49: hr_utility.set_location('Entering:'|| l_proc, 10);
50: --
51: -- Ensure that all the mandatory parameter are not null
52: --
53: hr_api.mandatory_arg_error
54: (p_api_name => l_proc
55: ,p_argument => 'resource_booking_id'
56: ,p_argument_value => p_resource_booking_id
57: );
76: close csr_sec_grp;
77: --
78: -- Set the security_group_id in CLIENT_INFO
79: --
80: hr_api.set_security_group_id
81: (p_security_group_id => l_security_group_id
82: );
83: --
84: -- Set the sessions legislation context in HR_SESSION_DATA
82: );
83: --
84: -- Set the sessions legislation context in HR_SESSION_DATA
85: --
86: hr_api.set_legislation_context(l_legislation_code);
87: end if;
88: --
89: hr_utility.set_location(' Leaving:'|| l_proc, 20);
90: --
120: hr_utility.set_location('Entering:'|| l_proc, 10);
121: --
122: -- Ensure that all the mandatory parameter are not null
123: --
124: hr_api.mandatory_arg_error
125: (p_api_name => l_proc
126: ,p_argument => 'resource_booking_id'
127: ,p_argument_value => p_resource_booking_id
128: );
126: ,p_argument => 'resource_booking_id'
127: ,p_argument_value => p_resource_booking_id
128: );
129: --
130: if ( nvl(ota_trb_bus.g_resource_booking_id, hr_api.g_number)
131: = p_resource_booking_id) then
132: --
133: -- The legislation code has already been found with a previous
134: -- call to this function. Just return the value in the global
202: begin
203: hr_utility.set_location('Entering:'||l_proc,10);
204: --
205: if ((p_rec.resource_booking_id is not null) and (
206: nvl(ota_trb_shd.g_old_rec.trb_information_category, hr_api.g_varchar2) <>
207: nvl(p_rec.trb_information_category, hr_api.g_varchar2) or
208: nvl(ota_trb_shd.g_old_rec.trb_information1, hr_api.g_varchar2) <>
209: nvl(p_rec.trb_information1, hr_api.g_varchar2) or
210: nvl(ota_trb_shd.g_old_rec.trb_information2, hr_api.g_varchar2) <>
203: hr_utility.set_location('Entering:'||l_proc,10);
204: --
205: if ((p_rec.resource_booking_id is not null) and (
206: nvl(ota_trb_shd.g_old_rec.trb_information_category, hr_api.g_varchar2) <>
207: nvl(p_rec.trb_information_category, hr_api.g_varchar2) or
208: nvl(ota_trb_shd.g_old_rec.trb_information1, hr_api.g_varchar2) <>
209: nvl(p_rec.trb_information1, hr_api.g_varchar2) or
210: nvl(ota_trb_shd.g_old_rec.trb_information2, hr_api.g_varchar2) <>
211: nvl(p_rec.trb_information2, hr_api.g_varchar2) or
204: --
205: if ((p_rec.resource_booking_id is not null) and (
206: nvl(ota_trb_shd.g_old_rec.trb_information_category, hr_api.g_varchar2) <>
207: nvl(p_rec.trb_information_category, hr_api.g_varchar2) or
208: nvl(ota_trb_shd.g_old_rec.trb_information1, hr_api.g_varchar2) <>
209: nvl(p_rec.trb_information1, hr_api.g_varchar2) or
210: nvl(ota_trb_shd.g_old_rec.trb_information2, hr_api.g_varchar2) <>
211: nvl(p_rec.trb_information2, hr_api.g_varchar2) or
212: nvl(ota_trb_shd.g_old_rec.trb_information3, hr_api.g_varchar2) <>
205: if ((p_rec.resource_booking_id is not null) and (
206: nvl(ota_trb_shd.g_old_rec.trb_information_category, hr_api.g_varchar2) <>
207: nvl(p_rec.trb_information_category, hr_api.g_varchar2) or
208: nvl(ota_trb_shd.g_old_rec.trb_information1, hr_api.g_varchar2) <>
209: nvl(p_rec.trb_information1, hr_api.g_varchar2) or
210: nvl(ota_trb_shd.g_old_rec.trb_information2, hr_api.g_varchar2) <>
211: nvl(p_rec.trb_information2, hr_api.g_varchar2) or
212: nvl(ota_trb_shd.g_old_rec.trb_information3, hr_api.g_varchar2) <>
213: nvl(p_rec.trb_information3, hr_api.g_varchar2) or
206: nvl(ota_trb_shd.g_old_rec.trb_information_category, hr_api.g_varchar2) <>
207: nvl(p_rec.trb_information_category, hr_api.g_varchar2) or
208: nvl(ota_trb_shd.g_old_rec.trb_information1, hr_api.g_varchar2) <>
209: nvl(p_rec.trb_information1, hr_api.g_varchar2) or
210: nvl(ota_trb_shd.g_old_rec.trb_information2, hr_api.g_varchar2) <>
211: nvl(p_rec.trb_information2, hr_api.g_varchar2) or
212: nvl(ota_trb_shd.g_old_rec.trb_information3, hr_api.g_varchar2) <>
213: nvl(p_rec.trb_information3, hr_api.g_varchar2) or
214: nvl(ota_trb_shd.g_old_rec.trb_information4, hr_api.g_varchar2) <>
207: nvl(p_rec.trb_information_category, hr_api.g_varchar2) or
208: nvl(ota_trb_shd.g_old_rec.trb_information1, hr_api.g_varchar2) <>
209: nvl(p_rec.trb_information1, hr_api.g_varchar2) or
210: nvl(ota_trb_shd.g_old_rec.trb_information2, hr_api.g_varchar2) <>
211: nvl(p_rec.trb_information2, hr_api.g_varchar2) or
212: nvl(ota_trb_shd.g_old_rec.trb_information3, hr_api.g_varchar2) <>
213: nvl(p_rec.trb_information3, hr_api.g_varchar2) or
214: nvl(ota_trb_shd.g_old_rec.trb_information4, hr_api.g_varchar2) <>
215: nvl(p_rec.trb_information4, hr_api.g_varchar2) or
208: nvl(ota_trb_shd.g_old_rec.trb_information1, hr_api.g_varchar2) <>
209: nvl(p_rec.trb_information1, hr_api.g_varchar2) or
210: nvl(ota_trb_shd.g_old_rec.trb_information2, hr_api.g_varchar2) <>
211: nvl(p_rec.trb_information2, hr_api.g_varchar2) or
212: nvl(ota_trb_shd.g_old_rec.trb_information3, hr_api.g_varchar2) <>
213: nvl(p_rec.trb_information3, hr_api.g_varchar2) or
214: nvl(ota_trb_shd.g_old_rec.trb_information4, hr_api.g_varchar2) <>
215: nvl(p_rec.trb_information4, hr_api.g_varchar2) or
216: nvl(ota_trb_shd.g_old_rec.trb_information5, hr_api.g_varchar2) <>
209: nvl(p_rec.trb_information1, hr_api.g_varchar2) or
210: nvl(ota_trb_shd.g_old_rec.trb_information2, hr_api.g_varchar2) <>
211: nvl(p_rec.trb_information2, hr_api.g_varchar2) or
212: nvl(ota_trb_shd.g_old_rec.trb_information3, hr_api.g_varchar2) <>
213: nvl(p_rec.trb_information3, hr_api.g_varchar2) or
214: nvl(ota_trb_shd.g_old_rec.trb_information4, hr_api.g_varchar2) <>
215: nvl(p_rec.trb_information4, hr_api.g_varchar2) or
216: nvl(ota_trb_shd.g_old_rec.trb_information5, hr_api.g_varchar2) <>
217: nvl(p_rec.trb_information5, hr_api.g_varchar2) or
210: nvl(ota_trb_shd.g_old_rec.trb_information2, hr_api.g_varchar2) <>
211: nvl(p_rec.trb_information2, hr_api.g_varchar2) or
212: nvl(ota_trb_shd.g_old_rec.trb_information3, hr_api.g_varchar2) <>
213: nvl(p_rec.trb_information3, hr_api.g_varchar2) or
214: nvl(ota_trb_shd.g_old_rec.trb_information4, hr_api.g_varchar2) <>
215: nvl(p_rec.trb_information4, hr_api.g_varchar2) or
216: nvl(ota_trb_shd.g_old_rec.trb_information5, hr_api.g_varchar2) <>
217: nvl(p_rec.trb_information5, hr_api.g_varchar2) or
218: nvl(ota_trb_shd.g_old_rec.trb_information6, hr_api.g_varchar2) <>
211: nvl(p_rec.trb_information2, hr_api.g_varchar2) or
212: nvl(ota_trb_shd.g_old_rec.trb_information3, hr_api.g_varchar2) <>
213: nvl(p_rec.trb_information3, hr_api.g_varchar2) or
214: nvl(ota_trb_shd.g_old_rec.trb_information4, hr_api.g_varchar2) <>
215: nvl(p_rec.trb_information4, hr_api.g_varchar2) or
216: nvl(ota_trb_shd.g_old_rec.trb_information5, hr_api.g_varchar2) <>
217: nvl(p_rec.trb_information5, hr_api.g_varchar2) or
218: nvl(ota_trb_shd.g_old_rec.trb_information6, hr_api.g_varchar2) <>
219: nvl(p_rec.trb_information6, hr_api.g_varchar2) or
212: nvl(ota_trb_shd.g_old_rec.trb_information3, hr_api.g_varchar2) <>
213: nvl(p_rec.trb_information3, hr_api.g_varchar2) or
214: nvl(ota_trb_shd.g_old_rec.trb_information4, hr_api.g_varchar2) <>
215: nvl(p_rec.trb_information4, hr_api.g_varchar2) or
216: nvl(ota_trb_shd.g_old_rec.trb_information5, hr_api.g_varchar2) <>
217: nvl(p_rec.trb_information5, hr_api.g_varchar2) or
218: nvl(ota_trb_shd.g_old_rec.trb_information6, hr_api.g_varchar2) <>
219: nvl(p_rec.trb_information6, hr_api.g_varchar2) or
220: nvl(ota_trb_shd.g_old_rec.trb_information7, hr_api.g_varchar2) <>
213: nvl(p_rec.trb_information3, hr_api.g_varchar2) or
214: nvl(ota_trb_shd.g_old_rec.trb_information4, hr_api.g_varchar2) <>
215: nvl(p_rec.trb_information4, hr_api.g_varchar2) or
216: nvl(ota_trb_shd.g_old_rec.trb_information5, hr_api.g_varchar2) <>
217: nvl(p_rec.trb_information5, hr_api.g_varchar2) or
218: nvl(ota_trb_shd.g_old_rec.trb_information6, hr_api.g_varchar2) <>
219: nvl(p_rec.trb_information6, hr_api.g_varchar2) or
220: nvl(ota_trb_shd.g_old_rec.trb_information7, hr_api.g_varchar2) <>
221: nvl(p_rec.trb_information7, hr_api.g_varchar2) or
214: nvl(ota_trb_shd.g_old_rec.trb_information4, hr_api.g_varchar2) <>
215: nvl(p_rec.trb_information4, hr_api.g_varchar2) or
216: nvl(ota_trb_shd.g_old_rec.trb_information5, hr_api.g_varchar2) <>
217: nvl(p_rec.trb_information5, hr_api.g_varchar2) or
218: nvl(ota_trb_shd.g_old_rec.trb_information6, hr_api.g_varchar2) <>
219: nvl(p_rec.trb_information6, hr_api.g_varchar2) or
220: nvl(ota_trb_shd.g_old_rec.trb_information7, hr_api.g_varchar2) <>
221: nvl(p_rec.trb_information7, hr_api.g_varchar2) or
222: nvl(ota_trb_shd.g_old_rec.trb_information8, hr_api.g_varchar2) <>
215: nvl(p_rec.trb_information4, hr_api.g_varchar2) or
216: nvl(ota_trb_shd.g_old_rec.trb_information5, hr_api.g_varchar2) <>
217: nvl(p_rec.trb_information5, hr_api.g_varchar2) or
218: nvl(ota_trb_shd.g_old_rec.trb_information6, hr_api.g_varchar2) <>
219: nvl(p_rec.trb_information6, hr_api.g_varchar2) or
220: nvl(ota_trb_shd.g_old_rec.trb_information7, hr_api.g_varchar2) <>
221: nvl(p_rec.trb_information7, hr_api.g_varchar2) or
222: nvl(ota_trb_shd.g_old_rec.trb_information8, hr_api.g_varchar2) <>
223: nvl(p_rec.trb_information8, hr_api.g_varchar2) or
216: nvl(ota_trb_shd.g_old_rec.trb_information5, hr_api.g_varchar2) <>
217: nvl(p_rec.trb_information5, hr_api.g_varchar2) or
218: nvl(ota_trb_shd.g_old_rec.trb_information6, hr_api.g_varchar2) <>
219: nvl(p_rec.trb_information6, hr_api.g_varchar2) or
220: nvl(ota_trb_shd.g_old_rec.trb_information7, hr_api.g_varchar2) <>
221: nvl(p_rec.trb_information7, hr_api.g_varchar2) or
222: nvl(ota_trb_shd.g_old_rec.trb_information8, hr_api.g_varchar2) <>
223: nvl(p_rec.trb_information8, hr_api.g_varchar2) or
224: nvl(ota_trb_shd.g_old_rec.trb_information9, hr_api.g_varchar2) <>
217: nvl(p_rec.trb_information5, hr_api.g_varchar2) or
218: nvl(ota_trb_shd.g_old_rec.trb_information6, hr_api.g_varchar2) <>
219: nvl(p_rec.trb_information6, hr_api.g_varchar2) or
220: nvl(ota_trb_shd.g_old_rec.trb_information7, hr_api.g_varchar2) <>
221: nvl(p_rec.trb_information7, hr_api.g_varchar2) or
222: nvl(ota_trb_shd.g_old_rec.trb_information8, hr_api.g_varchar2) <>
223: nvl(p_rec.trb_information8, hr_api.g_varchar2) or
224: nvl(ota_trb_shd.g_old_rec.trb_information9, hr_api.g_varchar2) <>
225: nvl(p_rec.trb_information9, hr_api.g_varchar2) or
218: nvl(ota_trb_shd.g_old_rec.trb_information6, hr_api.g_varchar2) <>
219: nvl(p_rec.trb_information6, hr_api.g_varchar2) or
220: nvl(ota_trb_shd.g_old_rec.trb_information7, hr_api.g_varchar2) <>
221: nvl(p_rec.trb_information7, hr_api.g_varchar2) or
222: nvl(ota_trb_shd.g_old_rec.trb_information8, hr_api.g_varchar2) <>
223: nvl(p_rec.trb_information8, hr_api.g_varchar2) or
224: nvl(ota_trb_shd.g_old_rec.trb_information9, hr_api.g_varchar2) <>
225: nvl(p_rec.trb_information9, hr_api.g_varchar2) or
226: nvl(ota_trb_shd.g_old_rec.trb_information10, hr_api.g_varchar2) <>
219: nvl(p_rec.trb_information6, hr_api.g_varchar2) or
220: nvl(ota_trb_shd.g_old_rec.trb_information7, hr_api.g_varchar2) <>
221: nvl(p_rec.trb_information7, hr_api.g_varchar2) or
222: nvl(ota_trb_shd.g_old_rec.trb_information8, hr_api.g_varchar2) <>
223: nvl(p_rec.trb_information8, hr_api.g_varchar2) or
224: nvl(ota_trb_shd.g_old_rec.trb_information9, hr_api.g_varchar2) <>
225: nvl(p_rec.trb_information9, hr_api.g_varchar2) or
226: nvl(ota_trb_shd.g_old_rec.trb_information10, hr_api.g_varchar2) <>
227: nvl(p_rec.trb_information10, hr_api.g_varchar2) or
220: nvl(ota_trb_shd.g_old_rec.trb_information7, hr_api.g_varchar2) <>
221: nvl(p_rec.trb_information7, hr_api.g_varchar2) or
222: nvl(ota_trb_shd.g_old_rec.trb_information8, hr_api.g_varchar2) <>
223: nvl(p_rec.trb_information8, hr_api.g_varchar2) or
224: nvl(ota_trb_shd.g_old_rec.trb_information9, hr_api.g_varchar2) <>
225: nvl(p_rec.trb_information9, hr_api.g_varchar2) or
226: nvl(ota_trb_shd.g_old_rec.trb_information10, hr_api.g_varchar2) <>
227: nvl(p_rec.trb_information10, hr_api.g_varchar2) or
228: nvl(ota_trb_shd.g_old_rec.trb_information11, hr_api.g_varchar2) <>
221: nvl(p_rec.trb_information7, hr_api.g_varchar2) or
222: nvl(ota_trb_shd.g_old_rec.trb_information8, hr_api.g_varchar2) <>
223: nvl(p_rec.trb_information8, hr_api.g_varchar2) or
224: nvl(ota_trb_shd.g_old_rec.trb_information9, hr_api.g_varchar2) <>
225: nvl(p_rec.trb_information9, hr_api.g_varchar2) or
226: nvl(ota_trb_shd.g_old_rec.trb_information10, hr_api.g_varchar2) <>
227: nvl(p_rec.trb_information10, hr_api.g_varchar2) or
228: nvl(ota_trb_shd.g_old_rec.trb_information11, hr_api.g_varchar2) <>
229: nvl(p_rec.trb_information11, hr_api.g_varchar2) or
222: nvl(ota_trb_shd.g_old_rec.trb_information8, hr_api.g_varchar2) <>
223: nvl(p_rec.trb_information8, hr_api.g_varchar2) or
224: nvl(ota_trb_shd.g_old_rec.trb_information9, hr_api.g_varchar2) <>
225: nvl(p_rec.trb_information9, hr_api.g_varchar2) or
226: nvl(ota_trb_shd.g_old_rec.trb_information10, hr_api.g_varchar2) <>
227: nvl(p_rec.trb_information10, hr_api.g_varchar2) or
228: nvl(ota_trb_shd.g_old_rec.trb_information11, hr_api.g_varchar2) <>
229: nvl(p_rec.trb_information11, hr_api.g_varchar2) or
230: nvl(ota_trb_shd.g_old_rec.trb_information12, hr_api.g_varchar2) <>
223: nvl(p_rec.trb_information8, hr_api.g_varchar2) or
224: nvl(ota_trb_shd.g_old_rec.trb_information9, hr_api.g_varchar2) <>
225: nvl(p_rec.trb_information9, hr_api.g_varchar2) or
226: nvl(ota_trb_shd.g_old_rec.trb_information10, hr_api.g_varchar2) <>
227: nvl(p_rec.trb_information10, hr_api.g_varchar2) or
228: nvl(ota_trb_shd.g_old_rec.trb_information11, hr_api.g_varchar2) <>
229: nvl(p_rec.trb_information11, hr_api.g_varchar2) or
230: nvl(ota_trb_shd.g_old_rec.trb_information12, hr_api.g_varchar2) <>
231: nvl(p_rec.trb_information12, hr_api.g_varchar2) or
224: nvl(ota_trb_shd.g_old_rec.trb_information9, hr_api.g_varchar2) <>
225: nvl(p_rec.trb_information9, hr_api.g_varchar2) or
226: nvl(ota_trb_shd.g_old_rec.trb_information10, hr_api.g_varchar2) <>
227: nvl(p_rec.trb_information10, hr_api.g_varchar2) or
228: nvl(ota_trb_shd.g_old_rec.trb_information11, hr_api.g_varchar2) <>
229: nvl(p_rec.trb_information11, hr_api.g_varchar2) or
230: nvl(ota_trb_shd.g_old_rec.trb_information12, hr_api.g_varchar2) <>
231: nvl(p_rec.trb_information12, hr_api.g_varchar2) or
232: nvl(ota_trb_shd.g_old_rec.trb_information13, hr_api.g_varchar2) <>
225: nvl(p_rec.trb_information9, hr_api.g_varchar2) or
226: nvl(ota_trb_shd.g_old_rec.trb_information10, hr_api.g_varchar2) <>
227: nvl(p_rec.trb_information10, hr_api.g_varchar2) or
228: nvl(ota_trb_shd.g_old_rec.trb_information11, hr_api.g_varchar2) <>
229: nvl(p_rec.trb_information11, hr_api.g_varchar2) or
230: nvl(ota_trb_shd.g_old_rec.trb_information12, hr_api.g_varchar2) <>
231: nvl(p_rec.trb_information12, hr_api.g_varchar2) or
232: nvl(ota_trb_shd.g_old_rec.trb_information13, hr_api.g_varchar2) <>
233: nvl(p_rec.trb_information13, hr_api.g_varchar2) or
226: nvl(ota_trb_shd.g_old_rec.trb_information10, hr_api.g_varchar2) <>
227: nvl(p_rec.trb_information10, hr_api.g_varchar2) or
228: nvl(ota_trb_shd.g_old_rec.trb_information11, hr_api.g_varchar2) <>
229: nvl(p_rec.trb_information11, hr_api.g_varchar2) or
230: nvl(ota_trb_shd.g_old_rec.trb_information12, hr_api.g_varchar2) <>
231: nvl(p_rec.trb_information12, hr_api.g_varchar2) or
232: nvl(ota_trb_shd.g_old_rec.trb_information13, hr_api.g_varchar2) <>
233: nvl(p_rec.trb_information13, hr_api.g_varchar2) or
234: nvl(ota_trb_shd.g_old_rec.trb_information14, hr_api.g_varchar2) <>
227: nvl(p_rec.trb_information10, hr_api.g_varchar2) or
228: nvl(ota_trb_shd.g_old_rec.trb_information11, hr_api.g_varchar2) <>
229: nvl(p_rec.trb_information11, hr_api.g_varchar2) or
230: nvl(ota_trb_shd.g_old_rec.trb_information12, hr_api.g_varchar2) <>
231: nvl(p_rec.trb_information12, hr_api.g_varchar2) or
232: nvl(ota_trb_shd.g_old_rec.trb_information13, hr_api.g_varchar2) <>
233: nvl(p_rec.trb_information13, hr_api.g_varchar2) or
234: nvl(ota_trb_shd.g_old_rec.trb_information14, hr_api.g_varchar2) <>
235: nvl(p_rec.trb_information14, hr_api.g_varchar2) or
228: nvl(ota_trb_shd.g_old_rec.trb_information11, hr_api.g_varchar2) <>
229: nvl(p_rec.trb_information11, hr_api.g_varchar2) or
230: nvl(ota_trb_shd.g_old_rec.trb_information12, hr_api.g_varchar2) <>
231: nvl(p_rec.trb_information12, hr_api.g_varchar2) or
232: nvl(ota_trb_shd.g_old_rec.trb_information13, hr_api.g_varchar2) <>
233: nvl(p_rec.trb_information13, hr_api.g_varchar2) or
234: nvl(ota_trb_shd.g_old_rec.trb_information14, hr_api.g_varchar2) <>
235: nvl(p_rec.trb_information14, hr_api.g_varchar2) or
236: nvl(ota_trb_shd.g_old_rec.trb_information15, hr_api.g_varchar2) <>
229: nvl(p_rec.trb_information11, hr_api.g_varchar2) or
230: nvl(ota_trb_shd.g_old_rec.trb_information12, hr_api.g_varchar2) <>
231: nvl(p_rec.trb_information12, hr_api.g_varchar2) or
232: nvl(ota_trb_shd.g_old_rec.trb_information13, hr_api.g_varchar2) <>
233: nvl(p_rec.trb_information13, hr_api.g_varchar2) or
234: nvl(ota_trb_shd.g_old_rec.trb_information14, hr_api.g_varchar2) <>
235: nvl(p_rec.trb_information14, hr_api.g_varchar2) or
236: nvl(ota_trb_shd.g_old_rec.trb_information15, hr_api.g_varchar2) <>
237: nvl(p_rec.trb_information15, hr_api.g_varchar2) or
230: nvl(ota_trb_shd.g_old_rec.trb_information12, hr_api.g_varchar2) <>
231: nvl(p_rec.trb_information12, hr_api.g_varchar2) or
232: nvl(ota_trb_shd.g_old_rec.trb_information13, hr_api.g_varchar2) <>
233: nvl(p_rec.trb_information13, hr_api.g_varchar2) or
234: nvl(ota_trb_shd.g_old_rec.trb_information14, hr_api.g_varchar2) <>
235: nvl(p_rec.trb_information14, hr_api.g_varchar2) or
236: nvl(ota_trb_shd.g_old_rec.trb_information15, hr_api.g_varchar2) <>
237: nvl(p_rec.trb_information15, hr_api.g_varchar2) or
238: nvl(ota_trb_shd.g_old_rec.trb_information16, hr_api.g_varchar2) <>
231: nvl(p_rec.trb_information12, hr_api.g_varchar2) or
232: nvl(ota_trb_shd.g_old_rec.trb_information13, hr_api.g_varchar2) <>
233: nvl(p_rec.trb_information13, hr_api.g_varchar2) or
234: nvl(ota_trb_shd.g_old_rec.trb_information14, hr_api.g_varchar2) <>
235: nvl(p_rec.trb_information14, hr_api.g_varchar2) or
236: nvl(ota_trb_shd.g_old_rec.trb_information15, hr_api.g_varchar2) <>
237: nvl(p_rec.trb_information15, hr_api.g_varchar2) or
238: nvl(ota_trb_shd.g_old_rec.trb_information16, hr_api.g_varchar2) <>
239: nvl(p_rec.trb_information16, hr_api.g_varchar2) or
232: nvl(ota_trb_shd.g_old_rec.trb_information13, hr_api.g_varchar2) <>
233: nvl(p_rec.trb_information13, hr_api.g_varchar2) or
234: nvl(ota_trb_shd.g_old_rec.trb_information14, hr_api.g_varchar2) <>
235: nvl(p_rec.trb_information14, hr_api.g_varchar2) or
236: nvl(ota_trb_shd.g_old_rec.trb_information15, hr_api.g_varchar2) <>
237: nvl(p_rec.trb_information15, hr_api.g_varchar2) or
238: nvl(ota_trb_shd.g_old_rec.trb_information16, hr_api.g_varchar2) <>
239: nvl(p_rec.trb_information16, hr_api.g_varchar2) or
240: nvl(ota_trb_shd.g_old_rec.trb_information17, hr_api.g_varchar2) <>
233: nvl(p_rec.trb_information13, hr_api.g_varchar2) or
234: nvl(ota_trb_shd.g_old_rec.trb_information14, hr_api.g_varchar2) <>
235: nvl(p_rec.trb_information14, hr_api.g_varchar2) or
236: nvl(ota_trb_shd.g_old_rec.trb_information15, hr_api.g_varchar2) <>
237: nvl(p_rec.trb_information15, hr_api.g_varchar2) or
238: nvl(ota_trb_shd.g_old_rec.trb_information16, hr_api.g_varchar2) <>
239: nvl(p_rec.trb_information16, hr_api.g_varchar2) or
240: nvl(ota_trb_shd.g_old_rec.trb_information17, hr_api.g_varchar2) <>
241: nvl(p_rec.trb_information17, hr_api.g_varchar2) or
234: nvl(ota_trb_shd.g_old_rec.trb_information14, hr_api.g_varchar2) <>
235: nvl(p_rec.trb_information14, hr_api.g_varchar2) or
236: nvl(ota_trb_shd.g_old_rec.trb_information15, hr_api.g_varchar2) <>
237: nvl(p_rec.trb_information15, hr_api.g_varchar2) or
238: nvl(ota_trb_shd.g_old_rec.trb_information16, hr_api.g_varchar2) <>
239: nvl(p_rec.trb_information16, hr_api.g_varchar2) or
240: nvl(ota_trb_shd.g_old_rec.trb_information17, hr_api.g_varchar2) <>
241: nvl(p_rec.trb_information17, hr_api.g_varchar2) or
242: nvl(ota_trb_shd.g_old_rec.trb_information18, hr_api.g_varchar2) <>
235: nvl(p_rec.trb_information14, hr_api.g_varchar2) or
236: nvl(ota_trb_shd.g_old_rec.trb_information15, hr_api.g_varchar2) <>
237: nvl(p_rec.trb_information15, hr_api.g_varchar2) or
238: nvl(ota_trb_shd.g_old_rec.trb_information16, hr_api.g_varchar2) <>
239: nvl(p_rec.trb_information16, hr_api.g_varchar2) or
240: nvl(ota_trb_shd.g_old_rec.trb_information17, hr_api.g_varchar2) <>
241: nvl(p_rec.trb_information17, hr_api.g_varchar2) or
242: nvl(ota_trb_shd.g_old_rec.trb_information18, hr_api.g_varchar2) <>
243: nvl(p_rec.trb_information18, hr_api.g_varchar2) or
236: nvl(ota_trb_shd.g_old_rec.trb_information15, hr_api.g_varchar2) <>
237: nvl(p_rec.trb_information15, hr_api.g_varchar2) or
238: nvl(ota_trb_shd.g_old_rec.trb_information16, hr_api.g_varchar2) <>
239: nvl(p_rec.trb_information16, hr_api.g_varchar2) or
240: nvl(ota_trb_shd.g_old_rec.trb_information17, hr_api.g_varchar2) <>
241: nvl(p_rec.trb_information17, hr_api.g_varchar2) or
242: nvl(ota_trb_shd.g_old_rec.trb_information18, hr_api.g_varchar2) <>
243: nvl(p_rec.trb_information18, hr_api.g_varchar2) or
244: nvl(ota_trb_shd.g_old_rec.trb_information19, hr_api.g_varchar2) <>
237: nvl(p_rec.trb_information15, hr_api.g_varchar2) or
238: nvl(ota_trb_shd.g_old_rec.trb_information16, hr_api.g_varchar2) <>
239: nvl(p_rec.trb_information16, hr_api.g_varchar2) or
240: nvl(ota_trb_shd.g_old_rec.trb_information17, hr_api.g_varchar2) <>
241: nvl(p_rec.trb_information17, hr_api.g_varchar2) or
242: nvl(ota_trb_shd.g_old_rec.trb_information18, hr_api.g_varchar2) <>
243: nvl(p_rec.trb_information18, hr_api.g_varchar2) or
244: nvl(ota_trb_shd.g_old_rec.trb_information19, hr_api.g_varchar2) <>
245: nvl(p_rec.trb_information19, hr_api.g_varchar2) or
238: nvl(ota_trb_shd.g_old_rec.trb_information16, hr_api.g_varchar2) <>
239: nvl(p_rec.trb_information16, hr_api.g_varchar2) or
240: nvl(ota_trb_shd.g_old_rec.trb_information17, hr_api.g_varchar2) <>
241: nvl(p_rec.trb_information17, hr_api.g_varchar2) or
242: nvl(ota_trb_shd.g_old_rec.trb_information18, hr_api.g_varchar2) <>
243: nvl(p_rec.trb_information18, hr_api.g_varchar2) or
244: nvl(ota_trb_shd.g_old_rec.trb_information19, hr_api.g_varchar2) <>
245: nvl(p_rec.trb_information19, hr_api.g_varchar2) or
246: nvl(ota_trb_shd.g_old_rec.trb_information20, hr_api.g_varchar2) <>
239: nvl(p_rec.trb_information16, hr_api.g_varchar2) or
240: nvl(ota_trb_shd.g_old_rec.trb_information17, hr_api.g_varchar2) <>
241: nvl(p_rec.trb_information17, hr_api.g_varchar2) or
242: nvl(ota_trb_shd.g_old_rec.trb_information18, hr_api.g_varchar2) <>
243: nvl(p_rec.trb_information18, hr_api.g_varchar2) or
244: nvl(ota_trb_shd.g_old_rec.trb_information19, hr_api.g_varchar2) <>
245: nvl(p_rec.trb_information19, hr_api.g_varchar2) or
246: nvl(ota_trb_shd.g_old_rec.trb_information20, hr_api.g_varchar2) <>
247: nvl(p_rec.trb_information20, hr_api.g_varchar2) ))
240: nvl(ota_trb_shd.g_old_rec.trb_information17, hr_api.g_varchar2) <>
241: nvl(p_rec.trb_information17, hr_api.g_varchar2) or
242: nvl(ota_trb_shd.g_old_rec.trb_information18, hr_api.g_varchar2) <>
243: nvl(p_rec.trb_information18, hr_api.g_varchar2) or
244: nvl(ota_trb_shd.g_old_rec.trb_information19, hr_api.g_varchar2) <>
245: nvl(p_rec.trb_information19, hr_api.g_varchar2) or
246: nvl(ota_trb_shd.g_old_rec.trb_information20, hr_api.g_varchar2) <>
247: nvl(p_rec.trb_information20, hr_api.g_varchar2) ))
248: or (p_rec.resource_booking_id is null) then
241: nvl(p_rec.trb_information17, hr_api.g_varchar2) or
242: nvl(ota_trb_shd.g_old_rec.trb_information18, hr_api.g_varchar2) <>
243: nvl(p_rec.trb_information18, hr_api.g_varchar2) or
244: nvl(ota_trb_shd.g_old_rec.trb_information19, hr_api.g_varchar2) <>
245: nvl(p_rec.trb_information19, hr_api.g_varchar2) or
246: nvl(ota_trb_shd.g_old_rec.trb_information20, hr_api.g_varchar2) <>
247: nvl(p_rec.trb_information20, hr_api.g_varchar2) ))
248: or (p_rec.resource_booking_id is null) then
249: --
242: nvl(ota_trb_shd.g_old_rec.trb_information18, hr_api.g_varchar2) <>
243: nvl(p_rec.trb_information18, hr_api.g_varchar2) or
244: nvl(ota_trb_shd.g_old_rec.trb_information19, hr_api.g_varchar2) <>
245: nvl(p_rec.trb_information19, hr_api.g_varchar2) or
246: nvl(ota_trb_shd.g_old_rec.trb_information20, hr_api.g_varchar2) <>
247: nvl(p_rec.trb_information20, hr_api.g_varchar2) ))
248: or (p_rec.resource_booking_id is null) then
249: --
250: -- Only execute the validation if absolutely necessary:
243: nvl(p_rec.trb_information18, hr_api.g_varchar2) or
244: nvl(ota_trb_shd.g_old_rec.trb_information19, hr_api.g_varchar2) <>
245: nvl(p_rec.trb_information19, hr_api.g_varchar2) or
246: nvl(ota_trb_shd.g_old_rec.trb_information20, hr_api.g_varchar2) <>
247: nvl(p_rec.trb_information20, hr_api.g_varchar2) ))
248: or (p_rec.resource_booking_id is null) then
249: --
250: -- Only execute the validation if absolutely necessary:
251: -- a) During update, the structure column value or any
814: check_res_bkng_time(p_rec.required_start_time
815: ,p_rec.required_end_time
816: ,p_rec.book_entire_period_flag);
817:
818: IF p_rec.timezone_code <> hr_api.g_varchar2 THEN
819: check_timezone(p_rec.timezone_code);
820: END IF;
821:
822: --