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.HR_LEI_BUS dependencies on HR_LEI_SHD

Line 113: Procedure chk_non_updateable_args(p_rec in hr_lei_shd.g_rec_type) is

109: --
110: -- {End Of Comments}
111: -- ----------------------------------------------------------------------------
112: --
113: Procedure chk_non_updateable_args(p_rec in hr_lei_shd.g_rec_type) is
114: --
115: l_proc varchar2(72) := g_package||'chk_non_updateable_args';
116: l_error exception;
117: l_argument varchar2(30);

Line 125: if not hr_lei_shd.api_updating

121: hr_utility.set_location('Entering:'|| l_proc,10);
122: --
123: -- Only proceed with validation if a row exists for
124: -- the current record in the HR Schema.
125: if not hr_lei_shd.api_updating
126: (p_location_extra_info_id => p_rec.location_extra_info_id
127: ,p_object_version_number => p_rec.object_version_number
128: ) then
129: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');

Line 137: <> nvl(hr_lei_shd.g_old_rec.location_id,hr_api.g_number) then

133: --
134: hr_utility.set_location (l_proc, 30);
135: --
136: if nvl(p_rec.location_id,hr_api.g_number)
137: <> nvl(hr_lei_shd.g_old_rec.location_id,hr_api.g_number) then
138: l_argument := 'location_id';
139: raise l_error;
140: end if;
141: --

Line 143: <> nvl(hr_lei_shd.g_old_rec.information_type,hr_api.g_varchar2) then

139: raise l_error;
140: end if;
141: --
142: if nvl(p_rec.information_type,hr_api.g_varchar2)
143: <> nvl(hr_lei_shd.g_old_rec.information_type,hr_api.g_varchar2) then
144: l_argument := 'information_type';
145: raise l_error;
146: end if;
147: --

Line 381: (p_rec in hr_lei_shd.g_rec_type) is

377: -- {End Of Comments}
378: --
379: -- -----------------------------------------------------------------------
380: procedure chk_df
381: (p_rec in hr_lei_shd.g_rec_type) is
382: --
383: l_proc varchar2(72) := g_package||'chk_df';
384: --
385: begin

Line 389: nvl(hr_lei_shd.g_old_rec.lei_attribute_category, hr_api.g_varchar2) <>

385: begin
386: hr_utility.set_location('Entering:'||l_proc, 10);
387: --
388: if ((p_rec.location_extra_info_id is not null) and (
389: nvl(hr_lei_shd.g_old_rec.lei_attribute_category, hr_api.g_varchar2) <>
390: nvl(p_rec.lei_attribute_category, hr_api.g_varchar2) or
391: nvl(hr_lei_shd.g_old_rec.lei_attribute1, hr_api.g_varchar2) <>
392: nvl(p_rec.lei_attribute1, hr_api.g_varchar2) or
393: nvl(hr_lei_shd.g_old_rec.lei_attribute2, hr_api.g_varchar2) <>

Line 391: nvl(hr_lei_shd.g_old_rec.lei_attribute1, hr_api.g_varchar2) <>

387: --
388: if ((p_rec.location_extra_info_id is not null) and (
389: nvl(hr_lei_shd.g_old_rec.lei_attribute_category, hr_api.g_varchar2) <>
390: nvl(p_rec.lei_attribute_category, hr_api.g_varchar2) or
391: nvl(hr_lei_shd.g_old_rec.lei_attribute1, hr_api.g_varchar2) <>
392: nvl(p_rec.lei_attribute1, hr_api.g_varchar2) or
393: nvl(hr_lei_shd.g_old_rec.lei_attribute2, hr_api.g_varchar2) <>
394: nvl(p_rec.lei_attribute2, hr_api.g_varchar2) or
395: nvl(hr_lei_shd.g_old_rec.lei_attribute3, hr_api.g_varchar2) <>

Line 393: nvl(hr_lei_shd.g_old_rec.lei_attribute2, hr_api.g_varchar2) <>

389: nvl(hr_lei_shd.g_old_rec.lei_attribute_category, hr_api.g_varchar2) <>
390: nvl(p_rec.lei_attribute_category, hr_api.g_varchar2) or
391: nvl(hr_lei_shd.g_old_rec.lei_attribute1, hr_api.g_varchar2) <>
392: nvl(p_rec.lei_attribute1, hr_api.g_varchar2) or
393: nvl(hr_lei_shd.g_old_rec.lei_attribute2, hr_api.g_varchar2) <>
394: nvl(p_rec.lei_attribute2, hr_api.g_varchar2) or
395: nvl(hr_lei_shd.g_old_rec.lei_attribute3, hr_api.g_varchar2) <>
396: nvl(p_rec.lei_attribute3, hr_api.g_varchar2) or
397: nvl(hr_lei_shd.g_old_rec.lei_attribute4, hr_api.g_varchar2) <>

Line 395: nvl(hr_lei_shd.g_old_rec.lei_attribute3, hr_api.g_varchar2) <>

391: nvl(hr_lei_shd.g_old_rec.lei_attribute1, hr_api.g_varchar2) <>
392: nvl(p_rec.lei_attribute1, hr_api.g_varchar2) or
393: nvl(hr_lei_shd.g_old_rec.lei_attribute2, hr_api.g_varchar2) <>
394: nvl(p_rec.lei_attribute2, hr_api.g_varchar2) or
395: nvl(hr_lei_shd.g_old_rec.lei_attribute3, hr_api.g_varchar2) <>
396: nvl(p_rec.lei_attribute3, hr_api.g_varchar2) or
397: nvl(hr_lei_shd.g_old_rec.lei_attribute4, hr_api.g_varchar2) <>
398: nvl(p_rec.lei_attribute4, hr_api.g_varchar2) or
399: nvl(hr_lei_shd.g_old_rec.lei_attribute5, hr_api.g_varchar2) <>

Line 397: nvl(hr_lei_shd.g_old_rec.lei_attribute4, hr_api.g_varchar2) <>

393: nvl(hr_lei_shd.g_old_rec.lei_attribute2, hr_api.g_varchar2) <>
394: nvl(p_rec.lei_attribute2, hr_api.g_varchar2) or
395: nvl(hr_lei_shd.g_old_rec.lei_attribute3, hr_api.g_varchar2) <>
396: nvl(p_rec.lei_attribute3, hr_api.g_varchar2) or
397: nvl(hr_lei_shd.g_old_rec.lei_attribute4, hr_api.g_varchar2) <>
398: nvl(p_rec.lei_attribute4, hr_api.g_varchar2) or
399: nvl(hr_lei_shd.g_old_rec.lei_attribute5, hr_api.g_varchar2) <>
400: nvl(p_rec.lei_attribute5, hr_api.g_varchar2) or
401: nvl(hr_lei_shd.g_old_rec.lei_attribute6, hr_api.g_varchar2) <>

Line 399: nvl(hr_lei_shd.g_old_rec.lei_attribute5, hr_api.g_varchar2) <>

395: nvl(hr_lei_shd.g_old_rec.lei_attribute3, hr_api.g_varchar2) <>
396: nvl(p_rec.lei_attribute3, hr_api.g_varchar2) or
397: nvl(hr_lei_shd.g_old_rec.lei_attribute4, hr_api.g_varchar2) <>
398: nvl(p_rec.lei_attribute4, hr_api.g_varchar2) or
399: nvl(hr_lei_shd.g_old_rec.lei_attribute5, hr_api.g_varchar2) <>
400: nvl(p_rec.lei_attribute5, hr_api.g_varchar2) or
401: nvl(hr_lei_shd.g_old_rec.lei_attribute6, hr_api.g_varchar2) <>
402: nvl(p_rec.lei_attribute6, hr_api.g_varchar2) or
403: nvl(hr_lei_shd.g_old_rec.lei_attribute7, hr_api.g_varchar2) <>

Line 401: nvl(hr_lei_shd.g_old_rec.lei_attribute6, hr_api.g_varchar2) <>

397: nvl(hr_lei_shd.g_old_rec.lei_attribute4, hr_api.g_varchar2) <>
398: nvl(p_rec.lei_attribute4, hr_api.g_varchar2) or
399: nvl(hr_lei_shd.g_old_rec.lei_attribute5, hr_api.g_varchar2) <>
400: nvl(p_rec.lei_attribute5, hr_api.g_varchar2) or
401: nvl(hr_lei_shd.g_old_rec.lei_attribute6, hr_api.g_varchar2) <>
402: nvl(p_rec.lei_attribute6, hr_api.g_varchar2) or
403: nvl(hr_lei_shd.g_old_rec.lei_attribute7, hr_api.g_varchar2) <>
404: nvl(p_rec.lei_attribute7, hr_api.g_varchar2) or
405: nvl(hr_lei_shd.g_old_rec.lei_attribute8, hr_api.g_varchar2) <>

Line 403: nvl(hr_lei_shd.g_old_rec.lei_attribute7, hr_api.g_varchar2) <>

399: nvl(hr_lei_shd.g_old_rec.lei_attribute5, hr_api.g_varchar2) <>
400: nvl(p_rec.lei_attribute5, hr_api.g_varchar2) or
401: nvl(hr_lei_shd.g_old_rec.lei_attribute6, hr_api.g_varchar2) <>
402: nvl(p_rec.lei_attribute6, hr_api.g_varchar2) or
403: nvl(hr_lei_shd.g_old_rec.lei_attribute7, hr_api.g_varchar2) <>
404: nvl(p_rec.lei_attribute7, hr_api.g_varchar2) or
405: nvl(hr_lei_shd.g_old_rec.lei_attribute8, hr_api.g_varchar2) <>
406: nvl(p_rec.lei_attribute8, hr_api.g_varchar2) or
407: nvl(hr_lei_shd.g_old_rec.lei_attribute9, hr_api.g_varchar2) <>

Line 405: nvl(hr_lei_shd.g_old_rec.lei_attribute8, hr_api.g_varchar2) <>

401: nvl(hr_lei_shd.g_old_rec.lei_attribute6, hr_api.g_varchar2) <>
402: nvl(p_rec.lei_attribute6, hr_api.g_varchar2) or
403: nvl(hr_lei_shd.g_old_rec.lei_attribute7, hr_api.g_varchar2) <>
404: nvl(p_rec.lei_attribute7, hr_api.g_varchar2) or
405: nvl(hr_lei_shd.g_old_rec.lei_attribute8, hr_api.g_varchar2) <>
406: nvl(p_rec.lei_attribute8, hr_api.g_varchar2) or
407: nvl(hr_lei_shd.g_old_rec.lei_attribute9, hr_api.g_varchar2) <>
408: nvl(p_rec.lei_attribute9, hr_api.g_varchar2) or
409: nvl(hr_lei_shd.g_old_rec.lei_attribute10, hr_api.g_varchar2) <>

Line 407: nvl(hr_lei_shd.g_old_rec.lei_attribute9, hr_api.g_varchar2) <>

403: nvl(hr_lei_shd.g_old_rec.lei_attribute7, hr_api.g_varchar2) <>
404: nvl(p_rec.lei_attribute7, hr_api.g_varchar2) or
405: nvl(hr_lei_shd.g_old_rec.lei_attribute8, hr_api.g_varchar2) <>
406: nvl(p_rec.lei_attribute8, hr_api.g_varchar2) or
407: nvl(hr_lei_shd.g_old_rec.lei_attribute9, hr_api.g_varchar2) <>
408: nvl(p_rec.lei_attribute9, hr_api.g_varchar2) or
409: nvl(hr_lei_shd.g_old_rec.lei_attribute10, hr_api.g_varchar2) <>
410: nvl(p_rec.lei_attribute10, hr_api.g_varchar2) or
411: nvl(hr_lei_shd.g_old_rec.lei_attribute11, hr_api.g_varchar2) <>

Line 409: nvl(hr_lei_shd.g_old_rec.lei_attribute10, hr_api.g_varchar2) <>

405: nvl(hr_lei_shd.g_old_rec.lei_attribute8, hr_api.g_varchar2) <>
406: nvl(p_rec.lei_attribute8, hr_api.g_varchar2) or
407: nvl(hr_lei_shd.g_old_rec.lei_attribute9, hr_api.g_varchar2) <>
408: nvl(p_rec.lei_attribute9, hr_api.g_varchar2) or
409: nvl(hr_lei_shd.g_old_rec.lei_attribute10, hr_api.g_varchar2) <>
410: nvl(p_rec.lei_attribute10, hr_api.g_varchar2) or
411: nvl(hr_lei_shd.g_old_rec.lei_attribute11, hr_api.g_varchar2) <>
412: nvl(p_rec.lei_attribute11, hr_api.g_varchar2) or
413: nvl(hr_lei_shd.g_old_rec.lei_attribute12, hr_api.g_varchar2) <>

Line 411: nvl(hr_lei_shd.g_old_rec.lei_attribute11, hr_api.g_varchar2) <>

407: nvl(hr_lei_shd.g_old_rec.lei_attribute9, hr_api.g_varchar2) <>
408: nvl(p_rec.lei_attribute9, hr_api.g_varchar2) or
409: nvl(hr_lei_shd.g_old_rec.lei_attribute10, hr_api.g_varchar2) <>
410: nvl(p_rec.lei_attribute10, hr_api.g_varchar2) or
411: nvl(hr_lei_shd.g_old_rec.lei_attribute11, hr_api.g_varchar2) <>
412: nvl(p_rec.lei_attribute11, hr_api.g_varchar2) or
413: nvl(hr_lei_shd.g_old_rec.lei_attribute12, hr_api.g_varchar2) <>
414: nvl(p_rec.lei_attribute12, hr_api.g_varchar2) or
415: nvl(hr_lei_shd.g_old_rec.lei_attribute13, hr_api.g_varchar2) <>

Line 413: nvl(hr_lei_shd.g_old_rec.lei_attribute12, hr_api.g_varchar2) <>

409: nvl(hr_lei_shd.g_old_rec.lei_attribute10, hr_api.g_varchar2) <>
410: nvl(p_rec.lei_attribute10, hr_api.g_varchar2) or
411: nvl(hr_lei_shd.g_old_rec.lei_attribute11, hr_api.g_varchar2) <>
412: nvl(p_rec.lei_attribute11, hr_api.g_varchar2) or
413: nvl(hr_lei_shd.g_old_rec.lei_attribute12, hr_api.g_varchar2) <>
414: nvl(p_rec.lei_attribute12, hr_api.g_varchar2) or
415: nvl(hr_lei_shd.g_old_rec.lei_attribute13, hr_api.g_varchar2) <>
416: nvl(p_rec.lei_attribute13, hr_api.g_varchar2) or
417: nvl(hr_lei_shd.g_old_rec.lei_attribute14, hr_api.g_varchar2) <>

Line 415: nvl(hr_lei_shd.g_old_rec.lei_attribute13, hr_api.g_varchar2) <>

411: nvl(hr_lei_shd.g_old_rec.lei_attribute11, hr_api.g_varchar2) <>
412: nvl(p_rec.lei_attribute11, hr_api.g_varchar2) or
413: nvl(hr_lei_shd.g_old_rec.lei_attribute12, hr_api.g_varchar2) <>
414: nvl(p_rec.lei_attribute12, hr_api.g_varchar2) or
415: nvl(hr_lei_shd.g_old_rec.lei_attribute13, hr_api.g_varchar2) <>
416: nvl(p_rec.lei_attribute13, hr_api.g_varchar2) or
417: nvl(hr_lei_shd.g_old_rec.lei_attribute14, hr_api.g_varchar2) <>
418: nvl(p_rec.lei_attribute14, hr_api.g_varchar2) or
419: nvl(hr_lei_shd.g_old_rec.lei_attribute15, hr_api.g_varchar2) <>

Line 417: nvl(hr_lei_shd.g_old_rec.lei_attribute14, hr_api.g_varchar2) <>

413: nvl(hr_lei_shd.g_old_rec.lei_attribute12, hr_api.g_varchar2) <>
414: nvl(p_rec.lei_attribute12, hr_api.g_varchar2) or
415: nvl(hr_lei_shd.g_old_rec.lei_attribute13, hr_api.g_varchar2) <>
416: nvl(p_rec.lei_attribute13, hr_api.g_varchar2) or
417: nvl(hr_lei_shd.g_old_rec.lei_attribute14, hr_api.g_varchar2) <>
418: nvl(p_rec.lei_attribute14, hr_api.g_varchar2) or
419: nvl(hr_lei_shd.g_old_rec.lei_attribute15, hr_api.g_varchar2) <>
420: nvl(p_rec.lei_attribute15, hr_api.g_varchar2) or
421: nvl(hr_lei_shd.g_old_rec.lei_attribute16, hr_api.g_varchar2) <>

Line 419: nvl(hr_lei_shd.g_old_rec.lei_attribute15, hr_api.g_varchar2) <>

415: nvl(hr_lei_shd.g_old_rec.lei_attribute13, hr_api.g_varchar2) <>
416: nvl(p_rec.lei_attribute13, hr_api.g_varchar2) or
417: nvl(hr_lei_shd.g_old_rec.lei_attribute14, hr_api.g_varchar2) <>
418: nvl(p_rec.lei_attribute14, hr_api.g_varchar2) or
419: nvl(hr_lei_shd.g_old_rec.lei_attribute15, hr_api.g_varchar2) <>
420: nvl(p_rec.lei_attribute15, hr_api.g_varchar2) or
421: nvl(hr_lei_shd.g_old_rec.lei_attribute16, hr_api.g_varchar2) <>
422: nvl(p_rec.lei_attribute16, hr_api.g_varchar2) or
423: nvl(hr_lei_shd.g_old_rec.lei_attribute17, hr_api.g_varchar2) <>

Line 421: nvl(hr_lei_shd.g_old_rec.lei_attribute16, hr_api.g_varchar2) <>

417: nvl(hr_lei_shd.g_old_rec.lei_attribute14, hr_api.g_varchar2) <>
418: nvl(p_rec.lei_attribute14, hr_api.g_varchar2) or
419: nvl(hr_lei_shd.g_old_rec.lei_attribute15, hr_api.g_varchar2) <>
420: nvl(p_rec.lei_attribute15, hr_api.g_varchar2) or
421: nvl(hr_lei_shd.g_old_rec.lei_attribute16, hr_api.g_varchar2) <>
422: nvl(p_rec.lei_attribute16, hr_api.g_varchar2) or
423: nvl(hr_lei_shd.g_old_rec.lei_attribute17, hr_api.g_varchar2) <>
424: nvl(p_rec.lei_attribute17, hr_api.g_varchar2) or
425: nvl(hr_lei_shd.g_old_rec.lei_attribute18, hr_api.g_varchar2) <>

Line 423: nvl(hr_lei_shd.g_old_rec.lei_attribute17, hr_api.g_varchar2) <>

419: nvl(hr_lei_shd.g_old_rec.lei_attribute15, hr_api.g_varchar2) <>
420: nvl(p_rec.lei_attribute15, hr_api.g_varchar2) or
421: nvl(hr_lei_shd.g_old_rec.lei_attribute16, hr_api.g_varchar2) <>
422: nvl(p_rec.lei_attribute16, hr_api.g_varchar2) or
423: nvl(hr_lei_shd.g_old_rec.lei_attribute17, hr_api.g_varchar2) <>
424: nvl(p_rec.lei_attribute17, hr_api.g_varchar2) or
425: nvl(hr_lei_shd.g_old_rec.lei_attribute18, hr_api.g_varchar2) <>
426: nvl(p_rec.lei_attribute18, hr_api.g_varchar2) or
427: nvl(hr_lei_shd.g_old_rec.lei_attribute19, hr_api.g_varchar2) <>

Line 425: nvl(hr_lei_shd.g_old_rec.lei_attribute18, hr_api.g_varchar2) <>

421: nvl(hr_lei_shd.g_old_rec.lei_attribute16, hr_api.g_varchar2) <>
422: nvl(p_rec.lei_attribute16, hr_api.g_varchar2) or
423: nvl(hr_lei_shd.g_old_rec.lei_attribute17, hr_api.g_varchar2) <>
424: nvl(p_rec.lei_attribute17, hr_api.g_varchar2) or
425: nvl(hr_lei_shd.g_old_rec.lei_attribute18, hr_api.g_varchar2) <>
426: nvl(p_rec.lei_attribute18, hr_api.g_varchar2) or
427: nvl(hr_lei_shd.g_old_rec.lei_attribute19, hr_api.g_varchar2) <>
428: nvl(p_rec.lei_attribute19, hr_api.g_varchar2) or
429: nvl(hr_lei_shd.g_old_rec.lei_attribute20, hr_api.g_varchar2) <>

Line 427: nvl(hr_lei_shd.g_old_rec.lei_attribute19, hr_api.g_varchar2) <>

423: nvl(hr_lei_shd.g_old_rec.lei_attribute17, hr_api.g_varchar2) <>
424: nvl(p_rec.lei_attribute17, hr_api.g_varchar2) or
425: nvl(hr_lei_shd.g_old_rec.lei_attribute18, hr_api.g_varchar2) <>
426: nvl(p_rec.lei_attribute18, hr_api.g_varchar2) or
427: nvl(hr_lei_shd.g_old_rec.lei_attribute19, hr_api.g_varchar2) <>
428: nvl(p_rec.lei_attribute19, hr_api.g_varchar2) or
429: nvl(hr_lei_shd.g_old_rec.lei_attribute20, hr_api.g_varchar2) <>
430: nvl(p_rec.lei_attribute20, hr_api.g_varchar2)))
431: or

Line 429: nvl(hr_lei_shd.g_old_rec.lei_attribute20, hr_api.g_varchar2) <>

425: nvl(hr_lei_shd.g_old_rec.lei_attribute18, hr_api.g_varchar2) <>
426: nvl(p_rec.lei_attribute18, hr_api.g_varchar2) or
427: nvl(hr_lei_shd.g_old_rec.lei_attribute19, hr_api.g_varchar2) <>
428: nvl(p_rec.lei_attribute19, hr_api.g_varchar2) or
429: nvl(hr_lei_shd.g_old_rec.lei_attribute20, hr_api.g_varchar2) <>
430: nvl(p_rec.lei_attribute20, hr_api.g_varchar2)))
431: or
432: (p_rec.location_extra_info_id is null) then
433: --

Line 522: (p_rec in hr_lei_shd.g_rec_type) is

518: -- {End Of Comments}
519: --
520: -- ----------------------------------------------------------------------------
521: procedure chk_ddf
522: (p_rec in hr_lei_shd.g_rec_type) is
523: --
524: l_proc varchar2(72) := g_package||'chk_ddf';
525: l_error exception;
526: --

Line 536: nvl(hr_lei_shd.g_old_rec.lei_attribute_category, hr_api.g_varchar2) <>

532: --
533: if (p_rec.location_extra_info_id is null)
534: or ((p_rec.location_extra_info_id is not null)
535: and
536: nvl(hr_lei_shd.g_old_rec.lei_attribute_category, hr_api.g_varchar2) <>
537: nvl(p_rec.lei_information_category, hr_api.g_varchar2) or
538: nvl(hr_lei_shd.g_old_rec.lei_information1, hr_api.g_varchar2) <>
539: nvl(p_rec.lei_information1, hr_api.g_varchar2) or
540: nvl(hr_lei_shd.g_old_rec.lei_information2, hr_api.g_varchar2) <>

Line 538: nvl(hr_lei_shd.g_old_rec.lei_information1, hr_api.g_varchar2) <>

534: or ((p_rec.location_extra_info_id is not null)
535: and
536: nvl(hr_lei_shd.g_old_rec.lei_attribute_category, hr_api.g_varchar2) <>
537: nvl(p_rec.lei_information_category, hr_api.g_varchar2) or
538: nvl(hr_lei_shd.g_old_rec.lei_information1, hr_api.g_varchar2) <>
539: nvl(p_rec.lei_information1, hr_api.g_varchar2) or
540: nvl(hr_lei_shd.g_old_rec.lei_information2, hr_api.g_varchar2) <>
541: nvl(p_rec.lei_information2, hr_api.g_varchar2) or
542: nvl(hr_lei_shd.g_old_rec.lei_information3, hr_api.g_varchar2) <>

Line 540: nvl(hr_lei_shd.g_old_rec.lei_information2, hr_api.g_varchar2) <>

536: nvl(hr_lei_shd.g_old_rec.lei_attribute_category, hr_api.g_varchar2) <>
537: nvl(p_rec.lei_information_category, hr_api.g_varchar2) or
538: nvl(hr_lei_shd.g_old_rec.lei_information1, hr_api.g_varchar2) <>
539: nvl(p_rec.lei_information1, hr_api.g_varchar2) or
540: nvl(hr_lei_shd.g_old_rec.lei_information2, hr_api.g_varchar2) <>
541: nvl(p_rec.lei_information2, hr_api.g_varchar2) or
542: nvl(hr_lei_shd.g_old_rec.lei_information3, hr_api.g_varchar2) <>
543: nvl(p_rec.lei_information3, hr_api.g_varchar2) or
544: nvl(hr_lei_shd.g_old_rec.lei_information4, hr_api.g_varchar2) <>

Line 542: nvl(hr_lei_shd.g_old_rec.lei_information3, hr_api.g_varchar2) <>

538: nvl(hr_lei_shd.g_old_rec.lei_information1, hr_api.g_varchar2) <>
539: nvl(p_rec.lei_information1, hr_api.g_varchar2) or
540: nvl(hr_lei_shd.g_old_rec.lei_information2, hr_api.g_varchar2) <>
541: nvl(p_rec.lei_information2, hr_api.g_varchar2) or
542: nvl(hr_lei_shd.g_old_rec.lei_information3, hr_api.g_varchar2) <>
543: nvl(p_rec.lei_information3, hr_api.g_varchar2) or
544: nvl(hr_lei_shd.g_old_rec.lei_information4, hr_api.g_varchar2) <>
545: nvl(p_rec.lei_information4, hr_api.g_varchar2) or
546: nvl(hr_lei_shd.g_old_rec.lei_information5, hr_api.g_varchar2) <>

Line 544: nvl(hr_lei_shd.g_old_rec.lei_information4, hr_api.g_varchar2) <>

540: nvl(hr_lei_shd.g_old_rec.lei_information2, hr_api.g_varchar2) <>
541: nvl(p_rec.lei_information2, hr_api.g_varchar2) or
542: nvl(hr_lei_shd.g_old_rec.lei_information3, hr_api.g_varchar2) <>
543: nvl(p_rec.lei_information3, hr_api.g_varchar2) or
544: nvl(hr_lei_shd.g_old_rec.lei_information4, hr_api.g_varchar2) <>
545: nvl(p_rec.lei_information4, hr_api.g_varchar2) or
546: nvl(hr_lei_shd.g_old_rec.lei_information5, hr_api.g_varchar2) <>
547: nvl(p_rec.lei_information5, hr_api.g_varchar2) or
548: nvl(hr_lei_shd.g_old_rec.lei_information6, hr_api.g_varchar2) <>

Line 546: nvl(hr_lei_shd.g_old_rec.lei_information5, hr_api.g_varchar2) <>

542: nvl(hr_lei_shd.g_old_rec.lei_information3, hr_api.g_varchar2) <>
543: nvl(p_rec.lei_information3, hr_api.g_varchar2) or
544: nvl(hr_lei_shd.g_old_rec.lei_information4, hr_api.g_varchar2) <>
545: nvl(p_rec.lei_information4, hr_api.g_varchar2) or
546: nvl(hr_lei_shd.g_old_rec.lei_information5, hr_api.g_varchar2) <>
547: nvl(p_rec.lei_information5, hr_api.g_varchar2) or
548: nvl(hr_lei_shd.g_old_rec.lei_information6, hr_api.g_varchar2) <>
549: nvl(p_rec.lei_information6, hr_api.g_varchar2) or
550: nvl(hr_lei_shd.g_old_rec.lei_information7, hr_api.g_varchar2) <>

Line 548: nvl(hr_lei_shd.g_old_rec.lei_information6, hr_api.g_varchar2) <>

544: nvl(hr_lei_shd.g_old_rec.lei_information4, hr_api.g_varchar2) <>
545: nvl(p_rec.lei_information4, hr_api.g_varchar2) or
546: nvl(hr_lei_shd.g_old_rec.lei_information5, hr_api.g_varchar2) <>
547: nvl(p_rec.lei_information5, hr_api.g_varchar2) or
548: nvl(hr_lei_shd.g_old_rec.lei_information6, hr_api.g_varchar2) <>
549: nvl(p_rec.lei_information6, hr_api.g_varchar2) or
550: nvl(hr_lei_shd.g_old_rec.lei_information7, hr_api.g_varchar2) <>
551: nvl(p_rec.lei_information7, hr_api.g_varchar2) or
552: nvl(hr_lei_shd.g_old_rec.lei_information8, hr_api.g_varchar2) <>

Line 550: nvl(hr_lei_shd.g_old_rec.lei_information7, hr_api.g_varchar2) <>

546: nvl(hr_lei_shd.g_old_rec.lei_information5, hr_api.g_varchar2) <>
547: nvl(p_rec.lei_information5, hr_api.g_varchar2) or
548: nvl(hr_lei_shd.g_old_rec.lei_information6, hr_api.g_varchar2) <>
549: nvl(p_rec.lei_information6, hr_api.g_varchar2) or
550: nvl(hr_lei_shd.g_old_rec.lei_information7, hr_api.g_varchar2) <>
551: nvl(p_rec.lei_information7, hr_api.g_varchar2) or
552: nvl(hr_lei_shd.g_old_rec.lei_information8, hr_api.g_varchar2) <>
553: nvl(p_rec.lei_information8, hr_api.g_varchar2) or
554: nvl(hr_lei_shd.g_old_rec.lei_information9, hr_api.g_varchar2) <>

Line 552: nvl(hr_lei_shd.g_old_rec.lei_information8, hr_api.g_varchar2) <>

548: nvl(hr_lei_shd.g_old_rec.lei_information6, hr_api.g_varchar2) <>
549: nvl(p_rec.lei_information6, hr_api.g_varchar2) or
550: nvl(hr_lei_shd.g_old_rec.lei_information7, hr_api.g_varchar2) <>
551: nvl(p_rec.lei_information7, hr_api.g_varchar2) or
552: nvl(hr_lei_shd.g_old_rec.lei_information8, hr_api.g_varchar2) <>
553: nvl(p_rec.lei_information8, hr_api.g_varchar2) or
554: nvl(hr_lei_shd.g_old_rec.lei_information9, hr_api.g_varchar2) <>
555: nvl(p_rec.lei_information9, hr_api.g_varchar2) or
556: nvl(hr_lei_shd.g_old_rec.lei_information10, hr_api.g_varchar2) <>

Line 554: nvl(hr_lei_shd.g_old_rec.lei_information9, hr_api.g_varchar2) <>

550: nvl(hr_lei_shd.g_old_rec.lei_information7, hr_api.g_varchar2) <>
551: nvl(p_rec.lei_information7, hr_api.g_varchar2) or
552: nvl(hr_lei_shd.g_old_rec.lei_information8, hr_api.g_varchar2) <>
553: nvl(p_rec.lei_information8, hr_api.g_varchar2) or
554: nvl(hr_lei_shd.g_old_rec.lei_information9, hr_api.g_varchar2) <>
555: nvl(p_rec.lei_information9, hr_api.g_varchar2) or
556: nvl(hr_lei_shd.g_old_rec.lei_information10, hr_api.g_varchar2) <>
557: nvl(p_rec.lei_information10, hr_api.g_varchar2) or
558: nvl(hr_lei_shd.g_old_rec.lei_information11, hr_api.g_varchar2) <>

Line 556: nvl(hr_lei_shd.g_old_rec.lei_information10, hr_api.g_varchar2) <>

552: nvl(hr_lei_shd.g_old_rec.lei_information8, hr_api.g_varchar2) <>
553: nvl(p_rec.lei_information8, hr_api.g_varchar2) or
554: nvl(hr_lei_shd.g_old_rec.lei_information9, hr_api.g_varchar2) <>
555: nvl(p_rec.lei_information9, hr_api.g_varchar2) or
556: nvl(hr_lei_shd.g_old_rec.lei_information10, hr_api.g_varchar2) <>
557: nvl(p_rec.lei_information10, hr_api.g_varchar2) or
558: nvl(hr_lei_shd.g_old_rec.lei_information11, hr_api.g_varchar2) <>
559: nvl(p_rec.lei_information11, hr_api.g_varchar2) or
560: nvl(hr_lei_shd.g_old_rec.lei_information12, hr_api.g_varchar2) <>

Line 558: nvl(hr_lei_shd.g_old_rec.lei_information11, hr_api.g_varchar2) <>

554: nvl(hr_lei_shd.g_old_rec.lei_information9, hr_api.g_varchar2) <>
555: nvl(p_rec.lei_information9, hr_api.g_varchar2) or
556: nvl(hr_lei_shd.g_old_rec.lei_information10, hr_api.g_varchar2) <>
557: nvl(p_rec.lei_information10, hr_api.g_varchar2) or
558: nvl(hr_lei_shd.g_old_rec.lei_information11, hr_api.g_varchar2) <>
559: nvl(p_rec.lei_information11, hr_api.g_varchar2) or
560: nvl(hr_lei_shd.g_old_rec.lei_information12, hr_api.g_varchar2) <>
561: nvl(p_rec.lei_information12, hr_api.g_varchar2) or
562: nvl(hr_lei_shd.g_old_rec.lei_information13, hr_api.g_varchar2) <>

Line 560: nvl(hr_lei_shd.g_old_rec.lei_information12, hr_api.g_varchar2) <>

556: nvl(hr_lei_shd.g_old_rec.lei_information10, hr_api.g_varchar2) <>
557: nvl(p_rec.lei_information10, hr_api.g_varchar2) or
558: nvl(hr_lei_shd.g_old_rec.lei_information11, hr_api.g_varchar2) <>
559: nvl(p_rec.lei_information11, hr_api.g_varchar2) or
560: nvl(hr_lei_shd.g_old_rec.lei_information12, hr_api.g_varchar2) <>
561: nvl(p_rec.lei_information12, hr_api.g_varchar2) or
562: nvl(hr_lei_shd.g_old_rec.lei_information13, hr_api.g_varchar2) <>
563: nvl(p_rec.lei_information13, hr_api.g_varchar2) or
564: nvl(hr_lei_shd.g_old_rec.lei_information14, hr_api.g_varchar2) <>

Line 562: nvl(hr_lei_shd.g_old_rec.lei_information13, hr_api.g_varchar2) <>

558: nvl(hr_lei_shd.g_old_rec.lei_information11, hr_api.g_varchar2) <>
559: nvl(p_rec.lei_information11, hr_api.g_varchar2) or
560: nvl(hr_lei_shd.g_old_rec.lei_information12, hr_api.g_varchar2) <>
561: nvl(p_rec.lei_information12, hr_api.g_varchar2) or
562: nvl(hr_lei_shd.g_old_rec.lei_information13, hr_api.g_varchar2) <>
563: nvl(p_rec.lei_information13, hr_api.g_varchar2) or
564: nvl(hr_lei_shd.g_old_rec.lei_information14, hr_api.g_varchar2) <>
565: nvl(p_rec.lei_information14, hr_api.g_varchar2) or
566: nvl(hr_lei_shd.g_old_rec.lei_information15, hr_api.g_varchar2) <>

Line 564: nvl(hr_lei_shd.g_old_rec.lei_information14, hr_api.g_varchar2) <>

560: nvl(hr_lei_shd.g_old_rec.lei_information12, hr_api.g_varchar2) <>
561: nvl(p_rec.lei_information12, hr_api.g_varchar2) or
562: nvl(hr_lei_shd.g_old_rec.lei_information13, hr_api.g_varchar2) <>
563: nvl(p_rec.lei_information13, hr_api.g_varchar2) or
564: nvl(hr_lei_shd.g_old_rec.lei_information14, hr_api.g_varchar2) <>
565: nvl(p_rec.lei_information14, hr_api.g_varchar2) or
566: nvl(hr_lei_shd.g_old_rec.lei_information15, hr_api.g_varchar2) <>
567: nvl(p_rec.lei_information15, hr_api.g_varchar2) or
568: nvl(hr_lei_shd.g_old_rec.lei_information16, hr_api.g_varchar2) <>

Line 566: nvl(hr_lei_shd.g_old_rec.lei_information15, hr_api.g_varchar2) <>

562: nvl(hr_lei_shd.g_old_rec.lei_information13, hr_api.g_varchar2) <>
563: nvl(p_rec.lei_information13, hr_api.g_varchar2) or
564: nvl(hr_lei_shd.g_old_rec.lei_information14, hr_api.g_varchar2) <>
565: nvl(p_rec.lei_information14, hr_api.g_varchar2) or
566: nvl(hr_lei_shd.g_old_rec.lei_information15, hr_api.g_varchar2) <>
567: nvl(p_rec.lei_information15, hr_api.g_varchar2) or
568: nvl(hr_lei_shd.g_old_rec.lei_information16, hr_api.g_varchar2) <>
569: nvl(p_rec.lei_information16, hr_api.g_varchar2) or
570: nvl(hr_lei_shd.g_old_rec.lei_information17, hr_api.g_varchar2) <>

Line 568: nvl(hr_lei_shd.g_old_rec.lei_information16, hr_api.g_varchar2) <>

564: nvl(hr_lei_shd.g_old_rec.lei_information14, hr_api.g_varchar2) <>
565: nvl(p_rec.lei_information14, hr_api.g_varchar2) or
566: nvl(hr_lei_shd.g_old_rec.lei_information15, hr_api.g_varchar2) <>
567: nvl(p_rec.lei_information15, hr_api.g_varchar2) or
568: nvl(hr_lei_shd.g_old_rec.lei_information16, hr_api.g_varchar2) <>
569: nvl(p_rec.lei_information16, hr_api.g_varchar2) or
570: nvl(hr_lei_shd.g_old_rec.lei_information17, hr_api.g_varchar2) <>
571: nvl(p_rec.lei_information17, hr_api.g_varchar2) or
572: nvl(hr_lei_shd.g_old_rec.lei_information18, hr_api.g_varchar2) <>

Line 570: nvl(hr_lei_shd.g_old_rec.lei_information17, hr_api.g_varchar2) <>

566: nvl(hr_lei_shd.g_old_rec.lei_information15, hr_api.g_varchar2) <>
567: nvl(p_rec.lei_information15, hr_api.g_varchar2) or
568: nvl(hr_lei_shd.g_old_rec.lei_information16, hr_api.g_varchar2) <>
569: nvl(p_rec.lei_information16, hr_api.g_varchar2) or
570: nvl(hr_lei_shd.g_old_rec.lei_information17, hr_api.g_varchar2) <>
571: nvl(p_rec.lei_information17, hr_api.g_varchar2) or
572: nvl(hr_lei_shd.g_old_rec.lei_information18, hr_api.g_varchar2) <>
573: nvl(p_rec.lei_information18, hr_api.g_varchar2) or
574: nvl(hr_lei_shd.g_old_rec.lei_information19, hr_api.g_varchar2) <>

Line 572: nvl(hr_lei_shd.g_old_rec.lei_information18, hr_api.g_varchar2) <>

568: nvl(hr_lei_shd.g_old_rec.lei_information16, hr_api.g_varchar2) <>
569: nvl(p_rec.lei_information16, hr_api.g_varchar2) or
570: nvl(hr_lei_shd.g_old_rec.lei_information17, hr_api.g_varchar2) <>
571: nvl(p_rec.lei_information17, hr_api.g_varchar2) or
572: nvl(hr_lei_shd.g_old_rec.lei_information18, hr_api.g_varchar2) <>
573: nvl(p_rec.lei_information18, hr_api.g_varchar2) or
574: nvl(hr_lei_shd.g_old_rec.lei_information19, hr_api.g_varchar2) <>
575: nvl(p_rec.lei_information19, hr_api.g_varchar2) or
576: nvl(hr_lei_shd.g_old_rec.lei_information20, hr_api.g_varchar2) <>

Line 574: nvl(hr_lei_shd.g_old_rec.lei_information19, hr_api.g_varchar2) <>

570: nvl(hr_lei_shd.g_old_rec.lei_information17, hr_api.g_varchar2) <>
571: nvl(p_rec.lei_information17, hr_api.g_varchar2) or
572: nvl(hr_lei_shd.g_old_rec.lei_information18, hr_api.g_varchar2) <>
573: nvl(p_rec.lei_information18, hr_api.g_varchar2) or
574: nvl(hr_lei_shd.g_old_rec.lei_information19, hr_api.g_varchar2) <>
575: nvl(p_rec.lei_information19, hr_api.g_varchar2) or
576: nvl(hr_lei_shd.g_old_rec.lei_information20, hr_api.g_varchar2) <>
577: nvl(p_rec.lei_information20, hr_api.g_varchar2) or
578: nvl(hr_lei_shd.g_old_rec.lei_information21, hr_api.g_varchar2) <>

Line 576: nvl(hr_lei_shd.g_old_rec.lei_information20, hr_api.g_varchar2) <>

572: nvl(hr_lei_shd.g_old_rec.lei_information18, hr_api.g_varchar2) <>
573: nvl(p_rec.lei_information18, hr_api.g_varchar2) or
574: nvl(hr_lei_shd.g_old_rec.lei_information19, hr_api.g_varchar2) <>
575: nvl(p_rec.lei_information19, hr_api.g_varchar2) or
576: nvl(hr_lei_shd.g_old_rec.lei_information20, hr_api.g_varchar2) <>
577: nvl(p_rec.lei_information20, hr_api.g_varchar2) or
578: nvl(hr_lei_shd.g_old_rec.lei_information21, hr_api.g_varchar2) <>
579: nvl(p_rec.lei_information21, hr_api.g_varchar2) or
580: nvl(hr_lei_shd.g_old_rec.lei_information22, hr_api.g_varchar2) <>

Line 578: nvl(hr_lei_shd.g_old_rec.lei_information21, hr_api.g_varchar2) <>

574: nvl(hr_lei_shd.g_old_rec.lei_information19, hr_api.g_varchar2) <>
575: nvl(p_rec.lei_information19, hr_api.g_varchar2) or
576: nvl(hr_lei_shd.g_old_rec.lei_information20, hr_api.g_varchar2) <>
577: nvl(p_rec.lei_information20, hr_api.g_varchar2) or
578: nvl(hr_lei_shd.g_old_rec.lei_information21, hr_api.g_varchar2) <>
579: nvl(p_rec.lei_information21, hr_api.g_varchar2) or
580: nvl(hr_lei_shd.g_old_rec.lei_information22, hr_api.g_varchar2) <>
581: nvl(p_rec.lei_information22, hr_api.g_varchar2) or
582: nvl(hr_lei_shd.g_old_rec.lei_information23, hr_api.g_varchar2) <>

Line 580: nvl(hr_lei_shd.g_old_rec.lei_information22, hr_api.g_varchar2) <>

576: nvl(hr_lei_shd.g_old_rec.lei_information20, hr_api.g_varchar2) <>
577: nvl(p_rec.lei_information20, hr_api.g_varchar2) or
578: nvl(hr_lei_shd.g_old_rec.lei_information21, hr_api.g_varchar2) <>
579: nvl(p_rec.lei_information21, hr_api.g_varchar2) or
580: nvl(hr_lei_shd.g_old_rec.lei_information22, hr_api.g_varchar2) <>
581: nvl(p_rec.lei_information22, hr_api.g_varchar2) or
582: nvl(hr_lei_shd.g_old_rec.lei_information23, hr_api.g_varchar2) <>
583: nvl(p_rec.lei_information23, hr_api.g_varchar2) or
584: nvl(hr_lei_shd.g_old_rec.lei_information24, hr_api.g_varchar2) <>

Line 582: nvl(hr_lei_shd.g_old_rec.lei_information23, hr_api.g_varchar2) <>

578: nvl(hr_lei_shd.g_old_rec.lei_information21, hr_api.g_varchar2) <>
579: nvl(p_rec.lei_information21, hr_api.g_varchar2) or
580: nvl(hr_lei_shd.g_old_rec.lei_information22, hr_api.g_varchar2) <>
581: nvl(p_rec.lei_information22, hr_api.g_varchar2) or
582: nvl(hr_lei_shd.g_old_rec.lei_information23, hr_api.g_varchar2) <>
583: nvl(p_rec.lei_information23, hr_api.g_varchar2) or
584: nvl(hr_lei_shd.g_old_rec.lei_information24, hr_api.g_varchar2) <>
585: nvl(p_rec.lei_information24, hr_api.g_varchar2) or
586: nvl(hr_lei_shd.g_old_rec.lei_information25, hr_api.g_varchar2) <>

Line 584: nvl(hr_lei_shd.g_old_rec.lei_information24, hr_api.g_varchar2) <>

580: nvl(hr_lei_shd.g_old_rec.lei_information22, hr_api.g_varchar2) <>
581: nvl(p_rec.lei_information22, hr_api.g_varchar2) or
582: nvl(hr_lei_shd.g_old_rec.lei_information23, hr_api.g_varchar2) <>
583: nvl(p_rec.lei_information23, hr_api.g_varchar2) or
584: nvl(hr_lei_shd.g_old_rec.lei_information24, hr_api.g_varchar2) <>
585: nvl(p_rec.lei_information24, hr_api.g_varchar2) or
586: nvl(hr_lei_shd.g_old_rec.lei_information25, hr_api.g_varchar2) <>
587: nvl(p_rec.lei_information25, hr_api.g_varchar2) or
588: nvl(hr_lei_shd.g_old_rec.lei_information26, hr_api.g_varchar2) <>

Line 586: nvl(hr_lei_shd.g_old_rec.lei_information25, hr_api.g_varchar2) <>

582: nvl(hr_lei_shd.g_old_rec.lei_information23, hr_api.g_varchar2) <>
583: nvl(p_rec.lei_information23, hr_api.g_varchar2) or
584: nvl(hr_lei_shd.g_old_rec.lei_information24, hr_api.g_varchar2) <>
585: nvl(p_rec.lei_information24, hr_api.g_varchar2) or
586: nvl(hr_lei_shd.g_old_rec.lei_information25, hr_api.g_varchar2) <>
587: nvl(p_rec.lei_information25, hr_api.g_varchar2) or
588: nvl(hr_lei_shd.g_old_rec.lei_information26, hr_api.g_varchar2) <>
589: nvl(p_rec.lei_information26, hr_api.g_varchar2) or
590: nvl(hr_lei_shd.g_old_rec.lei_information27, hr_api.g_varchar2) <>

Line 588: nvl(hr_lei_shd.g_old_rec.lei_information26, hr_api.g_varchar2) <>

584: nvl(hr_lei_shd.g_old_rec.lei_information24, hr_api.g_varchar2) <>
585: nvl(p_rec.lei_information24, hr_api.g_varchar2) or
586: nvl(hr_lei_shd.g_old_rec.lei_information25, hr_api.g_varchar2) <>
587: nvl(p_rec.lei_information25, hr_api.g_varchar2) or
588: nvl(hr_lei_shd.g_old_rec.lei_information26, hr_api.g_varchar2) <>
589: nvl(p_rec.lei_information26, hr_api.g_varchar2) or
590: nvl(hr_lei_shd.g_old_rec.lei_information27, hr_api.g_varchar2) <>
591: nvl(p_rec.lei_information27, hr_api.g_varchar2) or
592: nvl(hr_lei_shd.g_old_rec.lei_information28, hr_api.g_varchar2) <>

Line 590: nvl(hr_lei_shd.g_old_rec.lei_information27, hr_api.g_varchar2) <>

586: nvl(hr_lei_shd.g_old_rec.lei_information25, hr_api.g_varchar2) <>
587: nvl(p_rec.lei_information25, hr_api.g_varchar2) or
588: nvl(hr_lei_shd.g_old_rec.lei_information26, hr_api.g_varchar2) <>
589: nvl(p_rec.lei_information26, hr_api.g_varchar2) or
590: nvl(hr_lei_shd.g_old_rec.lei_information27, hr_api.g_varchar2) <>
591: nvl(p_rec.lei_information27, hr_api.g_varchar2) or
592: nvl(hr_lei_shd.g_old_rec.lei_information28, hr_api.g_varchar2) <>
593: nvl(p_rec.lei_information28, hr_api.g_varchar2) or
594: nvl(hr_lei_shd.g_old_rec.lei_information29, hr_api.g_varchar2) <>

Line 592: nvl(hr_lei_shd.g_old_rec.lei_information28, hr_api.g_varchar2) <>

588: nvl(hr_lei_shd.g_old_rec.lei_information26, hr_api.g_varchar2) <>
589: nvl(p_rec.lei_information26, hr_api.g_varchar2) or
590: nvl(hr_lei_shd.g_old_rec.lei_information27, hr_api.g_varchar2) <>
591: nvl(p_rec.lei_information27, hr_api.g_varchar2) or
592: nvl(hr_lei_shd.g_old_rec.lei_information28, hr_api.g_varchar2) <>
593: nvl(p_rec.lei_information28, hr_api.g_varchar2) or
594: nvl(hr_lei_shd.g_old_rec.lei_information29, hr_api.g_varchar2) <>
595: nvl(p_rec.lei_information29, hr_api.g_varchar2) or
596: nvl(hr_lei_shd.g_old_rec.lei_information30, hr_api.g_varchar2) <>

Line 594: nvl(hr_lei_shd.g_old_rec.lei_information29, hr_api.g_varchar2) <>

590: nvl(hr_lei_shd.g_old_rec.lei_information27, hr_api.g_varchar2) <>
591: nvl(p_rec.lei_information27, hr_api.g_varchar2) or
592: nvl(hr_lei_shd.g_old_rec.lei_information28, hr_api.g_varchar2) <>
593: nvl(p_rec.lei_information28, hr_api.g_varchar2) or
594: nvl(hr_lei_shd.g_old_rec.lei_information29, hr_api.g_varchar2) <>
595: nvl(p_rec.lei_information29, hr_api.g_varchar2) or
596: nvl(hr_lei_shd.g_old_rec.lei_information30, hr_api.g_varchar2) <>
597: nvl(p_rec.lei_information30, hr_api.g_varchar2))
598: then

Line 596: nvl(hr_lei_shd.g_old_rec.lei_information30, hr_api.g_varchar2) <>

592: nvl(hr_lei_shd.g_old_rec.lei_information28, hr_api.g_varchar2) <>
593: nvl(p_rec.lei_information28, hr_api.g_varchar2) or
594: nvl(hr_lei_shd.g_old_rec.lei_information29, hr_api.g_varchar2) <>
595: nvl(p_rec.lei_information29, hr_api.g_varchar2) or
596: nvl(hr_lei_shd.g_old_rec.lei_information30, hr_api.g_varchar2) <>
597: nvl(p_rec.lei_information30, hr_api.g_varchar2))
598: then
599: --
600: hr_dflex_utility.ins_or_upd_descflex_attribs

Line 674: Procedure insert_validate(p_rec in hr_lei_shd.g_rec_type) is

670: --
671: -- ----------------------------------------------------------------------------
672: -- |---------------------------< insert_validate >----------------------------|
673: -- ----------------------------------------------------------------------------
674: Procedure insert_validate(p_rec in hr_lei_shd.g_rec_type) is
675: --
676: l_proc varchar2(72) := g_package||'insert_validate';
677: l_multiple_occurences_flag hr_location_info_types.multiple_occurences_flag%type;
678: --

Line 758: Procedure update_validate(p_rec in hr_lei_shd.g_rec_type) is

754: --
755: -- ----------------------------------------------------------------------------
756: -- |---------------------------< update_validate >----------------------------|
757: -- ----------------------------------------------------------------------------
758: Procedure update_validate(p_rec in hr_lei_shd.g_rec_type) is
759: --
760: l_proc varchar2(72) := g_package||'update_validate';
761: --
762: -- bug 6329528

Line 831: Procedure delete_validate(p_rec in hr_lei_shd.g_rec_type) is

827: --
828: -- ----------------------------------------------------------------------------
829: -- |---------------------------< delete_validate >----------------------------|
830: -- ----------------------------------------------------------------------------
831: Procedure delete_validate(p_rec in hr_lei_shd.g_rec_type) is
832: --
833: l_proc varchar2(72) := g_package||'delete_validate';
834: --
835: Begin