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_PD_COPY_TO_BEN_TWO dependencies on BEN_PD_COPY_TO_BEN_TWO

Line 1: Package BODY BEN_PD_COPY_TO_BEN_TWO as

1: Package BODY BEN_PD_COPY_TO_BEN_TWO as
2: /* $Header: bepdccp2.pkb 120.15.12020000.2 2012/09/10 06:45:25 amnaraya ship $ */
3:
4: --
5: --UPD Changes New procedure for getting the dtmodes

Line 27364: BEN_PD_COPY_TO_BEN_TWO.create_SAZ_rows(

27360: --
27361: -- Create all Service Area Postal Zip Range rows
27362: --
27363: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('SAZ') then
27364: BEN_PD_COPY_TO_BEN_TWO.create_SAZ_rows(
27365: p_validate => p_validate
27366: ,p_copy_entity_txn_id => p_copy_entity_txn_id
27367: ,p_effective_date => p_effective_date
27368: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 27378: BEN_PD_COPY_TO_BEN_TWO.create_COP_rows(

27374: --
27375: -- Create all oipl rows. Moved these calls to End
27376: --
27377: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('COP') then
27378: BEN_PD_COPY_TO_BEN_TWO.create_COP_rows(
27379: p_validate => p_validate
27380: ,p_copy_entity_txn_id => p_copy_entity_txn_id
27381: ,p_effective_date => p_effective_date
27382: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 27392: BEN_PD_COPY_TO_BEN_TWO.create_DDR_rows(

27388: --
27389: -- Create all DDR rows, which could be attached to opt, oipl, pl levels..
27390: --
27391: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('DDR') then
27392: BEN_PD_COPY_TO_BEN_TWO.create_DDR_rows(
27393: p_validate => p_validate
27394: ,p_copy_entity_txn_id => p_copy_entity_txn_id
27395: ,p_effective_date => p_effective_date
27396: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 27406: BEN_PD_COPY_TO_BEN_TWO.create_DRR_rows(

27402: --
27403: -- Create all DRR rows, which could be attached to DRR rows.
27404: --
27405: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('DRR') then
27406: BEN_PD_COPY_TO_BEN_TWO.create_DRR_rows(
27407: p_validate => p_validate
27408: ,p_copy_entity_txn_id => p_copy_entity_txn_id
27409: ,p_effective_date => p_effective_date
27410: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 27427: BEN_PD_COPY_TO_BEN_TWO.create_CPY_rows(

27423: -- CPY records are created at PGM and PL level
27424: -- This call creates the intersections between all these levels and yr_perds.
27425: --
27426: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('CPY') then
27427: BEN_PD_COPY_TO_BEN_TWO.create_CPY_rows(
27428: p_validate => p_validate
27429: ,p_copy_entity_txn_id => p_copy_entity_txn_id
27430: ,p_effective_date => p_effective_date
27431: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 27439: BEN_PD_COPY_TO_BEN_TWO.create_CWG_rows(

27435: );
27436: end if;
27437: --
27438: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('CWG') then
27439: BEN_PD_COPY_TO_BEN_TWO.create_CWG_rows(
27440: p_validate => p_validate
27441: ,p_copy_entity_txn_id => p_copy_entity_txn_id
27442: ,p_effective_date => p_effective_date
27443: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 27462: BEN_PD_COPY_TO_BEN_TWO.create_PAT_rows(

27458: -- PAT records are created at PGM and PL level
27459: -- This call creates the intersections between all these levels and Action type.
27460: --
27461: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('PAT') then
27462: BEN_PD_COPY_TO_BEN_TWO.create_PAT_rows(
27463: p_validate => p_validate
27464: ,p_copy_entity_txn_id => p_copy_entity_txn_id
27465: ,p_effective_date => p_effective_date
27466: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 27478: BEN_PD_COPY_TO_BEN_TWO.create_PET_rows(

27474: -- PET records are created at PGM and PL level
27475: -- This call creates the intersections between all these levels and enrt type cycl code.
27476: --
27477: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('PET') then
27478: BEN_PD_COPY_TO_BEN_TWO.create_PET_rows(
27479: p_validate => p_validate
27480: ,p_copy_entity_txn_id => p_copy_entity_txn_id
27481: ,p_effective_date => p_effective_date
27482: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 27493: BEN_PD_COPY_TO_BEN_TWO.create_ENP_rows(

27489: -- ENP records are created at PGM and PL level
27490: -- This call creates the intersections between all these levels and year periods.
27491: --
27492: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('ENP') then
27493: BEN_PD_COPY_TO_BEN_TWO.create_ENP_rows(
27494: p_validate => p_validate
27495: ,p_copy_entity_txn_id => p_copy_entity_txn_id
27496: ,p_effective_date => p_effective_date
27497: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 27509: BEN_PD_COPY_TO_BEN_TWO.create_LEN_rows(

27505: -- LEN records are created at PGM and PL level
27506: -- This call creates the intersections between all these levels and ler.
27507: --
27508: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('LEN') then
27509: BEN_PD_COPY_TO_BEN_TWO.create_LEN_rows(
27510: p_validate => p_validate
27511: ,p_copy_entity_txn_id => p_copy_entity_txn_id
27512: ,p_effective_date => p_effective_date
27513: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 27524: BEN_PD_COPY_TO_BEN_TWO.create_LOP_rows(

27520: --
27521: -- LOP records are created at OIPL and LER level
27522: --
27523: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('LOP') then
27524: BEN_PD_COPY_TO_BEN_TWO.create_LOP_rows(
27525: p_validate => p_validate
27526: ,p_copy_entity_txn_id => p_copy_entity_txn_id
27527: ,p_effective_date => p_effective_date
27528: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 27539: BEN_PD_COPY_TO_BEN_TWO.create_ERP_rows(

27535: --
27536: -- ERP records are created at LEN or ENP level
27537: --
27538: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('ERP') then
27539: BEN_PD_COPY_TO_BEN_TWO.create_ERP_rows(
27540: p_validate => p_validate
27541: ,p_copy_entity_txn_id => p_copy_entity_txn_id
27542: ,p_effective_date => p_effective_date
27543: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 27554: BEN_PD_COPY_TO_BEN_TWO.create_SER_rows(

27550: --
27551: -- SER records are created at ENP level
27552: --
27553: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('SER') then
27554: BEN_PD_COPY_TO_BEN_TWO.create_SER_rows(
27555: p_validate => p_validate
27556: ,p_copy_entity_txn_id => p_copy_entity_txn_id
27557: ,p_effective_date => p_effective_date
27558: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 27571: BEN_PD_COPY_TO_BEN_TWO.create_ECF_rows(

27567: -- This call creates the intersections between all these levels and
27568: -- enrt_ctfn_cd
27569: --
27570: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('ECF') then
27571: BEN_PD_COPY_TO_BEN_TWO.create_ECF_rows(
27572: p_validate => p_validate
27573: ,p_copy_entity_txn_id => p_copy_entity_txn_id
27574: ,p_effective_date => p_effective_date
27575: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 27587: BEN_PD_COPY_TO_BEN_TWO.create_CPO_rows(

27583: -- This call creates the intersections between these levels and
27584: -- Organization
27585: --
27586: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('CPO') then
27587: BEN_PD_COPY_TO_BEN_TWO.create_CPO_rows(
27588: p_validate => p_validate
27589: ,p_copy_entity_txn_id => p_copy_entity_txn_id
27590: ,p_effective_date => p_effective_date
27591: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 27602: BEN_PD_COPY_TO_BEN_TWO.create_CPR_rows(

27598: -- This call creates the child records for the CPO level
27599: --
27600: --
27601: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('CPR') then
27602: BEN_PD_COPY_TO_BEN_TWO.create_CPR_rows(
27603: p_validate => p_validate
27604: ,p_copy_entity_txn_id => p_copy_entity_txn_id
27605: ,p_effective_date => p_effective_date
27606: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 27618: BEN_PD_COPY_TO_BEN_TWO.create_RGR_rows(

27614: -- This call creates the intersections between these levels and
27615: -- reporting group
27616: --
27617: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('RGR') then
27618: BEN_PD_COPY_TO_BEN_TWO.create_RGR_rows(
27619: p_validate => p_validate
27620: ,p_copy_entity_txn_id => p_copy_entity_txn_id
27621: ,p_effective_date => p_effective_date
27622: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 27634: BEN_PD_COPY_TO_BEN_TWO.create_PRG_rows(

27630: -- This call creates the intersections between these levels and
27631: -- REGN
27632: --
27633: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('PRG') then
27634: BEN_PD_COPY_TO_BEN_TWO.create_PRG_rows(
27635: p_validate => p_validate
27636: ,p_copy_entity_txn_id => p_copy_entity_txn_id
27637: ,p_effective_date => p_effective_date
27638: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 27647: BEN_PD_COPY_TO_BEN_two.create_ACP_rows

27643: end if;
27644:
27645: --
27646: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('ACP') then
27647: BEN_PD_COPY_TO_BEN_two.create_ACP_rows
27648: (p_validate => p_validate
27649: ,p_copy_entity_txn_id => p_copy_entity_txn_id
27650: ,p_effective_date => p_effective_date
27651: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 27662: BEN_PD_COPY_TO_BEN_TWO.create_CTP_rows(

27658: -- Start of Intersections for the PTIP
27659: -- CTP records are created at Program and Plan Intersection
27660: --
27661: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('CTP') then
27662: BEN_PD_COPY_TO_BEN_TWO.create_CTP_rows(
27663: p_validate => p_validate
27664: ,p_copy_entity_txn_id => p_copy_entity_txn_id
27665: ,p_effective_date => p_effective_date
27666: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 27677: BEN_PD_COPY_TO_BEN_TWO.create_ADE_rows(

27673: -- This call creates the intersections between all these levels and
27674: -- ben_dpnt_cvg_eligy_prfl_f
27675: --
27676: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('ADE') then
27677: BEN_PD_COPY_TO_BEN_TWO.create_ADE_rows(
27678: p_validate => p_validate
27679: ,p_copy_entity_txn_id => p_copy_entity_txn_id
27680: ,p_effective_date => p_effective_date
27681: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 27693: BEN_PD_COPY_TO_BEN_TWO.create_LDC_rows(

27689: -- This call creates the intersections between all these levels and
27690: -- ben_ler_f
27691: --
27692: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('LDC') then
27693: BEN_PD_COPY_TO_BEN_TWO.create_LDC_rows(
27694: p_validate => p_validate
27695: ,p_copy_entity_txn_id => p_copy_entity_txn_id
27696: ,p_effective_date => p_effective_date
27697: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 27707: BEN_PD_COPY_TO_BEN_TWO.create_LCC_rows(

27703: --
27704: -- LCC records are created at LDC and certification type
27705: --
27706: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('LCC') then
27707: BEN_PD_COPY_TO_BEN_TWO.create_LCC_rows(
27708: p_validate => p_validate
27709: ,p_copy_entity_txn_id => p_copy_entity_txn_id
27710: ,p_effective_date => p_effective_date
27711: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 27720: BEN_PD_COPY_TO_BEN_TWO.create_WPT_rows(

27716: end if;
27717: -- WPT records are created at PTIP and wv_prtn_rsn_cd intersection
27718: --
27719: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('WPT') then
27720: BEN_PD_COPY_TO_BEN_TWO.create_WPT_rows(
27721: p_validate => p_validate
27722: ,p_copy_entity_txn_id => p_copy_entity_txn_id
27723: ,p_effective_date => p_effective_date
27724: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 27733: BEN_PD_COPY_TO_BEN_TWO.create_WCT_rows(

27729: end if;
27730: -- WCT records are created at WPT and wv_prtn_ctfn_typ_cd intersection
27731: --
27732: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('WCT') then
27733: BEN_PD_COPY_TO_BEN_TWO.create_WCT_rows(
27734: p_validate => p_validate
27735: ,p_copy_entity_txn_id => p_copy_entity_txn_id
27736: ,p_effective_date => p_effective_date
27737: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 27746: BEN_PD_COPY_TO_BEN_TWO.create_LCT_rows(

27742: end if;
27743: -- LCT records are created at PTIP and LER_ID intersection
27744: --
27745: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('LCT') then
27746: BEN_PD_COPY_TO_BEN_TWO.create_LCT_rows(
27747: p_validate => p_validate
27748: ,p_copy_entity_txn_id => p_copy_entity_txn_id
27749: ,p_effective_date => p_effective_date
27750: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 27759: BEN_PD_COPY_TO_BEN_TWO.create_PYD_rows(

27755: end if;
27756: -- PYD records are created at PTIP and dependent certification type intersection
27757: --
27758: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('PYD') then
27759: BEN_PD_COPY_TO_BEN_TWO.create_PYD_rows(
27760: p_validate => p_validate
27761: ,p_copy_entity_txn_id => p_copy_entity_txn_id
27762: ,p_effective_date => p_effective_date
27763: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 27773: BEN_PD_COPY_TO_BEN_TWO.create_CPP_rows(

27769: -- PLIP Rows start here
27770: -- CPP records are created at PGM and PLN intersection
27771: -- XXXPLIP
27772: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('CPP') then
27773: BEN_PD_COPY_TO_BEN_TWO.create_CPP_rows(
27774: p_validate => p_validate
27775: ,p_copy_entity_txn_id => p_copy_entity_txn_id
27776: ,p_effective_date => p_effective_date
27777: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 27786: BEN_PD_COPY_TO_BEN_TWO.create_OPP_rows(

27782: end if;
27783:
27784: -- OIPLIP Always Reuse, never create
27785: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('OPP') then
27786: BEN_PD_COPY_TO_BEN_TWO.create_OPP_rows(
27787: p_validate => p_validate
27788: ,p_copy_entity_txn_id => p_copy_entity_txn_id
27789: ,p_effective_date => p_effective_date
27790: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 27800: BEN_PD_COPY_TO_BEN_TWO.create_OTP_rows(

27796: --
27797: -- OPTIP Always Reuse, never create
27798: /* Commented out for Now - Not Complete
27799: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('OTP') then
27800: BEN_PD_COPY_TO_BEN_TWO.create_OTP_rows(
27801: p_validate => p_validate
27802: ,p_copy_entity_txn_id => p_copy_entity_txn_id
27803: ,p_effective_date => p_effective_date
27804: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 27816: BEN_PD_COPY_TO_BEN_TWO.create_BPP_rows(

27812: -- Moved call from bepdccp1.pkb so that Benefit Pools are
27813: -- created after PLIP, PTIP and OIPLIP
27814: --
27815: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('BPP') then
27816: BEN_PD_COPY_TO_BEN_TWO.create_BPP_rows(
27817: p_validate => p_validate
27818: ,p_copy_entity_txn_id => p_copy_entity_txn_id
27819: ,p_effective_date => p_effective_date
27820: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 27831: BEN_PD_COPY_TO_BEN_TWO.create_LBR_rows(

27827:
27828: -- LBR records are created at PLIP and LER intersection
27829: --
27830: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('LBR') then
27831: BEN_PD_COPY_TO_BEN_TWO.create_LBR_rows(
27832: p_validate => p_validate
27833: ,p_copy_entity_txn_id => p_copy_entity_txn_id
27834: ,p_effective_date => p_effective_date
27835: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 27845: BEN_PD_COPY_TO_BEN_TWO.create_LPR1_rows(

27841: --
27842: -- LPR1 records are created at PLIP and LER intersection
27843: --
27844: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('LPR1') then
27845: BEN_PD_COPY_TO_BEN_TWO.create_LPR1_rows(
27846: p_validate => p_validate
27847: ,p_copy_entity_txn_id => p_copy_entity_txn_id
27848: ,p_effective_date => p_effective_date
27849: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 27859: BEN_PD_COPY_TO_BEN_TWO.create_VGS_rows(

27855: -- Plan Intersections
27856: -- VGS records are created at PL and GOS intersection
27857: --
27858: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('VGS') then
27859: BEN_PD_COPY_TO_BEN_TWO.create_VGS_rows(
27860: p_validate => p_validate
27861: ,p_copy_entity_txn_id => p_copy_entity_txn_id
27862: ,p_effective_date => p_effective_date
27863: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 27872: BEN_PD_COPY_TO_BEN_TWO.create_PCT_rows(

27868: end if;
27869: -- PCT records are created at VGS and certification type intersection
27870: --
27871: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('PCT') then
27872: BEN_PD_COPY_TO_BEN_TWO.create_PCT_rows(
27873: p_validate => p_validate
27874: ,p_copy_entity_txn_id => p_copy_entity_txn_id
27875: ,p_effective_date => p_effective_date
27876: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 27885: BEN_PD_COPY_TO_BEN_TWO.create_VRP_rows(

27881: end if;
27882: -- VRP records as child record of PL
27883: --
27884: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('VRP') then
27885: BEN_PD_COPY_TO_BEN_TWO.create_VRP_rows(
27886: p_validate => p_validate
27887: ,p_copy_entity_txn_id => p_copy_entity_txn_id
27888: ,p_effective_date => p_effective_date
27889: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 27899: BEN_PD_COPY_TO_BEN_TWO.create_WPN_rows(

27895: --
27896: -- WPN records are intersection of PL and wv_prtn_rsn_cd
27897: --
27898: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('WPN') then
27899: BEN_PD_COPY_TO_BEN_TWO.create_WPN_rows(
27900: p_validate => p_validate
27901: ,p_copy_entity_txn_id => p_copy_entity_txn_id
27902: ,p_effective_date => p_effective_date
27903: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 27912: BEN_PD_COPY_TO_BEN_TWO.create_WCN_rows(

27908: end if;
27909: -- WCN records are intersection of WPN and wv_prtn_ctfn_typ_cd
27910: --
27911: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('WCN') then
27912: BEN_PD_COPY_TO_BEN_TWO.create_WCN_rows(
27913: p_validate => p_validate
27914: ,p_copy_entity_txn_id => p_copy_entity_txn_id
27915: ,p_effective_date => p_effective_date
27916: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 27926: BEN_PD_COPY_TO_BEN_TWO.create_BRC_rows(

27922: --
27923: -- BRC records are intersection of PL and enrt_ctfn_typ_cd
27924: --
27925: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('BRC') then
27926: BEN_PD_COPY_TO_BEN_TWO.create_BRC_rows(
27927: p_validate => p_validate
27928: ,p_copy_entity_txn_id => p_copy_entity_txn_id
27929: ,p_effective_date => p_effective_date
27930: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 27939: BEN_PD_COPY_TO_BEN_TWO.create_LBC_rows(

27935: end if;
27936: -- LBC records are intersection of ler_bnft_rstrn_id and enrt_ctfn_typ_cd
27937: --
27938: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('LBC') then
27939: BEN_PD_COPY_TO_BEN_TWO.create_LBC_rows(
27940: p_validate => p_validate
27941: ,p_copy_entity_txn_id => p_copy_entity_txn_id
27942: ,p_effective_date => p_effective_date
27943: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 27952: BEN_PD_COPY_TO_BEN_TWO.create_LRE_rows(

27948: end if;
27949: -- LRE records are intersection of PL,OIPL with LER
27950: --
27951: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('LRE') then
27952: BEN_PD_COPY_TO_BEN_TWO.create_LRE_rows(
27953: p_validate => p_validate
27954: ,p_copy_entity_txn_id => p_copy_entity_txn_id
27955: ,p_effective_date => p_effective_date
27956: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 27965: BEN_PD_COPY_TO_BEN_TWO.create_LNC_rows(

27961: end if;
27962: -- LNC records are intersection of LRE and enrt_ctfn_typ_cd
27963: --
27964: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('LNC') then
27965: BEN_PD_COPY_TO_BEN_TWO.create_LNC_rows(
27966: p_validate => p_validate
27967: ,p_copy_entity_txn_id => p_copy_entity_txn_id
27968: ,p_effective_date => p_effective_date
27969: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 27978: BEN_PD_COPY_TO_BEN_TWO.create_LPE_rows(

27974: end if;
27975: -- LPE records are intersection of PLN and LER
27976: --
27977: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('LPE') then
27978: BEN_PD_COPY_TO_BEN_TWO.create_LPE_rows(
27979: p_validate => p_validate
27980: ,p_copy_entity_txn_id => p_copy_entity_txn_id
27981: ,p_effective_date => p_effective_date
27982: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 27991: BEN_PD_COPY_TO_BEN_TWO.create_PND_rows(

27987: end if;
27988: -- PND records are intersection of PLN and dpnt_cvg_ctfn_typ_cd
27989: --
27990: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('PND') then
27991: BEN_PD_COPY_TO_BEN_TWO.create_PND_rows(
27992: p_validate => p_validate
27993: ,p_copy_entity_txn_id => p_copy_entity_txn_id
27994: ,p_effective_date => p_effective_date
27995: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 28010: BEN_PD_COPY_TO_BEN_TWO.create_PEO_rows(

28006: -- PEO records are created at PGM,PTIP,PLIP,PL and OIPLIP level
28007: -- This call creates the intersections between all these levels and ler.
28008: --
28009: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('PEO') then
28010: BEN_PD_COPY_TO_BEN_TWO.create_PEO_rows(
28011: p_validate => p_validate
28012: ,p_copy_entity_txn_id => p_copy_entity_txn_id
28013: ,p_effective_date => p_effective_date
28014: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 28024: BEN_PD_COPY_TO_BEN_TWO.create_EPA_rows(

28020: --
28021: -- EPA records are created at PGM,PTIP,PLIP,PL and OIPLIP level
28022: --
28023: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('EPA') then
28024: BEN_PD_COPY_TO_BEN_TWO.create_EPA_rows(
28025: p_validate => p_validate
28026: ,p_copy_entity_txn_id => p_copy_entity_txn_id
28027: ,p_effective_date => p_effective_date
28028: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 28038: BEN_PD_COPY_TO_BEN_TWO.create_CEP_rows(

28034: --
28035: -- CEP records are created at the intersection of EPA and ELP
28036: --
28037: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('CEP') then
28038: BEN_PD_COPY_TO_BEN_TWO.create_CEP_rows(
28039: p_validate => p_validate
28040: ,p_copy_entity_txn_id => p_copy_entity_txn_id
28041: ,p_effective_date => p_effective_date
28042: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 28051: BEN_PD_COPY_TO_BEN_TWO.create_CER_rows(

28047: end if;
28048: -- CER records are created at the intersection of EPA and FORMULA
28049: --
28050: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('CER') then
28051: BEN_PD_COPY_TO_BEN_TWO.create_CER_rows(
28052: p_validate => p_validate
28053: ,p_copy_entity_txn_id => p_copy_entity_txn_id
28054: ,p_effective_date => p_effective_date
28055: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 28064: BEN_PD_COPY_TO_BEN_TWO.create_PCX_rows(

28060: end if;
28061: --
28062: --
28063: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('PCX') then
28064: BEN_PD_COPY_TO_BEN_TWO.create_PCX_rows(
28065: p_validate => p_validate
28066: ,p_copy_entity_txn_id => p_copy_entity_txn_id
28067: ,p_effective_date => p_effective_date
28068: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 28078: BEN_PD_COPY_TO_BEN_TWO.create_PCP_rows(

28074: --
28075: -- PCP records are intersection of PLN and ben_pl_pcp
28076: --
28077: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('PCP') then
28078: BEN_PD_COPY_TO_BEN_TWO.create_PCP_rows(
28079: p_validate => p_validate
28080: ,p_copy_entity_txn_id => p_copy_entity_txn_id
28081: ,p_effective_date => p_effective_date
28082: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 28092: BEN_PD_COPY_TO_BEN_TWO.create_PTY_rows(

28088: --
28089: -- PTY records are child records of PCP
28090: --
28091: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('PTY') then
28092: BEN_PD_COPY_TO_BEN_TWO.create_PTY_rows(
28093: p_validate => p_validate
28094: ,p_copy_entity_txn_id => p_copy_entity_txn_id
28095: ,p_effective_date => p_effective_date
28096: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 28106: BEN_PD_COPY_TO_BEN_TWO.create_PRB_rows(

28102: --
28103: -- PRB records are child records of PLN OR BNR
28104: --
28105: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('PRB') then
28106: BEN_PD_COPY_TO_BEN_TWO.create_PRB_rows(
28107: p_validate => p_validate
28108: ,p_copy_entity_txn_id => p_copy_entity_txn_id
28109: ,p_effective_date => p_effective_date
28110: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 28119: BEN_PD_COPY_TO_BEN_TWO.create_PRP_rows(

28115: end if;
28116: --
28117: --
28118: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('PRP') then
28119: BEN_PD_COPY_TO_BEN_TWO.create_PRP_rows(
28120: p_validate => p_validate
28121: ,p_copy_entity_txn_id => p_copy_entity_txn_id
28122: ,p_effective_date => p_effective_date
28123: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 28147: if(BEN_PD_COPY_TO_BEN_TWO.g_copy_entity_txn_id <> p_copy_entity_txn_id) then

28143: --
28144: -- First try creating all the leaf rows.
28145: --
28146: --TCS PDW Integration ENH
28147: if(BEN_PD_COPY_TO_BEN_TWO.g_copy_entity_txn_id <> p_copy_entity_txn_id) then
28148:
28149: BEN_PD_COPY_TO_BEN_TWO.g_copy_entity_txn_id := p_copy_entity_txn_id;
28150:
28151: open BEN_PD_COPY_TO_BEN_TWO.g_copy_entity_txn(p_copy_entity_txn_id) ;

Line 28149: BEN_PD_COPY_TO_BEN_TWO.g_copy_entity_txn_id := p_copy_entity_txn_id;

28145: --
28146: --TCS PDW Integration ENH
28147: if(BEN_PD_COPY_TO_BEN_TWO.g_copy_entity_txn_id <> p_copy_entity_txn_id) then
28148:
28149: BEN_PD_COPY_TO_BEN_TWO.g_copy_entity_txn_id := p_copy_entity_txn_id;
28150:
28151: open BEN_PD_COPY_TO_BEN_TWO.g_copy_entity_txn(p_copy_entity_txn_id) ;
28152: fetch BEN_PD_COPY_TO_BEN_TWO.g_copy_entity_txn into BEN_PD_COPY_TO_BEN_TWO.g_row_type_cd;
28153: close BEN_PD_COPY_TO_BEN_TWO.g_copy_entity_txn;

Line 28151: open BEN_PD_COPY_TO_BEN_TWO.g_copy_entity_txn(p_copy_entity_txn_id) ;

28147: if(BEN_PD_COPY_TO_BEN_TWO.g_copy_entity_txn_id <> p_copy_entity_txn_id) then
28148:
28149: BEN_PD_COPY_TO_BEN_TWO.g_copy_entity_txn_id := p_copy_entity_txn_id;
28150:
28151: open BEN_PD_COPY_TO_BEN_TWO.g_copy_entity_txn(p_copy_entity_txn_id) ;
28152: fetch BEN_PD_COPY_TO_BEN_TWO.g_copy_entity_txn into BEN_PD_COPY_TO_BEN_TWO.g_row_type_cd;
28153: close BEN_PD_COPY_TO_BEN_TWO.g_copy_entity_txn;
28154:
28155: end if;

Line 28152: fetch BEN_PD_COPY_TO_BEN_TWO.g_copy_entity_txn into BEN_PD_COPY_TO_BEN_TWO.g_row_type_cd;

28148:
28149: BEN_PD_COPY_TO_BEN_TWO.g_copy_entity_txn_id := p_copy_entity_txn_id;
28150:
28151: open BEN_PD_COPY_TO_BEN_TWO.g_copy_entity_txn(p_copy_entity_txn_id) ;
28152: fetch BEN_PD_COPY_TO_BEN_TWO.g_copy_entity_txn into BEN_PD_COPY_TO_BEN_TWO.g_row_type_cd;
28153: close BEN_PD_COPY_TO_BEN_TWO.g_copy_entity_txn;
28154:
28155: end if;
28156:

Line 28153: close BEN_PD_COPY_TO_BEN_TWO.g_copy_entity_txn;

28149: BEN_PD_COPY_TO_BEN_TWO.g_copy_entity_txn_id := p_copy_entity_txn_id;
28150:
28151: open BEN_PD_COPY_TO_BEN_TWO.g_copy_entity_txn(p_copy_entity_txn_id) ;
28152: fetch BEN_PD_COPY_TO_BEN_TWO.g_copy_entity_txn into BEN_PD_COPY_TO_BEN_TWO.g_row_type_cd;
28153: close BEN_PD_COPY_TO_BEN_TWO.g_copy_entity_txn;
28154:
28155: end if;
28156:
28157: -- TCS PDW Integration passed the parameter BEN_PD_COPY_TO_BEN_TWO.g_row_type_cd to create_all_leaf_ben_rows

Line 28157: -- TCS PDW Integration passed the parameter BEN_PD_COPY_TO_BEN_TWO.g_row_type_cd to create_all_leaf_ben_rows

28153: close BEN_PD_COPY_TO_BEN_TWO.g_copy_entity_txn;
28154:
28155: end if;
28156:
28157: -- TCS PDW Integration passed the parameter BEN_PD_COPY_TO_BEN_TWO.g_row_type_cd to create_all_leaf_ben_rows
28158: BEN_PD_COPY_TO_BEN_ONE.create_all_leaf_ben_rows(
28159: p_validate => p_validate
28160: ,p_copy_entity_txn_id => p_copy_entity_txn_id
28161: ,p_effective_date => p_effective_date

Line 28166: ,p_txn_row_type_cd => BEN_PD_COPY_TO_BEN_TWO.g_row_type_cd

28162: ,p_prefix_suffix_text => p_prefix_suffix_text
28163: ,p_reuse_object_flag => p_reuse_object_flag
28164: ,p_target_business_group_id => p_target_business_group_id
28165: ,p_prefix_suffix_cd => p_prefix_suffix_cd
28166: ,p_txn_row_type_cd => BEN_PD_COPY_TO_BEN_TWO.g_row_type_cd
28167: );
28168:
28169: if (BEN_PD_COPY_TO_BEN_TWO.g_row_type_cd <> 'ELP') then
28170: --TCS PDW Integration ENH

Line 28169: if (BEN_PD_COPY_TO_BEN_TWO.g_row_type_cd <> 'ELP') then

28165: ,p_prefix_suffix_cd => p_prefix_suffix_cd
28166: ,p_txn_row_type_cd => BEN_PD_COPY_TO_BEN_TWO.g_row_type_cd
28167: );
28168:
28169: if (BEN_PD_COPY_TO_BEN_TWO.g_row_type_cd <> 'ELP') then
28170: --TCS PDW Integration ENH
28171: --
28172: -- ben_popl_enrt_typ_cycl_f rows are created as pgm and pl, yrp, wyp rows
28173: -- are created as part of leaf call and above call.

Line 28175: BEN_PD_COPY_TO_BEN_TWO.create_final_intersect_rows(

28171: --
28172: -- ben_popl_enrt_typ_cycl_f rows are created as pgm and pl, yrp, wyp rows
28173: -- are created as part of leaf call and above call.
28174: --
28175: BEN_PD_COPY_TO_BEN_TWO.create_final_intersect_rows(
28176: p_validate => p_validate
28177: ,p_copy_entity_txn_id => p_copy_entity_txn_id
28178: ,p_effective_date => p_effective_date
28179: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 28189: BEN_PD_COPY_TO_BEN_TWO.create_LGE_rows(

28185: -- LGE records are created at Only PGM level
28186: -- This call creates the intersections between the program levels and ler.
28187: --
28188: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('LGE') then
28189: BEN_PD_COPY_TO_BEN_TWO.create_LGE_rows(
28190: p_validate => p_validate
28191: ,p_copy_entity_txn_id => p_copy_entity_txn_id
28192: ,p_effective_date => p_effective_date
28193: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 28204: BEN_PD_COPY_TO_BEN_TWO.create_PGC_rows(

28200: -- PGC records are created at Only PGM level
28201: -- This call creates the intersections between the program levels and dpnt_cvg_ctfn_typ_cd.
28202: --
28203: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('PGC') then
28204: BEN_PD_COPY_TO_BEN_TWO.create_PGC_rows(
28205: p_validate => p_validate
28206: ,p_copy_entity_txn_id => p_copy_entity_txn_id
28207: ,p_effective_date => p_effective_date
28208: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 28238: if (BEN_PD_COPY_TO_BEN_TWO.g_row_type_cd <> 'ELP') then

28234: -- Now make call to rate and all other ows creation
28235: --
28236: --TCS PDW Integration ENH
28237:
28238: if (BEN_PD_COPY_TO_BEN_TWO.g_row_type_cd <> 'ELP') then
28239: --TCS PDW Integration ENH
28240:
28241: BEN_PD_COPY_TO_BEN_five.create_rate_rows
28242: (

Line 28326: BEN_PD_COPY_TO_BEN_TWO.create_pgm_intersect_rows(

28322:
28323: -- Initialize global variable for Transaction Category
28324: BEN_PD_COPY_TO_BEN_ONE.g_transaction_category := l_transaction_category.short_name;
28325:
28326: BEN_PD_COPY_TO_BEN_TWO.create_pgm_intersect_rows(
28327: p_validate => p_validate
28328: ,p_copy_entity_txn_id => p_copy_entity_txn_id
28329: ,p_effective_date => p_effective_date
28330: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 28342: end BEN_PD_COPY_TO_BEN_TWO;

28338: --
28339: --
28340: end create_stg_to_ben_rows ;
28341: --
28342: end BEN_PD_COPY_TO_BEN_TWO;