APPS.OTA_TSP_UPD dependencies on HR_API

Line 105: When hr_api.check_integrity_violated Then

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));

Line 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

Line 110: When hr_api.parent_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
114: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 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

Line 115: When hr_api.unique_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
119: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 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;

Line 266: If (p_rec.activity_version_id = hr_api.g_number) then

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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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: --

Line 428: Raise HR_Api.Validate_Enabled;

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

Line 433: When HR_Api.Validate_Enabled Then

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: --

Line 447: p_activity_version_id in number default hr_api.g_number,

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,

Line 449: p_type 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,

Line 450: p_comments 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,

Line 451: p_tsp_information_category 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,

Line 452: p_tsp_information1 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,

Line 453: p_tsp_information2 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,

Line 454: p_tsp_information3 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,

Line 455: p_tsp_information4 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,

Line 456: p_tsp_information5 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,

Line 457: p_tsp_information6 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,

Line 458: p_tsp_information7 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,

Line 459: p_tsp_information8 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,

Line 460: p_tsp_information9 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,

Line 461: p_tsp_information10 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,

Line 462: p_tsp_information11 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,

Line 463: p_tsp_information12 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,

Line 464: p_tsp_information13 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,

Line 465: p_tsp_information14 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,

Line 466: p_tsp_information15 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,

Line 467: p_tsp_information16 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,

Line 468: p_tsp_information17 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,

Line 469: p_tsp_information18 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,
473: p_validate in boolean default false

Line 470: p_tsp_information19 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
474: ) is

Line 471: p_tsp_information20 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
475: --

Line 472: p_analysis_criteria_id in number default hr_api.g_number,

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;