eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PERCOMPSTATUS dependencies on PER_COMPETENCES

Line 25: l_competence_cluster per_competences_vl.competence_cluster%type;

21: and pco.date_from <= p_eff_date
22: and nvl(pco.date_to,p_eff_date) >= p_eff_date
23: group by ceo.outcome_id;
24:
25: l_competence_cluster per_competences_vl.competence_cluster%type;
26: l_noof_outcomes number;
27: p_person_id per_competence_elements.person_id%type;
28: l_status per_competence_elements.status%type;
29: l_achieved_date per_competence_elements.Achieved_date%type;

Line 31: Select competence_cluster INTO l_competence_cluster FROM per_competences_vl

27: p_person_id per_competence_elements.person_id%type;
28: l_status per_competence_elements.status%type;
29: l_achieved_date per_competence_elements.Achieved_date%type;
30: begin
31: Select competence_cluster INTO l_competence_cluster FROM per_competences_vl
32: WHERE competence_id = p_competence_id;
33: IF l_competence_cluster = 'UNIT_STANDARD' then
34: IF p_competence_element_id IS NOT NULL then
35: -- added for the 4187713 bug.

Line 210: l_competence_cluster per_competences.competence_cluster%type;

206: RETURN VARCHAR2 is
207: l_status_id per_competence_elements.status%type;
208: l_status_meaning varchar2(100);
209: l_noof_outcomes number;
210: l_competence_cluster per_competences.competence_cluster%type;
211: p_person_id per_competence_elements.person_id%type;
212: begin
213: l_status_id := PerCompStatus.Get_Competence_Status(
214: p_competence_id => p_competence_id

Line 234: l_competence_cluster per_competences_vl.competence_cluster%type;

230: ,p_competence_element_id IN NUMBER DEFAULT null
231: ,p_person_id IN number
232: ,p_eff_date in date default trunc(sysdate)
233: ) return VARCHAR2 is
234: l_competence_cluster per_competences_vl.competence_cluster%type;
235: l_noof_outcomes number;
236: l_comp_status per_competence_elements.status%type;
237: begin
238: Select competence_cluster INTO l_competence_cluster FROM per_competences_vl

Line 238: Select competence_cluster INTO l_competence_cluster FROM per_competences_vl

234: l_competence_cluster per_competences_vl.competence_cluster%type;
235: l_noof_outcomes number;
236: l_comp_status per_competence_elements.status%type;
237: begin
238: Select competence_cluster INTO l_competence_cluster FROM per_competences_vl
239: WHERE competence_id = p_competence_id;
240: IF l_competence_cluster = 'UNIT_STANDARD' then
241: IF p_competence_element_id IS NOT NULL OR p_competence_element_id > 0 then
242: l_comp_status := Get_Competence_Status(