71: ,p_effective_date => trunc(p_effective_date));
72: --
73: exception
74: --
75: when hr_api.cannot_find_prog_unit then
76: --
77: hr_api.cannot_find_prog_unit_error
78: (p_module_name => 'CREATE_batch_elctbl_chc'
79: ,p_hook_type => 'BP');
73: exception
74: --
75: when hr_api.cannot_find_prog_unit then
76: --
77: hr_api.cannot_find_prog_unit_error
78: (p_module_name => 'CREATE_batch_elctbl_chc'
79: ,p_hook_type => 'BP');
80: --
81: -- End of API User Hook for the before hook of create_batch_elctbl_chc
127: ,p_effective_date => trunc(p_effective_date));
128: --
129: exception
130: --
131: when hr_api.cannot_find_prog_unit then
132: --
133: hr_api.cannot_find_prog_unit_error
134: (p_module_name => 'CREATE_batch_elctbl_chc'
135: ,p_hook_type => 'AP');
129: exception
130: --
131: when hr_api.cannot_find_prog_unit then
132: --
133: hr_api.cannot_find_prog_unit_error
134: (p_module_name => 'CREATE_batch_elctbl_chc'
135: ,p_hook_type => 'AP');
136: --
137: -- End of API User Hook for the after hook of create_batch_elctbl_chc
142: --
143: -- When in validation only mode raise the Validate_Enabled exception
144: --
145: if p_validate then
146: raise hr_api.validate_enabled;
147: end if;
148: --
149: -- Set all output arguments
150: --
154: hr_utility.set_location(' Leaving:'||l_proc, 70);
155: --
156: exception
157: --
158: when hr_api.validate_enabled then
159: --
160: -- As the Validate_Enabled exception has been raised
161: -- we must rollback to the savepoint
162: --
186: --
187: procedure update_batch_elctbl_chc
188: (p_validate in boolean default false
189: ,p_batch_elctbl_id in number
190: ,p_benefit_action_id in number default hr_api.g_number
191: ,p_person_id in number default hr_api.g_number
192: ,p_pgm_id in number default hr_api.g_number
193: ,p_pl_id in number default hr_api.g_number
194: ,p_oipl_id in number default hr_api.g_number
187: procedure update_batch_elctbl_chc
188: (p_validate in boolean default false
189: ,p_batch_elctbl_id in number
190: ,p_benefit_action_id in number default hr_api.g_number
191: ,p_person_id in number default hr_api.g_number
192: ,p_pgm_id in number default hr_api.g_number
193: ,p_pl_id in number default hr_api.g_number
194: ,p_oipl_id in number default hr_api.g_number
195: ,p_enrt_cvg_strt_dt in date default hr_api.g_date
188: (p_validate in boolean default false
189: ,p_batch_elctbl_id in number
190: ,p_benefit_action_id in number default hr_api.g_number
191: ,p_person_id in number default hr_api.g_number
192: ,p_pgm_id in number default hr_api.g_number
193: ,p_pl_id in number default hr_api.g_number
194: ,p_oipl_id in number default hr_api.g_number
195: ,p_enrt_cvg_strt_dt in date default hr_api.g_date
196: ,p_enrt_perd_strt_dt in date default hr_api.g_date
189: ,p_batch_elctbl_id in number
190: ,p_benefit_action_id in number default hr_api.g_number
191: ,p_person_id in number default hr_api.g_number
192: ,p_pgm_id in number default hr_api.g_number
193: ,p_pl_id in number default hr_api.g_number
194: ,p_oipl_id in number default hr_api.g_number
195: ,p_enrt_cvg_strt_dt in date default hr_api.g_date
196: ,p_enrt_perd_strt_dt in date default hr_api.g_date
197: ,p_enrt_perd_end_dt in date default hr_api.g_date
190: ,p_benefit_action_id in number default hr_api.g_number
191: ,p_person_id in number default hr_api.g_number
192: ,p_pgm_id in number default hr_api.g_number
193: ,p_pl_id in number default hr_api.g_number
194: ,p_oipl_id in number default hr_api.g_number
195: ,p_enrt_cvg_strt_dt in date default hr_api.g_date
196: ,p_enrt_perd_strt_dt in date default hr_api.g_date
197: ,p_enrt_perd_end_dt in date default hr_api.g_date
198: ,p_erlst_deenrt_dt in date default hr_api.g_date
191: ,p_person_id in number default hr_api.g_number
192: ,p_pgm_id in number default hr_api.g_number
193: ,p_pl_id in number default hr_api.g_number
194: ,p_oipl_id in number default hr_api.g_number
195: ,p_enrt_cvg_strt_dt in date default hr_api.g_date
196: ,p_enrt_perd_strt_dt in date default hr_api.g_date
197: ,p_enrt_perd_end_dt in date default hr_api.g_date
198: ,p_erlst_deenrt_dt in date default hr_api.g_date
199: ,p_dflt_enrt_dt in date default hr_api.g_date
192: ,p_pgm_id in number default hr_api.g_number
193: ,p_pl_id in number default hr_api.g_number
194: ,p_oipl_id in number default hr_api.g_number
195: ,p_enrt_cvg_strt_dt in date default hr_api.g_date
196: ,p_enrt_perd_strt_dt in date default hr_api.g_date
197: ,p_enrt_perd_end_dt in date default hr_api.g_date
198: ,p_erlst_deenrt_dt in date default hr_api.g_date
199: ,p_dflt_enrt_dt in date default hr_api.g_date
200: ,p_enrt_typ_cycl_cd in varchar2 default hr_api.g_varchar2
193: ,p_pl_id in number default hr_api.g_number
194: ,p_oipl_id in number default hr_api.g_number
195: ,p_enrt_cvg_strt_dt in date default hr_api.g_date
196: ,p_enrt_perd_strt_dt in date default hr_api.g_date
197: ,p_enrt_perd_end_dt in date default hr_api.g_date
198: ,p_erlst_deenrt_dt in date default hr_api.g_date
199: ,p_dflt_enrt_dt in date default hr_api.g_date
200: ,p_enrt_typ_cycl_cd in varchar2 default hr_api.g_varchar2
201: ,p_comp_lvl_cd in varchar2 default hr_api.g_varchar2
194: ,p_oipl_id in number default hr_api.g_number
195: ,p_enrt_cvg_strt_dt in date default hr_api.g_date
196: ,p_enrt_perd_strt_dt in date default hr_api.g_date
197: ,p_enrt_perd_end_dt in date default hr_api.g_date
198: ,p_erlst_deenrt_dt in date default hr_api.g_date
199: ,p_dflt_enrt_dt in date default hr_api.g_date
200: ,p_enrt_typ_cycl_cd in varchar2 default hr_api.g_varchar2
201: ,p_comp_lvl_cd in varchar2 default hr_api.g_varchar2
202: ,p_mndtry_flag in varchar2 default hr_api.g_varchar2
195: ,p_enrt_cvg_strt_dt in date default hr_api.g_date
196: ,p_enrt_perd_strt_dt in date default hr_api.g_date
197: ,p_enrt_perd_end_dt in date default hr_api.g_date
198: ,p_erlst_deenrt_dt in date default hr_api.g_date
199: ,p_dflt_enrt_dt in date default hr_api.g_date
200: ,p_enrt_typ_cycl_cd in varchar2 default hr_api.g_varchar2
201: ,p_comp_lvl_cd in varchar2 default hr_api.g_varchar2
202: ,p_mndtry_flag in varchar2 default hr_api.g_varchar2
203: ,p_dflt_flag in varchar2 default hr_api.g_varchar2
196: ,p_enrt_perd_strt_dt in date default hr_api.g_date
197: ,p_enrt_perd_end_dt in date default hr_api.g_date
198: ,p_erlst_deenrt_dt in date default hr_api.g_date
199: ,p_dflt_enrt_dt in date default hr_api.g_date
200: ,p_enrt_typ_cycl_cd in varchar2 default hr_api.g_varchar2
201: ,p_comp_lvl_cd in varchar2 default hr_api.g_varchar2
202: ,p_mndtry_flag in varchar2 default hr_api.g_varchar2
203: ,p_dflt_flag in varchar2 default hr_api.g_varchar2
204: ,p_business_group_id in number default hr_api.g_number
197: ,p_enrt_perd_end_dt in date default hr_api.g_date
198: ,p_erlst_deenrt_dt in date default hr_api.g_date
199: ,p_dflt_enrt_dt in date default hr_api.g_date
200: ,p_enrt_typ_cycl_cd in varchar2 default hr_api.g_varchar2
201: ,p_comp_lvl_cd in varchar2 default hr_api.g_varchar2
202: ,p_mndtry_flag in varchar2 default hr_api.g_varchar2
203: ,p_dflt_flag in varchar2 default hr_api.g_varchar2
204: ,p_business_group_id in number default hr_api.g_number
205: ,p_object_version_number in out nocopy number
198: ,p_erlst_deenrt_dt in date default hr_api.g_date
199: ,p_dflt_enrt_dt in date default hr_api.g_date
200: ,p_enrt_typ_cycl_cd in varchar2 default hr_api.g_varchar2
201: ,p_comp_lvl_cd in varchar2 default hr_api.g_varchar2
202: ,p_mndtry_flag in varchar2 default hr_api.g_varchar2
203: ,p_dflt_flag in varchar2 default hr_api.g_varchar2
204: ,p_business_group_id in number default hr_api.g_number
205: ,p_object_version_number in out nocopy number
206: ,p_effective_date in date) is
199: ,p_dflt_enrt_dt in date default hr_api.g_date
200: ,p_enrt_typ_cycl_cd in varchar2 default hr_api.g_varchar2
201: ,p_comp_lvl_cd in varchar2 default hr_api.g_varchar2
202: ,p_mndtry_flag in varchar2 default hr_api.g_varchar2
203: ,p_dflt_flag in varchar2 default hr_api.g_varchar2
204: ,p_business_group_id in number default hr_api.g_number
205: ,p_object_version_number in out nocopy number
206: ,p_effective_date in date) is
207: --
200: ,p_enrt_typ_cycl_cd in varchar2 default hr_api.g_varchar2
201: ,p_comp_lvl_cd in varchar2 default hr_api.g_varchar2
202: ,p_mndtry_flag in varchar2 default hr_api.g_varchar2
203: ,p_dflt_flag in varchar2 default hr_api.g_varchar2
204: ,p_business_group_id in number default hr_api.g_number
205: ,p_object_version_number in out nocopy number
206: ,p_effective_date in date) is
207: --
208: -- Declare cursors and local variables
249: ,p_effective_date => trunc(p_effective_date));
250: --
251: exception
252: --
253: when hr_api.cannot_find_prog_unit then
254: --
255: hr_api.cannot_find_prog_unit_error
256: (p_module_name => 'UPDATE_batch_elctbl_chc'
257: ,p_hook_type => 'BP');
251: exception
252: --
253: when hr_api.cannot_find_prog_unit then
254: --
255: hr_api.cannot_find_prog_unit_error
256: (p_module_name => 'UPDATE_batch_elctbl_chc'
257: ,p_hook_type => 'BP');
258: --
259: -- End of API User Hook for the before hook of update_batch_elctbl_chc
305: ,p_effective_date => trunc(p_effective_date));
306: --
307: exception
308: --
309: when hr_api.cannot_find_prog_unit then
310: --
311: hr_api.cannot_find_prog_unit_error
312: (p_module_name => 'UPDATE_batch_elctbl_chc'
313: ,p_hook_type => 'AP');
307: exception
308: --
309: when hr_api.cannot_find_prog_unit then
310: --
311: hr_api.cannot_find_prog_unit_error
312: (p_module_name => 'UPDATE_batch_elctbl_chc'
313: ,p_hook_type => 'AP');
314: --
315: -- End of API User Hook for the after hook of update_batch_elctbl_chc
320: --
321: -- When in validation only mode raise the Validate_Enabled exception
322: --
323: if p_validate then
324: raise hr_api.validate_enabled;
325: end if;
326: --
327: -- Set all output arguments
328: --
331: hr_utility.set_location(' Leaving:'||l_proc, 70);
332: --
333: exception
334: --
335: when hr_api.validate_enabled then
336: --
337: -- As the Validate_Enabled exception has been raised
338: -- we must rollback to the savepoint
339: --
393: ,p_effective_date => trunc(p_effective_date));
394: --
395: exception
396: --
397: when hr_api.cannot_find_prog_unit then
398: --
399: hr_api.cannot_find_prog_unit_error
400: (p_module_name => 'DELETE_batch_elctbl_chc'
401: ,p_hook_type => 'BP');
395: exception
396: --
397: when hr_api.cannot_find_prog_unit then
398: --
399: hr_api.cannot_find_prog_unit_error
400: (p_module_name => 'DELETE_batch_elctbl_chc'
401: ,p_hook_type => 'BP');
402: --
403: -- End of API User Hook for the before hook of delete_batch_elctbl_chc
419: ,p_effective_date => trunc(p_effective_date));
420: --
421: exception
422: --
423: when hr_api.cannot_find_prog_unit then
424: --
425: hr_api.cannot_find_prog_unit_error
426: (p_module_name => 'DELETE_batch_elctbl_chc'
427: ,p_hook_type => 'AP');
421: exception
422: --
423: when hr_api.cannot_find_prog_unit then
424: --
425: hr_api.cannot_find_prog_unit_error
426: (p_module_name => 'DELETE_batch_elctbl_chc'
427: ,p_hook_type => 'AP');
428: --
429: -- End of API User Hook for the after hook of delete_batch_elctbl_chc
434: --
435: -- When in validation only mode raise the Validate_Enabled exception
436: --
437: if p_validate then
438: raise hr_api.validate_enabled;
439: end if;
440: --
441: hr_utility.set_location(' Leaving:'||l_proc, 70);
442: --
441: hr_utility.set_location(' Leaving:'||l_proc, 70);
442: --
443: exception
444: --
445: when hr_api.validate_enabled then
446: --
447: -- As the Validate_Enabled exception has been raised
448: -- we must rollback to the savepoint
449: --