5340: SELECT ra_cust_trx_line_gl_dist_s.NEXTVAL
5341: FROM dual;
5342:
5343: l_user_id NUMBER;
5344: l_account_class ra_cust_trx_line_gl_dist_all.account_class%TYPE;
5345: l_gl_dist_id ra_cust_trx_line_gl_dist_all.cust_trx_line_gl_dist_id%TYPE;
5346: l_ccid ra_cust_trx_line_gl_dist_all.code_combination_id%TYPE;
5347: l_concat_segments VARCHAR2(2000);
5348: l_fail_count NUMBER := 0;
5341: FROM dual;
5342:
5343: l_user_id NUMBER;
5344: l_account_class ra_cust_trx_line_gl_dist_all.account_class%TYPE;
5345: l_gl_dist_id ra_cust_trx_line_gl_dist_all.cust_trx_line_gl_dist_id%TYPE;
5346: l_ccid ra_cust_trx_line_gl_dist_all.code_combination_id%TYPE;
5347: l_concat_segments VARCHAR2(2000);
5348: l_fail_count NUMBER := 0;
5349:
5342:
5343: l_user_id NUMBER;
5344: l_account_class ra_cust_trx_line_gl_dist_all.account_class%TYPE;
5345: l_gl_dist_id ra_cust_trx_line_gl_dist_all.cust_trx_line_gl_dist_id%TYPE;
5346: l_ccid ra_cust_trx_line_gl_dist_all.code_combination_id%TYPE;
5347: l_concat_segments VARCHAR2(2000);
5348: l_fail_count NUMBER := 0;
5349:
5350: invalid_ccid EXCEPTION;