1 Package IRC_VACANCY_CONSIDERATIONS_API AUTHID CURRENT_USER as
2 /* $Header: irivcapi.pkh 120.2 2008/02/21 14:29:37 viviswan noship $ */
3 /*#
4 * This package contains APIs for marking the consideration status of a
5 * candidate for a vacancy.
6 * @rep:scope public
7 * @rep:product irc
8 * @rep:displayname Vacancy Consideration
9 */
10 --
11 -- ----------------------------------------------------------------------------
12 -- |-----------------------< create_vacancy_consideration >-------------------|
13 -- ----------------------------------------------------------------------------
14 --
15 -- {Start Of Comments}
16 /*#
17 * This API creates a consideration status for a candidate for a vacancy.
18 *
19 * If the consideration status is PURSUE then a notification will be sent to
20 * the candidate to ask them to apply for the vacancy. If the consideration
21 * status is REJECT then the candidate will not show up in searches for
22 * candidates for this vacancy. If the status is CONSIDER then no further
23 * action is taken.
24 *
25 * <p><b>Licensing</b><br>
26 * This API is licensed for use with iRecruitment.
27 *
28 * <p><b>Prerequisites</b><br>
29 * The vacancy and the candidate must exist in the database
30 *
31 * <p><b>Post Success</b><br>
32 * The vacancy consideration status is recorded in the database, and a
33 * notification may be sent to the candidate
34 *
35 * <p><b>Post Failure</b><br>
36 * The vacancy consideration status will not be stored and an error will be
37 * raised
38 * @param p_validate If true, then validation alone will be performed and the
39 * database will remain unchanged. If false and all validation checks pass,
40 * then the database will be modified.
41 * @param p_person_id Identifies the person for whom you create the
42 * consideration status record.
43 * @param p_vacancy_id Identifies the vacancy that the candidate is being
44 * considered for
45 * @param p_consideration_status Indicates the consideration status (PURSUE,
46 * CONSIDER or NO)
47 * @param p_vacancy_consideration_id If p_validate is false, then this uniquely
48 * identifies the consideration status recorded. If p_validate is true, then
49 * set to null.
50 * @param p_object_version_number If p_validate is false, then set to the
51 * version number of the created consideration status. If p_validate is true,
52 * then the value will be null.
53 * @param p_effective_date Reference date for validating lookup values are
54 * applicable during the start to end active date range. This date does not
55 * determine when the changes take effect.
56 * @rep:displayname Create Vacancy Consideration
57 * @rep:category BUSINESS_ENTITY IRC_VACANCY_CONSIDERATION
58 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
59 * @rep:scope public
60 * @rep:lifecycle active
61 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
62 */
63 --
64 -- {End Of Comments}
65 --
66 procedure create_vacancy_consideration
67 (p_validate in boolean default false
68 ,p_person_id in number
69 ,p_vacancy_id in number
70 ,p_consideration_status in varchar2 default 'CONSIDER'
71 ,p_vacancy_consideration_id out nocopy number
72 ,p_object_version_number out nocopy number
73 ,p_effective_date in date
74 );
75 --
76 -- ----------------------------------------------------------------------------
77 -- |-----------------------< update_vacancy_consideration >-------------------|
78 -- ----------------------------------------------------------------------------
79 --
80 -- {Start Of Comments}
81 /*#
82 * This API updates a consideration status for a candidate for a vacancy.
83 *
84 * If the consideration status is PURSUE then a notification will be sent to
85 * the candidate to ask them to apply for the vacancy. If the consideration
86 * status is NO then the candidate will not show up in searches for candidates
87 * for this vacancy. If the status is CONSIDER then no further action is taken.
88 *
89 * <p><b>Licensing</b><br>
90 * This API is licensed for use with iRecruitment.
91 *
92 * <p><b>Prerequisites</b><br>
93 * The vacancy consideration must already exist
94 *
95 * <p><b>Post Success</b><br>
96 * The vacancy consideration record is updated
97 *
98 * <p><b>Post Failure</b><br>
99 * The vacancy consideration record will not be updated and an error will be
100 * raised
101 * @param p_validate If true, then validation alone will be performed and the
102 * database will remain unchanged. If false and all validation checks pass,
103 * then the database will be modified.
104 * @param p_vacancy_consideration_id Identifies the vacancy consideration
105 * record to be updated
106 * @param p_party_id Obsolete parameter. Do not use
107 * @param p_consideration_status Indicates the consideration status (PURSUE,
108 * CONSIDER or NO)
109 * @param p_object_version_number Pass in the current version number of the
110 * consideration status to be updated. When the API completes if p_validate is
111 * false, will be set to the new version number of the updated consideration
112 * status. If p_validate is true will be set to the same value which was passed
113 * in.
114 * @param p_effective_date Reference date for validating lookup values are
115 * applicable during the start to end active date range. This date does not
116 * determine when the changes take effect.
117 * @rep:displayname Update Vacancy Consideration
118 * @rep:category BUSINESS_ENTITY IRC_VACANCY_CONSIDERATION
119 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
120 * @rep:scope public
121 * @rep:lifecycle active
122 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
123 */
124 --
125 -- {End Of Comments}
126 --
127 procedure update_vacancy_consideration
128 (p_validate in boolean default false
129 ,p_vacancy_consideration_id in number
130 ,p_party_id in number default hr_api.g_number
131 ,p_consideration_status in varchar2 default hr_api.g_varchar2
132 ,p_object_version_number in out nocopy number
133 ,p_effective_date in date
134 );
135 --
136 -- ----------------------------------------------------------------------------
137 -- |-----------------------< delete_vacancy_consideration >-------------------|
138 -- ----------------------------------------------------------------------------
139 --
140 -- {Start Of Comments}
141 /*#
142 * This API removes a vacancy consideration status.
143 *
144 * If a notification has been sent to the candidate, it will not be unsent.
145 *
146 * <p><b>Licensing</b><br>
147 * This API is licensed for use with iRecruitment.
148 *
149 * <p><b>Prerequisites</b><br>
150 * The vacancy consideration must already exist
151 *
152 * <p><b>Post Success</b><br>
153 * The vacancy consideration record is deleted
154 *
155 * <p><b>Post Failure</b><br>
156 * The vacancy consideration record will not be deleted and an error will be
157 * raised
158 * @param p_validate If true, then validation alone will be performed and the
159 * database will remain unchanged. If false and all validation checks pass,
160 * then the database will be modified.
161 * @param p_vacancy_consideration_id Identifies the vacancy consideration
162 * record to be deleted
163 * @param p_object_version_number Current version number of the consideration
164 * status to be deleted.
165 * @rep:displayname Delete Vacancy Consideration
166 * @rep:category BUSINESS_ENTITY IRC_VACANCY_CONSIDERATION
167 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
168 * @rep:scope public
169 * @rep:lifecycle active
170 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
171 */
172 --
173 -- {End Of Comments}
174 --
175 procedure delete_vacancy_consideration
176 (p_validate in boolean default false
177 ,p_vacancy_consideration_id in number
178 ,p_object_version_number in number
179 );
180 --
181 -- ----------------------------------------------------------------------------
182 -- |--------------------------< NOTIFY_SEEKER_IF_REQUIRED >-------------------|
183 -- ----------------------------------------------------------------------------
184 -- Comment
185 -- This procedure will send an email to a job seeker under certain
186 -- circumstances.
187 --
188 -- Access Status:
189 -- Private
190 --
191 -- {End Of Comments}
192 --
193 procedure notify_seeker_if_required
194 (
195 p_person_id in number
196 ,p_vacancy_id in number
197 ,p_consideration_status in varchar2
198 ,p_effective_date in date
199 ,p_validate_only in boolean);
200 end IRC_VACANCY_CONSIDERATIONS_API;