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 | : 1 |