DBA Data[Home] [Help]

APPS.BEN_PERSON_OBJECT dependencies on PER_ADDRESSES

Line 622: procedure set_object(p_rec in out NOCOPY per_addresses%rowtype) is

618: -- 115.23 set cache entry at current index location
619: g_cache_pps_rec(l_index):=p_rec;
620: end set_object;
621: --
622: procedure set_object(p_rec in out NOCOPY per_addresses%rowtype) is
623: --
624: l_proc varchar2(80) := g_package||'set_object adr';
625: l_index pls_integer;
626: --

Line 1756: p_rec in out nocopy per_addresses%rowtype) is

1752: procedure set_pad_object
1753: (p_person_id in number,
1754: p_business_group_id in number,
1755: p_effective_date in date,
1756: p_rec in out nocopy per_addresses%rowtype) is
1757: --
1758: l_proc varchar2(80) := g_package||'set_pad_object';
1759: --
1760: cursor c1 is

Line 1762: from per_addresses pad

1758: l_proc varchar2(80) := g_package||'set_pad_object';
1759: --
1760: cursor c1 is
1761: select pad.*
1762: from per_addresses pad
1763: where pad.person_id = p_person_id
1764: and pad.business_group_id = p_business_group_id
1765: and pad.primary_flag = 'Y'
1766: and p_effective_date

Line 1770: --l_rec per_addresses%rowtype;

1766: and p_effective_date
1767: between pad.date_from
1768: and nvl(pad.date_to,p_effective_date);
1769: --
1770: --l_rec per_addresses%rowtype;
1771: --115.23 - comment out unneeded record
1772: --
1773: begin
1774: --

Line 2878: p_rec in out nocopy per_addresses%rowtype) is

2874: --
2875: end get_object;
2876: --
2877: procedure get_object(p_person_id in number,
2878: p_rec in out nocopy per_addresses%rowtype) is
2879: --
2880: l_proc varchar2(80) := g_package||'get_object adr';
2881: l_index pls_integer;
2882: --l_not_hash_found boolean;

Line 2884: --l_rec per_addresses%rowtype;

2880: l_proc varchar2(80) := g_package||'get_object adr';
2881: l_index pls_integer;
2882: --l_not_hash_found boolean;
2883: l_env ben_env_object.g_global_env_rec_type;
2884: --l_rec per_addresses%rowtype;
2885: -- FONM
2886: l_effective_date date;
2887: --
2888: --

Line 3803: l_cache_last_pad_rec per_addresses%rowtype;

3799: l_cache_last_ass_rec per_all_assignments_f%rowtype;
3800: l_cache_last_benass_rec per_all_assignments_f%rowtype;
3801: l_cache_last_ast_rec per_assignment_status_types%rowtype;
3802: l_cache_last_pps_rec per_periods_of_service%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;

Line 3866: l_cache_last_pad_rec per_addresses%rowtype;

3862: l_cache_last_ass_rec per_all_assignments_f%rowtype;
3863: l_cache_last_benass_rec per_all_assignments_f%rowtype;
3864: l_cache_last_ast_rec per_assignment_status_types%rowtype;
3865: l_cache_last_pps_rec per_periods_of_service%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;