[Home] [Help]
PACKAGE BODY: APPS.IRC_DEFAULT_POSTING_API
Source
1 Package Body irc_default_posting_api as
2 /* $Header: iridpapi.pkb 120.0 2005/07/26 15:06:35 mbocutt noship $ */
3 --
4 -- Package Variables
5 --
6 g_package varchar2(33) := ' irc_default_posting_api.';
7 --
8 -- ----------------------------------------------------------------------------
9 -- |------------------------< create_default_posting >------------------------|
10 -- ----------------------------------------------------------------------------
11 --
12 procedure create_default_posting
13 (P_VALIDATE IN BOOLEAN default FALSE
14 ,P_LANGUAGE_CODE IN VARCHAR2 default hr_api.userenv_lang
15 ,P_POSITION_ID IN NUMBER default NULL
16 ,P_JOB_ID IN NUMBER default NULL
17 ,P_ORGANIZATION_ID IN NUMBER default NULL
18 ,P_ORG_NAME IN VARCHAR2 default NULL
19 ,P_ORG_DESCRIPTION IN VARCHAR2 default NULL
20 ,P_JOB_TITLE IN VARCHAR2 default NULL
21 ,P_BRIEF_DESCRIPTION IN VARCHAR2 default NULL
22 ,P_DETAILED_DESCRIPTION IN VARCHAR2 default NULL
23 ,P_JOB_REQUIREMENTS IN VARCHAR2 default NULL
24 ,P_ADDITIONAL_DETAILS IN VARCHAR2 default NULL
25 ,P_HOW_TO_APPLY IN VARCHAR2 default NULL
26 ,P_IMAGE_URL IN VARCHAR2 default NULL
27 ,P_IMAGE_URL_ALT 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_DEFAULT_POSTING_ID OUT NOCOPY NUMBER
60 ,P_OBJECT_VERSION_NUMBER OUT NOCOPY NUMBER
61 ) is
62
63 --
64 -- Declare cursors and local variables
65 --
66
67 l_proc varchar2(72) := g_package||'create_default_posting';
68 l_object_version_number number;
69 l_language_code varchar2(30);
70 --
71 begin
72 hr_utility.set_location('Entering:'|| l_proc, 10);
73 --
74 -- Issue a savepoint
75 --
76 savepoint create_default_posting;
77 --
78 l_language_code:=p_language_code;
79 hr_api.validate_language_code(p_language_code => l_language_code);
80 --
81 -- Call Before Process User Hook
82 --
83 begin
84 irc_default_posting_bk1.create_default_posting_b
85 (P_POSITION_ID => P_POSITION_ID
86 ,P_JOB_ID => P_JOB_ID
87 ,P_ORGANIZATION_ID => P_ORGANIZATION_ID
88 ,P_LANGUAGE_CODE => L_LANGUAGE_CODE
89 ,P_ORG_NAME => P_ORG_NAME
90 ,P_ORG_DESCRIPTION => P_ORG_DESCRIPTION
91 ,P_JOB_TITLE => P_JOB_TITLE
92 ,P_BRIEF_DESCRIPTION => P_BRIEF_DESCRIPTION
93 ,P_DETAILED_DESCRIPTION => P_DETAILED_DESCRIPTION
94 ,P_JOB_REQUIREMENTS => P_JOB_REQUIREMENTS
95 ,P_ADDITIONAL_DETAILS => P_ADDITIONAL_DETAILS
96 ,P_HOW_TO_APPLY => P_HOW_TO_APPLY
97 ,P_IMAGE_URL => P_IMAGE_URL
98 ,P_IMAGE_URL_ALT => P_IMAGE_URL_ALT
99 ,P_ATTRIBUTE_CATEGORY => P_ATTRIBUTE_CATEGORY
100 ,P_ATTRIBUTE1 => P_ATTRIBUTE1
101 ,P_ATTRIBUTE2 => P_ATTRIBUTE2
102 ,P_ATTRIBUTE3 => P_ATTRIBUTE3
103 ,P_ATTRIBUTE4 => P_ATTRIBUTE4
104 ,P_ATTRIBUTE5 => P_ATTRIBUTE5
105 ,P_ATTRIBUTE6 => P_ATTRIBUTE6
106 ,P_ATTRIBUTE7 => P_ATTRIBUTE7
107 ,P_ATTRIBUTE8 => P_ATTRIBUTE8
108 ,P_ATTRIBUTE9 => P_ATTRIBUTE9
109 ,P_ATTRIBUTE10 => P_ATTRIBUTE10
110 ,P_ATTRIBUTE11 => P_ATTRIBUTE11
111 ,P_ATTRIBUTE12 => P_ATTRIBUTE12
112 ,P_ATTRIBUTE13 => P_ATTRIBUTE13
113 ,P_ATTRIBUTE14 => P_ATTRIBUTE14
114 ,P_ATTRIBUTE15 => P_ATTRIBUTE15
115 ,P_ATTRIBUTE16 => P_ATTRIBUTE16
116 ,P_ATTRIBUTE17 => P_ATTRIBUTE17
117 ,P_ATTRIBUTE18 => P_ATTRIBUTE18
118 ,P_ATTRIBUTE19 => P_ATTRIBUTE19
119 ,P_ATTRIBUTE20 => P_ATTRIBUTE20
120 ,P_ATTRIBUTE21 => P_ATTRIBUTE21
121 ,P_ATTRIBUTE22 => P_ATTRIBUTE22
122 ,P_ATTRIBUTE23 => P_ATTRIBUTE23
123 ,P_ATTRIBUTE24 => P_ATTRIBUTE24
124 ,P_ATTRIBUTE25 => P_ATTRIBUTE25
125 ,P_ATTRIBUTE26 => P_ATTRIBUTE26
126 ,P_ATTRIBUTE27 => P_ATTRIBUTE27
127 ,P_ATTRIBUTE28 => P_ATTRIBUTE28
128 ,P_ATTRIBUTE29 => P_ATTRIBUTE29
129 ,P_ATTRIBUTE30 => P_ATTRIBUTE30
130 );
131 exception
132 when hr_api.cannot_find_prog_unit then
133 hr_api.cannot_find_prog_unit_error
134 (p_module_name => 'create_default_posting'
135 ,p_hook_type => 'BP'
136 );
137 end;
138
139 --
140 -- Process Logic
141 --
142
143 irc_idp_ins.ins
144 (P_POSITION_ID => P_POSITION_ID
145 ,P_JOB_ID => P_JOB_ID
146 ,P_ORGANIZATION_ID => P_ORGANIZATION_ID
147 ,P_ATTRIBUTE_CATEGORY => P_ATTRIBUTE_CATEGORY
148 ,P_ATTRIBUTE1 => P_ATTRIBUTE1
149 ,P_ATTRIBUTE2 => P_ATTRIBUTE2
150 ,P_ATTRIBUTE3 => P_ATTRIBUTE3
151 ,P_ATTRIBUTE4 => P_ATTRIBUTE4
152 ,P_ATTRIBUTE5 => P_ATTRIBUTE5
153 ,P_ATTRIBUTE6 => P_ATTRIBUTE6
154 ,P_ATTRIBUTE7 => P_ATTRIBUTE7
155 ,P_ATTRIBUTE8 => P_ATTRIBUTE8
159 ,P_ATTRIBUTE12 => P_ATTRIBUTE12
156 ,P_ATTRIBUTE9 => P_ATTRIBUTE9
157 ,P_ATTRIBUTE10 => P_ATTRIBUTE10
158 ,P_ATTRIBUTE11 => P_ATTRIBUTE11
160 ,P_ATTRIBUTE13 => P_ATTRIBUTE13
161 ,P_ATTRIBUTE14 => P_ATTRIBUTE14
162 ,P_ATTRIBUTE15 => P_ATTRIBUTE15
163 ,P_ATTRIBUTE16 => P_ATTRIBUTE16
164 ,P_ATTRIBUTE17 => P_ATTRIBUTE17
165 ,P_ATTRIBUTE18 => P_ATTRIBUTE18
166 ,P_ATTRIBUTE19 => P_ATTRIBUTE19
167 ,P_ATTRIBUTE20 => P_ATTRIBUTE20
168 ,P_ATTRIBUTE21 => P_ATTRIBUTE21
169 ,P_ATTRIBUTE22 => P_ATTRIBUTE22
170 ,P_ATTRIBUTE23 => P_ATTRIBUTE23
171 ,P_ATTRIBUTE24 => P_ATTRIBUTE24
172 ,P_ATTRIBUTE25 => P_ATTRIBUTE25
173 ,P_ATTRIBUTE26 => P_ATTRIBUTE26
174 ,P_ATTRIBUTE27 => P_ATTRIBUTE27
175 ,P_ATTRIBUTE28 => P_ATTRIBUTE28
176 ,P_ATTRIBUTE29 => P_ATTRIBUTE29
177 ,P_ATTRIBUTE30 => P_ATTRIBUTE30
178 ,P_DEFAULT_POSTING_ID => P_DEFAULT_POSTING_ID
179 ,P_OBJECT_VERSION_NUMBER => L_OBJECT_VERSION_NUMBER);
180
181 --
182 -- Process Translation Logic
183 --
184
185 irc_idt_ins.ins_tl
186 (P_DEFAULT_POSTING_ID => P_DEFAULT_POSTING_ID
187 ,P_LANGUAGE_CODE => L_LANGUAGE_CODE
188 ,P_ORG_NAME => P_ORG_NAME
189 ,P_ORG_DESCRIPTION => P_ORG_DESCRIPTION
190 ,P_JOB_TITLE => P_JOB_TITLE
191 ,P_BRIEF_DESCRIPTION => P_BRIEF_DESCRIPTION
192 ,P_DETAILED_DESCRIPTION => P_DETAILED_DESCRIPTION
193 ,P_JOB_REQUIREMENTS => P_JOB_REQUIREMENTS
194 ,P_ADDITIONAL_DETAILS => P_ADDITIONAL_DETAILS
195 ,P_HOW_TO_APPLY => P_HOW_TO_APPLY
196 ,P_IMAGE_URL => P_IMAGE_URL
197 ,P_IMAGE_URL_ALT => P_IMAGE_URL_ALT);
198 --
199 -- Call After Process User Hook
200 --
201 begin
202 irc_default_posting_bk1.create_default_posting_a
203 (P_POSITION_ID => P_POSITION_ID
204 ,P_JOB_ID => P_JOB_ID
205 ,P_ORGANIZATION_ID => P_ORGANIZATION_ID
206 ,P_LANGUAGE_CODE => L_LANGUAGE_CODE
207 ,P_ORG_NAME => P_ORG_NAME
208 ,P_ORG_DESCRIPTION => P_ORG_DESCRIPTION
209 ,P_JOB_TITLE => P_JOB_TITLE
210 ,P_BRIEF_DESCRIPTION => P_BRIEF_DESCRIPTION
211 ,P_DETAILED_DESCRIPTION => P_DETAILED_DESCRIPTION
212 ,P_JOB_REQUIREMENTS => P_JOB_REQUIREMENTS
213 ,P_ADDITIONAL_DETAILS => P_ADDITIONAL_DETAILS
214 ,P_HOW_TO_APPLY => P_HOW_TO_APPLY
215 ,P_IMAGE_URL => P_IMAGE_URL
216 ,P_IMAGE_URL_ALT => P_IMAGE_URL_ALT
217 ,P_ATTRIBUTE_CATEGORY => P_ATTRIBUTE_CATEGORY
218 ,P_ATTRIBUTE1 => P_ATTRIBUTE1
219 ,P_ATTRIBUTE2 => P_ATTRIBUTE2
220 ,P_ATTRIBUTE3 => P_ATTRIBUTE3
221 ,P_ATTRIBUTE4 => P_ATTRIBUTE4
222 ,P_ATTRIBUTE5 => P_ATTRIBUTE5
223 ,P_ATTRIBUTE6 => P_ATTRIBUTE6
224 ,P_ATTRIBUTE7 => P_ATTRIBUTE7
225 ,P_ATTRIBUTE8 => P_ATTRIBUTE8
226 ,P_ATTRIBUTE9 => P_ATTRIBUTE9
227 ,P_ATTRIBUTE10 => P_ATTRIBUTE10
228 ,P_ATTRIBUTE11 => P_ATTRIBUTE11
229 ,P_ATTRIBUTE12 => P_ATTRIBUTE12
230 ,P_ATTRIBUTE13 => P_ATTRIBUTE13
231 ,P_ATTRIBUTE14 => P_ATTRIBUTE14
232 ,P_ATTRIBUTE15 => P_ATTRIBUTE15
233 ,P_ATTRIBUTE16 => P_ATTRIBUTE16
234 ,P_ATTRIBUTE17 => P_ATTRIBUTE17
235 ,P_ATTRIBUTE18 => P_ATTRIBUTE18
236 ,P_ATTRIBUTE19 => P_ATTRIBUTE19
237 ,P_ATTRIBUTE20 => P_ATTRIBUTE20
238 ,P_ATTRIBUTE21 => P_ATTRIBUTE21
239 ,P_ATTRIBUTE22 => P_ATTRIBUTE22
240 ,P_ATTRIBUTE23 => P_ATTRIBUTE23
241 ,P_ATTRIBUTE24 => P_ATTRIBUTE24
242 ,P_ATTRIBUTE25 => P_ATTRIBUTE25
243 ,P_ATTRIBUTE26 => P_ATTRIBUTE26
244 ,P_ATTRIBUTE27 => P_ATTRIBUTE27
245 ,P_ATTRIBUTE28 => P_ATTRIBUTE28
246 ,P_ATTRIBUTE29 => P_ATTRIBUTE29
247 ,P_ATTRIBUTE30 => P_ATTRIBUTE30
248 ,P_DEFAULT_POSTING_ID => P_DEFAULT_POSTING_ID
249 );
250 exception
251 when hr_api.cannot_find_prog_unit then
252 hr_api.cannot_find_prog_unit_error
253 (p_module_name => 'create_default_posting'
254 ,p_hook_type => 'AP'
255 );
256 end;
257 --
258 -- When in validation only mode raise the Validate_Enabled exception
259 --
260 if p_validate then
261 raise hr_api.validate_enabled;
262 end if;
263 --
264 -- Set all output arguments
265 --
266 p_object_version_number := l_object_version_number;
267 --
268 hr_utility.set_location(' Leaving:'||l_proc, 70);
269 exception
270 when hr_api.validate_enabled then
271 --
272 -- As the Validate_Enabled exception has been raised
273 -- we must rollback to the savepoint
274 --
275 rollback to create_default_posting;
276 --
277 -- Only set output warning arguments
278 -- (Any key or derived arguments must be set to null
279 -- when validation only mode is being used.)
280 --
281 p_object_version_number := null;
282 P_DEFAULT_POSTING_ID := null;
283 hr_utility.set_location(' Leaving:'||l_proc, 80);
284 when others then
285 --
286 -- A validation or unexpected error has occured
287 --
288 rollback to create_default_posting;
289 --
290 -- Reset IN OUT parameters and set OUT parameters
291 p_object_version_number := null;
292 P_DEFAULT_POSTING_ID := null;
293 --
294 hr_utility.set_location(' Leaving:'||l_proc, 90);
295 raise;
296 end create_default_posting;
297
298 --
299 -- ----------------------------------------------------------------------------
300 -- |----------------------< update_default_posting >--------------------------|
301 -- ----------------------------------------------------------------------------
302 --
303 procedure update_default_posting
304 (P_VALIDATE IN BOOLEAN default FALSE
305 ,P_LANGUAGE_CODE IN VARCHAR2 default hr_api.userenv_lang
306 ,P_DEFAULT_POSTING_ID IN NUMBER
307 ,P_POSITION_ID IN NUMBER default hr_api.g_number
308 ,P_JOB_ID IN NUMBER default hr_api.g_number
309 ,P_ORGANIZATION_ID IN NUMBER default hr_api.g_number
310 ,P_ORG_NAME IN VARCHAR2 default hr_api.g_varchar2
311 ,P_ORG_DESCRIPTION IN VARCHAR2 default hr_api.g_varchar2
312 ,P_JOB_TITLE IN VARCHAR2 default hr_api.g_varchar2
313 ,P_BRIEF_DESCRIPTION IN VARCHAR2 default hr_api.g_varchar2
314 ,P_DETAILED_DESCRIPTION IN VARCHAR2 default hr_api.g_varchar2
315 ,P_JOB_REQUIREMENTS IN VARCHAR2 default hr_api.g_varchar2
316 ,P_ADDITIONAL_DETAILS IN VARCHAR2 default hr_api.g_varchar2
317 ,P_HOW_TO_APPLY IN VARCHAR2 default hr_api.g_varchar2
318 ,P_IMAGE_URL IN VARCHAR2 default hr_api.g_varchar2
319 ,P_IMAGE_URL_ALT IN VARCHAR2 default hr_api.g_varchar2
320 ,P_ATTRIBUTE_CATEGORY IN VARCHAR2 default hr_api.g_varchar2
321 ,P_ATTRIBUTE1 IN VARCHAR2 default hr_api.g_varchar2
322 ,P_ATTRIBUTE2 IN VARCHAR2 default hr_api.g_varchar2
323 ,P_ATTRIBUTE3 IN VARCHAR2 default hr_api.g_varchar2
324 ,P_ATTRIBUTE4 IN VARCHAR2 default hr_api.g_varchar2
325 ,P_ATTRIBUTE5 IN VARCHAR2 default hr_api.g_varchar2
326 ,P_ATTRIBUTE6 IN VARCHAR2 default hr_api.g_varchar2
327 ,P_ATTRIBUTE7 IN VARCHAR2 default hr_api.g_varchar2
328 ,P_ATTRIBUTE8 IN VARCHAR2 default hr_api.g_varchar2
329 ,P_ATTRIBUTE9 IN VARCHAR2 default hr_api.g_varchar2
330 ,P_ATTRIBUTE10 IN VARCHAR2 default hr_api.g_varchar2
331 ,P_ATTRIBUTE11 IN VARCHAR2 default hr_api.g_varchar2
332 ,P_ATTRIBUTE12 IN VARCHAR2 default hr_api.g_varchar2
333 ,P_ATTRIBUTE13 IN VARCHAR2 default hr_api.g_varchar2
334 ,P_ATTRIBUTE14 IN VARCHAR2 default hr_api.g_varchar2
335 ,P_ATTRIBUTE15 IN VARCHAR2 default hr_api.g_varchar2
336 ,P_ATTRIBUTE16 IN VARCHAR2 default hr_api.g_varchar2
337 ,P_ATTRIBUTE17 IN VARCHAR2 default hr_api.g_varchar2
338 ,P_ATTRIBUTE18 IN VARCHAR2 default hr_api.g_varchar2
339 ,P_ATTRIBUTE19 IN VARCHAR2 default hr_api.g_varchar2
340 ,P_ATTRIBUTE20 IN VARCHAR2 default hr_api.g_varchar2
341 ,P_ATTRIBUTE21 IN VARCHAR2 default hr_api.g_varchar2
342 ,P_ATTRIBUTE22 IN VARCHAR2 default hr_api.g_varchar2
343 ,P_ATTRIBUTE23 IN VARCHAR2 default hr_api.g_varchar2
344 ,P_ATTRIBUTE24 IN VARCHAR2 default hr_api.g_varchar2
345 ,P_ATTRIBUTE25 IN VARCHAR2 default hr_api.g_varchar2
346 ,P_ATTRIBUTE26 IN VARCHAR2 default hr_api.g_varchar2
347 ,P_ATTRIBUTE27 IN VARCHAR2 default hr_api.g_varchar2
348 ,P_ATTRIBUTE28 IN VARCHAR2 default hr_api.g_varchar2
349 ,P_ATTRIBUTE29 IN VARCHAR2 default hr_api.g_varchar2
350 ,P_ATTRIBUTE30 IN VARCHAR2 default hr_api.g_varchar2
351 ,P_OBJECT_VERSION_NUMBER IN OUT NOCOPY NUMBER
352 ) is
353 --
354 -- Declare cursors and local variables
355 --
356
357 l_proc varchar2(72) := g_package||'update_default_posting';
358 l_object_version_number number;
359 l_language_code varchar2(30);
360
361 begin
362 hr_utility.set_location('Entering:'|| l_proc||p_object_version_number, 10);
363 --
364 -- Issue a savepoint
365 --
366 savepoint update_default_posting;
367 --
368 l_language_code:=p_language_code;
369 hr_api.validate_language_code(p_language_code => l_language_code);
370 --
371 -- Call Before Process User Hook
372 --
373 begin
374 irc_default_posting_bk2.update_default_posting_b
375 (P_DEFAULT_POSTING_ID => P_DEFAULT_POSTING_ID
376 ,P_POSITION_ID => P_POSITION_ID
377 ,P_JOB_ID => P_JOB_ID
378 ,P_ORGANIZATION_ID => P_ORGANIZATION_ID
379 ,P_LANGUAGE_CODE => L_LANGUAGE_CODE
380 ,P_ORG_NAME => P_ORG_NAME
381 ,P_ORG_DESCRIPTION => P_ORG_DESCRIPTION
382 ,P_JOB_TITLE => P_JOB_TITLE
383 ,P_BRIEF_DESCRIPTION => P_BRIEF_DESCRIPTION
384 ,P_DETAILED_DESCRIPTION => P_DETAILED_DESCRIPTION
385 ,P_JOB_REQUIREMENTS => P_JOB_REQUIREMENTS
386 ,P_ADDITIONAL_DETAILS => P_ADDITIONAL_DETAILS
387 ,P_HOW_TO_APPLY => P_HOW_TO_APPLY
388 ,P_IMAGE_URL => P_IMAGE_URL
389 ,P_IMAGE_URL_ALT => P_IMAGE_URL_ALT
390 ,P_ATTRIBUTE_CATEGORY => P_ATTRIBUTE_CATEGORY
391 ,P_ATTRIBUTE1 => P_ATTRIBUTE1
392 ,P_ATTRIBUTE2 => P_ATTRIBUTE2
393 ,P_ATTRIBUTE3 => P_ATTRIBUTE3
394 ,P_ATTRIBUTE4 => P_ATTRIBUTE4
395 ,P_ATTRIBUTE5 => P_ATTRIBUTE5
396 ,P_ATTRIBUTE6 => P_ATTRIBUTE6
397 ,P_ATTRIBUTE7 => P_ATTRIBUTE7
398 ,P_ATTRIBUTE8 => P_ATTRIBUTE8
399 ,P_ATTRIBUTE9 => P_ATTRIBUTE9
400 ,P_ATTRIBUTE10 => P_ATTRIBUTE10
401 ,P_ATTRIBUTE11 => P_ATTRIBUTE11
402 ,P_ATTRIBUTE12 => P_ATTRIBUTE12
403 ,P_ATTRIBUTE13 => P_ATTRIBUTE13
404 ,P_ATTRIBUTE14 => P_ATTRIBUTE14
405 ,P_ATTRIBUTE15 => P_ATTRIBUTE15
406 ,P_ATTRIBUTE16 => P_ATTRIBUTE16
407 ,P_ATTRIBUTE17 => P_ATTRIBUTE17
408 ,P_ATTRIBUTE18 => P_ATTRIBUTE18
409 ,P_ATTRIBUTE19 => P_ATTRIBUTE19
410 ,P_ATTRIBUTE20 => P_ATTRIBUTE20
411 ,P_ATTRIBUTE21 => P_ATTRIBUTE21
412 ,P_ATTRIBUTE22 => P_ATTRIBUTE22
413 ,P_ATTRIBUTE23 => P_ATTRIBUTE23
414 ,P_ATTRIBUTE24 => P_ATTRIBUTE24
415 ,P_ATTRIBUTE25 => P_ATTRIBUTE25
416 ,P_ATTRIBUTE26 => P_ATTRIBUTE26
417 ,P_ATTRIBUTE27 => P_ATTRIBUTE27
418 ,P_ATTRIBUTE28 => P_ATTRIBUTE28
419 ,P_ATTRIBUTE29 => P_ATTRIBUTE29
420 ,P_ATTRIBUTE30 => P_ATTRIBUTE30
421 );
422 exception
423 when hr_api.cannot_find_prog_unit then
424 hr_api.cannot_find_prog_unit_error
425 (p_module_name => 'update_default_posting'
426 ,p_hook_type => 'BP'
427 );
428 end;
429 --
430 -- Validation in addition to Row Handlers
431 --
432
433 -- None
434
435 --
436 -- Process Logic
437 --
438 l_object_version_number := p_object_version_number;
439
440 irc_idp_upd.upd
441 (P_DEFAULT_POSTING_ID => P_DEFAULT_POSTING_ID
442 ,P_OBJECT_VERSION_NUMBER => l_OBJECT_VERSION_NUMBER
443 ,P_POSITION_ID => P_POSITION_ID
444 ,P_JOB_ID => P_JOB_ID
445 ,P_ORGANIZATION_ID => P_ORGANIZATION_ID
446 ,P_ATTRIBUTE_CATEGORY => P_ATTRIBUTE_CATEGORY
447 ,P_ATTRIBUTE1 => P_ATTRIBUTE1
448 ,P_ATTRIBUTE2 => P_ATTRIBUTE2
449 ,P_ATTRIBUTE3 => P_ATTRIBUTE3
450 ,P_ATTRIBUTE4 => P_ATTRIBUTE4
451 ,P_ATTRIBUTE5 => P_ATTRIBUTE5
452 ,P_ATTRIBUTE6 => P_ATTRIBUTE6
453 ,P_ATTRIBUTE7 => P_ATTRIBUTE7
454 ,P_ATTRIBUTE8 => P_ATTRIBUTE8
455 ,P_ATTRIBUTE9 => P_ATTRIBUTE9
456 ,P_ATTRIBUTE10 => P_ATTRIBUTE10
457 ,P_ATTRIBUTE11 => P_ATTRIBUTE11
458 ,P_ATTRIBUTE12 => P_ATTRIBUTE12
459 ,P_ATTRIBUTE13 => P_ATTRIBUTE13
460 ,P_ATTRIBUTE14 => P_ATTRIBUTE14
461 ,P_ATTRIBUTE15 => P_ATTRIBUTE15
462 ,P_ATTRIBUTE16 => P_ATTRIBUTE16
463 ,P_ATTRIBUTE17 => P_ATTRIBUTE17
464 ,P_ATTRIBUTE18 => P_ATTRIBUTE18
465 ,P_ATTRIBUTE19 => P_ATTRIBUTE19
466 ,P_ATTRIBUTE20 => P_ATTRIBUTE20
467 ,P_ATTRIBUTE21 => P_ATTRIBUTE21
468 ,P_ATTRIBUTE22 => P_ATTRIBUTE22
469 ,P_ATTRIBUTE23 => P_ATTRIBUTE23
470 ,P_ATTRIBUTE24 => P_ATTRIBUTE24
471 ,P_ATTRIBUTE25 => P_ATTRIBUTE25
472 ,P_ATTRIBUTE26 => P_ATTRIBUTE26
473 ,P_ATTRIBUTE27 => P_ATTRIBUTE27
474 ,P_ATTRIBUTE28 => P_ATTRIBUTE28
475 ,P_ATTRIBUTE29 => P_ATTRIBUTE29
476 ,P_ATTRIBUTE30 => P_ATTRIBUTE30
477 );
478
479 --
480 -- Process Translation Logic
481 --
482
483 irc_idt_upd.upd_tl
484 (P_DEFAULT_POSTING_ID => P_DEFAULT_POSTING_ID
485 ,P_LANGUAGE_CODE => L_LANGUAGE_CODE
486 ,P_ORG_NAME => P_ORG_NAME
487 ,P_ORG_DESCRIPTION => P_ORG_DESCRIPTION
488 ,P_JOB_TITLE => P_JOB_TITLE
489 ,P_BRIEF_DESCRIPTION => P_BRIEF_DESCRIPTION
490 ,P_DETAILED_DESCRIPTION => P_DETAILED_DESCRIPTION
491 ,P_JOB_REQUIREMENTS => P_JOB_REQUIREMENTS
492 ,P_ADDITIONAL_DETAILS => P_ADDITIONAL_DETAILS
493 ,P_HOW_TO_APPLY => P_HOW_TO_APPLY
494 ,P_IMAGE_URL => P_IMAGE_URL
495 ,P_IMAGE_URL_ALT => P_IMAGE_URL_ALT
496 );
497
498 --
499 -- Call After Process User Hook
500 --
501 begin
502 irc_default_posting_bk2.update_default_posting_a
503 (P_POSITION_ID => P_POSITION_ID
504 ,P_JOB_ID => P_JOB_ID
505 ,P_ORGANIZATION_ID => P_ORGANIZATION_ID
506 ,P_LANGUAGE_CODE => L_LANGUAGE_CODE
507 ,P_ORG_NAME => P_ORG_NAME
508 ,P_ORG_DESCRIPTION => P_ORG_DESCRIPTION
509 ,P_JOB_TITLE => P_JOB_TITLE
510 ,P_BRIEF_DESCRIPTION => P_BRIEF_DESCRIPTION
511 ,P_DETAILED_DESCRIPTION => P_DETAILED_DESCRIPTION
512 ,P_JOB_REQUIREMENTS => P_JOB_REQUIREMENTS
513 ,P_ADDITIONAL_DETAILS => P_ADDITIONAL_DETAILS
514 ,P_HOW_TO_APPLY => P_HOW_TO_APPLY
515 ,P_IMAGE_URL => P_IMAGE_URL
516 ,P_IMAGE_URL_ALT => P_IMAGE_URL_ALT
517 ,P_ATTRIBUTE_CATEGORY => P_ATTRIBUTE_CATEGORY
518 ,P_ATTRIBUTE1 => P_ATTRIBUTE1
519 ,P_ATTRIBUTE2 => P_ATTRIBUTE2
520 ,P_ATTRIBUTE3 => P_ATTRIBUTE3
521 ,P_ATTRIBUTE4 => P_ATTRIBUTE4
522 ,P_ATTRIBUTE5 => P_ATTRIBUTE5
523 ,P_ATTRIBUTE6 => P_ATTRIBUTE6
524 ,P_ATTRIBUTE7 => P_ATTRIBUTE7
525 ,P_ATTRIBUTE8 => P_ATTRIBUTE8
526 ,P_ATTRIBUTE9 => P_ATTRIBUTE9
527 ,P_ATTRIBUTE10 => P_ATTRIBUTE10
528 ,P_ATTRIBUTE11 => P_ATTRIBUTE11
529 ,P_ATTRIBUTE12 => P_ATTRIBUTE12
530 ,P_ATTRIBUTE13 => P_ATTRIBUTE13
531 ,P_ATTRIBUTE14 => P_ATTRIBUTE14
532 ,P_ATTRIBUTE15 => P_ATTRIBUTE15
533 ,P_ATTRIBUTE16 => P_ATTRIBUTE16
534 ,P_ATTRIBUTE17 => P_ATTRIBUTE17
535 ,P_ATTRIBUTE18 => P_ATTRIBUTE18
536 ,P_ATTRIBUTE19 => P_ATTRIBUTE19
537 ,P_ATTRIBUTE20 => P_ATTRIBUTE20
538 ,P_ATTRIBUTE21 => P_ATTRIBUTE21
539 ,P_ATTRIBUTE22 => P_ATTRIBUTE22
540 ,P_ATTRIBUTE23 => P_ATTRIBUTE23
541 ,P_ATTRIBUTE24 => P_ATTRIBUTE24
542 ,P_ATTRIBUTE25 => P_ATTRIBUTE25
543 ,P_ATTRIBUTE26 => P_ATTRIBUTE26
544 ,P_ATTRIBUTE27 => P_ATTRIBUTE27
545 ,P_ATTRIBUTE28 => P_ATTRIBUTE28
546 ,P_ATTRIBUTE29 => P_ATTRIBUTE29
547 ,P_ATTRIBUTE30 => P_ATTRIBUTE30
548 ,P_DEFAULT_POSTING_ID => P_DEFAULT_POSTING_ID
549 );
550 exception
551 when hr_api.cannot_find_prog_unit then
552 hr_api.cannot_find_prog_unit_error
553 (p_module_name => 'update_default_posting'
554 ,p_hook_type => 'AP'
555 );
556 end;
557 --
558 -- When in validation only mode raise the Validate_Enabled exception
559 --
560 if p_validate then
561 raise hr_api.validate_enabled;
562 end if;
563 --
564 p_object_version_number := l_object_version_number;
565 --
566 hr_utility.set_location(' Leaving:'||l_proc||p_object_version_number, 70);
567 exception
568 when hr_api.validate_enabled then
569 --
570 -- As the Validate_Enabled exception has been raised
571 -- we must rollback to the savepoint
572 --
573 rollback to update_default_posting;
574 --
575 --
576 p_object_version_number := l_object_version_number;
577 --
578 -- Only set output warning arguments
579 -- (Any key or derived arguments must be set to null
580 -- when validation only mode is being used.)
581 --
582 hr_utility.set_location(' Leaving:'||l_proc, 80);
583 when others then
584 --
585 -- A validation or unexpected error has occured
586 --
587 rollback to update_default_posting;
588 --
589 p_object_version_number := l_object_version_number;
590 --
591 hr_utility.set_location(' Leaving:'||l_proc, 90);
592 raise;
593 end update_default_posting;
594
595 --
596 -- ----------------------------------------------------------------------------
597 -- |------------------------< delete_default_posting >------------------------|
598 -- ----------------------------------------------------------------------------
599 --
600 procedure delete_default_posting
601 (P_VALIDATE in BOOLEAN default false
602 ,P_DEFAULT_POSTING_ID in NUMBER
603 ,P_OBJECT_VERSION_NUMBER in NUMBER
604 ) is
605
606 --
607 -- Declare cursors and local variables
608 --
609
610 l_proc varchar2(72) := g_package||'delete_default_posting';
611 l_object_version_number number;
612
613 begin
614 hr_utility.set_location('Entering:'|| l_proc, 10);
615 --
616 -- Issue a savepoint
617 --
618 savepoint delete_default_posting;
619
620 --
621 -- Call Before Process User Hook
622 --
623 begin
624 irc_default_posting_bk3.delete_default_posting_b
625 (P_DEFAULT_POSTING_ID => P_DEFAULT_POSTING_ID
626 );
627 exception
628 when hr_api.cannot_find_prog_unit then
629 hr_api.cannot_find_prog_unit_error
630 (p_module_name => 'delete_default_posting'
631 ,p_hook_type => 'BP'
632 );
633 end;
634
635 --
636 -- Validation in addition to Row Handlers
637 --
638
639 -- NONE
640
641 --
642 -- Process Logic
643 --
644 irc_idp_shd.lck
645 (P_DEFAULT_POSTING_ID => P_DEFAULT_POSTING_ID
646 ,P_OBJECT_VERSION_NUMBER => P_OBJECT_VERSION_NUMBER
647 );
648 --
649 -- Process Translation Logic
650 --
651 irc_idt_del.del_tl
652 (P_DEFAULT_POSTING_ID => P_DEFAULT_POSTING_ID
653 );
654 irc_idp_del.del
655 (P_DEFAULT_POSTING_ID => P_DEFAULT_POSTING_ID
656 ,P_OBJECT_VERSION_NUMBER => P_OBJECT_VERSION_NUMBER
657 );
658
659 --
660 -- Call After Process User Hook
661 --
662 begin
663 irc_default_posting_bk3.delete_default_posting_a
664 (P_DEFAULT_POSTING_ID => P_DEFAULT_POSTING_ID
665 );
666 exception
667 when hr_api.cannot_find_prog_unit then
668 hr_api.cannot_find_prog_unit_error
669 (p_module_name => 'delete_default_posting'
670 ,p_hook_type => 'AP'
671 );
672 end;
673 --
674 -- When in validation only mode raise the Validate_Enabled exception
675 --
676 if p_validate then
677 raise hr_api.validate_enabled;
678 end if;
679 hr_utility.set_location(' Leaving:'||l_proc, 70);
680
681 exception
682 when hr_api.validate_enabled then
683 --
684 -- As the Validate_Enabled exception has been raised
685 -- we must rollback to the savepoint
686 --
687 rollback to delete_default_posting;
688 --
689 -- Only set output warning arguments
690 -- (Any key or derived arguments must be set to null
691 -- when validation only mode is being used.)
692 --
693 hr_utility.set_location(' Leaving:'||l_proc, 80);
694 when others then
695 --
696 -- A validation or unexpected error has occured
697 --
698 rollback to delete_default_posting;
699 hr_utility.set_location(' Leaving:'||l_proc, 90);
700 raise;
701 end delete_default_posting;
702
703 --
704 end irc_default_posting_api;