[Home] [Help]
PACKAGE BODY: APPS.HRI_OLTP_PMV_DYNAMIC
Source
1 PACKAGE BODY hri_oltp_pmv_dynamic AS
2 /* $Header: hriopdyn.pkb 115.3 2002/12/23 10:18:14 cbridge noship $ */
3
4 /******************************************************************************/
5 /* Vacancy Ageing */
6 /******************/
7 FUNCTION vacancy_ageing_suph(p_params_tbl IN BIS_PMV_PAGE_PARAMETER_TBL)
8 RETURN VARCHAR2 IS
9
10 l_sql_text VARCHAR2(4000);
11
12 BEGIN
13
14 l_sql_text := hri_oltp_pmv_dynsqlgen.get_query
15 (p_params_tbl => p_params_tbl,
16 p_ak_region_code => 'HRI_P_REC_VAC_AGEING_SUPH');
17
18 RETURN l_sql_text;
19
20 END vacancy_ageing_suph;
21
22 FUNCTION vacancy_ageing_orgh(p_params_tbl IN BIS_PMV_PAGE_PARAMETER_TBL)
23 RETURN VARCHAR2 IS
24
25 l_sql_text VARCHAR2(4000);
26
27 BEGIN
28
29 l_sql_text := hri_oltp_pmv_dynsqlgen.get_query
30 (p_params_tbl => p_params_tbl,
31 p_ak_region_code => 'HRI_P_REC_VAC_AGEING_ORGH');
32
33 RETURN l_sql_text;
34
35 END vacancy_ageing_orgh;
36
37
38 /******************************************************************************/
39 /* Time to Fill */
40 /****************/
41 FUNCTION vac_time_to_fill_orgh(p_params_tbl IN BIS_PMV_PAGE_PARAMETER_TBL)
42 RETURN VARCHAR2 IS
43
44 l_sql_text VARCHAR2(4000);
45
46 BEGIN
47
48 l_sql_text := hri_oltp_pmv_dynsqlgen.get_query
49 (p_params_tbl => p_params_tbl,
50 p_ak_region_code => 'HRI_P_REC_VAC_TIME_FILL_ORGH');
51
52 RETURN l_sql_text;
53
54 END vac_time_to_fill_orgh;
55
56 FUNCTION vac_time_to_fill_suph(p_params_tbl IN BIS_PMV_PAGE_PARAMETER_TBL)
57 RETURN VARCHAR2 IS
58
59 l_sql_text VARCHAR2(4000);
60
61 BEGIN
62
63 l_sql_text := hri_oltp_pmv_dynsqlgen.get_query
64 (p_params_tbl => p_params_tbl,
65 p_ak_region_code => 'HRI_P_REC_VAC_TIME_FILL_SUPH');
66
67 RETURN l_sql_text;
68
69 END vac_time_to_fill_suph;
70
71 FUNCTION apl_time_to_fill_orgh(p_params_tbl IN BIS_PMV_PAGE_PARAMETER_TBL)
72 RETURN VARCHAR2 IS
73
74 l_sql_text VARCHAR2(4000);
75
76 BEGIN
77
78 l_sql_text := hri_oltp_pmv_dynsqlgen.get_query
79 (p_params_tbl => p_params_tbl,
80 p_ak_region_code => 'HRI_P_REC_APL_TIME_FILL_ORGH');
81
82 RETURN l_sql_text;
83
84 END apl_time_to_fill_orgh;
85
86 FUNCTION apl_time_to_fill_suph(p_params_tbl IN BIS_PMV_PAGE_PARAMETER_TBL)
87 RETURN VARCHAR2 IS
88
89 l_sql_text VARCHAR2(4000);
90
91 BEGIN
92
93 l_sql_text := hri_oltp_pmv_dynsqlgen.get_query
94 (p_params_tbl => p_params_tbl,
95 p_ak_region_code => 'HRI_P_REC_APL_TIME_FILL_SUPH');
96
97 RETURN l_sql_text;
98
99 END apl_time_to_fill_suph;
100
101
102 /******************************************************************************/
103 /* Time to Hire */
104 /****************/
105 FUNCTION apl_time_hire_orgh(p_params_tbl IN BIS_PMV_PAGE_PARAMETER_TBL)
106 RETURN VARCHAR2 IS
107
108 l_sql_text VARCHAR2(4000);
109
110 BEGIN
111
112 l_sql_text := hri_oltp_pmv_dynsqlgen.get_query
113 (p_params_tbl => p_params_tbl,
114 p_ak_region_code => 'HRI_P_REC_APL_TIME_HIRE_ORGH');
115
116 RETURN l_sql_text;
117
118 END apl_time_hire_orgh;
119
120 FUNCTION apl_time_hire_suph(p_params_tbl IN BIS_PMV_PAGE_PARAMETER_TBL)
121 RETURN VARCHAR2 IS
122
123 l_sql_text VARCHAR2(4000);
124
125 BEGIN
126
127 l_sql_text := hri_oltp_pmv_dynsqlgen.get_query
128 (p_params_tbl => p_params_tbl,
129 p_ak_region_code => 'HRI_P_REC_APL_TIME_HIRE_SUPH');
130
131 RETURN l_sql_text;
132
133 END apl_time_hire_suph;
134
135 FUNCTION vac_time_hire_orgh(p_params_tbl IN BIS_PMV_PAGE_PARAMETER_TBL)
136 RETURN VARCHAR2 IS
137
138 l_sql_text VARCHAR2(4000);
139
140 BEGIN
141
142 l_sql_text := hri_oltp_pmv_dynsqlgen.get_query
143 (p_params_tbl => p_params_tbl,
144 p_ak_region_code => 'HRI_P_REC_VAC_TIME_HIRE_ORGH');
145
146 RETURN l_sql_text;
147
148 END vac_time_hire_orgh;
149
150 FUNCTION vac_time_hire_suph(p_params_tbl IN BIS_PMV_PAGE_PARAMETER_TBL)
151 RETURN VARCHAR2 IS
152
153 l_sql_text VARCHAR2(4000);
154
155 BEGIN
156
157 l_sql_text := hri_oltp_pmv_dynsqlgen.get_query
158 (p_params_tbl => p_params_tbl,
159 p_ak_region_code => 'HRI_P_REC_VAC_TIME_HIRE_SUPH');
160
161 RETURN l_sql_text;
162
163 END vac_time_hire_suph;
164
165 FUNCTION time_to_hire_orgh(p_params_tbl IN BIS_PMV_PAGE_PARAMETER_TBL)
166 RETURN VARCHAR2 IS
167
168 l_sql_text VARCHAR2(4000);
169
170 BEGIN
171
172 l_sql_text := hri_oltp_pmv_dynsqlgen.get_query
173 (p_params_tbl => p_params_tbl,
174 p_ak_region_code => 'HRI_P_REC_TIME_TO_HIRE_ORGH');
175
176 RETURN l_sql_text;
177
178 END time_to_hire_orgh;
179
180 FUNCTION time_to_hire_orgh_1(p_params_tbl IN BIS_PMV_PAGE_PARAMETER_TBL)
181 RETURN VARCHAR2 IS
182
183 l_sql_text VARCHAR2(4000);
184
185 BEGIN
186
187 l_sql_text := hri_oltp_pmv_dynsqlgen.get_query
188 (p_params_tbl => p_params_tbl,
189 p_ak_region_code => 'HRI_P_REC_TIME_TO_HIRE_ORGH_1');
190
191 RETURN l_sql_text;
192
193 END time_to_hire_orgh_1;
194
195 FUNCTION time_to_hire_orgh_2(p_params_tbl IN BIS_PMV_PAGE_PARAMETER_TBL)
196 RETURN VARCHAR2 IS
197
198 l_sql_text VARCHAR2(4000);
199
200 BEGIN
201
202 l_sql_text := hri_oltp_pmv_dynsqlgen.get_query
203 (p_params_tbl => p_params_tbl,
204 p_ak_region_code => 'HRI_P_REC_TIME_TO_HIRE_ORGH_2');
205
206 RETURN l_sql_text;
207
208 END time_to_hire_orgh_2;
209
210 FUNCTION time_to_hire_suph(p_params_tbl IN BIS_PMV_PAGE_PARAMETER_TBL)
211 RETURN VARCHAR2 IS
212
213 l_sql_text VARCHAR2(4000);
214
215 BEGIN
216
217 l_sql_text := hri_oltp_pmv_dynsqlgen.get_query
218 (p_params_tbl => p_params_tbl,
219 p_ak_region_code => 'HRI_P_REC_TIME_TO_HIRE_SUPH');
220
221 RETURN l_sql_text;
222
223 END time_to_hire_suph;
224
225
226 /******************************************************************************/
227 /* Time from Accept to Hire */
228 /****************************/
229 FUNCTION apl_accpt_hire_orgh(p_params_tbl IN BIS_PMV_PAGE_PARAMETER_TBL)
230 RETURN VARCHAR2 IS
231
232 l_sql_text VARCHAR2(4000);
233
234 BEGIN
235
236 l_sql_text := hri_oltp_pmv_dynsqlgen.get_query
237 (p_params_tbl => p_params_tbl,
238 p_ak_region_code => 'HRI_P_REC_APL_ACCPT_HIRE_ORGH');
239
240 RETURN l_sql_text;
241
242 END apl_accpt_hire_orgh;
243
244 FUNCTION apl_accpt_hire_suph(p_params_tbl IN BIS_PMV_PAGE_PARAMETER_TBL)
245 RETURN VARCHAR2 IS
246
247 l_sql_text VARCHAR2(4000);
248
249 BEGIN
250
251 l_sql_text := hri_oltp_pmv_dynsqlgen.get_query
252 (p_params_tbl => p_params_tbl,
253 p_ak_region_code => 'HRI_P_REC_APL_ACCPT_HIRE_SUPH');
254
255 RETURN l_sql_text;
256
257 END apl_accpt_hire_suph;
258
259 FUNCTION vac_accpt_hire_orgh(p_params_tbl IN BIS_PMV_PAGE_PARAMETER_TBL)
260 RETURN VARCHAR2 IS
261
262 l_sql_text VARCHAR2(4000);
263
264 BEGIN
265
266 l_sql_text := hri_oltp_pmv_dynsqlgen.get_query
267 (p_params_tbl => p_params_tbl,
268 p_ak_region_code => 'HRI_P_REC_VAC_ACCPT_HIRE_ORGH');
269
270 RETURN l_sql_text;
271
272 END vac_accpt_hire_orgh;
273
274 FUNCTION vac_accpt_hire_suph(p_params_tbl IN BIS_PMV_PAGE_PARAMETER_TBL)
275 RETURN VARCHAR2 IS
276
277 l_sql_text VARCHAR2(4000);
278
279 BEGIN
280
281 l_sql_text := hri_oltp_pmv_dynsqlgen.get_query
282 (p_params_tbl => p_params_tbl,
283 p_ak_region_code => 'HRI_P_REC_VAC_ACCPT_HIRE_SUPH');
284
285 RETURN l_sql_text;
286
287 END vac_accpt_hire_suph;
288
289 FUNCTION time_accpt_hire_orgh(p_params_tbl IN BIS_PMV_PAGE_PARAMETER_TBL)
290 RETURN VARCHAR2 IS
291
292 l_sql_text VARCHAR2(4000);
293
294 BEGIN
295
296 l_sql_text := hri_oltp_pmv_dynsqlgen.get_query
297 (p_params_tbl => p_params_tbl,
298 p_ak_region_code => 'HRI_P_REC_TIME_ACCPT_HIRE_ORGH');
299
300 RETURN l_sql_text;
301
302 END time_accpt_hire_orgh;
303
304 FUNCTION time_accpt_hire_suph(p_params_tbl IN BIS_PMV_PAGE_PARAMETER_TBL)
305 RETURN VARCHAR2 IS
306
307 l_sql_text VARCHAR2(4000);
308
309 BEGIN
310
311 l_sql_text := hri_oltp_pmv_dynsqlgen.get_query
312 (p_params_tbl => p_params_tbl,
313 p_ak_region_code => 'HRI_P_REC_TIME_ACCPT_HIRE_SUPH');
314
315 RETURN l_sql_text;
316
317 END time_accpt_hire_suph;
318
319
320 /******************************************************************************/
321 /* Recruitment Efficiency */
322 /**************************/
323 FUNCTION time_efficiency_orgh(p_params_tbl IN BIS_PMV_PAGE_PARAMETER_TBL)
324 RETURN VARCHAR2 IS
325
326 l_sql_text VARCHAR2(4000);
327
328 BEGIN
329
330 l_sql_text := hri_oltp_pmv_dynsqlgen.get_query
331 (p_params_tbl => p_params_tbl,
332 p_ak_region_code => 'HRI_P_REC_TIME_EFFICIENCY_ORGH');
333
334 RETURN l_sql_text;
335
336 END time_efficiency_orgh;
337
338 FUNCTION time_efficiency_suph(p_params_tbl IN BIS_PMV_PAGE_PARAMETER_TBL)
339 RETURN VARCHAR2 IS
340
341 l_sql_text VARCHAR2(4000);
342
343 BEGIN
344
345 l_sql_text := hri_oltp_pmv_dynsqlgen.get_query
346 (p_params_tbl => p_params_tbl,
347 p_ak_region_code => 'HRI_P_REC_TIME_EFFICIENCY_SUPH');
348
349 RETURN l_sql_text;
350
351 END time_efficiency_suph;
352
353
354 /******************************************************************************/
355 /* Recruitment Success */
356 /***********************/
357 FUNCTION rec_success_dyn(p_params_tbl IN BIS_PMV_PAGE_PARAMETER_TBL)
358 RETURN VARCHAR2 IS
359
360 l_sql_text VARCHAR2(4000);
361
362 BEGIN
363
364 l_sql_text := hri_oltp_pmv_dynsqlgen.get_query
365 (p_params_tbl => p_params_tbl,
366 p_ak_region_code => 'HRI_P_REC_SUCCESS_DYN');
367
371
368 RETURN l_sql_text;
369
370 END rec_success_dyn;
372
373 /******************************************************************************/
374 /* Vacancy Status */
375 /******************/
376 FUNCTION vacancy_system_status_orgh(p_params_tbl IN BIS_PMV_PAGE_PARAMETER_TBL)
377 RETURN VARCHAR2 IS
378
379 l_sql_text VARCHAR2(4000);
380
381 BEGIN
382
383 l_sql_text := hri_oltp_pmv_dynsqlgen.get_query
384 (p_params_tbl => p_params_tbl,
385 p_ak_region_code => 'HRI_P_REC_VAC_SYS_STATUS_ORGH');
386
387 RETURN l_sql_text;
388
389 END vacancy_system_status_orgh;
390
391 FUNCTION vacancy_system_status_suph(p_params_tbl IN BIS_PMV_PAGE_PARAMETER_TBL)
392 RETURN VARCHAR2 IS
393
394 l_sql_text VARCHAR2(4000);
395
396 BEGIN
397
398 l_sql_text := hri_oltp_pmv_dynsqlgen.get_query
399 (p_params_tbl => p_params_tbl,
400 p_ak_region_code => 'HRI_P_REC_VAC_SYS_STATUS_SUPH');
401
402 RETURN l_sql_text;
403
404 END vacancy_system_status_suph;
405
406
407 /******************************************************************************/
408 /* Applicant Detail */
409 /********************/
410 FUNCTION applicant_detail(p_params_tbl IN BIS_PMV_PAGE_PARAMETER_TBL)
411 RETURN VARCHAR2
412
413 IS
414
415 l_sql_text VARCHAR2(4000);
416
417 BEGIN
418
419 l_sql_text := hri_oltp_pmv_dynsqlgen.get_no_viewby_query
420 (p_params_tbl => p_params_tbl,
421 p_ak_region_code => 'HRI_P_REC_APPLICANT_DETAIL');
422
423 RETURN l_sql_text;
424
425 END applicant_detail;
426
427
428 /******************************************************************************/
429 /* Recuitment Source Effectiveness */
430 /****************/
431 FUNCTION recruitment_source_effective(p_params_tbl IN BIS_PMV_PAGE_PARAMETER_TBL)
432 RETURN VARCHAR2 IS
433
434 l_sql_text VARCHAR2(4000);
435
436 BEGIN
437
438 l_sql_text := hri_oltp_pmv_dynsqlgen.get_query
439 (p_params_tbl => p_params_tbl,
440 p_ak_region_code => 'HRI_P_REC_APL_SRC');
441
442 RETURN l_sql_text;
443
444 END recruitment_source_effective;
445
446
447 /******************************************************************************/
448 /* Drill to Detail Reports */
449 /***************************/
450 FUNCTION apl_detail_orgh(p_params_tbl IN BIS_PMV_PAGE_PARAMETER_TBL)
451 RETURN VARCHAR2 IS
452
453 l_sql_text VARCHAR2(4000);
454
455 BEGIN
456
457 l_sql_text := hri_oltp_pmv_dynsqlgen.get_drill_into_query
458 (p_params_tbl => p_params_tbl,
459 p_ak_region_code => 'HRI_P_REC_APL_DETAIL_ORGH');
460
461 RETURN l_sql_text;
462
463 END apl_detail_orgh;
464
465 FUNCTION apl_detail_ttf_orgh(p_params_tbl IN BIS_PMV_PAGE_PARAMETER_TBL)
466 RETURN VARCHAR2 IS
467
468 l_sql_text VARCHAR2(4000);
469
470 BEGIN
471
472 l_sql_text := hri_oltp_pmv_dynsqlgen.get_drill_into_query
473 (p_params_tbl => p_params_tbl,
474 p_ak_region_code => 'HRI_P_REC_APL_DET_TTF_ORGH');
475
476 RETURN l_sql_text;
477
478 END apl_detail_ttf_orgh;
479
480
481 FUNCTION apl_detail_ttf_suph(p_params_tbl IN BIS_PMV_PAGE_PARAMETER_TBL)
482 RETURN VARCHAR2 IS
483
484 l_sql_text VARCHAR2(4000);
485
486 BEGIN
487
488 l_sql_text := hri_oltp_pmv_dynsqlgen.get_drill_into_query
489 (p_params_tbl => p_params_tbl,
490 p_ak_region_code => 'HRI_P_REC_APL_DET_TTF_SUPH');
491
492 RETURN l_sql_text;
493
494 END apl_detail_ttf_suph;
495
496
497 FUNCTION apl_detail_tth_orgh(p_params_tbl IN BIS_PMV_PAGE_PARAMETER_TBL)
498 RETURN VARCHAR2 IS
499
500 l_sql_text VARCHAR2(4000);
501
502 BEGIN
503
504 l_sql_text := hri_oltp_pmv_dynsqlgen.get_drill_into_query
505 (p_params_tbl => p_params_tbl,
506 p_ak_region_code => 'HRI_P_REC_APL_DET_TTH_ORGH');
507
508 RETURN l_sql_text;
509
510 END apl_detail_tth_orgh;
511
512
513 FUNCTION apl_detail_tth_suph(p_params_tbl IN BIS_PMV_PAGE_PARAMETER_TBL)
514 RETURN VARCHAR2 IS
515
516 l_sql_text VARCHAR2(4000);
517
518 BEGIN
519
520 l_sql_text := hri_oltp_pmv_dynsqlgen.get_drill_into_query
521 (p_params_tbl => p_params_tbl,
522 p_ak_region_code => 'HRI_P_REC_APL_DET_TTH_SUPH');
523
524 RETURN l_sql_text;
525
526 END apl_detail_tth_suph;
527
528
529 FUNCTION apl_detail_tah_orgh(p_params_tbl IN BIS_PMV_PAGE_PARAMETER_TBL)
530 RETURN VARCHAR2 IS
531
532 l_sql_text VARCHAR2(4000);
533
534 BEGIN
535
536 l_sql_text := hri_oltp_pmv_dynsqlgen.get_drill_into_query
537 (p_params_tbl => p_params_tbl,
538 p_ak_region_code => 'HRI_P_REC_APL_DET_TAH_ORGH');
539
540 RETURN l_sql_text;
541
542 END apl_detail_tah_orgh;
543
544
545 FUNCTION apl_detail_tah_suph(p_params_tbl IN BIS_PMV_PAGE_PARAMETER_TBL)
546 RETURN VARCHAR2 IS
547
548 l_sql_text VARCHAR2(4000);
549
550 BEGIN
554 p_ak_region_code => 'HRI_P_REC_APL_DET_TAH_SUPH');
551
552 l_sql_text := hri_oltp_pmv_dynsqlgen.get_drill_into_query
553 (p_params_tbl => p_params_tbl,
555
556 RETURN l_sql_text;
557
558 END apl_detail_tah_suph;
559
560 -- vacancy drills
561
562 FUNCTION vac_detail_ttf_orgh(p_params_tbl IN BIS_PMV_PAGE_PARAMETER_TBL)
563 RETURN VARCHAR2 IS
564
565 l_sql_text VARCHAR2(4000);
566
567 BEGIN
568
569 l_sql_text := hri_oltp_pmv_dynsqlgen.get_drill_into_query
570 (p_params_tbl => p_params_tbl,
571 p_ak_region_code => 'HRI_P_REC_VAC_DET_TTF_ORGH');
572
573 RETURN l_sql_text;
574
575 END vac_detail_ttf_orgh;
576
577
578 FUNCTION vac_detail_ttf_suph(p_params_tbl IN BIS_PMV_PAGE_PARAMETER_TBL)
579 RETURN VARCHAR2 IS
580
581 l_sql_text VARCHAR2(4000);
582
583 BEGIN
584
585 l_sql_text := hri_oltp_pmv_dynsqlgen.get_drill_into_query
586 (p_params_tbl => p_params_tbl,
587 p_ak_region_code => 'HRI_P_REC_VAC_DET_TTF_SUPH');
588
589 RETURN l_sql_text;
590
591 END vac_detail_ttf_suph;
592
593
594 FUNCTION vac_detail_tth_orgh(p_params_tbl IN BIS_PMV_PAGE_PARAMETER_TBL)
595 RETURN VARCHAR2 IS
596
597 l_sql_text VARCHAR2(4000);
598
599 BEGIN
600
601 l_sql_text := hri_oltp_pmv_dynsqlgen.get_drill_into_query
602 (p_params_tbl => p_params_tbl,
603 p_ak_region_code => 'HRI_P_REC_VAC_DET_TTH_ORGH');
604
605 RETURN l_sql_text;
606
607 END vac_detail_tth_orgh;
608
609
610 FUNCTION vac_detail_tth_suph(p_params_tbl IN BIS_PMV_PAGE_PARAMETER_TBL)
611 RETURN VARCHAR2 IS
612
613 l_sql_text VARCHAR2(4000);
614
615 BEGIN
616
617 l_sql_text := hri_oltp_pmv_dynsqlgen.get_drill_into_query
618 (p_params_tbl => p_params_tbl,
619 p_ak_region_code => 'HRI_P_REC_VAC_DET_TTH_SUPH');
620
621 RETURN l_sql_text;
622
623 END vac_detail_tth_suph;
624
625
626 FUNCTION vac_detail_tah_orgh(p_params_tbl IN BIS_PMV_PAGE_PARAMETER_TBL)
627 RETURN VARCHAR2 IS
628
629 l_sql_text VARCHAR2(4000);
630
631 BEGIN
632
633 l_sql_text := hri_oltp_pmv_dynsqlgen.get_drill_into_query
634 (p_params_tbl => p_params_tbl,
635 p_ak_region_code => 'HRI_P_REC_VAC_DET_TAH_ORGH');
636
637 RETURN l_sql_text;
638
639 END vac_detail_tah_orgh;
640
641
642 FUNCTION vac_detail_tah_suph(p_params_tbl IN BIS_PMV_PAGE_PARAMETER_TBL)
643 RETURN VARCHAR2 IS
644
645 l_sql_text VARCHAR2(4000);
646
647 BEGIN
648
649 l_sql_text := hri_oltp_pmv_dynsqlgen.get_drill_into_query
650 (p_params_tbl => p_params_tbl,
651 p_ak_region_code => 'HRI_P_REC_VAC_DET_TAH_SUPH');
652
653 RETURN l_sql_text;
654
655 END vac_detail_tah_suph;
656
657
658 FUNCTION apl_detail_suph(p_params_tbl IN BIS_PMV_PAGE_PARAMETER_TBL)
659 RETURN VARCHAR2 IS
660
661 l_sql_text VARCHAR2(4000);
662
663 BEGIN
664
665 l_sql_text := hri_oltp_pmv_dynsqlgen.get_drill_into_query
666 (p_params_tbl => p_params_tbl,
667 p_ak_region_code => 'HRI_P_REC_APL_DETAIL_SUPH');
668
669 RETURN l_sql_text;
670
671 END apl_detail_suph;
672
673 FUNCTION vac_detail_orgh(p_params_tbl IN BIS_PMV_PAGE_PARAMETER_TBL)
674 RETURN VARCHAR2 IS
675
676 l_sql_text VARCHAR2(4000);
677
678 BEGIN
679
680 l_sql_text := hri_oltp_pmv_dynsqlgen.get_drill_into_query
681 (p_params_tbl => p_params_tbl,
682 p_ak_region_code => 'HRI_P_REC_VAC_DETAIL_ORGH');
683
684 RETURN l_sql_text;
685
686 END vac_detail_orgh;
687
688 FUNCTION vac_detail_suph(p_params_tbl IN BIS_PMV_PAGE_PARAMETER_TBL)
689 RETURN VARCHAR2 IS
690
691 l_sql_text VARCHAR2(4000);
692
693 BEGIN
694
695 l_sql_text := hri_oltp_pmv_dynsqlgen.get_drill_into_query
696 (p_params_tbl => p_params_tbl,
697 p_ak_region_code => 'HRI_P_REC_VAC_DETAIL_SUPH');
698
699 RETURN l_sql_text;
700
701 END vac_detail_suph;
702
703 FUNCTION vac_detail_vag_orgh(p_params_tbl IN BIS_PMV_PAGE_PARAMETER_TBL)
704 RETURN VARCHAR2 IS
705
706 l_sql_text VARCHAR2(4000);
707
708 BEGIN
709
710 l_sql_text := hri_oltp_pmv_dynsqlgen.get_drill_into_query
711 (p_params_tbl => p_params_tbl,
712 p_ak_region_code => 'HRI_P_REC_VAC_DET_VAG_ORGH');
713
714 RETURN l_sql_text;
715
716 END vac_detail_vag_orgh;
717
718 FUNCTION vac_detail_vag_suph(p_params_tbl IN BIS_PMV_PAGE_PARAMETER_TBL)
719 RETURN VARCHAR2 IS
720
721 l_sql_text VARCHAR2(4000);
722
723 BEGIN
724
725 l_sql_text := hri_oltp_pmv_dynsqlgen.get_drill_into_query
726 (p_params_tbl => p_params_tbl,
727 p_ak_region_code => 'HRI_P_REC_VAC_DET_VAG_SUPH');
728
729 RETURN l_sql_text;
730
731 END vac_detail_vag_suph;
732
733 FUNCTION vac_detail_vst_orgh(p_params_tbl IN BIS_PMV_PAGE_PARAMETER_TBL)
734 RETURN VARCHAR2 IS
735
736 l_sql_text VARCHAR2(4000);
737
738 BEGIN
739
740 l_sql_text := hri_oltp_pmv_dynsqlgen.get_drill_into_query
741 (p_params_tbl => p_params_tbl,
742 p_ak_region_code => 'HRI_P_REC_VAC_DET_VST_ORGH');
743
744 RETURN l_sql_text;
745
746 END vac_detail_vst_orgh;
747
748 FUNCTION vac_detail_vst_suph(p_params_tbl IN BIS_PMV_PAGE_PARAMETER_TBL)
749 RETURN VARCHAR2 IS
750
751 l_sql_text VARCHAR2(4000);
752
753 BEGIN
754
755 l_sql_text := hri_oltp_pmv_dynsqlgen.get_drill_into_query
756 (p_params_tbl => p_params_tbl,
757 p_ak_region_code => 'HRI_P_REC_VAC_DET_VST_SUPH');
758
759 RETURN l_sql_text;
760
761 END vac_detail_vst_suph;
762
763
764 END hri_oltp_pmv_dynamic;