53: begin
54: --
55: hr_utility.set_location('Entering:'||l_proc,5);
56: --
57: l_api_updating := per_est_shd.api_updating
58: (p_establishment_id => p_establishment_id,
59: p_object_version_number => p_object_version_number);
60: --
61: if not l_api_updating
59: p_object_version_number => p_object_version_number);
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: --
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
69: --
95: --
96: -- raise error as name and location exists
97: --
98: close c1;
99: per_est_shd.constraint_error('PER_ESTABLISHMENTS_UK');
100: --
101: end if;
102: --
103: close c1;
139: Begin
140: --
141: hr_utility.set_location('Entering:'||l_proc, 5);
142: --
143: l_api_updating := per_est_shd.api_updating
144: (p_establishment_id => p_establishment_id,
145: p_object_version_number => p_object_version_number);
146: --
147: if (not l_api_updating) then
149: if p_establishment_id is not null then
150: --
151: -- raise error as establishment id is a not null value
152: --
153: per_est_shd.constraint_error('PER_ESTABLISHMENTS_PK');
154: --
155: end if;
156: --
157: elsif (l_api_updating
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: --
163: per_est_shd.constraint_error('PER_ESTABLISHMENTS_PK');
159: <> per_est_shd.g_old_rec.establishment_id) then
160: --
161: -- raise error as PK has been updated
162: --
163: per_est_shd.constraint_error('PER_ESTABLISHMENTS_PK');
164: --
165: end if;
166: --
167: hr_utility.set_location(' Leaving:'||l_proc, 10);
254: -- Access Status:
255: -- Internal Row Handler Use Only.
256: --
257: procedure chk_df
258: (p_rec in per_est_shd.g_rec_type) is
259: --
260: l_proc varchar2(72) := g_package||'chk_df';
261: --
262: begin
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) <>
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) <>
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) <>
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) <>
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) <>
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) <>
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) <>
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) <>
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) <>
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) <>
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) <>
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) <>
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) <>
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) <>
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) <>
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) <>
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) <>
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) <>
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) <>
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
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: --
391: -- Internal Row Handler Use Only.
392: --
393: -- ----------------------------------------------------------------------------
394: procedure chk_ddf
395: (p_rec in per_est_shd.g_rec_type
396: ) is
397: --
398: l_proc varchar2(72) := g_package || 'chk_ddf';
399: --
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) <>
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) <>
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) <>
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) <>
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) <>
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) <>
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) <>
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) <>
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) <>
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) <>
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) <>
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) <>
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) <>
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) <>
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) <>
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) <>
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) <>
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) <>
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) <>
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
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:
501: end chk_ddf;
502: -- ----------------------------------------------------------------------------
503: -- |---------------------------< insert_validate >----------------------------|
504: -- ----------------------------------------------------------------------------
505: Procedure insert_validate(p_rec in per_est_shd.g_rec_type) is
506: --
507: l_proc varchar2(72) := g_package||'insert_validate';
508: --
509: Begin
550: --
551: -- ----------------------------------------------------------------------------
552: -- |---------------------------< update_validate >----------------------------|
553: -- ----------------------------------------------------------------------------
554: Procedure update_validate(p_rec in per_est_shd.g_rec_type) is
555: --
556: l_proc varchar2(72) := g_package||'update_validate';
557: --
558: Begin
599: --
600: -- ----------------------------------------------------------------------------
601: -- |---------------------------< delete_validate >----------------------------|
602: -- ----------------------------------------------------------------------------
603: Procedure delete_validate(p_rec in per_est_shd.g_rec_type) is
604: --
605: l_proc varchar2(72) := g_package||'delete_validate';
606: --
607: Begin