DBA Data[Home] [Help]

APPS.CZ_IMP_SINGLE dependencies on CZ_IMP_ITEM_PROPERTY_VALUE

Line 2607: INSERT INTO CZ_IMP_ITEM_PROPERTY_VALUE

2603: --
2604: -- insert portion of data limited by l_Batch_Size to Import Property Values
2605: --
2606: FORALL i IN l_prop_values_tbl.FIRST..l_prop_values_tbl.LAST
2607: INSERT INTO CZ_IMP_ITEM_PROPERTY_VALUE
2608: (PROPERTY_VALUE, FSK_PROPERTY_1_1,FSK_PROPERTY_1_EXT,
2609: FSK_ITEMMASTER_2_1,FSK_ITEMMASTER_2_EXT,RUN_ID,ORIG_SYS_REF,FSK_LOCALIZEDTEXT_3_1,PROPERTY_NUM_VALUE,
2610: SRC_APPLICATION_ID)
2611: VALUES

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

2652: COMMIT;
2653:
2654: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2655: cz_utils.log_report(G_PKG_NAME, l_api_name, l_ndebug,
2656: 'CZ_IMP_ITEM_PROPERTY_VALUE has been populated ('||TO_CHAR(SYSDATE,'MM-DD-YYYY HH24:MI:SS')||') ',
2657: fnd_log.LEVEL_STATEMENT);
2658: END IF;
2659:
2660: EXCEPTION

Line 2894: INSERT INTO CZ_IMP_ITEM_PROPERTY_VALUE

2890: st_time := dbms_utility.get_time();
2891: end if;
2892:
2893: FORALL i IN 1..inventoryItemId.COUNT
2894: INSERT INTO CZ_IMP_ITEM_PROPERTY_VALUE
2895: (PROPERTY_VALUE, FSK_PROPERTY_1_1, FSK_PROPERTY_1_EXT,
2896: FSK_ITEMMASTER_2_1,
2897: FSK_ITEMMASTER_2_EXT,
2898: RUN_ID,