1 PACKAGE pay_sg_payslip_archive AS
2 /* $Header: pysgparc.pkh 120.0.12000000.1 2007/01/18 01:34:45 appldev noship $ */
3
4 --------------------------------------------------------------------
5 -- These are PUBLIC procedures are required by the Archive process.
6 -- There names are stored in PAY_REPORT_FORMAT_MAPPINGS_F so that
7 -- the archive process knows what code to execute for each step of
8 -- the archive.
9 --------------------------------------------------------------------
10
11 --------------------------------------------------------------------
12 -- This procedure returns a sql string to select a range
13 -- of assignments eligible for archival.
14 --------------------------------------------------------------------
15
16 procedure range_code
17 (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
18 p_sql out nocopy varchar2);
19
20
21
22 --------------------------------------------------------------------
23 -- This procedure is used to set global contexts
24 -- Here It is used to archive the data at payroll action level.
25 --------------------------------------------------------------------
26
27 procedure initialization_code
28 (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type);
29
30
31 --------------------------------------------------------------------
32 -- This procedure further restricts the assignment_id's
33 -- returned by range_code
34 --------------------------------------------------------------------
35
36 procedure assignment_action_code
37 (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
38 p_start_person in per_all_people_f.person_id%type,
39 p_end_person in per_all_people_f.person_id%type,
40 p_chunk in number);
41
42
43 --------------------------------------------------------------------
44 -- This procedure is actually used to archive data . It
45 -- internally calls private procedures to archive balances ,
46 -- employee details, employer details ,elements,absences and accruals etc.
47 --------------------------------------------------------------------
48
49 procedure archive_code
50 (p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
51 p_effective_date in date);
52
53
54
55 --------------------------------------------------------------------
56
57
58 END pay_sg_payslip_archive;
[Home] [Help]