[Home] [Help]
PACKAGE BODY: APPS.IRC_POSTING_CONTENT_SWI
Source
1 Package Body irc_posting_content_swi As
2 /* $Header: iripcswi.pkb 120.1.12000000.4 2007/07/10 11:09:21 gaukumar noship $ */
3 --
4 -- Package variables
5 --
6 g_package varchar2(33) := 'irc_posting_content_swi.';
7 --
8 -- ----------------------------------------------------------------------------
9 -- |------------------------< create_posting_content >------------------------|
10 -- ----------------------------------------------------------------------------
11 PROCEDURE create_posting_content
12 (p_validate in number default hr_api.g_false_num
13 ,p_display_manager_info in varchar2
14 ,p_display_recruiter_info in varchar2
15 ,p_language_code in varchar2 default null
16 ,p_name in varchar2
17 ,p_org_name in varchar2 default null
18 ,p_org_description in varchar2 default null
19 ,p_job_title in varchar2 default null
20 ,p_brief_description in varchar2 default null
21 ,p_detailed_description in varchar2 default null
22 ,p_job_requirements in varchar2 default null
23 ,p_additional_details in varchar2 default null
24 ,p_how_to_apply in varchar2 default null
25 ,p_benefit_info in varchar2 default null
26 ,p_image_url in varchar2 default null
27 ,p_alt_image_url in varchar2 default null
28 ,p_attribute_category in varchar2 default null
29 ,p_attribute1 in varchar2 default null
30 ,p_attribute2 in varchar2 default null
31 ,p_attribute3 in varchar2 default null
32 ,p_attribute4 in varchar2 default null
33 ,p_attribute5 in varchar2 default null
34 ,p_attribute6 in varchar2 default null
35 ,p_attribute7 in varchar2 default null
36 ,p_attribute8 in varchar2 default null
37 ,p_attribute9 in varchar2 default null
38 ,p_attribute10 in varchar2 default null
39 ,p_attribute11 in varchar2 default null
40 ,p_attribute12 in varchar2 default null
41 ,p_attribute13 in varchar2 default null
42 ,p_attribute14 in varchar2 default null
43 ,p_attribute15 in varchar2 default null
44 ,p_attribute16 in varchar2 default null
45 ,p_attribute17 in varchar2 default null
46 ,p_attribute18 in varchar2 default null
47 ,p_attribute19 in varchar2 default null
48 ,p_attribute20 in varchar2 default null
49 ,p_attribute21 in varchar2 default null
50 ,p_attribute22 in varchar2 default null
51 ,p_attribute23 in varchar2 default null
52 ,p_attribute24 in varchar2 default null
53 ,p_attribute25 in varchar2 default null
54 ,p_attribute26 in varchar2 default null
55 ,p_attribute27 in varchar2 default null
56 ,p_attribute28 in varchar2 default null
57 ,p_attribute29 in varchar2 default null
58 ,p_attribute30 in varchar2 default null
59 ,p_ipc_information_category in varchar2 default null
60 ,p_ipc_information1 in varchar2 default null
61 ,p_ipc_information2 in varchar2 default null
62 ,p_ipc_information3 in varchar2 default null
63 ,p_ipc_information4 in varchar2 default null
64 ,p_ipc_information5 in varchar2 default null
65 ,p_ipc_information6 in varchar2 default null
66 ,p_ipc_information7 in varchar2 default null
67 ,p_ipc_information8 in varchar2 default null
68 ,p_ipc_information9 in varchar2 default null
69 ,p_ipc_information10 in varchar2 default null
70 ,p_ipc_information11 in varchar2 default null
71 ,p_ipc_information12 in varchar2 default null
72 ,p_ipc_information13 in varchar2 default null
73 ,p_ipc_information14 in varchar2 default null
74 ,p_ipc_information15 in varchar2 default null
75 ,p_ipc_information16 in varchar2 default null
76 ,p_ipc_information17 in varchar2 default null
77 ,p_ipc_information18 in varchar2 default null
78 ,p_ipc_information19 in varchar2 default null
79 ,p_ipc_information20 in varchar2 default null
80 ,p_ipc_information21 in varchar2 default null
81 ,p_ipc_information22 in varchar2 default null
82 ,p_ipc_information23 in varchar2 default null
83 ,p_ipc_information24 in varchar2 default null
84 ,p_ipc_information25 in varchar2 default null
85 ,p_ipc_information26 in varchar2 default null
86 ,p_ipc_information27 in varchar2 default null
87 ,p_ipc_information28 in varchar2 default null
88 ,p_ipc_information29 in varchar2 default null
89 ,p_ipc_information30 in varchar2 default null
90 ,p_date_approved in date default null
91 ,p_posting_content_id in number
92 ,p_object_version_number out nocopy number
93 ,p_return_status out nocopy varchar2
94 ) is
95 --
96 -- Variables for API Boolean parameters
97 l_validate boolean;
98 --
99 -- Variables for IN/OUT parameters
100 --
101 -- Other variables
102 l_posting_content_id number;
103 l_proc varchar2(72) := g_package ||'create_posting_content';
104 Begin
105 hr_utility.set_location(' Entering:' || l_proc,10);
106 --
107 -- Issue a savepoint
108 --
109 savepoint create_posting_content_swi;
110 --
111 -- Initialise Multiple Message Detection
112 --
113 hr_multi_message.enable_message_list;
114 --
115 -- Remember IN OUT parameter IN values
116 --
117 --
118 -- Convert constant values to their corresponding boolean value
119 --
120 l_validate :=
121 hr_api.constant_to_boolean
122 (p_constant_value => p_validate);
123 --
124 -- Register Surrogate ID or user key values
125 --
126 irc_ipc_ins.set_base_key_value
127 (p_posting_content_id => p_posting_content_id
128 );
129 --
130 -- Call API
131 --
132 irc_posting_content_api.create_posting_content
133 (p_validate => l_validate
134 ,p_display_manager_info => p_display_manager_info
135 ,p_display_recruiter_info => p_display_recruiter_info
136 ,p_language_code => p_language_code
137 ,p_name => p_name
138 ,p_org_name => p_org_name
139 ,p_org_description => p_org_description
140 ,p_job_title => p_job_title
141 ,p_brief_description => p_brief_description
142 ,p_detailed_description => p_detailed_description
143 ,p_job_requirements => p_job_requirements
144 ,p_additional_details => p_additional_details
145 ,p_how_to_apply => p_how_to_apply
146 ,p_benefit_info => p_benefit_info
147 ,p_image_url => p_image_url
148 ,p_alt_image_url => p_alt_image_url
149 ,p_attribute_category => p_attribute_category
150 ,p_attribute1 => p_attribute1
151 ,p_attribute2 => p_attribute2
152 ,p_attribute3 => p_attribute3
153 ,p_attribute4 => p_attribute4
154 ,p_attribute5 => p_attribute5
155 ,p_attribute6 => p_attribute6
156 ,p_attribute7 => p_attribute7
157 ,p_attribute8 => p_attribute8
158 ,p_attribute9 => p_attribute9
159 ,p_attribute10 => p_attribute10
160 ,p_attribute11 => p_attribute11
161 ,p_attribute12 => p_attribute12
162 ,p_attribute13 => p_attribute13
163 ,p_attribute14 => p_attribute14
164 ,p_attribute15 => p_attribute15
165 ,p_attribute16 => p_attribute16
166 ,p_attribute17 => p_attribute17
167 ,p_attribute18 => p_attribute18
168 ,p_attribute19 => p_attribute19
169 ,p_attribute20 => p_attribute20
170 ,p_attribute21 => p_attribute21
171 ,p_attribute22 => p_attribute22
172 ,p_attribute23 => p_attribute23
173 ,p_attribute24 => p_attribute24
174 ,p_attribute25 => p_attribute25
175 ,p_attribute26 => p_attribute26
176 ,p_attribute27 => p_attribute27
177 ,p_attribute28 => p_attribute28
178 ,p_attribute29 => p_attribute29
179 ,p_attribute30 => p_attribute30
180 ,p_ipc_information_category => p_ipc_information_category
181 ,p_ipc_information1 => p_ipc_information1
182 ,p_ipc_information2 => p_ipc_information2
183 ,p_ipc_information3 => p_ipc_information3
184 ,p_ipc_information4 => p_ipc_information4
185 ,p_ipc_information5 => p_ipc_information5
186 ,p_ipc_information6 => p_ipc_information6
187 ,p_ipc_information7 => p_ipc_information7
188 ,p_ipc_information8 => p_ipc_information8
189 ,p_ipc_information9 => p_ipc_information9
190 ,p_ipc_information10 => p_ipc_information10
191 ,p_ipc_information11 => p_ipc_information11
192 ,p_ipc_information12 => p_ipc_information12
193 ,p_ipc_information13 => p_ipc_information13
194 ,p_ipc_information14 => p_ipc_information14
195 ,p_ipc_information15 => p_ipc_information15
196 ,p_ipc_information16 => p_ipc_information16
197 ,p_ipc_information17 => p_ipc_information17
198 ,p_ipc_information18 => p_ipc_information18
199 ,p_ipc_information19 => p_ipc_information19
200 ,p_ipc_information20 => p_ipc_information20
201 ,p_ipc_information21 => p_ipc_information21
202 ,p_ipc_information22 => p_ipc_information22
203 ,p_ipc_information23 => p_ipc_information23
204 ,p_ipc_information24 => p_ipc_information24
205 ,p_ipc_information25 => p_ipc_information25
206 ,p_ipc_information26 => p_ipc_information26
207 ,p_ipc_information27 => p_ipc_information27
208 ,p_ipc_information28 => p_ipc_information28
209 ,p_ipc_information29 => p_ipc_information29
210 ,p_ipc_information30 => p_ipc_information30
211 ,p_date_approved => p_date_approved
212 ,p_posting_content_id => l_posting_content_id
213 ,p_object_version_number => p_object_version_number
214 );
215 --
216 -- Convert API warning boolean parameter values to specific
217 -- messages and add them to Multiple Message List
218 --
219 --
220 -- Convert API non-warning boolean parameter values
221 --
222 --
223 -- Derive the API return status value based on whether
224 -- messages of any type exist in the Multiple Message List.
225 -- Also disable Multiple Message Detection.
226 --
227 p_return_status := hr_multi_message.get_return_status_disable;
228 hr_utility.set_location(' Leaving:' || l_proc,20);
229 --
230 exception
231 when hr_multi_message.error_message_exist then
232 --
233 -- Catch the Multiple Message List exception which
234 -- indicates API processing has been aborted because
235 -- at least one message exists in the list.
236 --
237 rollback to create_posting_content_swi;
238 --
239 -- Reset IN OUT parameters and set OUT parameters
240 --
241 p_object_version_number := null;
242 p_return_status := hr_multi_message.get_return_status_disable;
243 hr_utility.set_location(' Leaving:' || l_proc, 30);
244 when others then
245 --
246 -- When Multiple Message Detection is enabled catch
247 -- any Application specific or other unexpected
248 -- exceptions. Adding appropriate details to the
249 -- Multiple Message List. Otherwise re-raise the
250 -- error.
251 --
252 rollback to create_posting_content_swi;
253 if hr_multi_message.unexpected_error_add(l_proc) then
254 hr_utility.set_location(' Leaving:' || l_proc,40);
255 raise;
256 end if;
257 --
258 -- Reset IN OUT and set OUT parameters
259 --
260 p_object_version_number := null;
261 p_return_status := hr_multi_message.get_return_status_disable;
262 hr_utility.set_location(' Leaving:' || l_proc,50);
263 end create_posting_content;
264 -- ----------------------------------------------------------------------------
265 -- |------------------------< delete_posting_content >------------------------|
266 -- ----------------------------------------------------------------------------
267 PROCEDURE delete_posting_content
268 (p_validate in number default hr_api.g_false_num
269 ,p_posting_content_id in number
270 ,p_object_version_number in number
271 ,p_return_status out nocopy varchar2
272 ) is
273 --
274 -- Variables for API Boolean parameters
275 l_validate boolean;
276 --
277 -- Variables for IN/OUT parameters
278 --
279 -- Other variables
280 l_proc varchar2(72) := g_package ||'delete_posting_content';
281 Begin
282 hr_utility.set_location(' Entering:' || l_proc,10);
283 --
284 -- Issue a savepoint
285 --
286 savepoint delete_posting_content_swi;
287 --
288 -- Initialise Multiple Message Detection
289 --
290 hr_multi_message.enable_message_list;
291 --
292 -- Remember IN OUT parameter IN values
293 --
294 --
295 -- Convert constant values to their corresponding boolean value
296 --
297 l_validate :=
298 hr_api.constant_to_boolean
299 (p_constant_value => p_validate);
300 --
301 -- Register Surrogate ID or user key values
302 --
303 --
304 -- Call API
305 --
306 irc_posting_content_api.delete_posting_content
307 (p_validate => l_validate
308 ,p_posting_content_id => p_posting_content_id
309 ,p_object_version_number => p_object_version_number
310 );
311 --
312 -- Convert API warning boolean parameter values to specific
313 -- messages and add them to Multiple Message List
314 --
315 --
316 -- Convert API non-warning boolean parameter values
317 --
318 --
319 -- Derive the API return status value based on whether
320 -- messages of any type exist in the Multiple Message List.
321 -- Also disable Multiple Message Detection.
322 --
323 p_return_status := hr_multi_message.get_return_status_disable;
324 hr_utility.set_location(' Leaving:' || l_proc,20);
325 --
326 exception
327 when hr_multi_message.error_message_exist then
328 --
329 -- Catch the Multiple Message List exception which
330 -- indicates API processing has been aborted because
331 -- at least one message exists in the list.
332 --
333 rollback to delete_posting_content_swi;
334 --
335 -- Reset IN OUT parameters and set OUT parameters
336 --
337 p_return_status := hr_multi_message.get_return_status_disable;
338 hr_utility.set_location(' Leaving:' || l_proc, 30);
339 when others then
340 --
341 -- When Multiple Message Detection is enabled catch
342 -- any Application specific or other unexpected
343 -- exceptions. Adding appropriate details to the
344 -- Multiple Message List. Otherwise re-raise the
345 -- error.
346 --
347 rollback to delete_posting_content_swi;
348 if hr_multi_message.unexpected_error_add(l_proc) then
352 --
349 hr_utility.set_location(' Leaving:' || l_proc,40);
350 raise;
351 end if;
353 -- Reset IN OUT and set OUT parameters
354 --
355 p_return_status := hr_multi_message.get_return_status_disable;
356 hr_utility.set_location(' Leaving:' || l_proc,50);
357 end delete_posting_content;
358 -- ----------------------------------------------------------------------------
359 -- |------------------------< update_posting_content >------------------------|
360 -- ----------------------------------------------------------------------------
361 PROCEDURE update_posting_content
362 (p_validate in number default hr_api.g_false_num
363 ,p_posting_content_id in number
364 ,p_display_manager_info in varchar2 default hr_api.g_varchar2
365 ,p_display_recruiter_info in varchar2 default hr_api.g_varchar2
366 ,p_language_code in varchar2 default hr_api.g_varchar2
367 ,p_name in varchar2 default hr_api.g_varchar2
368 ,p_org_name in varchar2 default hr_api.g_varchar2
369 ,p_org_description in varchar2 default hr_api.g_varchar2
370 ,p_job_title in varchar2 default hr_api.g_varchar2
371 ,p_brief_description in varchar2 default hr_api.g_varchar2
372 ,p_detailed_description in varchar2 default hr_api.g_varchar2
373 ,p_job_requirements in varchar2 default hr_api.g_varchar2
374 ,p_additional_details in varchar2 default hr_api.g_varchar2
375 ,p_how_to_apply in varchar2 default hr_api.g_varchar2
376 ,p_benefit_info in varchar2 default hr_api.g_varchar2
377 ,p_image_url in varchar2 default hr_api.g_varchar2
378 ,p_alt_image_url in varchar2 default hr_api.g_varchar2
379 ,p_attribute_category in varchar2 default hr_api.g_varchar2
380 ,p_attribute1 in varchar2 default hr_api.g_varchar2
381 ,p_attribute2 in varchar2 default hr_api.g_varchar2
382 ,p_attribute3 in varchar2 default hr_api.g_varchar2
383 ,p_attribute4 in varchar2 default hr_api.g_varchar2
384 ,p_attribute5 in varchar2 default hr_api.g_varchar2
385 ,p_attribute6 in varchar2 default hr_api.g_varchar2
386 ,p_attribute7 in varchar2 default hr_api.g_varchar2
387 ,p_attribute8 in varchar2 default hr_api.g_varchar2
388 ,p_attribute9 in varchar2 default hr_api.g_varchar2
389 ,p_attribute10 in varchar2 default hr_api.g_varchar2
390 ,p_attribute11 in varchar2 default hr_api.g_varchar2
391 ,p_attribute12 in varchar2 default hr_api.g_varchar2
392 ,p_attribute13 in varchar2 default hr_api.g_varchar2
393 ,p_attribute14 in varchar2 default hr_api.g_varchar2
394 ,p_attribute15 in varchar2 default hr_api.g_varchar2
395 ,p_attribute16 in varchar2 default hr_api.g_varchar2
396 ,p_attribute17 in varchar2 default hr_api.g_varchar2
397 ,p_attribute18 in varchar2 default hr_api.g_varchar2
398 ,p_attribute19 in varchar2 default hr_api.g_varchar2
399 ,p_attribute20 in varchar2 default hr_api.g_varchar2
400 ,p_attribute21 in varchar2 default hr_api.g_varchar2
401 ,p_attribute22 in varchar2 default hr_api.g_varchar2
402 ,p_attribute23 in varchar2 default hr_api.g_varchar2
403 ,p_attribute24 in varchar2 default hr_api.g_varchar2
404 ,p_attribute25 in varchar2 default hr_api.g_varchar2
405 ,p_attribute26 in varchar2 default hr_api.g_varchar2
406 ,p_attribute27 in varchar2 default hr_api.g_varchar2
407 ,p_attribute28 in varchar2 default hr_api.g_varchar2
408 ,p_attribute29 in varchar2 default hr_api.g_varchar2
409 ,p_attribute30 in varchar2 default hr_api.g_varchar2
410 ,p_ipc_information_category in varchar2 default hr_api.g_varchar2
411 ,p_ipc_information1 in varchar2 default hr_api.g_varchar2
412 ,p_ipc_information2 in varchar2 default hr_api.g_varchar2
413 ,p_ipc_information3 in varchar2 default hr_api.g_varchar2
414 ,p_ipc_information4 in varchar2 default hr_api.g_varchar2
415 ,p_ipc_information5 in varchar2 default hr_api.g_varchar2
416 ,p_ipc_information6 in varchar2 default hr_api.g_varchar2
417 ,p_ipc_information7 in varchar2 default hr_api.g_varchar2
418 ,p_ipc_information8 in varchar2 default hr_api.g_varchar2
419 ,p_ipc_information9 in varchar2 default hr_api.g_varchar2
420 ,p_ipc_information10 in varchar2 default hr_api.g_varchar2
421 ,p_ipc_information11 in varchar2 default hr_api.g_varchar2
422 ,p_ipc_information12 in varchar2 default hr_api.g_varchar2
423 ,p_ipc_information13 in varchar2 default hr_api.g_varchar2
424 ,p_ipc_information14 in varchar2 default hr_api.g_varchar2
425 ,p_ipc_information15 in varchar2 default hr_api.g_varchar2
426 ,p_ipc_information16 in varchar2 default hr_api.g_varchar2
427 ,p_ipc_information17 in varchar2 default hr_api.g_varchar2
431 ,p_ipc_information21 in varchar2 default hr_api.g_varchar2
428 ,p_ipc_information18 in varchar2 default hr_api.g_varchar2
429 ,p_ipc_information19 in varchar2 default hr_api.g_varchar2
430 ,p_ipc_information20 in varchar2 default hr_api.g_varchar2
432 ,p_ipc_information22 in varchar2 default hr_api.g_varchar2
433 ,p_ipc_information23 in varchar2 default hr_api.g_varchar2
434 ,p_ipc_information24 in varchar2 default hr_api.g_varchar2
435 ,p_ipc_information25 in varchar2 default hr_api.g_varchar2
436 ,p_ipc_information26 in varchar2 default hr_api.g_varchar2
437 ,p_ipc_information27 in varchar2 default hr_api.g_varchar2
438 ,p_ipc_information28 in varchar2 default hr_api.g_varchar2
439 ,p_ipc_information29 in varchar2 default hr_api.g_varchar2
440 ,p_ipc_information30 in varchar2 default hr_api.g_varchar2
441 ,p_date_approved in date default hr_api.g_date
442 ,p_object_version_number in out nocopy number
443 ,p_return_status out nocopy varchar2
444 ) is
445 --
446 -- Variables for API Boolean parameters
447 l_validate boolean;
448 --
449 -- Variables for IN/OUT parameters
450 l_object_version_number number;
451 --
452 -- Other variables
453 l_proc varchar2(72) := g_package ||'update_posting_content';
454 Begin
455 hr_utility.set_location(' Entering:' || l_proc,10);
456 --
457 -- Issue a savepoint
458 --
459 savepoint update_posting_content_swi;
460 --
461 -- Initialise Multiple Message Detection
462 --
463 hr_multi_message.enable_message_list;
464 --
465 -- Remember IN OUT parameter IN values
466 --
467 l_object_version_number := p_object_version_number;
468 --
469 -- Convert constant values to their corresponding boolean value
470 --
471 l_validate :=
472 hr_api.constant_to_boolean
473 (p_constant_value => p_validate);
474 --
475 -- Register Surrogate ID or user key values
476 --
477 --
478 -- Call API
479 --
480 irc_posting_content_api.update_posting_content
481 (p_validate => l_validate
482 ,p_posting_content_id => p_posting_content_id
483 ,p_display_manager_info => p_display_manager_info
484 ,p_display_recruiter_info => p_display_recruiter_info
485 ,p_language_code => p_language_code
486 ,p_name => p_name
487 ,p_org_name => p_org_name
488 ,p_org_description => p_org_description
489 ,p_job_title => p_job_title
490 ,p_brief_description => p_brief_description
491 ,p_detailed_description => p_detailed_description
492 ,p_job_requirements => p_job_requirements
493 ,p_additional_details => p_additional_details
494 ,p_how_to_apply => p_how_to_apply
495 ,p_benefit_info => p_benefit_info
496 ,p_image_url => p_image_url
497 ,p_alt_image_url => p_alt_image_url
498 ,p_attribute_category => p_attribute_category
499 ,p_attribute1 => p_attribute1
500 ,p_attribute2 => p_attribute2
501 ,p_attribute3 => p_attribute3
502 ,p_attribute4 => p_attribute4
503 ,p_attribute5 => p_attribute5
504 ,p_attribute6 => p_attribute6
505 ,p_attribute7 => p_attribute7
506 ,p_attribute8 => p_attribute8
507 ,p_attribute9 => p_attribute9
508 ,p_attribute10 => p_attribute10
509 ,p_attribute11 => p_attribute11
510 ,p_attribute12 => p_attribute12
511 ,p_attribute13 => p_attribute13
512 ,p_attribute14 => p_attribute14
513 ,p_attribute15 => p_attribute15
514 ,p_attribute16 => p_attribute16
515 ,p_attribute17 => p_attribute17
516 ,p_attribute18 => p_attribute18
517 ,p_attribute19 => p_attribute19
518 ,p_attribute20 => p_attribute20
519 ,p_attribute21 => p_attribute21
520 ,p_attribute22 => p_attribute22
521 ,p_attribute23 => p_attribute23
522 ,p_attribute24 => p_attribute24
523 ,p_attribute25 => p_attribute25
524 ,p_attribute26 => p_attribute26
525 ,p_attribute27 => p_attribute27
526 ,p_attribute28 => p_attribute28
527 ,p_attribute29 => p_attribute29
528 ,p_attribute30 => p_attribute30
529 ,p_ipc_information_category => p_ipc_information_category
530 ,p_ipc_information1 => p_ipc_information1
531 ,p_ipc_information2 => p_ipc_information2
532 ,p_ipc_information3 => p_ipc_information3
533 ,p_ipc_information4 => p_ipc_information4
534 ,p_ipc_information5 => p_ipc_information5
535 ,p_ipc_information6 => p_ipc_information6
536 ,p_ipc_information7 => p_ipc_information7
537 ,p_ipc_information8 => p_ipc_information8
538 ,p_ipc_information9 => p_ipc_information9
542 ,p_ipc_information13 => p_ipc_information13
539 ,p_ipc_information10 => p_ipc_information10
540 ,p_ipc_information11 => p_ipc_information11
541 ,p_ipc_information12 => p_ipc_information12
543 ,p_ipc_information14 => p_ipc_information14
544 ,p_ipc_information15 => p_ipc_information15
545 ,p_ipc_information16 => p_ipc_information16
546 ,p_ipc_information17 => p_ipc_information17
547 ,p_ipc_information18 => p_ipc_information18
548 ,p_ipc_information19 => p_ipc_information19
549 ,p_ipc_information20 => p_ipc_information20
550 ,p_ipc_information21 => p_ipc_information21
551 ,p_ipc_information22 => p_ipc_information22
552 ,p_ipc_information23 => p_ipc_information23
553 ,p_ipc_information24 => p_ipc_information24
554 ,p_ipc_information25 => p_ipc_information25
555 ,p_ipc_information26 => p_ipc_information26
556 ,p_ipc_information27 => p_ipc_information27
557 ,p_ipc_information28 => p_ipc_information28
558 ,p_ipc_information29 => p_ipc_information29
559 ,p_ipc_information30 => p_ipc_information30
560 ,p_date_approved => p_date_approved
561 ,p_object_version_number => p_object_version_number
562 );
563 --
564 -- Convert API warning boolean parameter values to specific
565 -- messages and add them to Multiple Message List
566 --
567 --
568 -- Convert API non-warning boolean parameter values
569 --
570 --
571 -- Derive the API return status value based on whether
572 -- messages of any type exist in the Multiple Message List.
573 -- Also disable Multiple Message Detection.
574 --
575 p_return_status := hr_multi_message.get_return_status_disable;
576 hr_utility.set_location(' Leaving:' || l_proc,20);
577 --
578 exception
579 when hr_multi_message.error_message_exist then
580 --
581 -- Catch the Multiple Message List exception which
582 -- indicates API processing has been aborted because
583 -- at least one message exists in the list.
584 --
585 rollback to update_posting_content_swi;
586 --
587 -- Reset IN OUT parameters and set OUT parameters
588 --
589 p_object_version_number := l_object_version_number;
590 p_return_status := hr_multi_message.get_return_status_disable;
591 hr_utility.set_location(' Leaving:' || l_proc, 30);
592 when others then
593 --
594 -- When Multiple Message Detection is enabled catch
595 -- any Application specific or other unexpected
596 -- exceptions. Adding appropriate details to the
597 -- Multiple Message List. Otherwise re-raise the
598 -- error.
599 --
600 rollback to update_posting_content_swi;
601 if hr_multi_message.unexpected_error_add(l_proc) then
602 hr_utility.set_location(' Leaving:' || l_proc,40);
603 raise;
604 end if;
605 --
606 -- Reset IN OUT and set OUT parameters
607 --
608 p_object_version_number := l_object_version_number;
609 p_return_status := hr_multi_message.get_return_status_disable;
610 hr_utility.set_location(' Leaving:' || l_proc,50);
611 end update_posting_content;
612
613 -- ----------------------------------------------------------------------------
614 -- |----------------------------< process_api >-------------------------------|
615 -- ----------------------------------------------------------------------------
616
617 procedure process_api
618 (
619 p_document in CLOB
620 ,p_return_status out nocopy VARCHAR2
621 ,p_validate in number default hr_api.g_false_num
622 ,p_effective_date in date default null
623 )
624 IS
625 l_postState VARCHAR2(2);
626 l_return_status VARCHAR2(1);
627 l_object_version_number number;
628 l_posting_content_id number;
629 l_commitElement xmldom.DOMElement;
630 l_parser xmlparser.Parser;
631 l_CommitNode xmldom.DOMNode;
632
633 l_proc varchar2(72) := g_package || 'process_api';
634 l_effective_date date := trunc(sysdate);
635
636 BEGIN
637 --
638 hr_utility.set_location(' Entering:' || l_proc,10);
639 hr_utility.set_location(' CLOB --> xmldom.DOMNode:' || l_proc,15);
640 --
641 l_parser := xmlparser.newParser;
642 xmlparser.ParseCLOB(l_parser,p_document);
643 l_CommitNode := xmldom.makeNode(xmldom.getDocumentElement(xmlparser.getDocument(l_parser)));
644 --
645 hr_utility.set_location('Extracting the PostState:' || l_proc,20);
646
647 l_commitElement := xmldom.makeElement(l_CommitNode);
648 l_postState := xmldom.getAttribute(l_commitElement, 'PS');
649 --
650 --Get the values for in/out parameters
651 --
652 l_object_version_number := hr_transaction_swi.getNumberValue(l_CommitNode,'ObjectVersionNumber');
653 l_posting_content_id := hr_transaction_swi.getNumberValue(l_CommitNode,'PostingContentId');
654 --
655 if p_effective_date is null then
656 l_effective_date := trunc(sysdate);
657 else
658 l_effective_date := p_effective_date;
659 end if;
663 hr_utility.set_location('creating :' || l_proc,30);
660 --
661 if l_postState = '0' then
662 --
664 --
665 create_posting_content
666 (p_validate => p_validate
667 ,p_display_manager_info => hr_transaction_swi.getVarchar2Value(l_CommitNode,'DisplayManagerInfo',NULL)
668 ,p_display_recruiter_info => hr_transaction_swi.getVarchar2Value(l_CommitNode,'DisplayRecruiterInfo',NULL)
669 ,p_language_code => hr_transaction_swi.getVarchar2Value(l_CommitNode,'LanguageCode',NULL)
670 ,p_name => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Name',NULL)
671 ,p_org_name => getClobValue(l_CommitNode,'OrgName',NULL)
672 ,p_org_description => getClobValue(l_CommitNode,'OrgDescription',NULL)
673 ,p_job_title => getClobValue(l_CommitNode,'JobTitle',NULL)
674 ,p_brief_description => getClobValue(l_CommitNode,'BriefDescription',NULL)
675 ,p_detailed_description => getClobValue(l_CommitNode,'DetailedDescription',NULL)
676 ,p_job_requirements => getClobValue(l_CommitNode,'JobRequirements',NULL)
677 ,p_additional_details => getClobValue(l_CommitNode,'AdditionalDetails',NULL)
678 ,p_how_to_apply => getClobValue(l_CommitNode,'HowToApply',NULL)
679 ,p_benefit_info => getClobValue(l_CommitNode,'BenefitInfo',NULL)
680 ,p_image_url => getClobValue(l_CommitNode,'ImageUrl',NULL)
681 ,p_alt_image_url => getClobValue(l_CommitNode,'AltImageUrl',NULL)
682 ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory',NULL)
683 ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1',NULL)
684 ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2',NULL)
685 ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3',NULL)
686 ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4',NULL)
687 ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5',NULL)
688 ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6',NULL)
689 ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7',NULL)
690 ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8',NULL)
691 ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9',NULL)
692 ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10',NULL)
693 ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11',NULL)
694 ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12',NULL)
695 ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13',NULL)
696 ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14',NULL)
697 ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15',NULL)
698 ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16',NULL)
699 ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17',NULL)
700 ,p_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18',NULL)
701 ,p_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute19',NULL)
702 ,p_attribute20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute20',NULL)
703 ,p_attribute21 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute21',NULL)
704 ,p_attribute22 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute22',NULL)
705 ,p_attribute23 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute23',NULL)
706 ,p_attribute24 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute24',NULL)
707 ,p_attribute25 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute25',NULL)
708 ,p_attribute26 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute26',NULL)
709 ,p_attribute27 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute27',NULL)
710 ,p_attribute28 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute28',NULL)
711 ,p_attribute29 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute29',NULL)
712 ,p_attribute30 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute30',NULL)
713 ,p_ipc_information_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'IpcInformationCategory',NULL)
714 ,p_ipc_information1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'IpcInformation1',NULL)
715 ,p_ipc_information2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'IpcInformation2',NULL)
716 ,p_ipc_information3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'IpcInformation3',NULL)
717 ,p_ipc_information4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'IpcInformation4',NULL)
718 ,p_ipc_information5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'IpcInformation5',NULL)
719 ,p_ipc_information6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'IpcInformation6',NULL)
720 ,p_ipc_information7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'IpcInformation7',NULL)
721 ,p_ipc_information8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'IpcInformation8',NULL)
725 ,p_ipc_information12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'IpcInformation12',NULL)
722 ,p_ipc_information9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'IpcInformation9',NULL)
723 ,p_ipc_information10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'IpcInformation10',NULL)
724 ,p_ipc_information11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'IpcInformation11',NULL)
726 ,p_ipc_information13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'IpcInformation13',NULL)
727 ,p_ipc_information14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'IpcInformation14',NULL)
728 ,p_ipc_information15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'IpcInformation15',NULL)
729 ,p_ipc_information16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'IpcInformation16',NULL)
730 ,p_ipc_information17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'IpcInformation17',NULL)
731 ,p_ipc_information18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'IpcInformation18',NULL)
732 ,p_ipc_information19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'IpcInformation19',NULL)
733 ,p_ipc_information20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'IpcInformation20',NULL)
734 ,p_ipc_information21 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'IpcInformation21',NULL)
735 ,p_ipc_information22 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'IpcInformation22',NULL)
736 ,p_ipc_information23 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'IpcInformation23',NULL)
737 ,p_ipc_information24 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'IpcInformation24',NULL)
738 ,p_ipc_information25 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'IpcInformation25',NULL)
739 ,p_ipc_information26 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'IpcInformation26',NULL)
740 ,p_ipc_information27 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'IpcInformation27',NULL)
741 ,p_ipc_information28 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'IpcInformation28',NULL)
742 ,p_ipc_information29 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'IpcInformation29',NULL)
743 ,p_ipc_information30 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'IpcInformation30',NULL)
744 ,p_date_approved => hr_transaction_swi.getDateValue(l_CommitNode,'DateApproved',NULL)
745 ,p_posting_content_id => l_posting_content_id
746 ,p_object_version_number => l_object_version_number
747 ,p_return_status => l_return_status
748 );
749 --
750 elsif l_postState = '2' then
751 --
752 hr_utility.set_location('updating :' || l_proc,32);
753 --
754 update_posting_content
755 (p_validate => p_validate
756 ,p_posting_content_id => l_posting_content_id
757 ,p_display_manager_info => 'Y'
758 ,p_display_recruiter_info => 'Y'
759 -- ,p_display_manager_info => hr_transaction_swi.getVarchar2Value(l_CommitNode,'DisplayManagerInfo',NULL)
760 -- ,p_display_recruiter_info => hr_transaction_swi.getVarchar2Value(l_CommitNode,'DisplayRecruiterInfo',NULL)
761 ,p_language_code => hr_transaction_swi.getVarchar2Value(l_CommitNode,'LanguageCode',NULL)
762 ,p_name => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Name',NULL)
763 ,p_org_name => getClobValue(l_CommitNode,'OrgName',NULL)
764 ,p_org_description => getClobValue(l_CommitNode,'OrgDescription',NULL)
765 ,p_job_title => getClobValue(l_CommitNode,'JobTitle',NULL)
766 ,p_brief_description => getClobValue(l_CommitNode,'BriefDescription',NULL)
767 ,p_detailed_description => getClobValue(l_CommitNode,'DetailedDescription',NULL)
768 ,p_job_requirements => getClobValue(l_CommitNode,'JobRequirements',NULL)
769 ,p_additional_details => getClobValue(l_CommitNode,'AdditionalDetails',NULL)
770 ,p_how_to_apply => getClobValue(l_CommitNode,'HowToApply',NULL)
771 ,p_benefit_info => getClobValue(l_CommitNode,'BenefitInfo',NULL)
772 ,p_image_url => getClobValue(l_CommitNode,'ImageUrl',NULL)
773 ,p_alt_image_url => getClobValue(l_CommitNode,'AltImageUrl',NULL)
774 ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory',NULL)
775 ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1',NULL)
776 ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2',NULL)
777 ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3',NULL)
778 ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4',NULL)
779 ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5',NULL)
780 ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6',NULL)
781 ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7',NULL)
782 ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8',NULL)
783 ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9',NULL)
784 ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10',NULL)
785 ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11',NULL)
786 ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12',NULL)
790 ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16',NULL)
787 ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13',NULL)
788 ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14',NULL)
789 ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15',NULL)
791 ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17',NULL)
792 ,p_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18',NULL)
793 ,p_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute19',NULL)
794 ,p_attribute20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute20',NULL)
795 ,p_attribute21 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute21',NULL)
796 ,p_attribute22 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute22',NULL)
797 ,p_attribute23 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute23',NULL)
798 ,p_attribute24 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute24',NULL)
799 ,p_attribute25 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute25',NULL)
800 ,p_attribute26 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute26',NULL)
801 ,p_attribute27 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute27',NULL)
802 ,p_attribute28 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute28',NULL)
803 ,p_attribute29 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute29',NULL)
804 ,p_attribute30 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute30',NULL)
805 ,p_ipc_information_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'IpcInformationCategory',NULL)
806 ,p_ipc_information1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'IpcInformation1',NULL)
807 ,p_ipc_information2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'IpcInformation2',NULL)
808 ,p_ipc_information3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'IpcInformation3',NULL)
809 ,p_ipc_information4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'IpcInformation4',NULL)
810 ,p_ipc_information5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'IpcInformation5',NULL)
811 ,p_ipc_information6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'IpcInformation6',NULL)
812 ,p_ipc_information7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'IpcInformation7',NULL)
813 ,p_ipc_information8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'IpcInformation8',NULL)
814 ,p_ipc_information9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'IpcInformation9',NULL)
815 ,p_ipc_information10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'IpcInformation10',NULL)
819 ,p_ipc_information14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'IpcInformation14',NULL)
816 ,p_ipc_information11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'IpcInformation11',NULL)
817 ,p_ipc_information12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'IpcInformation12',NULL)
818 ,p_ipc_information13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'IpcInformation13',NULL)
820 ,p_ipc_information15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'IpcInformation15',NULL)
821 ,p_ipc_information16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'IpcInformation16',NULL)
822 ,p_ipc_information17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'IpcInformation17',NULL)
823 ,p_ipc_information18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'IpcInformation18',NULL)
824 ,p_ipc_information19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'IpcInformation19',NULL)
825 ,p_ipc_information20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'IpcInformation20',NULL)
826 ,p_ipc_information21 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'IpcInformation21',NULL)
827 ,p_ipc_information22 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'IpcInformation22',NULL)
828 ,p_ipc_information23 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'IpcInformation23',NULL)
829 ,p_ipc_information24 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'IpcInformation24',NULL)
830 ,p_ipc_information25 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'IpcInformation25',NULL)
831 ,p_ipc_information26 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'IpcInformation26',NULL)
832 ,p_ipc_information27 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'IpcInformation27',NULL)
833 ,p_ipc_information28 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'IpcInformation28',NULL)
834 ,p_ipc_information29 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'IpcInformation29',NULL)
835 ,p_ipc_information30 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'IpcInformation30',NULL)
836 ,p_date_approved => hr_transaction_swi.getDateValue(l_CommitNode,'DateApproved',NULL)
837 ,p_object_version_number => l_object_version_number
838 ,p_return_status => l_return_status
839 );
840 --
841 elsif l_postState = '3' then
842 --
843 hr_utility.set_location('deleting :' || l_proc,33);
844 --
845 delete_posting_content
846 (p_validate => p_validate
847 ,p_object_version_number => l_object_version_number
848 ,p_posting_content_id => l_posting_content_id
849 ,p_return_status => l_return_status
850 );
851 --
852 end if;
853 p_return_status := l_return_status;
854
855 hr_utility.set_location
856 ('Exiting :'|| l_proc || ': return status :'|| l_return_status || ':',40);
857
858 end process_api;
859
860 Function getClobValue(
861 commitNode in xmldom.DOMNode,
862 attributeName in VARCHAR2,
863 gmisc_value in varchar2 default hr_api.g_varchar2)
864 return varchar2 IS
865 l_varchar2 VARCHAR2(32767);
866 l_isNull VARCHAR2(10);
867 l_element xmldom.DOMElement;
868 l_proc varchar2(72) := g_package || 'getVarchar2Value';
869 Begin
870 hr_utility.set_location(' Entering:' || l_proc,10);
871 xslprocessor.valueof(commitNode,attributeName,l_varchar2);
872 l_element := xmldom.makeElement(commitNode);
873 l_isNull := xmldom.getAttribute(l_element, 'null');
874 if l_isNull = 'true' then
875 l_varchar2 := NULL;
876 else
877 l_varchar2 := NVL(l_varchar2, gmisc_value);
878 end if;
879 hr_utility.set_location(' Exiting :' || l_proc,15);
880 return l_varchar2;
881 End getClobValue;
882
883
884 end irc_posting_content_swi;