[Home] [Help]
PACKAGE: APPS.PQP_SHP_API
Source
1 Package pqp_shp_api as
2 /* $Header: pqshpapi.pkh 120.1 2005/10/02 02:27:57 aroussel $ */
3 /*#
4 * This package contains employment service history API's.
5 * @rep:scope public
6 * @rep:product per
7 * @rep:displayname Employment Service History
8 */
9 --
10 -- ----------------------------------------------------------------------------
11 -- |----------------------< create_service_history_period >-------------------|
12 -- ----------------------------------------------------------------------------
13 --
14 -- {Start Of Comments}
15 /*#
16 * This API creates employment service history.
17 *
18 * This API creates employment service history period information for an
19 * employee assignment.
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 * This employee should have an assignment before creating a service history
26 * period.
27 *
28 * <p><b>Post Success</b><br>
29 * The employment service history record will be successfully inserted into the
30 * database.
31 *
32 * <p><b>Post Failure</b><br>
33 * The employment service history record will not be created and an error will
34 * be raised.
35 * @param p_validate If true, then validation alone will be performed and the
36 * database will remain unchanged. If false and all validation checks pass,
37 * then the database will be modified.
38 * @param p_business_group_id {@rep:casecolumn
39 * PQP_SERVICE_HISTORY_PERIODS.BUSINESS_GROUP_ID}
40 * @param p_assignment_id Identifies the assignment for which you create the
41 * employment service history record.
42 * @param p_start_date {@rep:casecolumn PQP_SERVICE_HISTORY_PERIODS.START_DATE}
43 * @param p_end_date {@rep:casecolumn PQP_SERVICE_HISTORY_PERIODS.END_DATE}
44 * @param p_employer_name {@rep:casecolumn
45 * PQP_SERVICE_HISTORY_PERIODS.EMPLOYER_NAME}
46 * @param p_employer_address {@rep:casecolumn
47 * PQP_SERVICE_HISTORY_PERIODS.EMPLOYER_ADDRESS}
48 * @param p_employer_type {@rep:casecolumn
49 * PQP_SERVICE_HISTORY_PERIODS.EMPLOYER_TYPE}
50 * @param p_employer_subtype {@rep:casecolumn
51 * PQP_SERVICE_HISTORY_PERIODS.EMPLOYER_SUBTYPE}
52 * @param p_description {@rep:casecolumn
53 * PQP_SERVICE_HISTORY_PERIODS.CONTINUOUS_SERVICE}
54 * @param p_continuous_service {@rep:casecolumn
55 * PQP_SERVICE_HISTORY_PERIODS.ALL_ASSIGNMENTS}
56 * @param p_all_assignments {@rep:casecolumn
57 * PQP_SERVICE_HISTORY_PERIODS.DESCRIPTION}
58 * @param p_period_years {@rep:casecolumn
59 * PQP_SERVICE_HISTORY_PERIODS.PERIOD_YEARS}
60 * @param p_period_days {@rep:casecolumn
61 * PQP_SERVICE_HISTORY_PERIODS.PERIOD_DAYS}
62 * @param p_shp_attribute_category {@rep:casecolumn
63 * PQP_SERVICE_HISTORY_PERIODS.SHP_ATTRIBUTE_CATEGORY}
64 * @param p_shp_attribute1 {@rep:casecolumn
65 * PQP_SERVICE_HISTORY_PERIODS.SHP_ATTRIBUTE1}
66 * @param p_shp_attribute2 {@rep:casecolumn
67 * PQP_SERVICE_HISTORY_PERIODS.SHP_ATTRIBUTE2}
68 * @param p_shp_attribute3 {@rep:casecolumn
69 * PQP_SERVICE_HISTORY_PERIODS.SHP_ATTRIBUTE3}
70 * @param p_shp_attribute4 {@rep:casecolumn
71 * PQP_SERVICE_HISTORY_PERIODS.SHP_ATTRIBUTE4}
72 * @param p_shp_attribute5 {@rep:casecolumn
73 * PQP_SERVICE_HISTORY_PERIODS.SHP_ATTRIBUTE5}
74 * @param p_shp_attribute6 {@rep:casecolumn
75 * PQP_SERVICE_HISTORY_PERIODS.SHP_ATTRIBUTE6}
76 * @param p_shp_attribute7 {@rep:casecolumn
77 * PQP_SERVICE_HISTORY_PERIODS.SHP_ATTRIBUTE7}
78 * @param p_shp_attribute8 {@rep:casecolumn
79 * PQP_SERVICE_HISTORY_PERIODS.SHP_ATTRIBUTE8}
80 * @param p_shp_attribute9 {@rep:casecolumn
81 * PQP_SERVICE_HISTORY_PERIODS.SHP_ATTRIBUTE9}
82 * @param p_shp_attribute10 {@rep:casecolumn
83 * PQP_SERVICE_HISTORY_PERIODS.SHP_ATTRIBUTE10}
84 * @param p_shp_attribute11 {@rep:casecolumn
85 * PQP_SERVICE_HISTORY_PERIODS.SHP_ATTRIBUTE11}
86 * @param p_shp_attribute12 {@rep:casecolumn
87 * PQP_SERVICE_HISTORY_PERIODS.SHP_ATTRIBUTE12}
88 * @param p_shp_attribute13 {@rep:casecolumn
89 * PQP_SERVICE_HISTORY_PERIODS.SHP_ATTRIBUTE13}
90 * @param p_shp_attribute14 {@rep:casecolumn
91 * PQP_SERVICE_HISTORY_PERIODS.SHP_ATTRIBUTE14}
92 * @param p_shp_attribute15 {@rep:casecolumn
93 * PQP_SERVICE_HISTORY_PERIODS.SHP_ATTRIBUTE15}
94 * @param p_shp_attribute16 {@rep:casecolumn
95 * PQP_SERVICE_HISTORY_PERIODS.SHP_ATTRIBUTE16}
96 * @param p_shp_attribute17 {@rep:casecolumn
97 * PQP_SERVICE_HISTORY_PERIODS.SHP_ATTRIBUTE17}
98 * @param p_shp_attribute18 {@rep:casecolumn
99 * PQP_SERVICE_HISTORY_PERIODS.SHP_ATTRIBUTE18}
100 * @param p_shp_attribute19 {@rep:casecolumn
101 * PQP_SERVICE_HISTORY_PERIODS.SHP_ATTRIBUTE19}
102 * @param p_shp_attribute20 {@rep:casecolumn
103 * PQP_SERVICE_HISTORY_PERIODS.SHP_ATTRIBUTE20}
104 * @param p_shp_information_category {@rep:casecolumn
105 * PQP_SERVICE_HISTORY_PERIODS.SHP_INFORMATION_CATEGORY}
106 * @param p_shp_information1 {@rep:casecolumn
107 * PQP_SERVICE_HISTORY_PERIODS.SHP_INFORMATION1}
108 * @param p_shp_information2 {@rep:casecolumn
109 * PQP_SERVICE_HISTORY_PERIODS.SHP_INFORMATION2}
110 * @param p_shp_information3 {@rep:casecolumn
111 * PQP_SERVICE_HISTORY_PERIODS.SHP_INFORMATION3}
112 * @param p_shp_information4 {@rep:casecolumn
113 * PQP_SERVICE_HISTORY_PERIODS.SHP_INFORMATION4}
114 * @param p_shp_information5 {@rep:casecolumn
115 * PQP_SERVICE_HISTORY_PERIODS.SHP_INFORMATION5}
116 * @param p_shp_information6 {@rep:casecolumn
117 * PQP_SERVICE_HISTORY_PERIODS.SHP_INFORMATION6}
118 * @param p_shp_information7 {@rep:casecolumn
119 * PQP_SERVICE_HISTORY_PERIODS.SHP_INFORMATION7}
120 * @param p_shp_information8 {@rep:casecolumn
121 * PQP_SERVICE_HISTORY_PERIODS.SHP_INFORMATION8}
122 * @param p_shp_information9 {@rep:casecolumn
123 * PQP_SERVICE_HISTORY_PERIODS.SHP_INFORMATION9}
124 * @param p_shp_information10 {@rep:casecolumn
125 * PQP_SERVICE_HISTORY_PERIODS.SHP_INFORMATION10}
126 * @param p_shp_information11 {@rep:casecolumn
127 * PQP_SERVICE_HISTORY_PERIODS.SHP_INFORMATION11}
128 * @param p_shp_information12 {@rep:casecolumn
129 * PQP_SERVICE_HISTORY_PERIODS.SHP_INFORMATION12}
130 * @param p_shp_information13 {@rep:casecolumn
131 * PQP_SERVICE_HISTORY_PERIODS.SHP_INFORMATION13}
132 * @param p_shp_information14 {@rep:casecolumn
133 * PQP_SERVICE_HISTORY_PERIODS.SHP_INFORMATION14}
134 * @param p_shp_information15 {@rep:casecolumn
135 * PQP_SERVICE_HISTORY_PERIODS.SHP_INFORMATION15}
136 * @param p_shp_information16 {@rep:casecolumn
137 * PQP_SERVICE_HISTORY_PERIODS.SHP_INFORMATION16}
138 * @param p_shp_information17 {@rep:casecolumn
139 * PQP_SERVICE_HISTORY_PERIODS.SHP_INFORMATION17}
140 * @param p_shp_information18 {@rep:casecolumn
141 * PQP_SERVICE_HISTORY_PERIODS.SHP_INFORMATION18}
142 * @param p_shp_information19 {@rep:casecolumn
143 * PQP_SERVICE_HISTORY_PERIODS.SHP_INFORMATION19}
144 * @param p_shp_information20 {@rep:casecolumn
145 * PQP_SERVICE_HISTORY_PERIODS.SHP_INFORMATION20}
146 * @param p_service_history_period_id {@rep:casecolumn
147 * PQP_SERVICE_HISTORY_PERIODS.SERVICE_HISTORY_PERIOD_ID}
148 * @param p_object_version_number If p_validate is false, then set to the
149 * version number of the created employment service history. If p_validate is
150 * true, then the value will be null.
151 * @rep:displayname Create Employment Service History
152 * @rep:category BUSINESS_ENTITY PER_EMPLOYEE_ASG
153 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
154 * @rep:scope public
155 * @rep:lifecycle active
156 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
157 */
158 --
159 -- {End Of Comments}
160 --
161 procedure create_service_history_period
162 (p_validate in boolean default false
163 ,p_business_group_id in number
164 ,p_assignment_id in number
165 ,p_start_date in date default null
166 ,p_end_date in date default null
167 ,p_employer_name in varchar2 default null
168 ,p_employer_address in varchar2 default null
169 ,p_employer_type in varchar2 default null
170 ,p_employer_subtype in varchar2 default null
171 ,p_description in varchar2 default null
172 ,p_continuous_service in varchar2 default null
173 ,p_all_assignments in varchar2 default null
174 ,p_period_years in number default null
175 ,p_period_days in number default null
176 ,p_shp_attribute_category in varchar2 default null
177 ,p_shp_attribute1 in varchar2 default null
178 ,p_shp_attribute2 in varchar2 default null
179 ,p_shp_attribute3 in varchar2 default null
180 ,p_shp_attribute4 in varchar2 default null
181 ,p_shp_attribute5 in varchar2 default null
182 ,p_shp_attribute6 in varchar2 default null
183 ,p_shp_attribute7 in varchar2 default null
184 ,p_shp_attribute8 in varchar2 default null
185 ,p_shp_attribute9 in varchar2 default null
186 ,p_shp_attribute10 in varchar2 default null
187 ,p_shp_attribute11 in varchar2 default null
188 ,p_shp_attribute12 in varchar2 default null
189 ,p_shp_attribute13 in varchar2 default null
190 ,p_shp_attribute14 in varchar2 default null
191 ,p_shp_attribute15 in varchar2 default null
192 ,p_shp_attribute16 in varchar2 default null
193 ,p_shp_attribute17 in varchar2 default null
194 ,p_shp_attribute18 in varchar2 default null
195 ,p_shp_attribute19 in varchar2 default null
196 ,p_shp_attribute20 in varchar2 default null
197 ,p_shp_information_category in varchar2 default null
198 ,p_shp_information1 in varchar2 default null
199 ,p_shp_information2 in varchar2 default null
200 ,p_shp_information3 in varchar2 default null
201 ,p_shp_information4 in varchar2 default null
202 ,p_shp_information5 in varchar2 default null
203 ,p_shp_information6 in varchar2 default null
204 ,p_shp_information7 in varchar2 default null
205 ,p_shp_information8 in varchar2 default null
206 ,p_shp_information9 in varchar2 default null
207 ,p_shp_information10 in varchar2 default null
208 ,p_shp_information11 in varchar2 default null
209 ,p_shp_information12 in varchar2 default null
210 ,p_shp_information13 in varchar2 default null
211 ,p_shp_information14 in varchar2 default null
212 ,p_shp_information15 in varchar2 default null
213 ,p_shp_information16 in varchar2 default null
214 ,p_shp_information17 in varchar2 default null
215 ,p_shp_information18 in varchar2 default null
216 ,p_shp_information19 in varchar2 default null
217 ,p_shp_information20 in varchar2 default null
218 ,p_service_history_period_id out nocopy number
219 ,p_object_version_number out nocopy number
220 );
221 --
222 -- ----------------------------------------------------------------------------
223 -- |----------------------< update_service_history_period >-------------------|
224 -- ----------------------------------------------------------------------------
225 --
226 -- {Start Of Comments}
227 /*#
228 * This API updates employment service history period information for an
229 * employee assignment.
230 *
231 * This API updates employment service history period information for an
232 * employee assignment.
233 *
234 * <p><b>Licensing</b><br>
235 * This API is licensed for use with Human Resources.
236 *
237 * <p><b>Prerequisites</b><br>
238 * An employment service history record for this assignment should exist before
239 * updating.
240 *
241 * <p><b>Post Success</b><br>
242 * The employment service history record will be successfully updated into the
243 * database.
244 *
245 * <p><b>Post Failure</b><br>
246 * The employment service history record will not be updated and an error will
247 * be raised.
248 * @param p_validate If true, then validation alone will be performed and the
249 * database will remain unchanged. If false and all validation checks pass,
250 * then the database will be modified.
251 * @param p_service_history_period_id {@rep:casecolumn
252 * PQP_SERVICE_HISTORY_PERIODS.SERVICE_HISTORY_PERIOD_ID}
253 * @param p_assignment_id Identifies the assignment record to modify.
254 * @param p_start_date {@rep:casecolumn PQP_SERVICE_HISTORY_PERIODS.START_DATE}
255 * @param p_end_date {@rep:casecolumn PQP_SERVICE_HISTORY_PERIODS.END_DATE}
256 * @param p_employer_name {@rep:casecolumn
257 * PQP_SERVICE_HISTORY_PERIODS.EMPLOYER_NAME}
258 * @param p_employer_address {@rep:casecolumn
259 * PQP_SERVICE_HISTORY_PERIODS.EMPLOYER_ADDRESS}
260 * @param p_employer_type {@rep:casecolumn
261 * PQP_SERVICE_HISTORY_PERIODS.EMPLOYER_TYPE}
262 * @param p_employer_subtype {@rep:casecolumn
263 * PQP_SERVICE_HISTORY_PERIODS.EMPLOYER_SUBTYPE}
264 * @param p_description {@rep:casecolumn
265 * PQP_SERVICE_HISTORY_PERIODS.DESCRIPTION}
266 * @param p_continuous_service {@rep:casecolumn
267 * PQP_SERVICE_HISTORY_PERIODS.CONTINUOUS_SERVICE}
268 * @param p_all_assignments {@rep:casecolumn
269 * PQP_SERVICE_HISTORY_PERIODS.ALL_ASSIGNMENTS}
270 * @param p_period_years {@rep:casecolumn
271 * PQP_SERVICE_HISTORY_PERIODS.PERIOD_YEARS}
272 * @param p_period_days {@rep:casecolumn
273 * PQP_SERVICE_HISTORY_PERIODS.PERIOD_DAYS}
274 * @param p_shp_attribute_category {@rep:casecolumn
275 * PQP_SERVICE_HISTORY_PERIODS.SHP_ATTRIBUTE_CATEGORY}
276 * @param p_shp_attribute1 {@rep:casecolumn
277 * PQP_SERVICE_HISTORY_PERIODS.SHP_ATTRIBUTE1}
278 * @param p_shp_attribute2 {@rep:casecolumn
279 * PQP_SERVICE_HISTORY_PERIODS.SHP_ATTRIBUTE2}
280 * @param p_shp_attribute3 {@rep:casecolumn
281 * PQP_SERVICE_HISTORY_PERIODS.SHP_ATTRIBUTE3}
282 * @param p_shp_attribute4 {@rep:casecolumn
283 * PQP_SERVICE_HISTORY_PERIODS.SHP_ATTRIBUTE4}
284 * @param p_shp_attribute5 {@rep:casecolumn
285 * PQP_SERVICE_HISTORY_PERIODS.SHP_ATTRIBUTE5}
286 * @param p_shp_attribute6 {@rep:casecolumn
287 * PQP_SERVICE_HISTORY_PERIODS.SHP_ATTRIBUTE6}
288 * @param p_shp_attribute7 {@rep:casecolumn
289 * PQP_SERVICE_HISTORY_PERIODS.SHP_ATTRIBUTE7}
290 * @param p_shp_attribute8 {@rep:casecolumn
291 * PQP_SERVICE_HISTORY_PERIODS.SHP_ATTRIBUTE8}
292 * @param p_shp_attribute9 {@rep:casecolumn
293 * PQP_SERVICE_HISTORY_PERIODS.SHP_ATTRIBUTE9}
294 * @param p_shp_attribute10 {@rep:casecolumn
295 * PQP_SERVICE_HISTORY_PERIODS.SHP_ATTRIBUTE10}
296 * @param p_shp_attribute11 {@rep:casecolumn
297 * PQP_SERVICE_HISTORY_PERIODS.SHP_ATTRIBUTE11}
298 * @param p_shp_attribute12 {@rep:casecolumn
299 * PQP_SERVICE_HISTORY_PERIODS.SHP_ATTRIBUTE12}
300 * @param p_shp_attribute13 {@rep:casecolumn
301 * PQP_SERVICE_HISTORY_PERIODS.SHP_ATTRIBUTE13}
302 * @param p_shp_attribute14 {@rep:casecolumn
303 * PQP_SERVICE_HISTORY_PERIODS.SHP_ATTRIBUTE14}
304 * @param p_shp_attribute15 {@rep:casecolumn
308 * @param p_shp_attribute17 {@rep:casecolumn
305 * PQP_SERVICE_HISTORY_PERIODS.SHP_ATTRIBUTE15}
306 * @param p_shp_attribute16 {@rep:casecolumn
307 * PQP_SERVICE_HISTORY_PERIODS.SHP_ATTRIBUTE16}
309 * PQP_SERVICE_HISTORY_PERIODS.SHP_ATTRIBUTE17}
310 * @param p_shp_attribute18 {@rep:casecolumn
311 * PQP_SERVICE_HISTORY_PERIODS.SHP_ATTRIBUTE18}
312 * @param p_shp_attribute19 {@rep:casecolumn
313 * PQP_SERVICE_HISTORY_PERIODS.SHP_ATTRIBUTE19}
314 * @param p_shp_attribute20 {@rep:casecolumn
315 * PQP_SERVICE_HISTORY_PERIODS.SHP_ATTRIBUTE20}
316 * @param p_shp_information_category {@rep:casecolumn
317 * PQP_SERVICE_HISTORY_PERIODS.SHP_INFORMATION_CATEGORY}
318 * @param p_shp_information1 {@rep:casecolumn
319 * PQP_SERVICE_HISTORY_PERIODS.SHP_INFORMATION1}
320 * @param p_shp_information2 {@rep:casecolumn
321 * PQP_SERVICE_HISTORY_PERIODS.SHP_INFORMATION2}
322 * @param p_shp_information3 {@rep:casecolumn
323 * PQP_SERVICE_HISTORY_PERIODS.SHP_INFORMATION3}
324 * @param p_shp_information4 {@rep:casecolumn
325 * PQP_SERVICE_HISTORY_PERIODS.SHP_INFORMATION4}
326 * @param p_shp_information5 {@rep:casecolumn
327 * PQP_SERVICE_HISTORY_PERIODS.SHP_INFORMATION5}
328 * @param p_shp_information6 {@rep:casecolumn
329 * PQP_SERVICE_HISTORY_PERIODS.SHP_INFORMATION6}
330 * @param p_shp_information7 {@rep:casecolumn
331 * PQP_SERVICE_HISTORY_PERIODS.SHP_INFORMATION7}
332 * @param p_shp_information8 {@rep:casecolumn
333 * PQP_SERVICE_HISTORY_PERIODS.SHP_INFORMATION8}
334 * @param p_shp_information9 {@rep:casecolumn
335 * PQP_SERVICE_HISTORY_PERIODS.SHP_INFORMATION9}
336 * @param p_shp_information10 {@rep:casecolumn
337 * PQP_SERVICE_HISTORY_PERIODS.SHP_INFORMATION10}
338 * @param p_shp_information11 {@rep:casecolumn
339 * PQP_SERVICE_HISTORY_PERIODS.SHP_INFORMATION11}
340 * @param p_shp_information12 {@rep:casecolumn
341 * PQP_SERVICE_HISTORY_PERIODS.SHP_INFORMATION12}
342 * @param p_shp_information13 {@rep:casecolumn
343 * PQP_SERVICE_HISTORY_PERIODS.SHP_INFORMATION13}
344 * @param p_shp_information14 {@rep:casecolumn
345 * PQP_SERVICE_HISTORY_PERIODS.SHP_INFORMATION14}
346 * @param p_shp_information15 {@rep:casecolumn
347 * PQP_SERVICE_HISTORY_PERIODS.SHP_INFORMATION15}
348 * @param p_shp_information16 {@rep:casecolumn
349 * PQP_SERVICE_HISTORY_PERIODS.SHP_INFORMATION16}
350 * @param p_shp_information17 {@rep:casecolumn
351 * PQP_SERVICE_HISTORY_PERIODS.SHP_INFORMATION17}
352 * @param p_shp_information18 {@rep:casecolumn
353 * PQP_SERVICE_HISTORY_PERIODS.SHP_INFORMATION18}
354 * @param p_shp_information19 {@rep:casecolumn
355 * PQP_SERVICE_HISTORY_PERIODS.SHP_INFORMATION19}
356 * @param p_shp_information20 {@rep:casecolumn
357 * PQP_SERVICE_HISTORY_PERIODS.SHP_INFORMATION20}
358 * @param p_object_version_number Pass in the current version number of the
359 * employment service history to be updated. When the API completes, if
360 * p_validate is false, it will be set to the new version number of the updated
361 * employment service history. If p_validate is true will be set to the same
362 * value which was passed in.
363 * @rep:displayname Update Employment Service History
364 * @rep:category BUSINESS_ENTITY PER_EMPLOYEE_ASG
365 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
366 * @rep:scope public
367 * @rep:lifecycle active
368 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
369 */
370 --
371 -- {End Of Comments}
372 --
373 procedure update_service_history_period
374 (p_validate in boolean default false
375 ,p_service_history_period_id in number
376 ,p_assignment_id in number default hr_api.g_number
377 ,p_start_date in date default hr_api.g_date
378 ,p_end_date in date default hr_api.g_date
379 ,p_employer_name in varchar2 default hr_api.g_varchar2
380 ,p_employer_address in varchar2 default hr_api.g_varchar2
381 ,p_employer_type in varchar2 default hr_api.g_varchar2
382 ,p_employer_subtype in varchar2 default hr_api.g_varchar2
383 ,p_description in varchar2 default hr_api.g_varchar2
384 ,p_continuous_service in varchar2 default hr_api.g_varchar2
385 ,p_all_assignments in varchar2 default hr_api.g_varchar2
386 ,p_period_years in number default hr_api.g_number
387 ,p_period_days in number default hr_api.g_number
388 ,p_shp_attribute_category in varchar2 default hr_api.g_varchar2
389 ,p_shp_attribute1 in varchar2 default hr_api.g_varchar2
390 ,p_shp_attribute2 in varchar2 default hr_api.g_varchar2
391 ,p_shp_attribute3 in varchar2 default hr_api.g_varchar2
392 ,p_shp_attribute4 in varchar2 default hr_api.g_varchar2
393 ,p_shp_attribute5 in varchar2 default hr_api.g_varchar2
394 ,p_shp_attribute6 in varchar2 default hr_api.g_varchar2
395 ,p_shp_attribute7 in varchar2 default hr_api.g_varchar2
396 ,p_shp_attribute8 in varchar2 default hr_api.g_varchar2
397 ,p_shp_attribute9 in varchar2 default hr_api.g_varchar2
398 ,p_shp_attribute10 in varchar2 default hr_api.g_varchar2
399 ,p_shp_attribute11 in varchar2 default hr_api.g_varchar2
400 ,p_shp_attribute12 in varchar2 default hr_api.g_varchar2
401 ,p_shp_attribute13 in varchar2 default hr_api.g_varchar2
402 ,p_shp_attribute14 in varchar2 default hr_api.g_varchar2
403 ,p_shp_attribute15 in varchar2 default hr_api.g_varchar2
404 ,p_shp_attribute16 in varchar2 default hr_api.g_varchar2
405 ,p_shp_attribute17 in varchar2 default hr_api.g_varchar2
406 ,p_shp_attribute18 in varchar2 default hr_api.g_varchar2
407 ,p_shp_attribute19 in varchar2 default hr_api.g_varchar2
408 ,p_shp_attribute20 in varchar2 default hr_api.g_varchar2
409 ,p_shp_information_category in varchar2 default hr_api.g_varchar2
410 ,p_shp_information1 in varchar2 default hr_api.g_varchar2
411 ,p_shp_information2 in varchar2 default hr_api.g_varchar2
412 ,p_shp_information3 in varchar2 default hr_api.g_varchar2
413 ,p_shp_information4 in varchar2 default hr_api.g_varchar2
414 ,p_shp_information5 in varchar2 default hr_api.g_varchar2
415 ,p_shp_information6 in varchar2 default hr_api.g_varchar2
416 ,p_shp_information7 in varchar2 default hr_api.g_varchar2
417 ,p_shp_information8 in varchar2 default hr_api.g_varchar2
418 ,p_shp_information9 in varchar2 default hr_api.g_varchar2
419 ,p_shp_information10 in varchar2 default hr_api.g_varchar2
420 ,p_shp_information11 in varchar2 default hr_api.g_varchar2
421 ,p_shp_information12 in varchar2 default hr_api.g_varchar2
422 ,p_shp_information13 in varchar2 default hr_api.g_varchar2
423 ,p_shp_information14 in varchar2 default hr_api.g_varchar2
424 ,p_shp_information15 in varchar2 default hr_api.g_varchar2
425 ,p_shp_information16 in varchar2 default hr_api.g_varchar2
426 ,p_shp_information17 in varchar2 default hr_api.g_varchar2
427 ,p_shp_information18 in varchar2 default hr_api.g_varchar2
428 ,p_shp_information19 in varchar2 default hr_api.g_varchar2
429 ,p_shp_information20 in varchar2 default hr_api.g_varchar2
430 ,p_object_version_number in out nocopy number
431 );
432 --
433 -- ----------------------------------------------------------------------------
434 -- |----------------------< delete_service_history_period >-------------------|
435 -- ----------------------------------------------------------------------------
436 --
437 -- {Start Of Comments}
438 /*#
439 * This API deletes Employment Service History period information for an
440 * employee assignment.
441 *
442 * This API deletes Employment Service History period information for an
443 * employee assignment.
444 *
445 * <p><b>Licensing</b><br>
446 * This API is licensed for use with Human Resources.
447 *
448 * <p><b>Prerequisites</b><br>
449 * An employment service history record for this assignment should exist before
450 * deleting.
451 *
452 * <p><b>Post Success</b><br>
453 * The employment service history record will be successfully deleted from the
454 * database.
455 *
456 * <p><b>Post Failure</b><br>
457 * The employment service history record will not be deleted and an error will
458 * be raised.
459 * @param p_validate If true, then validation alone will be performed and the
460 * database will remain unchanged. If false and all validation checks pass,
461 * then the database will be modified.
462 * @param p_service_history_period_id {@rep:casecolumn
463 * PQP_SERVICE_HISTORY_PERIODS.SERVICE_HISTORY_PERIOD_ID}
464 * @param p_object_version_number Current version number of the employment
465 * service history to be deleted.
466 * @rep:displayname Delete Employment Service History
467 * @rep:category BUSINESS_ENTITY PER_EMPLOYEE_ASG
468 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
469 * @rep:scope public
470 * @rep:lifecycle active
471 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
472 */
473 --
474 -- {End Of Comments}
475 --
476 procedure delete_service_history_period
477 (p_validate in boolean default false
478 ,p_service_history_period_id in number
479 ,p_object_version_number in number
480 );
481 --
482 end pqp_shp_api;