APPS.BOM_BOM_REVISION_UTIL dependencies on MTL_ITEM_REVISIONS_B

Line 38: INSERT INTO MTL_ITEM_REVISIONS_B(

34: l_user_id NUMBER := FND_GLOBAL.User_Id;
35: l_login_id NUMBER := FND_GLOBAL.Login_Id;
36: BEGIN
37: --bug:3254815 Update request id, prog id, prog appl id and prog update date.
38: INSERT INTO MTL_ITEM_REVISIONS_B(
39: inventory_item_id,
40: organization_id,
41: revision,
42: revision_label,

Line 105: mtl_item_revisions_b_s.NEXTVAL,

101: p_bom_revision_rec.Attribute13,
102: p_bom_revision_rec.Attribute14,
103: p_bom_revision_rec.Attribute15,
104: --p_bom_revision_rec.Description
105: mtl_item_revisions_b_s.NEXTVAL,
106: 1,
107: Fnd_Global.Conc_Request_Id,
108: Fnd_Global.Conc_Program_Id,
109: Fnd_Global.Prog_Appl_Id,

Line 184: UPDATE Mtl_Item_Revisions_b

180: l_revision_id NUMBER;
181: l_user_id NUMBER := FND_GLOBAL.User_Id;
182: l_login_id NUMBER := FND_GLOBAL.Login_Id;
183: BEGIN
184: UPDATE Mtl_Item_Revisions_b
185: SET --description = p_bom_revision_rec.Description,
186: effectivity_date = NVL(p_bom_revision_rec.start_effective_date,sysdate),--bug:4242412 Replace NULL effectivity date by SYSDATE
187: revision_label= p_bom_revision_rec.revision_label,
188: revision_reason= p_bom_revision_rec.revision_reason,