[Home] [Help]
PACKAGE: APPS.PAY_NO_EOY_ARCHIVE
Source
1 PACKAGE pay_no_eoy_archive AUTHID CURRENT_USER AS
2 /* $Header: pynoeoya.pkh 120.4.12020000.2 2012/09/07 13:46:30 rajganga ship $ */
3 --
4 --
5 -- -----------------------------------------------------------------------------
6 -- Data types.
7 -- -----------------------------------------------------------------------------
8 --
9 TYPE t_rep_code_rec IS RECORD
10 (reporting_code VARCHAR2(10)
11 ,amount VARCHAR2(10)
12 ,info1 VARCHAR2(30)
13 ,info2 VARCHAR2(30)
14 ,info3 VARCHAR2(30)
15 ,info4 VARCHAR2(30)
16 ,info5 VARCHAR2(30)
17 ,info6 VARCHAR2(30)
18 ,info7 VARCHAR2(100)
19 ,info8 VARCHAR2(100)
20 ,info9 VARCHAR2(100)
21 ,info10 VARCHAR2(100)
22 ,info11 VARCHAR2(100)
23 ,info12 VARCHAR2(100)
24 ,info13 VARCHAR2(30) --2009 changes
25 ,info14 VARCHAR2(30) --2009 changes
26 ,info15 VARCHAR2(30) --2009 changes
27 ,info16 VARCHAR2(30) --2009 changes
28 ,info17 VARCHAR2(100) --2009 changes
29 ,info18 VARCHAR2(100) --2009 changes
30 ,info19 VARCHAR2(100) --2009 changes
31 ,info20 VARCHAR2(100) --2009 changes
32 );
33 --
34 TYPE t_rep_code_table IS TABLE OF t_rep_code_rec INDEX BY BINARY_INTEGER;
35 --
36 --
37 -- -----------------------------------------------------------------------------
38 -- Localisation delivered support for extracting specific reporting codes.
39 --
40 -- Needs to populate the archive as follows:-
41 --
42 -- pay_action_information_api.create_action_information
43 -- (p_action_context_type => 'AAP'
44 -- ,p_action_context_id => p_assignment_action_id
45 -- ,p_action_information_id => l_act_inf_id
46 -- ,p_object_version_number => l_ovn
47 -- ,p_effective_date => p_report_date
48 -- ,p_action_information_category => 'EMEA REPORT INFORMATION'
49 -- ,p_action_information1 => 'ASG_REP_CODE_INFO'
50 -- ,p_action_information2 => p_reporting_code
51 -- ,p_action_information3 => <amount>
52 -- ,p_action_information4 => <info1>
53 -- ,p_action_information5 => <info2>
54 -- ,p_action_information6 => <info3>
55 -- ,p_action_information7 => <info4>
56 -- ,p_action_information8 => <info5>
57 -- ,p_action_information9 => <info6>
58 -- ,p_action_information10 => <Seaman Component status>
59 -- ,p_action_information11 => <info7> --2009 changes
60 -- ,p_action_information12 => <info8> --2009 changes
61 -- ,p_action_information13 => <info9> --2009 changes
62 -- ,p_action_information14 => <info10> --2009 changes
63 --);
64 -- -----------------------------------------------------------------------------
65 --
66 PROCEDURE extract_reporting_code
67 (p_assignment_action_id IN NUMBER
68 ,p_reporting_code IN VARCHAR2
69 ,p_report_date IN DATE);
70 --
71 --
72 -- -----------------------------------------------------------------------------
73 -- Localisation delivered support for collating specific reporting codes.
74 --
75 -- Cursor to retrieve reporting code informastion to be collated:-
76 --
77 -- CURSOR csr_REPORTING_CODES
78 -- (p_payroll_action_id IN NUMBER
79 -- ,p_legal_employer_id IN VARCHAR2
80 -- ,p_reporting_code IN VARCHAR2) IS
81 -- SELECT asg_act.action_information5 person_id
82 -- ,asg_act.action_information6 tax_municipality
83 -- ,TO_NUMBER(rep_cde.action_information3) amount
84 -- FROM pay_assignment_actions paa
85 -- ,pay_action_information asg_act
86 -- ,pay_action_information rep_cde
87 -- WHERE paa.payroll_action_id = p_payroll_action_id
88 -- AND asg_act.action_context_type = 'AAP'
89 -- AND asg_act.action_context_id = paa.assignment_action_id
90 -- AND asg_act.action_information_category = 'EMEA REPORT INFORMATION'
91 -- AND asg_act.action_information1 = 'ASG_ACT_INFO'
92 -- AND asg_act.action_information2 = p_legal_employer_id
93 -- AND rep_cde.action_context_type = 'AAP'
94 -- AND rep_cde.action_context_id = asg_act.action_context_id
95 -- AND rep_cde.action_information_category = 'EMEA REPORT INFORMATION'
96 -- AND rep_cde.action_information1 = 'ASG_REP_CODE_INFO'
97 -- AND rep_cde.action_information2 = p_reporting_code;
98 --
99 -- Needs to populate the archive as follows:-
100 --
101 -- pay_action_information_api.create_action_information
102 -- (p_action_context_type => 'PA'
103 -- ,p_action_context_id => p_payroll_action_id
104 -- ,p_action_information_id => l_act_inf_id
105 -- ,p_object_version_number => l_ovn
106 -- ,p_effective_date => p_report_date
107 -- ,p_action_information_category => 'EMEA REPORT INFORMATION'
108 -- ,p_action_information1 => 'AUDIT_REP_SUMMARY'
109 -- ,p_action_information2 => p_legal_employer_id
110 -- ,p_action_information3 => <person ID>
111 -- ,p_action_information4 => p_reporting_code
112 -- ,p_action_information5 => <amount>
113 -- ,p_action_information6 => <info1>
114 -- ,p_action_information7 => <info2>
115 -- ,p_action_information8 => <info3>
116 -- ,p_action_information9 => <info4>
117 -- ,p_action_information10 => <info5>
118 -- ,p_action_information11 => <info6>
119 -- ,p_action_information12 => <tax_municipality>
120 -- ,p_action_information13 => <Seaman Component status>
121 -- ,p_action_information14 => <info7> --2009 changes
122 -- ,p_action_information15 => <info8> --2009 changes
123 -- ,p_action_information16 => <info9> --2009 changes
124 -- ,p_action_information17 => <info10> --2009 changes
125 --);
126 -- -----------------------------------------------------------------------------
127 --
128 PROCEDURE collate_reporting_code
129 (p_payroll_action_id IN NUMBER
130 ,p_legal_employer_id IN VARCHAR2
131 ,p_reporting_code IN VARCHAR2);
132 --
133 --
134 -- -----------------------------------------------------------------------------
135 -- Parse out parameters from string.
136 -- -----------------------------------------------------------------------------
137 --
138 FUNCTION get_parameter
139 (p_parameter_string IN VARCHAR2
140 ,p_token IN VARCHAR) RETURN VARCHAR2;
141 --
142 --
143 -- -----------------------------------------------------------------------------
144 -- Returns the prompt for a given information item.
145 -- -----------------------------------------------------------------------------
146 --
147 FUNCTION get_info_prompt
148 (p_payroll_action_id IN NUMBER
149 ,p_legal_employer_id IN VARCHAR2
150 ,p_reporting_code IN VARCHAR2
151 ,p_info_id IN VARCHAR2) RETURN VARCHAR2;
152 --
153 --
154 -- -----------------------------------------------------------------------------
155 -- Returns the Data Type for a given information item.
156 -- -----------------------------------------------------------------------------
157 --
158 FUNCTION get_info_dtype
159 (p_payroll_action_id IN NUMBER
160 ,p_legal_employer_id IN VARCHAR2
161 ,p_reporting_code IN VARCHAR
162 ,p_info_id IN VARCHAR2) RETURN VARCHAR2;
163 --
164 --
165 -- -----------------------------------------------------------------------------
166 -- Returns the description for a given reporting code.
167 -- -----------------------------------------------------------------------------
168 --
169 FUNCTION get_code_desc
170 (p_payroll_action_id IN NUMBER
171 ,p_legal_employer_id IN VARCHAR2
172 ,p_reporting_code IN VARCHAR) RETURN VARCHAR2;
173 --
174 --
175 -- -----------------------------------------------------------------------------
176 -- Returns the ORID for a given reporting code.
177 -- -----------------------------------------------------------------------------
178 FUNCTION get_xml_orid
179 (p_payroll_action_id IN NUMBER
180 ,p_legal_employer_id IN VARCHAR2
181 ,p_reporting_code IN VARCHAR
182 ,p_info_id IN VARCHAR2) RETURN VARCHAR2;
183 --
184 --
185 -- -----------------------------------------------------------------------------
186 -- Part of archive logic.
187 -- -----------------------------------------------------------------------------
188 --
189 PROCEDURE range_code
190 (p_payroll_action_id IN NUMBER
191 ,p_sql OUT NOCOPY VARCHAR2);
192 --
193 --
194 -- -----------------------------------------------------------------------------
195 -- Part of archive logic.
196 -- -----------------------------------------------------------------------------
197 --
198 PROCEDURE assignment_action_code
199 (p_payroll_action_id IN NUMBER
200 ,p_start_person IN NUMBER
201 ,p_end_person IN NUMBER
202 ,p_chunk IN NUMBER);
203 --
204 --
205 -- -----------------------------------------------------------------------------
206 -- Part of archive logic.
207 -- -----------------------------------------------------------------------------
208 --
209 PROCEDURE initialization_code
210 (p_payroll_action_id IN NUMBER);
211 --
212 --
213 -- -----------------------------------------------------------------------------
214 -- Part of archive logic.
215 -- -----------------------------------------------------------------------------
216 --
217 PROCEDURE archive_code
218 (p_assignment_action_id IN NUMBER
219 ,p_effective_date IN DATE);
220 --
221 --
222 -- -----------------------------------------------------------------------------
223 -- Part of archive logic.
224 -- -----------------------------------------------------------------------------
225 --
226 PROCEDURE deinitialization_code
227 (p_payroll_action_id IN NUMBER);
228 --
229 --
230 -- -----------------------------------------------------------------------------
231 -- Generates XML for the Norwegian End of Year Audit report.
232 -- -----------------------------------------------------------------------------
233 --
234 PROCEDURE get_audit_data
235 (p_payroll_action_id IN VARCHAR2
236 ,p_template_name IN VARCHAR2
237 ,p_xml OUT NOCOPY CLOB);
238 --
239 --
240 -- -----------------------------------------------------------------------------
241 -- Generates PDF Report for the Norwegian End of Year Employer Contribution Summary
242 -- report.
243 -- -----------------------------------------------------------------------------
244 --
245 PROCEDURE get_employer_contribution_data
246 (p_payroll_action_id IN VARCHAR2
247 ,p_template_name IN VARCHAR2
248 ,p_xml OUT NOCOPY CLOB);
249 --
250 --
251 -- -----------------------------------------------------------------------------
252 -- Generates XML for the Norwegian End of Year Employer Contribution Summary
253 -- report.
254 -- -----------------------------------------------------------------------------
255 --
256 PROCEDURE get_employer_contribution_xml
257 (p_business_group_id IN NUMBER
258 ,p_payroll_action_id IN VARCHAR2
259 ,p_template_name IN VARCHAR2
260 ,p_xml OUT NOCOPY CLOB);
261 --
262 --
263 -- -----------------------------------------------------------------------------
264 -- Generates Report for the Norwegian End of Year Report called Certificate of Pay
265 -- and Tax Deducted for each employee.
266 -- -----------------------------------------------------------------------------
267 --
268 PROCEDURE get_employee_cerificate_data
269 (p_payroll_action_id IN VARCHAR2
270 ,p_template_name IN VARCHAR2
271 ,p_xml OUT NOCOPY CLOB);
272 --
273 --
274 -- -----------------------------------------------------------------------------
275 -- Generates XML for the Norwegian End of Year Report called Certificate of Pay
276 -- and Tax Deducted for each employee.
277 -- -----------------------------------------------------------------------------
278 --
279 PROCEDURE get_employee_certificate_xml
280 (p_business_group_id IN NUMBER
281 ,p_payroll_action_id IN VARCHAR2
282 ,p_template_name IN VARCHAR2
283 ,employee_number in number
284 ,p_xml OUT NOCOPY CLOB);
285 --
286 --
287 -- -----------------------------------------------------------------------------
288 -- Returns Y if Person is employed throughout the year in same Tax Unit
289 -- -----------------------------------------------------------------------------
290 --
291 --
292 FUNCTION employed_throughout_year ( p_person_id IN NUMBER
293 ,p_legal_empoyer_id IN NUMBER
294 ,p_effective_date IN DATE )
295 RETURN VARCHAR2 ;
296 --
297 END pay_no_eoy_archive;