[Home] [Help]
2169: END LOOP; -- enc_cur
2170:
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(
2459: AND pesl.group_id = l_group_id
2460: AND pesl.payroll_action_id = p_payroll_action_id;
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);