set define '^' set verify off prompt ...wwv_flow create or replace package body wwv_flow wrapped 0 abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd 3 b 9200000 1 4 0 9b3 2 :e: 1PACKAGE: 1BODY: 1WWV_FLOW: 1OK_TO_REDIRECT_URLS: 1BOOLEAN: 1FALSE: 1OK_TO_TRACE: 1G_NAVIGATION_BAR: 1VARCHAR2: 132767: 1G_ITEM_FOUND: 1G_VPD_SET: 1L_LOGIN_COUNT: 1INT: 10: 1G_PASSED_THIS_VIEW: 14000: 1G_FAILED_THIS_VIEW: 1G_BUTTON_TEMPLATE_ID: 1NUMBER: 1G_SESSID_CREATE_ATTEMPTS: 1C_DEEP_LINK_ITEM: 1CONSTANT: 1FSP_AFTER_LOGIN_URL: 1L_PAGE_TEMPLATE: 1255: 1FUNCTION: 1REMOVE_SESSION_SUBS: 1P_STRING: 1RETURN: 1REPLACE: 1&SESSION.: 1&FLOW_SESSION.: 1&SESSION: 1&FLOW_SESSION: 1&APP_SESSION.: 1&APP_ALIAS.: 1G_FLOW_ID: 1GET_SGID: 1WWV_FLOW_SECURITY: 1G_SECURITY_GROUP_ID: 1CONVERT_PAGE_ALIAS_TO_ID: 1P_PAGE_ALIAS: 1P: 1C1: 1ID: 1WWV_FLOW_STEPS: 1FLOW_ID: 1ALIAS: 1UPPER: 1select id :n from wwv_flow_steps :n where flow_id+ 1 = wwv_flow.g_flow_id and:n alias = upper(p_page_alias): 1LOOP: 1GET_CURRENT_FLOW_SGID: 1P_FLOW_ID: 1P_COMPANY_ID: 1G_CURR_FLOW_SECURITY_GROUP_ID: 1IS NOT NULL: 1ELSIF: 14999: 110: 13000: 13999: 120: 15000: 18999: 1IS NULL: 1=: 18000: 1SECURITY_GROUP_ID: 1WWV_FLOWS: 1select security_group_id from wwv_flows where id = p_flow_id: 1CONVERT_FLOW_ALIAS_TO_ID: 1P_FLOW_ALIAS_OR_ID: 1P_SECURITY_GROUP_ID: 1L_FLOW_SGIDS: 1WWV_FLOW_GLOBAL: 1VC_ARR2: 1L_COMPANY: 1TO_NUMBER: 1OTHERS: 1select id from wwv_flows :n where alias = upper(p_flow_alias_+ 1or_id) :n and security_group_id = p_security_group_id: 1RAISE_APPLICATION_ERROR: 1-: 120001: 1WWV_FLOW_LANG: 1SYSTEM_MESSAGE: 1wwv_flow.cannot_determine_flow_err: 1BULK: 1COLLECT: 1SELECT security_group_id||'::'||id :n bulk collect into l_flow_s+ 1gids :n from wwv_flows :n where alias = upper(p_flow_alias_o+ 1r_id) :n order by security_group_id: 1COUNT: 11: 1SUBSTR: 1INSTR: 1::: 1+: 1>: 1FIND_SECURITY_GROUP_ID: 1P_COMPANY: 1WWV_FLOW_UTILITIES: 1GET_COMPANY_FROM_COOKIE: 1I: 1TO_CHAR: 1||: 1wwv_flow.alias_convert_err: 1HTF: 1ESCAPE_SC: 1wwv_flow.alias_exist_err: 1SHOW_ERROR_MESSAGE: 1P_MESSAGE: 1wwv_flow.alias_err: 1P_FOOTER: 1CONVERT_DISPLAY_ID_TO_FLOW_ID: 1P_DISPLAY_ID: 1SHOW_LOGIN_LINK: 1P_FLOW: 1P_PAGE: 1P_HOME: 1L_FLOW: 1L_PAGE: 13: 1wwv_flow.unable_home_err: 1development_service_home_login: 1SHOW_LOGIN_MESSAGE: 1wwv_flow.not_logged_in: 1wwv_flow.click_to_login: 1err7372: 1SET_G_BOOLEAN: 1P_FUNCTION_RET_BOOLEAN: 1G_LAST_QUERY_TEXT: 1TRIM_SQL: 1P_SQL: 1CHR: 113: 1 : 1#OWNER#: 1G_FLOW_OWNER: 1P_ENDS_IN_SEMICOLON: 1TRUE: 1P_DO_SUBSTITUTIONS: 1WWV_EXECUTE_IMMEDIATE: 1RUN_BLOCK: 1declare function x return boolean is begin : 1 end; begin wwv_flow.g_boolean ::= x; end;: 1P_USER: 1G_PARSE_AS_SCHEMA: 1ADJUST_PAGINATION_GLOBALS: 1G_REQUEST: 1FLOW_PREVIOUS_PAGE: 1G_FLOW_CURRENT_MIN_ROW: 1G_FLOW_CURRENT_MAX_ROWS: 1FLOW_NEXT_PAGE: 1PAINT_FORMOPEN: 1L_ENCTYPE: 1L_STR: 1WWV_SEQ: 1NEXTVAL: 1G_UNIQUE_PAGE_ID: 1DUAL: 1SELECT wwv_seq.nextval into g_unique_page_id from dual: 1G_ITEM_DISPLAY_AS: 1FILE: 1enctype="multipart/form-data": 1EXIT: 1G_FORM_PAINTED: 1
: 1 : 1 : 1 : 1 : 1G_DEBUG: 1: 1: 1RTRIM: 1DO_SUBSTITUTIONS: 1;: 1TAB_TITLE: 1P_TEXT: 1G_BODY_TITLE: 1#BODY_TITLE#: 1PAINT_TRAILING_JAVASCRIPT: 1L_COMMA: 1CHAR: 1G_SPELL_CHECK_REQUIRED: 1WWV_SPELING: 1INIT_PAGE: 1HTP: 1: 1GET_NEXT_SESSION_ID_SEQ: 1DES_KEY: 1RAW: 124: 1DBMS_OBFUSCATION_TOOLKIT: 1DESGETKEY: 1SEED: 1UTL_RAW: 1CAST_TO_RAW: 1RPAD: 1WWV_FLOW_ELEMENT: 1G_ELEMENT: 180: 1RAWTOHEX: 1X: 1LENGTH: 1CREATE_NEW_FLOW_SESSION: 1WWV_FLOW_SESSIONS$: 1ON_NEW_INSTANCE_FIRED_FOR: 1INSERT into wwv_flow_sessions$ :n ( id, on_new_instance_fired_for ) :n + 1 values :n ( g_instance, g_flow_id ): 1DEBUG: 1New session created:: : 1COMMIT: 1DUP_VAL_ON_INDEX: 1<: 14: 1wwv_flow.create_session_err: 1SQLERRM: 1G_UNRECOVERABLE_ERROR: 1CREATE_NEW_FLOW_SESSION2: 1COOKIE: 1NVL: 1G_USER: 1INSERT into wwv_flow_sessions$ :n ( id, on_new_instance_fired_for, cook+ 1ie ) :n values :n ( g_instance, null, nvl(g_user,'nobody') ): 1Session created:: : 1 user::: 1nobody: 1FIND_NEXT_UNUSED_INSTANCE_ID: 1L_INSTANCE_EXISTS: 1L_INSTANCE: 1select 1 from wwv_flow_sessions$ where id = nvl(l_instance,-123): 1WHILE: 1C2: 1REWRITE_QUERY_STRING: 1L_FLOW_ID: 1100: 1L_PAGE_ID: 1L_SESS_ID: 1L_REMAINDER: 11000: 1L_QUERY_STRING: 1L_NEW_REQUEST: 1L_REQUEST: 1GET_CGI_QUERY_STRING_DECODED: 1PARSE_QUERY_STRING: 1::::: 1REPLACE_CGI_ENV: 1P_IN: 1P_OUT: 1&CGI_REQUEST_PROTOCOL.: 1&CGI_REQUEST_PROTOCOL: 1OWA_UTIL: 1GET_CGI_ENV: 1REQUEST_PROTOCOL: 1&CGI_HTTP_HOST.: 1&CGI_HTTP_HOST: 1HTTP_HOST: 1&CGI_DAD_NAME.: 1&CGI_DAD_NAME: 1DAD_NAME: 1&CGI_SCRIPT_NAME.: 1&CGI_SCRIPT_NAME: 1SCRIPT_NAME: 1&CGI_SERVER_NAME.: 1&CGI_SERVER_NAME: 1SERVER_NAME: 1&CGI_SERVER_PORT.: 1&CGI_SERVER_PORT: 1SERVER_PORT: 1REMOVE_SESSION_DATA: 1P_SESSION: 1P_ITEM_ID: 1WWV_FLOW_DATA: 1FLOW_INSTANCE: 1ITEM_ID: 1DELETE :n from wwv_flow_data :n where flow_instance = g_instance and+ 1 :n item_id = p_item_id: 1UPDATE_SUBSTITUTION_CACHE: 1P_ID: 1P_VALUE: 1G_SUBSTITUTION_ITEM_ID: 1G_SUBSTITUTION_ITEM_VALUE: 1wwv_flow.update_sub_err: 1GET_ITEM_PROPS: 1P_NAME: 1OUT: 1P_PROTECTION_LEVEL: 1PLS_INTEGER: 1P_ESCAPE_ON_HTTP_INPUT: 1MAX: 1DECODE: 1PROTECTION_LEVEL: 1ESCAPE_ON_HTTP_INPUT: 1WWV_FLOW_STEP_ITEMS: 1FLOW_STEP_ID: 1NAME: 1SELECT max(id), max(decode(nvl(protection_level,'N'),'N',0,'B',1,'P',2,'S',3,+ 1'I',4)), max(nvl(escape_on_http_input,'Y')):n into p_id, p_protectio+ 1n_level, p_escape_on_http_input:n from wwv_flow_step_items:n + 1where flow_id = g_flow_id and :n flow_step_id = g_flow_step_id+ 1 and :n name = p_name: 1WWV_FLOW_ITEMS: 1SELECT max(id), max(decode(nvl(protection_level,'N'),'N',0,'B',1,'P',2,'S',3,+ 1'I',4)), max('Y'):n into p_id, p_protection_level, p_escape_on_h+ 1ttp_input:n from wwv_flow_items:n where flow_id = g_+ 1flow_id and:n name = p_name: 1SELECT max(id), max(decode(nvl(protection_level,'N'),'N',0,'B',1,'P',2,'S',3,+ 1'I',4)), max(nvl(escape_on_http_input,'Y')):n into p_id, p_prote+ 1ction_level, p_escape_on_http_input:n from wwv_flow_step_items:n+ 1 where flow_id = g_flow_id and :n name = p_name: 1WWV_FLOW_ID: 1NEXT_VAL: 1WWV_FLOW_API: 1CREATE_FLOW_ITEM: 1P_DATA_TYPE: 1VARCHAR: 1P_IS_PERSISTENT: 1Y: 1P_ITEM_COMMENT: 1Used by Custom2 authentication for deep linking support: 1wwv_flow.find_item_id_err: 1wwv_flow.find_item_id_err2: 1SAVE_IN_SUBSTITUTION_CACHE: 1J: 1L_ITEM_ID: 1L_DUMMY: 1L_ESCAPE_ON_HTTP_INPUT: 1G_SUBSTITUTION_ITEM_NAME: 1NOT: 1G_SUBSTITUTION_ITEM_FILTER: 1SAVE: 1P_ITEM_VALUE: 1P_ITEM_NAME: 1P_EXTERNAL_INPUT: 1L_ID: 1L_ELEMENT_ID: 1L_COUNT: 1L_SAME: 1L_PAGE_ITEM_FOUND: 1L_DATA_TYPE: 130: 1L_ITEM_NAME: 1L_VALUE: 1L_PROTECTION_LEVEL: 1L_ITEM_FILTER: 1FIND_ITEM_NAME: 1ITEM_VALUE: 1select item_value :n from wwv_flow_data :n where flow_inst+ 1ance = g_instance and item_id = p_item_id: 1&6dk*yY: 1...: 1 session state saving same value:: ": 1": 1IS_PERSISTENT: 1DISPLAY_AS: 1DATA_TYPE: 1select is_persistent, display_as, data_type, escape_on_http_input:n + 1 from wwv_flow_step_items :n where id = p_item_i+ 1d: 1!=: 1DISPLAY_ONLY_HTML: 1U: 1WWV_FLOW_PREFERENCES: 1SET_PREFERENCE: 1P_PREFERENCE: 1PERSISTENT_ITEM_: 1select data_type:n from wwv_flow_items :n + 1 where id = p_item_id: 1wwv_flow.save_routine_numeric_err: 1P0: 1ITEM_ELEMENT_ID: 1ITEM_NAME: 1SESSION_STATE_STATUS: 1ITEM_FILTER: 1INSERT into wwv_flow_data (:n flow_instance,:n + 1item_id,:n item_element_id,:n item_name,:n + 1 item_value,:n session_state_status,:n + 1 flow_id,:n item_filter:n ) values (:n + 1 g_instance,:n p_item_id,:n l_element_id,:n + 1 l_item_name,:n l_value,:n 'I',:n+ 1 wwv_flow.g_flow_id,:n l_item_filter:n + 1 ): 1Saved session state:: : 1 ": 1" newValue=": 1 "escape_on_input=": 1UPDATE wwv_flow_data:n set item_value = l_value,+ 1:n session_state_status = decode(session_state_status,'+ 1R','I','U'):n where flow_instance = g_instance and + 1:n item_element_id = l_element_id and :n + 1 item_id = p_item_id: 1" changedValue=": 1ROLLBACK: 1wwv_flow.session_info_err: 1wwv_flow.save_routine_err: 1UPDATE_SESSION_SET_COOKIE: 1TRUNC: 1UPDATE wwv_flow_sessions$:n set cookie = g_user, :n id =+ 1 trunc(id):n where id = p_session: 1UPDATE_CACHE_WITH_WRITE: 1FIND_ITEM_ID: 1FLOW_ITEM_EXISTS: 1SELECT max(id):n into l_id:n from wwv_flow_items:n w+ 1here flow_id = nvl(g_flow_id,-123) and:n name = p_name: 1REMEMBER_DEEP_LINK: 1P_URL: 1wwv_flow.deeplinking_err: 1FETCH_ITEM: 1FETCH_VALUE: 1wwv_flow.fetch_value_err: 1select item_value, item_element_id:n from wwv_flow_data:n where+ 1 flow_instance = g_instance and :n item_id = l_item_id :n+ 1 order by item_element_id: 1FETCH_FLOW_ITEM: 1P_ITEM: 1P_INSTANCE: 1L_OWNER: 1256: 1L_NAME: 1L_LINENO: 1L_CALLER_T: 1L_SGID: 1WHO_CALLED_ME: 1OWNER: 1LINENO: 1CALLER_T: 1WWV_FLOW_COMPANY_SCHEMAS: 1SCHEMA: 1select security_group_id :n from wwv_flow_company_schemas where sc+ 1hema=l_owner: 1A: 1B: 1select item_value:n from wwv_flow_data a,wwv_flow_items b:n whe+ 1re a.flow_instance = l_instance:n and a.flow_id = l_flow_id:n a+ 1nd b.security_group_id = l_sgid:n and a.item_id = b.id:n and b.+ 1name=p_item: 1FETCH_APP_ITEM: 1P_APP: 1SELECT max(id):n into l_id:n from wwv_flow_step_items:n + 1 where flow_id = g_flow_id and :n flow_step_id = g_flow_ste+ 1p_id and :n name = p_name: 1SELECT max(id):n into l_id:n from wwv_flow_items:n w+ 1here flow_id = g_flow_id and:n name = p_name: 1SELECT max(id):n into l_id:n from wwv_flow_step_items:n + 1 where flow_id = g_flow_id and :n name = p_name: 1SELECT max(name):n into l_name:n from wwv_flow_step_items:n wher+ 1e flow_id = g_flow_id and:n flow_step_id = g_flow_step_id and:n + 1 id = p_id: 1SELECT max(name):n into l_name:n from wwv_flow_items:n + 1 where flow_id = g_flow_id and:n id = p_id: 1SELECT max(name):n into l_name:n from wwv_flow_step_items:n+ 1 where flow_id = g_flow_id and:n id = p_id: 1wwv_flow.find_item_err: 1wwv_flow.unexpected_err: 1wwv_flow.find_item_err2: 1SET_FAILED_SEC_CHECK: 1P_FAILED_SEC_CHECK: 1FAILED_SEC_CHECKS: 1UPDATE wwv_flow_sessions$:n set failed_sec_checks = p_failed_sec_check:n + 1 where id = p_session: 1SET_PASSED_SEC_CHECK: 1P_PASSED_SEC_CHECKS: 1PASSED_SEC_CHECKS: 1UPDATE wwv_flow_sessions$ :n set passed_sec_checks = p_passed_sec_checks:n+ 1 where id = p_session: 1ROLE_CHECK: 1P_ROLE: 1P_OWNER: 1P_COMPONENT: 1IN_LIST: 1L_ROLES: 1L_FETCHCNT: 1INTEGER: 1L_ROLE: 12000: 1L_REVERSE_AUTHORIZATION_CHECK: 1DISP_ERROR: 1P_QUERY: 1P_ERROR: 1wwv_flow.auth_scheme_err: 1DISP_FAIL_FOR_PAGE_OR_FLOW: 1P_ERROR_MSG: 1P_SUCCESS: 1L_COMPONENT: 1XOR: 1x: 1PAGE: 1FLOW: 14350_APPLICATION: 1wwv_flow.access_denied: 1CACHE_FAILED_SECURITY_CHECK: 1G_SEC_CHECKS_FAILED: 1CACHE_PASS_SECURITY_CHECK: 1G_SEC_CHECKS_PASSED: 1CHECK_FOR_FAILED_SEC_CHECK: 1CHECK_FOR_CACHED_SEC_CHECK: 1AUTH_CHECK_EVAL: 1!: 12: 1MUST_NOT_BE_PUBLIC_USER: 1PUBLIC_USER: 1G_PUBLIC_USER: 1HTMLDB_PUBLIC_USER: 1ANONYMOUS: 15: 1FLOW::: 1FLOW:: EDIT: 1DEVELOPER_ROLE: 1WWV_FLOW_DEVELOPERS: 1USERID: 1V: 1select developer_role:n from wwv_flow_developers:n + 1 where userid = g_user and :n security_group_id = wwv_f+ 1low_security.g_security_group_id and:n security_group_id + 1= (select decode(v('FB_FLOW_ID'),null,wwv_flow_security.g_security_group_id,+ 1:n (select security_group_id from wwv_flows where id=+ 1v('FB_FLOW_ID'))) from dual):n and:n + 1instr(developer_role,'EDIT') > 0 and:n (flow_id = v('FB_F+ 1LOW_ID') or flow_id is null) : 1STRING_TO_TABLE2: 1LTRIM: 16: 1: 1select developer_role:n from wwv_flow_developers:n where + 1 userid = g_user and :n security_group_id = wwv_flow_security+ 1.g_security_group_id: 1SCHEME_TYPE: 1SCHEME: 1SCHEME_TEXT: 1ERROR_MESSAGE: 1CACHING: 1WWV_FLOW_SECURITY_SCHEMES: 1select id, name, scheme_type, scheme, scheme_text, error_message, nvl(caching+ 1,'BY_USER_BY_SESSION') caching:n from wwv_flow_security_schemes+ 1:n where flow_id = g_flow_id and id = to_number(l_role) : 1BY_USER_BY_PAGE_VIEW: 1EXISTS: 1NOT_EXISTS: 1COUNTEM: 1select count(*) from dual where exists (: 1): 1BY_USER_BY_SESSION: 1FUNCTION_RETURNING_BOOLEAN: 1G_BOOLEAN: 1VAL_OF_ITEM_IN_COND_EQ_COND_TEXT: 1Mjhakb: 1mjHbka: 1VAL_OF_ITEM_IN_COND_NOT_EQ_COND_TEXT: 1ITEM_IS_NULL: 1%null%: 1ITEM_IS_NOT_NULL: 1PREFERENCE_EQ_COND_TEXT: 1GET_PREFERENCE: 1mHjjrk: 1PREFERENCE_NOT_EQ_COND_TEXT: 1PUBLIC_ROLE_CHECK: 1PUBLIC_SECURITY_CHECK: 1P_SECURITY_SCHEME: 1C_ID: 1select id from wwv_flow_security_schemes where flow_id = g_flow_id and name =+ 1 p_security_scheme: 1DRAW_BODY_OPEN: 1P_TITLE: 1P_WIDTH: 1100%: 1P_BOX_BORDER: 1P1: 1T: 1L_CURRENT_TABSET: 1L_PARENT_TABSET: 1L_OK_TO_DISPLAY_TAB: 1L_TAB_EDIT_LINK: 1L_IMAGE_PREFIX: 1G_PRINTER_FRIENDLY: 1WWV_FLOW_TEMPLATES_UTIL: 1FETCH_TAB_INFO: 1GET_TEMPLATE_ID: 1G_PRINTER_FRIENDLY_TEMPLATE: 1G_DEFAULT_PAGE_TEMPLATE: 1PAINT_BUTTONS: 1P_POSITION: 1LEFT_OF_TITLE: 1P_PLUG_ID: 1RIGHT_OF_TITLE: 1G_TABCNT: 1G_TAB_PARENT_TABSET: 1G_TAB_PLSQL_CONDITION_TYPE: 1WWV_FLOW_CONDITIONS: 1STANDARD_CONDITION: 1P_CONDITION_TYPE: 1P_CONDITION: 1G_TAB_PLSQL_CONDITION: 1P_CONDITION2: 1G_TAB_DISP_COND_TEXT: 1G_TAB_SECURITY_SCHEME: 1tab: 1G_TAB_TEXT: 1 : 1G_EDIT_COOKIE_SESSION_ID: 1G_FLOW_STATUS: 1AVAILABLE_W_EDIT_LINK: 1G_BUILD_STATUS: 1RUN_AND_BUILD: 1:
1: 1G_TAB_IMAGE: 1LOWER: 1http: 1//: 1G_TAB_STEP: 1G_TAB_ALSO_CURRENT_FOR_PAGES: 1G_TAB_SET: 1G_CURRENT_TAB: 1#TAB_TEXT#: 1G_CURRENT_IMAGE_TAB: 1#TAB_IMAGE#: 1: 1#TAB_INLINE_EDIT#: 1#TAB_FONT_ATTRIBUTES#: 1G_CURRENT_TAB_FONT_ATTR: 1#TAB_LINK#: 1javascript::doSubmit(': 1G_TAB_NAME: 1#TAB_NAME#: 1#TAB_NAME_ENCODED#: 1URL_ENCODE2: 1#TAB_LABEL#: 1IMG: 1: 1G_NON_CURRENT_TAB: 1TABLEDATA: 1f_spacer.gif: 1CATTRIBUTES: 1height="1" width="1" border="0": 1width="1%": 1G_NON_CURRENT_IMAGE_TAB: 1G_ITEMCNT: 1: 1G_TAB_NON_CURRENT_IMAGE: 1" border="0" />: 1: 1');">: 1EMPTY_VC_ARR: 1FETCH_TOPLEVEL_TAB_INFO: 1G_TAB_PARENT_DISPLAY_COND_TY: 1G_TAB_PARENT_DISPLAY_COND: 1G_TAB_PARENT_DISPLAY_COND2: 1G_TAB_PARENT_SECURITY_SCHEME: 1parenttab: 1" href="javascript::popupURL('f?p=4000::387::: 1::::::::P387_ID,FB_FLOW_ID,FB_FLOW_PAGE_ID::: 1G_TAB_PARENT_ID: 1G_TAB_CURRENT_ON_TABSET: 1G_CURRENT_PARENT_TAB_TEXT: 1G_TOP_CURRENT_TAB: 1PREPARE_URL: 1G_TAB_TARGET: 1G_TOP_NON_CURR_TAB: 1G_TOP_NON_CURR_TAB_FONT_ATTR: 1G_TOP_CURRENT_TAB_FONT_ATTR: 1: 1">: 1NOTIFICATION: 1#NOTIFICATION_MESSAGE#: 1G_NOTIFICATION_MESSAGE: 1#GLOBAL_NOTIFICATION#: 1G_GLOBAL_NOTIFICATION: 1G_PRINT_SUCCESS_MESSAGE: 1#SUCCESS_MESSAGE#: 1G_TEMPLATE_SUCCESS_MESSAGE: 1P_SUB_TYPE: 1ESC: 1#BOX_BODY#: 1DRAW_ICON_NAVIGATION_BAR: 1L_OK_TO_SHOW_ICON: 1L_BARCNT: 1L_INLINE_EDIT_LINK: 1L_NAVBAR_SHOWN: 1L_SHOW_HTML_TABLE_MARKUP: 1CELL: 1P_TARGET: 1P_IMAGE: 1P_SUBTEXT: 1P_ALT: 1P_HEIGHT: 1P_LOV: 1P_LOV_TYPE: 1P_LOV_NAME: 1P_ICON_COLSPAN: 1P_CELL_BGCOLOR: 1#CCCCCC: 1P_ONCLICK: 1L_TARGET: 1L_IMAGE_SIZE: 1300: 1L_SUBTEXT: 1L_ONCLICK: 1L_IMAGE: 1512: 1 onclick=": 1G_VALUE: 1 width=": 1 height=": 1TEXT: 1
: 1#: 1W: 1C: 1G_COMPANY_IMAGES: 1#WORKSPACE_IMAGES#: 1#COMPANY_IMAGES#: 1G_FLOW_IMAGES: 1#APP_IMAGES: 1#FLOW_IMAGES: 1#FLOW_IMAGES#: 1: 1: 1)">: 1 alt=": 1 border="0" : 1G_BUTTON_IMAGE_ATTRIBUTES: 1 id="IMAGE_FNP_: 1">: 1 id="IMAGE_FPP_: 1alt=": 1" href="javascript::popupURL('f?p=4000::381::: 1::::::381::P381_ID,FB_FLOW_ID,FB_FLOW_PAGE_ID::: 1G_BUTTON_ID: 1G_BUTTON_POSITION: 1TEMPLATE_DEFAULT: 1G_DEFAULT_BUTTON_POSITION: 1TOP_AND_BOTTOM: 1ABOVE_BOX: 1BELOW_BOX: 1G_BUTTONCNT: 115: 1REGION_TEMPLATE: 1G_BUTTON_ALIGNMENT: 1RIGHT: 1LEFT: 1: 1
: 1: 1
: 1DO_PROCESS: 1L_OK_TO_PROCESS: 1L_PROCESS_VALUES: 1L_WEBSERVICE_IDS: 1L_UPDATABLE_REGION_ID: 1L_ALLOWED_ACTIONS: 150: 1L_DML_FETCH_MODE: 1L_PROCESS_FOUND: 1L_MIN_ROW: 1L_MAX_ROW: 1L_TOTAL_ROWS: 1L_ADD_ROWS: 1L_HAS_STATE: 1Processing point:: : 1G_IN_PROCESS: 1G_PROCESS_SQL: 1G_PROCESS_POINT: 1G_PROCESS_IS_STATEFUL_Y_N: 1PROCESS_STATE: 1P_PROCESS_ID: 1G_PROCESS_ID: 1 (identified to run once per session) has been run, and will not be run for t+ 1his page view.: 1G_PROCESS_WHEN_BUTTON_ID: 1AFTER_SUBMIT: 1ON_SUBMIT_BEFORE_COMPUTATION: 1BUTTON_NAME: 1WWV_FLOW_STEP_BUTTONS: 1select button_name :n from wwv_flow_step_buttons :n+ 1 where id = to_number(g_process_when_button_id(i)): 1mJh: 1SOURCE: 1select name button_name:n from WWV_FLOW_STEP_ITEMS:n+ 1 where flow_step_id = g_flow_step_id and :n + 1 flow_id = g_flow_id and :n + 1 display_as = 'BUTTON' and:n nvl(source,'oOh') + 1= nvl(wwv_flow.g_request,'mJh') and:n id = to_n+ 1umber(g_process_when_button_id(i)):n : 1Item button ": 1" pressed process.: 1G_PROCESS_SECURITY_SCHEME: 1PROCESS: 1G_INLINE_VALIDATION_ERROR_CNT: 1......do not perform process because inline validation condition found.: 1G_PROCESS_WHEN_TYPE: 1G_PROCESS_WHEN: 1G_PROCESS_WHEN2: 13900: 1PROCESS_SQL_CLOB: 1WWV_FLOW_STEP_PROCESSING: 1G_TRANSLATED_FLOW_ID: 1G_TRANSLATED_PAGE_ID: 1select process_sql_clob :n from wwv_flow_step_+ 1processing :n where flow_id = nvl(g_translated_f+ 1low_id,g_flow_id) and flow_step_id = nvl(g_translated_page_id,g_flow_step_id)+ 1 and:n id = g_process_id(i) : 1WWV_FLOW_PROCESSING: 1select process_sql_clob:n from wwv_flow_proc+ 1essing:n where flow_id = nvl(g_translated_fl+ 1ow_id,g_flow_id):n and id = g_process_id(i) : 1G_PROCESS_TYPE: 1 (: 1) : 1PLSQL: 1G_PROCESS_SUCCESS_MESSAGE: 1G_PROCESS_ERROR_MESSAGE: 1#SQLERRM_TEXT#: 1#SQLERRM#: 1PLSQL_DBMS_JOB: 1G_JOB: 1WWV_FLOW_PLSQL_JOB: 1SUBMIT_PROCESS: 1P_STATUS: 1PENDING: 1SET_ITEM_USING_STATIC_ASSIGNMENT: 1......performing static assignment of : 1G_PROCESS_ITEM_NAME: 1SET_ITEM_USING_PLSQL_FUNCTION_BODY: 1......performing PLSQL function body assignment of : 1G_COMPUTATION_RESULT_VC: 1declare function x return varchar2 is begin : 1 return null; end; begin wwv_flow.g_computation_result_vc ::= x; end;: 1SET_ITEM_USING_SQL_EXPRESSION: 1SET_ITEM_USING_PLSQL_EXPRESSION: 1......performing PLSQL expression asignment of : 1begin wwv_flow.g_computation_result_vc ::= : 1SET_ITEM_USING_SQL_QUERY: 1......performing SQL query asignment of : 1SELECT_VC: 1NO_DATA_FOUND: 1INITIALIZE_PAGINATION_FOR_ALL_PAGES: 1......initializing pagination for all pages: 1select id :n from wwv_flow_steps :n + 1 where flow_id = wwv_flow.g_flow_id: 1RESET_PAGINATION_BY_PAGE: 1P_PAGE_ID: 1INITIALIZE_PAGE_PAGINATION: 1......initializing pagination for comma delimited list of pages: 1RESET_PAGINATION: 1RESET_REGION_PAGINATION: 1RESET_SESSION_STATE: 1CLEAR_USER_CACHE: 1CLEAR_CACHE_CURRENT_FLOW: 1CLEAR_FLOW_CACHE: 1CLEAR_CACHE_FOR_FLOWS: 1......clearing cache for application: 1RESET_USER_PREFERENCES: 1REMOVE_PREFERENCES: 1ADD_ROWS_TO_TABULAR_FORM: 1C_UR: 1WWV_FLOW_PAGE_PLUGS: 1PLUG_SOURCE_TYPE: 1PAGE_ID: 1select id :n from wwv_flow_page_plugs :n + 1 where flow_id = wwv_flow.g_flow_id and:n + 1 PLUG_SOURCE_TYPE in ('UPDATABLE_SQL_QUERY','UPDATEABLE_SQL_QUE+ 1RY') and:n page_id = wwv_flow.g_flow_step_id: 1IS_NUMERIC: 1NO_UPDATEABLE_REPORT_FOUND: 1GET_PAGINATION_DATA: 1*: 1>=: 1SET_PAGINATION_DATA: 1P_REGION_ID: 1P_MIN_ROW: 1P_ADD_ROWS: 1Error in add row internal routine:: : 1Error in region query:: : 1MULTI_ROW_UPDATE: 1WWV_FLOW_ITEM: 1P_MRU_STRING: 1Error in mru internal routine:: : 1G_MRU_COUNT: 1G_MRI_COUNT: 1#MRU_COUNT#: 1#MRI_COUNT#: 1MULTI_ROW_DELETE: 1#MRD_COUNT#: 1G_MRD_COUNT: 1CLEAR_CACHE_FOR_PAGES: 1NULL_STEP_CACHE: 1CLEAR_CACHE_FOR_ITEMS: 1SET_PREFERENCE_TO_ITEM_VALUE: 1SET_PREFERENCE_TO_ITEM_VALUE_IF_ITEM_NOT_NULL: 1DML_FETCH_ROW: 1F|: 1SET_MEMORY_CACHE_ON_FETCH: 1FETCH_ROW: 1P_TABLE_OWNER: 1P_TABLE_NAME: 1P_ROWID: 1P_ALT_ROWID: 1P_ROWID2: 1P_ALT_ROWID2: 1P_DML_FETCH_MODE: 1WEB_SERVICE: 1STRING_TO_TABLE: 1begin wwv_flow_web_services.make_request(: 1); end;: 1begin wwv_flow.g_value ::= wwv_flow_web_services.get_last_error_message; end;: 1Web Service:: ": 1DML_PROCESS_ROW: 1|: 1P_ACTION: 1P_ALLOWED_ACTIONS: 1P_RETURN_ITEM1_NAME: 1G_PROC_RETURN_KEY_INTO_ITEM1: 1P_RETURN_ITEM2_NAME: 1G_PROC_RETURN_KEY_INTO_ITEM2: 1DML_PROCESS_DELETE_ROW: 1DELETE: 1DML_PROCESS_UPDATE_ROW: 1UPDATE: 1DML_PROCESS_INSERT_ROW: 1INSERT: 1ON_DEMAND: 1select process_sql_clob:n from wwv_flow_process+ 1ing:n where id = g_process_sql(i): 1INITIALIZE_ALL_PAGE_ITEMS: 1D: 1select flow_id, flow_step_id, id, name :n from + 1wwv_flow_step_items:n where flow_id = wwv_flow.+ 1g_flow_id:n minus:n + 1 select d.flow_id flow_id, i.flow_step_id flow_step_id, d.item_id id, i.nam+ 1e:n from wwv_flow_data d, wwv_flow_step_items i+ 1:n where d.item_id = i.id:n + 1 and d.flow_instance = wwv_flow.g_instance:n + 1 and d.flow_id = wwv_flow.g_flow_id:n : 1INSERT into wwv_flow_data(:n flow_instance,:n + 1 item_id,:n item_name,:n + 1 item_value,:n SESSION_STATE_STA+ 1TUS,:n flow_id):n values (:n+ 1 wwv_flow.g_instance,:n c+ 11.id,:n c1.name,:n null,+ 1:n 'I',:n c1.flow_id): 1GET_NEXT_OR_PREV_PK: 1WWV_FLOW_FORM_CONTROL: 1GET_NEXT_OR_PREV_INFO: 1P_PROCESS_SQL: 1CLOSE_WINDOW: 1HTMLOPEN: 1