set define '^' set verify off prompt wwv_render_report3.plb create or replace package body wwv_render_report3 wrapped 0 abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd 3 b 9200000 1 4 0 57f 2 :e: 1PACKAGE: 1BODY: 1WWV_RENDER_REPORT3: 1G_QUERY: 1VARCHAR2: 132767: 1G_HIDDEN_FIELDS: 1G_USE_QUERY_HEADINGS: 116: 1G_DEFAULT_SORT_COLS: 1255: 1G_DISABLE_SORT_COLS: 1G_REGION_ID: 1NUMBER: 10: 1G_REPEAT_HD_COUNT: 1G_UPGRADE_MODE: 1BOOLEAN: 1FALSE: 1G_ADDED_ROWS_TO_REPORT: 1G_TOTAL_NUMBER_OF_ROWS: 1G_TARGET_DB_CHARSET: 1100: 1G_SOURCE_DB_CHARSET: 1G_EXPORT_BLOB: 1BLOB: 1G_EXPORT_CLOB: 1CLOB: 1G_DEFAULT_MIME_CHARSET: 1utf-8: 1G_SEPARATOR: 11: 1G_ENCLOSED_BY: 1G_SECONDS_AGO: 14000: 1G_MINUTES_AGO: 1G_HOURS_AGO: 1G_DAYS_AGO: 1G_WEEKS_AGO: 1G_MONTHS_AGO: 1G_YEARS_AGO: 1G_SINCE_USED: 1G_CSV_CHARSET: 1INIT_GLOBALS: 1G_QUERY_COLUMN_ID: 1EMPTY_VC_ARR: 1G_FORM_ELEMENT_ID: 1G_COLUMN_ALIAS: 1G_COLUMN_HEADING: 1G_COLUMN_FORMAT: 1G_COLUMN_HTML_EXPRESSION: 1G_COLUMN_CSS_CLASS: 1G_COLUMN_CSS_STYLE: 1G_COLUMN_HIT_HIGHLIGHT: 1G_COLUMN_LINK: 1G_COLUMN_LINKTEXT: 1G_COLUMN_LINK_CHECKSUM_TYPE: 1G_COLUMN_ALIGNMENT: 1G_HEADING_ALIGNMENT: 1G_DEFAULT_SORT_COLUMN_SEQUENCE: 1G_DEFAULT_SORT_DIR: 1G_DISABLE_SORT_COLUMN: 1G_SUM_COLUMN: 1G_HIDDEN_COLUMN: 1G_ASC_IMAGE: 1G_ASC_IMAGE_ATTR: 1G_DESC_IMAGE: 1G_DESC_IMAGE_ATTR: 1G_DISPLAY_WHEN_COND_TYPE: 1G_DISPLAY_WHEN_CONDITION: 1G_DISPLAY_WHEN_CONDITION2: 1G_COLUMN_REQUIRED_ROLE: 1G_QUERY_OPTIONS: 1G_DISPLAY_AS: 1G_NAMED_LOV: 1G_INLINE_LOV: 1G_LOV_SHOW_NULLS: 1G_LOV_NULL_TEXT: 1G_LOV_NULL_VALUE: 1G_COLUMN_WIDTH: 1G_COLUMN_HEIGHT: 1G_CATTRIBUTES: 1G_CATTRIBUTES_ELEMENT: 1G_OK_TO_CONTINUE: 1TRUE: 1G_IS_XML_EXPORT: 1G_SORT_ENABLED: 1G_HAS_DERIVED_COLUMNS: 1G_HAS_ROW_SELECTOR: 1G_HAS_ROW_HIGHLIGHTING: 1G_IS_TABULAR_FORM: 1WWV_FLOW_LANG: 1GET_CSV_CHARSET: 1FUNCTION: 1WS: 1P_COUNT: 1RETURN: 1L_WS: 1I: 1LOOP: 1||: 1 : 1INIT_SINCE: 1IS NULL: 1SYSTEM_MESSAGE: 1SINCE_SECONDS_AGO: 1#time#: 1SINCE_MINUTES_AGO: 1SINCE_HOURS_AGO: 1SINCE_DAYS_AGO: 1SINCE_WEEKS_AGO: 1SINCE_MONTHS_AGO: 1SINCE_YEARS_AGO: 1IS_NUMERIC: 1P_VAL: 1L_NUM: 1TO_NUMBER: 1OTHERS: 1INIT_NUM_ARRAY: 1P_COL_CNT: 1NUM_ARR: 1L_NUM_ARRAY: 1GET_DBMS_SQL_CURSOR: 1P_QUERY: 1L_OWNER: 1WWV_FLOW_SECURITY: 1G_PARSE_AS_SCHEMA: 1INTEGER: 1L_REPORT_CURSOR: 1L_QUERY: 1WWV_FLOW: 1DEBUG: 1cursor provided by calling program: 1SYS: 1DBMS_SYS_SQL: 1IS_OPEN: 1NOT: 1G_STATUS: 1WWV_RENDER_REPORT3.CURSOR_NOT_OPEN: 1G_LAST_QUERY_TEXT: 1parse query: 1OPEN_CURSOR: 1TRIM_SQL: 1P_SQL: 1P_ENDS_IN_SEMICOLON: 1P_DO_SUBSTITUTIONS: 1PARSE_AS_USER: 1NATIVE: 1USERID: 1WWV_EXECUTE_IMMEDIATE: 1GET_USERID: 1SQLERRM: 1RAISE_APPLICATION_ERROR: 1-: 120001: 1wwv_render_report3.show : 1NVL: 1INSTR: 1::: 1>: 1WWV_FLOW_UTILITIES: 1PERFORM_BINDS: 1P_CURSOR: 1P_STMT: 1query could not be parsed::
:
1ESCAPE_SC:
1
: 1CLOSE_CURSOR: 1STRING_REPLACE: 1P_VALUE: 1P_SEARCH_STRING: 1P_STYLE: 1L_BEFORE_STRING: 132676: 1L_REPLACE_STRING: 1L_AFTER_STRING: 1UPPER: 1SUBSTR: 1LENGTH: 1+: 1: 1: 1HIGHLIGHT_VALUE: 1P_HIGHLIGHT_STRING: 1font-weight:: bold; color:: red;: 1P_TAG_OPEN: 1L_VALUE: 1L_TEXT: 1L_TAG: 1<: 1REPLACE: 1GET_ROW_TEMPLATE: 1P_TEMPLATE_ID: 1WWV_FLOW_ROW_TEMPLATES: 1ROWTYPE: 1L_ROW_TEMPLATE: 1L_TEMPLATE_ID: 1C1: 1ID: 1select * from wwv_flow_row_templates where id = l_template_id: 1PAGINATION_TEMPLATE: 1#TEXT#: 1NEXT_PAGE_TEMPLATE: 1: 1PREVIOUS_PAGE_TEMPLATE: 1
: 1PAGINATION.NEXT: 1next
<+ 1a href="#LINK#" class="fielddata">: 1PAGINATION.PREVIOUS: 1
: 1NEXT_SET_TEMPLATE: 1jtfunexe.gif" border="0" width="16" height="16" alt="next">: 1PREVIOUS_SET_TEMPLATE: 1=: 1ROW_TEMPLATE_NAME: 1CSV: 1ROW_TEMPLATE_TYPE: 1GENERIC_COLUMNS: 1COLUMN_HEADING_TEMPLATE: 1#COLUMN_HEADER#: 1ROW_TEMPLATE1: 1#COLUMN_VALUE#: 1ROW_TEMPLATE_DISPLAY_COND1: 1ROW_TEMPLATE_BEFORE_ROWS: 1OMIT: 1ROW_TEMPLATE_AFTER_ROWS: 1ROW_TEMPLATE_BEFORE_FIRST: 1ROW_TEMPLATE_AFTER_LAST: 1ELSIF: 1HTML (standard look): 1#COLUMN_HEADER#: 1CHR: 110: 1#COLUMN_VALUE#: 1ROW_TEMPLATE_CONDITION1: 1: 1ROW_TEMPLATE_COMMENT: 1#PAGINATION#
#TOP_PAGINATION#: 1
#CSV_LINK#
: 1ROW_TEMPLATE_TABLE_ATTRIBUTES: 1: 1: 1ROW_STYLE_CHECKED: 1#dddddd: 1ROW_STYLE_UNCHECKED: 1ROW_STYLE_MOUSE_OVER: 1ROW_STYLE_MOUSE_OUT: 1#TEXT#: 1: 1 >: 1< : 1: 1PAGINATION.NEXT_SET: 1 »: 1« : 1PAGINATION.PREVIOUS_SET: 12: 13: 1Vertical Look 1: 1#COLUMN_HEADER#: 1#COLUMN_VALUE#: 1#TOP_PAGINATION#: 1#PAGINATION#
#CSV_LINK#: 1
: 1: 1
: 1: 1ROW_TEMPLATE2: 1ROW_TEMPLATE_CONDITION2: 1ROW_TEMPLATE_DISPLAY_COND2: 1ROW_TEMPLATE3: 1ROW_TEMPLATE_CONDITION3: 1ROW_TEMPLATE_DISPLAY_COND3: 1ROW_TEMPLATE4: 1ROW_TEMPLATE_CONDITION4: 1ROW_TEMPLATE_DISPLAY_COND4: 1
#COLUMN_HEADER##COLUMN_VALUE#
#TOP_PAGINATION#: 1#PAGINATION#
#CSV_LINK#
: 1
: 1

next
: 1: 1EVEN_ROW_NUMBERS: 1
previous: 111: 1default:: look 1: 1ODD_ROW_NUMBERS: 1#COLUMN_VALUE#
#TOP_PAGINATION##PAGINATION#
: 1
 #CSV_LINK#
: 112: 1default:: look 2: 1#TOP_PAGINATION##PAGINATION#
#CSV_LINK#
: 1
: 1: 113: 1default:: look 3: 1#TOP_PAGINATION#: 1: 1
: 1TYPE: 1NAMED_COLUMNS: 1BEFORE_FIRST: 1AFTER_LAST: 1#HIGHLIGHT_ROW#: 1BEFORE_ROWS: 1AFTER_ROWS: 1TAB_ATTR: 1#PAGINATION#: 1PAGINATION: 1: 1TEMPLATE: 1CLOB_TO_VARCHAR2: 1#COLUMN_HEADER# : 1#COLUMN_VALUE# : 1
:
1G_EMPTY_CELL:
1SET_BREAK_TEMPLATE:
1P_REGION_ID:
1REPORT_TOTAL_TEXT_FORMAT:
1BREAK_COLUMN_TEXT_FORMAT:
1BREAK_BEFORE_ROW:
1BREAK_GENERIC_COLUMN:
1BREAK_AFTER_ROW:
1BREAK_TYPE_FLAG:
1BREAK_REPEAT_HEADING_FORMAT:
1WWV_FLOW_PAGE_PLUGS:
1select:n        report_total_text_format,:n        break_column_text_format,+
1:n        break_before_row,:n        break_generic_column,:n        break_aft+
1er_row,:n        break_type_flag,:n        break_repeat_heading_format:n     +
1 from wwv_flow_page_plugs:n      where id = p_region_id:n    :
1:
1REPORT_TOTAL:
1:::
1#SUM_COLUMN_HEADER# :
1TOTAL:
1DEFAULT_BREAK_FORMATTING:
1
: 1LOWER: 1: 1GET_CURRENT_ROW_TEMPLATE: 1P_DESC_TBL: 1DESC_TAB2: 1P_COL_VALUES: 1P_SHOW_NULL_AS: 1L_ROW_CONDITION: 1L_CURRENT_VALUE: 1COUNT: 1NOT_CONDITIONAL: 1EXIT: 1MOD: 1G_ROWNUM: 1IS NOT NULL: 1J: 1#: 1COL_NAME: 1#rownum#: 1#ROWNUM#: 1ODD_ROW: 1EVEN_ROW: 1WWV_FLOW_CHECK: 1CHECK_COND_PLSQL_EXPRESION: 1SHOW_PREVIEW: 1L_HEADER: 1HTP: 1INIT: 1OWA_UTIL: 1MIME_HEADER: 1text/html: 1HTTP_HEADER_CLOSE: 1T: 1HEADER_TEMPLATE: 1WWV_FLOW_TEMPLATES: 1WWV_FLOWS: 1FL: 1DEFAULT_PAGE_TEMPLATE: 1G_FLOW_ID: 1select t.header_template:n from wwv_flow_templates t, wwv_flows fl:n + 1 where t.id = fl.default_page_template and fl.id = wwv_flow.g_flow_id:n + 1 --where t.id = fl.webdb_template and fl.id = wwv_flow.g_flow_id:n : 1#ONLOAD#: 1#TITLE#: 1#NAVIGATION_BAR#: 1#FORM_OPEN#: 1#NOTIFICATION_MESSAGE#: 1#SUCCESS_MESSAGE#: 1#GLOBAL_NOTIFICATION#: 1#HEAD#: 1P: 1ACTIVATE_SORT_COLUMNS: 1L_IMAGE: 1L_IMAGE_ATTR: 1L_DEFAULT_SORT_COL_NUM: 1L_REQUEST: 1200: 1L_DEBUG: 1L_SORT_COL: 1L_SORT_COL_N_ORDER: 1L_FIRST_SORT_COL: 1L_ORDER_BY: 11000: 1L_SORT_BY_OLD: 1L_SORT_BY_NEW: 1L_DEFAULT_SORT_COLS: 1L_IMG_SRC: 1L_LAST_SORT_COL: 1L_REGION_ID: 1L_FIRST_SORT_SEQ: 1activate sort: 1TRUNC: 1fsp_sort_: 1desc: 1_: 1 : 1,: 1WWV_FLOW_PREFERENCES: 1GET_PREFERENCE: 1P_PREFERENCE: 1FSP: 1_P: 1G_FLOW_STEP_ID: 1_R: 1_SORT: 1G_REQUEST: 1NOT_LIKE: 1fsp_sort_%: 1G_FSP_REGION_ID: 1use_old_sort: 1fsp_sort: 1 order by : 1G_COLUMN_ALIAS_IDX: 1 desc: 1TRIM: 1N: 1_desc: 1G_DEBUG: 1::YES: 1DO_SUBSTITUTIONS: 1http:://: 1https:://: 1HTF: 1ANCHOR: 1f?p=: 1G_INSTANCE: 1ITE: 1::RP&fsp_region_id=: 1:
1WWV_RENDER_REPORT3.SORT_BY_THIS_COLUMN:
1SET_PREFERENCE:
1DETERMIN_COL_HEADINGS:
1P_PLUG_QUERY_HEADINGS:
1P_PLUG_QUERY_HEADINGS_TYPE:
1L_COL_HEADINGS:
1L_PLUG_QUERY_HEADINGS:
1determine column headings:
1FUNCTION_BODY_RETURNING_COLON_DELIMITED_LIST:
1FUNCTION_BODY_RETURNING_PIPE_DELIMITED_LIST:
1RUN_BLOCK:
1declare function x return varchar2 is begin :
1 return null; end; begin wwv_flow.g_value ::= x; end;:
1P_USER:
1G_VALUE:
1ROLLBACK:
1WWV_RENDER_REPORT3.ERR_DETERMINE_QUERY_HEADINGS:
1STRING_TO_TABLE2:
1ESC:
1|:
1SORT_ENABLED_COLON_DELMITED_LIST:
1NO_HEADINGS:
1NO:
1QUERY_COLUMNS:
1YES:
1QUERY_COLUMNS_INITCAP:
1INI:
199:
1COL:
1LPAD:
1GET_SINCE:
1P_DATE:
1DATE:
1L_DATE:
1G_SYSDATE:
1/:
1720:
1ROUND:
124:
1*:
160:
1.08333:
17:
1365:
1MONTHS_BETWEEN:
1GET_MD5_CHECKSUM:
1P_VALUES:
1L_MD5_CHECKSUM:
1L_VALUES:
150:
1<=:
1WWV_FLOW_ITEM:
1MD5_CHECKSUM:
1P_VALUE01:
1P_VALUE02:
1P_VALUE03:
1P_VALUE04:
1P_VALUE05:
1P_VALUE06:
16:
1P_VALUE07:
1P_VALUE08:
18:
1P_VALUE09:
19:
1P_VALUE10:
1P_VALUE11:
1P_VALUE12:
1P_VALUE13:
1P_VALUE14:
1P_VALUE15:
1P_VALUE16:
1P_VALUE17:
117:
1P_VALUE18:
118:
1P_VALUE19:
119:
1P_VALUE20:
120:
1P_VALUE21:
1P_VALUE22:
1P_VALUE23:
123:
1P_VALUE24:
1P_VALUE25:
125:
1P_VALUE26:
126:
1P_VALUE27:
127:
1P_VALUE28:
128:
1P_VALUE29:
129:
1P_VALUE30:
130:
1P_VALUE31:
1P_VALUE32:
132:
1P_VALUE33:
133:
1P_VALUE34:
134:
1P_VALUE35:
135:
1P_VALUE36:
136:
1P_VALUE37:
137:
1P_VALUE38:
138:
1P_VALUE39:
139:
1P_VALUE40:
140:
1P_VALUE41:
141:
1P_VALUE42:
142:
1P_VALUE43:
143:
1P_VALUE44:
144:
1P_VALUE45:
145:
1P_VALUE46:
146:
1P_VALUE47:
147:
1P_VALUE48:
148:
1P_VALUE49:
149:
1P_VALUE50:
1GET_MRU_INFO:
1P_TYPE:
1L_PROCESS_SQL:
1L_FLOW_ID:
1L_PROCESS_VALUES:
1PROCESS_SQL_CLOB:
1PROCESS_SQL:
1WWV_FLOW_STEP_PROCESSING:
1R:
1FLOW_ID:
1PAGE_ID:
1FLOW_STEP_ID:
1PROCESS_TYPE:
1select wwv_flow_utilities.clob_to_varchar2(process_sql_clob) process_sql:n   +
1       from wwv_flow_step_processing p, wwv_flow_page_plugs r :n          whe+
1re r.id = p_region_id :n          and   r.flow_id = p.flow_id:n          and +
1  r.page_id = p.flow_step_id:n          and   p.process_type = 'MULTI_ROW_UPD+
1ATE':n      :
1:::::::::
1OWNER:
1#OWNER#:
1PK1:
1PK2:
1ADD_ROWS:
1L_QRY_INSERT_ROWS:
1L_QRY_UPDATE_ROWS:
1L_MIN_ROW:
1L_MAX_ROW:
1L_TOTAL_ROWS:
1L_ADD_ROWS:
1L_HAS_STATE:
1L_DATA_TYPE:
1WWV_FLOW_DISP_PAGE_PLUGS:
1GET_PAGINATION_DATA:
1select :
1COLUMN_ALIAS:
1COLUMN_DEFAULT_TYPE:
1COLUMN_DEFAULT:
1WWV_FLOW_REGION_REPORT_COLUMN:
1REGION_ID:
1QUERY_COLUMN_ID:
1select column_alias, column_default_type, column_default :n            from w+
1wv_flow_region_report_column:n            where region_id = p_region_id:n    +
1        order by query_column_id:n          :
1 CHECK$01: 1!=: 1CENTER: 1 align=": 1#ALIGN#: 1LEFT: 1#ALIGNMENT#: 1#COLUMN_HEADER_NAME#: 1_#REPEAT#: 1#ROWCOUNT#: 1#COLCOUNT#: 1,OMIT: 1GET_REPORT_FOOTER: 1P_ROW_TEMPLATE_AFTER_ROWS: 1DO_COL_NAME_REPLACEMENTS: 1P_COL_NAMES: 1P_TEXT: 1P_STRIP_HTML: 1INTERNET_PAGINATION: 1P_FORMAT: 1SEARCH_ENGINE: 1P_PAGINATION_ROW: 1P_ROWS_PER_PAGE: 1P_FIRST_ROW: 1P_ROWS_FETCHED: 1P_ROWS_COUNTED: 1P_MAX_ROWS: 1P_ROW_COUNT_MAX: 1P_SETS_ON_PAGE: 1P_MORE_DATA_FOUND: 1L_PAGE: 1L_PAGINATION_ROW: 1L_PG_TXT_LINK: 1L_PREV_LINK: 1L_PAGINATION_SET: 1L_NEXT_LINK: 1L_FIRST_ROW: 1L_LAST_ROW: 1L_SPAN_COUNT: 1L_SET: 1L_ROW_OFFSET: 1L_PAGE_OFFSET: 1L_PREVIOUS_FIRST_ROW: 1L_SETS_ON_PAGE: 1L_SELECT_URL1: 1L_SELECT_URL2: 1ROW_RANGES: 1CEIL: 1::pg_R_: 1::&DEBUG.&pg_min_row=: 1&pg_rows_fetched=: 1G_PREVIOUS_LINK: 1::&DEBUG.: 1&pg_min_row=: 1&pg_max_rows=: 1#LINK#: 1 : 1G_NEXT_LINK: 1>=: 1#TEXT#: 1#PREVSET#: 1#NEXTSET#: 1ROW_RANGES_IN_SELECT_LIST: 1: 1rows loop:: : 1 row(s): 1FETCH_ROWS: 1 rowStyle[: 1]='';: 1 rowStyleHover[: 1 rowActive[: 1]='N';: 1COLUMN_VALUE: 1PICK_DATE: 1SINCE: 1[datatype]: 1H: 1: 1: 1:n : 1WWV_FLOW_LOG: 1G_TOTAL_ROWS_FETCHED: 1
: 1: 1: 1
previous: 114: 1default:: look 4: 1#COLUMN_VALUE##COLUMN_VALUE#
: 1
 #CSV_LI+ 1NK#
: 1
: 1 >: 1< : 115: 1default:: look 5: 1#eeeeee: 121: 1export:: CSV: 122: 1export:: XML: 1 <#COLUMN_HEADER#>#COLUMN_VALUE#: 1: 1: 131: 1export:: FOP: 1: 1: 1: 1: 1SET_TEMPLATE: 1P_ROW_TEMPLATE_ID: 1P_COLUMN_HEADING_TEMPLATE: 1OUT: 1P_ROW_TEMPLATE: 1P_ROW_TEMPLATES: 1VC_ARR2: 1P_ROW_TEMPLATE_CONDITIONS: 1P_ROW_TEMPLATE_DISPLAY_COND: 1P_MULTIPLE_TEMPLATES_EXIST: 1P_SHOW_NULL_COLS: 1L_ROW_TEMPLATE_REC: 1L_ROW_START: 1L_ROW_END: 1L_COL_START: 1L_COL_END: 1TABLE: 1: 1
#PREVSET##PREVLINK##TEXT##NEXTLINK##NEXTSET#

#COLUMN_VALUE#

: 1