1 package pay_sg_awcap_archive as
2 /* $Header: pysgawcp.pkh 120.0.12010000.1 2008/07/27 23:40:26 appldev ship $ */
3 --------------------------------------------------------------------
4 -- These are PUBLIC procedures are required by the Archive process.
5 -- Their names are stored in PAY_REPORT_FORMAT_MAPPINGS_F so that
6 -- the archive process knows what code to execute for each step of
7 -- the archive.
8 -------------------------------------------------------------------
9 procedure range_code
10 ( p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
11 p_sql out nocopy varchar2);
12 --
13 procedure assignment_action_code
14 ( p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
15 p_start_person_id in per_all_people_f.person_id%type,
16 p_end_person_id in per_all_people_f.person_id%type,
17 p_chunk in number );
18 --
19 procedure initialization_code
20 ( p_payroll_action_id in pay_payroll_actions.payroll_action_id%type);
21 --
22 procedure archive_code
23 ( p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
24 p_effective_date in date);
25 --
26 procedure deinit_code
27 ( p_payroll_action_id in pay_payroll_actions.payroll_action_id%type ) ;
28 --
29 ----------------------------------------------------------------------------------
30 --Function calculates current year Ordinary Earnings with monthly ceiling of 5,500
31 ---------------------------------------------------------------------------------
32 function get_cur_year_ord_ytd (p_person_id in per_all_people_f.person_id%type,
33 p_assignment_id in per_all_assignments_f.assignment_id%type,
34 p_date_earned in date) return number ;
35 --
36 end pay_sg_awcap_archive;