APPS.BEN_EVALUATE_ELIG_PROFILES dependencies on PQH_POPL_CRITERIA_OVRRD

Line 8959: l_crit_ovrrd_val_rec pqh_popl_criteria_ovrrd.g_crit_ovrrd_val_rec;

8955: l_event_type varchar2(255);
8956: l_perf_rtng_cd varchar2(255);
8957: l_leaving_reason varchar2(255);
8958: l_postal_code varchar2(255);
8959: l_crit_ovrrd_val_rec pqh_popl_criteria_ovrrd.g_crit_ovrrd_val_rec;
8960: l_crit_ovrrd_val_tab pqh_popl_criteria_ovrrd.g_crit_ovrrd_val_tbl;
8961: l_profile_score_tab scoreTab;
8962: l_prof_score_compute boolean := false;
8963:

Line 8960: l_crit_ovrrd_val_tab pqh_popl_criteria_ovrrd.g_crit_ovrrd_val_tbl;

8956: l_perf_rtng_cd varchar2(255);
8957: l_leaving_reason varchar2(255);
8958: l_postal_code varchar2(255);
8959: l_crit_ovrrd_val_rec pqh_popl_criteria_ovrrd.g_crit_ovrrd_val_rec;
8960: l_crit_ovrrd_val_tab pqh_popl_criteria_ovrrd.g_crit_ovrrd_val_tbl;
8961: l_profile_score_tab scoreTab;
8962: l_prof_score_compute boolean := false;
8963:
8964: cursor c_elgy_prfl(p_eligy_prfl_id number,

Line 9108: if not (pqh_popl_criteria_ovrrd.g_criteria_count>0) then

9104: begin
9105:
9106: hr_utility.set_location('Entering :'||l_proc,10);
9107:
9108: if not (pqh_popl_criteria_ovrrd.g_criteria_count>0) then
9109: hr_utility.set_location('No overridden values',10);
9110: hr_utility.set_location('Leaving :'||l_proc,10);
9111: return;
9112: end if;

Line 9114: hr_utility.set_location('Overridden count '||pqh_popl_criteria_ovrrd.g_criteria_override_val.count,10);

9110: hr_utility.set_location('Leaving :'||l_proc,10);
9111: return;
9112: end if;
9113:
9114: hr_utility.set_location('Overridden count '||pqh_popl_criteria_ovrrd.g_criteria_override_val.count,10);
9115:
9116: for i in 1..pqh_popl_criteria_ovrrd.g_criteria_override_val.count
9117: loop
9118: l_crit_ovrrd_val_rec := pqh_popl_criteria_ovrrd.g_criteria_override_val(i);

Line 9116: for i in 1..pqh_popl_criteria_ovrrd.g_criteria_override_val.count

9112: end if;
9113:
9114: hr_utility.set_location('Overridden count '||pqh_popl_criteria_ovrrd.g_criteria_override_val.count,10);
9115:
9116: for i in 1..pqh_popl_criteria_ovrrd.g_criteria_override_val.count
9117: loop
9118: l_crit_ovrrd_val_rec := pqh_popl_criteria_ovrrd.g_criteria_override_val(i);
9119: hr_utility.set_location('Short code '||l_crit_ovrrd_val_rec.criteria_short_code,10);
9120: if l_crit_ovrrd_val_rec.criteria_short_code is null then

Line 9118: l_crit_ovrrd_val_rec := pqh_popl_criteria_ovrrd.g_criteria_override_val(i);

9114: hr_utility.set_location('Overridden count '||pqh_popl_criteria_ovrrd.g_criteria_override_val.count,10);
9115:
9116: for i in 1..pqh_popl_criteria_ovrrd.g_criteria_override_val.count
9117: loop
9118: l_crit_ovrrd_val_rec := pqh_popl_criteria_ovrrd.g_criteria_override_val(i);
9119: hr_utility.set_location('Short code '||l_crit_ovrrd_val_rec.criteria_short_code,10);
9120: if l_crit_ovrrd_val_rec.criteria_short_code is null then
9121: exit;
9122: end if;