DBA Data[Home] [Help]

APPS.PQH_FR_CR_PATH_ENGINE_PKG dependencies on BEN_EVALUATE_ELIG_PROFILES

Line 68: p_score_tab out nocopy ben_evaluate_elig_profiles.scoreTab

64: p_par_pl_id in number default null,
65: p_par_plip_id in number default null,
66: p_par_opt_id in number default null,
67: p_return_status out nocopy varchar2,
68: p_score_tab out nocopy ben_evaluate_elig_profiles.scoreTab
69: ) is
70:
71: l_proc varchar2(60) := g_package||'check_eligibility';
72:

Line 81: l_score_tab ben_evaluate_elig_profiles.scoreTab;

77: l_empasg_row per_all_assignments_f%ROWTYPE;
78: l_benasg_row per_all_assignments_f%ROWTYPE;
79: l_pil_row ben_per_in_ler%ROWTYPE;
80: l_oiplip_rec ben_derive_part_and_rate_facts.g_cache_structure;
81: l_score_tab ben_evaluate_elig_profiles.scoreTab;
82:
83: begin
84: hr_utility.set_location('Entering into '||l_proc,5);
85: hr_utility.set_location('Clearing Cache '||l_proc,5);

Line 177: l_elig_return_status := ben_evaluate_elig_profiles.eligible

173: ,p_oiplip_rec => l_oiplip_rec);
174:
175: hr_utility.set_location('Checking Eligibiltiy ',5);
176:
177: l_elig_return_status := ben_evaluate_elig_profiles.eligible
178: (
179: p_person_id => p_person_id
180: ,p_business_group_id => p_business_group_id
181: ,p_effective_date => p_effective_date

Line 556: p_score_tab in ben_evaluate_elig_profiles.scoreTab

552: p_pl_id in number default null,
553: p_plip_id in number default null,
554: p_ptip_id in number default null,
555: p_opt_id in number default null,
556: p_score_tab in ben_evaluate_elig_profiles.scoreTab
557: ) is
558: l_number_of_rows number;
559: l_elig_per_id number;
560: l_effective_start_date date;

Line 667: l_score_tab ben_evaluate_elig_profiles.scoreTab;

663: l_proc varchar2(60) := g_package||'get_career_paths';
664: l_cur_corp_id number;
665: l_cur_grade_id number;
666: l_cur_step_id number;
667: l_score_tab ben_evaluate_elig_profiles.scoreTab;
668:
669:
670: cursor career_paths is
671: select ghn.Information9 to_corp_Id,