174: ,p_vrbl_rt_add_on_calc_rl => p_vrbl_rt_add_on_calc_rl
175: ,p_effective_date => trunc(p_effective_date)
176: );
177: exception
178: when hr_api.cannot_find_prog_unit then
179: hr_api.cannot_find_prog_unit_error
180: (
181: p_module_name => 'CREATE_actual_premium'
182: ,p_hook_type => 'BP'
175: ,p_effective_date => trunc(p_effective_date)
176: );
177: exception
178: when hr_api.cannot_find_prog_unit then
179: hr_api.cannot_find_prog_unit_error
180: (
181: p_module_name => 'CREATE_actual_premium'
182: ,p_hook_type => 'BP'
183: );
335: ,p_vrbl_rt_add_on_calc_rl => p_vrbl_rt_add_on_calc_rl
336: ,p_effective_date => trunc(p_effective_date)
337: );
338: exception
339: when hr_api.cannot_find_prog_unit then
340: hr_api.cannot_find_prog_unit_error
341: (p_module_name => 'CREATE_actual_premium'
342: ,p_hook_type => 'AP'
343: );
336: ,p_effective_date => trunc(p_effective_date)
337: );
338: exception
339: when hr_api.cannot_find_prog_unit then
340: hr_api.cannot_find_prog_unit_error
341: (p_module_name => 'CREATE_actual_premium'
342: ,p_hook_type => 'AP'
343: );
344: --
350: --
351: -- When in validation only mode raise the Validate_Enabled exception
352: --
353: if p_validate then
354: raise hr_api.validate_enabled;
355: end if;
356: --
357: -- Set all output arguments
358: --
364: hr_utility.set_location(' Leaving:'||l_proc, 70);
365: --
366: exception
367: --
368: when hr_api.validate_enabled then
369: --
370: -- As the Validate_Enabled exception has been raised
371: -- we must rollback to the savepoint
372: --
402: (p_validate in boolean default false
403: ,p_actl_prem_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_acty_ref_perd_cd in varchar2 default hr_api.g_varchar2
408: ,p_uom in varchar2 default hr_api.g_varchar2
409: ,p_rt_typ_cd in varchar2 default hr_api.g_varchar2
410: ,p_bnft_rt_typ_cd in varchar2 default hr_api.g_varchar2
403: ,p_actl_prem_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_acty_ref_perd_cd in varchar2 default hr_api.g_varchar2
408: ,p_uom in varchar2 default hr_api.g_varchar2
409: ,p_rt_typ_cd in varchar2 default hr_api.g_varchar2
410: ,p_bnft_rt_typ_cd in varchar2 default hr_api.g_varchar2
411: ,p_val 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_acty_ref_perd_cd in varchar2 default hr_api.g_varchar2
408: ,p_uom in varchar2 default hr_api.g_varchar2
409: ,p_rt_typ_cd in varchar2 default hr_api.g_varchar2
410: ,p_bnft_rt_typ_cd in varchar2 default hr_api.g_varchar2
411: ,p_val in number default hr_api.g_number
412: ,p_mlt_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_acty_ref_perd_cd in varchar2 default hr_api.g_varchar2
408: ,p_uom in varchar2 default hr_api.g_varchar2
409: ,p_rt_typ_cd in varchar2 default hr_api.g_varchar2
410: ,p_bnft_rt_typ_cd in varchar2 default hr_api.g_varchar2
411: ,p_val in number default hr_api.g_number
412: ,p_mlt_cd in varchar2 default hr_api.g_varchar2
413: ,p_prdct_cd in varchar2 default hr_api.g_varchar2
406: ,p_name in varchar2 default hr_api.g_varchar2
407: ,p_acty_ref_perd_cd in varchar2 default hr_api.g_varchar2
408: ,p_uom in varchar2 default hr_api.g_varchar2
409: ,p_rt_typ_cd in varchar2 default hr_api.g_varchar2
410: ,p_bnft_rt_typ_cd in varchar2 default hr_api.g_varchar2
411: ,p_val in number default hr_api.g_number
412: ,p_mlt_cd in varchar2 default hr_api.g_varchar2
413: ,p_prdct_cd in varchar2 default hr_api.g_varchar2
414: ,p_rndg_cd in varchar2 default hr_api.g_varchar2
407: ,p_acty_ref_perd_cd in varchar2 default hr_api.g_varchar2
408: ,p_uom in varchar2 default hr_api.g_varchar2
409: ,p_rt_typ_cd in varchar2 default hr_api.g_varchar2
410: ,p_bnft_rt_typ_cd in varchar2 default hr_api.g_varchar2
411: ,p_val in number default hr_api.g_number
412: ,p_mlt_cd in varchar2 default hr_api.g_varchar2
413: ,p_prdct_cd in varchar2 default hr_api.g_varchar2
414: ,p_rndg_cd in varchar2 default hr_api.g_varchar2
415: ,p_rndg_rl in number default hr_api.g_number
408: ,p_uom in varchar2 default hr_api.g_varchar2
409: ,p_rt_typ_cd in varchar2 default hr_api.g_varchar2
410: ,p_bnft_rt_typ_cd in varchar2 default hr_api.g_varchar2
411: ,p_val in number default hr_api.g_number
412: ,p_mlt_cd in varchar2 default hr_api.g_varchar2
413: ,p_prdct_cd in varchar2 default hr_api.g_varchar2
414: ,p_rndg_cd in varchar2 default hr_api.g_varchar2
415: ,p_rndg_rl in number default hr_api.g_number
416: ,p_val_calc_rl in number default hr_api.g_number
409: ,p_rt_typ_cd in varchar2 default hr_api.g_varchar2
410: ,p_bnft_rt_typ_cd in varchar2 default hr_api.g_varchar2
411: ,p_val in number default hr_api.g_number
412: ,p_mlt_cd in varchar2 default hr_api.g_varchar2
413: ,p_prdct_cd in varchar2 default hr_api.g_varchar2
414: ,p_rndg_cd in varchar2 default hr_api.g_varchar2
415: ,p_rndg_rl in number default hr_api.g_number
416: ,p_val_calc_rl in number default hr_api.g_number
417: ,p_prem_asnmt_cd in varchar2 default hr_api.g_varchar2
410: ,p_bnft_rt_typ_cd in varchar2 default hr_api.g_varchar2
411: ,p_val in number default hr_api.g_number
412: ,p_mlt_cd in varchar2 default hr_api.g_varchar2
413: ,p_prdct_cd in varchar2 default hr_api.g_varchar2
414: ,p_rndg_cd in varchar2 default hr_api.g_varchar2
415: ,p_rndg_rl in number default hr_api.g_number
416: ,p_val_calc_rl in number default hr_api.g_number
417: ,p_prem_asnmt_cd in varchar2 default hr_api.g_varchar2
418: ,p_prem_asnmt_lvl_cd in varchar2 default hr_api.g_varchar2
411: ,p_val in number default hr_api.g_number
412: ,p_mlt_cd in varchar2 default hr_api.g_varchar2
413: ,p_prdct_cd in varchar2 default hr_api.g_varchar2
414: ,p_rndg_cd in varchar2 default hr_api.g_varchar2
415: ,p_rndg_rl in number default hr_api.g_number
416: ,p_val_calc_rl in number default hr_api.g_number
417: ,p_prem_asnmt_cd in varchar2 default hr_api.g_varchar2
418: ,p_prem_asnmt_lvl_cd in varchar2 default hr_api.g_varchar2
419: ,p_actl_prem_typ_cd in varchar2 default hr_api.g_varchar2
412: ,p_mlt_cd in varchar2 default hr_api.g_varchar2
413: ,p_prdct_cd in varchar2 default hr_api.g_varchar2
414: ,p_rndg_cd in varchar2 default hr_api.g_varchar2
415: ,p_rndg_rl in number default hr_api.g_number
416: ,p_val_calc_rl in number default hr_api.g_number
417: ,p_prem_asnmt_cd in varchar2 default hr_api.g_varchar2
418: ,p_prem_asnmt_lvl_cd in varchar2 default hr_api.g_varchar2
419: ,p_actl_prem_typ_cd in varchar2 default hr_api.g_varchar2
420: ,p_prem_pyr_cd in varchar2 default hr_api.g_varchar2
413: ,p_prdct_cd in varchar2 default hr_api.g_varchar2
414: ,p_rndg_cd in varchar2 default hr_api.g_varchar2
415: ,p_rndg_rl in number default hr_api.g_number
416: ,p_val_calc_rl in number default hr_api.g_number
417: ,p_prem_asnmt_cd in varchar2 default hr_api.g_varchar2
418: ,p_prem_asnmt_lvl_cd in varchar2 default hr_api.g_varchar2
419: ,p_actl_prem_typ_cd in varchar2 default hr_api.g_varchar2
420: ,p_prem_pyr_cd in varchar2 default hr_api.g_varchar2
421: ,p_cr_lkbk_val in number default hr_api.g_number
414: ,p_rndg_cd in varchar2 default hr_api.g_varchar2
415: ,p_rndg_rl in number default hr_api.g_number
416: ,p_val_calc_rl in number default hr_api.g_number
417: ,p_prem_asnmt_cd in varchar2 default hr_api.g_varchar2
418: ,p_prem_asnmt_lvl_cd in varchar2 default hr_api.g_varchar2
419: ,p_actl_prem_typ_cd in varchar2 default hr_api.g_varchar2
420: ,p_prem_pyr_cd in varchar2 default hr_api.g_varchar2
421: ,p_cr_lkbk_val in number default hr_api.g_number
422: ,p_cr_lkbk_uom in varchar2 default hr_api.g_varchar2
415: ,p_rndg_rl in number default hr_api.g_number
416: ,p_val_calc_rl in number default hr_api.g_number
417: ,p_prem_asnmt_cd in varchar2 default hr_api.g_varchar2
418: ,p_prem_asnmt_lvl_cd in varchar2 default hr_api.g_varchar2
419: ,p_actl_prem_typ_cd in varchar2 default hr_api.g_varchar2
420: ,p_prem_pyr_cd in varchar2 default hr_api.g_varchar2
421: ,p_cr_lkbk_val in number default hr_api.g_number
422: ,p_cr_lkbk_uom in varchar2 default hr_api.g_varchar2
423: ,p_cr_lkbk_crnt_py_only_flag in varchar2 default hr_api.g_varchar2
416: ,p_val_calc_rl in number default hr_api.g_number
417: ,p_prem_asnmt_cd in varchar2 default hr_api.g_varchar2
418: ,p_prem_asnmt_lvl_cd in varchar2 default hr_api.g_varchar2
419: ,p_actl_prem_typ_cd in varchar2 default hr_api.g_varchar2
420: ,p_prem_pyr_cd in varchar2 default hr_api.g_varchar2
421: ,p_cr_lkbk_val in number default hr_api.g_number
422: ,p_cr_lkbk_uom in varchar2 default hr_api.g_varchar2
423: ,p_cr_lkbk_crnt_py_only_flag in varchar2 default hr_api.g_varchar2
424: ,p_prsptv_r_rtsptv_cd in varchar2 default hr_api.g_varchar2
417: ,p_prem_asnmt_cd in varchar2 default hr_api.g_varchar2
418: ,p_prem_asnmt_lvl_cd in varchar2 default hr_api.g_varchar2
419: ,p_actl_prem_typ_cd in varchar2 default hr_api.g_varchar2
420: ,p_prem_pyr_cd in varchar2 default hr_api.g_varchar2
421: ,p_cr_lkbk_val in number default hr_api.g_number
422: ,p_cr_lkbk_uom in varchar2 default hr_api.g_varchar2
423: ,p_cr_lkbk_crnt_py_only_flag in varchar2 default hr_api.g_varchar2
424: ,p_prsptv_r_rtsptv_cd in varchar2 default hr_api.g_varchar2
425: ,p_upr_lmt_val in number default hr_api.g_number
418: ,p_prem_asnmt_lvl_cd in varchar2 default hr_api.g_varchar2
419: ,p_actl_prem_typ_cd in varchar2 default hr_api.g_varchar2
420: ,p_prem_pyr_cd in varchar2 default hr_api.g_varchar2
421: ,p_cr_lkbk_val in number default hr_api.g_number
422: ,p_cr_lkbk_uom in varchar2 default hr_api.g_varchar2
423: ,p_cr_lkbk_crnt_py_only_flag in varchar2 default hr_api.g_varchar2
424: ,p_prsptv_r_rtsptv_cd in varchar2 default hr_api.g_varchar2
425: ,p_upr_lmt_val in number default hr_api.g_number
426: ,p_upr_lmt_calc_rl in number default hr_api.g_number
419: ,p_actl_prem_typ_cd in varchar2 default hr_api.g_varchar2
420: ,p_prem_pyr_cd in varchar2 default hr_api.g_varchar2
421: ,p_cr_lkbk_val in number default hr_api.g_number
422: ,p_cr_lkbk_uom in varchar2 default hr_api.g_varchar2
423: ,p_cr_lkbk_crnt_py_only_flag in varchar2 default hr_api.g_varchar2
424: ,p_prsptv_r_rtsptv_cd in varchar2 default hr_api.g_varchar2
425: ,p_upr_lmt_val in number default hr_api.g_number
426: ,p_upr_lmt_calc_rl in number default hr_api.g_number
427: ,p_lwr_lmt_val in number default hr_api.g_number
420: ,p_prem_pyr_cd in varchar2 default hr_api.g_varchar2
421: ,p_cr_lkbk_val in number default hr_api.g_number
422: ,p_cr_lkbk_uom in varchar2 default hr_api.g_varchar2
423: ,p_cr_lkbk_crnt_py_only_flag in varchar2 default hr_api.g_varchar2
424: ,p_prsptv_r_rtsptv_cd in varchar2 default hr_api.g_varchar2
425: ,p_upr_lmt_val in number default hr_api.g_number
426: ,p_upr_lmt_calc_rl in number default hr_api.g_number
427: ,p_lwr_lmt_val in number default hr_api.g_number
428: ,p_lwr_lmt_calc_rl in number default hr_api.g_number
421: ,p_cr_lkbk_val in number default hr_api.g_number
422: ,p_cr_lkbk_uom in varchar2 default hr_api.g_varchar2
423: ,p_cr_lkbk_crnt_py_only_flag in varchar2 default hr_api.g_varchar2
424: ,p_prsptv_r_rtsptv_cd in varchar2 default hr_api.g_varchar2
425: ,p_upr_lmt_val in number default hr_api.g_number
426: ,p_upr_lmt_calc_rl in number default hr_api.g_number
427: ,p_lwr_lmt_val in number default hr_api.g_number
428: ,p_lwr_lmt_calc_rl in number default hr_api.g_number
429: ,p_cost_allocation_keyflex_id in number default hr_api.g_number
422: ,p_cr_lkbk_uom in varchar2 default hr_api.g_varchar2
423: ,p_cr_lkbk_crnt_py_only_flag in varchar2 default hr_api.g_varchar2
424: ,p_prsptv_r_rtsptv_cd in varchar2 default hr_api.g_varchar2
425: ,p_upr_lmt_val in number default hr_api.g_number
426: ,p_upr_lmt_calc_rl in number default hr_api.g_number
427: ,p_lwr_lmt_val in number default hr_api.g_number
428: ,p_lwr_lmt_calc_rl in number default hr_api.g_number
429: ,p_cost_allocation_keyflex_id in number default hr_api.g_number
430: ,p_organization_id in number default hr_api.g_number
423: ,p_cr_lkbk_crnt_py_only_flag in varchar2 default hr_api.g_varchar2
424: ,p_prsptv_r_rtsptv_cd in varchar2 default hr_api.g_varchar2
425: ,p_upr_lmt_val in number default hr_api.g_number
426: ,p_upr_lmt_calc_rl in number default hr_api.g_number
427: ,p_lwr_lmt_val in number default hr_api.g_number
428: ,p_lwr_lmt_calc_rl in number default hr_api.g_number
429: ,p_cost_allocation_keyflex_id in number default hr_api.g_number
430: ,p_organization_id in number default hr_api.g_number
431: ,p_oipl_id in number default hr_api.g_number
424: ,p_prsptv_r_rtsptv_cd in varchar2 default hr_api.g_varchar2
425: ,p_upr_lmt_val in number default hr_api.g_number
426: ,p_upr_lmt_calc_rl in number default hr_api.g_number
427: ,p_lwr_lmt_val in number default hr_api.g_number
428: ,p_lwr_lmt_calc_rl in number default hr_api.g_number
429: ,p_cost_allocation_keyflex_id in number default hr_api.g_number
430: ,p_organization_id in number default hr_api.g_number
431: ,p_oipl_id in number default hr_api.g_number
432: ,p_pl_id in number default hr_api.g_number
425: ,p_upr_lmt_val in number default hr_api.g_number
426: ,p_upr_lmt_calc_rl in number default hr_api.g_number
427: ,p_lwr_lmt_val in number default hr_api.g_number
428: ,p_lwr_lmt_calc_rl in number default hr_api.g_number
429: ,p_cost_allocation_keyflex_id in number default hr_api.g_number
430: ,p_organization_id in number default hr_api.g_number
431: ,p_oipl_id in number default hr_api.g_number
432: ,p_pl_id in number default hr_api.g_number
433: ,p_comp_lvl_fctr_id in number default hr_api.g_number
426: ,p_upr_lmt_calc_rl in number default hr_api.g_number
427: ,p_lwr_lmt_val in number default hr_api.g_number
428: ,p_lwr_lmt_calc_rl in number default hr_api.g_number
429: ,p_cost_allocation_keyflex_id in number default hr_api.g_number
430: ,p_organization_id in number default hr_api.g_number
431: ,p_oipl_id in number default hr_api.g_number
432: ,p_pl_id in number default hr_api.g_number
433: ,p_comp_lvl_fctr_id in number default hr_api.g_number
434: ,p_business_group_id in number default hr_api.g_number
427: ,p_lwr_lmt_val in number default hr_api.g_number
428: ,p_lwr_lmt_calc_rl in number default hr_api.g_number
429: ,p_cost_allocation_keyflex_id in number default hr_api.g_number
430: ,p_organization_id in number default hr_api.g_number
431: ,p_oipl_id in number default hr_api.g_number
432: ,p_pl_id in number default hr_api.g_number
433: ,p_comp_lvl_fctr_id in number default hr_api.g_number
434: ,p_business_group_id in number default hr_api.g_number
435: ,p_apr_attribute_category in varchar2 default hr_api.g_varchar2
428: ,p_lwr_lmt_calc_rl in number default hr_api.g_number
429: ,p_cost_allocation_keyflex_id in number default hr_api.g_number
430: ,p_organization_id in number default hr_api.g_number
431: ,p_oipl_id in number default hr_api.g_number
432: ,p_pl_id in number default hr_api.g_number
433: ,p_comp_lvl_fctr_id in number default hr_api.g_number
434: ,p_business_group_id in number default hr_api.g_number
435: ,p_apr_attribute_category in varchar2 default hr_api.g_varchar2
436: ,p_apr_attribute1 in varchar2 default hr_api.g_varchar2
429: ,p_cost_allocation_keyflex_id in number default hr_api.g_number
430: ,p_organization_id in number default hr_api.g_number
431: ,p_oipl_id in number default hr_api.g_number
432: ,p_pl_id in number default hr_api.g_number
433: ,p_comp_lvl_fctr_id in number default hr_api.g_number
434: ,p_business_group_id in number default hr_api.g_number
435: ,p_apr_attribute_category in varchar2 default hr_api.g_varchar2
436: ,p_apr_attribute1 in varchar2 default hr_api.g_varchar2
437: ,p_apr_attribute2 in varchar2 default hr_api.g_varchar2
430: ,p_organization_id in number default hr_api.g_number
431: ,p_oipl_id in number default hr_api.g_number
432: ,p_pl_id in number default hr_api.g_number
433: ,p_comp_lvl_fctr_id in number default hr_api.g_number
434: ,p_business_group_id in number default hr_api.g_number
435: ,p_apr_attribute_category in varchar2 default hr_api.g_varchar2
436: ,p_apr_attribute1 in varchar2 default hr_api.g_varchar2
437: ,p_apr_attribute2 in varchar2 default hr_api.g_varchar2
438: ,p_apr_attribute3 in varchar2 default hr_api.g_varchar2
431: ,p_oipl_id in number default hr_api.g_number
432: ,p_pl_id in number default hr_api.g_number
433: ,p_comp_lvl_fctr_id in number default hr_api.g_number
434: ,p_business_group_id in number default hr_api.g_number
435: ,p_apr_attribute_category in varchar2 default hr_api.g_varchar2
436: ,p_apr_attribute1 in varchar2 default hr_api.g_varchar2
437: ,p_apr_attribute2 in varchar2 default hr_api.g_varchar2
438: ,p_apr_attribute3 in varchar2 default hr_api.g_varchar2
439: ,p_apr_attribute4 in varchar2 default hr_api.g_varchar2
432: ,p_pl_id in number default hr_api.g_number
433: ,p_comp_lvl_fctr_id in number default hr_api.g_number
434: ,p_business_group_id in number default hr_api.g_number
435: ,p_apr_attribute_category in varchar2 default hr_api.g_varchar2
436: ,p_apr_attribute1 in varchar2 default hr_api.g_varchar2
437: ,p_apr_attribute2 in varchar2 default hr_api.g_varchar2
438: ,p_apr_attribute3 in varchar2 default hr_api.g_varchar2
439: ,p_apr_attribute4 in varchar2 default hr_api.g_varchar2
440: ,p_apr_attribute5 in varchar2 default hr_api.g_varchar2
433: ,p_comp_lvl_fctr_id in number default hr_api.g_number
434: ,p_business_group_id in number default hr_api.g_number
435: ,p_apr_attribute_category in varchar2 default hr_api.g_varchar2
436: ,p_apr_attribute1 in varchar2 default hr_api.g_varchar2
437: ,p_apr_attribute2 in varchar2 default hr_api.g_varchar2
438: ,p_apr_attribute3 in varchar2 default hr_api.g_varchar2
439: ,p_apr_attribute4 in varchar2 default hr_api.g_varchar2
440: ,p_apr_attribute5 in varchar2 default hr_api.g_varchar2
441: ,p_apr_attribute6 in varchar2 default hr_api.g_varchar2
434: ,p_business_group_id in number default hr_api.g_number
435: ,p_apr_attribute_category in varchar2 default hr_api.g_varchar2
436: ,p_apr_attribute1 in varchar2 default hr_api.g_varchar2
437: ,p_apr_attribute2 in varchar2 default hr_api.g_varchar2
438: ,p_apr_attribute3 in varchar2 default hr_api.g_varchar2
439: ,p_apr_attribute4 in varchar2 default hr_api.g_varchar2
440: ,p_apr_attribute5 in varchar2 default hr_api.g_varchar2
441: ,p_apr_attribute6 in varchar2 default hr_api.g_varchar2
442: ,p_apr_attribute7 in varchar2 default hr_api.g_varchar2
435: ,p_apr_attribute_category in varchar2 default hr_api.g_varchar2
436: ,p_apr_attribute1 in varchar2 default hr_api.g_varchar2
437: ,p_apr_attribute2 in varchar2 default hr_api.g_varchar2
438: ,p_apr_attribute3 in varchar2 default hr_api.g_varchar2
439: ,p_apr_attribute4 in varchar2 default hr_api.g_varchar2
440: ,p_apr_attribute5 in varchar2 default hr_api.g_varchar2
441: ,p_apr_attribute6 in varchar2 default hr_api.g_varchar2
442: ,p_apr_attribute7 in varchar2 default hr_api.g_varchar2
443: ,p_apr_attribute8 in varchar2 default hr_api.g_varchar2
436: ,p_apr_attribute1 in varchar2 default hr_api.g_varchar2
437: ,p_apr_attribute2 in varchar2 default hr_api.g_varchar2
438: ,p_apr_attribute3 in varchar2 default hr_api.g_varchar2
439: ,p_apr_attribute4 in varchar2 default hr_api.g_varchar2
440: ,p_apr_attribute5 in varchar2 default hr_api.g_varchar2
441: ,p_apr_attribute6 in varchar2 default hr_api.g_varchar2
442: ,p_apr_attribute7 in varchar2 default hr_api.g_varchar2
443: ,p_apr_attribute8 in varchar2 default hr_api.g_varchar2
444: ,p_apr_attribute9 in varchar2 default hr_api.g_varchar2
437: ,p_apr_attribute2 in varchar2 default hr_api.g_varchar2
438: ,p_apr_attribute3 in varchar2 default hr_api.g_varchar2
439: ,p_apr_attribute4 in varchar2 default hr_api.g_varchar2
440: ,p_apr_attribute5 in varchar2 default hr_api.g_varchar2
441: ,p_apr_attribute6 in varchar2 default hr_api.g_varchar2
442: ,p_apr_attribute7 in varchar2 default hr_api.g_varchar2
443: ,p_apr_attribute8 in varchar2 default hr_api.g_varchar2
444: ,p_apr_attribute9 in varchar2 default hr_api.g_varchar2
445: ,p_apr_attribute10 in varchar2 default hr_api.g_varchar2
438: ,p_apr_attribute3 in varchar2 default hr_api.g_varchar2
439: ,p_apr_attribute4 in varchar2 default hr_api.g_varchar2
440: ,p_apr_attribute5 in varchar2 default hr_api.g_varchar2
441: ,p_apr_attribute6 in varchar2 default hr_api.g_varchar2
442: ,p_apr_attribute7 in varchar2 default hr_api.g_varchar2
443: ,p_apr_attribute8 in varchar2 default hr_api.g_varchar2
444: ,p_apr_attribute9 in varchar2 default hr_api.g_varchar2
445: ,p_apr_attribute10 in varchar2 default hr_api.g_varchar2
446: ,p_apr_attribute11 in varchar2 default hr_api.g_varchar2
439: ,p_apr_attribute4 in varchar2 default hr_api.g_varchar2
440: ,p_apr_attribute5 in varchar2 default hr_api.g_varchar2
441: ,p_apr_attribute6 in varchar2 default hr_api.g_varchar2
442: ,p_apr_attribute7 in varchar2 default hr_api.g_varchar2
443: ,p_apr_attribute8 in varchar2 default hr_api.g_varchar2
444: ,p_apr_attribute9 in varchar2 default hr_api.g_varchar2
445: ,p_apr_attribute10 in varchar2 default hr_api.g_varchar2
446: ,p_apr_attribute11 in varchar2 default hr_api.g_varchar2
447: ,p_apr_attribute12 in varchar2 default hr_api.g_varchar2
440: ,p_apr_attribute5 in varchar2 default hr_api.g_varchar2
441: ,p_apr_attribute6 in varchar2 default hr_api.g_varchar2
442: ,p_apr_attribute7 in varchar2 default hr_api.g_varchar2
443: ,p_apr_attribute8 in varchar2 default hr_api.g_varchar2
444: ,p_apr_attribute9 in varchar2 default hr_api.g_varchar2
445: ,p_apr_attribute10 in varchar2 default hr_api.g_varchar2
446: ,p_apr_attribute11 in varchar2 default hr_api.g_varchar2
447: ,p_apr_attribute12 in varchar2 default hr_api.g_varchar2
448: ,p_apr_attribute13 in varchar2 default hr_api.g_varchar2
441: ,p_apr_attribute6 in varchar2 default hr_api.g_varchar2
442: ,p_apr_attribute7 in varchar2 default hr_api.g_varchar2
443: ,p_apr_attribute8 in varchar2 default hr_api.g_varchar2
444: ,p_apr_attribute9 in varchar2 default hr_api.g_varchar2
445: ,p_apr_attribute10 in varchar2 default hr_api.g_varchar2
446: ,p_apr_attribute11 in varchar2 default hr_api.g_varchar2
447: ,p_apr_attribute12 in varchar2 default hr_api.g_varchar2
448: ,p_apr_attribute13 in varchar2 default hr_api.g_varchar2
449: ,p_apr_attribute14 in varchar2 default hr_api.g_varchar2
442: ,p_apr_attribute7 in varchar2 default hr_api.g_varchar2
443: ,p_apr_attribute8 in varchar2 default hr_api.g_varchar2
444: ,p_apr_attribute9 in varchar2 default hr_api.g_varchar2
445: ,p_apr_attribute10 in varchar2 default hr_api.g_varchar2
446: ,p_apr_attribute11 in varchar2 default hr_api.g_varchar2
447: ,p_apr_attribute12 in varchar2 default hr_api.g_varchar2
448: ,p_apr_attribute13 in varchar2 default hr_api.g_varchar2
449: ,p_apr_attribute14 in varchar2 default hr_api.g_varchar2
450: ,p_apr_attribute15 in varchar2 default hr_api.g_varchar2
443: ,p_apr_attribute8 in varchar2 default hr_api.g_varchar2
444: ,p_apr_attribute9 in varchar2 default hr_api.g_varchar2
445: ,p_apr_attribute10 in varchar2 default hr_api.g_varchar2
446: ,p_apr_attribute11 in varchar2 default hr_api.g_varchar2
447: ,p_apr_attribute12 in varchar2 default hr_api.g_varchar2
448: ,p_apr_attribute13 in varchar2 default hr_api.g_varchar2
449: ,p_apr_attribute14 in varchar2 default hr_api.g_varchar2
450: ,p_apr_attribute15 in varchar2 default hr_api.g_varchar2
451: ,p_apr_attribute16 in varchar2 default hr_api.g_varchar2
444: ,p_apr_attribute9 in varchar2 default hr_api.g_varchar2
445: ,p_apr_attribute10 in varchar2 default hr_api.g_varchar2
446: ,p_apr_attribute11 in varchar2 default hr_api.g_varchar2
447: ,p_apr_attribute12 in varchar2 default hr_api.g_varchar2
448: ,p_apr_attribute13 in varchar2 default hr_api.g_varchar2
449: ,p_apr_attribute14 in varchar2 default hr_api.g_varchar2
450: ,p_apr_attribute15 in varchar2 default hr_api.g_varchar2
451: ,p_apr_attribute16 in varchar2 default hr_api.g_varchar2
452: ,p_apr_attribute17 in varchar2 default hr_api.g_varchar2
445: ,p_apr_attribute10 in varchar2 default hr_api.g_varchar2
446: ,p_apr_attribute11 in varchar2 default hr_api.g_varchar2
447: ,p_apr_attribute12 in varchar2 default hr_api.g_varchar2
448: ,p_apr_attribute13 in varchar2 default hr_api.g_varchar2
449: ,p_apr_attribute14 in varchar2 default hr_api.g_varchar2
450: ,p_apr_attribute15 in varchar2 default hr_api.g_varchar2
451: ,p_apr_attribute16 in varchar2 default hr_api.g_varchar2
452: ,p_apr_attribute17 in varchar2 default hr_api.g_varchar2
453: ,p_apr_attribute18 in varchar2 default hr_api.g_varchar2
446: ,p_apr_attribute11 in varchar2 default hr_api.g_varchar2
447: ,p_apr_attribute12 in varchar2 default hr_api.g_varchar2
448: ,p_apr_attribute13 in varchar2 default hr_api.g_varchar2
449: ,p_apr_attribute14 in varchar2 default hr_api.g_varchar2
450: ,p_apr_attribute15 in varchar2 default hr_api.g_varchar2
451: ,p_apr_attribute16 in varchar2 default hr_api.g_varchar2
452: ,p_apr_attribute17 in varchar2 default hr_api.g_varchar2
453: ,p_apr_attribute18 in varchar2 default hr_api.g_varchar2
454: ,p_apr_attribute19 in varchar2 default hr_api.g_varchar2
447: ,p_apr_attribute12 in varchar2 default hr_api.g_varchar2
448: ,p_apr_attribute13 in varchar2 default hr_api.g_varchar2
449: ,p_apr_attribute14 in varchar2 default hr_api.g_varchar2
450: ,p_apr_attribute15 in varchar2 default hr_api.g_varchar2
451: ,p_apr_attribute16 in varchar2 default hr_api.g_varchar2
452: ,p_apr_attribute17 in varchar2 default hr_api.g_varchar2
453: ,p_apr_attribute18 in varchar2 default hr_api.g_varchar2
454: ,p_apr_attribute19 in varchar2 default hr_api.g_varchar2
455: ,p_apr_attribute20 in varchar2 default hr_api.g_varchar2
448: ,p_apr_attribute13 in varchar2 default hr_api.g_varchar2
449: ,p_apr_attribute14 in varchar2 default hr_api.g_varchar2
450: ,p_apr_attribute15 in varchar2 default hr_api.g_varchar2
451: ,p_apr_attribute16 in varchar2 default hr_api.g_varchar2
452: ,p_apr_attribute17 in varchar2 default hr_api.g_varchar2
453: ,p_apr_attribute18 in varchar2 default hr_api.g_varchar2
454: ,p_apr_attribute19 in varchar2 default hr_api.g_varchar2
455: ,p_apr_attribute20 in varchar2 default hr_api.g_varchar2
456: ,p_apr_attribute21 in varchar2 default hr_api.g_varchar2
449: ,p_apr_attribute14 in varchar2 default hr_api.g_varchar2
450: ,p_apr_attribute15 in varchar2 default hr_api.g_varchar2
451: ,p_apr_attribute16 in varchar2 default hr_api.g_varchar2
452: ,p_apr_attribute17 in varchar2 default hr_api.g_varchar2
453: ,p_apr_attribute18 in varchar2 default hr_api.g_varchar2
454: ,p_apr_attribute19 in varchar2 default hr_api.g_varchar2
455: ,p_apr_attribute20 in varchar2 default hr_api.g_varchar2
456: ,p_apr_attribute21 in varchar2 default hr_api.g_varchar2
457: ,p_apr_attribute22 in varchar2 default hr_api.g_varchar2
450: ,p_apr_attribute15 in varchar2 default hr_api.g_varchar2
451: ,p_apr_attribute16 in varchar2 default hr_api.g_varchar2
452: ,p_apr_attribute17 in varchar2 default hr_api.g_varchar2
453: ,p_apr_attribute18 in varchar2 default hr_api.g_varchar2
454: ,p_apr_attribute19 in varchar2 default hr_api.g_varchar2
455: ,p_apr_attribute20 in varchar2 default hr_api.g_varchar2
456: ,p_apr_attribute21 in varchar2 default hr_api.g_varchar2
457: ,p_apr_attribute22 in varchar2 default hr_api.g_varchar2
458: ,p_apr_attribute23 in varchar2 default hr_api.g_varchar2
451: ,p_apr_attribute16 in varchar2 default hr_api.g_varchar2
452: ,p_apr_attribute17 in varchar2 default hr_api.g_varchar2
453: ,p_apr_attribute18 in varchar2 default hr_api.g_varchar2
454: ,p_apr_attribute19 in varchar2 default hr_api.g_varchar2
455: ,p_apr_attribute20 in varchar2 default hr_api.g_varchar2
456: ,p_apr_attribute21 in varchar2 default hr_api.g_varchar2
457: ,p_apr_attribute22 in varchar2 default hr_api.g_varchar2
458: ,p_apr_attribute23 in varchar2 default hr_api.g_varchar2
459: ,p_apr_attribute24 in varchar2 default hr_api.g_varchar2
452: ,p_apr_attribute17 in varchar2 default hr_api.g_varchar2
453: ,p_apr_attribute18 in varchar2 default hr_api.g_varchar2
454: ,p_apr_attribute19 in varchar2 default hr_api.g_varchar2
455: ,p_apr_attribute20 in varchar2 default hr_api.g_varchar2
456: ,p_apr_attribute21 in varchar2 default hr_api.g_varchar2
457: ,p_apr_attribute22 in varchar2 default hr_api.g_varchar2
458: ,p_apr_attribute23 in varchar2 default hr_api.g_varchar2
459: ,p_apr_attribute24 in varchar2 default hr_api.g_varchar2
460: ,p_apr_attribute25 in varchar2 default hr_api.g_varchar2
453: ,p_apr_attribute18 in varchar2 default hr_api.g_varchar2
454: ,p_apr_attribute19 in varchar2 default hr_api.g_varchar2
455: ,p_apr_attribute20 in varchar2 default hr_api.g_varchar2
456: ,p_apr_attribute21 in varchar2 default hr_api.g_varchar2
457: ,p_apr_attribute22 in varchar2 default hr_api.g_varchar2
458: ,p_apr_attribute23 in varchar2 default hr_api.g_varchar2
459: ,p_apr_attribute24 in varchar2 default hr_api.g_varchar2
460: ,p_apr_attribute25 in varchar2 default hr_api.g_varchar2
461: ,p_apr_attribute26 in varchar2 default hr_api.g_varchar2
454: ,p_apr_attribute19 in varchar2 default hr_api.g_varchar2
455: ,p_apr_attribute20 in varchar2 default hr_api.g_varchar2
456: ,p_apr_attribute21 in varchar2 default hr_api.g_varchar2
457: ,p_apr_attribute22 in varchar2 default hr_api.g_varchar2
458: ,p_apr_attribute23 in varchar2 default hr_api.g_varchar2
459: ,p_apr_attribute24 in varchar2 default hr_api.g_varchar2
460: ,p_apr_attribute25 in varchar2 default hr_api.g_varchar2
461: ,p_apr_attribute26 in varchar2 default hr_api.g_varchar2
462: ,p_apr_attribute27 in varchar2 default hr_api.g_varchar2
455: ,p_apr_attribute20 in varchar2 default hr_api.g_varchar2
456: ,p_apr_attribute21 in varchar2 default hr_api.g_varchar2
457: ,p_apr_attribute22 in varchar2 default hr_api.g_varchar2
458: ,p_apr_attribute23 in varchar2 default hr_api.g_varchar2
459: ,p_apr_attribute24 in varchar2 default hr_api.g_varchar2
460: ,p_apr_attribute25 in varchar2 default hr_api.g_varchar2
461: ,p_apr_attribute26 in varchar2 default hr_api.g_varchar2
462: ,p_apr_attribute27 in varchar2 default hr_api.g_varchar2
463: ,p_apr_attribute28 in varchar2 default hr_api.g_varchar2
456: ,p_apr_attribute21 in varchar2 default hr_api.g_varchar2
457: ,p_apr_attribute22 in varchar2 default hr_api.g_varchar2
458: ,p_apr_attribute23 in varchar2 default hr_api.g_varchar2
459: ,p_apr_attribute24 in varchar2 default hr_api.g_varchar2
460: ,p_apr_attribute25 in varchar2 default hr_api.g_varchar2
461: ,p_apr_attribute26 in varchar2 default hr_api.g_varchar2
462: ,p_apr_attribute27 in varchar2 default hr_api.g_varchar2
463: ,p_apr_attribute28 in varchar2 default hr_api.g_varchar2
464: ,p_apr_attribute29 in varchar2 default hr_api.g_varchar2
457: ,p_apr_attribute22 in varchar2 default hr_api.g_varchar2
458: ,p_apr_attribute23 in varchar2 default hr_api.g_varchar2
459: ,p_apr_attribute24 in varchar2 default hr_api.g_varchar2
460: ,p_apr_attribute25 in varchar2 default hr_api.g_varchar2
461: ,p_apr_attribute26 in varchar2 default hr_api.g_varchar2
462: ,p_apr_attribute27 in varchar2 default hr_api.g_varchar2
463: ,p_apr_attribute28 in varchar2 default hr_api.g_varchar2
464: ,p_apr_attribute29 in varchar2 default hr_api.g_varchar2
465: ,p_apr_attribute30 in varchar2 default hr_api.g_varchar2
458: ,p_apr_attribute23 in varchar2 default hr_api.g_varchar2
459: ,p_apr_attribute24 in varchar2 default hr_api.g_varchar2
460: ,p_apr_attribute25 in varchar2 default hr_api.g_varchar2
461: ,p_apr_attribute26 in varchar2 default hr_api.g_varchar2
462: ,p_apr_attribute27 in varchar2 default hr_api.g_varchar2
463: ,p_apr_attribute28 in varchar2 default hr_api.g_varchar2
464: ,p_apr_attribute29 in varchar2 default hr_api.g_varchar2
465: ,p_apr_attribute30 in varchar2 default hr_api.g_varchar2
466: ,p_object_version_number in out nocopy number
459: ,p_apr_attribute24 in varchar2 default hr_api.g_varchar2
460: ,p_apr_attribute25 in varchar2 default hr_api.g_varchar2
461: ,p_apr_attribute26 in varchar2 default hr_api.g_varchar2
462: ,p_apr_attribute27 in varchar2 default hr_api.g_varchar2
463: ,p_apr_attribute28 in varchar2 default hr_api.g_varchar2
464: ,p_apr_attribute29 in varchar2 default hr_api.g_varchar2
465: ,p_apr_attribute30 in varchar2 default hr_api.g_varchar2
466: ,p_object_version_number in out nocopy number
467: ,p_prtl_mo_det_mthd_cd in varchar2 default hr_api.g_varchar2
460: ,p_apr_attribute25 in varchar2 default hr_api.g_varchar2
461: ,p_apr_attribute26 in varchar2 default hr_api.g_varchar2
462: ,p_apr_attribute27 in varchar2 default hr_api.g_varchar2
463: ,p_apr_attribute28 in varchar2 default hr_api.g_varchar2
464: ,p_apr_attribute29 in varchar2 default hr_api.g_varchar2
465: ,p_apr_attribute30 in varchar2 default hr_api.g_varchar2
466: ,p_object_version_number in out nocopy number
467: ,p_prtl_mo_det_mthd_cd in varchar2 default hr_api.g_varchar2
468: ,p_prtl_mo_det_mthd_rl in number default hr_api.g_number
461: ,p_apr_attribute26 in varchar2 default hr_api.g_varchar2
462: ,p_apr_attribute27 in varchar2 default hr_api.g_varchar2
463: ,p_apr_attribute28 in varchar2 default hr_api.g_varchar2
464: ,p_apr_attribute29 in varchar2 default hr_api.g_varchar2
465: ,p_apr_attribute30 in varchar2 default hr_api.g_varchar2
466: ,p_object_version_number in out nocopy number
467: ,p_prtl_mo_det_mthd_cd in varchar2 default hr_api.g_varchar2
468: ,p_prtl_mo_det_mthd_rl in number default hr_api.g_number
469: ,p_wsh_rl_dy_mo_num in number default hr_api.g_number
463: ,p_apr_attribute28 in varchar2 default hr_api.g_varchar2
464: ,p_apr_attribute29 in varchar2 default hr_api.g_varchar2
465: ,p_apr_attribute30 in varchar2 default hr_api.g_varchar2
466: ,p_object_version_number in out nocopy number
467: ,p_prtl_mo_det_mthd_cd in varchar2 default hr_api.g_varchar2
468: ,p_prtl_mo_det_mthd_rl in number default hr_api.g_number
469: ,p_wsh_rl_dy_mo_num in number default hr_api.g_number
470: ,p_vrbl_rt_add_on_calc_rl in number default hr_api.g_number
471: ,p_effective_date in date
464: ,p_apr_attribute29 in varchar2 default hr_api.g_varchar2
465: ,p_apr_attribute30 in varchar2 default hr_api.g_varchar2
466: ,p_object_version_number in out nocopy number
467: ,p_prtl_mo_det_mthd_cd in varchar2 default hr_api.g_varchar2
468: ,p_prtl_mo_det_mthd_rl in number default hr_api.g_number
469: ,p_wsh_rl_dy_mo_num in number default hr_api.g_number
470: ,p_vrbl_rt_add_on_calc_rl in number default hr_api.g_number
471: ,p_effective_date in date
472: ,p_datetrack_mode in varchar2
465: ,p_apr_attribute30 in varchar2 default hr_api.g_varchar2
466: ,p_object_version_number in out nocopy number
467: ,p_prtl_mo_det_mthd_cd in varchar2 default hr_api.g_varchar2
468: ,p_prtl_mo_det_mthd_rl in number default hr_api.g_number
469: ,p_wsh_rl_dy_mo_num in number default hr_api.g_number
470: ,p_vrbl_rt_add_on_calc_rl in number default hr_api.g_number
471: ,p_effective_date in date
472: ,p_datetrack_mode in varchar2
473: ) is
466: ,p_object_version_number in out nocopy number
467: ,p_prtl_mo_det_mthd_cd in varchar2 default hr_api.g_varchar2
468: ,p_prtl_mo_det_mthd_rl in number default hr_api.g_number
469: ,p_wsh_rl_dy_mo_num in number default hr_api.g_number
470: ,p_vrbl_rt_add_on_calc_rl in number default hr_api.g_number
471: ,p_effective_date in date
472: ,p_datetrack_mode in varchar2
473: ) is
474: --
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_actual_premium'
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_actual_premium'
577: ,p_hook_type => 'BP'
578: );
579: --
732: ,p_effective_date => trunc(p_effective_date)
733: ,p_datetrack_mode => p_datetrack_mode
734: );
735: exception
736: when hr_api.cannot_find_prog_unit then
737: hr_api.cannot_find_prog_unit_error
738: (p_module_name => 'UPDATE_actual_premium'
739: ,p_hook_type => 'AP'
740: );
733: ,p_datetrack_mode => p_datetrack_mode
734: );
735: exception
736: when hr_api.cannot_find_prog_unit then
737: hr_api.cannot_find_prog_unit_error
738: (p_module_name => 'UPDATE_actual_premium'
739: ,p_hook_type => 'AP'
740: );
741: --
747: --
748: -- When in validation only mode raise the Validate_Enabled exception
749: --
750: if p_validate then
751: raise hr_api.validate_enabled;
752: end if;
753: --
754: -- Set all output arguments
755: --
760: hr_utility.set_location(' Leaving:'||l_proc, 70);
761: --
762: exception
763: --
764: when hr_api.validate_enabled then
765: --
766: -- As the Validate_Enabled exception has been raised
767: -- we must rollback to the savepoint
768: --
834: ,p_effective_date => trunc(p_effective_date)
835: ,p_datetrack_mode => p_datetrack_mode
836: );
837: exception
838: when hr_api.cannot_find_prog_unit then
839: hr_api.cannot_find_prog_unit_error
840: (p_module_name => 'DELETE_actual_premium'
841: ,p_hook_type => 'BP'
842: );
835: ,p_datetrack_mode => p_datetrack_mode
836: );
837: exception
838: when hr_api.cannot_find_prog_unit then
839: hr_api.cannot_find_prog_unit_error
840: (p_module_name => 'DELETE_actual_premium'
841: ,p_hook_type => 'BP'
842: );
843: --
868: ,p_effective_date => trunc(p_effective_date)
869: ,p_datetrack_mode => p_datetrack_mode
870: );
871: exception
872: when hr_api.cannot_find_prog_unit then
873: hr_api.cannot_find_prog_unit_error
874: (p_module_name => 'DELETE_actual_premium'
875: ,p_hook_type => 'AP'
876: );
869: ,p_datetrack_mode => p_datetrack_mode
870: );
871: exception
872: when hr_api.cannot_find_prog_unit then
873: hr_api.cannot_find_prog_unit_error
874: (p_module_name => 'DELETE_actual_premium'
875: ,p_hook_type => 'AP'
876: );
877: --
883: --
884: -- When in validation only mode raise the Validate_Enabled exception
885: --
886: if p_validate then
887: raise hr_api.validate_enabled;
888: end if;
889: --
890: hr_utility.set_location(' Leaving:'||l_proc, 70);
891: --
890: hr_utility.set_location(' Leaving:'||l_proc, 70);
891: --
892: exception
893: --
894: when hr_api.validate_enabled then
895: --
896: -- As the Validate_Enabled exception has been raised
897: -- we must rollback to the savepoint
898: --