DBA Data[Home] [Help]

APPS.BEN_BENEFIT_PRVDR_POOL_API dependencies on HR_API

Line 180: when hr_api.cannot_find_prog_unit then

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'

Line 181: hr_api.cannot_find_prog_unit_error

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: );

Line 343: when hr_api.cannot_find_prog_unit then

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: );

Line 344: hr_api.cannot_find_prog_unit_error

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: --

Line 358: raise hr_api.validate_enabled;

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: --

Line 372: when hr_api.validate_enabled then

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: --

Line 406: ,p_name in varchar2 default hr_api.g_varchar2

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

Line 407: ,p_pgm_pool_flag 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

Line 408: ,p_excs_alwys_fftd_flag in varchar2 default hr_api.g_varchar2

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

Line 409: ,p_use_for_pgm_pool_flag 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

Line 410: ,p_pct_rndg_cd in varchar2 default hr_api.g_varchar2

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

Line 411: ,p_pct_rndg_rl in number default hr_api.g_number

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

Line 412: ,p_val_rndg_cd 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
416: ,p_rlovr_rstrcn_cd in varchar2 default hr_api.g_varchar2

Line 413: ,p_val_rndg_rl in number default hr_api.g_number

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

Line 414: ,p_dflt_excs_trtmt_cd 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

Line 415: ,p_dflt_excs_trtmt_rl in number default hr_api.g_number

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

Line 416: ,p_rlovr_rstrcn_cd 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

Line 417: ,p_no_mn_dstrbl_pct_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

Line 418: ,p_no_mn_dstrbl_val_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

Line 419: ,p_no_mx_dstrbl_pct_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

Line 420: ,p_no_mx_dstrbl_val_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

Line 421: ,p_auto_alct_excs_flag 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
425: ,p_mx_dfcit_pct_comp_num in number default hr_api.g_number

Line 422: ,p_alws_ngtv_crs_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
426: ,p_comp_lvl_fctr_id in number default hr_api.g_number

Line 423: ,p_uses_net_crs_mthd_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
427: ,p_mn_dstrbl_pct_num in number default hr_api.g_number

Line 424: ,p_mx_dfcit_pct_pool_crs_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

Line 425: ,p_mx_dfcit_pct_comp_num 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

Line 426: ,p_comp_lvl_fctr_id 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

Line 427: ,p_mn_dstrbl_pct_num 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

Line 428: ,p_mn_dstrbl_val in number default hr_api.g_number

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

Line 429: ,p_mx_dstrbl_pct_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
433: ,p_plip_id in number default hr_api.g_number

Line 430: ,p_mx_dstrbl_val 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

Line 431: ,p_excs_trtmt_cd in varchar2 default hr_api.g_varchar2

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

Line 432: ,p_ptip_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

Line 433: ,p_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

Line 434: ,p_pgm_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

Line 435: ,p_oiplip_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

Line 436: ,p_cmbn_plip_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

Line 437: ,p_cmbn_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
441: ,p_bpp_attribute1 in varchar2 default hr_api.g_varchar2

Line 438: ,p_cmbn_ptip_opt_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
442: ,p_bpp_attribute2 in varchar2 default hr_api.g_varchar2

Line 439: ,p_business_group_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
443: ,p_bpp_attribute3 in varchar2 default hr_api.g_varchar2

Line 440: ,p_bpp_attribute_category 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

Line 441: ,p_bpp_attribute1 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

Line 442: ,p_bpp_attribute2 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

Line 443: ,p_bpp_attribute3 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

Line 444: ,p_bpp_attribute4 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

Line 445: ,p_bpp_attribute5 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

Line 446: ,p_bpp_attribute6 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

Line 447: ,p_bpp_attribute7 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

Line 448: ,p_bpp_attribute8 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

Line 449: ,p_bpp_attribute9 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

Line 450: ,p_bpp_attribute10 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

Line 451: ,p_bpp_attribute11 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

Line 452: ,p_bpp_attribute12 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

Line 453: ,p_bpp_attribute13 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

Line 454: ,p_bpp_attribute14 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

Line 455: ,p_bpp_attribute15 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

Line 456: ,p_bpp_attribute16 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

Line 457: ,p_bpp_attribute17 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

Line 458: ,p_bpp_attribute18 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

Line 459: ,p_bpp_attribute19 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

Line 460: ,p_bpp_attribute20 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

Line 461: ,p_bpp_attribute21 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

Line 462: ,p_bpp_attribute22 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

Line 463: ,p_bpp_attribute23 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

Line 464: ,p_bpp_attribute24 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

Line 465: ,p_bpp_attribute25 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

Line 466: ,p_bpp_attribute26 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

Line 467: ,p_bpp_attribute27 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

Line 468: ,p_bpp_attribute28 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
472: ,p_effective_date in date

Line 469: ,p_bpp_attribute29 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
473: ,p_datetrack_mode in varchar2

Line 470: ,p_bpp_attribute30 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
474: ) is

Line 574: when hr_api.cannot_find_prog_unit then

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: );

Line 575: hr_api.cannot_find_prog_unit_error

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: --

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 => 'UPDATE_Benefit_Prvdr_Pool'
742: ,p_hook_type => 'AP'
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 => 'UPDATE_Benefit_Prvdr_Pool'
742: ,p_hook_type => 'AP'
743: );
744: --

Line 754: raise hr_api.validate_enabled;

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: --

Line 767: when hr_api.validate_enabled then

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: --

Line 836: when hr_api.cannot_find_prog_unit then

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: );

Line 837: hr_api.cannot_find_prog_unit_error

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: --

Line 870: when hr_api.cannot_find_prog_unit then

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: );

Line 871: hr_api.cannot_find_prog_unit_error

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: --

Line 885: raise hr_api.validate_enabled;

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: --

Line 892: when hr_api.validate_enabled then

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: --