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

Line 14: (p_ptnl_rec IN OUT NOCOPY BEN_PTNL_LER_FOR_PER%ROWTYPE

10: -- |------------------------< update_ptnl_per_for_ler >-----------------------|
11: -- ----------------------------------------------------------------------------
12: --
13: procedure update_ptnl_per_for_ler
14: (p_ptnl_rec IN OUT NOCOPY BEN_PTNL_LER_FOR_PER%ROWTYPE
15: ,p_effective_date IN DATE) is
16: --
17: l_proc varchar2(72) := g_package||'update_ptnl_per_for_ler';
18: --

Line 29: ben_ptnl_ler_for_per_api.update_ptnl_ler_for_per_perf

25: begin
26: --
27: l_procd_dt := trunc(sysdate);
28: --
29: ben_ptnl_ler_for_per_api.update_ptnl_ler_for_per_perf
30: (p_validate => false
31: ,p_ptnl_ler_for_per_id => p_ptnl_rec.ptnl_ler_for_per_id
32: ,p_lf_evt_ocrd_dt => p_ptnl_rec.lf_evt_ocrd_dt
33: ,p_ptnl_ler_for_per_stat_cd => 'PROCD'

Line 77: from ben_ptnl_ler_for_per pfl,

73: ler.name,
74: pfl.trgr_table_pk_id, -- it is absence_attendance_id
75: ler.lf_evt_oper_cd, -- 9999 lf_evt_oper_cd,
76: ler.typ_cd
77: from ben_ptnl_ler_for_per pfl,
78: ben_ler_f ler
79: where pfl.ptnl_ler_for_per_stat_cd not in ('VOIDD','PROCD')
80: and pfl.person_id = p_person_id
81: and pfl.ler_id = ler.ler_id

Line 108: from ben_ptnl_ler_for_per ptn,

104: l_next_row binary_integer;
105: --
106: cursor c_get_min_ptnl is
107: select min(ptn.lf_evt_ocrd_dt)
108: from ben_ptnl_ler_for_per ptn,
109: ben_ler_f ler
110: where ptn.person_id = p_person_id
111: and ptn.ler_id = ler.ler_id
112: and p_effective_date

Line 123: from ben_ptnl_ler_for_per ptn,

119: and ptn.ptnl_ler_for_per_stat_cd not in ('PROCD','VOIDD');
120: --
121: cursor c_get_ptnl_for_aba is
122: select ptn.ptnl_ler_for_per_id
123: from ben_ptnl_ler_for_per ptn,
124: ben_ler_f ler
125: where ptn.person_id = p_person_id
126: and ptn.business_group_id = p_business_group_id
127: and ptn.ptnl_ler_for_per_stat_cd not in ('PROCD','VOIDD')

Line 138: from ben_ptnl_ler_for_per ptn

134: and ler.lf_evt_oper_cd = 'DELETE';
135: --
136: cursor c_get_ptnl_for_del_aba is
137: select ptn.*
138: from ben_ptnl_ler_for_per ptn
139: where ptn.person_id = p_person_id
140: and ptn.ptnl_ler_for_per_stat_cd not in ('PROCD','VOIDD')
141: and ptn.trgr_table_pk_id = l_potent.trgr_table_pk_id;
142: --

Line 146: from ben_ptnl_ler_for_per ptn,

142: --
143: --
144: cursor c_winning_ptnl_of_same_type is
145: select ler.lf_evt_oper_cd,ptn.*
146: from ben_ptnl_ler_for_per ptn,
147: ben_ler_f ler
148: where ptn.person_id = p_person_id
149: and ptn.ptnl_ler_for_per_stat_cd <> 'VOIDD' -- 9999(it should work) not in ('PROCD','VOIDD')
150: and ptn.trgr_table_pk_id = l_potent.trgr_table_pk_id

Line 169: from ben_ptnl_ler_for_per ptn

165: and date_end is null;
166:
167: cursor c_get_ptnl_for_win_aba is
168: select ptn.*
169: from ben_ptnl_ler_for_per ptn
170: where ptn.person_id = p_person_id
171: and ptn.ptnl_ler_for_per_stat_cd not in ('PROCD','VOIDD')
172: and ptn.ler_id = l_winning_ptnl_rec.ler_id
173: and ptn.trgr_table_pk_id = l_winning_ptnl_rec.trgr_table_pk_id

Line 326: ben_ptnl_ler_for_per_api.update_ptnl_ler_for_per_perf

322: for l_ppl_rec in c_get_ptnl_for_del_aba loop
323: --
324: if l_del_ptnl_ler_for_per_id = l_ppl_rec.ptnl_ler_for_per_id then
325: --
326: ben_ptnl_ler_for_per_api.update_ptnl_ler_for_per_perf
327: (p_validate => false
328: ,p_ptnl_ler_for_per_id => l_ppl_rec.ptnl_ler_for_per_id
329: ,p_lf_evt_ocrd_dt => l_ppl_rec.lf_evt_ocrd_dt
330: ,p_ptnl_ler_for_per_stat_cd => 'PROCD'

Line 344: ben_ptnl_ler_for_per_api.update_ptnl_ler_for_per_perf

340: ,p_program_update_date => sysdate);
341: --
342: else
343: --
344: ben_ptnl_ler_for_per_api.update_ptnl_ler_for_per_perf
345: (p_validate => false
346: ,p_ptnl_ler_for_per_id => l_ppl_rec.ptnl_ler_for_per_id
347: ,p_ptnl_ler_for_per_stat_cd => 'VOIDD'
348: ,p_object_version_number => l_ppl_rec.object_version_number

Line 472: ben_ptnl_ler_for_per_api.update_ptnl_ler_for_per_perf

468: -- Now void all the potentials attached to the current absence.
469: --
470: for l_ppl_rec in c_get_ptnl_for_win_aba loop
471: --
472: ben_ptnl_ler_for_per_api.update_ptnl_ler_for_per_perf
473: (p_validate => false
474: ,p_ptnl_ler_for_per_id => l_ppl_rec.ptnl_ler_for_per_id
475: ,p_ptnl_ler_for_per_stat_cd => 'VOIDD'
476: ,p_object_version_number => l_ppl_rec.object_version_number

Line 570: ben_ptnl_ler_for_per_api.update_ptnl_ler_for_per_perf

566: --
567: --
568: l_procd_dt := trunc(sysdate);
569: --
570: ben_ptnl_ler_for_per_api.update_ptnl_ler_for_per_perf
571: (p_validate => false
572: ,p_ptnl_ler_for_per_id => l_winning_ptnl_rec.ptnl_ler_for_per_id
573: ,p_lf_evt_ocrd_dt => l_winning_ptnl_rec.lf_evt_ocrd_dt
574: ,p_ptnl_ler_for_per_stat_cd => 'PROCD'

Line 660: from ben_ptnl_ler_for_per ptnl

656: --
657: cursor c_ptnl(cv_ptnl_ler_for_per_id in number)
658: is
659: select ptnl.*
660: from ben_ptnl_ler_for_per ptnl
661: where ptnl.ptnl_ler_for_per_id = cv_ptnl_ler_for_per_id;
662: --
663: cursor get_per_in_ler(cv_lf_evt_ocrd_dt date)
664: is

Line 717: l_ptnl_rec ben_ptnl_ler_for_per%rowtype;

713: and ler.typ_cd = 'COMP'
714: order by 3 asc;
715: --
716: l_pil_rec get_per_in_ler%rowtype;
717: l_ptnl_rec ben_ptnl_ler_for_per%rowtype;
718: l_procd_dt date;
719: l_strtd_dt date;
720: l_voidd_dt date;
721: l_object_version_number NUMBER;

Line 969: from ben_ptnl_ler_for_per pfl,

965: pfl.voidd_dt,
966: ler.name,
967: pfl.person_id,
968: pfl.business_group_id
969: from ben_ptnl_ler_for_per pfl,
970: ben_ler_f ler
971: where pfl.ptnl_ler_for_per_stat_cd not in ('VOIDD','PROCD')
972: and pfl.person_id = p_person_id
973: and pfl.ler_id = ler.ler_id

Line 1011: l_ptnl_rec ben_ptnl_ler_for_per%rowtype;

1007: and ler.effective_end_date
1008: and ler.typ_cd = 'GSP'
1009: order by per_in_ler_stat_cd desc, lf_evt_ocrd_dt desc;
1010: --
1011: l_ptnl_rec ben_ptnl_ler_for_per%rowtype;
1012: l_potent get_all_potential%rowtype;
1013: l_min_ptnl get_all_potential%rowtype;
1014: l_recs_found boolean := false;
1015: l_pil_rec ben_per_in_ler%rowtype;

Line 1249: ben_ptnl_ler_for_per_api.update_ptnl_ler_for_per_perf

1245: benutils.write(p_rec => g_rec);
1246: --
1247: -- update ptnl
1248: --
1249: ben_ptnl_ler_for_per_api.update_ptnl_ler_for_per_perf
1250: (p_validate => false
1251: ,p_ptnl_ler_for_per_id => l_min_ptnl.ptnl_ler_for_per_id
1252: ,p_lf_evt_ocrd_dt => l_min_ptnl.lf_evt_ocrd_dt
1253: ,p_ptnl_ler_for_per_stat_cd => 'PROCD'

Line 1298: from ben_ptnl_ler_for_per pfl,

1294: pfl.ntfn_dt,
1295: pfl.dtctd_dt,
1296: pfl.voidd_dt,
1297: ler.name
1298: from ben_ptnl_ler_for_per pfl,
1299: ben_ler_f ler
1300: where pfl.ptnl_ler_for_per_stat_cd not in ('VOIDD','PROCD')
1301: and pfl.person_id = p_person_id
1302: and pfl.ler_id = ler.ler_id

Line 1317: l_ptnl_rec ben_ptnl_ler_for_per%rowtype;

1313: --
1314: and ler.typ_cd not in ( 'COMP', 'ABS', 'GSP', 'IREC') -- iRec
1315: order by pfl.lf_evt_ocrd_dt asc;
1316: --
1317: l_ptnl_rec ben_ptnl_ler_for_per%rowtype;
1318: --
1319: l_pil_rec ben_per_in_ler%rowtype;
1320: --
1321: -- Bug 3179 : pil processed or started and a ptnl is created on the

Line 1445: l_ptnl_ler_for_per_id BEN_PTNL_LER_FOR_PER.PTNL_LER_FOR_PER_ID%TYPE;

1441: l_deadlock_per_in_ler get_current_per_in_ler%rowtype;
1442: l_current_per_in_ler get_current_per_in_ler%rowtype;
1443: l_curr_per_in_ler_id number;
1444: l_ovridg_le_flag BEN_LER_F.OVRIDG_LE_FLAG%TYPE;
1445: l_ptnl_ler_for_per_id BEN_PTNL_LER_FOR_PER.PTNL_LER_FOR_PER_ID%TYPE;
1446: l_lf_evt_ocrd_dt BEN_PTNL_LER_FOR_PER.LF_EVT_OCRD_DT%TYPE;
1447: l_creation_date BEN_PTNL_LER_FOR_PER.CREATION_DATE%TYPE;
1448: l_ntfn_dt BEN_PTNL_LER_FOR_PER.NTFN_DT%TYPE;
1449: l_win_ler_id BEN_LER_F.LER_ID%TYPE;

Line 1446: l_lf_evt_ocrd_dt BEN_PTNL_LER_FOR_PER.LF_EVT_OCRD_DT%TYPE;

1442: l_current_per_in_ler get_current_per_in_ler%rowtype;
1443: l_curr_per_in_ler_id number;
1444: l_ovridg_le_flag BEN_LER_F.OVRIDG_LE_FLAG%TYPE;
1445: l_ptnl_ler_for_per_id BEN_PTNL_LER_FOR_PER.PTNL_LER_FOR_PER_ID%TYPE;
1446: l_lf_evt_ocrd_dt BEN_PTNL_LER_FOR_PER.LF_EVT_OCRD_DT%TYPE;
1447: l_creation_date BEN_PTNL_LER_FOR_PER.CREATION_DATE%TYPE;
1448: l_ntfn_dt BEN_PTNL_LER_FOR_PER.NTFN_DT%TYPE;
1449: l_win_ler_id BEN_LER_F.LER_ID%TYPE;
1450: l_norm_ler_id BEN_LER_F.LER_ID%TYPE;

Line 1447: l_creation_date BEN_PTNL_LER_FOR_PER.CREATION_DATE%TYPE;

1443: l_curr_per_in_ler_id number;
1444: l_ovridg_le_flag BEN_LER_F.OVRIDG_LE_FLAG%TYPE;
1445: l_ptnl_ler_for_per_id BEN_PTNL_LER_FOR_PER.PTNL_LER_FOR_PER_ID%TYPE;
1446: l_lf_evt_ocrd_dt BEN_PTNL_LER_FOR_PER.LF_EVT_OCRD_DT%TYPE;
1447: l_creation_date BEN_PTNL_LER_FOR_PER.CREATION_DATE%TYPE;
1448: l_ntfn_dt BEN_PTNL_LER_FOR_PER.NTFN_DT%TYPE;
1449: l_win_ler_id BEN_LER_F.LER_ID%TYPE;
1450: l_norm_ler_id BEN_LER_F.LER_ID%TYPE;
1451: l_ler_id BEN_LER_F.LER_ID%TYPE;

Line 1448: l_ntfn_dt BEN_PTNL_LER_FOR_PER.NTFN_DT%TYPE;

1444: l_ovridg_le_flag BEN_LER_F.OVRIDG_LE_FLAG%TYPE;
1445: l_ptnl_ler_for_per_id BEN_PTNL_LER_FOR_PER.PTNL_LER_FOR_PER_ID%TYPE;
1446: l_lf_evt_ocrd_dt BEN_PTNL_LER_FOR_PER.LF_EVT_OCRD_DT%TYPE;
1447: l_creation_date BEN_PTNL_LER_FOR_PER.CREATION_DATE%TYPE;
1448: l_ntfn_dt BEN_PTNL_LER_FOR_PER.NTFN_DT%TYPE;
1449: l_win_ler_id BEN_LER_F.LER_ID%TYPE;
1450: l_norm_ler_id BEN_LER_F.LER_ID%TYPE;
1451: l_ler_id BEN_LER_F.LER_ID%TYPE;
1452: l_ler_typ_cd BEN_LER_F.TYP_CD%TYPE;

Line 1461: l_min_creation_date BEN_PTNL_LER_FOR_PER.creation_date%type;

1457: l_min_tmlns_eval_cd BEN_LER_F.tmlns_eval_cd%type;
1458: l_min_tmlns_dys_num BEN_LER_F.tmlns_dys_num%type;
1459: l_min_tmlns_perd_cd BEN_LER_F.tmlns_perd_cd%type;
1460: l_min_tmlns_perd_rl BEN_LER_F.tmlns_perd_rl%type;
1461: l_min_creation_date BEN_PTNL_LER_FOR_PER.creation_date%type;
1462: l_object_version_number BEN_PTNL_LER_FOR_PER.OBJECT_VERSION_NUMBER%TYPE;
1463: l_proc varchar2(72) := g_package||'eval_ptnl_per_for_ler';
1464: l_created_ler varchar(2) := 'N';
1465: l_dummy varchar2(1);

Line 1462: l_object_version_number BEN_PTNL_LER_FOR_PER.OBJECT_VERSION_NUMBER%TYPE;

1458: l_min_tmlns_dys_num BEN_LER_F.tmlns_dys_num%type;
1459: l_min_tmlns_perd_cd BEN_LER_F.tmlns_perd_cd%type;
1460: l_min_tmlns_perd_rl BEN_LER_F.tmlns_perd_rl%type;
1461: l_min_creation_date BEN_PTNL_LER_FOR_PER.creation_date%type;
1462: l_object_version_number BEN_PTNL_LER_FOR_PER.OBJECT_VERSION_NUMBER%TYPE;
1463: l_proc varchar2(72) := g_package||'eval_ptnl_per_for_ler';
1464: l_created_ler varchar(2) := 'N';
1465: l_dummy varchar2(1);
1466: l_num_winners number := 0;

Line 1525: (p_ptnl_rec IN OUT NOCOPY BEN_PTNL_LER_FOR_PER%ROWTYPE

1521: -- |------------------------< update_ptnl_per_for_ler >-----------------------|
1522: -- ----------------------------------------------------------------------------
1523: --
1524: procedure update_ptnl_per_for_ler
1525: (p_ptnl_rec IN OUT NOCOPY BEN_PTNL_LER_FOR_PER%ROWTYPE
1526: ,p_effective_date IN DATE) is
1527: --
1528: l_proc varchar2(72) := g_package||'update_ptnl_per_for_ler';
1529: --

Line 1540: ben_ptnl_ler_for_per_api.update_ptnl_ler_for_per_perf

1536: begin
1537: --
1538: l_procd_dt := trunc(sysdate);
1539: --
1540: ben_ptnl_ler_for_per_api.update_ptnl_ler_for_per_perf
1541: (p_validate => false
1542: ,p_ptnl_ler_for_per_id => p_ptnl_rec.ptnl_ler_for_per_id
1543: ,p_lf_evt_ocrd_dt => p_ptnl_rec.lf_evt_ocrd_dt
1544: ,p_ptnl_ler_for_per_stat_cd => 'PROCD'

Line 1562: (p_ptnl_rec IN out NOCOPY BEN_PTNL_LER_FOR_PER%ROWTYPE

1558: -- ------------------------------------------------------------------------
1559: -- |------------------------< insert_per_in_ler >-------------------------|
1560: -- ------------------------------------------------------------------------
1561: procedure insert_per_in_ler
1562: (p_ptnl_rec IN out NOCOPY BEN_PTNL_LER_FOR_PER%ROWTYPE
1563: ,p_curr_per_in_ler_id out NOCOPY number
1564: ,p_effective_date IN DATE) is
1565: --
1566: l_per_in_ler_id NUMBER;

Line 1654: from ben_ptnl_ler_for_per ptn,

1650: ptn.lf_evt_ocrd_dt,
1651: ptn.ptnl_ler_for_per_id,
1652: ptn.ler_id,
1653: ptn.object_version_number
1654: from ben_ptnl_ler_for_per ptn,
1655: ben_ler_f ler
1656: where ler.ler_id = ptn.ler_id
1657: and ler.business_group_id = p_business_group_id
1658: and ptn.ptnl_ler_for_per_stat_cd not in ('PROCD','VOIDD', 'MNLO')

Line 1804: ben_ptnl_ler_for_per_api.update_ptnl_ler_for_per_perf

1800: -- that the event has been voided
1801: --
1802: l_action_happened := true;
1803: --
1804: ben_ptnl_ler_for_per_api.update_ptnl_ler_for_per_perf
1805: (p_validate => false
1806: ,p_ptnl_ler_for_per_id => l_potent.ptnl_ler_for_per_id
1807: ,p_ptnl_ler_for_per_stat_cd => 'VOIDD'
1808: ,p_object_version_number => l_potent.object_version_number

Line 1859: ben_ptnl_ler_for_per_api.update_ptnl_ler_for_per_perf

1855: --
1856: -- We need to void the event and raise a message informing
1857: -- the user that the event has been voided
1858: --
1859: ben_ptnl_ler_for_per_api.update_ptnl_ler_for_per_perf
1860: (p_validate => false
1861: ,p_ptnl_ler_for_per_id => l_potent.ptnl_ler_for_per_id
1862: ,p_ptnl_ler_for_per_stat_cd => 'VOIDD'
1863: ,p_object_version_number => l_potent.object_version_number

Line 1943: ben_ptnl_ler_for_per_api.update_ptnl_ler_for_per_perf

1939: --
1940: -- We need to void the event and raise a message informing
1941: -- the user that the event has been voided
1942: --
1943: ben_ptnl_ler_for_per_api.update_ptnl_ler_for_per_perf
1944: (p_validate => false
1945: ,p_ptnl_ler_for_per_id => l_potent.ptnl_ler_for_per_id
1946: ,p_ptnl_ler_for_per_stat_cd => 'VOIDD'
1947: ,p_object_version_number => l_potent.object_version_number

Line 2008: ben_ptnl_ler_for_per_api.update_ptnl_ler_for_per_perf

2004: > l_potent.tmlns_dys_num then
2005: --
2006: l_action_happened := true;
2007: --
2008: ben_ptnl_ler_for_per_api.update_ptnl_ler_for_per_perf
2009: (p_validate => false
2010: ,p_ptnl_ler_for_per_id => l_potent.ptnl_ler_for_per_id
2011: ,p_ptnl_ler_for_per_stat_cd => 'MNL'
2012: ,p_object_version_number => l_potent.object_version_number

Line 2037: ben_ptnl_ler_for_per_api.update_ptnl_ler_for_per_perf

2033: --
2034: if abs(to_number(to_char(l_potent.ntfn_dt,'YYYY')) -
2035: to_number(to_char(l_potent.lf_evt_ocrd_dt,'YYYY'))) >= 1 then
2036: --
2037: ben_ptnl_ler_for_per_api.update_ptnl_ler_for_per_perf
2038: (p_validate => false
2039: ,p_ptnl_ler_for_per_id => l_potent.ptnl_ler_for_per_id
2040: ,p_ptnl_ler_for_per_stat_cd => 'MNL'
2041: ,p_object_version_number => l_potent.object_version_number

Line 2099: ben_ptnl_ler_for_per_api.update_ptnl_ler_for_per_perf

2095: -- We need to void the event and raise a message informing
2096: -- the user that the event has been voided
2097: -- Bug 4217795 set status to manual
2098: --
2099: ben_ptnl_ler_for_per_api.update_ptnl_ler_for_per_perf
2100: (p_validate => false
2101: ,p_ptnl_ler_for_per_id => l_potent.ptnl_ler_for_per_id
2102: ,p_ptnl_ler_for_per_stat_cd => 'MNL'
2103: ,p_object_version_number => l_potent.object_version_number

Line 2280: from ben_ptnl_ler_for_per ptn,

2276: -- CWB Changes : Cursor joined to ben_ler_f
2277: --
2278: cursor c1 is
2279: select min(ptn.lf_evt_ocrd_dt)
2280: from ben_ptnl_ler_for_per ptn,
2281: ben_ler_f ler
2282: where ptn.person_id = p_person_id
2283: and ptn.ler_id = ler.ler_id
2284: and p_effective_date

Line 2582: ben_ptnl_ler_for_per_api.create_ptnl_ler_for_per_perf

2578: l_unprocd_dt := sysdate;
2579: end if;
2580:
2581: --
2582: ben_ptnl_ler_for_per_api.create_ptnl_ler_for_per_perf
2583: (p_validate => false,
2584: p_ptnl_ler_for_per_id => l_ptnl_ler_for_per_id,
2585: p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt,
2586: p_ptnl_ler_for_per_stat_cd => l_ptnl_ler_for_per_stat_cd_use,

Line 2602: ben_ptnl_ler_for_per_api.update_ptnl_ler_for_per_perf

2598: p_program_update_date => sysdate);
2599: --
2600: -- hr_utility.set_location('Step 5 ' ,195);
2601: if l_ptnl_ler_for_per_stat_cd = 'MNL' then
2602: ben_ptnl_ler_for_per_api.update_ptnl_ler_for_per_perf
2603: (p_ptnl_ler_for_per_id => l_ptnl_ler_for_per_id,
2604: p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt,
2605: p_ler_id => l_ler_id,
2606: p_ntfn_dt => l_ntfn_dt,

Line 2640: -- We need to update the ben_ptnl_ler_for_per record in order

2636: */
2637: --End Bug 14137075:
2638: --
2639: -- The rule has reset some values on the ptnl per for ler.
2640: -- We need to update the ben_ptnl_ler_for_per record in order
2641: -- to reflect the evaluated rule.
2642: --
2643: l_object_version_number := p_object_version_number;
2644: --

Line 2645: ben_ptnl_ler_for_per_api.update_ptnl_ler_for_per_perf

2641: -- to reflect the evaluated rule.
2642: --
2643: l_object_version_number := p_object_version_number;
2644: --
2645: ben_ptnl_ler_for_per_api.update_ptnl_ler_for_per_perf
2646: (p_ptnl_ler_for_per_id => p_ptnl_ler_for_per_id,
2647: p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt,
2648: p_ler_id => p_ler_id,
2649: p_ntfn_dt => l_ntfn_dt,

Line 2693: p_ptnl_rec out NOCOPY ben_ptnl_ler_for_per%rowtype) is

2689: (p_lf_evt_ocrd_dt in date,
2690: p_person_id in number,
2691: p_business_group_id in number,
2692: p_effective_date in date,
2693: p_ptnl_rec out NOCOPY ben_ptnl_ler_for_per%rowtype) is
2694: --
2695: l_proc varchar2(72) := g_package||'check_and_get_winner';
2696: l_num_recs number := 0;
2697: l_num_winners number := 0;

Line 2706: from ben_ptnl_ler_for_per ppl,

2702: cursor c1 is
2703: select ler.ovridg_le_flag,
2704: ppl.ptnl_ler_for_per_id,
2705: ler.name
2706: from ben_ptnl_ler_for_per ppl,
2707: ben_ler_f ler
2708: where ppl.person_id = p_person_id
2709: and ppl.ler_id = ler.ler_id
2710: and ppl.business_group_id = p_business_group_id

Line 2748: from ben_ptnl_ler_for_per ppl,

2744: --
2745: cursor c_ptnl is
2746: select ppl.object_version_number,
2747: ppl.ptnl_ler_for_per_id
2748: from ben_ptnl_ler_for_per ppl,
2749: ben_ler_f ler
2750: where ppl.person_id = p_person_id
2751: and ppl.business_group_id = p_business_group_id
2752: and ppl.lf_evt_ocrd_dt = p_lf_evt_ocrd_dt

Line 2765: from ben_ptnl_ler_for_per ptn

2761: -- CWB Changes End
2762: --
2763: cursor c2 is
2764: select *
2765: from ben_ptnl_ler_for_per ptn
2766: where ptn.ptnl_ler_for_per_id = l_search_ptnl_ler_for_per_id;
2767: --
2768: -- Bug 1146792 (4285) : Modified check_and_get_winner -
2769: -- Back out the per in ler's before determining

Line 2797: from ben_ptnl_ler_for_per ptnl

2793: l_per_in_ler_id number;
2794: --
2795: cursor c_ptnl_ovn(v_ptnl_ler_for_per_id number) is
2796: select ptnl.object_version_number
2797: from ben_ptnl_ler_for_per ptnl
2798: where ptnl.ptnl_ler_for_per_id = v_ptnl_ler_for_per_id
2799: and ptnl.business_group_id = p_business_group_id;
2800: --
2801: l_ptnl_ovn number;

Line 2920: ben_ptnl_ler_for_per_api.update_ptnl_ler_for_per_perf

2916: fetch c_ptnl_ovn into l_ptnl_ovn;
2917: close c_ptnl_ovn;
2918: */
2919: --
2920: ben_ptnl_ler_for_per_api.update_ptnl_ler_for_per_perf
2921: (p_validate => false
2922: ,p_ptnl_ler_for_per_id => l_ptnl.ptnl_ler_for_per_id
2923: ,p_ptnl_ler_for_per_stat_cd => 'VOIDD'
2924: ,p_object_version_number => l_ptnl.object_version_number

Line 3002: from ben_ptnl_ler_for_per ptn,

2998: -- CWB Changes : Cursor joined to ben_ler_f
2999: --
3000: cursor c1 is
3001: select min(ptn.lf_evt_ocrd_dt)
3002: from ben_ptnl_ler_for_per ptn,
3003: ben_ler_f ler
3004: where ptn.person_id = p_person_id
3005: and ptn.ler_id = ler.ler_id
3006: and p_effective_date

Line 3128: ben_ptnl_ler_for_per_api.update_ptnl_ler_for_per_perf

3124: --
3125: -- The life event didn't happen so void it
3126: --
3127: hr_utility.set_location('After call to rule_evaluates ',19);
3128: ben_ptnl_ler_for_per_api.update_ptnl_ler_for_per_perf
3129: (p_ptnl_ler_for_per_id => l_potent.ptnl_ler_for_per_id,
3130: p_object_version_number => l_potent.object_version_number,
3131: p_ptnl_ler_for_per_stat_cd => 'VOIDD',
3132: p_effective_date => p_effective_date,

Line 3291: -- update BEN_PTNL_LER_FOR_PER setting to processed

3287: hr_utility.set_location('active LED '||l_current_per_in_ler.lf_evt_ocrd_dt,10);
3288: hr_utility.set_location('ptnl LED '||l_ptnl_rec.lf_evt_ocrd_dt,10);
3289: -- If no PER_IN_LER exists then we
3290: -- insert PTNL into PER_IN_LER
3291: -- update BEN_PTNL_LER_FOR_PER setting to processed
3292: --
3293: -- else
3294: -- We now we have the minimum PTNL PER_IN_LER
3295: -- and the date of the current PER in LER

Line 3370: ben_ptnl_ler_for_per_api.update_ptnl_ler_for_per_perf

3366: -- on same day.
3367: --
3368: if l_deadlock_per_in_ler.per_in_ler_id is not null then
3369: --
3370: ben_ptnl_ler_for_per_api.update_ptnl_ler_for_per_perf
3371: (p_validate => false
3372: ,p_ptnl_ler_for_per_id => l_ptnl_rec.ptnl_ler_for_per_id
3373: ,p_ptnl_ler_for_per_stat_cd => 'MNL'
3374: ,p_object_version_number => l_ptnl_rec.object_version_number

Line 3571: from ben_ptnl_ler_for_per ptnl

3567: --
3568: cursor c_ptnl(cv_ptnl_ler_for_per_id in number)
3569: is
3570: select ptnl.*
3571: from ben_ptnl_ler_for_per ptnl
3572: where ptnl.ptnl_ler_for_per_id = cv_ptnl_ler_for_per_id;
3573: --
3574: cursor get_per_in_ler(cv_assignment_id number,
3575: cv_person_id number,

Line 3616: l_ptnl_rec ben_ptnl_ler_for_per%rowtype;

3612: and pel.per_in_ler_id = pil.per_in_ler_id
3613: and pel.business_group_id = pil.business_group_id;
3614: --
3615: l_pil_rec get_per_in_ler%rowtype;
3616: l_ptnl_rec ben_ptnl_ler_for_per%rowtype;
3617: l_procd_dt date;
3618: l_strtd_dt date;
3619: l_voidd_dt date;
3620: l_ntfn_dt date;

Line 3757: ben_ptnl_ler_for_per_api.update_ptnl_ler_for_per_perf

3753: -- if l_ptnl_rec.lf_evt_ocrd_dt <> p_lf_evt_ocrd_dt then
3754: --
3755: -- update the potential record.
3756: --
3757: ben_ptnl_ler_for_per_api.update_ptnl_ler_for_per_perf
3758: (p_validate => false
3759: ,p_ptnl_ler_for_per_id => l_ptnl_rec.ptnl_ler_for_per_id
3760: ,p_ptnl_ler_for_per_stat_cd => 'PROCD'
3761: ,p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt

Line 3781: ben_ptnl_ler_for_per_api.create_ptnl_ler_for_per_perf

3777: else
3778: --
3779: -- Create potential.
3780: --
3781: ben_ptnl_ler_for_per_api.create_ptnl_ler_for_per_perf
3782: (p_validate => false,
3783: p_ptnl_ler_for_per_id => l_ptnl_rec.ptnl_ler_for_per_id,
3784: p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt,
3785: p_ptnl_ler_for_per_stat_cd => 'PROCD',