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,
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,
13: x_return_status OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
14:
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,
13: x_return_status OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
14:
15: PROCEDURE Update_competence_element
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,
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 ,
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,
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,
21: p_commit IN VARCHAR2 := FND_API.G_MISS_CHAR,
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,
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,
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,
24: p_object_version_number IN NUMBER,
25: x_object_version_number OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
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,
24: p_object_version_number IN NUMBER,
25: x_object_version_number OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
26: x_return_status OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
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,
24: p_object_version_number IN NUMBER,
25: x_object_version_number OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
26: x_return_status OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
27:
29: ( p_person_id IN NUMBER,
30: p_competence_id IN NUMBER,
31: p_element_id IN NUMBER,
32: p_object_version_number IN NUMBER,
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,