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_LF_EVT_CLPS_RESTORE dependencies on BEN_REINSTATE_EPE_CACHE

Line 7250: function comp_ori_new_epe(p_bckdt_epe_row ben_reinstate_epe_cache.g_pilepe_inst_row,

7246: -- This procedure compares the original and new electability
7247: -- data associated with the same ler and returns Y if changes
7248: -- exists else returns N.
7249: --
7250: function comp_ori_new_epe(p_bckdt_epe_row ben_reinstate_epe_cache.g_pilepe_inst_row,
7251: p_current_epe_row ben_reinstate_epe_cache.g_pilepe_inst_row,
7252: p_per_in_ler_id number,
7253: p_bckdt_per_in_ler_id number,
7254: p_person_id number,

Line 7251: p_current_epe_row ben_reinstate_epe_cache.g_pilepe_inst_row,

7247: -- data associated with the same ler and returns Y if changes
7248: -- exists else returns N.
7249: --
7250: function comp_ori_new_epe(p_bckdt_epe_row ben_reinstate_epe_cache.g_pilepe_inst_row,
7251: p_current_epe_row ben_reinstate_epe_cache.g_pilepe_inst_row,
7252: p_per_in_ler_id number,
7253: p_bckdt_per_in_ler_id number,
7254: p_person_id number,
7255: p_business_group_id number,

Line 7412: ,p_pilepe_inst_table out nocopy ben_reinstate_epe_cache.g_pilepe_inst_tbl

7408: ,p_pgm_id in number
7409: ,p_pl_id in number
7410: ,p_effective_date in date
7411: ,p_bckdt_per_in_ler_id in number
7412: ,p_pilepe_inst_table out nocopy ben_reinstate_epe_cache.g_pilepe_inst_tbl
7413: ,p_bckdt_pen_table out nocopy g_bckdt_pen_tbl
7414: ) is
7415: --
7416: l_proc varchar2(72) := g_package||'.get_backedout_results';

Line 7420: l_bkd_pilepe_inst_row ben_reinstate_epe_cache.g_pilepe_inst_row;

7416: l_proc varchar2(72) := g_package||'.get_backedout_results';
7417: --
7418: -- Get the electable choice data.
7419: --
7420: l_bkd_pilepe_inst_row ben_reinstate_epe_cache.g_pilepe_inst_row;
7421: l_bkd_pilepe_inst_table ben_reinstate_epe_cache.g_pilepe_inst_tbl;
7422: l_bkd_penepe_counter binary_integer ;
7423: l_hv pls_integer;
7424: --

Line 7421: l_bkd_pilepe_inst_table ben_reinstate_epe_cache.g_pilepe_inst_tbl;

7417: --
7418: -- Get the electable choice data.
7419: --
7420: l_bkd_pilepe_inst_row ben_reinstate_epe_cache.g_pilepe_inst_row;
7421: l_bkd_pilepe_inst_table ben_reinstate_epe_cache.g_pilepe_inst_tbl;
7422: l_bkd_penepe_counter binary_integer ;
7423: l_hv pls_integer;
7424: --
7425: l_dummy_number number;

Line 7453: ben_reinstate_epe_cache.get_pilcobjepe_dets(

7449: --
7450: --
7451: hr_utility.set_location('Inside BCKDT pen loop ' || l_proc,20);
7452: --
7453: ben_reinstate_epe_cache.get_pilcobjepe_dets(
7454: p_per_in_ler_id => p_bckdt_per_in_ler_id
7455: ,p_pgm_id => l_bckdt_pen_rec.pgm_id
7456: ,p_pl_id => l_bckdt_pen_rec.pl_id
7457: ,p_oipl_id => l_bckdt_pen_rec.oipl_id

Line 7627: ,p_epe_table in ben_reinstate_epe_cache.g_pilepe_inst_tbl

7623: */
7624: --
7625: procedure reinstate_prev_enrt_for_popl(
7626: p_bckdt_pen_table in g_bckdt_pen_tbl
7627: ,p_epe_table in ben_reinstate_epe_cache.g_pilepe_inst_tbl
7628: ,p_pgm_table in out nocopy g_pgm_table
7629: ,p_pl_table in out nocopy g_pl_table
7630: ,p_enrt_table in out nocopy g_enrt_table
7631: ,p_person_id in number

Line 7663: l_epe_pen_rec ben_reinstate_epe_cache.g_pilepe_inst_row;

7659: l_bckdt_pen_rec g_bckdt_pen%rowtype;
7660: --
7661: -- Get the enrollment results from the backup table for backed out pil.
7662: --
7663: l_epe_pen_rec ben_reinstate_epe_cache.g_pilepe_inst_row;
7664: --
7665: cursor c_bnft(cp_elig_per_elctbl_chc_id in number,cp_ordr_num number ) is
7666: select enb.enrt_bnft_id,
7667: enb.entr_val_at_enrt_flag,

Line 9163: l_bckdt_pilepe_table ben_reinstate_epe_cache.g_pilepe_inst_tbl;

9159: l_reinstate_cd varchar2(30);
9160: l_reinstate_ovrdn_cd varchar2(30);
9161: l_susp_flag boolean ;
9162: l_batch_flag boolean := FALSE ; ---99999 When called from benmngle batch it needs to be TRUE
9163: l_bckdt_pilepe_table ben_reinstate_epe_cache.g_pilepe_inst_tbl;
9164: l_bckdt_pen_table g_bckdt_pen_tbl;
9165: l_bckdt_pilepe_inst_row ben_reinstate_epe_cache.g_pilepe_inst_row;
9166: l_bckdt_epe_count number;
9167: l_pilepe_inst_row ben_reinstate_epe_cache.g_pilepe_inst_row;

Line 9165: l_bckdt_pilepe_inst_row ben_reinstate_epe_cache.g_pilepe_inst_row;

9161: l_susp_flag boolean ;
9162: l_batch_flag boolean := FALSE ; ---99999 When called from benmngle batch it needs to be TRUE
9163: l_bckdt_pilepe_table ben_reinstate_epe_cache.g_pilepe_inst_tbl;
9164: l_bckdt_pen_table g_bckdt_pen_tbl;
9165: l_bckdt_pilepe_inst_row ben_reinstate_epe_cache.g_pilepe_inst_row;
9166: l_bckdt_epe_count number;
9167: l_pilepe_inst_row ben_reinstate_epe_cache.g_pilepe_inst_row;
9168: --
9169: --To reinstate

Line 9167: l_pilepe_inst_row ben_reinstate_epe_cache.g_pilepe_inst_row;

9163: l_bckdt_pilepe_table ben_reinstate_epe_cache.g_pilepe_inst_tbl;
9164: l_bckdt_pen_table g_bckdt_pen_tbl;
9165: l_bckdt_pilepe_inst_row ben_reinstate_epe_cache.g_pilepe_inst_row;
9166: l_bckdt_epe_count number;
9167: l_pilepe_inst_row ben_reinstate_epe_cache.g_pilepe_inst_row;
9168: --
9169: --To reinstate
9170: --
9171: l_valid_count number;

Line 9173: l_valid_epe_table ben_reinstate_epe_cache.g_pilepe_inst_tbl;

9169: --To reinstate
9170: --
9171: l_valid_count number;
9172: l_valid_pen_table g_bckdt_pen_tbl;
9173: l_valid_epe_table ben_reinstate_epe_cache.g_pilepe_inst_tbl;
9174: --
9175: --To report non-reinstating results info
9176: --
9177: l_invalid_pen_table g_bckdt_pen_tbl;

Line 9179: l_invalid_epe_table ben_reinstate_epe_cache.g_pilepe_inst_tbl;

9175: --To report non-reinstating results info
9176: --
9177: l_invalid_pen_table g_bckdt_pen_tbl;
9178: l_invalid_count number;
9179: l_invalid_epe_table ben_reinstate_epe_cache.g_pilepe_inst_tbl;
9180: --
9181: l_pgm_table g_pgm_table;
9182: l_pl_table g_pl_table;
9183: l_enrt_table g_enrt_table;

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

9406: --Get the current per_in_ler info
9407: --
9408: l_bckdt_pilepe_inst_row := l_bckdt_pilepe_table(l_bckdt_epe);
9409: --
9410: hr_utility.set_location('Calling ben_reinstate_epe_cache.get_pilcobjepe_dets',100);
9411: hr_utility.set_location('pgm '||l_bckdt_pen_table(l_bckdt_epe).pgm_id,100);
9412: hr_utility.set_location('pln '||l_bckdt_pen_table(l_bckdt_epe).pl_id,100);
9413: hr_utility.set_location('oipl '||l_bckdt_pen_table(l_bckdt_epe).oipl_id,100);
9414: --

Line 9415: ben_reinstate_epe_cache.get_pilcobjepe_dets(

9411: hr_utility.set_location('pgm '||l_bckdt_pen_table(l_bckdt_epe).pgm_id,100);
9412: hr_utility.set_location('pln '||l_bckdt_pen_table(l_bckdt_epe).pl_id,100);
9413: hr_utility.set_location('oipl '||l_bckdt_pen_table(l_bckdt_epe).oipl_id,100);
9414: --
9415: ben_reinstate_epe_cache.get_pilcobjepe_dets(
9416: p_per_in_ler_id => p_per_in_ler_id
9417: ,p_pgm_id => l_bckdt_pen_table(l_bckdt_epe).pgm_id
9418: ,p_pl_id => l_bckdt_pen_table(l_bckdt_epe).pl_id
9419: ,p_oipl_id => l_bckdt_pen_table(l_bckdt_epe).oipl_id

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

9479: --Get the current per_in_ler info
9480: --
9481: l_bckdt_pilepe_inst_row := l_bckdt_pilepe_table(l_bckdt_epe);
9482: --
9483: hr_utility.set_location(' Calling ben_reinstate_epe_cache.get_pilcobjepe_dets '||l_bckdt_pen_table(l_bckdt_epe).pgm_id
9484: ||' PLN '||l_bckdt_pen_table(l_bckdt_epe).pl_id||' OIPL '
9485: ||l_bckdt_pen_table(l_bckdt_epe).oipl_id,145);
9486: ben_reinstate_epe_cache.get_pilcobjepe_dets(
9487: p_per_in_ler_id => p_per_in_ler_id

Line 9486: ben_reinstate_epe_cache.get_pilcobjepe_dets(

9482: --
9483: hr_utility.set_location(' Calling ben_reinstate_epe_cache.get_pilcobjepe_dets '||l_bckdt_pen_table(l_bckdt_epe).pgm_id
9484: ||' PLN '||l_bckdt_pen_table(l_bckdt_epe).pl_id||' OIPL '
9485: ||l_bckdt_pen_table(l_bckdt_epe).oipl_id,145);
9486: ben_reinstate_epe_cache.get_pilcobjepe_dets(
9487: p_per_in_ler_id => p_per_in_ler_id
9488: ,p_pgm_id => l_bckdt_pen_table(l_bckdt_epe).pgm_id
9489: ,p_pl_id => l_bckdt_pen_table(l_bckdt_epe).pl_id
9490: ,p_oipl_id => l_bckdt_pen_table(l_bckdt_epe).oipl_id

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

9549: --Get the current per_in_ler info
9550: --
9551: l_bckdt_pilepe_inst_row := l_bckdt_pilepe_table(l_bckdt_epe);
9552: --
9553: hr_utility.set_location(' Calling ben_reinstate_epe_cache.get_pilcobjepe_dets '||l_bckdt_pen_table(l_bckdt_epe).pgm_id
9554: ||' PLN '||l_bckdt_pen_table(l_bckdt_epe).pl_id||' OIPL '
9555: ||l_bckdt_pen_table(l_bckdt_epe).oipl_id,175);
9556: --
9557: ben_reinstate_epe_cache.get_pilcobjepe_dets(

Line 9557: ben_reinstate_epe_cache.get_pilcobjepe_dets(

9553: hr_utility.set_location(' Calling ben_reinstate_epe_cache.get_pilcobjepe_dets '||l_bckdt_pen_table(l_bckdt_epe).pgm_id
9554: ||' PLN '||l_bckdt_pen_table(l_bckdt_epe).pl_id||' OIPL '
9555: ||l_bckdt_pen_table(l_bckdt_epe).oipl_id,175);
9556: --
9557: ben_reinstate_epe_cache.get_pilcobjepe_dets(
9558: p_per_in_ler_id => p_per_in_ler_id
9559: ,p_pgm_id => l_bckdt_pen_table(l_bckdt_epe).pgm_id
9560: ,p_pl_id => l_bckdt_pen_table(l_bckdt_epe).pl_id
9561: ,p_oipl_id => l_bckdt_pen_table(l_bckdt_epe).oipl_id