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.

[Home] [Help]

APPS.BEN_LF_EVT_CLPS_RESTORE dependencies on BEN_REINSTATE_EPE_CACHE

Line 7644: function comp_ori_new_epe(p_bckdt_epe_row ben_reinstate_epe_cache.g_pilepe_inst_row,

7640: -- This procedure compares the original and new electability
7641: -- data associated with the same ler and returns Y if changes
7642: -- exists else returns N.
7643: --
7644: function comp_ori_new_epe(p_bckdt_epe_row ben_reinstate_epe_cache.g_pilepe_inst_row,
7645: p_current_epe_row ben_reinstate_epe_cache.g_pilepe_inst_row,
7646: p_per_in_ler_id number,
7647: p_bckdt_per_in_ler_id number,
7648: p_person_id number,

Line 7645: p_current_epe_row ben_reinstate_epe_cache.g_pilepe_inst_row,

7641: -- data associated with the same ler and returns Y if changes
7642: -- exists else returns N.
7643: --
7644: function comp_ori_new_epe(p_bckdt_epe_row ben_reinstate_epe_cache.g_pilepe_inst_row,
7645: p_current_epe_row ben_reinstate_epe_cache.g_pilepe_inst_row,
7646: p_per_in_ler_id number,
7647: p_bckdt_per_in_ler_id number,
7648: p_person_id number,
7649: p_business_group_id number,

Line 7806: ,p_pilepe_inst_table out nocopy ben_reinstate_epe_cache.g_pilepe_inst_tbl

7802: ,p_pgm_id in number
7803: ,p_pl_id in number
7804: ,p_effective_date in date
7805: ,p_bckdt_per_in_ler_id in number
7806: ,p_pilepe_inst_table out nocopy ben_reinstate_epe_cache.g_pilepe_inst_tbl
7807: ,p_bckdt_pen_table out nocopy g_bckdt_pen_tbl
7808: ) is
7809: --
7810: l_proc varchar2(72) := g_package||'.get_backedout_results';

Line 7814: l_bkd_pilepe_inst_row ben_reinstate_epe_cache.g_pilepe_inst_row;

7810: l_proc varchar2(72) := g_package||'.get_backedout_results';
7811: --
7812: -- Get the electable choice data.
7813: --
7814: l_bkd_pilepe_inst_row ben_reinstate_epe_cache.g_pilepe_inst_row;
7815: l_bkd_pilepe_inst_table ben_reinstate_epe_cache.g_pilepe_inst_tbl;
7816: l_bkd_penepe_counter binary_integer ;
7817: l_hv pls_integer;
7818: --

Line 7815: l_bkd_pilepe_inst_table ben_reinstate_epe_cache.g_pilepe_inst_tbl;

7811: --
7812: -- Get the electable choice data.
7813: --
7814: l_bkd_pilepe_inst_row ben_reinstate_epe_cache.g_pilepe_inst_row;
7815: l_bkd_pilepe_inst_table ben_reinstate_epe_cache.g_pilepe_inst_tbl;
7816: l_bkd_penepe_counter binary_integer ;
7817: l_hv pls_integer;
7818: --
7819: l_dummy_number number;

Line 7847: ben_reinstate_epe_cache.get_pilcobjepe_dets(

7843: --
7844: --
7845: hr_utility.set_location('Inside BCKDT pen loop ' || l_proc,20);
7846: --
7847: ben_reinstate_epe_cache.get_pilcobjepe_dets(
7848: p_per_in_ler_id => p_bckdt_per_in_ler_id
7849: ,p_pgm_id => l_bckdt_pen_rec.pgm_id
7850: ,p_pl_id => l_bckdt_pen_rec.pl_id
7851: ,p_oipl_id => l_bckdt_pen_rec.oipl_id

Line 8021: ,p_epe_table in ben_reinstate_epe_cache.g_pilepe_inst_tbl

8017: */
8018: --
8019: procedure reinstate_prev_enrt_for_popl(
8020: p_bckdt_pen_table in g_bckdt_pen_tbl
8021: ,p_epe_table in ben_reinstate_epe_cache.g_pilepe_inst_tbl
8022: ,p_pgm_table in out nocopy g_pgm_table
8023: ,p_pl_table in out nocopy g_pl_table
8024: ,p_enrt_table in out nocopy g_enrt_table
8025: ,p_person_id in number

Line 8057: l_epe_pen_rec ben_reinstate_epe_cache.g_pilepe_inst_row;

8053: l_bckdt_pen_rec g_bckdt_pen%rowtype;
8054: --
8055: -- Get the enrollment results from the backup table for backed out pil.
8056: --
8057: l_epe_pen_rec ben_reinstate_epe_cache.g_pilepe_inst_row;
8058: --
8059: cursor c_bnft(cp_elig_per_elctbl_chc_id in number,cp_ordr_num number ) is
8060: select enb.enrt_bnft_id,
8061: enb.entr_val_at_enrt_flag,

Line 10085: l_bckdt_pilepe_table ben_reinstate_epe_cache.g_pilepe_inst_tbl;

10081: l_reinstate_cd varchar2(30);
10082: l_reinstate_ovrdn_cd varchar2(30);
10083: l_susp_flag boolean ;
10084: l_batch_flag boolean := FALSE ; ---99999 When called from benmngle batch it needs to be TRUE
10085: l_bckdt_pilepe_table ben_reinstate_epe_cache.g_pilepe_inst_tbl;
10086: l_bckdt_pen_table g_bckdt_pen_tbl;
10087: l_bckdt_pilepe_inst_row ben_reinstate_epe_cache.g_pilepe_inst_row;
10088: l_bckdt_epe_count number;
10089: l_pilepe_inst_row ben_reinstate_epe_cache.g_pilepe_inst_row;

Line 10087: l_bckdt_pilepe_inst_row ben_reinstate_epe_cache.g_pilepe_inst_row;

10083: l_susp_flag boolean ;
10084: l_batch_flag boolean := FALSE ; ---99999 When called from benmngle batch it needs to be TRUE
10085: l_bckdt_pilepe_table ben_reinstate_epe_cache.g_pilepe_inst_tbl;
10086: l_bckdt_pen_table g_bckdt_pen_tbl;
10087: l_bckdt_pilepe_inst_row ben_reinstate_epe_cache.g_pilepe_inst_row;
10088: l_bckdt_epe_count number;
10089: l_pilepe_inst_row ben_reinstate_epe_cache.g_pilepe_inst_row;
10090: --
10091: --To reinstate

Line 10089: l_pilepe_inst_row ben_reinstate_epe_cache.g_pilepe_inst_row;

10085: l_bckdt_pilepe_table ben_reinstate_epe_cache.g_pilepe_inst_tbl;
10086: l_bckdt_pen_table g_bckdt_pen_tbl;
10087: l_bckdt_pilepe_inst_row ben_reinstate_epe_cache.g_pilepe_inst_row;
10088: l_bckdt_epe_count number;
10089: l_pilepe_inst_row ben_reinstate_epe_cache.g_pilepe_inst_row;
10090: --
10091: --To reinstate
10092: --
10093: l_valid_count number;

Line 10095: l_valid_epe_table ben_reinstate_epe_cache.g_pilepe_inst_tbl;

10091: --To reinstate
10092: --
10093: l_valid_count number;
10094: l_valid_pen_table g_bckdt_pen_tbl;
10095: l_valid_epe_table ben_reinstate_epe_cache.g_pilepe_inst_tbl;
10096: --
10097: --To report non-reinstating results info
10098: --
10099: l_invalid_pen_table g_bckdt_pen_tbl;

Line 10101: l_invalid_epe_table ben_reinstate_epe_cache.g_pilepe_inst_tbl;

10097: --To report non-reinstating results info
10098: --
10099: l_invalid_pen_table g_bckdt_pen_tbl;
10100: l_invalid_count number;
10101: l_invalid_epe_table ben_reinstate_epe_cache.g_pilepe_inst_tbl;
10102: --
10103: l_pgm_table g_pgm_table;
10104: l_pl_table g_pl_table;
10105: l_enrt_table g_enrt_table;

Line 10413: ben_reinstate_epe_cache.get_pilcobjepe_dets(

10409: l_bckdt_pilepe_inst_row := l_bckdt_pilepe_table(l_bckdt_epe);
10410: hr_utility.set_location(' Reinstate '||l_bckdt_pen_table(l_bckdt_epe).pgm_id
10411: ||' PLN '||l_bckdt_pen_table(l_bckdt_epe).pl_id||' OIPL '
10412: ||l_bckdt_pen_table(l_bckdt_epe).oipl_id,175);
10413: ben_reinstate_epe_cache.get_pilcobjepe_dets(
10414: p_per_in_ler_id => p_per_in_ler_id
10415: ,p_pgm_id => l_bckdt_pen_table(l_bckdt_epe).pgm_id
10416: ,p_pl_id => l_bckdt_pen_table(l_bckdt_epe).pl_id
10417: ,p_oipl_id => l_bckdt_pen_table(l_bckdt_epe).oipl_id

Line 10677: hr_utility.set_location('Calling ben_reinstate_epe_cache.get_pilcobjepe_dets',100);

10673: --Get the current per_in_ler info
10674: --
10675: l_bckdt_pilepe_inst_row := l_bckdt_pilepe_table(l_bckdt_epe);
10676: --
10677: hr_utility.set_location('Calling ben_reinstate_epe_cache.get_pilcobjepe_dets',100);
10678: hr_utility.set_location('pgm '||l_bckdt_pen_table(l_bckdt_epe).pgm_id,100);
10679: hr_utility.set_location('pln '||l_bckdt_pen_table(l_bckdt_epe).pl_id,100);
10680: hr_utility.set_location('oipl '||l_bckdt_pen_table(l_bckdt_epe).oipl_id,100);
10681: --

Line 10682: ben_reinstate_epe_cache.get_pilcobjepe_dets(

10678: hr_utility.set_location('pgm '||l_bckdt_pen_table(l_bckdt_epe).pgm_id,100);
10679: hr_utility.set_location('pln '||l_bckdt_pen_table(l_bckdt_epe).pl_id,100);
10680: hr_utility.set_location('oipl '||l_bckdt_pen_table(l_bckdt_epe).oipl_id,100);
10681: --
10682: ben_reinstate_epe_cache.get_pilcobjepe_dets(
10683: p_per_in_ler_id => p_per_in_ler_id
10684: ,p_pgm_id => l_bckdt_pen_table(l_bckdt_epe).pgm_id
10685: ,p_pl_id => l_bckdt_pen_table(l_bckdt_epe).pl_id
10686: ,p_oipl_id => l_bckdt_pen_table(l_bckdt_epe).oipl_id

Line 10750: hr_utility.set_location(' Calling ben_reinstate_epe_cache.get_pilcobjepe_dets '||l_bckdt_pen_table(l_bckdt_epe).pgm_id

10746: --Get the current per_in_ler info
10747: --
10748: l_bckdt_pilepe_inst_row := l_bckdt_pilepe_table(l_bckdt_epe);
10749: --
10750: hr_utility.set_location(' Calling ben_reinstate_epe_cache.get_pilcobjepe_dets '||l_bckdt_pen_table(l_bckdt_epe).pgm_id
10751: ||' PLN '||l_bckdt_pen_table(l_bckdt_epe).pl_id||' OIPL '
10752: ||l_bckdt_pen_table(l_bckdt_epe).oipl_id,145);
10753: ben_reinstate_epe_cache.get_pilcobjepe_dets(
10754: p_per_in_ler_id => p_per_in_ler_id

Line 10753: ben_reinstate_epe_cache.get_pilcobjepe_dets(

10749: --
10750: hr_utility.set_location(' Calling ben_reinstate_epe_cache.get_pilcobjepe_dets '||l_bckdt_pen_table(l_bckdt_epe).pgm_id
10751: ||' PLN '||l_bckdt_pen_table(l_bckdt_epe).pl_id||' OIPL '
10752: ||l_bckdt_pen_table(l_bckdt_epe).oipl_id,145);
10753: ben_reinstate_epe_cache.get_pilcobjepe_dets(
10754: p_per_in_ler_id => p_per_in_ler_id
10755: ,p_pgm_id => l_bckdt_pen_table(l_bckdt_epe).pgm_id
10756: ,p_pl_id => l_bckdt_pen_table(l_bckdt_epe).pl_id
10757: ,p_oipl_id => l_bckdt_pen_table(l_bckdt_epe).oipl_id

Line 10843: hr_utility.set_location(' Calling ben_reinstate_epe_cache.get_pilcobjepe_dets '||l_bckdt_pen_table(l_bckdt_epe).pgm_id

10839: --Get the current per_in_ler info
10840: --
10841: l_bckdt_pilepe_inst_row := l_bckdt_pilepe_table(l_bckdt_epe);
10842: --
10843: hr_utility.set_location(' Calling ben_reinstate_epe_cache.get_pilcobjepe_dets '||l_bckdt_pen_table(l_bckdt_epe).pgm_id
10844: ||' PLN '||l_bckdt_pen_table(l_bckdt_epe).pl_id||' OIPL '
10845: ||l_bckdt_pen_table(l_bckdt_epe).oipl_id,175);
10846: --
10847: ben_reinstate_epe_cache.get_pilcobjepe_dets(

Line 10847: ben_reinstate_epe_cache.get_pilcobjepe_dets(

10843: hr_utility.set_location(' Calling ben_reinstate_epe_cache.get_pilcobjepe_dets '||l_bckdt_pen_table(l_bckdt_epe).pgm_id
10844: ||' PLN '||l_bckdt_pen_table(l_bckdt_epe).pl_id||' OIPL '
10845: ||l_bckdt_pen_table(l_bckdt_epe).oipl_id,175);
10846: --
10847: ben_reinstate_epe_cache.get_pilcobjepe_dets(
10848: p_per_in_ler_id => p_per_in_ler_id
10849: ,p_pgm_id => l_bckdt_pen_table(l_bckdt_epe).pgm_id
10850: ,p_pl_id => l_bckdt_pen_table(l_bckdt_epe).pl_id
10851: ,p_oipl_id => l_bckdt_pen_table(l_bckdt_epe).oipl_id