[Home] [Help]
PACKAGE: APPS.PER_VACANCIES_PKG
Source
1 PACKAGE PER_VACANCIES_PKG as
2 /* $Header: pevac01t.pkh 120.1.12000000.2 2007/02/13 09:34:12 sidsaxen ship $ */
3 /*+=========================================================================+
4 | Copyright (c) 1993 Oracle Corporation |
5 | Redwood Shores, California, USA |
6 | All rights reserved. |
7 +=========================================================================+
8 Name
9 per_vacancies_pkg
10 Purpose
11 Supports the VACANCY block in the form PERWSVAC (Define Requistion and
12 Vacancy form).
13 Notes
14
15 History
16 13-APR-94 H.Minton 40.0 Date created.
17
18 23-MAY-94 H.Minton 40.1 Added new functions for folder form.
19
20 19-JAN-95 D.Kerr 70.5 Removed WHO- columns
21
22 17-MAY-95 D.Kerr 70.6 1.Removed p_business_group_id
23 parameter from D_from_updt_rec_act_chk
24 2.Removed check_references1 and
25 renamed check_references2 to
26 check_references.
27 3.Added vacancy_id parameter to
28 delete_row to make ref. int check
29 easier.
30
31 26-JAN-98 I.Harding 110.1 Added extra vacancy_category parameter
32 to insert, update and lock procs.
33
34 25-FEB-98 B.Goodsell 115.1 Added Budget Measurement columns to
35 Table Handler procedures
36 03-JUL-06 avarri 115.4 Modiifed the procedure Check_Unique_Name
37 for 4262036.
38 ============================================================================*/
39 --
40 -----------------------------------------------------------------------------
41 -- Name --
42 -- Check_References --
43 -- Purpose --
44 -- To ensure the referential integrity when a vacancy is deleted from the--
45 -- Define Requisition and Vacancy form. --
46 -----------------------------------------------------------------------------
47 --
48 PROCEDURE Check_References(P_vacancy_id NUMBER);
49
50 ----------------------------------------------------------------------------
51 --
52 -- Name --
53 -- B_counter --
54 -- Purpose --
55 -- The purpose of this function is to return the values for the FOLDER
56 -- block of the forms VIEW VACANCIES.
57 -----------------------------------------------------------------------------
58 FUNCTION B_counter(P_Business_group_id NUMBER,
59 P_vacancy_id NUMBER,
60 P_legislation_code VARCHAR2,
61 P_vac_type VARCHAR2) return NUMBER;
62 ----------------------------------------------------------------------------
63 --
64 -- Name --
65 -- folder_hires --
66 -- Purpose --
67 -- the purpose of this function is to return the number of applicants who
68 -- have been hired as employees as a result of being hired into a vacancy.
69 -- This function is used by the folder form PERWILVA - View Vacancies.
70 -----------------------------------------------------------------------------
71 FUNCTION folder_hires(P_Business_group_id NUMBER,
72 P_vacancy_id NUMBER
73 ) return NUMBER;
74 ----------------------------------------------------------------------------
75 -- Name --
76 -- folder_current --
77 -- Purpose --
78 -- the purpose of this function is to return the number of current openings
79 -- for the vacancy as of the session date i.e it is the initial number of
80 -- openings for the vacancy as when the vacancy was defined minus the
81 -- number of applicants who have been hired into the vacancy.
82 -----------------------------------------------------------------------------
83 FUNCTION folder_current(P_Business_group_id NUMBER,
84 P_vacancy_id NUMBER,
85 P_session_date DATE
86 ) return NUMBER;
87 ----------------------------------------------------------------------------
88 -- Name --
89 -- Check_Unique_Name --
90 -- Purpose --
91 -- checks that the vacancy name is unique. Called from the --
92 -- client side package VACANCY_ITEM from the procedure 'name'. Called --
93 -- on WHEN-VALIDATE-ITEM from Name. --
94 -- --
95 -----------------------------------------------------------------------------
96 --
97 PROCEDURE Check_Unique_Name(P_Name VARCHAR2,
98 P_business_group_id NUMBER,
99 P_rowid VARCHAR2);
100 --
101 -----------------------------------------------------------------------------
102 -- Name --
103 -- Chk_appl_exists --
104 -- Purpose --
105 -- Verify the effective date, you cannot change the effective date of --
106 -- this vacancy to a future date as applications exist within the vacancy--
107 -- availability period. --
108 -- Called from WHEN-VALIDATE-ITEM in the vacancy block. --
109 -- --
110 -----------------------------------------------------------------------------
111 --
112 procedure chk_appl_exists (P_vacancy_id NUMBER,
113 P_vac_date_from DATE,
114 P_vac_date_to DATE,
115 P_end_of_time DATE
116 );
117 --
118 -----------------------------------------------------------------------------
119 -- Name --
120 -- Check_in_req_dates --
121 -- Purpose --
122 -- to check that the vacancy date_from is not < than the requisition date--
123 -- date_from. --
124 -----------------------------------------------------------------------------
125 PROCEDURE Check_in_req_dates(P_requisition_id NUMBER,
126 P_Business_group_id NUMBER,
127 P_vac_date_from DATE);
128 --
129 -----------------------------------------------------------------------------
130 -- Name --
131 -- Chk_dt_to_in_req_dates --
132 -- Purpose --
133 -- Ensure that the vacancy date to is witin the requisition dates. --
134 -- Called from WHEN-VALIDATE-ITEM in the vacancy block. --
135 -- --
136 -----------------------------------------------------------------------------
137 --
138 PROCEDURE Chk_dt_to_in_req_dates(P_requisition_id NUMBER,
139 P_Business_group_id NUMBER,
140 P_vac_date_to DATE);
141 ----------------------------------------------------------------------------
142 -- Name --
143 -- Date_from_upd_validation --
144 -- Purpose --
145 -- Ensure that the vacancy date_from does not invalidate any of the --
146 -- vacancy_for region.
147 -----------------------------------------------------------------------------
148 PROCEDURE Date_from_upd_validation(
149 Pz_vac_date_from DATE,
150 Pz_business_group_id NUMBER,
151 Pz_start_of_time DATE,
152 Pz_end_of_time DATE,
153 Pz_organization_id NUMBER,
154 Pz_position_id NUMBER,
155 Pz_people_group_id NUMBER,
156 Pz_job_id NUMBER,
157 Pz_grade_id NUMBER,
158 Pz_recruiter_id NUMBER,
159 Pz_location_id NUMBER);
160 ----------------------------------------------------------------------------
161 -- Name --
162 -- D_from_updt_rec_act_chk --
163 -- Purpose --
164 -- to check that the vacancy date_from does not invalidate any recruitment
165 -- activity which uses this vacancy. --
166 -----------------------------------------------------------------------------
167 PROCEDURE D_from_updt_rec_act_chk(P_vacancy_id NUMBER,
168 P_vac_date_from DATE,
169 P_vac_date_to DATE,
170 P_end_of_time DATE);
171 -----------------------------------------------------------------------------
172 -- Name --
173 -- D_from_updt_org_chk --
174 -- Purpose --
175 -- Ensure that the vacancy date_from does not invalidate the organization--
176 -- part of the vacancy. --
177 -- Arguments --
178 -- see below. --
179 -----------------------------------------------------------------------------
180 PROCEDURE D_from_updt_org_chk(P_Business_group_id NUMBER,
181 P_vac_date_from DATE,
182 P_organization_id NUMBER);
183 -----------------------------------------------------------------------------
184 -- Name --
185 -- D_from_updt_pos_chk --
186 -- Purpose --
187 -- Ensure that the vacancy date_from does not invalidate the position --
188 -- part of the vacancy. --
189 -- Arguments --
190 -- see below. --
191 -----------------------------------------------------------------------------
192 PROCEDURE D_from_updt_pos_chk(P_Business_group_id NUMBER,
193 P_vac_date_from DATE,
194 P_position_id NUMBER);
195
196 -----------------------------------------------------------------------------
197 -- Name --
198 -- D_from_updt_grp_chk --
199 -- Purpose --
200 -- Ensure that the vacancy date_from does not invalidate the group --
201 -- part of the vacancy. --
202 -- Arguments --
203 -- see below. --
204 -----------------------------------------------------------------------------
205 PROCEDURE D_from_updt_grp_chk(P_vac_date_from DATE,
206 P_start_of_time DATE,
207 P_people_group_id NUMBER);
208 -----------------------------------------------------------------------------
209 -- Name --
210 -- D_from_updt_job_chk --
211 -- Purpose --
212 -- Ensure that the vacancy date_from does not invalidate the job --
213 -- part of the vacancy. --
214 -- Arguments --
215 -- see below. --
216 -----------------------------------------------------------------------------
217 PROCEDURE D_from_updt_job_chk(P_vac_date_from DATE,
218 P_business_group_id NUMBER,
219 P_job_id NUMBER);
220 -----------------------------------------------------------------------------
221 -- Name --
222 -- D_from_updt_grd_chk --
223 -- Purpose --
224 -- Ensure that the vacancy date_from does not invalidate the grade --
225 -- part of the vacancy. --
226 -- Arguments --
227 -- see below. --
228 -----------------------------------------------------------------------------
229 PROCEDURE D_from_updt_grd_chk(P_vac_date_from DATE,
230 P_business_group_id NUMBER,
231 P_grade_id NUMBER);
232
233 -----------------------------------------------------------------------------
234 -- Name --
235 -- D_from_updt_loc_chk --
236 -- Purpose --
237 -- Ensure that the vacancy date_from does not invalidate the location --
238 -- part of the vacancy. --
239 -- Arguments --
240 -- see below. --
241 -----------------------------------------------------------------------------
242 PROCEDURE D_from_updt_loc_chk(P_vac_date_from DATE,
243 P_end_of_time DATE,
244 P_location_id NUMBER);
245 -----------------------------------------------------------------------------
246 -- Name --
247 -- D_from_updt_person
248 -- Purpose --
249 -- Ensure that the vacancy date_from does not invalidate the recruiter --
250 -- part of the vacancy. --
251 -- Arguments --
252 -- see below. --
253 -----------------------------------------------------------------------------
254 PROCEDURE D_from_updt_person(P_vac_date_from DATE,
255 P_recruiter_id NUMBER,
256 P_business_group_id NUMBER);
257
258 -----------------------------------------------------------------------------
259 -- Name --
260 -- FUNCTION get_people_group
261 -- Purpose --
262 -- to get the people_group_structure for the group key flexfield in the --
263 -- vacancy block of PERWSVAC.l
267 FUNCTION get_people_group(P_Business_Group_Id NUMBER) return VARCHAR2;
264 -- Arguments --
265 -- see below. --
266 -----------------------------------------------------------------------------
268
269 -----------------------------------------------------------------------------
270 -- Name --
271 -- Insert_Row --
272 -- Purpose --
273 -- Table handler procedure. Supports the insert of a VACANCY via the --
274 -- Define Requistion and Vacancy form. --
275 -- Arguments --
276 -- See below. --
277 -- Notes --
278 -- --
279 -----------------------------------------------------------------------------
280 --
281 PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
282 X_Vacancy_Id IN OUT NOCOPY NUMBER,
283 X_Business_Group_Id NUMBER,
284 X_Position_Id NUMBER,
285 X_Job_Id NUMBER,
286 X_Grade_Id NUMBER,
287 X_Organization_Id NUMBER,
288 X_Requisition_Id NUMBER,
289 X_People_Group_Id NUMBER,
290 X_People_Group_Name VARCHAR2,
291 X_Location_Id NUMBER,
292 X_Recruiter_Id NUMBER,
293 X_Date_From DATE,
294 X_Name VARCHAR2,
295 X_Comments VARCHAR2,
296 X_Date_To DATE,
297 X_Description VARCHAR2,
298 X_Vacancy_category varchar2,
299 X_Number_Of_Openings NUMBER,
300 X_Status VARCHAR2,
301 X_Budget_Measurement_Type VARCHAR2,
302 X_Budget_Measurement_Value NUMBER,
303 X_Attribute_Category VARCHAR2,
304 X_Attribute1 VARCHAR2,
305 X_Attribute2 VARCHAR2,
306 X_Attribute3 VARCHAR2,
307 X_Attribute4 VARCHAR2,
308 X_Attribute5 VARCHAR2,
309 X_Attribute6 VARCHAR2,
310 X_Attribute7 VARCHAR2,
311 X_Attribute8 VARCHAR2,
312 X_Attribute9 VARCHAR2,
313 X_Attribute10 VARCHAR2,
314 X_Attribute11 VARCHAR2,
315 X_Attribute12 VARCHAR2,
316 X_Attribute13 VARCHAR2,
317 X_Attribute14 VARCHAR2,
318 X_Attribute15 VARCHAR2,
319 X_Attribute16 VARCHAR2,
320 X_Attribute17 VARCHAR2,
321 X_Attribute18 VARCHAR2,
322 X_Attribute19 VARCHAR2,
323 X_Attribute20 VARCHAR2
324 );
325 --
326 -----------------------------------------------------------------------------
327 -- Name --
328 -- Lock_Row --
329 -- Purpose --
330 -- Table handler procedure that supports the insert , update and delete --
331 -- of an activity by applying a lock on a vacancy in the Define --
332 -- Requistion and Vacancy form. --
333 -- Arguments --
334 -- Notes --
335 -- None. --
336 -----------------------------------------------------------------------------
337 --
338 PROCEDURE Lock_Row(X_Rowid VARCHAR2,
339 X_Vacancy_Id NUMBER,
340 X_Business_Group_Id NUMBER,
341 X_Position_Id NUMBER,
342 X_Job_Id NUMBER,
343 X_Grade_Id NUMBER,
344 X_Organization_Id NUMBER,
345 X_Requisition_Id NUMBER,
346 X_People_Group_Id NUMBER,
350 X_Name VARCHAR2,
347 X_Location_Id NUMBER,
348 X_Recruiter_Id NUMBER,
349 X_Date_From DATE,
351 X_Comments VARCHAR2,
352 X_Date_To DATE,
353 X_Description VARCHAR2,
354 X_Vacancy_category VARCHAR2,
355 X_Number_Of_Openings NUMBER,
356 X_Status VARCHAR2,
357 X_Budget_Measurement_Type VARCHAR2,
358 X_Budget_Measurement_Value NUMBER,
359 X_Attribute_Category VARCHAR2,
360 X_Attribute1 VARCHAR2,
361 X_Attribute2 VARCHAR2,
362 X_Attribute3 VARCHAR2,
363 X_Attribute4 VARCHAR2,
364 X_Attribute5 VARCHAR2,
365 X_Attribute6 VARCHAR2,
366 X_Attribute7 VARCHAR2,
367 X_Attribute8 VARCHAR2,
368 X_Attribute9 VARCHAR2,
369 X_Attribute10 VARCHAR2,
370 X_Attribute11 VARCHAR2,
371 X_Attribute12 VARCHAR2,
372 X_Attribute13 VARCHAR2,
373 X_Attribute14 VARCHAR2,
374 X_Attribute15 VARCHAR2,
375 X_Attribute16 VARCHAR2,
376 X_Attribute17 VARCHAR2,
377 X_Attribute18 VARCHAR2,
378 X_Attribute19 VARCHAR2,
379 X_Attribute20 VARCHAR2
380 );
381 --
382 -----------------------------------------------------------------------------
383 -- Name --
384 -- Update_Row --
385 -- Purpose --
386 -- Table handler procedure that supports the update of a VACANCY via --
387 -- Define Requistion and Vacancy form. --
388 -- Arguments --
389 -- See below. --
390 -- Notes --
391 -- None. --
392 -----------------------------------------------------------------------------
393 --
394 PROCEDURE Update_Row(X_Rowid VARCHAR2,
395 X_Vacancy_Id NUMBER,
396 X_Business_Group_Id NUMBER,
397 X_Position_Id NUMBER,
398 X_Job_Id NUMBER,
399 X_Grade_Id NUMBER,
400 X_Organization_Id NUMBER,
401 X_Requisition_Id NUMBER,
402 X_People_Group_Id NUMBER,
403 X_People_Group_Name VARCHAR2,
404 X_Location_Id NUMBER,
405 X_Recruiter_Id NUMBER,
406 X_Date_From DATE,
407 X_Name VARCHAR2,
408 X_Comments VARCHAR2,
409 X_Date_To DATE,
410 X_Description VARCHAR2,
411 X_Vacancy_category varchar2,
412 X_Number_Of_Openings NUMBER,
413 X_Status VARCHAR2,
414 X_Budget_Measurement_Type VARCHAR2,
415 X_Budget_Measurement_Value NUMBER,
416 X_Attribute_Category VARCHAR2,
417 X_Attribute1 VARCHAR2,
418 X_Attribute2 VARCHAR2,
419 X_Attribute3 VARCHAR2,
420 X_Attribute4 VARCHAR2,
421 X_Attribute5 VARCHAR2,
422 X_Attribute6 VARCHAR2,
423 X_Attribute7 VARCHAR2,
424 X_Attribute8 VARCHAR2,
425 X_Attribute9 VARCHAR2,
426 X_Attribute10 VARCHAR2,
427 X_Attribute11 VARCHAR2,
428 X_Attribute12 VARCHAR2,
429 X_Attribute13 VARCHAR2,
430 X_Attribute14 VARCHAR2,
431 X_Attribute15 VARCHAR2,
432 X_Attribute16 VARCHAR2,
433 X_Attribute17 VARCHAR2,
434 X_Attribute18 VARCHAR2,
435 X_Attribute19 VARCHAR2,
436 X_Attribute20 VARCHAR2
437 );
438 --
439 -----------------------------------------------------------------------------
440 -- Name --
441 -- Delete_Row --
442 -- Purpose --
443 -- Table handler procedure that supports the delete of a VACANCY via --
444 -- the Define Requistion and Vacancy form. --
445 -- Arguments --
446 -- See below. --
447 -- Notes --
448 -- --
449 -----------------------------------------------------------------------------
450 --
451 PROCEDURE Delete_Row(X_Rowid VARCHAR2,
452 X_vacancy_id in number );
453
454 g_Recinfo per_vacancies%ROWTYPE;
455
456 END PER_VACANCIES_PKG;