1 PACKAGE pay_in_payslip_archive AUTHID CURRENT_USER AS
2 /* $Header: pyinparc.pkh 120.2.12020000.1 2012/06/28 18:14:40 appldev ship $ */
3
4 -------------------------------------------------------------------------
5 -- These are PUBLIC procedures that 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 -- --
13 -- Name : RANGE_CODE --
14 -- Type : PROCEDURE --
15 -- Access : Public --
16 -- Description : This procedure returns a sql string to select a --
17 -- range of assignments eligible for archival. --
18 -- --
19 -- Parameters : --
20 -- IN : p_payroll_action_id NUMBER --
21 -- OUT : p_sql VARCHAR2 --
22 -- --
23 --------------------------------------------------------------------------
24 --
25
26 PROCEDURE range_code
27 (
28 p_payroll_action_id IN NUMBER
29 ,p_sql OUT NOCOPY VARCHAR2
30 );
31 --
32
33 --------------------------------------------------------------------------
34 -- --
35 -- Name : INITIALIZATION_CODE --
36 -- Type : PROCEDURE --
37 -- Access : Public --
38 -- Description : This procedure is used to set global contexts --
39 -- Here It is used to archive the data at payroll --
40 -- action level. --
41 -- --
42 -- Parameters : --
43 -- IN : p_payroll_action_id NUMBER --
44 -- OUT : N/A --
45 --------------------------------------------------------------------------
46 --
47 PROCEDURE initialization_code
48 (
49 p_payroll_action_id IN NUMBER
50 );
51 --
52
53 --------------------------------------------------------------------------
54 -- --
55 -- Name : ASSIGNMENT_ACTION_CODE --
56 -- Type : PROCEDURE --
57 -- Access : Public --
58 -- Description : This procedure further restricts the assignment_id's--
59 -- returned by range_code --
60 -- --
61 -- Parameters : --
62 -- IN : p_payroll_action_id NUMBER --
63 -- p_start_person NUMBER --
64 -- p_end_person NUMBER --
65 -- p_chunk NUMBER --
66 -- OUT : N/A --
67 --------------------------------------------------------------------------
68 --
69
70 PROCEDURE assignment_action_code
71 (
72 p_payroll_action_id IN NUMBER
73 ,p_start_person IN NUMBER
74 ,p_end_person IN NUMBER
75 ,p_chunk IN NUMBER
76 );
77 --
78
79 --------------------------------------------------------------------------
80 -- --
81 -- Name : ARCHIVE_CODE --
82 -- Type : PROCEDURE --
83 -- Access : Public --
84 -- Description : This procedure is actually used to archive data . It--
85 -- internally calls private procedures to archive --
86 -- balances,employee details, employer details, --
87 -- elements,absences and accruals etc. --
88 -- --
89 -- Parameters : --
90 -- IN : p_assignment_action_id NUMBER --
91 -- p_effective_date DATE --
92 -- OUT : N/A --
93 --------------------------------------------------------------------------
94 --
95
96 PROCEDURE archive_code
97 (
98 p_assignment_action_id IN NUMBER
99 ,p_effective_date IN DATE
100 );
101 --
102
103
104
105 --------------------------------------------------------------------------
106 -- --
107 -- Name : ARCHIVE_FORM_DATA --
108 -- Type : PROCEDURE --
109 -- Access : Public --
110 -- Description : This procedure archives the data required for form --
111 -- 3A and form 6A --
112 -- Parameters : --
113 -- IN : p_assignment_action_id NUMBER --
114 -- p_payroll_action_id NUMBER --
115 -- p_run_payroll_action_id NUMBER --
116 -- p_archive_action_id NUMBER --
117 -- p_assignment_id NUMBER --
118 -- p_payroll_date DATE --
119 -- p_prepayment_date DATE --
120 -- --
121 -- --
122 -- OUT : N/A --
123 -- --
124 -- Change History : --
125 --------------------------------------------------------------------------
126 -- Rev# Date Userid Description --
127 --------------------------------------------------------------------------
128 -- 115.0 01-Jan-2005 aaagawra Initial Version --
129 -- 115.1 01-Mar-2005 aaagawra Changes done for incorporating PA data-
130 -- 115.2 31-Mar-2005 lnagaraj New parameter p_run_payroll_action_id
131 --------------------------------------------------------------------------
132 PROCEDURE archive_form_data
133 (
134 p_assignment_action_id IN NUMBER
135 ,p_payroll_action_id IN NUMBER
136 ,p_run_payroll_action_id IN NUMBER
137 ,p_archive_action_id IN NUMBER
138 ,p_assignment_id IN NUMBER
139 ,p_payroll_date IN DATE
140 ,p_prepayment_date IN DATE
141 );
142
143 --------------------------------------------------------------------------
144 -- --
145 -- Name : ARCHIVE_ESI_DATA --
146 -- Type : PROCEDURE --
147 -- Access : Public --
148 -- Description : This procedure archives the data required for form 6--
149 -- Parameters : --
150 -- IN : p_assignment_action_id NUMBER --
151 -- p_payroll_action_id NUMBER --
152 -- p_archive_action_id NUMBER --
153 -- p_assignment_id NUMBER --
154 -- p_payroll_date DATE --
155 -- p_prepayment_date DATE --
156 -- --
157 -- --
158 -- OUT : N/A --
159 -- --
160 -- Change History : --
161 --------------------------------------------------------------------------
162 -- Rev# Date Userid Description --
163 --------------------------------------------------------------------------
164 -- 115.0 07-Mar-2005 aaagarwa Initial Version --
165 --------------------------------------------------------------------------
166 --
167 PROCEDURE archive_esi_data
168 (
169 p_assignment_action_id IN NUMBER
170 ,p_payroll_action_id IN NUMBER
171 ,p_archive_action_id IN NUMBER
172 ,p_assignment_id IN NUMBER
173 ,p_payroll_date IN DATE
174 ,p_prepayment_date IN DATE
175 );
176
177 --
178 --------------------------------------------------------------------------
179 -- --
180 -- Name : GET_PARAMETER --
181 -- Type : FUNCTION --
182 -- Access : Public --
183 -- Description : This function returns payroll id of corresponding --
184 -- payroll action id. --
185 -- Parameters : --
186 -- IN : p_name VARCHAR2 --
187 -- p_leg_parameters VARCHAR2 --
188 -- Returns: VARCHAR2 --
189 --------------------------------------------------------------------------
190 --
191
192 FUNCTION get_parameter
193 (
194 p_name IN VARCHAR2,
195 p_leg_parameters IN VARCHAR2
196 ) RETURN VARCHAR2;
197
198 END pay_in_payslip_archive;