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

2471: l_unprocd_dt := sysdate;
2472: end if;
2473:
2474: --
2475: ben_ptnl_ler_for_per_api.create_ptnl_ler_for_per_perf
2476: (p_validate => false,
2477: p_ptnl_ler_for_per_id => l_ptnl_ler_for_per_id,
2478: p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt,
2479: p_ptnl_ler_for_per_stat_cd => l_ptnl_ler_for_per_stat_cd_use,

Line 2495: ben_ptnl_ler_for_per_api.update_ptnl_ler_for_per_perf

2491: p_program_update_date => sysdate);
2492: --
2493: -- hr_utility.set_location('Step 5 ' ,195);
2494: if l_ptnl_ler_for_per_stat_cd = 'MNL' then
2495: ben_ptnl_ler_for_per_api.update_ptnl_ler_for_per_perf
2496: (p_ptnl_ler_for_per_id => l_ptnl_ler_for_per_id,
2497: p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt,
2498: p_ler_id => l_ler_id,
2499: p_ntfn_dt => l_ntfn_dt,

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

2520: --
2521: end if;
2522: --
2523: -- The rule has reset some values on the ptnl per for ler.
2524: -- We need to update the ben_ptnl_ler_for_per record in order
2525: -- to reflect the evaluated rule.
2526: --
2527: l_object_version_number := p_object_version_number;
2528: --

Line 2529: ben_ptnl_ler_for_per_api.update_ptnl_ler_for_per_perf

2525: -- to reflect the evaluated rule.
2526: --
2527: l_object_version_number := p_object_version_number;
2528: --
2529: ben_ptnl_ler_for_per_api.update_ptnl_ler_for_per_perf
2530: (p_ptnl_ler_for_per_id => p_ptnl_ler_for_per_id,
2531: p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt,
2532: p_ler_id => p_ler_id,
2533: p_ntfn_dt => l_ntfn_dt,

Line 2563: p_ptnl_rec out NOCOPY ben_ptnl_ler_for_per%rowtype) is

2559: (p_lf_evt_ocrd_dt in date,
2560: p_person_id in number,
2561: p_business_group_id in number,
2562: p_effective_date in date,
2563: p_ptnl_rec out NOCOPY ben_ptnl_ler_for_per%rowtype) is
2564: --
2565: l_proc varchar2(72) := g_package||'check_and_get_winner';
2566: l_num_recs number := 0;
2567: l_num_winners number := 0;

Line 2576: from ben_ptnl_ler_for_per ppl,

2572: cursor c1 is
2573: select ler.ovridg_le_flag,
2574: ppl.ptnl_ler_for_per_id,
2575: ler.name
2576: from ben_ptnl_ler_for_per ppl,
2577: ben_ler_f ler
2578: where ppl.person_id = p_person_id
2579: and ppl.ler_id = ler.ler_id
2580: and ppl.business_group_id = p_business_group_id

Line 2618: from ben_ptnl_ler_for_per ppl,

2614: --
2615: cursor c_ptnl is
2616: select ppl.object_version_number,
2617: ppl.ptnl_ler_for_per_id
2618: from ben_ptnl_ler_for_per ppl,
2619: ben_ler_f ler
2620: where ppl.person_id = p_person_id
2621: and ppl.business_group_id = p_business_group_id
2622: and ppl.lf_evt_ocrd_dt = p_lf_evt_ocrd_dt

Line 2635: from ben_ptnl_ler_for_per ptn

2631: -- CWB Changes End
2632: --
2633: cursor c2 is
2634: select *
2635: from ben_ptnl_ler_for_per ptn
2636: where ptn.ptnl_ler_for_per_id = l_search_ptnl_ler_for_per_id;
2637: --
2638: -- Bug 1146792 (4285) : Modified check_and_get_winner -
2639: -- Back out the per in ler's before determining

Line 2667: from ben_ptnl_ler_for_per ptnl

2663: l_per_in_ler_id number;
2664: --
2665: cursor c_ptnl_ovn(v_ptnl_ler_for_per_id number) is
2666: select ptnl.object_version_number
2667: from ben_ptnl_ler_for_per ptnl
2668: where ptnl.ptnl_ler_for_per_id = v_ptnl_ler_for_per_id
2669: and ptnl.business_group_id = p_business_group_id;
2670: --
2671: l_ptnl_ovn number;

Line 2790: ben_ptnl_ler_for_per_api.update_ptnl_ler_for_per_perf

2786: fetch c_ptnl_ovn into l_ptnl_ovn;
2787: close c_ptnl_ovn;
2788: */
2789: --
2790: ben_ptnl_ler_for_per_api.update_ptnl_ler_for_per_perf
2791: (p_validate => false
2792: ,p_ptnl_ler_for_per_id => l_ptnl.ptnl_ler_for_per_id
2793: ,p_ptnl_ler_for_per_stat_cd => 'VOIDD'
2794: ,p_object_version_number => l_ptnl.object_version_number

Line 2872: from ben_ptnl_ler_for_per ptn,

2868: -- CWB Changes : Cursor joined to ben_ler_f
2869: --
2870: cursor c1 is
2871: select min(ptn.lf_evt_ocrd_dt)
2872: from ben_ptnl_ler_for_per ptn,
2873: ben_ler_f ler
2874: where ptn.person_id = p_person_id
2875: and ptn.ler_id = ler.ler_id
2876: and p_effective_date

Line 2998: ben_ptnl_ler_for_per_api.update_ptnl_ler_for_per_perf

2994: --
2995: -- The life event didn't happen so void it
2996: --
2997: hr_utility.set_location('After call to rule_evaluates ',19);
2998: ben_ptnl_ler_for_per_api.update_ptnl_ler_for_per_perf
2999: (p_ptnl_ler_for_per_id => l_potent.ptnl_ler_for_per_id,
3000: p_object_version_number => l_potent.object_version_number,
3001: p_ptnl_ler_for_per_stat_cd => 'VOIDD',
3002: p_effective_date => p_effective_date,

Line 3161: -- update BEN_PTNL_LER_FOR_PER setting to processed

3157: hr_utility.set_location('active LED '||l_current_per_in_ler.lf_evt_ocrd_dt,10);
3158: hr_utility.set_location('ptnl LED '||l_ptnl_rec.lf_evt_ocrd_dt,10);
3159: -- If no PER_IN_LER exists then we
3160: -- insert PTNL into PER_IN_LER
3161: -- update BEN_PTNL_LER_FOR_PER setting to processed
3162: --
3163: -- else
3164: -- We now we have the minimum PTNL PER_IN_LER
3165: -- and the date of the current PER in LER

Line 3240: ben_ptnl_ler_for_per_api.update_ptnl_ler_for_per_perf

3236: -- on same day.
3237: --
3238: if l_deadlock_per_in_ler.per_in_ler_id is not null then
3239: --
3240: ben_ptnl_ler_for_per_api.update_ptnl_ler_for_per_perf
3241: (p_validate => false
3242: ,p_ptnl_ler_for_per_id => l_ptnl_rec.ptnl_ler_for_per_id
3243: ,p_ptnl_ler_for_per_stat_cd => 'MNL'
3244: ,p_object_version_number => l_ptnl_rec.object_version_number

Line 3441: from ben_ptnl_ler_for_per ptnl

3437: --
3438: cursor c_ptnl(cv_ptnl_ler_for_per_id in number)
3439: is
3440: select ptnl.*
3441: from ben_ptnl_ler_for_per ptnl
3442: where ptnl.ptnl_ler_for_per_id = cv_ptnl_ler_for_per_id;
3443: --
3444: cursor get_per_in_ler(cv_assignment_id number,
3445: cv_person_id number,

Line 3486: l_ptnl_rec ben_ptnl_ler_for_per%rowtype;

3482: and pel.per_in_ler_id = pil.per_in_ler_id
3483: and pel.business_group_id = pil.business_group_id;
3484: --
3485: l_pil_rec get_per_in_ler%rowtype;
3486: l_ptnl_rec ben_ptnl_ler_for_per%rowtype;
3487: l_procd_dt date;
3488: l_strtd_dt date;
3489: l_voidd_dt date;
3490: l_ntfn_dt date;

Line 3627: ben_ptnl_ler_for_per_api.update_ptnl_ler_for_per_perf

3623: -- if l_ptnl_rec.lf_evt_ocrd_dt <> p_lf_evt_ocrd_dt then
3624: --
3625: -- update the potential record.
3626: --
3627: ben_ptnl_ler_for_per_api.update_ptnl_ler_for_per_perf
3628: (p_validate => false
3629: ,p_ptnl_ler_for_per_id => l_ptnl_rec.ptnl_ler_for_per_id
3630: ,p_ptnl_ler_for_per_stat_cd => 'PROCD'
3631: ,p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt

Line 3651: ben_ptnl_ler_for_per_api.create_ptnl_ler_for_per_perf

3647: else
3648: --
3649: -- Create potential.
3650: --
3651: ben_ptnl_ler_for_per_api.create_ptnl_ler_for_per_perf
3652: (p_validate => false,
3653: p_ptnl_ler_for_per_id => l_ptnl_rec.ptnl_ler_for_per_id,
3654: p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt,
3655: p_ptnl_ler_for_per_stat_cd => 'PROCD',