APPS.HRI_OLTP_PMV_DYNAMIC dependencies on HRI_OLTP_PMV_DYNSQLGEN

Line 14: l_sql_text := hri_oltp_pmv_dynsqlgen.get_query

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;

Line 29: l_sql_text := hri_oltp_pmv_dynsqlgen.get_query

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;

Line 48: l_sql_text := hri_oltp_pmv_dynsqlgen.get_query

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;

Line 63: l_sql_text := hri_oltp_pmv_dynsqlgen.get_query

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;

Line 78: l_sql_text := hri_oltp_pmv_dynsqlgen.get_query

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;

Line 93: l_sql_text := hri_oltp_pmv_dynsqlgen.get_query

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;

Line 112: l_sql_text := hri_oltp_pmv_dynsqlgen.get_query

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;

Line 127: l_sql_text := hri_oltp_pmv_dynsqlgen.get_query

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;

Line 142: l_sql_text := hri_oltp_pmv_dynsqlgen.get_query

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;

Line 157: l_sql_text := hri_oltp_pmv_dynsqlgen.get_query

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;

Line 172: l_sql_text := hri_oltp_pmv_dynsqlgen.get_query

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;

Line 187: l_sql_text := hri_oltp_pmv_dynsqlgen.get_query

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;

Line 202: l_sql_text := hri_oltp_pmv_dynsqlgen.get_query

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;

Line 217: l_sql_text := hri_oltp_pmv_dynsqlgen.get_query

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;

Line 236: l_sql_text := hri_oltp_pmv_dynsqlgen.get_query

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;

Line 251: l_sql_text := hri_oltp_pmv_dynsqlgen.get_query

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;

Line 266: l_sql_text := hri_oltp_pmv_dynsqlgen.get_query

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;

Line 281: l_sql_text := hri_oltp_pmv_dynsqlgen.get_query

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;

Line 296: l_sql_text := hri_oltp_pmv_dynsqlgen.get_query

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;

Line 311: l_sql_text := hri_oltp_pmv_dynsqlgen.get_query

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;

Line 330: l_sql_text := hri_oltp_pmv_dynsqlgen.get_query

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;

Line 345: l_sql_text := hri_oltp_pmv_dynsqlgen.get_query

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;

Line 364: l_sql_text := hri_oltp_pmv_dynsqlgen.get_query

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:
368: RETURN l_sql_text;

Line 383: l_sql_text := hri_oltp_pmv_dynsqlgen.get_query

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;

Line 398: l_sql_text := hri_oltp_pmv_dynsqlgen.get_query

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;

Line 419: l_sql_text := hri_oltp_pmv_dynsqlgen.get_no_viewby_query

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;

Line 438: l_sql_text := hri_oltp_pmv_dynsqlgen.get_query

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;

Line 457: l_sql_text := hri_oltp_pmv_dynsqlgen.get_drill_into_query

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;

Line 472: l_sql_text := hri_oltp_pmv_dynsqlgen.get_drill_into_query

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;

Line 488: l_sql_text := hri_oltp_pmv_dynsqlgen.get_drill_into_query

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;

Line 504: l_sql_text := hri_oltp_pmv_dynsqlgen.get_drill_into_query

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;

Line 520: l_sql_text := hri_oltp_pmv_dynsqlgen.get_drill_into_query

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;

Line 536: l_sql_text := hri_oltp_pmv_dynsqlgen.get_drill_into_query

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;

Line 552: l_sql_text := hri_oltp_pmv_dynsqlgen.get_drill_into_query

548: l_sql_text VARCHAR2(4000);
549:
550: BEGIN
551:
552: l_sql_text := hri_oltp_pmv_dynsqlgen.get_drill_into_query
553: (p_params_tbl => p_params_tbl,
554: p_ak_region_code => 'HRI_P_REC_APL_DET_TAH_SUPH');
555:
556: RETURN l_sql_text;

Line 569: l_sql_text := hri_oltp_pmv_dynsqlgen.get_drill_into_query

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;

Line 585: l_sql_text := hri_oltp_pmv_dynsqlgen.get_drill_into_query

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;

Line 601: l_sql_text := hri_oltp_pmv_dynsqlgen.get_drill_into_query

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;

Line 617: l_sql_text := hri_oltp_pmv_dynsqlgen.get_drill_into_query

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;

Line 633: l_sql_text := hri_oltp_pmv_dynsqlgen.get_drill_into_query

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;

Line 649: l_sql_text := hri_oltp_pmv_dynsqlgen.get_drill_into_query

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;

Line 665: l_sql_text := hri_oltp_pmv_dynsqlgen.get_drill_into_query

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;

Line 680: l_sql_text := hri_oltp_pmv_dynsqlgen.get_drill_into_query

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;

Line 695: l_sql_text := hri_oltp_pmv_dynsqlgen.get_drill_into_query

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;

Line 710: l_sql_text := hri_oltp_pmv_dynsqlgen.get_drill_into_query

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;

Line 725: l_sql_text := hri_oltp_pmv_dynsqlgen.get_drill_into_query

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;

Line 740: l_sql_text := hri_oltp_pmv_dynsqlgen.get_drill_into_query

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;

Line 755: l_sql_text := hri_oltp_pmv_dynsqlgen.get_drill_into_query

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;