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 169: UPDATE Mtl_Item_Revisions_b

165: l_revision_id NUMBER;
166: l_user_id NUMBER := FND_GLOBAL.User_Id;
167: l_login_id NUMBER := FND_GLOBAL.Login_Id;
168: BEGIN
169: UPDATE Mtl_Item_Revisions_b
170: SET --description = p_bom_revision_rec.Description,
171: effectivity_date = NVL(p_bom_revision_rec.start_effective_date,sysdate),--bug:4242412 Replace NULL effectivity date by SYSDATE
172: revision_label= p_bom_revision_rec.revision_label,
173: revision_reason= p_bom_revision_rec.revision_reason,