APPS.CZ_IMP_SINGLE dependencies on CZ_IMP_ITEM_TYPE_PROPERTY

Line 2356: INSERT INTO CZ_IMP_ITEM_TYPE_PROPERTY

2352: -- format of ORIG_SYS_REF : || ':' || || ':' ||
2353: -- where CZ_ATTR_NAME = ||'.'||
2354: --
2355: FORALL i IN l_attr_name_tbl.FIRST..l_attr_name_tbl.LAST
2356: INSERT INTO CZ_IMP_ITEM_TYPE_PROPERTY
2357: (FSK_ITEMTYPE_1_1,FSK_ITEMTYPE_1_EXT,FSK_PROPERTY_2_1,FSK_PROPERTY_2_EXT,RUN_ID,
2358: ORIG_SYS_REF,SRC_APPLICATION_ID)
2359: VALUES (l_item_catalog_group_id_tbl(i),
2360: l_item_catalog_group_id_tbl(i),

Line 2377: INSERT INTO CZ_IMP_ITEM_TYPE_PROPERTY

2373:
2374: IF l_attr_list_temp_tbl.COUNT > 0 THEN
2375: FOR jj IN l_attr_list_temp_tbl.First..l_attr_list_temp_tbl.Last
2376: LOOP
2377: INSERT INTO CZ_IMP_ITEM_TYPE_PROPERTY
2378: (FSK_ITEMTYPE_1_1,FSK_ITEMTYPE_1_EXT,FSK_PROPERTY_2_1,FSK_PROPERTY_2_EXT,RUN_ID,
2379: ORIG_SYS_REF,SRC_APPLICATION_ID)
2380: VALUES (ii.item_catalog_group_id,
2381: ii.item_catalog_group_id,

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

2393: END LOOP;
2394:
2395: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2396: cz_utils.log_report(G_PKG_NAME, l_api_name, l_ndebug,
2397: 'CZ_IMP_ITEM_TYPE_PROPERTY has been populated ('||TO_CHAR(SYSDATE,'MM-DD-YYYY HH24:MI:SS')||') ',
2398: fnd_log.LEVEL_STATEMENT);
2399: END IF;
2400:
2401: --

Line 2846: INSERT INTO CZ_IMP_ITEM_TYPE_PROPERTY

2842: st_time := dbms_utility.get_time();
2843: end if;
2844:
2845: FORALL i IN 1..itemCatalogGroupId.COUNT
2846: INSERT INTO CZ_IMP_ITEM_TYPE_PROPERTY
2847: (FSK_ITEMTYPE_1_1,FSK_ITEMTYPE_1_EXT,FSK_PROPERTY_2_1,FSK_PROPERTY_2_EXT,RUN_ID,
2848: ORIG_SYS_REF,SRC_APPLICATION_ID)
2849: SELECT ITEM_CATALOG_GROUP_ID, ITEM_CATALOG_GROUP_ID, ELEMENT_NAME, ELEMENT_NAME, inRUN_ID,
2850: TO_CHAR(ITEM_CATALOG_GROUP_ID) || ':' || ELEMENT_NAME, G_BOM_APPLICATION_ID