54: hr_utility.set_location('Entering:'||l_proc, 1);
55: --
56: -- Check mandatory parameters have been set
57: --
58: hr_api.mandatory_arg_error
59: (
60: p_api_name => l_proc,
61: p_argument => 'location_id',
62: p_argument_value => p_location_id
132: end if;
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;
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: --
138: l_argument := 'location_id';
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;
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: --
148: hr_utility.set_location(' Leaving : '|| l_proc, 40);
149: --
150: exception
151: when l_error then
152: hr_api.argument_changed_error
153: (p_api_name => l_proc
154: ,p_argument => l_argument);
155: when others then
156: raise;
211: --
212: --
213: -- Check mandatory parameters have been set
214: --
215: hr_api.mandatory_arg_error
216: (
217: p_api_name => l_proc,
218: p_argument => 'information_type',
219: p_argument_value => p_information_type
310: if p_multiple_occurences_flag = 'N' then
311: --
312: -- Check mandatory parameters have been set
313: --
314: hr_api.mandatory_arg_error
315: (
316: p_api_name => l_proc,
317: p_argument => 'information_type',
318: p_argument_value => p_information_type
318: p_argument_value => p_information_type
319: );
320: --
321: --
322: hr_api.mandatory_arg_error
323: (
324: p_api_name => l_proc,
325: p_argument => 'location_id',
326: p_argument_value => p_location_id
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) <>
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) <>
394: nvl(p_rec.lei_attribute2, hr_api.g_varchar2) or
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) <>
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) <>
396: nvl(p_rec.lei_attribute3, hr_api.g_varchar2) or
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) <>
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) <>
398: nvl(p_rec.lei_attribute4, 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) <>
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) <>
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) <>
400: nvl(p_rec.lei_attribute5, 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) <>
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) <>
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) <>
402: nvl(p_rec.lei_attribute6, 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) <>
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) <>
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) <>
404: nvl(p_rec.lei_attribute7, 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) <>
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) <>
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) <>
406: nvl(p_rec.lei_attribute8, 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) <>
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) <>
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) <>
408: nvl(p_rec.lei_attribute9, 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) <>
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) <>
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) <>
410: nvl(p_rec.lei_attribute10, 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) <>
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) <>
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) <>
412: nvl(p_rec.lei_attribute11, 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) <>
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) <>
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) <>
414: nvl(p_rec.lei_attribute12, 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) <>
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) <>
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) <>
416: nvl(p_rec.lei_attribute13, 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) <>
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) <>
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) <>
418: nvl(p_rec.lei_attribute14, 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) <>
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) <>
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) <>
420: nvl(p_rec.lei_attribute15, 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) <>
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) <>
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) <>
422: nvl(p_rec.lei_attribute16, 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) <>
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) <>
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) <>
424: nvl(p_rec.lei_attribute17, 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) <>
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) <>
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) <>
426: nvl(p_rec.lei_attribute18, 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) <>
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) <>
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) <>
428: nvl(p_rec.lei_attribute19, 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) <>
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) <>
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) <>
430: nvl(p_rec.lei_attribute20, 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
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
432: (p_rec.location_extra_info_id is null) then
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: --
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: --
434: -- Only execute the validation if absolutely necessary:
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) <>
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) <>
541: nvl(p_rec.lei_information2, hr_api.g_varchar2) or
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) <>
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) <>
543: nvl(p_rec.lei_information3, hr_api.g_varchar2) or
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) <>
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) <>
545: nvl(p_rec.lei_information4, 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) <>
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) <>
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) <>
547: nvl(p_rec.lei_information5, 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) <>
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) <>
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) <>
549: nvl(p_rec.lei_information6, 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) <>
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) <>
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) <>
551: nvl(p_rec.lei_information7, 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) <>
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) <>
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) <>
553: nvl(p_rec.lei_information8, 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) <>
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) <>
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) <>
555: nvl(p_rec.lei_information9, 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) <>
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) <>
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) <>
557: nvl(p_rec.lei_information10, 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) <>
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) <>
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) <>
559: nvl(p_rec.lei_information11, 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) <>
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) <>
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) <>
561: nvl(p_rec.lei_information12, 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) <>
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) <>
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) <>
563: nvl(p_rec.lei_information13, 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) <>
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) <>
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) <>
565: nvl(p_rec.lei_information14, 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) <>
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) <>
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) <>
567: nvl(p_rec.lei_information15, 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) <>
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) <>
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) <>
569: nvl(p_rec.lei_information16, 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) <>
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) <>
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) <>
571: nvl(p_rec.lei_information17, 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) <>
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) <>
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) <>
573: nvl(p_rec.lei_information18, 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) <>
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) <>
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) <>
575: nvl(p_rec.lei_information19, 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) <>
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) <>
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) <>
577: nvl(p_rec.lei_information20, 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) <>
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) <>
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) <>
579: nvl(p_rec.lei_information21, 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) <>
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) <>
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) <>
581: nvl(p_rec.lei_information22, 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) <>
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) <>
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) <>
583: nvl(p_rec.lei_information23, 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) <>
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) <>
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) <>
585: nvl(p_rec.lei_information24, 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) <>
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) <>
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) <>
587: nvl(p_rec.lei_information25, 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) <>
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) <>
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) <>
589: nvl(p_rec.lei_information26, 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) <>
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) <>
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) <>
591: nvl(p_rec.lei_information27, 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) <>
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) <>
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) <>
593: nvl(p_rec.lei_information28, 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) <>
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) <>
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) <>
595: nvl(p_rec.lei_information29, 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) <>
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) <>
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) <>
597: nvl(p_rec.lei_information30, 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
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
599: --
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
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
601: (p_appl_short_name => 'PER'
695: -- As this data is not within the context of a business group
696: -- the set_security_group_id procedure has zero passed
697: -- to it as the default security_group_id.
698: --
699: -- hr_api.set_security_group_id(p_security_group_id => 0); commented bug 6329528
700: -- bug 6329528
701:
702: open csr_sec_grp;
703: fetch csr_sec_grp into l_security_group_id, l_legislation_code;
701:
702: open csr_sec_grp;
703: fetch csr_sec_grp into l_security_group_id, l_legislation_code;
704: close csr_sec_grp;
705: hr_api.set_security_group_id(p_security_group_id => l_security_group_id);
706: --
707: --
708: hr_utility.set_location('Entering:'||l_proc, 6);
709: --
764: -- the set_security_group_id procedure has zero passed
765: -- to it as the default security_group_id.
766: --
767: -- bug 6329528
768: -- hr_api.set_security_group_id(p_security_group_id => 0); commented -- bug 6329528
769: --
770:
771: open csr_sec_grp;
772: fetch csr_sec_grp into l_security_group_id, l_legislation_code;
770:
771: open csr_sec_grp;
772: fetch csr_sec_grp into l_security_group_id, l_legislation_code;
773: close csr_sec_grp;
774: hr_api.set_security_group_id(p_security_group_id => l_security_group_id);
775: --
776:
777: --
778: hr_utility.set_location('Entering:'||l_proc, 6);