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