[Home] [Help]
77: jmarupil 08-JUN-2011 120.3.12000000.8 12625481 Added cursors csr_leave_taken6, csr_leave_taken7 for archive_absences procedure for displaying
78: PPL in Leave Taken section
79: scireddy 26-JUL-2011 120.3.12000000.9 12775701 Added a join condition on 'action_type' for all the cursors in archive_absences procedure
80: to improve the performance of Pay Slip Archive process.
81: mingyhua 14-SEP-2012 120.3.12000000.10 14486386 Moved 'pay_emp_action_arch.arch_pay_action_level_data' procedure call
82: from range_code to initialization_code.
83: mingyhua 25-NOV-2012 120.3.12000000.11 15912284 Reversed the last change because under certain occasion
84: it causes duplicate record in AU payslip page when using
85: pay_employee_action_info_v
1247:
1248: --
1249: -- Bug#5681819
1250: -- Procedure archives payment details of the payment methods which get skipped in core procedure
1251: -- pay_emp_action_arch.get_net_pay_distribution() , this procedure archives payment methods
1252: -- for which effective start date is between period end date and payment date(+ve offset payroll)
1253: -- or payment method end date is after payment date and before period end date(-ve offset payroll).
1254: --
1255: PROCEDURE archive_offset_payment_method(
1452: --------------------------------------------------------------------------------------
1453: --
1454: -- archive_employee_details
1455: --
1456: -- Calls 'pay_emp_action_arch.get_personal_information' that actually
1457: -- archives the employee details,employee address details, Employer Address Details
1458: -- and Net Pay Distribution inforamation.
1459: -- tax_unit_id must be passed as a parameter to this procedure to make core provided
1460: -- 'Choose Payslip' view return appropriate rows.
1606: hr_utility.set_location('p_pre_assignment_action_id.'||p_pre_assignment_action_id,10);
1607: hr_utility.set_location('p_pre_effective_date.......'||to_char(p_pre_effective_date,'DD-MON-YYYY'),10);
1608: hr_utility.set_location('p_time_period_id...........'||p_time_period_id,10);
1609: hr_utility.set_location('p_period_end_date..........'||p_period_end_date,10); /* Bug No : 2491444 */
1610: hr_utility.set_location('Calling pay_emp_action_arch.get_personal_information',10);
1611:
1612: /* Bug No : 2491444 -- Value passed for p_time_period_id changed */
1613:
1614: pay_emp_action_arch.get_personal_information
1610: hr_utility.set_location('Calling pay_emp_action_arch.get_personal_information',10);
1611:
1612: /* Bug No : 2491444 -- Value passed for p_time_period_id changed */
1613:
1614: pay_emp_action_arch.get_personal_information
1615: ( p_payroll_action_id => g_arc_payroll_action_id -- archive run payroll_action_id
1616: , p_assactid => p_arc_assignment_action_id -- archive run assignment_action_id
1617: , p_assignment_id => p_assignment_id -- current assignment_id
1618: , p_curr_pymt_ass_act_id => p_pre_assignment_action_id -- prepayment run assignment_action_id
1807: --
1808: -- insert_quickpay_pa_info
1809: --
1810: -- This procedure is added for bug #15914996.
1811: -- It calls pay_emp_action_arch.arch_pay_action_level_data to archive
1812: -- employer's address details for QuickPay payslip archive.
1813: --
1814: ----------------------------
1815:
1844:
1845: hr_utility.set_location('p_payroll_id......= '|| l_payroll_id, 15);
1846: hr_utility.set_location('Archiving Employer''s Addr', 20);
1847:
1848: pay_emp_action_arch.arch_pay_action_level_data
1849: (p_payroll_action_id => p_payroll_action_id
1850: ,p_payroll_id => l_payroll_id
1851: ,p_effective_date => p_effective_date);
1852: