eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_PRTT_RT_VAL_API dependencies on HR_API

Line 376: ,p_new_rt_end_dt => hr_api.g_eot);

372: (p_acty_base_rt_id => p_acty_base_rt_id
373: ,p_prtt_rt_val_id => null
374: ,p_prtt_enrt_rslt_id => p_prtt_enrt_rslt_id
375: ,p_new_rt_strt_dt => p_rt_strt_dt
376: ,p_new_rt_end_dt => hr_api.g_eot);
377:
378: end if;
379: --
380: -- Process Logic

Line 454: when hr_api.cannot_find_prog_unit then

450: ,p_pk_id => p_pk_id
451: ,p_effective_date => trunc(p_effective_date)
452: );
453: exception
454: when hr_api.cannot_find_prog_unit then
455: hr_api.cannot_find_prog_unit_error
456: (
457: p_module_name => 'CREATE_prtt_rt_val'
458: ,p_hook_type => 'BP'

Line 455: hr_api.cannot_find_prog_unit_error

451: ,p_effective_date => trunc(p_effective_date)
452: );
453: exception
454: when hr_api.cannot_find_prog_unit then
455: hr_api.cannot_find_prog_unit_error
456: (
457: p_module_name => 'CREATE_prtt_rt_val'
458: ,p_hook_type => 'BP'
459: );

Line 717: when hr_api.cannot_find_prog_unit then

713: ,p_object_version_number => l_object_version_number
714: ,p_effective_date => trunc(p_effective_date)
715: );
716: exception
717: when hr_api.cannot_find_prog_unit then
718: hr_api.cannot_find_prog_unit_error
719: (p_module_name => 'CREATE_prtt_rt_val'
720: ,p_hook_type => 'AP'
721: );

Line 718: hr_api.cannot_find_prog_unit_error

714: ,p_effective_date => trunc(p_effective_date)
715: );
716: exception
717: when hr_api.cannot_find_prog_unit then
718: hr_api.cannot_find_prog_unit_error
719: (p_module_name => 'CREATE_prtt_rt_val'
720: ,p_hook_type => 'AP'
721: );
722: --

Line 734: raise hr_api.validate_enabled;

730: --
731: -- When in validation only mode raise the Validate_Enabled exception
732: --
733: if p_validate then
734: raise hr_api.validate_enabled;
735: end if;
736: --
737: -- Set all output arguments
738: --

Line 748: when hr_api.validate_enabled then

744: end if;
745: --
746: exception
747: --
748: when hr_api.validate_enabled then
749: --
750: -- As the Validate_Enabled exception has been raised
751: -- we must rollback to the savepoint
752: --

Line 782: ,p_person_id in number default hr_api.g_number

778: --
779: procedure update_prtt_rt_val
780: (p_validate in boolean default false
781: ,p_prtt_rt_val_id in number
782: ,p_person_id in number default hr_api.g_number
783: ,p_input_value_id in number default hr_api.g_number
784: ,p_element_type_id in number default hr_api.g_number
785: ,p_enrt_rt_id in number default hr_api.g_number
786: ,p_rt_strt_dt in date default hr_api.g_date

Line 783: ,p_input_value_id in number default hr_api.g_number

779: procedure update_prtt_rt_val
780: (p_validate in boolean default false
781: ,p_prtt_rt_val_id in number
782: ,p_person_id in number default hr_api.g_number
783: ,p_input_value_id in number default hr_api.g_number
784: ,p_element_type_id in number default hr_api.g_number
785: ,p_enrt_rt_id in number default hr_api.g_number
786: ,p_rt_strt_dt in date default hr_api.g_date
787: ,p_rt_end_dt in date default hr_api.g_date

Line 784: ,p_element_type_id in number default hr_api.g_number

780: (p_validate in boolean default false
781: ,p_prtt_rt_val_id in number
782: ,p_person_id in number default hr_api.g_number
783: ,p_input_value_id in number default hr_api.g_number
784: ,p_element_type_id in number default hr_api.g_number
785: ,p_enrt_rt_id in number default hr_api.g_number
786: ,p_rt_strt_dt in date default hr_api.g_date
787: ,p_rt_end_dt in date default hr_api.g_date
788: ,p_rt_typ_cd in varchar2 default hr_api.g_varchar2

Line 785: ,p_enrt_rt_id in number default hr_api.g_number

781: ,p_prtt_rt_val_id in number
782: ,p_person_id in number default hr_api.g_number
783: ,p_input_value_id in number default hr_api.g_number
784: ,p_element_type_id in number default hr_api.g_number
785: ,p_enrt_rt_id in number default hr_api.g_number
786: ,p_rt_strt_dt in date default hr_api.g_date
787: ,p_rt_end_dt in date default hr_api.g_date
788: ,p_rt_typ_cd in varchar2 default hr_api.g_varchar2
789: ,p_tx_typ_cd in varchar2 default hr_api.g_varchar2

Line 786: ,p_rt_strt_dt in date default hr_api.g_date

782: ,p_person_id in number default hr_api.g_number
783: ,p_input_value_id in number default hr_api.g_number
784: ,p_element_type_id in number default hr_api.g_number
785: ,p_enrt_rt_id in number default hr_api.g_number
786: ,p_rt_strt_dt in date default hr_api.g_date
787: ,p_rt_end_dt in date default hr_api.g_date
788: ,p_rt_typ_cd in varchar2 default hr_api.g_varchar2
789: ,p_tx_typ_cd in varchar2 default hr_api.g_varchar2
790: ,p_ordr_num in number default hr_api.g_number

Line 787: ,p_rt_end_dt in date default hr_api.g_date

783: ,p_input_value_id in number default hr_api.g_number
784: ,p_element_type_id in number default hr_api.g_number
785: ,p_enrt_rt_id in number default hr_api.g_number
786: ,p_rt_strt_dt in date default hr_api.g_date
787: ,p_rt_end_dt in date default hr_api.g_date
788: ,p_rt_typ_cd in varchar2 default hr_api.g_varchar2
789: ,p_tx_typ_cd in varchar2 default hr_api.g_varchar2
790: ,p_ordr_num in number default hr_api.g_number
791: ,p_acty_typ_cd in varchar2 default hr_api.g_varchar2

Line 788: ,p_rt_typ_cd in varchar2 default hr_api.g_varchar2

784: ,p_element_type_id in number default hr_api.g_number
785: ,p_enrt_rt_id in number default hr_api.g_number
786: ,p_rt_strt_dt in date default hr_api.g_date
787: ,p_rt_end_dt in date default hr_api.g_date
788: ,p_rt_typ_cd in varchar2 default hr_api.g_varchar2
789: ,p_tx_typ_cd in varchar2 default hr_api.g_varchar2
790: ,p_ordr_num in number default hr_api.g_number
791: ,p_acty_typ_cd in varchar2 default hr_api.g_varchar2
792: ,p_mlt_cd in varchar2 default hr_api.g_varchar2

Line 789: ,p_tx_typ_cd in varchar2 default hr_api.g_varchar2

785: ,p_enrt_rt_id in number default hr_api.g_number
786: ,p_rt_strt_dt in date default hr_api.g_date
787: ,p_rt_end_dt in date default hr_api.g_date
788: ,p_rt_typ_cd in varchar2 default hr_api.g_varchar2
789: ,p_tx_typ_cd in varchar2 default hr_api.g_varchar2
790: ,p_ordr_num in number default hr_api.g_number
791: ,p_acty_typ_cd in varchar2 default hr_api.g_varchar2
792: ,p_mlt_cd in varchar2 default hr_api.g_varchar2
793: ,p_acty_ref_perd_cd in varchar2 default hr_api.g_varchar2

Line 790: ,p_ordr_num in number default hr_api.g_number

786: ,p_rt_strt_dt in date default hr_api.g_date
787: ,p_rt_end_dt in date default hr_api.g_date
788: ,p_rt_typ_cd in varchar2 default hr_api.g_varchar2
789: ,p_tx_typ_cd in varchar2 default hr_api.g_varchar2
790: ,p_ordr_num in number default hr_api.g_number
791: ,p_acty_typ_cd in varchar2 default hr_api.g_varchar2
792: ,p_mlt_cd in varchar2 default hr_api.g_varchar2
793: ,p_acty_ref_perd_cd in varchar2 default hr_api.g_varchar2
794: ,p_rt_val in number default hr_api.g_number

Line 791: ,p_acty_typ_cd in varchar2 default hr_api.g_varchar2

787: ,p_rt_end_dt in date default hr_api.g_date
788: ,p_rt_typ_cd in varchar2 default hr_api.g_varchar2
789: ,p_tx_typ_cd in varchar2 default hr_api.g_varchar2
790: ,p_ordr_num in number default hr_api.g_number
791: ,p_acty_typ_cd in varchar2 default hr_api.g_varchar2
792: ,p_mlt_cd in varchar2 default hr_api.g_varchar2
793: ,p_acty_ref_perd_cd in varchar2 default hr_api.g_varchar2
794: ,p_rt_val in number default hr_api.g_number
795: ,p_ann_rt_val in number default hr_api.g_number

Line 792: ,p_mlt_cd in varchar2 default hr_api.g_varchar2

788: ,p_rt_typ_cd in varchar2 default hr_api.g_varchar2
789: ,p_tx_typ_cd in varchar2 default hr_api.g_varchar2
790: ,p_ordr_num in number default hr_api.g_number
791: ,p_acty_typ_cd in varchar2 default hr_api.g_varchar2
792: ,p_mlt_cd in varchar2 default hr_api.g_varchar2
793: ,p_acty_ref_perd_cd in varchar2 default hr_api.g_varchar2
794: ,p_rt_val in number default hr_api.g_number
795: ,p_ann_rt_val in number default hr_api.g_number
796: ,p_cmcd_rt_val in number default hr_api.g_number

Line 793: ,p_acty_ref_perd_cd in varchar2 default hr_api.g_varchar2

789: ,p_tx_typ_cd in varchar2 default hr_api.g_varchar2
790: ,p_ordr_num in number default hr_api.g_number
791: ,p_acty_typ_cd in varchar2 default hr_api.g_varchar2
792: ,p_mlt_cd in varchar2 default hr_api.g_varchar2
793: ,p_acty_ref_perd_cd in varchar2 default hr_api.g_varchar2
794: ,p_rt_val in number default hr_api.g_number
795: ,p_ann_rt_val in number default hr_api.g_number
796: ,p_cmcd_rt_val in number default hr_api.g_number
797: ,p_cmcd_ref_perd_cd in varchar2 default hr_api.g_varchar2

Line 794: ,p_rt_val in number default hr_api.g_number

790: ,p_ordr_num in number default hr_api.g_number
791: ,p_acty_typ_cd in varchar2 default hr_api.g_varchar2
792: ,p_mlt_cd in varchar2 default hr_api.g_varchar2
793: ,p_acty_ref_perd_cd in varchar2 default hr_api.g_varchar2
794: ,p_rt_val in number default hr_api.g_number
795: ,p_ann_rt_val in number default hr_api.g_number
796: ,p_cmcd_rt_val in number default hr_api.g_number
797: ,p_cmcd_ref_perd_cd in varchar2 default hr_api.g_varchar2
798: ,p_bnft_rt_typ_cd in varchar2 default hr_api.g_varchar2

Line 795: ,p_ann_rt_val in number default hr_api.g_number

791: ,p_acty_typ_cd in varchar2 default hr_api.g_varchar2
792: ,p_mlt_cd in varchar2 default hr_api.g_varchar2
793: ,p_acty_ref_perd_cd in varchar2 default hr_api.g_varchar2
794: ,p_rt_val in number default hr_api.g_number
795: ,p_ann_rt_val in number default hr_api.g_number
796: ,p_cmcd_rt_val in number default hr_api.g_number
797: ,p_cmcd_ref_perd_cd in varchar2 default hr_api.g_varchar2
798: ,p_bnft_rt_typ_cd in varchar2 default hr_api.g_varchar2
799: ,p_dsply_on_enrt_flag in varchar2 default hr_api.g_varchar2

Line 796: ,p_cmcd_rt_val in number default hr_api.g_number

792: ,p_mlt_cd in varchar2 default hr_api.g_varchar2
793: ,p_acty_ref_perd_cd in varchar2 default hr_api.g_varchar2
794: ,p_rt_val in number default hr_api.g_number
795: ,p_ann_rt_val in number default hr_api.g_number
796: ,p_cmcd_rt_val in number default hr_api.g_number
797: ,p_cmcd_ref_perd_cd in varchar2 default hr_api.g_varchar2
798: ,p_bnft_rt_typ_cd in varchar2 default hr_api.g_varchar2
799: ,p_dsply_on_enrt_flag in varchar2 default hr_api.g_varchar2
800: ,p_rt_ovridn_flag in varchar2 default hr_api.g_varchar2

Line 797: ,p_cmcd_ref_perd_cd in varchar2 default hr_api.g_varchar2

793: ,p_acty_ref_perd_cd in varchar2 default hr_api.g_varchar2
794: ,p_rt_val in number default hr_api.g_number
795: ,p_ann_rt_val in number default hr_api.g_number
796: ,p_cmcd_rt_val in number default hr_api.g_number
797: ,p_cmcd_ref_perd_cd in varchar2 default hr_api.g_varchar2
798: ,p_bnft_rt_typ_cd in varchar2 default hr_api.g_varchar2
799: ,p_dsply_on_enrt_flag in varchar2 default hr_api.g_varchar2
800: ,p_rt_ovridn_flag in varchar2 default hr_api.g_varchar2
801: ,p_rt_ovridn_thru_dt in date default hr_api.g_date

Line 798: ,p_bnft_rt_typ_cd in varchar2 default hr_api.g_varchar2

794: ,p_rt_val in number default hr_api.g_number
795: ,p_ann_rt_val in number default hr_api.g_number
796: ,p_cmcd_rt_val in number default hr_api.g_number
797: ,p_cmcd_ref_perd_cd in varchar2 default hr_api.g_varchar2
798: ,p_bnft_rt_typ_cd in varchar2 default hr_api.g_varchar2
799: ,p_dsply_on_enrt_flag in varchar2 default hr_api.g_varchar2
800: ,p_rt_ovridn_flag in varchar2 default hr_api.g_varchar2
801: ,p_rt_ovridn_thru_dt in date default hr_api.g_date
802: ,p_elctns_made_dt in date default hr_api.g_date

Line 799: ,p_dsply_on_enrt_flag in varchar2 default hr_api.g_varchar2

795: ,p_ann_rt_val in number default hr_api.g_number
796: ,p_cmcd_rt_val in number default hr_api.g_number
797: ,p_cmcd_ref_perd_cd in varchar2 default hr_api.g_varchar2
798: ,p_bnft_rt_typ_cd in varchar2 default hr_api.g_varchar2
799: ,p_dsply_on_enrt_flag in varchar2 default hr_api.g_varchar2
800: ,p_rt_ovridn_flag in varchar2 default hr_api.g_varchar2
801: ,p_rt_ovridn_thru_dt in date default hr_api.g_date
802: ,p_elctns_made_dt in date default hr_api.g_date
803: ,p_prtt_rt_val_stat_cd in varchar2 default hr_api.g_varchar2

Line 800: ,p_rt_ovridn_flag in varchar2 default hr_api.g_varchar2

796: ,p_cmcd_rt_val in number default hr_api.g_number
797: ,p_cmcd_ref_perd_cd in varchar2 default hr_api.g_varchar2
798: ,p_bnft_rt_typ_cd in varchar2 default hr_api.g_varchar2
799: ,p_dsply_on_enrt_flag in varchar2 default hr_api.g_varchar2
800: ,p_rt_ovridn_flag in varchar2 default hr_api.g_varchar2
801: ,p_rt_ovridn_thru_dt in date default hr_api.g_date
802: ,p_elctns_made_dt in date default hr_api.g_date
803: ,p_prtt_rt_val_stat_cd in varchar2 default hr_api.g_varchar2
804: ,p_prtt_enrt_rslt_id in number default hr_api.g_number

Line 801: ,p_rt_ovridn_thru_dt in date default hr_api.g_date

797: ,p_cmcd_ref_perd_cd in varchar2 default hr_api.g_varchar2
798: ,p_bnft_rt_typ_cd in varchar2 default hr_api.g_varchar2
799: ,p_dsply_on_enrt_flag in varchar2 default hr_api.g_varchar2
800: ,p_rt_ovridn_flag in varchar2 default hr_api.g_varchar2
801: ,p_rt_ovridn_thru_dt in date default hr_api.g_date
802: ,p_elctns_made_dt in date default hr_api.g_date
803: ,p_prtt_rt_val_stat_cd in varchar2 default hr_api.g_varchar2
804: ,p_prtt_enrt_rslt_id in number default hr_api.g_number
805: ,p_cvg_amt_calc_mthd_id in number default hr_api.g_number

Line 802: ,p_elctns_made_dt in date default hr_api.g_date

798: ,p_bnft_rt_typ_cd in varchar2 default hr_api.g_varchar2
799: ,p_dsply_on_enrt_flag in varchar2 default hr_api.g_varchar2
800: ,p_rt_ovridn_flag in varchar2 default hr_api.g_varchar2
801: ,p_rt_ovridn_thru_dt in date default hr_api.g_date
802: ,p_elctns_made_dt in date default hr_api.g_date
803: ,p_prtt_rt_val_stat_cd in varchar2 default hr_api.g_varchar2
804: ,p_prtt_enrt_rslt_id in number default hr_api.g_number
805: ,p_cvg_amt_calc_mthd_id in number default hr_api.g_number
806: ,p_actl_prem_id in number default hr_api.g_number

Line 803: ,p_prtt_rt_val_stat_cd in varchar2 default hr_api.g_varchar2

799: ,p_dsply_on_enrt_flag in varchar2 default hr_api.g_varchar2
800: ,p_rt_ovridn_flag in varchar2 default hr_api.g_varchar2
801: ,p_rt_ovridn_thru_dt in date default hr_api.g_date
802: ,p_elctns_made_dt in date default hr_api.g_date
803: ,p_prtt_rt_val_stat_cd in varchar2 default hr_api.g_varchar2
804: ,p_prtt_enrt_rslt_id in number default hr_api.g_number
805: ,p_cvg_amt_calc_mthd_id in number default hr_api.g_number
806: ,p_actl_prem_id in number default hr_api.g_number
807: ,p_comp_lvl_fctr_id in number default hr_api.g_number

Line 804: ,p_prtt_enrt_rslt_id in number default hr_api.g_number

800: ,p_rt_ovridn_flag in varchar2 default hr_api.g_varchar2
801: ,p_rt_ovridn_thru_dt in date default hr_api.g_date
802: ,p_elctns_made_dt in date default hr_api.g_date
803: ,p_prtt_rt_val_stat_cd in varchar2 default hr_api.g_varchar2
804: ,p_prtt_enrt_rslt_id in number default hr_api.g_number
805: ,p_cvg_amt_calc_mthd_id in number default hr_api.g_number
806: ,p_actl_prem_id in number default hr_api.g_number
807: ,p_comp_lvl_fctr_id in number default hr_api.g_number
808: ,p_element_entry_value_id in number default hr_api.g_number

Line 805: ,p_cvg_amt_calc_mthd_id in number default hr_api.g_number

801: ,p_rt_ovridn_thru_dt in date default hr_api.g_date
802: ,p_elctns_made_dt in date default hr_api.g_date
803: ,p_prtt_rt_val_stat_cd in varchar2 default hr_api.g_varchar2
804: ,p_prtt_enrt_rslt_id in number default hr_api.g_number
805: ,p_cvg_amt_calc_mthd_id in number default hr_api.g_number
806: ,p_actl_prem_id in number default hr_api.g_number
807: ,p_comp_lvl_fctr_id in number default hr_api.g_number
808: ,p_element_entry_value_id in number default hr_api.g_number
809: ,p_per_in_ler_id in number default hr_api.g_number

Line 806: ,p_actl_prem_id in number default hr_api.g_number

802: ,p_elctns_made_dt in date default hr_api.g_date
803: ,p_prtt_rt_val_stat_cd in varchar2 default hr_api.g_varchar2
804: ,p_prtt_enrt_rslt_id in number default hr_api.g_number
805: ,p_cvg_amt_calc_mthd_id in number default hr_api.g_number
806: ,p_actl_prem_id in number default hr_api.g_number
807: ,p_comp_lvl_fctr_id in number default hr_api.g_number
808: ,p_element_entry_value_id in number default hr_api.g_number
809: ,p_per_in_ler_id in number default hr_api.g_number
810: ,p_ended_per_in_ler_id in number default hr_api.g_number

Line 807: ,p_comp_lvl_fctr_id in number default hr_api.g_number

803: ,p_prtt_rt_val_stat_cd in varchar2 default hr_api.g_varchar2
804: ,p_prtt_enrt_rslt_id in number default hr_api.g_number
805: ,p_cvg_amt_calc_mthd_id in number default hr_api.g_number
806: ,p_actl_prem_id in number default hr_api.g_number
807: ,p_comp_lvl_fctr_id in number default hr_api.g_number
808: ,p_element_entry_value_id in number default hr_api.g_number
809: ,p_per_in_ler_id in number default hr_api.g_number
810: ,p_ended_per_in_ler_id in number default hr_api.g_number
811: ,p_acty_base_rt_id in number default hr_api.g_number

Line 808: ,p_element_entry_value_id in number default hr_api.g_number

804: ,p_prtt_enrt_rslt_id in number default hr_api.g_number
805: ,p_cvg_amt_calc_mthd_id in number default hr_api.g_number
806: ,p_actl_prem_id in number default hr_api.g_number
807: ,p_comp_lvl_fctr_id in number default hr_api.g_number
808: ,p_element_entry_value_id in number default hr_api.g_number
809: ,p_per_in_ler_id in number default hr_api.g_number
810: ,p_ended_per_in_ler_id in number default hr_api.g_number
811: ,p_acty_base_rt_id in number default hr_api.g_number
812: ,p_prtt_reimbmt_rqst_id in number default hr_api.g_number

Line 809: ,p_per_in_ler_id in number default hr_api.g_number

805: ,p_cvg_amt_calc_mthd_id in number default hr_api.g_number
806: ,p_actl_prem_id in number default hr_api.g_number
807: ,p_comp_lvl_fctr_id in number default hr_api.g_number
808: ,p_element_entry_value_id in number default hr_api.g_number
809: ,p_per_in_ler_id in number default hr_api.g_number
810: ,p_ended_per_in_ler_id in number default hr_api.g_number
811: ,p_acty_base_rt_id in number default hr_api.g_number
812: ,p_prtt_reimbmt_rqst_id in number default hr_api.g_number
813: ,p_prtt_rmt_aprvd_fr_pymt_id in number default hr_api.g_number

Line 810: ,p_ended_per_in_ler_id in number default hr_api.g_number

806: ,p_actl_prem_id in number default hr_api.g_number
807: ,p_comp_lvl_fctr_id in number default hr_api.g_number
808: ,p_element_entry_value_id in number default hr_api.g_number
809: ,p_per_in_ler_id in number default hr_api.g_number
810: ,p_ended_per_in_ler_id in number default hr_api.g_number
811: ,p_acty_base_rt_id in number default hr_api.g_number
812: ,p_prtt_reimbmt_rqst_id in number default hr_api.g_number
813: ,p_prtt_rmt_aprvd_fr_pymt_id in number default hr_api.g_number
814: ,p_pp_in_yr_used_num in number default hr_api.g_number

Line 811: ,p_acty_base_rt_id in number default hr_api.g_number

807: ,p_comp_lvl_fctr_id in number default hr_api.g_number
808: ,p_element_entry_value_id in number default hr_api.g_number
809: ,p_per_in_ler_id in number default hr_api.g_number
810: ,p_ended_per_in_ler_id in number default hr_api.g_number
811: ,p_acty_base_rt_id in number default hr_api.g_number
812: ,p_prtt_reimbmt_rqst_id in number default hr_api.g_number
813: ,p_prtt_rmt_aprvd_fr_pymt_id in number default hr_api.g_number
814: ,p_pp_in_yr_used_num in number default hr_api.g_number
815: ,p_business_group_id in number default hr_api.g_number

Line 812: ,p_prtt_reimbmt_rqst_id in number default hr_api.g_number

808: ,p_element_entry_value_id in number default hr_api.g_number
809: ,p_per_in_ler_id in number default hr_api.g_number
810: ,p_ended_per_in_ler_id in number default hr_api.g_number
811: ,p_acty_base_rt_id in number default hr_api.g_number
812: ,p_prtt_reimbmt_rqst_id in number default hr_api.g_number
813: ,p_prtt_rmt_aprvd_fr_pymt_id in number default hr_api.g_number
814: ,p_pp_in_yr_used_num in number default hr_api.g_number
815: ,p_business_group_id in number default hr_api.g_number
816: ,p_prv_attribute_category in varchar2 default hr_api.g_varchar2

Line 813: ,p_prtt_rmt_aprvd_fr_pymt_id in number default hr_api.g_number

809: ,p_per_in_ler_id in number default hr_api.g_number
810: ,p_ended_per_in_ler_id in number default hr_api.g_number
811: ,p_acty_base_rt_id in number default hr_api.g_number
812: ,p_prtt_reimbmt_rqst_id in number default hr_api.g_number
813: ,p_prtt_rmt_aprvd_fr_pymt_id in number default hr_api.g_number
814: ,p_pp_in_yr_used_num in number default hr_api.g_number
815: ,p_business_group_id in number default hr_api.g_number
816: ,p_prv_attribute_category in varchar2 default hr_api.g_varchar2
817: ,p_prv_attribute1 in varchar2 default hr_api.g_varchar2

Line 814: ,p_pp_in_yr_used_num in number default hr_api.g_number

810: ,p_ended_per_in_ler_id in number default hr_api.g_number
811: ,p_acty_base_rt_id in number default hr_api.g_number
812: ,p_prtt_reimbmt_rqst_id in number default hr_api.g_number
813: ,p_prtt_rmt_aprvd_fr_pymt_id in number default hr_api.g_number
814: ,p_pp_in_yr_used_num in number default hr_api.g_number
815: ,p_business_group_id in number default hr_api.g_number
816: ,p_prv_attribute_category in varchar2 default hr_api.g_varchar2
817: ,p_prv_attribute1 in varchar2 default hr_api.g_varchar2
818: ,p_prv_attribute2 in varchar2 default hr_api.g_varchar2

Line 815: ,p_business_group_id in number default hr_api.g_number

811: ,p_acty_base_rt_id in number default hr_api.g_number
812: ,p_prtt_reimbmt_rqst_id in number default hr_api.g_number
813: ,p_prtt_rmt_aprvd_fr_pymt_id in number default hr_api.g_number
814: ,p_pp_in_yr_used_num in number default hr_api.g_number
815: ,p_business_group_id in number default hr_api.g_number
816: ,p_prv_attribute_category in varchar2 default hr_api.g_varchar2
817: ,p_prv_attribute1 in varchar2 default hr_api.g_varchar2
818: ,p_prv_attribute2 in varchar2 default hr_api.g_varchar2
819: ,p_prv_attribute3 in varchar2 default hr_api.g_varchar2

Line 816: ,p_prv_attribute_category in varchar2 default hr_api.g_varchar2

812: ,p_prtt_reimbmt_rqst_id in number default hr_api.g_number
813: ,p_prtt_rmt_aprvd_fr_pymt_id in number default hr_api.g_number
814: ,p_pp_in_yr_used_num in number default hr_api.g_number
815: ,p_business_group_id in number default hr_api.g_number
816: ,p_prv_attribute_category in varchar2 default hr_api.g_varchar2
817: ,p_prv_attribute1 in varchar2 default hr_api.g_varchar2
818: ,p_prv_attribute2 in varchar2 default hr_api.g_varchar2
819: ,p_prv_attribute3 in varchar2 default hr_api.g_varchar2
820: ,p_prv_attribute4 in varchar2 default hr_api.g_varchar2

Line 817: ,p_prv_attribute1 in varchar2 default hr_api.g_varchar2

813: ,p_prtt_rmt_aprvd_fr_pymt_id in number default hr_api.g_number
814: ,p_pp_in_yr_used_num in number default hr_api.g_number
815: ,p_business_group_id in number default hr_api.g_number
816: ,p_prv_attribute_category in varchar2 default hr_api.g_varchar2
817: ,p_prv_attribute1 in varchar2 default hr_api.g_varchar2
818: ,p_prv_attribute2 in varchar2 default hr_api.g_varchar2
819: ,p_prv_attribute3 in varchar2 default hr_api.g_varchar2
820: ,p_prv_attribute4 in varchar2 default hr_api.g_varchar2
821: ,p_prv_attribute5 in varchar2 default hr_api.g_varchar2

Line 818: ,p_prv_attribute2 in varchar2 default hr_api.g_varchar2

814: ,p_pp_in_yr_used_num in number default hr_api.g_number
815: ,p_business_group_id in number default hr_api.g_number
816: ,p_prv_attribute_category in varchar2 default hr_api.g_varchar2
817: ,p_prv_attribute1 in varchar2 default hr_api.g_varchar2
818: ,p_prv_attribute2 in varchar2 default hr_api.g_varchar2
819: ,p_prv_attribute3 in varchar2 default hr_api.g_varchar2
820: ,p_prv_attribute4 in varchar2 default hr_api.g_varchar2
821: ,p_prv_attribute5 in varchar2 default hr_api.g_varchar2
822: ,p_prv_attribute6 in varchar2 default hr_api.g_varchar2

Line 819: ,p_prv_attribute3 in varchar2 default hr_api.g_varchar2

815: ,p_business_group_id in number default hr_api.g_number
816: ,p_prv_attribute_category in varchar2 default hr_api.g_varchar2
817: ,p_prv_attribute1 in varchar2 default hr_api.g_varchar2
818: ,p_prv_attribute2 in varchar2 default hr_api.g_varchar2
819: ,p_prv_attribute3 in varchar2 default hr_api.g_varchar2
820: ,p_prv_attribute4 in varchar2 default hr_api.g_varchar2
821: ,p_prv_attribute5 in varchar2 default hr_api.g_varchar2
822: ,p_prv_attribute6 in varchar2 default hr_api.g_varchar2
823: ,p_prv_attribute7 in varchar2 default hr_api.g_varchar2

Line 820: ,p_prv_attribute4 in varchar2 default hr_api.g_varchar2

816: ,p_prv_attribute_category in varchar2 default hr_api.g_varchar2
817: ,p_prv_attribute1 in varchar2 default hr_api.g_varchar2
818: ,p_prv_attribute2 in varchar2 default hr_api.g_varchar2
819: ,p_prv_attribute3 in varchar2 default hr_api.g_varchar2
820: ,p_prv_attribute4 in varchar2 default hr_api.g_varchar2
821: ,p_prv_attribute5 in varchar2 default hr_api.g_varchar2
822: ,p_prv_attribute6 in varchar2 default hr_api.g_varchar2
823: ,p_prv_attribute7 in varchar2 default hr_api.g_varchar2
824: ,p_prv_attribute8 in varchar2 default hr_api.g_varchar2

Line 821: ,p_prv_attribute5 in varchar2 default hr_api.g_varchar2

817: ,p_prv_attribute1 in varchar2 default hr_api.g_varchar2
818: ,p_prv_attribute2 in varchar2 default hr_api.g_varchar2
819: ,p_prv_attribute3 in varchar2 default hr_api.g_varchar2
820: ,p_prv_attribute4 in varchar2 default hr_api.g_varchar2
821: ,p_prv_attribute5 in varchar2 default hr_api.g_varchar2
822: ,p_prv_attribute6 in varchar2 default hr_api.g_varchar2
823: ,p_prv_attribute7 in varchar2 default hr_api.g_varchar2
824: ,p_prv_attribute8 in varchar2 default hr_api.g_varchar2
825: ,p_prv_attribute9 in varchar2 default hr_api.g_varchar2

Line 822: ,p_prv_attribute6 in varchar2 default hr_api.g_varchar2

818: ,p_prv_attribute2 in varchar2 default hr_api.g_varchar2
819: ,p_prv_attribute3 in varchar2 default hr_api.g_varchar2
820: ,p_prv_attribute4 in varchar2 default hr_api.g_varchar2
821: ,p_prv_attribute5 in varchar2 default hr_api.g_varchar2
822: ,p_prv_attribute6 in varchar2 default hr_api.g_varchar2
823: ,p_prv_attribute7 in varchar2 default hr_api.g_varchar2
824: ,p_prv_attribute8 in varchar2 default hr_api.g_varchar2
825: ,p_prv_attribute9 in varchar2 default hr_api.g_varchar2
826: ,p_prv_attribute10 in varchar2 default hr_api.g_varchar2

Line 823: ,p_prv_attribute7 in varchar2 default hr_api.g_varchar2

819: ,p_prv_attribute3 in varchar2 default hr_api.g_varchar2
820: ,p_prv_attribute4 in varchar2 default hr_api.g_varchar2
821: ,p_prv_attribute5 in varchar2 default hr_api.g_varchar2
822: ,p_prv_attribute6 in varchar2 default hr_api.g_varchar2
823: ,p_prv_attribute7 in varchar2 default hr_api.g_varchar2
824: ,p_prv_attribute8 in varchar2 default hr_api.g_varchar2
825: ,p_prv_attribute9 in varchar2 default hr_api.g_varchar2
826: ,p_prv_attribute10 in varchar2 default hr_api.g_varchar2
827: ,p_prv_attribute11 in varchar2 default hr_api.g_varchar2

Line 824: ,p_prv_attribute8 in varchar2 default hr_api.g_varchar2

820: ,p_prv_attribute4 in varchar2 default hr_api.g_varchar2
821: ,p_prv_attribute5 in varchar2 default hr_api.g_varchar2
822: ,p_prv_attribute6 in varchar2 default hr_api.g_varchar2
823: ,p_prv_attribute7 in varchar2 default hr_api.g_varchar2
824: ,p_prv_attribute8 in varchar2 default hr_api.g_varchar2
825: ,p_prv_attribute9 in varchar2 default hr_api.g_varchar2
826: ,p_prv_attribute10 in varchar2 default hr_api.g_varchar2
827: ,p_prv_attribute11 in varchar2 default hr_api.g_varchar2
828: ,p_prv_attribute12 in varchar2 default hr_api.g_varchar2

Line 825: ,p_prv_attribute9 in varchar2 default hr_api.g_varchar2

821: ,p_prv_attribute5 in varchar2 default hr_api.g_varchar2
822: ,p_prv_attribute6 in varchar2 default hr_api.g_varchar2
823: ,p_prv_attribute7 in varchar2 default hr_api.g_varchar2
824: ,p_prv_attribute8 in varchar2 default hr_api.g_varchar2
825: ,p_prv_attribute9 in varchar2 default hr_api.g_varchar2
826: ,p_prv_attribute10 in varchar2 default hr_api.g_varchar2
827: ,p_prv_attribute11 in varchar2 default hr_api.g_varchar2
828: ,p_prv_attribute12 in varchar2 default hr_api.g_varchar2
829: ,p_prv_attribute13 in varchar2 default hr_api.g_varchar2

Line 826: ,p_prv_attribute10 in varchar2 default hr_api.g_varchar2

822: ,p_prv_attribute6 in varchar2 default hr_api.g_varchar2
823: ,p_prv_attribute7 in varchar2 default hr_api.g_varchar2
824: ,p_prv_attribute8 in varchar2 default hr_api.g_varchar2
825: ,p_prv_attribute9 in varchar2 default hr_api.g_varchar2
826: ,p_prv_attribute10 in varchar2 default hr_api.g_varchar2
827: ,p_prv_attribute11 in varchar2 default hr_api.g_varchar2
828: ,p_prv_attribute12 in varchar2 default hr_api.g_varchar2
829: ,p_prv_attribute13 in varchar2 default hr_api.g_varchar2
830: ,p_prv_attribute14 in varchar2 default hr_api.g_varchar2

Line 827: ,p_prv_attribute11 in varchar2 default hr_api.g_varchar2

823: ,p_prv_attribute7 in varchar2 default hr_api.g_varchar2
824: ,p_prv_attribute8 in varchar2 default hr_api.g_varchar2
825: ,p_prv_attribute9 in varchar2 default hr_api.g_varchar2
826: ,p_prv_attribute10 in varchar2 default hr_api.g_varchar2
827: ,p_prv_attribute11 in varchar2 default hr_api.g_varchar2
828: ,p_prv_attribute12 in varchar2 default hr_api.g_varchar2
829: ,p_prv_attribute13 in varchar2 default hr_api.g_varchar2
830: ,p_prv_attribute14 in varchar2 default hr_api.g_varchar2
831: ,p_prv_attribute15 in varchar2 default hr_api.g_varchar2

Line 828: ,p_prv_attribute12 in varchar2 default hr_api.g_varchar2

824: ,p_prv_attribute8 in varchar2 default hr_api.g_varchar2
825: ,p_prv_attribute9 in varchar2 default hr_api.g_varchar2
826: ,p_prv_attribute10 in varchar2 default hr_api.g_varchar2
827: ,p_prv_attribute11 in varchar2 default hr_api.g_varchar2
828: ,p_prv_attribute12 in varchar2 default hr_api.g_varchar2
829: ,p_prv_attribute13 in varchar2 default hr_api.g_varchar2
830: ,p_prv_attribute14 in varchar2 default hr_api.g_varchar2
831: ,p_prv_attribute15 in varchar2 default hr_api.g_varchar2
832: ,p_prv_attribute16 in varchar2 default hr_api.g_varchar2

Line 829: ,p_prv_attribute13 in varchar2 default hr_api.g_varchar2

825: ,p_prv_attribute9 in varchar2 default hr_api.g_varchar2
826: ,p_prv_attribute10 in varchar2 default hr_api.g_varchar2
827: ,p_prv_attribute11 in varchar2 default hr_api.g_varchar2
828: ,p_prv_attribute12 in varchar2 default hr_api.g_varchar2
829: ,p_prv_attribute13 in varchar2 default hr_api.g_varchar2
830: ,p_prv_attribute14 in varchar2 default hr_api.g_varchar2
831: ,p_prv_attribute15 in varchar2 default hr_api.g_varchar2
832: ,p_prv_attribute16 in varchar2 default hr_api.g_varchar2
833: ,p_prv_attribute17 in varchar2 default hr_api.g_varchar2

Line 830: ,p_prv_attribute14 in varchar2 default hr_api.g_varchar2

826: ,p_prv_attribute10 in varchar2 default hr_api.g_varchar2
827: ,p_prv_attribute11 in varchar2 default hr_api.g_varchar2
828: ,p_prv_attribute12 in varchar2 default hr_api.g_varchar2
829: ,p_prv_attribute13 in varchar2 default hr_api.g_varchar2
830: ,p_prv_attribute14 in varchar2 default hr_api.g_varchar2
831: ,p_prv_attribute15 in varchar2 default hr_api.g_varchar2
832: ,p_prv_attribute16 in varchar2 default hr_api.g_varchar2
833: ,p_prv_attribute17 in varchar2 default hr_api.g_varchar2
834: ,p_prv_attribute18 in varchar2 default hr_api.g_varchar2

Line 831: ,p_prv_attribute15 in varchar2 default hr_api.g_varchar2

827: ,p_prv_attribute11 in varchar2 default hr_api.g_varchar2
828: ,p_prv_attribute12 in varchar2 default hr_api.g_varchar2
829: ,p_prv_attribute13 in varchar2 default hr_api.g_varchar2
830: ,p_prv_attribute14 in varchar2 default hr_api.g_varchar2
831: ,p_prv_attribute15 in varchar2 default hr_api.g_varchar2
832: ,p_prv_attribute16 in varchar2 default hr_api.g_varchar2
833: ,p_prv_attribute17 in varchar2 default hr_api.g_varchar2
834: ,p_prv_attribute18 in varchar2 default hr_api.g_varchar2
835: ,p_prv_attribute19 in varchar2 default hr_api.g_varchar2

Line 832: ,p_prv_attribute16 in varchar2 default hr_api.g_varchar2

828: ,p_prv_attribute12 in varchar2 default hr_api.g_varchar2
829: ,p_prv_attribute13 in varchar2 default hr_api.g_varchar2
830: ,p_prv_attribute14 in varchar2 default hr_api.g_varchar2
831: ,p_prv_attribute15 in varchar2 default hr_api.g_varchar2
832: ,p_prv_attribute16 in varchar2 default hr_api.g_varchar2
833: ,p_prv_attribute17 in varchar2 default hr_api.g_varchar2
834: ,p_prv_attribute18 in varchar2 default hr_api.g_varchar2
835: ,p_prv_attribute19 in varchar2 default hr_api.g_varchar2
836: ,p_prv_attribute20 in varchar2 default hr_api.g_varchar2

Line 833: ,p_prv_attribute17 in varchar2 default hr_api.g_varchar2

829: ,p_prv_attribute13 in varchar2 default hr_api.g_varchar2
830: ,p_prv_attribute14 in varchar2 default hr_api.g_varchar2
831: ,p_prv_attribute15 in varchar2 default hr_api.g_varchar2
832: ,p_prv_attribute16 in varchar2 default hr_api.g_varchar2
833: ,p_prv_attribute17 in varchar2 default hr_api.g_varchar2
834: ,p_prv_attribute18 in varchar2 default hr_api.g_varchar2
835: ,p_prv_attribute19 in varchar2 default hr_api.g_varchar2
836: ,p_prv_attribute20 in varchar2 default hr_api.g_varchar2
837: ,p_prv_attribute21 in varchar2 default hr_api.g_varchar2

Line 834: ,p_prv_attribute18 in varchar2 default hr_api.g_varchar2

830: ,p_prv_attribute14 in varchar2 default hr_api.g_varchar2
831: ,p_prv_attribute15 in varchar2 default hr_api.g_varchar2
832: ,p_prv_attribute16 in varchar2 default hr_api.g_varchar2
833: ,p_prv_attribute17 in varchar2 default hr_api.g_varchar2
834: ,p_prv_attribute18 in varchar2 default hr_api.g_varchar2
835: ,p_prv_attribute19 in varchar2 default hr_api.g_varchar2
836: ,p_prv_attribute20 in varchar2 default hr_api.g_varchar2
837: ,p_prv_attribute21 in varchar2 default hr_api.g_varchar2
838: ,p_prv_attribute22 in varchar2 default hr_api.g_varchar2

Line 835: ,p_prv_attribute19 in varchar2 default hr_api.g_varchar2

831: ,p_prv_attribute15 in varchar2 default hr_api.g_varchar2
832: ,p_prv_attribute16 in varchar2 default hr_api.g_varchar2
833: ,p_prv_attribute17 in varchar2 default hr_api.g_varchar2
834: ,p_prv_attribute18 in varchar2 default hr_api.g_varchar2
835: ,p_prv_attribute19 in varchar2 default hr_api.g_varchar2
836: ,p_prv_attribute20 in varchar2 default hr_api.g_varchar2
837: ,p_prv_attribute21 in varchar2 default hr_api.g_varchar2
838: ,p_prv_attribute22 in varchar2 default hr_api.g_varchar2
839: ,p_prv_attribute23 in varchar2 default hr_api.g_varchar2

Line 836: ,p_prv_attribute20 in varchar2 default hr_api.g_varchar2

832: ,p_prv_attribute16 in varchar2 default hr_api.g_varchar2
833: ,p_prv_attribute17 in varchar2 default hr_api.g_varchar2
834: ,p_prv_attribute18 in varchar2 default hr_api.g_varchar2
835: ,p_prv_attribute19 in varchar2 default hr_api.g_varchar2
836: ,p_prv_attribute20 in varchar2 default hr_api.g_varchar2
837: ,p_prv_attribute21 in varchar2 default hr_api.g_varchar2
838: ,p_prv_attribute22 in varchar2 default hr_api.g_varchar2
839: ,p_prv_attribute23 in varchar2 default hr_api.g_varchar2
840: ,p_prv_attribute24 in varchar2 default hr_api.g_varchar2

Line 837: ,p_prv_attribute21 in varchar2 default hr_api.g_varchar2

833: ,p_prv_attribute17 in varchar2 default hr_api.g_varchar2
834: ,p_prv_attribute18 in varchar2 default hr_api.g_varchar2
835: ,p_prv_attribute19 in varchar2 default hr_api.g_varchar2
836: ,p_prv_attribute20 in varchar2 default hr_api.g_varchar2
837: ,p_prv_attribute21 in varchar2 default hr_api.g_varchar2
838: ,p_prv_attribute22 in varchar2 default hr_api.g_varchar2
839: ,p_prv_attribute23 in varchar2 default hr_api.g_varchar2
840: ,p_prv_attribute24 in varchar2 default hr_api.g_varchar2
841: ,p_prv_attribute25 in varchar2 default hr_api.g_varchar2

Line 838: ,p_prv_attribute22 in varchar2 default hr_api.g_varchar2

834: ,p_prv_attribute18 in varchar2 default hr_api.g_varchar2
835: ,p_prv_attribute19 in varchar2 default hr_api.g_varchar2
836: ,p_prv_attribute20 in varchar2 default hr_api.g_varchar2
837: ,p_prv_attribute21 in varchar2 default hr_api.g_varchar2
838: ,p_prv_attribute22 in varchar2 default hr_api.g_varchar2
839: ,p_prv_attribute23 in varchar2 default hr_api.g_varchar2
840: ,p_prv_attribute24 in varchar2 default hr_api.g_varchar2
841: ,p_prv_attribute25 in varchar2 default hr_api.g_varchar2
842: ,p_prv_attribute26 in varchar2 default hr_api.g_varchar2

Line 839: ,p_prv_attribute23 in varchar2 default hr_api.g_varchar2

835: ,p_prv_attribute19 in varchar2 default hr_api.g_varchar2
836: ,p_prv_attribute20 in varchar2 default hr_api.g_varchar2
837: ,p_prv_attribute21 in varchar2 default hr_api.g_varchar2
838: ,p_prv_attribute22 in varchar2 default hr_api.g_varchar2
839: ,p_prv_attribute23 in varchar2 default hr_api.g_varchar2
840: ,p_prv_attribute24 in varchar2 default hr_api.g_varchar2
841: ,p_prv_attribute25 in varchar2 default hr_api.g_varchar2
842: ,p_prv_attribute26 in varchar2 default hr_api.g_varchar2
843: ,p_prv_attribute27 in varchar2 default hr_api.g_varchar2

Line 840: ,p_prv_attribute24 in varchar2 default hr_api.g_varchar2

836: ,p_prv_attribute20 in varchar2 default hr_api.g_varchar2
837: ,p_prv_attribute21 in varchar2 default hr_api.g_varchar2
838: ,p_prv_attribute22 in varchar2 default hr_api.g_varchar2
839: ,p_prv_attribute23 in varchar2 default hr_api.g_varchar2
840: ,p_prv_attribute24 in varchar2 default hr_api.g_varchar2
841: ,p_prv_attribute25 in varchar2 default hr_api.g_varchar2
842: ,p_prv_attribute26 in varchar2 default hr_api.g_varchar2
843: ,p_prv_attribute27 in varchar2 default hr_api.g_varchar2
844: ,p_prv_attribute28 in varchar2 default hr_api.g_varchar2

Line 841: ,p_prv_attribute25 in varchar2 default hr_api.g_varchar2

837: ,p_prv_attribute21 in varchar2 default hr_api.g_varchar2
838: ,p_prv_attribute22 in varchar2 default hr_api.g_varchar2
839: ,p_prv_attribute23 in varchar2 default hr_api.g_varchar2
840: ,p_prv_attribute24 in varchar2 default hr_api.g_varchar2
841: ,p_prv_attribute25 in varchar2 default hr_api.g_varchar2
842: ,p_prv_attribute26 in varchar2 default hr_api.g_varchar2
843: ,p_prv_attribute27 in varchar2 default hr_api.g_varchar2
844: ,p_prv_attribute28 in varchar2 default hr_api.g_varchar2
845: ,p_prv_attribute29 in varchar2 default hr_api.g_varchar2

Line 842: ,p_prv_attribute26 in varchar2 default hr_api.g_varchar2

838: ,p_prv_attribute22 in varchar2 default hr_api.g_varchar2
839: ,p_prv_attribute23 in varchar2 default hr_api.g_varchar2
840: ,p_prv_attribute24 in varchar2 default hr_api.g_varchar2
841: ,p_prv_attribute25 in varchar2 default hr_api.g_varchar2
842: ,p_prv_attribute26 in varchar2 default hr_api.g_varchar2
843: ,p_prv_attribute27 in varchar2 default hr_api.g_varchar2
844: ,p_prv_attribute28 in varchar2 default hr_api.g_varchar2
845: ,p_prv_attribute29 in varchar2 default hr_api.g_varchar2
846: ,p_prv_attribute30 in varchar2 default hr_api.g_varchar2

Line 843: ,p_prv_attribute27 in varchar2 default hr_api.g_varchar2

839: ,p_prv_attribute23 in varchar2 default hr_api.g_varchar2
840: ,p_prv_attribute24 in varchar2 default hr_api.g_varchar2
841: ,p_prv_attribute25 in varchar2 default hr_api.g_varchar2
842: ,p_prv_attribute26 in varchar2 default hr_api.g_varchar2
843: ,p_prv_attribute27 in varchar2 default hr_api.g_varchar2
844: ,p_prv_attribute28 in varchar2 default hr_api.g_varchar2
845: ,p_prv_attribute29 in varchar2 default hr_api.g_varchar2
846: ,p_prv_attribute30 in varchar2 default hr_api.g_varchar2
847: ,p_pk_id_table_name in varchar2 default hr_api.g_varchar2

Line 844: ,p_prv_attribute28 in varchar2 default hr_api.g_varchar2

840: ,p_prv_attribute24 in varchar2 default hr_api.g_varchar2
841: ,p_prv_attribute25 in varchar2 default hr_api.g_varchar2
842: ,p_prv_attribute26 in varchar2 default hr_api.g_varchar2
843: ,p_prv_attribute27 in varchar2 default hr_api.g_varchar2
844: ,p_prv_attribute28 in varchar2 default hr_api.g_varchar2
845: ,p_prv_attribute29 in varchar2 default hr_api.g_varchar2
846: ,p_prv_attribute30 in varchar2 default hr_api.g_varchar2
847: ,p_pk_id_table_name in varchar2 default hr_api.g_varchar2
848: ,p_pk_id in number default hr_api.g_number

Line 845: ,p_prv_attribute29 in varchar2 default hr_api.g_varchar2

841: ,p_prv_attribute25 in varchar2 default hr_api.g_varchar2
842: ,p_prv_attribute26 in varchar2 default hr_api.g_varchar2
843: ,p_prv_attribute27 in varchar2 default hr_api.g_varchar2
844: ,p_prv_attribute28 in varchar2 default hr_api.g_varchar2
845: ,p_prv_attribute29 in varchar2 default hr_api.g_varchar2
846: ,p_prv_attribute30 in varchar2 default hr_api.g_varchar2
847: ,p_pk_id_table_name in varchar2 default hr_api.g_varchar2
848: ,p_pk_id in number default hr_api.g_number
849: ,p_no_end_element in boolean default false

Line 846: ,p_prv_attribute30 in varchar2 default hr_api.g_varchar2

842: ,p_prv_attribute26 in varchar2 default hr_api.g_varchar2
843: ,p_prv_attribute27 in varchar2 default hr_api.g_varchar2
844: ,p_prv_attribute28 in varchar2 default hr_api.g_varchar2
845: ,p_prv_attribute29 in varchar2 default hr_api.g_varchar2
846: ,p_prv_attribute30 in varchar2 default hr_api.g_varchar2
847: ,p_pk_id_table_name in varchar2 default hr_api.g_varchar2
848: ,p_pk_id in number default hr_api.g_number
849: ,p_no_end_element in boolean default false
850: ,p_object_version_number in out nocopy number

Line 847: ,p_pk_id_table_name in varchar2 default hr_api.g_varchar2

843: ,p_prv_attribute27 in varchar2 default hr_api.g_varchar2
844: ,p_prv_attribute28 in varchar2 default hr_api.g_varchar2
845: ,p_prv_attribute29 in varchar2 default hr_api.g_varchar2
846: ,p_prv_attribute30 in varchar2 default hr_api.g_varchar2
847: ,p_pk_id_table_name in varchar2 default hr_api.g_varchar2
848: ,p_pk_id in number default hr_api.g_number
849: ,p_no_end_element in boolean default false
850: ,p_object_version_number in out nocopy number
851: ,p_effective_date in date

Line 848: ,p_pk_id in number default hr_api.g_number

844: ,p_prv_attribute28 in varchar2 default hr_api.g_varchar2
845: ,p_prv_attribute29 in varchar2 default hr_api.g_varchar2
846: ,p_prv_attribute30 in varchar2 default hr_api.g_varchar2
847: ,p_pk_id_table_name in varchar2 default hr_api.g_varchar2
848: ,p_pk_id in number default hr_api.g_number
849: ,p_no_end_element in boolean default false
850: ,p_object_version_number in out nocopy number
851: ,p_effective_date in date
852: ) is

Line 909: and pen.effective_end_date = hr_api.g_eot

905: cursor c_pen_curr(p_prtt_enrt_rslt_id number) is
906: select pen.*
907: from ben_prtt_enrt_rslt_f pen
908: where pen.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
909: and pen.effective_end_date = hr_api.g_eot
910: and pen.prtt_enrt_rslt_stat_cd is null
911: and pen.business_group_id = p_business_group_id;
912: --
913: l_pen_curr c_pen_curr%rowtype;

Line 1000: if nvl(p_rt_strt_dt,hr_api.g_date) = hr_api.g_date then

996: fnd_message.raise_error;
997: end if;
998: close c_old_prv;
999: --
1000: if nvl(p_rt_strt_dt,hr_api.g_date) = hr_api.g_date then
1001: l_rt_strt_dt := l_old_rt_strt_dt;
1002: else
1003: l_rt_strt_dt := p_rt_strt_dt;
1004: end if;

Line 1018: if l_rt_end_dt = hr_api.g_date then

1014: ,p_recurring_rt => l_recurring_rt
1015: ,p_effective_date => p_effective_date) ;
1016: end if;
1017: --
1018: if l_rt_end_dt = hr_api.g_date then
1019: l_rt_end_dt := l_old_rt_end_dt;
1020: end if;
1021: --
1022: if p_rt_val = hr_api.g_number then

Line 1022: if p_rt_val = hr_api.g_number then

1018: if l_rt_end_dt = hr_api.g_date then
1019: l_rt_end_dt := l_old_rt_end_dt;
1020: end if;
1021: --
1022: if p_rt_val = hr_api.g_number then
1023: l_rt_val := l_old_rt_val;
1024: else
1025: l_rt_val := p_rt_val;
1026: end if;

Line 1028: if p_cmcd_rt_val = hr_api.g_number then

1024: else
1025: l_rt_val := p_rt_val;
1026: end if;
1027: --
1028: if p_cmcd_rt_val = hr_api.g_number then
1029: l_cmcd_rt_val := l_old_cmcd_rt_val;
1030: else
1031: l_cmcd_rt_val := p_cmcd_rt_val;
1032: end if;

Line 1034: if p_ann_rt_val = hr_api.g_number then

1030: else
1031: l_cmcd_rt_val := p_cmcd_rt_val;
1032: end if;
1033: --
1034: if p_ann_rt_val = hr_api.g_number then
1035: l_ann_rt_val := l_old_ann_rt_val;
1036: else
1037: l_ann_rt_val := p_ann_rt_val;
1038: end if;

Line 1057: NVL(p_rt_ovridn_thru_dt,hr_api.g_eot ) < l_rt_strt_dt

1053: --
1054: --if l_ele_rec.element_entry_id is not null then
1055: if ( (NVL(p_rt_ovridn_flag,'N') = 'N' OR
1056: (NVL(p_rt_ovridn_flag,'N') ='Y' AND
1057: NVL(p_rt_ovridn_thru_dt,hr_api.g_eot ) < l_rt_strt_dt
1058: )
1059: )
1060: AND l_ele_rec.element_entry_id is not null ) then
1061: --

Line 1169: when hr_api.cannot_find_prog_unit then

1165: ,p_object_version_number => p_object_version_number
1166: ,p_effective_date => trunc(p_effective_date)
1167: );
1168: exception
1169: when hr_api.cannot_find_prog_unit then
1170: hr_api.cannot_find_prog_unit_error
1171: (p_module_name => 'UPDATE_prtt_rt_val'
1172: ,p_hook_type => 'BP'
1173: );

Line 1170: hr_api.cannot_find_prog_unit_error

1166: ,p_effective_date => trunc(p_effective_date)
1167: );
1168: exception
1169: when hr_api.cannot_find_prog_unit then
1170: hr_api.cannot_find_prog_unit_error
1171: (p_module_name => 'UPDATE_prtt_rt_val'
1172: ,p_hook_type => 'BP'
1173: );
1174: --

Line 1271: if l_rt_end_dt <> hr_api.g_eot then

1267: nvl(l_ann_rt_val,0) <> nvl(l_old_ann_rt_val,0) then
1268:
1269: /* Added if else condition for Bug 12576710. Modified the fix of Bug 10127267. If Rate EndDate is EOT,
1270: there will not exist any enrollment result*/
1271: if l_rt_end_dt <> hr_api.g_eot then
1272: l_rslt_suspended :=
1273: result_is_suspended(p_prtt_enrt_rslt_id => l_old_enrt_rslt_id,
1274: p_person_id => p_person_id,
1275: p_business_group_id => p_business_group_id,

Line 1296: if (p_rt_end_dt = hr_api.g_eot

1292: --
1293: hr_utility.set_location('p_prtt_enrt_rslt_id'||l_old_enrt_rslt_id,15);
1294: hr_utility.set_location('l_old_element_entry_value_id '||l_old_element_entry_value_id,15);
1295: --
1296: if (p_rt_end_dt = hr_api.g_eot
1297: and l_old_element_entry_value_id is not null) then
1298: open c_pen_curr(l_old_enrt_rslt_id);
1299: fetch c_pen_curr into l_pen_curr;
1300: close c_pen_curr;

Line 1432: (l_recurring_rt and l_rt_end_dt <> hr_api.g_eot) and

1428:
1429: if not p_no_end_element and
1430: (l_rt_end_dt < l_rt_strt_dt or
1431: (
1432: (l_recurring_rt and l_rt_end_dt <> hr_api.g_eot) and
1433: (l_rt_end_dt <> l_old_rt_end_dt or l_recreated)
1434: )
1435: ) then
1436:

Line 1526: when hr_api.cannot_find_prog_unit then

1522: ,p_object_version_number => l_object_version_number
1523: ,p_effective_date => trunc(p_effective_date)
1524: );
1525: exception
1526: when hr_api.cannot_find_prog_unit then
1527: hr_api.cannot_find_prog_unit_error
1528: (p_module_name => 'UPDATE_prtt_rt_val'
1529: ,p_hook_type => 'AP'
1530: );

Line 1527: hr_api.cannot_find_prog_unit_error

1523: ,p_effective_date => trunc(p_effective_date)
1524: );
1525: exception
1526: when hr_api.cannot_find_prog_unit then
1527: hr_api.cannot_find_prog_unit_error
1528: (p_module_name => 'UPDATE_prtt_rt_val'
1529: ,p_hook_type => 'AP'
1530: );
1531: --

Line 1543: raise hr_api.validate_enabled;

1539: --
1540: -- When in validation only mode raise the Validate_Enabled exception
1541: --
1542: if p_validate then
1543: raise hr_api.validate_enabled;
1544: end if;
1545: --
1546: -- Set all output arguments
1547: --

Line 1556: when hr_api.validate_enabled then

1552: end if;
1553: --
1554: exception
1555: --
1556: when hr_api.validate_enabled then
1557: --
1558: -- As the Validate_Enabled exception has been raised
1559: -- we must rollback to the savepoint
1560: --

Line 1680: when hr_api.cannot_find_prog_unit then

1676: ,p_object_version_number => p_object_version_number
1677: ,p_effective_date => trunc(p_effective_date)
1678: );
1679: exception
1680: when hr_api.cannot_find_prog_unit then
1681: hr_api.cannot_find_prog_unit_error
1682: (p_module_name => 'DELETE_prtt_rt_val'
1683: ,p_hook_type => 'BP'
1684: );

Line 1681: hr_api.cannot_find_prog_unit_error

1677: ,p_effective_date => trunc(p_effective_date)
1678: );
1679: exception
1680: when hr_api.cannot_find_prog_unit then
1681: hr_api.cannot_find_prog_unit_error
1682: (p_module_name => 'DELETE_prtt_rt_val'
1683: ,p_hook_type => 'BP'
1684: );
1685: --

Line 1757: when hr_api.cannot_find_prog_unit then

1753: ,p_object_version_number => l_object_version_number
1754: ,p_effective_date => trunc(p_effective_date)
1755: );
1756: exception
1757: when hr_api.cannot_find_prog_unit then
1758: hr_api.cannot_find_prog_unit_error
1759: (p_module_name => 'DELETE_prtt_rt_val'
1760: ,p_hook_type => 'AP'
1761: );

Line 1758: hr_api.cannot_find_prog_unit_error

1754: ,p_effective_date => trunc(p_effective_date)
1755: );
1756: exception
1757: when hr_api.cannot_find_prog_unit then
1758: hr_api.cannot_find_prog_unit_error
1759: (p_module_name => 'DELETE_prtt_rt_val'
1760: ,p_hook_type => 'AP'
1761: );
1762: --

Line 1774: raise hr_api.validate_enabled;

1770: --
1771: -- When in validation only mode raise the Validate_Enabled exception
1772: --
1773: if p_validate then
1774: raise hr_api.validate_enabled;
1775: end if;
1776: --
1777: if g_debug then
1778: hr_utility.set_location(' Leaving:'||l_proc, 70);

Line 1783: when hr_api.validate_enabled then

1779: end if;
1780: --
1781: exception
1782: --
1783: when hr_api.validate_enabled then
1784: --
1785: -- As the Validate_Enabled exception has been raised
1786: -- we must rollback to the savepoint
1787: --