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_ELECTION_INFORMATION dependencies on BEN_MANAGE_LIFE_EVENTS

Line 1230: and ( (ben_manage_life_events.fonm = 'Y' and

1226: ben_acty_base_rt_f abr
1227: where er.enrt_rt_id=p_enrt_rt_id
1228: and eb.enrt_bnft_id(+)=er.enrt_bnft_id
1229: and er.acty_base_rt_id=abr.acty_base_rt_id
1230: and ( (ben_manage_life_events.fonm = 'Y' and
1231: nvl(nvl(p_rt_strt_dt,er.rt_strt_dt),l_effective_date) between
1232: abr.effective_start_date and abr.effective_end_date) or
1233: (nvl(ben_manage_life_events.fonm,'N') = 'N'
1234: and l_effective_date between abr.effective_start_date

Line 1233: (nvl(ben_manage_life_events.fonm,'N') = 'N'

1229: and er.acty_base_rt_id=abr.acty_base_rt_id
1230: and ( (ben_manage_life_events.fonm = 'Y' and
1231: nvl(nvl(p_rt_strt_dt,er.rt_strt_dt),l_effective_date) between
1232: abr.effective_start_date and abr.effective_end_date) or
1233: (nvl(ben_manage_life_events.fonm,'N') = 'N'
1234: and l_effective_date between abr.effective_start_date
1235: and abr.effective_end_date) ) ;
1236: l_enrt_rt c_enrt_rt%rowtype;
1237:

Line 1574: AND ( ( ben_manage_life_events.fonm = 'Y'

1570: AND eb.enrt_bnft_id = er.enrt_bnft_id
1571: AND er.acty_base_rt_id = abr.acty_base_rt_id
1572: AND l_effective_date BETWEEN pen.effective_start_date
1573: AND pen.effective_end_date
1574: AND ( ( ben_manage_life_events.fonm = 'Y'
1575: AND NVL (er.rt_strt_dt, l_effective_date)
1576: BETWEEN abr.effective_start_date
1577: AND abr.effective_end_date
1578: )

Line 1579: OR ( NVL (ben_manage_life_events.fonm, 'N') = 'N'

1575: AND NVL (er.rt_strt_dt, l_effective_date)
1576: BETWEEN abr.effective_start_date
1577: AND abr.effective_end_date
1578: )
1579: OR ( NVL (ben_manage_life_events.fonm, 'N') = 'N'
1580: AND l_effective_date BETWEEN abr.effective_start_date
1581: AND abr.effective_end_date
1582: )
1583: );

Line 1824: if ben_manage_life_events.fonm is null then

1820: if l_global_pil_rec.typ_cd = 'SCHEDDU' then
1821: l_unrestricted := 'Y';
1822: end if;
1823:
1824: if ben_manage_life_events.fonm is null then
1825:
1826: open c_epe;
1827: fetch c_epe into l_fonm_cvg_strt_dt;
1828: close c_epe;

Line 1831: ben_manage_life_events.fonm := 'Y';

1827: fetch c_epe into l_fonm_cvg_strt_dt;
1828: close c_epe;
1829:
1830: if l_fonm_cvg_strt_dt is not null then
1831: ben_manage_life_events.fonm := 'Y';
1832: ben_manage_life_events.g_fonm_cvg_strt_dt := l_fonm_cvg_strt_dt;
1833: /* 8716870: Code added for Imp Inc Enh starts*/
1834: if p_imp_cvg_strt_dt is not NULL and p_imp_cvg_strt_dt > l_fonm_cvg_strt_dt then
1835: ben_manage_life_events.g_fonm_cvg_strt_dt := p_imp_cvg_strt_dt;

Line 1832: ben_manage_life_events.g_fonm_cvg_strt_dt := l_fonm_cvg_strt_dt;

1828: close c_epe;
1829:
1830: if l_fonm_cvg_strt_dt is not null then
1831: ben_manage_life_events.fonm := 'Y';
1832: ben_manage_life_events.g_fonm_cvg_strt_dt := l_fonm_cvg_strt_dt;
1833: /* 8716870: Code added for Imp Inc Enh starts*/
1834: if p_imp_cvg_strt_dt is not NULL and p_imp_cvg_strt_dt > l_fonm_cvg_strt_dt then
1835: ben_manage_life_events.g_fonm_cvg_strt_dt := p_imp_cvg_strt_dt;
1836: end if;

Line 1835: ben_manage_life_events.g_fonm_cvg_strt_dt := p_imp_cvg_strt_dt;

1831: ben_manage_life_events.fonm := 'Y';
1832: ben_manage_life_events.g_fonm_cvg_strt_dt := l_fonm_cvg_strt_dt;
1833: /* 8716870: Code added for Imp Inc Enh starts*/
1834: if p_imp_cvg_strt_dt is not NULL and p_imp_cvg_strt_dt > l_fonm_cvg_strt_dt then
1835: ben_manage_life_events.g_fonm_cvg_strt_dt := p_imp_cvg_strt_dt;
1836: end if;
1837: /* Code added for Imp Inc Enh ends */
1838:
1839: else

Line 1840: ben_manage_life_events.fonm := 'N';

1836: end if;
1837: /* Code added for Imp Inc Enh ends */
1838:
1839: else
1840: ben_manage_life_events.fonm := 'N';
1841: ben_manage_life_events.g_fonm_cvg_strt_dt := null;
1842: ben_manage_life_events.g_fonm_rt_strt_dt := null;
1843: end if;
1844: else

Line 1841: ben_manage_life_events.g_fonm_cvg_strt_dt := null;

1837: /* Code added for Imp Inc Enh ends */
1838:
1839: else
1840: ben_manage_life_events.fonm := 'N';
1841: ben_manage_life_events.g_fonm_cvg_strt_dt := null;
1842: ben_manage_life_events.g_fonm_rt_strt_dt := null;
1843: end if;
1844: else
1845: if ben_manage_life_events.g_fonm_cvg_strt_dt is null and ben_manage_life_events.fonm = 'Y' then

Line 1842: ben_manage_life_events.g_fonm_rt_strt_dt := null;

1838:
1839: else
1840: ben_manage_life_events.fonm := 'N';
1841: ben_manage_life_events.g_fonm_cvg_strt_dt := null;
1842: ben_manage_life_events.g_fonm_rt_strt_dt := null;
1843: end if;
1844: else
1845: if ben_manage_life_events.g_fonm_cvg_strt_dt is null and ben_manage_life_events.fonm = 'Y' then
1846: open c_epe;

Line 1845: if ben_manage_life_events.g_fonm_cvg_strt_dt is null and ben_manage_life_events.fonm = 'Y' then

1841: ben_manage_life_events.g_fonm_cvg_strt_dt := null;
1842: ben_manage_life_events.g_fonm_rt_strt_dt := null;
1843: end if;
1844: else
1845: if ben_manage_life_events.g_fonm_cvg_strt_dt is null and ben_manage_life_events.fonm = 'Y' then
1846: open c_epe;
1847: fetch c_epe into l_fonm_cvg_strt_dt;
1848: close c_epe;
1849: ben_manage_life_events.g_fonm_cvg_strt_dt := l_fonm_cvg_strt_dt;

Line 1849: ben_manage_life_events.g_fonm_cvg_strt_dt := l_fonm_cvg_strt_dt;

1845: if ben_manage_life_events.g_fonm_cvg_strt_dt is null and ben_manage_life_events.fonm = 'Y' then
1846: open c_epe;
1847: fetch c_epe into l_fonm_cvg_strt_dt;
1848: close c_epe;
1849: ben_manage_life_events.g_fonm_cvg_strt_dt := l_fonm_cvg_strt_dt;
1850: /* 8716870: Code added for Imp Inc Enh starts*/
1851: hr_utility.set_location('p_imp_cvg_strt_dt '||p_imp_cvg_strt_dt,5);
1852: if p_imp_cvg_strt_dt is not NULL and p_imp_cvg_strt_dt > l_fonm_cvg_strt_dt then
1853: ben_manage_life_events.g_fonm_cvg_strt_dt := p_imp_cvg_strt_dt;

Line 1853: ben_manage_life_events.g_fonm_cvg_strt_dt := p_imp_cvg_strt_dt;

1849: ben_manage_life_events.g_fonm_cvg_strt_dt := l_fonm_cvg_strt_dt;
1850: /* 8716870: Code added for Imp Inc Enh starts*/
1851: hr_utility.set_location('p_imp_cvg_strt_dt '||p_imp_cvg_strt_dt,5);
1852: if p_imp_cvg_strt_dt is not NULL and p_imp_cvg_strt_dt > l_fonm_cvg_strt_dt then
1853: ben_manage_life_events.g_fonm_cvg_strt_dt := p_imp_cvg_strt_dt;
1854: end if;
1855: /* Code added for Imp Inc Enh ends */
1856:
1857: end if ;

Line 1889: if ben_manage_life_events.fonm = 'Y' then

1885: fnd_message.raise_error;
1886: end if; -- notfound
1887: close c_enrt_rt;
1888:
1889: if ben_manage_life_events.fonm = 'Y' then
1890: ----Bug 7557403
1891: ben_manage_life_events.g_fonm_rt_strt_dt := nvl(ben_manage_life_events.g_fonm_rt_strt_dt,
1892: nvl(p_rt_strt_dt,l_enrt_rt.rt_strt_dt));
1893: ----Bug 7557403

Line 1891: ben_manage_life_events.g_fonm_rt_strt_dt := nvl(ben_manage_life_events.g_fonm_rt_strt_dt,

1887: close c_enrt_rt;
1888:
1889: if ben_manage_life_events.fonm = 'Y' then
1890: ----Bug 7557403
1891: ben_manage_life_events.g_fonm_rt_strt_dt := nvl(ben_manage_life_events.g_fonm_rt_strt_dt,
1892: nvl(p_rt_strt_dt,l_enrt_rt.rt_strt_dt));
1893: ----Bug 7557403
1894: /* 8716870: Code added for Imp Inc Enh starts*/
1895: hr_utility.set_location('p_imp_cvg_strt_dt '||p_imp_cvg_strt_dt,7);

Line 1897: ben_manage_life_events.g_fonm_rt_strt_dt := p_imp_cvg_strt_dt;

1893: ----Bug 7557403
1894: /* 8716870: Code added for Imp Inc Enh starts*/
1895: hr_utility.set_location('p_imp_cvg_strt_dt '||p_imp_cvg_strt_dt,7);
1896: if p_imp_cvg_strt_dt is not NULL and p_imp_cvg_strt_dt > nvl(p_rt_strt_dt,l_enrt_rt.rt_strt_dt) then
1897: ben_manage_life_events.g_fonm_rt_strt_dt := p_imp_cvg_strt_dt;
1898: end if;
1899: /* Code added for Imp Inc Enh ends */
1900: l_effective_date := nvl(ben_manage_life_events.g_fonm_rt_strt_dt,l_effective_date);
1901: end if;

Line 1900: l_effective_date := nvl(ben_manage_life_events.g_fonm_rt_strt_dt,l_effective_date);

1896: if p_imp_cvg_strt_dt is not NULL and p_imp_cvg_strt_dt > nvl(p_rt_strt_dt,l_enrt_rt.rt_strt_dt) then
1897: ben_manage_life_events.g_fonm_rt_strt_dt := p_imp_cvg_strt_dt;
1898: end if;
1899: /* Code added for Imp Inc Enh ends */
1900: l_effective_date := nvl(ben_manage_life_events.g_fonm_rt_strt_dt,l_effective_date);
1901: end if;
1902:
1903: if g_debug then
1904: hr_utility.set_location(l_proc, 30);

Line 4178: ben_manage_life_events.fonm := null;

4174: if g_debug then
4175: hr_utility.set_location('Leaving:'||l_proc, 99);
4176: end if;
4177:
4178: ben_manage_life_events.fonm := null;
4179: ben_manage_life_events.g_fonm_cvg_strt_dt := null;
4180: ben_manage_life_events.g_fonm_rt_strt_dt := null;
4181: --
4182: -- Set OUT parameters

Line 4179: ben_manage_life_events.g_fonm_cvg_strt_dt := null;

4175: hr_utility.set_location('Leaving:'||l_proc, 99);
4176: end if;
4177:
4178: ben_manage_life_events.fonm := null;
4179: ben_manage_life_events.g_fonm_cvg_strt_dt := null;
4180: ben_manage_life_events.g_fonm_rt_strt_dt := null;
4181: --
4182: -- Set OUT parameters
4183: --

Line 4180: ben_manage_life_events.g_fonm_rt_strt_dt := null;

4176: end if;
4177:
4178: ben_manage_life_events.fonm := null;
4179: ben_manage_life_events.g_fonm_cvg_strt_dt := null;
4180: ben_manage_life_events.g_fonm_rt_strt_dt := null;
4181: --
4182: -- Set OUT parameters
4183: --
4184: p_prv_rt_val := l_rt_val;

Line 5538: ben_manage_life_events.fonm := 'Y';

5534: close c_epe ;
5535:
5536: if l_fonm_cvg_strt_dt is not null then
5537: l_fonm_flag := 'Y' ;
5538: ben_manage_life_events.fonm := 'Y';
5539: ben_manage_life_events.g_fonm_cvg_strt_dt := l_fonm_cvg_strt_dt;
5540: /* 8716870: Code added for Imp Inc Enh begins*/
5541: if p_imp_cvg_strt_dt is not NULL and p_imp_cvg_strt_dt > l_fonm_cvg_strt_dt then
5542: hr_utility.set_location('p_imp_cvg_strt_dt '||p_imp_cvg_strt_dt,20);

Line 5539: ben_manage_life_events.g_fonm_cvg_strt_dt := l_fonm_cvg_strt_dt;

5535:
5536: if l_fonm_cvg_strt_dt is not null then
5537: l_fonm_flag := 'Y' ;
5538: ben_manage_life_events.fonm := 'Y';
5539: ben_manage_life_events.g_fonm_cvg_strt_dt := l_fonm_cvg_strt_dt;
5540: /* 8716870: Code added for Imp Inc Enh begins*/
5541: if p_imp_cvg_strt_dt is not NULL and p_imp_cvg_strt_dt > l_fonm_cvg_strt_dt then
5542: hr_utility.set_location('p_imp_cvg_strt_dt '||p_imp_cvg_strt_dt,20);
5543: ben_manage_life_events.g_fonm_cvg_strt_dt := p_imp_cvg_strt_dt;

Line 5543: ben_manage_life_events.g_fonm_cvg_strt_dt := p_imp_cvg_strt_dt;

5539: ben_manage_life_events.g_fonm_cvg_strt_dt := l_fonm_cvg_strt_dt;
5540: /* 8716870: Code added for Imp Inc Enh begins*/
5541: if p_imp_cvg_strt_dt is not NULL and p_imp_cvg_strt_dt > l_fonm_cvg_strt_dt then
5542: hr_utility.set_location('p_imp_cvg_strt_dt '||p_imp_cvg_strt_dt,20);
5543: ben_manage_life_events.g_fonm_cvg_strt_dt := p_imp_cvg_strt_dt;
5544: l_global_epe_rec.enrt_cvg_strt_dt := p_imp_cvg_strt_dt;
5545: end if;
5546: /* Code added for Imp Inc Enh ends*/
5547:

Line 5550: ben_manage_life_events.fonm := 'N';

5546: /* Code added for Imp Inc Enh ends*/
5547:
5548: else
5549: l_fonm_flag := 'N' ;
5550: ben_manage_life_events.fonm := 'N';
5551: ben_manage_life_events.g_fonm_cvg_strt_dt := null ;
5552: end if ;
5553: hr_utility.set_location (' FONM ' || ben_manage_life_events.fonm , 99 ) ;
5554: hr_utility.set_location (' FONM CVG ' || ben_manage_life_events.g_fonm_cvg_strt_dt , 99 ) ;

Line 5551: ben_manage_life_events.g_fonm_cvg_strt_dt := null ;

5547:
5548: else
5549: l_fonm_flag := 'N' ;
5550: ben_manage_life_events.fonm := 'N';
5551: ben_manage_life_events.g_fonm_cvg_strt_dt := null ;
5552: end if ;
5553: hr_utility.set_location (' FONM ' || ben_manage_life_events.fonm , 99 ) ;
5554: hr_utility.set_location (' FONM CVG ' || ben_manage_life_events.g_fonm_cvg_strt_dt , 99 ) ;
5555:

Line 5553: hr_utility.set_location (' FONM ' || ben_manage_life_events.fonm , 99 ) ;

5549: l_fonm_flag := 'N' ;
5550: ben_manage_life_events.fonm := 'N';
5551: ben_manage_life_events.g_fonm_cvg_strt_dt := null ;
5552: end if ;
5553: hr_utility.set_location (' FONM ' || ben_manage_life_events.fonm , 99 ) ;
5554: hr_utility.set_location (' FONM CVG ' || ben_manage_life_events.g_fonm_cvg_strt_dt , 99 ) ;
5555:
5556: --
5557: -- If form code is too lazy to pass in the result id

Line 5554: hr_utility.set_location (' FONM CVG ' || ben_manage_life_events.g_fonm_cvg_strt_dt , 99 ) ;

5550: ben_manage_life_events.fonm := 'N';
5551: ben_manage_life_events.g_fonm_cvg_strt_dt := null ;
5552: end if ;
5553: hr_utility.set_location (' FONM ' || ben_manage_life_events.fonm , 99 ) ;
5554: hr_utility.set_location (' FONM CVG ' || ben_manage_life_events.g_fonm_cvg_strt_dt , 99 ) ;
5555:
5556: --
5557: -- If form code is too lazy to pass in the result id
5558: -- then get it from the choice. Note will be null if

Line 7542: ben_manage_life_events.fonm := l_fonm_flag ;

7538: );
7539: --
7540: -- after delete enrollment the fonm flag back
7541: -- when the plan replcaed the dele_enroll might have reset the fonm flag
7542: ben_manage_life_events.fonm := l_fonm_flag ;
7543: ben_manage_life_events.g_fonm_cvg_strt_dt := l_fonm_cvg_strt_dt;
7544:
7545: hr_utility.set_location (' aftr del_enrl FONM ' || ben_manage_life_events.fonm , 99 ) ;
7546: hr_utility.set_location (' FONM CVG ' || ben_manage_life_events.g_fonm_cvg_strt_dt , 99 ) ;

Line 7543: ben_manage_life_events.g_fonm_cvg_strt_dt := l_fonm_cvg_strt_dt;

7539: --
7540: -- after delete enrollment the fonm flag back
7541: -- when the plan replcaed the dele_enroll might have reset the fonm flag
7542: ben_manage_life_events.fonm := l_fonm_flag ;
7543: ben_manage_life_events.g_fonm_cvg_strt_dt := l_fonm_cvg_strt_dt;
7544:
7545: hr_utility.set_location (' aftr del_enrl FONM ' || ben_manage_life_events.fonm , 99 ) ;
7546: hr_utility.set_location (' FONM CVG ' || ben_manage_life_events.g_fonm_cvg_strt_dt , 99 ) ;
7547:

Line 7545: hr_utility.set_location (' aftr del_enrl FONM ' || ben_manage_life_events.fonm , 99 ) ;

7541: -- when the plan replcaed the dele_enroll might have reset the fonm flag
7542: ben_manage_life_events.fonm := l_fonm_flag ;
7543: ben_manage_life_events.g_fonm_cvg_strt_dt := l_fonm_cvg_strt_dt;
7544:
7545: hr_utility.set_location (' aftr del_enrl FONM ' || ben_manage_life_events.fonm , 99 ) ;
7546: hr_utility.set_location (' FONM CVG ' || ben_manage_life_events.g_fonm_cvg_strt_dt , 99 ) ;
7547:
7548:
7549: end if;

Line 7546: hr_utility.set_location (' FONM CVG ' || ben_manage_life_events.g_fonm_cvg_strt_dt , 99 ) ;

7542: ben_manage_life_events.fonm := l_fonm_flag ;
7543: ben_manage_life_events.g_fonm_cvg_strt_dt := l_fonm_cvg_strt_dt;
7544:
7545: hr_utility.set_location (' aftr del_enrl FONM ' || ben_manage_life_events.fonm , 99 ) ;
7546: hr_utility.set_location (' FONM CVG ' || ben_manage_life_events.g_fonm_cvg_strt_dt , 99 ) ;
7547:
7548:
7549: end if;
7550: --