APPS.BEN_EVALUATE_ELIG_PROFILES dependencies on PQH_POPL_CRITERIA_OVRRD

Line 8978: l_crit_ovrrd_val_rec pqh_popl_criteria_ovrrd.g_crit_ovrrd_val_rec;

8974: l_event_type varchar2(255);
8975: l_perf_rtng_cd varchar2(255);
8976: l_leaving_reason varchar2(255);
8977: l_postal_code varchar2(255);
8978: l_crit_ovrrd_val_rec pqh_popl_criteria_ovrrd.g_crit_ovrrd_val_rec;
8979: l_crit_ovrrd_val_tab pqh_popl_criteria_ovrrd.g_crit_ovrrd_val_tbl;
8980: l_profile_score_tab scoreTab;
8981: l_prof_score_compute boolean := false;
8982:

Line 8979: l_crit_ovrrd_val_tab pqh_popl_criteria_ovrrd.g_crit_ovrrd_val_tbl;

8975: l_perf_rtng_cd varchar2(255);
8976: l_leaving_reason varchar2(255);
8977: l_postal_code varchar2(255);
8978: l_crit_ovrrd_val_rec pqh_popl_criteria_ovrrd.g_crit_ovrrd_val_rec;
8979: l_crit_ovrrd_val_tab pqh_popl_criteria_ovrrd.g_crit_ovrrd_val_tbl;
8980: l_profile_score_tab scoreTab;
8981: l_prof_score_compute boolean := false;
8982:
8983: cursor c_elgy_prfl(p_eligy_prfl_id number,

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

9123: begin
9124:
9125: hr_utility.set_location('Entering :'||l_proc,10);
9126:
9127: if not (pqh_popl_criteria_ovrrd.g_criteria_count>0) then
9128: hr_utility.set_location('No overridden values',10);
9129: hr_utility.set_location('Leaving :'||l_proc,10);
9130: return;
9131: end if;

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

9129: hr_utility.set_location('Leaving :'||l_proc,10);
9130: return;
9131: end if;
9132:
9133: hr_utility.set_location('Overridden count '||pqh_popl_criteria_ovrrd.g_criteria_override_val.count,10);
9134:
9135: for i in 1..pqh_popl_criteria_ovrrd.g_criteria_override_val.count
9136: loop
9137: l_crit_ovrrd_val_rec := pqh_popl_criteria_ovrrd.g_criteria_override_val(i);

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

9131: end if;
9132:
9133: hr_utility.set_location('Overridden count '||pqh_popl_criteria_ovrrd.g_criteria_override_val.count,10);
9134:
9135: for i in 1..pqh_popl_criteria_ovrrd.g_criteria_override_val.count
9136: loop
9137: l_crit_ovrrd_val_rec := pqh_popl_criteria_ovrrd.g_criteria_override_val(i);
9138: hr_utility.set_location('Short code '||l_crit_ovrrd_val_rec.criteria_short_code,10);
9139: if l_crit_ovrrd_val_rec.criteria_short_code is null then

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

9133: hr_utility.set_location('Overridden count '||pqh_popl_criteria_ovrrd.g_criteria_override_val.count,10);
9134:
9135: for i in 1..pqh_popl_criteria_ovrrd.g_criteria_override_val.count
9136: loop
9137: l_crit_ovrrd_val_rec := pqh_popl_criteria_ovrrd.g_criteria_override_val(i);
9138: hr_utility.set_location('Short code '||l_crit_ovrrd_val_rec.criteria_short_code,10);
9139: if l_crit_ovrrd_val_rec.criteria_short_code is null then
9140: exit;
9141: end if;