[Home] [Help]
PACKAGE BODY: APPS.PAY_PYAURECP_XMLP_PKG
Source
1 PACKAGE BODY PAY_PYAURECP_XMLP_PKG AS
2 /* $Header: PYAURECPB.pls 120.0 2007/12/13 12:15:05 amakrish noship $ */
3 FUNCTION BEFOREREPORT RETURN BOOLEAN IS
4 CURSOR C_YEAR(C_FIN_YR IN VARCHAR2) IS
5 SELECT
6 TO_DATE('01-07-' || SUBSTR(C_FIN_YR
7 ,1
8 ,4)
9 ,'DD-MM-YYYY') FINANCIAL_YEAR_START,
10 TO_DATE('30-06-' || SUBSTR(C_FIN_YR
11 ,6
12 ,4)
13 ,'DD-MM-YYYY') FINANCIAL_YEAR_END,
14 TO_DATE('01-04-' || SUBSTR(C_FIN_YR
15 ,1
16 ,4)
17 ,'DD-MM-YYYY') FBT_YEAR_START,
18 TO_DATE('30-06-' || SUBSTR(C_FIN_YR
19 ,1
20 ,4)
21 ,'DD-MM-YYYY') FBT_YEAR_END
22 FROM
23 DUAL;
24 CURSOR C_REG_EMP(C_ORG_ID IN HR_AU_LEG_EMP_V.ORGANIZATION_ID%TYPE) IS
25 SELECT
26 NAME
27 FROM
28 HR_AU_LEG_EMP_V
29 WHERE ORGANIZATION_ID = C_ORG_ID;
30 CURSOR C_PAYROLL_INFO(C_PAYROLL_ID IN NUMBER) IS
31 SELECT
32 PPF.PAYROLL_NAME
33 FROM
34 PAY_PAYROLLS_F PPF
35 WHERE PPF.PAYROLL_ID = C_PAYROLL_ID
36 AND PPF.EFFECTIVE_START_DATE = (
37 SELECT
38 MAX(PPF1.EFFECTIVE_START_DATE)
39 FROM
40 PAY_PAYROLLS_F PPF1
41 WHERE PPF1.PAYROLL_ID = PPF.PAYROLL_ID );
42 CURSOR C_HL_MEANING(C_HL_CODE IN HR_LOOKUPS.LOOKUP_CODE%TYPE) IS
43 SELECT
44 HL.MEANING
45 FROM
46 HR_LOOKUPS HL
47 WHERE HL.LOOKUP_TYPE = 'AU_PS_EMPLOYEE_TYPE'
48 AND HL.ENABLED_FLAG = 'Y'
49 AND HL.LOOKUP_CODE = C_HL_CODE;
50 CURSOR C_ASSIGNMENT_INFO(C_ASSIGNMENT_ID IN NUMBER) IS
51 SELECT
52 PAA.ASSIGNMENT_NUMBER
53 FROM
54 PER_ASSIGNMENTS_F PAA
55 WHERE PAA.ASSIGNMENT_ID = C_ASSIGNMENT_ID
56 AND PAA.EFFECTIVE_START_DATE = (
57 SELECT
58 MAX(PAA1.EFFECTIVE_START_DATE)
59 FROM
60 PER_ASSIGNMENTS_F PAA1
61 WHERE PAA1.ASSIGNMENT_ID = PAA.ASSIGNMENT_ID
62 AND PAA1.EFFECTIVE_START_DATE <= CP_FIN_YR_END
63 AND PAA1.EFFECTIVE_END_DATE >= CP_FIN_YR_START );
64 CURSOR C_GET_GLOBAL(C_NAME IN VARCHAR2,C_YEAR_END IN DATE) IS
65 SELECT
66 GLOBAL_VALUE
67 FROM
68 FF_GLOBALS_F
69 WHERE GLOBAL_NAME = C_NAME
70 AND LEGISLATION_CODE = 'AU'
71 AND C_YEAR_END BETWEEN EFFECTIVE_START_DATE
72 AND EFFECTIVE_END_DATE;
73 CURSOR C_ASG_COUNT IS
74 SELECT
75 COUNT(ASSIGNMENT_ACTION_ID)
76 FROM
77 PAY_ASSIGNMENT_ACTIONS
78 WHERE PAYROLL_ACTION_ID = LP_PAYROLL_ACTION_ID;
79 X NUMBER;
80 L_TEXT LONG;
81 LN NUMBER;
82 BEGIN
83 select
84 SUBSTR(argument1,INSTR(argument1,'=',1)+1,LENGTH(argument1)),
85 SUBSTR(argument2,INSTR(argument2,'=',1)+1,LENGTH(argument2)),
86 SUBSTR(argument3,INSTR(argument3,'=',1)+1,LENGTH(argument3)),
87 SUBSTR(argument4,INSTR(argument4,'=',1)+1,LENGTH(argument4)),
88 SUBSTR(argument5,INSTR(argument5,'=',1)+1,LENGTH(argument5)),
89 SUBSTR(argument6,INSTR(argument6,'=',1)+1,LENGTH(argument6)),
90 SUBSTR(argument7,INSTR(argument7,'=',1)+1,LENGTH(argument7)),
91 SUBSTR(argument8,INSTR(argument8,'=',1)+1,LENGTH(argument8))
92 into
93
94 LP_PAYROLL_ACTION_ID,
95 LP_ASSIGNMENT_ID,
96 LP_BUSINESS_GROUP_ID,
97 LP_EMPLOYEE_TYPE,
98 LP_FINANCIAL_YEAR,
99 LP_LST_YR_TERM,
100 LP_PAYROLL_ID,
101 LP_REGISTERED_EMPLOYER
102
103 from FND_CONCURRENT_REQUESTS
104 where request_id= FND_GLOBAL.conc_request_id;
105 P_ASSIGNMENT_ID:=LP_ASSIGNMENT_ID;
106
107 P_CONC_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
108 X := PAY_AU_RECON_SUMMARY.POPULATE_BAL_IDS('Y'
109 ,LP_BUSINESS_GROUP_ID
110 ,LP_LST_YR_TERM);
111 -- WHERECLAUSE := NULL;
112 WHERECLAUSE := ' ';
113 IF (LP_REGISTERED_EMPLOYER IS NOT NULL) THEN
114 IF (LP_PAYROLL_ID IS NOT NULL) THEN
115 CP_DIMENSION := '_ASG_LE_YTD';
116 IF (LP_ASSIGNMENT_ID IS NOT NULL) THEN
117 WHERECLAUSE := 'and pa1.assignment_id=' || LP_ASSIGNMENT_ID;
118 ELSE
119 WHERECLAUSE := 'and pa1.payroll_id=' || LP_PAYROLL_ID;
120 END IF;
121 ELSE
122 CP_DIMENSION := '_LE_YTD';
123 END IF;
124 END IF;
125
126 CP_TOTAL_STANDARD := 0;
127 CP_TOTAL_CURRENT_EMPLOYEES := 0;
128 CP_TOTAL_TERMINATED_EMPLOYEES := 0;
129 CP_TOTAL_GROSS := 0;
130 CP_TOTAL_ALLOWANCES := 0;
131 CP_TOTAL_RFB := 0;
132 CP_TOTAL_CDEP := 0;
133 CP_TOTAL_LUMPSUM_A_PAY := 0;
134 CP_TOTAL_LUMPSUM_B_PAY := 0;
135 CP_TOTAL_LUMPSUM_D_PAY := 0;
136 CP_TOTAL_LUMPSUM_E_PAY := 0;
137 CP_TOTAL_UNION_FEES := 0;
138 CP_TOTAL_TID := 0;
139 CP_TOTAL_OTHER_INCOME := 0;
140 CP_TOTAL_ETP := 0;
141 CP_TOTAL_PRE_JUL_83 := 0;
142 CP_TOTAL_JUN_83_UNT := 0;
143 CP_TOTAL_JUN_83_TAX := 0;
144 CP_TOTAL_JUN_94_INV := 0;
145 CP_TOTAL_GROSS_ETP := 0;
146 CP_TOTAL_ETP_TID := 0;
147 CP_TOTAL_ASSESSABLE_INCOME := 0;
148 CP_TOTAL_WORKPLACE := 0;
149 CP_MAN_TOTAL_STANDARD := 0;
150 CP_MAN_TOTAL_CURR_EMPLOYEES := 0;
151 CP_MAN_TOTAL_TERM_EMPLOYEES := 0;
152 CP_MAN_TOTAL_GROSS := 0;
153 CP_MAN_TOTAL_ALLOWANCES := 0;
154 CP_MAN_TOTAL_RFB := 0;
155 CP_MAN_TOTAL_CDEP := 0;
156 CP_MAN_TOTAL_LUMPSUM_A_PAY := 0;
157 CP_MAN_TOTAL_LUMPSUM_B_PAY := 0;
158 CP_MAN_TOTAL_LUMPSUM_D_PAY := 0;
159 CP_MAN_TOTAL_LUMPSUM_E_PAY := 0;
160 CP_MAN_TOTAL_UNION_FEES := 0;
161 CP_MAN_TOTAL_TID := 0;
162 CP_MAN_TOTAL_OTHER_INCOME := 0;
163 CP_MAN_TOTAL_ETP := 0;
164 CP_MAN_TOTAL_PRE_JUL_83 := 0;
165 CP_MAN_TOTAL_JUN_83_UNT := 0;
166 CP_MAN_TOTAL_JUN_83_TAX := 0;
167 CP_MAN_TOTAL_JUN_94_INV := 0;
168 CP_MAN_TOTAL_GROSS_ETP := 0;
169 CP_MAN_TOTAL_ETP_TID := 0;
170 CP_MAN_TOTAL_ASSESSABLE_INCOME := 0;
171 CP_MAN_TOTAL_WORKPLACE := 0;
172 OPEN C_YEAR(LP_FINANCIAL_YEAR);
173 FETCH C_YEAR
174 INTO
175 CP_FIN_YR_START
176 ,CP_FIN_YR_END
177 ,CP_FBT_YR_START
178 ,CP_FBT_YR_END;
179 CLOSE C_YEAR;
180 CP_FINANCIAL_YEAR := LP_FINANCIAL_YEAR;
181 IF (LP_LST_YR_TERM = 'Y') THEN
182 CP_LST_YR_START := ADD_MONTHS(CP_FIN_YR_START
183 ,-12);
184 ELSE
185 CP_LST_YR_START := TO_DATE('01/01/1900'
186 ,'DD/MM/YYYY');
187 END IF;
188 OPEN C_REG_EMP(LP_REGISTERED_EMPLOYER);
189 FETCH C_REG_EMP
190 INTO
191 CP_REG_EMP;
192 CLOSE C_REG_EMP;
193 OPEN C_HL_MEANING(LP_EMPLOYEE_TYPE);
194 FETCH C_HL_MEANING
195 INTO
196 CP_EMP_TYPE;
197 CLOSE C_HL_MEANING;
198 IF LP_PAYROLL_ID IS NOT NULL THEN
199 OPEN C_PAYROLL_INFO(LP_PAYROLL_ID);
200 FETCH C_PAYROLL_INFO
201 INTO
202 CP_PAYROLL_NAME;
203 CLOSE C_PAYROLL_INFO;
204 END IF;
205 IF LP_ASSIGNMENT_ID IS NOT NULL THEN
206 OPEN C_ASSIGNMENT_INFO(LP_ASSIGNMENT_ID);
207 FETCH C_ASSIGNMENT_INFO
208 INTO
209 CP_ASSIGNMENT_NUMBER;
210 CLOSE C_ASSIGNMENT_INFO;
211 END IF;
212 IF LP_EMPLOYEE_TYPE = 'C' THEN
213 LP_EMPLOYEE_TYPE := 'Y';
214 END IF;
215 IF LP_EMPLOYEE_TYPE = 'T' THEN
216 LP_EMPLOYEE_TYPE := 'N';
217 END IF;
218 IF LP_EMPLOYEE_TYPE = 'B' THEN
219 LP_EMPLOYEE_TYPE := '%';
220 END IF;
221 IF LP_LST_YR_TERM = 'Y' THEN
222 CP_LST_YR_TERM := 'Yes';
223 ELSE
224 IF LP_LST_YR_TERM = 'N' THEN
225 CP_LST_YR_TERM := 'No';
226 END IF;
227 END IF;
228 OPEN C_GET_GLOBAL('FBT_RATE',ADD_MONTHS(CP_FIN_YR_END
229 ,-3));
230 FETCH C_GET_GLOBAL
231 INTO
232 CP_FBT_GLOBAL;
233 CLOSE C_GET_GLOBAL;
234 OPEN C_GET_GLOBAL('MEDICARE_LEVY',ADD_MONTHS(CP_FIN_YR_END
235 ,-3));
236 FETCH C_GET_GLOBAL
237 INTO
238 CP_ML_GLOBAL;
239 CLOSE C_GET_GLOBAL;
240 OPEN C_ASG_COUNT;
241 FETCH C_ASG_COUNT
242 INTO
243 CP_ASSGT_TOTAL;
244 CLOSE C_ASG_COUNT;
245 RETURN (TRUE);
246 END BEFOREREPORT;
247
248 FUNCTION CF_CALC_TOTALSFORMULA(ASSIGNMENT_ID IN NUMBER
249 ,TAX_UNIT_ID IN NUMBER
250 ,EMP_TYPE IN VARCHAR2
251 ,TERM_DATE IN DATE
252 ,DATE_EARNED IN DATE
253 ,ASSIGNMENT_ACTION_ID IN NUMBER) RETURN NUMBER IS
254 L_OUTPUT_TAB PAY_AU_RECON_SUMMARY.BAL_TAB;
255 L_TERM_OUTPUT_TAB PAY_AU_RECON_SUMMARY.BAL_TAB;
256 L_DISPLAY_FLAG VARCHAR2(5);
257 L_MESSAGE VARCHAR2(100);
258 L_FBT_VALUE NUMBER;
259 X NUMBER;
260 L_MANUAL_PS_YEAR VARCHAR2(80);
261 CURSOR C_PAYMENT_SUMMARY_DETAILS(C_ASSIGNMENT_ID IN NUMBER,C_FIN_DATE IN DATE,C_TAX_UNIT_ID IN PAY_ASSIGNMENT_ACTIONS.TAX_UNIT_ID%TYPE) IS
262 SELECT
263 HR.MEANING FIN_YEAR
264 FROM
265 PER_ASSIGNMENT_EXTRA_INFO PAE,
266 HR_LOOKUPS HR
267 WHERE PAE.AEI_INFORMATION_CATEGORY = 'HR_PS_ISSUE_DATE_AU'
268 AND PAE.INFORMATION_TYPE = 'HR_PS_ISSUE_DATE_AU'
269 AND PAE.ASSIGNMENT_ID = C_ASSIGNMENT_ID
270 AND PAE.AEI_INFORMATION1 = TO_CHAR(C_FIN_DATE
271 ,'YY')
272 AND NVL(AEI_INFORMATION2
273 ,C_TAX_UNIT_ID) = DECODE(AEI_INFORMATION2
274 ,'-999'
275 ,AEI_INFORMATION2
276 ,C_TAX_UNIT_ID)
277 AND PAE.AEI_INFORMATION1 = HR.LOOKUP_CODE
278 AND HR.LOOKUP_TYPE = 'AU_PS_FINANCIAL_YEAR';
279 BEGIN
280 OPEN C_PAYMENT_SUMMARY_DETAILS(ASSIGNMENT_ID,CP_FIN_YR_START,TAX_UNIT_ID);
281 FETCH C_PAYMENT_SUMMARY_DETAILS
282 INTO
283 L_MANUAL_PS_YEAR;
284 IF C_PAYMENT_SUMMARY_DETAILS%FOUND THEN
285 MANUAL_PS_ISSUED := 'Y';
286 ELSE
287 MANUAL_PS_ISSUED := 'N';
288 END IF;
289 CLOSE C_PAYMENT_SUMMARY_DETAILS;
290 IF EMP_TYPE = 'T' THEN
291 IF ((LP_LST_YR_TERM = 'Y' AND TERM_DATE > CP_FBT_YR_START) OR (LP_LST_YR_TERM = 'N' AND TERM_DATE > CP_LST_YR_START)) AND TERM_DATE < CP_FIN_YR_START AND DATE_EARNED < CP_FIN_YR_START THEN
292 CP_TOTAL_STANDARD := CP_TOTAL_STANDARD + 1;
293 CP_TOTAL_TERMINATED_EMPLOYEES := CP_TOTAL_TERMINATED_EMPLOYEES + 1;
294 L_FBT_VALUE := PAY_AU_RECON_SUMMARY.GET_TOTAL_FBT(CP_FIN_YR_START
295 ,ASSIGNMENT_ID
296 ,TAX_UNIT_ID
297 ,CP_FBT_GLOBAL
298 ,CP_ML_GLOBAL
299 ,'PRV_TERM');
300 CP_TOTAL_RFB := CP_TOTAL_RFB + L_FBT_VALUE;
301 X := PAY_AU_RECON_SUMMARY.POPULATE_EXCLUSION_TABLE(ASSIGNMENT_ID
302 ,CP_FINANCIAL_YEAR
303 ,CP_FIN_YR_END
304 ,TAX_UNIT_ID);
305 IF MANUAL_PS_ISSUED = 'Y' THEN
306 CP_MAN_TOTAL_STANDARD := CP_MAN_TOTAL_STANDARD + 1;
307 CP_MAN_TOTAL_TERM_EMPLOYEES := CP_MAN_TOTAL_TERM_EMPLOYEES + 1;
308 CP_MAN_TOTAL_RFB := CP_MAN_TOTAL_RFB + L_FBT_VALUE;
309 END IF;
310 RETURN (1);
311 END IF;
312 END IF;
313 IF (LP_EMPLOYEE_TYPE = '%' AND CP_DIMENSION < '_ASG_LE_YTD') THEN
314 L_DISPLAY_FLAG := 'YES';
315 IF (EMP_TYPE = 'T') THEN
316 IF (TERM_DATE < CP_FIN_YR_START) THEN
317 PAY_AU_RECON_SUMMARY.GET_VALUE_BBR(CP_FIN_YR_START
318 ,CP_FIN_YR_END
319 ,ASSIGNMENT_ID
320 ,CP_FBT_GLOBAL
321 ,CP_ML_GLOBAL
322 ,ASSIGNMENT_ACTION_ID
323 ,TAX_UNIT_ID
324 ,TERM_DATE
325 ,L_DISPLAY_FLAG
326 ,L_OUTPUT_TAB
327 ,L_MESSAGE);
328 IF L_MESSAGE IS NOT NULL THEN
329 RAISE_APPLICATION_ERROR(-20101
330 ,NULL);
331 END IF;
332 ELSE
333 L_DISPLAY_FLAG := 'YES';
334 END IF;
335 END IF;
336 IF L_DISPLAY_FLAG = 'YES' THEN
337 CP_TOTAL_STANDARD := CP_TOTAL_STANDARD + 1;
338 PAY_AU_RECON_SUMMARY.GET_ASSGT_CURR_TERM_VALUES_BBR(P_YEAR_START => CP_FIN_YR_START
339 ,P_YEAR_END => CP_FIN_YR_END
340 ,P_ASSIGNMENT_ID => ASSIGNMENT_ID
341 ,P_FBT_RATE => CP_FBT_GLOBAL
342 ,P_ML_RATE => CP_ML_GLOBAL
343 ,P_ASSIGNMENT_ACTION_ID => ASSIGNMENT_ACTION_ID
344 ,P_TAX_UNIT_ID => TAX_UNIT_ID
345 ,P_EMP_TYPE => EMP_TYPE
346 ,P_TERM_OUTPUT_TAB => L_TERM_OUTPUT_TAB
347 ,P_MESSAGE => L_MESSAGE);
348 IF L_MESSAGE IS NOT NULL THEN
349 RAISE_APPLICATION_ERROR(-20101
350 ,NULL);
351 END IF;
352 CP_TOTAL_ALLOWANCES := CP_TOTAL_ALLOWANCES + L_TERM_OUTPUT_TAB(1).BALANCE_VALUE;
353 CP_TOTAL_RFB := CP_TOTAL_RFB + L_TERM_OUTPUT_TAB(2).BALANCE_VALUE;
354 CP_TOTAL_LUMPSUM_E_PAY := CP_TOTAL_LUMPSUM_E_PAY + L_TERM_OUTPUT_TAB(3).BALANCE_VALUE;
355 IF EMP_TYPE = 'C' THEN
356 CP_TOTAL_CURRENT_EMPLOYEES := CP_TOTAL_CURRENT_EMPLOYEES + 1;
357 END IF;
358 IF EMP_TYPE = 'T' THEN
359 CP_TOTAL_TERMINATED_EMPLOYEES := CP_TOTAL_TERMINATED_EMPLOYEES + 1;
360 IF (L_TERM_OUTPUT_TAB(7).BALANCE_VALUE > 0) THEN
361 CP_TOTAL_ETP := CP_TOTAL_ETP + 1;
362 CP_TOTAL_PRE_JUL_83 := CP_TOTAL_PRE_JUL_83 + L_TERM_OUTPUT_TAB(4).BALANCE_VALUE;
363 CP_TOTAL_JUN_83_UNT := CP_TOTAL_JUN_83_UNT + L_TERM_OUTPUT_TAB(5).BALANCE_VALUE;
364 CP_TOTAL_JUN_94_INV := CP_TOTAL_JUN_94_INV + L_TERM_OUTPUT_TAB(6).BALANCE_VALUE;
365 CP_TOTAL_GROSS_ETP := CP_TOTAL_GROSS_ETP + L_TERM_OUTPUT_TAB(7).BALANCE_VALUE;
366 CP_TOTAL_ETP_TID := CP_TOTAL_ETP_TID + L_TERM_OUTPUT_TAB(8).BALANCE_VALUE;
367 CP_TOTAL_ASSESSABLE_INCOME := CP_TOTAL_ASSESSABLE_INCOME + L_TERM_OUTPUT_TAB(9).BALANCE_VALUE;
368 END IF;
369 END IF;
370 X := PAY_AU_RECON_SUMMARY.POPULATE_EXCLUSION_TABLE(ASSIGNMENT_ID
371 ,CP_FINANCIAL_YEAR
372 ,CP_FIN_YR_END
373 ,TAX_UNIT_ID);
374 END IF;
375 ELSE
376 PAY_AU_RECON_SUMMARY.GET_VALUE_BBR(CP_FIN_YR_START
377 ,CP_FIN_YR_END
378 ,ASSIGNMENT_ID
379 ,CP_FBT_GLOBAL
380 ,CP_ML_GLOBAL
381 ,ASSIGNMENT_ACTION_ID
382 ,TAX_UNIT_ID
383 ,TERM_DATE
384 ,L_DISPLAY_FLAG
385 ,L_OUTPUT_TAB
386 ,L_MESSAGE);
387 IF L_MESSAGE IS NOT NULL THEN
388 RAISE_APPLICATION_ERROR(-20101
389 ,NULL);
390 END IF;
391 IF L_DISPLAY_FLAG = 'YES' THEN
392 CP_TOTAL_STANDARD := CP_TOTAL_STANDARD + 1;
393 IF EMP_TYPE = 'C' THEN
394 CP_TOTAL_CURRENT_EMPLOYEES := CP_TOTAL_CURRENT_EMPLOYEES + 1;
395 END IF;
396 IF EMP_TYPE = 'T' THEN
397 CP_TOTAL_TERMINATED_EMPLOYEES := CP_TOTAL_TERMINATED_EMPLOYEES + 1;
398 END IF;
399 CP_TOTAL_GROSS := CP_TOTAL_GROSS + L_OUTPUT_TAB(11).BALANCE_VALUE;
400 CP_TOTAL_ALLOWANCES := CP_TOTAL_ALLOWANCES + L_OUTPUT_TAB(1).BALANCE_VALUE;
401 CP_TOTAL_RFB := CP_TOTAL_RFB + L_OUTPUT_TAB(2).BALANCE_VALUE;
402 CP_TOTAL_CDEP := CP_TOTAL_CDEP + L_OUTPUT_TAB(3).BALANCE_VALUE;
403 CP_TOTAL_LUMPSUM_A_PAY := CP_TOTAL_LUMPSUM_A_PAY + L_OUTPUT_TAB(4).BALANCE_VALUE;
404 CP_TOTAL_LUMPSUM_B_PAY := CP_TOTAL_LUMPSUM_B_PAY + L_OUTPUT_TAB(5).BALANCE_VALUE;
405 CP_TOTAL_LUMPSUM_D_PAY := CP_TOTAL_LUMPSUM_D_PAY + L_OUTPUT_TAB(6).BALANCE_VALUE;
406 CP_TOTAL_LUMPSUM_E_PAY := CP_TOTAL_LUMPSUM_E_PAY + L_OUTPUT_TAB(7).BALANCE_VALUE;
407 CP_TOTAL_UNION_FEES := CP_TOTAL_UNION_FEES + L_OUTPUT_TAB(8).BALANCE_VALUE;
408 CP_TOTAL_TID := CP_TOTAL_TID + L_OUTPUT_TAB(9).BALANCE_VALUE;
409 CP_TOTAL_OTHER_INCOME := CP_TOTAL_OTHER_INCOME + L_OUTPUT_TAB(10).BALANCE_VALUE;
410 CP_TOTAL_WORKPLACE := CP_TOTAL_WORKPLACE + L_OUTPUT_TAB(18).BALANCE_VALUE;
411 IF (EMP_TYPE = 'T' AND L_OUTPUT_TAB(15).BALANCE_VALUE > 0) THEN
412 CP_TOTAL_ETP := CP_TOTAL_ETP + 1;
413 CP_TOTAL_PRE_JUL_83 := CP_TOTAL_PRE_JUL_83 + L_OUTPUT_TAB(12).BALANCE_VALUE;
414 CP_TOTAL_JUN_83_UNT := CP_TOTAL_JUN_83_UNT + L_OUTPUT_TAB(13).BALANCE_VALUE;
415 CP_TOTAL_JUN_94_INV := CP_TOTAL_JUN_94_INV + L_OUTPUT_TAB(14).BALANCE_VALUE;
416 CP_TOTAL_GROSS_ETP := CP_TOTAL_GROSS_ETP + L_OUTPUT_TAB(15).BALANCE_VALUE;
417 CP_TOTAL_ETP_TID := CP_TOTAL_ETP_TID + L_OUTPUT_TAB(16).BALANCE_VALUE;
418 CP_TOTAL_ASSESSABLE_INCOME := CP_TOTAL_ASSESSABLE_INCOME + L_OUTPUT_TAB(17).BALANCE_VALUE;
419 END IF;
420 X := PAY_AU_RECON_SUMMARY.POPULATE_EXCLUSION_TABLE(ASSIGNMENT_ID
421 ,CP_FINANCIAL_YEAR
422 ,CP_FIN_YR_END
423 ,TAX_UNIT_ID);
424 END IF;
425 END IF;
426 IF MANUAL_PS_ISSUED = 'Y' THEN
427 IF (LP_EMPLOYEE_TYPE = '%' AND CP_DIMENSION < '_ASG_LE_YTD') THEN
428 PAY_AU_RECON_SUMMARY.GET_VALUE_BBR(CP_FIN_YR_START
429 ,CP_FIN_YR_END
430 ,ASSIGNMENT_ID
431 ,CP_FBT_GLOBAL
432 ,CP_ML_GLOBAL
433 ,ASSIGNMENT_ACTION_ID
434 ,TAX_UNIT_ID
435 ,TERM_DATE
436 ,L_DISPLAY_FLAG
437 ,L_OUTPUT_TAB
438 ,L_MESSAGE);
439 IF L_MESSAGE IS NOT NULL THEN
440 RAISE_APPLICATION_ERROR(-20101
441 ,NULL);
442 END IF;
443 END IF;
444 IF L_DISPLAY_FLAG = 'YES' THEN
445 CP_MAN_TOTAL_STANDARD := CP_MAN_TOTAL_STANDARD + 1;
446 IF EMP_TYPE = 'C' THEN
447 CP_MAN_TOTAL_CURR_EMPLOYEES := CP_MAN_TOTAL_CURR_EMPLOYEES + 1;
448 END IF;
449 IF EMP_TYPE = 'T' THEN
450 CP_MAN_TOTAL_TERM_EMPLOYEES := CP_MAN_TOTAL_TERM_EMPLOYEES + 1;
451 END IF;
452 CP_MAN_TOTAL_GROSS := CP_MAN_TOTAL_GROSS + L_OUTPUT_TAB(11).BALANCE_VALUE;
453 CP_MAN_TOTAL_ALLOWANCES := CP_MAN_TOTAL_ALLOWANCES + L_OUTPUT_TAB(1).BALANCE_VALUE;
454 CP_MAN_TOTAL_RFB := CP_MAN_TOTAL_RFB + L_OUTPUT_TAB(2).BALANCE_VALUE;
455 CP_MAN_TOTAL_CDEP := CP_MAN_TOTAL_CDEP + L_OUTPUT_TAB(3).BALANCE_VALUE;
456 CP_MAN_TOTAL_LUMPSUM_A_PAY := CP_MAN_TOTAL_LUMPSUM_A_PAY + L_OUTPUT_TAB(4).BALANCE_VALUE;
457 CP_MAN_TOTAL_LUMPSUM_B_PAY := CP_MAN_TOTAL_LUMPSUM_B_PAY + L_OUTPUT_TAB(5).BALANCE_VALUE;
458 CP_MAN_TOTAL_LUMPSUM_D_PAY := CP_MAN_TOTAL_LUMPSUM_D_PAY + L_OUTPUT_TAB(6).BALANCE_VALUE;
459 CP_MAN_TOTAL_LUMPSUM_E_PAY := CP_MAN_TOTAL_LUMPSUM_E_PAY + L_OUTPUT_TAB(7).BALANCE_VALUE;
460 CP_MAN_TOTAL_UNION_FEES := CP_MAN_TOTAL_UNION_FEES + L_OUTPUT_TAB(8).BALANCE_VALUE;
461 CP_MAN_TOTAL_TID := CP_MAN_TOTAL_TID + L_OUTPUT_TAB(9).BALANCE_VALUE;
462 CP_MAN_TOTAL_OTHER_INCOME := CP_MAN_TOTAL_OTHER_INCOME + L_OUTPUT_TAB(10).BALANCE_VALUE;
463 CP_MAN_TOTAL_WORKPLACE := CP_MAN_TOTAL_WORKPLACE + L_OUTPUT_TAB(18).BALANCE_VALUE;
464 IF (EMP_TYPE = 'T' AND L_OUTPUT_TAB(15).BALANCE_VALUE > 0) THEN
465 CP_MAN_TOTAL_ETP := CP_MAN_TOTAL_ETP + 1;
466 CP_MAN_TOTAL_PRE_JUL_83 := CP_MAN_TOTAL_PRE_JUL_83 + L_OUTPUT_TAB(12).BALANCE_VALUE;
467 CP_MAN_TOTAL_JUN_83_UNT := CP_MAN_TOTAL_JUN_83_UNT + L_OUTPUT_TAB(13).BALANCE_VALUE;
468 CP_MAN_TOTAL_JUN_94_INV := CP_MAN_TOTAL_JUN_94_INV + L_OUTPUT_TAB(14).BALANCE_VALUE;
469 CP_MAN_TOTAL_GROSS_ETP := CP_MAN_TOTAL_GROSS_ETP + L_OUTPUT_TAB(15).BALANCE_VALUE;
470 CP_MAN_TOTAL_ETP_TID := CP_MAN_TOTAL_ETP_TID + L_OUTPUT_TAB(16).BALANCE_VALUE;
471 CP_MAN_TOTAL_ASSESSABLE_INCOME := CP_MAN_TOTAL_ASSESSABLE_INCOME + L_OUTPUT_TAB(17).BALANCE_VALUE;
472 END IF;
473 END IF;
474 END IF;
475 RETURN (1);
476 END CF_CALC_TOTALSFORMULA;
477
478 FUNCTION AFTERREPORT RETURN BOOLEAN IS
479 BEGIN
480 DELETE FROM PAY_ASSIGNMENT_ACTIONS
481 WHERE PAYROLL_ACTION_ID = LP_PAYROLL_ACTION_ID;
482 DELETE FROM PAY_PAYROLL_ACTIONS
483 WHERE PAYROLL_ACTION_ID = LP_PAYROLL_ACTION_ID;
484 COMMIT;
485 RETURN (TRUE);
486 END AFTERREPORT;
487
488 FUNCTION CF_CALC_GROUP_TOTALSFORMULA RETURN NUMBER IS
489 CURSOR CSR_MAX_ASSGT_ACTION IS
490 SELECT
491 TO_NUMBER(SUBSTR(MAX(LPAD(PAA.ACTION_SEQUENCE
492 ,15
493 ,'0') || PAA.ASSIGNMENT_ACTION_ID)
494 ,16)) ASSIGNMENT_ACTION_ID
495 FROM
496 PAY_ASSIGNMENT_ACTIONS PAA,
497 PAY_PAYROLL_ACTIONS PPA
498 WHERE PAA.TAX_UNIT_ID = LP_REGISTERED_EMPLOYER
499 AND PAA.PAYROLL_ACTION_ID = PPA.PAYROLL_ACTION_ID
500 AND PPA.PAYROLL_ID = NVL(LP_PAYROLL_ID
501 ,PPA.PAYROLL_ID)
502 AND PAA.ASSIGNMENT_ID = NVL(LP_ASSIGNMENT_ID
503 ,PAA.ASSIGNMENT_ID)
504 AND PPA.EFFECTIVE_DATE BETWEEN CP_FIN_YR_START
505 AND CP_FIN_YR_END
506 AND PAA.ACTION_STATUS = 'C'
507 AND PPA.ACTION_STATUS = 'C'
508 AND PPA.ACTION_TYPE in ( 'R' , 'Q' , 'I' , 'V' , 'B' );
509 L_ASSIGNMENT_ACTION_ID PAY_ASSIGNMENT_ACTIONS.ASSIGNMENT_ACTION_ID%TYPE;
510 L_GROUP_OUTPUT_TAB PAY_AU_RECON_SUMMARY.BAL_TAB;
511 L_GROUP_ASSGT_OUTPUT_TAB PAY_AU_RECON_SUMMARY.BAL_TAB;
512 BEGIN
513 L_GROUP_OUTPUT_TAB.DELETE;
514 CP_ASSGT_COUNTER := CP_ASSGT_COUNTER + 1;
515 IF (CP_ASSGT_COUNTER = CP_ASSGT_TOTAL AND LP_EMPLOYEE_TYPE = '%' AND CP_DIMENSION < '_ASG_LE_YTD') THEN
516 OPEN CSR_MAX_ASSGT_ACTION;
517 FETCH CSR_MAX_ASSGT_ACTION
518 INTO
519 L_ASSIGNMENT_ACTION_ID;
520 CLOSE CSR_MAX_ASSGT_ACTION;
521 PAY_AU_RECON_SUMMARY.POPULATE_GROUP_DEF_BAL_IDS(P_DIMENSION_NAME => CP_DIMENSION);
522 PAY_AU_RECON_SUMMARY.GET_GROUP_VALUES_BBR(P_ASSIGNMENT_ACTION_ID => L_ASSIGNMENT_ACTION_ID
523 ,P_DATE_EARNED => CP_FIN_YR_END
524 ,P_TAX_UNIT_ID => LP_REGISTERED_EMPLOYER
525 ,P_GROUP_OUTPUT_TAB => L_GROUP_OUTPUT_TAB);
526 CP_TOTAL_LUMPSUM_A_PAY := L_GROUP_OUTPUT_TAB(1).BALANCE_VALUE;
527 CP_TOTAL_LUMPSUM_B_PAY := L_GROUP_OUTPUT_TAB(2).BALANCE_VALUE;
528 CP_TOTAL_LUMPSUM_D_PAY := L_GROUP_OUTPUT_TAB(3).BALANCE_VALUE;
529 CP_TOTAL_UNION_FEES := L_GROUP_OUTPUT_TAB(4).BALANCE_VALUE;
530 CP_TOTAL_TID := L_GROUP_OUTPUT_TAB(5).BALANCE_VALUE;
531 CP_TOTAL_CDEP := L_GROUP_OUTPUT_TAB(8).BALANCE_VALUE;
532 CP_TOTAL_OTHER_INCOME := L_GROUP_OUTPUT_TAB(9).BALANCE_VALUE;
533 CP_TOTAL_WORKPLACE := L_GROUP_OUTPUT_TAB(10).BALANCE_VALUE;
534 CP_TOTAL_GROSS := (L_GROUP_OUTPUT_TAB(6).BALANCE_VALUE + L_GROUP_OUTPUT_TAB(7).BALANCE_VALUE) + CP_TOTAL_WORKPLACE - (GREATEST(CP_TOTAL_ALLOWANCES
535 ,0) + CP_TOTAL_CDEP + CP_TOTAL_OTHER_INCOME + CP_TOTAL_LUMPSUM_E_PAY);
536 END IF;
537 IF (CP_ASSGT_COUNTER = CP_ASSGT_TOTAL) THEN
538 CP_TOTAL_STANDARD := CP_TOTAL_STANDARD - CP_MAN_TOTAL_STANDARD;
539 CP_TOTAL_CURRENT_EMPLOYEES := CP_TOTAL_CURRENT_EMPLOYEES - CP_MAN_TOTAL_CURR_EMPLOYEES;
540 CP_TOTAL_TERMINATED_EMPLOYEES := CP_TOTAL_TERMINATED_EMPLOYEES - CP_MAN_TOTAL_TERM_EMPLOYEES;
541 CP_TOTAL_GROSS := CP_TOTAL_GROSS - CP_MAN_TOTAL_GROSS;
542 CP_TOTAL_ALLOWANCES := CP_TOTAL_ALLOWANCES - CP_MAN_TOTAL_ALLOWANCES;
543 CP_TOTAL_RFB := CP_TOTAL_RFB - CP_MAN_TOTAL_RFB;
544 CP_TOTAL_CDEP := CP_TOTAL_CDEP - CP_MAN_TOTAL_CDEP;
545 CP_TOTAL_LUMPSUM_A_PAY := CP_TOTAL_LUMPSUM_A_PAY - CP_MAN_TOTAL_LUMPSUM_A_PAY;
546 CP_TOTAL_LUMPSUM_B_PAY := CP_TOTAL_LUMPSUM_B_PAY - CP_MAN_TOTAL_LUMPSUM_B_PAY;
547 CP_TOTAL_LUMPSUM_D_PAY := CP_TOTAL_LUMPSUM_D_PAY - CP_MAN_TOTAL_LUMPSUM_D_PAY;
548 CP_TOTAL_LUMPSUM_E_PAY := CP_TOTAL_LUMPSUM_E_PAY - CP_MAN_TOTAL_LUMPSUM_E_PAY;
549 CP_TOTAL_UNION_FEES := CP_TOTAL_UNION_FEES - CP_MAN_TOTAL_UNION_FEES;
550 CP_TOTAL_TID := CP_TOTAL_TID - CP_MAN_TOTAL_TID;
551 CP_TOTAL_OTHER_INCOME := CP_TOTAL_OTHER_INCOME - CP_MAN_TOTAL_OTHER_INCOME;
552 CP_TOTAL_ETP := CP_TOTAL_ETP - CP_MAN_TOTAL_ETP;
553 CP_TOTAL_PRE_JUL_83 := CP_TOTAL_PRE_JUL_83 - CP_MAN_TOTAL_PRE_JUL_83;
554 CP_TOTAL_JUN_83_UNT := CP_TOTAL_JUN_83_UNT - CP_MAN_TOTAL_JUN_83_UNT;
555 CP_TOTAL_JUN_83_TAX := CP_TOTAL_JUN_83_TAX - CP_MAN_TOTAL_JUN_83_TAX;
556 CP_TOTAL_JUN_94_INV := CP_TOTAL_JUN_94_INV - CP_MAN_TOTAL_JUN_94_INV;
557 CP_TOTAL_GROSS_ETP := CP_TOTAL_GROSS_ETP - CP_MAN_TOTAL_GROSS_ETP;
558 CP_TOTAL_ETP_TID := CP_TOTAL_ETP_TID - CP_MAN_TOTAL_ETP_TID;
559 CP_TOTAL_ASSESSABLE_INCOME := CP_TOTAL_ASSESSABLE_INCOME - CP_MAN_TOTAL_ASSESSABLE_INCOME;
560 CP_TOTAL_WORKPLACE := CP_TOTAL_WORKPLACE - CP_MAN_TOTAL_WORKPLACE;
561 END IF;
562 RETURN (1);
563 END CF_CALC_GROUP_TOTALSFORMULA;
564
565 FUNCTION MANUAL_PS_ISSUED_P RETURN VARCHAR2 IS
566 BEGIN
567 RETURN MANUAL_PS_ISSUED;
568 END MANUAL_PS_ISSUED_P;
569
570 FUNCTION CP_FIN_YR_START_P RETURN DATE IS
571 BEGIN
572 RETURN CP_FIN_YR_START;
573 END CP_FIN_YR_START_P;
574
575 FUNCTION CP_FIN_YR_END_P RETURN DATE IS
576 BEGIN
577 RETURN CP_FIN_YR_END;
578 END CP_FIN_YR_END_P;
579
580 FUNCTION CP_FBT_YR_START_P RETURN DATE IS
581 BEGIN
582 RETURN CP_FBT_YR_START;
583 END CP_FBT_YR_START_P;
584
585 FUNCTION CP_FBT_YR_END_P RETURN DATE IS
586 BEGIN
587 RETURN CP_FBT_YR_END;
588 END CP_FBT_YR_END_P;
589
590 FUNCTION CP_TOTAL_STANDARD_P RETURN NUMBER IS
591 BEGIN
592 RETURN CP_TOTAL_STANDARD;
593 END CP_TOTAL_STANDARD_P;
594
595 FUNCTION CP_TOTAL_ETP_P RETURN NUMBER IS
596 BEGIN
597 RETURN CP_TOTAL_ETP;
598 END CP_TOTAL_ETP_P;
599
600 FUNCTION CP_TOTAL_CURRENT_EMPLOYEES_P RETURN NUMBER IS
601 BEGIN
602 RETURN CP_TOTAL_CURRENT_EMPLOYEES;
603 END CP_TOTAL_CURRENT_EMPLOYEES_P;
604
605 --FUNCTION CP_TOTAL_TERMINATED_EMPLOYEES RETURN NUMBER IS
606 FUNCTION CP_TOTAL_TERMINATED_EMPLOY_P RETURN NUMBER IS
607 BEGIN
608 RETURN CP_TOTAL_TERMINATED_EMPLOYEES;
609 END CP_TOTAL_TERMINATED_EMPLOY_P;
610
611 FUNCTION CP_TOTAL_GROSS_P RETURN NUMBER IS
612 BEGIN
613 RETURN CP_TOTAL_GROSS;
614 END CP_TOTAL_GROSS_P;
615
616 FUNCTION CP_TOTAL_RFB_P RETURN NUMBER IS
617 BEGIN
618 RETURN CP_TOTAL_RFB;
619 END CP_TOTAL_RFB_P;
620
621 FUNCTION CP_TOTAL_LUMPSUM_A_PAY_P RETURN NUMBER IS
622 BEGIN
623 RETURN CP_TOTAL_LUMPSUM_A_PAY;
624 END CP_TOTAL_LUMPSUM_A_PAY_P;
625
626 FUNCTION CP_TOTAL_LUMPSUM_B_PAY_P RETURN NUMBER IS
627 BEGIN
628 RETURN CP_TOTAL_LUMPSUM_B_PAY;
629 END CP_TOTAL_LUMPSUM_B_PAY_P;
630
631 FUNCTION CP_TOTAL_LUMPSUM_D_PAY_P RETURN NUMBER IS
632 BEGIN
633 RETURN CP_TOTAL_LUMPSUM_D_PAY;
634 END CP_TOTAL_LUMPSUM_D_PAY_P;
635
636 FUNCTION CP_TOTAL_LUMPSUM_E_PAY_P RETURN NUMBER IS
637 BEGIN
638 RETURN CP_TOTAL_LUMPSUM_E_PAY;
639 END CP_TOTAL_LUMPSUM_E_PAY_P;
640
641 FUNCTION CP_TOTAL_UNION_FEES_P RETURN NUMBER IS
642 BEGIN
643 RETURN CP_TOTAL_UNION_FEES;
644 END CP_TOTAL_UNION_FEES_P;
645
646 FUNCTION CP_TOTAL_TID_P RETURN NUMBER IS
647 BEGIN
648 RETURN CP_TOTAL_TID;
649 END CP_TOTAL_TID_P;
650
651 FUNCTION CP_TOTAL_OTHER_INCOME_P RETURN NUMBER IS
652 BEGIN
653 RETURN CP_TOTAL_OTHER_INCOME;
654 END CP_TOTAL_OTHER_INCOME_P;
655
656 FUNCTION CP_TOTAL_PRE_JUL_83_P RETURN NUMBER IS
657 BEGIN
658 RETURN CP_TOTAL_PRE_JUL_83;
659 END CP_TOTAL_PRE_JUL_83_P;
660
661 FUNCTION CP_TOTAL_JUN_83_UNT_P RETURN NUMBER IS
662 BEGIN
663 RETURN CP_TOTAL_JUN_83_UNT;
664 END CP_TOTAL_JUN_83_UNT_P;
665
666 FUNCTION CP_TOTAL_JUN_83_TAX_P RETURN NUMBER IS
667 BEGIN
668 RETURN CP_TOTAL_JUN_83_TAX;
669 END CP_TOTAL_JUN_83_TAX_P;
670
671 FUNCTION CP_TOTAL_JUN_94_INV_P RETURN NUMBER IS
672 BEGIN
673 RETURN CP_TOTAL_JUN_94_INV;
674 END CP_TOTAL_JUN_94_INV_P;
675
676 FUNCTION CP_TOTAL_GROSS_ETP_P RETURN NUMBER IS
677 BEGIN
678 RETURN CP_TOTAL_GROSS_ETP;
679 END CP_TOTAL_GROSS_ETP_P;
680
681 FUNCTION CP_TOTAL_ETP_TID_P RETURN NUMBER IS
682 BEGIN
683 RETURN CP_TOTAL_ETP_TID;
684 END CP_TOTAL_ETP_TID_P;
685
686 FUNCTION CP_TOTAL_ASSESSABLE_INCOME_P RETURN NUMBER IS
687 BEGIN
688 RETURN CP_TOTAL_ASSESSABLE_INCOME;
689 END CP_TOTAL_ASSESSABLE_INCOME_P;
690
691 FUNCTION CP_TOTAL_ALLOWANCES_P RETURN NUMBER IS
692 BEGIN
693 RETURN CP_TOTAL_ALLOWANCES;
694 END CP_TOTAL_ALLOWANCES_P;
695
696 FUNCTION CP_TOTAL_CDEP_P RETURN NUMBER IS
697 BEGIN
698 RETURN CP_TOTAL_CDEP;
699 END CP_TOTAL_CDEP_P;
700
701 FUNCTION CP_FINANCIAL_YEAR_P RETURN VARCHAR2 IS
702 BEGIN
703 RETURN CP_FINANCIAL_YEAR;
704 END CP_FINANCIAL_YEAR_P;
705
706 FUNCTION CP_REG_EMP_P RETURN VARCHAR2 IS
707 BEGIN
708 RETURN CP_REG_EMP;
709 END CP_REG_EMP_P;
710
711 FUNCTION CP_PAYROLL_NAME_P RETURN VARCHAR2 IS
712 BEGIN
713 RETURN CP_PAYROLL_NAME;
714 END CP_PAYROLL_NAME_P;
715
716 FUNCTION CP_EMP_TYPE_P RETURN VARCHAR2 IS
717 BEGIN
718 RETURN CP_EMP_TYPE;
719 END CP_EMP_TYPE_P;
720
721 FUNCTION CP_ASSIGNMENT_NUMBER_P RETURN VARCHAR2 IS
722 BEGIN
723 RETURN CP_ASSIGNMENT_NUMBER;
724 END CP_ASSIGNMENT_NUMBER_P;
725
726 FUNCTION CP_FBT_GLOBAL_P RETURN VARCHAR2 IS
727 BEGIN
728 RETURN CP_FBT_GLOBAL;
729 END CP_FBT_GLOBAL_P;
730
731 FUNCTION CP_ML_GLOBAL_P RETURN VARCHAR2 IS
732 BEGIN
733 RETURN CP_ML_GLOBAL;
734 END CP_ML_GLOBAL_P;
735
736 FUNCTION CP_DIMENSION_P RETURN VARCHAR2 IS
737 BEGIN
738 RETURN CP_DIMENSION;
739 END CP_DIMENSION_P;
740
741 FUNCTION CP_ASSGT_COUNTER_P RETURN NUMBER IS
742 BEGIN
743 RETURN CP_ASSGT_COUNTER;
744 END CP_ASSGT_COUNTER_P;
745
746 FUNCTION CP_ASSGT_TOTAL_P RETURN NUMBER IS
747 BEGIN
748 RETURN CP_ASSGT_TOTAL;
749 END CP_ASSGT_TOTAL_P;
750
751 FUNCTION CP_LST_YR_START_P RETURN DATE IS
752 BEGIN
753 RETURN CP_LST_YR_START;
754 END CP_LST_YR_START_P;
755
756 FUNCTION CP_LST_YR_TERM_P RETURN VARCHAR2 IS
757 BEGIN
758 RETURN CP_LST_YR_TERM;
759 END CP_LST_YR_TERM_P;
760
761 FUNCTION CP_TOTAL_WORKPLACE_P RETURN NUMBER IS
762 BEGIN
763 RETURN CP_TOTAL_WORKPLACE;
764 END CP_TOTAL_WORKPLACE_P;
765
766 FUNCTION CP_MAN_TOTAL_STANDARD_P RETURN NUMBER IS
767 BEGIN
768 RETURN CP_MAN_TOTAL_STANDARD;
769 END CP_MAN_TOTAL_STANDARD_P;
770
771 FUNCTION CP_MAN_TOTAL_ETP_P RETURN NUMBER IS
772 BEGIN
773 RETURN CP_MAN_TOTAL_ETP;
774 END CP_MAN_TOTAL_ETP_P;
775
776 FUNCTION CP_MAN_TOTAL_CURR_EMPLOYEES_P RETURN NUMBER IS
777 BEGIN
778 RETURN CP_MAN_TOTAL_CURR_EMPLOYEES;
779 END CP_MAN_TOTAL_CURR_EMPLOYEES_P;
780
781 FUNCTION CP_MAN_TOTAL_TERM_EMPLOYEES_P RETURN NUMBER IS
782 BEGIN
783 RETURN CP_MAN_TOTAL_TERM_EMPLOYEES;
784 END CP_MAN_TOTAL_TERM_EMPLOYEES_P;
785
786 FUNCTION CP_MAN_TOTAL_GROSS_P RETURN NUMBER IS
787 BEGIN
788 RETURN CP_MAN_TOTAL_GROSS;
789 END CP_MAN_TOTAL_GROSS_P;
790
791 FUNCTION CP_MAN_TOTAL_RFB_P RETURN NUMBER IS
792 BEGIN
793 RETURN CP_MAN_TOTAL_RFB;
794 END CP_MAN_TOTAL_RFB_P;
795
796 FUNCTION CP_MAN_TOTAL_LUMPSUM_A_PAY_P RETURN NUMBER IS
797 BEGIN
798 RETURN CP_MAN_TOTAL_LUMPSUM_A_PAY;
799 END CP_MAN_TOTAL_LUMPSUM_A_PAY_P;
800
801 FUNCTION CP_MAN_TOTAL_LUMPSUM_B_PAY_P RETURN NUMBER IS
802 BEGIN
803 RETURN CP_MAN_TOTAL_LUMPSUM_B_PAY;
804 END CP_MAN_TOTAL_LUMPSUM_B_PAY_P;
805
806 FUNCTION CP_MAN_TOTAL_LUMPSUM_D_PAY_P RETURN NUMBER IS
807 BEGIN
808 RETURN CP_MAN_TOTAL_LUMPSUM_D_PAY;
809 END CP_MAN_TOTAL_LUMPSUM_D_PAY_P;
810
811 FUNCTION CP_MAN_TOTAL_LUMPSUM_E_PAY_P RETURN NUMBER IS
812 BEGIN
813 RETURN CP_MAN_TOTAL_LUMPSUM_E_PAY;
814 END CP_MAN_TOTAL_LUMPSUM_E_PAY_P;
815
816 FUNCTION CP_MAN_TOTAL_UNION_FEES_P RETURN NUMBER IS
817 BEGIN
818 RETURN CP_MAN_TOTAL_UNION_FEES;
819 END CP_MAN_TOTAL_UNION_FEES_P;
820
821 FUNCTION CP_MAN_TOTAL_TID_P RETURN NUMBER IS
822 BEGIN
823 RETURN CP_MAN_TOTAL_TID;
824 END CP_MAN_TOTAL_TID_P;
825
826 FUNCTION CP_MAN_TOTAL_OTHER_INCOME_P RETURN NUMBER IS
827 BEGIN
828 RETURN CP_MAN_TOTAL_OTHER_INCOME;
829 END CP_MAN_TOTAL_OTHER_INCOME_P;
830
831 FUNCTION CP_MAN_TOTAL_PRE_JUL_83_P RETURN NUMBER IS
832 BEGIN
833 RETURN CP_MAN_TOTAL_PRE_JUL_83;
834 END CP_MAN_TOTAL_PRE_JUL_83_P;
835
836 FUNCTION CP_MAN_TOTAL_JUN_83_UNT_P RETURN NUMBER IS
837 BEGIN
838 RETURN CP_MAN_TOTAL_JUN_83_UNT;
839 END CP_MAN_TOTAL_JUN_83_UNT_P;
840
841 FUNCTION CP_MAN_TOTAL_JUN_83_TAX_P RETURN NUMBER IS
842 BEGIN
843 RETURN CP_MAN_TOTAL_JUN_83_TAX;
844 END CP_MAN_TOTAL_JUN_83_TAX_P;
845
846 FUNCTION CP_MAN_TOTAL_JUN_94_INV_P RETURN NUMBER IS
847 BEGIN
848 RETURN CP_MAN_TOTAL_JUN_94_INV;
849 END CP_MAN_TOTAL_JUN_94_INV_P;
850
851 FUNCTION CP_MAN_TOTAL_GROSS_ETP_P RETURN NUMBER IS
852 BEGIN
853 RETURN CP_MAN_TOTAL_GROSS_ETP;
854 END CP_MAN_TOTAL_GROSS_ETP_P;
855
856 FUNCTION CP_MAN_TOTAL_ETP_TID_P RETURN NUMBER IS
857 BEGIN
858 RETURN CP_MAN_TOTAL_ETP_TID;
859 END CP_MAN_TOTAL_ETP_TID_P;
860
861 FUNCTION CP_MAN_TOTAL_ASSESSABLE_INCOM RETURN NUMBER IS
862 BEGIN
863 RETURN CP_MAN_TOTAL_ASSESSABLE_INCOME;
864 END CP_MAN_TOTAL_ASSESSABLE_INCOM;
865
866 FUNCTION CP_MAN_TOTAL_ALLOWANCES_P RETURN NUMBER IS
867 BEGIN
868 RETURN CP_MAN_TOTAL_ALLOWANCES;
869 END CP_MAN_TOTAL_ALLOWANCES_P;
870
871 FUNCTION CP_MAN_TOTAL_CDEP_P RETURN NUMBER IS
872 BEGIN
873 RETURN CP_MAN_TOTAL_CDEP;
874 END CP_MAN_TOTAL_CDEP_P;
875
876 FUNCTION CP_MAN_TOTAL_WORKPLACE_P RETURN NUMBER IS
877 BEGIN
878 RETURN CP_MAN_TOTAL_WORKPLACE;
879 END CP_MAN_TOTAL_WORKPLACE_P;
880
881 END PAY_PYAURECP_XMLP_PKG;