DBA Data[Home] [Help]

APPS.BEN_BATCH_LER_INFO_API dependencies on HR_API

Line 81: when hr_api.cannot_find_prog_unit then

77: ,p_effective_date => trunc(p_effective_date));
78: --
79: exception
80: --
81: when hr_api.cannot_find_prog_unit then
82: --
83: hr_api.cannot_find_prog_unit_error
84: (p_module_name => 'CREATE_batch_ler_info'
85: ,p_hook_type => 'BP');

Line 83: hr_api.cannot_find_prog_unit_error

79: exception
80: --
81: when hr_api.cannot_find_prog_unit then
82: --
83: hr_api.cannot_find_prog_unit_error
84: (p_module_name => 'CREATE_batch_ler_info'
85: ,p_hook_type => 'BP');
86: --
87: -- End of API User Hook for the before hook of create_batch_ler_info

Line 143: when hr_api.cannot_find_prog_unit then

139: ,p_effective_date => trunc(p_effective_date));
140: --
141: exception
142: --
143: when hr_api.cannot_find_prog_unit then
144: --
145: hr_api.cannot_find_prog_unit_error
146: (p_module_name => 'CREATE_batch_ler_info'
147: ,p_hook_type => 'AP');

Line 145: hr_api.cannot_find_prog_unit_error

141: exception
142: --
143: when hr_api.cannot_find_prog_unit then
144: --
145: hr_api.cannot_find_prog_unit_error
146: (p_module_name => 'CREATE_batch_ler_info'
147: ,p_hook_type => 'AP');
148: --
149: -- End of API User Hook for the after hook of create_batch_ler_info

Line 158: raise hr_api.validate_enabled;

154: --
155: -- When in validation only mode raise the Validate_Enabled exception
156: --
157: if p_validate then
158: raise hr_api.validate_enabled;
159: end if;
160: --
161: -- Set all output arguments
162: --

Line 170: when hr_api.validate_enabled then

166: hr_utility.set_location(' Leaving:'||l_proc, 70);
167: --
168: exception
169: --
170: when hr_api.validate_enabled then
171: --
172: -- As the Validate_Enabled exception has been raised
173: -- we must rollback to the savepoint
174: --

Line 202: ,p_benefit_action_id in number default hr_api.g_number

198: --
199: procedure update_batch_ler_info
200: (p_validate in boolean default false
201: ,p_batch_ler_id in number
202: ,p_benefit_action_id in number default hr_api.g_number
203: ,p_person_id in number default hr_api.g_number
204: ,p_ler_id in number default hr_api.g_number
205: ,p_lf_evt_ocrd_dt in date default hr_api.g_date
206: ,p_replcd_flag in varchar2 default hr_api.g_varchar2

Line 203: ,p_person_id in number default hr_api.g_number

199: procedure update_batch_ler_info
200: (p_validate in boolean default false
201: ,p_batch_ler_id in number
202: ,p_benefit_action_id in number default hr_api.g_number
203: ,p_person_id in number default hr_api.g_number
204: ,p_ler_id in number default hr_api.g_number
205: ,p_lf_evt_ocrd_dt in date default hr_api.g_date
206: ,p_replcd_flag in varchar2 default hr_api.g_varchar2
207: ,p_crtd_flag in varchar2 default hr_api.g_varchar2

Line 204: ,p_ler_id in number default hr_api.g_number

200: (p_validate in boolean default false
201: ,p_batch_ler_id in number
202: ,p_benefit_action_id in number default hr_api.g_number
203: ,p_person_id in number default hr_api.g_number
204: ,p_ler_id in number default hr_api.g_number
205: ,p_lf_evt_ocrd_dt in date default hr_api.g_date
206: ,p_replcd_flag in varchar2 default hr_api.g_varchar2
207: ,p_crtd_flag in varchar2 default hr_api.g_varchar2
208: ,p_tmprl_flag in varchar2 default hr_api.g_varchar2

Line 205: ,p_lf_evt_ocrd_dt in date default hr_api.g_date

201: ,p_batch_ler_id in number
202: ,p_benefit_action_id in number default hr_api.g_number
203: ,p_person_id in number default hr_api.g_number
204: ,p_ler_id in number default hr_api.g_number
205: ,p_lf_evt_ocrd_dt in date default hr_api.g_date
206: ,p_replcd_flag in varchar2 default hr_api.g_varchar2
207: ,p_crtd_flag in varchar2 default hr_api.g_varchar2
208: ,p_tmprl_flag in varchar2 default hr_api.g_varchar2
209: ,p_dltd_flag in varchar2 default hr_api.g_varchar2

Line 206: ,p_replcd_flag in varchar2 default hr_api.g_varchar2

202: ,p_benefit_action_id in number default hr_api.g_number
203: ,p_person_id in number default hr_api.g_number
204: ,p_ler_id in number default hr_api.g_number
205: ,p_lf_evt_ocrd_dt in date default hr_api.g_date
206: ,p_replcd_flag in varchar2 default hr_api.g_varchar2
207: ,p_crtd_flag in varchar2 default hr_api.g_varchar2
208: ,p_tmprl_flag in varchar2 default hr_api.g_varchar2
209: ,p_dltd_flag in varchar2 default hr_api.g_varchar2
210: ,p_open_and_clsd_flag in varchar2 default hr_api.g_varchar2

Line 207: ,p_crtd_flag in varchar2 default hr_api.g_varchar2

203: ,p_person_id in number default hr_api.g_number
204: ,p_ler_id in number default hr_api.g_number
205: ,p_lf_evt_ocrd_dt in date default hr_api.g_date
206: ,p_replcd_flag in varchar2 default hr_api.g_varchar2
207: ,p_crtd_flag in varchar2 default hr_api.g_varchar2
208: ,p_tmprl_flag in varchar2 default hr_api.g_varchar2
209: ,p_dltd_flag in varchar2 default hr_api.g_varchar2
210: ,p_open_and_clsd_flag in varchar2 default hr_api.g_varchar2
211: ,p_clsd_flag in varchar2 default hr_api.g_varchar2

Line 208: ,p_tmprl_flag in varchar2 default hr_api.g_varchar2

204: ,p_ler_id in number default hr_api.g_number
205: ,p_lf_evt_ocrd_dt in date default hr_api.g_date
206: ,p_replcd_flag in varchar2 default hr_api.g_varchar2
207: ,p_crtd_flag in varchar2 default hr_api.g_varchar2
208: ,p_tmprl_flag in varchar2 default hr_api.g_varchar2
209: ,p_dltd_flag in varchar2 default hr_api.g_varchar2
210: ,p_open_and_clsd_flag in varchar2 default hr_api.g_varchar2
211: ,p_clsd_flag in varchar2 default hr_api.g_varchar2
212: ,p_not_crtd_flag in varchar2 default hr_api.g_varchar2

Line 209: ,p_dltd_flag in varchar2 default hr_api.g_varchar2

205: ,p_lf_evt_ocrd_dt in date default hr_api.g_date
206: ,p_replcd_flag in varchar2 default hr_api.g_varchar2
207: ,p_crtd_flag in varchar2 default hr_api.g_varchar2
208: ,p_tmprl_flag in varchar2 default hr_api.g_varchar2
209: ,p_dltd_flag in varchar2 default hr_api.g_varchar2
210: ,p_open_and_clsd_flag in varchar2 default hr_api.g_varchar2
211: ,p_clsd_flag in varchar2 default hr_api.g_varchar2
212: ,p_not_crtd_flag in varchar2 default hr_api.g_varchar2
213: ,p_stl_actv_flag in varchar2 default hr_api.g_varchar2

Line 210: ,p_open_and_clsd_flag in varchar2 default hr_api.g_varchar2

206: ,p_replcd_flag in varchar2 default hr_api.g_varchar2
207: ,p_crtd_flag in varchar2 default hr_api.g_varchar2
208: ,p_tmprl_flag in varchar2 default hr_api.g_varchar2
209: ,p_dltd_flag in varchar2 default hr_api.g_varchar2
210: ,p_open_and_clsd_flag in varchar2 default hr_api.g_varchar2
211: ,p_clsd_flag in varchar2 default hr_api.g_varchar2
212: ,p_not_crtd_flag in varchar2 default hr_api.g_varchar2
213: ,p_stl_actv_flag in varchar2 default hr_api.g_varchar2
214: ,p_clpsd_flag in varchar2 default hr_api.g_varchar2

Line 211: ,p_clsd_flag in varchar2 default hr_api.g_varchar2

207: ,p_crtd_flag in varchar2 default hr_api.g_varchar2
208: ,p_tmprl_flag in varchar2 default hr_api.g_varchar2
209: ,p_dltd_flag in varchar2 default hr_api.g_varchar2
210: ,p_open_and_clsd_flag in varchar2 default hr_api.g_varchar2
211: ,p_clsd_flag in varchar2 default hr_api.g_varchar2
212: ,p_not_crtd_flag in varchar2 default hr_api.g_varchar2
213: ,p_stl_actv_flag in varchar2 default hr_api.g_varchar2
214: ,p_clpsd_flag in varchar2 default hr_api.g_varchar2
215: ,p_clsn_flag in varchar2 default hr_api.g_varchar2

Line 212: ,p_not_crtd_flag in varchar2 default hr_api.g_varchar2

208: ,p_tmprl_flag in varchar2 default hr_api.g_varchar2
209: ,p_dltd_flag in varchar2 default hr_api.g_varchar2
210: ,p_open_and_clsd_flag in varchar2 default hr_api.g_varchar2
211: ,p_clsd_flag in varchar2 default hr_api.g_varchar2
212: ,p_not_crtd_flag in varchar2 default hr_api.g_varchar2
213: ,p_stl_actv_flag in varchar2 default hr_api.g_varchar2
214: ,p_clpsd_flag in varchar2 default hr_api.g_varchar2
215: ,p_clsn_flag in varchar2 default hr_api.g_varchar2
216: ,p_no_effect_flag in varchar2 default hr_api.g_varchar2

Line 213: ,p_stl_actv_flag in varchar2 default hr_api.g_varchar2

209: ,p_dltd_flag in varchar2 default hr_api.g_varchar2
210: ,p_open_and_clsd_flag in varchar2 default hr_api.g_varchar2
211: ,p_clsd_flag in varchar2 default hr_api.g_varchar2
212: ,p_not_crtd_flag in varchar2 default hr_api.g_varchar2
213: ,p_stl_actv_flag in varchar2 default hr_api.g_varchar2
214: ,p_clpsd_flag in varchar2 default hr_api.g_varchar2
215: ,p_clsn_flag in varchar2 default hr_api.g_varchar2
216: ,p_no_effect_flag in varchar2 default hr_api.g_varchar2
217: ,p_cvrge_rt_prem_flag in varchar2 default hr_api.g_varchar2

Line 214: ,p_clpsd_flag in varchar2 default hr_api.g_varchar2

210: ,p_open_and_clsd_flag in varchar2 default hr_api.g_varchar2
211: ,p_clsd_flag in varchar2 default hr_api.g_varchar2
212: ,p_not_crtd_flag in varchar2 default hr_api.g_varchar2
213: ,p_stl_actv_flag in varchar2 default hr_api.g_varchar2
214: ,p_clpsd_flag in varchar2 default hr_api.g_varchar2
215: ,p_clsn_flag in varchar2 default hr_api.g_varchar2
216: ,p_no_effect_flag in varchar2 default hr_api.g_varchar2
217: ,p_cvrge_rt_prem_flag in varchar2 default hr_api.g_varchar2
218: ,p_per_in_ler_id in number default hr_api.g_number

Line 215: ,p_clsn_flag in varchar2 default hr_api.g_varchar2

211: ,p_clsd_flag in varchar2 default hr_api.g_varchar2
212: ,p_not_crtd_flag in varchar2 default hr_api.g_varchar2
213: ,p_stl_actv_flag in varchar2 default hr_api.g_varchar2
214: ,p_clpsd_flag in varchar2 default hr_api.g_varchar2
215: ,p_clsn_flag in varchar2 default hr_api.g_varchar2
216: ,p_no_effect_flag in varchar2 default hr_api.g_varchar2
217: ,p_cvrge_rt_prem_flag in varchar2 default hr_api.g_varchar2
218: ,p_per_in_ler_id in number default hr_api.g_number
219: ,p_business_group_id in number default hr_api.g_number

Line 216: ,p_no_effect_flag in varchar2 default hr_api.g_varchar2

212: ,p_not_crtd_flag in varchar2 default hr_api.g_varchar2
213: ,p_stl_actv_flag in varchar2 default hr_api.g_varchar2
214: ,p_clpsd_flag in varchar2 default hr_api.g_varchar2
215: ,p_clsn_flag in varchar2 default hr_api.g_varchar2
216: ,p_no_effect_flag in varchar2 default hr_api.g_varchar2
217: ,p_cvrge_rt_prem_flag in varchar2 default hr_api.g_varchar2
218: ,p_per_in_ler_id in number default hr_api.g_number
219: ,p_business_group_id in number default hr_api.g_number
220: ,p_object_version_number in out nocopy number

Line 217: ,p_cvrge_rt_prem_flag in varchar2 default hr_api.g_varchar2

213: ,p_stl_actv_flag in varchar2 default hr_api.g_varchar2
214: ,p_clpsd_flag in varchar2 default hr_api.g_varchar2
215: ,p_clsn_flag in varchar2 default hr_api.g_varchar2
216: ,p_no_effect_flag in varchar2 default hr_api.g_varchar2
217: ,p_cvrge_rt_prem_flag in varchar2 default hr_api.g_varchar2
218: ,p_per_in_ler_id in number default hr_api.g_number
219: ,p_business_group_id in number default hr_api.g_number
220: ,p_object_version_number in out nocopy number
221: ,p_effective_date in date) is

Line 218: ,p_per_in_ler_id in number default hr_api.g_number

214: ,p_clpsd_flag in varchar2 default hr_api.g_varchar2
215: ,p_clsn_flag in varchar2 default hr_api.g_varchar2
216: ,p_no_effect_flag in varchar2 default hr_api.g_varchar2
217: ,p_cvrge_rt_prem_flag in varchar2 default hr_api.g_varchar2
218: ,p_per_in_ler_id in number default hr_api.g_number
219: ,p_business_group_id in number default hr_api.g_number
220: ,p_object_version_number in out nocopy number
221: ,p_effective_date in date) is
222: --

Line 219: ,p_business_group_id in number default hr_api.g_number

215: ,p_clsn_flag in varchar2 default hr_api.g_varchar2
216: ,p_no_effect_flag in varchar2 default hr_api.g_varchar2
217: ,p_cvrge_rt_prem_flag in varchar2 default hr_api.g_varchar2
218: ,p_per_in_ler_id in number default hr_api.g_number
219: ,p_business_group_id in number default hr_api.g_number
220: ,p_object_version_number in out nocopy number
221: ,p_effective_date in date) is
222: --
223: -- Declare cursors and local variables

Line 271: when hr_api.cannot_find_prog_unit then

267: ,p_effective_date => trunc(p_effective_date));
268: --
269: exception
270: --
271: when hr_api.cannot_find_prog_unit then
272: --
273: hr_api.cannot_find_prog_unit_error
274: (p_module_name => 'UPDATE_batch_ler_info'
275: ,p_hook_type => 'BP');

Line 273: hr_api.cannot_find_prog_unit_error

269: exception
270: --
271: when hr_api.cannot_find_prog_unit then
272: --
273: hr_api.cannot_find_prog_unit_error
274: (p_module_name => 'UPDATE_batch_ler_info'
275: ,p_hook_type => 'BP');
276: --
277: -- End of API User Hook for the before hook of update_batch_ler_info

Line 333: when hr_api.cannot_find_prog_unit then

329: ,p_effective_date => trunc(p_effective_date));
330: --
331: exception
332: --
333: when hr_api.cannot_find_prog_unit then
334: --
335: hr_api.cannot_find_prog_unit_error
336: (p_module_name => 'UPDATE_batch_ler_info'
337: ,p_hook_type => 'AP');

Line 335: hr_api.cannot_find_prog_unit_error

331: exception
332: --
333: when hr_api.cannot_find_prog_unit then
334: --
335: hr_api.cannot_find_prog_unit_error
336: (p_module_name => 'UPDATE_batch_ler_info'
337: ,p_hook_type => 'AP');
338: --
339: -- End of API User Hook for the after hook of update_batch_ler_info

Line 348: raise hr_api.validate_enabled;

344: --
345: -- When in validation only mode raise the Validate_Enabled exception
346: --
347: if p_validate then
348: raise hr_api.validate_enabled;
349: end if;
350: --
351: -- Set all output arguments
352: --

Line 359: when hr_api.validate_enabled then

355: hr_utility.set_location(' Leaving:'||l_proc, 70);
356: --
357: exception
358: --
359: when hr_api.validate_enabled then
360: --
361: -- As the Validate_Enabled exception has been raised
362: -- we must rollback to the savepoint
363: --

Line 421: when hr_api.cannot_find_prog_unit then

417: ,p_effective_date => trunc(p_effective_date));
418: --
419: exception
420: --
421: when hr_api.cannot_find_prog_unit then
422: --
423: hr_api.cannot_find_prog_unit_error
424: (p_module_name => 'DELETE_batch_ler_info'
425: ,p_hook_type => 'BP');

Line 423: hr_api.cannot_find_prog_unit_error

419: exception
420: --
421: when hr_api.cannot_find_prog_unit then
422: --
423: hr_api.cannot_find_prog_unit_error
424: (p_module_name => 'DELETE_batch_ler_info'
425: ,p_hook_type => 'BP');
426: --
427: -- End of API User Hook for the before hook of delete_batch_ler_info

Line 447: when hr_api.cannot_find_prog_unit then

443: ,p_effective_date => trunc(p_effective_date));
444: --
445: exception
446: --
447: when hr_api.cannot_find_prog_unit then
448: --
449: hr_api.cannot_find_prog_unit_error
450: (p_module_name => 'DELETE_batch_ler_info'
451: ,p_hook_type => 'AP');

Line 449: hr_api.cannot_find_prog_unit_error

445: exception
446: --
447: when hr_api.cannot_find_prog_unit then
448: --
449: hr_api.cannot_find_prog_unit_error
450: (p_module_name => 'DELETE_batch_ler_info'
451: ,p_hook_type => 'AP');
452: --
453: -- End of API User Hook for the after hook of delete_batch_ler_info

Line 462: raise hr_api.validate_enabled;

458: --
459: -- When in validation only mode raise the Validate_Enabled exception
460: --
461: if p_validate then
462: raise hr_api.validate_enabled;
463: end if;
464: --
465: hr_utility.set_location(' Leaving:'||l_proc, 70);
466: --

Line 469: when hr_api.validate_enabled then

465: hr_utility.set_location(' Leaving:'||l_proc, 70);
466: --
467: exception
468: --
469: when hr_api.validate_enabled then
470: --
471: -- As the Validate_Enabled exception has been raised
472: -- we must rollback to the savepoint
473: --