63: hr_utility.set_location('Entering:'|| l_proc, 10);
64: --
65: -- Ensure that all the mandatory parameter are not null
66: --
67: hr_api.mandatory_arg_error
68: (p_api_name => l_proc
69: ,p_argument => 'form_property_id'
70: ,p_argument_value => p_form_property_id
71: );
69: ,p_argument => 'form_property_id'
70: ,p_argument_value => p_form_property_id
71: );
72: --
73: if ( nvl(hr_fmp_bus.g_form_property_id, hr_api.g_number)
74: = p_form_property_id) then
75: --
76: -- The legislation code has already been found with a previous
77: -- call to this function. Just return the value in the global
144: begin
145: hr_utility.set_location('Entering:'||l_proc,10);
146: --
147: if ((p_rec.form_property_id is not null) and (
148: nvl(hr_fmp_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
149: nvl(p_rec.information_category, hr_api.g_varchar2) or
150: nvl(hr_fmp_shd.g_old_rec.information1, hr_api.g_varchar2) <>
151: nvl(p_rec.information1, hr_api.g_varchar2) or
152: nvl(hr_fmp_shd.g_old_rec.information2, hr_api.g_varchar2) <>
145: hr_utility.set_location('Entering:'||l_proc,10);
146: --
147: if ((p_rec.form_property_id is not null) and (
148: nvl(hr_fmp_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
149: nvl(p_rec.information_category, hr_api.g_varchar2) or
150: nvl(hr_fmp_shd.g_old_rec.information1, hr_api.g_varchar2) <>
151: nvl(p_rec.information1, hr_api.g_varchar2) or
152: nvl(hr_fmp_shd.g_old_rec.information2, hr_api.g_varchar2) <>
153: nvl(p_rec.information2, hr_api.g_varchar2) or
146: --
147: if ((p_rec.form_property_id is not null) and (
148: nvl(hr_fmp_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
149: nvl(p_rec.information_category, hr_api.g_varchar2) or
150: nvl(hr_fmp_shd.g_old_rec.information1, hr_api.g_varchar2) <>
151: nvl(p_rec.information1, hr_api.g_varchar2) or
152: nvl(hr_fmp_shd.g_old_rec.information2, hr_api.g_varchar2) <>
153: nvl(p_rec.information2, hr_api.g_varchar2) or
154: nvl(hr_fmp_shd.g_old_rec.information3, hr_api.g_varchar2) <>
147: if ((p_rec.form_property_id is not null) and (
148: nvl(hr_fmp_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
149: nvl(p_rec.information_category, hr_api.g_varchar2) or
150: nvl(hr_fmp_shd.g_old_rec.information1, hr_api.g_varchar2) <>
151: nvl(p_rec.information1, hr_api.g_varchar2) or
152: nvl(hr_fmp_shd.g_old_rec.information2, hr_api.g_varchar2) <>
153: nvl(p_rec.information2, hr_api.g_varchar2) or
154: nvl(hr_fmp_shd.g_old_rec.information3, hr_api.g_varchar2) <>
155: nvl(p_rec.information3, hr_api.g_varchar2) or
148: nvl(hr_fmp_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
149: nvl(p_rec.information_category, hr_api.g_varchar2) or
150: nvl(hr_fmp_shd.g_old_rec.information1, hr_api.g_varchar2) <>
151: nvl(p_rec.information1, hr_api.g_varchar2) or
152: nvl(hr_fmp_shd.g_old_rec.information2, hr_api.g_varchar2) <>
153: nvl(p_rec.information2, hr_api.g_varchar2) or
154: nvl(hr_fmp_shd.g_old_rec.information3, hr_api.g_varchar2) <>
155: nvl(p_rec.information3, hr_api.g_varchar2) or
156: nvl(hr_fmp_shd.g_old_rec.information4, hr_api.g_varchar2) <>
149: nvl(p_rec.information_category, hr_api.g_varchar2) or
150: nvl(hr_fmp_shd.g_old_rec.information1, hr_api.g_varchar2) <>
151: nvl(p_rec.information1, hr_api.g_varchar2) or
152: nvl(hr_fmp_shd.g_old_rec.information2, hr_api.g_varchar2) <>
153: nvl(p_rec.information2, hr_api.g_varchar2) or
154: nvl(hr_fmp_shd.g_old_rec.information3, hr_api.g_varchar2) <>
155: nvl(p_rec.information3, hr_api.g_varchar2) or
156: nvl(hr_fmp_shd.g_old_rec.information4, hr_api.g_varchar2) <>
157: nvl(p_rec.information4, hr_api.g_varchar2) or
150: nvl(hr_fmp_shd.g_old_rec.information1, hr_api.g_varchar2) <>
151: nvl(p_rec.information1, hr_api.g_varchar2) or
152: nvl(hr_fmp_shd.g_old_rec.information2, hr_api.g_varchar2) <>
153: nvl(p_rec.information2, hr_api.g_varchar2) or
154: nvl(hr_fmp_shd.g_old_rec.information3, hr_api.g_varchar2) <>
155: nvl(p_rec.information3, hr_api.g_varchar2) or
156: nvl(hr_fmp_shd.g_old_rec.information4, hr_api.g_varchar2) <>
157: nvl(p_rec.information4, hr_api.g_varchar2) or
158: nvl(hr_fmp_shd.g_old_rec.information5, hr_api.g_varchar2) <>
151: nvl(p_rec.information1, hr_api.g_varchar2) or
152: nvl(hr_fmp_shd.g_old_rec.information2, hr_api.g_varchar2) <>
153: nvl(p_rec.information2, hr_api.g_varchar2) or
154: nvl(hr_fmp_shd.g_old_rec.information3, hr_api.g_varchar2) <>
155: nvl(p_rec.information3, hr_api.g_varchar2) or
156: nvl(hr_fmp_shd.g_old_rec.information4, hr_api.g_varchar2) <>
157: nvl(p_rec.information4, hr_api.g_varchar2) or
158: nvl(hr_fmp_shd.g_old_rec.information5, hr_api.g_varchar2) <>
159: nvl(p_rec.information5, hr_api.g_varchar2) or
152: nvl(hr_fmp_shd.g_old_rec.information2, hr_api.g_varchar2) <>
153: nvl(p_rec.information2, hr_api.g_varchar2) or
154: nvl(hr_fmp_shd.g_old_rec.information3, hr_api.g_varchar2) <>
155: nvl(p_rec.information3, hr_api.g_varchar2) or
156: nvl(hr_fmp_shd.g_old_rec.information4, hr_api.g_varchar2) <>
157: nvl(p_rec.information4, hr_api.g_varchar2) or
158: nvl(hr_fmp_shd.g_old_rec.information5, hr_api.g_varchar2) <>
159: nvl(p_rec.information5, hr_api.g_varchar2) or
160: nvl(hr_fmp_shd.g_old_rec.information6, hr_api.g_varchar2) <>
153: nvl(p_rec.information2, hr_api.g_varchar2) or
154: nvl(hr_fmp_shd.g_old_rec.information3, hr_api.g_varchar2) <>
155: nvl(p_rec.information3, hr_api.g_varchar2) or
156: nvl(hr_fmp_shd.g_old_rec.information4, hr_api.g_varchar2) <>
157: nvl(p_rec.information4, hr_api.g_varchar2) or
158: nvl(hr_fmp_shd.g_old_rec.information5, hr_api.g_varchar2) <>
159: nvl(p_rec.information5, hr_api.g_varchar2) or
160: nvl(hr_fmp_shd.g_old_rec.information6, hr_api.g_varchar2) <>
161: nvl(p_rec.information6, hr_api.g_varchar2) or
154: nvl(hr_fmp_shd.g_old_rec.information3, hr_api.g_varchar2) <>
155: nvl(p_rec.information3, hr_api.g_varchar2) or
156: nvl(hr_fmp_shd.g_old_rec.information4, hr_api.g_varchar2) <>
157: nvl(p_rec.information4, hr_api.g_varchar2) or
158: nvl(hr_fmp_shd.g_old_rec.information5, hr_api.g_varchar2) <>
159: nvl(p_rec.information5, hr_api.g_varchar2) or
160: nvl(hr_fmp_shd.g_old_rec.information6, hr_api.g_varchar2) <>
161: nvl(p_rec.information6, hr_api.g_varchar2) or
162: nvl(hr_fmp_shd.g_old_rec.information7, hr_api.g_varchar2) <>
155: nvl(p_rec.information3, hr_api.g_varchar2) or
156: nvl(hr_fmp_shd.g_old_rec.information4, hr_api.g_varchar2) <>
157: nvl(p_rec.information4, hr_api.g_varchar2) or
158: nvl(hr_fmp_shd.g_old_rec.information5, hr_api.g_varchar2) <>
159: nvl(p_rec.information5, hr_api.g_varchar2) or
160: nvl(hr_fmp_shd.g_old_rec.information6, hr_api.g_varchar2) <>
161: nvl(p_rec.information6, hr_api.g_varchar2) or
162: nvl(hr_fmp_shd.g_old_rec.information7, hr_api.g_varchar2) <>
163: nvl(p_rec.information7, hr_api.g_varchar2) or
156: nvl(hr_fmp_shd.g_old_rec.information4, hr_api.g_varchar2) <>
157: nvl(p_rec.information4, hr_api.g_varchar2) or
158: nvl(hr_fmp_shd.g_old_rec.information5, hr_api.g_varchar2) <>
159: nvl(p_rec.information5, hr_api.g_varchar2) or
160: nvl(hr_fmp_shd.g_old_rec.information6, hr_api.g_varchar2) <>
161: nvl(p_rec.information6, hr_api.g_varchar2) or
162: nvl(hr_fmp_shd.g_old_rec.information7, hr_api.g_varchar2) <>
163: nvl(p_rec.information7, hr_api.g_varchar2) or
164: nvl(hr_fmp_shd.g_old_rec.information8, hr_api.g_varchar2) <>
157: nvl(p_rec.information4, hr_api.g_varchar2) or
158: nvl(hr_fmp_shd.g_old_rec.information5, hr_api.g_varchar2) <>
159: nvl(p_rec.information5, hr_api.g_varchar2) or
160: nvl(hr_fmp_shd.g_old_rec.information6, hr_api.g_varchar2) <>
161: nvl(p_rec.information6, hr_api.g_varchar2) or
162: nvl(hr_fmp_shd.g_old_rec.information7, hr_api.g_varchar2) <>
163: nvl(p_rec.information7, hr_api.g_varchar2) or
164: nvl(hr_fmp_shd.g_old_rec.information8, hr_api.g_varchar2) <>
165: nvl(p_rec.information8, hr_api.g_varchar2) or
158: nvl(hr_fmp_shd.g_old_rec.information5, hr_api.g_varchar2) <>
159: nvl(p_rec.information5, hr_api.g_varchar2) or
160: nvl(hr_fmp_shd.g_old_rec.information6, hr_api.g_varchar2) <>
161: nvl(p_rec.information6, hr_api.g_varchar2) or
162: nvl(hr_fmp_shd.g_old_rec.information7, hr_api.g_varchar2) <>
163: nvl(p_rec.information7, hr_api.g_varchar2) or
164: nvl(hr_fmp_shd.g_old_rec.information8, hr_api.g_varchar2) <>
165: nvl(p_rec.information8, hr_api.g_varchar2) or
166: nvl(hr_fmp_shd.g_old_rec.information9, hr_api.g_varchar2) <>
159: nvl(p_rec.information5, hr_api.g_varchar2) or
160: nvl(hr_fmp_shd.g_old_rec.information6, hr_api.g_varchar2) <>
161: nvl(p_rec.information6, hr_api.g_varchar2) or
162: nvl(hr_fmp_shd.g_old_rec.information7, hr_api.g_varchar2) <>
163: nvl(p_rec.information7, hr_api.g_varchar2) or
164: nvl(hr_fmp_shd.g_old_rec.information8, hr_api.g_varchar2) <>
165: nvl(p_rec.information8, hr_api.g_varchar2) or
166: nvl(hr_fmp_shd.g_old_rec.information9, hr_api.g_varchar2) <>
167: nvl(p_rec.information9, hr_api.g_varchar2) or
160: nvl(hr_fmp_shd.g_old_rec.information6, hr_api.g_varchar2) <>
161: nvl(p_rec.information6, hr_api.g_varchar2) or
162: nvl(hr_fmp_shd.g_old_rec.information7, hr_api.g_varchar2) <>
163: nvl(p_rec.information7, hr_api.g_varchar2) or
164: nvl(hr_fmp_shd.g_old_rec.information8, hr_api.g_varchar2) <>
165: nvl(p_rec.information8, hr_api.g_varchar2) or
166: nvl(hr_fmp_shd.g_old_rec.information9, hr_api.g_varchar2) <>
167: nvl(p_rec.information9, hr_api.g_varchar2) or
168: nvl(hr_fmp_shd.g_old_rec.information10, hr_api.g_varchar2) <>
161: nvl(p_rec.information6, hr_api.g_varchar2) or
162: nvl(hr_fmp_shd.g_old_rec.information7, hr_api.g_varchar2) <>
163: nvl(p_rec.information7, hr_api.g_varchar2) or
164: nvl(hr_fmp_shd.g_old_rec.information8, hr_api.g_varchar2) <>
165: nvl(p_rec.information8, hr_api.g_varchar2) or
166: nvl(hr_fmp_shd.g_old_rec.information9, hr_api.g_varchar2) <>
167: nvl(p_rec.information9, hr_api.g_varchar2) or
168: nvl(hr_fmp_shd.g_old_rec.information10, hr_api.g_varchar2) <>
169: nvl(p_rec.information10, hr_api.g_varchar2) or
162: nvl(hr_fmp_shd.g_old_rec.information7, hr_api.g_varchar2) <>
163: nvl(p_rec.information7, hr_api.g_varchar2) or
164: nvl(hr_fmp_shd.g_old_rec.information8, hr_api.g_varchar2) <>
165: nvl(p_rec.information8, hr_api.g_varchar2) or
166: nvl(hr_fmp_shd.g_old_rec.information9, hr_api.g_varchar2) <>
167: nvl(p_rec.information9, hr_api.g_varchar2) or
168: nvl(hr_fmp_shd.g_old_rec.information10, hr_api.g_varchar2) <>
169: nvl(p_rec.information10, hr_api.g_varchar2) or
170: nvl(hr_fmp_shd.g_old_rec.information11, hr_api.g_varchar2) <>
163: nvl(p_rec.information7, hr_api.g_varchar2) or
164: nvl(hr_fmp_shd.g_old_rec.information8, hr_api.g_varchar2) <>
165: nvl(p_rec.information8, hr_api.g_varchar2) or
166: nvl(hr_fmp_shd.g_old_rec.information9, hr_api.g_varchar2) <>
167: nvl(p_rec.information9, hr_api.g_varchar2) or
168: nvl(hr_fmp_shd.g_old_rec.information10, hr_api.g_varchar2) <>
169: nvl(p_rec.information10, hr_api.g_varchar2) or
170: nvl(hr_fmp_shd.g_old_rec.information11, hr_api.g_varchar2) <>
171: nvl(p_rec.information11, hr_api.g_varchar2) or
164: nvl(hr_fmp_shd.g_old_rec.information8, hr_api.g_varchar2) <>
165: nvl(p_rec.information8, hr_api.g_varchar2) or
166: nvl(hr_fmp_shd.g_old_rec.information9, hr_api.g_varchar2) <>
167: nvl(p_rec.information9, hr_api.g_varchar2) or
168: nvl(hr_fmp_shd.g_old_rec.information10, hr_api.g_varchar2) <>
169: nvl(p_rec.information10, hr_api.g_varchar2) or
170: nvl(hr_fmp_shd.g_old_rec.information11, hr_api.g_varchar2) <>
171: nvl(p_rec.information11, hr_api.g_varchar2) or
172: nvl(hr_fmp_shd.g_old_rec.information12, hr_api.g_varchar2) <>
165: nvl(p_rec.information8, hr_api.g_varchar2) or
166: nvl(hr_fmp_shd.g_old_rec.information9, hr_api.g_varchar2) <>
167: nvl(p_rec.information9, hr_api.g_varchar2) or
168: nvl(hr_fmp_shd.g_old_rec.information10, hr_api.g_varchar2) <>
169: nvl(p_rec.information10, hr_api.g_varchar2) or
170: nvl(hr_fmp_shd.g_old_rec.information11, hr_api.g_varchar2) <>
171: nvl(p_rec.information11, hr_api.g_varchar2) or
172: nvl(hr_fmp_shd.g_old_rec.information12, hr_api.g_varchar2) <>
173: nvl(p_rec.information12, hr_api.g_varchar2) or
166: nvl(hr_fmp_shd.g_old_rec.information9, hr_api.g_varchar2) <>
167: nvl(p_rec.information9, hr_api.g_varchar2) or
168: nvl(hr_fmp_shd.g_old_rec.information10, hr_api.g_varchar2) <>
169: nvl(p_rec.information10, hr_api.g_varchar2) or
170: nvl(hr_fmp_shd.g_old_rec.information11, hr_api.g_varchar2) <>
171: nvl(p_rec.information11, hr_api.g_varchar2) or
172: nvl(hr_fmp_shd.g_old_rec.information12, hr_api.g_varchar2) <>
173: nvl(p_rec.information12, hr_api.g_varchar2) or
174: nvl(hr_fmp_shd.g_old_rec.information13, hr_api.g_varchar2) <>
167: nvl(p_rec.information9, hr_api.g_varchar2) or
168: nvl(hr_fmp_shd.g_old_rec.information10, hr_api.g_varchar2) <>
169: nvl(p_rec.information10, hr_api.g_varchar2) or
170: nvl(hr_fmp_shd.g_old_rec.information11, hr_api.g_varchar2) <>
171: nvl(p_rec.information11, hr_api.g_varchar2) or
172: nvl(hr_fmp_shd.g_old_rec.information12, hr_api.g_varchar2) <>
173: nvl(p_rec.information12, hr_api.g_varchar2) or
174: nvl(hr_fmp_shd.g_old_rec.information13, hr_api.g_varchar2) <>
175: nvl(p_rec.information13, hr_api.g_varchar2) or
168: nvl(hr_fmp_shd.g_old_rec.information10, hr_api.g_varchar2) <>
169: nvl(p_rec.information10, hr_api.g_varchar2) or
170: nvl(hr_fmp_shd.g_old_rec.information11, hr_api.g_varchar2) <>
171: nvl(p_rec.information11, hr_api.g_varchar2) or
172: nvl(hr_fmp_shd.g_old_rec.information12, hr_api.g_varchar2) <>
173: nvl(p_rec.information12, hr_api.g_varchar2) or
174: nvl(hr_fmp_shd.g_old_rec.information13, hr_api.g_varchar2) <>
175: nvl(p_rec.information13, hr_api.g_varchar2) or
176: nvl(hr_fmp_shd.g_old_rec.information14, hr_api.g_varchar2) <>
169: nvl(p_rec.information10, hr_api.g_varchar2) or
170: nvl(hr_fmp_shd.g_old_rec.information11, hr_api.g_varchar2) <>
171: nvl(p_rec.information11, hr_api.g_varchar2) or
172: nvl(hr_fmp_shd.g_old_rec.information12, hr_api.g_varchar2) <>
173: nvl(p_rec.information12, hr_api.g_varchar2) or
174: nvl(hr_fmp_shd.g_old_rec.information13, hr_api.g_varchar2) <>
175: nvl(p_rec.information13, hr_api.g_varchar2) or
176: nvl(hr_fmp_shd.g_old_rec.information14, hr_api.g_varchar2) <>
177: nvl(p_rec.information14, hr_api.g_varchar2) or
170: nvl(hr_fmp_shd.g_old_rec.information11, hr_api.g_varchar2) <>
171: nvl(p_rec.information11, hr_api.g_varchar2) or
172: nvl(hr_fmp_shd.g_old_rec.information12, hr_api.g_varchar2) <>
173: nvl(p_rec.information12, hr_api.g_varchar2) or
174: nvl(hr_fmp_shd.g_old_rec.information13, hr_api.g_varchar2) <>
175: nvl(p_rec.information13, hr_api.g_varchar2) or
176: nvl(hr_fmp_shd.g_old_rec.information14, hr_api.g_varchar2) <>
177: nvl(p_rec.information14, hr_api.g_varchar2) or
178: nvl(hr_fmp_shd.g_old_rec.information15, hr_api.g_varchar2) <>
171: nvl(p_rec.information11, hr_api.g_varchar2) or
172: nvl(hr_fmp_shd.g_old_rec.information12, hr_api.g_varchar2) <>
173: nvl(p_rec.information12, hr_api.g_varchar2) or
174: nvl(hr_fmp_shd.g_old_rec.information13, hr_api.g_varchar2) <>
175: nvl(p_rec.information13, hr_api.g_varchar2) or
176: nvl(hr_fmp_shd.g_old_rec.information14, hr_api.g_varchar2) <>
177: nvl(p_rec.information14, hr_api.g_varchar2) or
178: nvl(hr_fmp_shd.g_old_rec.information15, hr_api.g_varchar2) <>
179: nvl(p_rec.information15, hr_api.g_varchar2) or
172: nvl(hr_fmp_shd.g_old_rec.information12, hr_api.g_varchar2) <>
173: nvl(p_rec.information12, hr_api.g_varchar2) or
174: nvl(hr_fmp_shd.g_old_rec.information13, hr_api.g_varchar2) <>
175: nvl(p_rec.information13, hr_api.g_varchar2) or
176: nvl(hr_fmp_shd.g_old_rec.information14, hr_api.g_varchar2) <>
177: nvl(p_rec.information14, hr_api.g_varchar2) or
178: nvl(hr_fmp_shd.g_old_rec.information15, hr_api.g_varchar2) <>
179: nvl(p_rec.information15, hr_api.g_varchar2) or
180: nvl(hr_fmp_shd.g_old_rec.information16, hr_api.g_varchar2) <>
173: nvl(p_rec.information12, hr_api.g_varchar2) or
174: nvl(hr_fmp_shd.g_old_rec.information13, hr_api.g_varchar2) <>
175: nvl(p_rec.information13, hr_api.g_varchar2) or
176: nvl(hr_fmp_shd.g_old_rec.information14, hr_api.g_varchar2) <>
177: nvl(p_rec.information14, hr_api.g_varchar2) or
178: nvl(hr_fmp_shd.g_old_rec.information15, hr_api.g_varchar2) <>
179: nvl(p_rec.information15, hr_api.g_varchar2) or
180: nvl(hr_fmp_shd.g_old_rec.information16, hr_api.g_varchar2) <>
181: nvl(p_rec.information16, hr_api.g_varchar2) or
174: nvl(hr_fmp_shd.g_old_rec.information13, hr_api.g_varchar2) <>
175: nvl(p_rec.information13, hr_api.g_varchar2) or
176: nvl(hr_fmp_shd.g_old_rec.information14, hr_api.g_varchar2) <>
177: nvl(p_rec.information14, hr_api.g_varchar2) or
178: nvl(hr_fmp_shd.g_old_rec.information15, hr_api.g_varchar2) <>
179: nvl(p_rec.information15, hr_api.g_varchar2) or
180: nvl(hr_fmp_shd.g_old_rec.information16, hr_api.g_varchar2) <>
181: nvl(p_rec.information16, hr_api.g_varchar2) or
182: nvl(hr_fmp_shd.g_old_rec.information17, hr_api.g_varchar2) <>
175: nvl(p_rec.information13, hr_api.g_varchar2) or
176: nvl(hr_fmp_shd.g_old_rec.information14, hr_api.g_varchar2) <>
177: nvl(p_rec.information14, hr_api.g_varchar2) or
178: nvl(hr_fmp_shd.g_old_rec.information15, hr_api.g_varchar2) <>
179: nvl(p_rec.information15, hr_api.g_varchar2) or
180: nvl(hr_fmp_shd.g_old_rec.information16, hr_api.g_varchar2) <>
181: nvl(p_rec.information16, hr_api.g_varchar2) or
182: nvl(hr_fmp_shd.g_old_rec.information17, hr_api.g_varchar2) <>
183: nvl(p_rec.information17, hr_api.g_varchar2) or
176: nvl(hr_fmp_shd.g_old_rec.information14, hr_api.g_varchar2) <>
177: nvl(p_rec.information14, hr_api.g_varchar2) or
178: nvl(hr_fmp_shd.g_old_rec.information15, hr_api.g_varchar2) <>
179: nvl(p_rec.information15, hr_api.g_varchar2) or
180: nvl(hr_fmp_shd.g_old_rec.information16, hr_api.g_varchar2) <>
181: nvl(p_rec.information16, hr_api.g_varchar2) or
182: nvl(hr_fmp_shd.g_old_rec.information17, hr_api.g_varchar2) <>
183: nvl(p_rec.information17, hr_api.g_varchar2) or
184: nvl(hr_fmp_shd.g_old_rec.information18, hr_api.g_varchar2) <>
177: nvl(p_rec.information14, hr_api.g_varchar2) or
178: nvl(hr_fmp_shd.g_old_rec.information15, hr_api.g_varchar2) <>
179: nvl(p_rec.information15, hr_api.g_varchar2) or
180: nvl(hr_fmp_shd.g_old_rec.information16, hr_api.g_varchar2) <>
181: nvl(p_rec.information16, hr_api.g_varchar2) or
182: nvl(hr_fmp_shd.g_old_rec.information17, hr_api.g_varchar2) <>
183: nvl(p_rec.information17, hr_api.g_varchar2) or
184: nvl(hr_fmp_shd.g_old_rec.information18, hr_api.g_varchar2) <>
185: nvl(p_rec.information18, hr_api.g_varchar2) or
178: nvl(hr_fmp_shd.g_old_rec.information15, hr_api.g_varchar2) <>
179: nvl(p_rec.information15, hr_api.g_varchar2) or
180: nvl(hr_fmp_shd.g_old_rec.information16, hr_api.g_varchar2) <>
181: nvl(p_rec.information16, hr_api.g_varchar2) or
182: nvl(hr_fmp_shd.g_old_rec.information17, hr_api.g_varchar2) <>
183: nvl(p_rec.information17, hr_api.g_varchar2) or
184: nvl(hr_fmp_shd.g_old_rec.information18, hr_api.g_varchar2) <>
185: nvl(p_rec.information18, hr_api.g_varchar2) or
186: nvl(hr_fmp_shd.g_old_rec.information19, hr_api.g_varchar2) <>
179: nvl(p_rec.information15, hr_api.g_varchar2) or
180: nvl(hr_fmp_shd.g_old_rec.information16, hr_api.g_varchar2) <>
181: nvl(p_rec.information16, hr_api.g_varchar2) or
182: nvl(hr_fmp_shd.g_old_rec.information17, hr_api.g_varchar2) <>
183: nvl(p_rec.information17, hr_api.g_varchar2) or
184: nvl(hr_fmp_shd.g_old_rec.information18, hr_api.g_varchar2) <>
185: nvl(p_rec.information18, hr_api.g_varchar2) or
186: nvl(hr_fmp_shd.g_old_rec.information19, hr_api.g_varchar2) <>
187: nvl(p_rec.information19, hr_api.g_varchar2) or
180: nvl(hr_fmp_shd.g_old_rec.information16, hr_api.g_varchar2) <>
181: nvl(p_rec.information16, hr_api.g_varchar2) or
182: nvl(hr_fmp_shd.g_old_rec.information17, hr_api.g_varchar2) <>
183: nvl(p_rec.information17, hr_api.g_varchar2) or
184: nvl(hr_fmp_shd.g_old_rec.information18, hr_api.g_varchar2) <>
185: nvl(p_rec.information18, hr_api.g_varchar2) or
186: nvl(hr_fmp_shd.g_old_rec.information19, hr_api.g_varchar2) <>
187: nvl(p_rec.information19, hr_api.g_varchar2) or
188: nvl(hr_fmp_shd.g_old_rec.information20, hr_api.g_varchar2) <>
181: nvl(p_rec.information16, hr_api.g_varchar2) or
182: nvl(hr_fmp_shd.g_old_rec.information17, hr_api.g_varchar2) <>
183: nvl(p_rec.information17, hr_api.g_varchar2) or
184: nvl(hr_fmp_shd.g_old_rec.information18, hr_api.g_varchar2) <>
185: nvl(p_rec.information18, hr_api.g_varchar2) or
186: nvl(hr_fmp_shd.g_old_rec.information19, hr_api.g_varchar2) <>
187: nvl(p_rec.information19, hr_api.g_varchar2) or
188: nvl(hr_fmp_shd.g_old_rec.information20, hr_api.g_varchar2) <>
189: nvl(p_rec.information20, hr_api.g_varchar2) or
182: nvl(hr_fmp_shd.g_old_rec.information17, hr_api.g_varchar2) <>
183: nvl(p_rec.information17, hr_api.g_varchar2) or
184: nvl(hr_fmp_shd.g_old_rec.information18, hr_api.g_varchar2) <>
185: nvl(p_rec.information18, hr_api.g_varchar2) or
186: nvl(hr_fmp_shd.g_old_rec.information19, hr_api.g_varchar2) <>
187: nvl(p_rec.information19, hr_api.g_varchar2) or
188: nvl(hr_fmp_shd.g_old_rec.information20, hr_api.g_varchar2) <>
189: nvl(p_rec.information20, hr_api.g_varchar2) or
190: nvl(hr_fmp_shd.g_old_rec.information21, hr_api.g_varchar2) <>
183: nvl(p_rec.information17, hr_api.g_varchar2) or
184: nvl(hr_fmp_shd.g_old_rec.information18, hr_api.g_varchar2) <>
185: nvl(p_rec.information18, hr_api.g_varchar2) or
186: nvl(hr_fmp_shd.g_old_rec.information19, hr_api.g_varchar2) <>
187: nvl(p_rec.information19, hr_api.g_varchar2) or
188: nvl(hr_fmp_shd.g_old_rec.information20, hr_api.g_varchar2) <>
189: nvl(p_rec.information20, hr_api.g_varchar2) or
190: nvl(hr_fmp_shd.g_old_rec.information21, hr_api.g_varchar2) <>
191: nvl(p_rec.information21, hr_api.g_varchar2) or
184: nvl(hr_fmp_shd.g_old_rec.information18, hr_api.g_varchar2) <>
185: nvl(p_rec.information18, hr_api.g_varchar2) or
186: nvl(hr_fmp_shd.g_old_rec.information19, hr_api.g_varchar2) <>
187: nvl(p_rec.information19, hr_api.g_varchar2) or
188: nvl(hr_fmp_shd.g_old_rec.information20, hr_api.g_varchar2) <>
189: nvl(p_rec.information20, hr_api.g_varchar2) or
190: nvl(hr_fmp_shd.g_old_rec.information21, hr_api.g_varchar2) <>
191: nvl(p_rec.information21, hr_api.g_varchar2) or
192: nvl(hr_fmp_shd.g_old_rec.information22, hr_api.g_varchar2) <>
185: nvl(p_rec.information18, hr_api.g_varchar2) or
186: nvl(hr_fmp_shd.g_old_rec.information19, hr_api.g_varchar2) <>
187: nvl(p_rec.information19, hr_api.g_varchar2) or
188: nvl(hr_fmp_shd.g_old_rec.information20, hr_api.g_varchar2) <>
189: nvl(p_rec.information20, hr_api.g_varchar2) or
190: nvl(hr_fmp_shd.g_old_rec.information21, hr_api.g_varchar2) <>
191: nvl(p_rec.information21, hr_api.g_varchar2) or
192: nvl(hr_fmp_shd.g_old_rec.information22, hr_api.g_varchar2) <>
193: nvl(p_rec.information22, hr_api.g_varchar2) or
186: nvl(hr_fmp_shd.g_old_rec.information19, hr_api.g_varchar2) <>
187: nvl(p_rec.information19, hr_api.g_varchar2) or
188: nvl(hr_fmp_shd.g_old_rec.information20, hr_api.g_varchar2) <>
189: nvl(p_rec.information20, hr_api.g_varchar2) or
190: nvl(hr_fmp_shd.g_old_rec.information21, hr_api.g_varchar2) <>
191: nvl(p_rec.information21, hr_api.g_varchar2) or
192: nvl(hr_fmp_shd.g_old_rec.information22, hr_api.g_varchar2) <>
193: nvl(p_rec.information22, hr_api.g_varchar2) or
194: nvl(hr_fmp_shd.g_old_rec.information23, hr_api.g_varchar2) <>
187: nvl(p_rec.information19, hr_api.g_varchar2) or
188: nvl(hr_fmp_shd.g_old_rec.information20, hr_api.g_varchar2) <>
189: nvl(p_rec.information20, hr_api.g_varchar2) or
190: nvl(hr_fmp_shd.g_old_rec.information21, hr_api.g_varchar2) <>
191: nvl(p_rec.information21, hr_api.g_varchar2) or
192: nvl(hr_fmp_shd.g_old_rec.information22, hr_api.g_varchar2) <>
193: nvl(p_rec.information22, hr_api.g_varchar2) or
194: nvl(hr_fmp_shd.g_old_rec.information23, hr_api.g_varchar2) <>
195: nvl(p_rec.information23, hr_api.g_varchar2) or
188: nvl(hr_fmp_shd.g_old_rec.information20, hr_api.g_varchar2) <>
189: nvl(p_rec.information20, hr_api.g_varchar2) or
190: nvl(hr_fmp_shd.g_old_rec.information21, hr_api.g_varchar2) <>
191: nvl(p_rec.information21, hr_api.g_varchar2) or
192: nvl(hr_fmp_shd.g_old_rec.information22, hr_api.g_varchar2) <>
193: nvl(p_rec.information22, hr_api.g_varchar2) or
194: nvl(hr_fmp_shd.g_old_rec.information23, hr_api.g_varchar2) <>
195: nvl(p_rec.information23, hr_api.g_varchar2) or
196: nvl(hr_fmp_shd.g_old_rec.information24, hr_api.g_varchar2) <>
189: nvl(p_rec.information20, hr_api.g_varchar2) or
190: nvl(hr_fmp_shd.g_old_rec.information21, hr_api.g_varchar2) <>
191: nvl(p_rec.information21, hr_api.g_varchar2) or
192: nvl(hr_fmp_shd.g_old_rec.information22, hr_api.g_varchar2) <>
193: nvl(p_rec.information22, hr_api.g_varchar2) or
194: nvl(hr_fmp_shd.g_old_rec.information23, hr_api.g_varchar2) <>
195: nvl(p_rec.information23, hr_api.g_varchar2) or
196: nvl(hr_fmp_shd.g_old_rec.information24, hr_api.g_varchar2) <>
197: nvl(p_rec.information24, hr_api.g_varchar2) or
190: nvl(hr_fmp_shd.g_old_rec.information21, hr_api.g_varchar2) <>
191: nvl(p_rec.information21, hr_api.g_varchar2) or
192: nvl(hr_fmp_shd.g_old_rec.information22, hr_api.g_varchar2) <>
193: nvl(p_rec.information22, hr_api.g_varchar2) or
194: nvl(hr_fmp_shd.g_old_rec.information23, hr_api.g_varchar2) <>
195: nvl(p_rec.information23, hr_api.g_varchar2) or
196: nvl(hr_fmp_shd.g_old_rec.information24, hr_api.g_varchar2) <>
197: nvl(p_rec.information24, hr_api.g_varchar2) or
198: nvl(hr_fmp_shd.g_old_rec.information25, hr_api.g_varchar2) <>
191: nvl(p_rec.information21, hr_api.g_varchar2) or
192: nvl(hr_fmp_shd.g_old_rec.information22, hr_api.g_varchar2) <>
193: nvl(p_rec.information22, hr_api.g_varchar2) or
194: nvl(hr_fmp_shd.g_old_rec.information23, hr_api.g_varchar2) <>
195: nvl(p_rec.information23, hr_api.g_varchar2) or
196: nvl(hr_fmp_shd.g_old_rec.information24, hr_api.g_varchar2) <>
197: nvl(p_rec.information24, hr_api.g_varchar2) or
198: nvl(hr_fmp_shd.g_old_rec.information25, hr_api.g_varchar2) <>
199: nvl(p_rec.information25, hr_api.g_varchar2) or
192: nvl(hr_fmp_shd.g_old_rec.information22, hr_api.g_varchar2) <>
193: nvl(p_rec.information22, hr_api.g_varchar2) or
194: nvl(hr_fmp_shd.g_old_rec.information23, hr_api.g_varchar2) <>
195: nvl(p_rec.information23, hr_api.g_varchar2) or
196: nvl(hr_fmp_shd.g_old_rec.information24, hr_api.g_varchar2) <>
197: nvl(p_rec.information24, hr_api.g_varchar2) or
198: nvl(hr_fmp_shd.g_old_rec.information25, hr_api.g_varchar2) <>
199: nvl(p_rec.information25, hr_api.g_varchar2) or
200: nvl(hr_fmp_shd.g_old_rec.information26, hr_api.g_varchar2) <>
193: nvl(p_rec.information22, hr_api.g_varchar2) or
194: nvl(hr_fmp_shd.g_old_rec.information23, hr_api.g_varchar2) <>
195: nvl(p_rec.information23, hr_api.g_varchar2) or
196: nvl(hr_fmp_shd.g_old_rec.information24, hr_api.g_varchar2) <>
197: nvl(p_rec.information24, hr_api.g_varchar2) or
198: nvl(hr_fmp_shd.g_old_rec.information25, hr_api.g_varchar2) <>
199: nvl(p_rec.information25, hr_api.g_varchar2) or
200: nvl(hr_fmp_shd.g_old_rec.information26, hr_api.g_varchar2) <>
201: nvl(p_rec.information26, hr_api.g_varchar2) or
194: nvl(hr_fmp_shd.g_old_rec.information23, hr_api.g_varchar2) <>
195: nvl(p_rec.information23, hr_api.g_varchar2) or
196: nvl(hr_fmp_shd.g_old_rec.information24, hr_api.g_varchar2) <>
197: nvl(p_rec.information24, hr_api.g_varchar2) or
198: nvl(hr_fmp_shd.g_old_rec.information25, hr_api.g_varchar2) <>
199: nvl(p_rec.information25, hr_api.g_varchar2) or
200: nvl(hr_fmp_shd.g_old_rec.information26, hr_api.g_varchar2) <>
201: nvl(p_rec.information26, hr_api.g_varchar2) or
202: nvl(hr_fmp_shd.g_old_rec.information27, hr_api.g_varchar2) <>
195: nvl(p_rec.information23, hr_api.g_varchar2) or
196: nvl(hr_fmp_shd.g_old_rec.information24, hr_api.g_varchar2) <>
197: nvl(p_rec.information24, hr_api.g_varchar2) or
198: nvl(hr_fmp_shd.g_old_rec.information25, hr_api.g_varchar2) <>
199: nvl(p_rec.information25, hr_api.g_varchar2) or
200: nvl(hr_fmp_shd.g_old_rec.information26, hr_api.g_varchar2) <>
201: nvl(p_rec.information26, hr_api.g_varchar2) or
202: nvl(hr_fmp_shd.g_old_rec.information27, hr_api.g_varchar2) <>
203: nvl(p_rec.information27, hr_api.g_varchar2) or
196: nvl(hr_fmp_shd.g_old_rec.information24, hr_api.g_varchar2) <>
197: nvl(p_rec.information24, hr_api.g_varchar2) or
198: nvl(hr_fmp_shd.g_old_rec.information25, hr_api.g_varchar2) <>
199: nvl(p_rec.information25, hr_api.g_varchar2) or
200: nvl(hr_fmp_shd.g_old_rec.information26, hr_api.g_varchar2) <>
201: nvl(p_rec.information26, hr_api.g_varchar2) or
202: nvl(hr_fmp_shd.g_old_rec.information27, hr_api.g_varchar2) <>
203: nvl(p_rec.information27, hr_api.g_varchar2) or
204: nvl(hr_fmp_shd.g_old_rec.information28, hr_api.g_varchar2) <>
197: nvl(p_rec.information24, hr_api.g_varchar2) or
198: nvl(hr_fmp_shd.g_old_rec.information25, hr_api.g_varchar2) <>
199: nvl(p_rec.information25, hr_api.g_varchar2) or
200: nvl(hr_fmp_shd.g_old_rec.information26, hr_api.g_varchar2) <>
201: nvl(p_rec.information26, hr_api.g_varchar2) or
202: nvl(hr_fmp_shd.g_old_rec.information27, hr_api.g_varchar2) <>
203: nvl(p_rec.information27, hr_api.g_varchar2) or
204: nvl(hr_fmp_shd.g_old_rec.information28, hr_api.g_varchar2) <>
205: nvl(p_rec.information28, hr_api.g_varchar2) or
198: nvl(hr_fmp_shd.g_old_rec.information25, hr_api.g_varchar2) <>
199: nvl(p_rec.information25, hr_api.g_varchar2) or
200: nvl(hr_fmp_shd.g_old_rec.information26, hr_api.g_varchar2) <>
201: nvl(p_rec.information26, hr_api.g_varchar2) or
202: nvl(hr_fmp_shd.g_old_rec.information27, hr_api.g_varchar2) <>
203: nvl(p_rec.information27, hr_api.g_varchar2) or
204: nvl(hr_fmp_shd.g_old_rec.information28, hr_api.g_varchar2) <>
205: nvl(p_rec.information28, hr_api.g_varchar2) or
206: nvl(hr_fmp_shd.g_old_rec.information29, hr_api.g_varchar2) <>
199: nvl(p_rec.information25, hr_api.g_varchar2) or
200: nvl(hr_fmp_shd.g_old_rec.information26, hr_api.g_varchar2) <>
201: nvl(p_rec.information26, hr_api.g_varchar2) or
202: nvl(hr_fmp_shd.g_old_rec.information27, hr_api.g_varchar2) <>
203: nvl(p_rec.information27, hr_api.g_varchar2) or
204: nvl(hr_fmp_shd.g_old_rec.information28, hr_api.g_varchar2) <>
205: nvl(p_rec.information28, hr_api.g_varchar2) or
206: nvl(hr_fmp_shd.g_old_rec.information29, hr_api.g_varchar2) <>
207: nvl(p_rec.information29, hr_api.g_varchar2) or
200: nvl(hr_fmp_shd.g_old_rec.information26, hr_api.g_varchar2) <>
201: nvl(p_rec.information26, hr_api.g_varchar2) or
202: nvl(hr_fmp_shd.g_old_rec.information27, hr_api.g_varchar2) <>
203: nvl(p_rec.information27, hr_api.g_varchar2) or
204: nvl(hr_fmp_shd.g_old_rec.information28, hr_api.g_varchar2) <>
205: nvl(p_rec.information28, hr_api.g_varchar2) or
206: nvl(hr_fmp_shd.g_old_rec.information29, hr_api.g_varchar2) <>
207: nvl(p_rec.information29, hr_api.g_varchar2) or
208: nvl(hr_fmp_shd.g_old_rec.information30, hr_api.g_varchar2) <>
201: nvl(p_rec.information26, hr_api.g_varchar2) or
202: nvl(hr_fmp_shd.g_old_rec.information27, hr_api.g_varchar2) <>
203: nvl(p_rec.information27, hr_api.g_varchar2) or
204: nvl(hr_fmp_shd.g_old_rec.information28, hr_api.g_varchar2) <>
205: nvl(p_rec.information28, hr_api.g_varchar2) or
206: nvl(hr_fmp_shd.g_old_rec.information29, hr_api.g_varchar2) <>
207: nvl(p_rec.information29, hr_api.g_varchar2) or
208: nvl(hr_fmp_shd.g_old_rec.information30, hr_api.g_varchar2) <>
209: nvl(p_rec.information30, hr_api.g_varchar2) )
202: nvl(hr_fmp_shd.g_old_rec.information27, hr_api.g_varchar2) <>
203: nvl(p_rec.information27, hr_api.g_varchar2) or
204: nvl(hr_fmp_shd.g_old_rec.information28, hr_api.g_varchar2) <>
205: nvl(p_rec.information28, hr_api.g_varchar2) or
206: nvl(hr_fmp_shd.g_old_rec.information29, hr_api.g_varchar2) <>
207: nvl(p_rec.information29, hr_api.g_varchar2) or
208: nvl(hr_fmp_shd.g_old_rec.information30, hr_api.g_varchar2) <>
209: nvl(p_rec.information30, hr_api.g_varchar2) )
210: or (p_rec.form_property_id is null) ) then
203: nvl(p_rec.information27, hr_api.g_varchar2) or
204: nvl(hr_fmp_shd.g_old_rec.information28, hr_api.g_varchar2) <>
205: nvl(p_rec.information28, hr_api.g_varchar2) or
206: nvl(hr_fmp_shd.g_old_rec.information29, hr_api.g_varchar2) <>
207: nvl(p_rec.information29, hr_api.g_varchar2) or
208: nvl(hr_fmp_shd.g_old_rec.information30, hr_api.g_varchar2) <>
209: nvl(p_rec.information30, hr_api.g_varchar2) )
210: or (p_rec.form_property_id is null) ) then
211: --
204: nvl(hr_fmp_shd.g_old_rec.information28, hr_api.g_varchar2) <>
205: nvl(p_rec.information28, hr_api.g_varchar2) or
206: nvl(hr_fmp_shd.g_old_rec.information29, hr_api.g_varchar2) <>
207: nvl(p_rec.information29, hr_api.g_varchar2) or
208: nvl(hr_fmp_shd.g_old_rec.information30, hr_api.g_varchar2) <>
209: nvl(p_rec.information30, hr_api.g_varchar2) )
210: or (p_rec.form_property_id is null) ) then
211: --
212: -- Only execute the validation if absolutely necessary:
205: nvl(p_rec.information28, hr_api.g_varchar2) or
206: nvl(hr_fmp_shd.g_old_rec.information29, hr_api.g_varchar2) <>
207: nvl(p_rec.information29, hr_api.g_varchar2) or
208: nvl(hr_fmp_shd.g_old_rec.information30, hr_api.g_varchar2) <>
209: nvl(p_rec.information30, hr_api.g_varchar2) )
210: or (p_rec.form_property_id is null) ) then
211: --
212: -- Only execute the validation if absolutely necessary:
213: -- a) During update, the structure column value or any
333: fnd_message.set_token('STEP ', '5');
334: fnd_message.raise_error;
335: END IF;
336: --
337: IF (nvl(p_rec.application_id,hr_api.g_number) <>
338: nvl(hr_fmp_shd.g_old_rec.application_id,hr_api.g_number)
339: ) THEN
340: l_argument := 'application_id';
341: RAISE l_error;
334: fnd_message.raise_error;
335: END IF;
336: --
337: IF (nvl(p_rec.application_id,hr_api.g_number) <>
338: nvl(hr_fmp_shd.g_old_rec.application_id,hr_api.g_number)
339: ) THEN
340: l_argument := 'application_id';
341: RAISE l_error;
342: END IF;
340: l_argument := 'application_id';
341: RAISE l_error;
342: END IF;
343: --
344: IF (nvl(p_rec.form_id,hr_api.g_number) <>
345: nvl(hr_fmp_shd.g_old_rec.form_id,hr_api.g_number)
346: ) THEN
347: l_argument := 'form_id';
348: RAISE l_error;
341: RAISE l_error;
342: END IF;
343: --
344: IF (nvl(p_rec.form_id,hr_api.g_number) <>
345: nvl(hr_fmp_shd.g_old_rec.form_id,hr_api.g_number)
346: ) THEN
347: l_argument := 'form_id';
348: RAISE l_error;
349: END IF;
347: l_argument := 'form_id';
348: RAISE l_error;
349: END IF;
350: --
351: IF (nvl(p_rec.form_template_id,hr_api.g_number) <>
352: nvl(hr_fmp_shd.g_old_rec.form_template_id,hr_api.g_number)
353: ) THEN
354: l_argument := 'form_template_id';
355: RAISE l_error;
348: RAISE l_error;
349: END IF;
350: --
351: IF (nvl(p_rec.form_template_id,hr_api.g_number) <>
352: nvl(hr_fmp_shd.g_old_rec.form_template_id,hr_api.g_number)
353: ) THEN
354: l_argument := 'form_template_id';
355: RAISE l_error;
356: END IF;
356: END IF;
357: --
358: EXCEPTION
359: WHEN l_error THEN
360: hr_api.argument_changed_error
361: (p_api_name => l_proc
362: ,p_argument => l_argument);
363: WHEN OTHERS THEN
364: RAISE;
562: ,p_form_template_id => p_rec.form_template_id
563: );
564: --
565: IF (p_rec.application_id is not null OR
566: p_rec.application_id <> hr_api.g_number) THEN
567: chk_application_id
568: (p_form_property_id => p_rec.form_property_id
569: ,p_application_id => p_rec.application_id
570: );
570: );
571: END IF;
572: --
573: IF (p_rec.form_id is not null OR
574: p_rec.form_id <> hr_api.g_number) THEN
575: chk_form_id
576: (p_form_property_id => p_rec.form_property_id
577: ,p_form_id => p_rec.form_id
578: ,p_application_id => p_rec.application_id
623: ,p_form_template_id => p_rec.form_template_id
624: );
625: --
626: IF (p_rec.application_id is not null OR
627: p_rec.application_id <> hr_api.g_number) THEN
628: chk_application_id
629: (p_form_property_id => p_rec.form_property_id
630: ,p_application_id => p_rec.application_id
631: );
631: );
632: END IF;
633: --
634: IF (p_rec.form_id is not null OR
635: p_rec.form_id <> hr_api.g_number) THEN
636: chk_form_id
637: (p_form_property_id => p_rec.form_property_id
638: ,p_form_id => p_rec.form_id
639: ,p_application_id => p_rec.application_id