APPS.BEN_CSO_BUS dependencies on BEN_CSO_SHD

Line 279: (p_rec in ben_cso_shd.g_rec_type

275: -- Internal Row Handler Use Only.
276: --
277: -- ----------------------------------------------------------------------------
278: procedure chk_df
279: (p_rec in ben_cso_shd.g_rec_type
280: ) is
281: --
282: l_proc varchar2(72) := g_package || 'chk_df';
283: --

Line 288: nvl(ben_cso_shd.g_old_rec.cso_attribute_category, hr_api.g_varchar2) <>

284: begin
285: hr_utility.set_location('Entering:'||l_proc,10);
286: --
287: if ((p_rec.cwb_stock_optn_dtls_id is not null) and (
288: nvl(ben_cso_shd.g_old_rec.cso_attribute_category, hr_api.g_varchar2) <>
289: nvl(p_rec.cso_attribute_category, hr_api.g_varchar2) or
290: nvl(ben_cso_shd.g_old_rec.cso_attribute1, hr_api.g_varchar2) <>
291: nvl(p_rec.cso_attribute1, hr_api.g_varchar2) or
292: nvl(ben_cso_shd.g_old_rec.cso_attribute2, hr_api.g_varchar2) <>

Line 290: nvl(ben_cso_shd.g_old_rec.cso_attribute1, hr_api.g_varchar2) <>

286: --
287: if ((p_rec.cwb_stock_optn_dtls_id is not null) and (
288: nvl(ben_cso_shd.g_old_rec.cso_attribute_category, hr_api.g_varchar2) <>
289: nvl(p_rec.cso_attribute_category, hr_api.g_varchar2) or
290: nvl(ben_cso_shd.g_old_rec.cso_attribute1, hr_api.g_varchar2) <>
291: nvl(p_rec.cso_attribute1, hr_api.g_varchar2) or
292: nvl(ben_cso_shd.g_old_rec.cso_attribute2, hr_api.g_varchar2) <>
293: nvl(p_rec.cso_attribute2, hr_api.g_varchar2) or
294: nvl(ben_cso_shd.g_old_rec.cso_attribute3, hr_api.g_varchar2) <>

Line 292: nvl(ben_cso_shd.g_old_rec.cso_attribute2, hr_api.g_varchar2) <>

288: nvl(ben_cso_shd.g_old_rec.cso_attribute_category, hr_api.g_varchar2) <>
289: nvl(p_rec.cso_attribute_category, hr_api.g_varchar2) or
290: nvl(ben_cso_shd.g_old_rec.cso_attribute1, hr_api.g_varchar2) <>
291: nvl(p_rec.cso_attribute1, hr_api.g_varchar2) or
292: nvl(ben_cso_shd.g_old_rec.cso_attribute2, hr_api.g_varchar2) <>
293: nvl(p_rec.cso_attribute2, hr_api.g_varchar2) or
294: nvl(ben_cso_shd.g_old_rec.cso_attribute3, hr_api.g_varchar2) <>
295: nvl(p_rec.cso_attribute3, hr_api.g_varchar2) or
296: nvl(ben_cso_shd.g_old_rec.cso_attribute4, hr_api.g_varchar2) <>

Line 294: nvl(ben_cso_shd.g_old_rec.cso_attribute3, hr_api.g_varchar2) <>

290: nvl(ben_cso_shd.g_old_rec.cso_attribute1, hr_api.g_varchar2) <>
291: nvl(p_rec.cso_attribute1, hr_api.g_varchar2) or
292: nvl(ben_cso_shd.g_old_rec.cso_attribute2, hr_api.g_varchar2) <>
293: nvl(p_rec.cso_attribute2, hr_api.g_varchar2) or
294: nvl(ben_cso_shd.g_old_rec.cso_attribute3, hr_api.g_varchar2) <>
295: nvl(p_rec.cso_attribute3, hr_api.g_varchar2) or
296: nvl(ben_cso_shd.g_old_rec.cso_attribute4, hr_api.g_varchar2) <>
297: nvl(p_rec.cso_attribute4, hr_api.g_varchar2) or
298: nvl(ben_cso_shd.g_old_rec.cso_attribute5, hr_api.g_varchar2) <>

Line 296: nvl(ben_cso_shd.g_old_rec.cso_attribute4, hr_api.g_varchar2) <>

292: nvl(ben_cso_shd.g_old_rec.cso_attribute2, hr_api.g_varchar2) <>
293: nvl(p_rec.cso_attribute2, hr_api.g_varchar2) or
294: nvl(ben_cso_shd.g_old_rec.cso_attribute3, hr_api.g_varchar2) <>
295: nvl(p_rec.cso_attribute3, hr_api.g_varchar2) or
296: nvl(ben_cso_shd.g_old_rec.cso_attribute4, hr_api.g_varchar2) <>
297: nvl(p_rec.cso_attribute4, hr_api.g_varchar2) or
298: nvl(ben_cso_shd.g_old_rec.cso_attribute5, hr_api.g_varchar2) <>
299: nvl(p_rec.cso_attribute5, hr_api.g_varchar2) or
300: nvl(ben_cso_shd.g_old_rec.cso_attribute6, hr_api.g_varchar2) <>

Line 298: nvl(ben_cso_shd.g_old_rec.cso_attribute5, hr_api.g_varchar2) <>

294: nvl(ben_cso_shd.g_old_rec.cso_attribute3, hr_api.g_varchar2) <>
295: nvl(p_rec.cso_attribute3, hr_api.g_varchar2) or
296: nvl(ben_cso_shd.g_old_rec.cso_attribute4, hr_api.g_varchar2) <>
297: nvl(p_rec.cso_attribute4, hr_api.g_varchar2) or
298: nvl(ben_cso_shd.g_old_rec.cso_attribute5, hr_api.g_varchar2) <>
299: nvl(p_rec.cso_attribute5, hr_api.g_varchar2) or
300: nvl(ben_cso_shd.g_old_rec.cso_attribute6, hr_api.g_varchar2) <>
301: nvl(p_rec.cso_attribute6, hr_api.g_varchar2) or
302: nvl(ben_cso_shd.g_old_rec.cso_attribute7, hr_api.g_varchar2) <>

Line 300: nvl(ben_cso_shd.g_old_rec.cso_attribute6, hr_api.g_varchar2) <>

296: nvl(ben_cso_shd.g_old_rec.cso_attribute4, hr_api.g_varchar2) <>
297: nvl(p_rec.cso_attribute4, hr_api.g_varchar2) or
298: nvl(ben_cso_shd.g_old_rec.cso_attribute5, hr_api.g_varchar2) <>
299: nvl(p_rec.cso_attribute5, hr_api.g_varchar2) or
300: nvl(ben_cso_shd.g_old_rec.cso_attribute6, hr_api.g_varchar2) <>
301: nvl(p_rec.cso_attribute6, hr_api.g_varchar2) or
302: nvl(ben_cso_shd.g_old_rec.cso_attribute7, hr_api.g_varchar2) <>
303: nvl(p_rec.cso_attribute7, hr_api.g_varchar2) or
304: nvl(ben_cso_shd.g_old_rec.cso_attribute8, hr_api.g_varchar2) <>

Line 302: nvl(ben_cso_shd.g_old_rec.cso_attribute7, hr_api.g_varchar2) <>

298: nvl(ben_cso_shd.g_old_rec.cso_attribute5, hr_api.g_varchar2) <>
299: nvl(p_rec.cso_attribute5, hr_api.g_varchar2) or
300: nvl(ben_cso_shd.g_old_rec.cso_attribute6, hr_api.g_varchar2) <>
301: nvl(p_rec.cso_attribute6, hr_api.g_varchar2) or
302: nvl(ben_cso_shd.g_old_rec.cso_attribute7, hr_api.g_varchar2) <>
303: nvl(p_rec.cso_attribute7, hr_api.g_varchar2) or
304: nvl(ben_cso_shd.g_old_rec.cso_attribute8, hr_api.g_varchar2) <>
305: nvl(p_rec.cso_attribute8, hr_api.g_varchar2) or
306: nvl(ben_cso_shd.g_old_rec.cso_attribute9, hr_api.g_varchar2) <>

Line 304: nvl(ben_cso_shd.g_old_rec.cso_attribute8, hr_api.g_varchar2) <>

300: nvl(ben_cso_shd.g_old_rec.cso_attribute6, hr_api.g_varchar2) <>
301: nvl(p_rec.cso_attribute6, hr_api.g_varchar2) or
302: nvl(ben_cso_shd.g_old_rec.cso_attribute7, hr_api.g_varchar2) <>
303: nvl(p_rec.cso_attribute7, hr_api.g_varchar2) or
304: nvl(ben_cso_shd.g_old_rec.cso_attribute8, hr_api.g_varchar2) <>
305: nvl(p_rec.cso_attribute8, hr_api.g_varchar2) or
306: nvl(ben_cso_shd.g_old_rec.cso_attribute9, hr_api.g_varchar2) <>
307: nvl(p_rec.cso_attribute9, hr_api.g_varchar2) or
308: nvl(ben_cso_shd.g_old_rec.cso_attribute10, hr_api.g_varchar2) <>

Line 306: nvl(ben_cso_shd.g_old_rec.cso_attribute9, hr_api.g_varchar2) <>

302: nvl(ben_cso_shd.g_old_rec.cso_attribute7, hr_api.g_varchar2) <>
303: nvl(p_rec.cso_attribute7, hr_api.g_varchar2) or
304: nvl(ben_cso_shd.g_old_rec.cso_attribute8, hr_api.g_varchar2) <>
305: nvl(p_rec.cso_attribute8, hr_api.g_varchar2) or
306: nvl(ben_cso_shd.g_old_rec.cso_attribute9, hr_api.g_varchar2) <>
307: nvl(p_rec.cso_attribute9, hr_api.g_varchar2) or
308: nvl(ben_cso_shd.g_old_rec.cso_attribute10, hr_api.g_varchar2) <>
309: nvl(p_rec.cso_attribute10, hr_api.g_varchar2) or
310: nvl(ben_cso_shd.g_old_rec.cso_attribute11, hr_api.g_varchar2) <>

Line 308: nvl(ben_cso_shd.g_old_rec.cso_attribute10, hr_api.g_varchar2) <>

304: nvl(ben_cso_shd.g_old_rec.cso_attribute8, hr_api.g_varchar2) <>
305: nvl(p_rec.cso_attribute8, hr_api.g_varchar2) or
306: nvl(ben_cso_shd.g_old_rec.cso_attribute9, hr_api.g_varchar2) <>
307: nvl(p_rec.cso_attribute9, hr_api.g_varchar2) or
308: nvl(ben_cso_shd.g_old_rec.cso_attribute10, hr_api.g_varchar2) <>
309: nvl(p_rec.cso_attribute10, hr_api.g_varchar2) or
310: nvl(ben_cso_shd.g_old_rec.cso_attribute11, hr_api.g_varchar2) <>
311: nvl(p_rec.cso_attribute11, hr_api.g_varchar2) or
312: nvl(ben_cso_shd.g_old_rec.cso_attribute12, hr_api.g_varchar2) <>

Line 310: nvl(ben_cso_shd.g_old_rec.cso_attribute11, hr_api.g_varchar2) <>

306: nvl(ben_cso_shd.g_old_rec.cso_attribute9, hr_api.g_varchar2) <>
307: nvl(p_rec.cso_attribute9, hr_api.g_varchar2) or
308: nvl(ben_cso_shd.g_old_rec.cso_attribute10, hr_api.g_varchar2) <>
309: nvl(p_rec.cso_attribute10, hr_api.g_varchar2) or
310: nvl(ben_cso_shd.g_old_rec.cso_attribute11, hr_api.g_varchar2) <>
311: nvl(p_rec.cso_attribute11, hr_api.g_varchar2) or
312: nvl(ben_cso_shd.g_old_rec.cso_attribute12, hr_api.g_varchar2) <>
313: nvl(p_rec.cso_attribute12, hr_api.g_varchar2) or
314: nvl(ben_cso_shd.g_old_rec.cso_attribute13, hr_api.g_varchar2) <>

Line 312: nvl(ben_cso_shd.g_old_rec.cso_attribute12, hr_api.g_varchar2) <>

308: nvl(ben_cso_shd.g_old_rec.cso_attribute10, hr_api.g_varchar2) <>
309: nvl(p_rec.cso_attribute10, hr_api.g_varchar2) or
310: nvl(ben_cso_shd.g_old_rec.cso_attribute11, hr_api.g_varchar2) <>
311: nvl(p_rec.cso_attribute11, hr_api.g_varchar2) or
312: nvl(ben_cso_shd.g_old_rec.cso_attribute12, hr_api.g_varchar2) <>
313: nvl(p_rec.cso_attribute12, hr_api.g_varchar2) or
314: nvl(ben_cso_shd.g_old_rec.cso_attribute13, hr_api.g_varchar2) <>
315: nvl(p_rec.cso_attribute13, hr_api.g_varchar2) or
316: nvl(ben_cso_shd.g_old_rec.cso_attribute14, hr_api.g_varchar2) <>

Line 314: nvl(ben_cso_shd.g_old_rec.cso_attribute13, hr_api.g_varchar2) <>

310: nvl(ben_cso_shd.g_old_rec.cso_attribute11, hr_api.g_varchar2) <>
311: nvl(p_rec.cso_attribute11, hr_api.g_varchar2) or
312: nvl(ben_cso_shd.g_old_rec.cso_attribute12, hr_api.g_varchar2) <>
313: nvl(p_rec.cso_attribute12, hr_api.g_varchar2) or
314: nvl(ben_cso_shd.g_old_rec.cso_attribute13, hr_api.g_varchar2) <>
315: nvl(p_rec.cso_attribute13, hr_api.g_varchar2) or
316: nvl(ben_cso_shd.g_old_rec.cso_attribute14, hr_api.g_varchar2) <>
317: nvl(p_rec.cso_attribute14, hr_api.g_varchar2) or
318: nvl(ben_cso_shd.g_old_rec.cso_attribute15, hr_api.g_varchar2) <>

Line 316: nvl(ben_cso_shd.g_old_rec.cso_attribute14, hr_api.g_varchar2) <>

312: nvl(ben_cso_shd.g_old_rec.cso_attribute12, hr_api.g_varchar2) <>
313: nvl(p_rec.cso_attribute12, hr_api.g_varchar2) or
314: nvl(ben_cso_shd.g_old_rec.cso_attribute13, hr_api.g_varchar2) <>
315: nvl(p_rec.cso_attribute13, hr_api.g_varchar2) or
316: nvl(ben_cso_shd.g_old_rec.cso_attribute14, hr_api.g_varchar2) <>
317: nvl(p_rec.cso_attribute14, hr_api.g_varchar2) or
318: nvl(ben_cso_shd.g_old_rec.cso_attribute15, hr_api.g_varchar2) <>
319: nvl(p_rec.cso_attribute15, hr_api.g_varchar2) or
320: nvl(ben_cso_shd.g_old_rec.cso_attribute16, hr_api.g_varchar2) <>

Line 318: nvl(ben_cso_shd.g_old_rec.cso_attribute15, hr_api.g_varchar2) <>

314: nvl(ben_cso_shd.g_old_rec.cso_attribute13, hr_api.g_varchar2) <>
315: nvl(p_rec.cso_attribute13, hr_api.g_varchar2) or
316: nvl(ben_cso_shd.g_old_rec.cso_attribute14, hr_api.g_varchar2) <>
317: nvl(p_rec.cso_attribute14, hr_api.g_varchar2) or
318: nvl(ben_cso_shd.g_old_rec.cso_attribute15, hr_api.g_varchar2) <>
319: nvl(p_rec.cso_attribute15, hr_api.g_varchar2) or
320: nvl(ben_cso_shd.g_old_rec.cso_attribute16, hr_api.g_varchar2) <>
321: nvl(p_rec.cso_attribute16, hr_api.g_varchar2) or
322: nvl(ben_cso_shd.g_old_rec.cso_attribute17, hr_api.g_varchar2) <>

Line 320: nvl(ben_cso_shd.g_old_rec.cso_attribute16, hr_api.g_varchar2) <>

316: nvl(ben_cso_shd.g_old_rec.cso_attribute14, hr_api.g_varchar2) <>
317: nvl(p_rec.cso_attribute14, hr_api.g_varchar2) or
318: nvl(ben_cso_shd.g_old_rec.cso_attribute15, hr_api.g_varchar2) <>
319: nvl(p_rec.cso_attribute15, hr_api.g_varchar2) or
320: nvl(ben_cso_shd.g_old_rec.cso_attribute16, hr_api.g_varchar2) <>
321: nvl(p_rec.cso_attribute16, hr_api.g_varchar2) or
322: nvl(ben_cso_shd.g_old_rec.cso_attribute17, hr_api.g_varchar2) <>
323: nvl(p_rec.cso_attribute17, hr_api.g_varchar2) or
324: nvl(ben_cso_shd.g_old_rec.cso_attribute18, hr_api.g_varchar2) <>

Line 322: nvl(ben_cso_shd.g_old_rec.cso_attribute17, hr_api.g_varchar2) <>

318: nvl(ben_cso_shd.g_old_rec.cso_attribute15, hr_api.g_varchar2) <>
319: nvl(p_rec.cso_attribute15, hr_api.g_varchar2) or
320: nvl(ben_cso_shd.g_old_rec.cso_attribute16, hr_api.g_varchar2) <>
321: nvl(p_rec.cso_attribute16, hr_api.g_varchar2) or
322: nvl(ben_cso_shd.g_old_rec.cso_attribute17, hr_api.g_varchar2) <>
323: nvl(p_rec.cso_attribute17, hr_api.g_varchar2) or
324: nvl(ben_cso_shd.g_old_rec.cso_attribute18, hr_api.g_varchar2) <>
325: nvl(p_rec.cso_attribute18, hr_api.g_varchar2) or
326: nvl(ben_cso_shd.g_old_rec.cso_attribute19, hr_api.g_varchar2) <>

Line 324: nvl(ben_cso_shd.g_old_rec.cso_attribute18, hr_api.g_varchar2) <>

320: nvl(ben_cso_shd.g_old_rec.cso_attribute16, hr_api.g_varchar2) <>
321: nvl(p_rec.cso_attribute16, hr_api.g_varchar2) or
322: nvl(ben_cso_shd.g_old_rec.cso_attribute17, hr_api.g_varchar2) <>
323: nvl(p_rec.cso_attribute17, hr_api.g_varchar2) or
324: nvl(ben_cso_shd.g_old_rec.cso_attribute18, hr_api.g_varchar2) <>
325: nvl(p_rec.cso_attribute18, hr_api.g_varchar2) or
326: nvl(ben_cso_shd.g_old_rec.cso_attribute19, hr_api.g_varchar2) <>
327: nvl(p_rec.cso_attribute19, hr_api.g_varchar2) or
328: nvl(ben_cso_shd.g_old_rec.cso_attribute20, hr_api.g_varchar2) <>

Line 326: nvl(ben_cso_shd.g_old_rec.cso_attribute19, hr_api.g_varchar2) <>

322: nvl(ben_cso_shd.g_old_rec.cso_attribute17, hr_api.g_varchar2) <>
323: nvl(p_rec.cso_attribute17, hr_api.g_varchar2) or
324: nvl(ben_cso_shd.g_old_rec.cso_attribute18, hr_api.g_varchar2) <>
325: nvl(p_rec.cso_attribute18, hr_api.g_varchar2) or
326: nvl(ben_cso_shd.g_old_rec.cso_attribute19, hr_api.g_varchar2) <>
327: nvl(p_rec.cso_attribute19, hr_api.g_varchar2) or
328: nvl(ben_cso_shd.g_old_rec.cso_attribute20, hr_api.g_varchar2) <>
329: nvl(p_rec.cso_attribute20, hr_api.g_varchar2) or
330: nvl(ben_cso_shd.g_old_rec.cso_attribute21, hr_api.g_varchar2) <>

Line 328: nvl(ben_cso_shd.g_old_rec.cso_attribute20, hr_api.g_varchar2) <>

324: nvl(ben_cso_shd.g_old_rec.cso_attribute18, hr_api.g_varchar2) <>
325: nvl(p_rec.cso_attribute18, hr_api.g_varchar2) or
326: nvl(ben_cso_shd.g_old_rec.cso_attribute19, hr_api.g_varchar2) <>
327: nvl(p_rec.cso_attribute19, hr_api.g_varchar2) or
328: nvl(ben_cso_shd.g_old_rec.cso_attribute20, hr_api.g_varchar2) <>
329: nvl(p_rec.cso_attribute20, hr_api.g_varchar2) or
330: nvl(ben_cso_shd.g_old_rec.cso_attribute21, hr_api.g_varchar2) <>
331: nvl(p_rec.cso_attribute21, hr_api.g_varchar2) or
332: nvl(ben_cso_shd.g_old_rec.cso_attribute22, hr_api.g_varchar2) <>

Line 330: nvl(ben_cso_shd.g_old_rec.cso_attribute21, hr_api.g_varchar2) <>

326: nvl(ben_cso_shd.g_old_rec.cso_attribute19, hr_api.g_varchar2) <>
327: nvl(p_rec.cso_attribute19, hr_api.g_varchar2) or
328: nvl(ben_cso_shd.g_old_rec.cso_attribute20, hr_api.g_varchar2) <>
329: nvl(p_rec.cso_attribute20, hr_api.g_varchar2) or
330: nvl(ben_cso_shd.g_old_rec.cso_attribute21, hr_api.g_varchar2) <>
331: nvl(p_rec.cso_attribute21, hr_api.g_varchar2) or
332: nvl(ben_cso_shd.g_old_rec.cso_attribute22, hr_api.g_varchar2) <>
333: nvl(p_rec.cso_attribute22, hr_api.g_varchar2) or
334: nvl(ben_cso_shd.g_old_rec.cso_attribute23, hr_api.g_varchar2) <>

Line 332: nvl(ben_cso_shd.g_old_rec.cso_attribute22, hr_api.g_varchar2) <>

328: nvl(ben_cso_shd.g_old_rec.cso_attribute20, hr_api.g_varchar2) <>
329: nvl(p_rec.cso_attribute20, hr_api.g_varchar2) or
330: nvl(ben_cso_shd.g_old_rec.cso_attribute21, hr_api.g_varchar2) <>
331: nvl(p_rec.cso_attribute21, hr_api.g_varchar2) or
332: nvl(ben_cso_shd.g_old_rec.cso_attribute22, hr_api.g_varchar2) <>
333: nvl(p_rec.cso_attribute22, hr_api.g_varchar2) or
334: nvl(ben_cso_shd.g_old_rec.cso_attribute23, hr_api.g_varchar2) <>
335: nvl(p_rec.cso_attribute23, hr_api.g_varchar2) or
336: nvl(ben_cso_shd.g_old_rec.cso_attribute24, hr_api.g_varchar2) <>

Line 334: nvl(ben_cso_shd.g_old_rec.cso_attribute23, hr_api.g_varchar2) <>

330: nvl(ben_cso_shd.g_old_rec.cso_attribute21, hr_api.g_varchar2) <>
331: nvl(p_rec.cso_attribute21, hr_api.g_varchar2) or
332: nvl(ben_cso_shd.g_old_rec.cso_attribute22, hr_api.g_varchar2) <>
333: nvl(p_rec.cso_attribute22, hr_api.g_varchar2) or
334: nvl(ben_cso_shd.g_old_rec.cso_attribute23, hr_api.g_varchar2) <>
335: nvl(p_rec.cso_attribute23, hr_api.g_varchar2) or
336: nvl(ben_cso_shd.g_old_rec.cso_attribute24, hr_api.g_varchar2) <>
337: nvl(p_rec.cso_attribute24, hr_api.g_varchar2) or
338: nvl(ben_cso_shd.g_old_rec.cso_attribute25, hr_api.g_varchar2) <>

Line 336: nvl(ben_cso_shd.g_old_rec.cso_attribute24, hr_api.g_varchar2) <>

332: nvl(ben_cso_shd.g_old_rec.cso_attribute22, hr_api.g_varchar2) <>
333: nvl(p_rec.cso_attribute22, hr_api.g_varchar2) or
334: nvl(ben_cso_shd.g_old_rec.cso_attribute23, hr_api.g_varchar2) <>
335: nvl(p_rec.cso_attribute23, hr_api.g_varchar2) or
336: nvl(ben_cso_shd.g_old_rec.cso_attribute24, hr_api.g_varchar2) <>
337: nvl(p_rec.cso_attribute24, hr_api.g_varchar2) or
338: nvl(ben_cso_shd.g_old_rec.cso_attribute25, hr_api.g_varchar2) <>
339: nvl(p_rec.cso_attribute25, hr_api.g_varchar2) or
340: nvl(ben_cso_shd.g_old_rec.cso_attribute26, hr_api.g_varchar2) <>

Line 338: nvl(ben_cso_shd.g_old_rec.cso_attribute25, hr_api.g_varchar2) <>

334: nvl(ben_cso_shd.g_old_rec.cso_attribute23, hr_api.g_varchar2) <>
335: nvl(p_rec.cso_attribute23, hr_api.g_varchar2) or
336: nvl(ben_cso_shd.g_old_rec.cso_attribute24, hr_api.g_varchar2) <>
337: nvl(p_rec.cso_attribute24, hr_api.g_varchar2) or
338: nvl(ben_cso_shd.g_old_rec.cso_attribute25, hr_api.g_varchar2) <>
339: nvl(p_rec.cso_attribute25, hr_api.g_varchar2) or
340: nvl(ben_cso_shd.g_old_rec.cso_attribute26, hr_api.g_varchar2) <>
341: nvl(p_rec.cso_attribute26, hr_api.g_varchar2) or
342: nvl(ben_cso_shd.g_old_rec.cso_attribute27, hr_api.g_varchar2) <>

Line 340: nvl(ben_cso_shd.g_old_rec.cso_attribute26, hr_api.g_varchar2) <>

336: nvl(ben_cso_shd.g_old_rec.cso_attribute24, hr_api.g_varchar2) <>
337: nvl(p_rec.cso_attribute24, hr_api.g_varchar2) or
338: nvl(ben_cso_shd.g_old_rec.cso_attribute25, hr_api.g_varchar2) <>
339: nvl(p_rec.cso_attribute25, hr_api.g_varchar2) or
340: nvl(ben_cso_shd.g_old_rec.cso_attribute26, hr_api.g_varchar2) <>
341: nvl(p_rec.cso_attribute26, hr_api.g_varchar2) or
342: nvl(ben_cso_shd.g_old_rec.cso_attribute27, hr_api.g_varchar2) <>
343: nvl(p_rec.cso_attribute27, hr_api.g_varchar2) or
344: nvl(ben_cso_shd.g_old_rec.cso_attribute28, hr_api.g_varchar2) <>

Line 342: nvl(ben_cso_shd.g_old_rec.cso_attribute27, hr_api.g_varchar2) <>

338: nvl(ben_cso_shd.g_old_rec.cso_attribute25, hr_api.g_varchar2) <>
339: nvl(p_rec.cso_attribute25, hr_api.g_varchar2) or
340: nvl(ben_cso_shd.g_old_rec.cso_attribute26, hr_api.g_varchar2) <>
341: nvl(p_rec.cso_attribute26, hr_api.g_varchar2) or
342: nvl(ben_cso_shd.g_old_rec.cso_attribute27, hr_api.g_varchar2) <>
343: nvl(p_rec.cso_attribute27, hr_api.g_varchar2) or
344: nvl(ben_cso_shd.g_old_rec.cso_attribute28, hr_api.g_varchar2) <>
345: nvl(p_rec.cso_attribute28, hr_api.g_varchar2) or
346: nvl(ben_cso_shd.g_old_rec.cso_attribute29, hr_api.g_varchar2) <>

Line 344: nvl(ben_cso_shd.g_old_rec.cso_attribute28, hr_api.g_varchar2) <>

340: nvl(ben_cso_shd.g_old_rec.cso_attribute26, hr_api.g_varchar2) <>
341: nvl(p_rec.cso_attribute26, hr_api.g_varchar2) or
342: nvl(ben_cso_shd.g_old_rec.cso_attribute27, hr_api.g_varchar2) <>
343: nvl(p_rec.cso_attribute27, hr_api.g_varchar2) or
344: nvl(ben_cso_shd.g_old_rec.cso_attribute28, hr_api.g_varchar2) <>
345: nvl(p_rec.cso_attribute28, hr_api.g_varchar2) or
346: nvl(ben_cso_shd.g_old_rec.cso_attribute29, hr_api.g_varchar2) <>
347: nvl(p_rec.cso_attribute29, hr_api.g_varchar2) or
348: nvl(ben_cso_shd.g_old_rec.cso_attribute30, hr_api.g_varchar2) <>

Line 346: nvl(ben_cso_shd.g_old_rec.cso_attribute29, hr_api.g_varchar2) <>

342: nvl(ben_cso_shd.g_old_rec.cso_attribute27, hr_api.g_varchar2) <>
343: nvl(p_rec.cso_attribute27, hr_api.g_varchar2) or
344: nvl(ben_cso_shd.g_old_rec.cso_attribute28, hr_api.g_varchar2) <>
345: nvl(p_rec.cso_attribute28, hr_api.g_varchar2) or
346: nvl(ben_cso_shd.g_old_rec.cso_attribute29, hr_api.g_varchar2) <>
347: nvl(p_rec.cso_attribute29, hr_api.g_varchar2) or
348: nvl(ben_cso_shd.g_old_rec.cso_attribute30, hr_api.g_varchar2) <>
349: nvl(p_rec.cso_attribute30, hr_api.g_varchar2) ))
350: or (p_rec.cwb_stock_optn_dtls_id is null) then

Line 348: nvl(ben_cso_shd.g_old_rec.cso_attribute30, hr_api.g_varchar2) <>

344: nvl(ben_cso_shd.g_old_rec.cso_attribute28, hr_api.g_varchar2) <>
345: nvl(p_rec.cso_attribute28, hr_api.g_varchar2) or
346: nvl(ben_cso_shd.g_old_rec.cso_attribute29, hr_api.g_varchar2) <>
347: nvl(p_rec.cso_attribute29, hr_api.g_varchar2) or
348: nvl(ben_cso_shd.g_old_rec.cso_attribute30, hr_api.g_varchar2) <>
349: nvl(p_rec.cso_attribute30, hr_api.g_varchar2) ))
350: or (p_rec.cwb_stock_optn_dtls_id is null) then
351: --
352: -- Only execute the validation if absolutely necessary:

Line 456: ,p_rec in ben_cso_shd.g_rec_type

452: -- {End Of Comments}
453: -- ----------------------------------------------------------------------------
454: Procedure chk_non_updateable_args
455: (p_effective_date in date
456: ,p_rec in ben_cso_shd.g_rec_type
457: ) IS
458: --
459: l_proc varchar2(72) := g_package || 'chk_non_updateable_args';
460: --

Line 466: IF NOT ben_cso_shd.api_updating

462: --
463: -- Only proceed with the validation if a row exists for the current
464: -- record in the HR Schema.
465: --
466: IF NOT ben_cso_shd.api_updating
467: (p_cwb_stock_optn_dtls_id => p_rec.cwb_stock_optn_dtls_id
468: ,p_object_version_number => p_rec.object_version_number
469: ) THEN
470: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');

Line 484: ,p_rec in ben_cso_shd.g_rec_type

480: -- |---------------------------< insert_validate >----------------------------|
481: -- ----------------------------------------------------------------------------
482: Procedure insert_validate
483: (p_effective_date in date
484: ,p_rec in ben_cso_shd.g_rec_type
485: ) is
486: --
487: l_proc varchar2(72) := g_package||'insert_validate';
488: --

Line 504: ,p_associated_column1 => ben_cso_shd.g_tab_nam

500: if(p_rec.business_group_id is not null)
501: then
502: hr_api.validate_bus_grp_id
503: (p_business_group_id => p_rec.business_group_id
504: ,p_associated_column1 => ben_cso_shd.g_tab_nam
505: || '.BUSINESS_GROUP_ID');
506: end if;
507: --
508: -- After validating the set of important attributes,

Line 527: ,p_rec in ben_cso_shd.g_rec_type

523: -- |---------------------------< update_validate >----------------------------|
524: -- ----------------------------------------------------------------------------
525: Procedure update_validate
526: (p_effective_date in date
527: ,p_rec in ben_cso_shd.g_rec_type
528: ) is
529: --
530: l_proc varchar2(72) := g_package||'update_validate';
531: --

Line 548: ,p_associated_column1 => ben_cso_shd.g_tab_nam

544: if(p_rec.business_group_id is not null)
545: then
546: hr_api.validate_bus_grp_id
547: (p_business_group_id => p_rec.business_group_id
548: ,p_associated_column1 => ben_cso_shd.g_tab_nam
549: || '.BUSINESS_GROUP_ID');
550: end if;
551: --
552: -- After validating the set of important attributes,

Line 575: (p_rec in ben_cso_shd.g_rec_type

571: -- ----------------------------------------------------------------------------
572: -- |---------------------------< delete_validate >----------------------------|
573: -- ----------------------------------------------------------------------------
574: Procedure delete_validate
575: (p_rec in ben_cso_shd.g_rec_type
576: ) is
577: --
578: l_proc varchar2(72) := g_package||'delete_validate';
579: --