DBA Data[Home] [Help]

APPS.PA_COMP_PROFILE_PVT dependencies on FND_API

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

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,

Line 10: p_commit IN VARCHAR2 := FND_API.G_MISS_CHAR,

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:

Line 11: p_validate_only IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

Line 12: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

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 ,

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

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

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,

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

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,

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

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,

Line 21: p_commit IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

Line 22: p_validate_only IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

Line 23: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

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:

Line 33: p_commit IN VARCHAR2 := FND_API.G_MISS_CHAR,

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,