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

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

12: --
13: PROCEDURE Add_competence_element
14: ( p_object_name IN per_competence_elements.object_name%TYPE := FND_API.G_MISS_CHAR,
15: p_object_id IN per_competence_elements.object_id%TYPE := FND_API.G_MISS_NUM,
16: p_competence_id IN per_competences.competence_id%TYPE := FND_API.G_MISS_NUM,
17: p_competence_alias IN per_competences.competence_alias%TYPE := FND_API.G_MISS_CHAR,
18: p_competence_name IN per_competences.name%TYPE := FND_API.G_MISS_CHAR,
19: p_rating_level_id IN per_competence_elements.rating_level_id%TYPE := FND_API.G_MISS_NUM,
20: p_rating_level_value IN per_rating_levels.step_value%TYPE := FND_API.G_MISS_NUM,

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

13: PROCEDURE Add_competence_element
14: ( p_object_name IN per_competence_elements.object_name%TYPE := FND_API.G_MISS_CHAR,
15: p_object_id IN per_competence_elements.object_id%TYPE := FND_API.G_MISS_NUM,
16: p_competence_id IN per_competences.competence_id%TYPE := FND_API.G_MISS_NUM,
17: p_competence_alias IN per_competences.competence_alias%TYPE := FND_API.G_MISS_CHAR,
18: p_competence_name IN per_competences.name%TYPE := FND_API.G_MISS_CHAR,
19: p_rating_level_id IN per_competence_elements.rating_level_id%TYPE := FND_API.G_MISS_NUM,
20: p_rating_level_value IN per_rating_levels.step_value%TYPE := FND_API.G_MISS_NUM,
21: p_mandatory_flag IN per_competence_elements.mandatory%TYPE := FND_API.G_MISS_CHAR,

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

14: ( p_object_name IN per_competence_elements.object_name%TYPE := FND_API.G_MISS_CHAR,
15: p_object_id IN per_competence_elements.object_id%TYPE := FND_API.G_MISS_NUM,
16: p_competence_id IN per_competences.competence_id%TYPE := FND_API.G_MISS_NUM,
17: p_competence_alias IN per_competences.competence_alias%TYPE := FND_API.G_MISS_CHAR,
18: p_competence_name IN per_competences.name%TYPE := FND_API.G_MISS_CHAR,
19: p_rating_level_id IN per_competence_elements.rating_level_id%TYPE := FND_API.G_MISS_NUM,
20: p_rating_level_value IN per_rating_levels.step_value%TYPE := FND_API.G_MISS_NUM,
21: p_mandatory_flag IN per_competence_elements.mandatory%TYPE := FND_API.G_MISS_CHAR,
22: p_init_msg_list IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

30:
31: PROCEDURE Update_competence_element
32: (p_object_name IN per_competence_elements.object_name%TYPE := FND_API.G_MISS_CHAR,
33: p_object_id IN per_competence_elements.object_id%TYPE := FND_API.G_MISS_NUM,
34: p_competence_id IN per_competences.competence_id%TYPE := FND_API.G_MISS_NUM,
35: p_competence_alias IN per_competences.competence_alias%TYPE := FND_API.G_MISS_CHAR,
36: p_competence_name IN per_competences.name%TYPE := FND_API.G_MISS_CHAR,
37: p_element_rowid IN ROWID := FND_API.G_MISS_CHAR,
38: p_element_id IN per_competence_elements.competence_element_id%TYPE := FND_API.G_MISS_NUM,

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

31: PROCEDURE Update_competence_element
32: (p_object_name IN per_competence_elements.object_name%TYPE := FND_API.G_MISS_CHAR,
33: p_object_id IN per_competence_elements.object_id%TYPE := FND_API.G_MISS_NUM,
34: p_competence_id IN per_competences.competence_id%TYPE := FND_API.G_MISS_NUM,
35: p_competence_alias IN per_competences.competence_alias%TYPE := FND_API.G_MISS_CHAR,
36: p_competence_name IN per_competences.name%TYPE := FND_API.G_MISS_CHAR,
37: p_element_rowid IN ROWID := FND_API.G_MISS_CHAR,
38: p_element_id IN per_competence_elements.competence_element_id%TYPE := FND_API.G_MISS_NUM,
39: p_rating_level_id IN per_competence_elements.rating_level_id%TYPE := FND_API.G_MISS_NUM,

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

32: (p_object_name IN per_competence_elements.object_name%TYPE := FND_API.G_MISS_CHAR,
33: p_object_id IN per_competence_elements.object_id%TYPE := FND_API.G_MISS_NUM,
34: p_competence_id IN per_competences.competence_id%TYPE := FND_API.G_MISS_NUM,
35: p_competence_alias IN per_competences.competence_alias%TYPE := FND_API.G_MISS_CHAR,
36: p_competence_name IN per_competences.name%TYPE := FND_API.G_MISS_CHAR,
37: p_element_rowid IN ROWID := FND_API.G_MISS_CHAR,
38: p_element_id IN per_competence_elements.competence_element_id%TYPE := FND_API.G_MISS_NUM,
39: p_rating_level_id IN per_competence_elements.rating_level_id%TYPE := FND_API.G_MISS_NUM,
40: p_rating_level_value IN per_rating_levels.step_value%TYPE := FND_API.G_MISS_NUM,

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

50:
51: PROCEDURE delete_competence_element
52: (p_object_name IN per_competence_elements.object_name%TYPE := FND_API.G_MISS_CHAR,
53: p_object_id IN per_competence_elements.object_id%TYPE := FND_API.G_MISS_NUM,
54: p_competence_id IN per_competences.competence_id%TYPE := FND_API.G_MISS_NUM,
55: p_competence_alias IN per_competences.competence_alias%TYPE := FND_API.G_MISS_CHAR,
56: p_competence_name IN per_competences.name%TYPE := chr(0),
57: p_element_rowid IN ROWID := FND_API.G_MISS_CHAR,
58: p_element_id IN per_competence_elements.competence_element_id%TYPE := FND_API.G_MISS_NUM,

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

51: PROCEDURE delete_competence_element
52: (p_object_name IN per_competence_elements.object_name%TYPE := FND_API.G_MISS_CHAR,
53: p_object_id IN per_competence_elements.object_id%TYPE := FND_API.G_MISS_NUM,
54: p_competence_id IN per_competences.competence_id%TYPE := FND_API.G_MISS_NUM,
55: p_competence_alias IN per_competences.competence_alias%TYPE := FND_API.G_MISS_CHAR,
56: p_competence_name IN per_competences.name%TYPE := chr(0),
57: p_element_rowid IN ROWID := FND_API.G_MISS_CHAR,
58: p_element_id IN per_competence_elements.competence_element_id%TYPE := FND_API.G_MISS_NUM,
59: p_init_msg_list IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 56: p_competence_name IN per_competences.name%TYPE := chr(0),

52: (p_object_name IN per_competence_elements.object_name%TYPE := FND_API.G_MISS_CHAR,
53: p_object_id IN per_competence_elements.object_id%TYPE := FND_API.G_MISS_NUM,
54: p_competence_id IN per_competences.competence_id%TYPE := FND_API.G_MISS_NUM,
55: p_competence_alias IN per_competences.competence_alias%TYPE := FND_API.G_MISS_CHAR,
56: p_competence_name IN per_competences.name%TYPE := chr(0),
57: p_element_rowid IN ROWID := FND_API.G_MISS_CHAR,
58: p_element_id IN per_competence_elements.competence_element_id%TYPE := FND_API.G_MISS_NUM,
59: p_init_msg_list IN VARCHAR2 := FND_API.G_MISS_CHAR,
60: p_commit IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

68: (
69: p_element_id IN NUMBER := null,
70: p_object_name IN per_competence_elements.object_name%TYPE := FND_API.G_MISS_CHAR,
71: p_object_id IN per_competence_elements.object_id%TYPE := FND_API.G_MISS_NUM,
72: p_competence_id IN per_competences.competence_id%TYPE := FND_API.G_MISS_NUM,
73: p_competence_alias IN per_competences.competence_alias%TYPE := FND_API.G_MISS_CHAR,
74: p_competence_name IN per_competences.name%TYPE := FND_API.G_MISS_CHAR,
75: p_rating_level_id IN per_competence_elements.rating_level_id%TYPE := FND_API.G_MISS_NUM,
76: p_rating_level_value IN per_rating_levels.step_value%TYPE := FND_API.G_MISS_NUM,

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

69: p_element_id IN NUMBER := null,
70: p_object_name IN per_competence_elements.object_name%TYPE := FND_API.G_MISS_CHAR,
71: p_object_id IN per_competence_elements.object_id%TYPE := FND_API.G_MISS_NUM,
72: p_competence_id IN per_competences.competence_id%TYPE := FND_API.G_MISS_NUM,
73: p_competence_alias IN per_competences.competence_alias%TYPE := FND_API.G_MISS_CHAR,
74: p_competence_name IN per_competences.name%TYPE := FND_API.G_MISS_CHAR,
75: p_rating_level_id IN per_competence_elements.rating_level_id%TYPE := FND_API.G_MISS_NUM,
76: p_rating_level_value IN per_rating_levels.step_value%TYPE := FND_API.G_MISS_NUM,
77: p_operation IN VARCHAR2,

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

70: p_object_name IN per_competence_elements.object_name%TYPE := FND_API.G_MISS_CHAR,
71: p_object_id IN per_competence_elements.object_id%TYPE := FND_API.G_MISS_NUM,
72: p_competence_id IN per_competences.competence_id%TYPE := FND_API.G_MISS_NUM,
73: p_competence_alias IN per_competences.competence_alias%TYPE := FND_API.G_MISS_CHAR,
74: p_competence_name IN per_competences.name%TYPE := FND_API.G_MISS_CHAR,
75: p_rating_level_id IN per_competence_elements.rating_level_id%TYPE := FND_API.G_MISS_NUM,
76: p_rating_level_value IN per_rating_levels.step_value%TYPE := FND_API.G_MISS_NUM,
77: p_operation IN VARCHAR2,
78: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

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

75: p_rating_level_id IN per_competence_elements.rating_level_id%TYPE := FND_API.G_MISS_NUM,
76: p_rating_level_value IN per_rating_levels.step_value%TYPE := FND_API.G_MISS_NUM,
77: p_operation IN VARCHAR2,
78: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
79: x_competence_id OUT NOCOPY per_competences.competence_id%TYPE, --File.Sql.39 bug 4440895
80: x_rating_level_id OUT NOCOPY per_competence_elements.rating_level_id%TYPE ) ; --File.Sql.39 bug 4440895
81:
82: PROCEDURE Mass_Exec_Process_Competences
83: ( p_asgn_update_mode IN VARCHAR2 := FND_API.G_MISS_CHAR