APPS.OTA_LCI_BUS dependencies on HR_API

Line 54: hr_api.mandatory_arg_error

50: hr_utility.set_location('Entering:'|| l_proc, 10);
51: --
52: -- Ensure that all the mandatory parameter are not null
53: --
54: hr_api.mandatory_arg_error
55: (p_api_name => l_proc
56: ,p_argument => 'learning_path_id'
57: ,p_argument_value => p_learning_path_id
58: );

Line 59: hr_api.mandatory_arg_error

55: (p_api_name => l_proc
56: ,p_argument => 'learning_path_id'
57: ,p_argument_value => p_learning_path_id
58: );
59: hr_api.mandatory_arg_error
60: (p_api_name => l_proc
61: ,p_argument => 'category_usage_id'
62: ,p_argument_value => p_category_usage_id
63: );

Line 88: hr_api.set_security_group_id

84: close csr_sec_grp;
85: --
86: -- Set the security_group_id in CLIENT_INFO
87: --
88: hr_api.set_security_group_id
89: (p_security_group_id => l_security_group_id
90: );
91: --
92: -- Set the sessions legislation context in HR_SESSION_DATA

Line 94: hr_api.set_legislation_context(l_legislation_code);

90: );
91: --
92: -- Set the sessions legislation context in HR_SESSION_DATA
93: --
94: hr_api.set_legislation_context(l_legislation_code);
95: end if;
96: --
97: hr_utility.set_location(' Leaving:'|| l_proc, 20);
98: --

Line 134: hr_api.mandatory_arg_error

130: hr_utility.set_location('Entering:'|| l_proc, 10);
131: --
132: -- Ensure that all the mandatory parameter are not null
133: --
134: hr_api.mandatory_arg_error
135: (p_api_name => l_proc
136: ,p_argument => 'learning_path_id'
137: ,p_argument_value => p_learning_path_id
138: );

Line 139: hr_api.mandatory_arg_error

135: (p_api_name => l_proc
136: ,p_argument => 'learning_path_id'
137: ,p_argument_value => p_learning_path_id
138: );
139: hr_api.mandatory_arg_error
140: (p_api_name => l_proc
141: ,p_argument => 'category_usage_id'
142: ,p_argument_value => p_category_usage_id
143: );

Line 145: if (( nvl(ota_lci_bus.g_learning_path_id, hr_api.g_number)

141: ,p_argument => 'category_usage_id'
142: ,p_argument_value => p_category_usage_id
143: );
144: --
145: if (( nvl(ota_lci_bus.g_learning_path_id, hr_api.g_number)
146: = p_learning_path_id)
147: and ( nvl(ota_lci_bus.g_category_usage_id, hr_api.g_number)
148: = p_category_usage_id)) then
149: --

Line 147: and ( nvl(ota_lci_bus.g_category_usage_id, hr_api.g_number)

143: );
144: --
145: if (( nvl(ota_lci_bus.g_learning_path_id, hr_api.g_number)
146: = p_learning_path_id)
147: and ( nvl(ota_lci_bus.g_category_usage_id, hr_api.g_number)
148: = p_category_usage_id)) then
149: --
150: -- The legislation code has already been found with a previous
151: -- call to this function. Just return the value in the global

Line 225: nvl(ota_lci_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>

221: hr_utility.set_location('Entering:'||l_proc,10);
222: --
223: if ((p_rec.learning_path_id is not null) and
224: (p_rec.category_usage_id is not null) and (
225: nvl(ota_lci_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
226: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
227: nvl(ota_lci_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
228: nvl(p_rec.attribute1, hr_api.g_varchar2) or
229: nvl(ota_lci_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

Line 226: nvl(p_rec.attribute_category, hr_api.g_varchar2) or

222: --
223: if ((p_rec.learning_path_id is not null) and
224: (p_rec.category_usage_id is not null) and (
225: nvl(ota_lci_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
226: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
227: nvl(ota_lci_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
228: nvl(p_rec.attribute1, hr_api.g_varchar2) or
229: nvl(ota_lci_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
230: nvl(p_rec.attribute2, hr_api.g_varchar2) or

Line 227: nvl(ota_lci_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>

223: if ((p_rec.learning_path_id is not null) and
224: (p_rec.category_usage_id is not null) and (
225: nvl(ota_lci_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
226: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
227: nvl(ota_lci_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
228: nvl(p_rec.attribute1, hr_api.g_varchar2) or
229: nvl(ota_lci_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
230: nvl(p_rec.attribute2, hr_api.g_varchar2) or
231: nvl(ota_lci_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

Line 228: nvl(p_rec.attribute1, hr_api.g_varchar2) or

224: (p_rec.category_usage_id is not null) and (
225: nvl(ota_lci_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
226: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
227: nvl(ota_lci_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
228: nvl(p_rec.attribute1, hr_api.g_varchar2) or
229: nvl(ota_lci_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
230: nvl(p_rec.attribute2, hr_api.g_varchar2) or
231: nvl(ota_lci_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
232: nvl(p_rec.attribute3, hr_api.g_varchar2) or

Line 229: nvl(ota_lci_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

225: nvl(ota_lci_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
226: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
227: nvl(ota_lci_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
228: nvl(p_rec.attribute1, hr_api.g_varchar2) or
229: nvl(ota_lci_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
230: nvl(p_rec.attribute2, hr_api.g_varchar2) or
231: nvl(ota_lci_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
232: nvl(p_rec.attribute3, hr_api.g_varchar2) or
233: nvl(ota_lci_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

Line 230: nvl(p_rec.attribute2, hr_api.g_varchar2) or

226: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
227: nvl(ota_lci_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
228: nvl(p_rec.attribute1, hr_api.g_varchar2) or
229: nvl(ota_lci_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
230: nvl(p_rec.attribute2, hr_api.g_varchar2) or
231: nvl(ota_lci_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
232: nvl(p_rec.attribute3, hr_api.g_varchar2) or
233: nvl(ota_lci_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
234: nvl(p_rec.attribute4, hr_api.g_varchar2) or

Line 231: nvl(ota_lci_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

227: nvl(ota_lci_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
228: nvl(p_rec.attribute1, hr_api.g_varchar2) or
229: nvl(ota_lci_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
230: nvl(p_rec.attribute2, hr_api.g_varchar2) or
231: nvl(ota_lci_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
232: nvl(p_rec.attribute3, hr_api.g_varchar2) or
233: nvl(ota_lci_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
234: nvl(p_rec.attribute4, hr_api.g_varchar2) or
235: nvl(ota_lci_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

Line 232: nvl(p_rec.attribute3, hr_api.g_varchar2) or

228: nvl(p_rec.attribute1, hr_api.g_varchar2) or
229: nvl(ota_lci_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
230: nvl(p_rec.attribute2, hr_api.g_varchar2) or
231: nvl(ota_lci_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
232: nvl(p_rec.attribute3, hr_api.g_varchar2) or
233: nvl(ota_lci_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
234: nvl(p_rec.attribute4, hr_api.g_varchar2) or
235: nvl(ota_lci_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
236: nvl(p_rec.attribute5, hr_api.g_varchar2) or

Line 233: nvl(ota_lci_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

229: nvl(ota_lci_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
230: nvl(p_rec.attribute2, hr_api.g_varchar2) or
231: nvl(ota_lci_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
232: nvl(p_rec.attribute3, hr_api.g_varchar2) or
233: nvl(ota_lci_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
234: nvl(p_rec.attribute4, hr_api.g_varchar2) or
235: nvl(ota_lci_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
236: nvl(p_rec.attribute5, hr_api.g_varchar2) or
237: nvl(ota_lci_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

Line 234: nvl(p_rec.attribute4, hr_api.g_varchar2) or

230: nvl(p_rec.attribute2, hr_api.g_varchar2) or
231: nvl(ota_lci_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
232: nvl(p_rec.attribute3, hr_api.g_varchar2) or
233: nvl(ota_lci_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
234: nvl(p_rec.attribute4, hr_api.g_varchar2) or
235: nvl(ota_lci_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
236: nvl(p_rec.attribute5, hr_api.g_varchar2) or
237: nvl(ota_lci_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
238: nvl(p_rec.attribute6, hr_api.g_varchar2) or

Line 235: nvl(ota_lci_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

231: nvl(ota_lci_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
232: nvl(p_rec.attribute3, hr_api.g_varchar2) or
233: nvl(ota_lci_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
234: nvl(p_rec.attribute4, hr_api.g_varchar2) or
235: nvl(ota_lci_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
236: nvl(p_rec.attribute5, hr_api.g_varchar2) or
237: nvl(ota_lci_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
238: nvl(p_rec.attribute6, hr_api.g_varchar2) or
239: nvl(ota_lci_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

Line 236: nvl(p_rec.attribute5, hr_api.g_varchar2) or

232: nvl(p_rec.attribute3, hr_api.g_varchar2) or
233: nvl(ota_lci_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
234: nvl(p_rec.attribute4, hr_api.g_varchar2) or
235: nvl(ota_lci_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
236: nvl(p_rec.attribute5, hr_api.g_varchar2) or
237: nvl(ota_lci_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
238: nvl(p_rec.attribute6, hr_api.g_varchar2) or
239: nvl(ota_lci_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
240: nvl(p_rec.attribute7, hr_api.g_varchar2) or

Line 237: nvl(ota_lci_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

233: nvl(ota_lci_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
234: nvl(p_rec.attribute4, hr_api.g_varchar2) or
235: nvl(ota_lci_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
236: nvl(p_rec.attribute5, hr_api.g_varchar2) or
237: nvl(ota_lci_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
238: nvl(p_rec.attribute6, hr_api.g_varchar2) or
239: nvl(ota_lci_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
240: nvl(p_rec.attribute7, hr_api.g_varchar2) or
241: nvl(ota_lci_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

Line 238: nvl(p_rec.attribute6, hr_api.g_varchar2) or

234: nvl(p_rec.attribute4, hr_api.g_varchar2) or
235: nvl(ota_lci_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
236: nvl(p_rec.attribute5, hr_api.g_varchar2) or
237: nvl(ota_lci_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
238: nvl(p_rec.attribute6, hr_api.g_varchar2) or
239: nvl(ota_lci_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
240: nvl(p_rec.attribute7, hr_api.g_varchar2) or
241: nvl(ota_lci_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
242: nvl(p_rec.attribute8, hr_api.g_varchar2) or

Line 239: nvl(ota_lci_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

235: nvl(ota_lci_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
236: nvl(p_rec.attribute5, hr_api.g_varchar2) or
237: nvl(ota_lci_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
238: nvl(p_rec.attribute6, hr_api.g_varchar2) or
239: nvl(ota_lci_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
240: nvl(p_rec.attribute7, hr_api.g_varchar2) or
241: nvl(ota_lci_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
242: nvl(p_rec.attribute8, hr_api.g_varchar2) or
243: nvl(ota_lci_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

Line 240: nvl(p_rec.attribute7, hr_api.g_varchar2) or

236: nvl(p_rec.attribute5, hr_api.g_varchar2) or
237: nvl(ota_lci_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
238: nvl(p_rec.attribute6, hr_api.g_varchar2) or
239: nvl(ota_lci_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
240: nvl(p_rec.attribute7, hr_api.g_varchar2) or
241: nvl(ota_lci_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
242: nvl(p_rec.attribute8, hr_api.g_varchar2) or
243: nvl(ota_lci_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
244: nvl(p_rec.attribute9, hr_api.g_varchar2) or

Line 241: nvl(ota_lci_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

237: nvl(ota_lci_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
238: nvl(p_rec.attribute6, hr_api.g_varchar2) or
239: nvl(ota_lci_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
240: nvl(p_rec.attribute7, hr_api.g_varchar2) or
241: nvl(ota_lci_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
242: nvl(p_rec.attribute8, hr_api.g_varchar2) or
243: nvl(ota_lci_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
244: nvl(p_rec.attribute9, hr_api.g_varchar2) or
245: nvl(ota_lci_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

Line 242: nvl(p_rec.attribute8, hr_api.g_varchar2) or

238: nvl(p_rec.attribute6, hr_api.g_varchar2) or
239: nvl(ota_lci_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
240: nvl(p_rec.attribute7, hr_api.g_varchar2) or
241: nvl(ota_lci_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
242: nvl(p_rec.attribute8, hr_api.g_varchar2) or
243: nvl(ota_lci_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
244: nvl(p_rec.attribute9, hr_api.g_varchar2) or
245: nvl(ota_lci_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
246: nvl(p_rec.attribute10, hr_api.g_varchar2) or

Line 243: nvl(ota_lci_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

239: nvl(ota_lci_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
240: nvl(p_rec.attribute7, hr_api.g_varchar2) or
241: nvl(ota_lci_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
242: nvl(p_rec.attribute8, hr_api.g_varchar2) or
243: nvl(ota_lci_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
244: nvl(p_rec.attribute9, hr_api.g_varchar2) or
245: nvl(ota_lci_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
246: nvl(p_rec.attribute10, hr_api.g_varchar2) or
247: nvl(ota_lci_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

Line 244: nvl(p_rec.attribute9, hr_api.g_varchar2) or

240: nvl(p_rec.attribute7, hr_api.g_varchar2) or
241: nvl(ota_lci_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
242: nvl(p_rec.attribute8, hr_api.g_varchar2) or
243: nvl(ota_lci_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
244: nvl(p_rec.attribute9, hr_api.g_varchar2) or
245: nvl(ota_lci_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
246: nvl(p_rec.attribute10, hr_api.g_varchar2) or
247: nvl(ota_lci_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
248: nvl(p_rec.attribute11, hr_api.g_varchar2) or

Line 245: nvl(ota_lci_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

241: nvl(ota_lci_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
242: nvl(p_rec.attribute8, hr_api.g_varchar2) or
243: nvl(ota_lci_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
244: nvl(p_rec.attribute9, hr_api.g_varchar2) or
245: nvl(ota_lci_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
246: nvl(p_rec.attribute10, hr_api.g_varchar2) or
247: nvl(ota_lci_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
248: nvl(p_rec.attribute11, hr_api.g_varchar2) or
249: nvl(ota_lci_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

Line 246: nvl(p_rec.attribute10, hr_api.g_varchar2) or

242: nvl(p_rec.attribute8, hr_api.g_varchar2) or
243: nvl(ota_lci_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
244: nvl(p_rec.attribute9, hr_api.g_varchar2) or
245: nvl(ota_lci_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
246: nvl(p_rec.attribute10, hr_api.g_varchar2) or
247: nvl(ota_lci_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
248: nvl(p_rec.attribute11, hr_api.g_varchar2) or
249: nvl(ota_lci_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
250: nvl(p_rec.attribute12, hr_api.g_varchar2) or

Line 247: nvl(ota_lci_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

243: nvl(ota_lci_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
244: nvl(p_rec.attribute9, hr_api.g_varchar2) or
245: nvl(ota_lci_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
246: nvl(p_rec.attribute10, hr_api.g_varchar2) or
247: nvl(ota_lci_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
248: nvl(p_rec.attribute11, hr_api.g_varchar2) or
249: nvl(ota_lci_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
250: nvl(p_rec.attribute12, hr_api.g_varchar2) or
251: nvl(ota_lci_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

Line 248: nvl(p_rec.attribute11, hr_api.g_varchar2) or

244: nvl(p_rec.attribute9, hr_api.g_varchar2) or
245: nvl(ota_lci_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
246: nvl(p_rec.attribute10, hr_api.g_varchar2) or
247: nvl(ota_lci_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
248: nvl(p_rec.attribute11, hr_api.g_varchar2) or
249: nvl(ota_lci_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
250: nvl(p_rec.attribute12, hr_api.g_varchar2) or
251: nvl(ota_lci_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
252: nvl(p_rec.attribute13, hr_api.g_varchar2) or

Line 249: nvl(ota_lci_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

245: nvl(ota_lci_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
246: nvl(p_rec.attribute10, hr_api.g_varchar2) or
247: nvl(ota_lci_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
248: nvl(p_rec.attribute11, hr_api.g_varchar2) or
249: nvl(ota_lci_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
250: nvl(p_rec.attribute12, hr_api.g_varchar2) or
251: nvl(ota_lci_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
252: nvl(p_rec.attribute13, hr_api.g_varchar2) or
253: nvl(ota_lci_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

Line 250: nvl(p_rec.attribute12, hr_api.g_varchar2) or

246: nvl(p_rec.attribute10, hr_api.g_varchar2) or
247: nvl(ota_lci_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
248: nvl(p_rec.attribute11, hr_api.g_varchar2) or
249: nvl(ota_lci_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
250: nvl(p_rec.attribute12, hr_api.g_varchar2) or
251: nvl(ota_lci_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
252: nvl(p_rec.attribute13, hr_api.g_varchar2) or
253: nvl(ota_lci_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
254: nvl(p_rec.attribute14, hr_api.g_varchar2) or

Line 251: nvl(ota_lci_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

247: nvl(ota_lci_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
248: nvl(p_rec.attribute11, hr_api.g_varchar2) or
249: nvl(ota_lci_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
250: nvl(p_rec.attribute12, hr_api.g_varchar2) or
251: nvl(ota_lci_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
252: nvl(p_rec.attribute13, hr_api.g_varchar2) or
253: nvl(ota_lci_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
254: nvl(p_rec.attribute14, hr_api.g_varchar2) or
255: nvl(ota_lci_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

Line 252: nvl(p_rec.attribute13, hr_api.g_varchar2) or

248: nvl(p_rec.attribute11, hr_api.g_varchar2) or
249: nvl(ota_lci_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
250: nvl(p_rec.attribute12, hr_api.g_varchar2) or
251: nvl(ota_lci_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
252: nvl(p_rec.attribute13, hr_api.g_varchar2) or
253: nvl(ota_lci_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
254: nvl(p_rec.attribute14, hr_api.g_varchar2) or
255: nvl(ota_lci_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
256: nvl(p_rec.attribute15, hr_api.g_varchar2) or

Line 253: nvl(ota_lci_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

249: nvl(ota_lci_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
250: nvl(p_rec.attribute12, hr_api.g_varchar2) or
251: nvl(ota_lci_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
252: nvl(p_rec.attribute13, hr_api.g_varchar2) or
253: nvl(ota_lci_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
254: nvl(p_rec.attribute14, hr_api.g_varchar2) or
255: nvl(ota_lci_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
256: nvl(p_rec.attribute15, hr_api.g_varchar2) or
257: nvl(ota_lci_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

Line 254: nvl(p_rec.attribute14, hr_api.g_varchar2) or

250: nvl(p_rec.attribute12, hr_api.g_varchar2) or
251: nvl(ota_lci_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
252: nvl(p_rec.attribute13, hr_api.g_varchar2) or
253: nvl(ota_lci_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
254: nvl(p_rec.attribute14, hr_api.g_varchar2) or
255: nvl(ota_lci_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
256: nvl(p_rec.attribute15, hr_api.g_varchar2) or
257: nvl(ota_lci_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
258: nvl(p_rec.attribute16, hr_api.g_varchar2) or

Line 255: nvl(ota_lci_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

251: nvl(ota_lci_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
252: nvl(p_rec.attribute13, hr_api.g_varchar2) or
253: nvl(ota_lci_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
254: nvl(p_rec.attribute14, hr_api.g_varchar2) or
255: nvl(ota_lci_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
256: nvl(p_rec.attribute15, hr_api.g_varchar2) or
257: nvl(ota_lci_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
258: nvl(p_rec.attribute16, hr_api.g_varchar2) or
259: nvl(ota_lci_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

Line 256: nvl(p_rec.attribute15, hr_api.g_varchar2) or

252: nvl(p_rec.attribute13, hr_api.g_varchar2) or
253: nvl(ota_lci_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
254: nvl(p_rec.attribute14, hr_api.g_varchar2) or
255: nvl(ota_lci_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
256: nvl(p_rec.attribute15, hr_api.g_varchar2) or
257: nvl(ota_lci_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
258: nvl(p_rec.attribute16, hr_api.g_varchar2) or
259: nvl(ota_lci_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
260: nvl(p_rec.attribute17, hr_api.g_varchar2) or

Line 257: nvl(ota_lci_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

253: nvl(ota_lci_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
254: nvl(p_rec.attribute14, hr_api.g_varchar2) or
255: nvl(ota_lci_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
256: nvl(p_rec.attribute15, hr_api.g_varchar2) or
257: nvl(ota_lci_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
258: nvl(p_rec.attribute16, hr_api.g_varchar2) or
259: nvl(ota_lci_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
260: nvl(p_rec.attribute17, hr_api.g_varchar2) or
261: nvl(ota_lci_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

Line 258: nvl(p_rec.attribute16, hr_api.g_varchar2) or

254: nvl(p_rec.attribute14, hr_api.g_varchar2) or
255: nvl(ota_lci_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
256: nvl(p_rec.attribute15, hr_api.g_varchar2) or
257: nvl(ota_lci_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
258: nvl(p_rec.attribute16, hr_api.g_varchar2) or
259: nvl(ota_lci_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
260: nvl(p_rec.attribute17, hr_api.g_varchar2) or
261: nvl(ota_lci_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
262: nvl(p_rec.attribute18, hr_api.g_varchar2) or

Line 259: nvl(ota_lci_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

255: nvl(ota_lci_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
256: nvl(p_rec.attribute15, hr_api.g_varchar2) or
257: nvl(ota_lci_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
258: nvl(p_rec.attribute16, hr_api.g_varchar2) or
259: nvl(ota_lci_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
260: nvl(p_rec.attribute17, hr_api.g_varchar2) or
261: nvl(ota_lci_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
262: nvl(p_rec.attribute18, hr_api.g_varchar2) or
263: nvl(ota_lci_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

Line 260: nvl(p_rec.attribute17, hr_api.g_varchar2) or

256: nvl(p_rec.attribute15, hr_api.g_varchar2) or
257: nvl(ota_lci_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
258: nvl(p_rec.attribute16, hr_api.g_varchar2) or
259: nvl(ota_lci_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
260: nvl(p_rec.attribute17, hr_api.g_varchar2) or
261: nvl(ota_lci_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
262: nvl(p_rec.attribute18, hr_api.g_varchar2) or
263: nvl(ota_lci_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
264: nvl(p_rec.attribute19, hr_api.g_varchar2) or

Line 261: nvl(ota_lci_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

257: nvl(ota_lci_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
258: nvl(p_rec.attribute16, hr_api.g_varchar2) or
259: nvl(ota_lci_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
260: nvl(p_rec.attribute17, hr_api.g_varchar2) or
261: nvl(ota_lci_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
262: nvl(p_rec.attribute18, hr_api.g_varchar2) or
263: nvl(ota_lci_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
264: nvl(p_rec.attribute19, hr_api.g_varchar2) or
265: nvl(ota_lci_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

Line 262: nvl(p_rec.attribute18, hr_api.g_varchar2) or

258: nvl(p_rec.attribute16, hr_api.g_varchar2) or
259: nvl(ota_lci_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
260: nvl(p_rec.attribute17, hr_api.g_varchar2) or
261: nvl(ota_lci_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
262: nvl(p_rec.attribute18, hr_api.g_varchar2) or
263: nvl(ota_lci_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
264: nvl(p_rec.attribute19, hr_api.g_varchar2) or
265: nvl(ota_lci_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
266: nvl(p_rec.attribute20, hr_api.g_varchar2) ))

Line 263: nvl(ota_lci_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

259: nvl(ota_lci_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
260: nvl(p_rec.attribute17, hr_api.g_varchar2) or
261: nvl(ota_lci_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
262: nvl(p_rec.attribute18, hr_api.g_varchar2) or
263: nvl(ota_lci_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
264: nvl(p_rec.attribute19, hr_api.g_varchar2) or
265: nvl(ota_lci_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
266: nvl(p_rec.attribute20, hr_api.g_varchar2) ))
267: or (p_rec.learning_path_id is null) and

Line 264: nvl(p_rec.attribute19, hr_api.g_varchar2) or

260: nvl(p_rec.attribute17, hr_api.g_varchar2) or
261: nvl(ota_lci_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
262: nvl(p_rec.attribute18, hr_api.g_varchar2) or
263: nvl(ota_lci_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
264: nvl(p_rec.attribute19, hr_api.g_varchar2) or
265: nvl(ota_lci_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
266: nvl(p_rec.attribute20, hr_api.g_varchar2) ))
267: or (p_rec.learning_path_id is null) and
268: (p_rec.category_usage_id is null) then

Line 265: nvl(ota_lci_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

261: nvl(ota_lci_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
262: nvl(p_rec.attribute18, hr_api.g_varchar2) or
263: nvl(ota_lci_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
264: nvl(p_rec.attribute19, hr_api.g_varchar2) or
265: nvl(ota_lci_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
266: nvl(p_rec.attribute20, hr_api.g_varchar2) ))
267: or (p_rec.learning_path_id is null) and
268: (p_rec.category_usage_id is null) then
269: --

Line 266: nvl(p_rec.attribute20, hr_api.g_varchar2) ))

262: nvl(p_rec.attribute18, hr_api.g_varchar2) or
263: nvl(ota_lci_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
264: nvl(p_rec.attribute19, hr_api.g_varchar2) or
265: nvl(ota_lci_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
266: nvl(p_rec.attribute20, hr_api.g_varchar2) ))
267: or (p_rec.learning_path_id is null) and
268: (p_rec.category_usage_id is null) then
269: --
270: -- Only execute the validation if absolutely necessary: