APPS.PER_REI_BUS dependencies on HR_API

Line 45: hr_api.mandatory_arg_error

41: hr_utility.set_location('Entering:'|| l_proc, 10);
42: --
43: -- Ensure that all the mandatory parameter are not null
44: --
45: hr_api.mandatory_arg_error
46: (p_api_name => l_proc
47: ,p_argument => 'contact_relationship_id'
48: ,p_argument_value => p_contact_relationship_id
49: );

Line 71: hr_api.set_security_group_id

67: close csr_sec_grp;
68: --
69: -- Set the security_group_id in CLIENT_INFO
70: --
71: hr_api.set_security_group_id
72: (p_security_group_id => l_security_group_id
73: );
74: end if;
75: --

Line 116: hr_api.mandatory_arg_error

112: hr_utility.set_location('Entering:'|| l_proc, 10);
113: --
114: -- Ensure that all the mandatory parameter are not null
115: --
116: hr_api.mandatory_arg_error
117: (p_api_name => l_proc
118: ,p_argument => 'contact_extra_info_id'
119: ,p_argument_value => p_contact_extra_info_id
120: );

Line 122: if ( nvl(per_rei_bus.g_contact_extra_info_id, hr_api.g_number)

118: ,p_argument => 'contact_extra_info_id'
119: ,p_argument_value => p_contact_extra_info_id
120: );
121: --
122: if ( nvl(per_rei_bus.g_contact_extra_info_id, hr_api.g_number)
123: = p_contact_extra_info_id) then
124: --
125: -- The legislation code has already been found with a previous
126: -- call to this function. Just return the value in the global

Line 207: hr_api.mandatory_arg_error(

203: hr_utility.set_location('Entering:' || l_proc, 1);
204: --
205: -- Check mandatory parameters have been set
206: --
207: hr_api.mandatory_arg_error(
208: p_api_name => l_proc,
209: p_argument => 'contact_relationship_id',
210: p_argument_value => p_contact_relationship_id);
211: --

Line 281: hr_api.mandatory_arg_error(

277: hr_utility.set_location('Entering:' || l_proc, 1);
278: --
279: -- Check mandatory parameters have been set
280: --
281: hr_api.mandatory_arg_error(
282: p_api_name => l_proc,
283: p_argument => 'information_type',
284: p_argument_value => p_information_type);
285: --

Line 291: if p_datetrack_mode in (hr_api.g_insert, hr_api.g_future_change, hr_api.g_delete_next_change) then

287: -- 1) INSERT
288: -- 2) FUTURE_CHANGE (possibly extend effective_end_date)
289: -- 3) DELETE_NEXT_CHANGE (possibly extend effective_end_date)
290: --
291: if p_datetrack_mode in (hr_api.g_insert, hr_api.g_future_change, hr_api.g_delete_next_change) then
292: open csr_information_type;
293: fetch csr_information_type into l_rec;
294: if csr_information_type%notfound then
295: close csr_information_type;

Line 303: if p_datetrack_mode = hr_api.g_insert then

299: close csr_information_type;
300: --
301: -- The following validation is only done when INSERTING
302: --
303: if p_datetrack_mode = hr_api.g_insert then
304: --
305: -- Check the information_type is available in current legislation.
306: --
307: if (l_rec.legislation_code is not null and

Line 419: nvl(per_rei_shd.g_old_rec.information_type, hr_api.g_varchar2) <>

415: fnd_message.raise_error;
416: end if;
417: --
418: if ((p_rec.contact_extra_info_id is not null) and (
419: nvl(per_rei_shd.g_old_rec.information_type, hr_api.g_varchar2) <>
420: nvl(p_rec.information_type, hr_api.g_varchar2) or
421: nvl(per_rei_shd.g_old_rec.cei_information_category, hr_api.g_varchar2) <>
422: nvl(p_rec.cei_information_category, hr_api.g_varchar2) or
423: nvl(per_rei_shd.g_old_rec.cei_information1, hr_api.g_varchar2) <>

Line 420: nvl(p_rec.information_type, hr_api.g_varchar2) or

416: end if;
417: --
418: if ((p_rec.contact_extra_info_id is not null) and (
419: nvl(per_rei_shd.g_old_rec.information_type, hr_api.g_varchar2) <>
420: nvl(p_rec.information_type, hr_api.g_varchar2) or
421: nvl(per_rei_shd.g_old_rec.cei_information_category, hr_api.g_varchar2) <>
422: nvl(p_rec.cei_information_category, hr_api.g_varchar2) or
423: nvl(per_rei_shd.g_old_rec.cei_information1, hr_api.g_varchar2) <>
424: nvl(p_rec.cei_information1, hr_api.g_varchar2) or

Line 421: nvl(per_rei_shd.g_old_rec.cei_information_category, hr_api.g_varchar2) <>

417: --
418: if ((p_rec.contact_extra_info_id is not null) and (
419: nvl(per_rei_shd.g_old_rec.information_type, hr_api.g_varchar2) <>
420: nvl(p_rec.information_type, hr_api.g_varchar2) or
421: nvl(per_rei_shd.g_old_rec.cei_information_category, hr_api.g_varchar2) <>
422: nvl(p_rec.cei_information_category, hr_api.g_varchar2) or
423: nvl(per_rei_shd.g_old_rec.cei_information1, hr_api.g_varchar2) <>
424: nvl(p_rec.cei_information1, hr_api.g_varchar2) or
425: nvl(per_rei_shd.g_old_rec.cei_information2, hr_api.g_varchar2) <>

Line 422: nvl(p_rec.cei_information_category, hr_api.g_varchar2) or

418: if ((p_rec.contact_extra_info_id is not null) and (
419: nvl(per_rei_shd.g_old_rec.information_type, hr_api.g_varchar2) <>
420: nvl(p_rec.information_type, hr_api.g_varchar2) or
421: nvl(per_rei_shd.g_old_rec.cei_information_category, hr_api.g_varchar2) <>
422: nvl(p_rec.cei_information_category, hr_api.g_varchar2) or
423: nvl(per_rei_shd.g_old_rec.cei_information1, hr_api.g_varchar2) <>
424: nvl(p_rec.cei_information1, hr_api.g_varchar2) or
425: nvl(per_rei_shd.g_old_rec.cei_information2, hr_api.g_varchar2) <>
426: nvl(p_rec.cei_information2, hr_api.g_varchar2) or

Line 423: nvl(per_rei_shd.g_old_rec.cei_information1, hr_api.g_varchar2) <>

419: nvl(per_rei_shd.g_old_rec.information_type, hr_api.g_varchar2) <>
420: nvl(p_rec.information_type, hr_api.g_varchar2) or
421: nvl(per_rei_shd.g_old_rec.cei_information_category, hr_api.g_varchar2) <>
422: nvl(p_rec.cei_information_category, hr_api.g_varchar2) or
423: nvl(per_rei_shd.g_old_rec.cei_information1, hr_api.g_varchar2) <>
424: nvl(p_rec.cei_information1, hr_api.g_varchar2) or
425: nvl(per_rei_shd.g_old_rec.cei_information2, hr_api.g_varchar2) <>
426: nvl(p_rec.cei_information2, hr_api.g_varchar2) or
427: nvl(per_rei_shd.g_old_rec.cei_information3, hr_api.g_varchar2) <>

Line 424: nvl(p_rec.cei_information1, hr_api.g_varchar2) or

420: nvl(p_rec.information_type, hr_api.g_varchar2) or
421: nvl(per_rei_shd.g_old_rec.cei_information_category, hr_api.g_varchar2) <>
422: nvl(p_rec.cei_information_category, hr_api.g_varchar2) or
423: nvl(per_rei_shd.g_old_rec.cei_information1, hr_api.g_varchar2) <>
424: nvl(p_rec.cei_information1, hr_api.g_varchar2) or
425: nvl(per_rei_shd.g_old_rec.cei_information2, hr_api.g_varchar2) <>
426: nvl(p_rec.cei_information2, hr_api.g_varchar2) or
427: nvl(per_rei_shd.g_old_rec.cei_information3, hr_api.g_varchar2) <>
428: nvl(p_rec.cei_information3, hr_api.g_varchar2) or

Line 425: nvl(per_rei_shd.g_old_rec.cei_information2, hr_api.g_varchar2) <>

421: nvl(per_rei_shd.g_old_rec.cei_information_category, hr_api.g_varchar2) <>
422: nvl(p_rec.cei_information_category, hr_api.g_varchar2) or
423: nvl(per_rei_shd.g_old_rec.cei_information1, hr_api.g_varchar2) <>
424: nvl(p_rec.cei_information1, hr_api.g_varchar2) or
425: nvl(per_rei_shd.g_old_rec.cei_information2, hr_api.g_varchar2) <>
426: nvl(p_rec.cei_information2, hr_api.g_varchar2) or
427: nvl(per_rei_shd.g_old_rec.cei_information3, hr_api.g_varchar2) <>
428: nvl(p_rec.cei_information3, hr_api.g_varchar2) or
429: nvl(per_rei_shd.g_old_rec.cei_information4, hr_api.g_varchar2) <>

Line 426: nvl(p_rec.cei_information2, hr_api.g_varchar2) or

422: nvl(p_rec.cei_information_category, hr_api.g_varchar2) or
423: nvl(per_rei_shd.g_old_rec.cei_information1, hr_api.g_varchar2) <>
424: nvl(p_rec.cei_information1, hr_api.g_varchar2) or
425: nvl(per_rei_shd.g_old_rec.cei_information2, hr_api.g_varchar2) <>
426: nvl(p_rec.cei_information2, hr_api.g_varchar2) or
427: nvl(per_rei_shd.g_old_rec.cei_information3, hr_api.g_varchar2) <>
428: nvl(p_rec.cei_information3, hr_api.g_varchar2) or
429: nvl(per_rei_shd.g_old_rec.cei_information4, hr_api.g_varchar2) <>
430: nvl(p_rec.cei_information4, hr_api.g_varchar2) or

Line 427: nvl(per_rei_shd.g_old_rec.cei_information3, hr_api.g_varchar2) <>

423: nvl(per_rei_shd.g_old_rec.cei_information1, hr_api.g_varchar2) <>
424: nvl(p_rec.cei_information1, hr_api.g_varchar2) or
425: nvl(per_rei_shd.g_old_rec.cei_information2, hr_api.g_varchar2) <>
426: nvl(p_rec.cei_information2, hr_api.g_varchar2) or
427: nvl(per_rei_shd.g_old_rec.cei_information3, hr_api.g_varchar2) <>
428: nvl(p_rec.cei_information3, hr_api.g_varchar2) or
429: nvl(per_rei_shd.g_old_rec.cei_information4, hr_api.g_varchar2) <>
430: nvl(p_rec.cei_information4, hr_api.g_varchar2) or
431: nvl(per_rei_shd.g_old_rec.cei_information5, hr_api.g_varchar2) <>

Line 428: nvl(p_rec.cei_information3, hr_api.g_varchar2) or

424: nvl(p_rec.cei_information1, hr_api.g_varchar2) or
425: nvl(per_rei_shd.g_old_rec.cei_information2, hr_api.g_varchar2) <>
426: nvl(p_rec.cei_information2, hr_api.g_varchar2) or
427: nvl(per_rei_shd.g_old_rec.cei_information3, hr_api.g_varchar2) <>
428: nvl(p_rec.cei_information3, hr_api.g_varchar2) or
429: nvl(per_rei_shd.g_old_rec.cei_information4, hr_api.g_varchar2) <>
430: nvl(p_rec.cei_information4, hr_api.g_varchar2) or
431: nvl(per_rei_shd.g_old_rec.cei_information5, hr_api.g_varchar2) <>
432: nvl(p_rec.cei_information5, hr_api.g_varchar2) or

Line 429: nvl(per_rei_shd.g_old_rec.cei_information4, hr_api.g_varchar2) <>

425: nvl(per_rei_shd.g_old_rec.cei_information2, hr_api.g_varchar2) <>
426: nvl(p_rec.cei_information2, hr_api.g_varchar2) or
427: nvl(per_rei_shd.g_old_rec.cei_information3, hr_api.g_varchar2) <>
428: nvl(p_rec.cei_information3, hr_api.g_varchar2) or
429: nvl(per_rei_shd.g_old_rec.cei_information4, hr_api.g_varchar2) <>
430: nvl(p_rec.cei_information4, hr_api.g_varchar2) or
431: nvl(per_rei_shd.g_old_rec.cei_information5, hr_api.g_varchar2) <>
432: nvl(p_rec.cei_information5, hr_api.g_varchar2) or
433: nvl(per_rei_shd.g_old_rec.cei_information6, hr_api.g_varchar2) <>

Line 430: nvl(p_rec.cei_information4, hr_api.g_varchar2) or

426: nvl(p_rec.cei_information2, hr_api.g_varchar2) or
427: nvl(per_rei_shd.g_old_rec.cei_information3, hr_api.g_varchar2) <>
428: nvl(p_rec.cei_information3, hr_api.g_varchar2) or
429: nvl(per_rei_shd.g_old_rec.cei_information4, hr_api.g_varchar2) <>
430: nvl(p_rec.cei_information4, hr_api.g_varchar2) or
431: nvl(per_rei_shd.g_old_rec.cei_information5, hr_api.g_varchar2) <>
432: nvl(p_rec.cei_information5, hr_api.g_varchar2) or
433: nvl(per_rei_shd.g_old_rec.cei_information6, hr_api.g_varchar2) <>
434: nvl(p_rec.cei_information6, hr_api.g_varchar2) or

Line 431: nvl(per_rei_shd.g_old_rec.cei_information5, hr_api.g_varchar2) <>

427: nvl(per_rei_shd.g_old_rec.cei_information3, hr_api.g_varchar2) <>
428: nvl(p_rec.cei_information3, hr_api.g_varchar2) or
429: nvl(per_rei_shd.g_old_rec.cei_information4, hr_api.g_varchar2) <>
430: nvl(p_rec.cei_information4, hr_api.g_varchar2) or
431: nvl(per_rei_shd.g_old_rec.cei_information5, hr_api.g_varchar2) <>
432: nvl(p_rec.cei_information5, hr_api.g_varchar2) or
433: nvl(per_rei_shd.g_old_rec.cei_information6, hr_api.g_varchar2) <>
434: nvl(p_rec.cei_information6, hr_api.g_varchar2) or
435: nvl(per_rei_shd.g_old_rec.cei_information7, hr_api.g_varchar2) <>

Line 432: nvl(p_rec.cei_information5, hr_api.g_varchar2) or

428: nvl(p_rec.cei_information3, hr_api.g_varchar2) or
429: nvl(per_rei_shd.g_old_rec.cei_information4, hr_api.g_varchar2) <>
430: nvl(p_rec.cei_information4, hr_api.g_varchar2) or
431: nvl(per_rei_shd.g_old_rec.cei_information5, hr_api.g_varchar2) <>
432: nvl(p_rec.cei_information5, hr_api.g_varchar2) or
433: nvl(per_rei_shd.g_old_rec.cei_information6, hr_api.g_varchar2) <>
434: nvl(p_rec.cei_information6, hr_api.g_varchar2) or
435: nvl(per_rei_shd.g_old_rec.cei_information7, hr_api.g_varchar2) <>
436: nvl(p_rec.cei_information7, hr_api.g_varchar2) or

Line 433: nvl(per_rei_shd.g_old_rec.cei_information6, hr_api.g_varchar2) <>

429: nvl(per_rei_shd.g_old_rec.cei_information4, hr_api.g_varchar2) <>
430: nvl(p_rec.cei_information4, hr_api.g_varchar2) or
431: nvl(per_rei_shd.g_old_rec.cei_information5, hr_api.g_varchar2) <>
432: nvl(p_rec.cei_information5, hr_api.g_varchar2) or
433: nvl(per_rei_shd.g_old_rec.cei_information6, hr_api.g_varchar2) <>
434: nvl(p_rec.cei_information6, hr_api.g_varchar2) or
435: nvl(per_rei_shd.g_old_rec.cei_information7, hr_api.g_varchar2) <>
436: nvl(p_rec.cei_information7, hr_api.g_varchar2) or
437: nvl(per_rei_shd.g_old_rec.cei_information8, hr_api.g_varchar2) <>

Line 434: nvl(p_rec.cei_information6, hr_api.g_varchar2) or

430: nvl(p_rec.cei_information4, hr_api.g_varchar2) or
431: nvl(per_rei_shd.g_old_rec.cei_information5, hr_api.g_varchar2) <>
432: nvl(p_rec.cei_information5, hr_api.g_varchar2) or
433: nvl(per_rei_shd.g_old_rec.cei_information6, hr_api.g_varchar2) <>
434: nvl(p_rec.cei_information6, hr_api.g_varchar2) or
435: nvl(per_rei_shd.g_old_rec.cei_information7, hr_api.g_varchar2) <>
436: nvl(p_rec.cei_information7, hr_api.g_varchar2) or
437: nvl(per_rei_shd.g_old_rec.cei_information8, hr_api.g_varchar2) <>
438: nvl(p_rec.cei_information8, hr_api.g_varchar2) or

Line 435: nvl(per_rei_shd.g_old_rec.cei_information7, hr_api.g_varchar2) <>

431: nvl(per_rei_shd.g_old_rec.cei_information5, hr_api.g_varchar2) <>
432: nvl(p_rec.cei_information5, hr_api.g_varchar2) or
433: nvl(per_rei_shd.g_old_rec.cei_information6, hr_api.g_varchar2) <>
434: nvl(p_rec.cei_information6, hr_api.g_varchar2) or
435: nvl(per_rei_shd.g_old_rec.cei_information7, hr_api.g_varchar2) <>
436: nvl(p_rec.cei_information7, hr_api.g_varchar2) or
437: nvl(per_rei_shd.g_old_rec.cei_information8, hr_api.g_varchar2) <>
438: nvl(p_rec.cei_information8, hr_api.g_varchar2) or
439: nvl(per_rei_shd.g_old_rec.cei_information9, hr_api.g_varchar2) <>

Line 436: nvl(p_rec.cei_information7, hr_api.g_varchar2) or

432: nvl(p_rec.cei_information5, hr_api.g_varchar2) or
433: nvl(per_rei_shd.g_old_rec.cei_information6, hr_api.g_varchar2) <>
434: nvl(p_rec.cei_information6, hr_api.g_varchar2) or
435: nvl(per_rei_shd.g_old_rec.cei_information7, hr_api.g_varchar2) <>
436: nvl(p_rec.cei_information7, hr_api.g_varchar2) or
437: nvl(per_rei_shd.g_old_rec.cei_information8, hr_api.g_varchar2) <>
438: nvl(p_rec.cei_information8, hr_api.g_varchar2) or
439: nvl(per_rei_shd.g_old_rec.cei_information9, hr_api.g_varchar2) <>
440: nvl(p_rec.cei_information9, hr_api.g_varchar2) or

Line 437: nvl(per_rei_shd.g_old_rec.cei_information8, hr_api.g_varchar2) <>

433: nvl(per_rei_shd.g_old_rec.cei_information6, hr_api.g_varchar2) <>
434: nvl(p_rec.cei_information6, hr_api.g_varchar2) or
435: nvl(per_rei_shd.g_old_rec.cei_information7, hr_api.g_varchar2) <>
436: nvl(p_rec.cei_information7, hr_api.g_varchar2) or
437: nvl(per_rei_shd.g_old_rec.cei_information8, hr_api.g_varchar2) <>
438: nvl(p_rec.cei_information8, hr_api.g_varchar2) or
439: nvl(per_rei_shd.g_old_rec.cei_information9, hr_api.g_varchar2) <>
440: nvl(p_rec.cei_information9, hr_api.g_varchar2) or
441: nvl(per_rei_shd.g_old_rec.cei_information10, hr_api.g_varchar2) <>

Line 438: nvl(p_rec.cei_information8, hr_api.g_varchar2) or

434: nvl(p_rec.cei_information6, hr_api.g_varchar2) or
435: nvl(per_rei_shd.g_old_rec.cei_information7, hr_api.g_varchar2) <>
436: nvl(p_rec.cei_information7, hr_api.g_varchar2) or
437: nvl(per_rei_shd.g_old_rec.cei_information8, hr_api.g_varchar2) <>
438: nvl(p_rec.cei_information8, hr_api.g_varchar2) or
439: nvl(per_rei_shd.g_old_rec.cei_information9, hr_api.g_varchar2) <>
440: nvl(p_rec.cei_information9, hr_api.g_varchar2) or
441: nvl(per_rei_shd.g_old_rec.cei_information10, hr_api.g_varchar2) <>
442: nvl(p_rec.cei_information10, hr_api.g_varchar2) or

Line 439: nvl(per_rei_shd.g_old_rec.cei_information9, hr_api.g_varchar2) <>

435: nvl(per_rei_shd.g_old_rec.cei_information7, hr_api.g_varchar2) <>
436: nvl(p_rec.cei_information7, hr_api.g_varchar2) or
437: nvl(per_rei_shd.g_old_rec.cei_information8, hr_api.g_varchar2) <>
438: nvl(p_rec.cei_information8, hr_api.g_varchar2) or
439: nvl(per_rei_shd.g_old_rec.cei_information9, hr_api.g_varchar2) <>
440: nvl(p_rec.cei_information9, hr_api.g_varchar2) or
441: nvl(per_rei_shd.g_old_rec.cei_information10, hr_api.g_varchar2) <>
442: nvl(p_rec.cei_information10, hr_api.g_varchar2) or
443: nvl(per_rei_shd.g_old_rec.cei_information11, hr_api.g_varchar2) <>

Line 440: nvl(p_rec.cei_information9, hr_api.g_varchar2) or

436: nvl(p_rec.cei_information7, hr_api.g_varchar2) or
437: nvl(per_rei_shd.g_old_rec.cei_information8, hr_api.g_varchar2) <>
438: nvl(p_rec.cei_information8, hr_api.g_varchar2) or
439: nvl(per_rei_shd.g_old_rec.cei_information9, hr_api.g_varchar2) <>
440: nvl(p_rec.cei_information9, hr_api.g_varchar2) or
441: nvl(per_rei_shd.g_old_rec.cei_information10, hr_api.g_varchar2) <>
442: nvl(p_rec.cei_information10, hr_api.g_varchar2) or
443: nvl(per_rei_shd.g_old_rec.cei_information11, hr_api.g_varchar2) <>
444: nvl(p_rec.cei_information11, hr_api.g_varchar2) or

Line 441: nvl(per_rei_shd.g_old_rec.cei_information10, hr_api.g_varchar2) <>

437: nvl(per_rei_shd.g_old_rec.cei_information8, hr_api.g_varchar2) <>
438: nvl(p_rec.cei_information8, hr_api.g_varchar2) or
439: nvl(per_rei_shd.g_old_rec.cei_information9, hr_api.g_varchar2) <>
440: nvl(p_rec.cei_information9, hr_api.g_varchar2) or
441: nvl(per_rei_shd.g_old_rec.cei_information10, hr_api.g_varchar2) <>
442: nvl(p_rec.cei_information10, hr_api.g_varchar2) or
443: nvl(per_rei_shd.g_old_rec.cei_information11, hr_api.g_varchar2) <>
444: nvl(p_rec.cei_information11, hr_api.g_varchar2) or
445: nvl(per_rei_shd.g_old_rec.cei_information12, hr_api.g_varchar2) <>

Line 442: nvl(p_rec.cei_information10, hr_api.g_varchar2) or

438: nvl(p_rec.cei_information8, hr_api.g_varchar2) or
439: nvl(per_rei_shd.g_old_rec.cei_information9, hr_api.g_varchar2) <>
440: nvl(p_rec.cei_information9, hr_api.g_varchar2) or
441: nvl(per_rei_shd.g_old_rec.cei_information10, hr_api.g_varchar2) <>
442: nvl(p_rec.cei_information10, hr_api.g_varchar2) or
443: nvl(per_rei_shd.g_old_rec.cei_information11, hr_api.g_varchar2) <>
444: nvl(p_rec.cei_information11, hr_api.g_varchar2) or
445: nvl(per_rei_shd.g_old_rec.cei_information12, hr_api.g_varchar2) <>
446: nvl(p_rec.cei_information12, hr_api.g_varchar2) or

Line 443: nvl(per_rei_shd.g_old_rec.cei_information11, hr_api.g_varchar2) <>

439: nvl(per_rei_shd.g_old_rec.cei_information9, hr_api.g_varchar2) <>
440: nvl(p_rec.cei_information9, hr_api.g_varchar2) or
441: nvl(per_rei_shd.g_old_rec.cei_information10, hr_api.g_varchar2) <>
442: nvl(p_rec.cei_information10, hr_api.g_varchar2) or
443: nvl(per_rei_shd.g_old_rec.cei_information11, hr_api.g_varchar2) <>
444: nvl(p_rec.cei_information11, hr_api.g_varchar2) or
445: nvl(per_rei_shd.g_old_rec.cei_information12, hr_api.g_varchar2) <>
446: nvl(p_rec.cei_information12, hr_api.g_varchar2) or
447: nvl(per_rei_shd.g_old_rec.cei_information13, hr_api.g_varchar2) <>

Line 444: nvl(p_rec.cei_information11, hr_api.g_varchar2) or

440: nvl(p_rec.cei_information9, hr_api.g_varchar2) or
441: nvl(per_rei_shd.g_old_rec.cei_information10, hr_api.g_varchar2) <>
442: nvl(p_rec.cei_information10, hr_api.g_varchar2) or
443: nvl(per_rei_shd.g_old_rec.cei_information11, hr_api.g_varchar2) <>
444: nvl(p_rec.cei_information11, hr_api.g_varchar2) or
445: nvl(per_rei_shd.g_old_rec.cei_information12, hr_api.g_varchar2) <>
446: nvl(p_rec.cei_information12, hr_api.g_varchar2) or
447: nvl(per_rei_shd.g_old_rec.cei_information13, hr_api.g_varchar2) <>
448: nvl(p_rec.cei_information13, hr_api.g_varchar2) or

Line 445: nvl(per_rei_shd.g_old_rec.cei_information12, hr_api.g_varchar2) <>

441: nvl(per_rei_shd.g_old_rec.cei_information10, hr_api.g_varchar2) <>
442: nvl(p_rec.cei_information10, hr_api.g_varchar2) or
443: nvl(per_rei_shd.g_old_rec.cei_information11, hr_api.g_varchar2) <>
444: nvl(p_rec.cei_information11, hr_api.g_varchar2) or
445: nvl(per_rei_shd.g_old_rec.cei_information12, hr_api.g_varchar2) <>
446: nvl(p_rec.cei_information12, hr_api.g_varchar2) or
447: nvl(per_rei_shd.g_old_rec.cei_information13, hr_api.g_varchar2) <>
448: nvl(p_rec.cei_information13, hr_api.g_varchar2) or
449: nvl(per_rei_shd.g_old_rec.cei_information14, hr_api.g_varchar2) <>

Line 446: nvl(p_rec.cei_information12, hr_api.g_varchar2) or

442: nvl(p_rec.cei_information10, hr_api.g_varchar2) or
443: nvl(per_rei_shd.g_old_rec.cei_information11, hr_api.g_varchar2) <>
444: nvl(p_rec.cei_information11, hr_api.g_varchar2) or
445: nvl(per_rei_shd.g_old_rec.cei_information12, hr_api.g_varchar2) <>
446: nvl(p_rec.cei_information12, hr_api.g_varchar2) or
447: nvl(per_rei_shd.g_old_rec.cei_information13, hr_api.g_varchar2) <>
448: nvl(p_rec.cei_information13, hr_api.g_varchar2) or
449: nvl(per_rei_shd.g_old_rec.cei_information14, hr_api.g_varchar2) <>
450: nvl(p_rec.cei_information14, hr_api.g_varchar2) or

Line 447: nvl(per_rei_shd.g_old_rec.cei_information13, hr_api.g_varchar2) <>

443: nvl(per_rei_shd.g_old_rec.cei_information11, hr_api.g_varchar2) <>
444: nvl(p_rec.cei_information11, hr_api.g_varchar2) or
445: nvl(per_rei_shd.g_old_rec.cei_information12, hr_api.g_varchar2) <>
446: nvl(p_rec.cei_information12, hr_api.g_varchar2) or
447: nvl(per_rei_shd.g_old_rec.cei_information13, hr_api.g_varchar2) <>
448: nvl(p_rec.cei_information13, hr_api.g_varchar2) or
449: nvl(per_rei_shd.g_old_rec.cei_information14, hr_api.g_varchar2) <>
450: nvl(p_rec.cei_information14, hr_api.g_varchar2) or
451: nvl(per_rei_shd.g_old_rec.cei_information15, hr_api.g_varchar2) <>

Line 448: nvl(p_rec.cei_information13, hr_api.g_varchar2) or

444: nvl(p_rec.cei_information11, hr_api.g_varchar2) or
445: nvl(per_rei_shd.g_old_rec.cei_information12, hr_api.g_varchar2) <>
446: nvl(p_rec.cei_information12, hr_api.g_varchar2) or
447: nvl(per_rei_shd.g_old_rec.cei_information13, hr_api.g_varchar2) <>
448: nvl(p_rec.cei_information13, hr_api.g_varchar2) or
449: nvl(per_rei_shd.g_old_rec.cei_information14, hr_api.g_varchar2) <>
450: nvl(p_rec.cei_information14, hr_api.g_varchar2) or
451: nvl(per_rei_shd.g_old_rec.cei_information15, hr_api.g_varchar2) <>
452: nvl(p_rec.cei_information15, hr_api.g_varchar2) or

Line 449: nvl(per_rei_shd.g_old_rec.cei_information14, hr_api.g_varchar2) <>

445: nvl(per_rei_shd.g_old_rec.cei_information12, hr_api.g_varchar2) <>
446: nvl(p_rec.cei_information12, hr_api.g_varchar2) or
447: nvl(per_rei_shd.g_old_rec.cei_information13, hr_api.g_varchar2) <>
448: nvl(p_rec.cei_information13, hr_api.g_varchar2) or
449: nvl(per_rei_shd.g_old_rec.cei_information14, hr_api.g_varchar2) <>
450: nvl(p_rec.cei_information14, hr_api.g_varchar2) or
451: nvl(per_rei_shd.g_old_rec.cei_information15, hr_api.g_varchar2) <>
452: nvl(p_rec.cei_information15, hr_api.g_varchar2) or
453: nvl(per_rei_shd.g_old_rec.cei_information16, hr_api.g_varchar2) <>

Line 450: nvl(p_rec.cei_information14, hr_api.g_varchar2) or

446: nvl(p_rec.cei_information12, hr_api.g_varchar2) or
447: nvl(per_rei_shd.g_old_rec.cei_information13, hr_api.g_varchar2) <>
448: nvl(p_rec.cei_information13, hr_api.g_varchar2) or
449: nvl(per_rei_shd.g_old_rec.cei_information14, hr_api.g_varchar2) <>
450: nvl(p_rec.cei_information14, hr_api.g_varchar2) or
451: nvl(per_rei_shd.g_old_rec.cei_information15, hr_api.g_varchar2) <>
452: nvl(p_rec.cei_information15, hr_api.g_varchar2) or
453: nvl(per_rei_shd.g_old_rec.cei_information16, hr_api.g_varchar2) <>
454: nvl(p_rec.cei_information16, hr_api.g_varchar2) or

Line 451: nvl(per_rei_shd.g_old_rec.cei_information15, hr_api.g_varchar2) <>

447: nvl(per_rei_shd.g_old_rec.cei_information13, hr_api.g_varchar2) <>
448: nvl(p_rec.cei_information13, hr_api.g_varchar2) or
449: nvl(per_rei_shd.g_old_rec.cei_information14, hr_api.g_varchar2) <>
450: nvl(p_rec.cei_information14, hr_api.g_varchar2) or
451: nvl(per_rei_shd.g_old_rec.cei_information15, hr_api.g_varchar2) <>
452: nvl(p_rec.cei_information15, hr_api.g_varchar2) or
453: nvl(per_rei_shd.g_old_rec.cei_information16, hr_api.g_varchar2) <>
454: nvl(p_rec.cei_information16, hr_api.g_varchar2) or
455: nvl(per_rei_shd.g_old_rec.cei_information17, hr_api.g_varchar2) <>

Line 452: nvl(p_rec.cei_information15, hr_api.g_varchar2) or

448: nvl(p_rec.cei_information13, hr_api.g_varchar2) or
449: nvl(per_rei_shd.g_old_rec.cei_information14, hr_api.g_varchar2) <>
450: nvl(p_rec.cei_information14, hr_api.g_varchar2) or
451: nvl(per_rei_shd.g_old_rec.cei_information15, hr_api.g_varchar2) <>
452: nvl(p_rec.cei_information15, hr_api.g_varchar2) or
453: nvl(per_rei_shd.g_old_rec.cei_information16, hr_api.g_varchar2) <>
454: nvl(p_rec.cei_information16, hr_api.g_varchar2) or
455: nvl(per_rei_shd.g_old_rec.cei_information17, hr_api.g_varchar2) <>
456: nvl(p_rec.cei_information17, hr_api.g_varchar2) or

Line 453: nvl(per_rei_shd.g_old_rec.cei_information16, hr_api.g_varchar2) <>

449: nvl(per_rei_shd.g_old_rec.cei_information14, hr_api.g_varchar2) <>
450: nvl(p_rec.cei_information14, hr_api.g_varchar2) or
451: nvl(per_rei_shd.g_old_rec.cei_information15, hr_api.g_varchar2) <>
452: nvl(p_rec.cei_information15, hr_api.g_varchar2) or
453: nvl(per_rei_shd.g_old_rec.cei_information16, hr_api.g_varchar2) <>
454: nvl(p_rec.cei_information16, hr_api.g_varchar2) or
455: nvl(per_rei_shd.g_old_rec.cei_information17, hr_api.g_varchar2) <>
456: nvl(p_rec.cei_information17, hr_api.g_varchar2) or
457: nvl(per_rei_shd.g_old_rec.cei_information18, hr_api.g_varchar2) <>

Line 454: nvl(p_rec.cei_information16, hr_api.g_varchar2) or

450: nvl(p_rec.cei_information14, hr_api.g_varchar2) or
451: nvl(per_rei_shd.g_old_rec.cei_information15, hr_api.g_varchar2) <>
452: nvl(p_rec.cei_information15, hr_api.g_varchar2) or
453: nvl(per_rei_shd.g_old_rec.cei_information16, hr_api.g_varchar2) <>
454: nvl(p_rec.cei_information16, hr_api.g_varchar2) or
455: nvl(per_rei_shd.g_old_rec.cei_information17, hr_api.g_varchar2) <>
456: nvl(p_rec.cei_information17, hr_api.g_varchar2) or
457: nvl(per_rei_shd.g_old_rec.cei_information18, hr_api.g_varchar2) <>
458: nvl(p_rec.cei_information18, hr_api.g_varchar2) or

Line 455: nvl(per_rei_shd.g_old_rec.cei_information17, hr_api.g_varchar2) <>

451: nvl(per_rei_shd.g_old_rec.cei_information15, hr_api.g_varchar2) <>
452: nvl(p_rec.cei_information15, hr_api.g_varchar2) or
453: nvl(per_rei_shd.g_old_rec.cei_information16, hr_api.g_varchar2) <>
454: nvl(p_rec.cei_information16, hr_api.g_varchar2) or
455: nvl(per_rei_shd.g_old_rec.cei_information17, hr_api.g_varchar2) <>
456: nvl(p_rec.cei_information17, hr_api.g_varchar2) or
457: nvl(per_rei_shd.g_old_rec.cei_information18, hr_api.g_varchar2) <>
458: nvl(p_rec.cei_information18, hr_api.g_varchar2) or
459: nvl(per_rei_shd.g_old_rec.cei_information19, hr_api.g_varchar2) <>

Line 456: nvl(p_rec.cei_information17, hr_api.g_varchar2) or

452: nvl(p_rec.cei_information15, hr_api.g_varchar2) or
453: nvl(per_rei_shd.g_old_rec.cei_information16, hr_api.g_varchar2) <>
454: nvl(p_rec.cei_information16, hr_api.g_varchar2) or
455: nvl(per_rei_shd.g_old_rec.cei_information17, hr_api.g_varchar2) <>
456: nvl(p_rec.cei_information17, hr_api.g_varchar2) or
457: nvl(per_rei_shd.g_old_rec.cei_information18, hr_api.g_varchar2) <>
458: nvl(p_rec.cei_information18, hr_api.g_varchar2) or
459: nvl(per_rei_shd.g_old_rec.cei_information19, hr_api.g_varchar2) <>
460: nvl(p_rec.cei_information19, hr_api.g_varchar2) or

Line 457: nvl(per_rei_shd.g_old_rec.cei_information18, hr_api.g_varchar2) <>

453: nvl(per_rei_shd.g_old_rec.cei_information16, hr_api.g_varchar2) <>
454: nvl(p_rec.cei_information16, hr_api.g_varchar2) or
455: nvl(per_rei_shd.g_old_rec.cei_information17, hr_api.g_varchar2) <>
456: nvl(p_rec.cei_information17, hr_api.g_varchar2) or
457: nvl(per_rei_shd.g_old_rec.cei_information18, hr_api.g_varchar2) <>
458: nvl(p_rec.cei_information18, hr_api.g_varchar2) or
459: nvl(per_rei_shd.g_old_rec.cei_information19, hr_api.g_varchar2) <>
460: nvl(p_rec.cei_information19, hr_api.g_varchar2) or
461: nvl(per_rei_shd.g_old_rec.cei_information20, hr_api.g_varchar2) <>

Line 458: nvl(p_rec.cei_information18, hr_api.g_varchar2) or

454: nvl(p_rec.cei_information16, hr_api.g_varchar2) or
455: nvl(per_rei_shd.g_old_rec.cei_information17, hr_api.g_varchar2) <>
456: nvl(p_rec.cei_information17, hr_api.g_varchar2) or
457: nvl(per_rei_shd.g_old_rec.cei_information18, hr_api.g_varchar2) <>
458: nvl(p_rec.cei_information18, hr_api.g_varchar2) or
459: nvl(per_rei_shd.g_old_rec.cei_information19, hr_api.g_varchar2) <>
460: nvl(p_rec.cei_information19, hr_api.g_varchar2) or
461: nvl(per_rei_shd.g_old_rec.cei_information20, hr_api.g_varchar2) <>
462: nvl(p_rec.cei_information20, hr_api.g_varchar2) or

Line 459: nvl(per_rei_shd.g_old_rec.cei_information19, hr_api.g_varchar2) <>

455: nvl(per_rei_shd.g_old_rec.cei_information17, hr_api.g_varchar2) <>
456: nvl(p_rec.cei_information17, hr_api.g_varchar2) or
457: nvl(per_rei_shd.g_old_rec.cei_information18, hr_api.g_varchar2) <>
458: nvl(p_rec.cei_information18, hr_api.g_varchar2) or
459: nvl(per_rei_shd.g_old_rec.cei_information19, hr_api.g_varchar2) <>
460: nvl(p_rec.cei_information19, hr_api.g_varchar2) or
461: nvl(per_rei_shd.g_old_rec.cei_information20, hr_api.g_varchar2) <>
462: nvl(p_rec.cei_information20, hr_api.g_varchar2) or
463: nvl(per_rei_shd.g_old_rec.cei_information21, hr_api.g_varchar2) <>

Line 460: nvl(p_rec.cei_information19, hr_api.g_varchar2) or

456: nvl(p_rec.cei_information17, hr_api.g_varchar2) or
457: nvl(per_rei_shd.g_old_rec.cei_information18, hr_api.g_varchar2) <>
458: nvl(p_rec.cei_information18, hr_api.g_varchar2) or
459: nvl(per_rei_shd.g_old_rec.cei_information19, hr_api.g_varchar2) <>
460: nvl(p_rec.cei_information19, hr_api.g_varchar2) or
461: nvl(per_rei_shd.g_old_rec.cei_information20, hr_api.g_varchar2) <>
462: nvl(p_rec.cei_information20, hr_api.g_varchar2) or
463: nvl(per_rei_shd.g_old_rec.cei_information21, hr_api.g_varchar2) <>
464: nvl(p_rec.cei_information21, hr_api.g_varchar2) or

Line 461: nvl(per_rei_shd.g_old_rec.cei_information20, hr_api.g_varchar2) <>

457: nvl(per_rei_shd.g_old_rec.cei_information18, hr_api.g_varchar2) <>
458: nvl(p_rec.cei_information18, hr_api.g_varchar2) or
459: nvl(per_rei_shd.g_old_rec.cei_information19, hr_api.g_varchar2) <>
460: nvl(p_rec.cei_information19, hr_api.g_varchar2) or
461: nvl(per_rei_shd.g_old_rec.cei_information20, hr_api.g_varchar2) <>
462: nvl(p_rec.cei_information20, hr_api.g_varchar2) or
463: nvl(per_rei_shd.g_old_rec.cei_information21, hr_api.g_varchar2) <>
464: nvl(p_rec.cei_information21, hr_api.g_varchar2) or
465: nvl(per_rei_shd.g_old_rec.cei_information22, hr_api.g_varchar2) <>

Line 462: nvl(p_rec.cei_information20, hr_api.g_varchar2) or

458: nvl(p_rec.cei_information18, hr_api.g_varchar2) or
459: nvl(per_rei_shd.g_old_rec.cei_information19, hr_api.g_varchar2) <>
460: nvl(p_rec.cei_information19, hr_api.g_varchar2) or
461: nvl(per_rei_shd.g_old_rec.cei_information20, hr_api.g_varchar2) <>
462: nvl(p_rec.cei_information20, hr_api.g_varchar2) or
463: nvl(per_rei_shd.g_old_rec.cei_information21, hr_api.g_varchar2) <>
464: nvl(p_rec.cei_information21, hr_api.g_varchar2) or
465: nvl(per_rei_shd.g_old_rec.cei_information22, hr_api.g_varchar2) <>
466: nvl(p_rec.cei_information22, hr_api.g_varchar2) or

Line 463: nvl(per_rei_shd.g_old_rec.cei_information21, hr_api.g_varchar2) <>

459: nvl(per_rei_shd.g_old_rec.cei_information19, hr_api.g_varchar2) <>
460: nvl(p_rec.cei_information19, hr_api.g_varchar2) or
461: nvl(per_rei_shd.g_old_rec.cei_information20, hr_api.g_varchar2) <>
462: nvl(p_rec.cei_information20, hr_api.g_varchar2) or
463: nvl(per_rei_shd.g_old_rec.cei_information21, hr_api.g_varchar2) <>
464: nvl(p_rec.cei_information21, hr_api.g_varchar2) or
465: nvl(per_rei_shd.g_old_rec.cei_information22, hr_api.g_varchar2) <>
466: nvl(p_rec.cei_information22, hr_api.g_varchar2) or
467: nvl(per_rei_shd.g_old_rec.cei_information23, hr_api.g_varchar2) <>

Line 464: nvl(p_rec.cei_information21, hr_api.g_varchar2) or

460: nvl(p_rec.cei_information19, hr_api.g_varchar2) or
461: nvl(per_rei_shd.g_old_rec.cei_information20, hr_api.g_varchar2) <>
462: nvl(p_rec.cei_information20, hr_api.g_varchar2) or
463: nvl(per_rei_shd.g_old_rec.cei_information21, hr_api.g_varchar2) <>
464: nvl(p_rec.cei_information21, hr_api.g_varchar2) or
465: nvl(per_rei_shd.g_old_rec.cei_information22, hr_api.g_varchar2) <>
466: nvl(p_rec.cei_information22, hr_api.g_varchar2) or
467: nvl(per_rei_shd.g_old_rec.cei_information23, hr_api.g_varchar2) <>
468: nvl(p_rec.cei_information23, hr_api.g_varchar2) or

Line 465: nvl(per_rei_shd.g_old_rec.cei_information22, hr_api.g_varchar2) <>

461: nvl(per_rei_shd.g_old_rec.cei_information20, hr_api.g_varchar2) <>
462: nvl(p_rec.cei_information20, hr_api.g_varchar2) or
463: nvl(per_rei_shd.g_old_rec.cei_information21, hr_api.g_varchar2) <>
464: nvl(p_rec.cei_information21, hr_api.g_varchar2) or
465: nvl(per_rei_shd.g_old_rec.cei_information22, hr_api.g_varchar2) <>
466: nvl(p_rec.cei_information22, hr_api.g_varchar2) or
467: nvl(per_rei_shd.g_old_rec.cei_information23, hr_api.g_varchar2) <>
468: nvl(p_rec.cei_information23, hr_api.g_varchar2) or
469: nvl(per_rei_shd.g_old_rec.cei_information24, hr_api.g_varchar2) <>

Line 466: nvl(p_rec.cei_information22, hr_api.g_varchar2) or

462: nvl(p_rec.cei_information20, hr_api.g_varchar2) or
463: nvl(per_rei_shd.g_old_rec.cei_information21, hr_api.g_varchar2) <>
464: nvl(p_rec.cei_information21, hr_api.g_varchar2) or
465: nvl(per_rei_shd.g_old_rec.cei_information22, hr_api.g_varchar2) <>
466: nvl(p_rec.cei_information22, hr_api.g_varchar2) or
467: nvl(per_rei_shd.g_old_rec.cei_information23, hr_api.g_varchar2) <>
468: nvl(p_rec.cei_information23, hr_api.g_varchar2) or
469: nvl(per_rei_shd.g_old_rec.cei_information24, hr_api.g_varchar2) <>
470: nvl(p_rec.cei_information24, hr_api.g_varchar2) or

Line 467: nvl(per_rei_shd.g_old_rec.cei_information23, hr_api.g_varchar2) <>

463: nvl(per_rei_shd.g_old_rec.cei_information21, hr_api.g_varchar2) <>
464: nvl(p_rec.cei_information21, hr_api.g_varchar2) or
465: nvl(per_rei_shd.g_old_rec.cei_information22, hr_api.g_varchar2) <>
466: nvl(p_rec.cei_information22, hr_api.g_varchar2) or
467: nvl(per_rei_shd.g_old_rec.cei_information23, hr_api.g_varchar2) <>
468: nvl(p_rec.cei_information23, hr_api.g_varchar2) or
469: nvl(per_rei_shd.g_old_rec.cei_information24, hr_api.g_varchar2) <>
470: nvl(p_rec.cei_information24, hr_api.g_varchar2) or
471: nvl(per_rei_shd.g_old_rec.cei_information25, hr_api.g_varchar2) <>

Line 468: nvl(p_rec.cei_information23, hr_api.g_varchar2) or

464: nvl(p_rec.cei_information21, hr_api.g_varchar2) or
465: nvl(per_rei_shd.g_old_rec.cei_information22, hr_api.g_varchar2) <>
466: nvl(p_rec.cei_information22, hr_api.g_varchar2) or
467: nvl(per_rei_shd.g_old_rec.cei_information23, hr_api.g_varchar2) <>
468: nvl(p_rec.cei_information23, hr_api.g_varchar2) or
469: nvl(per_rei_shd.g_old_rec.cei_information24, hr_api.g_varchar2) <>
470: nvl(p_rec.cei_information24, hr_api.g_varchar2) or
471: nvl(per_rei_shd.g_old_rec.cei_information25, hr_api.g_varchar2) <>
472: nvl(p_rec.cei_information25, hr_api.g_varchar2) or

Line 469: nvl(per_rei_shd.g_old_rec.cei_information24, hr_api.g_varchar2) <>

465: nvl(per_rei_shd.g_old_rec.cei_information22, hr_api.g_varchar2) <>
466: nvl(p_rec.cei_information22, hr_api.g_varchar2) or
467: nvl(per_rei_shd.g_old_rec.cei_information23, hr_api.g_varchar2) <>
468: nvl(p_rec.cei_information23, hr_api.g_varchar2) or
469: nvl(per_rei_shd.g_old_rec.cei_information24, hr_api.g_varchar2) <>
470: nvl(p_rec.cei_information24, hr_api.g_varchar2) or
471: nvl(per_rei_shd.g_old_rec.cei_information25, hr_api.g_varchar2) <>
472: nvl(p_rec.cei_information25, hr_api.g_varchar2) or
473: nvl(per_rei_shd.g_old_rec.cei_information26, hr_api.g_varchar2) <>

Line 470: nvl(p_rec.cei_information24, hr_api.g_varchar2) or

466: nvl(p_rec.cei_information22, hr_api.g_varchar2) or
467: nvl(per_rei_shd.g_old_rec.cei_information23, hr_api.g_varchar2) <>
468: nvl(p_rec.cei_information23, hr_api.g_varchar2) or
469: nvl(per_rei_shd.g_old_rec.cei_information24, hr_api.g_varchar2) <>
470: nvl(p_rec.cei_information24, hr_api.g_varchar2) or
471: nvl(per_rei_shd.g_old_rec.cei_information25, hr_api.g_varchar2) <>
472: nvl(p_rec.cei_information25, hr_api.g_varchar2) or
473: nvl(per_rei_shd.g_old_rec.cei_information26, hr_api.g_varchar2) <>
474: nvl(p_rec.cei_information26, hr_api.g_varchar2) or

Line 471: nvl(per_rei_shd.g_old_rec.cei_information25, hr_api.g_varchar2) <>

467: nvl(per_rei_shd.g_old_rec.cei_information23, hr_api.g_varchar2) <>
468: nvl(p_rec.cei_information23, hr_api.g_varchar2) or
469: nvl(per_rei_shd.g_old_rec.cei_information24, hr_api.g_varchar2) <>
470: nvl(p_rec.cei_information24, hr_api.g_varchar2) or
471: nvl(per_rei_shd.g_old_rec.cei_information25, hr_api.g_varchar2) <>
472: nvl(p_rec.cei_information25, hr_api.g_varchar2) or
473: nvl(per_rei_shd.g_old_rec.cei_information26, hr_api.g_varchar2) <>
474: nvl(p_rec.cei_information26, hr_api.g_varchar2) or
475: nvl(per_rei_shd.g_old_rec.cei_information27, hr_api.g_varchar2) <>

Line 472: nvl(p_rec.cei_information25, hr_api.g_varchar2) or

468: nvl(p_rec.cei_information23, hr_api.g_varchar2) or
469: nvl(per_rei_shd.g_old_rec.cei_information24, hr_api.g_varchar2) <>
470: nvl(p_rec.cei_information24, hr_api.g_varchar2) or
471: nvl(per_rei_shd.g_old_rec.cei_information25, hr_api.g_varchar2) <>
472: nvl(p_rec.cei_information25, hr_api.g_varchar2) or
473: nvl(per_rei_shd.g_old_rec.cei_information26, hr_api.g_varchar2) <>
474: nvl(p_rec.cei_information26, hr_api.g_varchar2) or
475: nvl(per_rei_shd.g_old_rec.cei_information27, hr_api.g_varchar2) <>
476: nvl(p_rec.cei_information27, hr_api.g_varchar2) or

Line 473: nvl(per_rei_shd.g_old_rec.cei_information26, hr_api.g_varchar2) <>

469: nvl(per_rei_shd.g_old_rec.cei_information24, hr_api.g_varchar2) <>
470: nvl(p_rec.cei_information24, hr_api.g_varchar2) or
471: nvl(per_rei_shd.g_old_rec.cei_information25, hr_api.g_varchar2) <>
472: nvl(p_rec.cei_information25, hr_api.g_varchar2) or
473: nvl(per_rei_shd.g_old_rec.cei_information26, hr_api.g_varchar2) <>
474: nvl(p_rec.cei_information26, hr_api.g_varchar2) or
475: nvl(per_rei_shd.g_old_rec.cei_information27, hr_api.g_varchar2) <>
476: nvl(p_rec.cei_information27, hr_api.g_varchar2) or
477: nvl(per_rei_shd.g_old_rec.cei_information28, hr_api.g_varchar2) <>

Line 474: nvl(p_rec.cei_information26, hr_api.g_varchar2) or

470: nvl(p_rec.cei_information24, hr_api.g_varchar2) or
471: nvl(per_rei_shd.g_old_rec.cei_information25, hr_api.g_varchar2) <>
472: nvl(p_rec.cei_information25, hr_api.g_varchar2) or
473: nvl(per_rei_shd.g_old_rec.cei_information26, hr_api.g_varchar2) <>
474: nvl(p_rec.cei_information26, hr_api.g_varchar2) or
475: nvl(per_rei_shd.g_old_rec.cei_information27, hr_api.g_varchar2) <>
476: nvl(p_rec.cei_information27, hr_api.g_varchar2) or
477: nvl(per_rei_shd.g_old_rec.cei_information28, hr_api.g_varchar2) <>
478: nvl(p_rec.cei_information28, hr_api.g_varchar2) or

Line 475: nvl(per_rei_shd.g_old_rec.cei_information27, hr_api.g_varchar2) <>

471: nvl(per_rei_shd.g_old_rec.cei_information25, hr_api.g_varchar2) <>
472: nvl(p_rec.cei_information25, hr_api.g_varchar2) or
473: nvl(per_rei_shd.g_old_rec.cei_information26, hr_api.g_varchar2) <>
474: nvl(p_rec.cei_information26, hr_api.g_varchar2) or
475: nvl(per_rei_shd.g_old_rec.cei_information27, hr_api.g_varchar2) <>
476: nvl(p_rec.cei_information27, hr_api.g_varchar2) or
477: nvl(per_rei_shd.g_old_rec.cei_information28, hr_api.g_varchar2) <>
478: nvl(p_rec.cei_information28, hr_api.g_varchar2) or
479: nvl(per_rei_shd.g_old_rec.cei_information29, hr_api.g_varchar2) <>

Line 476: nvl(p_rec.cei_information27, hr_api.g_varchar2) or

472: nvl(p_rec.cei_information25, hr_api.g_varchar2) or
473: nvl(per_rei_shd.g_old_rec.cei_information26, hr_api.g_varchar2) <>
474: nvl(p_rec.cei_information26, hr_api.g_varchar2) or
475: nvl(per_rei_shd.g_old_rec.cei_information27, hr_api.g_varchar2) <>
476: nvl(p_rec.cei_information27, hr_api.g_varchar2) or
477: nvl(per_rei_shd.g_old_rec.cei_information28, hr_api.g_varchar2) <>
478: nvl(p_rec.cei_information28, hr_api.g_varchar2) or
479: nvl(per_rei_shd.g_old_rec.cei_information29, hr_api.g_varchar2) <>
480: nvl(p_rec.cei_information29, hr_api.g_varchar2) or

Line 477: nvl(per_rei_shd.g_old_rec.cei_information28, hr_api.g_varchar2) <>

473: nvl(per_rei_shd.g_old_rec.cei_information26, hr_api.g_varchar2) <>
474: nvl(p_rec.cei_information26, hr_api.g_varchar2) or
475: nvl(per_rei_shd.g_old_rec.cei_information27, hr_api.g_varchar2) <>
476: nvl(p_rec.cei_information27, hr_api.g_varchar2) or
477: nvl(per_rei_shd.g_old_rec.cei_information28, hr_api.g_varchar2) <>
478: nvl(p_rec.cei_information28, hr_api.g_varchar2) or
479: nvl(per_rei_shd.g_old_rec.cei_information29, hr_api.g_varchar2) <>
480: nvl(p_rec.cei_information29, hr_api.g_varchar2) or
481: nvl(per_rei_shd.g_old_rec.cei_information30, hr_api.g_varchar2) <>

Line 478: nvl(p_rec.cei_information28, hr_api.g_varchar2) or

474: nvl(p_rec.cei_information26, hr_api.g_varchar2) or
475: nvl(per_rei_shd.g_old_rec.cei_information27, hr_api.g_varchar2) <>
476: nvl(p_rec.cei_information27, hr_api.g_varchar2) or
477: nvl(per_rei_shd.g_old_rec.cei_information28, hr_api.g_varchar2) <>
478: nvl(p_rec.cei_information28, hr_api.g_varchar2) or
479: nvl(per_rei_shd.g_old_rec.cei_information29, hr_api.g_varchar2) <>
480: nvl(p_rec.cei_information29, hr_api.g_varchar2) or
481: nvl(per_rei_shd.g_old_rec.cei_information30, hr_api.g_varchar2) <>
482: nvl(p_rec.cei_information30, hr_api.g_varchar2) ))

Line 479: nvl(per_rei_shd.g_old_rec.cei_information29, hr_api.g_varchar2) <>

475: nvl(per_rei_shd.g_old_rec.cei_information27, hr_api.g_varchar2) <>
476: nvl(p_rec.cei_information27, hr_api.g_varchar2) or
477: nvl(per_rei_shd.g_old_rec.cei_information28, hr_api.g_varchar2) <>
478: nvl(p_rec.cei_information28, hr_api.g_varchar2) or
479: nvl(per_rei_shd.g_old_rec.cei_information29, hr_api.g_varchar2) <>
480: nvl(p_rec.cei_information29, hr_api.g_varchar2) or
481: nvl(per_rei_shd.g_old_rec.cei_information30, hr_api.g_varchar2) <>
482: nvl(p_rec.cei_information30, hr_api.g_varchar2) ))
483: or (p_rec.contact_extra_info_id is null) then

Line 480: nvl(p_rec.cei_information29, hr_api.g_varchar2) or

476: nvl(p_rec.cei_information27, hr_api.g_varchar2) or
477: nvl(per_rei_shd.g_old_rec.cei_information28, hr_api.g_varchar2) <>
478: nvl(p_rec.cei_information28, hr_api.g_varchar2) or
479: nvl(per_rei_shd.g_old_rec.cei_information29, hr_api.g_varchar2) <>
480: nvl(p_rec.cei_information29, hr_api.g_varchar2) or
481: nvl(per_rei_shd.g_old_rec.cei_information30, hr_api.g_varchar2) <>
482: nvl(p_rec.cei_information30, hr_api.g_varchar2) ))
483: or (p_rec.contact_extra_info_id is null) then
484: --

Line 481: nvl(per_rei_shd.g_old_rec.cei_information30, hr_api.g_varchar2) <>

477: nvl(per_rei_shd.g_old_rec.cei_information28, hr_api.g_varchar2) <>
478: nvl(p_rec.cei_information28, hr_api.g_varchar2) or
479: nvl(per_rei_shd.g_old_rec.cei_information29, hr_api.g_varchar2) <>
480: nvl(p_rec.cei_information29, hr_api.g_varchar2) or
481: nvl(per_rei_shd.g_old_rec.cei_information30, hr_api.g_varchar2) <>
482: nvl(p_rec.cei_information30, hr_api.g_varchar2) ))
483: or (p_rec.contact_extra_info_id is null) then
484: --
485: -- Only execute the validation if absolutely necessary:

Line 482: nvl(p_rec.cei_information30, hr_api.g_varchar2) ))

478: nvl(p_rec.cei_information28, hr_api.g_varchar2) or
479: nvl(per_rei_shd.g_old_rec.cei_information29, hr_api.g_varchar2) <>
480: nvl(p_rec.cei_information29, hr_api.g_varchar2) or
481: nvl(per_rei_shd.g_old_rec.cei_information30, hr_api.g_varchar2) <>
482: nvl(p_rec.cei_information30, hr_api.g_varchar2) ))
483: or (p_rec.contact_extra_info_id is null) then
484: --
485: -- Only execute the validation if absolutely necessary:
486: -- a) During update, the structure column value or any

Line 600: nvl(per_rei_shd.g_old_rec.cei_attribute_category, hr_api.g_varchar2) <>

596: begin
597: hr_utility.set_location('Entering:'||l_proc,10);
598: --
599: if ((p_rec.contact_extra_info_id is not null) and (
600: nvl(per_rei_shd.g_old_rec.cei_attribute_category, hr_api.g_varchar2) <>
601: nvl(p_rec.cei_attribute_category, hr_api.g_varchar2) or
602: nvl(per_rei_shd.g_old_rec.cei_attribute1, hr_api.g_varchar2) <>
603: nvl(p_rec.cei_attribute1, hr_api.g_varchar2) or
604: nvl(per_rei_shd.g_old_rec.cei_attribute2, hr_api.g_varchar2) <>

Line 601: nvl(p_rec.cei_attribute_category, hr_api.g_varchar2) or

597: hr_utility.set_location('Entering:'||l_proc,10);
598: --
599: if ((p_rec.contact_extra_info_id is not null) and (
600: nvl(per_rei_shd.g_old_rec.cei_attribute_category, hr_api.g_varchar2) <>
601: nvl(p_rec.cei_attribute_category, hr_api.g_varchar2) or
602: nvl(per_rei_shd.g_old_rec.cei_attribute1, hr_api.g_varchar2) <>
603: nvl(p_rec.cei_attribute1, hr_api.g_varchar2) or
604: nvl(per_rei_shd.g_old_rec.cei_attribute2, hr_api.g_varchar2) <>
605: nvl(p_rec.cei_attribute2, hr_api.g_varchar2) or

Line 602: nvl(per_rei_shd.g_old_rec.cei_attribute1, hr_api.g_varchar2) <>

598: --
599: if ((p_rec.contact_extra_info_id is not null) and (
600: nvl(per_rei_shd.g_old_rec.cei_attribute_category, hr_api.g_varchar2) <>
601: nvl(p_rec.cei_attribute_category, hr_api.g_varchar2) or
602: nvl(per_rei_shd.g_old_rec.cei_attribute1, hr_api.g_varchar2) <>
603: nvl(p_rec.cei_attribute1, hr_api.g_varchar2) or
604: nvl(per_rei_shd.g_old_rec.cei_attribute2, hr_api.g_varchar2) <>
605: nvl(p_rec.cei_attribute2, hr_api.g_varchar2) or
606: nvl(per_rei_shd.g_old_rec.cei_attribute3, hr_api.g_varchar2) <>

Line 603: nvl(p_rec.cei_attribute1, hr_api.g_varchar2) or

599: if ((p_rec.contact_extra_info_id is not null) and (
600: nvl(per_rei_shd.g_old_rec.cei_attribute_category, hr_api.g_varchar2) <>
601: nvl(p_rec.cei_attribute_category, hr_api.g_varchar2) or
602: nvl(per_rei_shd.g_old_rec.cei_attribute1, hr_api.g_varchar2) <>
603: nvl(p_rec.cei_attribute1, hr_api.g_varchar2) or
604: nvl(per_rei_shd.g_old_rec.cei_attribute2, hr_api.g_varchar2) <>
605: nvl(p_rec.cei_attribute2, hr_api.g_varchar2) or
606: nvl(per_rei_shd.g_old_rec.cei_attribute3, hr_api.g_varchar2) <>
607: nvl(p_rec.cei_attribute3, hr_api.g_varchar2) or

Line 604: nvl(per_rei_shd.g_old_rec.cei_attribute2, hr_api.g_varchar2) <>

600: nvl(per_rei_shd.g_old_rec.cei_attribute_category, hr_api.g_varchar2) <>
601: nvl(p_rec.cei_attribute_category, hr_api.g_varchar2) or
602: nvl(per_rei_shd.g_old_rec.cei_attribute1, hr_api.g_varchar2) <>
603: nvl(p_rec.cei_attribute1, hr_api.g_varchar2) or
604: nvl(per_rei_shd.g_old_rec.cei_attribute2, hr_api.g_varchar2) <>
605: nvl(p_rec.cei_attribute2, hr_api.g_varchar2) or
606: nvl(per_rei_shd.g_old_rec.cei_attribute3, hr_api.g_varchar2) <>
607: nvl(p_rec.cei_attribute3, hr_api.g_varchar2) or
608: nvl(per_rei_shd.g_old_rec.cei_attribute4, hr_api.g_varchar2) <>

Line 605: nvl(p_rec.cei_attribute2, hr_api.g_varchar2) or

601: nvl(p_rec.cei_attribute_category, hr_api.g_varchar2) or
602: nvl(per_rei_shd.g_old_rec.cei_attribute1, hr_api.g_varchar2) <>
603: nvl(p_rec.cei_attribute1, hr_api.g_varchar2) or
604: nvl(per_rei_shd.g_old_rec.cei_attribute2, hr_api.g_varchar2) <>
605: nvl(p_rec.cei_attribute2, hr_api.g_varchar2) or
606: nvl(per_rei_shd.g_old_rec.cei_attribute3, hr_api.g_varchar2) <>
607: nvl(p_rec.cei_attribute3, hr_api.g_varchar2) or
608: nvl(per_rei_shd.g_old_rec.cei_attribute4, hr_api.g_varchar2) <>
609: nvl(p_rec.cei_attribute4, hr_api.g_varchar2) or

Line 606: nvl(per_rei_shd.g_old_rec.cei_attribute3, hr_api.g_varchar2) <>

602: nvl(per_rei_shd.g_old_rec.cei_attribute1, hr_api.g_varchar2) <>
603: nvl(p_rec.cei_attribute1, hr_api.g_varchar2) or
604: nvl(per_rei_shd.g_old_rec.cei_attribute2, hr_api.g_varchar2) <>
605: nvl(p_rec.cei_attribute2, hr_api.g_varchar2) or
606: nvl(per_rei_shd.g_old_rec.cei_attribute3, hr_api.g_varchar2) <>
607: nvl(p_rec.cei_attribute3, hr_api.g_varchar2) or
608: nvl(per_rei_shd.g_old_rec.cei_attribute4, hr_api.g_varchar2) <>
609: nvl(p_rec.cei_attribute4, hr_api.g_varchar2) or
610: nvl(per_rei_shd.g_old_rec.cei_attribute5, hr_api.g_varchar2) <>

Line 607: nvl(p_rec.cei_attribute3, hr_api.g_varchar2) or

603: nvl(p_rec.cei_attribute1, hr_api.g_varchar2) or
604: nvl(per_rei_shd.g_old_rec.cei_attribute2, hr_api.g_varchar2) <>
605: nvl(p_rec.cei_attribute2, hr_api.g_varchar2) or
606: nvl(per_rei_shd.g_old_rec.cei_attribute3, hr_api.g_varchar2) <>
607: nvl(p_rec.cei_attribute3, hr_api.g_varchar2) or
608: nvl(per_rei_shd.g_old_rec.cei_attribute4, hr_api.g_varchar2) <>
609: nvl(p_rec.cei_attribute4, hr_api.g_varchar2) or
610: nvl(per_rei_shd.g_old_rec.cei_attribute5, hr_api.g_varchar2) <>
611: nvl(p_rec.cei_attribute5, hr_api.g_varchar2) or

Line 608: nvl(per_rei_shd.g_old_rec.cei_attribute4, hr_api.g_varchar2) <>

604: nvl(per_rei_shd.g_old_rec.cei_attribute2, hr_api.g_varchar2) <>
605: nvl(p_rec.cei_attribute2, hr_api.g_varchar2) or
606: nvl(per_rei_shd.g_old_rec.cei_attribute3, hr_api.g_varchar2) <>
607: nvl(p_rec.cei_attribute3, hr_api.g_varchar2) or
608: nvl(per_rei_shd.g_old_rec.cei_attribute4, hr_api.g_varchar2) <>
609: nvl(p_rec.cei_attribute4, hr_api.g_varchar2) or
610: nvl(per_rei_shd.g_old_rec.cei_attribute5, hr_api.g_varchar2) <>
611: nvl(p_rec.cei_attribute5, hr_api.g_varchar2) or
612: nvl(per_rei_shd.g_old_rec.cei_attribute6, hr_api.g_varchar2) <>

Line 609: nvl(p_rec.cei_attribute4, hr_api.g_varchar2) or

605: nvl(p_rec.cei_attribute2, hr_api.g_varchar2) or
606: nvl(per_rei_shd.g_old_rec.cei_attribute3, hr_api.g_varchar2) <>
607: nvl(p_rec.cei_attribute3, hr_api.g_varchar2) or
608: nvl(per_rei_shd.g_old_rec.cei_attribute4, hr_api.g_varchar2) <>
609: nvl(p_rec.cei_attribute4, hr_api.g_varchar2) or
610: nvl(per_rei_shd.g_old_rec.cei_attribute5, hr_api.g_varchar2) <>
611: nvl(p_rec.cei_attribute5, hr_api.g_varchar2) or
612: nvl(per_rei_shd.g_old_rec.cei_attribute6, hr_api.g_varchar2) <>
613: nvl(p_rec.cei_attribute6, hr_api.g_varchar2) or

Line 610: nvl(per_rei_shd.g_old_rec.cei_attribute5, hr_api.g_varchar2) <>

606: nvl(per_rei_shd.g_old_rec.cei_attribute3, hr_api.g_varchar2) <>
607: nvl(p_rec.cei_attribute3, hr_api.g_varchar2) or
608: nvl(per_rei_shd.g_old_rec.cei_attribute4, hr_api.g_varchar2) <>
609: nvl(p_rec.cei_attribute4, hr_api.g_varchar2) or
610: nvl(per_rei_shd.g_old_rec.cei_attribute5, hr_api.g_varchar2) <>
611: nvl(p_rec.cei_attribute5, hr_api.g_varchar2) or
612: nvl(per_rei_shd.g_old_rec.cei_attribute6, hr_api.g_varchar2) <>
613: nvl(p_rec.cei_attribute6, hr_api.g_varchar2) or
614: nvl(per_rei_shd.g_old_rec.cei_attribute7, hr_api.g_varchar2) <>

Line 611: nvl(p_rec.cei_attribute5, hr_api.g_varchar2) or

607: nvl(p_rec.cei_attribute3, hr_api.g_varchar2) or
608: nvl(per_rei_shd.g_old_rec.cei_attribute4, hr_api.g_varchar2) <>
609: nvl(p_rec.cei_attribute4, hr_api.g_varchar2) or
610: nvl(per_rei_shd.g_old_rec.cei_attribute5, hr_api.g_varchar2) <>
611: nvl(p_rec.cei_attribute5, hr_api.g_varchar2) or
612: nvl(per_rei_shd.g_old_rec.cei_attribute6, hr_api.g_varchar2) <>
613: nvl(p_rec.cei_attribute6, hr_api.g_varchar2) or
614: nvl(per_rei_shd.g_old_rec.cei_attribute7, hr_api.g_varchar2) <>
615: nvl(p_rec.cei_attribute7, hr_api.g_varchar2) or

Line 612: nvl(per_rei_shd.g_old_rec.cei_attribute6, hr_api.g_varchar2) <>

608: nvl(per_rei_shd.g_old_rec.cei_attribute4, hr_api.g_varchar2) <>
609: nvl(p_rec.cei_attribute4, hr_api.g_varchar2) or
610: nvl(per_rei_shd.g_old_rec.cei_attribute5, hr_api.g_varchar2) <>
611: nvl(p_rec.cei_attribute5, hr_api.g_varchar2) or
612: nvl(per_rei_shd.g_old_rec.cei_attribute6, hr_api.g_varchar2) <>
613: nvl(p_rec.cei_attribute6, hr_api.g_varchar2) or
614: nvl(per_rei_shd.g_old_rec.cei_attribute7, hr_api.g_varchar2) <>
615: nvl(p_rec.cei_attribute7, hr_api.g_varchar2) or
616: nvl(per_rei_shd.g_old_rec.cei_attribute8, hr_api.g_varchar2) <>

Line 613: nvl(p_rec.cei_attribute6, hr_api.g_varchar2) or

609: nvl(p_rec.cei_attribute4, hr_api.g_varchar2) or
610: nvl(per_rei_shd.g_old_rec.cei_attribute5, hr_api.g_varchar2) <>
611: nvl(p_rec.cei_attribute5, hr_api.g_varchar2) or
612: nvl(per_rei_shd.g_old_rec.cei_attribute6, hr_api.g_varchar2) <>
613: nvl(p_rec.cei_attribute6, hr_api.g_varchar2) or
614: nvl(per_rei_shd.g_old_rec.cei_attribute7, hr_api.g_varchar2) <>
615: nvl(p_rec.cei_attribute7, hr_api.g_varchar2) or
616: nvl(per_rei_shd.g_old_rec.cei_attribute8, hr_api.g_varchar2) <>
617: nvl(p_rec.cei_attribute8, hr_api.g_varchar2) or

Line 614: nvl(per_rei_shd.g_old_rec.cei_attribute7, hr_api.g_varchar2) <>

610: nvl(per_rei_shd.g_old_rec.cei_attribute5, hr_api.g_varchar2) <>
611: nvl(p_rec.cei_attribute5, hr_api.g_varchar2) or
612: nvl(per_rei_shd.g_old_rec.cei_attribute6, hr_api.g_varchar2) <>
613: nvl(p_rec.cei_attribute6, hr_api.g_varchar2) or
614: nvl(per_rei_shd.g_old_rec.cei_attribute7, hr_api.g_varchar2) <>
615: nvl(p_rec.cei_attribute7, hr_api.g_varchar2) or
616: nvl(per_rei_shd.g_old_rec.cei_attribute8, hr_api.g_varchar2) <>
617: nvl(p_rec.cei_attribute8, hr_api.g_varchar2) or
618: nvl(per_rei_shd.g_old_rec.cei_attribute9, hr_api.g_varchar2) <>

Line 615: nvl(p_rec.cei_attribute7, hr_api.g_varchar2) or

611: nvl(p_rec.cei_attribute5, hr_api.g_varchar2) or
612: nvl(per_rei_shd.g_old_rec.cei_attribute6, hr_api.g_varchar2) <>
613: nvl(p_rec.cei_attribute6, hr_api.g_varchar2) or
614: nvl(per_rei_shd.g_old_rec.cei_attribute7, hr_api.g_varchar2) <>
615: nvl(p_rec.cei_attribute7, hr_api.g_varchar2) or
616: nvl(per_rei_shd.g_old_rec.cei_attribute8, hr_api.g_varchar2) <>
617: nvl(p_rec.cei_attribute8, hr_api.g_varchar2) or
618: nvl(per_rei_shd.g_old_rec.cei_attribute9, hr_api.g_varchar2) <>
619: nvl(p_rec.cei_attribute9, hr_api.g_varchar2) or

Line 616: nvl(per_rei_shd.g_old_rec.cei_attribute8, hr_api.g_varchar2) <>

612: nvl(per_rei_shd.g_old_rec.cei_attribute6, hr_api.g_varchar2) <>
613: nvl(p_rec.cei_attribute6, hr_api.g_varchar2) or
614: nvl(per_rei_shd.g_old_rec.cei_attribute7, hr_api.g_varchar2) <>
615: nvl(p_rec.cei_attribute7, hr_api.g_varchar2) or
616: nvl(per_rei_shd.g_old_rec.cei_attribute8, hr_api.g_varchar2) <>
617: nvl(p_rec.cei_attribute8, hr_api.g_varchar2) or
618: nvl(per_rei_shd.g_old_rec.cei_attribute9, hr_api.g_varchar2) <>
619: nvl(p_rec.cei_attribute9, hr_api.g_varchar2) or
620: nvl(per_rei_shd.g_old_rec.cei_attribute10, hr_api.g_varchar2) <>

Line 617: nvl(p_rec.cei_attribute8, hr_api.g_varchar2) or

613: nvl(p_rec.cei_attribute6, hr_api.g_varchar2) or
614: nvl(per_rei_shd.g_old_rec.cei_attribute7, hr_api.g_varchar2) <>
615: nvl(p_rec.cei_attribute7, hr_api.g_varchar2) or
616: nvl(per_rei_shd.g_old_rec.cei_attribute8, hr_api.g_varchar2) <>
617: nvl(p_rec.cei_attribute8, hr_api.g_varchar2) or
618: nvl(per_rei_shd.g_old_rec.cei_attribute9, hr_api.g_varchar2) <>
619: nvl(p_rec.cei_attribute9, hr_api.g_varchar2) or
620: nvl(per_rei_shd.g_old_rec.cei_attribute10, hr_api.g_varchar2) <>
621: nvl(p_rec.cei_attribute10, hr_api.g_varchar2) or

Line 618: nvl(per_rei_shd.g_old_rec.cei_attribute9, hr_api.g_varchar2) <>

614: nvl(per_rei_shd.g_old_rec.cei_attribute7, hr_api.g_varchar2) <>
615: nvl(p_rec.cei_attribute7, hr_api.g_varchar2) or
616: nvl(per_rei_shd.g_old_rec.cei_attribute8, hr_api.g_varchar2) <>
617: nvl(p_rec.cei_attribute8, hr_api.g_varchar2) or
618: nvl(per_rei_shd.g_old_rec.cei_attribute9, hr_api.g_varchar2) <>
619: nvl(p_rec.cei_attribute9, hr_api.g_varchar2) or
620: nvl(per_rei_shd.g_old_rec.cei_attribute10, hr_api.g_varchar2) <>
621: nvl(p_rec.cei_attribute10, hr_api.g_varchar2) or
622: nvl(per_rei_shd.g_old_rec.cei_attribute11, hr_api.g_varchar2) <>

Line 619: nvl(p_rec.cei_attribute9, hr_api.g_varchar2) or

615: nvl(p_rec.cei_attribute7, hr_api.g_varchar2) or
616: nvl(per_rei_shd.g_old_rec.cei_attribute8, hr_api.g_varchar2) <>
617: nvl(p_rec.cei_attribute8, hr_api.g_varchar2) or
618: nvl(per_rei_shd.g_old_rec.cei_attribute9, hr_api.g_varchar2) <>
619: nvl(p_rec.cei_attribute9, hr_api.g_varchar2) or
620: nvl(per_rei_shd.g_old_rec.cei_attribute10, hr_api.g_varchar2) <>
621: nvl(p_rec.cei_attribute10, hr_api.g_varchar2) or
622: nvl(per_rei_shd.g_old_rec.cei_attribute11, hr_api.g_varchar2) <>
623: nvl(p_rec.cei_attribute11, hr_api.g_varchar2) or

Line 620: nvl(per_rei_shd.g_old_rec.cei_attribute10, hr_api.g_varchar2) <>

616: nvl(per_rei_shd.g_old_rec.cei_attribute8, hr_api.g_varchar2) <>
617: nvl(p_rec.cei_attribute8, hr_api.g_varchar2) or
618: nvl(per_rei_shd.g_old_rec.cei_attribute9, hr_api.g_varchar2) <>
619: nvl(p_rec.cei_attribute9, hr_api.g_varchar2) or
620: nvl(per_rei_shd.g_old_rec.cei_attribute10, hr_api.g_varchar2) <>
621: nvl(p_rec.cei_attribute10, hr_api.g_varchar2) or
622: nvl(per_rei_shd.g_old_rec.cei_attribute11, hr_api.g_varchar2) <>
623: nvl(p_rec.cei_attribute11, hr_api.g_varchar2) or
624: nvl(per_rei_shd.g_old_rec.cei_attribute12, hr_api.g_varchar2) <>

Line 621: nvl(p_rec.cei_attribute10, hr_api.g_varchar2) or

617: nvl(p_rec.cei_attribute8, hr_api.g_varchar2) or
618: nvl(per_rei_shd.g_old_rec.cei_attribute9, hr_api.g_varchar2) <>
619: nvl(p_rec.cei_attribute9, hr_api.g_varchar2) or
620: nvl(per_rei_shd.g_old_rec.cei_attribute10, hr_api.g_varchar2) <>
621: nvl(p_rec.cei_attribute10, hr_api.g_varchar2) or
622: nvl(per_rei_shd.g_old_rec.cei_attribute11, hr_api.g_varchar2) <>
623: nvl(p_rec.cei_attribute11, hr_api.g_varchar2) or
624: nvl(per_rei_shd.g_old_rec.cei_attribute12, hr_api.g_varchar2) <>
625: nvl(p_rec.cei_attribute12, hr_api.g_varchar2) or

Line 622: nvl(per_rei_shd.g_old_rec.cei_attribute11, hr_api.g_varchar2) <>

618: nvl(per_rei_shd.g_old_rec.cei_attribute9, hr_api.g_varchar2) <>
619: nvl(p_rec.cei_attribute9, hr_api.g_varchar2) or
620: nvl(per_rei_shd.g_old_rec.cei_attribute10, hr_api.g_varchar2) <>
621: nvl(p_rec.cei_attribute10, hr_api.g_varchar2) or
622: nvl(per_rei_shd.g_old_rec.cei_attribute11, hr_api.g_varchar2) <>
623: nvl(p_rec.cei_attribute11, hr_api.g_varchar2) or
624: nvl(per_rei_shd.g_old_rec.cei_attribute12, hr_api.g_varchar2) <>
625: nvl(p_rec.cei_attribute12, hr_api.g_varchar2) or
626: nvl(per_rei_shd.g_old_rec.cei_attribute13, hr_api.g_varchar2) <>

Line 623: nvl(p_rec.cei_attribute11, hr_api.g_varchar2) or

619: nvl(p_rec.cei_attribute9, hr_api.g_varchar2) or
620: nvl(per_rei_shd.g_old_rec.cei_attribute10, hr_api.g_varchar2) <>
621: nvl(p_rec.cei_attribute10, hr_api.g_varchar2) or
622: nvl(per_rei_shd.g_old_rec.cei_attribute11, hr_api.g_varchar2) <>
623: nvl(p_rec.cei_attribute11, hr_api.g_varchar2) or
624: nvl(per_rei_shd.g_old_rec.cei_attribute12, hr_api.g_varchar2) <>
625: nvl(p_rec.cei_attribute12, hr_api.g_varchar2) or
626: nvl(per_rei_shd.g_old_rec.cei_attribute13, hr_api.g_varchar2) <>
627: nvl(p_rec.cei_attribute13, hr_api.g_varchar2) or

Line 624: nvl(per_rei_shd.g_old_rec.cei_attribute12, hr_api.g_varchar2) <>

620: nvl(per_rei_shd.g_old_rec.cei_attribute10, hr_api.g_varchar2) <>
621: nvl(p_rec.cei_attribute10, hr_api.g_varchar2) or
622: nvl(per_rei_shd.g_old_rec.cei_attribute11, hr_api.g_varchar2) <>
623: nvl(p_rec.cei_attribute11, hr_api.g_varchar2) or
624: nvl(per_rei_shd.g_old_rec.cei_attribute12, hr_api.g_varchar2) <>
625: nvl(p_rec.cei_attribute12, hr_api.g_varchar2) or
626: nvl(per_rei_shd.g_old_rec.cei_attribute13, hr_api.g_varchar2) <>
627: nvl(p_rec.cei_attribute13, hr_api.g_varchar2) or
628: nvl(per_rei_shd.g_old_rec.cei_attribute14, hr_api.g_varchar2) <>

Line 625: nvl(p_rec.cei_attribute12, hr_api.g_varchar2) or

621: nvl(p_rec.cei_attribute10, hr_api.g_varchar2) or
622: nvl(per_rei_shd.g_old_rec.cei_attribute11, hr_api.g_varchar2) <>
623: nvl(p_rec.cei_attribute11, hr_api.g_varchar2) or
624: nvl(per_rei_shd.g_old_rec.cei_attribute12, hr_api.g_varchar2) <>
625: nvl(p_rec.cei_attribute12, hr_api.g_varchar2) or
626: nvl(per_rei_shd.g_old_rec.cei_attribute13, hr_api.g_varchar2) <>
627: nvl(p_rec.cei_attribute13, hr_api.g_varchar2) or
628: nvl(per_rei_shd.g_old_rec.cei_attribute14, hr_api.g_varchar2) <>
629: nvl(p_rec.cei_attribute14, hr_api.g_varchar2) or

Line 626: nvl(per_rei_shd.g_old_rec.cei_attribute13, hr_api.g_varchar2) <>

622: nvl(per_rei_shd.g_old_rec.cei_attribute11, hr_api.g_varchar2) <>
623: nvl(p_rec.cei_attribute11, hr_api.g_varchar2) or
624: nvl(per_rei_shd.g_old_rec.cei_attribute12, hr_api.g_varchar2) <>
625: nvl(p_rec.cei_attribute12, hr_api.g_varchar2) or
626: nvl(per_rei_shd.g_old_rec.cei_attribute13, hr_api.g_varchar2) <>
627: nvl(p_rec.cei_attribute13, hr_api.g_varchar2) or
628: nvl(per_rei_shd.g_old_rec.cei_attribute14, hr_api.g_varchar2) <>
629: nvl(p_rec.cei_attribute14, hr_api.g_varchar2) or
630: nvl(per_rei_shd.g_old_rec.cei_attribute15, hr_api.g_varchar2) <>

Line 627: nvl(p_rec.cei_attribute13, hr_api.g_varchar2) or

623: nvl(p_rec.cei_attribute11, hr_api.g_varchar2) or
624: nvl(per_rei_shd.g_old_rec.cei_attribute12, hr_api.g_varchar2) <>
625: nvl(p_rec.cei_attribute12, hr_api.g_varchar2) or
626: nvl(per_rei_shd.g_old_rec.cei_attribute13, hr_api.g_varchar2) <>
627: nvl(p_rec.cei_attribute13, hr_api.g_varchar2) or
628: nvl(per_rei_shd.g_old_rec.cei_attribute14, hr_api.g_varchar2) <>
629: nvl(p_rec.cei_attribute14, hr_api.g_varchar2) or
630: nvl(per_rei_shd.g_old_rec.cei_attribute15, hr_api.g_varchar2) <>
631: nvl(p_rec.cei_attribute15, hr_api.g_varchar2) or

Line 628: nvl(per_rei_shd.g_old_rec.cei_attribute14, hr_api.g_varchar2) <>

624: nvl(per_rei_shd.g_old_rec.cei_attribute12, hr_api.g_varchar2) <>
625: nvl(p_rec.cei_attribute12, hr_api.g_varchar2) or
626: nvl(per_rei_shd.g_old_rec.cei_attribute13, hr_api.g_varchar2) <>
627: nvl(p_rec.cei_attribute13, hr_api.g_varchar2) or
628: nvl(per_rei_shd.g_old_rec.cei_attribute14, hr_api.g_varchar2) <>
629: nvl(p_rec.cei_attribute14, hr_api.g_varchar2) or
630: nvl(per_rei_shd.g_old_rec.cei_attribute15, hr_api.g_varchar2) <>
631: nvl(p_rec.cei_attribute15, hr_api.g_varchar2) or
632: nvl(per_rei_shd.g_old_rec.cei_attribute16, hr_api.g_varchar2) <>

Line 629: nvl(p_rec.cei_attribute14, hr_api.g_varchar2) or

625: nvl(p_rec.cei_attribute12, hr_api.g_varchar2) or
626: nvl(per_rei_shd.g_old_rec.cei_attribute13, hr_api.g_varchar2) <>
627: nvl(p_rec.cei_attribute13, hr_api.g_varchar2) or
628: nvl(per_rei_shd.g_old_rec.cei_attribute14, hr_api.g_varchar2) <>
629: nvl(p_rec.cei_attribute14, hr_api.g_varchar2) or
630: nvl(per_rei_shd.g_old_rec.cei_attribute15, hr_api.g_varchar2) <>
631: nvl(p_rec.cei_attribute15, hr_api.g_varchar2) or
632: nvl(per_rei_shd.g_old_rec.cei_attribute16, hr_api.g_varchar2) <>
633: nvl(p_rec.cei_attribute16, hr_api.g_varchar2) or

Line 630: nvl(per_rei_shd.g_old_rec.cei_attribute15, hr_api.g_varchar2) <>

626: nvl(per_rei_shd.g_old_rec.cei_attribute13, hr_api.g_varchar2) <>
627: nvl(p_rec.cei_attribute13, hr_api.g_varchar2) or
628: nvl(per_rei_shd.g_old_rec.cei_attribute14, hr_api.g_varchar2) <>
629: nvl(p_rec.cei_attribute14, hr_api.g_varchar2) or
630: nvl(per_rei_shd.g_old_rec.cei_attribute15, hr_api.g_varchar2) <>
631: nvl(p_rec.cei_attribute15, hr_api.g_varchar2) or
632: nvl(per_rei_shd.g_old_rec.cei_attribute16, hr_api.g_varchar2) <>
633: nvl(p_rec.cei_attribute16, hr_api.g_varchar2) or
634: nvl(per_rei_shd.g_old_rec.cei_attribute17, hr_api.g_varchar2) <>

Line 631: nvl(p_rec.cei_attribute15, hr_api.g_varchar2) or

627: nvl(p_rec.cei_attribute13, hr_api.g_varchar2) or
628: nvl(per_rei_shd.g_old_rec.cei_attribute14, hr_api.g_varchar2) <>
629: nvl(p_rec.cei_attribute14, hr_api.g_varchar2) or
630: nvl(per_rei_shd.g_old_rec.cei_attribute15, hr_api.g_varchar2) <>
631: nvl(p_rec.cei_attribute15, hr_api.g_varchar2) or
632: nvl(per_rei_shd.g_old_rec.cei_attribute16, hr_api.g_varchar2) <>
633: nvl(p_rec.cei_attribute16, hr_api.g_varchar2) or
634: nvl(per_rei_shd.g_old_rec.cei_attribute17, hr_api.g_varchar2) <>
635: nvl(p_rec.cei_attribute17, hr_api.g_varchar2) or

Line 632: nvl(per_rei_shd.g_old_rec.cei_attribute16, hr_api.g_varchar2) <>

628: nvl(per_rei_shd.g_old_rec.cei_attribute14, hr_api.g_varchar2) <>
629: nvl(p_rec.cei_attribute14, hr_api.g_varchar2) or
630: nvl(per_rei_shd.g_old_rec.cei_attribute15, hr_api.g_varchar2) <>
631: nvl(p_rec.cei_attribute15, hr_api.g_varchar2) or
632: nvl(per_rei_shd.g_old_rec.cei_attribute16, hr_api.g_varchar2) <>
633: nvl(p_rec.cei_attribute16, hr_api.g_varchar2) or
634: nvl(per_rei_shd.g_old_rec.cei_attribute17, hr_api.g_varchar2) <>
635: nvl(p_rec.cei_attribute17, hr_api.g_varchar2) or
636: nvl(per_rei_shd.g_old_rec.cei_attribute18, hr_api.g_varchar2) <>

Line 633: nvl(p_rec.cei_attribute16, hr_api.g_varchar2) or

629: nvl(p_rec.cei_attribute14, hr_api.g_varchar2) or
630: nvl(per_rei_shd.g_old_rec.cei_attribute15, hr_api.g_varchar2) <>
631: nvl(p_rec.cei_attribute15, hr_api.g_varchar2) or
632: nvl(per_rei_shd.g_old_rec.cei_attribute16, hr_api.g_varchar2) <>
633: nvl(p_rec.cei_attribute16, hr_api.g_varchar2) or
634: nvl(per_rei_shd.g_old_rec.cei_attribute17, hr_api.g_varchar2) <>
635: nvl(p_rec.cei_attribute17, hr_api.g_varchar2) or
636: nvl(per_rei_shd.g_old_rec.cei_attribute18, hr_api.g_varchar2) <>
637: nvl(p_rec.cei_attribute18, hr_api.g_varchar2) or

Line 634: nvl(per_rei_shd.g_old_rec.cei_attribute17, hr_api.g_varchar2) <>

630: nvl(per_rei_shd.g_old_rec.cei_attribute15, hr_api.g_varchar2) <>
631: nvl(p_rec.cei_attribute15, hr_api.g_varchar2) or
632: nvl(per_rei_shd.g_old_rec.cei_attribute16, hr_api.g_varchar2) <>
633: nvl(p_rec.cei_attribute16, hr_api.g_varchar2) or
634: nvl(per_rei_shd.g_old_rec.cei_attribute17, hr_api.g_varchar2) <>
635: nvl(p_rec.cei_attribute17, hr_api.g_varchar2) or
636: nvl(per_rei_shd.g_old_rec.cei_attribute18, hr_api.g_varchar2) <>
637: nvl(p_rec.cei_attribute18, hr_api.g_varchar2) or
638: nvl(per_rei_shd.g_old_rec.cei_attribute19, hr_api.g_varchar2) <>

Line 635: nvl(p_rec.cei_attribute17, hr_api.g_varchar2) or

631: nvl(p_rec.cei_attribute15, hr_api.g_varchar2) or
632: nvl(per_rei_shd.g_old_rec.cei_attribute16, hr_api.g_varchar2) <>
633: nvl(p_rec.cei_attribute16, hr_api.g_varchar2) or
634: nvl(per_rei_shd.g_old_rec.cei_attribute17, hr_api.g_varchar2) <>
635: nvl(p_rec.cei_attribute17, hr_api.g_varchar2) or
636: nvl(per_rei_shd.g_old_rec.cei_attribute18, hr_api.g_varchar2) <>
637: nvl(p_rec.cei_attribute18, hr_api.g_varchar2) or
638: nvl(per_rei_shd.g_old_rec.cei_attribute19, hr_api.g_varchar2) <>
639: nvl(p_rec.cei_attribute19, hr_api.g_varchar2) or

Line 636: nvl(per_rei_shd.g_old_rec.cei_attribute18, hr_api.g_varchar2) <>

632: nvl(per_rei_shd.g_old_rec.cei_attribute16, hr_api.g_varchar2) <>
633: nvl(p_rec.cei_attribute16, hr_api.g_varchar2) or
634: nvl(per_rei_shd.g_old_rec.cei_attribute17, hr_api.g_varchar2) <>
635: nvl(p_rec.cei_attribute17, hr_api.g_varchar2) or
636: nvl(per_rei_shd.g_old_rec.cei_attribute18, hr_api.g_varchar2) <>
637: nvl(p_rec.cei_attribute18, hr_api.g_varchar2) or
638: nvl(per_rei_shd.g_old_rec.cei_attribute19, hr_api.g_varchar2) <>
639: nvl(p_rec.cei_attribute19, hr_api.g_varchar2) or
640: nvl(per_rei_shd.g_old_rec.cei_attribute20, hr_api.g_varchar2) <>

Line 637: nvl(p_rec.cei_attribute18, hr_api.g_varchar2) or

633: nvl(p_rec.cei_attribute16, hr_api.g_varchar2) or
634: nvl(per_rei_shd.g_old_rec.cei_attribute17, hr_api.g_varchar2) <>
635: nvl(p_rec.cei_attribute17, hr_api.g_varchar2) or
636: nvl(per_rei_shd.g_old_rec.cei_attribute18, hr_api.g_varchar2) <>
637: nvl(p_rec.cei_attribute18, hr_api.g_varchar2) or
638: nvl(per_rei_shd.g_old_rec.cei_attribute19, hr_api.g_varchar2) <>
639: nvl(p_rec.cei_attribute19, hr_api.g_varchar2) or
640: nvl(per_rei_shd.g_old_rec.cei_attribute20, hr_api.g_varchar2) <>
641: nvl(p_rec.cei_attribute20, hr_api.g_varchar2) ))

Line 638: nvl(per_rei_shd.g_old_rec.cei_attribute19, hr_api.g_varchar2) <>

634: nvl(per_rei_shd.g_old_rec.cei_attribute17, hr_api.g_varchar2) <>
635: nvl(p_rec.cei_attribute17, hr_api.g_varchar2) or
636: nvl(per_rei_shd.g_old_rec.cei_attribute18, hr_api.g_varchar2) <>
637: nvl(p_rec.cei_attribute18, hr_api.g_varchar2) or
638: nvl(per_rei_shd.g_old_rec.cei_attribute19, hr_api.g_varchar2) <>
639: nvl(p_rec.cei_attribute19, hr_api.g_varchar2) or
640: nvl(per_rei_shd.g_old_rec.cei_attribute20, hr_api.g_varchar2) <>
641: nvl(p_rec.cei_attribute20, hr_api.g_varchar2) ))
642: or (p_rec.contact_extra_info_id is null) then

Line 639: nvl(p_rec.cei_attribute19, hr_api.g_varchar2) or

635: nvl(p_rec.cei_attribute17, hr_api.g_varchar2) or
636: nvl(per_rei_shd.g_old_rec.cei_attribute18, hr_api.g_varchar2) <>
637: nvl(p_rec.cei_attribute18, hr_api.g_varchar2) or
638: nvl(per_rei_shd.g_old_rec.cei_attribute19, hr_api.g_varchar2) <>
639: nvl(p_rec.cei_attribute19, hr_api.g_varchar2) or
640: nvl(per_rei_shd.g_old_rec.cei_attribute20, hr_api.g_varchar2) <>
641: nvl(p_rec.cei_attribute20, hr_api.g_varchar2) ))
642: or (p_rec.contact_extra_info_id is null) then
643: --

Line 640: nvl(per_rei_shd.g_old_rec.cei_attribute20, hr_api.g_varchar2) <>

636: nvl(per_rei_shd.g_old_rec.cei_attribute18, hr_api.g_varchar2) <>
637: nvl(p_rec.cei_attribute18, hr_api.g_varchar2) or
638: nvl(per_rei_shd.g_old_rec.cei_attribute19, hr_api.g_varchar2) <>
639: nvl(p_rec.cei_attribute19, hr_api.g_varchar2) or
640: nvl(per_rei_shd.g_old_rec.cei_attribute20, hr_api.g_varchar2) <>
641: nvl(p_rec.cei_attribute20, hr_api.g_varchar2) ))
642: or (p_rec.contact_extra_info_id is null) then
643: --
644: -- Only execute the validation if absolutely necessary:

Line 641: nvl(p_rec.cei_attribute20, hr_api.g_varchar2) ))

637: nvl(p_rec.cei_attribute18, hr_api.g_varchar2) or
638: nvl(per_rei_shd.g_old_rec.cei_attribute19, hr_api.g_varchar2) <>
639: nvl(p_rec.cei_attribute19, hr_api.g_varchar2) or
640: nvl(per_rei_shd.g_old_rec.cei_attribute20, hr_api.g_varchar2) <>
641: nvl(p_rec.cei_attribute20, hr_api.g_varchar2) ))
642: or (p_rec.contact_extra_info_id is null) then
643: --
644: -- Only execute the validation if absolutely necessary:
645: -- a) During update, the structure column value or any

Line 758: IF NVL(p_rec.contact_relationship_id, hr_api.g_number) <>

754: -- Check if contact_relationship_id is updated.
755: -- Raise an error when contact_relationship_id is updated.
756: --
757: hr_utility.set_location(l_proc, 20);
758: IF NVL(p_rec.contact_relationship_id, hr_api.g_number) <>
759: NVL(per_rei_shd.g_old_rec.contact_relationship_id, hr_api.g_number) THEN
760: --
761: l_argument := 'contact_relationship_id';
762: RAISE l_error;

Line 759: NVL(per_rei_shd.g_old_rec.contact_relationship_id, hr_api.g_number) THEN

755: -- Raise an error when contact_relationship_id is updated.
756: --
757: hr_utility.set_location(l_proc, 20);
758: IF NVL(p_rec.contact_relationship_id, hr_api.g_number) <>
759: NVL(per_rei_shd.g_old_rec.contact_relationship_id, hr_api.g_number) THEN
760: --
761: l_argument := 'contact_relationship_id';
762: RAISE l_error;
763: END IF;

Line 769: IF NVL(p_rec.information_type, hr_api.g_varchar2) <>

765: -- Check if information_type is updated.
766: -- Raise an error when information_type is updated.
767: --
768: hr_utility.set_location(l_proc, 30);
769: IF NVL(p_rec.information_type, hr_api.g_varchar2) <>
770: NVL(per_rei_shd.g_old_rec.information_type, hr_api.g_varchar2) THEN
771: --
772: l_argument := 'information_type';
773: RAISE l_error;

Line 770: NVL(per_rei_shd.g_old_rec.information_type, hr_api.g_varchar2) THEN

766: -- Raise an error when information_type is updated.
767: --
768: hr_utility.set_location(l_proc, 30);
769: IF NVL(p_rec.information_type, hr_api.g_varchar2) <>
770: NVL(per_rei_shd.g_old_rec.information_type, hr_api.g_varchar2) THEN
771: --
772: l_argument := 'information_type';
773: RAISE l_error;
774: END IF;

Line 780: IF NVL(p_rec.cei_information_category, hr_api.g_varchar2) <>

776: -- Check if cei_information_category is updated.
777: -- Raise an error when information_type is updated.
778: --
779: hr_utility.set_location(l_proc, 40);
780: IF NVL(p_rec.cei_information_category, hr_api.g_varchar2) <>
781: NVL(per_rei_shd.g_old_rec.cei_information_category, hr_api.g_varchar2) THEN
782: --
783: l_argument := 'cei_information_category';
784: RAISE l_error;

Line 781: NVL(per_rei_shd.g_old_rec.cei_information_category, hr_api.g_varchar2) THEN

777: -- Raise an error when information_type is updated.
778: --
779: hr_utility.set_location(l_proc, 40);
780: IF NVL(p_rec.cei_information_category, hr_api.g_varchar2) <>
781: NVL(per_rei_shd.g_old_rec.cei_information_category, hr_api.g_varchar2) THEN
782: --
783: l_argument := 'cei_information_category';
784: RAISE l_error;
785: END IF;

Line 792: hr_api.argument_changed_error(

788: EXCEPTION
789: WHEN l_error THEN
790: hr_utility.set_location(l_proc, 60);
791: --
792: hr_api.argument_changed_error(
793: p_api_name => l_proc,
794: p_argument => l_argument);
795: WHEN OTHERS THEN
796: hr_utility.set_location(l_proc, 70);

Line 842: hr_api.mandatory_arg_error

838: Begin
839: --
840: -- Ensure that the p_datetrack_mode argument is not null
841: --
842: hr_api.mandatory_arg_error
843: (p_api_name => l_proc
844: ,p_argument => 'datetrack_mode'
845: ,p_argument_value => p_datetrack_mode
846: );

Line 852: hr_api.mandatory_arg_error

848: -- Mode will be valid, as this is checked at the start of the upd.
849: --
850: -- Ensure the arguments are not null
851: --
852: hr_api.mandatory_arg_error
853: (p_api_name => l_proc
854: ,p_argument => 'validation_start_date'
855: ,p_argument_value => p_validation_start_date
856: );

Line 858: hr_api.mandatory_arg_error

854: ,p_argument => 'validation_start_date'
855: ,p_argument_value => p_validation_start_date
856: );
857: --
858: hr_api.mandatory_arg_error
859: (p_api_name => l_proc
860: ,p_argument => 'validation_end_date'
861: ,p_argument_value => p_validation_end_date
862: );

Line 926: hr_api.mandatory_arg_error

922: Begin
923: --
924: -- Ensure that the p_datetrack_mode argument is not null
925: --
926: hr_api.mandatory_arg_error
927: (p_api_name => l_proc
928: ,p_argument => 'datetrack_mode'
929: ,p_argument_value => p_datetrack_mode
930: );

Line 935: If (p_datetrack_mode = hr_api.g_delete or

931: --
932: -- Only perform the validation if the datetrack mode is either
933: -- DELETE or ZAP
934: --
935: If (p_datetrack_mode = hr_api.g_delete or
936: p_datetrack_mode = hr_api.g_zap) then
937: --
938: --
939: -- Ensure the arguments are not null

Line 936: p_datetrack_mode = hr_api.g_zap) then

932: -- Only perform the validation if the datetrack mode is either
933: -- DELETE or ZAP
934: --
935: If (p_datetrack_mode = hr_api.g_delete or
936: p_datetrack_mode = hr_api.g_zap) then
937: --
938: --
939: -- Ensure the arguments are not null
940: --

Line 941: hr_api.mandatory_arg_error

937: --
938: --
939: -- Ensure the arguments are not null
940: --
941: hr_api.mandatory_arg_error
942: (p_api_name => l_proc
943: ,p_argument => 'validation_start_date'
944: ,p_argument_value => p_validation_start_date
945: );

Line 947: hr_api.mandatory_arg_error

943: ,p_argument => 'validation_start_date'
944: ,p_argument_value => p_validation_start_date
945: );
946: --
947: hr_api.mandatory_arg_error
948: (p_api_name => l_proc
949: ,p_argument => 'validation_end_date'
950: ,p_argument_value => p_validation_end_date
951: );

Line 953: hr_api.mandatory_arg_error

949: ,p_argument => 'validation_end_date'
950: ,p_argument_value => p_validation_end_date
951: );
952: --
953: hr_api.mandatory_arg_error
954: (p_api_name => l_proc
955: ,p_argument => 'contact_extra_info_id'
956: ,p_argument_value => p_contact_extra_info_id
957: );