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_COMP_PROFILE_PUB dependencies on PER_COMPETENCES

Line 8: p_person_id IN per_competences.competence_id%TYPE := FND_API.G_MISS_NUM,

4: -- Forward declaration of validate_attributes procedure
5: PROCEDURE validate_attributes
6: (
7: p_element_id IN NUMBER := null,
8: p_person_id IN per_competences.competence_id%TYPE := FND_API.G_MISS_NUM,
9: p_competence_id IN per_competences.competence_id%TYPE := FND_API.G_MISS_NUM,
10: p_competence_alias IN per_competences.competence_alias%TYPE := FND_API.G_MISS_CHAR,
11: p_competence_name IN per_competences.name%TYPE := FND_API.G_MISS_CHAR,
12: p_rating_level_id IN per_competence_elements.rating_level_id%TYPE := FND_API.G_MISS_NUM,

Line 9: p_competence_id IN per_competences.competence_id%TYPE := FND_API.G_MISS_NUM,

5: PROCEDURE validate_attributes
6: (
7: p_element_id IN NUMBER := null,
8: p_person_id IN per_competences.competence_id%TYPE := FND_API.G_MISS_NUM,
9: p_competence_id IN per_competences.competence_id%TYPE := FND_API.G_MISS_NUM,
10: p_competence_alias IN per_competences.competence_alias%TYPE := FND_API.G_MISS_CHAR,
11: p_competence_name IN per_competences.name%TYPE := FND_API.G_MISS_CHAR,
12: p_rating_level_id IN per_competence_elements.rating_level_id%TYPE := FND_API.G_MISS_NUM,
13: p_rating_level_value IN per_rating_levels.step_value%TYPE := FND_API.G_MISS_NUM,

Line 10: p_competence_alias IN per_competences.competence_alias%TYPE := FND_API.G_MISS_CHAR,

6: (
7: p_element_id IN NUMBER := null,
8: p_person_id IN per_competences.competence_id%TYPE := FND_API.G_MISS_NUM,
9: p_competence_id IN per_competences.competence_id%TYPE := FND_API.G_MISS_NUM,
10: p_competence_alias IN per_competences.competence_alias%TYPE := FND_API.G_MISS_CHAR,
11: p_competence_name IN per_competences.name%TYPE := FND_API.G_MISS_CHAR,
12: p_rating_level_id IN per_competence_elements.rating_level_id%TYPE := FND_API.G_MISS_NUM,
13: p_rating_level_value IN per_rating_levels.step_value%TYPE := FND_API.G_MISS_NUM,
14: p_effective_date_from IN DATE := FND_API.G_MISS_DATE,

Line 11: p_competence_name IN per_competences.name%TYPE := FND_API.G_MISS_CHAR,

7: p_element_id IN NUMBER := null,
8: p_person_id IN per_competences.competence_id%TYPE := FND_API.G_MISS_NUM,
9: p_competence_id IN per_competences.competence_id%TYPE := FND_API.G_MISS_NUM,
10: p_competence_alias IN per_competences.competence_alias%TYPE := FND_API.G_MISS_CHAR,
11: p_competence_name IN per_competences.name%TYPE := FND_API.G_MISS_CHAR,
12: p_rating_level_id IN per_competence_elements.rating_level_id%TYPE := FND_API.G_MISS_NUM,
13: p_rating_level_value IN per_rating_levels.step_value%TYPE := FND_API.G_MISS_NUM,
14: p_effective_date_from IN DATE := FND_API.G_MISS_DATE,
15: p_operation IN VARCHAR2,

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

13: p_rating_level_value IN per_rating_levels.step_value%TYPE := FND_API.G_MISS_NUM,
14: p_effective_date_from IN DATE := FND_API.G_MISS_DATE,
15: p_operation IN VARCHAR2,
16: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
17: x_competence_id OUT NOCOPY per_competences.competence_id%TYPE, --File.Sql.39 bug 4440895
18: x_rating_level_id OUT NOCOPY per_competence_elements.rating_level_id%TYPE, --File.Sql.39 bug 4440895
19: x_effective_date_from OUT NOCOPY DATE); --File.Sql.39 bug 4440895
20:
21: /* --------------------------------------------------------------------

Line 29: p_competence_id IN per_competences.competence_id%TYPE,

25:
26: PROCEDURE Add_competence_element
27: (
28: p_person_id IN per_competence_elements.person_id%TYPE,
29: p_competence_id IN per_competences.competence_id%TYPE,
30: p_competence_alias IN per_competences.competence_alias%TYPE := FND_API.G_MISS_CHAR,
31: p_competence_name IN per_competences.name%TYPE := FND_API.G_MISS_CHAR,
32: p_rating_level_id IN per_competence_elements.rating_level_id%TYPE := FND_API.G_MISS_NUM,
33: p_rating_level_value IN per_rating_levels.step_value%TYPE := FND_API.G_MISS_NUM,

Line 30: p_competence_alias IN per_competences.competence_alias%TYPE := FND_API.G_MISS_CHAR,

26: PROCEDURE Add_competence_element
27: (
28: p_person_id IN per_competence_elements.person_id%TYPE,
29: p_competence_id IN per_competences.competence_id%TYPE,
30: p_competence_alias IN per_competences.competence_alias%TYPE := FND_API.G_MISS_CHAR,
31: p_competence_name IN per_competences.name%TYPE := FND_API.G_MISS_CHAR,
32: p_rating_level_id IN per_competence_elements.rating_level_id%TYPE := FND_API.G_MISS_NUM,
33: p_rating_level_value IN per_rating_levels.step_value%TYPE := FND_API.G_MISS_NUM,
34: p_effective_date_from IN DATE := FND_API.G_MISS_DATE,

Line 31: p_competence_name IN per_competences.name%TYPE := FND_API.G_MISS_CHAR,

27: (
28: p_person_id IN per_competence_elements.person_id%TYPE,
29: p_competence_id IN per_competences.competence_id%TYPE,
30: p_competence_alias IN per_competences.competence_alias%TYPE := FND_API.G_MISS_CHAR,
31: p_competence_name IN per_competences.name%TYPE := FND_API.G_MISS_CHAR,
32: p_rating_level_id IN per_competence_elements.rating_level_id%TYPE := FND_API.G_MISS_NUM,
33: p_rating_level_value IN per_rating_levels.step_value%TYPE := FND_API.G_MISS_NUM,
34: p_effective_date_from IN DATE := FND_API.G_MISS_DATE,
35: p_init_msg_list IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 200: p_competence_id IN per_competences.competence_id%TYPE := FND_API.G_MISS_NUM,

196:
197: PROCEDURE Update_competence_element
198: (
199: p_person_id IN per_competence_elements.person_id%TYPE := FND_API.G_MISS_NUM,
200: p_competence_id IN per_competences.competence_id%TYPE := FND_API.G_MISS_NUM,
201: p_competence_alias IN per_competences.competence_alias%TYPE := FND_API.G_MISS_CHAR,
202: p_competence_name IN per_competences.name%TYPE := FND_API.G_MISS_CHAR,
203: p_element_id IN per_competence_elements.competence_element_id%TYPE := FND_API.G_MISS_NUM,
204: p_rating_level_id IN per_competence_elements.rating_level_id%TYPE := FND_API.G_MISS_NUM,

Line 201: p_competence_alias IN per_competences.competence_alias%TYPE := FND_API.G_MISS_CHAR,

197: PROCEDURE Update_competence_element
198: (
199: p_person_id IN per_competence_elements.person_id%TYPE := FND_API.G_MISS_NUM,
200: p_competence_id IN per_competences.competence_id%TYPE := FND_API.G_MISS_NUM,
201: p_competence_alias IN per_competences.competence_alias%TYPE := FND_API.G_MISS_CHAR,
202: p_competence_name IN per_competences.name%TYPE := FND_API.G_MISS_CHAR,
203: p_element_id IN per_competence_elements.competence_element_id%TYPE := FND_API.G_MISS_NUM,
204: p_rating_level_id IN per_competence_elements.rating_level_id%TYPE := FND_API.G_MISS_NUM,
205: p_rating_level_value IN per_rating_levels.step_value%TYPE := FND_API.G_MISS_NUM,

Line 202: p_competence_name IN per_competences.name%TYPE := FND_API.G_MISS_CHAR,

198: (
199: p_person_id IN per_competence_elements.person_id%TYPE := FND_API.G_MISS_NUM,
200: p_competence_id IN per_competences.competence_id%TYPE := FND_API.G_MISS_NUM,
201: p_competence_alias IN per_competences.competence_alias%TYPE := FND_API.G_MISS_CHAR,
202: p_competence_name IN per_competences.name%TYPE := FND_API.G_MISS_CHAR,
203: p_element_id IN per_competence_elements.competence_element_id%TYPE := FND_API.G_MISS_NUM,
204: p_rating_level_id IN per_competence_elements.rating_level_id%TYPE := FND_API.G_MISS_NUM,
205: p_rating_level_value IN per_rating_levels.step_value%TYPE := FND_API.G_MISS_NUM,
206: p_effective_date_from IN DATE := FND_API.G_MISS_DATE,

Line 445: p_person_id IN per_competences.competence_id%TYPE := FND_API.G_MISS_NUM,

441: -------------------------------------------------------------------- */
442: PROCEDURE validate_attributes
443: (
444: p_element_id IN NUMBER := null,
445: p_person_id IN per_competences.competence_id%TYPE := FND_API.G_MISS_NUM,
446: p_competence_id IN per_competences.competence_id%TYPE := FND_API.G_MISS_NUM,
447: p_competence_alias IN per_competences.competence_alias%TYPE := FND_API.G_MISS_CHAR,
448: p_competence_name IN per_competences.name%TYPE := FND_API.G_MISS_CHAR,
449: p_rating_level_id IN per_competence_elements.rating_level_id%TYPE := FND_API.G_MISS_NUM,

Line 446: p_competence_id IN per_competences.competence_id%TYPE := FND_API.G_MISS_NUM,

442: PROCEDURE validate_attributes
443: (
444: p_element_id IN NUMBER := null,
445: p_person_id IN per_competences.competence_id%TYPE := FND_API.G_MISS_NUM,
446: p_competence_id IN per_competences.competence_id%TYPE := FND_API.G_MISS_NUM,
447: p_competence_alias IN per_competences.competence_alias%TYPE := FND_API.G_MISS_CHAR,
448: p_competence_name IN per_competences.name%TYPE := FND_API.G_MISS_CHAR,
449: p_rating_level_id IN per_competence_elements.rating_level_id%TYPE := FND_API.G_MISS_NUM,
450: p_rating_level_value IN per_rating_levels.step_value%TYPE := FND_API.G_MISS_NUM,

Line 447: p_competence_alias IN per_competences.competence_alias%TYPE := FND_API.G_MISS_CHAR,

443: (
444: p_element_id IN NUMBER := null,
445: p_person_id IN per_competences.competence_id%TYPE := FND_API.G_MISS_NUM,
446: p_competence_id IN per_competences.competence_id%TYPE := FND_API.G_MISS_NUM,
447: p_competence_alias IN per_competences.competence_alias%TYPE := FND_API.G_MISS_CHAR,
448: p_competence_name IN per_competences.name%TYPE := FND_API.G_MISS_CHAR,
449: p_rating_level_id IN per_competence_elements.rating_level_id%TYPE := FND_API.G_MISS_NUM,
450: p_rating_level_value IN per_rating_levels.step_value%TYPE := FND_API.G_MISS_NUM,
451: p_effective_date_from IN DATE := FND_API.G_MISS_DATE,

Line 448: p_competence_name IN per_competences.name%TYPE := FND_API.G_MISS_CHAR,

444: p_element_id IN NUMBER := null,
445: p_person_id IN per_competences.competence_id%TYPE := FND_API.G_MISS_NUM,
446: p_competence_id IN per_competences.competence_id%TYPE := FND_API.G_MISS_NUM,
447: p_competence_alias IN per_competences.competence_alias%TYPE := FND_API.G_MISS_CHAR,
448: p_competence_name IN per_competences.name%TYPE := FND_API.G_MISS_CHAR,
449: p_rating_level_id IN per_competence_elements.rating_level_id%TYPE := FND_API.G_MISS_NUM,
450: p_rating_level_value IN per_rating_levels.step_value%TYPE := FND_API.G_MISS_NUM,
451: p_effective_date_from IN DATE := FND_API.G_MISS_DATE,
452: p_operation IN VARCHAR2,

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

450: p_rating_level_value IN per_rating_levels.step_value%TYPE := FND_API.G_MISS_NUM,
451: p_effective_date_from IN DATE := FND_API.G_MISS_DATE,
452: p_operation IN VARCHAR2,
453: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
454: x_competence_id OUT NOCOPY per_competences.competence_id%TYPE, --File.Sql.39 bug 4440895
455: x_rating_level_id OUT NOCOPY per_competence_elements.rating_level_id%TYPE, --File.Sql.39 bug 4440895
456: x_effective_date_from OUT NOCOPY DATE) --File.Sql.39 bug 4440895
457: IS
458: l_return_status VARCHAR2(30);

Line 523: FROM per_competences

519: l_in_competence_alias is not null THEN
520: BEGIN
521: SELECT 'Y'
522: INTO l_exists
523: FROM per_competences
524: WHERE name = l_in_competence_name
525: AND competence_alias = l_in_competence_alias;
526: EXCEPTION
527: WHEN NO_DATA_FOUND THEN

Line 546: per_competences comp

542: INTO l_old_competence_id,
543: l_old_comp_name,
544: l_old_comp_alias
545: FROM per_competence_elements comp_ele,
546: per_competences comp
547: WHERE COMPETENCE_ELEMENT_ID = p_element_id
548: AND comp.competence_id = comp_ele.competence_id;
549:
550: IF (nvl(l_in_competence_name,l_old_comp_name) <> l_old_comp_name) OR

Line 638: FROM per_competences

634:
635: BEGIN
636: SELECT 'Y'
637: INTO l_valid
638: FROM per_competences
639: WHERE x_effective_date_from BETWEEN date_from AND NVL(date_to,x_effective_date_from)
640: AND competence_id=x_competence_id;
641: EXCEPTION
642: WHEN NO_DATA_FOUND THEN