53: ) IS
54: --
55: CURSOR csr_parameter_info (c_payroll_action_id NUMBER) IS
56: SELECT effective_date
57: ,fnd_date.canonical_to_date(per_hu_abs_rep_archive_pkg.get_parameter(legislative_parameters, 'DATE'))
58: ,per_hu_abs_rep_archive_pkg.get_parameter(legislative_parameters, 'PAYROLL_ID')
59: ,per_hu_abs_rep_archive_pkg.get_parameter(legislative_parameters, 'ASG_SET_ID')
60: ,per_hu_abs_rep_archive_pkg.get_parameter(legislative_parameters, 'EMP_ID')
61: ,business_group_id
123: OPEN csr_get_person_name(lperson_id ,leffective_date );
124: FETCH csr_get_person_name INTO lfull_name;
125: CLOSE csr_get_person_name;
126:
127: lreturn_val := fnd_date.date_to_displaydate(leffective_date)
128: ||' - '||fnd_date.date_to_displaydate(lreporting_date)
129: ||' - '||rpad(nvl(lpayroll_name,' '),40,' ')
130: ||' - '||rpad(nvl(to_char(lassignment_set_id),' '),10,' ')
131: ||' - '||rpad(nvl(lfull_name,' '),40,' ');
124: FETCH csr_get_person_name INTO lfull_name;
125: CLOSE csr_get_person_name;
126:
127: lreturn_val := fnd_date.date_to_displaydate(leffective_date)
128: ||' - '||fnd_date.date_to_displaydate(lreporting_date)
129: ||' - '||rpad(nvl(lpayroll_name,' '),40,' ')
130: ||' - '||rpad(nvl(to_char(lassignment_set_id),' '),10,' ')
131: ||' - '||rpad(nvl(lfull_name,' '),40,' ');
132:
899: , p_action_information5 => csr_rec.full_name
900: , p_action_information6 => csr_rec.organization
901: , p_action_information7 => l_location_code
902: , p_action_information8 => csr_rec.emp_no
903: , p_action_information9 => fnd_date.date_to_displaydate(csr_rec.date_of_birth)
904: , p_action_information10 => l_job_name
905: , p_action_information11 => fnd_date.date_to_displaydate(csr_rec.hire_date)
906: , p_action_information12 => fnd_date.date_to_displaydate(l_sus_asg_end_dt)
907: , p_action_information13 => to_char(g_reporting_date,'YYYY')
901: , p_action_information7 => l_location_code
902: , p_action_information8 => csr_rec.emp_no
903: , p_action_information9 => fnd_date.date_to_displaydate(csr_rec.date_of_birth)
904: , p_action_information10 => l_job_name
905: , p_action_information11 => fnd_date.date_to_displaydate(csr_rec.hire_date)
906: , p_action_information12 => fnd_date.date_to_displaydate(l_sus_asg_end_dt)
907: , p_action_information13 => to_char(g_reporting_date,'YYYY')
908: , p_action_information14 => l_base_accrual_sum
909: , p_action_information15 => l_child_care_accrual_sum
902: , p_action_information8 => csr_rec.emp_no
903: , p_action_information9 => fnd_date.date_to_displaydate(csr_rec.date_of_birth)
904: , p_action_information10 => l_job_name
905: , p_action_information11 => fnd_date.date_to_displaydate(csr_rec.hire_date)
906: , p_action_information12 => fnd_date.date_to_displaydate(l_sus_asg_end_dt)
907: , p_action_information13 => to_char(g_reporting_date,'YYYY')
908: , p_action_information14 => l_base_accrual_sum
909: , p_action_information15 => l_child_care_accrual_sum
910: , p_action_information16 => l_additional_accrual_sum
910: , p_action_information16 => l_additional_accrual_sum
911: , p_action_information17 => l_normal_paid_holiday_prev
912: , p_action_information18 => l_sickness_accrual_sum
913: , p_action_information19 => l_normal_holiday_total
914: , p_action_information20 => fnd_date.date_to_displaydate(g_reporting_date)
915: , p_action_information21 => csr_rec.people_group_id);
916: ELSE
917: fnd_file.put_line(fnd_file.log,substr(csr_rec.full_name,1,30)
918: || ' ['