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_CFS_BUS dependencies on OTA_CFS_SHD

Line 220: (p_rec in ota_cfs_shd.g_rec_type

216: -- Internal Row Handler Use Only.
217: --
218: -- ----------------------------------------------------------------------------
219: procedure chk_df
220: (p_rec in ota_cfs_shd.g_rec_type
221: ) is
222: --
223: l_proc varchar2(72) := g_package || 'chk_df';
224: --

Line 229: nvl(ota_cfs_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>

225: begin
226: hr_utility.set_location('Entering:'||l_proc,10);
227: --
228: if ((p_rec.conference_server_id is not null) and (
229: nvl(ota_cfs_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
230: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
231: nvl(ota_cfs_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
232: nvl(p_rec.attribute1, hr_api.g_varchar2) or
233: nvl(ota_cfs_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

Line 231: nvl(ota_cfs_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>

227: --
228: if ((p_rec.conference_server_id is not null) and (
229: nvl(ota_cfs_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
230: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
231: nvl(ota_cfs_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
232: nvl(p_rec.attribute1, hr_api.g_varchar2) or
233: nvl(ota_cfs_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
234: nvl(p_rec.attribute2, hr_api.g_varchar2) or
235: nvl(ota_cfs_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

Line 233: nvl(ota_cfs_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

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

Line 235: nvl(ota_cfs_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

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

Line 237: nvl(ota_cfs_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

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

Line 239: nvl(ota_cfs_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

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

Line 241: nvl(ota_cfs_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

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

Line 243: nvl(ota_cfs_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

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

Line 245: nvl(ota_cfs_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

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

Line 247: nvl(ota_cfs_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

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

Line 249: nvl(ota_cfs_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

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

Line 251: nvl(ota_cfs_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

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

Line 253: nvl(ota_cfs_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

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

Line 255: nvl(ota_cfs_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

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

Line 257: nvl(ota_cfs_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

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

Line 259: nvl(ota_cfs_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

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

Line 261: nvl(ota_cfs_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

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

Line 263: nvl(ota_cfs_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

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

Line 265: nvl(ota_cfs_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

261: nvl(ota_cfs_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
262: nvl(p_rec.attribute16, hr_api.g_varchar2) or
263: nvl(ota_cfs_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
264: nvl(p_rec.attribute17, hr_api.g_varchar2) or
265: nvl(ota_cfs_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
266: nvl(p_rec.attribute18, hr_api.g_varchar2) or
267: nvl(ota_cfs_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
268: nvl(p_rec.attribute19, hr_api.g_varchar2) or
269: nvl(ota_cfs_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

Line 267: nvl(ota_cfs_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

263: nvl(ota_cfs_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
264: nvl(p_rec.attribute17, hr_api.g_varchar2) or
265: nvl(ota_cfs_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
266: nvl(p_rec.attribute18, hr_api.g_varchar2) or
267: nvl(ota_cfs_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
268: nvl(p_rec.attribute19, hr_api.g_varchar2) or
269: nvl(ota_cfs_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
270: nvl(p_rec.attribute20, hr_api.g_varchar2) ))
271: or (p_rec.conference_server_id is null) then

Line 269: nvl(ota_cfs_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

265: nvl(ota_cfs_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
266: nvl(p_rec.attribute18, hr_api.g_varchar2) or
267: nvl(ota_cfs_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
268: nvl(p_rec.attribute19, hr_api.g_varchar2) or
269: nvl(ota_cfs_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
270: nvl(p_rec.attribute20, hr_api.g_varchar2) ))
271: or (p_rec.conference_server_id is null) then
272: --
273: -- Only execute the validation if absolutely necessary:

Line 357: ,p_rec in ota_cfs_shd.g_rec_type

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

Line 367: IF NOT ota_cfs_shd.api_updating

363: --
364: -- Only proceed with the validation if a row exists for the current
365: -- record in the HR Schema.
366: --
367: IF NOT ota_cfs_shd.api_updating
368: (p_conference_server_id => p_rec.conference_server_id
369: ,p_object_version_number => p_rec.object_version_number
370: ) THEN
371: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');

Line 518: P_REC in out nocopy OTA_CFS_SHD.G_REC_TYPE

514: --
515: end UNIQUE_CFS_NAME;
516:
517: procedure VALIDITY_CHECKS (
518: P_REC in out nocopy OTA_CFS_SHD.G_REC_TYPE
519: ,p_name in varchar2
520: ) is
521:
522: Begin

Line 585: ,p_rec in out nocopy ota_cfs_shd.g_rec_type

581: -- |---------------------------< insert_validate >----------------------------|
582: -- ----------------------------------------------------------------------------
583: Procedure insert_validate
584: (p_effective_date in date
585: ,p_rec in out nocopy ota_cfs_shd.g_rec_type
586: ,p_name in varchar2
587:
588: ) is
589: --

Line 599: ,p_associated_column1 => ota_cfs_shd.g_tab_nam

595: -- Call all supporting business operations
596: --
597: hr_api.validate_bus_grp_id
598: (p_business_group_id => p_rec.business_group_id
599: ,p_associated_column1 => ota_cfs_shd.g_tab_nam
600: || '.BUSINESS_GROUP_ID');
601:
602: VALIDITY_CHECKS (P_REC => P_REC,
603: p_name => p_name );

Line 625: ,p_rec in out nocopy ota_cfs_shd.g_rec_type

621: -- |---------------------------< update_validate >----------------------------|
622: -- ----------------------------------------------------------------------------
623: Procedure update_validate
624: (p_effective_date in date
625: ,p_rec in out nocopy ota_cfs_shd.g_rec_type
626: ,p_name in varchar2
627: ) is
628: --
629: l_proc varchar2(72) := g_package||'update_validate';

Line 638: ,p_associated_column1 => ota_cfs_shd.g_tab_nam

634: -- Call all supporting business operations
635: --
636: hr_api.validate_bus_grp_id
637: (p_business_group_id => p_rec.business_group_id
638: ,p_associated_column1 => ota_cfs_shd.g_tab_nam
639: || '.BUSINESS_GROUP_ID');
640:
641: VALIDITY_CHECKS (P_REC => P_REC,
642: p_name => p_name );

Line 668: (p_rec in ota_cfs_shd.g_rec_type

664: -- ----------------------------------------------------------------------------
665: -- |---------------------------< delete_validate >----------------------------|
666: -- ----------------------------------------------------------------------------
667: Procedure delete_validate
668: (p_rec in ota_cfs_shd.g_rec_type
669: ) is
670: --
671: l_proc varchar2(72) := g_package||'delete_validate';
672: --