1 Package irc_default_posting_api AUTHID CURRENT_USER as
2 /* $Header: iridpapi.pkh 120.2 2008/02/21 14:12:57 viviswan noship $ */
3 /*#
4 * This package contains Default Posting APIs.
5 * @rep:scope public
6 * @rep:product irc
7 * @rep:displayname Default Posting
8 */
9 --
10 -- ----------------------------------------------------------------------------
11 -- |--------------------------< create_default_posting >----------------------|
12 -- ----------------------------------------------------------------------------
13 --
14 -- {Start Of Comments}
15 /*#
16 * This API creates a Default Posting.
17 *
18 * Default postings will be used to populate job postings when a vacancy is
19 * created.
20 *
21 * <p><b>Licensing</b><br>
22 * This API is licensed for use with iRecruitment.
23 *
24 * <p><b>Prerequisites</b><br>
25 * The position, job or organization must already exist
26 *
27 * <p><b>Post Success</b><br>
28 * The default posting will be created in the database
29 *
30 * <p><b>Post Failure</b><br>
31 * The default posting 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_position_id The position which the default posting is for
41 * @param p_job_id The job which the default posting is for
42 * @param p_organization_id The organization which the default posting is for
43 * @param p_org_name The default advertised organization name
44 * @param p_org_description The default advertised organization description
45 * @param p_job_title The default advertised job title
46 * @param p_brief_description The default advertised brief description
47 * @param p_detailed_description The default advertised detailed description
48 * @param p_job_requirements The default advertised job requirements
49 * @param p_additional_details The default advertised additional details
50 * @param p_how_to_apply The default apply instructions
51 * @param p_image_url The default URL for an image to accompany the advert
52 * @param p_image_url_alt The default alternative text for an image to
53 * accompany the advert
54 * @param p_attribute_category This context value determines which flexfield
55 * structure to use with the descriptive flexfield segments.
56 * @param p_attribute1 Descriptive flexfield segment.
57 * @param p_attribute2 Descriptive flexfield segment.
58 * @param p_attribute3 Descriptive flexfield segment.
59 * @param p_attribute4 Descriptive flexfield segment.
60 * @param p_attribute5 Descriptive flexfield segment.
61 * @param p_attribute6 Descriptive flexfield segment.
62 * @param p_attribute7 Descriptive flexfield segment.
63 * @param p_attribute8 Descriptive flexfield segment.
64 * @param p_attribute9 Descriptive flexfield segment.
65 * @param p_attribute10 Descriptive flexfield segment.
66 * @param p_attribute11 Descriptive flexfield segment.
67 * @param p_attribute12 Descriptive flexfield segment.
68 * @param p_attribute13 Descriptive flexfield segment.
69 * @param p_attribute14 Descriptive flexfield segment.
70 * @param p_attribute15 Descriptive flexfield segment.
71 * @param p_attribute16 Descriptive flexfield segment.
72 * @param p_attribute17 Descriptive flexfield segment.
73 * @param p_attribute18 Descriptive flexfield segment.
74 * @param p_attribute19 Descriptive flexfield segment.
75 * @param p_attribute20 Descriptive flexfield segment.
76 * @param p_attribute21 Descriptive flexfield segment.
77 * @param p_attribute22 Descriptive flexfield segment.
78 * @param p_attribute23 Descriptive flexfield segment.
79 * @param p_attribute24 Descriptive flexfield segment.
80 * @param p_attribute25 Descriptive flexfield segment.
81 * @param p_attribute26 Descriptive flexfield segment.
82 * @param p_attribute27 Descriptive flexfield segment.
83 * @param p_attribute28 Descriptive flexfield segment.
84 * @param p_attribute29 Descriptive flexfield segment.
88 * null.
85 * @param p_attribute30 Descriptive flexfield segment.
86 * @param p_default_posting_id If p_validate is false, then this uniquely
87 * identifies the default posting created. If p_validate is true, then set to
89 * @param p_object_version_number If p_validate is false, then set to the
90 * version number of the created default posting. If p_validate is true, then
91 * the value will be null.
92 * @rep:displayname Create Default Posting
93 * @rep:category BUSINESS_ENTITY IRC_DEFAULT_JOB_POSTING
94 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
95 * @rep:scope public
96 * @rep:lifecycle active
97 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
98 */
99 --
100 -- {End Of Comments}
101 --
102 procedure create_default_posting
103 (P_VALIDATE IN BOOLEAN default FALSE
104 ,P_LANGUAGE_CODE IN VARCHAR2 default hr_api.userenv_lang
105 ,P_POSITION_ID IN NUMBER default NULL
106 ,P_JOB_ID IN NUMBER default NULL
107 ,P_ORGANIZATION_ID IN NUMBER default NULL
108 ,P_ORG_NAME IN VARCHAR2 default NULL
109 ,P_ORG_DESCRIPTION IN VARCHAR2 default NULL
110 ,P_JOB_TITLE IN VARCHAR2 default NULL
111 ,P_BRIEF_DESCRIPTION IN VARCHAR2 default NULL
112 ,P_DETAILED_DESCRIPTION IN VARCHAR2 default NULL
113 ,P_JOB_REQUIREMENTS IN VARCHAR2 default NULL
114 ,P_ADDITIONAL_DETAILS IN VARCHAR2 default NULL
115 ,P_HOW_TO_APPLY IN VARCHAR2 default NULL
116 ,P_IMAGE_URL IN VARCHAR2 default NULL
117 ,P_IMAGE_URL_ALT IN VARCHAR2 default NULL
118 ,P_ATTRIBUTE_CATEGORY IN VARCHAR2 default NULL
119 ,P_ATTRIBUTE1 IN VARCHAR2 default NULL
120 ,P_ATTRIBUTE2 IN VARCHAR2 default NULL
121 ,P_ATTRIBUTE3 IN VARCHAR2 default NULL
122 ,P_ATTRIBUTE4 IN VARCHAR2 default NULL
123 ,P_ATTRIBUTE5 IN VARCHAR2 default NULL
124 ,P_ATTRIBUTE6 IN VARCHAR2 default NULL
125 ,P_ATTRIBUTE7 IN VARCHAR2 default NULL
126 ,P_ATTRIBUTE8 IN VARCHAR2 default NULL
127 ,P_ATTRIBUTE9 IN VARCHAR2 default NULL
128 ,P_ATTRIBUTE10 IN VARCHAR2 default NULL
129 ,P_ATTRIBUTE11 IN VARCHAR2 default NULL
130 ,P_ATTRIBUTE12 IN VARCHAR2 default NULL
131 ,P_ATTRIBUTE13 IN VARCHAR2 default NULL
132 ,P_ATTRIBUTE14 IN VARCHAR2 default NULL
133 ,P_ATTRIBUTE15 IN VARCHAR2 default NULL
134 ,P_ATTRIBUTE16 IN VARCHAR2 default NULL
135 ,P_ATTRIBUTE17 IN VARCHAR2 default NULL
136 ,P_ATTRIBUTE18 IN VARCHAR2 default NULL
137 ,P_ATTRIBUTE19 IN VARCHAR2 default NULL
138 ,P_ATTRIBUTE20 IN VARCHAR2 default NULL
139 ,P_ATTRIBUTE21 IN VARCHAR2 default NULL
140 ,P_ATTRIBUTE22 IN VARCHAR2 default NULL
141 ,P_ATTRIBUTE23 IN VARCHAR2 default NULL
142 ,P_ATTRIBUTE24 IN VARCHAR2 default NULL
143 ,P_ATTRIBUTE25 IN VARCHAR2 default NULL
144 ,P_ATTRIBUTE26 IN VARCHAR2 default NULL
145 ,P_ATTRIBUTE27 IN VARCHAR2 default NULL
146 ,P_ATTRIBUTE28 IN VARCHAR2 default NULL
147 ,P_ATTRIBUTE29 IN VARCHAR2 default NULL
148 ,P_ATTRIBUTE30 IN VARCHAR2 default NULL
149 ,P_DEFAULT_POSTING_ID OUT NOCOPY NUMBER
150 ,P_OBJECT_VERSION_NUMBER OUT NOCOPY NUMBER
151 );
152 --
153 -- ----------------------------------------------------------------------------
154 -- |--------------------------< update_default_posting >----------------------|
155 -- ----------------------------------------------------------------------------
156 --
157 -- {Start Of Comments}
158 /*#
159 * This API updates a Default Posting.
160 *
161 * Default postings will be used to populate job postings when a vacancy is
162 * created.
163 *
164 * <p><b>Licensing</b><br>
165 * This API is licensed for use with iRecruitment.
166 *
167 * <p><b>Prerequisites</b><br>
168 * The default posting must exist in the database
169 *
170 * <p><b>Post Success</b><br>
171 * The default posting will be updated in the database
172 *
173 * <p><b>Post Failure</b><br>
174 * The default posting will not be updated in the database and an error will be
175 * raised
176 * @param p_validate If true, then validation alone will be performed and the
177 * database will remain unchanged. If false and all validation checks pass,
178 * then the database will be modified.
179 * @param p_language_code Specifies to which language the translation values
180 * apply. You can set to the base or any installed language. The default value
181 * of hr_api.userenv_lang is equivalent to the RDBMS userenv('LANG') function
182 * value.
183 * @param p_default_posting_id Identifies the default posting to be modified
184 * @param p_position_id The position which the default posting is for
185 * @param p_job_id The job which the default posting is for
186 * @param p_organization_id The organization which the default posting is for
187 * @param p_org_name The default advertised organization name
188 * @param p_org_description The default advertised organization description
189 * @param p_job_title The default advertised job title
190 * @param p_brief_description The default advertised brief description
191 * @param p_detailed_description The default advertised detailed description
192 * @param p_job_requirements The default advertised job requirements
193 * @param p_additional_details The default advertised additional details
194 * @param p_how_to_apply The default apply instructions
195 * @param p_image_url The default URL for an image to accompany the advert
196 * @param p_image_url_alt The default alternative text for an image to
197 * accompany the advert
198 * @param p_attribute_category This context value determines which flexfield
199 * structure to use with the descriptive flexfield segments.
200 * @param p_attribute1 Descriptive flexfield segment.
201 * @param p_attribute2 Descriptive flexfield segment.
202 * @param p_attribute3 Descriptive flexfield segment.
203 * @param p_attribute4 Descriptive flexfield segment.
204 * @param p_attribute5 Descriptive flexfield segment.
205 * @param p_attribute6 Descriptive flexfield segment.
206 * @param p_attribute7 Descriptive flexfield segment.
207 * @param p_attribute8 Descriptive flexfield segment.
208 * @param p_attribute9 Descriptive flexfield segment.
209 * @param p_attribute10 Descriptive flexfield segment.
210 * @param p_attribute11 Descriptive flexfield segment.
211 * @param p_attribute12 Descriptive flexfield segment.
212 * @param p_attribute13 Descriptive flexfield segment.
213 * @param p_attribute14 Descriptive flexfield segment.
214 * @param p_attribute15 Descriptive flexfield segment.
215 * @param p_attribute16 Descriptive flexfield segment.
216 * @param p_attribute17 Descriptive flexfield segment.
217 * @param p_attribute18 Descriptive flexfield segment.
218 * @param p_attribute19 Descriptive flexfield segment.
219 * @param p_attribute20 Descriptive flexfield segment.
220 * @param p_attribute21 Descriptive flexfield segment.
221 * @param p_attribute22 Descriptive flexfield segment.
222 * @param p_attribute23 Descriptive flexfield segment.
223 * @param p_attribute24 Descriptive flexfield segment.
224 * @param p_attribute25 Descriptive flexfield segment.
225 * @param p_attribute26 Descriptive flexfield segment.
226 * @param p_attribute27 Descriptive flexfield segment.
227 * @param p_attribute28 Descriptive flexfield segment.
228 * @param p_attribute29 Descriptive flexfield segment.
229 * @param p_attribute30 Descriptive flexfield segment.
230 * @param p_object_version_number Pass in the current version number of the
231 * default posting to be updated. When the API completes if p_validate is
232 * false, will be set to the new version number of the updated default posting.
233 * If p_validate is true will be set to the same value which was passed in.
234 * @rep:displayname Update Default Posting
235 * @rep:category BUSINESS_ENTITY IRC_DEFAULT_JOB_POSTING
236 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
237 * @rep:scope public
238 * @rep:lifecycle active
239 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
240 */
241 --
242 -- {End Of Comments}
243 --
244 procedure update_default_posting
245 (P_VALIDATE IN BOOLEAN default FALSE
246 ,P_LANGUAGE_CODE IN VARCHAR2 default hr_api.userenv_lang
247 ,P_DEFAULT_POSTING_ID IN NUMBER
248 ,P_POSITION_ID IN NUMBER default hr_api.g_number
249 ,P_JOB_ID IN NUMBER default hr_api.g_number
250 ,P_ORGANIZATION_ID IN NUMBER default hr_api.g_number
251 ,P_ORG_NAME IN VARCHAR2 default hr_api.g_varchar2
252 ,P_ORG_DESCRIPTION IN VARCHAR2 default hr_api.g_varchar2
253 ,P_JOB_TITLE IN VARCHAR2 default hr_api.g_varchar2
254 ,P_BRIEF_DESCRIPTION IN VARCHAR2 default hr_api.g_varchar2
255 ,P_DETAILED_DESCRIPTION IN VARCHAR2 default hr_api.g_varchar2
256 ,P_JOB_REQUIREMENTS IN VARCHAR2 default hr_api.g_varchar2
257 ,P_ADDITIONAL_DETAILS IN VARCHAR2 default hr_api.g_varchar2
258 ,P_HOW_TO_APPLY IN VARCHAR2 default hr_api.g_varchar2
259 ,P_IMAGE_URL IN VARCHAR2 default hr_api.g_varchar2
260 ,P_IMAGE_URL_ALT IN VARCHAR2 default hr_api.g_varchar2
261 ,P_ATTRIBUTE_CATEGORY IN VARCHAR2 default hr_api.g_varchar2
262 ,P_ATTRIBUTE1 IN VARCHAR2 default hr_api.g_varchar2
263 ,P_ATTRIBUTE2 IN VARCHAR2 default hr_api.g_varchar2
264 ,P_ATTRIBUTE3 IN VARCHAR2 default hr_api.g_varchar2
265 ,P_ATTRIBUTE4 IN VARCHAR2 default hr_api.g_varchar2
266 ,P_ATTRIBUTE5 IN VARCHAR2 default hr_api.g_varchar2
267 ,P_ATTRIBUTE6 IN VARCHAR2 default hr_api.g_varchar2
268 ,P_ATTRIBUTE7 IN VARCHAR2 default hr_api.g_varchar2
269 ,P_ATTRIBUTE8 IN VARCHAR2 default hr_api.g_varchar2
270 ,P_ATTRIBUTE9 IN VARCHAR2 default hr_api.g_varchar2
271 ,P_ATTRIBUTE10 IN VARCHAR2 default hr_api.g_varchar2
272 ,P_ATTRIBUTE11 IN VARCHAR2 default hr_api.g_varchar2
273 ,P_ATTRIBUTE12 IN VARCHAR2 default hr_api.g_varchar2
274 ,P_ATTRIBUTE13 IN VARCHAR2 default hr_api.g_varchar2
275 ,P_ATTRIBUTE14 IN VARCHAR2 default hr_api.g_varchar2
276 ,P_ATTRIBUTE15 IN VARCHAR2 default hr_api.g_varchar2
277 ,P_ATTRIBUTE16 IN VARCHAR2 default hr_api.g_varchar2
278 ,P_ATTRIBUTE17 IN VARCHAR2 default hr_api.g_varchar2
279 ,P_ATTRIBUTE18 IN VARCHAR2 default hr_api.g_varchar2
280 ,P_ATTRIBUTE19 IN VARCHAR2 default hr_api.g_varchar2
281 ,P_ATTRIBUTE20 IN VARCHAR2 default hr_api.g_varchar2
282 ,P_ATTRIBUTE21 IN VARCHAR2 default hr_api.g_varchar2
283 ,P_ATTRIBUTE22 IN VARCHAR2 default hr_api.g_varchar2
284 ,P_ATTRIBUTE23 IN VARCHAR2 default hr_api.g_varchar2
285 ,P_ATTRIBUTE24 IN VARCHAR2 default hr_api.g_varchar2
286 ,P_ATTRIBUTE25 IN VARCHAR2 default hr_api.g_varchar2
287 ,P_ATTRIBUTE26 IN VARCHAR2 default hr_api.g_varchar2
288 ,P_ATTRIBUTE27 IN VARCHAR2 default hr_api.g_varchar2
289 ,P_ATTRIBUTE28 IN VARCHAR2 default hr_api.g_varchar2
290 ,P_ATTRIBUTE29 IN VARCHAR2 default hr_api.g_varchar2
291 ,P_ATTRIBUTE30 IN VARCHAR2 default hr_api.g_varchar2
292 ,P_OBJECT_VERSION_NUMBER IN OUT NOCOPY NUMBER
293 );
294 --
295 -- ----------------------------------------------------------------------------
296 -- |--------------------------< delete_default_posting >----------------------|
297 -- ----------------------------------------------------------------------------
298 --
299 -- {Start Of Comments}
300 /*#
301 * This API deletes a Default Posting.
302 *
303 *
304 * <p><b>Licensing</b><br>
305 * This API is licensed for use with iRecruitment.
306 *
307 * <p><b>Prerequisites</b><br>
308 * The default posting must exist in the database
309 *
310 * <p><b>Post Success</b><br>
311 * The default posting will be deleted in the database
312 *
313 * <p><b>Post Failure</b><br>
314 * The default posting will not be deleted in the database and an error will be
315 * raised
316 * @param p_validate If true, then validation alone will be performed and the
317 * database will remain unchanged. If false and all validation checks pass,
318 * then the database will be modified.
319 * @param p_default_posting_id Identifies the default posting to be deleted
320 * @param p_object_version_number Current version number of the default posting
321 * to be deleted.
322 * @rep:displayname Delete Default Posting
323 * @rep:category BUSINESS_ENTITY IRC_DEFAULT_JOB_POSTING
324 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
325 * @rep:scope public
326 * @rep:lifecycle active
327 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
328 */
329 --
330 -- {End Of Comments}
331 --
332 procedure delete_default_posting
333 (P_VALIDATE in BOOLEAN default false
334 ,P_DEFAULT_POSTING_ID in NUMBER
335 ,P_OBJECT_VERSION_NUMBER in NUMBER
336 );
337
338 --
339 end irc_default_posting_api;