1 PACKAGE pay_in_eoy_archive AUTHID CURRENT_USER AS
2 /* $Header: pyinpeoy.pkh 120.0.12010000.1 2008/07/27 22:53:55 appldev ship $ */
3 TYPE t_asg_rec IS RECORD
4 (gre_id NUMBER
5 ,start_date DATE
6 ,end_date DATE
7 );
8
9 TYPE t_asg_tab IS TABLE OF t_asg_rec
10 INDEX BY BINARY_INTEGER;
11
12 TYPE t_gre_rec IS RECORD
13 (gre_id NUMBER
14 );
15
16 TYPE t_gre_tab IS TABLE OF t_asg_rec
17 INDEX BY BINARY_INTEGER;
18
19 TYPE t_bal_name_rec IS RECORD
20 (
21 balance_name VARCHAR2(240)
22 );
23
24 TYPE t_bal_name_tab IS TABLE OF t_bal_name_rec
25 INDEX BY BINARY_INTEGER;
26 -------------------------------------------------------------------------
27 -- These are PUBLIC procedures that are required by the Archive process.
28 -- There names are stored in PAY_REPORT_FORMAT_MAPPINGS_F so that
29 -- the archive process knows what code to execute for each step of
30 -- the archive.
31 --------------------------------------------------------------------------
32
33 --------------------------------------------------------------------------
34 -- --
35 -- Name : RANGE_CODE --
36 -- Type : PROCEDURE --
37 -- Access : Public --
38 -- Description : This procedure returns a sql string to select a --
39 -- range of assignments eligible for archival. --
40 -- --
41 -- Parameters : --
42 -- IN : p_payroll_action_id NUMBER --
43 -- OUT : p_sql VARCHAR2 --
44 -- --
45 --------------------------------------------------------------------------
46 --
47
48 PROCEDURE range_code
49 (
50 p_payroll_action_id IN NUMBER
51 ,p_sql OUT NOCOPY VARCHAR2
52 );
53 --
54
55 --------------------------------------------------------------------------
56 -- --
57 -- Name : INITIALIZATION_CODE --
58 -- Type : PROCEDURE --
59 -- Access : Public --
60 -- Description : This procedure is used to set global contexts --
61 -- Here It is used to archive the data at payroll --
62 -- action level. --
63 -- --
64 -- Parameters : --
65 -- IN : p_payroll_action_id NUMBER --
66 -- OUT : N/A --
67 --------------------------------------------------------------------------
68 --
69 PROCEDURE initialization_code
70 (
71 p_payroll_action_id IN NUMBER
72 );
73 --
74
75 --------------------------------------------------------------------------
76 -- --
77 -- Name : ASSIGNMENT_ACTION_CODE --
78 -- Type : PROCEDURE --
79 -- Access : Public --
80 -- Description : This procedure further restricts the assignment_id's--
81 -- returned by range_code --
82 -- --
83 -- Parameters : --
84 -- IN : p_payroll_action_id NUMBER --
85 -- p_start_person NUMBER --
86 -- p_end_person NUMBER --
87 -- p_chunk NUMBER --
88 -- OUT : N/A --
89 --------------------------------------------------------------------------
90 --
91
92 PROCEDURE assignment_action_code
93 (
94 p_payroll_action_id IN NUMBER
95 ,p_start_person IN NUMBER
96 ,p_end_person IN NUMBER
97 ,p_chunk IN NUMBER
98 );
99 --
100
101 --------------------------------------------------------------------------
102 -- --
103 -- Name : ARCHIVE_CODE --
104 -- Type : PROCEDURE --
105 -- Access : Public --
106 -- Description : This procedure is actually used to archive data . It--
107 -- internally calls private procedures to archive --
108 -- balances,employee details, employer details, --
109 -- elements,absences and accruals etc. --
110 -- --
111 -- Parameters : --
112 -- IN : p_assignment_action_id NUMBER --
113 -- p_effective_date DATE --
114 -- OUT : N/A --
115 --------------------------------------------------------------------------
116 --
117
118 PROCEDURE archive_code
119 (
120 p_assignment_action_id IN NUMBER
121 ,p_effective_date IN DATE
122 );
123
124 END pay_in_eoy_archive;