101: --
102: hr_utility.set_location(' Leaving:'||l_proc, 10);
103: --
104: Exception
105: When hr_api.check_integrity_violated Then
106: -- A check constraint has been violated
107: ota_tsp_shd.g_api_dml := false; -- Unset the api dml status
108: ota_tsp_shd.constraint_error
109: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
105: When hr_api.check_integrity_violated Then
106: -- A check constraint has been violated
107: ota_tsp_shd.g_api_dml := false; -- Unset the api dml status
108: ota_tsp_shd.constraint_error
109: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
110: When hr_api.parent_integrity_violated Then
111: -- Parent integrity has been violated
112: ota_tsp_shd.g_api_dml := false; -- Unset the api dml status
113: ota_tsp_shd.constraint_error
106: -- A check constraint has been violated
107: ota_tsp_shd.g_api_dml := false; -- Unset the api dml status
108: ota_tsp_shd.constraint_error
109: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
110: When hr_api.parent_integrity_violated Then
111: -- Parent integrity has been violated
112: ota_tsp_shd.g_api_dml := false; -- Unset the api dml status
113: ota_tsp_shd.constraint_error
114: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
110: When hr_api.parent_integrity_violated Then
111: -- Parent integrity has been violated
112: ota_tsp_shd.g_api_dml := false; -- Unset the api dml status
113: ota_tsp_shd.constraint_error
114: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
115: When hr_api.unique_integrity_violated Then
116: -- Unique integrity has been violated
117: ota_tsp_shd.g_api_dml := false; -- Unset the api dml status
118: ota_tsp_shd.constraint_error
111: -- Parent integrity has been violated
112: ota_tsp_shd.g_api_dml := false; -- Unset the api dml status
113: ota_tsp_shd.constraint_error
114: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
115: When hr_api.unique_integrity_violated Then
116: -- Unique integrity has been violated
117: ota_tsp_shd.g_api_dml := false; -- Unset the api dml status
118: ota_tsp_shd.constraint_error
119: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
115: When hr_api.unique_integrity_violated Then
116: -- Unique integrity has been violated
117: ota_tsp_shd.g_api_dml := false; -- Unset the api dml status
118: ota_tsp_shd.constraint_error
119: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
120: When Others Then
121: ota_tsp_shd.g_api_dml := false; -- Unset the api dml status
122: Raise;
123: End update_dml;
262: -- p_rec plsql record structure
263: -- to see if a system default is being used. If a system default
264: -- is being used then we must set to the 'current' argument value.
265: --
266: If (p_rec.activity_version_id = hr_api.g_number) then
267: p_rec.activity_version_id :=
268: ota_tsp_shd.g_old_rec.activity_version_id;
269: End If;
270: If (p_rec.type = hr_api.g_varchar2) then
266: If (p_rec.activity_version_id = hr_api.g_number) then
267: p_rec.activity_version_id :=
268: ota_tsp_shd.g_old_rec.activity_version_id;
269: End If;
270: If (p_rec.type = hr_api.g_varchar2) then
271: p_rec.type :=
272: ota_tsp_shd.g_old_rec.type;
273: End If;
274: If (p_rec.comments = hr_api.g_varchar2) then
270: If (p_rec.type = hr_api.g_varchar2) then
271: p_rec.type :=
272: ota_tsp_shd.g_old_rec.type;
273: End If;
274: If (p_rec.comments = hr_api.g_varchar2) then
275: p_rec.comments :=
276: ota_tsp_shd.g_old_rec.comments;
277: End If;
278: If (p_rec.tsp_information_category = hr_api.g_varchar2) then
274: If (p_rec.comments = hr_api.g_varchar2) then
275: p_rec.comments :=
276: ota_tsp_shd.g_old_rec.comments;
277: End If;
278: If (p_rec.tsp_information_category = hr_api.g_varchar2) then
279: p_rec.tsp_information_category :=
280: ota_tsp_shd.g_old_rec.tsp_information_category;
281: End If;
282: If (p_rec.tsp_information1 = hr_api.g_varchar2) then
278: If (p_rec.tsp_information_category = hr_api.g_varchar2) then
279: p_rec.tsp_information_category :=
280: ota_tsp_shd.g_old_rec.tsp_information_category;
281: End If;
282: If (p_rec.tsp_information1 = hr_api.g_varchar2) then
283: p_rec.tsp_information1 :=
284: ota_tsp_shd.g_old_rec.tsp_information1;
285: End If;
286: If (p_rec.tsp_information2 = hr_api.g_varchar2) then
282: If (p_rec.tsp_information1 = hr_api.g_varchar2) then
283: p_rec.tsp_information1 :=
284: ota_tsp_shd.g_old_rec.tsp_information1;
285: End If;
286: If (p_rec.tsp_information2 = hr_api.g_varchar2) then
287: p_rec.tsp_information2 :=
288: ota_tsp_shd.g_old_rec.tsp_information2;
289: End If;
290: If (p_rec.tsp_information3 = hr_api.g_varchar2) then
286: If (p_rec.tsp_information2 = hr_api.g_varchar2) then
287: p_rec.tsp_information2 :=
288: ota_tsp_shd.g_old_rec.tsp_information2;
289: End If;
290: If (p_rec.tsp_information3 = hr_api.g_varchar2) then
291: p_rec.tsp_information3 :=
292: ota_tsp_shd.g_old_rec.tsp_information3;
293: End If;
294: If (p_rec.tsp_information4 = hr_api.g_varchar2) then
290: If (p_rec.tsp_information3 = hr_api.g_varchar2) then
291: p_rec.tsp_information3 :=
292: ota_tsp_shd.g_old_rec.tsp_information3;
293: End If;
294: If (p_rec.tsp_information4 = hr_api.g_varchar2) then
295: p_rec.tsp_information4 :=
296: ota_tsp_shd.g_old_rec.tsp_information4;
297: End If;
298: If (p_rec.tsp_information5 = hr_api.g_varchar2) then
294: If (p_rec.tsp_information4 = hr_api.g_varchar2) then
295: p_rec.tsp_information4 :=
296: ota_tsp_shd.g_old_rec.tsp_information4;
297: End If;
298: If (p_rec.tsp_information5 = hr_api.g_varchar2) then
299: p_rec.tsp_information5 :=
300: ota_tsp_shd.g_old_rec.tsp_information5;
301: End If;
302: If (p_rec.tsp_information6 = hr_api.g_varchar2) then
298: If (p_rec.tsp_information5 = hr_api.g_varchar2) then
299: p_rec.tsp_information5 :=
300: ota_tsp_shd.g_old_rec.tsp_information5;
301: End If;
302: If (p_rec.tsp_information6 = hr_api.g_varchar2) then
303: p_rec.tsp_information6 :=
304: ota_tsp_shd.g_old_rec.tsp_information6;
305: End If;
306: If (p_rec.tsp_information7 = hr_api.g_varchar2) then
302: If (p_rec.tsp_information6 = hr_api.g_varchar2) then
303: p_rec.tsp_information6 :=
304: ota_tsp_shd.g_old_rec.tsp_information6;
305: End If;
306: If (p_rec.tsp_information7 = hr_api.g_varchar2) then
307: p_rec.tsp_information7 :=
308: ota_tsp_shd.g_old_rec.tsp_information7;
309: End If;
310: If (p_rec.tsp_information8 = hr_api.g_varchar2) then
306: If (p_rec.tsp_information7 = hr_api.g_varchar2) then
307: p_rec.tsp_information7 :=
308: ota_tsp_shd.g_old_rec.tsp_information7;
309: End If;
310: If (p_rec.tsp_information8 = hr_api.g_varchar2) then
311: p_rec.tsp_information8 :=
312: ota_tsp_shd.g_old_rec.tsp_information8;
313: End If;
314: If (p_rec.tsp_information9 = hr_api.g_varchar2) then
310: If (p_rec.tsp_information8 = hr_api.g_varchar2) then
311: p_rec.tsp_information8 :=
312: ota_tsp_shd.g_old_rec.tsp_information8;
313: End If;
314: If (p_rec.tsp_information9 = hr_api.g_varchar2) then
315: p_rec.tsp_information9 :=
316: ota_tsp_shd.g_old_rec.tsp_information9;
317: End If;
318: If (p_rec.tsp_information10 = hr_api.g_varchar2) then
314: If (p_rec.tsp_information9 = hr_api.g_varchar2) then
315: p_rec.tsp_information9 :=
316: ota_tsp_shd.g_old_rec.tsp_information9;
317: End If;
318: If (p_rec.tsp_information10 = hr_api.g_varchar2) then
319: p_rec.tsp_information10 :=
320: ota_tsp_shd.g_old_rec.tsp_information10;
321: End If;
322: If (p_rec.tsp_information11 = hr_api.g_varchar2) then
318: If (p_rec.tsp_information10 = hr_api.g_varchar2) then
319: p_rec.tsp_information10 :=
320: ota_tsp_shd.g_old_rec.tsp_information10;
321: End If;
322: If (p_rec.tsp_information11 = hr_api.g_varchar2) then
323: p_rec.tsp_information11 :=
324: ota_tsp_shd.g_old_rec.tsp_information11;
325: End If;
326: If (p_rec.tsp_information12 = hr_api.g_varchar2) then
322: If (p_rec.tsp_information11 = hr_api.g_varchar2) then
323: p_rec.tsp_information11 :=
324: ota_tsp_shd.g_old_rec.tsp_information11;
325: End If;
326: If (p_rec.tsp_information12 = hr_api.g_varchar2) then
327: p_rec.tsp_information12 :=
328: ota_tsp_shd.g_old_rec.tsp_information12;
329: End If;
330: If (p_rec.tsp_information13 = hr_api.g_varchar2) then
326: If (p_rec.tsp_information12 = hr_api.g_varchar2) then
327: p_rec.tsp_information12 :=
328: ota_tsp_shd.g_old_rec.tsp_information12;
329: End If;
330: If (p_rec.tsp_information13 = hr_api.g_varchar2) then
331: p_rec.tsp_information13 :=
332: ota_tsp_shd.g_old_rec.tsp_information13;
333: End If;
334: If (p_rec.tsp_information14 = hr_api.g_varchar2) then
330: If (p_rec.tsp_information13 = hr_api.g_varchar2) then
331: p_rec.tsp_information13 :=
332: ota_tsp_shd.g_old_rec.tsp_information13;
333: End If;
334: If (p_rec.tsp_information14 = hr_api.g_varchar2) then
335: p_rec.tsp_information14 :=
336: ota_tsp_shd.g_old_rec.tsp_information14;
337: End If;
338: If (p_rec.tsp_information15 = hr_api.g_varchar2) then
334: If (p_rec.tsp_information14 = hr_api.g_varchar2) then
335: p_rec.tsp_information14 :=
336: ota_tsp_shd.g_old_rec.tsp_information14;
337: End If;
338: If (p_rec.tsp_information15 = hr_api.g_varchar2) then
339: p_rec.tsp_information15 :=
340: ota_tsp_shd.g_old_rec.tsp_information15;
341: End If;
342: If (p_rec.tsp_information16 = hr_api.g_varchar2) then
338: If (p_rec.tsp_information15 = hr_api.g_varchar2) then
339: p_rec.tsp_information15 :=
340: ota_tsp_shd.g_old_rec.tsp_information15;
341: End If;
342: If (p_rec.tsp_information16 = hr_api.g_varchar2) then
343: p_rec.tsp_information16 :=
344: ota_tsp_shd.g_old_rec.tsp_information16;
345: End If;
346: If (p_rec.tsp_information17 = hr_api.g_varchar2) then
342: If (p_rec.tsp_information16 = hr_api.g_varchar2) then
343: p_rec.tsp_information16 :=
344: ota_tsp_shd.g_old_rec.tsp_information16;
345: End If;
346: If (p_rec.tsp_information17 = hr_api.g_varchar2) then
347: p_rec.tsp_information17 :=
348: ota_tsp_shd.g_old_rec.tsp_information17;
349: End If;
350: If (p_rec.tsp_information18 = hr_api.g_varchar2) then
346: If (p_rec.tsp_information17 = hr_api.g_varchar2) then
347: p_rec.tsp_information17 :=
348: ota_tsp_shd.g_old_rec.tsp_information17;
349: End If;
350: If (p_rec.tsp_information18 = hr_api.g_varchar2) then
351: p_rec.tsp_information18 :=
352: ota_tsp_shd.g_old_rec.tsp_information18;
353: End If;
354: If (p_rec.tsp_information19 = hr_api.g_varchar2) then
350: If (p_rec.tsp_information18 = hr_api.g_varchar2) then
351: p_rec.tsp_information18 :=
352: ota_tsp_shd.g_old_rec.tsp_information18;
353: End If;
354: If (p_rec.tsp_information19 = hr_api.g_varchar2) then
355: p_rec.tsp_information19 :=
356: ota_tsp_shd.g_old_rec.tsp_information19;
357: End If;
358: If (p_rec.tsp_information20 = hr_api.g_varchar2) then
354: If (p_rec.tsp_information19 = hr_api.g_varchar2) then
355: p_rec.tsp_information19 :=
356: ota_tsp_shd.g_old_rec.tsp_information19;
357: End If;
358: If (p_rec.tsp_information20 = hr_api.g_varchar2) then
359: p_rec.tsp_information20 :=
360: ota_tsp_shd.g_old_rec.tsp_information20;
361: End If;
362: If (p_rec.analysis_criteria_id = hr_api.g_number) then
358: If (p_rec.tsp_information20 = hr_api.g_varchar2) then
359: p_rec.tsp_information20 :=
360: ota_tsp_shd.g_old_rec.tsp_information20;
361: End If;
362: If (p_rec.analysis_criteria_id = hr_api.g_number) then
363: p_rec.analysis_criteria_id :=
364: ota_tsp_shd.g_old_rec.analysis_criteria_id;
365: End If;
366: --
424: --
425: -- If we are validating then raise the Validate_Enabled exception
426: --
427: If p_validate then
428: Raise HR_Api.Validate_Enabled;
429: End If;
430: --
431: hr_utility.set_location(' Leaving:'||l_proc, 10);
432: Exception
429: End If;
430: --
431: hr_utility.set_location(' Leaving:'||l_proc, 10);
432: Exception
433: When HR_Api.Validate_Enabled Then
434: --
435: -- As the Validate_Enabled exception has been raised
436: -- we must rollback to the savepoint
437: --
443: -- ----------------------------------------------------------------------------
444: Procedure upd
445: (
446: p_skill_provision_id in number,
447: p_activity_version_id in number default hr_api.g_number,
448: p_object_version_number in out nocopy number,
449: p_type in varchar2 default hr_api.g_varchar2,
450: p_comments in varchar2 default hr_api.g_varchar2,
451: p_tsp_information_category in varchar2 default hr_api.g_varchar2,
445: (
446: p_skill_provision_id in number,
447: p_activity_version_id in number default hr_api.g_number,
448: p_object_version_number in out nocopy number,
449: p_type in varchar2 default hr_api.g_varchar2,
450: p_comments in varchar2 default hr_api.g_varchar2,
451: p_tsp_information_category in varchar2 default hr_api.g_varchar2,
452: p_tsp_information1 in varchar2 default hr_api.g_varchar2,
453: p_tsp_information2 in varchar2 default hr_api.g_varchar2,
446: p_skill_provision_id in number,
447: p_activity_version_id in number default hr_api.g_number,
448: p_object_version_number in out nocopy number,
449: p_type in varchar2 default hr_api.g_varchar2,
450: p_comments in varchar2 default hr_api.g_varchar2,
451: p_tsp_information_category in varchar2 default hr_api.g_varchar2,
452: p_tsp_information1 in varchar2 default hr_api.g_varchar2,
453: p_tsp_information2 in varchar2 default hr_api.g_varchar2,
454: p_tsp_information3 in varchar2 default hr_api.g_varchar2,
447: p_activity_version_id in number default hr_api.g_number,
448: p_object_version_number in out nocopy number,
449: p_type in varchar2 default hr_api.g_varchar2,
450: p_comments in varchar2 default hr_api.g_varchar2,
451: p_tsp_information_category in varchar2 default hr_api.g_varchar2,
452: p_tsp_information1 in varchar2 default hr_api.g_varchar2,
453: p_tsp_information2 in varchar2 default hr_api.g_varchar2,
454: p_tsp_information3 in varchar2 default hr_api.g_varchar2,
455: p_tsp_information4 in varchar2 default hr_api.g_varchar2,
448: p_object_version_number in out nocopy number,
449: p_type in varchar2 default hr_api.g_varchar2,
450: p_comments in varchar2 default hr_api.g_varchar2,
451: p_tsp_information_category in varchar2 default hr_api.g_varchar2,
452: p_tsp_information1 in varchar2 default hr_api.g_varchar2,
453: p_tsp_information2 in varchar2 default hr_api.g_varchar2,
454: p_tsp_information3 in varchar2 default hr_api.g_varchar2,
455: p_tsp_information4 in varchar2 default hr_api.g_varchar2,
456: p_tsp_information5 in varchar2 default hr_api.g_varchar2,
449: p_type in varchar2 default hr_api.g_varchar2,
450: p_comments in varchar2 default hr_api.g_varchar2,
451: p_tsp_information_category in varchar2 default hr_api.g_varchar2,
452: p_tsp_information1 in varchar2 default hr_api.g_varchar2,
453: p_tsp_information2 in varchar2 default hr_api.g_varchar2,
454: p_tsp_information3 in varchar2 default hr_api.g_varchar2,
455: p_tsp_information4 in varchar2 default hr_api.g_varchar2,
456: p_tsp_information5 in varchar2 default hr_api.g_varchar2,
457: p_tsp_information6 in varchar2 default hr_api.g_varchar2,
450: p_comments in varchar2 default hr_api.g_varchar2,
451: p_tsp_information_category in varchar2 default hr_api.g_varchar2,
452: p_tsp_information1 in varchar2 default hr_api.g_varchar2,
453: p_tsp_information2 in varchar2 default hr_api.g_varchar2,
454: p_tsp_information3 in varchar2 default hr_api.g_varchar2,
455: p_tsp_information4 in varchar2 default hr_api.g_varchar2,
456: p_tsp_information5 in varchar2 default hr_api.g_varchar2,
457: p_tsp_information6 in varchar2 default hr_api.g_varchar2,
458: p_tsp_information7 in varchar2 default hr_api.g_varchar2,
451: p_tsp_information_category in varchar2 default hr_api.g_varchar2,
452: p_tsp_information1 in varchar2 default hr_api.g_varchar2,
453: p_tsp_information2 in varchar2 default hr_api.g_varchar2,
454: p_tsp_information3 in varchar2 default hr_api.g_varchar2,
455: p_tsp_information4 in varchar2 default hr_api.g_varchar2,
456: p_tsp_information5 in varchar2 default hr_api.g_varchar2,
457: p_tsp_information6 in varchar2 default hr_api.g_varchar2,
458: p_tsp_information7 in varchar2 default hr_api.g_varchar2,
459: p_tsp_information8 in varchar2 default hr_api.g_varchar2,
452: p_tsp_information1 in varchar2 default hr_api.g_varchar2,
453: p_tsp_information2 in varchar2 default hr_api.g_varchar2,
454: p_tsp_information3 in varchar2 default hr_api.g_varchar2,
455: p_tsp_information4 in varchar2 default hr_api.g_varchar2,
456: p_tsp_information5 in varchar2 default hr_api.g_varchar2,
457: p_tsp_information6 in varchar2 default hr_api.g_varchar2,
458: p_tsp_information7 in varchar2 default hr_api.g_varchar2,
459: p_tsp_information8 in varchar2 default hr_api.g_varchar2,
460: p_tsp_information9 in varchar2 default hr_api.g_varchar2,
453: p_tsp_information2 in varchar2 default hr_api.g_varchar2,
454: p_tsp_information3 in varchar2 default hr_api.g_varchar2,
455: p_tsp_information4 in varchar2 default hr_api.g_varchar2,
456: p_tsp_information5 in varchar2 default hr_api.g_varchar2,
457: p_tsp_information6 in varchar2 default hr_api.g_varchar2,
458: p_tsp_information7 in varchar2 default hr_api.g_varchar2,
459: p_tsp_information8 in varchar2 default hr_api.g_varchar2,
460: p_tsp_information9 in varchar2 default hr_api.g_varchar2,
461: p_tsp_information10 in varchar2 default hr_api.g_varchar2,
454: p_tsp_information3 in varchar2 default hr_api.g_varchar2,
455: p_tsp_information4 in varchar2 default hr_api.g_varchar2,
456: p_tsp_information5 in varchar2 default hr_api.g_varchar2,
457: p_tsp_information6 in varchar2 default hr_api.g_varchar2,
458: p_tsp_information7 in varchar2 default hr_api.g_varchar2,
459: p_tsp_information8 in varchar2 default hr_api.g_varchar2,
460: p_tsp_information9 in varchar2 default hr_api.g_varchar2,
461: p_tsp_information10 in varchar2 default hr_api.g_varchar2,
462: p_tsp_information11 in varchar2 default hr_api.g_varchar2,
455: p_tsp_information4 in varchar2 default hr_api.g_varchar2,
456: p_tsp_information5 in varchar2 default hr_api.g_varchar2,
457: p_tsp_information6 in varchar2 default hr_api.g_varchar2,
458: p_tsp_information7 in varchar2 default hr_api.g_varchar2,
459: p_tsp_information8 in varchar2 default hr_api.g_varchar2,
460: p_tsp_information9 in varchar2 default hr_api.g_varchar2,
461: p_tsp_information10 in varchar2 default hr_api.g_varchar2,
462: p_tsp_information11 in varchar2 default hr_api.g_varchar2,
463: p_tsp_information12 in varchar2 default hr_api.g_varchar2,
456: p_tsp_information5 in varchar2 default hr_api.g_varchar2,
457: p_tsp_information6 in varchar2 default hr_api.g_varchar2,
458: p_tsp_information7 in varchar2 default hr_api.g_varchar2,
459: p_tsp_information8 in varchar2 default hr_api.g_varchar2,
460: p_tsp_information9 in varchar2 default hr_api.g_varchar2,
461: p_tsp_information10 in varchar2 default hr_api.g_varchar2,
462: p_tsp_information11 in varchar2 default hr_api.g_varchar2,
463: p_tsp_information12 in varchar2 default hr_api.g_varchar2,
464: p_tsp_information13 in varchar2 default hr_api.g_varchar2,
457: p_tsp_information6 in varchar2 default hr_api.g_varchar2,
458: p_tsp_information7 in varchar2 default hr_api.g_varchar2,
459: p_tsp_information8 in varchar2 default hr_api.g_varchar2,
460: p_tsp_information9 in varchar2 default hr_api.g_varchar2,
461: p_tsp_information10 in varchar2 default hr_api.g_varchar2,
462: p_tsp_information11 in varchar2 default hr_api.g_varchar2,
463: p_tsp_information12 in varchar2 default hr_api.g_varchar2,
464: p_tsp_information13 in varchar2 default hr_api.g_varchar2,
465: p_tsp_information14 in varchar2 default hr_api.g_varchar2,
458: p_tsp_information7 in varchar2 default hr_api.g_varchar2,
459: p_tsp_information8 in varchar2 default hr_api.g_varchar2,
460: p_tsp_information9 in varchar2 default hr_api.g_varchar2,
461: p_tsp_information10 in varchar2 default hr_api.g_varchar2,
462: p_tsp_information11 in varchar2 default hr_api.g_varchar2,
463: p_tsp_information12 in varchar2 default hr_api.g_varchar2,
464: p_tsp_information13 in varchar2 default hr_api.g_varchar2,
465: p_tsp_information14 in varchar2 default hr_api.g_varchar2,
466: p_tsp_information15 in varchar2 default hr_api.g_varchar2,
459: p_tsp_information8 in varchar2 default hr_api.g_varchar2,
460: p_tsp_information9 in varchar2 default hr_api.g_varchar2,
461: p_tsp_information10 in varchar2 default hr_api.g_varchar2,
462: p_tsp_information11 in varchar2 default hr_api.g_varchar2,
463: p_tsp_information12 in varchar2 default hr_api.g_varchar2,
464: p_tsp_information13 in varchar2 default hr_api.g_varchar2,
465: p_tsp_information14 in varchar2 default hr_api.g_varchar2,
466: p_tsp_information15 in varchar2 default hr_api.g_varchar2,
467: p_tsp_information16 in varchar2 default hr_api.g_varchar2,
460: p_tsp_information9 in varchar2 default hr_api.g_varchar2,
461: p_tsp_information10 in varchar2 default hr_api.g_varchar2,
462: p_tsp_information11 in varchar2 default hr_api.g_varchar2,
463: p_tsp_information12 in varchar2 default hr_api.g_varchar2,
464: p_tsp_information13 in varchar2 default hr_api.g_varchar2,
465: p_tsp_information14 in varchar2 default hr_api.g_varchar2,
466: p_tsp_information15 in varchar2 default hr_api.g_varchar2,
467: p_tsp_information16 in varchar2 default hr_api.g_varchar2,
468: p_tsp_information17 in varchar2 default hr_api.g_varchar2,
461: p_tsp_information10 in varchar2 default hr_api.g_varchar2,
462: p_tsp_information11 in varchar2 default hr_api.g_varchar2,
463: p_tsp_information12 in varchar2 default hr_api.g_varchar2,
464: p_tsp_information13 in varchar2 default hr_api.g_varchar2,
465: p_tsp_information14 in varchar2 default hr_api.g_varchar2,
466: p_tsp_information15 in varchar2 default hr_api.g_varchar2,
467: p_tsp_information16 in varchar2 default hr_api.g_varchar2,
468: p_tsp_information17 in varchar2 default hr_api.g_varchar2,
469: p_tsp_information18 in varchar2 default hr_api.g_varchar2,
462: p_tsp_information11 in varchar2 default hr_api.g_varchar2,
463: p_tsp_information12 in varchar2 default hr_api.g_varchar2,
464: p_tsp_information13 in varchar2 default hr_api.g_varchar2,
465: p_tsp_information14 in varchar2 default hr_api.g_varchar2,
466: p_tsp_information15 in varchar2 default hr_api.g_varchar2,
467: p_tsp_information16 in varchar2 default hr_api.g_varchar2,
468: p_tsp_information17 in varchar2 default hr_api.g_varchar2,
469: p_tsp_information18 in varchar2 default hr_api.g_varchar2,
470: p_tsp_information19 in varchar2 default hr_api.g_varchar2,
463: p_tsp_information12 in varchar2 default hr_api.g_varchar2,
464: p_tsp_information13 in varchar2 default hr_api.g_varchar2,
465: p_tsp_information14 in varchar2 default hr_api.g_varchar2,
466: p_tsp_information15 in varchar2 default hr_api.g_varchar2,
467: p_tsp_information16 in varchar2 default hr_api.g_varchar2,
468: p_tsp_information17 in varchar2 default hr_api.g_varchar2,
469: p_tsp_information18 in varchar2 default hr_api.g_varchar2,
470: p_tsp_information19 in varchar2 default hr_api.g_varchar2,
471: p_tsp_information20 in varchar2 default hr_api.g_varchar2,
464: p_tsp_information13 in varchar2 default hr_api.g_varchar2,
465: p_tsp_information14 in varchar2 default hr_api.g_varchar2,
466: p_tsp_information15 in varchar2 default hr_api.g_varchar2,
467: p_tsp_information16 in varchar2 default hr_api.g_varchar2,
468: p_tsp_information17 in varchar2 default hr_api.g_varchar2,
469: p_tsp_information18 in varchar2 default hr_api.g_varchar2,
470: p_tsp_information19 in varchar2 default hr_api.g_varchar2,
471: p_tsp_information20 in varchar2 default hr_api.g_varchar2,
472: p_analysis_criteria_id in number default hr_api.g_number,
465: p_tsp_information14 in varchar2 default hr_api.g_varchar2,
466: p_tsp_information15 in varchar2 default hr_api.g_varchar2,
467: p_tsp_information16 in varchar2 default hr_api.g_varchar2,
468: p_tsp_information17 in varchar2 default hr_api.g_varchar2,
469: p_tsp_information18 in varchar2 default hr_api.g_varchar2,
470: p_tsp_information19 in varchar2 default hr_api.g_varchar2,
471: p_tsp_information20 in varchar2 default hr_api.g_varchar2,
472: p_analysis_criteria_id in number default hr_api.g_number,
473: p_validate in boolean default false
466: p_tsp_information15 in varchar2 default hr_api.g_varchar2,
467: p_tsp_information16 in varchar2 default hr_api.g_varchar2,
468: p_tsp_information17 in varchar2 default hr_api.g_varchar2,
469: p_tsp_information18 in varchar2 default hr_api.g_varchar2,
470: p_tsp_information19 in varchar2 default hr_api.g_varchar2,
471: p_tsp_information20 in varchar2 default hr_api.g_varchar2,
472: p_analysis_criteria_id in number default hr_api.g_number,
473: p_validate in boolean default false
474: ) is
467: p_tsp_information16 in varchar2 default hr_api.g_varchar2,
468: p_tsp_information17 in varchar2 default hr_api.g_varchar2,
469: p_tsp_information18 in varchar2 default hr_api.g_varchar2,
470: p_tsp_information19 in varchar2 default hr_api.g_varchar2,
471: p_tsp_information20 in varchar2 default hr_api.g_varchar2,
472: p_analysis_criteria_id in number default hr_api.g_number,
473: p_validate in boolean default false
474: ) is
475: --
468: p_tsp_information17 in varchar2 default hr_api.g_varchar2,
469: p_tsp_information18 in varchar2 default hr_api.g_varchar2,
470: p_tsp_information19 in varchar2 default hr_api.g_varchar2,
471: p_tsp_information20 in varchar2 default hr_api.g_varchar2,
472: p_analysis_criteria_id in number default hr_api.g_number,
473: p_validate in boolean default false
474: ) is
475: --
476: l_rec ota_tsp_shd.g_rec_type;