DBA Data[Home] [Help]

APPS.PA_COMP_PROFILE_PUB dependencies on PER_COMPETENCES

Line 7: p_competence_id IN per_competences.competence_id%TYPE,

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,
11: p_rating_level_value IN per_rating_levels.step_value%TYPE := FND_API.G_MISS_NUM,

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

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,
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,

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

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,
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,

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

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,
27: p_rating_level_id IN per_competence_elements.rating_level_id%TYPE := FND_API.G_MISS_NUM,

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

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,
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,

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

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,
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,