[Home] [Help]
2148: END LOOP; -- enc_cur
2149:
2150: IF l_rec_count > 0 THEN --- replaced l_rec_no with l_rec_count ..2444657
2151:
2152: SELECT GL_JOURNAL_IMPORT_S.NEXTVAL
2153: INTO l_int_run_id
2154: FROM dual;
2155:
2156: insert into gl_interface_control(
2440:
2441: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Number of records inserted into GL_INTERFACE: ' || SQL%ROWCOUNT);
2442:
2443: IF (SQL%ROWCOUNT > 0) THEN
2444: SELECT GL_JOURNAL_IMPORT_S.NEXTVAL
2445: INTO l_int_run_id
2446: FROM DUAL;
2447:
2448: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' l_int_run_id: ' || l_int_run_id);