1 PACKAGE HRI_Parameters AUTHID CURRENT_USER AS
2 /* $Header: hripmgen.pkh 115.11 2002/12/06 15:32:42 cbridge ship $ */
3
4 -- Package Global Variables
5 g_bus_id number;
6 g_orgver number;
7 g_report_name varchar2(8);
8
9 cursor c_area is
10 select '-1' area_code, ' ' area
11 from dual
12 union
13 select lookup_code area_code, meaning area
14 from fnd_lookups
15 where lookup_type = 'AREA'
16 order by 2;
17
18 -- This is the main procedure for this package.
19 -- It is referenced in the AOL function definition for the report.
20 -- It creates all the parameters and passes them to a
21 -- core BIS procedure to create all the formatting of the page
22
23 PROCEDURE Parameter_FormView
24 (p_report_name varchar2,
25 p_param_request varchar2
26 );
27
28 PROCEDURE Param_ActionView(
29 P_ORGANIZATION_ID varchar2 default '-1',
30 P_ORGANIZATION_NAME varchar2,
31 ORGPRC varchar2 default 'SIRO',
32 ORGVER number,
33 BUS_ID number,
34 BPL_ID number,
35 GEOLVL varchar2 default '1',
36 GEOVAL varchar2 default '-1',
37 PRODID varchar2 default '-1',
38 P_JOB_ID varchar2 default '-1',
39 P_JOB_NAME varchar2,
40 JOBCAT varchar2 default '__ALL__',
41 JOBCAT1 varchar2 default '__ALL__',
42 JOBCAT2 varchar2 default '__ALL__',
43 JOBCAT3 varchar2 default '__ALL__',
44 BGTTYP varchar2,
45 VIEWBY varchar2 default 'HR_BIS_TIME',
46 FRQNCY varchar2 default 'CM',
47 P_START_DATE_V varchar2,
48 P_END_DATE_V varchar2,
49 P_LOCATION_ID varchar2 default '-1',
50 P_LOCATION_NAME varchar2,
51 BGT_ID varchar2,
52 COMPID varchar2,
53 CURRCD varchar2,
54 P_REPORT_DATE_V varchar2,
55 EMPAPL varchar2,
56 EXCCUR varchar2,
57 P_GRADE_ID varchar2 default '-1', --bug 1863276 fixed
58 P_GRADE_NAME varchar2, --bug 1863276
59 ORDERB varchar2,
60 PAYRLL varchar2,
61 PERFRT varchar2,
62 PFMEAS varchar2,
63 PROPRN varchar2,
64 SEPRSN varchar2,
65 DISPLY varchar2,
66 DCOUNT varchar2,
67 RPNAME varchar2
68 );
69
70 PROCEDURE Before_Parameter_Form(
71 p_function_code IN VARCHAR2
72 ,p_rdf_filename IN VARCHAR2
73 );
74
75 PROCEDURE After_Parameter_Form;
76
77 FUNCTION Display_Label(
78 p_label_name IN VARCHAR2 )
79 RETURN VARCHAR2;
80
81 PROCEDURE Build_Business_Plan(
82 params IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type
83 ,i IN NUMBER
84 );
85
86 PROCEDURE Build_Geog_Level(
87 params IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type
88 ,i IN NUMBER
89 );
90
91 PROCEDURE Build_Geog_Value(
92 params IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type
93 ,i IN NUMBER
94 );
95
96 PROCEDURE Build_Product (
97 params IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type
98 ,i IN NUMBER
99 );
100
101 PROCEDURE Build_Job_Category (
102 params IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type
103 ,i IN OUT NOCOPY NUMBER
104 ,p_option IN NUMBER
105 );
106
107 PROCEDURE Build_Budget (
108 params IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type
109 ,i IN NUMBER
110 ,P_return_status IN OUT NOCOPY NUMBER
111 );
112
113 -- cbridge, 28/06/2001, added to support lookup from pqh tables
114 PROCEDURE Build_pqh_Budget (
115 params IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type
116 ,i IN NUMBER
117 , p_return_status IN OUT NOCOPY NUMBER
118 );
119
120 PROCEDURE Build_Frequency (
121 params IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type
122 ,i IN NUMBER
123 );
124
125 PROCEDURE Geography_Cross_Validation;
126
127 PROCEDURE Build_Budget_ID(
128 params IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type
129 ,i IN NUMBER
130 );
131
132 PROCEDURE Build_Competence_ID(
133 params IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type
134 ,i IN NUMBER
135 ,P_return_status IN OUT NOCOPY NUMBER
136 );
137
138 PROCEDURE Build_Report_Currency(
139 params IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type
140 ,i IN NUMBER
141 );
142
143 PROCEDURE Build_Display_By(
144 params IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type
145 ,i IN NUMBER
146 );
147
148 PROCEDURE Build_Exclude_Currency(
149 params IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type
150 ,i IN NUMBER
151 );
152
153 /*
154 This procedure was commented out by dsheth on 06-AUG-2001
155 to fix the bug 1863276.
156
157 PROCEDURE Build_Grade_ID(
158 params IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type
159 ,i IN NUMBER
160 );
161 */
162
163 PROCEDURE Build_Employee_Applicant(
164 params IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type
165 ,i IN NUMBER
166 );
167
168 PROCEDURE Build_Order_By(
169 params IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type
170 ,i IN NUMBER
171 ,p_option IN NUMBER
172 );
173
174 PROCEDURE Build_Incl_Subord(
175 params IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type
176 ,i IN NUMBER
177 ,p_option IN NUMBER
178 );
179
180 PROCEDURE Build_Payroll_ID(
181 params IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type
182 ,i IN NUMBER
183 ,P_OPTION IN NUMBER
184 ,P_return_status IN OUT NOCOPY NUMBER
185 );
186
187 PROCEDURE Build_Rep_Dates(
188 params IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type
189 ,i IN NUMBER
190 ,P_OPTION IN NUMBER
191 );
192
193 PROCEDURE Build_lookup_param(
194 params IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type
195 ,i IN NUMBER
196 ,P_LABEL IN VARCHAR2
197 ,P_FORM_NAME IN VARCHAR2
198 ,P_LOOKUP_TYPE IN VARCHAR2
199 ,P_ALL_OPTION IN VARCHAR2
200 );
201
202 PROCEDURE Build_Proficiency_Measure(
203 params IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type
204 ,i IN NUMBER
205 );
206
207 PROCEDURE Build_View_By(
208 params IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type
209 ,i IN NUMBER
210 ,p_option IN NUMBER
211 );
212
213 PROCEDURE Build_LOV(
214 params IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type
215 ,i IN Number
216 ,p_option IN NUMBER
217 ,param_name IN varchar2
218 ,LOV_name IN varchar2
219 );
220
221 -- enhancement 1110938
222 PROCEDURE Build_Organization(
223 params IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type
224 , i IN NUMBER
225 , p_option IN NUMBER
226 );
227
228 -- enhancement 1110938
229 PROCEDURE Build_Job(
230 params IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type
231 , i IN NUMBER
232 , p_option IN NUMBER
233 ,P_return_status IN OUT NOCOPY NUMBER
234 );
235
236 -- enhancement 1110938
237 PROCEDURE Build_Location(
238 params IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type
239 , i IN NUMBER
240 , p_option IN NUMBER
241 );
242
243 PROCEDURE LINK_HRCOMGAP;
244
245 PROCEDURE LINK_HRCOMPEO;
246
247 PROCEDURE LINK_HRCOMREC;
248
249 PROCEDURE LINK_HRMNPBGT;
250
251 PROCEDURE LINK_HRMNPCMP;
252
253 PROCEDURE LINK_HRMNPRAT;
254
255 PROCEDURE LINK_HRMNPSUM;
256
257 PROCEDURE LINK_HRORGBGT;
258
259 PROCEDURE LINK_HRORGCHG;
260
261 PROCEDURE LINK_HRORGSEP;
262
263 PROCEDURE LINK_HRSALCOM;
264
265 PROCEDURE LINK_HRSALGRG;
266
267 PROCEDURE LINK_HRSALGRP;
268
269 PROCEDURE LINK_HRSALSPD;
270
271 PROCEDURE LINK_HRSALTND;
272
273 PROCEDURE LINK_HRTRNSUC;
274
275 PROCEDURE LINK_HRUTLABH;
276
277 PROCEDURE LINK_HRUTLHRS;
278
279 -- cbridge, 28/06/2001, pqh budget reports
280 PROCEDURE LINK_HRMNPPSB;
281 PROCEDURE LINK_HRORGPSB;
282
283
284 -- Added to make the parameter page calls (above) look at the database
285 -- to find their list of values, rather than having them hard coded.
286 -- This reduces the chances of one place being updated, while the other
287 -- isn't. - Bug #1349114 - M.J.Andrews - 31-July-2000
288
289 PROCEDURE LINK_PARAMPAGE
290 ( p_report_name IN VarChar2);
291
292 END HRI_Parameters;
293