[Home] [Help]
PACKAGE BODY: APPS.IRC_POSTING_CONTENT_API
Source
1 Package Body IRC_POSTING_CONTENT_API as
2 /* $Header: iripcapi.pkb 120.2 2006/02/16 07:22:04 mmillmor noship $ */
3 --
4 -- Package Variables
5 --
6 g_package varchar2(33) := 'IRC_POSTING_CONTENT_API.';
7 g_full_mode varchar2(30) := 'FULL';
8 g_online_mode varchar2(30) := 'ONLINE';
9 g_none_mode varchar(30) :='NONE';
10 --
11 --
12 -- ----------------------------------------------------------------------------
13 -- |--------------------------< synchronize_index >-----------------------
14 -- ----------------------------------------------------------------------------
15 Procedure synchronize_index(p_mode in varchar2)
16 is
17 l_proc varchar2(72) := g_package||'synchronize_index';
18 l_hr_username fnd_oracle_userid.oracle_username%TYPE :=null ;
19 cursor csr_user is
20 select oracle_username
21 from fnd_oracle_userid
22 where oracle_id = 800;
23 begin
24 hr_utility.set_location('Entering:'|| l_proc, 10);
25 open csr_user;
26 fetch csr_user into l_hr_username;
27 close csr_user;
28 If l_hr_username is not null
29 then
30 If p_mode = g_full_mode
31 then
32 hr_utility.set_location(l_proc, 20);
33 ad_ctx_ddl.optimize_index
34 (idx_name=>l_hr_username||'.IRC_POSTING_CON_TL_CTX'
35 ,optlevel=>'FULL'
36 ,maxtime=>null
37 ,token=>null);
38 elsif p_mode = g_online_mode
39 then
40 hr_utility.set_location(l_proc, 30);
41 ad_ctx_ddl.sync_index
42 (idx_name=>l_hr_username||'.IRC_POSTING_CON_TL_CTX');
43 elsif p_mode = g_none_mode
44 then
45 hr_utility.set_location(l_proc, 35);
46 end if;
47 end if;
48 hr_utility.set_location('Leaving:'|| l_proc, 40);
49 exception
50 when others then
51 If csr_user%isopen
52 then
53 close csr_user;
54 End if;
55 raise;
56 end synchronize_index;
57 -- ----------------------------------------------------------------------------
58 -- |--------------------------< create_posting_content >-----------------------
59 -- ----------------------------------------------------------------------------
60 --
61 procedure create_posting_content
62 (
63 P_VALIDATE in boolean default false
64 ,P_DISPLAY_MANAGER_INFO in varchar2
65 ,P_DISPLAY_RECRUITER_INFO in varchar2
66 ,P_LANGUAGE_CODE in varchar2 default hr_api.userenv_lang
67 ,P_NAME in varchar2
68 ,P_ORG_NAME in varchar2 default null
69 ,P_ORG_DESCRIPTION in varchar2 default null
70 ,P_JOB_TITLE in varchar2 default null
71 ,P_BRIEF_DESCRIPTION in varchar2 default null
72 ,P_DETAILED_DESCRIPTION in varchar2 default null
73 ,P_JOB_REQUIREMENTS in varchar2 default null
74 ,P_ADDITIONAL_DETAILS in varchar2 default null
75 ,P_HOW_TO_APPLY in varchar2 default null
76 ,P_BENEFIT_INFO in varchar2 default null
77 ,P_IMAGE_URL in varchar2 default null
78 ,P_ALT_IMAGE_URL in varchar2 default null
79 ,P_ATTRIBUTE_CATEGORY in varchar2 default null
80 ,P_ATTRIBUTE1 in varchar2 default null
81 ,P_ATTRIBUTE2 in varchar2 default null
82 ,P_ATTRIBUTE3 in varchar2 default null
83 ,P_ATTRIBUTE4 in varchar2 default null
84 ,P_ATTRIBUTE5 in varchar2 default null
85 ,P_ATTRIBUTE6 in varchar2 default null
86 ,P_ATTRIBUTE7 in varchar2 default null
87 ,P_ATTRIBUTE8 in varchar2 default null
88 ,P_ATTRIBUTE9 in varchar2 default null
89 ,P_ATTRIBUTE10 in varchar2 default null
90 ,P_ATTRIBUTE11 in varchar2 default null
91 ,P_ATTRIBUTE12 in varchar2 default null
92 ,P_ATTRIBUTE13 in varchar2 default null
93 ,P_ATTRIBUTE14 in varchar2 default null
94 ,P_ATTRIBUTE15 in varchar2 default null
95 ,P_ATTRIBUTE16 in varchar2 default null
96 ,P_ATTRIBUTE17 in varchar2 default null
97 ,P_ATTRIBUTE18 in varchar2 default null
98 ,P_ATTRIBUTE19 in varchar2 default null
99 ,P_ATTRIBUTE20 in varchar2 default null
100 ,P_ATTRIBUTE21 in varchar2 default null
101 ,P_ATTRIBUTE22 in varchar2 default null
102 ,P_ATTRIBUTE23 in varchar2 default null
103 ,P_ATTRIBUTE24 in varchar2 default null
104 ,P_ATTRIBUTE25 in varchar2 default null
105 ,P_ATTRIBUTE26 in varchar2 default null
106 ,P_ATTRIBUTE27 in varchar2 default null
107 ,P_ATTRIBUTE28 in varchar2 default null
108 ,P_ATTRIBUTE29 in varchar2 default null
109 ,P_ATTRIBUTE30 in varchar2 default null
110 ,P_IPC_INFORMATION_CATEGORY in varchar2 default null
111 ,P_IPC_INFORMATION1 in varchar2 default null
112 ,P_IPC_INFORMATION2 in varchar2 default null
113 ,P_IPC_INFORMATION3 in varchar2 default null
114 ,P_IPC_INFORMATION4 in varchar2 default null
115 ,P_IPC_INFORMATION5 in varchar2 default null
116 ,P_IPC_INFORMATION6 in varchar2 default null
117 ,P_IPC_INFORMATION7 in varchar2 default null
118 ,P_IPC_INFORMATION8 in varchar2 default null
119 ,P_IPC_INFORMATION9 in varchar2 default null
120 ,P_IPC_INFORMATION10 in varchar2 default null
121 ,P_IPC_INFORMATION11 in varchar2 default null
122 ,P_IPC_INFORMATION12 in varchar2 default null
123 ,P_IPC_INFORMATION13 in varchar2 default null
124 ,P_IPC_INFORMATION14 in varchar2 default null
125 ,P_IPC_INFORMATION15 in varchar2 default null
126 ,P_IPC_INFORMATION16 in varchar2 default null
127 ,P_IPC_INFORMATION17 in varchar2 default null
128 ,P_IPC_INFORMATION18 in varchar2 default null
129 ,P_IPC_INFORMATION19 in varchar2 default null
130 ,P_IPC_INFORMATION20 in varchar2 default null
131 ,P_IPC_INFORMATION21 in varchar2 default null
132 ,P_IPC_INFORMATION22 in varchar2 default null
133 ,P_IPC_INFORMATION23 in varchar2 default null
134 ,P_IPC_INFORMATION24 in varchar2 default null
135 ,P_IPC_INFORMATION25 in varchar2 default null
136 ,P_IPC_INFORMATION26 in varchar2 default null
137 ,P_IPC_INFORMATION27 in varchar2 default null
138 ,P_IPC_INFORMATION28 in varchar2 default null
139 ,P_IPC_INFORMATION29 in varchar2 default null
140 ,P_IPC_INFORMATION30 in varchar2 default null
141 ,P_DATE_APPROVED in date default null
142 ,P_POSTING_CONTENT_ID out nocopy number
143 ,P_OBJECT_VERSION_NUMBER out nocopy number
144 )is
145 --
146 -- Declare cursors and local variables
147 --
148 l_proc varchar2(72) := g_package||'create_posting_content';
149 l_posting_content_id number;
150 l_language_code varchar2(30);
151 l_object_version_number number;
152 l_date_approved date := trunc(P_DATE_APPROVED);
153 begin
154 hr_utility.set_location('Entering:'|| l_proc, 10);
155 --
156 -- Issue a savepoint
157 --
158 savepoint create_posting_content;
159 --
160 l_language_code:=p_language_code;
161 hr_api.validate_language_code(p_language_code => l_language_code);
162 --
163 -- Call Before Process User Hook
164 --
165 begin
166 IRC_POSTING_CONTENT_BK1.create_posting_content_b
167 (
168 P_DISPLAY_MANAGER_INFO => P_DISPLAY_MANAGER_INFO
169 ,P_DISPLAY_RECRUITER_INFO => P_DISPLAY_RECRUITER_INFO
170 ,P_LANGUAGE_CODE => l_language_code
171 ,P_NAME => P_NAME
172 ,P_ORG_NAME => P_ORG_NAME
173 ,P_ORG_DESCRIPTION => P_ORG_DESCRIPTION
174 ,P_JOB_TITLE => P_JOB_TITLE
175 ,P_BRIEF_DESCRIPTION => P_BRIEF_DESCRIPTION
176 ,P_DETAILED_DESCRIPTION => P_DETAILED_DESCRIPTION
177 ,P_JOB_REQUIREMENTS => P_JOB_REQUIREMENTS
178 ,P_ADDITIONAL_DETAILS => P_ADDITIONAL_DETAILS
179 ,P_HOW_TO_APPLY => P_HOW_TO_APPLY
180 ,P_BENEFIT_INFO => P_BENEFIT_INFO
181 ,P_IMAGE_URL => P_IMAGE_URL
182 ,P_ALT_IMAGE_URL => P_ALT_IMAGE_URL
183 ,P_ATTRIBUTE_CATEGORY => P_ATTRIBUTE_CATEGORY
184 ,P_ATTRIBUTE1 => P_ATTRIBUTE1
185 ,P_ATTRIBUTE2 => P_ATTRIBUTE2
186 ,P_ATTRIBUTE3 => P_ATTRIBUTE3
187 ,P_ATTRIBUTE4 => P_ATTRIBUTE4
188 ,P_ATTRIBUTE5 => P_ATTRIBUTE5
189 ,P_ATTRIBUTE6 => P_ATTRIBUTE6
190 ,P_ATTRIBUTE7 => P_ATTRIBUTE7
191 ,P_ATTRIBUTE8 => P_ATTRIBUTE8
192 ,P_ATTRIBUTE9 => P_ATTRIBUTE9
193 ,P_ATTRIBUTE10 => P_ATTRIBUTE10
194 ,P_ATTRIBUTE11 => P_ATTRIBUTE11
195 ,P_ATTRIBUTE12 => P_ATTRIBUTE12
196 ,P_ATTRIBUTE13 => P_ATTRIBUTE13
197 ,P_ATTRIBUTE14 => P_ATTRIBUTE14
198 ,P_ATTRIBUTE15 => P_ATTRIBUTE15
199 ,P_ATTRIBUTE16 => P_ATTRIBUTE16
200 ,P_ATTRIBUTE17 => P_ATTRIBUTE17
201 ,P_ATTRIBUTE18 => P_ATTRIBUTE18
202 ,P_ATTRIBUTE19 => P_ATTRIBUTE19
203 ,P_ATTRIBUTE20 => P_ATTRIBUTE20
204 ,P_ATTRIBUTE21 => P_ATTRIBUTE21
205 ,P_ATTRIBUTE22 => P_ATTRIBUTE22
206 ,P_ATTRIBUTE23 => P_ATTRIBUTE23
207 ,P_ATTRIBUTE24 => P_ATTRIBUTE24
208 ,P_ATTRIBUTE25 => P_ATTRIBUTE25
209 ,P_ATTRIBUTE26 => P_ATTRIBUTE26
210 ,P_ATTRIBUTE27 => P_ATTRIBUTE27
211 ,P_ATTRIBUTE28 => P_ATTRIBUTE28
212 ,P_ATTRIBUTE29 => P_ATTRIBUTE29
213 ,P_ATTRIBUTE30 => P_ATTRIBUTE30
214 ,P_IPC_INFORMATION_CATEGORY => P_IPC_INFORMATION_CATEGORY
215 ,P_IPC_INFORMATION1 => P_IPC_INFORMATION1
216 ,P_IPC_INFORMATION2 => P_IPC_INFORMATION2
217 ,P_IPC_INFORMATION3 => P_IPC_INFORMATION3
218 ,P_IPC_INFORMATION4 => P_IPC_INFORMATION4
219 ,P_IPC_INFORMATION5 => P_IPC_INFORMATION5
220 ,P_IPC_INFORMATION6 => P_IPC_INFORMATION6
221 ,P_IPC_INFORMATION7 => P_IPC_INFORMATION7
222 ,P_IPC_INFORMATION8 => P_IPC_INFORMATION8
223 ,P_IPC_INFORMATION9 => P_IPC_INFORMATION9
224 ,P_IPC_INFORMATION10 => P_IPC_INFORMATION10
225 ,P_IPC_INFORMATION11 => P_IPC_INFORMATION11
226 ,P_IPC_INFORMATION12 => P_IPC_INFORMATION12
227 ,P_IPC_INFORMATION13 => P_IPC_INFORMATION13
228 ,P_IPC_INFORMATION14 => P_IPC_INFORMATION14
229 ,P_IPC_INFORMATION15 => P_IPC_INFORMATION15
230 ,P_IPC_INFORMATION16 => P_IPC_INFORMATION16
231 ,P_IPC_INFORMATION17 => P_IPC_INFORMATION17
232 ,P_IPC_INFORMATION18 => P_IPC_INFORMATION18
233 ,P_IPC_INFORMATION19 => P_IPC_INFORMATION19
234 ,P_IPC_INFORMATION20 => P_IPC_INFORMATION20
235 ,P_IPC_INFORMATION21 => P_IPC_INFORMATION21
236 ,P_IPC_INFORMATION22 => P_IPC_INFORMATION22
237 ,P_IPC_INFORMATION23 => P_IPC_INFORMATION23
238 ,P_IPC_INFORMATION24 => P_IPC_INFORMATION24
239 ,P_IPC_INFORMATION25 => P_IPC_INFORMATION25
240 ,P_IPC_INFORMATION26 => P_IPC_INFORMATION26
241 ,P_IPC_INFORMATION27 => P_IPC_INFORMATION27
242 ,P_IPC_INFORMATION28 => P_IPC_INFORMATION28
243 ,P_IPC_INFORMATION29 => P_IPC_INFORMATION29
244 ,P_IPC_INFORMATION30 => P_IPC_INFORMATION30
245 ,P_DATE_APPROVED => l_date_approved
246 );
247 exception
248 when hr_api.cannot_find_prog_unit then
249 hr_api.cannot_find_prog_unit_error
250 (p_module_name => 'create_posting_content'
251 ,p_hook_type => 'BP'
252 );
253 end;
254 --
255 -- Validation in addition to Row Handlers
256 --
257 irc_ipc_ins.ins
258 (p_display_manager_info => P_DISPLAY_MANAGER_INFO
259 ,p_display_recruiter_info => P_DISPLAY_RECRUITER_INFO
260 ,p_attribute_category => P_ATTRIBUTE_CATEGORY
261 ,p_attribute1 => P_ATTRIBUTE1
262 ,p_attribute2 => P_ATTRIBUTE2
263 ,p_attribute3 => P_ATTRIBUTE3
264 ,p_attribute4 => P_ATTRIBUTE4
265 ,p_attribute5 => P_ATTRIBUTE5
266 ,p_attribute6 => P_ATTRIBUTE6
267 ,p_attribute7 => P_ATTRIBUTE7
268 ,p_attribute8 => P_ATTRIBUTE8
269 ,p_attribute9 => P_ATTRIBUTE9
270 ,p_attribute10 => P_ATTRIBUTE10
271 ,p_attribute11 => P_ATTRIBUTE11
272 ,p_attribute12 => P_ATTRIBUTE12
273 ,p_attribute13 => P_ATTRIBUTE13
274 ,p_attribute14 => P_ATTRIBUTE14
275 ,p_attribute15 => P_ATTRIBUTE15
276 ,p_attribute16 => P_ATTRIBUTE16
277 ,p_attribute17 => P_ATTRIBUTE17
278 ,p_attribute18 => P_ATTRIBUTE18
279 ,p_attribute19 => P_ATTRIBUTE19
280 ,p_attribute20 => P_ATTRIBUTE20
281 ,p_attribute21 => P_ATTRIBUTE21
282 ,p_attribute22 => P_ATTRIBUTE22
283 ,p_attribute23 => P_ATTRIBUTE23
284 ,p_attribute24 => P_ATTRIBUTE24
285 ,p_attribute25 => P_ATTRIBUTE25
286 ,p_attribute26 => P_ATTRIBUTE26
287 ,p_attribute27 => P_ATTRIBUTE27
288 ,p_attribute28 => P_ATTRIBUTE28
289 ,p_attribute29 => P_ATTRIBUTE29
290 ,p_attribute30 => P_ATTRIBUTE30
291 ,p_ipc_information_category => P_IPC_INFORMATION_CATEGORY
292 ,p_ipc_information1 => P_IPC_INFORMATION1
293 ,p_ipc_information2 => P_IPC_INFORMATION2
294 ,p_ipc_information3 => P_IPC_INFORMATION3
295 ,p_ipc_information4 => P_IPC_INFORMATION4
296 ,p_ipc_information5 => P_IPC_INFORMATION5
297 ,p_ipc_information6 => P_IPC_INFORMATION6
298 ,p_ipc_information7 => P_IPC_INFORMATION7
299 ,p_ipc_information8 => P_IPC_INFORMATION8
300 ,p_ipc_information9 => P_IPC_INFORMATION9
301 ,p_ipc_information10 => P_IPC_INFORMATION10
302 ,p_ipc_information11 => P_IPC_INFORMATION11
303 ,p_ipc_information12 => P_IPC_INFORMATION12
304 ,p_ipc_information13 => P_IPC_INFORMATION13
305 ,p_ipc_information14 => P_IPC_INFORMATION14
306 ,p_ipc_information15 => P_IPC_INFORMATION15
307 ,p_ipc_information16 => P_IPC_INFORMATION16
308 ,p_ipc_information17 => P_IPC_INFORMATION17
309 ,p_ipc_information18 => P_IPC_INFORMATION18
310 ,p_ipc_information19 => P_IPC_INFORMATION19
311 ,p_ipc_information20 => P_IPC_INFORMATION20
312 ,p_ipc_information21 => P_IPC_INFORMATION21
313 ,p_ipc_information22 => P_IPC_INFORMATION22
314 ,p_ipc_information23 => P_IPC_INFORMATION23
315 ,p_ipc_information24 => P_IPC_INFORMATION24
316 ,p_ipc_information25 => P_IPC_INFORMATION25
317 ,p_ipc_information26 => P_IPC_INFORMATION26
318 ,p_ipc_information27 => P_IPC_INFORMATION27
319 ,p_ipc_information28 => P_IPC_INFORMATION28
320 ,p_ipc_information29 => P_IPC_INFORMATION29
321 ,p_ipc_information30 => P_IPC_INFORMATION30
322 ,p_date_approved => l_date_approved
323 ,p_posting_content_id => l_posting_content_id
324 ,p_object_version_number => l_object_version_number
325 );
326 --
327 irc_ipt_ins.ins_tl
328 (p_language_code => l_language_code
329 ,p_posting_content_id => l_posting_content_id
330 ,p_name => P_NAME
331 ,p_org_name => P_ORG_NAME
332 ,p_org_description => P_ORG_DESCRIPTION
333 ,p_job_title => P_JOB_TITLE
334 ,p_brief_description => P_BRIEF_DESCRIPTION
335 ,p_detailed_description => P_DETAILED_DESCRIPTION
336 ,p_job_requirements => P_JOB_REQUIREMENTS
337 ,p_additional_details => P_ADDITIONAL_DETAILS
338 ,p_how_to_apply => P_HOW_TO_APPLY
339 ,p_benefit_info => P_BENEFIT_INFO
340 ,p_image_url => P_IMAGE_URL
341 ,p_image_url_alt => P_ALT_IMAGE_URL
342 );
343 --
344 -- Process Logic
345 --
346 --
347 -- Call After Process User Hook
348 --
349 begin
350 IRC_POSTING_CONTENT_BK1.create_posting_content_a
351 (
352 P_DISPLAY_MANAGER_INFO => P_DISPLAY_MANAGER_INFO
353 ,P_DISPLAY_RECRUITER_INFO => P_DISPLAY_RECRUITER_INFO
354 ,P_LANGUAGE_CODE => l_language_code
355 ,P_NAME => P_NAME
356 ,P_ORG_NAME => P_ORG_NAME
357 ,P_ORG_DESCRIPTION => P_ORG_DESCRIPTION
358 ,P_JOB_TITLE => P_JOB_TITLE
359 ,P_BRIEF_DESCRIPTION => P_BRIEF_DESCRIPTION
360 ,P_DETAILED_DESCRIPTION => P_DETAILED_DESCRIPTION
361 ,P_JOB_REQUIREMENTS => P_JOB_REQUIREMENTS
362 ,P_ADDITIONAL_DETAILS => P_ADDITIONAL_DETAILS
363 ,P_HOW_TO_APPLY => P_HOW_TO_APPLY
364 ,P_BENEFIT_INFO => P_BENEFIT_INFO
365 ,P_IMAGE_URL => P_IMAGE_URL
366 ,P_ALT_IMAGE_URL => P_ALT_IMAGE_URL
367 ,P_ATTRIBUTE_CATEGORY => P_ATTRIBUTE_CATEGORY
368 ,P_ATTRIBUTE1 => P_ATTRIBUTE1
369 ,P_ATTRIBUTE2 => P_ATTRIBUTE2
370 ,P_ATTRIBUTE3 => P_ATTRIBUTE3
371 ,P_ATTRIBUTE4 => P_ATTRIBUTE4
372 ,P_ATTRIBUTE5 => P_ATTRIBUTE5
373 ,P_ATTRIBUTE6 => P_ATTRIBUTE6
374 ,P_ATTRIBUTE7 => P_ATTRIBUTE7
375 ,P_ATTRIBUTE8 => P_ATTRIBUTE8
376 ,P_ATTRIBUTE9 => P_ATTRIBUTE9
377 ,P_ATTRIBUTE10 => P_ATTRIBUTE10
378 ,P_ATTRIBUTE11 => P_ATTRIBUTE11
379 ,P_ATTRIBUTE12 => P_ATTRIBUTE12
380 ,P_ATTRIBUTE13 => P_ATTRIBUTE13
381 ,P_ATTRIBUTE14 => P_ATTRIBUTE14
382 ,P_ATTRIBUTE15 => P_ATTRIBUTE15
383 ,P_ATTRIBUTE16 => P_ATTRIBUTE16
384 ,P_ATTRIBUTE17 => P_ATTRIBUTE17
385 ,P_ATTRIBUTE18 => P_ATTRIBUTE18
386 ,P_ATTRIBUTE19 => P_ATTRIBUTE19
387 ,P_ATTRIBUTE20 => P_ATTRIBUTE20
388 ,P_ATTRIBUTE21 => P_ATTRIBUTE21
389 ,P_ATTRIBUTE22 => P_ATTRIBUTE22
390 ,P_ATTRIBUTE23 => P_ATTRIBUTE23
391 ,P_ATTRIBUTE24 => P_ATTRIBUTE24
392 ,P_ATTRIBUTE25 => P_ATTRIBUTE25
393 ,P_ATTRIBUTE26 => P_ATTRIBUTE26
394 ,P_ATTRIBUTE27 => P_ATTRIBUTE27
395 ,P_ATTRIBUTE28 => P_ATTRIBUTE28
396 ,P_ATTRIBUTE29 => P_ATTRIBUTE29
397 ,P_ATTRIBUTE30 => P_ATTRIBUTE30
398 ,P_IPC_INFORMATION_CATEGORY => P_IPC_INFORMATION_CATEGORY
399 ,P_IPC_INFORMATION1 => P_IPC_INFORMATION1
400 ,P_IPC_INFORMATION2 => P_IPC_INFORMATION2
401 ,P_IPC_INFORMATION3 => P_IPC_INFORMATION3
402 ,P_IPC_INFORMATION4 => P_IPC_INFORMATION4
403 ,P_IPC_INFORMATION5 => P_IPC_INFORMATION5
404 ,P_IPC_INFORMATION6 => P_IPC_INFORMATION6
405 ,P_IPC_INFORMATION7 => P_IPC_INFORMATION7
406 ,P_IPC_INFORMATION8 => P_IPC_INFORMATION8
407 ,P_IPC_INFORMATION9 => P_IPC_INFORMATION9
408 ,P_IPC_INFORMATION10 => P_IPC_INFORMATION10
409 ,P_IPC_INFORMATION11 => P_IPC_INFORMATION11
410 ,P_IPC_INFORMATION12 => P_IPC_INFORMATION12
411 ,P_IPC_INFORMATION13 => P_IPC_INFORMATION13
412 ,P_IPC_INFORMATION14 => P_IPC_INFORMATION14
413 ,P_IPC_INFORMATION15 => P_IPC_INFORMATION15
414 ,P_IPC_INFORMATION16 => P_IPC_INFORMATION16
415 ,P_IPC_INFORMATION17 => P_IPC_INFORMATION17
416 ,P_IPC_INFORMATION18 => P_IPC_INFORMATION18
417 ,P_IPC_INFORMATION19 => P_IPC_INFORMATION19
418 ,P_IPC_INFORMATION20 => P_IPC_INFORMATION20
419 ,P_IPC_INFORMATION21 => P_IPC_INFORMATION21
420 ,P_IPC_INFORMATION22 => P_IPC_INFORMATION22
421 ,P_IPC_INFORMATION23 => P_IPC_INFORMATION23
422 ,P_IPC_INFORMATION24 => P_IPC_INFORMATION24
423 ,P_IPC_INFORMATION25 => P_IPC_INFORMATION25
424 ,P_IPC_INFORMATION26 => P_IPC_INFORMATION26
425 ,P_IPC_INFORMATION27 => P_IPC_INFORMATION27
426 ,P_IPC_INFORMATION28 => P_IPC_INFORMATION28
427 ,P_IPC_INFORMATION29 => P_IPC_INFORMATION29
428 ,P_IPC_INFORMATION30 => P_IPC_INFORMATION30
429 ,P_DATE_APPROVED => l_date_approved
430 ,P_POSTING_CONTENT_ID => l_posting_content_id
431 ,P_OBJECT_VERSION_NUMBER => l_object_version_number
432 );
433 exception
434 when hr_api.cannot_find_prog_unit then
435 hr_api.cannot_find_prog_unit_error
436 (p_module_name => 'create_posting_content'
437 ,p_hook_type => 'AP'
438 );
439 end;
440 --
441 -- When in validation only mode raise the Validate_Enabled exception
442 --
443 if p_validate then
444 raise hr_api.validate_enabled;
445 end if;
446 --
447 -- Set all output arguments
448 --
449 P_POSTING_CONTENT_ID := l_posting_content_id;
450 P_OBJECT_VERSION_NUMBER := l_object_version_number;
451 --
452 hr_utility.set_location(' Leaving:'||l_proc, 70);
453 exception
454 when hr_api.validate_enabled then
455 --
456 -- As the Validate_Enabled exception has been raised
457 -- we must rollback to the savepoint
458 --
459 rollback to create_posting_content;
460 --
461 -- Only set output warning arguments
462 -- (Any key or derived arguments must be set to null
463 -- when validation only mode is being used.)
464 --
465 P_POSTING_CONTENT_ID := null;
466 P_OBJECT_VERSION_NUMBER := null;
467 hr_utility.set_location(' Leaving:'||l_proc, 80);
468 when others then
469 --
470 -- A validation or unexpected error has occured
471 --
472 rollback to create_posting_content;
473 -- Reset IN OUT parameters and set OUT parameters
474 --
475 P_POSTING_CONTENT_ID := null;
476 P_OBJECT_VERSION_NUMBER := null;
477 hr_utility.set_location(' Leaving:'||l_proc, 90);
478 raise;
479 end create_posting_content;
480 --
481 -- ----------------------------------------------------------------------------
482 -- |--------------------------< update_posting_content >----------------------|
483 -- ----------------------------------------------------------------------------
484 --
485 procedure update_posting_content
486 (
487 P_VALIDATE in boolean default false
488 ,P_POSTING_CONTENT_ID in number
489 ,P_DISPLAY_MANAGER_INFO in varchar2 default hr_api.g_varchar2
490 ,P_DISPLAY_RECRUITER_INFO in varchar2 default hr_api.g_varchar2
491 ,P_LANGUAGE_CODE in varchar2 default hr_api.userenv_lang
492 ,P_NAME in varchar2 default hr_api.g_varchar2
493 ,P_ORG_NAME in varchar2 default hr_api.g_varchar2
494 ,P_ORG_DESCRIPTION in varchar2 default hr_api.g_varchar2
495 ,P_JOB_TITLE in varchar2 default hr_api.g_varchar2
496 ,P_BRIEF_DESCRIPTION in varchar2 default hr_api.g_varchar2
497 ,P_DETAILED_DESCRIPTION in varchar2 default hr_api.g_varchar2
498 ,P_JOB_REQUIREMENTS in varchar2 default hr_api.g_varchar2
499 ,P_ADDITIONAL_DETAILS in varchar2 default hr_api.g_varchar2
500 ,P_HOW_TO_APPLY in varchar2 default hr_api.g_varchar2
501 ,P_BENEFIT_INFO in varchar2 default hr_api.g_varchar2
502 ,P_IMAGE_URL in varchar2 default hr_api.g_varchar2
503 ,P_ALT_IMAGE_URL in varchar2 default hr_api.g_varchar2
504 ,P_ATTRIBUTE_CATEGORY in varchar2 default hr_api.g_varchar2
505 ,P_ATTRIBUTE1 in varchar2 default hr_api.g_varchar2
506 ,P_ATTRIBUTE2 in varchar2 default hr_api.g_varchar2
507 ,P_ATTRIBUTE3 in varchar2 default hr_api.g_varchar2
508 ,P_ATTRIBUTE4 in varchar2 default hr_api.g_varchar2
509 ,P_ATTRIBUTE5 in varchar2 default hr_api.g_varchar2
510 ,P_ATTRIBUTE6 in varchar2 default hr_api.g_varchar2
511 ,P_ATTRIBUTE7 in varchar2 default hr_api.g_varchar2
512 ,P_ATTRIBUTE8 in varchar2 default hr_api.g_varchar2
513 ,P_ATTRIBUTE9 in varchar2 default hr_api.g_varchar2
514 ,P_ATTRIBUTE10 in varchar2 default hr_api.g_varchar2
515 ,P_ATTRIBUTE11 in varchar2 default hr_api.g_varchar2
516 ,P_ATTRIBUTE12 in varchar2 default hr_api.g_varchar2
517 ,P_ATTRIBUTE13 in varchar2 default hr_api.g_varchar2
518 ,P_ATTRIBUTE14 in varchar2 default hr_api.g_varchar2
519 ,P_ATTRIBUTE15 in varchar2 default hr_api.g_varchar2
520 ,P_ATTRIBUTE16 in varchar2 default hr_api.g_varchar2
521 ,P_ATTRIBUTE17 in varchar2 default hr_api.g_varchar2
522 ,P_ATTRIBUTE18 in varchar2 default hr_api.g_varchar2
523 ,P_ATTRIBUTE19 in varchar2 default hr_api.g_varchar2
524 ,P_ATTRIBUTE20 in varchar2 default hr_api.g_varchar2
525 ,P_ATTRIBUTE21 in varchar2 default hr_api.g_varchar2
526 ,P_ATTRIBUTE22 in varchar2 default hr_api.g_varchar2
527 ,P_ATTRIBUTE23 in varchar2 default hr_api.g_varchar2
528 ,P_ATTRIBUTE24 in varchar2 default hr_api.g_varchar2
529 ,P_ATTRIBUTE25 in varchar2 default hr_api.g_varchar2
530 ,P_ATTRIBUTE26 in varchar2 default hr_api.g_varchar2
531 ,P_ATTRIBUTE27 in varchar2 default hr_api.g_varchar2
532 ,P_ATTRIBUTE28 in varchar2 default hr_api.g_varchar2
533 ,P_ATTRIBUTE29 in varchar2 default hr_api.g_varchar2
534 ,P_ATTRIBUTE30 in varchar2 default hr_api.g_varchar2
535 ,P_IPC_INFORMATION_CATEGORY in varchar2 default hr_api.g_varchar2
536 ,P_IPC_INFORMATION1 in varchar2 default hr_api.g_varchar2
537 ,P_IPC_INFORMATION2 in varchar2 default hr_api.g_varchar2
538 ,P_IPC_INFORMATION3 in varchar2 default hr_api.g_varchar2
539 ,P_IPC_INFORMATION4 in varchar2 default hr_api.g_varchar2
540 ,P_IPC_INFORMATION5 in varchar2 default hr_api.g_varchar2
541 ,P_IPC_INFORMATION6 in varchar2 default hr_api.g_varchar2
542 ,P_IPC_INFORMATION7 in varchar2 default hr_api.g_varchar2
543 ,P_IPC_INFORMATION8 in varchar2 default hr_api.g_varchar2
544 ,P_IPC_INFORMATION9 in varchar2 default hr_api.g_varchar2
545 ,P_IPC_INFORMATION10 in varchar2 default hr_api.g_varchar2
546 ,P_IPC_INFORMATION11 in varchar2 default hr_api.g_varchar2
547 ,P_IPC_INFORMATION12 in varchar2 default hr_api.g_varchar2
548 ,P_IPC_INFORMATION13 in varchar2 default hr_api.g_varchar2
549 ,P_IPC_INFORMATION14 in varchar2 default hr_api.g_varchar2
550 ,P_IPC_INFORMATION15 in varchar2 default hr_api.g_varchar2
551 ,P_IPC_INFORMATION16 in varchar2 default hr_api.g_varchar2
552 ,P_IPC_INFORMATION17 in varchar2 default hr_api.g_varchar2
553 ,P_IPC_INFORMATION18 in varchar2 default hr_api.g_varchar2
554 ,P_IPC_INFORMATION19 in varchar2 default hr_api.g_varchar2
555 ,P_IPC_INFORMATION20 in varchar2 default hr_api.g_varchar2
556 ,P_IPC_INFORMATION21 in varchar2 default hr_api.g_varchar2
557 ,P_IPC_INFORMATION22 in varchar2 default hr_api.g_varchar2
558 ,P_IPC_INFORMATION23 in varchar2 default hr_api.g_varchar2
559 ,P_IPC_INFORMATION24 in varchar2 default hr_api.g_varchar2
560 ,P_IPC_INFORMATION25 in varchar2 default hr_api.g_varchar2
561 ,P_IPC_INFORMATION26 in varchar2 default hr_api.g_varchar2
562 ,P_IPC_INFORMATION27 in varchar2 default hr_api.g_varchar2
563 ,P_IPC_INFORMATION28 in varchar2 default hr_api.g_varchar2
564 ,P_IPC_INFORMATION29 in varchar2 default hr_api.g_varchar2
565 ,P_IPC_INFORMATION30 in varchar2 default hr_api.g_varchar2
566 ,P_DATE_APPROVED in date default hr_api.g_date
567 ,P_OBJECT_VERSION_NUMBER in out nocopy number
568 )
569 is
570 --
571 -- Declare cursors and local variables
572 --
573 l_proc varchar2(72) := g_package||'update_posting_content';
574 l_object_version_number number := P_OBJECT_VERSION_NUMBER;
575 l_date_approved date := trunc(P_DATE_APPROVED);
576 l_language_code varchar2(30);
577 begin
578 hr_utility.set_location('Entering:'|| l_proc, 10);
579 --
580 -- Issue a savepoint
581 --
582 savepoint update_posting_content;
583 --
584 l_language_code:=p_language_code;
585 hr_api.validate_language_code(p_language_code => l_language_code);
586 --
587 --
588 -- Call Before Process User Hook
589 --
590 begin
591 IRC_POSTING_CONTENT_BK2.update_posting_content_b
592 (
593 P_POSTING_CONTENT_ID => P_POSTING_CONTENT_ID
594 ,P_DISPLAY_MANAGER_INFO => P_DISPLAY_MANAGER_INFO
595 ,P_DISPLAY_RECRUITER_INFO => P_DISPLAY_RECRUITER_INFO
596 ,P_LANGUAGE_CODE => l_language_code
597 ,P_NAME => P_NAME
598 ,P_ORG_NAME => P_ORG_NAME
599 ,P_ORG_DESCRIPTION => P_ORG_DESCRIPTION
600 ,P_JOB_TITLE => P_JOB_TITLE
601 ,P_BRIEF_DESCRIPTION => P_BRIEF_DESCRIPTION
602 ,P_DETAILED_DESCRIPTION => P_DETAILED_DESCRIPTION
603 ,P_JOB_REQUIREMENTS => P_JOB_REQUIREMENTS
604 ,P_ADDITIONAL_DETAILS => P_ADDITIONAL_DETAILS
605 ,P_HOW_TO_APPLY => P_HOW_TO_APPLY
606 ,P_BENEFIT_INFO => P_BENEFIT_INFO
607 ,P_IMAGE_URL => P_IMAGE_URL
608 ,P_ALT_IMAGE_URL => P_ALT_IMAGE_URL
609 ,P_ATTRIBUTE_CATEGORY => P_ATTRIBUTE_CATEGORY
610 ,P_ATTRIBUTE1 => P_ATTRIBUTE1
611 ,P_ATTRIBUTE2 => P_ATTRIBUTE2
612 ,P_ATTRIBUTE3 => P_ATTRIBUTE3
613 ,P_ATTRIBUTE4 => P_ATTRIBUTE4
614 ,P_ATTRIBUTE5 => P_ATTRIBUTE5
615 ,P_ATTRIBUTE6 => P_ATTRIBUTE6
616 ,P_ATTRIBUTE7 => P_ATTRIBUTE7
617 ,P_ATTRIBUTE8 => P_ATTRIBUTE8
618 ,P_ATTRIBUTE9 => P_ATTRIBUTE9
619 ,P_ATTRIBUTE10 => P_ATTRIBUTE10
620 ,P_ATTRIBUTE11 => P_ATTRIBUTE11
621 ,P_ATTRIBUTE12 => P_ATTRIBUTE12
622 ,P_ATTRIBUTE13 => P_ATTRIBUTE13
623 ,P_ATTRIBUTE14 => P_ATTRIBUTE14
624 ,P_ATTRIBUTE15 => P_ATTRIBUTE15
625 ,P_ATTRIBUTE16 => P_ATTRIBUTE16
626 ,P_ATTRIBUTE17 => P_ATTRIBUTE17
627 ,P_ATTRIBUTE18 => P_ATTRIBUTE18
628 ,P_ATTRIBUTE19 => P_ATTRIBUTE19
629 ,P_ATTRIBUTE20 => P_ATTRIBUTE20
630 ,P_ATTRIBUTE21 => P_ATTRIBUTE21
631 ,P_ATTRIBUTE22 => P_ATTRIBUTE22
632 ,P_ATTRIBUTE23 => P_ATTRIBUTE23
633 ,P_ATTRIBUTE24 => P_ATTRIBUTE24
634 ,P_ATTRIBUTE25 => P_ATTRIBUTE25
635 ,P_ATTRIBUTE26 => P_ATTRIBUTE26
636 ,P_ATTRIBUTE27 => P_ATTRIBUTE27
637 ,P_ATTRIBUTE28 => P_ATTRIBUTE28
638 ,P_ATTRIBUTE29 => P_ATTRIBUTE29
639 ,P_ATTRIBUTE30 => P_ATTRIBUTE30
640 ,P_IPC_INFORMATION_CATEGORY => P_IPC_INFORMATION_CATEGORY
641 ,P_IPC_INFORMATION1 => P_IPC_INFORMATION1
642 ,P_IPC_INFORMATION2 => P_IPC_INFORMATION2
643 ,P_IPC_INFORMATION3 => P_IPC_INFORMATION3
644 ,P_IPC_INFORMATION4 => P_IPC_INFORMATION4
645 ,P_IPC_INFORMATION5 => P_IPC_INFORMATION5
646 ,P_IPC_INFORMATION6 => P_IPC_INFORMATION6
647 ,P_IPC_INFORMATION7 => P_IPC_INFORMATION7
648 ,P_IPC_INFORMATION8 => P_IPC_INFORMATION8
649 ,P_IPC_INFORMATION9 => P_IPC_INFORMATION9
650 ,P_IPC_INFORMATION10 => P_IPC_INFORMATION10
651 ,P_IPC_INFORMATION11 => P_IPC_INFORMATION11
652 ,P_IPC_INFORMATION12 => P_IPC_INFORMATION12
653 ,P_IPC_INFORMATION13 => P_IPC_INFORMATION13
654 ,P_IPC_INFORMATION14 => P_IPC_INFORMATION14
655 ,P_IPC_INFORMATION15 => P_IPC_INFORMATION15
656 ,P_IPC_INFORMATION16 => P_IPC_INFORMATION16
657 ,P_IPC_INFORMATION17 => P_IPC_INFORMATION17
658 ,P_IPC_INFORMATION18 => P_IPC_INFORMATION18
659 ,P_IPC_INFORMATION19 => P_IPC_INFORMATION19
660 ,P_IPC_INFORMATION20 => P_IPC_INFORMATION20
661 ,P_IPC_INFORMATION21 => P_IPC_INFORMATION21
662 ,P_IPC_INFORMATION22 => P_IPC_INFORMATION22
663 ,P_IPC_INFORMATION23 => P_IPC_INFORMATION23
664 ,P_IPC_INFORMATION24 => P_IPC_INFORMATION24
665 ,P_IPC_INFORMATION25 => P_IPC_INFORMATION25
666 ,P_IPC_INFORMATION26 => P_IPC_INFORMATION26
667 ,P_IPC_INFORMATION27 => P_IPC_INFORMATION27
668 ,P_IPC_INFORMATION28 => P_IPC_INFORMATION28
669 ,P_IPC_INFORMATION29 => P_IPC_INFORMATION29
670 ,P_IPC_INFORMATION30 => P_IPC_INFORMATION30
671 ,P_DATE_APPROVED => l_date_approved
672 ,P_OBJECT_VERSION_NUMBER => l_object_version_number
673 );
674 exception
675 when hr_api.cannot_find_prog_unit then
676 hr_api.cannot_find_prog_unit_error
677 (p_module_name => 'update_posting_content'
678 ,p_hook_type => 'BP'
679 );
680 end;
681 --
682 -- Validation in addition to Row Handlers
683 --
684 irc_ipc_upd.upd
685 (p_posting_content_id => P_POSTING_CONTENT_ID
686 ,p_object_version_number => l_object_version_number
687 ,p_display_manager_info => P_DISPLAY_MANAGER_INFO
688 ,p_display_recruiter_info => P_DISPLAY_RECRUITER_INFO
689 ,p_attribute_category => P_ATTRIBUTE_CATEGORY
690 ,p_attribute1 => P_ATTRIBUTE1
691 ,p_attribute2 => P_ATTRIBUTE2
692 ,p_attribute3 => P_ATTRIBUTE3
693 ,p_attribute4 => P_ATTRIBUTE4
694 ,p_attribute5 => P_ATTRIBUTE5
695 ,p_attribute6 => P_ATTRIBUTE6
696 ,p_attribute7 => P_ATTRIBUTE7
697 ,p_attribute8 => P_ATTRIBUTE8
698 ,p_attribute9 => P_ATTRIBUTE9
699 ,p_attribute10 => P_ATTRIBUTE10
700 ,p_attribute11 => P_ATTRIBUTE11
701 ,p_attribute12 => P_ATTRIBUTE12
702 ,p_attribute13 => P_ATTRIBUTE13
703 ,p_attribute14 => P_ATTRIBUTE14
704 ,p_attribute15 => P_ATTRIBUTE15
705 ,p_attribute16 => P_ATTRIBUTE16
706 ,p_attribute17 => P_ATTRIBUTE17
707 ,p_attribute18 => P_ATTRIBUTE18
708 ,p_attribute19 => P_ATTRIBUTE19
709 ,p_attribute20 => P_ATTRIBUTE20
710 ,p_attribute21 => P_ATTRIBUTE21
711 ,p_attribute22 => P_ATTRIBUTE22
712 ,p_attribute23 => P_ATTRIBUTE23
713 ,p_attribute24 => P_ATTRIBUTE24
714 ,p_attribute25 => P_ATTRIBUTE25
715 ,p_attribute26 => P_ATTRIBUTE26
716 ,p_attribute27 => P_ATTRIBUTE27
717 ,p_attribute28 => P_ATTRIBUTE28
718 ,p_attribute29 => P_ATTRIBUTE29
719 ,p_attribute30 => P_ATTRIBUTE30
720 ,p_ipc_information_category => P_IPC_INFORMATION_CATEGORY
721 ,p_ipc_information1 => P_IPC_INFORMATION1
722 ,p_ipc_information2 => P_IPC_INFORMATION2
723 ,p_ipc_information3 => P_IPC_INFORMATION3
724 ,p_ipc_information4 => P_IPC_INFORMATION4
725 ,p_ipc_information5 => P_IPC_INFORMATION5
726 ,p_ipc_information6 => P_IPC_INFORMATION6
727 ,p_ipc_information7 => P_IPC_INFORMATION7
728 ,p_ipc_information8 => P_IPC_INFORMATION8
729 ,p_ipc_information9 => P_IPC_INFORMATION9
730 ,p_ipc_information10 => P_IPC_INFORMATION10
731 ,p_ipc_information11 => P_IPC_INFORMATION11
732 ,p_ipc_information12 => P_IPC_INFORMATION12
733 ,p_ipc_information13 => P_IPC_INFORMATION13
734 ,p_ipc_information14 => P_IPC_INFORMATION14
735 ,p_ipc_information15 => P_IPC_INFORMATION15
736 ,p_ipc_information16 => P_IPC_INFORMATION16
737 ,p_ipc_information17 => P_IPC_INFORMATION17
738 ,p_ipc_information18 => P_IPC_INFORMATION18
739 ,p_ipc_information19 => P_IPC_INFORMATION19
740 ,p_ipc_information20 => P_IPC_INFORMATION20
741 ,p_ipc_information21 => P_IPC_INFORMATION21
742 ,p_ipc_information22 => P_IPC_INFORMATION22
743 ,p_ipc_information23 => P_IPC_INFORMATION23
744 ,p_ipc_information24 => P_IPC_INFORMATION24
745 ,p_ipc_information25 => P_IPC_INFORMATION25
746 ,p_ipc_information26 => P_IPC_INFORMATION26
747 ,p_ipc_information27 => P_IPC_INFORMATION27
748 ,p_ipc_information28 => P_IPC_INFORMATION28
749 ,p_ipc_information29 => P_IPC_INFORMATION29
750 ,p_ipc_information30 => P_IPC_INFORMATION30
751 ,p_date_approved => l_date_approved
752 );
753 --
754 -- Process Logic
755 irc_ipt_upd.upd_tl
756 (p_language_code => l_language_code
757 ,p_posting_content_id => P_POSTING_CONTENT_ID
758 ,p_name => P_NAME
759 ,p_org_name => P_ORG_NAME
760 ,p_org_description => P_ORG_DESCRIPTION
761 ,p_job_title => P_JOB_TITLE
762 ,p_brief_description => P_BRIEF_DESCRIPTION
763 ,p_detailed_description => P_DETAILED_DESCRIPTION
764 ,p_job_requirements => P_JOB_REQUIREMENTS
765 ,p_additional_details => P_ADDITIONAL_DETAILS
766 ,p_how_to_apply => P_HOW_TO_APPLY
767 ,p_benefit_info => P_BENEFIT_INFO
768 ,p_image_url => P_IMAGE_URL
769 ,p_image_url_alt => P_ALT_IMAGE_URL
770 );
771 --
772 --
773 -- Call After Process User Hook
774 --
775 begin
776 IRC_POSTING_CONTENT_BK2.update_posting_content_a
777 (
778 P_POSTING_CONTENT_ID => P_POSTING_CONTENT_ID
779 ,P_DISPLAY_MANAGER_INFO => P_DISPLAY_MANAGER_INFO
780 ,P_DISPLAY_RECRUITER_INFO => P_DISPLAY_RECRUITER_INFO
781 ,P_LANGUAGE_CODE => l_language_code
782 ,P_NAME => P_NAME
783 ,P_ORG_NAME => P_ORG_NAME
784 ,P_ORG_DESCRIPTION => P_ORG_DESCRIPTION
785 ,P_JOB_TITLE => P_JOB_TITLE
786 ,P_BRIEF_DESCRIPTION => P_BRIEF_DESCRIPTION
787 ,P_DETAILED_DESCRIPTION => P_DETAILED_DESCRIPTION
788 ,P_JOB_REQUIREMENTS => P_JOB_REQUIREMENTS
789 ,P_ADDITIONAL_DETAILS => P_ADDITIONAL_DETAILS
790 ,P_HOW_TO_APPLY => P_HOW_TO_APPLY
791 ,P_BENEFIT_INFO => P_BENEFIT_INFO
792 ,P_IMAGE_URL => P_IMAGE_URL
793 ,P_ALT_IMAGE_URL => P_ALT_IMAGE_URL
794 ,P_ATTRIBUTE_CATEGORY => P_ATTRIBUTE_CATEGORY
795 ,P_ATTRIBUTE1 => P_ATTRIBUTE1
796 ,P_ATTRIBUTE2 => P_ATTRIBUTE2
797 ,P_ATTRIBUTE3 => P_ATTRIBUTE3
798 ,P_ATTRIBUTE4 => P_ATTRIBUTE4
799 ,P_ATTRIBUTE5 => P_ATTRIBUTE5
800 ,P_ATTRIBUTE6 => P_ATTRIBUTE6
801 ,P_ATTRIBUTE7 => P_ATTRIBUTE7
802 ,P_ATTRIBUTE8 => P_ATTRIBUTE8
803 ,P_ATTRIBUTE9 => P_ATTRIBUTE9
804 ,P_ATTRIBUTE10 => P_ATTRIBUTE10
805 ,P_ATTRIBUTE11 => P_ATTRIBUTE11
806 ,P_ATTRIBUTE12 => P_ATTRIBUTE12
807 ,P_ATTRIBUTE13 => P_ATTRIBUTE13
808 ,P_ATTRIBUTE14 => P_ATTRIBUTE14
809 ,P_ATTRIBUTE15 => P_ATTRIBUTE15
810 ,P_ATTRIBUTE16 => P_ATTRIBUTE16
811 ,P_ATTRIBUTE17 => P_ATTRIBUTE17
812 ,P_ATTRIBUTE18 => P_ATTRIBUTE18
813 ,P_ATTRIBUTE19 => P_ATTRIBUTE19
814 ,P_ATTRIBUTE20 => P_ATTRIBUTE20
815 ,P_ATTRIBUTE21 => P_ATTRIBUTE21
816 ,P_ATTRIBUTE22 => P_ATTRIBUTE22
817 ,P_ATTRIBUTE23 => P_ATTRIBUTE23
818 ,P_ATTRIBUTE24 => P_ATTRIBUTE24
819 ,P_ATTRIBUTE25 => P_ATTRIBUTE25
820 ,P_ATTRIBUTE26 => P_ATTRIBUTE26
821 ,P_ATTRIBUTE27 => P_ATTRIBUTE27
822 ,P_ATTRIBUTE28 => P_ATTRIBUTE28
823 ,P_ATTRIBUTE29 => P_ATTRIBUTE29
824 ,P_ATTRIBUTE30 => P_ATTRIBUTE30
825 ,P_IPC_INFORMATION_CATEGORY => P_IPC_INFORMATION_CATEGORY
826 ,P_IPC_INFORMATION1 => P_IPC_INFORMATION1
827 ,P_IPC_INFORMATION2 => P_IPC_INFORMATION2
828 ,P_IPC_INFORMATION3 => P_IPC_INFORMATION3
829 ,P_IPC_INFORMATION4 => P_IPC_INFORMATION4
830 ,P_IPC_INFORMATION5 => P_IPC_INFORMATION5
831 ,P_IPC_INFORMATION6 => P_IPC_INFORMATION6
832 ,P_IPC_INFORMATION7 => P_IPC_INFORMATION7
833 ,P_IPC_INFORMATION8 => P_IPC_INFORMATION8
834 ,P_IPC_INFORMATION9 => P_IPC_INFORMATION9
835 ,P_IPC_INFORMATION10 => P_IPC_INFORMATION10
836 ,P_IPC_INFORMATION11 => P_IPC_INFORMATION11
837 ,P_IPC_INFORMATION12 => P_IPC_INFORMATION12
838 ,P_IPC_INFORMATION13 => P_IPC_INFORMATION13
839 ,P_IPC_INFORMATION14 => P_IPC_INFORMATION14
840 ,P_IPC_INFORMATION15 => P_IPC_INFORMATION15
841 ,P_IPC_INFORMATION16 => P_IPC_INFORMATION16
842 ,P_IPC_INFORMATION17 => P_IPC_INFORMATION17
843 ,P_IPC_INFORMATION18 => P_IPC_INFORMATION18
844 ,P_IPC_INFORMATION19 => P_IPC_INFORMATION19
845 ,P_IPC_INFORMATION20 => P_IPC_INFORMATION20
846 ,P_IPC_INFORMATION21 => P_IPC_INFORMATION21
847 ,P_IPC_INFORMATION22 => P_IPC_INFORMATION22
848 ,P_IPC_INFORMATION23 => P_IPC_INFORMATION23
849 ,P_IPC_INFORMATION24 => P_IPC_INFORMATION24
850 ,P_IPC_INFORMATION25 => P_IPC_INFORMATION25
851 ,P_IPC_INFORMATION26 => P_IPC_INFORMATION26
852 ,P_IPC_INFORMATION27 => P_IPC_INFORMATION27
853 ,P_IPC_INFORMATION28 => P_IPC_INFORMATION28
854 ,P_IPC_INFORMATION29 => P_IPC_INFORMATION29
855 ,P_IPC_INFORMATION30 => P_IPC_INFORMATION30
856 ,P_DATE_APPROVED => l_date_approved
857 ,P_OBJECT_VERSION_NUMBER => l_object_version_number
858 );
859 exception
860 when hr_api.cannot_find_prog_unit then
861 hr_api.cannot_find_prog_unit_error
862 (p_module_name => 'update_posting_content'
863 ,p_hook_type => 'AP'
864 );
865 end;
866 --
867 -- When in validation only mode raise the Validate_Enabled exception
868 --
869 if p_validate then
870 raise hr_api.validate_enabled;
871 end if;
872 --
873 -- Set all output arguments
874 --
875 P_OBJECT_VERSION_NUMBER := l_object_version_number;
876 --
877 hr_utility.set_location(' Leaving:'||l_proc, 70);
878 exception
879 when hr_api.validate_enabled then
880 --
881 -- As the Validate_Enabled exception has been raised
882 -- we must rollback to the savepoint
883 --
884 rollback to update_posting_content;
885 --
886 P_OBJECT_VERSION_NUMBER := l_object_version_number;
887 -- Only set output warning arguments
888 -- (Any key or derived arguments must be set to null
889 -- when validation only mode is being used.)
890 --
891 hr_utility.set_location(' Leaving:'||l_proc, 80);
892 when others then
893 --
894 -- A validation or unexpected error has occured
895 --
896 rollback to update_posting_content;
897 -- Reset IN OUT parameters and set OUT parameters
898 P_OBJECT_VERSION_NUMBER := l_object_version_number;
899 hr_utility.set_location(' Leaving:'||l_proc, 90);
900 raise;
901 end update_posting_content;
902
903 -- ----------------------------------------------------------------------------
904 -- |--------------------------< delete_posting_content >----------------------|
905 -- ----------------------------------------------------------------------------
906 --
907 procedure delete_posting_content
908 (
909 P_VALIDATE in boolean default false
910 ,P_POSTING_CONTENT_ID in number
911 ,P_OBJECT_VERSION_NUMBER in number
912 )
913 is
914 --
915 -- Declare cursors and local variables
916 --
917 l_proc varchar2(72) := g_package||'delete_posting_content';
918 begin
919 hr_utility.set_location('Entering:'|| l_proc, 10);
920 --
921 -- Issue a savepoint
922 --
923 savepoint delete_posting_content;
924 --
925 --
926 --
927 -- Call Before Process User Hook
928 --
929 begin
930 IRC_POSTING_CONTENT_BK3.delete_posting_content_b
931 (
932 P_POSTING_CONTENT_ID => P_POSTING_CONTENT_ID
933 ,P_OBJECT_VERSION_NUMBER => P_OBJECT_VERSION_NUMBER
934 );
935 exception
936 when hr_api.cannot_find_prog_unit then
937 hr_api.cannot_find_prog_unit_error
938 (p_module_name => 'delete_posting_content'
939 ,p_hook_type => 'BP'
940 );
941 end;
942 --
943 -- Validation in addition to Row Handlers
944 --
945 irc_ipc_shd.lck
946 (P_POSTING_CONTENT_ID => P_POSTING_CONTENT_ID
947 ,P_OBJECT_VERSION_NUMBER => P_OBJECT_VERSION_NUMBER
948 );
949 --
950 irc_ipt_del.del_tl
951 (P_POSTING_CONTENT_ID => P_POSTING_CONTENT_ID
952 );
953 --
954 irc_ipc_del.del
955 (p_posting_content_id => P_POSTING_CONTENT_ID
956 ,p_object_version_number => P_OBJECT_VERSION_NUMBER
957 );
958 --
959 -- Call After Process User Hook
960 --
961 begin
962 IRC_POSTING_CONTENT_BK3.delete_posting_content_a
963 (
964 P_POSTING_CONTENT_ID => P_POSTING_CONTENT_ID
965 ,P_OBJECT_VERSION_NUMBER => P_OBJECT_VERSION_NUMBER
966 );
967 exception
968 when hr_api.cannot_find_prog_unit then
969 hr_api.cannot_find_prog_unit_error
970 (p_module_name => 'delete_posting_content'
971 ,p_hook_type => 'AP'
972 );
973 end;
974 --
975 -- When in validation only mode raise the Validate_Enabled exception
976 --
977 if p_validate then
978 raise hr_api.validate_enabled;
979 end if;
980 --
981 -- Set all output arguments
982 --
983 --
984 hr_utility.set_location(' Leaving:'||l_proc, 70);
985 exception
986 when hr_api.validate_enabled then
987 --
988 -- As the Validate_Enabled exception has been raised
989 -- we must rollback to the savepoint
990 --
991 rollback to delete_posting_content;
992 --
993 -- Only set output warning arguments
994 -- (Any key or derived arguments must be set to null
995 -- when validation only mode is being used.)
996 --
997
998 hr_utility.set_location(' Leaving:'||l_proc, 80);
999
1000 when others then
1001 --
1002 -- A validation or unexpected error has occured
1003 --
1004 rollback to delete_posting_content;
1005 hr_utility.set_location(' Leaving:'||l_proc, 90);
1006 raise;
1007 end delete_posting_content;
1008
1009 -- ----------------------------------------------------------------------------
1010 -- |----------------------< synchronize_recruiter_info >----------------------|
1011 -- ----------------------------------------------------------------------------
1012 procedure synchronize_recruiter_info is
1013 l_posting_content_ovn number;
1014
1015 cursor get_recruiter_info is
1016 select
1017 ppf.full_name
1018 , ppf.email_address
1019 , pp.phone_number
1020 , ipc.posting_content_id
1021 , ipc.object_version_number
1022 from per_all_vacancies pv
1023 , per_recruitment_activity_for RAF
1024 , per_recruitment_activities pra
1025 , irc_posting_contents ipc
1026 , irc_all_recruiting_sites iars
1027 , per_all_people_f ppf
1028 , per_phones pp
1029 where pv.vacancy_id = raf.vacancy_id
1030 and pv.status='APPROVED'
1031 and raf.recruitment_activity_id = pra.recruitment_activity_id
1032 and pra.recruiting_site_id = iars.recruiting_site_id
1033 and iars.external='Y'
1034 and pra.posting_content_id = ipc.posting_content_id
1035 and pv.recruiter_id = ppf.person_id
1036 and sysdate between ppf.effective_start_date
1037 and ppf.effective_end_date
1038 and pv.recruiter_id = pp.parent_id(+)
1039 and pp.parent_table(+)='PER_ALL_PEOPLE_F'
1040 and pp.phone_type(+)='W1'
1041 and sysdate between nvl(pp.date_from, sysdate) and nvl(pp.date_to, sysdate)
1042 and ( nvl(ipc.recruiter_full_name,'-1') <> ppf.full_name
1043 OR nvl(ipc.recruiter_email,'-1') <> nvl(ppf.email_address,'-1')
1044 OR nvl(ipc.recruiter_work_telephone,'-1') <> nvl(pp.phone_number,'-1')
1045 );
1046 cursor get_manager_info is
1047 select
1048 ppf.full_name
1049 , ppf.email_address
1050 , pp.phone_number
1051 , ipc.posting_content_id
1052 , ipc.object_version_number
1053 from per_all_vacancies pv
1054 , per_recruitment_activity_for RAF
1055 , per_recruitment_activities pra
1056 , irc_posting_contents ipc
1057 , irc_all_recruiting_sites iars
1058 , per_all_people_f ppf
1059 , per_phones pp
1060 where pv.vacancy_id = raf.vacancy_id
1061 and pv.status='APPROVED'
1062 and raf.recruitment_activity_id = pra.recruitment_activity_id
1063 and pra.recruiting_site_id = iars.recruiting_site_id
1064 and iars.external='Y'
1065 and pra.posting_content_id = ipc.posting_content_id
1066 and pv.manager_id = ppf.person_id
1067 and sysdate between ppf.effective_start_date
1068 and ppf.effective_end_date
1069 and pv.recruiter_id = pp.parent_id(+)
1070 and pp.parent_table(+)='PER_ALL_PEOPLE_F'
1071 and pp.phone_type(+)='W1'
1072 and sysdate between nvl(pp.date_from, sysdate) and nvl(pp.date_to, sysdate)
1073 and ( nvl(ipc.manager_full_name,'-1') <> ppf.full_name
1074 OR nvl(ipc.manager_email,'-1') <> nvl(ppf.email_address,'-1')
1075 OR nvl(ipc.manager_work_telephone,'-1') <> nvl(pp.phone_number,'-1')
1076 );
1077
1078 begin
1079 for l_data in get_recruiter_info loop
1080 l_posting_content_ovn := l_data.object_version_number;
1081 irc_ipc_upd.upd(p_posting_content_id => l_data.posting_content_id,
1082 p_object_version_number => l_posting_content_ovn,
1083 p_recruiter_full_name => l_data.full_name,
1084 p_recruiter_email => l_data.email_address,
1085 p_recruiter_work_telephone => l_data.phone_number
1086 );
1087 end loop;
1088 for l_data in get_manager_info loop
1089 l_posting_content_ovn := l_data.object_version_number;
1090 irc_ipc_upd.upd(p_posting_content_id => l_data.posting_content_id,
1091 p_object_version_number => l_posting_content_ovn,
1092 p_manager_full_name => l_data.full_name,
1093 p_manager_email => l_data.email_address,
1094 p_manager_work_telephone => l_data.phone_number
1095 );
1096 end loop;
1097
1098 end synchronize_recruiter_info;
1099 --
1100 end IRC_POSTING_CONTENT_API;