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_COMPETENCE_ELEMENTS

Line 12: p_rating_level_id IN per_competence_elements.rating_level_id%TYPE := FND_API.G_MISS_NUM,

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,
16: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 18: x_rating_level_id OUT NOCOPY per_competence_elements.rating_level_id%TYPE, --File.Sql.39 bug 4440895

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: /* --------------------------------------------------------------------
22: PROCEDURE Add_Competence_Element

Line 28: p_person_id IN per_competence_elements.person_id%TYPE,

24: -------------------------------------------------------------------- */
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,

Line 32: p_rating_level_id IN per_competence_elements.rating_level_id%TYPE := FND_API.G_MISS_NUM,

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,
36: p_commit IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 199: p_person_id IN per_competence_elements.person_id%TYPE := FND_API.G_MISS_NUM,

195: -------------------------------------------------------------------- */
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,

Line 203: p_element_id IN per_competence_elements.competence_element_id%TYPE := FND_API.G_MISS_NUM,

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,
207: p_init_msg_list IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 204: p_rating_level_id IN per_competence_elements.rating_level_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,
207: p_init_msg_list IN VARCHAR2 := FND_API.G_MISS_CHAR,
208: p_commit IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 371: (p_person_id IN per_competence_elements.person_id%TYPE := FND_API.G_MISS_NUM,

367:
368: END update_competence_element ;
369:
370: PROCEDURE delete_competence_element
371: (p_person_id IN per_competence_elements.person_id%TYPE := FND_API.G_MISS_NUM,
372: p_competence_id IN per_competence_elements.competence_id%TYPE := FND_API.G_MISS_NUM,
373: p_element_id IN per_competence_elements.competence_element_id%TYPE := FND_API.G_MISS_NUM,
374: p_init_msg_list IN VARCHAR2 := FND_API.G_MISS_CHAR,
375: p_commit IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 372: p_competence_id IN per_competence_elements.competence_id%TYPE := FND_API.G_MISS_NUM,

368: END update_competence_element ;
369:
370: PROCEDURE delete_competence_element
371: (p_person_id IN per_competence_elements.person_id%TYPE := FND_API.G_MISS_NUM,
372: p_competence_id IN per_competence_elements.competence_id%TYPE := FND_API.G_MISS_NUM,
373: p_element_id IN per_competence_elements.competence_element_id%TYPE := FND_API.G_MISS_NUM,
374: p_init_msg_list IN VARCHAR2 := FND_API.G_MISS_CHAR,
375: p_commit IN VARCHAR2 := FND_API.G_MISS_CHAR,
376: p_validate_only IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 373: p_element_id IN per_competence_elements.competence_element_id%TYPE := FND_API.G_MISS_NUM,

369:
370: PROCEDURE delete_competence_element
371: (p_person_id IN per_competence_elements.person_id%TYPE := FND_API.G_MISS_NUM,
372: p_competence_id IN per_competence_elements.competence_id%TYPE := FND_API.G_MISS_NUM,
373: p_element_id IN per_competence_elements.competence_element_id%TYPE := FND_API.G_MISS_NUM,
374: p_init_msg_list IN VARCHAR2 := FND_API.G_MISS_CHAR,
375: p_commit IN VARCHAR2 := FND_API.G_MISS_CHAR,
376: p_validate_only IN VARCHAR2 := FND_API.G_MISS_CHAR,
377: p_object_version_number IN NUMBER,

Line 449: p_rating_level_id IN per_competence_elements.rating_level_id%TYPE := FND_API.G_MISS_NUM,

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,
453: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 455: x_rating_level_id OUT NOCOPY per_competence_elements.rating_level_id%TYPE, --File.Sql.39 bug 4440895

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);
459: l_error_message_code VARCHAR2(30);

Line 545: FROM per_competence_elements comp_ele,

541: comp.competence_alias
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:

Line 606: FROM per_competence_elements

602: IF p_element_id is not null THEN
603: BEGIN
604: SELECT competence_id
605: INTO l_old_competence_id
606: FROM per_competence_elements
607: WHERE competence_element_id = p_element_id;
608:
609: IF l_old_competence_id <> l_competence_id THEN
610: PA_COMP_PROFILE_PVT.Check_Error

Line 863: FROM per_competence_elements

859: IF g_person_id > 0 THEN
860:
861: SELECT 'Y'
862: INTO l_exists
863: FROM per_competence_elements
864: WHERE person_id = g_person_id
865: AND competence_id = p_competence_id;
866:
867: ELSIF g_assignment_id > 0 THEN

Line 871: FROM per_competence_elements

867: ELSIF g_assignment_id > 0 THEN
868:
869: SELECT 'Y'
870: INTO l_exists
871: FROM per_competence_elements
872: WHERE object_id = g_assignment_id
873: AND competence_id = p_competence_id
874: and OBJECT_NAME = 'OPEN_ASSIGNMENT' ; -- Included for 4765876
875: