[Home] [Help]
PACKAGE: APPS.PA_COMPETENCE_PVT
Source
1 PACKAGE pa_competence_pvt AS
2 -- $Header: PACOMPVS.pls 120.1 2005/08/19 16:20:31 mwasowic noship $
3
4 --
5 -- PROCEDURE
6 -- Add_Competence_Element
7 -- PURPOSE
8 -- This procedure creates the competence elements for
9 -- a project role or an open assignment
10 -- HISTORY
11 -- 24-JUL-2000 R. Krishnamurthy Created
12 --
13 g_noof_errors NUMBER := 0;
14
15 PROCEDURE Add_competence_element
16 ( p_object_name IN per_competence_elements.object_name%TYPE := FND_API.G_MISS_CHAR,
17 --p_object_id IN per_competence_elements.object_id%TYPE := FND_API.G_MISS_NUM,
18 p_object_id IN PA_ASSIGNMENTS_PUB.assignment_id_tbl_type,
19 p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM,
20 p_competence_id IN per_competences.competence_id%TYPE := FND_API.G_MISS_NUM,
21 p_rating_level_id IN per_competence_elements.rating_level_id%TYPE := FND_API.G_MISS_NUM,
22 p_mandatory_flag IN per_competence_elements.mandatory%TYPE := FND_API.G_MISS_CHAR,
23 p_commit IN VARCHAR2 := FND_API.G_MISS_CHAR,
24 p_validate_only IN VARCHAR2 := FND_API.G_MISS_CHAR,
25 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
26 x_element_rowid OUT NOCOPY ROWID, --File.Sql.39 bug 4440895
27 x_element_id OUT NOCOPY per_competence_elements.competence_element_id%TYPE, --File.Sql.39 bug 4440895
28 x_return_status OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
29
30 PROCEDURE Update_competence_element
31 (p_object_name IN per_competence_elements.object_name%TYPE := FND_API.G_MISS_CHAR,
32 p_object_id IN per_competence_elements.object_id%TYPE := FND_API.G_MISS_NUM,
33 p_competence_id IN per_competences.competence_id%TYPE := FND_API.G_MISS_NUM,
34 p_element_rowid IN ROWID := FND_API.G_MISS_CHAR,
35 p_element_id IN per_competence_elements.competence_element_id%TYPE := FND_API.G_MISS_NUM,
36 p_rating_level_id IN per_competence_elements.rating_level_id%TYPE := FND_API.G_MISS_NUM,
37 p_mandatory_flag IN per_competence_elements.mandatory%TYPE := FND_API.G_MISS_CHAR,
38 p_commit IN VARCHAR2 := FND_API.G_MISS_CHAR,
39 p_validate_only IN VARCHAR2 := FND_API.G_MISS_CHAR,
40 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
41 p_object_version_number IN NUMBER,
42 x_object_version_number OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
43 x_return_status OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
44
45 PROCEDURE delete_competence_element
46 (p_object_name IN per_competence_elements.object_name%TYPE := FND_API.G_MISS_CHAR,
47 p_object_id IN per_competence_elements.object_id%TYPE := FND_API.G_MISS_NUM,
48 p_competence_id IN per_competences.competence_id%TYPE := FND_API.G_MISS_NUM,
49 p_element_rowid IN ROWID := FND_API.G_MISS_CHAR,
50 p_element_id IN per_competence_elements.competence_element_id%TYPE := FND_API.G_MISS_NUM,
51 p_commit IN VARCHAR2 := FND_API.G_MISS_CHAR,
52 p_validate_only IN VARCHAR2 := FND_API.G_MISS_CHAR,
53 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
54 p_object_version_number IN NUMBER,
55 x_return_status OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
56
57 PROCEDURE Check_Element_id
58 (p_object_name IN per_competence_elements.object_name%TYPE := FND_API.G_MISS_CHAR,
59 p_object_id IN per_competence_elements.object_id%TYPE := FND_API.G_MISS_NUM,
60 p_competence_id IN per_competences.competence_id%TYPE := FND_API.G_MISS_NUM,
61 p_element_id IN per_competence_elements.competence_element_id%TYPE := FND_API.G_MISS_NUM,
62 x_effective_date_from OUT NOCOPY per_competence_elements.effective_date_from%TYPE , --File.Sql.39 bug 4440895
63 x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
64 x_error_message_code OUT NOCOPY VARCHAR2) ; --File.Sql.39 bug 4440895
65
66 PROCEDURE Check_Error (p_return_status IN VARCHAR2,
67 p_error_message_code IN VARCHAR2) ;
68
69 PROCEDURE Check_Object_version_number
70 (p_element_id IN per_competence_elements.competence_element_id%TYPE,
71 p_object_version_number IN NUMBER,
72 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
73 x_error_message_code OUT NOCOPY VARCHAR2) ; --File.Sql.39 bug 4440895
74
75 end pa_competence_PVT ;