eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_PLAN_DESIGN_PROGRAM_MODULE dependencies on BEN_COPY_ENTITY_RESULTS

Line 29: l_copy_entity_result_id ben_copy_entity_results.copy_entity_result_id%TYPE;

25: ) is
26: --
27: -- Declare cursors and local variables
28: --
29: l_copy_entity_result_id ben_copy_entity_results.copy_entity_result_id%TYPE;
30: l_proc varchar2(72) := g_package||'create_program_result';
31: l_object_version_number ben_copy_entity_results.object_version_number%TYPE;
32: l_pgm_id number(15) default p_pgm_id ;
33: --

Line 31: l_object_version_number ben_copy_entity_results.object_version_number%TYPE;

27: -- Declare cursors and local variables
28: --
29: l_copy_entity_result_id ben_copy_entity_results.copy_entity_result_id%TYPE;
30: l_proc varchar2(72) := g_package||'create_program_result';
31: l_object_version_number ben_copy_entity_results.object_version_number%TYPE;
32: l_pgm_id number(15) default p_pgm_id ;
33: --
34: l_cv_result_type_cd varchar2(30) := 'DISPLAY' ;
35: --

Line 42: from ben_copy_entity_results cpe

38: -- c_parent_table_name varchar2,
39: c_parent_table_alias varchar2,
40: c_copy_entity_txn_id number) is
41: select copy_entity_result_id mirror_src_entity_result_id
42: from ben_copy_entity_results cpe
43: -- ,pqh_table_route trt
44: where cpe.information1= c_parent_pk_id
45: and cpe.result_type_cd = l_cv_result_type_cd
46: and cpe.copy_entity_txn_id = c_copy_entity_txn_id

Line 84: from ben_copy_entity_results cpe

80: where pgm.pgm_id = c_pgm_id
81: --and pgm.business_group_id = p_business_group_id
82: and not exists (
83: select /* */ null
84: from ben_copy_entity_results cpe
85: --ggnanagu ,pqh_table_route trt
86: where copy_entity_txn_id = p_copy_entity_txn_id
87: -- and trt.table_route_id = cpe.table_route_id
88: and ( c_mirror_src_entity_result_id is null or

Line 115: from ben_copy_entity_results cpe

111: where ldc.ler_chg_dpnt_cvg_id = c_ler_chg_dpnt_cvg_id
112: --and ldc.business_group_id = p_business_group_id
113: and not exists (
114: select /* */ null
115: from ben_copy_entity_results cpe
116: -- ,pqh_table_route trt
117: where copy_entity_txn_id = p_copy_entity_txn_id
118: -- and trt.table_route_id = cpe.table_route_id
119: and mirror_src_entity_result_id = c_mirror_src_entity_result_id

Line 130: from ben_copy_entity_results cpe

126: --
127: cursor c_ldc_drp(c_ler_chg_dpnt_cvg_id number ,c_mirror_src_entity_result_id number,
128: c_table_alias varchar2 ) is
129: select distinct cpe.information257 ler_id
130: from ben_copy_entity_results cpe
131: -- ,pqh_table_route trt
132: where copy_entity_txn_id = p_copy_entity_txn_id
133: -- and trt.table_route_id = cpe.table_route_id
134: and mirror_src_entity_result_id = c_mirror_src_entity_result_id

Line 159: from ben_copy_entity_results cpe

155: where lge.ler_chg_pgm_enrt_id = c_ler_chg_pgm_enrt_id
156: --and lge.business_group_id = p_business_group_id
157: and not exists (
158: select /* */ null
159: from ben_copy_entity_results cpe
160: -- ,pqh_table_route trt
161: where copy_entity_txn_id = p_copy_entity_txn_id
162: -- and trt.table_route_id = cpe.table_route_id
163: and mirror_src_entity_result_id = c_mirror_src_entity_result_id

Line 174: from ben_copy_entity_results cpe

170: --
171: cursor c_lge_drp(c_ler_chg_pgm_enrt_id number ,c_mirror_src_entity_result_id number,
172: c_table_alias varchar2 ) is
173: select distinct cpe.information257 ler_id
174: from ben_copy_entity_results cpe
175: -- ,pqh_table_route trt
176: where copy_entity_txn_id = p_copy_entity_txn_id
177: -- and trt.table_route_id = cpe.table_route_id
178: and mirror_src_entity_result_id = c_mirror_src_entity_result_id

Line 204: from ben_copy_entity_results cpe

200: where peo.elig_to_prte_rsn_id = c_elig_to_prte_rsn_id
201: --and peo.business_group_id = p_business_group_id
202: and not exists (
203: select /* */ null
204: from ben_copy_entity_results cpe
205: -- ,pqh_table_route trt
206: where copy_entity_txn_id = p_copy_entity_txn_id
207: -- and trt.table_route_id = cpe.table_route_id
208: and mirror_src_entity_result_id = c_mirror_src_entity_result_id

Line 234: from ben_copy_entity_results cpe

230: from BEN_PGM_DPNT_CVG_CTFN_F pgc
231: where pgc.pgm_dpnt_cvg_ctfn_id = c_pgm_dpnt_cvg_ctfn_id
232: and not exists (
233: select /* */ null
234: from ben_copy_entity_results cpe
235: -- ,pqh_table_route trt
236: where copy_entity_txn_id = p_copy_entity_txn_id
237: -- and trt.table_route_id = cpe.table_route_id
238: and mirror_src_entity_result_id = c_mirror_src_entity_result_id

Line 264: from ben_copy_entity_results cpe

260: from BEN_LER_CHG_DPNT_CVG_CTFN_F lcc
261: where lcc.ler_chg_dpnt_cvg_ctfn_id = c_ler_chg_dpnt_cvg_ctfn_id
262: and not exists (
263: select /* */ null
264: from ben_copy_entity_results cpe
265: -- ,pqh_table_route trt
266: where copy_entity_txn_id = p_copy_entity_txn_id
267: -- and trt.table_route_id = cpe.table_route_id
268: and mirror_src_entity_result_id = c_mirror_src_entity_result_id

Line 294: from ben_copy_entity_results cpe

290: from BEN_PLIP_F cpp
291: where cpp.plip_id = c_plip_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 cpe.table_alias = c_table_alias

Line 323: from ben_copy_entity_results cpe

319: from BEN_PTIP_F ctp
320: where ctp.ptip_id = c_ptip_id
321: and not exists (
322: select /* */ null
323: from ben_copy_entity_results cpe
324: -- ,pqh_table_route trt
325: where copy_entity_txn_id = p_copy_entity_txn_id
326: -- and trt.table_route_id = cpe.table_route_id
327: and mirror_src_entity_result_id = c_mirror_src_entity_result_id

Line 353: from ben_copy_entity_results cpe

349: from BEN_ELIG_TO_PRTE_RSN_F peo
350: where peo.elig_to_prte_rsn_id = c_elig_to_prte_rsn_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 mirror_src_entity_result_id = c_mirror_src_entity_result_id

Line 383: from ben_copy_entity_results cpe

379: from BEN_LER_CHG_DPNT_CVG_F ldc
380: where ldc.ler_chg_dpnt_cvg_id = c_ler_chg_dpnt_cvg_id
381: and not exists (
382: select /* */ null
383: from ben_copy_entity_results cpe
384: -- ,pqh_table_route trt
385: where copy_entity_txn_id = p_copy_entity_txn_id
386: -- and trt.table_route_id = cpe.table_route_id
387: and mirror_src_entity_result_id = c_mirror_src_entity_result_id

Line 397: from ben_copy_entity_results cpe

393: --
394: cursor c_ldc1_drp(c_ler_chg_dpnt_cvg_id number ,c_mirror_src_entity_result_id number,
395: c_table_alias varchar2) is
396: select distinct cpe.information257 ler_id
397: from ben_copy_entity_results cpe
398: -- ,pqh_table_route trt
399: where copy_entity_txn_id = p_copy_entity_txn_id
400: -- and trt.table_route_id = cpe.table_route_id
401: and mirror_src_entity_result_id = c_mirror_src_entity_result_id

Line 425: from ben_copy_entity_results cpe

421: from BEN_LER_CHG_PTIP_ENRT_F lct
422: where lct.ler_chg_ptip_enrt_id = c_ler_chg_ptip_enrt_id
423: and not exists (
424: select /* */ null
425: from ben_copy_entity_results cpe
426: -- ,pqh_table_route trt
427: where copy_entity_txn_id = p_copy_entity_txn_id
428: -- and trt.table_route_id = cpe.table_route_id
429: and mirror_src_entity_result_id = c_mirror_src_entity_result_id

Line 440: from ben_copy_entity_results cpe

436:
437: cursor c_lct1_drp(c_ler_chg_ptip_enrt_id number,c_mirror_src_entity_result_id number ,
438: c_table_alias varchar2) is
439: select distinct cpe.information257 ler_id
440: from ben_copy_entity_results cpe
441: -- ,pqh_table_route trt
442: where copy_entity_txn_id = p_copy_entity_txn_id
443: -- and trt.table_route_id = cpe.table_route_id
444: and mirror_src_entity_result_id = c_mirror_src_entity_result_id

Line 467: from ben_copy_entity_results cpe

463: from BEN_PTIP_DPNT_CVG_CTFN_F pyd
464: where pyd.ptip_dpnt_cvg_ctfn_id = c_ptip_dpnt_cvg_ctfn_id
465: and not exists (
466: select /* */ null
467: from ben_copy_entity_results cpe
468: -- ,pqh_table_route trt
469: where copy_entity_txn_id = p_copy_entity_txn_id
470: -- and trt.table_route_id = cpe.table_route_id
471: and mirror_src_entity_result_id = c_mirror_src_entity_result_id

Line 497: from ben_copy_entity_results cpe

493: from BEN_WV_PRTN_RSN_PTIP_F wpt
494: where wpt.wv_prtn_rsn_ptip_id = c_wv_prtn_rsn_ptip_id
495: and not exists (
496: select /* */ null
497: from ben_copy_entity_results cpe
498: -- ,pqh_table_route trt
499: where copy_entity_txn_id = p_copy_entity_txn_id
500: -- and trt.table_route_id = cpe.table_route_id
501: and mirror_src_entity_result_id = c_mirror_src_entity_result_id

Line 527: from ben_copy_entity_results cpe

523: from BEN_WV_PRTN_RSN_CTFN_PTIP_F wct
524: where wct.wv_prtn_rsn_ctfn_ptip_id = c_wv_prtn_rsn_ctfn_ptip_id
525: and not exists (
526: select /* */ null
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

Line 557: from ben_copy_entity_results cpe

553: from BEN_LER_CHG_DPNT_CVG_CTFN_F lcc
554: where lcc.ler_chg_dpnt_cvg_ctfn_id = c_ler_chg_dpnt_cvg_ctfn_id
555: and not exists (
556: select /* */ null
557: from ben_copy_entity_results cpe
558: -- ,pqh_table_route trt
559: where copy_entity_txn_id = p_copy_entity_txn_id
560: -- and trt.table_route_id = cpe.table_route_id
561: and mirror_src_entity_result_id = c_mirror_src_entity_result_id

Line 588: from ben_copy_entity_results cpe

584: from BEN_ELIG_TO_PRTE_RSN_F peo
585: where peo.elig_to_prte_rsn_id = c_elig_to_prte_rsn_id
586: and not exists (
587: select /* */ null
588: from ben_copy_entity_results cpe
589: -- ,pqh_table_route trt
590: where copy_entity_txn_id = p_copy_entity_txn_id
591: -- and trt.table_route_id = cpe.table_route_id
592: and mirror_src_entity_result_id = c_mirror_src_entity_result_id

Line 618: from ben_copy_entity_results cpe

614: from BEN_LER_BNFT_RSTRN_F lbr
615: where lbr.ler_bnft_rstrn_id = c_ler_bnft_rstrn_id
616: and not exists (
617: select /* */ null
618: from ben_copy_entity_results cpe
619: -- ,pqh_table_route trt
620: where copy_entity_txn_id = p_copy_entity_txn_id
621: -- and trt.table_route_id = cpe.table_route_id
622: and mirror_src_entity_result_id = c_mirror_src_entity_result_id

Line 648: from ben_copy_entity_results cpe

644: from BEN_LER_CHG_PLIP_ENRT_F lpr
645: where lpr.ler_chg_plip_enrt_id = c_ler_chg_plip_enrt_id
646: and not exists (
647: select /* */ null
648: from ben_copy_entity_results cpe
649: -- ,pqh_table_route trt
650: where copy_entity_txn_id = p_copy_entity_txn_id
651: -- and trt.table_route_id = cpe.table_route_id
652: and mirror_src_entity_result_id = c_mirror_src_entity_result_id

Line 664: from ben_copy_entity_results cpe

660: --
661: cursor c_lpr_drp(c_ler_chg_plip_enrt_id number,c_mirror_src_entity_result_id number ,
662: c_table_alias varchar2) is
663: select distinct cpe.information257 ler_id
664: from ben_copy_entity_results cpe
665: -- ,pqh_table_route trt
666: where copy_entity_txn_id = p_copy_entity_txn_id
667: -- and trt.table_route_id = cpe.table_route_id
668: and mirror_src_entity_result_id = c_mirror_src_entity_result_id

Line 691: from ben_copy_entity_results cpe

687: from BEN_CMBN_PLIP_F cpl
688: where cpl.cmbn_plip_id = c_cmbn_plip_id
689: and not exists (
690: select /* */ null
691: from ben_copy_entity_results cpe
692: -- ,pqh_table_route trt
693: where copy_entity_txn_id = p_copy_entity_txn_id
694: -- and trt.table_route_id = cpe.table_route_id
695: and mirror_src_entity_result_id = c_mirror_src_entity_result_id

Line 722: from ben_copy_entity_results cpe

718: from BEN_CMBN_PTIP_F cbp
719: where cbp.cmbn_ptip_id = c_cmbn_ptip_id
720: and not exists (
721: select /* */ null
722: from ben_copy_entity_results cpe
723: -- ,pqh_table_route trt
724: where copy_entity_txn_id = p_copy_entity_txn_id
725: -- and trt.table_route_id = cpe.table_route_id
726: and mirror_src_entity_result_id = c_mirror_src_entity_result_id

Line 752: from ben_copy_entity_results cpe

748: from BEN_CMBN_PTIP_OPT_F cpt
749: where cpt.cmbn_ptip_opt_id = c_cmbn_ptip_opt_id
750: and not exists (
751: select /* */ null
752: from ben_copy_entity_results cpe
753: -- ,pqh_table_route trt
754: where copy_entity_txn_id = p_copy_entity_txn_id
755: -- and trt.table_route_id = cpe.table_route_id
756: and mirror_src_entity_result_id = c_mirror_src_entity_result_id

Line 774: ben_copy_entity_results cpe_oipl,

770: cursor c_opp1_from_parent(c_PGM_ID number, c_table_alias varchar2 ) is
771: select oiplip.oiplip_id,cpe_oipl.copy_entity_result_id
772: from ben_oiplip_f oiplip,
773: ben_plip_f plip,
774: ben_copy_entity_results cpe_oipl,
775: ben_copy_entity_results cpe_pl,
776: ben_copy_entity_results cpe_plip
777: -- ,pqh_table_route trt
778: where plip.plip_id = oiplip.plip_id

Line 775: ben_copy_entity_results cpe_pl,

771: select oiplip.oiplip_id,cpe_oipl.copy_entity_result_id
772: from ben_oiplip_f oiplip,
773: ben_plip_f plip,
774: ben_copy_entity_results cpe_oipl,
775: ben_copy_entity_results cpe_pl,
776: ben_copy_entity_results cpe_plip
777: -- ,pqh_table_route trt
778: where plip.plip_id = oiplip.plip_id
779: and plip.pgm_id = c_pgm_id

Line 776: ben_copy_entity_results cpe_plip

772: from ben_oiplip_f oiplip,
773: ben_plip_f plip,
774: ben_copy_entity_results cpe_oipl,
775: ben_copy_entity_results cpe_pl,
776: ben_copy_entity_results cpe_plip
777: -- ,pqh_table_route trt
778: where plip.plip_id = oiplip.plip_id
779: and plip.pgm_id = c_pgm_id
780: and oiplip.oipl_id = cpe_oipl.information1

Line 798: from ben_copy_entity_results cpe

794: from BEN_OIPLIP_F opp
795: where opp.oiplip_id = c_oiplip_id
796: and not exists (
797: select /* */ null
798: from ben_copy_entity_results cpe
799: -- ,pqh_table_route trt
800: where copy_entity_txn_id = p_copy_entity_txn_id
801: -- and trt.table_route_id = cpe.table_route_id
802: and mirror_src_entity_result_id = c_mirror_src_entity_result_id

Line 820: ben_copy_entity_results cpe

816: cursor c_otp1_from_parent(c_PGM_ID number,c_table_alias varchar2 ) is
817: select optip.optip_id,cpe.copy_entity_result_id
818: from ben_optip_f optip,
819: ben_ptip_f ptip,
820: ben_copy_entity_results cpe
821: -- ,pqh_table_route trt
822: where ptip.ptip_id = optip.ptip_id
823: and ptip.pgm_id = c_pgm_id
824: and optip.opt_id = cpe.information1

Line 836: from ben_copy_entity_results cpe

832: from BEN_OPTIP_F otp
833: where otp.optip_id = c_optip_id
834: and not exists (
835: select /* */ null
836: from ben_copy_entity_results cpe
837: -- ,pqh_table_route trt
838: where copy_entity_txn_id = p_copy_entity_txn_id
839: -- and trt.table_route_id = cpe.table_route_id
840: and mirror_src_entity_result_id = c_mirror_src_entity_result_id

Line 876: from ben_copy_entity_results cpe

872:
873: cursor c_object_exists(c_pk_id number,
874: c_table_alias varchar2) is
875: select null
876: from ben_copy_entity_results cpe
877: -- ,pqh_table_route trt
878: where copy_entity_txn_id = p_copy_entity_txn_id
879: -- and trt.table_route_id = cpe.table_route_id
880: and cpe.table_alias = c_table_alias

Line 888: l_information5 ben_copy_entity_results.information5%type;

884:
885: l_table_route_id number(15);
886: l_mirror_src_entity_result_id number(15);
887: l_result_type_cd varchar2(30);
888: l_information5 ben_copy_entity_results.information5%type;
889: l_number_of_copies number(15);
890: l_child_exists boolean default false ;
891:
892: begin

Line 952: ben_copy_entity_results_api.create_copy_entity_results(

948: close c_lookup_meaning;
949:
950: -- End: Fetch Lookup Meaning for Program Type
951:
952: ben_copy_entity_results_api.create_copy_entity_results(
953: p_copy_entity_result_id => l_copy_entity_result_id,
954: p_copy_entity_txn_id => p_copy_entity_txn_id,
955: p_result_type_cd => l_result_type_cd,
956: p_mirror_src_entity_result_id => null,

Line 1505: ben_copy_entity_results_api.create_copy_entity_results(

1501: end if;
1502: --
1503: l_copy_entity_result_id := null;
1504: l_object_version_number := null;
1505: ben_copy_entity_results_api.create_copy_entity_results(
1506: p_copy_entity_result_id => l_copy_entity_result_id,
1507: p_copy_entity_txn_id => p_copy_entity_txn_id,
1508: p_result_type_cd => l_result_type_cd,
1509: p_mirror_src_entity_result_id => l_mirror_src_entity_result_id,

Line 1666: ben_copy_entity_results_api.create_copy_entity_results(

1662: end if;
1663: --
1664: l_copy_entity_result_id := null;
1665: l_object_version_number := null;
1666: ben_copy_entity_results_api.create_copy_entity_results(
1667: p_copy_entity_result_id => l_copy_entity_result_id,
1668: p_copy_entity_txn_id => p_copy_entity_txn_id,
1669: p_result_type_cd => l_result_type_cd,
1670: p_mirror_src_entity_result_id => l_mirror_src_entity_result_id,

Line 1793: ben_copy_entity_results_api.create_copy_entity_results(

1789: end if;
1790: --
1791: l_copy_entity_result_id := null;
1792: l_object_version_number := null;
1793: ben_copy_entity_results_api.create_copy_entity_results(
1794: p_copy_entity_result_id => l_copy_entity_result_id,
1795: p_copy_entity_txn_id => p_copy_entity_txn_id,
1796: p_result_type_cd => l_result_type_cd,
1797: p_mirror_src_entity_result_id => l_mirror_src_entity_result_id,

Line 1978: ben_copy_entity_results_api.create_copy_entity_results(

1974: end if;
1975: --
1976: l_copy_entity_result_id := null;
1977: l_object_version_number := null;
1978: ben_copy_entity_results_api.create_copy_entity_results(
1979: p_copy_entity_result_id => l_copy_entity_result_id,
1980: p_copy_entity_txn_id => p_copy_entity_txn_id,
1981: p_result_type_cd => l_result_type_cd,
1982: p_mirror_src_entity_result_id => l_mirror_src_entity_result_id,

Line 2258: ben_copy_entity_results_api.create_copy_entity_results(

2254: end if;
2255: --
2256: l_copy_entity_result_id := null;
2257: l_object_version_number := null;
2258: ben_copy_entity_results_api.create_copy_entity_results(
2259: p_copy_entity_result_id => l_copy_entity_result_id,
2260: p_copy_entity_txn_id => p_copy_entity_txn_id,
2261: p_result_type_cd => l_result_type_cd,
2262: p_mirror_src_entity_result_id => l_mirror_src_entity_result_id,

Line 2383: ben_copy_entity_results_api.create_copy_entity_results(

2379: end if;
2380: --
2381: l_copy_entity_result_id := null;
2382: l_object_version_number := null;
2383: ben_copy_entity_results_api.create_copy_entity_results(
2384: p_copy_entity_result_id => l_copy_entity_result_id,
2385: p_copy_entity_txn_id => p_copy_entity_txn_id,
2386: p_result_type_cd => l_result_type_cd,
2387: p_mirror_src_entity_result_id => l_mirror_src_entity_result_id,

Line 2888: ben_copy_entity_results_api.create_copy_entity_results(

2884: end if;
2885: --
2886: l_copy_entity_result_id := null;
2887: l_object_version_number := null;
2888: ben_copy_entity_results_api.create_copy_entity_results(
2889: p_copy_entity_result_id => l_copy_entity_result_id,
2890: p_copy_entity_txn_id => p_copy_entity_txn_id,
2891: p_result_type_cd => l_result_type_cd,
2892: p_mirror_src_entity_result_id => l_mirror_src_entity_result_id,

Line 3162: ben_copy_entity_results_api.create_copy_entity_results(

3158: end if;
3159: --
3160: l_copy_entity_result_id := null;
3161: l_object_version_number := null;
3162: ben_copy_entity_results_api.create_copy_entity_results(
3163: p_copy_entity_result_id => l_copy_entity_result_id,
3164: p_copy_entity_txn_id => p_copy_entity_txn_id,
3165: p_result_type_cd => l_result_type_cd,
3166: p_mirror_src_entity_result_id => l_mirror_src_entity_result_id,

Line 3340: ben_copy_entity_results_api.create_copy_entity_results(

3336: end if;
3337: --
3338: l_copy_entity_result_id := null;
3339: l_object_version_number := null;
3340: ben_copy_entity_results_api.create_copy_entity_results(
3341: p_copy_entity_result_id => l_copy_entity_result_id,
3342: p_copy_entity_txn_id => p_copy_entity_txn_id,
3343: p_result_type_cd => l_result_type_cd,
3344: p_mirror_src_entity_result_id => l_mirror_src_entity_result_id,

Line 3445: ben_copy_entity_results_api.create_copy_entity_results(

3441: end if;
3442: --
3443: l_copy_entity_result_id := null;
3444: l_object_version_number := null;
3445: ben_copy_entity_results_api.create_copy_entity_results(
3446: p_copy_entity_result_id => l_copy_entity_result_id,
3447: p_copy_entity_txn_id => p_copy_entity_txn_id,
3448: p_result_type_cd => l_result_type_cd,
3449: p_mirror_src_entity_result_id => l_mirror_src_entity_result_id,

Line 3607: ben_copy_entity_results_api.create_copy_entity_results(

3603: end if;
3604: --
3605: l_copy_entity_result_id := null;
3606: l_object_version_number := null;
3607: ben_copy_entity_results_api.create_copy_entity_results(
3608: p_copy_entity_result_id => l_copy_entity_result_id,
3609: p_copy_entity_txn_id => p_copy_entity_txn_id,
3610: p_result_type_cd => l_result_type_cd,
3611: p_mirror_src_entity_result_id => l_mirror_src_entity_result_id,

Line 3732: ben_copy_entity_results_api.create_copy_entity_results(

3728: end if;
3729: --
3730: l_copy_entity_result_id := null;
3731: l_object_version_number := null;
3732: ben_copy_entity_results_api.create_copy_entity_results(
3733: p_copy_entity_result_id => l_copy_entity_result_id,
3734: p_copy_entity_txn_id => p_copy_entity_txn_id,
3735: p_result_type_cd => l_result_type_cd,
3736: p_mirror_src_entity_result_id => l_mirror_src_entity_result_id,

Line 3825: ben_copy_entity_results_api.create_copy_entity_results(

3821: end if;
3822: --
3823: l_copy_entity_result_id := null;
3824: l_object_version_number := null;
3825: ben_copy_entity_results_api.create_copy_entity_results(
3826: p_copy_entity_result_id => l_copy_entity_result_id,
3827: p_copy_entity_txn_id => p_copy_entity_txn_id,
3828: p_result_type_cd => l_result_type_cd,
3829: p_mirror_src_entity_result_id => l_mirror_src_entity_result_id,

Line 3961: ben_copy_entity_results_api.create_copy_entity_results(

3957: end if;
3958: --
3959: l_copy_entity_result_id := null;
3960: l_object_version_number := null;
3961: ben_copy_entity_results_api.create_copy_entity_results(
3962: p_copy_entity_result_id => l_copy_entity_result_id,
3963: p_copy_entity_txn_id => p_copy_entity_txn_id,
3964: p_result_type_cd => l_result_type_cd,
3965: p_mirror_src_entity_result_id => l_mirror_src_entity_result_id,

Line 4469: ben_copy_entity_results_api.create_copy_entity_results(

4465: end if;
4466: --
4467: l_copy_entity_result_id := null;
4468: l_object_version_number := null;
4469: ben_copy_entity_results_api.create_copy_entity_results(
4470: p_copy_entity_result_id => l_copy_entity_result_id,
4471: p_copy_entity_txn_id => p_copy_entity_txn_id,
4472: p_result_type_cd => l_result_type_cd,
4473: p_mirror_src_entity_result_id => l_mirror_src_entity_result_id,

Line 4749: ben_copy_entity_results_api.create_copy_entity_results(

4745: end if;
4746: --
4747: l_copy_entity_result_id := null;
4748: l_object_version_number := null;
4749: ben_copy_entity_results_api.create_copy_entity_results(
4750: p_copy_entity_result_id => l_copy_entity_result_id,
4751: p_copy_entity_txn_id => p_copy_entity_txn_id,
4752: p_result_type_cd => l_result_type_cd,
4753: p_mirror_src_entity_result_id => l_mirror_src_entity_result_id,

Line 4927: ben_copy_entity_results_api.create_copy_entity_results(

4923: end if;
4924: --
4925: l_copy_entity_result_id := null;
4926: l_object_version_number := null;
4927: ben_copy_entity_results_api.create_copy_entity_results(
4928: p_copy_entity_result_id => l_copy_entity_result_id,
4929: p_copy_entity_txn_id => p_copy_entity_txn_id,
4930: p_result_type_cd => l_result_type_cd,
4931: p_mirror_src_entity_result_id => l_mirror_src_entity_result_id,

Line 5132: ben_copy_entity_results_api.create_copy_entity_results(

5128: end if;
5129: --
5130: l_copy_entity_result_id := null;
5131: l_object_version_number := null;
5132: ben_copy_entity_results_api.create_copy_entity_results(
5133: p_copy_entity_result_id => l_copy_entity_result_id,
5134: p_copy_entity_txn_id => p_copy_entity_txn_id,
5135: p_result_type_cd => l_result_type_cd,
5136: p_mirror_src_entity_result_id => l_mirror_src_entity_result_id,

Line 5273: ben_copy_entity_results_api.create_copy_entity_results(

5269: end if;
5270: --
5271: l_copy_entity_result_id := null;
5272: l_object_version_number := null;
5273: ben_copy_entity_results_api.create_copy_entity_results(
5274: p_copy_entity_result_id => l_copy_entity_result_id,
5275: p_copy_entity_txn_id => p_copy_entity_txn_id,
5276: p_result_type_cd => l_result_type_cd,
5277: p_mirror_src_entity_result_id => l_mirror_src_entity_result_id,

Line 5414: ben_copy_entity_results_api.create_copy_entity_results(

5410: end if;
5411: --
5412: l_copy_entity_result_id := null;
5413: l_object_version_number := null;
5414: ben_copy_entity_results_api.create_copy_entity_results(
5415: p_copy_entity_result_id => l_copy_entity_result_id,
5416: p_copy_entity_txn_id => p_copy_entity_txn_id,
5417: p_result_type_cd => l_result_type_cd,
5418: p_mirror_src_entity_result_id => l_mirror_src_entity_result_id,

Line 5557: ben_copy_entity_results_api.create_copy_entity_results(

5553: end if;
5554: --
5555: l_copy_entity_result_id := null;
5556: l_object_version_number := null;
5557: ben_copy_entity_results_api.create_copy_entity_results(
5558: p_copy_entity_result_id => l_copy_entity_result_id,
5559: p_copy_entity_txn_id => p_copy_entity_txn_id,
5560: p_result_type_cd => l_result_type_cd,
5561: p_mirror_src_entity_result_id => l_mirror_src_entity_result_id,

Line 5701: ben_copy_entity_results_api.create_copy_entity_results(

5697: end if;
5698: --
5699: l_copy_entity_result_id := null;
5700: l_object_version_number := null;
5701: ben_copy_entity_results_api.create_copy_entity_results(
5702: p_copy_entity_result_id => l_copy_entity_result_id,
5703: p_copy_entity_txn_id => p_copy_entity_txn_id,
5704: p_result_type_cd => l_result_type_cd,
5705: p_mirror_src_entity_result_id => l_mirror_src_entity_result_id,

Line 5792: l_copy_entity_result_id ben_copy_entity_results.copy_entity_result_id%TYPE;

5788: ,p_object_version_number out nocopy number
5789: ,p_effective_date in date
5790: ) is
5791: --
5792: l_copy_entity_result_id ben_copy_entity_results.copy_entity_result_id%TYPE;
5793: l_proc varchar2(72) := g_package||'create_formula_result';
5794: l_object_version_number ben_copy_entity_results.object_version_number%TYPE;
5795: --
5796: l_cv_result_type_cd varchar2(30) := 'DISPLAY' ;

Line 5794: l_object_version_number ben_copy_entity_results.object_version_number%TYPE;

5790: ) is
5791: --
5792: l_copy_entity_result_id ben_copy_entity_results.copy_entity_result_id%TYPE;
5793: l_proc varchar2(72) := g_package||'create_formula_result';
5794: l_object_version_number ben_copy_entity_results.object_version_number%TYPE;
5795: --
5796: l_cv_result_type_cd varchar2(30) := 'DISPLAY' ;
5797: --
5798: -- Bug : 3752407 : Global cursor g_table_route will now be used

Line 5812: from ben_copy_entity_results cpe

5808: cursor c_parent_result(c_parent_pk_id number,
5809: c_parent_table_alias varchar2,
5810: c_copy_entity_txn_id number) is
5811: select copy_entity_result_id mirror_src_entity_result_id
5812: from ben_copy_entity_results cpe
5813: -- ,pqh_table_route trt
5814: where cpe.information1= c_parent_pk_id
5815: and cpe.result_type_cd = l_cv_result_type_cd
5816: and cpe.copy_entity_txn_id = c_copy_entity_txn_id

Line 5833: from ben_copy_entity_results cpe

5829: and fff.formula_type_id = ft.formula_type_id
5830: and ( fff.business_group_id = p_business_group_id or fff.business_group_id is null )
5831: and not exists (
5832: select /* */ null
5833: from ben_copy_entity_results cpe
5834: -- ,pqh_table_route trt
5835: where copy_entity_txn_id = p_copy_entity_txn_id
5836: -- and trt.table_route_id = cpe.table_route_id
5837: and mirror_src_entity_result_id = c_mirror_src_entity_result_id

Line 5852: from ben_copy_entity_results cpe

5848:
5849: cursor c_object_exists(c_pk_id number,
5850: c_table_alias varchar2) is
5851: select null
5852: from ben_copy_entity_results cpe
5853: -- ,pqh_table_route trt
5854: where copy_entity_txn_id = p_copy_entity_txn_id
5855: -- and trt.table_route_id = cpe.table_route_id
5856: and cpe.table_alias = c_table_alias

Line 5864: l_information5 ben_copy_entity_results.information5%type;

5860:
5861: l_table_route_id number(15);
5862: l_mirror_src_entity_result_id number(15);
5863: l_result_type_cd varchar2(30);
5864: l_information5 ben_copy_entity_results.information5%type;
5865: l_ler_id number(15);
5866: l_number_of_copies number(15);
5867:
5868: l_ff_formula_text_clob clob;

Line 5936: ben_copy_entity_results_api.create_copy_entity_results(

5932: --
5933: l_copy_entity_result_id := null;
5934: l_object_version_number := null;
5935:
5936: ben_copy_entity_results_api.create_copy_entity_results(
5937: p_copy_entity_result_id => l_copy_entity_result_id,
5938: p_copy_entity_txn_id => p_copy_entity_txn_id,
5939: p_result_type_cd => l_result_type_cd,
5940: p_mirror_src_entity_result_id => l_mirror_src_entity_result_id,

Line 5976: update ben_copy_entity_results cped

5972: and fff.business_Group_id = l_fff_rec.business_group_id;
5973:
5974: l_ff_formula_text_clob := RTrim(to_char(l_ff_formula_text_long));
5975:
5976: update ben_copy_entity_results cped
5977: set cped.INFORMATION325 = l_ff_formula_text_clob
5978: where cped.COPY_ENTITY_RESULT_ID = l_copy_entity_result_id
5979: and cped.copy_entity_txn_id = p_copy_entity_txn_id;
5980:

Line 6009: l_copy_entity_result_id ben_copy_entity_results.copy_entity_result_id%TYPE;

6005: ,p_business_group_id in number default null
6006: ,p_number_of_copies in number default 0
6007: ,p_effective_date in date
6008: ) is
6009: l_copy_entity_result_id ben_copy_entity_results.copy_entity_result_id%TYPE;
6010: l_proc varchar2(72) := g_package||'create_actn_typ_result';
6011: l_object_version_number ben_copy_entity_results.object_version_number%TYPE;
6012: --
6013: l_cv_result_type_cd varchar2(30) := 'DISPLAY' ;

Line 6011: l_object_version_number ben_copy_entity_results.object_version_number%TYPE;

6007: ,p_effective_date in date
6008: ) is
6009: l_copy_entity_result_id ben_copy_entity_results.copy_entity_result_id%TYPE;
6010: l_proc varchar2(72) := g_package||'create_actn_typ_result';
6011: l_object_version_number ben_copy_entity_results.object_version_number%TYPE;
6012: --
6013: l_cv_result_type_cd varchar2(30) := 'DISPLAY' ;
6014: --
6015: cursor c_parent_result(c_parent_pk_id number,

Line 6020: from ben_copy_entity_results cpe

6016: -- c_parent_table_name varchar2,
6017: c_parent_table_alias varchar2,
6018: c_copy_entity_txn_id number) is
6019: select copy_entity_result_id mirror_src_entity_result_id
6020: from ben_copy_entity_results cpe
6021: -- ,pqh_table_route trt
6022: where cpe.information1= c_parent_pk_id
6023: and cpe.result_type_cd = l_cv_result_type_cd
6024: and cpe.copy_entity_txn_id = c_copy_entity_txn_id

Line 6041: l_information5 ben_copy_entity_results.information5%type;

6037: ---
6038: l_mirror_src_entity_result_id number(15);
6039: l_table_route_id number(15);
6040: l_result_type_cd varchar2(30);
6041: l_information5 ben_copy_entity_results.information5%type;
6042: l_number_of_copies number(15);
6043: ---------------------------------------------------------------
6044: -- START OF BEN_ACTN_TYP ----------------------
6045: ---------------------------------------------------------------

Line 6053: from ben_copy_entity_results cpe

6049: from BEN_ACTN_TYP eat
6050: where eat.business_group_id = p_business_group_id
6051: and not exists (
6052: select /* */ null
6053: from ben_copy_entity_results cpe
6054: -- ,pqh_table_route trt
6055: where copy_entity_txn_id = p_copy_entity_txn_id
6056: -- and trt.table_route_id = cpe.table_route_id
6057: and cpe.table_alias = c_table_alias

Line 6087: ben_copy_entity_results_api.create_copy_entity_results(

6083: l_result_type_cd := 'DISPLAY';
6084: --
6085: l_copy_entity_result_id := null;
6086: l_object_version_number := null;
6087: ben_copy_entity_results_api.create_copy_entity_results(
6088: p_copy_entity_result_id => l_copy_entity_result_id,
6089: p_copy_entity_txn_id => p_copy_entity_txn_id,
6090: p_result_type_cd => l_result_type_cd,
6091: p_mirror_src_entity_result_id => l_mirror_src_entity_result_id,