2500: --
2501: insert_session(l_effective_date);
2502: commit;
2503: --
2504: fnd_file.put_line(fnd_file.output, 'Full Name Assignment Number');
2505: fnd_file.put_line(fnd_file.output, '---------------------------------------- ------------------------------');
2506: fnd_file.put_line(fnd_file.log, 'Full Name Assignment Number');
2507: fnd_file.put_line(fnd_file.log, '---------------------------------------- ------------------------------');
2508: --
2501: insert_session(l_effective_date);
2502: commit;
2503: --
2504: fnd_file.put_line(fnd_file.output, 'Full Name Assignment Number');
2505: fnd_file.put_line(fnd_file.output, '---------------------------------------- ------------------------------');
2506: fnd_file.put_line(fnd_file.log, 'Full Name Assignment Number');
2507: fnd_file.put_line(fnd_file.log, '---------------------------------------- ------------------------------');
2508: --
2509: for l_rec in csr_assact loop
2502: commit;
2503: --
2504: fnd_file.put_line(fnd_file.output, 'Full Name Assignment Number');
2505: fnd_file.put_line(fnd_file.output, '---------------------------------------- ------------------------------');
2506: fnd_file.put_line(fnd_file.log, 'Full Name Assignment Number');
2507: fnd_file.put_line(fnd_file.log, '---------------------------------------- ------------------------------');
2508: --
2509: for l_rec in csr_assact loop
2510: begin
2503: --
2504: fnd_file.put_line(fnd_file.output, 'Full Name Assignment Number');
2505: fnd_file.put_line(fnd_file.output, '---------------------------------------- ------------------------------');
2506: fnd_file.put_line(fnd_file.log, 'Full Name Assignment Number');
2507: fnd_file.put_line(fnd_file.log, '---------------------------------------- ------------------------------');
2508: --
2509: for l_rec in csr_assact loop
2510: begin
2511: do_transfer(
2513: p_object_version_number => l_rec.object_version_number,
2514: p_create_session => false);
2515: commit;
2516: --
2517: fnd_file.put_line(fnd_file.output, rpad(l_rec.full_name, 40) || ' ' || rpad(l_rec.assignment_number, 30));
2518: exception
2519: when others then
2520: retcode := '1';
2521: fnd_file.put_line(fnd_file.log, rpad(l_rec.full_name, 40) || ' ' || rpad(l_rec.assignment_number, 30));
2517: fnd_file.put_line(fnd_file.output, rpad(l_rec.full_name, 40) || ' ' || rpad(l_rec.assignment_number, 30));
2518: exception
2519: when others then
2520: retcode := '1';
2521: fnd_file.put_line(fnd_file.log, rpad(l_rec.full_name, 40) || ' ' || rpad(l_rec.assignment_number, 30));
2522: fnd_file.put_line(fnd_file.log, get_sqlerrm);
2523: end;
2524: end loop;
2525: --
2518: exception
2519: when others then
2520: retcode := '1';
2521: fnd_file.put_line(fnd_file.log, rpad(l_rec.full_name, 40) || ' ' || rpad(l_rec.assignment_number, 30));
2522: fnd_file.put_line(fnd_file.log, get_sqlerrm);
2523: end;
2524: end loop;
2525: --
2526: delete_session;