APPS.GHR_CMP_BUS dependencies on GHR_CMP_SHD

Line 178: ,p_rec in ghr_cmp_shd.g_rec_type

174: -- {End Of Comments}
175: -- ----------------------------------------------------------------------------
176: Procedure chk_non_updateable_args
177: (p_effective_date in date
178: ,p_rec in ghr_cmp_shd.g_rec_type
179: ) IS
180: --
181: l_proc varchar2(72) := g_package || 'chk_non_updateable_args';
182: l_error EXCEPTION;

Line 190: IF NOT ghr_cmp_shd.api_updating

186: --
187: -- Only proceed with the validation if a row exists for the current
188: -- record in the HR Schema.
189: --
190: IF NOT ghr_cmp_shd.api_updating
191: (p_complaint_id => p_rec.complaint_id
192: ,p_object_version_number => p_rec.object_version_number
193: ) THEN
194: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');

Line 242: (p_rec in ghr_cmp_shd.g_rec_type) is

238: -- Access Status:
239: -- Internal Row Handler Use Only.
240: --
241: procedure chk_df
242: (p_rec in ghr_cmp_shd.g_rec_type) is
243: --
244: l_proc varchar2(72);
245: --
246: begin

Line 253: nvl(ghr_cmp_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>

249: hr_utility.set_location('Entering:'||l_proc, 10);
250: end if;
251: --
252: if ((p_rec.complaint_id is not null) and (
253: nvl(ghr_cmp_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
254: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
255: nvl(ghr_cmp_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
256: nvl(p_rec.attribute1, hr_api.g_varchar2) or
257: nvl(ghr_cmp_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

Line 255: nvl(ghr_cmp_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>

251: --
252: if ((p_rec.complaint_id is not null) and (
253: nvl(ghr_cmp_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
254: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
255: nvl(ghr_cmp_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
256: nvl(p_rec.attribute1, hr_api.g_varchar2) or
257: nvl(ghr_cmp_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
258: nvl(p_rec.attribute2, hr_api.g_varchar2) or
259: nvl(ghr_cmp_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

Line 257: nvl(ghr_cmp_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

253: nvl(ghr_cmp_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
254: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
255: nvl(ghr_cmp_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
256: nvl(p_rec.attribute1, hr_api.g_varchar2) or
257: nvl(ghr_cmp_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
258: nvl(p_rec.attribute2, hr_api.g_varchar2) or
259: nvl(ghr_cmp_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
260: nvl(p_rec.attribute3, hr_api.g_varchar2) or
261: nvl(ghr_cmp_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

Line 259: nvl(ghr_cmp_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

255: nvl(ghr_cmp_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
256: nvl(p_rec.attribute1, hr_api.g_varchar2) or
257: nvl(ghr_cmp_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
258: nvl(p_rec.attribute2, hr_api.g_varchar2) or
259: nvl(ghr_cmp_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
260: nvl(p_rec.attribute3, hr_api.g_varchar2) or
261: nvl(ghr_cmp_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
262: nvl(p_rec.attribute4, hr_api.g_varchar2) or
263: nvl(ghr_cmp_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

Line 261: nvl(ghr_cmp_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

257: nvl(ghr_cmp_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
258: nvl(p_rec.attribute2, hr_api.g_varchar2) or
259: nvl(ghr_cmp_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
260: nvl(p_rec.attribute3, hr_api.g_varchar2) or
261: nvl(ghr_cmp_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
262: nvl(p_rec.attribute4, hr_api.g_varchar2) or
263: nvl(ghr_cmp_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
264: nvl(p_rec.attribute5, hr_api.g_varchar2) or
265: nvl(ghr_cmp_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

Line 263: nvl(ghr_cmp_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

259: nvl(ghr_cmp_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
260: nvl(p_rec.attribute3, hr_api.g_varchar2) or
261: nvl(ghr_cmp_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
262: nvl(p_rec.attribute4, hr_api.g_varchar2) or
263: nvl(ghr_cmp_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
264: nvl(p_rec.attribute5, hr_api.g_varchar2) or
265: nvl(ghr_cmp_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
266: nvl(p_rec.attribute6, hr_api.g_varchar2) or
267: nvl(ghr_cmp_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

Line 265: nvl(ghr_cmp_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

261: nvl(ghr_cmp_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
262: nvl(p_rec.attribute4, hr_api.g_varchar2) or
263: nvl(ghr_cmp_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
264: nvl(p_rec.attribute5, hr_api.g_varchar2) or
265: nvl(ghr_cmp_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
266: nvl(p_rec.attribute6, hr_api.g_varchar2) or
267: nvl(ghr_cmp_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
268: nvl(p_rec.attribute7, hr_api.g_varchar2) or
269: nvl(ghr_cmp_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

Line 267: nvl(ghr_cmp_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

263: nvl(ghr_cmp_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
264: nvl(p_rec.attribute5, hr_api.g_varchar2) or
265: nvl(ghr_cmp_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
266: nvl(p_rec.attribute6, hr_api.g_varchar2) or
267: nvl(ghr_cmp_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
268: nvl(p_rec.attribute7, hr_api.g_varchar2) or
269: nvl(ghr_cmp_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
270: nvl(p_rec.attribute8, hr_api.g_varchar2) or
271: nvl(ghr_cmp_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

Line 269: nvl(ghr_cmp_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

265: nvl(ghr_cmp_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
266: nvl(p_rec.attribute6, hr_api.g_varchar2) or
267: nvl(ghr_cmp_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
268: nvl(p_rec.attribute7, hr_api.g_varchar2) or
269: nvl(ghr_cmp_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
270: nvl(p_rec.attribute8, hr_api.g_varchar2) or
271: nvl(ghr_cmp_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
272: nvl(p_rec.attribute9, hr_api.g_varchar2) or
273: nvl(ghr_cmp_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

Line 271: nvl(ghr_cmp_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

267: nvl(ghr_cmp_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
268: nvl(p_rec.attribute7, hr_api.g_varchar2) or
269: nvl(ghr_cmp_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
270: nvl(p_rec.attribute8, hr_api.g_varchar2) or
271: nvl(ghr_cmp_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
272: nvl(p_rec.attribute9, hr_api.g_varchar2) or
273: nvl(ghr_cmp_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
274: nvl(p_rec.attribute10, hr_api.g_varchar2) or
275: nvl(ghr_cmp_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

Line 273: nvl(ghr_cmp_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

269: nvl(ghr_cmp_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
270: nvl(p_rec.attribute8, hr_api.g_varchar2) or
271: nvl(ghr_cmp_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
272: nvl(p_rec.attribute9, hr_api.g_varchar2) or
273: nvl(ghr_cmp_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
274: nvl(p_rec.attribute10, hr_api.g_varchar2) or
275: nvl(ghr_cmp_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
276: nvl(p_rec.attribute11, hr_api.g_varchar2) or
277: nvl(ghr_cmp_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

Line 275: nvl(ghr_cmp_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

271: nvl(ghr_cmp_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
272: nvl(p_rec.attribute9, hr_api.g_varchar2) or
273: nvl(ghr_cmp_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
274: nvl(p_rec.attribute10, hr_api.g_varchar2) or
275: nvl(ghr_cmp_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
276: nvl(p_rec.attribute11, hr_api.g_varchar2) or
277: nvl(ghr_cmp_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
278: nvl(p_rec.attribute12, hr_api.g_varchar2) or
279: nvl(ghr_cmp_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

Line 277: nvl(ghr_cmp_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

273: nvl(ghr_cmp_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
274: nvl(p_rec.attribute10, hr_api.g_varchar2) or
275: nvl(ghr_cmp_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
276: nvl(p_rec.attribute11, hr_api.g_varchar2) or
277: nvl(ghr_cmp_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
278: nvl(p_rec.attribute12, hr_api.g_varchar2) or
279: nvl(ghr_cmp_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
280: nvl(p_rec.attribute13, hr_api.g_varchar2) or
281: nvl(ghr_cmp_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

Line 279: nvl(ghr_cmp_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

275: nvl(ghr_cmp_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
276: nvl(p_rec.attribute11, hr_api.g_varchar2) or
277: nvl(ghr_cmp_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
278: nvl(p_rec.attribute12, hr_api.g_varchar2) or
279: nvl(ghr_cmp_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
280: nvl(p_rec.attribute13, hr_api.g_varchar2) or
281: nvl(ghr_cmp_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
282: nvl(p_rec.attribute14, hr_api.g_varchar2) or
283: nvl(ghr_cmp_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

Line 281: nvl(ghr_cmp_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

277: nvl(ghr_cmp_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
278: nvl(p_rec.attribute12, hr_api.g_varchar2) or
279: nvl(ghr_cmp_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
280: nvl(p_rec.attribute13, hr_api.g_varchar2) or
281: nvl(ghr_cmp_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
282: nvl(p_rec.attribute14, hr_api.g_varchar2) or
283: nvl(ghr_cmp_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
284: nvl(p_rec.attribute15, hr_api.g_varchar2) or
285: nvl(ghr_cmp_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

Line 283: nvl(ghr_cmp_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

279: nvl(ghr_cmp_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
280: nvl(p_rec.attribute13, hr_api.g_varchar2) or
281: nvl(ghr_cmp_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
282: nvl(p_rec.attribute14, hr_api.g_varchar2) or
283: nvl(ghr_cmp_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
284: nvl(p_rec.attribute15, hr_api.g_varchar2) or
285: nvl(ghr_cmp_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
286: nvl(p_rec.attribute16, hr_api.g_varchar2) or
287: nvl(ghr_cmp_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

Line 285: nvl(ghr_cmp_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

281: nvl(ghr_cmp_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
282: nvl(p_rec.attribute14, hr_api.g_varchar2) or
283: nvl(ghr_cmp_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
284: nvl(p_rec.attribute15, hr_api.g_varchar2) or
285: nvl(ghr_cmp_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
286: nvl(p_rec.attribute16, hr_api.g_varchar2) or
287: nvl(ghr_cmp_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
288: nvl(p_rec.attribute17, hr_api.g_varchar2) or
289: nvl(ghr_cmp_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

Line 287: nvl(ghr_cmp_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

283: nvl(ghr_cmp_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
284: nvl(p_rec.attribute15, hr_api.g_varchar2) or
285: nvl(ghr_cmp_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
286: nvl(p_rec.attribute16, hr_api.g_varchar2) or
287: nvl(ghr_cmp_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
288: nvl(p_rec.attribute17, hr_api.g_varchar2) or
289: nvl(ghr_cmp_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
290: nvl(p_rec.attribute18, hr_api.g_varchar2) or
291: nvl(ghr_cmp_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

Line 289: nvl(ghr_cmp_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

285: nvl(ghr_cmp_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
286: nvl(p_rec.attribute16, hr_api.g_varchar2) or
287: nvl(ghr_cmp_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
288: nvl(p_rec.attribute17, hr_api.g_varchar2) or
289: nvl(ghr_cmp_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
290: nvl(p_rec.attribute18, hr_api.g_varchar2) or
291: nvl(ghr_cmp_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
292: nvl(p_rec.attribute19, hr_api.g_varchar2) or
293: nvl(ghr_cmp_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

Line 291: nvl(ghr_cmp_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

287: nvl(ghr_cmp_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
288: nvl(p_rec.attribute17, hr_api.g_varchar2) or
289: nvl(ghr_cmp_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
290: nvl(p_rec.attribute18, hr_api.g_varchar2) or
291: nvl(ghr_cmp_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
292: nvl(p_rec.attribute19, hr_api.g_varchar2) or
293: nvl(ghr_cmp_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
294: nvl(p_rec.attribute20, hr_api.g_varchar2) or
295: nvl(ghr_cmp_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>

Line 293: nvl(ghr_cmp_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

289: nvl(ghr_cmp_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
290: nvl(p_rec.attribute18, hr_api.g_varchar2) or
291: nvl(ghr_cmp_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
292: nvl(p_rec.attribute19, hr_api.g_varchar2) or
293: nvl(ghr_cmp_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
294: nvl(p_rec.attribute20, hr_api.g_varchar2) or
295: nvl(ghr_cmp_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
296: nvl(p_rec.attribute21, hr_api.g_varchar2) or
297: nvl(ghr_cmp_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>

Line 295: nvl(ghr_cmp_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>

291: nvl(ghr_cmp_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
292: nvl(p_rec.attribute19, hr_api.g_varchar2) or
293: nvl(ghr_cmp_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
294: nvl(p_rec.attribute20, hr_api.g_varchar2) or
295: nvl(ghr_cmp_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
296: nvl(p_rec.attribute21, hr_api.g_varchar2) or
297: nvl(ghr_cmp_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
298: nvl(p_rec.attribute22, hr_api.g_varchar2) or
299: nvl(ghr_cmp_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>

Line 297: nvl(ghr_cmp_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>

293: nvl(ghr_cmp_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
294: nvl(p_rec.attribute20, hr_api.g_varchar2) or
295: nvl(ghr_cmp_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
296: nvl(p_rec.attribute21, hr_api.g_varchar2) or
297: nvl(ghr_cmp_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
298: nvl(p_rec.attribute22, hr_api.g_varchar2) or
299: nvl(ghr_cmp_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
300: nvl(p_rec.attribute23, hr_api.g_varchar2) or
301: nvl(ghr_cmp_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>

Line 299: nvl(ghr_cmp_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>

295: nvl(ghr_cmp_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
296: nvl(p_rec.attribute21, hr_api.g_varchar2) or
297: nvl(ghr_cmp_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
298: nvl(p_rec.attribute22, hr_api.g_varchar2) or
299: nvl(ghr_cmp_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
300: nvl(p_rec.attribute23, hr_api.g_varchar2) or
301: nvl(ghr_cmp_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
302: nvl(p_rec.attribute24, hr_api.g_varchar2) or
303: nvl(ghr_cmp_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>

Line 301: nvl(ghr_cmp_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>

297: nvl(ghr_cmp_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
298: nvl(p_rec.attribute22, hr_api.g_varchar2) or
299: nvl(ghr_cmp_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
300: nvl(p_rec.attribute23, hr_api.g_varchar2) or
301: nvl(ghr_cmp_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
302: nvl(p_rec.attribute24, hr_api.g_varchar2) or
303: nvl(ghr_cmp_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
304: nvl(p_rec.attribute25, hr_api.g_varchar2) or
305: nvl(ghr_cmp_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>

Line 303: nvl(ghr_cmp_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>

299: nvl(ghr_cmp_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
300: nvl(p_rec.attribute23, hr_api.g_varchar2) or
301: nvl(ghr_cmp_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
302: nvl(p_rec.attribute24, hr_api.g_varchar2) or
303: nvl(ghr_cmp_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
304: nvl(p_rec.attribute25, hr_api.g_varchar2) or
305: nvl(ghr_cmp_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
306: nvl(p_rec.attribute26, hr_api.g_varchar2) or
307: nvl(ghr_cmp_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>

Line 305: nvl(ghr_cmp_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>

301: nvl(ghr_cmp_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
302: nvl(p_rec.attribute24, hr_api.g_varchar2) or
303: nvl(ghr_cmp_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
304: nvl(p_rec.attribute25, hr_api.g_varchar2) or
305: nvl(ghr_cmp_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
306: nvl(p_rec.attribute26, hr_api.g_varchar2) or
307: nvl(ghr_cmp_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
308: nvl(p_rec.attribute27, hr_api.g_varchar2) or
309: nvl(ghr_cmp_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>

Line 307: nvl(ghr_cmp_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>

303: nvl(ghr_cmp_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
304: nvl(p_rec.attribute25, hr_api.g_varchar2) or
305: nvl(ghr_cmp_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
306: nvl(p_rec.attribute26, hr_api.g_varchar2) or
307: nvl(ghr_cmp_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
308: nvl(p_rec.attribute27, hr_api.g_varchar2) or
309: nvl(ghr_cmp_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
310: nvl(p_rec.attribute28, hr_api.g_varchar2) or
311: nvl(ghr_cmp_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>

Line 309: nvl(ghr_cmp_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>

305: nvl(ghr_cmp_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
306: nvl(p_rec.attribute26, hr_api.g_varchar2) or
307: nvl(ghr_cmp_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
308: nvl(p_rec.attribute27, hr_api.g_varchar2) or
309: nvl(ghr_cmp_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
310: nvl(p_rec.attribute28, hr_api.g_varchar2) or
311: nvl(ghr_cmp_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
312: nvl(p_rec.attribute29, hr_api.g_varchar2) or
313: nvl(ghr_cmp_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>

Line 311: nvl(ghr_cmp_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>

307: nvl(ghr_cmp_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
308: nvl(p_rec.attribute27, hr_api.g_varchar2) or
309: nvl(ghr_cmp_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
310: nvl(p_rec.attribute28, hr_api.g_varchar2) or
311: nvl(ghr_cmp_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
312: nvl(p_rec.attribute29, hr_api.g_varchar2) or
313: nvl(ghr_cmp_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
314: nvl(p_rec.attribute30, hr_api.g_varchar2)))
315: or (p_rec.complaint_id is null) then

Line 313: nvl(ghr_cmp_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>

309: nvl(ghr_cmp_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
310: nvl(p_rec.attribute28, hr_api.g_varchar2) or
311: nvl(ghr_cmp_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
312: nvl(p_rec.attribute29, hr_api.g_varchar2) or
313: nvl(ghr_cmp_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
314: nvl(p_rec.attribute30, hr_api.g_varchar2)))
315: or (p_rec.complaint_id is null) then
316: --
317: -- Only execute the validation if absolutely necessary:

Line 403: ,p_rec in ghr_cmp_shd.g_rec_type

399: -- |---------------------------< insert_validate >----------------------------|
400: -- ----------------------------------------------------------------------------
401: Procedure insert_validate
402: (p_effective_date in date
403: ,p_rec in ghr_cmp_shd.g_rec_type
404: ) is
405: --
406: l_proc varchar2(72) := g_package||'insert_validate';
407: --

Line 434: ghr_cmp_shd.chk_df(p_rec => p_rec);

430: -- Validate flex fields.
431: --
432: /*
433: -- JH DFF
434: ghr_cmp_shd.chk_df(p_rec => p_rec);
435: if g_debug then
436: hr_utility.set_location(l_proc, 210);
437: end if;
438: */

Line 448: ,p_rec in ghr_cmp_shd.g_rec_type

444: -- |---------------------------< update_validate >----------------------------|
445: -- ----------------------------------------------------------------------------
446: Procedure update_validate
447: (p_effective_date in date
448: ,p_rec in ghr_cmp_shd.g_rec_type
449: ) is
450: --
451: l_proc varchar2(72) := g_package||'update_validate';
452: --

Line 484: ghr_cmp_shd.chk_df(p_rec => p_rec);

480: -- Validate flex fields.
481: --
482: /*
483: -- JH DFF
484: ghr_cmp_shd.chk_df(p_rec => p_rec);
485: if g_debug then
486: hr_utility.set_location(l_proc, 210);
487: end if;
488: */

Line 497: (p_rec in ghr_cmp_shd.g_rec_type

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