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_UTIL_PVT dependencies on DBMS_SQL

Line 150: l_key_tbl DBMS_SQL.NUMBER_TABLE;

146: l_err_loc PLS_INTEGER;
147:
148: ----- Start of declaring columns selected in the cursor -----
149:
150: l_key_tbl DBMS_SQL.NUMBER_TABLE;
151: l_index_num1_tbl DBMS_SQL.NUMBER_TABLE;
152: l_index_num2_tbl DBMS_SQL.NUMBER_TABLE;
153: l_index_char1_tbl DBMS_SQL.VARCHAR2_TABLE;
154: l_index_char2_tbl DBMS_SQL.VARCHAR2_TABLE;

Line 151: l_index_num1_tbl DBMS_SQL.NUMBER_TABLE;

147:
148: ----- Start of declaring columns selected in the cursor -----
149:
150: l_key_tbl DBMS_SQL.NUMBER_TABLE;
151: l_index_num1_tbl DBMS_SQL.NUMBER_TABLE;
152: l_index_num2_tbl DBMS_SQL.NUMBER_TABLE;
153: l_index_char1_tbl DBMS_SQL.VARCHAR2_TABLE;
154: l_index_char2_tbl DBMS_SQL.VARCHAR2_TABLE;
155: l_char1_tbl DBMS_SQL.NUMBER_TABLE;

Line 152: l_index_num2_tbl DBMS_SQL.NUMBER_TABLE;

148: ----- Start of declaring columns selected in the cursor -----
149:
150: l_key_tbl DBMS_SQL.NUMBER_TABLE;
151: l_index_num1_tbl DBMS_SQL.NUMBER_TABLE;
152: l_index_num2_tbl DBMS_SQL.NUMBER_TABLE;
153: l_index_char1_tbl DBMS_SQL.VARCHAR2_TABLE;
154: l_index_char2_tbl DBMS_SQL.VARCHAR2_TABLE;
155: l_char1_tbl DBMS_SQL.NUMBER_TABLE;
156: l_char2_tbl DBMS_SQL.VARCHAR2_TABLE;

Line 153: l_index_char1_tbl DBMS_SQL.VARCHAR2_TABLE;

149:
150: l_key_tbl DBMS_SQL.NUMBER_TABLE;
151: l_index_num1_tbl DBMS_SQL.NUMBER_TABLE;
152: l_index_num2_tbl DBMS_SQL.NUMBER_TABLE;
153: l_index_char1_tbl DBMS_SQL.VARCHAR2_TABLE;
154: l_index_char2_tbl DBMS_SQL.VARCHAR2_TABLE;
155: l_char1_tbl DBMS_SQL.NUMBER_TABLE;
156: l_char2_tbl DBMS_SQL.VARCHAR2_TABLE;
157: l_char3_tbl DBMS_SQL.VARCHAR2_TABLE;

Line 154: l_index_char2_tbl DBMS_SQL.VARCHAR2_TABLE;

150: l_key_tbl DBMS_SQL.NUMBER_TABLE;
151: l_index_num1_tbl DBMS_SQL.NUMBER_TABLE;
152: l_index_num2_tbl DBMS_SQL.NUMBER_TABLE;
153: l_index_char1_tbl DBMS_SQL.VARCHAR2_TABLE;
154: l_index_char2_tbl DBMS_SQL.VARCHAR2_TABLE;
155: l_char1_tbl DBMS_SQL.NUMBER_TABLE;
156: l_char2_tbl DBMS_SQL.VARCHAR2_TABLE;
157: l_char3_tbl DBMS_SQL.VARCHAR2_TABLE;
158:

Line 155: l_char1_tbl DBMS_SQL.NUMBER_TABLE;

151: l_index_num1_tbl DBMS_SQL.NUMBER_TABLE;
152: l_index_num2_tbl DBMS_SQL.NUMBER_TABLE;
153: l_index_char1_tbl DBMS_SQL.VARCHAR2_TABLE;
154: l_index_char2_tbl DBMS_SQL.VARCHAR2_TABLE;
155: l_char1_tbl DBMS_SQL.NUMBER_TABLE;
156: l_char2_tbl DBMS_SQL.VARCHAR2_TABLE;
157: l_char3_tbl DBMS_SQL.VARCHAR2_TABLE;
158:
159: ------ End of declaring columns selected in the cursor ------

Line 156: l_char2_tbl DBMS_SQL.VARCHAR2_TABLE;

152: l_index_num2_tbl DBMS_SQL.NUMBER_TABLE;
153: l_index_char1_tbl DBMS_SQL.VARCHAR2_TABLE;
154: l_index_char2_tbl DBMS_SQL.VARCHAR2_TABLE;
155: l_char1_tbl DBMS_SQL.NUMBER_TABLE;
156: l_char2_tbl DBMS_SQL.VARCHAR2_TABLE;
157: l_char3_tbl DBMS_SQL.VARCHAR2_TABLE;
158:
159: ------ End of declaring columns selected in the cursor ------
160: BEGIN

Line 157: l_char3_tbl DBMS_SQL.VARCHAR2_TABLE;

153: l_index_char1_tbl DBMS_SQL.VARCHAR2_TABLE;
154: l_index_char2_tbl DBMS_SQL.VARCHAR2_TABLE;
155: l_char1_tbl DBMS_SQL.NUMBER_TABLE;
156: l_char2_tbl DBMS_SQL.VARCHAR2_TABLE;
157: l_char3_tbl DBMS_SQL.VARCHAR2_TABLE;
158:
159: ------ End of declaring columns selected in the cursor ------
160: BEGIN
161: l_err_loc := 100;

Line 238: l_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;

234: l_err_loc PLS_INTEGER;
235:
236: ----- Start of declaring columns selected in the cursor -----
237:
238: l_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;
239: l_organization_id_tbl DBMS_SQL.NUMBER_TABLE;
240: l_revision_id_tbl DBMS_SQL.NUMBER_TABLE;
241: l_category_id_tbl DBMS_SQL.NUMBER_TABLE;
242: l_category_set_id_tbl DBMS_SQL.NUMBER_TABLE;

Line 239: l_organization_id_tbl DBMS_SQL.NUMBER_TABLE;

235:
236: ----- Start of declaring columns selected in the cursor -----
237:
238: l_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;
239: l_organization_id_tbl DBMS_SQL.NUMBER_TABLE;
240: l_revision_id_tbl DBMS_SQL.NUMBER_TABLE;
241: l_category_id_tbl DBMS_SQL.NUMBER_TABLE;
242: l_category_set_id_tbl DBMS_SQL.NUMBER_TABLE;
243:

Line 240: l_revision_id_tbl DBMS_SQL.NUMBER_TABLE;

236: ----- Start of declaring columns selected in the cursor -----
237:
238: l_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;
239: l_organization_id_tbl DBMS_SQL.NUMBER_TABLE;
240: l_revision_id_tbl DBMS_SQL.NUMBER_TABLE;
241: l_category_id_tbl DBMS_SQL.NUMBER_TABLE;
242: l_category_set_id_tbl DBMS_SQL.NUMBER_TABLE;
243:
244: ------ End of declaring columns selected in the cursor ------

Line 241: l_category_id_tbl DBMS_SQL.NUMBER_TABLE;

237:
238: l_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;
239: l_organization_id_tbl DBMS_SQL.NUMBER_TABLE;
240: l_revision_id_tbl DBMS_SQL.NUMBER_TABLE;
241: l_category_id_tbl DBMS_SQL.NUMBER_TABLE;
242: l_category_set_id_tbl DBMS_SQL.NUMBER_TABLE;
243:
244: ------ End of declaring columns selected in the cursor ------
245: BEGIN

Line 242: l_category_set_id_tbl DBMS_SQL.NUMBER_TABLE;

238: l_inventory_item_id_tbl DBMS_SQL.NUMBER_TABLE;
239: l_organization_id_tbl DBMS_SQL.NUMBER_TABLE;
240: l_revision_id_tbl DBMS_SQL.NUMBER_TABLE;
241: l_category_id_tbl DBMS_SQL.NUMBER_TABLE;
242: l_category_set_id_tbl DBMS_SQL.NUMBER_TABLE;
243:
244: ------ End of declaring columns selected in the cursor ------
245: BEGIN
246: l_err_loc := 100;

Line 349: ( p_table IN DBMS_SQL.NUMBER_TABLE ,

345: --------------------------------------------------------------
346: -- Get PL/SQL Table element Start --
347: --------------------------------------------------------------
348: FUNCTION getTableElement
349: ( p_table IN DBMS_SQL.NUMBER_TABLE ,
350: p_index IN BINARY_INTEGER
351: )
352: RETURN VARCHAR2
353: IS

Line 370: ( p_table IN DBMS_SQL.VARCHAR2_TABLE ,

366: RETURN l_string;
367: END getTableElement;
368:
369: FUNCTION getTableElement
370: ( p_table IN DBMS_SQL.VARCHAR2_TABLE ,
371: p_index IN BINARY_INTEGER
372: )
373: RETURN VARCHAR2
374: IS

Line 390: ( p_table IN DBMS_SQL.UROWID_TABLE ,

386: RETURN l_string;
387: END getTableElement;
388:
389: FUNCTION getTableElement
390: ( p_table IN DBMS_SQL.UROWID_TABLE ,
391: p_index IN BINARY_INTEGER
392: )
393: RETURN VARCHAR2
394: IS

Line 411: ( p_table IN DBMS_SQL.DATE_TABLE ,

407: RETURN l_string;
408: END getTableElement;
409:
410: FUNCTION getTableElement
411: ( p_table IN DBMS_SQL.DATE_TABLE ,
412: p_index IN BINARY_INTEGER
413: )
414: RETURN VARCHAR2
415: IS

Line 432: ( p_table IN DBMS_SQL.NUMBER_TABLE ,

428: RETURN l_string;
429: END getTableElement;
430:
431: FUNCTION checkValueExistsInTable
432: ( p_table IN DBMS_SQL.NUMBER_TABLE ,
433: p_value IN NUMBER
434: )
435: RETURN VARCHAR2
436: IS

Line 665: l_appl_column_name_tbl DBMS_SQL.VARCHAR2_TABLE;

661: PROCEDURE getMIConcatSegmentClause
662: IS
663: l_api_name CONSTANT VARCHAR2(30) := 'getMIConcatSegmentClause';
664: l_err_loc PLS_INTEGER;
665: l_appl_column_name_tbl DBMS_SQL.VARCHAR2_TABLE;
666: l_delimiter VARCHAR2(1);
667: BEGIN
668: l_err_loc := 100;
669: SELECT application_column_name