DBA Data[Home] [Help]

APPS.BEN_PERSON_OBJECT dependencies on BEN_PER_BNFTS_BAL_F

Line 493: procedure set_object(p_rec in out NOCOPY ben_per_bnfts_bal_f%rowtype) is

489: -- 115.23 set cache entry at current index location
490: g_cache_pil_rec(l_index):=p_rec;
491: end set_object;
492: --
493: procedure set_object(p_rec in out NOCOPY ben_per_bnfts_bal_f%rowtype) is
494: --
495: l_proc varchar2(80) := g_package||'set_object bbb';
496: l_index pls_integer;
497: --

Line 1699: from ben_per_bnfts_bal_f bal

1695: l_proc varchar2(80) := g_package||'set_bal_object';
1696: --
1697: cursor c1 is
1698: select bal.*
1699: from ben_per_bnfts_bal_f bal
1700: where bal.person_id = p_person_id
1701: and bal.business_group_id = p_business_group_id;
1702: --
1703: l_rec ben_per_bnfts_bal_f%rowtype;

Line 1703: l_rec ben_per_bnfts_bal_f%rowtype;

1699: from ben_per_bnfts_bal_f bal
1700: where bal.person_id = p_person_id
1701: and bal.business_group_id = p_business_group_id;
1702: --
1703: l_rec ben_per_bnfts_bal_f%rowtype;
1704: l_bal_per_rec ben_cache.g_cache_lookup;
1705: l_num_recs number := 0;
1706: --
1707: begin

Line 3032: p_rec in out nocopy ben_per_bnfts_bal_f%rowtype) is

3028: --
3029: procedure get_object(p_person_id in number,
3030: p_bnfts_bal_id in number,
3031: p_effective_date in date,
3032: p_rec in out nocopy ben_per_bnfts_bal_f%rowtype) is
3033: --
3034: l_proc varchar2(80) := g_package||'get_object bbb';
3035: l_index pls_integer;
3036: --l_not_hash_found boolean;

Line 3038: --l_rec ben_per_bnfts_bal_f%rowtype;

3034: l_proc varchar2(80) := g_package||'get_object bbb';
3035: l_index pls_integer;
3036: --l_not_hash_found boolean;
3037: l_env ben_env_object.g_global_env_rec_type;
3038: --l_rec ben_per_bnfts_bal_f%rowtype;
3039: -- FONM
3040: l_effective_date date;
3041: --
3042: --

Line 3556: p_rec in out nocopy ben_per_bnfts_bal_f%rowtype) is

3552: procedure get_bal_per_object
3553: (p_person_id in number,
3554: p_bnfts_bal_id in number,
3555: p_effective_date in date,
3556: p_rec in out nocopy ben_per_bnfts_bal_f%rowtype) is
3557: --
3558: l_proc varchar2(80) := g_package||'get_bal_per_object';
3559: l_index pls_integer;
3560: l_count pls_integer;

Line 3563: l_rec ben_per_bnfts_bal_f%rowtype;

3559: l_index pls_integer;
3560: l_count pls_integer;
3561: --l_not_hash_found boolean;
3562: l_env ben_env_object.g_global_env_rec_type;
3563: l_rec ben_per_bnfts_bal_f%rowtype;
3564: l_start_index pls_integer;
3565: l_end_index pls_integer;
3566: --
3567: begin

Line 3807: l_cache_last_bal_rec ben_per_bnfts_bal_f%rowtype;

3803: l_cache_last_pad_rec per_addresses%rowtype;
3804: l_cache_last_pil_rec ben_per_in_ler%rowtype;
3805: l_cache_last_date_rec g_person_date_info_rec;
3806: l_cache_last_fte_rec g_person_fte_info_rec;
3807: l_cache_last_bal_rec ben_per_bnfts_bal_f%rowtype;
3808: l_cache_last_bnb_rec ben_bnfts_bal_f%rowtype;
3809: l_cache_last_hsc_rec hr_soft_coding_keyflex%rowtype;
3810: --
3811: begin

Line 3870: l_cache_last_bal_rec ben_per_bnfts_bal_f%rowtype;

3866: l_cache_last_pad_rec per_addresses%rowtype;
3867: l_cache_last_pil_rec ben_per_in_ler%rowtype;
3868: l_cache_last_date_rec g_person_date_info_rec;
3869: l_cache_last_fte_rec g_person_fte_info_rec;
3870: l_cache_last_bal_rec ben_per_bnfts_bal_f%rowtype;
3871: l_cache_last_bnb_rec ben_bnfts_bal_f%rowtype;
3872: l_cache_last_hsc_rec hr_soft_coding_keyflex%rowtype;
3873: --
3874: begin