APPS.PSP_ENC_SUM_TRAN dependencies on DUAL

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

520: enc_control_rec enc_control_cur%ROWTYPE;
521: l_bg_id NUMBER := g_business_group_id;
522: BEGIN
523: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || 'Entering Enc_Batch_begin ');
524: SELECT psp_st_run_id_s.nextval INTO g_run_id FROM dual;
525:
526: OPEN enc_control_cur;
527: LOOP
528: FETCH enc_control_cur INTO enc_control_rec;

Line 1757: FROM DUAL;

1753: ) IS
1754: BEGIN
1755: SELECT PSP_ENC_SUMMARY_LINES_S.NEXTVAL
1756: INTO P_ENC_SUMMARY_LINE_ID
1757: FROM DUAL;
1758: INSERT INTO PSP_ENC_SUMMARY_LINES(
1759: ENC_SUMMARY_LINE_ID,
1760: BUSINESS_GROUP_ID,
1761: ENC_CONTROL_ID,

Line 2002: FROM dual;

1998: END IF;
1999:
2000: SELECT gl_interface_control_s.nextval
2001: INTO l_group_id
2002: FROM dual;
2003:
2004: OPEN enc_control_cur;
2005: LOOP
2006: FETCH enc_control_cur INTO enc_control_rec;

Line 2175: FROM dual;

2171: IF l_rec_count > 0 THEN --- replaced l_rec_no with l_rec_count ..2444657
2172:
2173: SELECT GL_JOURNAL_IMPORT_S.NEXTVAL
2174: INTO l_int_run_id
2175: FROM dual;
2176:
2177: insert into gl_interface_control(
2178: je_source_name,
2179: status,

Line 2394: FROM dual;

2390: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' l_enc_type_id: ' || l_enc_type_id);
2391:
2392: SELECT gl_interface_control_s.nextval
2393: INTO l_group_id
2394: FROM dual;
2395:
2396: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' l_group_id: ' || l_group_id);
2397:
2398: UPDATE psp_enc_summary_lines pesl

Line 2465: FROM DUAL;

2461:
2462: IF (SQL%ROWCOUNT > 0) THEN
2463: SELECT GL_JOURNAL_IMPORT_S.NEXTVAL
2464: INTO l_int_run_id
2465: FROM DUAL;
2466:
2467: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' l_int_run_id: ' || l_int_run_id);
2468:
2469: INSERT INTO gl_interface_control

Line 4801: FROM DUAL;

4797: FOR I in 1..org_id_tab.COUNT
4798: LOOP
4799: SELECT TO_CHAR(psp_gms_batch_name_s.NEXTVAL)
4800: INTO gms_batch_name_tab(i)
4801: FROM DUAL;
4802: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' gms_batch_name_tab(' || I || '): ' || gms_batch_name_tab(i));
4803: END LOOP;
4804:
4805:

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

6830: CLOSE sum_lines_cur;
6831:
6832: FOR recno IN 1..t_sum_lines.enc_control_id.COUNT
6833: LOOP
6834: SELECT psp_enc_summary_lines_s.NEXTVAL INTO t_sum_lines.enc_summary_line_id(recno) FROM DUAL;
6835: END LOOP;
6836:
6837: FORALL recno IN 1..t_sum_lines.enc_control_id.COUNT
6838: INSERT INTO psp_enc_summary_lines