99: --
100: hr_utility.set_location(' Leaving:'||l_proc, 10);
101: --
102: Exception
103: When hr_api.check_integrity_violated Then
104: -- A check constraint has been violated
105: ota_tea_shd.g_api_dml := false; -- Unset the api dml status
106: ota_tea_shd.constraint_error
107: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
103: When hr_api.check_integrity_violated Then
104: -- A check constraint has been violated
105: ota_tea_shd.g_api_dml := false; -- Unset the api dml status
106: ota_tea_shd.constraint_error
107: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
108: When hr_api.parent_integrity_violated Then
109: -- Parent integrity has been violated
110: ota_tea_shd.g_api_dml := false; -- Unset the api dml status
111: ota_tea_shd.constraint_error
104: -- A check constraint has been violated
105: ota_tea_shd.g_api_dml := false; -- Unset the api dml status
106: ota_tea_shd.constraint_error
107: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
108: When hr_api.parent_integrity_violated Then
109: -- Parent integrity has been violated
110: ota_tea_shd.g_api_dml := false; -- Unset the api dml status
111: ota_tea_shd.constraint_error
112: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
108: When hr_api.parent_integrity_violated Then
109: -- Parent integrity has been violated
110: ota_tea_shd.g_api_dml := false; -- Unset the api dml status
111: ota_tea_shd.constraint_error
112: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
113: When hr_api.unique_integrity_violated Then
114: -- Unique integrity has been violated
115: ota_tea_shd.g_api_dml := false; -- Unset the api dml status
116: ota_tea_shd.constraint_error
109: -- Parent integrity has been violated
110: ota_tea_shd.g_api_dml := false; -- Unset the api dml status
111: ota_tea_shd.constraint_error
112: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
113: When hr_api.unique_integrity_violated Then
114: -- Unique integrity has been violated
115: ota_tea_shd.g_api_dml := false; -- Unset the api dml status
116: ota_tea_shd.constraint_error
117: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
113: When hr_api.unique_integrity_violated Then
114: -- Unique integrity has been violated
115: ota_tea_shd.g_api_dml := false; -- Unset the api dml status
116: ota_tea_shd.constraint_error
117: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
118: When Others Then
119: ota_tea_shd.g_api_dml := false; -- Unset the api dml status
120: Raise;
121: End update_dml;
339: -- p_rec plsql record structure
340: -- to see if a system default is being used. If a system default
341: -- is being used then we must set to the 'current' argument value.
342: --
343: If (p_rec.event_id = hr_api.g_number) then
344: p_rec.event_id :=
345: ota_tea_shd.g_old_rec.event_id;
346: End If;
347: If (p_rec.customer_id = hr_api.g_number) then
343: If (p_rec.event_id = hr_api.g_number) then
344: p_rec.event_id :=
345: ota_tea_shd.g_old_rec.event_id;
346: End If;
347: If (p_rec.customer_id = hr_api.g_number) then
348: p_rec.customer_id :=
349: ota_tea_shd.g_old_rec.customer_id;
350: End If;
351: If (p_rec.organization_id = hr_api.g_number) then
347: If (p_rec.customer_id = hr_api.g_number) then
348: p_rec.customer_id :=
349: ota_tea_shd.g_old_rec.customer_id;
350: End If;
351: If (p_rec.organization_id = hr_api.g_number) then
352: p_rec.organization_id :=
353: ota_tea_shd.g_old_rec.organization_id;
354: End If;
355: If (p_rec.job_id = hr_api.g_number) then
351: If (p_rec.organization_id = hr_api.g_number) then
352: p_rec.organization_id :=
353: ota_tea_shd.g_old_rec.organization_id;
354: End If;
355: If (p_rec.job_id = hr_api.g_number) then
356: p_rec.job_id :=
357: ota_tea_shd.g_old_rec.job_id;
358: End If;
359: If (p_rec.position_id = hr_api.g_number) then
355: If (p_rec.job_id = hr_api.g_number) then
356: p_rec.job_id :=
357: ota_tea_shd.g_old_rec.job_id;
358: End If;
359: If (p_rec.position_id = hr_api.g_number) then
360: p_rec.position_id :=
361: ota_tea_shd.g_old_rec.position_id;
362: End If;
363: If (p_rec.comments = hr_api.g_varchar2) then
359: If (p_rec.position_id = hr_api.g_number) then
360: p_rec.position_id :=
361: ota_tea_shd.g_old_rec.position_id;
362: End If;
363: If (p_rec.comments = hr_api.g_varchar2) then
364: p_rec.comments :=
365: ota_tea_shd.g_old_rec.comments;
366: End If;
367: If (p_rec.tea_information_category = hr_api.g_varchar2) then
363: If (p_rec.comments = hr_api.g_varchar2) then
364: p_rec.comments :=
365: ota_tea_shd.g_old_rec.comments;
366: End If;
367: If (p_rec.tea_information_category = hr_api.g_varchar2) then
368: p_rec.tea_information_category :=
369: ota_tea_shd.g_old_rec.tea_information_category;
370: End If;
371: If (p_rec.tea_information1 = hr_api.g_varchar2) then
367: If (p_rec.tea_information_category = hr_api.g_varchar2) then
368: p_rec.tea_information_category :=
369: ota_tea_shd.g_old_rec.tea_information_category;
370: End If;
371: If (p_rec.tea_information1 = hr_api.g_varchar2) then
372: p_rec.tea_information1 :=
373: ota_tea_shd.g_old_rec.tea_information1;
374: End If;
375: If (p_rec.tea_information2 = hr_api.g_varchar2) then
371: If (p_rec.tea_information1 = hr_api.g_varchar2) then
372: p_rec.tea_information1 :=
373: ota_tea_shd.g_old_rec.tea_information1;
374: End If;
375: If (p_rec.tea_information2 = hr_api.g_varchar2) then
376: p_rec.tea_information2 :=
377: ota_tea_shd.g_old_rec.tea_information2;
378: End If;
379: If (p_rec.tea_information3 = hr_api.g_varchar2) then
375: If (p_rec.tea_information2 = hr_api.g_varchar2) then
376: p_rec.tea_information2 :=
377: ota_tea_shd.g_old_rec.tea_information2;
378: End If;
379: If (p_rec.tea_information3 = hr_api.g_varchar2) then
380: p_rec.tea_information3 :=
381: ota_tea_shd.g_old_rec.tea_information3;
382: End If;
383: If (p_rec.tea_information4 = hr_api.g_varchar2) then
379: If (p_rec.tea_information3 = hr_api.g_varchar2) then
380: p_rec.tea_information3 :=
381: ota_tea_shd.g_old_rec.tea_information3;
382: End If;
383: If (p_rec.tea_information4 = hr_api.g_varchar2) then
384: p_rec.tea_information4 :=
385: ota_tea_shd.g_old_rec.tea_information4;
386: End If;
387: If (p_rec.tea_information5 = hr_api.g_varchar2) then
383: If (p_rec.tea_information4 = hr_api.g_varchar2) then
384: p_rec.tea_information4 :=
385: ota_tea_shd.g_old_rec.tea_information4;
386: End If;
387: If (p_rec.tea_information5 = hr_api.g_varchar2) then
388: p_rec.tea_information5 :=
389: ota_tea_shd.g_old_rec.tea_information5;
390: End If;
391: If (p_rec.tea_information6 = hr_api.g_varchar2) then
387: If (p_rec.tea_information5 = hr_api.g_varchar2) then
388: p_rec.tea_information5 :=
389: ota_tea_shd.g_old_rec.tea_information5;
390: End If;
391: If (p_rec.tea_information6 = hr_api.g_varchar2) then
392: p_rec.tea_information6 :=
393: ota_tea_shd.g_old_rec.tea_information6;
394: End If;
395: If (p_rec.tea_information7 = hr_api.g_varchar2) then
391: If (p_rec.tea_information6 = hr_api.g_varchar2) then
392: p_rec.tea_information6 :=
393: ota_tea_shd.g_old_rec.tea_information6;
394: End If;
395: If (p_rec.tea_information7 = hr_api.g_varchar2) then
396: p_rec.tea_information7 :=
397: ota_tea_shd.g_old_rec.tea_information7;
398: End If;
399: If (p_rec.tea_information8 = hr_api.g_varchar2) then
395: If (p_rec.tea_information7 = hr_api.g_varchar2) then
396: p_rec.tea_information7 :=
397: ota_tea_shd.g_old_rec.tea_information7;
398: End If;
399: If (p_rec.tea_information8 = hr_api.g_varchar2) then
400: p_rec.tea_information8 :=
401: ota_tea_shd.g_old_rec.tea_information8;
402: End If;
403: If (p_rec.tea_information9 = hr_api.g_varchar2) then
399: If (p_rec.tea_information8 = hr_api.g_varchar2) then
400: p_rec.tea_information8 :=
401: ota_tea_shd.g_old_rec.tea_information8;
402: End If;
403: If (p_rec.tea_information9 = hr_api.g_varchar2) then
404: p_rec.tea_information9 :=
405: ota_tea_shd.g_old_rec.tea_information9;
406: End If;
407: If (p_rec.tea_information10 = hr_api.g_varchar2) then
403: If (p_rec.tea_information9 = hr_api.g_varchar2) then
404: p_rec.tea_information9 :=
405: ota_tea_shd.g_old_rec.tea_information9;
406: End If;
407: If (p_rec.tea_information10 = hr_api.g_varchar2) then
408: p_rec.tea_information10 :=
409: ota_tea_shd.g_old_rec.tea_information10;
410: End If;
411: If (p_rec.tea_information11 = hr_api.g_varchar2) then
407: If (p_rec.tea_information10 = hr_api.g_varchar2) then
408: p_rec.tea_information10 :=
409: ota_tea_shd.g_old_rec.tea_information10;
410: End If;
411: If (p_rec.tea_information11 = hr_api.g_varchar2) then
412: p_rec.tea_information11 :=
413: ota_tea_shd.g_old_rec.tea_information11;
414: End If;
415: If (p_rec.tea_information12 = hr_api.g_varchar2) then
411: If (p_rec.tea_information11 = hr_api.g_varchar2) then
412: p_rec.tea_information11 :=
413: ota_tea_shd.g_old_rec.tea_information11;
414: End If;
415: If (p_rec.tea_information12 = hr_api.g_varchar2) then
416: p_rec.tea_information12 :=
417: ota_tea_shd.g_old_rec.tea_information12;
418: End If;
419: If (p_rec.tea_information13 = hr_api.g_varchar2) then
415: If (p_rec.tea_information12 = hr_api.g_varchar2) then
416: p_rec.tea_information12 :=
417: ota_tea_shd.g_old_rec.tea_information12;
418: End If;
419: If (p_rec.tea_information13 = hr_api.g_varchar2) then
420: p_rec.tea_information13 :=
421: ota_tea_shd.g_old_rec.tea_information13;
422: End If;
423: If (p_rec.tea_information14 = hr_api.g_varchar2) then
419: If (p_rec.tea_information13 = hr_api.g_varchar2) then
420: p_rec.tea_information13 :=
421: ota_tea_shd.g_old_rec.tea_information13;
422: End If;
423: If (p_rec.tea_information14 = hr_api.g_varchar2) then
424: p_rec.tea_information14 :=
425: ota_tea_shd.g_old_rec.tea_information14;
426: End If;
427: If (p_rec.tea_information15 = hr_api.g_varchar2) then
423: If (p_rec.tea_information14 = hr_api.g_varchar2) then
424: p_rec.tea_information14 :=
425: ota_tea_shd.g_old_rec.tea_information14;
426: End If;
427: If (p_rec.tea_information15 = hr_api.g_varchar2) then
428: p_rec.tea_information15 :=
429: ota_tea_shd.g_old_rec.tea_information15;
430: End If;
431: If (p_rec.tea_information16 = hr_api.g_varchar2) then
427: If (p_rec.tea_information15 = hr_api.g_varchar2) then
428: p_rec.tea_information15 :=
429: ota_tea_shd.g_old_rec.tea_information15;
430: End If;
431: If (p_rec.tea_information16 = hr_api.g_varchar2) then
432: p_rec.tea_information16 :=
433: ota_tea_shd.g_old_rec.tea_information16;
434: End If;
435: If (p_rec.tea_information17 = hr_api.g_varchar2) then
431: If (p_rec.tea_information16 = hr_api.g_varchar2) then
432: p_rec.tea_information16 :=
433: ota_tea_shd.g_old_rec.tea_information16;
434: End If;
435: If (p_rec.tea_information17 = hr_api.g_varchar2) then
436: p_rec.tea_information17 :=
437: ota_tea_shd.g_old_rec.tea_information17;
438: End If;
439: If (p_rec.tea_information18 = hr_api.g_varchar2) then
435: If (p_rec.tea_information17 = hr_api.g_varchar2) then
436: p_rec.tea_information17 :=
437: ota_tea_shd.g_old_rec.tea_information17;
438: End If;
439: If (p_rec.tea_information18 = hr_api.g_varchar2) then
440: p_rec.tea_information18 :=
441: ota_tea_shd.g_old_rec.tea_information18;
442: End If;
443: If (p_rec.tea_information19 = hr_api.g_varchar2) then
439: If (p_rec.tea_information18 = hr_api.g_varchar2) then
440: p_rec.tea_information18 :=
441: ota_tea_shd.g_old_rec.tea_information18;
442: End If;
443: If (p_rec.tea_information19 = hr_api.g_varchar2) then
444: p_rec.tea_information19 :=
445: ota_tea_shd.g_old_rec.tea_information19;
446: End If;
447: If (p_rec.tea_information20 = hr_api.g_varchar2) then
443: If (p_rec.tea_information19 = hr_api.g_varchar2) then
444: p_rec.tea_information19 :=
445: ota_tea_shd.g_old_rec.tea_information19;
446: End If;
447: If (p_rec.tea_information20 = hr_api.g_varchar2) then
448: p_rec.tea_information20 :=
449: ota_tea_shd.g_old_rec.tea_information20;
450: End If;
451: --
568: --
569: -- If we are validating then raise the Validate_Enabled exception
570: --
571: If p_validate then
572: Raise HR_Api.Validate_Enabled;
573: End If;
574: --
575: hr_utility.set_location(' Leaving:'||l_proc, 10);
576: Exception
573: End If;
574: --
575: hr_utility.set_location(' Leaving:'||l_proc, 10);
576: Exception
577: When HR_Api.Validate_Enabled Then
578: --
579: -- As the Validate_Enabled exception has been raised
580: -- we must rollback to the savepoint
581: --
588: --
589: Procedure upd
590: (
591: p_event_association_id in number,
592: p_event_id in number default hr_api.g_number,
593: p_customer_id in number default hr_api.g_number,
594: p_organization_id in number default hr_api.g_number,
595: p_job_id in number default hr_api.g_number,
596: p_position_id in number default hr_api.g_number,
589: Procedure upd
590: (
591: p_event_association_id in number,
592: p_event_id in number default hr_api.g_number,
593: p_customer_id in number default hr_api.g_number,
594: p_organization_id in number default hr_api.g_number,
595: p_job_id in number default hr_api.g_number,
596: p_position_id in number default hr_api.g_number,
597: p_comments in varchar2 default hr_api.g_varchar2,
590: (
591: p_event_association_id in number,
592: p_event_id in number default hr_api.g_number,
593: p_customer_id in number default hr_api.g_number,
594: p_organization_id in number default hr_api.g_number,
595: p_job_id in number default hr_api.g_number,
596: p_position_id in number default hr_api.g_number,
597: p_comments in varchar2 default hr_api.g_varchar2,
598: p_tea_information_category in varchar2 default hr_api.g_varchar2,
591: p_event_association_id in number,
592: p_event_id in number default hr_api.g_number,
593: p_customer_id in number default hr_api.g_number,
594: p_organization_id in number default hr_api.g_number,
595: p_job_id in number default hr_api.g_number,
596: p_position_id in number default hr_api.g_number,
597: p_comments in varchar2 default hr_api.g_varchar2,
598: p_tea_information_category in varchar2 default hr_api.g_varchar2,
599: p_tea_information1 in varchar2 default hr_api.g_varchar2,
592: p_event_id in number default hr_api.g_number,
593: p_customer_id in number default hr_api.g_number,
594: p_organization_id in number default hr_api.g_number,
595: p_job_id in number default hr_api.g_number,
596: p_position_id in number default hr_api.g_number,
597: p_comments in varchar2 default hr_api.g_varchar2,
598: p_tea_information_category in varchar2 default hr_api.g_varchar2,
599: p_tea_information1 in varchar2 default hr_api.g_varchar2,
600: p_tea_information2 in varchar2 default hr_api.g_varchar2,
593: p_customer_id in number default hr_api.g_number,
594: p_organization_id in number default hr_api.g_number,
595: p_job_id in number default hr_api.g_number,
596: p_position_id in number default hr_api.g_number,
597: p_comments in varchar2 default hr_api.g_varchar2,
598: p_tea_information_category in varchar2 default hr_api.g_varchar2,
599: p_tea_information1 in varchar2 default hr_api.g_varchar2,
600: p_tea_information2 in varchar2 default hr_api.g_varchar2,
601: p_tea_information3 in varchar2 default hr_api.g_varchar2,
594: p_organization_id in number default hr_api.g_number,
595: p_job_id in number default hr_api.g_number,
596: p_position_id in number default hr_api.g_number,
597: p_comments in varchar2 default hr_api.g_varchar2,
598: p_tea_information_category in varchar2 default hr_api.g_varchar2,
599: p_tea_information1 in varchar2 default hr_api.g_varchar2,
600: p_tea_information2 in varchar2 default hr_api.g_varchar2,
601: p_tea_information3 in varchar2 default hr_api.g_varchar2,
602: p_tea_information4 in varchar2 default hr_api.g_varchar2,
595: p_job_id in number default hr_api.g_number,
596: p_position_id in number default hr_api.g_number,
597: p_comments in varchar2 default hr_api.g_varchar2,
598: p_tea_information_category in varchar2 default hr_api.g_varchar2,
599: p_tea_information1 in varchar2 default hr_api.g_varchar2,
600: p_tea_information2 in varchar2 default hr_api.g_varchar2,
601: p_tea_information3 in varchar2 default hr_api.g_varchar2,
602: p_tea_information4 in varchar2 default hr_api.g_varchar2,
603: p_tea_information5 in varchar2 default hr_api.g_varchar2,
596: p_position_id in number default hr_api.g_number,
597: p_comments in varchar2 default hr_api.g_varchar2,
598: p_tea_information_category in varchar2 default hr_api.g_varchar2,
599: p_tea_information1 in varchar2 default hr_api.g_varchar2,
600: p_tea_information2 in varchar2 default hr_api.g_varchar2,
601: p_tea_information3 in varchar2 default hr_api.g_varchar2,
602: p_tea_information4 in varchar2 default hr_api.g_varchar2,
603: p_tea_information5 in varchar2 default hr_api.g_varchar2,
604: p_tea_information6 in varchar2 default hr_api.g_varchar2,
597: p_comments in varchar2 default hr_api.g_varchar2,
598: p_tea_information_category in varchar2 default hr_api.g_varchar2,
599: p_tea_information1 in varchar2 default hr_api.g_varchar2,
600: p_tea_information2 in varchar2 default hr_api.g_varchar2,
601: p_tea_information3 in varchar2 default hr_api.g_varchar2,
602: p_tea_information4 in varchar2 default hr_api.g_varchar2,
603: p_tea_information5 in varchar2 default hr_api.g_varchar2,
604: p_tea_information6 in varchar2 default hr_api.g_varchar2,
605: p_tea_information7 in varchar2 default hr_api.g_varchar2,
598: p_tea_information_category in varchar2 default hr_api.g_varchar2,
599: p_tea_information1 in varchar2 default hr_api.g_varchar2,
600: p_tea_information2 in varchar2 default hr_api.g_varchar2,
601: p_tea_information3 in varchar2 default hr_api.g_varchar2,
602: p_tea_information4 in varchar2 default hr_api.g_varchar2,
603: p_tea_information5 in varchar2 default hr_api.g_varchar2,
604: p_tea_information6 in varchar2 default hr_api.g_varchar2,
605: p_tea_information7 in varchar2 default hr_api.g_varchar2,
606: p_tea_information8 in varchar2 default hr_api.g_varchar2,
599: p_tea_information1 in varchar2 default hr_api.g_varchar2,
600: p_tea_information2 in varchar2 default hr_api.g_varchar2,
601: p_tea_information3 in varchar2 default hr_api.g_varchar2,
602: p_tea_information4 in varchar2 default hr_api.g_varchar2,
603: p_tea_information5 in varchar2 default hr_api.g_varchar2,
604: p_tea_information6 in varchar2 default hr_api.g_varchar2,
605: p_tea_information7 in varchar2 default hr_api.g_varchar2,
606: p_tea_information8 in varchar2 default hr_api.g_varchar2,
607: p_tea_information9 in varchar2 default hr_api.g_varchar2,
600: p_tea_information2 in varchar2 default hr_api.g_varchar2,
601: p_tea_information3 in varchar2 default hr_api.g_varchar2,
602: p_tea_information4 in varchar2 default hr_api.g_varchar2,
603: p_tea_information5 in varchar2 default hr_api.g_varchar2,
604: p_tea_information6 in varchar2 default hr_api.g_varchar2,
605: p_tea_information7 in varchar2 default hr_api.g_varchar2,
606: p_tea_information8 in varchar2 default hr_api.g_varchar2,
607: p_tea_information9 in varchar2 default hr_api.g_varchar2,
608: p_tea_information10 in varchar2 default hr_api.g_varchar2,
601: p_tea_information3 in varchar2 default hr_api.g_varchar2,
602: p_tea_information4 in varchar2 default hr_api.g_varchar2,
603: p_tea_information5 in varchar2 default hr_api.g_varchar2,
604: p_tea_information6 in varchar2 default hr_api.g_varchar2,
605: p_tea_information7 in varchar2 default hr_api.g_varchar2,
606: p_tea_information8 in varchar2 default hr_api.g_varchar2,
607: p_tea_information9 in varchar2 default hr_api.g_varchar2,
608: p_tea_information10 in varchar2 default hr_api.g_varchar2,
609: p_tea_information11 in varchar2 default hr_api.g_varchar2,
602: p_tea_information4 in varchar2 default hr_api.g_varchar2,
603: p_tea_information5 in varchar2 default hr_api.g_varchar2,
604: p_tea_information6 in varchar2 default hr_api.g_varchar2,
605: p_tea_information7 in varchar2 default hr_api.g_varchar2,
606: p_tea_information8 in varchar2 default hr_api.g_varchar2,
607: p_tea_information9 in varchar2 default hr_api.g_varchar2,
608: p_tea_information10 in varchar2 default hr_api.g_varchar2,
609: p_tea_information11 in varchar2 default hr_api.g_varchar2,
610: p_tea_information12 in varchar2 default hr_api.g_varchar2,
603: p_tea_information5 in varchar2 default hr_api.g_varchar2,
604: p_tea_information6 in varchar2 default hr_api.g_varchar2,
605: p_tea_information7 in varchar2 default hr_api.g_varchar2,
606: p_tea_information8 in varchar2 default hr_api.g_varchar2,
607: p_tea_information9 in varchar2 default hr_api.g_varchar2,
608: p_tea_information10 in varchar2 default hr_api.g_varchar2,
609: p_tea_information11 in varchar2 default hr_api.g_varchar2,
610: p_tea_information12 in varchar2 default hr_api.g_varchar2,
611: p_tea_information13 in varchar2 default hr_api.g_varchar2,
604: p_tea_information6 in varchar2 default hr_api.g_varchar2,
605: p_tea_information7 in varchar2 default hr_api.g_varchar2,
606: p_tea_information8 in varchar2 default hr_api.g_varchar2,
607: p_tea_information9 in varchar2 default hr_api.g_varchar2,
608: p_tea_information10 in varchar2 default hr_api.g_varchar2,
609: p_tea_information11 in varchar2 default hr_api.g_varchar2,
610: p_tea_information12 in varchar2 default hr_api.g_varchar2,
611: p_tea_information13 in varchar2 default hr_api.g_varchar2,
612: p_tea_information14 in varchar2 default hr_api.g_varchar2,
605: p_tea_information7 in varchar2 default hr_api.g_varchar2,
606: p_tea_information8 in varchar2 default hr_api.g_varchar2,
607: p_tea_information9 in varchar2 default hr_api.g_varchar2,
608: p_tea_information10 in varchar2 default hr_api.g_varchar2,
609: p_tea_information11 in varchar2 default hr_api.g_varchar2,
610: p_tea_information12 in varchar2 default hr_api.g_varchar2,
611: p_tea_information13 in varchar2 default hr_api.g_varchar2,
612: p_tea_information14 in varchar2 default hr_api.g_varchar2,
613: p_tea_information15 in varchar2 default hr_api.g_varchar2,
606: p_tea_information8 in varchar2 default hr_api.g_varchar2,
607: p_tea_information9 in varchar2 default hr_api.g_varchar2,
608: p_tea_information10 in varchar2 default hr_api.g_varchar2,
609: p_tea_information11 in varchar2 default hr_api.g_varchar2,
610: p_tea_information12 in varchar2 default hr_api.g_varchar2,
611: p_tea_information13 in varchar2 default hr_api.g_varchar2,
612: p_tea_information14 in varchar2 default hr_api.g_varchar2,
613: p_tea_information15 in varchar2 default hr_api.g_varchar2,
614: p_tea_information16 in varchar2 default hr_api.g_varchar2,
607: p_tea_information9 in varchar2 default hr_api.g_varchar2,
608: p_tea_information10 in varchar2 default hr_api.g_varchar2,
609: p_tea_information11 in varchar2 default hr_api.g_varchar2,
610: p_tea_information12 in varchar2 default hr_api.g_varchar2,
611: p_tea_information13 in varchar2 default hr_api.g_varchar2,
612: p_tea_information14 in varchar2 default hr_api.g_varchar2,
613: p_tea_information15 in varchar2 default hr_api.g_varchar2,
614: p_tea_information16 in varchar2 default hr_api.g_varchar2,
615: p_tea_information17 in varchar2 default hr_api.g_varchar2,
608: p_tea_information10 in varchar2 default hr_api.g_varchar2,
609: p_tea_information11 in varchar2 default hr_api.g_varchar2,
610: p_tea_information12 in varchar2 default hr_api.g_varchar2,
611: p_tea_information13 in varchar2 default hr_api.g_varchar2,
612: p_tea_information14 in varchar2 default hr_api.g_varchar2,
613: p_tea_information15 in varchar2 default hr_api.g_varchar2,
614: p_tea_information16 in varchar2 default hr_api.g_varchar2,
615: p_tea_information17 in varchar2 default hr_api.g_varchar2,
616: p_tea_information18 in varchar2 default hr_api.g_varchar2,
609: p_tea_information11 in varchar2 default hr_api.g_varchar2,
610: p_tea_information12 in varchar2 default hr_api.g_varchar2,
611: p_tea_information13 in varchar2 default hr_api.g_varchar2,
612: p_tea_information14 in varchar2 default hr_api.g_varchar2,
613: p_tea_information15 in varchar2 default hr_api.g_varchar2,
614: p_tea_information16 in varchar2 default hr_api.g_varchar2,
615: p_tea_information17 in varchar2 default hr_api.g_varchar2,
616: p_tea_information18 in varchar2 default hr_api.g_varchar2,
617: p_tea_information19 in varchar2 default hr_api.g_varchar2,
610: p_tea_information12 in varchar2 default hr_api.g_varchar2,
611: p_tea_information13 in varchar2 default hr_api.g_varchar2,
612: p_tea_information14 in varchar2 default hr_api.g_varchar2,
613: p_tea_information15 in varchar2 default hr_api.g_varchar2,
614: p_tea_information16 in varchar2 default hr_api.g_varchar2,
615: p_tea_information17 in varchar2 default hr_api.g_varchar2,
616: p_tea_information18 in varchar2 default hr_api.g_varchar2,
617: p_tea_information19 in varchar2 default hr_api.g_varchar2,
618: p_tea_information20 in varchar2 default hr_api.g_varchar2,
611: p_tea_information13 in varchar2 default hr_api.g_varchar2,
612: p_tea_information14 in varchar2 default hr_api.g_varchar2,
613: p_tea_information15 in varchar2 default hr_api.g_varchar2,
614: p_tea_information16 in varchar2 default hr_api.g_varchar2,
615: p_tea_information17 in varchar2 default hr_api.g_varchar2,
616: p_tea_information18 in varchar2 default hr_api.g_varchar2,
617: p_tea_information19 in varchar2 default hr_api.g_varchar2,
618: p_tea_information20 in varchar2 default hr_api.g_varchar2,
619: p_validate in boolean default false
612: p_tea_information14 in varchar2 default hr_api.g_varchar2,
613: p_tea_information15 in varchar2 default hr_api.g_varchar2,
614: p_tea_information16 in varchar2 default hr_api.g_varchar2,
615: p_tea_information17 in varchar2 default hr_api.g_varchar2,
616: p_tea_information18 in varchar2 default hr_api.g_varchar2,
617: p_tea_information19 in varchar2 default hr_api.g_varchar2,
618: p_tea_information20 in varchar2 default hr_api.g_varchar2,
619: p_validate in boolean default false
620: ,p_association_type in varchar2
613: p_tea_information15 in varchar2 default hr_api.g_varchar2,
614: p_tea_information16 in varchar2 default hr_api.g_varchar2,
615: p_tea_information17 in varchar2 default hr_api.g_varchar2,
616: p_tea_information18 in varchar2 default hr_api.g_varchar2,
617: p_tea_information19 in varchar2 default hr_api.g_varchar2,
618: p_tea_information20 in varchar2 default hr_api.g_varchar2,
619: p_validate in boolean default false
620: ,p_association_type in varchar2
621: ,p_business_group_id in number default null
614: p_tea_information16 in varchar2 default hr_api.g_varchar2,
615: p_tea_information17 in varchar2 default hr_api.g_varchar2,
616: p_tea_information18 in varchar2 default hr_api.g_varchar2,
617: p_tea_information19 in varchar2 default hr_api.g_varchar2,
618: p_tea_information20 in varchar2 default hr_api.g_varchar2,
619: p_validate in boolean default false
620: ,p_association_type in varchar2
621: ,p_business_group_id in number default null
622: ,p_price_basis in varchar2 default null
729: --
730: Procedure upd
731: (
732: p_event_association_id in number,
733: p_event_id in number default hr_api.g_number,
734: p_customer_id in number default hr_api.g_number,
735: p_comments in varchar2 default hr_api.g_varchar2,
736: p_tea_information_category in varchar2 default hr_api.g_varchar2,
737: p_tea_information1 in varchar2 default hr_api.g_varchar2,
730: Procedure upd
731: (
732: p_event_association_id in number,
733: p_event_id in number default hr_api.g_number,
734: p_customer_id in number default hr_api.g_number,
735: p_comments in varchar2 default hr_api.g_varchar2,
736: p_tea_information_category in varchar2 default hr_api.g_varchar2,
737: p_tea_information1 in varchar2 default hr_api.g_varchar2,
738: p_tea_information2 in varchar2 default hr_api.g_varchar2,
731: (
732: p_event_association_id in number,
733: p_event_id in number default hr_api.g_number,
734: p_customer_id in number default hr_api.g_number,
735: p_comments in varchar2 default hr_api.g_varchar2,
736: p_tea_information_category in varchar2 default hr_api.g_varchar2,
737: p_tea_information1 in varchar2 default hr_api.g_varchar2,
738: p_tea_information2 in varchar2 default hr_api.g_varchar2,
739: p_tea_information3 in varchar2 default hr_api.g_varchar2,
732: p_event_association_id in number,
733: p_event_id in number default hr_api.g_number,
734: p_customer_id in number default hr_api.g_number,
735: p_comments in varchar2 default hr_api.g_varchar2,
736: p_tea_information_category in varchar2 default hr_api.g_varchar2,
737: p_tea_information1 in varchar2 default hr_api.g_varchar2,
738: p_tea_information2 in varchar2 default hr_api.g_varchar2,
739: p_tea_information3 in varchar2 default hr_api.g_varchar2,
740: p_tea_information4 in varchar2 default hr_api.g_varchar2,
733: p_event_id in number default hr_api.g_number,
734: p_customer_id in number default hr_api.g_number,
735: p_comments in varchar2 default hr_api.g_varchar2,
736: p_tea_information_category in varchar2 default hr_api.g_varchar2,
737: p_tea_information1 in varchar2 default hr_api.g_varchar2,
738: p_tea_information2 in varchar2 default hr_api.g_varchar2,
739: p_tea_information3 in varchar2 default hr_api.g_varchar2,
740: p_tea_information4 in varchar2 default hr_api.g_varchar2,
741: p_tea_information5 in varchar2 default hr_api.g_varchar2,
734: p_customer_id in number default hr_api.g_number,
735: p_comments in varchar2 default hr_api.g_varchar2,
736: p_tea_information_category in varchar2 default hr_api.g_varchar2,
737: p_tea_information1 in varchar2 default hr_api.g_varchar2,
738: p_tea_information2 in varchar2 default hr_api.g_varchar2,
739: p_tea_information3 in varchar2 default hr_api.g_varchar2,
740: p_tea_information4 in varchar2 default hr_api.g_varchar2,
741: p_tea_information5 in varchar2 default hr_api.g_varchar2,
742: p_tea_information6 in varchar2 default hr_api.g_varchar2,
735: p_comments in varchar2 default hr_api.g_varchar2,
736: p_tea_information_category in varchar2 default hr_api.g_varchar2,
737: p_tea_information1 in varchar2 default hr_api.g_varchar2,
738: p_tea_information2 in varchar2 default hr_api.g_varchar2,
739: p_tea_information3 in varchar2 default hr_api.g_varchar2,
740: p_tea_information4 in varchar2 default hr_api.g_varchar2,
741: p_tea_information5 in varchar2 default hr_api.g_varchar2,
742: p_tea_information6 in varchar2 default hr_api.g_varchar2,
743: p_tea_information7 in varchar2 default hr_api.g_varchar2,
736: p_tea_information_category in varchar2 default hr_api.g_varchar2,
737: p_tea_information1 in varchar2 default hr_api.g_varchar2,
738: p_tea_information2 in varchar2 default hr_api.g_varchar2,
739: p_tea_information3 in varchar2 default hr_api.g_varchar2,
740: p_tea_information4 in varchar2 default hr_api.g_varchar2,
741: p_tea_information5 in varchar2 default hr_api.g_varchar2,
742: p_tea_information6 in varchar2 default hr_api.g_varchar2,
743: p_tea_information7 in varchar2 default hr_api.g_varchar2,
744: p_tea_information8 in varchar2 default hr_api.g_varchar2,
737: p_tea_information1 in varchar2 default hr_api.g_varchar2,
738: p_tea_information2 in varchar2 default hr_api.g_varchar2,
739: p_tea_information3 in varchar2 default hr_api.g_varchar2,
740: p_tea_information4 in varchar2 default hr_api.g_varchar2,
741: p_tea_information5 in varchar2 default hr_api.g_varchar2,
742: p_tea_information6 in varchar2 default hr_api.g_varchar2,
743: p_tea_information7 in varchar2 default hr_api.g_varchar2,
744: p_tea_information8 in varchar2 default hr_api.g_varchar2,
745: p_tea_information9 in varchar2 default hr_api.g_varchar2,
738: p_tea_information2 in varchar2 default hr_api.g_varchar2,
739: p_tea_information3 in varchar2 default hr_api.g_varchar2,
740: p_tea_information4 in varchar2 default hr_api.g_varchar2,
741: p_tea_information5 in varchar2 default hr_api.g_varchar2,
742: p_tea_information6 in varchar2 default hr_api.g_varchar2,
743: p_tea_information7 in varchar2 default hr_api.g_varchar2,
744: p_tea_information8 in varchar2 default hr_api.g_varchar2,
745: p_tea_information9 in varchar2 default hr_api.g_varchar2,
746: p_tea_information10 in varchar2 default hr_api.g_varchar2,
739: p_tea_information3 in varchar2 default hr_api.g_varchar2,
740: p_tea_information4 in varchar2 default hr_api.g_varchar2,
741: p_tea_information5 in varchar2 default hr_api.g_varchar2,
742: p_tea_information6 in varchar2 default hr_api.g_varchar2,
743: p_tea_information7 in varchar2 default hr_api.g_varchar2,
744: p_tea_information8 in varchar2 default hr_api.g_varchar2,
745: p_tea_information9 in varchar2 default hr_api.g_varchar2,
746: p_tea_information10 in varchar2 default hr_api.g_varchar2,
747: p_tea_information11 in varchar2 default hr_api.g_varchar2,
740: p_tea_information4 in varchar2 default hr_api.g_varchar2,
741: p_tea_information5 in varchar2 default hr_api.g_varchar2,
742: p_tea_information6 in varchar2 default hr_api.g_varchar2,
743: p_tea_information7 in varchar2 default hr_api.g_varchar2,
744: p_tea_information8 in varchar2 default hr_api.g_varchar2,
745: p_tea_information9 in varchar2 default hr_api.g_varchar2,
746: p_tea_information10 in varchar2 default hr_api.g_varchar2,
747: p_tea_information11 in varchar2 default hr_api.g_varchar2,
748: p_tea_information12 in varchar2 default hr_api.g_varchar2,
741: p_tea_information5 in varchar2 default hr_api.g_varchar2,
742: p_tea_information6 in varchar2 default hr_api.g_varchar2,
743: p_tea_information7 in varchar2 default hr_api.g_varchar2,
744: p_tea_information8 in varchar2 default hr_api.g_varchar2,
745: p_tea_information9 in varchar2 default hr_api.g_varchar2,
746: p_tea_information10 in varchar2 default hr_api.g_varchar2,
747: p_tea_information11 in varchar2 default hr_api.g_varchar2,
748: p_tea_information12 in varchar2 default hr_api.g_varchar2,
749: p_tea_information13 in varchar2 default hr_api.g_varchar2,
742: p_tea_information6 in varchar2 default hr_api.g_varchar2,
743: p_tea_information7 in varchar2 default hr_api.g_varchar2,
744: p_tea_information8 in varchar2 default hr_api.g_varchar2,
745: p_tea_information9 in varchar2 default hr_api.g_varchar2,
746: p_tea_information10 in varchar2 default hr_api.g_varchar2,
747: p_tea_information11 in varchar2 default hr_api.g_varchar2,
748: p_tea_information12 in varchar2 default hr_api.g_varchar2,
749: p_tea_information13 in varchar2 default hr_api.g_varchar2,
750: p_tea_information14 in varchar2 default hr_api.g_varchar2,
743: p_tea_information7 in varchar2 default hr_api.g_varchar2,
744: p_tea_information8 in varchar2 default hr_api.g_varchar2,
745: p_tea_information9 in varchar2 default hr_api.g_varchar2,
746: p_tea_information10 in varchar2 default hr_api.g_varchar2,
747: p_tea_information11 in varchar2 default hr_api.g_varchar2,
748: p_tea_information12 in varchar2 default hr_api.g_varchar2,
749: p_tea_information13 in varchar2 default hr_api.g_varchar2,
750: p_tea_information14 in varchar2 default hr_api.g_varchar2,
751: p_tea_information15 in varchar2 default hr_api.g_varchar2,
744: p_tea_information8 in varchar2 default hr_api.g_varchar2,
745: p_tea_information9 in varchar2 default hr_api.g_varchar2,
746: p_tea_information10 in varchar2 default hr_api.g_varchar2,
747: p_tea_information11 in varchar2 default hr_api.g_varchar2,
748: p_tea_information12 in varchar2 default hr_api.g_varchar2,
749: p_tea_information13 in varchar2 default hr_api.g_varchar2,
750: p_tea_information14 in varchar2 default hr_api.g_varchar2,
751: p_tea_information15 in varchar2 default hr_api.g_varchar2,
752: p_tea_information16 in varchar2 default hr_api.g_varchar2,
745: p_tea_information9 in varchar2 default hr_api.g_varchar2,
746: p_tea_information10 in varchar2 default hr_api.g_varchar2,
747: p_tea_information11 in varchar2 default hr_api.g_varchar2,
748: p_tea_information12 in varchar2 default hr_api.g_varchar2,
749: p_tea_information13 in varchar2 default hr_api.g_varchar2,
750: p_tea_information14 in varchar2 default hr_api.g_varchar2,
751: p_tea_information15 in varchar2 default hr_api.g_varchar2,
752: p_tea_information16 in varchar2 default hr_api.g_varchar2,
753: p_tea_information17 in varchar2 default hr_api.g_varchar2,
746: p_tea_information10 in varchar2 default hr_api.g_varchar2,
747: p_tea_information11 in varchar2 default hr_api.g_varchar2,
748: p_tea_information12 in varchar2 default hr_api.g_varchar2,
749: p_tea_information13 in varchar2 default hr_api.g_varchar2,
750: p_tea_information14 in varchar2 default hr_api.g_varchar2,
751: p_tea_information15 in varchar2 default hr_api.g_varchar2,
752: p_tea_information16 in varchar2 default hr_api.g_varchar2,
753: p_tea_information17 in varchar2 default hr_api.g_varchar2,
754: p_tea_information18 in varchar2 default hr_api.g_varchar2,
747: p_tea_information11 in varchar2 default hr_api.g_varchar2,
748: p_tea_information12 in varchar2 default hr_api.g_varchar2,
749: p_tea_information13 in varchar2 default hr_api.g_varchar2,
750: p_tea_information14 in varchar2 default hr_api.g_varchar2,
751: p_tea_information15 in varchar2 default hr_api.g_varchar2,
752: p_tea_information16 in varchar2 default hr_api.g_varchar2,
753: p_tea_information17 in varchar2 default hr_api.g_varchar2,
754: p_tea_information18 in varchar2 default hr_api.g_varchar2,
755: p_tea_information19 in varchar2 default hr_api.g_varchar2,
748: p_tea_information12 in varchar2 default hr_api.g_varchar2,
749: p_tea_information13 in varchar2 default hr_api.g_varchar2,
750: p_tea_information14 in varchar2 default hr_api.g_varchar2,
751: p_tea_information15 in varchar2 default hr_api.g_varchar2,
752: p_tea_information16 in varchar2 default hr_api.g_varchar2,
753: p_tea_information17 in varchar2 default hr_api.g_varchar2,
754: p_tea_information18 in varchar2 default hr_api.g_varchar2,
755: p_tea_information19 in varchar2 default hr_api.g_varchar2,
756: p_tea_information20 in varchar2 default hr_api.g_varchar2,
749: p_tea_information13 in varchar2 default hr_api.g_varchar2,
750: p_tea_information14 in varchar2 default hr_api.g_varchar2,
751: p_tea_information15 in varchar2 default hr_api.g_varchar2,
752: p_tea_information16 in varchar2 default hr_api.g_varchar2,
753: p_tea_information17 in varchar2 default hr_api.g_varchar2,
754: p_tea_information18 in varchar2 default hr_api.g_varchar2,
755: p_tea_information19 in varchar2 default hr_api.g_varchar2,
756: p_tea_information20 in varchar2 default hr_api.g_varchar2,
757: p_validate in boolean
750: p_tea_information14 in varchar2 default hr_api.g_varchar2,
751: p_tea_information15 in varchar2 default hr_api.g_varchar2,
752: p_tea_information16 in varchar2 default hr_api.g_varchar2,
753: p_tea_information17 in varchar2 default hr_api.g_varchar2,
754: p_tea_information18 in varchar2 default hr_api.g_varchar2,
755: p_tea_information19 in varchar2 default hr_api.g_varchar2,
756: p_tea_information20 in varchar2 default hr_api.g_varchar2,
757: p_validate in boolean
758: ,p_business_group_id in number
751: p_tea_information15 in varchar2 default hr_api.g_varchar2,
752: p_tea_information16 in varchar2 default hr_api.g_varchar2,
753: p_tea_information17 in varchar2 default hr_api.g_varchar2,
754: p_tea_information18 in varchar2 default hr_api.g_varchar2,
755: p_tea_information19 in varchar2 default hr_api.g_varchar2,
756: p_tea_information20 in varchar2 default hr_api.g_varchar2,
757: p_validate in boolean
758: ,p_business_group_id in number
759: ,p_price_basis in varchar2
752: p_tea_information16 in varchar2 default hr_api.g_varchar2,
753: p_tea_information17 in varchar2 default hr_api.g_varchar2,
754: p_tea_information18 in varchar2 default hr_api.g_varchar2,
755: p_tea_information19 in varchar2 default hr_api.g_varchar2,
756: p_tea_information20 in varchar2 default hr_api.g_varchar2,
757: p_validate in boolean
758: ,p_business_group_id in number
759: ,p_price_basis in varchar2
760: ,p_booking_id in out nocopy number