[Home] [Help]
PACKAGE BODY: APPS.HR_CONTACT_EXTRA_INFO_API
Source
1 Package Body hr_contact_extra_info_api as
2 /* $Header: pereiapi.pkb 115.1 2002/12/10 15:37:01 eumenyio noship $ */
3 --
4 -- Package Variables
5 --
6 g_package varchar2(33) := ' hr_contact_extra_info.';
7 --
8 -- ----------------------------------------------------------------------------
9 -- |-----------------------< create_contact_extra_info >----------------------|
10 -- ----------------------------------------------------------------------------
11 --
12 procedure create_contact_extra_info
13 (p_validate in boolean default false
14 ,p_effective_date in date,
15 -- ,p_business_group_id in number
16 -- ,p_non_mandatory_arg in number default null
17 p_contact_relationship_id IN NUMBER,
18 p_information_type IN VARCHAR2,
19 p_cei_information_category IN VARCHAR2 DEFAULT NULL,
20 p_cei_information1 IN VARCHAR2 DEFAULT NULL,
21 p_cei_information2 IN VARCHAR2 DEFAULT NULL,
22 p_cei_information3 IN VARCHAR2 DEFAULT NULL,
23 p_cei_information4 IN VARCHAR2 DEFAULT NULL,
24 p_cei_information5 IN VARCHAR2 DEFAULT NULL,
25 p_cei_information6 IN VARCHAR2 DEFAULT NULL,
26 p_cei_information7 IN VARCHAR2 DEFAULT NULL,
27 p_cei_information8 IN VARCHAR2 DEFAULT NULL,
28 p_cei_information9 IN VARCHAR2 DEFAULT NULL,
29 p_cei_information10 IN VARCHAR2 DEFAULT NULL,
30 p_cei_information11 IN VARCHAR2 DEFAULT NULL,
31 p_cei_information12 IN VARCHAR2 DEFAULT NULL,
32 p_cei_information13 IN VARCHAR2 DEFAULT NULL,
33 p_cei_information14 IN VARCHAR2 DEFAULT NULL,
34 p_cei_information15 IN VARCHAR2 DEFAULT NULL,
35 p_cei_information16 IN VARCHAR2 DEFAULT NULL,
36 p_cei_information17 IN VARCHAR2 DEFAULT NULL,
37 p_cei_information18 IN VARCHAR2 DEFAULT NULL,
38 p_cei_information19 IN VARCHAR2 DEFAULT NULL,
39 p_cei_information20 IN VARCHAR2 DEFAULT NULL,
40 p_cei_information21 IN VARCHAR2 DEFAULT NULL,
41 p_cei_information22 IN VARCHAR2 DEFAULT NULL,
42 p_cei_information23 IN VARCHAR2 DEFAULT NULL,
43 p_cei_information24 IN VARCHAR2 DEFAULT NULL,
44 p_cei_information25 IN VARCHAR2 DEFAULT NULL,
45 p_cei_information26 IN VARCHAR2 DEFAULT NULL,
46 p_cei_information27 IN VARCHAR2 DEFAULT NULL,
47 p_cei_information28 IN VARCHAR2 DEFAULT NULL,
48 p_cei_information29 IN VARCHAR2 DEFAULT NULL,
49 p_cei_information30 IN VARCHAR2 DEFAULT NULL,
50 p_cei_attribute_category IN VARCHAR2 DEFAULT NULL,
51 p_cei_attribute1 IN VARCHAR2 DEFAULT NULL,
52 p_cei_attribute2 IN VARCHAR2 DEFAULT NULL,
53 p_cei_attribute3 IN VARCHAR2 DEFAULT NULL,
54 p_cei_attribute4 IN VARCHAR2 DEFAULT NULL,
55 p_cei_attribute5 IN VARCHAR2 DEFAULT NULL,
56 p_cei_attribute6 IN VARCHAR2 DEFAULT NULL,
57 p_cei_attribute7 IN VARCHAR2 DEFAULT NULL,
58 p_cei_attribute8 IN VARCHAR2 DEFAULT NULL,
59 p_cei_attribute9 IN VARCHAR2 DEFAULT NULL,
60 p_cei_attribute10 IN VARCHAR2 DEFAULT NULL,
61 p_cei_attribute11 IN VARCHAR2 DEFAULT NULL,
62 p_cei_attribute12 IN VARCHAR2 DEFAULT NULL,
63 p_cei_attribute13 IN VARCHAR2 DEFAULT NULL,
64 p_cei_attribute14 IN VARCHAR2 DEFAULT NULL,
65 p_cei_attribute15 IN VARCHAR2 DEFAULT NULL,
66 p_cei_attribute16 IN VARCHAR2 DEFAULT NULL,
67 p_cei_attribute17 IN VARCHAR2 DEFAULT NULL,
68 p_cei_attribute18 IN VARCHAR2 DEFAULT NULL,
69 p_cei_attribute19 IN VARCHAR2 DEFAULT NULL,
70 p_cei_attribute20 IN VARCHAR2 DEFAULT NULL
71 ,p_contact_extra_info_id out nocopy number
72 ,p_object_version_number out nocopy number,
73 -- ,p_some_warning out boolean
74 p_effective_start_date OUT NOCOPY DATE,
75 p_effective_end_date OUT NOCOPY DATE
76 ) is
77 --
78 -- Declare cursors and local variables
79 --
80 l_contact_extra_info_id per_contact_extra_info_f.contact_extra_info_id%TYPE;
81 l_object_version_number per_contact_extra_info_f.object_version_number%TYPE;
82 l_effective_start_date per_contact_extra_info_f.effective_start_date%TYPE;
83 l_effective_end_date per_contact_extra_info_f.effective_end_date%TYPE;
84 l_proc varchar2(72) := g_package||'create_contact_extra_info';
85 begin
86 hr_utility.set_location('Entering:'|| l_proc, 10);
87 --
88 -- Issue a savepoint
89 --
90 savepoint create_contact_extra_info;
91 --
92 -- Truncate the time portion from all IN date parameters
93 --
94
95 --
96 -- Call Before Process User Hook
97 --
98 begin
99 hr_contact_extra_info_bk1.create_contact_extra_info_b
100 (p_effective_date => p_effective_date,
101 -- ,p_business_group_id => p_business_group_id
102 -- ,p_non_mandatory_arg => p_non_mandatory_arg
103 p_contact_relationship_id => p_contact_relationship_id,
104 p_information_type => p_information_type,
105 p_cei_information_category => p_cei_information_category,
106 p_cei_information1 => p_cei_information1,
107 p_cei_information2 => p_cei_information2,
108 p_cei_information3 => p_cei_information3,
109 p_cei_information4 => p_cei_information4,
110 p_cei_information5 => p_cei_information5,
111 p_cei_information6 => p_cei_information6,
112 p_cei_information7 => p_cei_information7,
113 p_cei_information8 => p_cei_information8,
114 p_cei_information9 => p_cei_information9,
115 p_cei_information10 => p_cei_information10,
116 p_cei_information11 => p_cei_information11,
117 p_cei_information12 => p_cei_information12,
118 p_cei_information13 => p_cei_information13,
119 p_cei_information14 => p_cei_information14,
120 p_cei_information15 => p_cei_information15,
121 p_cei_information16 => p_cei_information16,
122 p_cei_information17 => p_cei_information17,
123 p_cei_information18 => p_cei_information18,
124 p_cei_information19 => p_cei_information19,
125 p_cei_information20 => p_cei_information20,
126 p_cei_information21 => p_cei_information21,
127 p_cei_information22 => p_cei_information22,
128 p_cei_information23 => p_cei_information23,
129 p_cei_information24 => p_cei_information24,
130 p_cei_information25 => p_cei_information25,
131 p_cei_information26 => p_cei_information26,
132 p_cei_information27 => p_cei_information27,
133 p_cei_information28 => p_cei_information28,
134 p_cei_information29 => p_cei_information29,
135 p_cei_information30 => p_cei_information30,
136 p_cei_attribute_category => p_cei_attribute_category,
137 p_cei_attribute1 => p_cei_attribute1,
138 p_cei_attribute2 => p_cei_attribute2,
139 p_cei_attribute3 => p_cei_attribute3,
140 p_cei_attribute4 => p_cei_attribute4,
141 p_cei_attribute5 => p_cei_attribute5,
142 p_cei_attribute6 => p_cei_attribute6,
143 p_cei_attribute7 => p_cei_attribute7,
144 p_cei_attribute8 => p_cei_attribute8,
145 p_cei_attribute9 => p_cei_attribute9,
146 p_cei_attribute10 => p_cei_attribute10,
147 p_cei_attribute11 => p_cei_attribute11,
148 p_cei_attribute12 => p_cei_attribute12,
149 p_cei_attribute13 => p_cei_attribute13,
150 p_cei_attribute14 => p_cei_attribute14,
151 p_cei_attribute15 => p_cei_attribute15,
152 p_cei_attribute16 => p_cei_attribute16,
153 p_cei_attribute17 => p_cei_attribute17,
154 p_cei_attribute18 => p_cei_attribute18,
155 p_cei_attribute19 => p_cei_attribute19,
156 p_cei_attribute20 => p_cei_attribute20
157 );
158 exception
159 when hr_api.cannot_find_prog_unit then
160 hr_api.cannot_find_prog_unit_error
161 (p_module_name => 'create_contact_extra_info'
162 ,p_hook_type => 'BP'
163 );
164 end;
165 --
166 -- Validation in addition to Row Handlers
167 --
168
169
170
171 --
172 -- Process Logic
173 --
174 per_rei_ins.ins(
175 p_effective_date => p_effective_date,
176 p_contact_relationship_id => p_contact_relationship_id,
177 p_information_type => p_information_type,
178 p_cei_information_category => p_cei_information_category,
179 p_cei_information1 => p_cei_information1,
180 p_cei_information2 => p_cei_information2,
181 p_cei_information3 => p_cei_information3,
182 p_cei_information4 => p_cei_information4,
183 p_cei_information5 => p_cei_information5,
184 p_cei_information6 => p_cei_information6,
185 p_cei_information7 => p_cei_information7,
186 p_cei_information8 => p_cei_information8,
187 p_cei_information9 => p_cei_information9,
188 p_cei_information10 => p_cei_information10,
189 p_cei_information11 => p_cei_information11,
190 p_cei_information12 => p_cei_information12,
191 p_cei_information13 => p_cei_information13,
192 p_cei_information14 => p_cei_information14,
193 p_cei_information15 => p_cei_information15,
194 p_cei_information16 => p_cei_information16,
195 p_cei_information17 => p_cei_information17,
196 p_cei_information18 => p_cei_information18,
197 p_cei_information19 => p_cei_information19,
198 p_cei_information20 => p_cei_information20,
199 p_cei_information21 => p_cei_information21,
200 p_cei_information22 => p_cei_information22,
201 p_cei_information23 => p_cei_information23,
202 p_cei_information24 => p_cei_information24,
203 p_cei_information25 => p_cei_information25,
204 p_cei_information26 => p_cei_information26,
205 p_cei_information27 => p_cei_information27,
206 p_cei_information28 => p_cei_information28,
207 p_cei_information29 => p_cei_information29,
208 p_cei_information30 => p_cei_information30,
209 p_cei_attribute_category => p_cei_attribute_category,
210 p_cei_attribute1 => p_cei_attribute1,
211 p_cei_attribute2 => p_cei_attribute2,
212 p_cei_attribute3 => p_cei_attribute3,
213 p_cei_attribute4 => p_cei_attribute4,
214 p_cei_attribute5 => p_cei_attribute5,
215 p_cei_attribute6 => p_cei_attribute6,
216 p_cei_attribute7 => p_cei_attribute7,
217 p_cei_attribute8 => p_cei_attribute8,
218 p_cei_attribute9 => p_cei_attribute9,
219 p_cei_attribute10 => p_cei_attribute10,
220 p_cei_attribute11 => p_cei_attribute11,
221 p_cei_attribute12 => p_cei_attribute12,
222 p_cei_attribute13 => p_cei_attribute13,
223 p_cei_attribute14 => p_cei_attribute14,
224 p_cei_attribute15 => p_cei_attribute15,
225 p_cei_attribute16 => p_cei_attribute16,
226 p_cei_attribute17 => p_cei_attribute17,
227 p_cei_attribute18 => p_cei_attribute18,
228 p_cei_attribute19 => p_cei_attribute19,
229 p_cei_attribute20 => p_cei_attribute20,
230 p_contact_extra_info_id => l_contact_extra_info_id,
231 p_object_version_number => l_object_version_number,
232 p_effective_start_date => l_effective_start_date,
233 p_effective_end_date => l_effective_end_date);
234 --
235 -- Call After Process User Hook
236 --
237 begin
238 hr_contact_extra_info_bk1.create_contact_extra_info_a
239 (p_effective_date => p_effective_date,
240 -- ,p_business_group_id => p_business_group_id
241 -- ,p_non_mandatory_arg => p_non_mandatory_arg
242 p_contact_relationship_id => p_contact_relationship_id,
243 p_information_type => p_information_type,
244 p_cei_information_category => p_cei_information_category,
245 p_cei_information1 => p_cei_information1,
246 p_cei_information2 => p_cei_information2,
247 p_cei_information3 => p_cei_information3,
248 p_cei_information4 => p_cei_information4,
249 p_cei_information5 => p_cei_information5,
250 p_cei_information6 => p_cei_information6,
251 p_cei_information7 => p_cei_information7,
252 p_cei_information8 => p_cei_information8,
253 p_cei_information9 => p_cei_information9,
254 p_cei_information10 => p_cei_information10,
255 p_cei_information11 => p_cei_information11,
256 p_cei_information12 => p_cei_information12,
257 p_cei_information13 => p_cei_information13,
258 p_cei_information14 => p_cei_information14,
259 p_cei_information15 => p_cei_information15,
260 p_cei_information16 => p_cei_information16,
261 p_cei_information17 => p_cei_information17,
262 p_cei_information18 => p_cei_information18,
263 p_cei_information19 => p_cei_information19,
264 p_cei_information20 => p_cei_information20,
265 p_cei_information21 => p_cei_information21,
266 p_cei_information22 => p_cei_information22,
267 p_cei_information23 => p_cei_information23,
268 p_cei_information24 => p_cei_information24,
269 p_cei_information25 => p_cei_information25,
270 p_cei_information26 => p_cei_information26,
271 p_cei_information27 => p_cei_information27,
272 p_cei_information28 => p_cei_information28,
273 p_cei_information29 => p_cei_information29,
274 p_cei_information30 => p_cei_information30,
275 p_cei_attribute_category => p_cei_attribute_category,
276 p_cei_attribute1 => p_cei_attribute1,
277 p_cei_attribute2 => p_cei_attribute2,
278 p_cei_attribute3 => p_cei_attribute3,
279 p_cei_attribute4 => p_cei_attribute4,
280 p_cei_attribute5 => p_cei_attribute5,
281 p_cei_attribute6 => p_cei_attribute6,
282 p_cei_attribute7 => p_cei_attribute7,
283 p_cei_attribute8 => p_cei_attribute8,
284 p_cei_attribute9 => p_cei_attribute9,
285 p_cei_attribute10 => p_cei_attribute10,
286 p_cei_attribute11 => p_cei_attribute11,
287 p_cei_attribute12 => p_cei_attribute12,
288 p_cei_attribute13 => p_cei_attribute13,
289 p_cei_attribute14 => p_cei_attribute14,
290 p_cei_attribute15 => p_cei_attribute15,
291 p_cei_attribute16 => p_cei_attribute16,
292 p_cei_attribute17 => p_cei_attribute17,
293 p_cei_attribute18 => p_cei_attribute18,
294 p_cei_attribute19 => p_cei_attribute19,
295 p_cei_attribute20 => p_cei_attribute20
296 ,p_contact_extra_info_id => l_contact_extra_info_id
297 ,p_object_version_number => l_object_version_number
298 -- ,p_some_warning => <local_var_set_in_process_logic>
299 );
300 exception
301 when hr_api.cannot_find_prog_unit then
302 hr_api.cannot_find_prog_unit_error
303 (p_module_name => 'create_contact_extra_info'
304 ,p_hook_type => 'AP'
305 );
306 end;
307 --
308 -- When in validation only mode raise the Validate_Enabled exception
309 --
310 if p_validate then
311 raise hr_api.validate_enabled;
312 end if;
313 --
314 -- Set all output arguments
315 --
316 p_contact_extra_info_id := l_contact_extra_info_id;
317 p_object_version_number := l_object_version_number;
318 -- p_some_warning := <local_var_set_in_process_logic>
319 p_effective_start_date := l_effective_start_date;
320 p_effective_end_date := l_effective_end_date;
321 --
322 hr_utility.set_location(' Leaving:'||l_proc, 70);
323 exception
324 when hr_api.validate_enabled then
325 --
326 -- As the Validate_Enabled exception has been raised
327 -- we must rollback to the savepoint
328 --
329 rollback to create_contact_extra_info;
330 --
331 -- Only set output warning arguments
332 -- (Any key or derived arguments must be set to null
333 -- when validation only mode is being used.)
334 --
335 p_contact_extra_info_id := null;
336 p_object_version_number := null;
337 -- p_some_warning := <local_var_set_in_process_logic>
338 p_effective_start_date := NULL;
339 p_effective_end_date := NULL;
340 hr_utility.set_location(' Leaving:'||l_proc, 80);
341 when others then
342 --
343 -- A validation or unexpected error has occured
344 --
345 p_contact_extra_info_id := null;
346 p_object_version_number := null;
347 p_effective_start_date := NULL;
348 p_effective_end_date := NULL;
349 rollback to create_contact_extra_info;
350 hr_utility.set_location(' Leaving:'||l_proc, 90);
351 raise;
352 end create_contact_extra_info;
353 --
354 -- ----------------------------------------------------------------------------
355 -- |-----------------------< update_contact_extra_info >----------------------|
356 -- ----------------------------------------------------------------------------
357 --
358 procedure update_contact_extra_info
359 (p_validate in boolean default false
360 ,p_effective_date in date,
361 -- ,p_business_group_id in number
362 -- ,p_non_mandatory_arg in number default null
363 p_datetrack_update_mode IN VARCHAR2,
364 p_contact_extra_info_id IN NUMBER,
365 p_contact_relationship_id IN NUMBER DEFAULT hr_api.g_number,
366 p_information_type IN VARCHAR2 DEFAULT hr_api.g_varchar2,
367 p_object_version_number IN OUT NOCOPY NUMBER,
368 p_cei_information_category IN VARCHAR2 DEFAULT hr_api.g_varchar2,
369 p_cei_information1 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
370 p_cei_information2 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
371 p_cei_information3 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
372 p_cei_information4 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
373 p_cei_information5 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
374 p_cei_information6 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
375 p_cei_information7 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
376 p_cei_information8 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
377 p_cei_information9 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
378 p_cei_information10 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
379 p_cei_information11 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
380 p_cei_information12 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
381 p_cei_information13 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
382 p_cei_information14 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
383 p_cei_information15 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
384 p_cei_information16 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
385 p_cei_information17 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
386 p_cei_information18 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
387 p_cei_information19 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
388 p_cei_information20 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
389 p_cei_information21 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
390 p_cei_information22 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
391 p_cei_information23 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
392 p_cei_information24 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
393 p_cei_information25 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
394 p_cei_information26 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
395 p_cei_information27 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
396 p_cei_information28 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
397 p_cei_information29 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
398 p_cei_information30 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
399 p_cei_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2,
400 p_cei_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
401 p_cei_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
402 p_cei_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
403 p_cei_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
404 p_cei_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
405 p_cei_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
406 p_cei_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
407 p_cei_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
408 p_cei_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
409 p_cei_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
410 p_cei_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
411 p_cei_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
412 p_cei_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
413 p_cei_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
414 p_cei_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
415 p_cei_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
416 p_cei_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
417 p_cei_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
418 p_cei_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
419 p_cei_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2,
420 -- ,p_id out number
421 -- ,p_object_version_number out number
422 -- ,p_some_warning out boolean
423 p_effective_start_date OUT NOCOPY DATE,
424 p_effective_end_date OUT NOCOPY DATE
425 ) is
426 --
427 --
428 -- Declare cursors and local variables
429 --
430 l_effective_start_date per_contact_extra_info_f.effective_start_date%TYPE;
431 l_effective_end_date per_contact_extra_info_f.effective_end_date%TYPE;
432 l_proc varchar2(72) := g_package||'update_contact_extra_info';
433 l_temp_ovn number := p_object_version_number;
434 begin
435 hr_utility.set_location('Entering:'|| l_proc, 10);
436 --
437 -- Issue a savepoint
438 --
439 savepoint update_contact_extra_info;
440 --
441 -- Truncate the time portion from all IN date parameters
442 --
443
444 --
445 -- Call Before Process User Hook
446 --
447 begin
448 hr_contact_extra_info_bk2.update_contact_extra_info_b
449 (p_effective_date => p_effective_date,
450 -- ,p_business_group_id => p_business_group_id
451 -- ,p_non_mandatory_arg => p_non_mandatory_arg
452 p_datetrack_update_mode => p_datetrack_update_mode,
453 p_contact_extra_info_id => p_contact_extra_info_id,
454 p_contact_relationship_id => p_contact_relationship_id,
455 p_information_type => p_information_type,
456 p_cei_information_category => p_cei_information_category,
457 p_cei_information1 => p_cei_information1,
458 p_cei_information2 => p_cei_information2,
459 p_cei_information3 => p_cei_information3,
460 p_cei_information4 => p_cei_information4,
461 p_cei_information5 => p_cei_information5,
462 p_cei_information6 => p_cei_information6,
463 p_cei_information7 => p_cei_information7,
464 p_cei_information8 => p_cei_information8,
465 p_cei_information9 => p_cei_information9,
466 p_cei_information10 => p_cei_information10,
467 p_cei_information11 => p_cei_information11,
468 p_cei_information12 => p_cei_information12,
469 p_cei_information13 => p_cei_information13,
470 p_cei_information14 => p_cei_information14,
471 p_cei_information15 => p_cei_information15,
472 p_cei_information16 => p_cei_information16,
473 p_cei_information17 => p_cei_information17,
474 p_cei_information18 => p_cei_information18,
475 p_cei_information19 => p_cei_information19,
476 p_cei_information20 => p_cei_information20,
477 p_cei_information21 => p_cei_information21,
478 p_cei_information22 => p_cei_information22,
479 p_cei_information23 => p_cei_information23,
480 p_cei_information24 => p_cei_information24,
481 p_cei_information25 => p_cei_information25,
482 p_cei_information26 => p_cei_information26,
483 p_cei_information27 => p_cei_information27,
484 p_cei_information28 => p_cei_information28,
485 p_cei_information29 => p_cei_information29,
486 p_cei_information30 => p_cei_information30,
487 p_cei_attribute_category => p_cei_attribute_category,
488 p_cei_attribute1 => p_cei_attribute1,
489 p_cei_attribute2 => p_cei_attribute2,
490 p_cei_attribute3 => p_cei_attribute3,
491 p_cei_attribute4 => p_cei_attribute4,
492 p_cei_attribute5 => p_cei_attribute5,
493 p_cei_attribute6 => p_cei_attribute6,
494 p_cei_attribute7 => p_cei_attribute7,
495 p_cei_attribute8 => p_cei_attribute8,
496 p_cei_attribute9 => p_cei_attribute9,
497 p_cei_attribute10 => p_cei_attribute10,
498 p_cei_attribute11 => p_cei_attribute11,
499 p_cei_attribute12 => p_cei_attribute12,
500 p_cei_attribute13 => p_cei_attribute13,
501 p_cei_attribute14 => p_cei_attribute14,
502 p_cei_attribute15 => p_cei_attribute15,
503 p_cei_attribute16 => p_cei_attribute16,
504 p_cei_attribute17 => p_cei_attribute17,
505 p_cei_attribute18 => p_cei_attribute18,
506 p_cei_attribute19 => p_cei_attribute19,
507 p_cei_attribute20 => p_cei_attribute20,
508 p_object_version_number => p_object_version_number
509 );
510 exception
511 when hr_api.cannot_find_prog_unit then
512 hr_api.cannot_find_prog_unit_error
513 (p_module_name => 'update_contact_extra_info'
514 ,p_hook_type => 'BP'
515 );
516 end;
517 --
518 -- Validation in addition to Row Handlers
519 --
520
521
522 --
523 -- Process Logic
524 --
525 per_rei_upd.upd(
526 p_effective_date => p_effective_date,
527 p_datetrack_mode => p_datetrack_update_mode,
528 p_contact_extra_info_id => p_contact_extra_info_id,
529 p_object_version_number => p_object_version_number,
530 p_contact_relationship_id => p_contact_relationship_id,
531 p_information_type => p_information_type,
532 p_cei_information_category => p_cei_information_category,
533 p_cei_information1 => p_cei_information1,
534 p_cei_information2 => p_cei_information2,
535 p_cei_information3 => p_cei_information3,
536 p_cei_information4 => p_cei_information4,
537 p_cei_information5 => p_cei_information5,
538 p_cei_information6 => p_cei_information6,
539 p_cei_information7 => p_cei_information7,
540 p_cei_information8 => p_cei_information8,
541 p_cei_information9 => p_cei_information9,
542 p_cei_information10 => p_cei_information10,
543 p_cei_information11 => p_cei_information11,
544 p_cei_information12 => p_cei_information12,
545 p_cei_information13 => p_cei_information13,
546 p_cei_information14 => p_cei_information14,
547 p_cei_information15 => p_cei_information15,
548 p_cei_information16 => p_cei_information16,
549 p_cei_information17 => p_cei_information17,
550 p_cei_information18 => p_cei_information18,
551 p_cei_information19 => p_cei_information19,
552 p_cei_information20 => p_cei_information20,
553 p_cei_information21 => p_cei_information21,
554 p_cei_information22 => p_cei_information22,
555 p_cei_information23 => p_cei_information23,
556 p_cei_information24 => p_cei_information24,
557 p_cei_information25 => p_cei_information25,
558 p_cei_information26 => p_cei_information26,
559 p_cei_information27 => p_cei_information27,
560 p_cei_information28 => p_cei_information28,
561 p_cei_information29 => p_cei_information29,
562 p_cei_information30 => p_cei_information30,
563 p_cei_attribute_category => p_cei_attribute_category,
564 p_cei_attribute1 => p_cei_attribute1,
565 p_cei_attribute2 => p_cei_attribute2,
566 p_cei_attribute3 => p_cei_attribute3,
567 p_cei_attribute4 => p_cei_attribute4,
568 p_cei_attribute5 => p_cei_attribute5,
569 p_cei_attribute6 => p_cei_attribute6,
570 p_cei_attribute7 => p_cei_attribute7,
571 p_cei_attribute8 => p_cei_attribute8,
572 p_cei_attribute9 => p_cei_attribute9,
573 p_cei_attribute10 => p_cei_attribute10,
574 p_cei_attribute11 => p_cei_attribute11,
575 p_cei_attribute12 => p_cei_attribute12,
576 p_cei_attribute13 => p_cei_attribute13,
577 p_cei_attribute14 => p_cei_attribute14,
578 p_cei_attribute15 => p_cei_attribute15,
579 p_cei_attribute16 => p_cei_attribute16,
580 p_cei_attribute17 => p_cei_attribute17,
581 p_cei_attribute18 => p_cei_attribute18,
582 p_cei_attribute19 => p_cei_attribute19,
583 p_cei_attribute20 => p_cei_attribute20,
584 p_effective_start_date => l_effective_start_date,
585 p_effective_end_date => l_effective_end_date);
586 --
587 -- Call After Process User Hook
588 --
589 begin
590 hr_contact_extra_info_bk2.update_contact_extra_info_a
591 (p_effective_date => p_effective_date
592 -- ,p_business_group_id => p_business_group_id
593 -- ,p_non_mandatory_arg => p_non_mandatory_arg
594 ,p_contact_extra_info_id => p_contact_extra_info_id,
595 p_contact_relationship_id => p_contact_relationship_id,
596 p_information_type => p_information_type
597 ,p_object_version_number => p_object_version_number,
598 -- ,p_some_warning => <local_var_set_in_process_logic>
599 p_datetrack_update_mode => p_datetrack_update_mode,
600 p_cei_information_category => p_cei_information_category,
601 p_cei_information1 => p_cei_information1,
602 p_cei_information2 => p_cei_information2,
603 p_cei_information3 => p_cei_information3,
604 p_cei_information4 => p_cei_information4,
605 p_cei_information5 => p_cei_information5,
606 p_cei_information6 => p_cei_information6,
607 p_cei_information7 => p_cei_information7,
608 p_cei_information8 => p_cei_information8,
609 p_cei_information9 => p_cei_information9,
610 p_cei_information10 => p_cei_information10,
611 p_cei_information11 => p_cei_information11,
612 p_cei_information12 => p_cei_information12,
613 p_cei_information13 => p_cei_information13,
614 p_cei_information14 => p_cei_information14,
615 p_cei_information15 => p_cei_information15,
616 p_cei_information16 => p_cei_information16,
617 p_cei_information17 => p_cei_information17,
618 p_cei_information18 => p_cei_information18,
619 p_cei_information19 => p_cei_information19,
620 p_cei_information20 => p_cei_information20,
621 p_cei_information21 => p_cei_information21,
622 p_cei_information22 => p_cei_information22,
623 p_cei_information23 => p_cei_information23,
624 p_cei_information24 => p_cei_information24,
625 p_cei_information25 => p_cei_information25,
626 p_cei_information26 => p_cei_information26,
627 p_cei_information27 => p_cei_information27,
628 p_cei_information28 => p_cei_information28,
629 p_cei_information29 => p_cei_information29,
630 p_cei_information30 => p_cei_information30,
631 p_cei_attribute_category => p_cei_attribute_category,
632 p_cei_attribute1 => p_cei_attribute1,
633 p_cei_attribute2 => p_cei_attribute2,
634 p_cei_attribute3 => p_cei_attribute3,
635 p_cei_attribute4 => p_cei_attribute4,
636 p_cei_attribute5 => p_cei_attribute5,
637 p_cei_attribute6 => p_cei_attribute6,
638 p_cei_attribute7 => p_cei_attribute7,
639 p_cei_attribute8 => p_cei_attribute8,
640 p_cei_attribute9 => p_cei_attribute9,
641 p_cei_attribute10 => p_cei_attribute10,
642 p_cei_attribute11 => p_cei_attribute11,
643 p_cei_attribute12 => p_cei_attribute12,
644 p_cei_attribute13 => p_cei_attribute13,
645 p_cei_attribute14 => p_cei_attribute14,
646 p_cei_attribute15 => p_cei_attribute15,
647 p_cei_attribute16 => p_cei_attribute16,
648 p_cei_attribute17 => p_cei_attribute17,
649 p_cei_attribute18 => p_cei_attribute18,
650 p_cei_attribute19 => p_cei_attribute19,
651 p_cei_attribute20 => p_cei_attribute20
652 );
653 exception
654 when hr_api.cannot_find_prog_unit then
655 hr_api.cannot_find_prog_unit_error
656 (p_module_name => 'update_contact_extra_info'
657 ,p_hook_type => 'AP'
658 );
659 end;
660 --
661 -- When in validation only mode raise the Validate_Enabled exception
662 --
663 if p_validate then
664 raise hr_api.validate_enabled;
665 end if;
666 --
667 -- Set all output arguments
668 --
669 -- p_id := <local_var_set_in_process_logic>
670 -- p_object_version_number := <local_var_set_in_process_logic>
671 -- p_some_warning := <local_var_set_in_process_logic>
672 p_effective_start_date := l_effective_start_date;
673 p_effective_end_date := l_effective_end_date;
674 --
675 hr_utility.set_location(' Leaving:'||l_proc, 70);
676 exception
677 when hr_api.validate_enabled then
678 --
679 -- As the Validate_Enabled exception has been raised
680 -- we must rollback to the savepoint
681 --
682 rollback to update_contact_extra_info;
683 --
684 -- Only set output warning arguments
685 -- (Any key or derived arguments must be set to null
686 -- when validation only mode is being used.)
687 --
688 -- p_id := null;
689 p_object_version_number := null;
690 -- p_some_warning := <local_var_set_in_process_logic>
691 p_effective_start_date := NULL;
692 p_effective_end_date := NULL;
693 hr_utility.set_location(' Leaving:'||l_proc, 80);
694 when others then
695 --
696 -- A validation or unexpected error has occured
697 --
698 p_object_version_number := l_temp_ovn;
699 p_effective_start_date := NULL;
700 p_effective_end_date := NULL;
701 rollback to update_contact_extra_info;
702 hr_utility.set_location(' Leaving:'||l_proc, 90);
703 raise;
704 end update_contact_extra_info;
705 --
706 -- ----------------------------------------------------------------------------
707 -- |----------------------< delete_contact_extra_info >-----------------------|
708 -- ----------------------------------------------------------------------------
709 --
710 procedure delete_contact_extra_info
711 (p_validate in boolean default false
712 ,p_effective_date in date,
713 -- ,p_business_group_id in number
714 -- ,p_non_mandatory_arg in number default null
715 p_datetrack_delete_mode IN VARCHAR2,
716 p_contact_extra_info_id IN NUMBER,
717 p_object_version_number IN OUT NOCOPY NUMBER,
718 -- ,p_id out number
719 -- ,p_object_version_number out number
720 -- ,p_some_warning out boolean
721 p_effective_start_date OUT NOCOPY DATE,
722 p_effective_end_date OUT NOCOPY DATE
723 ) is
724 --
725 -- Declare cursors and local variables
726 --
727 l_effective_start_date per_contact_extra_info_f.effective_start_date%TYPE;
728 l_effective_end_date per_contact_extra_info_f.effective_end_date%TYPE;
729 l_proc varchar2(72) := g_package||'delete_contact_extra_info';
730 l_temp_ovn number := p_object_version_number;
731 begin
732 hr_utility.set_location('Entering:'|| l_proc, 10);
733 --
734 -- Issue a savepoint
735 --
736 savepoint delete_contact_extra_info;
737 --
738 -- Truncate the time portion from all IN date parameters
739 --
740
741 --
742 -- Call Before Process User Hook
743 --
744 begin
745 hr_contact_extra_info_bk3.delete_contact_extra_info_b
746 (p_effective_date => p_effective_date,
747 -- ,p_business_group_id => p_business_group_id
748 -- ,p_non_mandatory_arg => p_non_mandatory_arg
749 p_contact_extra_info_id => p_contact_extra_info_id,
750 p_object_version_number => p_object_version_number,
751 p_datetrack_delete_mode => p_datetrack_delete_mode
752 );
753 exception
754 when hr_api.cannot_find_prog_unit then
755 hr_api.cannot_find_prog_unit_error
756 (p_module_name => 'delete_contact_extra_info'
757 ,p_hook_type => 'BP'
758 );
759 end;
760 --
761 -- Validation in addition to Row Handlers
762 --
763
764
765
766 --
767 -- Process Logic
768 --
769 per_rei_del.del(
770 p_effective_date => p_effective_date,
771 p_datetrack_mode => p_datetrack_delete_mode,
772 p_contact_extra_info_id => p_contact_extra_info_id,
773 p_object_version_number => p_object_version_number,
774 p_effective_start_date => l_effective_start_date,
775 p_effective_end_date => l_effective_end_date);
776 --
777 -- Call After Process User Hook
778 --
779 begin
780 hr_contact_extra_info_bk3.delete_contact_extra_info_a
781 (p_effective_date => p_effective_date
782 -- ,p_business_group_id => p_business_group_id
783 -- ,p_non_mandatory_arg => p_non_mandatory_arg
784 ,p_contact_extra_info_id => p_contact_extra_info_id
785 ,p_object_version_number => p_object_version_number,
786 -- ,p_some_warning => <local_var_set_in_process_logic>
787 p_datetrack_delete_mode => p_datetrack_delete_mode
788 );
789 exception
790 when hr_api.cannot_find_prog_unit then
791 hr_api.cannot_find_prog_unit_error
792 (p_module_name => 'delete_contact_extra_info_api'
793 ,p_hook_type => 'AP'
794 );
795 end;
796 --
797 -- When in validation only mode raise the Validate_Enabled exception
798 --
799 if p_validate then
800 raise hr_api.validate_enabled;
801 end if;
802 --
803 -- Set all output arguments
804 --
805 -- p_id := <local_var_set_in_process_logic>
806 -- p_object_version_number := <local_var_set_in_process_logic>
807 -- p_some_warning := <local_var_set_in_process_logic>
808 p_effective_start_date := l_effective_start_date;
809 p_effective_end_date := l_effective_end_date;
810 --
811 hr_utility.set_location(' Leaving:'||l_proc, 70);
812 exception
813 when hr_api.validate_enabled then
814 --
815 -- As the Validate_Enabled exception has been raised
816 -- we must rollback to the savepoint
817 --
818 rollback to delete_contact_extra_info;
819 --
820 -- Only set output warning arguments
821 -- (Any key or derived arguments must be set to null
822 -- when validation only mode is being used.)
823 --
824 -- p_id := null;
825 -- p_object_version_number := null;
826 -- p_some_warning := <local_var_set_in_process_logic>
827 p_effective_start_date := NULL;
828 p_effective_end_date := NULL;
829 hr_utility.set_location(' Leaving:'||l_proc, 80);
830 when others then
831 --
832 -- A validation or unexpected error has occured
833 --
834 p_effective_start_date := NULL;
835 p_effective_end_date := NULL;
836 p_object_version_number := l_temp_ovn;
837 rollback to delete_contact_extra_info;
838 hr_utility.set_location(' Leaving:'||l_proc, 90);
839 raise;
840 end delete_contact_extra_info;
841 --
842 end hr_contact_extra_info_api;