APPS.EGO_IMPORT_BATCH_PURGE_PKG dependencies on BOM_SUB_COMPS_INTERFACE

Line 665: --delete records from bom_sub_comps_interface

661: IF str_num >0 THEN
662:
663: fnd_file.put_line(fnd_file.Log,'Start deleting Structure Entities');
664:
665: --delete records from bom_sub_comps_interface
666: stm_num := 2;
667:
668: FORALL comp IN l_structure_table.first .. l_structure_table.last
669:

Line 670: DELETE FROM bom_sub_comps_interface bsci

666: stm_num := 2;
667:
668: FORALL comp IN l_structure_table.first .. l_structure_table.last
669:
670: DELETE FROM bom_sub_comps_interface bsci
671: WHERE bsci.batch_id = TREAT(l_structure_table(comp) AS Ego_Structure_list_inf).batch_id
672: AND bsci.organization_id = TREAT(l_structure_table(comp) AS Ego_Structure_list_inf).organization_id
673: AND Nvl(bsci.request_id,0) = Nvl(TREAT(l_structure_table(comp) AS Ego_Structure_list_inf).request_id,0)
674: AND ( bsci.bill_sequence_id = bill_sequence_id

Line 980: SELECT Count(1) INTO l_item_table(item).isinsubcomp FROM bom_sub_comps_interface bsci

976: AND bici.COMPONENT_ITEM_NUMBER = l_item_table(item).item_number;
977:
978:
979:
980: SELECT Count(1) INTO l_item_table(item).isinsubcomp FROM bom_sub_comps_interface bsci
981: WHERE bsci.BATCH_ID = l_item_table(item).set_process_id
982: AND ( bsci.ORGANIZATION_ID = l_item_table(item).organization_id
983: OR ( bsci.ORGANIZATION_CODE = l_item_table(item).organization_code
984: AND ( bsci.ORGANIZATION_CODE IS NULL OR l_item_table(item).organization_code IS NULL)

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

1103:
1104:
1105: stm_num :=11;
1106:
1107: DELETE bom_sub_comps_interface WHERE batch_id = p_batch_id AND PROCESS_FLAG IN (3,6,7);
1108:
1109: fnd_file.put_line(fnd_file.Log,'No.of Sub-components deleted are '||SQL%ROWCOUNT);
1110:
1111: