set define '^' set verify off prompt ...wwv_flow_forms create or replace package body wwv_flow_forms wrapped 0 abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd 3 b 9200000 1 4 0 2d6 2 :e: 1PACKAGE: 1BODY: 1WWV_FLOW_FORMS: 1G_LIST_MGR_ELEMENT: 1NUMBER: 199: 1G_ITEM_FOUND: 1BOOLEAN: 1FALSE: 1L_ROW: 1VARCHAR2: 1200: 1L_COL: 1L_STR: 132767: 1FUNCTION: 1TD_ALIGNMENT: 1P_TEXT: 1I: 10: 1RETURN: 1=: 1LEFT: 1align="left": 1ELSIF: 1RIGHT: 1align="right": 1CENTER: 1align=center: 1LEFT-TOP: 1align="left" valign="top": 1RIGHT-TOP: 1align="right" valign="top": 1CENTER-TOP: 1align="center" valign="top": 1LEFT-BOTTOM: 1align="left" valign="bottom": 1RIGHT-BOTTOM: 1align="right" valign="bottom": 1CENTER-BOTTOM: 1align="center" valign="middle": 1LEFT-CENTER: 1align="left" valign="middle": 1RIGHT-CENTER: 1align="right" valign="middle": 1CENTER-CENTER: 1CURRENT_SUBS: 1P_I: 1INSTR: 1#CURRENT: 1WWV_FLOW: 1G_TRANSLATED_FLOW_ID: 1IS NULL: 1REPLACE: 1#CURRENT_FORM_ELEMENT#: 1G_CURRENT_FORM_ELEMENT: 1#CURRENT_ITEM_ID#: 1G_ITEM_ID: 1#CURRENT_ITEM_NAME#: 1G_ITEM_NAME: 1||: 1.: 1INCREMENT_ITEM_SEQUENCE: 1P_CURRENT_ITEM_SEQ_VALUE: 1G_CURRENT_ITEM_SEQUENCE: 1+: 11: 1DISPLAY_POSITIONAL_FORM: 1P_BOX_BORDER: 1P_CURRENT_PLUG_ID: 1L_DATE: 130: 1L_DATE_FORMAT: 1L_FETCHCNT: 1PLS_INTEGER: 1L_OK_TO_DISPLAY_ITEM: 1TRUE: 1L_ROW_IS_OPEN: 1L_CELL_IS_OPEN: 1L_CELL_EMITTED: 1L_VALUE: 1L_DISPLAY_VALUE: 1L_CACHE_VALUE: 1Q: 1L_LOV: 15000: 1L_CELL_ATTRIBUTES: 1L_HEIGHT: 1INT: 14: 1J: 1L_HIDDEN_SEQUENCE: 1L_TABLE_IS_OPEN: 1L_IMAGE: 1512: 1L_TIME_AND_DATE: 1L_CAL_WINDOW_HEIGHT: 1L_JSID: 1255: 1L_IMG_ALT_TEXT: 11000: 1L_FORMAT_MASK_USED: 1N: 1L_BUTTON_TEMPLATE_ID: 1L_OF: 1of: 1L_USE_P_ARGS_VALUE: 1G_PRINTER_FRIENDLY: 1NOT: 1NVL: 1HTP: 1PRN: 1PAINT_BUTTONS: 1P_POSITION: 1TOP: 1P_PLUG_ID: 1TOP_AND_BOTTOM: 1G_ITEMCNT: 1LOOP: 1G_I: 1!=: 1G_ITEM_PLUG_ID: 1G_ITEM_DISPLAY_WHEN_TYPE: 1IS NOT NULL: 1WWV_FLOW_CONDITIONS: 1STANDARD_CONDITION: 1P_CONDITION_TYPE: 1P_CONDITION: 1G_ITEM_DISPLAY_WHEN: 1P_CONDITION2: 1G_ITEM_DISPLAY_WHEN2: 1G_ITEM_READ_ONLY_WHEN_TYPE: 1%null%: 1G_ITEM_READ_ONLY_WHEN: 1G_ITEM_READ_ONLY_WHEN2: 1G_ITEM_DISPLAY_AS: 1LIKE: 1CHECKBOX%: 1RADIOGR%: 1G_ITEM_TAG_ATTRIBUTES: 1LTRIM: 1 disabled="disabled": 1TEXT_DISABLED%: 1COMBOBOX%: 1POPUP%: 1DISPLAY_AND_SAVE_LOV: 1LIST_MGR%: 1LIST_MGR_VIEW: 1MULTIPLESELECT%: 1DISPLAY_AND_SAVE: 1G_ITEM_CATTRIBUTES_ELEMENT: 1G_ITEM_READ_ONLY_DISP_ATTR: 1G_ITEM_SECURITY_SCHEME: 1PUBLIC_ROLE_CHECK: 1P_ROLE: 1G_FORM_PAINTED: 1P: 1WWV_FLOW_LANG: 1SYSTEM_MESSAGE: 1wwv_flow_forms.item_not_disp_err: 1x: 1HIDDEN: 1DEBUG: 1Item:: : 1 : 1: 1G_ITEM_PROMPT: 1": 1WWV_FLOW_RENDER_SHORTCUT: 1DO_SORTCUTS_EXIST: 1EXPAND_SHORTCUTS: 1&: 1DO_SUBSTITUTIONS: 1ESC: 1STOP_AND_START_HTML_TABLE: 1: 1: 1: 1: 1
: 1: 1G_ITEM_BEGIN_ON_NEW_LINE: 1YES: 1: 1: 1BUTTON: 1G_ITEM_LABEL_ALIGNMENT: 1G_ITEM_BEGIN_ON_NEW_FIELD: 1
: 1UPPER: 1SUBSTR: 1G_ITEM_LOV: 16: 1STATIC2: 1: 1(: 1WWV_FLOW_UTILITIES: 1GET_LOV_DELIMITERS: 1POPULATE_TEMP_LOV_TABLE: 1P_S: 1::: 1P_R: 1,: 1P_C: 1;: 17: 12: 1select disp, val from wwv_flow_lov_temp order by insert_order: 1select disp, val from wwv_flow_lov_temp order by disp: 122: 1PLSQL_OPTION_PROCEDURE: 116: 1PLSQL_EXPRESSION2: 1VALUEOF_VC: 117: 1select decode(lov_template,null,lov_disp_value,replace(lov_template,'#DISPLAY+ 1_VALUE#',lov_disp_value)) lov_disp_value, lov_return_value : 1 from wwv_flow_list_of_values_data : 1 where lov_id = : 1 and (required_patch is null : 1 or : 1 (required_patch > 0 and : 1 (wwv_flow_item.fetch_g_build_options_excluded is null or : 1 instr(wwv_flow_item.fetch_g_build_options_excluded,'::'||requir+ 1ed_patch||'::') = 0) : 1 ) : 1 (required_patch < 0 and : 1 (wwv_flow_item.fetch_g_build_options_included is null or : 1 instr(wwv_flow_item.fetch_g_build_options_included,'::'||(0-req+ 1uired_patch)||'::') = 0) : 1 ) : 1 and exists (select 1 from wwv_flow_lists_of_values$ where flow_id = ::flow_i+ 1d and id = : 1) : 1C9: 1LOV_DISP_COND_TYPE: 1LOV_DISP_COND: 1LOV_DISP_COND2: 1ID: 1WWV_FLOW_LIST_OF_VALUES_DATA: 1D: 1LOV_ID: 1TO_NUMBER: 1REQUIRED_PATCH: 1WWV_FLOW_META_DATA: 1G_BUILD_OPTIONS_EXCLUDED: 1G_BUILD_OPTIONS_INCLUDED: 1select LOV_DISP_COND_TYPE, LOV_DISP_COND, lov_disp_cond2, id:n + 1 from wwv_flow_list_of_values_data d:n where lov_id+ 1 = to_number(replace(wwv_flow.g_item_lov(i), '.' ,null)) :n + 1 and (required_patch is null:n or:n + 1 (required_patch > 0 and:n (wwv_flow_meta_dat+ 1a.g_build_options_excluded is null or:n instr(wwv_+ 1flow_meta_data.g_build_options_excluded,'::'||required_patch||'::') = 0):n + 1 ):n or:n (+ 1required_patch < 0 and:n (wwv_flow_meta_data.g_bui+ 1ld_options_included is null or:n instr(wwv_flow_me+ 1ta_data.g_build_options_included,'::'||(0-required_patch)||'::') = 0):n + 1 ):n ) + 1 :n : 1 and id != : 1 order by lov_disp_sequence, LOV_DISP_VALUE: 1#OWNER#: 1COMBOBOX: 1COMBOBOX_WITH_JS_REDIRECT: 1COMBOBOX_WITH_URL_REDIRECT: 1COMBOBOX_WITH_BRANCH_TO_PAGE: 1COMBOBOX_WITH_SUBMIT: 1COMBOBOX_WITH_JS_POST: 1SHOW_AS_DISPLAY_ONLY: 1P_LOV: 1P_VALUE: 1WWV_FLOW_HOT_HTTP_LINKS: 1[: 1P_ATTRIBUTES: 1]: 1begin : 113: 1#FLOW_OWNER#: 1G_FLOW_SCHEMA_OWNER: 1%NULL%: 1[ ]: 1WWV_HTP: 1FORMHIDDEN: 1p_arg_names: 1p_t: 1LPAD: 1FORMTEXT: 1CNAME: 1CSIZE: 1G_ITEM_CSIZE: 1CMAXLENGTH: 1G_ITEM_CMAXLENGTH: 1CATTRIBUTES: 1id=": 1CVALUE: 1TEXT_WITH_ENTER_SUBMIT: 1onKeyPress="return submitEnter(this,event)" id=": 1TEXT_DISABLED: 1TEXT_DISABLED_AND_SAVE: 1 readonly="readonly": 1TEXT_WITH_CALCULATOR: 1ANCHOR: 1javascript::calculatorPopUp_: 1(): 1IMG: 1G_IMAGE_PREFIX: 1calc.gif: 1height="20" width="15" border="0": 1WWV_CALCULATOR: 1DRAW: 1P_FIELD: 1document.wwv_flow.p_t: 1: 1IMAGE: 1border="0": 1P_TRANSLATION: 1G_ITEM_LOV_TRANSLATED: 1POPUP_FILTER: 1SHOW_AS_POPUP: 1P_NAME: 1P_WIDTH: 1P_MAX_LENGTH: 1P_FORM_INDEX: 1G_FORM_COUNT: 1P_ELEMENT_INDEX: 1TO_CHAR: 1P_FILTER_FIRST_FETCH: 1POPUP: 1POPUP_KEY_LOV: 1_HIDDENVALUE": 1GET_DISPLAY_VALUE_GIVEN_LOV: 1P_SQL_QUERY: 1P_RETURN_KEY: 1 disabled="disabled" onfocus="this.blur()": 1P_HIDDEN_ELEM_NAME: 1POPUP_KEY_LOV_NOFETCH: 1P_OK_TO_QUERY: 1NO: 1POPUP2: 1PICK_DATE_USING_APP_FORMAT_MASK: 1PICK_DATE_USING_FLOW_FORMAT_MASK: 1PICK_DATE_MON_YYYY: 1PICK_DATE_YYYY_MM_DD_SLASH: 1PICK_DATE_YYYY_MM_DD_HH_MI_SLASH: 1PICK_DATE_YYYY_MM_DD_HH24_MI_SLASH: 1PICK_DATE_YYYY_MM_DD: 1PICK_DATE_YYYY_MM_DD_HH_MI: 1PICK_DATE_YYYY_MM_DD_HH24_MI: 1PICK_DATE_YYYY_DD_MM_DOT: 1PICK_DATE_YYYY_DD_MM_HH_MI_DOT: 1PICK_DATE_YYYY_DD_MM_HH24_MI_DOT: 1PICK_DATE_RR_MON_DD: 1PICK_DATE_RR_MON_DD_HH_MI: 1PICK_DATE_RR_MON_DD_HH24_MI: 1PICK_DATE_MM_DD_YYYY: 1PICK_DATE_MM_DD_YYYY_HH_MI: 1PICK_DATE_MM_DD_YYYY_HH24_MI: 1PICK_DATE_DD_MON_YY: 1PICK_DATE_DD_MON_YY_HH_MI: 1PICK_DATE_DD_MON_YY_HH24_MI: 1PICK_DATE_DD_MON_YYYY: 1PICK_DATE_DD_MON_YYYY_HH_MI: 1PICK_DATE_DD_MON_YYYY_HH24_MI: 1PICK_DATE_DD_MON_RR: 1PICK_DATE_DD_MON_RR_HH_MI: 1PICK_DATE_DD_MON_RR_HH24_MI: 1PICK_DATE_DD_MM_YYYY_DOT: 1PICK_DATE_DD_MM_YYYY_HH_MI_DOT: 1PICK_DATE_DD_MM_YYYY_HH24_MI_DOT: 1PICK_DATE_DD_MM_YYYY_DASH: 1PICK_DATE_DD_MM_YYYY_HH_MI_DASH: 1PICK_DATE_DD_MM_YYYY_HH24_MI_DASH: 1PICK_DATE_DD_MM_YYYY: 1PICK_DATE_DD_MM_YYYY_HH_MI: 1PICK_DATE_DD_MM_YYYY_HH24_MI: 1 id=": 1HH24_MI: 1HH_MI: 1210: 1G_BROWSER_LANGUAGE: 1zh: 120: 1PICK_DATE_FORMAT_MASK: 1DD-MON-YY: 1SYSDATE: 1MMYYYYDDHH24MI: 1MMYYYYDDHHMIPM: 1MMYYYY: 1TO_DATE: 1OPEN_JAVASCRIPT: 1:n function genCal: 1_: 1():n {:n w = open(": 1wwv_flow_utilities.show_as_popup_calendar" +:n "?p_element_+ 1index=" + escape(': 1') +:n "&p_form_index=" + escape(': 1') +:n "&p_date_format=" + escape(': 1') +:n "&p_bgcolor=" + escape(': 1#666666: 1') +:n "&p_dd=" + escape(': 1') +:n "&p_hh=" + escape(': 19: 1') +:n "&p_mi=" + escape(': 111: 1') +:n "&p_pm=: 1ESCAPE_URL: 1" +:n "&p_yyyy=" + escape(': 13: 1') +:n "&p_lang=" + escape(': 1') +:n "&p_application_format=" + escape(': 1') +:n "&p_mm=" + escape(': 1'),:n "winLov",:n "Scrollbars=no,resizabl+ 1e=yes,width=258,height=: 1");:n if (w.opener == null):n w.opener = self;:n w.focus(+ 1);:n }: 1CLOSE_JAVASCRIPT: 1javascript::genCal: 1_p_t: 1: 1CHECKBOX: 1select null, 'YES' from dual: 1disabled="disabled": 1p_v: 1SHOW_AS_CHECKBOX: 1checkbox: 1P_COLS: 1G_ITEM_LOV_COLUMNS: 1STRING_TO_TABLE2: 1P_ATTRIBUTES2: 1G_ITEM_TAG_ATTRIBUTES2: 1P_ITEM_NAME: 1RAISE_APPLICATION_ERROR: 1-: 120001: 1wwv_flow_forms.combo_no_query_err: 1SHOW_AS_COMBOBOX: 1P_SHOW_NULL: 1G_ITEM_LOV_DISPLAY_NULL: 1P_NULL_TEXT: 1G_ITEM_LOV_NULL_TEXT: 1P_NULL_VALUE: 1G_ITEM_LOV_NULL_VALUE: 1P_SHOW_EXTRA: 1G_ITEM_LOV_DISPLAY_EXTRA: 1wwv_flow_forms.combo_js_no_query_err: 1P_ONCHANGE: 1location.href='f?p=: 1G_FLOW_ID: 1G_INSTANCE: 1::::NO::::: 1'+this.options[selectedIndex].value;: 1wwv_flow_forms.combo_url_err: 1location.href=this.options[selectedIndex].value;: 1wwv_flow_forms.combo_url_page_err: 1'+this.options[selectedIndex].value+'::: 1';: 1javascript::doSubmit(': 1');: 1MULTIPLESELECT: 1SHOW_AS_MULTIPLE_SELECT: 1P_HEIGHT: 1G_ITEM_CHEIGHT: 1RADIOGROUP: 1SHOW_AS_RADIO_GROUP: 1RADIOGROUP2: 1SHOW_AS_RADIO_GROUP2: 1RADIOGROUP_WITH_REDIRECT: 1'+this.value;: 1RADIOGROUP_WITH_JS_SUBMIT: 1RADIOGROUP_WITH_SUBMIT: 1'): 1TEXTAREA_WITH_CONTROLS: 1SHOW_AS_TEXTAREA_WITH_CONTROLS: 1P_SIZE: 1TEXTAREA_WITH_SPELL_CHECK: 1
: 1