1 Package IRC_AGENCY_VACANCIES_API as
2 /* $Header: iriavapi.pkh 120.2 2008/02/21 14:08:33 viviswan noship $ */
3 /*#
4 * This package contains agency vacancy APIs.
5 * @rep:scope public
6 * @rep:product IRC
7 * @rep:displayname Agency Vacancy
8 */
9 --
10 -- ----------------------------------------------------------------------------
11 -- |--------------------------< create_agency_vacancy >-----------------------|
12 -- ----------------------------------------------------------------------------
13 --
14 -- {Start Of Comments}
15 /*#
16 *
17 * This API associates an agency with a vacancy.
18 *
19 * <p><b>Licensing</b><br>
20 * This API is licensed for use with iRecruitment.
21 *
22 * <p><b>Prerequisites</b><br>
23 * The agency and the vacancy must both exist.
24 *
25 * <p><b>Post Success</b><br>
26 * The agency is associated with the vacancy.
27 *
28 * <p><b>Post Failure</b><br>
29 * The agency will not be associated with the vacancy and an error will be
30 * raised.
31 *
32 * @param p_validate If true, then validation alone will be performed and the
33 * database will remain unchanged. If false and all validation checks pass,
34 * then the database will be modified.
35 * @param p_agency_id Identifies the agency.
36 * @param p_vacancy_id Identifies the vacancy.
37 * @param p_start_date The date from which the agency may see that they are
38 * associated with the vacancy.
39 * @param p_end_date The last date on which the agency may see that they are
40 * associated with the vacancy.
41 * @param p_max_allowed_applicants The maximum number of applicants the agency
42 * is allowed to submit for the vacancy.
43 * @param p_manage_applicants_allowed Indicates whether or not the agency can
44 * manage the vacancy (Y or N).
45 * @param p_attribute_category This context value determines which flexfield
46 * structure to use with the descriptive flexfield segments.
47 * @param p_attribute1 Descriptive flexfield segment.
48 * @param p_attribute2 Descriptive flexfield segment.
49 * @param p_attribute3 Descriptive flexfield segment.
50 * @param p_attribute4 Descriptive flexfield segment.
51 * @param p_attribute5 Descriptive flexfield segment.
52 * @param p_attribute6 Descriptive flexfield segment.
53 * @param p_attribute7 Descriptive flexfield segment.
54 * @param p_attribute8 Descriptive flexfield segment.
55 * @param p_attribute9 Descriptive flexfield segment.
56 * @param p_attribute10 Descriptive flexfield segment.
57 * @param p_attribute11 Descriptive flexfield segment.
58 * @param p_attribute12 Descriptive flexfield segment.
59 * @param p_attribute13 Descriptive flexfield segment.
60 * @param p_attribute14 Descriptive flexfield segment.
61 * @param p_attribute15 Descriptive flexfield segment.
62 * @param p_attribute16 Descriptive flexfield segment.
63 * @param p_attribute17 Descriptive flexfield segment.
64 * @param p_attribute18 Descriptive flexfield segment.
65 * @param p_attribute19 Descriptive flexfield segment.
66 * @param p_attribute20 Descriptive flexfield segment.
67 * @param p_attribute21 Descriptive flexfield segment.
68 * @param p_attribute22 Descriptive flexfield segment.
69 * @param p_attribute23 Descriptive flexfield segment.
70 * @param p_attribute24 Descriptive flexfield segment.
71 * @param p_attribute25 Descriptive flexfield segment.
72 * @param p_attribute26 Descriptive flexfield segment.
73 * @param p_attribute27 Descriptive flexfield segment.
74 * @param p_attribute28 Descriptive flexfield segment.
75 * @param p_attribute29 Descriptive flexfield segment.
76 * @param p_attribute30 Descriptive flexfield segment.
77 * @param p_object_version_number If p_validate is false, then set to the
78 * version number of the created association. If p_validate is true, then the
79 * value will be null.
80 * @param p_agency_vacancy_id If p_validate is false, then this uniquely
81 * identifies the association of the agency with the vacancy. If p_validate is
82 * true, then this is set to null.
83 * @rep:displayname Create Agency Vacancy
84 * @rep:category BUSINESS_ENTITY IRC_AGENCY
85 * @rep:lifecycle active
86 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
87 * @rep:scope public
88 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
89 */
90 --
91 -- {End Of Comments}
92 --
93 procedure create_agency_vacancy
94 (p_validate in boolean default false
95 ,p_agency_id in number
96 ,p_vacancy_id in number
97 ,p_start_date in date default null
98 ,p_end_date in date default null
99 ,p_max_allowed_applicants in number default null
100 ,p_manage_applicants_allowed in varchar2 default 'N'
101 ,p_attribute_category in varchar2 default null
102 ,p_attribute1 in varchar2 default null
103 ,p_attribute2 in varchar2 default null
104 ,p_attribute3 in varchar2 default null
105 ,p_attribute4 in varchar2 default null
106 ,p_attribute5 in varchar2 default null
107 ,p_attribute6 in varchar2 default null
108 ,p_attribute7 in varchar2 default null
109 ,p_attribute8 in varchar2 default null
110 ,p_attribute9 in varchar2 default null
111 ,p_attribute10 in varchar2 default null
112 ,p_attribute11 in varchar2 default null
113 ,p_attribute12 in varchar2 default null
114 ,p_attribute13 in varchar2 default null
115 ,p_attribute14 in varchar2 default null
116 ,p_attribute15 in varchar2 default null
117 ,p_attribute16 in varchar2 default null
118 ,p_attribute17 in varchar2 default null
119 ,p_attribute18 in varchar2 default null
120 ,p_attribute19 in varchar2 default null
121 ,p_attribute20 in varchar2 default null
122 ,p_attribute21 in varchar2 default null
123 ,p_attribute22 in varchar2 default null
124 ,p_attribute23 in varchar2 default null
125 ,p_attribute24 in varchar2 default null
126 ,p_attribute25 in varchar2 default null
127 ,p_attribute26 in varchar2 default null
128 ,p_attribute27 in varchar2 default null
129 ,p_attribute28 in varchar2 default null
130 ,p_attribute29 in varchar2 default null
131 ,p_attribute30 in varchar2 default null
132 ,p_object_version_number out nocopy number
133 ,p_agency_vacancy_id out nocopy number
134 );
135 --
136 -- ----------------------------------------------------------------------------
137 -- |--------------------------< update_agency_vacancy >-----------------------|
138 -- ----------------------------------------------------------------------------
139 --
140 -- {Start Of Comments}
141 /*#
142 *
143 * This API updates the association of an agency with a vacancy.
144 *
145 * <p><b>Licensing</b><br>
146 * This API is licensed for use with iRecruitment.
147 *
148 * <p><b>Prerequisites</b><br>
149 * The association must exist.
150 *
151 * <p><b>Post Success</b><br>
152 * The association details will be updated.
153 *
154 * <p><b>Post Failure</b><br>
155 * The association details will not be updated and an error will be raised.
156 *
157 * @param p_validate If true, then validation alone will be performed and the
158 * database will remain unchanged. If false and all validation checks pass,
159 * then the database will be modified.
160 * @param p_agency_vacancy_id Identifies the association of the agency and
161 * vacancy to be updated.
162 * @param p_agency_id Identifies the agency.
163 * @param p_vacancy_id Identifies the vacancy.
164 * @param p_start_date The date from which the agency may see that they are
165 * associated with the vacancy.
166 * @param p_end_date The last date on which the agency may see that they are
167 * associated with the vacancy.
168 * @param p_max_allowed_applicants The maximum number of applicants the agency
169 * is allowed to submit for the vacancy.
170 * @param p_manage_applicants_allowed Indicates whether or not the agency can
171 * manage the vacancy (Y or N).
172 * @param p_attribute_category This context value determines which flexfield
173 * structure to use with the descriptive flexfield segments.
174 * @param p_attribute1 Descriptive flexfield segment.
175 * @param p_attribute2 Descriptive flexfield segment.
176 * @param p_attribute3 Descriptive flexfield segment.
177 * @param p_attribute4 Descriptive flexfield segment.
178 * @param p_attribute5 Descriptive flexfield segment.
179 * @param p_attribute6 Descriptive flexfield segment.
180 * @param p_attribute7 Descriptive flexfield segment.
181 * @param p_attribute8 Descriptive flexfield segment.
182 * @param p_attribute9 Descriptive flexfield segment.
183 * @param p_attribute10 Descriptive flexfield segment.
184 * @param p_attribute11 Descriptive flexfield segment.
185 * @param p_attribute12 Descriptive flexfield segment.
186 * @param p_attribute13 Descriptive flexfield segment.
187 * @param p_attribute14 Descriptive flexfield segment.
188 * @param p_attribute15 Descriptive flexfield segment.
189 * @param p_attribute16 Descriptive flexfield segment.
190 * @param p_attribute17 Descriptive flexfield segment.
191 * @param p_attribute18 Descriptive flexfield segment.
192 * @param p_attribute19 Descriptive flexfield segment.
193 * @param p_attribute20 Descriptive flexfield segment.
194 * @param p_attribute21 Descriptive flexfield segment.
195 * @param p_attribute22 Descriptive flexfield segment.
196 * @param p_attribute23 Descriptive flexfield segment.
197 * @param p_attribute24 Descriptive flexfield segment.
198 * @param p_attribute25 Descriptive flexfield segment.
199 * @param p_attribute26 Descriptive flexfield segment.
200 * @param p_attribute27 Descriptive flexfield segment.
201 * @param p_attribute28 Descriptive flexfield segment.
202 * @param p_attribute29 Descriptive flexfield segment.
203 * @param p_attribute30 Descriptive flexfield segment.
204 * @param p_object_version_number Pass in the current version number of the
205 * association to be updated. When the API completes if p_validate is false,
206 * will be set to the new version number of the updated association. If
207 * p_validate is true will be set to the same value which was passed in.
208 * @rep:displayname Update Agency Vacancy
209 * @rep:category BUSINESS_ENTITY IRC_AGENCY
210 * @rep:lifecycle active
211 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
212 * @rep:scope public
213 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
214 */
215 --
216 -- {End Of Comments}
217 --
218 procedure update_agency_vacancy
219 (p_validate in boolean default false
220 ,p_agency_vacancy_id in number
221 ,p_agency_id in number
222 ,p_vacancy_id in number
223 ,p_start_date in date
224 ,p_end_date in date
225 ,p_max_allowed_applicants in number default hr_api.g_number
226 ,p_manage_applicants_allowed in varchar2 default 'N'
227 ,p_attribute_category in varchar2 default hr_api.g_varchar2
228 ,p_attribute1 in varchar2 default hr_api.g_varchar2
229 ,p_attribute2 in varchar2 default hr_api.g_varchar2
230 ,p_attribute3 in varchar2 default hr_api.g_varchar2
231 ,p_attribute4 in varchar2 default hr_api.g_varchar2
232 ,p_attribute5 in varchar2 default hr_api.g_varchar2
233 ,p_attribute6 in varchar2 default hr_api.g_varchar2
234 ,p_attribute7 in varchar2 default hr_api.g_varchar2
235 ,p_attribute8 in varchar2 default hr_api.g_varchar2
236 ,p_attribute9 in varchar2 default hr_api.g_varchar2
237 ,p_attribute10 in varchar2 default hr_api.g_varchar2
238 ,p_attribute11 in varchar2 default hr_api.g_varchar2
239 ,p_attribute12 in varchar2 default hr_api.g_varchar2
240 ,p_attribute13 in varchar2 default hr_api.g_varchar2
241 ,p_attribute14 in varchar2 default hr_api.g_varchar2
242 ,p_attribute15 in varchar2 default hr_api.g_varchar2
243 ,p_attribute16 in varchar2 default hr_api.g_varchar2
244 ,p_attribute17 in varchar2 default hr_api.g_varchar2
245 ,p_attribute18 in varchar2 default hr_api.g_varchar2
246 ,p_attribute19 in varchar2 default hr_api.g_varchar2
247 ,p_attribute20 in varchar2 default hr_api.g_varchar2
248 ,p_attribute21 in varchar2 default hr_api.g_varchar2
249 ,p_attribute22 in varchar2 default hr_api.g_varchar2
250 ,p_attribute23 in varchar2 default hr_api.g_varchar2
251 ,p_attribute24 in varchar2 default hr_api.g_varchar2
252 ,p_attribute25 in varchar2 default hr_api.g_varchar2
253 ,p_attribute26 in varchar2 default hr_api.g_varchar2
254 ,p_attribute27 in varchar2 default hr_api.g_varchar2
255 ,p_attribute28 in varchar2 default hr_api.g_varchar2
256 ,p_attribute29 in varchar2 default hr_api.g_varchar2
257 ,p_attribute30 in varchar2 default hr_api.g_varchar2
258 ,p_object_version_number in out nocopy number
259 );
260 --
261 -- ----------------------------------------------------------------------------
262 -- |--------------------------< delete_agency_vacancy >-----------------------|
263 -- ----------------------------------------------------------------------------
264 --
265 -- {Start Of Comments}
266 /*#
267 *
271 * This API is licensed for use with iRecruitment.
268 * This API removes the association of an agency with a vacancy.
269 *
270 * <p><b>Licensing</b><br>
272 *
273 * <p><b>Prerequisites</b><br>
274 * The association must exist.
275 *
276 * <p><b>Post Success</b><br>
277 * The association will be removed.
278 *
279 * <p><b>Post Failure</b><br>
280 * The association will not be removed and an error will be raised.
281 *
282 * @param p_validate If true, then validation alone will be performed and the
283 * database will remain unchanged. If false and all validation checks pass,
284 * then the database will be modified.
285 * @param p_agency_vacancy_id Identifies the association of the agency and
286 * vacancy to be updated.
287 * @param p_object_version_number Current version number of the association to
288 * be deleted
289 * @rep:displayname Delete Agency Vacancy
290 * @rep:category BUSINESS_ENTITY IRC_AGENCY
291 * @rep:lifecycle active
292 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
293 * @rep:scope public
294 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
295 */
296 --
297 -- {End Of Comments}
298 --
299 procedure delete_agency_vacancy
300 (p_validate in boolean default false
301 ,p_agency_vacancy_id in number
302 ,p_object_version_number in number
303 );
304 end IRC_AGENCY_VACANCIES_API;