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 2005: FUNCTION get_ItemCatalogTable RETURN SYSTEM.CZ_ITEM_CATALOG_TBL IS

2001: END IF;
2002: RETURN -1;
2003: END get_Col_Num;
2004:
2005: FUNCTION get_ItemCatalogTable RETURN SYSTEM.CZ_ITEM_CATALOG_TBL IS
2006: BEGIN
2007: RETURN g_ItemCatalogTable;
2008: END get_ItemCatalogTable;
2009:

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

2018: loop_end_time NUMBER;
2019: insert_end_time NUMBER;
2020: d_str VARCHAR2(255);
2021:
2022: l_prev_item_catalog_tbl SYSTEM.CZ_ITEM_CATALOG_TBL := SYSTEM.CZ_ITEM_CATALOG_TBL(SYSTEM.CZ_ITEM_CATALOG_REC(NULL));
2023:
2024: l_cursor NUMBER;
2025: l_exec NUMBER;
2026: l_error BOOLEAN;

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

2138: -- Definitions of global SQL types which are used in TABLE(CAST(...))
2139: --
2140: -- CREATE OR REPLACE TYPE SYSTEM.CZ_ITEM_CATALOG_REC IS OBJECT(item_catalog_group_id number);
2141: --
2142: -- CREATE OR REPLACE TYPE SYSTEM.CZ_ITEM_CATALOG_TBL IS TABLE OF SYSTEM.CZ_ITEM_CATALOG_REC;
2143: --
2144:
2145: FOR item_index IN itemCatalogGroupId.FIRST..itemCatalogGroupId.LAST
2146: LOOP

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

2171:
2172: INSERT INTO CZ_IMP_TMP_ITEMCAT(run_id, item_catalog_group_id)
2173: SELECT p_run_id,item_catalog_group_id
2174: FROM (SELECT DISTINCT item_catalog_group_id
2175: FROM TABLE(CAST(l_prev_item_catalog_tbl AS SYSTEM.CZ_ITEM_CATALOG_TBL)) WHERE item_catalog_group_id IS NOT NULL);
2176:
2177:
2178: IF SQL%ROWCOUNT=0 THEN
2179: RETURN;