DBA Data[Home] [Help]

APPS.BEN_DERIVE_PART_AND_RATE_FACTS dependencies on BEN_COBJ_CACHE

Line 715: ,p_curroipl_row IN ben_cobj_cache.g_oipl_inst_row

711: ,p_empasg_row IN per_all_assignments_f%ROWTYPE
712: ,p_benasg_row IN per_all_assignments_f%ROWTYPE
713: ,p_pil_row IN ben_per_in_ler%ROWTYPE
714: --
715: ,p_curroipl_row IN ben_cobj_cache.g_oipl_inst_row
716: ,p_curroiplip_row IN ben_cobj_cache.g_oiplip_inst_row
717: --
718: ,p_rule_type IN VARCHAR2 DEFAULT 'NUMBER'
719: ,p_effective_date IN DATE

Line 716: ,p_curroiplip_row IN ben_cobj_cache.g_oiplip_inst_row

712: ,p_benasg_row IN per_all_assignments_f%ROWTYPE
713: ,p_pil_row IN ben_per_in_ler%ROWTYPE
714: --
715: ,p_curroipl_row IN ben_cobj_cache.g_oipl_inst_row
716: ,p_curroiplip_row IN ben_cobj_cache.g_oiplip_inst_row
717: --
718: ,p_rule_type IN VARCHAR2 DEFAULT 'NUMBER'
719: ,p_effective_date IN DATE
720: ,p_lf_evt_ocrd_dt IN DATE

Line 739: l_oiplip_rec ben_cobj_cache.g_oiplip_inst_row;

735: l_loc_rec hr_locations_all%ROWTYPE;
736: l_ass_rec per_all_assignments_f%ROWTYPE;
737: l_pl_rec ben_pl_f%ROWTYPE;
738: l_oipl_rec ben_oipl_f%ROWTYPE;
739: l_oiplip_rec ben_cobj_cache.g_oiplip_inst_row;
740: l_effective_date date ;
741: l_jurisdiction_code VARCHAR2(30);
742: cursor c_ptip(p_effective_date date) is
743: select pl_typ_id

Line 2024: ,p_curroiplip_row IN ben_cobj_cache.g_oiplip_inst_row

2020: --
2021: PROCEDURE min_max_breach
2022: (p_calculate_only_mode in boolean default false
2023: ,p_comp_obj_tree_row IN ben_manage_life_events.g_cache_proc_objects_rec
2024: ,p_curroiplip_row IN ben_cobj_cache.g_oiplip_inst_row
2025: ,p_person_id IN NUMBER
2026: ,p_pgm_id IN NUMBER
2027: ,p_pl_id IN NUMBER
2028: ,p_oipl_id IN NUMBER

Line 2054: l_oiplip_rec ben_cobj_cache.g_oiplip_inst_row;

2050: l_lf_evt_ocrd_dt DATE;
2051: l_new_lf_evt_ocrd_dt DATE;
2052: l_start_date DATE;
2053: l_rec ben_person_object.g_person_date_info_rec;
2054: l_oiplip_rec ben_cobj_cache.g_oiplip_inst_row;
2055: --
2056: BEGIN
2057: --
2058: if g_debug then

Line 2300: ,p_curroipl_row IN ben_cobj_cache.g_oipl_inst_row

2296: p_comp_obj_tree_row IN ben_manage_life_events.g_cache_proc_objects_rec
2297: ,p_empasg_row IN per_all_assignments_f%ROWTYPE
2298: ,p_benasg_row IN per_all_assignments_f%ROWTYPE
2299: ,p_pil_row IN ben_per_in_ler%ROWTYPE
2300: ,p_curroipl_row IN ben_cobj_cache.g_oipl_inst_row
2301: ,p_curroiplip_row IN ben_cobj_cache.g_oiplip_inst_row
2302: ,p_rec IN ben_derive_part_and_rate_cache.g_cache_los_rec_obj
2303: ,p_comp_rec IN OUT NOCOPY g_cache_structure
2304: ,p_effective_date IN DATE

Line 2301: ,p_curroiplip_row IN ben_cobj_cache.g_oiplip_inst_row

2297: ,p_empasg_row IN per_all_assignments_f%ROWTYPE
2298: ,p_benasg_row IN per_all_assignments_f%ROWTYPE
2299: ,p_pil_row IN ben_per_in_ler%ROWTYPE
2300: ,p_curroipl_row IN ben_cobj_cache.g_oipl_inst_row
2301: ,p_curroiplip_row IN ben_cobj_cache.g_oiplip_inst_row
2302: ,p_rec IN ben_derive_part_and_rate_cache.g_cache_los_rec_obj
2303: ,p_comp_rec IN OUT NOCOPY g_cache_structure
2304: ,p_effective_date IN DATE
2305: ,p_lf_evt_ocrd_dt IN DATE

Line 2327: l_oiplip_rec ben_cobj_cache.g_oiplip_inst_row;

2323: l_per_rec per_all_people_f%ROWTYPE;
2324: l_dummy_num NUMBER;
2325: l_aei_rec per_assignment_extra_info%ROWTYPE;
2326: l_ass_rec per_all_assignments_f%ROWTYPE;
2327: l_oiplip_rec ben_cobj_cache.g_oiplip_inst_row;
2328: --
2329: BEGIN
2330: -- hr_utility.set_location('Entering ' || l_package,10);
2331: --

Line 2587: ,p_curroipl_row IN ben_cobj_cache.g_oipl_inst_row

2583: ,p_per_row IN per_all_people_f%ROWTYPE
2584: ,p_empasg_row IN per_all_assignments_f%ROWTYPE
2585: ,p_benasg_row IN per_all_assignments_f%ROWTYPE
2586: ,p_pil_row IN ben_per_in_ler%ROWTYPE
2587: ,p_curroipl_row IN ben_cobj_cache.g_oipl_inst_row
2588: ,p_curroiplip_row IN ben_cobj_cache.g_oiplip_inst_row
2589: ,p_rec IN ben_derive_part_and_rate_cache.g_cache_age_rec_obj
2590: ,p_effective_date IN DATE
2591: ,p_lf_evt_ocrd_dt IN DATE

Line 2588: ,p_curroiplip_row IN ben_cobj_cache.g_oiplip_inst_row

2584: ,p_empasg_row IN per_all_assignments_f%ROWTYPE
2585: ,p_benasg_row IN per_all_assignments_f%ROWTYPE
2586: ,p_pil_row IN ben_per_in_ler%ROWTYPE
2587: ,p_curroipl_row IN ben_cobj_cache.g_oipl_inst_row
2588: ,p_curroiplip_row IN ben_cobj_cache.g_oiplip_inst_row
2589: ,p_rec IN ben_derive_part_and_rate_cache.g_cache_age_rec_obj
2590: ,p_effective_date IN DATE
2591: ,p_lf_evt_ocrd_dt IN DATE
2592: ,p_business_group_id IN NUMBER

Line 2616: l_oiplip_rec ben_cobj_cache.g_oiplip_inst_row;

2612: l_outputs ff_exec.outputs_t;
2613: l_pil_rec ben_per_in_ler%ROWTYPE;
2614: l_pl_rec ben_pl_f%ROWTYPE;
2615: l_oipl_rec ben_oipl_f%ROWTYPE;
2616: l_oiplip_rec ben_cobj_cache.g_oiplip_inst_row;
2617: l_ass_rec per_all_assignments_f%ROWTYPE;
2618: l_loc_rec hr_locations_all%ROWTYPE;
2619: l_per_rec per_all_people_f%ROWTYPE;
2620: l_person_id NUMBER;

Line 3034: ,p_curroiplip_row IN ben_cobj_cache.g_oiplip_inst_row

3030: FUNCTION hours_calculation(
3031: p_comp_obj_tree_row IN ben_manage_life_events.g_cache_proc_objects_rec
3032: ,p_empasg_row IN per_all_assignments_f%ROWTYPE
3033: ,p_benasg_row IN per_all_assignments_f%ROWTYPE
3034: ,p_curroiplip_row IN ben_cobj_cache.g_oiplip_inst_row
3035: ,p_rec IN ben_derive_part_and_rate_cache.g_cache_hwf_rec_obj
3036: ,p_business_group_id IN NUMBER
3037: ,p_person_id IN NUMBER
3038: ,p_pgm_id IN NUMBER

Line 3055: l_oiplip_rec ben_cobj_cache.g_oiplip_inst_row;

3051: l_outputs ff_exec.outputs_t;
3052: l_pil_rec ben_per_in_ler%ROWTYPE;
3053: l_pl_rec ben_pl_f%ROWTYPE;
3054: l_oipl_rec ben_oipl_f%ROWTYPE;
3055: l_oiplip_rec ben_cobj_cache.g_oiplip_inst_row;
3056: l_loc_rec hr_locations_all%ROWTYPE;
3057: l_ass_rec per_all_assignments_f%ROWTYPE;
3058: l_bal_rec ben_per_bnfts_bal_f%ROWTYPE;
3059: l_bnb_rec ben_bnfts_bal_f%ROWTYPE;

Line 3370: ,p_curroiplip_row IN ben_cobj_cache.g_oiplip_inst_row

3366: FUNCTION comp_calculation(
3367: p_comp_obj_tree_row IN ben_manage_life_events.g_cache_proc_objects_rec
3368: ,p_empasg_row IN per_all_assignments_f%ROWTYPE
3369: ,p_benasg_row IN per_all_assignments_f%ROWTYPE
3370: ,p_curroiplip_row IN ben_cobj_cache.g_oiplip_inst_row
3371: ,p_rec IN ben_derive_part_and_rate_cache.g_cache_clf_rec_obj
3372: ,p_person_id IN NUMBER
3373: ,p_business_group_id IN NUMBER
3374: ,p_pgm_id IN NUMBER

Line 3402: l_oiplip_rec ben_cobj_cache.g_oiplip_inst_row;

3398: l_outputs ff_exec.outputs_t;
3399: l_pil_rec ben_per_in_ler%ROWTYPE;
3400: l_pl_rec ben_pl_f%ROWTYPE;
3401: l_oipl_rec ben_oipl_f%ROWTYPE;
3402: l_oiplip_rec ben_cobj_cache.g_oiplip_inst_row;
3403: l_loc_rec hr_locations_all%ROWTYPE;
3404: l_ass_rec per_all_assignments_f%ROWTYPE;
3405: l_bal_rec ben_per_bnfts_bal_f%ROWTYPE;
3406: l_bnb_rec ben_bnfts_bal_f%ROWTYPE;

Line 3772: ,p_curroipl_row IN ben_cobj_cache.g_oipl_inst_row

3768: ,p_comp_obj_tree_row IN ben_manage_life_events.g_cache_proc_objects_rec
3769: ,p_empasg_row IN per_all_assignments_f%ROWTYPE
3770: ,p_benasg_row IN per_all_assignments_f%ROWTYPE
3771: ,p_pil_row IN ben_per_in_ler%ROWTYPE
3772: ,p_curroipl_row IN ben_cobj_cache.g_oipl_inst_row
3773: ,p_curroiplip_row IN ben_cobj_cache.g_oiplip_inst_row
3774: ,p_person_id IN NUMBER
3775: ,p_business_group_id IN NUMBER
3776: ,p_pgm_id IN NUMBER

Line 3773: ,p_curroiplip_row IN ben_cobj_cache.g_oiplip_inst_row

3769: ,p_empasg_row IN per_all_assignments_f%ROWTYPE
3770: ,p_benasg_row IN per_all_assignments_f%ROWTYPE
3771: ,p_pil_row IN ben_per_in_ler%ROWTYPE
3772: ,p_curroipl_row IN ben_cobj_cache.g_oipl_inst_row
3773: ,p_curroiplip_row IN ben_cobj_cache.g_oiplip_inst_row
3774: ,p_person_id IN NUMBER
3775: ,p_business_group_id IN NUMBER
3776: ,p_pgm_id IN NUMBER
3777: ,p_pl_id IN NUMBER

Line 3811: l_oiplip_rec ben_cobj_cache.g_oiplip_inst_row;

3807: l_dummy_date DATE;
3808: l_rate BOOLEAN := FALSE;
3809: l_cvg BOOLEAN := FALSE;
3810: l_prem BOOLEAN := FALSE;
3811: l_oiplip_rec ben_cobj_cache.g_oiplip_inst_row;
3812: l_los_val number;
3813: --FONM
3814: --g_fonm_cvg_strt_dt DATE ;
3815: --END FONM

Line 4500: ,p_curroipl_row IN ben_cobj_cache.g_oipl_inst_row

4496: ,p_per_row IN per_all_people_f%ROWTYPE
4497: ,p_empasg_row IN per_all_assignments_f%ROWTYPE
4498: ,p_benasg_row IN per_all_assignments_f%ROWTYPE
4499: ,p_pil_row IN ben_per_in_ler%ROWTYPE
4500: ,p_curroipl_row IN ben_cobj_cache.g_oipl_inst_row
4501: ,p_curroiplip_row IN ben_cobj_cache.g_oiplip_inst_row
4502: ,p_person_id IN NUMBER
4503: ,p_business_group_id IN NUMBER
4504: ,p_pgm_id IN NUMBER

Line 4501: ,p_curroiplip_row IN ben_cobj_cache.g_oiplip_inst_row

4497: ,p_empasg_row IN per_all_assignments_f%ROWTYPE
4498: ,p_benasg_row IN per_all_assignments_f%ROWTYPE
4499: ,p_pil_row IN ben_per_in_ler%ROWTYPE
4500: ,p_curroipl_row IN ben_cobj_cache.g_oipl_inst_row
4501: ,p_curroiplip_row IN ben_cobj_cache.g_oiplip_inst_row
4502: ,p_person_id IN NUMBER
4503: ,p_business_group_id IN NUMBER
4504: ,p_pgm_id IN NUMBER
4505: ,p_pl_id IN NUMBER

Line 5111: ,p_curroiplip_row IN ben_cobj_cache.g_oiplip_inst_row

5107: --
5108: PROCEDURE comp_level_min_max
5109: (p_calculate_only_mode in boolean default false
5110: ,p_comp_obj_tree_row IN ben_manage_life_events.g_cache_proc_objects_rec
5111: ,p_curroiplip_row IN ben_cobj_cache.g_oiplip_inst_row
5112: ,p_rec IN ben_derive_part_and_rate_cache.g_cache_clf_rec_obj
5113: -- ,p_rate_rec IN OUT ben_derive_part_and_rate_cache.g_cache_clf_rec_obj
5114: -- ,p_comp_rec IN OUT NOCOPY g_cache_structure
5115: ,p_empasg_row IN per_all_assignments_f%ROWTYPE

Line 5149: l_oiplip_rec ben_cobj_cache.g_oiplip_inst_row;

5145: l_lf_evt_ocrd_dt DATE;
5146: l_new_lf_evt_ocrd_dt DATE;
5147: l_start_date DATE;
5148: l_rec ben_person_object.g_person_date_info_rec;
5149: l_oiplip_rec ben_cobj_cache.g_oiplip_inst_row;
5150: --
5151: BEGIN
5152: if g_debug then
5153: hr_utility.set_location('Entering comp_level_min_max ', 10 );

Line 5456: ,p_curroipl_row IN ben_cobj_cache.g_oipl_inst_row

5452: ,p_comp_obj_tree_row in ben_manage_life_events.g_cache_proc_objects_rec
5453: ,p_empasg_row IN per_all_assignments_f%ROWTYPE
5454: ,p_benasg_row IN per_all_assignments_f%ROWTYPE
5455: ,p_pil_row IN ben_per_in_ler%ROWTYPE
5456: ,p_curroipl_row IN ben_cobj_cache.g_oipl_inst_row
5457: ,p_curroiplip_row IN ben_cobj_cache.g_oiplip_inst_row
5458: ,p_person_id IN NUMBER
5459: ,p_business_group_id IN NUMBER
5460: ,p_pgm_id IN NUMBER

Line 5457: ,p_curroiplip_row IN ben_cobj_cache.g_oiplip_inst_row

5453: ,p_empasg_row IN per_all_assignments_f%ROWTYPE
5454: ,p_benasg_row IN per_all_assignments_f%ROWTYPE
5455: ,p_pil_row IN ben_per_in_ler%ROWTYPE
5456: ,p_curroipl_row IN ben_cobj_cache.g_oipl_inst_row
5457: ,p_curroiplip_row IN ben_cobj_cache.g_oiplip_inst_row
5458: ,p_person_id IN NUMBER
5459: ,p_business_group_id IN NUMBER
5460: ,p_pgm_id IN NUMBER
5461: ,p_pl_id IN NUMBER

Line 5497: l_oiplip_rec ben_cobj_cache.g_oiplip_inst_row;

5493: l_start_date DATE;
5494: l_rate BOOLEAN := FALSE;
5495: l_cvg BOOLEAN := FALSE;
5496: l_prem BOOLEAN := FALSE;
5497: l_oiplip_rec ben_cobj_cache.g_oiplip_inst_row;
5498: --BUG 3174453
5499: l_pgm_id number(15) := p_pgm_id;
5500: l_pl_id number(15) := p_pl_id;
5501: l_oipl_id number(15) := p_oipl_id;

Line 6761: ,p_curroipl_row IN ben_cobj_cache.g_oipl_inst_row

6757: ,p_per_row IN per_all_people_f%ROWTYPE
6758: ,p_empasg_row IN per_all_assignments_f%ROWTYPE
6759: ,p_benasg_row IN per_all_assignments_f%ROWTYPE
6760: ,p_pil_row IN ben_per_in_ler%ROWTYPE
6761: ,p_curroipl_row IN ben_cobj_cache.g_oipl_inst_row
6762: ,p_curroiplip_row IN ben_cobj_cache.g_oiplip_inst_row
6763: ,p_person_id IN NUMBER
6764: ,p_business_group_id IN NUMBER
6765: ,p_pgm_id IN NUMBER

Line 6762: ,p_curroiplip_row IN ben_cobj_cache.g_oiplip_inst_row

6758: ,p_empasg_row IN per_all_assignments_f%ROWTYPE
6759: ,p_benasg_row IN per_all_assignments_f%ROWTYPE
6760: ,p_pil_row IN ben_per_in_ler%ROWTYPE
6761: ,p_curroipl_row IN ben_cobj_cache.g_oipl_inst_row
6762: ,p_curroiplip_row IN ben_cobj_cache.g_oiplip_inst_row
6763: ,p_person_id IN NUMBER
6764: ,p_business_group_id IN NUMBER
6765: ,p_pgm_id IN NUMBER
6766: ,p_pl_id IN NUMBER

Line 7457: ,p_curroiplip_row IN ben_cobj_cache.g_oiplip_inst_row

7453: --
7454: PROCEDURE percent_fulltime_min_max
7455: (p_calculate_only_mode in boolean default false
7456: ,p_comp_obj_tree_row IN ben_manage_life_events.g_cache_proc_objects_rec
7457: ,p_curroiplip_row IN ben_cobj_cache.g_oiplip_inst_row
7458: --,p_rate_rec IN OUT ben_derive_part_and_rate_cache.g_cache_clf_rec_obj
7459: ,p_comp_rec IN OUT NOCOPY g_cache_structure
7460: ,p_empasg_row IN per_all_assignments_f%ROWTYPE
7461: ,p_benasg_row IN per_all_assignments_f%ROWTYPE

Line 7494: l_oiplip_rec ben_cobj_cache.g_oiplip_inst_row;

7490: l_lf_evt_ocrd_dt DATE;
7491: l_new_lf_evt_ocrd_dt DATE;
7492: l_start_date DATE;
7493: l_rec ben_person_object.g_person_date_info_rec;
7494: l_oiplip_rec ben_cobj_cache.g_oiplip_inst_row;
7495: --
7496: BEGIN
7497: if g_debug then
7498: hr_utility.set_location('Entering percent_fulltime_min_max ', 10 );

Line 7597: ,p_curroipl_row IN ben_cobj_cache.g_oipl_inst_row

7593: ,p_comp_obj_tree_row IN ben_manage_life_events.g_cache_proc_objects_rec
7594: ,p_empasg_row IN per_all_assignments_f%ROWTYPE
7595: ,p_benasg_row IN per_all_assignments_f%ROWTYPE
7596: ,p_pil_row IN ben_per_in_ler%ROWTYPE
7597: ,p_curroipl_row IN ben_cobj_cache.g_oipl_inst_row
7598: ,p_curroiplip_row IN ben_cobj_cache.g_oiplip_inst_row
7599: ,p_person_id IN NUMBER
7600: ,p_business_group_id IN NUMBER
7601: ,p_pgm_id IN NUMBER

Line 7598: ,p_curroiplip_row IN ben_cobj_cache.g_oiplip_inst_row

7594: ,p_empasg_row IN per_all_assignments_f%ROWTYPE
7595: ,p_benasg_row IN per_all_assignments_f%ROWTYPE
7596: ,p_pil_row IN ben_per_in_ler%ROWTYPE
7597: ,p_curroipl_row IN ben_cobj_cache.g_oipl_inst_row
7598: ,p_curroiplip_row IN ben_cobj_cache.g_oiplip_inst_row
7599: ,p_person_id IN NUMBER
7600: ,p_business_group_id IN NUMBER
7601: ,p_pgm_id IN NUMBER
7602: ,p_pl_id IN NUMBER

Line 8184: ,p_curroiplip_row IN ben_cobj_cache.g_oiplip_inst_row

8180: --
8181: PROCEDURE hours_worked_min_max
8182: (p_calculate_only_mode in boolean default false
8183: ,p_comp_obj_tree_row IN ben_manage_life_events.g_cache_proc_objects_rec
8184: ,p_curroiplip_row IN ben_cobj_cache.g_oiplip_inst_row
8185: --,p_rate_rec IN OUT ben_derive_part_and_rate_cache.g_cache_clf_rec_obj
8186: ,p_comp_rec IN OUT NOCOPY g_cache_structure
8187: ,p_empasg_row IN per_all_assignments_f%ROWTYPE
8188: ,p_benasg_row IN per_all_assignments_f%ROWTYPE

Line 8221: l_oiplip_rec ben_cobj_cache.g_oiplip_inst_row;

8217: l_lf_evt_ocrd_dt DATE;
8218: l_new_lf_evt_ocrd_dt DATE;
8219: l_start_date DATE;
8220: l_rec ben_person_object.g_person_date_info_rec;
8221: l_oiplip_rec ben_cobj_cache.g_oiplip_inst_row;
8222: --
8223: BEGIN
8224: hr_utility.set_location('Entering hours_worked_min_max ', 10 );
8225: /* Bug 5478918 */

Line 8399: ,p_curroipl_row IN ben_cobj_cache.g_oipl_inst_row

8395: ,p_comp_obj_tree_row IN ben_manage_life_events.g_cache_proc_objects_rec
8396: ,p_empasg_row IN per_all_assignments_f%ROWTYPE
8397: ,p_benasg_row IN per_all_assignments_f%ROWTYPE
8398: ,p_pil_row IN ben_per_in_ler%ROWTYPE
8399: ,p_curroipl_row IN ben_cobj_cache.g_oipl_inst_row
8400: ,p_curroiplip_row IN ben_cobj_cache.g_oiplip_inst_row
8401: ,p_person_id IN NUMBER
8402: ,p_business_group_id IN NUMBER
8403: ,p_pgm_id IN NUMBER

Line 8400: ,p_curroiplip_row IN ben_cobj_cache.g_oiplip_inst_row

8396: ,p_empasg_row IN per_all_assignments_f%ROWTYPE
8397: ,p_benasg_row IN per_all_assignments_f%ROWTYPE
8398: ,p_pil_row IN ben_per_in_ler%ROWTYPE
8399: ,p_curroipl_row IN ben_cobj_cache.g_oipl_inst_row
8400: ,p_curroiplip_row IN ben_cobj_cache.g_oiplip_inst_row
8401: ,p_person_id IN NUMBER
8402: ,p_business_group_id IN NUMBER
8403: ,p_pgm_id IN NUMBER
8404: ,p_pl_id IN NUMBER

Line 8440: l_oiplip_rec ben_cobj_cache.g_oiplip_inst_row;

8436: l_dummy_date DATE;
8437: l_rate BOOLEAN := FALSE;
8438: l_cvg BOOLEAN := FALSE;
8439: l_prem BOOLEAN := FALSE;
8440: l_oiplip_rec ben_cobj_cache.g_oiplip_inst_row;
8441: --
8442: BEGIN
8443: --
8444: if g_debug then

Line 10761: l_curroipl_row ben_cobj_cache.g_oipl_inst_row;

10757: l_pgm_rec ben_pgm_f%ROWTYPE;
10758: l_ptip_rec ben_ptip_f%ROWTYPE;
10759: l_comp_rec g_cache_structure;
10760: l_oiplip_rec g_cache_structure;
10761: l_curroipl_row ben_cobj_cache.g_oipl_inst_row;
10762: l_curroiplip_row ben_cobj_cache.g_oiplip_inst_row;
10763: l_oipl_id NUMBER;
10764: l_oiplip_id NUMBER;
10765: l_loop_count NUMBER := 1;

Line 10762: l_curroiplip_row ben_cobj_cache.g_oiplip_inst_row;

10758: l_ptip_rec ben_ptip_f%ROWTYPE;
10759: l_comp_rec g_cache_structure;
10760: l_oiplip_rec g_cache_structure;
10761: l_curroipl_row ben_cobj_cache.g_oipl_inst_row;
10762: l_curroiplip_row ben_cobj_cache.g_oiplip_inst_row;
10763: l_oipl_id NUMBER;
10764: l_oiplip_id NUMBER;
10765: l_loop_count NUMBER := 1;
10766: --FONM

Line 10917: ben_cobj_cache.get_oipl_dets(p_business_group_id=> p_business_group_id

10913: --
10914: --hr_utility.set_location(' p_comp_obj_tree_row.oipl_id '||p_comp_obj_tree_row.oipl_id ,55);
10915: IF p_comp_obj_tree_row.oipl_id IS NOT NULL THEN
10916: --
10917: ben_cobj_cache.get_oipl_dets(p_business_group_id=> p_business_group_id
10918: ,p_effective_date => g_fonm_cvg_strt_dt -- FONM p_effective_date
10919: ,p_oipl_id => p_comp_obj_tree_row.oipl_id
10920: ,p_inst_row => l_curroipl_row);
10921: --

Line 10928: ben_cobj_cache.get_oiplip_dets(p_business_group_id=> p_business_group_id

10924: --hr_utility.set_location(' p_comp_obj_tree_row.oiplip_id '||p_comp_obj_tree_row.oiplip_id ,55);
10925: --
10926: IF p_comp_obj_tree_row.oiplip_id IS NOT NULL THEN
10927: --
10928: ben_cobj_cache.get_oiplip_dets(p_business_group_id=> p_business_group_id
10929: ,p_effective_date => NVL(g_fonm_cvg_strt_dt, p_effective_date)
10930: ,p_oiplip_id => p_comp_obj_tree_row.oiplip_id
10931: ,p_inst_row => l_curroiplip_row);
10932: --