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_PLAN_DESIGN_PLAN_MODULE dependencies on BEN_PLAN_DESIGN_PROGRAM_MODULE

Line 1366: if p_no_dup_rslt = ben_plan_design_program_module.g_pdw_no_dup_rslt then

1362: --
1363: l_pl_id := l_parent_rec.pl_id ;
1364: --
1365:
1366: if p_no_dup_rslt = ben_plan_design_program_module.g_pdw_no_dup_rslt then
1367: ben_plan_design_program_module.g_pdw_allow_dup_rslt := ben_plan_design_program_module.g_pdw_no_dup_rslt;
1368: else
1369: ben_plan_design_program_module.g_pdw_allow_dup_rslt := null;
1370: end if;

Line 1367: ben_plan_design_program_module.g_pdw_allow_dup_rslt := ben_plan_design_program_module.g_pdw_no_dup_rslt;

1363: l_pl_id := l_parent_rec.pl_id ;
1364: --
1365:
1366: if p_no_dup_rslt = ben_plan_design_program_module.g_pdw_no_dup_rslt then
1367: ben_plan_design_program_module.g_pdw_allow_dup_rslt := ben_plan_design_program_module.g_pdw_no_dup_rslt;
1368: else
1369: ben_plan_design_program_module.g_pdw_allow_dup_rslt := null;
1370: end if;
1371:

Line 1369: ben_plan_design_program_module.g_pdw_allow_dup_rslt := null;

1365:
1366: if p_no_dup_rslt = ben_plan_design_program_module.g_pdw_no_dup_rslt then
1367: ben_plan_design_program_module.g_pdw_allow_dup_rslt := ben_plan_design_program_module.g_pdw_no_dup_rslt;
1368: else
1369: ben_plan_design_program_module.g_pdw_allow_dup_rslt := null;
1370: end if;
1371:
1372: if ben_plan_design_program_module.g_pdw_allow_dup_rslt = ben_plan_design_program_module.g_pdw_no_dup_rslt then
1373: open c_object_exists(l_pl_id,'PLN');

Line 1372: if ben_plan_design_program_module.g_pdw_allow_dup_rslt = ben_plan_design_program_module.g_pdw_no_dup_rslt then

1368: else
1369: ben_plan_design_program_module.g_pdw_allow_dup_rslt := null;
1370: end if;
1371:
1372: if ben_plan_design_program_module.g_pdw_allow_dup_rslt = ben_plan_design_program_module.g_pdw_no_dup_rslt then
1373: open c_object_exists(l_pl_id,'PLN');
1374: fetch c_object_exists into l_dummy;
1375: if c_object_exists%found then
1376: close c_object_exists;

Line 1412: open ben_plan_design_program_module.g_table_route('PLN');

1408: --
1409: savepoint create_copy_entity_result;
1410: --
1411: l_table_route_id := null ;
1412: open ben_plan_design_program_module.g_table_route('PLN');
1413: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
1414: close ben_plan_design_program_module.g_table_route ;
1415: --
1416: l_information5 := l_pln_rec.name; --'Intersection';

Line 1413: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;

1409: savepoint create_copy_entity_result;
1410: --
1411: l_table_route_id := null ;
1412: open ben_plan_design_program_module.g_table_route('PLN');
1413: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
1414: close ben_plan_design_program_module.g_table_route ;
1415: --
1416: l_information5 := l_pln_rec.name; --'Intersection';
1417: --

Line 1414: close ben_plan_design_program_module.g_table_route ;

1410: --
1411: l_table_route_id := null ;
1412: open ben_plan_design_program_module.g_table_route('PLN');
1413: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
1414: close ben_plan_design_program_module.g_table_route ;
1415: --
1416: l_information5 := l_pln_rec.name; --'Intersection';
1417: --
1418: l_pl_typ_name := ben_plan_design_program_module.get_pl_typ_name(l_pln_rec.pl_typ_id,p_effective_date);

Line 1418: l_pl_typ_name := ben_plan_design_program_module.get_pl_typ_name(l_pln_rec.pl_typ_id,p_effective_date);

1414: close ben_plan_design_program_module.g_table_route ;
1415: --
1416: l_information5 := l_pln_rec.name; --'Intersection';
1417: --
1418: l_pl_typ_name := ben_plan_design_program_module.get_pl_typ_name(l_pln_rec.pl_typ_id,p_effective_date);
1419: l_pl_usage := hr_general.decode_lookup('BEN_PL',l_pln_rec.pl_cd);
1420: --
1421: if p_effective_date between l_pln_rec.effective_start_date
1422: and l_pln_rec.effective_end_date then

Line 1716: ben_plan_design_program_module.create_formula_result(

1712: l_pln_esd := l_pln_rec.EFFECTIVE_START_DATE;
1713: end if;
1714:
1715: if (l_pln_rec.auto_enrt_mthd_rl is not null) then
1716: ben_plan_design_program_module.create_formula_result(
1717: p_validate => p_validate
1718: ,p_copy_entity_result_id => l_copy_entity_result_id
1719: ,p_copy_entity_txn_id => p_copy_entity_txn_id
1720: ,p_formula_id => l_pln_rec.auto_enrt_mthd_rl

Line 1728: ben_plan_design_program_module.create_formula_result(

1724: ,p_effective_date => p_effective_date);
1725: end if;
1726:
1727: if (l_pln_rec.dflt_to_asn_pndg_ctfn_rl is not null) then
1728: ben_plan_design_program_module.create_formula_result(
1729: p_validate => p_validate
1730: ,p_copy_entity_result_id => l_copy_entity_result_id
1731: ,p_copy_entity_txn_id => p_copy_entity_txn_id
1732: ,p_formula_id => l_pln_rec.dflt_to_asn_pndg_ctfn_rl

Line 1740: ben_plan_design_program_module.create_formula_result(

1736: ,p_effective_date => p_effective_date);
1737: end if;
1738:
1739: if (l_pln_rec.dpnt_cvg_end_dt_rl is not null) then
1740: ben_plan_design_program_module.create_formula_result(
1741: p_validate => p_validate
1742: ,p_copy_entity_result_id => l_copy_entity_result_id
1743: ,p_copy_entity_txn_id => p_copy_entity_txn_id
1744: ,p_formula_id => l_pln_rec.dpnt_cvg_end_dt_rl

Line 1752: ben_plan_design_program_module.create_formula_result(

1748: ,p_effective_date => p_effective_date);
1749: end if;
1750:
1751: if (l_pln_rec.dpnt_cvg_strt_dt_rl is not null) then
1752: ben_plan_design_program_module.create_formula_result(
1753: p_validate => p_validate
1754: ,p_copy_entity_result_id => l_copy_entity_result_id
1755: ,p_copy_entity_txn_id => p_copy_entity_txn_id
1756: ,p_formula_id => l_pln_rec.dpnt_cvg_strt_dt_rl

Line 1764: ben_plan_design_program_module.create_formula_result(

1760: ,p_effective_date => p_effective_date);
1761: end if;
1762:
1763: if (l_pln_rec.enrt_cvg_end_dt_rl is not null) then
1764: ben_plan_design_program_module.create_formula_result(
1765: p_validate => p_validate
1766: ,p_copy_entity_result_id => l_copy_entity_result_id
1767: ,p_copy_entity_txn_id => p_copy_entity_txn_id
1768: ,p_formula_id => l_pln_rec.enrt_cvg_end_dt_rl

Line 1776: ben_plan_design_program_module.create_formula_result(

1772: ,p_effective_date => p_effective_date);
1773: end if;
1774:
1775: if (l_pln_rec.enrt_cvg_strt_dt_rl is not null) then
1776: ben_plan_design_program_module.create_formula_result(
1777: p_validate => p_validate
1778: ,p_copy_entity_result_id => l_copy_entity_result_id
1779: ,p_copy_entity_txn_id => p_copy_entity_txn_id
1780: ,p_formula_id => l_pln_rec.enrt_cvg_strt_dt_rl

Line 1788: ben_plan_design_program_module.create_formula_result(

1784: ,p_effective_date => p_effective_date);
1785: end if;
1786:
1787: if (l_pln_rec.enrt_rl is not null) then
1788: ben_plan_design_program_module.create_formula_result(
1789: p_validate => p_validate
1790: ,p_copy_entity_result_id => l_copy_entity_result_id
1791: ,p_copy_entity_txn_id => p_copy_entity_txn_id
1792: ,p_formula_id => l_pln_rec.enrt_rl

Line 1800: ben_plan_design_program_module.create_formula_result(

1796: ,p_effective_date => p_effective_date);
1797: end if;
1798:
1799: if (l_pln_rec.frfs_distr_mthd_rl is not null) then
1800: ben_plan_design_program_module.create_formula_result(
1801: p_validate => p_validate
1802: ,p_copy_entity_result_id => l_copy_entity_result_id
1803: ,p_copy_entity_txn_id => p_copy_entity_txn_id
1804: ,p_formula_id => l_pln_rec.frfs_distr_mthd_rl

Line 1812: ben_plan_design_program_module.create_formula_result(

1808: ,p_effective_date => p_effective_date);
1809: end if;
1810:
1811: if (l_pln_rec.mn_cvg_rl is not null) then
1812: ben_plan_design_program_module.create_formula_result(
1813: p_validate => p_validate
1814: ,p_copy_entity_result_id => l_copy_entity_result_id
1815: ,p_copy_entity_txn_id => p_copy_entity_txn_id
1816: ,p_formula_id => l_pln_rec.mn_cvg_rl

Line 1824: ben_plan_design_program_module.create_formula_result(

1820: ,p_effective_date => p_effective_date);
1821: end if;
1822:
1823: if (l_pln_rec.mx_cvg_rl is not null) then
1824: ben_plan_design_program_module.create_formula_result(
1825: p_validate => p_validate
1826: ,p_copy_entity_result_id => l_copy_entity_result_id
1827: ,p_copy_entity_txn_id => p_copy_entity_txn_id
1828: ,p_formula_id => l_pln_rec.mx_cvg_rl

Line 1836: ben_plan_design_program_module.create_formula_result(

1832: ,p_effective_date => p_effective_date);
1833: end if;
1834:
1835: if (l_pln_rec.mx_wtg_dt_to_use_rl is not null) then
1836: ben_plan_design_program_module.create_formula_result(
1837: p_validate => p_validate
1838: ,p_copy_entity_result_id => l_copy_entity_result_id
1839: ,p_copy_entity_txn_id => p_copy_entity_txn_id
1840: ,p_formula_id => l_pln_rec.mx_wtg_dt_to_use_rl

Line 1848: ben_plan_design_program_module.create_formula_result(

1844: ,p_effective_date => p_effective_date);
1845: end if;
1846:
1847: if (l_pln_rec.mx_wtg_perd_rl is not null) then
1848: ben_plan_design_program_module.create_formula_result(
1849: p_validate => p_validate
1850: ,p_copy_entity_result_id => l_copy_entity_result_id
1851: ,p_copy_entity_txn_id => p_copy_entity_txn_id
1852: ,p_formula_id => l_pln_rec.mx_wtg_perd_rl

Line 1860: ben_plan_design_program_module.create_formula_result(

1856: ,p_effective_date => p_effective_date);
1857: end if;
1858:
1859: if (l_pln_rec.nip_dflt_enrt_det_rl is not null) then
1860: ben_plan_design_program_module.create_formula_result(
1861: p_validate => p_validate
1862: ,p_copy_entity_result_id => l_copy_entity_result_id
1863: ,p_copy_entity_txn_id => p_copy_entity_txn_id
1864: ,p_formula_id => l_pln_rec.nip_dflt_enrt_det_rl

Line 1872: ben_plan_design_program_module.create_formula_result(

1868: ,p_effective_date => p_effective_date);
1869: end if;
1870:
1871: if (l_pln_rec.postelcn_edit_rl is not null) then
1872: ben_plan_design_program_module.create_formula_result(
1873: p_validate => p_validate
1874: ,p_copy_entity_result_id => l_copy_entity_result_id
1875: ,p_copy_entity_txn_id => p_copy_entity_txn_id
1876: ,p_formula_id => l_pln_rec.postelcn_edit_rl

Line 1884: ben_plan_design_program_module.create_formula_result(

1880: ,p_effective_date => p_effective_date);
1881: end if;
1882:
1883: if (l_pln_rec.prort_prtl_yr_cvg_rstrn_rl is not null) then
1884: ben_plan_design_program_module.create_formula_result(
1885: p_validate => p_validate
1886: ,p_copy_entity_result_id => l_copy_entity_result_id
1887: ,p_copy_entity_txn_id => p_copy_entity_txn_id
1888: ,p_formula_id => l_pln_rec.prort_prtl_yr_cvg_rstrn_rl

Line 1896: ben_plan_design_program_module.create_formula_result(

1892: ,p_effective_date => p_effective_date);
1893: end if;
1894:
1895: if (l_pln_rec.rqd_perd_enrt_nenrt_rl is not null) then
1896: ben_plan_design_program_module.create_formula_result(
1897: p_validate => p_validate
1898: ,p_copy_entity_result_id => l_copy_entity_result_id
1899: ,p_copy_entity_txn_id => p_copy_entity_txn_id
1900: ,p_formula_id => l_pln_rec.rqd_perd_enrt_nenrt_rl

Line 1908: ben_plan_design_program_module.create_formula_result(

1904: ,p_effective_date => p_effective_date);
1905: end if;
1906:
1907: if (l_pln_rec.rt_end_dt_rl is not null) then
1908: ben_plan_design_program_module.create_formula_result(
1909: p_validate => p_validate
1910: ,p_copy_entity_result_id => l_copy_entity_result_id
1911: ,p_copy_entity_txn_id => p_copy_entity_txn_id
1912: ,p_formula_id => l_pln_rec.rt_end_dt_rl

Line 1920: ben_plan_design_program_module.create_formula_result(

1916: ,p_effective_date => p_effective_date);
1917: end if;
1918:
1919: if (l_pln_rec.rt_strt_dt_rl is not null) then
1920: ben_plan_design_program_module.create_formula_result(
1921: p_validate => p_validate
1922: ,p_copy_entity_result_id => l_copy_entity_result_id
1923: ,p_copy_entity_txn_id => p_copy_entity_txn_id
1924: ,p_formula_id => l_pln_rec.rt_strt_dt_rl

Line 1932: ben_plan_design_program_module.create_formula_result(

1928: ,p_effective_date => p_effective_date);
1929: end if;
1930:
1931: if (l_pln_rec.vrfy_fmly_mmbr_rl is not null) then
1932: ben_plan_design_program_module.create_formula_result(
1933: p_validate => p_validate
1934: ,p_copy_entity_result_id => l_copy_entity_result_id
1935: ,p_copy_entity_txn_id => p_copy_entity_txn_id
1936: ,p_formula_id => l_pln_rec.vrfy_fmly_mmbr_rl

Line 2111: open ben_plan_design_program_module.g_table_route('CWG');

2107: --
2108: for l_cwg_rec in c_cwg(l_parent_rec.cwb_wksht_grp_id,l_mirror_src_entity_result_id,'CWG') loop
2109: --
2110: l_table_route_id := null ;
2111: open ben_plan_design_program_module.g_table_route('CWG');
2112: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
2113: close ben_plan_design_program_module.g_table_route ;
2114: --
2115: l_information5 := l_cwg_rec.label;

Line 2112: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;

2108: for l_cwg_rec in c_cwg(l_parent_rec.cwb_wksht_grp_id,l_mirror_src_entity_result_id,'CWG') loop
2109: --
2110: l_table_route_id := null ;
2111: open ben_plan_design_program_module.g_table_route('CWG');
2112: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
2113: close ben_plan_design_program_module.g_table_route ;
2114: --
2115: l_information5 := l_cwg_rec.label;
2116: --

Line 2113: close ben_plan_design_program_module.g_table_route ;

2109: --
2110: l_table_route_id := null ;
2111: open ben_plan_design_program_module.g_table_route('CWG');
2112: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
2113: close ben_plan_design_program_module.g_table_route ;
2114: --
2115: l_information5 := l_cwg_rec.label;
2116: --
2117: l_result_type_cd := 'DISPLAY';

Line 2196: open ben_plan_design_program_module.g_table_route('CRI');

2192: for l_cri_rec in c_cri(l_parent_rec.cwb_wksht_grp_id,l_mirror_src_entity_result_id,'CRI') loop
2193: --
2194:
2195: l_table_route_id := null ;
2196: open ben_plan_design_program_module.g_table_route('CRI');
2197: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
2198: close ben_plan_design_program_module.g_table_route ;
2199: --
2200: l_cri_information5 := l_cri_rec.label;

Line 2197: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;

2193: --
2194:
2195: l_table_route_id := null ;
2196: open ben_plan_design_program_module.g_table_route('CRI');
2197: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
2198: close ben_plan_design_program_module.g_table_route ;
2199: --
2200: l_cri_information5 := l_cri_rec.label;
2201: --

Line 2198: close ben_plan_design_program_module.g_table_route ;

2194:
2195: l_table_route_id := null ;
2196: open ben_plan_design_program_module.g_table_route('CRI');
2197: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
2198: close ben_plan_design_program_module.g_table_route ;
2199: --
2200: l_cri_information5 := l_cri_rec.label;
2201: --
2202: --Bug 5018205 DO NOT Display personalizations if the Label is NULL

Line 2292: if ben_plan_design_program_module.g_pdw_allow_dup_rslt = ben_plan_design_program_module.g_pdw_no_dup_rslt then

2288: l_parent_entity_result_id := l_out_pln_cpp_result_id;
2289:
2290: l_pl_regn_id := l_parent_rec.pl_regn_id ;
2291:
2292: if ben_plan_design_program_module.g_pdw_allow_dup_rslt = ben_plan_design_program_module.g_pdw_no_dup_rslt then
2293: open c_object_exists(l_pl_regn_id,'PRG');
2294: fetch c_object_exists into l_dummy;
2295: if c_object_exists%found then
2296: close c_object_exists;

Line 2306: open ben_plan_design_program_module.g_table_route('PRG');

2302: --
2303: for l_prg_rec in c_prg(l_parent_rec.pl_regn_id,l_mirror_src_entity_result_id,'PRG') loop
2304: --
2305: l_table_route_id := null ;
2306: open ben_plan_design_program_module.g_table_route('PRG');
2307: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
2308: close ben_plan_design_program_module.g_table_route ;
2309: --
2310: l_information5 := ben_plan_design_program_module.get_regn_name(l_prg_rec.regn_id,p_effective_date); --'Intersection';

Line 2307: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;

2303: for l_prg_rec in c_prg(l_parent_rec.pl_regn_id,l_mirror_src_entity_result_id,'PRG') loop
2304: --
2305: l_table_route_id := null ;
2306: open ben_plan_design_program_module.g_table_route('PRG');
2307: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
2308: close ben_plan_design_program_module.g_table_route ;
2309: --
2310: l_information5 := ben_plan_design_program_module.get_regn_name(l_prg_rec.regn_id,p_effective_date); --'Intersection';
2311: --

Line 2308: close ben_plan_design_program_module.g_table_route ;

2304: --
2305: l_table_route_id := null ;
2306: open ben_plan_design_program_module.g_table_route('PRG');
2307: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
2308: close ben_plan_design_program_module.g_table_route ;
2309: --
2310: l_information5 := ben_plan_design_program_module.get_regn_name(l_prg_rec.regn_id,p_effective_date); --'Intersection';
2311: --
2312: if p_effective_date between l_prg_rec.effective_start_date

Line 2310: l_information5 := ben_plan_design_program_module.get_regn_name(l_prg_rec.regn_id,p_effective_date); --'Intersection';

2306: open ben_plan_design_program_module.g_table_route('PRG');
2307: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
2308: close ben_plan_design_program_module.g_table_route ;
2309: --
2310: l_information5 := ben_plan_design_program_module.get_regn_name(l_prg_rec.regn_id,p_effective_date); --'Intersection';
2311: --
2312: if p_effective_date between l_prg_rec.effective_start_date
2313: and l_prg_rec.effective_end_date then
2314: --

Line 2328: l_regn_name := ben_plan_design_program_module.get_regn_name(l_prg_rec.regn_id,l_prg_rec.effective_start_date);

2324: -- The copy process will try and map the Regulation name to the ones existing in the
2325: -- Target Business Group and if a match is found, then that Regulation Id will be used
2326: -- for creating Plan Regulation (BEN_PL_REGN) records.
2327:
2328: l_regn_name := ben_plan_design_program_module.get_regn_name(l_prg_rec.regn_id,l_prg_rec.effective_start_date);
2329: --
2330: */
2331:
2332: l_copy_entity_result_id := null;

Line 2403: ben_plan_design_program_module.create_formula_result(

2399: l_out_prg_result_id := l_copy_entity_result_id ;
2400: end if;
2401:
2402: if (l_prg_rec.cntr_nndscrn_rl is not null) then
2403: ben_plan_design_program_module.create_formula_result(
2404: p_validate => p_validate
2405: ,p_copy_entity_result_id => l_copy_entity_result_id
2406: ,p_copy_entity_txn_id => p_copy_entity_txn_id
2407: ,p_formula_id => l_prg_rec.cntr_nndscrn_rl

Line 2415: ben_plan_design_program_module.create_formula_result(

2411: ,p_effective_date => p_effective_date);
2412: end if;
2413:
2414: if (l_prg_rec.cvg_nndscrn_rl is not null) then
2415: ben_plan_design_program_module.create_formula_result(
2416: p_validate => p_validate
2417: ,p_copy_entity_result_id => l_copy_entity_result_id
2418: ,p_copy_entity_txn_id => p_copy_entity_txn_id
2419: ,p_formula_id => l_prg_rec.cvg_nndscrn_rl

Line 2427: ben_plan_design_program_module.create_formula_result(

2423: ,p_effective_date => p_effective_date);
2424: end if;
2425:
2426: if (l_prg_rec.five_pct_ownr_rl is not null) then
2427: ben_plan_design_program_module.create_formula_result(
2428: p_validate => p_validate
2429: ,p_copy_entity_result_id => l_copy_entity_result_id
2430: ,p_copy_entity_txn_id => p_copy_entity_txn_id
2431: ,p_formula_id => l_prg_rec.five_pct_ownr_rl

Line 2439: ben_plan_design_program_module.create_formula_result(

2435: ,p_effective_date => p_effective_date);
2436: end if;
2437:
2438: if (l_prg_rec.hghly_compd_det_rl is not null) then
2439: ben_plan_design_program_module.create_formula_result(
2440: p_validate => p_validate
2441: ,p_copy_entity_result_id => l_copy_entity_result_id
2442: ,p_copy_entity_txn_id => p_copy_entity_txn_id
2443: ,p_formula_id => l_prg_rec.hghly_compd_det_rl

Line 2451: ben_plan_design_program_module.create_formula_result(

2447: ,p_effective_date => p_effective_date);
2448: end if;
2449:
2450: if (l_prg_rec.key_ee_det_rl is not null) then
2451: ben_plan_design_program_module.create_formula_result(
2452: p_validate => p_validate
2453: ,p_copy_entity_result_id => l_copy_entity_result_id
2454: ,p_copy_entity_txn_id => p_copy_entity_txn_id
2455: ,p_formula_id => l_prg_rec.key_ee_det_rl

Line 2474: if ben_plan_design_program_module.g_pdw_allow_dup_rslt = ben_plan_design_program_module.g_pdw_no_dup_rslt then

2470: l_mirror_src_entity_result_id := l_out_prg_result_id;
2471:
2472: l_regn_id := l_parent_rec.regn_id ;
2473:
2474: if ben_plan_design_program_module.g_pdw_allow_dup_rslt = ben_plan_design_program_module.g_pdw_no_dup_rslt then
2475: open c_object_exists(l_regn_id,'REG');
2476: fetch c_object_exists into l_dummy;
2477: if c_object_exists%found then
2478: close c_object_exists;

Line 2487: open ben_plan_design_program_module.g_table_route('REG');

2483: --
2484: for l_reg_rec in c_reg(l_parent_rec.regn_id,l_mirror_src_entity_result_id,'REG') loop
2485: --
2486: l_table_route_id := null ;
2487: open ben_plan_design_program_module.g_table_route('REG');
2488: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
2489: close ben_plan_design_program_module.g_table_route ;
2490: --
2491: l_information5 := l_reg_rec.name; --'Intersection';

Line 2488: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;

2484: for l_reg_rec in c_reg(l_parent_rec.regn_id,l_mirror_src_entity_result_id,'REG') loop
2485: --
2486: l_table_route_id := null ;
2487: open ben_plan_design_program_module.g_table_route('REG');
2488: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
2489: close ben_plan_design_program_module.g_table_route ;
2490: --
2491: l_information5 := l_reg_rec.name; --'Intersection';
2492: --

Line 2489: close ben_plan_design_program_module.g_table_route ;

2485: --
2486: l_table_route_id := null ;
2487: open ben_plan_design_program_module.g_table_route('REG');
2488: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
2489: close ben_plan_design_program_module.g_table_route ;
2490: --
2491: l_information5 := l_reg_rec.name; --'Intersection';
2492: --
2493: l_regn_id := l_reg_rec.regn_id ;

Line 2583: if ben_plan_design_program_module.g_pdw_allow_dup_rslt = ben_plan_design_program_module.g_pdw_no_dup_rslt then

2579: l_mirror_src_entity_result_id := l_out_prg_result_id ;
2580:
2581: l_rptg_grp_id := l_parent_rec.rptg_grp_id ;
2582:
2583: if ben_plan_design_program_module.g_pdw_allow_dup_rslt = ben_plan_design_program_module.g_pdw_no_dup_rslt then
2584: open c_object_exists(l_rptg_grp_id,'BNR');
2585: fetch c_object_exists into l_dummy;
2586: if c_object_exists%found then
2587: close c_object_exists;

Line 2597: open ben_plan_design_program_module.g_table_route('BNR');

2593: --
2594: for l_bnr_rec in c_bnr(l_parent_rec.rptg_grp_id,l_mirror_src_entity_result_id,'BNR') loop
2595: --
2596: l_table_route_id := null ;
2597: open ben_plan_design_program_module.g_table_route('BNR');
2598: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
2599: close ben_plan_design_program_module.g_table_route ;
2600: --
2601: l_information5 := l_bnr_rec.name; --'Intersection';

Line 2598: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;

2594: for l_bnr_rec in c_bnr(l_parent_rec.rptg_grp_id,l_mirror_src_entity_result_id,'BNR') loop
2595: --
2596: l_table_route_id := null ;
2597: open ben_plan_design_program_module.g_table_route('BNR');
2598: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
2599: close ben_plan_design_program_module.g_table_route ;
2600: --
2601: l_information5 := l_bnr_rec.name; --'Intersection';
2602: --

Line 2599: close ben_plan_design_program_module.g_table_route ;

2595: --
2596: l_table_route_id := null ;
2597: open ben_plan_design_program_module.g_table_route('BNR');
2598: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
2599: close ben_plan_design_program_module.g_table_route ;
2600: --
2601: l_information5 := l_bnr_rec.name; --'Intersection';
2602: --
2603: l_rptg_grp_id := l_bnr_rec.rptg_grp_id ;

Line 2683: if ben_plan_design_program_module.g_pdw_allow_dup_rslt = ben_plan_design_program_module.g_pdw_no_dup_rslt then

2679: l_mirror_src_entity_result_id := l_out_bnr_result_id ;
2680: --
2681: l_pl_regn_id1 := l_parent_rec.pl_regn_id ;
2682:
2683: if ben_plan_design_program_module.g_pdw_allow_dup_rslt = ben_plan_design_program_module.g_pdw_no_dup_rslt then
2684: open c_object_exists(l_pl_regn_id1,'PRG');
2685: fetch c_object_exists into l_dummy;
2686: if c_object_exists%found then
2687: close c_object_exists;

Line 2697: open ben_plan_design_program_module.g_table_route('PRG');

2693: --
2694: for l_prg_rec in c_prg1(l_parent_rec.pl_regn_id,l_mirror_src_entity_result_id,'PRG') loop
2695: --
2696: l_table_route_id := null ;
2697: open ben_plan_design_program_module.g_table_route('PRG');
2698: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
2699: close ben_plan_design_program_module.g_table_route ;
2700: --
2701: l_information5 := ben_plan_design_program_module.get_regn_name(l_prg_rec.regn_id,

Line 2698: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;

2694: for l_prg_rec in c_prg1(l_parent_rec.pl_regn_id,l_mirror_src_entity_result_id,'PRG') loop
2695: --
2696: l_table_route_id := null ;
2697: open ben_plan_design_program_module.g_table_route('PRG');
2698: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
2699: close ben_plan_design_program_module.g_table_route ;
2700: --
2701: l_information5 := ben_plan_design_program_module.get_regn_name(l_prg_rec.regn_id,
2702: p_effective_date);

Line 2699: close ben_plan_design_program_module.g_table_route ;

2695: --
2696: l_table_route_id := null ;
2697: open ben_plan_design_program_module.g_table_route('PRG');
2698: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
2699: close ben_plan_design_program_module.g_table_route ;
2700: --
2701: l_information5 := ben_plan_design_program_module.get_regn_name(l_prg_rec.regn_id,
2702: p_effective_date);
2703: --

Line 2701: l_information5 := ben_plan_design_program_module.get_regn_name(l_prg_rec.regn_id,

2697: open ben_plan_design_program_module.g_table_route('PRG');
2698: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
2699: close ben_plan_design_program_module.g_table_route ;
2700: --
2701: l_information5 := ben_plan_design_program_module.get_regn_name(l_prg_rec.regn_id,
2702: p_effective_date);
2703: --
2704: if p_effective_date between l_prg_rec.effective_start_date
2705: and l_prg_rec.effective_end_date then

Line 2720: l_regn_name := ben_plan_design_program_module.get_regn_name(l_prg_rec.regn_id,l_prg_rec.effective_start_date);

2716: -- The copy process will try and map the Regulation name to the ones existing in the
2717: -- Target Business Group and if a match is found, then that Regulation Id will be used
2718: -- for creating Plan Regulation (BEN_PL_REGN) records.
2719:
2720: l_regn_name := ben_plan_design_program_module.get_regn_name(l_prg_rec.regn_id,l_prg_rec.effective_start_date);
2721: --
2722: */
2723:
2724: l_copy_entity_result_id := null;

Line 2806: if ben_plan_design_program_module.g_pdw_allow_dup_rslt = ben_plan_design_program_module.g_pdw_no_dup_rslt then

2802: l_mirror_src_entity_result_id := l_out_prg1_result_id ;
2803: --
2804: l_regn_id := l_parent_rec.regn_id ;
2805:
2806: if ben_plan_design_program_module.g_pdw_allow_dup_rslt = ben_plan_design_program_module.g_pdw_no_dup_rslt then
2807: open c_object_exists(l_regn_id,'REG');
2808: fetch c_object_exists into l_dummy;
2809: if c_object_exists%found then
2810: close c_object_exists;

Line 2819: open ben_plan_design_program_module.g_table_route('REG');

2815: --
2816: for l_reg_rec in c_reg(l_parent_rec.regn_id,l_mirror_src_entity_result_id,'REG') loop
2817: --
2818: l_table_route_id := null ;
2819: open ben_plan_design_program_module.g_table_route('REG');
2820: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
2821: close ben_plan_design_program_module.g_table_route ;
2822: --
2823: l_information5 := l_reg_rec.name ;

Line 2820: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;

2816: for l_reg_rec in c_reg(l_parent_rec.regn_id,l_mirror_src_entity_result_id,'REG') loop
2817: --
2818: l_table_route_id := null ;
2819: open ben_plan_design_program_module.g_table_route('REG');
2820: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
2821: close ben_plan_design_program_module.g_table_route ;
2822: --
2823: l_information5 := l_reg_rec.name ;
2824: --

Line 2821: close ben_plan_design_program_module.g_table_route ;

2817: --
2818: l_table_route_id := null ;
2819: open ben_plan_design_program_module.g_table_route('REG');
2820: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
2821: close ben_plan_design_program_module.g_table_route ;
2822: --
2823: l_information5 := l_reg_rec.name ;
2824: --
2825: if p_effective_date between l_reg_rec.effective_start_date

Line 2919: open ben_plan_design_program_module.g_table_route('PRB');

2915: --
2916: for l_prb_rec in c_prb(l_parent_rec.pl_regy_bod_id,l_mirror_src_entity_result_id,'PRB') loop
2917: --
2918: l_table_route_id := null ;
2919: open ben_plan_design_program_module.g_table_route('PRB');
2920: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
2921: close ben_plan_design_program_module.g_table_route ;
2922: --
2923: l_information5 := l_prb_rec.regy_pl_name ;

Line 2920: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;

2916: for l_prb_rec in c_prb(l_parent_rec.pl_regy_bod_id,l_mirror_src_entity_result_id,'PRB') loop
2917: --
2918: l_table_route_id := null ;
2919: open ben_plan_design_program_module.g_table_route('PRB');
2920: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
2921: close ben_plan_design_program_module.g_table_route ;
2922: --
2923: l_information5 := l_prb_rec.regy_pl_name ;
2924: --

Line 2921: close ben_plan_design_program_module.g_table_route ;

2917: --
2918: l_table_route_id := null ;
2919: open ben_plan_design_program_module.g_table_route('PRB');
2920: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
2921: close ben_plan_design_program_module.g_table_route ;
2922: --
2923: l_information5 := l_prb_rec.regy_pl_name ;
2924: --
2925: if p_effective_date between l_prb_rec.effective_start_date

Line 3015: open ben_plan_design_program_module.g_table_route('PRP');

3011: --
3012: for l_prp_rec in c_prp(l_parent_rec.pl_regy_prps_id,l_mirror_src_entity_result_id,'PRP') loop
3013: --
3014: l_table_route_id := null ;
3015: open ben_plan_design_program_module.g_table_route('PRP');
3016: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
3017: close ben_plan_design_program_module.g_table_route ;
3018: --
3019: l_information5 := hr_general.decode_lookup('BEN_REGY_PRPS',l_prp_rec.pl_regy_prps_cd);

Line 3016: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;

3012: for l_prp_rec in c_prp(l_parent_rec.pl_regy_prps_id,l_mirror_src_entity_result_id,'PRP') loop
3013: --
3014: l_table_route_id := null ;
3015: open ben_plan_design_program_module.g_table_route('PRP');
3016: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
3017: close ben_plan_design_program_module.g_table_route ;
3018: --
3019: l_information5 := hr_general.decode_lookup('BEN_REGY_PRPS',l_prp_rec.pl_regy_prps_cd);
3020: --

Line 3017: close ben_plan_design_program_module.g_table_route ;

3013: --
3014: l_table_route_id := null ;
3015: open ben_plan_design_program_module.g_table_route('PRP');
3016: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
3017: close ben_plan_design_program_module.g_table_route ;
3018: --
3019: l_information5 := hr_general.decode_lookup('BEN_REGY_PRPS',l_prp_rec.pl_regy_prps_cd);
3020: --
3021: if p_effective_date between l_prp_rec.effective_start_date

Line 3136: open ben_plan_design_program_module.g_table_route('VGS');

3132: --
3133: for l_vgs_rec in c_vgs(l_parent_rec.pl_gd_or_svc_id,l_mirror_src_entity_result_id,'VGS') loop
3134: --
3135: l_table_route_id := null ;
3136: open ben_plan_design_program_module.g_table_route('VGS');
3137: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
3138: close ben_plan_design_program_module.g_table_route ;
3139: --
3140: l_information5 := ben_plan_design_program_module.get_gd_or_svc_typ_name(l_vgs_rec.gd_or_svc_typ_id); --'Intersection'

Line 3137: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;

3133: for l_vgs_rec in c_vgs(l_parent_rec.pl_gd_or_svc_id,l_mirror_src_entity_result_id,'VGS') loop
3134: --
3135: l_table_route_id := null ;
3136: open ben_plan_design_program_module.g_table_route('VGS');
3137: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
3138: close ben_plan_design_program_module.g_table_route ;
3139: --
3140: l_information5 := ben_plan_design_program_module.get_gd_or_svc_typ_name(l_vgs_rec.gd_or_svc_typ_id); --'Intersection'
3141: --

Line 3138: close ben_plan_design_program_module.g_table_route ;

3134: --
3135: l_table_route_id := null ;
3136: open ben_plan_design_program_module.g_table_route('VGS');
3137: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
3138: close ben_plan_design_program_module.g_table_route ;
3139: --
3140: l_information5 := ben_plan_design_program_module.get_gd_or_svc_typ_name(l_vgs_rec.gd_or_svc_typ_id); --'Intersection'
3141: --
3142: if p_effective_date between l_vgs_rec.effective_start_date

Line 3140: l_information5 := ben_plan_design_program_module.get_gd_or_svc_typ_name(l_vgs_rec.gd_or_svc_typ_id); --'Intersection'

3136: open ben_plan_design_program_module.g_table_route('VGS');
3137: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
3138: close ben_plan_design_program_module.g_table_route ;
3139: --
3140: l_information5 := ben_plan_design_program_module.get_gd_or_svc_typ_name(l_vgs_rec.gd_or_svc_typ_id); --'Intersection'
3141: --
3142: if p_effective_date between l_vgs_rec.effective_start_date
3143: and l_vgs_rec.effective_end_date then
3144: --

Line 3229: if ben_plan_design_program_module.g_pdw_allow_dup_rslt = ben_plan_design_program_module.g_pdw_no_dup_rslt then

3225: l_mirror_src_entity_result_id := l_out_vgs_result_id;
3226:
3227: l_gd_or_svc_typ_id := l_parent_rec.gd_or_svc_typ_id ;
3228:
3229: if ben_plan_design_program_module.g_pdw_allow_dup_rslt = ben_plan_design_program_module.g_pdw_no_dup_rslt then
3230: open c_object_exists(l_gd_or_svc_typ_id,'GOS');
3231: fetch c_object_exists into l_dummy;
3232: if c_object_exists%found then
3233: close c_object_exists;

Line 3243: open ben_plan_design_program_module.g_table_route('GOS');

3239: --
3240: for l_gos_rec in c_gos(l_parent_rec.gd_or_svc_typ_id,l_mirror_src_entity_result_id,'GOS') loop
3241: --
3242: l_table_route_id := null ;
3243: open ben_plan_design_program_module.g_table_route('GOS');
3244: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
3245: close ben_plan_design_program_module.g_table_route ;
3246: --
3247: l_information5 := l_gos_rec.name; --'Intersection';

Line 3244: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;

3240: for l_gos_rec in c_gos(l_parent_rec.gd_or_svc_typ_id,l_mirror_src_entity_result_id,'GOS') loop
3241: --
3242: l_table_route_id := null ;
3243: open ben_plan_design_program_module.g_table_route('GOS');
3244: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
3245: close ben_plan_design_program_module.g_table_route ;
3246: --
3247: l_information5 := l_gos_rec.name; --'Intersection';
3248: --

Line 3245: close ben_plan_design_program_module.g_table_route ;

3241: --
3242: l_table_route_id := null ;
3243: open ben_plan_design_program_module.g_table_route('GOS');
3244: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
3245: close ben_plan_design_program_module.g_table_route ;
3246: --
3247: l_information5 := l_gos_rec.name; --'Intersection';
3248: --
3249: l_gd_or_svc_typ_id := l_gos_rec.gd_or_svc_typ_id ;

Line 3334: open ben_plan_design_program_module.g_table_route('PCT');

3330: --
3331: for l_pct_rec in c_pct(l_parent_rec.pl_gd_r_svc_ctfn_id,l_mirror_src_entity_result_id,'PCT') loop
3332: --
3333: l_table_route_id := null ;
3334: open ben_plan_design_program_module.g_table_route('PCT');
3335: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
3336: close ben_plan_design_program_module.g_table_route ;
3337: --
3338: l_information5 := hr_general.decode_lookup('BEN_REIMBMT_CTFN_TYP',l_pct_rec.rmbmt_ctfn_typ_cd); --'Intersection

Line 3335: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;

3331: for l_pct_rec in c_pct(l_parent_rec.pl_gd_r_svc_ctfn_id,l_mirror_src_entity_result_id,'PCT') loop
3332: --
3333: l_table_route_id := null ;
3334: open ben_plan_design_program_module.g_table_route('PCT');
3335: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
3336: close ben_plan_design_program_module.g_table_route ;
3337: --
3338: l_information5 := hr_general.decode_lookup('BEN_REIMBMT_CTFN_TYP',l_pct_rec.rmbmt_ctfn_typ_cd); --'Intersection
3339: --

Line 3336: close ben_plan_design_program_module.g_table_route ;

3332: --
3333: l_table_route_id := null ;
3334: open ben_plan_design_program_module.g_table_route('PCT');
3335: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
3336: close ben_plan_design_program_module.g_table_route ;
3337: --
3338: l_information5 := hr_general.decode_lookup('BEN_REIMBMT_CTFN_TYP',l_pct_rec.rmbmt_ctfn_typ_cd); --'Intersection
3339: --
3340: l_pl_gd_r_svc_ctfn_id := l_pct_rec.pl_gd_r_svc_ctfn_id ;

Line 3417: ben_plan_design_program_module.create_formula_result(

3413: l_out_pct_result_id := l_copy_entity_result_id ;
3414: end if;
3415:
3416: if (l_pct_rec.ctfn_rqd_when_rl is not null) then
3417: ben_plan_design_program_module.create_formula_result(
3418: p_validate => p_validate
3419: ,p_copy_entity_result_id => l_copy_entity_result_id
3420: ,p_copy_entity_txn_id => p_copy_entity_txn_id
3421: ,p_formula_id => l_pct_rec.ctfn_rqd_when_rl

Line 3429: ben_plan_design_program_module.create_formula_result(

3425: ,p_effective_date => p_effective_date);
3426: end if;
3427:
3428: if (l_pct_rec.lack_ctfn_deny_rmbmt_rl is not null) then
3429: ben_plan_design_program_module.create_formula_result(
3430: p_validate => p_validate
3431: ,p_copy_entity_result_id => l_copy_entity_result_id
3432: ,p_copy_entity_txn_id => p_copy_entity_txn_id
3433: ,p_formula_id => l_pct_rec.lack_ctfn_deny_rmbmt_rl

Line 3463: open ben_plan_design_program_module.g_table_route('VRP');

3459: --
3460: for l_vrp_rec in c_vrp(l_parent_rec.vald_rlshp_for_reimb_id,l_mirror_src_entity_result_id,'VRP') loop
3461: --
3462: l_table_route_id := null ;
3463: open ben_plan_design_program_module.g_table_route('VRP');
3464: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
3465: close ben_plan_design_program_module.g_table_route ;
3466: --
3467: l_information5 := hr_general.decode_lookup('CONTACT',l_vrp_rec.rlshp_typ_cd); --'Intersection

Line 3464: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;

3460: for l_vrp_rec in c_vrp(l_parent_rec.vald_rlshp_for_reimb_id,l_mirror_src_entity_result_id,'VRP') loop
3461: --
3462: l_table_route_id := null ;
3463: open ben_plan_design_program_module.g_table_route('VRP');
3464: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
3465: close ben_plan_design_program_module.g_table_route ;
3466: --
3467: l_information5 := hr_general.decode_lookup('CONTACT',l_vrp_rec.rlshp_typ_cd); --'Intersection
3468: --

Line 3465: close ben_plan_design_program_module.g_table_route ;

3461: --
3462: l_table_route_id := null ;
3463: open ben_plan_design_program_module.g_table_route('VRP');
3464: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
3465: close ben_plan_design_program_module.g_table_route ;
3466: --
3467: l_information5 := hr_general.decode_lookup('CONTACT',l_vrp_rec.rlshp_typ_cd); --'Intersection
3468: --
3469: if p_effective_date between l_vrp_rec.effective_start_date

Line 3560: open ben_plan_design_program_module.g_table_route('WPN');

3556: --
3557: for l_wpn_rec in c_wpn(l_parent_rec.wv_prtn_rsn_pl_id,l_mirror_src_entity_result_id,'WPN') loop
3558: --
3559: l_table_route_id := null ;
3560: open ben_plan_design_program_module.g_table_route('WPN');
3561: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
3562: close ben_plan_design_program_module.g_table_route ;
3563: --
3564: l_information5 := hr_general.decode_lookup('BEN_WV_PRTN_RSN',l_wpn_rec.wv_prtn_rsn_cd); --'Intersection';

Line 3561: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;

3557: for l_wpn_rec in c_wpn(l_parent_rec.wv_prtn_rsn_pl_id,l_mirror_src_entity_result_id,'WPN') loop
3558: --
3559: l_table_route_id := null ;
3560: open ben_plan_design_program_module.g_table_route('WPN');
3561: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
3562: close ben_plan_design_program_module.g_table_route ;
3563: --
3564: l_information5 := hr_general.decode_lookup('BEN_WV_PRTN_RSN',l_wpn_rec.wv_prtn_rsn_cd); --'Intersection';
3565: --

Line 3562: close ben_plan_design_program_module.g_table_route ;

3558: --
3559: l_table_route_id := null ;
3560: open ben_plan_design_program_module.g_table_route('WPN');
3561: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
3562: close ben_plan_design_program_module.g_table_route ;
3563: --
3564: l_information5 := hr_general.decode_lookup('BEN_WV_PRTN_RSN',l_wpn_rec.wv_prtn_rsn_cd); --'Intersection';
3565: --
3566: l_wv_prtn_rsn_pl_id := l_wpn_rec.wv_prtn_rsn_pl_id ;

Line 3654: open ben_plan_design_program_module.g_table_route('WCN');

3650: --
3651: for l_wcn_rec in c_wcn(l_parent_rec.wv_prtn_rsn_ctfn_pl_id,l_mirror_src_entity_result_id,'WCN') loop
3652: --
3653: l_table_route_id := null ;
3654: open ben_plan_design_program_module.g_table_route('WCN');
3655: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
3656: close ben_plan_design_program_module.g_table_route ;
3657: --
3658: l_information5 := hr_general.decode_lookup('BEN_WV_PRTN_CTFN_TYP',l_wcn_rec.wv_prtn_ctfn_typ_cd); --'Intersection';

Line 3655: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;

3651: for l_wcn_rec in c_wcn(l_parent_rec.wv_prtn_rsn_ctfn_pl_id,l_mirror_src_entity_result_id,'WCN') loop
3652: --
3653: l_table_route_id := null ;
3654: open ben_plan_design_program_module.g_table_route('WCN');
3655: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
3656: close ben_plan_design_program_module.g_table_route ;
3657: --
3658: l_information5 := hr_general.decode_lookup('BEN_WV_PRTN_CTFN_TYP',l_wcn_rec.wv_prtn_ctfn_typ_cd); --'Intersection';
3659: --

Line 3656: close ben_plan_design_program_module.g_table_route ;

3652: --
3653: l_table_route_id := null ;
3654: open ben_plan_design_program_module.g_table_route('WCN');
3655: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
3656: close ben_plan_design_program_module.g_table_route ;
3657: --
3658: l_information5 := hr_general.decode_lookup('BEN_WV_PRTN_CTFN_TYP',l_wcn_rec.wv_prtn_ctfn_typ_cd); --'Intersection';
3659: --
3660: l_wv_prtn_rsn_ctfn_pl_id := l_wcn_rec.wv_prtn_rsn_ctfn_pl_id ;

Line 3736: ben_plan_design_program_module.create_formula_result(

3732: l_out_wcn_result_id := l_copy_entity_result_id ;
3733: end if;
3734:
3735: if (l_wcn_rec.ctfn_rqd_when_rl is not null) then
3736: ben_plan_design_program_module.create_formula_result(
3737: p_validate => p_validate
3738: ,p_copy_entity_result_id => l_copy_entity_result_id
3739: ,p_copy_entity_txn_id => p_copy_entity_txn_id
3740: ,p_formula_id => l_wcn_rec.ctfn_rqd_when_rl

Line 3774: open ben_plan_design_program_module.g_table_route('BRC');

3770: --
3771: for l_brc_rec in c_brc(l_parent_rec.bnft_rstrn_ctfn_id,l_mirror_src_entity_result_id,'BRC') loop
3772: --
3773: l_table_route_id := null ;
3774: open ben_plan_design_program_module.g_table_route('BRC');
3775: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
3776: close ben_plan_design_program_module.g_table_route ;
3777: --
3778: l_information5 := hr_general.decode_lookup('BEN_ENRT_CTFN_TYP',l_brc_rec.enrt_ctfn_typ_cd); --'Intersection';

Line 3775: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;

3771: for l_brc_rec in c_brc(l_parent_rec.bnft_rstrn_ctfn_id,l_mirror_src_entity_result_id,'BRC') loop
3772: --
3773: l_table_route_id := null ;
3774: open ben_plan_design_program_module.g_table_route('BRC');
3775: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
3776: close ben_plan_design_program_module.g_table_route ;
3777: --
3778: l_information5 := hr_general.decode_lookup('BEN_ENRT_CTFN_TYP',l_brc_rec.enrt_ctfn_typ_cd); --'Intersection';
3779: --

Line 3776: close ben_plan_design_program_module.g_table_route ;

3772: --
3773: l_table_route_id := null ;
3774: open ben_plan_design_program_module.g_table_route('BRC');
3775: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
3776: close ben_plan_design_program_module.g_table_route ;
3777: --
3778: l_information5 := hr_general.decode_lookup('BEN_ENRT_CTFN_TYP',l_brc_rec.enrt_ctfn_typ_cd); --'Intersection';
3779: --
3780: if p_effective_date between l_brc_rec.effective_start_date

Line 3853: ben_plan_design_program_module.create_formula_result(

3849: l_out_brc_result_id := l_copy_entity_result_id ;
3850: end if;
3851:
3852: if (l_brc_rec.ctfn_rqd_when_rl is not null) then
3853: ben_plan_design_program_module.create_formula_result(
3854: p_validate => p_validate
3855: ,p_copy_entity_result_id => l_copy_entity_result_id
3856: ,p_copy_entity_txn_id => p_copy_entity_txn_id
3857: ,p_formula_id => l_brc_rec.ctfn_rqd_when_rl

Line 3887: open ben_plan_design_program_module.g_table_route('LBR');

3883: --
3884: for l_lbr_rec in c_lbr(l_parent_rec.ler_bnft_rstrn_id,l_mirror_src_entity_result_id,'LBR') loop
3885: --
3886: l_table_route_id := null ;
3887: open ben_plan_design_program_module.g_table_route('LBR');
3888: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
3889: close ben_plan_design_program_module.g_table_route ;
3890: --
3891: l_information5 := ben_plan_design_program_module.get_ler_name(l_lbr_rec.ler_id,p_effective_date); --'Intersection';

Line 3888: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;

3884: for l_lbr_rec in c_lbr(l_parent_rec.ler_bnft_rstrn_id,l_mirror_src_entity_result_id,'LBR') loop
3885: --
3886: l_table_route_id := null ;
3887: open ben_plan_design_program_module.g_table_route('LBR');
3888: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
3889: close ben_plan_design_program_module.g_table_route ;
3890: --
3891: l_information5 := ben_plan_design_program_module.get_ler_name(l_lbr_rec.ler_id,p_effective_date); --'Intersection';
3892: --

Line 3889: close ben_plan_design_program_module.g_table_route ;

3885: --
3886: l_table_route_id := null ;
3887: open ben_plan_design_program_module.g_table_route('LBR');
3888: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
3889: close ben_plan_design_program_module.g_table_route ;
3890: --
3891: l_information5 := ben_plan_design_program_module.get_ler_name(l_lbr_rec.ler_id,p_effective_date); --'Intersection';
3892: --
3893: l_ler_bnft_rstrn_id := l_lbr_rec.ler_bnft_rstrn_id ;

Line 3891: l_information5 := ben_plan_design_program_module.get_ler_name(l_lbr_rec.ler_id,p_effective_date); --'Intersection';

3887: open ben_plan_design_program_module.g_table_route('LBR');
3888: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
3889: close ben_plan_design_program_module.g_table_route ;
3890: --
3891: l_information5 := ben_plan_design_program_module.get_ler_name(l_lbr_rec.ler_id,p_effective_date); --'Intersection';
3892: --
3893: l_ler_bnft_rstrn_id := l_lbr_rec.ler_bnft_rstrn_id ;
3894: --
3895: if p_effective_date between l_lbr_rec.effective_start_date

Line 3986: ben_plan_design_program_module.create_formula_result(

3982: l_out_lbr_result_id := l_copy_entity_result_id ;
3983: end if;
3984: --
3985: if (l_lbr_rec.dflt_to_asn_pndg_ctfn_rl is not null) then
3986: ben_plan_design_program_module.create_formula_result(
3987: p_validate => p_validate
3988: ,p_copy_entity_result_id => l_copy_entity_result_id
3989: ,p_copy_entity_txn_id => p_copy_entity_txn_id
3990: ,p_formula_id => l_lbr_rec.dflt_to_asn_pndg_ctfn_rl

Line 3998: ben_plan_design_program_module.create_formula_result(

3994: ,p_effective_date => p_effective_date);
3995: end if;
3996:
3997: if (l_lbr_rec.mn_cvg_rl is not null) then
3998: ben_plan_design_program_module.create_formula_result(
3999: p_validate => p_validate
4000: ,p_copy_entity_result_id => l_copy_entity_result_id
4001: ,p_copy_entity_txn_id => p_copy_entity_txn_id
4002: ,p_formula_id => l_lbr_rec.mn_cvg_rl

Line 4010: ben_plan_design_program_module.create_formula_result(

4006: ,p_effective_date => p_effective_date);
4007: end if;
4008:
4009: if (l_lbr_rec.mx_cvg_rl is not null) then
4010: ben_plan_design_program_module.create_formula_result(
4011: p_validate => p_validate
4012: ,p_copy_entity_result_id => l_copy_entity_result_id
4013: ,p_copy_entity_txn_id => p_copy_entity_txn_id
4014: ,p_formula_id => l_lbr_rec.mx_cvg_rl

Line 4051: open ben_plan_design_program_module.g_table_route('LBC');

4047: --
4048: for l_lbc_rec in c_lbc(l_parent_rec.ler_bnft_rstrn_ctfn_id,l_mirror_src_entity_result_id,'LBC') loop
4049: --
4050: l_table_route_id := null ;
4051: open ben_plan_design_program_module.g_table_route('LBC');
4052: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
4053: close ben_plan_design_program_module.g_table_route ;
4054: --
4055: l_information5 := hr_general.decode_lookup('BEN_ENRT_CTFN_TYP',l_lbc_rec.enrt_ctfn_typ_cd); --'Intersection';

Line 4052: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;

4048: for l_lbc_rec in c_lbc(l_parent_rec.ler_bnft_rstrn_ctfn_id,l_mirror_src_entity_result_id,'LBC') loop
4049: --
4050: l_table_route_id := null ;
4051: open ben_plan_design_program_module.g_table_route('LBC');
4052: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
4053: close ben_plan_design_program_module.g_table_route ;
4054: --
4055: l_information5 := hr_general.decode_lookup('BEN_ENRT_CTFN_TYP',l_lbc_rec.enrt_ctfn_typ_cd); --'Intersection';
4056: --

Line 4053: close ben_plan_design_program_module.g_table_route ;

4049: --
4050: l_table_route_id := null ;
4051: open ben_plan_design_program_module.g_table_route('LBC');
4052: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
4053: close ben_plan_design_program_module.g_table_route ;
4054: --
4055: l_information5 := hr_general.decode_lookup('BEN_ENRT_CTFN_TYP',l_lbc_rec.enrt_ctfn_typ_cd); --'Intersection';
4056: --
4057: l_ler_bnft_rstrn_ctfn_id := l_lbc_rec.ler_bnft_rstrn_ctfn_id ;

Line 4131: ben_plan_design_program_module.create_formula_result(

4127: l_out_lbc_result_id := l_copy_entity_result_id ;
4128: end if;
4129:
4130: if (l_lbc_rec.ctfn_rqd_when_rl is not null) then
4131: ben_plan_design_program_module.create_formula_result(
4132: p_validate => p_validate
4133: ,p_copy_entity_result_id => l_copy_entity_result_id
4134: ,p_copy_entity_txn_id => p_copy_entity_txn_id
4135: ,p_formula_id => l_lbc_rec.ctfn_rqd_when_rl

Line 4170: open ben_plan_design_program_module.g_table_route('ECF');

4166: --
4167: for l_ecf_rec in c_ecf(l_parent_rec.enrt_ctfn_id,l_mirror_src_entity_result_id,'ECF') loop
4168: --
4169: l_table_route_id := null ;
4170: open ben_plan_design_program_module.g_table_route('ECF');
4171: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
4172: close ben_plan_design_program_module.g_table_route ;
4173: --
4174: l_information5 := hr_general.decode_lookup('BEN_ENRT_CTFN_TYP',l_ecf_rec.enrt_ctfn_typ_cd); --'Intersection';

Line 4171: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;

4167: for l_ecf_rec in c_ecf(l_parent_rec.enrt_ctfn_id,l_mirror_src_entity_result_id,'ECF') loop
4168: --
4169: l_table_route_id := null ;
4170: open ben_plan_design_program_module.g_table_route('ECF');
4171: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
4172: close ben_plan_design_program_module.g_table_route ;
4173: --
4174: l_information5 := hr_general.decode_lookup('BEN_ENRT_CTFN_TYP',l_ecf_rec.enrt_ctfn_typ_cd); --'Intersection';
4175: --

Line 4172: close ben_plan_design_program_module.g_table_route ;

4168: --
4169: l_table_route_id := null ;
4170: open ben_plan_design_program_module.g_table_route('ECF');
4171: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
4172: close ben_plan_design_program_module.g_table_route ;
4173: --
4174: l_information5 := hr_general.decode_lookup('BEN_ENRT_CTFN_TYP',l_ecf_rec.enrt_ctfn_typ_cd); --'Intersection';
4175: --
4176: if p_effective_date between l_ecf_rec.effective_start_date

Line 4251: ben_plan_design_program_module.create_formula_result(

4247: l_out_ecf_result_id := l_copy_entity_result_id ;
4248: end if;
4249:
4250: if (l_ecf_rec.ctfn_rqd_when_rl is not null) then
4251: ben_plan_design_program_module.create_formula_result(
4252: p_validate => p_validate
4253: ,p_copy_entity_result_id => l_copy_entity_result_id
4254: ,p_copy_entity_txn_id => p_copy_entity_txn_id
4255: ,p_formula_id => l_ecf_rec.ctfn_rqd_when_rl

Line 4286: open ben_plan_design_program_module.g_table_route('LDC');

4282: --
4283: for l_ldc_rec in c_ldc(l_parent_rec.ler_chg_dpnt_cvg_id,l_mirror_src_entity_result_id,'LDC') loop
4284: --
4285: l_table_route_id := null ;
4286: open ben_plan_design_program_module.g_table_route('LDC');
4287: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
4288: close ben_plan_design_program_module.g_table_route ;
4289: --
4290: l_information5 := ben_plan_design_program_module.get_ler_name(l_ldc_rec.ler_id,p_effective_date); --'Intersection'

Line 4287: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;

4283: for l_ldc_rec in c_ldc(l_parent_rec.ler_chg_dpnt_cvg_id,l_mirror_src_entity_result_id,'LDC') loop
4284: --
4285: l_table_route_id := null ;
4286: open ben_plan_design_program_module.g_table_route('LDC');
4287: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
4288: close ben_plan_design_program_module.g_table_route ;
4289: --
4290: l_information5 := ben_plan_design_program_module.get_ler_name(l_ldc_rec.ler_id,p_effective_date); --'Intersection'
4291: --

Line 4288: close ben_plan_design_program_module.g_table_route ;

4284: --
4285: l_table_route_id := null ;
4286: open ben_plan_design_program_module.g_table_route('LDC');
4287: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
4288: close ben_plan_design_program_module.g_table_route ;
4289: --
4290: l_information5 := ben_plan_design_program_module.get_ler_name(l_ldc_rec.ler_id,p_effective_date); --'Intersection'
4291: --
4292: l_ler_chg_dpnt_cvg_id := l_ldc_rec.ler_chg_dpnt_cvg_id;

Line 4290: l_information5 := ben_plan_design_program_module.get_ler_name(l_ldc_rec.ler_id,p_effective_date); --'Intersection'

4286: open ben_plan_design_program_module.g_table_route('LDC');
4287: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
4288: close ben_plan_design_program_module.g_table_route ;
4289: --
4290: l_information5 := ben_plan_design_program_module.get_ler_name(l_ldc_rec.ler_id,p_effective_date); --'Intersection'
4291: --
4292: l_ler_chg_dpnt_cvg_id := l_ldc_rec.ler_chg_dpnt_cvg_id;
4293: if p_effective_date between l_ldc_rec.effective_start_date
4294: and l_ldc_rec.effective_end_date then

Line 4375: ben_plan_design_program_module.create_formula_result(

4371: l_out_ldc_result_id := l_copy_entity_result_id ;
4372: end if;
4373: --
4374: if (l_ldc_rec.cvg_eff_end_rl is not null) then
4375: ben_plan_design_program_module.create_formula_result(
4376: p_validate => p_validate
4377: ,p_copy_entity_result_id => l_copy_entity_result_id
4378: ,p_copy_entity_txn_id => p_copy_entity_txn_id
4379: ,p_formula_id => l_ldc_rec.cvg_eff_end_rl

Line 4387: ben_plan_design_program_module.create_formula_result(

4383: ,p_effective_date => p_effective_date);
4384: end if;
4385:
4386: if (l_ldc_rec.cvg_eff_strt_rl is not null) then
4387: ben_plan_design_program_module.create_formula_result(
4388: p_validate => p_validate
4389: ,p_copy_entity_result_id => l_copy_entity_result_id
4390: ,p_copy_entity_txn_id => p_copy_entity_txn_id
4391: ,p_formula_id => l_ldc_rec.cvg_eff_strt_rl

Line 4399: ben_plan_design_program_module.create_formula_result(

4395: ,p_effective_date => p_effective_date);
4396: end if;
4397:
4398: if (l_ldc_rec.ler_chg_dpnt_cvg_rl is not null) then
4399: ben_plan_design_program_module.create_formula_result(
4400: p_validate => p_validate
4401: ,p_copy_entity_result_id => l_copy_entity_result_id
4402: ,p_copy_entity_txn_id => p_copy_entity_txn_id
4403: ,p_formula_id => l_ldc_rec.ler_chg_dpnt_cvg_rl

Line 4437: open ben_plan_design_program_module.g_table_route('LCC');

4433: --
4434: for l_lcc_rec in c_lcc(l_parent_rec.ler_chg_dpnt_cvg_ctfn_id,l_mirror_src_entity_result_id,'LCC') loop
4435: --
4436: l_table_route_id := null ;
4437: open ben_plan_design_program_module.g_table_route('LCC');
4438: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
4439: close ben_plan_design_program_module.g_table_route ;
4440: --
4441: l_information5 := hr_general.decode_lookup('BEN_DPNT_CVG_CTFN_TYP',l_lcc_rec.dpnt_cvg_ctfn_typ_cd); --'Intersection';

Line 4438: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;

4434: for l_lcc_rec in c_lcc(l_parent_rec.ler_chg_dpnt_cvg_ctfn_id,l_mirror_src_entity_result_id,'LCC') loop
4435: --
4436: l_table_route_id := null ;
4437: open ben_plan_design_program_module.g_table_route('LCC');
4438: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
4439: close ben_plan_design_program_module.g_table_route ;
4440: --
4441: l_information5 := hr_general.decode_lookup('BEN_DPNT_CVG_CTFN_TYP',l_lcc_rec.dpnt_cvg_ctfn_typ_cd); --'Intersection';
4442: --

Line 4439: close ben_plan_design_program_module.g_table_route ;

4435: --
4436: l_table_route_id := null ;
4437: open ben_plan_design_program_module.g_table_route('LCC');
4438: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
4439: close ben_plan_design_program_module.g_table_route ;
4440: --
4441: l_information5 := hr_general.decode_lookup('BEN_DPNT_CVG_CTFN_TYP',l_lcc_rec.dpnt_cvg_ctfn_typ_cd); --'Intersection';
4442: --
4443: l_ler_chg_dpnt_cvg_ctfn_id := l_lcc_rec.ler_chg_dpnt_cvg_ctfn_id ;

Line 4519: ben_plan_design_program_module.create_formula_result(

4515: l_out_lcc_result_id := l_copy_entity_result_id ;
4516: end if;
4517:
4518: if (l_lcc_rec.ctfn_rqd_when_rl is not null) then
4519: ben_plan_design_program_module.create_formula_result(
4520: p_validate => p_validate
4521: ,p_copy_entity_result_id => l_copy_entity_result_id
4522: ,p_copy_entity_txn_id => p_copy_entity_txn_id
4523: ,p_formula_id => l_lcc_rec.ctfn_rqd_when_rl

Line 4557: open ben_plan_design_program_module.g_table_route('LPE');

4553: --
4554: for l_lpe_rec in c_lpe(l_parent_rec.ler_chg_pl_nip_enrt_id,l_mirror_src_entity_result_id,'LPE') loop
4555: --
4556: l_table_route_id := null ;
4557: open ben_plan_design_program_module.g_table_route('LPE');
4558: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
4559: close ben_plan_design_program_module.g_table_route ;
4560: --
4561: l_information5 := ben_plan_design_program_module.get_ler_name(l_lpe_rec.ler_id,p_effective_date); --'Intersection';

Line 4558: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;

4554: for l_lpe_rec in c_lpe(l_parent_rec.ler_chg_pl_nip_enrt_id,l_mirror_src_entity_result_id,'LPE') loop
4555: --
4556: l_table_route_id := null ;
4557: open ben_plan_design_program_module.g_table_route('LPE');
4558: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
4559: close ben_plan_design_program_module.g_table_route ;
4560: --
4561: l_information5 := ben_plan_design_program_module.get_ler_name(l_lpe_rec.ler_id,p_effective_date); --'Intersection';
4562: --

Line 4559: close ben_plan_design_program_module.g_table_route ;

4555: --
4556: l_table_route_id := null ;
4557: open ben_plan_design_program_module.g_table_route('LPE');
4558: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
4559: close ben_plan_design_program_module.g_table_route ;
4560: --
4561: l_information5 := ben_plan_design_program_module.get_ler_name(l_lpe_rec.ler_id,p_effective_date); --'Intersection';
4562: --
4563: if p_effective_date between l_lpe_rec.effective_start_date

Line 4561: l_information5 := ben_plan_design_program_module.get_ler_name(l_lpe_rec.ler_id,p_effective_date); --'Intersection';

4557: open ben_plan_design_program_module.g_table_route('LPE');
4558: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
4559: close ben_plan_design_program_module.g_table_route ;
4560: --
4561: l_information5 := ben_plan_design_program_module.get_ler_name(l_lpe_rec.ler_id,p_effective_date); --'Intersection';
4562: --
4563: if p_effective_date between l_lpe_rec.effective_start_date
4564: and l_lpe_rec.effective_end_date then
4565: --

Line 4643: ben_plan_design_program_module.create_formula_result(

4639: l_out_lpe_result_id := l_copy_entity_result_id ;
4640: end if;
4641: --
4642: if (l_lpe_rec.auto_enrt_mthd_rl is not null) then
4643: ben_plan_design_program_module.create_formula_result(
4644: p_validate => p_validate
4645: ,p_copy_entity_result_id => l_copy_entity_result_id
4646: ,p_copy_entity_txn_id => p_copy_entity_txn_id
4647: ,p_formula_id => l_lpe_rec.auto_enrt_mthd_rl

Line 4655: ben_plan_design_program_module.create_formula_result(

4651: ,p_effective_date => p_effective_date);
4652: end if;
4653:
4654: if (l_lpe_rec.dflt_enrt_rl is not null) then
4655: ben_plan_design_program_module.create_formula_result(
4656: p_validate => p_validate
4657: ,p_copy_entity_result_id => l_copy_entity_result_id
4658: ,p_copy_entity_txn_id => p_copy_entity_txn_id
4659: ,p_formula_id => l_lpe_rec.dflt_enrt_rl

Line 4667: ben_plan_design_program_module.create_formula_result(

4663: ,p_effective_date => p_effective_date);
4664: end if;
4665:
4666: if (l_lpe_rec.enrt_rl is not null) then
4667: ben_plan_design_program_module.create_formula_result(
4668: p_validate => p_validate
4669: ,p_copy_entity_result_id => l_copy_entity_result_id
4670: ,p_copy_entity_txn_id => p_copy_entity_txn_id
4671: ,p_formula_id => l_lpe_rec.enrt_rl

Line 4713: open ben_plan_design_program_module.g_table_route('LRE');

4709: --
4710: for l_lre_rec in c_lre(l_parent_rec.ler_rqrs_enrt_ctfn_id,l_mirror_src_entity_result_id,'LRE') loop
4711: --
4712: l_table_route_id := null ;
4713: open ben_plan_design_program_module.g_table_route('LRE');
4714: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
4715: close ben_plan_design_program_module.g_table_route ;
4716: --
4717: l_information5 := ben_plan_design_program_module.get_ler_name(l_lre_rec.ler_id,p_effective_date); --'Intersection';

Line 4714: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;

4710: for l_lre_rec in c_lre(l_parent_rec.ler_rqrs_enrt_ctfn_id,l_mirror_src_entity_result_id,'LRE') loop
4711: --
4712: l_table_route_id := null ;
4713: open ben_plan_design_program_module.g_table_route('LRE');
4714: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
4715: close ben_plan_design_program_module.g_table_route ;
4716: --
4717: l_information5 := ben_plan_design_program_module.get_ler_name(l_lre_rec.ler_id,p_effective_date); --'Intersection';
4718: --

Line 4715: close ben_plan_design_program_module.g_table_route ;

4711: --
4712: l_table_route_id := null ;
4713: open ben_plan_design_program_module.g_table_route('LRE');
4714: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
4715: close ben_plan_design_program_module.g_table_route ;
4716: --
4717: l_information5 := ben_plan_design_program_module.get_ler_name(l_lre_rec.ler_id,p_effective_date); --'Intersection';
4718: --
4719: if p_effective_date between l_lre_rec.effective_start_date

Line 4717: l_information5 := ben_plan_design_program_module.get_ler_name(l_lre_rec.ler_id,p_effective_date); --'Intersection';

4713: open ben_plan_design_program_module.g_table_route('LRE');
4714: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
4715: close ben_plan_design_program_module.g_table_route ;
4716: --
4717: l_information5 := ben_plan_design_program_module.get_ler_name(l_lre_rec.ler_id,p_effective_date); --'Intersection';
4718: --
4719: if p_effective_date between l_lre_rec.effective_start_date
4720: and l_lre_rec.effective_end_date then
4721: --

Line 4796: ben_plan_design_program_module.create_formula_result(

4792: l_out_lre_result_id := l_copy_entity_result_id ;
4793: end if;
4794: --
4795: if (l_lre_rec.ctfn_rqd_when_rl is not null) then
4796: ben_plan_design_program_module.create_formula_result(
4797: p_validate => p_validate
4798: ,p_copy_entity_result_id => l_copy_entity_result_id
4799: ,p_copy_entity_txn_id => p_copy_entity_txn_id
4800: ,p_formula_id => l_lre_rec.ctfn_rqd_when_rl

Line 4835: open ben_plan_design_program_module.g_table_route('LNC');

4831: --
4832: for l_lnc_rec in c_lnc(l_parent_rec.ler_enrt_ctfn_id,l_mirror_src_entity_result_id,'LNC') loop
4833: --
4834: l_table_route_id := null ;
4835: open ben_plan_design_program_module.g_table_route('LNC');
4836: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
4837: close ben_plan_design_program_module.g_table_route ;
4838: --
4839: l_information5 := hr_general.decode_lookup('BEN_ENRT_CTFN_TYP',l_lnc_rec.enrt_ctfn_typ_cd); --'Intersection';

Line 4836: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;

4832: for l_lnc_rec in c_lnc(l_parent_rec.ler_enrt_ctfn_id,l_mirror_src_entity_result_id,'LNC') loop
4833: --
4834: l_table_route_id := null ;
4835: open ben_plan_design_program_module.g_table_route('LNC');
4836: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
4837: close ben_plan_design_program_module.g_table_route ;
4838: --
4839: l_information5 := hr_general.decode_lookup('BEN_ENRT_CTFN_TYP',l_lnc_rec.enrt_ctfn_typ_cd); --'Intersection';
4840: --

Line 4837: close ben_plan_design_program_module.g_table_route ;

4833: --
4834: l_table_route_id := null ;
4835: open ben_plan_design_program_module.g_table_route('LNC');
4836: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
4837: close ben_plan_design_program_module.g_table_route ;
4838: --
4839: l_information5 := hr_general.decode_lookup('BEN_ENRT_CTFN_TYP',l_lnc_rec.enrt_ctfn_typ_cd); --'Intersection';
4840: --
4841: l_ler_enrt_ctfn_id := l_lnc_rec.ler_enrt_ctfn_id ;

Line 4914: ben_plan_design_program_module.create_formula_result(

4910: if l_result_type_cd = 'DISPLAY' then
4911: l_out_lnc_result_id := l_copy_entity_result_id ;
4912: end if;
4913: if (l_lnc_rec.ctfn_rqd_when_rl is not null) then
4914: ben_plan_design_program_module.create_formula_result(
4915: p_validate => p_validate
4916: ,p_copy_entity_result_id => l_copy_entity_result_id
4917: ,p_copy_entity_txn_id => p_copy_entity_txn_id
4918: ,p_formula_id => l_lnc_rec.ctfn_rqd_when_rl

Line 4951: open ben_plan_design_program_module.g_table_route('PCP');

4947: --
4948: for l_pcp_rec in c_pcp(l_parent_rec.pl_pcp_id,l_mirror_src_entity_result_id,'PCP') loop
4949: --
4950: l_table_route_id := null ;
4951: open ben_plan_design_program_module.g_table_route('PCP');
4952: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
4953: close ben_plan_design_program_module.g_table_route ;
4954: --
4955: l_information5 := fnd_message.get_string('BEN','BEN_93292_PDC_PCP_DSGN_CD') ||' - '||

Line 4952: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;

4948: for l_pcp_rec in c_pcp(l_parent_rec.pl_pcp_id,l_mirror_src_entity_result_id,'PCP') loop
4949: --
4950: l_table_route_id := null ;
4951: open ben_plan_design_program_module.g_table_route('PCP');
4952: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
4953: close ben_plan_design_program_module.g_table_route ;
4954: --
4955: l_information5 := fnd_message.get_string('BEN','BEN_93292_PDC_PCP_DSGN_CD') ||' - '||
4956: hr_general.decode_lookup('BEN_PCP_DSGN',l_pcp_rec.pcp_dsgn_cd) ||' - '||

Line 4953: close ben_plan_design_program_module.g_table_route ;

4949: --
4950: l_table_route_id := null ;
4951: open ben_plan_design_program_module.g_table_route('PCP');
4952: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
4953: close ben_plan_design_program_module.g_table_route ;
4954: --
4955: l_information5 := fnd_message.get_string('BEN','BEN_93292_PDC_PCP_DSGN_CD') ||' - '||
4956: hr_general.decode_lookup('BEN_PCP_DSGN',l_pcp_rec.pcp_dsgn_cd) ||' - '||
4957: fnd_message.get_string('BEN','BEN_93293_PDC_PCP_DPNT_DSGN_CD') ||' - '||

Line 5054: open ben_plan_design_program_module.g_table_route('PTY');

5050: --
5051: for l_pty_rec in c_pty(l_parent_rec.pl_pcp_typ_id,l_mirror_src_entity_result_id,'PTY') loop
5052: --
5053: l_table_route_id := null ;
5054: open ben_plan_design_program_module.g_table_route('PTY');
5055: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
5056: close ben_plan_design_program_module.g_table_route ;
5057: --
5058: l_information5 := hr_general.decode_lookup('BEN_PCP_SPCLTY',l_pty_rec.pcp_typ_cd); --'Intersection

Line 5055: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;

5051: for l_pty_rec in c_pty(l_parent_rec.pl_pcp_typ_id,l_mirror_src_entity_result_id,'PTY') loop
5052: --
5053: l_table_route_id := null ;
5054: open ben_plan_design_program_module.g_table_route('PTY');
5055: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
5056: close ben_plan_design_program_module.g_table_route ;
5057: --
5058: l_information5 := hr_general.decode_lookup('BEN_PCP_SPCLTY',l_pty_rec.pcp_typ_cd); --'Intersection
5059: --

Line 5056: close ben_plan_design_program_module.g_table_route ;

5052: --
5053: l_table_route_id := null ;
5054: open ben_plan_design_program_module.g_table_route('PTY');
5055: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
5056: close ben_plan_design_program_module.g_table_route ;
5057: --
5058: l_information5 := hr_general.decode_lookup('BEN_PCP_SPCLTY',l_pty_rec.pcp_typ_cd); --'Intersection
5059: --
5060: l_result_type_cd := 'DISPLAY';

Line 5148: open ben_plan_design_program_module.g_table_route('PCX');

5144: --
5145: for l_pcx_rec in c_pcx(l_parent_rec.pl_bnf_ctfn_id,l_mirror_src_entity_result_id,'PCX') loop
5146: --
5147: l_table_route_id := null ;
5148: open ben_plan_design_program_module.g_table_route('PCX');
5149: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
5150: close ben_plan_design_program_module.g_table_route ;
5151: --
5152: l_information5 := hr_general.decode_lookup('BEN_BNF_CTFN_TYP',l_pcx_rec.bnf_ctfn_typ_cd); --'Intersection

Line 5149: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;

5145: for l_pcx_rec in c_pcx(l_parent_rec.pl_bnf_ctfn_id,l_mirror_src_entity_result_id,'PCX') loop
5146: --
5147: l_table_route_id := null ;
5148: open ben_plan_design_program_module.g_table_route('PCX');
5149: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
5150: close ben_plan_design_program_module.g_table_route ;
5151: --
5152: l_information5 := hr_general.decode_lookup('BEN_BNF_CTFN_TYP',l_pcx_rec.bnf_ctfn_typ_cd); --'Intersection
5153: --

Line 5150: close ben_plan_design_program_module.g_table_route ;

5146: --
5147: l_table_route_id := null ;
5148: open ben_plan_design_program_module.g_table_route('PCX');
5149: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
5150: close ben_plan_design_program_module.g_table_route ;
5151: --
5152: l_information5 := hr_general.decode_lookup('BEN_BNF_CTFN_TYP',l_pcx_rec.bnf_ctfn_typ_cd); --'Intersection
5153: --
5154: if p_effective_date between l_pcx_rec.effective_start_date

Line 5230: ben_plan_design_program_module.create_formula_result(

5226: if l_result_type_cd = 'DISPLAY' then
5227: l_out_pcx_result_id := l_copy_entity_result_id ;
5228: end if;
5229: if (l_pcx_rec.ctfn_rqd_when_rl is not null) then
5230: ben_plan_design_program_module.create_formula_result(
5231: p_validate => p_validate
5232: ,p_copy_entity_result_id => l_copy_entity_result_id
5233: ,p_copy_entity_txn_id => p_copy_entity_txn_id
5234: ,p_formula_id => l_pcx_rec.ctfn_rqd_when_rl

Line 5263: open ben_plan_design_program_module.g_table_route('PND');

5259: --
5260: for l_pnd_rec in c_pnd(l_parent_rec.pl_dpnt_cvg_ctfn_id,l_mirror_src_entity_result_id,'PND') loop
5261: --
5262: l_table_route_id := null ;
5263: open ben_plan_design_program_module.g_table_route('PND');
5264: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
5265: close ben_plan_design_program_module.g_table_route ;
5266: --
5267: l_information5 := hr_general.decode_lookup('BEN_DPNT_CVG_CTFN_TYP',l_pnd_rec.dpnt_cvg_ctfn_typ_cd); --'Intersection

Line 5264: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;

5260: for l_pnd_rec in c_pnd(l_parent_rec.pl_dpnt_cvg_ctfn_id,l_mirror_src_entity_result_id,'PND') loop
5261: --
5262: l_table_route_id := null ;
5263: open ben_plan_design_program_module.g_table_route('PND');
5264: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
5265: close ben_plan_design_program_module.g_table_route ;
5266: --
5267: l_information5 := hr_general.decode_lookup('BEN_DPNT_CVG_CTFN_TYP',l_pnd_rec.dpnt_cvg_ctfn_typ_cd); --'Intersection
5268: --

Line 5265: close ben_plan_design_program_module.g_table_route ;

5261: --
5262: l_table_route_id := null ;
5263: open ben_plan_design_program_module.g_table_route('PND');
5264: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
5265: close ben_plan_design_program_module.g_table_route ;
5266: --
5267: l_information5 := hr_general.decode_lookup('BEN_DPNT_CVG_CTFN_TYP',l_pnd_rec.dpnt_cvg_ctfn_typ_cd); --'Intersection
5268: --
5269: if p_effective_date between l_pnd_rec.effective_start_date

Line 5345: ben_plan_design_program_module.create_formula_result(

5341: l_out_pnd_result_id := l_copy_entity_result_id ;
5342: end if;
5343:
5344: if (l_pnd_rec.ctfn_rqd_when_rl is not null) then
5345: ben_plan_design_program_module.create_formula_result(
5346: p_validate => p_validate
5347: ,p_copy_entity_result_id => l_copy_entity_result_id
5348: ,p_copy_entity_txn_id => p_copy_entity_txn_id
5349: ,p_formula_id => l_pnd_rec.ctfn_rqd_when_rl

Line 5379: open ben_plan_design_program_module.g_table_route('PEO');

5375: --
5376: for l_peo_rec in c_peo(l_parent_rec.elig_to_prte_rsn_id,l_mirror_src_entity_result_id,'PEO') loop
5377: --
5378: l_table_route_id := null ;
5379: open ben_plan_design_program_module.g_table_route('PEO');
5380: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
5381: close ben_plan_design_program_module.g_table_route ;
5382: --
5383: l_information5 := ben_plan_design_program_module.get_ler_name(l_peo_rec.ler_id,p_effective_date); --'Intersection';

Line 5380: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;

5376: for l_peo_rec in c_peo(l_parent_rec.elig_to_prte_rsn_id,l_mirror_src_entity_result_id,'PEO') loop
5377: --
5378: l_table_route_id := null ;
5379: open ben_plan_design_program_module.g_table_route('PEO');
5380: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
5381: close ben_plan_design_program_module.g_table_route ;
5382: --
5383: l_information5 := ben_plan_design_program_module.get_ler_name(l_peo_rec.ler_id,p_effective_date); --'Intersection';
5384: --

Line 5381: close ben_plan_design_program_module.g_table_route ;

5377: --
5378: l_table_route_id := null ;
5379: open ben_plan_design_program_module.g_table_route('PEO');
5380: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
5381: close ben_plan_design_program_module.g_table_route ;
5382: --
5383: l_information5 := ben_plan_design_program_module.get_ler_name(l_peo_rec.ler_id,p_effective_date); --'Intersection';
5384: --
5385: if p_effective_date between l_peo_rec.effective_start_date

Line 5383: l_information5 := ben_plan_design_program_module.get_ler_name(l_peo_rec.ler_id,p_effective_date); --'Intersection';

5379: open ben_plan_design_program_module.g_table_route('PEO');
5380: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
5381: close ben_plan_design_program_module.g_table_route ;
5382: --
5383: l_information5 := ben_plan_design_program_module.get_ler_name(l_peo_rec.ler_id,p_effective_date); --'Intersection';
5384: --
5385: if p_effective_date between l_peo_rec.effective_start_date
5386: and l_peo_rec.effective_end_date then
5387: --

Line 5480: ben_plan_design_program_module.create_formula_result(

5476: l_out_peo_result_id := l_copy_entity_result_id ;
5477: end if;
5478:
5479: if (l_peo_rec.mx_poe_det_dt_rl is not null) then
5480: ben_plan_design_program_module.create_formula_result(
5481: p_validate => p_validate
5482: ,p_copy_entity_result_id => l_copy_entity_result_id
5483: ,p_copy_entity_txn_id => p_copy_entity_txn_id
5484: ,p_formula_id => l_peo_rec.mx_poe_det_dt_rl

Line 5492: ben_plan_design_program_module.create_formula_result(

5488: ,p_effective_date => p_effective_date);
5489: end if;
5490:
5491: if (l_peo_rec.mx_poe_rl is not null) then
5492: ben_plan_design_program_module.create_formula_result(
5493: p_validate => p_validate
5494: ,p_copy_entity_result_id => l_copy_entity_result_id
5495: ,p_copy_entity_txn_id => p_copy_entity_txn_id
5496: ,p_formula_id => l_peo_rec.mx_poe_rl

Line 5504: ben_plan_design_program_module.create_formula_result(

5500: ,p_effective_date => p_effective_date);
5501: end if;
5502:
5503: if (l_peo_rec.prtn_eff_end_dt_rl is not null) then
5504: ben_plan_design_program_module.create_formula_result(
5505: p_validate => p_validate
5506: ,p_copy_entity_result_id => l_copy_entity_result_id
5507: ,p_copy_entity_txn_id => p_copy_entity_txn_id
5508: ,p_formula_id => l_peo_rec.prtn_eff_end_dt_rl

Line 5516: ben_plan_design_program_module.create_formula_result(

5512: ,p_effective_date => p_effective_date);
5513: end if;
5514:
5515: if (l_peo_rec.prtn_eff_strt_dt_rl is not null) then
5516: ben_plan_design_program_module.create_formula_result(
5517: p_validate => p_validate
5518: ,p_copy_entity_result_id => l_copy_entity_result_id
5519: ,p_copy_entity_txn_id => p_copy_entity_txn_id
5520: ,p_formula_id => l_peo_rec.prtn_eff_strt_dt_rl

Line 5528: ben_plan_design_program_module.create_formula_result(

5524: ,p_effective_date => p_effective_date);
5525: end if;
5526:
5527: if (l_peo_rec.vrfy_fmly_mmbr_rl is not null) then
5528: ben_plan_design_program_module.create_formula_result(
5529: p_validate => p_validate
5530: ,p_copy_entity_result_id => l_copy_entity_result_id
5531: ,p_copy_entity_txn_id => p_copy_entity_txn_id
5532: ,p_formula_id => l_peo_rec.vrfy_fmly_mmbr_rl

Line 5540: ben_plan_design_program_module.create_formula_result(

5536: ,p_effective_date => p_effective_date);
5537: end if;
5538:
5539: if (l_peo_rec.wait_perd_dt_to_use_rl is not null) then
5540: ben_plan_design_program_module.create_formula_result(
5541: p_validate => p_validate
5542: ,p_copy_entity_result_id => l_copy_entity_result_id
5543: ,p_copy_entity_txn_id => p_copy_entity_txn_id
5544: ,p_formula_id => l_peo_rec.wait_perd_dt_to_use_rl

Line 5552: ben_plan_design_program_module.create_formula_result(

5548: ,p_effective_date => p_effective_date);
5549: end if;
5550:
5551: if (l_peo_rec.wait_perd_rl is not null) then
5552: ben_plan_design_program_module.create_formula_result(
5553: p_validate => p_validate
5554: ,p_copy_entity_result_id => l_copy_entity_result_id
5555: ,p_copy_entity_txn_id => p_copy_entity_txn_id
5556: ,p_formula_id => l_peo_rec.wait_perd_rl

Line 5598: open ben_plan_design_program_module.g_table_route('DDR');

5594: --
5595: for l_ddr_rec in c_ddr3(l_parent_rec.dsgn_rqmt_id,l_mirror_src_entity_result_id,'DDR') loop
5596: --
5597: l_table_route_id := null ;
5598: open ben_plan_design_program_module.g_table_route('DDR');
5599: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
5600: close ben_plan_design_program_module.g_table_route ;
5601: --
5602: l_information5 := hr_general.decode_lookup('BEN_GRP_RLSHP',l_ddr_rec.grp_rlshp_cd); --'Intersection';

Line 5599: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;

5595: for l_ddr_rec in c_ddr3(l_parent_rec.dsgn_rqmt_id,l_mirror_src_entity_result_id,'DDR') loop
5596: --
5597: l_table_route_id := null ;
5598: open ben_plan_design_program_module.g_table_route('DDR');
5599: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
5600: close ben_plan_design_program_module.g_table_route ;
5601: --
5602: l_information5 := hr_general.decode_lookup('BEN_GRP_RLSHP',l_ddr_rec.grp_rlshp_cd); --'Intersection';
5603: --

Line 5600: close ben_plan_design_program_module.g_table_route ;

5596: --
5597: l_table_route_id := null ;
5598: open ben_plan_design_program_module.g_table_route('DDR');
5599: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
5600: close ben_plan_design_program_module.g_table_route ;
5601: --
5602: l_information5 := hr_general.decode_lookup('BEN_GRP_RLSHP',l_ddr_rec.grp_rlshp_cd); --'Intersection';
5603: --
5604: if p_effective_date between l_ddr_rec.effective_start_date

Line 5705: open ben_plan_design_program_module.g_table_route('DRR');

5701: --
5702: for l_drr_rec in c_drr3(l_parent_rec.dsgn_rqmt_rlshp_typ_id,l_mirror_src_entity_result_id,'DRR') loop
5703: --
5704: l_table_route_id := null ;
5705: open ben_plan_design_program_module.g_table_route('DRR');
5706: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
5707: close ben_plan_design_program_module.g_table_route ;
5708: --
5709: l_information5 := hr_general.decode_lookup('CONTACT',l_drr_rec.rlshp_typ_cd); --'Intersection';

Line 5706: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;

5702: for l_drr_rec in c_drr3(l_parent_rec.dsgn_rqmt_rlshp_typ_id,l_mirror_src_entity_result_id,'DRR') loop
5703: --
5704: l_table_route_id := null ;
5705: open ben_plan_design_program_module.g_table_route('DRR');
5706: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
5707: close ben_plan_design_program_module.g_table_route ;
5708: --
5709: l_information5 := hr_general.decode_lookup('CONTACT',l_drr_rec.rlshp_typ_cd); --'Intersection';
5710: --

Line 5707: close ben_plan_design_program_module.g_table_route ;

5703: --
5704: l_table_route_id := null ;
5705: open ben_plan_design_program_module.g_table_route('DRR');
5706: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
5707: close ben_plan_design_program_module.g_table_route ;
5708: --
5709: l_information5 := hr_general.decode_lookup('CONTACT',l_drr_rec.rlshp_typ_cd); --'Intersection';
5710: --
5711: l_result_type_cd := 'DISPLAY';

Line 6711: open ben_plan_design_program_module.g_table_route('PAT');

6707:
6708: for l_pat_rec in c_pat(l_parent_rec.popl_actn_typ_id,l_mirror_src_entity_result_id,'PAT') loop
6709: --
6710: l_table_route_id := null ;
6711: open ben_plan_design_program_module.g_table_route('PAT');
6712: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
6713: close ben_plan_design_program_module.g_table_route ;
6714: --
6715: l_information5 := ben_plan_design_program_module.get_actn_typ_name(l_pat_rec.actn_typ_id); --'Intersection;

Line 6712: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;

6708: for l_pat_rec in c_pat(l_parent_rec.popl_actn_typ_id,l_mirror_src_entity_result_id,'PAT') loop
6709: --
6710: l_table_route_id := null ;
6711: open ben_plan_design_program_module.g_table_route('PAT');
6712: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
6713: close ben_plan_design_program_module.g_table_route ;
6714: --
6715: l_information5 := ben_plan_design_program_module.get_actn_typ_name(l_pat_rec.actn_typ_id); --'Intersection;
6716: --

Line 6713: close ben_plan_design_program_module.g_table_route ;

6709: --
6710: l_table_route_id := null ;
6711: open ben_plan_design_program_module.g_table_route('PAT');
6712: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
6713: close ben_plan_design_program_module.g_table_route ;
6714: --
6715: l_information5 := ben_plan_design_program_module.get_actn_typ_name(l_pat_rec.actn_typ_id); --'Intersection;
6716: --
6717: --

Line 6715: l_information5 := ben_plan_design_program_module.get_actn_typ_name(l_pat_rec.actn_typ_id); --'Intersection;

6711: open ben_plan_design_program_module.g_table_route('PAT');
6712: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
6713: close ben_plan_design_program_module.g_table_route ;
6714: --
6715: l_information5 := ben_plan_design_program_module.get_actn_typ_name(l_pat_rec.actn_typ_id); --'Intersection;
6716: --
6717: --
6718: if p_effective_date between l_pat_rec.effective_start_date
6719: and l_pat_rec.effective_end_date then

Line 6792: ben_plan_design_program_module.create_formula_result(

6788: l_out_pat_result_id := l_copy_entity_result_id ;
6789: end if;
6790:
6791: if (l_pat_rec.actn_typ_due_dt_rl is not null) then
6792: ben_plan_design_program_module.create_formula_result(
6793: p_validate => p_validate
6794: ,p_copy_entity_result_id => l_copy_entity_result_id
6795: ,p_copy_entity_txn_id => p_copy_entity_txn_id
6796: ,p_formula_id => l_pat_rec.actn_typ_due_dt_rl

Line 6816: if ben_plan_design_program_module.g_pdw_allow_dup_rslt = ben_plan_design_program_module.g_pdw_no_dup_rslt then

6812: l_mirror_src_entity_result_id := l_out_pat_result_id ;
6813:
6814: l_actn_typ_id := l_parent_rec.actn_typ_id ;
6815:
6816: if ben_plan_design_program_module.g_pdw_allow_dup_rslt = ben_plan_design_program_module.g_pdw_no_dup_rslt then
6817: open c_object_exists(l_actn_typ_id,'EAT');
6818: fetch c_object_exists into l_dummy;
6819: if c_object_exists%found then
6820: close c_object_exists;

Line 6830: open ben_plan_design_program_module.g_table_route('EAT');

6826: for l_eat_rec in c_eat(l_parent_rec.actn_typ_id,l_mirror_src_entity_result_id,'EAT') loop
6827: --
6828: --
6829: l_table_route_id := null ;
6830: open ben_plan_design_program_module.g_table_route('EAT');
6831: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
6832: close ben_plan_design_program_module.g_table_route ;
6833: --
6834: l_information5 := l_eat_rec.name; --'Intersection';

Line 6831: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;

6827: --
6828: --
6829: l_table_route_id := null ;
6830: open ben_plan_design_program_module.g_table_route('EAT');
6831: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
6832: close ben_plan_design_program_module.g_table_route ;
6833: --
6834: l_information5 := l_eat_rec.name; --'Intersection';
6835: --

Line 6832: close ben_plan_design_program_module.g_table_route ;

6828: --
6829: l_table_route_id := null ;
6830: open ben_plan_design_program_module.g_table_route('EAT');
6831: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
6832: close ben_plan_design_program_module.g_table_route ;
6833: --
6834: l_information5 := l_eat_rec.name; --'Intersection';
6835: --
6836: l_result_type_cd := 'DISPLAY';

Line 6930: open ben_plan_design_program_module.g_table_route('PET');

6926: for l_pet_rec in c_pet(l_parent_rec.popl_enrt_typ_cycl_id,l_mirror_src_entity_result_id,'PET') loop
6927: --
6928: --
6929: l_table_route_id := null ;
6930: open ben_plan_design_program_module.g_table_route('PET');
6931: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
6932: close ben_plan_design_program_module.g_table_route ;
6933: --
6934: l_information5 := hr_general.decode_lookup('BEN_ENRT_TYP_CYCL',l_pet_rec.enrt_typ_cycl_cd); --'Intersection';

Line 6931: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;

6927: --
6928: --
6929: l_table_route_id := null ;
6930: open ben_plan_design_program_module.g_table_route('PET');
6931: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
6932: close ben_plan_design_program_module.g_table_route ;
6933: --
6934: l_information5 := hr_general.decode_lookup('BEN_ENRT_TYP_CYCL',l_pet_rec.enrt_typ_cycl_cd); --'Intersection';
6935: if p_effective_date between l_pet_rec.effective_start_date

Line 6932: close ben_plan_design_program_module.g_table_route ;

6928: --
6929: l_table_route_id := null ;
6930: open ben_plan_design_program_module.g_table_route('PET');
6931: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
6932: close ben_plan_design_program_module.g_table_route ;
6933: --
6934: l_information5 := hr_general.decode_lookup('BEN_ENRT_TYP_CYCL',l_pet_rec.enrt_typ_cycl_cd); --'Intersection';
6935: if p_effective_date between l_pet_rec.effective_start_date
6936: and l_pet_rec.effective_end_date then

Line 7028: open ben_plan_design_program_module.g_table_route('ENP');

7024: for l_enp_rec in c_enp(l_parent_rec.enrt_perd_id,l_mirror_src_entity_result_id,'ENP') loop
7025: --
7026: --
7027: l_table_route_id := null ;
7028: open ben_plan_design_program_module.g_table_route('ENP');
7029: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
7030: close ben_plan_design_program_module.g_table_route ;
7031: --
7032: l_information5 := TO_CHAR(l_enp_rec.strt_dt,'DD-Mon-YYYY')||' - '||

Line 7029: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;

7025: --
7026: --
7027: l_table_route_id := null ;
7028: open ben_plan_design_program_module.g_table_route('ENP');
7029: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
7030: close ben_plan_design_program_module.g_table_route ;
7031: --
7032: l_information5 := TO_CHAR(l_enp_rec.strt_dt,'DD-Mon-YYYY')||' - '||
7033: TO_CHAR(l_enp_rec.end_dt,'DD-Mon-YYYY'); --'Intersection';

Line 7030: close ben_plan_design_program_module.g_table_route ;

7026: --
7027: l_table_route_id := null ;
7028: open ben_plan_design_program_module.g_table_route('ENP');
7029: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
7030: close ben_plan_design_program_module.g_table_route ;
7031: --
7032: l_information5 := TO_CHAR(l_enp_rec.strt_dt,'DD-Mon-YYYY')||' - '||
7033: TO_CHAR(l_enp_rec.end_dt,'DD-Mon-YYYY'); --'Intersection';
7034: --

Line 7201: ben_plan_design_program_module.create_formula_result(

7197: );
7198: end if;
7199: --
7200: if (l_enp_rec.enrt_cvg_strt_dt_rl is not null) then
7201: ben_plan_design_program_module.create_formula_result(
7202: p_validate => p_validate
7203: ,p_copy_entity_result_id => l_copy_entity_result_id
7204: ,p_copy_entity_txn_id => p_copy_entity_txn_id
7205: ,p_formula_id => l_enp_rec.enrt_cvg_strt_dt_rl

Line 7213: ben_plan_design_program_module.create_formula_result(

7209: ,p_effective_date => p_effective_date);
7210: end if;
7211: --
7212: if (l_enp_rec.hrchy_rl is not null) then
7213: ben_plan_design_program_module.create_formula_result(
7214: p_validate => p_validate
7215: ,p_copy_entity_result_id => l_copy_entity_result_id
7216: ,p_copy_entity_txn_id => p_copy_entity_txn_id
7217: ,p_formula_id => l_enp_rec.hrchy_rl

Line 7225: ben_plan_design_program_module.create_formula_result(

7221: ,p_effective_date => p_effective_date);
7222: end if;
7223:
7224: if (l_enp_rec.enrt_cvg_end_dt_rl is not null) then
7225: ben_plan_design_program_module.create_formula_result(
7226: p_validate => p_validate
7227: ,p_copy_entity_result_id => l_copy_entity_result_id
7228: ,p_copy_entity_txn_id => p_copy_entity_txn_id
7229: ,p_formula_id => l_enp_rec.enrt_cvg_end_dt_rl

Line 7237: ben_plan_design_program_module.create_formula_result(

7233: ,p_effective_date => p_effective_date);
7234: end if;
7235:
7236: if (l_enp_rec.rt_end_dt_rl is not null) then
7237: ben_plan_design_program_module.create_formula_result(
7238: p_validate => p_validate
7239: ,p_copy_entity_result_id => l_copy_entity_result_id
7240: ,p_copy_entity_txn_id => p_copy_entity_txn_id
7241: ,p_formula_id => l_enp_rec.rt_end_dt_rl

Line 7249: ben_plan_design_program_module.create_formula_result(

7245: ,p_effective_date => p_effective_date);
7246: end if;
7247:
7248: if (l_enp_rec.rt_strt_dt_rl is not null) then
7249: ben_plan_design_program_module.create_formula_result(
7250: p_validate => p_validate
7251: ,p_copy_entity_result_id => l_copy_entity_result_id
7252: ,p_copy_entity_txn_id => p_copy_entity_txn_id
7253: ,p_formula_id => l_enp_rec.rt_strt_dt_rl

Line 7299: open ben_plan_design_program_module.g_table_route('ERP');

7295: for l_erp_rec in c_erp(l_parent_rec.enrt_perd_for_pl_id,l_mirror_src_entity_result_id,'ERP') loop
7296: --
7297: --
7298: l_table_route_id := null ;
7299: open ben_plan_design_program_module.g_table_route('ERP');
7300: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
7301: close ben_plan_design_program_module.g_table_route ;
7302: --
7303: l_information5 := ben_plan_design_program_module.get_pl_name(l_erp_rec.pl_id,p_effective_date);--'Intersection'

Line 7300: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;

7296: --
7297: --
7298: l_table_route_id := null ;
7299: open ben_plan_design_program_module.g_table_route('ERP');
7300: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
7301: close ben_plan_design_program_module.g_table_route ;
7302: --
7303: l_information5 := ben_plan_design_program_module.get_pl_name(l_erp_rec.pl_id,p_effective_date);--'Intersection'
7304: --

Line 7301: close ben_plan_design_program_module.g_table_route ;

7297: --
7298: l_table_route_id := null ;
7299: open ben_plan_design_program_module.g_table_route('ERP');
7300: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
7301: close ben_plan_design_program_module.g_table_route ;
7302: --
7303: l_information5 := ben_plan_design_program_module.get_pl_name(l_erp_rec.pl_id,p_effective_date);--'Intersection'
7304: --
7305: if p_effective_date between l_erp_rec.effective_start_date

Line 7303: l_information5 := ben_plan_design_program_module.get_pl_name(l_erp_rec.pl_id,p_effective_date);--'Intersection'

7299: open ben_plan_design_program_module.g_table_route('ERP');
7300: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
7301: close ben_plan_design_program_module.g_table_route ;
7302: --
7303: l_information5 := ben_plan_design_program_module.get_pl_name(l_erp_rec.pl_id,p_effective_date);--'Intersection'
7304: --
7305: if p_effective_date between l_erp_rec.effective_start_date
7306: and l_erp_rec.effective_end_date then
7307: --

Line 7385: ben_plan_design_program_module.create_formula_result(

7381: l_out_erp_result_id := l_copy_entity_result_id ;
7382: end if;
7383:
7384: if (l_erp_rec.enrt_cvg_strt_dt_rl is not null) then
7385: ben_plan_design_program_module.create_formula_result(
7386: p_validate => p_validate
7387: ,p_copy_entity_result_id => l_copy_entity_result_id
7388: ,p_copy_entity_txn_id => p_copy_entity_txn_id
7389: ,p_formula_id => l_erp_rec.enrt_cvg_strt_dt_rl

Line 7397: ben_plan_design_program_module.create_formula_result(

7393: ,p_effective_date => p_effective_date);
7394: end if;
7395:
7396: if (l_erp_rec.enrt_cvg_end_dt_rl is not null) then
7397: ben_plan_design_program_module.create_formula_result(
7398: p_validate => p_validate
7399: ,p_copy_entity_result_id => l_copy_entity_result_id
7400: ,p_copy_entity_txn_id => p_copy_entity_txn_id
7401: ,p_formula_id => l_erp_rec.enrt_cvg_end_dt_rl

Line 7409: ben_plan_design_program_module.create_formula_result(

7405: ,p_effective_date => p_effective_date);
7406: end if;
7407:
7408: if (l_erp_rec.rt_end_dt_rl is not null) then
7409: ben_plan_design_program_module.create_formula_result(
7410: p_validate => p_validate
7411: ,p_copy_entity_result_id => l_copy_entity_result_id
7412: ,p_copy_entity_txn_id => p_copy_entity_txn_id
7413: ,p_formula_id => l_erp_rec.rt_end_dt_rl

Line 7421: ben_plan_design_program_module.create_formula_result(

7417: ,p_effective_date => p_effective_date);
7418: end if;
7419:
7420: if (l_erp_rec.rt_strt_dt_rl is not null) then
7421: ben_plan_design_program_module.create_formula_result(
7422: p_validate => p_validate
7423: ,p_copy_entity_result_id => l_copy_entity_result_id
7424: ,p_copy_entity_txn_id => p_copy_entity_txn_id
7425: ,p_formula_id => l_erp_rec.rt_strt_dt_rl

Line 7453: open ben_plan_design_program_module.g_table_route('SER');

7449: for l_ser_rec in c_ser(l_parent_rec.schedd_enrt_rl_id,l_mirror_src_entity_result_id,'SER') loop
7450: --
7451: --
7452: l_table_route_id := null ;
7453: open ben_plan_design_program_module.g_table_route('SER');
7454: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
7455: close ben_plan_design_program_module.g_table_route ;
7456: --
7457: l_information5 := ben_plan_design_program_module.get_formula_name(l_ser_rec.formula_id,p_effective_date); --'Intersection';

Line 7454: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;

7450: --
7451: --
7452: l_table_route_id := null ;
7453: open ben_plan_design_program_module.g_table_route('SER');
7454: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
7455: close ben_plan_design_program_module.g_table_route ;
7456: --
7457: l_information5 := ben_plan_design_program_module.get_formula_name(l_ser_rec.formula_id,p_effective_date); --'Intersection';
7458: --

Line 7455: close ben_plan_design_program_module.g_table_route ;

7451: --
7452: l_table_route_id := null ;
7453: open ben_plan_design_program_module.g_table_route('SER');
7454: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
7455: close ben_plan_design_program_module.g_table_route ;
7456: --
7457: l_information5 := ben_plan_design_program_module.get_formula_name(l_ser_rec.formula_id,p_effective_date); --'Intersection';
7458: --
7459: if p_effective_date between l_ser_rec.effective_start_date

Line 7457: l_information5 := ben_plan_design_program_module.get_formula_name(l_ser_rec.formula_id,p_effective_date); --'Intersection';

7453: open ben_plan_design_program_module.g_table_route('SER');
7454: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
7455: close ben_plan_design_program_module.g_table_route ;
7456: --
7457: l_information5 := ben_plan_design_program_module.get_formula_name(l_ser_rec.formula_id,p_effective_date); --'Intersection';
7458: --
7459: if p_effective_date between l_ser_rec.effective_start_date
7460: and l_ser_rec.effective_end_date then
7461: --

Line 7531: ben_plan_design_program_module.create_formula_result(

7527: l_out_ser_result_id := l_copy_entity_result_id ;
7528: end if;
7529:
7530: if (l_ser_rec.formula_id is not null) then
7531: ben_plan_design_program_module.create_formula_result(
7532: p_validate => p_validate
7533: ,p_copy_entity_result_id => l_copy_entity_result_id
7534: ,p_copy_entity_txn_id => p_copy_entity_txn_id
7535: ,p_formula_id => l_ser_rec.formula_id

Line 7567: open ben_plan_design_program_module.g_table_route('LEN');

7563: for l_len_rec in c_len(l_parent_rec.lee_rsn_id,l_mirror_src_entity_result_id,'LEN') loop
7564: --
7565: --
7566: l_table_route_id := null ;
7567: open ben_plan_design_program_module.g_table_route('LEN');
7568: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
7569: close ben_plan_design_program_module.g_table_route ;
7570: --
7571: l_information5 := ben_plan_design_program_module.get_ler_name(l_len_rec.ler_id,p_effective_date); --'Intersection';

Line 7568: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;

7564: --
7565: --
7566: l_table_route_id := null ;
7567: open ben_plan_design_program_module.g_table_route('LEN');
7568: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
7569: close ben_plan_design_program_module.g_table_route ;
7570: --
7571: l_information5 := ben_plan_design_program_module.get_ler_name(l_len_rec.ler_id,p_effective_date); --'Intersection';
7572: --

Line 7569: close ben_plan_design_program_module.g_table_route ;

7565: --
7566: l_table_route_id := null ;
7567: open ben_plan_design_program_module.g_table_route('LEN');
7568: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
7569: close ben_plan_design_program_module.g_table_route ;
7570: --
7571: l_information5 := ben_plan_design_program_module.get_ler_name(l_len_rec.ler_id,p_effective_date); --'Intersection';
7572: --
7573: if p_effective_date between l_len_rec.effective_start_date

Line 7571: l_information5 := ben_plan_design_program_module.get_ler_name(l_len_rec.ler_id,p_effective_date); --'Intersection';

7567: open ben_plan_design_program_module.g_table_route('LEN');
7568: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
7569: close ben_plan_design_program_module.g_table_route ;
7570: --
7571: l_information5 := ben_plan_design_program_module.get_ler_name(l_len_rec.ler_id,p_effective_date); --'Intersection';
7572: --
7573: if p_effective_date between l_len_rec.effective_start_date
7574: and l_len_rec.effective_end_date then
7575: --

Line 7669: ben_plan_design_program_module.create_formula_result(

7665: end if;
7666: --
7667:
7668: if (l_len_rec.enrt_cvg_end_dt_rl is not null) then
7669: ben_plan_design_program_module.create_formula_result(
7670: p_validate => p_validate
7671: ,p_copy_entity_result_id => l_copy_entity_result_id
7672: ,p_copy_entity_txn_id => p_copy_entity_txn_id
7673: ,p_formula_id => l_len_rec.enrt_cvg_end_dt_rl

Line 7681: ben_plan_design_program_module.create_formula_result(

7677: ,p_effective_date => p_effective_date);
7678: end if;
7679:
7680: if (l_len_rec.enrt_cvg_strt_dt_rl is not null) then
7681: ben_plan_design_program_module.create_formula_result(
7682: p_validate => p_validate
7683: ,p_copy_entity_result_id => l_copy_entity_result_id
7684: ,p_copy_entity_txn_id => p_copy_entity_txn_id
7685: ,p_formula_id => l_len_rec.enrt_cvg_strt_dt_rl

Line 7693: ben_plan_design_program_module.create_formula_result(

7689: ,p_effective_date => p_effective_date);
7690: end if;
7691:
7692: if (l_len_rec.enrt_perd_end_dt_rl is not null) then
7693: ben_plan_design_program_module.create_formula_result(
7694: p_validate => p_validate
7695: ,p_copy_entity_result_id => l_copy_entity_result_id
7696: ,p_copy_entity_txn_id => p_copy_entity_txn_id
7697: ,p_formula_id => l_len_rec.enrt_perd_end_dt_rl

Line 7705: ben_plan_design_program_module.create_formula_result(

7701: ,p_effective_date => p_effective_date);
7702: end if;
7703:
7704: if (l_len_rec.enrt_perd_strt_dt_rl is not null) then
7705: ben_plan_design_program_module.create_formula_result(
7706: p_validate => p_validate
7707: ,p_copy_entity_result_id => l_copy_entity_result_id
7708: ,p_copy_entity_txn_id => p_copy_entity_txn_id
7709: ,p_formula_id => l_len_rec.enrt_perd_strt_dt_rl

Line 7717: ben_plan_design_program_module.create_formula_result(

7713: ,p_effective_date => p_effective_date);
7714: end if;
7715:
7716: if (l_len_rec.rt_end_dt_rl is not null) then
7717: ben_plan_design_program_module.create_formula_result(
7718: p_validate => p_validate
7719: ,p_copy_entity_result_id => l_copy_entity_result_id
7720: ,p_copy_entity_txn_id => p_copy_entity_txn_id
7721: ,p_formula_id => l_len_rec.rt_end_dt_rl

Line 7728: ben_plan_design_program_module.create_formula_result(

7724: ,p_object_version_number => l_object_version_number
7725: ,p_effective_date => p_effective_date);
7726: end if;
7727: if (l_len_rec.rt_strt_dt_rl is not null) then
7728: ben_plan_design_program_module.create_formula_result(
7729: p_validate => p_validate
7730: ,p_copy_entity_result_id => l_copy_entity_result_id
7731: ,p_copy_entity_txn_id => p_copy_entity_txn_id
7732: ,p_formula_id => l_len_rec.rt_strt_dt_rl

Line 7770: open ben_plan_design_program_module.g_table_route('ERP');

7766: for l_erp_rec in c_erp1(l_parent_rec.enrt_perd_for_pl_id,l_mirror_src_entity_result_id,'ERP') loop
7767: --
7768: --
7769: l_table_route_id := null ;
7770: open ben_plan_design_program_module.g_table_route('ERP');
7771: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
7772: close ben_plan_design_program_module.g_table_route ;
7773: --
7774: l_information5 := ben_plan_design_program_module.get_pl_name(l_erp_rec.pl_id,p_effective_date);--'Intersection';

Line 7771: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;

7767: --
7768: --
7769: l_table_route_id := null ;
7770: open ben_plan_design_program_module.g_table_route('ERP');
7771: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
7772: close ben_plan_design_program_module.g_table_route ;
7773: --
7774: l_information5 := ben_plan_design_program_module.get_pl_name(l_erp_rec.pl_id,p_effective_date);--'Intersection';
7775: --

Line 7772: close ben_plan_design_program_module.g_table_route ;

7768: --
7769: l_table_route_id := null ;
7770: open ben_plan_design_program_module.g_table_route('ERP');
7771: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
7772: close ben_plan_design_program_module.g_table_route ;
7773: --
7774: l_information5 := ben_plan_design_program_module.get_pl_name(l_erp_rec.pl_id,p_effective_date);--'Intersection';
7775: --
7776: if p_effective_date between l_erp_rec.effective_start_date

Line 7774: l_information5 := ben_plan_design_program_module.get_pl_name(l_erp_rec.pl_id,p_effective_date);--'Intersection';

7770: open ben_plan_design_program_module.g_table_route('ERP');
7771: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
7772: close ben_plan_design_program_module.g_table_route ;
7773: --
7774: l_information5 := ben_plan_design_program_module.get_pl_name(l_erp_rec.pl_id,p_effective_date);--'Intersection';
7775: --
7776: if p_effective_date between l_erp_rec.effective_start_date
7777: and l_erp_rec.effective_end_date then
7778: --

Line 7875: open ben_plan_design_program_module.g_table_route('LRR');

7871: for l_lrr_rec in c_lrr(l_parent_rec.lee_rsn_rl_id,l_mirror_src_entity_result_id,'LRR') loop
7872: --
7873: --
7874: l_table_route_id := null ;
7875: open ben_plan_design_program_module.g_table_route('LRR');
7876: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
7877: close ben_plan_design_program_module.g_table_route ;
7878: --
7879: l_information5 := ben_plan_design_program_module.get_formula_name(l_lrr_rec.formula_id,p_effective_date);

Line 7876: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;

7872: --
7873: --
7874: l_table_route_id := null ;
7875: open ben_plan_design_program_module.g_table_route('LRR');
7876: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
7877: close ben_plan_design_program_module.g_table_route ;
7878: --
7879: l_information5 := ben_plan_design_program_module.get_formula_name(l_lrr_rec.formula_id,p_effective_date);
7880: --'Intersection';

Line 7877: close ben_plan_design_program_module.g_table_route ;

7873: --
7874: l_table_route_id := null ;
7875: open ben_plan_design_program_module.g_table_route('LRR');
7876: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
7877: close ben_plan_design_program_module.g_table_route ;
7878: --
7879: l_information5 := ben_plan_design_program_module.get_formula_name(l_lrr_rec.formula_id,p_effective_date);
7880: --'Intersection';
7881: --

Line 7879: l_information5 := ben_plan_design_program_module.get_formula_name(l_lrr_rec.formula_id,p_effective_date);

7875: open ben_plan_design_program_module.g_table_route('LRR');
7876: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
7877: close ben_plan_design_program_module.g_table_route ;
7878: --
7879: l_information5 := ben_plan_design_program_module.get_formula_name(l_lrr_rec.formula_id,p_effective_date);
7880: --'Intersection';
7881: --
7882: if p_effective_date between l_lrr_rec.effective_start_date
7883: and l_lrr_rec.effective_end_date then

Line 7954: ben_plan_design_program_module.create_formula_result(

7950: l_out_lrr_result_id := l_copy_entity_result_id ;
7951: end if;
7952:
7953: if (l_lrr_rec.formula_id is not null) then
7954: ben_plan_design_program_module.create_formula_result(
7955: p_validate => p_validate
7956: ,p_copy_entity_result_id => l_copy_entity_result_id
7957: ,p_copy_entity_txn_id => p_copy_entity_txn_id
7958: ,p_formula_id => l_lrr_rec.formula_id

Line 7997: open ben_plan_design_program_module.g_table_route('CPO');

7993: for l_cpo_rec in c_cpo(l_parent_rec.popl_org_id,l_mirror_src_entity_result_id,'CPO') loop
7994: --
7995: --
7996: l_table_route_id := null ;
7997: open ben_plan_design_program_module.g_table_route('CPO');
7998: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
7999: close ben_plan_design_program_module.g_table_route ;
8000: --
8001: l_information5 := ben_plan_design_program_module.get_organization_name(l_cpo_rec.organization_id);--'Intersection'

Line 7998: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;

7994: --
7995: --
7996: l_table_route_id := null ;
7997: open ben_plan_design_program_module.g_table_route('CPO');
7998: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
7999: close ben_plan_design_program_module.g_table_route ;
8000: --
8001: l_information5 := ben_plan_design_program_module.get_organization_name(l_cpo_rec.organization_id);--'Intersection'
8002: --

Line 7999: close ben_plan_design_program_module.g_table_route ;

7995: --
7996: l_table_route_id := null ;
7997: open ben_plan_design_program_module.g_table_route('CPO');
7998: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
7999: close ben_plan_design_program_module.g_table_route ;
8000: --
8001: l_information5 := ben_plan_design_program_module.get_organization_name(l_cpo_rec.organization_id);--'Intersection'
8002: --
8003: --

Line 8001: l_information5 := ben_plan_design_program_module.get_organization_name(l_cpo_rec.organization_id);--'Intersection'

7997: open ben_plan_design_program_module.g_table_route('CPO');
7998: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
7999: close ben_plan_design_program_module.g_table_route ;
8000: --
8001: l_information5 := ben_plan_design_program_module.get_organization_name(l_cpo_rec.organization_id);--'Intersection'
8002: --
8003: --
8004: if p_effective_date between l_cpo_rec.effective_start_date
8005: and l_cpo_rec.effective_end_date then

Line 8140: open ben_plan_design_program_module.g_table_route('CPR');

8136: for l_cpr_rec in c_cpr(l_parent_rec.popl_org_role_id,l_mirror_src_entity_result_id,'CPR') loop
8137: --
8138: --
8139: l_table_route_id := null ;
8140: open ben_plan_design_program_module.g_table_route('CPR');
8141: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
8142: close ben_plan_design_program_module.g_table_route ;
8143: --
8144: l_information5 := l_cpr_rec.name; --'Intersection';

Line 8141: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;

8137: --
8138: --
8139: l_table_route_id := null ;
8140: open ben_plan_design_program_module.g_table_route('CPR');
8141: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
8142: close ben_plan_design_program_module.g_table_route ;
8143: --
8144: l_information5 := l_cpr_rec.name; --'Intersection';
8145: --

Line 8142: close ben_plan_design_program_module.g_table_route ;

8138: --
8139: l_table_route_id := null ;
8140: open ben_plan_design_program_module.g_table_route('CPR');
8141: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
8142: close ben_plan_design_program_module.g_table_route ;
8143: --
8144: l_information5 := l_cpr_rec.name; --'Intersection';
8145: --
8146: if p_effective_date between l_cpr_rec.effective_start_date

Line 8241: open ben_plan_design_program_module.g_table_route('CPY');

8237: for l_cpy_rec in c_cpy(l_parent_rec.popl_yr_perd_id,l_mirror_src_entity_result_id,'CPY') loop
8238: --
8239: --
8240: l_table_route_id := null ;
8241: open ben_plan_design_program_module.g_table_route('CPY');
8242: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
8243: close ben_plan_design_program_module.g_table_route ;
8244: --
8245: l_information5 := ben_plan_design_program_module.get_yr_perd_name(l_cpy_rec.yr_perd_id); --'Intersection'

Line 8242: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;

8238: --
8239: --
8240: l_table_route_id := null ;
8241: open ben_plan_design_program_module.g_table_route('CPY');
8242: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
8243: close ben_plan_design_program_module.g_table_route ;
8244: --
8245: l_information5 := ben_plan_design_program_module.get_yr_perd_name(l_cpy_rec.yr_perd_id); --'Intersection'
8246: --

Line 8243: close ben_plan_design_program_module.g_table_route ;

8239: --
8240: l_table_route_id := null ;
8241: open ben_plan_design_program_module.g_table_route('CPY');
8242: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
8243: close ben_plan_design_program_module.g_table_route ;
8244: --
8245: l_information5 := ben_plan_design_program_module.get_yr_perd_name(l_cpy_rec.yr_perd_id); --'Intersection'
8246: --
8247: l_result_type_cd := 'DISPLAY';

Line 8245: l_information5 := ben_plan_design_program_module.get_yr_perd_name(l_cpy_rec.yr_perd_id); --'Intersection'

8241: open ben_plan_design_program_module.g_table_route('CPY');
8242: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
8243: close ben_plan_design_program_module.g_table_route ;
8244: --
8245: l_information5 := ben_plan_design_program_module.get_yr_perd_name(l_cpy_rec.yr_perd_id); --'Intersection'
8246: --
8247: l_result_type_cd := 'DISPLAY';
8248: --
8249: l_copy_entity_result_id := null;

Line 8361: open ben_plan_design_program_module.g_table_route('RGR');

8357: for l_rgr_rec in c_rgr(l_parent_rec.popl_rptg_grp_id,l_mirror_src_entity_result_id,'RGR') loop
8358: --
8359: --
8360: l_table_route_id := null ;
8361: open ben_plan_design_program_module.g_table_route('RGR');
8362: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
8363: close ben_plan_design_program_module.g_table_route ;
8364: --
8365: l_information5 := ben_plan_design_program_module.get_rptg_grp_name(l_rgr_rec.rptg_grp_id); --'Intersection';

Line 8362: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;

8358: --
8359: --
8360: l_table_route_id := null ;
8361: open ben_plan_design_program_module.g_table_route('RGR');
8362: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
8363: close ben_plan_design_program_module.g_table_route ;
8364: --
8365: l_information5 := ben_plan_design_program_module.get_rptg_grp_name(l_rgr_rec.rptg_grp_id); --'Intersection';
8366: --

Line 8363: close ben_plan_design_program_module.g_table_route ;

8359: --
8360: l_table_route_id := null ;
8361: open ben_plan_design_program_module.g_table_route('RGR');
8362: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
8363: close ben_plan_design_program_module.g_table_route ;
8364: --
8365: l_information5 := ben_plan_design_program_module.get_rptg_grp_name(l_rgr_rec.rptg_grp_id); --'Intersection';
8366: --
8367: if p_effective_date between l_rgr_rec.effective_start_date

Line 8365: l_information5 := ben_plan_design_program_module.get_rptg_grp_name(l_rgr_rec.rptg_grp_id); --'Intersection';

8361: open ben_plan_design_program_module.g_table_route('RGR');
8362: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
8363: close ben_plan_design_program_module.g_table_route ;
8364: --
8365: l_information5 := ben_plan_design_program_module.get_rptg_grp_name(l_rgr_rec.rptg_grp_id); --'Intersection';
8366: --
8367: if p_effective_date between l_rgr_rec.effective_start_date
8368: and l_rgr_rec.effective_end_date then
8369: --

Line 8449: if ben_plan_design_program_module.g_pdw_allow_dup_rslt = ben_plan_design_program_module.g_pdw_no_dup_rslt then

8445: l_mirror_src_entity_result_id := l_out_rgr_result_id ;
8446:
8447: l_rptg_grp_id := l_parent_rec.rptg_grp_id ;
8448:
8449: if ben_plan_design_program_module.g_pdw_allow_dup_rslt = ben_plan_design_program_module.g_pdw_no_dup_rslt then
8450: open c_object_exists(l_rptg_grp_id,'BNR');
8451: fetch c_object_exists into l_dummy;
8452: if c_object_exists%found then
8453: close c_object_exists;

Line 8464: open ben_plan_design_program_module.g_table_route('BNR');

8460: for l_bnr_rec in c_bnr(l_parent_rec.rptg_grp_id,l_mirror_src_entity_result_id,'BNR') loop
8461: --
8462: --
8463: l_table_route_id := null ;
8464: open ben_plan_design_program_module.g_table_route('BNR');
8465: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
8466: close ben_plan_design_program_module.g_table_route ;
8467: --
8468: l_information5 := l_bnr_rec.name; --'Intersection';

Line 8465: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;

8461: --
8462: --
8463: l_table_route_id := null ;
8464: open ben_plan_design_program_module.g_table_route('BNR');
8465: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
8466: close ben_plan_design_program_module.g_table_route ;
8467: --
8468: l_information5 := l_bnr_rec.name; --'Intersection';
8469: --

Line 8466: close ben_plan_design_program_module.g_table_route ;

8462: --
8463: l_table_route_id := null ;
8464: open ben_plan_design_program_module.g_table_route('BNR');
8465: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
8466: close ben_plan_design_program_module.g_table_route ;
8467: --
8468: l_information5 := l_bnr_rec.name; --'Intersection';
8469: --
8470: l_result_type_cd := 'DISPLAY';

Line 8548: if ben_plan_design_program_module.g_pdw_allow_dup_rslt = ben_plan_design_program_module.g_pdw_no_dup_rslt then

8544: l_mirror_src_entity_result_id := l_out_bnr_result_id ;
8545: --
8546: l_pl_regn_id := l_parent_rec.pl_regn_id ;
8547:
8548: if ben_plan_design_program_module.g_pdw_allow_dup_rslt = ben_plan_design_program_module.g_pdw_no_dup_rslt then
8549: open c_object_exists(l_pl_regn_id,'PRG');
8550: fetch c_object_exists into l_dummy;
8551: if c_object_exists%found then
8552: close c_object_exists;

Line 8562: open ben_plan_design_program_module.g_table_route('PRG');

8558: --
8559: for l_prg_rec in c_prg(l_parent_rec.pl_regn_id,l_mirror_src_entity_result_id,'PRG') loop
8560: --
8561: l_table_route_id := null ;
8562: open ben_plan_design_program_module.g_table_route('PRG');
8563: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
8564: close ben_plan_design_program_module.g_table_route ;
8565: --
8566: l_information5 := ben_plan_design_program_module.get_regn_name(l_prg_rec.regn_id,

Line 8563: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;

8559: for l_prg_rec in c_prg(l_parent_rec.pl_regn_id,l_mirror_src_entity_result_id,'PRG') loop
8560: --
8561: l_table_route_id := null ;
8562: open ben_plan_design_program_module.g_table_route('PRG');
8563: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
8564: close ben_plan_design_program_module.g_table_route ;
8565: --
8566: l_information5 := ben_plan_design_program_module.get_regn_name(l_prg_rec.regn_id,
8567: p_effective_date );

Line 8564: close ben_plan_design_program_module.g_table_route ;

8560: --
8561: l_table_route_id := null ;
8562: open ben_plan_design_program_module.g_table_route('PRG');
8563: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
8564: close ben_plan_design_program_module.g_table_route ;
8565: --
8566: l_information5 := ben_plan_design_program_module.get_regn_name(l_prg_rec.regn_id,
8567: p_effective_date );
8568: --

Line 8566: l_information5 := ben_plan_design_program_module.get_regn_name(l_prg_rec.regn_id,

8562: open ben_plan_design_program_module.g_table_route('PRG');
8563: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
8564: close ben_plan_design_program_module.g_table_route ;
8565: --
8566: l_information5 := ben_plan_design_program_module.get_regn_name(l_prg_rec.regn_id,
8567: p_effective_date );
8568: --
8569: if p_effective_date between l_prg_rec.effective_start_date
8570: and l_prg_rec.effective_end_date then

Line 8586: l_regn_name := ben_plan_design_program_module.get_regn_name(l_prg_rec.regn_id,l_prg_rec.effective_start_date);

8582: -- The copy process will try and map the Regulation name to the ones existing in the
8583: -- Target Business Group and if a match is found, then that Regulation Id will be used
8584: -- for creating Plan Regulation (BEN_PL_REGN) records.
8585:
8586: l_regn_name := ben_plan_design_program_module.get_regn_name(l_prg_rec.regn_id,l_prg_rec.effective_start_date);
8587: --
8588: */
8589:
8590: l_copy_entity_result_id := null;

Line 8673: if ben_plan_design_program_module.g_pdw_allow_dup_rslt = ben_plan_design_program_module.g_pdw_no_dup_rslt then

8669: l_mirror_src_entity_result_id := l_out_prg_result_id ;
8670: --
8671: l_regn_id := l_parent_rec.regn_id ;
8672:
8673: if ben_plan_design_program_module.g_pdw_allow_dup_rslt = ben_plan_design_program_module.g_pdw_no_dup_rslt then
8674: open c_object_exists(l_regn_id,'REG');
8675: fetch c_object_exists into l_dummy;
8676: if c_object_exists%found then
8677: close c_object_exists;

Line 8686: open ben_plan_design_program_module.g_table_route('REG');

8682: --
8683: for l_reg_rec in c_reg(l_parent_rec.regn_id,l_mirror_src_entity_result_id,'REG') loop
8684: --
8685: l_table_route_id := null ;
8686: open ben_plan_design_program_module.g_table_route('REG');
8687: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
8688: close ben_plan_design_program_module.g_table_route ;
8689: --
8690: l_information5 := l_reg_rec.name ;

Line 8687: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;

8683: for l_reg_rec in c_reg(l_parent_rec.regn_id,l_mirror_src_entity_result_id,'REG') loop
8684: --
8685: l_table_route_id := null ;
8686: open ben_plan_design_program_module.g_table_route('REG');
8687: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
8688: close ben_plan_design_program_module.g_table_route ;
8689: --
8690: l_information5 := l_reg_rec.name ;
8691: --

Line 8688: close ben_plan_design_program_module.g_table_route ;

8684: --
8685: l_table_route_id := null ;
8686: open ben_plan_design_program_module.g_table_route('REG');
8687: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
8688: close ben_plan_design_program_module.g_table_route ;
8689: --
8690: l_information5 := l_reg_rec.name ;
8691: --
8692: if p_effective_date between l_reg_rec.effective_start_date

Line 8786: open ben_plan_design_program_module.g_table_route('PRB');

8782: --
8783: for l_prb_rec in c_prb(l_parent_rec.pl_regy_bod_id,l_mirror_src_entity_result_id,'PRB') loop
8784: --
8785: l_table_route_id := null ;
8786: open ben_plan_design_program_module.g_table_route('PRB');
8787: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
8788: close ben_plan_design_program_module.g_table_route ;
8789: --
8790: l_information5 := l_prb_rec.regy_pl_name ;

Line 8787: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;

8783: for l_prb_rec in c_prb(l_parent_rec.pl_regy_bod_id,l_mirror_src_entity_result_id,'PRB') loop
8784: --
8785: l_table_route_id := null ;
8786: open ben_plan_design_program_module.g_table_route('PRB');
8787: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
8788: close ben_plan_design_program_module.g_table_route ;
8789: --
8790: l_information5 := l_prb_rec.regy_pl_name ;
8791: --

Line 8788: close ben_plan_design_program_module.g_table_route ;

8784: --
8785: l_table_route_id := null ;
8786: open ben_plan_design_program_module.g_table_route('PRB');
8787: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
8788: close ben_plan_design_program_module.g_table_route ;
8789: --
8790: l_information5 := l_prb_rec.regy_pl_name ;
8791: --
8792: if p_effective_date between l_prb_rec.effective_start_date

Line 8882: open ben_plan_design_program_module.g_table_route('PRP');

8878: --
8879: for l_prp_rec in c_prp(l_parent_rec.pl_regy_prps_id,l_mirror_src_entity_result_id,'PRP') loop
8880: --
8881: l_table_route_id := null ;
8882: open ben_plan_design_program_module.g_table_route('PRP');
8883: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
8884: close ben_plan_design_program_module.g_table_route ;
8885: --
8886: l_information5 := hr_general.decode_lookup('BEN_REGY_PRPS',l_prp_rec.pl_regy_prps_cd);

Line 8883: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;

8879: for l_prp_rec in c_prp(l_parent_rec.pl_regy_prps_id,l_mirror_src_entity_result_id,'PRP') loop
8880: --
8881: l_table_route_id := null ;
8882: open ben_plan_design_program_module.g_table_route('PRP');
8883: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
8884: close ben_plan_design_program_module.g_table_route ;
8885: --
8886: l_information5 := hr_general.decode_lookup('BEN_REGY_PRPS',l_prp_rec.pl_regy_prps_cd);
8887: --

Line 8884: close ben_plan_design_program_module.g_table_route ;

8880: --
8881: l_table_route_id := null ;
8882: open ben_plan_design_program_module.g_table_route('PRP');
8883: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
8884: close ben_plan_design_program_module.g_table_route ;
8885: --
8886: l_information5 := hr_general.decode_lookup('BEN_REGY_PRPS',l_prp_rec.pl_regy_prps_cd);
8887: --
8888: if p_effective_date between l_prp_rec.effective_start_date

Line 9291: if p_no_dup_rslt = ben_plan_design_program_module.g_pdw_no_dup_rslt then

9287: l_rltd_per_chg_cs_ler_id number(15);
9288: l_out_src_result_id number(15);
9289: begin
9290:
9291: if p_no_dup_rslt = ben_plan_design_program_module.g_pdw_no_dup_rslt then
9292: ben_plan_design_program_module.g_pdw_allow_dup_rslt := ben_plan_design_program_module.g_pdw_no_dup_rslt;
9293: end if;
9294:
9295: if ben_plan_design_program_module.g_pdw_allow_dup_rslt = ben_plan_design_program_module.g_pdw_no_dup_rslt then

Line 9292: ben_plan_design_program_module.g_pdw_allow_dup_rslt := ben_plan_design_program_module.g_pdw_no_dup_rslt;

9288: l_out_src_result_id number(15);
9289: begin
9290:
9291: if p_no_dup_rslt = ben_plan_design_program_module.g_pdw_no_dup_rslt then
9292: ben_plan_design_program_module.g_pdw_allow_dup_rslt := ben_plan_design_program_module.g_pdw_no_dup_rslt;
9293: end if;
9294:
9295: if ben_plan_design_program_module.g_pdw_allow_dup_rslt = ben_plan_design_program_module.g_pdw_no_dup_rslt then
9296: open c_object_exists(p_ler_id,'LER');

Line 9295: if ben_plan_design_program_module.g_pdw_allow_dup_rslt = ben_plan_design_program_module.g_pdw_no_dup_rslt then

9291: if p_no_dup_rslt = ben_plan_design_program_module.g_pdw_no_dup_rslt then
9292: ben_plan_design_program_module.g_pdw_allow_dup_rslt := ben_plan_design_program_module.g_pdw_no_dup_rslt;
9293: end if;
9294:
9295: if ben_plan_design_program_module.g_pdw_allow_dup_rslt = ben_plan_design_program_module.g_pdw_no_dup_rslt then
9296: open c_object_exists(p_ler_id,'LER');
9297: fetch c_object_exists into l_dummy;
9298: if c_object_exists%found then
9299: close c_object_exists;

Line 9319: open ben_plan_design_program_module.g_table_route('LER');

9315: for l_ler_rec in c_ler(p_ler_id,l_mirror_src_entity_result_id,'LER') loop
9316: --
9317: --
9318: l_table_route_id := null ;
9319: open ben_plan_design_program_module.g_table_route('LER');
9320: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
9321: close ben_plan_design_program_module.g_table_route ;
9322: --
9323: l_information5 := l_ler_rec.name; --'Intersection';

Line 9320: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;

9316: --
9317: --
9318: l_table_route_id := null ;
9319: open ben_plan_design_program_module.g_table_route('LER');
9320: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
9321: close ben_plan_design_program_module.g_table_route ;
9322: --
9323: l_information5 := l_ler_rec.name; --'Intersection';
9324: --

Line 9321: close ben_plan_design_program_module.g_table_route ;

9317: --
9318: l_table_route_id := null ;
9319: open ben_plan_design_program_module.g_table_route('LER');
9320: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
9321: close ben_plan_design_program_module.g_table_route ;
9322: --
9323: l_information5 := l_ler_rec.name; --'Intersection';
9324: --
9325: l_ler_id := l_ler_rec.ler_id ;

Line 9418: ben_plan_design_program_module.create_formula_result(

9414: -- ------------------------------------------------------------------------
9415: end if;
9416: --
9417: if (l_ler_rec.ler_eval_rl is not null) then
9418: ben_plan_design_program_module.create_formula_result(
9419: p_validate => p_validate
9420: ,p_copy_entity_result_id => l_copy_entity_result_id
9421: ,p_copy_entity_txn_id => p_copy_entity_txn_id
9422: ,p_formula_id => l_ler_rec.ler_eval_rl

Line 9430: ben_plan_design_program_module.create_formula_result(

9426: ,p_effective_date => p_effective_date);
9427: end if;
9428:
9429: if (l_ler_rec.tmlns_perd_rl is not null) then
9430: ben_plan_design_program_module.create_formula_result(
9431: p_validate => p_validate
9432: ,p_copy_entity_result_id => l_copy_entity_result_id
9433: ,p_copy_entity_txn_id => p_copy_entity_txn_id
9434: ,p_formula_id => l_ler_rec.tmlns_perd_rl

Line 9461: open ben_plan_design_program_module.g_table_route('CSR');

9457: for l_csr_rec in c_csr(l_parent_rec.css_rltd_per_per_in_ler_id,l_mirror_src_entity_result_id,'CSR') loop
9458: --
9459: --
9460: l_table_route_id := null ;
9461: open ben_plan_design_program_module.g_table_route('CSR');
9462: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
9463: close ben_plan_design_program_module.g_table_route ;
9464: --
9465: l_information5 := ben_plan_design_program_module.get_ler_name(l_csr_rec.rsltg_ler_id,p_effective_date); --'Intersection';

Line 9462: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;

9458: --
9459: --
9460: l_table_route_id := null ;
9461: open ben_plan_design_program_module.g_table_route('CSR');
9462: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
9463: close ben_plan_design_program_module.g_table_route ;
9464: --
9465: l_information5 := ben_plan_design_program_module.get_ler_name(l_csr_rec.rsltg_ler_id,p_effective_date); --'Intersection';
9466: --

Line 9463: close ben_plan_design_program_module.g_table_route ;

9459: --
9460: l_table_route_id := null ;
9461: open ben_plan_design_program_module.g_table_route('CSR');
9462: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
9463: close ben_plan_design_program_module.g_table_route ;
9464: --
9465: l_information5 := ben_plan_design_program_module.get_ler_name(l_csr_rec.rsltg_ler_id,p_effective_date); --'Intersection';
9466: --
9467: l_css_rltd_per_per_in_ler_id := l_csr_rec.css_rltd_per_per_in_ler_id ;

Line 9465: l_information5 := ben_plan_design_program_module.get_ler_name(l_csr_rec.rsltg_ler_id,p_effective_date); --'Intersection';

9461: open ben_plan_design_program_module.g_table_route('CSR');
9462: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
9463: close ben_plan_design_program_module.g_table_route ;
9464: --
9465: l_information5 := ben_plan_design_program_module.get_ler_name(l_csr_rec.rsltg_ler_id,p_effective_date); --'Intersection';
9466: --
9467: l_css_rltd_per_per_in_ler_id := l_csr_rec.css_rltd_per_per_in_ler_id ;
9468: if p_effective_date between l_csr_rec.effective_start_date
9469: and l_csr_rec.effective_end_date then

Line 9559: open ben_plan_design_program_module.g_table_route('LPL');

9555: for l_lpl_rec in c_lpl(l_parent_rec.ler_per_info_cs_ler_id,l_mirror_src_entity_result_id,'LPL') loop
9556: --
9557: --
9558: l_table_route_id := null ;
9559: open ben_plan_design_program_module.g_table_route('LPL');
9560: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
9561: close ben_plan_design_program_module.g_table_route ;
9562: --
9563: l_information5 := ben_plan_design_program_module.get_per_info_chg_cs_ler_name(l_lpl_rec.per_info_chg_cs_ler_id,

Line 9560: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;

9556: --
9557: --
9558: l_table_route_id := null ;
9559: open ben_plan_design_program_module.g_table_route('LPL');
9560: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
9561: close ben_plan_design_program_module.g_table_route ;
9562: --
9563: l_information5 := ben_plan_design_program_module.get_per_info_chg_cs_ler_name(l_lpl_rec.per_info_chg_cs_ler_id,
9564: p_effective_date); --'Intersection';

Line 9561: close ben_plan_design_program_module.g_table_route ;

9557: --
9558: l_table_route_id := null ;
9559: open ben_plan_design_program_module.g_table_route('LPL');
9560: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
9561: close ben_plan_design_program_module.g_table_route ;
9562: --
9563: l_information5 := ben_plan_design_program_module.get_per_info_chg_cs_ler_name(l_lpl_rec.per_info_chg_cs_ler_id,
9564: p_effective_date); --'Intersection';
9565: --

Line 9563: l_information5 := ben_plan_design_program_module.get_per_info_chg_cs_ler_name(l_lpl_rec.per_info_chg_cs_ler_id,

9559: open ben_plan_design_program_module.g_table_route('LPL');
9560: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
9561: close ben_plan_design_program_module.g_table_route ;
9562: --
9563: l_information5 := ben_plan_design_program_module.get_per_info_chg_cs_ler_name(l_lpl_rec.per_info_chg_cs_ler_id,
9564: p_effective_date); --'Intersection';
9565: --
9566: if p_effective_date between l_lpl_rec.effective_start_date
9567: and l_lpl_rec.effective_end_date then

Line 9638: ben_plan_design_program_module.create_formula_result(

9634: l_out_lpl_result_id := l_copy_entity_result_id ;
9635: end if;
9636:
9637: if (l_lpl_rec.ler_per_info_cs_ler_rl is not null) then
9638: ben_plan_design_program_module.create_formula_result(
9639: p_validate => p_validate
9640: ,p_copy_entity_result_id => l_copy_entity_result_id
9641: ,p_copy_entity_txn_id => p_copy_entity_txn_id
9642: ,p_formula_id => l_lpl_rec.ler_per_info_cs_ler_rl

Line 9666: open ben_plan_design_program_module.g_table_route('PSL');

9662: for l_psl_rec in c_psl(l_parent_rec.per_info_chg_cs_ler_id,l_mirror_src_entity_result_id,'PSL') loop
9663: --
9664: --
9665: l_table_route_id := null ;
9666: open ben_plan_design_program_module.g_table_route('PSL');
9667: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
9668: close ben_plan_design_program_module.g_table_route ;
9669: --
9670: l_information5 := SUBSTR(l_psl_rec.name,1,255); --'Intersection';

Line 9667: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;

9663: --
9664: --
9665: l_table_route_id := null ;
9666: open ben_plan_design_program_module.g_table_route('PSL');
9667: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
9668: close ben_plan_design_program_module.g_table_route ;
9669: --
9670: l_information5 := SUBSTR(l_psl_rec.name,1,255); --'Intersection';
9671: --

Line 9668: close ben_plan_design_program_module.g_table_route ;

9664: --
9665: l_table_route_id := null ;
9666: open ben_plan_design_program_module.g_table_route('PSL');
9667: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
9668: close ben_plan_design_program_module.g_table_route ;
9669: --
9670: l_information5 := SUBSTR(l_psl_rec.name,1,255); --'Intersection';
9671: --
9672:

Line 9795: ben_plan_design_program_module.create_formula_result(

9791: l_out_psl_result_id := l_copy_entity_result_id ;
9792: end if;
9793:
9794: if (l_psl_rec.per_info_chg_cs_ler_rl is not null) then
9795: ben_plan_design_program_module.create_formula_result(
9796: p_validate => p_validate
9797: ,p_copy_entity_result_id => l_copy_entity_result_id
9798: ,p_copy_entity_txn_id => p_copy_entity_txn_id
9799: ,p_formula_id => l_psl_rec.per_info_chg_cs_ler_rl

Line 9831: open ben_plan_design_program_module.g_table_route('LRC');

9827: for l_lrc_rec in c_lrc(l_parent_rec.ler_rltd_per_cs_ler_id,l_mirror_src_entity_result_id,'LRC') loop
9828: --
9829: --
9830: l_table_route_id := null ;
9831: open ben_plan_design_program_module.g_table_route('LRC');
9832: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
9833: close ben_plan_design_program_module.g_table_route ;
9834: --
9835: l_information5 := SUBSTR(

Line 9832: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;

9828: --
9829: --
9830: l_table_route_id := null ;
9831: open ben_plan_design_program_module.g_table_route('LRC');
9832: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
9833: close ben_plan_design_program_module.g_table_route ;
9834: --
9835: l_information5 := SUBSTR(
9836: ben_plan_design_program_module.get_rltd_per_chg_cs_ler_name(

Line 9833: close ben_plan_design_program_module.g_table_route ;

9829: --
9830: l_table_route_id := null ;
9831: open ben_plan_design_program_module.g_table_route('LRC');
9832: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
9833: close ben_plan_design_program_module.g_table_route ;
9834: --
9835: l_information5 := SUBSTR(
9836: ben_plan_design_program_module.get_rltd_per_chg_cs_ler_name(
9837: l_lrc_rec.rltd_per_chg_cs_ler_id,

Line 9836: ben_plan_design_program_module.get_rltd_per_chg_cs_ler_name(

9832: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
9833: close ben_plan_design_program_module.g_table_route ;
9834: --
9835: l_information5 := SUBSTR(
9836: ben_plan_design_program_module.get_rltd_per_chg_cs_ler_name(
9837: l_lrc_rec.rltd_per_chg_cs_ler_id,
9838: p_effective_date),1,255); --'Intersection';
9839: --
9840: l_ler_rltd_per_cs_ler_id := l_lrc_rec.ler_rltd_per_cs_ler_id ;

Line 9912: ben_plan_design_program_module.create_formula_result(

9908: l_out_lrc_result_id := l_copy_entity_result_id ;
9909: end if;
9910:
9911: if (l_lrc_rec.ler_rltd_per_cs_chg_rl is not null) then
9912: ben_plan_design_program_module.create_formula_result(
9913: p_validate => p_validate
9914: ,p_copy_entity_result_id => l_copy_entity_result_id
9915: ,p_copy_entity_txn_id => p_copy_entity_txn_id
9916: ,p_formula_id => l_lrc_rec.ler_rltd_per_cs_chg_rl

Line 9941: open ben_plan_design_program_module.g_table_route('RCL');

9937: for l_rcl_rec in c_rcl(l_parent_rec.rltd_per_chg_cs_ler_id,l_mirror_src_entity_result_id,'RCL') loop
9938: --
9939: --
9940: l_table_route_id := null ;
9941: open ben_plan_design_program_module.g_table_route('RCL');
9942: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
9943: close ben_plan_design_program_module.g_table_route ;
9944: --
9945: l_information5 := SUBSTR(l_rcl_rec.name,1,255); --'Intersection';

Line 9942: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;

9938: --
9939: --
9940: l_table_route_id := null ;
9941: open ben_plan_design_program_module.g_table_route('RCL');
9942: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
9943: close ben_plan_design_program_module.g_table_route ;
9944: --
9945: l_information5 := SUBSTR(l_rcl_rec.name,1,255); --'Intersection';
9946: --

Line 9943: close ben_plan_design_program_module.g_table_route ;

9939: --
9940: l_table_route_id := null ;
9941: open ben_plan_design_program_module.g_table_route('RCL');
9942: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
9943: close ben_plan_design_program_module.g_table_route ;
9944: --
9945: l_information5 := SUBSTR(l_rcl_rec.name,1,255); --'Intersection';
9946: --
9947:

Line 10028: ben_plan_design_program_module.create_formula_result(

10024: l_out_rcl_result_id := l_copy_entity_result_id ;
10025: end if;
10026:
10027: if (l_rcl_rec.rltd_per_chg_cs_ler_rl is not null) then
10028: ben_plan_design_program_module.create_formula_result(
10029: p_validate => p_validate
10030: ,p_copy_entity_result_id => l_copy_entity_result_id
10031: ,p_copy_entity_txn_id => p_copy_entity_txn_id
10032: ,p_formula_id => l_rcl_rec.rltd_per_chg_cs_ler_rl

Line 10408: open ben_plan_design_program_module.g_table_route('COP');

10404: --
10405: for l_cop_rec in c_cop1(l_oipl_id,l_mirror_src_entity_result_id,'COP') loop
10406: --
10407: l_table_route_id := null ;
10408: open ben_plan_design_program_module.g_table_route('COP');
10409: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
10410: close ben_plan_design_program_module.g_table_route ;
10411: --
10412: l_information5 := ben_plan_design_program_module.get_opt_name(l_cop_rec.opt_id,p_effective_date); --'Intersection';

Line 10409: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;

10405: for l_cop_rec in c_cop1(l_oipl_id,l_mirror_src_entity_result_id,'COP') loop
10406: --
10407: l_table_route_id := null ;
10408: open ben_plan_design_program_module.g_table_route('COP');
10409: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
10410: close ben_plan_design_program_module.g_table_route ;
10411: --
10412: l_information5 := ben_plan_design_program_module.get_opt_name(l_cop_rec.opt_id,p_effective_date); --'Intersection';
10413: --

Line 10410: close ben_plan_design_program_module.g_table_route ;

10406: --
10407: l_table_route_id := null ;
10408: open ben_plan_design_program_module.g_table_route('COP');
10409: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
10410: close ben_plan_design_program_module.g_table_route ;
10411: --
10412: l_information5 := ben_plan_design_program_module.get_opt_name(l_cop_rec.opt_id,p_effective_date); --'Intersection';
10413: --
10414: if p_effective_date between l_cop_rec.effective_start_date

Line 10412: l_information5 := ben_plan_design_program_module.get_opt_name(l_cop_rec.opt_id,p_effective_date); --'Intersection';

10408: open ben_plan_design_program_module.g_table_route('COP');
10409: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
10410: close ben_plan_design_program_module.g_table_route ;
10411: --
10412: l_information5 := ben_plan_design_program_module.get_opt_name(l_cop_rec.opt_id,p_effective_date); --'Intersection';
10413: --
10414: if p_effective_date between l_cop_rec.effective_start_date
10415: and l_cop_rec.effective_end_date then
10416: --

Line 10518: ben_plan_design_program_module.create_formula_result(

10514: l_out_cop_result_id := l_copy_entity_result_id ;
10515: end if;
10516: --
10517: if (l_cop_rec.auto_enrt_mthd_rl is not null) then
10518: ben_plan_design_program_module.create_formula_result(
10519: p_validate => p_validate
10520: ,p_copy_entity_result_id => l_copy_entity_result_id
10521: ,p_copy_entity_txn_id => p_copy_entity_txn_id
10522: ,p_formula_id => l_cop_rec.auto_enrt_mthd_rl

Line 10530: ben_plan_design_program_module.create_formula_result(

10526: ,p_effective_date => p_effective_date);
10527: end if;
10528:
10529: if (l_cop_rec.dflt_enrt_det_rl is not null) then
10530: ben_plan_design_program_module.create_formula_result(
10531: p_validate => p_validate
10532: ,p_copy_entity_result_id => l_copy_entity_result_id
10533: ,p_copy_entity_txn_id => p_copy_entity_txn_id
10534: ,p_formula_id => l_cop_rec.dflt_enrt_det_rl

Line 10542: ben_plan_design_program_module.create_formula_result(

10538: ,p_effective_date => p_effective_date);
10539: end if;
10540:
10541: if (l_cop_rec.enrt_rl is not null) then
10542: ben_plan_design_program_module.create_formula_result(
10543: p_validate => p_validate
10544: ,p_copy_entity_result_id => l_copy_entity_result_id
10545: ,p_copy_entity_txn_id => p_copy_entity_txn_id
10546: ,p_formula_id => l_cop_rec.enrt_rl

Line 10554: ben_plan_design_program_module.create_formula_result(

10550: ,p_effective_date => p_effective_date);
10551: end if;
10552:
10553: if (l_cop_rec.mndtry_rl is not null) then
10554: ben_plan_design_program_module.create_formula_result(
10555: p_validate => p_validate
10556: ,p_copy_entity_result_id => l_copy_entity_result_id
10557: ,p_copy_entity_txn_id => p_copy_entity_txn_id
10558: ,p_formula_id => l_cop_rec.mndtry_rl

Line 10566: ben_plan_design_program_module.create_formula_result(

10562: ,p_effective_date => p_effective_date);
10563: end if;
10564:
10565: if (l_cop_rec.postelcn_edit_rl is not null) then
10566: ben_plan_design_program_module.create_formula_result(
10567: p_validate => p_validate
10568: ,p_copy_entity_result_id => l_copy_entity_result_id
10569: ,p_copy_entity_txn_id => p_copy_entity_txn_id
10570: ,p_formula_id => l_cop_rec.postelcn_edit_rl

Line 10578: ben_plan_design_program_module.create_formula_result(

10574: ,p_effective_date => p_effective_date);
10575: end if;
10576:
10577: if (l_cop_rec.rqd_perd_enrt_nenrt_rl is not null) then
10578: ben_plan_design_program_module.create_formula_result(
10579: p_validate => p_validate
10580: ,p_copy_entity_result_id => l_copy_entity_result_id
10581: ,p_copy_entity_txn_id => p_copy_entity_txn_id
10582: ,p_formula_id => l_cop_rec.rqd_perd_enrt_nenrt_rl

Line 10590: ben_plan_design_program_module.create_formula_result(

10586: ,p_effective_date => p_effective_date);
10587: end if;
10588:
10589: if (l_cop_rec.vrfy_fmly_mmbr_rl is not null) then
10590: ben_plan_design_program_module.create_formula_result(
10591: p_validate => p_validate
10592: ,p_copy_entity_result_id => l_copy_entity_result_id
10593: ,p_copy_entity_txn_id => p_copy_entity_txn_id
10594: ,p_formula_id => l_cop_rec.vrfy_fmly_mmbr_rl

Line 10707: open ben_plan_design_program_module.g_table_route('DDR');

10703: --
10704: for l_ddr_rec in c_ddr1(l_parent_rec.dsgn_rqmt_id,l_mirror_src_entity_result_id,'DDR') loop
10705: --
10706: l_table_route_id := null ;
10707: open ben_plan_design_program_module.g_table_route('DDR');
10708: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
10709: close ben_plan_design_program_module.g_table_route ;
10710: --
10711: l_information5 := hr_general.decode_lookup('BEN_GRP_RLSHP',l_ddr_rec.grp_rlshp_cd); --'Intersection';

Line 10708: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;

10704: for l_ddr_rec in c_ddr1(l_parent_rec.dsgn_rqmt_id,l_mirror_src_entity_result_id,'DDR') loop
10705: --
10706: l_table_route_id := null ;
10707: open ben_plan_design_program_module.g_table_route('DDR');
10708: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
10709: close ben_plan_design_program_module.g_table_route ;
10710: --
10711: l_information5 := hr_general.decode_lookup('BEN_GRP_RLSHP',l_ddr_rec.grp_rlshp_cd); --'Intersection';
10712: --

Line 10709: close ben_plan_design_program_module.g_table_route ;

10705: --
10706: l_table_route_id := null ;
10707: open ben_plan_design_program_module.g_table_route('DDR');
10708: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
10709: close ben_plan_design_program_module.g_table_route ;
10710: --
10711: l_information5 := hr_general.decode_lookup('BEN_GRP_RLSHP',l_ddr_rec.grp_rlshp_cd); --'Intersection';
10712: --
10713: if p_effective_date between l_ddr_rec.effective_start_date

Line 10814: open ben_plan_design_program_module.g_table_route('DRR');

10810: --
10811: for l_drr_rec in c_drr1(l_parent_rec.dsgn_rqmt_rlshp_typ_id,l_mirror_src_entity_result_id,'DRR') loop
10812: --
10813: l_table_route_id := null ;
10814: open ben_plan_design_program_module.g_table_route('DRR');
10815: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
10816: close ben_plan_design_program_module.g_table_route ;
10817: --
10818: l_information5 := hr_general.decode_lookup('CONTACT',l_drr_rec.rlshp_typ_cd); --'Intersection';

Line 10815: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;

10811: for l_drr_rec in c_drr1(l_parent_rec.dsgn_rqmt_rlshp_typ_id,l_mirror_src_entity_result_id,'DRR') loop
10812: --
10813: l_table_route_id := null ;
10814: open ben_plan_design_program_module.g_table_route('DRR');
10815: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
10816: close ben_plan_design_program_module.g_table_route ;
10817: --
10818: l_information5 := hr_general.decode_lookup('CONTACT',l_drr_rec.rlshp_typ_cd); --'Intersection';
10819: --

Line 10816: close ben_plan_design_program_module.g_table_route ;

10812: --
10813: l_table_route_id := null ;
10814: open ben_plan_design_program_module.g_table_route('DRR');
10815: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
10816: close ben_plan_design_program_module.g_table_route ;
10817: --
10818: l_information5 := hr_general.decode_lookup('CONTACT',l_drr_rec.rlshp_typ_cd); --'Intersection';
10819: --
10820: l_result_type_cd := 'DISPLAY';

Line 10909: open ben_plan_design_program_module.g_table_route('PEO');

10905: --
10906: for l_peo_rec in c_peo1(l_parent_rec.elig_to_prte_rsn_id,l_mirror_src_entity_result_id,'PEO') loop
10907: --
10908: l_table_route_id := null ;
10909: open ben_plan_design_program_module.g_table_route('PEO');
10910: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
10911: close ben_plan_design_program_module.g_table_route ;
10912: --
10913: l_information5 := ben_plan_design_program_module.get_ler_name(l_peo_rec.ler_id,p_effective_date); --'Intersection';

Line 10910: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;

10906: for l_peo_rec in c_peo1(l_parent_rec.elig_to_prte_rsn_id,l_mirror_src_entity_result_id,'PEO') loop
10907: --
10908: l_table_route_id := null ;
10909: open ben_plan_design_program_module.g_table_route('PEO');
10910: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
10911: close ben_plan_design_program_module.g_table_route ;
10912: --
10913: l_information5 := ben_plan_design_program_module.get_ler_name(l_peo_rec.ler_id,p_effective_date); --'Intersection';
10914: --

Line 10911: close ben_plan_design_program_module.g_table_route ;

10907: --
10908: l_table_route_id := null ;
10909: open ben_plan_design_program_module.g_table_route('PEO');
10910: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
10911: close ben_plan_design_program_module.g_table_route ;
10912: --
10913: l_information5 := ben_plan_design_program_module.get_ler_name(l_peo_rec.ler_id,p_effective_date); --'Intersection';
10914: --
10915: if p_effective_date between l_peo_rec.effective_start_date

Line 10913: l_information5 := ben_plan_design_program_module.get_ler_name(l_peo_rec.ler_id,p_effective_date); --'Intersection';

10909: open ben_plan_design_program_module.g_table_route('PEO');
10910: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
10911: close ben_plan_design_program_module.g_table_route ;
10912: --
10913: l_information5 := ben_plan_design_program_module.get_ler_name(l_peo_rec.ler_id,p_effective_date); --'Intersection';
10914: --
10915: if p_effective_date between l_peo_rec.effective_start_date
10916: and l_peo_rec.effective_end_date then
10917: --

Line 11039: open ben_plan_design_program_module.g_table_route('LOP');

11035: --
11036: for l_lop_rec in c_lop(l_parent_rec.ler_chg_oipl_enrt_id,l_mirror_src_entity_result_id,'LOP') loop
11037: --
11038: l_table_route_id := null ;
11039: open ben_plan_design_program_module.g_table_route('LOP');
11040: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
11041: close ben_plan_design_program_module.g_table_route ;
11042: --
11043: l_information5 := ben_plan_design_program_module.get_ler_name(l_lop_rec.ler_id,p_effective_date); --'Intersection';

Line 11040: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;

11036: for l_lop_rec in c_lop(l_parent_rec.ler_chg_oipl_enrt_id,l_mirror_src_entity_result_id,'LOP') loop
11037: --
11038: l_table_route_id := null ;
11039: open ben_plan_design_program_module.g_table_route('LOP');
11040: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
11041: close ben_plan_design_program_module.g_table_route ;
11042: --
11043: l_information5 := ben_plan_design_program_module.get_ler_name(l_lop_rec.ler_id,p_effective_date); --'Intersection';
11044: --

Line 11041: close ben_plan_design_program_module.g_table_route ;

11037: --
11038: l_table_route_id := null ;
11039: open ben_plan_design_program_module.g_table_route('LOP');
11040: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
11041: close ben_plan_design_program_module.g_table_route ;
11042: --
11043: l_information5 := ben_plan_design_program_module.get_ler_name(l_lop_rec.ler_id,p_effective_date); --'Intersection';
11044: --
11045: if p_effective_date between l_lop_rec.effective_start_date

Line 11043: l_information5 := ben_plan_design_program_module.get_ler_name(l_lop_rec.ler_id,p_effective_date); --'Intersection';

11039: open ben_plan_design_program_module.g_table_route('LOP');
11040: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
11041: close ben_plan_design_program_module.g_table_route ;
11042: --
11043: l_information5 := ben_plan_design_program_module.get_ler_name(l_lop_rec.ler_id,p_effective_date); --'Intersection';
11044: --
11045: if p_effective_date between l_lop_rec.effective_start_date
11046: and l_lop_rec.effective_end_date then
11047: --

Line 11131: ben_plan_design_program_module.create_formula_result

11127: ---------------------------------------------------------------
11128:
11129: if to_char(l_lop_rec.auto_enrt_mthd_rl) is not null then
11130: --
11131: ben_plan_design_program_module.create_formula_result
11132: (
11133: p_validate => 0
11134: ,p_copy_entity_result_id => l_copy_entity_result_id
11135: ,p_copy_entity_txn_id => p_copy_entity_txn_id

Line 11151: ben_plan_design_program_module.create_formula_result

11147: ---------------------------------------------------------------
11148:
11149: if to_char(l_lop_rec.dflt_enrt_rl) is not null then
11150: --
11151: ben_plan_design_program_module.create_formula_result
11152: (
11153: p_validate => 0
11154: ,p_copy_entity_result_id => l_copy_entity_result_id
11155: ,p_copy_entity_txn_id => p_copy_entity_txn_id

Line 11171: ben_plan_design_program_module.create_formula_result

11167: ---------------------------------------------------------------
11168:
11169: if to_char(l_lop_rec.enrt_rl) is not null then
11170: --
11171: ben_plan_design_program_module.create_formula_result
11172: (
11173: p_validate => 0
11174: ,p_copy_entity_result_id => l_copy_entity_result_id
11175: ,p_copy_entity_txn_id => p_copy_entity_txn_id

Line 11217: open ben_plan_design_program_module.g_table_route('ECF');

11213: --
11214: for l_ecf_rec in c_ecf1(l_parent_rec.enrt_ctfn_id,l_mirror_src_entity_result_id,'ECF') loop
11215: --
11216: l_table_route_id := null ;
11217: open ben_plan_design_program_module.g_table_route('ECF');
11218: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
11219: close ben_plan_design_program_module.g_table_route ;
11220: --
11221: l_information5 := hr_general.decode_lookup('BEN_ENRT_CTFN_TYP',l_ecf_rec.enrt_ctfn_typ_cd); --'Intersection'

Line 11218: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;

11214: for l_ecf_rec in c_ecf1(l_parent_rec.enrt_ctfn_id,l_mirror_src_entity_result_id,'ECF') loop
11215: --
11216: l_table_route_id := null ;
11217: open ben_plan_design_program_module.g_table_route('ECF');
11218: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
11219: close ben_plan_design_program_module.g_table_route ;
11220: --
11221: l_information5 := hr_general.decode_lookup('BEN_ENRT_CTFN_TYP',l_ecf_rec.enrt_ctfn_typ_cd); --'Intersection'
11222: --

Line 11219: close ben_plan_design_program_module.g_table_route ;

11215: --
11216: l_table_route_id := null ;
11217: open ben_plan_design_program_module.g_table_route('ECF');
11218: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
11219: close ben_plan_design_program_module.g_table_route ;
11220: --
11221: l_information5 := hr_general.decode_lookup('BEN_ENRT_CTFN_TYP',l_ecf_rec.enrt_ctfn_typ_cd); --'Intersection'
11222: --
11223: if p_effective_date between l_ecf_rec.effective_start_date

Line 11317: open ben_plan_design_program_module.g_table_route('LRE');

11313: --
11314: for l_lre_rec in c_lre1(l_parent_rec.ler_rqrs_enrt_ctfn_id,l_mirror_src_entity_result_id,'LRE') loop
11315: --
11316: l_table_route_id := null ;
11317: open ben_plan_design_program_module.g_table_route('LRE');
11318: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
11319: close ben_plan_design_program_module.g_table_route ;
11320: --
11321: l_information5 := ben_plan_design_program_module.get_ler_name(l_lre_rec.ler_id,p_effective_date); --'Intersection';

Line 11318: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;

11314: for l_lre_rec in c_lre1(l_parent_rec.ler_rqrs_enrt_ctfn_id,l_mirror_src_entity_result_id,'LRE') loop
11315: --
11316: l_table_route_id := null ;
11317: open ben_plan_design_program_module.g_table_route('LRE');
11318: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
11319: close ben_plan_design_program_module.g_table_route ;
11320: --
11321: l_information5 := ben_plan_design_program_module.get_ler_name(l_lre_rec.ler_id,p_effective_date); --'Intersection';
11322: --

Line 11319: close ben_plan_design_program_module.g_table_route ;

11315: --
11316: l_table_route_id := null ;
11317: open ben_plan_design_program_module.g_table_route('LRE');
11318: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
11319: close ben_plan_design_program_module.g_table_route ;
11320: --
11321: l_information5 := ben_plan_design_program_module.get_ler_name(l_lre_rec.ler_id,p_effective_date); --'Intersection';
11322: --
11323: if p_effective_date between l_lre_rec.effective_start_date

Line 11321: l_information5 := ben_plan_design_program_module.get_ler_name(l_lre_rec.ler_id,p_effective_date); --'Intersection';

11317: open ben_plan_design_program_module.g_table_route('LRE');
11318: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
11319: close ben_plan_design_program_module.g_table_route ;
11320: --
11321: l_information5 := ben_plan_design_program_module.get_ler_name(l_lre_rec.ler_id,p_effective_date); --'Intersection';
11322: --
11323: if p_effective_date between l_lre_rec.effective_start_date
11324: and l_lre_rec.effective_end_date then
11325: --

Line 11428: open ben_plan_design_program_module.g_table_route('LNC');

11424: --
11425: for l_lnc_rec in c_lnc1(l_parent_rec.ler_enrt_ctfn_id,l_mirror_src_entity_result_id,'LNC') loop
11426: --
11427: l_table_route_id := null ;
11428: open ben_plan_design_program_module.g_table_route('LNC');
11429: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
11430: close ben_plan_design_program_module.g_table_route ;
11431: --
11432: l_information5 := hr_general.decode_lookup('BEN_ENRT_CTFN_TYP',l_lnc_rec.enrt_ctfn_typ_cd); --'Intersection'

Line 11429: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;

11425: for l_lnc_rec in c_lnc1(l_parent_rec.ler_enrt_ctfn_id,l_mirror_src_entity_result_id,'LNC') loop
11426: --
11427: l_table_route_id := null ;
11428: open ben_plan_design_program_module.g_table_route('LNC');
11429: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
11430: close ben_plan_design_program_module.g_table_route ;
11431: --
11432: l_information5 := hr_general.decode_lookup('BEN_ENRT_CTFN_TYP',l_lnc_rec.enrt_ctfn_typ_cd); --'Intersection'
11433: --

Line 11430: close ben_plan_design_program_module.g_table_route ;

11426: --
11427: l_table_route_id := null ;
11428: open ben_plan_design_program_module.g_table_route('LNC');
11429: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
11430: close ben_plan_design_program_module.g_table_route ;
11431: --
11432: l_information5 := hr_general.decode_lookup('BEN_ENRT_CTFN_TYP',l_lnc_rec.enrt_ctfn_typ_cd); --'Intersection'
11433: --
11434: if p_effective_date between l_lnc_rec.effective_start_date

Line 11771: if p_no_dup_rslt = ben_plan_design_program_module.g_pdw_no_dup_rslt then

11767: ---------------------------------------------------------------
11768: -- START OF BEN_OPT_F ----------------------
11769: ---------------------------------------------------------------
11770:
11771: if p_no_dup_rslt = ben_plan_design_program_module.g_pdw_no_dup_rslt then
11772: ben_plan_design_program_module.g_pdw_allow_dup_rslt := ben_plan_design_program_module.g_pdw_no_dup_rslt;
11773: end if;
11774:
11775: if p_no_dup_rslt = 'Y' OR

Line 11772: ben_plan_design_program_module.g_pdw_allow_dup_rslt := ben_plan_design_program_module.g_pdw_no_dup_rslt;

11768: -- START OF BEN_OPT_F ----------------------
11769: ---------------------------------------------------------------
11770:
11771: if p_no_dup_rslt = ben_plan_design_program_module.g_pdw_no_dup_rslt then
11772: ben_plan_design_program_module.g_pdw_allow_dup_rslt := ben_plan_design_program_module.g_pdw_no_dup_rslt;
11773: end if;
11774:
11775: if p_no_dup_rslt = 'Y' OR
11776: ben_plan_design_program_module.g_pdw_allow_dup_rslt =

Line 11776: ben_plan_design_program_module.g_pdw_allow_dup_rslt =

11772: ben_plan_design_program_module.g_pdw_allow_dup_rslt := ben_plan_design_program_module.g_pdw_no_dup_rslt;
11773: end if;
11774:
11775: if p_no_dup_rslt = 'Y' OR
11776: ben_plan_design_program_module.g_pdw_allow_dup_rslt =
11777: ben_plan_design_program_module.g_pdw_no_dup_rslt then
11778: open c_opt_exists(p_opt_id,'OPT');
11779: fetch c_opt_exists into l_dummy;
11780: if c_opt_exists%found then

Line 11777: ben_plan_design_program_module.g_pdw_no_dup_rslt then

11773: end if;
11774:
11775: if p_no_dup_rslt = 'Y' OR
11776: ben_plan_design_program_module.g_pdw_allow_dup_rslt =
11777: ben_plan_design_program_module.g_pdw_no_dup_rslt then
11778: open c_opt_exists(p_opt_id,'OPT');
11779: fetch c_opt_exists into l_dummy;
11780: if c_opt_exists%found then
11781: close c_opt_exists;

Line 11795: open ben_plan_design_program_module.g_table_route('OPT');

11791: --
11792: for l_opt_rec in c_opt1(l_opt_id,l_mirror_src_entity_result_id,'OPT') loop
11793: --
11794: l_table_route_id := null ;
11795: open ben_plan_design_program_module.g_table_route('OPT');
11796: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
11797: close ben_plan_design_program_module.g_table_route ;
11798: --
11799: l_information5 := l_opt_rec.name; --'Intersection';

Line 11796: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;

11792: for l_opt_rec in c_opt1(l_opt_id,l_mirror_src_entity_result_id,'OPT') loop
11793: --
11794: l_table_route_id := null ;
11795: open ben_plan_design_program_module.g_table_route('OPT');
11796: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
11797: close ben_plan_design_program_module.g_table_route ;
11798: --
11799: l_information5 := l_opt_rec.name; --'Intersection';
11800: --

Line 11797: close ben_plan_design_program_module.g_table_route ;

11793: --
11794: l_table_route_id := null ;
11795: open ben_plan_design_program_module.g_table_route('OPT');
11796: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
11797: close ben_plan_design_program_module.g_table_route ;
11798: --
11799: l_information5 := l_opt_rec.name; --'Intersection';
11800: --
11801: if p_effective_date between l_opt_rec.effective_start_date

Line 11917: ben_plan_design_program_module.create_formula_result(

11913: l_out_opt_result_id := l_copy_entity_result_id ;
11914: end if;
11915: --
11916: if (l_opt_rec.rqd_perd_enrt_nenrt_rl is not null) then
11917: ben_plan_design_program_module.create_formula_result(
11918: p_validate => p_validate
11919: ,p_copy_entity_result_id => l_copy_entity_result_id
11920: ,p_copy_entity_txn_id => p_copy_entity_txn_id
11921: ,p_formula_id => l_opt_rec.rqd_perd_enrt_nenrt_rl

Line 11979: open ben_plan_design_program_module.g_table_route('DDR');

11975: --
11976: for l_ddr_rec in c_ddr2(l_parent_rec.dsgn_rqmt_id,l_mirror_src_entity_result_id,'DDR') loop
11977: --
11978: l_table_route_id := null ;
11979: open ben_plan_design_program_module.g_table_route('DDR');
11980: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
11981: close ben_plan_design_program_module.g_table_route ;
11982: --
11983: l_information5 := hr_general.decode_lookup('BEN_GRP_RLSHP',l_ddr_rec.grp_rlshp_cd); --'Intersection';

Line 11980: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;

11976: for l_ddr_rec in c_ddr2(l_parent_rec.dsgn_rqmt_id,l_mirror_src_entity_result_id,'DDR') loop
11977: --
11978: l_table_route_id := null ;
11979: open ben_plan_design_program_module.g_table_route('DDR');
11980: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
11981: close ben_plan_design_program_module.g_table_route ;
11982: --
11983: l_information5 := hr_general.decode_lookup('BEN_GRP_RLSHP',l_ddr_rec.grp_rlshp_cd); --'Intersection';
11984: --

Line 11981: close ben_plan_design_program_module.g_table_route ;

11977: --
11978: l_table_route_id := null ;
11979: open ben_plan_design_program_module.g_table_route('DDR');
11980: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
11981: close ben_plan_design_program_module.g_table_route ;
11982: --
11983: l_information5 := hr_general.decode_lookup('BEN_GRP_RLSHP',l_ddr_rec.grp_rlshp_cd); --'Intersection';
11984: --
11985: if p_effective_date between l_ddr_rec.effective_start_date

Line 12086: open ben_plan_design_program_module.g_table_route('DRR');

12082: --
12083: for l_drr_rec in c_drr2(l_parent_rec.dsgn_rqmt_rlshp_typ_id,l_mirror_src_entity_result_id,'DRR') loop
12084: --
12085: l_table_route_id := null ;
12086: open ben_plan_design_program_module.g_table_route('DRR');
12087: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
12088: close ben_plan_design_program_module.g_table_route ;
12089: --
12090: l_information5 := hr_general.decode_lookup('CONTACT',l_drr_rec.rlshp_typ_cd); --'Intersection';

Line 12087: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;

12083: for l_drr_rec in c_drr2(l_parent_rec.dsgn_rqmt_rlshp_typ_id,l_mirror_src_entity_result_id,'DRR') loop
12084: --
12085: l_table_route_id := null ;
12086: open ben_plan_design_program_module.g_table_route('DRR');
12087: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
12088: close ben_plan_design_program_module.g_table_route ;
12089: --
12090: l_information5 := hr_general.decode_lookup('CONTACT',l_drr_rec.rlshp_typ_cd); --'Intersection';
12091: --

Line 12088: close ben_plan_design_program_module.g_table_route ;

12084: --
12085: l_table_route_id := null ;
12086: open ben_plan_design_program_module.g_table_route('DRR');
12087: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
12088: close ben_plan_design_program_module.g_table_route ;
12089: --
12090: l_information5 := hr_general.decode_lookup('CONTACT',l_drr_rec.rlshp_typ_cd); --'Intersection';
12091: --
12092: l_result_type_cd := 'DISPLAY';

Line 12182: open ben_plan_design_program_module.g_table_route('PON');

12178: --
12179: for l_pon_rec in c_pon1(l_parent_rec.pl_typ_opt_typ_id,l_mirror_src_entity_result_id,'PON') loop
12180: --
12181: l_table_route_id := null ;
12182: open ben_plan_design_program_module.g_table_route('PON');
12183: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
12184: close ben_plan_design_program_module.g_table_route ;
12185: --
12186: l_information5 := hr_general.decode_lookup('BEN_OPT_TYP',l_pon_rec.pl_typ_opt_typ_cd); --'Intersection';

Line 12183: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;

12179: for l_pon_rec in c_pon1(l_parent_rec.pl_typ_opt_typ_id,l_mirror_src_entity_result_id,'PON') loop
12180: --
12181: l_table_route_id := null ;
12182: open ben_plan_design_program_module.g_table_route('PON');
12183: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
12184: close ben_plan_design_program_module.g_table_route ;
12185: --
12186: l_information5 := hr_general.decode_lookup('BEN_OPT_TYP',l_pon_rec.pl_typ_opt_typ_cd); --'Intersection';
12187: --

Line 12184: close ben_plan_design_program_module.g_table_route ;

12180: --
12181: l_table_route_id := null ;
12182: open ben_plan_design_program_module.g_table_route('PON');
12183: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
12184: close ben_plan_design_program_module.g_table_route ;
12185: --
12186: l_information5 := hr_general.decode_lookup('BEN_OPT_TYP',l_pon_rec.pl_typ_opt_typ_cd); --'Intersection';
12187: --
12188: if p_effective_date between l_pon_rec.effective_start_date

Line 12389: if p_no_dup_rslt = ben_plan_design_program_module.g_pdw_no_dup_rslt then

12385: -- START OF BEN_PL_TYP_F ----------------------
12386: ---------------------------------------------------------------
12387: --
12388: --
12389: if p_no_dup_rslt = ben_plan_design_program_module.g_pdw_no_dup_rslt then
12390: ben_plan_design_program_module.g_pdw_allow_dup_rslt := ben_plan_design_program_module.g_pdw_no_dup_rslt;
12391: end if;
12392:
12393: if ben_plan_design_program_module.g_pdw_allow_dup_rslt = ben_plan_design_program_module.g_pdw_no_dup_rslt then

Line 12390: ben_plan_design_program_module.g_pdw_allow_dup_rslt := ben_plan_design_program_module.g_pdw_no_dup_rslt;

12386: ---------------------------------------------------------------
12387: --
12388: --
12389: if p_no_dup_rslt = ben_plan_design_program_module.g_pdw_no_dup_rslt then
12390: ben_plan_design_program_module.g_pdw_allow_dup_rslt := ben_plan_design_program_module.g_pdw_no_dup_rslt;
12391: end if;
12392:
12393: if ben_plan_design_program_module.g_pdw_allow_dup_rslt = ben_plan_design_program_module.g_pdw_no_dup_rslt then
12394: open c_object_exists(p_pl_typ_id,'PTP');

Line 12393: if ben_plan_design_program_module.g_pdw_allow_dup_rslt = ben_plan_design_program_module.g_pdw_no_dup_rslt then

12389: if p_no_dup_rslt = ben_plan_design_program_module.g_pdw_no_dup_rslt then
12390: ben_plan_design_program_module.g_pdw_allow_dup_rslt := ben_plan_design_program_module.g_pdw_no_dup_rslt;
12391: end if;
12392:
12393: if ben_plan_design_program_module.g_pdw_allow_dup_rslt = ben_plan_design_program_module.g_pdw_no_dup_rslt then
12394: open c_object_exists(p_pl_typ_id,'PTP');
12395: fetch c_object_exists into l_dummy;
12396: if c_object_exists%found then
12397: close c_object_exists;

Line 12412: open ben_plan_design_program_module.g_table_route('PTP');

12408: --
12409: for l_ptp_rec in c_ptp(p_pl_typ_id,l_mirror_src_entity_result_id,'PTP') loop
12410: --
12411: l_table_route_id := null ;
12412: open ben_plan_design_program_module.g_table_route('PTP');
12413: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
12414: close ben_plan_design_program_module.g_table_route ;
12415: --
12416: l_information5 := l_ptp_rec.name;

Line 12413: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;

12409: for l_ptp_rec in c_ptp(p_pl_typ_id,l_mirror_src_entity_result_id,'PTP') loop
12410: --
12411: l_table_route_id := null ;
12412: open ben_plan_design_program_module.g_table_route('PTP');
12413: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
12414: close ben_plan_design_program_module.g_table_route ;
12415: --
12416: l_information5 := l_ptp_rec.name;
12417: --

Line 12414: close ben_plan_design_program_module.g_table_route ;

12410: --
12411: l_table_route_id := null ;
12412: open ben_plan_design_program_module.g_table_route('PTP');
12413: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
12414: close ben_plan_design_program_module.g_table_route ;
12415: --
12416: l_information5 := l_ptp_rec.name;
12417: --
12418: if p_effective_date between l_ptp_rec.effective_start_date

Line 12633: if p_no_dup_rslt = ben_plan_design_program_module.g_pdw_no_dup_rslt then

12629: ---------------------------------------------------------------
12630: -- START OF BEN_YR_PERD ----------------------
12631: ---------------------------------------------------------------
12632:
12633: if p_no_dup_rslt = ben_plan_design_program_module.g_pdw_no_dup_rslt then
12634: ben_plan_design_program_module.g_pdw_allow_dup_rslt := ben_plan_design_program_module.g_pdw_no_dup_rslt;
12635: end if;
12636:
12637: l_mirror_src_entity_result_id := p_copy_entity_result_id ;

Line 12634: ben_plan_design_program_module.g_pdw_allow_dup_rslt := ben_plan_design_program_module.g_pdw_no_dup_rslt;

12630: -- START OF BEN_YR_PERD ----------------------
12631: ---------------------------------------------------------------
12632:
12633: if p_no_dup_rslt = ben_plan_design_program_module.g_pdw_no_dup_rslt then
12634: ben_plan_design_program_module.g_pdw_allow_dup_rslt := ben_plan_design_program_module.g_pdw_no_dup_rslt;
12635: end if;
12636:
12637: l_mirror_src_entity_result_id := p_copy_entity_result_id ;
12638:

Line 12641: if ben_plan_design_program_module.g_pdw_allow_dup_rslt = ben_plan_design_program_module.g_pdw_no_dup_rslt then

12637: l_mirror_src_entity_result_id := p_copy_entity_result_id ;
12638:
12639: l_yr_perd_id := p_yr_perd_id ;
12640:
12641: if ben_plan_design_program_module.g_pdw_allow_dup_rslt = ben_plan_design_program_module.g_pdw_no_dup_rslt then
12642: open c_object_exists(l_yr_perd_id,'YRP');
12643: fetch c_object_exists into l_dummy;
12644: if c_object_exists%found then
12645: close c_object_exists;

Line 12656: open ben_plan_design_program_module.g_table_route('YRP');

12652: for l_yrp_rec in c_yrp(l_yr_perd_id,l_mirror_src_entity_result_id,'YRP') loop
12653: --
12654: --
12655: l_table_route_id := null ;
12656: open ben_plan_design_program_module.g_table_route('YRP');
12657: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
12658: close ben_plan_design_program_module.g_table_route ;
12659: --
12660: l_information5 := TO_CHAR(l_yrp_rec.start_date,'DD-Mon-YYYY')||' - '||

Line 12657: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;

12653: --
12654: --
12655: l_table_route_id := null ;
12656: open ben_plan_design_program_module.g_table_route('YRP');
12657: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
12658: close ben_plan_design_program_module.g_table_route ;
12659: --
12660: l_information5 := TO_CHAR(l_yrp_rec.start_date,'DD-Mon-YYYY')||' - '||
12661: TO_CHAR(l_yrp_rec.end_date,'DD-Mon-YYYY'); --'Intersection';

Line 12658: close ben_plan_design_program_module.g_table_route ;

12654: --
12655: l_table_route_id := null ;
12656: open ben_plan_design_program_module.g_table_route('YRP');
12657: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
12658: close ben_plan_design_program_module.g_table_route ;
12659: --
12660: l_information5 := TO_CHAR(l_yrp_rec.start_date,'DD-Mon-YYYY')||' - '||
12661: TO_CHAR(l_yrp_rec.end_date,'DD-Mon-YYYY'); --'Intersection';
12662: --

Line 12754: open ben_plan_design_program_module.g_table_route('WYP');

12750: for l_wyp_rec in c_wyp(l_parent_rec.wthn_yr_perd_id,l_mirror_src_entity_result_id,'WYP') loop
12751: --
12752: --
12753: l_table_route_id := null ;
12754: open ben_plan_design_program_module.g_table_route('WYP');
12755: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
12756: close ben_plan_design_program_module.g_table_route ;
12757: --
12758: l_information5 := TO_CHAR(l_wyp_rec.strt_mo) || '/' || TO_CHAR(l_wyp_rec.strt_day)|| ' - ' ||

Line 12755: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;

12751: --
12752: --
12753: l_table_route_id := null ;
12754: open ben_plan_design_program_module.g_table_route('WYP');
12755: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
12756: close ben_plan_design_program_module.g_table_route ;
12757: --
12758: l_information5 := TO_CHAR(l_wyp_rec.strt_mo) || '/' || TO_CHAR(l_wyp_rec.strt_day)|| ' - ' ||
12759: TO_CHAR(l_wyp_rec.end_mo) || '/' || TO_CHAR(l_wyp_rec.end_day); --'Intersection';

Line 12756: close ben_plan_design_program_module.g_table_route ;

12752: --
12753: l_table_route_id := null ;
12754: open ben_plan_design_program_module.g_table_route('WYP');
12755: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
12756: close ben_plan_design_program_module.g_table_route ;
12757: --
12758: l_information5 := TO_CHAR(l_wyp_rec.strt_mo) || '/' || TO_CHAR(l_wyp_rec.strt_day)|| ' - ' ||
12759: TO_CHAR(l_wyp_rec.end_mo) || '/' || TO_CHAR(l_wyp_rec.end_day); --'Intersection';
12760: --