1 package PER_APPLICANT_PKG AUTHID CURRENT_USER as
2 /* $Header: peper02t.pkh 120.1.12020000.1 2012/06/29 01:42:14 appldev ship $ */
3
4 --
5 procedure insert_row ( p_rowid in out nocopy varchar2
6 ,p_business_group_id NUMBER
7 ,p_person_type_id in out nocopy NUMBER
8 ,p_person_id in out nocopy NUMBER
9 ,p_effective_start_date DATE
10 ,p_effective_end_date DATE
11 ,p_last_name VARCHAR2
12 ,p_first_name VARCHAR2
13 ,p_title VARCHAR2
14 ,p_full_name VARCHAR2
15 ,p_sex VARCHAR2
16 ,p_work_telephone VARCHAR2
17 ,p_applicant_number in out nocopy VARCHAR2
18 ,p_assignment_status_type_id NUMBER
19 ,p_request_id NUMBER
20 ,p_program_application_id NUMBER
21 ,p_program_id NUMBER
22 ,p_program_update_date DATE
23 ,p_attribute_category VARCHAR2
24 ,p_attribute1 VARCHAR2
25 ,p_attribute2 VARCHAR2
26 ,p_attribute3 VARCHAR2
27 ,p_attribute4 VARCHAR2
28 ,p_attribute5 VARCHAR2
29 ,p_attribute6 VARCHAR2
30 ,p_attribute7 VARCHAR2
31 ,p_attribute8 VARCHAR2
32 ,p_attribute9 VARCHAR2
33 ,p_attribute10 VARCHAR2
34 ,p_attribute11 VARCHAR2
35 ,p_attribute12 VARCHAR2
36 ,p_attribute13 VARCHAR2
37 ,p_attribute14 VARCHAR2
38 ,p_attribute15 VARCHAR2
39 ,p_attribute16 VARCHAR2
40 ,p_attribute17 VARCHAR2
41 ,p_attribute18 VARCHAR2
42 ,p_attribute19 VARCHAR2
43 ,p_attribute20 VARCHAR2
44 ,p_attribute21 VARCHAR2
45 ,p_attribute22 VARCHAR2
46 ,p_attribute23 VARCHAR2
47 ,p_attribute24 VARCHAR2
48 ,p_attribute25 VARCHAR2
49 ,p_attribute26 VARCHAR2
50 ,p_attribute27 VARCHAR2
51 ,p_attribute28 VARCHAR2
52 ,p_attribute29 VARCHAR2
53 ,p_attribute30 VARCHAR2
54 ,p_per_information_category VARCHAR2
55 ,p_per_information1 VARCHAR2
56 ,p_per_information2 VARCHAR2
57 ,p_per_information3 VARCHAR2
58 ,p_per_information4 VARCHAR2
59 ,p_per_information5 VARCHAR2
60 ,p_per_information6 VARCHAR2
61 ,p_per_information7 VARCHAR2
62 ,p_per_information8 VARCHAR2
63 ,p_per_information9 VARCHAR2
64 ,p_per_information10 VARCHAR2
65 ,p_per_information11 VARCHAR2
66 ,p_per_information12 VARCHAR2
67 ,p_per_information13 VARCHAR2
68 ,p_per_information14 VARCHAR2
69 ,p_per_information15 VARCHAR2
70 ,p_per_information16 VARCHAR2
71 ,p_per_information17 VARCHAR2
72 ,p_per_information18 VARCHAR2
73 ,p_per_information19 VARCHAR2
74 ,p_per_information20 VARCHAR2
75 ,p_per_information21 VARCHAR2
76 ,p_per_information22 VARCHAR2
77 ,p_per_information23 VARCHAR2
78 ,p_per_information24 VARCHAR2
79 ,p_per_information25 VARCHAR2
80 ,p_per_information26 VARCHAR2
81 ,p_per_information27 VARCHAR2
82 ,p_per_information28 VARCHAR2
83 ,p_per_information29 VARCHAR2
84 ,p_per_information30 VARCHAR2
85 ,p_style VARCHAR2
86 ,p_address_line1 VARCHAR2
87 ,p_address_line2 VARCHAR2
88 ,p_address_line3 VARCHAR2
89 ,p_address_type VARCHAR2
90 ,p_country VARCHAR2
91 ,p_postal_code VARCHAR2
92 ,p_region_1 VARCHAR2
93 ,p_region_2 VARCHAR2
94 ,p_region_3 VARCHAR2
95 ,p_telephone_number_1 VARCHAR2
96 ,p_telephone_number_2 VARCHAR2
97 ,p_telephone_number_3 VARCHAR2
98 ,p_town_or_city VARCHAR2
99 ,p_addr_attribute_category VARCHAR2
100 ,p_addr_attribute1 VARCHAR2
101 ,p_addr_attribute2 VARCHAR2
102 ,p_addr_attribute3 VARCHAR2
103 ,p_addr_attribute4 VARCHAR2
104 ,p_addr_attribute5 VARCHAR2
105 ,p_addr_attribute6 VARCHAR2
106 ,p_addr_attribute7 VARCHAR2
107 ,p_addr_attribute8 VARCHAR2
108 ,p_addr_attribute9 VARCHAR2
109 ,p_addr_attribute10 VARCHAR2
110 ,p_addr_attribute11 VARCHAR2
111 ,p_addr_attribute12 VARCHAR2
112 ,p_addr_attribute13 VARCHAR2
113 ,p_addr_attribute14 VARCHAR2
114 ,p_addr_attribute15 VARCHAR2
115 ,p_addr_attribute16 VARCHAR2
116 ,p_addr_attribute17 VARCHAR2
117 ,p_addr_attribute18 VARCHAR2
118 ,p_addr_attribute19 VARCHAR2
119 ,p_addr_attribute20 VARCHAR2
120 -- ***** Start new code for bug 2711964 **************
121 ,p_add_information13 VARCHAR2
122 ,p_add_information14 VARCHAR2
123 ,p_add_information15 VARCHAR2
124 ,p_add_information16 VARCHAR2
125 ,p_add_information17 VARCHAR2
126 ,p_add_information18 VARCHAR2
127 ,p_add_information19 VARCHAR2
128 ,p_add_information20 VARCHAR2
129 -- ***** End new code for bug 2711964 ***************
130 ,p_date_received DATE
131 ,p_current_employer VARCHAR2
132 ,p_appl_attribute_category VARCHAR2
133 ,p_appl_attribute1 VARCHAR2
134 ,p_appl_attribute2 VARCHAR2
135 ,p_appl_attribute3 VARCHAR2
136 ,p_appl_attribute4 VARCHAR2
137 ,p_appl_attribute5 VARCHAR2
138 ,p_appl_attribute6 VARCHAR2
139 ,p_appl_attribute7 VARCHAR2
140 ,p_appl_attribute8 VARCHAR2
141 ,p_appl_attribute9 VARCHAR2
142 ,p_appl_attribute10 VARCHAR2
143 ,p_appl_attribute11 VARCHAR2
144 ,p_appl_attribute12 VARCHAR2
145 ,p_appl_attribute13 VARCHAR2
146 ,p_appl_attribute14 VARCHAR2
147 ,p_appl_attribute15 VARCHAR2
148 ,p_appl_attribute16 VARCHAR2
149 ,p_appl_attribute17 VARCHAR2
150 ,p_appl_attribute18 VARCHAR2
151 ,p_appl_attribute19 VARCHAR2
152 ,p_appl_attribute20 VARCHAR2
153 ,p_recruitment_activity_id NUMBER
154 ,p_source_organization_id NUMBER
155 ,p_person_referred_by_id NUMBER
156 ,p_vacancy_id NUMBER
157 ,p_recruiter_id NUMBER
158 ,p_organization_id NUMBER
159 ,p_people_group_id NUMBER
160 ,p_people_group_name VARCHAR2
161 ,p_job_id NUMBER
162 ,p_position_id NUMBER
163 ,p_grade_id NUMBER
164 ,p_location_id NUMBER
165 ,p_location_code in out nocopy VARCHAR2
166 ,p_source_type VARCHAR2
167 ,p_ass_attribute_category VARCHAR2
168 ,p_ass_attribute1 VARCHAR2
169 ,p_ass_attribute2 VARCHAR2
170 ,p_ass_attribute3 VARCHAR2
171 ,p_ass_attribute4 VARCHAR2
172 ,p_ass_attribute5 VARCHAR2
173 ,p_ass_attribute6 VARCHAR2
174 ,p_ass_attribute7 VARCHAR2
175 ,p_ass_attribute8 VARCHAR2
176 ,p_ass_attribute9 VARCHAR2
177 ,p_ass_attribute10 VARCHAR2
178 ,p_ass_attribute11 VARCHAR2
179 ,p_ass_attribute12 VARCHAR2
180 ,p_ass_attribute13 VARCHAR2
181 ,p_ass_attribute14 VARCHAR2
182 ,p_ass_attribute15 VARCHAR2
183 ,p_ass_attribute16 VARCHAR2
184 ,p_ass_attribute17 VARCHAR2
185 ,p_ass_attribute18 VARCHAR2
186 ,p_ass_attribute19 VARCHAR2
187 ,p_ass_attribute20 VARCHAR2
188 ,p_ass_attribute21 VARCHAR2
189 ,p_ass_attribute22 VARCHAR2
190 ,p_ass_attribute23 VARCHAR2
191 ,p_ass_attribute24 VARCHAR2
192 ,p_ass_attribute25 VARCHAR2
193 ,p_ass_attribute26 VARCHAR2
194 ,p_ass_attribute27 VARCHAR2
195 ,p_ass_attribute28 VARCHAR2
196 ,p_ass_attribute29 VARCHAR2
197 ,p_ass_attribute30 VARCHAR2
198 ,p_per_system_status VARCHAR2
199 ,p_address_set BOOLEAN -- Indicates that an address has been entered
200 ,p_method_of_apl_num_gen VARCHAR2
201 ,p_party_id NUMBER default NULL
202 ,p_date_of_birth DATE default NULL
203 ,p_known_as VARCHAR2 default NULL
204 ,p_marital_status VARCHAR2 default NULL
205 ,p_middle_names VARCHAR2 default NULL
206 ,p_nationality VARCHAR2 default NULL
207 ,p_blood_type VARCHAR2 default NULL
208 ,p_correspondence_language VARCHAR2 default NULL
209 ,p_honors VARCHAR2 default NULL
210 ,p_pre_name_adjunct VARCHAR2 default NULL
211 ,p_rehire_authorizor VARCHAR2 default NULL
212 ,p_rehire_recommendation VARCHAR2 default NULL
213 ,p_resume_exists VARCHAR2 default NULL
214 ,p_resume_last_updated DATE default NULL
215 ,p_second_passport_exists VARCHAR2 default NULL
216 ,p_student_status VARCHAR2 default NULL
217 ,p_suffix VARCHAR2 default NULL
218 ,p_date_of_death DATE default NULL
219 ,p_uses_tobacco_flag VARCHAR2 default NULL
220 ,p_town_of_birth VARCHAR2 default NULL
221 ,p_region_of_birth VARCHAR2 default NULL
222 ,p_country_of_birth VARCHAR2 default NULL
223 ,p_fast_path_employee VARCHAR2 default NULL
224 ,p_email_address VARCHAR2 default NULL
225 ,p_fte_capacity VARCHAR2 default NULL
226 ,p_national_identifier VARCHAR2 default NULL);
227 --
228 -- Name
229 -- lock_row
230 -- Purpose
231 -- Attemps to lock the person row
232 -- Only the person fields are compared. Calls the person package lock
233 -- row procedure
234 -- Arguments
235 --
236 procedure lock_row(p_rowid VARCHAR2
237 ,p_person_id NUMBER
238 ,p_effective_start_date DATE
239 ,p_effective_end_date DATE
240 ,p_business_group_id NUMBER
241 ,p_person_type_id NUMBER
242 ,p_last_name VARCHAR2
243 ,p_start_date DATE
244 ,p_applicant_number VARCHAR2
245 ,p_comment_id NUMBER
246 ,p_current_applicant_flag VARCHAR2
247 ,p_current_emp_or_apl_flag VARCHAR2
248 ,p_current_employee_flag VARCHAR2
249 ,p_date_employee_data_verified DATE
250 ,p_date_of_birth DATE
251 ,p_email_address VARCHAR2
252 ,p_employee_number VARCHAR2
253 ,p_expense_check_send_to_addr VARCHAR2
254 ,p_first_name VARCHAR2
255 ,p_full_name VARCHAR2
256 ,p_known_as VARCHAR2
257 ,p_marital_status VARCHAR2
258 ,p_middle_names VARCHAR2
259 ,p_nationality VARCHAR2
260 ,p_national_identifier VARCHAR2
261 ,p_previous_last_name VARCHAR2
262 ,p_registered_disabled_flag VARCHAR2
263 ,p_sex VARCHAR2
264 ,p_title VARCHAR2
265 ,p_vendor_id NUMBER
266 ,p_work_telephone VARCHAR2
267 ,p_attribute_category VARCHAR2
268 ,p_attribute1 VARCHAR2
269 ,p_attribute2 VARCHAR2
270 ,p_attribute3 VARCHAR2
271 ,p_attribute4 VARCHAR2
272 ,p_attribute5 VARCHAR2
273 ,p_attribute6 VARCHAR2
274 ,p_attribute7 VARCHAR2
275 ,p_attribute8 VARCHAR2
276 ,p_attribute9 VARCHAR2
277 ,p_attribute10 VARCHAR2
278 ,p_attribute11 VARCHAR2
279 ,p_attribute12 VARCHAR2
280 ,p_attribute13 VARCHAR2
281 ,p_attribute14 VARCHAR2
282 ,p_attribute15 VARCHAR2
283 ,p_attribute16 VARCHAR2
284 ,p_attribute17 VARCHAR2
285 ,p_attribute18 VARCHAR2
286 ,p_attribute19 VARCHAR2
287 ,p_attribute20 VARCHAR2
288 ,p_attribute21 VARCHAR2
289 ,p_attribute22 VARCHAR2
290 ,p_attribute23 VARCHAR2
291 ,p_attribute24 VARCHAR2
292 ,p_attribute25 VARCHAR2
293 ,p_attribute26 VARCHAR2
294 ,p_attribute27 VARCHAR2
295 ,p_attribute28 VARCHAR2
296 ,p_attribute29 VARCHAR2
297 ,p_attribute30 VARCHAR2
298 ,p_per_information_category VARCHAR2
299 ,p_per_information1 VARCHAR2
300 ,p_per_information2 VARCHAR2
301 ,p_per_information3 VARCHAR2
302 ,p_per_information4 VARCHAR2
303 ,p_per_information5 VARCHAR2
304 ,p_per_information6 VARCHAR2
305 ,p_per_information7 VARCHAR2
306 ,p_per_information8 VARCHAR2
307 ,p_per_information9 VARCHAR2
308 ,p_per_information10 VARCHAR2
309 ,p_per_information11 VARCHAR2
310 ,p_per_information12 VARCHAR2
311 ,p_per_information13 VARCHAR2
312 ,p_per_information14 VARCHAR2
313 ,p_per_information15 VARCHAR2
314 ,p_per_information16 VARCHAR2
315 ,p_per_information17 VARCHAR2
316 ,p_per_information18 VARCHAR2
317 ,p_per_information19 VARCHAR2
318 ,p_per_information20 VARCHAR2
319 ,p_per_information21 VARCHAR2
320 ,p_per_information22 VARCHAR2
321 ,p_per_information23 VARCHAR2
322 ,p_per_information24 VARCHAR2
323 ,p_per_information25 VARCHAR2
324 ,p_per_information26 VARCHAR2
325 ,p_per_information27 VARCHAR2
326 ,p_per_information28 VARCHAR2
327 ,p_per_information29 VARCHAR2
328 ,p_per_information30 VARCHAR2) ;
329 --
330 -- Fix for 3908271 starts here.
331 --
332 -- Name
333 -- delete_row
334 -- Purpose
335 -- Validates delete and then calls hr_person.applicant_default_deletes
336 -- Arguments
337 -- See below
338 --procedure delete_row ( p_person_id in number,
339 -- p_session_date in date ) ;
340 --
341 -- Fix for 3908271 ends here.
342 --
343 --
344 -- Name
345 -- get_location_code
346 -- Purpose
347 -- Retrieve the location code for the given location id
348 -- Arguments
349 -- See below
350 function get_location_code ( p_location_id in number ) return varchar2 ;
351 --
352 -- Name
353 -- get_db_default_values (overloaded)
354 -- Purpose
355 -- Retrieves the default values used by the form
356 -- These are
357 -- Business Group Defaults
358 -- Default Assignment Status
359 -- Territory Short Name
360 -- Arguments
361 -- See below
362 -- Notes
363 procedure get_db_default_values ( p_business_group_id in number ,
364 p_legislation_code in varchar2,
365 p_bg_name in out nocopy varchar2,
366 p_bg_location_id in out nocopy number,
367 p_bg_working_hours in out nocopy number,
368 p_bg_frequency in out nocopy varchar2,
369 p_bg_default_start_time in out nocopy varchar2,
370 p_bg_default_end_time in out nocopy varchar2,
371 p_system_person_type in out nocopy varchar2,
372 p_person_type_id in out nocopy number,
373 p_ass_status_type_id in out nocopy number,
374 p_ass_status_type_desc in out nocopy varchar2,
375 p_ass_per_system_status in out nocopy varchar2,
376 p_country_meaning in out nocopy varchar2,
377 p_default_yes_desc in out nocopy varchar2,
378 p_default_no_desc in out nocopy varchar2,
379 p_people_group_structure in out nocopy varchar2,
380 p_method_of_apl_gen in out nocopy varchar2);
381 --
382 -- Name
383 -- get_db_default_values
384 -- Purpose
385 -- Retrieves the default values used by the form
386 -- These are
387 -- Business Group Defaults
388 -- Default Assignment Status
389 -- Territory Short Name
390 -- Arguments
391 -- See below
392 -- Notes
393 procedure get_db_default_values ( p_business_group_id in number ,
394 p_legislation_code in varchar2,
395 p_bg_name in out nocopy varchar2,
396 p_bg_location_id in out nocopy number,
400 p_bg_default_end_time in out nocopy varchar2,
397 p_bg_working_hours in out nocopy number,
398 p_bg_frequency in out nocopy varchar2,
399 p_bg_default_start_time in out nocopy varchar2,
401 p_system_person_type in out nocopy varchar2,
402 p_person_type_id in out nocopy number,
403 p_ass_status_type_id in out nocopy number,
404 p_ass_status_type_desc in out nocopy varchar2,
405 p_ass_per_system_status in out nocopy varchar2,
406 p_country_meaning in out nocopy varchar2,
407 p_default_yes_desc in out nocopy varchar2,
408 p_default_no_desc in out nocopy varchar2,
409 p_people_group_structure in out nocopy varchar2,
410 p_method_of_apl_gen in out nocopy varchar2,
411 p_style in out nocopy varchar2);
412 --
413 -- Name
414 -- vacancy_in_activity
415 -- Purpose
416 -- Determines whether the the given vacancy_id is in the given
417 -- recruitment activity.
418 -- Returns TRUE if it is and FALSE otherwise.
419 -- Arguments
420 -- See below
421 -- Notes
422 function vacancy_in_activity ( p_recruitment_activity_id in number,
423 p_vacancy_id in number )return boolean ;
424 --
425 -- Name
426 -- uniq_vac_for_rec_act
427 -- Purpose
428 -- Returns the vacancy_id for the given recruitment activity if there
429 -- is a unique one on the given date
430 -- Otherwise returns NULL
431 -- Arguments
432 -- See below
433 -- Notes
434 function uniq_vac_for_rec_act ( p_recruitment_activity_id in number ,
435 p_date_received in date )
436 return number ;
437 --
438 -- Name
439 -- get_vacancy_details
440 -- Purpose
441 -- Returns all of the details for a given vacancy
442 -- Arguments
443 -- See below
444 -- ***TEMP Should ideally use out variables
445 -- Notes
446 -- If a p_vacancy_name is not null then the other id fields are also assumed
447 -- to have been supplied.
448 procedure get_vacancy_details ( p_vacancy_id in number,
449 p_vacancy_name in out nocopy varchar2,
450 p_recruiter_id in out nocopy number,
451 p_recruiter_name in out nocopy varchar2,
452 p_org_id in out nocopy number,
453 p_org_name in out nocopy varchar2,
454 p_people_group_id in out nocopy number,
455 p_job_id in out nocopy number,
456 p_job_name in out nocopy varchar2,
457 p_pos_id in out nocopy number,
458 p_pos_name in out nocopy varchar2,
459 p_grade_id in out nocopy number,
460 p_grade_name in out nocopy varchar2,
461 p_location_id in out nocopy number,
462 p_location_code in out nocopy varchar2,
463 p_recruiter_number in out nocopy varchar2,
464 --Start changes for bug 8678206
465 p_manager_id in out nocopy number,
466 p_manager_name in out nocopy varchar2,
467 p_manager_number in out nocopy varchar2) ;
468
469 --
470 -- Provide overloaded version of get_vacancy_details to prevent other
471 -- forms/packages breaking due to new argument added in previous
472 -- version.
473 --
474 procedure get_vacancy_details ( p_vacancy_id in number,
475 p_vacancy_name in out nocopy varchar2,
476 p_recruiter_id in out nocopy number,
477 p_recruiter_name in out nocopy varchar2,
478 p_org_id in out nocopy number,
479 p_org_name in out nocopy varchar2,
480 p_people_group_id in out nocopy number,
481 p_job_id in out nocopy number,
482 p_job_name in out nocopy varchar2,
483 p_pos_id in out nocopy number,
484 p_pos_name in out nocopy varchar2,
485 p_grade_id in out nocopy number,
486 p_grade_name in out nocopy varchar2,
487 p_location_id in out nocopy number,
488 p_location_code in out nocopy varchar2,
489 p_recruiter_number in out nocopy varchar2 ) ;
490 --End changes for bug 8678206
491
492 --
493 -- Provide overloaded version of get_vacancy_details to prevent other
494 -- forms/packages breaking due to new argument added in previous
495 -- version.
496 --
497 procedure get_vacancy_details ( p_vacancy_id in number,
498 p_vacancy_name in out nocopy varchar2,
499 p_recruiter_id in out nocopy number,
500 p_recruiter_name in out nocopy varchar2,
501 p_org_id in out nocopy number,
502 p_org_name in out nocopy varchar2,
503 p_people_group_id in out nocopy number,
504 p_job_id in out nocopy number,
505 p_job_name in out nocopy varchar2,
506 p_pos_id in out nocopy number,
507 p_pos_name in out nocopy varchar2,
508 p_grade_id in out nocopy number,
509 p_grade_name in out nocopy varchar2,
510 p_location_id in out nocopy number,
511 p_location_code in out nocopy varchar2) ;
512 --
513 -- Name
514 -- set_vac_from_rec_act
515 -- Purpose
519 -- Arguments
516 -- Sets the vacancy details for a given recruitment activity
517 -- If there is a unique vacancy for the recruitment activity at the
518 -- given date then the vacancy details are retrieved.
520 -- See below
521 -- ***TEMP Should ideally use out variables
522 procedure set_vac_from_rec_act ( p_recruitment_activity_id in number,
523 p_date_received in date,
524 p_vacancy_id in out nocopy number,
525 p_vacancy_name in out nocopy varchar2,
526 p_recruiter_id in out nocopy number,
527 p_recruiter_name in out nocopy varchar2,
528 p_org_id in out nocopy number,
529 p_org_name in out nocopy varchar2,
530 p_people_group_id in out nocopy number,
531 p_job_id in out nocopy number,
532 p_job_name in out nocopy varchar2,
533 p_pos_id in out nocopy number,
534 p_pos_name in out nocopy varchar2,
535 p_grade_id in out nocopy number,
536 p_grade_name in out nocopy varchar2,
537 p_location_id in out nocopy number,
538 p_location_code in out nocopy varchar2,
539 -- Start changes for bug 8678206
540 p_manager_id in out nocopy number,
541 p_manager_name in out nocopy varchar2,
542 p_manager_number in out nocopy varchar2) ;
543 --
544 -- Provide overloaded version of set_vac_from_rec_act to prevent other
545 -- forms/packages breaking due to new argument added in previous
546 -- version.
547 --
548 procedure set_vac_from_rec_act ( p_recruitment_activity_id in number,
549 p_date_received in date,
550 p_vacancy_id in out nocopy number,
551 p_vacancy_name in out nocopy varchar2,
552 p_recruiter_id in out nocopy number,
553 p_recruiter_name in out nocopy varchar2,
554 p_org_id in out nocopy number,
555 p_org_name in out nocopy varchar2,
556 p_people_group_id in out nocopy number,
557 p_job_id in out nocopy number,
558 p_job_name in out nocopy varchar2,
559 p_pos_id in out nocopy number,
560 p_pos_name in out nocopy varchar2,
561 p_grade_id in out nocopy number,
562 p_grade_name in out nocopy varchar2,
563 p_location_id in out nocopy number,
564 p_location_code in out nocopy varchar2 ) ;
565 -- End changes for bug 8678206
566
567 --
568 -- Name
569 -- chk_job_org_pos_comb
570 -- Purpose
571 -- Checks that the given combination of job , organization and position is
572 -- valid.
573 -- Returns TRUE if the combination is valid otherwise FALSE.
574 -- Arguments
575 -- See below
576 function chk_job_org_pos_comb ( p_job_id in number,
577 p_org_id in number,
578 p_pos_id in number,
579 p_date_received in date ) return boolean ;
580 --
581 -- Name
582 -- update_group
583 -- Purpose
584 -- Updates the group keyflex combinations table
585 -- Arguments
586 -- See below
587 -- Notes
588 -- Code taken from PER_ASSIGNMENTS_F_PACKAGE
589 procedure update_group( p_pg_id number,
590 p_group_name varchar2) ;
591 --
592 --
593 -- Name
594 -- exists_val_grd_for_pos_and_job
595 -- Purpose
596 -- Checks that there is a valid grade set up for either the job or position
597 -- at the given date.
598 -- If there valid grades for the position then the corresponing output
599 -- variable is set to TRUE otherwise it is FALSE
600 -- If there valid grades for the job then the corresponing output
601 -- variable is set to TRUE otherwise it is FALSE
602 -- Arguments
603 -- See below
604 procedure exists_val_grd_for_pos_and_job ( p_business_group_id in number,
605 p_date_received in date,
606 p_job_id in number,
607 p_exists_grd_for_job out nocopy boolean,
608 p_pos_id in number,
609 p_exists_grd_for_pos out nocopy boolean );
610
611 --
612 -- Name
613 -- check_apl_num_unique ***OBSOLETE
614 -- Purpose
615 -- Checks that the given application number is unique for the person
616 -- within the given business group.
617 -- This procedure should only be called if the method of number generation
618 -- is not automatic
619 procedure check_apl_num_unique( p_business_group_id in number,
620 p_applicant_number in number ) ;
621 --
622 -- Name
623 -- check_delete_allowed
624 -- Purpose
625 -- Checks delete is allowed. In addition to calling the standard
626 -- pre delete validation procedure this procedure also checks that there
627 -- is only a single person and a single address record for the person.
628 -- Arguments
629 -- See below
630 procedure check_delete_allowed ( p_person_id in number,
631 p_session_date in date ) ;
632 --
633 --
634 -- Name
635 -- create_default_budget_values
636 -- Purpose
637 -- Creates a default set of budget values for an assignment
638 procedure create_default_budget_values ( p_business_group_id in number,
639 p_assignment_id in number,
640 p_effective_start_date in date,
641 p_effective_end_date in date);
642 --
643 -- Name
644 -- check_for_letter_requests
645 -- Purpose
646 -- Create a letter request if there is no entry pending for the
647 -- particular letter type required.
648 --
649 procedure check_for_letter_requests ( p_business_group_id in number,
650 p_per_system_status in varchar2,
654 p_effective_start_date in date,
651 p_assignment_status_type_id in number,
652 p_person_id in number,
653 p_assignment_id in number,
655 p_validation_start_date in date,
656 p_vacancy_id in number );
657 --
658 -- Name
659 -- pre_update
660 -- Purpose
661 -- Used in PERWSAPA to perform referential integrity checks at pre update
662 -- time.
663 -- Checks that if the date received has changed that it is valid
664 procedure pre_update ( p_rowid in varchar2,
665 p_person_id in number,
666 p_business_group_id in number,
667 p_date_received in date,
668 p_old_date_received in out nocopy date ) ;
669 --
670 -- Name
671 -- get_territory_short_name
672 -- Purpose
673 -- Retrieve the territory_short_name for a given territory_code
674 function get_territory_short_name ( p_territory_code in varchar2 )
675 return varchar2 ;
676 pragma restrict_references (get_territory_short_name, WNPS, WNDS, RNPS);
677 --
678 -- Function get_style_name
679 --
680 function get_style_name (p_style in varchar2)
681 return varchar2 ;
682 pragma restrict_references (get_style_name, WNPS, WNDS, RNPS);
683 --
684 end PER_APPLICANT_PKG ;
[Home] [Help]