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_CCI_BUS dependencies on OTA_CCI_SHD

Line 214: (p_rec in ota_cci_shd.g_rec_type

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

Line 224: nvl(ota_cci_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>

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

Line 226: nvl(ota_cci_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>

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

Line 228: nvl(ota_cci_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

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

Line 230: nvl(ota_cci_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

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

Line 232: nvl(ota_cci_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

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

Line 234: nvl(ota_cci_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

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

Line 236: nvl(ota_cci_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

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

Line 238: nvl(ota_cci_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

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

Line 240: nvl(ota_cci_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

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

Line 242: nvl(ota_cci_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

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

Line 244: nvl(ota_cci_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

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

Line 246: nvl(ota_cci_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

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

Line 248: nvl(ota_cci_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

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

Line 250: nvl(ota_cci_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

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

Line 252: nvl(ota_cci_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

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

Line 254: nvl(ota_cci_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

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

Line 256: nvl(ota_cci_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

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

Line 258: nvl(ota_cci_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

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

Line 260: nvl(ota_cci_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

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

Line 262: nvl(ota_cci_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

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

Line 264: nvl(ota_cci_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

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

Line 353: ,p_rec in ota_cci_shd.g_rec_type

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

Line 363: IF NOT ota_cci_shd.api_updating

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

Line 472: ,p_rec in ota_cci_shd.g_rec_type

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

Line 513: ,p_rec in ota_cci_shd.g_rec_type

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

Line 518: l_start_date_changed boolean := ota_general.value_changed(ota_cci_shd.g_old_rec.start_date_active

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

Line 520: l_end_date_changed boolean := ota_general.value_changed(ota_cci_shd.g_old_rec.end_date_active

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

Line 548: l_start_date := ota_cci_shd.g_old_rec.start_date_active;

544:
545: IF (l_start_date_changed) THEN
546: l_start_date := p_rec.start_date_active;
547: ELSE
548: l_start_date := ota_cci_shd.g_old_rec.start_date_active;
549: END IF;
550:
551: IF (l_end_date_changed) THEN
552: l_end_date := p_rec.end_date_active;

Line 554: l_end_date := ota_cci_shd.g_old_rec.end_date_active;

550:
551: IF (l_end_date_changed) THEN
552: l_end_date := p_rec.end_date_active;
553: ELSE
554: l_end_date := ota_cci_shd.g_old_rec.end_date_active;
555: END IF;
556:
557: check_category_dates(p_rec.category_usage_id
558: ,l_start_date

Line 577: (p_rec in ota_cci_shd.g_rec_type

573: -- ----------------------------------------------------------------------------
574: -- |---------------------------< delete_validate >----------------------------|
575: -- ----------------------------------------------------------------------------
576: Procedure delete_validate
577: (p_rec in ota_cci_shd.g_rec_type
578: ) is
579: --
580: l_proc varchar2(72) := g_package||'delete_validate';
581: --