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