[Home] [Help]
200: ,p_object_version_number out nocopy number
201: ,p_effective_date in date
202: ,p_parent_entity_result_id in number
203: ) is
204: l_copy_entity_result_id ben_copy_entity_results.copy_entity_result_id%TYPE;
205: l_proc varchar2(72) := g_package||'create_elpro_results';
206: l_object_version_number ben_copy_entity_results.object_version_number%TYPE;
207: --
208: l_cv_result_type_cd varchar2(30) := 'DISPLAY' ;
202: ,p_parent_entity_result_id in number
203: ) is
204: l_copy_entity_result_id ben_copy_entity_results.copy_entity_result_id%TYPE;
205: l_proc varchar2(72) := g_package||'create_elpro_results';
206: l_object_version_number ben_copy_entity_results.object_version_number%TYPE;
207: --
208: l_cv_result_type_cd varchar2(30) := 'DISPLAY' ;
209: --
210: --
214: -- c_parent_table_name varchar2,
215: c_parent_table_alias varchar2,
216: c_copy_entity_txn_id number) is
217: select copy_entity_result_id mirror_src_entity_result_id
218: from ben_copy_entity_results cpe
219: -- pqh_table_route trt
220: where cpe.information1= c_parent_pk_id
221: -- and cpe.result_type_cd = 'DISPLAY'
222: and cpe.result_type_cd = l_cv_result_type_cd
256: where epa.prtn_elig_id = c_prtn_elig_id
257: -- and epa.business_group_id = p_business_group_id
258: and not exists (
259: select /* */ null
260: from ben_copy_entity_results cpe
261: -- pqh_table_route trt
262: where copy_entity_txn_id = p_copy_entity_txn_id
263: -- and trt.table_route_id = cpe.table_route_id
264: and ( -- c_mirror_src_entity_result_id is null or
290: where cep.prtn_elig_prfl_id = c_prtn_elig_prfl_id
291: -- and cep.business_group_id = p_business_group_id
292: and not exists (
293: select /* */ null
294: from ben_copy_entity_results cpe
295: -- pqh_table_route trt
296: where copy_entity_txn_id = p_copy_entity_txn_id
297: -- and trt.table_route_id = cpe.table_route_id
298: and ( -- c_mirror_src_entity_result_id is null or
330: where cer.prtn_eligy_rl_id = c_prtn_eligy_rl_id
331: -- and cpe.business_group_id = p_business_group_id
332: and not exists (
333: select /* */ null
334: from ben_copy_entity_results cpe1
335: -- pqh_table_route trt
336: where copy_entity_txn_id = p_copy_entity_txn_id
337: -- and trt.table_route_id = cpe1.table_route_id
338: and ( -- c_mirror_src_entity_result_id is null or
352: --
353: l_mirror_src_entity_result_id number(15);
354: l_table_route_id number(15);
355: l_result_type_cd varchar2(30);
356: l_information5 ben_copy_entity_results.information5%type;
357: l_number_of_copies number(15);
358:
359: l_mndtry_flag ben_prtn_elig_prfl_f.mndtry_flag%type;
360:
474: end if;
475: --
476: l_copy_entity_result_id := null;
477: l_object_version_number := null;
478: ben_copy_entity_results_api.create_copy_entity_results(
479: p_copy_entity_result_id => l_copy_entity_result_id,
480: p_copy_entity_txn_id => p_copy_entity_txn_id,
481: p_result_type_cd => l_result_type_cd,
482: p_mirror_src_entity_result_id => l_mirror_src_entity_result_id,
669: -- End Bug 5059695
670:
671: l_copy_entity_result_id := null;
672: l_object_version_number := null;
673: ben_copy_entity_results_api.create_copy_entity_results(
674: p_copy_entity_result_id => l_copy_entity_result_id,
675: p_copy_entity_txn_id => p_copy_entity_txn_id,
676: p_result_type_cd => l_result_type_cd,
677: p_mirror_src_entity_result_id => l_mirror_src_entity_result_id,
809: end if;
810: --
811: l_copy_entity_result_id := null;
812: l_object_version_number := null;
813: ben_copy_entity_results_api.create_copy_entity_results(
814: p_copy_entity_result_id => l_copy_entity_result_id,
815: p_copy_entity_txn_id => p_copy_entity_txn_id,
816: p_result_type_cd => l_result_type_cd,
817: p_mirror_src_entity_result_id => l_mirror_src_entity_result_id,
917: ,p_object_version_number out nocopy number
918: ,p_effective_date in date
919: ,p_parent_entity_result_id in number
920: ) is
921: l_copy_entity_result_id ben_copy_entity_results.copy_entity_result_id%TYPE;
922: l_proc varchar2(72) := g_package||'create_dep_elpro_result';
923: l_object_version_number ben_copy_entity_results.object_version_number%TYPE;
924: --
925: l_cv_result_type_cd varchar2(30) := 'DISPLAY' ;
919: ,p_parent_entity_result_id in number
920: ) is
921: l_copy_entity_result_id ben_copy_entity_results.copy_entity_result_id%TYPE;
922: l_proc varchar2(72) := g_package||'create_dep_elpro_result';
923: l_object_version_number ben_copy_entity_results.object_version_number%TYPE;
924: --
925: l_cv_result_type_cd varchar2(30) := 'DISPLAY' ;
926: --
927: cursor c_parent_result(c_parent_pk_id number,
927: cursor c_parent_result(c_parent_pk_id number,
928: c_parent_table_alias varchar2,
929: c_copy_entity_txn_id number) is
930: select copy_entity_result_id mirror_src_entity_result_id
931: from ben_copy_entity_results cpe
932: -- pqh_table_route trt
933: where cpe.information1= c_parent_pk_id
934: and cpe.result_type_cd = l_cv_result_type_cd
935: and cpe.copy_entity_txn_id = c_copy_entity_txn_id
962: where ade.apld_dpnt_cvg_elig_prfl_id = c_apld_dpnt_cvg_elig_prfl_id
963: -- and ade.business_group_id = p_business_group_id
964: and not exists (
965: select /* */ null
966: from ben_copy_entity_results cpe
967: -- pqh_table_route trt
968: where copy_entity_txn_id = p_copy_entity_txn_id
969: -- and trt.table_route_id = cpe.table_route_id
970: and ( -- c_mirror_src_entity_result_id is null or
995:
996: l_mirror_src_entity_result_id number(15);
997: l_table_route_id number(15);
998: l_result_type_cd varchar2(30);
999: l_information5 ben_copy_entity_results.information5%type;
1000: l_number_of_copies number(15);
1001:
1002: begin
1003: l_number_of_copies := p_number_of_copies ;
1031: end if;
1032: --
1033: l_copy_entity_result_id := null;
1034: l_object_version_number := null;
1035: ben_copy_entity_results_api.create_copy_entity_results(
1036: p_copy_entity_result_id => l_copy_entity_result_id,
1037: p_copy_entity_txn_id => p_copy_entity_txn_id,
1038: p_result_type_cd => l_result_type_cd,
1039: p_mirror_src_entity_result_id => l_mirror_src_entity_result_id,
1152: ,p_object_version_number out nocopy number
1153: ,p_effective_date in date
1154: ,p_no_dup_rslt in varchar2 default null
1155: ) is
1156: l_copy_entity_result_id ben_copy_entity_results.copy_entity_result_id%TYPE;
1157: l_proc varchar2(72) := g_package||'create_elig_prfl_results';
1158: l_object_version_number ben_copy_entity_results.object_version_number%TYPE;
1159: --
1160: l_cv_result_type_cd varchar2(30) := 'DISPLAY' ;
1154: ,p_no_dup_rslt in varchar2 default null
1155: ) is
1156: l_copy_entity_result_id ben_copy_entity_results.copy_entity_result_id%TYPE;
1157: l_proc varchar2(72) := g_package||'create_elig_prfl_results';
1158: l_object_version_number ben_copy_entity_results.object_version_number%TYPE;
1159: --
1160: l_cv_result_type_cd varchar2(30) := 'DISPLAY' ;
1161: --
1162: cursor c_parent_result(c_parent_pk_id number,
1163: -- c_parent_table_name varchar2,
1164: c_parent_table_alias varchar2,
1165: c_copy_entity_txn_id number) is
1166: select copy_entity_result_id mirror_src_entity_result_id
1167: from ben_copy_entity_results cpe
1168: -- pqh_table_route trt
1169: where cpe.information1= c_parent_pk_id
1170: -- and cpe.result_type_cd = 'DISPLAY'
1171: and cpe.result_type_cd = l_cv_result_type_cd
1198: where elp.eligy_prfl_id = c_eligy_prfl_id
1199: -- and elp.business_group_id = p_business_group_id
1200: and not exists (
1201: select /* */ null
1202: from ben_copy_entity_results cpe
1203: -- pqh_table_route trt
1204: where copy_entity_txn_id = p_copy_entity_txn_id
1205: -- and trt.table_route_id = cpe.table_route_id
1206: and ( -- c_mirror_src_entity_result_id is null or
1232: where cgp.cntng_prtn_elig_prfl_id = c_cntng_prtn_elig_prfl_id
1233: -- and cgp.business_group_id = p_business_group_id
1234: and not exists (
1235: select /* */ null
1236: from ben_copy_entity_results cpe
1237: -- pqh_table_route trt
1238: where copy_entity_txn_id = p_copy_entity_txn_id
1239: -- and trt.table_route_id = cpe.table_route_id
1240: and ( -- c_mirror_src_entity_result_id is null or
1266: where erl.eligy_prfl_rl_id = c_eligy_prfl_rl_id
1267: -- and erl.business_group_id = p_business_group_id
1268: and not exists (
1269: select /* */ null
1270: from ben_copy_entity_results cpe
1271: -- pqh_table_route trt
1272: where copy_entity_txn_id = p_copy_entity_txn_id
1273: -- and trt.table_route_id = cpe.table_route_id
1274: and ( -- c_mirror_src_entity_result_id is null or
1300: where eap.elig_age_prte_id = c_elig_age_prte_id
1301: -- and eap.business_group_id = p_business_group_id
1302: and not exists (
1303: select /* */ null
1304: from ben_copy_entity_results cpe
1305: -- pqh_table_route trt
1306: where copy_entity_txn_id = p_copy_entity_txn_id
1307: -- and trt.table_route_id = cpe.table_route_id
1308: and ( -- c_mirror_src_entity_result_id is null or
1319: --
1320: cursor c_eap_drp(c_elig_age_prte_id number,c_mirror_src_entity_result_id number ,
1321: c_table_alias varchar2 ) is
1322: select distinct cpe.information246 age_fctr_id
1323: from ben_copy_entity_results cpe
1324: -- pqh_table_route trt
1325: where copy_entity_txn_id = p_copy_entity_txn_id
1326: -- and trt.table_route_id = cpe.table_route_id
1327: and mirror_src_entity_result_id = c_mirror_src_entity_result_id
1348: where ean.elig_asnt_set_prte_id = c_elig_asnt_set_prte_id
1349: -- and ean.business_group_id = p_business_group_id
1350: and not exists (
1351: select /* */ null
1352: from ben_copy_entity_results cpe
1353: -- pqh_table_route trt
1354: where copy_entity_txn_id = p_copy_entity_txn_id
1355: -- and trt.table_route_id = cpe.table_route_id
1356: and ( -- c_mirror_src_entity_result_id is null or
1397: where ebn.elig_benfts_grp_prte_id = c_elig_benfts_grp_prte_id
1398: -- and ebn.business_group_id = p_business_group_id
1399: and not exists (
1400: select /* */ null
1401: from ben_copy_entity_results cpe
1402: -- pqh_table_route trt
1403: where copy_entity_txn_id = p_copy_entity_txn_id
1404: -- and trt.table_route_id = cpe.table_route_id
1405: and ( -- c_mirror_src_entity_result_id is null or
1416: --
1417: cursor c_ebn_bg(c_elig_benfts_grp_prte_id number,c_mirror_src_entity_result_id number ,
1418: c_table_alias varchar2 ) is
1419: select distinct cpe.information222 benfts_grp_id
1420: from ben_copy_entity_results cpe
1421: -- pqh_table_route trt
1422: where copy_entity_txn_id = p_copy_entity_txn_id
1423: -- and trt.table_route_id = cpe.table_route_id
1424: and mirror_src_entity_result_id = c_mirror_src_entity_result_id
1445: where ebu.elig_brgng_unit_prte_id = c_elig_brgng_unit_prte_id
1446: -- and ebu.business_group_id = p_business_group_id
1447: and not exists (
1448: select /* */ null
1449: from ben_copy_entity_results cpe
1450: -- pqh_table_route trt
1451: where copy_entity_txn_id = p_copy_entity_txn_id
1452: -- and trt.table_route_id = cpe.table_route_id
1453: and ( -- c_mirror_src_entity_result_id is null or
1479: where ecq.elig_cbr_quald_bnf_id = c_elig_cbr_quald_bnf_id
1480: -- and ecq.business_group_id = p_business_group_id
1481: and not exists (
1482: select /* */ null
1483: from ben_copy_entity_results cpe
1484: -- pqh_table_route trt
1485: where copy_entity_txn_id = p_copy_entity_txn_id
1486: -- and trt.table_route_id = cpe.table_route_id
1487: and ( -- c_mirror_src_entity_result_id is null or
1513: where ecp.elig_cmbn_age_los_prte_id = c_elig_cmbn_age_los_prte_id
1514: -- and ecp.business_group_id = p_business_group_id
1515: and not exists (
1516: select /* */ null
1517: from ben_copy_entity_results cpe
1518: -- pqh_table_route trt
1519: where copy_entity_txn_id = p_copy_entity_txn_id
1520: -- and trt.table_route_id = cpe.table_route_id
1521: and ( -- c_mirror_src_entity_result_id is null or
1532: --
1533: cursor c_ecp_drp(c_elig_cmbn_age_los_prte_id number,c_mirror_src_entity_result_id number ,
1534: c_table_alias varchar2 ) is
1535: select distinct cpe.information223 cmbn_age_los_fctr_id
1536: from ben_copy_entity_results cpe
1537: -- pqh_table_route trt
1538: where copy_entity_txn_id = p_copy_entity_txn_id
1539: -- and trt.table_route_id = cpe.table_route_id
1540: and mirror_src_entity_result_id = c_mirror_src_entity_result_id
1561: where ecl.elig_comp_lvl_prte_id = c_elig_comp_lvl_prte_id
1562: -- and ecl.business_group_id = p_business_group_id
1563: and not exists (
1564: select /* */ null
1565: from ben_copy_entity_results cpe
1566: -- pqh_table_route trt
1567: where copy_entity_txn_id = p_copy_entity_txn_id
1568: -- and trt.table_route_id = cpe.table_route_id
1569: and ( -- c_mirror_src_entity_result_id is null or
1580: --
1581: cursor c_ecl_drp(c_elig_comp_lvl_prte_id number,c_mirror_src_entity_result_id number ,
1582: c_table_alias varchar2 ) is
1583: select distinct cpe.information254 comp_lvl_fctr_id
1584: from ben_copy_entity_results cpe
1585: -- pqh_table_route trt
1586: where copy_entity_txn_id = p_copy_entity_txn_id
1587: -- and trt.table_route_id = cpe.table_route_id
1588: and mirror_src_entity_result_id = c_mirror_src_entity_result_id
1610: where edg.elig_dpnt_cvrd_othr_pgm_id = c_elig_dpnt_cvrd_othr_pgm_id
1611: -- and edg.business_group_id = p_business_group_id
1612: and not exists (
1613: select /* */ null
1614: from ben_copy_entity_results cpe
1615: -- pqh_table_route trt
1616: where copy_entity_txn_id = p_copy_entity_txn_id
1617: -- and trt.table_route_id = cpe.table_route_id
1618: and ( -- c_mirror_src_entity_result_id is null or
1644: where edp.elig_dpnt_cvrd_othr_pl_id = c_elig_dpnt_cvrd_othr_pl_id
1645: -- and edp.business_group_id = p_business_group_id
1646: and not exists (
1647: select /* */ null
1648: from ben_copy_entity_results cpe
1649: -- pqh_table_route trt
1650: where copy_entity_txn_id = p_copy_entity_txn_id
1651: -- and trt.table_route_id = cpe.table_route_id
1652: and ( -- c_mirror_src_entity_result_id is null or
1678: where edt.elig_dpnt_cvrd_othr_ptip_id = c_elig_dpnt_cvrd_othr_ptip_id
1679: -- and edt.business_group_id = p_business_group_id
1680: and not exists (
1681: select /* */ null
1682: from ben_copy_entity_results cpe
1683: -- pqh_table_route trt
1684: where copy_entity_txn_id = p_copy_entity_txn_id
1685: -- and trt.table_route_id = cpe.table_route_id
1686: and ( -- c_mirror_src_entity_result_id is null or
1712: where edi.elig_dpnt_cvrd_plip_id = c_elig_dpnt_cvrd_plip_id
1713: -- and edi.business_group_id = p_business_group_id
1714: and not exists (
1715: select /* */ null
1716: from ben_copy_entity_results cpe
1717: -- pqh_table_route trt
1718: where copy_entity_txn_id = p_copy_entity_txn_id
1719: -- and trt.table_route_id = cpe.table_route_id
1720: and ( -- c_mirror_src_entity_result_id is null or
1746: where etd.elig_dpnt_othr_ptip_id = c_elig_dpnt_othr_ptip_id
1747: -- and etd.business_group_id = p_business_group_id
1748: and not exists (
1749: select /* */ null
1750: from ben_copy_entity_results cpe
1751: -- pqh_table_route trt
1752: where copy_entity_txn_id = p_copy_entity_txn_id
1753: -- and trt.table_route_id = cpe.table_route_id
1754: and ( -- c_mirror_src_entity_result_id is null or
1780: where eds.elig_dsbld_stat_prte_id = c_elig_dsbld_stat_prte_id
1781: -- and eds.business_group_id = p_business_group_id
1782: and not exists (
1783: select /* */ null
1784: from ben_copy_entity_results cpe
1785: -- pqh_table_route trt
1786: where copy_entity_txn_id = p_copy_entity_txn_id
1787: -- and trt.table_route_id = cpe.table_route_id
1788: and ( -- c_mirror_src_entity_result_id is null or
1814: where ees.elig_ee_stat_prte_id = c_elig_ee_stat_prte_id
1815: -- and ees.business_group_id = p_business_group_id
1816: and not exists (
1817: select /* */ null
1818: from ben_copy_entity_results cpe
1819: -- pqh_table_route trt
1820: where copy_entity_txn_id = p_copy_entity_txn_id
1821: -- and trt.table_route_id = cpe.table_route_id
1822: and ( -- c_mirror_src_entity_result_id is null or
1871: where eei.elig_enrld_anthr_oipl_id = c_elig_enrld_anthr_oipl_id
1872: -- and eei.business_group_id = p_business_group_id
1873: and not exists (
1874: select /* */ null
1875: from ben_copy_entity_results cpe
1876: -- pqh_table_route trt
1877: where copy_entity_txn_id = p_copy_entity_txn_id
1878: -- and trt.table_route_id = cpe.table_route_id
1879: and ( -- c_mirror_src_entity_result_id is null or
1905: where eeg.elig_enrld_anthr_pgm_id = c_elig_enrld_anthr_pgm_id
1906: -- and eeg.business_group_id = p_business_group_id
1907: and not exists (
1908: select /* */ null
1909: from ben_copy_entity_results cpe
1910: -- pqh_table_route trt
1911: where copy_entity_txn_id = p_copy_entity_txn_id
1912: -- and trt.table_route_id = cpe.table_route_id
1913: and ( -- c_mirror_src_entity_result_id is null or
1939: where eai.elig_enrld_anthr_plip_id = c_elig_enrld_anthr_plip_id
1940: -- and eai.business_group_id = p_business_group_id
1941: and not exists (
1942: select /* */ null
1943: from ben_copy_entity_results cpe
1944: -- pqh_table_route trt
1945: where copy_entity_txn_id = p_copy_entity_txn_id
1946: -- and trt.table_route_id = cpe.table_route_id
1947: and ( -- c_mirror_src_entity_result_id is null or
1973: where eep.elig_enrld_anthr_pl_id = c_elig_enrld_anthr_pl_id
1974: -- and eep.business_group_id = p_business_group_id
1975: and not exists (
1976: select /* */ null
1977: from ben_copy_entity_results cpe
1978: -- pqh_table_route trt
1979: where copy_entity_txn_id = p_copy_entity_txn_id
1980: -- and trt.table_route_id = cpe.table_route_id
1981: and ( -- c_mirror_src_entity_result_id is null or
2007: where eet.elig_enrld_anthr_ptip_id = c_elig_enrld_anthr_ptip_id
2008: -- and eet.business_group_id = p_business_group_id
2009: and not exists (
2010: select /* */ null
2011: from ben_copy_entity_results cpe
2012: -- pqh_table_route trt
2013: where copy_entity_txn_id = p_copy_entity_txn_id
2014: -- and trt.table_route_id = cpe.table_route_id
2015: and ( -- c_mirror_src_entity_result_id is null or
2041: where efp.elig_fl_tm_pt_tm_prte_id = c_elig_fl_tm_pt_tm_prte_id
2042: -- and efp.business_group_id = p_business_group_id
2043: and not exists (
2044: select /* */ null
2045: from ben_copy_entity_results cpe
2046: -- pqh_table_route trt
2047: where copy_entity_txn_id = p_copy_entity_txn_id
2048: -- and trt.table_route_id = cpe.table_route_id
2049: and ( -- c_mirror_src_entity_result_id is null or
2075: where egr.elig_grd_prte_id = c_elig_grd_prte_id
2076: -- and egr.business_group_id = p_business_group_id
2077: and not exists (
2078: select /* */ null
2079: from ben_copy_entity_results cpe
2080: -- pqh_table_route trt
2081: where copy_entity_txn_id = p_copy_entity_txn_id
2082: -- and trt.table_route_id = cpe.table_route_id
2083: and ( -- c_mirror_src_entity_result_id is null or
2125: where ehs.elig_hrly_slrd_prte_id = c_elig_hrly_slrd_prte_id
2126: -- and ehs.business_group_id = p_business_group_id
2127: and not exists (
2128: select /* */ null
2129: from ben_copy_entity_results cpe
2130: -- pqh_table_route trt
2131: where copy_entity_txn_id = p_copy_entity_txn_id
2132: -- and trt.table_route_id = cpe.table_route_id
2133: and ( -- c_mirror_src_entity_result_id is null or
2159: where ehw.elig_hrs_wkd_prte_id = c_elig_hrs_wkd_prte_id
2160: -- and ehw.business_group_id = p_business_group_id
2161: and not exists (
2162: select /* */ null
2163: from ben_copy_entity_results cpe
2164: -- pqh_table_route trt
2165: where copy_entity_txn_id = p_copy_entity_txn_id
2166: -- and trt.table_route_id = cpe.table_route_id
2167: and ( -- c_mirror_src_entity_result_id is null or
2178: --
2179: cursor c_ehw_drp(c_elig_hrs_wkd_prte_id number,c_mirror_src_entity_result_id number ,
2180: c_table_alias varchar2 ) is
2181: select distinct cpe.information224 hrs_wkd_in_perd_fctr_id
2182: from ben_copy_entity_results cpe
2183: -- pqh_table_route trt
2184: where copy_entity_txn_id = p_copy_entity_txn_id
2185: -- and trt.table_route_id = cpe.table_route_id
2186: and mirror_src_entity_result_id = c_mirror_src_entity_result_id
2207: where ejp.elig_job_prte_id = c_elig_job_prte_id
2208: -- and ejp.business_group_id = p_business_group_id
2209: and not exists (
2210: select /* */ null
2211: from ben_copy_entity_results cpe
2212: -- pqh_table_route trt
2213: where copy_entity_txn_id = p_copy_entity_txn_id
2214: -- and trt.table_route_id = cpe.table_route_id
2215: and ( -- c_mirror_src_entity_result_id is null or
2258: where elu.elig_lbr_mmbr_prte_id = c_elig_lbr_mmbr_prte_id
2259: -- and elu.business_group_id = p_business_group_id
2260: and not exists (
2261: select /* */ null
2262: from ben_copy_entity_results cpe
2263: -- pqh_table_route trt
2264: where copy_entity_txn_id = p_copy_entity_txn_id
2265: -- and trt.table_route_id = cpe.table_route_id
2266: and ( -- c_mirror_src_entity_result_id is null or
2292: where eln.elig_lgl_enty_prte_id = c_elig_lgl_enty_prte_id
2293: -- and eln.business_group_id = p_business_group_id
2294: and not exists (
2295: select /* */ null
2296: from ben_copy_entity_results cpe
2297: -- pqh_table_route trt
2298: where copy_entity_txn_id = p_copy_entity_txn_id
2299: -- and trt.table_route_id = cpe.table_route_id
2300: and ( -- c_mirror_src_entity_result_id is null or
2347: where elr.elig_loa_rsn_prte_id = c_elig_loa_rsn_prte_id
2348: -- and elr.business_group_id = p_business_group_id
2349: and not exists (
2350: select /* */ null
2351: from ben_copy_entity_results cpe
2352: -- pqh_table_route trt
2353: where copy_entity_txn_id = p_copy_entity_txn_id
2354: -- and trt.table_route_id = cpe.table_route_id
2355: and ( -- c_mirror_src_entity_result_id is null or
2418: where els.elig_los_prte_id = c_elig_los_prte_id
2419: -- and els.business_group_id = p_business_group_id
2420: and not exists (
2421: select /* */ null
2422: from ben_copy_entity_results cpe
2423: -- pqh_table_route trt
2424: where copy_entity_txn_id = p_copy_entity_txn_id
2425: -- and trt.table_route_id = cpe.table_route_id
2426: and ( -- c_mirror_src_entity_result_id is null or
2438: --
2439: cursor c_els_drp(c_elig_los_prte_id number,c_mirror_src_entity_result_id number ,
2440: c_table_alias varchar2 ) is
2441: select distinct cpe.information243 los_fctr_id
2442: from ben_copy_entity_results cpe
2443: -- pqh_table_route trt
2444: where copy_entity_txn_id = p_copy_entity_txn_id
2445: -- and trt.table_route_id = cpe.table_route_id
2446: and mirror_src_entity_result_id = c_mirror_src_entity_result_id
2467: where elv.elig_lvg_rsn_prte_id = c_elig_lvg_rsn_prte_id
2468: -- and elv.business_group_id = p_business_group_id
2469: and not exists (
2470: select /* */ null
2471: from ben_copy_entity_results cpe
2472: -- pqh_table_route trt
2473: where copy_entity_txn_id = p_copy_entity_txn_id
2474: -- and trt.table_route_id = cpe.table_route_id
2475: and ( -- c_mirror_src_entity_result_id is null or
2501: where eno.elig_no_othr_cvg_prte_id = c_elig_no_othr_cvg_prte_id
2502: -- and eno.business_group_id = p_business_group_id
2503: and not exists (
2504: select /* */ null
2505: from ben_copy_entity_results cpe
2506: -- pqh_table_route trt
2507: where copy_entity_txn_id = p_copy_entity_txn_id
2508: -- and trt.table_route_id = cpe.table_route_id
2509: and ( -- c_mirror_src_entity_result_id is null or
2535: where eom.elig_optd_mdcr_prte_id = c_elig_optd_mdcr_prte_id
2536: -- and eom.business_group_id = p_business_group_id
2537: and not exists (
2538: select /* */ null
2539: from ben_copy_entity_results cpe
2540: -- pqh_table_route trt
2541: where copy_entity_txn_id = p_copy_entity_txn_id
2542: -- and trt.table_route_id = cpe.table_route_id
2543: and ( -- c_mirror_src_entity_result_id is null or
2569: where eou.elig_org_unit_prte_id = c_elig_org_unit_prte_id
2570: -- and eou.business_group_id = p_business_group_id
2571: and not exists (
2572: select /* */ null
2573: from ben_copy_entity_results cpe
2574: -- pqh_table_route trt
2575: where copy_entity_txn_id = p_copy_entity_txn_id
2576: -- and trt.table_route_id = cpe.table_route_id
2577: and ( -- c_mirror_src_entity_result_id is null or
2618: where eoy.elig_othr_ptip_prte_id = c_elig_othr_ptip_prte_id
2619: -- and eoy.business_group_id = p_business_group_id
2620: and not exists (
2621: select /* */ null
2622: from ben_copy_entity_results cpe
2623: -- pqh_table_route trt
2624: where copy_entity_txn_id = p_copy_entity_txn_id
2625: -- and trt.table_route_id = cpe.table_route_id
2626: and ( -- c_mirror_src_entity_result_id is null or
2652: where epf.elig_pct_fl_tm_prte_id = c_elig_pct_fl_tm_prte_id
2653: -- and epf.business_group_id = p_business_group_id
2654: and not exists (
2655: select /* */ null
2656: from ben_copy_entity_results cpe
2657: -- pqh_table_route trt
2658: where copy_entity_txn_id = p_copy_entity_txn_id
2659: -- and trt.table_route_id = cpe.table_route_id
2660: and ( -- c_mirror_src_entity_result_id is null or
2671: --
2672: cursor c_epf_drp(c_elig_pct_fl_tm_prte_id number,c_mirror_src_entity_result_id number ,
2673: c_table_alias varchar2 ) is
2674: select distinct cpe.information233 pct_fl_tm_fctr_id
2675: from ben_copy_entity_results cpe
2676: -- pqh_table_route trt
2677: where copy_entity_txn_id = p_copy_entity_txn_id
2678: -- and trt.table_route_id = cpe.table_route_id
2679: and mirror_src_entity_result_id = c_mirror_src_entity_result_id
2700: where ept.elig_per_typ_prte_id = c_elig_per_typ_prte_id
2701: -- and ept.business_group_id = p_business_group_id
2702: and not exists (
2703: select /* */ null
2704: from ben_copy_entity_results cpe
2705: -- pqh_table_route trt
2706: where copy_entity_txn_id = p_copy_entity_txn_id
2707: -- and trt.table_route_id = cpe.table_route_id
2708: and ( -- c_mirror_src_entity_result_id is null or
2754: where epg.elig_ppl_grp_prte_id = c_elig_ppl_grp_prte_id
2755: -- and epg.business_group_id = p_business_group_id
2756: and not exists (
2757: select /* */ null
2758: from ben_copy_entity_results cpe
2759: -- pqh_table_route trt
2760: where copy_entity_txn_id = p_copy_entity_txn_id
2761: -- and trt.table_route_id = cpe.table_route_id
2762: and ( -- c_mirror_src_entity_result_id is null or
2788: where epp.elig_prtt_anthr_pl_prte_id = c_elig_prtt_anthr_pl_prte_id
2789: -- and epp.business_group_id = p_business_group_id
2790: and not exists (
2791: select /* */ null
2792: from ben_copy_entity_results cpe
2793: -- pqh_table_route trt
2794: where copy_entity_txn_id = p_copy_entity_txn_id
2795: -- and trt.table_route_id = cpe.table_route_id
2796: and ( -- c_mirror_src_entity_result_id is null or
2822: where epz.elig_pstl_cd_r_rng_prte_id = c_elig_pstl_cd_r_rng_prte_id
2823: -- and epz.business_group_id = p_business_group_id
2824: and not exists (
2825: select /* */ null
2826: from ben_copy_entity_results cpe
2827: -- pqh_table_route trt
2828: where copy_entity_txn_id = p_copy_entity_txn_id
2829: -- and trt.table_route_id = cpe.table_route_id
2830: and ( -- c_mirror_src_entity_result_id is null or
2841: --
2842: cursor c_epz_pstl(c_elig_pstl_cd_r_rng_prte_id number,c_mirror_src_entity_result_id number ,
2843: c_table_alias varchar2 ) is
2844: select distinct cpe.information245 pstl_zip_rng_id
2845: from ben_copy_entity_results cpe
2846: -- pqh_table_route trt
2847: where copy_entity_txn_id = p_copy_entity_txn_id
2848: -- and trt.table_route_id = cpe.table_route_id
2849: and mirror_src_entity_result_id = c_mirror_src_entity_result_id
2870: where epy.elig_pyrl_prte_id = c_elig_pyrl_prte_id
2871: -- and epy.business_group_id = p_business_group_id
2872: and not exists (
2873: select /* */ null
2874: from ben_copy_entity_results cpe
2875: -- pqh_table_route trt
2876: where copy_entity_txn_id = p_copy_entity_txn_id
2877: -- and trt.table_route_id = cpe.table_route_id
2878: and ( -- c_mirror_src_entity_result_id is null or
2919: where epb.elig_py_bss_prte_id = c_elig_py_bss_prte_id
2920: -- and epb.business_group_id = p_business_group_id
2921: and not exists (
2922: select /* */ null
2923: from ben_copy_entity_results cpe
2924: -- pqh_table_route trt
2925: where copy_entity_txn_id = p_copy_entity_txn_id
2926: -- and trt.table_route_id = cpe.table_route_id
2927: and ( -- c_mirror_src_entity_result_id is null or
2960: where esh.elig_schedd_hrs_prte_id = c_elig_schedd_hrs_prte_id
2961: -- and esh.business_group_id = p_business_group_id
2962: and not exists (
2963: select /* */ null
2964: from ben_copy_entity_results cpe
2965: -- pqh_table_route trt
2966: where copy_entity_txn_id = p_copy_entity_txn_id
2967: -- and trt.table_route_id = cpe.table_route_id
2968: and ( -- c_mirror_src_entity_result_id is null or
2994: where esa.elig_svc_area_prte_id = c_elig_svc_area_prte_id
2995: -- and esa.business_group_id = p_business_group_id
2996: and not exists (
2997: select /* */ null
2998: from ben_copy_entity_results cpe
2999: -- pqh_table_route trt
3000: where copy_entity_txn_id = p_copy_entity_txn_id
3001: -- and trt.table_route_id = cpe.table_route_id
3002: and ( -- c_mirror_src_entity_result_id is null or
3013: --
3014: cursor c_esa_svc(c_elig_svc_area_prte_id number,c_mirror_src_entity_result_id number ,
3015: c_table_alias varchar2 ) is
3016: select distinct cpe.information241 svc_area_id
3017: from ben_copy_entity_results cpe
3018: -- pqh_table_route trt
3019: where copy_entity_txn_id = p_copy_entity_txn_id
3020: -- and trt.table_route_id = cpe.table_route_id
3021: and mirror_src_entity_result_id = c_mirror_src_entity_result_id
3042: where ewl.elig_wk_loc_prte_id = c_elig_wk_loc_prte_id
3043: -- and ewl.business_group_id = p_business_group_id
3044: and not exists (
3045: select /* */ null
3046: from ben_copy_entity_results cpe
3047: -- pqh_table_route trt
3048: where copy_entity_txn_id = p_copy_entity_txn_id
3049: -- and trt.table_route_id = cpe.table_route_id
3050: and ( -- c_mirror_src_entity_result_id is null or
3091: where esp.elig_sp_clng_prg_prte_id = c_elig_sp_clng_prg_prte_id
3092: -- and esp.business_group_id = p_business_group_id
3093: and not exists (
3094: select /* */ null
3095: from ben_copy_entity_results cpe
3096: -- pqh_table_route trt
3097: where copy_entity_txn_id = p_copy_entity_txn_id
3098: -- and trt.table_route_id = cpe.table_route_id
3099: and ( -- c_mirror_src_entity_result_id is null or
3151: where eps.elig_pstn_prte_id = c_elig_pstn_prte_id
3152: -- and eps.business_group_id = p_business_group_id
3153: and not exists (
3154: select /* */ null
3155: from ben_copy_entity_results cpe
3156: -- pqh_table_route trt
3157: where copy_entity_txn_id = p_copy_entity_txn_id
3158: -- and trt.table_route_id = cpe.table_route_id
3159: and ( -- c_mirror_src_entity_result_id is null or
3200: where epn.elig_prbtn_perd_prte_id = c_elig_prbtn_perd_prte_id
3201: -- and epn.business_group_id = p_business_group_id
3202: and not exists (
3203: select /* */ null
3204: from ben_copy_entity_results cpe
3205: -- pqh_table_route trt
3206: where copy_entity_txn_id = p_copy_entity_txn_id
3207: -- and trt.table_route_id = cpe.table_route_id
3208: and ( -- c_mirror_src_entity_result_id is null or
3234: where emp.elig_mrtl_sts_prte_id = c_elig_mrtl_sts_prte_id
3235: -- and emp.business_group_id = p_business_group_id
3236: and not exists (
3237: select /* */ null
3238: from ben_copy_entity_results cpe
3239: -- pqh_table_route trt
3240: where copy_entity_txn_id = p_copy_entity_txn_id
3241: -- and trt.table_route_id = cpe.table_route_id
3242: and ( -- c_mirror_src_entity_result_id is null or
3268: where egn.elig_gndr_prte_id = c_elig_gndr_prte_id
3269: -- and egn.business_group_id = p_business_group_id
3270: and not exists (
3271: select /* */ null
3272: from ben_copy_entity_results cpe
3273: -- pqh_table_route trt
3274: where copy_entity_txn_id = p_copy_entity_txn_id
3275: -- and trt.table_route_id = cpe.table_route_id
3276: and ( -- c_mirror_src_entity_result_id is null or
3302: where edr.elig_dsblty_rsn_prte_id = c_elig_dsblty_rsn_prte_id
3303: -- and edr.business_group_id = p_business_group_id
3304: and not exists (
3305: select /* */ null
3306: from ben_copy_entity_results cpe
3307: -- pqh_table_route trt
3308: where copy_entity_txn_id = p_copy_entity_txn_id
3309: -- and trt.table_route_id = cpe.table_route_id
3310: and ( -- c_mirror_src_entity_result_id is null or
3336: where edd.elig_dsblty_dgr_prte_id = c_elig_dsblty_dgr_prte_id
3337: -- and edd.business_group_id = p_business_group_id
3338: and not exists (
3339: select /* */ null
3340: from ben_copy_entity_results cpe
3341: -- pqh_table_route trt
3342: where copy_entity_txn_id = p_copy_entity_txn_id
3343: -- and trt.table_route_id = cpe.table_route_id
3344: and ( -- c_mirror_src_entity_result_id is null or
3370: where eqt.elig_qual_titl_prte_id = c_elig_qual_titl_prte_id
3371: -- and eqt.business_group_id = p_business_group_id
3372: and not exists (
3373: select /* */ null
3374: from ben_copy_entity_results cpe
3375: -- pqh_table_route trt
3376: where copy_entity_txn_id = p_copy_entity_txn_id
3377: -- and trt.table_route_id = cpe.table_route_id
3378: and ( -- c_mirror_src_entity_result_id is null or
3412: where est.elig_suppl_role_prte_id = c_elig_suppl_role_prte_id
3413: -- and est.business_group_id = p_business_group_id
3414: and not exists (
3415: select /* */ null
3416: from ben_copy_entity_results cpe
3417: -- pqh_table_route trt
3418: where copy_entity_txn_id = p_copy_entity_txn_id
3419: -- and trt.table_route_id = cpe.table_route_id
3420: and ( -- c_mirror_src_entity_result_id is null or
3464: where ect.elig_dsblty_ctg_prte_id = c_elig_dsblty_ctg_prte_id
3465: -- and ect.business_group_id = p_business_group_id
3466: and not exists (
3467: select /* */ null
3468: from ben_copy_entity_results cpe
3469: -- pqh_table_route trt
3470: where copy_entity_txn_id = p_copy_entity_txn_id
3471: -- and trt.table_route_id = cpe.table_route_id
3472: and ( -- c_mirror_src_entity_result_id is null or
3498: where ecy.elig_comptncy_prte_id = c_elig_comptncy_prte_id
3499: -- and ecy.business_group_id = p_business_group_id
3500: and not exists (
3501: select /* */ null
3502: from ben_copy_entity_results cpe
3503: -- pqh_table_route trt
3504: where copy_entity_txn_id = p_copy_entity_txn_id
3505: -- and trt.table_route_id = cpe.table_route_id
3506: and ( -- c_mirror_src_entity_result_id is null or
3555: where erg.elig_perf_rtng_prte_id = c_elig_perf_rtng_prte_id
3556: -- and erg.business_group_id = p_business_group_id
3557: and not exists (
3558: select /* */ null
3559: from ben_copy_entity_results cpe
3560: -- pqh_table_route trt
3561: where copy_entity_txn_id = p_copy_entity_txn_id
3562: -- and trt.table_route_id = cpe.table_route_id
3563: and ( -- c_mirror_src_entity_result_id is null or
3589: where eqg.elig_qua_in_gr_prte_id = c_elig_qua_in_gr_prte_id
3590: -- and eqg.business_group_id = p_business_group_id
3591: and not exists (
3592: select /* */ null
3593: from ben_copy_entity_results cpe
3594: -- pqh_table_route trt
3595: where copy_entity_txn_id = p_copy_entity_txn_id
3596: -- and trt.table_route_id = cpe.table_route_id
3597: and ( -- c_mirror_src_entity_result_id is null or
3623: where etu.elig_tbco_use_prte_id = c_elig_tbco_use_prte_id
3624: -- and etu.business_group_id = p_business_group_id
3625: and not exists (
3626: select /* */ null
3627: from ben_copy_entity_results cpe
3628: -- pqh_table_route trt
3629: where copy_entity_txn_id = p_copy_entity_txn_id
3630: -- and trt.table_route_id = cpe.table_route_id
3631: and ( -- c_mirror_src_entity_result_id is null or
3657: where etc.elig_ttl_cvg_vol_prte_id = c_elig_ttl_cvg_vol_prte_id
3658: -- and etc.business_group_id = p_business_group_id
3659: and not exists (
3660: select /* */ null
3661: from ben_copy_entity_results cpe
3662: -- pqh_table_route trt
3663: where copy_entity_txn_id = p_copy_entity_txn_id
3664: -- and trt.table_route_id = cpe.table_route_id
3665: and ( -- c_mirror_src_entity_result_id is null or
3691: where etp.elig_ttl_prtt_prte_id = c_elig_ttl_prtt_prte_id
3692: -- and etp.business_group_id = p_business_group_id
3693: and not exists (
3694: select /* */ null
3695: from ben_copy_entity_results cpe
3696: -- pqh_table_route trt
3697: where copy_entity_txn_id = p_copy_entity_txn_id
3698: -- and trt.table_route_id = cpe.table_route_id
3699: and ( -- c_mirror_src_entity_result_id is null or
3725: where edb.elig_dsbld_prte_id = c_elig_dsbld_prte_id
3726: -- and edb.business_group_id = p_business_group_id
3727: and not exists (
3728: select /* */ null
3729: from ben_copy_entity_results cpe
3730: -- pqh_table_route trt
3731: where copy_entity_txn_id = p_copy_entity_txn_id
3732: -- and trt.table_route_id = cpe.table_route_id
3733: and ( -- c_mirror_src_entity_result_id is null or
3759: where ehc.elig_hlth_cvg_prte_id = c_elig_hlth_cvg_prte_id
3760: -- and ehc.business_group_id = p_business_group_id
3761: and not exists (
3762: select /* */ null
3763: from ben_copy_entity_results cpe
3764: -- pqh_table_route trt
3765: where copy_entity_txn_id = p_copy_entity_txn_id
3766: -- and trt.table_route_id = cpe.table_route_id
3767: and ( -- c_mirror_src_entity_result_id is null or
3793: where eop.elig_anthr_pl_prte_id = c_elig_anthr_pl_prte_id
3794: -- and eop.business_group_id = p_business_group_id
3795: and not exists (
3796: select /* */ null
3797: from ben_copy_entity_results cpe
3798: -- pqh_table_route trt
3799: where copy_entity_txn_id = p_copy_entity_txn_id
3800: -- and trt.table_route_id = cpe.table_route_id
3801: and ( -- c_mirror_src_entity_result_id is null or
3832: FROM ben_eligy_crit_values_f ecv
3833: WHERE ecv.eligy_crit_values_id = cv_eligy_crit_values_id
3834: AND NOT EXISTS (
3835: SELECT NULL
3836: FROM ben_copy_entity_results cpe
3837: WHERE copy_entity_txn_id = p_copy_entity_txn_id
3838: AND mirror_src_entity_result_id =
3839: cv_mirror_src_entity_result_id
3840: AND cpe.table_alias = cv_table_alias
3876: FROM ben_eligy_criteria egl
3877: WHERE egl.eligy_criteria_id = cv_eligy_criteria_id
3878: AND NOT EXISTS (
3879: SELECT NULL
3880: FROM ben_copy_entity_results cpe
3881: WHERE copy_entity_txn_id = p_copy_entity_txn_id
3882: AND mirror_src_entity_result_id =
3883: cv_mirror_src_entity_result_id
3884: AND cpe.table_alias = cv_table_alias
3894: l_out_egl_result_id NUMBER (15);
3895: l_egl_table_route_id NUMBER (15);
3896: l_egl_result_type_cd VARCHAR2 (30);
3897:
3898: l_egl_copy_entity_result_id ben_copy_entity_results.copy_entity_result_id%TYPE;
3899: l_egl_object_version_number ben_copy_entity_results.object_version_number%TYPE;
3900: l_flex_value_set_name fnd_flex_value_sets.flex_value_set_name%TYPE;
3901: --
3902: ---------------------------------------------------------------
3895: l_egl_table_route_id NUMBER (15);
3896: l_egl_result_type_cd VARCHAR2 (30);
3897:
3898: l_egl_copy_entity_result_id ben_copy_entity_results.copy_entity_result_id%TYPE;
3899: l_egl_object_version_number ben_copy_entity_results.object_version_number%TYPE;
3900: l_flex_value_set_name fnd_flex_value_sets.flex_value_set_name%TYPE;
3901: --
3902: ---------------------------------------------------------------
3903: ------------------ END OF BEN_ELIGY_CRITERIA ------------------
3905: */
3906: cursor c_object_exists(c_pk_id number,
3907: c_table_alias varchar2) is
3908: select null
3909: from ben_copy_entity_results cpe
3910: -- pqh_table_route trt
3911: where copy_entity_txn_id = p_copy_entity_txn_id
3912: -- and trt.table_route_id = cpe.table_route_id
3913: and cpe.table_alias = c_table_alias
3922:
3923: l_mirror_src_entity_result_id number(15);
3924: l_table_route_id number(15);
3925: l_result_type_cd varchar2(30);
3926: l_information5 ben_copy_entity_results.information5%type;
3927: l_number_of_copies number(15);
3928: begin
3929:
3930: ---------------------------------------------------------------
4001: end if;
4002: -- End Bug 5059695
4003:
4004:
4005: ben_copy_entity_results_api.create_copy_entity_results(
4006: p_copy_entity_result_id => l_copy_entity_result_id,
4007: p_copy_entity_txn_id => p_copy_entity_txn_id,
4008: p_result_type_cd => l_result_type_cd,
4009: p_mirror_src_entity_result_id => l_mirror_src_entity_result_id,
4174: end if;
4175: --
4176: l_copy_entity_result_id := null;
4177: l_object_version_number := null;
4178: ben_copy_entity_results_api.create_copy_entity_results(
4179: p_copy_entity_result_id => l_copy_entity_result_id,
4180: p_copy_entity_txn_id => p_copy_entity_txn_id,
4181: p_result_type_cd => l_result_type_cd,
4182: p_mirror_src_entity_result_id => l_mirror_src_entity_result_id,
4292: end if;
4293: --
4294: l_copy_entity_result_id := null;
4295: l_object_version_number := null;
4296: ben_copy_entity_results_api.create_copy_entity_results(
4297: p_copy_entity_result_id => l_copy_entity_result_id,
4298: p_copy_entity_txn_id => p_copy_entity_txn_id,
4299: p_result_type_cd => l_result_type_cd,
4300: p_mirror_src_entity_result_id => l_mirror_src_entity_result_id,
4410: end if;
4411: --
4412: l_copy_entity_result_id := null;
4413: l_object_version_number := null;
4414: ben_copy_entity_results_api.create_copy_entity_results(
4415: p_copy_entity_result_id => l_copy_entity_result_id,
4416: p_copy_entity_txn_id => p_copy_entity_txn_id,
4417: p_result_type_cd => l_result_type_cd,
4418: p_mirror_src_entity_result_id => l_mirror_src_entity_result_id,
4557: l_mapping_column_name1,
4558: l_mapping_column_name2,
4559: p_copy_entity_txn_id);
4560: --
4561: ben_copy_entity_results_api.create_copy_entity_results(
4562: p_copy_entity_result_id => l_copy_entity_result_id,
4563: p_copy_entity_txn_id => p_copy_entity_txn_id,
4564: p_result_type_cd => l_result_type_cd,
4565: p_mirror_src_entity_result_id => l_mirror_src_entity_result_id,
4668: end if;
4669: --
4670: l_copy_entity_result_id := null;
4671: l_object_version_number := null;
4672: ben_copy_entity_results_api.create_copy_entity_results(
4673: p_copy_entity_result_id => l_copy_entity_result_id,
4674: p_copy_entity_txn_id => p_copy_entity_txn_id,
4675: p_result_type_cd => l_result_type_cd,
4676: p_mirror_src_entity_result_id => l_mirror_src_entity_result_id,
4786: end if;
4787: --
4788: l_copy_entity_result_id := null;
4789: l_object_version_number := null;
4790: ben_copy_entity_results_api.create_copy_entity_results(
4791: p_copy_entity_result_id => l_copy_entity_result_id,
4792: p_copy_entity_txn_id => p_copy_entity_txn_id,
4793: p_result_type_cd => l_result_type_cd,
4794: p_mirror_src_entity_result_id => l_mirror_src_entity_result_id,
4897: end if;
4898: --
4899: l_copy_entity_result_id := null;
4900: l_object_version_number := null;
4901: ben_copy_entity_results_api.create_copy_entity_results(
4902: p_copy_entity_result_id => l_copy_entity_result_id,
4903: p_copy_entity_txn_id => p_copy_entity_txn_id,
4904: p_result_type_cd => l_result_type_cd,
4905: p_mirror_src_entity_result_id => l_mirror_src_entity_result_id,
5003: end if;
5004: --
5005: l_copy_entity_result_id := null;
5006: l_object_version_number := null;
5007: ben_copy_entity_results_api.create_copy_entity_results(
5008: p_copy_entity_result_id => l_copy_entity_result_id,
5009: p_copy_entity_txn_id => p_copy_entity_txn_id,
5010: p_result_type_cd => l_result_type_cd,
5011: p_mirror_src_entity_result_id => l_mirror_src_entity_result_id,
5127: end if;
5128: --
5129: l_copy_entity_result_id := null;
5130: l_object_version_number := null;
5131: ben_copy_entity_results_api.create_copy_entity_results(
5132: p_copy_entity_result_id => l_copy_entity_result_id,
5133: p_copy_entity_txn_id => p_copy_entity_txn_id,
5134: p_result_type_cd => l_result_type_cd,
5135: p_mirror_src_entity_result_id => l_mirror_src_entity_result_id,
5260: end if;
5261: --
5262: l_copy_entity_result_id := null;
5263: l_object_version_number := null;
5264: ben_copy_entity_results_api.create_copy_entity_results(
5265: p_copy_entity_result_id => l_copy_entity_result_id,
5266: p_copy_entity_txn_id => p_copy_entity_txn_id,
5267: p_result_type_cd => l_result_type_cd,
5268: p_mirror_src_entity_result_id => l_mirror_src_entity_result_id,
5367: end if;
5368: --
5369: l_copy_entity_result_id := null;
5370: l_object_version_number := null;
5371: ben_copy_entity_results_api.create_copy_entity_results(
5372: p_copy_entity_result_id => l_copy_entity_result_id,
5373: p_copy_entity_txn_id => p_copy_entity_txn_id,
5374: p_result_type_cd => l_result_type_cd,
5375: p_mirror_src_entity_result_id => l_mirror_src_entity_result_id,
5474: end if;
5475: --
5476: l_copy_entity_result_id := null;
5477: l_object_version_number := null;
5478: ben_copy_entity_results_api.create_copy_entity_results(
5479: p_copy_entity_result_id => l_copy_entity_result_id,
5480: p_copy_entity_txn_id => p_copy_entity_txn_id,
5481: p_result_type_cd => l_result_type_cd,
5482: p_mirror_src_entity_result_id => l_mirror_src_entity_result_id,
5581: end if;
5582: --
5583: l_copy_entity_result_id := null;
5584: l_object_version_number := null;
5585: ben_copy_entity_results_api.create_copy_entity_results(
5586: p_copy_entity_result_id => l_copy_entity_result_id,
5587: p_copy_entity_txn_id => p_copy_entity_txn_id,
5588: p_result_type_cd => l_result_type_cd,
5589: p_mirror_src_entity_result_id => l_mirror_src_entity_result_id,
5681: end if;
5682: --
5683: l_copy_entity_result_id := null;
5684: l_object_version_number := null;
5685: ben_copy_entity_results_api.create_copy_entity_results(
5686: p_copy_entity_result_id => l_copy_entity_result_id,
5687: p_copy_entity_txn_id => p_copy_entity_txn_id,
5688: p_result_type_cd => l_result_type_cd,
5689: p_mirror_src_entity_result_id => l_mirror_src_entity_result_id,
5780: end if;
5781: --
5782: l_copy_entity_result_id := null;
5783: l_object_version_number := null;
5784: ben_copy_entity_results_api.create_copy_entity_results(
5785: p_copy_entity_result_id => l_copy_entity_result_id,
5786: p_copy_entity_txn_id => p_copy_entity_txn_id,
5787: p_result_type_cd => l_result_type_cd,
5788: p_mirror_src_entity_result_id => l_mirror_src_entity_result_id,
5908: l_mapping_column_name1,
5909: l_mapping_column_name2,
5910: p_copy_entity_txn_id);
5911: --
5912: ben_copy_entity_results_api.create_copy_entity_results(
5913: p_copy_entity_result_id => l_copy_entity_result_id,
5914: p_copy_entity_txn_id => p_copy_entity_txn_id,
5915: p_result_type_cd => l_result_type_cd,
5916: p_mirror_src_entity_result_id => l_mirror_src_entity_result_id,
6025: end if;
6026: --
6027: l_copy_entity_result_id := null;
6028: l_object_version_number := null;
6029: ben_copy_entity_results_api.create_copy_entity_results(
6030: p_copy_entity_result_id => l_copy_entity_result_id,
6031: p_copy_entity_txn_id => p_copy_entity_txn_id,
6032: p_result_type_cd => l_result_type_cd,
6033: p_mirror_src_entity_result_id => l_mirror_src_entity_result_id,
6135: end if;
6136: --
6137: l_copy_entity_result_id := null;
6138: l_object_version_number := null;
6139: ben_copy_entity_results_api.create_copy_entity_results(
6140: p_copy_entity_result_id => l_copy_entity_result_id,
6141: p_copy_entity_txn_id => p_copy_entity_txn_id,
6142: p_result_type_cd => l_result_type_cd,
6143: p_mirror_src_entity_result_id => l_mirror_src_entity_result_id,
6245: end if;
6246: --
6247: l_copy_entity_result_id := null;
6248: l_object_version_number := null;
6249: ben_copy_entity_results_api.create_copy_entity_results(
6250: p_copy_entity_result_id => l_copy_entity_result_id,
6251: p_copy_entity_txn_id => p_copy_entity_txn_id,
6252: p_result_type_cd => l_result_type_cd,
6253: p_mirror_src_entity_result_id => l_mirror_src_entity_result_id,
6355: end if;
6356: --
6357: l_copy_entity_result_id := null;
6358: l_object_version_number := null;
6359: ben_copy_entity_results_api.create_copy_entity_results(
6360: p_copy_entity_result_id => l_copy_entity_result_id,
6361: p_copy_entity_txn_id => p_copy_entity_txn_id,
6362: p_result_type_cd => l_result_type_cd,
6363: p_parent_entity_result_id => l_mirror_src_entity_result_id,
6466: end if;
6467: --
6468: l_copy_entity_result_id := null;
6469: l_object_version_number := null;
6470: ben_copy_entity_results_api.create_copy_entity_results(
6471: p_copy_entity_result_id => l_copy_entity_result_id,
6472: p_copy_entity_txn_id => p_copy_entity_txn_id,
6473: p_result_type_cd => l_result_type_cd,
6474: p_mirror_src_entity_result_id => l_mirror_src_entity_result_id,
6572: end if;
6573: --
6574: l_copy_entity_result_id := null;
6575: l_object_version_number := null;
6576: ben_copy_entity_results_api.create_copy_entity_results(
6577: p_copy_entity_result_id => l_copy_entity_result_id,
6578: p_copy_entity_txn_id => p_copy_entity_txn_id,
6579: p_result_type_cd => l_result_type_cd,
6580: p_mirror_src_entity_result_id => l_mirror_src_entity_result_id,
6716: l_mapping_column_name2,
6717: p_copy_entity_txn_id);
6718: --
6719:
6720: ben_copy_entity_results_api.create_copy_entity_results(
6721: p_copy_entity_result_id => l_copy_entity_result_id,
6722: p_copy_entity_txn_id => p_copy_entity_txn_id,
6723: p_result_type_cd => l_result_type_cd,
6724: p_mirror_src_entity_result_id => l_mirror_src_entity_result_id,
6827: end if;
6828: --
6829: l_copy_entity_result_id := null;
6830: l_object_version_number := null;
6831: ben_copy_entity_results_api.create_copy_entity_results(
6832: p_copy_entity_result_id => l_copy_entity_result_id,
6833: p_copy_entity_txn_id => p_copy_entity_txn_id,
6834: p_result_type_cd => l_result_type_cd,
6835: p_mirror_src_entity_result_id => l_mirror_src_entity_result_id,
6932: end if;
6933: --
6934: l_copy_entity_result_id := null;
6935: l_object_version_number := null;
6936: ben_copy_entity_results_api.create_copy_entity_results(
6937: p_copy_entity_result_id => l_copy_entity_result_id,
6938: p_copy_entity_txn_id => p_copy_entity_txn_id,
6939: p_result_type_cd => l_result_type_cd,
6940: p_mirror_src_entity_result_id => l_mirror_src_entity_result_id,
7089: l_mapping_column_name2,
7090: p_copy_entity_txn_id);
7091: --
7092:
7093: ben_copy_entity_results_api.create_copy_entity_results(
7094: p_copy_entity_result_id => l_copy_entity_result_id,
7095: p_copy_entity_txn_id => p_copy_entity_txn_id,
7096: p_result_type_cd => l_result_type_cd,
7097: p_mirror_src_entity_result_id => l_mirror_src_entity_result_id,
7201: end if;
7202: --
7203: l_copy_entity_result_id := null;
7204: l_object_version_number := null;
7205: ben_copy_entity_results_api.create_copy_entity_results(
7206: p_copy_entity_result_id => l_copy_entity_result_id,
7207: p_copy_entity_txn_id => p_copy_entity_txn_id,
7208: p_result_type_cd => l_result_type_cd,
7209: p_mirror_src_entity_result_id => l_mirror_src_entity_result_id,
7343: l_mapping_column_name2,
7344: p_copy_entity_txn_id);
7345: --
7346:
7347: ben_copy_entity_results_api.create_copy_entity_results(
7348: p_copy_entity_result_id => l_copy_entity_result_id,
7349: p_copy_entity_txn_id => p_copy_entity_txn_id,
7350: p_result_type_cd => l_result_type_cd,
7351: p_mirror_src_entity_result_id => l_mirror_src_entity_result_id,
7509: --
7510:
7511: l_copy_entity_result_id := null;
7512: l_object_version_number := null;
7513: ben_copy_entity_results_api.create_copy_entity_results(
7514: p_copy_entity_result_id => l_copy_entity_result_id,
7515: p_copy_entity_txn_id => p_copy_entity_txn_id,
7516: p_result_type_cd => l_result_type_cd,
7517: p_mirror_src_entity_result_id => l_mirror_src_entity_result_id,
7671: l_mapping_column_name2,
7672: p_copy_entity_txn_id);
7673: --
7674:
7675: ben_copy_entity_results_api.create_copy_entity_results(
7676: p_copy_entity_result_id => l_copy_entity_result_id,
7677: p_copy_entity_txn_id => p_copy_entity_txn_id,
7678: p_result_type_cd => l_result_type_cd,
7679: p_mirror_src_entity_result_id => l_mirror_src_entity_result_id,
7787: end if;
7788: --
7789: l_copy_entity_result_id := null;
7790: l_object_version_number := null;
7791: ben_copy_entity_results_api.create_copy_entity_results(
7792: p_copy_entity_result_id => l_copy_entity_result_id,
7793: p_copy_entity_txn_id => p_copy_entity_txn_id,
7794: p_result_type_cd => l_result_type_cd,
7795: p_mirror_src_entity_result_id => l_mirror_src_entity_result_id,
7910: end if;
7911: --
7912: l_copy_entity_result_id := null;
7913: l_object_version_number := null;
7914: ben_copy_entity_results_api.create_copy_entity_results(
7915: p_copy_entity_result_id => l_copy_entity_result_id,
7916: p_copy_entity_txn_id => p_copy_entity_txn_id,
7917: p_result_type_cd => l_result_type_cd,
7918: p_mirror_src_entity_result_id => l_mirror_src_entity_result_id,
8014: end if;
8015: --
8016: l_copy_entity_result_id := null;
8017: l_object_version_number := null;
8018: ben_copy_entity_results_api.create_copy_entity_results(
8019: p_copy_entity_result_id => l_copy_entity_result_id,
8020: p_copy_entity_txn_id => p_copy_entity_txn_id,
8021: p_result_type_cd => l_result_type_cd,
8022: p_mirror_src_entity_result_id => l_mirror_src_entity_result_id,
8115: end if;
8116: --
8117: l_copy_entity_result_id := null;
8118: l_object_version_number := null;
8119: ben_copy_entity_results_api.create_copy_entity_results(
8120: p_copy_entity_result_id => l_copy_entity_result_id,
8121: p_copy_entity_txn_id => p_copy_entity_txn_id,
8122: p_result_type_cd => l_result_type_cd,
8123: p_mirror_src_entity_result_id => l_mirror_src_entity_result_id,
8253: l_mapping_column_name2,
8254: p_copy_entity_txn_id);
8255: --
8256:
8257: ben_copy_entity_results_api.create_copy_entity_results(
8258: p_copy_entity_result_id => l_copy_entity_result_id,
8259: p_copy_entity_txn_id => p_copy_entity_txn_id,
8260: p_result_type_cd => l_result_type_cd,
8261: p_mirror_src_entity_result_id => l_mirror_src_entity_result_id,
8370: end if;
8371: --
8372: l_copy_entity_result_id := null;
8373: l_object_version_number := null;
8374: ben_copy_entity_results_api.create_copy_entity_results(
8375: p_copy_entity_result_id => l_copy_entity_result_id,
8376: p_copy_entity_txn_id => p_copy_entity_txn_id,
8377: p_result_type_cd => l_result_type_cd,
8378: p_mirror_src_entity_result_id => l_mirror_src_entity_result_id,
8474: end if;
8475: --
8476: l_copy_entity_result_id := null;
8477: l_object_version_number := null;
8478: ben_copy_entity_results_api.create_copy_entity_results(
8479: p_copy_entity_result_id => l_copy_entity_result_id,
8480: p_copy_entity_txn_id => p_copy_entity_txn_id,
8481: p_result_type_cd => l_result_type_cd,
8482: p_mirror_src_entity_result_id => l_mirror_src_entity_result_id,
8623: l_mapping_column_name2,
8624: p_copy_entity_txn_id);
8625: --
8626:
8627: ben_copy_entity_results_api.create_copy_entity_results(
8628: p_copy_entity_result_id => l_copy_entity_result_id,
8629: p_copy_entity_txn_id => p_copy_entity_txn_id,
8630: p_result_type_cd => l_result_type_cd,
8631: p_mirror_src_entity_result_id => l_mirror_src_entity_result_id,
8735: end if;
8736: --
8737: l_copy_entity_result_id := null;
8738: l_object_version_number := null;
8739: ben_copy_entity_results_api.create_copy_entity_results(
8740: p_copy_entity_result_id => l_copy_entity_result_id,
8741: p_copy_entity_txn_id => p_copy_entity_txn_id,
8742: p_result_type_cd => l_result_type_cd,
8743: p_mirror_src_entity_result_id => l_mirror_src_entity_result_id,
8840: end if;
8841: --
8842: l_copy_entity_result_id := null;
8843: l_object_version_number := null;
8844: ben_copy_entity_results_api.create_copy_entity_results(
8845: p_copy_entity_result_id => l_copy_entity_result_id,
8846: p_copy_entity_txn_id => p_copy_entity_txn_id,
8847: p_result_type_cd => l_result_type_cd,
8848: p_mirror_src_entity_result_id => l_mirror_src_entity_result_id,
8946: end if;
8947: --
8948: l_copy_entity_result_id := null;
8949: l_object_version_number := null;
8950: ben_copy_entity_results_api.create_copy_entity_results(
8951: p_copy_entity_result_id => l_copy_entity_result_id,
8952: p_copy_entity_txn_id => p_copy_entity_txn_id,
8953: p_result_type_cd => l_result_type_cd,
8954: p_mirror_src_entity_result_id => l_mirror_src_entity_result_id,
9101: l_mapping_column_name2,
9102: p_copy_entity_txn_id);
9103: --
9104:
9105: ben_copy_entity_results_api.create_copy_entity_results(
9106: p_copy_entity_result_id => l_copy_entity_result_id,
9107: p_copy_entity_txn_id => p_copy_entity_txn_id,
9108: p_result_type_cd => l_result_type_cd,
9109: p_mirror_src_entity_result_id => l_mirror_src_entity_result_id,
9236: l_mapping_column_name1,
9237: l_mapping_column_name2,
9238: p_copy_entity_txn_id);
9239: --
9240: ben_copy_entity_results_api.create_copy_entity_results(
9241: p_copy_entity_result_id => l_copy_entity_result_id,
9242: p_copy_entity_txn_id => p_copy_entity_txn_id,
9243: p_result_type_cd => l_result_type_cd,
9244: p_mirror_src_entity_result_id => l_mirror_src_entity_result_id,
9356: end if;
9357: --
9358: l_copy_entity_result_id := null;
9359: l_object_version_number := null;
9360: ben_copy_entity_results_api.create_copy_entity_results(
9361: p_copy_entity_result_id => l_copy_entity_result_id,
9362: p_copy_entity_txn_id => p_copy_entity_txn_id,
9363: p_result_type_cd => l_result_type_cd,
9364: p_mirror_src_entity_result_id => l_mirror_src_entity_result_id,
9506: end if;
9507: --
9508: l_copy_entity_result_id := null;
9509: l_object_version_number := null;
9510: ben_copy_entity_results_api.create_copy_entity_results(
9511: p_copy_entity_result_id => l_copy_entity_result_id,
9512: p_copy_entity_txn_id => p_copy_entity_txn_id,
9513: p_result_type_cd => l_result_type_cd,
9514: p_mirror_src_entity_result_id => l_mirror_src_entity_result_id,
9660: l_mapping_column_name2,
9661: p_copy_entity_txn_id);
9662: --
9663:
9664: ben_copy_entity_results_api.create_copy_entity_results(
9665: p_copy_entity_result_id => l_copy_entity_result_id,
9666: p_copy_entity_txn_id => p_copy_entity_txn_id,
9667: p_result_type_cd => l_result_type_cd,
9668: p_mirror_src_entity_result_id => l_mirror_src_entity_result_id,
9810: l_mapping_column_name2,
9811: p_copy_entity_txn_id);
9812: --
9813:
9814: ben_copy_entity_results_api.create_copy_entity_results(
9815: p_copy_entity_result_id => l_copy_entity_result_id,
9816: p_copy_entity_txn_id => p_copy_entity_txn_id,
9817: p_result_type_cd => l_result_type_cd,
9818: p_mirror_src_entity_result_id => l_mirror_src_entity_result_id,
9958: fetch c_position_start_date into l_position_start_date;
9959: close c_position_start_date;
9960: end if;
9961:
9962: ben_copy_entity_results_api.create_copy_entity_results(
9963: p_copy_entity_result_id => l_copy_entity_result_id,
9964: p_copy_entity_txn_id => p_copy_entity_txn_id,
9965: p_result_type_cd => l_result_type_cd,
9966: p_mirror_src_entity_result_id => l_mirror_src_entity_result_id,
10071: end if;
10072: --
10073: l_copy_entity_result_id := null;
10074: l_object_version_number := null;
10075: ben_copy_entity_results_api.create_copy_entity_results(
10076: p_copy_entity_result_id => l_copy_entity_result_id,
10077: p_copy_entity_txn_id => p_copy_entity_txn_id,
10078: p_result_type_cd => l_result_type_cd,
10079: p_mirror_src_entity_result_id => l_mirror_src_entity_result_id,
10181: end if;
10182: --
10183: l_copy_entity_result_id := null;
10184: l_object_version_number := null;
10185: ben_copy_entity_results_api.create_copy_entity_results(
10186: p_copy_entity_result_id => l_copy_entity_result_id,
10187: p_copy_entity_txn_id => p_copy_entity_txn_id,
10188: p_result_type_cd => l_result_type_cd,
10189: p_mirror_src_entity_result_id => l_mirror_src_entity_result_id,
10288: end if;
10289: --
10290: l_copy_entity_result_id := null;
10291: l_object_version_number := null;
10292: ben_copy_entity_results_api.create_copy_entity_results(
10293: p_copy_entity_result_id => l_copy_entity_result_id,
10294: p_copy_entity_txn_id => p_copy_entity_txn_id,
10295: p_result_type_cd => l_result_type_cd,
10296: p_mirror_src_entity_result_id => l_mirror_src_entity_result_id,
10395: end if;
10396: --
10397: l_copy_entity_result_id := null;
10398: l_object_version_number := null;
10399: ben_copy_entity_results_api.create_copy_entity_results(
10400: p_copy_entity_result_id => l_copy_entity_result_id,
10401: p_copy_entity_txn_id => p_copy_entity_txn_id,
10402: p_result_type_cd => l_result_type_cd,
10403: p_mirror_src_entity_result_id => l_mirror_src_entity_result_id,
10502: end if;
10503: --
10504: l_copy_entity_result_id := null;
10505: l_object_version_number := null;
10506: ben_copy_entity_results_api.create_copy_entity_results(
10507: p_copy_entity_result_id => l_copy_entity_result_id,
10508: p_copy_entity_txn_id => p_copy_entity_txn_id,
10509: p_result_type_cd => l_result_type_cd,
10510: p_mirror_src_entity_result_id => l_mirror_src_entity_result_id,
10632: l_mapping_column_name1,
10633: l_mapping_column_name2,
10634: p_copy_entity_txn_id);
10635: --
10636: ben_copy_entity_results_api.create_copy_entity_results(
10637: p_copy_entity_result_id => l_copy_entity_result_id,
10638: p_copy_entity_txn_id => p_copy_entity_txn_id,
10639: p_result_type_cd => l_result_type_cd,
10640: p_mirror_src_entity_result_id => l_mirror_src_entity_result_id,
10786: fetch c_job_start_date into l_job_start_date;
10787: close c_job_start_date;
10788: end if;
10789:
10790: ben_copy_entity_results_api.create_copy_entity_results(
10791: p_copy_entity_result_id => l_copy_entity_result_id,
10792: p_copy_entity_txn_id => p_copy_entity_txn_id,
10793: p_result_type_cd => l_result_type_cd,
10794: p_mirror_src_entity_result_id => l_mirror_src_entity_result_id,
10903: end if;
10904: --
10905: l_copy_entity_result_id := null;
10906: l_object_version_number := null;
10907: ben_copy_entity_results_api.create_copy_entity_results(
10908: p_copy_entity_result_id => l_copy_entity_result_id,
10909: p_copy_entity_txn_id => p_copy_entity_txn_id,
10910: p_result_type_cd => l_result_type_cd,
10911: p_mirror_src_entity_result_id => l_mirror_src_entity_result_id,
11011: end if;
11012: --
11013: l_copy_entity_result_id := null;
11014: l_object_version_number := null;
11015: ben_copy_entity_results_api.create_copy_entity_results(
11016: p_copy_entity_result_id => l_copy_entity_result_id,
11017: p_copy_entity_txn_id => p_copy_entity_txn_id,
11018: p_result_type_cd => l_result_type_cd,
11019: p_mirror_src_entity_result_id => l_mirror_src_entity_result_id,
11117: end if;
11118: --
11119: l_copy_entity_result_id := null;
11120: l_object_version_number := null;
11121: ben_copy_entity_results_api.create_copy_entity_results(
11122: p_copy_entity_result_id => l_copy_entity_result_id,
11123: p_copy_entity_txn_id => p_copy_entity_txn_id,
11124: p_result_type_cd => l_result_type_cd,
11125: p_mirror_src_entity_result_id => l_mirror_src_entity_result_id,
11223: end if;
11224: --
11225: l_copy_entity_result_id := null;
11226: l_object_version_number := null;
11227: ben_copy_entity_results_api.create_copy_entity_results(
11228: p_copy_entity_result_id => l_copy_entity_result_id,
11229: p_copy_entity_txn_id => p_copy_entity_txn_id,
11230: p_result_type_cd => l_result_type_cd,
11231: p_mirror_src_entity_result_id => l_mirror_src_entity_result_id,
11327: end if;
11328: --
11329: l_copy_entity_result_id := null;
11330: l_object_version_number := null;
11331: ben_copy_entity_results_api.create_copy_entity_results(
11332: p_copy_entity_result_id => l_copy_entity_result_id,
11333: p_copy_entity_txn_id => p_copy_entity_txn_id,
11334: p_result_type_cd => l_result_type_cd,
11335: p_mirror_src_entity_result_id => l_mirror_src_entity_result_id,
11447: end if;
11448: --
11449: l_copy_entity_result_id := null;
11450: l_object_version_number := null;
11451: ben_copy_entity_results_api.create_copy_entity_results(
11452: p_copy_entity_result_id => l_copy_entity_result_id,
11453: p_copy_entity_txn_id => p_copy_entity_txn_id,
11454: p_result_type_cd => l_result_type_cd,
11455: p_mirror_src_entity_result_id => l_mirror_src_entity_result_id,
11569: end if;
11570: --
11571: l_copy_entity_result_id := null;
11572: l_object_version_number := null;
11573: ben_copy_entity_results_api.create_copy_entity_results(
11574: p_copy_entity_result_id => l_copy_entity_result_id,
11575: p_copy_entity_txn_id => p_copy_entity_txn_id,
11576: p_result_type_cd => l_result_type_cd,
11577: p_mirror_src_entity_result_id => l_mirror_src_entity_result_id,
11676: end if;
11677: --
11678: l_copy_entity_result_id := null;
11679: l_object_version_number := null;
11680: ben_copy_entity_results_api.create_copy_entity_results(
11681: p_copy_entity_result_id => l_copy_entity_result_id,
11682: p_copy_entity_txn_id => p_copy_entity_txn_id,
11683: p_result_type_cd => l_result_type_cd,
11684: p_mirror_src_entity_result_id => l_mirror_src_entity_result_id,
11779: end if;
11780: --
11781: l_copy_entity_result_id := null;
11782: l_object_version_number := null;
11783: ben_copy_entity_results_api.create_copy_entity_results(
11784: p_copy_entity_result_id => l_copy_entity_result_id,
11785: p_copy_entity_txn_id => p_copy_entity_txn_id,
11786: p_result_type_cd => l_result_type_cd,
11787: p_mirror_src_entity_result_id => l_mirror_src_entity_result_id,
11931: end if;
11932: --
11933: close c_egl_val_type_cd ;
11934: --
11935: ben_copy_entity_results_api.create_copy_entity_results
11936: (
11937: p_copy_entity_result_id => l_copy_entity_result_id,
11938: p_copy_entity_txn_id => p_copy_entity_txn_id,
11939: p_result_type_cd => l_result_type_cd,
12087: close c_value_set_name;
12088: --
12089: end if;
12090: --
12091: ben_copy_entity_results_api.create_copy_entity_results
12092: (
12093: p_copy_entity_result_id => l_egl_copy_entity_result_id,
12094: p_copy_entity_txn_id => p_copy_entity_txn_id,
12095: p_result_type_cd => l_egl_result_type_cd,
12210: ,p_object_version_number out nocopy number
12211: ,p_effective_date in date
12212: ,p_no_dup_rslt in varchar2 default null
12213: ) is
12214: l_copy_entity_result_id ben_copy_entity_results.copy_entity_result_id%TYPE;
12215: l_proc varchar2(72) := g_package||'create_dep_elig_prfl_result';
12216: l_object_version_number ben_copy_entity_results.object_version_number%TYPE;
12217: --
12218: l_cv_result_type_cd varchar2(30) := 'DISPLAY' ;
12212: ,p_no_dup_rslt in varchar2 default null
12213: ) is
12214: l_copy_entity_result_id ben_copy_entity_results.copy_entity_result_id%TYPE;
12215: l_proc varchar2(72) := g_package||'create_dep_elig_prfl_result';
12216: l_object_version_number ben_copy_entity_results.object_version_number%TYPE;
12217: --
12218: l_cv_result_type_cd varchar2(30) := 'DISPLAY' ;
12219: --
12220: cursor c_parent_result(c_parent_pk_id number,
12220: cursor c_parent_result(c_parent_pk_id number,
12221: c_parent_table_alias varchar2,
12222: c_copy_entity_txn_id number) is
12223: select copy_entity_result_id mirror_src_entity_result_id
12224: from ben_copy_entity_results cpe
12225: -- pqh_table_route trt
12226: where cpe.information1= c_parent_pk_id
12227: and cpe.result_type_cd = l_cv_result_type_cd
12228: and cpe.copy_entity_txn_id = c_copy_entity_txn_id
12250: where dce.dpnt_cvg_eligy_prfl_id = c_dpnt_cvg_eligy_prfl_id
12251: -- and dce.business_group_id = p_business_group_id
12252: and not exists (
12253: select /* */ null
12254: from ben_copy_entity_results cpe
12255: -- pqh_table_route trt
12256: where copy_entity_txn_id = p_copy_entity_txn_id
12257: -- and trt.table_route_id = cpe.table_route_id
12258: and ( -- c_mirror_src_entity_result_id is null or
12284: where dcr.dpnt_cvg_rqd_rlshp_id = c_dpnt_cvg_rqd_rlshp_id
12285: -- and dcr.business_group_id = p_business_group_id
12286: and not exists (
12287: select /* */ null
12288: from ben_copy_entity_results cpe
12289: -- pqh_table_route trt
12290: where copy_entity_txn_id = p_copy_entity_txn_id
12291: -- and trt.table_route_id = cpe.table_route_id
12292: and ( -- c_mirror_src_entity_result_id is null or
12318: where dpc.dpnt_cvrd_anthr_pl_cvg_id = c_dpnt_cvrd_anthr_pl_cvg_id
12319: -- and dpc.business_group_id = p_business_group_id
12320: and not exists (
12321: select /* */ null
12322: from ben_copy_entity_results cpe
12323: -- pqh_table_route trt
12324: where copy_entity_txn_id = p_copy_entity_txn_id
12325: -- and trt.table_route_id = cpe.table_route_id
12326: and ( -- c_mirror_src_entity_result_id is null or
12352: where dec.dsgntr_enrld_cvg_id = c_dsgntr_enrld_cvg_id
12353: -- and dec.business_group_id = p_business_group_id
12354: and not exists (
12355: select /* */ null
12356: from ben_copy_entity_results cpe
12357: -- pqh_table_route trt
12358: where copy_entity_txn_id = p_copy_entity_txn_id
12359: -- and trt.table_route_id = cpe.table_route_id
12360: and ( -- c_mirror_src_entity_result_id is null or
12386: where eac.elig_age_cvg_id = c_elig_age_cvg_id
12387: -- and eac.business_group_id = p_business_group_id
12388: and not exists (
12389: select /* */ null
12390: from ben_copy_entity_results cpe
12391: -- pqh_table_route trt
12392: where copy_entity_txn_id = p_copy_entity_txn_id
12393: -- and trt.table_route_id = cpe.table_route_id
12394: and ( -- c_mirror_src_entity_result_id is null or
12405: --
12406: cursor c_eac_drp(c_elig_age_cvg_id number,c_mirror_src_entity_result_id number ,
12407: c_table_alias varchar2 ) is
12408: select distinct cpe.information246 age_fctr_id
12409: from ben_copy_entity_results cpe
12410: -- pqh_table_route trt
12411: where copy_entity_txn_id = p_copy_entity_txn_id
12412: -- and trt.table_route_id = cpe.table_route_id
12413: and mirror_src_entity_result_id = c_mirror_src_entity_result_id
12434: where edc.elig_dsbld_stat_cvg_id = c_elig_dsbld_stat_cvg_id
12435: -- and edc.business_group_id = p_business_group_id
12436: and not exists (
12437: select /* */ null
12438: from ben_copy_entity_results cpe
12439: -- pqh_table_route trt
12440: where copy_entity_txn_id = p_copy_entity_txn_id
12441: -- and trt.table_route_id = cpe.table_route_id
12442: and ( -- c_mirror_src_entity_result_id is null or
12468: where emc.elig_mltry_stat_cvg_id = c_elig_mltry_stat_cvg_id
12469: -- and emc.business_group_id = p_business_group_id
12470: and not exists (
12471: select /* */ null
12472: from ben_copy_entity_results cpe
12473: -- pqh_table_route trt
12474: where copy_entity_txn_id = p_copy_entity_txn_id
12475: -- and trt.table_route_id = cpe.table_route_id
12476: and ( -- c_mirror_src_entity_result_id is null or
12502: where ems.elig_mrtl_stat_cvg_id = c_elig_mrtl_stat_cvg_id
12503: -- and ems.business_group_id = p_business_group_id
12504: and not exists (
12505: select /* */ null
12506: from ben_copy_entity_results cpe
12507: -- pqh_table_route trt
12508: where copy_entity_txn_id = p_copy_entity_txn_id
12509: -- and trt.table_route_id = cpe.table_route_id
12510: and ( -- c_mirror_src_entity_result_id is null or
12536: where epl.elig_pstl_cd_r_rng_cvg_id = c_elig_pstl_cd_r_rng_cvg_id
12537: -- and epl.business_group_id = p_business_group_id
12538: and not exists (
12539: select /* */ null
12540: from ben_copy_entity_results cpe
12541: -- pqh_table_route trt
12542: where copy_entity_txn_id = p_copy_entity_txn_id
12543: -- and trt.table_route_id = cpe.table_route_id
12544: and ( -- c_mirror_src_entity_result_id is null or
12555: --
12556: cursor c_epl_pstl(c_elig_pstl_cd_r_rng_cvg_id number,c_mirror_src_entity_result_id number ,
12557: c_table_alias varchar2 ) is
12558: select distinct cpe.information245 pstl_zip_rng_id
12559: from ben_copy_entity_results cpe
12560: -- pqh_table_route trt
12561: where copy_entity_txn_id = p_copy_entity_txn_id
12562: -- and trt.table_route_id = cpe.table_route_id
12563: and mirror_src_entity_result_id = c_mirror_src_entity_result_id
12584: where esc.elig_stdnt_stat_cvg_id = c_elig_stdnt_stat_cvg_id
12585: -- and esc.business_group_id = p_business_group_id
12586: and not exists (
12587: select /* */ null
12588: from ben_copy_entity_results cpe
12589: -- pqh_table_route trt
12590: where copy_entity_txn_id = p_copy_entity_txn_id
12591: -- and trt.table_route_id = cpe.table_route_id
12592: and ( -- c_mirror_src_entity_result_id is null or
12606:
12607: cursor c_object_exists(c_pk_id number,
12608: c_table_alias varchar2) is
12609: select null
12610: from ben_copy_entity_results cpe
12611: -- pqh_table_route trt
12612: where copy_entity_txn_id = p_copy_entity_txn_id
12613: -- and trt.table_route_id = cpe.table_route_id
12614: and cpe.table_alias = c_table_alias
12618:
12619: l_mirror_src_entity_result_id number(15);
12620: l_table_route_id number(15);
12621: l_result_type_cd varchar2(30);
12622: l_information5 ben_copy_entity_results.information5%type;
12623: l_number_of_copies number(15);
12624:
12625: begin
12626:
12664: end if;
12665: --
12666: l_copy_entity_result_id := null;
12667: l_object_version_number := null;
12668: ben_copy_entity_results_api.create_copy_entity_results(
12669: p_copy_entity_result_id => l_copy_entity_result_id,
12670: p_copy_entity_txn_id => p_copy_entity_txn_id,
12671: p_result_type_cd => l_result_type_cd,
12672: p_mirror_src_entity_result_id => l_mirror_src_entity_result_id,
12790: end if;
12791: --
12792: l_copy_entity_result_id := null;
12793: l_object_version_number := null;
12794: ben_copy_entity_results_api.create_copy_entity_results(
12795: p_copy_entity_result_id => l_copy_entity_result_id,
12796: p_copy_entity_txn_id => p_copy_entity_txn_id,
12797: p_result_type_cd => l_result_type_cd,
12798: p_mirror_src_entity_result_id => l_mirror_src_entity_result_id,
12921: end if;
12922: --
12923: l_copy_entity_result_id := null;
12924: l_object_version_number := null;
12925: ben_copy_entity_results_api.create_copy_entity_results(
12926: p_copy_entity_result_id => l_copy_entity_result_id,
12927: p_copy_entity_txn_id => p_copy_entity_txn_id,
12928: p_result_type_cd => l_result_type_cd,
12929: p_mirror_src_entity_result_id => l_mirror_src_entity_result_id,
13024: end if;
13025: --
13026: l_copy_entity_result_id := null;
13027: l_object_version_number := null;
13028: ben_copy_entity_results_api.create_copy_entity_results(
13029: p_copy_entity_result_id => l_copy_entity_result_id,
13030: p_copy_entity_txn_id => p_copy_entity_txn_id,
13031: p_result_type_cd => l_result_type_cd,
13032: p_mirror_src_entity_result_id => l_mirror_src_entity_result_id,
13125: end if;
13126: --
13127: l_copy_entity_result_id := null;
13128: l_object_version_number := null;
13129: ben_copy_entity_results_api.create_copy_entity_results(
13130: p_copy_entity_result_id => l_copy_entity_result_id,
13131: p_copy_entity_txn_id => p_copy_entity_txn_id,
13132: p_result_type_cd => l_result_type_cd,
13133: p_mirror_src_entity_result_id => l_mirror_src_entity_result_id,
13272: end if;
13273: --
13274: l_copy_entity_result_id := null;
13275: l_object_version_number := null;
13276: ben_copy_entity_results_api.create_copy_entity_results(
13277: p_copy_entity_result_id => l_copy_entity_result_id,
13278: p_copy_entity_txn_id => p_copy_entity_txn_id,
13279: p_result_type_cd => l_result_type_cd,
13280: p_mirror_src_entity_result_id => l_mirror_src_entity_result_id,
13400: end if;
13401: --
13402: l_copy_entity_result_id := null;
13403: l_object_version_number := null;
13404: ben_copy_entity_results_api.create_copy_entity_results(
13405: p_copy_entity_result_id => l_copy_entity_result_id,
13406: p_copy_entity_txn_id => p_copy_entity_txn_id,
13407: p_result_type_cd => l_result_type_cd,
13408: p_mirror_src_entity_result_id => l_mirror_src_entity_result_id,
13530: end if;
13531: --
13532: l_copy_entity_result_id := null;
13533: l_object_version_number := null;
13534: ben_copy_entity_results_api.create_copy_entity_results(
13535: p_copy_entity_result_id => l_copy_entity_result_id,
13536: p_copy_entity_txn_id => p_copy_entity_txn_id,
13537: p_result_type_cd => l_result_type_cd,
13538: p_mirror_src_entity_result_id => l_mirror_src_entity_result_id,
13661: end if;
13662: --
13663: l_copy_entity_result_id := null;
13664: l_object_version_number := null;
13665: ben_copy_entity_results_api.create_copy_entity_results(
13666: p_copy_entity_result_id => l_copy_entity_result_id,
13667: p_copy_entity_txn_id => p_copy_entity_txn_id,
13668: p_result_type_cd => l_result_type_cd,
13669: p_mirror_src_entity_result_id => l_mirror_src_entity_result_id,
13776: end if;
13777: --
13778: l_copy_entity_result_id := null;
13779: l_object_version_number := null;
13780: ben_copy_entity_results_api.create_copy_entity_results(
13781: p_copy_entity_result_id => l_copy_entity_result_id,
13782: p_copy_entity_txn_id => p_copy_entity_txn_id,
13783: p_result_type_cd => l_result_type_cd,
13784: p_mirror_src_entity_result_id => l_mirror_src_entity_result_id,
13898: ,p_parent_entity_result_id in number
13899: ,p_no_dup_rslt in varchar2 default null
13900: ) is
13901:
13902: l_copy_entity_result_id ben_copy_entity_results.copy_entity_result_id%TYPE;
13903: l_proc varchar2(72) := g_package||'.create_eligy_criteria_result';
13904: l_object_version_number ben_copy_entity_results.object_version_number%TYPE;
13905: l_result_type_cd varchar2(30) := 'DISPLAY' ;
13906:
13900: ) is
13901:
13902: l_copy_entity_result_id ben_copy_entity_results.copy_entity_result_id%TYPE;
13903: l_proc varchar2(72) := g_package||'.create_eligy_criteria_result';
13904: l_object_version_number ben_copy_entity_results.object_version_number%TYPE;
13905: l_result_type_cd varchar2(30) := 'DISPLAY' ;
13906:
13907: /* cursor c_parent_result(c_parent_pk_id number,
13908: c_parent_table_alias varchar2,
13907: /* cursor c_parent_result(c_parent_pk_id number,
13908: c_parent_table_alias varchar2,
13909: c_copy_entity_txn_id number) is
13910: select copy_entity_result_id mirror_src_entity_result_id
13911: from ben_copy_entity_results cpe
13912: where cpe.information1 = c_parent_pk_id
13913: and cpe.result_type_cd = l_cv_result_type_cd
13914: and cpe.copy_entity_txn_id = c_copy_entity_txn_id
13915: and cpe.table_alias = c_parent_table_alias;
13925: FROM ben_eligy_criteria egl
13926: WHERE egl.eligy_criteria_id = cv_eligy_criteria_id
13927: AND NOT EXISTS (
13928: SELECT NULL
13929: FROM ben_copy_entity_results cpe
13930: WHERE copy_entity_txn_id = p_copy_entity_txn_id
13931: AND mirror_src_entity_result_id =
13932: cv_mirror_src_entity_result_id
13933: AND cpe.table_alias = cv_table_alias
13943: l_out_egl_result_id NUMBER (15);
13944: l_egl_table_route_id NUMBER (15);
13945: l_egl_result_type_cd VARCHAR2 (30);
13946: l_eligy_criteria_id NUMBER (15);
13947: l_egl_copy_entity_result_id ben_copy_entity_results.copy_entity_result_id%TYPE;
13948: l_egl_object_version_number ben_copy_entity_results.object_version_number%TYPE;
13949: l_flex_value_set_name fnd_flex_value_sets.flex_value_set_name%TYPE;
13950: --
13951: cursor c_object_exists(c_pk_id number,
13944: l_egl_table_route_id NUMBER (15);
13945: l_egl_result_type_cd VARCHAR2 (30);
13946: l_eligy_criteria_id NUMBER (15);
13947: l_egl_copy_entity_result_id ben_copy_entity_results.copy_entity_result_id%TYPE;
13948: l_egl_object_version_number ben_copy_entity_results.object_version_number%TYPE;
13949: l_flex_value_set_name fnd_flex_value_sets.flex_value_set_name%TYPE;
13950: --
13951: cursor c_object_exists(c_pk_id number,
13952: c_table_alias varchar2) is
13950: --
13951: cursor c_object_exists(c_pk_id number,
13952: c_table_alias varchar2) is
13953: select null
13954: from ben_copy_entity_results cpe
13955: where copy_entity_txn_id = p_copy_entity_txn_id
13956: and cpe.table_alias = c_table_alias
13957: and information1 = c_pk_id;
13958:
13959: l_dummy varchar2(1);
13960: l_mirror_src_entity_result_id number(15);
13961: l_table_route_id number(15);
13962: l_result_type_cd varchar2(30);
13963: l_information5 ben_copy_entity_results.information5%type;
13964: l_number_of_copies number(15);
13965: --
13966: begin
13967: --
14019: close c_value_set_name;
14020: --
14021: end if;
14022: --
14023: ben_copy_entity_results_api.create_copy_entity_results
14024: (
14025: p_copy_entity_result_id => l_egl_copy_entity_result_id,
14026: p_copy_entity_txn_id => p_copy_entity_txn_id,
14027: p_result_type_cd => l_egl_result_type_cd,