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