APPS.EGO_IMPORT_BATCH_PURGE_PKG dependencies on BOM_OP_RESOURCES_INTERFACE

Line 824: --delete records from bom_op_resources_interface

820:
821:
822: IF routing_num >0 THEN
823:
824: --delete records from bom_op_resources_interface
825: stm_num := 8;
826:
827: fnd_file.put_line(fnd_file.Log,'Start deleting Routing Entities');
828:

Line 832: DELETE FROM bom_op_resources_interface bori

828:
829:
830: FORALL op IN l_routing_table.first .. l_routing_table.last
831:
832: DELETE FROM bom_op_resources_interface bori
833: WHERE bori.batch_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).batch_id
834: AND bori.organization_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).organization_id
835: AND bori.request_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).request_id
836: AND bori.assembly_item_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).assembly_item_id

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

1129:
1130:
1131: stm_num :=15;
1132:
1133: DELETE bom_op_resources_interface WHERE batch_id = p_batch_id AND PROCESS_FLAG IN (3,6,7);
1134:
1135: fnd_file.put_line(fnd_file.Log,'No.of Operation Resources deleted are '||SQL%ROWCOUNT);
1136:
1137: