[Home] [Help]
PACKAGE BODY: APPS.BEN_NO_OTHR_CVG_RT_API
Source
1 Package Body ben_NO_OTHR_CVG_RT_api as
2 /* $Header: benocapi.pkb 120.0 2005/05/28 09:09:57 appldev noship $ */
3 --
4 -- Package Variables
5 --
6 g_package varchar2(33) := ' ben_NO_OTHR_CVG_RT_api.';
7 --
8 -- ----------------------------------------------------------------------------
9 -- |------------------------< create_NO_OTHR_CVG_RT >----------------------|
10 -- ----------------------------------------------------------------------------
11 --
12 procedure create_NO_OTHR_CVG_RT
13 (p_validate in boolean default false
14 ,p_no_othr_cvg_rt_id out nocopy number
15 ,p_effective_start_date out nocopy date
16 ,p_effective_end_date out nocopy date
17 ,p_coord_ben_no_cvg_flag in varchar2 default 'N'
18 ,p_vrbl_rt_prfl_id in number default null
19 ,p_business_group_id in number default null
20 ,p_noc_attribute_category in varchar2 default null
21 ,p_noc_attribute1 in varchar2 default null
22 ,p_noc_attribute2 in varchar2 default null
23 ,p_noc_attribute3 in varchar2 default null
24 ,p_noc_attribute4 in varchar2 default null
25 ,p_noc_attribute5 in varchar2 default null
26 ,p_noc_attribute6 in varchar2 default null
27 ,p_noc_attribute7 in varchar2 default null
28 ,p_noc_attribute8 in varchar2 default null
29 ,p_noc_attribute9 in varchar2 default null
30 ,p_noc_attribute10 in varchar2 default null
31 ,p_noc_attribute11 in varchar2 default null
32 ,p_noc_attribute12 in varchar2 default null
33 ,p_noc_attribute13 in varchar2 default null
34 ,p_noc_attribute14 in varchar2 default null
35 ,p_noc_attribute15 in varchar2 default null
36 ,p_noc_attribute16 in varchar2 default null
37 ,p_noc_attribute17 in varchar2 default null
38 ,p_noc_attribute18 in varchar2 default null
39 ,p_noc_attribute19 in varchar2 default null
40 ,p_noc_attribute20 in varchar2 default null
41 ,p_noc_attribute21 in varchar2 default null
42 ,p_noc_attribute22 in varchar2 default null
43 ,p_noc_attribute23 in varchar2 default null
44 ,p_noc_attribute24 in varchar2 default null
45 ,p_noc_attribute25 in varchar2 default null
46 ,p_noc_attribute26 in varchar2 default null
47 ,p_noc_attribute27 in varchar2 default null
48 ,p_noc_attribute28 in varchar2 default null
49 ,p_noc_attribute29 in varchar2 default null
50 ,p_noc_attribute30 in varchar2 default null
51 ,p_object_version_number out nocopy number
52 ,p_effective_date in date
53 ) is
54 --
55 -- Declare cursors and local variables
56 --
57 l_no_othr_cvg_rt_id ben_no_othr_cvg_rt_f.no_othr_cvg_rt_id%TYPE;
58 l_effective_start_date ben_no_othr_cvg_rt_f.effective_start_date%TYPE;
59 l_effective_end_date ben_no_othr_cvg_rt_f.effective_end_date%TYPE;
60 l_proc varchar2(72) := g_package||'create_NO_OTHR_CVG_RT';
61 l_object_version_number ben_no_othr_cvg_rt_f.object_version_number%TYPE;
62 --
63 begin
64 --
65 hr_utility.set_location('Entering:'|| l_proc, 10);
66 --
67 -- Issue a savepoint if operating in validation only mode
68 --
69 savepoint create_NO_OTHR_CVG_RT;
70 --
71 hr_utility.set_location(l_proc, 20);
72 --
73 -- Process Logic
74 --
75 begin
76 --
77 -- Start of API User Hook for the before hook of create_NO_OTHR_CVG_RT
78 --
79 ben_NO_OTHR_CVG_RT_bk1.create_NO_OTHR_CVG_RT_b
80 (
81 p_coord_ben_no_cvg_flag => p_coord_ben_no_cvg_flag
82 ,p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
83 ,p_business_group_id => p_business_group_id
84 ,p_noc_attribute_category => p_noc_attribute_category
85 ,p_noc_attribute1 => p_noc_attribute1
86 ,p_noc_attribute2 => p_noc_attribute2
87 ,p_noc_attribute3 => p_noc_attribute3
88 ,p_noc_attribute4 => p_noc_attribute4
89 ,p_noc_attribute5 => p_noc_attribute5
90 ,p_noc_attribute6 => p_noc_attribute6
91 ,p_noc_attribute7 => p_noc_attribute7
92 ,p_noc_attribute8 => p_noc_attribute8
93 ,p_noc_attribute9 => p_noc_attribute9
94 ,p_noc_attribute10 => p_noc_attribute10
95 ,p_noc_attribute11 => p_noc_attribute11
96 ,p_noc_attribute12 => p_noc_attribute12
97 ,p_noc_attribute13 => p_noc_attribute13
98 ,p_noc_attribute14 => p_noc_attribute14
99 ,p_noc_attribute15 => p_noc_attribute15
100 ,p_noc_attribute16 => p_noc_attribute16
101 ,p_noc_attribute17 => p_noc_attribute17
102 ,p_noc_attribute18 => p_noc_attribute18
103 ,p_noc_attribute19 => p_noc_attribute19
104 ,p_noc_attribute20 => p_noc_attribute20
105 ,p_noc_attribute21 => p_noc_attribute21
106 ,p_noc_attribute22 => p_noc_attribute22
107 ,p_noc_attribute23 => p_noc_attribute23
108 ,p_noc_attribute24 => p_noc_attribute24
109 ,p_noc_attribute25 => p_noc_attribute25
110 ,p_noc_attribute26 => p_noc_attribute26
111 ,p_noc_attribute27 => p_noc_attribute27
112 ,p_noc_attribute28 => p_noc_attribute28
113 ,p_noc_attribute29 => p_noc_attribute29
114 ,p_noc_attribute30 => p_noc_attribute30
115 ,p_effective_date => trunc(p_effective_date)
116 );
117 exception
118 when hr_api.cannot_find_prog_unit then
119 hr_api.cannot_find_prog_unit_error
120 (
121 p_module_name => 'CREATE_NO_OTHR_CVG_RT'
122 ,p_hook_type => 'BP'
123 );
124 --
125 -- End of API User Hook for the before hook of create_NO_OTHR_CVG_RT
126 --
127 end;
128 --
129 ben_noc_ins.ins
130 (
131 p_no_othr_cvg_rt_id => l_no_othr_cvg_rt_id
132 ,p_effective_start_date => l_effective_start_date
133 ,p_effective_end_date => l_effective_end_date
134 ,p_coord_ben_no_cvg_flag => p_coord_ben_no_cvg_flag
135 ,p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
136 ,p_business_group_id => p_business_group_id
137 ,p_noc_attribute_category => p_noc_attribute_category
138 ,p_noc_attribute1 => p_noc_attribute1
139 ,p_noc_attribute2 => p_noc_attribute2
140 ,p_noc_attribute3 => p_noc_attribute3
141 ,p_noc_attribute4 => p_noc_attribute4
142 ,p_noc_attribute5 => p_noc_attribute5
143 ,p_noc_attribute6 => p_noc_attribute6
144 ,p_noc_attribute7 => p_noc_attribute7
145 ,p_noc_attribute8 => p_noc_attribute8
146 ,p_noc_attribute9 => p_noc_attribute9
147 ,p_noc_attribute10 => p_noc_attribute10
148 ,p_noc_attribute11 => p_noc_attribute11
149 ,p_noc_attribute12 => p_noc_attribute12
150 ,p_noc_attribute13 => p_noc_attribute13
151 ,p_noc_attribute14 => p_noc_attribute14
152 ,p_noc_attribute15 => p_noc_attribute15
153 ,p_noc_attribute16 => p_noc_attribute16
154 ,p_noc_attribute17 => p_noc_attribute17
155 ,p_noc_attribute18 => p_noc_attribute18
156 ,p_noc_attribute19 => p_noc_attribute19
157 ,p_noc_attribute20 => p_noc_attribute20
158 ,p_noc_attribute21 => p_noc_attribute21
159 ,p_noc_attribute22 => p_noc_attribute22
160 ,p_noc_attribute23 => p_noc_attribute23
161 ,p_noc_attribute24 => p_noc_attribute24
162 ,p_noc_attribute25 => p_noc_attribute25
163 ,p_noc_attribute26 => p_noc_attribute26
164 ,p_noc_attribute27 => p_noc_attribute27
165 ,p_noc_attribute28 => p_noc_attribute28
166 ,p_noc_attribute29 => p_noc_attribute29
167 ,p_noc_attribute30 => p_noc_attribute30
168 ,p_object_version_number => l_object_version_number
169 ,p_effective_date => trunc(p_effective_date)
170 );
171 --
172 begin
173 --
174 -- Start of API User Hook for the after hook of create_NO_OTHR_CVG_RT
175 --
176 ben_NO_OTHR_CVG_RT_bk1.create_NO_OTHR_CVG_RT_a
177 (
178 p_no_othr_cvg_rt_id => l_no_othr_cvg_rt_id
179 ,p_effective_start_date => l_effective_start_date
180 ,p_effective_end_date => l_effective_end_date
181 ,p_coord_ben_no_cvg_flag => p_coord_ben_no_cvg_flag
182 ,p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
183 ,p_business_group_id => p_business_group_id
184 ,p_noc_attribute_category => p_noc_attribute_category
185 ,p_noc_attribute1 => p_noc_attribute1
186 ,p_noc_attribute2 => p_noc_attribute2
187 ,p_noc_attribute3 => p_noc_attribute3
188 ,p_noc_attribute4 => p_noc_attribute4
189 ,p_noc_attribute5 => p_noc_attribute5
190 ,p_noc_attribute6 => p_noc_attribute6
191 ,p_noc_attribute7 => p_noc_attribute7
192 ,p_noc_attribute8 => p_noc_attribute8
193 ,p_noc_attribute9 => p_noc_attribute9
194 ,p_noc_attribute10 => p_noc_attribute10
195 ,p_noc_attribute11 => p_noc_attribute11
196 ,p_noc_attribute12 => p_noc_attribute12
197 ,p_noc_attribute13 => p_noc_attribute13
198 ,p_noc_attribute14 => p_noc_attribute14
199 ,p_noc_attribute15 => p_noc_attribute15
200 ,p_noc_attribute16 => p_noc_attribute16
201 ,p_noc_attribute17 => p_noc_attribute17
202 ,p_noc_attribute18 => p_noc_attribute18
203 ,p_noc_attribute19 => p_noc_attribute19
204 ,p_noc_attribute20 => p_noc_attribute20
205 ,p_noc_attribute21 => p_noc_attribute21
206 ,p_noc_attribute22 => p_noc_attribute22
207 ,p_noc_attribute23 => p_noc_attribute23
208 ,p_noc_attribute24 => p_noc_attribute24
209 ,p_noc_attribute25 => p_noc_attribute25
210 ,p_noc_attribute26 => p_noc_attribute26
211 ,p_noc_attribute27 => p_noc_attribute27
212 ,p_noc_attribute28 => p_noc_attribute28
213 ,p_noc_attribute29 => p_noc_attribute29
214 ,p_noc_attribute30 => p_noc_attribute30
215 ,p_object_version_number => l_object_version_number
216 ,p_effective_date => trunc(p_effective_date)
217 );
218 exception
219 when hr_api.cannot_find_prog_unit then
220 hr_api.cannot_find_prog_unit_error
221 (p_module_name => 'CREATE_NO_OTHR_CVG_RT'
222 ,p_hook_type => 'AP'
223 );
224 --
225 -- End of API User Hook for the after hook of create_NO_OTHR_CVG_RT
226 --
227 end;
228 --
229 ben_profile_handler.event_handler
230 (p_event => 'CREATE',
231 p_base_table => 'BEN_VRBL_RT_PRFL_F',
232 p_base_table_column => 'VRBL_RT_PRFL_ID',
233 p_base_table_column_value => p_vrbl_rt_prfl_id,
234 p_base_table_reference_column => 'RT_NO_OTHR_CVG_FLAG',
235 p_reference_table => 'BEN_NO_OTHR_CVG_RT_F',
236 p_reference_table_column => 'VRBL_RT_PRFL_ID');
237 --
238 hr_utility.set_location(l_proc, 60);
239 --
240 -- When in validation only mode raise the Validate_Enabled exception
241 --
242 if p_validate then
243 raise hr_api.validate_enabled;
244 end if;
245 --
246 -- Set all output arguments
247 --
248 p_no_othr_cvg_rt_id := l_no_othr_cvg_rt_id;
249 p_effective_start_date := l_effective_start_date;
250 p_effective_end_date := l_effective_end_date;
251 p_object_version_number := l_object_version_number;
252 --
253 hr_utility.set_location(' Leaving:'||l_proc, 70);
254 --
255 exception
256 --
257 when hr_api.validate_enabled then
258 --
259 -- As the Validate_Enabled exception has been raised
260 -- we must rollback to the savepoint
261 --
262 ROLLBACK TO create_NO_OTHR_CVG_RT;
263 --
264 -- Only set output warning arguments
265 -- (Any key or derived arguments must be set to null
266 -- when validation only mode is being used.)
267 --
268 p_no_othr_cvg_rt_id := null;
269 p_effective_start_date := null;
270 p_effective_end_date := null;
271 p_object_version_number := null;
272 hr_utility.set_location(' Leaving:'||l_proc, 80);
273 --
274 when others then
275 --
276 -- A validation or unexpected error has occured
277 --
278 ROLLBACK TO create_NO_OTHR_CVG_RT;
279 p_no_othr_cvg_rt_id := null;
280 p_effective_start_date := null;
281 p_effective_end_date := null;
282 p_object_version_number := null;
283
284 raise;
285 --
286 end create_NO_OTHR_CVG_RT;
287 -- ----------------------------------------------------------------------------
288 -- |------------------------< update_NO_OTHR_CVG_RT >--- ------------------|
289 -- ----------------------------------------------------------------------------
290 --
291 procedure update_NO_OTHR_CVG_RT
292 (p_validate in boolean default false
293 ,p_no_othr_cvg_rt_id in number
294 ,p_effective_start_date out nocopy date
295 ,p_effective_end_date out nocopy date
296 ,p_coord_ben_no_cvg_flag in varchar2 default hr_api.g_varchar2
297 ,p_vrbl_rt_prfl_id in number default hr_api.g_number
298 ,p_business_group_id in number default hr_api.g_number
299 ,p_noc_attribute_category in varchar2 default hr_api.g_varchar2
300 ,p_noc_attribute1 in varchar2 default hr_api.g_varchar2
301 ,p_noc_attribute2 in varchar2 default hr_api.g_varchar2
302 ,p_noc_attribute3 in varchar2 default hr_api.g_varchar2
303 ,p_noc_attribute4 in varchar2 default hr_api.g_varchar2
304 ,p_noc_attribute5 in varchar2 default hr_api.g_varchar2
305 ,p_noc_attribute6 in varchar2 default hr_api.g_varchar2
306 ,p_noc_attribute7 in varchar2 default hr_api.g_varchar2
307 ,p_noc_attribute8 in varchar2 default hr_api.g_varchar2
308 ,p_noc_attribute9 in varchar2 default hr_api.g_varchar2
309 ,p_noc_attribute10 in varchar2 default hr_api.g_varchar2
310 ,p_noc_attribute11 in varchar2 default hr_api.g_varchar2
311 ,p_noc_attribute12 in varchar2 default hr_api.g_varchar2
312 ,p_noc_attribute13 in varchar2 default hr_api.g_varchar2
313 ,p_noc_attribute14 in varchar2 default hr_api.g_varchar2
314 ,p_noc_attribute15 in varchar2 default hr_api.g_varchar2
315 ,p_noc_attribute16 in varchar2 default hr_api.g_varchar2
316 ,p_noc_attribute17 in varchar2 default hr_api.g_varchar2
317 ,p_noc_attribute18 in varchar2 default hr_api.g_varchar2
318 ,p_noc_attribute19 in varchar2 default hr_api.g_varchar2
319 ,p_noc_attribute20 in varchar2 default hr_api.g_varchar2
320 ,p_noc_attribute21 in varchar2 default hr_api.g_varchar2
321 ,p_noc_attribute22 in varchar2 default hr_api.g_varchar2
322 ,p_noc_attribute23 in varchar2 default hr_api.g_varchar2
323 ,p_noc_attribute24 in varchar2 default hr_api.g_varchar2
324 ,p_noc_attribute25 in varchar2 default hr_api.g_varchar2
325 ,p_noc_attribute26 in varchar2 default hr_api.g_varchar2
326 ,p_noc_attribute27 in varchar2 default hr_api.g_varchar2
327 ,p_noc_attribute28 in varchar2 default hr_api.g_varchar2
328 ,p_noc_attribute29 in varchar2 default hr_api.g_varchar2
329 ,p_noc_attribute30 in varchar2 default hr_api.g_varchar2
330 ,p_object_version_number in out nocopy number
331 ,p_effective_date in date
332 ,p_datetrack_mode in varchar2
333 ) is
334 --
335 -- Declare cursors and local variables
336 --
337 l_proc varchar2(72) := g_package||'update_NO_OTHR_CVG_RT';
338 l_object_version_number ben_no_othr_cvg_rt_f.object_version_number%TYPE;
339 l_effective_start_date ben_no_othr_cvg_rt_f.effective_start_date%TYPE;
340 l_effective_end_date ben_no_othr_cvg_rt_f.effective_end_date%TYPE;
341 --
342 begin
343 --
344 hr_utility.set_location('Entering:'|| l_proc, 10);
345 --
346 -- Issue a savepoint if operating in validation only mode
347 --
348 savepoint update_NO_OTHR_CVG_RT;
349 --
350 hr_utility.set_location(l_proc, 20);
351 --
352 -- Process Logic
353 --
354 l_object_version_number := p_object_version_number;
355 --
356 begin
357 --
358 -- Start of API User Hook for the before hook of update_NO_OTHR_CVG_RT
359 --
360 ben_NO_OTHR_CVG_RT_bk2.update_NO_OTHR_CVG_RT_b
361 (
362 p_no_othr_cvg_rt_id => p_no_othr_cvg_rt_id
363 ,p_coord_ben_no_cvg_flag => p_coord_ben_no_cvg_flag
364 ,p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
365 ,p_business_group_id => p_business_group_id
366 ,p_noc_attribute_category => p_noc_attribute_category
367 ,p_noc_attribute1 => p_noc_attribute1
368 ,p_noc_attribute2 => p_noc_attribute2
369 ,p_noc_attribute3 => p_noc_attribute3
370 ,p_noc_attribute4 => p_noc_attribute4
371 ,p_noc_attribute5 => p_noc_attribute5
372 ,p_noc_attribute6 => p_noc_attribute6
373 ,p_noc_attribute7 => p_noc_attribute7
374 ,p_noc_attribute8 => p_noc_attribute8
375 ,p_noc_attribute9 => p_noc_attribute9
376 ,p_noc_attribute10 => p_noc_attribute10
377 ,p_noc_attribute11 => p_noc_attribute11
378 ,p_noc_attribute12 => p_noc_attribute12
379 ,p_noc_attribute13 => p_noc_attribute13
380 ,p_noc_attribute14 => p_noc_attribute14
381 ,p_noc_attribute15 => p_noc_attribute15
382 ,p_noc_attribute16 => p_noc_attribute16
383 ,p_noc_attribute17 => p_noc_attribute17
384 ,p_noc_attribute18 => p_noc_attribute18
385 ,p_noc_attribute19 => p_noc_attribute19
386 ,p_noc_attribute20 => p_noc_attribute20
387 ,p_noc_attribute21 => p_noc_attribute21
388 ,p_noc_attribute22 => p_noc_attribute22
389 ,p_noc_attribute23 => p_noc_attribute23
390 ,p_noc_attribute24 => p_noc_attribute24
391 ,p_noc_attribute25 => p_noc_attribute25
392 ,p_noc_attribute26 => p_noc_attribute26
393 ,p_noc_attribute27 => p_noc_attribute27
394 ,p_noc_attribute28 => p_noc_attribute28
395 ,p_noc_attribute29 => p_noc_attribute29
396 ,p_noc_attribute30 => p_noc_attribute30
397 ,p_object_version_number => p_object_version_number
398 ,p_effective_date => trunc(p_effective_date)
399 ,p_datetrack_mode => p_datetrack_mode
400 );
401 exception
402 when hr_api.cannot_find_prog_unit then
403 hr_api.cannot_find_prog_unit_error
404 (p_module_name => 'UPDATE_NO_OTHR_CVG_RT'
405 ,p_hook_type => 'BP'
406 );
407 --
408 -- End of API User Hook for the before hook of update_NO_OTHR_CVG_RT
409 --
410 end;
411 --
412 ben_noc_upd.upd
413 (
414 p_no_othr_cvg_rt_id => p_no_othr_cvg_rt_id
415 ,p_effective_start_date => l_effective_start_date
416 ,p_effective_end_date => l_effective_end_date
417 ,p_coord_ben_no_cvg_flag => p_coord_ben_no_cvg_flag
418 ,p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
419 ,p_business_group_id => p_business_group_id
420 ,p_noc_attribute_category => p_noc_attribute_category
421 ,p_noc_attribute1 => p_noc_attribute1
422 ,p_noc_attribute2 => p_noc_attribute2
423 ,p_noc_attribute3 => p_noc_attribute3
424 ,p_noc_attribute4 => p_noc_attribute4
425 ,p_noc_attribute5 => p_noc_attribute5
426 ,p_noc_attribute6 => p_noc_attribute6
427 ,p_noc_attribute7 => p_noc_attribute7
428 ,p_noc_attribute8 => p_noc_attribute8
429 ,p_noc_attribute9 => p_noc_attribute9
430 ,p_noc_attribute10 => p_noc_attribute10
431 ,p_noc_attribute11 => p_noc_attribute11
432 ,p_noc_attribute12 => p_noc_attribute12
433 ,p_noc_attribute13 => p_noc_attribute13
434 ,p_noc_attribute14 => p_noc_attribute14
435 ,p_noc_attribute15 => p_noc_attribute15
436 ,p_noc_attribute16 => p_noc_attribute16
437 ,p_noc_attribute17 => p_noc_attribute17
438 ,p_noc_attribute18 => p_noc_attribute18
439 ,p_noc_attribute19 => p_noc_attribute19
440 ,p_noc_attribute20 => p_noc_attribute20
441 ,p_noc_attribute21 => p_noc_attribute21
442 ,p_noc_attribute22 => p_noc_attribute22
443 ,p_noc_attribute23 => p_noc_attribute23
444 ,p_noc_attribute24 => p_noc_attribute24
445 ,p_noc_attribute25 => p_noc_attribute25
446 ,p_noc_attribute26 => p_noc_attribute26
447 ,p_noc_attribute27 => p_noc_attribute27
448 ,p_noc_attribute28 => p_noc_attribute28
449 ,p_noc_attribute29 => p_noc_attribute29
450 ,p_noc_attribute30 => p_noc_attribute30
451 ,p_object_version_number => l_object_version_number
452 ,p_effective_date => trunc(p_effective_date)
453 ,p_datetrack_mode => p_datetrack_mode
454 );
455 --
456 begin
457 --
458 -- Start of API User Hook for the after hook of update_NO_OTHR_CVG_RT
459 --
460 ben_NO_OTHR_CVG_RT_bk2.update_NO_OTHR_CVG_RT_a
461 (
462 p_no_othr_cvg_rt_id => p_no_othr_cvg_rt_id
463 ,p_effective_start_date => l_effective_start_date
464 ,p_effective_end_date => l_effective_end_date
465 ,p_coord_ben_no_cvg_flag => p_coord_ben_no_cvg_flag
466 ,p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
467 ,p_business_group_id => p_business_group_id
468 ,p_noc_attribute_category => p_noc_attribute_category
469 ,p_noc_attribute1 => p_noc_attribute1
470 ,p_noc_attribute2 => p_noc_attribute2
471 ,p_noc_attribute3 => p_noc_attribute3
472 ,p_noc_attribute4 => p_noc_attribute4
473 ,p_noc_attribute5 => p_noc_attribute5
474 ,p_noc_attribute6 => p_noc_attribute6
475 ,p_noc_attribute7 => p_noc_attribute7
476 ,p_noc_attribute8 => p_noc_attribute8
477 ,p_noc_attribute9 => p_noc_attribute9
478 ,p_noc_attribute10 => p_noc_attribute10
479 ,p_noc_attribute11 => p_noc_attribute11
480 ,p_noc_attribute12 => p_noc_attribute12
481 ,p_noc_attribute13 => p_noc_attribute13
482 ,p_noc_attribute14 => p_noc_attribute14
483 ,p_noc_attribute15 => p_noc_attribute15
484 ,p_noc_attribute16 => p_noc_attribute16
485 ,p_noc_attribute17 => p_noc_attribute17
486 ,p_noc_attribute18 => p_noc_attribute18
487 ,p_noc_attribute19 => p_noc_attribute19
488 ,p_noc_attribute20 => p_noc_attribute20
489 ,p_noc_attribute21 => p_noc_attribute21
490 ,p_noc_attribute22 => p_noc_attribute22
491 ,p_noc_attribute23 => p_noc_attribute23
492 ,p_noc_attribute24 => p_noc_attribute24
493 ,p_noc_attribute25 => p_noc_attribute25
494 ,p_noc_attribute26 => p_noc_attribute26
495 ,p_noc_attribute27 => p_noc_attribute27
496 ,p_noc_attribute28 => p_noc_attribute28
497 ,p_noc_attribute29 => p_noc_attribute29
498 ,p_noc_attribute30 => p_noc_attribute30
499 ,p_object_version_number => l_object_version_number
500 ,p_effective_date => trunc(p_effective_date)
501 ,p_datetrack_mode => p_datetrack_mode
502 );
503 exception
504 when hr_api.cannot_find_prog_unit then
505 hr_api.cannot_find_prog_unit_error
506 (p_module_name => 'UPDATE_NO_OTHR_CVG_RT'
507 ,p_hook_type => 'AP'
508 );
509 --
510 -- End of API User Hook for the after hook of update_NO_OTHR_CVG_RT
511 --
512 end;
513 --
514 hr_utility.set_location(l_proc, 60);
515 --
516 -- When in validation only mode raise the Validate_Enabled exception
517 --
518 if p_validate then
519 raise hr_api.validate_enabled;
520 end if;
521 --
522 -- Set all output arguments
523 --
524 p_object_version_number := l_object_version_number;
525 p_effective_start_date := l_effective_start_date;
526 p_effective_end_date := l_effective_end_date;
527 --
528 hr_utility.set_location(' Leaving:'||l_proc, 70);
529 --
530 exception
531 --
532 when hr_api.validate_enabled then
533 --
534 -- As the Validate_Enabled exception has been raised
535 -- we must rollback to the savepoint
536 --
537 ROLLBACK TO update_NO_OTHR_CVG_RT;
538 --
539 -- Only set output warning arguments
540 -- (Any key or derived arguments must be set to null
541 -- when validation only mode is being used.)
542 --
543 hr_utility.set_location(' Leaving:'||l_proc, 80);
544 --
545 when others then
546 --
547 -- A validation or unexpected error has occured
548 --
549 ROLLBACK TO update_NO_OTHR_CVG_RT;
550 p_effective_start_date := null;
551 p_effective_end_date := null;
552 p_object_version_number := l_object_version_number;
553
554 raise;
555 --
556 end update_NO_OTHR_CVG_RT;
557 -- ----------------------------------------------------------------------------
558 -- |------------------------< delete_NO_OTHR_CVG_RT >----------------------|
559 -- ----------------------------------------------------------------------------
560 --
561 procedure delete_NO_OTHR_CVG_RT
562 (p_validate in boolean default false
563 ,p_no_othr_cvg_rt_id in number
564 ,p_effective_start_date out nocopy date
565 ,p_effective_end_date out nocopy date
566 ,p_object_version_number in out nocopy number
567 ,p_effective_date in date
568 ,p_datetrack_mode in varchar2
569 ) is
570 --
571 -- Declare cursors and local variables
572 --
573 l_proc varchar2(72) := g_package||'update_NO_OTHR_CVG_RT';
574 l_object_version_number ben_no_othr_cvg_rt_f.object_version_number%TYPE;
575 l_effective_start_date ben_no_othr_cvg_rt_f.effective_start_date%TYPE;
576 l_effective_end_date ben_no_othr_cvg_rt_f.effective_end_date%TYPE;
577 --
578 begin
579 --
580 hr_utility.set_location('Entering:'|| l_proc, 10);
581 --
582 -- Issue a savepoint if operating in validation only mode
583 --
584 savepoint delete_NO_OTHR_CVG_RT;
585 --
586 hr_utility.set_location(l_proc, 20);
587 --
588 -- Process Logic
589 --
590 l_object_version_number := p_object_version_number;
591 --
592 --
593 begin
594 --
595 -- Start of API User Hook for the before hook of delete_NO_OTHR_CVG_RT
596 --
597 ben_NO_OTHR_CVG_RT_bk3.delete_NO_OTHR_CVG_RT_b
598 (
599 p_no_othr_cvg_rt_id => p_no_othr_cvg_rt_id
600 ,p_object_version_number => p_object_version_number
601 ,p_effective_date => trunc(p_effective_date)
602 ,p_datetrack_mode => p_datetrack_mode
603 );
604 exception
605 when hr_api.cannot_find_prog_unit then
606 hr_api.cannot_find_prog_unit_error
607 (p_module_name => 'DELETE_NO_OTHR_CVG_RT'
608 ,p_hook_type => 'BP'
609 );
610 --
611 -- End of API User Hook for the before hook of delete_NO_OTHR_CVG_RT
612 --
613 end;
614 --
615 ben_noc_del.del
616 (
617 p_no_othr_cvg_rt_id => p_no_othr_cvg_rt_id
618 ,p_effective_start_date => l_effective_start_date
619 ,p_effective_end_date => l_effective_end_date
620 ,p_object_version_number => l_object_version_number
621 ,p_effective_date => p_effective_date
622 ,p_datetrack_mode => p_datetrack_mode
623 );
624 --
625 begin
626 --
627 -- Start of API User Hook for the after hook of delete_NO_OTHR_CVG_RT
628 --
629 ben_NO_OTHR_CVG_RT_bk3.delete_NO_OTHR_CVG_RT_a
630 (
631 p_no_othr_cvg_rt_id => p_no_othr_cvg_rt_id
632 ,p_effective_start_date => l_effective_start_date
633 ,p_effective_end_date => l_effective_end_date
634 ,p_object_version_number => l_object_version_number
635 ,p_effective_date => trunc(p_effective_date)
636 ,p_datetrack_mode => p_datetrack_mode
637 );
638 exception
639 when hr_api.cannot_find_prog_unit then
640 hr_api.cannot_find_prog_unit_error
641 (p_module_name => 'DELETE_NO_OTHR_CVG_RT'
642 ,p_hook_type => 'AP'
643 );
644 --
645 -- End of API User Hook for the after hook of delete_NO_OTHR_CVG_RT
646 --
647 end;
648 --
649 ben_profile_handler.event_handler
650 (p_event => 'DELETE',
651 p_base_table => 'BEN_VRBL_RT_PRFL_F',
652 p_base_table_column => 'VRBL_RT_PRFL_ID',
653 p_base_table_column_value => ben_noc_shd.g_old_rec.vrbl_rt_prfl_id,
654 p_base_table_reference_column => 'RT_NO_OTHR_CVG_FLAG',
655 p_reference_table => 'BEN_NO_OTHR_CVG_RT_F',
656 p_reference_table_column => 'VRBL_RT_PRFL_ID');
657 --
658 hr_utility.set_location(l_proc, 60);
659 --
660 -- When in validation only mode raise the Validate_Enabled exception
661 --
662 if p_validate then
663 raise hr_api.validate_enabled;
664 end if;
665 --
666 hr_utility.set_location(' Leaving:'||l_proc, 70);
667 --
668 exception
669 --
670 when hr_api.validate_enabled then
671 --
672 -- As the Validate_Enabled exception has been raised
673 -- we must rollback to the savepoint
674 --
675 ROLLBACK TO delete_NO_OTHR_CVG_RT;
676 --
677 -- Only set output warning arguments
678 -- (Any key or derived arguments must be set to null
679 -- when validation only mode is being used.)
680 --
681 p_effective_start_date := null;
682 p_effective_end_date := null;
683 --
684 when others then
685 --
686 -- A validation or unexpected error has occured
687 --
688 ROLLBACK TO delete_NO_OTHR_CVG_RT;
689 p_effective_start_date := null;
690 p_effective_end_date := null;
691 p_object_version_number := l_object_version_number;
692
693 raise;
694 --
695 end delete_NO_OTHR_CVG_RT;
696 --
697 -- ----------------------------------------------------------------------------
698 -- |-------------------------------< lck >------------------------------------|
699 -- ----------------------------------------------------------------------------
700 --
701 procedure lck
702 (
703 p_no_othr_cvg_rt_id in number
704 ,p_object_version_number in number
705 ,p_effective_date in date
706 ,p_datetrack_mode in varchar2
707 ,p_validation_start_date out nocopy date
708 ,p_validation_end_date out nocopy date
709 ) is
710 --
711 --
712 -- Declare cursors and local variables
713 --
714 l_proc varchar2(72) := g_package||'lck';
715 l_validation_start_date date;
716 l_validation_end_date date;
717 --
718 begin
719 --
720 hr_utility.set_location('Entering:'|| l_proc, 10);
721 --
722 ben_noc_shd.lck
723 (
724 p_no_othr_cvg_rt_id => p_no_othr_cvg_rt_id
725 ,p_validation_start_date => l_validation_start_date
726 ,p_validation_end_date => l_validation_end_date
727 ,p_object_version_number => p_object_version_number
728 ,p_effective_date => p_effective_date
729 ,p_datetrack_mode => p_datetrack_mode
730 );
731 --
732 hr_utility.set_location(' Leaving:'||l_proc, 70);
733 --
734 end lck;
735 --
736 end ben_NO_OTHR_CVG_RT_api;