DBA Data[Home] [Help]

APPS.BOM_OP_NETWORK_UTIL dependencies on FND_GLOBAL

Line 211: , Fnd_Global.Conc_Request_Id

207: , SYSDATE
208: , BOM_Rtg_Globals.Get_User_Id
209: , BOM_Rtg_Globals.Get_Login_Id
210: , p_op_network_rec.original_system_reference -- Added by MK 05/01
211: , Fnd_Global.Conc_Request_Id
212: , Fnd_Global.Conc_Program_Id
213: , Fnd_Global.Prog_Appl_Id
214: , SYSDATE
215: );

Line 212: , Fnd_Global.Conc_Program_Id

208: , BOM_Rtg_Globals.Get_User_Id
209: , BOM_Rtg_Globals.Get_Login_Id
210: , p_op_network_rec.original_system_reference -- Added by MK 05/01
211: , Fnd_Global.Conc_Request_Id
212: , Fnd_Global.Conc_Program_Id
213: , Fnd_Global.Prog_Appl_Id
214: , SYSDATE
215: );
216: -- Update bom_operation sequences to set the X and Y coordinates

Line 213: , Fnd_Global.Prog_Appl_Id

209: , BOM_Rtg_Globals.Get_Login_Id
210: , p_op_network_rec.original_system_reference -- Added by MK 05/01
211: , Fnd_Global.Conc_Request_Id
212: , Fnd_Global.Conc_Program_Id
213: , Fnd_Global.Prog_Appl_Id
214: , SYSDATE
215: );
216: -- Update bom_operation sequences to set the X and Y coordinates
217: -- for the operations involved in this network.

Line 224: , request_id = Fnd_Global.Conc_Request_Id

220: ,Y_COORDINATE = p_op_network_rec.From_Y_Coordinate
221: , last_update_date = SYSDATE
222: , last_updated_by = BOM_Rtg_Globals.Get_User_Id
223: , last_update_login = BOM_Rtg_Globals.Get_Login_Id
224: , request_id = Fnd_Global.Conc_Request_Id
225: , program_id = Fnd_Global.Conc_Program_Id
226: , program_application_id = Fnd_Global.Prog_Appl_Id
227: , program_update_date = SYSDATE
228: where operation_sequence_id =

Line 225: , program_id = Fnd_Global.Conc_Program_Id

221: , last_update_date = SYSDATE
222: , last_updated_by = BOM_Rtg_Globals.Get_User_Id
223: , last_update_login = BOM_Rtg_Globals.Get_Login_Id
224: , request_id = Fnd_Global.Conc_Request_Id
225: , program_id = Fnd_Global.Conc_Program_Id
226: , program_application_id = Fnd_Global.Prog_Appl_Id
227: , program_update_date = SYSDATE
228: where operation_sequence_id =
229: p_op_network_unexp_rec.from_op_seq_id;

Line 226: , program_application_id = Fnd_Global.Prog_Appl_Id

222: , last_updated_by = BOM_Rtg_Globals.Get_User_Id
223: , last_update_login = BOM_Rtg_Globals.Get_Login_Id
224: , request_id = Fnd_Global.Conc_Request_Id
225: , program_id = Fnd_Global.Conc_Program_Id
226: , program_application_id = Fnd_Global.Prog_Appl_Id
227: , program_update_date = SYSDATE
228: where operation_sequence_id =
229: p_op_network_unexp_rec.from_op_seq_id;
230:

Line 237: , request_id = Fnd_Global.Conc_Request_Id

233: ,Y_COORDINATE = p_op_network_rec.To_Y_Coordinate
234: , last_update_date = SYSDATE
235: , last_updated_by = BOM_Rtg_Globals.Get_User_Id
236: , last_update_login = BOM_Rtg_Globals.Get_Login_Id
237: , request_id = Fnd_Global.Conc_Request_Id
238: , program_id = Fnd_Global.Conc_Program_Id
239: , program_application_id = Fnd_Global.Prog_Appl_Id
240: , program_update_date = SYSDATE
241: where operation_sequence_id =

Line 238: , program_id = Fnd_Global.Conc_Program_Id

234: , last_update_date = SYSDATE
235: , last_updated_by = BOM_Rtg_Globals.Get_User_Id
236: , last_update_login = BOM_Rtg_Globals.Get_Login_Id
237: , request_id = Fnd_Global.Conc_Request_Id
238: , program_id = Fnd_Global.Conc_Program_Id
239: , program_application_id = Fnd_Global.Prog_Appl_Id
240: , program_update_date = SYSDATE
241: where operation_sequence_id =
242: p_op_network_unexp_rec.to_op_seq_id;

Line 239: , program_application_id = Fnd_Global.Prog_Appl_Id

235: , last_updated_by = BOM_Rtg_Globals.Get_User_Id
236: , last_update_login = BOM_Rtg_Globals.Get_Login_Id
237: , request_id = Fnd_Global.Conc_Request_Id
238: , program_id = Fnd_Global.Conc_Program_Id
239: , program_application_id = Fnd_Global.Prog_Appl_Id
240: , program_update_date = SYSDATE
241: where operation_sequence_id =
242: p_op_network_unexp_rec.to_op_seq_id;
243:

Line 320: , request_id = Fnd_Global.Conc_Request_Id

316: , attribute13= p_op_network_rec.attribute13
317: , attribute14= p_op_network_rec.attribute14
318: , attribute15= p_op_network_rec.attribute15
319: , original_system_reference = p_op_network_rec.original_system_reference
320: , request_id = Fnd_Global.Conc_Request_Id
321: , program_id = Fnd_Global.Conc_Program_Id
322: , program_application_id = Fnd_Global.Prog_Appl_Id
323: , program_update_date = SYSDATE
324: WHERE from_op_seq_id = p_op_network_unexp_rec.from_op_seq_id

Line 321: , program_id = Fnd_Global.Conc_Program_Id

317: , attribute14= p_op_network_rec.attribute14
318: , attribute15= p_op_network_rec.attribute15
319: , original_system_reference = p_op_network_rec.original_system_reference
320: , request_id = Fnd_Global.Conc_Request_Id
321: , program_id = Fnd_Global.Conc_Program_Id
322: , program_application_id = Fnd_Global.Prog_Appl_Id
323: , program_update_date = SYSDATE
324: WHERE from_op_seq_id = p_op_network_unexp_rec.from_op_seq_id
325: AND to_op_seq_id = p_op_network_unexp_rec.to_op_seq_id;

Line 322: , program_application_id = Fnd_Global.Prog_Appl_Id

318: , attribute15= p_op_network_rec.attribute15
319: , original_system_reference = p_op_network_rec.original_system_reference
320: , request_id = Fnd_Global.Conc_Request_Id
321: , program_id = Fnd_Global.Conc_Program_Id
322: , program_application_id = Fnd_Global.Prog_Appl_Id
323: , program_update_date = SYSDATE
324: WHERE from_op_seq_id = p_op_network_unexp_rec.from_op_seq_id
325: AND to_op_seq_id = p_op_network_unexp_rec.to_op_seq_id;
326:

Line 335: , request_id = Fnd_Global.Conc_Request_Id

331: ,Y_COORDINATE = p_op_network_rec.From_Y_Coordinate
332: , last_update_date = SYSDATE
333: , last_updated_by = BOM_Rtg_Globals.Get_User_Id
334: , last_update_login = BOM_Rtg_Globals.Get_Login_Id
335: , request_id = Fnd_Global.Conc_Request_Id
336: , program_id = Fnd_Global.Conc_Program_Id
337: , program_application_id = Fnd_Global.Prog_Appl_Id
338: , program_update_date = SYSDATE
339: where operation_sequence_id =

Line 336: , program_id = Fnd_Global.Conc_Program_Id

332: , last_update_date = SYSDATE
333: , last_updated_by = BOM_Rtg_Globals.Get_User_Id
334: , last_update_login = BOM_Rtg_Globals.Get_Login_Id
335: , request_id = Fnd_Global.Conc_Request_Id
336: , program_id = Fnd_Global.Conc_Program_Id
337: , program_application_id = Fnd_Global.Prog_Appl_Id
338: , program_update_date = SYSDATE
339: where operation_sequence_id =
340: DECODE(p_op_network_unexp_rec.new_from_op_seq_id,

Line 337: , program_application_id = Fnd_Global.Prog_Appl_Id

333: , last_updated_by = BOM_Rtg_Globals.Get_User_Id
334: , last_update_login = BOM_Rtg_Globals.Get_Login_Id
335: , request_id = Fnd_Global.Conc_Request_Id
336: , program_id = Fnd_Global.Conc_Program_Id
337: , program_application_id = Fnd_Global.Prog_Appl_Id
338: , program_update_date = SYSDATE
339: where operation_sequence_id =
340: DECODE(p_op_network_unexp_rec.new_from_op_seq_id,
341: NULL , p_op_network_unexp_rec.from_op_seq_id,

Line 351: , request_id = Fnd_Global.Conc_Request_Id

347: ,Y_COORDINATE = p_op_network_rec.To_Y_Coordinate
348: , last_update_date = SYSDATE
349: , last_updated_by = BOM_Rtg_Globals.Get_User_Id
350: , last_update_login = BOM_Rtg_Globals.Get_Login_Id
351: , request_id = Fnd_Global.Conc_Request_Id
352: , program_id = Fnd_Global.Conc_Program_Id
353: , program_application_id = Fnd_Global.Prog_Appl_Id
354: , program_update_date = SYSDATE
355: where operation_sequence_id =

Line 352: , program_id = Fnd_Global.Conc_Program_Id

348: , last_update_date = SYSDATE
349: , last_updated_by = BOM_Rtg_Globals.Get_User_Id
350: , last_update_login = BOM_Rtg_Globals.Get_Login_Id
351: , request_id = Fnd_Global.Conc_Request_Id
352: , program_id = Fnd_Global.Conc_Program_Id
353: , program_application_id = Fnd_Global.Prog_Appl_Id
354: , program_update_date = SYSDATE
355: where operation_sequence_id =
356: DECODE(p_op_network_unexp_rec.new_to_op_seq_id,

Line 353: , program_application_id = Fnd_Global.Prog_Appl_Id

349: , last_updated_by = BOM_Rtg_Globals.Get_User_Id
350: , last_update_login = BOM_Rtg_Globals.Get_Login_Id
351: , request_id = Fnd_Global.Conc_Request_Id
352: , program_id = Fnd_Global.Conc_Program_Id
353: , program_application_id = Fnd_Global.Prog_Appl_Id
354: , program_update_date = SYSDATE
355: where operation_sequence_id =
356: DECODE(p_op_network_unexp_rec.new_to_op_seq_id,
357: NULL , p_op_network_unexp_rec.to_op_seq_id,