[Home] [Help]
7: -- the archive process knows what code to execute for each step of
8: -- the archive.
9: --------------------------------------------------------------------
10: procedure range_code
11: ( p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
12: p_sql out nocopy varchar2);
13: --
14: procedure assignment_action_code
15: ( p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
11: ( p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
12: p_sql out nocopy varchar2);
13: --
14: procedure assignment_action_code
15: ( p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
16: p_start_person_id in per_all_people_f.person_id%type,
17: p_end_person_id in per_all_people_f.person_id%type,
18: p_chunk in number );
19: --
17: p_end_person_id in per_all_people_f.person_id%type,
18: p_chunk in number );
19: --
20: procedure initialization_code
21: ( p_payroll_action_id in pay_payroll_actions.payroll_action_id%type);
22: --
23: procedure archive_code
24: ( p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
25: p_effective_date in date);
24: ( p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
25: p_effective_date in date);
26: --
27: procedure deinit_code
28: ( p_payroll_action_id in pay_payroll_actions.payroll_action_id%type ) ;
29: --
30:
31: ------------------------------------------------------------------------
32: -- Bug 7532687 - The function to check if the CPF CSN is valid
160: 'EMPLOYEE_NUMBER=P',
161: pai.action_information18||'#'||pai.action_information18 employee_number,
162: 'EMP_TERMINATION_DATE=P',
163: nvl(to_char(fnd_date.canonical_to_date(pai.action_information19),'dd/mm/yyyy'),'01/01/1900') emp_termination_date
164: from pay_payroll_actions ppa,
165: pay_assignment_actions paa,
166: pay_action_information pai
167: where ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
168: and ppa.payroll_action_id = paa.payroll_action_id
356: pai.action_information19,
357: ppa.payroll_action_id,
358: pai.action_information21
359: ) emp_termination_date
360: from pay_payroll_actions ppa,
361: pay_assignment_actions paa,
362: pay_action_information pai
363: where ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
364: and ppa.payroll_action_id = paa.payroll_action_id
431: 'EMPLOYEE_NUMBER=P',
432: pai.action_information18||'#'||pai.action_information18 employee_number,
433: 'EMP_TERMINATION_DATE=P',
434: nvl(to_char(fnd_date.canonical_to_date(pai.action_information19),'dd/mm/yyyy'),'01/01/1900') emp_termination_date
435: from pay_payroll_actions ppa,
436: pay_assignment_actions paa,
437: pay_action_information pai
438: where ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
439: and ppa.payroll_action_id = paa.payroll_action_id
626: pai.action_information19,
627: ppa.payroll_action_id,
628: pai.action_information21
629: ) emp_termination_date
630: from pay_payroll_actions ppa,
631: pay_assignment_actions paa,
632: pay_action_information pai
633: where ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
634: and ppa.payroll_action_id = paa.payroll_action_id
670: 'CDAC Fund', pai.action_information10,
671: 'ECF Fund', pai.action_information11,
672: 'FWL', pai.action_information16,
673: 'SHARE Program Donations', pai.action_information14)) value
674: from pay_payroll_actions ppa,
675: pay_assignment_actions paa,
676: pay_action_information pai,
677: hr_lookups hl
678: where ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')