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_CWB_LIFE_EVENTS dependencies on BEN_PTNL_LER_FOR_PER

Line 1844: ben_ptnl_ler_for_per ptnl,

1840: pil.business_group_id,
1841: ptnl.ptnl_ler_for_per_id,
1842: ptnl.object_version_number ptnl_ovn
1843: from ben_per_in_ler pil,
1844: ben_ptnl_ler_for_per ptnl,
1845: ben_cwb_person_info cpi
1846: where pil.group_pl_id = cv_group_pl_id
1847: and pil.lf_evt_ocrd_dt = cv_lf_evt_ocrd_dt
1848: and pil.per_in_ler_stat_cd = 'STRTD'

Line 1879: * ben_per_in_ler, ben_ptnl_ler_for_per, ben_pil_elctbl_chc_popl,

1875: * ELIG_FLAG = Y and only consider uncloned data
1876: * then
1877: *
1878: * Delete data from ben_cwb_person_rates, ben_cwb_person_groups,
1879: * ben_per_in_ler, ben_ptnl_ler_for_per, ben_pil_elctbl_chc_popl,
1880: * ben_elig_per_elctbl_chc, ben_group_heirarchy,
1881: * ben_cwb_person_tasks.
1882: */
1883: if g_debug then

Line 1934: ben_ptnl_ler_for_per_api.delete_ptnl_ler_for_per

1930: (p_per_in_ler_id => del_inelg_per_rec.per_in_ler_id,
1931: p_object_version_number => del_inelg_per_rec.pil_ovn,
1932: p_effective_date => p_group_lf_evt_ocrd_dt);
1933:
1934: ben_ptnl_ler_for_per_api.delete_ptnl_ler_for_per
1935: (p_ptnl_ler_for_per_id => del_inelg_per_rec.ptnl_ler_for_per_id,
1936: p_object_version_number => del_inelg_per_rec.ptnl_ovn,
1937: p_effective_date => p_group_lf_evt_ocrd_dt);
1938: --

Line 1964: l_ptnl_ler_for_per_id BEN_PTNL_LER_FOR_PER.PTNL_LER_FOR_PER_ID%TYPE;

1960: ,p_pl_id in number
1961: ,p_clone_only_cpg in varchar2 default 'N'
1962: ) is
1963: --
1964: l_ptnl_ler_for_per_id BEN_PTNL_LER_FOR_PER.PTNL_LER_FOR_PER_ID%TYPE;
1965: l_curr_per_in_ler_id number;
1966: l_object_version_number BEN_PTNL_LER_FOR_PER.OBJECT_VERSION_NUMBER%TYPE;
1967: l_pil_object_version_number BEN_PTNL_LER_FOR_PER.OBJECT_VERSION_NUMBER%TYPE;
1968: l_ws_mgr_id number;

Line 1966: l_object_version_number BEN_PTNL_LER_FOR_PER.OBJECT_VERSION_NUMBER%TYPE;

1962: ) is
1963: --
1964: l_ptnl_ler_for_per_id BEN_PTNL_LER_FOR_PER.PTNL_LER_FOR_PER_ID%TYPE;
1965: l_curr_per_in_ler_id number;
1966: l_object_version_number BEN_PTNL_LER_FOR_PER.OBJECT_VERSION_NUMBER%TYPE;
1967: l_pil_object_version_number BEN_PTNL_LER_FOR_PER.OBJECT_VERSION_NUMBER%TYPE;
1968: l_ws_mgr_id number;
1969: l_assignment_id number;
1970: l_ler_id number;

Line 1967: l_pil_object_version_number BEN_PTNL_LER_FOR_PER.OBJECT_VERSION_NUMBER%TYPE;

1963: --
1964: l_ptnl_ler_for_per_id BEN_PTNL_LER_FOR_PER.PTNL_LER_FOR_PER_ID%TYPE;
1965: l_curr_per_in_ler_id number;
1966: l_object_version_number BEN_PTNL_LER_FOR_PER.OBJECT_VERSION_NUMBER%TYPE;
1967: l_pil_object_version_number BEN_PTNL_LER_FOR_PER.OBJECT_VERSION_NUMBER%TYPE;
1968: l_ws_mgr_id number;
1969: l_assignment_id number;
1970: l_ler_id number;
1971: l_procd_dt date;

Line 2074: ben_ptnl_ler_for_per_api.create_ptnl_ler_for_per_perf

2070: hr_utility.set_location('l_ler_id = ' || l_ler_id, 1234);
2071: hr_utility.set_location('p_pl_id = ' || p_pl_id, 1234);
2072: hr_utility.set_location('p_business_group_id = ' || p_business_group_id, 1234);
2073: --
2074: ben_ptnl_ler_for_per_api.create_ptnl_ler_for_per_perf
2075: (p_validate => false,
2076: p_ptnl_ler_for_per_id => l_ptnl_ler_for_per_id,
2077: p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt,
2078: p_ptnl_ler_for_per_stat_cd => 'PROCD',

Line 4052: ben_ptnl_ler_for_per_api.create_ptnl_ler_for_per_perf

4048: l_effective_date := p_group_lf_evt_ocrd_dt;
4049: else
4050: l_effective_date := p_effective_date;
4051: end if;
4052: ben_ptnl_ler_for_per_api.create_ptnl_ler_for_per_perf
4053: (p_validate => false,
4054: p_ptnl_ler_for_per_id => l_ptnl_ler_for_per_id,
4055: p_lf_evt_ocrd_dt => p_group_lf_evt_ocrd_dt,
4056: p_ptnl_ler_for_per_stat_cd => 'PROCD' ,