[Home] [Help]
1344: close pc_batch_cur;
1345: exit;
1346: end if;
1347: -- get the group_id. Moved the group id out of payroll control id loop. Bug 1977939
1348: SELECT gl_interface_control_s.nextval
1349: INTO l_group_id
1350: FROM DUAL;
1351:
1352: l_rec_count := 0; -- MOVED this stmt, from inside the payroll control loop id Bug 1977939.
1482: null;
1483:
1484: end;*/
1485:
1486: -- insert into gl_interface_control
1487: SELECT GL_JOURNAL_IMPORT_S.NEXTVAL
1488: INTO l_int_run_id
1489: FROM DUAL;
1490:
1489: FROM DUAL;
1490:
1491: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) ||' Calling insert_into_gl_interface ');
1492:
1493: insert into gl_interface_control(
1494: je_source_name,
1495: status,
1496: interface_run_id,
1497: group_id,
1818: and user_je_source_name = 'OLD';
1819: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) ||' deleted from gl_interface count: '||sql%rowcount);
1820:
1821:
1822: delete from gl_interface_control
1823: where group_id = l_group_id
1824: and je_source_name = 'OLD';
1825: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) ||' deleted from gl_interface count: '||sql%rowcount);
1826:
4595: where user_je_source_name = l_user_je_source_name
4596: and group_id = p_group_id ;
4597:
4598: --- Added this stmt for Bug 2133056
4599: delete from gl_interface_control
4600: where je_source_name = l_user_je_source_name
4601: and group_id = p_group_id;
4602:
4603: end if;
4761: delete from gl_interface
4762: where group_id = l_group_id
4763: and user_je_source_name = 'OLD';
4764:
4765: delete from gl_interface_control
4766: where group_id = l_group_id
4767: and je_source_name = 'OLD';
4768: end if;
4769: