APPS.ENG_REVISED_ITEM_UTIL dependencies on BOM_OPERATION_SEQUENCES

Line 43: from BOM_OPERATION_SEQUENCES bos

39: DELETE FROM BOM_OPERATIONAL_ROUTINGS bor
40: where bor.routing_sequence_id = p_routing_sequence_id
41: and bor.pending_from_ecn = p_change_notice
42: and not exists (select null
43: from BOM_OPERATION_SEQUENCES bos
44: where bos.routing_sequence_id = bor.routing_sequence_id
45: and (bos.change_notice is null
46: or
47: bos.change_notice <> p_change_notice

Line 287: FROM BOM_OPERATION_SEQUENCES

283:
284: CURSOR c_getRevisedOps IS
285: SELECT operation_sequence_id
286: , operation_seq_num
287: FROM BOM_OPERATION_SEQUENCES
288: WHERE revised_item_sequence_id = rev_item_seq ;
289:
290: -- Changes for Bug 3668603
291: -- Cursor to check if the routing header used in the revised item has any references

Line 298: from BOM_OPERATION_SEQUENCES bos

294: from bom_operational_routings bor
295: where bor.routing_sequence_id = routing_seq_id
296: and bor.pending_from_ecn = change_order
297: and not exists (select null
298: from BOM_OPERATION_SEQUENCES bos
299: where bos.routing_sequence_id = bor.routing_sequence_id
300: and (bos.change_notice is null
301: or
302: bos.change_notice <> change_order

Line 425: -- Delete the rows from bom_operation_sequences

421: ) ;
422:
423: END LOOP;
424:
425: -- Delete the rows from bom_operation_sequences
426:
427: DELETE FROM BOM_OPERATION_SEQUENCES
428: WHERE REVISED_ITEM_SEQUENCE_ID = rev_item_seq;
429:

Line 427: DELETE FROM BOM_OPERATION_SEQUENCES

423: END LOOP;
424:
425: -- Delete the rows from bom_operation_sequences
426:
427: DELETE FROM BOM_OPERATION_SEQUENCES
428: WHERE REVISED_ITEM_SEQUENCE_ID = rev_item_seq;
429:
430: -- Delete item revisions created by revised items on ECO
431:

Line 479: FROM BOM_OPERATION_SEQUENCES bos

475: /* DELETE FROM BOM_OPERATIONAL_ROUTINGS bor1
476: WHERE bor1.routing_sequence_id = routing_seq_id
477: AND bor1.pending_from_ecn = change_order
478: AND NOT EXISTS (SELECT NULL
479: FROM BOM_OPERATION_SEQUENCES bos
480: WHERE bos.ROUTING_SEQUENCE_ID = bor1.ROUTING_SEQUENCE_ID
481: AND (bos.CHANGE_NOTICE IS NULL
482: OR bos.CHANGE_NOTICE <> change_order)
483: )

Line 620: UPDATE BOM_OPERATION_SEQUENCES

616: x_scheduled_date DATE,
617: x_from_end_item_unit_number VARCHAR2 DEFAULT NULL)
618: IS
619: BEGIN
620: UPDATE BOM_OPERATION_SEQUENCES
621: SET effectivity_date = x_scheduled_date
622: -- , from_end_item_unit_number = x_from_end_item_unit_number
623: WHERE implementation_date IS NULL
624: AND change_notice = x_change_notice

Line 628: UPDATE BOM_OPERATION_SEQUENCES

624: AND change_notice = x_change_notice
625: AND revised_item_sequence_id = x_revised_item_sequence_id
626: AND routing_sequence_id = x_routing_sequence_id ;
627:
628: UPDATE BOM_OPERATION_SEQUENCES
629: SET disable_date = x_scheduled_date
630: WHERE implementation_date IS NULL
631: AND acd_type = 3
632: AND change_notice = x_change_notice

Line 1497: UPDATE BOM_OPERATION_SEQUENCES

1493: THEN
1494:
1495: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Before Updating Eco_For_Production in Rev Comps and Rev Ops'); END IF;
1496:
1497: UPDATE BOM_OPERATION_SEQUENCES
1498: SET eco_for_production = p_revised_item_rec.eco_for_production
1499: WHERE revised_item_sequence_id = p_rev_item_unexp_rec.revised_item_sequence_id ;
1500:
1501: UPDATE BOM_INVENTORY_COMPONENTS