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.11.12000000.2 2007/08/23 21:29:01 sshetty noship $ */
3:
4: --
5: --UPD Changes New procedure for getting the dtmodes

Line 27262: BEN_PD_COPY_TO_BEN_TWO.create_SAZ_rows(

27258: --
27259: -- Create all Service Area Postal Zip Range rows
27260: --
27261: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('SAZ') then
27262: BEN_PD_COPY_TO_BEN_TWO.create_SAZ_rows(
27263: p_validate => p_validate
27264: ,p_copy_entity_txn_id => p_copy_entity_txn_id
27265: ,p_effective_date => p_effective_date
27266: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 27276: BEN_PD_COPY_TO_BEN_TWO.create_COP_rows(

27272: --
27273: -- Create all oipl rows. Moved these calls to End
27274: --
27275: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('COP') then
27276: BEN_PD_COPY_TO_BEN_TWO.create_COP_rows(
27277: p_validate => p_validate
27278: ,p_copy_entity_txn_id => p_copy_entity_txn_id
27279: ,p_effective_date => p_effective_date
27280: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 27290: BEN_PD_COPY_TO_BEN_TWO.create_DDR_rows(

27286: --
27287: -- Create all DDR rows, which could be attached to opt, oipl, pl levels..
27288: --
27289: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('DDR') then
27290: BEN_PD_COPY_TO_BEN_TWO.create_DDR_rows(
27291: p_validate => p_validate
27292: ,p_copy_entity_txn_id => p_copy_entity_txn_id
27293: ,p_effective_date => p_effective_date
27294: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 27304: BEN_PD_COPY_TO_BEN_TWO.create_DRR_rows(

27300: --
27301: -- Create all DRR rows, which could be attached to DRR rows.
27302: --
27303: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('DRR') then
27304: BEN_PD_COPY_TO_BEN_TWO.create_DRR_rows(
27305: p_validate => p_validate
27306: ,p_copy_entity_txn_id => p_copy_entity_txn_id
27307: ,p_effective_date => p_effective_date
27308: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 27325: BEN_PD_COPY_TO_BEN_TWO.create_CPY_rows(

27321: -- CPY records are created at PGM and PL level
27322: -- This call creates the intersections between all these levels and yr_perds.
27323: --
27324: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('CPY') then
27325: BEN_PD_COPY_TO_BEN_TWO.create_CPY_rows(
27326: p_validate => p_validate
27327: ,p_copy_entity_txn_id => p_copy_entity_txn_id
27328: ,p_effective_date => p_effective_date
27329: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 27337: BEN_PD_COPY_TO_BEN_TWO.create_CWG_rows(

27333: );
27334: end if;
27335: --
27336: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('CWG') then
27337: BEN_PD_COPY_TO_BEN_TWO.create_CWG_rows(
27338: p_validate => p_validate
27339: ,p_copy_entity_txn_id => p_copy_entity_txn_id
27340: ,p_effective_date => p_effective_date
27341: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 27360: BEN_PD_COPY_TO_BEN_TWO.create_PAT_rows(

27356: -- PAT records are created at PGM and PL level
27357: -- This call creates the intersections between all these levels and Action type.
27358: --
27359: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('PAT') then
27360: BEN_PD_COPY_TO_BEN_TWO.create_PAT_rows(
27361: p_validate => p_validate
27362: ,p_copy_entity_txn_id => p_copy_entity_txn_id
27363: ,p_effective_date => p_effective_date
27364: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 27376: BEN_PD_COPY_TO_BEN_TWO.create_PET_rows(

27372: -- PET records are created at PGM and PL level
27373: -- This call creates the intersections between all these levels and enrt type cycl code.
27374: --
27375: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('PET') then
27376: BEN_PD_COPY_TO_BEN_TWO.create_PET_rows(
27377: p_validate => p_validate
27378: ,p_copy_entity_txn_id => p_copy_entity_txn_id
27379: ,p_effective_date => p_effective_date
27380: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 27391: BEN_PD_COPY_TO_BEN_TWO.create_ENP_rows(

27387: -- ENP records are created at PGM and PL level
27388: -- This call creates the intersections between all these levels and year periods.
27389: --
27390: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('ENP') then
27391: BEN_PD_COPY_TO_BEN_TWO.create_ENP_rows(
27392: p_validate => p_validate
27393: ,p_copy_entity_txn_id => p_copy_entity_txn_id
27394: ,p_effective_date => p_effective_date
27395: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 27407: BEN_PD_COPY_TO_BEN_TWO.create_LEN_rows(

27403: -- LEN records are created at PGM and PL level
27404: -- This call creates the intersections between all these levels and ler.
27405: --
27406: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('LEN') then
27407: BEN_PD_COPY_TO_BEN_TWO.create_LEN_rows(
27408: p_validate => p_validate
27409: ,p_copy_entity_txn_id => p_copy_entity_txn_id
27410: ,p_effective_date => p_effective_date
27411: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 27422: BEN_PD_COPY_TO_BEN_TWO.create_LOP_rows(

27418: --
27419: -- LOP records are created at OIPL and LER level
27420: --
27421: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('LOP') then
27422: BEN_PD_COPY_TO_BEN_TWO.create_LOP_rows(
27423: p_validate => p_validate
27424: ,p_copy_entity_txn_id => p_copy_entity_txn_id
27425: ,p_effective_date => p_effective_date
27426: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 27437: BEN_PD_COPY_TO_BEN_TWO.create_ERP_rows(

27433: --
27434: -- ERP records are created at LEN or ENP level
27435: --
27436: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('ERP') then
27437: BEN_PD_COPY_TO_BEN_TWO.create_ERP_rows(
27438: p_validate => p_validate
27439: ,p_copy_entity_txn_id => p_copy_entity_txn_id
27440: ,p_effective_date => p_effective_date
27441: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 27452: BEN_PD_COPY_TO_BEN_TWO.create_SER_rows(

27448: --
27449: -- SER records are created at ENP level
27450: --
27451: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('SER') then
27452: BEN_PD_COPY_TO_BEN_TWO.create_SER_rows(
27453: p_validate => p_validate
27454: ,p_copy_entity_txn_id => p_copy_entity_txn_id
27455: ,p_effective_date => p_effective_date
27456: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 27469: BEN_PD_COPY_TO_BEN_TWO.create_ECF_rows(

27465: -- This call creates the intersections between all these levels and
27466: -- enrt_ctfn_cd
27467: --
27468: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('ECF') then
27469: BEN_PD_COPY_TO_BEN_TWO.create_ECF_rows(
27470: p_validate => p_validate
27471: ,p_copy_entity_txn_id => p_copy_entity_txn_id
27472: ,p_effective_date => p_effective_date
27473: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 27485: BEN_PD_COPY_TO_BEN_TWO.create_CPO_rows(

27481: -- This call creates the intersections between these levels and
27482: -- Organization
27483: --
27484: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('CPO') then
27485: BEN_PD_COPY_TO_BEN_TWO.create_CPO_rows(
27486: p_validate => p_validate
27487: ,p_copy_entity_txn_id => p_copy_entity_txn_id
27488: ,p_effective_date => p_effective_date
27489: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 27500: BEN_PD_COPY_TO_BEN_TWO.create_CPR_rows(

27496: -- This call creates the child records for the CPO level
27497: --
27498: --
27499: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('CPR') then
27500: BEN_PD_COPY_TO_BEN_TWO.create_CPR_rows(
27501: p_validate => p_validate
27502: ,p_copy_entity_txn_id => p_copy_entity_txn_id
27503: ,p_effective_date => p_effective_date
27504: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 27516: BEN_PD_COPY_TO_BEN_TWO.create_RGR_rows(

27512: -- This call creates the intersections between these levels and
27513: -- reporting group
27514: --
27515: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('RGR') then
27516: BEN_PD_COPY_TO_BEN_TWO.create_RGR_rows(
27517: p_validate => p_validate
27518: ,p_copy_entity_txn_id => p_copy_entity_txn_id
27519: ,p_effective_date => p_effective_date
27520: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 27532: BEN_PD_COPY_TO_BEN_TWO.create_PRG_rows(

27528: -- This call creates the intersections between these levels and
27529: -- REGN
27530: --
27531: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('PRG') then
27532: BEN_PD_COPY_TO_BEN_TWO.create_PRG_rows(
27533: p_validate => p_validate
27534: ,p_copy_entity_txn_id => p_copy_entity_txn_id
27535: ,p_effective_date => p_effective_date
27536: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 27545: BEN_PD_COPY_TO_BEN_two.create_ACP_rows

27541: end if;
27542:
27543: --
27544: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('ACP') then
27545: BEN_PD_COPY_TO_BEN_two.create_ACP_rows
27546: (p_validate => p_validate
27547: ,p_copy_entity_txn_id => p_copy_entity_txn_id
27548: ,p_effective_date => p_effective_date
27549: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 27560: BEN_PD_COPY_TO_BEN_TWO.create_CTP_rows(

27556: -- Start of Intersections for the PTIP
27557: -- CTP records are created at Program and Plan Intersection
27558: --
27559: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('CTP') then
27560: BEN_PD_COPY_TO_BEN_TWO.create_CTP_rows(
27561: p_validate => p_validate
27562: ,p_copy_entity_txn_id => p_copy_entity_txn_id
27563: ,p_effective_date => p_effective_date
27564: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 27575: BEN_PD_COPY_TO_BEN_TWO.create_ADE_rows(

27571: -- This call creates the intersections between all these levels and
27572: -- ben_dpnt_cvg_eligy_prfl_f
27573: --
27574: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('ADE') then
27575: BEN_PD_COPY_TO_BEN_TWO.create_ADE_rows(
27576: p_validate => p_validate
27577: ,p_copy_entity_txn_id => p_copy_entity_txn_id
27578: ,p_effective_date => p_effective_date
27579: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 27591: BEN_PD_COPY_TO_BEN_TWO.create_LDC_rows(

27587: -- This call creates the intersections between all these levels and
27588: -- ben_ler_f
27589: --
27590: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('LDC') then
27591: BEN_PD_COPY_TO_BEN_TWO.create_LDC_rows(
27592: p_validate => p_validate
27593: ,p_copy_entity_txn_id => p_copy_entity_txn_id
27594: ,p_effective_date => p_effective_date
27595: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 27605: BEN_PD_COPY_TO_BEN_TWO.create_LCC_rows(

27601: --
27602: -- LCC records are created at LDC and certification type
27603: --
27604: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('LCC') then
27605: BEN_PD_COPY_TO_BEN_TWO.create_LCC_rows(
27606: p_validate => p_validate
27607: ,p_copy_entity_txn_id => p_copy_entity_txn_id
27608: ,p_effective_date => p_effective_date
27609: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 27618: BEN_PD_COPY_TO_BEN_TWO.create_WPT_rows(

27614: end if;
27615: -- WPT records are created at PTIP and wv_prtn_rsn_cd intersection
27616: --
27617: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('WPT') then
27618: BEN_PD_COPY_TO_BEN_TWO.create_WPT_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 27631: BEN_PD_COPY_TO_BEN_TWO.create_WCT_rows(

27627: end if;
27628: -- WCT records are created at WPT and wv_prtn_ctfn_typ_cd intersection
27629: --
27630: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('WCT') then
27631: BEN_PD_COPY_TO_BEN_TWO.create_WCT_rows(
27632: p_validate => p_validate
27633: ,p_copy_entity_txn_id => p_copy_entity_txn_id
27634: ,p_effective_date => p_effective_date
27635: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 27644: BEN_PD_COPY_TO_BEN_TWO.create_LCT_rows(

27640: end if;
27641: -- LCT records are created at PTIP and LER_ID intersection
27642: --
27643: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('LCT') then
27644: BEN_PD_COPY_TO_BEN_TWO.create_LCT_rows(
27645: p_validate => p_validate
27646: ,p_copy_entity_txn_id => p_copy_entity_txn_id
27647: ,p_effective_date => p_effective_date
27648: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 27657: BEN_PD_COPY_TO_BEN_TWO.create_PYD_rows(

27653: end if;
27654: -- PYD records are created at PTIP and dependent certification type intersection
27655: --
27656: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('PYD') then
27657: BEN_PD_COPY_TO_BEN_TWO.create_PYD_rows(
27658: p_validate => p_validate
27659: ,p_copy_entity_txn_id => p_copy_entity_txn_id
27660: ,p_effective_date => p_effective_date
27661: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 27671: BEN_PD_COPY_TO_BEN_TWO.create_CPP_rows(

27667: -- PLIP Rows start here
27668: -- CPP records are created at PGM and PLN intersection
27669: -- XXXPLIP
27670: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('CPP') then
27671: BEN_PD_COPY_TO_BEN_TWO.create_CPP_rows(
27672: p_validate => p_validate
27673: ,p_copy_entity_txn_id => p_copy_entity_txn_id
27674: ,p_effective_date => p_effective_date
27675: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 27684: BEN_PD_COPY_TO_BEN_TWO.create_OPP_rows(

27680: end if;
27681:
27682: -- OIPLIP Always Reuse, never create
27683: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('OPP') then
27684: BEN_PD_COPY_TO_BEN_TWO.create_OPP_rows(
27685: p_validate => p_validate
27686: ,p_copy_entity_txn_id => p_copy_entity_txn_id
27687: ,p_effective_date => p_effective_date
27688: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 27698: BEN_PD_COPY_TO_BEN_TWO.create_OTP_rows(

27694: --
27695: -- OPTIP Always Reuse, never create
27696: /* Commented out for Now - Not Complete
27697: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('OTP') then
27698: BEN_PD_COPY_TO_BEN_TWO.create_OTP_rows(
27699: p_validate => p_validate
27700: ,p_copy_entity_txn_id => p_copy_entity_txn_id
27701: ,p_effective_date => p_effective_date
27702: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 27714: BEN_PD_COPY_TO_BEN_TWO.create_BPP_rows(

27710: -- Moved call from bepdccp1.pkb so that Benefit Pools are
27711: -- created after PLIP, PTIP and OIPLIP
27712: --
27713: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('BPP') then
27714: BEN_PD_COPY_TO_BEN_TWO.create_BPP_rows(
27715: p_validate => p_validate
27716: ,p_copy_entity_txn_id => p_copy_entity_txn_id
27717: ,p_effective_date => p_effective_date
27718: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 27729: BEN_PD_COPY_TO_BEN_TWO.create_LBR_rows(

27725:
27726: -- LBR records are created at PLIP and LER intersection
27727: --
27728: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('LBR') then
27729: BEN_PD_COPY_TO_BEN_TWO.create_LBR_rows(
27730: p_validate => p_validate
27731: ,p_copy_entity_txn_id => p_copy_entity_txn_id
27732: ,p_effective_date => p_effective_date
27733: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 27743: BEN_PD_COPY_TO_BEN_TWO.create_LPR1_rows(

27739: --
27740: -- LPR1 records are created at PLIP and LER intersection
27741: --
27742: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('LPR1') then
27743: BEN_PD_COPY_TO_BEN_TWO.create_LPR1_rows(
27744: p_validate => p_validate
27745: ,p_copy_entity_txn_id => p_copy_entity_txn_id
27746: ,p_effective_date => p_effective_date
27747: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 27757: BEN_PD_COPY_TO_BEN_TWO.create_VGS_rows(

27753: -- Plan Intersections
27754: -- VGS records are created at PL and GOS intersection
27755: --
27756: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('VGS') then
27757: BEN_PD_COPY_TO_BEN_TWO.create_VGS_rows(
27758: p_validate => p_validate
27759: ,p_copy_entity_txn_id => p_copy_entity_txn_id
27760: ,p_effective_date => p_effective_date
27761: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 27770: BEN_PD_COPY_TO_BEN_TWO.create_PCT_rows(

27766: end if;
27767: -- PCT records are created at VGS and certification type intersection
27768: --
27769: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('PCT') then
27770: BEN_PD_COPY_TO_BEN_TWO.create_PCT_rows(
27771: p_validate => p_validate
27772: ,p_copy_entity_txn_id => p_copy_entity_txn_id
27773: ,p_effective_date => p_effective_date
27774: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 27783: BEN_PD_COPY_TO_BEN_TWO.create_VRP_rows(

27779: end if;
27780: -- VRP records as child record of PL
27781: --
27782: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('VRP') then
27783: BEN_PD_COPY_TO_BEN_TWO.create_VRP_rows(
27784: p_validate => p_validate
27785: ,p_copy_entity_txn_id => p_copy_entity_txn_id
27786: ,p_effective_date => p_effective_date
27787: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 27797: BEN_PD_COPY_TO_BEN_TWO.create_WPN_rows(

27793: --
27794: -- WPN records are intersection of PL and wv_prtn_rsn_cd
27795: --
27796: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('WPN') then
27797: BEN_PD_COPY_TO_BEN_TWO.create_WPN_rows(
27798: p_validate => p_validate
27799: ,p_copy_entity_txn_id => p_copy_entity_txn_id
27800: ,p_effective_date => p_effective_date
27801: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 27810: BEN_PD_COPY_TO_BEN_TWO.create_WCN_rows(

27806: end if;
27807: -- WCN records are intersection of WPN and wv_prtn_ctfn_typ_cd
27808: --
27809: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('WCN') then
27810: BEN_PD_COPY_TO_BEN_TWO.create_WCN_rows(
27811: p_validate => p_validate
27812: ,p_copy_entity_txn_id => p_copy_entity_txn_id
27813: ,p_effective_date => p_effective_date
27814: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 27824: BEN_PD_COPY_TO_BEN_TWO.create_BRC_rows(

27820: --
27821: -- BRC records are intersection of PL and enrt_ctfn_typ_cd
27822: --
27823: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('BRC') then
27824: BEN_PD_COPY_TO_BEN_TWO.create_BRC_rows(
27825: p_validate => p_validate
27826: ,p_copy_entity_txn_id => p_copy_entity_txn_id
27827: ,p_effective_date => p_effective_date
27828: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 27837: BEN_PD_COPY_TO_BEN_TWO.create_LBC_rows(

27833: end if;
27834: -- LBC records are intersection of ler_bnft_rstrn_id and enrt_ctfn_typ_cd
27835: --
27836: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('LBC') then
27837: BEN_PD_COPY_TO_BEN_TWO.create_LBC_rows(
27838: p_validate => p_validate
27839: ,p_copy_entity_txn_id => p_copy_entity_txn_id
27840: ,p_effective_date => p_effective_date
27841: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 27850: BEN_PD_COPY_TO_BEN_TWO.create_LRE_rows(

27846: end if;
27847: -- LRE records are intersection of PL,OIPL with LER
27848: --
27849: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('LRE') then
27850: BEN_PD_COPY_TO_BEN_TWO.create_LRE_rows(
27851: p_validate => p_validate
27852: ,p_copy_entity_txn_id => p_copy_entity_txn_id
27853: ,p_effective_date => p_effective_date
27854: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 27863: BEN_PD_COPY_TO_BEN_TWO.create_LNC_rows(

27859: end if;
27860: -- LNC records are intersection of LRE and enrt_ctfn_typ_cd
27861: --
27862: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('LNC') then
27863: BEN_PD_COPY_TO_BEN_TWO.create_LNC_rows(
27864: p_validate => p_validate
27865: ,p_copy_entity_txn_id => p_copy_entity_txn_id
27866: ,p_effective_date => p_effective_date
27867: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 27876: BEN_PD_COPY_TO_BEN_TWO.create_LPE_rows(

27872: end if;
27873: -- LPE records are intersection of PLN and LER
27874: --
27875: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('LPE') then
27876: BEN_PD_COPY_TO_BEN_TWO.create_LPE_rows(
27877: p_validate => p_validate
27878: ,p_copy_entity_txn_id => p_copy_entity_txn_id
27879: ,p_effective_date => p_effective_date
27880: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 27889: BEN_PD_COPY_TO_BEN_TWO.create_PND_rows(

27885: end if;
27886: -- PND records are intersection of PLN and dpnt_cvg_ctfn_typ_cd
27887: --
27888: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('PND') then
27889: BEN_PD_COPY_TO_BEN_TWO.create_PND_rows(
27890: p_validate => p_validate
27891: ,p_copy_entity_txn_id => p_copy_entity_txn_id
27892: ,p_effective_date => p_effective_date
27893: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 27908: BEN_PD_COPY_TO_BEN_TWO.create_PEO_rows(

27904: -- PEO records are created at PGM,PTIP,PLIP,PL and OIPLIP level
27905: -- This call creates the intersections between all these levels and ler.
27906: --
27907: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('PEO') then
27908: BEN_PD_COPY_TO_BEN_TWO.create_PEO_rows(
27909: p_validate => p_validate
27910: ,p_copy_entity_txn_id => p_copy_entity_txn_id
27911: ,p_effective_date => p_effective_date
27912: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 27922: BEN_PD_COPY_TO_BEN_TWO.create_EPA_rows(

27918: --
27919: -- EPA records are created at PGM,PTIP,PLIP,PL and OIPLIP level
27920: --
27921: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('EPA') then
27922: BEN_PD_COPY_TO_BEN_TWO.create_EPA_rows(
27923: p_validate => p_validate
27924: ,p_copy_entity_txn_id => p_copy_entity_txn_id
27925: ,p_effective_date => p_effective_date
27926: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 27936: BEN_PD_COPY_TO_BEN_TWO.create_CEP_rows(

27932: --
27933: -- CEP records are created at the intersection of EPA and ELP
27934: --
27935: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('CEP') then
27936: BEN_PD_COPY_TO_BEN_TWO.create_CEP_rows(
27937: p_validate => p_validate
27938: ,p_copy_entity_txn_id => p_copy_entity_txn_id
27939: ,p_effective_date => p_effective_date
27940: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 27949: BEN_PD_COPY_TO_BEN_TWO.create_CER_rows(

27945: end if;
27946: -- CER records are created at the intersection of EPA and FORMULA
27947: --
27948: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('CER') then
27949: BEN_PD_COPY_TO_BEN_TWO.create_CER_rows(
27950: p_validate => p_validate
27951: ,p_copy_entity_txn_id => p_copy_entity_txn_id
27952: ,p_effective_date => p_effective_date
27953: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 27962: BEN_PD_COPY_TO_BEN_TWO.create_PCX_rows(

27958: end if;
27959: --
27960: --
27961: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('PCX') then
27962: BEN_PD_COPY_TO_BEN_TWO.create_PCX_rows(
27963: p_validate => p_validate
27964: ,p_copy_entity_txn_id => p_copy_entity_txn_id
27965: ,p_effective_date => p_effective_date
27966: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 27976: BEN_PD_COPY_TO_BEN_TWO.create_PCP_rows(

27972: --
27973: -- PCP records are intersection of PLN and ben_pl_pcp
27974: --
27975: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('PCP') then
27976: BEN_PD_COPY_TO_BEN_TWO.create_PCP_rows(
27977: p_validate => p_validate
27978: ,p_copy_entity_txn_id => p_copy_entity_txn_id
27979: ,p_effective_date => p_effective_date
27980: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 27990: BEN_PD_COPY_TO_BEN_TWO.create_PTY_rows(

27986: --
27987: -- PTY records are child records of PCP
27988: --
27989: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('PTY') then
27990: BEN_PD_COPY_TO_BEN_TWO.create_PTY_rows(
27991: p_validate => p_validate
27992: ,p_copy_entity_txn_id => p_copy_entity_txn_id
27993: ,p_effective_date => p_effective_date
27994: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 28004: BEN_PD_COPY_TO_BEN_TWO.create_PRB_rows(

28000: --
28001: -- PRB records are child records of PLN OR BNR
28002: --
28003: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('PRB') then
28004: BEN_PD_COPY_TO_BEN_TWO.create_PRB_rows(
28005: p_validate => p_validate
28006: ,p_copy_entity_txn_id => p_copy_entity_txn_id
28007: ,p_effective_date => p_effective_date
28008: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 28017: BEN_PD_COPY_TO_BEN_TWO.create_PRP_rows(

28013: end if;
28014: --
28015: --
28016: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('PRP') then
28017: BEN_PD_COPY_TO_BEN_TWO.create_PRP_rows(
28018: p_validate => p_validate
28019: ,p_copy_entity_txn_id => p_copy_entity_txn_id
28020: ,p_effective_date => p_effective_date
28021: ,p_prefix_suffix_text => p_prefix_suffix_text

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

28041: --
28042: -- First try creating all the leaf rows.
28043: --
28044: --TCS PDW Integration ENH
28045: if(BEN_PD_COPY_TO_BEN_TWO.g_copy_entity_txn_id <> p_copy_entity_txn_id) then
28046:
28047: BEN_PD_COPY_TO_BEN_TWO.g_copy_entity_txn_id := p_copy_entity_txn_id;
28048:
28049: open BEN_PD_COPY_TO_BEN_TWO.g_copy_entity_txn(p_copy_entity_txn_id) ;

Line 28047: BEN_PD_COPY_TO_BEN_TWO.g_copy_entity_txn_id := p_copy_entity_txn_id;

28043: --
28044: --TCS PDW Integration ENH
28045: if(BEN_PD_COPY_TO_BEN_TWO.g_copy_entity_txn_id <> p_copy_entity_txn_id) then
28046:
28047: BEN_PD_COPY_TO_BEN_TWO.g_copy_entity_txn_id := p_copy_entity_txn_id;
28048:
28049: open BEN_PD_COPY_TO_BEN_TWO.g_copy_entity_txn(p_copy_entity_txn_id) ;
28050: fetch BEN_PD_COPY_TO_BEN_TWO.g_copy_entity_txn into BEN_PD_COPY_TO_BEN_TWO.g_row_type_cd;
28051: close BEN_PD_COPY_TO_BEN_TWO.g_copy_entity_txn;

Line 28049: open BEN_PD_COPY_TO_BEN_TWO.g_copy_entity_txn(p_copy_entity_txn_id) ;

28045: if(BEN_PD_COPY_TO_BEN_TWO.g_copy_entity_txn_id <> p_copy_entity_txn_id) then
28046:
28047: BEN_PD_COPY_TO_BEN_TWO.g_copy_entity_txn_id := p_copy_entity_txn_id;
28048:
28049: open BEN_PD_COPY_TO_BEN_TWO.g_copy_entity_txn(p_copy_entity_txn_id) ;
28050: fetch BEN_PD_COPY_TO_BEN_TWO.g_copy_entity_txn into BEN_PD_COPY_TO_BEN_TWO.g_row_type_cd;
28051: close BEN_PD_COPY_TO_BEN_TWO.g_copy_entity_txn;
28052:
28053: end if;

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

28046:
28047: BEN_PD_COPY_TO_BEN_TWO.g_copy_entity_txn_id := p_copy_entity_txn_id;
28048:
28049: open BEN_PD_COPY_TO_BEN_TWO.g_copy_entity_txn(p_copy_entity_txn_id) ;
28050: fetch BEN_PD_COPY_TO_BEN_TWO.g_copy_entity_txn into BEN_PD_COPY_TO_BEN_TWO.g_row_type_cd;
28051: close BEN_PD_COPY_TO_BEN_TWO.g_copy_entity_txn;
28052:
28053: end if;
28054:

Line 28051: close BEN_PD_COPY_TO_BEN_TWO.g_copy_entity_txn;

28047: BEN_PD_COPY_TO_BEN_TWO.g_copy_entity_txn_id := p_copy_entity_txn_id;
28048:
28049: open BEN_PD_COPY_TO_BEN_TWO.g_copy_entity_txn(p_copy_entity_txn_id) ;
28050: fetch BEN_PD_COPY_TO_BEN_TWO.g_copy_entity_txn into BEN_PD_COPY_TO_BEN_TWO.g_row_type_cd;
28051: close BEN_PD_COPY_TO_BEN_TWO.g_copy_entity_txn;
28052:
28053: end if;
28054:
28055: -- TCS PDW Integration passed the parameter BEN_PD_COPY_TO_BEN_TWO.g_row_type_cd to create_all_leaf_ben_rows

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

28051: close BEN_PD_COPY_TO_BEN_TWO.g_copy_entity_txn;
28052:
28053: end if;
28054:
28055: -- TCS PDW Integration passed the parameter BEN_PD_COPY_TO_BEN_TWO.g_row_type_cd to create_all_leaf_ben_rows
28056: BEN_PD_COPY_TO_BEN_ONE.create_all_leaf_ben_rows(
28057: p_validate => p_validate
28058: ,p_copy_entity_txn_id => p_copy_entity_txn_id
28059: ,p_effective_date => p_effective_date

Line 28064: ,p_txn_row_type_cd => BEN_PD_COPY_TO_BEN_TWO.g_row_type_cd

28060: ,p_prefix_suffix_text => p_prefix_suffix_text
28061: ,p_reuse_object_flag => p_reuse_object_flag
28062: ,p_target_business_group_id => p_target_business_group_id
28063: ,p_prefix_suffix_cd => p_prefix_suffix_cd
28064: ,p_txn_row_type_cd => BEN_PD_COPY_TO_BEN_TWO.g_row_type_cd
28065: );
28066:
28067: if (BEN_PD_COPY_TO_BEN_TWO.g_row_type_cd <> 'ELP') then
28068: --TCS PDW Integration ENH

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

28063: ,p_prefix_suffix_cd => p_prefix_suffix_cd
28064: ,p_txn_row_type_cd => BEN_PD_COPY_TO_BEN_TWO.g_row_type_cd
28065: );
28066:
28067: if (BEN_PD_COPY_TO_BEN_TWO.g_row_type_cd <> 'ELP') then
28068: --TCS PDW Integration ENH
28069: --
28070: -- ben_popl_enrt_typ_cycl_f rows are created as pgm and pl, yrp, wyp rows
28071: -- are created as part of leaf call and above call.

Line 28073: BEN_PD_COPY_TO_BEN_TWO.create_final_intersect_rows(

28069: --
28070: -- ben_popl_enrt_typ_cycl_f rows are created as pgm and pl, yrp, wyp rows
28071: -- are created as part of leaf call and above call.
28072: --
28073: BEN_PD_COPY_TO_BEN_TWO.create_final_intersect_rows(
28074: p_validate => p_validate
28075: ,p_copy_entity_txn_id => p_copy_entity_txn_id
28076: ,p_effective_date => p_effective_date
28077: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 28087: BEN_PD_COPY_TO_BEN_TWO.create_LGE_rows(

28083: -- LGE records are created at Only PGM level
28084: -- This call creates the intersections between the program levels and ler.
28085: --
28086: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('LGE') then
28087: BEN_PD_COPY_TO_BEN_TWO.create_LGE_rows(
28088: p_validate => p_validate
28089: ,p_copy_entity_txn_id => p_copy_entity_txn_id
28090: ,p_effective_date => p_effective_date
28091: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 28102: BEN_PD_COPY_TO_BEN_TWO.create_PGC_rows(

28098: -- PGC records are created at Only PGM level
28099: -- This call creates the intersections between the program levels and dpnt_cvg_ctfn_typ_cd.
28100: --
28101: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('PGC') then
28102: BEN_PD_COPY_TO_BEN_TWO.create_PGC_rows(
28103: p_validate => p_validate
28104: ,p_copy_entity_txn_id => p_copy_entity_txn_id
28105: ,p_effective_date => p_effective_date
28106: ,p_prefix_suffix_text => p_prefix_suffix_text

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

28132: -- Now make call to rate and all other ows creation
28133: --
28134: --TCS PDW Integration ENH
28135:
28136: if (BEN_PD_COPY_TO_BEN_TWO.g_row_type_cd <> 'ELP') then
28137: --TCS PDW Integration ENH
28138:
28139: BEN_PD_COPY_TO_BEN_five.create_rate_rows
28140: (

Line 28224: BEN_PD_COPY_TO_BEN_TWO.create_pgm_intersect_rows(

28220:
28221: -- Initialize global variable for Transaction Category
28222: BEN_PD_COPY_TO_BEN_ONE.g_transaction_category := l_transaction_category.short_name;
28223:
28224: BEN_PD_COPY_TO_BEN_TWO.create_pgm_intersect_rows(
28225: p_validate => p_validate
28226: ,p_copy_entity_txn_id => p_copy_entity_txn_id
28227: ,p_effective_date => p_effective_date
28228: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 28240: end BEN_PD_COPY_TO_BEN_TWO;

28236: --
28237: --
28238: end create_stg_to_ben_rows ;
28239: --
28240: end BEN_PD_COPY_TO_BEN_TWO;