1 Package hr_no_qualification_type_api as
2 /* $Header: peeqtnoi.pkh 120.1 2005/10/02 02:41 aroussel $ */
3 /*#
4 * This package contains qualification type APIs for Norway.
5 * @rep:scope public
6 * @rep:product PER
7 * @rep:displayname Qualification Type for Norway
8 */
9 --
10 -- ----------------------------------------------------------------------------
11 -- |-----------------------< create_no_qualification_type >-------------------|
12 -- ----------------------------------------------------------------------------
13 --
14 -- {Start Of Comments}
15 /*#
16 * This API creates a new qualification type for Norway.
17 *
18 * This API creates a qualification type for a business group with a
19 * legislation code of Norway.
20 *
21 * <p><b>Licensing</b><br>
22 * This API is licensed for use with Human Resources.
23 *
24 * <p><b>Prerequisites</b><br>
25 * A valid business group must exist.
26 *
27 * <p><b>Post Success</b><br>
28 * A new qualification type will be successfully inserted into the database.
29 *
30 * <p><b>Post Failure</b><br>
31 * The qualification type will not be created, and an error will be raised.
32 *
33 * @param p_validate If true, then validation alone will be performed and the
34 * database will remain unchanged. If false and all validation checks pass,
35 * then the database will be modified.
36 * @param p_effective_date Determines when the DateTrack operation comes into
37 * force.
38 * @param p_language_code Specifies to which language the translation values
39 * apply. You can set to the base or any installed language. The default value
40 * of hr_api.userenv_lang is equivalent to the RDBMS userenv('LANG') function
41 * value.
42 * @param p_name Qualification type name.
43 * @param p_category A grouping or categorization of the qualification type.
44 * Valid values are defined in the PER_CATEGORIES lookup type.
45 * @param p_rank The rank of the qualification.
46 * @param p_attribute_category This context value determines which flexfield
47 * structure to use with the descriptive flexfield segments.
48 * @param p_attribute1 Descriptive flexfield segment.
49 * @param p_attribute2 Descriptive flexfield segment.
50 * @param p_attribute3 Descriptive flexfield segment.
51 * @param p_attribute4 Descriptive flexfield segment.
52 * @param p_attribute5 Descriptive flexfield segment.
53 * @param p_attribute6 Descriptive flexfield segment.
54 * @param p_attribute7 Descriptive flexfield segment.
55 * @param p_attribute8 Descriptive flexfield segment.
56 * @param p_attribute9 Descriptive flexfield segment.
57 * @param p_attribute10 Descriptive flexfield segment.
58 * @param p_attribute11 Descriptive flexfield segment.
59 * @param p_attribute12 Descriptive flexfield segment.
60 * @param p_attribute13 Descriptive flexfield segment.
61 * @param p_attribute14 Descriptive flexfield segment.
62 * @param p_attribute15 Descriptive flexfield segment.
63 * @param p_attribute16 Descriptive flexfield segment.
64 * @param p_attribute17 Descriptive flexfield segment.
65 * @param p_attribute18 Descriptive flexfield segment.
66 * @param p_attribute19 Descriptive flexfield segment.
67 * @param p_attribute20 Descriptive flexfield segment.
68 * @param p_information_category This context value determines which flexfield
69 * structure to use with the developer descriptive flexfield segments.
70 * @param p_nus2000_code NUS-2000 code.
71 * @param p_qual_framework_id Qualifications Framework identifier for the
72 * qualification.
73 * @param p_qualification_type Qualifications Framework qualification type.
74 * @param p_credit_type Qualifications Framework credit type.
75 * @param p_credits Qualifications Framework credits.
76 * @param p_level_type Qualifications Framework level type.
77 * @param p_level_number Qualifications Framework level.
78 * @param p_field Qualifications Framework field of learning.
79 * @param p_sub_field Qualifications Framework subsidiary field of learning.
80 * @param p_provider Qualification provider.
81 * @param p_qa_organization Quality Assurance (QA) organization that registered
82 * the qualification provider.
83 * @param p_qualification_type_id Identifier of the qualification type.
84 * @param p_object_version_number If p_validate is false, then set to the
85 * version number of the created qualification type. If p_validate is true,
86 * then the value will be null.
87 * @rep:displayname Create Qualification Type for Norway
88 * @rep:category BUSINESS_ENTITY PER_QUALIFICATION
89 * @rep:lifecycle active
90 * @rep:scope public
91 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
92 */
93 --
94 -- {End Of Comments}
95 --
96 procedure create_no_qualification_type
97 (p_validate in boolean default false
98 ,p_effective_date in date
99 ,p_language_code in varchar2 default hr_api.userenv_lang
100 ,p_name in varchar2
101 ,p_category in varchar2
102 ,p_rank in number default null
103 ,p_attribute_category in varchar2 default null
104 ,p_attribute1 in varchar2 default null
105 ,p_attribute2 in varchar2 default null
106 ,p_attribute3 in varchar2 default null
107 ,p_attribute4 in varchar2 default null
108 ,p_attribute5 in varchar2 default null
109 ,p_attribute6 in varchar2 default null
110 ,p_attribute7 in varchar2 default null
111 ,p_attribute8 in varchar2 default null
112 ,p_attribute9 in varchar2 default null
113 ,p_attribute10 in varchar2 default null
114 ,p_attribute11 in varchar2 default null
115 ,p_attribute12 in varchar2 default null
116 ,p_attribute13 in varchar2 default null
117 ,p_attribute14 in varchar2 default null
118 ,p_attribute15 in varchar2 default null
119 ,p_attribute16 in varchar2 default null
120 ,p_attribute17 in varchar2 default null
121 ,p_attribute18 in varchar2 default null
122 ,p_attribute19 in varchar2 default null
123 ,p_attribute20 in varchar2 default null
124 ,p_information_category in varchar2 default null
125 ,p_nus2000_code in varchar2 default null
126 ,p_qual_framework_id in number default null
127 ,p_qualification_type in varchar2 default null
128 ,p_credit_type in varchar2 default null
129 ,p_credits in number default null
130 ,p_level_type in varchar2 default null
131 ,p_level_number in number default null
132 ,p_field in varchar2 default null
133 ,p_sub_field in varchar2 default null
134 ,p_provider in varchar2 default null
135 ,p_qa_organization in varchar2 default null
136 ,p_qualification_type_id out NOCOPY number
137 ,p_object_version_number out NOCOPY number
138 ) ;
139 --
140 -- ----------------------------------------------------------------------------
141 -- |-----------------------< update_no_qualification_type >-------------------|
142 -- ----------------------------------------------------------------------------
143 --
144 -- {Start Of Comments}
145 /*#
146 * This API updates an existing qualification type.
147 *
148 * This API updates the qualification type identified by the in parameter
149 * p_qualification_type_id and the in out parameter p_object_version_number.
150 *
151 * <p><b>Licensing</b><br>
152 * This API is licensed for use with Human Resources.
153 *
154 * <p><b>Prerequisites</b><br>
155 * The qualification type must exist.
156 *
157 * <p><b>Post Success</b><br>
158 * The qualification type is successfully updated in the database.
159 *
160 * <p><b>Post Failure</b><br>
161 * The qualification type will not be updated, and an error will be raised.
162 *
163 * @param p_validate If true, then validation alone will be performed and the
164 * database will remain unchanged. If false and all validation checks pass,
165 * then the database will be modified.
166 * @param p_qualification_type_id Identifier of the qualification type.
167 * @param p_object_version_number Pass in the current version number of the
168 * qualification type. to be updated. When the API completes if p_validate is
169 * false, will be set to the new version number of the updated qualification
170 * type. If p_validate is true will be set to the same value which was passed
171 * in.
172 * @param p_effective_date Determines when the DateTrack operation comes into
173 * force.
174 * @param p_language_code Specifies to which language the translation values
175 * apply. You can set to the base or any installed language. The default value
176 * of hr_api.userenv_lang is equivalent to the RDBMS userenv('LANG') function
177 * value.
178 * @param p_name Qualification type name.
179 * @param p_category A grouping or categorization of the qualification type.
180 * Valid values are defined in the PER_CATEGORIES lookup type.
181 * @param p_rank The rank of the qualification.
182 * @param p_attribute_category This context value determines which flexfield
183 * structure to use with the descriptive flexfield segments.
184 * @param p_attribute1 Descriptive flexfield segment.
185 * @param p_attribute2 Descriptive flexfield segment.
186 * @param p_attribute3 Descriptive flexfield segment.
187 * @param p_attribute4 Descriptive flexfield segment.
188 * @param p_attribute5 Descriptive flexfield segment.
189 * @param p_attribute6 Descriptive flexfield segment.
190 * @param p_attribute7 Descriptive flexfield segment.
191 * @param p_attribute8 Descriptive flexfield segment.
192 * @param p_attribute9 Descriptive flexfield segment.
193 * @param p_attribute10 Descriptive flexfield segment.
194 * @param p_attribute11 Descriptive flexfield segment.
195 * @param p_attribute12 Descriptive flexfield segment.
196 * @param p_attribute13 Descriptive flexfield segment.
197 * @param p_attribute14 Descriptive flexfield segment.
198 * @param p_attribute15 Descriptive flexfield segment.
199 * @param p_attribute16 Descriptive flexfield segment.
200 * @param p_attribute17 Descriptive flexfield segment.
201 * @param p_attribute18 Descriptive flexfield segment.
205 * structure to use with the developer descriptive flexfield segments.
202 * @param p_attribute19 Descriptive flexfield segment.
203 * @param p_attribute20 Descriptive flexfield segment.
204 * @param p_information_category This context value determines which flexfield
206 * @param p_nus2000_code NUS-2000 code.
207 * @param p_qual_framework_id Qualifications Framework identifier for the
208 * qualification.
209 * @param p_qualification_type Qualifications Framework qualification type.
210 * @param p_credit_type Qualifications Framework credit type.
211 * @param p_credits Qualifications Framework credits.
212 * @param p_level_type Qualifications Framework level type.
213 * @param p_level_number Qualifications Framework level.
214 * @param p_field Qualifications Framework field of learning.
215 * @param p_sub_field Qualifications Framework subsidiary field of learning.
216 * @param p_provider Qualification provider.
217 * @param p_qa_organization Quality Assurance (QA) organization post success:
218 * when the qualification type is valid, the API updates the qualification type
219 * successfully.
220 * @rep:displayname Update Qualification Type for Norway
221 * @rep:category BUSINESS_ENTITY PER_QUALIFICATION
222 * @rep:lifecycle active
223 * @rep:scope public
224 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
225 */
226 --
227 -- {End Of Comments}
228 --
229 procedure update_no_qualification_type
230 (p_validate in boolean default false
231 ,p_qualification_type_id in number
232 ,p_object_version_number in out nocopy number
233 ,p_effective_date in date
234 ,p_language_code in varchar2 default hr_api.userenv_lang
235 ,p_name in varchar2 default hr_api.g_varchar2
236 ,p_category in varchar2 default hr_api.g_varchar2
237 ,p_rank in number default hr_api.g_number
238 ,p_attribute_category in varchar2 default hr_api.g_varchar2
239 ,p_attribute1 in varchar2 default hr_api.g_varchar2
240 ,p_attribute2 in varchar2 default hr_api.g_varchar2
241 ,p_attribute3 in varchar2 default hr_api.g_varchar2
242 ,p_attribute4 in varchar2 default hr_api.g_varchar2
243 ,p_attribute5 in varchar2 default hr_api.g_varchar2
244 ,p_attribute6 in varchar2 default hr_api.g_varchar2
245 ,p_attribute7 in varchar2 default hr_api.g_varchar2
246 ,p_attribute8 in varchar2 default hr_api.g_varchar2
247 ,p_attribute9 in varchar2 default hr_api.g_varchar2
248 ,p_attribute10 in varchar2 default hr_api.g_varchar2
249 ,p_attribute11 in varchar2 default hr_api.g_varchar2
250 ,p_attribute12 in varchar2 default hr_api.g_varchar2
251 ,p_attribute13 in varchar2 default hr_api.g_varchar2
252 ,p_attribute14 in varchar2 default hr_api.g_varchar2
253 ,p_attribute15 in varchar2 default hr_api.g_varchar2
254 ,p_attribute16 in varchar2 default hr_api.g_varchar2
255 ,p_attribute17 in varchar2 default hr_api.g_varchar2
256 ,p_attribute18 in varchar2 default hr_api.g_varchar2
257 ,p_attribute19 in varchar2 default hr_api.g_varchar2
258 ,p_attribute20 in varchar2 default hr_api.g_varchar2
259 ,p_information_category in varchar2 default hr_api.g_varchar2
260 ,p_nus2000_code in varchar2 default hr_api.g_varchar2
261 ,p_qual_framework_id in number default hr_api.g_number
262 ,p_qualification_type in varchar2 default hr_api.g_varchar2
263 ,p_credit_type in varchar2 default hr_api.g_varchar2
264 ,p_credits in number default hr_api.g_number
265 ,p_level_type in varchar2 default hr_api.g_varchar2
266 ,p_level_number in number default hr_api.g_number
267 ,p_field in varchar2 default hr_api.g_varchar2
268 ,p_sub_field in varchar2 default hr_api.g_varchar2
269 ,p_provider in varchar2 default hr_api.g_varchar2
270 ,p_qa_organization in varchar2 default hr_api.g_varchar2
271 );
272
273 end hr_no_qualification_type_api;