APPS.HR_LEI_BUS dependencies on HR_API

Line 58: hr_api.mandatory_arg_error

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

Line 136: if nvl(p_rec.location_id,hr_api.g_number)

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;

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 142: if nvl(p_rec.information_type,hr_api.g_varchar2)

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;

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 152: hr_api.argument_changed_error

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;

Line 215: hr_api.mandatory_arg_error

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

Line 314: hr_api.mandatory_arg_error

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

Line 322: hr_api.mandatory_arg_error

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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)))

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 428: nvl(p_rec.lei_attribute19, hr_api.g_varchar2) 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

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 430: nvl(p_rec.lei_attribute20, 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: --
434: -- Only execute the validation if absolutely necessary:

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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))

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

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

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 597: nvl(p_rec.lei_information30, 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
601: (p_appl_short_name => 'PER'

Line 712: -- hr_api.set_security_group_id(p_security_group_id => 0); commented bug 6329528

708: -- As this data is not within the context of a business group
709: -- the set_security_group_id procedure has zero passed
710: -- to it as the default security_group_id.
711: --
712: -- hr_api.set_security_group_id(p_security_group_id => 0); commented bug 6329528
713: -- bug 6329528
714:
715: open csr_sec_grp;
716: fetch csr_sec_grp into l_security_group_id, l_legislation_code;

Line 718: hr_api.set_security_group_id(p_security_group_id => l_security_group_id);

714:
715: open csr_sec_grp;
716: fetch csr_sec_grp into l_security_group_id, l_legislation_code;
717: close csr_sec_grp;
718: hr_api.set_security_group_id(p_security_group_id => l_security_group_id);
719: --
720: --
721: hr_utility.set_location('Entering:'||l_proc, 6);
722: --

Line 793: -- hr_api.set_security_group_id(p_security_group_id => 0); commented -- bug 6329528

789: -- the set_security_group_id procedure has zero passed
790: -- to it as the default security_group_id.
791: --
792: -- bug 6329528
793: -- hr_api.set_security_group_id(p_security_group_id => 0); commented -- bug 6329528
794: --
795:
796: open csr_sec_grp;
797: fetch csr_sec_grp into l_security_group_id, l_legislation_code;

Line 799: hr_api.set_security_group_id(p_security_group_id => l_security_group_id);

795:
796: open csr_sec_grp;
797: fetch csr_sec_grp into l_security_group_id, l_legislation_code;
798: close csr_sec_grp;
799: hr_api.set_security_group_id(p_security_group_id => l_security_group_id);
800: --
801:
802: --
803: hr_utility.set_location('Entering:'||l_proc, 6);