[Home] [Help]
27: ) is
28: --
29: -- Declare cursors and local variables
30: --
31: l_copy_entity_result_id ben_copy_entity_results.copy_entity_result_id%TYPE;
32: l_proc varchar2(72) := g_package||'create_copy_entity_result';
33: l_object_version_number ben_copy_entity_results.object_version_number%TYPE;
34: --
35:
29: -- Declare cursors and local variables
30: --
31: l_copy_entity_result_id ben_copy_entity_results.copy_entity_result_id%TYPE;
32: l_proc varchar2(72) := g_package||'create_copy_entity_result';
33: l_object_version_number ben_copy_entity_results.object_version_number%TYPE;
34: --
35:
36: cursor c_pln_from_parent(c_PLIP_ID number,c_pl_id number ) is
37: select distinct pln.pl_id,
82: where pln.pl_id = c_pl_id
83: -- and pln.business_group_id = p_business_group_id
84: and not exists (
85: select /*+ */ null
86: from ben_copy_entity_results cpe
87: -- ,pqh_table_route trt
88: where copy_entity_txn_id = p_copy_entity_txn_id
89: -- and trt.table_route_id = cpe.table_route_id
90: and ( c_mirror_src_entity_result_id is null or
104: -- c_parent_table_name varchar2,
105: c_parent_table_alias varchar2,
106: c_copy_entity_txn_id number) is
107: select copy_entity_result_id mirror_src_entity_result_id
108: from ben_copy_entity_results cpe
109: -- ,pqh_table_route trt
110: where cpe.information1= c_parent_pk_id
111: and cpe.result_type_cd = l_cv_result_type_cd
112: and cpe.copy_entity_txn_id = c_copy_entity_txn_id
119: cursor c_parent_result1(c_parent_pk_id number,
120: c_parent_table_alias varchar2,
121: c_copy_entity_txn_id number) is
122: select min(copy_entity_result_id) mirror_src_entity_result_id
123: from ben_copy_entity_results cpe
124: -- ,pqh_table_route trt
125: where cpe.information1= c_parent_pk_id
126: and cpe.copy_entity_txn_id = c_copy_entity_txn_id
127: -- and cpe.table_route_id = trt.table_route_id
145: -- c_parent_table_name varchar2,
146: c_parent_table_alias varchar2,
147: c_copy_entity_txn_id number) is
148: select min(cpe.information2) min_esd
149: from ben_copy_entity_results cpe
150: -- ,pqh_table_route trt
151: where cpe.information1= c_parent_pk_id
152: and cpe.copy_entity_txn_id = c_copy_entity_txn_id
153: -- and cpe.table_route_id = trt.table_route_id
199: where vgs.pl_gd_or_svc_id = c_pl_gd_or_svc_id
200: -- and vgs.business_group_id = p_business_group_id
201: and not exists (
202: select /*+ */ null
203: from ben_copy_entity_results cpe
204: -- ,pqh_table_route trt
205: where copy_entity_txn_id = p_copy_entity_txn_id
206: -- and trt.table_route_id = cpe.table_route_id
207: and ( -- c_mirror_src_entity_result_id is null or
231: where cwg.cwb_wksht_grp_id = c_cwb_wksht_grp_id
232: and cwg.business_group_id = p_business_group_id
233: and not exists (
234: select /*+ */ null
235: from ben_copy_entity_results cpe
236: -- ,pqh_table_route trt
237: where copy_entity_txn_id = p_copy_entity_txn_id
238: -- and trt.table_route_id = cpe.table_route_id
239: and ( --c_mirror_src_entity_result_id is null or
251: where cri.custom_key = to_char(c_cwb_wksht_grp_id)
252: and cri.custom_type like 'Cwb%PG'
253: and not exists (
254: select /*+ */ null
255: from ben_copy_entity_results cpe
256: where copy_entity_txn_id = p_copy_entity_txn_id
257: and (c_mirror_src_entity_result_id = c_mirror_src_entity_result_id )
258: and cpe.table_alias = c_table_alias
259: and information1 = c_cwb_wksht_grp_id
259: and information1 = c_cwb_wksht_grp_id
260: );
261:
262: l_cwb_wksht_grp_id number(15);
263: l_cri_information5 ben_copy_entity_results.information5%type;
264: l_cri_result_type_cd varchar2(30);
265: l_out_cri_result_id number(15);
266: l_out_cwg_result_id number(15);
267: ---------------------------------------------------------------
282: where vrp.vald_rlshp_for_reimb_id = c_vald_rlshp_for_reimb_id
283: -- and vrp.business_group_id = p_business_group_id
284: and not exists (
285: select /*+ */ null
286: from ben_copy_entity_results cpe
287: -- ,pqh_table_route trt
288: where copy_entity_txn_id = p_copy_entity_txn_id
289: -- and trt.table_route_id = cpe.table_route_id
290: and ( -- c_mirror_src_entity_result_id is null or
315: where wpn.wv_prtn_rsn_pl_id = c_wv_prtn_rsn_pl_id
316: -- and wpn.business_group_id = p_business_group_id
317: and not exists (
318: select /*+ */ null
319: from ben_copy_entity_results cpe
320: -- ,pqh_table_route trt
321: where copy_entity_txn_id = p_copy_entity_txn_id
322: -- and trt.table_route_id = cpe.table_route_id
323: and ( -- c_mirror_src_entity_result_id is null or
349: where brc.bnft_rstrn_ctfn_id = c_bnft_rstrn_ctfn_id
350: -- and brc.business_group_id = p_business_group_id
351: and not exists (
352: select /*+ */ null
353: from ben_copy_entity_results cpe
354: -- ,pqh_table_route trt
355: where copy_entity_txn_id = p_copy_entity_txn_id
356: -- and trt.table_route_id = cpe.table_route_id
357: and ( -- c_mirror_src_entity_result_id is null or
383: where lbr.ler_bnft_rstrn_id = c_ler_bnft_rstrn_id
384: -- and lbr.business_group_id = p_business_group_id
385: and not exists (
386: select /*+ */ null
387: from ben_copy_entity_results cpe
388: -- ,pqh_table_route trt
389: where copy_entity_txn_id = p_copy_entity_txn_id
390: -- and trt.table_route_id = cpe.table_route_id
391: and ( -- c_mirror_src_entity_result_id is null or
398: and information3 = lbr.effective_end_date
399: );
400: cursor c_lbr_drp(c_ler_bnft_rstrn_id number,c_mirror_src_entity_result_id number,c_table_alias varchar2) is
401: select distinct cpe.information257 ler_id
402: from ben_copy_entity_results cpe
403: -- ,pqh_table_route trt
404: where copy_entity_txn_id = p_copy_entity_txn_id
405: -- and trt.table_route_id = cpe.table_route_id
406: and mirror_src_entity_result_id = c_mirror_src_entity_result_id
429: where ecf.enrt_ctfn_id = c_enrt_ctfn_id
430: -- and ecf.business_group_id = p_business_group_id
431: and not exists (
432: select /*+ */ null
433: from ben_copy_entity_results cpe
434: -- ,pqh_table_route trt
435: where copy_entity_txn_id = p_copy_entity_txn_id
436: -- and trt.table_route_id = cpe.table_route_id
437: and ( -- c_mirror_src_entity_result_id is null or
462: where ldc.ler_chg_dpnt_cvg_id = c_ler_chg_dpnt_cvg_id
463: -- and ldc.business_group_id = p_business_group_id
464: and not exists (
465: select /*+ */ null
466: from ben_copy_entity_results cpe
467: -- ,pqh_table_route trt
468: where copy_entity_txn_id = p_copy_entity_txn_id
469: -- and trt.table_route_id = cpe.table_route_id
470: and ( -- c_mirror_src_entity_result_id is null or
477: and information3 = ldc.effective_end_date
478: );
479: cursor c_ldc_drp(c_ler_chg_dpnt_cvg_id number,c_mirror_src_entity_result_id number,c_table_alias varchar2) is
480: select distinct cpe.information257 ler_id
481: from ben_copy_entity_results cpe
482: -- ,pqh_table_route trt
483: where copy_entity_txn_id = p_copy_entity_txn_id
484: -- and trt.table_route_id = cpe.table_route_id
485: and mirror_src_entity_result_id = c_mirror_src_entity_result_id
508: where lpe.ler_chg_pl_nip_enrt_id = c_ler_chg_pl_nip_enrt_id
509: -- and lpe.business_group_id = p_business_group_id
510: and not exists (
511: select /*+ */ null
512: from ben_copy_entity_results cpe
513: -- ,pqh_table_route trt
514: where copy_entity_txn_id = p_copy_entity_txn_id
515: -- and trt.table_route_id = cpe.table_route_id
516: and ( -- c_mirror_src_entity_result_id is null or
523: and information3 = lpe.effective_end_date
524: );
525: cursor c_lpe_drp(c_ler_chg_pl_nip_enrt_id number,c_mirror_src_entity_result_id number,c_table_alias varchar2) is
526: select distinct cpe.information257 ler_id
527: from ben_copy_entity_results cpe
528: -- ,pqh_table_route trt
529: where copy_entity_txn_id = p_copy_entity_txn_id
530: -- and trt.table_route_id = cpe.table_route_id
531: and mirror_src_entity_result_id = c_mirror_src_entity_result_id
554: where lre.ler_rqrs_enrt_ctfn_id = c_ler_rqrs_enrt_ctfn_id
555: -- and lre.business_group_id = p_business_group_id
556: and not exists (
557: select /*+ */ null
558: from ben_copy_entity_results cpe
559: -- ,pqh_table_route trt
560: where copy_entity_txn_id = p_copy_entity_txn_id
561: -- and trt.table_route_id = cpe.table_route_id
562: and ( -- c_mirror_src_entity_result_id is null or
569: and information3 = lre.effective_end_date
570: );
571: cursor c_lre_drp(c_ler_rqrs_enrt_ctfn_id number,c_mirror_src_entity_result_id number,c_table_alias varchar2) is
572: select distinct cpe.information257 ler_id
573: from ben_copy_entity_results cpe
574: -- ,pqh_table_route trt
575: where copy_entity_txn_id = p_copy_entity_txn_id
576: -- and trt.table_route_id = cpe.table_route_id
577: and mirror_src_entity_result_id = c_mirror_src_entity_result_id
600: where pcp.pl_pcp_id = c_pl_pcp_id
601: -- and pcp.business_group_id = p_business_group_id
602: and not exists (
603: select /*+ */ null
604: from ben_copy_entity_results cpe
605: -- ,pqh_table_route trt
606: where copy_entity_txn_id = p_copy_entity_txn_id
607: -- and trt.table_route_id = cpe.table_route_id
608: and ( -- c_mirror_src_entity_result_id is null or
632: where pty.pl_pcp_typ_id = c_pl_pcp_typ_id
633: -- and pty.business_group_id = p_business_group_id
634: and not exists (
635: select /*+ */ null
636: from ben_copy_entity_results cpe
637: -- pqh_table_route trt
638: where copy_entity_txn_id = p_copy_entity_txn_id
639: -- and trt.table_route_id = cpe.table_route_id
640: and ( -- c_mirror_src_entity_result_id is null or
664: where pcx.pl_bnf_ctfn_id = c_pl_bnf_ctfn_id
665: -- and pcx.business_group_id = p_business_group_id
666: and not exists (
667: select /*+ */ null
668: from ben_copy_entity_results cpe
669: -- ,pqh_table_route trt
670: where copy_entity_txn_id = p_copy_entity_txn_id
671: -- and trt.table_route_id = cpe.table_route_id
672: and ( -- c_mirror_src_entity_result_id is null or
697: where pnd.pl_dpnt_cvg_ctfn_id = c_pl_dpnt_cvg_ctfn_id
698: -- and pnd.business_group_id = p_business_group_id
699: and not exists (
700: select /*+ */ null
701: from ben_copy_entity_results cpe
702: -- ,pqh_table_route trt
703: where copy_entity_txn_id = p_copy_entity_txn_id
704: -- and trt.table_route_id = cpe.table_route_id
705: and ( -- c_mirror_src_entity_result_id is null or
730: where peo.elig_to_prte_rsn_id = c_elig_to_prte_rsn_id
731: -- and peo.business_group_id = p_business_group_id
732: and not exists (
733: select /*+ */ null
734: from ben_copy_entity_results cpe
735: -- ,pqh_table_route trt
736: where copy_entity_txn_id = p_copy_entity_txn_id
737: -- and trt.table_route_id = cpe.table_route_id
738: and ( -- c_mirror_src_entity_result_id is null or
764: where gos.gd_or_svc_typ_id = c_gd_or_svc_typ_id
765: -- and gos.business_group_id = p_business_group_id
766: and not exists (
767: select /*+ */ null
768: from ben_copy_entity_results cpe
769: -- ,pqh_table_route trt
770: where copy_entity_txn_id = p_copy_entity_txn_id
771: -- and trt.table_route_id = cpe.table_route_id
772: and ( -- c_mirror_src_entity_result_id is null or
795: where pct.pl_gd_r_svc_ctfn_id = c_pl_gd_r_svc_ctfn_id
796: -- and pct.business_group_id = p_business_group_id
797: and not exists (
798: select /*+ */ null
799: from ben_copy_entity_results cpe
800: -- pqh_table_route trt
801: where copy_entity_txn_id = p_copy_entity_txn_id
802: -- and trt.table_route_id = cpe.table_route_id
803: and ( -- c_mirror_src_entity_result_id is null or
829: where prg.pl_regn_id = c_pl_regn_id
830: -- and prg.business_group_id = p_business_group_id
831: and not exists (
832: select /*+ */ null
833: from ben_copy_entity_results cpe
834: -- ,pqh_table_route trt
835: where copy_entity_txn_id = p_copy_entity_txn_id
836: -- and trt.table_route_id = cpe.table_route_id
837: and ( -- c_mirror_src_entity_result_id is null or
862: where reg.regn_id = c_regn_id
863: -- and reg.business_group_id = p_business_group_id
864: and not exists (
865: select /*+ */ null
866: from ben_copy_entity_results cpe
867: -- ,pqh_table_route trt
868: where copy_entity_txn_id = p_copy_entity_txn_id
869: -- and trt.table_route_id = cpe.table_route_id
870: and ( -- c_mirror_src_entity_result_id is null or
896: where bnr.rptg_grp_id = c_rptg_grp_id
897: -- and bnr.business_group_id = p_business_group_id
898: and not exists (
899: select /*+ */ null
900: from ben_copy_entity_results cpe
901: -- ,pqh_table_route trt
902: where copy_entity_txn_id = p_copy_entity_txn_id
903: -- and trt.table_route_id = cpe.table_route_id
904: and ( -- c_mirror_src_entity_result_id is null or
926: where wcn.wv_prtn_rsn_ctfn_pl_id = c_wv_prtn_rsn_ctfn_pl_id
927: -- and wcn.business_group_id = p_business_group_id
928: and not exists (
929: select /*+ */ null
930: from ben_copy_entity_results cpe
931: -- ,pqh_table_route trt
932: where copy_entity_txn_id = p_copy_entity_txn_id
933: -- and trt.table_route_id = cpe.table_route_id
934: and ( -- c_mirror_src_entity_result_id is null or
959: where lbc.ler_bnft_rstrn_ctfn_id = c_ler_bnft_rstrn_ctfn_id
960: -- and lbc.business_group_id = p_business_group_id
961: and not exists (
962: select /*+ */ null
963: from ben_copy_entity_results cpe
964: -- ,pqh_table_route trt
965: where copy_entity_txn_id = p_copy_entity_txn_id
966: -- and trt.table_route_id = cpe.table_route_id
967: and ( -- c_mirror_src_entity_result_id is null or
993: where lnc.ler_enrt_ctfn_id = c_ler_enrt_ctfn_id
994: -- and lnc.business_group_id = p_business_group_id
995: and not exists (
996: select /*+ */ null
997: from ben_copy_entity_results cpe
998: -- ,pqh_table_route trt
999: where copy_entity_txn_id = p_copy_entity_txn_id
1000: -- and trt.table_route_id = cpe.table_route_id
1001: and ( -- c_mirror_src_entity_result_id is null or
1026: where lcc.ler_chg_dpnt_cvg_ctfn_id = c_ler_chg_dpnt_cvg_ctfn_id
1027: -- and lcc.business_group_id = p_business_group_id
1028: and not exists (
1029: select /*+ */ null
1030: from ben_copy_entity_results cpe
1031: -- ,pqh_table_route trt
1032: where copy_entity_txn_id = p_copy_entity_txn_id
1033: -- and trt.table_route_id = cpe.table_route_id
1034: and ( -- c_mirror_src_entity_result_id is null or
1060: where ddr.dsgn_rqmt_id = c_dsgn_rqmt_id
1061: -- and ddr.business_group_id = p_business_group_id
1062: and not exists (
1063: select /*+ */ null
1064: from ben_copy_entity_results cpe
1065: -- pqh_table_route trt
1066: where copy_entity_txn_id = p_copy_entity_txn_id
1067: -- and trt.table_route_id = cpe.table_route_id
1068: and ( -- c_mirror_src_entity_result_id is null or
1094: where drr.dsgn_rqmt_rlshp_typ_id = c_dsgn_rqmt_rlshp_typ_id
1095: -- and drr.business_group_id = p_business_group_id
1096: and not exists (
1097: select /*+ */ null
1098: from ben_copy_entity_results cpe
1099: -- pqh_table_route trt
1100: where copy_entity_txn_id = p_copy_entity_txn_id
1101: -- and trt.table_route_id = cpe.table_route_id
1102: and ( -- c_mirror_src_entity_result_id is null or
1133: where prg.pl_regn_id = c_pl_regn_id
1134: -- and prg.business_group_id = p_business_group_id
1135: and not exists (
1136: select /*+ */ null
1137: from ben_copy_entity_results cpe
1138: -- pqh_table_route trt
1139: where copy_entity_txn_id = p_copy_entity_txn_id
1140: -- and trt.table_route_id = cpe.table_route_id
1141: and ( -- c_mirror_src_entity_result_id is null or
1167: where prb.pl_regy_bod_id = c_pl_regy_bod_id
1168: -- and prb.business_group_id = p_business_group_id
1169: and not exists (
1170: select /*+ */ null
1171: from ben_copy_entity_results cpe
1172: -- pqh_table_route trt
1173: where copy_entity_txn_id = p_copy_entity_txn_id
1174: -- and trt.table_route_id = cpe.table_route_id
1175: and ( -- c_mirror_src_entity_result_id is null or
1201: where prp.pl_regy_prps_id = c_pl_regy_prps_id
1202: -- and prp.business_group_id = p_business_group_id
1203: and not exists (
1204: select /*+ */ null
1205: from ben_copy_entity_results cpe
1206: -- pqh_table_route trt
1207: where copy_entity_txn_id = p_copy_entity_txn_id
1208: -- and trt.table_route_id = cpe.table_route_id
1209: and ( -- c_mirror_src_entity_result_id is null or
1235: where rgr.popl_rptg_grp_id = c_popl_rptg_grp_id
1236: -- and rgr.business_group_id = p_business_group_id
1237: and not exists (
1238: select /*+ */ null
1239: from ben_copy_entity_results cpe
1240: -- pqh_table_route trt
1241: where copy_entity_txn_id = p_copy_entity_txn_id
1242: -- and trt.table_route_id = cpe.table_route_id
1243: and ( -- c_mirror_src_entity_result_id is null or
1268: where reg.regn_id = c_regn_id
1269: -- and reg.business_group_id = p_business_group_id
1270: and not exists (
1271: select /*+ */ null
1272: from ben_copy_entity_results cpe
1273: --- pqh_table_route trt
1274: where copy_entity_txn_id = p_copy_entity_txn_id
1275: -- and trt.table_route_id = cpe.table_route_id
1276: and ( -- c_mirror_src_entity_result_id is null or
1289:
1290: cursor c_object_exists(c_pk_id number,
1291: c_table_alias varchar2) is
1292: select null
1293: from ben_copy_entity_results cpe
1294: -- pqh_table_route trt
1295: where copy_entity_txn_id = p_copy_entity_txn_id
1296: -- and trt.table_route_id = cpe.table_route_id
1297: and cpe.table_alias = c_table_alias
1301:
1302: l_table_route_id number(15);
1303: l_mirror_src_entity_result_id number(15);
1304: l_result_type_cd varchar2(30);
1305: l_information5 ben_copy_entity_results.information5%type;
1306: l_regn_name ben_regn_f.name%type;
1307: --
1308: l_pl_id number(15);
1309: l_popl_yr_perd_id number(15);
1453: end if;
1454: --
1455: l_copy_entity_result_id := null;
1456: l_object_version_number := null;
1457: ben_copy_entity_results_api.create_copy_entity_results(
1458: p_copy_entity_result_id => l_copy_entity_result_id,
1459: p_copy_entity_txn_id => p_copy_entity_txn_id,
1460: p_result_type_cd => l_result_type_cd,
1461: p_mirror_src_entity_result_id => l_mirror_src_entity_result_id,
2117: l_result_type_cd := 'DISPLAY';
2118: --
2119: l_copy_entity_result_id := null;
2120: l_object_version_number := null;
2121: ben_copy_entity_results_api.create_copy_entity_results(
2122: p_copy_entity_result_id => l_copy_entity_result_id,
2123: p_copy_entity_txn_id => p_copy_entity_txn_id,
2124: p_result_type_cd => l_result_type_cd,
2125: p_mirror_src_entity_result_id => l_mirror_src_entity_result_id,
2208: --
2209: l_copy_entity_result_id := null;
2210: l_object_version_number := null;
2211:
2212: ben_copy_entity_results_api.create_copy_entity_results(
2213: p_copy_entity_result_id => l_copy_entity_result_id,
2214: p_copy_entity_txn_id => p_copy_entity_txn_id,
2215: p_result_type_cd => l_cri_result_type_cd,
2216: p_mirror_src_entity_result_id => l_mirror_src_entity_result_id,
2330: */
2331:
2332: l_copy_entity_result_id := null;
2333: l_object_version_number := null;
2334: ben_copy_entity_results_api.create_copy_entity_results(
2335: p_copy_entity_result_id => l_copy_entity_result_id,
2336: p_copy_entity_txn_id => p_copy_entity_txn_id,
2337: p_result_type_cd => l_result_type_cd,
2338: p_mirror_src_entity_result_id => l_mirror_src_entity_result_id,
2500: end if;
2501: --
2502: l_copy_entity_result_id := null;
2503: l_object_version_number := null;
2504: ben_copy_entity_results_api.create_copy_entity_results(
2505: p_copy_entity_result_id => l_copy_entity_result_id,
2506: p_copy_entity_txn_id => p_copy_entity_txn_id,
2507: p_result_type_cd => l_result_type_cd,
2508: p_mirror_src_entity_result_id => l_mirror_src_entity_result_id,
2604: l_result_type_cd := 'DISPLAY';
2605: --
2606: l_copy_entity_result_id := null;
2607: l_object_version_number := null;
2608: ben_copy_entity_results_api.create_copy_entity_results(
2609: p_copy_entity_result_id => l_copy_entity_result_id,
2610: p_copy_entity_txn_id => p_copy_entity_txn_id,
2611: p_result_type_cd => l_result_type_cd,
2612: p_mirror_src_entity_result_id => l_mirror_src_entity_result_id,
2722: */
2723:
2724: l_copy_entity_result_id := null;
2725: l_object_version_number := null;
2726: ben_copy_entity_results_api.create_copy_entity_results(
2727: p_copy_entity_result_id => l_copy_entity_result_id,
2728: p_copy_entity_txn_id => p_copy_entity_txn_id,
2729: p_result_type_cd => l_result_type_cd,
2730: p_mirror_src_entity_result_id => l_mirror_src_entity_result_id,
2831: end if;
2832: --
2833: l_copy_entity_result_id := null;
2834: l_object_version_number := null;
2835: ben_copy_entity_results_api.create_copy_entity_results(
2836: p_copy_entity_result_id => l_copy_entity_result_id,
2837: p_copy_entity_txn_id => p_copy_entity_txn_id,
2838: p_result_type_cd => l_result_type_cd,
2839: p_mirror_src_entity_result_id => l_mirror_src_entity_result_id,
2931: end if;
2932: --
2933: l_copy_entity_result_id := null;
2934: l_object_version_number := null;
2935: ben_copy_entity_results_api.create_copy_entity_results(
2936: p_copy_entity_result_id => l_copy_entity_result_id,
2937: p_copy_entity_txn_id => p_copy_entity_txn_id,
2938: p_result_type_cd => l_result_type_cd,
2939: p_mirror_src_entity_result_id => l_mirror_src_entity_result_id,
3027: end if;
3028: --
3029: l_copy_entity_result_id := null;
3030: l_object_version_number := null;
3031: ben_copy_entity_results_api.create_copy_entity_results(
3032: p_copy_entity_result_id => l_copy_entity_result_id,
3033: p_copy_entity_txn_id => p_copy_entity_txn_id,
3034: p_result_type_cd => l_result_type_cd,
3035: p_mirror_src_entity_result_id => l_mirror_src_entity_result_id,
3148: end if;
3149: --
3150: l_copy_entity_result_id := null;
3151: l_object_version_number := null;
3152: ben_copy_entity_results_api.create_copy_entity_results(
3153: p_copy_entity_result_id => l_copy_entity_result_id,
3154: p_copy_entity_txn_id => p_copy_entity_txn_id,
3155: p_result_type_cd => l_result_type_cd,
3156: p_mirror_src_entity_result_id => l_mirror_src_entity_result_id,
3250: l_result_type_cd := 'DISPLAY';
3251: --
3252: l_copy_entity_result_id := null;
3253: l_object_version_number := null;
3254: ben_copy_entity_results_api.create_copy_entity_results(
3255: p_copy_entity_result_id => l_copy_entity_result_id,
3256: p_copy_entity_txn_id => p_copy_entity_txn_id,
3257: p_result_type_cd => l_result_type_cd,
3258: p_mirror_src_entity_result_id => l_mirror_src_entity_result_id,
3347: end if;
3348: --
3349: l_copy_entity_result_id := null;
3350: l_object_version_number := null;
3351: ben_copy_entity_results_api.create_copy_entity_results(
3352: p_copy_entity_result_id => l_copy_entity_result_id,
3353: p_copy_entity_txn_id => p_copy_entity_txn_id,
3354: p_result_type_cd => l_result_type_cd,
3355: p_mirror_src_entity_result_id => l_mirror_src_entity_result_id,
3475: end if;
3476: --
3477: l_copy_entity_result_id := null;
3478: l_object_version_number := null;
3479: ben_copy_entity_results_api.create_copy_entity_results(
3480: p_copy_entity_result_id => l_copy_entity_result_id,
3481: p_copy_entity_txn_id => p_copy_entity_txn_id,
3482: p_result_type_cd => l_result_type_cd,
3483: p_mirror_src_entity_result_id => l_mirror_src_entity_result_id,
3574: end if;
3575: --
3576: l_copy_entity_result_id := null;
3577: l_object_version_number := null;
3578: ben_copy_entity_results_api.create_copy_entity_results(
3579: p_copy_entity_result_id => l_copy_entity_result_id,
3580: p_copy_entity_txn_id => p_copy_entity_txn_id,
3581: p_result_type_cd => l_result_type_cd,
3582: p_mirror_src_entity_result_id => l_mirror_src_entity_result_id,
3667: end if;
3668: --
3669: l_copy_entity_result_id := null;
3670: l_object_version_number := null;
3671: ben_copy_entity_results_api.create_copy_entity_results(
3672: p_copy_entity_result_id => l_copy_entity_result_id,
3673: p_copy_entity_txn_id => p_copy_entity_txn_id,
3674: p_result_type_cd => l_result_type_cd,
3675: p_mirror_src_entity_result_id => l_mirror_src_entity_result_id,
3786: end if;
3787: --
3788: l_copy_entity_result_id := null;
3789: l_object_version_number := null;
3790: ben_copy_entity_results_api.create_copy_entity_results(
3791: p_copy_entity_result_id => l_copy_entity_result_id,
3792: p_copy_entity_txn_id => p_copy_entity_txn_id,
3793: p_result_type_cd => l_result_type_cd,
3794: p_mirror_src_entity_result_id => l_mirror_src_entity_result_id,
3901: end if;
3902: --
3903: l_copy_entity_result_id := null;
3904: l_object_version_number := null;
3905: ben_copy_entity_results_api.create_copy_entity_results(
3906: p_copy_entity_result_id => l_copy_entity_result_id,
3907: p_copy_entity_txn_id => p_copy_entity_txn_id,
3908: p_result_type_cd => l_result_type_cd,
3909: p_mirror_src_entity_result_id => l_mirror_src_entity_result_id,
4064: end if;
4065: --
4066: l_copy_entity_result_id := null;
4067: l_object_version_number := null;
4068: ben_copy_entity_results_api.create_copy_entity_results(
4069: p_copy_entity_result_id => l_copy_entity_result_id,
4070: p_copy_entity_txn_id => p_copy_entity_txn_id,
4071: p_result_type_cd => l_result_type_cd,
4072: p_mirror_src_entity_result_id => l_mirror_src_entity_result_id,
4182: end if;
4183: --
4184: l_copy_entity_result_id := null;
4185: l_object_version_number := null;
4186: ben_copy_entity_results_api.create_copy_entity_results(
4187: p_copy_entity_result_id => l_copy_entity_result_id,
4188: p_copy_entity_txn_id => p_copy_entity_txn_id,
4189: p_result_type_cd => l_result_type_cd,
4190: p_mirror_src_entity_result_id => l_mirror_src_entity_result_id,
4299: end if;
4300: --
4301: l_copy_entity_result_id := null;
4302: l_object_version_number := null;
4303: ben_copy_entity_results_api.create_copy_entity_results(
4304: p_copy_entity_result_id => l_copy_entity_result_id,
4305: p_copy_entity_txn_id => p_copy_entity_txn_id,
4306: p_result_type_cd => l_result_type_cd,
4307: p_mirror_src_entity_result_id => l_mirror_src_entity_result_id,
4450: end if;
4451: --
4452: l_copy_entity_result_id := null;
4453: l_object_version_number := null;
4454: ben_copy_entity_results_api.create_copy_entity_results(
4455: p_copy_entity_result_id => l_copy_entity_result_id,
4456: p_copy_entity_txn_id => p_copy_entity_txn_id,
4457: p_result_type_cd => l_result_type_cd,
4458: p_mirror_src_entity_result_id => l_mirror_src_entity_result_id,
4569: end if;
4570: --
4571: l_copy_entity_result_id := null;
4572: l_object_version_number := null;
4573: ben_copy_entity_results_api.create_copy_entity_results(
4574: p_copy_entity_result_id => l_copy_entity_result_id,
4575: p_copy_entity_txn_id => p_copy_entity_txn_id,
4576: p_result_type_cd => l_result_type_cd,
4577: p_mirror_src_entity_result_id => l_mirror_src_entity_result_id,
4725: end if;
4726: --
4727: l_copy_entity_result_id := null;
4728: l_object_version_number := null;
4729: ben_copy_entity_results_api.create_copy_entity_results(
4730: p_copy_entity_result_id => l_copy_entity_result_id,
4731: p_copy_entity_txn_id => p_copy_entity_txn_id,
4732: p_result_type_cd => l_result_type_cd,
4733: p_mirror_src_entity_result_id => l_mirror_src_entity_result_id,
4848: end if;
4849: --
4850: l_copy_entity_result_id := null;
4851: l_object_version_number := null;
4852: ben_copy_entity_results_api.create_copy_entity_results(
4853: p_copy_entity_result_id => l_copy_entity_result_id,
4854: p_copy_entity_txn_id => p_copy_entity_txn_id,
4855: p_result_type_cd => l_result_type_cd,
4856: p_mirror_src_entity_result_id => l_mirror_src_entity_result_id,
4960: l_result_type_cd := 'DISPLAY';
4961: --
4962: l_copy_entity_result_id := null;
4963: l_object_version_number := null;
4964: ben_copy_entity_results_api.create_copy_entity_results(
4965: p_copy_entity_result_id => l_copy_entity_result_id,
4966: p_copy_entity_txn_id => p_copy_entity_txn_id,
4967: p_result_type_cd => l_result_type_cd,
4968: p_mirror_src_entity_result_id => l_mirror_src_entity_result_id,
5060: l_result_type_cd := 'DISPLAY';
5061: --
5062: l_copy_entity_result_id := null;
5063: l_object_version_number := null;
5064: ben_copy_entity_results_api.create_copy_entity_results(
5065: p_copy_entity_result_id => l_copy_entity_result_id,
5066: p_copy_entity_txn_id => p_copy_entity_txn_id,
5067: p_result_type_cd => l_result_type_cd,
5068: p_mirror_src_entity_result_id => l_mirror_src_entity_result_id,
5160: end if;
5161: --
5162: l_copy_entity_result_id := null;
5163: l_object_version_number := null;
5164: ben_copy_entity_results_api.create_copy_entity_results(
5165: p_copy_entity_result_id => l_copy_entity_result_id,
5166: p_copy_entity_txn_id => p_copy_entity_txn_id,
5167: p_result_type_cd => l_result_type_cd,
5168: p_mirror_src_entity_result_id => l_mirror_src_entity_result_id,
5275: end if;
5276: --
5277: l_copy_entity_result_id := null;
5278: l_object_version_number := null;
5279: ben_copy_entity_results_api.create_copy_entity_results(
5280: p_copy_entity_result_id => l_copy_entity_result_id,
5281: p_copy_entity_txn_id => p_copy_entity_txn_id,
5282: p_result_type_cd => l_result_type_cd,
5283: p_mirror_src_entity_result_id => l_mirror_src_entity_result_id,
5391: end if;
5392: --
5393: l_copy_entity_result_id := null;
5394: l_object_version_number := null;
5395: ben_copy_entity_results_api.create_copy_entity_results(
5396: p_copy_entity_result_id => l_copy_entity_result_id,
5397: p_copy_entity_txn_id => p_copy_entity_txn_id,
5398: p_result_type_cd => l_result_type_cd,
5399: p_mirror_src_entity_result_id => l_mirror_src_entity_result_id,
5610: end if;
5611: --
5612: l_copy_entity_result_id := null;
5613: l_object_version_number := null;
5614: ben_copy_entity_results_api.create_copy_entity_results(
5615: p_copy_entity_result_id => l_copy_entity_result_id,
5616: p_copy_entity_txn_id => p_copy_entity_txn_id,
5617: p_result_type_cd => l_result_type_cd,
5618: p_mirror_src_entity_result_id => l_mirror_src_entity_result_id,
5711: l_result_type_cd := 'DISPLAY';
5712: --
5713: l_copy_entity_result_id := null;
5714: l_object_version_number := null;
5715: ben_copy_entity_results_api.create_copy_entity_results(
5716: p_copy_entity_result_id => l_copy_entity_result_id,
5717: p_copy_entity_txn_id => p_copy_entity_txn_id,
5718: p_result_type_cd => l_result_type_cd,
5719: p_mirror_src_entity_result_id => l_mirror_src_entity_result_id,
5858: ,p_no_dup_rslt => p_no_dup_rslt
5859: );
5860:
5861: if p_plan_in_program = 'Y' then
5862: update ben_copy_entity_results
5863: set information8 = NULL
5864: where information1 = p_pl_id
5865: and copy_entity_txn_id = p_copy_entity_txn_id
5866: and table_alias = 'PLN';
5885: ,p_effective_date in date
5886: ,p_parent_entity_result_id in number
5887: ) is
5888:
5889: l_copy_entity_result_id ben_copy_entity_results.copy_entity_result_id%TYPE;
5890: l_proc varchar2(72) := g_package||'create_popl_result';
5891: l_object_version_number ben_copy_entity_results.object_version_number%TYPE;
5892: --
5893: l_cv_result_type_cd varchar2(30) := 'DISPLAY' ;
5887: ) is
5888:
5889: l_copy_entity_result_id ben_copy_entity_results.copy_entity_result_id%TYPE;
5890: l_proc varchar2(72) := g_package||'create_popl_result';
5891: l_object_version_number ben_copy_entity_results.object_version_number%TYPE;
5892: --
5893: l_cv_result_type_cd varchar2(30) := 'DISPLAY' ;
5894: --
5895: -- Cursor to get mirror_src_entity_result_id
5897: -- c_parent_table_name varchar2,
5898: c_parent_table_alias varchar2,
5899: c_copy_entity_txn_id number) is
5900: select copy_entity_result_id mirror_src_entity_result_id
5901: from ben_copy_entity_results cpe
5902: -- pqh_table_route trt
5903: where cpe.information1= c_parent_pk_id
5904: and cpe.result_type_cd = l_cv_result_type_cd
5905: and cpe.copy_entity_txn_id = c_copy_entity_txn_id
5938: where pat.popl_actn_typ_id = c_popl_actn_typ_id
5939: -- and pat.business_group_id = p_business_group_id
5940: and not exists (
5941: select /*+ */ null
5942: from ben_copy_entity_results cpe
5943: -- pqh_table_route trt
5944: where copy_entity_txn_id = p_copy_entity_txn_id
5945: -- and trt.table_route_id = cpe.table_route_id
5946: and ( -- c_mirror_src_entity_result_id is null or
5971: where pet.popl_enrt_typ_cycl_id = c_popl_enrt_typ_cycl_id
5972: -- and pet.business_group_id = p_business_group_id
5973: and not exists (
5974: select /*+ */ null
5975: from ben_copy_entity_results cpe
5976: -- pqh_table_route trt
5977: where copy_entity_txn_id = p_copy_entity_txn_id
5978: -- and trt.table_route_id = cpe.table_route_id
5979: and ( -- c_mirror_src_entity_result_id is null or
6007: where cpo.popl_org_id = c_popl_org_id
6008: -- and cpo.business_group_id = p_business_group_id
6009: and not exists (
6010: select /*+ */ null
6011: from ben_copy_entity_results cpe
6012: -- pqh_table_route trt
6013: where copy_entity_txn_id = p_copy_entity_txn_id
6014: -- and trt.table_route_id = cpe.table_route_id
6015: and ( -- c_mirror_src_entity_result_id is null or
6060: where cpy.popl_yr_perd_id = c_popl_yr_perd_id
6061: -- and cpy.business_group_id = p_business_group_id
6062: and not exists (
6063: select /*+ */ null
6064: from ben_copy_entity_results cpe
6065: -- pqh_table_route trt
6066: where copy_entity_txn_id = p_copy_entity_txn_id
6067: -- and trt.table_route_id = cpe.table_route_id
6068: and ( -- c_mirror_src_entity_result_id is null or
6093: where rgr.popl_rptg_grp_id = c_popl_rptg_grp_id
6094: -- and rgr.business_group_id = p_business_group_id
6095: and not exists (
6096: select /*+ */ null
6097: from ben_copy_entity_results cpe
6098: --pqh_table_route trt
6099: where copy_entity_txn_id = p_copy_entity_txn_id
6100: -- and trt.table_route_id = cpe.table_route_id
6101: and ( -- c_mirror_src_entity_result_id is null or
6138: where cpr.popl_org_role_id = c_popl_org_role_id
6139: -- and cpr.business_group_id = p_business_group_id
6140: and not exists (
6141: select /*+ */ null
6142: from ben_copy_entity_results cpe
6143: -- pqh_table_route trt
6144: where copy_entity_txn_id = p_copy_entity_txn_id
6145: -- and trt.table_route_id = cpe.table_route_id
6146: and ( -- c_mirror_src_entity_result_id is null or
6171: where bnr.rptg_grp_id = c_rptg_grp_id
6172: -- and bnr.business_group_id = p_business_group_id
6173: and not exists (
6174: select /*+ */ null
6175: from ben_copy_entity_results cpe
6176: -- pqh_table_route trt
6177: where copy_entity_txn_id = p_copy_entity_txn_id
6178: -- and trt.table_route_id = cpe.table_route_id
6179: and ( -- c_mirror_src_entity_result_id is null or
6202: where len.lee_rsn_id = c_lee_rsn_id
6203: -- and len.business_group_id = p_business_group_id
6204: and not exists (
6205: select /*+ */ null
6206: from ben_copy_entity_results cpe
6207: -- pqh_table_route trt
6208: where copy_entity_txn_id = p_copy_entity_txn_id
6209: -- and trt.table_route_id = cpe.table_route_id
6210: and ( -- c_mirror_src_entity_result_id is null or
6218: );
6219: cursor c_len_drp(c_lee_rsn_id number,c_mirror_src_entity_result_id number,
6220: c_table_alias varchar2) is
6221: select distinct cpe.information257 ler_id
6222: from ben_copy_entity_results cpe,
6223: pqh_table_route trt
6224: where copy_entity_txn_id = p_copy_entity_txn_id
6225: and trt.table_route_id = cpe.table_route_id
6226: and mirror_src_entity_result_id = c_mirror_src_entity_result_id
6248: where enp.enrt_perd_id = c_enrt_perd_id
6249: -- and enp.business_group_id = p_business_group_id
6250: and not exists (
6251: select /*+ */ null
6252: from ben_copy_entity_results cpe
6253: -- pqh_table_route trt
6254: where copy_entity_txn_id = p_copy_entity_txn_id
6255: -- and trt.table_route_id = cpe.table_route_id
6256: and ( -- c_mirror_src_entity_result_id is null or
6321: where erp.enrt_perd_for_pl_id = c_enrt_perd_for_pl_id
6322: -- and erp.business_group_id = p_business_group_id
6323: and not exists (
6324: select /*+ */ null
6325: from ben_copy_entity_results cpe
6326: -- pqh_table_route trt
6327: where copy_entity_txn_id = p_copy_entity_txn_id
6328: -- and trt.table_route_id = cpe.table_route_id
6329: and ( -- c_mirror_src_entity_result_id is null or
6354: where ser.schedd_enrt_rl_id = c_schedd_enrt_rl_id
6355: -- and ser.business_group_id = p_business_group_id
6356: and not exists (
6357: select /*+ */ null
6358: from ben_copy_entity_results cpe
6359: -- pqh_table_route trt
6360: where copy_entity_txn_id = p_copy_entity_txn_id
6361: -- and trt.table_route_id = cpe.table_route_id
6362: and ( -- c_mirror_src_entity_result_id is null or
6387: where lrr.lee_rsn_rl_id = c_lee_rsn_rl_id
6388: -- and lrr.business_group_id = p_business_group_id
6389: and not exists (
6390: select /*+ */ null
6391: from ben_copy_entity_results cpe
6392: -- pqh_table_route trt
6393: where copy_entity_txn_id = p_copy_entity_txn_id
6394: -- and trt.table_route_id = cpe.table_route_id
6395: and ( -- c_mirror_src_entity_result_id is null or
6425: where erp.enrt_perd_for_pl_id = c_enrt_perd_for_pl_id
6426: -- and erp.business_group_id = p_business_group_id
6427: and not exists (
6428: select /*+ */ null
6429: from ben_copy_entity_results cpe
6430: -- pqh_table_route trt
6431: where copy_entity_txn_id = p_copy_entity_txn_id
6432: -- and trt.table_route_id = cpe.table_route_id
6433: and ( -- c_mirror_src_entity_result_id is null or
6459: where eat.actn_typ_id = c_actn_typ_id
6460: -- and eat.business_group_id = p_business_group_id
6461: and not exists (
6462: select /*+ */ null
6463: from ben_copy_entity_results cpe
6464: -- pqh_table_route trt
6465: where copy_entity_txn_id = p_copy_entity_txn_id
6466: -- and trt.table_route_id = cpe.table_route_id
6467: and ( -- c_mirror_src_entity_result_id is null or
6490: where prg.pl_regn_id = c_pl_regn_id
6491: -- and prg.business_group_id = p_business_group_id
6492: and not exists (
6493: select /*+ */ null
6494: from ben_copy_entity_results cpe
6495: -- pqh_table_route trt
6496: where copy_entity_txn_id = p_copy_entity_txn_id
6497: -- and trt.table_route_id = cpe.table_route_id
6498: and ( -- c_mirror_src_entity_result_id is null or
6524: where prb.pl_regy_bod_id = c_pl_regy_bod_id
6525: -- and prb.business_group_id = p_business_group_id
6526: and not exists (
6527: select /*+ */ null
6528: from ben_copy_entity_results cpe
6529: -- pqh_table_route trt
6530: where copy_entity_txn_id = p_copy_entity_txn_id
6531: -- and trt.table_route_id = cpe.table_route_id
6532: and ( -- c_mirror_src_entity_result_id is null or
6558: where prp.pl_regy_prps_id = c_pl_regy_prps_id
6559: -- and prp.business_group_id = p_business_group_id
6560: and not exists (
6561: select /*+ */ null
6562: from ben_copy_entity_results cpe
6563: -- pqh_table_route trt
6564: where copy_entity_txn_id = p_copy_entity_txn_id
6565: -- and trt.table_route_id = cpe.table_route_id
6566: and ( -- c_mirror_src_entity_result_id is null or
6592: where rgr.popl_rptg_grp_id = c_popl_rptg_grp_id
6593: -- and rgr.business_group_id = p_business_group_id
6594: and not exists (
6595: select /*+ */ null
6596: from ben_copy_entity_results cpe
6597: -- pqh_table_route trt
6598: where copy_entity_txn_id = p_copy_entity_txn_id
6599: -- and trt.table_route_id = cpe.table_route_id
6600: and ( -- c_mirror_src_entity_result_id is null or
6624: where reg.regn_id = c_regn_id
6625: -- and reg.business_group_id = p_business_group_id
6626: and not exists (
6627: select /*+ */ null
6628: from ben_copy_entity_results cpe
6629: -- pqh_table_route trt
6630: where copy_entity_txn_id = p_copy_entity_txn_id
6631: -- and trt.table_route_id = cpe.table_route_id
6632: and ( -- c_mirror_src_entity_result_id is null or
6646:
6647: cursor c_object_exists(c_pk_id number,
6648: c_table_alias varchar2) is
6649: select null
6650: from ben_copy_entity_results cpe
6651: -- pqh_table_route trt
6652: where copy_entity_txn_id = p_copy_entity_txn_id
6653: -- and trt.table_route_id = cpe.table_route_id
6654: and cpe.table_alias = c_table_alias
6658:
6659: l_table_route_id number(15);
6660: l_mirror_src_entity_result_id number(15):= p_copy_entity_result_id;
6661: l_result_type_cd varchar2(30);
6662: l_information5 ben_copy_entity_results.information5%type;
6663: l_regn_name ben_regn_f.name%type;
6664: --
6665: l_pl_id number(15);
6666: l_popl_yr_perd_id number(15);
6724: end if;
6725: --
6726: l_copy_entity_result_id := null;
6727: l_object_version_number := null;
6728: ben_copy_entity_results_api.create_copy_entity_results(
6729: p_copy_entity_result_id => l_copy_entity_result_id,
6730: p_copy_entity_txn_id => p_copy_entity_txn_id,
6731: p_result_type_cd => l_result_type_cd,
6732: p_mirror_src_entity_result_id => l_mirror_src_entity_result_id,
6836: l_result_type_cd := 'DISPLAY';
6837: --
6838: l_copy_entity_result_id := null;
6839: l_object_version_number := null;
6840: ben_copy_entity_results_api.create_copy_entity_results(
6841: p_copy_entity_result_id => l_copy_entity_result_id,
6842: p_copy_entity_txn_id => p_copy_entity_txn_id,
6843: p_result_type_cd => l_result_type_cd,
6844: p_mirror_src_entity_result_id => l_mirror_src_entity_result_id,
6941: end if;
6942: --
6943: l_copy_entity_result_id := null;
6944: l_object_version_number := null;
6945: ben_copy_entity_results_api.create_copy_entity_results(
6946: p_copy_entity_result_id => l_copy_entity_result_id,
6947: p_copy_entity_txn_id => p_copy_entity_txn_id,
6948: p_result_type_cd => l_result_type_cd,
6949: p_mirror_src_entity_result_id => l_mirror_src_entity_result_id,
7072: l_mapping_column_name2,
7073: p_copy_entity_txn_id);
7074: --
7075:
7076: ben_copy_entity_results_api.create_copy_entity_results(
7077: p_copy_entity_result_id => l_copy_entity_result_id,
7078: p_copy_entity_txn_id => p_copy_entity_txn_id,
7079: p_result_type_cd => l_result_type_cd,
7080: p_mirror_src_entity_result_id => l_mirror_src_entity_result_id,
7311: end if;
7312: --
7313: l_copy_entity_result_id := null;
7314: l_object_version_number := null;
7315: ben_copy_entity_results_api.create_copy_entity_results(
7316: p_copy_entity_result_id => l_copy_entity_result_id,
7317: p_copy_entity_txn_id => p_copy_entity_txn_id,
7318: p_result_type_cd => l_result_type_cd,
7319: p_mirror_src_entity_result_id => l_mirror_src_entity_result_id,
7465: end if;
7466: --
7467: l_copy_entity_result_id := null;
7468: l_object_version_number := null;
7469: ben_copy_entity_results_api.create_copy_entity_results(
7470: p_copy_entity_result_id => l_copy_entity_result_id,
7471: p_copy_entity_txn_id => p_copy_entity_txn_id,
7472: p_result_type_cd => l_result_type_cd,
7473: p_mirror_src_entity_result_id => l_mirror_src_entity_result_id,
7579: end if;
7580: --
7581: l_copy_entity_result_id := null;
7582: l_object_version_number := null;
7583: ben_copy_entity_results_api.create_copy_entity_results(
7584: p_copy_entity_result_id => l_copy_entity_result_id,
7585: p_copy_entity_txn_id => p_copy_entity_txn_id,
7586: p_result_type_cd => l_result_type_cd,
7587: p_mirror_src_entity_result_id => l_mirror_src_entity_result_id,
7782: end if;
7783: --
7784: l_copy_entity_result_id := null;
7785: l_object_version_number := null;
7786: ben_copy_entity_results_api.create_copy_entity_results(
7787: p_copy_entity_result_id => l_copy_entity_result_id,
7788: p_copy_entity_txn_id => p_copy_entity_txn_id,
7789: p_result_type_cd => l_result_type_cd,
7790: p_mirror_src_entity_result_id => l_mirror_src_entity_result_id,
7888: end if;
7889: --
7890: l_copy_entity_result_id := null;
7891: l_object_version_number := null;
7892: ben_copy_entity_results_api.create_copy_entity_results(
7893: p_copy_entity_result_id => l_copy_entity_result_id,
7894: p_copy_entity_txn_id => p_copy_entity_txn_id,
7895: p_result_type_cd => l_result_type_cd,
7896: p_mirror_src_entity_result_id => l_mirror_src_entity_result_id,
8049: --
8050:
8051: l_copy_entity_result_id := null;
8052: l_object_version_number := null;
8053: ben_copy_entity_results_api.create_copy_entity_results(
8054: p_copy_entity_result_id => l_copy_entity_result_id,
8055: p_copy_entity_txn_id => p_copy_entity_txn_id,
8056: p_result_type_cd => l_result_type_cd,
8057: p_mirror_src_entity_result_id => l_mirror_src_entity_result_id,
8152: end if;
8153: --
8154: l_copy_entity_result_id := null;
8155: l_object_version_number := null;
8156: ben_copy_entity_results_api.create_copy_entity_results(
8157: p_copy_entity_result_id => l_copy_entity_result_id,
8158: p_copy_entity_txn_id => p_copy_entity_txn_id,
8159: p_result_type_cd => l_result_type_cd,
8160: p_mirror_src_entity_result_id => l_mirror_src_entity_result_id,
8247: l_result_type_cd := 'DISPLAY';
8248: --
8249: l_copy_entity_result_id := null;
8250: l_object_version_number := null;
8251: ben_copy_entity_results_api.create_copy_entity_results(
8252: p_copy_entity_result_id => l_copy_entity_result_id,
8253: p_copy_entity_txn_id => p_copy_entity_txn_id,
8254: p_result_type_cd => l_result_type_cd,
8255: p_mirror_src_entity_result_id => l_mirror_src_entity_result_id,
8373: end if;
8374: --
8375: l_copy_entity_result_id := null;
8376: l_object_version_number := null;
8377: ben_copy_entity_results_api.create_copy_entity_results(
8378: p_copy_entity_result_id => l_copy_entity_result_id,
8379: p_copy_entity_txn_id => p_copy_entity_txn_id,
8380: p_result_type_cd => l_result_type_cd,
8381: p_mirror_src_entity_result_id => l_mirror_src_entity_result_id,
8470: l_result_type_cd := 'DISPLAY';
8471: --
8472: l_copy_entity_result_id := null;
8473: l_object_version_number := null;
8474: ben_copy_entity_results_api.create_copy_entity_results(
8475: p_copy_entity_result_id => l_copy_entity_result_id,
8476: p_copy_entity_txn_id => p_copy_entity_txn_id,
8477: p_result_type_cd => l_result_type_cd,
8478: p_mirror_src_entity_result_id => l_mirror_src_entity_result_id,
8588: */
8589:
8590: l_copy_entity_result_id := null;
8591: l_object_version_number := null;
8592: ben_copy_entity_results_api.create_copy_entity_results(
8593: p_copy_entity_result_id => l_copy_entity_result_id,
8594: p_copy_entity_txn_id => p_copy_entity_txn_id,
8595: p_result_type_cd => l_result_type_cd,
8596: p_mirror_src_entity_result_id => l_mirror_src_entity_result_id,
8698: end if;
8699: --
8700: l_copy_entity_result_id := null;
8701: l_object_version_number := null;
8702: ben_copy_entity_results_api.create_copy_entity_results(
8703: p_copy_entity_result_id => l_copy_entity_result_id,
8704: p_copy_entity_txn_id => p_copy_entity_txn_id,
8705: p_result_type_cd => l_result_type_cd,
8706: p_mirror_src_entity_result_id => l_mirror_src_entity_result_id,
8798: end if;
8799: --
8800: l_copy_entity_result_id := null;
8801: l_object_version_number := null;
8802: ben_copy_entity_results_api.create_copy_entity_results(
8803: p_copy_entity_result_id => l_copy_entity_result_id,
8804: p_copy_entity_txn_id => p_copy_entity_txn_id,
8805: p_result_type_cd => l_result_type_cd,
8806: p_mirror_src_entity_result_id => l_mirror_src_entity_result_id,
8894: end if;
8895: --
8896: l_copy_entity_result_id := null;
8897: l_object_version_number := null;
8898: ben_copy_entity_results_api.create_copy_entity_results(
8899: p_copy_entity_result_id => l_copy_entity_result_id,
8900: p_copy_entity_txn_id => p_copy_entity_txn_id,
8901: p_result_type_cd => l_result_type_cd,
8902: p_mirror_src_entity_result_id => l_mirror_src_entity_result_id,
9011: ,p_effective_date in date
9012: ,p_no_dup_rslt in varchar2 default null
9013: ) is
9014: --
9015: l_copy_entity_result_id ben_copy_entity_results.copy_entity_result_id%TYPE;
9016: l_proc varchar2(72) := g_package||'create_ler_result';
9017: l_object_version_number ben_copy_entity_results.object_version_number%TYPE;
9018: --
9019: --
9013: ) is
9014: --
9015: l_copy_entity_result_id ben_copy_entity_results.copy_entity_result_id%TYPE;
9016: l_proc varchar2(72) := g_package||'create_ler_result';
9017: l_object_version_number ben_copy_entity_results.object_version_number%TYPE;
9018: --
9019: --
9020: -- Bug : 3752407 : Global cursor g_table_route will now be used
9021: --
9034: -- c_parent_table_name varchar2,
9035: c_parent_table_alias varchar2,
9036: c_copy_entity_txn_id number) is
9037: select copy_entity_result_id mirror_src_entity_result_id
9038: from ben_copy_entity_results cpe
9039: -- pqh_table_route trt
9040: where cpe.information1= c_parent_pk_id
9041: and cpe.result_type_cd = l_cv_result_type_cd
9042: and cpe.copy_entity_txn_id = c_copy_entity_txn_id
9055: where ler.ler_id = c_ler_id
9056: -- and ler.business_group_id = p_business_group_id
9057: and not exists (
9058: select /*+ */ null
9059: from ben_copy_entity_results cpe
9060: -- pqh_table_route trt
9061: where copy_entity_txn_id = p_copy_entity_txn_id
9062: -- and trt.table_route_id = cpe.table_route_id
9063: and ( -- c_mirror_src_entity_result_id is null or
9086: where csr.css_rltd_per_per_in_ler_id = c_css_rltd_per_per_in_ler_id
9087: -- and csr.business_group_id = p_business_group_id
9088: and not exists (
9089: select /*+ */ null
9090: from ben_copy_entity_results cpe
9091: -- pqh_table_route trt
9092: where copy_entity_txn_id = p_copy_entity_txn_id
9093: -- and trt.table_route_id = cpe.table_route_id
9094: and ( -- c_mirror_src_entity_result_id is null or
9123: where lpl.ler_per_info_cs_ler_id = c_ler_per_info_cs_ler_id
9124: -- and lpl.business_group_id = p_business_group_id
9125: and not exists (
9126: select /*+ */ null
9127: from ben_copy_entity_results cpe
9128: -- pqh_table_route trt
9129: where copy_entity_txn_id = p_copy_entity_txn_id
9130: -- and trt.table_route_id = cpe.table_route_id
9131: and ( -- c_mirror_src_entity_result_id is null or
9155: where lrc.ler_rltd_per_cs_ler_id = c_ler_rltd_per_cs_ler_id
9156: -- and lrc.business_group_id = p_business_group_id
9157: and not exists (
9158: select /*+ */ null
9159: from ben_copy_entity_results cpe
9160: -- pqh_table_route trt
9161: where copy_entity_txn_id = p_copy_entity_txn_id
9162: -- and trt.table_route_id = cpe.table_route_id
9163: and ( -- c_mirror_src_entity_result_id is null or
9190: where psl.per_info_chg_cs_ler_id = c_per_info_chg_cs_ler_id
9191: -- and psl.business_group_id = p_business_group_id
9192: and not exists (
9193: select /*+ */ null
9194: from ben_copy_entity_results cpe
9195: -- pqh_table_route trt
9196: where copy_entity_txn_id = p_copy_entity_txn_id
9197: -- and trt.table_route_id = cpe.table_route_id
9198: and ( -- c_mirror_src_entity_result_id is null or
9243: where rcl.rltd_per_chg_cs_ler_id = c_rltd_per_chg_cs_ler_id
9244: -- and rcl.business_group_id = p_business_group_id
9245: and not exists (
9246: select /*+ */ null
9247: from ben_copy_entity_results cpe
9248: -- pqh_table_route trt
9249: where copy_entity_txn_id = p_copy_entity_txn_id
9250: -- and trt.table_route_id = cpe.table_route_id
9251: and ( -- c_mirror_src_entity_result_id is null or
9264:
9265: cursor c_object_exists(c_pk_id number,
9266: c_table_alias varchar2) is
9267: select null
9268: from ben_copy_entity_results cpe
9269: -- pqh_table_route trt
9270: where copy_entity_txn_id = p_copy_entity_txn_id
9271: -- and trt.table_route_id = cpe.table_route_id
9272: and cpe.table_alias = c_table_alias
9276:
9277: l_table_route_id number(15);
9278: l_mirror_src_entity_result_id number(15);
9279: l_result_type_cd varchar2(30);
9280: l_information5 ben_copy_entity_results.information5%type;
9281: l_ler_id number(15);
9282: l_number_of_copies number(15);
9283: l_css_rltd_per_per_in_ler_id number(15);
9284: l_ler_per_info_cs_ler_id number(15);
9332: end if;
9333: --
9334: l_copy_entity_result_id := null;
9335: l_object_version_number := null;
9336: ben_copy_entity_results_api.create_copy_entity_results(
9337: p_copy_entity_result_id => l_copy_entity_result_id,
9338: p_copy_entity_txn_id => p_copy_entity_txn_id,
9339: p_result_type_cd => l_result_type_cd,
9340: p_mirror_src_entity_result_id => l_mirror_src_entity_result_id,
9474: end if;
9475: --
9476: l_copy_entity_result_id := null;
9477: l_object_version_number := null;
9478: ben_copy_entity_results_api.create_copy_entity_results(
9479: p_copy_entity_result_id => l_copy_entity_result_id,
9480: p_copy_entity_txn_id => p_copy_entity_txn_id,
9481: p_result_type_cd => l_result_type_cd,
9482: p_mirror_src_entity_result_id => l_mirror_src_entity_result_id,
9572: end if;
9573: --
9574: l_copy_entity_result_id := null;
9575: l_object_version_number := null;
9576: ben_copy_entity_results_api.create_copy_entity_results(
9577: p_copy_entity_result_id => l_copy_entity_result_id,
9578: p_copy_entity_txn_id => p_copy_entity_txn_id,
9579: p_result_type_cd => l_result_type_cd,
9580: p_mirror_src_entity_result_id => l_mirror_src_entity_result_id,
9718: end if;
9719: --
9720: l_copy_entity_result_id := null;
9721: l_object_version_number := null;
9722: ben_copy_entity_results_api.create_copy_entity_results(
9723: p_copy_entity_result_id => l_copy_entity_result_id,
9724: p_copy_entity_txn_id => p_copy_entity_txn_id,
9725: p_result_type_cd => l_result_type_cd,
9726: p_mirror_src_entity_result_id => l_mirror_src_entity_result_id,
9847: end if;
9848: --
9849: l_copy_entity_result_id := null;
9850: l_object_version_number := null;
9851: ben_copy_entity_results_api.create_copy_entity_results(
9852: p_copy_entity_result_id => l_copy_entity_result_id,
9853: p_copy_entity_txn_id => p_copy_entity_txn_id,
9854: p_result_type_cd => l_result_type_cd,
9855: p_mirror_src_entity_result_id => l_mirror_src_entity_result_id,
9954: end if;
9955: --
9956: l_copy_entity_result_id := null;
9957: l_object_version_number := null;
9958: ben_copy_entity_results_api.create_copy_entity_results(
9959: p_copy_entity_result_id => l_copy_entity_result_id,
9960: p_copy_entity_txn_id => p_copy_entity_txn_id,
9961: p_result_type_cd => l_result_type_cd,
9962: p_mirror_src_entity_result_id => l_mirror_src_entity_result_id,
10062: ,p_parent_entity_result_id in number
10063: ,p_no_dup_rslt in varchar2 default null
10064: ) is
10065: --
10066: l_copy_entity_result_id ben_copy_entity_results.copy_entity_result_id%TYPE;
10067: l_proc varchar2(72) := g_package||'create_popl_result';
10068: l_object_version_number ben_copy_entity_results.object_version_number%TYPE;
10069: --
10070: l_result_type_cd varchar2(30) := 'DISPLAY' ;
10064: ) is
10065: --
10066: l_copy_entity_result_id ben_copy_entity_results.copy_entity_result_id%TYPE;
10067: l_proc varchar2(72) := g_package||'create_popl_result';
10068: l_object_version_number ben_copy_entity_results.object_version_number%TYPE;
10069: --
10070: l_result_type_cd varchar2(30) := 'DISPLAY' ;
10071: -- Cursor to get mirror_src_entity_result_id
10072: cursor c_parent_result(c_parent_pk_id number,
10072: cursor c_parent_result(c_parent_pk_id number,
10073: c_parent_table_alias varchar2,
10074: c_copy_entity_txn_id number) is
10075: select copy_entity_result_id mirror_src_entity_result_id
10076: from ben_copy_entity_results cpe
10077: -- pqh_table_route trt
10078: where cpe.information1 = c_parent_pk_id
10079: and cpe.result_type_cd = l_result_type_cd
10080: and cpe.copy_entity_txn_id = c_copy_entity_txn_id
10100: where cop.oipl_id = c_oipl_id
10101: -- and cop.business_group_id = p_business_group_id
10102: and not exists (
10103: select /*+ */ null
10104: from ben_copy_entity_results cpe
10105: -- pqh_table_route trt
10106: where copy_entity_txn_id = p_copy_entity_txn_id
10107: -- and trt.table_route_id = cpe.table_route_id
10108: and ( -- c_mirror_src_entity_result_id is null or
10134: where ddr.dsgn_rqmt_id = c_dsgn_rqmt_id
10135: -- and ddr.business_group_id = p_business_group_id
10136: and not exists (
10137: select /*+ */ null
10138: from ben_copy_entity_results cpe
10139: -- pqh_table_route trt
10140: where copy_entity_txn_id = p_copy_entity_txn_id
10141: -- and trt.table_route_id = cpe.table_route_id
10142: and ( -- c_mirror_src_entity_result_id is null or
10168: where drr.dsgn_rqmt_rlshp_typ_id = c_dsgn_rqmt_rlshp_typ_id
10169: -- and drr.business_group_id = p_business_group_id
10170: and not exists (
10171: select /*+ */ null
10172: from ben_copy_entity_results cpe
10173: -- pqh_table_route trt
10174: where copy_entity_txn_id = p_copy_entity_txn_id
10175: -- and trt.table_route_id = cpe.table_route_id
10176: and ( -- c_mirror_src_entity_result_id is null or
10199: where peo.elig_to_prte_rsn_id = c_elig_to_prte_rsn_id
10200: -- and peo.business_group_id = p_business_group_id
10201: and not exists (
10202: select /*+ */ null
10203: from ben_copy_entity_results cpe
10204: -- pqh_table_route trt
10205: where copy_entity_txn_id = p_copy_entity_txn_id
10206: -- and trt.table_route_id = cpe.table_route_id
10207: and ( -- c_mirror_src_entity_result_id is null or
10231: where lop.ler_chg_oipl_enrt_id = c_ler_chg_oipl_enrt_id
10232: -- and lop.business_group_id = p_business_group_id
10233: and not exists (
10234: select /*+ */ null
10235: from ben_copy_entity_results cpe
10236: -- pqh_table_route trt
10237: where copy_entity_txn_id = p_copy_entity_txn_id
10238: -- and trt.table_route_id = cpe.table_route_id
10239: and ( -- c_mirror_src_entity_result_id is null or
10248: l_ler_chg_oipl_enrt_id number(15);
10249: l_out_lop_result_id number(15);
10250: cursor c_lop_drp(c_ler_chg_oipl_enrt_id number,c_mirror_src_entity_result_id number,c_table_alias varchar2) is
10251: select distinct cpe.information257 ler_id
10252: from ben_copy_entity_results cpe
10253: -- pqh_table_route trt
10254: where copy_entity_txn_id = p_copy_entity_txn_id
10255: -- and trt.table_route_id = cpe.table_route_id
10256: and mirror_src_entity_result_id = c_mirror_src_entity_result_id
10277: where ecf.enrt_ctfn_id = c_enrt_ctfn_id
10278: -- and ecf.business_group_id = p_business_group_id
10279: and not exists (
10280: select /*+ */ null
10281: from ben_copy_entity_results cpe
10282: -- pqh_table_route trt
10283: where copy_entity_txn_id = p_copy_entity_txn_id
10284: -- and trt.table_route_id = cpe.table_route_id
10285: and ( -- c_mirror_src_entity_result_id is null or
10309: where lre.ler_rqrs_enrt_ctfn_id = c_ler_rqrs_enrt_ctfn_id
10310: -- and lre.business_group_id = p_business_group_id
10311: and not exists (
10312: select /*+ */ null
10313: from ben_copy_entity_results cpe
10314: -- pqh_table_route trt
10315: where copy_entity_txn_id = p_copy_entity_txn_id
10316: -- and trt.table_route_id = cpe.table_route_id
10317: and ( -- c_mirror_src_entity_result_id is null or
10325: );
10326: l_out_lre_result_id number(15);
10327: cursor c_lre1_drp(c_ler_rqrs_enrt_ctfn_id number,c_mirror_src_entity_result_id number,c_table_alias varchar2) is
10328: select distinct cpe.information257 ler_id
10329: from ben_copy_entity_results cpe
10330: -- pqh_table_route trt
10331: where copy_entity_txn_id = p_copy_entity_txn_id
10332: -- and trt.table_route_id = cpe.table_route_id
10333: and mirror_src_entity_result_id = c_mirror_src_entity_result_id
10353: where lnc.ler_enrt_ctfn_id = c_ler_enrt_ctfn_id
10354: -- and lnc.business_group_id = p_business_group_id
10355: and not exists (
10356: select /*+ */ null
10357: from ben_copy_entity_results cpe
10358: -- pqh_table_route trt
10359: where copy_entity_txn_id = p_copy_entity_txn_id
10360: -- and trt.table_route_id = cpe.table_route_id
10361: and ( -- c_mirror_src_entity_result_id is null or
10379:
10380: l_mirror_src_entity_result_id number;
10381: l_parent_entity_result_id number;
10382: l_table_route_id number;
10383: l_information5 ben_copy_entity_results.information5%TYPE;
10384: l_number_of_copies number := p_number_of_copies ;
10385: --
10386: L_ELIG_TO_PRTE_RSN_ID number;
10387:
10420: end if;
10421: --
10422: l_copy_entity_result_id := null;
10423: l_object_version_number := null;
10424: ben_copy_entity_results_api.create_copy_entity_results(
10425: p_copy_entity_result_id => l_copy_entity_result_id,
10426: p_copy_entity_txn_id => p_copy_entity_txn_id,
10427: p_result_type_cd => l_result_type_cd,
10428: p_mirror_src_entity_result_id => l_mirror_src_entity_result_id,
10719: end if;
10720: --
10721: l_copy_entity_result_id := null;
10722: l_object_version_number := null;
10723: ben_copy_entity_results_api.create_copy_entity_results(
10724: p_copy_entity_result_id => l_copy_entity_result_id,
10725: p_copy_entity_txn_id => p_copy_entity_txn_id,
10726: p_result_type_cd => l_result_type_cd,
10727: p_mirror_src_entity_result_id => l_mirror_src_entity_result_id,
10820: l_result_type_cd := 'DISPLAY';
10821: --
10822: l_copy_entity_result_id := null;
10823: l_object_version_number := null;
10824: ben_copy_entity_results_api.create_copy_entity_results(
10825: p_copy_entity_result_id => l_copy_entity_result_id,
10826: p_copy_entity_txn_id => p_copy_entity_txn_id,
10827: p_result_type_cd => l_result_type_cd,
10828: p_mirror_src_entity_result_id => l_mirror_src_entity_result_id,
10921: end if;
10922: --
10923: l_copy_entity_result_id := null;
10924: l_object_version_number := null;
10925: ben_copy_entity_results_api.create_copy_entity_results(
10926: p_copy_entity_result_id => l_copy_entity_result_id,
10927: p_copy_entity_txn_id => p_copy_entity_txn_id,
10928: p_result_type_cd => l_result_type_cd,
10929: p_mirror_src_entity_result_id => l_mirror_src_entity_result_id,
11051: end if;
11052: --
11053: l_copy_entity_result_id := null;
11054: l_object_version_number := null;
11055: ben_copy_entity_results_api.create_copy_entity_results(
11056: p_copy_entity_result_id => l_copy_entity_result_id,
11057: p_copy_entity_txn_id => p_copy_entity_txn_id,
11058: p_result_type_cd => l_result_type_cd,
11059: p_mirror_src_entity_result_id => l_mirror_src_entity_result_id,
11229: end if;
11230: --
11231: l_copy_entity_result_id := null;
11232: l_object_version_number := null;
11233: ben_copy_entity_results_api.create_copy_entity_results(
11234: p_copy_entity_result_id => l_copy_entity_result_id,
11235: p_copy_entity_txn_id => p_copy_entity_txn_id,
11236: p_result_type_cd => l_result_type_cd,
11237: p_mirror_src_entity_result_id => l_mirror_src_entity_result_id,
11329: end if;
11330: --
11331: l_copy_entity_result_id := null;
11332: l_object_version_number := null;
11333: ben_copy_entity_results_api.create_copy_entity_results(
11334: p_copy_entity_result_id => l_copy_entity_result_id,
11335: p_copy_entity_txn_id => p_copy_entity_txn_id,
11336: p_result_type_cd => l_result_type_cd,
11337: p_mirror_src_entity_result_id => l_mirror_src_entity_result_id,
11440: end if;
11441: --
11442: l_copy_entity_result_id := null;
11443: l_object_version_number := null;
11444: ben_copy_entity_results_api.create_copy_entity_results(
11445: p_copy_entity_result_id => l_copy_entity_result_id,
11446: p_copy_entity_txn_id => p_copy_entity_txn_id,
11447: p_result_type_cd => l_result_type_cd,
11448: p_mirror_src_entity_result_id => l_mirror_src_entity_result_id,
11548: ,p_parent_entity_result_id in number
11549: ,p_no_dup_rslt in varchar2 default null
11550: ) is
11551: --
11552: l_copy_entity_result_id ben_copy_entity_results.copy_entity_result_id%TYPE;
11553: l_proc varchar2(72) := g_package||'create_popl_result';
11554: l_object_version_number ben_copy_entity_results.object_version_number%TYPE;
11555: --
11556: l_result_type_cd varchar2(30) := 'DISPLAY' ;
11550: ) is
11551: --
11552: l_copy_entity_result_id ben_copy_entity_results.copy_entity_result_id%TYPE;
11553: l_proc varchar2(72) := g_package||'create_popl_result';
11554: l_object_version_number ben_copy_entity_results.object_version_number%TYPE;
11555: --
11556: l_result_type_cd varchar2(30) := 'DISPLAY' ;
11557: -- Cursor to get mirror_src_entity_result_id
11558: cursor c_parent_result(c_parent_pk_id number,
11558: cursor c_parent_result(c_parent_pk_id number,
11559: c_parent_table_alias varchar2,
11560: c_copy_entity_txn_id number) is
11561: select copy_entity_result_id mirror_src_entity_result_id
11562: from ben_copy_entity_results cpe
11563: -- pqh_table_route trt
11564: where cpe.information1 = c_parent_pk_id
11565: and cpe.result_type_cd = l_result_type_cd
11566: and cpe.copy_entity_txn_id = c_copy_entity_txn_id
11586: where opt.opt_id = c_opt_id
11587: -- and opt.business_group_id = p_business_group_id
11588: and not exists (
11589: select /*+ */ null
11590: from ben_copy_entity_results cpe
11591: -- pqh_table_route trt
11592: where copy_entity_txn_id = p_copy_entity_txn_id
11593: -- and trt.table_route_id = cpe.table_route_id
11594: and ( -- c_mirror_src_entity_result_id is null or
11637: where ddr.dsgn_rqmt_id = c_dsgn_rqmt_id
11638: -- and ddr.business_group_id = p_business_group_id
11639: and not exists (
11640: select /*+ */ null
11641: from ben_copy_entity_results cpe
11642: -- pqh_table_route trt
11643: where copy_entity_txn_id = p_copy_entity_txn_id
11644: -- and trt.table_route_id = cpe.table_route_id
11645: and ( -- c_mirror_src_entity_result_id is null or
11670: where pon.pl_typ_opt_typ_id = c_pl_typ_opt_typ_id
11671: -- and pon.business_group_id = p_business_group_id
11672: and not exists (
11673: select /*+ */ null
11674: from ben_copy_entity_results cpe
11675: -- pqh_table_route trt
11676: where copy_entity_txn_id = p_copy_entity_txn_id
11677: -- and trt.table_route_id = cpe.table_route_id
11678: and ( -- c_mirror_src_entity_result_id is null or
11703: where drr.dsgn_rqmt_rlshp_typ_id = c_dsgn_rqmt_rlshp_typ_id
11704: -- and drr.business_group_id = p_business_group_id
11705: and not exists (
11706: select /*+ */ null
11707: from ben_copy_entity_results cpe
11708: -- pqh_table_route trt
11709: where copy_entity_txn_id = p_copy_entity_txn_id
11710: -- and trt.table_route_id = cpe.table_route_id
11711: and ( -- c_mirror_src_entity_result_id is null or
11732:
11733: cursor c_opt_exists(c_opt_id number,
11734: c_table_alias varchar2) is
11735: select null
11736: from ben_copy_entity_results cpe
11737: -- pqh_table_route trt
11738: where copy_entity_txn_id = p_copy_entity_txn_id
11739: -- and trt.table_route_id = cpe.table_route_id
11740: and cpe.table_alias = c_table_alias
11744:
11745: l_mirror_src_entity_result_id number(15);
11746: l_parent_entity_result_id number(15);
11747: l_table_route_id number(15);
11748: l_information5 ben_copy_entity_results.information5%TYPE;
11749: l_number_of_copies number := p_number_of_copies ;
11750: --
11751: L_ELIG_TO_PRTE_RSN_ID number(15);
11752:
11833: --
11834: l_copy_entity_result_id := null;
11835: l_object_version_number := null;
11836: --
11837: ben_copy_entity_results_api.create_copy_entity_results(
11838: p_copy_entity_result_id => l_copy_entity_result_id,
11839: p_copy_entity_txn_id => p_copy_entity_txn_id,
11840: p_result_type_cd => l_result_type_cd,
11841: p_mirror_src_entity_result_id => l_mirror_src_entity_result_id,
11991: end if;
11992: --
11993: l_copy_entity_result_id := null;
11994: l_object_version_number := null;
11995: ben_copy_entity_results_api.create_copy_entity_results(
11996: p_copy_entity_result_id => l_copy_entity_result_id,
11997: p_copy_entity_txn_id => p_copy_entity_txn_id,
11998: p_result_type_cd => l_result_type_cd,
11999: p_mirror_src_entity_result_id => l_mirror_src_entity_result_id,
12092: l_result_type_cd := 'DISPLAY';
12093: --
12094: l_copy_entity_result_id := null;
12095: l_object_version_number := null;
12096: ben_copy_entity_results_api.create_copy_entity_results(
12097: p_copy_entity_result_id => l_copy_entity_result_id,
12098: p_copy_entity_txn_id => p_copy_entity_txn_id,
12099: p_result_type_cd => l_result_type_cd,
12100: p_mirror_src_entity_result_id => l_mirror_src_entity_result_id,
12194: end if;
12195: --
12196: l_copy_entity_result_id := null;
12197: l_object_version_number := null;
12198: ben_copy_entity_results_api.create_copy_entity_results(
12199: p_copy_entity_result_id => l_copy_entity_result_id,
12200: p_copy_entity_txn_id => p_copy_entity_txn_id,
12201: p_result_type_cd => l_result_type_cd,
12202: p_mirror_src_entity_result_id => l_mirror_src_entity_result_id,
12302: ,p_parent_entity_result_id in number
12303: ,p_no_dup_rslt in varchar2 default null
12304: ) is
12305: --
12306: l_copy_entity_result_id ben_copy_entity_results.copy_entity_result_id%TYPE;
12307: l_proc varchar2(72) := g_package||'create_pl_typ_result';
12308: l_object_version_number ben_copy_entity_results.object_version_number%TYPE;
12309: --
12310: l_result_type_cd varchar2(30) := 'DISPLAY' ;
12304: ) is
12305: --
12306: l_copy_entity_result_id ben_copy_entity_results.copy_entity_result_id%TYPE;
12307: l_proc varchar2(72) := g_package||'create_pl_typ_result';
12308: l_object_version_number ben_copy_entity_results.object_version_number%TYPE;
12309: --
12310: l_result_type_cd varchar2(30) := 'DISPLAY' ;
12311: -- Cursor to get mirror_src_entity_result_id
12312: cursor c_parent_result(c_parent_pk_id number,
12312: cursor c_parent_result(c_parent_pk_id number,
12313: c_parent_table_alias varchar2,
12314: c_copy_entity_txn_id number) is
12315: select copy_entity_result_id mirror_src_entity_result_id
12316: from ben_copy_entity_results cpe
12317: -- pqh_table_route trt
12318: where cpe.information1 = c_parent_pk_id
12319: and cpe.result_type_cd = l_result_type_cd
12320: and cpe.copy_entity_txn_id = c_copy_entity_txn_id
12339: where ptp.pl_typ_id = c_pl_typ_id
12340: -- and ptp.business_group_id = p_business_group_id
12341: and not exists (
12342: select /*+ */ null
12343: from ben_copy_entity_results cpe
12344: -- pqh_table_route trt
12345: where copy_entity_txn_id = p_copy_entity_txn_id
12346: -- and trt.table_route_id = cpe.table_route_id
12347: and ( -- c_mirror_src_entity_result_id is null or
12362:
12363: cursor c_object_exists(c_pk_id number,
12364: c_table_alias varchar2) is
12365: select null
12366: from ben_copy_entity_results cpe
12367: -- pqh_table_route trt
12368: where copy_entity_txn_id = p_copy_entity_txn_id
12369: -- and trt.table_route_id = cpe.table_route_id
12370: and cpe.table_alias = c_table_alias
12374:
12375: l_mirror_src_entity_result_id number(15);
12376: l_parent_entity_result_id number(15);
12377: l_table_route_id number(15);
12378: l_information5 ben_copy_entity_results.information5%TYPE;
12379: l_number_of_copies number := p_number_of_copies ;
12380: --
12381:
12382: begin
12424: end if;
12425: --
12426: l_copy_entity_result_id := null;
12427: l_object_version_number := null;
12428: ben_copy_entity_results_api.create_copy_entity_results(
12429: p_copy_entity_result_id => l_copy_entity_result_id,
12430: p_copy_entity_txn_id => p_copy_entity_txn_id,
12431: p_result_type_cd => l_result_type_cd,
12432: p_mirror_src_entity_result_id => l_mirror_src_entity_result_id,
12515: ,p_parent_entity_result_id in number
12516: ,p_no_dup_rslt in varchar2 default null
12517: ) is
12518: --
12519: l_copy_entity_result_id ben_copy_entity_results.copy_entity_result_id%TYPE;
12520: l_proc varchar2(72) := g_package||'create_yr_perd_result';
12521: l_object_version_number ben_copy_entity_results.object_version_number%TYPE;
12522: --
12523: l_result_type_cd varchar2(30) := 'DISPLAY' ;
12517: ) is
12518: --
12519: l_copy_entity_result_id ben_copy_entity_results.copy_entity_result_id%TYPE;
12520: l_proc varchar2(72) := g_package||'create_yr_perd_result';
12521: l_object_version_number ben_copy_entity_results.object_version_number%TYPE;
12522: --
12523: l_result_type_cd varchar2(30) := 'DISPLAY' ;
12524: -- Cursor to get mirror_src_entity_result_id
12525: cursor c_parent_result(c_parent_pk_id number,
12525: cursor c_parent_result(c_parent_pk_id number,
12526: c_parent_table_alias varchar2,
12527: c_copy_entity_txn_id number) is
12528: select copy_entity_result_id mirror_src_entity_result_id
12529: from ben_copy_entity_results cpe
12530: -- pqh_table_route trt
12531: where cpe.information1 = c_parent_pk_id
12532: and cpe.result_type_cd = l_result_type_cd
12533: and cpe.copy_entity_txn_id = c_copy_entity_txn_id
12553: where yrp.yr_perd_id = c_yr_perd_id
12554: -- and yrp.business_group_id = p_business_group_id
12555: and not exists (
12556: select /*+ */ null
12557: from ben_copy_entity_results cpe
12558: -- pqh_table_route trt
12559: where copy_entity_txn_id = p_copy_entity_txn_id
12560: -- and trt.table_route_id = cpe.table_route_id
12561: and ( -- c_mirror_src_entity_result_id is null or
12585: where wyp.wthn_yr_perd_id = c_wthn_yr_perd_id
12586: -- and wyp.business_group_id = p_business_group_id
12587: and not exists (
12588: select /*+ */ null
12589: from ben_copy_entity_results cpe
12590: -- pqh_table_route trt
12591: where copy_entity_txn_id = p_copy_entity_txn_id
12592: -- and trt.table_route_id = cpe.table_route_id
12593: and ( -- c_mirror_src_entity_result_id is null or
12607:
12608: cursor c_object_exists(c_pk_id number,
12609: c_table_alias varchar2) is
12610: select null
12611: from ben_copy_entity_results cpe
12612: -- pqh_table_route trt
12613: where copy_entity_txn_id = p_copy_entity_txn_id
12614: -- and trt.table_route_id = cpe.table_route_id
12615: and cpe.table_alias = c_table_alias
12619:
12620: l_mirror_src_entity_result_id number(15);
12621: l_parent_entity_result_id number(15);
12622: l_table_route_id number(15);
12623: l_information5 ben_copy_entity_results.information5%TYPE;
12624: l_number_of_copies number := p_number_of_copies ;
12625: --
12626:
12627: begin
12664: l_result_type_cd := 'DISPLAY';
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,
12761: l_result_type_cd := 'DISPLAY';
12762: --
12763: l_copy_entity_result_id := null;
12764: l_object_version_number := null;
12765: ben_copy_entity_results_api.create_copy_entity_results(
12766: p_copy_entity_result_id => l_copy_entity_result_id,
12767: p_copy_entity_txn_id => p_copy_entity_txn_id,
12768: p_result_type_cd => l_result_type_cd,
12769: p_mirror_src_entity_result_id => l_mirror_src_entity_result_id,