[Home] [Help]
PACKAGE: APPS.GHR_POSITION_EXTRA_INFO_API
Source
1 Package ghr_position_extra_info_api AUTHID CURRENT_USER as
2 /* $Header: ghpoiapi.pkh 120.0.12020000.5 2012/11/06 09:28:30 utokachi ship $ */
3 /*#
4 * This package contains the procedures for creating, updating a
8 * @rep:displayname Position Extra Information
5 * US Federal Position Extra Information.
6 * @rep:scope public
7 * @rep:product per
9 */
10 --
11 -- ----------------------------------------------------------------------------
12 -- |------------------------< create_position_extra_info >--------------------|
13 -- ----------------------------------------------------------------------------
14 --
15 -- {Start Of Comments}
16 /*#
17 * This API creates a new extra information for a given position.
18 *
19 *
20 * <p><b>Licensing</b><br>
21 * This API is licensed for use with Federal HR Foundation.
22 *
23 * <p><b>Prerequisites</b><br>
24 * Position and position information type must already exist.
25 *
26 * <p><b>Post Success</b><br>
27 * Position extra info is created.
28 *
29 * <p><b>Post Failure</b><br>
30 * The API does not create the position extra information and raises an error.
31 *
32 * @param p_validate If true, then validation alone will be performed and the
33 * database will remain unchanged. If false and all validation checks pass,
34 * then the database will be modified.
35 * @param p_position_id Uniquely identifies the position to which the extra
36 * information applies.
37 * @param p_information_type Information type the extra info applies to.
38 * @param p_effective_date Reference date for validating lookup values are
39 * applicable during the start to end active date range. This date does not
40 * determine when the changes take effect.
41 * @param p_poei_attribute_category This context value determines which
42 * flexfield structure to use with the poei_attribute descriptive flexfield
43 * segments.
44 * @param p_poei_attribute1 Descriptive flexfield
45 * @param p_poei_attribute2 Descriptive flexfield
46 * @param p_poei_attribute3 Descriptive flexfield
47 * @param p_poei_attribute4 Descriptive flexfield
48 * @param p_poei_attribute5 Descriptive flexfield
49 * @param p_poei_attribute6 Descriptive flexfield
50 * @param p_poei_attribute7 Descriptive flexfield
51 * @param p_poei_attribute8 Descriptive flexfield
52 * @param p_poei_attribute9 Descriptive flexfield
53 * @param p_poei_attribute10 Descriptive flexfield
54 * @param p_poei_attribute11 Descriptive flexfield
55 * @param p_poei_attribute12 Descriptive flexfield
56 * @param p_poei_attribute13 Descriptive flexfield
57 * @param p_poei_attribute14 Descriptive flexfield
58 * @param p_poei_attribute15 Descriptive flexfield
59 * @param p_poei_attribute16 Descriptive flexfield
60 * @param p_poei_attribute17 Descriptive flexfield
61 * @param p_poei_attribute18 Descriptive flexfield
62 * @param p_poei_attribute19 Descriptive flexfield
63 * @param p_poei_attribute20 Descriptive flexfield
64 * @param p_poei_information_category This context value determines which
65 * flexfield structure to use with the poei_information developer descriptive
66 * flexfield segments.
67 * @param p_poei_information1 Developer descriptive flexfield
68 * @param p_poei_information2 Developer descriptive flexfield
69 * @param p_poei_information3 Developer descriptive flexfield
70 * @param p_poei_information4 Developer descriptive flexfield
71 * @param p_poei_information5 Developer descriptive flexfield
72 * @param p_poei_information6 Developer descriptive flexfield
73 * @param p_poei_information7 Developer descriptive flexfield
74 * @param p_poei_information8 Developer descriptive flexfield
75 * @param p_poei_information9 Developer descriptive flexfield
76 * @param p_poei_information10 Developer descriptive flexfield
77 * @param p_poei_information11 Developer descriptive flexfield
78 * @param p_poei_information12 Developer descriptive flexfield
79 * @param p_poei_information13 Developer descriptive flexfield
80 * @param p_poei_information14 Developer descriptive flexfield
81 * @param p_poei_information15 Developer descriptive flexfield
82 * @param p_poei_information16 Developer descriptive flexfield
83 * @param p_poei_information17 Developer descriptive flexfield
84 * @param p_poei_information18 Developer descriptive flexfield
85 * @param p_poei_information19 Developer descriptive flexfield
86 * @param p_poei_information20 Developer descriptive flexfield
87 * @param p_poei_information21 Developer descriptive flexfield
88 * @param p_poei_information22 Developer descriptive flexfield
89 * @param p_poei_information23 Developer descriptive flexfield
90 * @param p_poei_information24 Developer descriptive flexfield
91 * @param p_poei_information25 Developer descriptive flexfield
92 * @param p_poei_information26 Developer descriptive flexfield
93 * @param p_poei_information27 Developer descriptive flexfield
94 * @param p_poei_information28 Developer descriptive flexfield
95 * @param p_poei_information29 Developer descriptive flexfield
96 * @param p_poei_information30 Developer descriptive flexfield
97 * @param p_position_extra_info_id If p_validate is false, uniquely identifies
98 * the position extra information created. If p_validate is true, set to null.
99 * @param p_object_version_number If p_validate is false, then set to the
100 * version number of the created Position Extra Information. If p_validate is
101 * true, then the value will be null.
102 * @rep:displayname Create Position Extra Information
103 * @rep:category BUSINESS_ENTITY PER_POSITION
104 * @rep:lifecycle active
105 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
106 * @rep:scope public
107 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
108 */
109 --
110 -- {End Of Comments}
111 --
112 --
113
114 procedure create_position_extra_info
115 (p_validate in boolean default false
116 ,p_position_id in number
117 ,p_information_type in varchar2
118 ,p_effective_date in date
119 ,p_poei_attribute_category in varchar2 default null
120 ,p_poei_attribute1 in varchar2 default null
124 ,p_poei_attribute5 in varchar2 default null
121 ,p_poei_attribute2 in varchar2 default null
122 ,p_poei_attribute3 in varchar2 default null
123 ,p_poei_attribute4 in varchar2 default null
125 ,p_poei_attribute6 in varchar2 default null
126 ,p_poei_attribute7 in varchar2 default null
127 ,p_poei_attribute8 in varchar2 default null
128 ,p_poei_attribute9 in varchar2 default null
129 ,p_poei_attribute10 in varchar2 default null
130 ,p_poei_attribute11 in varchar2 default null
131 ,p_poei_attribute12 in varchar2 default null
132 ,p_poei_attribute13 in varchar2 default null
133 ,p_poei_attribute14 in varchar2 default null
134 ,p_poei_attribute15 in varchar2 default null
135 ,p_poei_attribute16 in varchar2 default null
136 ,p_poei_attribute17 in varchar2 default null
137 ,p_poei_attribute18 in varchar2 default null
138 ,p_poei_attribute19 in varchar2 default null
139 ,p_poei_attribute20 in varchar2 default null
140 ,p_poei_information_category in varchar2 default null
141 ,p_poei_information1 in varchar2 default null
142 ,p_poei_information2 in varchar2 default null
143 ,p_poei_information3 in varchar2 default null
144 ,p_poei_information4 in varchar2 default null
145 ,p_poei_information5 in varchar2 default null
146 ,p_poei_information6 in varchar2 default null
147 ,p_poei_information7 in varchar2 default null
148 ,p_poei_information8 in varchar2 default null
149 ,p_poei_information9 in varchar2 default null
150 ,p_poei_information10 in varchar2 default null
151 ,p_poei_information11 in varchar2 default null
152 ,p_poei_information12 in varchar2 default null
153 ,p_poei_information13 in varchar2 default null
154 ,p_poei_information14 in varchar2 default null
155 ,p_poei_information15 in varchar2 default null
156 ,p_poei_information16 in varchar2 default null
157 ,p_poei_information17 in varchar2 default null
158 ,p_poei_information18 in varchar2 default null
159 ,p_poei_information19 in varchar2 default null
160 ,p_poei_information20 in varchar2 default null
161 ,p_poei_information21 in varchar2 default null
162 ,p_poei_information22 in varchar2 default null
163 ,p_poei_information23 in varchar2 default null
164 ,p_poei_information24 in varchar2 default null
165 ,p_poei_information25 in varchar2 default null
166 ,p_poei_information26 in varchar2 default null
167 ,p_poei_information27 in varchar2 default null
168 ,p_poei_information28 in varchar2 default null
169 ,p_poei_information29 in varchar2 default null
170 ,p_poei_information30 in varchar2 default null
171 ,p_position_extra_info_id out nocopy number
172 ,p_object_version_number out nocopy number
173 ) ;
174
175 -- ----------------------------------------------------------------------------
176 -- |------------------------< update_position_extra_info >--------------------|
177 -- ----------------------------------------------------------------------------
178 --
179 -- {Start Of Comments}
180 /*#
181 * This API updates extra information for a given position.
182 *
183 *
184 * <p><b>Licensing</b><br>
185 * This API is licensed for use with Federal HR Foundation.
186 *
187 * <p><b>Prerequisites</b><br>
188 * The position extra info as identified by the in parameter
189 * p_position_extra_info_id and the in out parameter p_object_version_number
190 * must already exist.
191 *
192 * <p><b>Post Success</b><br>
193 * The position extra info is updated.
194 *
195 * <p><b>Post Failure</b><br>
196 * The API does not update the position extra info and raises an error.
197 *
198 * @param p_validate If true, then validation alone will be performed and the
199 * database will remain unchanged. If false and all validation checks pass,
200 * then the database will be modified.
201 * @param p_position_extra_info_id Identifies the position extra info record to
202 * modify.
203 * @param p_object_version_number Pass in the current version number of the
204 * Position Extra Information to be updated. When the API completes if
205 * p_validate is false, will be set to the new version number of the updated
206 * Position Extra Information. If p_validate is true will be set to the same
207 * value which was passed in.
208 * @param p_effective_date Reference date for validating lookup values are
209 * applicable during the start to end active date range. This date does not
210 * determine when the changes take effect.
211 * @param p_poei_attribute_category This context value determines which
212 * flexfield structure to use with the poei_attribute descriptive flexfield
213 * segments.
214 * @param p_poei_attribute1 Descriptive flexfield
215 * @param p_poei_attribute2 Descriptive flexfield
216 * @param p_poei_attribute3 Descriptive flexfield
217 * @param p_poei_attribute4 Descriptive flexfield
218 * @param p_poei_attribute5 Descriptive flexfield
219 * @param p_poei_attribute6 Descriptive flexfield
220 * @param p_poei_attribute7 Descriptive flexfield
221 * @param p_poei_attribute8 Descriptive flexfield
222 * @param p_poei_attribute9 Descriptive flexfield
226 * @param p_poei_attribute13 Descriptive flexfield
223 * @param p_poei_attribute10 Descriptive flexfield
224 * @param p_poei_attribute11 Descriptive flexfield
225 * @param p_poei_attribute12 Descriptive flexfield
227 * @param p_poei_attribute14 Descriptive flexfield
228 * @param p_poei_attribute15 Descriptive flexfield
229 * @param p_poei_attribute16 Descriptive flexfield
230 * @param p_poei_attribute17 Descriptive flexfield
231 * @param p_poei_attribute18 Descriptive flexfield
232 * @param p_poei_attribute19 Descriptive flexfield
233 * @param p_poei_attribute20 Descriptive flexfield
234 * @param p_poei_information_category This context value determines which
235 * flexfield structure to use with the poei_information developer descriptive
236 * flexfield segments.
237 * @param p_poei_information1 Developer descriptive flexfield
238 * @param p_poei_information2 Developer descriptive flexfield
239 * @param p_poei_information3 Developer descriptive flexfield
240 * @param p_poei_information4 Developer descriptive flexfield
241 * @param p_poei_information5 Developer descriptive flexfield
242 * @param p_poei_information6 Developer descriptive flexfield
243 * @param p_poei_information7 Developer descriptive flexfield
244 * @param p_poei_information8 Developer descriptive flexfield
245 * @param p_poei_information9 Developer descriptive flexfield
246 * @param p_poei_information10 Developer descriptive flexfield
247 * @param p_poei_information11 Developer descriptive flexfield
248 * @param p_poei_information12 Developer descriptive flexfield
249 * @param p_poei_information13 Developer descriptive flexfield
250 * @param p_poei_information14 Developer descriptive flexfield
251 * @param p_poei_information15 Developer descriptive flexfield
252 * @param p_poei_information16 Developer descriptive flexfield
253 * @param p_poei_information17 Developer descriptive flexfield
254 * @param p_poei_information18 Developer descriptive flexfield
255 * @param p_poei_information19 Developer descriptive flexfield
256 * @param p_poei_information20 Developer descriptive flexfield
257 * @param p_poei_information21 Developer descriptive flexfield
258 * @param p_poei_information22 Developer descriptive flexfield
259 * @param p_poei_information23 Developer descriptive flexfield
260 * @param p_poei_information24 Developer descriptive flexfield
261 * @param p_poei_information25 Developer descriptive flexfield
262 * @param p_poei_information26 Developer descriptive flexfield
263 * @param p_poei_information27 Developer descriptive flexfield
264 * @param p_poei_information28 Developer descriptive flexfield
265 * @param p_poei_information29 Developer descriptive flexfield
266 * @param p_poei_information30 Developer descriptive flexfield
267 * @rep:displayname Update Position Extra Information
268 * @rep:category BUSINESS_ENTITY PER_POSITION
269 * @rep:lifecycle active
270 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
271 * @rep:scope public
272 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
273 */
274 --
275 -- {End Of Comments}
276 --
277 procedure update_position_extra_info
278 (p_validate in boolean default false
279 ,p_position_extra_info_id in number
280 ,p_object_version_number in out nocopy number
281 ,p_effective_date in date
282 ,p_poei_attribute_category in varchar2 default hr_api.g_varchar2
283 ,p_poei_attribute1 in varchar2 default hr_api.g_varchar2
284 ,p_poei_attribute2 in varchar2 default hr_api.g_varchar2
285 ,p_poei_attribute3 in varchar2 default hr_api.g_varchar2
286 ,p_poei_attribute4 in varchar2 default hr_api.g_varchar2
287 ,p_poei_attribute5 in varchar2 default hr_api.g_varchar2
288 ,p_poei_attribute6 in varchar2 default hr_api.g_varchar2
289 ,p_poei_attribute7 in varchar2 default hr_api.g_varchar2
290 ,p_poei_attribute8 in varchar2 default hr_api.g_varchar2
291 ,p_poei_attribute9 in varchar2 default hr_api.g_varchar2
292 ,p_poei_attribute10 in varchar2 default hr_api.g_varchar2
293 ,p_poei_attribute11 in varchar2 default hr_api.g_varchar2
294 ,p_poei_attribute12 in varchar2 default hr_api.g_varchar2
295 ,p_poei_attribute13 in varchar2 default hr_api.g_varchar2
296 ,p_poei_attribute14 in varchar2 default hr_api.g_varchar2
297 ,p_poei_attribute15 in varchar2 default hr_api.g_varchar2
298 ,p_poei_attribute16 in varchar2 default hr_api.g_varchar2
299 ,p_poei_attribute17 in varchar2 default hr_api.g_varchar2
300 ,p_poei_attribute18 in varchar2 default hr_api.g_varchar2
301 ,p_poei_attribute19 in varchar2 default hr_api.g_varchar2
302 ,p_poei_attribute20 in varchar2 default hr_api.g_varchar2
303 ,p_poei_information_category in varchar2 default hr_api.g_varchar2
304 ,p_poei_information1 in varchar2 default hr_api.g_varchar2
305 ,p_poei_information2 in varchar2 default hr_api.g_varchar2
306 ,p_poei_information3 in varchar2 default hr_api.g_varchar2
307 ,p_poei_information4 in varchar2 default hr_api.g_varchar2
308 ,p_poei_information5 in varchar2 default hr_api.g_varchar2
309 ,p_poei_information6 in varchar2 default hr_api.g_varchar2
310 ,p_poei_information7 in varchar2 default hr_api.g_varchar2
311 ,p_poei_information8 in varchar2 default hr_api.g_varchar2
312 ,p_poei_information9 in varchar2 default hr_api.g_varchar2
313 ,p_poei_information10 in varchar2 default hr_api.g_varchar2
314 ,p_poei_information11 in varchar2 default hr_api.g_varchar2
315 ,p_poei_information12 in varchar2 default hr_api.g_varchar2
316 ,p_poei_information13 in varchar2 default hr_api.g_varchar2
317 ,p_poei_information14 in varchar2 default hr_api.g_varchar2
318 ,p_poei_information15 in varchar2 default hr_api.g_varchar2
319 ,p_poei_information16 in varchar2 default hr_api.g_varchar2
320 ,p_poei_information17 in varchar2 default hr_api.g_varchar2
321 ,p_poei_information18 in varchar2 default hr_api.g_varchar2
322 ,p_poei_information19 in varchar2 default hr_api.g_varchar2
323 ,p_poei_information20 in varchar2 default hr_api.g_varchar2
324 ,p_poei_information21 in varchar2 default hr_api.g_varchar2
325 ,p_poei_information22 in varchar2 default hr_api.g_varchar2
326 ,p_poei_information23 in varchar2 default hr_api.g_varchar2
327 ,p_poei_information24 in varchar2 default hr_api.g_varchar2
328 ,p_poei_information25 in varchar2 default hr_api.g_varchar2
329 ,p_poei_information26 in varchar2 default hr_api.g_varchar2
330 ,p_poei_information27 in varchar2 default hr_api.g_varchar2
331 ,p_poei_information28 in varchar2 default hr_api.g_varchar2
332 ,p_poei_information29 in varchar2 default hr_api.g_varchar2
333 ,p_poei_information30 in varchar2 default hr_api.g_varchar2
334 );
335 end ghr_position_extra_info_api;