APPS.PSP_ENC_SUM_TRAN dependencies on PSP_ENC_SUMMARY_LINES_S

Line 1755: SELECT PSP_ENC_SUMMARY_LINES_S.NEXTVAL

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

Line 4829: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || 'updating psp_enc_summary_lines setting status_code N count: '||g_bulk_row_count);

4825: loop
4826: g_bulk_row_count := g_bulk_row_count + SQL%BULK_ROWCOUNT(bulk_idx);
4827: end loop;
4828:
4829: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || 'updating psp_enc_summary_lines setting status_code N count: '||g_bulk_row_count);
4830:
4831: OPEN int_cur;
4832: FETCH int_cur BULK COLLECT INTO r_interface.txn_interface_id, r_interface.enc_summary_line_id,
4833: r_interface.effective_date, r_interface.time_period_id,

Line 5140: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || 'update psp_enc_summary_lines setting encumbrance_item_id count: '||g_bulk_row_count);

5136: loop
5137: g_bulk_row_count := g_bulk_row_count + SQL%BULK_ROWCOUNT(bulk_idx);
5138: end loop;
5139:
5140: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || 'update psp_enc_summary_lines setting encumbrance_item_id count: '||g_bulk_row_count);
5141:
5142:
5143: FORALL recno IN 1..r_gms_batch.gms_batch_name.COUNT
5144: DELETE pa_transaction_interface_all

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