DBA Data[Home] [Help]

APPS.BEN_ELECTION_INFORMATION dependencies on BEN_GLOBAL_ENRT

Line 238: Modified calls to ben_global_enrt.

234: should be less than or equal to rate
235: end date in election_rate_info...
236: 17-May-01 maagrawa 115.99 Removed use of ben_comp_object and
237: replaced with ben_cobj_cache.
238: Modified calls to ben_global_enrt.
239: 29-May-01 kmahendr 115.100 Modified cursor c_prv2 Bug#1771887
240: 18-Jun-01 kmahendr 115.101 Bug#1830930-rate end date code is enterable
241: and rate start dt is not passed thro PUI then
242: end date is arrived as rate start dt - 1

Line 1156: l_global_asg_rec ben_global_enrt.g_global_asg_rec_type;

1152: l_prnt_ann_val number;
1153: l_prnt_ann_rt varchar2(1) := 'N';
1154: l_rounded_value number;
1155: l_cal_val_in number ;
1156: l_global_asg_rec ben_global_enrt.g_global_asg_rec_type;
1157: l_global_pen_rec ben_prtt_enrt_rslt_f%rowtype;
1158: l_ele_entry_val_cd varchar2(30);
1159: l_new_assignment_id number;
1160: l_new_payroll_id number;

Line 1791: l_global_pil_rec ben_global_enrt.g_global_pil_rec_type;

1787: l_cmcd_dummy number;
1788: --END GEVITY
1789: l_fonm_cvg_strt_dt date;
1790: l_input_value_id number;
1791: l_global_pil_rec ben_global_enrt.g_global_pil_rec_type;
1792: l_unrestricted varchar2(1) := 'N';
1793: l_compute_val number; --
1794: l_rt_val_param number; --| 5259005 -- New vars to hold p_rt_val, p_ann_rt_val
1795: l_ann_rt_val_param number; --|

Line 1812: ben_global_enrt.get_pil -- per in ler

1808: open c_ler_id;
1809: fetch c_ler_id into l_ler_id;
1810: close c_ler_id;
1811:
1812: ben_global_enrt.get_pil -- per in ler
1813: (p_per_in_ler_id => p_per_in_ler_id
1814: ,p_global_pil_rec => l_global_pil_rec);
1815:
1816: l_lf_evt_ocrd_dt := l_global_pil_rec.lf_evt_ocrd_dt;

Line 2007: ben_global_enrt.get_pen -- result

2003: end if;
2004: --
2005: -- Get result information
2006: --
2007: ben_global_enrt.get_pen -- result
2008: (p_prtt_enrt_rslt_id => p_prtt_enrt_rslt_id
2009: ,p_effective_date => p_effective_date
2010: ,p_global_pen_rec => l_global_pen_rec);
2011:

Line 4766: l_global_epe_rec ben_global_enrt.g_global_epe_rec_type;

4762: l_enrt_ovrid_thru_dt date;
4763: l_enrt_cvg_thru_dt date;
4764: l_enrt_cvg_strt_dt date;
4765:
4766: l_global_epe_rec ben_global_enrt.g_global_epe_rec_type;
4767: l_global_pel_rec ben_global_enrt.g_global_pel_rec_type;
4768: l_global_pil_rec ben_global_enrt.g_global_pil_rec_type;
4769: l_global_enb_rec ben_global_enrt.g_global_enb_rec_type;
4770: l_global_pen_rec ben_prtt_enrt_rslt_f%rowtype;

Line 4767: l_global_pel_rec ben_global_enrt.g_global_pel_rec_type;

4763: l_enrt_cvg_thru_dt date;
4764: l_enrt_cvg_strt_dt date;
4765:
4766: l_global_epe_rec ben_global_enrt.g_global_epe_rec_type;
4767: l_global_pel_rec ben_global_enrt.g_global_pel_rec_type;
4768: l_global_pil_rec ben_global_enrt.g_global_pil_rec_type;
4769: l_global_enb_rec ben_global_enrt.g_global_enb_rec_type;
4770: l_global_pen_rec ben_prtt_enrt_rslt_f%rowtype;
4771:

Line 4768: l_global_pil_rec ben_global_enrt.g_global_pil_rec_type;

4764: l_enrt_cvg_strt_dt date;
4765:
4766: l_global_epe_rec ben_global_enrt.g_global_epe_rec_type;
4767: l_global_pel_rec ben_global_enrt.g_global_pel_rec_type;
4768: l_global_pil_rec ben_global_enrt.g_global_pil_rec_type;
4769: l_global_enb_rec ben_global_enrt.g_global_enb_rec_type;
4770: l_global_pen_rec ben_prtt_enrt_rslt_f%rowtype;
4771:
4772: l_xenrt_cvg_strt_dt date;

Line 4769: l_global_enb_rec ben_global_enrt.g_global_enb_rec_type;

4765:
4766: l_global_epe_rec ben_global_enrt.g_global_epe_rec_type;
4767: l_global_pel_rec ben_global_enrt.g_global_pel_rec_type;
4768: l_global_pil_rec ben_global_enrt.g_global_pil_rec_type;
4769: l_global_enb_rec ben_global_enrt.g_global_enb_rec_type;
4770: l_global_pen_rec ben_prtt_enrt_rslt_f%rowtype;
4771:
4772: l_xenrt_cvg_strt_dt date;
4773: l_xenrt_cvg_strt_dt_cd varchar2(30);

Line 5488: ben_global_enrt.get_epe -- choice

5484: g_elig_per_elctbl_chc_id:=p_elig_per_elctbl_chc_id;
5485: --
5486: -- begin by getting the choice, bnft, per in ler and pil popl information
5487: --
5488: ben_global_enrt.get_epe -- choice
5489: (p_elig_per_elctbl_chc_id => p_elig_per_elctbl_chc_id
5490: ,p_global_epe_rec => l_global_epe_rec);
5491:
5492: ben_global_enrt.get_pel -- pil popl

Line 5492: ben_global_enrt.get_pel -- pil popl

5488: ben_global_enrt.get_epe -- choice
5489: (p_elig_per_elctbl_chc_id => p_elig_per_elctbl_chc_id
5490: ,p_global_epe_rec => l_global_epe_rec);
5491:
5492: ben_global_enrt.get_pel -- pil popl
5493: (p_pil_elctbl_chc_popl_id => l_global_epe_rec.pil_elctbl_chc_popl_id
5494: ,p_global_pel_rec => l_global_pel_rec);
5495:
5496: ben_global_enrt.get_pil -- per in ler

Line 5496: ben_global_enrt.get_pil -- per in ler

5492: ben_global_enrt.get_pel -- pil popl
5493: (p_pil_elctbl_chc_popl_id => l_global_epe_rec.pil_elctbl_chc_popl_id
5494: ,p_global_pel_rec => l_global_pel_rec);
5495:
5496: ben_global_enrt.get_pil -- per in ler
5497: (p_per_in_ler_id => l_global_epe_rec.per_in_ler_id
5498: ,p_global_pil_rec => l_global_pil_rec);
5499:
5500: --Bug#5099296

Line 5502: ben_global_enrt.get_pen

5498: ,p_global_pil_rec => l_global_pil_rec);
5499:
5500: --Bug#5099296
5501: if l_global_epe_rec.prtt_enrt_rslt_id is not null then
5502: ben_global_enrt.get_pen
5503: (p_prtt_enrt_rslt_id => l_global_epe_rec.prtt_enrt_rslt_id
5504: ,p_effective_date => p_effective_date
5505: ,p_global_pen_rec => l_global_pen_rec);
5506: end if;

Line 5510: ben_global_enrt.get_enb -- enrt bnft

5506: end if;
5507: --Bug#5099296
5508:
5509: if p_enrt_bnft_id is not null then
5510: ben_global_enrt.get_enb -- enrt bnft
5511: (p_enrt_bnft_id => p_enrt_bnft_id
5512: ,p_global_enb_rec => l_global_enb_rec);
5513: else
5514: ben_global_enrt.clear_enb

Line 5514: ben_global_enrt.clear_enb

5510: ben_global_enrt.get_enb -- enrt bnft
5511: (p_enrt_bnft_id => p_enrt_bnft_id
5512: ,p_global_enb_rec => l_global_enb_rec);
5513: else
5514: ben_global_enrt.clear_enb
5515: (p_global_enb_rec => l_global_enb_rec);
5516: end if;
5517:
5518: if l_global_epe_rec.oipl_id is not null and p_enrt_bnft_id is null then

Line 5674: ben_global_enrt.get_pen -- result

5670: );
5671: --
5672: -- reload enrollment data
5673: --
5674: ben_global_enrt.get_pen -- result
5675: (p_prtt_enrt_rslt_id => l_global_epe_rec.prtt_enrt_rslt_id
5676: ,p_effective_date => p_effective_date
5677: ,p_global_pen_rec => l_global_pen_rec);
5678: --

Line 7576: ben_global_enrt.get_enb -- enrt bnft --CHANGE TO RELOAD_ENB if it's created.

7572: p_prtt_enrt_rslt_id:=l_prtt_enrt_rslt_id;
7573:
7574: -- update, create and delete enrolloment may all change the enrt_bnft row.
7575: if p_enrt_bnft_id is not null then
7576: ben_global_enrt.get_enb -- enrt bnft --CHANGE TO RELOAD_ENB if it's created.
7577: (p_enrt_bnft_id => p_enrt_bnft_id
7578: ,p_global_enb_rec => l_global_enb_rec);
7579: else ben_global_enrt.clear_enb
7580: (p_global_enb_rec => l_global_enb_rec);

Line 7579: else ben_global_enrt.clear_enb

7575: if p_enrt_bnft_id is not null then
7576: ben_global_enrt.get_enb -- enrt bnft --CHANGE TO RELOAD_ENB if it's created.
7577: (p_enrt_bnft_id => p_enrt_bnft_id
7578: ,p_global_enb_rec => l_global_enb_rec);
7579: else ben_global_enrt.clear_enb
7580: (p_global_enb_rec => l_global_enb_rec);
7581: end if;
7582:
7583: -- update benefit fk in enrt_bnft

Line 8016: ben_global_enrt.clear_enb

8012: --
8013: g_enrt_bnft_id:=null;
8014: g_bnft_val:=null;
8015: g_elig_per_elctbl_chc_id:=null;
8016: ben_global_enrt.clear_enb
8017: (p_global_enb_rec => l_global_enb_rec);
8018: --
8019: -- When in validation only mode raise the Validate_Enabled exception
8020: --