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_COMPETENCES

Line 17: ( p_competence_id IN per_competences.competence_id%TYPE

13: -- 27-JUN-2000 R. Krishnamurthy Created
14: --
15:
16: procedure Check_Rating_Level_Or_Id
17: ( p_competence_id IN per_competences.competence_id%TYPE
18: ,p_rating_level_id IN per_rating_levels.rating_level_id%TYPE
19: ,p_rating_level IN per_rating_levels.step_value%TYPE
20: ,p_check_id_flag IN VARCHAR2
21: ,x_rating_level_id OUT NOCOPY per_rating_levels.rating_level_id%TYPE --File.Sql.39 bug 4440895

Line 108: ( p_competence_id IN per_competences.competence_id%TYPE

104: RAISE;
105: END Check_Rating_Level_Or_Id;
106:
107: PROCEDURE Check_CompName_Or_Id
108: ( p_competence_id IN per_competences.competence_id%TYPE
109: ,p_competence_alias IN per_competences.competence_alias%TYPE
110: ,p_competence_name IN per_competences.name%TYPE := null
111: ,p_check_id_flag IN VARCHAR2
112: ,x_competence_id OUT NOCOPY per_competences.competence_id%TYPE --File.Sql.39 bug 4440895

Line 109: ,p_competence_alias IN per_competences.competence_alias%TYPE

105: END Check_Rating_Level_Or_Id;
106:
107: PROCEDURE Check_CompName_Or_Id
108: ( p_competence_id IN per_competences.competence_id%TYPE
109: ,p_competence_alias IN per_competences.competence_alias%TYPE
110: ,p_competence_name IN per_competences.name%TYPE := null
111: ,p_check_id_flag IN VARCHAR2
112: ,x_competence_id OUT NOCOPY per_competences.competence_id%TYPE --File.Sql.39 bug 4440895
113: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 110: ,p_competence_name IN per_competences.name%TYPE := null

106:
107: PROCEDURE Check_CompName_Or_Id
108: ( p_competence_id IN per_competences.competence_id%TYPE
109: ,p_competence_alias IN per_competences.competence_alias%TYPE
110: ,p_competence_name IN per_competences.name%TYPE := null
111: ,p_check_id_flag IN VARCHAR2
112: ,x_competence_id OUT NOCOPY per_competences.competence_id%TYPE --File.Sql.39 bug 4440895
113: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
114: ,x_error_msg_code OUT NOCOPY VARCHAR2 ) IS --File.Sql.39 bug 4440895

Line 112: ,x_competence_id OUT NOCOPY per_competences.competence_id%TYPE --File.Sql.39 bug 4440895

108: ( p_competence_id IN per_competences.competence_id%TYPE
109: ,p_competence_alias IN per_competences.competence_alias%TYPE
110: ,p_competence_name IN per_competences.name%TYPE := null
111: ,p_check_id_flag IN VARCHAR2
112: ,x_competence_id OUT NOCOPY per_competences.competence_id%TYPE --File.Sql.39 bug 4440895
113: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
114: ,x_error_msg_code OUT NOCOPY VARCHAR2 ) IS --File.Sql.39 bug 4440895
115:
116: l_current_id NUMBER := NULL;

Line 122: FROM per_competences

118: l_id_found_flag VARCHAR(1) := 'N';
119:
120: CURSOR c_ids IS
121: SELECT competence_id
122: FROM per_competences
123: WHERE name = p_competence_name;
124: BEGIN
125: pa_debug.init_err_stack ('pa_competence_utils.check_compName_or_id');
126: IF p_competence_id IS NOT NULL THEN

Line 130: FROM per_competences

126: IF p_competence_id IS NOT NULL THEN
127: IF (p_check_id_flag = 'Y') THEN
128: SELECT competence_id
129: INTO x_competence_id
130: FROM per_competences
131: WHERE competence_id = p_competence_id;
132: ELSIF (p_check_id_flag = 'N') THEN
133: x_competence_id := p_competence_id;
134: ELSIF (p_check_id_flag = 'A') THEN

Line 168: FROM per_competences

164: END IF;
165: ELSIF (p_competence_alias is not null) THEN
166: SELECT competence_id
167: INTO x_competence_id
168: FROM per_competences
169: WHERE competence_alias = p_competence_alias;
170: ELSE
171: IF (p_competence_name IS NOT NULL) THEN
172: SELECT competence_id

Line 174: FROM per_competences

170: ELSE
171: IF (p_competence_name IS NOT NULL) THEN
172: SELECT competence_id
173: INTO x_competence_id
174: FROM per_competences
175: WHERE name = p_competence_name;
176: ELSE
177: x_competence_id := NULL;
178: END IF;

Line 261: per_competences pc

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

Line 279: per_competences pc

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;
283: l_competence_exists VARCHAR2(1);

Line 379: per_competences pc

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:
383: l_index NUMBER := 0;

Line 434: ,p_competence_id IN per_competences.competence_id%TYPE )

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
438: SELECT 'x' INTO l_dummy

Line 476: PER_COMPETENCES comp,

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
480: AND comp_ele.proficiency_level_id = rl.rating_level_id (+);