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_CPE_BUS dependencies on OTA_CPE_SHD

Line 189: (p_rec in ota_cpe_shd.g_rec_type

185: -- Internal Row Handler Use Only.
186: --
187: -- ----------------------------------------------------------------------------
188: procedure chk_df
189: (p_rec in ota_cpe_shd.g_rec_type
190: ) is
191: --
192: l_proc varchar2(72) := g_package || 'chk_df';
193: --

Line 198: nvl(ota_cpe_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>

194: begin
195: hr_utility.set_location('Entering:'||l_proc,10);
196: --
197: if ((p_rec.cert_prd_enrollment_id is not null) and (
198: nvl(ota_cpe_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
199: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
200: nvl(ota_cpe_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
201: nvl(p_rec.attribute1, hr_api.g_varchar2) or
202: nvl(ota_cpe_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

Line 200: nvl(ota_cpe_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>

196: --
197: if ((p_rec.cert_prd_enrollment_id is not null) and (
198: nvl(ota_cpe_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
199: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
200: nvl(ota_cpe_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
201: nvl(p_rec.attribute1, hr_api.g_varchar2) or
202: nvl(ota_cpe_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
203: nvl(p_rec.attribute2, hr_api.g_varchar2) or
204: nvl(ota_cpe_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

Line 202: nvl(ota_cpe_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

198: nvl(ota_cpe_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
199: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
200: nvl(ota_cpe_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
201: nvl(p_rec.attribute1, hr_api.g_varchar2) or
202: nvl(ota_cpe_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
203: nvl(p_rec.attribute2, hr_api.g_varchar2) or
204: nvl(ota_cpe_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
205: nvl(p_rec.attribute3, hr_api.g_varchar2) or
206: nvl(ota_cpe_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

Line 204: nvl(ota_cpe_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

200: nvl(ota_cpe_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
201: nvl(p_rec.attribute1, hr_api.g_varchar2) or
202: nvl(ota_cpe_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
203: nvl(p_rec.attribute2, hr_api.g_varchar2) or
204: nvl(ota_cpe_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
205: nvl(p_rec.attribute3, hr_api.g_varchar2) or
206: nvl(ota_cpe_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
207: nvl(p_rec.attribute4, hr_api.g_varchar2) or
208: nvl(ota_cpe_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

Line 206: nvl(ota_cpe_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

202: nvl(ota_cpe_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
203: nvl(p_rec.attribute2, hr_api.g_varchar2) or
204: nvl(ota_cpe_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
205: nvl(p_rec.attribute3, hr_api.g_varchar2) or
206: nvl(ota_cpe_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
207: nvl(p_rec.attribute4, hr_api.g_varchar2) or
208: nvl(ota_cpe_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
209: nvl(p_rec.attribute5, hr_api.g_varchar2) or
210: nvl(ota_cpe_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

Line 208: nvl(ota_cpe_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

204: nvl(ota_cpe_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
205: nvl(p_rec.attribute3, hr_api.g_varchar2) or
206: nvl(ota_cpe_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
207: nvl(p_rec.attribute4, hr_api.g_varchar2) or
208: nvl(ota_cpe_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
209: nvl(p_rec.attribute5, hr_api.g_varchar2) or
210: nvl(ota_cpe_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
211: nvl(p_rec.attribute6, hr_api.g_varchar2) or
212: nvl(ota_cpe_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

Line 210: nvl(ota_cpe_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

206: nvl(ota_cpe_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
207: nvl(p_rec.attribute4, hr_api.g_varchar2) or
208: nvl(ota_cpe_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
209: nvl(p_rec.attribute5, hr_api.g_varchar2) or
210: nvl(ota_cpe_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
211: nvl(p_rec.attribute6, hr_api.g_varchar2) or
212: nvl(ota_cpe_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
213: nvl(p_rec.attribute7, hr_api.g_varchar2) or
214: nvl(ota_cpe_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

Line 212: nvl(ota_cpe_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

208: nvl(ota_cpe_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
209: nvl(p_rec.attribute5, hr_api.g_varchar2) or
210: nvl(ota_cpe_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
211: nvl(p_rec.attribute6, hr_api.g_varchar2) or
212: nvl(ota_cpe_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
213: nvl(p_rec.attribute7, hr_api.g_varchar2) or
214: nvl(ota_cpe_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
215: nvl(p_rec.attribute8, hr_api.g_varchar2) or
216: nvl(ota_cpe_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

Line 214: nvl(ota_cpe_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

210: nvl(ota_cpe_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
211: nvl(p_rec.attribute6, hr_api.g_varchar2) or
212: nvl(ota_cpe_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
213: nvl(p_rec.attribute7, hr_api.g_varchar2) or
214: nvl(ota_cpe_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
215: nvl(p_rec.attribute8, hr_api.g_varchar2) or
216: nvl(ota_cpe_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
217: nvl(p_rec.attribute9, hr_api.g_varchar2) or
218: nvl(ota_cpe_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

Line 216: nvl(ota_cpe_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

212: nvl(ota_cpe_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
213: nvl(p_rec.attribute7, hr_api.g_varchar2) or
214: nvl(ota_cpe_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
215: nvl(p_rec.attribute8, hr_api.g_varchar2) or
216: nvl(ota_cpe_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
217: nvl(p_rec.attribute9, hr_api.g_varchar2) or
218: nvl(ota_cpe_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
219: nvl(p_rec.attribute10, hr_api.g_varchar2) or
220: nvl(ota_cpe_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

Line 218: nvl(ota_cpe_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

214: nvl(ota_cpe_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
215: nvl(p_rec.attribute8, hr_api.g_varchar2) or
216: nvl(ota_cpe_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
217: nvl(p_rec.attribute9, hr_api.g_varchar2) or
218: nvl(ota_cpe_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
219: nvl(p_rec.attribute10, hr_api.g_varchar2) or
220: nvl(ota_cpe_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
221: nvl(p_rec.attribute11, hr_api.g_varchar2) or
222: nvl(ota_cpe_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

Line 220: nvl(ota_cpe_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

216: nvl(ota_cpe_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
217: nvl(p_rec.attribute9, hr_api.g_varchar2) or
218: nvl(ota_cpe_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
219: nvl(p_rec.attribute10, hr_api.g_varchar2) or
220: nvl(ota_cpe_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
221: nvl(p_rec.attribute11, hr_api.g_varchar2) or
222: nvl(ota_cpe_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
223: nvl(p_rec.attribute12, hr_api.g_varchar2) or
224: nvl(ota_cpe_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

Line 222: nvl(ota_cpe_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

218: nvl(ota_cpe_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
219: nvl(p_rec.attribute10, hr_api.g_varchar2) or
220: nvl(ota_cpe_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
221: nvl(p_rec.attribute11, hr_api.g_varchar2) or
222: nvl(ota_cpe_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
223: nvl(p_rec.attribute12, hr_api.g_varchar2) or
224: nvl(ota_cpe_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
225: nvl(p_rec.attribute13, hr_api.g_varchar2) or
226: nvl(ota_cpe_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

Line 224: nvl(ota_cpe_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

220: nvl(ota_cpe_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
221: nvl(p_rec.attribute11, hr_api.g_varchar2) or
222: nvl(ota_cpe_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
223: nvl(p_rec.attribute12, hr_api.g_varchar2) or
224: nvl(ota_cpe_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
225: nvl(p_rec.attribute13, hr_api.g_varchar2) or
226: nvl(ota_cpe_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
227: nvl(p_rec.attribute14, hr_api.g_varchar2) or
228: nvl(ota_cpe_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

Line 226: nvl(ota_cpe_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

222: nvl(ota_cpe_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
223: nvl(p_rec.attribute12, hr_api.g_varchar2) or
224: nvl(ota_cpe_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
225: nvl(p_rec.attribute13, hr_api.g_varchar2) or
226: nvl(ota_cpe_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
227: nvl(p_rec.attribute14, hr_api.g_varchar2) or
228: nvl(ota_cpe_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
229: nvl(p_rec.attribute15, hr_api.g_varchar2) or
230: nvl(ota_cpe_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

Line 228: nvl(ota_cpe_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

224: nvl(ota_cpe_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
225: nvl(p_rec.attribute13, hr_api.g_varchar2) or
226: nvl(ota_cpe_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
227: nvl(p_rec.attribute14, hr_api.g_varchar2) or
228: nvl(ota_cpe_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
229: nvl(p_rec.attribute15, hr_api.g_varchar2) or
230: nvl(ota_cpe_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
231: nvl(p_rec.attribute16, hr_api.g_varchar2) or
232: nvl(ota_cpe_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

Line 230: nvl(ota_cpe_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

226: nvl(ota_cpe_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
227: nvl(p_rec.attribute14, hr_api.g_varchar2) or
228: nvl(ota_cpe_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
229: nvl(p_rec.attribute15, hr_api.g_varchar2) or
230: nvl(ota_cpe_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
231: nvl(p_rec.attribute16, hr_api.g_varchar2) or
232: nvl(ota_cpe_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
233: nvl(p_rec.attribute17, hr_api.g_varchar2) or
234: nvl(ota_cpe_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

Line 232: nvl(ota_cpe_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

228: nvl(ota_cpe_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
229: nvl(p_rec.attribute15, hr_api.g_varchar2) or
230: nvl(ota_cpe_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
231: nvl(p_rec.attribute16, hr_api.g_varchar2) or
232: nvl(ota_cpe_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
233: nvl(p_rec.attribute17, hr_api.g_varchar2) or
234: nvl(ota_cpe_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
235: nvl(p_rec.attribute18, hr_api.g_varchar2) or
236: nvl(ota_cpe_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

Line 234: nvl(ota_cpe_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

230: nvl(ota_cpe_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
231: nvl(p_rec.attribute16, hr_api.g_varchar2) or
232: nvl(ota_cpe_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
233: nvl(p_rec.attribute17, hr_api.g_varchar2) or
234: nvl(ota_cpe_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
235: nvl(p_rec.attribute18, hr_api.g_varchar2) or
236: nvl(ota_cpe_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
237: nvl(p_rec.attribute19, hr_api.g_varchar2) or
238: nvl(ota_cpe_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

Line 236: nvl(ota_cpe_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

232: nvl(ota_cpe_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
233: nvl(p_rec.attribute17, hr_api.g_varchar2) or
234: nvl(ota_cpe_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
235: nvl(p_rec.attribute18, hr_api.g_varchar2) or
236: nvl(ota_cpe_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
237: nvl(p_rec.attribute19, hr_api.g_varchar2) or
238: nvl(ota_cpe_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
239: nvl(p_rec.attribute20, hr_api.g_varchar2) ))
240: or (p_rec.cert_prd_enrollment_id is null) then

Line 238: nvl(ota_cpe_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

234: nvl(ota_cpe_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
235: nvl(p_rec.attribute18, hr_api.g_varchar2) or
236: nvl(ota_cpe_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
237: nvl(p_rec.attribute19, hr_api.g_varchar2) or
238: nvl(ota_cpe_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
239: nvl(p_rec.attribute20, hr_api.g_varchar2) ))
240: or (p_rec.cert_prd_enrollment_id is null) then
241: --
242: -- Only execute the validation if absolutely necessary:

Line 326: ,p_rec in ota_cpe_shd.g_rec_type

322: -- {End Of Comments}
323: -- ----------------------------------------------------------------------------
324: Procedure chk_non_updateable_args
325: (p_effective_date in date
326: ,p_rec in ota_cpe_shd.g_rec_type
327: ) IS
328: --
329: l_proc varchar2(72) := g_package || 'chk_non_updateable_args';
330: --

Line 336: IF NOT ota_cpe_shd.api_updating

332: --
333: -- Only proceed with the validation if a row exists for the current
334: -- record in the HR Schema.
335: --
336: IF NOT ota_cpe_shd.api_updating
337: (p_cert_prd_enrollment_id => p_rec.cert_prd_enrollment_id
338: ,p_object_version_number => p_rec.object_version_number
339: ) THEN
340: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');

Line 454: ,p_rec in ota_cpe_shd.g_rec_type

450: -- |---------------------------< insert_validate >----------------------------|
451: -- ----------------------------------------------------------------------------
452: Procedure insert_validate
453: (p_effective_date in date
454: ,p_rec in ota_cpe_shd.g_rec_type
455: ) is
456: --
457: l_proc varchar2(72) := g_package||'insert_validate';
458: --

Line 467: ,p_associated_column1 => ota_cpe_shd.g_tab_nam

463: --
464: -- Validate Important Attributes
465: hr_api.validate_bus_grp_id
466: (p_business_group_id => p_rec.business_group_id
467: ,p_associated_column1 => ota_cpe_shd.g_tab_nam
468: || '.BUSINESS_GROUP_ID');
469: --
470: -- After validating the set of important attributes,
471: -- if Multiple Message detection is enabled and at least

Line 494: ,p_rec in ota_cpe_shd.g_rec_type

490: -- |---------------------------< update_validate >----------------------------|
491: -- ----------------------------------------------------------------------------
492: Procedure update_validate
493: (p_effective_date in date
494: ,p_rec in ota_cpe_shd.g_rec_type
495: ) is
496: --
497: l_proc varchar2(72) := g_package||'update_validate';
498: --

Line 507: ,p_associated_column1 => ota_cpe_shd.g_tab_nam

503: --
504: -- Validate Important Attributes
505: hr_api.validate_bus_grp_id
506: (p_business_group_id => p_rec.business_group_id
507: ,p_associated_column1 => ota_cpe_shd.g_tab_nam
508: || '.BUSINESS_GROUP_ID');
509: --
510: -- After validating the set of important attributes,
511: -- if Multiple Message detection is enabled and at least

Line 535: (p_rec in ota_cpe_shd.g_rec_type

531: -- ----------------------------------------------------------------------------
532: -- |---------------------------< delete_validate >----------------------------|
533: -- ----------------------------------------------------------------------------
534: Procedure delete_validate
535: (p_rec in ota_cpe_shd.g_rec_type
536: ) is
537: --
538: l_proc varchar2(72) := g_package||'delete_validate';
539: --