68: hr_utility.set_location('Entering:'|| l_proc, 10);
69: --
70: -- Ensure that all the mandatory parameter are not null
71: --
72: hr_api.mandatory_arg_error
73: (p_api_name => l_proc
74: ,p_argument => 'supplied_resource_id'
75: ,p_argument_value => p_supplied_resource_id
76: );
95: close csr_sec_grp;
96: --
97: -- Set the security_group_id in CLIENT_INFO
98: --
99: hr_api.set_security_group_id
100: (p_security_group_id => l_security_group_id
101: );
102: --
103: -- Set the sessions legislation context in HR_SESSION_DATA
101: );
102: --
103: -- Set the sessions legislation context in HR_SESSION_DATA
104: --
105: hr_api.set_legislation_context(l_legislation_code);
106: end if;
107: --
108: hr_utility.set_location(' Leaving:'|| l_proc, 20);
109: --
254: l_dummy integer;
255: --
256: procedure chkp is
257: begin
258: hr_api.mandatory_arg_error(g_package,'business_group',p_biz);
259: end chkp;
260: -----------------
261: begin
262: --
399: select 'X'
400: from ota_resource_usages
401: where supplied_resource_id = p_supplied_resource_id
402: and (start_date < p_start_date or
403: nvl(end_date, hr_api.g_eot) > nvl(p_end_date, hr_api.g_eot));
404: --
405: l_proc varchar2(72) := g_package||'check_usage_dates';
406: l_dummy varchar2(1);
407: --
436: from ota_resource_bookings
437: where supplied_resource_id = p_supplied_resource_id
438: and (required_date_from < p_start_date
439: or
440: nvl(required_date_to,hr_api.g_eot) > nvl(p_end_date,hr_api.g_eot));
441: --
442: l_proc varchar2(72) := g_package||'check_booking_dates';
443: l_dummy varchar2(1);
444: --
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);
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);
649: if (p_training_center_id is not null) then
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);
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);
699: if (p_location_id is not null) then
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
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
788: nvl(ota_tsr_shd.g_old_rec.end_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
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
791: --
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);
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);
793: if (p_trainer_id is not null) then
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) <>
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) <>
866: NVL(p_rec.tsr_information2, hr_api.g_varchar2) OR
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) <>
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) <>
868: NVL(p_rec.tsr_information3, hr_api.g_varchar2) OR
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) <>
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) <>
870: NVL(p_rec.tsr_information4, 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) <>
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) <>
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) <>
872: NVL(p_rec.tsr_information5, 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) <>
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) <>
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) <>
874: NVL(p_rec.tsr_information6, 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) <>
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) <>
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) <>
876: NVL(p_rec.tsr_information7, 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) <>
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) <>
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) <>
878: NVL(p_rec.tsr_information8, 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) <>
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) <>
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) <>
880: NVL(p_rec.tsr_information9, 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) <>
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) <>
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) <>
882: NVL(p_rec.tsr_information10, 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) <>
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) <>
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) <>
884: NVL(p_rec.tsr_information11, 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) <>
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) <>
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) <>
886: NVL(p_rec.tsr_information12, 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) <>
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) <>
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) <>
888: NVL(p_rec.tsr_information13, 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) <>
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) <>
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) <>
890: NVL(p_rec.tsr_information14, 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) <>
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) <>
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) <>
892: NVL(p_rec.tsr_information15, 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) <>
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) <>
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) <>
894: NVL(p_rec.tsr_information16, 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) <>
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) <>
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) <>
896: NVL(p_rec.tsr_information17, 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) <>
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) <>
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) <>
898: NVL(p_rec.tsr_information18, 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) <>
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) <>
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) <>
900: NVL(p_rec.tsr_information19, 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) <>
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) <>
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) <>
902: NVL(p_rec.tsr_information20, 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
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
904: --
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:
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:
906: -- a) During update, the structure column value or any
1089: --
1090: -- Call all supporting business operations
1091: insert_validate2(p_rec);
1092: --
1093: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
1094: --
1095: ota_tsr_bus.chk_df(p_rec);
1096: hr_utility.set_location(' Leaving:'||l_proc, 10);
1097: End insert_validate;
1108: --
1109: -- Call all supporting business operations
1110: update_validate2(p_rec);
1111: --
1112: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
1113: --
1114: hr_utility.set_location(' Leaving:'||l_proc, 10);
1115: End update_validate;
1116: --
1183: hr_utility.set_location('Entering:'||l_proc, 5);
1184: --
1185: -- Ensure that all the mandatory parameters are not null
1186: --
1187: hr_api.mandatory_arg_error (p_api_name => l_proc,
1188: p_argument => 'supplied_resource_id',
1189: p_argument_value => p_supplied_resource_id);
1190: open csr_leg_code;
1191: fetch csr_leg_code into l_legislation_code;