APPS.MSC_CL_PRE_PROCESS dependencies on MSC_ST_OPERATION_SEQUENCE_ID_S

Line 45111: SET operation_sequence_id = msc_st_operation_sequence_id_s.NEXTVAL ,

45107:
45108: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
45109:
45110: UPDATE msc_st_routing_operations
45111: SET operation_sequence_id = msc_st_operation_sequence_id_s.NEXTVAL ,
45112: operation_seq_num =
45113: to_number(decode(length(rtrim(operation_seq_code,'0123456789')),
45114: NULL,operation_seq_code,'1'))
45115: WHERE rowid = lb_rowid(j);

Line 49381: SET operation_sequence_id = msc_st_operation_sequence_id_s.NEXTVAL ,

49377:
49378: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
49379:
49380: UPDATE msc_st_resource_requirements
49381: SET operation_sequence_id = msc_st_operation_sequence_id_s.NEXTVAL ,
49382: operation_seq_num =
49383: to_number(decode(length(rtrim(operation_seq_code,'0123456789')),
49384: NULL,operation_seq_code,'1'))
49385: WHERE rowid = lb_rowid(j);

Line 50580: -- SELECT msc_st_operation_sequence_id_s.NEXTVAL

50576:
50577: IF c2%ROWCOUNT > 0 THEN
50578: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
50579:
50580: -- SELECT msc_st_operation_sequence_id_s.NEXTVAL
50581: -- INTO lv_local_id
50582: -- FROM DUAL;
50583:
50584: UPDATE msc_st_demands

Line 50620: msc_st_operation_sequence_id_s.NEXTVAL,

50616: last_updated_by,
50617: creation_date,
50618: created_by )
50619: SELECT
50620: msc_st_operation_sequence_id_s.NEXTVAL,
50621: st_transaction_id,
50622: v_instance_id,
50623: 'OPERATION_SEQUENCE_ID',
50624: data_source_type,