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_THREE dependencies on BEN_PD_COPY_TO_BEN_THREE

Line 1: Package BODY BEN_PD_COPY_TO_BEN_three as

1: Package BODY BEN_PD_COPY_TO_BEN_three as
2: /* $Header: bepdccp3.pkb 120.1 2006/04/10 05:38:59 gsehgal noship $ */
3: --
4: --UPD Changes New procedure for getting the dtmodes
5: --

Line 26571: BEN_PD_COPY_TO_BEN_THREE.create_CTY_rows(

26567: --
26568: -- Create all oipl rows.
26569: --
26570: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('CTY') then
26571: BEN_PD_COPY_TO_BEN_THREE.create_CTY_rows(
26572: p_validate => p_validate
26573: ,p_copy_entity_txn_id => p_copy_entity_txn_id
26574: ,p_effective_date => p_effective_date
26575: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 26584: BEN_PD_COPY_TO_BEN_THREE.create_JRT_rows(

26580: end if;
26581: --
26582: --
26583: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('JRT') then
26584: BEN_PD_COPY_TO_BEN_THREE.create_JRT_rows(
26585: p_validate => p_validate
26586: ,p_copy_entity_txn_id => p_copy_entity_txn_id
26587: ,p_effective_date => p_effective_date
26588: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 26594: --dbms_output.put_line( 'BEN_PD_COPY_TO_BEN_THREE.create_JRT_rows ');

26590: ,p_target_business_group_id => p_target_business_group_id
26591: ,p_prefix_suffix_cd => p_prefix_suffix_cd );
26592: end if;
26593: --
26594: --dbms_output.put_line( 'BEN_PD_COPY_TO_BEN_THREE.create_JRT_rows ');
26595: --
26596: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('HSR') then
26597: BEN_PD_COPY_TO_BEN_THREE.create_HSR_rows(
26598: p_validate => p_validate

Line 26597: BEN_PD_COPY_TO_BEN_THREE.create_HSR_rows(

26593: --
26594: --dbms_output.put_line( 'BEN_PD_COPY_TO_BEN_THREE.create_JRT_rows ');
26595: --
26596: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('HSR') then
26597: BEN_PD_COPY_TO_BEN_THREE.create_HSR_rows(
26598: p_validate => p_validate
26599: ,p_copy_entity_txn_id => p_copy_entity_txn_id
26600: ,p_effective_date => p_effective_date
26601: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 26607: --dbms_output.put_line( 'BEN_PD_COPY_TO_BEN_THREE.create_HSR_rows ');

26603: ,p_target_business_group_id => p_target_business_group_id
26604: ,p_prefix_suffix_cd => p_prefix_suffix_cd );
26605: --
26606: end if;
26607: --dbms_output.put_line( 'BEN_PD_COPY_TO_BEN_THREE.create_HSR_rows ');
26608: --
26609: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('GRR') then
26610: BEN_PD_COPY_TO_BEN_THREE.create_GRR_rows(
26611: p_validate => p_validate

Line 26610: BEN_PD_COPY_TO_BEN_THREE.create_GRR_rows(

26606: end if;
26607: --dbms_output.put_line( 'BEN_PD_COPY_TO_BEN_THREE.create_HSR_rows ');
26608: --
26609: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('GRR') then
26610: BEN_PD_COPY_TO_BEN_THREE.create_GRR_rows(
26611: p_validate => p_validate
26612: ,p_copy_entity_txn_id => p_copy_entity_txn_id
26613: ,p_effective_date => p_effective_date
26614: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 26620: --dbms_output.put_line( 'BEN_PD_COPY_TO_BEN_THREE.create_GRR_rows');

26616: ,p_target_business_group_id => p_target_business_group_id
26617: ,p_prefix_suffix_cd => p_prefix_suffix_cd );
26618: end if;
26619: --
26620: --dbms_output.put_line( 'BEN_PD_COPY_TO_BEN_THREE.create_GRR_rows');
26621: --
26622: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('FTR') then
26623: BEN_PD_COPY_TO_BEN_THREE.create_FTR_rows(
26624: p_validate => p_validate

Line 26623: BEN_PD_COPY_TO_BEN_THREE.create_FTR_rows(

26619: --
26620: --dbms_output.put_line( 'BEN_PD_COPY_TO_BEN_THREE.create_GRR_rows');
26621: --
26622: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('FTR') then
26623: BEN_PD_COPY_TO_BEN_THREE.create_FTR_rows(
26624: p_validate => p_validate
26625: ,p_copy_entity_txn_id => p_copy_entity_txn_id
26626: ,p_effective_date => p_effective_date
26627: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 26633: --dbms_output.put_line( 'BEN_PD_COPY_TO_BEN_THREE.create_FTR_rows');

26629: ,p_target_business_group_id => p_target_business_group_id
26630: ,p_prefix_suffix_cd => p_prefix_suffix_cd );
26631: end if;
26632: --
26633: --dbms_output.put_line( 'BEN_PD_COPY_TO_BEN_THREE.create_FTR_rows');
26634: --
26635: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('BUR') then
26636: BEN_PD_COPY_TO_BEN_THREE.create_BUR_rows(
26637: p_validate => p_validate

Line 26636: BEN_PD_COPY_TO_BEN_THREE.create_BUR_rows(

26632: --
26633: --dbms_output.put_line( 'BEN_PD_COPY_TO_BEN_THREE.create_FTR_rows');
26634: --
26635: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('BUR') then
26636: BEN_PD_COPY_TO_BEN_THREE.create_BUR_rows(
26637: p_validate => p_validate
26638: ,p_copy_entity_txn_id => p_copy_entity_txn_id
26639: ,p_effective_date => p_effective_date
26640: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 26646: --dbms_output.put_line( 'BEN_PD_COPY_TO_BEN_THREE.create_BUR_rows');

26642: ,p_target_business_group_id => p_target_business_group_id
26643: ,p_prefix_suffix_cd => p_prefix_suffix_cd );
26644: end if;
26645: --
26646: --dbms_output.put_line( 'BEN_PD_COPY_TO_BEN_THREE.create_BUR_rows');
26647: --
26648: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('ESR') then
26649: BEN_PD_COPY_TO_BEN_THREE.create_ESR_rows(
26650: p_validate => p_validate

Line 26649: BEN_PD_COPY_TO_BEN_THREE.create_ESR_rows(

26645: --
26646: --dbms_output.put_line( 'BEN_PD_COPY_TO_BEN_THREE.create_BUR_rows');
26647: --
26648: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('ESR') then
26649: BEN_PD_COPY_TO_BEN_THREE.create_ESR_rows(
26650: p_validate => p_validate
26651: ,p_copy_entity_txn_id => p_copy_entity_txn_id
26652: ,p_effective_date => p_effective_date
26653: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 26661: BEN_PD_COPY_TO_BEN_THREE.create_ASR_rows(

26657: end if;
26658: --
26659: --
26660: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('ASR') then
26661: BEN_PD_COPY_TO_BEN_THREE.create_ASR_rows(
26662: p_validate => p_validate
26663: ,p_copy_entity_txn_id => p_copy_entity_txn_id
26664: ,p_effective_date => p_effective_date
26665: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 26671: --dbms_output.put_line( 'BEN_PD_COPY_TO_BEN_THREE.create_ASR_rows ');

26667: ,p_target_business_group_id => p_target_business_group_id
26668: ,p_prefix_suffix_cd => p_prefix_suffix_cd );
26669: end if;
26670: --
26671: --dbms_output.put_line( 'BEN_PD_COPY_TO_BEN_THREE.create_ASR_rows ');
26672: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('TUR') then
26673: BEN_PD_COPY_TO_BEN_THREE.create_TUR_rows(
26674: p_validate => p_validate
26675: ,p_copy_entity_txn_id => p_copy_entity_txn_id

Line 26673: BEN_PD_COPY_TO_BEN_THREE.create_TUR_rows(

26669: end if;
26670: --
26671: --dbms_output.put_line( 'BEN_PD_COPY_TO_BEN_THREE.create_ASR_rows ');
26672: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('TUR') then
26673: BEN_PD_COPY_TO_BEN_THREE.create_TUR_rows(
26674: p_validate => p_validate
26675: ,p_copy_entity_txn_id => p_copy_entity_txn_id
26676: ,p_effective_date => p_effective_date
26677: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 26685: BEN_PD_COPY_TO_BEN_THREE.create_SAR_rows(

26681: end if;
26682: --
26683: --
26684: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('SAR') then
26685: BEN_PD_COPY_TO_BEN_THREE.create_SAR_rows(
26686: p_validate => p_validate
26687: ,p_copy_entity_txn_id => p_copy_entity_txn_id
26688: ,p_effective_date => p_effective_date
26689: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 26697: BEN_PD_COPY_TO_BEN_THREE.create_QTR_rows(

26693: end if;
26694: --
26695: --
26696: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('QTR') then
26697: BEN_PD_COPY_TO_BEN_THREE.create_QTR_rows(
26698: p_validate => p_validate
26699: ,p_copy_entity_txn_id => p_copy_entity_txn_id
26700: ,p_effective_date => p_effective_date
26701: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 26709: BEN_PD_COPY_TO_BEN_THREE.create_PZR_rows(

26705: end if;
26706: --
26707: --
26708: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('PZR') then
26709: BEN_PD_COPY_TO_BEN_THREE.create_PZR_rows(
26710: p_validate => p_validate
26711: ,p_copy_entity_txn_id => p_copy_entity_txn_id
26712: ,p_effective_date => p_effective_date
26713: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 26721: BEN_PD_COPY_TO_BEN_THREE.create_PTR_rows(

26717: end if;
26718: --
26719: --
26720: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('PTR') then
26721: BEN_PD_COPY_TO_BEN_THREE.create_PTR_rows(
26722: p_validate => p_validate
26723: ,p_copy_entity_txn_id => p_copy_entity_txn_id
26724: ,p_effective_date => p_effective_date
26725: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 26733: BEN_PD_COPY_TO_BEN_THREE.create_GNR_rows(

26729: end if;
26730: --
26731: --
26732: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('GNR') then
26733: BEN_PD_COPY_TO_BEN_THREE.create_GNR_rows(
26734: p_validate => p_validate
26735: ,p_copy_entity_txn_id => p_copy_entity_txn_id
26736: ,p_effective_date => p_effective_date
26737: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 26743: --dbms_output.put_line( 'BEN_PD_COPY_TO_BEN_THREE.create_GNR_rows ');

26739: ,p_target_business_group_id => p_target_business_group_id
26740: ,p_prefix_suffix_cd => p_prefix_suffix_cd );
26741: end if;
26742: --
26743: --dbms_output.put_line( 'BEN_PD_COPY_TO_BEN_THREE.create_GNR_rows ');
26744: --
26745: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('DBR') then
26746: BEN_PD_COPY_TO_BEN_THREE.create_DBR_rows(
26747: p_validate => p_validate

Line 26746: BEN_PD_COPY_TO_BEN_THREE.create_DBR_rows(

26742: --
26743: --dbms_output.put_line( 'BEN_PD_COPY_TO_BEN_THREE.create_GNR_rows ');
26744: --
26745: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('DBR') then
26746: BEN_PD_COPY_TO_BEN_THREE.create_DBR_rows(
26747: p_validate => p_validate
26748: ,p_copy_entity_txn_id => p_copy_entity_txn_id
26749: ,p_effective_date => p_effective_date
26750: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 26760: BEN_PD_COPY_TO_BEN_THREE.create_LMM_rows(

26756:
26757:
26758: --
26759: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('LMM') then
26760: BEN_PD_COPY_TO_BEN_THREE.create_LMM_rows(
26761: p_validate => p_validate
26762: ,p_copy_entity_txn_id => p_copy_entity_txn_id
26763: ,p_effective_date => p_effective_date
26764: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 26772: BEN_PD_COPY_TO_BEN_THREE.create_LAR_rows(

26768: end if;
26769: --
26770: --
26771: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('LAR') then
26772: BEN_PD_COPY_TO_BEN_THREE.create_LAR_rows(
26773: p_validate => p_validate
26774: ,p_copy_entity_txn_id => p_copy_entity_txn_id
26775: ,p_effective_date => p_effective_date
26776: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 26784: BEN_PD_COPY_TO_BEN_THREE.create_OUR_rows(

26780: end if;
26781: --
26782: --
26783: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('OUR') then
26784: BEN_PD_COPY_TO_BEN_THREE.create_OUR_rows(
26785: p_validate => p_validate
26786: ,p_copy_entity_txn_id => p_copy_entity_txn_id
26787: ,p_effective_date => p_effective_date
26788: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 26795: BEN_PD_COPY_TO_BEN_THREE.create_LER1_rows(

26791: ,p_prefix_suffix_cd => p_prefix_suffix_cd );
26792: end if;
26793: --
26794: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('LER1') then
26795: BEN_PD_COPY_TO_BEN_THREE.create_LER1_rows(
26796: p_validate => p_validate
26797: ,p_copy_entity_txn_id => p_copy_entity_txn_id
26798: ,p_effective_date => p_effective_date
26799: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 26805: --dbms_output.put_line( 'BEN_PD_COPY_TO_BEN_THREE.create_LER1_rows ');

26801: ,p_target_business_group_id => p_target_business_group_id
26802: ,p_prefix_suffix_cd => p_prefix_suffix_cd );
26803: end if;
26804: --
26805: --dbms_output.put_line( 'BEN_PD_COPY_TO_BEN_THREE.create_LER1_rows ');
26806: --
26807: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('PR_') then
26808: BEN_PD_COPY_TO_BEN_THREE.create_PR__rows(
26809: p_validate => p_validate

Line 26808: BEN_PD_COPY_TO_BEN_THREE.create_PR__rows(

26804: --
26805: --dbms_output.put_line( 'BEN_PD_COPY_TO_BEN_THREE.create_LER1_rows ');
26806: --
26807: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('PR_') then
26808: BEN_PD_COPY_TO_BEN_THREE.create_PR__rows(
26809: p_validate => p_validate
26810: ,p_copy_entity_txn_id => p_copy_entity_txn_id
26811: ,p_effective_date => p_effective_date
26812: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 26818: --dbms_output.put_line( 'BEN_PD_COPY_TO_BEN_THREE.create_PR__rows');

26814: ,p_target_business_group_id => p_target_business_group_id
26815: ,p_prefix_suffix_cd => p_prefix_suffix_cd );
26816: end if;
26817: --
26818: --dbms_output.put_line( 'BEN_PD_COPY_TO_BEN_THREE.create_PR__rows');
26819: --
26820: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('PBR') then
26821: BEN_PD_COPY_TO_BEN_THREE.create_PBR_rows(
26822: p_validate => p_validate

Line 26821: BEN_PD_COPY_TO_BEN_THREE.create_PBR_rows(

26817: --
26818: --dbms_output.put_line( 'BEN_PD_COPY_TO_BEN_THREE.create_PR__rows');
26819: --
26820: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('PBR') then
26821: BEN_PD_COPY_TO_BEN_THREE.create_PBR_rows(
26822: p_validate => p_validate
26823: ,p_copy_entity_txn_id => p_copy_entity_txn_id
26824: ,p_effective_date => p_effective_date
26825: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 26832: BEN_PD_COPY_TO_BEN_THREE.create_BRG_rows(

26828: ,p_prefix_suffix_cd => p_prefix_suffix_cd );
26829: end if;
26830: --
26831: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('BRG') then
26832: BEN_PD_COPY_TO_BEN_THREE.create_BRG_rows(
26833: p_validate => p_validate
26834: ,p_copy_entity_txn_id => p_copy_entity_txn_id
26835: ,p_effective_date => p_effective_date
26836: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 26844: BEN_PD_COPY_TO_BEN_THREE.create_CMR_rows(

26840: end if;
26841: --
26842: --
26843: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('CMR') then
26844: BEN_PD_COPY_TO_BEN_THREE.create_CMR_rows(
26845: p_validate => p_validate
26846: ,p_copy_entity_txn_id => p_copy_entity_txn_id
26847: ,p_effective_date => p_effective_date
26848: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 26856: BEN_PD_COPY_TO_BEN_THREE.create_VMR_rows(

26852: end if;
26853: --
26854: --
26855: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('VMR') then
26856: BEN_PD_COPY_TO_BEN_THREE.create_VMR_rows(
26857: p_validate => p_validate
26858: ,p_copy_entity_txn_id => p_copy_entity_txn_id
26859: ,p_effective_date => p_effective_date
26860: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 26868: BEN_PD_COPY_TO_BEN_THREE.create_NOC_rows(

26864: end if;
26865: --
26866: --
26867: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('NOC') then
26868: BEN_PD_COPY_TO_BEN_THREE.create_NOC_rows(
26869: p_validate => p_validate
26870: ,p_copy_entity_txn_id => p_copy_entity_txn_id
26871: ,p_effective_date => p_effective_date
26872: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 26880: BEN_PD_COPY_TO_BEN_THREE.create_OMR_rows(

26876: end if;
26877: --
26878: --
26879: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('OMR') then
26880: BEN_PD_COPY_TO_BEN_THREE.create_OMR_rows(
26881: p_validate => p_validate
26882: ,p_copy_entity_txn_id => p_copy_entity_txn_id
26883: ,p_effective_date => p_effective_date
26884: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 26892: BEN_PD_COPY_TO_BEN_THREE.create_TTP_rows(

26888: end if;
26889: --
26890: --
26891: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('TTP') then
26892: BEN_PD_COPY_TO_BEN_THREE.create_TTP_rows(
26893: p_validate => p_validate
26894: ,p_copy_entity_txn_id => p_copy_entity_txn_id
26895: ,p_effective_date => p_effective_date
26896: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 26904: BEN_PD_COPY_TO_BEN_THREE.create_TCV_rows(

26900: end if;
26901: --
26902: --
26903: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('TCV') then
26904: BEN_PD_COPY_TO_BEN_THREE.create_TCV_rows(
26905: p_validate => p_validate
26906: ,p_copy_entity_txn_id => p_copy_entity_txn_id
26907: ,p_effective_date => p_effective_date
26908: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 26916: BEN_PD_COPY_TO_BEN_THREE.create_VPR_rows(

26912: end if;
26913: --
26914: --
26915: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('VPR') then
26916: BEN_PD_COPY_TO_BEN_THREE.create_VPR_rows(
26917: p_validate => p_validate
26918: ,p_copy_entity_txn_id => p_copy_entity_txn_id
26919: ,p_effective_date => p_effective_date
26920: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 26928: BEN_PD_COPY_TO_BEN_THREE.create_PRT_rows(

26924: end if;
26925: --
26926: --
26927: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('PRT') then
26928: BEN_PD_COPY_TO_BEN_THREE.create_PRT_rows(
26929: p_validate => p_validate
26930: ,p_copy_entity_txn_id => p_copy_entity_txn_id
26931: ,p_effective_date => p_effective_date
26932: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 26940: BEN_PD_COPY_TO_BEN_THREE.create_CPN_rows(

26936: end if;
26937: --
26938: --
26939: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('CPN') then
26940: BEN_PD_COPY_TO_BEN_THREE.create_CPN_rows(
26941: p_validate => p_validate
26942: ,p_copy_entity_txn_id => p_copy_entity_txn_id
26943: ,p_effective_date => p_effective_date
26944: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 26952: BEN_PD_COPY_TO_BEN_THREE.create_PST_rows(

26948: end if;
26949: --
26950: --
26951: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('PST') then
26952: BEN_PD_COPY_TO_BEN_THREE.create_PST_rows(
26953: p_validate => p_validate
26954: ,p_copy_entity_txn_id => p_copy_entity_txn_id
26955: ,p_effective_date => p_effective_date
26956: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 26964: BEN_PD_COPY_TO_BEN_THREE.create_WLR_rows(

26960: end if;
26961: --
26962: --
26963: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('WLR') then
26964: BEN_PD_COPY_TO_BEN_THREE.create_WLR_rows(
26965: p_validate => p_validate
26966: ,p_copy_entity_txn_id => p_copy_entity_txn_id
26967: ,p_effective_date => p_effective_date
26968: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 26976: BEN_PD_COPY_TO_BEN_THREE.create_PFR_rows(

26972: end if;
26973: --
26974: --
26975: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('PFR') then
26976: BEN_PD_COPY_TO_BEN_THREE.create_PFR_rows(
26977: p_validate => p_validate
26978: ,p_copy_entity_txn_id => p_copy_entity_txn_id
26979: ,p_effective_date => p_effective_date
26980: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 26988: BEN_PD_COPY_TO_BEN_THREE.create_HWR_rows(

26984: end if;
26985: --
26986: --
26987: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('HWR') then
26988: BEN_PD_COPY_TO_BEN_THREE.create_HWR_rows(
26989: p_validate => p_validate
26990: ,p_copy_entity_txn_id => p_copy_entity_txn_id
26991: ,p_effective_date => p_effective_date
26992: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 27000: BEN_PD_COPY_TO_BEN_THREE.create_CLR_rows(

26996: end if;
26997: --
26998: --
26999: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('CLR') then
27000: BEN_PD_COPY_TO_BEN_THREE.create_CLR_rows(
27001: p_validate => p_validate
27002: ,p_copy_entity_txn_id => p_copy_entity_txn_id
27003: ,p_effective_date => p_effective_date
27004: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 27012: BEN_PD_COPY_TO_BEN_THREE.create_LSR_rows(

27008: end if;
27009: --
27010: --
27011: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('LSR') then
27012: BEN_PD_COPY_TO_BEN_THREE.create_LSR_rows(
27013: p_validate => p_validate
27014: ,p_copy_entity_txn_id => p_copy_entity_txn_id
27015: ,p_effective_date => p_effective_date
27016: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 27024: BEN_PD_COPY_TO_BEN_THREE.create_LRN_rows(

27020: end if;
27021: --
27022: --
27023: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('LRN') then
27024: BEN_PD_COPY_TO_BEN_THREE.create_LRN_rows(
27025: p_validate => p_validate
27026: ,p_copy_entity_txn_id => p_copy_entity_txn_id
27027: ,p_effective_date => p_effective_date
27028: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 27036: BEN_PD_COPY_TO_BEN_THREE.create_ART_rows(

27032: end if;
27033: --
27034: --
27035: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('ART') then
27036: BEN_PD_COPY_TO_BEN_THREE.create_ART_rows(
27037: p_validate => p_validate
27038: ,p_copy_entity_txn_id => p_copy_entity_txn_id
27039: ,p_effective_date => p_effective_date
27040: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 27048: BEN_PD_COPY_TO_BEN_THREE.create_SHR_rows(

27044: end if;
27045: --
27046: --
27047: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('SHR') then
27048: BEN_PD_COPY_TO_BEN_THREE.create_SHR_rows(
27049: p_validate => p_validate
27050: ,p_copy_entity_txn_id => p_copy_entity_txn_id
27051: ,p_effective_date => p_effective_date
27052: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 27060: BEN_PD_COPY_TO_BEN_THREE.create_QIG_rows(

27056: end if;
27057: --
27058: --
27059: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('QIG') then
27060: BEN_PD_COPY_TO_BEN_THREE.create_QIG_rows(
27061: p_validate => p_validate
27062: ,p_copy_entity_txn_id => p_copy_entity_txn_id
27063: ,p_effective_date => p_effective_date
27064: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 27072: BEN_PD_COPY_TO_BEN_THREE.create_PRR_rows(

27068: end if;
27069: --
27070: --
27071: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('PRR') then
27072: BEN_PD_COPY_TO_BEN_THREE.create_PRR_rows(
27073: p_validate => p_validate
27074: ,p_copy_entity_txn_id => p_copy_entity_txn_id
27075: ,p_effective_date => p_effective_date
27076: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 27089: BEN_PD_COPY_TO_BEN_THREE.create_CQR_rows(

27085: --
27086: if BEN_PD_COPY_TO_BEN_ONE.g_transaction_category = 'BEN_PDCRWZ' then
27087: --
27088: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('CQR') then
27089: BEN_PD_COPY_TO_BEN_THREE.create_CQR_rows(
27090: p_validate => p_validate
27091: ,p_copy_entity_txn_id => p_copy_entity_txn_id
27092: ,p_effective_date => p_effective_date
27093: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 27101: BEN_PD_COPY_TO_BEN_THREE.create_PAP_rows(

27097: end if;
27098: --
27099: --
27100: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('PAP') then
27101: BEN_PD_COPY_TO_BEN_THREE.create_PAP_rows(
27102: p_validate => p_validate
27103: ,p_copy_entity_txn_id => p_copy_entity_txn_id
27104: ,p_effective_date => p_effective_date
27105: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 27113: BEN_PD_COPY_TO_BEN_THREE.create_OPR_rows(

27109: end if;
27110: --
27111: --
27112: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('OPR') then
27113: BEN_PD_COPY_TO_BEN_THREE.create_OPR_rows(
27114: p_validate => p_validate
27115: ,p_copy_entity_txn_id => p_copy_entity_txn_id
27116: ,p_effective_date => p_effective_date
27117: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 27125: BEN_PD_COPY_TO_BEN_THREE.create_ENT_rows(

27121: end if;
27122: --
27123: --
27124: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('ENT') then
27125: BEN_PD_COPY_TO_BEN_THREE.create_ENT_rows(
27126: p_validate => p_validate
27127: ,p_copy_entity_txn_id => p_copy_entity_txn_id
27128: ,p_effective_date => p_effective_date
27129: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 27137: BEN_PD_COPY_TO_BEN_THREE.create_ENL_rows(

27133: end if;
27134: --
27135: --
27136: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('ENL') then
27137: BEN_PD_COPY_TO_BEN_THREE.create_ENL_rows(
27138: p_validate => p_validate
27139: ,p_copy_entity_txn_id => p_copy_entity_txn_id
27140: ,p_effective_date => p_effective_date
27141: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 27149: BEN_PD_COPY_TO_BEN_THREE.create_EAR_rows(

27145: end if;
27146: --
27147: --
27148: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('EAR') then
27149: BEN_PD_COPY_TO_BEN_THREE.create_EAR_rows(
27150: p_validate => p_validate
27151: ,p_copy_entity_txn_id => p_copy_entity_txn_id
27152: ,p_effective_date => p_effective_date
27153: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 27161: BEN_PD_COPY_TO_BEN_THREE.create_EAO_rows(

27157: end if;
27158: --
27159: --
27160: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('EAO') then
27161: BEN_PD_COPY_TO_BEN_THREE.create_EAO_rows(
27162: p_validate => p_validate
27163: ,p_copy_entity_txn_id => p_copy_entity_txn_id
27164: ,p_effective_date => p_effective_date
27165: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 27173: BEN_PD_COPY_TO_BEN_THREE.create_DOT_rows(

27169: end if;
27170: --
27171: --
27172: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('DOT') then
27173: BEN_PD_COPY_TO_BEN_THREE.create_DOT_rows(
27174: p_validate => p_validate
27175: ,p_copy_entity_txn_id => p_copy_entity_txn_id
27176: ,p_effective_date => p_effective_date
27177: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 27185: BEN_PD_COPY_TO_BEN_THREE.create_DOP_rows(

27181: end if;
27182: --
27183: --
27184: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('DOP') then
27185: BEN_PD_COPY_TO_BEN_THREE.create_DOP_rows(
27186: p_validate => p_validate
27187: ,p_copy_entity_txn_id => p_copy_entity_txn_id
27188: ,p_effective_date => p_effective_date
27189: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 27197: BEN_PD_COPY_TO_BEN_THREE.create_DCP_rows(

27193: end if;
27194: --
27195: --
27196: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('DCP') then
27197: BEN_PD_COPY_TO_BEN_THREE.create_DCP_rows(
27198: p_validate => p_validate
27199: ,p_copy_entity_txn_id => p_copy_entity_txn_id
27200: ,p_effective_date => p_effective_date
27201: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 27209: BEN_PD_COPY_TO_BEN_THREE.create_DCO_rows(

27205: end if;
27206: --
27207: --
27208: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('DCO') then
27209: BEN_PD_COPY_TO_BEN_THREE.create_DCO_rows(
27210: p_validate => p_validate
27211: ,p_copy_entity_txn_id => p_copy_entity_txn_id
27212: ,p_effective_date => p_effective_date
27213: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 27221: BEN_PD_COPY_TO_BEN_THREE.create_DCL_rows(

27217: end if;
27218: --
27219: --
27220: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('DCL') then
27221: BEN_PD_COPY_TO_BEN_THREE.create_DCL_rows(
27222: p_validate => p_validate
27223: ,p_copy_entity_txn_id => p_copy_entity_txn_id
27224: ,p_effective_date => p_effective_date
27225: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 27233: BEN_PD_COPY_TO_BEN_THREE.create_EPM_rows(

27229: end if;
27230: --
27231: --
27232: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('EPM') then
27233: BEN_PD_COPY_TO_BEN_THREE.create_EPM_rows(
27234: p_validate => p_validate
27235: ,p_copy_entity_txn_id => p_copy_entity_txn_id
27236: ,p_effective_date => p_effective_date
27237: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 27245: BEN_PD_COPY_TO_BEN_THREE.create_PGR_rows(

27241: end if;
27242: --
27243: --
27244: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('PGR') then
27245: BEN_PD_COPY_TO_BEN_THREE.create_PGR_rows(
27246: p_validate => p_validate
27247: ,p_copy_entity_txn_id => p_copy_entity_txn_id
27248: ,p_effective_date => p_effective_date
27249: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 27258: end BEN_PD_COPY_TO_BEN_three;

27254: end if;
27255: end create_all_rt_prf_ben_rows;
27256: --
27257: --
27258: end BEN_PD_COPY_TO_BEN_three;