APPS.HRI_OLTP_PMV_DYNAMIC dependencies on BIS_PMV_PAGE_PARAMETER_TBL

Line 7: FUNCTION vacancy_ageing_suph(p_params_tbl IN BIS_PMV_PAGE_PARAMETER_TBL)

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:

Line 22: FUNCTION vacancy_ageing_orgh(p_params_tbl IN BIS_PMV_PAGE_PARAMETER_TBL)

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:

Line 41: FUNCTION vac_time_to_fill_orgh(p_params_tbl IN BIS_PMV_PAGE_PARAMETER_TBL)

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:

Line 56: FUNCTION vac_time_to_fill_suph(p_params_tbl IN BIS_PMV_PAGE_PARAMETER_TBL)

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:

Line 71: FUNCTION apl_time_to_fill_orgh(p_params_tbl IN BIS_PMV_PAGE_PARAMETER_TBL)

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:

Line 86: FUNCTION apl_time_to_fill_suph(p_params_tbl IN BIS_PMV_PAGE_PARAMETER_TBL)

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:

Line 105: FUNCTION apl_time_hire_orgh(p_params_tbl IN BIS_PMV_PAGE_PARAMETER_TBL)

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:

Line 120: FUNCTION apl_time_hire_suph(p_params_tbl IN BIS_PMV_PAGE_PARAMETER_TBL)

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:

Line 135: FUNCTION vac_time_hire_orgh(p_params_tbl IN BIS_PMV_PAGE_PARAMETER_TBL)

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:

Line 150: FUNCTION vac_time_hire_suph(p_params_tbl IN BIS_PMV_PAGE_PARAMETER_TBL)

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:

Line 165: FUNCTION time_to_hire_orgh(p_params_tbl IN BIS_PMV_PAGE_PARAMETER_TBL)

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:

Line 180: FUNCTION time_to_hire_orgh_1(p_params_tbl IN BIS_PMV_PAGE_PARAMETER_TBL)

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:

Line 195: FUNCTION time_to_hire_orgh_2(p_params_tbl IN BIS_PMV_PAGE_PARAMETER_TBL)

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:

Line 210: FUNCTION time_to_hire_suph(p_params_tbl IN BIS_PMV_PAGE_PARAMETER_TBL)

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:

Line 229: FUNCTION apl_accpt_hire_orgh(p_params_tbl IN BIS_PMV_PAGE_PARAMETER_TBL)

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:

Line 244: FUNCTION apl_accpt_hire_suph(p_params_tbl IN BIS_PMV_PAGE_PARAMETER_TBL)

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:

Line 259: FUNCTION vac_accpt_hire_orgh(p_params_tbl IN BIS_PMV_PAGE_PARAMETER_TBL)

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:

Line 274: FUNCTION vac_accpt_hire_suph(p_params_tbl IN BIS_PMV_PAGE_PARAMETER_TBL)

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:

Line 289: FUNCTION time_accpt_hire_orgh(p_params_tbl IN BIS_PMV_PAGE_PARAMETER_TBL)

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:

Line 304: FUNCTION time_accpt_hire_suph(p_params_tbl IN BIS_PMV_PAGE_PARAMETER_TBL)

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:

Line 323: FUNCTION time_efficiency_orgh(p_params_tbl IN BIS_PMV_PAGE_PARAMETER_TBL)

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:

Line 338: FUNCTION time_efficiency_suph(p_params_tbl IN BIS_PMV_PAGE_PARAMETER_TBL)

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:

Line 357: FUNCTION rec_success_dyn(p_params_tbl IN BIS_PMV_PAGE_PARAMETER_TBL)

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:

Line 376: FUNCTION vacancy_system_status_orgh(p_params_tbl IN BIS_PMV_PAGE_PARAMETER_TBL)

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:

Line 391: FUNCTION vacancy_system_status_suph(p_params_tbl IN BIS_PMV_PAGE_PARAMETER_TBL)

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:

Line 410: FUNCTION applicant_detail(p_params_tbl IN BIS_PMV_PAGE_PARAMETER_TBL)

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:

Line 431: FUNCTION recruitment_source_effective(p_params_tbl IN BIS_PMV_PAGE_PARAMETER_TBL)

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:

Line 450: FUNCTION apl_detail_orgh(p_params_tbl IN BIS_PMV_PAGE_PARAMETER_TBL)

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:

Line 465: FUNCTION apl_detail_ttf_orgh(p_params_tbl IN BIS_PMV_PAGE_PARAMETER_TBL)

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:

Line 481: FUNCTION apl_detail_ttf_suph(p_params_tbl IN BIS_PMV_PAGE_PARAMETER_TBL)

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:

Line 497: FUNCTION apl_detail_tth_orgh(p_params_tbl IN BIS_PMV_PAGE_PARAMETER_TBL)

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:

Line 513: FUNCTION apl_detail_tth_suph(p_params_tbl IN BIS_PMV_PAGE_PARAMETER_TBL)

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:

Line 529: FUNCTION apl_detail_tah_orgh(p_params_tbl IN BIS_PMV_PAGE_PARAMETER_TBL)

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:

Line 545: FUNCTION apl_detail_tah_suph(p_params_tbl IN BIS_PMV_PAGE_PARAMETER_TBL)

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:

Line 562: FUNCTION vac_detail_ttf_orgh(p_params_tbl IN BIS_PMV_PAGE_PARAMETER_TBL)

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:

Line 578: FUNCTION vac_detail_ttf_suph(p_params_tbl IN BIS_PMV_PAGE_PARAMETER_TBL)

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:

Line 594: FUNCTION vac_detail_tth_orgh(p_params_tbl IN BIS_PMV_PAGE_PARAMETER_TBL)

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:

Line 610: FUNCTION vac_detail_tth_suph(p_params_tbl IN BIS_PMV_PAGE_PARAMETER_TBL)

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:

Line 626: FUNCTION vac_detail_tah_orgh(p_params_tbl IN BIS_PMV_PAGE_PARAMETER_TBL)

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:

Line 642: FUNCTION vac_detail_tah_suph(p_params_tbl IN BIS_PMV_PAGE_PARAMETER_TBL)

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:

Line 658: FUNCTION apl_detail_suph(p_params_tbl IN BIS_PMV_PAGE_PARAMETER_TBL)

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:

Line 673: FUNCTION vac_detail_orgh(p_params_tbl IN BIS_PMV_PAGE_PARAMETER_TBL)

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:

Line 688: FUNCTION vac_detail_suph(p_params_tbl IN BIS_PMV_PAGE_PARAMETER_TBL)

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:

Line 703: FUNCTION vac_detail_vag_orgh(p_params_tbl IN BIS_PMV_PAGE_PARAMETER_TBL)

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:

Line 718: FUNCTION vac_detail_vag_suph(p_params_tbl IN BIS_PMV_PAGE_PARAMETER_TBL)

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:

Line 733: FUNCTION vac_detail_vst_orgh(p_params_tbl IN BIS_PMV_PAGE_PARAMETER_TBL)

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:

Line 748: FUNCTION vac_detail_vst_suph(p_params_tbl IN BIS_PMV_PAGE_PARAMETER_TBL)

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: