1 Package hr_applicant_internal AUTHID CURRENT_USER as
2 /* $Header: peaplbsi.pkh 120.1 2005/10/25 00:28 risgupta noship $ */
3 --
4 -- These procedures are for internal use. Only by Development.
5 -- -------------------------------------------------------------------------- +
6 -- |--------------------< create_applicant_anytime >------------------------- |
7 -- -------------------------------------------------------------------------- +
8 -- This creates an application with default information and transforms
9 -- an existing person into an applicant.
10 --
11 -- To create a new person as an applicant then use the
12 -- hr_applicant_api.create_applicant() API
13 --
14 procedure create_applicant_anytime
15 (p_effective_date in date
16 ,p_person_id in number
17 ,p_applicant_number in out nocopy varchar2
18 ,p_per_object_version_number in out nocopy number
19 ,p_vacancy_id in number
20 ,p_person_type_id in number
21 ,p_assignment_status_type_id in number
22 ,p_application_id out nocopy number
23 ,p_assignment_id out nocopy number
24 ,p_apl_object_version_number out nocopy number
25 ,p_asg_object_version_number out nocopy number
26 ,p_assignment_sequence out nocopy number
27 ,p_per_effective_start_date out nocopy date
28 ,p_per_effective_end_date out nocopy DATE
29 ,p_appl_override_warning OUT NOCOPY boolean
30 );
31 -- ------------------------------------------------------------------------- +
32 -- --------------------< override_future_applications >--------------------- |
33 -- ------------------------------------------------------------------------- +
34 -- Returns 'Y' if future applications exist; otherwise returns 'N'
35 --
36 FUNCTION override_future_applications
37 (p_person_id IN NUMBER
38 ,p_effective_date IN DATE
39 ) RETURN VARCHAR2;
40 -- ------------------------------------------------------------------------- +
41 -- --------------------< future_apl_asg_exist >----------------------------- |
42 -- ------------------------------------------------------------------------- +
43 -- Returns 'Y' if future applicant assignments exist; otherwise returns 'N'
44 --
45 FUNCTION future_apl_asg_exist
46 (p_person_id IN NUMBER
47 ,p_effective_date IN DATE
48 ,p_application_id IN NUMBER
49 ) RETURN VARCHAR2;
50 -- ------------------------------------------------------------------------- +
51 -- -----------------------< Update_PER_PTU_Records >------------------------ |
52 -- ------------------------------------------------------------------------- +
53 -- Updates the Person and PTU records when tranforming the person into an
54 -- applicant.
55 --
56 PROCEDURE Update_PER_PTU_Records
57 (p_business_group_id IN number
58 ,p_person_id IN number
59 ,p_effective_date IN date
60 ,p_applicant_number IN varchar2
61 ,p_APL_person_type_id IN number
62 ,p_per_effective_start_date out nocopy date
63 ,p_per_effective_end_date out nocopy DATE
64 ,p_per_object_version_number in out nocopy number -- BUG4081676
65 );
66
67 -- ------------------------------------------------------------------------- +
68 -- -----------------------< Update_PER_PTU_to_EX_APL >---------------------- |
69 -- ------------------------------------------------------------------------- +
70 -- Updates the Person and PTU records when tranforming the person into an
71 -- ex-applicant.
72 --
73 PROCEDURE Update_PER_PTU_to_EX_APL
74 (p_business_group_id IN number
75 ,p_person_id IN number
76 ,p_effective_date IN date
77 ,p_person_type_id IN number
78 ,p_per_effective_start_date out nocopy date
79 ,p_per_effective_end_date out nocopy DATE
80 );
81
82 -- ------------------------------------------------------------------------- +
83 -- ---------------------< Upd_person_EX_APL_and_APL >----------------------- |
84 -- ------------------------------------------------------------------------- +
85 -- Updates the Person and PTU records when tranforming the person into an
86 -- ex-applicant and applicant.
87 --
88 PROCEDURE Upd_person_EX_APL_and_APL
89 (p_business_group_id IN number
90 ,p_person_id IN number
91 ,p_ex_apl_effective_date IN date -- date person becomes EX_APL
92 ,p_apl_effective_date IN date -- date person becomes APL
93 ,p_per_effective_start_date out nocopy date
94 ,p_per_effective_end_date out nocopy DATE
95 );
96 -- -------------------------------------------------------------------------- +
97 -- |--------------------< Update_APL_Assignments >--------------------------- |
98 -- -------------------------------------------------------------------------- +
99 -- Updates the applicant assignments to reflect new application ID
100 --
101 PROCEDURE Update_APL_Assignments
102 (p_business_group_id IN number
103 ,p_old_application_id IN number
104 ,p_new_application_id IN number
105 );
106
107 -- -------------------------------------------------------------------------- +
108 -- |----------------------< create_application >----------------------------- |
109 -- -------------------------------------------------------------------------- +
110 -- Creates the application based on current status of the person.
111 --
112 PROCEDURE Create_Application
113 (p_application_id OUT nocopy number
114 ,p_business_group_id IN number
115 ,p_person_id IN number
116 ,p_effective_date IN date
117 ,p_date_received OUT nocopy date
118 ,p_object_version_number OUT nocopy number
119 ,p_appl_override_warning OUT nocopy boolean
120 ,p_validate_df_flex IN boolean default true -- bug 4689836
121 ) ;
122 --
123 -- ------------------------------------------------------------------------ +
124 -- -------------------< generate_applicant_number >------------------------ |
125 -- ------------------------------------------------------------------------ +
126 procedure generate_applicant_number
127 (p_business_group_id IN NUMBER
128 ,p_person_id IN NUMBER
129 ,p_effective_date IN DATE
130 ,p_party_id IN NUMBER
131 ,p_date_of_birth IN DATE
132 ,p_start_date IN DATE
133 ,p_applicant_number IN OUT NOCOPY VARCHAR2);
134 --
135 end hr_applicant_internal;