[Home] [Help]
PACKAGE: APPS.PAY_CN_EXT
Source
1 PACKAGE pay_cn_ext AS
2 /* $Header: pycnext.pkh 120.0.12010000.1 2008/07/27 22:21:00 appldev ship $ */
3
4 g_package VARCHAR2(100);
5
6
7 ----------------------------------------------------------------------------
8 -- --
9 -- Name : CB_EXTRACT_PROCESS --
10 -- Type : PROCEDURE --
11 -- Access : Public --
12 -- Description : Procedure for CB Extract --
13 -- --
14 -- Parameters : --
15 -- IN : p_phf_si_type VARCHAR2 --
16 -- p_legal_employer_id NUMBER DEFAULT NULL --
17 -- p_contribution_area VARCHAR2 --
18 -- p_contribution_year VARCHAR2 --
19 -- p_business_group_id NUMBER --
20 -- OUT : errbuf VARCHAR2 --
21 -- retcode VARCHAR2 --
22 -- Change History : --
23 ----------------------------------------------------------------------------
24 -- Rev# Date Userid Description --
25 ----------------------------------------------------------------------------
26 -- 1.0 10-Jan-2004 bramajey Created this procedure --
27 ----------------------------------------------------------------------------
28 PROCEDURE cb_extract_process( errbuf OUT NOCOPY VARCHAR2
29 , retcode OUT NOCOPY VARCHAR2
30 , p_phf_si_type IN VARCHAR2
31 , p_legal_employer_id IN NUMBER
32 , p_contribution_area IN VARCHAR2
33 , p_contribution_year IN VARCHAR2
34 , p_business_group_id IN NUMBER
35 ) ;
36
37 ----------------------------------------------------------------------------
38 -- --
39 -- Name : CA_EXTRACT_PROCESS --
40 -- Type : PROCEDURE --
41 -- Access : Public --
42 -- Description : Procedure for CA Extract --
43 -- --
44 -- Parameters : --
45 -- IN : p_phf_si_type VARCHAR2 --
46 -- p_legal_employer_id NUMBER --
47 -- p_contribution_area VARCHAR2 --
48 -- p_contribution_year VARCHAR2 --
49 -- p_business_group_id NUMBER --
50 -- OUT : errbuf VARCHAR2 --
51 -- retcode VARCHAR2 --
52 -- Change History : --
53 ----------------------------------------------------------------------------
54 -- Rev# Date Userid Description --
55 ----------------------------------------------------------------------------
56 -- 1.0 10-Jan-2004 bramajey Created this procedure --
57 ----------------------------------------------------------------------------
58 PROCEDURE ca_extract_process( errbuf OUT NOCOPY VARCHAR2
59 , retcode OUT NOCOPY VARCHAR2
60 , p_phf_si_type IN VARCHAR2
61 , p_legal_employer_id IN NUMBER
62 , p_contribution_area IN VARCHAR2
63 , p_contribution_year IN VARCHAR2
64 , p_contribution_month IN VARCHAR2
65 , p_business_group_id IN NUMBER
66 ) ;
67
68 ----------------------------------------------------------------------------
69 -- --
70 -- Name : EM_EXTRACT_PROCESS --
71 -- Type : PROCEDURE --
72 -- Access : Public --
73 -- Description : Procedure for EM Extract --
74 -- --
75 -- Parameters : --
76 -- IN : p_phf_si_type VARCHAR2 --
77 -- p_legal_employer_id NUMBER --
78 -- p_contribution_area VARCHAR2 --
79 -- p_contribution_year VARCHAR2 --
80 -- p_contribution_month VARCHAR2 --
81 -- p_business_group_id NUMBER --
82 -- p_filling_date VARCHAR2 --
83 -- OUT : errbuf VARCHAR2 --
84 -- retcode VARCHAR2 --
85 -- Change History : --
86 ----------------------------------------------------------------------------
87 -- Rev# Date Userid Description --
88 ----------------------------------------------------------------------------
89 -- 1.0 10-Jan-2004 bramajey Created this procedure --
90 ----------------------------------------------------------------------------
91 PROCEDURE em_extract_process( errbuf OUT NOCOPY VARCHAR2
92 , retcode OUT NOCOPY VARCHAR2
93 , p_phf_si_type IN VARCHAR2
94 , p_legal_employer_id IN NUMBER
95 , p_contribution_area IN VARCHAR2
96 , p_contribution_year IN VARCHAR2
97 , p_contribution_month IN VARCHAR2
98 , p_business_group_id IN NUMBER
99 , p_filling_date IN VARCHAR2
100 ) ;
101
102
103 ----------------------------------------------------------------------------
104 -- --
105 -- Name : CB_CRITERIA_PROFILE --
106 -- Type : FUNCTION --
107 -- Access : Public --
108 -- Description : Function to select the assignments to be extracted --
109 -- for CB Report --
110 -- Parameters : --
111 -- IN : p_assignment_id NUMBER --
112 -- p_business_group_id NUMBER --
113 -- p_date_earned DATE --
114 -- OUT : p_warning_message VARCHAR2 --
115 -- p_error_message VARCHAR2 --
116 -- Change History : --
117 ----------------------------------------------------------------------------
118 -- Rev# Date Userid Description --
119 ----------------------------------------------------------------------------
120 -- 1.0 10-Jan-2004 bramajey Created this function --
121 ----------------------------------------------------------------------------
122 FUNCTION cb_criteria_profile ( p_assignment_id IN VARCHAR2
123 , p_business_group_id IN NUMBER
124 , p_date_earned IN DATE
125 , p_warning_message OUT NOCOPY VARCHAR2
126 , p_error_message OUT NOCOPY VARCHAR2
127 )
128 RETURN VARCHAR2;
129
130 ----------------------------------------------------------------------------
131 -- --
132 -- Name : CA_CRITERIA_PROFILE --
133 -- Type : FUNCTION --
134 -- Access : Public --
135 -- Description : Function to select the assignments to be extracted --
136 -- for CA Report --
137 -- Parameters : --
138 -- IN : p_assignment_id NUMBER --
139 -- p_business_group_id NUMBER --
140 -- p_date_earned DATE --
141 -- OUT: p_warning_message VARCHAR2 --
142 -- p_error_message VARCHAR2 --
143 -- Change History : --
144 ----------------------------------------------------------------------------
145 -- Rev# Date Userid Description --
146 ----------------------------------------------------------------------------
147 -- 1.0 10-Jan-2004 bramajey Created this function --
148 ----------------------------------------------------------------------------
149 FUNCTION ca_criteria_profile ( p_assignment_id IN VARCHAR2
150 , p_business_group_id IN NUMBER
151 , p_date_earned IN DATE
152 , p_warning_message OUT NOCOPY VARCHAR2
153 , p_error_message OUT NOCOPY VARCHAR2
154 )
155 RETURN VARCHAR2;
156
157
158 ----------------------------------------------------------------------------
159 -- --
160 -- Name : EM_CRITERIA_PROFILE --
161 -- Type : FUNCTION --
162 -- Access : Public --
163 -- Description : Function to select the assignments to be extracted --
164 -- for EM Report --
165 -- Parameters : --
166 -- IN : p_assignment_id NUMBER --
167 -- p_business_group_id NUMBER --
168 -- p_date_earned DATE --
169 -- OUT: p_warning_message VARCHAR2 --
170 -- p_error_message VARCHAR2 --
171 -- Change History : --
172 ----------------------------------------------------------------------------
173 -- Rev# Date Userid Description --
174 ----------------------------------------------------------------------------
175 -- 1.0 10-Jan-2004 bramajey Created this function --
176 ----------------------------------------------------------------------------
177 FUNCTION em_criteria_profile ( p_assignment_id IN VARCHAR2
178 , p_business_group_id IN NUMBER
179 , p_date_earned IN DATE
180 , p_warning_message OUT NOCOPY VARCHAR2
181 , p_error_message OUT NOCOPY VARCHAR2
182 )
183 RETURN VARCHAR2;
184
185
186 ----------------------------------------------------------------------------
187 -- --
188 -- Name : GET_EMPLOYER_INFO --
189 -- Type : FUNCTION --
190 -- Access : Public --
191 -- Description : Function to get employer information based on the --
192 -- info type --
193 -- --
194 -- Parameters : --
195 -- IN : p_info_type VARCHAR2 --
196 -- p_assignment_id NUMBER --
197 -- Change History : --
198 ----------------------------------------------------------------------------
199 -- Rev# Date Userid Description --
200 ----------------------------------------------------------------------------
201 -- 1.0 10-Jan-2004 bramajey Created this function --
202 -- 1.1 15-Sep-2004 snekkala Added the parameter p_assignment_id --
203 ----------------------------------------------------------------------------
204 FUNCTION get_employer_info(p_assignment_id IN NUMBER
205 ,p_info_type IN VARCHAR2)
206 RETURN VARCHAR2;
207
208
209 ----------------------------------------------------------------------------
210 -- --
211 -- Name : GET_EMPLOYEE_INFO --
212 -- Type : FUNCTION --
213 -- Access : Public --
214 -- Description : Function to get Employee Details based on Info Type --
215 -- --
216 -- Parameters : --
217 -- IN : p_assignment_id NUMBER --
218 -- p_date_earned DATE --
219 -- p_info_type VARCHAR2 --
220 -- Change History : --
221 ----------------------------------------------------------------------------
222 -- Rev# Date Userid Description --
223 ----------------------------------------------------------------------------
224 -- 1.0 10-Jan-2004 bramajey Created this function --
225 ----------------------------------------------------------------------------
226 FUNCTION get_employee_info(p_assignment_id IN NUMBER
227 ,p_date_earned IN DATE
228 ,p_info_type IN VARCHAR2)
229 RETURN VARCHAR2;
230
231
232 ----------------------------------------------------------------------------
233 -- --
234 -- Name : GET_BALANCE_VALUE --
235 -- Type : FUNCTION --
236 -- Access : Public --
237 -- Description : Function to set the Balance value of a given Balance --
238 -- and Balance Dimension --
239 -- This function returns --
240 -- o Previous month value if Info Type is PREV_MONTH --
241 -- o Current month value if Info Type is CURR_MONTH --
242 -- o Prev Years average value of the defined balance --
243 -- --
244 -- Parameters : --
245 -- IN : p_assignment_id NUMBER --
246 -- p_business_group_id NUMBER --
247 -- p_balance_name VARCHAR2 --
248 -- p_balance_dimension VARCHAR2 --
252 -- Rev# Date Userid Description --
249 -- p_info_type VARCHAR2 --
250 -- Change History : --
251 ----------------------------------------------------------------------------
253 ----------------------------------------------------------------------------
254 -- 1.0 10-Jan-2004 bramajey Created this function --
255 ----------------------------------------------------------------------------
256 FUNCTION get_balance_value( p_assignment_id IN NUMBER
257 , p_business_group_id IN NUMBER
258 , p_balance_name IN VARCHAR2
259 , p_balance_dimension IN VARCHAR2
260 , p_info_type IN VARCHAR2
261 )
262 RETURN NUMBER;
263
264
265 ----------------------------------------------------------------------------
266 -- --
267 -- Name : GET_ELEMENT_ENTRY --
268 -- Type : FUNCTION --
269 -- Access : Public --
270 -- Description : Function to check whether an assignment has element --
271 -- entries for the given PHF/SI Type --
272 -- --
273 -- Parameters : --
274 -- IN : p_assignment_id NUMBER --
275 -- p_business_group_id NUMBER --
276 -- p_effective_date IN DATE --
277 -- p_phf_si_type IN VARCHAR2 --
278 -- Change History : --
279 ----------------------------------------------------------------------------
280 -- Rev# Date Userid Description --
281 ----------------------------------------------------------------------------
282 -- 1.0 10-Jan-2004 bramajey Created this function --
283 -- 1.1 04-Feb-2004 bramajey Removed parameters p_start_date and --
284 -- p_end_date. Added new paramter --
285 -- p_effective_date --
286 ----------------------------------------------------------------------------
287 FUNCTION get_element_entry ( p_assignment_id IN NUMBER
288 , p_business_group_id IN NUMBER
289 , p_effective_date IN DATE
290 , p_phf_si_type IN VARCHAR2
291 )
292 RETURN VARCHAR2;
293
294 ----------------------------------------------------------------------------
295 -- --
296 -- Name : GET_ASSIGNMENT_ACTION --
297 -- Type : FUNCTION --
298 -- Access : Private --
299 -- Description : Function to check whether an assignment has assignment--
300 -- action id for the given period --
301 -- --
302 -- Parameters : --
303 -- IN : p_assignment_id NUMBER --
304 -- p_business_group_id NUMBER --
305 -- Change History : --
306 ----------------------------------------------------------------------------
307 -- Rev# Date Userid Description --
308 ----------------------------------------------------------------------------
309 -- 1.0 03-Feb-2004 saikrish Created this function (Bug# 3411273) --
310 ----------------------------------------------------------------------------
311 FUNCTION get_assignment_action ( p_assignment_id IN NUMBER
312 , p_business_group_id IN NUMBER
313 , p_start_date IN DATE
314 , p_end_date IN DATE
315 )
316 RETURN VARCHAR2;
317
318
319 ----------------------------------------------------------------------------
320 -- --
321 -- Name : GET_OVERRIDE_SIC_CODE --
322 -- Type : FUNCTION --
323 -- Access : Privatre --
324 -- Description : Function to check whether an assignment has Override --
325 -- SIC code for the given PHF/SI Type --
326 -- --
327 -- Parameters : --
328 -- IN : p_element_name IN VARCHAR2 --
329 -- p_assignment_id IN NUMBER --
330 -- p_date_earned IN DATE --
331 -- Change History : --
332 ----------------------------------------------------------------------------
333 -- Rev# Date Userid Description --
334 ----------------------------------------------------------------------------
335 -- 1.0 03-Feb-2004 saikrish Created this function(Bug# 3411840) --
336 -- 1.1 05-Feb-2004 saikrish Removed p_business_group_id --
337 ----------------------------------------------------------------------------
338 FUNCTION get_override_sic_code ( p_element_name IN VARCHAR2
339 , p_assignment_id IN NUMBER
340 , p_date_earned IN DATE
341 )
342 RETURN VARCHAR2;
343
344
345
346 END pay_cn_ext;