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

Line 1: Package Body ben_plan_design_program_module as

1: Package Body ben_plan_design_program_module as
2: /* $Header: bepdcpgm.pkb 120.8.12020000.2 2012/07/03 13:04:10 amnaraya ship $ */
3: --
4: -- Package Variables
5: --

Line 6: g_package varchar2(33) := ' ben_plan_design_program_module.';

2: /* $Header: bepdcpgm.pkb 120.8.12020000.2 2012/07/03 13:04:10 amnaraya ship $ */
3: --
4: -- Package Variables
5: --
6: g_package varchar2(33) := ' ben_plan_design_program_module.';
7: --
8: -- This procedure is used to create a row for each of the comp objects
9: -- selected by the end user on search page into
10: -- pqh_copy_entity_txn table.

Line 897: if p_no_dup_rslt = ben_plan_design_program_module.g_pdw_no_dup_rslt then

893: --
894: --
895: l_number_of_copies := p_number_of_copies ;
896:
897: if p_no_dup_rslt = ben_plan_design_program_module.g_pdw_no_dup_rslt then
898: ben_plan_design_program_module.g_pdw_allow_dup_rslt := ben_plan_design_program_module.g_pdw_no_dup_rslt;
899: else
900: ben_plan_design_program_module.g_pdw_allow_dup_rslt := NULL;
901: end if;

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

894: --
895: l_number_of_copies := p_number_of_copies ;
896:
897: if p_no_dup_rslt = ben_plan_design_program_module.g_pdw_no_dup_rslt then
898: ben_plan_design_program_module.g_pdw_allow_dup_rslt := ben_plan_design_program_module.g_pdw_no_dup_rslt;
899: else
900: ben_plan_design_program_module.g_pdw_allow_dup_rslt := NULL;
901: end if;
902:

Line 900: ben_plan_design_program_module.g_pdw_allow_dup_rslt := NULL;

896:
897: if p_no_dup_rslt = ben_plan_design_program_module.g_pdw_no_dup_rslt then
898: ben_plan_design_program_module.g_pdw_allow_dup_rslt := ben_plan_design_program_module.g_pdw_no_dup_rslt;
899: else
900: ben_plan_design_program_module.g_pdw_allow_dup_rslt := NULL;
901: end if;
902:
903: if ben_plan_design_program_module.g_pdw_allow_dup_rslt = ben_plan_design_program_module.g_pdw_no_dup_rslt then
904: open c_object_exists(p_pgm_id,'PGM');

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

899: else
900: ben_plan_design_program_module.g_pdw_allow_dup_rslt := NULL;
901: end if;
902:
903: if ben_plan_design_program_module.g_pdw_allow_dup_rslt = ben_plan_design_program_module.g_pdw_no_dup_rslt then
904: open c_object_exists(p_pgm_id,'PGM');
905: fetch c_object_exists into l_dummy;
906: if c_object_exists%found then
907: close c_object_exists;

Line 1095: ben_plan_design_program_module.create_formula_result

1091: ---------------------------------------------------------------
1092:
1093: if to_char(l_pgm_rec.salary_calc_mthd_rl) is not null then
1094: --
1095: ben_plan_design_program_module.create_formula_result
1096: (
1097: p_validate => 0
1098: ,p_copy_entity_result_id => l_copy_entity_result_id
1099: ,p_copy_entity_txn_id => p_copy_entity_txn_id

Line 1116: ben_plan_design_program_module.create_formula_result

1112: ---------------------------------------------------------------
1113:
1114: if to_char(l_pgm_rec.Dflt_step_rl) is not null then
1115: --
1116: ben_plan_design_program_module.create_formula_result
1117: (
1118: p_validate => 0
1119: ,p_copy_entity_result_id => l_copy_entity_result_id
1120: ,p_copy_entity_txn_id => p_copy_entity_txn_id

Line 1137: ben_plan_design_program_module.create_formula_result

1133: ---------------------------------------------------------------
1134:
1135: if to_char(l_pgm_rec.Scores_calc_rl) is not null then
1136: --
1137: ben_plan_design_program_module.create_formula_result
1138: (
1139: p_validate => 0
1140: ,p_copy_entity_result_id => l_copy_entity_result_id
1141: ,p_copy_entity_txn_id => p_copy_entity_txn_id

Line 1158: ben_plan_design_program_module.create_formula_result

1154: ---------------------------------------------------------------
1155:
1156: if to_char(l_pgm_rec.auto_enrt_mthd_rl) is not null then
1157: --
1158: ben_plan_design_program_module.create_formula_result
1159: (
1160: p_validate => 0
1161: ,p_copy_entity_result_id => l_copy_entity_result_id
1162: ,p_copy_entity_txn_id => p_copy_entity_txn_id

Line 1179: ben_plan_design_program_module.create_formula_result

1175: ---------------------------------------------------------------
1176:
1177: if to_char(l_pgm_rec.dpnt_cvg_end_dt_rl) is not null then
1178: --
1179: ben_plan_design_program_module.create_formula_result
1180: (
1181: p_validate => 0
1182: ,p_copy_entity_result_id => l_copy_entity_result_id
1183: ,p_copy_entity_txn_id => p_copy_entity_txn_id

Line 1200: ben_plan_design_program_module.create_formula_result

1196: ---------------------------------------------------------------
1197:
1198: if to_char(l_pgm_rec.dpnt_cvg_strt_dt_rl) is not null then
1199: --
1200: ben_plan_design_program_module.create_formula_result
1201: (
1202: p_validate => 0
1203: ,p_copy_entity_result_id => l_copy_entity_result_id
1204: ,p_copy_entity_txn_id => p_copy_entity_txn_id

Line 1221: ben_plan_design_program_module.create_formula_result

1217: ---------------------------------------------------------------
1218:
1219: if to_char(l_pgm_rec.enrt_cvg_end_dt_rl) is not null then
1220: --
1221: ben_plan_design_program_module.create_formula_result
1222: (
1223: p_validate => 0
1224: ,p_copy_entity_result_id => l_copy_entity_result_id
1225: ,p_copy_entity_txn_id => p_copy_entity_txn_id

Line 1242: ben_plan_design_program_module.create_formula_result

1238: ---------------------------------------------------------------
1239:
1240: if to_char(l_pgm_rec.enrt_cvg_strt_dt_rl) is not null then
1241: --
1242: ben_plan_design_program_module.create_formula_result
1243: (
1244: p_validate => 0
1245: ,p_copy_entity_result_id => l_copy_entity_result_id
1246: ,p_copy_entity_txn_id => p_copy_entity_txn_id

Line 1263: ben_plan_design_program_module.create_formula_result

1259: ---------------------------------------------------------------
1260:
1261: if to_char(l_pgm_rec.enrt_rl) is not null then
1262: --
1263: ben_plan_design_program_module.create_formula_result
1264: (
1265: p_validate => 0
1266: ,p_copy_entity_result_id => l_copy_entity_result_id
1267: ,p_copy_entity_txn_id => p_copy_entity_txn_id

Line 1284: ben_plan_design_program_module.create_formula_result

1280: ---------------------------------------------------------------
1281:
1282: if to_char(l_pgm_rec.rt_end_dt_rl) is not null then
1283: --
1284: ben_plan_design_program_module.create_formula_result
1285: (
1286: p_validate => 0
1287: ,p_copy_entity_result_id => l_copy_entity_result_id
1288: ,p_copy_entity_txn_id => p_copy_entity_txn_id

Line 1305: ben_plan_design_program_module.create_formula_result

1301: ---------------------------------------------------------------
1302:
1303: if to_char(l_pgm_rec.rt_strt_dt_rl) is not null then
1304: --
1305: ben_plan_design_program_module.create_formula_result
1306: (
1307: p_validate => 0
1308: ,p_copy_entity_result_id => l_copy_entity_result_id
1309: ,p_copy_entity_txn_id => p_copy_entity_txn_id

Line 1326: ben_plan_design_program_module.create_formula_result

1322: ---------------------------------------------------------------
1323:
1324: if to_char(l_pgm_rec.vrfy_fmly_mmbr_rl) is not null then
1325: --
1326: ben_plan_design_program_module.create_formula_result
1327: (
1328: p_validate => 0
1329: ,p_copy_entity_result_id => l_copy_entity_result_id
1330: ,p_copy_entity_txn_id => p_copy_entity_txn_id

Line 1581: ben_plan_design_program_module.create_formula_result(

1577:
1578:
1579: --Start Bug 6162249
1580: if (l_ldc_rec.cvg_eff_end_rl is not null) then
1581: ben_plan_design_program_module.create_formula_result(
1582: p_validate => p_validate
1583: ,p_copy_entity_result_id => l_copy_entity_result_id
1584: ,p_copy_entity_txn_id => p_copy_entity_txn_id
1585: ,p_formula_id => l_ldc_rec.cvg_eff_end_rl

Line 1593: ben_plan_design_program_module.create_formula_result(

1589: ,p_effective_date => p_effective_date);
1590: end if;
1591:
1592: if (l_ldc_rec.cvg_eff_strt_rl is not null) then
1593: ben_plan_design_program_module.create_formula_result(
1594: p_validate => p_validate
1595: ,p_copy_entity_result_id => l_copy_entity_result_id
1596: ,p_copy_entity_txn_id => p_copy_entity_txn_id
1597: ,p_formula_id => l_ldc_rec.cvg_eff_strt_rl

Line 1605: ben_plan_design_program_module.create_formula_result(

1601: ,p_effective_date => p_effective_date);
1602: end if;
1603:
1604: if (l_ldc_rec.ler_chg_dpnt_cvg_rl is not null) then
1605: ben_plan_design_program_module.create_formula_result(
1606: p_validate => p_validate
1607: ,p_copy_entity_result_id => l_copy_entity_result_id
1608: ,p_copy_entity_txn_id => p_copy_entity_txn_id
1609: ,p_formula_id => l_ldc_rec.ler_chg_dpnt_cvg_rl

Line 1738: ben_plan_design_program_module.create_formula_result

1734: ---------------------------------------------------------------
1735:
1736: if to_char(l_lcc_rec.ctfn_rqd_when_rl) is not null then
1737: --
1738: ben_plan_design_program_module.create_formula_result
1739: (
1740: p_validate => 0
1741: ,p_copy_entity_result_id => l_copy_entity_result_id
1742: ,p_copy_entity_txn_id => p_copy_entity_txn_id

Line 1872: ben_plan_design_program_module.create_formula_result

1868: ---------------------------------------------------------------
1869:
1870: if to_char(l_lge_rec.auto_enrt_mthd_rl) is not null then
1871: --
1872: ben_plan_design_program_module.create_formula_result
1873: (
1874: p_validate => 0
1875: ,p_copy_entity_result_id => l_copy_entity_result_id
1876: ,p_copy_entity_txn_id => p_copy_entity_txn_id

Line 1892: ben_plan_design_program_module.create_formula_result

1888: ---------------------------------------------------------------
1889:
1890: if to_char(l_lge_rec.dflt_enrt_rl) is not null then
1891: --
1892: ben_plan_design_program_module.create_formula_result
1893: (
1894: p_validate => 0
1895: ,p_copy_entity_result_id => l_copy_entity_result_id
1896: ,p_copy_entity_txn_id => p_copy_entity_txn_id

Line 1913: ben_plan_design_program_module.create_formula_result

1909: ---------------------------------------------------------------
1910:
1911: if to_char(l_lge_rec.enrt_rl) is not null then
1912: --
1913: ben_plan_design_program_module.create_formula_result
1914: (
1915: p_validate => 0
1916: ,p_copy_entity_result_id => l_copy_entity_result_id
1917: ,p_copy_entity_txn_id => p_copy_entity_txn_id

Line 2070: ben_plan_design_program_module.create_formula_result

2066: ---------------------------------------------------------------
2067:
2068: if to_char(l_peo_rec.mx_poe_det_dt_rl) is not null then
2069: --
2070: ben_plan_design_program_module.create_formula_result
2071: (
2072: p_validate => 0
2073: ,p_copy_entity_result_id => l_copy_entity_result_id
2074: ,p_copy_entity_txn_id => p_copy_entity_txn_id

Line 2091: ben_plan_design_program_module.create_formula_result

2087: ---------------------------------------------------------------
2088:
2089: if to_char(l_peo_rec.mx_poe_rl) is not null then
2090: --
2091: ben_plan_design_program_module.create_formula_result
2092: (
2093: p_validate => 0
2094: ,p_copy_entity_result_id => l_copy_entity_result_id
2095: ,p_copy_entity_txn_id => p_copy_entity_txn_id

Line 2112: ben_plan_design_program_module.create_formula_result

2108: ---------------------------------------------------------------
2109:
2110: if to_char(l_peo_rec.prtn_eff_end_dt_rl) is not null then
2111: --
2112: ben_plan_design_program_module.create_formula_result
2113: (
2114: p_validate => 0
2115: ,p_copy_entity_result_id => l_copy_entity_result_id
2116: ,p_copy_entity_txn_id => p_copy_entity_txn_id

Line 2133: ben_plan_design_program_module.create_formula_result

2129: ---------------------------------------------------------------
2130:
2131: if to_char(l_peo_rec.prtn_eff_strt_dt_rl) is not null then
2132: --
2133: ben_plan_design_program_module.create_formula_result
2134: (
2135: p_validate => 0
2136: ,p_copy_entity_result_id => l_copy_entity_result_id
2137: ,p_copy_entity_txn_id => p_copy_entity_txn_id

Line 2154: ben_plan_design_program_module.create_formula_result

2150: ---------------------------------------------------------------
2151:
2152: if to_char(l_peo_rec.vrfy_fmly_mmbr_rl) is not null then
2153: --
2154: ben_plan_design_program_module.create_formula_result
2155: (
2156: p_validate => 0
2157: ,p_copy_entity_result_id => l_copy_entity_result_id
2158: ,p_copy_entity_txn_id => p_copy_entity_txn_id

Line 2175: ben_plan_design_program_module.create_formula_result

2171: ---------------------------------------------------------------
2172:
2173: if to_char(l_peo_rec.wait_perd_dt_to_use_rl) is not null then
2174: --
2175: ben_plan_design_program_module.create_formula_result
2176: (
2177: p_validate => 0
2178: ,p_copy_entity_result_id => l_copy_entity_result_id
2179: ,p_copy_entity_txn_id => p_copy_entity_txn_id

Line 2196: ben_plan_design_program_module.create_formula_result

2192: ---------------------------------------------------------------
2193:
2194: if to_char(l_peo_rec.wait_perd_rl) is not null then
2195: --
2196: ben_plan_design_program_module.create_formula_result
2197: (
2198: p_validate => 0
2199: ,p_copy_entity_result_id => l_copy_entity_result_id
2200: ,p_copy_entity_txn_id => p_copy_entity_txn_id

Line 2331: ben_plan_design_program_module.create_formula_result

2327: ---------------------------------------------------------------
2328:
2329: if to_char(l_pgc_rec.ctfn_rqd_when_rl) is not null then
2330: --
2331: ben_plan_design_program_module.create_formula_result
2332: (
2333: p_validate => 0
2334: ,p_copy_entity_result_id => l_copy_entity_result_id
2335: ,p_copy_entity_txn_id => p_copy_entity_txn_id

Line 2513: ben_plan_design_program_module.create_formula_result

2509: ---------------------------------------------------------------
2510:
2511: if to_char(l_ctp_rec.auto_enrt_mthd_rl) is not null then
2512: --
2513: ben_plan_design_program_module.create_formula_result
2514: (
2515: p_validate => 0
2516: ,p_copy_entity_result_id => l_copy_entity_result_id
2517: ,p_copy_entity_txn_id => p_copy_entity_txn_id

Line 2534: ben_plan_design_program_module.create_formula_result

2530: ---------------------------------------------------------------
2531:
2532: if to_char(l_ctp_rec.dflt_enrt_det_rl) is not null then
2533: --
2534: ben_plan_design_program_module.create_formula_result
2535: (
2536: p_validate => 0
2537: ,p_copy_entity_result_id => l_copy_entity_result_id
2538: ,p_copy_entity_txn_id => p_copy_entity_txn_id

Line 2555: ben_plan_design_program_module.create_formula_result

2551: ---------------------------------------------------------------
2552:
2553: if to_char(l_ctp_rec.dpnt_cvg_end_dt_rl) is not null then
2554: --
2555: ben_plan_design_program_module.create_formula_result
2556: (
2557: p_validate => 0
2558: ,p_copy_entity_result_id => l_copy_entity_result_id
2559: ,p_copy_entity_txn_id => p_copy_entity_txn_id

Line 2576: ben_plan_design_program_module.create_formula_result

2572: ---------------------------------------------------------------
2573:
2574: if to_char(l_ctp_rec.dpnt_cvg_strt_dt_rl) is not null then
2575: --
2576: ben_plan_design_program_module.create_formula_result
2577: (
2578: p_validate => 0
2579: ,p_copy_entity_result_id => l_copy_entity_result_id
2580: ,p_copy_entity_txn_id => p_copy_entity_txn_id

Line 2597: ben_plan_design_program_module.create_formula_result

2593: ---------------------------------------------------------------
2594:
2595: if to_char(l_ctp_rec.enrt_cvg_end_dt_rl) is not null then
2596: --
2597: ben_plan_design_program_module.create_formula_result
2598: (
2599: p_validate => 0
2600: ,p_copy_entity_result_id => l_copy_entity_result_id
2601: ,p_copy_entity_txn_id => p_copy_entity_txn_id

Line 2618: ben_plan_design_program_module.create_formula_result

2614: ---------------------------------------------------------------
2615:
2616: if to_char(l_ctp_rec.enrt_cvg_strt_dt_rl) is not null then
2617: --
2618: ben_plan_design_program_module.create_formula_result
2619: (
2620: p_validate => 0
2621: ,p_copy_entity_result_id => l_copy_entity_result_id
2622: ,p_copy_entity_txn_id => p_copy_entity_txn_id

Line 2639: ben_plan_design_program_module.create_formula_result

2635: ---------------------------------------------------------------
2636:
2637: if to_char(l_ctp_rec.enrt_rl) is not null then
2638: --
2639: ben_plan_design_program_module.create_formula_result
2640: (
2641: p_validate => 0
2642: ,p_copy_entity_result_id => l_copy_entity_result_id
2643: ,p_copy_entity_txn_id => p_copy_entity_txn_id

Line 2660: ben_plan_design_program_module.create_formula_result

2656: ---------------------------------------------------------------
2657:
2658: if to_char(l_ctp_rec.postelcn_edit_rl) is not null then
2659: --
2660: ben_plan_design_program_module.create_formula_result
2661: (
2662: p_validate => 0
2663: ,p_copy_entity_result_id => l_copy_entity_result_id
2664: ,p_copy_entity_txn_id => p_copy_entity_txn_id

Line 2681: ben_plan_design_program_module.create_formula_result

2677: ---------------------------------------------------------------
2678:
2679: if to_char(l_ctp_rec.rqd_perd_enrt_nenrt_rl) is not null then
2680: --
2681: ben_plan_design_program_module.create_formula_result
2682: (
2683: p_validate => 0
2684: ,p_copy_entity_result_id => l_copy_entity_result_id
2685: ,p_copy_entity_txn_id => p_copy_entity_txn_id

Line 2701: ben_plan_design_program_module.create_formula_result

2697: ---------------------------------------------------------------
2698:
2699: if to_char(l_ctp_rec.rt_end_dt_rl) is not null then
2700: --
2701: ben_plan_design_program_module.create_formula_result
2702: (
2703: p_validate => 0
2704: ,p_copy_entity_result_id => l_copy_entity_result_id
2705: ,p_copy_entity_txn_id => p_copy_entity_txn_id

Line 2722: ben_plan_design_program_module.create_formula_result

2718: ---------------------------------------------------------------
2719:
2720: if to_char(l_ctp_rec.rt_strt_dt_rl) is not null then
2721: --
2722: ben_plan_design_program_module.create_formula_result
2723: (
2724: p_validate => 0
2725: ,p_copy_entity_result_id => l_copy_entity_result_id
2726: ,p_copy_entity_txn_id => p_copy_entity_txn_id

Line 2743: ben_plan_design_program_module.create_formula_result

2739: ---------------------------------------------------------------
2740:
2741: if to_char(l_ctp_rec.vrfy_fmly_mmbr_rl) is not null then
2742: --
2743: ben_plan_design_program_module.create_formula_result
2744: (
2745: p_validate => 0
2746: ,p_copy_entity_result_id => l_copy_entity_result_id
2747: ,p_copy_entity_txn_id => p_copy_entity_txn_id

Line 2981: ben_plan_design_program_module.create_formula_result

2977: ---------------------------------------------------------------
2978:
2979: if to_char(l_peo_rec.mx_poe_det_dt_rl) is not null then
2980: --
2981: ben_plan_design_program_module.create_formula_result
2982: (
2983: p_validate => 0
2984: ,p_copy_entity_result_id => l_copy_entity_result_id
2985: ,p_copy_entity_txn_id => p_copy_entity_txn_id

Line 3002: ben_plan_design_program_module.create_formula_result

2998: ---------------------------------------------------------------
2999:
3000: if to_char(l_peo_rec.mx_poe_rl) is not null then
3001: --
3002: ben_plan_design_program_module.create_formula_result
3003: (
3004: p_validate => 0
3005: ,p_copy_entity_result_id => l_copy_entity_result_id
3006: ,p_copy_entity_txn_id => p_copy_entity_txn_id

Line 3022: ben_plan_design_program_module.create_formula_result

3018: ---------------------------------------------------------------
3019:
3020: if to_char(l_peo_rec.prtn_eff_end_dt_rl) is not null then
3021: --
3022: ben_plan_design_program_module.create_formula_result
3023: (
3024: p_validate => 0
3025: ,p_copy_entity_result_id => l_copy_entity_result_id
3026: ,p_copy_entity_txn_id => p_copy_entity_txn_id

Line 3042: ben_plan_design_program_module.create_formula_result

3038: ---------------------------------------------------------------
3039:
3040: if to_char(l_peo_rec.prtn_eff_strt_dt_rl) is not null then
3041: --
3042: ben_plan_design_program_module.create_formula_result
3043: (
3044: p_validate => 0
3045: ,p_copy_entity_result_id => l_copy_entity_result_id
3046: ,p_copy_entity_txn_id => p_copy_entity_txn_id

Line 3062: ben_plan_design_program_module.create_formula_result

3058: ---------------------------------------------------------------
3059:
3060: if to_char(l_peo_rec.vrfy_fmly_mmbr_rl) is not null then
3061: --
3062: ben_plan_design_program_module.create_formula_result
3063: (
3064: p_validate => 0
3065: ,p_copy_entity_result_id => l_copy_entity_result_id
3066: ,p_copy_entity_txn_id => p_copy_entity_txn_id

Line 3082: ben_plan_design_program_module.create_formula_result

3078: ---------------------------------------------------------------
3079:
3080: if to_char(l_peo_rec.wait_perd_dt_to_use_rl) is not null then
3081: --
3082: ben_plan_design_program_module.create_formula_result
3083: (
3084: p_validate => 0
3085: ,p_copy_entity_result_id => l_copy_entity_result_id
3086: ,p_copy_entity_txn_id => p_copy_entity_txn_id

Line 3102: ben_plan_design_program_module.create_formula_result

3098: ---------------------------------------------------------------
3099:
3100: if to_char(l_peo_rec.wait_perd_rl) is not null then
3101: --
3102: ben_plan_design_program_module.create_formula_result
3103: (
3104: p_validate => 0
3105: ,p_copy_entity_result_id => l_copy_entity_result_id
3106: ,p_copy_entity_txn_id => p_copy_entity_txn_id

Line 3240: ben_plan_design_program_module.create_formula_result

3236: ---------------------------------------------------------------
3237:
3238: if to_char(l_ldc_rec.cvg_eff_end_rl) is not null then
3239: --
3240: ben_plan_design_program_module.create_formula_result
3241: (
3242: p_validate => 0
3243: ,p_copy_entity_result_id => l_copy_entity_result_id
3244: ,p_copy_entity_txn_id => p_copy_entity_txn_id

Line 3261: ben_plan_design_program_module.create_formula_result

3257: ---------------------------------------------------------------
3258:
3259: if to_char(l_ldc_rec.cvg_eff_strt_rl) is not null then
3260: --
3261: ben_plan_design_program_module.create_formula_result
3262: (
3263: p_validate => 0
3264: ,p_copy_entity_result_id => l_copy_entity_result_id
3265: ,p_copy_entity_txn_id => p_copy_entity_txn_id

Line 3282: ben_plan_design_program_module.create_formula_result

3278: ---------------------------------------------------------------
3279:
3280: if to_char(l_ldc_rec.ler_chg_dpnt_cvg_rl) is not null then
3281: --
3282: ben_plan_design_program_module.create_formula_result
3283: (
3284: p_validate => 0
3285: ,p_copy_entity_result_id => l_copy_entity_result_id
3286: ,p_copy_entity_txn_id => p_copy_entity_txn_id

Line 3523: ben_plan_design_program_module.create_formula_result

3519: ---------------------------------------------------------------
3520:
3521: if l_lct_rec.dflt_enrt_rl is not null then
3522: --
3523: ben_plan_design_program_module.create_formula_result
3524: (
3525: p_validate => 0
3526: ,p_copy_entity_result_id => l_copy_entity_result_id
3527: ,p_copy_entity_txn_id => p_copy_entity_txn_id

Line 3544: ben_plan_design_program_module.create_formula_result

3540: ---------------------------------------------------------------
3541:
3542: if l_lct_rec.enrt_rl is not null then
3543: --
3544: ben_plan_design_program_module.create_formula_result
3545: (
3546: p_validate => 0
3547: ,p_copy_entity_result_id => l_copy_entity_result_id
3548: ,p_copy_entity_txn_id => p_copy_entity_txn_id

Line 3681: ben_plan_design_program_module.create_formula_result

3677: ---------------------------------------------------------------
3678:
3679: if to_char(l_pyd_rec.ctfn_rqd_when_rl) is not null then
3680: --
3681: ben_plan_design_program_module.create_formula_result
3682: (
3683: p_validate => 0
3684: ,p_copy_entity_result_id => l_copy_entity_result_id
3685: ,p_copy_entity_txn_id => p_copy_entity_txn_id

Line 3899: ben_plan_design_program_module.create_formula_result

3895: ---------------------------------------------------------------
3896:
3897: if to_char(l_wct_rec.ctfn_rqd_when_rl) is not null then
3898: --
3899: ben_plan_design_program_module.create_formula_result
3900: (
3901: p_validate => 0
3902: ,p_copy_entity_result_id => l_copy_entity_result_id
3903: ,p_copy_entity_txn_id => p_copy_entity_txn_id

Line 4082: ben_plan_design_program_module.create_formula_result

4078: ---------------------------------------------------------------
4079:
4080: if to_char(l_cpp_rec.auto_enrt_mthd_rl) is not null then
4081: --
4082: ben_plan_design_program_module.create_formula_result
4083: (
4084: p_validate => 0
4085: ,p_copy_entity_result_id => l_copy_entity_result_id
4086: ,p_copy_entity_txn_id => p_copy_entity_txn_id

Line 4104: ben_plan_design_program_module.create_formula_result

4100: ---------------------------------------------------------------
4101:
4102: if to_char(l_cpp_rec.dflt_enrt_det_rl) is not null then
4103: --
4104: ben_plan_design_program_module.create_formula_result
4105: (
4106: p_validate => 0
4107: ,p_copy_entity_result_id => l_copy_entity_result_id
4108: ,p_copy_entity_txn_id => p_copy_entity_txn_id

Line 4125: ben_plan_design_program_module.create_formula_result

4121: ---------------------------------------------------------------
4122:
4123: if to_char(l_cpp_rec.dflt_to_asn_pndg_ctfn_rl) is not null then
4124: --
4125: ben_plan_design_program_module.create_formula_result
4126: (
4127: p_validate => 0
4128: ,p_copy_entity_result_id => l_copy_entity_result_id
4129: ,p_copy_entity_txn_id => p_copy_entity_txn_id

Line 4146: ben_plan_design_program_module.create_formula_result

4142: ---------------------------------------------------------------
4143:
4144: if to_char(l_cpp_rec.enrt_cvg_end_dt_rl) is not null then
4145: --
4146: ben_plan_design_program_module.create_formula_result
4147: (
4148: p_validate => 0
4149: ,p_copy_entity_result_id => l_copy_entity_result_id
4150: ,p_copy_entity_txn_id => p_copy_entity_txn_id

Line 4167: ben_plan_design_program_module.create_formula_result

4163: ---------------------------------------------------------------
4164:
4165: if to_char(l_cpp_rec.enrt_cvg_strt_dt_rl) is not null then
4166: --
4167: ben_plan_design_program_module.create_formula_result
4168: (
4169: p_validate => 0
4170: ,p_copy_entity_result_id => l_copy_entity_result_id
4171: ,p_copy_entity_txn_id => p_copy_entity_txn_id

Line 4188: ben_plan_design_program_module.create_formula_result

4184: ---------------------------------------------------------------
4185:
4186: if to_char(l_cpp_rec.enrt_rl) is not null then
4187: --
4188: ben_plan_design_program_module.create_formula_result
4189: (
4190: p_validate => 0
4191: ,p_copy_entity_result_id => l_copy_entity_result_id
4192: ,p_copy_entity_txn_id => p_copy_entity_txn_id

Line 4209: ben_plan_design_program_module.create_formula_result

4205: ---------------------------------------------------------------
4206:
4207: if to_char(l_cpp_rec.mn_cvg_rl) is not null then
4208: --
4209: ben_plan_design_program_module.create_formula_result
4210: (
4211: p_validate => 0
4212: ,p_copy_entity_result_id => l_copy_entity_result_id
4213: ,p_copy_entity_txn_id => p_copy_entity_txn_id

Line 4230: ben_plan_design_program_module.create_formula_result

4226: ---------------------------------------------------------------
4227:
4228: if to_char(l_cpp_rec.mx_cvg_rl) is not null then
4229: --
4230: ben_plan_design_program_module.create_formula_result
4231: (
4232: p_validate => 0
4233: ,p_copy_entity_result_id => l_copy_entity_result_id
4234: ,p_copy_entity_txn_id => p_copy_entity_txn_id

Line 4252: ben_plan_design_program_module.create_formula_result

4248: ---------------------------------------------------------------
4249:
4250: if to_char(l_cpp_rec.postelcn_edit_rl) is not null then
4251: --
4252: ben_plan_design_program_module.create_formula_result
4253: (
4254: p_validate => 0
4255: ,p_copy_entity_result_id => l_copy_entity_result_id
4256: ,p_copy_entity_txn_id => p_copy_entity_txn_id

Line 4273: ben_plan_design_program_module.create_formula_result

4269: ---------------------------------------------------------------
4270:
4271: if to_char(l_cpp_rec.prort_prtl_yr_cvg_rstrn_rl) is not null then
4272: --
4273: ben_plan_design_program_module.create_formula_result
4274: (
4275: p_validate => 0
4276: ,p_copy_entity_result_id => l_copy_entity_result_id
4277: ,p_copy_entity_txn_id => p_copy_entity_txn_id

Line 4294: ben_plan_design_program_module.create_formula_result

4290: ---------------------------------------------------------------
4291:
4292: if to_char(l_cpp_rec.rt_end_dt_rl) is not null then
4293: --
4294: ben_plan_design_program_module.create_formula_result
4295: (
4296: p_validate => 0
4297: ,p_copy_entity_result_id => l_copy_entity_result_id
4298: ,p_copy_entity_txn_id => p_copy_entity_txn_id

Line 4315: ben_plan_design_program_module.create_formula_result

4311: ---------------------------------------------------------------
4312:
4313: if to_char(l_cpp_rec.rt_strt_dt_rl) is not null then
4314: --
4315: ben_plan_design_program_module.create_formula_result
4316: (
4317: p_validate => 0
4318: ,p_copy_entity_result_id => l_copy_entity_result_id
4319: ,p_copy_entity_txn_id => p_copy_entity_txn_id

Line 4336: ben_plan_design_program_module.create_formula_result

4332: ---------------------------------------------------------------
4333:
4334: if to_char(l_cpp_rec.vrfy_fmly_mmbr_rl) is not null then
4335: --
4336: ben_plan_design_program_module.create_formula_result
4337: (
4338: p_validate => 0
4339: ,p_copy_entity_result_id => l_copy_entity_result_id
4340: ,p_copy_entity_txn_id => p_copy_entity_txn_id

Line 4562: ben_plan_design_program_module.create_formula_result

4558: ---------------------------------------------------------------
4559:
4560: if to_char(l_peo_rec.mx_poe_det_dt_rl) is not null then
4561: --
4562: ben_plan_design_program_module.create_formula_result
4563: (
4564: p_validate => 0
4565: ,p_copy_entity_result_id => l_copy_entity_result_id
4566: ,p_copy_entity_txn_id => p_copy_entity_txn_id

Line 4583: ben_plan_design_program_module.create_formula_result

4579: ---------------------------------------------------------------
4580:
4581: if to_char(l_peo_rec.mx_poe_rl) is not null then
4582: --
4583: ben_plan_design_program_module.create_formula_result
4584: (
4585: p_validate => 0
4586: ,p_copy_entity_result_id => l_copy_entity_result_id
4587: ,p_copy_entity_txn_id => p_copy_entity_txn_id

Line 4604: ben_plan_design_program_module.create_formula_result

4600: ---------------------------------------------------------------
4601:
4602: if to_char(l_peo_rec.prtn_eff_end_dt_rl) is not null then
4603: --
4604: ben_plan_design_program_module.create_formula_result
4605: (
4606: p_validate => 0
4607: ,p_copy_entity_result_id => l_copy_entity_result_id
4608: ,p_copy_entity_txn_id => p_copy_entity_txn_id

Line 4625: ben_plan_design_program_module.create_formula_result

4621: ---------------------------------------------------------------
4622:
4623: if to_char(l_peo_rec.prtn_eff_strt_dt_rl) is not null then
4624: --
4625: ben_plan_design_program_module.create_formula_result
4626: (
4627: p_validate => 0
4628: ,p_copy_entity_result_id => l_copy_entity_result_id
4629: ,p_copy_entity_txn_id => p_copy_entity_txn_id

Line 4646: ben_plan_design_program_module.create_formula_result

4642: ---------------------------------------------------------------
4643:
4644: if to_char(l_peo_rec.vrfy_fmly_mmbr_rl) is not null then
4645: --
4646: ben_plan_design_program_module.create_formula_result
4647: (
4648: p_validate => 0
4649: ,p_copy_entity_result_id => l_copy_entity_result_id
4650: ,p_copy_entity_txn_id => p_copy_entity_txn_id

Line 4667: ben_plan_design_program_module.create_formula_result

4663: ---------------------------------------------------------------
4664:
4665: if to_char(l_peo_rec.wait_perd_dt_to_use_rl) is not null then
4666: --
4667: ben_plan_design_program_module.create_formula_result
4668: (
4669: p_validate => 0
4670: ,p_copy_entity_result_id => l_copy_entity_result_id
4671: ,p_copy_entity_txn_id => p_copy_entity_txn_id

Line 4688: ben_plan_design_program_module.create_formula_result

4684: ---------------------------------------------------------------
4685:
4686: if to_char(l_peo_rec.wait_perd_rl) is not null then
4687: --
4688: ben_plan_design_program_module.create_formula_result
4689: (
4690: p_validate => 0
4691: ,p_copy_entity_result_id => l_copy_entity_result_id
4692: ,p_copy_entity_txn_id => p_copy_entity_txn_id

Line 4836: ben_plan_design_program_module.create_formula_result

4832: ---------------------------------------------------------------
4833:
4834: if to_char(l_lbr_rec.dflt_to_asn_pndg_ctfn_rl) is not null then
4835: --
4836: ben_plan_design_program_module.create_formula_result
4837: (
4838: p_validate => 0
4839: ,p_copy_entity_result_id => l_copy_entity_result_id
4840: ,p_copy_entity_txn_id => p_copy_entity_txn_id

Line 4856: ben_plan_design_program_module.create_formula_result

4852: ---------------------------------------------------------------
4853:
4854: if to_char(l_lbr_rec.mn_cvg_rl) is not null then
4855: --
4856: ben_plan_design_program_module.create_formula_result
4857: (
4858: p_validate => 0
4859: ,p_copy_entity_result_id => l_copy_entity_result_id
4860: ,p_copy_entity_txn_id => p_copy_entity_txn_id

Line 4876: ben_plan_design_program_module.create_formula_result

4872: ---------------------------------------------------------------
4873:
4874: if to_char(l_lbr_rec.mx_cvg_rl) is not null then
4875: --
4876: ben_plan_design_program_module.create_formula_result
4877: (
4878: p_validate => 0
4879: ,p_copy_entity_result_id => l_copy_entity_result_id
4880: ,p_copy_entity_txn_id => p_copy_entity_txn_id

Line 5006: ben_plan_design_program_module.create_formula_result

5002: ---------------------------------------------------------------
5003:
5004: if to_char(l_lpr_rec.auto_enrt_mthd_rl) is not null then
5005: --
5006: ben_plan_design_program_module.create_formula_result
5007: (
5008: p_validate => 0
5009: ,p_copy_entity_result_id => l_copy_entity_result_id
5010: ,p_copy_entity_txn_id => p_copy_entity_txn_id

Line 5026: ben_plan_design_program_module.create_formula_result

5022: ---------------------------------------------------------------
5023:
5024: if to_char(l_lpr_rec.dflt_enrt_rl) is not null then
5025: --
5026: ben_plan_design_program_module.create_formula_result
5027: (
5028: p_validate => 0
5029: ,p_copy_entity_result_id => l_copy_entity_result_id
5030: ,p_copy_entity_txn_id => p_copy_entity_txn_id

Line 5046: ben_plan_design_program_module.create_formula_result

5042: ---------------------------------------------------------------
5043:
5044: if to_char(l_lpr_rec.enrt_rl) is not null then
5045: --
5046: ben_plan_design_program_module.create_formula_result
5047: (
5048: p_validate => 0
5049: ,p_copy_entity_result_id => l_copy_entity_result_id
5050: ,p_copy_entity_txn_id => p_copy_entity_txn_id

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

5902: l_mirror_src_entity_result_id := p_copy_entity_result_id ;
5903: --
5904: l_FORMULA_ID := p_formula_id ;
5905: --
5906: if ben_plan_design_program_module.g_pdw_allow_dup_rslt = ben_plan_design_program_module.g_pdw_no_dup_rslt then
5907: open c_object_exists(l_FORMULA_ID,'FFF');
5908: fetch c_object_exists into l_dummy;
5909: if c_object_exists%found then
5910: close c_object_exists;

Line 7375: end ben_plan_design_program_module;

7371:
7372: ---------------------------------------------------------------
7373: -- END OF INTERSECTION NAME FUNCTIONS ----------------------
7374: ---------------------------------------------------------------
7375: end ben_plan_design_program_module;