DBA Data[Home] [Help]

APPS.BEN_PERSON_OBJECT dependencies on BEN_ENV_OBJECT

Line 2152: l_env ben_env_object.g_global_env_rec_type;

2148: procedure get_object(p_person_id in number,
2149: p_rec in out nocopy per_all_people_f%rowtype) is
2150: l_proc varchar2(80) := g_package||'get_object per';
2151: l_index pls_integer;
2152: l_env ben_env_object.g_global_env_rec_type;
2153: --l_rec per_all_people_f%rowtype;
2154: --
2155: -- FONM
2156: l_effective_date date;

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

2206: -- Defrag all person caches to grab back PGA memory
2207: --
2208: ben_person_object.defrag_caches;
2209: --
2210: ben_env_object.get(p_rec => l_env);
2211: --
2212: -- FONM
2213: --
2214: l_effective_date := nvl(ben_manage_life_events.g_fonm_rt_strt_dt,

Line 2235: l_env ben_env_object.g_global_env_rec_type;

2231: --
2232: l_proc varchar2(80) := g_package||'get_object bnb';
2233: l_index pls_integer;
2234: --l_not_hash_found boolean;
2235: l_env ben_env_object.g_global_env_rec_type;
2236: --l_rec ben_bnfts_bal_f%rowtype;
2237: -- FONM
2238: l_effective_date date;
2239: --

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

2285: exception
2286: --
2287: when no_data_found then
2288: --
2289: ben_env_object.get(p_rec => l_env);
2290: --
2291: -- FONM
2292: --
2293: l_effective_date := nvl(ben_manage_life_events.g_fonm_rt_strt_dt,

Line 2377: l_env ben_env_object.g_global_env_rec_type;

2373: --
2374: l_proc varchar2(80) := g_package||'get_object asg';
2375: l_index pls_integer;
2376: --l_not_hash_found boolean;
2377: l_env ben_env_object.g_global_env_rec_type;
2378: --l_rec per_all_assignments_f%rowtype;
2379: -- FONM
2380: l_effective_date date;
2381: --

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

2424: exception
2425: --
2426: when no_data_found then
2427: --
2428: ben_env_object.get(p_rec => l_env);
2429: --
2430: -- FONM
2431: --
2432: l_effective_date := nvl(ben_manage_life_events.g_fonm_rt_strt_dt,

Line 2455: l_env ben_env_object.g_global_env_rec_type;

2451: --
2452: l_proc varchar2(80) := g_package||'get_object benass';
2453: l_index pls_integer;
2454: --l_not_hash_found boolean;
2455: l_env ben_env_object.g_global_env_rec_type;
2456: --l_rec per_all_assignments_f%rowtype;
2457: --
2458: -- FONM
2459: l_effective_date date;

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

2502: exception
2503: --
2504: when no_data_found then
2505: --
2506: ben_env_object.get(p_rec => l_env);
2507: --
2508: -- FONM
2509: --
2510: l_effective_date := nvl(ben_manage_life_events.g_fonm_rt_strt_dt,

Line 2655: l_env ben_env_object.g_global_env_rec_type;

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

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

2701: exception
2702: --
2703: when no_data_found then
2704: --
2705: ben_env_object.get(p_rec => l_env);
2706: --
2707: -- FONM
2708: --
2709: l_effective_date := nvl(ben_manage_life_events.g_fonm_rt_strt_dt,

Line 2733: l_env ben_env_object.g_global_env_rec_type;

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

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

2779: exception
2780: --
2781: when no_data_found then
2782: --
2783: ben_env_object.get(p_rec => l_env);
2784: --
2785: -- FONM
2786: --
2787: l_effective_date := nvl(ben_manage_life_events.g_fonm_rt_strt_dt,

Line 2809: l_env ben_env_object.g_global_env_rec_type;

2805: --
2806: l_proc varchar2(80) := g_package||'get_object pds';
2807: l_index pls_integer;
2808: --l_not_hash_found boolean;
2809: l_env ben_env_object.g_global_env_rec_type;
2810: --l_rec per_periods_of_service%rowtype;
2811: -- FONM
2812: l_effective_date date;
2813: --

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

2855: exception
2856: --
2857: when no_data_found then
2858: --
2859: ben_env_object.get(p_rec => l_env);
2860: --
2861: -- FONM
2862: --
2863: l_effective_date := nvl(ben_manage_life_events.g_fonm_rt_strt_dt,

Line 2887: l_env ben_env_object.g_global_env_rec_type;

2883: --
2884: l_proc varchar2(80) := g_package||'get_object bbb';
2885: l_index pls_integer;
2886: --l_not_hash_found boolean;
2887: l_env ben_env_object.g_global_env_rec_type;
2888: --l_rec ben_per_bnfts_bal_f%rowtype;
2889: -- FONM
2890: l_effective_date date;
2891: --

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

2935: end if;
2936: --
2937: -- FONM
2938: --
2939: ben_env_object.get(p_rec => l_env);
2940: --
2941: l_effective_date := nvl(ben_manage_life_events.g_fonm_rt_strt_dt,
2942: nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,
2943: p_effective_date)

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

2957: exception
2958: --
2959: when no_data_found then
2960: --
2961: ben_env_object.get(p_rec => l_env);
2962: --
2963: -- FONM
2964: --
2965: l_effective_date := nvl(ben_manage_life_events.g_fonm_rt_strt_dt,

Line 2991: l_env ben_env_object.g_global_env_rec_type;

2987: --
2988: l_proc varchar2(80) := g_package||'get_object con';
2989: l_index pls_integer;
2990: --l_not_hash_found boolean;
2991: l_env ben_env_object.g_global_env_rec_type;
2992: --l_rec g_cache_con_table;
2993: -- FONM
2994: l_effective_date date;
2995: --

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

3065: exception
3066: --
3067: when no_data_found then
3068: --
3069: ben_env_object.get(p_rec => l_env);
3070: --
3071: -- FONM
3072: --
3073: l_effective_date := nvl(ben_manage_life_events.g_fonm_rt_strt_dt,

Line 3092: l_env ben_env_object.g_global_env_rec_type;

3088: --
3089: l_proc varchar2(80) := g_package||'get_object ass';
3090: l_index pls_integer;
3091: --l_not_hash_found boolean;
3092: l_env ben_env_object.g_global_env_rec_type;
3093: --l_rec g_cache_ass_table;
3094: -- FONM
3095: l_effective_date date;
3096: --

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

3170: exception
3171: --
3172: when no_data_found then
3173: --
3174: ben_env_object.get(p_rec => l_env);
3175: --
3176: -- FONM
3177: --
3178: l_effective_date := nvl(ben_manage_life_events.g_fonm_rt_strt_dt,

Line 3197: l_env ben_env_object.g_global_env_rec_type;

3193: --
3194: l_proc varchar2(80) ;
3195: l_index pls_integer;
3196: --l_not_hash_found boolean;
3197: l_env ben_env_object.g_global_env_rec_type;
3198: --l_rec g_cache_ass_table;
3199: -- FONM
3200: l_effective_date date;
3201: --

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

3275: exception
3276: --
3277: when no_data_found then
3278: --
3279: ben_env_object.get(p_rec => l_env);
3280: --
3281: -- FONM
3282: --
3283: l_effective_date := nvl(ben_manage_life_events.g_fonm_rt_strt_dt,

Line 3302: l_env ben_env_object.g_global_env_rec_type;

3298: --
3299: l_proc varchar2(80) := g_package||'get_object typ';
3300: l_index pls_integer;
3301: --l_not_hash_found boolean;
3302: l_env ben_env_object.g_global_env_rec_type;
3303: --l_rec g_cache_typ_table;
3304: -- FONM
3305: l_effective_date date;
3306: --

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

3376: exception
3377: --
3378: when no_data_found then
3379: --
3380: ben_env_object.get(p_rec => l_env);
3381: --
3382: -- FONM
3383: --
3384: l_effective_date := nvl(ben_manage_life_events.g_fonm_rt_strt_dt,

Line 3407: l_env ben_env_object.g_global_env_rec_type;

3403: l_proc varchar2(80) := g_package||'get_bal_per_object';
3404: l_index pls_integer;
3405: l_count pls_integer;
3406: --l_not_hash_found boolean;
3407: l_env ben_env_object.g_global_env_rec_type;
3408: l_rec ben_per_bnfts_bal_f%rowtype;
3409: l_start_index pls_integer;
3410: l_end_index pls_integer;
3411: --

Line 3493: l_env ben_env_object.g_global_env_rec_type;

3489: --
3490: l_proc varchar2(80) := g_package||'get_object pdi';
3491: l_index pls_integer;
3492: --l_not_hash_found boolean;
3493: l_env ben_env_object.g_global_env_rec_type;
3494: --l_rec g_person_date_info_rec;
3495: -- FONM
3496: l_effective_date date;
3497: --

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

3540: exception
3541: --
3542: when no_data_found then
3543: --
3544: ben_env_object.get(p_rec => l_env);
3545: --
3546: -- FONM
3547: --
3548: l_effective_date := nvl(ben_manage_life_events.g_fonm_rt_strt_dt,

Line 3570: l_env ben_env_object.g_global_env_rec_type;

3566: --
3567: l_proc varchar2(80) := g_package||'get_object pfte';
3568: l_index pls_integer;
3569: --l_not_hash_found boolean;
3570: l_env ben_env_object.g_global_env_rec_type;
3571: --l_rec g_person_fte_info_rec;
3572: -- FONM
3573: l_effective_date date;
3574: --

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

3617: exception
3618: --
3619: when no_data_found then
3620: --
3621: ben_env_object.get(p_rec => l_env);
3622: --
3623: -- FONM
3624: --
3625: l_effective_date := nvl(ben_manage_life_events.g_fonm_rt_strt_dt,