242: , SYSDATE
243: , BOM_Rtg_Globals.Get_User_Id
244: , BOM_Rtg_Globals.Get_Login_Id
245: , p_rtg_header_rec.original_system_reference
246: , Fnd_Global.Conc_Request_Id
247: , Fnd_Global.Conc_Program_Id
248: , Fnd_Global.Prog_Appl_Id
249: , SYSDATE
250: );
243: , BOM_Rtg_Globals.Get_User_Id
244: , BOM_Rtg_Globals.Get_Login_Id
245: , p_rtg_header_rec.original_system_reference
246: , Fnd_Global.Conc_Request_Id
247: , Fnd_Global.Conc_Program_Id
248: , Fnd_Global.Prog_Appl_Id
249: , SYSDATE
250: );
251:
244: , BOM_Rtg_Globals.Get_Login_Id
245: , p_rtg_header_rec.original_system_reference
246: , Fnd_Global.Conc_Request_Id
247: , Fnd_Global.Conc_Program_Id
248: , Fnd_Global.Prog_Appl_Id
249: , SYSDATE
250: );
251:
252:
280: , SYSDATE
281: , BOM_Rtg_Globals.Get_User_Id
282: , BOM_Rtg_Globals.Get_Login_Id
283: , SYSDATE
284: , Fnd_Global.Conc_Request_Id
285: , Fnd_Global.Conc_Program_Id
286: , Fnd_Global.Prog_Appl_Id
287: , SYSDATE
288: FROM MTL_PARAMETERS mp
281: , BOM_Rtg_Globals.Get_User_Id
282: , BOM_Rtg_Globals.Get_Login_Id
283: , SYSDATE
284: , Fnd_Global.Conc_Request_Id
285: , Fnd_Global.Conc_Program_Id
286: , Fnd_Global.Prog_Appl_Id
287: , SYSDATE
288: FROM MTL_PARAMETERS mp
289: WHERE mp.organization_id = p_rtg_header_unexp_rec.organization_id
282: , BOM_Rtg_Globals.Get_Login_Id
283: , SYSDATE
284: , Fnd_Global.Conc_Request_Id
285: , Fnd_Global.Conc_Program_Id
286: , Fnd_Global.Prog_Appl_Id
287: , SYSDATE
288: FROM MTL_PARAMETERS mp
289: WHERE mp.organization_id = p_rtg_header_unexp_rec.organization_id
290: AND NOT EXISTS( SELECT NULL
384: , attribute13= p_rtg_header_rec.attribute13
385: , attribute14= p_rtg_header_rec.attribute14
386: , attribute15= p_rtg_header_rec.attribute15
387: , original_system_reference = p_rtg_header_rec.original_system_reference
388: , request_id = Fnd_Global.Conc_Request_Id
389: , program_id = Fnd_Global.Conc_Program_Id
390: , program_application_id = Fnd_Global.Prog_Appl_Id
391: , program_update_date = SYSDATE
392: WHERE routing_sequence_id =
385: , attribute14= p_rtg_header_rec.attribute14
386: , attribute15= p_rtg_header_rec.attribute15
387: , original_system_reference = p_rtg_header_rec.original_system_reference
388: , request_id = Fnd_Global.Conc_Request_Id
389: , program_id = Fnd_Global.Conc_Program_Id
390: , program_application_id = Fnd_Global.Prog_Appl_Id
391: , program_update_date = SYSDATE
392: WHERE routing_sequence_id =
393: p_rtg_header_unexp_rec.routing_sequence_id
386: , attribute15= p_rtg_header_rec.attribute15
387: , original_system_reference = p_rtg_header_rec.original_system_reference
388: , request_id = Fnd_Global.Conc_Request_Id
389: , program_id = Fnd_Global.Conc_Program_Id
390: , program_application_id = Fnd_Global.Prog_Appl_Id
391: , program_update_date = SYSDATE
392: WHERE routing_sequence_id =
393: p_rtg_header_unexp_rec.routing_sequence_id
394: ;