APPS.ENG_REVISED_ITEM_UTIL dependencies on MTL_RTG_ITEM_REVISIONS

Line 26: DELETE FROM MTL_RTG_ITEM_REVISIONS

22: IS
23:
24:
25: BEGIN
26: DELETE FROM MTL_RTG_ITEM_REVISIONS
27: where organization_id = p_organization_id
28: and inventory_item_id = p_revised_item_id
29: and revised_item_sequence_Id = p_revised_item_sequence_id
30: and change_notice = p_change_notice

Line 74: * Purpose : Insert the New Routing Revision Record into MTL_RTG_ITEM_REVISIONS

70: /*****************************************************************************
71: * Added by MK on 09/01/2000
72: * Procedure : Insert_Routing_Revisions
73: * Parameters IN : Routing Revision Column.
74: * Purpose : Insert the New Routing Revision Record into MTL_RTG_ITEM_REVISIONS
75: ****************************************************************************/
76: PROCEDURE Insert_Routing_Revisions
77: ( p_inventory_item_id IN NUMBER
78: , p_organization_id IN NUMBER

Line 89: INSERT INTO MTL_RTG_ITEM_REVISIONS

85: )
86: IS
87: BEGIN
88:
89: INSERT INTO MTL_RTG_ITEM_REVISIONS
90: ( inventory_item_id
91: , organization_id
92: , process_revision
93: , last_update_date

Line 313: from MTL_RTG_ITEM_REVISIONS mriv

309: where bor2.organization_id = bor.organization_id
310: and bor2.assembly_item_id = bor.assembly_item_id
311: and bor2.alternate_routing_designator is not null)
312: and not exists (select null
313: from MTL_RTG_ITEM_REVISIONS mriv
314: where mriv.organization_id = bor.organization_id
315: and mriv.inventory_item_id = bor.assembly_item_id
316: and mriv.implementation_date is not null
317: and mriv.change_notice is null))

Line 432: DELETE FROM MTL_RTG_ITEM_REVISIONS I

428: WHERE REVISED_ITEM_SEQUENCE_ID = rev_item_seq;
429:
430: -- Delete item revisions created by revised items on ECO
431:
432: DELETE FROM MTL_RTG_ITEM_REVISIONS I
433: WHERE REVISED_ITEM_SEQUENCE_ID = rev_item_seq
434: AND implementation_date IS NULL; -- bug 3668603: delete only unimplemented revisions
435:
436: -- Delete the routing header if routing was created by this revised item and

Line 454: DELETE FROM MTL_RTG_ITEM_REVISIONS rev

450: END LOOP;
451:
452: IF (l_del_rtg_header = 1)
453: THEN
454: DELETE FROM MTL_RTG_ITEM_REVISIONS rev
455: WHERE EXISTS (SELECT 1
456: FROM BOM_OPERATIONAL_ROUTINGS bor
457: WHERE bor.routing_sequence_id = routing_seq_id
458: AND bor.alternate_routing_designator IS NULL

Line 1230: -- Delete record from MTL_RTG_ITEM_REVISIONS if it already

1226: ****************************************************************/
1227:
1228: IF Eng_Default_Revised_Item.G_DEL_UPD_INS_RTG_REV = 1
1229: THEN
1230: -- Delete record from MTL_RTG_ITEM_REVISIONS if it already
1231: -- exists
1232: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Deleting Routing Revisions . . .'); END IF;
1233:
1234: DELETE FROM MTL_RTG_ITEM_REVISIONS

Line 1234: DELETE FROM MTL_RTG_ITEM_REVISIONS

1230: -- Delete record from MTL_RTG_ITEM_REVISIONS if it already
1231: -- exists
1232: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Deleting Routing Revisions . . .'); END IF;
1233:
1234: DELETE FROM MTL_RTG_ITEM_REVISIONS
1235: WHERE implementation_date IS NULL
1236: AND change_notice = p_revised_item_rec.eco_name
1237: AND revised_item_sequence_id = p_rev_item_unexp_rec.revised_item_sequence_id
1238: AND organization_id = p_rev_item_unexp_rec.organization_id

Line 1250: UPDATE MTL_RTG_ITEM_REVISIONS

1246: -- MTL_ITEM_REVISIONS
1247:
1248: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Updating Routing Revisions . . .'); END IF;
1249:
1250: UPDATE MTL_RTG_ITEM_REVISIONS
1251: SET process_revision = p_revised_item_rec.updated_routing_revision
1252: , effectivity_date = DECODE( DECODE(p_revised_item_rec.new_effective_date,
1253: to_date(NULL), p_revised_item_rec.start_effective_date,
1254: p_revised_item_rec.new_effective_date)

Line 1404: UPDATE MTL_RTG_ITEM_REVISIONS

1400: IF Bom_Globals.Get_Debug = 'Y' THEN
1401: Error_Handler.Write_Debug('Updating effective dates of pending item/rtg rev in this revised item record . . . ');
1402: END IF;
1403:
1404: UPDATE MTL_RTG_ITEM_REVISIONS
1405: SET effectivity_date =
1406: DECODE( DECODE( p_revised_item_rec.new_effective_date
1407: , to_date(NULL)
1408: , p_revised_item_rec.start_effective_date

Line 2576: UPDATE MTL_RTG_ITEM_REVISIONS

2572: , x_scheduled_date => p_effectivity_date);
2573: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Updated operation sequences effectivity'); END IF;
2574:
2575: -- update routing revision details
2576: UPDATE MTL_RTG_ITEM_REVISIONS
2577: SET effectivity_date = p_effectivity_date,
2578: last_update_date = sysdate,
2579: last_updated_by = l_user_id,
2580: last_update_login = l_login_id