APPS.CZ_IMP_SINGLE dependencies on CZ_ITEM_CATALOG_REC

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 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 2140: -- CREATE OR REPLACE TYPE SYSTEM.CZ_ITEM_CATALOG_REC IS OBJECT(item_catalog_group_id number);

2136:
2137: --
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:

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 2155: l_prev_item_catalog_tbl(l_prev_item_catalog_tbl.LAST) := SYSTEM.CZ_ITEM_CATALOG_REC(i.item_catalog_group_id);

2151: START WITH item_catalog_group_id = itemCatalogGroupId(item_index)
2152: CONNECT BY PRIOR parent_catalog_group_id = item_catalog_group_id)
2153: LOOP
2154: l_prev_item_catalog_tbl.extend;
2155: l_prev_item_catalog_tbl(l_prev_item_catalog_tbl.LAST) := SYSTEM.CZ_ITEM_CATALOG_REC(i.item_catalog_group_id);
2156:
2157: IF i.item_catalog_group_id<>itemCatalogGroupId(item_index) THEN
2158: l_item_cat_tbl(l_item_cat_tbl.COUNT+1) := i.item_catalog_group_id;
2159: l_item_catalog_path := l_item_catalog_path || '-' || TO_CHAR(i.item_catalog_group_id);