APPS.ENG_REVISED_ITEMS_PKG dependencies on MTL_ITEM_REVISIONS_B

Line 68: FROM MTL_ITEM_REVISIONS_B

64: BEGIN
65:
66: delete from MTL_ITEM_REVISIONS_TL
67: where revision_id IN (SELECT revision_id
68: FROM MTL_ITEM_REVISIONS_B
69: WHERE organization_id = x_organization_id
70: and inventory_item_id = x_revised_item_id
71: and revised_item_sequence_Id = x_revised_item_sequence_id
72: and change_notice = x_change_notice

Line 75: delete from MTL_ITEM_REVISIONS_B

71: and revised_item_sequence_Id = x_revised_item_sequence_id
72: and change_notice = x_change_notice
73: and implementation_date is null);
74:
75: delete from MTL_ITEM_REVISIONS_B
76: where organization_id = x_organization_id
77: and inventory_item_id = x_revised_item_id
78: and revised_item_sequence_Id = x_revised_item_sequence_id
79: and change_notice = x_change_notice

Line 308: from MTL_ITEM_REVISIONS_B

304: and organization_id = x_organization_id) and --change_id is required for index
305: revised_item_sequence_id = x_revised_item_sequence_id and
306: entity_name = 'MTL_ITEM_REVISIONS' and
307: pk3_value IN (select revision_id
308: from MTL_ITEM_REVISIONS_B
309: where organization_id = x_organization_id
310: and inventory_item_id = x_inventory_item_id
311: and revised_item_sequence_Id = x_revised_item_sequence_id
312: and change_notice = x_change_notice

Line 319: from MTL_ITEM_REVISIONS_B

315:
316:
317: delete from MTL_ITEM_REVISIONS_TL
318: where revision_id IN (select revision_id
319: from MTL_ITEM_REVISIONS_B
320: where organization_id = x_organization_id
321: and inventory_item_id = x_inventory_item_id
322: and revised_item_sequence_Id = x_revised_item_sequence_id
323: and change_notice = x_change_notice

Line 326: delete from MTL_ITEM_REVISIONS_B

322: and revised_item_sequence_Id = x_revised_item_sequence_id
323: and change_notice = x_change_notice
324: and implementation_date is null);
325:
326: delete from MTL_ITEM_REVISIONS_B
327: where organization_id = x_organization_id
328: and inventory_item_id =x_inventory_item_id
329: and revised_item_sequence_Id = x_revised_item_sequence_id
330: and change_notice = x_change_notice

Line 391: insert into MTL_ITEM_REVISIONS_B (

387:
388:
389: BEGIN
390: IF (Bom_globals.Get_Caller_Type <> BOM_GLOBALS.G_MASS_CHANGE) THEN -- added for bug 3534567
391: insert into MTL_ITEM_REVISIONS_B (
392: inventory_item_id,
393: organization_id,
394: revision,
395: revision_label,

Line 425: mtl_item_revisions_b_s.NEXTVAL,

421: x_change_notice,
422: sysdate,
423: decode(x_scheduled_date, trunc(sysdate), sysdate, x_scheduled_date),
424: x_revised_item_sequence_id,
425: mtl_item_revisions_b_s.NEXTVAL,
426: 1,
427: decode(x_revision_description,FND_API.G_MISS_CHAR,NULL,x_revision_description),
428: decode(p_new_revision_reason_code, FND_API.G_MISS_CHAR, NULL, p_new_revision_reason_code)
429: )RETURNING revision_id INTO l_revision_id;

Line 546: update MTL_ITEM_REVISIONS_B

542: l_login_id NUMBER := FND_GLOBAL.Login_Id;
543:
544: BEGIN
545:
546: update MTL_ITEM_REVISIONS_B
547: set revision = x_revision,
548: revision_label = x_revision, -- Bug No:3612330 added by sseraphi to update rev label along with rev code.
549: effectivity_date = decode(x_scheduled_date, trunc(sysdate), sysdate, x_scheduled_date),
550: last_update_date = SYSDATE,

Line 650: * mtl_item_revisions_b/_tl table with the value passed as parameter

646: * API Name : UPDATE_REVISION_CHANGE_NOTICE
647: * Parameters IN : p_revision_id, p_change_notice
648: * Parameters OUT: None
649: * Purpose : Updates the value of change_notice in the
650: * mtl_item_revisions_b/_tl table with the value passed as parameter
651: * for the row specified.
652: *********************************************************************/
653: PROCEDURE UPDATE_REVISION_CHANGE_NOTICE ( p_revision_id IN NUMBER
654: , p_change_notice IN VARCHAR2

Line 662: UPDATE MTL_ITEM_REVISIONS_B

658: l_user_id NUMBER := FND_GLOBAL.User_Id;
659: l_login_id NUMBER := FND_GLOBAL.Login_Id;
660: BEGIN
661:
662: UPDATE MTL_ITEM_REVISIONS_B
663: SET change_notice = p_change_notice,
664: last_update_date = SYSDATE,
665: last_update_login = l_login_id,
666: last_updated_by = l_user_id