APPS.ICX_POR_EXT_PURGE dependencies on DBMS_SQL

Line 23: gRtCategoryIds DBMS_SQL.NUMBER_TABLE;

19:
20: --------------------------------------------------------------
21: -- Global Variables --
22: --------------------------------------------------------------
23: gRtCategoryIds DBMS_SQL.NUMBER_TABLE;
24: gCategoryKeys DBMS_SQL.VARCHAR2_TABLE;
25: gCategoryTypes DBMS_SQL.NUMBER_TABLE;
26: gRtItemIds DBMS_SQL.NUMBER_TABLE;
27:

Line 24: gCategoryKeys DBMS_SQL.VARCHAR2_TABLE;

20: --------------------------------------------------------------
21: -- Global Variables --
22: --------------------------------------------------------------
23: gRtCategoryIds DBMS_SQL.NUMBER_TABLE;
24: gCategoryKeys DBMS_SQL.VARCHAR2_TABLE;
25: gCategoryTypes DBMS_SQL.NUMBER_TABLE;
26: gRtItemIds DBMS_SQL.NUMBER_TABLE;
27:
28: gCompletedCount PLS_INTEGER := 0;

Line 25: gCategoryTypes DBMS_SQL.NUMBER_TABLE;

21: -- Global Variables --
22: --------------------------------------------------------------
23: gRtCategoryIds DBMS_SQL.NUMBER_TABLE;
24: gCategoryKeys DBMS_SQL.VARCHAR2_TABLE;
25: gCategoryTypes DBMS_SQL.NUMBER_TABLE;
26: gRtItemIds DBMS_SQL.NUMBER_TABLE;
27:
28: gCompletedCount PLS_INTEGER := 0;
29:

Line 26: gRtItemIds DBMS_SQL.NUMBER_TABLE;

22: --------------------------------------------------------------
23: gRtCategoryIds DBMS_SQL.NUMBER_TABLE;
24: gCategoryKeys DBMS_SQL.VARCHAR2_TABLE;
25: gCategoryTypes DBMS_SQL.NUMBER_TABLE;
26: gRtItemIds DBMS_SQL.NUMBER_TABLE;
27:
28: gCompletedCount PLS_INTEGER := 0;
29:
30: -- Bug 2001770

Line 86: xRtItemIds DBMS_SQL.NUMBER_TABLE;

82: SELECT rt_item_id
83: FROM icx_cat_category_items
84: WHERE rt_category_id = p_rt_category_id;
85:
86: xRtItemIds DBMS_SQL.NUMBER_TABLE;
87: xErrLoc PLS_INTEGER := 100;
88:
89: BEGIN
90:

Line 450: xRtCategoryIds DBMS_SQL.NUMBER_TABLE;

446: PROCEDURE purgeClassificationData(pMode IN PLS_INTEGER,
447: pInvCatId IN NUMBER)
448: IS
449:
450: xRtCategoryIds DBMS_SQL.NUMBER_TABLE;
451: xKeys DBMS_SQL.VARCHAR2_TABLE;
452: xTypes DBMS_SQL.NUMBER_TABLE;
453:
454: xErrLoc PLS_INTEGER := 100;

Line 451: xKeys DBMS_SQL.VARCHAR2_TABLE;

447: pInvCatId IN NUMBER)
448: IS
449:
450: xRtCategoryIds DBMS_SQL.NUMBER_TABLE;
451: xKeys DBMS_SQL.VARCHAR2_TABLE;
452: xTypes DBMS_SQL.NUMBER_TABLE;
453:
454: xErrLoc PLS_INTEGER := 100;
455: cClass tClassCursorType;

Line 452: xTypes DBMS_SQL.NUMBER_TABLE;

448: IS
449:
450: xRtCategoryIds DBMS_SQL.NUMBER_TABLE;
451: xKeys DBMS_SQL.VARCHAR2_TABLE;
452: xTypes DBMS_SQL.NUMBER_TABLE;
453:
454: xErrLoc PLS_INTEGER := 100;
455: cClass tClassCursorType;
456:

Line 705: xRtItemIds DBMS_SQL.NUMBER_TABLE;

701:
702: -- Process item records
703: PROCEDURE processItemRecords(pCursor IN tItemCursorType)
704: IS
705: xRtItemIds DBMS_SQL.NUMBER_TABLE;
706:
707: xErrLoc PLS_INTEGER := 100;
708: xPendingCount PLS_INTEGER := 0;
709:

Line 778: xRtItemIds DBMS_SQL.NUMBER_TABLE;

774: PROCEDURE purgeItemData (pMode IN PLS_INTEGER,
775: pInvCatItemId IN NUMBER)
776: IS
777:
778: xRtItemIds DBMS_SQL.NUMBER_TABLE;
779: xPriceRowIds DBMS_SQL.UROWID_TABLE;
780: xMtlCategoryIds DBMS_SQL.NUMBER_TABLE;
781:
782: xErrLoc PLS_INTEGER := 100;

Line 779: xPriceRowIds DBMS_SQL.UROWID_TABLE;

775: pInvCatItemId IN NUMBER)
776: IS
777:
778: xRtItemIds DBMS_SQL.NUMBER_TABLE;
779: xPriceRowIds DBMS_SQL.UROWID_TABLE;
780: xMtlCategoryIds DBMS_SQL.NUMBER_TABLE;
781:
782: xErrLoc PLS_INTEGER := 100;
783: cItem tItemCursorType;

Line 780: xMtlCategoryIds DBMS_SQL.NUMBER_TABLE;

776: IS
777:
778: xRtItemIds DBMS_SQL.NUMBER_TABLE;
779: xPriceRowIds DBMS_SQL.UROWID_TABLE;
780: xMtlCategoryIds DBMS_SQL.NUMBER_TABLE;
781:
782: xErrLoc PLS_INTEGER := 100;
783: cItem tItemCursorType;
784: