DBA Data[Home] [Help]

APPS.BEN_BNFT_POOL_RLOVR_RQMT_API dependencies on HR_API

Line 156: when hr_api.cannot_find_prog_unit then

152: ,p_bpr_attribute30 => p_bpr_attribute30
153: ,p_effective_date => trunc(p_effective_date)
154: );
155: exception
156: when hr_api.cannot_find_prog_unit then
157: hr_api.cannot_find_prog_unit_error
158: (
159: p_module_name => 'CREATE_Bnft_Pool_Rlovr_Rqmt'
160: ,p_hook_type => 'BP'

Line 157: hr_api.cannot_find_prog_unit_error

153: ,p_effective_date => trunc(p_effective_date)
154: );
155: exception
156: when hr_api.cannot_find_prog_unit then
157: hr_api.cannot_find_prog_unit_error
158: (
159: p_module_name => 'CREATE_Bnft_Pool_Rlovr_Rqmt'
160: ,p_hook_type => 'BP'
161: );

Line 295: when hr_api.cannot_find_prog_unit then

291: ,p_object_version_number => l_object_version_number
292: ,p_effective_date => trunc(p_effective_date)
293: );
294: exception
295: when hr_api.cannot_find_prog_unit then
296: hr_api.cannot_find_prog_unit_error
297: (p_module_name => 'CREATE_Bnft_Pool_Rlovr_Rqmt'
298: ,p_hook_type => 'AP'
299: );

Line 296: hr_api.cannot_find_prog_unit_error

292: ,p_effective_date => trunc(p_effective_date)
293: );
294: exception
295: when hr_api.cannot_find_prog_unit then
296: hr_api.cannot_find_prog_unit_error
297: (p_module_name => 'CREATE_Bnft_Pool_Rlovr_Rqmt'
298: ,p_hook_type => 'AP'
299: );
300: --

Line 310: raise hr_api.validate_enabled;

306: --
307: -- When in validation only mode raise the Validate_Enabled exception
308: --
309: if p_validate then
310: raise hr_api.validate_enabled;
311: end if;
312: --
313: -- Set all output arguments
314: --

Line 324: when hr_api.validate_enabled then

320: hr_utility.set_location(' Leaving:'||l_proc, 70);
321: --
322: exception
323: --
324: when hr_api.validate_enabled then
325: --
326: -- As the Validate_Enabled exception has been raised
327: -- we must rollback to the savepoint
328: --

Line 358: ,p_no_mn_rlovr_pct_dfnd_flag in varchar2 default hr_api.g_varchar2

354: (p_validate in boolean default false
355: ,p_bnft_pool_rlovr_rqmt_id in number
356: ,p_effective_start_date out nocopy date
357: ,p_effective_end_date out nocopy date
358: ,p_no_mn_rlovr_pct_dfnd_flag in varchar2 default hr_api.g_varchar2
359: ,p_no_mx_rlovr_pct_dfnd_flag in varchar2 default hr_api.g_varchar2
360: ,p_no_mn_rlovr_val_dfnd_flag in varchar2 default hr_api.g_varchar2
361: ,p_no_mx_rlovr_val_dfnd_flag in varchar2 default hr_api.g_varchar2
362: ,p_rlovr_val_incrmt_num in number default hr_api.g_number

Line 359: ,p_no_mx_rlovr_pct_dfnd_flag in varchar2 default hr_api.g_varchar2

355: ,p_bnft_pool_rlovr_rqmt_id in number
356: ,p_effective_start_date out nocopy date
357: ,p_effective_end_date out nocopy date
358: ,p_no_mn_rlovr_pct_dfnd_flag in varchar2 default hr_api.g_varchar2
359: ,p_no_mx_rlovr_pct_dfnd_flag in varchar2 default hr_api.g_varchar2
360: ,p_no_mn_rlovr_val_dfnd_flag in varchar2 default hr_api.g_varchar2
361: ,p_no_mx_rlovr_val_dfnd_flag in varchar2 default hr_api.g_varchar2
362: ,p_rlovr_val_incrmt_num in number default hr_api.g_number
363: ,p_rlovr_val_rl in number default hr_api.g_number

Line 360: ,p_no_mn_rlovr_val_dfnd_flag in varchar2 default hr_api.g_varchar2

356: ,p_effective_start_date out nocopy date
357: ,p_effective_end_date out nocopy date
358: ,p_no_mn_rlovr_pct_dfnd_flag in varchar2 default hr_api.g_varchar2
359: ,p_no_mx_rlovr_pct_dfnd_flag in varchar2 default hr_api.g_varchar2
360: ,p_no_mn_rlovr_val_dfnd_flag in varchar2 default hr_api.g_varchar2
361: ,p_no_mx_rlovr_val_dfnd_flag in varchar2 default hr_api.g_varchar2
362: ,p_rlovr_val_incrmt_num in number default hr_api.g_number
363: ,p_rlovr_val_rl in number default hr_api.g_number
364: ,p_mn_rlovr_val in number default hr_api.g_number

Line 361: ,p_no_mx_rlovr_val_dfnd_flag in varchar2 default hr_api.g_varchar2

357: ,p_effective_end_date out nocopy date
358: ,p_no_mn_rlovr_pct_dfnd_flag in varchar2 default hr_api.g_varchar2
359: ,p_no_mx_rlovr_pct_dfnd_flag in varchar2 default hr_api.g_varchar2
360: ,p_no_mn_rlovr_val_dfnd_flag in varchar2 default hr_api.g_varchar2
361: ,p_no_mx_rlovr_val_dfnd_flag in varchar2 default hr_api.g_varchar2
362: ,p_rlovr_val_incrmt_num in number default hr_api.g_number
363: ,p_rlovr_val_rl in number default hr_api.g_number
364: ,p_mn_rlovr_val in number default hr_api.g_number
365: ,p_mx_rlovr_val in number default hr_api.g_number

Line 362: ,p_rlovr_val_incrmt_num in number default hr_api.g_number

358: ,p_no_mn_rlovr_pct_dfnd_flag in varchar2 default hr_api.g_varchar2
359: ,p_no_mx_rlovr_pct_dfnd_flag in varchar2 default hr_api.g_varchar2
360: ,p_no_mn_rlovr_val_dfnd_flag in varchar2 default hr_api.g_varchar2
361: ,p_no_mx_rlovr_val_dfnd_flag in varchar2 default hr_api.g_varchar2
362: ,p_rlovr_val_incrmt_num in number default hr_api.g_number
363: ,p_rlovr_val_rl in number default hr_api.g_number
364: ,p_mn_rlovr_val in number default hr_api.g_number
365: ,p_mx_rlovr_val in number default hr_api.g_number
366: ,p_val_rndg_cd in varchar2 default hr_api.g_varchar2

Line 363: ,p_rlovr_val_rl in number default hr_api.g_number

359: ,p_no_mx_rlovr_pct_dfnd_flag in varchar2 default hr_api.g_varchar2
360: ,p_no_mn_rlovr_val_dfnd_flag in varchar2 default hr_api.g_varchar2
361: ,p_no_mx_rlovr_val_dfnd_flag in varchar2 default hr_api.g_varchar2
362: ,p_rlovr_val_incrmt_num in number default hr_api.g_number
363: ,p_rlovr_val_rl in number default hr_api.g_number
364: ,p_mn_rlovr_val in number default hr_api.g_number
365: ,p_mx_rlovr_val in number default hr_api.g_number
366: ,p_val_rndg_cd in varchar2 default hr_api.g_varchar2
367: ,p_val_rndg_rl in number default hr_api.g_number

Line 364: ,p_mn_rlovr_val in number default hr_api.g_number

360: ,p_no_mn_rlovr_val_dfnd_flag in varchar2 default hr_api.g_varchar2
361: ,p_no_mx_rlovr_val_dfnd_flag in varchar2 default hr_api.g_varchar2
362: ,p_rlovr_val_incrmt_num in number default hr_api.g_number
363: ,p_rlovr_val_rl in number default hr_api.g_number
364: ,p_mn_rlovr_val in number default hr_api.g_number
365: ,p_mx_rlovr_val in number default hr_api.g_number
366: ,p_val_rndg_cd in varchar2 default hr_api.g_varchar2
367: ,p_val_rndg_rl in number default hr_api.g_number
368: ,p_pct_rndg_cd in varchar2 default hr_api.g_varchar2

Line 365: ,p_mx_rlovr_val in number default hr_api.g_number

361: ,p_no_mx_rlovr_val_dfnd_flag in varchar2 default hr_api.g_varchar2
362: ,p_rlovr_val_incrmt_num in number default hr_api.g_number
363: ,p_rlovr_val_rl in number default hr_api.g_number
364: ,p_mn_rlovr_val in number default hr_api.g_number
365: ,p_mx_rlovr_val in number default hr_api.g_number
366: ,p_val_rndg_cd in varchar2 default hr_api.g_varchar2
367: ,p_val_rndg_rl in number default hr_api.g_number
368: ,p_pct_rndg_cd in varchar2 default hr_api.g_varchar2
369: ,p_pct_rndg_rl in number default hr_api.g_number

Line 366: ,p_val_rndg_cd in varchar2 default hr_api.g_varchar2

362: ,p_rlovr_val_incrmt_num in number default hr_api.g_number
363: ,p_rlovr_val_rl in number default hr_api.g_number
364: ,p_mn_rlovr_val in number default hr_api.g_number
365: ,p_mx_rlovr_val in number default hr_api.g_number
366: ,p_val_rndg_cd in varchar2 default hr_api.g_varchar2
367: ,p_val_rndg_rl in number default hr_api.g_number
368: ,p_pct_rndg_cd in varchar2 default hr_api.g_varchar2
369: ,p_pct_rndg_rl in number default hr_api.g_number
370: ,p_prtt_elig_rlovr_rl in number default hr_api.g_number

Line 367: ,p_val_rndg_rl in number default hr_api.g_number

363: ,p_rlovr_val_rl in number default hr_api.g_number
364: ,p_mn_rlovr_val in number default hr_api.g_number
365: ,p_mx_rlovr_val in number default hr_api.g_number
366: ,p_val_rndg_cd in varchar2 default hr_api.g_varchar2
367: ,p_val_rndg_rl in number default hr_api.g_number
368: ,p_pct_rndg_cd in varchar2 default hr_api.g_varchar2
369: ,p_pct_rndg_rl in number default hr_api.g_number
370: ,p_prtt_elig_rlovr_rl in number default hr_api.g_number
371: ,p_mx_rchd_dflt_ordr_num in number default hr_api.g_number

Line 368: ,p_pct_rndg_cd in varchar2 default hr_api.g_varchar2

364: ,p_mn_rlovr_val in number default hr_api.g_number
365: ,p_mx_rlovr_val in number default hr_api.g_number
366: ,p_val_rndg_cd in varchar2 default hr_api.g_varchar2
367: ,p_val_rndg_rl in number default hr_api.g_number
368: ,p_pct_rndg_cd in varchar2 default hr_api.g_varchar2
369: ,p_pct_rndg_rl in number default hr_api.g_number
370: ,p_prtt_elig_rlovr_rl in number default hr_api.g_number
371: ,p_mx_rchd_dflt_ordr_num in number default hr_api.g_number
372: ,p_pct_rlovr_incrmt_num in number default hr_api.g_number

Line 369: ,p_pct_rndg_rl in number default hr_api.g_number

365: ,p_mx_rlovr_val in number default hr_api.g_number
366: ,p_val_rndg_cd in varchar2 default hr_api.g_varchar2
367: ,p_val_rndg_rl in number default hr_api.g_number
368: ,p_pct_rndg_cd in varchar2 default hr_api.g_varchar2
369: ,p_pct_rndg_rl in number default hr_api.g_number
370: ,p_prtt_elig_rlovr_rl in number default hr_api.g_number
371: ,p_mx_rchd_dflt_ordr_num in number default hr_api.g_number
372: ,p_pct_rlovr_incrmt_num in number default hr_api.g_number
373: ,p_mn_rlovr_pct_num in number default hr_api.g_number

Line 370: ,p_prtt_elig_rlovr_rl in number default hr_api.g_number

366: ,p_val_rndg_cd in varchar2 default hr_api.g_varchar2
367: ,p_val_rndg_rl in number default hr_api.g_number
368: ,p_pct_rndg_cd in varchar2 default hr_api.g_varchar2
369: ,p_pct_rndg_rl in number default hr_api.g_number
370: ,p_prtt_elig_rlovr_rl in number default hr_api.g_number
371: ,p_mx_rchd_dflt_ordr_num in number default hr_api.g_number
372: ,p_pct_rlovr_incrmt_num in number default hr_api.g_number
373: ,p_mn_rlovr_pct_num in number default hr_api.g_number
374: ,p_mx_rlovr_pct_num in number default hr_api.g_number

Line 371: ,p_mx_rchd_dflt_ordr_num in number default hr_api.g_number

367: ,p_val_rndg_rl in number default hr_api.g_number
368: ,p_pct_rndg_cd in varchar2 default hr_api.g_varchar2
369: ,p_pct_rndg_rl in number default hr_api.g_number
370: ,p_prtt_elig_rlovr_rl in number default hr_api.g_number
371: ,p_mx_rchd_dflt_ordr_num in number default hr_api.g_number
372: ,p_pct_rlovr_incrmt_num in number default hr_api.g_number
373: ,p_mn_rlovr_pct_num in number default hr_api.g_number
374: ,p_mx_rlovr_pct_num in number default hr_api.g_number
375: ,p_crs_rlovr_procg_cd in varchar2 default hr_api.g_varchar2

Line 372: ,p_pct_rlovr_incrmt_num in number default hr_api.g_number

368: ,p_pct_rndg_cd in varchar2 default hr_api.g_varchar2
369: ,p_pct_rndg_rl in number default hr_api.g_number
370: ,p_prtt_elig_rlovr_rl in number default hr_api.g_number
371: ,p_mx_rchd_dflt_ordr_num in number default hr_api.g_number
372: ,p_pct_rlovr_incrmt_num in number default hr_api.g_number
373: ,p_mn_rlovr_pct_num in number default hr_api.g_number
374: ,p_mx_rlovr_pct_num in number default hr_api.g_number
375: ,p_crs_rlovr_procg_cd in varchar2 default hr_api.g_varchar2
376: ,p_mx_pct_ttl_crs_cn_roll_num in number default hr_api.g_number

Line 373: ,p_mn_rlovr_pct_num in number default hr_api.g_number

369: ,p_pct_rndg_rl in number default hr_api.g_number
370: ,p_prtt_elig_rlovr_rl in number default hr_api.g_number
371: ,p_mx_rchd_dflt_ordr_num in number default hr_api.g_number
372: ,p_pct_rlovr_incrmt_num in number default hr_api.g_number
373: ,p_mn_rlovr_pct_num in number default hr_api.g_number
374: ,p_mx_rlovr_pct_num in number default hr_api.g_number
375: ,p_crs_rlovr_procg_cd in varchar2 default hr_api.g_varchar2
376: ,p_mx_pct_ttl_crs_cn_roll_num in number default hr_api.g_number
377: ,p_bnft_prvdr_pool_id in number default hr_api.g_number

Line 374: ,p_mx_rlovr_pct_num in number default hr_api.g_number

370: ,p_prtt_elig_rlovr_rl in number default hr_api.g_number
371: ,p_mx_rchd_dflt_ordr_num in number default hr_api.g_number
372: ,p_pct_rlovr_incrmt_num in number default hr_api.g_number
373: ,p_mn_rlovr_pct_num in number default hr_api.g_number
374: ,p_mx_rlovr_pct_num in number default hr_api.g_number
375: ,p_crs_rlovr_procg_cd in varchar2 default hr_api.g_varchar2
376: ,p_mx_pct_ttl_crs_cn_roll_num in number default hr_api.g_number
377: ,p_bnft_prvdr_pool_id in number default hr_api.g_number
378: ,p_acty_base_rt_id in number default hr_api.g_number

Line 375: ,p_crs_rlovr_procg_cd in varchar2 default hr_api.g_varchar2

371: ,p_mx_rchd_dflt_ordr_num in number default hr_api.g_number
372: ,p_pct_rlovr_incrmt_num in number default hr_api.g_number
373: ,p_mn_rlovr_pct_num in number default hr_api.g_number
374: ,p_mx_rlovr_pct_num in number default hr_api.g_number
375: ,p_crs_rlovr_procg_cd in varchar2 default hr_api.g_varchar2
376: ,p_mx_pct_ttl_crs_cn_roll_num in number default hr_api.g_number
377: ,p_bnft_prvdr_pool_id in number default hr_api.g_number
378: ,p_acty_base_rt_id in number default hr_api.g_number
379: ,p_business_group_id in number default hr_api.g_number

Line 376: ,p_mx_pct_ttl_crs_cn_roll_num in number default hr_api.g_number

372: ,p_pct_rlovr_incrmt_num in number default hr_api.g_number
373: ,p_mn_rlovr_pct_num in number default hr_api.g_number
374: ,p_mx_rlovr_pct_num in number default hr_api.g_number
375: ,p_crs_rlovr_procg_cd in varchar2 default hr_api.g_varchar2
376: ,p_mx_pct_ttl_crs_cn_roll_num in number default hr_api.g_number
377: ,p_bnft_prvdr_pool_id in number default hr_api.g_number
378: ,p_acty_base_rt_id in number default hr_api.g_number
379: ,p_business_group_id in number default hr_api.g_number
380: ,p_bpr_attribute_category in varchar2 default hr_api.g_varchar2

Line 377: ,p_bnft_prvdr_pool_id in number default hr_api.g_number

373: ,p_mn_rlovr_pct_num in number default hr_api.g_number
374: ,p_mx_rlovr_pct_num in number default hr_api.g_number
375: ,p_crs_rlovr_procg_cd in varchar2 default hr_api.g_varchar2
376: ,p_mx_pct_ttl_crs_cn_roll_num in number default hr_api.g_number
377: ,p_bnft_prvdr_pool_id in number default hr_api.g_number
378: ,p_acty_base_rt_id in number default hr_api.g_number
379: ,p_business_group_id in number default hr_api.g_number
380: ,p_bpr_attribute_category in varchar2 default hr_api.g_varchar2
381: ,p_bpr_attribute1 in varchar2 default hr_api.g_varchar2

Line 378: ,p_acty_base_rt_id in number default hr_api.g_number

374: ,p_mx_rlovr_pct_num in number default hr_api.g_number
375: ,p_crs_rlovr_procg_cd in varchar2 default hr_api.g_varchar2
376: ,p_mx_pct_ttl_crs_cn_roll_num in number default hr_api.g_number
377: ,p_bnft_prvdr_pool_id in number default hr_api.g_number
378: ,p_acty_base_rt_id in number default hr_api.g_number
379: ,p_business_group_id in number default hr_api.g_number
380: ,p_bpr_attribute_category in varchar2 default hr_api.g_varchar2
381: ,p_bpr_attribute1 in varchar2 default hr_api.g_varchar2
382: ,p_bpr_attribute2 in varchar2 default hr_api.g_varchar2

Line 379: ,p_business_group_id in number default hr_api.g_number

375: ,p_crs_rlovr_procg_cd in varchar2 default hr_api.g_varchar2
376: ,p_mx_pct_ttl_crs_cn_roll_num in number default hr_api.g_number
377: ,p_bnft_prvdr_pool_id in number default hr_api.g_number
378: ,p_acty_base_rt_id in number default hr_api.g_number
379: ,p_business_group_id in number default hr_api.g_number
380: ,p_bpr_attribute_category in varchar2 default hr_api.g_varchar2
381: ,p_bpr_attribute1 in varchar2 default hr_api.g_varchar2
382: ,p_bpr_attribute2 in varchar2 default hr_api.g_varchar2
383: ,p_bpr_attribute3 in varchar2 default hr_api.g_varchar2

Line 380: ,p_bpr_attribute_category in varchar2 default hr_api.g_varchar2

376: ,p_mx_pct_ttl_crs_cn_roll_num in number default hr_api.g_number
377: ,p_bnft_prvdr_pool_id in number default hr_api.g_number
378: ,p_acty_base_rt_id in number default hr_api.g_number
379: ,p_business_group_id in number default hr_api.g_number
380: ,p_bpr_attribute_category in varchar2 default hr_api.g_varchar2
381: ,p_bpr_attribute1 in varchar2 default hr_api.g_varchar2
382: ,p_bpr_attribute2 in varchar2 default hr_api.g_varchar2
383: ,p_bpr_attribute3 in varchar2 default hr_api.g_varchar2
384: ,p_bpr_attribute4 in varchar2 default hr_api.g_varchar2

Line 381: ,p_bpr_attribute1 in varchar2 default hr_api.g_varchar2

377: ,p_bnft_prvdr_pool_id in number default hr_api.g_number
378: ,p_acty_base_rt_id in number default hr_api.g_number
379: ,p_business_group_id in number default hr_api.g_number
380: ,p_bpr_attribute_category in varchar2 default hr_api.g_varchar2
381: ,p_bpr_attribute1 in varchar2 default hr_api.g_varchar2
382: ,p_bpr_attribute2 in varchar2 default hr_api.g_varchar2
383: ,p_bpr_attribute3 in varchar2 default hr_api.g_varchar2
384: ,p_bpr_attribute4 in varchar2 default hr_api.g_varchar2
385: ,p_bpr_attribute5 in varchar2 default hr_api.g_varchar2

Line 382: ,p_bpr_attribute2 in varchar2 default hr_api.g_varchar2

378: ,p_acty_base_rt_id in number default hr_api.g_number
379: ,p_business_group_id in number default hr_api.g_number
380: ,p_bpr_attribute_category in varchar2 default hr_api.g_varchar2
381: ,p_bpr_attribute1 in varchar2 default hr_api.g_varchar2
382: ,p_bpr_attribute2 in varchar2 default hr_api.g_varchar2
383: ,p_bpr_attribute3 in varchar2 default hr_api.g_varchar2
384: ,p_bpr_attribute4 in varchar2 default hr_api.g_varchar2
385: ,p_bpr_attribute5 in varchar2 default hr_api.g_varchar2
386: ,p_bpr_attribute6 in varchar2 default hr_api.g_varchar2

Line 383: ,p_bpr_attribute3 in varchar2 default hr_api.g_varchar2

379: ,p_business_group_id in number default hr_api.g_number
380: ,p_bpr_attribute_category in varchar2 default hr_api.g_varchar2
381: ,p_bpr_attribute1 in varchar2 default hr_api.g_varchar2
382: ,p_bpr_attribute2 in varchar2 default hr_api.g_varchar2
383: ,p_bpr_attribute3 in varchar2 default hr_api.g_varchar2
384: ,p_bpr_attribute4 in varchar2 default hr_api.g_varchar2
385: ,p_bpr_attribute5 in varchar2 default hr_api.g_varchar2
386: ,p_bpr_attribute6 in varchar2 default hr_api.g_varchar2
387: ,p_bpr_attribute7 in varchar2 default hr_api.g_varchar2

Line 384: ,p_bpr_attribute4 in varchar2 default hr_api.g_varchar2

380: ,p_bpr_attribute_category in varchar2 default hr_api.g_varchar2
381: ,p_bpr_attribute1 in varchar2 default hr_api.g_varchar2
382: ,p_bpr_attribute2 in varchar2 default hr_api.g_varchar2
383: ,p_bpr_attribute3 in varchar2 default hr_api.g_varchar2
384: ,p_bpr_attribute4 in varchar2 default hr_api.g_varchar2
385: ,p_bpr_attribute5 in varchar2 default hr_api.g_varchar2
386: ,p_bpr_attribute6 in varchar2 default hr_api.g_varchar2
387: ,p_bpr_attribute7 in varchar2 default hr_api.g_varchar2
388: ,p_bpr_attribute8 in varchar2 default hr_api.g_varchar2

Line 385: ,p_bpr_attribute5 in varchar2 default hr_api.g_varchar2

381: ,p_bpr_attribute1 in varchar2 default hr_api.g_varchar2
382: ,p_bpr_attribute2 in varchar2 default hr_api.g_varchar2
383: ,p_bpr_attribute3 in varchar2 default hr_api.g_varchar2
384: ,p_bpr_attribute4 in varchar2 default hr_api.g_varchar2
385: ,p_bpr_attribute5 in varchar2 default hr_api.g_varchar2
386: ,p_bpr_attribute6 in varchar2 default hr_api.g_varchar2
387: ,p_bpr_attribute7 in varchar2 default hr_api.g_varchar2
388: ,p_bpr_attribute8 in varchar2 default hr_api.g_varchar2
389: ,p_bpr_attribute9 in varchar2 default hr_api.g_varchar2

Line 386: ,p_bpr_attribute6 in varchar2 default hr_api.g_varchar2

382: ,p_bpr_attribute2 in varchar2 default hr_api.g_varchar2
383: ,p_bpr_attribute3 in varchar2 default hr_api.g_varchar2
384: ,p_bpr_attribute4 in varchar2 default hr_api.g_varchar2
385: ,p_bpr_attribute5 in varchar2 default hr_api.g_varchar2
386: ,p_bpr_attribute6 in varchar2 default hr_api.g_varchar2
387: ,p_bpr_attribute7 in varchar2 default hr_api.g_varchar2
388: ,p_bpr_attribute8 in varchar2 default hr_api.g_varchar2
389: ,p_bpr_attribute9 in varchar2 default hr_api.g_varchar2
390: ,p_bpr_attribute10 in varchar2 default hr_api.g_varchar2

Line 387: ,p_bpr_attribute7 in varchar2 default hr_api.g_varchar2

383: ,p_bpr_attribute3 in varchar2 default hr_api.g_varchar2
384: ,p_bpr_attribute4 in varchar2 default hr_api.g_varchar2
385: ,p_bpr_attribute5 in varchar2 default hr_api.g_varchar2
386: ,p_bpr_attribute6 in varchar2 default hr_api.g_varchar2
387: ,p_bpr_attribute7 in varchar2 default hr_api.g_varchar2
388: ,p_bpr_attribute8 in varchar2 default hr_api.g_varchar2
389: ,p_bpr_attribute9 in varchar2 default hr_api.g_varchar2
390: ,p_bpr_attribute10 in varchar2 default hr_api.g_varchar2
391: ,p_bpr_attribute11 in varchar2 default hr_api.g_varchar2

Line 388: ,p_bpr_attribute8 in varchar2 default hr_api.g_varchar2

384: ,p_bpr_attribute4 in varchar2 default hr_api.g_varchar2
385: ,p_bpr_attribute5 in varchar2 default hr_api.g_varchar2
386: ,p_bpr_attribute6 in varchar2 default hr_api.g_varchar2
387: ,p_bpr_attribute7 in varchar2 default hr_api.g_varchar2
388: ,p_bpr_attribute8 in varchar2 default hr_api.g_varchar2
389: ,p_bpr_attribute9 in varchar2 default hr_api.g_varchar2
390: ,p_bpr_attribute10 in varchar2 default hr_api.g_varchar2
391: ,p_bpr_attribute11 in varchar2 default hr_api.g_varchar2
392: ,p_bpr_attribute12 in varchar2 default hr_api.g_varchar2

Line 389: ,p_bpr_attribute9 in varchar2 default hr_api.g_varchar2

385: ,p_bpr_attribute5 in varchar2 default hr_api.g_varchar2
386: ,p_bpr_attribute6 in varchar2 default hr_api.g_varchar2
387: ,p_bpr_attribute7 in varchar2 default hr_api.g_varchar2
388: ,p_bpr_attribute8 in varchar2 default hr_api.g_varchar2
389: ,p_bpr_attribute9 in varchar2 default hr_api.g_varchar2
390: ,p_bpr_attribute10 in varchar2 default hr_api.g_varchar2
391: ,p_bpr_attribute11 in varchar2 default hr_api.g_varchar2
392: ,p_bpr_attribute12 in varchar2 default hr_api.g_varchar2
393: ,p_bpr_attribute13 in varchar2 default hr_api.g_varchar2

Line 390: ,p_bpr_attribute10 in varchar2 default hr_api.g_varchar2

386: ,p_bpr_attribute6 in varchar2 default hr_api.g_varchar2
387: ,p_bpr_attribute7 in varchar2 default hr_api.g_varchar2
388: ,p_bpr_attribute8 in varchar2 default hr_api.g_varchar2
389: ,p_bpr_attribute9 in varchar2 default hr_api.g_varchar2
390: ,p_bpr_attribute10 in varchar2 default hr_api.g_varchar2
391: ,p_bpr_attribute11 in varchar2 default hr_api.g_varchar2
392: ,p_bpr_attribute12 in varchar2 default hr_api.g_varchar2
393: ,p_bpr_attribute13 in varchar2 default hr_api.g_varchar2
394: ,p_bpr_attribute14 in varchar2 default hr_api.g_varchar2

Line 391: ,p_bpr_attribute11 in varchar2 default hr_api.g_varchar2

387: ,p_bpr_attribute7 in varchar2 default hr_api.g_varchar2
388: ,p_bpr_attribute8 in varchar2 default hr_api.g_varchar2
389: ,p_bpr_attribute9 in varchar2 default hr_api.g_varchar2
390: ,p_bpr_attribute10 in varchar2 default hr_api.g_varchar2
391: ,p_bpr_attribute11 in varchar2 default hr_api.g_varchar2
392: ,p_bpr_attribute12 in varchar2 default hr_api.g_varchar2
393: ,p_bpr_attribute13 in varchar2 default hr_api.g_varchar2
394: ,p_bpr_attribute14 in varchar2 default hr_api.g_varchar2
395: ,p_bpr_attribute15 in varchar2 default hr_api.g_varchar2

Line 392: ,p_bpr_attribute12 in varchar2 default hr_api.g_varchar2

388: ,p_bpr_attribute8 in varchar2 default hr_api.g_varchar2
389: ,p_bpr_attribute9 in varchar2 default hr_api.g_varchar2
390: ,p_bpr_attribute10 in varchar2 default hr_api.g_varchar2
391: ,p_bpr_attribute11 in varchar2 default hr_api.g_varchar2
392: ,p_bpr_attribute12 in varchar2 default hr_api.g_varchar2
393: ,p_bpr_attribute13 in varchar2 default hr_api.g_varchar2
394: ,p_bpr_attribute14 in varchar2 default hr_api.g_varchar2
395: ,p_bpr_attribute15 in varchar2 default hr_api.g_varchar2
396: ,p_bpr_attribute16 in varchar2 default hr_api.g_varchar2

Line 393: ,p_bpr_attribute13 in varchar2 default hr_api.g_varchar2

389: ,p_bpr_attribute9 in varchar2 default hr_api.g_varchar2
390: ,p_bpr_attribute10 in varchar2 default hr_api.g_varchar2
391: ,p_bpr_attribute11 in varchar2 default hr_api.g_varchar2
392: ,p_bpr_attribute12 in varchar2 default hr_api.g_varchar2
393: ,p_bpr_attribute13 in varchar2 default hr_api.g_varchar2
394: ,p_bpr_attribute14 in varchar2 default hr_api.g_varchar2
395: ,p_bpr_attribute15 in varchar2 default hr_api.g_varchar2
396: ,p_bpr_attribute16 in varchar2 default hr_api.g_varchar2
397: ,p_bpr_attribute17 in varchar2 default hr_api.g_varchar2

Line 394: ,p_bpr_attribute14 in varchar2 default hr_api.g_varchar2

390: ,p_bpr_attribute10 in varchar2 default hr_api.g_varchar2
391: ,p_bpr_attribute11 in varchar2 default hr_api.g_varchar2
392: ,p_bpr_attribute12 in varchar2 default hr_api.g_varchar2
393: ,p_bpr_attribute13 in varchar2 default hr_api.g_varchar2
394: ,p_bpr_attribute14 in varchar2 default hr_api.g_varchar2
395: ,p_bpr_attribute15 in varchar2 default hr_api.g_varchar2
396: ,p_bpr_attribute16 in varchar2 default hr_api.g_varchar2
397: ,p_bpr_attribute17 in varchar2 default hr_api.g_varchar2
398: ,p_bpr_attribute18 in varchar2 default hr_api.g_varchar2

Line 395: ,p_bpr_attribute15 in varchar2 default hr_api.g_varchar2

391: ,p_bpr_attribute11 in varchar2 default hr_api.g_varchar2
392: ,p_bpr_attribute12 in varchar2 default hr_api.g_varchar2
393: ,p_bpr_attribute13 in varchar2 default hr_api.g_varchar2
394: ,p_bpr_attribute14 in varchar2 default hr_api.g_varchar2
395: ,p_bpr_attribute15 in varchar2 default hr_api.g_varchar2
396: ,p_bpr_attribute16 in varchar2 default hr_api.g_varchar2
397: ,p_bpr_attribute17 in varchar2 default hr_api.g_varchar2
398: ,p_bpr_attribute18 in varchar2 default hr_api.g_varchar2
399: ,p_bpr_attribute19 in varchar2 default hr_api.g_varchar2

Line 396: ,p_bpr_attribute16 in varchar2 default hr_api.g_varchar2

392: ,p_bpr_attribute12 in varchar2 default hr_api.g_varchar2
393: ,p_bpr_attribute13 in varchar2 default hr_api.g_varchar2
394: ,p_bpr_attribute14 in varchar2 default hr_api.g_varchar2
395: ,p_bpr_attribute15 in varchar2 default hr_api.g_varchar2
396: ,p_bpr_attribute16 in varchar2 default hr_api.g_varchar2
397: ,p_bpr_attribute17 in varchar2 default hr_api.g_varchar2
398: ,p_bpr_attribute18 in varchar2 default hr_api.g_varchar2
399: ,p_bpr_attribute19 in varchar2 default hr_api.g_varchar2
400: ,p_bpr_attribute20 in varchar2 default hr_api.g_varchar2

Line 397: ,p_bpr_attribute17 in varchar2 default hr_api.g_varchar2

393: ,p_bpr_attribute13 in varchar2 default hr_api.g_varchar2
394: ,p_bpr_attribute14 in varchar2 default hr_api.g_varchar2
395: ,p_bpr_attribute15 in varchar2 default hr_api.g_varchar2
396: ,p_bpr_attribute16 in varchar2 default hr_api.g_varchar2
397: ,p_bpr_attribute17 in varchar2 default hr_api.g_varchar2
398: ,p_bpr_attribute18 in varchar2 default hr_api.g_varchar2
399: ,p_bpr_attribute19 in varchar2 default hr_api.g_varchar2
400: ,p_bpr_attribute20 in varchar2 default hr_api.g_varchar2
401: ,p_bpr_attribute21 in varchar2 default hr_api.g_varchar2

Line 398: ,p_bpr_attribute18 in varchar2 default hr_api.g_varchar2

394: ,p_bpr_attribute14 in varchar2 default hr_api.g_varchar2
395: ,p_bpr_attribute15 in varchar2 default hr_api.g_varchar2
396: ,p_bpr_attribute16 in varchar2 default hr_api.g_varchar2
397: ,p_bpr_attribute17 in varchar2 default hr_api.g_varchar2
398: ,p_bpr_attribute18 in varchar2 default hr_api.g_varchar2
399: ,p_bpr_attribute19 in varchar2 default hr_api.g_varchar2
400: ,p_bpr_attribute20 in varchar2 default hr_api.g_varchar2
401: ,p_bpr_attribute21 in varchar2 default hr_api.g_varchar2
402: ,p_bpr_attribute22 in varchar2 default hr_api.g_varchar2

Line 399: ,p_bpr_attribute19 in varchar2 default hr_api.g_varchar2

395: ,p_bpr_attribute15 in varchar2 default hr_api.g_varchar2
396: ,p_bpr_attribute16 in varchar2 default hr_api.g_varchar2
397: ,p_bpr_attribute17 in varchar2 default hr_api.g_varchar2
398: ,p_bpr_attribute18 in varchar2 default hr_api.g_varchar2
399: ,p_bpr_attribute19 in varchar2 default hr_api.g_varchar2
400: ,p_bpr_attribute20 in varchar2 default hr_api.g_varchar2
401: ,p_bpr_attribute21 in varchar2 default hr_api.g_varchar2
402: ,p_bpr_attribute22 in varchar2 default hr_api.g_varchar2
403: ,p_bpr_attribute23 in varchar2 default hr_api.g_varchar2

Line 400: ,p_bpr_attribute20 in varchar2 default hr_api.g_varchar2

396: ,p_bpr_attribute16 in varchar2 default hr_api.g_varchar2
397: ,p_bpr_attribute17 in varchar2 default hr_api.g_varchar2
398: ,p_bpr_attribute18 in varchar2 default hr_api.g_varchar2
399: ,p_bpr_attribute19 in varchar2 default hr_api.g_varchar2
400: ,p_bpr_attribute20 in varchar2 default hr_api.g_varchar2
401: ,p_bpr_attribute21 in varchar2 default hr_api.g_varchar2
402: ,p_bpr_attribute22 in varchar2 default hr_api.g_varchar2
403: ,p_bpr_attribute23 in varchar2 default hr_api.g_varchar2
404: ,p_bpr_attribute24 in varchar2 default hr_api.g_varchar2

Line 401: ,p_bpr_attribute21 in varchar2 default hr_api.g_varchar2

397: ,p_bpr_attribute17 in varchar2 default hr_api.g_varchar2
398: ,p_bpr_attribute18 in varchar2 default hr_api.g_varchar2
399: ,p_bpr_attribute19 in varchar2 default hr_api.g_varchar2
400: ,p_bpr_attribute20 in varchar2 default hr_api.g_varchar2
401: ,p_bpr_attribute21 in varchar2 default hr_api.g_varchar2
402: ,p_bpr_attribute22 in varchar2 default hr_api.g_varchar2
403: ,p_bpr_attribute23 in varchar2 default hr_api.g_varchar2
404: ,p_bpr_attribute24 in varchar2 default hr_api.g_varchar2
405: ,p_bpr_attribute25 in varchar2 default hr_api.g_varchar2

Line 402: ,p_bpr_attribute22 in varchar2 default hr_api.g_varchar2

398: ,p_bpr_attribute18 in varchar2 default hr_api.g_varchar2
399: ,p_bpr_attribute19 in varchar2 default hr_api.g_varchar2
400: ,p_bpr_attribute20 in varchar2 default hr_api.g_varchar2
401: ,p_bpr_attribute21 in varchar2 default hr_api.g_varchar2
402: ,p_bpr_attribute22 in varchar2 default hr_api.g_varchar2
403: ,p_bpr_attribute23 in varchar2 default hr_api.g_varchar2
404: ,p_bpr_attribute24 in varchar2 default hr_api.g_varchar2
405: ,p_bpr_attribute25 in varchar2 default hr_api.g_varchar2
406: ,p_bpr_attribute26 in varchar2 default hr_api.g_varchar2

Line 403: ,p_bpr_attribute23 in varchar2 default hr_api.g_varchar2

399: ,p_bpr_attribute19 in varchar2 default hr_api.g_varchar2
400: ,p_bpr_attribute20 in varchar2 default hr_api.g_varchar2
401: ,p_bpr_attribute21 in varchar2 default hr_api.g_varchar2
402: ,p_bpr_attribute22 in varchar2 default hr_api.g_varchar2
403: ,p_bpr_attribute23 in varchar2 default hr_api.g_varchar2
404: ,p_bpr_attribute24 in varchar2 default hr_api.g_varchar2
405: ,p_bpr_attribute25 in varchar2 default hr_api.g_varchar2
406: ,p_bpr_attribute26 in varchar2 default hr_api.g_varchar2
407: ,p_bpr_attribute27 in varchar2 default hr_api.g_varchar2

Line 404: ,p_bpr_attribute24 in varchar2 default hr_api.g_varchar2

400: ,p_bpr_attribute20 in varchar2 default hr_api.g_varchar2
401: ,p_bpr_attribute21 in varchar2 default hr_api.g_varchar2
402: ,p_bpr_attribute22 in varchar2 default hr_api.g_varchar2
403: ,p_bpr_attribute23 in varchar2 default hr_api.g_varchar2
404: ,p_bpr_attribute24 in varchar2 default hr_api.g_varchar2
405: ,p_bpr_attribute25 in varchar2 default hr_api.g_varchar2
406: ,p_bpr_attribute26 in varchar2 default hr_api.g_varchar2
407: ,p_bpr_attribute27 in varchar2 default hr_api.g_varchar2
408: ,p_bpr_attribute28 in varchar2 default hr_api.g_varchar2

Line 405: ,p_bpr_attribute25 in varchar2 default hr_api.g_varchar2

401: ,p_bpr_attribute21 in varchar2 default hr_api.g_varchar2
402: ,p_bpr_attribute22 in varchar2 default hr_api.g_varchar2
403: ,p_bpr_attribute23 in varchar2 default hr_api.g_varchar2
404: ,p_bpr_attribute24 in varchar2 default hr_api.g_varchar2
405: ,p_bpr_attribute25 in varchar2 default hr_api.g_varchar2
406: ,p_bpr_attribute26 in varchar2 default hr_api.g_varchar2
407: ,p_bpr_attribute27 in varchar2 default hr_api.g_varchar2
408: ,p_bpr_attribute28 in varchar2 default hr_api.g_varchar2
409: ,p_bpr_attribute29 in varchar2 default hr_api.g_varchar2

Line 406: ,p_bpr_attribute26 in varchar2 default hr_api.g_varchar2

402: ,p_bpr_attribute22 in varchar2 default hr_api.g_varchar2
403: ,p_bpr_attribute23 in varchar2 default hr_api.g_varchar2
404: ,p_bpr_attribute24 in varchar2 default hr_api.g_varchar2
405: ,p_bpr_attribute25 in varchar2 default hr_api.g_varchar2
406: ,p_bpr_attribute26 in varchar2 default hr_api.g_varchar2
407: ,p_bpr_attribute27 in varchar2 default hr_api.g_varchar2
408: ,p_bpr_attribute28 in varchar2 default hr_api.g_varchar2
409: ,p_bpr_attribute29 in varchar2 default hr_api.g_varchar2
410: ,p_bpr_attribute30 in varchar2 default hr_api.g_varchar2

Line 407: ,p_bpr_attribute27 in varchar2 default hr_api.g_varchar2

403: ,p_bpr_attribute23 in varchar2 default hr_api.g_varchar2
404: ,p_bpr_attribute24 in varchar2 default hr_api.g_varchar2
405: ,p_bpr_attribute25 in varchar2 default hr_api.g_varchar2
406: ,p_bpr_attribute26 in varchar2 default hr_api.g_varchar2
407: ,p_bpr_attribute27 in varchar2 default hr_api.g_varchar2
408: ,p_bpr_attribute28 in varchar2 default hr_api.g_varchar2
409: ,p_bpr_attribute29 in varchar2 default hr_api.g_varchar2
410: ,p_bpr_attribute30 in varchar2 default hr_api.g_varchar2
411: ,p_object_version_number in out nocopy number

Line 408: ,p_bpr_attribute28 in varchar2 default hr_api.g_varchar2

404: ,p_bpr_attribute24 in varchar2 default hr_api.g_varchar2
405: ,p_bpr_attribute25 in varchar2 default hr_api.g_varchar2
406: ,p_bpr_attribute26 in varchar2 default hr_api.g_varchar2
407: ,p_bpr_attribute27 in varchar2 default hr_api.g_varchar2
408: ,p_bpr_attribute28 in varchar2 default hr_api.g_varchar2
409: ,p_bpr_attribute29 in varchar2 default hr_api.g_varchar2
410: ,p_bpr_attribute30 in varchar2 default hr_api.g_varchar2
411: ,p_object_version_number in out nocopy number
412: ,p_effective_date in date

Line 409: ,p_bpr_attribute29 in varchar2 default hr_api.g_varchar2

405: ,p_bpr_attribute25 in varchar2 default hr_api.g_varchar2
406: ,p_bpr_attribute26 in varchar2 default hr_api.g_varchar2
407: ,p_bpr_attribute27 in varchar2 default hr_api.g_varchar2
408: ,p_bpr_attribute28 in varchar2 default hr_api.g_varchar2
409: ,p_bpr_attribute29 in varchar2 default hr_api.g_varchar2
410: ,p_bpr_attribute30 in varchar2 default hr_api.g_varchar2
411: ,p_object_version_number in out nocopy number
412: ,p_effective_date in date
413: ,p_datetrack_mode in varchar2

Line 410: ,p_bpr_attribute30 in varchar2 default hr_api.g_varchar2

406: ,p_bpr_attribute26 in varchar2 default hr_api.g_varchar2
407: ,p_bpr_attribute27 in varchar2 default hr_api.g_varchar2
408: ,p_bpr_attribute28 in varchar2 default hr_api.g_varchar2
409: ,p_bpr_attribute29 in varchar2 default hr_api.g_varchar2
410: ,p_bpr_attribute30 in varchar2 default hr_api.g_varchar2
411: ,p_object_version_number in out nocopy number
412: ,p_effective_date in date
413: ,p_datetrack_mode in varchar2
414: ) is

Line 502: when hr_api.cannot_find_prog_unit then

498: ,p_effective_date => trunc(p_effective_date)
499: ,p_datetrack_mode => p_datetrack_mode
500: );
501: exception
502: when hr_api.cannot_find_prog_unit then
503: hr_api.cannot_find_prog_unit_error
504: (p_module_name => 'UPDATE_Bnft_Pool_Rlovr_Rqmt'
505: ,p_hook_type => 'BP'
506: );

Line 503: hr_api.cannot_find_prog_unit_error

499: ,p_datetrack_mode => p_datetrack_mode
500: );
501: exception
502: when hr_api.cannot_find_prog_unit then
503: hr_api.cannot_find_prog_unit_error
504: (p_module_name => 'UPDATE_Bnft_Pool_Rlovr_Rqmt'
505: ,p_hook_type => 'BP'
506: );
507: --

Line 642: when hr_api.cannot_find_prog_unit then

638: ,p_effective_date => trunc(p_effective_date)
639: ,p_datetrack_mode => p_datetrack_mode
640: );
641: exception
642: when hr_api.cannot_find_prog_unit then
643: hr_api.cannot_find_prog_unit_error
644: (p_module_name => 'UPDATE_Bnft_Pool_Rlovr_Rqmt'
645: ,p_hook_type => 'AP'
646: );

Line 643: hr_api.cannot_find_prog_unit_error

639: ,p_datetrack_mode => p_datetrack_mode
640: );
641: exception
642: when hr_api.cannot_find_prog_unit then
643: hr_api.cannot_find_prog_unit_error
644: (p_module_name => 'UPDATE_Bnft_Pool_Rlovr_Rqmt'
645: ,p_hook_type => 'AP'
646: );
647: --

Line 657: raise hr_api.validate_enabled;

653: --
654: -- When in validation only mode raise the Validate_Enabled exception
655: --
656: if p_validate then
657: raise hr_api.validate_enabled;
658: end if;
659: --
660: -- Set all output arguments
661: --

Line 670: when hr_api.validate_enabled then

666: hr_utility.set_location(' Leaving:'||l_proc, 70);
667: --
668: exception
669: --
670: when hr_api.validate_enabled then
671: --
672: -- As the Validate_Enabled exception has been raised
673: -- we must rollback to the savepoint
674: --

Line 739: when hr_api.cannot_find_prog_unit then

735: ,p_effective_date => trunc(p_effective_date)
736: ,p_datetrack_mode => p_datetrack_mode
737: );
738: exception
739: when hr_api.cannot_find_prog_unit then
740: hr_api.cannot_find_prog_unit_error
741: (p_module_name => 'DELETE_Bnft_Pool_Rlovr_Rqmt'
742: ,p_hook_type => 'BP'
743: );

Line 740: hr_api.cannot_find_prog_unit_error

736: ,p_datetrack_mode => p_datetrack_mode
737: );
738: exception
739: when hr_api.cannot_find_prog_unit then
740: hr_api.cannot_find_prog_unit_error
741: (p_module_name => 'DELETE_Bnft_Pool_Rlovr_Rqmt'
742: ,p_hook_type => 'BP'
743: );
744: --

Line 773: when hr_api.cannot_find_prog_unit then

769: ,p_effective_date => trunc(p_effective_date)
770: ,p_datetrack_mode => p_datetrack_mode
771: );
772: exception
773: when hr_api.cannot_find_prog_unit then
774: hr_api.cannot_find_prog_unit_error
775: (p_module_name => 'DELETE_Bnft_Pool_Rlovr_Rqmt'
776: ,p_hook_type => 'AP'
777: );

Line 774: hr_api.cannot_find_prog_unit_error

770: ,p_datetrack_mode => p_datetrack_mode
771: );
772: exception
773: when hr_api.cannot_find_prog_unit then
774: hr_api.cannot_find_prog_unit_error
775: (p_module_name => 'DELETE_Bnft_Pool_Rlovr_Rqmt'
776: ,p_hook_type => 'AP'
777: );
778: --

Line 788: raise hr_api.validate_enabled;

784: --
785: -- When in validation only mode raise the Validate_Enabled exception
786: --
787: if p_validate then
788: raise hr_api.validate_enabled;
789: end if;
790: --
791: hr_utility.set_location(' Leaving:'||l_proc, 70);
792: --

Line 795: when hr_api.validate_enabled then

791: hr_utility.set_location(' Leaving:'||l_proc, 70);
792: --
793: exception
794: --
795: when hr_api.validate_enabled then
796: --
797: -- As the Validate_Enabled exception has been raised
798: -- we must rollback to the savepoint
799: --