96: ,p_bep_attribute20 => p_bep_attribute20
97: ,p_effective_date => trunc(p_effective_date)
98: );
99: exception
100: when hr_api.cannot_find_prog_unit then
101: hr_api.cannot_find_prog_unit_error
102: (
103: p_module_name => 'CREATE_ELIG_OBJ_ELIG_PROFL'
104: ,p_hook_type => 'BP'
97: ,p_effective_date => trunc(p_effective_date)
98: );
99: exception
100: when hr_api.cannot_find_prog_unit then
101: hr_api.cannot_find_prog_unit_error
102: (
103: p_module_name => 'CREATE_ELIG_OBJ_ELIG_PROFL'
104: ,p_hook_type => 'BP'
105: );
179: ,p_object_version_number => l_object_version_number
180: ,p_effective_date => trunc(p_effective_date)
181: );
182: exception
183: when hr_api.cannot_find_prog_unit then
184: hr_api.cannot_find_prog_unit_error
185: (p_module_name => 'CREATE_ELIG_OBJ_ELIG_PROFL'
186: ,p_hook_type => 'AP'
187: );
180: ,p_effective_date => trunc(p_effective_date)
181: );
182: exception
183: when hr_api.cannot_find_prog_unit then
184: hr_api.cannot_find_prog_unit_error
185: (p_module_name => 'CREATE_ELIG_OBJ_ELIG_PROFL'
186: ,p_hook_type => 'AP'
187: );
188: --
194: --
195: -- When in validation only mode raise the Validate_Enabled exception
196: --
197: if p_validate then
198: raise hr_api.validate_enabled;
199: end if;
200: --
201: -- Set all output arguments
202: --
208: hr_utility.set_location(' Leaving:'||l_proc, 70);
209: --
210: exception
211: --
212: when hr_api.validate_enabled then
213: --
214: -- As the Validate_Enabled exception has been raised
215: -- we must rollback to the savepoint
216: --
242: (p_validate in boolean default false
243: ,p_elig_obj_elig_prfl_id in number
244: ,p_effective_start_date out nocopy date
245: ,p_effective_end_date out nocopy date
246: ,p_business_group_id in number default hr_api.g_number
247: ,p_elig_obj_id in number default hr_api.g_number
248: ,p_elig_prfl_id in number default hr_api.g_number
249: ,p_mndtry_flag in varchar2 default hr_api.g_varchar2
250: ,p_bep_attribute_category in varchar2 default hr_api.g_varchar2
243: ,p_elig_obj_elig_prfl_id in number
244: ,p_effective_start_date out nocopy date
245: ,p_effective_end_date out nocopy date
246: ,p_business_group_id in number default hr_api.g_number
247: ,p_elig_obj_id in number default hr_api.g_number
248: ,p_elig_prfl_id in number default hr_api.g_number
249: ,p_mndtry_flag in varchar2 default hr_api.g_varchar2
250: ,p_bep_attribute_category in varchar2 default hr_api.g_varchar2
251: ,p_bep_attribute1 in varchar2 default hr_api.g_varchar2
244: ,p_effective_start_date out nocopy date
245: ,p_effective_end_date out nocopy date
246: ,p_business_group_id in number default hr_api.g_number
247: ,p_elig_obj_id in number default hr_api.g_number
248: ,p_elig_prfl_id in number default hr_api.g_number
249: ,p_mndtry_flag in varchar2 default hr_api.g_varchar2
250: ,p_bep_attribute_category in varchar2 default hr_api.g_varchar2
251: ,p_bep_attribute1 in varchar2 default hr_api.g_varchar2
252: ,p_bep_attribute2 in varchar2 default hr_api.g_varchar2
245: ,p_effective_end_date out nocopy date
246: ,p_business_group_id in number default hr_api.g_number
247: ,p_elig_obj_id in number default hr_api.g_number
248: ,p_elig_prfl_id in number default hr_api.g_number
249: ,p_mndtry_flag in varchar2 default hr_api.g_varchar2
250: ,p_bep_attribute_category in varchar2 default hr_api.g_varchar2
251: ,p_bep_attribute1 in varchar2 default hr_api.g_varchar2
252: ,p_bep_attribute2 in varchar2 default hr_api.g_varchar2
253: ,p_bep_attribute3 in varchar2 default hr_api.g_varchar2
246: ,p_business_group_id in number default hr_api.g_number
247: ,p_elig_obj_id in number default hr_api.g_number
248: ,p_elig_prfl_id in number default hr_api.g_number
249: ,p_mndtry_flag in varchar2 default hr_api.g_varchar2
250: ,p_bep_attribute_category in varchar2 default hr_api.g_varchar2
251: ,p_bep_attribute1 in varchar2 default hr_api.g_varchar2
252: ,p_bep_attribute2 in varchar2 default hr_api.g_varchar2
253: ,p_bep_attribute3 in varchar2 default hr_api.g_varchar2
254: ,p_bep_attribute4 in varchar2 default hr_api.g_varchar2
247: ,p_elig_obj_id in number default hr_api.g_number
248: ,p_elig_prfl_id in number default hr_api.g_number
249: ,p_mndtry_flag in varchar2 default hr_api.g_varchar2
250: ,p_bep_attribute_category in varchar2 default hr_api.g_varchar2
251: ,p_bep_attribute1 in varchar2 default hr_api.g_varchar2
252: ,p_bep_attribute2 in varchar2 default hr_api.g_varchar2
253: ,p_bep_attribute3 in varchar2 default hr_api.g_varchar2
254: ,p_bep_attribute4 in varchar2 default hr_api.g_varchar2
255: ,p_bep_attribute5 in varchar2 default hr_api.g_varchar2
248: ,p_elig_prfl_id in number default hr_api.g_number
249: ,p_mndtry_flag in varchar2 default hr_api.g_varchar2
250: ,p_bep_attribute_category in varchar2 default hr_api.g_varchar2
251: ,p_bep_attribute1 in varchar2 default hr_api.g_varchar2
252: ,p_bep_attribute2 in varchar2 default hr_api.g_varchar2
253: ,p_bep_attribute3 in varchar2 default hr_api.g_varchar2
254: ,p_bep_attribute4 in varchar2 default hr_api.g_varchar2
255: ,p_bep_attribute5 in varchar2 default hr_api.g_varchar2
256: ,p_bep_attribute6 in varchar2 default hr_api.g_varchar2
249: ,p_mndtry_flag in varchar2 default hr_api.g_varchar2
250: ,p_bep_attribute_category in varchar2 default hr_api.g_varchar2
251: ,p_bep_attribute1 in varchar2 default hr_api.g_varchar2
252: ,p_bep_attribute2 in varchar2 default hr_api.g_varchar2
253: ,p_bep_attribute3 in varchar2 default hr_api.g_varchar2
254: ,p_bep_attribute4 in varchar2 default hr_api.g_varchar2
255: ,p_bep_attribute5 in varchar2 default hr_api.g_varchar2
256: ,p_bep_attribute6 in varchar2 default hr_api.g_varchar2
257: ,p_bep_attribute7 in varchar2 default hr_api.g_varchar2
250: ,p_bep_attribute_category in varchar2 default hr_api.g_varchar2
251: ,p_bep_attribute1 in varchar2 default hr_api.g_varchar2
252: ,p_bep_attribute2 in varchar2 default hr_api.g_varchar2
253: ,p_bep_attribute3 in varchar2 default hr_api.g_varchar2
254: ,p_bep_attribute4 in varchar2 default hr_api.g_varchar2
255: ,p_bep_attribute5 in varchar2 default hr_api.g_varchar2
256: ,p_bep_attribute6 in varchar2 default hr_api.g_varchar2
257: ,p_bep_attribute7 in varchar2 default hr_api.g_varchar2
258: ,p_bep_attribute8 in varchar2 default hr_api.g_varchar2
251: ,p_bep_attribute1 in varchar2 default hr_api.g_varchar2
252: ,p_bep_attribute2 in varchar2 default hr_api.g_varchar2
253: ,p_bep_attribute3 in varchar2 default hr_api.g_varchar2
254: ,p_bep_attribute4 in varchar2 default hr_api.g_varchar2
255: ,p_bep_attribute5 in varchar2 default hr_api.g_varchar2
256: ,p_bep_attribute6 in varchar2 default hr_api.g_varchar2
257: ,p_bep_attribute7 in varchar2 default hr_api.g_varchar2
258: ,p_bep_attribute8 in varchar2 default hr_api.g_varchar2
259: ,p_bep_attribute9 in varchar2 default hr_api.g_varchar2
252: ,p_bep_attribute2 in varchar2 default hr_api.g_varchar2
253: ,p_bep_attribute3 in varchar2 default hr_api.g_varchar2
254: ,p_bep_attribute4 in varchar2 default hr_api.g_varchar2
255: ,p_bep_attribute5 in varchar2 default hr_api.g_varchar2
256: ,p_bep_attribute6 in varchar2 default hr_api.g_varchar2
257: ,p_bep_attribute7 in varchar2 default hr_api.g_varchar2
258: ,p_bep_attribute8 in varchar2 default hr_api.g_varchar2
259: ,p_bep_attribute9 in varchar2 default hr_api.g_varchar2
260: ,p_bep_attribute10 in varchar2 default hr_api.g_varchar2
253: ,p_bep_attribute3 in varchar2 default hr_api.g_varchar2
254: ,p_bep_attribute4 in varchar2 default hr_api.g_varchar2
255: ,p_bep_attribute5 in varchar2 default hr_api.g_varchar2
256: ,p_bep_attribute6 in varchar2 default hr_api.g_varchar2
257: ,p_bep_attribute7 in varchar2 default hr_api.g_varchar2
258: ,p_bep_attribute8 in varchar2 default hr_api.g_varchar2
259: ,p_bep_attribute9 in varchar2 default hr_api.g_varchar2
260: ,p_bep_attribute10 in varchar2 default hr_api.g_varchar2
261: ,p_bep_attribute11 in varchar2 default hr_api.g_varchar2
254: ,p_bep_attribute4 in varchar2 default hr_api.g_varchar2
255: ,p_bep_attribute5 in varchar2 default hr_api.g_varchar2
256: ,p_bep_attribute6 in varchar2 default hr_api.g_varchar2
257: ,p_bep_attribute7 in varchar2 default hr_api.g_varchar2
258: ,p_bep_attribute8 in varchar2 default hr_api.g_varchar2
259: ,p_bep_attribute9 in varchar2 default hr_api.g_varchar2
260: ,p_bep_attribute10 in varchar2 default hr_api.g_varchar2
261: ,p_bep_attribute11 in varchar2 default hr_api.g_varchar2
262: ,p_bep_attribute12 in varchar2 default hr_api.g_varchar2
255: ,p_bep_attribute5 in varchar2 default hr_api.g_varchar2
256: ,p_bep_attribute6 in varchar2 default hr_api.g_varchar2
257: ,p_bep_attribute7 in varchar2 default hr_api.g_varchar2
258: ,p_bep_attribute8 in varchar2 default hr_api.g_varchar2
259: ,p_bep_attribute9 in varchar2 default hr_api.g_varchar2
260: ,p_bep_attribute10 in varchar2 default hr_api.g_varchar2
261: ,p_bep_attribute11 in varchar2 default hr_api.g_varchar2
262: ,p_bep_attribute12 in varchar2 default hr_api.g_varchar2
263: ,p_bep_attribute13 in varchar2 default hr_api.g_varchar2
256: ,p_bep_attribute6 in varchar2 default hr_api.g_varchar2
257: ,p_bep_attribute7 in varchar2 default hr_api.g_varchar2
258: ,p_bep_attribute8 in varchar2 default hr_api.g_varchar2
259: ,p_bep_attribute9 in varchar2 default hr_api.g_varchar2
260: ,p_bep_attribute10 in varchar2 default hr_api.g_varchar2
261: ,p_bep_attribute11 in varchar2 default hr_api.g_varchar2
262: ,p_bep_attribute12 in varchar2 default hr_api.g_varchar2
263: ,p_bep_attribute13 in varchar2 default hr_api.g_varchar2
264: ,p_bep_attribute14 in varchar2 default hr_api.g_varchar2
257: ,p_bep_attribute7 in varchar2 default hr_api.g_varchar2
258: ,p_bep_attribute8 in varchar2 default hr_api.g_varchar2
259: ,p_bep_attribute9 in varchar2 default hr_api.g_varchar2
260: ,p_bep_attribute10 in varchar2 default hr_api.g_varchar2
261: ,p_bep_attribute11 in varchar2 default hr_api.g_varchar2
262: ,p_bep_attribute12 in varchar2 default hr_api.g_varchar2
263: ,p_bep_attribute13 in varchar2 default hr_api.g_varchar2
264: ,p_bep_attribute14 in varchar2 default hr_api.g_varchar2
265: ,p_bep_attribute15 in varchar2 default hr_api.g_varchar2
258: ,p_bep_attribute8 in varchar2 default hr_api.g_varchar2
259: ,p_bep_attribute9 in varchar2 default hr_api.g_varchar2
260: ,p_bep_attribute10 in varchar2 default hr_api.g_varchar2
261: ,p_bep_attribute11 in varchar2 default hr_api.g_varchar2
262: ,p_bep_attribute12 in varchar2 default hr_api.g_varchar2
263: ,p_bep_attribute13 in varchar2 default hr_api.g_varchar2
264: ,p_bep_attribute14 in varchar2 default hr_api.g_varchar2
265: ,p_bep_attribute15 in varchar2 default hr_api.g_varchar2
266: ,p_bep_attribute16 in varchar2 default hr_api.g_varchar2
259: ,p_bep_attribute9 in varchar2 default hr_api.g_varchar2
260: ,p_bep_attribute10 in varchar2 default hr_api.g_varchar2
261: ,p_bep_attribute11 in varchar2 default hr_api.g_varchar2
262: ,p_bep_attribute12 in varchar2 default hr_api.g_varchar2
263: ,p_bep_attribute13 in varchar2 default hr_api.g_varchar2
264: ,p_bep_attribute14 in varchar2 default hr_api.g_varchar2
265: ,p_bep_attribute15 in varchar2 default hr_api.g_varchar2
266: ,p_bep_attribute16 in varchar2 default hr_api.g_varchar2
267: ,p_bep_attribute17 in varchar2 default hr_api.g_varchar2
260: ,p_bep_attribute10 in varchar2 default hr_api.g_varchar2
261: ,p_bep_attribute11 in varchar2 default hr_api.g_varchar2
262: ,p_bep_attribute12 in varchar2 default hr_api.g_varchar2
263: ,p_bep_attribute13 in varchar2 default hr_api.g_varchar2
264: ,p_bep_attribute14 in varchar2 default hr_api.g_varchar2
265: ,p_bep_attribute15 in varchar2 default hr_api.g_varchar2
266: ,p_bep_attribute16 in varchar2 default hr_api.g_varchar2
267: ,p_bep_attribute17 in varchar2 default hr_api.g_varchar2
268: ,p_bep_attribute18 in varchar2 default hr_api.g_varchar2
261: ,p_bep_attribute11 in varchar2 default hr_api.g_varchar2
262: ,p_bep_attribute12 in varchar2 default hr_api.g_varchar2
263: ,p_bep_attribute13 in varchar2 default hr_api.g_varchar2
264: ,p_bep_attribute14 in varchar2 default hr_api.g_varchar2
265: ,p_bep_attribute15 in varchar2 default hr_api.g_varchar2
266: ,p_bep_attribute16 in varchar2 default hr_api.g_varchar2
267: ,p_bep_attribute17 in varchar2 default hr_api.g_varchar2
268: ,p_bep_attribute18 in varchar2 default hr_api.g_varchar2
269: ,p_bep_attribute19 in varchar2 default hr_api.g_varchar2
262: ,p_bep_attribute12 in varchar2 default hr_api.g_varchar2
263: ,p_bep_attribute13 in varchar2 default hr_api.g_varchar2
264: ,p_bep_attribute14 in varchar2 default hr_api.g_varchar2
265: ,p_bep_attribute15 in varchar2 default hr_api.g_varchar2
266: ,p_bep_attribute16 in varchar2 default hr_api.g_varchar2
267: ,p_bep_attribute17 in varchar2 default hr_api.g_varchar2
268: ,p_bep_attribute18 in varchar2 default hr_api.g_varchar2
269: ,p_bep_attribute19 in varchar2 default hr_api.g_varchar2
270: ,p_bep_attribute20 in varchar2 default hr_api.g_varchar2
263: ,p_bep_attribute13 in varchar2 default hr_api.g_varchar2
264: ,p_bep_attribute14 in varchar2 default hr_api.g_varchar2
265: ,p_bep_attribute15 in varchar2 default hr_api.g_varchar2
266: ,p_bep_attribute16 in varchar2 default hr_api.g_varchar2
267: ,p_bep_attribute17 in varchar2 default hr_api.g_varchar2
268: ,p_bep_attribute18 in varchar2 default hr_api.g_varchar2
269: ,p_bep_attribute19 in varchar2 default hr_api.g_varchar2
270: ,p_bep_attribute20 in varchar2 default hr_api.g_varchar2
271: ,p_object_version_number in out nocopy number
264: ,p_bep_attribute14 in varchar2 default hr_api.g_varchar2
265: ,p_bep_attribute15 in varchar2 default hr_api.g_varchar2
266: ,p_bep_attribute16 in varchar2 default hr_api.g_varchar2
267: ,p_bep_attribute17 in varchar2 default hr_api.g_varchar2
268: ,p_bep_attribute18 in varchar2 default hr_api.g_varchar2
269: ,p_bep_attribute19 in varchar2 default hr_api.g_varchar2
270: ,p_bep_attribute20 in varchar2 default hr_api.g_varchar2
271: ,p_object_version_number in out nocopy number
272: ,p_effective_date in date
265: ,p_bep_attribute15 in varchar2 default hr_api.g_varchar2
266: ,p_bep_attribute16 in varchar2 default hr_api.g_varchar2
267: ,p_bep_attribute17 in varchar2 default hr_api.g_varchar2
268: ,p_bep_attribute18 in varchar2 default hr_api.g_varchar2
269: ,p_bep_attribute19 in varchar2 default hr_api.g_varchar2
270: ,p_bep_attribute20 in varchar2 default hr_api.g_varchar2
271: ,p_object_version_number in out nocopy number
272: ,p_effective_date in date
273: ,p_datetrack_mode in varchar2
266: ,p_bep_attribute16 in varchar2 default hr_api.g_varchar2
267: ,p_bep_attribute17 in varchar2 default hr_api.g_varchar2
268: ,p_bep_attribute18 in varchar2 default hr_api.g_varchar2
269: ,p_bep_attribute19 in varchar2 default hr_api.g_varchar2
270: ,p_bep_attribute20 in varchar2 default hr_api.g_varchar2
271: ,p_object_version_number in out nocopy number
272: ,p_effective_date in date
273: ,p_datetrack_mode in varchar2
274: ) is
330: ,p_effective_date => trunc(p_effective_date)
331: ,p_datetrack_mode => p_datetrack_mode
332: );
333: exception
334: when hr_api.cannot_find_prog_unit then
335: hr_api.cannot_find_prog_unit_error
336: (p_module_name => 'UPDATE_ELIG_OBJ_ELIG_PROFL'
337: ,p_hook_type => 'BP'
338: );
331: ,p_datetrack_mode => p_datetrack_mode
332: );
333: exception
334: when hr_api.cannot_find_prog_unit then
335: hr_api.cannot_find_prog_unit_error
336: (p_module_name => 'UPDATE_ELIG_OBJ_ELIG_PROFL'
337: ,p_hook_type => 'BP'
338: );
339: --
414: ,p_effective_date => trunc(p_effective_date)
415: ,p_datetrack_mode => p_datetrack_mode
416: );
417: exception
418: when hr_api.cannot_find_prog_unit then
419: hr_api.cannot_find_prog_unit_error
420: (p_module_name => 'UPDATE_ELIG_OBJ_ELIG_PROFL'
421: ,p_hook_type => 'AP'
422: );
415: ,p_datetrack_mode => p_datetrack_mode
416: );
417: exception
418: when hr_api.cannot_find_prog_unit then
419: hr_api.cannot_find_prog_unit_error
420: (p_module_name => 'UPDATE_ELIG_OBJ_ELIG_PROFL'
421: ,p_hook_type => 'AP'
422: );
423: --
429: --
430: -- When in validation only mode raise the Validate_Enabled exception
431: --
432: if p_validate then
433: raise hr_api.validate_enabled;
434: end if;
435: --
436: -- Set all output arguments
437: --
442: hr_utility.set_location(' Leaving:'||l_proc, 70);
443: --
444: exception
445: --
446: when hr_api.validate_enabled then
447: --
448: -- As the Validate_Enabled exception has been raised
449: -- we must rollback to the savepoint
450: --
511: ,p_effective_date => trunc(p_effective_date)
512: ,p_datetrack_mode => p_datetrack_mode
513: );
514: exception
515: when hr_api.cannot_find_prog_unit then
516: hr_api.cannot_find_prog_unit_error
517: (p_module_name => 'DELETE_ELIG_OBJ_ELIG_PROFL'
518: ,p_hook_type => 'BP'
519: );
512: ,p_datetrack_mode => p_datetrack_mode
513: );
514: exception
515: when hr_api.cannot_find_prog_unit then
516: hr_api.cannot_find_prog_unit_error
517: (p_module_name => 'DELETE_ELIG_OBJ_ELIG_PROFL'
518: ,p_hook_type => 'BP'
519: );
520: --
545: ,p_effective_date => trunc(p_effective_date)
546: ,p_datetrack_mode => p_datetrack_mode
547: );
548: exception
549: when hr_api.cannot_find_prog_unit then
550: hr_api.cannot_find_prog_unit_error
551: (p_module_name => 'DELETE_ELIG_OBJ_ELIG_PROFL'
552: ,p_hook_type => 'AP'
553: );
546: ,p_datetrack_mode => p_datetrack_mode
547: );
548: exception
549: when hr_api.cannot_find_prog_unit then
550: hr_api.cannot_find_prog_unit_error
551: (p_module_name => 'DELETE_ELIG_OBJ_ELIG_PROFL'
552: ,p_hook_type => 'AP'
553: );
554: --
560: --
561: -- When in validation only mode raise the Validate_Enabled exception
562: --
563: if p_validate then
564: raise hr_api.validate_enabled;
565: end if;
566: --
567: hr_utility.set_location(' Leaving:'||l_proc, 70);
568: --
567: hr_utility.set_location(' Leaving:'||l_proc, 70);
568: --
569: exception
570: --
571: when hr_api.validate_enabled then
572: --
573: -- As the Validate_Enabled exception has been raised
574: -- we must rollback to the savepoint
575: --