DBA Data[Home] [Help]

APPS.BEN_BATCH_RATE_INFO_API dependencies on HR_API

Line 87: when hr_api.cannot_find_prog_unit then

83: ,p_effective_date => trunc(p_effective_date));
84: --
85: exception
86: --
87: when hr_api.cannot_find_prog_unit then
88: --
89: hr_api.cannot_find_prog_unit_error
90: (p_module_name => 'CREATE_batch_rate_info'
91: ,p_hook_type => 'BP');

Line 89: hr_api.cannot_find_prog_unit_error

85: exception
86: --
87: when hr_api.cannot_find_prog_unit then
88: --
89: hr_api.cannot_find_prog_unit_error
90: (p_module_name => 'CREATE_batch_rate_info'
91: ,p_hook_type => 'BP');
92: --
93: -- End of API User Hook for the before hook of create_batch_rate_info

Line 155: when hr_api.cannot_find_prog_unit then

151: ,p_effective_date => trunc(p_effective_date));
152: --
153: exception
154: --
155: when hr_api.cannot_find_prog_unit then
156: --
157: hr_api.cannot_find_prog_unit_error
158: (p_module_name => 'CREATE_batch_rate_info'
159: ,p_hook_type => 'AP');

Line 157: hr_api.cannot_find_prog_unit_error

153: exception
154: --
155: when hr_api.cannot_find_prog_unit then
156: --
157: hr_api.cannot_find_prog_unit_error
158: (p_module_name => 'CREATE_batch_rate_info'
159: ,p_hook_type => 'AP');
160: --
161: -- End of API User Hook for the after hook of create_batch_rate_info

Line 170: raise hr_api.validate_enabled;

166: --
167: -- When in validation only mode raise the Validate_Enabled exception
168: --
169: if p_validate then
170: raise hr_api.validate_enabled;
171: end if;
172: --
173: -- Set all output arguments
174: --

Line 182: when hr_api.validate_enabled then

178: hr_utility.set_location(' Leaving:'||l_proc, 70);
179: --
180: exception
181: --
182: when hr_api.validate_enabled then
183: --
184: -- As the Validate_Enabled exception has been raised
185: -- we must rollback to the savepoint
186: --

Line 216: ,p_benefit_action_id in number default hr_api.g_number

212: --
213: procedure update_batch_rate_info
214: (p_validate in boolean default false
215: ,p_batch_rt_id in number
216: ,p_benefit_action_id in number default hr_api.g_number
217: ,p_person_id in number default hr_api.g_number
218: ,p_pgm_id in number default hr_api.g_number
219: ,p_pl_id in number default hr_api.g_number
220: ,p_oipl_id in number default hr_api.g_number

Line 217: ,p_person_id in number default hr_api.g_number

213: procedure update_batch_rate_info
214: (p_validate in boolean default false
215: ,p_batch_rt_id in number
216: ,p_benefit_action_id in number default hr_api.g_number
217: ,p_person_id in number default hr_api.g_number
218: ,p_pgm_id in number default hr_api.g_number
219: ,p_pl_id in number default hr_api.g_number
220: ,p_oipl_id in number default hr_api.g_number
221: ,p_bnft_rt_typ_cd in varchar2 default hr_api.g_varchar2

Line 218: ,p_pgm_id in number default hr_api.g_number

214: (p_validate in boolean default false
215: ,p_batch_rt_id in number
216: ,p_benefit_action_id in number default hr_api.g_number
217: ,p_person_id in number default hr_api.g_number
218: ,p_pgm_id in number default hr_api.g_number
219: ,p_pl_id in number default hr_api.g_number
220: ,p_oipl_id in number default hr_api.g_number
221: ,p_bnft_rt_typ_cd in varchar2 default hr_api.g_varchar2
222: ,p_dflt_flag in varchar2 default hr_api.g_varchar2

Line 219: ,p_pl_id in number default hr_api.g_number

215: ,p_batch_rt_id in number
216: ,p_benefit_action_id in number default hr_api.g_number
217: ,p_person_id in number default hr_api.g_number
218: ,p_pgm_id in number default hr_api.g_number
219: ,p_pl_id in number default hr_api.g_number
220: ,p_oipl_id in number default hr_api.g_number
221: ,p_bnft_rt_typ_cd in varchar2 default hr_api.g_varchar2
222: ,p_dflt_flag in varchar2 default hr_api.g_varchar2
223: ,p_val in number default hr_api.g_number

Line 220: ,p_oipl_id in number default hr_api.g_number

216: ,p_benefit_action_id in number default hr_api.g_number
217: ,p_person_id in number default hr_api.g_number
218: ,p_pgm_id in number default hr_api.g_number
219: ,p_pl_id in number default hr_api.g_number
220: ,p_oipl_id in number default hr_api.g_number
221: ,p_bnft_rt_typ_cd in varchar2 default hr_api.g_varchar2
222: ,p_dflt_flag in varchar2 default hr_api.g_varchar2
223: ,p_val in number default hr_api.g_number
224: ,p_old_val in number default hr_api.g_number

Line 221: ,p_bnft_rt_typ_cd in varchar2 default hr_api.g_varchar2

217: ,p_person_id in number default hr_api.g_number
218: ,p_pgm_id in number default hr_api.g_number
219: ,p_pl_id in number default hr_api.g_number
220: ,p_oipl_id in number default hr_api.g_number
221: ,p_bnft_rt_typ_cd in varchar2 default hr_api.g_varchar2
222: ,p_dflt_flag in varchar2 default hr_api.g_varchar2
223: ,p_val in number default hr_api.g_number
224: ,p_old_val in number default hr_api.g_number
225: ,p_tx_typ_cd in varchar2 default hr_api.g_varchar2

Line 222: ,p_dflt_flag in varchar2 default hr_api.g_varchar2

218: ,p_pgm_id in number default hr_api.g_number
219: ,p_pl_id in number default hr_api.g_number
220: ,p_oipl_id in number default hr_api.g_number
221: ,p_bnft_rt_typ_cd in varchar2 default hr_api.g_varchar2
222: ,p_dflt_flag in varchar2 default hr_api.g_varchar2
223: ,p_val in number default hr_api.g_number
224: ,p_old_val in number default hr_api.g_number
225: ,p_tx_typ_cd in varchar2 default hr_api.g_varchar2
226: ,p_acty_typ_cd in varchar2 default hr_api.g_varchar2

Line 223: ,p_val in number default hr_api.g_number

219: ,p_pl_id in number default hr_api.g_number
220: ,p_oipl_id in number default hr_api.g_number
221: ,p_bnft_rt_typ_cd in varchar2 default hr_api.g_varchar2
222: ,p_dflt_flag in varchar2 default hr_api.g_varchar2
223: ,p_val in number default hr_api.g_number
224: ,p_old_val in number default hr_api.g_number
225: ,p_tx_typ_cd in varchar2 default hr_api.g_varchar2
226: ,p_acty_typ_cd in varchar2 default hr_api.g_varchar2
227: ,p_mn_elcn_val in number default hr_api.g_number

Line 224: ,p_old_val in number default hr_api.g_number

220: ,p_oipl_id in number default hr_api.g_number
221: ,p_bnft_rt_typ_cd in varchar2 default hr_api.g_varchar2
222: ,p_dflt_flag in varchar2 default hr_api.g_varchar2
223: ,p_val in number default hr_api.g_number
224: ,p_old_val in number default hr_api.g_number
225: ,p_tx_typ_cd in varchar2 default hr_api.g_varchar2
226: ,p_acty_typ_cd in varchar2 default hr_api.g_varchar2
227: ,p_mn_elcn_val in number default hr_api.g_number
228: ,p_mx_elcn_val in number default hr_api.g_number

Line 225: ,p_tx_typ_cd in varchar2 default hr_api.g_varchar2

221: ,p_bnft_rt_typ_cd in varchar2 default hr_api.g_varchar2
222: ,p_dflt_flag in varchar2 default hr_api.g_varchar2
223: ,p_val in number default hr_api.g_number
224: ,p_old_val in number default hr_api.g_number
225: ,p_tx_typ_cd in varchar2 default hr_api.g_varchar2
226: ,p_acty_typ_cd in varchar2 default hr_api.g_varchar2
227: ,p_mn_elcn_val in number default hr_api.g_number
228: ,p_mx_elcn_val in number default hr_api.g_number
229: ,p_incrmt_elcn_val in number default hr_api.g_number

Line 226: ,p_acty_typ_cd in varchar2 default hr_api.g_varchar2

222: ,p_dflt_flag in varchar2 default hr_api.g_varchar2
223: ,p_val in number default hr_api.g_number
224: ,p_old_val in number default hr_api.g_number
225: ,p_tx_typ_cd in varchar2 default hr_api.g_varchar2
226: ,p_acty_typ_cd in varchar2 default hr_api.g_varchar2
227: ,p_mn_elcn_val in number default hr_api.g_number
228: ,p_mx_elcn_val in number default hr_api.g_number
229: ,p_incrmt_elcn_val in number default hr_api.g_number
230: ,p_dflt_val in number default hr_api.g_number

Line 227: ,p_mn_elcn_val in number default hr_api.g_number

223: ,p_val in number default hr_api.g_number
224: ,p_old_val in number default hr_api.g_number
225: ,p_tx_typ_cd in varchar2 default hr_api.g_varchar2
226: ,p_acty_typ_cd in varchar2 default hr_api.g_varchar2
227: ,p_mn_elcn_val in number default hr_api.g_number
228: ,p_mx_elcn_val in number default hr_api.g_number
229: ,p_incrmt_elcn_val in number default hr_api.g_number
230: ,p_dflt_val in number default hr_api.g_number
231: ,p_rt_strt_dt in date default hr_api.g_date

Line 228: ,p_mx_elcn_val in number default hr_api.g_number

224: ,p_old_val in number default hr_api.g_number
225: ,p_tx_typ_cd in varchar2 default hr_api.g_varchar2
226: ,p_acty_typ_cd in varchar2 default hr_api.g_varchar2
227: ,p_mn_elcn_val in number default hr_api.g_number
228: ,p_mx_elcn_val in number default hr_api.g_number
229: ,p_incrmt_elcn_val in number default hr_api.g_number
230: ,p_dflt_val in number default hr_api.g_number
231: ,p_rt_strt_dt in date default hr_api.g_date
232: ,p_business_group_id in number default hr_api.g_number

Line 229: ,p_incrmt_elcn_val in number default hr_api.g_number

225: ,p_tx_typ_cd in varchar2 default hr_api.g_varchar2
226: ,p_acty_typ_cd in varchar2 default hr_api.g_varchar2
227: ,p_mn_elcn_val in number default hr_api.g_number
228: ,p_mx_elcn_val in number default hr_api.g_number
229: ,p_incrmt_elcn_val in number default hr_api.g_number
230: ,p_dflt_val in number default hr_api.g_number
231: ,p_rt_strt_dt in date default hr_api.g_date
232: ,p_business_group_id in number default hr_api.g_number
233: ,p_object_version_number in out nocopy number

Line 230: ,p_dflt_val in number default hr_api.g_number

226: ,p_acty_typ_cd in varchar2 default hr_api.g_varchar2
227: ,p_mn_elcn_val in number default hr_api.g_number
228: ,p_mx_elcn_val in number default hr_api.g_number
229: ,p_incrmt_elcn_val in number default hr_api.g_number
230: ,p_dflt_val in number default hr_api.g_number
231: ,p_rt_strt_dt in date default hr_api.g_date
232: ,p_business_group_id in number default hr_api.g_number
233: ,p_object_version_number in out nocopy number
234: ,p_enrt_cvg_strt_dt in date default hr_api.g_date

Line 231: ,p_rt_strt_dt in date default hr_api.g_date

227: ,p_mn_elcn_val in number default hr_api.g_number
228: ,p_mx_elcn_val in number default hr_api.g_number
229: ,p_incrmt_elcn_val in number default hr_api.g_number
230: ,p_dflt_val in number default hr_api.g_number
231: ,p_rt_strt_dt in date default hr_api.g_date
232: ,p_business_group_id in number default hr_api.g_number
233: ,p_object_version_number in out nocopy number
234: ,p_enrt_cvg_strt_dt in date default hr_api.g_date
235: ,p_enrt_cvg_thru_dt in date default hr_api.g_date

Line 232: ,p_business_group_id in number default hr_api.g_number

228: ,p_mx_elcn_val in number default hr_api.g_number
229: ,p_incrmt_elcn_val in number default hr_api.g_number
230: ,p_dflt_val in number default hr_api.g_number
231: ,p_rt_strt_dt in date default hr_api.g_date
232: ,p_business_group_id in number default hr_api.g_number
233: ,p_object_version_number in out nocopy number
234: ,p_enrt_cvg_strt_dt in date default hr_api.g_date
235: ,p_enrt_cvg_thru_dt in date default hr_api.g_date
236: ,p_actn_cd in varchar2 default hr_api.g_varchar2

Line 234: ,p_enrt_cvg_strt_dt in date default hr_api.g_date

230: ,p_dflt_val in number default hr_api.g_number
231: ,p_rt_strt_dt in date default hr_api.g_date
232: ,p_business_group_id in number default hr_api.g_number
233: ,p_object_version_number in out nocopy number
234: ,p_enrt_cvg_strt_dt in date default hr_api.g_date
235: ,p_enrt_cvg_thru_dt in date default hr_api.g_date
236: ,p_actn_cd in varchar2 default hr_api.g_varchar2
237: ,p_close_actn_itm_dt in date default hr_api.g_date
238: ,p_effective_date in date) is

Line 235: ,p_enrt_cvg_thru_dt in date default hr_api.g_date

231: ,p_rt_strt_dt in date default hr_api.g_date
232: ,p_business_group_id in number default hr_api.g_number
233: ,p_object_version_number in out nocopy number
234: ,p_enrt_cvg_strt_dt in date default hr_api.g_date
235: ,p_enrt_cvg_thru_dt in date default hr_api.g_date
236: ,p_actn_cd in varchar2 default hr_api.g_varchar2
237: ,p_close_actn_itm_dt in date default hr_api.g_date
238: ,p_effective_date in date) is
239: --

Line 236: ,p_actn_cd in varchar2 default hr_api.g_varchar2

232: ,p_business_group_id in number default hr_api.g_number
233: ,p_object_version_number in out nocopy number
234: ,p_enrt_cvg_strt_dt in date default hr_api.g_date
235: ,p_enrt_cvg_thru_dt in date default hr_api.g_date
236: ,p_actn_cd in varchar2 default hr_api.g_varchar2
237: ,p_close_actn_itm_dt in date default hr_api.g_date
238: ,p_effective_date in date) is
239: --
240: -- Declare cursors and local variables

Line 237: ,p_close_actn_itm_dt in date default hr_api.g_date

233: ,p_object_version_number in out nocopy number
234: ,p_enrt_cvg_strt_dt in date default hr_api.g_date
235: ,p_enrt_cvg_thru_dt in date default hr_api.g_date
236: ,p_actn_cd in varchar2 default hr_api.g_varchar2
237: ,p_close_actn_itm_dt in date default hr_api.g_date
238: ,p_effective_date in date) is
239: --
240: -- Declare cursors and local variables
241: --

Line 291: when hr_api.cannot_find_prog_unit then

287: ,p_effective_date => trunc(p_effective_date));
288: --
289: exception
290: --
291: when hr_api.cannot_find_prog_unit then
292: --
293: hr_api.cannot_find_prog_unit_error
294: (p_module_name => 'UPDATE_batch_rate_info'
295: ,p_hook_type => 'BP');

Line 293: hr_api.cannot_find_prog_unit_error

289: exception
290: --
291: when hr_api.cannot_find_prog_unit then
292: --
293: hr_api.cannot_find_prog_unit_error
294: (p_module_name => 'UPDATE_batch_rate_info'
295: ,p_hook_type => 'BP');
296: --
297: -- End of API User Hook for the before hook of update_batch_rate_info

Line 359: when hr_api.cannot_find_prog_unit then

355: ,p_effective_date => trunc(p_effective_date));
356: --
357: exception
358: --
359: when hr_api.cannot_find_prog_unit then
360: --
361: hr_api.cannot_find_prog_unit_error
362: (p_module_name => 'UPDATE_batch_rate_info'
363: ,p_hook_type => 'AP');

Line 361: hr_api.cannot_find_prog_unit_error

357: exception
358: --
359: when hr_api.cannot_find_prog_unit then
360: --
361: hr_api.cannot_find_prog_unit_error
362: (p_module_name => 'UPDATE_batch_rate_info'
363: ,p_hook_type => 'AP');
364: --
365: -- End of API User Hook for the after hook of update_batch_rate_info

Line 374: raise hr_api.validate_enabled;

370: --
371: -- When in validation only mode raise the Validate_Enabled exception
372: --
373: if p_validate then
374: raise hr_api.validate_enabled;
375: end if;
376: --
377: -- Set all output arguments
378: --

Line 385: when hr_api.validate_enabled then

381: hr_utility.set_location(' Leaving:'||l_proc, 70);
382: --
383: exception
384: --
385: when hr_api.validate_enabled then
386: --
387: -- As the Validate_Enabled exception has been raised
388: -- we must rollback to the savepoint
389: --

Line 450: when hr_api.cannot_find_prog_unit then

446: ,p_effective_date => trunc(p_effective_date));
447: --
448: exception
449: --
450: when hr_api.cannot_find_prog_unit then
451: --
452: hr_api.cannot_find_prog_unit_error
453: (p_module_name => 'DELETE_batch_rate_info'
454: ,p_hook_type => 'BP');

Line 452: hr_api.cannot_find_prog_unit_error

448: exception
449: --
450: when hr_api.cannot_find_prog_unit then
451: --
452: hr_api.cannot_find_prog_unit_error
453: (p_module_name => 'DELETE_batch_rate_info'
454: ,p_hook_type => 'BP');
455: --
456: -- End of API User Hook for the before hook of delete_batch_rate_info

Line 476: when hr_api.cannot_find_prog_unit then

472: ,p_effective_date => trunc(p_effective_date));
473: --
474: exception
475: --
476: when hr_api.cannot_find_prog_unit then
477: --
478: hr_api.cannot_find_prog_unit_error
479: (p_module_name => 'DELETE_batch_rate_info'
480: ,p_hook_type => 'AP');

Line 478: hr_api.cannot_find_prog_unit_error

474: exception
475: --
476: when hr_api.cannot_find_prog_unit then
477: --
478: hr_api.cannot_find_prog_unit_error
479: (p_module_name => 'DELETE_batch_rate_info'
480: ,p_hook_type => 'AP');
481: --
482: -- End of API User Hook for the after hook of delete_batch_rate_info

Line 491: raise hr_api.validate_enabled;

487: --
488: -- When in validation only mode raise the Validate_Enabled exception
489: --
490: if p_validate then
491: raise hr_api.validate_enabled;
492: end if;
493: --
494: hr_utility.set_location(' Leaving:'||l_proc, 70);
495: --

Line 498: when hr_api.validate_enabled then

494: hr_utility.set_location(' Leaving:'||l_proc, 70);
495: --
496: exception
497: --
498: when hr_api.validate_enabled then
499: --
500: -- As the Validate_Enabled exception has been raised
501: -- we must rollback to the savepoint
502: --