1 PACKAGE BODY PAY_PAYAUSOE_XMLP_PKG AS
2 /* $Header: PAYAUSOEB.pls 120.2 2011/04/20 04:54:14 jmarupil ship $ */
3 FUNCTION AFTERREPORT RETURN BOOLEAN IS
4 BEGIN
5 RETURN (TRUE);
6 END AFTERREPORT;
7
8 FUNCTION BEFOREREPORT RETURN BOOLEAN IS
9 BEGIN
10 CONSTRUCT_WHERE_CLAUSE;
11 CONSTRUCT_ORDER_BY;
12 PAY_AU_SOE_PKG.POPULATE_DEFINED_BALANCES;
13 P_CONC_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
14 RETURN (TRUE);
15 END BEFOREREPORT;
16
17 FUNCTION CF_CURRENCY_FORMAT_MASKFORMULA RETURN VARCHAR2 IS
18 V_CURRENCY_CODE FND_CURRENCIES.CURRENCY_CODE%TYPE;
19 V_FORMAT_MASK VARCHAR2(100) := NULL;
20 V_FIELD_LENGTH NUMBER(3) := 15;
21 LV_DATE_EARNED PAY_PAYROLL_ACTIONS.DATE_EARNED%TYPE;
22 CURSOR C_DATE_EARNED(PAYROLL_ACT_ID IN PAY_PAYROLL_ACTIONS.PAYROLL_ACTION_ID%TYPE) IS
23 SELECT
24 EFFECTIVE_DATE
25 FROM
26 PAY_PAYROLL_ACTIONS
27 WHERE PAYROLL_ACTION_ID = PAYROLL_ACT_ID;
28 BEGIN
29 OPEN C_DATE_EARNED(P_PAYROLL_ACTION_ID);
30 FETCH C_DATE_EARNED
31 INTO LV_DATE_EARNED;
32 CLOSE C_DATE_EARNED;
33 V_CURRENCY_CODE := PAY_AU_SOE_PKG.GET_CURRENCY_CODE(P_BUSINESS_GROUP_ID
34 ,P_PAYROLL_ID
35 ,LV_DATE_EARNED);
36 /* V_CURRENCY_CODE := PAY_AU_SOE_PKG.BUSINESS_CURRENCY_CODE(P_BUSINESS_GROUP_ID);*/
37 V_FORMAT_MASK := FND_CURRENCY.GET_FORMAT_MASK(V_CURRENCY_CODE
38 ,V_FIELD_LENGTH);
39 RETURN V_FORMAT_MASK;
40 END CF_CURRENCY_FORMAT_MASKFORMULA;
41
42 FUNCTION CF_NET_ACCRUALFORMULA(LEAVE_BALANCE_ABSENCE_TYPE IN VARCHAR2
43 ,ASSIGNMENT_ACTION_ID_LB IN NUMBER
44 ,ASSIGNMENT_ID_LB IN NUMBER
45 ,PAYROLL_ID_LB IN NUMBER
46 ,BUSINESS_GROUP_ID_LB IN NUMBER
47 ,ACCRUAL_PLAN_ID_LB IN NUMBER
48 ,PERIOD_END_DATE IN DATE) RETURN NUMBER IS
49 V_CUMULATIVE_BALANCE NUMBER := NULL;
50 CURSOR C_GET_NET_ACCRUAL(R_ASG_ASSIGNMENT_ACTION_ID IN NUMBER) IS
51 SELECT
52 1
53 FROM
54 PAY_ACCRUAL_PLANS AP,
55 PAY_ELEMENT_TYPES_F ET,
56 PAY_ELEMENT_LINKS_F EL,
57 PAY_ELEMENT_ENTRIES_F EE,
58 PAY_ASSIGNMENT_ACTIONS AA,
59 PAY_PAYROLL_ACTIONS PA,
60 PER_ABSENCE_ATTENDANCE_TYPES PAAT,
61 PER_TIME_PERIODS TP
62 WHERE AA.ASSIGNMENT_ACTION_ID = R_ASG_ASSIGNMENT_ACTION_ID
63 AND AP.ACCRUAL_CATEGORY = 'AUAL'
64 AND ET.ELEMENT_TYPE_ID = AP.ACCRUAL_PLAN_ELEMENT_TYPE_ID
65 AND EL.ELEMENT_TYPE_ID = ET.ELEMENT_TYPE_ID
66 AND EE.ELEMENT_LINK_ID = EL.ELEMENT_LINK_ID
67 AND AA.ASSIGNMENT_ID = EE.ASSIGNMENT_ID
68 AND PA.PAYROLL_ACTION_ID = AA.PAYROLL_ACTION_ID
69 AND TP.PAYROLL_ID = PA.PAYROLL_ID
70 AND PAAT.INPUT_VALUE_ID = AP.PTO_INPUT_VALUE_ID
71 AND PA.EFFECTIVE_DATE between TP.START_DATE
72 AND TP.END_DATE
73 AND PAAT.ABSENCE_ATTENDANCE_TYPE_ID = (
74 SELECT
75 MAX(PAAT1.ABSENCE_ATTENDANCE_TYPE_ID)
76 FROM
77 PER_ABSENCE_ATTENDANCE_TYPES PAAT1
78 WHERE PAAT1.INPUT_VALUE_ID = AP.PTO_INPUT_VALUE_ID )
79 AND PA.EFFECTIVE_DATE between ET.EFFECTIVE_START_DATE
80 AND ET.EFFECTIVE_END_DATE
81 AND PA.EFFECTIVE_DATE between EL.EFFECTIVE_START_DATE
82 AND EL.EFFECTIVE_END_DATE
83 AND PA.EFFECTIVE_DATE between EE.EFFECTIVE_START_DATE
84 AND EE.EFFECTIVE_END_DATE;
85 L_DUMMY NUMBER;
86 BEGIN
87 IF LEAVE_BALANCE_ABSENCE_TYPE IS NOT NULL THEN
88 CP_ACCRUAL := 0;
89 OPEN C_GET_NET_ACCRUAL(ASSIGNMENT_ACTION_ID_LB);
90 FETCH C_GET_NET_ACCRUAL
91 INTO
92 L_DUMMY;
93 IF C_GET_NET_ACCRUAL%FOUND THEN
94
95 CP_ACCRUAL := NVL(HR_AU_HOLIDAYS.GET_NET_ACCRUAL(ASSIGNMENT_ID_LB
96 ,PAYROLL_ID_LB
97 ,BUSINESS_GROUP_ID_LB
98 ,ACCRUAL_PLAN_ID_LB
99 ,PERIOD_END_DATE)
100 ,0);
101
102 END IF;
103 CLOSE C_GET_NET_ACCRUAL;
104 END IF;
105 RETURN V_CUMULATIVE_BALANCE;
106 END CF_NET_ACCRUALFORMULA;
107
108 PROCEDURE CONSTRUCT_WHERE_CLAUSE IS
109 BEGIN
110 --CP_WHERE_CLAUSE := NULL;
111 CP_WHERE_CLAUSE := ' ';
112 IF P_ASSIGNMENT_ID IS NOT NULL THEN
113 CP_WHERE_CLAUSE := ' and assignment_id = ' || TO_CHAR(P_ASSIGNMENT_ID);
114 END IF;
115 IF P_LOCATION_ID IS NOT NULL THEN
116 CP_WHERE_CLAUSE := CP_WHERE_CLAUSE || ' and location_id = ' || TO_CHAR(P_LOCATION_ID);
117 END IF;
118 IF P_ORGANISATION_NAME IS NOT NULL THEN
119 CP_WHERE_CLAUSE := CP_WHERE_CLAUSE || ' and organization_name = ' || '''' || P_ORGANISATION_NAME || '''';
120 END IF;
121 END CONSTRUCT_WHERE_CLAUSE;
122
123 PROCEDURE CONSTRUCT_ORDER_BY IS
124 L_SORT_ORDER_1 VARCHAR2(250);
125 L_SORT_ORDER_2 VARCHAR2(250);
126 L_SORT_ORDER_3 VARCHAR2(250);
127 L_SORT_ORDER_4 VARCHAR2(250);
128 BEGIN
129 CP_ORDER_BY := NULL;
130 IF P_SORT_ORDER_1 = 'FULL_NAME' THEN
131 L_SORT_ORDER_1 := 'nvl(order_name,full_name)';
132 ELSE
133 L_SORT_ORDER_1 := P_SORT_ORDER_1;
134 END IF;
135 IF P_SORT_ORDER_2 = 'FULL_NAME' THEN
136 L_SORT_ORDER_2 := 'nvl(order_name,full_name)';
137 ELSE
138 L_SORT_ORDER_2 := P_SORT_ORDER_2;
139 END IF;
140 IF P_SORT_ORDER_3 = 'FULL_NAME' THEN
141 L_SORT_ORDER_3 := 'nvl(order_name,full_name)';
142 ELSE
143 L_SORT_ORDER_3 := P_SORT_ORDER_3;
144 END IF;
145 IF P_SORT_ORDER_4 = 'FULL_NAME' THEN
146 L_SORT_ORDER_4 := 'nvl(order_name,full_name)';
147 ELSE
148 L_SORT_ORDER_4 := P_SORT_ORDER_4;
149 END IF;
150 IF P_SORT_ORDER_1 IS NOT NULL THEN
151 CP_ORDER_BY := L_SORT_ORDER_1;
152 END IF;
153 IF P_SORT_ORDER_2 IS NOT NULL THEN
154 IF CP_ORDER_BY IS NOT NULL THEN
155 CP_ORDER_BY := CP_ORDER_BY || ', ' || L_SORT_ORDER_2;
156 ELSE
157 CP_ORDER_BY := L_SORT_ORDER_2;
158 END IF;
159 END IF;
160 IF P_SORT_ORDER_3 IS NOT NULL THEN
161 IF CP_ORDER_BY IS NOT NULL THEN
162 CP_ORDER_BY := CP_ORDER_BY || ', ' || L_SORT_ORDER_3;
163 ELSE
164 CP_ORDER_BY := L_SORT_ORDER_3;
165 END IF;
166 END IF;
167 IF P_SORT_ORDER_4 IS NOT NULL THEN
168 IF CP_ORDER_BY IS NOT NULL THEN
169 CP_ORDER_BY := CP_ORDER_BY || ', ' || L_SORT_ORDER_4;
170 ELSE
171 CP_ORDER_BY := L_SORT_ORDER_4;
172 END IF;
173 END IF;
174 IF CP_ORDER_BY IS NOT NULL THEN
175 CP_ORDER_BY := ' order by ' || CP_ORDER_BY;
176 ELSE
177 CP_ORDER_BY := ' order by assignment_number';
178 END IF;
179 END CONSTRUCT_ORDER_BY;
180
181 FUNCTION CF_NET_THIS_PAYFORMULA RETURN NUMBER IS
182 BEGIN
183 RETURN (CP_GROSS_THIS_PAY - CP_PRE_TAX_DEDUCTIONS_THIS_PAY - CP_OTHER_DEDUCTIONS_THIS_PAY - CP_TAX_DEDUCTIONS_THIS_PAY + CP_DIRECT_PAYMENTS_THIS_PAY);
184 END CF_NET_THIS_PAYFORMULA;
185
186 FUNCTION CF_NET_YTDFORMULA RETURN NUMBER IS
187 BEGIN
188 RETURN (CP_GROSS_YTD - CP_PRE_TAX_DEDUCTIONS_YTD - CP_OTHER_DEDUCTIONS_YTD - CP_TAX_DEDUCTIONS_YTD + CP_DIRECT_PAYMENTS_YTD);
189 END CF_NET_YTDFORMULA;
190
191 FUNCTION CF_GET_MISCELLANEOUS_VALUESFOR(EXPENSE_CHECK_SEND_TO_ADDRESS IN VARCHAR2
192 ,PERSON_ID IN NUMBER
193 ,LOCATION_ID IN NUMBER
194 ,ASSIGNMENT_ID IN NUMBER
195 ,ASSIGNMENT_ACTION_ID IN NUMBER
196 ,DATE_EARNED IN DATE) RETURN NUMBER IS
197 V_ADDRESS_LINE_1 HR_LOCATIONS.ADDRESS_LINE_1%TYPE;
198 V_ADDRESS_LINE_2 HR_LOCATIONS.ADDRESS_LINE_2%TYPE;
199 V_ADDRESS_LINE_3 HR_LOCATIONS.ADDRESS_LINE_3%TYPE;
200 V_TOWN_CITY HR_LOCATIONS.TOWN_OR_CITY%TYPE;
201 V_POSTAL_CODE HR_LOCATIONS.POSTAL_CODE%TYPE;
202 V_COUNTRY FND_TERRITORIES_TL.TERRITORY_SHORT_NAME%TYPE;
203 V_SUPER_THIS_PAY NUMBER;
204 V_SUPER_YTD NUMBER;
205 BEGIN
206 IF EXPENSE_CHECK_SEND_TO_ADDRESS = 'H' THEN
207 PAY_AU_SOE_PKG.GET_HOME_ADDRESS(PERSON_ID
208 ,V_ADDRESS_LINE_1
209 ,V_ADDRESS_LINE_2
210 ,V_ADDRESS_LINE_3
211 ,V_TOWN_CITY
212 ,V_POSTAL_CODE
213 ,V_COUNTRY);
214 ELSE
215 PAY_AU_SOE_PKG.GET_WORK_ADDRESS(LOCATION_ID
216 ,V_ADDRESS_LINE_1
217 ,V_ADDRESS_LINE_2
218 ,V_ADDRESS_LINE_3
219 ,V_TOWN_CITY
220 ,V_POSTAL_CODE
221 ,V_COUNTRY);
222 END IF;
223 CP_ADDRESS_LINE_1 := SUBSTR(V_ADDRESS_LINE_1
224 ,1
225 ,60);
226 CP_ADDRESS_LINE_2 := SUBSTR(V_ADDRESS_LINE_2
227 ,1
228 ,60);
229 CP_ADDRESS_LINE_3 := SUBSTR(V_ADDRESS_LINE_3
230 ,1
231 ,60);
232 CP_TOWN_CITY := V_TOWN_CITY;
233 CP_POSTAL_CODE := V_POSTAL_CODE;
234 CP_COUNTRY := V_COUNTRY;
235 PAY_AU_SOE_PKG.FINAL_BALANCE_TOTALS(ASSIGNMENT_ID
236 ,ASSIGNMENT_ACTION_ID
237 ,DATE_EARNED
238 ,CP_GROSS_THIS_PAY
239 ,CP_OTHER_DEDUCTIONS_THIS_PAY
240 ,CP_TAX_DEDUCTIONS_THIS_PAY
241 ,CP_GROSS_YTD
242 ,CP_OTHER_DEDUCTIONS_YTD
243 ,CP_TAX_DEDUCTIONS_YTD
244 ,CP_NON_TAX_ALLOW_THIS_PAY
245 ,CP_NON_TAX_ALLOW_YTD
246 ,CP_PRE_TAX_DEDUCTIONS_THIS_PAY
247 ,CP_PRE_TAX_DEDUCTIONS_YTD
248 ,V_SUPER_THIS_PAY
249 ,V_SUPER_YTD
250 ,CP_TAXABLE_INCOME_THIS_PAY
251 ,CP_TAXABLE_INCOME_YTD
252 ,CP_DIRECT_PAYMENTS_THIS_PAY
253 ,CP_DIRECT_PAYMENTS_YTD
254 ,'Y'
255 ,'N');
256 RETURN 0;
257 END CF_GET_MISCELLANEOUS_VALUESFOR;
258
259 FUNCTION CF_HOURS_FORMAT_MASKFORMULA RETURN CHAR IS
260 BEGIN
261 RETURN '99G990D00';
262 END CF_HOURS_FORMAT_MASKFORMULA;
263
264 FUNCTION CF_CHANGE_PRINT_MESSAGESFORMUL(PAY_ADVICE_MESSAGE IN VARCHAR2) RETURN NUMBER IS
265 BEGIN
266 SET_PRINT_FLAGS;
267 IF PAY_ADVICE_MESSAGE IS NOT NULL THEN
268 PRINT_MESSAGES := 'Y';
269 ELSE
270 PRINT_MESSAGES := 'N';
271 END IF;
272 RETURN 0;
273 END CF_CHANGE_PRINT_MESSAGESFORMUL;
274
275 FUNCTION CF_CHANGE_PRINT_LEAVE_TAKENFOR RETURN NUMBER IS
276 BEGIN
277 PRINT_LEAVE_TAKEN := 'Y';
278 RETURN 0;
279 END CF_CHANGE_PRINT_LEAVE_TAKENFOR;
280
281 FUNCTION CF_CHANGE_PRINT_LEAVE_BALANCES RETURN NUMBER IS
282 BEGIN
283 PRINT_LEAVE_BALANCES := 'Y';
284 RETURN 0;
285 END CF_CHANGE_PRINT_LEAVE_BALANCES;
286
287 PROCEDURE SET_PRINT_FLAGS IS
288 BEGIN
289 PRINT_LEAVE_TAKEN := 'N';
290 PRINT_LEAVE_BALANCES := 'N';
291 PRINT_MESSAGES := 'N';
292 END SET_PRINT_FLAGS;
293
294 --FUNCTION CF_PERIOD_START_DATEFORMULA(ASSIGNMENT_ACTION_ID IN NUMBER) RETURN DATE IS
295 FUNCTION CF_PERIOD_START_DATEFORMULA(ASSIGNMENT_ACTION_ID_V IN NUMBER) RETURN DATE IS
296 CURSOR GET_PERIOD_START_DATE IS
297 SELECT
298 PTP.START_DATE
299 FROM
300 PAY_ASSIGNMENT_ACTIONS PAC,
301 PAY_PAYROLL_ACTIONS PPA,
302 PER_TIME_PERIODS PTP
303 WHERE PPA.PAYROLL_ACTION_ID = PAC.PAYROLL_ACTION_ID
304 AND PAC.SOURCE_ACTION_ID is null
305 AND PTP.PAYROLL_ID = PPA.PAYROLL_ID
306 AND PPA.DATE_EARNED between PTP.START_DATE
307 AND PTP.END_DATE
308 AND PAC.ASSIGNMENT_ACTION_ID = (
309 SELECT
310 MIN(PAI.LOCKED_ACTION_ID)
311 FROM
312 PAY_ACTION_INTERLOCKS PAI
313 WHERE PAI.LOCKING_ACTION_ID = ASSIGNMENT_ACTION_ID_V );
314 V_PERIOD_START_DATE DATE;
315 BEGIN
316 OPEN GET_PERIOD_START_DATE;
317 FETCH GET_PERIOD_START_DATE
318 INTO
319 V_PERIOD_START_DATE;
320 CLOSE GET_PERIOD_START_DATE;
321
322 RETURN V_PERIOD_START_DATE;
323 END CF_PERIOD_START_DATEFORMULA;
324 FUNCTION CF_GRADE_STEPFORMULA(ASSIGNMENT_ID IN NUMBER
325 ,DATE_EARNED IN DATE) RETURN NUMBER IS
326 L_GRADE_STEP NUMBER;
327 BEGIN
328 L_GRADE_STEP := NULL;
329 SELECT
330 count(*)
331 INTO L_GRADE_STEP
332 FROM
333 PER_SPINAL_POINT_STEPS_F PSP,
334 PER_SPINAL_POINT_PLACEMENTS_F PSPP,
335 PER_SPINAL_POINT_STEPS_F PSP2
336 WHERE PSP.SEQUENCE >= PSP2.SEQUENCE
337 AND PSPP.STEP_ID = PSP.STEP_ID
338 AND PSPP.ASSIGNMENT_ID = CF_GRADE_STEPFORMULA.ASSIGNMENT_ID
339 AND PSP.GRADE_SPINE_ID = PSP2.GRADE_SPINE_ID
340 AND PSPP.BUSINESS_GROUP_ID = P_BUSINESS_GROUP_ID
341 AND PSP.BUSINESS_GROUP_ID = P_BUSINESS_GROUP_ID
342 AND PSP2.BUSINESS_GROUP_ID = P_BUSINESS_GROUP_ID
343 AND CF_GRADE_STEPFORMULA.DATE_EARNED between PSP.EFFECTIVE_START_DATE
344 AND PSP.EFFECTIVE_END_DATE
345 AND CF_GRADE_STEPFORMULA.DATE_EARNED between PSPP.EFFECTIVE_START_DATE
346 AND PSPP.EFFECTIVE_END_DATE
347 AND CF_GRADE_STEPFORMULA.DATE_EARNED between PSP2.EFFECTIVE_START_DATE
348 AND PSP2.EFFECTIVE_END_DATE;
349
350 IF (L_GRADE_STEP IS NULL OR L_GRADE_STEP = 0) THEN
351 RETURN (NULL);
352 ELSE
353 RETURN (L_GRADE_STEP);
354 END IF;
355 END CF_GRADE_STEPFORMULA;
356
357 FUNCTION CP_ADDRESS_LINE_1_P RETURN VARCHAR2 IS
358 BEGIN
359 RETURN CP_ADDRESS_LINE_1;
360 END CP_ADDRESS_LINE_1_P;
361
362 FUNCTION CP_ADDRESS_LINE_2_P RETURN VARCHAR2 IS
363 BEGIN
364 RETURN CP_ADDRESS_LINE_2;
365 END CP_ADDRESS_LINE_2_P;
366
367 FUNCTION CP_ADDRESS_LINE_3_P RETURN VARCHAR2 IS
368 BEGIN
369 RETURN CP_ADDRESS_LINE_3;
370 END CP_ADDRESS_LINE_3_P;
371
372 FUNCTION CP_POSTAL_CODE_P RETURN VARCHAR2 IS
373 BEGIN
374 RETURN CP_POSTAL_CODE;
375 END CP_POSTAL_CODE_P;
376
377 FUNCTION CP_TOWN_CITY_P RETURN VARCHAR2 IS
378 BEGIN
379 RETURN CP_TOWN_CITY;
380 END CP_TOWN_CITY_P;
381
382 FUNCTION CP_COUNTRY_P RETURN VARCHAR2 IS
383 BEGIN
384 RETURN CP_COUNTRY;
385 END CP_COUNTRY_P;
386
387 FUNCTION CP_PRE_TAX_DEDUCTIONS_THIS_PA RETURN NUMBER IS
388 BEGIN
389 RETURN CP_PRE_TAX_DEDUCTIONS_THIS_PAY;
390 END CP_PRE_TAX_DEDUCTIONS_THIS_PA;
391
392 FUNCTION CP_DIRECT_PAYMENTS_YTD_P RETURN NUMBER IS
393 BEGIN
394 RETURN CP_DIRECT_PAYMENTS_YTD;
395 END CP_DIRECT_PAYMENTS_YTD_P;
396
397 FUNCTION CP_TAXABLE_INCOME_YTD_P RETURN NUMBER IS
398 BEGIN
399 RETURN CP_TAXABLE_INCOME_YTD;
400 END CP_TAXABLE_INCOME_YTD_P;
401
402 FUNCTION CP_DIRECT_PAYMENTS_THIS_PAY_P RETURN NUMBER IS
403 BEGIN
404 RETURN CP_DIRECT_PAYMENTS_THIS_PAY;
405 END CP_DIRECT_PAYMENTS_THIS_PAY_P;
406
407 FUNCTION CP_TAXABLE_INCOME_THIS_PAY_P RETURN NUMBER IS
408 BEGIN
409 RETURN CP_TAXABLE_INCOME_THIS_PAY;
410 END CP_TAXABLE_INCOME_THIS_PAY_P;
411
412 FUNCTION CP_PRE_TAX_DEDUCTIONS_YTD_P RETURN NUMBER IS
413 BEGIN
414 RETURN CP_PRE_TAX_DEDUCTIONS_YTD;
415 END CP_PRE_TAX_DEDUCTIONS_YTD_P;
416
417 FUNCTION CP_NON_TAX_ALLOW_YTD_P RETURN NUMBER IS
418 BEGIN
419 RETURN CP_NON_TAX_ALLOW_YTD;
420 END CP_NON_TAX_ALLOW_YTD_P;
421
422 FUNCTION CP_GROSS_THIS_PAY_P RETURN NUMBER IS
423 BEGIN
424 RETURN CP_GROSS_THIS_PAY;
425 END CP_GROSS_THIS_PAY_P;
426
427 FUNCTION CP_NON_TAX_ALLOW_THIS_PAY_P RETURN NUMBER IS
428 BEGIN
429 RETURN CP_NON_TAX_ALLOW_THIS_PAY;
430 END CP_NON_TAX_ALLOW_THIS_PAY_P;
431
432 FUNCTION CP_OTHER_DEDUCTIONS_THIS_PAY_P RETURN NUMBER IS
433 BEGIN
434 RETURN CP_OTHER_DEDUCTIONS_THIS_PAY;
435 END CP_OTHER_DEDUCTIONS_THIS_PAY_P;
436
437 FUNCTION CP_TAX_DEDUCTIONS_THIS_PAY_P RETURN NUMBER IS
438 BEGIN
439 RETURN CP_TAX_DEDUCTIONS_THIS_PAY;
440 END CP_TAX_DEDUCTIONS_THIS_PAY_P;
441
442 FUNCTION CP_GROSS_YTD_P RETURN NUMBER IS
443 BEGIN
444 RETURN CP_GROSS_YTD;
445 END CP_GROSS_YTD_P;
446
447 FUNCTION CP_OTHER_DEDUCTIONS_YTD_P RETURN NUMBER IS
448 BEGIN
449 RETURN CP_OTHER_DEDUCTIONS_YTD;
450 END CP_OTHER_DEDUCTIONS_YTD_P;
451
452 FUNCTION CP_TAX_DEDUCTIONS_YTD_P RETURN NUMBER IS
453 BEGIN
454 RETURN CP_TAX_DEDUCTIONS_YTD;
455 END CP_TAX_DEDUCTIONS_YTD_P;
456
457 FUNCTION CP_START_DATE_P RETURN DATE IS
458 BEGIN
459 RETURN CP_START_DATE;
460 END CP_START_DATE_P;
461
462 FUNCTION CP_END_DATE_P RETURN DATE IS
463 BEGIN
464 RETURN CP_END_DATE;
465 END CP_END_DATE_P;
466
467 FUNCTION CP_ACCRUAL_END_DATE_P RETURN DATE IS
468 BEGIN
469 RETURN CP_ACCRUAL_END_DATE;
470 END CP_ACCRUAL_END_DATE_P;
471
472 FUNCTION CP_ACCRUAL_P RETURN NUMBER IS
473 BEGIN
474 RETURN CP_ACCRUAL;
475 END CP_ACCRUAL_P;
476
477 FUNCTION CP_NET_ENTITLEMENT_P RETURN NUMBER IS
481
478 BEGIN
479 RETURN CP_NET_ENTITLEMENT;
480 END CP_NET_ENTITLEMENT_P;
482 FUNCTION CP_WHERE_CLAUSE_P RETURN VARCHAR2 IS
483 BEGIN
484 RETURN CP_WHERE_CLAUSE;
485 END CP_WHERE_CLAUSE_P;
486
487 FUNCTION CP_ORDER_BY_P RETURN VARCHAR2 IS
488 BEGIN
489 RETURN CP_ORDER_BY;
490 END CP_ORDER_BY_P;
491
492 /* Bug 11833361 - To remove duplicate payment Records */
493
494 FUNCTION CF_EFECTIVE_DATEFORMULA(ASSIGNMENT_ACTION_ID IN NUMBER) RETURN DATE is
495 BEGIN
496
497 CF_EFFECTIVE_DATE := pay_au_soe_pkg.get_effective_date(ASSIGNMENT_ACTION_ID);
498
499 RETURN CF_EFFECTIVE_DATE;
500 END;
501
502
503 END PAY_PAYAUSOE_XMLP_PKG;