DBA Data[Home] [Help]

APPS.BEN_PERSON_OBJECT dependencies on BEN_PER_BNFTS_BAL_F

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

467: -- 115.23 set cache entry at current index location
468: g_cache_pil_rec(l_index):=p_rec;
469: end set_object;
470: --
471: procedure set_object(p_rec in out NOCOPY ben_per_bnfts_bal_f%rowtype) is
472: --
473: l_proc varchar2(80) := g_package||'set_object bbb';
474: l_index pls_integer;
475: --

Line 1645: from ben_per_bnfts_bal_f bal

1641: l_proc varchar2(80) := g_package||'set_bal_object';
1642: --
1643: cursor c1 is
1644: select bal.*
1645: from ben_per_bnfts_bal_f bal
1646: where bal.person_id = p_person_id
1647: and bal.business_group_id = p_business_group_id;
1648: --
1649: l_rec ben_per_bnfts_bal_f%rowtype;

Line 1649: l_rec ben_per_bnfts_bal_f%rowtype;

1645: from ben_per_bnfts_bal_f bal
1646: where bal.person_id = p_person_id
1647: and bal.business_group_id = p_business_group_id;
1648: --
1649: l_rec ben_per_bnfts_bal_f%rowtype;
1650: l_bal_per_rec ben_cache.g_cache_lookup;
1651: l_num_recs number := 0;
1652: --
1653: begin

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

2878: --
2879: procedure get_object(p_person_id in number,
2880: p_bnfts_bal_id in number,
2881: p_effective_date in date,
2882: p_rec in out nocopy ben_per_bnfts_bal_f%rowtype) is
2883: --
2884: l_proc varchar2(80) := g_package||'get_object bbb';
2885: l_index pls_integer;
2886: --l_not_hash_found boolean;

Line 2888: --l_rec ben_per_bnfts_bal_f%rowtype;

2884: l_proc varchar2(80) := g_package||'get_object bbb';
2885: l_index pls_integer;
2886: --l_not_hash_found boolean;
2887: l_env ben_env_object.g_global_env_rec_type;
2888: --l_rec ben_per_bnfts_bal_f%rowtype;
2889: -- FONM
2890: l_effective_date date;
2891: --
2892: --

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

3397: procedure get_bal_per_object
3398: (p_person_id in number,
3399: p_bnfts_bal_id in number,
3400: p_effective_date in date,
3401: p_rec in out nocopy ben_per_bnfts_bal_f%rowtype) is
3402: --
3403: l_proc varchar2(80) := g_package||'get_bal_per_object';
3404: l_index pls_integer;
3405: l_count pls_integer;

Line 3408: l_rec ben_per_bnfts_bal_f%rowtype;

3404: l_index pls_integer;
3405: l_count pls_integer;
3406: --l_not_hash_found boolean;
3407: l_env ben_env_object.g_global_env_rec_type;
3408: l_rec ben_per_bnfts_bal_f%rowtype;
3409: l_start_index pls_integer;
3410: l_end_index pls_integer;
3411: --
3412: begin

Line 3652: l_cache_last_bal_rec ben_per_bnfts_bal_f%rowtype;

3648: l_cache_last_pad_rec per_addresses%rowtype;
3649: l_cache_last_pil_rec ben_per_in_ler%rowtype;
3650: l_cache_last_date_rec g_person_date_info_rec;
3651: l_cache_last_fte_rec g_person_fte_info_rec;
3652: l_cache_last_bal_rec ben_per_bnfts_bal_f%rowtype;
3653: l_cache_last_bnb_rec ben_bnfts_bal_f%rowtype;
3654: l_cache_last_hsc_rec hr_soft_coding_keyflex%rowtype;
3655: --
3656: begin

Line 3715: l_cache_last_bal_rec ben_per_bnfts_bal_f%rowtype;

3711: l_cache_last_pad_rec per_addresses%rowtype;
3712: l_cache_last_pil_rec ben_per_in_ler%rowtype;
3713: l_cache_last_date_rec g_person_date_info_rec;
3714: l_cache_last_fte_rec g_person_fte_info_rec;
3715: l_cache_last_bal_rec ben_per_bnfts_bal_f%rowtype;
3716: l_cache_last_bnb_rec ben_bnfts_bal_f%rowtype;
3717: l_cache_last_hsc_rec hr_soft_coding_keyflex%rowtype;
3718: --
3719: begin