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_PDW_COPY_BEN_TO_STG dependencies on BEN_PDW_COPY_BEN_TO_STG

Line 1: PACKAGE BODY BEN_PDW_COPY_BEN_TO_STG AS

1: PACKAGE BODY BEN_PDW_COPY_BEN_TO_STG AS
2: /* $Header: bepdwstg.pkb 120.20.12010000.1 2008/07/29 12:45:43 appldev ship $ */
3: g_package varchar2(30) :='BEN_PDW_COPY_BEN_TO_STG';
4: PROCEDURE get_txn_details (
5: p_copy_entity_txn_id IN NUMBER

Line 3: g_package varchar2(30) :='BEN_PDW_COPY_BEN_TO_STG';

1: PACKAGE BODY BEN_PDW_COPY_BEN_TO_STG AS
2: /* $Header: bepdwstg.pkb 120.20.12010000.1 2008/07/29 12:45:43 appldev ship $ */
3: g_package varchar2(30) :='BEN_PDW_COPY_BEN_TO_STG';
4: PROCEDURE get_txn_details (
5: p_copy_entity_txn_id IN NUMBER
6: ,p_business_group_id OUT NOCOPY NUMBER
7: ,p_effective_date OUT NOCOPY DATE

Line 955: l_new_enrt_cd := BEN_PDW_COPY_BEN_TO_STG.get_new_enrt_cd(l_lpr1.ENRT_CD);

951: End Loop ;
952: --
953: for l_lpr1 in c_lpr1(p_copy_entity_txn_id, p_effective_date)
954: loop
955: l_new_enrt_cd := BEN_PDW_COPY_BEN_TO_STG.get_new_enrt_cd(l_lpr1.ENRT_CD);
956: l_cur_enrt_cd := BEN_PDW_COPY_BEN_TO_STG.get_cur_enrt_cd(l_lpr1.ENRT_CD);
957: update
958: ben_copy_entity_results
959: set

Line 956: l_cur_enrt_cd := BEN_PDW_COPY_BEN_TO_STG.get_cur_enrt_cd(l_lpr1.ENRT_CD);

952: --
953: for l_lpr1 in c_lpr1(p_copy_entity_txn_id, p_effective_date)
954: loop
955: l_new_enrt_cd := BEN_PDW_COPY_BEN_TO_STG.get_new_enrt_cd(l_lpr1.ENRT_CD);
956: l_cur_enrt_cd := BEN_PDW_COPY_BEN_TO_STG.get_cur_enrt_cd(l_lpr1.ENRT_CD);
957: update
958: ben_copy_entity_results
959: set
960: information101 = l_new_enrt_cd,

Line 4404: l_new_enrt_cd := BEN_PDW_COPY_BEN_TO_STG.get_new_enrt_cd(L_Enrt_Ctp.ENRT_CD);

4400: --
4401: -- Now update the New and Cur Enrt Codes from Enrt_CD
4402: For L_Enrt_Ctp in C_Enrt_Ctp
4403: loop
4404: l_new_enrt_cd := BEN_PDW_COPY_BEN_TO_STG.get_new_enrt_cd(L_Enrt_Ctp.ENRT_CD);
4405: l_cur_enrt_cd := BEN_PDW_COPY_BEN_TO_STG.get_cur_enrt_cd(L_Enrt_Ctp.ENRT_CD);
4406:
4407: update
4408: ben_copy_entity_results

Line 4405: l_cur_enrt_cd := BEN_PDW_COPY_BEN_TO_STG.get_cur_enrt_cd(L_Enrt_Ctp.ENRT_CD);

4401: -- Now update the New and Cur Enrt Codes from Enrt_CD
4402: For L_Enrt_Ctp in C_Enrt_Ctp
4403: loop
4404: l_new_enrt_cd := BEN_PDW_COPY_BEN_TO_STG.get_new_enrt_cd(L_Enrt_Ctp.ENRT_CD);
4405: l_cur_enrt_cd := BEN_PDW_COPY_BEN_TO_STG.get_cur_enrt_cd(L_Enrt_Ctp.ENRT_CD);
4406:
4407: update
4408: ben_copy_entity_results
4409: set

Line 4622: l_new_enrt_cd := BEN_PDW_COPY_BEN_TO_STG.get_new_enrt_cd(l_lct.ENRT_CD);

4618: End Loop ;
4619: --
4620: for l_lct in c_enrt_lct
4621: loop
4622: l_new_enrt_cd := BEN_PDW_COPY_BEN_TO_STG.get_new_enrt_cd(l_lct.ENRT_CD);
4623: l_cur_enrt_cd := BEN_PDW_COPY_BEN_TO_STG.get_cur_enrt_cd(l_lct.ENRT_CD);
4624: update
4625: ben_copy_entity_results
4626: set

Line 4623: l_cur_enrt_cd := BEN_PDW_COPY_BEN_TO_STG.get_cur_enrt_cd(l_lct.ENRT_CD);

4619: --
4620: for l_lct in c_enrt_lct
4621: loop
4622: l_new_enrt_cd := BEN_PDW_COPY_BEN_TO_STG.get_new_enrt_cd(l_lct.ENRT_CD);
4623: l_cur_enrt_cd := BEN_PDW_COPY_BEN_TO_STG.get_cur_enrt_cd(l_lct.ENRT_CD);
4624: update
4625: ben_copy_entity_results
4626: set
4627: information101 = l_new_enrt_cd,

Line 4735: l_new_enrt_cd := BEN_PDW_COPY_BEN_TO_STG.get_new_enrt_cd(L_Cpp.ENRT_CD);

4731: --
4732:
4733: -- Now update the New and Cur Enrt Codes from Enrt_CD
4734: for l_cpp in C_Enrt_CPP loop
4735: l_new_enrt_cd := BEN_PDW_COPY_BEN_TO_STG.get_new_enrt_cd(L_Cpp.ENRT_CD);
4736: l_cur_enrt_cd := BEN_PDW_COPY_BEN_TO_STG.get_cur_enrt_cd(L_Cpp.ENRT_CD);
4737:
4738: update
4739: ben_copy_entity_results

Line 4736: l_cur_enrt_cd := BEN_PDW_COPY_BEN_TO_STG.get_cur_enrt_cd(L_Cpp.ENRT_CD);

4732:
4733: -- Now update the New and Cur Enrt Codes from Enrt_CD
4734: for l_cpp in C_Enrt_CPP loop
4735: l_new_enrt_cd := BEN_PDW_COPY_BEN_TO_STG.get_new_enrt_cd(L_Cpp.ENRT_CD);
4736: l_cur_enrt_cd := BEN_PDW_COPY_BEN_TO_STG.get_cur_enrt_cd(L_Cpp.ENRT_CD);
4737:
4738: update
4739: ben_copy_entity_results
4740: set

Line 4775: l_new_enrt_cd := BEN_PDW_COPY_BEN_TO_STG.get_new_enrt_cd(l_PGM.information51) ;

4771: hr_utility.set_location('Entering: '||l_proc,10);
4772: --
4773: For l_PGM in c_PGM Loop
4774: --
4775: l_new_enrt_cd := BEN_PDW_COPY_BEN_TO_STG.get_new_enrt_cd(l_PGM.information51) ;
4776: l_cur_enrt_cd := BEN_PDW_COPY_BEN_TO_STG.get_cur_enrt_cd(l_PGM.information51) ;
4777:
4778: Update
4779: Ben_copy_entity_results pgm1

Line 4776: l_cur_enrt_cd := BEN_PDW_COPY_BEN_TO_STG.get_cur_enrt_cd(l_PGM.information51) ;

4772: --
4773: For l_PGM in c_PGM Loop
4774: --
4775: l_new_enrt_cd := BEN_PDW_COPY_BEN_TO_STG.get_new_enrt_cd(l_PGM.information51) ;
4776: l_cur_enrt_cd := BEN_PDW_COPY_BEN_TO_STG.get_cur_enrt_cd(l_PGM.information51) ;
4777:
4778: Update
4779: Ben_copy_entity_results pgm1
4780: Set

Line 5328: END BEN_PDW_COPY_BEN_TO_STG;

5324: where copy_entity_txn_id = p_copy_entity_txn_id;
5325: commit;
5326: raise;
5327: end copy_elig_pzip_bnftgrp;
5328: END BEN_PDW_COPY_BEN_TO_STG;