APPS.EGO_IMPORT_BATCH_PURGE_PKG dependencies on BOM_INVENTORY_COMPS_INTERFACE

Line 748: --delete records from bom_inventory_comps_interface

744: l_op_comp_entity_count := l_op_comp_entity_count + SQL%BULK_ROWCOUNT(i);
745: END LOOP;
746:
747:
748: --delete records from bom_inventory_comps_interface
749: stm_num := 6;
750:
751: FORALL comp IN l_structure_table.first .. l_structure_table.last
752:

Line 753: DELETE FROM bom_inventory_comps_interface bici

749: stm_num := 6;
750:
751: FORALL comp IN l_structure_table.first .. l_structure_table.last
752:
753: DELETE FROM bom_inventory_comps_interface bici
754: WHERE bici.BATCH_ID = TREAT(l_structure_table(comp) AS Ego_Structure_list_inf).batch_id
755: AND bici.ORGANIZATION_ID = TREAT(l_structure_table(comp) AS Ego_Structure_list_inf).organization_id
756: AND Nvl(bici.REQUEST_ID,0) = Nvl(TREAT(l_structure_table(comp) AS Ego_Structure_list_inf).request_id,0)
757: AND Nvl(bici.BUNDLE_ID,0) = Nvl(TREAT(l_structure_table(comp) AS Ego_Structure_list_inf).bundle_id,0)

Line 969: SELECT Count(1) INTO l_item_table(item).isincomp FROM bom_inventory_comps_interface bici

965: AND bbmi.ITEM_NUMBER = l_item_table(item).item_number;
966:
967:
968:
969: SELECT Count(1) INTO l_item_table(item).isincomp FROM bom_inventory_comps_interface bici
970: WHERE bici.BATCH_ID = l_item_table(item).set_process_id
971: AND ( bici.ORGANIZATION_ID = l_item_table(item).organization_id
972: OR ( bici.ORGANIZATION_CODE = l_item_table(item).organization_code
973: AND ( bici.ORGANIZATION_CODE IS NULL OR l_item_table(item).organization_code IS NULL)

Line 1093: DELETE bom_inventory_comps_interface WHERE batch_id = p_batch_id AND PROCESS_FLAG IN (3,6,7);

1089:
1090:
1091: stm_num :=9;
1092:
1093: DELETE bom_inventory_comps_interface WHERE batch_id = p_batch_id AND PROCESS_FLAG IN (3,6,7);
1094:
1095: fnd_file.put_line(fnd_file.Log,'No.of Components deleted are '||SQL%ROWCOUNT);
1096:
1097: