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

Line 28: gAddRtCategoryIds DBMS_SQL.NUMBER_TABLE;

24:
25: --------------------------------------------------------------
26: -- Global Tables --
27: --------------------------------------------------------------
28: gAddRtCategoryIds DBMS_SQL.NUMBER_TABLE;
29: gAddCategoryKeys DBMS_SQL.VARCHAR2_TABLE;
30: gAddCategoryNames DBMS_SQL.VARCHAR2_TABLE;
31: gAddLanguages DBMS_SQL.VARCHAR2_TABLE;
32: gAddSourceLangs DBMS_SQL.VARCHAR2_TABLE;

Line 29: gAddCategoryKeys DBMS_SQL.VARCHAR2_TABLE;

25: --------------------------------------------------------------
26: -- Global Tables --
27: --------------------------------------------------------------
28: gAddRtCategoryIds DBMS_SQL.NUMBER_TABLE;
29: gAddCategoryKeys DBMS_SQL.VARCHAR2_TABLE;
30: gAddCategoryNames DBMS_SQL.VARCHAR2_TABLE;
31: gAddLanguages DBMS_SQL.VARCHAR2_TABLE;
32: gAddSourceLangs DBMS_SQL.VARCHAR2_TABLE;
33: gAddNewRtCategoryIds DBMS_SQL.NUMBER_TABLE;

Line 30: gAddCategoryNames DBMS_SQL.VARCHAR2_TABLE;

26: -- Global Tables --
27: --------------------------------------------------------------
28: gAddRtCategoryIds DBMS_SQL.NUMBER_TABLE;
29: gAddCategoryKeys DBMS_SQL.VARCHAR2_TABLE;
30: gAddCategoryNames DBMS_SQL.VARCHAR2_TABLE;
31: gAddLanguages DBMS_SQL.VARCHAR2_TABLE;
32: gAddSourceLangs DBMS_SQL.VARCHAR2_TABLE;
33: gAddNewRtCategoryIds DBMS_SQL.NUMBER_TABLE;
34: gAddNewCategoryKeys DBMS_SQL.VARCHAR2_TABLE;

Line 31: gAddLanguages DBMS_SQL.VARCHAR2_TABLE;

27: --------------------------------------------------------------
28: gAddRtCategoryIds DBMS_SQL.NUMBER_TABLE;
29: gAddCategoryKeys DBMS_SQL.VARCHAR2_TABLE;
30: gAddCategoryNames DBMS_SQL.VARCHAR2_TABLE;
31: gAddLanguages DBMS_SQL.VARCHAR2_TABLE;
32: gAddSourceLangs DBMS_SQL.VARCHAR2_TABLE;
33: gAddNewRtCategoryIds DBMS_SQL.NUMBER_TABLE;
34: gAddNewCategoryKeys DBMS_SQL.VARCHAR2_TABLE;
35:

Line 32: gAddSourceLangs DBMS_SQL.VARCHAR2_TABLE;

28: gAddRtCategoryIds DBMS_SQL.NUMBER_TABLE;
29: gAddCategoryKeys DBMS_SQL.VARCHAR2_TABLE;
30: gAddCategoryNames DBMS_SQL.VARCHAR2_TABLE;
31: gAddLanguages DBMS_SQL.VARCHAR2_TABLE;
32: gAddSourceLangs DBMS_SQL.VARCHAR2_TABLE;
33: gAddNewRtCategoryIds DBMS_SQL.NUMBER_TABLE;
34: gAddNewCategoryKeys DBMS_SQL.VARCHAR2_TABLE;
35:
36: gUpdateRtCategoryIds DBMS_SQL.NUMBER_TABLE;

Line 33: gAddNewRtCategoryIds DBMS_SQL.NUMBER_TABLE;

29: gAddCategoryKeys DBMS_SQL.VARCHAR2_TABLE;
30: gAddCategoryNames DBMS_SQL.VARCHAR2_TABLE;
31: gAddLanguages DBMS_SQL.VARCHAR2_TABLE;
32: gAddSourceLangs DBMS_SQL.VARCHAR2_TABLE;
33: gAddNewRtCategoryIds DBMS_SQL.NUMBER_TABLE;
34: gAddNewCategoryKeys DBMS_SQL.VARCHAR2_TABLE;
35:
36: gUpdateRtCategoryIds DBMS_SQL.NUMBER_TABLE;
37: gUpdateCategoryKeys DBMS_SQL.VARCHAR2_TABLE;

Line 34: gAddNewCategoryKeys DBMS_SQL.VARCHAR2_TABLE;

30: gAddCategoryNames DBMS_SQL.VARCHAR2_TABLE;
31: gAddLanguages DBMS_SQL.VARCHAR2_TABLE;
32: gAddSourceLangs DBMS_SQL.VARCHAR2_TABLE;
33: gAddNewRtCategoryIds DBMS_SQL.NUMBER_TABLE;
34: gAddNewCategoryKeys DBMS_SQL.VARCHAR2_TABLE;
35:
36: gUpdateRtCategoryIds DBMS_SQL.NUMBER_TABLE;
37: gUpdateCategoryKeys DBMS_SQL.VARCHAR2_TABLE;
38: gUpdateCategoryNames DBMS_SQL.VARCHAR2_TABLE;

Line 36: gUpdateRtCategoryIds DBMS_SQL.NUMBER_TABLE;

32: gAddSourceLangs DBMS_SQL.VARCHAR2_TABLE;
33: gAddNewRtCategoryIds DBMS_SQL.NUMBER_TABLE;
34: gAddNewCategoryKeys DBMS_SQL.VARCHAR2_TABLE;
35:
36: gUpdateRtCategoryIds DBMS_SQL.NUMBER_TABLE;
37: gUpdateCategoryKeys DBMS_SQL.VARCHAR2_TABLE;
38: gUpdateCategoryNames DBMS_SQL.VARCHAR2_TABLE;
39: gUpdateLanguages DBMS_SQL.VARCHAR2_TABLE;
40: gUpdateSourceLangs DBMS_SQL.VARCHAR2_TABLE;

Line 37: gUpdateCategoryKeys DBMS_SQL.VARCHAR2_TABLE;

33: gAddNewRtCategoryIds DBMS_SQL.NUMBER_TABLE;
34: gAddNewCategoryKeys DBMS_SQL.VARCHAR2_TABLE;
35:
36: gUpdateRtCategoryIds DBMS_SQL.NUMBER_TABLE;
37: gUpdateCategoryKeys DBMS_SQL.VARCHAR2_TABLE;
38: gUpdateCategoryNames DBMS_SQL.VARCHAR2_TABLE;
39: gUpdateLanguages DBMS_SQL.VARCHAR2_TABLE;
40: gUpdateSourceLangs DBMS_SQL.VARCHAR2_TABLE;
41:

Line 38: gUpdateCategoryNames DBMS_SQL.VARCHAR2_TABLE;

34: gAddNewCategoryKeys DBMS_SQL.VARCHAR2_TABLE;
35:
36: gUpdateRtCategoryIds DBMS_SQL.NUMBER_TABLE;
37: gUpdateCategoryKeys DBMS_SQL.VARCHAR2_TABLE;
38: gUpdateCategoryNames DBMS_SQL.VARCHAR2_TABLE;
39: gUpdateLanguages DBMS_SQL.VARCHAR2_TABLE;
40: gUpdateSourceLangs DBMS_SQL.VARCHAR2_TABLE;
41:
42: --------------------------------------------------------------

Line 39: gUpdateLanguages DBMS_SQL.VARCHAR2_TABLE;

35:
36: gUpdateRtCategoryIds DBMS_SQL.NUMBER_TABLE;
37: gUpdateCategoryKeys DBMS_SQL.VARCHAR2_TABLE;
38: gUpdateCategoryNames DBMS_SQL.VARCHAR2_TABLE;
39: gUpdateLanguages DBMS_SQL.VARCHAR2_TABLE;
40: gUpdateSourceLangs DBMS_SQL.VARCHAR2_TABLE;
41:
42: --------------------------------------------------------------
43: -- Global PL/SQL Tables --

Line 40: gUpdateSourceLangs DBMS_SQL.VARCHAR2_TABLE;

36: gUpdateRtCategoryIds DBMS_SQL.NUMBER_TABLE;
37: gUpdateCategoryKeys DBMS_SQL.VARCHAR2_TABLE;
38: gUpdateCategoryNames DBMS_SQL.VARCHAR2_TABLE;
39: gUpdateLanguages DBMS_SQL.VARCHAR2_TABLE;
40: gUpdateSourceLangs DBMS_SQL.VARCHAR2_TABLE;
41:
42: --------------------------------------------------------------
43: -- Global PL/SQL Tables --
44: --------------------------------------------------------------

Line 123: xRowIds DBMS_SQL.UROWID_TABLE;

119: FROM icx_cat_items_tlp
120: WHERE primary_category_id = p_rt_category_id
121: AND language = p_language;
122:
123: xRowIds DBMS_SQL.UROWID_TABLE;
124:
125: BEGIN
126:
127: IF (ICX_POR_EXT_UTL.gDebugLevel >= ICX_POR_EXT_UTL.DETIL_LEVEL) THEN

Line 275: xRowIds DBMS_SQL.UROWID_TABLE;

271: FROM icx_cat_items_tlp
272: WHERE primary_category_id = p_rt_category_id
273: AND language = p_language;
274:
275: xRowIds DBMS_SQL.UROWID_TABLE;
276:
277: BEGIN
278:
279: IF (ICX_POR_EXT_UTL.gDebugLevel >= ICX_POR_EXT_UTL.DETIL_LEVEL) THEN

Line 658: xCategoryIds DBMS_SQL.NUMBER_TABLE;

654: pCursor IN tCursorType)
655: IS
656: xRtCategoryId number;
657:
658: xCategoryIds DBMS_SQL.NUMBER_TABLE;
659: xCategoryNames DBMS_SQL.VARCHAR2_TABLE;
660: xLanguages DBMS_SQL.VARCHAR2_TABLE;
661: xSourceLangs DBMS_SQL.VARCHAR2_TABLE;
662: xRtCategoryIds DBMS_SQL.NUMBER_TABLE;

Line 659: xCategoryNames DBMS_SQL.VARCHAR2_TABLE;

655: IS
656: xRtCategoryId number;
657:
658: xCategoryIds DBMS_SQL.NUMBER_TABLE;
659: xCategoryNames DBMS_SQL.VARCHAR2_TABLE;
660: xLanguages DBMS_SQL.VARCHAR2_TABLE;
661: xSourceLangs DBMS_SQL.VARCHAR2_TABLE;
662: xRtCategoryIds DBMS_SQL.NUMBER_TABLE;
663: xOldCategoryNames DBMS_SQL.VARCHAR2_TABLE;

Line 660: xLanguages DBMS_SQL.VARCHAR2_TABLE;

656: xRtCategoryId number;
657:
658: xCategoryIds DBMS_SQL.NUMBER_TABLE;
659: xCategoryNames DBMS_SQL.VARCHAR2_TABLE;
660: xLanguages DBMS_SQL.VARCHAR2_TABLE;
661: xSourceLangs DBMS_SQL.VARCHAR2_TABLE;
662: xRtCategoryIds DBMS_SQL.NUMBER_TABLE;
663: xOldCategoryNames DBMS_SQL.VARCHAR2_TABLE;
664:

Line 661: xSourceLangs DBMS_SQL.VARCHAR2_TABLE;

657:
658: xCategoryIds DBMS_SQL.NUMBER_TABLE;
659: xCategoryNames DBMS_SQL.VARCHAR2_TABLE;
660: xLanguages DBMS_SQL.VARCHAR2_TABLE;
661: xSourceLangs DBMS_SQL.VARCHAR2_TABLE;
662: xRtCategoryIds DBMS_SQL.NUMBER_TABLE;
663: xOldCategoryNames DBMS_SQL.VARCHAR2_TABLE;
664:
665: xErrLoc PLS_INTEGER := 100;

Line 662: xRtCategoryIds DBMS_SQL.NUMBER_TABLE;

658: xCategoryIds DBMS_SQL.NUMBER_TABLE;
659: xCategoryNames DBMS_SQL.VARCHAR2_TABLE;
660: xLanguages DBMS_SQL.VARCHAR2_TABLE;
661: xSourceLangs DBMS_SQL.VARCHAR2_TABLE;
662: xRtCategoryIds DBMS_SQL.NUMBER_TABLE;
663: xOldCategoryNames DBMS_SQL.VARCHAR2_TABLE;
664:
665: xErrLoc PLS_INTEGER := 100;
666: xPendingCount PLS_INTEGER := 0;

Line 663: xOldCategoryNames DBMS_SQL.VARCHAR2_TABLE;

659: xCategoryNames DBMS_SQL.VARCHAR2_TABLE;
660: xLanguages DBMS_SQL.VARCHAR2_TABLE;
661: xSourceLangs DBMS_SQL.VARCHAR2_TABLE;
662: xRtCategoryIds DBMS_SQL.NUMBER_TABLE;
663: xOldCategoryNames DBMS_SQL.VARCHAR2_TABLE;
664:
665: xErrLoc PLS_INTEGER := 100;
666: xPendingCount PLS_INTEGER := 0;
667: