DBA Data[Home] [Help]

APPS.BEN_DERIVE_PART_AND_RATE_FACTS dependencies on BEN_COBJ_CACHE

Line 716: ,p_curroipl_row IN ben_cobj_cache.g_oipl_inst_row

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

Line 717: ,p_curroiplip_row IN ben_cobj_cache.g_oiplip_inst_row

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

Line 740: l_oiplip_rec ben_cobj_cache.g_oiplip_inst_row;

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

Line 2025: ,p_curroiplip_row IN ben_cobj_cache.g_oiplip_inst_row

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

Line 2055: l_oiplip_rec ben_cobj_cache.g_oiplip_inst_row;

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

Line 2301: ,p_curroipl_row IN ben_cobj_cache.g_oipl_inst_row

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

Line 2302: ,p_curroiplip_row IN ben_cobj_cache.g_oiplip_inst_row

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

Line 2328: l_oiplip_rec ben_cobj_cache.g_oiplip_inst_row;

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

Line 2588: ,p_curroipl_row IN ben_cobj_cache.g_oipl_inst_row

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

Line 2589: ,p_curroiplip_row IN ben_cobj_cache.g_oiplip_inst_row

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

Line 2617: l_oiplip_rec ben_cobj_cache.g_oiplip_inst_row;

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

Line 3035: ,p_curroiplip_row IN ben_cobj_cache.g_oiplip_inst_row

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

Line 3056: l_oiplip_rec ben_cobj_cache.g_oiplip_inst_row;

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

Line 3371: ,p_curroiplip_row IN ben_cobj_cache.g_oiplip_inst_row

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

Line 3403: l_oiplip_rec ben_cobj_cache.g_oiplip_inst_row;

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

Line 3773: ,p_curroipl_row IN ben_cobj_cache.g_oipl_inst_row

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

Line 3774: ,p_curroiplip_row IN ben_cobj_cache.g_oiplip_inst_row

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

Line 3812: l_oiplip_rec ben_cobj_cache.g_oiplip_inst_row;

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

Line 4501: ,p_curroipl_row IN ben_cobj_cache.g_oipl_inst_row

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

Line 4502: ,p_curroiplip_row IN ben_cobj_cache.g_oiplip_inst_row

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

Line 5112: ,p_curroiplip_row IN ben_cobj_cache.g_oiplip_inst_row

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

Line 5150: l_oiplip_rec ben_cobj_cache.g_oiplip_inst_row;

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

Line 5457: ,p_curroipl_row IN ben_cobj_cache.g_oipl_inst_row

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

Line 5458: ,p_curroiplip_row IN ben_cobj_cache.g_oiplip_inst_row

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

Line 5498: l_oiplip_rec ben_cobj_cache.g_oiplip_inst_row;

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

Line 6762: ,p_curroipl_row IN ben_cobj_cache.g_oipl_inst_row

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

Line 6763: ,p_curroiplip_row IN ben_cobj_cache.g_oiplip_inst_row

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

Line 7458: ,p_curroiplip_row IN ben_cobj_cache.g_oiplip_inst_row

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

Line 7495: l_oiplip_rec ben_cobj_cache.g_oiplip_inst_row;

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

Line 7598: ,p_curroipl_row IN ben_cobj_cache.g_oipl_inst_row

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

Line 7599: ,p_curroiplip_row IN ben_cobj_cache.g_oiplip_inst_row

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

Line 8185: ,p_curroiplip_row IN ben_cobj_cache.g_oiplip_inst_row

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

Line 8222: l_oiplip_rec ben_cobj_cache.g_oiplip_inst_row;

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

Line 8400: ,p_curroipl_row IN ben_cobj_cache.g_oipl_inst_row

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

Line 8401: ,p_curroiplip_row IN ben_cobj_cache.g_oiplip_inst_row

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

Line 8441: l_oiplip_rec ben_cobj_cache.g_oiplip_inst_row;

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

Line 10834: l_curroipl_row ben_cobj_cache.g_oipl_inst_row;

10830: l_pgm_rec ben_pgm_f%ROWTYPE;
10831: l_ptip_rec ben_ptip_f%ROWTYPE;
10832: l_comp_rec g_cache_structure;
10833: l_oiplip_rec g_cache_structure;
10834: l_curroipl_row ben_cobj_cache.g_oipl_inst_row;
10835: l_curroiplip_row ben_cobj_cache.g_oiplip_inst_row;
10836: l_oipl_id NUMBER;
10837: l_oiplip_id NUMBER;
10838: l_loop_count NUMBER := 1;

Line 10835: l_curroiplip_row ben_cobj_cache.g_oiplip_inst_row;

10831: l_ptip_rec ben_ptip_f%ROWTYPE;
10832: l_comp_rec g_cache_structure;
10833: l_oiplip_rec g_cache_structure;
10834: l_curroipl_row ben_cobj_cache.g_oipl_inst_row;
10835: l_curroiplip_row ben_cobj_cache.g_oiplip_inst_row;
10836: l_oipl_id NUMBER;
10837: l_oiplip_id NUMBER;
10838: l_loop_count NUMBER := 1;
10839: --FONM

Line 10990: ben_cobj_cache.get_oipl_dets(p_business_group_id=> p_business_group_id

10986: --
10987: --hr_utility.set_location(' p_comp_obj_tree_row.oipl_id '||p_comp_obj_tree_row.oipl_id ,55);
10988: IF p_comp_obj_tree_row.oipl_id IS NOT NULL THEN
10989: --
10990: ben_cobj_cache.get_oipl_dets(p_business_group_id=> p_business_group_id
10991: ,p_effective_date => g_fonm_cvg_strt_dt -- FONM p_effective_date
10992: ,p_oipl_id => p_comp_obj_tree_row.oipl_id
10993: ,p_inst_row => l_curroipl_row);
10994: --

Line 11001: ben_cobj_cache.get_oiplip_dets(p_business_group_id=> p_business_group_id

10997: --hr_utility.set_location(' p_comp_obj_tree_row.oiplip_id '||p_comp_obj_tree_row.oiplip_id ,55);
10998: --
10999: IF p_comp_obj_tree_row.oiplip_id IS NOT NULL THEN
11000: --
11001: ben_cobj_cache.get_oiplip_dets(p_business_group_id=> p_business_group_id
11002: ,p_effective_date => NVL(g_fonm_cvg_strt_dt, p_effective_date)
11003: ,p_oiplip_id => p_comp_obj_tree_row.oiplip_id
11004: ,p_inst_row => l_curroiplip_row);
11005: --