APPS.OTA_NHS_UPD dependencies on HR_API

Line 119: When hr_api.check_integrity_violated Then

115: --
116: hr_utility.set_location(' Leaving:'||l_proc, 10);
117: --
118: Exception
119: When hr_api.check_integrity_violated Then
120: -- A check constraint has been violated
121: ota_nhs_shd.g_api_dml := false; -- Unset the api dml status
122: ota_nhs_shd.constraint_error
123: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 123: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

119: When hr_api.check_integrity_violated Then
120: -- A check constraint has been violated
121: ota_nhs_shd.g_api_dml := false; -- Unset the api dml status
122: ota_nhs_shd.constraint_error
123: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
124: When hr_api.parent_integrity_violated Then
125: -- Parent integrity has been violated
126: ota_nhs_shd.g_api_dml := false; -- Unset the api dml status
127: ota_nhs_shd.constraint_error

Line 124: When hr_api.parent_integrity_violated Then

120: -- A check constraint has been violated
121: ota_nhs_shd.g_api_dml := false; -- Unset the api dml status
122: ota_nhs_shd.constraint_error
123: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
124: When hr_api.parent_integrity_violated Then
125: -- Parent integrity has been violated
126: ota_nhs_shd.g_api_dml := false; -- Unset the api dml status
127: ota_nhs_shd.constraint_error
128: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 128: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

124: When hr_api.parent_integrity_violated Then
125: -- Parent integrity has been violated
126: ota_nhs_shd.g_api_dml := false; -- Unset the api dml status
127: ota_nhs_shd.constraint_error
128: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
129: When hr_api.unique_integrity_violated Then
130: -- Unique integrity has been violated
131: ota_nhs_shd.g_api_dml := false; -- Unset the api dml status
132: ota_nhs_shd.constraint_error

Line 129: When hr_api.unique_integrity_violated Then

125: -- Parent integrity has been violated
126: ota_nhs_shd.g_api_dml := false; -- Unset the api dml status
127: ota_nhs_shd.constraint_error
128: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
129: When hr_api.unique_integrity_violated Then
130: -- Unique integrity has been violated
131: ota_nhs_shd.g_api_dml := false; -- Unset the api dml status
132: ota_nhs_shd.constraint_error
133: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 133: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

129: When hr_api.unique_integrity_violated Then
130: -- Unique integrity has been violated
131: ota_nhs_shd.g_api_dml := false; -- Unset the api dml status
132: ota_nhs_shd.constraint_error
133: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
134: When Others Then
135: ota_nhs_shd.g_api_dml := false; -- Unset the api dml status
136: Raise;
137: End update_dml;

Line 391: when hr_api.cannot_find_prog_unit then

387: );
388: --
389: exception
390: --
391: when hr_api.cannot_find_prog_unit then
392: --
393: hr_api.cannot_find_prog_unit_error
394: (p_module_name => 'OTA_NOTRNG_HISTORIES'
395: ,p_hook_type => 'AU');

Line 393: hr_api.cannot_find_prog_unit_error

389: exception
390: --
391: when hr_api.cannot_find_prog_unit then
392: --
393: hr_api.cannot_find_prog_unit_error
394: (p_module_name => 'OTA_NOTRNG_HISTORIES'
395: ,p_hook_type => 'AU');
396: --
397: end;

Line 463: If (p_rec.person_id = hr_api.g_number) then

459: -- p_rec plsql record structure
460: -- to see if a system default is being used. If a system default
461: -- is being used then we must set to the 'current' argument value.
462: --
463: If (p_rec.person_id = hr_api.g_number) then
464: p_rec.person_id :=
465: ota_nhs_shd.g_old_rec.person_id;
466: End If;
467: If (p_rec.contact_id = hr_api.g_number) then

Line 467: If (p_rec.contact_id = hr_api.g_number) then

463: If (p_rec.person_id = hr_api.g_number) then
464: p_rec.person_id :=
465: ota_nhs_shd.g_old_rec.person_id;
466: End If;
467: If (p_rec.contact_id = hr_api.g_number) then
468: p_rec.contact_id :=
469: ota_nhs_shd.g_old_rec.contact_id;
470: End If;
471: If (p_rec.trng_title = hr_api.g_varchar2) then

Line 471: If (p_rec.trng_title = hr_api.g_varchar2) then

467: If (p_rec.contact_id = hr_api.g_number) then
468: p_rec.contact_id :=
469: ota_nhs_shd.g_old_rec.contact_id;
470: End If;
471: If (p_rec.trng_title = hr_api.g_varchar2) then
472: p_rec.trng_title :=
473: ota_nhs_shd.g_old_rec.trng_title;
474: End If;
475: If (p_rec.provider = hr_api.g_varchar2) then

Line 475: If (p_rec.provider = hr_api.g_varchar2) then

471: If (p_rec.trng_title = hr_api.g_varchar2) then
472: p_rec.trng_title :=
473: ota_nhs_shd.g_old_rec.trng_title;
474: End If;
475: If (p_rec.provider = hr_api.g_varchar2) then
476: p_rec.provider :=
477: ota_nhs_shd.g_old_rec.provider;
478: End If;
479: If (p_rec.type = hr_api.g_varchar2) then

Line 479: If (p_rec.type = hr_api.g_varchar2) then

475: If (p_rec.provider = hr_api.g_varchar2) then
476: p_rec.provider :=
477: ota_nhs_shd.g_old_rec.provider;
478: End If;
479: If (p_rec.type = hr_api.g_varchar2) then
480: p_rec.type :=
481: ota_nhs_shd.g_old_rec.type;
482: End If;
483: If (p_rec.centre = hr_api.g_varchar2) then

Line 483: If (p_rec.centre = hr_api.g_varchar2) then

479: If (p_rec.type = hr_api.g_varchar2) then
480: p_rec.type :=
481: ota_nhs_shd.g_old_rec.type;
482: End If;
483: If (p_rec.centre = hr_api.g_varchar2) then
484: p_rec.centre :=
485: ota_nhs_shd.g_old_rec.centre;
486: End If;
487: If (p_rec.completion_date = hr_api.g_date) then

Line 487: If (p_rec.completion_date = hr_api.g_date) then

483: If (p_rec.centre = hr_api.g_varchar2) then
484: p_rec.centre :=
485: ota_nhs_shd.g_old_rec.centre;
486: End If;
487: If (p_rec.completion_date = hr_api.g_date) then
488: p_rec.completion_date :=
489: ota_nhs_shd.g_old_rec.completion_date;
490: End If;
491: If (p_rec.award = hr_api.g_varchar2) then

Line 491: If (p_rec.award = hr_api.g_varchar2) then

487: If (p_rec.completion_date = hr_api.g_date) then
488: p_rec.completion_date :=
489: ota_nhs_shd.g_old_rec.completion_date;
490: End If;
491: If (p_rec.award = hr_api.g_varchar2) then
492: p_rec.award :=
493: ota_nhs_shd.g_old_rec.award;
494: End If;
495: If (p_rec.rating = hr_api.g_varchar2) then

Line 495: If (p_rec.rating = hr_api.g_varchar2) then

491: If (p_rec.award = hr_api.g_varchar2) then
492: p_rec.award :=
493: ota_nhs_shd.g_old_rec.award;
494: End If;
495: If (p_rec.rating = hr_api.g_varchar2) then
496: p_rec.rating :=
497: ota_nhs_shd.g_old_rec.rating;
498: End If;
499: If (p_rec.duration = hr_api.g_number) then

Line 499: If (p_rec.duration = hr_api.g_number) then

495: If (p_rec.rating = hr_api.g_varchar2) then
496: p_rec.rating :=
497: ota_nhs_shd.g_old_rec.rating;
498: End If;
499: If (p_rec.duration = hr_api.g_number) then
500: p_rec.duration :=
501: ota_nhs_shd.g_old_rec.duration;
502: End If;
503: If (p_rec.duration_units = hr_api.g_varchar2) then

Line 503: If (p_rec.duration_units = hr_api.g_varchar2) then

499: If (p_rec.duration = hr_api.g_number) then
500: p_rec.duration :=
501: ota_nhs_shd.g_old_rec.duration;
502: End If;
503: If (p_rec.duration_units = hr_api.g_varchar2) then
504: p_rec.duration_units :=
505: ota_nhs_shd.g_old_rec.duration_units;
506: End If;
507: If (p_rec.activity_version_id = hr_api.g_number) then

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

503: If (p_rec.duration_units = hr_api.g_varchar2) then
504: p_rec.duration_units :=
505: ota_nhs_shd.g_old_rec.duration_units;
506: End If;
507: If (p_rec.activity_version_id = hr_api.g_number) then
508: p_rec.activity_version_id :=
509: ota_nhs_shd.g_old_rec.activity_version_id;
510: End If;
511: If (p_rec.status = hr_api.g_varchar2) then

Line 511: If (p_rec.status = hr_api.g_varchar2) then

507: If (p_rec.activity_version_id = hr_api.g_number) then
508: p_rec.activity_version_id :=
509: ota_nhs_shd.g_old_rec.activity_version_id;
510: End If;
511: If (p_rec.status = hr_api.g_varchar2) then
512: p_rec.status :=
513: ota_nhs_shd.g_old_rec.status;
514: End If;
515: If (p_rec.verified_by_id = hr_api.g_number) then

Line 515: If (p_rec.verified_by_id = hr_api.g_number) then

511: If (p_rec.status = hr_api.g_varchar2) then
512: p_rec.status :=
513: ota_nhs_shd.g_old_rec.status;
514: End If;
515: If (p_rec.verified_by_id = hr_api.g_number) then
516: p_rec.verified_by_id :=
517: ota_nhs_shd.g_old_rec.verified_by_id;
518: End If;
519: If (p_rec.nth_information_category = hr_api.g_varchar2) then

Line 519: If (p_rec.nth_information_category = hr_api.g_varchar2) then

515: If (p_rec.verified_by_id = hr_api.g_number) then
516: p_rec.verified_by_id :=
517: ota_nhs_shd.g_old_rec.verified_by_id;
518: End If;
519: If (p_rec.nth_information_category = hr_api.g_varchar2) then
520: p_rec.nth_information_category :=
521: ota_nhs_shd.g_old_rec.nth_information_category;
522: End If;
523: If (p_rec.nth_information1 = hr_api.g_varchar2) then

Line 523: If (p_rec.nth_information1 = hr_api.g_varchar2) then

519: If (p_rec.nth_information_category = hr_api.g_varchar2) then
520: p_rec.nth_information_category :=
521: ota_nhs_shd.g_old_rec.nth_information_category;
522: End If;
523: If (p_rec.nth_information1 = hr_api.g_varchar2) then
524: p_rec.nth_information1 :=
525: ota_nhs_shd.g_old_rec.nth_information1;
526: End If;
527: If (p_rec.nth_information2 = hr_api.g_varchar2) then

Line 527: If (p_rec.nth_information2 = hr_api.g_varchar2) then

523: If (p_rec.nth_information1 = hr_api.g_varchar2) then
524: p_rec.nth_information1 :=
525: ota_nhs_shd.g_old_rec.nth_information1;
526: End If;
527: If (p_rec.nth_information2 = hr_api.g_varchar2) then
528: p_rec.nth_information2 :=
529: ota_nhs_shd.g_old_rec.nth_information2;
530: End If;
531: If (p_rec.nth_information3 = hr_api.g_varchar2) then

Line 531: If (p_rec.nth_information3 = hr_api.g_varchar2) then

527: If (p_rec.nth_information2 = hr_api.g_varchar2) then
528: p_rec.nth_information2 :=
529: ota_nhs_shd.g_old_rec.nth_information2;
530: End If;
531: If (p_rec.nth_information3 = hr_api.g_varchar2) then
532: p_rec.nth_information3 :=
533: ota_nhs_shd.g_old_rec.nth_information3;
534: End If;
535: If (p_rec.nth_information4 = hr_api.g_varchar2) then

Line 535: If (p_rec.nth_information4 = hr_api.g_varchar2) then

531: If (p_rec.nth_information3 = hr_api.g_varchar2) then
532: p_rec.nth_information3 :=
533: ota_nhs_shd.g_old_rec.nth_information3;
534: End If;
535: If (p_rec.nth_information4 = hr_api.g_varchar2) then
536: p_rec.nth_information4 :=
537: ota_nhs_shd.g_old_rec.nth_information4;
538: End If;
539: If (p_rec.nth_information5 = hr_api.g_varchar2) then

Line 539: If (p_rec.nth_information5 = hr_api.g_varchar2) then

535: If (p_rec.nth_information4 = hr_api.g_varchar2) then
536: p_rec.nth_information4 :=
537: ota_nhs_shd.g_old_rec.nth_information4;
538: End If;
539: If (p_rec.nth_information5 = hr_api.g_varchar2) then
540: p_rec.nth_information5 :=
541: ota_nhs_shd.g_old_rec.nth_information5;
542: End If;
543: If (p_rec.nth_information6 = hr_api.g_varchar2) then

Line 543: If (p_rec.nth_information6 = hr_api.g_varchar2) then

539: If (p_rec.nth_information5 = hr_api.g_varchar2) then
540: p_rec.nth_information5 :=
541: ota_nhs_shd.g_old_rec.nth_information5;
542: End If;
543: If (p_rec.nth_information6 = hr_api.g_varchar2) then
544: p_rec.nth_information6 :=
545: ota_nhs_shd.g_old_rec.nth_information6;
546: End If;
547: If (p_rec.nth_information7 = hr_api.g_varchar2) then

Line 547: If (p_rec.nth_information7 = hr_api.g_varchar2) then

543: If (p_rec.nth_information6 = hr_api.g_varchar2) then
544: p_rec.nth_information6 :=
545: ota_nhs_shd.g_old_rec.nth_information6;
546: End If;
547: If (p_rec.nth_information7 = hr_api.g_varchar2) then
548: p_rec.nth_information7 :=
549: ota_nhs_shd.g_old_rec.nth_information7;
550: End If;
551: If (p_rec.nth_information8 = hr_api.g_varchar2) then

Line 551: If (p_rec.nth_information8 = hr_api.g_varchar2) then

547: If (p_rec.nth_information7 = hr_api.g_varchar2) then
548: p_rec.nth_information7 :=
549: ota_nhs_shd.g_old_rec.nth_information7;
550: End If;
551: If (p_rec.nth_information8 = hr_api.g_varchar2) then
552: p_rec.nth_information8 :=
553: ota_nhs_shd.g_old_rec.nth_information8;
554: End If;
555: If (p_rec.nth_information9 = hr_api.g_varchar2) then

Line 555: If (p_rec.nth_information9 = hr_api.g_varchar2) then

551: If (p_rec.nth_information8 = hr_api.g_varchar2) then
552: p_rec.nth_information8 :=
553: ota_nhs_shd.g_old_rec.nth_information8;
554: End If;
555: If (p_rec.nth_information9 = hr_api.g_varchar2) then
556: p_rec.nth_information9 :=
557: ota_nhs_shd.g_old_rec.nth_information9;
558: End If;
559: If (p_rec.nth_information10 = hr_api.g_varchar2) then

Line 559: If (p_rec.nth_information10 = hr_api.g_varchar2) then

555: If (p_rec.nth_information9 = hr_api.g_varchar2) then
556: p_rec.nth_information9 :=
557: ota_nhs_shd.g_old_rec.nth_information9;
558: End If;
559: If (p_rec.nth_information10 = hr_api.g_varchar2) then
560: p_rec.nth_information10 :=
561: ota_nhs_shd.g_old_rec.nth_information10;
562: End If;
563: If (p_rec.nth_information11 = hr_api.g_varchar2) then

Line 563: If (p_rec.nth_information11 = hr_api.g_varchar2) then

559: If (p_rec.nth_information10 = hr_api.g_varchar2) then
560: p_rec.nth_information10 :=
561: ota_nhs_shd.g_old_rec.nth_information10;
562: End If;
563: If (p_rec.nth_information11 = hr_api.g_varchar2) then
564: p_rec.nth_information11 :=
565: ota_nhs_shd.g_old_rec.nth_information11;
566: End If;
567: If (p_rec.nth_information12 = hr_api.g_varchar2) then

Line 567: If (p_rec.nth_information12 = hr_api.g_varchar2) then

563: If (p_rec.nth_information11 = hr_api.g_varchar2) then
564: p_rec.nth_information11 :=
565: ota_nhs_shd.g_old_rec.nth_information11;
566: End If;
567: If (p_rec.nth_information12 = hr_api.g_varchar2) then
568: p_rec.nth_information12 :=
569: ota_nhs_shd.g_old_rec.nth_information12;
570: End If;
571: If (p_rec.nth_information13 = hr_api.g_varchar2) then

Line 571: If (p_rec.nth_information13 = hr_api.g_varchar2) then

567: If (p_rec.nth_information12 = hr_api.g_varchar2) then
568: p_rec.nth_information12 :=
569: ota_nhs_shd.g_old_rec.nth_information12;
570: End If;
571: If (p_rec.nth_information13 = hr_api.g_varchar2) then
572: p_rec.nth_information13 :=
573: ota_nhs_shd.g_old_rec.nth_information13;
574: End If;
575: If (p_rec.nth_information15 = hr_api.g_varchar2) then

Line 575: If (p_rec.nth_information15 = hr_api.g_varchar2) then

571: If (p_rec.nth_information13 = hr_api.g_varchar2) then
572: p_rec.nth_information13 :=
573: ota_nhs_shd.g_old_rec.nth_information13;
574: End If;
575: If (p_rec.nth_information15 = hr_api.g_varchar2) then
576: p_rec.nth_information15 :=
577: ota_nhs_shd.g_old_rec.nth_information15;
578: End If;
579: If (p_rec.nth_information16 = hr_api.g_varchar2) then

Line 579: If (p_rec.nth_information16 = hr_api.g_varchar2) then

575: If (p_rec.nth_information15 = hr_api.g_varchar2) then
576: p_rec.nth_information15 :=
577: ota_nhs_shd.g_old_rec.nth_information15;
578: End If;
579: If (p_rec.nth_information16 = hr_api.g_varchar2) then
580: p_rec.nth_information16 :=
581: ota_nhs_shd.g_old_rec.nth_information16;
582: End If;
583: If (p_rec.nth_information17 = hr_api.g_varchar2) then

Line 583: If (p_rec.nth_information17 = hr_api.g_varchar2) then

579: If (p_rec.nth_information16 = hr_api.g_varchar2) then
580: p_rec.nth_information16 :=
581: ota_nhs_shd.g_old_rec.nth_information16;
582: End If;
583: If (p_rec.nth_information17 = hr_api.g_varchar2) then
584: p_rec.nth_information17 :=
585: ota_nhs_shd.g_old_rec.nth_information17;
586: End If;
587: If (p_rec.nth_information18 = hr_api.g_varchar2) then

Line 587: If (p_rec.nth_information18 = hr_api.g_varchar2) then

583: If (p_rec.nth_information17 = hr_api.g_varchar2) then
584: p_rec.nth_information17 :=
585: ota_nhs_shd.g_old_rec.nth_information17;
586: End If;
587: If (p_rec.nth_information18 = hr_api.g_varchar2) then
588: p_rec.nth_information18 :=
589: ota_nhs_shd.g_old_rec.nth_information18;
590: End If;
591: If (p_rec.nth_information19 = hr_api.g_varchar2) then

Line 591: If (p_rec.nth_information19 = hr_api.g_varchar2) then

587: If (p_rec.nth_information18 = hr_api.g_varchar2) then
588: p_rec.nth_information18 :=
589: ota_nhs_shd.g_old_rec.nth_information18;
590: End If;
591: If (p_rec.nth_information19 = hr_api.g_varchar2) then
592: p_rec.nth_information19 :=
593: ota_nhs_shd.g_old_rec.nth_information19;
594: End If;
595: If (p_rec.nth_information20 = hr_api.g_varchar2) then

Line 595: If (p_rec.nth_information20 = hr_api.g_varchar2) then

591: If (p_rec.nth_information19 = hr_api.g_varchar2) then
592: p_rec.nth_information19 :=
593: ota_nhs_shd.g_old_rec.nth_information19;
594: End If;
595: If (p_rec.nth_information20 = hr_api.g_varchar2) then
596: p_rec.nth_information20 :=
597: ota_nhs_shd.g_old_rec.nth_information20;
598: End If;
599: If (p_rec.org_id = hr_api.g_number) then

Line 599: If (p_rec.org_id = hr_api.g_number) then

595: If (p_rec.nth_information20 = hr_api.g_varchar2) then
596: p_rec.nth_information20 :=
597: ota_nhs_shd.g_old_rec.nth_information20;
598: End If;
599: If (p_rec.org_id = hr_api.g_number) then
600: p_rec.org_id :=
601: ota_nhs_shd.g_old_rec.org_id;
602: End If;
603: If (p_rec.business_group_id = hr_api.g_number) then

Line 603: If (p_rec.business_group_id = hr_api.g_number) then

599: If (p_rec.org_id = hr_api.g_number) then
600: p_rec.org_id :=
601: ota_nhs_shd.g_old_rec.org_id;
602: End If;
603: If (p_rec.business_group_id = hr_api.g_number) then
604: p_rec.business_group_id :=
605: ota_nhs_shd.g_old_rec.business_group_id;
606: End If;
607: If (p_rec.nth_information14 = hr_api.g_varchar2) then

Line 607: If (p_rec.nth_information14 = hr_api.g_varchar2) then

603: If (p_rec.business_group_id = hr_api.g_number) then
604: p_rec.business_group_id :=
605: ota_nhs_shd.g_old_rec.business_group_id;
606: End If;
607: If (p_rec.nth_information14 = hr_api.g_varchar2) then
608: p_rec.nth_information14 :=
609: ota_nhs_shd.g_old_rec.nth_information14;
610: End If;
611: If (p_rec.customer_id = hr_api.g_number) then

Line 611: If (p_rec.customer_id = hr_api.g_number) then

607: If (p_rec.nth_information14 = hr_api.g_varchar2) then
608: p_rec.nth_information14 :=
609: ota_nhs_shd.g_old_rec.nth_information14;
610: End If;
611: If (p_rec.customer_id = hr_api.g_number) then
612: p_rec.customer_id :=
613: ota_nhs_shd.g_old_rec.customer_id;
614: End If;
615: If (p_rec.organization_id = hr_api.g_number) then

Line 615: If (p_rec.organization_id = hr_api.g_number) then

611: If (p_rec.customer_id = hr_api.g_number) then
612: p_rec.customer_id :=
613: ota_nhs_shd.g_old_rec.customer_id;
614: End If;
615: If (p_rec.organization_id = hr_api.g_number) then
616: p_rec.organization_id :=
617: ota_nhs_shd.g_old_rec.organization_id;
618: End If;
619: --

Line 678: p_person_id in number default hr_api.g_number,

674: -- ----------------------------------------------------------------------------
675: Procedure upd
676: (p_effective_date in date ,
677: p_nota_history_id in number,
678: p_person_id in number default hr_api.g_number,
679: p_contact_id in number default hr_api.g_number,
680: p_trng_title in varchar2 default hr_api.g_varchar2,
681: p_provider in varchar2 default hr_api.g_varchar2,
682: p_type in varchar2 default hr_api.g_varchar2,

Line 679: p_contact_id in number default hr_api.g_number,

675: Procedure upd
676: (p_effective_date in date ,
677: p_nota_history_id in number,
678: p_person_id in number default hr_api.g_number,
679: p_contact_id in number default hr_api.g_number,
680: p_trng_title in varchar2 default hr_api.g_varchar2,
681: p_provider in varchar2 default hr_api.g_varchar2,
682: p_type in varchar2 default hr_api.g_varchar2,
683: p_centre in varchar2 default hr_api.g_varchar2,

Line 680: p_trng_title in varchar2 default hr_api.g_varchar2,

676: (p_effective_date in date ,
677: p_nota_history_id in number,
678: p_person_id in number default hr_api.g_number,
679: p_contact_id in number default hr_api.g_number,
680: p_trng_title in varchar2 default hr_api.g_varchar2,
681: p_provider in varchar2 default hr_api.g_varchar2,
682: p_type in varchar2 default hr_api.g_varchar2,
683: p_centre in varchar2 default hr_api.g_varchar2,
684: p_completion_date in date default hr_api.g_date,

Line 681: p_provider in varchar2 default hr_api.g_varchar2,

677: p_nota_history_id in number,
678: p_person_id in number default hr_api.g_number,
679: p_contact_id in number default hr_api.g_number,
680: p_trng_title in varchar2 default hr_api.g_varchar2,
681: p_provider in varchar2 default hr_api.g_varchar2,
682: p_type in varchar2 default hr_api.g_varchar2,
683: p_centre in varchar2 default hr_api.g_varchar2,
684: p_completion_date in date default hr_api.g_date,
685: p_award in varchar2 default hr_api.g_varchar2,

Line 682: p_type in varchar2 default hr_api.g_varchar2,

678: p_person_id in number default hr_api.g_number,
679: p_contact_id in number default hr_api.g_number,
680: p_trng_title in varchar2 default hr_api.g_varchar2,
681: p_provider in varchar2 default hr_api.g_varchar2,
682: p_type in varchar2 default hr_api.g_varchar2,
683: p_centre in varchar2 default hr_api.g_varchar2,
684: p_completion_date in date default hr_api.g_date,
685: p_award in varchar2 default hr_api.g_varchar2,
686: p_rating in varchar2 default hr_api.g_varchar2,

Line 683: p_centre in varchar2 default hr_api.g_varchar2,

679: p_contact_id in number default hr_api.g_number,
680: p_trng_title in varchar2 default hr_api.g_varchar2,
681: p_provider in varchar2 default hr_api.g_varchar2,
682: p_type in varchar2 default hr_api.g_varchar2,
683: p_centre in varchar2 default hr_api.g_varchar2,
684: p_completion_date in date default hr_api.g_date,
685: p_award in varchar2 default hr_api.g_varchar2,
686: p_rating in varchar2 default hr_api.g_varchar2,
687: p_duration in number default hr_api.g_number,

Line 684: p_completion_date in date default hr_api.g_date,

680: p_trng_title in varchar2 default hr_api.g_varchar2,
681: p_provider in varchar2 default hr_api.g_varchar2,
682: p_type in varchar2 default hr_api.g_varchar2,
683: p_centre in varchar2 default hr_api.g_varchar2,
684: p_completion_date in date default hr_api.g_date,
685: p_award in varchar2 default hr_api.g_varchar2,
686: p_rating in varchar2 default hr_api.g_varchar2,
687: p_duration in number default hr_api.g_number,
688: p_duration_units in varchar2 default hr_api.g_varchar2,

Line 685: p_award in varchar2 default hr_api.g_varchar2,

681: p_provider in varchar2 default hr_api.g_varchar2,
682: p_type in varchar2 default hr_api.g_varchar2,
683: p_centre in varchar2 default hr_api.g_varchar2,
684: p_completion_date in date default hr_api.g_date,
685: p_award in varchar2 default hr_api.g_varchar2,
686: p_rating in varchar2 default hr_api.g_varchar2,
687: p_duration in number default hr_api.g_number,
688: p_duration_units in varchar2 default hr_api.g_varchar2,
689: p_activity_version_id in number default hr_api.g_number,

Line 686: p_rating in varchar2 default hr_api.g_varchar2,

682: p_type in varchar2 default hr_api.g_varchar2,
683: p_centre in varchar2 default hr_api.g_varchar2,
684: p_completion_date in date default hr_api.g_date,
685: p_award in varchar2 default hr_api.g_varchar2,
686: p_rating in varchar2 default hr_api.g_varchar2,
687: p_duration in number default hr_api.g_number,
688: p_duration_units in varchar2 default hr_api.g_varchar2,
689: p_activity_version_id in number default hr_api.g_number,
690: p_status in varchar2 default hr_api.g_varchar2,

Line 687: p_duration in number default hr_api.g_number,

683: p_centre in varchar2 default hr_api.g_varchar2,
684: p_completion_date in date default hr_api.g_date,
685: p_award in varchar2 default hr_api.g_varchar2,
686: p_rating in varchar2 default hr_api.g_varchar2,
687: p_duration in number default hr_api.g_number,
688: p_duration_units in varchar2 default hr_api.g_varchar2,
689: p_activity_version_id in number default hr_api.g_number,
690: p_status in varchar2 default hr_api.g_varchar2,
691: p_verified_by_id in number default hr_api.g_number,

Line 688: p_duration_units in varchar2 default hr_api.g_varchar2,

684: p_completion_date in date default hr_api.g_date,
685: p_award in varchar2 default hr_api.g_varchar2,
686: p_rating in varchar2 default hr_api.g_varchar2,
687: p_duration in number default hr_api.g_number,
688: p_duration_units in varchar2 default hr_api.g_varchar2,
689: p_activity_version_id in number default hr_api.g_number,
690: p_status in varchar2 default hr_api.g_varchar2,
691: p_verified_by_id in number default hr_api.g_number,
692: p_nth_information_category in varchar2 default hr_api.g_varchar2,

Line 689: p_activity_version_id in number default hr_api.g_number,

685: p_award in varchar2 default hr_api.g_varchar2,
686: p_rating in varchar2 default hr_api.g_varchar2,
687: p_duration in number default hr_api.g_number,
688: p_duration_units in varchar2 default hr_api.g_varchar2,
689: p_activity_version_id in number default hr_api.g_number,
690: p_status in varchar2 default hr_api.g_varchar2,
691: p_verified_by_id in number default hr_api.g_number,
692: p_nth_information_category in varchar2 default hr_api.g_varchar2,
693: p_nth_information1 in varchar2 default hr_api.g_varchar2,

Line 690: p_status in varchar2 default hr_api.g_varchar2,

686: p_rating in varchar2 default hr_api.g_varchar2,
687: p_duration in number default hr_api.g_number,
688: p_duration_units in varchar2 default hr_api.g_varchar2,
689: p_activity_version_id in number default hr_api.g_number,
690: p_status in varchar2 default hr_api.g_varchar2,
691: p_verified_by_id in number default hr_api.g_number,
692: p_nth_information_category in varchar2 default hr_api.g_varchar2,
693: p_nth_information1 in varchar2 default hr_api.g_varchar2,
694: p_nth_information2 in varchar2 default hr_api.g_varchar2,

Line 691: p_verified_by_id in number default hr_api.g_number,

687: p_duration in number default hr_api.g_number,
688: p_duration_units in varchar2 default hr_api.g_varchar2,
689: p_activity_version_id in number default hr_api.g_number,
690: p_status in varchar2 default hr_api.g_varchar2,
691: p_verified_by_id in number default hr_api.g_number,
692: p_nth_information_category in varchar2 default hr_api.g_varchar2,
693: p_nth_information1 in varchar2 default hr_api.g_varchar2,
694: p_nth_information2 in varchar2 default hr_api.g_varchar2,
695: p_nth_information3 in varchar2 default hr_api.g_varchar2,

Line 692: p_nth_information_category in varchar2 default hr_api.g_varchar2,

688: p_duration_units in varchar2 default hr_api.g_varchar2,
689: p_activity_version_id in number default hr_api.g_number,
690: p_status in varchar2 default hr_api.g_varchar2,
691: p_verified_by_id in number default hr_api.g_number,
692: p_nth_information_category in varchar2 default hr_api.g_varchar2,
693: p_nth_information1 in varchar2 default hr_api.g_varchar2,
694: p_nth_information2 in varchar2 default hr_api.g_varchar2,
695: p_nth_information3 in varchar2 default hr_api.g_varchar2,
696: p_nth_information4 in varchar2 default hr_api.g_varchar2,

Line 693: p_nth_information1 in varchar2 default hr_api.g_varchar2,

689: p_activity_version_id in number default hr_api.g_number,
690: p_status in varchar2 default hr_api.g_varchar2,
691: p_verified_by_id in number default hr_api.g_number,
692: p_nth_information_category in varchar2 default hr_api.g_varchar2,
693: p_nth_information1 in varchar2 default hr_api.g_varchar2,
694: p_nth_information2 in varchar2 default hr_api.g_varchar2,
695: p_nth_information3 in varchar2 default hr_api.g_varchar2,
696: p_nth_information4 in varchar2 default hr_api.g_varchar2,
697: p_nth_information5 in varchar2 default hr_api.g_varchar2,

Line 694: p_nth_information2 in varchar2 default hr_api.g_varchar2,

690: p_status in varchar2 default hr_api.g_varchar2,
691: p_verified_by_id in number default hr_api.g_number,
692: p_nth_information_category in varchar2 default hr_api.g_varchar2,
693: p_nth_information1 in varchar2 default hr_api.g_varchar2,
694: p_nth_information2 in varchar2 default hr_api.g_varchar2,
695: p_nth_information3 in varchar2 default hr_api.g_varchar2,
696: p_nth_information4 in varchar2 default hr_api.g_varchar2,
697: p_nth_information5 in varchar2 default hr_api.g_varchar2,
698: p_nth_information6 in varchar2 default hr_api.g_varchar2,

Line 695: p_nth_information3 in varchar2 default hr_api.g_varchar2,

691: p_verified_by_id in number default hr_api.g_number,
692: p_nth_information_category in varchar2 default hr_api.g_varchar2,
693: p_nth_information1 in varchar2 default hr_api.g_varchar2,
694: p_nth_information2 in varchar2 default hr_api.g_varchar2,
695: p_nth_information3 in varchar2 default hr_api.g_varchar2,
696: p_nth_information4 in varchar2 default hr_api.g_varchar2,
697: p_nth_information5 in varchar2 default hr_api.g_varchar2,
698: p_nth_information6 in varchar2 default hr_api.g_varchar2,
699: p_nth_information7 in varchar2 default hr_api.g_varchar2,

Line 696: p_nth_information4 in varchar2 default hr_api.g_varchar2,

692: p_nth_information_category in varchar2 default hr_api.g_varchar2,
693: p_nth_information1 in varchar2 default hr_api.g_varchar2,
694: p_nth_information2 in varchar2 default hr_api.g_varchar2,
695: p_nth_information3 in varchar2 default hr_api.g_varchar2,
696: p_nth_information4 in varchar2 default hr_api.g_varchar2,
697: p_nth_information5 in varchar2 default hr_api.g_varchar2,
698: p_nth_information6 in varchar2 default hr_api.g_varchar2,
699: p_nth_information7 in varchar2 default hr_api.g_varchar2,
700: p_nth_information8 in varchar2 default hr_api.g_varchar2,

Line 697: p_nth_information5 in varchar2 default hr_api.g_varchar2,

693: p_nth_information1 in varchar2 default hr_api.g_varchar2,
694: p_nth_information2 in varchar2 default hr_api.g_varchar2,
695: p_nth_information3 in varchar2 default hr_api.g_varchar2,
696: p_nth_information4 in varchar2 default hr_api.g_varchar2,
697: p_nth_information5 in varchar2 default hr_api.g_varchar2,
698: p_nth_information6 in varchar2 default hr_api.g_varchar2,
699: p_nth_information7 in varchar2 default hr_api.g_varchar2,
700: p_nth_information8 in varchar2 default hr_api.g_varchar2,
701: p_nth_information9 in varchar2 default hr_api.g_varchar2,

Line 698: p_nth_information6 in varchar2 default hr_api.g_varchar2,

694: p_nth_information2 in varchar2 default hr_api.g_varchar2,
695: p_nth_information3 in varchar2 default hr_api.g_varchar2,
696: p_nth_information4 in varchar2 default hr_api.g_varchar2,
697: p_nth_information5 in varchar2 default hr_api.g_varchar2,
698: p_nth_information6 in varchar2 default hr_api.g_varchar2,
699: p_nth_information7 in varchar2 default hr_api.g_varchar2,
700: p_nth_information8 in varchar2 default hr_api.g_varchar2,
701: p_nth_information9 in varchar2 default hr_api.g_varchar2,
702: p_nth_information10 in varchar2 default hr_api.g_varchar2,

Line 699: p_nth_information7 in varchar2 default hr_api.g_varchar2,

695: p_nth_information3 in varchar2 default hr_api.g_varchar2,
696: p_nth_information4 in varchar2 default hr_api.g_varchar2,
697: p_nth_information5 in varchar2 default hr_api.g_varchar2,
698: p_nth_information6 in varchar2 default hr_api.g_varchar2,
699: p_nth_information7 in varchar2 default hr_api.g_varchar2,
700: p_nth_information8 in varchar2 default hr_api.g_varchar2,
701: p_nth_information9 in varchar2 default hr_api.g_varchar2,
702: p_nth_information10 in varchar2 default hr_api.g_varchar2,
703: p_nth_information11 in varchar2 default hr_api.g_varchar2,

Line 700: p_nth_information8 in varchar2 default hr_api.g_varchar2,

696: p_nth_information4 in varchar2 default hr_api.g_varchar2,
697: p_nth_information5 in varchar2 default hr_api.g_varchar2,
698: p_nth_information6 in varchar2 default hr_api.g_varchar2,
699: p_nth_information7 in varchar2 default hr_api.g_varchar2,
700: p_nth_information8 in varchar2 default hr_api.g_varchar2,
701: p_nth_information9 in varchar2 default hr_api.g_varchar2,
702: p_nth_information10 in varchar2 default hr_api.g_varchar2,
703: p_nth_information11 in varchar2 default hr_api.g_varchar2,
704: p_nth_information12 in varchar2 default hr_api.g_varchar2,

Line 701: p_nth_information9 in varchar2 default hr_api.g_varchar2,

697: p_nth_information5 in varchar2 default hr_api.g_varchar2,
698: p_nth_information6 in varchar2 default hr_api.g_varchar2,
699: p_nth_information7 in varchar2 default hr_api.g_varchar2,
700: p_nth_information8 in varchar2 default hr_api.g_varchar2,
701: p_nth_information9 in varchar2 default hr_api.g_varchar2,
702: p_nth_information10 in varchar2 default hr_api.g_varchar2,
703: p_nth_information11 in varchar2 default hr_api.g_varchar2,
704: p_nth_information12 in varchar2 default hr_api.g_varchar2,
705: p_nth_information13 in varchar2 default hr_api.g_varchar2,

Line 702: p_nth_information10 in varchar2 default hr_api.g_varchar2,

698: p_nth_information6 in varchar2 default hr_api.g_varchar2,
699: p_nth_information7 in varchar2 default hr_api.g_varchar2,
700: p_nth_information8 in varchar2 default hr_api.g_varchar2,
701: p_nth_information9 in varchar2 default hr_api.g_varchar2,
702: p_nth_information10 in varchar2 default hr_api.g_varchar2,
703: p_nth_information11 in varchar2 default hr_api.g_varchar2,
704: p_nth_information12 in varchar2 default hr_api.g_varchar2,
705: p_nth_information13 in varchar2 default hr_api.g_varchar2,
706: p_nth_information15 in varchar2 default hr_api.g_varchar2,

Line 703: p_nth_information11 in varchar2 default hr_api.g_varchar2,

699: p_nth_information7 in varchar2 default hr_api.g_varchar2,
700: p_nth_information8 in varchar2 default hr_api.g_varchar2,
701: p_nth_information9 in varchar2 default hr_api.g_varchar2,
702: p_nth_information10 in varchar2 default hr_api.g_varchar2,
703: p_nth_information11 in varchar2 default hr_api.g_varchar2,
704: p_nth_information12 in varchar2 default hr_api.g_varchar2,
705: p_nth_information13 in varchar2 default hr_api.g_varchar2,
706: p_nth_information15 in varchar2 default hr_api.g_varchar2,
707: p_nth_information16 in varchar2 default hr_api.g_varchar2,

Line 704: p_nth_information12 in varchar2 default hr_api.g_varchar2,

700: p_nth_information8 in varchar2 default hr_api.g_varchar2,
701: p_nth_information9 in varchar2 default hr_api.g_varchar2,
702: p_nth_information10 in varchar2 default hr_api.g_varchar2,
703: p_nth_information11 in varchar2 default hr_api.g_varchar2,
704: p_nth_information12 in varchar2 default hr_api.g_varchar2,
705: p_nth_information13 in varchar2 default hr_api.g_varchar2,
706: p_nth_information15 in varchar2 default hr_api.g_varchar2,
707: p_nth_information16 in varchar2 default hr_api.g_varchar2,
708: p_nth_information17 in varchar2 default hr_api.g_varchar2,

Line 705: p_nth_information13 in varchar2 default hr_api.g_varchar2,

701: p_nth_information9 in varchar2 default hr_api.g_varchar2,
702: p_nth_information10 in varchar2 default hr_api.g_varchar2,
703: p_nth_information11 in varchar2 default hr_api.g_varchar2,
704: p_nth_information12 in varchar2 default hr_api.g_varchar2,
705: p_nth_information13 in varchar2 default hr_api.g_varchar2,
706: p_nth_information15 in varchar2 default hr_api.g_varchar2,
707: p_nth_information16 in varchar2 default hr_api.g_varchar2,
708: p_nth_information17 in varchar2 default hr_api.g_varchar2,
709: p_nth_information18 in varchar2 default hr_api.g_varchar2,

Line 706: p_nth_information15 in varchar2 default hr_api.g_varchar2,

702: p_nth_information10 in varchar2 default hr_api.g_varchar2,
703: p_nth_information11 in varchar2 default hr_api.g_varchar2,
704: p_nth_information12 in varchar2 default hr_api.g_varchar2,
705: p_nth_information13 in varchar2 default hr_api.g_varchar2,
706: p_nth_information15 in varchar2 default hr_api.g_varchar2,
707: p_nth_information16 in varchar2 default hr_api.g_varchar2,
708: p_nth_information17 in varchar2 default hr_api.g_varchar2,
709: p_nth_information18 in varchar2 default hr_api.g_varchar2,
710: p_nth_information19 in varchar2 default hr_api.g_varchar2,

Line 707: p_nth_information16 in varchar2 default hr_api.g_varchar2,

703: p_nth_information11 in varchar2 default hr_api.g_varchar2,
704: p_nth_information12 in varchar2 default hr_api.g_varchar2,
705: p_nth_information13 in varchar2 default hr_api.g_varchar2,
706: p_nth_information15 in varchar2 default hr_api.g_varchar2,
707: p_nth_information16 in varchar2 default hr_api.g_varchar2,
708: p_nth_information17 in varchar2 default hr_api.g_varchar2,
709: p_nth_information18 in varchar2 default hr_api.g_varchar2,
710: p_nth_information19 in varchar2 default hr_api.g_varchar2,
711: p_nth_information20 in varchar2 default hr_api.g_varchar2,

Line 708: p_nth_information17 in varchar2 default hr_api.g_varchar2,

704: p_nth_information12 in varchar2 default hr_api.g_varchar2,
705: p_nth_information13 in varchar2 default hr_api.g_varchar2,
706: p_nth_information15 in varchar2 default hr_api.g_varchar2,
707: p_nth_information16 in varchar2 default hr_api.g_varchar2,
708: p_nth_information17 in varchar2 default hr_api.g_varchar2,
709: p_nth_information18 in varchar2 default hr_api.g_varchar2,
710: p_nth_information19 in varchar2 default hr_api.g_varchar2,
711: p_nth_information20 in varchar2 default hr_api.g_varchar2,
712: p_org_id in number default hr_api.g_number,

Line 709: p_nth_information18 in varchar2 default hr_api.g_varchar2,

705: p_nth_information13 in varchar2 default hr_api.g_varchar2,
706: p_nth_information15 in varchar2 default hr_api.g_varchar2,
707: p_nth_information16 in varchar2 default hr_api.g_varchar2,
708: p_nth_information17 in varchar2 default hr_api.g_varchar2,
709: p_nth_information18 in varchar2 default hr_api.g_varchar2,
710: p_nth_information19 in varchar2 default hr_api.g_varchar2,
711: p_nth_information20 in varchar2 default hr_api.g_varchar2,
712: p_org_id in number default hr_api.g_number,
713: p_object_version_number in out nocopy number,

Line 710: p_nth_information19 in varchar2 default hr_api.g_varchar2,

706: p_nth_information15 in varchar2 default hr_api.g_varchar2,
707: p_nth_information16 in varchar2 default hr_api.g_varchar2,
708: p_nth_information17 in varchar2 default hr_api.g_varchar2,
709: p_nth_information18 in varchar2 default hr_api.g_varchar2,
710: p_nth_information19 in varchar2 default hr_api.g_varchar2,
711: p_nth_information20 in varchar2 default hr_api.g_varchar2,
712: p_org_id in number default hr_api.g_number,
713: p_object_version_number in out nocopy number,
714: p_business_group_id in number default hr_api.g_number,

Line 711: p_nth_information20 in varchar2 default hr_api.g_varchar2,

707: p_nth_information16 in varchar2 default hr_api.g_varchar2,
708: p_nth_information17 in varchar2 default hr_api.g_varchar2,
709: p_nth_information18 in varchar2 default hr_api.g_varchar2,
710: p_nth_information19 in varchar2 default hr_api.g_varchar2,
711: p_nth_information20 in varchar2 default hr_api.g_varchar2,
712: p_org_id in number default hr_api.g_number,
713: p_object_version_number in out nocopy number,
714: p_business_group_id in number default hr_api.g_number,
715: p_nth_information14 in varchar2 default hr_api.g_varchar2,

Line 712: p_org_id in number default hr_api.g_number,

708: p_nth_information17 in varchar2 default hr_api.g_varchar2,
709: p_nth_information18 in varchar2 default hr_api.g_varchar2,
710: p_nth_information19 in varchar2 default hr_api.g_varchar2,
711: p_nth_information20 in varchar2 default hr_api.g_varchar2,
712: p_org_id in number default hr_api.g_number,
713: p_object_version_number in out nocopy number,
714: p_business_group_id in number default hr_api.g_number,
715: p_nth_information14 in varchar2 default hr_api.g_varchar2,
716: p_customer_id in number default hr_api.g_number,

Line 714: p_business_group_id in number default hr_api.g_number,

710: p_nth_information19 in varchar2 default hr_api.g_varchar2,
711: p_nth_information20 in varchar2 default hr_api.g_varchar2,
712: p_org_id in number default hr_api.g_number,
713: p_object_version_number in out nocopy number,
714: p_business_group_id in number default hr_api.g_number,
715: p_nth_information14 in varchar2 default hr_api.g_varchar2,
716: p_customer_id in number default hr_api.g_number,
717: p_organization_id in number default hr_api.g_number
718: ) is

Line 715: p_nth_information14 in varchar2 default hr_api.g_varchar2,

711: p_nth_information20 in varchar2 default hr_api.g_varchar2,
712: p_org_id in number default hr_api.g_number,
713: p_object_version_number in out nocopy number,
714: p_business_group_id in number default hr_api.g_number,
715: p_nth_information14 in varchar2 default hr_api.g_varchar2,
716: p_customer_id in number default hr_api.g_number,
717: p_organization_id in number default hr_api.g_number
718: ) is
719: --

Line 716: p_customer_id in number default hr_api.g_number,

712: p_org_id in number default hr_api.g_number,
713: p_object_version_number in out nocopy number,
714: p_business_group_id in number default hr_api.g_number,
715: p_nth_information14 in varchar2 default hr_api.g_varchar2,
716: p_customer_id in number default hr_api.g_number,
717: p_organization_id in number default hr_api.g_number
718: ) is
719: --
720: l_rec ota_nhs_shd.g_rec_type;

Line 717: p_organization_id in number default hr_api.g_number

713: p_object_version_number in out nocopy number,
714: p_business_group_id in number default hr_api.g_number,
715: p_nth_information14 in varchar2 default hr_api.g_varchar2,
716: p_customer_id in number default hr_api.g_number,
717: p_organization_id in number default hr_api.g_number
718: ) is
719: --
720: l_rec ota_nhs_shd.g_rec_type;
721: l_proc varchar2(72) := g_package||'upd';