DBA Data[Home] [Help]

APPS.PSP_ENC_SUM_TRAN dependencies on PSP_ENC_SUMMARY_LINES_S

Line 1735: SELECT PSP_ENC_SUMMARY_LINES_S.NEXTVAL

1731: p_attribute10 IN VARCHAR2,
1732: p_return_status OUT NOCOPY VARCHAR2
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,

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