[Home] [Help]
PACKAGE: APPS.PER_APP_ASG_PKG
Source
1 package PER_APP_ASG_PKG AUTHID CURRENT_USER as
2 /* $Header: peasg02t.pkh 120.2 2006/05/17 19:20:25 irgonzal ship $ */
3 --
4 -- Procedure
5 -- cleanup_letters
6 -- Purpose
7 -- Remove extra letters for the given assignment
8 -- Arguments
9 procedure cleanup_letters ( p_assignment_id in number ) ;
10
11 procedure insert_row(
12 p_row_id in out nocopy varchar2,
13 p_assignment_id in out nocopy number,
14 p_effective_start_date date,
15 p_effective_end_date date,
16 p_business_group_id number,
17 p_recruiter_id number,
18 p_grade_id number,
19 p_position_id number,
20 p_job_id number,
21 p_assignment_status_type_id number,
22 p_location_id number,
23 p_location_code in out nocopy varchar2,
24 p_person_referred_by_id number,
25 p_supervisor_id number,
26 p_person_id number,
27 p_recruitment_activity_id number,
28 p_source_organization_id number,
29 p_organization_id number,
30 p_people_group_id number,
31 p_people_group_name varchar2 ,
32 p_vacancy_id number,
33 p_assignment_sequence in out nocopy number,
34 p_assignment_type in out nocopy varchar2,
35 p_primary_flag in out nocopy varchar2,
36 p_application_id number,
37 p_change_reason varchar2,
38 p_comment_id number,
39 p_date_probation_end date,
40 p_frequency varchar2,
41 p_frequency_meaning in out nocopy varchar2,
42 p_manager_flag varchar2,
43 p_normal_hours number,
44 p_probation_period number,
45 p_probation_unit varchar2,
46 p_source_type varchar2,
47 p_time_normal_finish varchar2,
48 p_time_normal_start varchar2,
49 p_request_id number,
50 p_program_application_id number,
51 p_program_id number,
52 p_program_update_date date,
53 p_ass_attribute_category varchar2,
54 p_ass_attribute1 varchar2,
55 p_ass_attribute2 varchar2,
56 p_ass_attribute3 varchar2,
57 p_ass_attribute4 varchar2,
58 p_ass_attribute5 varchar2,
59 p_ass_attribute6 varchar2,
60 p_ass_attribute7 varchar2,
61 p_ass_attribute8 varchar2,
62 p_ass_attribute9 varchar2,
63 p_ass_attribute10 varchar2,
64 p_ass_attribute11 varchar2,
65 p_ass_attribute12 varchar2,
66 p_ass_attribute13 varchar2,
67 p_ass_attribute14 varchar2,
68 p_ass_attribute15 varchar2,
69 p_ass_attribute16 varchar2,
70 p_ass_attribute17 varchar2,
71 p_ass_attribute18 varchar2,
72 p_ass_attribute19 varchar2,
73 p_ass_attribute20 varchar2,
74 p_ass_attribute21 varchar2,
75 p_ass_attribute22 varchar2,
76 p_ass_attribute23 varchar2,
77 p_ass_attribute24 varchar2,
78 p_ass_attribute25 varchar2,
79 p_ass_attribute26 varchar2,
80 p_ass_attribute27 varchar2,
81 p_ass_attribute28 varchar2,
82 p_ass_attribute29 varchar2,
83 p_ass_attribute30 varchar2,
84 p_session_date date,
85 p_contract_id number default null,
86 p_cagr_id_flex_num number default null,
87 p_cagr_grade_def_id number default null,
88 p_establishment_id number default null,
89 p_collective_agreement_id number default null,
90 p_notice_period number default null,
91 p_notice_period_uom varchar2 default null,
92 p_employee_category varchar2 default null,
93 p_work_at_home varchar2 default null,
94 p_job_post_source_name varchar2 default null,
95 p_grade_ladder_pgm_id number default null,
96 p_supervisor_assignment_id number default null
97 );
98 -----------------------------------------------------------------------------
99 --
100 -- Standard delete procedure
101 --
102 procedure delete_row(p_row_id varchar2,
103 p_assignment_id number,
104 p_new_end_date date,
105 p_effective_end_date date,
106 p_validation_end_date date,
107 p_session_date date,
108 p_delete_mode varchar2 );
109 -----------------------------------------------------------------------------
110 --
111 -- Standard lock procedure
112 --
113 procedure lock_row(
114 p_row_id varchar2,
115 p_assignment_id number,
116 p_effective_start_date date,
117 p_effective_end_date date,
118 p_business_group_id number,
119 p_recruiter_id number,
120 p_grade_id number,
121 p_position_id number,
122 p_job_id number,
123 p_assignment_status_type_id number,
124 p_location_id number,
125 p_person_referred_by_id number,
126 p_supervisor_id number,
127 p_person_id number,
128 p_recruitment_activity_id number,
129 p_source_organization_id number,
130 p_organization_id number,
131 p_people_group_id number,
132 p_vacancy_id number,
133 p_assignment_sequence number,
134 p_assignment_type varchar2,
135 p_primary_flag varchar2,
136 p_application_id number,
137 p_change_reason varchar2,
138 p_comment_id number,
139 p_date_probation_end date,
140 p_frequency varchar2,
141 p_manager_flag varchar2,
142 p_normal_hours number,
143 p_probation_period number,
144 p_probation_unit varchar2,
145 p_source_type varchar2,
146 p_time_normal_finish varchar2,
147 p_time_normal_start varchar2,
148 p_request_id number,
149 p_program_application_id number,
150 p_program_id number,
151 p_program_update_date date,
152 p_ass_attribute_category varchar2,
153 p_ass_attribute1 varchar2,
154 p_ass_attribute2 varchar2,
155 p_ass_attribute3 varchar2,
156 p_ass_attribute4 varchar2,
157 p_ass_attribute5 varchar2,
158 p_ass_attribute6 varchar2,
159 p_ass_attribute7 varchar2,
160 p_ass_attribute8 varchar2,
161 p_ass_attribute9 varchar2,
162 p_ass_attribute10 varchar2,
163 p_ass_attribute11 varchar2,
164 p_ass_attribute12 varchar2,
165 p_ass_attribute13 varchar2,
166 p_ass_attribute14 varchar2,
167 p_ass_attribute15 varchar2,
168 p_ass_attribute16 varchar2,
169 p_ass_attribute17 varchar2,
170 p_ass_attribute18 varchar2,
171 p_ass_attribute19 varchar2,
172 p_ass_attribute20 varchar2,
173 p_ass_attribute21 varchar2,
174 p_ass_attribute22 varchar2,
175 p_ass_attribute23 varchar2,
176 p_ass_attribute24 varchar2,
177 p_ass_attribute25 varchar2,
178 p_ass_attribute26 varchar2,
179 p_ass_attribute27 varchar2,
180 p_ass_attribute28 varchar2,
181 p_ass_attribute29 varchar2,
182 p_ass_attribute30 varchar2,
183 p_contract_id number,
184 p_cagr_id_flex_num number,
185 p_cagr_grade_def_id number,
186 p_establishment_id number,
187 p_collective_agreement_id number,
188 p_notice_period number,
189 p_notice_period_uom varchar2,
190 p_employee_category varchar2,
191 p_work_at_home varchar2,
192 p_job_post_source_name varchar2,
193 p_grade_ladder_pgm_id number,
194 p_supervisor_assignment_id number
195 ) ;
196 -----------------------------------------------------------------------------
197 --
198 -- Standard update procedure
199 --
200 procedure update_row(
201 p_row_id varchar2,
202 p_assignment_id number,
203 p_effective_start_date date,
204 p_effective_end_date date,
205 p_validation_start_date date,
206 p_business_group_id number,
207 p_recruiter_id number,
208 p_grade_id number,
209 p_position_id number,
210 p_job_id number,
211 p_assignment_status_type_id number,
212 p_per_system_status varchar2,
213 p_location_id number,
214 p_location_code in out nocopy varchar2,
215 p_person_referred_by_id number,
216 p_supervisor_id number,
217 p_person_id number,
218 p_recruitment_activity_id number,
219 p_source_organization_id number,
220 p_organization_id number,
221 p_people_group_id number,
222 p_vacancy_id number,
223 p_assignment_sequence number,
224 p_assignment_type varchar2,
225 p_primary_flag varchar2,
226 p_application_id number,
227 p_change_reason varchar2,
228 p_comment_id number,
229 p_date_probation_end date,
230 p_frequency varchar2,
231 p_frequency_meaning in out nocopy varchar2,
232 p_manager_flag varchar2,
233 p_normal_hours number,
234 p_probation_period number,
235 p_probation_unit varchar2,
236 p_source_type varchar2,
237 p_time_normal_finish varchar2,
238 p_time_normal_start varchar2,
239 p_request_id number,
240 p_program_application_id number,
241 p_program_id number,
242 p_program_update_date date,
243 p_ass_attribute_category varchar2,
244 p_ass_attribute1 varchar2,
245 p_ass_attribute2 varchar2,
246 p_ass_attribute3 varchar2,
247 p_ass_attribute4 varchar2,
248 p_ass_attribute5 varchar2,
249 p_ass_attribute6 varchar2,
250 p_ass_attribute7 varchar2,
251 p_ass_attribute8 varchar2,
252 p_ass_attribute9 varchar2,
253 p_ass_attribute10 varchar2,
254 p_ass_attribute11 varchar2,
255 p_ass_attribute12 varchar2,
256 p_ass_attribute13 varchar2,
257 p_ass_attribute14 varchar2,
258 p_ass_attribute15 varchar2,
259 p_ass_attribute16 varchar2,
260 p_ass_attribute17 varchar2,
261 p_ass_attribute18 varchar2,
262 p_ass_attribute19 varchar2,
263 p_ass_attribute20 varchar2,
264 p_ass_attribute21 varchar2,
265 p_ass_attribute22 varchar2,
266 p_ass_attribute23 varchar2,
267 p_ass_attribute24 varchar2,
268 p_ass_attribute25 varchar2,
269 p_ass_attribute26 varchar2,
270 p_ass_attribute27 varchar2,
271 p_ass_attribute28 varchar2,
272 p_ass_attribute29 varchar2,
273 p_ass_attribute30 varchar2,
274 p_session_date date,
275 p_status_changed boolean,
276 p_contract_id number default null,
277 p_cagr_id_flex_num number default null,
278 p_cagr_grade_def_id number default null,
279 p_establishment_id number default null,
280 p_collective_agreement_id number default null,
281 p_notice_period number default null,
282 p_notice_period_uom varchar2 default null,
283 p_employee_category varchar2 default null,
284 p_work_at_home varchar2 default null,
285 p_job_post_source_name varchar2 default null,
286 p_grade_ladder_pgm_id number default null,
287 p_supervisor_assignment_id number default null,
288 p_payroll_id number default null,--Added for Bug 4861490
289 p_pay_basis_id number default null --Added for BUg 4861490
290 ) ;
291 ----------------------------------------------------------------------
292 -- Validation Procedures ---
293 ----------------------------------------------------------------------
294 -- Procedure
295 -- check_apl_update_allowed
296 -- Purpose
297 -- Determines if the assignment refers to a current applicant
298 -- or an applicant that was subsequently hired. If the assignment
299 -- is for a current applicant, both updates and corrections are
300 -- allowed; if the assignment is for an applicant that was
301 -- later hired, changes are limited to corrections.
302 -- Used to limit changes of applicant assignment information to
303 -- active applications or applications of those subsequently hired.
304 -- Arguments
305 -- See below
306 procedure check_apl_update_allowed( p_application_id in number,
307 p_assignment_id in number,
308 p_person_id in number,
309 p_status out nocopy varchar2 );
310 --
311 -- Procedure
312 -- check_apl_end_date
313 -- Purpose
314 -- Fails if the end date has been set on the given application.
315 -- Used to prevent creation of a new assignment when the application
316 -- has its end date set.
317 -- Arguments
318 -- See below
319 procedure check_apl_end_date ( p_application_id in number ) ;
323 -- Purpose
320 --
321 -- Procedure
322 -- check_current_applicant
324 -- Checks whether the given person is (still) a current applicant
325 -- at the given date
326 -- Arguments
327 -- See below
328 procedure check_current_applicant ( p_person_id in number,
329 p_session_date in date ) ;
330 --
331 --
332 --
333 -- Procedure
334 -- check_valid_status
335 -- Purpose
336 -- Checks that the current status is still active
337 -- Arguments
338 -- See below
339 procedure check_valid_asg_status ( p_business_group_id in number,
340 p_legislation_code in varchar2,
341 p_assignment_status_type_id in number,
342 p_per_system_status in varchar2 );
343 --
344 --
345 -- Procedure
346 -- check_future_stat_change
347 -- Purpose
348 -- Checks that there isn't a status of ACTIVE_APL or ACTIVE_ASSIGN
349 -- at some point
350 -- Arguments
351 -- See below
352 procedure check_future_stat_change ( p_assignment_id in number ) ;
353 --
354 -- Procedure
355 -- check_end_date
356 -- Purpose
357 -- Checks whether the assignment has been ended at some point
358 -- Sets a message so that the user can opt to continue or not.
359 -- Arguments
360 -- See below
361 procedure check_end_date ( p_assignment_id in number,
362 p_warning_set out nocopy boolean ) ;
363 --
364 -- Procedure
365 -- check_assignment_continuity
366 -- Purpose
367 -- Checks that that another assignment exists continuously until the
368 -- application end date ( or end of time )
369 -- Arguments
370 -- See below
371 procedure check_assignment_continuity ( p_business_group_id in number,
372 p_assignment_id in number,
373 p_person_id in number,
374 p_max_end_date in date,
375 p_session_date in date ) ;
376 --
377 -- Procedure
378 -- process_end_status
379 -- Purpose
380 -- Checks that it is ok to set 'TERM_APL' status
381 -- Calls check_assignment_continuity (above)
382 -- and hr_assignment.del_ref_int_check
383 -- Arguments
384 -- See below
385 procedure process_end_status ( p_business_group_id in number,
386 p_assignment_id in number,
387 p_person_id in number,
388 p_max_end_date in date,
389 p_session_date in date,
390 p_application_id in number);
391
392 --
393 -- Procedure
394 -- rec_act_has_source_type
395 -- Purpose
396 -- Checks that the given recruitment activity uses the given
397 -- source type.
398 -- Returns TRUE if the source type is used otherwise FALSE
399 -- Arguments
400 -- See below
401 function rec_act_has_source_type ( p_recruitment_activity_id in number,
402 p_source_type in varchar2 )
403 return boolean ;
404 --
405 -- Procedure
406 -- key_delrec
407 -- Purpose
408 -- Checks the given delete mode is ok for the assignment at operation
409 -- time
410 -- Arguments
411 -- See below
412 procedure key_delrec ( p_business_group_id in number,
413 p_assignment_id in number,
414 p_person_id in number,
415 p_session_date in date,
416 p_validation_start_date in date,
417 p_delete_mode in varchar2 ) ;
418 --
419 -- Procedure
420 -- pre_delete_validation
421 -- Purpose
422 -- Performs pre_delete_validation
423 -- Arguments
424 -- See below
425 procedure pre_delete_validation ( p_business_group_id in number,
426 p_assignment_id in number,
427 p_application_id in number,
428 p_person_id in number,
429 p_session_date in date,
430 p_validation_start_date in date,
431 p_validation_end_date in date,
432 p_delete_mode in varchar2,
433 p_new_end_date in out nocopy date ) ;
434 --
435 --
436 -- Procedure
437 -- post_delete
438 -- Purpose
439 -- Removes related rows after a zap
440 -- Arguments
441 -- See below
442 procedure post_delete ( p_assignment_id in number,
443 p_validation_start_date in date ) ;
444
445 procedure chk_upd_mode ( p_event in varchar2,
446 p_object in varchar2,
447 p_assignment_id in number,
448 p_effective_start_date in date,
449 p_update_mode in varchar2,
450 p_record_status in varchar2,
451 p_per_system_status in varchar2,
452 p_allowed out nocopy varchar2 ) ;
453
454 end PER_APP_ASG_PKG ;