33: hr_utility.set_location('Entering:'|| l_proc, 10);
34: --
35: -- Ensure that all the mandatory parameter are not null
36: --
37: hr_api.mandatory_arg_error
38: (p_api_name => l_proc
39: ,p_argument => 'pending_data_id'
40: ,p_argument_value => p_pending_data_id
41: );
64: hr_utility.set_location('Entering:'|| l_proc, 10);
65: --
66: -- Ensure that all the mandatory parameter are not null
67: --
68: hr_api.mandatory_arg_error
69: (p_api_name => l_proc
70: ,p_argument => 'pending_data_id'
71: ,p_argument_value => p_pending_data_id
72: );
112: begin
113: hr_utility.set_location('Entering:'||l_proc,10);
114: --
115: if ((p_rec.pending_data_id is not null) and (
116: nvl(irc_ipd_shd.g_old_rec.per_information_category, hr_api.g_varchar2) <>
117: nvl(p_rec.per_information_category, hr_api.g_varchar2) or
118: nvl(irc_ipd_shd.g_old_rec.per_information1, hr_api.g_varchar2) <>
119: nvl(p_rec.per_information1, hr_api.g_varchar2) or
120: nvl(irc_ipd_shd.g_old_rec.per_information2, hr_api.g_varchar2) <>
113: hr_utility.set_location('Entering:'||l_proc,10);
114: --
115: if ((p_rec.pending_data_id is not null) and (
116: nvl(irc_ipd_shd.g_old_rec.per_information_category, hr_api.g_varchar2) <>
117: nvl(p_rec.per_information_category, hr_api.g_varchar2) or
118: nvl(irc_ipd_shd.g_old_rec.per_information1, hr_api.g_varchar2) <>
119: nvl(p_rec.per_information1, hr_api.g_varchar2) or
120: nvl(irc_ipd_shd.g_old_rec.per_information2, hr_api.g_varchar2) <>
121: nvl(p_rec.per_information2, hr_api.g_varchar2) or
114: --
115: if ((p_rec.pending_data_id is not null) and (
116: nvl(irc_ipd_shd.g_old_rec.per_information_category, hr_api.g_varchar2) <>
117: nvl(p_rec.per_information_category, hr_api.g_varchar2) or
118: nvl(irc_ipd_shd.g_old_rec.per_information1, hr_api.g_varchar2) <>
119: nvl(p_rec.per_information1, hr_api.g_varchar2) or
120: nvl(irc_ipd_shd.g_old_rec.per_information2, hr_api.g_varchar2) <>
121: nvl(p_rec.per_information2, hr_api.g_varchar2) or
122: nvl(irc_ipd_shd.g_old_rec.per_information3, hr_api.g_varchar2) <>
115: if ((p_rec.pending_data_id is not null) and (
116: nvl(irc_ipd_shd.g_old_rec.per_information_category, hr_api.g_varchar2) <>
117: nvl(p_rec.per_information_category, hr_api.g_varchar2) or
118: nvl(irc_ipd_shd.g_old_rec.per_information1, hr_api.g_varchar2) <>
119: nvl(p_rec.per_information1, hr_api.g_varchar2) or
120: nvl(irc_ipd_shd.g_old_rec.per_information2, hr_api.g_varchar2) <>
121: nvl(p_rec.per_information2, hr_api.g_varchar2) or
122: nvl(irc_ipd_shd.g_old_rec.per_information3, hr_api.g_varchar2) <>
123: nvl(p_rec.per_information3, hr_api.g_varchar2) or
116: nvl(irc_ipd_shd.g_old_rec.per_information_category, hr_api.g_varchar2) <>
117: nvl(p_rec.per_information_category, hr_api.g_varchar2) or
118: nvl(irc_ipd_shd.g_old_rec.per_information1, hr_api.g_varchar2) <>
119: nvl(p_rec.per_information1, hr_api.g_varchar2) or
120: nvl(irc_ipd_shd.g_old_rec.per_information2, hr_api.g_varchar2) <>
121: nvl(p_rec.per_information2, hr_api.g_varchar2) or
122: nvl(irc_ipd_shd.g_old_rec.per_information3, hr_api.g_varchar2) <>
123: nvl(p_rec.per_information3, hr_api.g_varchar2) or
124: nvl(irc_ipd_shd.g_old_rec.per_information4, hr_api.g_varchar2) <>
117: nvl(p_rec.per_information_category, hr_api.g_varchar2) or
118: nvl(irc_ipd_shd.g_old_rec.per_information1, hr_api.g_varchar2) <>
119: nvl(p_rec.per_information1, hr_api.g_varchar2) or
120: nvl(irc_ipd_shd.g_old_rec.per_information2, hr_api.g_varchar2) <>
121: nvl(p_rec.per_information2, hr_api.g_varchar2) or
122: nvl(irc_ipd_shd.g_old_rec.per_information3, hr_api.g_varchar2) <>
123: nvl(p_rec.per_information3, hr_api.g_varchar2) or
124: nvl(irc_ipd_shd.g_old_rec.per_information4, hr_api.g_varchar2) <>
125: nvl(p_rec.per_information4, hr_api.g_varchar2) or
118: nvl(irc_ipd_shd.g_old_rec.per_information1, hr_api.g_varchar2) <>
119: nvl(p_rec.per_information1, hr_api.g_varchar2) or
120: nvl(irc_ipd_shd.g_old_rec.per_information2, hr_api.g_varchar2) <>
121: nvl(p_rec.per_information2, hr_api.g_varchar2) or
122: nvl(irc_ipd_shd.g_old_rec.per_information3, hr_api.g_varchar2) <>
123: nvl(p_rec.per_information3, hr_api.g_varchar2) or
124: nvl(irc_ipd_shd.g_old_rec.per_information4, hr_api.g_varchar2) <>
125: nvl(p_rec.per_information4, hr_api.g_varchar2) or
126: nvl(irc_ipd_shd.g_old_rec.per_information5, hr_api.g_varchar2) <>
119: nvl(p_rec.per_information1, hr_api.g_varchar2) or
120: nvl(irc_ipd_shd.g_old_rec.per_information2, hr_api.g_varchar2) <>
121: nvl(p_rec.per_information2, hr_api.g_varchar2) or
122: nvl(irc_ipd_shd.g_old_rec.per_information3, hr_api.g_varchar2) <>
123: nvl(p_rec.per_information3, hr_api.g_varchar2) or
124: nvl(irc_ipd_shd.g_old_rec.per_information4, hr_api.g_varchar2) <>
125: nvl(p_rec.per_information4, hr_api.g_varchar2) or
126: nvl(irc_ipd_shd.g_old_rec.per_information5, hr_api.g_varchar2) <>
127: nvl(p_rec.per_information5, hr_api.g_varchar2) or
120: nvl(irc_ipd_shd.g_old_rec.per_information2, hr_api.g_varchar2) <>
121: nvl(p_rec.per_information2, hr_api.g_varchar2) or
122: nvl(irc_ipd_shd.g_old_rec.per_information3, hr_api.g_varchar2) <>
123: nvl(p_rec.per_information3, hr_api.g_varchar2) or
124: nvl(irc_ipd_shd.g_old_rec.per_information4, hr_api.g_varchar2) <>
125: nvl(p_rec.per_information4, hr_api.g_varchar2) or
126: nvl(irc_ipd_shd.g_old_rec.per_information5, hr_api.g_varchar2) <>
127: nvl(p_rec.per_information5, hr_api.g_varchar2) or
128: nvl(irc_ipd_shd.g_old_rec.per_information6, hr_api.g_varchar2) <>
121: nvl(p_rec.per_information2, hr_api.g_varchar2) or
122: nvl(irc_ipd_shd.g_old_rec.per_information3, hr_api.g_varchar2) <>
123: nvl(p_rec.per_information3, hr_api.g_varchar2) or
124: nvl(irc_ipd_shd.g_old_rec.per_information4, hr_api.g_varchar2) <>
125: nvl(p_rec.per_information4, hr_api.g_varchar2) or
126: nvl(irc_ipd_shd.g_old_rec.per_information5, hr_api.g_varchar2) <>
127: nvl(p_rec.per_information5, hr_api.g_varchar2) or
128: nvl(irc_ipd_shd.g_old_rec.per_information6, hr_api.g_varchar2) <>
129: nvl(p_rec.per_information6, hr_api.g_varchar2) or
122: nvl(irc_ipd_shd.g_old_rec.per_information3, hr_api.g_varchar2) <>
123: nvl(p_rec.per_information3, hr_api.g_varchar2) or
124: nvl(irc_ipd_shd.g_old_rec.per_information4, hr_api.g_varchar2) <>
125: nvl(p_rec.per_information4, hr_api.g_varchar2) or
126: nvl(irc_ipd_shd.g_old_rec.per_information5, hr_api.g_varchar2) <>
127: nvl(p_rec.per_information5, hr_api.g_varchar2) or
128: nvl(irc_ipd_shd.g_old_rec.per_information6, hr_api.g_varchar2) <>
129: nvl(p_rec.per_information6, hr_api.g_varchar2) or
130: nvl(irc_ipd_shd.g_old_rec.per_information7, hr_api.g_varchar2) <>
123: nvl(p_rec.per_information3, hr_api.g_varchar2) or
124: nvl(irc_ipd_shd.g_old_rec.per_information4, hr_api.g_varchar2) <>
125: nvl(p_rec.per_information4, hr_api.g_varchar2) or
126: nvl(irc_ipd_shd.g_old_rec.per_information5, hr_api.g_varchar2) <>
127: nvl(p_rec.per_information5, hr_api.g_varchar2) or
128: nvl(irc_ipd_shd.g_old_rec.per_information6, hr_api.g_varchar2) <>
129: nvl(p_rec.per_information6, hr_api.g_varchar2) or
130: nvl(irc_ipd_shd.g_old_rec.per_information7, hr_api.g_varchar2) <>
131: nvl(p_rec.per_information7, hr_api.g_varchar2) or
124: nvl(irc_ipd_shd.g_old_rec.per_information4, hr_api.g_varchar2) <>
125: nvl(p_rec.per_information4, hr_api.g_varchar2) or
126: nvl(irc_ipd_shd.g_old_rec.per_information5, hr_api.g_varchar2) <>
127: nvl(p_rec.per_information5, hr_api.g_varchar2) or
128: nvl(irc_ipd_shd.g_old_rec.per_information6, hr_api.g_varchar2) <>
129: nvl(p_rec.per_information6, hr_api.g_varchar2) or
130: nvl(irc_ipd_shd.g_old_rec.per_information7, hr_api.g_varchar2) <>
131: nvl(p_rec.per_information7, hr_api.g_varchar2) or
132: nvl(irc_ipd_shd.g_old_rec.per_information8, hr_api.g_varchar2) <>
125: nvl(p_rec.per_information4, hr_api.g_varchar2) or
126: nvl(irc_ipd_shd.g_old_rec.per_information5, hr_api.g_varchar2) <>
127: nvl(p_rec.per_information5, hr_api.g_varchar2) or
128: nvl(irc_ipd_shd.g_old_rec.per_information6, hr_api.g_varchar2) <>
129: nvl(p_rec.per_information6, hr_api.g_varchar2) or
130: nvl(irc_ipd_shd.g_old_rec.per_information7, hr_api.g_varchar2) <>
131: nvl(p_rec.per_information7, hr_api.g_varchar2) or
132: nvl(irc_ipd_shd.g_old_rec.per_information8, hr_api.g_varchar2) <>
133: nvl(p_rec.per_information8, hr_api.g_varchar2) or
126: nvl(irc_ipd_shd.g_old_rec.per_information5, hr_api.g_varchar2) <>
127: nvl(p_rec.per_information5, hr_api.g_varchar2) or
128: nvl(irc_ipd_shd.g_old_rec.per_information6, hr_api.g_varchar2) <>
129: nvl(p_rec.per_information6, hr_api.g_varchar2) or
130: nvl(irc_ipd_shd.g_old_rec.per_information7, hr_api.g_varchar2) <>
131: nvl(p_rec.per_information7, hr_api.g_varchar2) or
132: nvl(irc_ipd_shd.g_old_rec.per_information8, hr_api.g_varchar2) <>
133: nvl(p_rec.per_information8, hr_api.g_varchar2) or
134: nvl(irc_ipd_shd.g_old_rec.per_information9, hr_api.g_varchar2) <>
127: nvl(p_rec.per_information5, hr_api.g_varchar2) or
128: nvl(irc_ipd_shd.g_old_rec.per_information6, hr_api.g_varchar2) <>
129: nvl(p_rec.per_information6, hr_api.g_varchar2) or
130: nvl(irc_ipd_shd.g_old_rec.per_information7, hr_api.g_varchar2) <>
131: nvl(p_rec.per_information7, hr_api.g_varchar2) or
132: nvl(irc_ipd_shd.g_old_rec.per_information8, hr_api.g_varchar2) <>
133: nvl(p_rec.per_information8, hr_api.g_varchar2) or
134: nvl(irc_ipd_shd.g_old_rec.per_information9, hr_api.g_varchar2) <>
135: nvl(p_rec.per_information9, hr_api.g_varchar2) or
128: nvl(irc_ipd_shd.g_old_rec.per_information6, hr_api.g_varchar2) <>
129: nvl(p_rec.per_information6, hr_api.g_varchar2) or
130: nvl(irc_ipd_shd.g_old_rec.per_information7, hr_api.g_varchar2) <>
131: nvl(p_rec.per_information7, hr_api.g_varchar2) or
132: nvl(irc_ipd_shd.g_old_rec.per_information8, hr_api.g_varchar2) <>
133: nvl(p_rec.per_information8, hr_api.g_varchar2) or
134: nvl(irc_ipd_shd.g_old_rec.per_information9, hr_api.g_varchar2) <>
135: nvl(p_rec.per_information9, hr_api.g_varchar2) or
136: nvl(irc_ipd_shd.g_old_rec.per_information10, hr_api.g_varchar2) <>
129: nvl(p_rec.per_information6, hr_api.g_varchar2) or
130: nvl(irc_ipd_shd.g_old_rec.per_information7, hr_api.g_varchar2) <>
131: nvl(p_rec.per_information7, hr_api.g_varchar2) or
132: nvl(irc_ipd_shd.g_old_rec.per_information8, hr_api.g_varchar2) <>
133: nvl(p_rec.per_information8, hr_api.g_varchar2) or
134: nvl(irc_ipd_shd.g_old_rec.per_information9, hr_api.g_varchar2) <>
135: nvl(p_rec.per_information9, hr_api.g_varchar2) or
136: nvl(irc_ipd_shd.g_old_rec.per_information10, hr_api.g_varchar2) <>
137: nvl(p_rec.per_information10, hr_api.g_varchar2) or
130: nvl(irc_ipd_shd.g_old_rec.per_information7, hr_api.g_varchar2) <>
131: nvl(p_rec.per_information7, hr_api.g_varchar2) or
132: nvl(irc_ipd_shd.g_old_rec.per_information8, hr_api.g_varchar2) <>
133: nvl(p_rec.per_information8, hr_api.g_varchar2) or
134: nvl(irc_ipd_shd.g_old_rec.per_information9, hr_api.g_varchar2) <>
135: nvl(p_rec.per_information9, hr_api.g_varchar2) or
136: nvl(irc_ipd_shd.g_old_rec.per_information10, hr_api.g_varchar2) <>
137: nvl(p_rec.per_information10, hr_api.g_varchar2) or
138: nvl(irc_ipd_shd.g_old_rec.per_information11, hr_api.g_varchar2) <>
131: nvl(p_rec.per_information7, hr_api.g_varchar2) or
132: nvl(irc_ipd_shd.g_old_rec.per_information8, hr_api.g_varchar2) <>
133: nvl(p_rec.per_information8, hr_api.g_varchar2) or
134: nvl(irc_ipd_shd.g_old_rec.per_information9, hr_api.g_varchar2) <>
135: nvl(p_rec.per_information9, hr_api.g_varchar2) or
136: nvl(irc_ipd_shd.g_old_rec.per_information10, hr_api.g_varchar2) <>
137: nvl(p_rec.per_information10, hr_api.g_varchar2) or
138: nvl(irc_ipd_shd.g_old_rec.per_information11, hr_api.g_varchar2) <>
139: nvl(p_rec.per_information11, hr_api.g_varchar2) or
132: nvl(irc_ipd_shd.g_old_rec.per_information8, hr_api.g_varchar2) <>
133: nvl(p_rec.per_information8, hr_api.g_varchar2) or
134: nvl(irc_ipd_shd.g_old_rec.per_information9, hr_api.g_varchar2) <>
135: nvl(p_rec.per_information9, hr_api.g_varchar2) or
136: nvl(irc_ipd_shd.g_old_rec.per_information10, hr_api.g_varchar2) <>
137: nvl(p_rec.per_information10, hr_api.g_varchar2) or
138: nvl(irc_ipd_shd.g_old_rec.per_information11, hr_api.g_varchar2) <>
139: nvl(p_rec.per_information11, hr_api.g_varchar2) or
140: nvl(irc_ipd_shd.g_old_rec.per_information12, hr_api.g_varchar2) <>
133: nvl(p_rec.per_information8, hr_api.g_varchar2) or
134: nvl(irc_ipd_shd.g_old_rec.per_information9, hr_api.g_varchar2) <>
135: nvl(p_rec.per_information9, hr_api.g_varchar2) or
136: nvl(irc_ipd_shd.g_old_rec.per_information10, hr_api.g_varchar2) <>
137: nvl(p_rec.per_information10, hr_api.g_varchar2) or
138: nvl(irc_ipd_shd.g_old_rec.per_information11, hr_api.g_varchar2) <>
139: nvl(p_rec.per_information11, hr_api.g_varchar2) or
140: nvl(irc_ipd_shd.g_old_rec.per_information12, hr_api.g_varchar2) <>
141: nvl(p_rec.per_information12, hr_api.g_varchar2) or
134: nvl(irc_ipd_shd.g_old_rec.per_information9, hr_api.g_varchar2) <>
135: nvl(p_rec.per_information9, hr_api.g_varchar2) or
136: nvl(irc_ipd_shd.g_old_rec.per_information10, hr_api.g_varchar2) <>
137: nvl(p_rec.per_information10, hr_api.g_varchar2) or
138: nvl(irc_ipd_shd.g_old_rec.per_information11, hr_api.g_varchar2) <>
139: nvl(p_rec.per_information11, hr_api.g_varchar2) or
140: nvl(irc_ipd_shd.g_old_rec.per_information12, hr_api.g_varchar2) <>
141: nvl(p_rec.per_information12, hr_api.g_varchar2) or
142: nvl(irc_ipd_shd.g_old_rec.per_information13, hr_api.g_varchar2) <>
135: nvl(p_rec.per_information9, hr_api.g_varchar2) or
136: nvl(irc_ipd_shd.g_old_rec.per_information10, hr_api.g_varchar2) <>
137: nvl(p_rec.per_information10, hr_api.g_varchar2) or
138: nvl(irc_ipd_shd.g_old_rec.per_information11, hr_api.g_varchar2) <>
139: nvl(p_rec.per_information11, hr_api.g_varchar2) or
140: nvl(irc_ipd_shd.g_old_rec.per_information12, hr_api.g_varchar2) <>
141: nvl(p_rec.per_information12, hr_api.g_varchar2) or
142: nvl(irc_ipd_shd.g_old_rec.per_information13, hr_api.g_varchar2) <>
143: nvl(p_rec.per_information13, hr_api.g_varchar2) or
136: nvl(irc_ipd_shd.g_old_rec.per_information10, hr_api.g_varchar2) <>
137: nvl(p_rec.per_information10, hr_api.g_varchar2) or
138: nvl(irc_ipd_shd.g_old_rec.per_information11, hr_api.g_varchar2) <>
139: nvl(p_rec.per_information11, hr_api.g_varchar2) or
140: nvl(irc_ipd_shd.g_old_rec.per_information12, hr_api.g_varchar2) <>
141: nvl(p_rec.per_information12, hr_api.g_varchar2) or
142: nvl(irc_ipd_shd.g_old_rec.per_information13, hr_api.g_varchar2) <>
143: nvl(p_rec.per_information13, hr_api.g_varchar2) or
144: nvl(irc_ipd_shd.g_old_rec.per_information14, hr_api.g_varchar2) <>
137: nvl(p_rec.per_information10, hr_api.g_varchar2) or
138: nvl(irc_ipd_shd.g_old_rec.per_information11, hr_api.g_varchar2) <>
139: nvl(p_rec.per_information11, hr_api.g_varchar2) or
140: nvl(irc_ipd_shd.g_old_rec.per_information12, hr_api.g_varchar2) <>
141: nvl(p_rec.per_information12, hr_api.g_varchar2) or
142: nvl(irc_ipd_shd.g_old_rec.per_information13, hr_api.g_varchar2) <>
143: nvl(p_rec.per_information13, hr_api.g_varchar2) or
144: nvl(irc_ipd_shd.g_old_rec.per_information14, hr_api.g_varchar2) <>
145: nvl(p_rec.per_information14, hr_api.g_varchar2) or
138: nvl(irc_ipd_shd.g_old_rec.per_information11, hr_api.g_varchar2) <>
139: nvl(p_rec.per_information11, hr_api.g_varchar2) or
140: nvl(irc_ipd_shd.g_old_rec.per_information12, hr_api.g_varchar2) <>
141: nvl(p_rec.per_information12, hr_api.g_varchar2) or
142: nvl(irc_ipd_shd.g_old_rec.per_information13, hr_api.g_varchar2) <>
143: nvl(p_rec.per_information13, hr_api.g_varchar2) or
144: nvl(irc_ipd_shd.g_old_rec.per_information14, hr_api.g_varchar2) <>
145: nvl(p_rec.per_information14, hr_api.g_varchar2) or
146: nvl(irc_ipd_shd.g_old_rec.per_information15, hr_api.g_varchar2) <>
139: nvl(p_rec.per_information11, hr_api.g_varchar2) or
140: nvl(irc_ipd_shd.g_old_rec.per_information12, hr_api.g_varchar2) <>
141: nvl(p_rec.per_information12, hr_api.g_varchar2) or
142: nvl(irc_ipd_shd.g_old_rec.per_information13, hr_api.g_varchar2) <>
143: nvl(p_rec.per_information13, hr_api.g_varchar2) or
144: nvl(irc_ipd_shd.g_old_rec.per_information14, hr_api.g_varchar2) <>
145: nvl(p_rec.per_information14, hr_api.g_varchar2) or
146: nvl(irc_ipd_shd.g_old_rec.per_information15, hr_api.g_varchar2) <>
147: nvl(p_rec.per_information15, hr_api.g_varchar2) or
140: nvl(irc_ipd_shd.g_old_rec.per_information12, hr_api.g_varchar2) <>
141: nvl(p_rec.per_information12, hr_api.g_varchar2) or
142: nvl(irc_ipd_shd.g_old_rec.per_information13, hr_api.g_varchar2) <>
143: nvl(p_rec.per_information13, hr_api.g_varchar2) or
144: nvl(irc_ipd_shd.g_old_rec.per_information14, hr_api.g_varchar2) <>
145: nvl(p_rec.per_information14, hr_api.g_varchar2) or
146: nvl(irc_ipd_shd.g_old_rec.per_information15, hr_api.g_varchar2) <>
147: nvl(p_rec.per_information15, hr_api.g_varchar2) or
148: nvl(irc_ipd_shd.g_old_rec.per_information16, hr_api.g_varchar2) <>
141: nvl(p_rec.per_information12, hr_api.g_varchar2) or
142: nvl(irc_ipd_shd.g_old_rec.per_information13, hr_api.g_varchar2) <>
143: nvl(p_rec.per_information13, hr_api.g_varchar2) or
144: nvl(irc_ipd_shd.g_old_rec.per_information14, hr_api.g_varchar2) <>
145: nvl(p_rec.per_information14, hr_api.g_varchar2) or
146: nvl(irc_ipd_shd.g_old_rec.per_information15, hr_api.g_varchar2) <>
147: nvl(p_rec.per_information15, hr_api.g_varchar2) or
148: nvl(irc_ipd_shd.g_old_rec.per_information16, hr_api.g_varchar2) <>
149: nvl(p_rec.per_information16, hr_api.g_varchar2) or
142: nvl(irc_ipd_shd.g_old_rec.per_information13, hr_api.g_varchar2) <>
143: nvl(p_rec.per_information13, hr_api.g_varchar2) or
144: nvl(irc_ipd_shd.g_old_rec.per_information14, hr_api.g_varchar2) <>
145: nvl(p_rec.per_information14, hr_api.g_varchar2) or
146: nvl(irc_ipd_shd.g_old_rec.per_information15, hr_api.g_varchar2) <>
147: nvl(p_rec.per_information15, hr_api.g_varchar2) or
148: nvl(irc_ipd_shd.g_old_rec.per_information16, hr_api.g_varchar2) <>
149: nvl(p_rec.per_information16, hr_api.g_varchar2) or
150: nvl(irc_ipd_shd.g_old_rec.per_information17, hr_api.g_varchar2) <>
143: nvl(p_rec.per_information13, hr_api.g_varchar2) or
144: nvl(irc_ipd_shd.g_old_rec.per_information14, hr_api.g_varchar2) <>
145: nvl(p_rec.per_information14, hr_api.g_varchar2) or
146: nvl(irc_ipd_shd.g_old_rec.per_information15, hr_api.g_varchar2) <>
147: nvl(p_rec.per_information15, hr_api.g_varchar2) or
148: nvl(irc_ipd_shd.g_old_rec.per_information16, hr_api.g_varchar2) <>
149: nvl(p_rec.per_information16, hr_api.g_varchar2) or
150: nvl(irc_ipd_shd.g_old_rec.per_information17, hr_api.g_varchar2) <>
151: nvl(p_rec.per_information17, hr_api.g_varchar2) or
144: nvl(irc_ipd_shd.g_old_rec.per_information14, hr_api.g_varchar2) <>
145: nvl(p_rec.per_information14, hr_api.g_varchar2) or
146: nvl(irc_ipd_shd.g_old_rec.per_information15, hr_api.g_varchar2) <>
147: nvl(p_rec.per_information15, hr_api.g_varchar2) or
148: nvl(irc_ipd_shd.g_old_rec.per_information16, hr_api.g_varchar2) <>
149: nvl(p_rec.per_information16, hr_api.g_varchar2) or
150: nvl(irc_ipd_shd.g_old_rec.per_information17, hr_api.g_varchar2) <>
151: nvl(p_rec.per_information17, hr_api.g_varchar2) or
152: nvl(irc_ipd_shd.g_old_rec.per_information18, hr_api.g_varchar2) <>
145: nvl(p_rec.per_information14, hr_api.g_varchar2) or
146: nvl(irc_ipd_shd.g_old_rec.per_information15, hr_api.g_varchar2) <>
147: nvl(p_rec.per_information15, hr_api.g_varchar2) or
148: nvl(irc_ipd_shd.g_old_rec.per_information16, hr_api.g_varchar2) <>
149: nvl(p_rec.per_information16, hr_api.g_varchar2) or
150: nvl(irc_ipd_shd.g_old_rec.per_information17, hr_api.g_varchar2) <>
151: nvl(p_rec.per_information17, hr_api.g_varchar2) or
152: nvl(irc_ipd_shd.g_old_rec.per_information18, hr_api.g_varchar2) <>
153: nvl(p_rec.per_information18, hr_api.g_varchar2) or
146: nvl(irc_ipd_shd.g_old_rec.per_information15, hr_api.g_varchar2) <>
147: nvl(p_rec.per_information15, hr_api.g_varchar2) or
148: nvl(irc_ipd_shd.g_old_rec.per_information16, hr_api.g_varchar2) <>
149: nvl(p_rec.per_information16, hr_api.g_varchar2) or
150: nvl(irc_ipd_shd.g_old_rec.per_information17, hr_api.g_varchar2) <>
151: nvl(p_rec.per_information17, hr_api.g_varchar2) or
152: nvl(irc_ipd_shd.g_old_rec.per_information18, hr_api.g_varchar2) <>
153: nvl(p_rec.per_information18, hr_api.g_varchar2) or
154: nvl(irc_ipd_shd.g_old_rec.per_information19, hr_api.g_varchar2) <>
147: nvl(p_rec.per_information15, hr_api.g_varchar2) or
148: nvl(irc_ipd_shd.g_old_rec.per_information16, hr_api.g_varchar2) <>
149: nvl(p_rec.per_information16, hr_api.g_varchar2) or
150: nvl(irc_ipd_shd.g_old_rec.per_information17, hr_api.g_varchar2) <>
151: nvl(p_rec.per_information17, hr_api.g_varchar2) or
152: nvl(irc_ipd_shd.g_old_rec.per_information18, hr_api.g_varchar2) <>
153: nvl(p_rec.per_information18, hr_api.g_varchar2) or
154: nvl(irc_ipd_shd.g_old_rec.per_information19, hr_api.g_varchar2) <>
155: nvl(p_rec.per_information19, hr_api.g_varchar2) or
148: nvl(irc_ipd_shd.g_old_rec.per_information16, hr_api.g_varchar2) <>
149: nvl(p_rec.per_information16, hr_api.g_varchar2) or
150: nvl(irc_ipd_shd.g_old_rec.per_information17, hr_api.g_varchar2) <>
151: nvl(p_rec.per_information17, hr_api.g_varchar2) or
152: nvl(irc_ipd_shd.g_old_rec.per_information18, hr_api.g_varchar2) <>
153: nvl(p_rec.per_information18, hr_api.g_varchar2) or
154: nvl(irc_ipd_shd.g_old_rec.per_information19, hr_api.g_varchar2) <>
155: nvl(p_rec.per_information19, hr_api.g_varchar2) or
156: nvl(irc_ipd_shd.g_old_rec.per_information20, hr_api.g_varchar2) <>
149: nvl(p_rec.per_information16, hr_api.g_varchar2) or
150: nvl(irc_ipd_shd.g_old_rec.per_information17, hr_api.g_varchar2) <>
151: nvl(p_rec.per_information17, hr_api.g_varchar2) or
152: nvl(irc_ipd_shd.g_old_rec.per_information18, hr_api.g_varchar2) <>
153: nvl(p_rec.per_information18, hr_api.g_varchar2) or
154: nvl(irc_ipd_shd.g_old_rec.per_information19, hr_api.g_varchar2) <>
155: nvl(p_rec.per_information19, hr_api.g_varchar2) or
156: nvl(irc_ipd_shd.g_old_rec.per_information20, hr_api.g_varchar2) <>
157: nvl(p_rec.per_information20, hr_api.g_varchar2) or
150: nvl(irc_ipd_shd.g_old_rec.per_information17, hr_api.g_varchar2) <>
151: nvl(p_rec.per_information17, hr_api.g_varchar2) or
152: nvl(irc_ipd_shd.g_old_rec.per_information18, hr_api.g_varchar2) <>
153: nvl(p_rec.per_information18, hr_api.g_varchar2) or
154: nvl(irc_ipd_shd.g_old_rec.per_information19, hr_api.g_varchar2) <>
155: nvl(p_rec.per_information19, hr_api.g_varchar2) or
156: nvl(irc_ipd_shd.g_old_rec.per_information20, hr_api.g_varchar2) <>
157: nvl(p_rec.per_information20, hr_api.g_varchar2) or
158: nvl(irc_ipd_shd.g_old_rec.per_information21, hr_api.g_varchar2) <>
151: nvl(p_rec.per_information17, hr_api.g_varchar2) or
152: nvl(irc_ipd_shd.g_old_rec.per_information18, hr_api.g_varchar2) <>
153: nvl(p_rec.per_information18, hr_api.g_varchar2) or
154: nvl(irc_ipd_shd.g_old_rec.per_information19, hr_api.g_varchar2) <>
155: nvl(p_rec.per_information19, hr_api.g_varchar2) or
156: nvl(irc_ipd_shd.g_old_rec.per_information20, hr_api.g_varchar2) <>
157: nvl(p_rec.per_information20, hr_api.g_varchar2) or
158: nvl(irc_ipd_shd.g_old_rec.per_information21, hr_api.g_varchar2) <>
159: nvl(p_rec.per_information21, hr_api.g_varchar2) or
152: nvl(irc_ipd_shd.g_old_rec.per_information18, hr_api.g_varchar2) <>
153: nvl(p_rec.per_information18, hr_api.g_varchar2) or
154: nvl(irc_ipd_shd.g_old_rec.per_information19, hr_api.g_varchar2) <>
155: nvl(p_rec.per_information19, hr_api.g_varchar2) or
156: nvl(irc_ipd_shd.g_old_rec.per_information20, hr_api.g_varchar2) <>
157: nvl(p_rec.per_information20, hr_api.g_varchar2) or
158: nvl(irc_ipd_shd.g_old_rec.per_information21, hr_api.g_varchar2) <>
159: nvl(p_rec.per_information21, hr_api.g_varchar2) or
160: nvl(irc_ipd_shd.g_old_rec.per_information22, hr_api.g_varchar2) <>
153: nvl(p_rec.per_information18, hr_api.g_varchar2) or
154: nvl(irc_ipd_shd.g_old_rec.per_information19, hr_api.g_varchar2) <>
155: nvl(p_rec.per_information19, hr_api.g_varchar2) or
156: nvl(irc_ipd_shd.g_old_rec.per_information20, hr_api.g_varchar2) <>
157: nvl(p_rec.per_information20, hr_api.g_varchar2) or
158: nvl(irc_ipd_shd.g_old_rec.per_information21, hr_api.g_varchar2) <>
159: nvl(p_rec.per_information21, hr_api.g_varchar2) or
160: nvl(irc_ipd_shd.g_old_rec.per_information22, hr_api.g_varchar2) <>
161: nvl(p_rec.per_information22, hr_api.g_varchar2) or
154: nvl(irc_ipd_shd.g_old_rec.per_information19, hr_api.g_varchar2) <>
155: nvl(p_rec.per_information19, hr_api.g_varchar2) or
156: nvl(irc_ipd_shd.g_old_rec.per_information20, hr_api.g_varchar2) <>
157: nvl(p_rec.per_information20, hr_api.g_varchar2) or
158: nvl(irc_ipd_shd.g_old_rec.per_information21, hr_api.g_varchar2) <>
159: nvl(p_rec.per_information21, hr_api.g_varchar2) or
160: nvl(irc_ipd_shd.g_old_rec.per_information22, hr_api.g_varchar2) <>
161: nvl(p_rec.per_information22, hr_api.g_varchar2) or
162: nvl(irc_ipd_shd.g_old_rec.per_information23, hr_api.g_varchar2) <>
155: nvl(p_rec.per_information19, hr_api.g_varchar2) or
156: nvl(irc_ipd_shd.g_old_rec.per_information20, hr_api.g_varchar2) <>
157: nvl(p_rec.per_information20, hr_api.g_varchar2) or
158: nvl(irc_ipd_shd.g_old_rec.per_information21, hr_api.g_varchar2) <>
159: nvl(p_rec.per_information21, hr_api.g_varchar2) or
160: nvl(irc_ipd_shd.g_old_rec.per_information22, hr_api.g_varchar2) <>
161: nvl(p_rec.per_information22, hr_api.g_varchar2) or
162: nvl(irc_ipd_shd.g_old_rec.per_information23, hr_api.g_varchar2) <>
163: nvl(p_rec.per_information23, hr_api.g_varchar2) or
156: nvl(irc_ipd_shd.g_old_rec.per_information20, hr_api.g_varchar2) <>
157: nvl(p_rec.per_information20, hr_api.g_varchar2) or
158: nvl(irc_ipd_shd.g_old_rec.per_information21, hr_api.g_varchar2) <>
159: nvl(p_rec.per_information21, hr_api.g_varchar2) or
160: nvl(irc_ipd_shd.g_old_rec.per_information22, hr_api.g_varchar2) <>
161: nvl(p_rec.per_information22, hr_api.g_varchar2) or
162: nvl(irc_ipd_shd.g_old_rec.per_information23, hr_api.g_varchar2) <>
163: nvl(p_rec.per_information23, hr_api.g_varchar2) or
164: nvl(irc_ipd_shd.g_old_rec.per_information24, hr_api.g_varchar2) <>
157: nvl(p_rec.per_information20, hr_api.g_varchar2) or
158: nvl(irc_ipd_shd.g_old_rec.per_information21, hr_api.g_varchar2) <>
159: nvl(p_rec.per_information21, hr_api.g_varchar2) or
160: nvl(irc_ipd_shd.g_old_rec.per_information22, hr_api.g_varchar2) <>
161: nvl(p_rec.per_information22, hr_api.g_varchar2) or
162: nvl(irc_ipd_shd.g_old_rec.per_information23, hr_api.g_varchar2) <>
163: nvl(p_rec.per_information23, hr_api.g_varchar2) or
164: nvl(irc_ipd_shd.g_old_rec.per_information24, hr_api.g_varchar2) <>
165: nvl(p_rec.per_information24, hr_api.g_varchar2) or
158: nvl(irc_ipd_shd.g_old_rec.per_information21, hr_api.g_varchar2) <>
159: nvl(p_rec.per_information21, hr_api.g_varchar2) or
160: nvl(irc_ipd_shd.g_old_rec.per_information22, hr_api.g_varchar2) <>
161: nvl(p_rec.per_information22, hr_api.g_varchar2) or
162: nvl(irc_ipd_shd.g_old_rec.per_information23, hr_api.g_varchar2) <>
163: nvl(p_rec.per_information23, hr_api.g_varchar2) or
164: nvl(irc_ipd_shd.g_old_rec.per_information24, hr_api.g_varchar2) <>
165: nvl(p_rec.per_information24, hr_api.g_varchar2) or
166: nvl(irc_ipd_shd.g_old_rec.per_information25, hr_api.g_varchar2) <>
159: nvl(p_rec.per_information21, hr_api.g_varchar2) or
160: nvl(irc_ipd_shd.g_old_rec.per_information22, hr_api.g_varchar2) <>
161: nvl(p_rec.per_information22, hr_api.g_varchar2) or
162: nvl(irc_ipd_shd.g_old_rec.per_information23, hr_api.g_varchar2) <>
163: nvl(p_rec.per_information23, hr_api.g_varchar2) or
164: nvl(irc_ipd_shd.g_old_rec.per_information24, hr_api.g_varchar2) <>
165: nvl(p_rec.per_information24, hr_api.g_varchar2) or
166: nvl(irc_ipd_shd.g_old_rec.per_information25, hr_api.g_varchar2) <>
167: nvl(p_rec.per_information25, hr_api.g_varchar2) or
160: nvl(irc_ipd_shd.g_old_rec.per_information22, hr_api.g_varchar2) <>
161: nvl(p_rec.per_information22, hr_api.g_varchar2) or
162: nvl(irc_ipd_shd.g_old_rec.per_information23, hr_api.g_varchar2) <>
163: nvl(p_rec.per_information23, hr_api.g_varchar2) or
164: nvl(irc_ipd_shd.g_old_rec.per_information24, hr_api.g_varchar2) <>
165: nvl(p_rec.per_information24, hr_api.g_varchar2) or
166: nvl(irc_ipd_shd.g_old_rec.per_information25, hr_api.g_varchar2) <>
167: nvl(p_rec.per_information25, hr_api.g_varchar2) or
168: nvl(irc_ipd_shd.g_old_rec.per_information26, hr_api.g_varchar2) <>
161: nvl(p_rec.per_information22, hr_api.g_varchar2) or
162: nvl(irc_ipd_shd.g_old_rec.per_information23, hr_api.g_varchar2) <>
163: nvl(p_rec.per_information23, hr_api.g_varchar2) or
164: nvl(irc_ipd_shd.g_old_rec.per_information24, hr_api.g_varchar2) <>
165: nvl(p_rec.per_information24, hr_api.g_varchar2) or
166: nvl(irc_ipd_shd.g_old_rec.per_information25, hr_api.g_varchar2) <>
167: nvl(p_rec.per_information25, hr_api.g_varchar2) or
168: nvl(irc_ipd_shd.g_old_rec.per_information26, hr_api.g_varchar2) <>
169: nvl(p_rec.per_information26, hr_api.g_varchar2) or
162: nvl(irc_ipd_shd.g_old_rec.per_information23, hr_api.g_varchar2) <>
163: nvl(p_rec.per_information23, hr_api.g_varchar2) or
164: nvl(irc_ipd_shd.g_old_rec.per_information24, hr_api.g_varchar2) <>
165: nvl(p_rec.per_information24, hr_api.g_varchar2) or
166: nvl(irc_ipd_shd.g_old_rec.per_information25, hr_api.g_varchar2) <>
167: nvl(p_rec.per_information25, hr_api.g_varchar2) or
168: nvl(irc_ipd_shd.g_old_rec.per_information26, hr_api.g_varchar2) <>
169: nvl(p_rec.per_information26, hr_api.g_varchar2) or
170: nvl(irc_ipd_shd.g_old_rec.per_information27, hr_api.g_varchar2) <>
163: nvl(p_rec.per_information23, hr_api.g_varchar2) or
164: nvl(irc_ipd_shd.g_old_rec.per_information24, hr_api.g_varchar2) <>
165: nvl(p_rec.per_information24, hr_api.g_varchar2) or
166: nvl(irc_ipd_shd.g_old_rec.per_information25, hr_api.g_varchar2) <>
167: nvl(p_rec.per_information25, hr_api.g_varchar2) or
168: nvl(irc_ipd_shd.g_old_rec.per_information26, hr_api.g_varchar2) <>
169: nvl(p_rec.per_information26, hr_api.g_varchar2) or
170: nvl(irc_ipd_shd.g_old_rec.per_information27, hr_api.g_varchar2) <>
171: nvl(p_rec.per_information27, hr_api.g_varchar2) or
164: nvl(irc_ipd_shd.g_old_rec.per_information24, hr_api.g_varchar2) <>
165: nvl(p_rec.per_information24, hr_api.g_varchar2) or
166: nvl(irc_ipd_shd.g_old_rec.per_information25, hr_api.g_varchar2) <>
167: nvl(p_rec.per_information25, hr_api.g_varchar2) or
168: nvl(irc_ipd_shd.g_old_rec.per_information26, hr_api.g_varchar2) <>
169: nvl(p_rec.per_information26, hr_api.g_varchar2) or
170: nvl(irc_ipd_shd.g_old_rec.per_information27, hr_api.g_varchar2) <>
171: nvl(p_rec.per_information27, hr_api.g_varchar2) or
172: nvl(irc_ipd_shd.g_old_rec.per_information28, hr_api.g_varchar2) <>
165: nvl(p_rec.per_information24, hr_api.g_varchar2) or
166: nvl(irc_ipd_shd.g_old_rec.per_information25, hr_api.g_varchar2) <>
167: nvl(p_rec.per_information25, hr_api.g_varchar2) or
168: nvl(irc_ipd_shd.g_old_rec.per_information26, hr_api.g_varchar2) <>
169: nvl(p_rec.per_information26, hr_api.g_varchar2) or
170: nvl(irc_ipd_shd.g_old_rec.per_information27, hr_api.g_varchar2) <>
171: nvl(p_rec.per_information27, hr_api.g_varchar2) or
172: nvl(irc_ipd_shd.g_old_rec.per_information28, hr_api.g_varchar2) <>
173: nvl(p_rec.per_information28, hr_api.g_varchar2) or
166: nvl(irc_ipd_shd.g_old_rec.per_information25, hr_api.g_varchar2) <>
167: nvl(p_rec.per_information25, hr_api.g_varchar2) or
168: nvl(irc_ipd_shd.g_old_rec.per_information26, hr_api.g_varchar2) <>
169: nvl(p_rec.per_information26, hr_api.g_varchar2) or
170: nvl(irc_ipd_shd.g_old_rec.per_information27, hr_api.g_varchar2) <>
171: nvl(p_rec.per_information27, hr_api.g_varchar2) or
172: nvl(irc_ipd_shd.g_old_rec.per_information28, hr_api.g_varchar2) <>
173: nvl(p_rec.per_information28, hr_api.g_varchar2) or
174: nvl(irc_ipd_shd.g_old_rec.per_information29, hr_api.g_varchar2) <>
167: nvl(p_rec.per_information25, hr_api.g_varchar2) or
168: nvl(irc_ipd_shd.g_old_rec.per_information26, hr_api.g_varchar2) <>
169: nvl(p_rec.per_information26, hr_api.g_varchar2) or
170: nvl(irc_ipd_shd.g_old_rec.per_information27, hr_api.g_varchar2) <>
171: nvl(p_rec.per_information27, hr_api.g_varchar2) or
172: nvl(irc_ipd_shd.g_old_rec.per_information28, hr_api.g_varchar2) <>
173: nvl(p_rec.per_information28, hr_api.g_varchar2) or
174: nvl(irc_ipd_shd.g_old_rec.per_information29, hr_api.g_varchar2) <>
175: nvl(p_rec.per_information29, hr_api.g_varchar2) or
168: nvl(irc_ipd_shd.g_old_rec.per_information26, hr_api.g_varchar2) <>
169: nvl(p_rec.per_information26, hr_api.g_varchar2) or
170: nvl(irc_ipd_shd.g_old_rec.per_information27, hr_api.g_varchar2) <>
171: nvl(p_rec.per_information27, hr_api.g_varchar2) or
172: nvl(irc_ipd_shd.g_old_rec.per_information28, hr_api.g_varchar2) <>
173: nvl(p_rec.per_information28, hr_api.g_varchar2) or
174: nvl(irc_ipd_shd.g_old_rec.per_information29, hr_api.g_varchar2) <>
175: nvl(p_rec.per_information29, hr_api.g_varchar2) or
176: nvl(irc_ipd_shd.g_old_rec.per_information30, hr_api.g_varchar2) <>
169: nvl(p_rec.per_information26, hr_api.g_varchar2) or
170: nvl(irc_ipd_shd.g_old_rec.per_information27, hr_api.g_varchar2) <>
171: nvl(p_rec.per_information27, hr_api.g_varchar2) or
172: nvl(irc_ipd_shd.g_old_rec.per_information28, hr_api.g_varchar2) <>
173: nvl(p_rec.per_information28, hr_api.g_varchar2) or
174: nvl(irc_ipd_shd.g_old_rec.per_information29, hr_api.g_varchar2) <>
175: nvl(p_rec.per_information29, hr_api.g_varchar2) or
176: nvl(irc_ipd_shd.g_old_rec.per_information30, hr_api.g_varchar2) <>
177: nvl(p_rec.per_information30, hr_api.g_varchar2) ))
170: nvl(irc_ipd_shd.g_old_rec.per_information27, hr_api.g_varchar2) <>
171: nvl(p_rec.per_information27, hr_api.g_varchar2) or
172: nvl(irc_ipd_shd.g_old_rec.per_information28, hr_api.g_varchar2) <>
173: nvl(p_rec.per_information28, hr_api.g_varchar2) or
174: nvl(irc_ipd_shd.g_old_rec.per_information29, hr_api.g_varchar2) <>
175: nvl(p_rec.per_information29, hr_api.g_varchar2) or
176: nvl(irc_ipd_shd.g_old_rec.per_information30, hr_api.g_varchar2) <>
177: nvl(p_rec.per_information30, hr_api.g_varchar2) ))
178: or (p_rec.pending_data_id is null) then
171: nvl(p_rec.per_information27, hr_api.g_varchar2) or
172: nvl(irc_ipd_shd.g_old_rec.per_information28, hr_api.g_varchar2) <>
173: nvl(p_rec.per_information28, hr_api.g_varchar2) or
174: nvl(irc_ipd_shd.g_old_rec.per_information29, hr_api.g_varchar2) <>
175: nvl(p_rec.per_information29, hr_api.g_varchar2) or
176: nvl(irc_ipd_shd.g_old_rec.per_information30, hr_api.g_varchar2) <>
177: nvl(p_rec.per_information30, hr_api.g_varchar2) ))
178: or (p_rec.pending_data_id is null) then
179: --
172: nvl(irc_ipd_shd.g_old_rec.per_information28, hr_api.g_varchar2) <>
173: nvl(p_rec.per_information28, hr_api.g_varchar2) or
174: nvl(irc_ipd_shd.g_old_rec.per_information29, hr_api.g_varchar2) <>
175: nvl(p_rec.per_information29, hr_api.g_varchar2) or
176: nvl(irc_ipd_shd.g_old_rec.per_information30, hr_api.g_varchar2) <>
177: nvl(p_rec.per_information30, hr_api.g_varchar2) ))
178: or (p_rec.pending_data_id is null) then
179: --
180: -- Only execute the validation if absolutely necessary:
173: nvl(p_rec.per_information28, hr_api.g_varchar2) or
174: nvl(irc_ipd_shd.g_old_rec.per_information29, hr_api.g_varchar2) <>
175: nvl(p_rec.per_information29, hr_api.g_varchar2) or
176: nvl(irc_ipd_shd.g_old_rec.per_information30, hr_api.g_varchar2) <>
177: nvl(p_rec.per_information30, hr_api.g_varchar2) ))
178: or (p_rec.pending_data_id is null) then
179: --
180: -- Only execute the validation if absolutely necessary:
181: -- a) During update, the structure column value or any
303: -- Checks to ensure non-updateable args have
304: -- not been updated.
305: if p_rec.pending_data_id <> irc_ipd_shd.g_old_rec.pending_data_id
306: then
307: hr_api.argument_changed_error
308: (p_api_name => l_proc
309: ,p_argument => 'PENDING_DATA_ID'
310: ,p_base_table => irc_ipd_shd.g_tab_nam
311: );
310: ,p_base_table => irc_ipd_shd.g_tab_nam
311: );
312: end if;
313: --
314: if nvl(p_rec.vacancy_id, hr_api.g_number) <>
315: nvl(irc_ipd_shd.g_old_rec.vacancy_id
316: ,hr_api.g_number)
317: then
318: hr_api.argument_changed_error
312: end if;
313: --
314: if nvl(p_rec.vacancy_id, hr_api.g_number) <>
315: nvl(irc_ipd_shd.g_old_rec.vacancy_id
316: ,hr_api.g_number)
317: then
318: hr_api.argument_changed_error
319: (p_api_name => l_proc
320: ,p_argument => 'VACANCY_ID'
314: if nvl(p_rec.vacancy_id, hr_api.g_number) <>
315: nvl(irc_ipd_shd.g_old_rec.vacancy_id
316: ,hr_api.g_number)
317: then
318: hr_api.argument_changed_error
319: (p_api_name => l_proc
320: ,p_argument => 'VACANCY_ID'
321: ,p_base_table => irc_ipd_shd.g_tab_nam
322: );
323: end if;
324: --
325: if p_rec.creation_date <> irc_ipd_shd.g_old_rec.creation_date
326: then
327: hr_api.argument_changed_error
328: (p_api_name => l_proc
329: ,p_argument => 'CREATION_DATE'
330: ,p_base_table => irc_ipd_shd.g_tab_nam
331: );
371: cursor csr_vacancy_id is
372: select 1
373: from per_all_vacancies
374: where vacancy_id = p_vacancy_id
375: and nvl(date_to,hr_api.g_eot) >= p_creation_date
376: and date_from <= p_creation_date;
377: --
378: Begin
379: --
378: Begin
379: --
380: hr_utility.set_location(' Entering:'||l_proc,10);
381: --
382: hr_api.mandatory_arg_error
383: (p_api_name => l_proc
384: ,p_argument => 'creation date'
385: ,p_argument_value => p_creation_date
386: );
518: --
519: Begin
520: hr_utility.set_location('Entering:'||l_proc,10);
521: --
522: hr_api.mandatory_arg_error
523: (p_api_name => l_proc
524: ,p_argument => 'creation date'
525: ,p_argument_value => p_creation_date
526: );
531: if hr_multi_message.no_exclusive_error(
532: p_check_column1 => 'IRC_PENDING_DATA.VACANCY_ID'
533: ) then
534: --
535: if (l_api_updating and nvl(p_sex,hr_api.g_varchar2)
536: <> nvl(irc_ipd_shd.g_old_rec.sex,hr_api.g_varchar2)
537: or not l_api_updating) then
538: --
539: --Check if sex is set
532: p_check_column1 => 'IRC_PENDING_DATA.VACANCY_ID'
533: ) then
534: --
535: if (l_api_updating and nvl(p_sex,hr_api.g_varchar2)
536: <> nvl(irc_ipd_shd.g_old_rec.sex,hr_api.g_varchar2)
537: or not l_api_updating) then
538: --
539: --Check if sex is set
540: --
542: hr_utility.set_location('Entering:'||l_proc,20);
543: --
544: --Check if the sex exists in hr_lookups
545: --
546: if hr_api.not_exists_in_hr_lookups
547: (p_effective_date => p_creation_date
548: ,p_lookup_type => 'SEX'
549: ,p_lookup_code => p_sex
550: ) then
601: Begin
602: --
603: hr_utility.set_location(' Entering:'||l_proc,10);
604: --
605: hr_api.mandatory_arg_error
606: (p_api_name => l_proc
607: ,p_argument => 'ALLOW_ACCESS'
608: ,p_argument_value => p_allow_access
609: );
760: --
761: -- Check the mandatory parameters
762: --
763: --
764: hr_api.mandatory_arg_error
765: (p_api_name => l_proc
766: ,p_argument => 'creation_date'
767: ,p_argument_value => p_creation_date
768: );
778: -- Check that per information1 exists in hr_lookups for the
779: -- lookup type 'ETH_TYPE' with an enabled flag set to 'Y' and that
780: -- the person is active on creation date in hr_lookups.
781: --
782: if hr_api.not_exists_in_hr_lookups
783: (p_effective_date => p_creation_date
784: ,p_lookup_type => 'ETH_TYPE'
785: ,p_lookup_code => p_per_information1
786: )
801: -- Check that per information2 exists in hr_lookups for the
802: -- lookup type 'YES_NO' with an enabled flag set to 'Y' and that
803: -- the person is active on creation date in hr_lookups.
804: --
805: if hr_api.not_exists_in_hr_lookups
806: (p_effective_date => p_creation_date
807: ,p_lookup_type => 'YES_NO'
808: ,p_lookup_code => p_per_information2
809: )
824: -- Check that per information4 exists in hr_lookups for the
825: -- lookup type 'YES_NO' with an enabled flag set to 'Y' and that
826: -- the person is active on creation date in hr_lookups.
827: --
828: if hr_api.not_exists_in_hr_lookups
829: (p_effective_date => p_creation_date
830: ,p_lookup_type => 'YES_NO'
831: ,p_lookup_code => p_per_information4
832: )
928: -- Check that per information9 exists in hr_lookups for the
929: -- lookup type 'YES_NO' with an enabled flag set to 'Y' and that
930: -- the person is active on creation date in hr_lookups.
931: --
932: if hr_api.not_exists_in_hr_lookups
933: (p_effective_date => p_creation_date
934: ,p_lookup_type => 'YES_NO'
935: ,p_lookup_code => p_per_information9
936: )
947: -- Check that per information10 exists in hr_lookups for the
948: -- lookup type 'YES_NO' with an enabled flag set to 'Y' and that
949: -- the person is active on creation date in hr_lookups.
950: --
951: if hr_api.not_exists_in_hr_lookups
952: (p_effective_date => p_creation_date
953: ,p_lookup_type => 'YES_NO'
954: ,p_lookup_code => p_per_information10
955: )
1238: hr_utility.set_location('Entering:'|| l_proc, 10);
1239: --
1240: -- Check the mandatory parameters
1241: --
1242: hr_api.mandatory_arg_error
1243: (p_api_name => l_proc
1244: ,p_argument => 'creation_date'
1245: ,p_argument_value => p_creation_date
1246: );
1250: --
1251: -- Check if the value for per information1 is set on insert or has
1252: -- changed on update.
1253: --
1254: if (((nvl(p_per_information1,hr_api.g_varchar2)
1255: <> nvl(irc_ipd_shd.g_old_rec.per_information1,hr_api.g_varchar2)
1256: and p_api_updating)
1257: or (NOT p_api_updating))
1258: and p_per_information1 is not null)
1251: -- Check if the value for per information1 is set on insert or has
1252: -- changed on update.
1253: --
1254: if (((nvl(p_per_information1,hr_api.g_varchar2)
1255: <> nvl(irc_ipd_shd.g_old_rec.per_information1,hr_api.g_varchar2)
1256: and p_api_updating)
1257: or (NOT p_api_updating))
1258: and p_per_information1 is not null)
1259: then
1260: -- Check that per information1 exists in hr_lookups for the
1261: -- lookup type 'US_ETHNIC_GROUP' with an enabled flag set to 'Y'
1262: -- the person is active on creation date in hr_lookups.
1263: --
1264: if hr_api.not_exists_in_hr_lookups
1265: (p_effective_date => p_creation_date
1266: ,p_lookup_type => 'US_ETHNIC_GROUP'
1267: ,p_lookup_code => p_per_information1
1268: )
1275: end if;
1276: -- Check if the value for per information2 is set on insert or has
1277: -- changed on update.
1278: --
1279: if (((nvl(p_per_information2,hr_api.g_varchar2) <>
1280: nvl(irc_ipd_shd.g_old_rec.per_information2,hr_api.g_varchar2)
1281: and p_api_updating) or
1282: (NOT p_api_updating)) and
1283: p_per_information2 is not null)
1276: -- Check if the value for per information2 is set on insert or has
1277: -- changed on update.
1278: --
1279: if (((nvl(p_per_information2,hr_api.g_varchar2) <>
1280: nvl(irc_ipd_shd.g_old_rec.per_information2,hr_api.g_varchar2)
1281: and p_api_updating) or
1282: (NOT p_api_updating)) and
1283: p_per_information2 is not null)
1284: then
1286: -- Check that per information2 exists in hr_lookups for the
1287: -- lookup type 'PER_US_I9_STATE' with an enabled flag set to 'Y' and that
1288: -- the person is active on creation date in hr_lookups.
1289: --
1290: if hr_api.not_exists_in_hr_lookups
1291: (p_effective_date => p_creation_date
1292: ,p_lookup_type => 'PER_US_I9_STATE'
1293: ,p_lookup_code => p_per_information2
1294: )
1300: end if;
1301: -- Check if the value for per information3 is set on insert or has
1302: -- changed on update.
1303: --
1304: if (((nvl(p_per_information3,hr_api.g_varchar2) <>
1305: nvl(irc_ipd_shd.g_old_rec.per_information3,hr_api.g_varchar2)
1306: and p_api_updating) or
1307: (NOT p_api_updating)) and
1308: p_per_information3 is not null)
1301: -- Check if the value for per information3 is set on insert or has
1302: -- changed on update.
1303: --
1304: if (((nvl(p_per_information3,hr_api.g_varchar2) <>
1305: nvl(irc_ipd_shd.g_old_rec.per_information3,hr_api.g_varchar2)
1306: and p_api_updating) or
1307: (NOT p_api_updating)) and
1308: p_per_information3 is not null)
1309: then
1320: --
1321: -- Check if the value for per information4 is set on insert or has
1322: -- changed on update.
1323: --
1324: if (((nvl(p_per_information4,hr_api.g_varchar2) <>
1325: nvl(irc_ipd_shd.g_old_rec.per_information4,hr_api.g_varchar2)
1326: and p_api_updating) or
1327: (NOT p_api_updating)) and
1328: p_per_information4 is not null)
1321: -- Check if the value for per information4 is set on insert or has
1322: -- changed on update.
1323: --
1324: if (((nvl(p_per_information4,hr_api.g_varchar2) <>
1325: nvl(irc_ipd_shd.g_old_rec.per_information4,hr_api.g_varchar2)
1326: and p_api_updating) or
1327: (NOT p_api_updating)) and
1328: p_per_information4 is not null)
1329: then
1331: -- Check that per information4 exists in hr_lookups for the
1332: -- lookup type 'US_VISA_TYPE' with an enabled flag set to 'Y'
1333: -- the person is active on creation date in hr_lookups.
1334: --
1335: if hr_api.not_exists_in_hr_lookups
1336: (p_effective_date => p_creation_date
1337: ,p_lookup_type => 'US_VISA_TYPE'
1338: ,p_lookup_code => p_per_information4
1339: )
1347: --
1348: -- Check if the value for per information5 is set on insert or has
1349: -- changed on update.
1350: --
1351: if (((nvl(p_per_information5,hr_api.g_varchar2) <>
1352: nvl(irc_ipd_shd.g_old_rec.per_information5,hr_api.g_varchar2)
1353: and p_api_updating) or
1354: (NOT p_api_updating)) and
1355: p_per_information5 is not null)
1348: -- Check if the value for per information5 is set on insert or has
1349: -- changed on update.
1350: --
1351: if (((nvl(p_per_information5,hr_api.g_varchar2) <>
1352: nvl(irc_ipd_shd.g_old_rec.per_information5,hr_api.g_varchar2)
1353: and p_api_updating) or
1354: (NOT p_api_updating)) and
1355: p_per_information5 is not null)
1356: then
1358: -- Check that per information5 exists in hr_lookups for the
1359: -- lookup type 'US_VISA_TYPE' with an enabled flag set to 'Y'
1360: -- the person is active on creation date in hr_lookups.
1361: --
1362: if hr_api.not_exists_in_hr_lookups
1363: (p_effective_date => p_creation_date
1364: ,p_lookup_type => 'US_VETERAN_STATUS'
1365: ,p_lookup_code => p_per_information5
1366: )
1374: --
1375: -- Check if the value for per information6 is set on insert or has
1376: -- changed on update.
1377: --
1378: if (((nvl(p_per_information6,hr_api.g_varchar2) <>
1379: nvl(irc_ipd_shd.g_old_rec.per_information6,hr_api.g_varchar2)
1380: and p_api_updating) or
1381: (NOT p_api_updating)) and
1382: p_per_information6 is not null)
1375: -- Check if the value for per information6 is set on insert or has
1376: -- changed on update.
1377: --
1378: if (((nvl(p_per_information6,hr_api.g_varchar2) <>
1379: nvl(irc_ipd_shd.g_old_rec.per_information6,hr_api.g_varchar2)
1380: and p_api_updating) or
1381: (NOT p_api_updating)) and
1382: p_per_information6 is not null)
1383: then
1385: -- Check that per information6 exists in hr_lookups for the
1386: -- lookup type 'YES_NO' with an enabled flag set to 'Y' and that
1387: -- the person is active on creation date in hr_lookups.
1388: --
1389: if hr_api.not_exists_in_hr_lookups
1390: (p_effective_date => p_creation_date
1391: ,p_lookup_type => 'YES_NO'
1392: ,p_lookup_code => p_per_information6
1393: )
1401: --
1402: -- Check if the value for per information7 is set on insert or has
1403: -- changed on update.
1404: --
1405: if (((nvl(p_per_information7,hr_api.g_varchar2) <>
1406: nvl(irc_ipd_shd.g_old_rec.per_information7,hr_api.g_varchar2)
1407: and p_api_updating) or
1408: (NOT p_api_updating)) and
1409: p_per_information7 is not null)
1402: -- Check if the value for per information7 is set on insert or has
1403: -- changed on update.
1404: --
1405: if (((nvl(p_per_information7,hr_api.g_varchar2) <>
1406: nvl(irc_ipd_shd.g_old_rec.per_information7,hr_api.g_varchar2)
1407: and p_api_updating) or
1408: (NOT p_api_updating)) and
1409: p_per_information7 is not null)
1410: then
1412: -- Check that per information7 exists in hr_lookups for the
1413: -- lookup type 'US_NEW_HIRE_STATUS' with an enabled flag set to 'Y'
1414: -- the person is active on creation date in hr_lookups.
1415: --
1416: if hr_api.not_exists_in_hr_lookups
1417: (p_effective_date => p_creation_date
1418: ,p_lookup_type => 'US_NEW_HIRE_STATUS'
1419: ,p_lookup_code => p_per_information7
1420: )
1429: --
1430: -- Check if the value for per information8 is set on insert or has
1431: -- changed on update.
1432: --
1433: if (((nvl(p_per_information8,hr_api.g_varchar2) <>
1434: nvl(irc_ipd_shd.g_old_rec.per_information8,hr_api.g_varchar2)
1435: and p_api_updating) or
1436: (NOT p_api_updating)) and
1437: p_per_information8 is not null)
1430: -- Check if the value for per information8 is set on insert or has
1431: -- changed on update.
1432: --
1433: if (((nvl(p_per_information8,hr_api.g_varchar2) <>
1434: nvl(irc_ipd_shd.g_old_rec.per_information8,hr_api.g_varchar2)
1435: and p_api_updating) or
1436: (NOT p_api_updating)) and
1437: p_per_information8 is not null)
1438: then
1438: then
1439: --
1440: -- Check if per information7 is 'EXCL'
1441: --
1442: if nvl(p_per_information7,hr_api.g_varchar2) <> 'EXCL'
1443: then
1444: --
1445: -- Error: Field must be null because per_info7 is not 'EXCL'
1446: --
1451: -- Check that per information7 exists in hr_lookups for the
1452: -- lookup type 'US_NEW_HIRE_EXCEPTIONS' with an enabled flag set to 'Y'
1453: -- the person is active on creation date in hr_lookups.
1454: --
1455: if hr_api.not_exists_in_hr_lookups
1456: (p_effective_date => p_creation_date
1457: ,p_lookup_type => 'US_NEW_HIRE_EXCEPTIONS'
1458: ,p_lookup_code => p_per_information8
1459: )
1468: --
1469: -- Check if the value for per information9 is set on insert or has
1470: -- changed on update.
1471: --
1472: if (((nvl(p_per_information9,hr_api.g_varchar2) <>
1473: nvl(irc_ipd_shd.g_old_rec.per_information9,hr_api.g_varchar2)
1474: and p_api_updating) or
1475: (NOT p_api_updating)) and
1476: p_per_information9 is not null)
1469: -- Check if the value for per information9 is set on insert or has
1470: -- changed on update.
1471: --
1472: if (((nvl(p_per_information9,hr_api.g_varchar2) <>
1473: nvl(irc_ipd_shd.g_old_rec.per_information9,hr_api.g_varchar2)
1474: and p_api_updating) or
1475: (NOT p_api_updating)) and
1476: p_per_information9 is not null)
1477: then
1479: -- Check that per information9 exists in hr_lookups for the
1480: -- lookup type 'YES_NO' with an enabled flag set to 'Y' and that
1481: -- the person is active on creation date in hr_lookups.
1482: --
1483: if hr_api.not_exists_in_hr_lookups
1484: (p_effective_date => p_creation_date
1485: ,p_lookup_type => 'YES_NO'
1486: ,p_lookup_code => p_per_information9
1487: )
1492: --
1493: end if;
1494: end if;
1495: --
1496: if (((nvl(p_per_information10,hr_api.g_varchar2) <>
1497: nvl(irc_ipd_shd.g_old_rec.per_information10,hr_api.g_varchar2)
1498: and p_api_updating) or
1499: (NOT p_api_updating)) and
1500: p_per_information10 is not null)
1493: end if;
1494: end if;
1495: --
1496: if (((nvl(p_per_information10,hr_api.g_varchar2) <>
1497: nvl(irc_ipd_shd.g_old_rec.per_information10,hr_api.g_varchar2)
1498: and p_api_updating) or
1499: (NOT p_api_updating)) and
1500: p_per_information10 is not null)
1501: then
1503: -- Check that per information10 exists in hr_lookups for the
1504: -- lookup type 'YES_NO' with an enabled flag set to 'Y' and that
1505: -- the person is active on creation date in hr_lookups.
1506: --
1507: if hr_api.not_exists_in_hr_lookups
1508: (p_effective_date => p_creation_date
1509: ,p_lookup_type => 'YES_NO'
1510: ,p_lookup_code => p_per_information10
1511: )
1648: l_api_updating := irc_ipd_shd.api_updating
1649: (p_pending_data_id => p_rec.pending_data_id
1650: );
1651: if ((l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information_category,
1652: hr_api.g_varchar2)
1653: <> nvl(p_rec.per_information_category,hr_api.g_varchar2)) or
1654: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information1,
1655: hr_api.g_varchar2)
1656: <> nvl(p_rec.per_information1,hr_api.g_varchar2)) or
1649: (p_pending_data_id => p_rec.pending_data_id
1650: );
1651: if ((l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information_category,
1652: hr_api.g_varchar2)
1653: <> nvl(p_rec.per_information_category,hr_api.g_varchar2)) or
1654: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information1,
1655: hr_api.g_varchar2)
1656: <> nvl(p_rec.per_information1,hr_api.g_varchar2)) or
1657: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information2,
1651: if ((l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information_category,
1652: hr_api.g_varchar2)
1653: <> nvl(p_rec.per_information_category,hr_api.g_varchar2)) or
1654: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information1,
1655: hr_api.g_varchar2)
1656: <> nvl(p_rec.per_information1,hr_api.g_varchar2)) or
1657: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information2,
1658: hr_api.g_varchar2)
1659: <> nvl(p_rec.per_information2,hr_api.g_varchar2)) or
1652: hr_api.g_varchar2)
1653: <> nvl(p_rec.per_information_category,hr_api.g_varchar2)) or
1654: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information1,
1655: hr_api.g_varchar2)
1656: <> nvl(p_rec.per_information1,hr_api.g_varchar2)) or
1657: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information2,
1658: hr_api.g_varchar2)
1659: <> nvl(p_rec.per_information2,hr_api.g_varchar2)) or
1660: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information3,
1654: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information1,
1655: hr_api.g_varchar2)
1656: <> nvl(p_rec.per_information1,hr_api.g_varchar2)) or
1657: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information2,
1658: hr_api.g_varchar2)
1659: <> nvl(p_rec.per_information2,hr_api.g_varchar2)) or
1660: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information3,
1661: hr_api.g_varchar2)
1662: <> nvl(p_rec.per_information3,hr_api.g_varchar2)) or
1655: hr_api.g_varchar2)
1656: <> nvl(p_rec.per_information1,hr_api.g_varchar2)) or
1657: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information2,
1658: hr_api.g_varchar2)
1659: <> nvl(p_rec.per_information2,hr_api.g_varchar2)) or
1660: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information3,
1661: hr_api.g_varchar2)
1662: <> nvl(p_rec.per_information3,hr_api.g_varchar2)) or
1663: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information4,
1657: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information2,
1658: hr_api.g_varchar2)
1659: <> nvl(p_rec.per_information2,hr_api.g_varchar2)) or
1660: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information3,
1661: hr_api.g_varchar2)
1662: <> nvl(p_rec.per_information3,hr_api.g_varchar2)) or
1663: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information4,
1664: hr_api.g_varchar2)
1665: <> nvl(p_rec.per_information4,hr_api.g_varchar2)) or
1658: hr_api.g_varchar2)
1659: <> nvl(p_rec.per_information2,hr_api.g_varchar2)) or
1660: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information3,
1661: hr_api.g_varchar2)
1662: <> nvl(p_rec.per_information3,hr_api.g_varchar2)) or
1663: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information4,
1664: hr_api.g_varchar2)
1665: <> nvl(p_rec.per_information4,hr_api.g_varchar2)) or
1666: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information5,
1660: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information3,
1661: hr_api.g_varchar2)
1662: <> nvl(p_rec.per_information3,hr_api.g_varchar2)) or
1663: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information4,
1664: hr_api.g_varchar2)
1665: <> nvl(p_rec.per_information4,hr_api.g_varchar2)) or
1666: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information5,
1667: hr_api.g_varchar2)
1668: <> nvl(p_rec.per_information5,hr_api.g_varchar2)) or
1661: hr_api.g_varchar2)
1662: <> nvl(p_rec.per_information3,hr_api.g_varchar2)) or
1663: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information4,
1664: hr_api.g_varchar2)
1665: <> nvl(p_rec.per_information4,hr_api.g_varchar2)) or
1666: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information5,
1667: hr_api.g_varchar2)
1668: <> nvl(p_rec.per_information5,hr_api.g_varchar2)) or
1669: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information6,
1663: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information4,
1664: hr_api.g_varchar2)
1665: <> nvl(p_rec.per_information4,hr_api.g_varchar2)) or
1666: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information5,
1667: hr_api.g_varchar2)
1668: <> nvl(p_rec.per_information5,hr_api.g_varchar2)) or
1669: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information6,
1670: hr_api.g_varchar2)
1671: <> nvl(p_rec.per_information6,hr_api.g_varchar2)) or
1664: hr_api.g_varchar2)
1665: <> nvl(p_rec.per_information4,hr_api.g_varchar2)) or
1666: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information5,
1667: hr_api.g_varchar2)
1668: <> nvl(p_rec.per_information5,hr_api.g_varchar2)) or
1669: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information6,
1670: hr_api.g_varchar2)
1671: <> nvl(p_rec.per_information6,hr_api.g_varchar2)) or
1672: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information7,
1666: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information5,
1667: hr_api.g_varchar2)
1668: <> nvl(p_rec.per_information5,hr_api.g_varchar2)) or
1669: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information6,
1670: hr_api.g_varchar2)
1671: <> nvl(p_rec.per_information6,hr_api.g_varchar2)) or
1672: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information7,
1673: hr_api.g_varchar2)
1674: <> nvl(p_rec.per_information7,hr_api.g_varchar2)) or
1667: hr_api.g_varchar2)
1668: <> nvl(p_rec.per_information5,hr_api.g_varchar2)) or
1669: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information6,
1670: hr_api.g_varchar2)
1671: <> nvl(p_rec.per_information6,hr_api.g_varchar2)) or
1672: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information7,
1673: hr_api.g_varchar2)
1674: <> nvl(p_rec.per_information7,hr_api.g_varchar2)) or
1675: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information8,
1669: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information6,
1670: hr_api.g_varchar2)
1671: <> nvl(p_rec.per_information6,hr_api.g_varchar2)) or
1672: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information7,
1673: hr_api.g_varchar2)
1674: <> nvl(p_rec.per_information7,hr_api.g_varchar2)) or
1675: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information8,
1676: hr_api.g_varchar2)
1677: <> nvl(p_rec.per_information8,hr_api.g_varchar2)) or
1670: hr_api.g_varchar2)
1671: <> nvl(p_rec.per_information6,hr_api.g_varchar2)) or
1672: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information7,
1673: hr_api.g_varchar2)
1674: <> nvl(p_rec.per_information7,hr_api.g_varchar2)) or
1675: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information8,
1676: hr_api.g_varchar2)
1677: <> nvl(p_rec.per_information8,hr_api.g_varchar2)) or
1678: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information9,
1672: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information7,
1673: hr_api.g_varchar2)
1674: <> nvl(p_rec.per_information7,hr_api.g_varchar2)) or
1675: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information8,
1676: hr_api.g_varchar2)
1677: <> nvl(p_rec.per_information8,hr_api.g_varchar2)) or
1678: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information9,
1679: hr_api.g_varchar2)
1680: <> nvl(p_rec.per_information9,hr_api.g_varchar2)) or
1673: hr_api.g_varchar2)
1674: <> nvl(p_rec.per_information7,hr_api.g_varchar2)) or
1675: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information8,
1676: hr_api.g_varchar2)
1677: <> nvl(p_rec.per_information8,hr_api.g_varchar2)) or
1678: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information9,
1679: hr_api.g_varchar2)
1680: <> nvl(p_rec.per_information9,hr_api.g_varchar2)) or
1681: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information10,
1675: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information8,
1676: hr_api.g_varchar2)
1677: <> nvl(p_rec.per_information8,hr_api.g_varchar2)) or
1678: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information9,
1679: hr_api.g_varchar2)
1680: <> nvl(p_rec.per_information9,hr_api.g_varchar2)) or
1681: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information10,
1682: hr_api.g_varchar2)
1683: <> nvl(p_rec.per_information10,hr_api.g_varchar2)) or
1676: hr_api.g_varchar2)
1677: <> nvl(p_rec.per_information8,hr_api.g_varchar2)) or
1678: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information9,
1679: hr_api.g_varchar2)
1680: <> nvl(p_rec.per_information9,hr_api.g_varchar2)) or
1681: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information10,
1682: hr_api.g_varchar2)
1683: <> nvl(p_rec.per_information10,hr_api.g_varchar2)) or
1684: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information11,
1678: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information9,
1679: hr_api.g_varchar2)
1680: <> nvl(p_rec.per_information9,hr_api.g_varchar2)) or
1681: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information10,
1682: hr_api.g_varchar2)
1683: <> nvl(p_rec.per_information10,hr_api.g_varchar2)) or
1684: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information11,
1685: hr_api.g_varchar2)
1686: <> nvl(p_rec.per_information11,hr_api.g_varchar2)) or
1679: hr_api.g_varchar2)
1680: <> nvl(p_rec.per_information9,hr_api.g_varchar2)) or
1681: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information10,
1682: hr_api.g_varchar2)
1683: <> nvl(p_rec.per_information10,hr_api.g_varchar2)) or
1684: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information11,
1685: hr_api.g_varchar2)
1686: <> nvl(p_rec.per_information11,hr_api.g_varchar2)) or
1687: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information12,
1681: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information10,
1682: hr_api.g_varchar2)
1683: <> nvl(p_rec.per_information10,hr_api.g_varchar2)) or
1684: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information11,
1685: hr_api.g_varchar2)
1686: <> nvl(p_rec.per_information11,hr_api.g_varchar2)) or
1687: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information12,
1688: hr_api.g_varchar2)
1689: <> nvl(p_rec.per_information12,hr_api.g_varchar2)) or
1682: hr_api.g_varchar2)
1683: <> nvl(p_rec.per_information10,hr_api.g_varchar2)) or
1684: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information11,
1685: hr_api.g_varchar2)
1686: <> nvl(p_rec.per_information11,hr_api.g_varchar2)) or
1687: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information12,
1688: hr_api.g_varchar2)
1689: <> nvl(p_rec.per_information12,hr_api.g_varchar2)) or
1690: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information13,
1684: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information11,
1685: hr_api.g_varchar2)
1686: <> nvl(p_rec.per_information11,hr_api.g_varchar2)) or
1687: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information12,
1688: hr_api.g_varchar2)
1689: <> nvl(p_rec.per_information12,hr_api.g_varchar2)) or
1690: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information13,
1691: hr_api.g_varchar2)
1692: <> nvl(p_rec.per_information13,hr_api.g_varchar2)) or
1685: hr_api.g_varchar2)
1686: <> nvl(p_rec.per_information11,hr_api.g_varchar2)) or
1687: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information12,
1688: hr_api.g_varchar2)
1689: <> nvl(p_rec.per_information12,hr_api.g_varchar2)) or
1690: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information13,
1691: hr_api.g_varchar2)
1692: <> nvl(p_rec.per_information13,hr_api.g_varchar2)) or
1693: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information14,
1687: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information12,
1688: hr_api.g_varchar2)
1689: <> nvl(p_rec.per_information12,hr_api.g_varchar2)) or
1690: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information13,
1691: hr_api.g_varchar2)
1692: <> nvl(p_rec.per_information13,hr_api.g_varchar2)) or
1693: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information14,
1694: hr_api.g_varchar2)
1695: <> nvl(p_rec.per_information14,hr_api.g_varchar2)) or
1688: hr_api.g_varchar2)
1689: <> nvl(p_rec.per_information12,hr_api.g_varchar2)) or
1690: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information13,
1691: hr_api.g_varchar2)
1692: <> nvl(p_rec.per_information13,hr_api.g_varchar2)) or
1693: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information14,
1694: hr_api.g_varchar2)
1695: <> nvl(p_rec.per_information14,hr_api.g_varchar2)) or
1696: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information15,
1690: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information13,
1691: hr_api.g_varchar2)
1692: <> nvl(p_rec.per_information13,hr_api.g_varchar2)) or
1693: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information14,
1694: hr_api.g_varchar2)
1695: <> nvl(p_rec.per_information14,hr_api.g_varchar2)) or
1696: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information15,
1697: hr_api.g_varchar2)
1698: <> nvl(p_rec.per_information15,hr_api.g_varchar2)) or
1691: hr_api.g_varchar2)
1692: <> nvl(p_rec.per_information13,hr_api.g_varchar2)) or
1693: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information14,
1694: hr_api.g_varchar2)
1695: <> nvl(p_rec.per_information14,hr_api.g_varchar2)) or
1696: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information15,
1697: hr_api.g_varchar2)
1698: <> nvl(p_rec.per_information15,hr_api.g_varchar2)) or
1699: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information16,
1693: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information14,
1694: hr_api.g_varchar2)
1695: <> nvl(p_rec.per_information14,hr_api.g_varchar2)) or
1696: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information15,
1697: hr_api.g_varchar2)
1698: <> nvl(p_rec.per_information15,hr_api.g_varchar2)) or
1699: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information16,
1700: hr_api.g_varchar2)
1701: <> nvl(p_rec.per_information16,hr_api.g_varchar2)) or
1694: hr_api.g_varchar2)
1695: <> nvl(p_rec.per_information14,hr_api.g_varchar2)) or
1696: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information15,
1697: hr_api.g_varchar2)
1698: <> nvl(p_rec.per_information15,hr_api.g_varchar2)) or
1699: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information16,
1700: hr_api.g_varchar2)
1701: <> nvl(p_rec.per_information16,hr_api.g_varchar2)) or
1702: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information17,
1696: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information15,
1697: hr_api.g_varchar2)
1698: <> nvl(p_rec.per_information15,hr_api.g_varchar2)) or
1699: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information16,
1700: hr_api.g_varchar2)
1701: <> nvl(p_rec.per_information16,hr_api.g_varchar2)) or
1702: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information17,
1703: hr_api.g_varchar2)
1704: <> nvl(p_rec.per_information17,hr_api.g_varchar2)) or
1697: hr_api.g_varchar2)
1698: <> nvl(p_rec.per_information15,hr_api.g_varchar2)) or
1699: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information16,
1700: hr_api.g_varchar2)
1701: <> nvl(p_rec.per_information16,hr_api.g_varchar2)) or
1702: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information17,
1703: hr_api.g_varchar2)
1704: <> nvl(p_rec.per_information17,hr_api.g_varchar2)) or
1705: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information18,
1699: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information16,
1700: hr_api.g_varchar2)
1701: <> nvl(p_rec.per_information16,hr_api.g_varchar2)) or
1702: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information17,
1703: hr_api.g_varchar2)
1704: <> nvl(p_rec.per_information17,hr_api.g_varchar2)) or
1705: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information18,
1706: hr_api.g_varchar2)
1707: <> nvl(p_rec.per_information18,hr_api.g_varchar2)) or
1700: hr_api.g_varchar2)
1701: <> nvl(p_rec.per_information16,hr_api.g_varchar2)) or
1702: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information17,
1703: hr_api.g_varchar2)
1704: <> nvl(p_rec.per_information17,hr_api.g_varchar2)) or
1705: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information18,
1706: hr_api.g_varchar2)
1707: <> nvl(p_rec.per_information18,hr_api.g_varchar2)) or
1708: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information19,
1702: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information17,
1703: hr_api.g_varchar2)
1704: <> nvl(p_rec.per_information17,hr_api.g_varchar2)) or
1705: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information18,
1706: hr_api.g_varchar2)
1707: <> nvl(p_rec.per_information18,hr_api.g_varchar2)) or
1708: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information19,
1709: hr_api.g_varchar2)
1710: <> nvl(p_rec.per_information19,hr_api.g_varchar2)) or
1703: hr_api.g_varchar2)
1704: <> nvl(p_rec.per_information17,hr_api.g_varchar2)) or
1705: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information18,
1706: hr_api.g_varchar2)
1707: <> nvl(p_rec.per_information18,hr_api.g_varchar2)) or
1708: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information19,
1709: hr_api.g_varchar2)
1710: <> nvl(p_rec.per_information19,hr_api.g_varchar2)) or
1711: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information20,
1705: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information18,
1706: hr_api.g_varchar2)
1707: <> nvl(p_rec.per_information18,hr_api.g_varchar2)) or
1708: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information19,
1709: hr_api.g_varchar2)
1710: <> nvl(p_rec.per_information19,hr_api.g_varchar2)) or
1711: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information20,
1712: hr_api.g_varchar2)
1713: <> nvl(p_rec.per_information20,hr_api.g_varchar2)) or
1706: hr_api.g_varchar2)
1707: <> nvl(p_rec.per_information18,hr_api.g_varchar2)) or
1708: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information19,
1709: hr_api.g_varchar2)
1710: <> nvl(p_rec.per_information19,hr_api.g_varchar2)) or
1711: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information20,
1712: hr_api.g_varchar2)
1713: <> nvl(p_rec.per_information20,hr_api.g_varchar2)) or
1714: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information21,
1708: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information19,
1709: hr_api.g_varchar2)
1710: <> nvl(p_rec.per_information19,hr_api.g_varchar2)) or
1711: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information20,
1712: hr_api.g_varchar2)
1713: <> nvl(p_rec.per_information20,hr_api.g_varchar2)) or
1714: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information21,
1715: hr_api.g_varchar2)
1716: <> nvl(p_rec.per_information21,hr_api.g_varchar2)) or
1709: hr_api.g_varchar2)
1710: <> nvl(p_rec.per_information19,hr_api.g_varchar2)) or
1711: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information20,
1712: hr_api.g_varchar2)
1713: <> nvl(p_rec.per_information20,hr_api.g_varchar2)) or
1714: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information21,
1715: hr_api.g_varchar2)
1716: <> nvl(p_rec.per_information21,hr_api.g_varchar2)) or
1717: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information22,
1711: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information20,
1712: hr_api.g_varchar2)
1713: <> nvl(p_rec.per_information20,hr_api.g_varchar2)) or
1714: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information21,
1715: hr_api.g_varchar2)
1716: <> nvl(p_rec.per_information21,hr_api.g_varchar2)) or
1717: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information22,
1718: hr_api.g_varchar2)
1719: <> nvl(p_rec.per_information22,hr_api.g_varchar2)) or
1712: hr_api.g_varchar2)
1713: <> nvl(p_rec.per_information20,hr_api.g_varchar2)) or
1714: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information21,
1715: hr_api.g_varchar2)
1716: <> nvl(p_rec.per_information21,hr_api.g_varchar2)) or
1717: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information22,
1718: hr_api.g_varchar2)
1719: <> nvl(p_rec.per_information22,hr_api.g_varchar2)) or
1720: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information23,
1714: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information21,
1715: hr_api.g_varchar2)
1716: <> nvl(p_rec.per_information21,hr_api.g_varchar2)) or
1717: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information22,
1718: hr_api.g_varchar2)
1719: <> nvl(p_rec.per_information22,hr_api.g_varchar2)) or
1720: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information23,
1721: hr_api.g_varchar2)
1722: <> nvl(p_rec.per_information23,hr_api.g_varchar2)) or
1715: hr_api.g_varchar2)
1716: <> nvl(p_rec.per_information21,hr_api.g_varchar2)) or
1717: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information22,
1718: hr_api.g_varchar2)
1719: <> nvl(p_rec.per_information22,hr_api.g_varchar2)) or
1720: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information23,
1721: hr_api.g_varchar2)
1722: <> nvl(p_rec.per_information23,hr_api.g_varchar2)) or
1723: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information24,
1717: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information22,
1718: hr_api.g_varchar2)
1719: <> nvl(p_rec.per_information22,hr_api.g_varchar2)) or
1720: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information23,
1721: hr_api.g_varchar2)
1722: <> nvl(p_rec.per_information23,hr_api.g_varchar2)) or
1723: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information24,
1724: hr_api.g_varchar2)
1725: <> nvl(p_rec.per_information24,hr_api.g_varchar2)) or
1718: hr_api.g_varchar2)
1719: <> nvl(p_rec.per_information22,hr_api.g_varchar2)) or
1720: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information23,
1721: hr_api.g_varchar2)
1722: <> nvl(p_rec.per_information23,hr_api.g_varchar2)) or
1723: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information24,
1724: hr_api.g_varchar2)
1725: <> nvl(p_rec.per_information24,hr_api.g_varchar2)) or
1726: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information25,
1720: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information23,
1721: hr_api.g_varchar2)
1722: <> nvl(p_rec.per_information23,hr_api.g_varchar2)) or
1723: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information24,
1724: hr_api.g_varchar2)
1725: <> nvl(p_rec.per_information24,hr_api.g_varchar2)) or
1726: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information25,
1727: hr_api.g_varchar2)
1728: <> nvl(p_rec.per_information25,hr_api.g_varchar2)) or
1721: hr_api.g_varchar2)
1722: <> nvl(p_rec.per_information23,hr_api.g_varchar2)) or
1723: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information24,
1724: hr_api.g_varchar2)
1725: <> nvl(p_rec.per_information24,hr_api.g_varchar2)) or
1726: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information25,
1727: hr_api.g_varchar2)
1728: <> nvl(p_rec.per_information25,hr_api.g_varchar2)) or
1729: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information26,
1723: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information24,
1724: hr_api.g_varchar2)
1725: <> nvl(p_rec.per_information24,hr_api.g_varchar2)) or
1726: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information25,
1727: hr_api.g_varchar2)
1728: <> nvl(p_rec.per_information25,hr_api.g_varchar2)) or
1729: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information26,
1730: hr_api.g_varchar2)
1731: <> nvl(p_rec.per_information26,hr_api.g_varchar2)) or
1724: hr_api.g_varchar2)
1725: <> nvl(p_rec.per_information24,hr_api.g_varchar2)) or
1726: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information25,
1727: hr_api.g_varchar2)
1728: <> nvl(p_rec.per_information25,hr_api.g_varchar2)) or
1729: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information26,
1730: hr_api.g_varchar2)
1731: <> nvl(p_rec.per_information26,hr_api.g_varchar2)) or
1732: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information27,
1726: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information25,
1727: hr_api.g_varchar2)
1728: <> nvl(p_rec.per_information25,hr_api.g_varchar2)) or
1729: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information26,
1730: hr_api.g_varchar2)
1731: <> nvl(p_rec.per_information26,hr_api.g_varchar2)) or
1732: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information27,
1733: hr_api.g_varchar2)
1734: <> nvl(p_rec.per_information27,hr_api.g_varchar2)) or
1727: hr_api.g_varchar2)
1728: <> nvl(p_rec.per_information25,hr_api.g_varchar2)) or
1729: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information26,
1730: hr_api.g_varchar2)
1731: <> nvl(p_rec.per_information26,hr_api.g_varchar2)) or
1732: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information27,
1733: hr_api.g_varchar2)
1734: <> nvl(p_rec.per_information27,hr_api.g_varchar2)) or
1735: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information28,
1729: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information26,
1730: hr_api.g_varchar2)
1731: <> nvl(p_rec.per_information26,hr_api.g_varchar2)) or
1732: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information27,
1733: hr_api.g_varchar2)
1734: <> nvl(p_rec.per_information27,hr_api.g_varchar2)) or
1735: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information28,
1736: hr_api.g_varchar2)
1737: <> nvl(p_rec.per_information28,hr_api.g_varchar2)) or
1730: hr_api.g_varchar2)
1731: <> nvl(p_rec.per_information26,hr_api.g_varchar2)) or
1732: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information27,
1733: hr_api.g_varchar2)
1734: <> nvl(p_rec.per_information27,hr_api.g_varchar2)) or
1735: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information28,
1736: hr_api.g_varchar2)
1737: <> nvl(p_rec.per_information28,hr_api.g_varchar2)) or
1738: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information29,
1732: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information27,
1733: hr_api.g_varchar2)
1734: <> nvl(p_rec.per_information27,hr_api.g_varchar2)) or
1735: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information28,
1736: hr_api.g_varchar2)
1737: <> nvl(p_rec.per_information28,hr_api.g_varchar2)) or
1738: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information29,
1739: hr_api.g_varchar2)
1740: <> nvl(p_rec.per_information29,hr_api.g_varchar2)) or
1733: hr_api.g_varchar2)
1734: <> nvl(p_rec.per_information27,hr_api.g_varchar2)) or
1735: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information28,
1736: hr_api.g_varchar2)
1737: <> nvl(p_rec.per_information28,hr_api.g_varchar2)) or
1738: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information29,
1739: hr_api.g_varchar2)
1740: <> nvl(p_rec.per_information29,hr_api.g_varchar2)) or
1741: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information30,
1735: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information28,
1736: hr_api.g_varchar2)
1737: <> nvl(p_rec.per_information28,hr_api.g_varchar2)) or
1738: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information29,
1739: hr_api.g_varchar2)
1740: <> nvl(p_rec.per_information29,hr_api.g_varchar2)) or
1741: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information30,
1742: hr_api.g_varchar2)
1743: <> nvl(p_rec.per_information30,hr_api.g_varchar2)) or
1736: hr_api.g_varchar2)
1737: <> nvl(p_rec.per_information28,hr_api.g_varchar2)) or
1738: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information29,
1739: hr_api.g_varchar2)
1740: <> nvl(p_rec.per_information29,hr_api.g_varchar2)) or
1741: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information30,
1742: hr_api.g_varchar2)
1743: <> nvl(p_rec.per_information30,hr_api.g_varchar2)) or
1744: (NOT l_api_updating))
1738: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information29,
1739: hr_api.g_varchar2)
1740: <> nvl(p_rec.per_information29,hr_api.g_varchar2)) or
1741: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information30,
1742: hr_api.g_varchar2)
1743: <> nvl(p_rec.per_information30,hr_api.g_varchar2)) or
1744: (NOT l_api_updating))
1745: then
1746: -- Check if the per_information_category is 'GB' or 'US' calling
1739: hr_api.g_varchar2)
1740: <> nvl(p_rec.per_information29,hr_api.g_varchar2)) or
1741: (l_api_updating and nvl(irc_ipd_shd.g_old_rec.per_information30,
1742: hr_api.g_varchar2)
1743: <> nvl(p_rec.per_information30,hr_api.g_varchar2)) or
1744: (NOT l_api_updating))
1745: then
1746: -- Check if the per_information_category is 'GB' or 'US' calling
1747: -- the appropriate validation routine or generating an error