eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ICX_CAT_R12_DATA_EXCEP_RPT_PVT dependencies on DBMS_SQL

Line 23: PROCEDURE populate_upg_error_msgs(p_interface_header_id_tbl IN DBMS_SQL.NUMBER_TABLE);

19: p_language IN VARCHAR2,
20: x_lines_XML IN OUT NOCOPY CLOB);
21: PROCEDURE populate_namevalue_xmltag(p_category_id IN NUMBER);
22: PROCEDURE populate_language_map;
23: PROCEDURE populate_upg_error_msgs(p_interface_header_id_tbl IN DBMS_SQL.NUMBER_TABLE);
24: -- Private Functions declaration End
25:
26: /**
27: ** Procedure : cleanup_tables

Line 79: l_language_code_tbl DBMS_SQL.VARCHAR2_TABLE;

75: ** Synopsis : To populate the languages map
76: **/
77: PROCEDURE populate_language_map
78: IS
79: l_language_code_tbl DBMS_SQL.VARCHAR2_TABLE;
80: l_iso_territory_tbl DBMS_SQL.VARCHAR2_TABLE;
81: l_iso_language_tbl DBMS_SQL.VARCHAR2_TABLE;
82: l_nls_territory_tbl DBMS_SQL.VARCHAR2_TABLE;
83: l_nls_language_tbl DBMS_SQL.VARCHAR2_TABLE;

Line 80: l_iso_territory_tbl DBMS_SQL.VARCHAR2_TABLE;

76: **/
77: PROCEDURE populate_language_map
78: IS
79: l_language_code_tbl DBMS_SQL.VARCHAR2_TABLE;
80: l_iso_territory_tbl DBMS_SQL.VARCHAR2_TABLE;
81: l_iso_language_tbl DBMS_SQL.VARCHAR2_TABLE;
82: l_nls_territory_tbl DBMS_SQL.VARCHAR2_TABLE;
83: l_nls_language_tbl DBMS_SQL.VARCHAR2_TABLE;
84: l_progress pls_integer;

Line 81: l_iso_language_tbl DBMS_SQL.VARCHAR2_TABLE;

77: PROCEDURE populate_language_map
78: IS
79: l_language_code_tbl DBMS_SQL.VARCHAR2_TABLE;
80: l_iso_territory_tbl DBMS_SQL.VARCHAR2_TABLE;
81: l_iso_language_tbl DBMS_SQL.VARCHAR2_TABLE;
82: l_nls_territory_tbl DBMS_SQL.VARCHAR2_TABLE;
83: l_nls_language_tbl DBMS_SQL.VARCHAR2_TABLE;
84: l_progress pls_integer;
85: l_log_string varchar2(400);

Line 82: l_nls_territory_tbl DBMS_SQL.VARCHAR2_TABLE;

78: IS
79: l_language_code_tbl DBMS_SQL.VARCHAR2_TABLE;
80: l_iso_territory_tbl DBMS_SQL.VARCHAR2_TABLE;
81: l_iso_language_tbl DBMS_SQL.VARCHAR2_TABLE;
82: l_nls_territory_tbl DBMS_SQL.VARCHAR2_TABLE;
83: l_nls_language_tbl DBMS_SQL.VARCHAR2_TABLE;
84: l_progress pls_integer;
85: l_log_string varchar2(400);
86: l_module_name varchar2(200);

Line 83: l_nls_language_tbl DBMS_SQL.VARCHAR2_TABLE;

79: l_language_code_tbl DBMS_SQL.VARCHAR2_TABLE;
80: l_iso_territory_tbl DBMS_SQL.VARCHAR2_TABLE;
81: l_iso_language_tbl DBMS_SQL.VARCHAR2_TABLE;
82: l_nls_territory_tbl DBMS_SQL.VARCHAR2_TABLE;
83: l_nls_language_tbl DBMS_SQL.VARCHAR2_TABLE;
84: l_progress pls_integer;
85: l_log_string varchar2(400);
86: l_module_name varchar2(200);
87: l_proc_name varchar2(100) := 'populate_language_map';

Line 178: l_interface_header_id_tbl DBMS_SQL.NUMBER_TABLE;

174: AND language = poai.language)
175: ORDER BY pohi.interface_header_id;
176:
177: --Tables for fetching Individual values from cursor
178: l_interface_header_id_tbl DBMS_SQL.NUMBER_TABLE;
179: l_vendor_id_tbl DBMS_SQL.NUMBER_TABLE;
180: l_vendor_site_id_tbl DBMS_SQL.NUMBER_TABLE;
181: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;
182: l_currency_code_tbl DBMS_SQL.VARCHAR2_TABLE;

Line 179: l_vendor_id_tbl DBMS_SQL.NUMBER_TABLE;

175: ORDER BY pohi.interface_header_id;
176:
177: --Tables for fetching Individual values from cursor
178: l_interface_header_id_tbl DBMS_SQL.NUMBER_TABLE;
179: l_vendor_id_tbl DBMS_SQL.NUMBER_TABLE;
180: l_vendor_site_id_tbl DBMS_SQL.NUMBER_TABLE;
181: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;
182: l_currency_code_tbl DBMS_SQL.VARCHAR2_TABLE;
183: l_contract_num_tbl DBMS_SQL.NUMBER_TABLE;

Line 180: l_vendor_site_id_tbl DBMS_SQL.NUMBER_TABLE;

176:
177: --Tables for fetching Individual values from cursor
178: l_interface_header_id_tbl DBMS_SQL.NUMBER_TABLE;
179: l_vendor_id_tbl DBMS_SQL.NUMBER_TABLE;
180: l_vendor_site_id_tbl DBMS_SQL.NUMBER_TABLE;
181: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;
182: l_currency_code_tbl DBMS_SQL.VARCHAR2_TABLE;
183: l_contract_num_tbl DBMS_SQL.NUMBER_TABLE;
184: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;

Line 181: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;

177: --Tables for fetching Individual values from cursor
178: l_interface_header_id_tbl DBMS_SQL.NUMBER_TABLE;
179: l_vendor_id_tbl DBMS_SQL.NUMBER_TABLE;
180: l_vendor_site_id_tbl DBMS_SQL.NUMBER_TABLE;
181: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;
182: l_currency_code_tbl DBMS_SQL.VARCHAR2_TABLE;
183: l_contract_num_tbl DBMS_SQL.NUMBER_TABLE;
184: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;
185: l_progress PLS_INTEGER;

Line 182: l_currency_code_tbl DBMS_SQL.VARCHAR2_TABLE;

178: l_interface_header_id_tbl DBMS_SQL.NUMBER_TABLE;
179: l_vendor_id_tbl DBMS_SQL.NUMBER_TABLE;
180: l_vendor_site_id_tbl DBMS_SQL.NUMBER_TABLE;
181: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;
182: l_currency_code_tbl DBMS_SQL.VARCHAR2_TABLE;
183: l_contract_num_tbl DBMS_SQL.NUMBER_TABLE;
184: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;
185: l_progress PLS_INTEGER;
186: l_log_string varchar2(400);

Line 183: l_contract_num_tbl DBMS_SQL.NUMBER_TABLE;

179: l_vendor_id_tbl DBMS_SQL.NUMBER_TABLE;
180: l_vendor_site_id_tbl DBMS_SQL.NUMBER_TABLE;
181: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;
182: l_currency_code_tbl DBMS_SQL.VARCHAR2_TABLE;
183: l_contract_num_tbl DBMS_SQL.NUMBER_TABLE;
184: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;
185: l_progress PLS_INTEGER;
186: l_log_string varchar2(400);
187: l_module_name varchar2(200);

Line 184: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;

180: l_vendor_site_id_tbl DBMS_SQL.NUMBER_TABLE;
181: l_org_id_tbl DBMS_SQL.NUMBER_TABLE;
182: l_currency_code_tbl DBMS_SQL.VARCHAR2_TABLE;
183: l_contract_num_tbl DBMS_SQL.NUMBER_TABLE;
184: l_language_tbl DBMS_SQL.VARCHAR2_TABLE;
185: l_progress PLS_INTEGER;
186: l_log_string varchar2(400);
187: l_module_name varchar2(200);
188: l_proc_name varchar2(100) := 'process_data_exceptions_report';

Line 346: PROCEDURE populate_catalog_files(p_interface_header_id_tbl IN DBMS_SQL.NUMBER_TABLE,

342: ** p_currency_code_tbl
343: ** p_contract_num_tbl
344: ** p_language_tbl
345: **/
346: PROCEDURE populate_catalog_files(p_interface_header_id_tbl IN DBMS_SQL.NUMBER_TABLE,
347: p_vendor_id_tbl IN DBMS_SQL.NUMBER_TABLE,
348: p_vendor_site_id_tbl IN DBMS_SQL.NUMBER_TABLE,
349: p_org_id_tbl IN DBMS_SQL.NUMBER_TABLE,
350: p_currency_code_tbl IN DBMS_SQL.VARCHAR2_TABLE,

Line 347: p_vendor_id_tbl IN DBMS_SQL.NUMBER_TABLE,

343: ** p_contract_num_tbl
344: ** p_language_tbl
345: **/
346: PROCEDURE populate_catalog_files(p_interface_header_id_tbl IN DBMS_SQL.NUMBER_TABLE,
347: p_vendor_id_tbl IN DBMS_SQL.NUMBER_TABLE,
348: p_vendor_site_id_tbl IN DBMS_SQL.NUMBER_TABLE,
349: p_org_id_tbl IN DBMS_SQL.NUMBER_TABLE,
350: p_currency_code_tbl IN DBMS_SQL.VARCHAR2_TABLE,
351: p_contract_num_tbl IN DBMS_SQL.NUMBER_TABLE,

Line 348: p_vendor_site_id_tbl IN DBMS_SQL.NUMBER_TABLE,

344: ** p_language_tbl
345: **/
346: PROCEDURE populate_catalog_files(p_interface_header_id_tbl IN DBMS_SQL.NUMBER_TABLE,
347: p_vendor_id_tbl IN DBMS_SQL.NUMBER_TABLE,
348: p_vendor_site_id_tbl IN DBMS_SQL.NUMBER_TABLE,
349: p_org_id_tbl IN DBMS_SQL.NUMBER_TABLE,
350: p_currency_code_tbl IN DBMS_SQL.VARCHAR2_TABLE,
351: p_contract_num_tbl IN DBMS_SQL.NUMBER_TABLE,
352: p_language_tbl IN DBMS_SQL.VARCHAR2_TABLE)

Line 349: p_org_id_tbl IN DBMS_SQL.NUMBER_TABLE,

345: **/
346: PROCEDURE populate_catalog_files(p_interface_header_id_tbl IN DBMS_SQL.NUMBER_TABLE,
347: p_vendor_id_tbl IN DBMS_SQL.NUMBER_TABLE,
348: p_vendor_site_id_tbl IN DBMS_SQL.NUMBER_TABLE,
349: p_org_id_tbl IN DBMS_SQL.NUMBER_TABLE,
350: p_currency_code_tbl IN DBMS_SQL.VARCHAR2_TABLE,
351: p_contract_num_tbl IN DBMS_SQL.NUMBER_TABLE,
352: p_language_tbl IN DBMS_SQL.VARCHAR2_TABLE)
353: IS

Line 350: p_currency_code_tbl IN DBMS_SQL.VARCHAR2_TABLE,

346: PROCEDURE populate_catalog_files(p_interface_header_id_tbl IN DBMS_SQL.NUMBER_TABLE,
347: p_vendor_id_tbl IN DBMS_SQL.NUMBER_TABLE,
348: p_vendor_site_id_tbl IN DBMS_SQL.NUMBER_TABLE,
349: p_org_id_tbl IN DBMS_SQL.NUMBER_TABLE,
350: p_currency_code_tbl IN DBMS_SQL.VARCHAR2_TABLE,
351: p_contract_num_tbl IN DBMS_SQL.NUMBER_TABLE,
352: p_language_tbl IN DBMS_SQL.VARCHAR2_TABLE)
353: IS
354: -- List of category ids for which the line exists in

Line 351: p_contract_num_tbl IN DBMS_SQL.NUMBER_TABLE,

347: p_vendor_id_tbl IN DBMS_SQL.NUMBER_TABLE,
348: p_vendor_site_id_tbl IN DBMS_SQL.NUMBER_TABLE,
349: p_org_id_tbl IN DBMS_SQL.NUMBER_TABLE,
350: p_currency_code_tbl IN DBMS_SQL.VARCHAR2_TABLE,
351: p_contract_num_tbl IN DBMS_SQL.NUMBER_TABLE,
352: p_language_tbl IN DBMS_SQL.VARCHAR2_TABLE)
353: IS
354: -- List of category ids for which the line exists in
355: -- interface errors and attr values tlp tables.

Line 352: p_language_tbl IN DBMS_SQL.VARCHAR2_TABLE)

348: p_vendor_site_id_tbl IN DBMS_SQL.NUMBER_TABLE,
349: p_org_id_tbl IN DBMS_SQL.NUMBER_TABLE,
350: p_currency_code_tbl IN DBMS_SQL.VARCHAR2_TABLE,
351: p_contract_num_tbl IN DBMS_SQL.NUMBER_TABLE,
352: p_language_tbl IN DBMS_SQL.VARCHAR2_TABLE)
353: IS
354: -- List of category ids for which the line exists in
355: -- interface errors and attr values tlp tables.
356: Cursor category_ids_cursor(p_interface_header_id number,

Line 372: l_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;

368: WHERE poai.interface_header_id = poli.interface_header_id
369: AND poai.interface_line_id = poli.interface_line_id
370: AND poai.language = p_language);
371:
372: l_ip_category_id_tbl DBMS_SQL.NUMBER_TABLE;
373: l_mainXML CLOB;
374: l_headerXML CLOB;
375: l_linesXML CLOB;
376:

Line 519: PROCEDURE populate_upg_error_msgs(p_interface_header_id_tbl IN DBMS_SQL.NUMBER_TABLE)

515: ** ICX_CAT_R12_UPG_Error_Msgs Table.
516: ** Parameter:
517: ** IN p_interface_header_id_tbl --table of interface_header_ids
518: **/
519: PROCEDURE populate_upg_error_msgs(p_interface_header_id_tbl IN DBMS_SQL.NUMBER_TABLE)
520: IS
521: --cursor for fetching column value to be populated
522: -- as token value in the error messages table
523: CURSOR interface_errors_cursor(p_interface_header_id po_interface_errors.INTERFACE_HEADER_ID%TYPE)

Line 540: l_po_msg_tbl DBMS_SQL.VARCHAR2_TABLE;

536: GROUP BY error_message_name
537: CONNECT BY prev = PRIOR curr AND error_message_name = PRIOR error_message_name
538: START WITH curr = 1;
539:
540: l_po_msg_tbl DBMS_SQL.VARCHAR2_TABLE;
541: l_column_value_tbl DBMS_SQL.VARCHAR2_TABLE;
542: l_interface_header_id NUMBER;
543: l_prev_interface_header_id NUMBER := 0;
544: l_progress PLS_integer;

Line 541: l_column_value_tbl DBMS_SQL.VARCHAR2_TABLE;

537: CONNECT BY prev = PRIOR curr AND error_message_name = PRIOR error_message_name
538: START WITH curr = 1;
539:
540: l_po_msg_tbl DBMS_SQL.VARCHAR2_TABLE;
541: l_column_value_tbl DBMS_SQL.VARCHAR2_TABLE;
542: l_interface_header_id NUMBER;
543: l_prev_interface_header_id NUMBER := 0;
544: l_progress PLS_integer;
545: l_log_string varchar2(400);