[Home] [Help]
PACKAGE: APPS.PA_COMPETENCE_PUB
Source
1 PACKAGE pa_competence_pub AUTHID CURRENT_USER AS
2 -- $Header: PACOMPPS.pls 120.1 2005/08/19 16:20:22 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 -- 11-JUL-2000 R. Krishnamurthy Created
12 --
13 PROCEDURE Add_competence_element
14 ( p_object_name IN per_competence_elements.object_name%TYPE := FND_API.G_MISS_CHAR,
15 p_object_id IN per_competence_elements.object_id%TYPE := FND_API.G_MISS_NUM,
16 p_competence_id IN per_competences.competence_id%TYPE := FND_API.G_MISS_NUM,
17 p_competence_alias IN per_competences.competence_alias%TYPE := FND_API.G_MISS_CHAR,
18 p_competence_name IN per_competences.name%TYPE := FND_API.G_MISS_CHAR,
19 p_rating_level_id IN per_competence_elements.rating_level_id%TYPE := FND_API.G_MISS_NUM,
20 p_rating_level_value IN per_rating_levels.step_value%TYPE := FND_API.G_MISS_NUM,
21 p_mandatory_flag IN per_competence_elements.mandatory%TYPE := FND_API.G_MISS_CHAR,
22 p_init_msg_list IN VARCHAR2 := 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 x_element_rowid OUT NOCOPY ROWID, --File.Sql.39 bug 4440895
26 x_element_id OUT NOCOPY per_competence_elements.competence_element_id%TYPE, --File.Sql.39 bug 4440895
27 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
28 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
29 x_msg_data OUT NOCOPY VARCHAR2) ; --File.Sql.39 bug 4440895
30
31 PROCEDURE Update_competence_element
32 (p_object_name IN per_competence_elements.object_name%TYPE := FND_API.G_MISS_CHAR,
33 p_object_id IN per_competence_elements.object_id%TYPE := FND_API.G_MISS_NUM,
34 p_competence_id IN per_competences.competence_id%TYPE := FND_API.G_MISS_NUM,
35 p_competence_alias IN per_competences.competence_alias%TYPE := FND_API.G_MISS_CHAR,
36 p_competence_name IN per_competences.name%TYPE := FND_API.G_MISS_CHAR,
37 p_element_rowid IN ROWID := FND_API.G_MISS_CHAR,
38 p_element_id IN per_competence_elements.competence_element_id%TYPE := FND_API.G_MISS_NUM,
39 p_rating_level_id IN per_competence_elements.rating_level_id%TYPE := FND_API.G_MISS_NUM,
40 p_rating_level_value IN per_rating_levels.step_value%TYPE := FND_API.G_MISS_NUM,
41 p_mandatory_flag IN per_competence_elements.mandatory%TYPE := FND_API.G_MISS_CHAR,
42 p_init_msg_list IN VARCHAR2 := FND_API.G_MISS_CHAR,
43 p_commit IN VARCHAR2 := FND_API.G_MISS_CHAR,
44 p_validate_only IN VARCHAR2 := FND_API.G_MISS_CHAR,
45 p_object_version_number IN NUMBER,
46 x_object_version_number OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
47 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
48 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
49 x_msg_data OUT NOCOPY VARCHAR2) ; --File.Sql.39 bug 4440895
50
51 PROCEDURE delete_competence_element
52 (p_object_name IN per_competence_elements.object_name%TYPE := FND_API.G_MISS_CHAR,
53 p_object_id IN per_competence_elements.object_id%TYPE := FND_API.G_MISS_NUM,
54 p_competence_id IN per_competences.competence_id%TYPE := FND_API.G_MISS_NUM,
55 p_competence_alias IN per_competences.competence_alias%TYPE := FND_API.G_MISS_CHAR,
56 p_competence_name IN per_competences.name%TYPE := chr(0),
57 p_element_rowid IN ROWID := FND_API.G_MISS_CHAR,
58 p_element_id IN per_competence_elements.competence_element_id%TYPE := FND_API.G_MISS_NUM,
59 p_init_msg_list IN VARCHAR2 := FND_API.G_MISS_CHAR,
60 p_commit IN VARCHAR2 := FND_API.G_MISS_CHAR,
61 p_validate_only IN VARCHAR2 := FND_API.G_MISS_CHAR,
62 p_object_version_number IN NUMBER,
63 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
64 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
65 x_msg_data OUT NOCOPY VARCHAR2) ; --File.Sql.39 bug 4440895
66
67 PROCEDURE standard_pub_checks
68 (
69 p_element_id IN NUMBER := null,
70 p_object_name IN per_competence_elements.object_name%TYPE := FND_API.G_MISS_CHAR,
71 p_object_id IN per_competence_elements.object_id%TYPE := FND_API.G_MISS_NUM,
72 p_competence_id IN per_competences.competence_id%TYPE := FND_API.G_MISS_NUM,
73 p_competence_alias IN per_competences.competence_alias%TYPE := FND_API.G_MISS_CHAR,
74 p_competence_name IN per_competences.name%TYPE := FND_API.G_MISS_CHAR,
75 p_rating_level_id IN per_competence_elements.rating_level_id%TYPE := FND_API.G_MISS_NUM,
76 p_rating_level_value IN per_rating_levels.step_value%TYPE := FND_API.G_MISS_NUM,
77 p_operation IN VARCHAR2,
78 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
79 x_competence_id OUT NOCOPY per_competences.competence_id%TYPE, --File.Sql.39 bug 4440895
80 x_rating_level_id OUT NOCOPY per_competence_elements.rating_level_id%TYPE ) ; --File.Sql.39 bug 4440895
81
82 PROCEDURE Mass_Exec_Process_Competences
83 ( p_asgn_update_mode IN VARCHAR2 := FND_API.G_MISS_CHAR
84 ,p_project_id IN pa_project_assignments.project_id%TYPE
85 ,p_assignment_id_tbl IN SYSTEM.pa_num_tbl_type
86 ,p_competence_id_tbl IN SYSTEM.pa_num_tbl_type
87 ,p_competence_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type
88 ,p_competence_alias_tbl IN SYSTEM.pa_varchar2_30_tbl_type
89 ,p_rating_level_id_tbl IN SYSTEM.pa_num_tbl_type
90 ,p_rating_level_value_tbl IN SYSTEM.pa_num_tbl_type
91 ,p_mandatory_flag_tbl IN SYSTEM.pa_varchar2_1_tbl_type
92 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
93 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
94 ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
95 ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
96 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
97 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
98 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
99 );
100
101 PROCEDURE Mass_Process_Competences
102 ( p_project_id IN pa_project_assignments.project_id%TYPE,
103 p_assignment_tbl IN SYSTEM.pa_num_tbl_type,
104 p_competence_id_tbl IN SYSTEM.pa_num_tbl_type,
105 p_competence_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type,
106 p_competence_alias_tbl IN SYSTEM.pa_varchar2_30_tbl_type,
107 p_rating_level_id_tbl IN SYSTEM.pa_num_tbl_type,
108 p_mandatory_flag_tbl IN SYSTEM.pa_varchar2_1_tbl_type,
109 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
110 p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
111 p_commit IN VARCHAR2 := FND_API.G_FALSE,
112 x_success_assignment_id_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, /* Added NOCOPY for bug#2674619 */
113 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
114 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
115 x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
116
117 end pa_competence_pub ;