APPS.CZ_IMP_SINGLE dependencies on CZ_IMP_ITEM_TYPE

Line 1962: INSERT INTO CZ_IMP_ITEM_TYPE

1958: END IF;
1959:
1960: IF (l_use_segments = TRUE) THEN
1961: FORALL i IN 1..itemCatalogGroupId.COUNT
1962: INSERT INTO CZ_IMP_ITEM_TYPE
1963: (DESC_TEXT, NAME, ORIG_SYS_REF,SRC_APPLICATION_ID,RUN_ID)
1964: SELECT DESCRIPTION, CATALOG_CONCAT_SEGS, ITEM_CATALOG_GROUP_ID, G_BOM_APPLICATION_ID, inRUN_ID
1965: FROM CZ_EXV_ITEM_TYPES
1966: WHERE ITEM_CATALOG_GROUP_ID = itemCatalogGroupId(i);

Line 1969: INSERT INTO CZ_IMP_ITEM_TYPE

1965: FROM CZ_EXV_ITEM_TYPES
1966: WHERE ITEM_CATALOG_GROUP_ID = itemCatalogGroupId(i);
1967: ELSE
1968: FORALL i IN 1..itemCatalogGroupId.COUNT
1969: INSERT INTO CZ_IMP_ITEM_TYPE
1970: (DESC_TEXT, NAME, ORIG_SYS_REF, SRC_APPLICATION_ID, RUN_ID)
1971: SELECT DESCRIPTION, DESCRIPTION, ITEM_CATALOG_GROUP_ID, G_BOM_APPLICATION_ID, inRUN_ID
1972: FROM CZ_EXV_ITEM_TYPES
1973: WHERE ITEM_CATALOG_GROUP_ID = itemCatalogGroupId(i);

Line 2294: INSERT INTO CZ_IMP_ITEM_TYPE_PROPERTY

2290: -- format of ORIG_SYS_REF : || ':' || || ':' ||
2291: -- where CZ_ATTR_NAME = ||'.'||
2292: --
2293: FORALL i IN l_attr_name_tbl.FIRST..l_attr_name_tbl.LAST
2294: INSERT INTO CZ_IMP_ITEM_TYPE_PROPERTY
2295: (FSK_ITEMTYPE_1_1,FSK_ITEMTYPE_1_EXT,FSK_PROPERTY_2_1,FSK_PROPERTY_2_EXT,RUN_ID,
2296: ORIG_SYS_REF,SRC_APPLICATION_ID)
2297: VALUES (l_item_catalog_group_id_tbl(i),
2298: l_item_catalog_group_id_tbl(i),

Line 2315: INSERT INTO CZ_IMP_ITEM_TYPE_PROPERTY

2311:
2312: IF l_attr_list_temp_tbl.COUNT > 0 THEN
2313: FOR jj IN l_attr_list_temp_tbl.First..l_attr_list_temp_tbl.Last
2314: LOOP
2315: INSERT INTO CZ_IMP_ITEM_TYPE_PROPERTY
2316: (FSK_ITEMTYPE_1_1,FSK_ITEMTYPE_1_EXT,FSK_PROPERTY_2_1,FSK_PROPERTY_2_EXT,RUN_ID,
2317: ORIG_SYS_REF,SRC_APPLICATION_ID)
2318: VALUES (ii.item_catalog_group_id,
2319: ii.item_catalog_group_id,

Line 2335: 'CZ_IMP_ITEM_TYPE_PROPERTY has been populated ('||TO_CHAR(SYSDATE,'MM-DD-YYYY HH24:MI:SS')||') ',

2331: END LOOP;
2332:
2333: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2334: cz_utils.log_report(G_PKG_NAME, l_api_name, l_ndebug,
2335: 'CZ_IMP_ITEM_TYPE_PROPERTY has been populated ('||TO_CHAR(SYSDATE,'MM-DD-YYYY HH24:MI:SS')||') ',
2336: fnd_log.LEVEL_STATEMENT);
2337: END IF;
2338:
2339: --

Line 2776: INSERT INTO CZ_IMP_ITEM_TYPE_PROPERTY

2772: st_time := dbms_utility.get_time();
2773: end if;
2774:
2775: FORALL i IN 1..itemCatalogGroupId.COUNT
2776: INSERT INTO CZ_IMP_ITEM_TYPE_PROPERTY
2777: (FSK_ITEMTYPE_1_1,FSK_ITEMTYPE_1_EXT,FSK_PROPERTY_2_1,FSK_PROPERTY_2_EXT,RUN_ID,
2778: ORIG_SYS_REF,SRC_APPLICATION_ID)
2779: SELECT ITEM_CATALOG_GROUP_ID, ITEM_CATALOG_GROUP_ID, ELEMENT_NAME, ELEMENT_NAME, inRUN_ID,
2780: TO_CHAR(ITEM_CATALOG_GROUP_ID) || ':' || ELEMENT_NAME, G_BOM_APPLICATION_ID