40323:
40324: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
40325:
40326: UPDATE msc_st_routing_operations
40327: SET operation_sequence_id = msc_st_operation_sequence_id_s.NEXTVAL ,
40328: operation_seq_num =
40329: to_number(decode(length(rtrim(operation_seq_code,'0123456789')),
40330: NULL,operation_seq_code,'1'))
40331: WHERE rowid = lb_rowid(j);
44493:
44494: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
44495:
44496: UPDATE msc_st_resource_requirements
44497: SET operation_sequence_id = msc_st_operation_sequence_id_s.NEXTVAL ,
44498: operation_seq_num =
44499: to_number(decode(length(rtrim(operation_seq_code,'0123456789')),
44500: NULL,operation_seq_code,'1'))
44501: WHERE rowid = lb_rowid(j);
45692:
45693: IF c2%ROWCOUNT > 0 THEN
45694: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
45695:
45696: -- SELECT msc_st_operation_sequence_id_s.NEXTVAL
45697: -- INTO lv_local_id
45698: -- FROM DUAL;
45699:
45700: UPDATE msc_st_demands
45732: last_updated_by,
45733: creation_date,
45734: created_by )
45735: SELECT
45736: msc_st_operation_sequence_id_s.NEXTVAL,
45737: st_transaction_id,
45738: v_instance_id,
45739: 'OPERATION_SEQUENCE_ID',
45740: data_source_type,