eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_PPS_BUS dependencies on HR_API

Line 47: hr_api.mandatory_arg_error

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

Line 74: hr_api.set_security_group_id

70: close csr_sec_grp;
71: --
72: -- Set the security_group_id in CLIENT_INFO
73: --
74: hr_api.set_security_group_id
75: (p_security_group_id => l_security_group_id
76: );
77: --
78: -- Set the sessions legislation context in HR_SESSION_DATA

Line 80: hr_api.set_legislation_context(l_legislation_code);

76: );
77: --
78: -- Set the sessions legislation context in HR_SESSION_DATA
79: --
80: hr_api.set_legislation_context(l_legislation_code);
81: end if;
82: --
83: hr_utility.set_location(' Leaving:'|| l_proc, 20);
84: --

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 => 'parent_spine_id'
119: ,p_argument_value => p_parent_spine_id
120: );

Line 122: if ( nvl(per_pps_bus.g_parent_spine_id, hr_api.g_number)

118: ,p_argument => 'parent_spine_id'
119: ,p_argument_value => p_parent_spine_id
120: );
121: --
122: if ( nvl(per_pps_bus.g_parent_spine_id, hr_api.g_number)
123: = p_parent_spine_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 206: and nvl(p_parent_spine_id,hr_api.g_number)

202: ,p_object_version_number => p_object_version_number
203: );
204: --
205: if (l_api_updating
206: and nvl(p_parent_spine_id,hr_api.g_number)
207: <> per_pps_shd.g_old_rec.parent_spine_id) then
208: --
209: -- raise error as PK has changed
210: --

Line 290: hr_api.mandatory_arg_error

286: hr_utility.set_location('Entering:'||l_proc, 10);
287: --
288: -- Check mandatory parameters have been set
289: --
290: hr_api.mandatory_arg_error
291: (p_api_name => l_proc
292: ,p_argument => 'name'
293: ,p_argument_value => p_name
294: );

Line 382: and nvl(p_increment_frequency,hr_api.g_number)

378: ,p_object_version_number => p_object_version_number
379: );
380: --
381: if (l_api_updating
382: and nvl(p_increment_frequency,hr_api.g_number)
383: <> per_pps_shd.g_old_rec.increment_frequency) then
384: --
385: -- Check mandatory parameters have been set
386: --

Line 462: if hr_api.not_exists_in_hr_lookups

458: -- Check that the frequency exists in hr_lookups for the lookup
459: -- type 'FREQUENCY' with an enabled flag set to 'Y'
460: --
461: hr_utility.set_location(l_proc, 30);
462: if hr_api.not_exists_in_hr_lookups
463: (p_effective_date => p_effective_date
464: ,p_lookup_type => 'FREQUENCY'
465: ,p_lookup_code => p_increment_period
466: )

Line 679: nvl(per_pps_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>

675: begin
676: hr_utility.set_location('Entering:'||l_proc,10);
677: --
678: if ((p_rec.parent_spine_id is not null) and (
679: nvl(per_pps_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
680: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
681: nvl(per_pps_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
682: nvl(p_rec.attribute1, hr_api.g_varchar2) or
683: nvl(per_pps_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

Line 680: nvl(p_rec.attribute_category, hr_api.g_varchar2) or

676: hr_utility.set_location('Entering:'||l_proc,10);
677: --
678: if ((p_rec.parent_spine_id is not null) and (
679: nvl(per_pps_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
680: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
681: nvl(per_pps_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
682: nvl(p_rec.attribute1, hr_api.g_varchar2) or
683: nvl(per_pps_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
684: nvl(p_rec.attribute2, hr_api.g_varchar2) or

Line 681: nvl(per_pps_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>

677: --
678: if ((p_rec.parent_spine_id is not null) and (
679: nvl(per_pps_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
680: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
681: nvl(per_pps_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
682: nvl(p_rec.attribute1, hr_api.g_varchar2) or
683: nvl(per_pps_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
684: nvl(p_rec.attribute2, hr_api.g_varchar2) or
685: nvl(per_pps_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

Line 682: nvl(p_rec.attribute1, hr_api.g_varchar2) or

678: if ((p_rec.parent_spine_id is not null) and (
679: nvl(per_pps_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
680: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
681: nvl(per_pps_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
682: nvl(p_rec.attribute1, hr_api.g_varchar2) or
683: nvl(per_pps_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
684: nvl(p_rec.attribute2, hr_api.g_varchar2) or
685: nvl(per_pps_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
686: nvl(p_rec.attribute3, hr_api.g_varchar2) or

Line 683: nvl(per_pps_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

679: nvl(per_pps_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
680: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
681: nvl(per_pps_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
682: nvl(p_rec.attribute1, hr_api.g_varchar2) or
683: nvl(per_pps_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
684: nvl(p_rec.attribute2, hr_api.g_varchar2) or
685: nvl(per_pps_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
686: nvl(p_rec.attribute3, hr_api.g_varchar2) or
687: nvl(per_pps_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

Line 684: nvl(p_rec.attribute2, hr_api.g_varchar2) or

680: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
681: nvl(per_pps_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
682: nvl(p_rec.attribute1, hr_api.g_varchar2) or
683: nvl(per_pps_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
684: nvl(p_rec.attribute2, hr_api.g_varchar2) or
685: nvl(per_pps_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
686: nvl(p_rec.attribute3, hr_api.g_varchar2) or
687: nvl(per_pps_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
688: nvl(p_rec.attribute4, hr_api.g_varchar2) or

Line 685: nvl(per_pps_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

681: nvl(per_pps_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
682: nvl(p_rec.attribute1, hr_api.g_varchar2) or
683: nvl(per_pps_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
684: nvl(p_rec.attribute2, hr_api.g_varchar2) or
685: nvl(per_pps_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
686: nvl(p_rec.attribute3, hr_api.g_varchar2) or
687: nvl(per_pps_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
688: nvl(p_rec.attribute4, hr_api.g_varchar2) or
689: nvl(per_pps_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

Line 686: nvl(p_rec.attribute3, hr_api.g_varchar2) or

682: nvl(p_rec.attribute1, hr_api.g_varchar2) or
683: nvl(per_pps_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
684: nvl(p_rec.attribute2, hr_api.g_varchar2) or
685: nvl(per_pps_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
686: nvl(p_rec.attribute3, hr_api.g_varchar2) or
687: nvl(per_pps_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
688: nvl(p_rec.attribute4, hr_api.g_varchar2) or
689: nvl(per_pps_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
690: nvl(p_rec.attribute5, hr_api.g_varchar2) or

Line 687: nvl(per_pps_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

683: nvl(per_pps_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
684: nvl(p_rec.attribute2, hr_api.g_varchar2) or
685: nvl(per_pps_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
686: nvl(p_rec.attribute3, hr_api.g_varchar2) or
687: nvl(per_pps_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
688: nvl(p_rec.attribute4, hr_api.g_varchar2) or
689: nvl(per_pps_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
690: nvl(p_rec.attribute5, hr_api.g_varchar2) or
691: nvl(per_pps_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

Line 688: nvl(p_rec.attribute4, hr_api.g_varchar2) or

684: nvl(p_rec.attribute2, hr_api.g_varchar2) or
685: nvl(per_pps_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
686: nvl(p_rec.attribute3, hr_api.g_varchar2) or
687: nvl(per_pps_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
688: nvl(p_rec.attribute4, hr_api.g_varchar2) or
689: nvl(per_pps_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
690: nvl(p_rec.attribute5, hr_api.g_varchar2) or
691: nvl(per_pps_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
692: nvl(p_rec.attribute6, hr_api.g_varchar2) or

Line 689: nvl(per_pps_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

685: nvl(per_pps_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
686: nvl(p_rec.attribute3, hr_api.g_varchar2) or
687: nvl(per_pps_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
688: nvl(p_rec.attribute4, hr_api.g_varchar2) or
689: nvl(per_pps_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
690: nvl(p_rec.attribute5, hr_api.g_varchar2) or
691: nvl(per_pps_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
692: nvl(p_rec.attribute6, hr_api.g_varchar2) or
693: nvl(per_pps_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

Line 690: nvl(p_rec.attribute5, hr_api.g_varchar2) or

686: nvl(p_rec.attribute3, hr_api.g_varchar2) or
687: nvl(per_pps_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
688: nvl(p_rec.attribute4, hr_api.g_varchar2) or
689: nvl(per_pps_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
690: nvl(p_rec.attribute5, hr_api.g_varchar2) or
691: nvl(per_pps_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
692: nvl(p_rec.attribute6, hr_api.g_varchar2) or
693: nvl(per_pps_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
694: nvl(p_rec.attribute7, hr_api.g_varchar2) or

Line 691: nvl(per_pps_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

687: nvl(per_pps_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
688: nvl(p_rec.attribute4, hr_api.g_varchar2) or
689: nvl(per_pps_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
690: nvl(p_rec.attribute5, hr_api.g_varchar2) or
691: nvl(per_pps_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
692: nvl(p_rec.attribute6, hr_api.g_varchar2) or
693: nvl(per_pps_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
694: nvl(p_rec.attribute7, hr_api.g_varchar2) or
695: nvl(per_pps_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

Line 692: nvl(p_rec.attribute6, hr_api.g_varchar2) or

688: nvl(p_rec.attribute4, hr_api.g_varchar2) or
689: nvl(per_pps_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
690: nvl(p_rec.attribute5, hr_api.g_varchar2) or
691: nvl(per_pps_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
692: nvl(p_rec.attribute6, hr_api.g_varchar2) or
693: nvl(per_pps_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
694: nvl(p_rec.attribute7, hr_api.g_varchar2) or
695: nvl(per_pps_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
696: nvl(p_rec.attribute8, hr_api.g_varchar2) or

Line 693: nvl(per_pps_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

689: nvl(per_pps_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
690: nvl(p_rec.attribute5, hr_api.g_varchar2) or
691: nvl(per_pps_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
692: nvl(p_rec.attribute6, hr_api.g_varchar2) or
693: nvl(per_pps_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
694: nvl(p_rec.attribute7, hr_api.g_varchar2) or
695: nvl(per_pps_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
696: nvl(p_rec.attribute8, hr_api.g_varchar2) or
697: nvl(per_pps_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

Line 694: nvl(p_rec.attribute7, hr_api.g_varchar2) or

690: nvl(p_rec.attribute5, hr_api.g_varchar2) or
691: nvl(per_pps_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
692: nvl(p_rec.attribute6, hr_api.g_varchar2) or
693: nvl(per_pps_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
694: nvl(p_rec.attribute7, hr_api.g_varchar2) or
695: nvl(per_pps_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
696: nvl(p_rec.attribute8, hr_api.g_varchar2) or
697: nvl(per_pps_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
698: nvl(p_rec.attribute9, hr_api.g_varchar2) or

Line 695: nvl(per_pps_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

691: nvl(per_pps_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
692: nvl(p_rec.attribute6, hr_api.g_varchar2) or
693: nvl(per_pps_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
694: nvl(p_rec.attribute7, hr_api.g_varchar2) or
695: nvl(per_pps_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
696: nvl(p_rec.attribute8, hr_api.g_varchar2) or
697: nvl(per_pps_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
698: nvl(p_rec.attribute9, hr_api.g_varchar2) or
699: nvl(per_pps_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

Line 696: nvl(p_rec.attribute8, hr_api.g_varchar2) or

692: nvl(p_rec.attribute6, hr_api.g_varchar2) or
693: nvl(per_pps_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
694: nvl(p_rec.attribute7, hr_api.g_varchar2) or
695: nvl(per_pps_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
696: nvl(p_rec.attribute8, hr_api.g_varchar2) or
697: nvl(per_pps_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
698: nvl(p_rec.attribute9, hr_api.g_varchar2) or
699: nvl(per_pps_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
700: nvl(p_rec.attribute10, hr_api.g_varchar2) or

Line 697: nvl(per_pps_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

693: nvl(per_pps_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
694: nvl(p_rec.attribute7, hr_api.g_varchar2) or
695: nvl(per_pps_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
696: nvl(p_rec.attribute8, hr_api.g_varchar2) or
697: nvl(per_pps_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
698: nvl(p_rec.attribute9, hr_api.g_varchar2) or
699: nvl(per_pps_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
700: nvl(p_rec.attribute10, hr_api.g_varchar2) or
701: nvl(per_pps_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

Line 698: nvl(p_rec.attribute9, hr_api.g_varchar2) or

694: nvl(p_rec.attribute7, hr_api.g_varchar2) or
695: nvl(per_pps_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
696: nvl(p_rec.attribute8, hr_api.g_varchar2) or
697: nvl(per_pps_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
698: nvl(p_rec.attribute9, hr_api.g_varchar2) or
699: nvl(per_pps_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
700: nvl(p_rec.attribute10, hr_api.g_varchar2) or
701: nvl(per_pps_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
702: nvl(p_rec.attribute11, hr_api.g_varchar2) or

Line 699: nvl(per_pps_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

695: nvl(per_pps_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
696: nvl(p_rec.attribute8, hr_api.g_varchar2) or
697: nvl(per_pps_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
698: nvl(p_rec.attribute9, hr_api.g_varchar2) or
699: nvl(per_pps_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
700: nvl(p_rec.attribute10, hr_api.g_varchar2) or
701: nvl(per_pps_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
702: nvl(p_rec.attribute11, hr_api.g_varchar2) or
703: nvl(per_pps_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

Line 700: nvl(p_rec.attribute10, hr_api.g_varchar2) or

696: nvl(p_rec.attribute8, hr_api.g_varchar2) or
697: nvl(per_pps_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
698: nvl(p_rec.attribute9, hr_api.g_varchar2) or
699: nvl(per_pps_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
700: nvl(p_rec.attribute10, hr_api.g_varchar2) or
701: nvl(per_pps_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
702: nvl(p_rec.attribute11, hr_api.g_varchar2) or
703: nvl(per_pps_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
704: nvl(p_rec.attribute12, hr_api.g_varchar2) or

Line 701: nvl(per_pps_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

697: nvl(per_pps_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
698: nvl(p_rec.attribute9, hr_api.g_varchar2) or
699: nvl(per_pps_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
700: nvl(p_rec.attribute10, hr_api.g_varchar2) or
701: nvl(per_pps_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
702: nvl(p_rec.attribute11, hr_api.g_varchar2) or
703: nvl(per_pps_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
704: nvl(p_rec.attribute12, hr_api.g_varchar2) or
705: nvl(per_pps_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

Line 702: nvl(p_rec.attribute11, hr_api.g_varchar2) or

698: nvl(p_rec.attribute9, hr_api.g_varchar2) or
699: nvl(per_pps_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
700: nvl(p_rec.attribute10, hr_api.g_varchar2) or
701: nvl(per_pps_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
702: nvl(p_rec.attribute11, hr_api.g_varchar2) or
703: nvl(per_pps_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
704: nvl(p_rec.attribute12, hr_api.g_varchar2) or
705: nvl(per_pps_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
706: nvl(p_rec.attribute13, hr_api.g_varchar2) or

Line 703: nvl(per_pps_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

699: nvl(per_pps_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
700: nvl(p_rec.attribute10, hr_api.g_varchar2) or
701: nvl(per_pps_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
702: nvl(p_rec.attribute11, hr_api.g_varchar2) or
703: nvl(per_pps_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
704: nvl(p_rec.attribute12, hr_api.g_varchar2) or
705: nvl(per_pps_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
706: nvl(p_rec.attribute13, hr_api.g_varchar2) or
707: nvl(per_pps_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

Line 704: nvl(p_rec.attribute12, hr_api.g_varchar2) or

700: nvl(p_rec.attribute10, hr_api.g_varchar2) or
701: nvl(per_pps_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
702: nvl(p_rec.attribute11, hr_api.g_varchar2) or
703: nvl(per_pps_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
704: nvl(p_rec.attribute12, hr_api.g_varchar2) or
705: nvl(per_pps_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
706: nvl(p_rec.attribute13, hr_api.g_varchar2) or
707: nvl(per_pps_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
708: nvl(p_rec.attribute14, hr_api.g_varchar2) or

Line 705: nvl(per_pps_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

701: nvl(per_pps_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
702: nvl(p_rec.attribute11, hr_api.g_varchar2) or
703: nvl(per_pps_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
704: nvl(p_rec.attribute12, hr_api.g_varchar2) or
705: nvl(per_pps_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
706: nvl(p_rec.attribute13, hr_api.g_varchar2) or
707: nvl(per_pps_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
708: nvl(p_rec.attribute14, hr_api.g_varchar2) or
709: nvl(per_pps_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

Line 706: nvl(p_rec.attribute13, hr_api.g_varchar2) or

702: nvl(p_rec.attribute11, hr_api.g_varchar2) or
703: nvl(per_pps_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
704: nvl(p_rec.attribute12, hr_api.g_varchar2) or
705: nvl(per_pps_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
706: nvl(p_rec.attribute13, hr_api.g_varchar2) or
707: nvl(per_pps_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
708: nvl(p_rec.attribute14, hr_api.g_varchar2) or
709: nvl(per_pps_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
710: nvl(p_rec.attribute15, hr_api.g_varchar2) or

Line 707: nvl(per_pps_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

703: nvl(per_pps_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
704: nvl(p_rec.attribute12, hr_api.g_varchar2) or
705: nvl(per_pps_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
706: nvl(p_rec.attribute13, hr_api.g_varchar2) or
707: nvl(per_pps_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
708: nvl(p_rec.attribute14, hr_api.g_varchar2) or
709: nvl(per_pps_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
710: nvl(p_rec.attribute15, hr_api.g_varchar2) or
711: nvl(per_pps_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

Line 708: nvl(p_rec.attribute14, hr_api.g_varchar2) or

704: nvl(p_rec.attribute12, hr_api.g_varchar2) or
705: nvl(per_pps_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
706: nvl(p_rec.attribute13, hr_api.g_varchar2) or
707: nvl(per_pps_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
708: nvl(p_rec.attribute14, hr_api.g_varchar2) or
709: nvl(per_pps_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
710: nvl(p_rec.attribute15, hr_api.g_varchar2) or
711: nvl(per_pps_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
712: nvl(p_rec.attribute16, hr_api.g_varchar2) or

Line 709: nvl(per_pps_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

705: nvl(per_pps_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
706: nvl(p_rec.attribute13, hr_api.g_varchar2) or
707: nvl(per_pps_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
708: nvl(p_rec.attribute14, hr_api.g_varchar2) or
709: nvl(per_pps_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
710: nvl(p_rec.attribute15, hr_api.g_varchar2) or
711: nvl(per_pps_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
712: nvl(p_rec.attribute16, hr_api.g_varchar2) or
713: nvl(per_pps_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

Line 710: nvl(p_rec.attribute15, hr_api.g_varchar2) or

706: nvl(p_rec.attribute13, hr_api.g_varchar2) or
707: nvl(per_pps_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
708: nvl(p_rec.attribute14, hr_api.g_varchar2) or
709: nvl(per_pps_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
710: nvl(p_rec.attribute15, hr_api.g_varchar2) or
711: nvl(per_pps_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
712: nvl(p_rec.attribute16, hr_api.g_varchar2) or
713: nvl(per_pps_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
714: nvl(p_rec.attribute17, hr_api.g_varchar2) or

Line 711: nvl(per_pps_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

707: nvl(per_pps_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
708: nvl(p_rec.attribute14, hr_api.g_varchar2) or
709: nvl(per_pps_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
710: nvl(p_rec.attribute15, hr_api.g_varchar2) or
711: nvl(per_pps_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
712: nvl(p_rec.attribute16, hr_api.g_varchar2) or
713: nvl(per_pps_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
714: nvl(p_rec.attribute17, hr_api.g_varchar2) or
715: nvl(per_pps_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

Line 712: nvl(p_rec.attribute16, hr_api.g_varchar2) or

708: nvl(p_rec.attribute14, hr_api.g_varchar2) or
709: nvl(per_pps_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
710: nvl(p_rec.attribute15, hr_api.g_varchar2) or
711: nvl(per_pps_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
712: nvl(p_rec.attribute16, hr_api.g_varchar2) or
713: nvl(per_pps_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
714: nvl(p_rec.attribute17, hr_api.g_varchar2) or
715: nvl(per_pps_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
716: nvl(p_rec.attribute18, hr_api.g_varchar2) or

Line 713: nvl(per_pps_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

709: nvl(per_pps_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
710: nvl(p_rec.attribute15, hr_api.g_varchar2) or
711: nvl(per_pps_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
712: nvl(p_rec.attribute16, hr_api.g_varchar2) or
713: nvl(per_pps_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
714: nvl(p_rec.attribute17, hr_api.g_varchar2) or
715: nvl(per_pps_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
716: nvl(p_rec.attribute18, hr_api.g_varchar2) or
717: nvl(per_pps_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

Line 714: nvl(p_rec.attribute17, hr_api.g_varchar2) or

710: nvl(p_rec.attribute15, hr_api.g_varchar2) or
711: nvl(per_pps_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
712: nvl(p_rec.attribute16, hr_api.g_varchar2) or
713: nvl(per_pps_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
714: nvl(p_rec.attribute17, hr_api.g_varchar2) or
715: nvl(per_pps_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
716: nvl(p_rec.attribute18, hr_api.g_varchar2) or
717: nvl(per_pps_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
718: nvl(p_rec.attribute19, hr_api.g_varchar2) or

Line 715: nvl(per_pps_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

711: nvl(per_pps_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
712: nvl(p_rec.attribute16, hr_api.g_varchar2) or
713: nvl(per_pps_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
714: nvl(p_rec.attribute17, hr_api.g_varchar2) or
715: nvl(per_pps_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
716: nvl(p_rec.attribute18, hr_api.g_varchar2) or
717: nvl(per_pps_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
718: nvl(p_rec.attribute19, hr_api.g_varchar2) or
719: nvl(per_pps_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

Line 716: nvl(p_rec.attribute18, hr_api.g_varchar2) or

712: nvl(p_rec.attribute16, hr_api.g_varchar2) or
713: nvl(per_pps_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
714: nvl(p_rec.attribute17, hr_api.g_varchar2) or
715: nvl(per_pps_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
716: nvl(p_rec.attribute18, hr_api.g_varchar2) or
717: nvl(per_pps_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
718: nvl(p_rec.attribute19, hr_api.g_varchar2) or
719: nvl(per_pps_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
720: nvl(p_rec.attribute20, hr_api.g_varchar2) ))

Line 717: nvl(per_pps_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

713: nvl(per_pps_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
714: nvl(p_rec.attribute17, hr_api.g_varchar2) or
715: nvl(per_pps_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
716: nvl(p_rec.attribute18, hr_api.g_varchar2) or
717: nvl(per_pps_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
718: nvl(p_rec.attribute19, hr_api.g_varchar2) or
719: nvl(per_pps_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
720: nvl(p_rec.attribute20, hr_api.g_varchar2) ))
721: or (p_rec.parent_spine_id is null) then

Line 718: nvl(p_rec.attribute19, hr_api.g_varchar2) or

714: nvl(p_rec.attribute17, hr_api.g_varchar2) or
715: nvl(per_pps_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
716: nvl(p_rec.attribute18, hr_api.g_varchar2) or
717: nvl(per_pps_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
718: nvl(p_rec.attribute19, hr_api.g_varchar2) or
719: nvl(per_pps_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
720: nvl(p_rec.attribute20, hr_api.g_varchar2) ))
721: or (p_rec.parent_spine_id is null) then
722: --

Line 719: nvl(per_pps_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

715: nvl(per_pps_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
716: nvl(p_rec.attribute18, hr_api.g_varchar2) or
717: nvl(per_pps_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
718: nvl(p_rec.attribute19, hr_api.g_varchar2) or
719: nvl(per_pps_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
720: nvl(p_rec.attribute20, hr_api.g_varchar2) ))
721: or (p_rec.parent_spine_id is null) then
722: --
723: -- Only execute the validation if absolutely necessary:

Line 720: nvl(p_rec.attribute20, hr_api.g_varchar2) ))

716: nvl(p_rec.attribute18, hr_api.g_varchar2) or
717: nvl(per_pps_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
718: nvl(p_rec.attribute19, hr_api.g_varchar2) or
719: nvl(per_pps_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
720: nvl(p_rec.attribute20, hr_api.g_varchar2) ))
721: or (p_rec.parent_spine_id is null) then
722: --
723: -- Only execute the validation if absolutely necessary:
724: -- a) During update, the structure column value or any

Line 817: nvl(per_pps_shd.g_old_rec.information_category, hr_api.g_varchar2) <>

813: begin
814: hr_utility.set_location('Entering:'||l_proc,10);
815: --
816: if ((p_rec.parent_spine_id is not null) and (
817: nvl(per_pps_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
818: nvl(p_rec.information_category, hr_api.g_varchar2) or
819: nvl(per_pps_shd.g_old_rec.information1, hr_api.g_varchar2) <>
820: nvl(p_rec.information1, hr_api.g_varchar2) or
821: nvl(per_pps_shd.g_old_rec.information2, hr_api.g_varchar2) <>

Line 818: nvl(p_rec.information_category, hr_api.g_varchar2) or

814: hr_utility.set_location('Entering:'||l_proc,10);
815: --
816: if ((p_rec.parent_spine_id is not null) and (
817: nvl(per_pps_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
818: nvl(p_rec.information_category, hr_api.g_varchar2) or
819: nvl(per_pps_shd.g_old_rec.information1, hr_api.g_varchar2) <>
820: nvl(p_rec.information1, hr_api.g_varchar2) or
821: nvl(per_pps_shd.g_old_rec.information2, hr_api.g_varchar2) <>
822: nvl(p_rec.information2, hr_api.g_varchar2) or

Line 819: nvl(per_pps_shd.g_old_rec.information1, hr_api.g_varchar2) <>

815: --
816: if ((p_rec.parent_spine_id is not null) and (
817: nvl(per_pps_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
818: nvl(p_rec.information_category, hr_api.g_varchar2) or
819: nvl(per_pps_shd.g_old_rec.information1, hr_api.g_varchar2) <>
820: nvl(p_rec.information1, hr_api.g_varchar2) or
821: nvl(per_pps_shd.g_old_rec.information2, hr_api.g_varchar2) <>
822: nvl(p_rec.information2, hr_api.g_varchar2) or
823: nvl(per_pps_shd.g_old_rec.information3, hr_api.g_varchar2) <>

Line 820: nvl(p_rec.information1, hr_api.g_varchar2) or

816: if ((p_rec.parent_spine_id is not null) and (
817: nvl(per_pps_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
818: nvl(p_rec.information_category, hr_api.g_varchar2) or
819: nvl(per_pps_shd.g_old_rec.information1, hr_api.g_varchar2) <>
820: nvl(p_rec.information1, hr_api.g_varchar2) or
821: nvl(per_pps_shd.g_old_rec.information2, hr_api.g_varchar2) <>
822: nvl(p_rec.information2, hr_api.g_varchar2) or
823: nvl(per_pps_shd.g_old_rec.information3, hr_api.g_varchar2) <>
824: nvl(p_rec.information3, hr_api.g_varchar2) or

Line 821: nvl(per_pps_shd.g_old_rec.information2, hr_api.g_varchar2) <>

817: nvl(per_pps_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
818: nvl(p_rec.information_category, hr_api.g_varchar2) or
819: nvl(per_pps_shd.g_old_rec.information1, hr_api.g_varchar2) <>
820: nvl(p_rec.information1, hr_api.g_varchar2) or
821: nvl(per_pps_shd.g_old_rec.information2, hr_api.g_varchar2) <>
822: nvl(p_rec.information2, hr_api.g_varchar2) or
823: nvl(per_pps_shd.g_old_rec.information3, hr_api.g_varchar2) <>
824: nvl(p_rec.information3, hr_api.g_varchar2) or
825: nvl(per_pps_shd.g_old_rec.information4, hr_api.g_varchar2) <>

Line 822: nvl(p_rec.information2, hr_api.g_varchar2) or

818: nvl(p_rec.information_category, hr_api.g_varchar2) or
819: nvl(per_pps_shd.g_old_rec.information1, hr_api.g_varchar2) <>
820: nvl(p_rec.information1, hr_api.g_varchar2) or
821: nvl(per_pps_shd.g_old_rec.information2, hr_api.g_varchar2) <>
822: nvl(p_rec.information2, hr_api.g_varchar2) or
823: nvl(per_pps_shd.g_old_rec.information3, hr_api.g_varchar2) <>
824: nvl(p_rec.information3, hr_api.g_varchar2) or
825: nvl(per_pps_shd.g_old_rec.information4, hr_api.g_varchar2) <>
826: nvl(p_rec.information4, hr_api.g_varchar2) or

Line 823: nvl(per_pps_shd.g_old_rec.information3, hr_api.g_varchar2) <>

819: nvl(per_pps_shd.g_old_rec.information1, hr_api.g_varchar2) <>
820: nvl(p_rec.information1, hr_api.g_varchar2) or
821: nvl(per_pps_shd.g_old_rec.information2, hr_api.g_varchar2) <>
822: nvl(p_rec.information2, hr_api.g_varchar2) or
823: nvl(per_pps_shd.g_old_rec.information3, hr_api.g_varchar2) <>
824: nvl(p_rec.information3, hr_api.g_varchar2) or
825: nvl(per_pps_shd.g_old_rec.information4, hr_api.g_varchar2) <>
826: nvl(p_rec.information4, hr_api.g_varchar2) or
827: nvl(per_pps_shd.g_old_rec.information5, hr_api.g_varchar2) <>

Line 824: nvl(p_rec.information3, hr_api.g_varchar2) or

820: nvl(p_rec.information1, hr_api.g_varchar2) or
821: nvl(per_pps_shd.g_old_rec.information2, hr_api.g_varchar2) <>
822: nvl(p_rec.information2, hr_api.g_varchar2) or
823: nvl(per_pps_shd.g_old_rec.information3, hr_api.g_varchar2) <>
824: nvl(p_rec.information3, hr_api.g_varchar2) or
825: nvl(per_pps_shd.g_old_rec.information4, hr_api.g_varchar2) <>
826: nvl(p_rec.information4, hr_api.g_varchar2) or
827: nvl(per_pps_shd.g_old_rec.information5, hr_api.g_varchar2) <>
828: nvl(p_rec.information5, hr_api.g_varchar2) or

Line 825: nvl(per_pps_shd.g_old_rec.information4, hr_api.g_varchar2) <>

821: nvl(per_pps_shd.g_old_rec.information2, hr_api.g_varchar2) <>
822: nvl(p_rec.information2, hr_api.g_varchar2) or
823: nvl(per_pps_shd.g_old_rec.information3, hr_api.g_varchar2) <>
824: nvl(p_rec.information3, hr_api.g_varchar2) or
825: nvl(per_pps_shd.g_old_rec.information4, hr_api.g_varchar2) <>
826: nvl(p_rec.information4, hr_api.g_varchar2) or
827: nvl(per_pps_shd.g_old_rec.information5, hr_api.g_varchar2) <>
828: nvl(p_rec.information5, hr_api.g_varchar2) or
829: nvl(per_pps_shd.g_old_rec.information6, hr_api.g_varchar2) <>

Line 826: nvl(p_rec.information4, hr_api.g_varchar2) or

822: nvl(p_rec.information2, hr_api.g_varchar2) or
823: nvl(per_pps_shd.g_old_rec.information3, hr_api.g_varchar2) <>
824: nvl(p_rec.information3, hr_api.g_varchar2) or
825: nvl(per_pps_shd.g_old_rec.information4, hr_api.g_varchar2) <>
826: nvl(p_rec.information4, hr_api.g_varchar2) or
827: nvl(per_pps_shd.g_old_rec.information5, hr_api.g_varchar2) <>
828: nvl(p_rec.information5, hr_api.g_varchar2) or
829: nvl(per_pps_shd.g_old_rec.information6, hr_api.g_varchar2) <>
830: nvl(p_rec.information6, hr_api.g_varchar2) or

Line 827: nvl(per_pps_shd.g_old_rec.information5, hr_api.g_varchar2) <>

823: nvl(per_pps_shd.g_old_rec.information3, hr_api.g_varchar2) <>
824: nvl(p_rec.information3, hr_api.g_varchar2) or
825: nvl(per_pps_shd.g_old_rec.information4, hr_api.g_varchar2) <>
826: nvl(p_rec.information4, hr_api.g_varchar2) or
827: nvl(per_pps_shd.g_old_rec.information5, hr_api.g_varchar2) <>
828: nvl(p_rec.information5, hr_api.g_varchar2) or
829: nvl(per_pps_shd.g_old_rec.information6, hr_api.g_varchar2) <>
830: nvl(p_rec.information6, hr_api.g_varchar2) or
831: nvl(per_pps_shd.g_old_rec.information7, hr_api.g_varchar2) <>

Line 828: nvl(p_rec.information5, hr_api.g_varchar2) or

824: nvl(p_rec.information3, hr_api.g_varchar2) or
825: nvl(per_pps_shd.g_old_rec.information4, hr_api.g_varchar2) <>
826: nvl(p_rec.information4, hr_api.g_varchar2) or
827: nvl(per_pps_shd.g_old_rec.information5, hr_api.g_varchar2) <>
828: nvl(p_rec.information5, hr_api.g_varchar2) or
829: nvl(per_pps_shd.g_old_rec.information6, hr_api.g_varchar2) <>
830: nvl(p_rec.information6, hr_api.g_varchar2) or
831: nvl(per_pps_shd.g_old_rec.information7, hr_api.g_varchar2) <>
832: nvl(p_rec.information7, hr_api.g_varchar2) or

Line 829: nvl(per_pps_shd.g_old_rec.information6, hr_api.g_varchar2) <>

825: nvl(per_pps_shd.g_old_rec.information4, hr_api.g_varchar2) <>
826: nvl(p_rec.information4, hr_api.g_varchar2) or
827: nvl(per_pps_shd.g_old_rec.information5, hr_api.g_varchar2) <>
828: nvl(p_rec.information5, hr_api.g_varchar2) or
829: nvl(per_pps_shd.g_old_rec.information6, hr_api.g_varchar2) <>
830: nvl(p_rec.information6, hr_api.g_varchar2) or
831: nvl(per_pps_shd.g_old_rec.information7, hr_api.g_varchar2) <>
832: nvl(p_rec.information7, hr_api.g_varchar2) or
833: nvl(per_pps_shd.g_old_rec.information8, hr_api.g_varchar2) <>

Line 830: nvl(p_rec.information6, hr_api.g_varchar2) or

826: nvl(p_rec.information4, hr_api.g_varchar2) or
827: nvl(per_pps_shd.g_old_rec.information5, hr_api.g_varchar2) <>
828: nvl(p_rec.information5, hr_api.g_varchar2) or
829: nvl(per_pps_shd.g_old_rec.information6, hr_api.g_varchar2) <>
830: nvl(p_rec.information6, hr_api.g_varchar2) or
831: nvl(per_pps_shd.g_old_rec.information7, hr_api.g_varchar2) <>
832: nvl(p_rec.information7, hr_api.g_varchar2) or
833: nvl(per_pps_shd.g_old_rec.information8, hr_api.g_varchar2) <>
834: nvl(p_rec.information8, hr_api.g_varchar2) or

Line 831: nvl(per_pps_shd.g_old_rec.information7, hr_api.g_varchar2) <>

827: nvl(per_pps_shd.g_old_rec.information5, hr_api.g_varchar2) <>
828: nvl(p_rec.information5, hr_api.g_varchar2) or
829: nvl(per_pps_shd.g_old_rec.information6, hr_api.g_varchar2) <>
830: nvl(p_rec.information6, hr_api.g_varchar2) or
831: nvl(per_pps_shd.g_old_rec.information7, hr_api.g_varchar2) <>
832: nvl(p_rec.information7, hr_api.g_varchar2) or
833: nvl(per_pps_shd.g_old_rec.information8, hr_api.g_varchar2) <>
834: nvl(p_rec.information8, hr_api.g_varchar2) or
835: nvl(per_pps_shd.g_old_rec.information9, hr_api.g_varchar2) <>

Line 832: nvl(p_rec.information7, hr_api.g_varchar2) or

828: nvl(p_rec.information5, hr_api.g_varchar2) or
829: nvl(per_pps_shd.g_old_rec.information6, hr_api.g_varchar2) <>
830: nvl(p_rec.information6, hr_api.g_varchar2) or
831: nvl(per_pps_shd.g_old_rec.information7, hr_api.g_varchar2) <>
832: nvl(p_rec.information7, hr_api.g_varchar2) or
833: nvl(per_pps_shd.g_old_rec.information8, hr_api.g_varchar2) <>
834: nvl(p_rec.information8, hr_api.g_varchar2) or
835: nvl(per_pps_shd.g_old_rec.information9, hr_api.g_varchar2) <>
836: nvl(p_rec.information9, hr_api.g_varchar2) or

Line 833: nvl(per_pps_shd.g_old_rec.information8, hr_api.g_varchar2) <>

829: nvl(per_pps_shd.g_old_rec.information6, hr_api.g_varchar2) <>
830: nvl(p_rec.information6, hr_api.g_varchar2) or
831: nvl(per_pps_shd.g_old_rec.information7, hr_api.g_varchar2) <>
832: nvl(p_rec.information7, hr_api.g_varchar2) or
833: nvl(per_pps_shd.g_old_rec.information8, hr_api.g_varchar2) <>
834: nvl(p_rec.information8, hr_api.g_varchar2) or
835: nvl(per_pps_shd.g_old_rec.information9, hr_api.g_varchar2) <>
836: nvl(p_rec.information9, hr_api.g_varchar2) or
837: nvl(per_pps_shd.g_old_rec.information10, hr_api.g_varchar2) <>

Line 834: nvl(p_rec.information8, hr_api.g_varchar2) or

830: nvl(p_rec.information6, hr_api.g_varchar2) or
831: nvl(per_pps_shd.g_old_rec.information7, hr_api.g_varchar2) <>
832: nvl(p_rec.information7, hr_api.g_varchar2) or
833: nvl(per_pps_shd.g_old_rec.information8, hr_api.g_varchar2) <>
834: nvl(p_rec.information8, hr_api.g_varchar2) or
835: nvl(per_pps_shd.g_old_rec.information9, hr_api.g_varchar2) <>
836: nvl(p_rec.information9, hr_api.g_varchar2) or
837: nvl(per_pps_shd.g_old_rec.information10, hr_api.g_varchar2) <>
838: nvl(p_rec.information10, hr_api.g_varchar2) or

Line 835: nvl(per_pps_shd.g_old_rec.information9, hr_api.g_varchar2) <>

831: nvl(per_pps_shd.g_old_rec.information7, hr_api.g_varchar2) <>
832: nvl(p_rec.information7, hr_api.g_varchar2) or
833: nvl(per_pps_shd.g_old_rec.information8, hr_api.g_varchar2) <>
834: nvl(p_rec.information8, hr_api.g_varchar2) or
835: nvl(per_pps_shd.g_old_rec.information9, hr_api.g_varchar2) <>
836: nvl(p_rec.information9, hr_api.g_varchar2) or
837: nvl(per_pps_shd.g_old_rec.information10, hr_api.g_varchar2) <>
838: nvl(p_rec.information10, hr_api.g_varchar2) or
839: nvl(per_pps_shd.g_old_rec.information11, hr_api.g_varchar2) <>

Line 836: nvl(p_rec.information9, hr_api.g_varchar2) or

832: nvl(p_rec.information7, hr_api.g_varchar2) or
833: nvl(per_pps_shd.g_old_rec.information8, hr_api.g_varchar2) <>
834: nvl(p_rec.information8, hr_api.g_varchar2) or
835: nvl(per_pps_shd.g_old_rec.information9, hr_api.g_varchar2) <>
836: nvl(p_rec.information9, hr_api.g_varchar2) or
837: nvl(per_pps_shd.g_old_rec.information10, hr_api.g_varchar2) <>
838: nvl(p_rec.information10, hr_api.g_varchar2) or
839: nvl(per_pps_shd.g_old_rec.information11, hr_api.g_varchar2) <>
840: nvl(p_rec.information11, hr_api.g_varchar2) or

Line 837: nvl(per_pps_shd.g_old_rec.information10, hr_api.g_varchar2) <>

833: nvl(per_pps_shd.g_old_rec.information8, hr_api.g_varchar2) <>
834: nvl(p_rec.information8, hr_api.g_varchar2) or
835: nvl(per_pps_shd.g_old_rec.information9, hr_api.g_varchar2) <>
836: nvl(p_rec.information9, hr_api.g_varchar2) or
837: nvl(per_pps_shd.g_old_rec.information10, hr_api.g_varchar2) <>
838: nvl(p_rec.information10, hr_api.g_varchar2) or
839: nvl(per_pps_shd.g_old_rec.information11, hr_api.g_varchar2) <>
840: nvl(p_rec.information11, hr_api.g_varchar2) or
841: nvl(per_pps_shd.g_old_rec.information12, hr_api.g_varchar2) <>

Line 838: nvl(p_rec.information10, hr_api.g_varchar2) or

834: nvl(p_rec.information8, hr_api.g_varchar2) or
835: nvl(per_pps_shd.g_old_rec.information9, hr_api.g_varchar2) <>
836: nvl(p_rec.information9, hr_api.g_varchar2) or
837: nvl(per_pps_shd.g_old_rec.information10, hr_api.g_varchar2) <>
838: nvl(p_rec.information10, hr_api.g_varchar2) or
839: nvl(per_pps_shd.g_old_rec.information11, hr_api.g_varchar2) <>
840: nvl(p_rec.information11, hr_api.g_varchar2) or
841: nvl(per_pps_shd.g_old_rec.information12, hr_api.g_varchar2) <>
842: nvl(p_rec.information12, hr_api.g_varchar2) or

Line 839: nvl(per_pps_shd.g_old_rec.information11, hr_api.g_varchar2) <>

835: nvl(per_pps_shd.g_old_rec.information9, hr_api.g_varchar2) <>
836: nvl(p_rec.information9, hr_api.g_varchar2) or
837: nvl(per_pps_shd.g_old_rec.information10, hr_api.g_varchar2) <>
838: nvl(p_rec.information10, hr_api.g_varchar2) or
839: nvl(per_pps_shd.g_old_rec.information11, hr_api.g_varchar2) <>
840: nvl(p_rec.information11, hr_api.g_varchar2) or
841: nvl(per_pps_shd.g_old_rec.information12, hr_api.g_varchar2) <>
842: nvl(p_rec.information12, hr_api.g_varchar2) or
843: nvl(per_pps_shd.g_old_rec.information13, hr_api.g_varchar2) <>

Line 840: nvl(p_rec.information11, hr_api.g_varchar2) or

836: nvl(p_rec.information9, hr_api.g_varchar2) or
837: nvl(per_pps_shd.g_old_rec.information10, hr_api.g_varchar2) <>
838: nvl(p_rec.information10, hr_api.g_varchar2) or
839: nvl(per_pps_shd.g_old_rec.information11, hr_api.g_varchar2) <>
840: nvl(p_rec.information11, hr_api.g_varchar2) or
841: nvl(per_pps_shd.g_old_rec.information12, hr_api.g_varchar2) <>
842: nvl(p_rec.information12, hr_api.g_varchar2) or
843: nvl(per_pps_shd.g_old_rec.information13, hr_api.g_varchar2) <>
844: nvl(p_rec.information13, hr_api.g_varchar2) or

Line 841: nvl(per_pps_shd.g_old_rec.information12, hr_api.g_varchar2) <>

837: nvl(per_pps_shd.g_old_rec.information10, hr_api.g_varchar2) <>
838: nvl(p_rec.information10, hr_api.g_varchar2) or
839: nvl(per_pps_shd.g_old_rec.information11, hr_api.g_varchar2) <>
840: nvl(p_rec.information11, hr_api.g_varchar2) or
841: nvl(per_pps_shd.g_old_rec.information12, hr_api.g_varchar2) <>
842: nvl(p_rec.information12, hr_api.g_varchar2) or
843: nvl(per_pps_shd.g_old_rec.information13, hr_api.g_varchar2) <>
844: nvl(p_rec.information13, hr_api.g_varchar2) or
845: nvl(per_pps_shd.g_old_rec.information14, hr_api.g_varchar2) <>

Line 842: nvl(p_rec.information12, hr_api.g_varchar2) or

838: nvl(p_rec.information10, hr_api.g_varchar2) or
839: nvl(per_pps_shd.g_old_rec.information11, hr_api.g_varchar2) <>
840: nvl(p_rec.information11, hr_api.g_varchar2) or
841: nvl(per_pps_shd.g_old_rec.information12, hr_api.g_varchar2) <>
842: nvl(p_rec.information12, hr_api.g_varchar2) or
843: nvl(per_pps_shd.g_old_rec.information13, hr_api.g_varchar2) <>
844: nvl(p_rec.information13, hr_api.g_varchar2) or
845: nvl(per_pps_shd.g_old_rec.information14, hr_api.g_varchar2) <>
846: nvl(p_rec.information14, hr_api.g_varchar2) or

Line 843: nvl(per_pps_shd.g_old_rec.information13, hr_api.g_varchar2) <>

839: nvl(per_pps_shd.g_old_rec.information11, hr_api.g_varchar2) <>
840: nvl(p_rec.information11, hr_api.g_varchar2) or
841: nvl(per_pps_shd.g_old_rec.information12, hr_api.g_varchar2) <>
842: nvl(p_rec.information12, hr_api.g_varchar2) or
843: nvl(per_pps_shd.g_old_rec.information13, hr_api.g_varchar2) <>
844: nvl(p_rec.information13, hr_api.g_varchar2) or
845: nvl(per_pps_shd.g_old_rec.information14, hr_api.g_varchar2) <>
846: nvl(p_rec.information14, hr_api.g_varchar2) or
847: nvl(per_pps_shd.g_old_rec.information15, hr_api.g_varchar2) <>

Line 844: nvl(p_rec.information13, hr_api.g_varchar2) or

840: nvl(p_rec.information11, hr_api.g_varchar2) or
841: nvl(per_pps_shd.g_old_rec.information12, hr_api.g_varchar2) <>
842: nvl(p_rec.information12, hr_api.g_varchar2) or
843: nvl(per_pps_shd.g_old_rec.information13, hr_api.g_varchar2) <>
844: nvl(p_rec.information13, hr_api.g_varchar2) or
845: nvl(per_pps_shd.g_old_rec.information14, hr_api.g_varchar2) <>
846: nvl(p_rec.information14, hr_api.g_varchar2) or
847: nvl(per_pps_shd.g_old_rec.information15, hr_api.g_varchar2) <>
848: nvl(p_rec.information15, hr_api.g_varchar2) or

Line 845: nvl(per_pps_shd.g_old_rec.information14, hr_api.g_varchar2) <>

841: nvl(per_pps_shd.g_old_rec.information12, hr_api.g_varchar2) <>
842: nvl(p_rec.information12, hr_api.g_varchar2) or
843: nvl(per_pps_shd.g_old_rec.information13, hr_api.g_varchar2) <>
844: nvl(p_rec.information13, hr_api.g_varchar2) or
845: nvl(per_pps_shd.g_old_rec.information14, hr_api.g_varchar2) <>
846: nvl(p_rec.information14, hr_api.g_varchar2) or
847: nvl(per_pps_shd.g_old_rec.information15, hr_api.g_varchar2) <>
848: nvl(p_rec.information15, hr_api.g_varchar2) or
849: nvl(per_pps_shd.g_old_rec.information16, hr_api.g_varchar2) <>

Line 846: nvl(p_rec.information14, hr_api.g_varchar2) or

842: nvl(p_rec.information12, hr_api.g_varchar2) or
843: nvl(per_pps_shd.g_old_rec.information13, hr_api.g_varchar2) <>
844: nvl(p_rec.information13, hr_api.g_varchar2) or
845: nvl(per_pps_shd.g_old_rec.information14, hr_api.g_varchar2) <>
846: nvl(p_rec.information14, hr_api.g_varchar2) or
847: nvl(per_pps_shd.g_old_rec.information15, hr_api.g_varchar2) <>
848: nvl(p_rec.information15, hr_api.g_varchar2) or
849: nvl(per_pps_shd.g_old_rec.information16, hr_api.g_varchar2) <>
850: nvl(p_rec.information16, hr_api.g_varchar2) or

Line 847: nvl(per_pps_shd.g_old_rec.information15, hr_api.g_varchar2) <>

843: nvl(per_pps_shd.g_old_rec.information13, hr_api.g_varchar2) <>
844: nvl(p_rec.information13, hr_api.g_varchar2) or
845: nvl(per_pps_shd.g_old_rec.information14, hr_api.g_varchar2) <>
846: nvl(p_rec.information14, hr_api.g_varchar2) or
847: nvl(per_pps_shd.g_old_rec.information15, hr_api.g_varchar2) <>
848: nvl(p_rec.information15, hr_api.g_varchar2) or
849: nvl(per_pps_shd.g_old_rec.information16, hr_api.g_varchar2) <>
850: nvl(p_rec.information16, hr_api.g_varchar2) or
851: nvl(per_pps_shd.g_old_rec.information17, hr_api.g_varchar2) <>

Line 848: nvl(p_rec.information15, hr_api.g_varchar2) or

844: nvl(p_rec.information13, hr_api.g_varchar2) or
845: nvl(per_pps_shd.g_old_rec.information14, hr_api.g_varchar2) <>
846: nvl(p_rec.information14, hr_api.g_varchar2) or
847: nvl(per_pps_shd.g_old_rec.information15, hr_api.g_varchar2) <>
848: nvl(p_rec.information15, hr_api.g_varchar2) or
849: nvl(per_pps_shd.g_old_rec.information16, hr_api.g_varchar2) <>
850: nvl(p_rec.information16, hr_api.g_varchar2) or
851: nvl(per_pps_shd.g_old_rec.information17, hr_api.g_varchar2) <>
852: nvl(p_rec.information17, hr_api.g_varchar2) or

Line 849: nvl(per_pps_shd.g_old_rec.information16, hr_api.g_varchar2) <>

845: nvl(per_pps_shd.g_old_rec.information14, hr_api.g_varchar2) <>
846: nvl(p_rec.information14, hr_api.g_varchar2) or
847: nvl(per_pps_shd.g_old_rec.information15, hr_api.g_varchar2) <>
848: nvl(p_rec.information15, hr_api.g_varchar2) or
849: nvl(per_pps_shd.g_old_rec.information16, hr_api.g_varchar2) <>
850: nvl(p_rec.information16, hr_api.g_varchar2) or
851: nvl(per_pps_shd.g_old_rec.information17, hr_api.g_varchar2) <>
852: nvl(p_rec.information17, hr_api.g_varchar2) or
853: nvl(per_pps_shd.g_old_rec.information18, hr_api.g_varchar2) <>

Line 850: nvl(p_rec.information16, hr_api.g_varchar2) or

846: nvl(p_rec.information14, hr_api.g_varchar2) or
847: nvl(per_pps_shd.g_old_rec.information15, hr_api.g_varchar2) <>
848: nvl(p_rec.information15, hr_api.g_varchar2) or
849: nvl(per_pps_shd.g_old_rec.information16, hr_api.g_varchar2) <>
850: nvl(p_rec.information16, hr_api.g_varchar2) or
851: nvl(per_pps_shd.g_old_rec.information17, hr_api.g_varchar2) <>
852: nvl(p_rec.information17, hr_api.g_varchar2) or
853: nvl(per_pps_shd.g_old_rec.information18, hr_api.g_varchar2) <>
854: nvl(p_rec.information18, hr_api.g_varchar2) or

Line 851: nvl(per_pps_shd.g_old_rec.information17, hr_api.g_varchar2) <>

847: nvl(per_pps_shd.g_old_rec.information15, hr_api.g_varchar2) <>
848: nvl(p_rec.information15, hr_api.g_varchar2) or
849: nvl(per_pps_shd.g_old_rec.information16, hr_api.g_varchar2) <>
850: nvl(p_rec.information16, hr_api.g_varchar2) or
851: nvl(per_pps_shd.g_old_rec.information17, hr_api.g_varchar2) <>
852: nvl(p_rec.information17, hr_api.g_varchar2) or
853: nvl(per_pps_shd.g_old_rec.information18, hr_api.g_varchar2) <>
854: nvl(p_rec.information18, hr_api.g_varchar2) or
855: nvl(per_pps_shd.g_old_rec.information19, hr_api.g_varchar2) <>

Line 852: nvl(p_rec.information17, hr_api.g_varchar2) or

848: nvl(p_rec.information15, hr_api.g_varchar2) or
849: nvl(per_pps_shd.g_old_rec.information16, hr_api.g_varchar2) <>
850: nvl(p_rec.information16, hr_api.g_varchar2) or
851: nvl(per_pps_shd.g_old_rec.information17, hr_api.g_varchar2) <>
852: nvl(p_rec.information17, hr_api.g_varchar2) or
853: nvl(per_pps_shd.g_old_rec.information18, hr_api.g_varchar2) <>
854: nvl(p_rec.information18, hr_api.g_varchar2) or
855: nvl(per_pps_shd.g_old_rec.information19, hr_api.g_varchar2) <>
856: nvl(p_rec.information19, hr_api.g_varchar2) or

Line 853: nvl(per_pps_shd.g_old_rec.information18, hr_api.g_varchar2) <>

849: nvl(per_pps_shd.g_old_rec.information16, hr_api.g_varchar2) <>
850: nvl(p_rec.information16, hr_api.g_varchar2) or
851: nvl(per_pps_shd.g_old_rec.information17, hr_api.g_varchar2) <>
852: nvl(p_rec.information17, hr_api.g_varchar2) or
853: nvl(per_pps_shd.g_old_rec.information18, hr_api.g_varchar2) <>
854: nvl(p_rec.information18, hr_api.g_varchar2) or
855: nvl(per_pps_shd.g_old_rec.information19, hr_api.g_varchar2) <>
856: nvl(p_rec.information19, hr_api.g_varchar2) or
857: nvl(per_pps_shd.g_old_rec.information20, hr_api.g_varchar2) <>

Line 854: nvl(p_rec.information18, hr_api.g_varchar2) or

850: nvl(p_rec.information16, hr_api.g_varchar2) or
851: nvl(per_pps_shd.g_old_rec.information17, hr_api.g_varchar2) <>
852: nvl(p_rec.information17, hr_api.g_varchar2) or
853: nvl(per_pps_shd.g_old_rec.information18, hr_api.g_varchar2) <>
854: nvl(p_rec.information18, hr_api.g_varchar2) or
855: nvl(per_pps_shd.g_old_rec.information19, hr_api.g_varchar2) <>
856: nvl(p_rec.information19, hr_api.g_varchar2) or
857: nvl(per_pps_shd.g_old_rec.information20, hr_api.g_varchar2) <>
858: nvl(p_rec.information20, hr_api.g_varchar2) or

Line 855: nvl(per_pps_shd.g_old_rec.information19, hr_api.g_varchar2) <>

851: nvl(per_pps_shd.g_old_rec.information17, hr_api.g_varchar2) <>
852: nvl(p_rec.information17, hr_api.g_varchar2) or
853: nvl(per_pps_shd.g_old_rec.information18, hr_api.g_varchar2) <>
854: nvl(p_rec.information18, hr_api.g_varchar2) or
855: nvl(per_pps_shd.g_old_rec.information19, hr_api.g_varchar2) <>
856: nvl(p_rec.information19, hr_api.g_varchar2) or
857: nvl(per_pps_shd.g_old_rec.information20, hr_api.g_varchar2) <>
858: nvl(p_rec.information20, hr_api.g_varchar2) or
859: nvl(per_pps_shd.g_old_rec.information21, hr_api.g_varchar2) <>

Line 856: nvl(p_rec.information19, hr_api.g_varchar2) or

852: nvl(p_rec.information17, hr_api.g_varchar2) or
853: nvl(per_pps_shd.g_old_rec.information18, hr_api.g_varchar2) <>
854: nvl(p_rec.information18, hr_api.g_varchar2) or
855: nvl(per_pps_shd.g_old_rec.information19, hr_api.g_varchar2) <>
856: nvl(p_rec.information19, hr_api.g_varchar2) or
857: nvl(per_pps_shd.g_old_rec.information20, hr_api.g_varchar2) <>
858: nvl(p_rec.information20, hr_api.g_varchar2) or
859: nvl(per_pps_shd.g_old_rec.information21, hr_api.g_varchar2) <>
860: nvl(p_rec.information21, hr_api.g_varchar2) or

Line 857: nvl(per_pps_shd.g_old_rec.information20, hr_api.g_varchar2) <>

853: nvl(per_pps_shd.g_old_rec.information18, hr_api.g_varchar2) <>
854: nvl(p_rec.information18, hr_api.g_varchar2) or
855: nvl(per_pps_shd.g_old_rec.information19, hr_api.g_varchar2) <>
856: nvl(p_rec.information19, hr_api.g_varchar2) or
857: nvl(per_pps_shd.g_old_rec.information20, hr_api.g_varchar2) <>
858: nvl(p_rec.information20, hr_api.g_varchar2) or
859: nvl(per_pps_shd.g_old_rec.information21, hr_api.g_varchar2) <>
860: nvl(p_rec.information21, hr_api.g_varchar2) or
861: nvl(per_pps_shd.g_old_rec.information22, hr_api.g_varchar2) <>

Line 858: nvl(p_rec.information20, hr_api.g_varchar2) or

854: nvl(p_rec.information18, hr_api.g_varchar2) or
855: nvl(per_pps_shd.g_old_rec.information19, hr_api.g_varchar2) <>
856: nvl(p_rec.information19, hr_api.g_varchar2) or
857: nvl(per_pps_shd.g_old_rec.information20, hr_api.g_varchar2) <>
858: nvl(p_rec.information20, hr_api.g_varchar2) or
859: nvl(per_pps_shd.g_old_rec.information21, hr_api.g_varchar2) <>
860: nvl(p_rec.information21, hr_api.g_varchar2) or
861: nvl(per_pps_shd.g_old_rec.information22, hr_api.g_varchar2) <>
862: nvl(p_rec.information22, hr_api.g_varchar2) or

Line 859: nvl(per_pps_shd.g_old_rec.information21, hr_api.g_varchar2) <>

855: nvl(per_pps_shd.g_old_rec.information19, hr_api.g_varchar2) <>
856: nvl(p_rec.information19, hr_api.g_varchar2) or
857: nvl(per_pps_shd.g_old_rec.information20, hr_api.g_varchar2) <>
858: nvl(p_rec.information20, hr_api.g_varchar2) or
859: nvl(per_pps_shd.g_old_rec.information21, hr_api.g_varchar2) <>
860: nvl(p_rec.information21, hr_api.g_varchar2) or
861: nvl(per_pps_shd.g_old_rec.information22, hr_api.g_varchar2) <>
862: nvl(p_rec.information22, hr_api.g_varchar2) or
863: nvl(per_pps_shd.g_old_rec.information23, hr_api.g_varchar2) <>

Line 860: nvl(p_rec.information21, hr_api.g_varchar2) or

856: nvl(p_rec.information19, hr_api.g_varchar2) or
857: nvl(per_pps_shd.g_old_rec.information20, hr_api.g_varchar2) <>
858: nvl(p_rec.information20, hr_api.g_varchar2) or
859: nvl(per_pps_shd.g_old_rec.information21, hr_api.g_varchar2) <>
860: nvl(p_rec.information21, hr_api.g_varchar2) or
861: nvl(per_pps_shd.g_old_rec.information22, hr_api.g_varchar2) <>
862: nvl(p_rec.information22, hr_api.g_varchar2) or
863: nvl(per_pps_shd.g_old_rec.information23, hr_api.g_varchar2) <>
864: nvl(p_rec.information23, hr_api.g_varchar2) or

Line 861: nvl(per_pps_shd.g_old_rec.information22, hr_api.g_varchar2) <>

857: nvl(per_pps_shd.g_old_rec.information20, hr_api.g_varchar2) <>
858: nvl(p_rec.information20, hr_api.g_varchar2) or
859: nvl(per_pps_shd.g_old_rec.information21, hr_api.g_varchar2) <>
860: nvl(p_rec.information21, hr_api.g_varchar2) or
861: nvl(per_pps_shd.g_old_rec.information22, hr_api.g_varchar2) <>
862: nvl(p_rec.information22, hr_api.g_varchar2) or
863: nvl(per_pps_shd.g_old_rec.information23, hr_api.g_varchar2) <>
864: nvl(p_rec.information23, hr_api.g_varchar2) or
865: nvl(per_pps_shd.g_old_rec.information24, hr_api.g_varchar2) <>

Line 862: nvl(p_rec.information22, hr_api.g_varchar2) or

858: nvl(p_rec.information20, hr_api.g_varchar2) or
859: nvl(per_pps_shd.g_old_rec.information21, hr_api.g_varchar2) <>
860: nvl(p_rec.information21, hr_api.g_varchar2) or
861: nvl(per_pps_shd.g_old_rec.information22, hr_api.g_varchar2) <>
862: nvl(p_rec.information22, hr_api.g_varchar2) or
863: nvl(per_pps_shd.g_old_rec.information23, hr_api.g_varchar2) <>
864: nvl(p_rec.information23, hr_api.g_varchar2) or
865: nvl(per_pps_shd.g_old_rec.information24, hr_api.g_varchar2) <>
866: nvl(p_rec.information24, hr_api.g_varchar2) or

Line 863: nvl(per_pps_shd.g_old_rec.information23, hr_api.g_varchar2) <>

859: nvl(per_pps_shd.g_old_rec.information21, hr_api.g_varchar2) <>
860: nvl(p_rec.information21, hr_api.g_varchar2) or
861: nvl(per_pps_shd.g_old_rec.information22, hr_api.g_varchar2) <>
862: nvl(p_rec.information22, hr_api.g_varchar2) or
863: nvl(per_pps_shd.g_old_rec.information23, hr_api.g_varchar2) <>
864: nvl(p_rec.information23, hr_api.g_varchar2) or
865: nvl(per_pps_shd.g_old_rec.information24, hr_api.g_varchar2) <>
866: nvl(p_rec.information24, hr_api.g_varchar2) or
867: nvl(per_pps_shd.g_old_rec.information25, hr_api.g_varchar2) <>

Line 864: nvl(p_rec.information23, hr_api.g_varchar2) or

860: nvl(p_rec.information21, hr_api.g_varchar2) or
861: nvl(per_pps_shd.g_old_rec.information22, hr_api.g_varchar2) <>
862: nvl(p_rec.information22, hr_api.g_varchar2) or
863: nvl(per_pps_shd.g_old_rec.information23, hr_api.g_varchar2) <>
864: nvl(p_rec.information23, hr_api.g_varchar2) or
865: nvl(per_pps_shd.g_old_rec.information24, hr_api.g_varchar2) <>
866: nvl(p_rec.information24, hr_api.g_varchar2) or
867: nvl(per_pps_shd.g_old_rec.information25, hr_api.g_varchar2) <>
868: nvl(p_rec.information25, hr_api.g_varchar2) or

Line 865: nvl(per_pps_shd.g_old_rec.information24, hr_api.g_varchar2) <>

861: nvl(per_pps_shd.g_old_rec.information22, hr_api.g_varchar2) <>
862: nvl(p_rec.information22, hr_api.g_varchar2) or
863: nvl(per_pps_shd.g_old_rec.information23, hr_api.g_varchar2) <>
864: nvl(p_rec.information23, hr_api.g_varchar2) or
865: nvl(per_pps_shd.g_old_rec.information24, hr_api.g_varchar2) <>
866: nvl(p_rec.information24, hr_api.g_varchar2) or
867: nvl(per_pps_shd.g_old_rec.information25, hr_api.g_varchar2) <>
868: nvl(p_rec.information25, hr_api.g_varchar2) or
869: nvl(per_pps_shd.g_old_rec.information26, hr_api.g_varchar2) <>

Line 866: nvl(p_rec.information24, hr_api.g_varchar2) or

862: nvl(p_rec.information22, hr_api.g_varchar2) or
863: nvl(per_pps_shd.g_old_rec.information23, hr_api.g_varchar2) <>
864: nvl(p_rec.information23, hr_api.g_varchar2) or
865: nvl(per_pps_shd.g_old_rec.information24, hr_api.g_varchar2) <>
866: nvl(p_rec.information24, hr_api.g_varchar2) or
867: nvl(per_pps_shd.g_old_rec.information25, hr_api.g_varchar2) <>
868: nvl(p_rec.information25, hr_api.g_varchar2) or
869: nvl(per_pps_shd.g_old_rec.information26, hr_api.g_varchar2) <>
870: nvl(p_rec.information26, hr_api.g_varchar2) or

Line 867: nvl(per_pps_shd.g_old_rec.information25, hr_api.g_varchar2) <>

863: nvl(per_pps_shd.g_old_rec.information23, hr_api.g_varchar2) <>
864: nvl(p_rec.information23, hr_api.g_varchar2) or
865: nvl(per_pps_shd.g_old_rec.information24, hr_api.g_varchar2) <>
866: nvl(p_rec.information24, hr_api.g_varchar2) or
867: nvl(per_pps_shd.g_old_rec.information25, hr_api.g_varchar2) <>
868: nvl(p_rec.information25, hr_api.g_varchar2) or
869: nvl(per_pps_shd.g_old_rec.information26, hr_api.g_varchar2) <>
870: nvl(p_rec.information26, hr_api.g_varchar2) or
871: nvl(per_pps_shd.g_old_rec.information27, hr_api.g_varchar2) <>

Line 868: nvl(p_rec.information25, hr_api.g_varchar2) or

864: nvl(p_rec.information23, hr_api.g_varchar2) or
865: nvl(per_pps_shd.g_old_rec.information24, hr_api.g_varchar2) <>
866: nvl(p_rec.information24, hr_api.g_varchar2) or
867: nvl(per_pps_shd.g_old_rec.information25, hr_api.g_varchar2) <>
868: nvl(p_rec.information25, hr_api.g_varchar2) or
869: nvl(per_pps_shd.g_old_rec.information26, hr_api.g_varchar2) <>
870: nvl(p_rec.information26, hr_api.g_varchar2) or
871: nvl(per_pps_shd.g_old_rec.information27, hr_api.g_varchar2) <>
872: nvl(p_rec.information27, hr_api.g_varchar2) or

Line 869: nvl(per_pps_shd.g_old_rec.information26, hr_api.g_varchar2) <>

865: nvl(per_pps_shd.g_old_rec.information24, hr_api.g_varchar2) <>
866: nvl(p_rec.information24, hr_api.g_varchar2) or
867: nvl(per_pps_shd.g_old_rec.information25, hr_api.g_varchar2) <>
868: nvl(p_rec.information25, hr_api.g_varchar2) or
869: nvl(per_pps_shd.g_old_rec.information26, hr_api.g_varchar2) <>
870: nvl(p_rec.information26, hr_api.g_varchar2) or
871: nvl(per_pps_shd.g_old_rec.information27, hr_api.g_varchar2) <>
872: nvl(p_rec.information27, hr_api.g_varchar2) or
873: nvl(per_pps_shd.g_old_rec.information28, hr_api.g_varchar2) <>

Line 870: nvl(p_rec.information26, hr_api.g_varchar2) or

866: nvl(p_rec.information24, hr_api.g_varchar2) or
867: nvl(per_pps_shd.g_old_rec.information25, hr_api.g_varchar2) <>
868: nvl(p_rec.information25, hr_api.g_varchar2) or
869: nvl(per_pps_shd.g_old_rec.information26, hr_api.g_varchar2) <>
870: nvl(p_rec.information26, hr_api.g_varchar2) or
871: nvl(per_pps_shd.g_old_rec.information27, hr_api.g_varchar2) <>
872: nvl(p_rec.information27, hr_api.g_varchar2) or
873: nvl(per_pps_shd.g_old_rec.information28, hr_api.g_varchar2) <>
874: nvl(p_rec.information28, hr_api.g_varchar2) or

Line 871: nvl(per_pps_shd.g_old_rec.information27, hr_api.g_varchar2) <>

867: nvl(per_pps_shd.g_old_rec.information25, hr_api.g_varchar2) <>
868: nvl(p_rec.information25, hr_api.g_varchar2) or
869: nvl(per_pps_shd.g_old_rec.information26, hr_api.g_varchar2) <>
870: nvl(p_rec.information26, hr_api.g_varchar2) or
871: nvl(per_pps_shd.g_old_rec.information27, hr_api.g_varchar2) <>
872: nvl(p_rec.information27, hr_api.g_varchar2) or
873: nvl(per_pps_shd.g_old_rec.information28, hr_api.g_varchar2) <>
874: nvl(p_rec.information28, hr_api.g_varchar2) or
875: nvl(per_pps_shd.g_old_rec.information29, hr_api.g_varchar2) <>

Line 872: nvl(p_rec.information27, hr_api.g_varchar2) or

868: nvl(p_rec.information25, hr_api.g_varchar2) or
869: nvl(per_pps_shd.g_old_rec.information26, hr_api.g_varchar2) <>
870: nvl(p_rec.information26, hr_api.g_varchar2) or
871: nvl(per_pps_shd.g_old_rec.information27, hr_api.g_varchar2) <>
872: nvl(p_rec.information27, hr_api.g_varchar2) or
873: nvl(per_pps_shd.g_old_rec.information28, hr_api.g_varchar2) <>
874: nvl(p_rec.information28, hr_api.g_varchar2) or
875: nvl(per_pps_shd.g_old_rec.information29, hr_api.g_varchar2) <>
876: nvl(p_rec.information29, hr_api.g_varchar2) or

Line 873: nvl(per_pps_shd.g_old_rec.information28, hr_api.g_varchar2) <>

869: nvl(per_pps_shd.g_old_rec.information26, hr_api.g_varchar2) <>
870: nvl(p_rec.information26, hr_api.g_varchar2) or
871: nvl(per_pps_shd.g_old_rec.information27, hr_api.g_varchar2) <>
872: nvl(p_rec.information27, hr_api.g_varchar2) or
873: nvl(per_pps_shd.g_old_rec.information28, hr_api.g_varchar2) <>
874: nvl(p_rec.information28, hr_api.g_varchar2) or
875: nvl(per_pps_shd.g_old_rec.information29, hr_api.g_varchar2) <>
876: nvl(p_rec.information29, hr_api.g_varchar2) or
877: nvl(per_pps_shd.g_old_rec.information30, hr_api.g_varchar2) <>

Line 874: nvl(p_rec.information28, hr_api.g_varchar2) or

870: nvl(p_rec.information26, hr_api.g_varchar2) or
871: nvl(per_pps_shd.g_old_rec.information27, hr_api.g_varchar2) <>
872: nvl(p_rec.information27, hr_api.g_varchar2) or
873: nvl(per_pps_shd.g_old_rec.information28, hr_api.g_varchar2) <>
874: nvl(p_rec.information28, hr_api.g_varchar2) or
875: nvl(per_pps_shd.g_old_rec.information29, hr_api.g_varchar2) <>
876: nvl(p_rec.information29, hr_api.g_varchar2) or
877: nvl(per_pps_shd.g_old_rec.information30, hr_api.g_varchar2) <>
878: nvl(p_rec.information30, hr_api.g_varchar2) ))

Line 875: nvl(per_pps_shd.g_old_rec.information29, hr_api.g_varchar2) <>

871: nvl(per_pps_shd.g_old_rec.information27, hr_api.g_varchar2) <>
872: nvl(p_rec.information27, hr_api.g_varchar2) or
873: nvl(per_pps_shd.g_old_rec.information28, hr_api.g_varchar2) <>
874: nvl(p_rec.information28, hr_api.g_varchar2) or
875: nvl(per_pps_shd.g_old_rec.information29, hr_api.g_varchar2) <>
876: nvl(p_rec.information29, hr_api.g_varchar2) or
877: nvl(per_pps_shd.g_old_rec.information30, hr_api.g_varchar2) <>
878: nvl(p_rec.information30, hr_api.g_varchar2) ))
879: or (p_rec.parent_spine_id is null) then

Line 876: nvl(p_rec.information29, hr_api.g_varchar2) or

872: nvl(p_rec.information27, hr_api.g_varchar2) or
873: nvl(per_pps_shd.g_old_rec.information28, hr_api.g_varchar2) <>
874: nvl(p_rec.information28, hr_api.g_varchar2) or
875: nvl(per_pps_shd.g_old_rec.information29, hr_api.g_varchar2) <>
876: nvl(p_rec.information29, hr_api.g_varchar2) or
877: nvl(per_pps_shd.g_old_rec.information30, hr_api.g_varchar2) <>
878: nvl(p_rec.information30, hr_api.g_varchar2) ))
879: or (p_rec.parent_spine_id is null) then
880: --

Line 877: nvl(per_pps_shd.g_old_rec.information30, hr_api.g_varchar2) <>

873: nvl(per_pps_shd.g_old_rec.information28, hr_api.g_varchar2) <>
874: nvl(p_rec.information28, hr_api.g_varchar2) or
875: nvl(per_pps_shd.g_old_rec.information29, hr_api.g_varchar2) <>
876: nvl(p_rec.information29, hr_api.g_varchar2) or
877: nvl(per_pps_shd.g_old_rec.information30, hr_api.g_varchar2) <>
878: nvl(p_rec.information30, hr_api.g_varchar2) ))
879: or (p_rec.parent_spine_id is null) then
880: --
881: -- Only execute the validation if absolutely necessary:

Line 878: nvl(p_rec.information30, hr_api.g_varchar2) ))

874: nvl(p_rec.information28, hr_api.g_varchar2) or
875: nvl(per_pps_shd.g_old_rec.information29, hr_api.g_varchar2) <>
876: nvl(p_rec.information29, hr_api.g_varchar2) or
877: nvl(per_pps_shd.g_old_rec.information30, hr_api.g_varchar2) <>
878: nvl(p_rec.information30, hr_api.g_varchar2) ))
879: or (p_rec.parent_spine_id is null) then
880: --
881: -- Only execute the validation if absolutely necessary:
882: -- a) During update, the structure column value or any

Line 1007: IF nvl(p_rec.business_group_id, hr_api.g_number) <>

1003: fnd_message.set_token('STEP ', '5');
1004: fnd_message.raise_error;
1005: END IF;
1006: --
1007: IF nvl(p_rec.business_group_id, hr_api.g_number) <>
1008: per_pps_shd.g_old_rec.business_group_id then
1009: hr_api.argument_changed_error
1010: (p_api_name => l_proc
1011: ,p_argument => 'BUSINESS_GROUP_ID'

Line 1009: hr_api.argument_changed_error

1005: END IF;
1006: --
1007: IF nvl(p_rec.business_group_id, hr_api.g_number) <>
1008: per_pps_shd.g_old_rec.business_group_id then
1009: hr_api.argument_changed_error
1010: (p_api_name => l_proc
1011: ,p_argument => 'BUSINESS_GROUP_ID'
1012: ,p_base_table => per_pps_shd.g_tab_nam
1013: );

Line 1035: hr_api.validate_bus_grp_id

1031:
1032: --
1033: -- Call all supporting business operations
1034: --
1035: hr_api.validate_bus_grp_id
1036: (p_business_group_id => p_rec.business_group_id
1037: ,p_associated_column1 => per_pps_shd.g_tab_nam
1038: || '.BUSINESS_GROUP_ID');
1039: --

Line 1134: hr_api.validate_bus_grp_id

1130: hr_utility.set_location('Entering:'||l_proc, 10);
1131: --
1132: -- Call all supporting business operations
1133: --
1134: hr_api.validate_bus_grp_id
1135: (p_business_group_id => p_rec.business_group_id
1136: ,p_associated_column1 => per_pps_shd.g_tab_nam
1137: || '.BUSINESS_GROUP_ID');
1138: