DBA Data[Home] [Help]

APPS.BEN_PERSON_OBJECT dependencies on BEN_PER_IN_LER

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

445: -- 115.23 set cache entry at current index location
446: g_cache_aei_rec(l_index):=p_rec;
447: end set_object;
448: --
449: procedure set_object(p_rec in out NOCOPY ben_per_in_ler%rowtype) is
450: --
451: l_proc varchar2(80) := g_package||'set_object pil';
452: l_index pls_integer;
453: --

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

1272: p_business_group_id in number,
1273: p_effective_date in date,
1274: -- added a per_in_ler_id for unrestricted enhancement
1275: p_per_in_ler_id in number default null,
1276: p_rec in out nocopy ben_per_in_ler%rowtype) is
1277: --
1278: l_proc varchar2(80) := g_package||'set_pil_object';
1279: --
1280: cursor c1 is

Line 1282: from ben_per_in_ler pil

1278: l_proc varchar2(80) := g_package||'set_pil_object';
1279: --
1280: cursor c1 is
1281: select pil.*
1282: from ben_per_in_ler pil
1283: where pil.person_id = p_person_id
1284: and pil.business_group_id = p_business_group_id
1285: and pil.per_in_ler_stat_cd = 'STRTD'
1286: -- added per_in_ler_id for unrestricted enhancement

Line 1289: --l_rec ben_per_in_ler%rowtype;

1285: and pil.per_in_ler_stat_cd = 'STRTD'
1286: -- added per_in_ler_id for unrestricted enhancement
1287: and pil.per_in_ler_id = nvl(p_per_in_ler_id,pil.per_in_ler_id);
1288: --
1289: --l_rec ben_per_in_ler%rowtype;
1290: --115.23 - comment out unneeded record
1291: --
1292: begin
1293: --

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

2796: --
2797: procedure get_object(p_person_id in number,
2798: -- added per_in_ler_id for unrestricted enhancement
2799: p_per_in_ler_id in number default null,
2800: p_rec in out nocopy ben_per_in_ler%rowtype) is
2801: --
2802: l_proc varchar2(80) := g_package||'get_object pil';
2803: l_index pls_integer;
2804: --l_not_hash_found boolean;

Line 2806: --l_rec ben_per_in_ler%rowtype;

2802: l_proc varchar2(80) := g_package||'get_object pil';
2803: l_index pls_integer;
2804: --l_not_hash_found boolean;
2805: l_env ben_env_object.g_global_env_rec_type;
2806: --l_rec ben_per_in_ler%rowtype;
2807: -- FONM
2808: l_effective_date date;
2809: --
2810: --

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

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