[Home] [Help]
37: cache on demand.
38: 115.13 31-May-00 mhoyes - Fixed age and los problems.
39: 115.14 15-Dec-00 Tmathers - Change calls for
40: ben_hash_utility.write_mastDet_Cache to
41: call ben_cache.write_mastDet_Cache.
42: WWBUG 1545633.
43: 115.15 29-Dec-00 Tmathers - fixed check_sql errors
44: 115.16 20-Mar-02 vsethi added dbdrv lines
45: 115.17 29-Apr-02 pabodla Bug 1631182 : support user created
322: --
323: l_proc varchar2(80) := g_package || '.get_rt_prfl_cache people group';
324: l_lookup_query long;
325: l_inst_query long;
326: l_instcolnm_set ben_cache.instcolnmtype;
327: --
328: begin
329: --
330: g_pg_out.delete;
448: l_instcolnm_set(32).caccol_name := 'SEGMENT30';
449: l_instcolnm_set(32).col_name := 'SEGMENT30';
450:
451: --
452: ben_cache.write_mastDet_Cache
453: (p_mastercol_name => 'vrbl_rt_prfl_id'
454: ,p_detailcol_name => 'vrbl_rt_prfl_id'
455: ,p_lkup_name => 'ben_rt_prfl_cache.g_pg_lookup'
456: ,p_inst_name => 'ben_rt_prfl_cache.g_pg_instance'
495: --
496: l_proc varchar2(80) := g_package || '.get_rt_prfl_cache people group';
497: l_lookup_query long;
498: l_inst_query long;
499: l_instcolnm_set ben_cache.instcolnmtype;
500: --
501: begin
502: --
503: g_pg_out.delete;
534: l_instcolnm_set(1).caccol_name := 'people_group_id';
535: l_instcolnm_set(2).col_name := 'excld_flag';
536: l_instcolnm_set(2).caccol_name := 'excld_flag';
537: --
538: ben_cache.write_mastDet_Cache
539: (p_mastercol_name => 'vrbl_rt_prfl_id'
540: ,p_detailcol_name => 'vrbl_rt_prfl_id'
541: ,p_lkup_name => 'ben_rt_prfl_cache.g_pg_lookup'
542: ,p_inst_name => 'ben_rt_prfl_cache.g_pg_instance'
584: --
585: l_proc varchar2(80) := g_package || '.get_rt_prfl_cache RULES';
586: l_lookup_query long;
587: l_inst_query long;
588: l_instcolnm_set ben_cache.instcolnmtype;
589: --
590: begin
591: g_rl_out.delete;
592: --
618: l_instcolnm_set(0).col_name := 'vrbl_rt_prfl_id';
619: l_instcolnm_set(0).caccol_name := 'id';
620: l_instcolnm_set(1).col_name := 'formula_id';
621: l_instcolnm_set(1).caccol_name := 'formula_id';
622: ben_cache.write_mastDet_Cache
623: (p_mastercol_name => 'vrbl_rt_prfl_id'
624: ,p_detailcol_name => 'vrbl_rt_prfl_id'
625: ,p_lkup_name => 'ben_rt_prfl_cache.g_rl_lookup'
626: ,p_inst_name => 'ben_rt_prfl_cache.g_rl_instance'
665: --
666: l_proc varchar2(80) := g_package || '.get_rt_prfl_cache';
667: l_lookup_query long;
668: l_inst_query long;
669: l_instcolnm_set ben_cache.instcolnmtype;
670: --
671: begin
672: --
673: g_tbco_out.delete;
704: l_instcolnm_set(1).caccol_name := 'uses_tbco_flag';
705: l_instcolnm_set(2).col_name := 'excld_flag';
706: l_instcolnm_set(2).caccol_name := 'excld_flag';
707: --
708: ben_cache.write_mastDet_Cache
709: (p_mastercol_name => 'vrbl_rt_prfl_id'
710: ,p_detailcol_name => 'vrbl_rt_prfl_id'
711: ,p_lkup_name => 'ben_rt_prfl_cache.g_tbco_lookup'
712: ,p_inst_name => 'ben_rt_prfl_cache.g_tbco_instance'
753: --
754: l_proc varchar2(80) := g_package || '.get_rt_prfl_cache';
755: l_lookup_query long;
756: l_inst_query long;
757: l_instcolnm_set ben_cache.instcolnmtype;
758: --
759: begin
760: --
761: g_gndr_out.delete;
792: l_instcolnm_set(1).caccol_name := 'gndr_cd';
793: l_instcolnm_set(2).col_name := 'excld_flag';
794: l_instcolnm_set(2).caccol_name := 'excld_flag';
795: --
796: ben_cache.write_mastDet_Cache
797: (p_mastercol_name => 'vrbl_rt_prfl_id'
798: ,p_detailcol_name => 'vrbl_rt_prfl_id'
799: ,p_lkup_name => 'ben_rt_prfl_cache.g_gndr_lookup'
800: ,p_inst_name => 'ben_rt_prfl_cache.g_gndr_instance'
841: --
842: l_proc varchar2(80) := g_package || '.get_rt_prfl_cache';
843: l_lookup_query long;
844: l_inst_query long;
845: l_instcolnm_set ben_cache.instcolnmtype;
846: --
847: begin
848: --
849: g_dsbld_out.delete;
880: l_instcolnm_set(1).caccol_name := 'dsbld_cd';
881: l_instcolnm_set(2).col_name := 'excld_flag';
882: l_instcolnm_set(2).caccol_name := 'excld_flag';
883: --
884: ben_cache.write_mastDet_Cache
885: (p_mastercol_name => 'vrbl_rt_prfl_id'
886: ,p_detailcol_name => 'vrbl_rt_prfl_id'
887: ,p_lkup_name => 'ben_rt_prfl_cache.g_dsbld_lookup'
888: ,p_inst_name => 'ben_rt_prfl_cache.g_dsbld_instance'
929: --
930: l_proc varchar2(80) := g_package || '.get_rt_prfl_cache';
931: l_lookup_query long;
932: l_inst_query long;
933: l_instcolnm_set ben_cache.instcolnmtype;
934: --
935: begin
936: --
937: g_brgng_out.delete;
968: l_instcolnm_set(1).caccol_name := 'brgng_unit_cd';
969: l_instcolnm_set(2).col_name := 'excld_flag';
970: l_instcolnm_set(2).caccol_name := 'excld_flag';
971: --
972: ben_cache.write_mastDet_Cache
973: (p_mastercol_name => 'vrbl_rt_prfl_id'
974: ,p_detailcol_name => 'vrbl_rt_prfl_id'
975: ,p_lkup_name => 'ben_rt_prfl_cache.g_brgng_lookup'
976: ,p_inst_name => 'ben_rt_prfl_cache.g_brgng_instance'
1017: --
1018: l_proc varchar2(80) := g_package || '.get_rt_prfl_cache';
1019: l_lookup_query long;
1020: l_inst_query long;
1021: l_instcolnm_set ben_cache.instcolnmtype;
1022: --
1023: begin
1024: --
1025: g_bnfgrp_out.delete;
1056: l_instcolnm_set(1).caccol_name := 'benfts_grp_id';
1057: l_instcolnm_set(2).col_name := 'excld_flag';
1058: l_instcolnm_set(2).caccol_name := 'excld_flag';
1059: --
1060: ben_cache.write_mastDet_Cache
1061: (p_mastercol_name => 'vrbl_rt_prfl_id'
1062: ,p_detailcol_name => 'vrbl_rt_prfl_id'
1063: ,p_lkup_name => 'ben_rt_prfl_cache.g_bnfgrp_lookup'
1064: ,p_inst_name => 'ben_rt_prfl_cache.g_bnfgrp_instance'
1105: --
1106: l_proc varchar2(80) := g_package || '.get_rt_prfl_cache';
1107: l_lookup_query long;
1108: l_inst_query long;
1109: l_instcolnm_set ben_cache.instcolnmtype;
1110: --
1111: begin
1112: --
1113: g_eestat_out.delete;
1145: l_instcolnm_set(1).caccol_name := 'assignment_status_type_id';
1146: l_instcolnm_set(2).col_name := 'excld_flag';
1147: l_instcolnm_set(2).caccol_name := 'excld_flag';
1148: --
1149: ben_cache.write_mastDet_Cache
1150: (p_mastercol_name => 'vrbl_rt_prfl_id'
1151: ,p_detailcol_name => 'vrbl_rt_prfl_id'
1152: ,p_lkup_name => 'ben_rt_prfl_cache.g_eestat_lookup'
1153: ,p_inst_name => 'ben_rt_prfl_cache.g_eestat_instance'
1192: ,p_inst_count out nocopy number) is
1193: --
1194: l_proc varchar2(72) := 'get_rt_prfl_cache';
1195: --
1196: l_instcolnm_set ben_cache.InstColNmType;
1197: --
1198: l_torrwnum pls_integer;
1199: l_insttorrw_num pls_integer;
1200: l_index pls_integer;
1236: l_instcolnm_set(l_instcolnm_num).caccol_name := 'excld_flag';
1237: l_instcolnm_set(l_instcolnm_num).col_alias := 'table1';
1238: l_instcolnm_num := l_instcolnm_num+1;
1239: --
1240: ben_cache.Write_BGP_Cache
1241: (p_mastertab_name => l_mastertab_name
1242: ,p_masterpkcol_name => l_masterpkcol_name
1243: ,p_table1_name => 'ben_fl_tm_pt_tm_rt_f'
1244: ,p_business_group_id => p_business_group_id
1323: --
1324: l_proc varchar2(80) := g_package || '.get_rt_prfl_cache';
1325: l_lookup_query long;
1326: l_inst_query long;
1327: l_instcolnm_set ben_cache.instcolnmtype;
1328: --
1329: begin
1330: --
1331: g_grd_out.delete;
1362: l_instcolnm_set(1).caccol_name := 'grade_id';
1363: l_instcolnm_set(2).col_name := 'excld_flag';
1364: l_instcolnm_set(2).caccol_name := 'excld_flag';
1365: --
1366: ben_cache.write_mastDet_Cache
1367: (p_mastercol_name => 'vrbl_rt_prfl_id'
1368: ,p_detailcol_name => 'vrbl_rt_prfl_id'
1369: ,p_lkup_name => 'ben_rt_prfl_cache.g_grd_lookup'
1370: ,p_inst_name => 'ben_rt_prfl_cache.g_grd_instance'
1411: --
1412: l_proc varchar2(80) := g_package || '.get_rt_prfl_cache';
1413: l_lookup_query long;
1414: l_inst_query long;
1415: l_instcolnm_set ben_cache.instcolnmtype;
1416: --
1417: begin
1418: --
1419: g_pctft_out.delete;
1458: l_instcolnm_set(4).caccol_name := 'no_mx_pct_val_flag';
1459: l_instcolnm_set(5).col_name := 'excld_flag';
1460: l_instcolnm_set(5).caccol_name := 'excld_flag';
1461: --
1462: ben_cache.write_mastDet_Cache
1463: (p_mastercol_name => 'vrbl_rt_prfl_id'
1464: ,p_detailcol_name => 'vrbl_rt_prfl_id'
1465: ,p_lkup_name => 'ben_rt_prfl_cache.g_pctft_lookup'
1466: ,p_inst_name => 'ben_rt_prfl_cache.g_pctft_instance'
1507: --
1508: l_proc varchar2(80) := g_package || '.get_rt_prfl_cache';
1509: l_lookup_query long;
1510: l_inst_query long;
1511: l_instcolnm_set ben_cache.instcolnmtype;
1512: --
1513: begin
1514: --
1515: g_hrswkd_out.delete;
1554: l_instcolnm_set(4).caccol_name := 'no_mx_hrs_wkd_flag';
1555: l_instcolnm_set(5).col_name := 'excld_flag';
1556: l_instcolnm_set(5).caccol_name := 'excld_flag';
1557: --
1558: ben_cache.write_mastDet_Cache
1559: (p_mastercol_name => 'vrbl_rt_prfl_id'
1560: ,p_detailcol_name => 'vrbl_rt_prfl_id'
1561: ,p_lkup_name => 'ben_rt_prfl_cache.g_hrswkd_lookup'
1562: ,p_inst_name => 'ben_rt_prfl_cache.g_hrswkd_instance'
1603: --
1604: l_proc varchar2(80) := g_package || '.get_rt_prfl_cache';
1605: l_lookup_query long;
1606: l_inst_query long;
1607: l_instcolnm_set ben_cache.instcolnmtype;
1608: --
1609: begin
1610: --
1611: g_poe_out.delete;
1656: l_instcolnm_set(7).caccol_name := 'poe_nnmntry_uom';
1657: l_instcolnm_set(8).col_name := 'cbr_dsblty_apls_flag';
1658: l_instcolnm_set(8).caccol_name := 'cbr_dsblty_apls_flag';
1659: --
1660: ben_cache.write_mastDet_Cache
1661: (p_mastercol_name => 'vrbl_rt_prfl_id'
1662: ,p_detailcol_name => 'vrbl_rt_prfl_id'
1663: ,p_lkup_name => 'ben_rt_prfl_cache.g_poe_lookup'
1664: ,p_inst_name => 'ben_rt_prfl_cache.g_poe_instance'
1705: --
1706: l_proc varchar2(80) := g_package || '.get_rt_prfl_cache';
1707: l_lookup_query long;
1708: l_inst_query long;
1709: l_instcolnm_set ben_cache.instcolnmtype;
1710: --
1711: begin
1712: --
1713: g_lbrmmbr_out.delete;
1744: l_instcolnm_set(1).caccol_name := 'lbr_mmbr_flag';
1745: l_instcolnm_set(2).col_name := 'excld_flag';
1746: l_instcolnm_set(2).caccol_name := 'excld_flag';
1747: --
1748: ben_cache.write_mastDet_Cache
1749: (p_mastercol_name => 'vrbl_rt_prfl_id'
1750: ,p_detailcol_name => 'vrbl_rt_prfl_id'
1751: ,p_lkup_name => 'ben_rt_prfl_cache.g_lbrmmbr_lookup'
1752: ,p_inst_name => 'ben_rt_prfl_cache.g_lbrmmbr_instance'
1793: --
1794: l_proc varchar2(80) := g_package || '.get_rt_prfl_cache';
1795: l_lookup_query long;
1796: l_inst_query long;
1797: l_instcolnm_set ben_cache.instcolnmtype;
1798: --
1799: begin
1800: --
1801: g_lglenty_out.delete;
1832: l_instcolnm_set(1).caccol_name := 'organization_id';
1833: l_instcolnm_set(2).col_name := 'excld_flag';
1834: l_instcolnm_set(2).caccol_name := 'excld_flag';
1835: --
1836: ben_cache.write_mastDet_Cache
1837: (p_mastercol_name => 'vrbl_rt_prfl_id'
1838: ,p_detailcol_name => 'vrbl_rt_prfl_id'
1839: ,p_lkup_name => 'ben_rt_prfl_cache.g_lglenty_lookup'
1840: ,p_inst_name => 'ben_rt_prfl_cache.g_lglenty_instance'
1879: ,p_inst_count out nocopy number) is
1880: --
1881: l_proc varchar2(72) := 'get_rt_prfl_cache';
1882: --
1883: l_instcolnm_set ben_cache.InstColNmType;
1884: --
1885: l_torrwnum pls_integer;
1886: l_insttorrw_num pls_integer;
1887: l_index pls_integer;
1928: l_instcolnm_set(l_instcolnm_num).caccol_name := 'excld_flag';
1929: l_instcolnm_set(l_instcolnm_num).col_alias := 'table1';
1930: l_instcolnm_num := l_instcolnm_num+1;
1931: --
1932: ben_cache.Write_BGP_Cache
1933: (p_mastertab_name => l_mastertab_name
1934: ,p_masterpkcol_name => l_masterpkcol_name
1935: ,p_table1_name => 'ben_loa_rsn_rt_f'
1936: ,p_business_group_id => p_business_group_id
2013: ,p_inst_count out nocopy number) is
2014: --
2015: l_proc varchar2(72) := 'get_rt_prfl_cache';
2016: --
2017: l_instcolnm_set ben_cache.InstColNmType;
2018: --
2019: l_torrwnum pls_integer;
2020: l_insttorrw_num pls_integer;
2021: l_index pls_integer;
2057: l_instcolnm_set(l_instcolnm_num).caccol_name := 'excld_flag';
2058: l_instcolnm_set(l_instcolnm_num).col_alias := 'table1';
2059: l_instcolnm_num := l_instcolnm_num+1;
2060: --
2061: ben_cache.Write_BGP_Cache
2062: (p_mastertab_name => l_mastertab_name
2063: ,p_masterpkcol_name => l_masterpkcol_name
2064: ,p_table1_name => 'ben_org_unit_rt_f'
2065: ,p_business_group_id => p_business_group_id
2144: --
2145: l_proc varchar2(80) := g_package || '.get_rt_prfl_cache';
2146: l_lookup_query long;
2147: l_inst_query long;
2148: l_instcolnm_set ben_cache.instcolnmtype;
2149: --
2150: begin
2151: --
2152: g_pertyp_out.delete;
2190: l_instcolnm_set(1).caccol_name := 'person_type_id';
2191: l_instcolnm_set(2).col_name := 'excld_flag';
2192: l_instcolnm_set(2).caccol_name := 'excld_flag';
2193: --
2194: ben_cache.write_mastDet_Cache
2195: (p_mastercol_name => 'vrbl_rt_prfl_id'
2196: ,p_detailcol_name => 'vrbl_rt_prfl_id'
2197: ,p_lkup_name => 'ben_rt_prfl_cache.g_pertyp_lookup'
2198: ,p_inst_name => 'ben_rt_prfl_cache.g_pertyp_instance'
2239: --
2240: l_proc varchar2(80) := g_package || '.get_rt_prfl_cache';
2241: l_lookup_query long;
2242: l_inst_query long;
2243: l_instcolnm_set ben_cache.instcolnmtype;
2244: --
2245: begin
2246: --
2247: g_ziprng_out.delete;
2282: l_instcolnm_set(2).caccol_name := 'to_value';
2283: l_instcolnm_set(3).col_name := 'excld_flag';
2284: l_instcolnm_set(3).caccol_name := 'excld_flag';
2285: --
2286: ben_cache.write_mastDet_Cache
2287: (p_mastercol_name => 'vrbl_rt_prfl_id'
2288: ,p_detailcol_name => 'vrbl_rt_prfl_id'
2289: ,p_lkup_name => 'ben_rt_prfl_cache.g_ziprng_lookup'
2290: ,p_inst_name => 'ben_rt_prfl_cache.g_ziprng_instance'
2331: --
2332: l_proc varchar2(80) := g_package || '.get_rt_prfl_cache';
2333: l_lookup_query long;
2334: l_inst_query long;
2335: l_instcolnm_set ben_cache.instcolnmtype;
2336: --
2337: begin
2338: --
2339: g_pyrl_out.delete;
2370: l_instcolnm_set(1).caccol_name := 'payroll_id';
2371: l_instcolnm_set(2).col_name := 'excld_flag';
2372: l_instcolnm_set(2).caccol_name := 'excld_flag';
2373: --
2374: ben_cache.write_mastDet_Cache
2375: (p_mastercol_name => 'vrbl_rt_prfl_id'
2376: ,p_detailcol_name => 'vrbl_rt_prfl_id'
2377: ,p_lkup_name => 'ben_rt_prfl_cache.g_pyrl_lookup'
2378: ,p_inst_name => 'ben_rt_prfl_cache.g_pyrl_instance'
2419: --
2420: l_proc varchar2(80) := g_package || '.get_rt_prfl_cache';
2421: l_lookup_query long;
2422: l_inst_query long;
2423: l_instcolnm_set ben_cache.instcolnmtype;
2424: --
2425: begin
2426: --
2427: g_py_bss_out.delete;
2458: l_instcolnm_set(1).caccol_name := 'pay_basis_id';
2459: l_instcolnm_set(2).col_name := 'excld_flag';
2460: l_instcolnm_set(2).caccol_name := 'excld_flag';
2461: --
2462: ben_cache.write_mastDet_Cache
2463: (p_mastercol_name => 'vrbl_rt_prfl_id'
2464: ,p_detailcol_name => 'vrbl_rt_prfl_id'
2465: ,p_lkup_name => 'ben_rt_prfl_cache.g_py_bss_lookup'
2466: ,p_inst_name => 'ben_rt_prfl_cache.g_py_bss_instance'
2507: --
2508: l_proc varchar2(80) := g_package || '.get_rt_prfl_cache';
2509: l_lookup_query long;
2510: l_inst_query long;
2511: l_instcolnm_set ben_cache.instcolnmtype;
2512: --
2513: begin
2514: --
2515: g_scdhrs_out.delete;
2564: l_instcolnm_set(9).col_name := 'excld_flag';
2565: l_instcolnm_set(9).caccol_name := 'excld_flag';
2566:
2567: --
2568: ben_cache.write_mastDet_Cache
2569: (p_mastercol_name => 'vrbl_rt_prfl_id'
2570: ,p_detailcol_name => 'vrbl_rt_prfl_id'
2571: ,p_lkup_name => 'ben_rt_prfl_cache.g_scdhrs_lookup'
2572: ,p_inst_name => 'ben_rt_prfl_cache.g_scdhrs_instance'
2614: --
2615: l_proc varchar2(80) := g_package || '.get_rt_prfl_cache';
2616: l_lookup_query long;
2617: l_inst_query long;
2618: l_instcolnm_set ben_cache.instcolnmtype;
2619: --
2620: begin
2621: --
2622: g_wkloc_out.delete;
2653: l_instcolnm_set(1).caccol_name := 'location_id';
2654: l_instcolnm_set(2).col_name := 'excld_flag';
2655: l_instcolnm_set(2).caccol_name := 'excld_flag';
2656: --
2657: ben_cache.write_mastDet_Cache
2658: (p_mastercol_name => 'vrbl_rt_prfl_id'
2659: ,p_detailcol_name => 'vrbl_rt_prfl_id'
2660: ,p_lkup_name => 'ben_rt_prfl_cache.g_wkloc_lookup'
2661: ,p_inst_name => 'ben_rt_prfl_cache.g_wkloc_instance'
2702: --
2703: l_proc varchar2(80) := g_package || '.get_rt_prfl_cache';
2704: l_lookup_query long;
2705: l_inst_query long;
2706: l_instcolnm_set ben_cache.instcolnmtype;
2707: --
2708: begin
2709: --
2710: g_svcarea_out.delete;
2753: l_instcolnm_set(2).caccol_name := 'to_value';
2754: l_instcolnm_set(3).col_name := 'excld_flag';
2755: l_instcolnm_set(3).caccol_name := 'excld_flag';
2756: --
2757: ben_cache.write_mastDet_Cache
2758: (p_mastercol_name => 'vrbl_rt_prfl_id'
2759: ,p_detailcol_name => 'vrbl_rt_prfl_id'
2760: ,p_lkup_name => 'ben_rt_prfl_cache.g_svcarea_lookup'
2761: ,p_inst_name => 'ben_rt_prfl_cache.g_svcarea_instance'
2802: --
2803: l_proc varchar2(80) := g_package || '.get_rt_prfl_cache';
2804: l_lookup_query long;
2805: l_inst_query long;
2806: l_instcolnm_set ben_cache.instcolnmtype;
2807: --
2808: begin
2809: --
2810: g_hrlyslrd_out.delete;
2841: l_instcolnm_set(1).caccol_name := 'hrly_slrd_cd';
2842: l_instcolnm_set(2).col_name := 'excld_flag';
2843: l_instcolnm_set(2).caccol_name := 'excld_flag';
2844: --
2845: ben_cache.write_mastDet_Cache
2846: (p_mastercol_name => 'vrbl_rt_prfl_id'
2847: ,p_detailcol_name => 'vrbl_rt_prfl_id'
2848: ,p_lkup_name => 'ben_rt_prfl_cache.g_hrlyslrd_lookup'
2849: ,p_inst_name => 'ben_rt_prfl_cache.g_hrlyslrd_instance'
2888: ,p_inst_count out nocopy number) is
2889: --
2890: l_proc varchar2(72) := 'get_rt_prfl_cache';
2891: --
2892: l_instcolnm_set ben_cache.InstColNmType;
2893: l_tabdet_set ben_cache.TabDetType;
2894: --
2895: l_torrwnum pls_integer;
2896: l_insttorrw_num pls_integer;
2889: --
2890: l_proc varchar2(72) := 'get_rt_prfl_cache';
2891: --
2892: l_instcolnm_set ben_cache.InstColNmType;
2893: l_tabdet_set ben_cache.TabDetType;
2894: --
2895: l_torrwnum pls_integer;
2896: l_insttorrw_num pls_integer;
2897: l_index pls_integer;
2964: l_instcolnm_set(l_instcolnm_num).col_alias := 'table2';
2965: l_instcolnm_set(l_instcolnm_num).col_type := 'SELECT';
2966: l_instcolnm_num := l_instcolnm_num+1;
2967: --
2968: ben_cache.Write_BGP_Cache
2969: (p_mastertab_name => l_mastertab_name
2970: ,p_masterpkcol_name => l_masterpkcol_name
2971: ,p_tabdet_set => l_tabdet_set
2972: ,p_table1_name => null
3052: --
3053: l_proc varchar2(80) := g_package || '.get_rt_prfl_cache';
3054: l_lookup_query long;
3055: l_inst_query long;
3056: l_instcolnm_set ben_cache.instcolnmtype;
3057: --
3058: begin
3059: --
3060: g_complvl_out.delete;
3102: l_instcolnm_set(5).caccol_name := 'no_mn_comp_flag';
3103: l_instcolnm_set(6).col_name := 'no_mx_comp_flag';
3104: l_instcolnm_set(6).caccol_name := 'no_mx_comp_flag';
3105: --
3106: ben_cache.write_mastDet_Cache
3107: (p_mastercol_name => 'vrbl_rt_prfl_id'
3108: ,p_detailcol_name => 'vrbl_rt_prfl_id'
3109: ,p_lkup_name => 'ben_rt_prfl_cache.g_complvl_lookup'
3110: ,p_inst_name => 'ben_rt_prfl_cache.g_complvl_instance'
3149: ,p_inst_count out nocopy number) is
3150: --
3151: l_proc varchar2(72) := 'get_rt_prfl_cache';
3152: --
3153: l_instcolnm_set ben_cache.InstColNmType;
3154: l_tabdet_set ben_cache.TabDetType;
3155: --
3156: l_torrwnum pls_integer;
3157: l_insttorrw_num pls_integer;
3150: --
3151: l_proc varchar2(72) := 'get_rt_prfl_cache';
3152: --
3153: l_instcolnm_set ben_cache.InstColNmType;
3154: l_tabdet_set ben_cache.TabDetType;
3155: --
3156: l_torrwnum pls_integer;
3157: l_insttorrw_num pls_integer;
3158: l_index pls_integer;
3225: l_instcolnm_set(l_instcolnm_num).col_alias := 'table2';
3226: l_instcolnm_set(l_instcolnm_num).col_type := 'SELECT';
3227: l_instcolnm_num := l_instcolnm_num+1;
3228: --
3229: ben_cache.Write_BGP_Cache
3230: (p_mastertab_name => l_mastertab_name
3231: ,p_masterpkcol_name => l_masterpkcol_name
3232: ,p_tabdet_set => l_tabdet_set
3233: ,p_table1_name => null
3314: --
3315: l_proc varchar2(80) := g_package || '.get_rt_prfl_cache';
3316: l_lookup_query long;
3317: l_inst_query long;
3318: l_instcolnm_set ben_cache.instcolnmtype;
3319: --
3320: begin
3321: --
3322: g_los_out.delete;
3365: l_instcolnm_set(5).caccol_name := 'no_mx_los_num_apls_flag';
3366: l_instcolnm_set(6).col_name := 'los_fctr_id';
3367: l_instcolnm_set(6).caccol_name := 'los_fctr_id';
3368: --
3369: ben_cache.write_mastDet_Cache
3370: (p_mastercol_name => 'vrbl_rt_prfl_id'
3371: ,p_detailcol_name => 'vrbl_rt_prfl_id'
3372: ,p_lkup_name => 'ben_rt_prfl_cache.g_los_lookup'
3373: ,p_inst_name => 'ben_rt_prfl_cache.g_los_instance'
3415: --
3416: l_proc varchar2(80) := g_package || '.get_rt_prfl_cache';
3417: l_lookup_query long;
3418: l_inst_query long;
3419: l_instcolnm_set ben_cache.instcolnmtype;
3420: --
3421: begin
3422: --
3423: g_age_los_out.delete;
3461: l_instcolnm_set(3).caccol_name := 'excld_flag';
3462: l_instcolnm_set(4).col_name := 'cmbn_age_los_fctr_id';
3463: l_instcolnm_set(4).caccol_name := 'cmbn_age_los_fctr_id';
3464: --
3465: ben_cache.write_mastDet_Cache
3466: (p_mastercol_name => 'vrbl_rt_prfl_id'
3467: ,p_detailcol_name => 'vrbl_rt_prfl_id'
3468: ,p_lkup_name => 'ben_rt_prfl_cache.g_age_los_lookup'
3469: ,p_inst_name => 'ben_rt_prfl_cache.g_age_los_instance'
3508: ,p_inst_count out nocopy number) is
3509: --
3510: l_proc varchar2(72) := 'get_rt_prfl_cache';
3511: --
3512: l_instcolnm_set ben_cache.InstColNmType;
3513: --
3514: l_torrwnum pls_integer;
3515: l_insttorrw_num pls_integer;
3516: l_index pls_integer;
3552: l_instcolnm_set(l_instcolnm_num).caccol_name := 'mx_prtt_num';
3553: l_instcolnm_set(l_instcolnm_num).col_alias := 'table1';
3554: l_instcolnm_num := l_instcolnm_num+1;
3555: --
3556: ben_cache.Write_BGP_Cache
3557: (p_mastertab_name => l_mastertab_name
3558: ,p_masterpkcol_name => l_masterpkcol_name
3559: ,p_table1_name => 'ben_ttl_prtt_rt_f'
3560: ,p_business_group_id => p_business_group_id
3639: --
3640: l_proc varchar2(80) := g_package || '.get_rt_prfl_cache, ttl cvg';
3641: l_lookup_query long;
3642: l_inst_query long;
3643: l_instcolnm_set ben_cache.instcolnmtype;
3644: --
3645: begin
3646: g_ttl_cvg_out.delete;
3647: --
3678: l_instcolnm_set(1).caccol_name := 'mn_cvg_vol_amt';
3679: l_instcolnm_set(2).col_name := 'mx_cvg_vol_amt';
3680: l_instcolnm_set(2).caccol_name := 'mx_cvg_vol_amt';
3681:
3682: ben_cache.write_mastDet_Cache
3683: (p_mastercol_name => 'vrbl_rt_prfl_id'
3684: ,p_detailcol_name => 'vrbl_rt_prfl_id'
3685: ,p_lkup_name => 'ben_rt_prfl_cache.g_ttl_cvg_lookup'
3686: ,p_inst_name => 'ben_rt_prfl_cache.g_ttl_cvg_instance'
3730: --
3731: l_proc varchar2(80) := g_package || '.get_rt_prfl_cache';
3732: l_lookup_query long;
3733: l_inst_query long;
3734: l_instcolnm_set ben_cache.instcolnmtype;
3735: --
3736: begin
3737: --
3738: g_job_out.delete;
3769: l_instcolnm_set(1).caccol_name := 'job_id';
3770: l_instcolnm_set(2).col_name := 'excld_flag';
3771: l_instcolnm_set(2).caccol_name := 'excld_flag';
3772: --
3773: ben_cache.write_mastDet_Cache
3774: (p_mastercol_name => 'vrbl_rt_prfl_id'
3775: ,p_detailcol_name => 'vrbl_rt_prfl_id'
3776: ,p_lkup_name => 'ben_rt_prfl_cache.g_job_lookup'
3777: ,p_inst_name => 'ben_rt_prfl_cache.g_job_instance'
3819: --
3820: l_proc varchar2(80) := g_package || '.get_rt_prfl_cache';
3821: l_lookup_query long;
3822: l_inst_query long;
3823: l_instcolnm_set ben_cache.instcolnmtype;
3824: --
3825: begin
3826: --
3827: g_optd_mdcr_out.delete;
3856: l_instcolnm_set(0).caccol_name := 'id';
3857: l_instcolnm_set(1).col_name := 'optd_mdcr_flag';
3858: l_instcolnm_set(1).caccol_name := 'optd_mdcr_flag';
3859: --
3860: ben_cache.write_mastDet_Cache
3861: (p_mastercol_name => 'vrbl_rt_prfl_id'
3862: ,p_detailcol_name => 'vrbl_rt_prfl_id'
3863: ,p_lkup_name => 'ben_rt_prfl_cache.g_optd_mdcr_lookup'
3864: ,p_inst_name => 'ben_rt_prfl_cache.g_optd_mdcr_instance'
3905: --
3906: l_proc varchar2(80) := g_package || '.get_rt_prfl_cache';
3907: l_lookup_query long;
3908: l_inst_query long;
3909: l_instcolnm_set ben_cache.instcolnmtype;
3910: --
3911: begin
3912: --
3913: g_lvg_rsn_out.delete;
3944: l_instcolnm_set(1).caccol_name := 'lvg_rsn_cd';
3945: l_instcolnm_set(2).col_name := 'excld_flag';
3946: l_instcolnm_set(2).caccol_name := 'excld_flag';
3947: --
3948: ben_cache.write_mastDet_Cache
3949: (p_mastercol_name => 'vrbl_rt_prfl_id'
3950: ,p_detailcol_name => 'vrbl_rt_prfl_id'
3951: ,p_lkup_name => 'ben_rt_prfl_cache.g_lvg_rsn_lookup'
3952: ,p_inst_name => 'ben_rt_prfl_cache.g_lvg_rsn_instance'
3994: --
3995: l_proc varchar2(80) := g_package || '.get_rt_prfl_cache';
3996: l_lookup_query long;
3997: l_inst_query long;
3998: l_instcolnm_set ben_cache.instcolnmtype;
3999: --
4000: begin
4001: --
4002: g_cbr_qual_bnf_out.delete;
4037: l_instcolnm_set(3).col_name := 'quald_bnf_flag';
4038: l_instcolnm_set(3).caccol_name := 'quald_bnf_flag';
4039:
4040: --
4041: ben_cache.write_mastDet_Cache
4042: (p_mastercol_name => 'vrbl_rt_prfl_id'
4043: ,p_detailcol_name => 'vrbl_rt_prfl_id'
4044: ,p_lkup_name => 'ben_rt_prfl_cache.g_cbr_qual_bnf_lookup'
4045: ,p_inst_name => 'ben_rt_prfl_cache.g_cbr_qual_bnf_instance'
4087: --
4088: l_proc varchar2(80) := g_package || '.get_rt_prfl_cache';
4089: l_lookup_query long;
4090: l_inst_query long;
4091: l_instcolnm_set ben_cache.instcolnmtype;
4092: --
4093: begin
4094: --
4095: g_cntng_prtn_prfl_out.delete;
4130: l_instcolnm_set(2).caccol_name := 'pymt_must_be_rcvd_num';
4131: l_instcolnm_set(3).col_name := 'pymt_must_be_rcvd_rl';
4132: l_instcolnm_set(4).caccol_name := 'pymt_must_be_rcvd_rl';
4133: --
4134: ben_cache.write_mastDet_Cache
4135: (p_mastercol_name => 'vrbl_rt_prfl_id'
4136: ,p_detailcol_name => 'vrbl_rt_prfl_id'
4137: ,p_lkup_name => 'ben_rt_prfl_cache.g_cntng_prtn_prfl_lookup'
4138: ,p_inst_name => 'ben_rt_prfl_cache.g_cntng_prtn_prfl_instance'
4181: --
4182: l_proc varchar2(80) := g_package || '.get_rt_prfl_cache';
4183: l_lookup_query long;
4184: l_inst_query long;
4185: l_instcolnm_set ben_cache.instcolnmtype;
4186: --
4187: begin
4188: --
4189: g_pstn_out.delete;
4220: l_instcolnm_set(1).caccol_name := 'position_id';
4221: l_instcolnm_set(2).col_name := 'excld_flag';
4222: l_instcolnm_set(2).caccol_name := 'excld_flag';
4223: --
4224: ben_cache.write_mastDet_Cache
4225: (p_mastercol_name => 'vrbl_rt_prfl_id'
4226: ,p_detailcol_name => 'vrbl_rt_prfl_id'
4227: ,p_lkup_name => 'ben_rt_prfl_cache.g_pstn_lookup'
4228: ,p_inst_name => 'ben_rt_prfl_cache.g_pstn_instance'
4271: --
4272: l_proc varchar2(80) := g_package || '.get_rt_prfl_cache';
4273: l_lookup_query long;
4274: l_inst_query long;
4275: l_instcolnm_set ben_cache.instcolnmtype;
4276: --
4277: begin
4278: --
4279: g_comptncy_out.delete;
4313: l_instcolnm_set(2).caccol_name := 'rating_level_id';
4314: l_instcolnm_set(3).col_name := 'excld_flag';
4315: l_instcolnm_set(3).caccol_name := 'excld_flag';
4316: --
4317: ben_cache.write_mastDet_Cache
4318: (p_mastercol_name => 'vrbl_rt_prfl_id'
4319: ,p_detailcol_name => 'vrbl_rt_prfl_id'
4320: ,p_lkup_name => 'ben_rt_prfl_cache.g_comptncy_lookup'
4321: ,p_inst_name => 'ben_rt_prfl_cache.g_comptncy_instance'
4364: --
4365: l_proc varchar2(80) := g_package || '.get_rt_prfl_cache';
4366: l_lookup_query long;
4367: l_inst_query long;
4368: l_instcolnm_set ben_cache.instcolnmtype;
4369: --
4370: begin
4371: --
4372: g_qual_titl_out.delete;
4406: l_instcolnm_set(2).caccol_name := 'title';
4407: l_instcolnm_set(3).col_name := 'excld_flag';
4408: l_instcolnm_set(3).caccol_name := 'excld_flag';
4409: --
4410: ben_cache.write_mastDet_Cache
4411: (p_mastercol_name => 'vrbl_rt_prfl_id'
4412: ,p_detailcol_name => 'vrbl_rt_prfl_id'
4413: ,p_lkup_name => 'ben_rt_prfl_cache.g_qual_titl_lookup'
4414: ,p_inst_name => 'ben_rt_prfl_cache.g_qual_titl_instance'
4458: --
4459: l_proc varchar2(80) := g_package || '.get_rt_prfl_cache';
4460: l_lookup_query long;
4461: l_inst_query long;
4462: l_instcolnm_set ben_cache.instcolnmtype;
4463: --
4464: begin
4465: --
4466: g_dpnt_cvrd_othr_pl_out.delete;
4500: l_instcolnm_set(2).caccol_name := 'cvg_det_dt_cd';
4501: l_instcolnm_set(3).col_name := 'excld_flag';
4502: l_instcolnm_set(3).caccol_name := 'excld_flag';
4503: --
4504: ben_cache.write_mastDet_Cache
4505: (p_mastercol_name => 'vrbl_rt_prfl_id'
4506: ,p_detailcol_name => 'vrbl_rt_prfl_id'
4507: ,p_lkup_name => 'ben_rt_prfl_cache.g_dpnt_cvrd_othr_pl_lookup'
4508: ,p_inst_name => 'ben_rt_prfl_cache.g_dpnt_cvrd_othr_pl_instance'
4549: --
4550: l_proc varchar2(80) := g_package || '.get_rt_prfl_cache';
4551: l_lookup_query long;
4552: l_inst_query long;
4553: l_instcolnm_set ben_cache.instcolnmtype;
4554: --
4555: begin
4556: --
4557: g_dpnt_cvrd_othr_plip_out.delete;
4591: l_instcolnm_set(2).caccol_name := 'enrl_det_dt_cd';
4592: l_instcolnm_set(3).col_name := 'excld_flag';
4593: l_instcolnm_set(3).caccol_name := 'excld_flag';
4594: --
4595: ben_cache.write_mastDet_Cache
4596: (p_mastercol_name => 'vrbl_rt_prfl_id'
4597: ,p_detailcol_name => 'vrbl_rt_prfl_id'
4598: ,p_lkup_name => 'ben_rt_prfl_cache.g_dpnt_cvrd_othr_plip_lookup'
4599: ,p_inst_name => 'ben_rt_prfl_cache.g_dpnt_cvrd_othr_plip_instance'
4641: --
4642: l_proc varchar2(80) := g_package || '.get_rt_prfl_cache';
4643: l_lookup_query long;
4644: l_inst_query long;
4645: l_instcolnm_set ben_cache.instcolnmtype;
4646: --
4647: begin
4648: --
4649: g_dpnt_cvrd_othr_ptip_out.delete;
4686: l_instcolnm_set(4).col_name := 'only_pls_subj_cobra_flag';
4687: l_instcolnm_set(4).caccol_name := 'only_pls_subj_cobra_flag';
4688:
4689: --
4690: ben_cache.write_mastDet_Cache
4691: (p_mastercol_name => 'vrbl_rt_prfl_id'
4692: ,p_detailcol_name => 'vrbl_rt_prfl_id'
4693: ,p_lkup_name => 'ben_rt_prfl_cache.g_dpnt_cvrd_othr_ptip_lookup'
4694: ,p_inst_name => 'ben_rt_prfl_cache.g_dpnt_cvrd_othr_ptip_instance'
4736: --
4737: l_proc varchar2(80) := g_package || '.get_rt_prfl_cache';
4738: l_lookup_query long;
4739: l_inst_query long;
4740: l_instcolnm_set ben_cache.instcolnmtype;
4741: --
4742: begin
4743: --
4744: g_dpnt_cvrd_othr_pgm_out.delete;
4781: l_instcolnm_set(4).col_name := 'only_pls_subj_cobra_flag';
4782: l_instcolnm_set(4).caccol_name := 'only_pls_subj_cobra_flag';
4783: --
4784: --
4785: ben_cache.write_mastDet_Cache
4786: (p_mastercol_name => 'vrbl_rt_prfl_id'
4787: ,p_detailcol_name => 'vrbl_rt_prfl_id'
4788: ,p_lkup_name => 'ben_rt_prfl_cache.g_dpnt_cvrd_othr_pgm_lookup'
4789: ,p_inst_name => 'ben_rt_prfl_cache.g_dpnt_cvrd_othr_pgm_instance'
4831: --
4832: l_proc varchar2(80) := g_package || '.get_rt_prfl_cache';
4833: l_lookup_query long;
4834: l_inst_query long;
4835: l_instcolnm_set ben_cache.instcolnmtype;
4836: --
4837: begin
4838: --
4839: g_prtt_anthr_pl_out.delete;
4872: l_instcolnm_set(2).col_name := 'excld_flag';
4873: l_instcolnm_set(2).caccol_name := 'excld_flag';
4874: --
4875: --
4876: ben_cache.write_mastDet_Cache
4877: (p_mastercol_name => 'vrbl_rt_prfl_id'
4878: ,p_detailcol_name => 'vrbl_rt_prfl_id'
4879: ,p_lkup_name => 'ben_rt_prfl_cache.g_prtt_anthr_pl_lookup'
4880: ,p_inst_name => 'ben_rt_prfl_cache.g_prtt_anthr_pl_instance'
4922: --
4923: l_proc varchar2(80) := g_package || '.get_rt_prfl_cache';
4924: l_lookup_query long;
4925: l_inst_query long;
4926: l_instcolnm_set ben_cache.instcolnmtype;
4927: --
4928: begin
4929: --
4930: g_othr_ptip_out.delete;
4966: l_instcolnm_set(3).caccol_name := 'only_pls_subj_cobra_flag';
4967:
4968: --
4969: --
4970: ben_cache.write_mastDet_Cache
4971: (p_mastercol_name => 'vrbl_rt_prfl_id'
4972: ,p_detailcol_name => 'vrbl_rt_prfl_id'
4973: ,p_lkup_name => 'ben_rt_prfl_cache.g_othr_ptip_lookup'
4974: ,p_inst_name => 'ben_rt_prfl_cache.g_othr_ptip_instance'
5016: --
5017: l_proc varchar2(80) := g_package || '.get_rt_prfl_cache';
5018: l_lookup_query long;
5019: l_inst_query long;
5020: l_instcolnm_set ben_cache.instcolnmtype;
5021: --
5022: begin
5023: --
5024: g_enrld_anthr_pl_out.delete;
5059: l_instcolnm_set(3).col_name := 'excld_flag';
5060: l_instcolnm_set(3).caccol_name := 'excld_flag';
5061: --
5062: --
5063: ben_cache.write_mastDet_Cache
5064: (p_mastercol_name => 'vrbl_rt_prfl_id'
5065: ,p_detailcol_name => 'vrbl_rt_prfl_id'
5066: ,p_lkup_name => 'ben_rt_prfl_cache.g_enrld_anthr_pl_lookup'
5067: ,p_inst_name => 'ben_rt_prfl_cache.g_enrld_anthr_pl_instance'
5109: --
5110: l_proc varchar2(80) := g_package || '.get_rt_prfl_cache';
5111: l_lookup_query long;
5112: l_inst_query long;
5113: l_instcolnm_set ben_cache.instcolnmtype;
5114: --
5115: begin
5116: --
5117: g_enrld_anthr_oipl_out.delete;
5152: l_instcolnm_set(3).col_name := 'excld_flag';
5153: l_instcolnm_set(3).caccol_name := 'excld_flag';
5154: --
5155: --
5156: ben_cache.write_mastDet_Cache
5157: (p_mastercol_name => 'vrbl_rt_prfl_id'
5158: ,p_detailcol_name => 'vrbl_rt_prfl_id'
5159: ,p_lkup_name => 'ben_rt_prfl_cache.g_enrld_anthr_oipl_lookup'
5160: ,p_inst_name => 'ben_rt_prfl_cache.g_enrld_anthr_oipl_instance'
5202: --
5203: l_proc varchar2(80) := g_package || '.get_rt_prfl_cache';
5204: l_lookup_query long;
5205: l_inst_query long;
5206: l_instcolnm_set ben_cache.instcolnmtype;
5207: --
5208: begin
5209: --
5210: g_enrld_anthr_plip_out.delete;
5245: l_instcolnm_set(3).col_name := 'excld_flag';
5246: l_instcolnm_set(3).caccol_name := 'excld_flag';
5247: --
5248: --
5249: ben_cache.write_mastDet_Cache
5250: (p_mastercol_name => 'vrbl_rt_prfl_id'
5251: ,p_detailcol_name => 'vrbl_rt_prfl_id'
5252: ,p_lkup_name => 'ben_rt_prfl_cache.g_enrld_anthr_plip_lookup'
5253: ,p_inst_name => 'ben_rt_prfl_cache.g_enrld_anthr_plip_instance'
5295: --
5296: l_proc varchar2(80) := g_package || '.get_rt_prfl_cache';
5297: l_lookup_query long;
5298: l_inst_query long;
5299: l_instcolnm_set ben_cache.instcolnmtype;
5300: --
5301: begin
5302: --
5303: g_enrld_anthr_ptip_out.delete;
5341: l_instcolnm_set(4).caccol_name := 'only_pls_subj_cobra_flag';
5342:
5343: --
5344: --
5345: ben_cache.write_mastDet_Cache
5346: (p_mastercol_name => 'vrbl_rt_prfl_id'
5347: ,p_detailcol_name => 'vrbl_rt_prfl_id'
5348: ,p_lkup_name => 'ben_rt_prfl_cache.g_enrld_anthr_ptip_lookup'
5349: ,p_inst_name => 'ben_rt_prfl_cache.g_enrld_anthr_ptip_instance'
5391: --
5392: l_proc varchar2(80) := g_package || '.get_rt_prfl_cache';
5393: l_lookup_query long;
5394: l_inst_query long;
5395: l_instcolnm_set ben_cache.instcolnmtype;
5396: --
5397: begin
5398: --
5399: g_enrld_anthr_pgm_out.delete;
5435: l_instcolnm_set(3).caccol_name := 'excld_flag';
5436:
5437: --
5438: --
5439: ben_cache.write_mastDet_Cache
5440: (p_mastercol_name => 'vrbl_rt_prfl_id'
5441: ,p_detailcol_name => 'vrbl_rt_prfl_id'
5442: ,p_lkup_name => 'ben_rt_prfl_cache.g_enrld_anthr_pgm_lookup'
5443: ,p_inst_name => 'ben_rt_prfl_cache.g_enrld_anthr_pgm_instance'
5485: --
5486: l_proc varchar2(80) := g_package || '.get_rt_prfl_cache';
5487: l_lookup_query long;
5488: l_inst_query long;
5489: l_instcolnm_set ben_cache.instcolnmtype;
5490: --
5491: begin
5492: --
5493: g_dpnt_othr_ptip_out.delete;
5527: l_instcolnm_set(2).caccol_name := 'excld_flag';
5528:
5529: --
5530: --
5531: ben_cache.write_mastDet_Cache
5532: (p_mastercol_name => 'vrbl_rt_prfl_id'
5533: ,p_detailcol_name => 'vrbl_rt_prfl_id'
5534: ,p_lkup_name => 'ben_rt_prfl_cache.g_dpnt_othr_ptip_lookup'
5535: ,p_inst_name => 'ben_rt_prfl_cache.g_dpnt_othr_ptip_instance'
5576: --
5577: l_proc varchar2(80) := g_package || '.get_rt_prfl_cache';
5578: l_lookup_query long;
5579: l_inst_query long;
5580: l_instcolnm_set ben_cache.instcolnmtype;
5581: --
5582: begin
5583: --
5584: g_no_othr_cvg_out.delete;
5614: l_instcolnm_set(1).col_name := 'coord_ben_no_cvg_flag';
5615: l_instcolnm_set(1).caccol_name := 'coord_ben_no_cvg_flag';
5616: --
5617: --
5618: ben_cache.write_mastDet_Cache
5619: (p_mastercol_name => 'vrbl_rt_prfl_id'
5620: ,p_detailcol_name => 'vrbl_rt_prfl_id'
5621: ,p_lkup_name => 'ben_rt_prfl_cache.g_no_othr_cvg_lookup'
5622: ,p_inst_name => 'ben_rt_prfl_cache.g_no_othr_cvg_instance'
5664: --
5665: l_proc varchar2(80) := g_package || '.get_rt_prfl_cache';
5666: l_lookup_query long;
5667: l_inst_query long;
5668: l_instcolnm_set ben_cache.instcolnmtype;
5669: --
5670: begin
5671: --
5672: g_qua_in_gr_out.delete;
5703: l_instcolnm_set(1).caccol_name := 'quar_in_grade_cd';
5704: l_instcolnm_set(2).col_name := 'excld_flag';
5705: l_instcolnm_set(2).caccol_name := 'excld_flag';
5706: --
5707: ben_cache.write_mastDet_Cache
5708: (p_mastercol_name => 'vrbl_rt_prfl_id'
5709: ,p_detailcol_name => 'vrbl_rt_prfl_id'
5710: ,p_lkup_name => 'ben_rt_prfl_cache.g_qua_in_gr_lookup'
5711: ,p_inst_name => 'ben_rt_prfl_cache.g_qua_in_gr_instance'
5753: --
5754: l_proc varchar2(80) := g_package || '.get_rt_prfl_cache';
5755: l_lookup_query long;
5756: l_inst_query long;
5757: l_instcolnm_set ben_cache.instcolnmtype;
5758: --
5759: begin
5760: --
5761: g_perf_rtng_out.delete;
5795: l_instcolnm_set(2).caccol_name := 'event_type';
5796: l_instcolnm_set(3).col_name := 'excld_flag';
5797: l_instcolnm_set(3).caccol_name := 'excld_flag';
5798: --
5799: ben_cache.write_mastDet_Cache
5800: (p_mastercol_name => 'vrbl_rt_prfl_id'
5801: ,p_detailcol_name => 'vrbl_rt_prfl_id'
5802: ,p_lkup_name => 'ben_rt_prfl_cache.g_perf_rtng_lookup'
5803: ,p_inst_name => 'ben_rt_prfl_cache.g_perf_rtng_instance'