eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OTA_LCI_BUS dependencies on OTA_LCI_SHD

Line 215: (p_rec in ota_lci_shd.g_rec_type

211: -- Internal Row Handler Use Only.
212: --
213: -- ----------------------------------------------------------------------------
214: procedure chk_df
215: (p_rec in ota_lci_shd.g_rec_type
216: ) is
217: --
218: l_proc varchar2(72) := g_package || 'chk_df';
219: --

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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 354: ,p_rec in ota_lci_shd.g_rec_type

350: -- {End Of Comments}
351: -- ----------------------------------------------------------------------------
352: Procedure chk_non_updateable_args
353: (p_effective_date in date
354: ,p_rec in ota_lci_shd.g_rec_type
355: ) IS
356: --
357: l_proc varchar2(72) := g_package || 'chk_non_updateable_args';
358: --

Line 364: IF NOT ota_lci_shd.api_updating

360: --
361: -- Only proceed with the validation if a row exists for the current
362: -- record in the HR Schema.
363: --
364: IF NOT ota_lci_shd.api_updating
365: (p_learning_path_id => p_rec.learning_path_id
366: ,p_category_usage_id => p_rec.category_usage_id
367: ,p_object_version_number => p_rec.object_version_number
368: ) THEN

Line 473: ,p_rec in ota_lci_shd.g_rec_type

469: -- |---------------------------< insert_validate >----------------------------|
470: -- ----------------------------------------------------------------------------
471: Procedure insert_validate
472: (p_effective_date in date
473: ,p_rec in ota_lci_shd.g_rec_type
474: ,p_learning_path_id in number
475: ,p_category_usage_id in number
476: ) is
477: --

Line 514: ,p_rec in ota_lci_shd.g_rec_type

510: -- |---------------------------< update_validate >----------------------------|
511: -- ----------------------------------------------------------------------------
512: Procedure update_validate
513: (p_effective_date in date
514: ,p_rec in ota_lci_shd.g_rec_type
515: ) is
516: --
517: l_proc varchar2(72) := g_package||'update_validate';
518:

Line 519: l_start_date_changed boolean := ota_general.value_changed( ota_lci_shd.g_old_rec.start_date_active

515: ) is
516: --
517: l_proc varchar2(72) := g_package||'update_validate';
518:
519: l_start_date_changed boolean := ota_general.value_changed( ota_lci_shd.g_old_rec.start_date_active
520: , p_rec.start_date_active );
521: l_end_date_changed boolean := ota_general.value_changed( ota_lci_shd.g_old_rec.end_date_active
522: , p_rec.end_date_active );
523: l_start_date ota_lp_cat_inclusions.start_date_active%TYPE;

Line 521: l_end_date_changed boolean := ota_general.value_changed( ota_lci_shd.g_old_rec.end_date_active

517: l_proc varchar2(72) := g_package||'update_validate';
518:
519: l_start_date_changed boolean := ota_general.value_changed( ota_lci_shd.g_old_rec.start_date_active
520: , p_rec.start_date_active );
521: l_end_date_changed boolean := ota_general.value_changed( ota_lci_shd.g_old_rec.end_date_active
522: , p_rec.end_date_active );
523: l_start_date ota_lp_cat_inclusions.start_date_active%TYPE;
524: l_end_date ota_lp_cat_inclusions.end_date_active%TYPE;
525: --

Line 552: l_start_date := ota_lci_shd.g_old_rec.start_date_active;

548:
549: IF (l_start_date_changed) THEN
550: l_start_date := p_rec.start_date_active;
551: ELSE
552: l_start_date := ota_lci_shd.g_old_rec.start_date_active;
553: END IF;
554:
555: IF (l_end_date_changed) THEN
556: l_end_date := p_rec.end_date_active;

Line 558: l_end_date := ota_lci_shd.g_old_rec.end_date_active;

554:
555: IF (l_end_date_changed) THEN
556: l_end_date := p_rec.end_date_active;
557: ELSE
558: l_end_date := ota_lci_shd.g_old_rec.end_date_active;
559: END IF;
560:
561:
562: check_category_dates(p_rec.category_usage_id

Line 584: (p_rec in ota_lci_shd.g_rec_type

580: -- ----------------------------------------------------------------------------
581: -- |---------------------------< delete_validate >----------------------------|
582: -- ----------------------------------------------------------------------------
583: Procedure delete_validate
584: (p_rec in ota_lci_shd.g_rec_type
585: ) is
586: --
587: l_proc varchar2(72) := g_package||'delete_validate';
588: --