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_MANAGE_OVERRIDE dependencies on BEN_PRTT_RT_VAL

Line 663: --Cursor to get the ben_prtt_rt_val records with the rt_end_dt as end of time

659: ,p_prtt_enrt_rslt_id in number
660: ,p_enrt_cvg_thru_dt in date
661: ,p_effective_date in date
662: ) is
663: --Cursor to get the ben_prtt_rt_val records with the rt_end_dt as end of time
664: --
665: l_package varchar2(500) := 'Ben_Manage_Override.end_rate_and_dependents';
666: --
667: cursor c_prv(cv_prtt_enrt_rslt_id number) is

Line 674: from ben_prtt_rt_val prv

670: acty_base_rt_id,
671: per_in_ler_id,
672: business_group_id,
673: element_entry_value_id
674: from ben_prtt_rt_val prv
675: where prv.prtt_enrt_rslt_id = cv_prtt_enrt_rslt_id
676: and prv.prtt_rt_val_stat_cd is null
677: and prv.rt_end_dt = to_date('31/12/4712','DD/MM/RRRR') ;
678: --

Line 789: ben_prtt_rt_val_api.update_prtt_rt_val

785: fetch c_abr into l_abr ;
786: close c_abr ;
787: --
788: if l_abr.input_value_id is not null and l_abr.element_type_id is not null then
789: ben_prtt_rt_val_api.update_prtt_rt_val
790: (p_validate => false
791: ,p_prtt_rt_val_id => l_prv.prtt_rt_val_id
792: ,p_rt_end_dt => p_enrt_cvg_thru_dt
793: ,p_rt_ovridn_flag => 'Y'

Line 807: update ben_prtt_rt_val

803: );
804: --
805: else
806: --
807: update ben_prtt_rt_val
808: set rt_end_dt = p_enrt_cvg_thru_dt,
809: rt_ovridn_flag = 'Y',
810: rt_ovridn_thru_dt = p_enrt_cvg_thru_dt
811: where prtt_rt_val_id = l_prv.prtt_rt_val_id ;

Line 817: update ben_prtt_rt_val

813: end if;
814: --
815: else
816: --
817: update ben_prtt_rt_val
818: set rt_end_dt = p_enrt_cvg_thru_dt,
819: rt_ovridn_flag = 'Y',
820: rt_ovridn_thru_dt = p_enrt_cvg_thru_dt
821: where prtt_rt_val_id = l_prv.prtt_rt_val_id ;

Line 874: --Cursor to get the ben_prtt_rt_val records with the rt_end_dt as not end of time

870: ,p_per_in_ler_id in number
871: ,p_prtt_enrt_rslt_id in number
872: ,p_effective_date in date
873: ) is
874: --Cursor to get the ben_prtt_rt_val records with the rt_end_dt as not end of time
875: --
876: l_package varchar2(500) := 'Ben_Manage_Override.reopen_rate_and_dependents';
877: --
878: cursor c_prv(cv_prtt_enrt_rslt_id number) is

Line 885: from ben_prtt_rt_val prv

881: acty_base_rt_id,
882: per_in_ler_id,
883: business_group_id,
884: element_entry_value_id
885: from ben_prtt_rt_val prv
886: where prv.prtt_enrt_rslt_id = cv_prtt_enrt_rslt_id
887: and prv.prtt_rt_val_stat_cd is null
888: and prv.rt_end_dt <> to_date('31/12/4712','DD/MM/RRRR') and
889: not exists ( select 'x' from

Line 890: ben_prtt_rt_val prv1

886: where prv.prtt_enrt_rslt_id = cv_prtt_enrt_rslt_id
887: and prv.prtt_rt_val_stat_cd is null
888: and prv.rt_end_dt <> to_date('31/12/4712','DD/MM/RRRR') and
889: not exists ( select 'x' from
890: ben_prtt_rt_val prv1
891: where prv.rowid <> prv1.rowid
892: and prv1.prtt_enrt_rslt_id = cv_prtt_enrt_rslt_id
893: and prv1.acty_base_rt_id = prv.acty_base_rt_id
894: and prv1.prtt_rt_val_stat_cd is null

Line 1017: ben_prtt_rt_val_api.update_prtt_rt_val

1013: fetch c_abr into l_abr ;
1014: close c_abr ;
1015: --
1016: if l_abr.input_value_id is not null and l_abr.element_type_id is not null then
1017: ben_prtt_rt_val_api.update_prtt_rt_val
1018: (p_validate => false
1019: ,p_prtt_rt_val_id => l_prv.prtt_rt_val_id
1020: ,p_rt_end_dt => to_date('31/12/4712','DD/MM/RRRR')
1021: ,p_rt_ovridn_flag => 'Y'

Line 1035: update ben_prtt_rt_val

1031: );
1032: --
1033: else
1034: --
1035: update ben_prtt_rt_val
1036: set rt_end_dt = to_date('31/12/4712','DD/MM/RRRR'),
1037: rt_ovridn_flag = 'Y',
1038: rt_ovridn_thru_dt = null
1039: where prtt_rt_val_id = l_prv.prtt_rt_val_id ;

Line 1045: update ben_prtt_rt_val

1041: end if;
1042: --
1043: else
1044: --
1045: update ben_prtt_rt_val
1046: set rt_end_dt = to_date('31/12/4712','DD/MM/RRRR'),
1047: rt_ovridn_flag = 'Y',
1048: rt_ovridn_thru_dt = null
1049: where prtt_rt_val_id = l_prv.prtt_rt_val_id ;

Line 1467: from ben_prtt_rt_val

1463: --
1464: cursor c_prtt_rt_val
1465: is
1466: select rt_val
1467: from ben_prtt_rt_val
1468: where prtt_rt_val_id=l_ecr_rec.prtt_rt_val_id;
1469: --
1470: begin
1471: --

Line 1665: from ben_prtt_rt_val prv

1661: l_delete_warning boolean;
1662: --
1663: cursor c_current_prv is
1664: select prv.*
1665: from ben_prtt_rt_val prv
1666: where prv.prtt_rt_val_id = p_prtt_rt_val_id;
1667: --
1668: l_current_prv c_current_prv%ROWTYPE;
1669: --

Line 1724: from ben_prtt_rt_val prv,

1720: abr.input_value_id,
1721: prv.business_group_id,
1722: prv.acty_ref_perd_cd,
1723: prv.object_version_number
1724: from ben_prtt_rt_val prv,
1725: ben_acty_base_rt_f abr,
1726: ben_prtt_enrt_rslt_f pen
1727: where prv.prtt_rt_val_id <> p_prtt_rt_val_id
1728: and prv.prtt_rt_val_stat_cd IS NULL

Line 1750: ben_prtt_rt_val_api.get_non_recurring_end_dt

1746: fetch c_current_prv into l_current_prv;
1747: close c_current_prv;
1748: --
1749: --
1750: ben_prtt_rt_val_api.get_non_recurring_end_dt
1751: (p_rt_end_dt => l_rt_end_dt
1752: ,p_rt_strt_dt => p_rt_strt_dt
1753: ,p_acty_base_rt_id => p_acty_base_rt_id
1754: ,p_business_group_id => p_business_group_id

Line 1761: ben_prtt_rt_val_api.chk_overlapping_dates

1757: ) ;
1758: --
1759: if l_recurring_rt then
1760: --
1761: ben_prtt_rt_val_api.chk_overlapping_dates
1762: (p_acty_base_rt_id => p_acty_base_rt_id
1763: ,p_prtt_rt_val_id => p_prtt_rt_val_id
1764: ,p_prtt_enrt_rslt_id => p_prtt_enrt_rslt_id
1765: ,p_new_rt_strt_dt => p_rt_strt_dt

Line 1876: l_rslt_suspended := ben_prtt_rt_val_api.result_is_suspended

1872: close c_zap_future_ee;
1873: --
1874: end if;
1875: --
1876: l_rslt_suspended := ben_prtt_rt_val_api.result_is_suspended
1877: (p_prtt_enrt_rslt_id => p_prtt_enrt_rslt_id,
1878: p_person_id => p_person_id,
1879: p_business_group_id => p_business_group_id,
1880: p_effective_date => p_effective_date) ;

Line 1959: l_rslt_suspended := ben_prtt_rt_val_api.result_is_suspended

1955: if c_future_prv%notfound then
1956: exit;
1957: end if;
1958: --
1959: l_rslt_suspended := ben_prtt_rt_val_api.result_is_suspended
1960: (p_prtt_enrt_rslt_id => l_future_prv.prtt_enrt_rslt_id,
1961: p_person_id => p_person_id,
1962: p_business_group_id => p_business_group_id,
1963: p_effective_date => l_future_prv.rt_strt_dt ) ;