APPS.OTA_TRB_BUS dependencies on HR_API

Line 53: hr_api.mandatory_arg_error

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: );

Line 80: hr_api.set_security_group_id

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

Line 86: hr_api.set_legislation_context(l_legislation_code);

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: --

Line 124: hr_api.mandatory_arg_error

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: );

Line 130: if ( nvl(ota_trb_bus.g_resource_booking_id, hr_api.g_number)

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

Line 206: nvl(ota_trb_shd.g_old_rec.trb_information_category, hr_api.g_varchar2) <>

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) <>

Line 207: nvl(p_rec.trb_information_category, hr_api.g_varchar2) or

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

Line 208: nvl(ota_trb_shd.g_old_rec.trb_information1, hr_api.g_varchar2) <>

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) <>

Line 209: nvl(p_rec.trb_information1, hr_api.g_varchar2) or

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

Line 210: nvl(ota_trb_shd.g_old_rec.trb_information2, hr_api.g_varchar2) <>

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) <>

Line 211: nvl(p_rec.trb_information2, hr_api.g_varchar2) or

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

Line 212: nvl(ota_trb_shd.g_old_rec.trb_information3, hr_api.g_varchar2) <>

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) <>

Line 213: nvl(p_rec.trb_information3, hr_api.g_varchar2) or

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

Line 214: nvl(ota_trb_shd.g_old_rec.trb_information4, hr_api.g_varchar2) <>

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) <>

Line 215: nvl(p_rec.trb_information4, hr_api.g_varchar2) or

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

Line 216: nvl(ota_trb_shd.g_old_rec.trb_information5, hr_api.g_varchar2) <>

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) <>

Line 217: nvl(p_rec.trb_information5, hr_api.g_varchar2) or

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

Line 218: nvl(ota_trb_shd.g_old_rec.trb_information6, hr_api.g_varchar2) <>

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) <>

Line 219: nvl(p_rec.trb_information6, hr_api.g_varchar2) or

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

Line 220: nvl(ota_trb_shd.g_old_rec.trb_information7, hr_api.g_varchar2) <>

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) <>

Line 221: nvl(p_rec.trb_information7, hr_api.g_varchar2) or

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

Line 222: nvl(ota_trb_shd.g_old_rec.trb_information8, hr_api.g_varchar2) <>

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) <>

Line 223: nvl(p_rec.trb_information8, hr_api.g_varchar2) or

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

Line 224: nvl(ota_trb_shd.g_old_rec.trb_information9, hr_api.g_varchar2) <>

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) <>

Line 225: nvl(p_rec.trb_information9, hr_api.g_varchar2) or

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

Line 226: nvl(ota_trb_shd.g_old_rec.trb_information10, hr_api.g_varchar2) <>

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) <>

Line 227: nvl(p_rec.trb_information10, hr_api.g_varchar2) or

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

Line 228: nvl(ota_trb_shd.g_old_rec.trb_information11, hr_api.g_varchar2) <>

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) <>

Line 229: nvl(p_rec.trb_information11, hr_api.g_varchar2) or

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

Line 230: nvl(ota_trb_shd.g_old_rec.trb_information12, hr_api.g_varchar2) <>

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) <>

Line 231: nvl(p_rec.trb_information12, hr_api.g_varchar2) or

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

Line 232: nvl(ota_trb_shd.g_old_rec.trb_information13, hr_api.g_varchar2) <>

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) <>

Line 233: nvl(p_rec.trb_information13, hr_api.g_varchar2) or

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

Line 234: nvl(ota_trb_shd.g_old_rec.trb_information14, hr_api.g_varchar2) <>

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) <>

Line 235: nvl(p_rec.trb_information14, hr_api.g_varchar2) or

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

Line 236: nvl(ota_trb_shd.g_old_rec.trb_information15, hr_api.g_varchar2) <>

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) <>

Line 237: nvl(p_rec.trb_information15, hr_api.g_varchar2) or

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

Line 238: nvl(ota_trb_shd.g_old_rec.trb_information16, hr_api.g_varchar2) <>

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) <>

Line 239: nvl(p_rec.trb_information16, hr_api.g_varchar2) or

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

Line 240: nvl(ota_trb_shd.g_old_rec.trb_information17, hr_api.g_varchar2) <>

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) <>

Line 241: nvl(p_rec.trb_information17, hr_api.g_varchar2) or

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

Line 242: nvl(ota_trb_shd.g_old_rec.trb_information18, hr_api.g_varchar2) <>

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) <>

Line 243: nvl(p_rec.trb_information18, hr_api.g_varchar2) or

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) ))

Line 244: nvl(ota_trb_shd.g_old_rec.trb_information19, 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

Line 245: nvl(p_rec.trb_information19, hr_api.g_varchar2) or

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: --

Line 246: nvl(ota_trb_shd.g_old_rec.trb_information20, hr_api.g_varchar2) <>

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:

Line 247: nvl(p_rec.trb_information20, 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:
251: -- a) During update, the structure column value or any

Line 818: IF p_rec.timezone_code <> hr_api.g_varchar2 THEN

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: --