APPS.MSC_CL_RPO_PRE_PROCESS dependencies on DUAL

Line 142: FROM dual;

138: LOOP
139: MSC_CL_PRE_PROCESS.v_sql_stmt := 03;
140: SELECT msc_st_batch_id_s.NEXTVAL
141: INTO lv_batch_id
142: FROM dual;
143:
144: MSC_CL_PRE_PROCESS.v_sql_stmt := 04;
145: lv_sql_stmt :=
146: ' UPDATE msc_st_supplies '

Line 729: FROM dual;

725: LOOP
726: MSC_CL_PRE_PROCESS.v_sql_stmt := 03;
727: SELECT msc_st_batch_id_s.NEXTVAL
728: INTO lv_batch_id
729: FROM dual;
730:
731: MSC_CL_PRE_PROCESS.v_sql_stmt := 04;
732: lv_sql_stmt :=
733: ' UPDATE msc_st_demands '

Line 1303: FROM dual;

1299: LOOP
1300: MSC_CL_PRE_PROCESS.v_sql_stmt := 03;
1301: SELECT msc_st_batch_id_s.NEXTVAL
1302: INTO lv_batch_id
1303: FROM dual;
1304:
1305: MSC_CL_PRE_PROCESS.v_sql_stmt := 04;
1306: lv_sql_stmt :=
1307: ' UPDATE msc_st_supplies '

Line 2400: FROM DUAL;

2396: LOOP
2397: MSC_CL_PRE_PROCESS.v_sql_stmt := 03;
2398: SELECT msc_st_batch_id_s.NEXTVAL
2399: INTO lv_batch_id
2400: FROM DUAL;
2401:
2402: MSC_CL_PRE_PROCESS.v_sql_stmt := 04;
2403: lv_sql_stmt :=
2404: ' UPDATE msc_st_demands '

Line 3175: -- FROM DUAL;

3171: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
3172:
3173: -- SELECT msc_st_operation_sequence_id_s.NEXTVAL
3174: -- INTO lv_local_id
3175: -- FROM DUAL;
3176:
3177: UPDATE msc_st_demands
3178: SET operation_seq_num =
3179: to_number(decode(length(rtrim(operation_seq_code,'0123456789')),