4900: --
4901: insert_session(l_effective_date);
4902: commit;
4903: --
4904: fnd_file.put_line(fnd_file.output, 'Full Name Assignment Number');
4905: fnd_file.put_line(fnd_file.output, '---------------------------------------- ------------------------------');
4906: fnd_file.put_line(fnd_file.log, 'Full Name Assignment Number');
4907: fnd_file.put_line(fnd_file.log, '---------------------------------------- ------------------------------');
4908: --
4901: insert_session(l_effective_date);
4902: commit;
4903: --
4904: fnd_file.put_line(fnd_file.output, 'Full Name Assignment Number');
4905: fnd_file.put_line(fnd_file.output, '---------------------------------------- ------------------------------');
4906: fnd_file.put_line(fnd_file.log, 'Full Name Assignment Number');
4907: fnd_file.put_line(fnd_file.log, '---------------------------------------- ------------------------------');
4908: --
4909: for l_rec in csr_assact loop
4902: commit;
4903: --
4904: fnd_file.put_line(fnd_file.output, 'Full Name Assignment Number');
4905: fnd_file.put_line(fnd_file.output, '---------------------------------------- ------------------------------');
4906: fnd_file.put_line(fnd_file.log, 'Full Name Assignment Number');
4907: fnd_file.put_line(fnd_file.log, '---------------------------------------- ------------------------------');
4908: --
4909: for l_rec in csr_assact loop
4910: --
4903: --
4904: fnd_file.put_line(fnd_file.output, 'Full Name Assignment Number');
4905: fnd_file.put_line(fnd_file.output, '---------------------------------------- ------------------------------');
4906: fnd_file.put_line(fnd_file.log, 'Full Name Assignment Number');
4907: fnd_file.put_line(fnd_file.log, '---------------------------------------- ------------------------------');
4908: --
4909: for l_rec in csr_assact loop
4910: --
4911: begin
4916: p_user_comments => p_user_comments);
4917: --
4918: commit;
4919: --
4920: fnd_file.put_line(fnd_file.output, rpad(l_rec.full_name, 40) || ' ' || rpad(l_rec.assignment_number, 30));
4921: --
4922: exception
4923: when others then
4924: --
4921: --
4922: exception
4923: when others then
4924: --
4925: fnd_file.put_line(fnd_file.log, rpad(l_rec.full_name, 40) || ' ' || rpad(l_rec.assignment_number, 30));
4926: fnd_file.put_line(fnd_file.log, get_sqlerrm);
4927: --
4928: end;
4929: --
4922: exception
4923: when others then
4924: --
4925: fnd_file.put_line(fnd_file.log, rpad(l_rec.full_name, 40) || ' ' || rpad(l_rec.assignment_number, 30));
4926: fnd_file.put_line(fnd_file.log, get_sqlerrm);
4927: --
4928: end;
4929: --
4930: end loop;
4985: --
4986: insert_session(l_effective_date);
4987: commit;
4988: --
4989: fnd_file.put_line(fnd_file.output, 'Full Name Assignment Number');
4990: fnd_file.put_line(fnd_file.output, '---------------------------------------- ------------------------------');
4991: fnd_file.put_line(fnd_file.log, 'Full Name Assignment Number');
4992: fnd_file.put_line(fnd_file.log, '---------------------------------------- ------------------------------');
4993: --
4986: insert_session(l_effective_date);
4987: commit;
4988: --
4989: fnd_file.put_line(fnd_file.output, 'Full Name Assignment Number');
4990: fnd_file.put_line(fnd_file.output, '---------------------------------------- ------------------------------');
4991: fnd_file.put_line(fnd_file.log, 'Full Name Assignment Number');
4992: fnd_file.put_line(fnd_file.log, '---------------------------------------- ------------------------------');
4993: --
4994: for l_rec in csr_assact loop
4987: commit;
4988: --
4989: fnd_file.put_line(fnd_file.output, 'Full Name Assignment Number');
4990: fnd_file.put_line(fnd_file.output, '---------------------------------------- ------------------------------');
4991: fnd_file.put_line(fnd_file.log, 'Full Name Assignment Number');
4992: fnd_file.put_line(fnd_file.log, '---------------------------------------- ------------------------------');
4993: --
4994: for l_rec in csr_assact loop
4995: --
4988: --
4989: fnd_file.put_line(fnd_file.output, 'Full Name Assignment Number');
4990: fnd_file.put_line(fnd_file.output, '---------------------------------------- ------------------------------');
4991: fnd_file.put_line(fnd_file.log, 'Full Name Assignment Number');
4992: fnd_file.put_line(fnd_file.log, '---------------------------------------- ------------------------------');
4993: --
4994: for l_rec in csr_assact loop
4995: --
4996: begin
5000: p_object_version_number => l_rec.object_version_number);
5001: --
5002: commit;
5003: --
5004: fnd_file.put_line(fnd_file.output, rpad(l_rec.full_name, 40) || ' ' || rpad(l_rec.assignment_number, 30));
5005: --
5006: exception
5007: when others then
5008: --
5005: --
5006: exception
5007: when others then
5008: --
5009: fnd_file.put_line(fnd_file.log, rpad(l_rec.full_name, 40) || ' ' || rpad(l_rec.assignment_number, 30));
5010: fnd_file.put_line(fnd_file.log, get_sqlerrm);
5011: --
5012: end;
5013: --
5006: exception
5007: when others then
5008: --
5009: fnd_file.put_line(fnd_file.log, rpad(l_rec.full_name, 40) || ' ' || rpad(l_rec.assignment_number, 30));
5010: fnd_file.put_line(fnd_file.log, get_sqlerrm);
5011: --
5012: end;
5013: --
5014: end loop;
5076: --
5077: insert_session(l_effective_date);
5078: commit;
5079: --
5080: fnd_file.put_line(fnd_file.output, 'Full Name Assignment Number');
5081: fnd_file.put_line(fnd_file.output, '---------------------------------------- ------------------------------');
5082: fnd_file.put_line(fnd_file.log, 'Full Name Assignment Number');
5083: fnd_file.put_line(fnd_file.log, '---------------------------------------- ------------------------------');
5084: --
5077: insert_session(l_effective_date);
5078: commit;
5079: --
5080: fnd_file.put_line(fnd_file.output, 'Full Name Assignment Number');
5081: fnd_file.put_line(fnd_file.output, '---------------------------------------- ------------------------------');
5082: fnd_file.put_line(fnd_file.log, 'Full Name Assignment Number');
5083: fnd_file.put_line(fnd_file.log, '---------------------------------------- ------------------------------');
5084: --
5085: for l_rec in csr_assact loop
5078: commit;
5079: --
5080: fnd_file.put_line(fnd_file.output, 'Full Name Assignment Number');
5081: fnd_file.put_line(fnd_file.output, '---------------------------------------- ------------------------------');
5082: fnd_file.put_line(fnd_file.log, 'Full Name Assignment Number');
5083: fnd_file.put_line(fnd_file.log, '---------------------------------------- ------------------------------');
5084: --
5085: for l_rec in csr_assact loop
5086: --
5079: --
5080: fnd_file.put_line(fnd_file.output, 'Full Name Assignment Number');
5081: fnd_file.put_line(fnd_file.output, '---------------------------------------- ------------------------------');
5082: fnd_file.put_line(fnd_file.log, 'Full Name Assignment Number');
5083: fnd_file.put_line(fnd_file.log, '---------------------------------------- ------------------------------');
5084: --
5085: for l_rec in csr_assact loop
5086: --
5087: begin
5094: p_expire_after_transfer => p_expire_after_transfer);
5095: --
5096: commit;
5097: --
5098: fnd_file.put_line(fnd_file.output, rpad(l_rec.full_name, 40) || ' ' || rpad(l_rec.assignment_number, 30));
5099: --
5100: exception
5101: when others then
5102: --
5099: --
5100: exception
5101: when others then
5102: --
5103: fnd_file.put_line(fnd_file.log, rpad(l_rec.full_name, 40) || ' ' || rpad(l_rec.assignment_number, 30));
5104: fnd_file.put_line(fnd_file.log, get_sqlerrm);
5105: --
5106: end;
5107: --
5100: exception
5101: when others then
5102: --
5103: fnd_file.put_line(fnd_file.log, rpad(l_rec.full_name, 40) || ' ' || rpad(l_rec.assignment_number, 30));
5104: fnd_file.put_line(fnd_file.log, get_sqlerrm);
5105: --
5106: end;
5107: --
5108: end loop;
5170: --
5171: insert_session(l_effective_date);
5172: commit;
5173: --
5174: fnd_file.put_line(fnd_file.output, 'Full Name Assignment Number');
5175: fnd_file.put_line(fnd_file.output, '---------------------------------------- ------------------------------');
5176: fnd_file.put_line(fnd_file.log, 'Full Name Assignment Number');
5177: fnd_file.put_line(fnd_file.log, '---------------------------------------- ------------------------------');
5178: --
5171: insert_session(l_effective_date);
5172: commit;
5173: --
5174: fnd_file.put_line(fnd_file.output, 'Full Name Assignment Number');
5175: fnd_file.put_line(fnd_file.output, '---------------------------------------- ------------------------------');
5176: fnd_file.put_line(fnd_file.log, 'Full Name Assignment Number');
5177: fnd_file.put_line(fnd_file.log, '---------------------------------------- ------------------------------');
5178: --
5179: for l_rec in csr_assact loop
5172: commit;
5173: --
5174: fnd_file.put_line(fnd_file.output, 'Full Name Assignment Number');
5175: fnd_file.put_line(fnd_file.output, '---------------------------------------- ------------------------------');
5176: fnd_file.put_line(fnd_file.log, 'Full Name Assignment Number');
5177: fnd_file.put_line(fnd_file.log, '---------------------------------------- ------------------------------');
5178: --
5179: for l_rec in csr_assact loop
5180: --
5173: --
5174: fnd_file.put_line(fnd_file.output, 'Full Name Assignment Number');
5175: fnd_file.put_line(fnd_file.output, '---------------------------------------- ------------------------------');
5176: fnd_file.put_line(fnd_file.log, 'Full Name Assignment Number');
5177: fnd_file.put_line(fnd_file.log, '---------------------------------------- ------------------------------');
5178: --
5179: for l_rec in csr_assact loop
5180: --
5181: begin
5188: p_mode => p_mode);
5189: --
5190: commit;
5191: --
5192: fnd_file.put_line(fnd_file.output, rpad(l_rec.full_name, 40) || ' ' || rpad(l_rec.assignment_number, 30));
5193: --
5194: exception
5195: when others then
5196: --
5193: --
5194: exception
5195: when others then
5196: --
5197: fnd_file.put_line(fnd_file.log, rpad(l_rec.full_name, 40) || ' ' || rpad(l_rec.assignment_number, 30));
5198: fnd_file.put_line(fnd_file.log, get_sqlerrm);
5199: --
5200: end;
5201: --
5194: exception
5195: when others then
5196: --
5197: fnd_file.put_line(fnd_file.log, rpad(l_rec.full_name, 40) || ' ' || rpad(l_rec.assignment_number, 30));
5198: fnd_file.put_line(fnd_file.log, get_sqlerrm);
5199: --
5200: end;
5201: --
5202: end loop;