[Home] [Help]
31: hr_utility.set_location('Entering:'|| l_proc, 10);
32: --
33: -- Ensure that all the mandatory parameter are not null
34: --
35: hr_api.mandatory_arg_error
36: (p_api_name => l_proc
37: ,p_argument => 'search_criteria_id'
38: ,p_argument_value => p_search_criteria_id
39: );
61: hr_utility.set_location('Entering:'|| l_proc, 10);
62: --
63: -- Ensure that all the mandatory parameter are not null
64: --
65: hr_api.mandatory_arg_error
66: (p_api_name => l_proc
67: ,p_argument => 'search_criteria_id'
68: ,p_argument_value => p_search_criteria_id
69: );
109: begin
110: hr_utility.set_location('Entering:'||l_proc,10);
111: --
112: if ((p_rec.search_criteria_id is not null) and (
113: nvl(irc_isc_shd.g_old_rec.isc_information_category, hr_api.g_varchar2) <>
114: nvl(p_rec.isc_information_category, hr_api.g_varchar2) or
115: nvl(irc_isc_shd.g_old_rec.isc_information1, hr_api.g_varchar2) <>
116: nvl(p_rec.isc_information1, hr_api.g_varchar2) or
117: nvl(irc_isc_shd.g_old_rec.isc_information2, hr_api.g_varchar2) <>
110: hr_utility.set_location('Entering:'||l_proc,10);
111: --
112: if ((p_rec.search_criteria_id is not null) and (
113: nvl(irc_isc_shd.g_old_rec.isc_information_category, hr_api.g_varchar2) <>
114: nvl(p_rec.isc_information_category, hr_api.g_varchar2) or
115: nvl(irc_isc_shd.g_old_rec.isc_information1, hr_api.g_varchar2) <>
116: nvl(p_rec.isc_information1, hr_api.g_varchar2) or
117: nvl(irc_isc_shd.g_old_rec.isc_information2, hr_api.g_varchar2) <>
118: nvl(p_rec.isc_information2, hr_api.g_varchar2) or
111: --
112: if ((p_rec.search_criteria_id is not null) and (
113: nvl(irc_isc_shd.g_old_rec.isc_information_category, hr_api.g_varchar2) <>
114: nvl(p_rec.isc_information_category, hr_api.g_varchar2) or
115: nvl(irc_isc_shd.g_old_rec.isc_information1, hr_api.g_varchar2) <>
116: nvl(p_rec.isc_information1, hr_api.g_varchar2) or
117: nvl(irc_isc_shd.g_old_rec.isc_information2, hr_api.g_varchar2) <>
118: nvl(p_rec.isc_information2, hr_api.g_varchar2) or
119: nvl(irc_isc_shd.g_old_rec.isc_information3, hr_api.g_varchar2) <>
112: if ((p_rec.search_criteria_id is not null) and (
113: nvl(irc_isc_shd.g_old_rec.isc_information_category, hr_api.g_varchar2) <>
114: nvl(p_rec.isc_information_category, hr_api.g_varchar2) or
115: nvl(irc_isc_shd.g_old_rec.isc_information1, hr_api.g_varchar2) <>
116: nvl(p_rec.isc_information1, hr_api.g_varchar2) or
117: nvl(irc_isc_shd.g_old_rec.isc_information2, hr_api.g_varchar2) <>
118: nvl(p_rec.isc_information2, hr_api.g_varchar2) or
119: nvl(irc_isc_shd.g_old_rec.isc_information3, hr_api.g_varchar2) <>
120: nvl(p_rec.isc_information3, hr_api.g_varchar2) or
113: nvl(irc_isc_shd.g_old_rec.isc_information_category, hr_api.g_varchar2) <>
114: nvl(p_rec.isc_information_category, hr_api.g_varchar2) or
115: nvl(irc_isc_shd.g_old_rec.isc_information1, hr_api.g_varchar2) <>
116: nvl(p_rec.isc_information1, hr_api.g_varchar2) or
117: nvl(irc_isc_shd.g_old_rec.isc_information2, hr_api.g_varchar2) <>
118: nvl(p_rec.isc_information2, hr_api.g_varchar2) or
119: nvl(irc_isc_shd.g_old_rec.isc_information3, hr_api.g_varchar2) <>
120: nvl(p_rec.isc_information3, hr_api.g_varchar2) or
121: nvl(irc_isc_shd.g_old_rec.isc_information4, hr_api.g_varchar2) <>
114: nvl(p_rec.isc_information_category, hr_api.g_varchar2) or
115: nvl(irc_isc_shd.g_old_rec.isc_information1, hr_api.g_varchar2) <>
116: nvl(p_rec.isc_information1, hr_api.g_varchar2) or
117: nvl(irc_isc_shd.g_old_rec.isc_information2, hr_api.g_varchar2) <>
118: nvl(p_rec.isc_information2, hr_api.g_varchar2) or
119: nvl(irc_isc_shd.g_old_rec.isc_information3, hr_api.g_varchar2) <>
120: nvl(p_rec.isc_information3, hr_api.g_varchar2) or
121: nvl(irc_isc_shd.g_old_rec.isc_information4, hr_api.g_varchar2) <>
122: nvl(p_rec.isc_information4, hr_api.g_varchar2) or
115: nvl(irc_isc_shd.g_old_rec.isc_information1, hr_api.g_varchar2) <>
116: nvl(p_rec.isc_information1, hr_api.g_varchar2) or
117: nvl(irc_isc_shd.g_old_rec.isc_information2, hr_api.g_varchar2) <>
118: nvl(p_rec.isc_information2, hr_api.g_varchar2) or
119: nvl(irc_isc_shd.g_old_rec.isc_information3, hr_api.g_varchar2) <>
120: nvl(p_rec.isc_information3, hr_api.g_varchar2) or
121: nvl(irc_isc_shd.g_old_rec.isc_information4, hr_api.g_varchar2) <>
122: nvl(p_rec.isc_information4, hr_api.g_varchar2) or
123: nvl(irc_isc_shd.g_old_rec.isc_information5, hr_api.g_varchar2) <>
116: nvl(p_rec.isc_information1, hr_api.g_varchar2) or
117: nvl(irc_isc_shd.g_old_rec.isc_information2, hr_api.g_varchar2) <>
118: nvl(p_rec.isc_information2, hr_api.g_varchar2) or
119: nvl(irc_isc_shd.g_old_rec.isc_information3, hr_api.g_varchar2) <>
120: nvl(p_rec.isc_information3, hr_api.g_varchar2) or
121: nvl(irc_isc_shd.g_old_rec.isc_information4, hr_api.g_varchar2) <>
122: nvl(p_rec.isc_information4, hr_api.g_varchar2) or
123: nvl(irc_isc_shd.g_old_rec.isc_information5, hr_api.g_varchar2) <>
124: nvl(p_rec.isc_information5, hr_api.g_varchar2) or
117: nvl(irc_isc_shd.g_old_rec.isc_information2, hr_api.g_varchar2) <>
118: nvl(p_rec.isc_information2, hr_api.g_varchar2) or
119: nvl(irc_isc_shd.g_old_rec.isc_information3, hr_api.g_varchar2) <>
120: nvl(p_rec.isc_information3, hr_api.g_varchar2) or
121: nvl(irc_isc_shd.g_old_rec.isc_information4, hr_api.g_varchar2) <>
122: nvl(p_rec.isc_information4, hr_api.g_varchar2) or
123: nvl(irc_isc_shd.g_old_rec.isc_information5, hr_api.g_varchar2) <>
124: nvl(p_rec.isc_information5, hr_api.g_varchar2) or
125: nvl(irc_isc_shd.g_old_rec.isc_information6, hr_api.g_varchar2) <>
118: nvl(p_rec.isc_information2, hr_api.g_varchar2) or
119: nvl(irc_isc_shd.g_old_rec.isc_information3, hr_api.g_varchar2) <>
120: nvl(p_rec.isc_information3, hr_api.g_varchar2) or
121: nvl(irc_isc_shd.g_old_rec.isc_information4, hr_api.g_varchar2) <>
122: nvl(p_rec.isc_information4, hr_api.g_varchar2) or
123: nvl(irc_isc_shd.g_old_rec.isc_information5, hr_api.g_varchar2) <>
124: nvl(p_rec.isc_information5, hr_api.g_varchar2) or
125: nvl(irc_isc_shd.g_old_rec.isc_information6, hr_api.g_varchar2) <>
126: nvl(p_rec.isc_information6, hr_api.g_varchar2) or
119: nvl(irc_isc_shd.g_old_rec.isc_information3, hr_api.g_varchar2) <>
120: nvl(p_rec.isc_information3, hr_api.g_varchar2) or
121: nvl(irc_isc_shd.g_old_rec.isc_information4, hr_api.g_varchar2) <>
122: nvl(p_rec.isc_information4, hr_api.g_varchar2) or
123: nvl(irc_isc_shd.g_old_rec.isc_information5, hr_api.g_varchar2) <>
124: nvl(p_rec.isc_information5, hr_api.g_varchar2) or
125: nvl(irc_isc_shd.g_old_rec.isc_information6, hr_api.g_varchar2) <>
126: nvl(p_rec.isc_information6, hr_api.g_varchar2) or
127: nvl(irc_isc_shd.g_old_rec.isc_information7, hr_api.g_varchar2) <>
120: nvl(p_rec.isc_information3, hr_api.g_varchar2) or
121: nvl(irc_isc_shd.g_old_rec.isc_information4, hr_api.g_varchar2) <>
122: nvl(p_rec.isc_information4, hr_api.g_varchar2) or
123: nvl(irc_isc_shd.g_old_rec.isc_information5, hr_api.g_varchar2) <>
124: nvl(p_rec.isc_information5, hr_api.g_varchar2) or
125: nvl(irc_isc_shd.g_old_rec.isc_information6, hr_api.g_varchar2) <>
126: nvl(p_rec.isc_information6, hr_api.g_varchar2) or
127: nvl(irc_isc_shd.g_old_rec.isc_information7, hr_api.g_varchar2) <>
128: nvl(p_rec.isc_information7, hr_api.g_varchar2) or
121: nvl(irc_isc_shd.g_old_rec.isc_information4, hr_api.g_varchar2) <>
122: nvl(p_rec.isc_information4, hr_api.g_varchar2) or
123: nvl(irc_isc_shd.g_old_rec.isc_information5, hr_api.g_varchar2) <>
124: nvl(p_rec.isc_information5, hr_api.g_varchar2) or
125: nvl(irc_isc_shd.g_old_rec.isc_information6, hr_api.g_varchar2) <>
126: nvl(p_rec.isc_information6, hr_api.g_varchar2) or
127: nvl(irc_isc_shd.g_old_rec.isc_information7, hr_api.g_varchar2) <>
128: nvl(p_rec.isc_information7, hr_api.g_varchar2) or
129: nvl(irc_isc_shd.g_old_rec.isc_information8, hr_api.g_varchar2) <>
122: nvl(p_rec.isc_information4, hr_api.g_varchar2) or
123: nvl(irc_isc_shd.g_old_rec.isc_information5, hr_api.g_varchar2) <>
124: nvl(p_rec.isc_information5, hr_api.g_varchar2) or
125: nvl(irc_isc_shd.g_old_rec.isc_information6, hr_api.g_varchar2) <>
126: nvl(p_rec.isc_information6, hr_api.g_varchar2) or
127: nvl(irc_isc_shd.g_old_rec.isc_information7, hr_api.g_varchar2) <>
128: nvl(p_rec.isc_information7, hr_api.g_varchar2) or
129: nvl(irc_isc_shd.g_old_rec.isc_information8, hr_api.g_varchar2) <>
130: nvl(p_rec.isc_information8, hr_api.g_varchar2) or
123: nvl(irc_isc_shd.g_old_rec.isc_information5, hr_api.g_varchar2) <>
124: nvl(p_rec.isc_information5, hr_api.g_varchar2) or
125: nvl(irc_isc_shd.g_old_rec.isc_information6, hr_api.g_varchar2) <>
126: nvl(p_rec.isc_information6, hr_api.g_varchar2) or
127: nvl(irc_isc_shd.g_old_rec.isc_information7, hr_api.g_varchar2) <>
128: nvl(p_rec.isc_information7, hr_api.g_varchar2) or
129: nvl(irc_isc_shd.g_old_rec.isc_information8, hr_api.g_varchar2) <>
130: nvl(p_rec.isc_information8, hr_api.g_varchar2) or
131: nvl(irc_isc_shd.g_old_rec.isc_information9, hr_api.g_varchar2) <>
124: nvl(p_rec.isc_information5, hr_api.g_varchar2) or
125: nvl(irc_isc_shd.g_old_rec.isc_information6, hr_api.g_varchar2) <>
126: nvl(p_rec.isc_information6, hr_api.g_varchar2) or
127: nvl(irc_isc_shd.g_old_rec.isc_information7, hr_api.g_varchar2) <>
128: nvl(p_rec.isc_information7, hr_api.g_varchar2) or
129: nvl(irc_isc_shd.g_old_rec.isc_information8, hr_api.g_varchar2) <>
130: nvl(p_rec.isc_information8, hr_api.g_varchar2) or
131: nvl(irc_isc_shd.g_old_rec.isc_information9, hr_api.g_varchar2) <>
132: nvl(p_rec.isc_information9, hr_api.g_varchar2) or
125: nvl(irc_isc_shd.g_old_rec.isc_information6, hr_api.g_varchar2) <>
126: nvl(p_rec.isc_information6, hr_api.g_varchar2) or
127: nvl(irc_isc_shd.g_old_rec.isc_information7, hr_api.g_varchar2) <>
128: nvl(p_rec.isc_information7, hr_api.g_varchar2) or
129: nvl(irc_isc_shd.g_old_rec.isc_information8, hr_api.g_varchar2) <>
130: nvl(p_rec.isc_information8, hr_api.g_varchar2) or
131: nvl(irc_isc_shd.g_old_rec.isc_information9, hr_api.g_varchar2) <>
132: nvl(p_rec.isc_information9, hr_api.g_varchar2) or
133: nvl(irc_isc_shd.g_old_rec.isc_information10, hr_api.g_varchar2) <>
126: nvl(p_rec.isc_information6, hr_api.g_varchar2) or
127: nvl(irc_isc_shd.g_old_rec.isc_information7, hr_api.g_varchar2) <>
128: nvl(p_rec.isc_information7, hr_api.g_varchar2) or
129: nvl(irc_isc_shd.g_old_rec.isc_information8, hr_api.g_varchar2) <>
130: nvl(p_rec.isc_information8, hr_api.g_varchar2) or
131: nvl(irc_isc_shd.g_old_rec.isc_information9, hr_api.g_varchar2) <>
132: nvl(p_rec.isc_information9, hr_api.g_varchar2) or
133: nvl(irc_isc_shd.g_old_rec.isc_information10, hr_api.g_varchar2) <>
134: nvl(p_rec.isc_information10, hr_api.g_varchar2) or
127: nvl(irc_isc_shd.g_old_rec.isc_information7, hr_api.g_varchar2) <>
128: nvl(p_rec.isc_information7, hr_api.g_varchar2) or
129: nvl(irc_isc_shd.g_old_rec.isc_information8, hr_api.g_varchar2) <>
130: nvl(p_rec.isc_information8, hr_api.g_varchar2) or
131: nvl(irc_isc_shd.g_old_rec.isc_information9, hr_api.g_varchar2) <>
132: nvl(p_rec.isc_information9, hr_api.g_varchar2) or
133: nvl(irc_isc_shd.g_old_rec.isc_information10, hr_api.g_varchar2) <>
134: nvl(p_rec.isc_information10, hr_api.g_varchar2) or
135: nvl(irc_isc_shd.g_old_rec.isc_information11, hr_api.g_varchar2) <>
128: nvl(p_rec.isc_information7, hr_api.g_varchar2) or
129: nvl(irc_isc_shd.g_old_rec.isc_information8, hr_api.g_varchar2) <>
130: nvl(p_rec.isc_information8, hr_api.g_varchar2) or
131: nvl(irc_isc_shd.g_old_rec.isc_information9, hr_api.g_varchar2) <>
132: nvl(p_rec.isc_information9, hr_api.g_varchar2) or
133: nvl(irc_isc_shd.g_old_rec.isc_information10, hr_api.g_varchar2) <>
134: nvl(p_rec.isc_information10, hr_api.g_varchar2) or
135: nvl(irc_isc_shd.g_old_rec.isc_information11, hr_api.g_varchar2) <>
136: nvl(p_rec.isc_information11, hr_api.g_varchar2) or
129: nvl(irc_isc_shd.g_old_rec.isc_information8, hr_api.g_varchar2) <>
130: nvl(p_rec.isc_information8, hr_api.g_varchar2) or
131: nvl(irc_isc_shd.g_old_rec.isc_information9, hr_api.g_varchar2) <>
132: nvl(p_rec.isc_information9, hr_api.g_varchar2) or
133: nvl(irc_isc_shd.g_old_rec.isc_information10, hr_api.g_varchar2) <>
134: nvl(p_rec.isc_information10, hr_api.g_varchar2) or
135: nvl(irc_isc_shd.g_old_rec.isc_information11, hr_api.g_varchar2) <>
136: nvl(p_rec.isc_information11, hr_api.g_varchar2) or
137: nvl(irc_isc_shd.g_old_rec.isc_information12, hr_api.g_varchar2) <>
130: nvl(p_rec.isc_information8, hr_api.g_varchar2) or
131: nvl(irc_isc_shd.g_old_rec.isc_information9, hr_api.g_varchar2) <>
132: nvl(p_rec.isc_information9, hr_api.g_varchar2) or
133: nvl(irc_isc_shd.g_old_rec.isc_information10, hr_api.g_varchar2) <>
134: nvl(p_rec.isc_information10, hr_api.g_varchar2) or
135: nvl(irc_isc_shd.g_old_rec.isc_information11, hr_api.g_varchar2) <>
136: nvl(p_rec.isc_information11, hr_api.g_varchar2) or
137: nvl(irc_isc_shd.g_old_rec.isc_information12, hr_api.g_varchar2) <>
138: nvl(p_rec.isc_information12, hr_api.g_varchar2) or
131: nvl(irc_isc_shd.g_old_rec.isc_information9, hr_api.g_varchar2) <>
132: nvl(p_rec.isc_information9, hr_api.g_varchar2) or
133: nvl(irc_isc_shd.g_old_rec.isc_information10, hr_api.g_varchar2) <>
134: nvl(p_rec.isc_information10, hr_api.g_varchar2) or
135: nvl(irc_isc_shd.g_old_rec.isc_information11, hr_api.g_varchar2) <>
136: nvl(p_rec.isc_information11, hr_api.g_varchar2) or
137: nvl(irc_isc_shd.g_old_rec.isc_information12, hr_api.g_varchar2) <>
138: nvl(p_rec.isc_information12, hr_api.g_varchar2) or
139: nvl(irc_isc_shd.g_old_rec.isc_information13, hr_api.g_varchar2) <>
132: nvl(p_rec.isc_information9, hr_api.g_varchar2) or
133: nvl(irc_isc_shd.g_old_rec.isc_information10, hr_api.g_varchar2) <>
134: nvl(p_rec.isc_information10, hr_api.g_varchar2) or
135: nvl(irc_isc_shd.g_old_rec.isc_information11, hr_api.g_varchar2) <>
136: nvl(p_rec.isc_information11, hr_api.g_varchar2) or
137: nvl(irc_isc_shd.g_old_rec.isc_information12, hr_api.g_varchar2) <>
138: nvl(p_rec.isc_information12, hr_api.g_varchar2) or
139: nvl(irc_isc_shd.g_old_rec.isc_information13, hr_api.g_varchar2) <>
140: nvl(p_rec.isc_information13, hr_api.g_varchar2) or
133: nvl(irc_isc_shd.g_old_rec.isc_information10, hr_api.g_varchar2) <>
134: nvl(p_rec.isc_information10, hr_api.g_varchar2) or
135: nvl(irc_isc_shd.g_old_rec.isc_information11, hr_api.g_varchar2) <>
136: nvl(p_rec.isc_information11, hr_api.g_varchar2) or
137: nvl(irc_isc_shd.g_old_rec.isc_information12, hr_api.g_varchar2) <>
138: nvl(p_rec.isc_information12, hr_api.g_varchar2) or
139: nvl(irc_isc_shd.g_old_rec.isc_information13, hr_api.g_varchar2) <>
140: nvl(p_rec.isc_information13, hr_api.g_varchar2) or
141: nvl(irc_isc_shd.g_old_rec.isc_information14, hr_api.g_varchar2) <>
134: nvl(p_rec.isc_information10, hr_api.g_varchar2) or
135: nvl(irc_isc_shd.g_old_rec.isc_information11, hr_api.g_varchar2) <>
136: nvl(p_rec.isc_information11, hr_api.g_varchar2) or
137: nvl(irc_isc_shd.g_old_rec.isc_information12, hr_api.g_varchar2) <>
138: nvl(p_rec.isc_information12, hr_api.g_varchar2) or
139: nvl(irc_isc_shd.g_old_rec.isc_information13, hr_api.g_varchar2) <>
140: nvl(p_rec.isc_information13, hr_api.g_varchar2) or
141: nvl(irc_isc_shd.g_old_rec.isc_information14, hr_api.g_varchar2) <>
142: nvl(p_rec.isc_information14, hr_api.g_varchar2) or
135: nvl(irc_isc_shd.g_old_rec.isc_information11, hr_api.g_varchar2) <>
136: nvl(p_rec.isc_information11, hr_api.g_varchar2) or
137: nvl(irc_isc_shd.g_old_rec.isc_information12, hr_api.g_varchar2) <>
138: nvl(p_rec.isc_information12, hr_api.g_varchar2) or
139: nvl(irc_isc_shd.g_old_rec.isc_information13, hr_api.g_varchar2) <>
140: nvl(p_rec.isc_information13, hr_api.g_varchar2) or
141: nvl(irc_isc_shd.g_old_rec.isc_information14, hr_api.g_varchar2) <>
142: nvl(p_rec.isc_information14, hr_api.g_varchar2) or
143: nvl(irc_isc_shd.g_old_rec.isc_information15, hr_api.g_varchar2) <>
136: nvl(p_rec.isc_information11, hr_api.g_varchar2) or
137: nvl(irc_isc_shd.g_old_rec.isc_information12, hr_api.g_varchar2) <>
138: nvl(p_rec.isc_information12, hr_api.g_varchar2) or
139: nvl(irc_isc_shd.g_old_rec.isc_information13, hr_api.g_varchar2) <>
140: nvl(p_rec.isc_information13, hr_api.g_varchar2) or
141: nvl(irc_isc_shd.g_old_rec.isc_information14, hr_api.g_varchar2) <>
142: nvl(p_rec.isc_information14, hr_api.g_varchar2) or
143: nvl(irc_isc_shd.g_old_rec.isc_information15, hr_api.g_varchar2) <>
144: nvl(p_rec.isc_information15, hr_api.g_varchar2) or
137: nvl(irc_isc_shd.g_old_rec.isc_information12, hr_api.g_varchar2) <>
138: nvl(p_rec.isc_information12, hr_api.g_varchar2) or
139: nvl(irc_isc_shd.g_old_rec.isc_information13, hr_api.g_varchar2) <>
140: nvl(p_rec.isc_information13, hr_api.g_varchar2) or
141: nvl(irc_isc_shd.g_old_rec.isc_information14, hr_api.g_varchar2) <>
142: nvl(p_rec.isc_information14, hr_api.g_varchar2) or
143: nvl(irc_isc_shd.g_old_rec.isc_information15, hr_api.g_varchar2) <>
144: nvl(p_rec.isc_information15, hr_api.g_varchar2) or
145: nvl(irc_isc_shd.g_old_rec.isc_information16, hr_api.g_varchar2) <>
138: nvl(p_rec.isc_information12, hr_api.g_varchar2) or
139: nvl(irc_isc_shd.g_old_rec.isc_information13, hr_api.g_varchar2) <>
140: nvl(p_rec.isc_information13, hr_api.g_varchar2) or
141: nvl(irc_isc_shd.g_old_rec.isc_information14, hr_api.g_varchar2) <>
142: nvl(p_rec.isc_information14, hr_api.g_varchar2) or
143: nvl(irc_isc_shd.g_old_rec.isc_information15, hr_api.g_varchar2) <>
144: nvl(p_rec.isc_information15, hr_api.g_varchar2) or
145: nvl(irc_isc_shd.g_old_rec.isc_information16, hr_api.g_varchar2) <>
146: nvl(p_rec.isc_information16, hr_api.g_varchar2) or
139: nvl(irc_isc_shd.g_old_rec.isc_information13, hr_api.g_varchar2) <>
140: nvl(p_rec.isc_information13, hr_api.g_varchar2) or
141: nvl(irc_isc_shd.g_old_rec.isc_information14, hr_api.g_varchar2) <>
142: nvl(p_rec.isc_information14, hr_api.g_varchar2) or
143: nvl(irc_isc_shd.g_old_rec.isc_information15, hr_api.g_varchar2) <>
144: nvl(p_rec.isc_information15, hr_api.g_varchar2) or
145: nvl(irc_isc_shd.g_old_rec.isc_information16, hr_api.g_varchar2) <>
146: nvl(p_rec.isc_information16, hr_api.g_varchar2) or
147: nvl(irc_isc_shd.g_old_rec.isc_information17, hr_api.g_varchar2) <>
140: nvl(p_rec.isc_information13, hr_api.g_varchar2) or
141: nvl(irc_isc_shd.g_old_rec.isc_information14, hr_api.g_varchar2) <>
142: nvl(p_rec.isc_information14, hr_api.g_varchar2) or
143: nvl(irc_isc_shd.g_old_rec.isc_information15, hr_api.g_varchar2) <>
144: nvl(p_rec.isc_information15, hr_api.g_varchar2) or
145: nvl(irc_isc_shd.g_old_rec.isc_information16, hr_api.g_varchar2) <>
146: nvl(p_rec.isc_information16, hr_api.g_varchar2) or
147: nvl(irc_isc_shd.g_old_rec.isc_information17, hr_api.g_varchar2) <>
148: nvl(p_rec.isc_information17, hr_api.g_varchar2) or
141: nvl(irc_isc_shd.g_old_rec.isc_information14, hr_api.g_varchar2) <>
142: nvl(p_rec.isc_information14, hr_api.g_varchar2) or
143: nvl(irc_isc_shd.g_old_rec.isc_information15, hr_api.g_varchar2) <>
144: nvl(p_rec.isc_information15, hr_api.g_varchar2) or
145: nvl(irc_isc_shd.g_old_rec.isc_information16, hr_api.g_varchar2) <>
146: nvl(p_rec.isc_information16, hr_api.g_varchar2) or
147: nvl(irc_isc_shd.g_old_rec.isc_information17, hr_api.g_varchar2) <>
148: nvl(p_rec.isc_information17, hr_api.g_varchar2) or
149: nvl(irc_isc_shd.g_old_rec.isc_information18, hr_api.g_varchar2) <>
142: nvl(p_rec.isc_information14, hr_api.g_varchar2) or
143: nvl(irc_isc_shd.g_old_rec.isc_information15, hr_api.g_varchar2) <>
144: nvl(p_rec.isc_information15, hr_api.g_varchar2) or
145: nvl(irc_isc_shd.g_old_rec.isc_information16, hr_api.g_varchar2) <>
146: nvl(p_rec.isc_information16, hr_api.g_varchar2) or
147: nvl(irc_isc_shd.g_old_rec.isc_information17, hr_api.g_varchar2) <>
148: nvl(p_rec.isc_information17, hr_api.g_varchar2) or
149: nvl(irc_isc_shd.g_old_rec.isc_information18, hr_api.g_varchar2) <>
150: nvl(p_rec.isc_information18, hr_api.g_varchar2) or
143: nvl(irc_isc_shd.g_old_rec.isc_information15, hr_api.g_varchar2) <>
144: nvl(p_rec.isc_information15, hr_api.g_varchar2) or
145: nvl(irc_isc_shd.g_old_rec.isc_information16, hr_api.g_varchar2) <>
146: nvl(p_rec.isc_information16, hr_api.g_varchar2) or
147: nvl(irc_isc_shd.g_old_rec.isc_information17, hr_api.g_varchar2) <>
148: nvl(p_rec.isc_information17, hr_api.g_varchar2) or
149: nvl(irc_isc_shd.g_old_rec.isc_information18, hr_api.g_varchar2) <>
150: nvl(p_rec.isc_information18, hr_api.g_varchar2) or
151: nvl(irc_isc_shd.g_old_rec.isc_information19, hr_api.g_varchar2) <>
144: nvl(p_rec.isc_information15, hr_api.g_varchar2) or
145: nvl(irc_isc_shd.g_old_rec.isc_information16, hr_api.g_varchar2) <>
146: nvl(p_rec.isc_information16, hr_api.g_varchar2) or
147: nvl(irc_isc_shd.g_old_rec.isc_information17, hr_api.g_varchar2) <>
148: nvl(p_rec.isc_information17, hr_api.g_varchar2) or
149: nvl(irc_isc_shd.g_old_rec.isc_information18, hr_api.g_varchar2) <>
150: nvl(p_rec.isc_information18, hr_api.g_varchar2) or
151: nvl(irc_isc_shd.g_old_rec.isc_information19, hr_api.g_varchar2) <>
152: nvl(p_rec.isc_information19, hr_api.g_varchar2) or
145: nvl(irc_isc_shd.g_old_rec.isc_information16, hr_api.g_varchar2) <>
146: nvl(p_rec.isc_information16, hr_api.g_varchar2) or
147: nvl(irc_isc_shd.g_old_rec.isc_information17, hr_api.g_varchar2) <>
148: nvl(p_rec.isc_information17, hr_api.g_varchar2) or
149: nvl(irc_isc_shd.g_old_rec.isc_information18, hr_api.g_varchar2) <>
150: nvl(p_rec.isc_information18, hr_api.g_varchar2) or
151: nvl(irc_isc_shd.g_old_rec.isc_information19, hr_api.g_varchar2) <>
152: nvl(p_rec.isc_information19, hr_api.g_varchar2) or
153: nvl(irc_isc_shd.g_old_rec.isc_information20, hr_api.g_varchar2) <>
146: nvl(p_rec.isc_information16, hr_api.g_varchar2) or
147: nvl(irc_isc_shd.g_old_rec.isc_information17, hr_api.g_varchar2) <>
148: nvl(p_rec.isc_information17, hr_api.g_varchar2) or
149: nvl(irc_isc_shd.g_old_rec.isc_information18, hr_api.g_varchar2) <>
150: nvl(p_rec.isc_information18, hr_api.g_varchar2) or
151: nvl(irc_isc_shd.g_old_rec.isc_information19, hr_api.g_varchar2) <>
152: nvl(p_rec.isc_information19, hr_api.g_varchar2) or
153: nvl(irc_isc_shd.g_old_rec.isc_information20, hr_api.g_varchar2) <>
154: nvl(p_rec.isc_information20, hr_api.g_varchar2) or
147: nvl(irc_isc_shd.g_old_rec.isc_information17, hr_api.g_varchar2) <>
148: nvl(p_rec.isc_information17, hr_api.g_varchar2) or
149: nvl(irc_isc_shd.g_old_rec.isc_information18, hr_api.g_varchar2) <>
150: nvl(p_rec.isc_information18, hr_api.g_varchar2) or
151: nvl(irc_isc_shd.g_old_rec.isc_information19, hr_api.g_varchar2) <>
152: nvl(p_rec.isc_information19, hr_api.g_varchar2) or
153: nvl(irc_isc_shd.g_old_rec.isc_information20, hr_api.g_varchar2) <>
154: nvl(p_rec.isc_information20, hr_api.g_varchar2) or
155: nvl(irc_isc_shd.g_old_rec.isc_information21, hr_api.g_varchar2) <>
148: nvl(p_rec.isc_information17, hr_api.g_varchar2) or
149: nvl(irc_isc_shd.g_old_rec.isc_information18, hr_api.g_varchar2) <>
150: nvl(p_rec.isc_information18, hr_api.g_varchar2) or
151: nvl(irc_isc_shd.g_old_rec.isc_information19, hr_api.g_varchar2) <>
152: nvl(p_rec.isc_information19, hr_api.g_varchar2) or
153: nvl(irc_isc_shd.g_old_rec.isc_information20, hr_api.g_varchar2) <>
154: nvl(p_rec.isc_information20, hr_api.g_varchar2) or
155: nvl(irc_isc_shd.g_old_rec.isc_information21, hr_api.g_varchar2) <>
156: nvl(p_rec.isc_information21, hr_api.g_varchar2) or
149: nvl(irc_isc_shd.g_old_rec.isc_information18, hr_api.g_varchar2) <>
150: nvl(p_rec.isc_information18, hr_api.g_varchar2) or
151: nvl(irc_isc_shd.g_old_rec.isc_information19, hr_api.g_varchar2) <>
152: nvl(p_rec.isc_information19, hr_api.g_varchar2) or
153: nvl(irc_isc_shd.g_old_rec.isc_information20, hr_api.g_varchar2) <>
154: nvl(p_rec.isc_information20, hr_api.g_varchar2) or
155: nvl(irc_isc_shd.g_old_rec.isc_information21, hr_api.g_varchar2) <>
156: nvl(p_rec.isc_information21, hr_api.g_varchar2) or
157: nvl(irc_isc_shd.g_old_rec.isc_information22, hr_api.g_varchar2) <>
150: nvl(p_rec.isc_information18, hr_api.g_varchar2) or
151: nvl(irc_isc_shd.g_old_rec.isc_information19, hr_api.g_varchar2) <>
152: nvl(p_rec.isc_information19, hr_api.g_varchar2) or
153: nvl(irc_isc_shd.g_old_rec.isc_information20, hr_api.g_varchar2) <>
154: nvl(p_rec.isc_information20, hr_api.g_varchar2) or
155: nvl(irc_isc_shd.g_old_rec.isc_information21, hr_api.g_varchar2) <>
156: nvl(p_rec.isc_information21, hr_api.g_varchar2) or
157: nvl(irc_isc_shd.g_old_rec.isc_information22, hr_api.g_varchar2) <>
158: nvl(p_rec.isc_information22, hr_api.g_varchar2) or
151: nvl(irc_isc_shd.g_old_rec.isc_information19, hr_api.g_varchar2) <>
152: nvl(p_rec.isc_information19, hr_api.g_varchar2) or
153: nvl(irc_isc_shd.g_old_rec.isc_information20, hr_api.g_varchar2) <>
154: nvl(p_rec.isc_information20, hr_api.g_varchar2) or
155: nvl(irc_isc_shd.g_old_rec.isc_information21, hr_api.g_varchar2) <>
156: nvl(p_rec.isc_information21, hr_api.g_varchar2) or
157: nvl(irc_isc_shd.g_old_rec.isc_information22, hr_api.g_varchar2) <>
158: nvl(p_rec.isc_information22, hr_api.g_varchar2) or
159: nvl(irc_isc_shd.g_old_rec.isc_information23, hr_api.g_varchar2) <>
152: nvl(p_rec.isc_information19, hr_api.g_varchar2) or
153: nvl(irc_isc_shd.g_old_rec.isc_information20, hr_api.g_varchar2) <>
154: nvl(p_rec.isc_information20, hr_api.g_varchar2) or
155: nvl(irc_isc_shd.g_old_rec.isc_information21, hr_api.g_varchar2) <>
156: nvl(p_rec.isc_information21, hr_api.g_varchar2) or
157: nvl(irc_isc_shd.g_old_rec.isc_information22, hr_api.g_varchar2) <>
158: nvl(p_rec.isc_information22, hr_api.g_varchar2) or
159: nvl(irc_isc_shd.g_old_rec.isc_information23, hr_api.g_varchar2) <>
160: nvl(p_rec.isc_information23, hr_api.g_varchar2) or
153: nvl(irc_isc_shd.g_old_rec.isc_information20, hr_api.g_varchar2) <>
154: nvl(p_rec.isc_information20, hr_api.g_varchar2) or
155: nvl(irc_isc_shd.g_old_rec.isc_information21, hr_api.g_varchar2) <>
156: nvl(p_rec.isc_information21, hr_api.g_varchar2) or
157: nvl(irc_isc_shd.g_old_rec.isc_information22, hr_api.g_varchar2) <>
158: nvl(p_rec.isc_information22, hr_api.g_varchar2) or
159: nvl(irc_isc_shd.g_old_rec.isc_information23, hr_api.g_varchar2) <>
160: nvl(p_rec.isc_information23, hr_api.g_varchar2) or
161: nvl(irc_isc_shd.g_old_rec.isc_information24, hr_api.g_varchar2) <>
154: nvl(p_rec.isc_information20, hr_api.g_varchar2) or
155: nvl(irc_isc_shd.g_old_rec.isc_information21, hr_api.g_varchar2) <>
156: nvl(p_rec.isc_information21, hr_api.g_varchar2) or
157: nvl(irc_isc_shd.g_old_rec.isc_information22, hr_api.g_varchar2) <>
158: nvl(p_rec.isc_information22, hr_api.g_varchar2) or
159: nvl(irc_isc_shd.g_old_rec.isc_information23, hr_api.g_varchar2) <>
160: nvl(p_rec.isc_information23, hr_api.g_varchar2) or
161: nvl(irc_isc_shd.g_old_rec.isc_information24, hr_api.g_varchar2) <>
162: nvl(p_rec.isc_information24, hr_api.g_varchar2) or
155: nvl(irc_isc_shd.g_old_rec.isc_information21, hr_api.g_varchar2) <>
156: nvl(p_rec.isc_information21, hr_api.g_varchar2) or
157: nvl(irc_isc_shd.g_old_rec.isc_information22, hr_api.g_varchar2) <>
158: nvl(p_rec.isc_information22, hr_api.g_varchar2) or
159: nvl(irc_isc_shd.g_old_rec.isc_information23, hr_api.g_varchar2) <>
160: nvl(p_rec.isc_information23, hr_api.g_varchar2) or
161: nvl(irc_isc_shd.g_old_rec.isc_information24, hr_api.g_varchar2) <>
162: nvl(p_rec.isc_information24, hr_api.g_varchar2) or
163: nvl(irc_isc_shd.g_old_rec.isc_information25, hr_api.g_varchar2) <>
156: nvl(p_rec.isc_information21, hr_api.g_varchar2) or
157: nvl(irc_isc_shd.g_old_rec.isc_information22, hr_api.g_varchar2) <>
158: nvl(p_rec.isc_information22, hr_api.g_varchar2) or
159: nvl(irc_isc_shd.g_old_rec.isc_information23, hr_api.g_varchar2) <>
160: nvl(p_rec.isc_information23, hr_api.g_varchar2) or
161: nvl(irc_isc_shd.g_old_rec.isc_information24, hr_api.g_varchar2) <>
162: nvl(p_rec.isc_information24, hr_api.g_varchar2) or
163: nvl(irc_isc_shd.g_old_rec.isc_information25, hr_api.g_varchar2) <>
164: nvl(p_rec.isc_information25, hr_api.g_varchar2) or
157: nvl(irc_isc_shd.g_old_rec.isc_information22, hr_api.g_varchar2) <>
158: nvl(p_rec.isc_information22, hr_api.g_varchar2) or
159: nvl(irc_isc_shd.g_old_rec.isc_information23, hr_api.g_varchar2) <>
160: nvl(p_rec.isc_information23, hr_api.g_varchar2) or
161: nvl(irc_isc_shd.g_old_rec.isc_information24, hr_api.g_varchar2) <>
162: nvl(p_rec.isc_information24, hr_api.g_varchar2) or
163: nvl(irc_isc_shd.g_old_rec.isc_information25, hr_api.g_varchar2) <>
164: nvl(p_rec.isc_information25, hr_api.g_varchar2) or
165: nvl(irc_isc_shd.g_old_rec.isc_information26, hr_api.g_varchar2) <>
158: nvl(p_rec.isc_information22, hr_api.g_varchar2) or
159: nvl(irc_isc_shd.g_old_rec.isc_information23, hr_api.g_varchar2) <>
160: nvl(p_rec.isc_information23, hr_api.g_varchar2) or
161: nvl(irc_isc_shd.g_old_rec.isc_information24, hr_api.g_varchar2) <>
162: nvl(p_rec.isc_information24, hr_api.g_varchar2) or
163: nvl(irc_isc_shd.g_old_rec.isc_information25, hr_api.g_varchar2) <>
164: nvl(p_rec.isc_information25, hr_api.g_varchar2) or
165: nvl(irc_isc_shd.g_old_rec.isc_information26, hr_api.g_varchar2) <>
166: nvl(p_rec.isc_information26, hr_api.g_varchar2) or
159: nvl(irc_isc_shd.g_old_rec.isc_information23, hr_api.g_varchar2) <>
160: nvl(p_rec.isc_information23, hr_api.g_varchar2) or
161: nvl(irc_isc_shd.g_old_rec.isc_information24, hr_api.g_varchar2) <>
162: nvl(p_rec.isc_information24, hr_api.g_varchar2) or
163: nvl(irc_isc_shd.g_old_rec.isc_information25, hr_api.g_varchar2) <>
164: nvl(p_rec.isc_information25, hr_api.g_varchar2) or
165: nvl(irc_isc_shd.g_old_rec.isc_information26, hr_api.g_varchar2) <>
166: nvl(p_rec.isc_information26, hr_api.g_varchar2) or
167: nvl(irc_isc_shd.g_old_rec.isc_information27, hr_api.g_varchar2) <>
160: nvl(p_rec.isc_information23, hr_api.g_varchar2) or
161: nvl(irc_isc_shd.g_old_rec.isc_information24, hr_api.g_varchar2) <>
162: nvl(p_rec.isc_information24, hr_api.g_varchar2) or
163: nvl(irc_isc_shd.g_old_rec.isc_information25, hr_api.g_varchar2) <>
164: nvl(p_rec.isc_information25, hr_api.g_varchar2) or
165: nvl(irc_isc_shd.g_old_rec.isc_information26, hr_api.g_varchar2) <>
166: nvl(p_rec.isc_information26, hr_api.g_varchar2) or
167: nvl(irc_isc_shd.g_old_rec.isc_information27, hr_api.g_varchar2) <>
168: nvl(p_rec.isc_information27, hr_api.g_varchar2) or
161: nvl(irc_isc_shd.g_old_rec.isc_information24, hr_api.g_varchar2) <>
162: nvl(p_rec.isc_information24, hr_api.g_varchar2) or
163: nvl(irc_isc_shd.g_old_rec.isc_information25, hr_api.g_varchar2) <>
164: nvl(p_rec.isc_information25, hr_api.g_varchar2) or
165: nvl(irc_isc_shd.g_old_rec.isc_information26, hr_api.g_varchar2) <>
166: nvl(p_rec.isc_information26, hr_api.g_varchar2) or
167: nvl(irc_isc_shd.g_old_rec.isc_information27, hr_api.g_varchar2) <>
168: nvl(p_rec.isc_information27, hr_api.g_varchar2) or
169: nvl(irc_isc_shd.g_old_rec.isc_information28, hr_api.g_varchar2) <>
162: nvl(p_rec.isc_information24, hr_api.g_varchar2) or
163: nvl(irc_isc_shd.g_old_rec.isc_information25, hr_api.g_varchar2) <>
164: nvl(p_rec.isc_information25, hr_api.g_varchar2) or
165: nvl(irc_isc_shd.g_old_rec.isc_information26, hr_api.g_varchar2) <>
166: nvl(p_rec.isc_information26, hr_api.g_varchar2) or
167: nvl(irc_isc_shd.g_old_rec.isc_information27, hr_api.g_varchar2) <>
168: nvl(p_rec.isc_information27, hr_api.g_varchar2) or
169: nvl(irc_isc_shd.g_old_rec.isc_information28, hr_api.g_varchar2) <>
170: nvl(p_rec.isc_information28, hr_api.g_varchar2) or
163: nvl(irc_isc_shd.g_old_rec.isc_information25, hr_api.g_varchar2) <>
164: nvl(p_rec.isc_information25, hr_api.g_varchar2) or
165: nvl(irc_isc_shd.g_old_rec.isc_information26, hr_api.g_varchar2) <>
166: nvl(p_rec.isc_information26, hr_api.g_varchar2) or
167: nvl(irc_isc_shd.g_old_rec.isc_information27, hr_api.g_varchar2) <>
168: nvl(p_rec.isc_information27, hr_api.g_varchar2) or
169: nvl(irc_isc_shd.g_old_rec.isc_information28, hr_api.g_varchar2) <>
170: nvl(p_rec.isc_information28, hr_api.g_varchar2) or
171: nvl(irc_isc_shd.g_old_rec.isc_information29, hr_api.g_varchar2) <>
164: nvl(p_rec.isc_information25, hr_api.g_varchar2) or
165: nvl(irc_isc_shd.g_old_rec.isc_information26, hr_api.g_varchar2) <>
166: nvl(p_rec.isc_information26, hr_api.g_varchar2) or
167: nvl(irc_isc_shd.g_old_rec.isc_information27, hr_api.g_varchar2) <>
168: nvl(p_rec.isc_information27, hr_api.g_varchar2) or
169: nvl(irc_isc_shd.g_old_rec.isc_information28, hr_api.g_varchar2) <>
170: nvl(p_rec.isc_information28, hr_api.g_varchar2) or
171: nvl(irc_isc_shd.g_old_rec.isc_information29, hr_api.g_varchar2) <>
172: nvl(p_rec.isc_information29, hr_api.g_varchar2) or
165: nvl(irc_isc_shd.g_old_rec.isc_information26, hr_api.g_varchar2) <>
166: nvl(p_rec.isc_information26, hr_api.g_varchar2) or
167: nvl(irc_isc_shd.g_old_rec.isc_information27, hr_api.g_varchar2) <>
168: nvl(p_rec.isc_information27, hr_api.g_varchar2) or
169: nvl(irc_isc_shd.g_old_rec.isc_information28, hr_api.g_varchar2) <>
170: nvl(p_rec.isc_information28, hr_api.g_varchar2) or
171: nvl(irc_isc_shd.g_old_rec.isc_information29, hr_api.g_varchar2) <>
172: nvl(p_rec.isc_information29, hr_api.g_varchar2) or
173: nvl(irc_isc_shd.g_old_rec.isc_information30, hr_api.g_varchar2) <>
166: nvl(p_rec.isc_information26, hr_api.g_varchar2) or
167: nvl(irc_isc_shd.g_old_rec.isc_information27, hr_api.g_varchar2) <>
168: nvl(p_rec.isc_information27, hr_api.g_varchar2) or
169: nvl(irc_isc_shd.g_old_rec.isc_information28, hr_api.g_varchar2) <>
170: nvl(p_rec.isc_information28, hr_api.g_varchar2) or
171: nvl(irc_isc_shd.g_old_rec.isc_information29, hr_api.g_varchar2) <>
172: nvl(p_rec.isc_information29, hr_api.g_varchar2) or
173: nvl(irc_isc_shd.g_old_rec.isc_information30, hr_api.g_varchar2) <>
174: nvl(p_rec.isc_information30, hr_api.g_varchar2) ))
167: nvl(irc_isc_shd.g_old_rec.isc_information27, hr_api.g_varchar2) <>
168: nvl(p_rec.isc_information27, hr_api.g_varchar2) or
169: nvl(irc_isc_shd.g_old_rec.isc_information28, hr_api.g_varchar2) <>
170: nvl(p_rec.isc_information28, hr_api.g_varchar2) or
171: nvl(irc_isc_shd.g_old_rec.isc_information29, hr_api.g_varchar2) <>
172: nvl(p_rec.isc_information29, hr_api.g_varchar2) or
173: nvl(irc_isc_shd.g_old_rec.isc_information30, hr_api.g_varchar2) <>
174: nvl(p_rec.isc_information30, hr_api.g_varchar2) ))
175: or (p_rec.search_criteria_id is null) then
168: nvl(p_rec.isc_information27, hr_api.g_varchar2) or
169: nvl(irc_isc_shd.g_old_rec.isc_information28, hr_api.g_varchar2) <>
170: nvl(p_rec.isc_information28, hr_api.g_varchar2) or
171: nvl(irc_isc_shd.g_old_rec.isc_information29, hr_api.g_varchar2) <>
172: nvl(p_rec.isc_information29, hr_api.g_varchar2) or
173: nvl(irc_isc_shd.g_old_rec.isc_information30, hr_api.g_varchar2) <>
174: nvl(p_rec.isc_information30, hr_api.g_varchar2) ))
175: or (p_rec.search_criteria_id is null) then
176: --
169: nvl(irc_isc_shd.g_old_rec.isc_information28, hr_api.g_varchar2) <>
170: nvl(p_rec.isc_information28, hr_api.g_varchar2) or
171: nvl(irc_isc_shd.g_old_rec.isc_information29, hr_api.g_varchar2) <>
172: nvl(p_rec.isc_information29, hr_api.g_varchar2) or
173: nvl(irc_isc_shd.g_old_rec.isc_information30, hr_api.g_varchar2) <>
174: nvl(p_rec.isc_information30, hr_api.g_varchar2) ))
175: or (p_rec.search_criteria_id is null) then
176: --
177: -- Only execute the validation if absolutely necessary:
170: nvl(p_rec.isc_information28, hr_api.g_varchar2) or
171: nvl(irc_isc_shd.g_old_rec.isc_information29, hr_api.g_varchar2) <>
172: nvl(p_rec.isc_information29, hr_api.g_varchar2) or
173: nvl(irc_isc_shd.g_old_rec.isc_information30, hr_api.g_varchar2) <>
174: nvl(p_rec.isc_information30, hr_api.g_varchar2) ))
175: or (p_rec.search_criteria_id is null) then
176: --
177: -- Only execute the validation if absolutely necessary:
178: -- a) During update, the structure column value or any
286: begin
287: hr_utility.set_location('Entering:'||l_proc,10);
288: --
289: if ((p_rec.search_criteria_id is not null) and (
290: nvl(irc_isc_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
291: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
292: nvl(irc_isc_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
293: nvl(p_rec.attribute1, hr_api.g_varchar2) or
294: nvl(irc_isc_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
287: hr_utility.set_location('Entering:'||l_proc,10);
288: --
289: if ((p_rec.search_criteria_id is not null) and (
290: nvl(irc_isc_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
291: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
292: nvl(irc_isc_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
293: nvl(p_rec.attribute1, hr_api.g_varchar2) or
294: nvl(irc_isc_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
295: nvl(p_rec.attribute2, hr_api.g_varchar2) or
288: --
289: if ((p_rec.search_criteria_id is not null) and (
290: nvl(irc_isc_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
291: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
292: nvl(irc_isc_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
293: nvl(p_rec.attribute1, hr_api.g_varchar2) or
294: nvl(irc_isc_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
295: nvl(p_rec.attribute2, hr_api.g_varchar2) or
296: nvl(irc_isc_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
289: if ((p_rec.search_criteria_id is not null) and (
290: nvl(irc_isc_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
291: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
292: nvl(irc_isc_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
293: nvl(p_rec.attribute1, hr_api.g_varchar2) or
294: nvl(irc_isc_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
295: nvl(p_rec.attribute2, hr_api.g_varchar2) or
296: nvl(irc_isc_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
297: nvl(p_rec.attribute3, hr_api.g_varchar2) or
290: nvl(irc_isc_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
291: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
292: nvl(irc_isc_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
293: nvl(p_rec.attribute1, hr_api.g_varchar2) or
294: nvl(irc_isc_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
295: nvl(p_rec.attribute2, hr_api.g_varchar2) or
296: nvl(irc_isc_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
297: nvl(p_rec.attribute3, hr_api.g_varchar2) or
298: nvl(irc_isc_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
291: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
292: nvl(irc_isc_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
293: nvl(p_rec.attribute1, hr_api.g_varchar2) or
294: nvl(irc_isc_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
295: nvl(p_rec.attribute2, hr_api.g_varchar2) or
296: nvl(irc_isc_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
297: nvl(p_rec.attribute3, hr_api.g_varchar2) or
298: nvl(irc_isc_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
299: nvl(p_rec.attribute4, hr_api.g_varchar2) or
292: nvl(irc_isc_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
293: nvl(p_rec.attribute1, hr_api.g_varchar2) or
294: nvl(irc_isc_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
295: nvl(p_rec.attribute2, hr_api.g_varchar2) or
296: nvl(irc_isc_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
297: nvl(p_rec.attribute3, hr_api.g_varchar2) or
298: nvl(irc_isc_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
299: nvl(p_rec.attribute4, hr_api.g_varchar2) or
300: nvl(irc_isc_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
293: nvl(p_rec.attribute1, hr_api.g_varchar2) or
294: nvl(irc_isc_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
295: nvl(p_rec.attribute2, hr_api.g_varchar2) or
296: nvl(irc_isc_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
297: nvl(p_rec.attribute3, hr_api.g_varchar2) or
298: nvl(irc_isc_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
299: nvl(p_rec.attribute4, hr_api.g_varchar2) or
300: nvl(irc_isc_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
301: nvl(p_rec.attribute5, hr_api.g_varchar2) or
294: nvl(irc_isc_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
295: nvl(p_rec.attribute2, hr_api.g_varchar2) or
296: nvl(irc_isc_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
297: nvl(p_rec.attribute3, hr_api.g_varchar2) or
298: nvl(irc_isc_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
299: nvl(p_rec.attribute4, hr_api.g_varchar2) or
300: nvl(irc_isc_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
301: nvl(p_rec.attribute5, hr_api.g_varchar2) or
302: nvl(irc_isc_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
295: nvl(p_rec.attribute2, hr_api.g_varchar2) or
296: nvl(irc_isc_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
297: nvl(p_rec.attribute3, hr_api.g_varchar2) or
298: nvl(irc_isc_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
299: nvl(p_rec.attribute4, hr_api.g_varchar2) or
300: nvl(irc_isc_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
301: nvl(p_rec.attribute5, hr_api.g_varchar2) or
302: nvl(irc_isc_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
303: nvl(p_rec.attribute6, hr_api.g_varchar2) or
296: nvl(irc_isc_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
297: nvl(p_rec.attribute3, hr_api.g_varchar2) or
298: nvl(irc_isc_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
299: nvl(p_rec.attribute4, hr_api.g_varchar2) or
300: nvl(irc_isc_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
301: nvl(p_rec.attribute5, hr_api.g_varchar2) or
302: nvl(irc_isc_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
303: nvl(p_rec.attribute6, hr_api.g_varchar2) or
304: nvl(irc_isc_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
297: nvl(p_rec.attribute3, hr_api.g_varchar2) or
298: nvl(irc_isc_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
299: nvl(p_rec.attribute4, hr_api.g_varchar2) or
300: nvl(irc_isc_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
301: nvl(p_rec.attribute5, hr_api.g_varchar2) or
302: nvl(irc_isc_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
303: nvl(p_rec.attribute6, hr_api.g_varchar2) or
304: nvl(irc_isc_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
305: nvl(p_rec.attribute7, hr_api.g_varchar2) or
298: nvl(irc_isc_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
299: nvl(p_rec.attribute4, hr_api.g_varchar2) or
300: nvl(irc_isc_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
301: nvl(p_rec.attribute5, hr_api.g_varchar2) or
302: nvl(irc_isc_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
303: nvl(p_rec.attribute6, hr_api.g_varchar2) or
304: nvl(irc_isc_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
305: nvl(p_rec.attribute7, hr_api.g_varchar2) or
306: nvl(irc_isc_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
299: nvl(p_rec.attribute4, hr_api.g_varchar2) or
300: nvl(irc_isc_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
301: nvl(p_rec.attribute5, hr_api.g_varchar2) or
302: nvl(irc_isc_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
303: nvl(p_rec.attribute6, hr_api.g_varchar2) or
304: nvl(irc_isc_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
305: nvl(p_rec.attribute7, hr_api.g_varchar2) or
306: nvl(irc_isc_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
307: nvl(p_rec.attribute8, hr_api.g_varchar2) or
300: nvl(irc_isc_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
301: nvl(p_rec.attribute5, hr_api.g_varchar2) or
302: nvl(irc_isc_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
303: nvl(p_rec.attribute6, hr_api.g_varchar2) or
304: nvl(irc_isc_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
305: nvl(p_rec.attribute7, hr_api.g_varchar2) or
306: nvl(irc_isc_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
307: nvl(p_rec.attribute8, hr_api.g_varchar2) or
308: nvl(irc_isc_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
301: nvl(p_rec.attribute5, hr_api.g_varchar2) or
302: nvl(irc_isc_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
303: nvl(p_rec.attribute6, hr_api.g_varchar2) or
304: nvl(irc_isc_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
305: nvl(p_rec.attribute7, hr_api.g_varchar2) or
306: nvl(irc_isc_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
307: nvl(p_rec.attribute8, hr_api.g_varchar2) or
308: nvl(irc_isc_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
309: nvl(p_rec.attribute9, hr_api.g_varchar2) or
302: nvl(irc_isc_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
303: nvl(p_rec.attribute6, hr_api.g_varchar2) or
304: nvl(irc_isc_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
305: nvl(p_rec.attribute7, hr_api.g_varchar2) or
306: nvl(irc_isc_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
307: nvl(p_rec.attribute8, hr_api.g_varchar2) or
308: nvl(irc_isc_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
309: nvl(p_rec.attribute9, hr_api.g_varchar2) or
310: nvl(irc_isc_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
303: nvl(p_rec.attribute6, hr_api.g_varchar2) or
304: nvl(irc_isc_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
305: nvl(p_rec.attribute7, hr_api.g_varchar2) or
306: nvl(irc_isc_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
307: nvl(p_rec.attribute8, hr_api.g_varchar2) or
308: nvl(irc_isc_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
309: nvl(p_rec.attribute9, hr_api.g_varchar2) or
310: nvl(irc_isc_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
311: nvl(p_rec.attribute10, hr_api.g_varchar2) or
304: nvl(irc_isc_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
305: nvl(p_rec.attribute7, hr_api.g_varchar2) or
306: nvl(irc_isc_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
307: nvl(p_rec.attribute8, hr_api.g_varchar2) or
308: nvl(irc_isc_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
309: nvl(p_rec.attribute9, hr_api.g_varchar2) or
310: nvl(irc_isc_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
311: nvl(p_rec.attribute10, hr_api.g_varchar2) or
312: nvl(irc_isc_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
305: nvl(p_rec.attribute7, hr_api.g_varchar2) or
306: nvl(irc_isc_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
307: nvl(p_rec.attribute8, hr_api.g_varchar2) or
308: nvl(irc_isc_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
309: nvl(p_rec.attribute9, hr_api.g_varchar2) or
310: nvl(irc_isc_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
311: nvl(p_rec.attribute10, hr_api.g_varchar2) or
312: nvl(irc_isc_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
313: nvl(p_rec.attribute11, hr_api.g_varchar2) or
306: nvl(irc_isc_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
307: nvl(p_rec.attribute8, hr_api.g_varchar2) or
308: nvl(irc_isc_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
309: nvl(p_rec.attribute9, hr_api.g_varchar2) or
310: nvl(irc_isc_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
311: nvl(p_rec.attribute10, hr_api.g_varchar2) or
312: nvl(irc_isc_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
313: nvl(p_rec.attribute11, hr_api.g_varchar2) or
314: nvl(irc_isc_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
307: nvl(p_rec.attribute8, hr_api.g_varchar2) or
308: nvl(irc_isc_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
309: nvl(p_rec.attribute9, hr_api.g_varchar2) or
310: nvl(irc_isc_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
311: nvl(p_rec.attribute10, hr_api.g_varchar2) or
312: nvl(irc_isc_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
313: nvl(p_rec.attribute11, hr_api.g_varchar2) or
314: nvl(irc_isc_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
315: nvl(p_rec.attribute12, hr_api.g_varchar2) or
308: nvl(irc_isc_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
309: nvl(p_rec.attribute9, hr_api.g_varchar2) or
310: nvl(irc_isc_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
311: nvl(p_rec.attribute10, hr_api.g_varchar2) or
312: nvl(irc_isc_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
313: nvl(p_rec.attribute11, hr_api.g_varchar2) or
314: nvl(irc_isc_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
315: nvl(p_rec.attribute12, hr_api.g_varchar2) or
316: nvl(irc_isc_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
309: nvl(p_rec.attribute9, hr_api.g_varchar2) or
310: nvl(irc_isc_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
311: nvl(p_rec.attribute10, hr_api.g_varchar2) or
312: nvl(irc_isc_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
313: nvl(p_rec.attribute11, hr_api.g_varchar2) or
314: nvl(irc_isc_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
315: nvl(p_rec.attribute12, hr_api.g_varchar2) or
316: nvl(irc_isc_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
317: nvl(p_rec.attribute13, hr_api.g_varchar2) or
310: nvl(irc_isc_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
311: nvl(p_rec.attribute10, hr_api.g_varchar2) or
312: nvl(irc_isc_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
313: nvl(p_rec.attribute11, hr_api.g_varchar2) or
314: nvl(irc_isc_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
315: nvl(p_rec.attribute12, hr_api.g_varchar2) or
316: nvl(irc_isc_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
317: nvl(p_rec.attribute13, hr_api.g_varchar2) or
318: nvl(irc_isc_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
311: nvl(p_rec.attribute10, hr_api.g_varchar2) or
312: nvl(irc_isc_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
313: nvl(p_rec.attribute11, hr_api.g_varchar2) or
314: nvl(irc_isc_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
315: nvl(p_rec.attribute12, hr_api.g_varchar2) or
316: nvl(irc_isc_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
317: nvl(p_rec.attribute13, hr_api.g_varchar2) or
318: nvl(irc_isc_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
319: nvl(p_rec.attribute14, hr_api.g_varchar2) or
312: nvl(irc_isc_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
313: nvl(p_rec.attribute11, hr_api.g_varchar2) or
314: nvl(irc_isc_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
315: nvl(p_rec.attribute12, hr_api.g_varchar2) or
316: nvl(irc_isc_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
317: nvl(p_rec.attribute13, hr_api.g_varchar2) or
318: nvl(irc_isc_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
319: nvl(p_rec.attribute14, hr_api.g_varchar2) or
320: nvl(irc_isc_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
313: nvl(p_rec.attribute11, hr_api.g_varchar2) or
314: nvl(irc_isc_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
315: nvl(p_rec.attribute12, hr_api.g_varchar2) or
316: nvl(irc_isc_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
317: nvl(p_rec.attribute13, hr_api.g_varchar2) or
318: nvl(irc_isc_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
319: nvl(p_rec.attribute14, hr_api.g_varchar2) or
320: nvl(irc_isc_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
321: nvl(p_rec.attribute15, hr_api.g_varchar2) or
314: nvl(irc_isc_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
315: nvl(p_rec.attribute12, hr_api.g_varchar2) or
316: nvl(irc_isc_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
317: nvl(p_rec.attribute13, hr_api.g_varchar2) or
318: nvl(irc_isc_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
319: nvl(p_rec.attribute14, hr_api.g_varchar2) or
320: nvl(irc_isc_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
321: nvl(p_rec.attribute15, hr_api.g_varchar2) or
322: nvl(irc_isc_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
315: nvl(p_rec.attribute12, hr_api.g_varchar2) or
316: nvl(irc_isc_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
317: nvl(p_rec.attribute13, hr_api.g_varchar2) or
318: nvl(irc_isc_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
319: nvl(p_rec.attribute14, hr_api.g_varchar2) or
320: nvl(irc_isc_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
321: nvl(p_rec.attribute15, hr_api.g_varchar2) or
322: nvl(irc_isc_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
323: nvl(p_rec.attribute16, hr_api.g_varchar2) or
316: nvl(irc_isc_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
317: nvl(p_rec.attribute13, hr_api.g_varchar2) or
318: nvl(irc_isc_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
319: nvl(p_rec.attribute14, hr_api.g_varchar2) or
320: nvl(irc_isc_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
321: nvl(p_rec.attribute15, hr_api.g_varchar2) or
322: nvl(irc_isc_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
323: nvl(p_rec.attribute16, hr_api.g_varchar2) or
324: nvl(irc_isc_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
317: nvl(p_rec.attribute13, hr_api.g_varchar2) or
318: nvl(irc_isc_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
319: nvl(p_rec.attribute14, hr_api.g_varchar2) or
320: nvl(irc_isc_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
321: nvl(p_rec.attribute15, hr_api.g_varchar2) or
322: nvl(irc_isc_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
323: nvl(p_rec.attribute16, hr_api.g_varchar2) or
324: nvl(irc_isc_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
325: nvl(p_rec.attribute17, hr_api.g_varchar2) or
318: nvl(irc_isc_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
319: nvl(p_rec.attribute14, hr_api.g_varchar2) or
320: nvl(irc_isc_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
321: nvl(p_rec.attribute15, hr_api.g_varchar2) or
322: nvl(irc_isc_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
323: nvl(p_rec.attribute16, hr_api.g_varchar2) or
324: nvl(irc_isc_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
325: nvl(p_rec.attribute17, hr_api.g_varchar2) or
326: nvl(irc_isc_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
319: nvl(p_rec.attribute14, hr_api.g_varchar2) or
320: nvl(irc_isc_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
321: nvl(p_rec.attribute15, hr_api.g_varchar2) or
322: nvl(irc_isc_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
323: nvl(p_rec.attribute16, hr_api.g_varchar2) or
324: nvl(irc_isc_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
325: nvl(p_rec.attribute17, hr_api.g_varchar2) or
326: nvl(irc_isc_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
327: nvl(p_rec.attribute18, hr_api.g_varchar2) or
320: nvl(irc_isc_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
321: nvl(p_rec.attribute15, hr_api.g_varchar2) or
322: nvl(irc_isc_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
323: nvl(p_rec.attribute16, hr_api.g_varchar2) or
324: nvl(irc_isc_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
325: nvl(p_rec.attribute17, hr_api.g_varchar2) or
326: nvl(irc_isc_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
327: nvl(p_rec.attribute18, hr_api.g_varchar2) or
328: nvl(irc_isc_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
321: nvl(p_rec.attribute15, hr_api.g_varchar2) or
322: nvl(irc_isc_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
323: nvl(p_rec.attribute16, hr_api.g_varchar2) or
324: nvl(irc_isc_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
325: nvl(p_rec.attribute17, hr_api.g_varchar2) or
326: nvl(irc_isc_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
327: nvl(p_rec.attribute18, hr_api.g_varchar2) or
328: nvl(irc_isc_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
329: nvl(p_rec.attribute19, hr_api.g_varchar2) or
322: nvl(irc_isc_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
323: nvl(p_rec.attribute16, hr_api.g_varchar2) or
324: nvl(irc_isc_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
325: nvl(p_rec.attribute17, hr_api.g_varchar2) or
326: nvl(irc_isc_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
327: nvl(p_rec.attribute18, hr_api.g_varchar2) or
328: nvl(irc_isc_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
329: nvl(p_rec.attribute19, hr_api.g_varchar2) or
330: nvl(irc_isc_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
323: nvl(p_rec.attribute16, hr_api.g_varchar2) or
324: nvl(irc_isc_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
325: nvl(p_rec.attribute17, hr_api.g_varchar2) or
326: nvl(irc_isc_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
327: nvl(p_rec.attribute18, hr_api.g_varchar2) or
328: nvl(irc_isc_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
329: nvl(p_rec.attribute19, hr_api.g_varchar2) or
330: nvl(irc_isc_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
331: nvl(p_rec.attribute20, hr_api.g_varchar2) or
324: nvl(irc_isc_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
325: nvl(p_rec.attribute17, hr_api.g_varchar2) or
326: nvl(irc_isc_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
327: nvl(p_rec.attribute18, hr_api.g_varchar2) or
328: nvl(irc_isc_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
329: nvl(p_rec.attribute19, hr_api.g_varchar2) or
330: nvl(irc_isc_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
331: nvl(p_rec.attribute20, hr_api.g_varchar2) or
332: nvl(irc_isc_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
325: nvl(p_rec.attribute17, hr_api.g_varchar2) or
326: nvl(irc_isc_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
327: nvl(p_rec.attribute18, hr_api.g_varchar2) or
328: nvl(irc_isc_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
329: nvl(p_rec.attribute19, hr_api.g_varchar2) or
330: nvl(irc_isc_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
331: nvl(p_rec.attribute20, hr_api.g_varchar2) or
332: nvl(irc_isc_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
333: nvl(p_rec.attribute21, hr_api.g_varchar2) or
326: nvl(irc_isc_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
327: nvl(p_rec.attribute18, hr_api.g_varchar2) or
328: nvl(irc_isc_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
329: nvl(p_rec.attribute19, hr_api.g_varchar2) or
330: nvl(irc_isc_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
331: nvl(p_rec.attribute20, hr_api.g_varchar2) or
332: nvl(irc_isc_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
333: nvl(p_rec.attribute21, hr_api.g_varchar2) or
334: nvl(irc_isc_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
327: nvl(p_rec.attribute18, hr_api.g_varchar2) or
328: nvl(irc_isc_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
329: nvl(p_rec.attribute19, hr_api.g_varchar2) or
330: nvl(irc_isc_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
331: nvl(p_rec.attribute20, hr_api.g_varchar2) or
332: nvl(irc_isc_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
333: nvl(p_rec.attribute21, hr_api.g_varchar2) or
334: nvl(irc_isc_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
335: nvl(p_rec.attribute22, hr_api.g_varchar2) or
328: nvl(irc_isc_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
329: nvl(p_rec.attribute19, hr_api.g_varchar2) or
330: nvl(irc_isc_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
331: nvl(p_rec.attribute20, hr_api.g_varchar2) or
332: nvl(irc_isc_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
333: nvl(p_rec.attribute21, hr_api.g_varchar2) or
334: nvl(irc_isc_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
335: nvl(p_rec.attribute22, hr_api.g_varchar2) or
336: nvl(irc_isc_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
329: nvl(p_rec.attribute19, hr_api.g_varchar2) or
330: nvl(irc_isc_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
331: nvl(p_rec.attribute20, hr_api.g_varchar2) or
332: nvl(irc_isc_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
333: nvl(p_rec.attribute21, hr_api.g_varchar2) or
334: nvl(irc_isc_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
335: nvl(p_rec.attribute22, hr_api.g_varchar2) or
336: nvl(irc_isc_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
337: nvl(p_rec.attribute23, hr_api.g_varchar2) or
330: nvl(irc_isc_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
331: nvl(p_rec.attribute20, hr_api.g_varchar2) or
332: nvl(irc_isc_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
333: nvl(p_rec.attribute21, hr_api.g_varchar2) or
334: nvl(irc_isc_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
335: nvl(p_rec.attribute22, hr_api.g_varchar2) or
336: nvl(irc_isc_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
337: nvl(p_rec.attribute23, hr_api.g_varchar2) or
338: nvl(irc_isc_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
331: nvl(p_rec.attribute20, hr_api.g_varchar2) or
332: nvl(irc_isc_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
333: nvl(p_rec.attribute21, hr_api.g_varchar2) or
334: nvl(irc_isc_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
335: nvl(p_rec.attribute22, hr_api.g_varchar2) or
336: nvl(irc_isc_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
337: nvl(p_rec.attribute23, hr_api.g_varchar2) or
338: nvl(irc_isc_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
339: nvl(p_rec.attribute24, hr_api.g_varchar2) or
332: nvl(irc_isc_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
333: nvl(p_rec.attribute21, hr_api.g_varchar2) or
334: nvl(irc_isc_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
335: nvl(p_rec.attribute22, hr_api.g_varchar2) or
336: nvl(irc_isc_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
337: nvl(p_rec.attribute23, hr_api.g_varchar2) or
338: nvl(irc_isc_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
339: nvl(p_rec.attribute24, hr_api.g_varchar2) or
340: nvl(irc_isc_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
333: nvl(p_rec.attribute21, hr_api.g_varchar2) or
334: nvl(irc_isc_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
335: nvl(p_rec.attribute22, hr_api.g_varchar2) or
336: nvl(irc_isc_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
337: nvl(p_rec.attribute23, hr_api.g_varchar2) or
338: nvl(irc_isc_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
339: nvl(p_rec.attribute24, hr_api.g_varchar2) or
340: nvl(irc_isc_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
341: nvl(p_rec.attribute25, hr_api.g_varchar2) or
334: nvl(irc_isc_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
335: nvl(p_rec.attribute22, hr_api.g_varchar2) or
336: nvl(irc_isc_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
337: nvl(p_rec.attribute23, hr_api.g_varchar2) or
338: nvl(irc_isc_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
339: nvl(p_rec.attribute24, hr_api.g_varchar2) or
340: nvl(irc_isc_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
341: nvl(p_rec.attribute25, hr_api.g_varchar2) or
342: nvl(irc_isc_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
335: nvl(p_rec.attribute22, hr_api.g_varchar2) or
336: nvl(irc_isc_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
337: nvl(p_rec.attribute23, hr_api.g_varchar2) or
338: nvl(irc_isc_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
339: nvl(p_rec.attribute24, hr_api.g_varchar2) or
340: nvl(irc_isc_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
341: nvl(p_rec.attribute25, hr_api.g_varchar2) or
342: nvl(irc_isc_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
343: nvl(p_rec.attribute26, hr_api.g_varchar2) or
336: nvl(irc_isc_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
337: nvl(p_rec.attribute23, hr_api.g_varchar2) or
338: nvl(irc_isc_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
339: nvl(p_rec.attribute24, hr_api.g_varchar2) or
340: nvl(irc_isc_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
341: nvl(p_rec.attribute25, hr_api.g_varchar2) or
342: nvl(irc_isc_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
343: nvl(p_rec.attribute26, hr_api.g_varchar2) or
344: nvl(irc_isc_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
337: nvl(p_rec.attribute23, hr_api.g_varchar2) or
338: nvl(irc_isc_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
339: nvl(p_rec.attribute24, hr_api.g_varchar2) or
340: nvl(irc_isc_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
341: nvl(p_rec.attribute25, hr_api.g_varchar2) or
342: nvl(irc_isc_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
343: nvl(p_rec.attribute26, hr_api.g_varchar2) or
344: nvl(irc_isc_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
345: nvl(p_rec.attribute27, hr_api.g_varchar2) or
338: nvl(irc_isc_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
339: nvl(p_rec.attribute24, hr_api.g_varchar2) or
340: nvl(irc_isc_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
341: nvl(p_rec.attribute25, hr_api.g_varchar2) or
342: nvl(irc_isc_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
343: nvl(p_rec.attribute26, hr_api.g_varchar2) or
344: nvl(irc_isc_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
345: nvl(p_rec.attribute27, hr_api.g_varchar2) or
346: nvl(irc_isc_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
339: nvl(p_rec.attribute24, hr_api.g_varchar2) or
340: nvl(irc_isc_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
341: nvl(p_rec.attribute25, hr_api.g_varchar2) or
342: nvl(irc_isc_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
343: nvl(p_rec.attribute26, hr_api.g_varchar2) or
344: nvl(irc_isc_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
345: nvl(p_rec.attribute27, hr_api.g_varchar2) or
346: nvl(irc_isc_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
347: nvl(p_rec.attribute28, hr_api.g_varchar2) or
340: nvl(irc_isc_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
341: nvl(p_rec.attribute25, hr_api.g_varchar2) or
342: nvl(irc_isc_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
343: nvl(p_rec.attribute26, hr_api.g_varchar2) or
344: nvl(irc_isc_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
345: nvl(p_rec.attribute27, hr_api.g_varchar2) or
346: nvl(irc_isc_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
347: nvl(p_rec.attribute28, hr_api.g_varchar2) or
348: nvl(irc_isc_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
341: nvl(p_rec.attribute25, hr_api.g_varchar2) or
342: nvl(irc_isc_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
343: nvl(p_rec.attribute26, hr_api.g_varchar2) or
344: nvl(irc_isc_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
345: nvl(p_rec.attribute27, hr_api.g_varchar2) or
346: nvl(irc_isc_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
347: nvl(p_rec.attribute28, hr_api.g_varchar2) or
348: nvl(irc_isc_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
349: nvl(p_rec.attribute29, hr_api.g_varchar2) or
342: nvl(irc_isc_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
343: nvl(p_rec.attribute26, hr_api.g_varchar2) or
344: nvl(irc_isc_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
345: nvl(p_rec.attribute27, hr_api.g_varchar2) or
346: nvl(irc_isc_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
347: nvl(p_rec.attribute28, hr_api.g_varchar2) or
348: nvl(irc_isc_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
349: nvl(p_rec.attribute29, hr_api.g_varchar2) or
350: nvl(irc_isc_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
343: nvl(p_rec.attribute26, hr_api.g_varchar2) or
344: nvl(irc_isc_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
345: nvl(p_rec.attribute27, hr_api.g_varchar2) or
346: nvl(irc_isc_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
347: nvl(p_rec.attribute28, hr_api.g_varchar2) or
348: nvl(irc_isc_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
349: nvl(p_rec.attribute29, hr_api.g_varchar2) or
350: nvl(irc_isc_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
351: nvl(p_rec.attribute30, hr_api.g_varchar2) ))
344: nvl(irc_isc_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
345: nvl(p_rec.attribute27, hr_api.g_varchar2) or
346: nvl(irc_isc_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
347: nvl(p_rec.attribute28, hr_api.g_varchar2) or
348: nvl(irc_isc_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
349: nvl(p_rec.attribute29, hr_api.g_varchar2) or
350: nvl(irc_isc_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
351: nvl(p_rec.attribute30, hr_api.g_varchar2) ))
352: or (p_rec.search_criteria_id is null) then
345: nvl(p_rec.attribute27, hr_api.g_varchar2) or
346: nvl(irc_isc_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
347: nvl(p_rec.attribute28, hr_api.g_varchar2) or
348: nvl(irc_isc_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
349: nvl(p_rec.attribute29, hr_api.g_varchar2) or
350: nvl(irc_isc_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
351: nvl(p_rec.attribute30, hr_api.g_varchar2) ))
352: or (p_rec.search_criteria_id is null) then
353: --
346: nvl(irc_isc_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
347: nvl(p_rec.attribute28, hr_api.g_varchar2) or
348: nvl(irc_isc_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
349: nvl(p_rec.attribute29, hr_api.g_varchar2) or
350: nvl(irc_isc_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
351: nvl(p_rec.attribute30, hr_api.g_varchar2) ))
352: or (p_rec.search_criteria_id is null) then
353: --
354: -- Only execute the validation if absolutely necessary:
347: nvl(p_rec.attribute28, hr_api.g_varchar2) or
348: nvl(irc_isc_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
349: nvl(p_rec.attribute29, hr_api.g_varchar2) or
350: nvl(irc_isc_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
351: nvl(p_rec.attribute30, hr_api.g_varchar2) ))
352: or (p_rec.search_criteria_id is null) then
353: --
354: -- Only execute the validation if absolutely necessary:
355: -- a) During update, the structure column value or any
479: -- not been updated.
480: --
481: if p_rec.search_criteria_id <>
482: irc_isc_shd.g_old_rec.search_criteria_id then
483: hr_api.argument_changed_error
484: (p_api_name => l_proc
485: ,p_argument => 'SEARCH_CRITERIA_ID'
486: ,p_base_table => irc_isc_shd.g_tab_nam
487: );
489: --
490: --
491: if p_rec.object_id <> irc_isc_shd.g_old_rec.object_id then
492: if p_rec.object_type = 'PERSON' then
493: hr_api.argument_changed_error
494: ( p_api_name => l_proc
495: ,p_argument => 'PERSON_ID'
496: ,p_base_table => irc_isc_shd.g_tab_nam
497: );
495: ,p_argument => 'PERSON_ID'
496: ,p_base_table => irc_isc_shd.g_tab_nam
497: );
498: elsif p_rec.object_type = 'VACANCY' then
499: hr_api.argument_changed_error
500: ( p_api_name => l_proc
501: ,p_argument => 'VACANCY_ID'
502: ,p_base_table => irc_isc_shd.g_tab_nam
503: );
544: --
545: begin
546: hr_utility.set_location('Entering:'||l_proc,10);
547: -- Check that Person_ID is not null.
548: hr_api.mandatory_arg_error
549: (p_api_name => l_proc
550: ,p_argument => 'PERSON_ID'
551: ,p_argument_value => p_person_id
552: );
687: );
688: hr_utility.set_location(l_proc,30);
689: if (l_api_updating and
690: p_search_name <>
691: NVL(irc_isc_shd.g_old_rec.search_name,hr_api.g_varchar2)
692: ) or (NOT l_api_updating) then
693: -- Check that search_name is unique for a person_id
694: hr_utility.set_location(l_proc,40);
695: open csr_search_name;
767: --
768: hr_utility.set_location(l_proc,30);
769: if (l_api_updating and
770: p_distance_to_location <>
771: NVL(irc_isc_shd.g_old_rec.distance_to_location,hr_api.g_number))
772: or (NOT l_api_updating) then
773: -- Check that distance_to_location is a valid positive number.
774: hr_utility.set_location(l_proc,40);
775: if p_distance_to_location < 0 then
853: --
854: hr_utility.set_location(l_proc,30);
855: if (l_api_updating and
856: p_location_id <>
857: NVL(irc_isc_shd.g_old_rec.location_id,hr_api.g_number))
858: or (NOT l_api_updating) then
859: -- Check that location_id is a valid
860: hr_utility.set_location(l_proc,40);
861: open chk_loc;
972: --
973: hr_utility.set_location(l_proc,30);
974: if (l_api_updating and
975: p_use_for_matching <>
976: NVL(irc_isc_shd.g_old_rec.use_for_matching,hr_api.g_varchar2)
977: ) or (NOT l_api_updating) then
978: -- Check that use_for_matching is having a valid value of 'Y' or 'N'
979: hr_utility.set_location(l_proc,40);
980: if not p_use_for_matching in ('Y','N') then
1042: --
1043: hr_utility.set_location(l_proc,30);
1044: if (l_api_updating and
1045: p_match_competence <>
1046: NVL(irc_isc_shd.g_old_rec.match_competence,hr_api.g_varchar2)
1047: ) or (NOT l_api_updating) then
1048: -- Check that match_competence is having a valid value of 'Y' or 'N'
1049: hr_utility.set_location(l_proc,40);
1050: if not p_match_competence in ('Y','N') then
1113: --
1114: hr_utility.set_location(l_proc,30);
1115: if (l_api_updating and
1116: p_match_qualification <>
1117: NVL(irc_isc_shd.g_old_rec.match_qualification,hr_api.g_varchar2)
1118: ) or (NOT l_api_updating) then
1119: -- Check that match_qualification is having a valid value of 'Y' or 'N'
1120: hr_utility.set_location(l_proc,40);
1121: if not p_match_qualification in ('Y','N') then
1175: --
1176: begin
1177: hr_utility.set_location('Entering:'||l_proc,10);
1178: -- Check that Vacancy_id is not null.
1179: hr_api.mandatory_arg_error
1180: (p_api_name => l_proc
1181: ,p_argument => 'VACANCY_ID'
1182: ,p_argument_value => p_vacancy_id
1183: );
1257: --
1258: hr_utility.set_location(l_proc,30);
1259: if (l_api_updating and
1260: p_min_qual_level <>
1261: NVL(irc_isc_shd.g_old_rec.min_qual_level,hr_api.g_number)
1262: ) or (NOT l_api_updating) then
1263: hr_utility.set_location(l_proc,40);
1264: open csr_min_qual_level;
1265: fetch csr_min_qual_level into l_min_qual_level ;
1412: --
1413: hr_utility.set_location(l_proc,30);
1414: if (l_api_updating and
1415: p_min_salary <>
1416: NVL(irc_isc_shd.g_old_rec.min_salary,hr_api.g_number)
1417: ) or (NOT l_api_updating) then
1418: -- Check that min_salary is a valid positive number.
1419: hr_utility.set_location(l_proc,40);
1420: if p_min_salary < 0 then
1495: --
1496: hr_utility.set_location(l_proc,30);
1497: if (l_api_updating and
1498: p_max_salary <>
1499: NVL(irc_isc_shd.g_old_rec.max_salary,hr_api.g_number)
1500: ) or (NOT l_api_updating) then
1501: -- Check that max_salary is greater then min salary.
1502: hr_utility.set_location(l_proc,40);
1503: if p_max_salary < 0 or p_max_salary < NVL(p_min_salary,hr_api.g_number)
1499: NVL(irc_isc_shd.g_old_rec.max_salary,hr_api.g_number)
1500: ) or (NOT l_api_updating) then
1501: -- Check that max_salary is greater then min salary.
1502: hr_utility.set_location(l_proc,40);
1503: if p_max_salary < 0 or p_max_salary < NVL(p_min_salary,hr_api.g_number)
1504: then
1505: fnd_message.set_name('PER','IRC_412019_MAX_BELOW_MIN_SAL');
1506: fnd_message.raise_error;
1507: end if;
1699: if p_professional_area is not null then
1700: hr_utility.set_location(l_proc,30);
1701: if (l_api_updating and
1702: p_professional_area <>
1703: NVL(irc_isc_shd.g_old_rec.professional_area,hr_api.g_varchar2)
1704: ) or (NOT l_api_updating) then
1705: -- Check that professional_area exists in hr_lookups
1706: hr_utility.set_location(l_proc,40);
1707: l_ret := hr_api.not_exists_in_hr_lookups(
1703: NVL(irc_isc_shd.g_old_rec.professional_area,hr_api.g_varchar2)
1704: ) or (NOT l_api_updating) then
1705: -- Check that professional_area exists in hr_lookups
1706: hr_utility.set_location(l_proc,40);
1707: l_ret := hr_api.not_exists_in_hr_lookups(
1708: p_effective_date => p_effective_date
1709: ,p_lookup_type => 'IRC_PROFESSIONAL_AREA'
1710: ,p_lookup_code => p_professional_area);
1711: if l_ret = true then
1776: --
1777: hr_utility.set_location(l_proc,30);
1778: if (l_api_updating and
1779: p_employment_category <>
1780: NVL(irc_isc_shd.g_old_rec.employment_category,hr_api.g_varchar2)
1781: ) or (NOT l_api_updating) then
1782: -- Check that employment_category exists in hr_lookups
1783: hr_utility.set_location(l_proc,40);
1784: l_ret := hr_api.not_exists_in_hr_lookups(
1780: NVL(irc_isc_shd.g_old_rec.employment_category,hr_api.g_varchar2)
1781: ) or (NOT l_api_updating) then
1782: -- Check that employment_category exists in hr_lookups
1783: hr_utility.set_location(l_proc,40);
1784: l_ret := hr_api.not_exists_in_hr_lookups(
1785: p_effective_date => p_effective_date
1786: ,p_lookup_type => 'IRC_EMP_CAT'
1787: ,p_lookup_code => p_employment_category);
1788: if l_ret = true then
1853: --
1854: hr_utility.set_location(l_proc,30);
1855: if (l_api_updating and
1856: p_work_at_home <>
1857: NVL(irc_isc_shd.g_old_rec.work_at_home,hr_api.g_varchar2)
1858: ) or (NOT l_api_updating) then
1859: -- Check that work_at_home exists in hr_lookups
1860: hr_utility.set_location(l_proc,40);
1861: l_ret := hr_api.not_exists_in_hr_lookups(
1857: NVL(irc_isc_shd.g_old_rec.work_at_home,hr_api.g_varchar2)
1858: ) or (NOT l_api_updating) then
1859: -- Check that work_at_home exists in hr_lookups
1860: hr_utility.set_location(l_proc,40);
1861: l_ret := hr_api.not_exists_in_hr_lookups(
1862: p_effective_date => p_effective_date
1863: ,p_lookup_type => 'IRC_WORK_AT_HOME'
1864: ,p_lookup_code => p_work_at_home);
1865: if l_ret = true then
1930: --
1931: hr_utility.set_location(l_proc,30);
1932: if (l_api_updating and
1933: p_travel_percentage <>
1934: NVL(irc_isc_shd.g_old_rec.travel_percentage,hr_api.g_number))
1935: or (NOT l_api_updating) then
1936: -- Check that travel_percentage exists in hr_lookups
1937: hr_utility.set_location(l_proc,40);
1938: l_ret := hr_api.not_exists_in_hr_lookups(
1934: NVL(irc_isc_shd.g_old_rec.travel_percentage,hr_api.g_number))
1935: or (NOT l_api_updating) then
1936: -- Check that travel_percentage exists in hr_lookups
1937: hr_utility.set_location(l_proc,40);
1938: l_ret := hr_api.not_exists_in_hr_lookups(
1939: p_effective_date => p_effective_date
1940: ,p_lookup_type => 'IRC_TRAVEL_PERCENTAGE'
1941: ,p_lookup_code => to_char(p_travel_percentage));
1942: if l_ret = true then
2005: (p_search_criteria_id => p_search_criteria_id
2006: ,p_object_version_number => p_object_version_number
2007: );
2008: hr_utility.set_location(l_proc,20);
2009: if (p_max_salary = hr_api.g_number) then
2010: l_max_salary :=irc_isc_shd.g_old_rec.max_salary;
2011: else
2012: l_max_salary := p_max_salary;
2013: end if;
2011: else
2012: l_max_salary := p_max_salary;
2013: end if;
2014: --
2015: if (p_min_salary = hr_api.g_number) then
2016: l_min_salary :=irc_isc_shd.g_old_rec.min_salary;
2017: else
2018: l_min_salary := p_min_salary;
2019: end if;
2020: --
2021: hr_utility.set_location(l_proc,30);
2022: if (l_api_updating and
2023: p_salary_period <>
2024: NVL(irc_isc_shd.g_old_rec.salary_period,hr_api.g_varchar2)
2025: ) or (NOT l_api_updating) then
2026: -- Check that p_salary_period is not null if there is a salary
2027: if ((l_max_salary is not null or l_min_salary is not null)
2028: and p_salary_period is null) then
2031: end if;
2032: if p_salary_period is not null then
2033: -- Check that p_salary_period exists in hr_lookups
2034: hr_utility.set_location(l_proc,40);
2035: if hr_api.not_exists_in_hr_lookups(
2036: p_effective_date => p_effective_date
2037: ,p_lookup_type => 'PAY_BASIS'
2038: ,p_lookup_code => p_salary_period)
2039: then
2120: );
2121: --
2122: hr_utility.set_location(l_proc,20);
2123: if (l_api_updating and
2124: (NVL(p_salary_currency,hr_api.g_varchar2) <>
2125: NVL(irc_isc_shd.g_old_rec.salary_currency,hr_api.g_varchar2))
2126: or
2127: (NVL(p_max_salary,hr_api.g_number) <>
2128: NVL(irc_isc_shd.g_old_rec.max_salary,hr_api.g_number))
2121: --
2122: hr_utility.set_location(l_proc,20);
2123: if (l_api_updating and
2124: (NVL(p_salary_currency,hr_api.g_varchar2) <>
2125: NVL(irc_isc_shd.g_old_rec.salary_currency,hr_api.g_varchar2))
2126: or
2127: (NVL(p_max_salary,hr_api.g_number) <>
2128: NVL(irc_isc_shd.g_old_rec.max_salary,hr_api.g_number))
2129: or
2123: if (l_api_updating and
2124: (NVL(p_salary_currency,hr_api.g_varchar2) <>
2125: NVL(irc_isc_shd.g_old_rec.salary_currency,hr_api.g_varchar2))
2126: or
2127: (NVL(p_max_salary,hr_api.g_number) <>
2128: NVL(irc_isc_shd.g_old_rec.max_salary,hr_api.g_number))
2129: or
2130: (NVL(p_min_salary,hr_api.g_number) <>
2131: NVL(irc_isc_shd.g_old_rec.min_salary,hr_api.g_number))
2124: (NVL(p_salary_currency,hr_api.g_varchar2) <>
2125: NVL(irc_isc_shd.g_old_rec.salary_currency,hr_api.g_varchar2))
2126: or
2127: (NVL(p_max_salary,hr_api.g_number) <>
2128: NVL(irc_isc_shd.g_old_rec.max_salary,hr_api.g_number))
2129: or
2130: (NVL(p_min_salary,hr_api.g_number) <>
2131: NVL(irc_isc_shd.g_old_rec.min_salary,hr_api.g_number))
2132: )
2126: or
2127: (NVL(p_max_salary,hr_api.g_number) <>
2128: NVL(irc_isc_shd.g_old_rec.max_salary,hr_api.g_number))
2129: or
2130: (NVL(p_min_salary,hr_api.g_number) <>
2131: NVL(irc_isc_shd.g_old_rec.min_salary,hr_api.g_number))
2132: )
2133: or (NOT l_api_updating) then
2134: --
2127: (NVL(p_max_salary,hr_api.g_number) <>
2128: NVL(irc_isc_shd.g_old_rec.max_salary,hr_api.g_number))
2129: or
2130: (NVL(p_min_salary,hr_api.g_number) <>
2131: NVL(irc_isc_shd.g_old_rec.min_salary,hr_api.g_number))
2132: )
2133: or (NOT l_api_updating) then
2134: --
2135: -- Check that salary currency is not null if either min_sal or max_sal is
2227: --
2228: hr_utility.set_location(l_proc,30);
2229: if (l_api_updating and
2230: p_date_posted <>
2231: NVL(irc_isc_shd.g_old_rec.date_posted,hr_api.g_varchar2)
2232: ) or (NOT l_api_updating) then
2233: -- Check that date_posted exists in hr_lookups
2234: hr_utility.set_location(l_proc,40);
2235: l_ret := hr_api.not_exists_in_hr_lookups(
2231: NVL(irc_isc_shd.g_old_rec.date_posted,hr_api.g_varchar2)
2232: ) or (NOT l_api_updating) then
2233: -- Check that date_posted exists in hr_lookups
2234: hr_utility.set_location(l_proc,40);
2235: l_ret := hr_api.not_exists_in_hr_lookups(
2236: p_effective_date => p_effective_date
2237: ,p_lookup_type => 'IRC_VACANCY_SEARCH_DATE'
2238: ,p_lookup_code => p_date_posted);
2239: if l_ret = true then
2358: --
2359: hr_utility.set_location(l_proc,30);
2360: if ((l_api_updating and
2361: p_keywords <>
2362: NVL(irc_isc_shd.g_old_rec.keywords,hr_api.g_varchar2)
2363: ) or (NOT l_api_updating)) then
2364: hr_utility.set_location(l_proc,40);
2365: --
2366: -- Check the validity of the keywords by using the
2415: hr_utility.set_location(l_proc, 20);
2416: if p_rec.object_type in ('PERSON','WPREF') then
2417: --
2418: hr_utility.set_location(l_proc, 30);
2419: hr_api.mandatory_arg_error
2420: (p_api_name => l_proc
2421: ,p_argument => 'EFFECTIVE_DATE'
2422: ,p_argument_value => p_effective_date
2423: );