APPS.PERCOMPSTATUS dependencies on PER_COMPETENCE_ELEMENTS

Line 27: p_person_id per_competence_elements.person_id%type;

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;
30: begin
31: Select competence_cluster INTO l_competence_cluster FROM per_competences_vl

Line 28: l_status per_competence_elements.status%type;

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;
30: begin
31: Select competence_cluster INTO l_competence_cluster FROM per_competences_vl
32: WHERE competence_id = p_competence_id;

Line 29: l_achieved_date per_competence_elements.Achieved_date%type;

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;
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

Line 39: FROM per_competence_elements pce

35: -- added for the 4187713 bug.
36: -- Getting the End date outcome rec which were achieved earlier.
37: Select pce.status, pce.Achieved_date, pce.person_id
38: INTO l_status, l_achieved_date, p_person_id
39: FROM per_competence_elements pce
40: Where pce.competence_element_id = p_competence_element_id;
41: IF l_status = 'ACHIEVED' AND l_achieved_date <= p_eff_date then
42: FOR EndDatedRec IN getEndDatedOutcomes(p_competence_element_id)
43: loop

Line 207: l_status_id per_competence_elements.status%type;

203: ,p_item_key IN VARCHAR2 DEFAULT null
204: ,p_activity_id IN VARCHAR2 DEFAULT null
205: ,p_eff_date IN DATE DEFAULT trunc(sysdate))
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;

Line 211: p_person_id per_competence_elements.person_id%type;

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
215: ,p_competence_element_id => p_competence_element_id

Line 236: l_comp_status per_competence_elements.status%type;

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
239: WHERE competence_id = p_competence_id;
240: IF l_competence_cluster = 'UNIT_STANDARD' then

Line 334: per_competence_elements pce

330: , p_person_id IN number)
331: RETURN VARCHAR2 IS
332: CURSOR getCompIds(p_qualification_type_id IN number) is
333: SELECT pce.competence_id from
334: per_competence_elements pce
335: Where pce.TYPE = 'QUALIFICATION'
336: AND pce.Qualification_type_id = p_qualification_type_id
337: AND pce.effective_date_from <= trunc(sysdate)
338: AND nvl(pce.effective_date_to,trunc(sysdate)) >= trunc(sysdate);

Line 342: per_competence_elements pce

338: AND nvl(pce.effective_date_to,trunc(sysdate)) >= trunc(sysdate);
339: Cursor getCompEleId(p_competence_id IN number
340: , p_person_id IN number) is
341: Select competence_element_id from
342: per_competence_elements pce
343: Where pce.TYPE = 'PERSONAL'
344: AND pce.competence_id = p_competence_id
345: AND pce.person_id = p_person_id
346: AND pce.effective_date_from <= trunc(sysdate)

Line 358: per_competence_elements pce

354: l_NoOfCompAchieved := 0;
355: l_TotComps := 0;
356: Select count(*) INTO l_TotComps
357: from
358: per_competence_elements pce
359: Where pce.TYPE = 'QUALIFICATION'
360: AND pce.Qualification_type_id = p_qualification_type_id
361: AND pce.effective_date_from <= trunc(sysdate)
362: AND nvl(pce.effective_date_to,trunc(sysdate)) >= trunc(sysdate);