63: ,p_effective_date => trunc(p_effective_date));
64: --
65: exception
66: --
67: when hr_api.cannot_find_prog_unit then
68: --
69: hr_api.cannot_find_prog_unit_error
70: (p_module_name => 'CREATE_batch_dpnt_info'
71: ,p_hook_type => 'BP');
65: exception
66: --
67: when hr_api.cannot_find_prog_unit then
68: --
69: hr_api.cannot_find_prog_unit_error
70: (p_module_name => 'CREATE_batch_dpnt_info'
71: ,p_hook_type => 'BP');
72: --
73: -- End of API User Hook for the before hook of create_batch_dpnt_info
111: ,p_effective_date => trunc(p_effective_date));
112: --
113: exception
114: --
115: when hr_api.cannot_find_prog_unit then
116: --
117: hr_api.cannot_find_prog_unit_error
118: (p_module_name => 'CREATE_batch_dpnt_info'
119: ,p_hook_type => 'AP');
113: exception
114: --
115: when hr_api.cannot_find_prog_unit then
116: --
117: hr_api.cannot_find_prog_unit_error
118: (p_module_name => 'CREATE_batch_dpnt_info'
119: ,p_hook_type => 'AP');
120: --
121: -- End of API User Hook for the after hook of create_batch_dpnt_info
126: --
127: -- When in validation only mode raise the Validate_Enabled exception
128: --
129: if p_validate then
130: raise hr_api.validate_enabled;
131: end if;
132: --
133: -- Set all output arguments
134: --
138: hr_utility.set_location(' Leaving:'||l_proc, 70);
139: --
140: exception
141: --
142: when hr_api.validate_enabled then
143: --
144: -- As the Validate_Enabled exception has been raised
145: -- we must rollback to the savepoint
146: --
170: --
171: procedure update_batch_dpnt_info
172: (p_validate in boolean default false
173: ,p_batch_dpnt_id in number
174: ,p_benefit_action_id in number default hr_api.g_number
175: ,p_person_id in number default hr_api.g_number
176: ,p_pgm_id in number default hr_api.g_number
177: ,p_pl_id in number default hr_api.g_number
178: ,p_oipl_id in number default hr_api.g_number
171: procedure update_batch_dpnt_info
172: (p_validate in boolean default false
173: ,p_batch_dpnt_id in number
174: ,p_benefit_action_id in number default hr_api.g_number
175: ,p_person_id in number default hr_api.g_number
176: ,p_pgm_id in number default hr_api.g_number
177: ,p_pl_id in number default hr_api.g_number
178: ,p_oipl_id in number default hr_api.g_number
179: ,p_contact_typ_cd in varchar2 default hr_api.g_varchar2
172: (p_validate in boolean default false
173: ,p_batch_dpnt_id in number
174: ,p_benefit_action_id in number default hr_api.g_number
175: ,p_person_id in number default hr_api.g_number
176: ,p_pgm_id in number default hr_api.g_number
177: ,p_pl_id in number default hr_api.g_number
178: ,p_oipl_id in number default hr_api.g_number
179: ,p_contact_typ_cd in varchar2 default hr_api.g_varchar2
180: ,p_dpnt_person_id in number default hr_api.g_number
173: ,p_batch_dpnt_id in number
174: ,p_benefit_action_id in number default hr_api.g_number
175: ,p_person_id in number default hr_api.g_number
176: ,p_pgm_id in number default hr_api.g_number
177: ,p_pl_id in number default hr_api.g_number
178: ,p_oipl_id in number default hr_api.g_number
179: ,p_contact_typ_cd in varchar2 default hr_api.g_varchar2
180: ,p_dpnt_person_id in number default hr_api.g_number
181: ,p_business_group_id in number default hr_api.g_number
174: ,p_benefit_action_id in number default hr_api.g_number
175: ,p_person_id in number default hr_api.g_number
176: ,p_pgm_id in number default hr_api.g_number
177: ,p_pl_id in number default hr_api.g_number
178: ,p_oipl_id in number default hr_api.g_number
179: ,p_contact_typ_cd in varchar2 default hr_api.g_varchar2
180: ,p_dpnt_person_id in number default hr_api.g_number
181: ,p_business_group_id in number default hr_api.g_number
182: ,p_object_version_number in out nocopy varchar2
175: ,p_person_id in number default hr_api.g_number
176: ,p_pgm_id in number default hr_api.g_number
177: ,p_pl_id in number default hr_api.g_number
178: ,p_oipl_id in number default hr_api.g_number
179: ,p_contact_typ_cd in varchar2 default hr_api.g_varchar2
180: ,p_dpnt_person_id in number default hr_api.g_number
181: ,p_business_group_id in number default hr_api.g_number
182: ,p_object_version_number in out nocopy varchar2
183: ,p_enrt_cvg_strt_dt in date default hr_api.g_date
176: ,p_pgm_id in number default hr_api.g_number
177: ,p_pl_id in number default hr_api.g_number
178: ,p_oipl_id in number default hr_api.g_number
179: ,p_contact_typ_cd in varchar2 default hr_api.g_varchar2
180: ,p_dpnt_person_id in number default hr_api.g_number
181: ,p_business_group_id in number default hr_api.g_number
182: ,p_object_version_number in out nocopy varchar2
183: ,p_enrt_cvg_strt_dt in date default hr_api.g_date
184: ,p_enrt_cvg_thru_dt in date default hr_api.g_date
177: ,p_pl_id in number default hr_api.g_number
178: ,p_oipl_id in number default hr_api.g_number
179: ,p_contact_typ_cd in varchar2 default hr_api.g_varchar2
180: ,p_dpnt_person_id in number default hr_api.g_number
181: ,p_business_group_id in number default hr_api.g_number
182: ,p_object_version_number in out nocopy varchar2
183: ,p_enrt_cvg_strt_dt in date default hr_api.g_date
184: ,p_enrt_cvg_thru_dt in date default hr_api.g_date
185: ,p_actn_cd in varchar2 default hr_api.g_varchar2
179: ,p_contact_typ_cd in varchar2 default hr_api.g_varchar2
180: ,p_dpnt_person_id in number default hr_api.g_number
181: ,p_business_group_id in number default hr_api.g_number
182: ,p_object_version_number in out nocopy varchar2
183: ,p_enrt_cvg_strt_dt in date default hr_api.g_date
184: ,p_enrt_cvg_thru_dt in date default hr_api.g_date
185: ,p_actn_cd in varchar2 default hr_api.g_varchar2
186: ,p_effective_date in date) is
187: --
180: ,p_dpnt_person_id in number default hr_api.g_number
181: ,p_business_group_id in number default hr_api.g_number
182: ,p_object_version_number in out nocopy varchar2
183: ,p_enrt_cvg_strt_dt in date default hr_api.g_date
184: ,p_enrt_cvg_thru_dt in date default hr_api.g_date
185: ,p_actn_cd in varchar2 default hr_api.g_varchar2
186: ,p_effective_date in date) is
187: --
188: -- Declare cursors and local variables
181: ,p_business_group_id in number default hr_api.g_number
182: ,p_object_version_number in out nocopy varchar2
183: ,p_enrt_cvg_strt_dt in date default hr_api.g_date
184: ,p_enrt_cvg_thru_dt in date default hr_api.g_date
185: ,p_actn_cd in varchar2 default hr_api.g_varchar2
186: ,p_effective_date in date) is
187: --
188: -- Declare cursors and local variables
189: --
225: ,p_effective_date => trunc(p_effective_date));
226: --
227: exception
228: --
229: when hr_api.cannot_find_prog_unit then
230: hr_api.cannot_find_prog_unit_error
231: (p_module_name => 'UPDATE_batch_dpnt_info'
232: ,p_hook_type => 'BP');
233: --
226: --
227: exception
228: --
229: when hr_api.cannot_find_prog_unit then
230: hr_api.cannot_find_prog_unit_error
231: (p_module_name => 'UPDATE_batch_dpnt_info'
232: ,p_hook_type => 'BP');
233: --
234: -- End of API User Hook for the before hook of update_batch_dpnt_info
272: ,p_effective_date => trunc(p_effective_date));
273: --
274: exception
275: --
276: when hr_api.cannot_find_prog_unit then
277: --
278: hr_api.cannot_find_prog_unit_error
279: (p_module_name => 'UPDATE_batch_dpnt_info'
280: ,p_hook_type => 'AP');
274: exception
275: --
276: when hr_api.cannot_find_prog_unit then
277: --
278: hr_api.cannot_find_prog_unit_error
279: (p_module_name => 'UPDATE_batch_dpnt_info'
280: ,p_hook_type => 'AP');
281: --
282: -- End of API User Hook for the after hook of update_batch_dpnt_info
287: --
288: -- When in validation only mode raise the Validate_Enabled exception
289: --
290: if p_validate then
291: raise hr_api.validate_enabled;
292: end if;
293: --
294: -- Set all output arguments
295: --
298: hr_utility.set_location(' Leaving:'||l_proc, 70);
299: --
300: exception
301: --
302: when hr_api.validate_enabled then
303: --
304: -- As the Validate_Enabled exception has been raised
305: -- we must rollback to the savepoint
306: --
360: ,p_effective_date => trunc(p_effective_date));
361: --
362: exception
363: --
364: when hr_api.cannot_find_prog_unit then
365: --
366: hr_api.cannot_find_prog_unit_error
367: (p_module_name => 'DELETE_batch_dpnt_info'
368: ,p_hook_type => 'BP');
362: exception
363: --
364: when hr_api.cannot_find_prog_unit then
365: --
366: hr_api.cannot_find_prog_unit_error
367: (p_module_name => 'DELETE_batch_dpnt_info'
368: ,p_hook_type => 'BP');
369: --
370: -- End of API User Hook for the before hook of delete_batch_dpnt_info
386: ,p_effective_date => trunc(p_effective_date));
387: --
388: exception
389: --
390: when hr_api.cannot_find_prog_unit then
391: --
392: hr_api.cannot_find_prog_unit_error
393: (p_module_name => 'DELETE_batch_dpnt_info'
394: ,p_hook_type => 'AP');
388: exception
389: --
390: when hr_api.cannot_find_prog_unit then
391: --
392: hr_api.cannot_find_prog_unit_error
393: (p_module_name => 'DELETE_batch_dpnt_info'
394: ,p_hook_type => 'AP');
395: --
396: -- End of API User Hook for the after hook of delete_batch_dpnt_info
401: --
402: -- When in validation only mode raise the Validate_Enabled exception
403: --
404: if p_validate then
405: raise hr_api.validate_enabled;
406: end if;
407: --
408: hr_utility.set_location(' Leaving:'||l_proc, 70);
409: --
408: hr_utility.set_location(' Leaving:'||l_proc, 70);
409: --
410: exception
411: --
412: when hr_api.validate_enabled then
413: --
414: -- As the Validate_Enabled exception has been raised
415: -- we must rollback to the savepoint
416: --