APPS.BEN_PERSON_OBJECT dependencies on PER_ADDRESSES

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

596: -- 115.23 set cache entry at current index location
597: g_cache_pps_rec(l_index):=p_rec;
598: end set_object;
599: --
600: procedure set_object(p_rec in out NOCOPY per_addresses%rowtype) is
601: --
602: l_proc varchar2(80) := g_package||'set_object adr';
603: l_index pls_integer;
604: --

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

1698: procedure set_pad_object
1699: (p_person_id in number,
1700: p_business_group_id in number,
1701: p_effective_date in date,
1702: p_rec in out nocopy per_addresses%rowtype) is
1703: --
1704: l_proc varchar2(80) := g_package||'set_pad_object';
1705: --
1706: cursor c1 is

Line 1708: from per_addresses pad

1704: l_proc varchar2(80) := g_package||'set_pad_object';
1705: --
1706: cursor c1 is
1707: select pad.*
1708: from per_addresses pad
1709: where pad.person_id = p_person_id
1710: and pad.business_group_id = p_business_group_id
1711: and pad.primary_flag = 'Y'
1712: and p_effective_date

Line 1716: --l_rec per_addresses%rowtype;

1712: and p_effective_date
1713: between pad.date_from
1714: and nvl(pad.date_to,p_effective_date);
1715: --
1716: --l_rec per_addresses%rowtype;
1717: --115.23 - comment out unneeded record
1718: --
1719: begin
1720: --

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

2724: --
2725: end get_object;
2726: --
2727: procedure get_object(p_person_id in number,
2728: p_rec in out nocopy per_addresses%rowtype) is
2729: --
2730: l_proc varchar2(80) := g_package||'get_object adr';
2731: l_index pls_integer;
2732: --l_not_hash_found boolean;

Line 2734: --l_rec per_addresses%rowtype;

2730: l_proc varchar2(80) := g_package||'get_object adr';
2731: l_index pls_integer;
2732: --l_not_hash_found boolean;
2733: l_env ben_env_object.g_global_env_rec_type;
2734: --l_rec per_addresses%rowtype;
2735: -- FONM
2736: l_effective_date date;
2737: --
2738: --

Line 3648: l_cache_last_pad_rec per_addresses%rowtype;

3644: l_cache_last_ass_rec per_all_assignments_f%rowtype;
3645: l_cache_last_benass_rec per_all_assignments_f%rowtype;
3646: l_cache_last_ast_rec per_assignment_status_types%rowtype;
3647: l_cache_last_pps_rec per_periods_of_service%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;

Line 3711: l_cache_last_pad_rec per_addresses%rowtype;

3707: l_cache_last_ass_rec per_all_assignments_f%rowtype;
3708: l_cache_last_benass_rec per_all_assignments_f%rowtype;
3709: l_cache_last_ast_rec per_assignment_status_types%rowtype;
3710: l_cache_last_pps_rec per_periods_of_service%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;