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_CME_BUS dependencies on OTA_CME_SHD

Line 189: (p_rec in ota_cme_shd.g_rec_type

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

Line 198: nvl(ota_cme_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_mbr_enrollment_id is not null) and (
198: nvl(ota_cme_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
199: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
200: nvl(ota_cme_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
201: nvl(p_rec.attribute1, hr_api.g_varchar2) or
202: nvl(ota_cme_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 326: ,p_rec in ota_cme_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_cme_shd.g_rec_type
327: ) IS
328: --
329: l_proc varchar2(72) := g_package || 'chk_non_updateable_args';
330: --

Line 336: IF NOT ota_cme_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_cme_shd.api_updating
337: (p_cert_mbr_enrollment_id => p_rec.cert_mbr_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 373: l_api_updating := ota_cme_shd.api_updating

369: (p_api_name => l_proc
370: ,p_argument => 'effective_date'
371: ,p_argument_value => p_effective_date);
372:
373: l_api_updating := ota_cme_shd.api_updating
374: (p_cert_mbr_enrollment_id => p_cert_mbr_enrollment_id
375: ,p_object_version_number => p_object_version_number);
376:
377:

Line 379: NVL(ota_cme_shd.g_old_rec.member_status_code,hr_api.g_varchar2) <>

375: ,p_object_version_number => p_object_version_number);
376:
377:
378: IF ((l_api_updating AND
379: NVL(ota_cme_shd.g_old_rec.member_status_code,hr_api.g_varchar2) <>
380: NVL(p_member_status_code, hr_api.g_varchar2))
381: OR NOT l_api_updating AND p_member_status_code IS NOT NULL) THEN
382:
383: hr_utility.set_location(' Leaving:'||l_proc, 20);

Line 421: ,p_rec in ota_cme_shd.g_rec_type

417: -- |---------------------------< insert_validate >----------------------------|
418: -- ----------------------------------------------------------------------------
419: Procedure insert_validate
420: (p_effective_date in date
421: ,p_rec in ota_cme_shd.g_rec_type
422: ) is
423: --
424: l_proc varchar2(72) := g_package||'insert_validate';
425: --

Line 434: ,p_associated_column1 => ota_cme_shd.g_tab_nam

430: --
431: -- Validate Important Attributes
432: hr_api.validate_bus_grp_id
433: (p_business_group_id => p_rec.business_group_id
434: ,p_associated_column1 => ota_cme_shd.g_tab_nam
435: || '.BUSINESS_GROUP_ID');
436: --
437: -- After validating the set of important attributes,
438: -- if Multiple Message detection is enabled and at least

Line 456: ,p_rec in ota_cme_shd.g_rec_type

452: -- |---------------------------< update_validate >----------------------------|
453: -- ----------------------------------------------------------------------------
454: Procedure update_validate
455: (p_effective_date in date
456: ,p_rec in ota_cme_shd.g_rec_type
457: ) is
458: --
459: l_proc varchar2(72) := g_package||'update_validate';
460: --

Line 469: ,p_associated_column1 => ota_cme_shd.g_tab_nam

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

Line 495: (p_rec in ota_cme_shd.g_rec_type

491: -- ----------------------------------------------------------------------------
492: -- |---------------------------< delete_validate >----------------------------|
493: -- ----------------------------------------------------------------------------
494: Procedure delete_validate
495: (p_rec in ota_cme_shd.g_rec_type
496: ) is
497: --
498: l_proc varchar2(72) := g_package||'delete_validate';
499: --