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 1010: l_global_asg_rec ben_global_enrt.g_global_asg_rec_type;

1006: l_prnt_ann_val number;
1007: l_prnt_ann_rt varchar2(1) := 'N';
1008: l_rounded_value number;
1009: l_cal_val_in number ;
1010: l_global_asg_rec ben_global_enrt.g_global_asg_rec_type;
1011: l_global_pen_rec ben_prtt_enrt_rslt_f%rowtype;
1012: l_ele_entry_val_cd varchar2(30);
1013: l_new_assignment_id number;
1014: l_new_payroll_id number;

Line 1460: l_global_pil_rec ben_global_enrt.g_global_pil_rec_type;

1456: l_cmcd_dummy number;
1457: --END GEVITY
1458: l_fonm_cvg_strt_dt date;
1459: l_input_value_id number;
1460: l_global_pil_rec ben_global_enrt.g_global_pil_rec_type;
1461: l_unrestricted varchar2(1) := 'N';
1462: l_compute_val number; --
1463: l_rt_val_param number; --| 5259005 -- New vars to hold p_rt_val, p_ann_rt_val
1464: l_ann_rt_val_param number; --|

Line 1476: ben_global_enrt.get_pil -- per in ler

1472: hr_utility.set_location('p_prtt_rt_val_id:'||p_prtt_rt_val_id,5);
1473: hr_utility.set_location('p_per_in_ler_id:'||p_per_in_ler_id,5);
1474: end if;
1475: --
1476: ben_global_enrt.get_pil -- per in ler
1477: (p_per_in_ler_id => p_per_in_ler_id
1478: ,p_global_pil_rec => l_global_pil_rec);
1479:
1480: l_lf_evt_ocrd_dt := l_global_pil_rec.lf_evt_ocrd_dt;

Line 1650: ben_global_enrt.get_pen -- result

1646: end if;
1647: --
1648: -- Get result information
1649: --
1650: ben_global_enrt.get_pen -- result
1651: (p_prtt_enrt_rslt_id => p_prtt_enrt_rslt_id
1652: ,p_effective_date => p_effective_date
1653: ,p_global_pen_rec => l_global_pen_rec);
1654:

Line 4268: l_global_epe_rec ben_global_enrt.g_global_epe_rec_type;

4264: l_enrt_ovrid_thru_dt date;
4265: l_enrt_cvg_thru_dt date;
4266: l_enrt_cvg_strt_dt date;
4267:
4268: l_global_epe_rec ben_global_enrt.g_global_epe_rec_type;
4269: l_global_pel_rec ben_global_enrt.g_global_pel_rec_type;
4270: l_global_pil_rec ben_global_enrt.g_global_pil_rec_type;
4271: l_global_enb_rec ben_global_enrt.g_global_enb_rec_type;
4272: l_global_pen_rec ben_prtt_enrt_rslt_f%rowtype;

Line 4269: l_global_pel_rec ben_global_enrt.g_global_pel_rec_type;

4265: l_enrt_cvg_thru_dt date;
4266: l_enrt_cvg_strt_dt date;
4267:
4268: l_global_epe_rec ben_global_enrt.g_global_epe_rec_type;
4269: l_global_pel_rec ben_global_enrt.g_global_pel_rec_type;
4270: l_global_pil_rec ben_global_enrt.g_global_pil_rec_type;
4271: l_global_enb_rec ben_global_enrt.g_global_enb_rec_type;
4272: l_global_pen_rec ben_prtt_enrt_rslt_f%rowtype;
4273:

Line 4270: l_global_pil_rec ben_global_enrt.g_global_pil_rec_type;

4266: l_enrt_cvg_strt_dt date;
4267:
4268: l_global_epe_rec ben_global_enrt.g_global_epe_rec_type;
4269: l_global_pel_rec ben_global_enrt.g_global_pel_rec_type;
4270: l_global_pil_rec ben_global_enrt.g_global_pil_rec_type;
4271: l_global_enb_rec ben_global_enrt.g_global_enb_rec_type;
4272: l_global_pen_rec ben_prtt_enrt_rslt_f%rowtype;
4273:
4274: l_xenrt_cvg_strt_dt date;

Line 4271: l_global_enb_rec ben_global_enrt.g_global_enb_rec_type;

4267:
4268: l_global_epe_rec ben_global_enrt.g_global_epe_rec_type;
4269: l_global_pel_rec ben_global_enrt.g_global_pel_rec_type;
4270: l_global_pil_rec ben_global_enrt.g_global_pil_rec_type;
4271: l_global_enb_rec ben_global_enrt.g_global_enb_rec_type;
4272: l_global_pen_rec ben_prtt_enrt_rslt_f%rowtype;
4273:
4274: l_xenrt_cvg_strt_dt date;
4275: l_xenrt_cvg_strt_dt_cd varchar2(30);

Line 4704: ben_global_enrt.get_epe -- choice

4700: g_elig_per_elctbl_chc_id:=p_elig_per_elctbl_chc_id;
4701: --
4702: -- begin by getting the choice, bnft, per in ler and pil popl information
4703: --
4704: ben_global_enrt.get_epe -- choice
4705: (p_elig_per_elctbl_chc_id => p_elig_per_elctbl_chc_id
4706: ,p_global_epe_rec => l_global_epe_rec);
4707:
4708: ben_global_enrt.get_pel -- pil popl

Line 4708: ben_global_enrt.get_pel -- pil popl

4704: ben_global_enrt.get_epe -- choice
4705: (p_elig_per_elctbl_chc_id => p_elig_per_elctbl_chc_id
4706: ,p_global_epe_rec => l_global_epe_rec);
4707:
4708: ben_global_enrt.get_pel -- pil popl
4709: (p_pil_elctbl_chc_popl_id => l_global_epe_rec.pil_elctbl_chc_popl_id
4710: ,p_global_pel_rec => l_global_pel_rec);
4711:
4712: ben_global_enrt.get_pil -- per in ler

Line 4712: ben_global_enrt.get_pil -- per in ler

4708: ben_global_enrt.get_pel -- pil popl
4709: (p_pil_elctbl_chc_popl_id => l_global_epe_rec.pil_elctbl_chc_popl_id
4710: ,p_global_pel_rec => l_global_pel_rec);
4711:
4712: ben_global_enrt.get_pil -- per in ler
4713: (p_per_in_ler_id => l_global_epe_rec.per_in_ler_id
4714: ,p_global_pil_rec => l_global_pil_rec);
4715:
4716: --Bug#5099296

Line 4718: ben_global_enrt.get_pen

4714: ,p_global_pil_rec => l_global_pil_rec);
4715:
4716: --Bug#5099296
4717: if l_global_epe_rec.prtt_enrt_rslt_id is not null then
4718: ben_global_enrt.get_pen
4719: (p_prtt_enrt_rslt_id => l_global_epe_rec.prtt_enrt_rslt_id
4720: ,p_effective_date => p_effective_date
4721: ,p_global_pen_rec => l_global_pen_rec);
4722: end if;

Line 4726: ben_global_enrt.get_enb -- enrt bnft

4722: end if;
4723: --Bug#5099296
4724:
4725: if p_enrt_bnft_id is not null then
4726: ben_global_enrt.get_enb -- enrt bnft
4727: (p_enrt_bnft_id => p_enrt_bnft_id
4728: ,p_global_enb_rec => l_global_enb_rec);
4729: else
4730: ben_global_enrt.clear_enb

Line 4730: ben_global_enrt.clear_enb

4726: ben_global_enrt.get_enb -- enrt bnft
4727: (p_enrt_bnft_id => p_enrt_bnft_id
4728: ,p_global_enb_rec => l_global_enb_rec);
4729: else
4730: ben_global_enrt.clear_enb
4731: (p_global_enb_rec => l_global_enb_rec);
4732: end if;
4733:
4734: if l_global_epe_rec.oipl_id is not null and p_enrt_bnft_id is null then

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

6457: p_prtt_enrt_rslt_id:=l_prtt_enrt_rslt_id;
6458:
6459: -- update, create and delete enrolloment may all change the enrt_bnft row.
6460: if p_enrt_bnft_id is not null then
6461: ben_global_enrt.get_enb -- enrt bnft --CHANGE TO RELOAD_ENB if it's created.
6462: (p_enrt_bnft_id => p_enrt_bnft_id
6463: ,p_global_enb_rec => l_global_enb_rec);
6464: else ben_global_enrt.clear_enb
6465: (p_global_enb_rec => l_global_enb_rec);

Line 6464: else ben_global_enrt.clear_enb

6460: if p_enrt_bnft_id is not null then
6461: ben_global_enrt.get_enb -- enrt bnft --CHANGE TO RELOAD_ENB if it's created.
6462: (p_enrt_bnft_id => p_enrt_bnft_id
6463: ,p_global_enb_rec => l_global_enb_rec);
6464: else ben_global_enrt.clear_enb
6465: (p_global_enb_rec => l_global_enb_rec);
6466: end if;
6467:
6468: -- update benefit fk in enrt_bnft

Line 6891: ben_global_enrt.clear_enb

6887: --
6888: g_enrt_bnft_id:=null;
6889: g_bnft_val:=null;
6890: g_elig_per_elctbl_chc_id:=null;
6891: ben_global_enrt.clear_enb
6892: (p_global_enb_rec => l_global_enb_rec);
6893: --
6894: -- When in validation only mode raise the Validate_Enabled exception
6895: --