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.PA_HR_COMPETENCE_UTILS dependencies on PER_COMPETENCE_ELEMENTS

Line 241: ( p_object_name IN per_competence_elements.object_name%TYPE

237: -- PROJECT_ROLE and OPEN_ASSIGNMENT are fetched with the object_id
238: -- while for JOB, the record is fetched with the job_id
239: -- No other values for object_name are supported currently
240: PROCEDURE get_competencies
241: ( p_object_name IN per_competence_elements.object_name%TYPE
242: ,p_object_id IN per_competence_elements.object_id%TYPE
243: ,x_competency_tbl OUT NOCOPY competency_tbl_typ /* Added NOCOPY for bug#2674619 */
244: ,x_no_of_competencies OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
245: ,x_error_message_code OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 242: ,p_object_id IN per_competence_elements.object_id%TYPE

238: -- while for JOB, the record is fetched with the job_id
239: -- No other values for object_name are supported currently
240: PROCEDURE get_competencies
241: ( p_object_name IN per_competence_elements.object_name%TYPE
242: ,p_object_id IN per_competence_elements.object_id%TYPE
243: ,x_competency_tbl OUT NOCOPY competency_tbl_typ /* Added NOCOPY for bug#2674619 */
244: ,x_no_of_competencies OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
245: ,x_error_message_code OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
246: ,x_return_status OUT NOCOPY VARCHAR2 ) IS --File.Sql.39 bug 4440895

Line 260: per_competence_elements pce,

256: pc.competence_alias ,
257: Decode(pc.business_group_id ,NULL, 'Y','N') global_flag,
258: pce.object_version_number
259: FROM
260: per_competence_elements pce,
261: per_competences pc
262: WHERE pce.object_name = p_object_name
263: AND pce.object_id = p_object_id
264: AND pce.competence_id = pc.competence_id;

Line 278: FROM per_competence_elements pce,

274: pc.name ,
275: pc.competence_alias ,
276: Decode(pc.business_group_id ,NULL, 'Y','N') global_flag,
277: pce.object_version_number
278: FROM per_competence_elements pce,
279: per_competences pc
280: WHERE job_id = p_object_id
281: AND pce.competence_id = pc.competence_id;
282: l_index NUMBER := 0;

Line 378: per_competence_elements pce,

374: pc.competence_alias ,
375: Decode(pc.business_group_id ,NULL, 'Y','N') global_flag,
376: pce.object_version_number
377: FROM
378: per_competence_elements pce,
379: per_competences pc
380: WHERE pce.person_id = p_person_id
381: AND pce.competence_id = pc.competence_id;
382:

Line 432: ( p_object_name IN per_competence_elements.object_name%TYPE

428: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
429: END get_person_competencies;
430:
431: FUNCTION check_competence_exists
432: ( p_object_name IN per_competence_elements.object_name%TYPE
433: ,p_object_id IN per_competence_elements.object_id%TYPE
434: ,p_competence_id IN per_competences.competence_id%TYPE )
435: RETURN VARCHAR2 IS
436: l_dummy VARCHAR2(1);

Line 433: ,p_object_id IN per_competence_elements.object_id%TYPE

429: END get_person_competencies;
430:
431: FUNCTION check_competence_exists
432: ( p_object_name IN per_competence_elements.object_name%TYPE
433: ,p_object_id IN per_competence_elements.object_id%TYPE
434: ,p_competence_id IN per_competences.competence_id%TYPE )
435: RETURN VARCHAR2 IS
436: l_dummy VARCHAR2(1);
437: BEGIN

Line 439: FROM per_competence_elements

435: RETURN VARCHAR2 IS
436: l_dummy VARCHAR2(1);
437: BEGIN
438: SELECT 'x' INTO l_dummy
439: FROM per_competence_elements
440: WHERE object_id = p_object_id
441: AND object_name = p_object_name
442: AND competence_id = p_competence_id ;
443: RETURN 'Y';

Line 475: FROM PER_COMPETENCE_ELEMENTS comp_ele,

471: BULK COLLECT INTO
472: l_competence_name,
473: l_competence_alias,
474: l_competence_level
475: FROM PER_COMPETENCE_ELEMENTS comp_ele,
476: PER_COMPETENCES comp,
477: PER_RATING_LEVELS rl
478: WHERE comp_ele.competence_id = comp.competence_id
479: AND comp_ele.person_id = p_person_id

Line 520: FROM PER_COMPETENCE_ELEMENTS

516: l_count NUMBER;
517: BEGIN
518: SELECT count(*)
519: INTO l_count
520: FROM PER_COMPETENCE_ELEMENTS
521: WHERE person_id = p_person_id;
522:
523: RETURN l_count;
524: EXCEPTION

Line 538: FROM PER_COMPETENCE_ELEMENTS

534: l_date DATE;
535: BEGIN
536: SELECT MAX(last_update_date)
537: INTO l_date
538: FROM PER_COMPETENCE_ELEMENTS
539: WHERE person_id = p_person_id;
540:
541: RETURN l_date;
542: EXCEPTION