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_LME_BUS dependencies on OTA_LME_SHD

Line 189: (p_rec in ota_lme_shd.g_rec_type

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

232: nvl(ota_lme_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
233: nvl(p_rec.attribute17, hr_api.g_varchar2) or
234: nvl(ota_lme_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
235: nvl(p_rec.attribute18, hr_api.g_varchar2) or
236: nvl(ota_lme_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
237: nvl(p_rec.attribute19, hr_api.g_varchar2) or
238: nvl(ota_lme_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
239: nvl(p_rec.attribute20, hr_api.g_varchar2) or
240: nvl(ota_lme_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>

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

234: nvl(ota_lme_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
235: nvl(p_rec.attribute18, hr_api.g_varchar2) or
236: nvl(ota_lme_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
237: nvl(p_rec.attribute19, hr_api.g_varchar2) or
238: nvl(ota_lme_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
239: nvl(p_rec.attribute20, hr_api.g_varchar2) or
240: nvl(ota_lme_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
241: nvl(p_rec.attribute21, hr_api.g_varchar2) or
242: nvl(ota_lme_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>

Line 240: nvl(ota_lme_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>

236: nvl(ota_lme_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
237: nvl(p_rec.attribute19, hr_api.g_varchar2) or
238: nvl(ota_lme_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
239: nvl(p_rec.attribute20, hr_api.g_varchar2) or
240: nvl(ota_lme_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
241: nvl(p_rec.attribute21, hr_api.g_varchar2) or
242: nvl(ota_lme_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
243: nvl(p_rec.attribute22, hr_api.g_varchar2) or
244: nvl(ota_lme_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>

Line 242: nvl(ota_lme_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>

238: nvl(ota_lme_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
239: nvl(p_rec.attribute20, hr_api.g_varchar2) or
240: nvl(ota_lme_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
241: nvl(p_rec.attribute21, hr_api.g_varchar2) or
242: nvl(ota_lme_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
243: nvl(p_rec.attribute22, hr_api.g_varchar2) or
244: nvl(ota_lme_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
245: nvl(p_rec.attribute23, hr_api.g_varchar2) or
246: nvl(ota_lme_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>

Line 244: nvl(ota_lme_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>

240: nvl(ota_lme_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
241: nvl(p_rec.attribute21, hr_api.g_varchar2) or
242: nvl(ota_lme_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
243: nvl(p_rec.attribute22, hr_api.g_varchar2) or
244: nvl(ota_lme_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
245: nvl(p_rec.attribute23, hr_api.g_varchar2) or
246: nvl(ota_lme_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
247: nvl(p_rec.attribute24, hr_api.g_varchar2) or
248: nvl(ota_lme_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>

Line 246: nvl(ota_lme_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>

242: nvl(ota_lme_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
243: nvl(p_rec.attribute22, hr_api.g_varchar2) or
244: nvl(ota_lme_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
245: nvl(p_rec.attribute23, hr_api.g_varchar2) or
246: nvl(ota_lme_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
247: nvl(p_rec.attribute24, hr_api.g_varchar2) or
248: nvl(ota_lme_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
249: nvl(p_rec.attribute25, hr_api.g_varchar2) or
250: nvl(ota_lme_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>

Line 248: nvl(ota_lme_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>

244: nvl(ota_lme_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
245: nvl(p_rec.attribute23, hr_api.g_varchar2) or
246: nvl(ota_lme_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
247: nvl(p_rec.attribute24, hr_api.g_varchar2) or
248: nvl(ota_lme_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
249: nvl(p_rec.attribute25, hr_api.g_varchar2) or
250: nvl(ota_lme_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
251: nvl(p_rec.attribute26, hr_api.g_varchar2) or
252: nvl(ota_lme_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>

Line 250: nvl(ota_lme_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>

246: nvl(ota_lme_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
247: nvl(p_rec.attribute24, hr_api.g_varchar2) or
248: nvl(ota_lme_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
249: nvl(p_rec.attribute25, hr_api.g_varchar2) or
250: nvl(ota_lme_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
251: nvl(p_rec.attribute26, hr_api.g_varchar2) or
252: nvl(ota_lme_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
253: nvl(p_rec.attribute27, hr_api.g_varchar2) or
254: nvl(ota_lme_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>

Line 252: nvl(ota_lme_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>

248: nvl(ota_lme_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
249: nvl(p_rec.attribute25, hr_api.g_varchar2) or
250: nvl(ota_lme_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
251: nvl(p_rec.attribute26, hr_api.g_varchar2) or
252: nvl(ota_lme_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
253: nvl(p_rec.attribute27, hr_api.g_varchar2) or
254: nvl(ota_lme_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
255: nvl(p_rec.attribute28, hr_api.g_varchar2) or
256: nvl(ota_lme_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>

Line 254: nvl(ota_lme_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>

250: nvl(ota_lme_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
251: nvl(p_rec.attribute26, hr_api.g_varchar2) or
252: nvl(ota_lme_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
253: nvl(p_rec.attribute27, hr_api.g_varchar2) or
254: nvl(ota_lme_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
255: nvl(p_rec.attribute28, hr_api.g_varchar2) or
256: nvl(ota_lme_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
257: nvl(p_rec.attribute29, hr_api.g_varchar2) or
258: nvl(ota_lme_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>

Line 256: nvl(ota_lme_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>

252: nvl(ota_lme_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
253: nvl(p_rec.attribute27, hr_api.g_varchar2) or
254: nvl(ota_lme_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
255: nvl(p_rec.attribute28, hr_api.g_varchar2) or
256: nvl(ota_lme_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
257: nvl(p_rec.attribute29, hr_api.g_varchar2) or
258: nvl(ota_lme_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
259: nvl(p_rec.attribute30, hr_api.g_varchar2) ))
260: --Need not check creator_person_id

Line 258: nvl(ota_lme_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>

254: nvl(ota_lme_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
255: nvl(p_rec.attribute28, hr_api.g_varchar2) or
256: nvl(ota_lme_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
257: nvl(p_rec.attribute29, hr_api.g_varchar2) or
258: nvl(ota_lme_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
259: nvl(p_rec.attribute30, hr_api.g_varchar2) ))
260: --Need not check creator_person_id
261: /*or
262: nvl(ota_lme_shd.g_old_rec.creator_person_id, hr_api.g_varchar2) <>

Line 262: nvl(ota_lme_shd.g_old_rec.creator_person_id, hr_api.g_varchar2) <>

258: nvl(ota_lme_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
259: nvl(p_rec.attribute30, hr_api.g_varchar2) ))
260: --Need not check creator_person_id
261: /*or
262: nvl(ota_lme_shd.g_old_rec.creator_person_id, hr_api.g_varchar2) <>
263: nvl(p_rec.creator_person_id, hr_api.g_varchar2) ))
264: */
265: or (p_rec.lp_member_enrollment_id is null) then
266: --

Line 371: ,p_rec in ota_lme_shd.g_rec_type

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

Line 381: IF NOT ota_lme_shd.api_updating

377: --
378: -- Only proceed with the validation if a row exists for the current
379: -- record in the HR Schema.
380: --
381: IF NOT ota_lme_shd.api_updating
382: (p_lp_member_enrollment_id => p_rec.lp_member_enrollment_id
383: ,p_object_version_number => p_rec.object_version_number
384: ) THEN
385: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');

Line 419: l_api_updating := ota_lme_shd.api_updating

415: (p_api_name => l_proc
416: ,p_argument => 'effective_date'
417: ,p_argument_value => p_effective_date);
418:
419: l_api_updating := ota_lme_shd.api_updating
420: (p_lp_member_enrollment_id => p_lp_member_enrollment_id
421: ,p_object_version_number => p_object_version_number);
422:
423:

Line 425: NVL(ota_lme_shd.g_old_rec.member_status_code,hr_api.g_varchar2) <>

421: ,p_object_version_number => p_object_version_number);
422:
423:
424: IF ((l_api_updating AND
425: NVL(ota_lme_shd.g_old_rec.member_status_code,hr_api.g_varchar2) <>
426: NVL(p_member_status_code, hr_api.g_varchar2))
427: OR NOT l_api_updating AND p_member_status_code IS NOT NULL) THEN
428:
429: hr_utility.set_location(' Leaving:'||l_proc, 20);

Line 505: ,p_rec in ota_lme_shd.g_rec_type

501: -- |---------------------------< insert_validate >----------------------------|
502: -- ----------------------------------------------------------------------------
503: Procedure insert_validate
504: (p_effective_date in date
505: ,p_rec in ota_lme_shd.g_rec_type
506: ) is
507: --
508: l_proc varchar2(72) := g_package||'insert_validate';
509: --

Line 517: ,p_associated_column1 => ota_lme_shd.g_tab_nam

513: -- Call all supporting business operations
514: --
515: hr_api.validate_bus_grp_id
516: (p_business_group_id => p_rec.business_group_id
517: ,p_associated_column1 => ota_lme_shd.g_tab_nam
518: || '.BUSINESS_GROUP_ID');
519: --
520: -- After validating the set of important attributes,
521: -- if Multiple Message detection is enabled and at least

Line 541: ,p_rec in ota_lme_shd.g_rec_type

537: -- |---------------------------< update_validate >----------------------------|
538: -- ----------------------------------------------------------------------------
539: Procedure update_validate
540: (p_effective_date in date
541: ,p_rec in ota_lme_shd.g_rec_type
542: ) is
543: --
544: l_proc varchar2(72) := g_package||'update_validate';
545: --

Line 553: ,p_associated_column1 => ota_lme_shd.g_tab_nam

549: -- Call all supporting business operations
550: --
551: hr_api.validate_bus_grp_id
552: (p_business_group_id => p_rec.business_group_id
553: ,p_associated_column1 => ota_lme_shd.g_tab_nam
554: || '.BUSINESS_GROUP_ID');
555: --
556: -- After validating the set of important attributes,
557: -- if Multiple Message detection is enabled and at least

Line 581: (p_rec in ota_lme_shd.g_rec_type

577: -- ----------------------------------------------------------------------------
578: -- |---------------------------< delete_validate >----------------------------|
579: -- ----------------------------------------------------------------------------
580: Procedure delete_validate
581: (p_rec in ota_lme_shd.g_rec_type
582: ) is
583: --
584: l_proc varchar2(72) := g_package||'delete_validate';
585: --