APPS.BEN_TCS_STMT_PROCESS dependencies on BEN_EVALUATE_ELIG_PROFILES

Line 2336: l_score_tab ben_evaluate_elig_profiles.scoretab;

2332: l_person_ids g_number_type := g_number_type();
2333: l_stmt_ids g_number_type := g_number_type();
2334: l_perd_ids g_number_type := g_number_type();
2335: l_bg_ids g_number_type := g_number_type();
2336: l_score_tab ben_evaluate_elig_profiles.scoretab;
2337: l_item_cnt NUMBER :=1;
2338: t_prof_tbl ben_evaluate_elig_profiles.proftab;
2339: l_status BOOLEAN;
2340: All_Bg VARCHAR(10) := 'N';

Line 2338: t_prof_tbl ben_evaluate_elig_profiles.proftab;

2334: l_perd_ids g_number_type := g_number_type();
2335: l_bg_ids g_number_type := g_number_type();
2336: l_score_tab ben_evaluate_elig_profiles.scoretab;
2337: l_item_cnt NUMBER :=1;
2338: t_prof_tbl ben_evaluate_elig_profiles.proftab;
2339: l_status BOOLEAN;
2340: All_Bg VARCHAR(10) := 'N';
2341: l_person_temp NUMBER := 0 ;
2342: p_bg_name VARCHAR(240);

Line 2766: hr_utility.set_location('before calling ben_evaluate_elig_profiles.eligible...',167);

2762: t_prof_tbl (1).eligy_prfl_id := stmt_rec.ee_id ;
2763: hr_utility.set_location( 'valid eligy id'|| temp_ee_id ,166) ;
2764: BEGIN
2765: IF (temp_ee_id is not null ) THEN
2766: hr_utility.set_location('before calling ben_evaluate_elig_profiles.eligible...',167);
2767:
2768: ben_env_object.init(
2769: p_business_group_id=>l_business_group_id,
2770: p_effective_date =>l_period_end_date,

Line 2779: ben_evaluate_elig_profiles.eligible

2775: p_benefit_action_id => l_benefit_action_id
2776: );
2777:
2778: l_elig_return_status :=
2779: ben_evaluate_elig_profiles.eligible
2780: (p_person_id => p_person_id,
2781: p_business_group_id => l_business_group_id,
2782: p_effective_date => l_period_end_date,
2783: p_eligprof_tab => t_prof_tbl,

Line 2788: hr_utility.set_location('After ben_evaluate_elig_profiles.eligible...',168);

2784: p_comp_obj_mode => FALSE,
2785: p_score_tab => l_score_tab
2786: );
2787:
2788: hr_utility.set_location('After ben_evaluate_elig_profiles.eligible...',168);
2789: ELSE
2790: l_elig_return_status := TRUE ;
2791: END IF;
2792: EXCEPTION

Line 2949: hr_utility.set_location('before calling ben_evaluate_elig_profiles.eligible...' ,174);

2945: p_max_errors => l_max_errors_allowed,
2946: p_benefit_action_id => l_benefit_action_id
2947: );
2948:
2949: hr_utility.set_location('before calling ben_evaluate_elig_profiles.eligible...' ,174);
2950: l_elig_return_status :=
2951: ben_evaluate_elig_profiles.eligible
2952: (p_person_id => per_rec.person_id,
2953: p_business_group_id => stmt_rec.bg_id ,

Line 2951: ben_evaluate_elig_profiles.eligible

2947: );
2948:
2949: hr_utility.set_location('before calling ben_evaluate_elig_profiles.eligible...' ,174);
2950: l_elig_return_status :=
2951: ben_evaluate_elig_profiles.eligible
2952: (p_person_id => per_rec.person_id,
2953: p_business_group_id => stmt_rec.bg_id ,
2954: p_effective_date => l_period_end_date,
2955: p_eligprof_tab => t_prof_tbl,

Line 2959: hr_utility.set_location('after ben_evaluate_elig_profiles.eligible...',175);

2955: p_eligprof_tab => t_prof_tbl,
2956: p_comp_obj_mode => FALSE,
2957: p_score_tab => l_score_tab
2958: );
2959: hr_utility.set_location('after ben_evaluate_elig_profiles.eligible...',175);
2960: ELSE
2961: l_elig_return_status := TRUE ;
2962: END IF;
2963:

Line 3102: hr_utility.set_location('Before calling ben_evaluate_elig_profiles.eligible...',183);

3098: p_threads => l_threads ,
3099: p_max_errors => l_max_errors_allowed,
3100: p_benefit_action_id => l_benefit_action_id
3101: );
3102: hr_utility.set_location('Before calling ben_evaluate_elig_profiles.eligible...',183);
3103: l_elig_return_status :=
3104: ben_evaluate_elig_profiles.eligible
3105: (p_person_id => per_rec.person_id,
3106: p_business_group_id => stmt_record_rec (l_loop_cnt).statement_rec.bg_id ,

Line 3104: ben_evaluate_elig_profiles.eligible

3100: p_benefit_action_id => l_benefit_action_id
3101: );
3102: hr_utility.set_location('Before calling ben_evaluate_elig_profiles.eligible...',183);
3103: l_elig_return_status :=
3104: ben_evaluate_elig_profiles.eligible
3105: (p_person_id => per_rec.person_id,
3106: p_business_group_id => stmt_record_rec (l_loop_cnt).statement_rec.bg_id ,
3107: p_effective_date => l_period_end_date,
3108: p_eligprof_tab => t_prof_tbl,