1 PACKAGE hri_oltp_pmv_dynamic AUTHID CURRENT_USER AS
2 /* $Header: hriopdyn.pkh 115.3 2002/12/23 10:17:45 cbridge noship $ */
3
4 /* Vacancy Ageing */
5 FUNCTION vacancy_ageing_suph(p_params_tbl IN BIS_PMV_PAGE_PARAMETER_TBL)
6 RETURN VARCHAR2;
7
8 FUNCTION vacancy_ageing_orgh(p_params_tbl IN BIS_PMV_PAGE_PARAMETER_TBL)
9 RETURN VARCHAR2;
10
11 /* Time to Fill */
12 FUNCTION vac_time_to_fill_orgh(p_params_tbl IN BIS_PMV_PAGE_PARAMETER_TBL)
13 RETURN VARCHAR2;
14
15 FUNCTION vac_time_to_fill_suph(p_params_tbl IN BIS_PMV_PAGE_PARAMETER_TBL)
16 RETURN VARCHAR2;
17
18 FUNCTION apl_time_to_fill_orgh(p_params_tbl IN BIS_PMV_PAGE_PARAMETER_TBL)
19 RETURN VARCHAR2;
20
21 FUNCTION apl_time_to_fill_suph(p_params_tbl IN BIS_PMV_PAGE_PARAMETER_TBL)
22 RETURN VARCHAR2;
23
24 /* Time to Hire */
25 FUNCTION apl_time_hire_orgh(p_params_tbl IN BIS_PMV_PAGE_PARAMETER_TBL)
26 RETURN VARCHAR2;
27
28 FUNCTION vac_time_hire_orgh(p_params_tbl IN BIS_PMV_PAGE_PARAMETER_TBL)
29 RETURN VARCHAR2;
30
31 FUNCTION apl_time_hire_suph(p_params_tbl IN BIS_PMV_PAGE_PARAMETER_TBL)
32 RETURN VARCHAR2;
33
34 FUNCTION vac_time_hire_suph(p_params_tbl IN BIS_PMV_PAGE_PARAMETER_TBL)
35 RETURN VARCHAR2;
36
37 FUNCTION time_to_hire_orgh(p_params_tbl IN BIS_PMV_PAGE_PARAMETER_TBL)
38 RETURN VARCHAR2;
39
40 FUNCTION time_to_hire_orgh_1(p_params_tbl IN BIS_PMV_PAGE_PARAMETER_TBL)
41 RETURN VARCHAR2;
42
43 FUNCTION time_to_hire_orgh_2(p_params_tbl IN BIS_PMV_PAGE_PARAMETER_TBL)
44 RETURN VARCHAR2;
45
46 FUNCTION time_to_hire_suph(p_params_tbl IN BIS_PMV_PAGE_PARAMETER_TBL)
47 RETURN VARCHAR2;
48
49 /* Time from Accept to Hire */
50 FUNCTION apl_accpt_hire_orgh(p_params_tbl IN BIS_PMV_PAGE_PARAMETER_TBL)
51 RETURN VARCHAR2;
52
53 FUNCTION apl_accpt_hire_suph(p_params_tbl IN BIS_PMV_PAGE_PARAMETER_TBL)
54 RETURN VARCHAR2;
55
56 FUNCTION vac_accpt_hire_orgh(p_params_tbl IN BIS_PMV_PAGE_PARAMETER_TBL)
57 RETURN VARCHAR2;
58
59 FUNCTION vac_accpt_hire_suph(p_params_tbl IN BIS_PMV_PAGE_PARAMETER_TBL)
60 RETURN VARCHAR2;
61
62 FUNCTION time_accpt_hire_orgh(p_params_tbl IN BIS_PMV_PAGE_PARAMETER_TBL)
63 RETURN VARCHAR2;
64
65 FUNCTION time_accpt_hire_suph(p_params_tbl IN BIS_PMV_PAGE_PARAMETER_TBL)
66 RETURN VARCHAR2;
67
68 /* Recruitment Efficiency */
69 FUNCTION time_efficiency_orgh(p_params_tbl IN BIS_PMV_PAGE_PARAMETER_TBL)
70 RETURN VARCHAR2;
71
72 FUNCTION time_efficiency_suph(p_params_tbl IN BIS_PMV_PAGE_PARAMETER_TBL)
73 RETURN VARCHAR2;
74
75 /* Recruitment Success */
76 FUNCTION rec_success_dyn(p_params_tbl IN BIS_PMV_PAGE_PARAMETER_TBL)
77 RETURN VARCHAR2;
78
79 /* Vacancy Status */
80 FUNCTION vacancy_system_status_orgh(p_params_tbl IN BIS_PMV_PAGE_PARAMETER_TBL)
81 RETURN VARCHAR2;
82
83 FUNCTION vacancy_system_status_suph(p_params_tbl IN BIS_PMV_PAGE_PARAMETER_TBL)
84 RETURN VARCHAR2;
85
86 /* Applicant Detail */
87 FUNCTION applicant_detail(p_params_tbl IN BIS_PMV_PAGE_PARAMETER_TBL)
88 RETURN VARCHAR2;
89
90 /* Recuitment Source Effectiveness */
91 FUNCTION recruitment_source_effective(p_params_tbl IN BIS_PMV_PAGE_PARAMETER_TBL)
92 RETURN VARCHAR2;
93
94
95 /******************************************************************************/
96 /* Drill to Detail Reports */
97 /***************************/
98 FUNCTION apl_detail_orgh(p_params_tbl IN BIS_PMV_PAGE_PARAMETER_TBL)
99 RETURN VARCHAR2;
100
101 FUNCTION apl_detail_suph(p_params_tbl IN BIS_PMV_PAGE_PARAMETER_TBL)
102 RETURN VARCHAR2;
103
104 FUNCTION vac_detail_orgh(p_params_tbl IN BIS_PMV_PAGE_PARAMETER_TBL)
105 RETURN VARCHAR2;
106
107 FUNCTION vac_detail_suph(p_params_tbl IN BIS_PMV_PAGE_PARAMETER_TBL)
108 RETURN VARCHAR2;
109
110 FUNCTION apl_detail_ttf_orgh(p_params_tbl IN BIS_PMV_PAGE_PARAMETER_TBL)
111 RETURN VARCHAR2;
112
113 FUNCTION apl_detail_ttf_suph(p_params_tbl IN BIS_PMV_PAGE_PARAMETER_TBL)
114 RETURN VARCHAR2;
115
116 FUNCTION apl_detail_tth_orgh(p_params_tbl IN BIS_PMV_PAGE_PARAMETER_TBL)
117 RETURN VARCHAR2;
118
119 FUNCTION apl_detail_tth_suph(p_params_tbl IN BIS_PMV_PAGE_PARAMETER_TBL)
120 RETURN VARCHAR2;
121
122 FUNCTION apl_detail_tah_orgh(p_params_tbl IN BIS_PMV_PAGE_PARAMETER_TBL)
123 RETURN VARCHAR2;
124
125 FUNCTION apl_detail_tah_suph(p_params_tbl IN BIS_PMV_PAGE_PARAMETER_TBL)
126 RETURN VARCHAR2;
127
128 -- vacancy drills.
129
130 FUNCTION vac_detail_ttf_orgh(p_params_tbl IN BIS_PMV_PAGE_PARAMETER_TBL)
131 RETURN VARCHAR2;
132
133 FUNCTION vac_detail_ttf_suph(p_params_tbl IN BIS_PMV_PAGE_PARAMETER_TBL)
134 RETURN VARCHAR2;
135
136 FUNCTION vac_detail_tth_orgh(p_params_tbl IN BIS_PMV_PAGE_PARAMETER_TBL)
137 RETURN VARCHAR2;
138
139 FUNCTION vac_detail_tth_suph(p_params_tbl IN BIS_PMV_PAGE_PARAMETER_TBL)
140 RETURN VARCHAR2;
141
142 FUNCTION vac_detail_tah_orgh(p_params_tbl IN BIS_PMV_PAGE_PARAMETER_TBL)
143 RETURN VARCHAR2;
144
145 FUNCTION vac_detail_tah_suph(p_params_tbl IN BIS_PMV_PAGE_PARAMETER_TBL)
146 RETURN VARCHAR2;
147
148 FUNCTION vac_detail_vag_orgh(p_params_tbl IN BIS_PMV_PAGE_PARAMETER_TBL)
149 RETURN VARCHAR2;
150
151 FUNCTION vac_detail_vag_suph(p_params_tbl IN BIS_PMV_PAGE_PARAMETER_TBL)
152 RETURN VARCHAR2;
153
154 FUNCTION vac_detail_vst_orgh(p_params_tbl IN BIS_PMV_PAGE_PARAMETER_TBL)
155 RETURN VARCHAR2;
156
157 FUNCTION vac_detail_vst_suph(p_params_tbl IN BIS_PMV_PAGE_PARAMETER_TBL)
158 RETURN VARCHAR2;
159
160 END hri_oltp_pmv_dynamic;