1 Package IRC_RECRUITING_SITES_API as
2 /* $Header: irrseapi.pkh 120.2 2008/02/21 14:36:20 viviswan noship $ */
3 /*#
4 * This package contains APIs for recruiting sites.
5 * @rep:scope public
6 * @rep:product irc
7 * @rep:displayname Recruiting Site
8 */
9 --
10 -- ----------------------------------------------------------------------------
11 -- |--------------------------< create_recruiting_site >----------------------|
12 -- ----------------------------------------------------------------------------
13 --
14 -- {Start Of Comments}
15 /*#
16 * This API creates a recruiting site.
17 *
18 * A recruiting site has information necessary to post adverts to third
19 * parties.
20 *
21 * <p><b>Licensing</b><br>
22 * This API is licensed for use with iRecruitment.
23 *
24 * <p><b>Prerequisites</b><br>
25 * No known prerequisites.
26 *
27 * <p><b>Post Success</b><br>
28 * The recruiting site will be created in the database
29 *
30 * <p><b>Post Failure</b><br>
31 * The recruiting site will not be created in the database and an error will be
32 * raised
33 * @param p_validate If true, then validation alone will be performed and the
34 * database will remain unchanged. If false and all validation checks pass,
35 * then the database will be modified.
36 * @param p_language_code Specifies to which language the translation values
37 * apply. You can set to the base or any installed language. The default value
38 * of hr_api.userenv_lang is equivalent to the RDBMS userenv('LANG') function
39 * value.
40 * @param p_effective_date Reference date for validating lookup values are
41 * applicable during the start to end active date range. This date does not
42 * determine when the changes take effect.
43 * @param p_site_name The name of the recruiting site
44 * @param p_date_from The date from which the recruiting site can be used
45 * @param p_date_to The last date on which the recruiting site can be used
46 * @param p_posting_username The username for posting adverts to the third
47 * party recruiting site
48 * @param p_posting_password The password for posting adverts to the third
49 * party recruiting site
50 * @param p_internal Indicates that the recruiting site is for posting internal
51 * vacancies (Y or N)
52 * @param p_external Indicates that the recruiting site is for posting external
53 * vacancies (Y or N)
54 * @param p_third_party Indicates that the recruiting site is a third party
55 * recruiting site (Y or N)
56 * @param p_redirection_url Reserved for future use
57 * @param p_posting_url The URL for posting adverts to the third party
58 * recruiting site
59 * @param p_posting_cost The cost of posting to the third party recruiting site
60 * @param p_posting_cost_period The period that the cost of posting covers.
61 * Valid values are defined by 'IRC_POSTING_COST_FREQ' lookup type.
62 * @param p_posting_cost_currency The currency that the cost of posting is in
63 * @param p_stylesheet The optional XML stylesheet for conversion of the data
64 * format for posting to the third party recruiting site
65 * @param p_attribute_category This context value determines which flexfield
66 * structure to use with the descriptive flexfield segments.
67 * @param p_attribute1 Descriptive flexfield segment.
68 * @param p_attribute2 Descriptive flexfield segment.
69 * @param p_attribute3 Descriptive flexfield segment.
70 * @param p_attribute4 Descriptive flexfield segment.
71 * @param p_attribute5 Descriptive flexfield segment.
72 * @param p_attribute6 Descriptive flexfield segment.
73 * @param p_attribute7 Descriptive flexfield segment.
74 * @param p_attribute8 Descriptive flexfield segment.
75 * @param p_attribute9 Descriptive flexfield segment.
76 * @param p_attribute10 Descriptive flexfield segment.
77 * @param p_attribute11 Descriptive flexfield segment.
78 * @param p_attribute12 Descriptive flexfield segment.
79 * @param p_attribute13 Descriptive flexfield segment.
80 * @param p_attribute14 Descriptive flexfield segment.
81 * @param p_attribute15 Descriptive flexfield segment.
82 * @param p_attribute16 Descriptive flexfield segment.
83 * @param p_attribute17 Descriptive flexfield segment.
84 * @param p_attribute18 Descriptive flexfield segment.
85 * @param p_attribute19 Descriptive flexfield segment.
86 * @param p_attribute20 Descriptive flexfield segment.
87 * @param p_attribute21 Descriptive flexfield segment.
88 * @param p_attribute22 Descriptive flexfield segment.
89 * @param p_attribute23 Descriptive flexfield segment.
90 * @param p_attribute24 Descriptive flexfield segment.
91 * @param p_attribute25 Descriptive flexfield segment.
92 * @param p_attribute26 Descriptive flexfield segment.
93 * @param p_attribute27 Descriptive flexfield segment.
94 * @param p_attribute28 Descriptive flexfield segment.
95 * @param p_attribute29 Descriptive flexfield segment.
96 * @param p_attribute30 Descriptive flexfield segment.
97 * @param p_recruiting_site_id If p_validate is false, then this uniquely
98 * identifies the recruiting site created. If p_validate is true, then set to
99 * null.
100 * @param p_object_version_number If p_validate is false, then set to the
101 * version number of the created recruiting site. If p_validate is true, then
102 * the value will be null.
103 * @rep:displayname Create Recruiting Site
104 * @rep:category BUSINESS_ENTITY IRC_RECRUITING_SITE
105 * @rep:category BUSINESS_ENTITY IRC_RECRUITING_3RD_PARTY_SITE
106 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
107 * @rep:scope public
108 * @rep:lifecycle active
109 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
110 */
111 --
112 -- {End Of Comments}
113 --
114 procedure CREATE_RECRUITING_SITE
115 (p_validate in boolean default false
116 ,p_language_code in varchar2 default hr_api.userenv_lang
117 ,p_effective_date in date
118 ,p_site_name in varchar2
119 ,p_date_from in date default null
120 ,p_date_to in date default null
121 ,p_posting_username in varchar2 default null
122 ,p_posting_password in varchar2 default null
123 ,p_internal in varchar2 default 'N'
124 ,p_external in varchar2 default 'N'
125 ,p_third_party in varchar2 default 'Y'
126 ,p_redirection_url in varchar2 default null
127 ,p_posting_url in varchar2 default null
128 ,p_posting_cost in number default null
129 ,p_posting_cost_period in varchar2 default null
130 ,p_posting_cost_currency in varchar2 default null
131 ,p_stylesheet in varchar2 default null
132 ,p_attribute_category in varchar2 default null
133 ,p_attribute1 in varchar2 default null
134 ,p_attribute2 in varchar2 default null
135 ,p_attribute3 in varchar2 default null
136 ,p_attribute4 in varchar2 default null
137 ,p_attribute5 in varchar2 default null
138 ,p_attribute6 in varchar2 default null
139 ,p_attribute7 in varchar2 default null
140 ,p_attribute8 in varchar2 default null
141 ,p_attribute9 in varchar2 default null
142 ,p_attribute10 in varchar2 default null
143 ,p_attribute11 in varchar2 default null
144 ,p_attribute12 in varchar2 default null
145 ,p_attribute13 in varchar2 default null
146 ,p_attribute14 in varchar2 default null
147 ,p_attribute15 in varchar2 default null
148 ,p_attribute16 in varchar2 default null
149 ,p_attribute17 in varchar2 default null
150 ,p_attribute18 in varchar2 default null
151 ,p_attribute19 in varchar2 default null
152 ,p_attribute20 in varchar2 default null
153 ,p_attribute21 in varchar2 default null
154 ,p_attribute22 in varchar2 default null
155 ,p_attribute23 in varchar2 default null
156 ,p_attribute24 in varchar2 default null
157 ,p_attribute25 in varchar2 default null
158 ,p_attribute26 in varchar2 default null
159 ,p_attribute27 in varchar2 default null
160 ,p_attribute28 in varchar2 default null
161 ,p_attribute29 in varchar2 default null
162 ,p_attribute30 in varchar2 default null
163 ,p_recruiting_site_id out nocopy number
164 ,p_object_version_number out nocopy number
165 );
166 --
167 -- ----------------------------------------------------------------------------
168 -- |--------------------------< update_recruiting_site >----------------------|
169 -- ----------------------------------------------------------------------------
170 --
171 -- {Start Of Comments}
172 /*#
173 * This API updates a recruiting site.
174 *
175 * A recruiting site has information necessary to post adverts to third
176 * parties.
177 *
178 * <p><b>Licensing</b><br>
179 * This API is licensed for use with iRecruitment.
180 *
181 * <p><b>Prerequisites</b><br>
182 * The recruiting site must already exist
183 *
184 * <p><b>Post Success</b><br>
185 * The recruiting site will be updated in the database
186 *
187 * <p><b>Post Failure</b><br>
188 * The recruiting site will not be updated in the database and an error will be
189 * raised
190 * @param p_recruiting_site_id Identifies the recruiting site
191 * @param p_validate If true, then validation alone will be performed and the
192 * database will remain unchanged. If false and all validation checks pass,
193 * then the database will be modified.
194 * @param p_language_code Specifies to which language the translation values
195 * apply. You can set to the base or any installed language. The default value
196 * of hr_api.userenv_lang is equivalent to the RDBMS userenv('LANG') function
197 * value.
198 * @param p_effective_date Reference date for validating lookup values are
199 * applicable during the start to end active date range. This date does not
200 * determine when the changes take effect.
201 * @param p_site_name The name of the recruiting site
202 * @param p_date_from The date from which the recruiting site can be used
203 * @param p_date_to The last date on which the recruiting site can be used
204 * @param p_posting_username The username for posting adverts to the third
205 * party recruiting site
206 * @param p_posting_password The password for posting adverts to the third
207 * party recruiting site
208 * @param p_internal Indicates that the recruiting site is for posting internal
209 * vacancies (Y or N)
210 * @param p_external Indicates that the recruiting site is for posting external
211 * vacancies (Y or N)
212 * @param p_third_party Indicates that the recruiting site is a third party
213 * recruiting site (Y or N)
214 * @param p_redirection_url Reserved for future use
215 * @param p_posting_url The URL for posting adverts to the third party
216 * recruiting site
217 * @param p_posting_cost The cost of posting to the third party recruiting site
218 * @param p_posting_cost_period The period that the cost of posting covers.
219 * Valid values are defined by 'IRC_POSTING_COST_FREQ' lookup type.
220 * @param p_posting_cost_currency The currency that the cost of posting is in
221 * @param p_stylesheet The optional XML stylesheet for conversion of the data
222 * format for posting to the third party recruiting site
223 * @param p_attribute_category This context value determines which flexfield
224 * structure to use with the descriptive flexfield segments.
225 * @param p_attribute1 Descriptive flexfield segment.
226 * @param p_attribute2 Descriptive flexfield segment.
227 * @param p_attribute3 Descriptive flexfield segment.
228 * @param p_attribute4 Descriptive flexfield segment.
229 * @param p_attribute5 Descriptive flexfield segment.
230 * @param p_attribute6 Descriptive flexfield segment.
231 * @param p_attribute7 Descriptive flexfield segment.
232 * @param p_attribute8 Descriptive flexfield segment.
233 * @param p_attribute9 Descriptive flexfield segment.
234 * @param p_attribute10 Descriptive flexfield segment.
235 * @param p_attribute11 Descriptive flexfield segment.
236 * @param p_attribute12 Descriptive flexfield segment.
237 * @param p_attribute13 Descriptive flexfield segment.
238 * @param p_attribute14 Descriptive flexfield segment.
239 * @param p_attribute15 Descriptive flexfield segment.
240 * @param p_attribute16 Descriptive flexfield segment.
241 * @param p_attribute17 Descriptive flexfield segment.
242 * @param p_attribute18 Descriptive flexfield segment.
243 * @param p_attribute19 Descriptive flexfield segment.
244 * @param p_attribute20 Descriptive flexfield segment.
245 * @param p_attribute21 Descriptive flexfield segment.
246 * @param p_attribute22 Descriptive flexfield segment.
247 * @param p_attribute23 Descriptive flexfield segment.
248 * @param p_attribute24 Descriptive flexfield segment.
249 * @param p_attribute25 Descriptive flexfield segment.
250 * @param p_attribute26 Descriptive flexfield segment.
251 * @param p_attribute27 Descriptive flexfield segment.
252 * @param p_attribute28 Descriptive flexfield segment.
253 * @param p_attribute29 Descriptive flexfield segment.
254 * @param p_attribute30 Descriptive flexfield segment.
255 * @param p_object_version_number Pass in the current version number of the
256 * recruiting site to be updated. When the API completes if p_validate is
257 * false, will be set to the new version number of the updated recruiting site.
258 * If p_validate is true will be set to the same value which was passed in.
259 * @rep:displayname Update Recruiting Site
260 * @rep:category BUSINESS_ENTITY IRC_RECRUITING_SITE
261 * @rep:category BUSINESS_ENTITY IRC_RECRUITING_3RD_PARTY_SITE
262 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
263 * @rep:scope public
264 * @rep:lifecycle active
265 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
266 */
267 --
268 -- {End Of Comments}
269 --
270 procedure UPDATE_RECRUITING_SITE
271 (p_recruiting_site_id in number
272 ,p_validate in boolean default false
273 ,p_language_code in varchar2 default hr_api.userenv_lang
274 ,p_effective_date in date
275 ,p_site_name in varchar2 default hr_api.g_varchar2
276 ,p_date_from in date default hr_api.g_date
277 ,p_date_to in date default hr_api.g_date
278 ,p_posting_username in varchar2 default hr_api.g_varchar2
279 ,p_posting_password in varchar2 default hr_api.g_varchar2
280 ,p_internal in varchar2 default hr_api.g_varchar2
281 ,p_external in varchar2 default hr_api.g_varchar2
282 ,p_third_party in varchar2 default hr_api.g_varchar2
283 ,p_redirection_url in varchar2 default hr_api.g_varchar2
284 ,p_posting_url in varchar2 default hr_api.g_varchar2
285 ,p_posting_cost in number default hr_api.g_number
286 ,p_posting_cost_period in varchar2 default hr_api.g_varchar2
287 ,p_posting_cost_currency in varchar2 default hr_api.g_varchar2
288 ,p_stylesheet in varchar2 default hr_api.g_varchar2
289 ,p_attribute_category in varchar2 default hr_api.g_varchar2
290 ,p_attribute1 in varchar2 default hr_api.g_varchar2
291 ,p_attribute2 in varchar2 default hr_api.g_varchar2
292 ,p_attribute3 in varchar2 default hr_api.g_varchar2
293 ,p_attribute4 in varchar2 default hr_api.g_varchar2
297 ,p_attribute8 in varchar2 default hr_api.g_varchar2
294 ,p_attribute5 in varchar2 default hr_api.g_varchar2
295 ,p_attribute6 in varchar2 default hr_api.g_varchar2
296 ,p_attribute7 in varchar2 default hr_api.g_varchar2
298 ,p_attribute9 in varchar2 default hr_api.g_varchar2
299 ,p_attribute10 in varchar2 default hr_api.g_varchar2
300 ,p_attribute11 in varchar2 default hr_api.g_varchar2
301 ,p_attribute12 in varchar2 default hr_api.g_varchar2
302 ,p_attribute13 in varchar2 default hr_api.g_varchar2
303 ,p_attribute14 in varchar2 default hr_api.g_varchar2
304 ,p_attribute15 in varchar2 default hr_api.g_varchar2
305 ,p_attribute16 in varchar2 default hr_api.g_varchar2
306 ,p_attribute17 in varchar2 default hr_api.g_varchar2
307 ,p_attribute18 in varchar2 default hr_api.g_varchar2
308 ,p_attribute19 in varchar2 default hr_api.g_varchar2
309 ,p_attribute20 in varchar2 default hr_api.g_varchar2
310 ,p_attribute21 in varchar2 default hr_api.g_varchar2
311 ,p_attribute22 in varchar2 default hr_api.g_varchar2
312 ,p_attribute23 in varchar2 default hr_api.g_varchar2
313 ,p_attribute24 in varchar2 default hr_api.g_varchar2
314 ,p_attribute25 in varchar2 default hr_api.g_varchar2
315 ,p_attribute26 in varchar2 default hr_api.g_varchar2
316 ,p_attribute27 in varchar2 default hr_api.g_varchar2
317 ,p_attribute28 in varchar2 default hr_api.g_varchar2
318 ,p_attribute29 in varchar2 default hr_api.g_varchar2
319 ,p_attribute30 in varchar2 default hr_api.g_varchar2
320 ,p_object_version_number in out nocopy number
321 );
322 --
323 -- ----------------------------------------------------------------------------
324 -- |--------------------------< delete_recruiting_site >----------------------|
325 -- ----------------------------------------------------------------------------
326 --
327 -- {Start Of Comments}
328 /*#
329 * This API will delete a recruiting site.
330 *
331 *
332 * <p><b>Licensing</b><br>
333 * This API is licensed for use with iRecruitment.
334 *
335 * <p><b>Prerequisites</b><br>
336 * The recruiting site must already exist
337 *
338 * <p><b>Post Success</b><br>
339 * The recruiting site will be deleted from the database
340 *
341 * <p><b>Post Failure</b><br>
342 * The recruiting site will not be deleted from the database and an error will
343 * be raised
344 * @param p_validate If true, then validation alone will be performed and the
345 * database will remain unchanged. If false and all validation checks pass,
346 * then the database will be modified.
347 * @param p_recruiting_site_id Identifies the recruiting site
348 * @param p_object_version_number Current version number of the recruiting site
349 * to be deleted.
350 * @rep:displayname Delete Recruiting Site
351 * @rep:category BUSINESS_ENTITY IRC_RECRUITING_SITE
352 * @rep:category BUSINESS_ENTITY IRC_RECRUITING_3RD_PARTY_SITE
353 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
354 * @rep:scope public
355 * @rep:lifecycle active
356 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
357 */
358 --
359 -- {End Of Comments}
360 --
361 procedure DELETE_RECRUITING_SITE
362 (p_validate in boolean default false
363 ,p_recruiting_site_id in number
364 ,p_object_version_number in number
365 );
366 --
367 end IRC_RECRUITING_SITES_API;