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 783: nvl(ota_tsr_shd.g_old_rec.trainer_id,hr_api.g_number) <>

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

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

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

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

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

Line 852: (p_rec IN ota_tsr_shd.g_rec_type

848: -- Internal Row Handler Use Only.
849: --
850: -- ----------------------------------------------------------------------------
851: PROCEDURE chk_df
852: (p_rec IN ota_tsr_shd.g_rec_type
853: ) IS
854: --
855: l_proc varchar2(72) := g_package || 'chk_df';
856: --

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

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

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

859: --
860: IF ((p_rec.supplied_resource_id IS NOT NULL) AND (
861: NVL(ota_tsr_shd.g_old_rec.tsr_information_category, hr_api.g_varchar2) <>
862: NVL(p_rec.tsr_information_category, hr_api.g_varchar2) OR
863: NVL(ota_tsr_shd.g_old_rec.tsr_information1, hr_api.g_varchar2) <>
864: NVL(p_rec.tsr_information1, hr_api.g_varchar2) OR
865: NVL(ota_tsr_shd.g_old_rec.tsr_information2, hr_api.g_varchar2) <>
866: NVL(p_rec.tsr_information2, hr_api.g_varchar2) OR
867: NVL(ota_tsr_shd.g_old_rec.tsr_information3, hr_api.g_varchar2) <>

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

861: NVL(ota_tsr_shd.g_old_rec.tsr_information_category, hr_api.g_varchar2) <>
862: NVL(p_rec.tsr_information_category, hr_api.g_varchar2) OR
863: NVL(ota_tsr_shd.g_old_rec.tsr_information1, hr_api.g_varchar2) <>
864: NVL(p_rec.tsr_information1, hr_api.g_varchar2) OR
865: NVL(ota_tsr_shd.g_old_rec.tsr_information2, hr_api.g_varchar2) <>
866: NVL(p_rec.tsr_information2, hr_api.g_varchar2) OR
867: NVL(ota_tsr_shd.g_old_rec.tsr_information3, hr_api.g_varchar2) <>
868: NVL(p_rec.tsr_information3, hr_api.g_varchar2) OR
869: NVL(ota_tsr_shd.g_old_rec.tsr_information4, hr_api.g_varchar2) <>

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

895: NVL(ota_tsr_shd.g_old_rec.tsr_information17, hr_api.g_varchar2) <>
896: NVL(p_rec.tsr_information17, hr_api.g_varchar2) OR
897: NVL(ota_tsr_shd.g_old_rec.tsr_information18, hr_api.g_varchar2) <>
898: NVL(p_rec.tsr_information18, hr_api.g_varchar2) OR
899: NVL(ota_tsr_shd.g_old_rec.tsr_information19, hr_api.g_varchar2) <>
900: NVL(p_rec.tsr_information19, hr_api.g_varchar2) OR
901: NVL(ota_tsr_shd.g_old_rec.tsr_information20, hr_api.g_varchar2) <>
902: NVL(p_rec.tsr_information20, hr_api.g_varchar2) ) )
903: OR (p_rec.supplied_resource_id IS NULL) THEN

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

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

Line 970: p_rec in ota_tsr_shd.g_rec_type

966: -- GENERAL VALIDATION PROCEDURES
967: --*****************************************************************************
968: procedure validation1
969: (
970: p_rec in ota_tsr_shd.g_rec_type
971: )
972: is
973: ---------------------
974: begin

Line 1011: p_rec in ota_tsr_shd.g_rec_type

1007: --=============================================================================
1008: --=============================================================================
1009: procedure validation2
1010: (
1011: p_rec in ota_tsr_shd.g_rec_type
1012: )
1013: is
1014: ---------------------
1015: begin

Line 1026: p_rec in ota_tsr_shd.g_rec_type

1022: --=============================================================================
1023: --=============================================================================
1024: procedure insert_validate2
1025: (
1026: p_rec in ota_tsr_shd.g_rec_type
1027: )
1028: is
1029: ---------------------
1030: begin

Line 1041: p_rec in ota_tsr_shd.g_rec_type

1037: --=============================================================================
1038: --=============================================================================
1039: procedure update_validate2
1040: (
1041: p_rec in ota_tsr_shd.g_rec_type
1042: )
1043: is
1044: ---------------------
1045: begin

Line 1066: p_rec in ota_tsr_shd.g_rec_type

1062: --=============================================================================
1063: --=============================================================================
1064: procedure delete_validate2
1065: (
1066: p_rec in ota_tsr_shd.g_rec_type
1067: )
1068: is
1069: ---------------------
1070: begin

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

1079: --*****************************************************************************
1080: -- ----------------------------------------------------------------------------
1081: -- |---------------------------< insert_validate >----------------------------|
1082: -- ----------------------------------------------------------------------------
1083: Procedure insert_validate(p_rec in ota_tsr_shd.g_rec_type) is
1084: --
1085: l_proc varchar2(72) := g_package||'insert_validate';
1086: --
1087: Begin

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

1098: --
1099: -- ----------------------------------------------------------------------------
1100: -- |---------------------------< update_validate >----------------------------|
1101: -- ----------------------------------------------------------------------------
1102: Procedure update_validate(p_rec in ota_tsr_shd.g_rec_type) is
1103: --
1104: l_proc varchar2(72) := g_package||'update_validate';
1105: --
1106: Begin

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

1116: --
1117: -- ----------------------------------------------------------------------------
1118: -- |---------------------------< delete_validate >----------------------------|
1119: -- ----------------------------------------------------------------------------
1120: Procedure delete_validate(p_rec in ota_tsr_shd.g_rec_type) is
1121: --
1122: l_proc varchar2(72) := g_package||'delete_validate';
1123: --
1124: Begin