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 730: FROM dual;

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

Line 1334: FROM dual;

1330: LOOP
1331: MSC_CL_PRE_PROCESS.v_sql_stmt := 03;
1332: SELECT msc_st_batch_id_s.NEXTVAL
1333: INTO lv_batch_id
1334: FROM dual;
1335:
1336: MSC_CL_PRE_PROCESS.v_sql_stmt := 04;
1337: lv_sql_stmt :=
1338: ' UPDATE msc_st_supplies '

Line 2431: FROM DUAL;

2427: LOOP
2428: MSC_CL_PRE_PROCESS.v_sql_stmt := 03;
2429: SELECT msc_st_batch_id_s.NEXTVAL
2430: INTO lv_batch_id
2431: FROM DUAL;
2432:
2433: MSC_CL_PRE_PROCESS.v_sql_stmt := 04;
2434: lv_sql_stmt :=
2435: ' UPDATE msc_st_demands '

Line 3206: -- FROM DUAL;

3202: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
3203:
3204: -- SELECT msc_st_operation_sequence_id_s.NEXTVAL
3205: -- INTO lv_local_id
3206: -- FROM DUAL;
3207:
3208: UPDATE msc_st_demands
3209: SET operation_seq_num =
3210: to_number(decode(length(rtrim(operation_seq_code,'0123456789')),