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_FIVE dependencies on BEN_PD_COPY_TO_BEN_FIVE

Line 1: Package BODY BEN_PD_COPY_TO_BEN_five as

1: Package BODY BEN_PD_COPY_TO_BEN_five as
2: /* $Header: bepdccp5.pkb 120.9 2006/04/10 05:42:54 gsehgal noship $ */
3: --
4: -- {Start Of Comments}
5: --

Line 16459: BEN_PD_COPY_TO_BEN_five.create_CTU_rows

16455: --dbms_output.put_line(' Start of create_rate_rows ') ;
16456: /* TEMP COMMENT Communication Types
16457: --
16458: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('CTU') then
16459: BEN_PD_COPY_TO_BEN_five.create_CTU_rows
16460: (p_validate => p_validate
16461: ,p_copy_entity_txn_id => p_copy_entity_txn_id
16462: ,p_effective_date => p_effective_date
16463: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 16472: BEN_PD_COPY_TO_BEN_five.create_CTT_rows

16468: --
16469:
16470: --
16471: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('CTT') then
16472: BEN_PD_COPY_TO_BEN_five.create_CTT_rows
16473: (p_validate => p_validate
16474: ,p_copy_entity_txn_id => p_copy_entity_txn_id
16475: ,p_effective_date => p_effective_date
16476: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 16485: BEN_PD_COPY_TO_BEN_five.create_CMT_rows

16481: --
16482:
16483: --
16484: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('CMT') then
16485: BEN_PD_COPY_TO_BEN_five.create_CMT_rows
16486: (p_validate => p_validate
16487: ,p_copy_entity_txn_id => p_copy_entity_txn_id
16488: ,p_effective_date => p_effective_date
16489: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 16498: BEN_PD_COPY_TO_BEN_five.create_CMD_rows

16494: --
16495:
16496: --
16497: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('CMD') then
16498: BEN_PD_COPY_TO_BEN_five.create_CMD_rows
16499: (p_validate => p_validate
16500: ,p_copy_entity_txn_id => p_copy_entity_txn_id
16501: ,p_effective_date => p_effective_date
16502: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 16512: BEN_PD_COPY_TO_BEN_five.create_CCM_rows

16508: */
16509: -- Bug 2695254 Moved to be in CCM,APR and ABR Order
16510: --
16511: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('CCM') then
16512: BEN_PD_COPY_TO_BEN_five.create_CCM_rows
16513: (p_validate => p_validate
16514: ,p_copy_entity_txn_id => p_copy_entity_txn_id
16515: ,p_effective_date => p_effective_date
16516: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 16523: BEN_PD_COPY_TO_BEN_five.create_APR_rows

16519: ,p_prefix_suffix_cd => p_prefix_suffix_cd);
16520: end if;
16521: --
16522: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('APR') then
16523: BEN_PD_COPY_TO_BEN_five.create_APR_rows
16524: (p_validate => p_validate
16525: ,p_copy_entity_txn_id => p_copy_entity_txn_id
16526: ,p_effective_date => p_effective_date
16527: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 16536: BEN_PD_COPY_TO_BEN_five.create_ABR_rows

16532: --
16533: build_abr_hierarchy ( p_copy_entity_txn_id );
16534: --
16535: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('ABR') then
16536: BEN_PD_COPY_TO_BEN_five.create_ABR_rows
16537: (p_validate => p_validate
16538: ,p_copy_entity_txn_id => p_copy_entity_txn_id
16539: ,p_effective_date => p_effective_date
16540: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 16548: BEN_PD_COPY_TO_BEN_five.create_EIV_rows

16544: end if;
16545: --
16546: --
16547: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('EIV') then
16548: BEN_PD_COPY_TO_BEN_five.create_EIV_rows
16549: (p_validate => p_validate
16550: ,p_copy_entity_txn_id => p_copy_entity_txn_id
16551: ,p_effective_date => p_effective_date
16552: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 16560: BEN_PD_COPY_TO_BEN_five.create_APF_rows

16556: end if;
16557: --
16558: --
16559: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('APF') then
16560: BEN_PD_COPY_TO_BEN_five.create_APF_rows
16561: (p_validate => p_validate
16562: ,p_copy_entity_txn_id => p_copy_entity_txn_id
16563: ,p_effective_date => p_effective_date
16564: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 16572: BEN_PD_COPY_TO_BEN_five.create_PSQ_rows

16568: end if;
16569: --
16570: --
16571: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('PSQ') then
16572: BEN_PD_COPY_TO_BEN_five.create_PSQ_rows
16573: (p_validate => p_validate
16574: ,p_copy_entity_txn_id => p_copy_entity_txn_id
16575: ,p_effective_date => p_effective_date
16576: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 16584: BEN_PD_COPY_TO_BEN_five.create_ABC_rows

16580: end if;
16581: --
16582: --
16583: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('ABC') then
16584: BEN_PD_COPY_TO_BEN_five.create_ABC_rows
16585: (p_validate => p_validate
16586: ,p_copy_entity_txn_id => p_copy_entity_txn_id
16587: ,p_effective_date => p_effective_date
16588: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 16597: BEN_PD_COPY_TO_BEN_five.create_MTR_rows

16593: --
16594:
16595: --
16596: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('MTR') then
16597: BEN_PD_COPY_TO_BEN_five.create_MTR_rows
16598: (p_validate => p_validate
16599: ,p_copy_entity_txn_id => p_copy_entity_txn_id
16600: ,p_effective_date => p_effective_date
16601: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 16610: BEN_PD_COPY_TO_BEN_five.create_APL1_rows

16606: --
16607:
16608: --
16609: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('APL1') then
16610: BEN_PD_COPY_TO_BEN_five.create_APL1_rows
16611: (p_validate => p_validate
16612: ,p_copy_entity_txn_id => p_copy_entity_txn_id
16613: ,p_effective_date => p_effective_date
16614: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 16622: BEN_PD_COPY_TO_BEN_five.create_VPF_rows

16618: end if;
16619: --
16620: --
16621: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('VPF') then
16622: BEN_PD_COPY_TO_BEN_five.create_VPF_rows
16623: (p_validate => p_validate
16624: ,p_copy_entity_txn_id => p_copy_entity_txn_id
16625: ,p_effective_date => p_effective_date
16626: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 16634: BEN_PD_COPY_TO_BEN_five.create_AVR_rows

16630: end if;
16631: --
16632: --
16633: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('AVR') then
16634: BEN_PD_COPY_TO_BEN_five.create_AVR_rows
16635: (p_validate => p_validate
16636: ,p_copy_entity_txn_id => p_copy_entity_txn_id
16637: ,p_effective_date => p_effective_date
16638: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 16649: BEN_PD_COPY_TO_BEN_five.create_PMRPV_rows

16645: -- Create Partial Month Proration
16646: -- (To be called after creating ABR, APR and CCM)
16647: --
16648: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('PMRPV') then
16649: BEN_PD_COPY_TO_BEN_five.create_PMRPV_rows
16650: (p_validate => p_validate
16651: ,p_copy_entity_txn_id => p_copy_entity_txn_id
16652: ,p_effective_date => p_effective_date
16653: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 16662: BEN_PD_COPY_TO_BEN_five.create_BVR1_rows

16658: --
16659:
16660: --
16661: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('BVR1') then
16662: BEN_PD_COPY_TO_BEN_five.create_BVR1_rows
16663: (p_validate => p_validate
16664: ,p_copy_entity_txn_id => p_copy_entity_txn_id
16665: ,p_effective_date => p_effective_date
16666: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 16675: BEN_PD_COPY_TO_BEN_five.create_BRR_rows

16671: --
16672:
16673: --
16674: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('BRR') then
16675: BEN_PD_COPY_TO_BEN_five.create_BRR_rows
16676: (p_validate => p_validate
16677: ,p_copy_entity_txn_id => p_copy_entity_txn_id
16678: ,p_effective_date => p_effective_date
16679: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 16688: BEN_PD_COPY_TO_BEN_five.create_APV_rows

16684: --
16685:
16686: --
16687: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('APV') then
16688: BEN_PD_COPY_TO_BEN_five.create_APV_rows
16689: (p_validate => p_validate
16690: ,p_copy_entity_txn_id => p_copy_entity_txn_id
16691: ,p_effective_date => p_effective_date
16692: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 16701: BEN_PD_COPY_TO_BEN_five.create_AVA_rows

16697: --
16698:
16699: --
16700: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('AVA') then
16701: BEN_PD_COPY_TO_BEN_five.create_AVA_rows
16702: (p_validate => p_validate
16703: ,p_copy_entity_txn_id => p_copy_entity_txn_id
16704: ,p_effective_date => p_effective_date
16705: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 16714: BEN_PD_COPY_TO_BEN_five.create_DCR_rows

16710: --
16711:
16712: --
16713: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('DCR') then
16714: BEN_PD_COPY_TO_BEN_five.create_DCR_rows
16715: (p_validate => p_validate
16716: ,p_copy_entity_txn_id => p_copy_entity_txn_id
16717: ,p_effective_date => p_effective_date
16718: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 16727: BEN_PD_COPY_TO_BEN_five.create_DEC_rows

16723: --
16724:
16725: --
16726: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('DEC') then
16727: BEN_PD_COPY_TO_BEN_five.create_DEC_rows
16728: (p_validate => p_validate
16729: ,p_copy_entity_txn_id => p_copy_entity_txn_id
16730: ,p_effective_date => p_effective_date
16731: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 16740: BEN_PD_COPY_TO_BEN_five.create_EAC_rows

16736: --
16737:
16738: --
16739: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('EAC') then
16740: BEN_PD_COPY_TO_BEN_five.create_EAC_rows
16741: (p_validate => p_validate
16742: ,p_copy_entity_txn_id => p_copy_entity_txn_id
16743: ,p_effective_date => p_effective_date
16744: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 16753: BEN_PD_COPY_TO_BEN_five.create_EDC_rows

16749: --
16750:
16751: --
16752: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('EDC') then
16753: BEN_PD_COPY_TO_BEN_five.create_EDC_rows
16754: (p_validate => p_validate
16755: ,p_copy_entity_txn_id => p_copy_entity_txn_id
16756: ,p_effective_date => p_effective_date
16757: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 16766: BEN_PD_COPY_TO_BEN_five.create_EMC_rows

16762: --
16763:
16764: --
16765: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('EMC') then
16766: BEN_PD_COPY_TO_BEN_five.create_EMC_rows
16767: (p_validate => p_validate
16768: ,p_copy_entity_txn_id => p_copy_entity_txn_id
16769: ,p_effective_date => p_effective_date
16770: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 16779: BEN_PD_COPY_TO_BEN_five.create_EMS_rows

16775: --
16776:
16777: --
16778: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('EMS') then
16779: BEN_PD_COPY_TO_BEN_five.create_EMS_rows
16780: (p_validate => p_validate
16781: ,p_copy_entity_txn_id => p_copy_entity_txn_id
16782: ,p_effective_date => p_effective_date
16783: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 16792: BEN_PD_COPY_TO_BEN_five.create_EPL_rows

16788: --
16789:
16790: --
16791: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('EPL') then
16792: BEN_PD_COPY_TO_BEN_five.create_EPL_rows
16793: (p_validate => p_validate
16794: ,p_copy_entity_txn_id => p_copy_entity_txn_id
16795: ,p_effective_date => p_effective_date
16796: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 16804: BEN_PD_COPY_TO_BEN_five.create_ESC_rows

16800: end if;
16801: --
16802: --
16803: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('ESC') then
16804: BEN_PD_COPY_TO_BEN_five.create_ESC_rows
16805: (p_validate => p_validate
16806: ,p_copy_entity_txn_id => p_copy_entity_txn_id
16807: ,p_effective_date => p_effective_date
16808: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 16815: BEN_PD_COPY_TO_BEN_five.create_VEP_rows

16811: ,p_prefix_suffix_cd => p_prefix_suffix_cd);
16812: end if;
16813:
16814: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('VEP') then
16815: BEN_PD_COPY_TO_BEN_five.create_VEP_rows
16816: (p_validate => p_validate
16817: ,p_copy_entity_txn_id => p_copy_entity_txn_id
16818: ,p_effective_date => p_effective_date
16819: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 16835: BEN_PD_COPY_TO_BEN_five.create_ABP_rows

16831: if BEN_PD_COPY_TO_BEN_ONE.g_transaction_category = 'BEN_PDCRWZ' then
16832:
16833: --
16834: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('ABP') then
16835: BEN_PD_COPY_TO_BEN_five.create_ABP_rows
16836: (p_validate => p_validate
16837: ,p_copy_entity_txn_id => p_copy_entity_txn_id
16838: ,p_effective_date => p_effective_date
16839: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 16847: BEN_PD_COPY_TO_BEN_five.create_BPR_rows

16843: end if;
16844: --
16845: --
16846: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('BPR1') then
16847: BEN_PD_COPY_TO_BEN_five.create_BPR_rows
16848: (p_validate => p_validate
16849: ,p_copy_entity_txn_id => p_copy_entity_txn_id
16850: ,p_effective_date => p_effective_date
16851: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 16859: BEN_PD_COPY_TO_BEN_five.create_DPC_rows

16855: end if;
16856: --
16857: --
16858: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('DPC') then
16859: BEN_PD_COPY_TO_BEN_five.create_DPC_rows
16860: (p_validate => p_validate
16861: ,p_copy_entity_txn_id => p_copy_entity_txn_id
16862: ,p_effective_date => p_effective_date
16863: ,p_prefix_suffix_text => p_prefix_suffix_text

Line 16872: end BEN_PD_COPY_TO_BEN_five;

16868: --
16869: end if;
16870: end;
16871: --
16872: end BEN_PD_COPY_TO_BEN_five;