APPS.GHR_CMP_BUS dependencies on HR_API

Line 44: hr_api.mandatory_arg_error

40: hr_utility.set_location('Entering:'|| l_proc, 10);
41: --
42: -- Ensure that all the mandatory parameter are not null
43: --
44: hr_api.mandatory_arg_error
45: (p_api_name => l_proc
46: ,p_argument => 'complaint_id'
47: ,p_argument_value => p_complaint_id
48: );

Line 67: hr_api.set_security_group_id

63: close csr_sec_grp;
64: --
65: -- Set the security_group_id in CLIENT_INFO
66: --
67: hr_api.set_security_group_id
68: (p_security_group_id => l_security_group_id
69: );
70: --
71: hr_utility.set_location(' Leaving:'|| l_proc, 20);

Line 104: hr_api.mandatory_arg_error

100: hr_utility.set_location('Entering:'|| l_proc, 10);
101: --
102: -- Ensure that all the mandatory parameter are not null
103: --
104: hr_api.mandatory_arg_error
105: (p_api_name => l_proc
106: ,p_argument => 'complaint_id'
107: ,p_argument_value => p_complaint_id
108: );

Line 110: if ( nvl(ghr_cmp_bus.g_complaint_id, hr_api.g_number)

106: ,p_argument => 'complaint_id'
107: ,p_argument_value => p_complaint_id
108: );
109: --
110: if ( nvl(ghr_cmp_bus.g_complaint_id, hr_api.g_number)
111: = p_complaint_id) then
112: --
113: -- The legislation code has already been found with a previous
114: -- call to this function. Just return the value in the global

Line 205: hr_api.argument_changed_error

201: -- not been updated.
202: --
203: EXCEPTION
204: WHEN l_error THEN
205: hr_api.argument_changed_error
206: (p_api_name => l_proc
207: ,p_argument => l_argument);
208: WHEN OTHERS THEN
209: RAISE;

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 254: nvl(p_rec.attribute_category, hr_api.g_varchar2) or

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) <>
258: nvl(p_rec.attribute2, hr_api.g_varchar2) or

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 256: nvl(p_rec.attribute1, hr_api.g_varchar2) or

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) <>
260: nvl(p_rec.attribute3, hr_api.g_varchar2) or

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 258: nvl(p_rec.attribute2, hr_api.g_varchar2) or

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) <>
262: nvl(p_rec.attribute4, hr_api.g_varchar2) or

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 260: nvl(p_rec.attribute3, hr_api.g_varchar2) or

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) <>
264: nvl(p_rec.attribute5, hr_api.g_varchar2) or

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 262: nvl(p_rec.attribute4, hr_api.g_varchar2) or

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) <>
266: nvl(p_rec.attribute6, hr_api.g_varchar2) or

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 264: nvl(p_rec.attribute5, hr_api.g_varchar2) or

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) <>
268: nvl(p_rec.attribute7, hr_api.g_varchar2) or

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 266: nvl(p_rec.attribute6, hr_api.g_varchar2) or

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) <>
270: nvl(p_rec.attribute8, hr_api.g_varchar2) or

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 268: nvl(p_rec.attribute7, hr_api.g_varchar2) or

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) <>
272: nvl(p_rec.attribute9, hr_api.g_varchar2) or

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 270: nvl(p_rec.attribute8, hr_api.g_varchar2) or

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) <>
274: nvl(p_rec.attribute10, hr_api.g_varchar2) or

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 272: nvl(p_rec.attribute9, hr_api.g_varchar2) or

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) <>
276: nvl(p_rec.attribute11, hr_api.g_varchar2) or

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 274: nvl(p_rec.attribute10, hr_api.g_varchar2) or

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) <>
278: nvl(p_rec.attribute12, hr_api.g_varchar2) or

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 276: nvl(p_rec.attribute11, hr_api.g_varchar2) or

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) <>
280: nvl(p_rec.attribute13, hr_api.g_varchar2) or

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 278: nvl(p_rec.attribute12, hr_api.g_varchar2) or

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) <>
282: nvl(p_rec.attribute14, hr_api.g_varchar2) or

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 280: nvl(p_rec.attribute13, hr_api.g_varchar2) or

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) <>
284: nvl(p_rec.attribute15, hr_api.g_varchar2) or

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 282: nvl(p_rec.attribute14, hr_api.g_varchar2) or

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) <>
286: nvl(p_rec.attribute16, hr_api.g_varchar2) or

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 284: nvl(p_rec.attribute15, hr_api.g_varchar2) or

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) <>
288: nvl(p_rec.attribute17, hr_api.g_varchar2) or

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 286: nvl(p_rec.attribute16, hr_api.g_varchar2) or

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) <>
290: nvl(p_rec.attribute18, hr_api.g_varchar2) or

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 288: nvl(p_rec.attribute17, hr_api.g_varchar2) or

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) <>
292: nvl(p_rec.attribute19, hr_api.g_varchar2) or

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 290: nvl(p_rec.attribute18, hr_api.g_varchar2) or

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) <>
294: nvl(p_rec.attribute20, hr_api.g_varchar2) or

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 292: nvl(p_rec.attribute19, hr_api.g_varchar2) or

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) <>
296: nvl(p_rec.attribute21, hr_api.g_varchar2) or

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 294: nvl(p_rec.attribute20, hr_api.g_varchar2) or

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) <>
298: nvl(p_rec.attribute22, hr_api.g_varchar2) or

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 296: nvl(p_rec.attribute21, hr_api.g_varchar2) or

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) <>
300: nvl(p_rec.attribute23, hr_api.g_varchar2) or

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 298: nvl(p_rec.attribute22, hr_api.g_varchar2) or

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) <>
302: nvl(p_rec.attribute24, hr_api.g_varchar2) or

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 300: nvl(p_rec.attribute23, hr_api.g_varchar2) or

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) <>
304: nvl(p_rec.attribute25, hr_api.g_varchar2) or

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 302: nvl(p_rec.attribute24, hr_api.g_varchar2) or

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) <>
306: nvl(p_rec.attribute26, hr_api.g_varchar2) or

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 304: nvl(p_rec.attribute25, hr_api.g_varchar2) or

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) <>
308: nvl(p_rec.attribute27, hr_api.g_varchar2) or

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 306: nvl(p_rec.attribute26, hr_api.g_varchar2) or

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) <>
310: nvl(p_rec.attribute28, hr_api.g_varchar2) or

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 308: nvl(p_rec.attribute27, hr_api.g_varchar2) or

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) <>
312: nvl(p_rec.attribute29, hr_api.g_varchar2) or

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 310: nvl(p_rec.attribute28, hr_api.g_varchar2) or

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) <>
314: nvl(p_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 312: nvl(p_rec.attribute29, hr_api.g_varchar2) or

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
316: --

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 314: nvl(p_rec.attribute30, 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:
318: -- a) During update, the structure column value or any

Line 413: -- EDIT_HERE: The following call to hr_api.validate_bus_grp_id

409: hr_utility.set_location('Entering:'||l_proc, 5);
410: --
411: -- Call all supporting business operations
412: --
413: -- EDIT_HERE: The following call to hr_api.validate_bus_grp_id
414: -- will only be valid when the business_group_id is not null.
415: -- As this column is defined as optional on the table then
416: -- different logic will be required to handle the null case.
417: -- If this is a start-up data entity then:

Line 427: --hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp

423: -- validation against the HR_STANDARD_LOOKUPS view.
424: -- or c) (less likely) ensure the correct security_group_id
425: -- value is set in client_info.
426: -- Remove this comment when the edit has been completed.
427: --hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
428: --
429: --
430: -- Validate flex fields.
431: --

Line 458: -- EDIT_HERE: The following call to hr_api.validate_bus_grp_id

454: hr_utility.set_location('Entering:'||l_proc, 5);
455: --
456: -- Call all supporting business operations
457: --
458: -- EDIT_HERE: The following call to hr_api.validate_bus_grp_id
459: -- will only be valid when the business_group_id is not null.
460: -- As this column is defined as optional on the table then
461: -- different logic will be required to handle the null case.
462: -- If this is a start-up data entity then:

Line 472: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp

468: -- validation against the HR_STANDARD_LOOKUPS view.
469: -- or c) (less likely) ensure the correct security_group_id
470: -- value is set in client_info.
471: -- Remove this comment when the edit has been completed.
472: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
473: --
474: chk_non_updateable_args
475: (p_effective_date => p_effective_date
476: ,p_rec => p_rec