DBA Data[Home] [Help]

APPS.PA_COMP_PROFILE_PVT dependencies on PER_COMPETENCE_ELEMENTS

Line 6: ( p_person_id IN per_competence_elements.person_id%TYPE,

2: -- $Header: PARPRFVS.pls 120.1 2005/08/19 16:59:07 mwasowic noship $
3:
4: g_noof_errors NUMBER := 0;
5: PROCEDURE Add_competence_element
6: ( p_person_id IN per_competence_elements.person_id%TYPE,
7: p_competence_id IN per_competences.competence_id%TYPE,
8: p_rating_level_id IN per_competence_elements.rating_level_id%TYPE := FND_API.G_MISS_NUM,
9: p_effective_date_from IN DATE,
10: p_commit IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

4: g_noof_errors NUMBER := 0;
5: PROCEDURE Add_competence_element
6: ( p_person_id IN per_competence_elements.person_id%TYPE,
7: p_competence_id IN per_competences.competence_id%TYPE,
8: p_rating_level_id IN per_competence_elements.rating_level_id%TYPE := FND_API.G_MISS_NUM,
9: p_effective_date_from IN DATE,
10: p_commit IN VARCHAR2 := FND_API.G_MISS_CHAR,
11: p_validate_only IN VARCHAR2 := FND_API.G_MISS_CHAR,
12: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

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

12: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
13: x_return_status OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
14:
15: PROCEDURE Update_competence_element
16: (p_person_id IN per_competence_elements.person_id%TYPE := FND_API.G_MISS_NUM ,
17: p_competence_id IN per_competences.competence_id%TYPE := FND_API.G_MISS_NUM,
18: p_element_id IN per_competence_elements.competence_element_id%TYPE := FND_API.G_MISS_NUM,
19: p_rating_level_id IN per_competence_elements.rating_level_id%TYPE := FND_API.G_MISS_NUM,
20: p_effective_date_from IN DATE,

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

14:
15: PROCEDURE Update_competence_element
16: (p_person_id IN per_competence_elements.person_id%TYPE := FND_API.G_MISS_NUM ,
17: p_competence_id IN per_competences.competence_id%TYPE := FND_API.G_MISS_NUM,
18: p_element_id IN per_competence_elements.competence_element_id%TYPE := FND_API.G_MISS_NUM,
19: p_rating_level_id IN per_competence_elements.rating_level_id%TYPE := FND_API.G_MISS_NUM,
20: p_effective_date_from IN DATE,
21: p_commit IN VARCHAR2 := FND_API.G_MISS_CHAR,
22: p_validate_only IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

15: PROCEDURE Update_competence_element
16: (p_person_id IN per_competence_elements.person_id%TYPE := FND_API.G_MISS_NUM ,
17: p_competence_id IN per_competences.competence_id%TYPE := FND_API.G_MISS_NUM,
18: p_element_id IN per_competence_elements.competence_element_id%TYPE := FND_API.G_MISS_NUM,
19: p_rating_level_id IN per_competence_elements.rating_level_id%TYPE := FND_API.G_MISS_NUM,
20: p_effective_date_from IN DATE,
21: p_commit IN VARCHAR2 := FND_API.G_MISS_CHAR,
22: p_validate_only IN VARCHAR2 := FND_API.G_MISS_CHAR,
23: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

Line 37: (p_element_id IN per_competence_elements.competence_element_id%TYPE,

33: p_commit IN VARCHAR2 := FND_API.G_MISS_CHAR,
34: x_return_status OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
35:
36: PROCEDURE Check_Object_version_number
37: (p_element_id IN per_competence_elements.competence_element_id%TYPE,
38: p_object_version_number IN NUMBER,
39: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
40: x_error_message_code OUT NOCOPY VARCHAR2) ; --File.Sql.39 bug 4440895
41: