176: ,p_bpp_attribute30 => p_bpp_attribute30
177: ,p_effective_date => trunc(p_effective_date)
178: );
179: exception
180: when hr_api.cannot_find_prog_unit then
181: hr_api.cannot_find_prog_unit_error
182: (
183: p_module_name => 'CREATE_Benefit_Prvdr_Pool'
184: ,p_hook_type => 'BP'
177: ,p_effective_date => trunc(p_effective_date)
178: );
179: exception
180: when hr_api.cannot_find_prog_unit then
181: hr_api.cannot_find_prog_unit_error
182: (
183: p_module_name => 'CREATE_Benefit_Prvdr_Pool'
184: ,p_hook_type => 'BP'
185: );
339: ,p_object_version_number => l_object_version_number
340: ,p_effective_date => trunc(p_effective_date)
341: );
342: exception
343: when hr_api.cannot_find_prog_unit then
344: hr_api.cannot_find_prog_unit_error
345: (p_module_name => 'CREATE_Benefit_Prvdr_Pool'
346: ,p_hook_type => 'AP'
347: );
340: ,p_effective_date => trunc(p_effective_date)
341: );
342: exception
343: when hr_api.cannot_find_prog_unit then
344: hr_api.cannot_find_prog_unit_error
345: (p_module_name => 'CREATE_Benefit_Prvdr_Pool'
346: ,p_hook_type => 'AP'
347: );
348: --
354: --
355: -- When in validation only mode raise the Validate_Enabled exception
356: --
357: if p_validate then
358: raise hr_api.validate_enabled;
359: end if;
360: --
361: -- Set all output arguments
362: --
368: hr_utility.set_location(' Leaving:'||l_proc, 70);
369: --
370: exception
371: --
372: when hr_api.validate_enabled then
373: --
374: -- As the Validate_Enabled exception has been raised
375: -- we must rollback to the savepoint
376: --
402: (p_validate in boolean default false
403: ,p_bnft_prvdr_pool_id in number
404: ,p_effective_start_date out nocopy date
405: ,p_effective_end_date out nocopy date
406: ,p_name in varchar2 default hr_api.g_varchar2
407: ,p_pgm_pool_flag in varchar2 default hr_api.g_varchar2
408: ,p_excs_alwys_fftd_flag in varchar2 default hr_api.g_varchar2
409: ,p_use_for_pgm_pool_flag in varchar2 default hr_api.g_varchar2
410: ,p_pct_rndg_cd in varchar2 default hr_api.g_varchar2
403: ,p_bnft_prvdr_pool_id in number
404: ,p_effective_start_date out nocopy date
405: ,p_effective_end_date out nocopy date
406: ,p_name in varchar2 default hr_api.g_varchar2
407: ,p_pgm_pool_flag in varchar2 default hr_api.g_varchar2
408: ,p_excs_alwys_fftd_flag in varchar2 default hr_api.g_varchar2
409: ,p_use_for_pgm_pool_flag in varchar2 default hr_api.g_varchar2
410: ,p_pct_rndg_cd in varchar2 default hr_api.g_varchar2
411: ,p_pct_rndg_rl in number default hr_api.g_number
404: ,p_effective_start_date out nocopy date
405: ,p_effective_end_date out nocopy date
406: ,p_name in varchar2 default hr_api.g_varchar2
407: ,p_pgm_pool_flag in varchar2 default hr_api.g_varchar2
408: ,p_excs_alwys_fftd_flag in varchar2 default hr_api.g_varchar2
409: ,p_use_for_pgm_pool_flag in varchar2 default hr_api.g_varchar2
410: ,p_pct_rndg_cd in varchar2 default hr_api.g_varchar2
411: ,p_pct_rndg_rl in number default hr_api.g_number
412: ,p_val_rndg_cd in varchar2 default hr_api.g_varchar2
405: ,p_effective_end_date out nocopy date
406: ,p_name in varchar2 default hr_api.g_varchar2
407: ,p_pgm_pool_flag in varchar2 default hr_api.g_varchar2
408: ,p_excs_alwys_fftd_flag in varchar2 default hr_api.g_varchar2
409: ,p_use_for_pgm_pool_flag in varchar2 default hr_api.g_varchar2
410: ,p_pct_rndg_cd in varchar2 default hr_api.g_varchar2
411: ,p_pct_rndg_rl in number default hr_api.g_number
412: ,p_val_rndg_cd in varchar2 default hr_api.g_varchar2
413: ,p_val_rndg_rl in number default hr_api.g_number
406: ,p_name in varchar2 default hr_api.g_varchar2
407: ,p_pgm_pool_flag in varchar2 default hr_api.g_varchar2
408: ,p_excs_alwys_fftd_flag in varchar2 default hr_api.g_varchar2
409: ,p_use_for_pgm_pool_flag in varchar2 default hr_api.g_varchar2
410: ,p_pct_rndg_cd in varchar2 default hr_api.g_varchar2
411: ,p_pct_rndg_rl in number default hr_api.g_number
412: ,p_val_rndg_cd in varchar2 default hr_api.g_varchar2
413: ,p_val_rndg_rl in number default hr_api.g_number
414: ,p_dflt_excs_trtmt_cd in varchar2 default hr_api.g_varchar2
407: ,p_pgm_pool_flag in varchar2 default hr_api.g_varchar2
408: ,p_excs_alwys_fftd_flag in varchar2 default hr_api.g_varchar2
409: ,p_use_for_pgm_pool_flag in varchar2 default hr_api.g_varchar2
410: ,p_pct_rndg_cd in varchar2 default hr_api.g_varchar2
411: ,p_pct_rndg_rl in number default hr_api.g_number
412: ,p_val_rndg_cd in varchar2 default hr_api.g_varchar2
413: ,p_val_rndg_rl in number default hr_api.g_number
414: ,p_dflt_excs_trtmt_cd in varchar2 default hr_api.g_varchar2
415: ,p_dflt_excs_trtmt_rl in number default hr_api.g_number
408: ,p_excs_alwys_fftd_flag in varchar2 default hr_api.g_varchar2
409: ,p_use_for_pgm_pool_flag in varchar2 default hr_api.g_varchar2
410: ,p_pct_rndg_cd in varchar2 default hr_api.g_varchar2
411: ,p_pct_rndg_rl in number default hr_api.g_number
412: ,p_val_rndg_cd in varchar2 default hr_api.g_varchar2
413: ,p_val_rndg_rl in number default hr_api.g_number
414: ,p_dflt_excs_trtmt_cd in varchar2 default hr_api.g_varchar2
415: ,p_dflt_excs_trtmt_rl in number default hr_api.g_number
416: ,p_rlovr_rstrcn_cd in varchar2 default hr_api.g_varchar2
409: ,p_use_for_pgm_pool_flag in varchar2 default hr_api.g_varchar2
410: ,p_pct_rndg_cd in varchar2 default hr_api.g_varchar2
411: ,p_pct_rndg_rl in number default hr_api.g_number
412: ,p_val_rndg_cd in varchar2 default hr_api.g_varchar2
413: ,p_val_rndg_rl in number default hr_api.g_number
414: ,p_dflt_excs_trtmt_cd in varchar2 default hr_api.g_varchar2
415: ,p_dflt_excs_trtmt_rl in number default hr_api.g_number
416: ,p_rlovr_rstrcn_cd in varchar2 default hr_api.g_varchar2
417: ,p_no_mn_dstrbl_pct_flag in varchar2 default hr_api.g_varchar2
410: ,p_pct_rndg_cd in varchar2 default hr_api.g_varchar2
411: ,p_pct_rndg_rl in number default hr_api.g_number
412: ,p_val_rndg_cd in varchar2 default hr_api.g_varchar2
413: ,p_val_rndg_rl in number default hr_api.g_number
414: ,p_dflt_excs_trtmt_cd in varchar2 default hr_api.g_varchar2
415: ,p_dflt_excs_trtmt_rl in number default hr_api.g_number
416: ,p_rlovr_rstrcn_cd in varchar2 default hr_api.g_varchar2
417: ,p_no_mn_dstrbl_pct_flag in varchar2 default hr_api.g_varchar2
418: ,p_no_mn_dstrbl_val_flag in varchar2 default hr_api.g_varchar2
411: ,p_pct_rndg_rl in number default hr_api.g_number
412: ,p_val_rndg_cd in varchar2 default hr_api.g_varchar2
413: ,p_val_rndg_rl in number default hr_api.g_number
414: ,p_dflt_excs_trtmt_cd in varchar2 default hr_api.g_varchar2
415: ,p_dflt_excs_trtmt_rl in number default hr_api.g_number
416: ,p_rlovr_rstrcn_cd in varchar2 default hr_api.g_varchar2
417: ,p_no_mn_dstrbl_pct_flag in varchar2 default hr_api.g_varchar2
418: ,p_no_mn_dstrbl_val_flag in varchar2 default hr_api.g_varchar2
419: ,p_no_mx_dstrbl_pct_flag in varchar2 default hr_api.g_varchar2
412: ,p_val_rndg_cd in varchar2 default hr_api.g_varchar2
413: ,p_val_rndg_rl in number default hr_api.g_number
414: ,p_dflt_excs_trtmt_cd in varchar2 default hr_api.g_varchar2
415: ,p_dflt_excs_trtmt_rl in number default hr_api.g_number
416: ,p_rlovr_rstrcn_cd in varchar2 default hr_api.g_varchar2
417: ,p_no_mn_dstrbl_pct_flag in varchar2 default hr_api.g_varchar2
418: ,p_no_mn_dstrbl_val_flag in varchar2 default hr_api.g_varchar2
419: ,p_no_mx_dstrbl_pct_flag in varchar2 default hr_api.g_varchar2
420: ,p_no_mx_dstrbl_val_flag in varchar2 default hr_api.g_varchar2
413: ,p_val_rndg_rl in number default hr_api.g_number
414: ,p_dflt_excs_trtmt_cd in varchar2 default hr_api.g_varchar2
415: ,p_dflt_excs_trtmt_rl in number default hr_api.g_number
416: ,p_rlovr_rstrcn_cd in varchar2 default hr_api.g_varchar2
417: ,p_no_mn_dstrbl_pct_flag in varchar2 default hr_api.g_varchar2
418: ,p_no_mn_dstrbl_val_flag in varchar2 default hr_api.g_varchar2
419: ,p_no_mx_dstrbl_pct_flag in varchar2 default hr_api.g_varchar2
420: ,p_no_mx_dstrbl_val_flag in varchar2 default hr_api.g_varchar2
421: ,p_auto_alct_excs_flag in varchar2 default hr_api.g_varchar2
414: ,p_dflt_excs_trtmt_cd in varchar2 default hr_api.g_varchar2
415: ,p_dflt_excs_trtmt_rl in number default hr_api.g_number
416: ,p_rlovr_rstrcn_cd in varchar2 default hr_api.g_varchar2
417: ,p_no_mn_dstrbl_pct_flag in varchar2 default hr_api.g_varchar2
418: ,p_no_mn_dstrbl_val_flag in varchar2 default hr_api.g_varchar2
419: ,p_no_mx_dstrbl_pct_flag in varchar2 default hr_api.g_varchar2
420: ,p_no_mx_dstrbl_val_flag in varchar2 default hr_api.g_varchar2
421: ,p_auto_alct_excs_flag in varchar2 default hr_api.g_varchar2
422: ,p_alws_ngtv_crs_flag in varchar2 default hr_api.g_varchar2
415: ,p_dflt_excs_trtmt_rl in number default hr_api.g_number
416: ,p_rlovr_rstrcn_cd in varchar2 default hr_api.g_varchar2
417: ,p_no_mn_dstrbl_pct_flag in varchar2 default hr_api.g_varchar2
418: ,p_no_mn_dstrbl_val_flag in varchar2 default hr_api.g_varchar2
419: ,p_no_mx_dstrbl_pct_flag in varchar2 default hr_api.g_varchar2
420: ,p_no_mx_dstrbl_val_flag in varchar2 default hr_api.g_varchar2
421: ,p_auto_alct_excs_flag in varchar2 default hr_api.g_varchar2
422: ,p_alws_ngtv_crs_flag in varchar2 default hr_api.g_varchar2
423: ,p_uses_net_crs_mthd_flag in varchar2 default hr_api.g_varchar2
416: ,p_rlovr_rstrcn_cd in varchar2 default hr_api.g_varchar2
417: ,p_no_mn_dstrbl_pct_flag in varchar2 default hr_api.g_varchar2
418: ,p_no_mn_dstrbl_val_flag in varchar2 default hr_api.g_varchar2
419: ,p_no_mx_dstrbl_pct_flag in varchar2 default hr_api.g_varchar2
420: ,p_no_mx_dstrbl_val_flag in varchar2 default hr_api.g_varchar2
421: ,p_auto_alct_excs_flag in varchar2 default hr_api.g_varchar2
422: ,p_alws_ngtv_crs_flag in varchar2 default hr_api.g_varchar2
423: ,p_uses_net_crs_mthd_flag in varchar2 default hr_api.g_varchar2
424: ,p_mx_dfcit_pct_pool_crs_num in number default hr_api.g_number
417: ,p_no_mn_dstrbl_pct_flag in varchar2 default hr_api.g_varchar2
418: ,p_no_mn_dstrbl_val_flag in varchar2 default hr_api.g_varchar2
419: ,p_no_mx_dstrbl_pct_flag in varchar2 default hr_api.g_varchar2
420: ,p_no_mx_dstrbl_val_flag in varchar2 default hr_api.g_varchar2
421: ,p_auto_alct_excs_flag in varchar2 default hr_api.g_varchar2
422: ,p_alws_ngtv_crs_flag in varchar2 default hr_api.g_varchar2
423: ,p_uses_net_crs_mthd_flag in varchar2 default hr_api.g_varchar2
424: ,p_mx_dfcit_pct_pool_crs_num in number default hr_api.g_number
425: ,p_mx_dfcit_pct_comp_num in number default hr_api.g_number
418: ,p_no_mn_dstrbl_val_flag in varchar2 default hr_api.g_varchar2
419: ,p_no_mx_dstrbl_pct_flag in varchar2 default hr_api.g_varchar2
420: ,p_no_mx_dstrbl_val_flag in varchar2 default hr_api.g_varchar2
421: ,p_auto_alct_excs_flag in varchar2 default hr_api.g_varchar2
422: ,p_alws_ngtv_crs_flag in varchar2 default hr_api.g_varchar2
423: ,p_uses_net_crs_mthd_flag in varchar2 default hr_api.g_varchar2
424: ,p_mx_dfcit_pct_pool_crs_num in number default hr_api.g_number
425: ,p_mx_dfcit_pct_comp_num in number default hr_api.g_number
426: ,p_comp_lvl_fctr_id in number default hr_api.g_number
419: ,p_no_mx_dstrbl_pct_flag in varchar2 default hr_api.g_varchar2
420: ,p_no_mx_dstrbl_val_flag in varchar2 default hr_api.g_varchar2
421: ,p_auto_alct_excs_flag in varchar2 default hr_api.g_varchar2
422: ,p_alws_ngtv_crs_flag in varchar2 default hr_api.g_varchar2
423: ,p_uses_net_crs_mthd_flag in varchar2 default hr_api.g_varchar2
424: ,p_mx_dfcit_pct_pool_crs_num in number default hr_api.g_number
425: ,p_mx_dfcit_pct_comp_num in number default hr_api.g_number
426: ,p_comp_lvl_fctr_id in number default hr_api.g_number
427: ,p_mn_dstrbl_pct_num in number default hr_api.g_number
420: ,p_no_mx_dstrbl_val_flag in varchar2 default hr_api.g_varchar2
421: ,p_auto_alct_excs_flag in varchar2 default hr_api.g_varchar2
422: ,p_alws_ngtv_crs_flag in varchar2 default hr_api.g_varchar2
423: ,p_uses_net_crs_mthd_flag in varchar2 default hr_api.g_varchar2
424: ,p_mx_dfcit_pct_pool_crs_num in number default hr_api.g_number
425: ,p_mx_dfcit_pct_comp_num in number default hr_api.g_number
426: ,p_comp_lvl_fctr_id in number default hr_api.g_number
427: ,p_mn_dstrbl_pct_num in number default hr_api.g_number
428: ,p_mn_dstrbl_val in number default hr_api.g_number
421: ,p_auto_alct_excs_flag in varchar2 default hr_api.g_varchar2
422: ,p_alws_ngtv_crs_flag in varchar2 default hr_api.g_varchar2
423: ,p_uses_net_crs_mthd_flag in varchar2 default hr_api.g_varchar2
424: ,p_mx_dfcit_pct_pool_crs_num in number default hr_api.g_number
425: ,p_mx_dfcit_pct_comp_num in number default hr_api.g_number
426: ,p_comp_lvl_fctr_id in number default hr_api.g_number
427: ,p_mn_dstrbl_pct_num in number default hr_api.g_number
428: ,p_mn_dstrbl_val in number default hr_api.g_number
429: ,p_mx_dstrbl_pct_num in number default hr_api.g_number
422: ,p_alws_ngtv_crs_flag in varchar2 default hr_api.g_varchar2
423: ,p_uses_net_crs_mthd_flag in varchar2 default hr_api.g_varchar2
424: ,p_mx_dfcit_pct_pool_crs_num in number default hr_api.g_number
425: ,p_mx_dfcit_pct_comp_num in number default hr_api.g_number
426: ,p_comp_lvl_fctr_id in number default hr_api.g_number
427: ,p_mn_dstrbl_pct_num in number default hr_api.g_number
428: ,p_mn_dstrbl_val in number default hr_api.g_number
429: ,p_mx_dstrbl_pct_num in number default hr_api.g_number
430: ,p_mx_dstrbl_val in number default hr_api.g_number
423: ,p_uses_net_crs_mthd_flag in varchar2 default hr_api.g_varchar2
424: ,p_mx_dfcit_pct_pool_crs_num in number default hr_api.g_number
425: ,p_mx_dfcit_pct_comp_num in number default hr_api.g_number
426: ,p_comp_lvl_fctr_id in number default hr_api.g_number
427: ,p_mn_dstrbl_pct_num in number default hr_api.g_number
428: ,p_mn_dstrbl_val in number default hr_api.g_number
429: ,p_mx_dstrbl_pct_num in number default hr_api.g_number
430: ,p_mx_dstrbl_val in number default hr_api.g_number
431: ,p_excs_trtmt_cd in varchar2 default hr_api.g_varchar2
424: ,p_mx_dfcit_pct_pool_crs_num in number default hr_api.g_number
425: ,p_mx_dfcit_pct_comp_num in number default hr_api.g_number
426: ,p_comp_lvl_fctr_id in number default hr_api.g_number
427: ,p_mn_dstrbl_pct_num in number default hr_api.g_number
428: ,p_mn_dstrbl_val in number default hr_api.g_number
429: ,p_mx_dstrbl_pct_num in number default hr_api.g_number
430: ,p_mx_dstrbl_val in number default hr_api.g_number
431: ,p_excs_trtmt_cd in varchar2 default hr_api.g_varchar2
432: ,p_ptip_id in number default hr_api.g_number
425: ,p_mx_dfcit_pct_comp_num in number default hr_api.g_number
426: ,p_comp_lvl_fctr_id in number default hr_api.g_number
427: ,p_mn_dstrbl_pct_num in number default hr_api.g_number
428: ,p_mn_dstrbl_val in number default hr_api.g_number
429: ,p_mx_dstrbl_pct_num in number default hr_api.g_number
430: ,p_mx_dstrbl_val in number default hr_api.g_number
431: ,p_excs_trtmt_cd in varchar2 default hr_api.g_varchar2
432: ,p_ptip_id in number default hr_api.g_number
433: ,p_plip_id in number default hr_api.g_number
426: ,p_comp_lvl_fctr_id in number default hr_api.g_number
427: ,p_mn_dstrbl_pct_num in number default hr_api.g_number
428: ,p_mn_dstrbl_val in number default hr_api.g_number
429: ,p_mx_dstrbl_pct_num in number default hr_api.g_number
430: ,p_mx_dstrbl_val in number default hr_api.g_number
431: ,p_excs_trtmt_cd in varchar2 default hr_api.g_varchar2
432: ,p_ptip_id in number default hr_api.g_number
433: ,p_plip_id in number default hr_api.g_number
434: ,p_pgm_id in number default hr_api.g_number
427: ,p_mn_dstrbl_pct_num in number default hr_api.g_number
428: ,p_mn_dstrbl_val in number default hr_api.g_number
429: ,p_mx_dstrbl_pct_num in number default hr_api.g_number
430: ,p_mx_dstrbl_val in number default hr_api.g_number
431: ,p_excs_trtmt_cd in varchar2 default hr_api.g_varchar2
432: ,p_ptip_id in number default hr_api.g_number
433: ,p_plip_id in number default hr_api.g_number
434: ,p_pgm_id in number default hr_api.g_number
435: ,p_oiplip_id in number default hr_api.g_number
428: ,p_mn_dstrbl_val in number default hr_api.g_number
429: ,p_mx_dstrbl_pct_num in number default hr_api.g_number
430: ,p_mx_dstrbl_val in number default hr_api.g_number
431: ,p_excs_trtmt_cd in varchar2 default hr_api.g_varchar2
432: ,p_ptip_id in number default hr_api.g_number
433: ,p_plip_id in number default hr_api.g_number
434: ,p_pgm_id in number default hr_api.g_number
435: ,p_oiplip_id in number default hr_api.g_number
436: ,p_cmbn_plip_id in number default hr_api.g_number
429: ,p_mx_dstrbl_pct_num in number default hr_api.g_number
430: ,p_mx_dstrbl_val in number default hr_api.g_number
431: ,p_excs_trtmt_cd in varchar2 default hr_api.g_varchar2
432: ,p_ptip_id in number default hr_api.g_number
433: ,p_plip_id in number default hr_api.g_number
434: ,p_pgm_id in number default hr_api.g_number
435: ,p_oiplip_id in number default hr_api.g_number
436: ,p_cmbn_plip_id in number default hr_api.g_number
437: ,p_cmbn_ptip_id in number default hr_api.g_number
430: ,p_mx_dstrbl_val in number default hr_api.g_number
431: ,p_excs_trtmt_cd in varchar2 default hr_api.g_varchar2
432: ,p_ptip_id in number default hr_api.g_number
433: ,p_plip_id in number default hr_api.g_number
434: ,p_pgm_id in number default hr_api.g_number
435: ,p_oiplip_id in number default hr_api.g_number
436: ,p_cmbn_plip_id in number default hr_api.g_number
437: ,p_cmbn_ptip_id in number default hr_api.g_number
438: ,p_cmbn_ptip_opt_id in number default hr_api.g_number
431: ,p_excs_trtmt_cd in varchar2 default hr_api.g_varchar2
432: ,p_ptip_id in number default hr_api.g_number
433: ,p_plip_id in number default hr_api.g_number
434: ,p_pgm_id in number default hr_api.g_number
435: ,p_oiplip_id in number default hr_api.g_number
436: ,p_cmbn_plip_id in number default hr_api.g_number
437: ,p_cmbn_ptip_id in number default hr_api.g_number
438: ,p_cmbn_ptip_opt_id in number default hr_api.g_number
439: ,p_business_group_id in number default hr_api.g_number
432: ,p_ptip_id in number default hr_api.g_number
433: ,p_plip_id in number default hr_api.g_number
434: ,p_pgm_id in number default hr_api.g_number
435: ,p_oiplip_id in number default hr_api.g_number
436: ,p_cmbn_plip_id in number default hr_api.g_number
437: ,p_cmbn_ptip_id in number default hr_api.g_number
438: ,p_cmbn_ptip_opt_id in number default hr_api.g_number
439: ,p_business_group_id in number default hr_api.g_number
440: ,p_bpp_attribute_category in varchar2 default hr_api.g_varchar2
433: ,p_plip_id in number default hr_api.g_number
434: ,p_pgm_id in number default hr_api.g_number
435: ,p_oiplip_id in number default hr_api.g_number
436: ,p_cmbn_plip_id in number default hr_api.g_number
437: ,p_cmbn_ptip_id in number default hr_api.g_number
438: ,p_cmbn_ptip_opt_id in number default hr_api.g_number
439: ,p_business_group_id in number default hr_api.g_number
440: ,p_bpp_attribute_category in varchar2 default hr_api.g_varchar2
441: ,p_bpp_attribute1 in varchar2 default hr_api.g_varchar2
434: ,p_pgm_id in number default hr_api.g_number
435: ,p_oiplip_id in number default hr_api.g_number
436: ,p_cmbn_plip_id in number default hr_api.g_number
437: ,p_cmbn_ptip_id in number default hr_api.g_number
438: ,p_cmbn_ptip_opt_id in number default hr_api.g_number
439: ,p_business_group_id in number default hr_api.g_number
440: ,p_bpp_attribute_category in varchar2 default hr_api.g_varchar2
441: ,p_bpp_attribute1 in varchar2 default hr_api.g_varchar2
442: ,p_bpp_attribute2 in varchar2 default hr_api.g_varchar2
435: ,p_oiplip_id in number default hr_api.g_number
436: ,p_cmbn_plip_id in number default hr_api.g_number
437: ,p_cmbn_ptip_id in number default hr_api.g_number
438: ,p_cmbn_ptip_opt_id in number default hr_api.g_number
439: ,p_business_group_id in number default hr_api.g_number
440: ,p_bpp_attribute_category in varchar2 default hr_api.g_varchar2
441: ,p_bpp_attribute1 in varchar2 default hr_api.g_varchar2
442: ,p_bpp_attribute2 in varchar2 default hr_api.g_varchar2
443: ,p_bpp_attribute3 in varchar2 default hr_api.g_varchar2
436: ,p_cmbn_plip_id in number default hr_api.g_number
437: ,p_cmbn_ptip_id in number default hr_api.g_number
438: ,p_cmbn_ptip_opt_id in number default hr_api.g_number
439: ,p_business_group_id in number default hr_api.g_number
440: ,p_bpp_attribute_category in varchar2 default hr_api.g_varchar2
441: ,p_bpp_attribute1 in varchar2 default hr_api.g_varchar2
442: ,p_bpp_attribute2 in varchar2 default hr_api.g_varchar2
443: ,p_bpp_attribute3 in varchar2 default hr_api.g_varchar2
444: ,p_bpp_attribute4 in varchar2 default hr_api.g_varchar2
437: ,p_cmbn_ptip_id in number default hr_api.g_number
438: ,p_cmbn_ptip_opt_id in number default hr_api.g_number
439: ,p_business_group_id in number default hr_api.g_number
440: ,p_bpp_attribute_category in varchar2 default hr_api.g_varchar2
441: ,p_bpp_attribute1 in varchar2 default hr_api.g_varchar2
442: ,p_bpp_attribute2 in varchar2 default hr_api.g_varchar2
443: ,p_bpp_attribute3 in varchar2 default hr_api.g_varchar2
444: ,p_bpp_attribute4 in varchar2 default hr_api.g_varchar2
445: ,p_bpp_attribute5 in varchar2 default hr_api.g_varchar2
438: ,p_cmbn_ptip_opt_id in number default hr_api.g_number
439: ,p_business_group_id in number default hr_api.g_number
440: ,p_bpp_attribute_category in varchar2 default hr_api.g_varchar2
441: ,p_bpp_attribute1 in varchar2 default hr_api.g_varchar2
442: ,p_bpp_attribute2 in varchar2 default hr_api.g_varchar2
443: ,p_bpp_attribute3 in varchar2 default hr_api.g_varchar2
444: ,p_bpp_attribute4 in varchar2 default hr_api.g_varchar2
445: ,p_bpp_attribute5 in varchar2 default hr_api.g_varchar2
446: ,p_bpp_attribute6 in varchar2 default hr_api.g_varchar2
439: ,p_business_group_id in number default hr_api.g_number
440: ,p_bpp_attribute_category in varchar2 default hr_api.g_varchar2
441: ,p_bpp_attribute1 in varchar2 default hr_api.g_varchar2
442: ,p_bpp_attribute2 in varchar2 default hr_api.g_varchar2
443: ,p_bpp_attribute3 in varchar2 default hr_api.g_varchar2
444: ,p_bpp_attribute4 in varchar2 default hr_api.g_varchar2
445: ,p_bpp_attribute5 in varchar2 default hr_api.g_varchar2
446: ,p_bpp_attribute6 in varchar2 default hr_api.g_varchar2
447: ,p_bpp_attribute7 in varchar2 default hr_api.g_varchar2
440: ,p_bpp_attribute_category in varchar2 default hr_api.g_varchar2
441: ,p_bpp_attribute1 in varchar2 default hr_api.g_varchar2
442: ,p_bpp_attribute2 in varchar2 default hr_api.g_varchar2
443: ,p_bpp_attribute3 in varchar2 default hr_api.g_varchar2
444: ,p_bpp_attribute4 in varchar2 default hr_api.g_varchar2
445: ,p_bpp_attribute5 in varchar2 default hr_api.g_varchar2
446: ,p_bpp_attribute6 in varchar2 default hr_api.g_varchar2
447: ,p_bpp_attribute7 in varchar2 default hr_api.g_varchar2
448: ,p_bpp_attribute8 in varchar2 default hr_api.g_varchar2
441: ,p_bpp_attribute1 in varchar2 default hr_api.g_varchar2
442: ,p_bpp_attribute2 in varchar2 default hr_api.g_varchar2
443: ,p_bpp_attribute3 in varchar2 default hr_api.g_varchar2
444: ,p_bpp_attribute4 in varchar2 default hr_api.g_varchar2
445: ,p_bpp_attribute5 in varchar2 default hr_api.g_varchar2
446: ,p_bpp_attribute6 in varchar2 default hr_api.g_varchar2
447: ,p_bpp_attribute7 in varchar2 default hr_api.g_varchar2
448: ,p_bpp_attribute8 in varchar2 default hr_api.g_varchar2
449: ,p_bpp_attribute9 in varchar2 default hr_api.g_varchar2
442: ,p_bpp_attribute2 in varchar2 default hr_api.g_varchar2
443: ,p_bpp_attribute3 in varchar2 default hr_api.g_varchar2
444: ,p_bpp_attribute4 in varchar2 default hr_api.g_varchar2
445: ,p_bpp_attribute5 in varchar2 default hr_api.g_varchar2
446: ,p_bpp_attribute6 in varchar2 default hr_api.g_varchar2
447: ,p_bpp_attribute7 in varchar2 default hr_api.g_varchar2
448: ,p_bpp_attribute8 in varchar2 default hr_api.g_varchar2
449: ,p_bpp_attribute9 in varchar2 default hr_api.g_varchar2
450: ,p_bpp_attribute10 in varchar2 default hr_api.g_varchar2
443: ,p_bpp_attribute3 in varchar2 default hr_api.g_varchar2
444: ,p_bpp_attribute4 in varchar2 default hr_api.g_varchar2
445: ,p_bpp_attribute5 in varchar2 default hr_api.g_varchar2
446: ,p_bpp_attribute6 in varchar2 default hr_api.g_varchar2
447: ,p_bpp_attribute7 in varchar2 default hr_api.g_varchar2
448: ,p_bpp_attribute8 in varchar2 default hr_api.g_varchar2
449: ,p_bpp_attribute9 in varchar2 default hr_api.g_varchar2
450: ,p_bpp_attribute10 in varchar2 default hr_api.g_varchar2
451: ,p_bpp_attribute11 in varchar2 default hr_api.g_varchar2
444: ,p_bpp_attribute4 in varchar2 default hr_api.g_varchar2
445: ,p_bpp_attribute5 in varchar2 default hr_api.g_varchar2
446: ,p_bpp_attribute6 in varchar2 default hr_api.g_varchar2
447: ,p_bpp_attribute7 in varchar2 default hr_api.g_varchar2
448: ,p_bpp_attribute8 in varchar2 default hr_api.g_varchar2
449: ,p_bpp_attribute9 in varchar2 default hr_api.g_varchar2
450: ,p_bpp_attribute10 in varchar2 default hr_api.g_varchar2
451: ,p_bpp_attribute11 in varchar2 default hr_api.g_varchar2
452: ,p_bpp_attribute12 in varchar2 default hr_api.g_varchar2
445: ,p_bpp_attribute5 in varchar2 default hr_api.g_varchar2
446: ,p_bpp_attribute6 in varchar2 default hr_api.g_varchar2
447: ,p_bpp_attribute7 in varchar2 default hr_api.g_varchar2
448: ,p_bpp_attribute8 in varchar2 default hr_api.g_varchar2
449: ,p_bpp_attribute9 in varchar2 default hr_api.g_varchar2
450: ,p_bpp_attribute10 in varchar2 default hr_api.g_varchar2
451: ,p_bpp_attribute11 in varchar2 default hr_api.g_varchar2
452: ,p_bpp_attribute12 in varchar2 default hr_api.g_varchar2
453: ,p_bpp_attribute13 in varchar2 default hr_api.g_varchar2
446: ,p_bpp_attribute6 in varchar2 default hr_api.g_varchar2
447: ,p_bpp_attribute7 in varchar2 default hr_api.g_varchar2
448: ,p_bpp_attribute8 in varchar2 default hr_api.g_varchar2
449: ,p_bpp_attribute9 in varchar2 default hr_api.g_varchar2
450: ,p_bpp_attribute10 in varchar2 default hr_api.g_varchar2
451: ,p_bpp_attribute11 in varchar2 default hr_api.g_varchar2
452: ,p_bpp_attribute12 in varchar2 default hr_api.g_varchar2
453: ,p_bpp_attribute13 in varchar2 default hr_api.g_varchar2
454: ,p_bpp_attribute14 in varchar2 default hr_api.g_varchar2
447: ,p_bpp_attribute7 in varchar2 default hr_api.g_varchar2
448: ,p_bpp_attribute8 in varchar2 default hr_api.g_varchar2
449: ,p_bpp_attribute9 in varchar2 default hr_api.g_varchar2
450: ,p_bpp_attribute10 in varchar2 default hr_api.g_varchar2
451: ,p_bpp_attribute11 in varchar2 default hr_api.g_varchar2
452: ,p_bpp_attribute12 in varchar2 default hr_api.g_varchar2
453: ,p_bpp_attribute13 in varchar2 default hr_api.g_varchar2
454: ,p_bpp_attribute14 in varchar2 default hr_api.g_varchar2
455: ,p_bpp_attribute15 in varchar2 default hr_api.g_varchar2
448: ,p_bpp_attribute8 in varchar2 default hr_api.g_varchar2
449: ,p_bpp_attribute9 in varchar2 default hr_api.g_varchar2
450: ,p_bpp_attribute10 in varchar2 default hr_api.g_varchar2
451: ,p_bpp_attribute11 in varchar2 default hr_api.g_varchar2
452: ,p_bpp_attribute12 in varchar2 default hr_api.g_varchar2
453: ,p_bpp_attribute13 in varchar2 default hr_api.g_varchar2
454: ,p_bpp_attribute14 in varchar2 default hr_api.g_varchar2
455: ,p_bpp_attribute15 in varchar2 default hr_api.g_varchar2
456: ,p_bpp_attribute16 in varchar2 default hr_api.g_varchar2
449: ,p_bpp_attribute9 in varchar2 default hr_api.g_varchar2
450: ,p_bpp_attribute10 in varchar2 default hr_api.g_varchar2
451: ,p_bpp_attribute11 in varchar2 default hr_api.g_varchar2
452: ,p_bpp_attribute12 in varchar2 default hr_api.g_varchar2
453: ,p_bpp_attribute13 in varchar2 default hr_api.g_varchar2
454: ,p_bpp_attribute14 in varchar2 default hr_api.g_varchar2
455: ,p_bpp_attribute15 in varchar2 default hr_api.g_varchar2
456: ,p_bpp_attribute16 in varchar2 default hr_api.g_varchar2
457: ,p_bpp_attribute17 in varchar2 default hr_api.g_varchar2
450: ,p_bpp_attribute10 in varchar2 default hr_api.g_varchar2
451: ,p_bpp_attribute11 in varchar2 default hr_api.g_varchar2
452: ,p_bpp_attribute12 in varchar2 default hr_api.g_varchar2
453: ,p_bpp_attribute13 in varchar2 default hr_api.g_varchar2
454: ,p_bpp_attribute14 in varchar2 default hr_api.g_varchar2
455: ,p_bpp_attribute15 in varchar2 default hr_api.g_varchar2
456: ,p_bpp_attribute16 in varchar2 default hr_api.g_varchar2
457: ,p_bpp_attribute17 in varchar2 default hr_api.g_varchar2
458: ,p_bpp_attribute18 in varchar2 default hr_api.g_varchar2
451: ,p_bpp_attribute11 in varchar2 default hr_api.g_varchar2
452: ,p_bpp_attribute12 in varchar2 default hr_api.g_varchar2
453: ,p_bpp_attribute13 in varchar2 default hr_api.g_varchar2
454: ,p_bpp_attribute14 in varchar2 default hr_api.g_varchar2
455: ,p_bpp_attribute15 in varchar2 default hr_api.g_varchar2
456: ,p_bpp_attribute16 in varchar2 default hr_api.g_varchar2
457: ,p_bpp_attribute17 in varchar2 default hr_api.g_varchar2
458: ,p_bpp_attribute18 in varchar2 default hr_api.g_varchar2
459: ,p_bpp_attribute19 in varchar2 default hr_api.g_varchar2
452: ,p_bpp_attribute12 in varchar2 default hr_api.g_varchar2
453: ,p_bpp_attribute13 in varchar2 default hr_api.g_varchar2
454: ,p_bpp_attribute14 in varchar2 default hr_api.g_varchar2
455: ,p_bpp_attribute15 in varchar2 default hr_api.g_varchar2
456: ,p_bpp_attribute16 in varchar2 default hr_api.g_varchar2
457: ,p_bpp_attribute17 in varchar2 default hr_api.g_varchar2
458: ,p_bpp_attribute18 in varchar2 default hr_api.g_varchar2
459: ,p_bpp_attribute19 in varchar2 default hr_api.g_varchar2
460: ,p_bpp_attribute20 in varchar2 default hr_api.g_varchar2
453: ,p_bpp_attribute13 in varchar2 default hr_api.g_varchar2
454: ,p_bpp_attribute14 in varchar2 default hr_api.g_varchar2
455: ,p_bpp_attribute15 in varchar2 default hr_api.g_varchar2
456: ,p_bpp_attribute16 in varchar2 default hr_api.g_varchar2
457: ,p_bpp_attribute17 in varchar2 default hr_api.g_varchar2
458: ,p_bpp_attribute18 in varchar2 default hr_api.g_varchar2
459: ,p_bpp_attribute19 in varchar2 default hr_api.g_varchar2
460: ,p_bpp_attribute20 in varchar2 default hr_api.g_varchar2
461: ,p_bpp_attribute21 in varchar2 default hr_api.g_varchar2
454: ,p_bpp_attribute14 in varchar2 default hr_api.g_varchar2
455: ,p_bpp_attribute15 in varchar2 default hr_api.g_varchar2
456: ,p_bpp_attribute16 in varchar2 default hr_api.g_varchar2
457: ,p_bpp_attribute17 in varchar2 default hr_api.g_varchar2
458: ,p_bpp_attribute18 in varchar2 default hr_api.g_varchar2
459: ,p_bpp_attribute19 in varchar2 default hr_api.g_varchar2
460: ,p_bpp_attribute20 in varchar2 default hr_api.g_varchar2
461: ,p_bpp_attribute21 in varchar2 default hr_api.g_varchar2
462: ,p_bpp_attribute22 in varchar2 default hr_api.g_varchar2
455: ,p_bpp_attribute15 in varchar2 default hr_api.g_varchar2
456: ,p_bpp_attribute16 in varchar2 default hr_api.g_varchar2
457: ,p_bpp_attribute17 in varchar2 default hr_api.g_varchar2
458: ,p_bpp_attribute18 in varchar2 default hr_api.g_varchar2
459: ,p_bpp_attribute19 in varchar2 default hr_api.g_varchar2
460: ,p_bpp_attribute20 in varchar2 default hr_api.g_varchar2
461: ,p_bpp_attribute21 in varchar2 default hr_api.g_varchar2
462: ,p_bpp_attribute22 in varchar2 default hr_api.g_varchar2
463: ,p_bpp_attribute23 in varchar2 default hr_api.g_varchar2
456: ,p_bpp_attribute16 in varchar2 default hr_api.g_varchar2
457: ,p_bpp_attribute17 in varchar2 default hr_api.g_varchar2
458: ,p_bpp_attribute18 in varchar2 default hr_api.g_varchar2
459: ,p_bpp_attribute19 in varchar2 default hr_api.g_varchar2
460: ,p_bpp_attribute20 in varchar2 default hr_api.g_varchar2
461: ,p_bpp_attribute21 in varchar2 default hr_api.g_varchar2
462: ,p_bpp_attribute22 in varchar2 default hr_api.g_varchar2
463: ,p_bpp_attribute23 in varchar2 default hr_api.g_varchar2
464: ,p_bpp_attribute24 in varchar2 default hr_api.g_varchar2
457: ,p_bpp_attribute17 in varchar2 default hr_api.g_varchar2
458: ,p_bpp_attribute18 in varchar2 default hr_api.g_varchar2
459: ,p_bpp_attribute19 in varchar2 default hr_api.g_varchar2
460: ,p_bpp_attribute20 in varchar2 default hr_api.g_varchar2
461: ,p_bpp_attribute21 in varchar2 default hr_api.g_varchar2
462: ,p_bpp_attribute22 in varchar2 default hr_api.g_varchar2
463: ,p_bpp_attribute23 in varchar2 default hr_api.g_varchar2
464: ,p_bpp_attribute24 in varchar2 default hr_api.g_varchar2
465: ,p_bpp_attribute25 in varchar2 default hr_api.g_varchar2
458: ,p_bpp_attribute18 in varchar2 default hr_api.g_varchar2
459: ,p_bpp_attribute19 in varchar2 default hr_api.g_varchar2
460: ,p_bpp_attribute20 in varchar2 default hr_api.g_varchar2
461: ,p_bpp_attribute21 in varchar2 default hr_api.g_varchar2
462: ,p_bpp_attribute22 in varchar2 default hr_api.g_varchar2
463: ,p_bpp_attribute23 in varchar2 default hr_api.g_varchar2
464: ,p_bpp_attribute24 in varchar2 default hr_api.g_varchar2
465: ,p_bpp_attribute25 in varchar2 default hr_api.g_varchar2
466: ,p_bpp_attribute26 in varchar2 default hr_api.g_varchar2
459: ,p_bpp_attribute19 in varchar2 default hr_api.g_varchar2
460: ,p_bpp_attribute20 in varchar2 default hr_api.g_varchar2
461: ,p_bpp_attribute21 in varchar2 default hr_api.g_varchar2
462: ,p_bpp_attribute22 in varchar2 default hr_api.g_varchar2
463: ,p_bpp_attribute23 in varchar2 default hr_api.g_varchar2
464: ,p_bpp_attribute24 in varchar2 default hr_api.g_varchar2
465: ,p_bpp_attribute25 in varchar2 default hr_api.g_varchar2
466: ,p_bpp_attribute26 in varchar2 default hr_api.g_varchar2
467: ,p_bpp_attribute27 in varchar2 default hr_api.g_varchar2
460: ,p_bpp_attribute20 in varchar2 default hr_api.g_varchar2
461: ,p_bpp_attribute21 in varchar2 default hr_api.g_varchar2
462: ,p_bpp_attribute22 in varchar2 default hr_api.g_varchar2
463: ,p_bpp_attribute23 in varchar2 default hr_api.g_varchar2
464: ,p_bpp_attribute24 in varchar2 default hr_api.g_varchar2
465: ,p_bpp_attribute25 in varchar2 default hr_api.g_varchar2
466: ,p_bpp_attribute26 in varchar2 default hr_api.g_varchar2
467: ,p_bpp_attribute27 in varchar2 default hr_api.g_varchar2
468: ,p_bpp_attribute28 in varchar2 default hr_api.g_varchar2
461: ,p_bpp_attribute21 in varchar2 default hr_api.g_varchar2
462: ,p_bpp_attribute22 in varchar2 default hr_api.g_varchar2
463: ,p_bpp_attribute23 in varchar2 default hr_api.g_varchar2
464: ,p_bpp_attribute24 in varchar2 default hr_api.g_varchar2
465: ,p_bpp_attribute25 in varchar2 default hr_api.g_varchar2
466: ,p_bpp_attribute26 in varchar2 default hr_api.g_varchar2
467: ,p_bpp_attribute27 in varchar2 default hr_api.g_varchar2
468: ,p_bpp_attribute28 in varchar2 default hr_api.g_varchar2
469: ,p_bpp_attribute29 in varchar2 default hr_api.g_varchar2
462: ,p_bpp_attribute22 in varchar2 default hr_api.g_varchar2
463: ,p_bpp_attribute23 in varchar2 default hr_api.g_varchar2
464: ,p_bpp_attribute24 in varchar2 default hr_api.g_varchar2
465: ,p_bpp_attribute25 in varchar2 default hr_api.g_varchar2
466: ,p_bpp_attribute26 in varchar2 default hr_api.g_varchar2
467: ,p_bpp_attribute27 in varchar2 default hr_api.g_varchar2
468: ,p_bpp_attribute28 in varchar2 default hr_api.g_varchar2
469: ,p_bpp_attribute29 in varchar2 default hr_api.g_varchar2
470: ,p_bpp_attribute30 in varchar2 default hr_api.g_varchar2
463: ,p_bpp_attribute23 in varchar2 default hr_api.g_varchar2
464: ,p_bpp_attribute24 in varchar2 default hr_api.g_varchar2
465: ,p_bpp_attribute25 in varchar2 default hr_api.g_varchar2
466: ,p_bpp_attribute26 in varchar2 default hr_api.g_varchar2
467: ,p_bpp_attribute27 in varchar2 default hr_api.g_varchar2
468: ,p_bpp_attribute28 in varchar2 default hr_api.g_varchar2
469: ,p_bpp_attribute29 in varchar2 default hr_api.g_varchar2
470: ,p_bpp_attribute30 in varchar2 default hr_api.g_varchar2
471: ,p_object_version_number in out nocopy number
464: ,p_bpp_attribute24 in varchar2 default hr_api.g_varchar2
465: ,p_bpp_attribute25 in varchar2 default hr_api.g_varchar2
466: ,p_bpp_attribute26 in varchar2 default hr_api.g_varchar2
467: ,p_bpp_attribute27 in varchar2 default hr_api.g_varchar2
468: ,p_bpp_attribute28 in varchar2 default hr_api.g_varchar2
469: ,p_bpp_attribute29 in varchar2 default hr_api.g_varchar2
470: ,p_bpp_attribute30 in varchar2 default hr_api.g_varchar2
471: ,p_object_version_number in out nocopy number
472: ,p_effective_date in date
465: ,p_bpp_attribute25 in varchar2 default hr_api.g_varchar2
466: ,p_bpp_attribute26 in varchar2 default hr_api.g_varchar2
467: ,p_bpp_attribute27 in varchar2 default hr_api.g_varchar2
468: ,p_bpp_attribute28 in varchar2 default hr_api.g_varchar2
469: ,p_bpp_attribute29 in varchar2 default hr_api.g_varchar2
470: ,p_bpp_attribute30 in varchar2 default hr_api.g_varchar2
471: ,p_object_version_number in out nocopy number
472: ,p_effective_date in date
473: ,p_datetrack_mode in varchar2
466: ,p_bpp_attribute26 in varchar2 default hr_api.g_varchar2
467: ,p_bpp_attribute27 in varchar2 default hr_api.g_varchar2
468: ,p_bpp_attribute28 in varchar2 default hr_api.g_varchar2
469: ,p_bpp_attribute29 in varchar2 default hr_api.g_varchar2
470: ,p_bpp_attribute30 in varchar2 default hr_api.g_varchar2
471: ,p_object_version_number in out nocopy number
472: ,p_effective_date in date
473: ,p_datetrack_mode in varchar2
474: ) is
570: ,p_effective_date => trunc(p_effective_date)
571: ,p_datetrack_mode => p_datetrack_mode
572: );
573: exception
574: when hr_api.cannot_find_prog_unit then
575: hr_api.cannot_find_prog_unit_error
576: (p_module_name => 'UPDATE_Benefit_Prvdr_Pool'
577: ,p_hook_type => 'BP'
578: );
571: ,p_datetrack_mode => p_datetrack_mode
572: );
573: exception
574: when hr_api.cannot_find_prog_unit then
575: hr_api.cannot_find_prog_unit_error
576: (p_module_name => 'UPDATE_Benefit_Prvdr_Pool'
577: ,p_hook_type => 'BP'
578: );
579: --
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 => 'UPDATE_Benefit_Prvdr_Pool'
742: ,p_hook_type => 'AP'
743: );
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 => 'UPDATE_Benefit_Prvdr_Pool'
742: ,p_hook_type => 'AP'
743: );
744: --
750: --
751: -- When in validation only mode raise the Validate_Enabled exception
752: --
753: if p_validate then
754: raise hr_api.validate_enabled;
755: end if;
756: --
757: -- Set all output arguments
758: --
763: hr_utility.set_location(' Leaving:'||l_proc, 70);
764: --
765: exception
766: --
767: when hr_api.validate_enabled then
768: --
769: -- As the Validate_Enabled exception has been raised
770: -- we must rollback to the savepoint
771: --
832: ,p_effective_date => trunc(p_effective_date)
833: ,p_datetrack_mode => p_datetrack_mode
834: );
835: exception
836: when hr_api.cannot_find_prog_unit then
837: hr_api.cannot_find_prog_unit_error
838: (p_module_name => 'DELETE_Benefit_Prvdr_Pool'
839: ,p_hook_type => 'BP'
840: );
833: ,p_datetrack_mode => p_datetrack_mode
834: );
835: exception
836: when hr_api.cannot_find_prog_unit then
837: hr_api.cannot_find_prog_unit_error
838: (p_module_name => 'DELETE_Benefit_Prvdr_Pool'
839: ,p_hook_type => 'BP'
840: );
841: --
866: ,p_effective_date => trunc(p_effective_date)
867: ,p_datetrack_mode => p_datetrack_mode
868: );
869: exception
870: when hr_api.cannot_find_prog_unit then
871: hr_api.cannot_find_prog_unit_error
872: (p_module_name => 'DELETE_Benefit_Prvdr_Pool'
873: ,p_hook_type => 'AP'
874: );
867: ,p_datetrack_mode => p_datetrack_mode
868: );
869: exception
870: when hr_api.cannot_find_prog_unit then
871: hr_api.cannot_find_prog_unit_error
872: (p_module_name => 'DELETE_Benefit_Prvdr_Pool'
873: ,p_hook_type => 'AP'
874: );
875: --
881: --
882: -- When in validation only mode raise the Validate_Enabled exception
883: --
884: if p_validate then
885: raise hr_api.validate_enabled;
886: end if;
887: --
888: hr_utility.set_location(' Leaving:'||l_proc, 70);
889: --
888: hr_utility.set_location(' Leaving:'||l_proc, 70);
889: --
890: exception
891: --
892: when hr_api.validate_enabled then
893: --
894: -- As the Validate_Enabled exception has been raised
895: -- we must rollback to the savepoint
896: --