APPS.CZ_IMP_SINGLE dependencies on CZ_ITEM_CATALOG_TBL

Line 26: g_ItemCatalogTable SYSTEM.CZ_ITEM_CATALOG_TBL := SYSTEM.CZ_ITEM_CATALOG_TBL(SYSTEM.CZ_ITEM_CATALOG_REC(NULL));

22: TL_TEXT_TYPE CONSTANT NUMBER := 8;
23:
24: l_Batch_Size NUMBER := 100;
25:
26: g_ItemCatalogTable SYSTEM.CZ_ITEM_CATALOG_TBL := SYSTEM.CZ_ITEM_CATALOG_TBL(SYSTEM.CZ_ITEM_CATALOG_REC(NULL));
27: g_CONFIG_ENGINE_TYPE VARCHAR2(10);
28:
29: TYPE tCatalogGroupId IS TABLE OF cz_exv_item_master.item_catalog_group_id%TYPE INDEX BY BINARY_INTEGER;
30: TYPE tInventoryItemId IS TABLE OF cz_exv_item_master.inventory_item_id%TYPE INDEX BY BINARY_INTEGER;

Line 2067: FUNCTION get_ItemCatalogTable RETURN SYSTEM.CZ_ITEM_CATALOG_TBL IS

2063: END IF;
2064: RETURN -1;
2065: END get_Col_Num;
2066:
2067: FUNCTION get_ItemCatalogTable RETURN SYSTEM.CZ_ITEM_CATALOG_TBL IS
2068: BEGIN
2069: RETURN g_ItemCatalogTable;
2070: END get_ItemCatalogTable;
2071:

Line 2084: l_prev_item_catalog_tbl SYSTEM.CZ_ITEM_CATALOG_TBL := SYSTEM.CZ_ITEM_CATALOG_TBL(SYSTEM.CZ_ITEM_CATALOG_REC(NULL));

2080: loop_end_time NUMBER;
2081: insert_end_time NUMBER;
2082: d_str VARCHAR2(255);
2083:
2084: l_prev_item_catalog_tbl SYSTEM.CZ_ITEM_CATALOG_TBL := SYSTEM.CZ_ITEM_CATALOG_TBL(SYSTEM.CZ_ITEM_CATALOG_REC(NULL));
2085:
2086: l_cursor NUMBER;
2087: l_exec NUMBER;
2088: l_error BOOLEAN;

Line 2204: -- CREATE OR REPLACE TYPE SYSTEM.CZ_ITEM_CATALOG_TBL IS TABLE OF SYSTEM.CZ_ITEM_CATALOG_REC;

2200: -- Definitions of global SQL types which are used in TABLE(CAST(...))
2201: --
2202: -- CREATE OR REPLACE TYPE SYSTEM.CZ_ITEM_CATALOG_REC IS OBJECT(item_catalog_group_id number);
2203: --
2204: -- CREATE OR REPLACE TYPE SYSTEM.CZ_ITEM_CATALOG_TBL IS TABLE OF SYSTEM.CZ_ITEM_CATALOG_REC;
2205: --
2206:
2207: FOR item_index IN itemCatalogGroupId.FIRST..itemCatalogGroupId.LAST
2208: LOOP

Line 2237: FROM TABLE(CAST(l_prev_item_catalog_tbl AS SYSTEM.CZ_ITEM_CATALOG_TBL)) WHERE item_catalog_group_id IS NOT NULL);

2233:
2234: INSERT INTO CZ_IMP_TMP_ITEMCAT(run_id, item_catalog_group_id)
2235: SELECT p_run_id,item_catalog_group_id
2236: FROM (SELECT DISTINCT item_catalog_group_id
2237: FROM TABLE(CAST(l_prev_item_catalog_tbl AS SYSTEM.CZ_ITEM_CATALOG_TBL)) WHERE item_catalog_group_id IS NOT NULL);
2238:
2239:
2240: IF SQL%ROWCOUNT=0 THEN
2241: RETURN;