APPS.ENG_REVISED_ITEM_UTIL dependencies on BOM_OPERATION_SEQUENCES

Line 60: from BOM_OPERATION_SEQUENCES bos

56: DELETE FROM BOM_OPERATIONAL_ROUTINGS bor
57: where bor.routing_sequence_id = p_routing_sequence_id
58: and bor.pending_from_ecn = p_change_notice
59: and not exists (select null
60: from BOM_OPERATION_SEQUENCES bos
61: where bos.routing_sequence_id = bor.routing_sequence_id
62: and (bos.change_notice is null
63: or
64: bos.change_notice <> p_change_notice

Line 304: FROM BOM_OPERATION_SEQUENCES

300:
301: CURSOR c_getRevisedOps IS
302: SELECT operation_sequence_id
303: , operation_seq_num
304: FROM BOM_OPERATION_SEQUENCES
305: WHERE revised_item_sequence_id = rev_item_seq ;
306:
307: -- Changes for Bug 3668603
308: -- Cursor to check if the routing header used in the revised item has any references

Line 315: from BOM_OPERATION_SEQUENCES bos

311: from bom_operational_routings bor
312: where bor.routing_sequence_id = routing_seq_id
313: and bor.pending_from_ecn = change_order
314: and not exists (select null
315: from BOM_OPERATION_SEQUENCES bos
316: where bos.routing_sequence_id = bor.routing_sequence_id
317: and (bos.change_notice is null
318: or
319: bos.change_notice <> change_order

Line 442: -- Delete the rows from bom_operation_sequences

438: ) ;
439:
440: END LOOP;
441:
442: -- Delete the rows from bom_operation_sequences
443:
444: DELETE FROM BOM_OPERATION_SEQUENCES
445: WHERE REVISED_ITEM_SEQUENCE_ID = rev_item_seq;
446:

Line 444: DELETE FROM BOM_OPERATION_SEQUENCES

440: END LOOP;
441:
442: -- Delete the rows from bom_operation_sequences
443:
444: DELETE FROM BOM_OPERATION_SEQUENCES
445: WHERE REVISED_ITEM_SEQUENCE_ID = rev_item_seq;
446:
447: -- Delete item revisions created by revised items on ECO
448:

Line 496: FROM BOM_OPERATION_SEQUENCES bos

492: /* DELETE FROM BOM_OPERATIONAL_ROUTINGS bor1
493: WHERE bor1.routing_sequence_id = routing_seq_id
494: AND bor1.pending_from_ecn = change_order
495: AND NOT EXISTS (SELECT NULL
496: FROM BOM_OPERATION_SEQUENCES bos
497: WHERE bos.ROUTING_SEQUENCE_ID = bor1.ROUTING_SEQUENCE_ID
498: AND (bos.CHANGE_NOTICE IS NULL
499: OR bos.CHANGE_NOTICE <> change_order)
500: )

Line 637: UPDATE BOM_OPERATION_SEQUENCES

633: x_scheduled_date DATE,
634: x_from_end_item_unit_number VARCHAR2 DEFAULT NULL)
635: IS
636: BEGIN
637: UPDATE BOM_OPERATION_SEQUENCES
638: SET effectivity_date = x_scheduled_date
639: -- , from_end_item_unit_number = x_from_end_item_unit_number
640: WHERE implementation_date IS NULL
641: AND change_notice = x_change_notice

Line 645: UPDATE BOM_OPERATION_SEQUENCES

641: AND change_notice = x_change_notice
642: AND revised_item_sequence_id = x_revised_item_sequence_id
643: AND routing_sequence_id = x_routing_sequence_id ;
644:
645: UPDATE BOM_OPERATION_SEQUENCES
646: SET disable_date = x_scheduled_date
647: WHERE implementation_date IS NULL
648: AND acd_type = 3
649: AND change_notice = x_change_notice

Line 1515: UPDATE BOM_OPERATION_SEQUENCES

1511: THEN
1512:
1513: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Before Updating Eco_For_Production in Rev Comps and Rev Ops'); END IF;
1514:
1515: UPDATE BOM_OPERATION_SEQUENCES
1516: SET eco_for_production = p_revised_item_rec.eco_for_production
1517: WHERE revised_item_sequence_id = p_rev_item_unexp_rec.revised_item_sequence_id ;
1518:
1519: UPDATE BOM_INVENTORY_COMPONENTS