APPS.EGO_IMPORT_BATCH_PURGE_PKG dependencies on BOM_OP_ROUTINGS_INTERFACE

Line 636: FROM bom_op_routings_interface I

632: process_flag,
633: ALTERNATE_ROUTING_DESIGNATOR)
634: FROM
635: ( SELECT BATCH_ID,ORGANIZATION_ID,REQUEST_ID,ASSEMBLY_ITEM_ID,ROUTING_SEQUENCE_ID,process_flag,ALTERNATE_ROUTING_DESIGNATOR
636: FROM bom_op_routings_interface I
637: WHERE I.BATCH_ID =batch_id_route
638: AND I.PROCESS_FLAG IN ( Decode(purge_criteria,'SUCCESS',7,'ERROR',3,-123456) , Decode(purge_criteria,'SUCCESS',7,'ERROR',6,-123456) )
639: );
640:

Line 907: --delete records from bom_op_routings_interface

903: l_bom_op_seq_entity_count := l_bom_op_seq_entity_count + SQL%BULK_ROWCOUNT(i);
904: END LOOP;
905:
906:
907: --delete records from bom_op_routings_interface
908: stm_num := 12;
909:
910: FORALL op IN l_routing_table.first .. l_routing_table.last
911:

Line 912: DELETE FROM bom_op_routings_interface brou

908: stm_num := 12;
909:
910: FORALL op IN l_routing_table.first .. l_routing_table.last
911:
912: DELETE FROM bom_op_routings_interface brou
913: WHERE brou.batch_id =TREAT(l_routing_table(op) AS Ego_route_list_inf).batch_id
914: AND brou.organization_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).organization_id
915: AND brou.request_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).request_id
916: AND brou.assembly_item_id = TREAT(l_routing_table(op) AS Ego_route_list_inf).assembly_item_id

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

1122:
1123:
1124: stm_num :=14;
1125:
1126: DELETE bom_op_routings_interface WHERE batch_id = p_batch_id AND PROCESS_FLAG IN (3,6,7);
1127:
1128: fnd_file.put_line(fnd_file.Log,'No.of Routings deleted are '||SQL%ROWCOUNT);
1129:
1130: