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: );
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
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.
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 =
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;
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:
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 =
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;
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:
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
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;
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:
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 =
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,
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,
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 =
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,
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,