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