3000: sysdate,
3001: arp_standard.profile.user_id,
3002: -3,
3003: rec.gl_date, /* original_gl_date */
3004: ra_cust_trx_line_gl_dist_s.NEXTVAL, /* cust_trx_line_gl_dist_id */
3005: p_adjustment_id,
3006: p_user_generated_flag,
3007: arp_standard.sysparm.org_id);
3008:
5202: END IF;
5203:
5204: IF g_update_db_flag = 'Y'
5205: THEN
5206: SELECT ra_cust_trx_line_gl_dist_s.NEXTVAL
5207: INTO l_dist_id
5208: FROM dual;
5209:
5210: INSERT INTO ra_cust_trx_line_gl_dist
5336: SELECT ra_cust_trx_line_salesreps_s.NEXTVAL
5337: FROM dual;
5338:
5339: CURSOR get_gldist_line_id IS
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;