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