1 PACKAGE BODY PAY_PAYGBTPL_XMLP_PKG AS
2 /* $Header: PAYGBTPLB.pls 120.0 2008/01/07 15:34:31 srikrish noship $ */
3 FUNCTION BEFOREREPORT RETURN BOOLEAN IS
4 L_PROC_PTD_DIM NUMBER;
5 P_PERIOD_NAME VARCHAR2(60);
6 P_START_DATE DATE;
7 P_END_DATE DATE;
8 CURSOR INPUT_VALUES IS
9 SELECT
10 PIV_SCON.INPUT_VALUE_ID SCON_IV,
11 PIV_CAT.INPUT_VALUE_ID CAT_IV,
12 PET.ELEMENT_TYPE_ID
13 FROM
14 PAY_INPUT_VALUES_F PIV_SCON,
15 PAY_INPUT_VALUES_F PIV_CAT,
16 PAY_ELEMENT_TYPES_F PET
17 WHERE PET.ELEMENT_NAME = 'NI'
18 AND PET.LEGISLATION_CODE = 'GB'
19 AND PIV_SCON.NAME = 'SCON'
20 AND PET.LEGISLATION_CODE = PIV_SCON.LEGISLATION_CODE
21 AND PIV_SCON.ELEMENT_TYPE_ID = PET.ELEMENT_TYPE_ID
22 AND PIV_CAT.NAME = 'Category'
23 AND PET.LEGISLATION_CODE = PIV_CAT.LEGISLATION_CODE
24 AND PIV_CAT.ELEMENT_TYPE_ID = PET.ELEMENT_TYPE_ID;
25 BEGIN
26 BEGIN
27 --HR_STANDARD.EVENT('BEFORE REPORT');
28 NULL;
29 EXCEPTION
30 WHEN NO_DATA_FOUND THEN
31 NULL;
32 END;
33 BEGIN
34 SELECT
35 TO_DATE('06-04-' || TO_CHAR(TO_NUMBER(TO_CHAR(PTP.REGULAR_PAYMENT_DATE
36 ,'YYYY')) + DECODE(SIGN(PTP.REGULAR_PAYMENT_DATE - TO_DATE('06-04-' || TO_CHAR(PTP.REGULAR_PAYMENT_DATE
37 ,'YYYY')
38 ,'DD-MM-YYYY'))
39 ,-1
40 ,-1
41 ,0))
42 ,'DD-MM-YYYY')
43 INTO C_TY_START
44 FROM
45 PER_TIME_PERIODS PTP
46 WHERE PTP.TIME_PERIOD_ID = P_PAYROLL_PERIOD_ID;
47 EXCEPTION
48 WHEN NO_DATA_FOUND THEN
49 NULL;
50 END;
51 SELECT
52 BALANCE_DIMENSION_ID
53 INTO C_YTD_BAL_DIM_ID
54 FROM
55 PAY_BALANCE_DIMENSIONS
56 WHERE DIMENSION_NAME = '_ASG_TD_YTD'
57 AND LEGISLATION_CODE = 'GB';
58 SELECT
59 BALANCE_DIMENSION_ID
60 INTO C_PTD_BAL_DIM_ID
61 FROM
62 PAY_BALANCE_DIMENSIONS
63 WHERE DIMENSION_NAME = '_ASG_TRANSFER_PTD'
64 AND LEGISLATION_CODE = 'GB';
65 SELECT
66 BALANCE_DIMENSION_ID
67 INTO L_PROC_PTD_DIM
68 FROM
69 PAY_BALANCE_DIMENSIONS
70 WHERE DIMENSION_NAME = '_ASG_PROC_PTD'
71 AND LEGISLATION_CODE = 'GB';
72 OPEN INPUT_VALUES;
73 FETCH INPUT_VALUES
74 INTO C_SCON_INPUT_VALUE_ID,C_CAT_INPUT_VALUE_ID,C_NI_ELEMENT_TYPE_ID;
75 CLOSE INPUT_VALUES;
76 C_GROSS_PAY_PTD_DBID := C_GET_DEF_BAL_ID('Gross Pay'
77 ,L_PROC_PTD_DIM);
78 C_GROSS_PAY_YTD_DBID := C_GET_DEF_BAL_ID('Gross Pay'
79 ,C_YTD_BAL_DIM_ID);
80 C_TAXABLE_PAY_PTD_DBID := C_GET_DEF_BAL_ID('Taxable Pay'
81 ,C_PTD_BAL_DIM_ID);
82 C_TAXABLE_PAY_YTD_DBID := C_GET_DEF_BAL_ID('Taxable Pay'
83 ,C_YTD_BAL_DIM_ID);
84 C_PENSION_PTD_DBID := C_GET_DEF_BAL_ID('Superannuation Total'
85 ,L_PROC_PTD_DIM);
86 C_PENSION_YTD_DBID := C_GET_DEF_BAL_ID('Superannuation Total'
87 ,C_YTD_BAL_DIM_ID);
88 C_PAYE_PTD_DBID := C_GET_DEF_BAL_ID('PAYE'
89 ,C_PTD_BAL_DIM_ID);
90 C_PAYE_YTD_DBID := C_GET_DEF_BAL_ID('PAYE'
91 ,C_YTD_BAL_DIM_ID);
92 C_SSP_PTD_DBID := C_GET_DEF_BAL_ID('SSP Total'
93 ,C_PTD_BAL_DIM_ID);
94 C_SSP_YTD_DBID := C_GET_DEF_BAL_ID('SSP Total'
95 ,C_YTD_BAL_DIM_ID);
96 C_SMP_PTD_DBID := C_GET_DEF_BAL_ID('SMP Total'
97 ,C_PTD_BAL_DIM_ID);
98 C_SMP_YTD_DBID := C_GET_DEF_BAL_ID('SMP Total'
99 ,C_YTD_BAL_DIM_ID);
100 C_SAP_PTD_DBID := C_GET_DEF_BAL_ID('SAP Total'
101 ,C_PTD_BAL_DIM_ID);
102 C_SAP_YTD_DBID := C_GET_DEF_BAL_ID('SAP Total'
103 ,C_YTD_BAL_DIM_ID);
104 C_SPPB_PTD_DBID := C_GET_DEF_BAL_ID('SPP Birth Total'
105 ,C_PTD_BAL_DIM_ID);
106 C_SPPB_YTD_DBID := C_GET_DEF_BAL_ID('SPP Birth Total'
107 ,C_YTD_BAL_DIM_ID);
108 C_SPPA_PTD_DBID := C_GET_DEF_BAL_ID('SPP Adoption Total'
109 ,C_PTD_BAL_DIM_ID);
110 C_SPPA_YTD_DBID := C_GET_DEF_BAL_ID('SPP Adoption Total'
111 ,C_YTD_BAL_DIM_ID);
112 C_STULN_PTD_DBID := C_GET_DEF_BAL_ID('Student Loan'
113 ,C_PTD_BAL_DIM_ID);
114 C_STULN_YTD_DBID := C_GET_DEF_BAL_ID('Student Loan'
115 ,C_YTD_BAL_DIM_ID);
116 C_TAXCR_PTD_DBID := C_GET_DEF_BAL_ID('Tax Credit'
117 ,C_PTD_BAL_DIM_ID);
118 C_TAXCR_YTD_DBID := C_GET_DEF_BAL_ID('Tax Credit'
119 ,C_YTD_BAL_DIM_ID);
120 C_WORKING_TAXCR_PTD_DBID := C_GET_DEF_BAL_ID('Working Tax Credit'
121 ,C_PTD_BAL_DIM_ID);
122 C_WORKING_TAXCR_YTD_DBID := C_GET_DEF_BAL_ID('Working Tax Credit'
123 ,C_YTD_BAL_DIM_ID);
124 C_BUSINESS_GROUP_NAME := RTRIM(SUBSTRB(HR_REPORTS.GET_BUSINESS_GROUP(P_BUSINESS_GROUP_ID)
125 ,1
126 ,240));
127 C_PAYROLL_NAME := HR_REPORTS.GET_PAYROLL_NAME(SYSDATE
128 ,P_PAYROLL_ID);
129 HR_REPORTS.GET_TIME_PERIOD(P_PAYROLL_PERIOD_ID
130 ,P_PERIOD_NAME
131 ,P_START_DATE
132 ,P_END_DATE);
133 C_PAYROLL_PERIOD := P_PERIOD_NAME;
134 BEGIN
135 SELECT
136 CONSOLIDATION_SET_NAME
137 INTO C_CONSOLIDATION_SET
138 FROM
139 PAY_CONSOLIDATION_SETS
140 WHERE CONSOLIDATION_SET_ID = P_CONSOLIDATION_SET_ID;
141 EXCEPTION
142 WHEN NO_DATA_FOUND THEN
143 NULL;
144 END;
145 IF P_SORT = 'EMP' THEN
146 P_SORT_ORDER := 'ORDER BY nvl(ppf.order_name,ppf.full_name)';
147 C_SORT_ORDER := 'Sort by Employee Name';
148 ELSIF P_SORT = 'ASG' THEN
149 P_SORT_ORDER := 'ORDER BY paf.assignment_number';
150 C_SORT_ORDER := 'Sort by Assignment Number';
151 END IF;
152 IF P_SUMMARY_ONLY = 'Y' THEN
153 C_SUMMARY_ONLY := 'Yes';
154 ELSIF P_SUMMARY_ONLY = 'N' THEN
155 C_SUMMARY_ONLY := 'No';
156 END IF;
157 RETURN (TRUE);
158 END BEFOREREPORT;
159
160 FUNCTION C_GET_TPL_DATAFORMULA0030(ASSIGNMENT_ID IN NUMBER
161 ,REG_PAYMENT_DATE IN DATE
162 ,END_DATE_P IN DATE) RETURN NUMBER IS
163 L_ASSIGNMENT_ID NUMBER := ASSIGNMENT_ID;
164 L_REGULAR_PAYMENT_DATE DATE := REG_PAYMENT_DATE;
165 L_PAYE_ELEMENT_ID NUMBER;
166 L_TAX_CODE_IPV_ID NUMBER;
167 L_TAX_BASIS_IPV_ID NUMBER;
168 L_PAY_PREVIOUS_IPV_ID NUMBER;
169 L_TAX_PREVIOUS_IPV_ID NUMBER;
170 L_MAX_RUN_RESULT_ID NUMBER;
171 CURSOR CSR_PAYE_ELEMENT IS
172 SELECT
173 ELEMENT_TYPE_ID
174 FROM
175 PAY_ELEMENT_TYPES_F
176 WHERE ELEMENT_NAME = 'PAYE';
177 CURSOR CSR_INPUT_VALUE(P_IPV_NAME IN VARCHAR2) IS
178 SELECT
179 INPUT_VALUE_ID
180 FROM
181 PAY_INPUT_VALUES_F
182 WHERE ELEMENT_TYPE_ID = L_PAYE_ELEMENT_ID
183 AND NAME = P_IPV_NAME;
184 CURSOR CSR_RESULT_VALUE(P_IPV_ID IN NUMBER) IS
185 SELECT
186 RESULT_VALUE
187 FROM
188 PAY_RUN_RESULT_VALUES
189 WHERE RUN_RESULT_ID = L_MAX_RUN_RESULT_ID
190 AND INPUT_VALUE_ID = P_IPV_ID;
191 CURSOR CSR_MAX_RUN_RESULT IS
192 SELECT
193 TO_NUMBER(SUBSTR(MAX(LPAD(ASSACT2.ACTION_SEQUENCE
194 ,15
195 ,'0') || R2.SOURCE_TYPE || R2.RUN_RESULT_ID)
196 ,17))
197 FROM
198 PAY_ASSIGNMENT_ACTIONS ASSACT2,
199 PAY_PAYROLL_ACTIONS PACT,
200 PAY_RUN_RESULTS R2
201 WHERE ASSACT2.ASSIGNMENT_ID = L_ASSIGNMENT_ID
202 AND R2.ELEMENT_TYPE_ID + 0 = L_PAYE_ELEMENT_ID
203 AND R2.ASSIGNMENT_ACTION_ID = ASSACT2.ASSIGNMENT_ACTION_ID
204 AND R2.STATUS IN ( 'P' , 'PA' )
205 AND PACT.PAYROLL_ACTION_ID = ASSACT2.PAYROLL_ACTION_ID
206 AND PACT.ACTION_TYPE IN ( 'Q' , 'R' , 'B' , 'I' )
207 AND ASSACT2.ACTION_STATUS = 'C'
208 AND PACT.EFFECTIVE_DATE <= END_DATE_P
209 AND PACT.EFFECTIVE_DATE >= ( TO_DATE('06-04-' || TO_CHAR(TO_NUMBER(TO_CHAR(L_REGULAR_PAYMENT_DATE
210 ,'YYYY')) + DECODE(SIGN(L_REGULAR_PAYMENT_DATE - TO_DATE('06-04-' || TO_CHAR(L_REGULAR_PAYMENT_DATE
211 ,'YYYY')
212 ,'DD-MM-YYYY'))
213 ,-1
214 ,-1
215 ,0))
216 ,'DD-MM-YYYY') )
217 AND NOT EXISTS (
218 SELECT
219 '1'
220 FROM
221 PAY_ACTION_INTERLOCKS PAI,
222 PAY_ASSIGNMENT_ACTIONS ASSACT3,
223 PAY_PAYROLL_ACTIONS PACT3
224 WHERE PAI.LOCKED_ACTION_ID = ASSACT2.ASSIGNMENT_ACTION_ID
225 AND PAI.LOCKING_ACTION_ID = ASSACT3.ASSIGNMENT_ACTION_ID
226 AND PACT3.PAYROLL_ACTION_ID = ASSACT3.PAYROLL_ACTION_ID
227 AND PACT3.ACTION_TYPE = 'V'
228 AND ASSACT3.ACTION_STATUS = 'C' );
229 BEGIN
230 C_CURRENT_CAT := HR_GBNIDIR.ELEMENT_ENTRY_VALUE(L_ASSIGNMENT_ID
231 ,L_REGULAR_PAYMENT_DATE
232 ,'NI'
233 ,'Category');
234 OPEN CSR_PAYE_ELEMENT;
235 FETCH CSR_PAYE_ELEMENT
236 INTO L_PAYE_ELEMENT_ID;
237 CLOSE CSR_PAYE_ELEMENT;
238 OPEN CSR_INPUT_VALUE('Tax Code');
239 FETCH CSR_INPUT_VALUE
240 INTO L_TAX_CODE_IPV_ID;
241 CLOSE CSR_INPUT_VALUE;
242 OPEN CSR_INPUT_VALUE('Tax Basis');
243 FETCH CSR_INPUT_VALUE
244 INTO L_TAX_BASIS_IPV_ID;
245 CLOSE CSR_INPUT_VALUE;
246 OPEN CSR_INPUT_VALUE('Pay Previous');
247 FETCH CSR_INPUT_VALUE
248 INTO L_PAY_PREVIOUS_IPV_ID;
249 CLOSE CSR_INPUT_VALUE;
250 OPEN CSR_INPUT_VALUE('Tax Previous');
251 FETCH CSR_INPUT_VALUE
252 INTO L_TAX_PREVIOUS_IPV_ID;
253 CLOSE CSR_INPUT_VALUE;
254 BEGIN
255 OPEN CSR_MAX_RUN_RESULT;
256 FETCH CSR_MAX_RUN_RESULT
257 INTO L_MAX_RUN_RESULT_ID;
258 IF CSR_MAX_RUN_RESULT%FOUND THEN
259 OPEN CSR_RESULT_VALUE(L_TAX_CODE_IPV_ID);
260 FETCH CSR_RESULT_VALUE
261 INTO C_TAX_CODE;
262 CLOSE CSR_RESULT_VALUE;
263 OPEN CSR_RESULT_VALUE(L_TAX_BASIS_IPV_ID);
264 FETCH CSR_RESULT_VALUE
265 INTO C_BASIS;
266 CLOSE CSR_RESULT_VALUE;
267 OPEN CSR_RESULT_VALUE(L_PAY_PREVIOUS_IPV_ID);
268 FETCH CSR_RESULT_VALUE
269 INTO C_PREV_TAXABLE;
270 CLOSE CSR_RESULT_VALUE;
271 OPEN CSR_RESULT_VALUE(L_TAX_PREVIOUS_IPV_ID);
272 FETCH CSR_RESULT_VALUE
273 INTO C_PAID;
274 CLOSE CSR_RESULT_VALUE;
275 ELSE
276 C_TAX_CODE := HR_GBNIDIR.ELEMENT_ENTRY_VALUE(L_ASSIGNMENT_ID
277 ,L_REGULAR_PAYMENT_DATE
278 ,'PAYE Details'
279 ,'Tax Code');
280 C_BASIS := HR_GBNIDIR.ELEMENT_ENTRY_VALUE(L_ASSIGNMENT_ID
281 ,L_REGULAR_PAYMENT_DATE
282 ,'PAYE Details'
283 ,'Tax Basis');
284 C_PREV_TAXABLE := HR_GBNIDIR.ELEMENT_ENTRY_VALUE(L_ASSIGNMENT_ID
285 ,L_REGULAR_PAYMENT_DATE
286 ,'PAYE Details'
287 ,'Pay Previous');
288 C_PAID := HR_GBNIDIR.ELEMENT_ENTRY_VALUE(L_ASSIGNMENT_ID
289 ,L_REGULAR_PAYMENT_DATE
290 ,'PAYE Details'
291 ,'Tax Previous');
292 END IF;
293 END;
294 C_PREVIOUS_GROSS_TOT := C_PREVIOUS_GROSS_TOT + NVL(C_PREV_TAXABLE
295 ,0);
296 C_PREVIOUS_TAX_TOT := C_PREVIOUS_TAX_TOT + NVL(C_PAID
297 ,0);
298 RETURN (C_OUTPUT);
299 RETURN NULL;
300 EXCEPTION
301 WHEN NO_DATA_FOUND THEN
302 RETURN (C_OUTPUT);
303 END C_GET_TPL_DATAFORMULA0030;
304
305 FUNCTION C_GET_BALANCESFORMULA(ASG_ACTION_ID IN NUMBER) RETURN NUMBER IS
306 L_PERIOD_FLAG VARCHAR2(1) := 'N';
307 L_PERIOD_START DATE;
308 L_PERIOD_END DATE;
309 L_ACTION_EFFECTIVE DATE;
310 L_TIME_PERIOD_ID NUMBER;
311 BEGIN
312 SELECT
313 PPA.EFFECTIVE_DATE,
314 PPA.TIME_PERIOD_ID
315 INTO L_ACTION_EFFECTIVE,L_TIME_PERIOD_ID
316 FROM
317 PAY_PAYROLL_ACTIONS PPA,
318 PAY_ASSIGNMENT_ACTIONS PAA
319 WHERE PAA.ASSIGNMENT_ACTION_ID = ASG_ACTION_ID
320 AND PPA.PAYROLL_ACTION_ID = PAA.PAYROLL_ACTION_ID;
321 SELECT
322 PTP.START_DATE,
323 PTP.REGULAR_PAYMENT_DATE
324 INTO L_PERIOD_START,L_PERIOD_END
325 FROM
326 PER_TIME_PERIODS PTP
327 WHERE PTP.TIME_PERIOD_ID = P_PAYROLL_PERIOD_ID;
328 IF (L_TIME_PERIOD_ID <> P_PAYROLL_PERIOD_ID) THEN
329 L_PERIOD_FLAG := 'Y';
330 END IF;
331 C_GROSS_PAY_PTD_VALUE := 0;
332 C_GROSS_PAY_YTD_VALUE := 0;
333 C_GROSS_PAY_YTD_VALUE := HR_DIRBAL.GET_BALANCE(ASG_ACTION_ID
334 ,C_GROSS_PAY_YTD_DBID);
335 IF L_PERIOD_FLAG = 'N' THEN
336 C_GROSS_PAY_PTD_VALUE := HR_DIRBAL.GET_BALANCE(ASG_ACTION_ID
340 C_GROSS_PAY_YTD_TOT := C_GROSS_PAY_YTD_TOT + C_GROSS_PAY_YTD_VALUE;
337 ,C_GROSS_PAY_PTD_DBID);
338 END IF;
339 C_GROSS_PAY_PTD_TOT := C_GROSS_PAY_PTD_TOT + C_GROSS_PAY_PTD_VALUE;
341 C_TAXABLE_PAY_PTD_VALUE := 0;
342 C_TAXABLE_PAY_YTD_VALUE := 0;
343 C_TAXABLE_PAY_YTD_VALUE := HR_DIRBAL.GET_BALANCE(ASG_ACTION_ID
344 ,C_TAXABLE_PAY_YTD_DBID);
345 IF L_PERIOD_FLAG = 'N' THEN
346 C_TAXABLE_PAY_PTD_VALUE := HR_DIRBAL.GET_BALANCE(ASG_ACTION_ID
347 ,C_TAXABLE_PAY_PTD_DBID);
348 END IF;
349 C_TAXABLE_PAY_PTD_TOT := C_TAXABLE_PAY_PTD_TOT + C_TAXABLE_PAY_PTD_VALUE;
350 C_TAXABLE_PAY_YTD_TOT := C_TAXABLE_PAY_YTD_TOT + C_TAXABLE_PAY_YTD_VALUE;
351 C_PENSION_PTD_VALUE := 0;
352 C_PENSION_YTD_VALUE := 0;
353 C_PENSION_YTD_VALUE := HR_DIRBAL.GET_BALANCE(ASG_ACTION_ID
354 ,C_PENSION_YTD_DBID);
355 IF L_PERIOD_FLAG = 'N' THEN
356 C_PENSION_PTD_VALUE := HR_DIRBAL.GET_BALANCE(ASG_ACTION_ID
357 ,C_PENSION_PTD_DBID);
358 END IF;
359 C_PAYE_PTD_VALUE := 0;
360 C_PAYE_YTD_VALUE := 0;
361 C_PAYE_YTD_VALUE := HR_DIRBAL.GET_BALANCE(ASG_ACTION_ID
362 ,C_PAYE_YTD_DBID);
363 IF L_PERIOD_FLAG = 'N' THEN
364 C_PAYE_PTD_VALUE := HR_DIRBAL.GET_BALANCE(ASG_ACTION_ID
365 ,C_PAYE_PTD_DBID);
366 END IF;
367 C_PAYE_PTD_TOT := C_PAYE_PTD_TOT + C_PAYE_PTD_VALUE;
368 C_PAYE_YTD_TOT := C_PAYE_YTD_TOT + C_PAYE_YTD_VALUE;
369 C_SSP_PTD_VALUE := 0;
370 C_SSP_YTD_VALUE := 0;
371 C_SSP_YTD_VALUE := HR_DIRBAL.GET_BALANCE(ASG_ACTION_ID
372 ,C_SSP_YTD_DBID);
373 IF L_PERIOD_FLAG = 'N' THEN
374 C_SSP_PTD_VALUE := HR_DIRBAL.GET_BALANCE(ASG_ACTION_ID
375 ,C_SSP_PTD_DBID);
376 END IF;
377 C_SSP_PTD_TOT := C_SSP_PTD_TOT + C_SSP_PTD_VALUE;
378 C_SSP_YTD_TOT := C_SSP_YTD_TOT + C_SSP_YTD_VALUE;
379 C_SMP_PTD_VALUE := 0;
380 C_SMP_YTD_VALUE := 0;
381 C_SMP_YTD_VALUE := HR_DIRBAL.GET_BALANCE(ASG_ACTION_ID
382 ,C_SMP_YTD_DBID);
383 IF L_PERIOD_FLAG = 'N' THEN
384 C_SMP_PTD_VALUE := HR_DIRBAL.GET_BALANCE(ASG_ACTION_ID
385 ,C_SMP_PTD_DBID);
386 END IF;
387 C_SMP_PTD_TOT := C_SMP_PTD_TOT + C_SMP_PTD_VALUE;
388 C_SMP_YTD_TOT := C_SMP_YTD_TOT + C_SMP_YTD_VALUE;
389 C_SAP_PTD_VALUE := 0;
390 C_SAP_YTD_VALUE := 0;
391 C_SAP_YTD_VALUE := HR_DIRBAL.GET_BALANCE(ASG_ACTION_ID
392 ,C_SAP_YTD_DBID);
393 C_SAP_PTD_VALUE := HR_DIRBAL.GET_BALANCE(ASG_ACTION_ID
394 ,C_SAP_PTD_DBID);
395 C_SAP_PTD_TOT := C_SAP_PTD_TOT + C_SAP_PTD_VALUE;
396 C_SAP_YTD_TOT := C_SAP_YTD_TOT + C_SAP_YTD_VALUE;
397 C_SPPA_PTD_VALUE := 0;
398 C_SPPA_YTD_VALUE := 0;
399 C_SPPA_YTD_VALUE := HR_DIRBAL.GET_BALANCE(ASG_ACTION_ID
400 ,C_SPPA_YTD_DBID);
401 IF L_PERIOD_FLAG = 'N' THEN
402 C_SPPA_PTD_VALUE := HR_DIRBAL.GET_BALANCE(ASG_ACTION_ID
403 ,C_SPPA_PTD_DBID);
404 END IF;
405 C_SPPA_PTD_TOT := C_SPPA_PTD_TOT + C_SPPA_PTD_VALUE;
406 C_SPPA_YTD_TOT := C_SPPA_YTD_TOT + C_SPPA_YTD_VALUE;
407 C_SPPB_PTD_VALUE := 0;
408 C_SPPB_YTD_VALUE := 0;
409 C_SPPB_YTD_VALUE := HR_DIRBAL.GET_BALANCE(ASG_ACTION_ID
410 ,C_SPPB_YTD_DBID);
411 IF L_PERIOD_FLAG = 'N' THEN
412 C_SPPB_PTD_VALUE := HR_DIRBAL.GET_BALANCE(ASG_ACTION_ID
413 ,C_SPPB_PTD_DBID);
414 END IF;
415 C_SPPB_PTD_TOT := C_SPPB_PTD_TOT + C_SPPB_PTD_VALUE;
416 C_SPPB_YTD_TOT := C_SPPB_YTD_TOT + C_SPPB_YTD_VALUE;
417 C_STULN_PTD_VALUE := 0;
418 C_STULN_YTD_VALUE := 0;
419 C_STULN_YTD_VALUE := HR_DIRBAL.GET_BALANCE(ASG_ACTION_ID
420 ,C_STULN_YTD_DBID);
421 IF L_PERIOD_FLAG = 'N' THEN
422 C_STULN_PTD_VALUE := HR_DIRBAL.GET_BALANCE(ASG_ACTION_ID
423 ,C_STULN_PTD_DBID);
424 END IF;
425 C_STULN_PTD_TOT := C_STULN_PTD_TOT + C_STULN_PTD_VALUE;
426 C_STULN_YTD_TOT := C_STULN_YTD_TOT + C_STULN_YTD_VALUE;
427 C_WORKING_TAXCR_PTD_VALUE := 0;
428 C_WORKING_TAXCR_YTD_VALUE := 0;
429 C_WORKING_TAXCR_YTD_VALUE := HR_DIRBAL.GET_BALANCE(ASG_ACTION_ID
430 ,C_WORKING_TAXCR_YTD_DBID);
431 IF L_PERIOD_FLAG = 'N' THEN
432 C_WORKING_TAXCR_PTD_VALUE := HR_DIRBAL.GET_BALANCE(ASG_ACTION_ID
433 ,C_WORKING_TAXCR_PTD_DBID);
434 END IF;
435 RETURN (0);
436 END C_GET_BALANCESFORMULA;
437
438 FUNCTION C_GET_DEF_BAL_ID(P_BALANCE_NAME IN VARCHAR2
439 ,P_DIMENSION_ID IN NUMBER) RETURN NUMBER IS
440 T_DEF_BAL_ID NUMBER := 0;
441 BEGIN
442 SELECT
443 PDB.DEFINED_BALANCE_ID
444 INTO T_DEF_BAL_ID
445 FROM
446 PAY_DEFINED_BALANCES PDB,
447 PAY_BALANCE_TYPES PBT
448 WHERE PBT.BALANCE_TYPE_ID = PDB.BALANCE_TYPE_ID
449 AND PBT.BALANCE_NAME = P_BALANCE_NAME
450 AND PBT.LEGISLATION_CODE = 'GB'
451 AND PBT.BUSINESS_GROUP_ID is null
452 AND PDB.BALANCE_DIMENSION_ID = P_DIMENSION_ID
453 AND PDB.BUSINESS_GROUP_ID is null
454 AND PDB.LEGISLATION_CODE = 'GB';
455 RETURN (T_DEF_BAL_ID);
456 RETURN NULL;
457 EXCEPTION
461
458 WHEN NO_DATA_FOUND THEN
459 RETURN (0);
460 END C_GET_DEF_BAL_ID;
462 FUNCTION C_CALCULATE_TOTALSFORMULA(CAT_CODE IN VARCHAR2
463 ,DIM IN VARCHAR2
464 ,EMPLOYER IN NUMBER
465 ,ABLE IN NUMBER
466 ,EMPLOYEE IN NUMBER) RETURN NUMBER IS
467 BEGIN
468 IF CAT_CODE in ('C','S') THEN
469 IF DIM = 'PTD' THEN
470 C_NI_ERS_PTD_TOT := C_NI_ERS_PTD_TOT + EMPLOYER;
471 ELSE
472 C_NI_ERS_YTD_TOT := C_NI_ERS_YTD_TOT + EMPLOYER;
473 END IF;
474 ELSE
475 IF DIM = 'PTD' THEN
476 C_NI_EARNINGS_PTD_TOT := C_NI_EARNINGS_PTD_TOT + ABLE;
477 C_NI_EES_PTD_TOT := C_NI_EES_PTD_TOT + EMPLOYEE;
478 C_NI_ERS_PTD_TOT := C_NI_ERS_PTD_TOT + EMPLOYER;
479 ELSE
480 C_NI_EARNINGS_YTD_TOT := C_NI_EARNINGS_YTD_TOT + ABLE;
481 C_NI_EES_YTD_TOT := C_NI_EES_YTD_TOT + EMPLOYEE;
482 C_NI_ERS_YTD_TOT := C_NI_ERS_YTD_TOT + EMPLOYER;
483 END IF;
484 END IF;
485 C_NET_INCOME_TAX := 0;
486 C_GROSS_NIC := 0;
487 C_NIC_REBATE := 0;
488 C_NET_NI := 0;
489 C_TOTAL_AMOUNT_DUE := 0;
490 C_NET_INCOME_TAX := C_PAYE_PTD_TOT + C_STULN_PTD_TOT - C_TAXCR_PTD_TOT;
491 C_GROSS_NIC := C_NI_EES_PTD_TOT + C_NI_ERS_PTD_TOT;
492 C_NIC_REBATE := C_EES_REB_PTD_TOT + C_ERS_REB_PTD_TOT;
493 C_NET_NI := C_GROSS_NIC - C_NIC_REBATE;
494 C_TOTAL_AMOUNT_DUE := C_NET_INCOME_TAX + C_NET_NI;
495 RETURN (0);
496 END C_CALCULATE_TOTALSFORMULA;
497
498 FUNCTION C_ESTABLISH_PERIODFORMULA RETURN NUMBER IS
499 V_REG_PAY_DATE DATE;
500 V_NO_PER_FISC NUMBER;
501 BEGIN
502 SELECT
503 BPTP.REGULAR_PAYMENT_DATE,
504 BPTPT.NUMBER_PER_FISCAL_YEAR
505 INTO V_REG_PAY_DATE,V_NO_PER_FISC
506 FROM
507 PER_TIME_PERIODS BPTP,
508 PER_TIME_PERIOD_TYPES BPTPT
509 WHERE BPTP.TIME_PERIOD_ID = P_PAYROLL_PERIOD_ID
510 AND BPTP.PERIOD_TYPE = BPTPT.PERIOD_TYPE;
511 C_PERIOD_DATE := HR_GBBAL.SPAN_START(V_REG_PAY_DATE
512 ,V_NO_PER_FISC
513 ,'06-04');
514 RETURN 0;
515 END C_ESTABLISH_PERIODFORMULA;
516
517 FUNCTION AFTERREPORT RETURN BOOLEAN IS
518 BEGIN
519 --HR_STANDARD.EVENT('AFTER REPORT');
520 RETURN (TRUE);
521 END AFTERREPORT;
522
523 FUNCTION AFTERPFORM RETURN BOOLEAN IS
524 BEGIN
525 IF P_CONSOLIDATION_SET_ID IS NOT NULL THEN
526 P_CONSOLIDATION_SET_WHERE := ' and pact.consolidation_set_id = :P_CONSOLIDATION_SET_ID ';
527 P_REVERSAL_CONSOLIDATION_SET := ' and pact2.consolidation_set_id = :P_CONSOLIDATION_SET_ID ';
528 END IF;
529 RETURN (TRUE);
530 END AFTERPFORM;
531
532 FUNCTION C_TAX_CODE_P RETURN VARCHAR2 IS
533 BEGIN
534 RETURN C_TAX_CODE;
535 END C_TAX_CODE_P;
536
537 FUNCTION C_BASIS_P RETURN VARCHAR2 IS
538 BEGIN
539 RETURN C_BASIS;
540 END C_BASIS_P;
541
542 FUNCTION C_PREV_TAXABLE_P RETURN NUMBER IS
543 BEGIN
544 RETURN C_PREV_TAXABLE;
545 END C_PREV_TAXABLE_P;
546
547 FUNCTION C_PAID_P RETURN NUMBER IS
548 BEGIN
549 RETURN C_PAID;
550 END C_PAID_P;
551
552 FUNCTION C_CURRENT_CAT_P RETURN VARCHAR2 IS
553 BEGIN
554 RETURN C_CURRENT_CAT;
555 END C_CURRENT_CAT_P;
556
557 FUNCTION C_OUTPUT_P RETURN NUMBER IS
558 BEGIN
559 RETURN C_OUTPUT;
560 END C_OUTPUT_P;
561
562 FUNCTION C_GROSS_PAY_PTD_VALUE_P RETURN NUMBER IS
563 BEGIN
564 RETURN C_GROSS_PAY_PTD_VALUE;
565 END C_GROSS_PAY_PTD_VALUE_P;
566
567 FUNCTION C_GROSS_PAY_YTD_VALUE_P RETURN NUMBER IS
568 BEGIN
569 RETURN C_GROSS_PAY_YTD_VALUE;
570 END C_GROSS_PAY_YTD_VALUE_P;
571
572 FUNCTION C_TAXABLE_PAY_PTD_VALUE_P RETURN NUMBER IS
573 BEGIN
574 RETURN C_TAXABLE_PAY_PTD_VALUE;
575 END C_TAXABLE_PAY_PTD_VALUE_P;
576
577 FUNCTION C_TAXABLE_PAY_YTD_VALUE_P RETURN NUMBER IS
578 BEGIN
579 RETURN C_TAXABLE_PAY_YTD_VALUE;
580 END C_TAXABLE_PAY_YTD_VALUE_P;
581
582 FUNCTION C_SPPA_YTD_VALUE_P RETURN NUMBER IS
583 BEGIN
584 RETURN C_SPPA_YTD_VALUE;
585 END C_SPPA_YTD_VALUE_P;
586
587 FUNCTION C_PENSION_PTD_VALUE_P RETURN NUMBER IS
588 BEGIN
589 RETURN C_PENSION_PTD_VALUE;
590 END C_PENSION_PTD_VALUE_P;
591
592 FUNCTION C_PENSION_YTD_VALUE_P RETURN NUMBER IS
593 BEGIN
594 RETURN C_PENSION_YTD_VALUE;
595 END C_PENSION_YTD_VALUE_P;
596
597 FUNCTION C_PAYE_PTD_VALUE_P RETURN NUMBER IS
598 BEGIN
599 RETURN C_PAYE_PTD_VALUE;
600 END C_PAYE_PTD_VALUE_P;
601
602 FUNCTION C_PAYE_YTD_VALUE_P RETURN NUMBER IS
603 BEGIN
604 RETURN C_PAYE_YTD_VALUE;
605 END C_PAYE_YTD_VALUE_P;
606
607 FUNCTION C_SPPA_PTD_VALUE_P RETURN NUMBER IS
608 BEGIN
609 RETURN C_SPPA_PTD_VALUE;
610 END C_SPPA_PTD_VALUE_P;
611
612 FUNCTION C_SSP_PTD_VALUE_P RETURN NUMBER IS
613 BEGIN
614 RETURN C_SSP_PTD_VALUE;
615 END C_SSP_PTD_VALUE_P;
616
617 FUNCTION C_SSP_YTD_VALUE_P RETURN NUMBER IS
618 BEGIN
619 RETURN C_SSP_YTD_VALUE;
620 END C_SSP_YTD_VALUE_P;
621
622 FUNCTION C_SMP_PTD_VALUE_P RETURN NUMBER IS
623 BEGIN
624 RETURN C_SMP_PTD_VALUE;
625 END C_SMP_PTD_VALUE_P;
626
627 FUNCTION C_SPPB_YTD_VALUE_P RETURN NUMBER IS
628 BEGIN
629 RETURN C_SPPB_YTD_VALUE;
633 BEGIN
630 END C_SPPB_YTD_VALUE_P;
631
632 FUNCTION C_SMP_YTD_VALUE_P RETURN NUMBER IS
634 RETURN C_SMP_YTD_VALUE;
635 END C_SMP_YTD_VALUE_P;
636
637 FUNCTION C_STULN_PTD_VALUE_P RETURN NUMBER IS
638 BEGIN
639 RETURN C_STULN_PTD_VALUE;
640 END C_STULN_PTD_VALUE_P;
641
642 FUNCTION C_WORKING_TAXCR_YTD_VALUE_P RETURN NUMBER IS
643 BEGIN
644 RETURN C_WORKING_TAXCR_YTD_VALUE;
645 END C_WORKING_TAXCR_YTD_VALUE_P;
646
647 FUNCTION C_SPPB_PTD_VALUE_P RETURN NUMBER IS
648 BEGIN
649 RETURN C_SPPB_PTD_VALUE;
650 END C_SPPB_PTD_VALUE_P;
651
652 FUNCTION C_STULN_YTD_VALUE_P RETURN NUMBER IS
653 BEGIN
654 RETURN C_STULN_YTD_VALUE;
655 END C_STULN_YTD_VALUE_P;
656
657 FUNCTION C_WORKING_TAXCR_PTD_VALUE_P RETURN NUMBER IS
658 BEGIN
659 RETURN C_WORKING_TAXCR_PTD_VALUE;
660 END C_WORKING_TAXCR_PTD_VALUE_P;
661
662 FUNCTION C_SAP_PTD_VALUE_P RETURN NUMBER IS
663 BEGIN
664 RETURN C_SAP_PTD_VALUE;
665 END C_SAP_PTD_VALUE_P;
666
667 FUNCTION C_TAXCR_PTD_VALUE_P RETURN NUMBER IS
668 BEGIN
669 RETURN C_TAXCR_PTD_VALUE;
670 END C_TAXCR_PTD_VALUE_P;
671
672 FUNCTION C_SAP_YTD_VALUE_P RETURN NUMBER IS
673 BEGIN
674 RETURN C_SAP_YTD_VALUE;
675 END C_SAP_YTD_VALUE_P;
676
677 FUNCTION C_TAXCR_YTD_VALUE_P RETURN NUMBER IS
678 BEGIN
679 RETURN C_TAXCR_YTD_VALUE;
680 END C_TAXCR_YTD_VALUE_P;
681
682 FUNCTION C_NI_TOTAL_P RETURN NUMBER IS
683 BEGIN
684 RETURN C_NI_TOTAL;
685 END C_NI_TOTAL_P;
686
687 FUNCTION C_YTD_BAL_DIM_ID_P RETURN NUMBER IS
688 BEGIN
689 RETURN C_YTD_BAL_DIM_ID;
690 END C_YTD_BAL_DIM_ID_P;
691
692 FUNCTION C_PTD_BAL_DIM_ID_P RETURN NUMBER IS
693 BEGIN
694 RETURN C_PTD_BAL_DIM_ID;
695 END C_PTD_BAL_DIM_ID_P;
696
697 FUNCTION C_SCON_INPUT_VALUE_ID_P RETURN NUMBER IS
698 BEGIN
699 RETURN C_SCON_INPUT_VALUE_ID;
700 END C_SCON_INPUT_VALUE_ID_P;
701
702 FUNCTION C_NI_ELEMENT_TYPE_ID_P RETURN NUMBER IS
703 BEGIN
704 RETURN C_NI_ELEMENT_TYPE_ID;
705 END C_NI_ELEMENT_TYPE_ID_P;
706
707 FUNCTION C_GROSS_PAY_PTD_DBID_P RETURN NUMBER IS
708 BEGIN
709 RETURN C_GROSS_PAY_PTD_DBID;
710 END C_GROSS_PAY_PTD_DBID_P;
711
712 FUNCTION C_GROSS_PAY_YTD_DBID_P RETURN NUMBER IS
713 BEGIN
714 RETURN C_GROSS_PAY_YTD_DBID;
715 END C_GROSS_PAY_YTD_DBID_P;
716
717 FUNCTION C_GROSS_PAY_PTD_TOT_P RETURN NUMBER IS
718 BEGIN
719 RETURN C_GROSS_PAY_PTD_TOT;
720 END C_GROSS_PAY_PTD_TOT_P;
721
722 FUNCTION C_GROSS_PAY_YTD_TOT_P RETURN NUMBER IS
723 BEGIN
724 RETURN C_GROSS_PAY_YTD_TOT;
725 END C_GROSS_PAY_YTD_TOT_P;
726
727 FUNCTION C_NI_EARNINGS_PTD_TOT_P RETURN NUMBER IS
728 BEGIN
729 RETURN C_NI_EARNINGS_PTD_TOT;
730 END C_NI_EARNINGS_PTD_TOT_P;
731
732 FUNCTION C_NI_EARNINGS_YTD_TOT_P RETURN NUMBER IS
733 BEGIN
734 RETURN C_NI_EARNINGS_YTD_TOT;
735 END C_NI_EARNINGS_YTD_TOT_P;
736
737 FUNCTION C_TAXABLE_PAY_PTD_DBID_P RETURN NUMBER IS
738 BEGIN
739 RETURN C_TAXABLE_PAY_PTD_DBID;
740 END C_TAXABLE_PAY_PTD_DBID_P;
741
742 FUNCTION C_TAXABLE_PAY_YTD_DBID_P RETURN NUMBER IS
743 BEGIN
744 RETURN C_TAXABLE_PAY_YTD_DBID;
745 END C_TAXABLE_PAY_YTD_DBID_P;
746
747 FUNCTION C_TAXABLE_PAY_PTD_TOT_P RETURN NUMBER IS
748 BEGIN
749 RETURN C_TAXABLE_PAY_PTD_TOT;
750 END C_TAXABLE_PAY_PTD_TOT_P;
751
752 FUNCTION C_TAXABLE_PAY_YTD_TOT_P RETURN NUMBER IS
753 BEGIN
754 RETURN C_TAXABLE_PAY_YTD_TOT;
755 END C_TAXABLE_PAY_YTD_TOT_P;
756
757 FUNCTION C_PENSION_PTD_DBID_P RETURN NUMBER IS
758 BEGIN
759 RETURN C_PENSION_PTD_DBID;
760 END C_PENSION_PTD_DBID_P;
761
762 FUNCTION C_PENSION_YTD_DBID_P RETURN NUMBER IS
763 BEGIN
764 RETURN C_PENSION_YTD_DBID;
765 END C_PENSION_YTD_DBID_P;
766
767 FUNCTION C_PENSION_PTD_TOT_P RETURN NUMBER IS
768 BEGIN
769 RETURN C_PENSION_PTD_TOT;
770 END C_PENSION_PTD_TOT_P;
771
772 FUNCTION C_PENSION_YTD_TOT_P RETURN NUMBER IS
773 BEGIN
774 RETURN C_PENSION_YTD_TOT;
775 END C_PENSION_YTD_TOT_P;
776
777 FUNCTION C_PAYE_PTD_DBID_P RETURN NUMBER IS
778 BEGIN
779 RETURN C_PAYE_PTD_DBID;
780 END C_PAYE_PTD_DBID_P;
781
782 FUNCTION C_PAYE_YTD_DBID_P RETURN NUMBER IS
783 BEGIN
784 RETURN C_PAYE_YTD_DBID;
785 END C_PAYE_YTD_DBID_P;
786
787 FUNCTION C_PAYE_PTD_TOT_P RETURN NUMBER IS
788 BEGIN
789 RETURN C_PAYE_PTD_TOT;
790 END C_PAYE_PTD_TOT_P;
791
792 FUNCTION C_PAYE_YTD_TOT_P RETURN NUMBER IS
793 BEGIN
794 RETURN C_PAYE_YTD_TOT;
795 END C_PAYE_YTD_TOT_P;
796
797 FUNCTION C_SSP_YTD_DBID_P RETURN NUMBER IS
798 BEGIN
799 RETURN C_SSP_YTD_DBID;
800 END C_SSP_YTD_DBID_P;
801
802 FUNCTION C_SSP_PTD_DBID_P RETURN NUMBER IS
803 BEGIN
804 RETURN C_SSP_PTD_DBID;
805 END C_SSP_PTD_DBID_P;
806
807 FUNCTION C_SSP_PTD_TOT_P RETURN NUMBER IS
808 BEGIN
809 RETURN C_SSP_PTD_TOT;
810 END C_SSP_PTD_TOT_P;
811
812 FUNCTION C_SSP_YTD_TOT_P RETURN NUMBER IS
813 BEGIN
814 RETURN C_SSP_YTD_TOT;
815 END C_SSP_YTD_TOT_P;
816
817 FUNCTION C_SMP_PTD_DBID_P RETURN NUMBER IS
818 BEGIN
819 RETURN C_SMP_PTD_DBID;
820 END C_SMP_PTD_DBID_P;
821
825 END C_SMP_YTD_DBID_P;
822 FUNCTION C_SMP_YTD_DBID_P RETURN NUMBER IS
823 BEGIN
824 RETURN C_SMP_YTD_DBID;
826
827 FUNCTION C_SMP_PTD_TOT_P RETURN NUMBER IS
828 BEGIN
829 RETURN C_SMP_PTD_TOT;
830 END C_SMP_PTD_TOT_P;
831
832 FUNCTION C_SMP_YTD_TOT_P RETURN NUMBER IS
833 BEGIN
834 RETURN C_SMP_YTD_TOT;
835 END C_SMP_YTD_TOT_P;
836
837 FUNCTION C_NI_EES_PTD_TOT_P RETURN NUMBER IS
838 BEGIN
839 RETURN C_NI_EES_PTD_TOT;
840 END C_NI_EES_PTD_TOT_P;
841
842 FUNCTION C_NI_EES_YTD_TOT_P RETURN NUMBER IS
843 BEGIN
844 RETURN C_NI_EES_YTD_TOT;
845 END C_NI_EES_YTD_TOT_P;
846
847 FUNCTION C_NI_ERS_PTD_TOT_P RETURN NUMBER IS
848 BEGIN
849 RETURN C_NI_ERS_PTD_TOT;
850 END C_NI_ERS_PTD_TOT_P;
851
852 FUNCTION C_NI_ERS_YTD_TOT_P RETURN NUMBER IS
853 BEGIN
854 RETURN C_NI_ERS_YTD_TOT;
855 END C_NI_ERS_YTD_TOT_P;
856
857 FUNCTION C_PREVIOUS_GROSS_TOT_P RETURN NUMBER IS
858 BEGIN
859 RETURN C_PREVIOUS_GROSS_TOT;
860 END C_PREVIOUS_GROSS_TOT_P;
861
862 FUNCTION C_PREVIOUS_TAX_TOT_P RETURN NUMBER IS
863 BEGIN
864 RETURN C_PREVIOUS_TAX_TOT;
865 END C_PREVIOUS_TAX_TOT_P;
866
867 FUNCTION C_BUSINESS_GROUP_NAME_P RETURN VARCHAR2 IS
868 BEGIN
869 RETURN C_BUSINESS_GROUP_NAME;
870 END C_BUSINESS_GROUP_NAME_P;
871
872 FUNCTION C_PAYROLL_NAME_P RETURN VARCHAR2 IS
873 BEGIN
874 RETURN C_PAYROLL_NAME;
875 END C_PAYROLL_NAME_P;
876
877 FUNCTION C_PAYROLL_PERIOD_P RETURN VARCHAR2 IS
878 BEGIN
879 RETURN C_PAYROLL_PERIOD;
880 END C_PAYROLL_PERIOD_P;
881
882 FUNCTION C_CONSOLIDATION_SET_P RETURN VARCHAR2 IS
883 BEGIN
884 RETURN C_CONSOLIDATION_SET;
885 END C_CONSOLIDATION_SET_P;
886
887 FUNCTION C_SORT_ORDER_P RETURN VARCHAR2 IS
888 BEGIN
889 RETURN C_SORT_ORDER;
890 END C_SORT_ORDER_P;
891
892 FUNCTION C_PERIOD_DATE_P RETURN DATE IS
893 BEGIN
894 RETURN C_PERIOD_DATE;
895 END C_PERIOD_DATE_P;
896
897 FUNCTION C_SUMMARY_ONLY_P RETURN VARCHAR2 IS
898 BEGIN
899 RETURN C_SUMMARY_ONLY;
900 END C_SUMMARY_ONLY_P;
901
902 FUNCTION C_STULN_PTD_DBID_P RETURN NUMBER IS
903 BEGIN
904 RETURN C_STULN_PTD_DBID;
905 END C_STULN_PTD_DBID_P;
906
907 FUNCTION C_STULN_YTD_DBID_P RETURN NUMBER IS
908 BEGIN
909 RETURN C_STULN_YTD_DBID;
910 END C_STULN_YTD_DBID_P;
911
912 FUNCTION C_STULN_PTD_TOT_P RETURN NUMBER IS
913 BEGIN
914 RETURN C_STULN_PTD_TOT;
915 END C_STULN_PTD_TOT_P;
916
917 FUNCTION C_STULN_YTD_TOT_P RETURN NUMBER IS
918 BEGIN
919 RETURN C_STULN_YTD_TOT;
920 END C_STULN_YTD_TOT_P;
921
922 FUNCTION C_EES_REB_PTD_TOT_P RETURN NUMBER IS
923 BEGIN
924 RETURN C_EES_REB_PTD_TOT;
925 END C_EES_REB_PTD_TOT_P;
926
927 FUNCTION C_EES_REB_YTD_TOT_P RETURN NUMBER IS
928 BEGIN
929 RETURN C_EES_REB_YTD_TOT;
930 END C_EES_REB_YTD_TOT_P;
931
932 FUNCTION C_TAXCR_PTD_DBID_P RETURN NUMBER IS
933 BEGIN
934 RETURN C_TAXCR_PTD_DBID;
935 END C_TAXCR_PTD_DBID_P;
936
937 FUNCTION C_TAXCR_YTD_DBID_P RETURN NUMBER IS
938 BEGIN
939 RETURN C_TAXCR_YTD_DBID;
940 END C_TAXCR_YTD_DBID_P;
941
942 FUNCTION C_TAXCR_PTD_TOT_P RETURN NUMBER IS
943 BEGIN
944 RETURN C_TAXCR_PTD_TOT;
945 END C_TAXCR_PTD_TOT_P;
946
947 FUNCTION C_TAXCR_YTD_TOT_P RETURN NUMBER IS
948 BEGIN
949 RETURN C_TAXCR_YTD_TOT;
950 END C_TAXCR_YTD_TOT_P;
951
952 FUNCTION C_ERS_REB_PTD_TOT_P RETURN NUMBER IS
953 BEGIN
954 RETURN C_ERS_REB_PTD_TOT;
955 END C_ERS_REB_PTD_TOT_P;
956
957 FUNCTION C_ERS_REB_YTD_TOT_P RETURN NUMBER IS
958 BEGIN
959 RETURN C_ERS_REB_YTD_TOT;
960 END C_ERS_REB_YTD_TOT_P;
961
962 FUNCTION C_NET_INCOME_TAX_P RETURN NUMBER IS
963 BEGIN
964 RETURN C_NET_INCOME_TAX;
965 END C_NET_INCOME_TAX_P;
966
967 FUNCTION C_GROSS_NIC_P RETURN NUMBER IS
968 BEGIN
969 RETURN C_GROSS_NIC;
970 END C_GROSS_NIC_P;
971
972 FUNCTION C_NIC_REBATE_P RETURN NUMBER IS
973 BEGIN
974 RETURN C_NIC_REBATE;
975 END C_NIC_REBATE_P;
976
977 FUNCTION C_NET_NI_P RETURN NUMBER IS
978 BEGIN
979 RETURN C_NET_NI;
980 END C_NET_NI_P;
981
982 FUNCTION C_TOTAL_AMOUNT_DUE_P RETURN NUMBER IS
983 BEGIN
984 RETURN C_TOTAL_AMOUNT_DUE;
985 END C_TOTAL_AMOUNT_DUE_P;
986
987 FUNCTION C_SAP_PTD_DBID_P RETURN NUMBER IS
988 BEGIN
989 RETURN C_SAP_PTD_DBID;
990 END C_SAP_PTD_DBID_P;
991
992 FUNCTION C_SAP_PTD_TOT_P RETURN NUMBER IS
993 BEGIN
994 RETURN C_SAP_PTD_TOT;
995 END C_SAP_PTD_TOT_P;
996
997 FUNCTION C_SAP_YTD_DBID_P RETURN NUMBER IS
998 BEGIN
999 RETURN C_SAP_YTD_DBID;
1000 END C_SAP_YTD_DBID_P;
1001
1002 FUNCTION C_SAP_YTD_TOT_P RETURN NUMBER IS
1003 BEGIN
1004 RETURN C_SAP_YTD_TOT;
1005 END C_SAP_YTD_TOT_P;
1006
1007 FUNCTION C_SPPB_PTD_DBID_P RETURN NUMBER IS
1008 BEGIN
1009 RETURN C_SPPB_PTD_DBID;
1010 END C_SPPB_PTD_DBID_P;
1011
1012 FUNCTION C_SPPB_PTD_TOT_P RETURN NUMBER IS
1013 BEGIN
1014 RETURN C_SPPB_PTD_TOT;
1015 END C_SPPB_PTD_TOT_P;
1016
1017 FUNCTION C_SPPB_YTD_DBID_P RETURN NUMBER IS
1018 BEGIN
1019 RETURN C_SPPB_YTD_DBID;
1020 END C_SPPB_YTD_DBID_P;
1021
1022 FUNCTION C_SPPB_YTD_TOT_P RETURN NUMBER IS
1023 BEGIN
1024 RETURN C_SPPB_YTD_TOT;
1025 END C_SPPB_YTD_TOT_P;
1026
1027 FUNCTION C_SPPA_PTD_DBID_P RETURN NUMBER IS
1028 BEGIN
1029 RETURN C_SPPA_PTD_DBID;
1030 END C_SPPA_PTD_DBID_P;
1031
1032 FUNCTION C_SPPA_PTD_TOT_P RETURN NUMBER IS
1033 BEGIN
1034 RETURN C_SPPA_PTD_TOT;
1035 END C_SPPA_PTD_TOT_P;
1036
1037 FUNCTION C_SPPA_YTD_DBID_P RETURN NUMBER IS
1038 BEGIN
1039 RETURN C_SPPA_YTD_DBID;
1040 END C_SPPA_YTD_DBID_P;
1041
1042 FUNCTION C_SPPA_YTD_TOT_P RETURN NUMBER IS
1043 BEGIN
1044 RETURN C_SPPA_YTD_TOT;
1045 END C_SPPA_YTD_TOT_P;
1046
1047 FUNCTION C_WORKING_TAXCR_PTD_DBID_P RETURN NUMBER IS
1048 BEGIN
1049 RETURN C_WORKING_TAXCR_PTD_DBID;
1050 END C_WORKING_TAXCR_PTD_DBID_P;
1051
1052 FUNCTION C_WORKING_TAXCR_YTD_DBID_P RETURN NUMBER IS
1053 BEGIN
1054 RETURN C_WORKING_TAXCR_YTD_DBID;
1055 END C_WORKING_TAXCR_YTD_DBID_P;
1056
1057 FUNCTION C_CAT_INPUT_VALUE_ID_P RETURN NUMBER IS
1058 BEGIN
1059 RETURN C_CAT_INPUT_VALUE_ID;
1060 END C_CAT_INPUT_VALUE_ID_P;
1061
1062 FUNCTION C_TY_START_P RETURN DATE IS
1063 BEGIN
1064 RETURN C_TY_START;
1065 END C_TY_START_P;
1066
1067 END PAY_PAYGBTPL_XMLP_PKG;