DBA Data[Home] [Help]

APPS.BEN_PERSON_OBJECT dependencies on BEN_PER_IN_LER

Line 427: procedure set_object(p_rec in out NOCOPY ben_per_in_ler%rowtype) is

423: -- 115.23 set cache entry at current index location
424: g_cache_aei_rec(l_index):=p_rec;
425: end set_object;
426: --
427: procedure set_object(p_rec in out NOCOPY ben_per_in_ler%rowtype) is
428: --
429: l_proc varchar2(80) := g_package||'set_object pil';
430: l_index pls_integer;
431: --

Line 1245: p_rec in out nocopy ben_per_in_ler%rowtype) is

1241: p_business_group_id in number,
1242: p_effective_date in date,
1243: -- added a per_in_ler_id for unrestricted enhancement
1244: p_per_in_ler_id in number default null,
1245: p_rec in out nocopy ben_per_in_ler%rowtype) is
1246: --
1247: l_proc varchar2(80) := g_package||'set_pil_object';
1248: --
1249: cursor c1 is

Line 1251: from ben_per_in_ler pil

1247: l_proc varchar2(80) := g_package||'set_pil_object';
1248: --
1249: cursor c1 is
1250: select pil.*
1251: from ben_per_in_ler pil
1252: where pil.person_id = p_person_id
1253: and pil.business_group_id = p_business_group_id
1254: and pil.per_in_ler_stat_cd = 'STRTD'
1255: -- added per_in_ler_id for unrestricted enhancement

Line 1258: --l_rec ben_per_in_ler%rowtype;

1254: and pil.per_in_ler_stat_cd = 'STRTD'
1255: -- added per_in_ler_id for unrestricted enhancement
1256: and pil.per_in_ler_id = nvl(p_per_in_ler_id,pil.per_in_ler_id);
1257: --
1258: --l_rec ben_per_in_ler%rowtype;
1259: --115.23 - comment out unneeded record
1260: --
1261: begin
1262: --

Line 2650: p_rec in out nocopy ben_per_in_ler%rowtype) is

2646: --
2647: procedure get_object(p_person_id in number,
2648: -- added per_in_ler_id for unrestricted enhancement
2649: p_per_in_ler_id in number default null,
2650: p_rec in out nocopy ben_per_in_ler%rowtype) is
2651: --
2652: l_proc varchar2(80) := g_package||'get_object pil';
2653: l_index pls_integer;
2654: --l_not_hash_found boolean;

Line 2656: --l_rec ben_per_in_ler%rowtype;

2652: l_proc varchar2(80) := g_package||'get_object pil';
2653: l_index pls_integer;
2654: --l_not_hash_found boolean;
2655: l_env ben_env_object.g_global_env_rec_type;
2656: --l_rec ben_per_in_ler%rowtype;
2657: -- FONM
2658: l_effective_date date;
2659: --
2660: --

Line 3649: l_cache_last_pil_rec ben_per_in_ler%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;
3653: l_cache_last_bnb_rec ben_bnfts_bal_f%rowtype;

Line 3712: l_cache_last_pil_rec ben_per_in_ler%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;
3716: l_cache_last_bnb_rec ben_bnfts_bal_f%rowtype;