[Home] [Help]
214: , SYSDATE
215: );
216: -- Update bom_operation sequences to set the X and Y coordinates
217: -- for the operations involved in this network.
218: update BOM_OPERATION_SEQUENCES set
219: X_COORDINATE = p_op_network_rec.From_X_Coordinate
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
227: , program_update_date = SYSDATE
228: where operation_sequence_id =
229: p_op_network_unexp_rec.from_op_seq_id;
230:
231: update BOM_OPERATION_SEQUENCES set
232: X_COORDINATE = p_op_network_rec.To_X_Coordinate
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
325: AND to_op_seq_id = p_op_network_unexp_rec.to_op_seq_id;
326:
327: -- Update bom_operation sequences to set the X and Y coordinates
328: -- for the operations involved in this network.
329: update BOM_OPERATION_SEQUENCES set
330: X_COORDINATE = p_op_network_rec.From_X_Coordinate
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
341: NULL , p_op_network_unexp_rec.from_op_seq_id,
342: p_op_network_unexp_rec.new_from_op_seq_id);
343:
344:
345: update BOM_OPERATION_SEQUENCES set
346: X_COORDINATE = p_op_network_rec.To_X_Coordinate
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
873: Error_Handler.Write_Debug( ' Copying operation ' || p_operation_sequence_id );
874: END IF;
875:
876: -- Get a new operation sequence id
877: SELECT BOM_OPERATION_SEQUENCES_S.NEXTVAL
878: INTO l_op_seq_id
879: FROM DUAL;
880:
881: -- Copy the disabled operation with effectivity date as disable date plus one minute