APPS.OTA_ELIG_PROFILE_UTIL dependencies on BEN_EVALUATE_ELIG_PROFILES

Line 288: l_eligprof_tab ben_evaluate_elig_profiles.proftab;

284: csr_get_ug_to_be_processed learner_assign_details;
285:
286: ug_ep_whereclause varchar2(200);
287: get_ug_to_be_processed varchar2(4000);
288: l_eligprof_tab ben_evaluate_elig_profiles.proftab;
289: l_score_tab ben_evaluate_elig_profiles.scoreTab;
290: begin
291:
292: if p_learner_group_id is not null and p_elig_prof_id is not null then

Line 289: l_score_tab ben_evaluate_elig_profiles.scoreTab;

285:
286: ug_ep_whereclause varchar2(200);
287: get_ug_to_be_processed varchar2(4000);
288: l_eligprof_tab ben_evaluate_elig_profiles.proftab;
289: l_score_tab ben_evaluate_elig_profiles.scoreTab;
290: begin
291:
292: if p_learner_group_id is not null and p_elig_prof_id is not null then
293: ug_ep_whereclause := 'user_group_id = ' ||TO_CHAR(p_learner_group_id)

Line 427: IF ben_evaluate_elig_profiles.eligible

423:
424:
425: if lrnr_rec.business_group_id = l_elig_pro_bg_id then
426:
427: IF ben_evaluate_elig_profiles.eligible
428: (p_person_id => lrnr_rec.person_id,
429: p_assignment_id => lrnr_rec.assignment_id,
430: p_business_group_id => lrnr_rec.business_group_id,
431: p_eval_typ => 'E',

Line 888: l_eligprof_tab ben_evaluate_elig_profiles.proftab;

884: l_cnt number(5) DEFAULT 0;
885: l_per_bg_prof_val number := fnd_profile.value ('PER_BUSINESS_GROUP_ID');
886: l_ota_global_bg_prof_val number:= fnd_profile.value('OTA_HR_GLOBAL_BUSINESS_GROUP_ID');
887:
888: l_eligprof_tab ben_evaluate_elig_profiles.proftab;
889: l_score_tab ben_evaluate_elig_profiles.scoreTab;
890:
891: CURSOR c_range_thread IS
892: SELECT ran.range_id

Line 889: l_score_tab ben_evaluate_elig_profiles.scoreTab;

885: l_per_bg_prof_val number := fnd_profile.value ('PER_BUSINESS_GROUP_ID');
886: l_ota_global_bg_prof_val number:= fnd_profile.value('OTA_HR_GLOBAL_BUSINESS_GROUP_ID');
887:
888: l_eligprof_tab ben_evaluate_elig_profiles.proftab;
889: l_score_tab ben_evaluate_elig_profiles.scoreTab;
890:
891: CURSOR c_range_thread IS
892: SELECT ran.range_id
893: ,ran.starting_person_action_id

Line 1086: IF ben_evaluate_elig_profiles.eligible

1082: ,p_max_errors => NULL
1083: ,p_benefit_action_id => NULL
1084: ,p_effective_date => trunc (sysdate));
1085:
1086: IF ben_evaluate_elig_profiles.eligible
1087: (p_person_id => l_rec.person_id,
1088: p_assignment_id => l_rec.assignment_id,
1089: p_business_group_id => l_rec.mbr_bg_id,
1090: p_eval_typ => 'E',