[Home] [Help]
PACKAGE: APPS.PER_RECRUITMENT_ACTIVITIES_PKG
Source
1 PACKAGE PER_RECRUITMENT_ACTIVITIES_PKG AUTHID CURRENT_USER as
2 /* $Header: perca01t.pkh 115.1 2003/02/11 11:55:05 eumenyio ship $ */
3 --
4 /* +=======================================================================+
5 | Copyright (c) 1993 Oracle Corporation |
6 | Redwood Shores, California, USA |
7 | All rights reserved. |
8 +=======================================================================+
9 Note
10 Changed X_Parent_Recruitment_Activity_Id to X_Parent_Rec_Activity_Id
11 because was too long otherwise.
12 Name
13 per_recruitment_activities_pkg
14 Purpose
15 Supports the Activity blk in PERWSRA Define Recruitment Activity form
16
17 History
18 03-MAR-94 H.Minton 40.0 Date Created
19 01-JUL-94 H.Minton 40.1 Added procedure chk_auth_date.
20 29-JAN-95 D.Kerr 70.5 Removed WHO-columns for Set8
21 22-MAR-96 A.Mills 70.7 Altered procedure chk_vacancy_
22 dates to accept and test on
23 p_rec_activity_id.
24 ============================================================================*/
25 --
26 -----------------------------------------------------------------------------
27 -- Name --
28 -- Check_Unique_Name --
29 -- Purpose --
30 -- checks that the recruitment activity name is unique. Called from the --
31 -- client side package ACTIVITY_ITEMS from the procedure 'name'. Called --
32 -- on WHEN-VALIDATE-ITEM from Name. --
33 -- --
34 -----------------------------------------------------------------------------
35 --
36 PROCEDURE Check_Unique_Name(P_Name VARCHAR2,
37 P_Business_group_id NUMBER,
38 P_rowid VARCHAR2);
39 --
40 -----------------------------------------------------------------------------
41 --
42 -----------------------------------------------------------------------------
43 -- Name --
44 -- Check_References --
45 -- Purpose --
46 -- checks that deletes cannot take place of a recruitment activity if --
47 -- there are vacancies i.e recruitment_activities_for the recruitment- --
48 -- activity, or if the recruitment activity is being used in an --
49 -- assignment or if the recruitment activity is a parent.
50 -- Arguments --
51 -- See below. --
52 -- Notes --
53 -- --
54
55 -----------------------------------------------------------------------------
56 --
57 PROCEDURE check_References(P_recruitment_activity_id NUMBER,
58 P_Business_group_id NUMBER);
59 --
60 -----------------------------------------------------------------------------
61
62 --
63 -----------------------------------------------------------------------------
64 -- Name --
65 -- chk_org_date --
66 -- Purpose --
67 -- checks that update of the activity start date does not invalidate --
68 -- any of the components of the recruitment activity --
69 -- such as the organization, the parent recruitment activity and any --
70 -- child recruitment activities, and any vacancies.
71 -- Arguments --
72 -- See below. --
73 -- Notes --
74 -- --
75 -----------------------------------------------------------------------------
76 --
77 PROCEDURE chk_org_date(P_date_start DATE,
78 P_org_run_by_Id NUMBER,
79 P_Business_Group_id NUMBER);
80 --
81
82 -----------------------------------------------------------------------------
83 -- Name --
84 -- chk_auth_date --
85 -- Purpose --
86 -- checks that update of the activity start date does not invalidate --
87 -- any of the components of the recruitment activity, in this case it --
88 -- to check that the authoriser is not invalidated. --
89 -- Arguments --
90 -- See below. --
91 -- Notes --
92 -- --
93 -----------------------------------------------------------------------------
94 --
95 PROCEDURE chk_auth_date(P_date_start DATE,
96 P_authorising_person_id NUMBER,
97 P_Business_Group_id NUMBER);
98 --
99 -----------------------------------------------------------------------------
100 -- Name --
101 -- chk_int_cont_date --
102 -- Purpose --
103 -- Checks that on update of the Activity Start that the internal contact--
104 -- is not invalidated. --
105 -- Arguments --
106 -- See below. --
107 -- Notes --
108 -- Called from the client side the WVI for the date_start --
109 -----------------------------------------------------------------------------
110 --
111 --
112 PROCEDURE chk_int_cont_date(P_date_start DATE,
113 P_internal_contact_person_id NUMBER,
114 P_Business_Group_id NUMBER);
115 --
116 -----------------------------------------------------------------------------
117 -- Name --
118 -- chk_parent_dates --
119 -- Purpose --
120 -- Validates that the parent rec.act start date is not invalid if the --
121 -- user updates the start date of the recruitment activity. Called from --
122 -- the client side trigger WVI on the rec act Start date. --
123 -- Arguments --
124 -- See below. --
125 -- Notes --
126 -- --
127 -----------------------------------------------------------------------------
128 PROCEDURE chk_parent_dates(P_date_start DATE,
129 P_Business_Group_id NUMBER,
130 P_parent_rec_id NUMBER);
131 --
132 -----------------------------------------------------------------------------
133 -- Name --
134 -- chk_vacancy_dates --
135 -- Purpose --
136 -- Validates that the vacancy start date is not invalid if the --
137 -- user updates the start date of the recruitment activity. Called from --
138 -- the client side trigger WVI on the rec act Start date. --
139 -- Arguments --
140 -- See below. --
141 -- Notes --
142 -- --
143 -----------------------------------------------------------------------------
144 PROCEDURE chk_vacancy_dates(P_date_start DATE,
145 P_Business_Group_id NUMBER,
146 P_rec_activity_id NUMBER);
147 --
148 -----------------------------------------------------------------------------
149 -- Name --
150 -- chk_child_rec_date --
151 -- Purpose --
152 -- Validates that the date is not invalid if the recruitment activity is --
153 -- used as a parent recruitment activity elsewhere. --
154 -- Arguments --
155 -- See below. --
156 -- Notes --
157 -- --
158 -----------------------------------------------------------------------------
159 PROCEDURE chk_child_rec_dates(P_date_start DATE,
160 P_Business_Group_id NUMBER,
161 P_rec_act_id NUMBER);
162 --
163 -----------------------------------------------------------------------------
164 -- Name --
165 -- chk_child_end_dates --
166 -- Purpose --
167 -- Validates that the end date is not invalid if the recruitment activity--
168 -- is used as a parent recruitment activity elsewhere. --
169 -- Arguments --
170 -- See below. --
171 -- Notes --
172 -- --
173 -----------------------------------------------------------------------------
174 PROCEDURE chk_child_end_dates(P_date_end DATE,
175 P_Business_Group_id NUMBER,
176 P_rec_act_id NUMBER);
177 --
178 -----------------------------------------------------------------------------
179 -- Name --
180 -- default_currency_code --
181 -- Purpose --
182 -- to show the default currency code for the legislation of the business --
183 -- group for the recruitment activity. --
184 -----------------------------------------------------------------------------
185 FUNCTION default_currency_code(P_Business_Group_Id NUMBER) return VARCHAR2;
186 --
187 -----------------------------------------------------------------------------
188 -- Name --
189 -- Insert_Row --
190 -- Purpose --
191 -- Table handler procedure. Supports the insert of an ACTIVITY via the --
192 -- Define Recruitment Activity form. --
193 -- Arguments --
194 -- See below. --
195 -- Notes --
196 -- --
197 -----------------------------------------------------------------------------
198 --
199 PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
200 X_Recruitment_Activity_Id IN OUT NOCOPY NUMBER,
201 X_Business_Group_Id NUMBER,
202 X_Authorising_Person_Id NUMBER,
203 X_Run_By_Organization_Id NUMBER,
204 X_Internal_Contact_Person_Id NUMBER,
205 X_Parent_Rec_Activity_Id NUMBER,
206 X_Currency_Code VARCHAR2,
207 X_Date_Start DATE,
208 X_Name VARCHAR2,
209 X_Actual_Cost VARCHAR2,
210 X_Comments varchar2,
211 X_Contact_Telephone_Number VARCHAR2,
212 X_Date_Closing DATE,
213 X_Date_End DATE,
214 X_External_Contact VARCHAR2,
215 X_Planned_Cost VARCHAR2,
216 X_Type VARCHAR2,
217 X_Attribute_Category VARCHAR2,
218 X_Attribute1 VARCHAR2,
219 X_Attribute2 VARCHAR2,
220 X_Attribute3 VARCHAR2,
221 X_Attribute4 VARCHAR2,
222 X_Attribute5 VARCHAR2,
223 X_Attribute6 VARCHAR2,
224 X_Attribute7 VARCHAR2,
225 X_Attribute8 VARCHAR2,
226 X_Attribute9 VARCHAR2,
227 X_Attribute10 VARCHAR2,
228 X_Attribute11 VARCHAR2,
229 X_Attribute12 VARCHAR2,
230 X_Attribute13 VARCHAR2,
231 X_Attribute14 VARCHAR2,
232 X_Attribute15 VARCHAR2,
233 X_Attribute16 VARCHAR2,
234 X_Attribute17 VARCHAR2,
235 X_Attribute18 VARCHAR2,
236 X_Attribute19 VARCHAR2,
237 X_Attribute20 VARCHAR2
238 );
239
240 --
241 -----------------------------------------------------------------------------
242 -- Name --
246 -- of an activity by applying a lock on an activity in the Define --
243 -- Lock_Row --
244 -- Purpose --
245 -- Table handler procedure that supports the insert , update and delete --
247 -- Recruitment Activity form. --
248 -- Arguments --
249 -- Notes --
250 -- None. --
251 -----------------------------------------------------------------------------
252 --
253 PROCEDURE Lock_Row(X_Rowid VARCHAR2,
254 X_Recruitment_Activity_Id NUMBER,
255 X_Business_Group_Id NUMBER,
256 X_Authorising_Person_Id NUMBER,
257 X_Run_By_Organization_Id NUMBER,
258 X_Internal_Contact_Person_Id NUMBER,
259 X_Parent_Rec_Activity_Id NUMBER,
260 X_Currency_Code VARCHAR2,
261 X_Date_Start DATE,
262 X_Name VARCHAR2,
263 X_Actual_Cost VARCHAR2,
264 X_Comments varchar2,
265 X_Contact_Telephone_Number VARCHAR2,
266 X_Date_Closing DATE,
267 X_Date_End DATE,
268 X_External_Contact VARCHAR2,
269 X_Planned_Cost VARCHAR2,
270 X_Type VARCHAR2,
271 X_Attribute_Category VARCHAR2,
272 X_Attribute1 VARCHAR2,
273 X_Attribute2 VARCHAR2,
274 X_Attribute3 VARCHAR2,
275 X_Attribute4 VARCHAR2,
276 X_Attribute5 VARCHAR2,
277 X_Attribute6 VARCHAR2,
278 X_Attribute7 VARCHAR2,
279 X_Attribute8 VARCHAR2,
280 X_Attribute9 VARCHAR2,
281 X_Attribute10 VARCHAR2,
282 X_Attribute11 VARCHAR2,
283 X_Attribute12 VARCHAR2,
284 X_Attribute13 VARCHAR2,
285 X_Attribute14 VARCHAR2,
286 X_Attribute15 VARCHAR2,
287 X_Attribute16 VARCHAR2,
288 X_Attribute17 VARCHAR2,
289 X_Attribute18 VARCHAR2,
290 X_Attribute19 VARCHAR2,
291 X_Attribute20 VARCHAR2
292 );
293 --
294 -----------------------------------------------------------------------------
295 -- Name --
296 -- Update_Row --
297 -- Purpose --
298 -- Table handler procedure that supports the update of an ACTIVITY via --
299 -- Define Recruitment Activity form. --
300 -- Arguments --
301 -- See below. --
302 -- Notes --
303 -- None. --
304 -----------------------------------------------------------------------------
305 --
306
307 PROCEDURE Update_Row(X_Rowid VARCHAR2,
308 X_Recruitment_Activity_Id NUMBER,
309 X_Business_Group_Id NUMBER,
310 X_Authorising_Person_Id NUMBER,
311 X_Run_By_Organization_Id NUMBER,
312 X_Internal_Contact_Person_Id NUMBER,
313 X_Parent_Rec_Activity_Id NUMBER,
314 X_Currency_Code VARCHAR2,
315 X_Date_Start DATE,
316 X_Name VARCHAR2,
317 X_Actual_Cost VARCHAR2,
318 X_Comments varchar2,
319 X_Contact_Telephone_Number VARCHAR2,
320 X_Date_Closing DATE,
321 X_Date_End DATE,
322 X_External_Contact VARCHAR2,
323 X_Planned_Cost VARCHAR2,
324 X_Type VARCHAR2,
325 X_Attribute_Category VARCHAR2,
326 X_Attribute1 VARCHAR2,
330 X_Attribute5 VARCHAR2,
327 X_Attribute2 VARCHAR2,
328 X_Attribute3 VARCHAR2,
329 X_Attribute4 VARCHAR2,
331 X_Attribute6 VARCHAR2,
332 X_Attribute7 VARCHAR2,
333 X_Attribute8 VARCHAR2,
334 X_Attribute9 VARCHAR2,
335 X_Attribute10 VARCHAR2,
336 X_Attribute11 VARCHAR2,
337 X_Attribute12 VARCHAR2,
338 X_Attribute13 VARCHAR2,
339 X_Attribute14 VARCHAR2,
340 X_Attribute15 VARCHAR2,
341 X_Attribute16 VARCHAR2,
342 X_Attribute17 VARCHAR2,
343 X_Attribute18 VARCHAR2,
344 X_Attribute19 VARCHAR2,
345 X_Attribute20 VARCHAR2
346 );
347 --
348 -----------------------------------------------------------------------------
349 -- Name --
350 -- Delete_Row --
351 -- Purpose --
352 -- Table handler procedure that supports the delete of an ACTIVITY via --
353 -- the Define Recruitment Activity form. --
354 -- Arguments --
355 -- See below. --
356 -- Notes --
357 -- --
358 -----------------------------------------------------------------------------
359 --
360
361 PROCEDURE Delete_Row(X_Rowid VARCHAR2);
362
363 --
364
365 END PER_RECRUITMENT_ACTIVITIES_PKG;