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