APPS.PSP_ENC_SUM_TRAN dependencies on DUAL

Line 514: SELECT psp_st_run_id_s.nextval INTO g_run_id FROM dual;

510:
511: enc_control_rec enc_control_cur%ROWTYPE;
512: l_bg_id NUMBER := g_business_group_id;
513: BEGIN
514: SELECT psp_st_run_id_s.nextval INTO g_run_id FROM dual;
515:
516: OPEN enc_control_cur;
517: LOOP
518: FETCH enc_control_cur INTO enc_control_rec;

Line 1737: FROM DUAL;

1733: ) IS
1734: BEGIN
1735: SELECT PSP_ENC_SUMMARY_LINES_S.NEXTVAL
1736: INTO P_ENC_SUMMARY_LINE_ID
1737: FROM DUAL;
1738: INSERT INTO PSP_ENC_SUMMARY_LINES(
1739: ENC_SUMMARY_LINE_ID,
1740: BUSINESS_GROUP_ID,
1741: ENC_CONTROL_ID,

Line 1981: FROM dual;

1977: END IF;
1978:
1979: SELECT gl_interface_control_s.nextval
1980: INTO l_group_id
1981: FROM dual;
1982:
1983: OPEN enc_control_cur;
1984: LOOP
1985: FETCH enc_control_cur INTO enc_control_rec;

Line 2154: FROM dual;

2150: IF l_rec_count > 0 THEN --- replaced l_rec_no with l_rec_count ..2444657
2151:
2152: SELECT GL_JOURNAL_IMPORT_S.NEXTVAL
2153: INTO l_int_run_id
2154: FROM dual;
2155:
2156: insert into gl_interface_control(
2157: je_source_name,
2158: status,

Line 2373: FROM dual;

2369: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' l_enc_type_id: ' || l_enc_type_id);
2370:
2371: SELECT gl_interface_control_s.nextval
2372: INTO l_group_id
2373: FROM dual;
2374:
2375: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' l_group_id: ' || l_group_id);
2376:
2377: UPDATE psp_enc_summary_lines pesl

Line 2446: FROM DUAL;

2442:
2443: IF (SQL%ROWCOUNT > 0) THEN
2444: SELECT GL_JOURNAL_IMPORT_S.NEXTVAL
2445: INTO l_int_run_id
2446: FROM DUAL;
2447:
2448: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' l_int_run_id: ' || l_int_run_id);
2449:
2450: INSERT INTO gl_interface_control

Line 4692: FROM DUAL;

4688: FOR I in 1..org_id_tab.COUNT
4689: LOOP
4690: SELECT TO_CHAR(psp_gms_batch_name_s.NEXTVAL)
4691: INTO gms_batch_name_tab(i)
4692: FROM DUAL;
4693: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' gms_batch_name_tab(' || I || '): ' || gms_batch_name_tab(i));
4694: END LOOP;
4695:
4696:

Line 6600: SELECT psp_enc_summary_lines_s.NEXTVAL INTO t_sum_lines.enc_summary_line_id(recno) FROM DUAL;

6596: CLOSE sum_lines_cur;
6597:
6598: FOR recno IN 1..t_sum_lines.enc_control_id.COUNT
6599: LOOP
6600: SELECT psp_enc_summary_lines_s.NEXTVAL INTO t_sum_lines.enc_summary_line_id(recno) FROM DUAL;
6601: END LOOP;
6602:
6603: FORALL recno IN 1..t_sum_lines.enc_control_id.COUNT
6604: INSERT INTO psp_enc_summary_lines