DBA Data[Home] [Help]

APPS.BEN_TCS_STMT_PROCESS dependencies on BEN_EVALUATE_ELIG_PROFILES

Line 2367: l_score_tab ben_evaluate_elig_profiles.scoretab;

2363: l_person_ids g_number_type := g_number_type();
2364: l_stmt_ids g_number_type := g_number_type();
2365: l_perd_ids g_number_type := g_number_type();
2366: l_bg_ids g_number_type := g_number_type();
2367: l_score_tab ben_evaluate_elig_profiles.scoretab;
2368: l_item_cnt NUMBER :=1;
2369: t_prof_tbl ben_evaluate_elig_profiles.proftab;
2370: l_status BOOLEAN;
2371: All_Bg VARCHAR(10) := 'N';

Line 2369: t_prof_tbl ben_evaluate_elig_profiles.proftab;

2365: l_perd_ids g_number_type := g_number_type();
2366: l_bg_ids g_number_type := g_number_type();
2367: l_score_tab ben_evaluate_elig_profiles.scoretab;
2368: l_item_cnt NUMBER :=1;
2369: t_prof_tbl ben_evaluate_elig_profiles.proftab;
2370: l_status BOOLEAN;
2371: All_Bg VARCHAR(10) := 'N';
2372: l_person_temp NUMBER := 0 ;
2373: p_bg_name VARCHAR(240);

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

2793: t_prof_tbl (1).eligy_prfl_id := stmt_rec.ee_id ;
2794: hr_utility.set_location( 'valid eligy id'|| temp_ee_id ,166) ;
2795: BEGIN
2796: IF (temp_ee_id is not null ) THEN
2797: hr_utility.set_location('before calling ben_evaluate_elig_profiles.eligible...',167);
2798:
2799: ben_env_object.init(
2800: p_business_group_id=>l_business_group_id,
2801: p_effective_date =>l_period_end_date,

Line 2810: ben_evaluate_elig_profiles.eligible

2806: p_benefit_action_id => l_benefit_action_id
2807: );
2808:
2809: l_elig_return_status :=
2810: ben_evaluate_elig_profiles.eligible
2811: (p_person_id => p_person_id,
2812: p_business_group_id => l_business_group_id,
2813: p_effective_date => l_period_end_date,
2814: p_eligprof_tab => t_prof_tbl,

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

2815: p_comp_obj_mode => FALSE,
2816: p_score_tab => l_score_tab
2817: );
2818:
2819: hr_utility.set_location('After ben_evaluate_elig_profiles.eligible...',168);
2820: ELSE
2821: l_elig_return_status := TRUE ;
2822: END IF;
2823: EXCEPTION

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

2976: p_max_errors => l_max_errors_allowed,
2977: p_benefit_action_id => l_benefit_action_id
2978: );
2979:
2980: hr_utility.set_location('before calling ben_evaluate_elig_profiles.eligible...' ,174);
2981: l_elig_return_status :=
2982: ben_evaluate_elig_profiles.eligible
2983: (p_person_id => per_rec.person_id,
2984: p_business_group_id => stmt_rec.bg_id ,

Line 2982: ben_evaluate_elig_profiles.eligible

2978: );
2979:
2980: hr_utility.set_location('before calling ben_evaluate_elig_profiles.eligible...' ,174);
2981: l_elig_return_status :=
2982: ben_evaluate_elig_profiles.eligible
2983: (p_person_id => per_rec.person_id,
2984: p_business_group_id => stmt_rec.bg_id ,
2985: p_effective_date => l_period_end_date,
2986: p_eligprof_tab => t_prof_tbl,

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

2986: p_eligprof_tab => t_prof_tbl,
2987: p_comp_obj_mode => FALSE,
2988: p_score_tab => l_score_tab
2989: );
2990: hr_utility.set_location('after ben_evaluate_elig_profiles.eligible...',175);
2991: ELSE
2992: l_elig_return_status := TRUE ;
2993: END IF;
2994:

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

3129: p_threads => l_threads ,
3130: p_max_errors => l_max_errors_allowed,
3131: p_benefit_action_id => l_benefit_action_id
3132: );
3133: hr_utility.set_location('Before calling ben_evaluate_elig_profiles.eligible...',183);
3134: l_elig_return_status :=
3135: ben_evaluate_elig_profiles.eligible
3136: (p_person_id => per_rec.person_id,
3137: p_business_group_id => stmt_record_rec (l_loop_cnt).statement_rec.bg_id ,

Line 3135: ben_evaluate_elig_profiles.eligible

3131: p_benefit_action_id => l_benefit_action_id
3132: );
3133: hr_utility.set_location('Before calling ben_evaluate_elig_profiles.eligible...',183);
3134: l_elig_return_status :=
3135: ben_evaluate_elig_profiles.eligible
3136: (p_person_id => per_rec.person_id,
3137: p_business_group_id => stmt_record_rec (l_loop_cnt).statement_rec.bg_id ,
3138: p_effective_date => l_period_end_date,
3139: p_eligprof_tab => t_prof_tbl,