223: , BOM_Rtg_Globals.Get_User_Id
224: , SYSDATE
225: , BOM_Rtg_Globals.Get_User_Id
226: , BOM_Rtg_Globals.Get_User_Id
227: , Fnd_Global.Conc_Request_Id
228: , Fnd_Global.Conc_Program_Id
229: , Fnd_Global.Prog_Appl_Id
230: , SYSDATE
231: );
224: , SYSDATE
225: , BOM_Rtg_Globals.Get_User_Id
226: , BOM_Rtg_Globals.Get_User_Id
227: , Fnd_Global.Conc_Request_Id
228: , Fnd_Global.Conc_Program_Id
229: , Fnd_Global.Prog_Appl_Id
230: , SYSDATE
231: );
232: x_return_status := FND_API.G_RET_STS_SUCCESS;
225: , BOM_Rtg_Globals.Get_User_Id
226: , BOM_Rtg_Globals.Get_User_Id
227: , Fnd_Global.Conc_Request_Id
228: , Fnd_Global.Conc_Program_Id
229: , Fnd_Global.Prog_Appl_Id
230: , SYSDATE
231: );
232: x_return_status := FND_API.G_RET_STS_SUCCESS;
233:
296: , attribute12= p_rtg_revision_rec.attribute12
297: , attribute13= p_rtg_revision_rec.attribute13
298: , attribute14= p_rtg_revision_rec.attribute14
299: , attribute15= p_rtg_revision_rec.attribute15
300: , request_id = Fnd_Global.Conc_Request_Id
301: , program_id = Fnd_Global.Conc_Program_Id
302: , program_application_id = Fnd_Global.Prog_Appl_Id
303: , program_update_date = SYSDATE
304: WHERE inventory_item_id = p_rtg_rev_unexp_rec.assembly_item_id AND organization_id = p_rtg_rev_unexp_rec.organization_id
297: , attribute13= p_rtg_revision_rec.attribute13
298: , attribute14= p_rtg_revision_rec.attribute14
299: , attribute15= p_rtg_revision_rec.attribute15
300: , request_id = Fnd_Global.Conc_Request_Id
301: , program_id = Fnd_Global.Conc_Program_Id
302: , program_application_id = Fnd_Global.Prog_Appl_Id
303: , program_update_date = SYSDATE
304: WHERE inventory_item_id = p_rtg_rev_unexp_rec.assembly_item_id AND organization_id = p_rtg_rev_unexp_rec.organization_id
305: AND process_revision = p_rtg_revision_rec.revision;
298: , attribute14= p_rtg_revision_rec.attribute14
299: , attribute15= p_rtg_revision_rec.attribute15
300: , request_id = Fnd_Global.Conc_Request_Id
301: , program_id = Fnd_Global.Conc_Program_Id
302: , program_application_id = Fnd_Global.Prog_Appl_Id
303: , program_update_date = SYSDATE
304: WHERE inventory_item_id = p_rtg_rev_unexp_rec.assembly_item_id AND organization_id = p_rtg_rev_unexp_rec.organization_id
305: AND process_revision = p_rtg_revision_rec.revision;
306: