APPS.EGO_IMPORT_BATCH_PURGE_PKG dependencies on BOM_SUB_OP_RESOURCES_INTERFACE

Line 850: --delete records from bom_sub_op_resources_interface

846: l_bom_op_res_entity_count := l_bom_op_res_entity_count + SQL%BULK_ROWCOUNT(i);
847: END LOOP;
848:
849:
850: --delete records from bom_sub_op_resources_interface
851: stm_num := 9;
852:
853: FORALL op IN l_routing_table.first .. l_routing_table.last
854:

Line 855: DELETE FROM bom_sub_op_resources_interface bsr

851: stm_num := 9;
852:
853: FORALL op IN l_routing_table.first .. l_routing_table.last
854:
855: DELETE FROM bom_sub_op_resources_interface bsr
856: WHERE bsr.batch_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).batch_id
857: AND bsr.organization_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).organization_id
858: AND bsr.request_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).request_id
859: AND bsr.assembly_item_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).assembly_item_id

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

1136:
1137:
1138: stm_num :=16;
1139:
1140: DELETE bom_sub_op_resources_interface WHERE batch_id = p_batch_id AND PROCESS_FLAG IN (3,6,7);
1141:
1142: fnd_file.put_line(fnd_file.Log,'No.of Sub-operation Resources deleted are '||SQL%ROWCOUNT);
1143:
1144: