APPS.OTA_ANC_BUS dependencies on OTA_ANC_SHD

Line 231: (p_rec in ota_anc_shd.g_rec_type

227: -- Internal Row Handler Use Only.
228: --
229: -- ----------------------------------------------------------------------------
230: procedure chk_df
231: (p_rec in ota_anc_shd.g_rec_type
232: ) is
233: --
234: l_proc varchar2(72) := g_package || 'chk_df';
235: --

Line 240: nvl(ota_anc_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>

236: begin
237: hr_utility.set_location('Entering:'||l_proc,10);
238: --
239: if ((p_rec.announcement_id is not null) and (
240: nvl(ota_anc_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
241: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
242: nvl(ota_anc_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
243: nvl(p_rec.attribute1, hr_api.g_varchar2) or
244: nvl(ota_anc_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

Line 242: nvl(ota_anc_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>

238: --
239: if ((p_rec.announcement_id is not null) and (
240: nvl(ota_anc_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
241: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
242: nvl(ota_anc_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
243: nvl(p_rec.attribute1, hr_api.g_varchar2) or
244: nvl(ota_anc_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
245: nvl(p_rec.attribute2, hr_api.g_varchar2) or
246: nvl(ota_anc_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

Line 244: nvl(ota_anc_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

240: nvl(ota_anc_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
241: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
242: nvl(ota_anc_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
243: nvl(p_rec.attribute1, hr_api.g_varchar2) or
244: nvl(ota_anc_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
245: nvl(p_rec.attribute2, hr_api.g_varchar2) or
246: nvl(ota_anc_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
247: nvl(p_rec.attribute3, hr_api.g_varchar2) or
248: nvl(ota_anc_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

Line 246: nvl(ota_anc_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

242: nvl(ota_anc_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
243: nvl(p_rec.attribute1, hr_api.g_varchar2) or
244: nvl(ota_anc_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
245: nvl(p_rec.attribute2, hr_api.g_varchar2) or
246: nvl(ota_anc_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
247: nvl(p_rec.attribute3, hr_api.g_varchar2) or
248: nvl(ota_anc_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
249: nvl(p_rec.attribute4, hr_api.g_varchar2) or
250: nvl(ota_anc_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

Line 248: nvl(ota_anc_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

244: nvl(ota_anc_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
245: nvl(p_rec.attribute2, hr_api.g_varchar2) or
246: nvl(ota_anc_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
247: nvl(p_rec.attribute3, hr_api.g_varchar2) or
248: nvl(ota_anc_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
249: nvl(p_rec.attribute4, hr_api.g_varchar2) or
250: nvl(ota_anc_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
251: nvl(p_rec.attribute5, hr_api.g_varchar2) or
252: nvl(ota_anc_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

Line 250: nvl(ota_anc_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

246: nvl(ota_anc_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
247: nvl(p_rec.attribute3, hr_api.g_varchar2) or
248: nvl(ota_anc_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
249: nvl(p_rec.attribute4, hr_api.g_varchar2) or
250: nvl(ota_anc_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
251: nvl(p_rec.attribute5, hr_api.g_varchar2) or
252: nvl(ota_anc_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
253: nvl(p_rec.attribute6, hr_api.g_varchar2) or
254: nvl(ota_anc_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

Line 252: nvl(ota_anc_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

248: nvl(ota_anc_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
249: nvl(p_rec.attribute4, hr_api.g_varchar2) or
250: nvl(ota_anc_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
251: nvl(p_rec.attribute5, hr_api.g_varchar2) or
252: nvl(ota_anc_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
253: nvl(p_rec.attribute6, hr_api.g_varchar2) or
254: nvl(ota_anc_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
255: nvl(p_rec.attribute7, hr_api.g_varchar2) or
256: nvl(ota_anc_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

Line 254: nvl(ota_anc_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

250: nvl(ota_anc_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
251: nvl(p_rec.attribute5, hr_api.g_varchar2) or
252: nvl(ota_anc_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
253: nvl(p_rec.attribute6, hr_api.g_varchar2) or
254: nvl(ota_anc_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
255: nvl(p_rec.attribute7, hr_api.g_varchar2) or
256: nvl(ota_anc_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
257: nvl(p_rec.attribute8, hr_api.g_varchar2) or
258: nvl(ota_anc_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

Line 256: nvl(ota_anc_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

252: nvl(ota_anc_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
253: nvl(p_rec.attribute6, hr_api.g_varchar2) or
254: nvl(ota_anc_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
255: nvl(p_rec.attribute7, hr_api.g_varchar2) or
256: nvl(ota_anc_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
257: nvl(p_rec.attribute8, hr_api.g_varchar2) or
258: nvl(ota_anc_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
259: nvl(p_rec.attribute9, hr_api.g_varchar2) or
260: nvl(ota_anc_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

Line 258: nvl(ota_anc_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

254: nvl(ota_anc_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
255: nvl(p_rec.attribute7, hr_api.g_varchar2) or
256: nvl(ota_anc_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
257: nvl(p_rec.attribute8, hr_api.g_varchar2) or
258: nvl(ota_anc_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
259: nvl(p_rec.attribute9, hr_api.g_varchar2) or
260: nvl(ota_anc_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
261: nvl(p_rec.attribute10, hr_api.g_varchar2) or
262: nvl(ota_anc_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

Line 260: nvl(ota_anc_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

256: nvl(ota_anc_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
257: nvl(p_rec.attribute8, hr_api.g_varchar2) or
258: nvl(ota_anc_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
259: nvl(p_rec.attribute9, hr_api.g_varchar2) or
260: nvl(ota_anc_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
261: nvl(p_rec.attribute10, hr_api.g_varchar2) or
262: nvl(ota_anc_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
263: nvl(p_rec.attribute11, hr_api.g_varchar2) or
264: nvl(ota_anc_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

Line 262: nvl(ota_anc_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

258: nvl(ota_anc_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
259: nvl(p_rec.attribute9, hr_api.g_varchar2) or
260: nvl(ota_anc_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
261: nvl(p_rec.attribute10, hr_api.g_varchar2) or
262: nvl(ota_anc_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
263: nvl(p_rec.attribute11, hr_api.g_varchar2) or
264: nvl(ota_anc_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
265: nvl(p_rec.attribute12, hr_api.g_varchar2) or
266: nvl(ota_anc_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

Line 264: nvl(ota_anc_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

260: nvl(ota_anc_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
261: nvl(p_rec.attribute10, hr_api.g_varchar2) or
262: nvl(ota_anc_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
263: nvl(p_rec.attribute11, hr_api.g_varchar2) or
264: nvl(ota_anc_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
265: nvl(p_rec.attribute12, hr_api.g_varchar2) or
266: nvl(ota_anc_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
267: nvl(p_rec.attribute13, hr_api.g_varchar2) or
268: nvl(ota_anc_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

Line 266: nvl(ota_anc_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

262: nvl(ota_anc_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
263: nvl(p_rec.attribute11, hr_api.g_varchar2) or
264: nvl(ota_anc_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
265: nvl(p_rec.attribute12, hr_api.g_varchar2) or
266: nvl(ota_anc_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
267: nvl(p_rec.attribute13, hr_api.g_varchar2) or
268: nvl(ota_anc_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
269: nvl(p_rec.attribute14, hr_api.g_varchar2) or
270: nvl(ota_anc_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

Line 268: nvl(ota_anc_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

264: nvl(ota_anc_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
265: nvl(p_rec.attribute12, hr_api.g_varchar2) or
266: nvl(ota_anc_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
267: nvl(p_rec.attribute13, hr_api.g_varchar2) or
268: nvl(ota_anc_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
269: nvl(p_rec.attribute14, hr_api.g_varchar2) or
270: nvl(ota_anc_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
271: nvl(p_rec.attribute15, hr_api.g_varchar2) or
272: nvl(ota_anc_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

Line 270: nvl(ota_anc_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

266: nvl(ota_anc_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
267: nvl(p_rec.attribute13, hr_api.g_varchar2) or
268: nvl(ota_anc_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
269: nvl(p_rec.attribute14, hr_api.g_varchar2) or
270: nvl(ota_anc_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
271: nvl(p_rec.attribute15, hr_api.g_varchar2) or
272: nvl(ota_anc_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
273: nvl(p_rec.attribute16, hr_api.g_varchar2) or
274: nvl(ota_anc_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

Line 272: nvl(ota_anc_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

268: nvl(ota_anc_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
269: nvl(p_rec.attribute14, hr_api.g_varchar2) or
270: nvl(ota_anc_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
271: nvl(p_rec.attribute15, hr_api.g_varchar2) or
272: nvl(ota_anc_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
273: nvl(p_rec.attribute16, hr_api.g_varchar2) or
274: nvl(ota_anc_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
275: nvl(p_rec.attribute17, hr_api.g_varchar2) or
276: nvl(ota_anc_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

Line 274: nvl(ota_anc_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

270: nvl(ota_anc_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
271: nvl(p_rec.attribute15, hr_api.g_varchar2) or
272: nvl(ota_anc_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
273: nvl(p_rec.attribute16, hr_api.g_varchar2) or
274: nvl(ota_anc_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
275: nvl(p_rec.attribute17, hr_api.g_varchar2) or
276: nvl(ota_anc_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
277: nvl(p_rec.attribute18, hr_api.g_varchar2) or
278: nvl(ota_anc_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

Line 276: nvl(ota_anc_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

272: nvl(ota_anc_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
273: nvl(p_rec.attribute16, hr_api.g_varchar2) or
274: nvl(ota_anc_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
275: nvl(p_rec.attribute17, hr_api.g_varchar2) or
276: nvl(ota_anc_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
277: nvl(p_rec.attribute18, hr_api.g_varchar2) or
278: nvl(ota_anc_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
279: nvl(p_rec.attribute19, hr_api.g_varchar2) or
280: nvl(ota_anc_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

Line 278: nvl(ota_anc_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

274: nvl(ota_anc_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
275: nvl(p_rec.attribute17, hr_api.g_varchar2) or
276: nvl(ota_anc_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
277: nvl(p_rec.attribute18, hr_api.g_varchar2) or
278: nvl(ota_anc_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
279: nvl(p_rec.attribute19, hr_api.g_varchar2) or
280: nvl(ota_anc_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
281: nvl(p_rec.attribute20, hr_api.g_varchar2) ))
282: or (p_rec.announcement_id is null) then

Line 280: nvl(ota_anc_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

276: nvl(ota_anc_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
277: nvl(p_rec.attribute18, hr_api.g_varchar2) or
278: nvl(ota_anc_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
279: nvl(p_rec.attribute19, hr_api.g_varchar2) or
280: nvl(ota_anc_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
281: nvl(p_rec.attribute20, hr_api.g_varchar2) ))
282: or (p_rec.announcement_id is null) then
283: --
284: -- Only execute the validation if absolutely necessary:

Line 368: ,p_rec in ota_anc_shd.g_rec_type

364: -- {End Of Comments}
365: -- ----------------------------------------------------------------------------
366: Procedure chk_non_updateable_args
367: (p_effective_date in date
368: ,p_rec in ota_anc_shd.g_rec_type
369: ) IS
370: --
371: l_proc varchar2(72) := g_package || 'chk_non_updateable_args';
372: --

Line 378: IF NOT ota_anc_shd.api_updating

374: --
375: -- Only proceed with the validation if a row exists for the current
376: -- record in the HR Schema.
377: --
378: IF NOT ota_anc_shd.api_updating
379: (p_announcement_id => p_rec.announcement_id
380: ,p_object_version_number => p_rec.object_version_number
381: ) THEN
382: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');

Line 398: ,p_rec in ota_anc_shd.g_rec_type

394: -- |---------------------------< insert_validate >----------------------------|
395: -- ----------------------------------------------------------------------------
396: Procedure insert_validate
397: (p_effective_date in date
398: ,p_rec in ota_anc_shd.g_rec_type
399: ) is
400: --
401: l_proc varchar2(72) := g_package||'insert_validate';
402: --

Line 410: ,p_associated_column1 => ota_anc_shd.g_tab_nam

406: -- Call all supporting business operations
407: --
408: hr_api.validate_bus_grp_id
409: (p_business_group_id => p_rec.business_group_id
410: ,p_associated_column1 => ota_anc_shd.g_tab_nam
411: || '.BUSINESS_GROUP_ID');
412: --
413: -- After validating the set of important attributes,
414: -- if Multiple Message detection is enabled and at least

Line 434: ,p_rec in ota_anc_shd.g_rec_type

430: -- |---------------------------< update_validate >----------------------------|
431: -- ----------------------------------------------------------------------------
432: Procedure update_validate
433: (p_effective_date in date
434: ,p_rec in ota_anc_shd.g_rec_type
435: ) is
436: --
437: l_proc varchar2(72) := g_package||'update_validate';
438: --

Line 446: ,p_associated_column1 => ota_anc_shd.g_tab_nam

442: -- Call all supporting business operations
443: --
444: hr_api.validate_bus_grp_id
445: (p_business_group_id => p_rec.business_group_id
446: ,p_associated_column1 => ota_anc_shd.g_tab_nam
447: || '.BUSINESS_GROUP_ID');
448: --
449: -- After validating the set of important attributes,
450: -- if Multiple Message detection is enabled and at least

Line 474: (p_rec in ota_anc_shd.g_rec_type

470: -- ----------------------------------------------------------------------------
471: -- |---------------------------< delete_validate >----------------------------|
472: -- ----------------------------------------------------------------------------
473: Procedure delete_validate
474: (p_rec in ota_anc_shd.g_rec_type
475: ) is
476: --
477: l_proc varchar2(72) := g_package||'delete_validate';
478: --