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