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

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

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 PA_ASSIGNMENTS_PUB.assignment_id_tbl_type,
16: p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM,
17: p_competence_id IN per_competences.competence_id%TYPE := FND_API.G_MISS_NUM,
18: p_rating_level_id IN per_competence_elements.rating_level_id%TYPE := FND_API.G_MISS_NUM,
19: p_mandatory_flag IN per_competence_elements.mandatory%TYPE := FND_API.G_MISS_CHAR,
20: p_commit IN VARCHAR2 := FND_API.G_MISS_CHAR,
21: p_validate_only IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 43: FROM per_competences

39: l_first_assignment_id NUMBER;
40:
41: CURSOR l_bg_csr IS
42: SELECT business_group_id
43: FROM per_competences
44: WHERE competence_id = p_competence_id;
45:
46: CURSOR l_rowid_csr IS
47: SELECT rowid

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

247:
248: PROCEDURE Update_competence_element
249: (p_object_name IN per_competence_elements.object_name%TYPE := FND_API.G_MISS_CHAR,
250: p_object_id IN per_competence_elements.object_id%TYPE := FND_API.G_MISS_NUM,
251: p_competence_id IN per_competences.competence_id%TYPE := FND_API.G_MISS_NUM,
252: p_element_rowid IN ROWID := FND_API.G_MISS_CHAR,
253: p_element_id IN per_competence_elements.competence_element_id%TYPE := FND_API.G_MISS_NUM,
254: p_rating_level_id IN per_competence_elements.rating_level_id%TYPE := FND_API.G_MISS_NUM,
255: p_mandatory_flag IN per_competence_elements.mandatory%TYPE := FND_API.G_MISS_CHAR,

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

358:
359: PROCEDURE delete_competence_element
360: (p_object_name IN per_competence_elements.object_name%TYPE := FND_API.G_MISS_CHAR,
361: p_object_id IN per_competence_elements.object_id%TYPE := FND_API.G_MISS_NUM,
362: p_competence_id IN per_competences.competence_id%TYPE := FND_API.G_MISS_NUM,
363: p_element_rowid IN ROWID := FND_API.G_MISS_CHAR,
364: p_element_id IN per_competence_elements.competence_element_id%TYPE := FND_API.G_MISS_NUM,
365: p_commit IN VARCHAR2 := FND_API.G_MISS_CHAR,
366: p_validate_only IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

446:
447: PROCEDURE Check_Element_id
448: (p_object_name IN per_competence_elements.object_name%TYPE := FND_API.G_MISS_CHAR,
449: p_object_id IN per_competence_elements.object_id%TYPE := FND_API.G_MISS_NUM,
450: p_competence_id IN per_competences.competence_id%TYPE := FND_API.G_MISS_NUM,
451: p_element_id IN per_competence_elements.competence_element_id%TYPE := FND_API.G_MISS_NUM,
452: x_effective_date_from OUT NOCOPY per_competence_elements.effective_date_from%TYPE , --File.Sql.39 bug 4440895
453: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
454: x_error_message_code OUT NOCOPY VARCHAR2) IS --File.Sql.39 bug 4440895