DBA Data[Home] [Help]

APPS.BOM_BOM_REVISION_UTIL dependencies on MTL_ITEM_REVISIONS_TL

Line 117: INSERT INTO mtl_item_revisions_TL

113: SELECT userenv('LANG') INTO l_language_code FROM dual;
114:
115: -- Insert into TL table
116:
117: INSERT INTO mtl_item_revisions_TL
118: ( Inventory_Item_Id
119: , Organization_Id
120: , Revision_id
121: , Language

Line 223: UPDATE mtl_item_revisions_TL

219: SELECT userenv('LANG') INTO l_language_code FROM dual;
220:
221: -- Update the description in the TL table
222: --
223: UPDATE mtl_item_revisions_TL
224: SET description = decode(p_bom_Revision_rec.description, null, description, p_bom_Revision_rec.description)
225: , last_updated_by = l_user_Id
226: , last_update_date = sysdate
227: WHERE revision_id = l_revision_id