eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OTA_TSR_BUS dependencies on OTA_TSR_SHD

Line 364: if not l_api_updating or p_tsr_id <> OTA_TSR_SHD.g_old_rec.supplied_resource_id then

360: l_api_updating boolean;
361: --
362: procedure chkp is
363: begin
364: if not l_api_updating or p_tsr_id <> OTA_TSR_SHD.g_old_rec.supplied_resource_id then
365: constraint_error2('wrong_old_rec');
366: end if;
367: end chkp;
368: ---------------

Line 373: l_api_updating := OTA_TSR_SHD.api_updating (

369: Begin
370: --
371: hr_utility.set_location('Entering:'||l_proc, 5);
372: --
373: l_api_updating := OTA_TSR_SHD.api_updating (
374: p_supplied_resource_id => p_tsr_id,
375: p_object_version_number => p_ovn );
376: --
377: chkp;

Line 379: if OTA_TSR_SHD.g_old_rec.resource_type <> p_resource_type then

375: p_object_version_number => p_ovn );
376: --
377: chkp;
378: --
379: if OTA_TSR_SHD.g_old_rec.resource_type <> p_resource_type then
380: constraint_error2('resource_type_is_not_updatable');
381: end if;
382: --
383: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 644: nvl(ota_tsr_shd.g_old_rec.training_center_id,hr_api.g_number) <>

640:
641: Begin
642: hr_utility.set_location('Entering:'||l_proc, 5);
643: if (((p_supplied_resource_id is not null) and
644: nvl(ota_tsr_shd.g_old_rec.training_center_id,hr_api.g_number) <>
645: nvl(p_training_center_id,hr_api.g_number))
646: or (p_supplied_resource_id is null)) then
647: --
648: hr_utility.set_location('Entering:'||l_proc, 10);

Line 694: nvl(ota_tsr_shd.g_old_rec.location_id,hr_api.g_number) <>

690: Begin
691: hr_utility.set_location('Entering:'||l_proc, 5);
692:
693: if (((p_supplied_resource_id is not null) and
694: nvl(ota_tsr_shd.g_old_rec.location_id,hr_api.g_number) <>
695: nvl(p_location_id,hr_api.g_number))
696: or (p_supplied_resource_id is null)) then
697: --
698: hr_utility.set_location('Entering:'||l_proc, 10);

Line 787: nvl(ota_tsr_shd.g_old_rec.trainer_id,hr_api.g_number) <>

783: Begin
784: hr_utility.set_location('Entering:'||l_proc, 5);
785:
786: if (((p_supplied_resource_id is not null) and
787: nvl(ota_tsr_shd.g_old_rec.trainer_id,hr_api.g_number) <>
788: nvl(p_trainer_id,hr_api.g_number))
789: or (p_supplied_resource_id is null)) or
790: nvl(ota_tsr_shd.g_old_rec.start_date, hr_api.g_date) <>
791: nvl(p_start_date, hr_api.g_date) OR

Line 790: nvl(ota_tsr_shd.g_old_rec.start_date, hr_api.g_date) <>

786: if (((p_supplied_resource_id is not null) and
787: nvl(ota_tsr_shd.g_old_rec.trainer_id,hr_api.g_number) <>
788: nvl(p_trainer_id,hr_api.g_number))
789: or (p_supplied_resource_id is null)) or
790: nvl(ota_tsr_shd.g_old_rec.start_date, hr_api.g_date) <>
791: nvl(p_start_date, hr_api.g_date) OR
792: nvl(ota_tsr_shd.g_old_rec.end_date, hr_api.g_date) <>
793: nvl(p_end_date, hr_api.g_date)
794: then

Line 792: nvl(ota_tsr_shd.g_old_rec.end_date, hr_api.g_date) <>

788: nvl(p_trainer_id,hr_api.g_number))
789: or (p_supplied_resource_id is null)) or
790: nvl(ota_tsr_shd.g_old_rec.start_date, hr_api.g_date) <>
791: nvl(p_start_date, hr_api.g_date) OR
792: nvl(ota_tsr_shd.g_old_rec.end_date, hr_api.g_date) <>
793: nvl(p_end_date, hr_api.g_date)
794: then
795: --
796: hr_utility.set_location('Entering:'||l_proc, 10);

Line 856: (p_rec IN ota_tsr_shd.g_rec_type

852: -- Internal Row Handler Use Only.
853: --
854: -- ----------------------------------------------------------------------------
855: PROCEDURE chk_df
856: (p_rec IN ota_tsr_shd.g_rec_type
857: ) IS
858: --
859: l_proc varchar2(72) := g_package || 'chk_df';
860: --

Line 865: NVL(ota_tsr_shd.g_old_rec.tsr_information_category, hr_api.g_varchar2) <>

861: BEGIN
862: hr_utility.set_location('Entering:'||l_proc,10);
863: --
864: IF ((p_rec.supplied_resource_id IS NOT NULL) AND (
865: NVL(ota_tsr_shd.g_old_rec.tsr_information_category, hr_api.g_varchar2) <>
866: NVL(p_rec.tsr_information_category, hr_api.g_varchar2) OR
867: NVL(ota_tsr_shd.g_old_rec.tsr_information1, hr_api.g_varchar2) <>
868: NVL(p_rec.tsr_information1, hr_api.g_varchar2) OR
869: NVL(ota_tsr_shd.g_old_rec.tsr_information2, hr_api.g_varchar2) <>

Line 867: NVL(ota_tsr_shd.g_old_rec.tsr_information1, hr_api.g_varchar2) <>

863: --
864: IF ((p_rec.supplied_resource_id IS NOT NULL) AND (
865: NVL(ota_tsr_shd.g_old_rec.tsr_information_category, hr_api.g_varchar2) <>
866: NVL(p_rec.tsr_information_category, hr_api.g_varchar2) OR
867: NVL(ota_tsr_shd.g_old_rec.tsr_information1, hr_api.g_varchar2) <>
868: NVL(p_rec.tsr_information1, hr_api.g_varchar2) OR
869: NVL(ota_tsr_shd.g_old_rec.tsr_information2, hr_api.g_varchar2) <>
870: NVL(p_rec.tsr_information2, hr_api.g_varchar2) OR
871: NVL(ota_tsr_shd.g_old_rec.tsr_information3, hr_api.g_varchar2) <>

Line 869: NVL(ota_tsr_shd.g_old_rec.tsr_information2, hr_api.g_varchar2) <>

865: NVL(ota_tsr_shd.g_old_rec.tsr_information_category, hr_api.g_varchar2) <>
866: NVL(p_rec.tsr_information_category, hr_api.g_varchar2) OR
867: NVL(ota_tsr_shd.g_old_rec.tsr_information1, hr_api.g_varchar2) <>
868: NVL(p_rec.tsr_information1, hr_api.g_varchar2) OR
869: NVL(ota_tsr_shd.g_old_rec.tsr_information2, hr_api.g_varchar2) <>
870: NVL(p_rec.tsr_information2, hr_api.g_varchar2) OR
871: NVL(ota_tsr_shd.g_old_rec.tsr_information3, hr_api.g_varchar2) <>
872: NVL(p_rec.tsr_information3, hr_api.g_varchar2) OR
873: NVL(ota_tsr_shd.g_old_rec.tsr_information4, hr_api.g_varchar2) <>

Line 871: NVL(ota_tsr_shd.g_old_rec.tsr_information3, hr_api.g_varchar2) <>

867: NVL(ota_tsr_shd.g_old_rec.tsr_information1, hr_api.g_varchar2) <>
868: NVL(p_rec.tsr_information1, hr_api.g_varchar2) OR
869: NVL(ota_tsr_shd.g_old_rec.tsr_information2, hr_api.g_varchar2) <>
870: NVL(p_rec.tsr_information2, hr_api.g_varchar2) OR
871: NVL(ota_tsr_shd.g_old_rec.tsr_information3, hr_api.g_varchar2) <>
872: NVL(p_rec.tsr_information3, hr_api.g_varchar2) OR
873: NVL(ota_tsr_shd.g_old_rec.tsr_information4, hr_api.g_varchar2) <>
874: NVL(p_rec.tsr_information4, hr_api.g_varchar2) OR
875: NVL(ota_tsr_shd.g_old_rec.tsr_information5, hr_api.g_varchar2) <>

Line 873: NVL(ota_tsr_shd.g_old_rec.tsr_information4, hr_api.g_varchar2) <>

869: NVL(ota_tsr_shd.g_old_rec.tsr_information2, hr_api.g_varchar2) <>
870: NVL(p_rec.tsr_information2, hr_api.g_varchar2) OR
871: NVL(ota_tsr_shd.g_old_rec.tsr_information3, hr_api.g_varchar2) <>
872: NVL(p_rec.tsr_information3, hr_api.g_varchar2) OR
873: NVL(ota_tsr_shd.g_old_rec.tsr_information4, hr_api.g_varchar2) <>
874: NVL(p_rec.tsr_information4, hr_api.g_varchar2) OR
875: NVL(ota_tsr_shd.g_old_rec.tsr_information5, hr_api.g_varchar2) <>
876: NVL(p_rec.tsr_information5, hr_api.g_varchar2) OR
877: NVL(ota_tsr_shd.g_old_rec.tsr_information6, hr_api.g_varchar2) <>

Line 875: NVL(ota_tsr_shd.g_old_rec.tsr_information5, hr_api.g_varchar2) <>

871: NVL(ota_tsr_shd.g_old_rec.tsr_information3, hr_api.g_varchar2) <>
872: NVL(p_rec.tsr_information3, hr_api.g_varchar2) OR
873: NVL(ota_tsr_shd.g_old_rec.tsr_information4, hr_api.g_varchar2) <>
874: NVL(p_rec.tsr_information4, hr_api.g_varchar2) OR
875: NVL(ota_tsr_shd.g_old_rec.tsr_information5, hr_api.g_varchar2) <>
876: NVL(p_rec.tsr_information5, hr_api.g_varchar2) OR
877: NVL(ota_tsr_shd.g_old_rec.tsr_information6, hr_api.g_varchar2) <>
878: NVL(p_rec.tsr_information6, hr_api.g_varchar2) OR
879: NVL(ota_tsr_shd.g_old_rec.tsr_information7, hr_api.g_varchar2) <>

Line 877: NVL(ota_tsr_shd.g_old_rec.tsr_information6, hr_api.g_varchar2) <>

873: NVL(ota_tsr_shd.g_old_rec.tsr_information4, hr_api.g_varchar2) <>
874: NVL(p_rec.tsr_information4, hr_api.g_varchar2) OR
875: NVL(ota_tsr_shd.g_old_rec.tsr_information5, hr_api.g_varchar2) <>
876: NVL(p_rec.tsr_information5, hr_api.g_varchar2) OR
877: NVL(ota_tsr_shd.g_old_rec.tsr_information6, hr_api.g_varchar2) <>
878: NVL(p_rec.tsr_information6, hr_api.g_varchar2) OR
879: NVL(ota_tsr_shd.g_old_rec.tsr_information7, hr_api.g_varchar2) <>
880: NVL(p_rec.tsr_information7, hr_api.g_varchar2) OR
881: NVL(ota_tsr_shd.g_old_rec.tsr_information8, hr_api.g_varchar2) <>

Line 879: NVL(ota_tsr_shd.g_old_rec.tsr_information7, hr_api.g_varchar2) <>

875: NVL(ota_tsr_shd.g_old_rec.tsr_information5, hr_api.g_varchar2) <>
876: NVL(p_rec.tsr_information5, hr_api.g_varchar2) OR
877: NVL(ota_tsr_shd.g_old_rec.tsr_information6, hr_api.g_varchar2) <>
878: NVL(p_rec.tsr_information6, hr_api.g_varchar2) OR
879: NVL(ota_tsr_shd.g_old_rec.tsr_information7, hr_api.g_varchar2) <>
880: NVL(p_rec.tsr_information7, hr_api.g_varchar2) OR
881: NVL(ota_tsr_shd.g_old_rec.tsr_information8, hr_api.g_varchar2) <>
882: NVL(p_rec.tsr_information8, hr_api.g_varchar2) OR
883: NVL(ota_tsr_shd.g_old_rec.tsr_information9, hr_api.g_varchar2) <>

Line 881: NVL(ota_tsr_shd.g_old_rec.tsr_information8, hr_api.g_varchar2) <>

877: NVL(ota_tsr_shd.g_old_rec.tsr_information6, hr_api.g_varchar2) <>
878: NVL(p_rec.tsr_information6, hr_api.g_varchar2) OR
879: NVL(ota_tsr_shd.g_old_rec.tsr_information7, hr_api.g_varchar2) <>
880: NVL(p_rec.tsr_information7, hr_api.g_varchar2) OR
881: NVL(ota_tsr_shd.g_old_rec.tsr_information8, hr_api.g_varchar2) <>
882: NVL(p_rec.tsr_information8, hr_api.g_varchar2) OR
883: NVL(ota_tsr_shd.g_old_rec.tsr_information9, hr_api.g_varchar2) <>
884: NVL(p_rec.tsr_information9, hr_api.g_varchar2) OR
885: NVL(ota_tsr_shd.g_old_rec.tsr_information10, hr_api.g_varchar2) <>

Line 883: NVL(ota_tsr_shd.g_old_rec.tsr_information9, hr_api.g_varchar2) <>

879: NVL(ota_tsr_shd.g_old_rec.tsr_information7, hr_api.g_varchar2) <>
880: NVL(p_rec.tsr_information7, hr_api.g_varchar2) OR
881: NVL(ota_tsr_shd.g_old_rec.tsr_information8, hr_api.g_varchar2) <>
882: NVL(p_rec.tsr_information8, hr_api.g_varchar2) OR
883: NVL(ota_tsr_shd.g_old_rec.tsr_information9, hr_api.g_varchar2) <>
884: NVL(p_rec.tsr_information9, hr_api.g_varchar2) OR
885: NVL(ota_tsr_shd.g_old_rec.tsr_information10, hr_api.g_varchar2) <>
886: NVL(p_rec.tsr_information10, hr_api.g_varchar2) OR
887: NVL(ota_tsr_shd.g_old_rec.tsr_information11, hr_api.g_varchar2) <>

Line 885: NVL(ota_tsr_shd.g_old_rec.tsr_information10, hr_api.g_varchar2) <>

881: NVL(ota_tsr_shd.g_old_rec.tsr_information8, hr_api.g_varchar2) <>
882: NVL(p_rec.tsr_information8, hr_api.g_varchar2) OR
883: NVL(ota_tsr_shd.g_old_rec.tsr_information9, hr_api.g_varchar2) <>
884: NVL(p_rec.tsr_information9, hr_api.g_varchar2) OR
885: NVL(ota_tsr_shd.g_old_rec.tsr_information10, hr_api.g_varchar2) <>
886: NVL(p_rec.tsr_information10, hr_api.g_varchar2) OR
887: NVL(ota_tsr_shd.g_old_rec.tsr_information11, hr_api.g_varchar2) <>
888: NVL(p_rec.tsr_information11, hr_api.g_varchar2) OR
889: NVL(ota_tsr_shd.g_old_rec.tsr_information12, hr_api.g_varchar2) <>

Line 887: NVL(ota_tsr_shd.g_old_rec.tsr_information11, hr_api.g_varchar2) <>

883: NVL(ota_tsr_shd.g_old_rec.tsr_information9, hr_api.g_varchar2) <>
884: NVL(p_rec.tsr_information9, hr_api.g_varchar2) OR
885: NVL(ota_tsr_shd.g_old_rec.tsr_information10, hr_api.g_varchar2) <>
886: NVL(p_rec.tsr_information10, hr_api.g_varchar2) OR
887: NVL(ota_tsr_shd.g_old_rec.tsr_information11, hr_api.g_varchar2) <>
888: NVL(p_rec.tsr_information11, hr_api.g_varchar2) OR
889: NVL(ota_tsr_shd.g_old_rec.tsr_information12, hr_api.g_varchar2) <>
890: NVL(p_rec.tsr_information12, hr_api.g_varchar2) OR
891: NVL(ota_tsr_shd.g_old_rec.tsr_information13, hr_api.g_varchar2) <>

Line 889: NVL(ota_tsr_shd.g_old_rec.tsr_information12, hr_api.g_varchar2) <>

885: NVL(ota_tsr_shd.g_old_rec.tsr_information10, hr_api.g_varchar2) <>
886: NVL(p_rec.tsr_information10, hr_api.g_varchar2) OR
887: NVL(ota_tsr_shd.g_old_rec.tsr_information11, hr_api.g_varchar2) <>
888: NVL(p_rec.tsr_information11, hr_api.g_varchar2) OR
889: NVL(ota_tsr_shd.g_old_rec.tsr_information12, hr_api.g_varchar2) <>
890: NVL(p_rec.tsr_information12, hr_api.g_varchar2) OR
891: NVL(ota_tsr_shd.g_old_rec.tsr_information13, hr_api.g_varchar2) <>
892: NVL(p_rec.tsr_information13, hr_api.g_varchar2) OR
893: NVL(ota_tsr_shd.g_old_rec.tsr_information14, hr_api.g_varchar2) <>

Line 891: NVL(ota_tsr_shd.g_old_rec.tsr_information13, hr_api.g_varchar2) <>

887: NVL(ota_tsr_shd.g_old_rec.tsr_information11, hr_api.g_varchar2) <>
888: NVL(p_rec.tsr_information11, hr_api.g_varchar2) OR
889: NVL(ota_tsr_shd.g_old_rec.tsr_information12, hr_api.g_varchar2) <>
890: NVL(p_rec.tsr_information12, hr_api.g_varchar2) OR
891: NVL(ota_tsr_shd.g_old_rec.tsr_information13, hr_api.g_varchar2) <>
892: NVL(p_rec.tsr_information13, hr_api.g_varchar2) OR
893: NVL(ota_tsr_shd.g_old_rec.tsr_information14, hr_api.g_varchar2) <>
894: NVL(p_rec.tsr_information14, hr_api.g_varchar2) OR
895: NVL(ota_tsr_shd.g_old_rec.tsr_information15, hr_api.g_varchar2) <>

Line 893: NVL(ota_tsr_shd.g_old_rec.tsr_information14, hr_api.g_varchar2) <>

889: NVL(ota_tsr_shd.g_old_rec.tsr_information12, hr_api.g_varchar2) <>
890: NVL(p_rec.tsr_information12, hr_api.g_varchar2) OR
891: NVL(ota_tsr_shd.g_old_rec.tsr_information13, hr_api.g_varchar2) <>
892: NVL(p_rec.tsr_information13, hr_api.g_varchar2) OR
893: NVL(ota_tsr_shd.g_old_rec.tsr_information14, hr_api.g_varchar2) <>
894: NVL(p_rec.tsr_information14, hr_api.g_varchar2) OR
895: NVL(ota_tsr_shd.g_old_rec.tsr_information15, hr_api.g_varchar2) <>
896: NVL(p_rec.tsr_information15, hr_api.g_varchar2) OR
897: NVL(ota_tsr_shd.g_old_rec.tsr_information16, hr_api.g_varchar2) <>

Line 895: NVL(ota_tsr_shd.g_old_rec.tsr_information15, hr_api.g_varchar2) <>

891: NVL(ota_tsr_shd.g_old_rec.tsr_information13, hr_api.g_varchar2) <>
892: NVL(p_rec.tsr_information13, hr_api.g_varchar2) OR
893: NVL(ota_tsr_shd.g_old_rec.tsr_information14, hr_api.g_varchar2) <>
894: NVL(p_rec.tsr_information14, hr_api.g_varchar2) OR
895: NVL(ota_tsr_shd.g_old_rec.tsr_information15, hr_api.g_varchar2) <>
896: NVL(p_rec.tsr_information15, hr_api.g_varchar2) OR
897: NVL(ota_tsr_shd.g_old_rec.tsr_information16, hr_api.g_varchar2) <>
898: NVL(p_rec.tsr_information16, hr_api.g_varchar2) OR
899: NVL(ota_tsr_shd.g_old_rec.tsr_information17, hr_api.g_varchar2) <>

Line 897: NVL(ota_tsr_shd.g_old_rec.tsr_information16, hr_api.g_varchar2) <>

893: NVL(ota_tsr_shd.g_old_rec.tsr_information14, hr_api.g_varchar2) <>
894: NVL(p_rec.tsr_information14, hr_api.g_varchar2) OR
895: NVL(ota_tsr_shd.g_old_rec.tsr_information15, hr_api.g_varchar2) <>
896: NVL(p_rec.tsr_information15, hr_api.g_varchar2) OR
897: NVL(ota_tsr_shd.g_old_rec.tsr_information16, hr_api.g_varchar2) <>
898: NVL(p_rec.tsr_information16, hr_api.g_varchar2) OR
899: NVL(ota_tsr_shd.g_old_rec.tsr_information17, hr_api.g_varchar2) <>
900: NVL(p_rec.tsr_information17, hr_api.g_varchar2) OR
901: NVL(ota_tsr_shd.g_old_rec.tsr_information18, hr_api.g_varchar2) <>

Line 899: NVL(ota_tsr_shd.g_old_rec.tsr_information17, hr_api.g_varchar2) <>

895: NVL(ota_tsr_shd.g_old_rec.tsr_information15, hr_api.g_varchar2) <>
896: NVL(p_rec.tsr_information15, hr_api.g_varchar2) OR
897: NVL(ota_tsr_shd.g_old_rec.tsr_information16, hr_api.g_varchar2) <>
898: NVL(p_rec.tsr_information16, hr_api.g_varchar2) OR
899: NVL(ota_tsr_shd.g_old_rec.tsr_information17, hr_api.g_varchar2) <>
900: NVL(p_rec.tsr_information17, hr_api.g_varchar2) OR
901: NVL(ota_tsr_shd.g_old_rec.tsr_information18, hr_api.g_varchar2) <>
902: NVL(p_rec.tsr_information18, hr_api.g_varchar2) OR
903: NVL(ota_tsr_shd.g_old_rec.tsr_information19, hr_api.g_varchar2) <>

Line 901: NVL(ota_tsr_shd.g_old_rec.tsr_information18, hr_api.g_varchar2) <>

897: NVL(ota_tsr_shd.g_old_rec.tsr_information16, hr_api.g_varchar2) <>
898: NVL(p_rec.tsr_information16, hr_api.g_varchar2) OR
899: NVL(ota_tsr_shd.g_old_rec.tsr_information17, hr_api.g_varchar2) <>
900: NVL(p_rec.tsr_information17, hr_api.g_varchar2) OR
901: NVL(ota_tsr_shd.g_old_rec.tsr_information18, hr_api.g_varchar2) <>
902: NVL(p_rec.tsr_information18, hr_api.g_varchar2) OR
903: NVL(ota_tsr_shd.g_old_rec.tsr_information19, hr_api.g_varchar2) <>
904: NVL(p_rec.tsr_information19, hr_api.g_varchar2) OR
905: NVL(ota_tsr_shd.g_old_rec.tsr_information20, hr_api.g_varchar2) <>

Line 903: NVL(ota_tsr_shd.g_old_rec.tsr_information19, hr_api.g_varchar2) <>

899: NVL(ota_tsr_shd.g_old_rec.tsr_information17, hr_api.g_varchar2) <>
900: NVL(p_rec.tsr_information17, hr_api.g_varchar2) OR
901: NVL(ota_tsr_shd.g_old_rec.tsr_information18, hr_api.g_varchar2) <>
902: NVL(p_rec.tsr_information18, hr_api.g_varchar2) OR
903: NVL(ota_tsr_shd.g_old_rec.tsr_information19, hr_api.g_varchar2) <>
904: NVL(p_rec.tsr_information19, hr_api.g_varchar2) OR
905: NVL(ota_tsr_shd.g_old_rec.tsr_information20, hr_api.g_varchar2) <>
906: NVL(p_rec.tsr_information20, hr_api.g_varchar2) ) )
907: OR (p_rec.supplied_resource_id IS NULL) THEN

Line 905: NVL(ota_tsr_shd.g_old_rec.tsr_information20, hr_api.g_varchar2) <>

901: NVL(ota_tsr_shd.g_old_rec.tsr_information18, hr_api.g_varchar2) <>
902: NVL(p_rec.tsr_information18, hr_api.g_varchar2) OR
903: NVL(ota_tsr_shd.g_old_rec.tsr_information19, hr_api.g_varchar2) <>
904: NVL(p_rec.tsr_information19, hr_api.g_varchar2) OR
905: NVL(ota_tsr_shd.g_old_rec.tsr_information20, hr_api.g_varchar2) <>
906: NVL(p_rec.tsr_information20, hr_api.g_varchar2) ) )
907: OR (p_rec.supplied_resource_id IS NULL) THEN
908: --
909: -- Only execute the validation if absolutely necessary:

Line 974: p_rec in ota_tsr_shd.g_rec_type

970: -- GENERAL VALIDATION PROCEDURES
971: --*****************************************************************************
972: procedure validation1
973: (
974: p_rec in ota_tsr_shd.g_rec_type
975: )
976: is
977: ---------------------
978: begin

Line 1015: p_rec in ota_tsr_shd.g_rec_type

1011: --=============================================================================
1012: --=============================================================================
1013: procedure validation2
1014: (
1015: p_rec in ota_tsr_shd.g_rec_type
1016: )
1017: is
1018: ---------------------
1019: begin

Line 1030: p_rec in ota_tsr_shd.g_rec_type

1026: --=============================================================================
1027: --=============================================================================
1028: procedure insert_validate2
1029: (
1030: p_rec in ota_tsr_shd.g_rec_type
1031: )
1032: is
1033: ---------------------
1034: begin

Line 1045: p_rec in ota_tsr_shd.g_rec_type

1041: --=============================================================================
1042: --=============================================================================
1043: procedure update_validate2
1044: (
1045: p_rec in ota_tsr_shd.g_rec_type
1046: )
1047: is
1048: ---------------------
1049: begin

Line 1070: p_rec in ota_tsr_shd.g_rec_type

1066: --=============================================================================
1067: --=============================================================================
1068: procedure delete_validate2
1069: (
1070: p_rec in ota_tsr_shd.g_rec_type
1071: )
1072: is
1073: ---------------------
1074: begin

Line 1087: Procedure insert_validate(p_rec in ota_tsr_shd.g_rec_type) is

1083: --*****************************************************************************
1084: -- ----------------------------------------------------------------------------
1085: -- |---------------------------< insert_validate >----------------------------|
1086: -- ----------------------------------------------------------------------------
1087: Procedure insert_validate(p_rec in ota_tsr_shd.g_rec_type) is
1088: --
1089: l_proc varchar2(72) := g_package||'insert_validate';
1090: --
1091: Begin

Line 1106: Procedure update_validate(p_rec in ota_tsr_shd.g_rec_type) is

1102: --
1103: -- ----------------------------------------------------------------------------
1104: -- |---------------------------< update_validate >----------------------------|
1105: -- ----------------------------------------------------------------------------
1106: Procedure update_validate(p_rec in ota_tsr_shd.g_rec_type) is
1107: --
1108: l_proc varchar2(72) := g_package||'update_validate';
1109: --
1110: Begin

Line 1124: Procedure delete_validate(p_rec in ota_tsr_shd.g_rec_type) is

1120: --
1121: -- ----------------------------------------------------------------------------
1122: -- |---------------------------< delete_validate >----------------------------|
1123: -- ----------------------------------------------------------------------------
1124: Procedure delete_validate(p_rec in ota_tsr_shd.g_rec_type) is
1125: --
1126: l_proc varchar2(72) := g_package||'delete_validate';
1127: --
1128: Begin