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 4380: ben_ptnl_ler_for_per_api.create_ptnl_ler_for_per_perf

4376: l_mgr_per_in_ler_not_found := true;
4377: --
4378: -- Need to copy potential ler for per.
4379: --
4380: ben_ptnl_ler_for_per_api.create_ptnl_ler_for_per_perf
4381: (p_validate => false,
4382: p_ptnl_ler_for_per_id => l_ptnl_ler_for_per_id,
4383: p_lf_evt_ocrd_dt => l_effective_date,
4384: p_ptnl_ler_for_per_stat_cd => 'PROCD' ,

Line 4893: ben_ptnl_ler_for_per_api.create_ptnl_ler_for_per_perf

4889: l_mgr_per_in_ler_not_found := true;
4890: --
4891: -- Need to copy potential ler for per.
4892: --
4893: ben_ptnl_ler_for_per_api.create_ptnl_ler_for_per_perf
4894: (p_validate => false,
4895: p_ptnl_ler_for_per_id => l_ptnl_ler_for_per_id,
4896: p_lf_evt_ocrd_dt => l_effective_date,
4897: p_ptnl_ler_for_per_stat_cd => 'PROCD' ,

Line 5391: ben_ptnl_ler_for_per ptnl

5387: ptnl.ptnl_ler_for_per_id,
5388: ptnl.object_version_number ptnl_ovn,
5389: pil.object_version_number pil_ovn
5390: from ben_per_in_ler pil,
5391: ben_ptnl_ler_for_per ptnl
5392: where pil.ler_id = p_ler_id
5393: and pil.lf_evt_ocrd_dt = p_lf_evt_ocrd_dt
5394: and pil.person_id = p_person_id
5395: and ptnl.ptnl_ler_for_per_id = pil.ptnl_ler_for_per_id

Line 5442: ben_ptnl_ler_for_per_api.delete_ptnl_ler_for_per

5438: (p_per_in_ler_id => l_pil_rec.per_in_ler_id,
5439: p_object_version_number => l_pil_rec.pil_ovn,
5440: p_effective_date => p_effective_date);
5441:
5442: ben_ptnl_ler_for_per_api.delete_ptnl_ler_for_per
5443: (p_ptnl_ler_for_per_id => l_pil_rec.ptnl_ler_for_per_id,
5444: p_object_version_number => l_pil_rec.ptnl_ovn,
5445: p_effective_date => p_effective_date);
5446:

Line 5481: l_ptnl_ler_for_per_id ben_ptnl_ler_for_per.ptnl_ler_for_per_id%type;

5477: l_ler_id ben_person_actions.ler_id%type;
5478: l_person_id ben_person_actions.person_id%type;
5479: l_person_action_id ben_person_actions.person_action_id%type;
5480: l_object_version_number ben_person_actions.object_version_number%type;
5481: l_ptnl_ler_for_per_id ben_ptnl_ler_for_per.ptnl_ler_for_per_id%type;
5482: l_effective_start_date date;
5483: l_effective_end_date date;
5484: l_dummy varchar2(1);
5485: l_count number := 0;

Line 5514: from ben_ptnl_ler_for_per pfl,

5510: -- absences,gsp
5511: --
5512: cursor c_potential (p_person_id number) is
5513: select ptnl_ler_for_per_id
5514: from ben_ptnl_ler_for_per pfl,
5515: ben_ler_f ler
5516: where pfl.ptnl_ler_for_per_stat_cd not in ('VOIDD','PROCD')
5517: and pfl.person_id = p_person_id
5518: and pfl.ler_id = ler.ler_id

Line 9375: from ben_ptnl_ler_for_per ptn

9371: cv_person_id in number,
9372: cv_business_group_id in number,
9373: cv_lf_evt_ocrd_dt in date) is
9374: select ptn.ptnl_ler_for_per_id
9375: from ben_ptnl_ler_for_per ptn
9376: where ptn.ler_id = cv_ler_id
9377: and ptn.person_id = cv_person_id
9378: and ptn.business_group_id = cv_business_group_id
9379: and ptn.lf_evt_ocrd_dt = cv_lf_evt_ocrd_dt

Line 9493: ben_ptnl_ler_for_per_api.create_ptnl_ler_for_per

9489: --
9490: if g_debug then
9491: hr_utility.set_location('Really created GSP potential',10);
9492: end if;
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: ,p_lf_evt_ocrd_dt => l_cv_lf_evt_ocrd_dt
9497: --

Line 9901: ben_ptnl_ler_for_per_api.create_ptnl_ler_for_per

9897: -- end if;
9898: --
9899: if l_rec.per_in_ler_id is null then
9900: --
9901: ben_ptnl_ler_for_per_api.create_ptnl_ler_for_per
9902: (p_validate => false
9903: ,p_ptnl_ler_for_per_id => l_ptnl_ler_for_per_id
9904: --
9905: -- PB : 5422 : need to modify the form.

Line 9928: ben_ptnl_ler_for_per_api.update_ptnl_ler_for_per

9924: if p_ler_id is null then
9925: p_ler_id := l_ler_rec.ler_id;
9926: end if;
9927: --
9928: ben_ptnl_ler_for_per_api.update_ptnl_ler_for_per
9929: (p_validate => false
9930: ,p_object_version_number => l_object_version_number
9931: ,p_ptnl_ler_for_per_id => l_rec.ptnl_ler_for_per_id
9932: ,p_lf_evt_ocrd_dt => p_effective_date

Line 10170: from ben_ptnl_ler_for_per a,

10166: --
10167: cursor c_ptnl is
10168: select a.ptnl_ler_for_per_id ptnl_ler_for_per_id,
10169: a.object_version_number object_version_number
10170: from ben_ptnl_ler_for_per a,
10171: ben_per_in_ler b
10172: where b.per_in_ler_id = l_rec.per_in_ler_id
10173: and b.ptnl_ler_for_per_id = a.ptnl_ler_for_per_id;
10174: --