-- пример для простого случая, когда нету build options и global app substitution strings
declare
    l_param_name  owa.vc_arr;
    l_param_val  owa.vc_arr;
begin
    apex_application.g_user := 'APEX_PUBLIC_USER';
    apex_util.set_security_group_id(p_security_group_id => apex_util.find_security_group_id(p_workspace => :workspace));
  
    htp.init;
    l_param_name(1) := 'REMOTE_ADDR';
    l_param_val(1) := '1.2.3.4';
    owa.init_cgi_env( 1, l_param_name, l_param_val );
  
    apex_custom_auth.login(
          p_uname => :dev_user,
          p_password => :dev_password,
          p_app_page => :app_page
    );
end;
/

begin
  apex_application.g_public_user := 'APEX_PUBLIC_USER';
  
  APEX_APPLICATION_INSTALL.GENERATE_OFFSET;
  APEX_APPLICATION_INSTALL.SET_APPLICATION_ID( :app );
  APEX_APPLICATION_INSTALL.SET_WORKSPACE_ID ( apex_util.find_security_group_id(:workspace) );
  APEX_APPLICATION_INSTALL.SET_APPLICATION_ALIAS( :alias );
end;
/

alter session set current_schema=APEX_040200;

declare
  l_clob clob;
  FB_FLOW_ID varchar2(32767) := :app;
  P2103_SS_PROMPTS varchar2(32767) := null;
  P2103_SS_VALUES varchar2(32767) := null;
begin
  select t.process_source into l_clob
  from apex_application_page_proc t
  where t.page_id = 2116
    and t.application_id = 4000
    and t.process_name = 'Install';
  
  l_clob := to_clob('begin ') || l_clob || to_clob(' end;');
  
  execute immediate l_clob
  using FB_FLOW_ID, P2103_SS_PROMPTS, P2103_SS_VALUES;
  
  commit;
end;
/