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_LPE_BUS dependencies on OTA_LPE_SHD

Line 189: (p_rec in ota_lpe_shd.g_rec_type

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

252: nvl(ota_lpe_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
253: nvl(p_rec.attribute27, hr_api.g_varchar2) or
254: nvl(ota_lpe_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
255: nvl(p_rec.attribute28, hr_api.g_varchar2) or
256: nvl(ota_lpe_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
257: nvl(p_rec.attribute29, hr_api.g_varchar2) or
258: nvl(ota_lpe_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
259: nvl(p_rec.attribute30, hr_api.g_varchar2) ))
260: or (p_rec.lp_enrollment_id is null) then

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

254: nvl(ota_lpe_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
255: nvl(p_rec.attribute28, hr_api.g_varchar2) or
256: nvl(ota_lpe_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
257: nvl(p_rec.attribute29, hr_api.g_varchar2) or
258: nvl(ota_lpe_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
259: nvl(p_rec.attribute30, hr_api.g_varchar2) ))
260: or (p_rec.lp_enrollment_id is null) then
261: --
262: -- Only execute the validation if absolutely necessary:

Line 366: ,p_rec in ota_lpe_shd.g_rec_type

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

Line 376: IF NOT ota_lpe_shd.api_updating

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

Line 713: ,p_rec in ota_lpe_shd.g_rec_type

709: -- |-------------------------------------------------------|
710: -- ----------------------------------------------------------------------------
711: Procedure insert_validate
712: (p_effective_date in date
713: ,p_rec in ota_lpe_shd.g_rec_type
714: ) is
715: --
716: l_proc varchar2(72) := g_package||'insert_validate';
717: --

Line 725: ,p_associated_column1 => ota_lpe_shd.g_tab_nam

721: -- Call all supporting business operations
722: --
723: hr_api.validate_bus_grp_id
724: (p_business_group_id => p_rec.business_group_id
725: ,p_associated_column1 => ota_lpe_shd.g_tab_nam
726: || '.BUSINESS_GROUP_ID');
727: --
728: -- After validating the set of important attributes,
729: -- if Multiple Message detection is enabled and at least

Line 765: ,p_rec in ota_lpe_shd.g_rec_type

761: -- |---------------------------< update_validate >----------------------------|
762: -- ----------------------------------------------------------------------------
763: Procedure update_validate
764: (p_effective_date in date
765: ,p_rec in ota_lpe_shd.g_rec_type
766: ) is
767: --
768: l_proc varchar2(72) := g_package||'update_validate';
769: --

Line 777: ,p_associated_column1 => ota_lpe_shd.g_tab_nam

773: -- Call all supporting business operations
774: --
775: hr_api.validate_bus_grp_id
776: (p_business_group_id => p_rec.business_group_id
777: ,p_associated_column1 => ota_lpe_shd.g_tab_nam
778: || '.BUSINESS_GROUP_ID');
779: --
780: -- After validating the set of important attributes,
781: -- if Multiple Message detection is enabled and at least

Line 817: (p_rec in ota_lpe_shd.g_rec_type

813: -- ----------------------------------------------------------------------------
814: -- |---------------------------< delete_validate >----------------------------|
815: -- ----------------------------------------------------------------------------
816: Procedure delete_validate
817: (p_rec in ota_lpe_shd.g_rec_type
818: ) is
819: --
820: l_proc varchar2(72) := g_package||'delete_validate';
821: --