DBA Data[Home] [Help]

PACKAGE: APPS.HR_ASSESSMENT_GROUPS_API

Source


1 Package hr_assessment_groups_api AUTHID CURRENT_USER as
2 /* $Header: peasrapi.pkh 115.3 99/10/05 09:44:03 porting ship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- |-----------------------< <create_assessment_group> >----------------------|
6 -- ----------------------------------------------------------------------------
7 -- {Start Of Comments}
8 --
9 -- Description:
10 -- This API creates a new assessment group.
11 --
12 -- Prerequisites:
13 --
14 -- In Parameters:
15 --   Name                           Reqd Type     Description
16 --   p_validate                          boolean  If true, the database
17 --                                                remains unchanged. If false,
18 --                                                the address is created.
19 --   p_effective_date               Yes  date     Effective date.
20 --   p_name                         Yes  varchar2 Is the unique name of the
21 --						  assessment_group.
22 --   p_business_group_id            Yes  number   Business group id in which
23 --						  the competence is created.
24 --   p_comments                          varchar2 Extra comments.
25 --   p_attribute_category                varchar2 Determines context of the
26 --                                                attribute Descriptive
27 --                                                flexfield in parameters.
28 --   p_attribute1                        varchar2 Descriptive flexfield.
29 --   p_attribute2                        varchar2 Descriptive flexfield.
30 --   p_attribute3                        varchar2 Descriptive flexfield.
31 --   p_attribute4                        varchar2 Descriptive flexfield.
32 --   p_attribute5                        varchar2 Descriptive flexfield.
33 --   p_attribute6                        varchar2 Descriptive flexfield.
34 --   p_attribute7                        varchar2 Descriptive flexfield.
35 --   p_attribute8                        varchar2 Descriptive flexfield.
36 --   p_attribute9                        varchar2 Descriptive flexfield.
37 --   p_attribute10                       varchar2 Descriptive flexfield.
38 --   p_attribute11                       varchar2 Descriptive flexfield.
39 --   p_attribute12                       varchar2 Descriptive flexfield.
40 --   p_attribute13                       varchar2 Descriptive flexfield.
41 --   p_attribute14                       varchar2 Descriptive flexfield.
42 --   p_attribute15                       varchar2 Descriptive flexfield.
43 --   p_attribute16                       varchar2 Descriptive flexfield.
44 --   p_attribute17                       varchar2 Descriptive flexfield.
45 --   p_attribute18                       varchar2 Descriptive flexfield.
46 --   p_attribute19                       varchar2 Descriptive flexfield.
47 --   p_attribute20                       varchar2 Descriptive flexfield.
48 --
49 -- Post Success:
50 -- Competence is created and sets the following out parameters.
51 --
52 --   Name                           Type     Description
53 --   p_assessment_group_id	    number   If p_validate is false, uniquely
54 --                                           identifies the assessment_group
55 --					     created.
56 --                                           If p_validate is true, set to
57 --                                           null.
58 --
59 --   p_object_version_number        number   If p_validate is false, set to
60 --                                           the version number of this
61 --                                           assessment_group. If p_validate is
62 --					    true, set to null.
63 -- Post Failure:
64 -- Does not create a assessment_group and the api raises an error.
65 --
66 -- Access Status:
67 --   Public.
68 --
69 -- {End Of Comments}
70 --
71 procedure create_assessment_group
72  (p_assessment_group_id          out      number,
73   p_name                         in       varchar2,
74   p_business_group_id            in       number,
75   p_comments                     in       varchar2         default null,
76   p_object_version_number        out      number,
77   p_attribute_category           in 	varchar2         default null,
78   p_attribute1                   in 	varchar2         default null,
79   p_attribute2                   in 	varchar2         default null,
80   p_attribute3                   in 	varchar2         default null,
81   p_attribute4                   in 	varchar2         default null,
82   p_attribute5                   in 	varchar2         default null,
83   p_attribute6                   in 	varchar2         default null,
84   p_attribute7                   in 	varchar2         default null,
85   p_attribute8                   in 	varchar2         default null,
86   p_attribute9                   in 	varchar2         default null,
87   p_attribute10                  in 	varchar2         default null,
88   p_attribute11                  in 	varchar2         default null,
89   p_attribute12                  in 	varchar2         default null,
90   p_attribute13                  in 	varchar2         default null,
91   p_attribute14                  in 	varchar2         default null,
92   p_attribute15                  in 	varchar2         default null,
93   p_attribute16                  in 	varchar2         default null,
94   p_attribute17                  in 	varchar2         default null,
95   p_attribute18                  in 	varchar2         default null,
96   p_attribute19                  in 	varchar2         default null,
97   p_attribute20                  in 	varchar2         default null,
98   p_validate                     in       boolean          default false,
99   p_effective_date               in       date
100   );
101 --
102 -- ----------------------------------------------------------------------------
103 -- |-----------------------< <update_assessment_group> >----------------------|
104 -- ----------------------------------------------------------------------------
105 -- {Start Of Comments}
106 --
107 -- Description:
108 -- This API updates an assessment_group as identified by the in parameter
109 -- p_assessment_group_id and the in out parameter p_object_version_number.
110 --
111 -- Prerequisites:
112 -- A valid assessment_group_id must be passed to the API.
113 --
114 -- In Parameters:
115 --   Name                           Reqd Type     Description
116 --   p_validate                          boolean  If true, the database
117 --                                                remains unchanged. If false,
118 --                                                the address is created.
119 --   p_effective_date               Yes  date     Effective date.
120 --   p_name                         Yes  varchar2 Is the unique name for the
121 --                                                assessment_group.
122 -- p_comments                           varchar2  free form text comments.
123 --                                                flexfield in parameters.
124 --   p_attribute_category                varchar2 Determines context
125 --   p_attribute1                        varchar2 Descriptive flexfield.
126 --   p_attribute2                        varchar2 Descriptive flexfield.
127 --   p_attribute3                        varchar2 Descriptive flexfield.
128 --   p_attribute4                        varchar2 Descriptive flexfield.
129 --   p_attribute5                        varchar2 Descriptive flexfield.
130 --   p_attribute6                        varchar2 Descriptive flexfield.
131 --   p_attribute7                        varchar2 Descriptive flexfield.
132 --   p_attribute8                        varchar2 Descriptive flexfield.
133 --   p_attribute9                        varchar2 Descriptive flexfield.
134 --   p_attribute10                       varchar2 Descriptive flexfield.
135 --   p_attribute11                       varchar2 Descriptive flexfield.
136 --   p_attribute12                       varchar2 Descriptive flexfield.
137 --   p_attribute13                       varchar2 Descriptive flexfield.
138 --   p_attribute14                       varchar2 Descriptive flexfield.
139 --   p_attribute15                       varchar2 Descriptive flexfield.
140 --   p_attribute16                       varchar2 Descriptive flexfield.
141 --   p_attribute17                       varchar2 Descriptive flexfield.
142 --   p_attribute18                       varchar2 Descriptive flexfield.
143 --   p_attribute19                       varchar2 Descriptive flexfield.
144 --   p_attribute20                       varchar2 Descriptive flexfield.
145 --
146 -- Post Success:
147 --   Assessment_group is updated and the API sets the following out parameters:
148 --
149 --   Name                           Type     Description
150 --   p_object_version_number        number   If p_validate is false, set to
151 --                                           the version number of this
152 --                                           assessment_group.
153 --					     If p_validate is true,
154 --                                           set to null.
155 --
156 -- Post Failure:
157 --   Assessment_group remains unchanged and the api raises an error.
158 --
159 -- Access Status:
160 --   Public.
161 --
162 -- {End Of Comments}
163 procedure update_assessment_group
164  (p_assessment_group_id          in number,
165   p_name                         in varchar2         default hr_api.g_varchar2,
166   p_comments                     in varchar2         default hr_api.g_varchar2,
167   p_object_version_number        in out number,
168   --
169   p_attribute_category           in varchar2         default hr_api.g_varchar2,
170   p_attribute1                   in varchar2         default hr_api.g_varchar2,
171   p_attribute2                   in varchar2         default hr_api.g_varchar2,
172   p_attribute3                   in varchar2         default hr_api.g_varchar2,
173   p_attribute4                   in varchar2         default hr_api.g_varchar2,
174   p_attribute5                   in varchar2         default hr_api.g_varchar2,
175   p_attribute6                   in varchar2         default hr_api.g_varchar2,
176   p_attribute7                   in varchar2         default hr_api.g_varchar2,
177   p_attribute8                   in varchar2         default hr_api.g_varchar2,
178   p_attribute9                   in varchar2         default hr_api.g_varchar2,
179   p_attribute10                  in varchar2         default hr_api.g_varchar2,
180   p_attribute11                  in varchar2         default hr_api.g_varchar2,
181   p_attribute12                  in varchar2         default hr_api.g_varchar2,
182   p_attribute13                  in varchar2         default hr_api.g_varchar2,
183   p_attribute14                  in varchar2         default hr_api.g_varchar2,
184   p_attribute15                  in varchar2         default hr_api.g_varchar2,
185   p_attribute16                  in varchar2         default hr_api.g_varchar2,
186   p_attribute17                  in varchar2         default hr_api.g_varchar2,
187   p_attribute18                  in varchar2         default hr_api.g_varchar2,
188   p_attribute19                  in varchar2         default hr_api.g_varchar2,
189   p_attribute20                  in varchar2         default hr_api.g_varchar2,
190   p_validate                     in boolean      default false,
191   p_effective_date               in date
192   );
193 --
194 -- ----------------------------------------------------------------------------
195 -- |----------------------< <delete_assessment_group> >-----------------------|
196 -- ----------------------------------------------------------------------------
197 -- {Start Of Comments}
198 --
199 -- Description:
200 -- Deletes an existing assessment_group.
201 --
202 -- Prerequisites:
203 -- A valid assessment_group must already exist.
204 --
205 -- In Parameters:
206 --   Name                           Reqd Type     Description
207 --   p_validate                          boolean  If true, the database
208 --                                                remains unchanged. If false,
209 --                                                the address is created.
210 --   p_assessment_group_id           Yes  number   Assessment_group to be deleted.
211 --						  If p_validate is false,
212 --						  uniquely identifies the
213 --						  assessment_group to be deleted.
214 --                                                If p_validate is true, set to
215 --                                                null.
216 --   p_object_version_number             number   If p_validate is false, set
217 --						  to the version number of this
218 --                                                assessment_type. If
219 --						  p_validate is true, set to
220 --						  null.
221 -- Post Success:
222 -- Assessment_group is removed from the database.
223 --
224 -- Post Failure:
225 -- Assessment_group is not deleted and an application error is raised.
226 --
227 -- Access Status:
228 --   Public.
229 --
230 procedure delete_assessment_group
231 (p_validate                           in boolean default false,
232  p_assessment_group_id                 in number,
233  p_object_version_number              in number
234 );
235 --
236 end hr_assessment_groups_api;