57: ,p_effective_date => trunc(p_effective_date));
58: --
59: exception
60: --
61: when hr_api.cannot_find_prog_unit then
62: --
63: hr_api.cannot_find_prog_unit_error
64: (p_module_name => 'CREATE_batch_elig_info'
65: ,p_hook_type => 'BP');
59: exception
60: --
61: when hr_api.cannot_find_prog_unit then
62: --
63: hr_api.cannot_find_prog_unit_error
64: (p_module_name => 'CREATE_batch_elig_info'
65: ,p_hook_type => 'BP');
66: --
67: -- End of API User Hook for the before hook of create_batch_elig_info
99: ,p_effective_date => trunc(p_effective_date));
100: --
101: exception
102: --
103: when hr_api.cannot_find_prog_unit then
104: --
105: hr_api.cannot_find_prog_unit_error
106: (p_module_name => 'CREATE_batch_elig_info'
107: ,p_hook_type => 'AP');
101: exception
102: --
103: when hr_api.cannot_find_prog_unit then
104: --
105: hr_api.cannot_find_prog_unit_error
106: (p_module_name => 'CREATE_batch_elig_info'
107: ,p_hook_type => 'AP');
108: --
109: -- End of API User Hook for the after hook of create_batch_elig_info
114: --
115: -- When in validation only mode raise the Validate_Enabled exception
116: --
117: if p_validate then
118: raise hr_api.validate_enabled;
119: end if;
120: --
121: -- Set all output arguments
122: --
126: hr_utility.set_location(' Leaving:'||l_proc, 70);
127: --
128: exception
129: --
130: when hr_api.validate_enabled then
131: --
132: -- As the Validate_Enabled exception has been raised
133: -- we must rollback to the savepoint
134: --
159: --
160: procedure update_batch_elig_info
161: (p_validate in boolean default false
162: ,p_batch_elig_id in number
163: ,p_benefit_action_id in number default hr_api.g_number
164: ,p_person_id in number default hr_api.g_number
165: ,p_pgm_id in number default hr_api.g_number
166: ,p_pl_id in number default hr_api.g_number
167: ,p_oipl_id in number default hr_api.g_number
160: procedure update_batch_elig_info
161: (p_validate in boolean default false
162: ,p_batch_elig_id in number
163: ,p_benefit_action_id in number default hr_api.g_number
164: ,p_person_id in number default hr_api.g_number
165: ,p_pgm_id in number default hr_api.g_number
166: ,p_pl_id in number default hr_api.g_number
167: ,p_oipl_id in number default hr_api.g_number
168: ,p_elig_flag in varchar2 default hr_api.g_varchar2
161: (p_validate in boolean default false
162: ,p_batch_elig_id in number
163: ,p_benefit_action_id in number default hr_api.g_number
164: ,p_person_id in number default hr_api.g_number
165: ,p_pgm_id in number default hr_api.g_number
166: ,p_pl_id in number default hr_api.g_number
167: ,p_oipl_id in number default hr_api.g_number
168: ,p_elig_flag in varchar2 default hr_api.g_varchar2
169: ,p_inelig_text in varchar2 default hr_api.g_varchar2
162: ,p_batch_elig_id in number
163: ,p_benefit_action_id in number default hr_api.g_number
164: ,p_person_id in number default hr_api.g_number
165: ,p_pgm_id in number default hr_api.g_number
166: ,p_pl_id in number default hr_api.g_number
167: ,p_oipl_id in number default hr_api.g_number
168: ,p_elig_flag in varchar2 default hr_api.g_varchar2
169: ,p_inelig_text in varchar2 default hr_api.g_varchar2
170: ,p_business_group_id in number default hr_api.g_number
163: ,p_benefit_action_id in number default hr_api.g_number
164: ,p_person_id in number default hr_api.g_number
165: ,p_pgm_id in number default hr_api.g_number
166: ,p_pl_id in number default hr_api.g_number
167: ,p_oipl_id in number default hr_api.g_number
168: ,p_elig_flag in varchar2 default hr_api.g_varchar2
169: ,p_inelig_text in varchar2 default hr_api.g_varchar2
170: ,p_business_group_id in number default hr_api.g_number
171: ,p_object_version_number in out nocopy number
164: ,p_person_id in number default hr_api.g_number
165: ,p_pgm_id in number default hr_api.g_number
166: ,p_pl_id in number default hr_api.g_number
167: ,p_oipl_id in number default hr_api.g_number
168: ,p_elig_flag in varchar2 default hr_api.g_varchar2
169: ,p_inelig_text in varchar2 default hr_api.g_varchar2
170: ,p_business_group_id in number default hr_api.g_number
171: ,p_object_version_number in out nocopy number
172: ,p_effective_date in date) is
165: ,p_pgm_id in number default hr_api.g_number
166: ,p_pl_id in number default hr_api.g_number
167: ,p_oipl_id in number default hr_api.g_number
168: ,p_elig_flag in varchar2 default hr_api.g_varchar2
169: ,p_inelig_text in varchar2 default hr_api.g_varchar2
170: ,p_business_group_id in number default hr_api.g_number
171: ,p_object_version_number in out nocopy number
172: ,p_effective_date in date) is
173: --
166: ,p_pl_id in number default hr_api.g_number
167: ,p_oipl_id in number default hr_api.g_number
168: ,p_elig_flag in varchar2 default hr_api.g_varchar2
169: ,p_inelig_text in varchar2 default hr_api.g_varchar2
170: ,p_business_group_id in number default hr_api.g_number
171: ,p_object_version_number in out nocopy number
172: ,p_effective_date in date) is
173: --
174: -- Declare cursors and local variables
208: ,p_effective_date => trunc(p_effective_date));
209: --
210: exception
211: --
212: when hr_api.cannot_find_prog_unit then
213: hr_api.cannot_find_prog_unit_error
214: (p_module_name => 'UPDATE_batch_elig_info'
215: ,p_hook_type => 'BP');
216: --
209: --
210: exception
211: --
212: when hr_api.cannot_find_prog_unit then
213: hr_api.cannot_find_prog_unit_error
214: (p_module_name => 'UPDATE_batch_elig_info'
215: ,p_hook_type => 'BP');
216: --
217: -- End of API User Hook for the before hook of update_batch_elig_info
249: ,p_effective_date => trunc(p_effective_date));
250: --
251: exception
252: --
253: when hr_api.cannot_find_prog_unit then
254: hr_api.cannot_find_prog_unit_error
255: (p_module_name => 'UPDATE_batch_elig_info'
256: ,p_hook_type => 'AP');
257: --
250: --
251: exception
252: --
253: when hr_api.cannot_find_prog_unit then
254: hr_api.cannot_find_prog_unit_error
255: (p_module_name => 'UPDATE_batch_elig_info'
256: ,p_hook_type => 'AP');
257: --
258: -- End of API User Hook for the after hook of update_batch_elig_info
263: --
264: -- When in validation only mode raise the Validate_Enabled exception
265: --
266: if p_validate then
267: raise hr_api.validate_enabled;
268: end if;
269: --
270: -- Set all output arguments
271: --
274: hr_utility.set_location(' Leaving:'||l_proc, 70);
275: --
276: exception
277: --
278: when hr_api.validate_enabled then
279: --
280: -- As the Validate_Enabled exception has been raised
281: -- we must rollback to the savepoint
282: --
338: ,p_effective_date => trunc(p_effective_date));
339: --
340: exception
341: --
342: when hr_api.cannot_find_prog_unit then
343: --
344: hr_api.cannot_find_prog_unit_error
345: (p_module_name => 'DELETE_batch_elig_info'
346: ,p_hook_type => 'BP');
340: exception
341: --
342: when hr_api.cannot_find_prog_unit then
343: --
344: hr_api.cannot_find_prog_unit_error
345: (p_module_name => 'DELETE_batch_elig_info'
346: ,p_hook_type => 'BP');
347: --
348: -- End of API User Hook for the before hook of delete_batch_elig_info
364: ,p_effective_date => trunc(p_effective_date));
365: --
366: exception
367: --
368: when hr_api.cannot_find_prog_unit then
369: --
370: hr_api.cannot_find_prog_unit_error
371: (p_module_name => 'DELETE_batch_elig_info'
372: ,p_hook_type => 'AP');
366: exception
367: --
368: when hr_api.cannot_find_prog_unit then
369: --
370: hr_api.cannot_find_prog_unit_error
371: (p_module_name => 'DELETE_batch_elig_info'
372: ,p_hook_type => 'AP');
373: --
374: -- End of API User Hook for the after hook of delete_batch_elig_info
379: --
380: -- When in validation only mode raise the Validate_Enabled exception
381: --
382: if p_validate then
383: raise hr_api.validate_enabled;
384: end if;
385: --
386: hr_utility.set_location(' Leaving:'||l_proc, 70);
387: --
386: hr_utility.set_location(' Leaving:'||l_proc, 70);
387: --
388: exception
389: --
390: when hr_api.validate_enabled then
391: --
392: -- As the Validate_Enabled exception has been raised
393: -- we must rollback to the savepoint
394: --