DBA Data[Home] [Help]

APPS.BEN_PERSON_OBJECT dependencies on BEN_ENV_OBJECT

Line 2206: l_env ben_env_object.g_global_env_rec_type;

2202: procedure get_object(p_person_id in number,
2203: p_rec in out nocopy per_all_people_f%rowtype) is
2204: l_proc varchar2(80) := g_package||'get_object per';
2205: l_index pls_integer;
2206: l_env ben_env_object.g_global_env_rec_type;
2207: --l_rec per_all_people_f%rowtype;
2208: --
2209: -- FONM
2210: l_effective_date date;

Line 2264: ben_env_object.get(p_rec => l_env);

2260: -- Defrag all person caches to grab back PGA memory
2261: --
2262: ben_person_object.defrag_caches;
2263: --
2264: ben_env_object.get(p_rec => l_env);
2265: --
2266: -- FONM
2267: --
2268: l_effective_date := nvl(ben_manage_life_events.g_fonm_rt_strt_dt,

Line 2289: l_env ben_env_object.g_global_env_rec_type;

2285: --
2286: l_proc varchar2(80) := g_package||'get_object bnb';
2287: l_index pls_integer;
2288: --l_not_hash_found boolean;
2289: l_env ben_env_object.g_global_env_rec_type;
2290: --l_rec ben_bnfts_bal_f%rowtype;
2291: -- FONM
2292: l_effective_date date;
2293: --

Line 2343: ben_env_object.get(p_rec => l_env);

2339: exception
2340: --
2341: when no_data_found then
2342: --
2343: ben_env_object.get(p_rec => l_env);
2344: --
2345: -- FONM
2346: --
2347: l_effective_date := nvl(ben_manage_life_events.g_fonm_rt_strt_dt,

Line 2436: l_env ben_env_object.g_global_env_rec_type;

2432: --
2433: l_proc varchar2(80) := g_package||'get_object asg';
2434: l_index pls_integer;
2435: --l_not_hash_found boolean;
2436: l_env ben_env_object.g_global_env_rec_type;
2437: --l_rec per_all_assignments_f%rowtype;
2438: -- FONM
2439: l_effective_date date;
2440: --

Line 2497: ben_env_object.get(p_rec => l_env);

2493: exception
2494: --
2495: when no_data_found then
2496: --
2497: ben_env_object.get(p_rec => l_env);
2498: --
2499: -- FONM
2500: --
2501: l_effective_date := nvl(ben_manage_life_events.g_fonm_rt_strt_dt,

Line 2526: l_env ben_env_object.g_global_env_rec_type;

2522: --
2523: l_proc varchar2(80) := g_package||'get_object asg';
2524: l_index pls_integer;
2525: --l_not_hash_found boolean;
2526: l_env ben_env_object.g_global_env_rec_type;
2527: --l_rec per_all_assignments_f%rowtype;
2528: -- FONM
2529: l_effective_date date;
2530: --

Line 2577: ben_env_object.get(p_rec => l_env);

2573: exception
2574: --
2575: when no_data_found then
2576: --
2577: ben_env_object.get(p_rec => l_env);
2578: --
2579: -- FONM
2580: --
2581: l_effective_date := nvl(ben_manage_life_events.g_fonm_rt_strt_dt,

Line 2604: l_env ben_env_object.g_global_env_rec_type;

2600: --
2601: l_proc varchar2(80) := g_package||'get_object benass';
2602: l_index pls_integer;
2603: --l_not_hash_found boolean;
2604: l_env ben_env_object.g_global_env_rec_type;
2605: --l_rec per_all_assignments_f%rowtype;
2606: --
2607: -- FONM
2608: l_effective_date date;

Line 2655: ben_env_object.get(p_rec => l_env);

2651: exception
2652: --
2653: when no_data_found then
2654: --
2655: ben_env_object.get(p_rec => l_env);
2656: --
2657: -- FONM
2658: --
2659: l_effective_date := nvl(ben_manage_life_events.g_fonm_rt_strt_dt,

Line 2805: l_env ben_env_object.g_global_env_rec_type;

2801: --
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: --

Line 2855: ben_env_object.get(p_rec => l_env);

2851: exception
2852: --
2853: when no_data_found then
2854: --
2855: ben_env_object.get(p_rec => l_env);
2856: --
2857: -- FONM
2858: --
2859: l_effective_date := nvl(ben_manage_life_events.g_fonm_rt_strt_dt,

Line 2883: l_env ben_env_object.g_global_env_rec_type;

2879: --
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: --

Line 2933: ben_env_object.get(p_rec => l_env);

2929: exception
2930: --
2931: when no_data_found then
2932: --
2933: ben_env_object.get(p_rec => l_env);
2934: --
2935: -- FONM
2936: --
2937: l_effective_date := nvl(ben_manage_life_events.g_fonm_rt_strt_dt,

Line 2959: l_env ben_env_object.g_global_env_rec_type;

2955: --
2956: l_proc varchar2(80) := g_package||'get_object pds';
2957: l_index pls_integer;
2958: --l_not_hash_found boolean;
2959: l_env ben_env_object.g_global_env_rec_type;
2960: --l_rec per_periods_of_service%rowtype;
2961: -- FONM
2962: l_effective_date date;
2963: --

Line 3009: ben_env_object.get(p_rec => l_env);

3005: exception
3006: --
3007: when no_data_found then
3008: --
3009: ben_env_object.get(p_rec => l_env);
3010: --
3011: -- FONM
3012: --
3013: l_effective_date := nvl(ben_manage_life_events.g_fonm_rt_strt_dt,

Line 3037: l_env ben_env_object.g_global_env_rec_type;

3033: --
3034: l_proc varchar2(80) := g_package||'get_object bbb';
3035: l_index pls_integer;
3036: --l_not_hash_found boolean;
3037: l_env ben_env_object.g_global_env_rec_type;
3038: --l_rec ben_per_bnfts_bal_f%rowtype;
3039: -- FONM
3040: l_effective_date date;
3041: --

Line 3089: ben_env_object.get(p_rec => l_env);

3085: end if;
3086: --
3087: -- FONM
3088: --
3089: ben_env_object.get(p_rec => l_env);
3090: --
3091: l_effective_date := nvl(ben_manage_life_events.g_fonm_rt_strt_dt,
3092: nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,
3093: p_effective_date)

Line 3111: ben_env_object.get(p_rec => l_env);

3107: exception
3108: --
3109: when no_data_found then
3110: --
3111: ben_env_object.get(p_rec => l_env);
3112: --
3113: -- FONM
3114: --
3115: l_effective_date := nvl(ben_manage_life_events.g_fonm_rt_strt_dt,

Line 3141: l_env ben_env_object.g_global_env_rec_type;

3137: --
3138: l_proc varchar2(80) := g_package||'get_object con';
3139: l_index pls_integer;
3140: --l_not_hash_found boolean;
3141: l_env ben_env_object.g_global_env_rec_type;
3142: --l_rec g_cache_con_table;
3143: -- FONM
3144: l_effective_date date;
3145: --

Line 3219: ben_env_object.get(p_rec => l_env);

3215: exception
3216: --
3217: when no_data_found then
3218: --
3219: ben_env_object.get(p_rec => l_env);
3220: --
3221: -- FONM
3222: --
3223: l_effective_date := nvl(ben_manage_life_events.g_fonm_rt_strt_dt,

Line 3242: l_env ben_env_object.g_global_env_rec_type;

3238: --
3239: l_proc varchar2(80) := g_package||'get_object ass';
3240: l_index pls_integer;
3241: --l_not_hash_found boolean;
3242: l_env ben_env_object.g_global_env_rec_type;
3243: --l_rec g_cache_ass_table;
3244: -- FONM
3245: l_effective_date date;
3246: --

Line 3324: ben_env_object.get(p_rec => l_env);

3320: exception
3321: --
3322: when no_data_found then
3323: --
3324: ben_env_object.get(p_rec => l_env);
3325: --
3326: -- FONM
3327: --
3328: l_effective_date := nvl(ben_manage_life_events.g_fonm_rt_strt_dt,

Line 3347: l_env ben_env_object.g_global_env_rec_type;

3343: --
3344: l_proc varchar2(80) ;
3345: l_index pls_integer;
3346: --l_not_hash_found boolean;
3347: l_env ben_env_object.g_global_env_rec_type;
3348: --l_rec g_cache_ass_table;
3349: -- FONM
3350: l_effective_date date;
3351: --

Line 3434: ben_env_object.get(p_rec => l_env);

3430: exception
3431: --
3432: when no_data_found then
3433: --
3434: ben_env_object.get(p_rec => l_env);
3435: --
3436: -- FONM
3437: --
3438: l_effective_date := nvl(ben_manage_life_events.g_fonm_rt_strt_dt,

Line 3457: l_env ben_env_object.g_global_env_rec_type;

3453: --
3454: l_proc varchar2(80) := g_package||'get_object typ';
3455: l_index pls_integer;
3456: --l_not_hash_found boolean;
3457: l_env ben_env_object.g_global_env_rec_type;
3458: --l_rec g_cache_typ_table;
3459: -- FONM
3460: l_effective_date date;
3461: --

Line 3535: ben_env_object.get(p_rec => l_env);

3531: exception
3532: --
3533: when no_data_found then
3534: --
3535: ben_env_object.get(p_rec => l_env);
3536: --
3537: -- FONM
3538: --
3539: l_effective_date := nvl(ben_manage_life_events.g_fonm_rt_strt_dt,

Line 3562: l_env ben_env_object.g_global_env_rec_type;

3558: l_proc varchar2(80) := g_package||'get_bal_per_object';
3559: l_index pls_integer;
3560: l_count pls_integer;
3561: --l_not_hash_found boolean;
3562: l_env ben_env_object.g_global_env_rec_type;
3563: l_rec ben_per_bnfts_bal_f%rowtype;
3564: l_start_index pls_integer;
3565: l_end_index pls_integer;
3566: --

Line 3648: l_env ben_env_object.g_global_env_rec_type;

3644: --
3645: l_proc varchar2(80) := g_package||'get_object pdi';
3646: l_index pls_integer;
3647: --l_not_hash_found boolean;
3648: l_env ben_env_object.g_global_env_rec_type;
3649: --l_rec g_person_date_info_rec;
3650: -- FONM
3651: l_effective_date date;
3652: --

Line 3699: ben_env_object.get(p_rec => l_env);

3695: exception
3696: --
3697: when no_data_found then
3698: --
3699: ben_env_object.get(p_rec => l_env);
3700: --
3701: -- FONM
3702: --
3703: l_effective_date := nvl(ben_manage_life_events.g_fonm_rt_strt_dt,

Line 3725: l_env ben_env_object.g_global_env_rec_type;

3721: --
3722: l_proc varchar2(80) := g_package||'get_object pfte';
3723: l_index pls_integer;
3724: --l_not_hash_found boolean;
3725: l_env ben_env_object.g_global_env_rec_type;
3726: --l_rec g_person_fte_info_rec;
3727: -- FONM
3728: l_effective_date date;
3729: --

Line 3776: ben_env_object.get(p_rec => l_env);

3772: exception
3773: --
3774: when no_data_found then
3775: --
3776: ben_env_object.get(p_rec => l_env);
3777: --
3778: -- FONM
3779: --
3780: l_effective_date := nvl(ben_manage_life_events.g_fonm_rt_strt_dt,

Line 3937: l_env ben_env_object.g_global_env_rec_type;

3933: --
3934: l_proc varchar2(80) := g_package||'get_assgn_object asg';
3935: l_index pls_integer;
3936: --l_not_hash_found boolean;
3937: l_env ben_env_object.g_global_env_rec_type;
3938: --l_rec per_all_assignments_f%rowtype;
3939: -- FONM
3940: l_effective_date date;
3941: --

Line 3996: ben_env_object.get(p_rec => l_env);

3992: exception
3993: --
3994: when no_data_found then
3995: hr_utility.set_location('Entering '||l_proc,677);
3996: ben_env_object.get(p_rec => l_env);
3997: --
3998: -- FONM
3999: --
4000: l_effective_date := nvl(ben_manage_life_events.g_fonm_rt_strt_dt,