[Home] [Help]
PACKAGE: APPS.PAY_PYAURECP_XMLP_PKG
Source
1 PACKAGE PAY_PYAURECP_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: PYAURECPS.pls 120.0.12020000.2 2012/07/03 07:30:14 jmarupil ship $ */
3 P_ASSIGNMENT_ID VARCHAR2(40);
4
5 P_PAYROLL_ID VARCHAR2(40);
6
7 P_REGISTERED_EMPLOYER VARCHAR2(40);
8
9 P_FINANCIAL_YEAR VARCHAR2(32767);
10
11 P_EMPLOYEE_TYPE VARCHAR2(40);
12
13 P_CONC_REQUEST_ID NUMBER := 3487554;
14
15 P_BUSINESS_GROUP_ID NUMBER;
16
17 ASSIGNMENT_ACTION_ID NUMBER;
18
19 DATE_EARNED DATE;
20
21 CLAUSE VARCHAR2(100);
22
23 P_LST_YR_TERM VARCHAR2(10);
24
25 WHERECLAUSE VARCHAR2(100):= ' ';
26
27 P_PAYROLL_ACTION_ID NUMBER;
28
29 MANUAL_PS_ISSUED VARCHAR2(20);
30
31 FOREIGN_PS_EXISTS VARCHAR2(20);
32
33 CP_FIN_YR_START DATE;
34
35 CP_FIN_YR_END DATE;
36
37 CP_FBT_YR_START DATE;
38
39 CP_FBT_YR_END DATE;
40
41 CP_TOTAL_STANDARD NUMBER;
42
43 CP_TOTAL_ETP NUMBER;
44
45 CP_TOTAL_CURRENT_EMPLOYEES NUMBER;
46
47 CP_TOTAL_TERMINATED_EMPLOYEES NUMBER;
48
49 CP_TOTAL_GROSS NUMBER;
50
51 CP_TOTAL_RFB NUMBER;
52
53 CP_TOTAL_LUMPSUM_A_PAY NUMBER;
54
55 CP_TOTAL_LUMPSUM_B_PAY NUMBER;
56
57 CP_TOTAL_LUMPSUM_D_PAY NUMBER;
58
59 CP_TOTAL_LUMPSUM_E_PAY NUMBER;
60
61 CP_TOTAL_UNION_FEES NUMBER;
62
63 CP_TOTAL_TID NUMBER;
64
65 CP_TOTAL_PRE_JUL_83 NUMBER;
66
67 CP_TOTAL_JUN_83_UNT NUMBER;
68
69 CP_TOTAL_JUN_83_TAX NUMBER;
70
71 CP_TOTAL_JUN_94_INV NUMBER;
72
73 CP_TOTAL_GROSS_ETP NUMBER;
74
75 CP_TOTAL_ETP_TID NUMBER;
76
77 CP_TOTAL_ASSESSABLE_INCOME NUMBER;
78
79 CP_TOTAL_ALLOWANCES NUMBER;
80
81 CP_TOTAL_CDEP NUMBER;
82
83 CP_FINANCIAL_YEAR VARCHAR2(40);
84
85 CP_REG_EMP VARCHAR2(102);
86
87 CP_PAYROLL_NAME VARCHAR2(80);
88
89 CP_EMP_TYPE VARCHAR2(80);
90
91 CP_ASSIGNMENT_NUMBER VARCHAR2(80);
92
93 CP_FBT_GLOBAL VARCHAR2(240);
94
95 CP_ML_GLOBAL VARCHAR2(240);
96
97 CP_DIMENSION VARCHAR2(20);
98
99 CP_ASSGT_COUNTER NUMBER := 0;
100
101 CP_ASSGT_TOTAL NUMBER;
102
103 CP_LST_YR_START DATE;
104
105 CP_LST_YR_TERM VARCHAR2(80);
106
107 CP_TOTAL_WORKPLACE NUMBER;
108
109 CP_FW_TOTAL_ALLOWANCE NUMBER;
110
111 CP_FW_TOTAL_FTID NUMBER;
112
113 CP_FW_TOTAL_GROSS NUMBER;
114
115 CP_FW_TOTAL_LUMPSUMA NUMBER;
116
117 CP_FW_TOTAL_LUMPSUMD NUMBER;
118
119 CP_FW_TOTAL_LUMPSUME NUMBER;
120
121 CP_FW_TOTAL_NET_BAL NUMBER;
122
123 CP_FW_TOTAL_RESC NUMBER;
124
125 CP_FW_TOTAL_RFB NUMBER;
126
127 CP_FW_TOTAL_STANDARD NUMBER;
128
129 CP_FW_TOTAL_SUB_BAL NUMBER;
130
131 CP_FW_TOTAL_TID NUMBER;
132
133 CP_FW_TOTAL_UNION_FEES NUMBER;
134
135 CP_FW_TOTAL_WORKPLACE NUMBER;
136
137 CP_MAN_TOTAL_STANDARD NUMBER;
138
139 CP_MAN_TOTAL_ETP NUMBER;
140
141 CP_MAN_TOTAL_CURR_EMPLOYEES NUMBER;
142
143 CP_MAN_TOTAL_TERM_EMPLOYEES NUMBER;
144
145 CP_MAN_TOTAL_GROSS NUMBER;
146
147 CP_MAN_TOTAL_RFB NUMBER;
148
149 CP_MAN_TOTAL_LUMPSUM_A_PAY NUMBER;
150
151 CP_MAN_TOTAL_LUMPSUM_B_PAY NUMBER;
152
153 CP_MAN_TOTAL_LUMPSUM_D_PAY NUMBER;
154
155 CP_MAN_TOTAL_LUMPSUM_E_PAY NUMBER;
156
157 CP_MAN_TOTAL_UNION_FEES NUMBER;
158
159 CP_MAN_TOTAL_TID NUMBER;
160
161 CP_MAN_TOTAL_PRE_JUL_83 NUMBER;
162
163 CP_MAN_TOTAL_JUN_83_UNT NUMBER;
164
165 CP_MAN_TOTAL_JUN_83_TAX NUMBER;
166
167 CP_MAN_TOTAL_JUN_94_INV NUMBER;
168
169 CP_MAN_TOTAL_GROSS_ETP NUMBER;
170
171 CP_MAN_TOTAL_ETP_TID NUMBER;
172
173 CP_MAN_TOTAL_ASSESSABLE_INCOME NUMBER;
174
175 CP_MAN_TOTAL_ALLOWANCES NUMBER;
176
177 CP_MAN_TOTAL_CDEP NUMBER;
178
179 CP_MAN_TOTAL_FOREIGN_INCOME NUMBER;
180
181 CP_MAN_TOTAL_RESC NUMBER;
182
183 CP_MAN_TOTAL_TAXABLE_COMP NUMBER;
184
185 CP_MAN_TOTAL_TAX_FREE_COMP NUMBER;
186
187 CP_MAN_TOTAL_WORKPLACE NUMBER;
188
189 CP_TOTAL_FOREIGN_INCOME NUMBER;
190
191 CP_TOTAL_NET_BAL NUMBER;
192
193 CP_TOTAL_RESC NUMBER;
194
195 CP_TOTAL_TAXABLE_COMP NUMBER;
196
197 CP_TOTAL_TAX_FREE_COMP NUMBER;
198
199 /*ADDED AS FIX*/
200 LP_PAYROLL_ACTION_ID NUMBER;
201 LP_ASSIGNMENT_ID VARCHAR2(40);
202 LP_BUSINESS_GROUP_ID NUMBER;
203 LP_EMPLOYEE_TYPE VARCHAR2(40);
204 LP_FINANCIAL_YEAR VARCHAR2(32767);
205 LP_LST_YR_TERM VARCHAR2(10);
206 LP_PAYROLL_ID VARCHAR2(40);
207 LP_REGISTERED_EMPLOYER VARCHAR2(40);
208
209
210 FUNCTION BEFOREREPORT RETURN BOOLEAN;
211
212 FUNCTION CF_CALC_TOTALSFORMULA(ASSIGNMENT_ID IN NUMBER
213 ,TAX_UNIT_ID IN NUMBER
214 ,EMP_TYPE IN VARCHAR2
215 ,TERM_DATE IN DATE) RETURN NUMBER;
216
217 FUNCTION AFTERREPORT RETURN BOOLEAN;
218
219 FUNCTION CF_CALC_GROUP_TOTALSFORMULA RETURN NUMBER;
220
221 FUNCTION MANUAL_PS_ISSUED_P RETURN VARCHAR2;
222
223 FUNCTION FOREIGN_PS_EXISTS_P RETURN VARCHAR2;
224
225 FUNCTION ASSIGNMENT_ACTION_ID_P RETURN NUMBER;
226
227 FUNCTION DATE_EARNED_P RETURN DATE;
228
229 FUNCTION CP_FIN_YR_START_P RETURN DATE;
230
231 FUNCTION CP_FIN_YR_END_P RETURN DATE;
232
233 FUNCTION CP_FBT_YR_START_P RETURN DATE;
234
235 FUNCTION CP_FBT_YR_END_P RETURN DATE;
236
237 FUNCTION CP_TOTAL_STANDARD_P RETURN NUMBER;
238
239 FUNCTION CP_TOTAL_ETP_P RETURN NUMBER;
240
241 FUNCTION CP_TOTAL_CURRENT_EMPLOYEES_P RETURN NUMBER;
242
243 --FUNCTION CP_TOTAL_TERMINATED_EMPLOYEES RETURN NUMBER;
244 FUNCTION CP_TOTAL_TERMINATED_EMPLOY_P RETURN NUMBER;
245 FUNCTION CP_TOTAL_GROSS_P RETURN NUMBER;
246
247 FUNCTION CP_TOTAL_RFB_P RETURN NUMBER;
248
249 FUNCTION CP_TOTAL_LUMPSUM_A_PAY_P RETURN NUMBER;
250
251 FUNCTION CP_TOTAL_LUMPSUM_B_PAY_P RETURN NUMBER;
252
253 FUNCTION CP_TOTAL_LUMPSUM_D_PAY_P RETURN NUMBER;
254
255 FUNCTION CP_TOTAL_LUMPSUM_E_PAY_P RETURN NUMBER;
256
257 FUNCTION CP_TOTAL_UNION_FEES_P RETURN NUMBER;
258
259 FUNCTION CP_TOTAL_TID_P RETURN NUMBER;
260
261 FUNCTION CP_TOTAL_PRE_JUL_83_P RETURN NUMBER;
262
263 FUNCTION CP_TOTAL_JUN_83_UNT_P RETURN NUMBER;
264
265 FUNCTION CP_TOTAL_JUN_83_TAX_P RETURN NUMBER;
266
267 FUNCTION CP_TOTAL_JUN_94_INV_P RETURN NUMBER;
268
269 FUNCTION CP_TOTAL_GROSS_ETP_P RETURN NUMBER;
270
271 FUNCTION CP_TOTAL_ETP_TID_P RETURN NUMBER;
272
273 FUNCTION CP_TOTAL_ASSESSABLE_INCOME_P RETURN NUMBER;
274
275 FUNCTION CP_TOTAL_ALLOWANCES_P RETURN NUMBER;
276
277 FUNCTION CP_TOTAL_CDEP_P RETURN NUMBER;
278
279 FUNCTION CP_FINANCIAL_YEAR_P RETURN VARCHAR2;
280
281 FUNCTION CP_REG_EMP_P RETURN VARCHAR2;
282
283 FUNCTION CP_PAYROLL_NAME_P RETURN VARCHAR2;
284
285 FUNCTION CP_EMP_TYPE_P RETURN VARCHAR2;
286
287 FUNCTION CP_ASSIGNMENT_NUMBER_P RETURN VARCHAR2;
288
289 FUNCTION CP_FBT_GLOBAL_P RETURN VARCHAR2;
290
291 FUNCTION CP_ML_GLOBAL_P RETURN VARCHAR2;
292
293 FUNCTION CP_DIMENSION_P RETURN VARCHAR2;
294
295 FUNCTION CP_ASSGT_COUNTER_P RETURN NUMBER;
296
297 FUNCTION CP_ASSGT_TOTAL_P RETURN NUMBER;
298
299 FUNCTION CP_LST_YR_START_P RETURN DATE;
300
301 FUNCTION CP_LST_YR_TERM_P RETURN VARCHAR2;
302
303 FUNCTION CP_TOTAL_WORKPLACE_P RETURN NUMBER;
304
305 FUNCTION CP_FW_TOTAL_ALLOWANCE_P RETURN NUMBER;
306
307 FUNCTION CP_FW_TOTAL_FTID_P RETURN NUMBER;
308
309 FUNCTION CP_FW_TOTAL_GROSS_P RETURN NUMBER;
310
311 FUNCTION CP_FW_TOTAL_LUMPSUMA_P RETURN NUMBER;
312
313 FUNCTION CP_FW_TOTAL_LUMPSUMD_P RETURN NUMBER;
314
315 FUNCTION CP_FW_TOTAL_LUMPSUME_P RETURN NUMBER;
316
317 FUNCTION CP_FW_TOTAL_NET_BAL_P RETURN NUMBER;
318
319 FUNCTION CP_FW_TOTAL_RESC_P RETURN NUMBER;
320
321 FUNCTION CP_FW_TOTAL_RFB_P RETURN NUMBER;
322
323 FUNCTION CP_FW_TOTAL_STANDARD_P RETURN NUMBER;
324
325 FUNCTION CP_FW_TOTAL_SUB_BAL_P RETURN NUMBER;
326
327 FUNCTION CP_FW_TOTAL_TID_P RETURN NUMBER;
328
329 FUNCTION CP_FW_TOTAL_UNION_FEES_P RETURN NUMBER;
330
331 FUNCTION CP_FW_TOTAL_WORKPLACE_P RETURN NUMBER;
332
333 FUNCTION CP_MAN_TOTAL_STANDARD_P RETURN NUMBER;
334
335 FUNCTION CP_MAN_TOTAL_ETP_P RETURN NUMBER;
336
337 FUNCTION CP_MAN_TOTAL_CURR_EMPLOYEES_P RETURN NUMBER;
338
339 FUNCTION CP_MAN_TOTAL_TERM_EMPLOYEES_P RETURN NUMBER;
340
341 FUNCTION CP_MAN_TOTAL_GROSS_P RETURN NUMBER;
342
343 FUNCTION CP_MAN_TOTAL_RFB_P RETURN NUMBER;
344
345 FUNCTION CP_MAN_TOTAL_LUMPSUM_A_PAY_P RETURN NUMBER;
346
347 FUNCTION CP_MAN_TOTAL_LUMPSUM_B_PAY_P RETURN NUMBER;
348
349 FUNCTION CP_MAN_TOTAL_LUMPSUM_D_PAY_P RETURN NUMBER;
350
351 FUNCTION CP_MAN_TOTAL_LUMPSUM_E_PAY_P RETURN NUMBER;
352
353 FUNCTION CP_MAN_TOTAL_UNION_FEES_P RETURN NUMBER;
354
355 FUNCTION CP_MAN_TOTAL_TID_P RETURN NUMBER;
356
357 FUNCTION CP_MAN_TOTAL_PRE_JUL_83_P RETURN NUMBER;
358
359 FUNCTION CP_MAN_TOTAL_JUN_83_UNT_P RETURN NUMBER;
360
361 FUNCTION CP_MAN_TOTAL_JUN_83_TAX_P RETURN NUMBER;
362
363 FUNCTION CP_MAN_TOTAL_JUN_94_INV_P RETURN NUMBER;
364
365 FUNCTION CP_MAN_TOTAL_GROSS_ETP_P RETURN NUMBER;
366
367 FUNCTION CP_MAN_TOTAL_ETP_TID_P RETURN NUMBER;
368
369 FUNCTION CP_MAN_TOTAL_ASSESSABLE_INCOM RETURN NUMBER;
370
371 FUNCTION CP_MAN_TOTAL_ALLOWANCES_P RETURN NUMBER;
372
373 FUNCTION CP_MAN_TOTAL_CDEP_P RETURN NUMBER;
374
375 FUNCTION CP_MAN_TOTAL_WORKPLACE_P RETURN NUMBER;
376
377 FUNCTION CP_MAN_TOTAL_FOREIGN_INCOME_P RETURN NUMBER;
378
379 FUNCTION CP_MAN_TOTAL_RESC_P RETURN NUMBER;
380
381 FUNCTION CP_MAN_TOTAL_TAXABLE_COMP_P RETURN NUMBER;
382
383 FUNCTION CP_MAN_TOTAL_TAX_FREE_COMP_P RETURN NUMBER;
384
385 FUNCTION CP_TOTAL_FOREIGN_INCOME_P RETURN NUMBER;
386
387 FUNCTION CP_TOTAL_NET_BAL_P RETURN NUMBER;
388
389 FUNCTION CP_TOTAL_RESC_P RETURN NUMBER;
390
391 FUNCTION CP_TOTAL_TAXABLE_COMP_P RETURN NUMBER;
392
393 FUNCTION CP_TOTAL_TAX_FREE_COMP_P RETURN NUMBER;
394
395 END PAY_PYAURECP_XMLP_PKG;