[Home] [Help]
PACKAGE BODY: APPS.BEN_BENERPER_XMLP_PKG
Source
1 PACKAGE BODY BEN_BENERPER_XMLP_PKG AS
2 /* $Header: BENERPERB.pls 120.1 2007/12/10 08:31:45 vjaganat noship $ */
3
4 function CF_STANDARD_HEADERFormula return Number is
5 l_concurrent_program_name fnd_concurrent_programs_tl.user_concurrent_program_name%type ; l_process_date varchar2(30);
6 l_mode hr_lookups.meaning%type ;
7 l_derivable_factors hr_lookups.meaning%type ;
8 l_validate hr_lookups.meaning%type ;
9 l_person per_people_f.full_name%type ;
10 l_person_type per_person_types.user_person_type%type ;
11 l_program ben_pgm_f.name%type ;
12 l_business_group per_business_groups.name%type ;
13 l_plan ben_pl_f.name%type ;
14 l_enrollment_type_cycle varchar2(800);
15 l_plans_not_in_programs hr_lookups.meaning%type ;
16 l_just_programs hr_lookups.meaning%type ;
17 l_comp_object_selection_rule ff_formulas_f.formula_name%type ;
18 l_person_selection_rule ff_formulas_f.formula_name%type ;
19 l_life_event_reason ben_ler_f.name%type ;
20 l_organization hr_all_organization_units.name%type ;
21 l_postal_zip_range varchar2(80);
22 l_reporting_group ben_rptg_grp.name%type ;
23 l_plan_type ben_pl_typ_f.name%type ;
24 l_option ben_opt_f.name%type ;
25 l_eligibility_profile ben_eligy_prfl_f.name%type ;
26 l_variable_rate_profile ben_vrbl_rt_prfl_f.name%type ;
27 l_legal_entity hr_all_organization_units.name%type ;
28 l_payroll pay_payrolls_f.payroll_name%type ;
29 l_status fnd_lookups.meaning%type ;
30 l_debug_message varchar2(80);
31 l_location hr_locations_all.description%type ; l_audit_log hr_lookups.meaning%type ; l_benft_group ben_benfts_grp.name%type ; l_date_from varchar2(30);
32
33
34 L01 varchar2(80); L02 varchar2(80); L03 varchar2(80); L04 varchar2(80); L05 varchar2(80);
35 L06 varchar2(80); L07 varchar2(80); L08 varchar2(80); L09 varchar2(80); L10 varchar2(80);
36 L11 varchar2(80); L12 varchar2(80); L13 varchar2(80); L14 varchar2(80); L15 varchar2(80);
37 L16 varchar2(80); L17 varchar2(80); L18 varchar2(80); L19 varchar2(80); L20 varchar2(80);
38 begin
39
40
41 ben_batch_utils.standard_header
42 (p_concurrent_request_id => P_CONCURRENT_REQUEST_ID,
43 p_concurrent_program_name => L_CONCURRENT_PROGRAM_NAME,
44 p_process_date => L_PROCESS_DATE,
45 p_mode => L_MODE,
46 p_derivable_factors => L_DERIVABLE_FACTORS,
47 p_validate => L_VALIDATE,
48 p_person => L_PERSON,
49 p_person_type => L_PERSON_TYPE,
50 p_program => L_PROGRAM,
51 p_business_group => L_BUSINESS_GROUP,
52 p_plan => L_PLAN,
53 p_popl_enrt_typ_cycl => L_ENROLLMENT_TYPE_CYCLE,
54 p_plans_not_in_programs => L_PLANS_NOT_IN_PROGRAMS,
55 p_just_programs => L_JUST_PROGRAMS,
56 p_comp_object_selection_rule => L_COMP_OBJECT_SELECTION_RULE,
57 p_person_selection_rule => L_PERSON_SELECTION_RULE,
58 p_life_event_reason => L_LIFE_EVENT_REASON,
59 p_organization => L_ORGANIZATION,
60 p_postal_zip_range => L_POSTAL_ZIP_RANGE,
61 p_reporting_group => L_REPORTING_GROUP,
62 p_plan_type => L_PLAN_TYPE,
63 p_option => L_OPTION,
64 p_eligibility_profile => L_ELIGIBILITY_PROFILE,
65 p_variable_rate_profile => L_VARIABLE_RATE_PROFILE,
66 p_legal_entity => L_LEGAL_ENTITY,
67 p_payroll => L_PAYROLL,
68 p_debug_message => L_DEBUG_MESSAGE,
69 p_location => L_LOCATION,
70 p_audit_log => L_AUDIT_LOG,
71 p_benfts_group => L_BENFT_GROUP,
72 p_status => L_STATUS,
73 p_date_from => L_DATE_FROM);
74 CP_CONCURRENT_PROGRAM_NAME := l_concurrent_program_name;
75 CP_PROCESS_DATE := l_process_date;
76 CP_MODE := l_mode;
77 CP_DERIVABLE_FACTORS := l_derivable_factors;
78 CP_VALIDATE := l_validate;
79 CP_PERSON := l_person;
80 CP_PERSON_TYPE := l_person_type;
81 CP_PROGRAM := l_program;
82 CP_BUSINESS_GROUP := l_business_group;
83 CP_PLAN := l_plan;
84 CP_ENROLLMENT_TYPE_CYCLE := l_enrollment_type_cycle;
85 CP_PLANS_NOT_IN_PROGRAMS := l_plans_not_in_programs;
86 CP_JUST_PROGRAMS := l_just_programs;
87 CP_COMP_OBJECT_SELECTION_RULE := l_comp_object_selection_rule;
88 CP_PERSON_SELECTION_RULE := l_person_selection_rule;
89 CP_LIFE_EVENT_REASON := l_life_event_reason;
90 CP_ORGANIZATION := l_organization;
91 CP_POSTAL_ZIP_RANGE := l_postal_zip_range;
92 CP_REPORTING_GROUP := l_reporting_group;
93 CP_PLAN_TYPE := l_plan_type;
94 CP_OPTION := l_option;
95 CP_ELIGIBILITY_PROFILE := l_eligibility_profile;
96 CP_VARIABLE_RATE_PROFILE := l_variable_rate_profile;
97 CP_LEGAL_ENTITY := l_legal_entity;
98 CP_PAYROLL := l_payroll;
99 CP_DEBUG_MESSAGE := l_debug_message;
100 CP_LOCATION := l_location;
101 CP_AUDIT_LOG := l_audit_log;
102 CP_BENFT_GROUP := l_benft_group;
103 CP_STATUS := l_status;
104 CP_START_DATE := l_date_From;
105 begin
106 select date_from, uneai_effective_date into CP_FROM_OCRD_DT, CP_TO_OCRD_DT
107 from ben_benefit_actions
108 where request_id = P_CONCURRENT_REQUEST_ID;
109
110 exception when no_data_found then
111 null;
112 end;
113 begin
114 select hl.meaning into CP_BCKT_STAT_CD
115 from ben_benefit_actions bft, hr_lookups hl
116 where bft.PTNL_LER_FOR_PER_STAT_CD = hl.lookup_code
117 and hl.lookup_type = 'BEN_PTNL_LER_FOR_PER_STAT'
118 and bft.request_id = P_CONCURRENT_REQUEST_ID;
119
120 exception when no_data_found then
121 null;
122 end;
123
124 BEN_BATCH_UTILS.get_rpt_header
125 (p_concurrent_request_id => P_CONCURRENT_REQUEST_ID
126 ,p_cd_1 => L01
127 ,p_cd_2 => L02
128 ,p_cd_3 => L03
129 ,p_cd_4 => L04
130 ,p_cd_5 => L05
131 ,p_cd_6 => L06
132 ,p_cd_7 => L07
133 ,p_cd_8 => L08
134 ,p_cd_9 => L09
135 ,p_cd_10 => L10
136 ,p_cd_11 => L11
137 ,p_cd_12 => L12
138 ,p_cd_13 => L13
139 ,p_cd_14 => L14
140 ,p_cd_15 => L15
141 ,p_cd_16 => L16
142 ,p_cd_17 => L17
143 ,p_cd_18 => L18
144 ,p_cd_19 => L19
145 ,p_cd_20 => L20
146 );
147 CD_01 := L01;
148 CD_02 := L02;
149 CD_03 := L03;
150 CD_04 := L04;
151 CD_05 := L05;
152 CD_06 := L06;
153 CD_07 := L07;
154 CD_08 := L08;
155 CD_09 := L09;
156 CD_10 := L10;
157 CD_11 := L11;
158 CD_12 := L12;
159 CD_13 := L13;
160 CD_14 := L14;
161 CD_15 := L15;
162 CD_16 := L16;
163 CD_17 := L17;
164 CD_18 := L18;
165 CD_19 := L19;
166 CD_20 := L20;
167 CV_01 := get_val(L01);
168 CV_02 := get_val(L02);
169 CV_03 := get_val(L03);
170 CV_04 := get_val(L04);
171 CV_05 := get_val(L05);
172 CV_06 := get_val(L06);
173 CV_07 := get_val(L07);
174 CV_08 := get_val(L08);
175 CV_09 := get_val(L09);
176 CV_10 := get_val(L10);
177 CV_11 := get_val(L11);
178 CV_12 := get_val(L12);
179 CV_13 := get_val(L13);
180 CV_14 := get_val(L14);
181 CV_15 := get_val(L15);
182 CV_16 := get_val(L16);
183 CV_17 := get_val(L17);
184 CV_18 := get_val(L18);
185 CV_19 := get_val(L19);
186 CV_20 := get_val(L20);
187
188 return 1;
189 end;
190
191 function CF_1Formula return Number is
192 l_start_date varchar2(30);
193 l_end_date varchar2(30);
194 l_start_time varchar2(30);
195 l_end_time varchar2(30);
196 l_elapsed_time varchar2(30);
197 l_persons_selected varchar2(30);
198 l_persons_processed varchar2(30);
199 l_persons_errored varchar2(30);
200 l_persons_processed_succ varchar2(30);
201 l_persons_unprocessed varchar2(30);
202 begin
203 ben_batch_reporting.process_information
204 (p_concurrent_request_id => P_CONCURRENT_REQUEST_ID,
205 p_start_date => L_START_DATE,
206 p_end_date => L_END_DATE,
207 p_start_time => L_START_TIME,
208 p_end_time => L_END_TIME,
209 p_elapsed_time => L_ELAPSED_TIME,
210 p_persons_selected => L_PERSONS_SELECTED,
211 p_persons_processed => L_PERSONS_PROCESSED,
212 p_persons_unprocessed => L_PERSONS_UNPROCESSED,
213 p_persons_processed_succ => L_PERSONS_PROCESSED_SUCC,
214 p_persons_errored => L_PERSONS_ERRORED);
215 CP_START_DATE := l_start_date;
216 CP_END_DATE := l_end_date;
217 CP_START_TIME := l_start_time;
218 CP_END_TIME := l_end_time;
219 CP_ELAPSED_TIME := l_elapsed_time;
220 CP_PERSONS_SELECTED := l_persons_selected;
221 CP_PERSONS_PROCESSED := l_persons_processed;
222 CP_PERSONS_ERRORED := l_persons_errored;
223 CP_PERSONS_UNPROCESSED := l_persons_unprocessed;
224 CP_PERSONS_PROCESSED_SUCC := l_persons_processed_succ;
225 return 1;
226 end;
227
228 FUNCTION Get_val (p_cd varchar2) RETURN varchar2 IS
229 l_str Varchar2(240) := null;
230 BEGIN
231 If (p_cd in ('P_EFFECTIVE_DATE')) then
232 l_str := CP_PROCESS_DATE;
233 Elsif (p_cd in ('P_MODE')) then
234 l_str := NVL(CP_MODE,'ALL');
235 Elsif (p_cd in ('P_DERIVABLE_FACTORS')) then
236 l_str := NVL(CP_DERIVABLE_FACTORS,'ALL');
237 Elsif (p_cd in ('P_VALIDATE')) then
238 l_str := CP_VALIDATE;
239 Elsif (p_cd in ('P_PERSON_ID')) then
240 l_str := NVL(CP_PERSON,'ALL');
241 Elsif (p_cd in ('P_PERSON_TYPE_ID')) then
242 l_str := NVL(CP_PERSON_TYPE,'ALL');
243 Elsif (p_cd in ('P_PGM_ID')) then
244 l_str := NVL(CP_PROGRAM,'ALL');
245 Elsif (p_cd in ('P_BUSINESS_GROUP_ID')) then
246 l_str := CP_BUSINESS_GROUP;
247 Elsif (p_cd in ('P_PL_ID')) then
248 l_str := NVL(CP_PLAN,'ALL');
249 Elsif (p_cd in ('P_GROUP_PL_ID')) then
250 l_str := NVL(CP_PLAN,'ALL');
251 Elsif (p_cd in ('P_POPL_ENRT_TYP_CYCL_ID')) then
252 l_str := NVL(CP_ENROLLMENT_TYPE_CYCLE,'ALL');
253 Elsif (p_cd in ('P_NO_PROGRAMS_FLAG')) then
254 l_str := CP_PLANS_NOT_IN_PROGRAMS ;
255 Elsif (p_cd in ('P_NO_PLANS_FLAG ')) then
256 l_str := CP_JUST_PROGRAMS;
257 Elsif (p_cd in ('P_COMP_SELECTION_RL')) then
258 l_str := NVL(CP_COMP_OBJECT_SELECTION_RULE,'ALL');
259 Elsif (p_cd in ('P_PERSON_SELECTION_RULE_ID')) then
260 l_str := NVL(CP_PERSON_SELECTION_RULE,'ALL') ;
261 Elsif (p_cd in ('P_LER_ID')) then
262 l_str := NVL(CP_LIFE_EVENT_REASON,'ALL');
263 Elsif (p_cd in ('P_LIFE_EVENT_ID')) then
264 l_str := NVL(CP_LIFE_EVENT_REASON,'ALL');
265 Elsif (p_cd in ('P_OCRD_DATE')) then
266 l_str := NVL(CP_START_DATE,'ALL');
267 Elsif (p_cd in ('P_ORGANIZATION_ID')) then
268 l_str := NVL(CP_ORGANIZATION,'ALL');
269 Elsif (p_cd in ('P_PSTL_ZIP_RNG_ID')) then
270 l_str := NVL(CP_POSTAL_ZIP_RANGE,'ALL');
271 Elsif (p_cd in ('P_RPTG_GRP_ID')) then
272 l_str := NVL(CP_REPORTING_GROUP,'ALL');
273 Elsif (p_cd in ('P_PL_TYP_ID')) then
274 l_str := NVL(CP_PLAN_TYPE,'ALL');
275 Elsif (p_cd in ('P_OPT_ID')) then
276 l_str := NVL(CP_OPTION,'ALL');
277 Elsif (p_cd in ('P_ELIGY_PRFL_ID')) then
278 l_str := NVL(CP_ELIGIBILITY_PROFILE,'ALL');
279 Elsif (p_cd in ('P_VRBL_RT_PRFL_ID')) then
280 l_str := NVL(CP_VARIABLE_RATE_PROFILE,'ALL');
281 Elsif (p_cd in ('P_LEGAL_ENTITY_ID')) then
282 l_str := NVL(CP_LEGAL_ENTITY,'ALL');
283 Elsif (p_cd in ('P_PAYROLL_ID')) then
284 l_str := NVL(CP_PAYROLL,'ALL');
285 Elsif (p_cd in ('P_LOCATION_ID')) then
286 l_str := NVL(CP_LOCATION, 'ALL');
287 Elsif (p_cd in ('P_DEBUG_MESSAGES', 'P_DEBUG_MESSAGE')) then
288 l_str := NVL(CP_DEBUG_MESSAGE, 'ALL');
289 Elsif (p_cd in ('P_AUDIT_LOG')) then
290 l_str := NVL(CP_AUDIT_LOG, 'ALL');
291 Elsif (p_cd in ('P_BENFTS_GRP_ID')) then
292 l_str := NVL(CP_BENFT_GROUP, 'ALL');
293 Elsif (p_cd in ('P_FROM_OCRD_DATE')) then
294 l_str := NVL(CP_FROM_OCRD_DT, '');
295 Elsif (p_cd in ('P_TO_OCRD_DATE')) then
296 l_str := NVL(CP_TO_OCRD_DT, '');
297 Elsif (p_cd in ('P_BCKT_STAT_CD')) then
298 l_str := NVL(CP_BCKT_STAT_CD, '');
299
300 Elsif (p_cd in ('P_ABS_LER')) then
301 l_str := 'N' ;
302
303 Elsif (p_cd is NULL) then
304 l_str := NULL;
305 Else
306 l_str := 'ERR';
307 End if;
308 return l_str;
309 RETURN NULL; Exception
310 When others then
311 return 'ERR';
312 END;
313
314 function BeforePForm return boolean is
315 begin
316
317 return (TRUE);
318 end;
319
320 function AfterPForm return boolean is
321 CURSOR c_conc_pgm_name (cv_request_id number) is
322 SELECT fcp.concurrent_program_name
323 FROM ben_benefit_actions bft, fnd_concurrent_programs fcp
324 WHERE bft.program_id = fcp.concurrent_program_id
325 AND bft.request_id = cv_request_id;
326 l_source_program varchar2(30);
327 begin
328
329 if P_CONCURRENT_REQUEST_ID is not null
330 then
331 open c_conc_pgm_name(P_CONCURRENT_REQUEST_ID);
332 fetch c_conc_pgm_name into l_source_program;
333 if l_source_program = 'BENCWBBO'
334 then
335 run_mode := 'CWBGLOBAL_BKOUT';
336 elsif l_source_program = 'BENIRCBO'
337 then
338 run_mode := 'IREC_BKOUT';
339 else
340 run_mode := 'OTHERS';
341 end if;
342 close c_conc_pgm_name;
343 else
344 run_mode := 'OTHERS';
345 end if;
346 P_CONC_REQUEST_ID := P_CONCURRENT_REQUEST_ID;
347 return (TRUE);
348 end;
349
350 function BeforeReport return boolean is
351 begin
352 -- hr_standard.event('BEFORE REPORT');
353 return (TRUE);
354 end;
355
356 function AfterReport return boolean is
357 begin
358 -- hr_standard.event('AFTER REPORT');
359 return (TRUE);
360 end;
361
362 --Functions to refer Oracle report placeholders--
363
364 Function CP_PROCESS_DATE_p return varchar2 is
365 Begin
366 return CP_PROCESS_DATE;
367 END;
368 Function CP_DERIVABLE_FACTORS_p return varchar2 is
369 Begin
370 return CP_DERIVABLE_FACTORS;
371 END;
372 Function CP_VALIDATE_p return varchar2 is
373 Begin
374 return CP_VALIDATE;
375 END;
376 Function CP_PERSON_p return varchar2 is
377 Begin
378 return CP_PERSON;
379 END;
380 Function CP_PERSON_TYPE_p return varchar2 is
381 Begin
382 return CP_PERSON_TYPE;
383 END;
384 Function CP_PROGRAM_p return varchar2 is
385 Begin
386 return CP_PROGRAM;
387 END;
388 Function CP_BUSINESS_GROUP_p return varchar2 is
389 Begin
390 return CP_BUSINESS_GROUP;
391 END;
392 Function CP_PLAN_p return varchar2 is
393 Begin
394 return CP_PLAN;
395 END;
396 Function CP_ENROLLMENT_TYPE_CYCLE_p return varchar2 is
397 Begin
398 return CP_ENROLLMENT_TYPE_CYCLE;
399 END;
400 Function CP_PLANS_NOT_IN_PROGRAMS_p return varchar2 is
401 Begin
402 return CP_PLANS_NOT_IN_PROGRAMS;
403 END;
404 Function CP_JUST_PROGRAMS_p return varchar2 is
405 Begin
406 return CP_JUST_PROGRAMS;
407 END;
408 Function CP_COMP_OBJECT_SELECTION_RULE1 return varchar2 is
409 Begin
410 return CP_COMP_OBJECT_SELECTION_RULE;
411 END;
412 Function CP_PERSON_SELECTION_RULE_p return varchar2 is
413 Begin
414 return CP_PERSON_SELECTION_RULE;
415 END;
416 Function CP_LIFE_EVENT_REASON_p return varchar2 is
417 Begin
418 return CP_LIFE_EVENT_REASON;
419 END;
420 Function CP_ORGANIZATION_p return varchar2 is
421 Begin
422 return CP_ORGANIZATION;
423 END;
424 Function CP_POSTAL_ZIP_RANGE_p return varchar2 is
425 Begin
426 return CP_POSTAL_ZIP_RANGE;
427 END;
428 Function CP_REPORTING_GROUP_p return varchar2 is
429 Begin
430 return CP_REPORTING_GROUP;
431 END;
432 Function CP_PLAN_TYPE_p return varchar2 is
433 Begin
434 return CP_PLAN_TYPE;
435 END;
436 Function CP_OPTION_p return varchar2 is
437 Begin
438 return CP_OPTION;
439 END;
440 Function CP_ELIGIBILITY_PROFILE_p return varchar2 is
441 Begin
442 return CP_ELIGIBILITY_PROFILE;
443 END;
444 Function CP_VARIABLE_RATE_PROFILE_p return varchar2 is
445 Begin
446 return CP_VARIABLE_RATE_PROFILE;
447 END;
448 Function CP_LEGAL_ENTITY_p return varchar2 is
449 Begin
450 return CP_LEGAL_ENTITY;
451 END;
452 Function CP_PAYROLL_p return varchar2 is
453 Begin
454 return CP_PAYROLL;
455 END;
456 Function CP_CONCURRENT_PROGRAM_NAME_p return varchar2 is
457 Begin
458 return CP_CONCURRENT_PROGRAM_NAME;
459 END;
460 Function CP_MODE_p return varchar2 is
461 Begin
462 return CP_MODE;
463 END;
464 Function CP_STATUS_p return varchar2 is
465 Begin
466 return CP_STATUS;
467 END;
468 Function CP_START_DATE_p return varchar2 is
469 Begin
470 return CP_START_DATE;
471 END;
472 Function CP_END_DATE_p return varchar2 is
473 Begin
474 return CP_END_DATE;
475 END;
476 Function CP_START_TIME_p return varchar2 is
477 Begin
478 return CP_START_TIME;
479 END;
480 Function CP_END_TIME_p return varchar2 is
481 Begin
482 return CP_END_TIME;
483 END;
484 Function CP_ELAPSED_TIME_p return varchar2 is
485 Begin
486 return CP_ELAPSED_TIME;
487 END;
488 Function CP_PERSONS_SELECTED_p return number is
489 Begin
490 return CP_PERSONS_SELECTED;
491 END;
492 Function CP_PERSONS_PROCESSED_p return number is
493 Begin
494 return CP_PERSONS_PROCESSED;
495 END;
496 Function CP_PERSONS_ERRORED_p return number is
497 Begin
498 return CP_PERSONS_ERRORED;
499 END;
500 Function CP_PERSONS_UNPROCESSED_p return number is
501 Begin
502 return CP_PERSONS_UNPROCESSED;
503 END;
504 Function CP_PERSONS_PROCESSED_SUCC_p return number is
505 Begin
506 return CP_PERSONS_PROCESSED_SUCC;
507 END;
508 Function CD_01_p return varchar2 is
509 Begin
510 return CD_01;
511 END;
512 Function CD_02_p return varchar2 is
513 Begin
514 return CD_02;
515 END;
516 Function CD_03_p return varchar2 is
517 Begin
518 return CD_03;
519 END;
520 Function CD_04_p return varchar2 is
521 Begin
522 return CD_04;
523 END;
524 Function CD_05_p return varchar2 is
525 Begin
526 return CD_05;
527 END;
528 Function CD_06_p return varchar2 is
529 Begin
530 return CD_06;
531 END;
532 Function CD_07_p return varchar2 is
533 Begin
534 return CD_07;
535 END;
536 Function CD_08_p return varchar2 is
537 Begin
538 return CD_08;
539 END;
540 Function CD_09_p return varchar2 is
541 Begin
542 return CD_09;
543 END;
544 Function CD_10_p return varchar2 is
545 Begin
546 return CD_10;
547 END;
548 Function CD_11_p return varchar2 is
549 Begin
550 return CD_11;
551 END;
552 Function CD_12_p return varchar2 is
553 Begin
554 return CD_12;
555 END;
556 Function CD_13_p return varchar2 is
557 Begin
558 return CD_13;
559 END;
560 Function CD_14_p return varchar2 is
561 Begin
562 return CD_14;
563 END;
564 Function CD_15_p return varchar2 is
565 Begin
566 return CD_15;
567 END;
568 Function CD_16_p return varchar2 is
569 Begin
570 return CD_16;
571 END;
572 Function CD_17_p return varchar2 is
573 Begin
574 return CD_17;
575 END;
576 Function CD_18_p return varchar2 is
577 Begin
578 return CD_18;
579 END;
580 Function CD_19_p return varchar2 is
581 Begin
582 return CD_19;
583 END;
584 Function CD_20_p return varchar2 is
585 Begin
586 return CD_20;
587 END;
588 Function CV_01_p return varchar2 is
589 Begin
590 return CV_01;
591 END;
592 Function CV_02_p return varchar2 is
593 Begin
594 return CV_02;
595 END;
596 Function CV_03_p return varchar2 is
597 Begin
598 return CV_03;
599 END;
600 Function CV_04_p return varchar2 is
601 Begin
602 return CV_04;
603 END;
604 Function CV_05_p return varchar2 is
605 Begin
606 return CV_05;
607 END;
608 Function CV_06_p return varchar2 is
609 Begin
610 return CV_06;
611 END;
612 Function CV_07_p return varchar2 is
613 Begin
614 return CV_07;
615 END;
616 Function CV_08_p return varchar2 is
617 Begin
618 return CV_08;
619 END;
620 Function CV_09_p return varchar2 is
621 Begin
622 return CV_09;
623 END;
624 Function CV_10_p return varchar2 is
625 Begin
626 return CV_10;
627 END;
628 Function CV_11_p return varchar2 is
629 Begin
630 return CV_11;
631 END;
632 Function CV_12_p return varchar2 is
633 Begin
634 return CV_12;
635 END;
636 Function CV_13_p return varchar2 is
637 Begin
638 return CV_13;
639 END;
640 Function CV_14_p return varchar2 is
641 Begin
642 return CV_14;
643 END;
644 Function CV_15_p return varchar2 is
645 Begin
646 return CV_15;
647 END;
648 Function CV_16_p return varchar2 is
649 Begin
650 return CV_16;
651 END;
652 Function CV_17_p return varchar2 is
653 Begin
654 return CV_17;
655 END;
656 Function CV_18_p return varchar2 is
657 Begin
658 return CV_18;
659 END;
660 Function CV_19_p return varchar2 is
661 Begin
662 return CV_19;
663 END;
664 Function CV_20_p return varchar2 is
665 Begin
666 return CV_20;
667 END;
668 Function CP_DEBUG_MESSAGE_p return varchar2 is
669 Begin
670 return CP_DEBUG_MESSAGE;
671 END;
672 Function CP_LOCATION_p return varchar2 is
673 Begin
674 return CP_LOCATION;
675 END;
676 Function CP_AUDIT_LOG_p return varchar2 is
677 Begin
678 return CP_AUDIT_LOG;
679 END;
680 Function CP_BENFT_GROUP_p return varchar2 is
681 Begin
682 return CP_BENFT_GROUP;
683 END;
684 Function CP_1_p return varchar2 is
685 Begin
686 return CP_1;
687 END;
688 Function CP_FROM_OCRD_DT_p return varchar2 is
689 Begin
690 return CP_FROM_OCRD_DT;
691 END;
692 Function CP_TO_OCRD_DT_p return varchar2 is
693 Begin
694 return CP_TO_OCRD_DT;
695 END;
696 Function CP_BCKT_STAT_CD_p return varchar2 is
697 Begin
698 return CP_BCKT_STAT_CD;
699 END;
700 END BEN_BENERPER_XMLP_PKG ;