APPS.BEN_MANAGE_LIFE_EVENTS dependencies on BEN_PTNL_LER_FOR_PER

Line 578: ben_ptnl_ler_for_per_api.create_

574: 23-MAR-00 mhoyes 115.183 - Bug : 4965 : Fixed PLIP and Plan
575: level newly in-eligible problems.
576: - Fixes COBRA related coverage problem.
577: 24-MAR-00 mmogel 115.184 - Added p_ntfn_dt to the call to
578: ben_ptnl_ler_for_per_api.create_
579: ptnl_ler_for_per in Procedure
580: evaluate_life_events (bug 4806/
581: 1247107)
582: 28-MAR-00 mhoyes 115.185 - Fixed benmngle caching issue. Added

Line 3988: ben_ptnl_ler_for_per_api.create_ptnl_ler_for_per_perf

3984: l_mgr_per_in_ler_not_found := true;
3985: --
3986: -- Need to copy potential ler for per.
3987: --
3988: ben_ptnl_ler_for_per_api.create_ptnl_ler_for_per_perf
3989: (p_validate => false,
3990: p_ptnl_ler_for_per_id => l_ptnl_ler_for_per_id,
3991: p_lf_evt_ocrd_dt => l_effective_date,
3992: p_ptnl_ler_for_per_stat_cd => 'PROCD' ,

Line 4501: ben_ptnl_ler_for_per_api.create_ptnl_ler_for_per_perf

4497: l_mgr_per_in_ler_not_found := true;
4498: --
4499: -- Need to copy potential ler for per.
4500: --
4501: ben_ptnl_ler_for_per_api.create_ptnl_ler_for_per_perf
4502: (p_validate => false,
4503: p_ptnl_ler_for_per_id => l_ptnl_ler_for_per_id,
4504: p_lf_evt_ocrd_dt => l_effective_date,
4505: p_ptnl_ler_for_per_stat_cd => 'PROCD' ,

Line 4999: ben_ptnl_ler_for_per ptnl

4995: ptnl.ptnl_ler_for_per_id,
4996: ptnl.object_version_number ptnl_ovn,
4997: pil.object_version_number pil_ovn
4998: from ben_per_in_ler pil,
4999: ben_ptnl_ler_for_per ptnl
5000: where pil.ler_id = p_ler_id
5001: and pil.lf_evt_ocrd_dt = p_lf_evt_ocrd_dt
5002: and pil.person_id = p_person_id
5003: and ptnl.ptnl_ler_for_per_id = pil.ptnl_ler_for_per_id

Line 5050: ben_ptnl_ler_for_per_api.delete_ptnl_ler_for_per

5046: (p_per_in_ler_id => l_pil_rec.per_in_ler_id,
5047: p_object_version_number => l_pil_rec.pil_ovn,
5048: p_effective_date => p_effective_date);
5049:
5050: ben_ptnl_ler_for_per_api.delete_ptnl_ler_for_per
5051: (p_ptnl_ler_for_per_id => l_pil_rec.ptnl_ler_for_per_id,
5052: p_object_version_number => l_pil_rec.ptnl_ovn,
5053: p_effective_date => p_effective_date);
5054:

Line 5089: l_ptnl_ler_for_per_id ben_ptnl_ler_for_per.ptnl_ler_for_per_id%type;

5085: l_ler_id ben_person_actions.ler_id%type;
5086: l_person_id ben_person_actions.person_id%type;
5087: l_person_action_id ben_person_actions.person_action_id%type;
5088: l_object_version_number ben_person_actions.object_version_number%type;
5089: l_ptnl_ler_for_per_id ben_ptnl_ler_for_per.ptnl_ler_for_per_id%type;
5090: l_effective_start_date date;
5091: l_effective_end_date date;
5092: l_dummy varchar2(1);
5093: l_count number := 0;

Line 5122: from ben_ptnl_ler_for_per pfl,

5118: -- absences,gsp
5119: --
5120: cursor c_potential (p_person_id number) is
5121: select ptnl_ler_for_per_id
5122: from ben_ptnl_ler_for_per pfl,
5123: ben_ler_f ler
5124: where pfl.ptnl_ler_for_per_stat_cd not in ('VOIDD','PROCD')
5125: and pfl.person_id = p_person_id
5126: and pfl.ler_id = ler.ler_id

Line 8967: from ben_ptnl_ler_for_per ptn

8963: cv_person_id in number,
8964: cv_business_group_id in number,
8965: cv_lf_evt_ocrd_dt in date) is
8966: select ptn.ptnl_ler_for_per_id
8967: from ben_ptnl_ler_for_per ptn
8968: where ptn.ler_id = cv_ler_id
8969: and ptn.person_id = cv_person_id
8970: and ptn.business_group_id = cv_business_group_id
8971: and ptn.lf_evt_ocrd_dt = cv_lf_evt_ocrd_dt

Line 9085: ben_ptnl_ler_for_per_api.create_ptnl_ler_for_per

9081: --
9082: if g_debug then
9083: hr_utility.set_location('Really created GSP potential',10);
9084: end if;
9085: ben_ptnl_ler_for_per_api.create_ptnl_ler_for_per
9086: (p_validate => false
9087: ,p_ptnl_ler_for_per_id => l_ptnl_ler_for_per_id
9088: ,p_lf_evt_ocrd_dt => l_cv_lf_evt_ocrd_dt
9089: --

Line 9493: ben_ptnl_ler_for_per_api.create_ptnl_ler_for_per

9489: -- end if;
9490: --
9491: if l_rec.per_in_ler_id is null then
9492: --
9493: ben_ptnl_ler_for_per_api.create_ptnl_ler_for_per
9494: (p_validate => false
9495: ,p_ptnl_ler_for_per_id => l_ptnl_ler_for_per_id
9496: --
9497: -- PB : 5422 : need to modify the form.

Line 9520: ben_ptnl_ler_for_per_api.update_ptnl_ler_for_per

9516: if p_ler_id is null then
9517: p_ler_id := l_ler_rec.ler_id;
9518: end if;
9519: --
9520: ben_ptnl_ler_for_per_api.update_ptnl_ler_for_per
9521: (p_validate => false
9522: ,p_object_version_number => l_object_version_number
9523: ,p_ptnl_ler_for_per_id => l_rec.ptnl_ler_for_per_id
9524: ,p_lf_evt_ocrd_dt => p_effective_date

Line 9762: from ben_ptnl_ler_for_per a,

9758: --
9759: cursor c_ptnl is
9760: select a.ptnl_ler_for_per_id ptnl_ler_for_per_id,
9761: a.object_version_number object_version_number
9762: from ben_ptnl_ler_for_per a,
9763: ben_per_in_ler b
9764: where b.per_in_ler_id = l_rec.per_in_ler_id
9765: and b.ptnl_ler_for_per_id = a.ptnl_ler_for_per_id;
9766: --