DBA Data[Home] [Help]

APPS.PA_COMP_PROFILE_PUB dependencies on PER_COMPETENCE_ELEMENTS

Line 6: p_person_id IN per_competence_elements.person_id%TYPE,

2: -- $Header: PARPRFPS.pls 120.1 2005/08/19 16:59:02 mwasowic noship $
3:
4: PROCEDURE Add_competence_element
5: (
6: p_person_id IN per_competence_elements.person_id%TYPE,
7: p_competence_id IN per_competences.competence_id%TYPE,
8: p_competence_alias IN per_competences.competence_alias%TYPE := FND_API.G_MISS_CHAR,
9: p_competence_name IN per_competences.name%TYPE := FND_API.G_MISS_CHAR,
10: p_rating_level_id IN per_competence_elements.rating_level_id%TYPE := FND_API.G_MISS_NUM,

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

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

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

18: x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
19:
20: PROCEDURE Update_competence_element
21: (
22: p_person_id IN per_competence_elements.person_id%TYPE := FND_API.G_MISS_NUM,
23: p_competence_id IN per_competences.competence_id%TYPE := FND_API.G_MISS_NUM,
24: p_competence_alias IN per_competences.competence_alias%TYPE := FND_API.G_MISS_CHAR,
25: p_competence_name IN per_competences.name%TYPE := FND_API.G_MISS_CHAR,
26: p_element_id IN per_competence_elements.competence_element_id%TYPE := FND_API.G_MISS_NUM,

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

22: p_person_id IN per_competence_elements.person_id%TYPE := FND_API.G_MISS_NUM,
23: p_competence_id IN per_competences.competence_id%TYPE := FND_API.G_MISS_NUM,
24: p_competence_alias IN per_competences.competence_alias%TYPE := FND_API.G_MISS_CHAR,
25: p_competence_name IN per_competences.name%TYPE := FND_API.G_MISS_CHAR,
26: p_element_id IN per_competence_elements.competence_element_id%TYPE := FND_API.G_MISS_NUM,
27: p_rating_level_id IN per_competence_elements.rating_level_id%TYPE := FND_API.G_MISS_NUM,
28: p_rating_level_value IN per_rating_levels.step_value%TYPE := FND_API.G_MISS_NUM,
29: p_effective_date_from IN DATE := FND_API.G_MISS_DATE,
30: p_init_msg_list IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

23: p_competence_id IN per_competences.competence_id%TYPE := FND_API.G_MISS_NUM,
24: p_competence_alias IN per_competences.competence_alias%TYPE := FND_API.G_MISS_CHAR,
25: p_competence_name IN per_competences.name%TYPE := FND_API.G_MISS_CHAR,
26: p_element_id IN per_competence_elements.competence_element_id%TYPE := FND_API.G_MISS_NUM,
27: p_rating_level_id IN per_competence_elements.rating_level_id%TYPE := FND_API.G_MISS_NUM,
28: p_rating_level_value IN per_rating_levels.step_value%TYPE := FND_API.G_MISS_NUM,
29: p_effective_date_from IN DATE := FND_API.G_MISS_DATE,
30: p_init_msg_list IN VARCHAR2 := FND_API.G_MISS_CHAR,
31: p_commit IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

41: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
42: x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
43:
44: PROCEDURE delete_competence_element
45: (p_person_id IN per_competence_elements.person_id%TYPE := FND_API.G_MISS_NUM,
46: p_competence_id IN per_competence_elements.competence_id%TYPE := FND_API.G_MISS_NUM,
47: p_element_id IN per_competence_elements.competence_element_id%TYPE := FND_API.G_MISS_NUM,
48: p_init_msg_list IN VARCHAR2 := FND_API.G_MISS_CHAR,
49: p_commit IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

42: x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
43:
44: PROCEDURE delete_competence_element
45: (p_person_id IN per_competence_elements.person_id%TYPE := FND_API.G_MISS_NUM,
46: p_competence_id IN per_competence_elements.competence_id%TYPE := FND_API.G_MISS_NUM,
47: p_element_id IN per_competence_elements.competence_element_id%TYPE := FND_API.G_MISS_NUM,
48: p_init_msg_list IN VARCHAR2 := FND_API.G_MISS_CHAR,
49: p_commit IN VARCHAR2 := FND_API.G_MISS_CHAR,
50: p_validate_only IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

43:
44: PROCEDURE delete_competence_element
45: (p_person_id IN per_competence_elements.person_id%TYPE := FND_API.G_MISS_NUM,
46: p_competence_id IN per_competence_elements.competence_id%TYPE := FND_API.G_MISS_NUM,
47: p_element_id IN per_competence_elements.competence_element_id%TYPE := FND_API.G_MISS_NUM,
48: p_init_msg_list IN VARCHAR2 := FND_API.G_MISS_CHAR,
49: p_commit IN VARCHAR2 := FND_API.G_MISS_CHAR,
50: p_validate_only IN VARCHAR2 := FND_API.G_MISS_CHAR,
51: p_object_version_number IN NUMBER,