1 PACKAGE BODY HXC_HXCMISTC_XMLP_PKG AS
2 /* $Header: HXCMISTCB.pls 120.0 2007/12/04 05:40:50 amakrish noship $ */
3 FUNCTION AFTERPFORM RETURN BOOLEAN IS
4 L_COL_1 VARCHAR2(80) := NULL;
5 L_COL_2 VARCHAR2(80) := NULL;
6 L_COL_3 VARCHAR2(80) := NULL;
7 L_COL_4 VARCHAR2(80) := NULL;
8 L_SORT1_LABEL VARCHAR2(80) := NULL;
9 L_SORT2_LABEL VARCHAR2(80) := NULL;
10 L_SORT3_LABEL VARCHAR2(80) := NULL;
11 L_SORT4_LABEL VARCHAR2(80) := NULL;
12 L_DEFINE_MEANING VARCHAR2(80) := NULL;
13 L_APPLICATION_LABEL VARCHAR2(80) := NULL;
14 L_ORG_LABEL VARCHAR2(240) := NULL;
15 L_LOCATION_LABEL VARCHAR2(80) := NULL;
16 L_PAYROLL_LABEL VARCHAR2(80) := NULL;
17 L_SUPERVISOR_LABEL VARCHAR2(80) := NULL;
18 L_EMPOYEE_NAME_LABEL VARCHAR2(80) := NULL;
19 L_EMPLOYEE_NUMBER_LABEL VARCHAR2(80) := NULL;
20 L_PERSON_TYPE VARCHAR2(200) := NULL;
21 L_PERSON_TYPE3 VARCHAR2(200) := NULL;
22 L_ASSIGNMENT_TYPE VARCHAR2(200) := NULL;
23 L_PERSON_TYPE_LABEL VARCHAR2(80) := NULL;
24 L_ASSIGNMENT_TYPE_LABEL VARCHAR2(80) := NULL;
25 L_VENDOR_LABEL VARCHAR2(2000) := NULL;
26 LV_DUMMY VARCHAR2(100);
27 CURSOR C_PER_DTL(CP_PERSON_ID IN NUMBER,CP_EFFECTIVE_DATE IN DATE) IS
28 SELECT
29 PPF.FULL_NAME,
30 NVL(PPF.EMPLOYEE_NUMBER
31 ,PPF.NPW_NUMBER)
32 FROM
33 PER_PEOPLE_F PPF
34 WHERE PPF.PERSON_ID = CP_PERSON_ID
35 AND CP_EFFECTIVE_DATE between PPF.EFFECTIVE_START_DATE
36 AND PPF.EFFECTIVE_END_DATE;
37 CURSOR C_PAYROLL(CP_PAYROLL_ID IN NUMBER,CP_EFFECTIVE_DATE IN DATE) IS
38 SELECT
39 PAY.PAYROLL_NAME
40 FROM
41 PAY_PAYROLLS_F PAY
42 WHERE PAY.PAYROLL_ID = CP_PAYROLL_ID
43 AND CP_EFFECTIVE_DATE between PAY.EFFECTIVE_START_DATE
44 AND PAY.EFFECTIVE_END_DATE;
45 CURSOR C_VENDOR(P_VENDOR_ID IN NUMBER) IS
46 SELECT
47 VENDOR_NAME
48 FROM
49 PO_VENDORS
50 WHERE VENDOR_ID = P_VENDOR_ID;
51 CURSOR C_LOOKUP_MEANING(P_LOOKUP_TYPE IN VARCHAR2,P_LOOKUP_CODE IN VARCHAR2) IS
52 SELECT
53 MEANING
54 FROM
55 HR_LOOKUPS
56 WHERE LOOKUP_TYPE = P_LOOKUP_TYPE
57 AND LOOKUP_CODE = P_LOOKUP_CODE;
58 BEGIN
59 IF P_DEBUG = 'Y' THEN
60 HR_UTILITY.TRACE_ON(NULL
61 ,'MH');
62 END IF;
63 COL_1 := NULL;
64 COL_2 := NULL;
65 COL_3 := NULL;
66 COL_4 := NULL;
67 P_SORT1_LABEL := NULL;
68 P_SORT2_LABEL := NULL;
69 P_SORT3_LABEL := NULL;
70 P_SORT4_LABEL := NULL;
71 SORT_OPTION(P_SORT_OPTION1
72 ,L_COL_1
73 ,L_SORT1_LABEL);
74 SORT_OPTION(P_SORT_OPTION2
75 ,L_COL_2
76 ,L_SORT2_LABEL);
77 SORT_OPTION(P_SORT_OPTION3
78 ,L_COL_3
79 ,L_SORT3_LABEL);
80 SORT_OPTION(P_SORT_OPTION4
81 ,L_COL_4
82 ,L_SORT4_LABEL);
83 COL_1 := L_COL_1;
84 P_SORT1_LABEL := L_SORT1_LABEL;
85 COL_2 := L_COL_2;
86 P_SORT2_LABEL := L_SORT2_LABEL;
87 COL_3 := L_COL_3;
88 P_SORT3_LABEL := L_SORT3_LABEL;
89 COL_4 := L_COL_4;
90 P_SORT4_LABEL := L_SORT4_LABEL;
91 IF COL_1 IS NULL THEN
92 COL_1 := 'hou.name';
93 END IF;
94 IF COL_2 IS NULL THEN
95 COL_2 := 'hl.location_code';
96 END IF;
97 IF COL_3 IS NULL THEN
98 COL_3 := 'ppa.payroll_name';
99 END IF;
100 IF COL_4 IS NULL THEN
101 COL_4 := 'ppf.full_name';
102 END IF;
103 IF P_DEFINE_MISSING IS NOT NULL THEN
104 SELECT
105 MEANING
106 INTO
107 L_DEFINE_MEANING
108 FROM
109 HXC_LOOKUPS
110 WHERE LOOKUP_TYPE = 'HXC_DEFINE_MISSING'
111 AND LOOKUP_CODE = P_DEFINE_MISSING;
112 P_DEFINE_LABEL := L_DEFINE_MEANING;
113 END IF;
114 IF P_APPLICATION IS NOT NULL THEN
115 SELECT
116 NAME
117 INTO
118 P_APPLICATION_LABEL
119 FROM
120 HXC_TIME_RECIPIENTS
121 WHERE TIME_RECIPIENT_ID = P_APPLICATION;
122 END IF;
123 IF P_PERSON_NAME IS NOT NULL THEN
124 OPEN C_PER_DTL(P_PERSON_NAME,P_DATE_TO);
125 FETCH C_PER_DTL
126 INTO
127 P_PERSON_NAME_LABEL
128 ,LV_DUMMY;
129 CLOSE C_PER_DTL;
130 END IF;
131 IF P_PERSON_NUMBER IS NOT NULL THEN
132 OPEN C_PER_DTL(P_PERSON_NUMBER,P_DATE_TO);
133 FETCH C_PER_DTL
134 INTO
135 LV_DUMMY
136 ,P_PERSON_NUMBER_LABEL;
137 CLOSE C_PER_DTL;
138 END IF;
139 IF P_LOCATION IS NOT NULL THEN
140 SELECT
141 LOCATION_CODE
142 INTO
143 P_LOCATION_LABEL
144 FROM
145 HR_LOCATIONS
146 WHERE LOCATION_ID = P_LOCATION;
147 END IF;
148 IF P_ORGANIZATION IS NOT NULL THEN
149 SELECT
150 NAME
151 INTO
152 P_ORGANIZATION_LABEL
153 FROM
154 HR_ORGANIZATION_UNITS
155 WHERE ORGANIZATION_ID = P_ORGANIZATION;
156 END IF;
157 IF P_PAYROLL IS NOT NULL THEN
158 OPEN C_PAYROLL(P_PAYROLL,P_DATE_TO);
159 FETCH C_PAYROLL
160 INTO
161 P_PAYROLL_LABEL;
162 CLOSE C_PAYROLL;
163 END IF;
164 IF P_PAYROLL_ASSIGNMENT_SET IS NOT NULL THEN
165 SELECT
166 ASSIGNMENT_SET_NAME
167 INTO
168 P_ASSIGNMENT_SET_LABEL
169 FROM
170 HR_ASSIGNMENT_SETS
171 WHERE ASSIGNMENT_SET_ID = P_PAYROLL_ASSIGNMENT_SET;
172 END IF;
173 IF P_SUPERVISOR IS NOT NULL THEN
174 OPEN C_PER_DTL(P_SUPERVISOR,P_DATE_TO);
175 FETCH C_PER_DTL
176 INTO
177 P_SUPERVISOR_LABEL
178 ,LV_DUMMY;
179 CLOSE C_PER_DTL;
180 END IF;
181 IF P_VENDOR_ID IS NOT NULL THEN
182 OPEN C_VENDOR(P_VENDOR_ID);
183 FETCH C_VENDOR
184 INTO
185 P_VENDOR_LABEL;
186 CLOSE C_VENDOR;
187 END IF;
188 IF P_PERSON_TYPE IS NOT NULL THEN
189 OPEN C_LOOKUP_MEANING('HXC_PERSON_TYPES',P_PERSON_TYPE);
190 FETCH C_LOOKUP_MEANING
191 INTO
192 P_PERSON_TYPE_LABEL;
193 CLOSE C_LOOKUP_MEANING;
194 END IF;
195 IF P_ASSIGNMENT_TYPE IS NOT NULL THEN
196 OPEN C_LOOKUP_MEANING('HXC_ASSIGNMENT_TYPES',P_ASSIGNMENT_TYPE);
197 FETCH C_LOOKUP_MEANING
198 INTO
199 P_ASSIGNMENT_TYPE_LABEL;
200 CLOSE C_LOOKUP_MEANING;
201 END IF;
202 IF (P_PERSON_TYPE IS NULL) THEN
203 L_PERSON_TYPE := '(''EMP'',''EX_EMP'',''EMP_APL'',''EX_EMP_APL'',''CWK'',''EX_CWK'')';
204 L_PERSON_TYPE3 := '(''EMP_APL'',''EMP'',''CWK'')';
205 ELSE
206 IF (P_PERSON_TYPE = 'EMP') THEN
207 L_PERSON_TYPE := '(''EMP'',''EMP_APL'',''EX_EMP'',''EX_EMP_APL'')';
208 L_PERSON_TYPE3 := '(''EMP_APL'',''EMP'')';
209 ELSIF (P_PERSON_TYPE = 'CWK') THEN
210 L_PERSON_TYPE := '(''CWK'',''EX_CWK'')';
211 L_PERSON_TYPE3 := '(''CWK'')';
212 ELSIF (P_PERSON_TYPE = 'EMP_CWK') THEN
213 L_PERSON_TYPE := '(''EMP'',''EMP_APL'',''EX_EMP'',''EX_EMP_APL'',''CWK'',''EX_CWK'')';
214 L_PERSON_TYPE3 := '(''EMP_APL'',''EMP'',''CWK'')';
215 END IF;
216 END IF;
217 PERSON_TYPE1 := 'and ppf.effective_start_date = (select max(effective_start_date)
218 from per_people_f
219 where person_id = ppf.person_id
220 and effective_start_date <= :p_date_to
221 and effective_end_date >= :p_date_from
222 and ptu.person_id = person_id
223 and ptu.effective_start_date <= :p_date_to
224 and ptu.effective_end_date >= :p_date_from
225 and ppt.person_type_id = ptu.person_type_id
226 --and ppt.person_type_id = person_type_id
227 and ppt.system_person_type in ' || L_PERSON_TYPE || ')';
228 PERSON_TYPE2 := 'and ppt.system_person_type in ' || L_PERSON_TYPE;
229 PERSON_TYPE3 := 'and ppt.system_person_type in ' || L_PERSON_TYPE3;
230 IF (P_ASSIGNMENT_TYPE IS NULL) THEN
231 L_ASSIGNMENT_TYPE := '(''ACTIVE_ASSIGN'',''ACTIVE_CWK'')';
232 ELSE
233 IF (P_ASSIGNMENT_TYPE = 'ACTIVE') THEN
234 L_ASSIGNMENT_TYPE := '(''ACTIVE_ASSIGN'',''ACTIVE_CWK'')';
235 ELSIF (P_ASSIGNMENT_TYPE = 'SUSP') THEN
236 L_ASSIGNMENT_TYPE := '(''SUSP_ASSIGN'',''SUSP_CWK_ASG'')';
237 ELSIF (P_ASSIGNMENT_TYPE = 'TERM') THEN
238 L_ASSIGNMENT_TYPE := '(''TERM_ASSIGN'')';
239 ELSIF (P_ASSIGNMENT_TYPE = 'ACTIVE_SUSP') THEN
240 L_ASSIGNMENT_TYPE := '(''ACTIVE_ASSIGN'',''ACTIVE_CWK'',''SUSP_ASSIGN'',''SUSP_CWK_ASG'',''END'')';
241 ELSIF (P_ASSIGNMENT_TYPE = 'ALL') THEN
242 L_ASSIGNMENT_TYPE := '(''ACTIVE_ASSIGN'',''ACTIVE_CWK'',''SUSP_ASSIGN'',''SUSP_CWK_ASG'',''END'',''TERM_ASSIGN'')';
243 END IF;
244 END IF;
245 ASSIGNMENT_TYPE1 := 'and ast1.per_system_status in ' || L_ASSIGNMENT_TYPE;
246 RETURN (TRUE);
247 END AFTERPFORM;
248
249 FUNCTION CF_APPLICATIONFORMULA RETURN CHAR IS
250 L_ASG_STATUS_TYPE_ID PER_ASSIGNMENTS_F.ASSIGNMENT_STATUS_TYPE_ID%TYPE;
251 L_PAYROLL_ID PER_ASSIGNMENTS_F.PAYROLL_ID%TYPE;
252 L_SOFT_CODING_KEYFLEX_ID PER_ASSIGNMENTS_F.SOFT_CODING_KEYFLEX_ID%TYPE;
253 L_PAY_SYSTEM_STATUS PER_ASSIGNMENT_STATUS_TYPES.PAY_SYSTEM_STATUS%TYPE;
254 L_PAYROLL_NAME PAY_PAYROLLS_F.PAYROLL_NAME%TYPE;
255 L_SCL_TCARD_REQ VARCHAR2(5);
256 BEGIN
257 RETURN L_PAYROLL_NAME;
258 END CF_APPLICATIONFORMULA;
259
260 PROCEDURE SORT_OPTION(L_SORT_OPTION IN VARCHAR2
261 ,L_SORT_BY OUT NOCOPY VARCHAR2
262 ,L_SORT_LABEL OUT NOCOPY VARCHAR2) IS
263 BEGIN
264 IF L_SORT_OPTION = 'APPLICATION' THEN
265 L_SORT_BY := 'hasc.time_recipient_name';
266 L_SORT_LABEL := 'Application';
267 ELSIF L_SORT_OPTION = 'FULL_NAME' THEN
268 L_SORT_BY := 'ppf.full_name';
269 L_SORT_LABEL := 'Person Name';
270 ELSIF L_SORT_OPTION = 'EMPLOYEE_NUMBER' THEN
271 L_SORT_BY := 'lpad(nvl(ppf.employee_number,ppf.npw_number),30,''0'')';
272 L_SORT_LABEL := 'Person Number';
273 ELSIF L_SORT_OPTION = 'LOCATION' THEN
274 L_SORT_BY := 'hl.location_code';
275 L_SORT_LABEL := 'Location';
276 ELSIF L_SORT_OPTION = 'ORGANIZATION' THEN
277 L_SORT_BY := 'hou.name';
278 L_SORT_LABEL := 'Organization';
279 ELSIF L_SORT_OPTION = 'PAYROLL_NAME' THEN
280 L_SORT_BY := 'ppa.payroll_name ';
281 L_SORT_LABEL := 'Payroll Name';
282 ELSIF L_SORT_OPTION = 'SUPERVISOR' THEN
283 L_SORT_BY := 'hxc_tpd_end.get_supervisor_name(asm.supervisor_id,asm.effective_start_date)';
284 L_SORT_LABEL := 'Supervisor Name';
285 ELSIF L_SORT_OPTION = 'PERSON_TYPE' THEN
286 L_SORT_BY := 'ppt.user_person_type';
287 L_SORT_LABEL := 'Person Type';
288 ELSIF L_SORT_OPTION = 'SUPPLIER_ID' THEN
289 L_SORT_BY := 'hxc_missing_tcard_report.get_vendor_name(:p_date_from,:p_date_to,asm.person_id)';
290 L_SORT_LABEL := 'Supplier';
291 END IF;
292 END SORT_OPTION;
293
294 FUNCTION CF_RESOURCE_PREFFORMULA(PERSON_ID1 IN NUMBER) RETURN CHAR IS
295 P_PREF_SPEC_LIST_OUT VARCHAR2(300);
296 I NUMBER(5);
297 L_TCARD_REQ_ATTRI VARCHAR2(20);
298 P_MESSAGE VARCHAR2(30) := NULL;
299 BEGIN
300 P_PREF_SPEC_LIST_OUT := '|' || HXC_PREFERENCE_EVALUATION.RESOURCE_PREF_ERRCODE(PERSON_ID1
301 ,'TS_PER_APPLICATION_SET|1|,TS_PER_TCARD_REQUIRED|1|2|3|4|5|6|7|8|9|10|11|12|13|14|15|16|17|18|19|20|21|22|23|24|25|26|27|28|29|30|'
302 ,P_MESSAGE
303 ,SYSDATE) || '|';
304 IF P_MESSAGE IS NULL THEN
305 FOR i IN 1 .. 31 LOOP
306 SELECT
307 DECODE(SUBSTR(P_PREF_SPEC_LIST_OUT
308 ,(INSTR(P_PREF_SPEC_LIST_OUT
309 ,'|'
310 ,1
311 ,I) + 1)
312 ,(INSTR(P_PREF_SPEC_LIST_OUT
313 ,'|'
314 ,1
315 ,I + 1) - 1) - (INSTR(P_PREF_SPEC_LIST_OUT
316 ,'|'
317 ,1
318 ,I)))
319 ,'null'
320 ,''
321 ,SUBSTR(P_PREF_SPEC_LIST_OUT
322 ,(INSTR(P_PREF_SPEC_LIST_OUT
323 ,'|'
324 ,1
325 ,I) + 1)
326 ,(INSTR(P_PREF_SPEC_LIST_OUT
327 ,'|'
328 ,1
329 ,I + 1) - 1) - (INSTR(P_PREF_SPEC_LIST_OUT
330 ,'|'
331 ,1
332 ,I))))
333 INTO
334 L_TCARD_REQ_ATTRI
335 FROM
336 DUAL;
337 IF I = 1 THEN
338 CP_APPLICATION_SET_ID := L_TCARD_REQ_ATTRI;
339 ELSIF I = 2 THEN
340 CP_TCARD_REQ_ATTR1 := L_TCARD_REQ_ATTRI;
341 ELSIF I = 3 THEN
342 CP_TCARD_REQ_ATTR2 := L_TCARD_REQ_ATTRI;
343 ELSIF I = 4 THEN
344 CP_TCARD_REQ_ATTR3 := L_TCARD_REQ_ATTRI;
345 ELSIF I = 5 THEN
346 CP_TCARD_REQ_ATTR4 := L_TCARD_REQ_ATTRI;
347 ELSIF I = 6 THEN
348 CP_TCARD_REQ_ATTR5 := L_TCARD_REQ_ATTRI;
349 ELSIF I = 7 THEN
350 CP_TCARD_REQ_ATTR6 := L_TCARD_REQ_ATTRI;
351 ELSIF I = 8 THEN
355 ELSIF I = 10 THEN
352 CP_TCARD_REQ_ATTR7 := L_TCARD_REQ_ATTRI;
353 ELSIF I = 9 THEN
354 CP_TCARD_REQ_ATTR8 := L_TCARD_REQ_ATTRI;
356 CP_TCARD_REQ_ATTR9 := L_TCARD_REQ_ATTRI;
357 ELSIF I = 11 THEN
358 CP_TCARD_REQ_ATTR10 := L_TCARD_REQ_ATTRI;
359 ELSIF I = 12 THEN
360 CP_TCARD_REQ_ATTR11 := L_TCARD_REQ_ATTRI;
361 ELSIF I = 13 THEN
362 CP_TCARD_REQ_ATTR12 := L_TCARD_REQ_ATTRI;
363 ELSIF I = 14 THEN
364 CP_TCARD_REQ_ATTR13 := L_TCARD_REQ_ATTRI;
365 ELSIF I = 15 THEN
366 CP_TCARD_REQ_ATTR14 := L_TCARD_REQ_ATTRI;
367 ELSIF I = 16 THEN
368 CP_TCARD_REQ_ATTR15 := L_TCARD_REQ_ATTRI;
369 ELSIF I = 17 THEN
370 CP_TCARD_REQ_ATTR16 := L_TCARD_REQ_ATTRI;
371 ELSIF I = 18 THEN
372 CP_TCARD_REQ_ATTR17 := L_TCARD_REQ_ATTRI;
373 ELSIF I = 19 THEN
374 CP_TCARD_REQ_ATTR18 := L_TCARD_REQ_ATTRI;
375 ELSIF I = 20 THEN
376 CP_TCARD_REQ_ATTR19 := L_TCARD_REQ_ATTRI;
377 ELSIF I = 21 THEN
378 CP_TCARD_REQ_ATTR20 := L_TCARD_REQ_ATTRI;
379 ELSIF I = 22 THEN
380 CP_TCARD_REQ_ATTR21 := L_TCARD_REQ_ATTRI;
381 ELSIF I = 23 THEN
382 CP_TCARD_REQ_ATTR22 := L_TCARD_REQ_ATTRI;
383 ELSIF I = 24 THEN
384 CP_TCARD_REQ_ATTR23 := L_TCARD_REQ_ATTRI;
385 ELSIF I = 25 THEN
386 CP_TCARD_REQ_ATTR24 := L_TCARD_REQ_ATTRI;
387 ELSIF I = 26 THEN
388 CP_TCARD_REQ_ATTR25 := L_TCARD_REQ_ATTRI;
389 ELSIF I = 27 THEN
390 CP_TCARD_REQ_ATTR26 := L_TCARD_REQ_ATTRI;
391 ELSIF I = 28 THEN
392 CP_TCARD_REQ_ATTR27 := L_TCARD_REQ_ATTRI;
393 ELSIF I = 29 THEN
394 CP_TCARD_REQ_ATTR28 := L_TCARD_REQ_ATTRI;
395 ELSIF I = 30 THEN
396 CP_TCARD_REQ_ATTR29 := L_TCARD_REQ_ATTRI;
397 ELSIF I = 31 THEN
398 CP_TCARD_REQ_ATTR30 := L_TCARD_REQ_ATTRI;
399 END IF;
400 END LOOP;
401 END IF;
402 RETURN P_PREF_SPEC_LIST_OUT;
403 END CF_RESOURCE_PREFFORMULA;
404
405 FUNCTION G_START_TIMEGROUPFILTER(APPROVAL_STATUS IN VARCHAR2
406 ,P_COUNT IN NUMBER
407 ,RESOURCE_ID1 IN NUMBER) RETURN BOOLEAN IS
408 BEGIN
409 HR_UTILITY.TRACE('g_start_time group_filter');
410 HR_UTILITY.TRACE('define_missing:' || P_DEFINE_MISSING);
411 HR_UTILITY.TRACE('approval_status:' || APPROVAL_STATUS);
412 HR_UTILITY.TRACE('count:' || P_COUNT);
413 HR_UTILITY.TRACE('resource_id1:' || RESOURCE_ID1);
414 IF P_COUNT > 0 AND APPROVAL_STATUS < 'NOT ENTERED' THEN
415 HR_UTILITY.SET_LOCATION('g_start_time'
416 ,10);
417 RETURN (TRUE);
418 END IF;
419 IF P_COUNT = 0 AND APPROVAL_STATUS = 'NOT ENTERED' THEN
420 HR_UTILITY.SET_LOCATION('g_start_time'
421 ,11);
422 RETURN (FALSE);
423 END IF;
424 IF P_DEFINE_MISSING = '01' AND APPROVAL_STATUS = 'NOT ENTERED' THEN
425 HR_UTILITY.SET_LOCATION('g_start_time'
426 ,20);
427 RETURN (TRUE);
428 ELSIF P_DEFINE_MISSING = '02' AND APPROVAL_STATUS in ('NOT ENTERED','WORKING') THEN
429 HR_UTILITY.SET_LOCATION('g_start_time'
430 ,30);
431 RETURN (TRUE);
432 ELSIF P_DEFINE_MISSING = '03' AND APPROVAL_STATUS in ('NOT ENTERED','WORKING','REJECTED') THEN
433 HR_UTILITY.SET_LOCATION('g_start_time'
434 ,40);
435 RETURN (TRUE);
436 ELSIF P_DEFINE_MISSING = '04' AND APPROVAL_STATUS < 'APPROVED' THEN
437 HR_UTILITY.SET_LOCATION('g_start_time'
438 ,50);
439 RETURN (TRUE);
440 END IF;
441 RETURN (FALSE);
442 END G_START_TIMEGROUPFILTER;
443
444 FUNCTION G_ROWNUMGROUPFILTER(START_TIME1 IN DATE) RETURN BOOLEAN IS
445 BEGIN
446 IF START_TIME1 IS NULL THEN
447 RETURN FALSE;
448 END IF;
449 RETURN (TRUE);
450 END G_ROWNUMGROUPFILTER;
451
452 FUNCTION BEFOREREPORT RETURN BOOLEAN IS
453 BEGIN
454 P_CONC_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
455 RETURN (TRUE);
456 END BEFOREREPORT;
457
458 FUNCTION AFTERREPORT RETURN BOOLEAN IS
459 BEGIN
460 RETURN (TRUE);
461 END AFTERREPORT;
462
463 FUNCTION CP_PAYROLL_NAME_P RETURN VARCHAR2 IS
464 BEGIN
465 RETURN CP_PAYROLL_NAME;
466 END CP_PAYROLL_NAME_P;
467
468 FUNCTION CP_SCL_TCARD_REQ_P RETURN VARCHAR2 IS
469 BEGIN
470 RETURN CP_SCL_TCARD_REQ;
471 END CP_SCL_TCARD_REQ_P;
472
473 FUNCTION CP_APPLICATION_SET_ID_P RETURN VARCHAR2 IS
474 BEGIN
475 RETURN CP_APPLICATION_SET_ID;
476 END CP_APPLICATION_SET_ID_P;
477
478 FUNCTION CP_TCARD_REQ_ATTR1_P RETURN VARCHAR2 IS
479 BEGIN
480 RETURN CP_TCARD_REQ_ATTR1;
481 END CP_TCARD_REQ_ATTR1_P;
482
483 FUNCTION CP_TCARD_REQ_ATTR2_P RETURN VARCHAR2 IS
484 BEGIN
485 RETURN CP_TCARD_REQ_ATTR2;
486 END CP_TCARD_REQ_ATTR2_P;
487
488 FUNCTION CP_TCARD_REQ_ATTR3_P RETURN VARCHAR2 IS
489 BEGIN
490 RETURN CP_TCARD_REQ_ATTR3;
491 END CP_TCARD_REQ_ATTR3_P;
492
493 FUNCTION CP_TCARD_REQ_ATTR4_P RETURN VARCHAR2 IS
494 BEGIN
495 RETURN CP_TCARD_REQ_ATTR4;
496 END CP_TCARD_REQ_ATTR4_P;
497
498 FUNCTION CP_TCARD_REQ_ATTR5_P RETURN VARCHAR2 IS
499 BEGIN
500 RETURN CP_TCARD_REQ_ATTR5;
501 END CP_TCARD_REQ_ATTR5_P;
502
503 FUNCTION CP_TCARD_REQ_ATTR6_P RETURN VARCHAR2 IS
504 BEGIN
508 FUNCTION CP_TCARD_REQ_ATTR7_P RETURN VARCHAR2 IS
505 RETURN CP_TCARD_REQ_ATTR6;
506 END CP_TCARD_REQ_ATTR6_P;
507
509 BEGIN
510 RETURN CP_TCARD_REQ_ATTR7;
511 END CP_TCARD_REQ_ATTR7_P;
512
513 FUNCTION CP_TCARD_REQ_ATTR8_P RETURN VARCHAR2 IS
514 BEGIN
515 RETURN CP_TCARD_REQ_ATTR8;
516 END CP_TCARD_REQ_ATTR8_P;
517
518 FUNCTION CP_TCARD_REQ_ATTR9_P RETURN VARCHAR2 IS
519 BEGIN
520 RETURN CP_TCARD_REQ_ATTR9;
521 END CP_TCARD_REQ_ATTR9_P;
522
523 FUNCTION CP_TCARD_REQ_ATTR10_P RETURN VARCHAR2 IS
524 BEGIN
525 RETURN CP_TCARD_REQ_ATTR10;
526 END CP_TCARD_REQ_ATTR10_P;
527
528 FUNCTION CP_TCARD_REQ_ATTR11_P RETURN VARCHAR2 IS
529 BEGIN
530 RETURN CP_TCARD_REQ_ATTR11;
531 END CP_TCARD_REQ_ATTR11_P;
532
533 FUNCTION CP_TCARD_REQ_ATTR12_P RETURN VARCHAR2 IS
534 BEGIN
535 RETURN CP_TCARD_REQ_ATTR12;
536 END CP_TCARD_REQ_ATTR12_P;
537
538 FUNCTION CP_TCARD_REQ_ATTR13_P RETURN VARCHAR2 IS
539 BEGIN
540 RETURN CP_TCARD_REQ_ATTR13;
541 END CP_TCARD_REQ_ATTR13_P;
542
543 FUNCTION CP_TCARD_REQ_ATTR14_P RETURN VARCHAR2 IS
544 BEGIN
545 RETURN CP_TCARD_REQ_ATTR14;
546 END CP_TCARD_REQ_ATTR14_P;
547
548 FUNCTION CP_TCARD_REQ_ATTR15_P RETURN VARCHAR2 IS
549 BEGIN
550 RETURN CP_TCARD_REQ_ATTR15;
551 END CP_TCARD_REQ_ATTR15_P;
552
553 FUNCTION CP_TCARD_REQ_ATTR16_P RETURN VARCHAR2 IS
554 BEGIN
555 RETURN CP_TCARD_REQ_ATTR16;
556 END CP_TCARD_REQ_ATTR16_P;
557
558 FUNCTION CP_TCARD_REQ_ATTR17_P RETURN VARCHAR2 IS
559 BEGIN
560 RETURN CP_TCARD_REQ_ATTR17;
561 END CP_TCARD_REQ_ATTR17_P;
562
563 FUNCTION CP_TCARD_REQ_ATTR18_P RETURN VARCHAR2 IS
564 BEGIN
565 RETURN CP_TCARD_REQ_ATTR18;
566 END CP_TCARD_REQ_ATTR18_P;
567
568 FUNCTION CP_TCARD_REQ_ATTR19_P RETURN VARCHAR2 IS
569 BEGIN
570 RETURN CP_TCARD_REQ_ATTR19;
571 END CP_TCARD_REQ_ATTR19_P;
572
573 FUNCTION CP_TCARD_REQ_ATTR20_P RETURN VARCHAR2 IS
574 BEGIN
575 RETURN CP_TCARD_REQ_ATTR20;
576 END CP_TCARD_REQ_ATTR20_P;
577
578 FUNCTION CP_TCARD_REQ_ATTR21_P RETURN VARCHAR2 IS
579 BEGIN
580 RETURN CP_TCARD_REQ_ATTR21;
581 END CP_TCARD_REQ_ATTR21_P;
582
583 FUNCTION CP_TCARD_REQ_ATTR22_P RETURN VARCHAR2 IS
584 BEGIN
585 RETURN CP_TCARD_REQ_ATTR22;
586 END CP_TCARD_REQ_ATTR22_P;
587
588 FUNCTION CP_TCARD_REQ_ATTR23_P RETURN VARCHAR2 IS
589 BEGIN
590 RETURN CP_TCARD_REQ_ATTR23;
591 END CP_TCARD_REQ_ATTR23_P;
592
593 FUNCTION CP_TCARD_REQ_ATTR24_P RETURN VARCHAR2 IS
594 BEGIN
595 RETURN CP_TCARD_REQ_ATTR24;
596 END CP_TCARD_REQ_ATTR24_P;
597
598 FUNCTION CP_TCARD_REQ_ATTR25_P RETURN VARCHAR2 IS
599 BEGIN
600 RETURN CP_TCARD_REQ_ATTR25;
601 END CP_TCARD_REQ_ATTR25_P;
602
603 FUNCTION CP_TCARD_REQ_ATTR26_P RETURN VARCHAR2 IS
604 BEGIN
605 RETURN CP_TCARD_REQ_ATTR26;
606 END CP_TCARD_REQ_ATTR26_P;
607
608 FUNCTION CP_TCARD_REQ_ATTR27_P RETURN VARCHAR2 IS
609 BEGIN
610 RETURN CP_TCARD_REQ_ATTR27;
611 END CP_TCARD_REQ_ATTR27_P;
612
613 FUNCTION CP_TCARD_REQ_ATTR28_P RETURN VARCHAR2 IS
614 BEGIN
615 RETURN CP_TCARD_REQ_ATTR28;
616 END CP_TCARD_REQ_ATTR28_P;
617
618 FUNCTION CP_TCARD_REQ_ATTR29_P RETURN VARCHAR2 IS
619 BEGIN
620 RETURN CP_TCARD_REQ_ATTR29;
621 END CP_TCARD_REQ_ATTR29_P;
622
623 FUNCTION CP_TCARD_REQ_ATTR30_P RETURN VARCHAR2 IS
624 BEGIN
625 RETURN CP_TCARD_REQ_ATTR30;
626 END CP_TCARD_REQ_ATTR30_P;
627
628 END HXC_HXCMISTC_XMLP_PKG;