set define '^' set verify off prompt ...wwv_flow_utilities create or replace package body wwv_flow_utilities wrapped 0 abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd 3 b 9200000 1 4 0 805 2 :e: 1PACKAGE: 1BODY: 1WWV_FLOW_UTILITIES: 1MAX_ROWS_PER_PAGE: 1PLS_INTEGER: 110: 1G_CURSOR: 1NUMBER: 1G_SHOW_NULL: 1BOOLEAN: 1G_PARSE_MESSAGE: 1VARCHAR2: 132767: 1G_FIND_MESSAGE: 1G_LOV_TYPE: 1200: 1G_USER_OR_SYSTEM: 11: 1G_STATIC_LIST_IDX: 1G_STATIC_DISPLAYS: 1WWV_FLOW_GLOBAL: 1VC_ARR2: 1EMPTY_VC_ARR: 1G_STATIC_VALUES: 1G_LOV_DISPLAY: 1G_LOV_VALUE: 1G_STMT: 1G_POPUP_TEMPLATE_FETCHED: 1FALSE: 1G_POPUP_ICON: 14000: 1WWV_FLOW: 1G_IMAGE_PREFIX: 1||: 1list.gif: 1G_POPUP_ICON_ATTR: 1width="13" height="13": 1G_PAGE_NAME: 1255: 1winlov: 1G_PAGE_TITLE: 1Search Dialog: 1G_PAGE_HTML_HEAD: 1: 1G_PAGE_BODY_ATTR: 1bgcolor="white" OnLoad="first_field()": 1G_BEFORE_FIELD_TEXT: 1Enter case insensitive search criterion.
: 1G_PAGE_HEADING_TEXT: 1G_PAGE_FOOTER_TEXT: 1G_FILTER_WIDTH: 114: 1G_FILTER_MAX_WIDTH: 1G_FILTER_TEXT_ATTR: 1G_FIND_BUTTON_TEXT: 1Find...: 1G_FIND_BUTTON_IMAGE: 1G_FIND_BUTTON_ATTR: 1: 1G_CLOSE_BUTTON_TEXT: 1Close: 1G_CLOSE_BUTTON_IMAGE: 1G_CLOSE_BUTTON_ATTR: 1G_NEXT_BUTTON_TEXT: 1Next: 1G_NEXT_BUTTON_IMAGE: 1G_NEXT_BUTTON_ATTR: 1G_PREV_BUTTON_TEXT: 1Previous: 1G_PREV_BUTTON_IMAGE: 1G_PREV_BUTTON_ATTR: 1G_AFTER_FIELD_TEXT: 1G_SCROLLBARS: 1G_RESIZABLE: 1G_WIDTH: 1400: 1G_HEIGHT: 1450: 1G_RESULT_ROW_X_OF_Y: 1G_BEFORE_RESULT_SET: 1G_AFTER_RESULT_SET: 1G_FILTER_ESCAPE_PRINTED: 1G_MAX_ID_LEN: 150: 1G_VALIDCHARS: 1ABCDEFGHIJKLMNOPQRSTUVWXYZ1234567890_: 1G_INTO: 1AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA: 1T_BOLD: 1T_ITALICS: 1T_UNDERLINE: 1T_NO_LIST: 1T_BULL_LIST: 1T_JUST_LEFT: 1T_JUST_RT: 1T_JUST_CEN: 1T_IND_LEFT: 1T_IND_RIGHT: 1G_TAB_CHARACTER: 1 : 1G_NL_CHARACTER: 1:n: 1QUERY_PREPROCESSING: 1UPPER: 1SUBSTR: 1LTRIM: 1G_QUERY: 16: 1STATIC: 1SELECT: 1ELSIF: 1IS NULL: 1WWV_EXECUTE_IMMEDIATE: 1RUN_BLOCK: 1P_SQL: 1declare function x return varchar2 is begin : 1TRIM_SQL: 1P_ENDS_IN_SEMICOLON: 1TRUE: 1P_DO_SUBSTITUTIONS: 1 return null; end; begin wwv_flow_utilities.g_query ::= x; end;: 1P_USER: 1WWV_FLOW_SECURITY: 1G_PARSE_AS_SCHEMA: 1OTHERS: 1SHOW_ERROR_MESSAGE: 1P_MESSAGE: 1WWV_FLOW_LANG: 1SYSTEM_MESSAGE: 1wwv_flow_utilities.err_lov: 1P_QUERY: 1P_FOOTER: 1SQLERRM: 1G_UNRECOVERABLE_ERROR: 1RETURN: 1FUNCTION: 1WRAP_DIV_OPEN: 1P_ATTRIBUTES: 1
: 1WRAP_DIV_CLOSE: 1
: 1WRAP_SPAN_OPEN: 1: 1IN_LIST: 1P_VALUE: 1P_ARRAY: 1I: 1COUNT: 1LOOP: 1=: 1OPEN_NOSCRIPT: 1HTP: 1P: 1: 1OPEN_JAVASCRIPT: 1VERSION: 11.1: 1: 1APPEND_TO_LIST: 1function appendToList(theValue, toList): 1{: 1 // First, get rid of any spaces: 1 trimmedValue = "";: 1 for (i=0; i < theValue.length; i++): 1 if (theValue.charAt(i) != ' '): 1 trimmedValue += theValue.charAt(i): 1 if (trimmedValue == "") return;: 1 // Then, split the comma-separated string into an array: 1 valueArray = trimmedValue.split(",");: 1 for (i=0; i < valueArray.length; i++): 1 {: 1 if (valueArray[i] != ""): 1 {: 1 found = false;: 1 for (j=0; j= 0; i--):n {+ 1:n if (fromList.options[i].selected):n fromList.options[i] = nu+ 1ll; :n }:n}: 1SHOW_INVALID_INSTANCE_SCREEN: 1P_LINK_TEXT: 1P_LINK_TARGET: 1WWV_FLOW_INIT_HTP_BUFFER: 1: 1: 1

: 1: 1: 1: 1: 1TIME_SINCE: 1P_DATE: 1DATE: 1LIST_MGR_DISPLAY: 1P_LOV: 1P_POPUP_LOV_TYPE: 1POPUP: 1P_NAME: 1P_TEXT_NAME: 1P_EDIT_MODE: 1P_UPPER_VALS: 1P_FORM_INDEX: 10: 1P_ITEM1: 1P_ITEM2: 1REPLACE: 1CHR: 113: 1 : 1: 1PRN: 1: 1IS NOT NULL: 1FORMSELECTOPEN: 1CNAME: 1NSIZE: 1MULTIPLE WIDTH="225" : 1FORMSELECTOPTION: 1LPAD: 1 : 1240: 1VALUE="DELETE ME" : 1FORMSELECTCLOSE: 1if ( document.forms[: 1.length == 1 ) : 1 if ( document.forms[: 1.options[0].value == 'DELETE ME' ): 1 document.forms[: 1.length--; : 1: 1
: 1NVL: 1SHOW_AS_POPUP: 1P_WIDTH: 127: 1P_MAX_LENGTH: 12000: 1P_TRANSLATION: 1NO: 1P_OK_TO_QUERY: 1: 1WWV_HTP: 1FORMBUTTON: 1CVALUE: 1wwv_flow_utilities.add: 1CATTRIBUTES: 1onClick="appendToList(document.forms[: 1].: 1.value.toUpperCase(), document.forms[: 1);document.forms[: 1.value=''": 1.value, document.forms[: 1
: 1wwv_flow_utilities.remove: 1onClick="deleteListElement(document.forms[: 1)": 1
: 1URLENCODE: 1P_STR: 1L_TMP: 16000: 1L_LEN: 1LENGTH: 1L_HEX: 116: 10123456789ABCDEF: 1L_NUM: 1L_BAD: 1100: 1 >%}\~];?@&<#{|^[`/::=$+'": 1L_CHAR: 1CHAR: 1INSTR: 1ASCII: 1%: 1MOD: 1TRUNC: 1/: 1+: 1BUILD_ATTRIBUTES: 1P_ONFOCUS: 1P_ONCHANGE: 1P_ONBLUR: 1ITE: 1 onBlur=": 1": 1 onChange=": 1 onFocus=": 1GEN_FILTER_ESCAPE: 1L_STRING: 1OWA_UTIL: 1GET_CGI_ENV: 1HTTP_USER_AGENT: 1MSIE: 1REQUEST_IANA_CHARSET: 1UTF-8: 1 function filter_escape(in_value) { :n out_value = encodeURICo+ 1mponent( in_value );:n return out_value;:n }: 1 function filter_escape(in_value) { :n out_value = in_value; + 1:n out_value = out_value.replace( /%/g, '%25'); :n + 1 out_value = out_value.replace( /\?/g, '%3F');:n out_value + 1= out_value.replace( /&/g, '%26');:n out_value = out_value.rep+ 1lace( / /g, '%20');:n out_value = out_value.replace( /;/g, '%3+ 1B');:n out_value = out_value.replace( /\//g, '%2F');:n + 1 out_value = out_value.replace( /::/g, '%3A');:n out_va+ 1lue = out_value.replace( /@/g, '%40');:n out_value = out_value+ 1.replace( /=/g, '%3D');:n out_value = out_value.replace( /\+/g+ 1, '%2B');:n out_value = out_value.replace( /\$/g, '%24');:n + 1 out_value = out_value.replace( /,/g, '%2C');:n ou+ 1t_value = out_value.replace( /#/g, '%23');:n return out_value;+ 1:n }: 1 function filter_escape(in_value) { :n out_value = escape( in_valu+ 1e );:n return out_value;:n }: 1L_NEWLINE: 1UNISTR: 1\000a: 1wwv_flow_utilities.js_no_support: 1INIT: 1SYS: 1DBMS_SYS_SQL: 1IS_OPEN: 1DELETE: 1TO_NUMBER: 1CURSOR: 1VALUE_ERROR: 1OPEN_CURSOR: 1PARSE_AS_USER: 1NATIVE: 1USERID: 1GET_USERID: 1wwv_flow_utilities.init_lov_err: 1PERFORM_BINDS: 1P_CURSOR: 1P_STMT: 1DEFINE_COLUMN: 12: 1EXECUTE: 1CLOSE_CURSOR: 1INIT_WITH_FILTER: 1P_FILTER: 1L_DESCTBL: 1DBMS_SQL: 1DESC_TAB: 1L_COLCNT: 1L_DISP_COL: 1L_RETURN_COL: 1L_BINDS: 1VARCHAR2_TABLE: 1L_VAR: 1LIKE: 1select /* generated */%: 1DESCRIBE_COLUMNS: 1COL_NAME: 1select /* generated */ : 1, : 1 from (: 1) wwvlovinlineviewname : 1 where upper(: 1) like '%'||upper(::WWV_LOV_RETURN_KEY_UTIL_1111)||'%': 1wwv_flow_utilities.popup_filter_err: 1wwv_flow_utilities.generate_query_err: 1GET_BINDS: 1WWV_LOV_RETURN_KEY_UTIL_1111: 1BIND_VARIABLE: 1V: 1wwv_flow_utilities.unable_to_bind_err: 1FETCH_ROW: 1P_DISPLAY: 1OUT: 1STATICLIST: 1EXISTS: 1RTRIM: 1FETCH_ROWS: 1COLUMN_VALUE: 1SHOW_AS_TEXTAREA_BUTTON: 1P_COMMAND: 1P_IMAGE: 1P_TITLE: 1P_ITEM_NAME: 1: 1SHOW_AS_TEXTAREA_COLORLIST: 1 onchange="document.execCommand(': 1', '', this[this.selectedIndex].value );this.selectedIndex=0;document.getElem+ 1entById(': 1Div').focus();" style="background::white;font:: 8pt verdana,arial,sans-serif": 1VALUE=": 1aliceblue: 1VALUE="aliceblue": 1antiquewhite: 1VALUE="antiquewhite": 1aqua: 1VALUE="aqua": 1aquamarine: 1VALUE="aquamarine": 1azure: 1VALUE="azure": 1beige: 1VALUE="beige": 1bisque: 1VALUE="bisque": 1black: 1VALUE="black": 1blanchedalmond: 1VALUE="blanchedalmond": 1blue: 1VALUE="blue": 1blueviolet: 1VALUE="blueviolet": 1brown: 1VALUE="brown": 1burlywood: 1VALUE="burlywood": 1cadetblue: 1VALUE="cadetblue": 1chartreuse: 1VALUE="chartreuse": 1chocolate: 1VALUE="chocolate": 1coral: 1VALUE="coral": 1cornflower: 1VALUE="cornflower": 1cornsilk: 1VALUE="cornsilk": 1crimson: 1VALUE="crimson": 1cyan: 1VALUE="cyan": 1darkblue: 1VALUE="darkblue": 1darkcyan: 1VALUE="darkcyan": 1darkgoldenrod: 1VALUE="darkgoldenrod": 1darkgray: 1VALUE="darkgray": 1darkgreen: 1VALUE="darkgreen": 1darkkhaki: 1VALUE="darkkhaki": 1darkmagenta: 1VALUE="darkmagenta": 1darkolivegreen: 1VALUE="darkolivegreen": 1darkorange: 1VALUE="darkorange": 1darkorchid: 1VALUE="darkorchid": 1darkred: 1VALUE="darkred": 1darksalmon: 1VALUE="darksalmon": 1darkseagreen: 1VALUE="darkseagreen": 1darkslateblue: 1VALUE="darkslateblue": 1darkslategray: 1VALUE="darkslategray": 1darkturquoise: 1VALUE="darkturquoise": 1darkviolet: 1VALUE="darkviolet": 1deeppink: 1VALUE="deeppink": 1deepskyblue: 1VALUE="deepskyblue": 1dimgray: 1VALUE="dimgray": 1dodgerblue: 1VALUE="dodgerblue": 1firebrick: 1VALUE="firebrick": 1floralwhite: 1VALUE="floralwhite": 1forestgreen: 1VALUE="forestgreen": 1fuchia: 1VALUE="fuchia": 1gainsboro: 1VALUE="gainsboro": 1ghostwhite: 1VALUE="ghostwhite": 1gold: 1VALUE="gold": 1goldenrod: 1VALUE="goldenrod": 1gray: 1VALUE="gray": 1green: 1VALUE="green": 1greenyellow: 1VALUE="greenyellow": 1honeydew: 1VALUE="honeydew": 1hotpink: 1VALUE="hotpink": 1indianred: 1VALUE="indianred": 1indigo: 1VALUE="indigo": 1ivory: 1VALUE="ivory": 1khaki: 1VALUE="khaki": 1lavender: 1VALUE="lavender": 1lavenderblush: 1VALUE="lavenderblush": 1lawngreen: 1VALUE="lawngreen": 1lemonchiffon: 1VALUE="lemonchiffon": 1lightblue: 1VALUE="lightblue": 1lightcoral: 1VALUE="lightcoral": 1lightcyan: 1VALUE="lightcyan": 1lightgoldenrodyellow: 1VALUE="lightgoldenrodyellow": 1lightgreen: 1VALUE="lightgreen": 1lightgrey: 1VALUE="lightgrey": 1lightpink: 1VALUE="lightpink": 1lightsalmon: 1VALUE="lightsalmon": 1lightseagreen: 1VALUE="lightseagreen": 1lightskyblue: 1VALUE="lightskyblue": 1lightslategray: 1VALUE="lightslategray": 1lightsteelblue: 1VALUE="lightsteelblue": 1lightyellow: 1VALUE="lightyellow": 1lime: 1VALUE="lime": 1limegreen: 1VALUE="limegreen": 1linen: 1VALUE="linen": 1magenta: 1VALUE="magenta": 1maroon: 1VALUE="maroon": 1mediumaquamarine: 1VALUE="mediumaquamarine": 1mediumblue: 1VALUE="mediumblue": 1mediumorchid: 1VALUE="mediumorchid": 1mediumpurple: 1VALUE="mediumpurple": 1mediumseagreen: 1VALUE="mediumseagreen": 1mediumslateblue: 1VALUE="mediumslateblue": 1mediumspringgreen: 1VALUE="mediumspringgreen": 1mediumturquoise: 1VALUE="mediumturquoise": 1mediumvioletred: 1VALUE="mediumvioletred": 1midnightblue: 1VALUE="midnightblue": 1mintcream: 1VALUE="mintcream": 1mistyrose: 1VALUE="mistyrose": 1moccasin: 1VALUE="moccasin": 1navajowhite: 1VALUE="navajowhite": 1navy: 1VALUE="navy": 1oldlace: 1VALUE="oldlace": 1olive: 1VALUE="olive": 1olivedrab: 1VALUE="olivedrab": 1orange: 1VALUE="orange": 1orangered: 1VALUE="orangered": 1orchid: 1VALUE="orchid": 1palegoldenrod: 1VALUE="palegoldenrod": 1palegreen: 1VALUE="palegreen": 1paleturquoise: 1VALUE="paleturquoise": 1palevioletred: 1VALUE="palevioletred": 1papayawhip: 1VALUE="papayawhip": 1peachpuff: 1VALUE="peachpuff": 1peru: 1VALUE="peru": 1pink: 1VALUE="pink": 1plum: 1VALUE="plum": 1powderblue: 1VALUE="powderblue": 1purple: 1VALUE="purple": 1red: 1VALUE="red": 1rosybrown: 1VALUE="rosybrown": 1royalblue: 1VALUE="royalblue": 1saddlebrown: 1VALUE="saddlebrown": 1salmon: 1VALUE="salmon": 1sandybrown: 1VALUE="sandybrown": 1seagreen: 1VALUE="seagreen": 1seashell: 1VALUE="seashell": 1sienna: 1VALUE="sienna": 1silver: 1VALUE="silver": 1skyblue: 1VALUE="skyblue": 1slateblue: 1VALUE="slateblue": 1slategray: 1VALUE="slategray": 1snow: 1VALUE="snow": 1springgreen: 1VALUE="springgreen": 1steelblue: 1VALUE="steelblue": 1tan: 1VALUE="tan": 1teal: 1VALUE="teal": 1thistle: 1VALUE="thistle": 1tomato: 1VALUE="tomato": 1turquoise: 1VALUE="turquoise": 1violet: 1VALUE="violet": 1wheat: 1VALUE="wheat": 1white: 1VALUE="white": 1whitesmoke: 1VALUE="whitesmoke": 1yellow: 1VALUE="yellow": 1yellowgreen: 1VALUE="yellowgreen": 1SHOW_AS_TEXTAREA_WITH_CONTROLS: 1P_HEIGHT: 1P_SIZE: 1L_USER_AGENT: 1L_HEIGHT_PIXELS: 1L_WIDTH_PIXELS: 1MSIE 5: 1MSIE 6: 1Opera: 1Mac_: 15: 1*: 115: 130: 19.5: 1FORMHIDDEN: 1": 1id=": 1
: 1 onchange="document.execCommand('formatBlock','', this[this.selectedIndex].va+ 1lue );this.selectedIndex=0;: 1document.getElementById(': 1Paragraph: 1VALUE="Paragraph": 1Normal: 1VALUE="Normal": 1Heading 1 <H1>: 1VALUE="<H1>": 1Heading 2 <H2>: 1VALUE="<H2>": 1Heading 3 <H3>: 1VALUE="<H3>": 1Heading 4 <H4>: 1VALUE="<H4>": 1Heading 5 <H5>: 1VALUE="<H5>": 1Heading 6 <H6>: 1VALUE="<H6>": 1 onchange="document.execCommand('fontname', '', this[this.selectedIndex].valu+ 1e );this.selectedIndex=0;: 1Font: 1VALUE="Font": 1Arial: 1VALUE="Arial": 1Book Antiqua: 1VALUE="Book Antiqua": 1Century Gothic: 1VALUE="Century Gothic": 1Comic Sans MS: 1VALUE="Comic Sans MS": 1Courier: 1VALUE="Courier": 1Courier New: 1VALUE="Courier New": 1Garamond: 1VALUE="Garamond": 1Roman: 1VALUE="Roman": 1Script: 1VALUE="Script": 1Times New Roman: 1VALUE="Times New Roman": 1Verdana: 1VALUE="Verdana": 1Wingdings: 1VALUE="Wingdings": 1 onchange="document.execCommand('fontsize','', this[this.selectedIndex].value+ 1 );this.selectedIndex=0;: 1Size: 1VALUE="Size": 1-4: 1VALUE="-4": 1-3: 1VALUE="-3": 1-2: 1VALUE="-2": 1-1: 1VALUE="-1": 1VALUE="1": 1VALUE="2": 13: 1VALUE="3": 14: 1VALUE="4": 1VALUE="5": 1VALUE="6": 17: 1VALUE="7": 1forecolor: 1Foreground: 1backcolor: 1Background: 1
: 1G_TRANSLATED_FLOW_ID: 1G_FLOW_ID: 1Bold: 1Italics: 1Underline: 1Numbered List: 1Bulleted List: 1Justify Left: 1Justify Right: 1Justify Center: 1Indent Left: 1Indent Right: 1wwv_flow_utilities.t_bold: 1wwv_flow_utilities.t_italics: 1wwv_flow_utilities.t_underline: 1wwv_flow_utilities.t_no_list: 1wwv_flow_utilities.t_bull_list: 1wwv_flow_utilities.t_just_left: 1wwv_flow_utilities.t_just_rt: 1wwv_flow_utilities.t_just_cen: 1wwv_flow_utilities.t_ind_left: 1wwv_flow_utilities.t_ind_right: 1wbold.gif: 1Italic: 1witalic.gif: 1wunder.gif: 1insertOrderedList: 1wnlist.gif: 1insertUnorderedList: 1wblist.gif: 1JustifyLeft: 1waleft.gif: 1JustifyCenter: 1wcenter.gif: 1JustifyRight: 1waright.gif: 1Outdent: 1wileft.gif: 1Indent: 1wiright.gif: 1
: 1').value;: 1HTF: 1FORMTEXTAREAOPEN2: 1NCOLUMNS: 1NROWS: 1CWRAP: 1virtual: 1ESCAPE_SC: 1FORMTEXTAREACLOSE: 1SHOW_AS_DISPLAY_ONLY: 1wwv_flow_utilities.lov2_err: 1ORA-01007%: 1wwv_flow_utilities.disp_only_list_err: 1EXIT: 1NOT: 1YES: 1G_PRINTER_FRIENDLY: 1[: 1]: 1GET_DISPLAY_VALUE_GIVEN_LOV: 1P_SQL_QUERY: 1P_ESCAPE_SC: 1select : 1) wwvlovinlineviewname where : 1 = ::WWV_LOV_RETURN_KEY_UTIL_1111: 1PAGINATE_FOOTER: 1P_REQUEST: 1P_MIN_ROW: 1P_ROW_RETURNED: 1P_ROWS_X_OF_Y_FORMAT: 1L_LAST_ROW: 1-: 1#FIRST_ROW#: 1#LAST_ROW#: 1
: 1wwv_flow_utilities.no_matches: 1FORMSUBMIT: 1p_request: 1wwv_flow_utilities.prev: 1wwv_flow_utilities.next: 1p_min_row: 1: 1SHOW_AS_POPUP_CALENDAR: 1P_YYYY: 1P_MM: 1P_DD: 1P_HH: 1P_MI: 1P_PM: 1P_ELEMENT_INDEX: 1P_DATE_FORMAT: 1MM/DD/YYYY: 1P_BGCOLOR: 1#336699: 1P_WHITE_FOREGROUND: 1Y: 1P_APPLICATION_FORMAT: 1N: 1P_LANG: 1L_FORM_INDEX: 1L_ELEMENT_INDEX: 1L_MONTH_LABEL: 132: 1L_IMAGE_NAME: 1L_START_DAY_OF_MONTH: 1L_DAY_OF_WEEK_INDEX: 1L_DAYS_IN_MONTH: 1L_MONTH_VALUE: 1L_SELECTED: 1L_MM: 1L_DD: 1L_YYYY: 1L_HH: 1L_MI: 1L_PM: 1L_IMAGE_COLOR_CODE: 1L_KNOWN_DAYOFWEEK: 1L_TIME_COMPONENT: 1L_TIME_24: 1L_FORMAT_SUPPLIED: 1L_LOCATION_HREF: 1L_MERIDIAN_AM: 120: 1L_MERIDIAN_PM: 1L_DAY: 1L_DAY_DATE: 1C1: 1NLS_LANGUAGE: 1NLS_TERRITORY: 1WWV_FLOW_LANGUAGES: 1LANG_ID: 1select nls_language, nls_territory:n from wwv_flow_languag+ 1es:n where lang_id = p_lang: 1DBMS_SESSION: 1SET_NLS: 1PARAM: 1VALUE: 1TO_CHAR: 1TO_DATE: 1MERIDIAN_AM: 1DUAL: 1select to_char(to_date('2004010101','YYYYMMDDHH24'),'AM') meridian_am:n + 1 from dual: 1MERIDIAN_PM: 1select to_char(to_date('2004010113','YYYYMMDDHH24'),'PM') meridian_pm:n + 1 from dual: 1PREV_MONTH: 1ADD_MONTHS: 1MMYYYY: 1MM: 1YYYY: 1NEXT_MONTH: 101: 1LEAST: 1LAST_DAY: 1YYYYMM: 1DD: 100: 1D: 101012001: 1MMDDYYYY: 1location.href=': 1G_FLOW_SCHEMA_OWNER: 1.wwv_flow_utilities.show_as_popup_calendar?p_title=: 1&p_yyyy='+ document.forms[0].p_yyyy.options[document.forms[0].p_yyyy.selected+ 1Index].value +'&p_mm='+ document.forms[0].p_mm[document.forms[0].p_mm.selecte+ 1dIndex].value +'&p_element_index=: 1&p_form_index=: 1&p_bgcolor=: 1URL_ENCODE2: 1&p_date_format=: 1&p_application_format=: 1&p_lang=: 1ESCAPE_URL: 1HH24::MI: 1HH::MI: 1&p_dd='+document.forms[0].p_dd.value+'&p_hh='+document.forms[0].p_hh[document+ 1.forms[0].p_hh.selectedIndex].value +'&p_mi='+document.forms[0].p_mi[document+ 1.forms[0].p_mi.selectedIndex].value : 1HH24: 1+'&p_pm='+ document.forms[0].p_pm[document.forms[0].p_pm.selectedIndex].value+ 1 : 1': 1;: 1w: 1b: 1: 1: 1: 1WWV_FLOW_UTILITIES.CAL: 1: 1 : 1function doSubmit( r ) { : 1document.forms[0].p_request.value = r;: 1document.forms[0].submit(); : 1function setDateVal(x): 1document.forms[0].p_dd.value = x.substr(3,2);: 1DD/MM/YYYY: 1document.forms[0].p_dd.value = x.substr(0,2);: 1DD-MON-YYYY: 1DD-MON-YY: 1DD-MON-RR: 1YYYY-MM-DD: 1document.forms[0].p_dd.value = x.substr(8,2);: 1RR-MON-DD: 1document.forms[0].p_dd.value = x.substr(7,2);: 1DD-MM-YYYY: 1DD.MM.YYYY: 1YYYY.DD.MM: 1document.forms[0].p_dd.value = x.substr(5,2);: 1YYYY/MM/DD: 1 opener.document.forms["wwv_flow"].: 1.value = x;: 1 close();: 1function setDateValAndClose(): 1.value = ": 1YYYYMMDDHHMIPM: 1";: 1YYYYMMDDHH24MI: 1 window.close();: 1: 1
: 1: 1: 1: 1: 1:
1YYYYMMDD:
1FMMonth YYYY:
1: 1: 1: 1: 1
: 1: 1WWV_FLOW_UTILITIES.OK: 1" onClick="javascript::setDateValAndClose();"/>: 1
: 1
: 1ESCAPE_SPECIAL: 1\: 1\\: 1\": 1.: 1\.: 1IS_VALID_LOV_QUERY: 1P_OWNER: 1L_REPORT_CURSOR: 1INTEGER: 1L_COL_CNT: 1L_QUERY: 1L_COL_HEADINGS: 1L_DESC_TBL: 1DESC_TAB2: 1L_FROM: 1INT: 1#OWNER#: 1WWV_RENDER_REPORT3: 1GET_DBMS_SQL_CURSOR: 1DESCRIBE_COLUMNS2: 1STRIPHTML: 1WWV_FLOW_SW_UTIL: 1IS_VALID_NAME: 1G_VALUE: 1TRANSLATE: 1"*() : 1|||||||: 1|FROM|: 1begin : 1 bulk collect into wwv_flow_utilities.g_display,wwv_flow_utilities.g_value : 1; end;: 1begin execute immediate ': 1'': 1' : 1GET_USING_CLAUSE: 1GEN_POPUP_LIST: 1P_LOV_CHECKSUM: 1P_ESCAPE_HTML: 1P_MAX_ELEMENTS: 1P_BEFORE_FIELD_FIELD_TEXT: 1P_AFTER_FIELD_FIELD_TEXT: 1P_HELP: 1P_EVAL_VALUE: 1P_RETURN_KEY: 1P_HIDDEN_ELEM_NAME: 1P_FLOW_ID: 1P_PAGE_ID: 1P_SESSION_ID: 1P_COMPANY: 1L_CNT: 1L_MIN_ROW: 1L_FILTER: 1L_FLOWCNT: 1L_FLOW_ID: 1L_SESSION_ID: 1L_TEMP: 1L_LOV: 1L_OK_TO_QUERY: 1L_RETURN_KEY: 1%22: 1!=: 1RAISE_APPLICATION_ERROR: 120001: 1wwv_flow_utilities.popup_bg_select_err: 1G_POPUP_FILTER: 1G_INSTANCE: 1G_FLOW_STEP_ID: 1G_STEP_NAME: 1POPUP LOV - : 1SHOW: 1P_FLOW_STEP_ID: 1P_INSTANCE: 1FSP_SHOW_POPUPLOV: 1WWV_FLOW_SW_API: 1G_RAISE_ERRORS: 1G_ERROR_MSG: 1WWV_FLOW_UTILITIES.INVALID_LOV_QUERY: 1DISPLAY_ERROR_MSG: 1G_AUTHENTICATED: 1wwv_flow_utilities.popup_lov_auth_err: 1LOV_CHECKSUM: 1wwv_flow_utilities.popup_lov_check_err: 1WWV_FLOW_POPUP_LOV_TEMPLATE: 1FLOW_ID: 1THEME_ID: 1G_FLOW_THEME_ID: 1select * from WWV_FLOW_POPUP_LOV_TEMPLATE :n where flow_i+ 1d = nvl(wwv_flow.g_translated_flow_id,l_flow_id):n and (t+ 1heme_id is null or theme_id = wwv_flow.g_flow_theme_id) : 1POPUP_ICON: 1POPUP_ICON_ATTR: 1PAGE_NAME: 1PAGE_TITLE: 1PAGE_HTML_HEAD: 1PAGE_BODY_ATTR: 1BEFORE_FIELD_TEXT: 1PAGE_HEADING_TEXT: 1PAGE_FOOTER_TEXT: 1FILTER_WIDTH: 1FILTER_MAX_WIDTH: 1FILTER_TEXT_ATTR: 1FIND_BUTTON_TEXT: 1FIND_BUTTON_IMAGE: 1FIND_BUTTON_ATTR: 1CLOSE_BUTTON_TEXT: 1CLOSE_BUTTON_IMAGE: 1CLOSE_BUTTON_ATTR: 1NEXT_BUTTON_TEXT: 1NEXT_BUTTON_IMAGE: 1NEXT_BUTTON_ATTR: 1PREV_BUTTON_TEXT: 1PREV_BUTTON_IMAGE: 1PREV_BUTTON_ATTR: 1AFTER_FIELD_TEXT: 1SCROLLBARS: 1RESIZABLE: 1WIDTH: 1HEIGHT: 1RESULT_ROW_X_OF_Y: 1RESULT_ROWS_PER_PG: 1BEFORE_RESULT_SET: 1AFTER_RESULT_SET: 1DO_SUBSTITUTIONS: 1TEXT: 1wwv_flow_utilities.popup_init_err: 1wwv_flow_utilities.popup_filter_init_err: 1HTMLOPEN: 1HEADOPEN: 1TITLE: 1wwv_flow_utilities.search_dialog: 1HEADCLOSE: 1#IMAGE_PREFIX#: 1ESC: 1BODYOPEN: 1:n function first_field():n {:n document.forms[0].p_filter.focus()+ 1;:n return;:n }:n //-->:n : 1:n function passBack(x,y):n {:n if (opener.document.forms["wwv_f+ 1low"].: 1.length > 1):n {:n opener.document.forms[: 1"wwv_flow": 1.value = x;:n opener.document.forms[: 1.value = y;:n }:n else:n {:n opener.document+ 1.forms[: 1.value = y;:n }:n close();:n }: 1:n function passBack(x):n {:n if (opener.document.forms["wwv_flo+ 1w"].: 1.focus();:n }:n else:n {:n opener.document.f+ 1orms[: 1.focus();:n }:n close();:n }: 1FORMOPEN: 1CURL: 1wwv_flow_utilities.gen_popup_list: 1CMETHOD: 1GET: 1p_name: 1p_lov: 1p_lov_checksum: 1p_element_index: 1p_form_index: 1p_max_elements: 1p_escape_html: 1p_eval_value: 1p_translation: 1p_return_key: 1p_hidden_elem_name: 1p_ok_to_query: 1p_flow_id: 1p_page_id: 1p_session_id: 1p_company: 1G_CURR_FLOW_SECURITY_GROUP_ID: 1FORMTEXT: 1p_filter: 1CSIZE: 1CMAXLENGTH: 1wwv_flow_utilities.find: 1...: 1wwv_flow_utilities.close: 1 onClick="window.close()": 1var v = new Array();: 1var v2 = new Array();: 1>=: 1v[: 1] = ": 1v2[: 1document.writeln("
: 1");: 1BODYCLOSE: 1HTMLCLOSE: 1G_WEBDB_LOGGING: 1WWV_FLOW_LOG: 1LOG: 1P_ELAP: 1DBMS_UTILITY: 1GET_TIME: 1G_PACKAGE_INSTANTIATED: 1.01: 1P_NUM_ROWS: 1P_VERBOSE: 1INVALID_CURSOR: 1wwv_flow_utilities.generate_popup_lov_err: 1P_FILTER_FIRST_FETCH: 1NEW_LINE: 1wwv_flow_utilities.init_query_err: 1select popup_icon, popup_icon_attr, :n SCROLLBARS, :n + 1 RESIZABLE, :n WIDTH, :n + 1 HEIGHT :n from wwv_flow_popup_lov_template :n + 1 where flow_id = nvl(wwv_flow.g_translated_flow_id,wwv_flow.g_flow_id):n + 1 and (theme_id is null or theme_id = wwv_flow.g_flow_theme_id) : 1IMAGE: 1C2: 1FLOW_IMAGE_PREFIX: 1WWV_FLOWS: 1ID: 1select flow_image_prefix from wwv_flows where id = wwv_flow.g_flow_id: 1FAST_REPLACE: 1#COMPANY_IMAGES#: 1G_COMPANY_IMAGES: 1#WORKSPACE_IMAGES#: 1#FLOW_IMAGES#: 1FLOW_IMAGES: 1#APP_IMAGES#: 1COMPANY_IMAGES: 1:n function genList: 1_: 1(filter):n {:n w = open(": 1wwv_flow_utilities.gen_popup_list" +:n "?p_filter=" + + 1filter_escape(filter.value) +:n "&p_name=" + escape(': 1') +:n "&p_element_index=" + escape(': 1') +:n "&p_form_index=" + escape(': 1') +:n "&p_max_elements=" + escape(': 1') +:n "&p_escape_html=" + escape(': 1') +:n "&p_ok_to_query=" + escape(': 1') +:n "&p_flow_id=" + escape(': 1') +:n "&p_page_id=" + escape(': 1') +:n "&p_session_id=" + escape(': 1') +:n "&p_eval_value=" + escape(': 1') +:n "&p_translation=" + escape(': 1') +:n "&p_lov=" + filter_escape(': 1') +:n "&p_lov_checksum=: 1",:n "winLovList",:n "Scrollbars=: 1,resizable=: 1,width=: 1,height=: 1");:n if (w.opener == null):n w.opener = self;:n + 1 w.focus();:n }: 1():n {:n w = open(": 1wwv_flow_utilities.gen_popup_list" +:n "?p_filter=" + + 1:n "&p_name=" + escape(': 1') +:n "&p_hidden_elem_name=" + escape(': 1') +:n "&p_return_key=YES" +:n "&+ 1p_translation=" + escape(': 1ANCHOR: 1javascript::genList: 1(document.forms[0].: 1): 1CTEXT: 1IMG: 1 alt=": 1wwv_flow_utilities.list: 1" border="0" align="bottom": 1(): 1EXECUTE_IMMEDIATE_LOV: 1SHOW_AS_COMBOBOX: 1P_SHOW_NULL: 1P_NULL_TEXT: 1P_NULL_VALUE: 1P_SHOW_EXTRA: 1P_EXTRA_TEXT: 11000000: 1DEFAULT_MATCHED: 1L_VALUE: 122: 1PLSQL_OPTION_PROCEDURE: 1: 1 checked="checked" : 1 id=": 1" />: 1G_FLOW_IMAGES: 1&: 1