[Home] [Help]
413: CLOSE csr_person_info;
414:
415: hr_utility.trace('l_first_name='||l_first_name);
416: hr_utility.trace('l_middle_name='||l_middle_name);
417: hr_utility.trace('l_date_of_birth='||fnd_date.date_to_displaydate(l_date_of_birth));
418: hr_utility.trace('l_title='||l_title);
419: hr_utility.trace('l_expense_check_to_address='||l_expense_check_to_address);
420: hr_utility.trace('l_ni_number='||l_ni_number);
421: hr_utility.trace('l_sex='||l_sex);
904: FETCH get_week_53_start INTO l_week_53_start;
905: CLOSE get_week_53_start;
906:
907: hr_utility.trace('After get_week_53_start, l_week_53_start='||
908: fnd_date.date_to_displaydate(l_week_53_start));
909: IF nvl(l_week_53_start, hr_general.end_of_time) <= l_active_end THEN
910: l_week_53_indicator := substr(to_char(l_prl_max_period_number),2,1);
911: END IF;
912: else
3228: -- SUBSTR(pay_gb_eoy_archive.get_parameter(legislative_parameters,'FIRST_FPS'),1,1) first_fps,
3229: effective_date,
3230: business_group_id,
3231: SUBSTR(pay_gb_eoy_archive.get_parameter(legislative_parameters,'ASG_SET'),1,20) asg_set_id
3232: -- fnd_date.canonical_to_date(SUBSTR(pay_gb_eoy_archive.get_parameter(legislative_parameters,'FIRST_FPS_DATE'),1,10)) first_fps_date
3233: FROM pay_payroll_actions pact
3234: WHERE payroll_action_id = pactid;
3235:
3236: CURSOR csr_asg(c_asg_id NUMBER, c_effective_date DATE)
3914:
3915: -- Cursor to fetch the RTI NI Reporting assignment for this person.
3916: cursor csr_get_ni_rpt_asg(c_asg_id number) is
3917: select
3918: distinct paei.assignment_id , fnd_date.canonical_to_date(paei.AEI_INFORMATION2)
3919: from per_all_assignments_f paaf1, per_all_assignments_f paaf2 ,per_assignment_extra_info paei
3920: where paaf1.assignment_id = c_asg_id
3921: and paaf1.person_id = paaf2.person_id
3922: and paaf2.assignment_status_type_id in(select ASSIGNMENT_STATUS_TYPE_ID from per_assignment_status_types past where past.LEGISLATION_CODE is null and past.BUSINESS_GROUP_ID is null
4795: OPEN get_person_details(action_id.assignment_id);
4796: FETCH get_person_details INTO et_asg_rec;
4797: CLOSE get_person_details;
4798: l_et_temp := et_asg_rec.l_name || ', '|| et_asg_rec.title || ' ' || et_asg_rec.f_name || ' ' || et_asg_rec.m_name;
4799: IF et_asg_rec.end_date = fnd_date.canonical_to_date('4712/12/31 00:00:00') THEN
4800: fnd_file.put_line(fnd_file.output,rpad(et_asg_rec.emp_no, 18) || ' ' || rpad(et_asg_rec.ni_no ,10) || ' '
4801: || rpad(l_et_temp,50) );
4802: ELSE
4803: fnd_file.put_line(fnd_file.output,rpad(et_asg_rec.emp_no, 18) || ' ' || rpad(et_asg_rec.ni_no ,10) || ' '
4825:
4826: l_error_flag := 'Y';
4827:
4828: l_temp := asg_rec.l_name || ', '|| asg_rec.title || ' ' || asg_rec.f_name || ' ' || asg_rec.m_name;
4829: IF asg_rec.end_date = fnd_date.canonical_to_date('4712/12/31 00:00:00') THEN
4830: fnd_file.put_line(fnd_file.output,rpad(asg_rec.emp_no, 18) || ' ' || rpad(asg_rec.ni_no ,10) || ' ' || rpad(l_temp,50)
4831: || ' ' || rpad(err_msg,120) ); -- error message
4832: ELSE
4833: fnd_file.put_line(fnd_file.output,rpad(asg_rec.emp_no, 18) || ' ' || rpad(asg_rec.ni_no ,10) || ' ' || rpad(l_temp,50)
4865: IF csr_warn_msg%NOTFOUND THEN
4866: NULL;
4867: ELSE
4868: l_temp := asg_rec.l_name || ', '|| asg_rec.title || ' ' || asg_rec.f_name || ' ' || asg_rec.m_name;
4869: IF asg_rec.end_date = fnd_date.canonical_to_date('4712/12/31 00:00:00') THEN
4870: fnd_file.put_line(fnd_file.output,rpad(asg_rec.emp_no, 18) || ' ' || rpad(asg_rec.ni_no ,10) || ' ' || rpad(l_temp,50)
4871: || ' ' || rpad(err_msg,100) );
4872: ELSE
4873: fnd_file.put_line(fnd_file.output,rpad(asg_rec.emp_no, 18) || ' ' || rpad(asg_rec.ni_no ,10) || ' ' || rpad(l_temp,50)