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.PER_EST_BUS dependencies on HR_API

Line 64: <> nvl(p_name,hr_api.g_varchar2)

60: --
61: if not l_api_updating
62: or (l_api_updating
63: and (per_est_shd.g_old_rec.name
64: <> nvl(p_name,hr_api.g_varchar2)
65: or per_est_shd.g_old_rec.location
66: <> nvl(p_location,hr_api.g_varchar2))) then
67: --
68: -- check if name is not null

Line 66: <> nvl(p_location,hr_api.g_varchar2))) then

62: or (l_api_updating
63: and (per_est_shd.g_old_rec.name
64: <> nvl(p_name,hr_api.g_varchar2)
65: or per_est_shd.g_old_rec.location
66: <> nvl(p_location,hr_api.g_varchar2))) then
67: --
68: -- check if name is not null
69: --
70: if p_name is null then

Line 158: and nvl(p_establishment_id,hr_api.g_number)

154: --
155: end if;
156: --
157: elsif (l_api_updating
158: and nvl(p_establishment_id,hr_api.g_number)
159: <> per_est_shd.g_old_rec.establishment_id) then
160: --
161: -- raise error as PK has been updated
162: --

Line 266: nvl(per_est_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>

262: begin
263: hr_utility.set_location('Entering:'||l_proc, 10);
264: --
265: if ((p_rec.establishment_id is not null) and (
266: nvl(per_est_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
267: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
268: nvl(per_est_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
269: nvl(p_rec.attribute1, hr_api.g_varchar2) or
270: nvl(per_est_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

Line 267: nvl(p_rec.attribute_category, hr_api.g_varchar2) or

263: hr_utility.set_location('Entering:'||l_proc, 10);
264: --
265: if ((p_rec.establishment_id is not null) and (
266: nvl(per_est_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
267: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
268: nvl(per_est_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
269: nvl(p_rec.attribute1, hr_api.g_varchar2) or
270: nvl(per_est_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
271: nvl(p_rec.attribute2, hr_api.g_varchar2) or

Line 268: nvl(per_est_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>

264: --
265: if ((p_rec.establishment_id is not null) and (
266: nvl(per_est_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
267: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
268: nvl(per_est_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
269: nvl(p_rec.attribute1, hr_api.g_varchar2) or
270: nvl(per_est_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
271: nvl(p_rec.attribute2, hr_api.g_varchar2) or
272: nvl(per_est_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

Line 269: nvl(p_rec.attribute1, hr_api.g_varchar2) or

265: if ((p_rec.establishment_id is not null) and (
266: nvl(per_est_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
267: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
268: nvl(per_est_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
269: nvl(p_rec.attribute1, hr_api.g_varchar2) or
270: nvl(per_est_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
271: nvl(p_rec.attribute2, hr_api.g_varchar2) or
272: nvl(per_est_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
273: nvl(p_rec.attribute3, hr_api.g_varchar2) or

Line 270: nvl(per_est_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

266: nvl(per_est_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
267: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
268: nvl(per_est_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
269: nvl(p_rec.attribute1, hr_api.g_varchar2) or
270: nvl(per_est_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
271: nvl(p_rec.attribute2, hr_api.g_varchar2) or
272: nvl(per_est_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
273: nvl(p_rec.attribute3, hr_api.g_varchar2) or
274: nvl(per_est_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

Line 271: nvl(p_rec.attribute2, hr_api.g_varchar2) or

267: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
268: nvl(per_est_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
269: nvl(p_rec.attribute1, hr_api.g_varchar2) or
270: nvl(per_est_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
271: nvl(p_rec.attribute2, hr_api.g_varchar2) or
272: nvl(per_est_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
273: nvl(p_rec.attribute3, hr_api.g_varchar2) or
274: nvl(per_est_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
275: nvl(p_rec.attribute4, hr_api.g_varchar2) or

Line 272: nvl(per_est_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

268: nvl(per_est_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
269: nvl(p_rec.attribute1, hr_api.g_varchar2) or
270: nvl(per_est_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
271: nvl(p_rec.attribute2, hr_api.g_varchar2) or
272: nvl(per_est_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
273: nvl(p_rec.attribute3, hr_api.g_varchar2) or
274: nvl(per_est_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
275: nvl(p_rec.attribute4, hr_api.g_varchar2) or
276: nvl(per_est_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

Line 273: nvl(p_rec.attribute3, hr_api.g_varchar2) or

269: nvl(p_rec.attribute1, hr_api.g_varchar2) or
270: nvl(per_est_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
271: nvl(p_rec.attribute2, hr_api.g_varchar2) or
272: nvl(per_est_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
273: nvl(p_rec.attribute3, hr_api.g_varchar2) or
274: nvl(per_est_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
275: nvl(p_rec.attribute4, hr_api.g_varchar2) or
276: nvl(per_est_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
277: nvl(p_rec.attribute5, hr_api.g_varchar2) or

Line 274: nvl(per_est_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

270: nvl(per_est_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
271: nvl(p_rec.attribute2, hr_api.g_varchar2) or
272: nvl(per_est_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
273: nvl(p_rec.attribute3, hr_api.g_varchar2) or
274: nvl(per_est_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
275: nvl(p_rec.attribute4, hr_api.g_varchar2) or
276: nvl(per_est_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
277: nvl(p_rec.attribute5, hr_api.g_varchar2) or
278: nvl(per_est_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

Line 275: nvl(p_rec.attribute4, hr_api.g_varchar2) or

271: nvl(p_rec.attribute2, hr_api.g_varchar2) or
272: nvl(per_est_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
273: nvl(p_rec.attribute3, hr_api.g_varchar2) or
274: nvl(per_est_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
275: nvl(p_rec.attribute4, hr_api.g_varchar2) or
276: nvl(per_est_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
277: nvl(p_rec.attribute5, hr_api.g_varchar2) or
278: nvl(per_est_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
279: nvl(p_rec.attribute6, hr_api.g_varchar2) or

Line 276: nvl(per_est_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

272: nvl(per_est_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
273: nvl(p_rec.attribute3, hr_api.g_varchar2) or
274: nvl(per_est_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
275: nvl(p_rec.attribute4, hr_api.g_varchar2) or
276: nvl(per_est_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
277: nvl(p_rec.attribute5, hr_api.g_varchar2) or
278: nvl(per_est_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
279: nvl(p_rec.attribute6, hr_api.g_varchar2) or
280: nvl(per_est_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

Line 277: nvl(p_rec.attribute5, hr_api.g_varchar2) or

273: nvl(p_rec.attribute3, hr_api.g_varchar2) or
274: nvl(per_est_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
275: nvl(p_rec.attribute4, hr_api.g_varchar2) or
276: nvl(per_est_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
277: nvl(p_rec.attribute5, hr_api.g_varchar2) or
278: nvl(per_est_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
279: nvl(p_rec.attribute6, hr_api.g_varchar2) or
280: nvl(per_est_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
281: nvl(p_rec.attribute7, hr_api.g_varchar2) or

Line 278: nvl(per_est_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

274: nvl(per_est_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
275: nvl(p_rec.attribute4, hr_api.g_varchar2) or
276: nvl(per_est_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
277: nvl(p_rec.attribute5, hr_api.g_varchar2) or
278: nvl(per_est_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
279: nvl(p_rec.attribute6, hr_api.g_varchar2) or
280: nvl(per_est_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
281: nvl(p_rec.attribute7, hr_api.g_varchar2) or
282: nvl(per_est_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

Line 279: nvl(p_rec.attribute6, hr_api.g_varchar2) or

275: nvl(p_rec.attribute4, hr_api.g_varchar2) or
276: nvl(per_est_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
277: nvl(p_rec.attribute5, hr_api.g_varchar2) or
278: nvl(per_est_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
279: nvl(p_rec.attribute6, hr_api.g_varchar2) or
280: nvl(per_est_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
281: nvl(p_rec.attribute7, hr_api.g_varchar2) or
282: nvl(per_est_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
283: nvl(p_rec.attribute8, hr_api.g_varchar2) or

Line 280: nvl(per_est_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

276: nvl(per_est_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
277: nvl(p_rec.attribute5, hr_api.g_varchar2) or
278: nvl(per_est_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
279: nvl(p_rec.attribute6, hr_api.g_varchar2) or
280: nvl(per_est_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
281: nvl(p_rec.attribute7, hr_api.g_varchar2) or
282: nvl(per_est_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
283: nvl(p_rec.attribute8, hr_api.g_varchar2) or
284: nvl(per_est_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

Line 281: nvl(p_rec.attribute7, hr_api.g_varchar2) or

277: nvl(p_rec.attribute5, hr_api.g_varchar2) or
278: nvl(per_est_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
279: nvl(p_rec.attribute6, hr_api.g_varchar2) or
280: nvl(per_est_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
281: nvl(p_rec.attribute7, hr_api.g_varchar2) or
282: nvl(per_est_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
283: nvl(p_rec.attribute8, hr_api.g_varchar2) or
284: nvl(per_est_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
285: nvl(p_rec.attribute9, hr_api.g_varchar2) or

Line 282: nvl(per_est_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

278: nvl(per_est_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
279: nvl(p_rec.attribute6, hr_api.g_varchar2) or
280: nvl(per_est_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
281: nvl(p_rec.attribute7, hr_api.g_varchar2) or
282: nvl(per_est_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
283: nvl(p_rec.attribute8, hr_api.g_varchar2) or
284: nvl(per_est_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
285: nvl(p_rec.attribute9, hr_api.g_varchar2) or
286: nvl(per_est_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

Line 283: nvl(p_rec.attribute8, hr_api.g_varchar2) or

279: nvl(p_rec.attribute6, hr_api.g_varchar2) or
280: nvl(per_est_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
281: nvl(p_rec.attribute7, hr_api.g_varchar2) or
282: nvl(per_est_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
283: nvl(p_rec.attribute8, hr_api.g_varchar2) or
284: nvl(per_est_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
285: nvl(p_rec.attribute9, hr_api.g_varchar2) or
286: nvl(per_est_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
287: nvl(p_rec.attribute10, hr_api.g_varchar2) or

Line 284: nvl(per_est_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

280: nvl(per_est_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
281: nvl(p_rec.attribute7, hr_api.g_varchar2) or
282: nvl(per_est_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
283: nvl(p_rec.attribute8, hr_api.g_varchar2) or
284: nvl(per_est_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
285: nvl(p_rec.attribute9, hr_api.g_varchar2) or
286: nvl(per_est_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
287: nvl(p_rec.attribute10, hr_api.g_varchar2) or
288: nvl(per_est_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

Line 285: nvl(p_rec.attribute9, hr_api.g_varchar2) or

281: nvl(p_rec.attribute7, hr_api.g_varchar2) or
282: nvl(per_est_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
283: nvl(p_rec.attribute8, hr_api.g_varchar2) or
284: nvl(per_est_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
285: nvl(p_rec.attribute9, hr_api.g_varchar2) or
286: nvl(per_est_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
287: nvl(p_rec.attribute10, hr_api.g_varchar2) or
288: nvl(per_est_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
289: nvl(p_rec.attribute11, hr_api.g_varchar2) or

Line 286: nvl(per_est_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

282: nvl(per_est_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
283: nvl(p_rec.attribute8, hr_api.g_varchar2) or
284: nvl(per_est_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
285: nvl(p_rec.attribute9, hr_api.g_varchar2) or
286: nvl(per_est_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
287: nvl(p_rec.attribute10, hr_api.g_varchar2) or
288: nvl(per_est_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
289: nvl(p_rec.attribute11, hr_api.g_varchar2) or
290: nvl(per_est_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

Line 287: nvl(p_rec.attribute10, hr_api.g_varchar2) or

283: nvl(p_rec.attribute8, hr_api.g_varchar2) or
284: nvl(per_est_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
285: nvl(p_rec.attribute9, hr_api.g_varchar2) or
286: nvl(per_est_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
287: nvl(p_rec.attribute10, hr_api.g_varchar2) or
288: nvl(per_est_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
289: nvl(p_rec.attribute11, hr_api.g_varchar2) or
290: nvl(per_est_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
291: nvl(p_rec.attribute12, hr_api.g_varchar2) or

Line 288: nvl(per_est_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

284: nvl(per_est_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
285: nvl(p_rec.attribute9, hr_api.g_varchar2) or
286: nvl(per_est_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
287: nvl(p_rec.attribute10, hr_api.g_varchar2) or
288: nvl(per_est_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
289: nvl(p_rec.attribute11, hr_api.g_varchar2) or
290: nvl(per_est_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
291: nvl(p_rec.attribute12, hr_api.g_varchar2) or
292: nvl(per_est_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

Line 289: nvl(p_rec.attribute11, hr_api.g_varchar2) or

285: nvl(p_rec.attribute9, hr_api.g_varchar2) or
286: nvl(per_est_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
287: nvl(p_rec.attribute10, hr_api.g_varchar2) or
288: nvl(per_est_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
289: nvl(p_rec.attribute11, hr_api.g_varchar2) or
290: nvl(per_est_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
291: nvl(p_rec.attribute12, hr_api.g_varchar2) or
292: nvl(per_est_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
293: nvl(p_rec.attribute13, hr_api.g_varchar2) or

Line 290: nvl(per_est_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

286: nvl(per_est_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
287: nvl(p_rec.attribute10, hr_api.g_varchar2) or
288: nvl(per_est_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
289: nvl(p_rec.attribute11, hr_api.g_varchar2) or
290: nvl(per_est_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
291: nvl(p_rec.attribute12, hr_api.g_varchar2) or
292: nvl(per_est_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
293: nvl(p_rec.attribute13, hr_api.g_varchar2) or
294: nvl(per_est_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

Line 291: nvl(p_rec.attribute12, hr_api.g_varchar2) or

287: nvl(p_rec.attribute10, hr_api.g_varchar2) or
288: nvl(per_est_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
289: nvl(p_rec.attribute11, hr_api.g_varchar2) or
290: nvl(per_est_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
291: nvl(p_rec.attribute12, hr_api.g_varchar2) or
292: nvl(per_est_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
293: nvl(p_rec.attribute13, hr_api.g_varchar2) or
294: nvl(per_est_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
295: nvl(p_rec.attribute14, hr_api.g_varchar2) or

Line 292: nvl(per_est_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

288: nvl(per_est_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
289: nvl(p_rec.attribute11, hr_api.g_varchar2) or
290: nvl(per_est_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
291: nvl(p_rec.attribute12, hr_api.g_varchar2) or
292: nvl(per_est_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
293: nvl(p_rec.attribute13, hr_api.g_varchar2) or
294: nvl(per_est_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
295: nvl(p_rec.attribute14, hr_api.g_varchar2) or
296: nvl(per_est_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

Line 293: nvl(p_rec.attribute13, hr_api.g_varchar2) or

289: nvl(p_rec.attribute11, hr_api.g_varchar2) or
290: nvl(per_est_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
291: nvl(p_rec.attribute12, hr_api.g_varchar2) or
292: nvl(per_est_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
293: nvl(p_rec.attribute13, hr_api.g_varchar2) or
294: nvl(per_est_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
295: nvl(p_rec.attribute14, hr_api.g_varchar2) or
296: nvl(per_est_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
297: nvl(p_rec.attribute15, hr_api.g_varchar2) or

Line 294: nvl(per_est_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

290: nvl(per_est_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
291: nvl(p_rec.attribute12, hr_api.g_varchar2) or
292: nvl(per_est_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
293: nvl(p_rec.attribute13, hr_api.g_varchar2) or
294: nvl(per_est_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
295: nvl(p_rec.attribute14, hr_api.g_varchar2) or
296: nvl(per_est_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
297: nvl(p_rec.attribute15, hr_api.g_varchar2) or
298: nvl(per_est_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

Line 295: nvl(p_rec.attribute14, hr_api.g_varchar2) or

291: nvl(p_rec.attribute12, hr_api.g_varchar2) or
292: nvl(per_est_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
293: nvl(p_rec.attribute13, hr_api.g_varchar2) or
294: nvl(per_est_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
295: nvl(p_rec.attribute14, hr_api.g_varchar2) or
296: nvl(per_est_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
297: nvl(p_rec.attribute15, hr_api.g_varchar2) or
298: nvl(per_est_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
299: nvl(p_rec.attribute16, hr_api.g_varchar2) or

Line 296: nvl(per_est_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

292: nvl(per_est_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
293: nvl(p_rec.attribute13, hr_api.g_varchar2) or
294: nvl(per_est_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
295: nvl(p_rec.attribute14, hr_api.g_varchar2) or
296: nvl(per_est_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
297: nvl(p_rec.attribute15, hr_api.g_varchar2) or
298: nvl(per_est_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
299: nvl(p_rec.attribute16, hr_api.g_varchar2) or
300: nvl(per_est_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

Line 297: nvl(p_rec.attribute15, hr_api.g_varchar2) or

293: nvl(p_rec.attribute13, hr_api.g_varchar2) or
294: nvl(per_est_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
295: nvl(p_rec.attribute14, hr_api.g_varchar2) or
296: nvl(per_est_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
297: nvl(p_rec.attribute15, hr_api.g_varchar2) or
298: nvl(per_est_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
299: nvl(p_rec.attribute16, hr_api.g_varchar2) or
300: nvl(per_est_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
301: nvl(p_rec.attribute17, hr_api.g_varchar2) or

Line 298: nvl(per_est_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

294: nvl(per_est_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
295: nvl(p_rec.attribute14, hr_api.g_varchar2) or
296: nvl(per_est_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
297: nvl(p_rec.attribute15, hr_api.g_varchar2) or
298: nvl(per_est_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
299: nvl(p_rec.attribute16, hr_api.g_varchar2) or
300: nvl(per_est_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
301: nvl(p_rec.attribute17, hr_api.g_varchar2) or
302: nvl(per_est_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

Line 299: nvl(p_rec.attribute16, hr_api.g_varchar2) or

295: nvl(p_rec.attribute14, hr_api.g_varchar2) or
296: nvl(per_est_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
297: nvl(p_rec.attribute15, hr_api.g_varchar2) or
298: nvl(per_est_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
299: nvl(p_rec.attribute16, hr_api.g_varchar2) or
300: nvl(per_est_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
301: nvl(p_rec.attribute17, hr_api.g_varchar2) or
302: nvl(per_est_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
303: nvl(p_rec.attribute18, hr_api.g_varchar2) or

Line 300: nvl(per_est_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

296: nvl(per_est_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
297: nvl(p_rec.attribute15, hr_api.g_varchar2) or
298: nvl(per_est_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
299: nvl(p_rec.attribute16, hr_api.g_varchar2) or
300: nvl(per_est_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
301: nvl(p_rec.attribute17, hr_api.g_varchar2) or
302: nvl(per_est_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
303: nvl(p_rec.attribute18, hr_api.g_varchar2) or
304: nvl(per_est_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

Line 301: nvl(p_rec.attribute17, hr_api.g_varchar2) or

297: nvl(p_rec.attribute15, hr_api.g_varchar2) or
298: nvl(per_est_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
299: nvl(p_rec.attribute16, hr_api.g_varchar2) or
300: nvl(per_est_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
301: nvl(p_rec.attribute17, hr_api.g_varchar2) or
302: nvl(per_est_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
303: nvl(p_rec.attribute18, hr_api.g_varchar2) or
304: nvl(per_est_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
305: nvl(p_rec.attribute19, hr_api.g_varchar2) or

Line 302: nvl(per_est_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

298: nvl(per_est_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
299: nvl(p_rec.attribute16, hr_api.g_varchar2) or
300: nvl(per_est_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
301: nvl(p_rec.attribute17, hr_api.g_varchar2) or
302: nvl(per_est_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
303: nvl(p_rec.attribute18, hr_api.g_varchar2) or
304: nvl(per_est_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
305: nvl(p_rec.attribute19, hr_api.g_varchar2) or
306: nvl(per_est_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

Line 303: nvl(p_rec.attribute18, hr_api.g_varchar2) or

299: nvl(p_rec.attribute16, hr_api.g_varchar2) or
300: nvl(per_est_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
301: nvl(p_rec.attribute17, hr_api.g_varchar2) or
302: nvl(per_est_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
303: nvl(p_rec.attribute18, hr_api.g_varchar2) or
304: nvl(per_est_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
305: nvl(p_rec.attribute19, hr_api.g_varchar2) or
306: nvl(per_est_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
307: nvl(p_rec.attribute20, hr_api.g_varchar2)))

Line 304: nvl(per_est_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

300: nvl(per_est_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
301: nvl(p_rec.attribute17, hr_api.g_varchar2) or
302: nvl(per_est_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
303: nvl(p_rec.attribute18, hr_api.g_varchar2) or
304: nvl(per_est_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
305: nvl(p_rec.attribute19, hr_api.g_varchar2) or
306: nvl(per_est_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
307: nvl(p_rec.attribute20, hr_api.g_varchar2)))
308: or

Line 305: nvl(p_rec.attribute19, hr_api.g_varchar2) or

301: nvl(p_rec.attribute17, hr_api.g_varchar2) or
302: nvl(per_est_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
303: nvl(p_rec.attribute18, hr_api.g_varchar2) or
304: nvl(per_est_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
305: nvl(p_rec.attribute19, hr_api.g_varchar2) or
306: nvl(per_est_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
307: nvl(p_rec.attribute20, hr_api.g_varchar2)))
308: or
309: (p_rec.establishment_id is null) then

Line 306: nvl(per_est_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

302: nvl(per_est_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
303: nvl(p_rec.attribute18, hr_api.g_varchar2) or
304: nvl(per_est_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
305: nvl(p_rec.attribute19, hr_api.g_varchar2) or
306: nvl(per_est_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
307: nvl(p_rec.attribute20, hr_api.g_varchar2)))
308: or
309: (p_rec.establishment_id is null) then
310: --

Line 307: nvl(p_rec.attribute20, hr_api.g_varchar2)))

303: nvl(p_rec.attribute18, hr_api.g_varchar2) or
304: nvl(per_est_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
305: nvl(p_rec.attribute19, hr_api.g_varchar2) or
306: nvl(per_est_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
307: nvl(p_rec.attribute20, hr_api.g_varchar2)))
308: or
309: (p_rec.establishment_id is null) then
310: --
311: -- Only execute the validation if absolutely necessary:

Line 404: nvl(per_est_shd.g_old_rec.est_information_category, hr_api.g_varchar2) <>

400: begin
401: hr_utility.set_location('Entering:'||l_proc,10);
402: --
403: if ((p_rec.establishment_id is not null) and (
404: nvl(per_est_shd.g_old_rec.est_information_category, hr_api.g_varchar2) <>
405: nvl(p_rec.est_information_category, hr_api.g_varchar2) or
406: nvl(per_est_shd.g_old_rec.est_information1, hr_api.g_varchar2) <>
407: nvl(p_rec.est_information1, hr_api.g_varchar2) or
408: nvl(per_est_shd.g_old_rec.est_information2, hr_api.g_varchar2) <>

Line 405: nvl(p_rec.est_information_category, hr_api.g_varchar2) or

401: hr_utility.set_location('Entering:'||l_proc,10);
402: --
403: if ((p_rec.establishment_id is not null) and (
404: nvl(per_est_shd.g_old_rec.est_information_category, hr_api.g_varchar2) <>
405: nvl(p_rec.est_information_category, hr_api.g_varchar2) or
406: nvl(per_est_shd.g_old_rec.est_information1, hr_api.g_varchar2) <>
407: nvl(p_rec.est_information1, hr_api.g_varchar2) or
408: nvl(per_est_shd.g_old_rec.est_information2, hr_api.g_varchar2) <>
409: nvl(p_rec.est_information2, hr_api.g_varchar2) or

Line 406: nvl(per_est_shd.g_old_rec.est_information1, hr_api.g_varchar2) <>

402: --
403: if ((p_rec.establishment_id is not null) and (
404: nvl(per_est_shd.g_old_rec.est_information_category, hr_api.g_varchar2) <>
405: nvl(p_rec.est_information_category, hr_api.g_varchar2) or
406: nvl(per_est_shd.g_old_rec.est_information1, hr_api.g_varchar2) <>
407: nvl(p_rec.est_information1, hr_api.g_varchar2) or
408: nvl(per_est_shd.g_old_rec.est_information2, hr_api.g_varchar2) <>
409: nvl(p_rec.est_information2, hr_api.g_varchar2) or
410: nvl(per_est_shd.g_old_rec.est_information3, hr_api.g_varchar2) <>

Line 407: nvl(p_rec.est_information1, hr_api.g_varchar2) or

403: if ((p_rec.establishment_id is not null) and (
404: nvl(per_est_shd.g_old_rec.est_information_category, hr_api.g_varchar2) <>
405: nvl(p_rec.est_information_category, hr_api.g_varchar2) or
406: nvl(per_est_shd.g_old_rec.est_information1, hr_api.g_varchar2) <>
407: nvl(p_rec.est_information1, hr_api.g_varchar2) or
408: nvl(per_est_shd.g_old_rec.est_information2, hr_api.g_varchar2) <>
409: nvl(p_rec.est_information2, hr_api.g_varchar2) or
410: nvl(per_est_shd.g_old_rec.est_information3, hr_api.g_varchar2) <>
411: nvl(p_rec.est_information3, hr_api.g_varchar2) or

Line 408: nvl(per_est_shd.g_old_rec.est_information2, hr_api.g_varchar2) <>

404: nvl(per_est_shd.g_old_rec.est_information_category, hr_api.g_varchar2) <>
405: nvl(p_rec.est_information_category, hr_api.g_varchar2) or
406: nvl(per_est_shd.g_old_rec.est_information1, hr_api.g_varchar2) <>
407: nvl(p_rec.est_information1, hr_api.g_varchar2) or
408: nvl(per_est_shd.g_old_rec.est_information2, hr_api.g_varchar2) <>
409: nvl(p_rec.est_information2, hr_api.g_varchar2) or
410: nvl(per_est_shd.g_old_rec.est_information3, hr_api.g_varchar2) <>
411: nvl(p_rec.est_information3, hr_api.g_varchar2) or
412: nvl(per_est_shd.g_old_rec.est_information4, hr_api.g_varchar2) <>

Line 409: nvl(p_rec.est_information2, hr_api.g_varchar2) or

405: nvl(p_rec.est_information_category, hr_api.g_varchar2) or
406: nvl(per_est_shd.g_old_rec.est_information1, hr_api.g_varchar2) <>
407: nvl(p_rec.est_information1, hr_api.g_varchar2) or
408: nvl(per_est_shd.g_old_rec.est_information2, hr_api.g_varchar2) <>
409: nvl(p_rec.est_information2, hr_api.g_varchar2) or
410: nvl(per_est_shd.g_old_rec.est_information3, hr_api.g_varchar2) <>
411: nvl(p_rec.est_information3, hr_api.g_varchar2) or
412: nvl(per_est_shd.g_old_rec.est_information4, hr_api.g_varchar2) <>
413: nvl(p_rec.est_information4, hr_api.g_varchar2) or

Line 410: nvl(per_est_shd.g_old_rec.est_information3, hr_api.g_varchar2) <>

406: nvl(per_est_shd.g_old_rec.est_information1, hr_api.g_varchar2) <>
407: nvl(p_rec.est_information1, hr_api.g_varchar2) or
408: nvl(per_est_shd.g_old_rec.est_information2, hr_api.g_varchar2) <>
409: nvl(p_rec.est_information2, hr_api.g_varchar2) or
410: nvl(per_est_shd.g_old_rec.est_information3, hr_api.g_varchar2) <>
411: nvl(p_rec.est_information3, hr_api.g_varchar2) or
412: nvl(per_est_shd.g_old_rec.est_information4, hr_api.g_varchar2) <>
413: nvl(p_rec.est_information4, hr_api.g_varchar2) or
414: nvl(per_est_shd.g_old_rec.est_information5, hr_api.g_varchar2) <>

Line 411: nvl(p_rec.est_information3, hr_api.g_varchar2) or

407: nvl(p_rec.est_information1, hr_api.g_varchar2) or
408: nvl(per_est_shd.g_old_rec.est_information2, hr_api.g_varchar2) <>
409: nvl(p_rec.est_information2, hr_api.g_varchar2) or
410: nvl(per_est_shd.g_old_rec.est_information3, hr_api.g_varchar2) <>
411: nvl(p_rec.est_information3, hr_api.g_varchar2) or
412: nvl(per_est_shd.g_old_rec.est_information4, hr_api.g_varchar2) <>
413: nvl(p_rec.est_information4, hr_api.g_varchar2) or
414: nvl(per_est_shd.g_old_rec.est_information5, hr_api.g_varchar2) <>
415: nvl(p_rec.est_information5, hr_api.g_varchar2) or

Line 412: nvl(per_est_shd.g_old_rec.est_information4, hr_api.g_varchar2) <>

408: nvl(per_est_shd.g_old_rec.est_information2, hr_api.g_varchar2) <>
409: nvl(p_rec.est_information2, hr_api.g_varchar2) or
410: nvl(per_est_shd.g_old_rec.est_information3, hr_api.g_varchar2) <>
411: nvl(p_rec.est_information3, hr_api.g_varchar2) or
412: nvl(per_est_shd.g_old_rec.est_information4, hr_api.g_varchar2) <>
413: nvl(p_rec.est_information4, hr_api.g_varchar2) or
414: nvl(per_est_shd.g_old_rec.est_information5, hr_api.g_varchar2) <>
415: nvl(p_rec.est_information5, hr_api.g_varchar2) or
416: nvl(per_est_shd.g_old_rec.est_information6, hr_api.g_varchar2) <>

Line 413: nvl(p_rec.est_information4, hr_api.g_varchar2) or

409: nvl(p_rec.est_information2, hr_api.g_varchar2) or
410: nvl(per_est_shd.g_old_rec.est_information3, hr_api.g_varchar2) <>
411: nvl(p_rec.est_information3, hr_api.g_varchar2) or
412: nvl(per_est_shd.g_old_rec.est_information4, hr_api.g_varchar2) <>
413: nvl(p_rec.est_information4, hr_api.g_varchar2) or
414: nvl(per_est_shd.g_old_rec.est_information5, hr_api.g_varchar2) <>
415: nvl(p_rec.est_information5, hr_api.g_varchar2) or
416: nvl(per_est_shd.g_old_rec.est_information6, hr_api.g_varchar2) <>
417: nvl(p_rec.est_information6, hr_api.g_varchar2) or

Line 414: nvl(per_est_shd.g_old_rec.est_information5, hr_api.g_varchar2) <>

410: nvl(per_est_shd.g_old_rec.est_information3, hr_api.g_varchar2) <>
411: nvl(p_rec.est_information3, hr_api.g_varchar2) or
412: nvl(per_est_shd.g_old_rec.est_information4, hr_api.g_varchar2) <>
413: nvl(p_rec.est_information4, hr_api.g_varchar2) or
414: nvl(per_est_shd.g_old_rec.est_information5, hr_api.g_varchar2) <>
415: nvl(p_rec.est_information5, hr_api.g_varchar2) or
416: nvl(per_est_shd.g_old_rec.est_information6, hr_api.g_varchar2) <>
417: nvl(p_rec.est_information6, hr_api.g_varchar2) or
418: nvl(per_est_shd.g_old_rec.est_information7, hr_api.g_varchar2) <>

Line 415: nvl(p_rec.est_information5, hr_api.g_varchar2) or

411: nvl(p_rec.est_information3, hr_api.g_varchar2) or
412: nvl(per_est_shd.g_old_rec.est_information4, hr_api.g_varchar2) <>
413: nvl(p_rec.est_information4, hr_api.g_varchar2) or
414: nvl(per_est_shd.g_old_rec.est_information5, hr_api.g_varchar2) <>
415: nvl(p_rec.est_information5, hr_api.g_varchar2) or
416: nvl(per_est_shd.g_old_rec.est_information6, hr_api.g_varchar2) <>
417: nvl(p_rec.est_information6, hr_api.g_varchar2) or
418: nvl(per_est_shd.g_old_rec.est_information7, hr_api.g_varchar2) <>
419: nvl(p_rec.est_information7, hr_api.g_varchar2) or

Line 416: nvl(per_est_shd.g_old_rec.est_information6, hr_api.g_varchar2) <>

412: nvl(per_est_shd.g_old_rec.est_information4, hr_api.g_varchar2) <>
413: nvl(p_rec.est_information4, hr_api.g_varchar2) or
414: nvl(per_est_shd.g_old_rec.est_information5, hr_api.g_varchar2) <>
415: nvl(p_rec.est_information5, hr_api.g_varchar2) or
416: nvl(per_est_shd.g_old_rec.est_information6, hr_api.g_varchar2) <>
417: nvl(p_rec.est_information6, hr_api.g_varchar2) or
418: nvl(per_est_shd.g_old_rec.est_information7, hr_api.g_varchar2) <>
419: nvl(p_rec.est_information7, hr_api.g_varchar2) or
420: nvl(per_est_shd.g_old_rec.est_information8, hr_api.g_varchar2) <>

Line 417: nvl(p_rec.est_information6, hr_api.g_varchar2) or

413: nvl(p_rec.est_information4, hr_api.g_varchar2) or
414: nvl(per_est_shd.g_old_rec.est_information5, hr_api.g_varchar2) <>
415: nvl(p_rec.est_information5, hr_api.g_varchar2) or
416: nvl(per_est_shd.g_old_rec.est_information6, hr_api.g_varchar2) <>
417: nvl(p_rec.est_information6, hr_api.g_varchar2) or
418: nvl(per_est_shd.g_old_rec.est_information7, hr_api.g_varchar2) <>
419: nvl(p_rec.est_information7, hr_api.g_varchar2) or
420: nvl(per_est_shd.g_old_rec.est_information8, hr_api.g_varchar2) <>
421: nvl(p_rec.est_information8, hr_api.g_varchar2) or

Line 418: nvl(per_est_shd.g_old_rec.est_information7, hr_api.g_varchar2) <>

414: nvl(per_est_shd.g_old_rec.est_information5, hr_api.g_varchar2) <>
415: nvl(p_rec.est_information5, hr_api.g_varchar2) or
416: nvl(per_est_shd.g_old_rec.est_information6, hr_api.g_varchar2) <>
417: nvl(p_rec.est_information6, hr_api.g_varchar2) or
418: nvl(per_est_shd.g_old_rec.est_information7, hr_api.g_varchar2) <>
419: nvl(p_rec.est_information7, hr_api.g_varchar2) or
420: nvl(per_est_shd.g_old_rec.est_information8, hr_api.g_varchar2) <>
421: nvl(p_rec.est_information8, hr_api.g_varchar2) or
422: nvl(per_est_shd.g_old_rec.est_information9, hr_api.g_varchar2) <>

Line 419: nvl(p_rec.est_information7, hr_api.g_varchar2) or

415: nvl(p_rec.est_information5, hr_api.g_varchar2) or
416: nvl(per_est_shd.g_old_rec.est_information6, hr_api.g_varchar2) <>
417: nvl(p_rec.est_information6, hr_api.g_varchar2) or
418: nvl(per_est_shd.g_old_rec.est_information7, hr_api.g_varchar2) <>
419: nvl(p_rec.est_information7, hr_api.g_varchar2) or
420: nvl(per_est_shd.g_old_rec.est_information8, hr_api.g_varchar2) <>
421: nvl(p_rec.est_information8, hr_api.g_varchar2) or
422: nvl(per_est_shd.g_old_rec.est_information9, hr_api.g_varchar2) <>
423: nvl(p_rec.est_information9, hr_api.g_varchar2) or

Line 420: nvl(per_est_shd.g_old_rec.est_information8, hr_api.g_varchar2) <>

416: nvl(per_est_shd.g_old_rec.est_information6, hr_api.g_varchar2) <>
417: nvl(p_rec.est_information6, hr_api.g_varchar2) or
418: nvl(per_est_shd.g_old_rec.est_information7, hr_api.g_varchar2) <>
419: nvl(p_rec.est_information7, hr_api.g_varchar2) or
420: nvl(per_est_shd.g_old_rec.est_information8, hr_api.g_varchar2) <>
421: nvl(p_rec.est_information8, hr_api.g_varchar2) or
422: nvl(per_est_shd.g_old_rec.est_information9, hr_api.g_varchar2) <>
423: nvl(p_rec.est_information9, hr_api.g_varchar2) or
424: nvl(per_est_shd.g_old_rec.est_information10, hr_api.g_varchar2) <>

Line 421: nvl(p_rec.est_information8, hr_api.g_varchar2) or

417: nvl(p_rec.est_information6, hr_api.g_varchar2) or
418: nvl(per_est_shd.g_old_rec.est_information7, hr_api.g_varchar2) <>
419: nvl(p_rec.est_information7, hr_api.g_varchar2) or
420: nvl(per_est_shd.g_old_rec.est_information8, hr_api.g_varchar2) <>
421: nvl(p_rec.est_information8, hr_api.g_varchar2) or
422: nvl(per_est_shd.g_old_rec.est_information9, hr_api.g_varchar2) <>
423: nvl(p_rec.est_information9, hr_api.g_varchar2) or
424: nvl(per_est_shd.g_old_rec.est_information10, hr_api.g_varchar2) <>
425: nvl(p_rec.est_information10, hr_api.g_varchar2) or

Line 422: nvl(per_est_shd.g_old_rec.est_information9, hr_api.g_varchar2) <>

418: nvl(per_est_shd.g_old_rec.est_information7, hr_api.g_varchar2) <>
419: nvl(p_rec.est_information7, hr_api.g_varchar2) or
420: nvl(per_est_shd.g_old_rec.est_information8, hr_api.g_varchar2) <>
421: nvl(p_rec.est_information8, hr_api.g_varchar2) or
422: nvl(per_est_shd.g_old_rec.est_information9, hr_api.g_varchar2) <>
423: nvl(p_rec.est_information9, hr_api.g_varchar2) or
424: nvl(per_est_shd.g_old_rec.est_information10, hr_api.g_varchar2) <>
425: nvl(p_rec.est_information10, hr_api.g_varchar2) or
426: nvl(per_est_shd.g_old_rec.est_information11, hr_api.g_varchar2) <>

Line 423: nvl(p_rec.est_information9, hr_api.g_varchar2) or

419: nvl(p_rec.est_information7, hr_api.g_varchar2) or
420: nvl(per_est_shd.g_old_rec.est_information8, hr_api.g_varchar2) <>
421: nvl(p_rec.est_information8, hr_api.g_varchar2) or
422: nvl(per_est_shd.g_old_rec.est_information9, hr_api.g_varchar2) <>
423: nvl(p_rec.est_information9, hr_api.g_varchar2) or
424: nvl(per_est_shd.g_old_rec.est_information10, hr_api.g_varchar2) <>
425: nvl(p_rec.est_information10, hr_api.g_varchar2) or
426: nvl(per_est_shd.g_old_rec.est_information11, hr_api.g_varchar2) <>
427: nvl(p_rec.est_information11, hr_api.g_varchar2) or

Line 424: nvl(per_est_shd.g_old_rec.est_information10, hr_api.g_varchar2) <>

420: nvl(per_est_shd.g_old_rec.est_information8, hr_api.g_varchar2) <>
421: nvl(p_rec.est_information8, hr_api.g_varchar2) or
422: nvl(per_est_shd.g_old_rec.est_information9, hr_api.g_varchar2) <>
423: nvl(p_rec.est_information9, hr_api.g_varchar2) or
424: nvl(per_est_shd.g_old_rec.est_information10, hr_api.g_varchar2) <>
425: nvl(p_rec.est_information10, hr_api.g_varchar2) or
426: nvl(per_est_shd.g_old_rec.est_information11, hr_api.g_varchar2) <>
427: nvl(p_rec.est_information11, hr_api.g_varchar2) or
428: nvl(per_est_shd.g_old_rec.est_information12, hr_api.g_varchar2) <>

Line 425: nvl(p_rec.est_information10, hr_api.g_varchar2) or

421: nvl(p_rec.est_information8, hr_api.g_varchar2) or
422: nvl(per_est_shd.g_old_rec.est_information9, hr_api.g_varchar2) <>
423: nvl(p_rec.est_information9, hr_api.g_varchar2) or
424: nvl(per_est_shd.g_old_rec.est_information10, hr_api.g_varchar2) <>
425: nvl(p_rec.est_information10, hr_api.g_varchar2) or
426: nvl(per_est_shd.g_old_rec.est_information11, hr_api.g_varchar2) <>
427: nvl(p_rec.est_information11, hr_api.g_varchar2) or
428: nvl(per_est_shd.g_old_rec.est_information12, hr_api.g_varchar2) <>
429: nvl(p_rec.est_information12, hr_api.g_varchar2) or

Line 426: nvl(per_est_shd.g_old_rec.est_information11, hr_api.g_varchar2) <>

422: nvl(per_est_shd.g_old_rec.est_information9, hr_api.g_varchar2) <>
423: nvl(p_rec.est_information9, hr_api.g_varchar2) or
424: nvl(per_est_shd.g_old_rec.est_information10, hr_api.g_varchar2) <>
425: nvl(p_rec.est_information10, hr_api.g_varchar2) or
426: nvl(per_est_shd.g_old_rec.est_information11, hr_api.g_varchar2) <>
427: nvl(p_rec.est_information11, hr_api.g_varchar2) or
428: nvl(per_est_shd.g_old_rec.est_information12, hr_api.g_varchar2) <>
429: nvl(p_rec.est_information12, hr_api.g_varchar2) or
430: nvl(per_est_shd.g_old_rec.est_information13, hr_api.g_varchar2) <>

Line 427: nvl(p_rec.est_information11, hr_api.g_varchar2) or

423: nvl(p_rec.est_information9, hr_api.g_varchar2) or
424: nvl(per_est_shd.g_old_rec.est_information10, hr_api.g_varchar2) <>
425: nvl(p_rec.est_information10, hr_api.g_varchar2) or
426: nvl(per_est_shd.g_old_rec.est_information11, hr_api.g_varchar2) <>
427: nvl(p_rec.est_information11, hr_api.g_varchar2) or
428: nvl(per_est_shd.g_old_rec.est_information12, hr_api.g_varchar2) <>
429: nvl(p_rec.est_information12, hr_api.g_varchar2) or
430: nvl(per_est_shd.g_old_rec.est_information13, hr_api.g_varchar2) <>
431: nvl(p_rec.est_information13, hr_api.g_varchar2) or

Line 428: nvl(per_est_shd.g_old_rec.est_information12, hr_api.g_varchar2) <>

424: nvl(per_est_shd.g_old_rec.est_information10, hr_api.g_varchar2) <>
425: nvl(p_rec.est_information10, hr_api.g_varchar2) or
426: nvl(per_est_shd.g_old_rec.est_information11, hr_api.g_varchar2) <>
427: nvl(p_rec.est_information11, hr_api.g_varchar2) or
428: nvl(per_est_shd.g_old_rec.est_information12, hr_api.g_varchar2) <>
429: nvl(p_rec.est_information12, hr_api.g_varchar2) or
430: nvl(per_est_shd.g_old_rec.est_information13, hr_api.g_varchar2) <>
431: nvl(p_rec.est_information13, hr_api.g_varchar2) or
432: nvl(per_est_shd.g_old_rec.est_information14, hr_api.g_varchar2) <>

Line 429: nvl(p_rec.est_information12, hr_api.g_varchar2) or

425: nvl(p_rec.est_information10, hr_api.g_varchar2) or
426: nvl(per_est_shd.g_old_rec.est_information11, hr_api.g_varchar2) <>
427: nvl(p_rec.est_information11, hr_api.g_varchar2) or
428: nvl(per_est_shd.g_old_rec.est_information12, hr_api.g_varchar2) <>
429: nvl(p_rec.est_information12, hr_api.g_varchar2) or
430: nvl(per_est_shd.g_old_rec.est_information13, hr_api.g_varchar2) <>
431: nvl(p_rec.est_information13, hr_api.g_varchar2) or
432: nvl(per_est_shd.g_old_rec.est_information14, hr_api.g_varchar2) <>
433: nvl(p_rec.est_information14, hr_api.g_varchar2) or

Line 430: nvl(per_est_shd.g_old_rec.est_information13, hr_api.g_varchar2) <>

426: nvl(per_est_shd.g_old_rec.est_information11, hr_api.g_varchar2) <>
427: nvl(p_rec.est_information11, hr_api.g_varchar2) or
428: nvl(per_est_shd.g_old_rec.est_information12, hr_api.g_varchar2) <>
429: nvl(p_rec.est_information12, hr_api.g_varchar2) or
430: nvl(per_est_shd.g_old_rec.est_information13, hr_api.g_varchar2) <>
431: nvl(p_rec.est_information13, hr_api.g_varchar2) or
432: nvl(per_est_shd.g_old_rec.est_information14, hr_api.g_varchar2) <>
433: nvl(p_rec.est_information14, hr_api.g_varchar2) or
434: nvl(per_est_shd.g_old_rec.est_information15, hr_api.g_varchar2) <>

Line 431: nvl(p_rec.est_information13, hr_api.g_varchar2) or

427: nvl(p_rec.est_information11, hr_api.g_varchar2) or
428: nvl(per_est_shd.g_old_rec.est_information12, hr_api.g_varchar2) <>
429: nvl(p_rec.est_information12, hr_api.g_varchar2) or
430: nvl(per_est_shd.g_old_rec.est_information13, hr_api.g_varchar2) <>
431: nvl(p_rec.est_information13, hr_api.g_varchar2) or
432: nvl(per_est_shd.g_old_rec.est_information14, hr_api.g_varchar2) <>
433: nvl(p_rec.est_information14, hr_api.g_varchar2) or
434: nvl(per_est_shd.g_old_rec.est_information15, hr_api.g_varchar2) <>
435: nvl(p_rec.est_information15, hr_api.g_varchar2) or

Line 432: nvl(per_est_shd.g_old_rec.est_information14, hr_api.g_varchar2) <>

428: nvl(per_est_shd.g_old_rec.est_information12, hr_api.g_varchar2) <>
429: nvl(p_rec.est_information12, hr_api.g_varchar2) or
430: nvl(per_est_shd.g_old_rec.est_information13, hr_api.g_varchar2) <>
431: nvl(p_rec.est_information13, hr_api.g_varchar2) or
432: nvl(per_est_shd.g_old_rec.est_information14, hr_api.g_varchar2) <>
433: nvl(p_rec.est_information14, hr_api.g_varchar2) or
434: nvl(per_est_shd.g_old_rec.est_information15, hr_api.g_varchar2) <>
435: nvl(p_rec.est_information15, hr_api.g_varchar2) or
436: nvl(per_est_shd.g_old_rec.est_information16, hr_api.g_varchar2) <>

Line 433: nvl(p_rec.est_information14, hr_api.g_varchar2) or

429: nvl(p_rec.est_information12, hr_api.g_varchar2) or
430: nvl(per_est_shd.g_old_rec.est_information13, hr_api.g_varchar2) <>
431: nvl(p_rec.est_information13, hr_api.g_varchar2) or
432: nvl(per_est_shd.g_old_rec.est_information14, hr_api.g_varchar2) <>
433: nvl(p_rec.est_information14, hr_api.g_varchar2) or
434: nvl(per_est_shd.g_old_rec.est_information15, hr_api.g_varchar2) <>
435: nvl(p_rec.est_information15, hr_api.g_varchar2) or
436: nvl(per_est_shd.g_old_rec.est_information16, hr_api.g_varchar2) <>
437: nvl(p_rec.est_information16, hr_api.g_varchar2) or

Line 434: nvl(per_est_shd.g_old_rec.est_information15, hr_api.g_varchar2) <>

430: nvl(per_est_shd.g_old_rec.est_information13, hr_api.g_varchar2) <>
431: nvl(p_rec.est_information13, hr_api.g_varchar2) or
432: nvl(per_est_shd.g_old_rec.est_information14, hr_api.g_varchar2) <>
433: nvl(p_rec.est_information14, hr_api.g_varchar2) or
434: nvl(per_est_shd.g_old_rec.est_information15, hr_api.g_varchar2) <>
435: nvl(p_rec.est_information15, hr_api.g_varchar2) or
436: nvl(per_est_shd.g_old_rec.est_information16, hr_api.g_varchar2) <>
437: nvl(p_rec.est_information16, hr_api.g_varchar2) or
438: nvl(per_est_shd.g_old_rec.est_information17, hr_api.g_varchar2) <>

Line 435: nvl(p_rec.est_information15, hr_api.g_varchar2) or

431: nvl(p_rec.est_information13, hr_api.g_varchar2) or
432: nvl(per_est_shd.g_old_rec.est_information14, hr_api.g_varchar2) <>
433: nvl(p_rec.est_information14, hr_api.g_varchar2) or
434: nvl(per_est_shd.g_old_rec.est_information15, hr_api.g_varchar2) <>
435: nvl(p_rec.est_information15, hr_api.g_varchar2) or
436: nvl(per_est_shd.g_old_rec.est_information16, hr_api.g_varchar2) <>
437: nvl(p_rec.est_information16, hr_api.g_varchar2) or
438: nvl(per_est_shd.g_old_rec.est_information17, hr_api.g_varchar2) <>
439: nvl(p_rec.est_information17, hr_api.g_varchar2) or

Line 436: nvl(per_est_shd.g_old_rec.est_information16, hr_api.g_varchar2) <>

432: nvl(per_est_shd.g_old_rec.est_information14, hr_api.g_varchar2) <>
433: nvl(p_rec.est_information14, hr_api.g_varchar2) or
434: nvl(per_est_shd.g_old_rec.est_information15, hr_api.g_varchar2) <>
435: nvl(p_rec.est_information15, hr_api.g_varchar2) or
436: nvl(per_est_shd.g_old_rec.est_information16, hr_api.g_varchar2) <>
437: nvl(p_rec.est_information16, hr_api.g_varchar2) or
438: nvl(per_est_shd.g_old_rec.est_information17, hr_api.g_varchar2) <>
439: nvl(p_rec.est_information17, hr_api.g_varchar2) or
440: nvl(per_est_shd.g_old_rec.est_information18, hr_api.g_varchar2) <>

Line 437: nvl(p_rec.est_information16, hr_api.g_varchar2) or

433: nvl(p_rec.est_information14, hr_api.g_varchar2) or
434: nvl(per_est_shd.g_old_rec.est_information15, hr_api.g_varchar2) <>
435: nvl(p_rec.est_information15, hr_api.g_varchar2) or
436: nvl(per_est_shd.g_old_rec.est_information16, hr_api.g_varchar2) <>
437: nvl(p_rec.est_information16, hr_api.g_varchar2) or
438: nvl(per_est_shd.g_old_rec.est_information17, hr_api.g_varchar2) <>
439: nvl(p_rec.est_information17, hr_api.g_varchar2) or
440: nvl(per_est_shd.g_old_rec.est_information18, hr_api.g_varchar2) <>
441: nvl(p_rec.est_information18, hr_api.g_varchar2) or

Line 438: nvl(per_est_shd.g_old_rec.est_information17, hr_api.g_varchar2) <>

434: nvl(per_est_shd.g_old_rec.est_information15, hr_api.g_varchar2) <>
435: nvl(p_rec.est_information15, hr_api.g_varchar2) or
436: nvl(per_est_shd.g_old_rec.est_information16, hr_api.g_varchar2) <>
437: nvl(p_rec.est_information16, hr_api.g_varchar2) or
438: nvl(per_est_shd.g_old_rec.est_information17, hr_api.g_varchar2) <>
439: nvl(p_rec.est_information17, hr_api.g_varchar2) or
440: nvl(per_est_shd.g_old_rec.est_information18, hr_api.g_varchar2) <>
441: nvl(p_rec.est_information18, hr_api.g_varchar2) or
442: nvl(per_est_shd.g_old_rec.est_information19, hr_api.g_varchar2) <>

Line 439: nvl(p_rec.est_information17, hr_api.g_varchar2) or

435: nvl(p_rec.est_information15, hr_api.g_varchar2) or
436: nvl(per_est_shd.g_old_rec.est_information16, hr_api.g_varchar2) <>
437: nvl(p_rec.est_information16, hr_api.g_varchar2) or
438: nvl(per_est_shd.g_old_rec.est_information17, hr_api.g_varchar2) <>
439: nvl(p_rec.est_information17, hr_api.g_varchar2) or
440: nvl(per_est_shd.g_old_rec.est_information18, hr_api.g_varchar2) <>
441: nvl(p_rec.est_information18, hr_api.g_varchar2) or
442: nvl(per_est_shd.g_old_rec.est_information19, hr_api.g_varchar2) <>
443: nvl(p_rec.est_information19, hr_api.g_varchar2) or

Line 440: nvl(per_est_shd.g_old_rec.est_information18, hr_api.g_varchar2) <>

436: nvl(per_est_shd.g_old_rec.est_information16, hr_api.g_varchar2) <>
437: nvl(p_rec.est_information16, hr_api.g_varchar2) or
438: nvl(per_est_shd.g_old_rec.est_information17, hr_api.g_varchar2) <>
439: nvl(p_rec.est_information17, hr_api.g_varchar2) or
440: nvl(per_est_shd.g_old_rec.est_information18, hr_api.g_varchar2) <>
441: nvl(p_rec.est_information18, hr_api.g_varchar2) or
442: nvl(per_est_shd.g_old_rec.est_information19, hr_api.g_varchar2) <>
443: nvl(p_rec.est_information19, hr_api.g_varchar2) or
444: nvl(per_est_shd.g_old_rec.est_information20, hr_api.g_varchar2) <>

Line 441: nvl(p_rec.est_information18, hr_api.g_varchar2) or

437: nvl(p_rec.est_information16, hr_api.g_varchar2) or
438: nvl(per_est_shd.g_old_rec.est_information17, hr_api.g_varchar2) <>
439: nvl(p_rec.est_information17, hr_api.g_varchar2) or
440: nvl(per_est_shd.g_old_rec.est_information18, hr_api.g_varchar2) <>
441: nvl(p_rec.est_information18, hr_api.g_varchar2) or
442: nvl(per_est_shd.g_old_rec.est_information19, hr_api.g_varchar2) <>
443: nvl(p_rec.est_information19, hr_api.g_varchar2) or
444: nvl(per_est_shd.g_old_rec.est_information20, hr_api.g_varchar2) <>
445: nvl(p_rec.est_information20, hr_api.g_varchar2) ))

Line 442: nvl(per_est_shd.g_old_rec.est_information19, hr_api.g_varchar2) <>

438: nvl(per_est_shd.g_old_rec.est_information17, hr_api.g_varchar2) <>
439: nvl(p_rec.est_information17, hr_api.g_varchar2) or
440: nvl(per_est_shd.g_old_rec.est_information18, hr_api.g_varchar2) <>
441: nvl(p_rec.est_information18, hr_api.g_varchar2) or
442: nvl(per_est_shd.g_old_rec.est_information19, hr_api.g_varchar2) <>
443: nvl(p_rec.est_information19, hr_api.g_varchar2) or
444: nvl(per_est_shd.g_old_rec.est_information20, hr_api.g_varchar2) <>
445: nvl(p_rec.est_information20, hr_api.g_varchar2) ))
446: or (p_rec.establishment_id is null) then

Line 443: nvl(p_rec.est_information19, hr_api.g_varchar2) or

439: nvl(p_rec.est_information17, hr_api.g_varchar2) or
440: nvl(per_est_shd.g_old_rec.est_information18, hr_api.g_varchar2) <>
441: nvl(p_rec.est_information18, hr_api.g_varchar2) or
442: nvl(per_est_shd.g_old_rec.est_information19, hr_api.g_varchar2) <>
443: nvl(p_rec.est_information19, hr_api.g_varchar2) or
444: nvl(per_est_shd.g_old_rec.est_information20, hr_api.g_varchar2) <>
445: nvl(p_rec.est_information20, hr_api.g_varchar2) ))
446: or (p_rec.establishment_id is null) then
447: --

Line 444: nvl(per_est_shd.g_old_rec.est_information20, hr_api.g_varchar2) <>

440: nvl(per_est_shd.g_old_rec.est_information18, hr_api.g_varchar2) <>
441: nvl(p_rec.est_information18, hr_api.g_varchar2) or
442: nvl(per_est_shd.g_old_rec.est_information19, hr_api.g_varchar2) <>
443: nvl(p_rec.est_information19, hr_api.g_varchar2) or
444: nvl(per_est_shd.g_old_rec.est_information20, hr_api.g_varchar2) <>
445: nvl(p_rec.est_information20, hr_api.g_varchar2) ))
446: or (p_rec.establishment_id is null) then
447: --
448: -- Only execute the validation if absolutely necessary:

Line 445: nvl(p_rec.est_information20, hr_api.g_varchar2) ))

441: nvl(p_rec.est_information18, hr_api.g_varchar2) or
442: nvl(per_est_shd.g_old_rec.est_information19, hr_api.g_varchar2) <>
443: nvl(p_rec.est_information19, hr_api.g_varchar2) or
444: nvl(per_est_shd.g_old_rec.est_information20, hr_api.g_varchar2) <>
445: nvl(p_rec.est_information20, hr_api.g_varchar2) ))
446: or (p_rec.establishment_id is null) then
447: --
448: -- Only execute the validation if absolutely necessary:
449: -- a) During update, the structure column value or any

Line 517: hr_api.set_security_group_id(p_security_group_id => fnd_global.security_group_id);

513: -- the set_security_group_id procedure has zero passed
514: -- to it as the default security_group_id.
515: --
516: If hr_multi_tenancy_pkg.is_multi_tenant_system Then
517: hr_api.set_security_group_id(p_security_group_id => fnd_global.security_group_id);
518: Else
519: hr_api.set_security_group_id(p_security_group_id => 0);
520: End If;
521: --

Line 519: hr_api.set_security_group_id(p_security_group_id => 0);

515: --
516: If hr_multi_tenancy_pkg.is_multi_tenant_system Then
517: hr_api.set_security_group_id(p_security_group_id => fnd_global.security_group_id);
518: Else
519: hr_api.set_security_group_id(p_security_group_id => 0);
520: End If;
521: --
522: hr_utility.set_location('Entering:'||l_proc, 7);
523: --

Line 566: hr_api.set_security_group_id(p_security_group_id => fnd_global.security_group_id);

562: -- the set_security_group_id procedure has zero passed
563: -- to it as the default security_group_id.
564: --
565: If hr_multi_tenancy_pkg.is_multi_tenant_system Then
566: hr_api.set_security_group_id(p_security_group_id => fnd_global.security_group_id);
567: Else
568: hr_api.set_security_group_id(p_security_group_id => 0);
569: End If;
570: --

Line 568: hr_api.set_security_group_id(p_security_group_id => 0);

564: --
565: If hr_multi_tenancy_pkg.is_multi_tenant_system Then
566: hr_api.set_security_group_id(p_security_group_id => fnd_global.security_group_id);
567: Else
568: hr_api.set_security_group_id(p_security_group_id => 0);
569: End If;
570: --
571: hr_utility.set_location('Entering:'||l_proc, 7);
572: --