3209: --
3210: insert_session(l_effective_date);
3211: commit;
3212: --
3213: fnd_file.put_line(fnd_file.output, 'Full Name Assignment Number');
3214: fnd_file.put_line(fnd_file.output, '---------------------------------------- ------------------------------');
3215: fnd_file.put_line(fnd_file.log, 'Full Name Assignment Number');
3216: fnd_file.put_line(fnd_file.log, '---------------------------------------- ------------------------------');
3217: --
3210: insert_session(l_effective_date);
3211: commit;
3212: --
3213: fnd_file.put_line(fnd_file.output, 'Full Name Assignment Number');
3214: fnd_file.put_line(fnd_file.output, '---------------------------------------- ------------------------------');
3215: fnd_file.put_line(fnd_file.log, 'Full Name Assignment Number');
3216: fnd_file.put_line(fnd_file.log, '---------------------------------------- ------------------------------');
3217: --
3218: for l_rec in csr_assact loop
3211: commit;
3212: --
3213: fnd_file.put_line(fnd_file.output, 'Full Name Assignment Number');
3214: fnd_file.put_line(fnd_file.output, '---------------------------------------- ------------------------------');
3215: fnd_file.put_line(fnd_file.log, 'Full Name Assignment Number');
3216: fnd_file.put_line(fnd_file.log, '---------------------------------------- ------------------------------');
3217: --
3218: for l_rec in csr_assact loop
3219: begin
3212: --
3213: fnd_file.put_line(fnd_file.output, 'Full Name Assignment Number');
3214: fnd_file.put_line(fnd_file.output, '---------------------------------------- ------------------------------');
3215: fnd_file.put_line(fnd_file.log, 'Full Name Assignment Number');
3216: fnd_file.put_line(fnd_file.log, '---------------------------------------- ------------------------------');
3217: --
3218: for l_rec in csr_assact loop
3219: begin
3220: do_transfer(
3222: p_object_version_number => l_rec.object_version_number,
3223: p_create_session => false);
3224: commit;
3225: --
3226: fnd_file.put_line(fnd_file.output, rpad(l_rec.full_name, 40) || ' ' || rpad(l_rec.assignment_number, 30));
3227: exception
3228: when others then
3229: retcode := '1';
3230: fnd_file.put_line(fnd_file.log, rpad(l_rec.full_name, 40) || ' ' || rpad(l_rec.assignment_number, 30));
3226: fnd_file.put_line(fnd_file.output, rpad(l_rec.full_name, 40) || ' ' || rpad(l_rec.assignment_number, 30));
3227: exception
3228: when others then
3229: retcode := '1';
3230: fnd_file.put_line(fnd_file.log, rpad(l_rec.full_name, 40) || ' ' || rpad(l_rec.assignment_number, 30));
3231: fnd_file.put_line(fnd_file.log, get_sqlerrm);
3232: end;
3233: end loop;
3234: --
3227: exception
3228: when others then
3229: retcode := '1';
3230: fnd_file.put_line(fnd_file.log, rpad(l_rec.full_name, 40) || ' ' || rpad(l_rec.assignment_number, 30));
3231: fnd_file.put_line(fnd_file.log, get_sqlerrm);
3232: end;
3233: end loop;
3234: --
3235: delete_session;