69: hr_utility.set_location('Entering:'|| l_proc, 10);
70: --
71: -- Ensure that all the mandatory parameter are not null
72: --
73: hr_api.mandatory_arg_error
74: (p_api_name => l_proc
75: ,p_argument => 'tab_page_property_id'
76: ,p_argument_value => p_tab_page_property_id
77: );
75: ,p_argument => 'tab_page_property_id'
76: ,p_argument_value => p_tab_page_property_id
77: );
78: --
79: if ( nvl(hr_tpp_bus.g_tab_page_property_id, hr_api.g_number)
80: = p_tab_page_property_id) then
81: --
82: -- The legislation code has already been found with a previous
83: -- call to this function. Just return the value in the global
150: begin
151: hr_utility.set_location('Entering:'||l_proc,10);
152: --
153: if ((p_rec.tab_page_property_id is not null) and (
154: nvl(hr_tpp_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
155: nvl(p_rec.information_category, hr_api.g_varchar2) or
156: nvl(hr_tpp_shd.g_old_rec.information1, hr_api.g_varchar2) <>
157: nvl(p_rec.information1, hr_api.g_varchar2) or
158: nvl(hr_tpp_shd.g_old_rec.information2, hr_api.g_varchar2) <>
151: hr_utility.set_location('Entering:'||l_proc,10);
152: --
153: if ((p_rec.tab_page_property_id is not null) and (
154: nvl(hr_tpp_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
155: nvl(p_rec.information_category, hr_api.g_varchar2) or
156: nvl(hr_tpp_shd.g_old_rec.information1, hr_api.g_varchar2) <>
157: nvl(p_rec.information1, hr_api.g_varchar2) or
158: nvl(hr_tpp_shd.g_old_rec.information2, hr_api.g_varchar2) <>
159: nvl(p_rec.information2, hr_api.g_varchar2) or
152: --
153: if ((p_rec.tab_page_property_id is not null) and (
154: nvl(hr_tpp_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
155: nvl(p_rec.information_category, hr_api.g_varchar2) or
156: nvl(hr_tpp_shd.g_old_rec.information1, hr_api.g_varchar2) <>
157: nvl(p_rec.information1, hr_api.g_varchar2) or
158: nvl(hr_tpp_shd.g_old_rec.information2, hr_api.g_varchar2) <>
159: nvl(p_rec.information2, hr_api.g_varchar2) or
160: nvl(hr_tpp_shd.g_old_rec.information3, hr_api.g_varchar2) <>
153: if ((p_rec.tab_page_property_id is not null) and (
154: nvl(hr_tpp_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
155: nvl(p_rec.information_category, hr_api.g_varchar2) or
156: nvl(hr_tpp_shd.g_old_rec.information1, hr_api.g_varchar2) <>
157: nvl(p_rec.information1, hr_api.g_varchar2) or
158: nvl(hr_tpp_shd.g_old_rec.information2, hr_api.g_varchar2) <>
159: nvl(p_rec.information2, hr_api.g_varchar2) or
160: nvl(hr_tpp_shd.g_old_rec.information3, hr_api.g_varchar2) <>
161: nvl(p_rec.information3, hr_api.g_varchar2) or
154: nvl(hr_tpp_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
155: nvl(p_rec.information_category, hr_api.g_varchar2) or
156: nvl(hr_tpp_shd.g_old_rec.information1, hr_api.g_varchar2) <>
157: nvl(p_rec.information1, hr_api.g_varchar2) or
158: nvl(hr_tpp_shd.g_old_rec.information2, hr_api.g_varchar2) <>
159: nvl(p_rec.information2, hr_api.g_varchar2) or
160: nvl(hr_tpp_shd.g_old_rec.information3, hr_api.g_varchar2) <>
161: nvl(p_rec.information3, hr_api.g_varchar2) or
162: nvl(hr_tpp_shd.g_old_rec.information4, hr_api.g_varchar2) <>
155: nvl(p_rec.information_category, hr_api.g_varchar2) or
156: nvl(hr_tpp_shd.g_old_rec.information1, hr_api.g_varchar2) <>
157: nvl(p_rec.information1, hr_api.g_varchar2) or
158: nvl(hr_tpp_shd.g_old_rec.information2, hr_api.g_varchar2) <>
159: nvl(p_rec.information2, hr_api.g_varchar2) or
160: nvl(hr_tpp_shd.g_old_rec.information3, hr_api.g_varchar2) <>
161: nvl(p_rec.information3, hr_api.g_varchar2) or
162: nvl(hr_tpp_shd.g_old_rec.information4, hr_api.g_varchar2) <>
163: nvl(p_rec.information4, hr_api.g_varchar2) or
156: nvl(hr_tpp_shd.g_old_rec.information1, hr_api.g_varchar2) <>
157: nvl(p_rec.information1, hr_api.g_varchar2) or
158: nvl(hr_tpp_shd.g_old_rec.information2, hr_api.g_varchar2) <>
159: nvl(p_rec.information2, hr_api.g_varchar2) or
160: nvl(hr_tpp_shd.g_old_rec.information3, hr_api.g_varchar2) <>
161: nvl(p_rec.information3, hr_api.g_varchar2) or
162: nvl(hr_tpp_shd.g_old_rec.information4, hr_api.g_varchar2) <>
163: nvl(p_rec.information4, hr_api.g_varchar2) or
164: nvl(hr_tpp_shd.g_old_rec.information5, hr_api.g_varchar2) <>
157: nvl(p_rec.information1, hr_api.g_varchar2) or
158: nvl(hr_tpp_shd.g_old_rec.information2, hr_api.g_varchar2) <>
159: nvl(p_rec.information2, hr_api.g_varchar2) or
160: nvl(hr_tpp_shd.g_old_rec.information3, hr_api.g_varchar2) <>
161: nvl(p_rec.information3, hr_api.g_varchar2) or
162: nvl(hr_tpp_shd.g_old_rec.information4, hr_api.g_varchar2) <>
163: nvl(p_rec.information4, hr_api.g_varchar2) or
164: nvl(hr_tpp_shd.g_old_rec.information5, hr_api.g_varchar2) <>
165: nvl(p_rec.information5, hr_api.g_varchar2) or
158: nvl(hr_tpp_shd.g_old_rec.information2, hr_api.g_varchar2) <>
159: nvl(p_rec.information2, hr_api.g_varchar2) or
160: nvl(hr_tpp_shd.g_old_rec.information3, hr_api.g_varchar2) <>
161: nvl(p_rec.information3, hr_api.g_varchar2) or
162: nvl(hr_tpp_shd.g_old_rec.information4, hr_api.g_varchar2) <>
163: nvl(p_rec.information4, hr_api.g_varchar2) or
164: nvl(hr_tpp_shd.g_old_rec.information5, hr_api.g_varchar2) <>
165: nvl(p_rec.information5, hr_api.g_varchar2) or
166: nvl(hr_tpp_shd.g_old_rec.information6, hr_api.g_varchar2) <>
159: nvl(p_rec.information2, hr_api.g_varchar2) or
160: nvl(hr_tpp_shd.g_old_rec.information3, hr_api.g_varchar2) <>
161: nvl(p_rec.information3, hr_api.g_varchar2) or
162: nvl(hr_tpp_shd.g_old_rec.information4, hr_api.g_varchar2) <>
163: nvl(p_rec.information4, hr_api.g_varchar2) or
164: nvl(hr_tpp_shd.g_old_rec.information5, hr_api.g_varchar2) <>
165: nvl(p_rec.information5, hr_api.g_varchar2) or
166: nvl(hr_tpp_shd.g_old_rec.information6, hr_api.g_varchar2) <>
167: nvl(p_rec.information6, hr_api.g_varchar2) or
160: nvl(hr_tpp_shd.g_old_rec.information3, hr_api.g_varchar2) <>
161: nvl(p_rec.information3, hr_api.g_varchar2) or
162: nvl(hr_tpp_shd.g_old_rec.information4, hr_api.g_varchar2) <>
163: nvl(p_rec.information4, hr_api.g_varchar2) or
164: nvl(hr_tpp_shd.g_old_rec.information5, hr_api.g_varchar2) <>
165: nvl(p_rec.information5, hr_api.g_varchar2) or
166: nvl(hr_tpp_shd.g_old_rec.information6, hr_api.g_varchar2) <>
167: nvl(p_rec.information6, hr_api.g_varchar2) or
168: nvl(hr_tpp_shd.g_old_rec.information7, hr_api.g_varchar2) <>
161: nvl(p_rec.information3, hr_api.g_varchar2) or
162: nvl(hr_tpp_shd.g_old_rec.information4, hr_api.g_varchar2) <>
163: nvl(p_rec.information4, hr_api.g_varchar2) or
164: nvl(hr_tpp_shd.g_old_rec.information5, hr_api.g_varchar2) <>
165: nvl(p_rec.information5, hr_api.g_varchar2) or
166: nvl(hr_tpp_shd.g_old_rec.information6, hr_api.g_varchar2) <>
167: nvl(p_rec.information6, hr_api.g_varchar2) or
168: nvl(hr_tpp_shd.g_old_rec.information7, hr_api.g_varchar2) <>
169: nvl(p_rec.information7, hr_api.g_varchar2) or
162: nvl(hr_tpp_shd.g_old_rec.information4, hr_api.g_varchar2) <>
163: nvl(p_rec.information4, hr_api.g_varchar2) or
164: nvl(hr_tpp_shd.g_old_rec.information5, hr_api.g_varchar2) <>
165: nvl(p_rec.information5, hr_api.g_varchar2) or
166: nvl(hr_tpp_shd.g_old_rec.information6, hr_api.g_varchar2) <>
167: nvl(p_rec.information6, hr_api.g_varchar2) or
168: nvl(hr_tpp_shd.g_old_rec.information7, hr_api.g_varchar2) <>
169: nvl(p_rec.information7, hr_api.g_varchar2) or
170: nvl(hr_tpp_shd.g_old_rec.information8, hr_api.g_varchar2) <>
163: nvl(p_rec.information4, hr_api.g_varchar2) or
164: nvl(hr_tpp_shd.g_old_rec.information5, hr_api.g_varchar2) <>
165: nvl(p_rec.information5, hr_api.g_varchar2) or
166: nvl(hr_tpp_shd.g_old_rec.information6, hr_api.g_varchar2) <>
167: nvl(p_rec.information6, hr_api.g_varchar2) or
168: nvl(hr_tpp_shd.g_old_rec.information7, hr_api.g_varchar2) <>
169: nvl(p_rec.information7, hr_api.g_varchar2) or
170: nvl(hr_tpp_shd.g_old_rec.information8, hr_api.g_varchar2) <>
171: nvl(p_rec.information8, hr_api.g_varchar2) or
164: nvl(hr_tpp_shd.g_old_rec.information5, hr_api.g_varchar2) <>
165: nvl(p_rec.information5, hr_api.g_varchar2) or
166: nvl(hr_tpp_shd.g_old_rec.information6, hr_api.g_varchar2) <>
167: nvl(p_rec.information6, hr_api.g_varchar2) or
168: nvl(hr_tpp_shd.g_old_rec.information7, hr_api.g_varchar2) <>
169: nvl(p_rec.information7, hr_api.g_varchar2) or
170: nvl(hr_tpp_shd.g_old_rec.information8, hr_api.g_varchar2) <>
171: nvl(p_rec.information8, hr_api.g_varchar2) or
172: nvl(hr_tpp_shd.g_old_rec.information9, hr_api.g_varchar2) <>
165: nvl(p_rec.information5, hr_api.g_varchar2) or
166: nvl(hr_tpp_shd.g_old_rec.information6, hr_api.g_varchar2) <>
167: nvl(p_rec.information6, hr_api.g_varchar2) or
168: nvl(hr_tpp_shd.g_old_rec.information7, hr_api.g_varchar2) <>
169: nvl(p_rec.information7, hr_api.g_varchar2) or
170: nvl(hr_tpp_shd.g_old_rec.information8, hr_api.g_varchar2) <>
171: nvl(p_rec.information8, hr_api.g_varchar2) or
172: nvl(hr_tpp_shd.g_old_rec.information9, hr_api.g_varchar2) <>
173: nvl(p_rec.information9, hr_api.g_varchar2) or
166: nvl(hr_tpp_shd.g_old_rec.information6, hr_api.g_varchar2) <>
167: nvl(p_rec.information6, hr_api.g_varchar2) or
168: nvl(hr_tpp_shd.g_old_rec.information7, hr_api.g_varchar2) <>
169: nvl(p_rec.information7, hr_api.g_varchar2) or
170: nvl(hr_tpp_shd.g_old_rec.information8, hr_api.g_varchar2) <>
171: nvl(p_rec.information8, hr_api.g_varchar2) or
172: nvl(hr_tpp_shd.g_old_rec.information9, hr_api.g_varchar2) <>
173: nvl(p_rec.information9, hr_api.g_varchar2) or
174: nvl(hr_tpp_shd.g_old_rec.information10, hr_api.g_varchar2) <>
167: nvl(p_rec.information6, hr_api.g_varchar2) or
168: nvl(hr_tpp_shd.g_old_rec.information7, hr_api.g_varchar2) <>
169: nvl(p_rec.information7, hr_api.g_varchar2) or
170: nvl(hr_tpp_shd.g_old_rec.information8, hr_api.g_varchar2) <>
171: nvl(p_rec.information8, hr_api.g_varchar2) or
172: nvl(hr_tpp_shd.g_old_rec.information9, hr_api.g_varchar2) <>
173: nvl(p_rec.information9, hr_api.g_varchar2) or
174: nvl(hr_tpp_shd.g_old_rec.information10, hr_api.g_varchar2) <>
175: nvl(p_rec.information10, hr_api.g_varchar2) or
168: nvl(hr_tpp_shd.g_old_rec.information7, hr_api.g_varchar2) <>
169: nvl(p_rec.information7, hr_api.g_varchar2) or
170: nvl(hr_tpp_shd.g_old_rec.information8, hr_api.g_varchar2) <>
171: nvl(p_rec.information8, hr_api.g_varchar2) or
172: nvl(hr_tpp_shd.g_old_rec.information9, hr_api.g_varchar2) <>
173: nvl(p_rec.information9, hr_api.g_varchar2) or
174: nvl(hr_tpp_shd.g_old_rec.information10, hr_api.g_varchar2) <>
175: nvl(p_rec.information10, hr_api.g_varchar2) or
176: nvl(hr_tpp_shd.g_old_rec.information11, hr_api.g_varchar2) <>
169: nvl(p_rec.information7, hr_api.g_varchar2) or
170: nvl(hr_tpp_shd.g_old_rec.information8, hr_api.g_varchar2) <>
171: nvl(p_rec.information8, hr_api.g_varchar2) or
172: nvl(hr_tpp_shd.g_old_rec.information9, hr_api.g_varchar2) <>
173: nvl(p_rec.information9, hr_api.g_varchar2) or
174: nvl(hr_tpp_shd.g_old_rec.information10, hr_api.g_varchar2) <>
175: nvl(p_rec.information10, hr_api.g_varchar2) or
176: nvl(hr_tpp_shd.g_old_rec.information11, hr_api.g_varchar2) <>
177: nvl(p_rec.information11, hr_api.g_varchar2) or
170: nvl(hr_tpp_shd.g_old_rec.information8, hr_api.g_varchar2) <>
171: nvl(p_rec.information8, hr_api.g_varchar2) or
172: nvl(hr_tpp_shd.g_old_rec.information9, hr_api.g_varchar2) <>
173: nvl(p_rec.information9, hr_api.g_varchar2) or
174: nvl(hr_tpp_shd.g_old_rec.information10, hr_api.g_varchar2) <>
175: nvl(p_rec.information10, hr_api.g_varchar2) or
176: nvl(hr_tpp_shd.g_old_rec.information11, hr_api.g_varchar2) <>
177: nvl(p_rec.information11, hr_api.g_varchar2) or
178: nvl(hr_tpp_shd.g_old_rec.information12, hr_api.g_varchar2) <>
171: nvl(p_rec.information8, hr_api.g_varchar2) or
172: nvl(hr_tpp_shd.g_old_rec.information9, hr_api.g_varchar2) <>
173: nvl(p_rec.information9, hr_api.g_varchar2) or
174: nvl(hr_tpp_shd.g_old_rec.information10, hr_api.g_varchar2) <>
175: nvl(p_rec.information10, hr_api.g_varchar2) or
176: nvl(hr_tpp_shd.g_old_rec.information11, hr_api.g_varchar2) <>
177: nvl(p_rec.information11, hr_api.g_varchar2) or
178: nvl(hr_tpp_shd.g_old_rec.information12, hr_api.g_varchar2) <>
179: nvl(p_rec.information12, hr_api.g_varchar2) or
172: nvl(hr_tpp_shd.g_old_rec.information9, hr_api.g_varchar2) <>
173: nvl(p_rec.information9, hr_api.g_varchar2) or
174: nvl(hr_tpp_shd.g_old_rec.information10, hr_api.g_varchar2) <>
175: nvl(p_rec.information10, hr_api.g_varchar2) or
176: nvl(hr_tpp_shd.g_old_rec.information11, hr_api.g_varchar2) <>
177: nvl(p_rec.information11, hr_api.g_varchar2) or
178: nvl(hr_tpp_shd.g_old_rec.information12, hr_api.g_varchar2) <>
179: nvl(p_rec.information12, hr_api.g_varchar2) or
180: nvl(hr_tpp_shd.g_old_rec.information13, hr_api.g_varchar2) <>
173: nvl(p_rec.information9, hr_api.g_varchar2) or
174: nvl(hr_tpp_shd.g_old_rec.information10, hr_api.g_varchar2) <>
175: nvl(p_rec.information10, hr_api.g_varchar2) or
176: nvl(hr_tpp_shd.g_old_rec.information11, hr_api.g_varchar2) <>
177: nvl(p_rec.information11, hr_api.g_varchar2) or
178: nvl(hr_tpp_shd.g_old_rec.information12, hr_api.g_varchar2) <>
179: nvl(p_rec.information12, hr_api.g_varchar2) or
180: nvl(hr_tpp_shd.g_old_rec.information13, hr_api.g_varchar2) <>
181: nvl(p_rec.information13, hr_api.g_varchar2) or
174: nvl(hr_tpp_shd.g_old_rec.information10, hr_api.g_varchar2) <>
175: nvl(p_rec.information10, hr_api.g_varchar2) or
176: nvl(hr_tpp_shd.g_old_rec.information11, hr_api.g_varchar2) <>
177: nvl(p_rec.information11, hr_api.g_varchar2) or
178: nvl(hr_tpp_shd.g_old_rec.information12, hr_api.g_varchar2) <>
179: nvl(p_rec.information12, hr_api.g_varchar2) or
180: nvl(hr_tpp_shd.g_old_rec.information13, hr_api.g_varchar2) <>
181: nvl(p_rec.information13, hr_api.g_varchar2) or
182: nvl(hr_tpp_shd.g_old_rec.information14, hr_api.g_varchar2) <>
175: nvl(p_rec.information10, hr_api.g_varchar2) or
176: nvl(hr_tpp_shd.g_old_rec.information11, hr_api.g_varchar2) <>
177: nvl(p_rec.information11, hr_api.g_varchar2) or
178: nvl(hr_tpp_shd.g_old_rec.information12, hr_api.g_varchar2) <>
179: nvl(p_rec.information12, hr_api.g_varchar2) or
180: nvl(hr_tpp_shd.g_old_rec.information13, hr_api.g_varchar2) <>
181: nvl(p_rec.information13, hr_api.g_varchar2) or
182: nvl(hr_tpp_shd.g_old_rec.information14, hr_api.g_varchar2) <>
183: nvl(p_rec.information14, hr_api.g_varchar2) or
176: nvl(hr_tpp_shd.g_old_rec.information11, hr_api.g_varchar2) <>
177: nvl(p_rec.information11, hr_api.g_varchar2) or
178: nvl(hr_tpp_shd.g_old_rec.information12, hr_api.g_varchar2) <>
179: nvl(p_rec.information12, hr_api.g_varchar2) or
180: nvl(hr_tpp_shd.g_old_rec.information13, hr_api.g_varchar2) <>
181: nvl(p_rec.information13, hr_api.g_varchar2) or
182: nvl(hr_tpp_shd.g_old_rec.information14, hr_api.g_varchar2) <>
183: nvl(p_rec.information14, hr_api.g_varchar2) or
184: nvl(hr_tpp_shd.g_old_rec.information15, hr_api.g_varchar2) <>
177: nvl(p_rec.information11, hr_api.g_varchar2) or
178: nvl(hr_tpp_shd.g_old_rec.information12, hr_api.g_varchar2) <>
179: nvl(p_rec.information12, hr_api.g_varchar2) or
180: nvl(hr_tpp_shd.g_old_rec.information13, hr_api.g_varchar2) <>
181: nvl(p_rec.information13, hr_api.g_varchar2) or
182: nvl(hr_tpp_shd.g_old_rec.information14, hr_api.g_varchar2) <>
183: nvl(p_rec.information14, hr_api.g_varchar2) or
184: nvl(hr_tpp_shd.g_old_rec.information15, hr_api.g_varchar2) <>
185: nvl(p_rec.information15, hr_api.g_varchar2) or
178: nvl(hr_tpp_shd.g_old_rec.information12, hr_api.g_varchar2) <>
179: nvl(p_rec.information12, hr_api.g_varchar2) or
180: nvl(hr_tpp_shd.g_old_rec.information13, hr_api.g_varchar2) <>
181: nvl(p_rec.information13, hr_api.g_varchar2) or
182: nvl(hr_tpp_shd.g_old_rec.information14, hr_api.g_varchar2) <>
183: nvl(p_rec.information14, hr_api.g_varchar2) or
184: nvl(hr_tpp_shd.g_old_rec.information15, hr_api.g_varchar2) <>
185: nvl(p_rec.information15, hr_api.g_varchar2) or
186: nvl(hr_tpp_shd.g_old_rec.information16, hr_api.g_varchar2) <>
179: nvl(p_rec.information12, hr_api.g_varchar2) or
180: nvl(hr_tpp_shd.g_old_rec.information13, hr_api.g_varchar2) <>
181: nvl(p_rec.information13, hr_api.g_varchar2) or
182: nvl(hr_tpp_shd.g_old_rec.information14, hr_api.g_varchar2) <>
183: nvl(p_rec.information14, hr_api.g_varchar2) or
184: nvl(hr_tpp_shd.g_old_rec.information15, hr_api.g_varchar2) <>
185: nvl(p_rec.information15, hr_api.g_varchar2) or
186: nvl(hr_tpp_shd.g_old_rec.information16, hr_api.g_varchar2) <>
187: nvl(p_rec.information16, hr_api.g_varchar2) or
180: nvl(hr_tpp_shd.g_old_rec.information13, hr_api.g_varchar2) <>
181: nvl(p_rec.information13, hr_api.g_varchar2) or
182: nvl(hr_tpp_shd.g_old_rec.information14, hr_api.g_varchar2) <>
183: nvl(p_rec.information14, hr_api.g_varchar2) or
184: nvl(hr_tpp_shd.g_old_rec.information15, hr_api.g_varchar2) <>
185: nvl(p_rec.information15, hr_api.g_varchar2) or
186: nvl(hr_tpp_shd.g_old_rec.information16, hr_api.g_varchar2) <>
187: nvl(p_rec.information16, hr_api.g_varchar2) or
188: nvl(hr_tpp_shd.g_old_rec.information17, hr_api.g_varchar2) <>
181: nvl(p_rec.information13, hr_api.g_varchar2) or
182: nvl(hr_tpp_shd.g_old_rec.information14, hr_api.g_varchar2) <>
183: nvl(p_rec.information14, hr_api.g_varchar2) or
184: nvl(hr_tpp_shd.g_old_rec.information15, hr_api.g_varchar2) <>
185: nvl(p_rec.information15, hr_api.g_varchar2) or
186: nvl(hr_tpp_shd.g_old_rec.information16, hr_api.g_varchar2) <>
187: nvl(p_rec.information16, hr_api.g_varchar2) or
188: nvl(hr_tpp_shd.g_old_rec.information17, hr_api.g_varchar2) <>
189: nvl(p_rec.information17, hr_api.g_varchar2) or
182: nvl(hr_tpp_shd.g_old_rec.information14, hr_api.g_varchar2) <>
183: nvl(p_rec.information14, hr_api.g_varchar2) or
184: nvl(hr_tpp_shd.g_old_rec.information15, hr_api.g_varchar2) <>
185: nvl(p_rec.information15, hr_api.g_varchar2) or
186: nvl(hr_tpp_shd.g_old_rec.information16, hr_api.g_varchar2) <>
187: nvl(p_rec.information16, hr_api.g_varchar2) or
188: nvl(hr_tpp_shd.g_old_rec.information17, hr_api.g_varchar2) <>
189: nvl(p_rec.information17, hr_api.g_varchar2) or
190: nvl(hr_tpp_shd.g_old_rec.information18, hr_api.g_varchar2) <>
183: nvl(p_rec.information14, hr_api.g_varchar2) or
184: nvl(hr_tpp_shd.g_old_rec.information15, hr_api.g_varchar2) <>
185: nvl(p_rec.information15, hr_api.g_varchar2) or
186: nvl(hr_tpp_shd.g_old_rec.information16, hr_api.g_varchar2) <>
187: nvl(p_rec.information16, hr_api.g_varchar2) or
188: nvl(hr_tpp_shd.g_old_rec.information17, hr_api.g_varchar2) <>
189: nvl(p_rec.information17, hr_api.g_varchar2) or
190: nvl(hr_tpp_shd.g_old_rec.information18, hr_api.g_varchar2) <>
191: nvl(p_rec.information18, hr_api.g_varchar2) or
184: nvl(hr_tpp_shd.g_old_rec.information15, hr_api.g_varchar2) <>
185: nvl(p_rec.information15, hr_api.g_varchar2) or
186: nvl(hr_tpp_shd.g_old_rec.information16, hr_api.g_varchar2) <>
187: nvl(p_rec.information16, hr_api.g_varchar2) or
188: nvl(hr_tpp_shd.g_old_rec.information17, hr_api.g_varchar2) <>
189: nvl(p_rec.information17, hr_api.g_varchar2) or
190: nvl(hr_tpp_shd.g_old_rec.information18, hr_api.g_varchar2) <>
191: nvl(p_rec.information18, hr_api.g_varchar2) or
192: nvl(hr_tpp_shd.g_old_rec.information19, hr_api.g_varchar2) <>
185: nvl(p_rec.information15, hr_api.g_varchar2) or
186: nvl(hr_tpp_shd.g_old_rec.information16, hr_api.g_varchar2) <>
187: nvl(p_rec.information16, hr_api.g_varchar2) or
188: nvl(hr_tpp_shd.g_old_rec.information17, hr_api.g_varchar2) <>
189: nvl(p_rec.information17, hr_api.g_varchar2) or
190: nvl(hr_tpp_shd.g_old_rec.information18, hr_api.g_varchar2) <>
191: nvl(p_rec.information18, hr_api.g_varchar2) or
192: nvl(hr_tpp_shd.g_old_rec.information19, hr_api.g_varchar2) <>
193: nvl(p_rec.information19, hr_api.g_varchar2) or
186: nvl(hr_tpp_shd.g_old_rec.information16, hr_api.g_varchar2) <>
187: nvl(p_rec.information16, hr_api.g_varchar2) or
188: nvl(hr_tpp_shd.g_old_rec.information17, hr_api.g_varchar2) <>
189: nvl(p_rec.information17, hr_api.g_varchar2) or
190: nvl(hr_tpp_shd.g_old_rec.information18, hr_api.g_varchar2) <>
191: nvl(p_rec.information18, hr_api.g_varchar2) or
192: nvl(hr_tpp_shd.g_old_rec.information19, hr_api.g_varchar2) <>
193: nvl(p_rec.information19, hr_api.g_varchar2) or
194: nvl(hr_tpp_shd.g_old_rec.information20, hr_api.g_varchar2) <>
187: nvl(p_rec.information16, hr_api.g_varchar2) or
188: nvl(hr_tpp_shd.g_old_rec.information17, hr_api.g_varchar2) <>
189: nvl(p_rec.information17, hr_api.g_varchar2) or
190: nvl(hr_tpp_shd.g_old_rec.information18, hr_api.g_varchar2) <>
191: nvl(p_rec.information18, hr_api.g_varchar2) or
192: nvl(hr_tpp_shd.g_old_rec.information19, hr_api.g_varchar2) <>
193: nvl(p_rec.information19, hr_api.g_varchar2) or
194: nvl(hr_tpp_shd.g_old_rec.information20, hr_api.g_varchar2) <>
195: nvl(p_rec.information20, hr_api.g_varchar2) or
188: nvl(hr_tpp_shd.g_old_rec.information17, hr_api.g_varchar2) <>
189: nvl(p_rec.information17, hr_api.g_varchar2) or
190: nvl(hr_tpp_shd.g_old_rec.information18, hr_api.g_varchar2) <>
191: nvl(p_rec.information18, hr_api.g_varchar2) or
192: nvl(hr_tpp_shd.g_old_rec.information19, hr_api.g_varchar2) <>
193: nvl(p_rec.information19, hr_api.g_varchar2) or
194: nvl(hr_tpp_shd.g_old_rec.information20, hr_api.g_varchar2) <>
195: nvl(p_rec.information20, hr_api.g_varchar2) or
196: nvl(hr_tpp_shd.g_old_rec.information21, hr_api.g_varchar2) <>
189: nvl(p_rec.information17, hr_api.g_varchar2) or
190: nvl(hr_tpp_shd.g_old_rec.information18, hr_api.g_varchar2) <>
191: nvl(p_rec.information18, hr_api.g_varchar2) or
192: nvl(hr_tpp_shd.g_old_rec.information19, hr_api.g_varchar2) <>
193: nvl(p_rec.information19, hr_api.g_varchar2) or
194: nvl(hr_tpp_shd.g_old_rec.information20, hr_api.g_varchar2) <>
195: nvl(p_rec.information20, hr_api.g_varchar2) or
196: nvl(hr_tpp_shd.g_old_rec.information21, hr_api.g_varchar2) <>
197: nvl(p_rec.information21, hr_api.g_varchar2) or
190: nvl(hr_tpp_shd.g_old_rec.information18, hr_api.g_varchar2) <>
191: nvl(p_rec.information18, hr_api.g_varchar2) or
192: nvl(hr_tpp_shd.g_old_rec.information19, hr_api.g_varchar2) <>
193: nvl(p_rec.information19, hr_api.g_varchar2) or
194: nvl(hr_tpp_shd.g_old_rec.information20, hr_api.g_varchar2) <>
195: nvl(p_rec.information20, hr_api.g_varchar2) or
196: nvl(hr_tpp_shd.g_old_rec.information21, hr_api.g_varchar2) <>
197: nvl(p_rec.information21, hr_api.g_varchar2) or
198: nvl(hr_tpp_shd.g_old_rec.information22, hr_api.g_varchar2) <>
191: nvl(p_rec.information18, hr_api.g_varchar2) or
192: nvl(hr_tpp_shd.g_old_rec.information19, hr_api.g_varchar2) <>
193: nvl(p_rec.information19, hr_api.g_varchar2) or
194: nvl(hr_tpp_shd.g_old_rec.information20, hr_api.g_varchar2) <>
195: nvl(p_rec.information20, hr_api.g_varchar2) or
196: nvl(hr_tpp_shd.g_old_rec.information21, hr_api.g_varchar2) <>
197: nvl(p_rec.information21, hr_api.g_varchar2) or
198: nvl(hr_tpp_shd.g_old_rec.information22, hr_api.g_varchar2) <>
199: nvl(p_rec.information22, hr_api.g_varchar2) or
192: nvl(hr_tpp_shd.g_old_rec.information19, hr_api.g_varchar2) <>
193: nvl(p_rec.information19, hr_api.g_varchar2) or
194: nvl(hr_tpp_shd.g_old_rec.information20, hr_api.g_varchar2) <>
195: nvl(p_rec.information20, hr_api.g_varchar2) or
196: nvl(hr_tpp_shd.g_old_rec.information21, hr_api.g_varchar2) <>
197: nvl(p_rec.information21, hr_api.g_varchar2) or
198: nvl(hr_tpp_shd.g_old_rec.information22, hr_api.g_varchar2) <>
199: nvl(p_rec.information22, hr_api.g_varchar2) or
200: nvl(hr_tpp_shd.g_old_rec.information23, hr_api.g_varchar2) <>
193: nvl(p_rec.information19, hr_api.g_varchar2) or
194: nvl(hr_tpp_shd.g_old_rec.information20, hr_api.g_varchar2) <>
195: nvl(p_rec.information20, hr_api.g_varchar2) or
196: nvl(hr_tpp_shd.g_old_rec.information21, hr_api.g_varchar2) <>
197: nvl(p_rec.information21, hr_api.g_varchar2) or
198: nvl(hr_tpp_shd.g_old_rec.information22, hr_api.g_varchar2) <>
199: nvl(p_rec.information22, hr_api.g_varchar2) or
200: nvl(hr_tpp_shd.g_old_rec.information23, hr_api.g_varchar2) <>
201: nvl(p_rec.information23, hr_api.g_varchar2) or
194: nvl(hr_tpp_shd.g_old_rec.information20, hr_api.g_varchar2) <>
195: nvl(p_rec.information20, hr_api.g_varchar2) or
196: nvl(hr_tpp_shd.g_old_rec.information21, hr_api.g_varchar2) <>
197: nvl(p_rec.information21, hr_api.g_varchar2) or
198: nvl(hr_tpp_shd.g_old_rec.information22, hr_api.g_varchar2) <>
199: nvl(p_rec.information22, hr_api.g_varchar2) or
200: nvl(hr_tpp_shd.g_old_rec.information23, hr_api.g_varchar2) <>
201: nvl(p_rec.information23, hr_api.g_varchar2) or
202: nvl(hr_tpp_shd.g_old_rec.information24, hr_api.g_varchar2) <>
195: nvl(p_rec.information20, hr_api.g_varchar2) or
196: nvl(hr_tpp_shd.g_old_rec.information21, hr_api.g_varchar2) <>
197: nvl(p_rec.information21, hr_api.g_varchar2) or
198: nvl(hr_tpp_shd.g_old_rec.information22, hr_api.g_varchar2) <>
199: nvl(p_rec.information22, hr_api.g_varchar2) or
200: nvl(hr_tpp_shd.g_old_rec.information23, hr_api.g_varchar2) <>
201: nvl(p_rec.information23, hr_api.g_varchar2) or
202: nvl(hr_tpp_shd.g_old_rec.information24, hr_api.g_varchar2) <>
203: nvl(p_rec.information24, hr_api.g_varchar2) or
196: nvl(hr_tpp_shd.g_old_rec.information21, hr_api.g_varchar2) <>
197: nvl(p_rec.information21, hr_api.g_varchar2) or
198: nvl(hr_tpp_shd.g_old_rec.information22, hr_api.g_varchar2) <>
199: nvl(p_rec.information22, hr_api.g_varchar2) or
200: nvl(hr_tpp_shd.g_old_rec.information23, hr_api.g_varchar2) <>
201: nvl(p_rec.information23, hr_api.g_varchar2) or
202: nvl(hr_tpp_shd.g_old_rec.information24, hr_api.g_varchar2) <>
203: nvl(p_rec.information24, hr_api.g_varchar2) or
204: nvl(hr_tpp_shd.g_old_rec.information25, hr_api.g_varchar2) <>
197: nvl(p_rec.information21, hr_api.g_varchar2) or
198: nvl(hr_tpp_shd.g_old_rec.information22, hr_api.g_varchar2) <>
199: nvl(p_rec.information22, hr_api.g_varchar2) or
200: nvl(hr_tpp_shd.g_old_rec.information23, hr_api.g_varchar2) <>
201: nvl(p_rec.information23, hr_api.g_varchar2) or
202: nvl(hr_tpp_shd.g_old_rec.information24, hr_api.g_varchar2) <>
203: nvl(p_rec.information24, hr_api.g_varchar2) or
204: nvl(hr_tpp_shd.g_old_rec.information25, hr_api.g_varchar2) <>
205: nvl(p_rec.information25, hr_api.g_varchar2) or
198: nvl(hr_tpp_shd.g_old_rec.information22, hr_api.g_varchar2) <>
199: nvl(p_rec.information22, hr_api.g_varchar2) or
200: nvl(hr_tpp_shd.g_old_rec.information23, hr_api.g_varchar2) <>
201: nvl(p_rec.information23, hr_api.g_varchar2) or
202: nvl(hr_tpp_shd.g_old_rec.information24, hr_api.g_varchar2) <>
203: nvl(p_rec.information24, hr_api.g_varchar2) or
204: nvl(hr_tpp_shd.g_old_rec.information25, hr_api.g_varchar2) <>
205: nvl(p_rec.information25, hr_api.g_varchar2) or
206: nvl(hr_tpp_shd.g_old_rec.information26, hr_api.g_varchar2) <>
199: nvl(p_rec.information22, hr_api.g_varchar2) or
200: nvl(hr_tpp_shd.g_old_rec.information23, hr_api.g_varchar2) <>
201: nvl(p_rec.information23, hr_api.g_varchar2) or
202: nvl(hr_tpp_shd.g_old_rec.information24, hr_api.g_varchar2) <>
203: nvl(p_rec.information24, hr_api.g_varchar2) or
204: nvl(hr_tpp_shd.g_old_rec.information25, hr_api.g_varchar2) <>
205: nvl(p_rec.information25, hr_api.g_varchar2) or
206: nvl(hr_tpp_shd.g_old_rec.information26, hr_api.g_varchar2) <>
207: nvl(p_rec.information26, hr_api.g_varchar2) or
200: nvl(hr_tpp_shd.g_old_rec.information23, hr_api.g_varchar2) <>
201: nvl(p_rec.information23, hr_api.g_varchar2) or
202: nvl(hr_tpp_shd.g_old_rec.information24, hr_api.g_varchar2) <>
203: nvl(p_rec.information24, hr_api.g_varchar2) or
204: nvl(hr_tpp_shd.g_old_rec.information25, hr_api.g_varchar2) <>
205: nvl(p_rec.information25, hr_api.g_varchar2) or
206: nvl(hr_tpp_shd.g_old_rec.information26, hr_api.g_varchar2) <>
207: nvl(p_rec.information26, hr_api.g_varchar2) or
208: nvl(hr_tpp_shd.g_old_rec.information27, hr_api.g_varchar2) <>
201: nvl(p_rec.information23, hr_api.g_varchar2) or
202: nvl(hr_tpp_shd.g_old_rec.information24, hr_api.g_varchar2) <>
203: nvl(p_rec.information24, hr_api.g_varchar2) or
204: nvl(hr_tpp_shd.g_old_rec.information25, hr_api.g_varchar2) <>
205: nvl(p_rec.information25, hr_api.g_varchar2) or
206: nvl(hr_tpp_shd.g_old_rec.information26, hr_api.g_varchar2) <>
207: nvl(p_rec.information26, hr_api.g_varchar2) or
208: nvl(hr_tpp_shd.g_old_rec.information27, hr_api.g_varchar2) <>
209: nvl(p_rec.information27, hr_api.g_varchar2) or
202: nvl(hr_tpp_shd.g_old_rec.information24, hr_api.g_varchar2) <>
203: nvl(p_rec.information24, hr_api.g_varchar2) or
204: nvl(hr_tpp_shd.g_old_rec.information25, hr_api.g_varchar2) <>
205: nvl(p_rec.information25, hr_api.g_varchar2) or
206: nvl(hr_tpp_shd.g_old_rec.information26, hr_api.g_varchar2) <>
207: nvl(p_rec.information26, hr_api.g_varchar2) or
208: nvl(hr_tpp_shd.g_old_rec.information27, hr_api.g_varchar2) <>
209: nvl(p_rec.information27, hr_api.g_varchar2) or
210: nvl(hr_tpp_shd.g_old_rec.information28, hr_api.g_varchar2) <>
203: nvl(p_rec.information24, hr_api.g_varchar2) or
204: nvl(hr_tpp_shd.g_old_rec.information25, hr_api.g_varchar2) <>
205: nvl(p_rec.information25, hr_api.g_varchar2) or
206: nvl(hr_tpp_shd.g_old_rec.information26, hr_api.g_varchar2) <>
207: nvl(p_rec.information26, hr_api.g_varchar2) or
208: nvl(hr_tpp_shd.g_old_rec.information27, hr_api.g_varchar2) <>
209: nvl(p_rec.information27, hr_api.g_varchar2) or
210: nvl(hr_tpp_shd.g_old_rec.information28, hr_api.g_varchar2) <>
211: nvl(p_rec.information28, hr_api.g_varchar2) or
204: nvl(hr_tpp_shd.g_old_rec.information25, hr_api.g_varchar2) <>
205: nvl(p_rec.information25, hr_api.g_varchar2) or
206: nvl(hr_tpp_shd.g_old_rec.information26, hr_api.g_varchar2) <>
207: nvl(p_rec.information26, hr_api.g_varchar2) or
208: nvl(hr_tpp_shd.g_old_rec.information27, hr_api.g_varchar2) <>
209: nvl(p_rec.information27, hr_api.g_varchar2) or
210: nvl(hr_tpp_shd.g_old_rec.information28, hr_api.g_varchar2) <>
211: nvl(p_rec.information28, hr_api.g_varchar2) or
212: nvl(hr_tpp_shd.g_old_rec.information29, hr_api.g_varchar2) <>
205: nvl(p_rec.information25, hr_api.g_varchar2) or
206: nvl(hr_tpp_shd.g_old_rec.information26, hr_api.g_varchar2) <>
207: nvl(p_rec.information26, hr_api.g_varchar2) or
208: nvl(hr_tpp_shd.g_old_rec.information27, hr_api.g_varchar2) <>
209: nvl(p_rec.information27, hr_api.g_varchar2) or
210: nvl(hr_tpp_shd.g_old_rec.information28, hr_api.g_varchar2) <>
211: nvl(p_rec.information28, hr_api.g_varchar2) or
212: nvl(hr_tpp_shd.g_old_rec.information29, hr_api.g_varchar2) <>
213: nvl(p_rec.information29, hr_api.g_varchar2) or
206: nvl(hr_tpp_shd.g_old_rec.information26, hr_api.g_varchar2) <>
207: nvl(p_rec.information26, hr_api.g_varchar2) or
208: nvl(hr_tpp_shd.g_old_rec.information27, hr_api.g_varchar2) <>
209: nvl(p_rec.information27, hr_api.g_varchar2) or
210: nvl(hr_tpp_shd.g_old_rec.information28, hr_api.g_varchar2) <>
211: nvl(p_rec.information28, hr_api.g_varchar2) or
212: nvl(hr_tpp_shd.g_old_rec.information29, hr_api.g_varchar2) <>
213: nvl(p_rec.information29, hr_api.g_varchar2) or
214: nvl(hr_tpp_shd.g_old_rec.information30, hr_api.g_varchar2) <>
207: nvl(p_rec.information26, hr_api.g_varchar2) or
208: nvl(hr_tpp_shd.g_old_rec.information27, hr_api.g_varchar2) <>
209: nvl(p_rec.information27, hr_api.g_varchar2) or
210: nvl(hr_tpp_shd.g_old_rec.information28, hr_api.g_varchar2) <>
211: nvl(p_rec.information28, hr_api.g_varchar2) or
212: nvl(hr_tpp_shd.g_old_rec.information29, hr_api.g_varchar2) <>
213: nvl(p_rec.information29, hr_api.g_varchar2) or
214: nvl(hr_tpp_shd.g_old_rec.information30, hr_api.g_varchar2) <>
215: nvl(p_rec.information30, hr_api.g_varchar2) )
208: nvl(hr_tpp_shd.g_old_rec.information27, hr_api.g_varchar2) <>
209: nvl(p_rec.information27, hr_api.g_varchar2) or
210: nvl(hr_tpp_shd.g_old_rec.information28, hr_api.g_varchar2) <>
211: nvl(p_rec.information28, hr_api.g_varchar2) or
212: nvl(hr_tpp_shd.g_old_rec.information29, hr_api.g_varchar2) <>
213: nvl(p_rec.information29, hr_api.g_varchar2) or
214: nvl(hr_tpp_shd.g_old_rec.information30, hr_api.g_varchar2) <>
215: nvl(p_rec.information30, hr_api.g_varchar2) )
216: or (p_rec.tab_page_property_id is null) ) then
209: nvl(p_rec.information27, hr_api.g_varchar2) or
210: nvl(hr_tpp_shd.g_old_rec.information28, hr_api.g_varchar2) <>
211: nvl(p_rec.information28, hr_api.g_varchar2) or
212: nvl(hr_tpp_shd.g_old_rec.information29, hr_api.g_varchar2) <>
213: nvl(p_rec.information29, hr_api.g_varchar2) or
214: nvl(hr_tpp_shd.g_old_rec.information30, hr_api.g_varchar2) <>
215: nvl(p_rec.information30, hr_api.g_varchar2) )
216: or (p_rec.tab_page_property_id is null) ) then
217: --
210: nvl(hr_tpp_shd.g_old_rec.information28, hr_api.g_varchar2) <>
211: nvl(p_rec.information28, hr_api.g_varchar2) or
212: nvl(hr_tpp_shd.g_old_rec.information29, hr_api.g_varchar2) <>
213: nvl(p_rec.information29, hr_api.g_varchar2) or
214: nvl(hr_tpp_shd.g_old_rec.information30, hr_api.g_varchar2) <>
215: nvl(p_rec.information30, hr_api.g_varchar2) )
216: or (p_rec.tab_page_property_id is null) ) then
217: --
218: -- Only execute the validation if absolutely necessary:
211: nvl(p_rec.information28, hr_api.g_varchar2) or
212: nvl(hr_tpp_shd.g_old_rec.information29, hr_api.g_varchar2) <>
213: nvl(p_rec.information29, hr_api.g_varchar2) or
214: nvl(hr_tpp_shd.g_old_rec.information30, hr_api.g_varchar2) <>
215: nvl(p_rec.information30, hr_api.g_varchar2) )
216: or (p_rec.tab_page_property_id is null) ) then
217: --
218: -- Only execute the validation if absolutely necessary:
219: -- a) During update, the structure column value or any
340: fnd_message.set_token('STEP ', '5');
341: fnd_message.raise_error;
342: END IF;
343: --
344: IF (nvl(p_rec.form_tab_page_id,hr_api.g_number) <>
345: nvl(hr_tpp_shd.g_old_rec.form_tab_page_id,hr_api.g_number)
346: ) THEN
347: l_argument := 'form_tab_page_id';
348: RAISE l_error;
341: fnd_message.raise_error;
342: END IF;
343: --
344: IF (nvl(p_rec.form_tab_page_id,hr_api.g_number) <>
345: nvl(hr_tpp_shd.g_old_rec.form_tab_page_id,hr_api.g_number)
346: ) THEN
347: l_argument := 'form_tab_page_id';
348: RAISE l_error;
349: END IF;
347: l_argument := 'form_tab_page_id';
348: RAISE l_error;
349: END IF;
350: --
351: IF (nvl(p_rec.template_tab_page_id,hr_api.g_number) <>
352: nvl(hr_tpp_shd.g_old_rec.template_tab_page_id,hr_api.g_number)
353: ) THEN
354: l_argument := 'template_tab_page_id';
355: RAISE l_error;
348: RAISE l_error;
349: END IF;
350: --
351: IF (nvl(p_rec.template_tab_page_id,hr_api.g_number) <>
352: nvl(hr_tpp_shd.g_old_rec.template_tab_page_id,hr_api.g_number)
353: ) THEN
354: l_argument := 'template_tab_page_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;
457: hr_utility.set_location('Entering:'||l_proc, 10);
458: --
459: -- Check mandatory arguments have been set
460: --
461: hr_api.mandatory_arg_error
462: (p_api_name => l_proc
463: ,p_argument => 'effective_date'
464: ,p_argument_value => p_effective_date
465: );
472: --
473: -- Only proceed with SQL validation if absolutely necessary
474: --
475: if ( ( l_api_updating
476: and nvl(hr_tpp_shd.g_old_rec.navigation_direction,hr_api.g_varchar2) <>
477: nvl(p_navigation_direction,hr_api.g_varchar2))
478: or (NOT l_api_updating)) then
479: --
480: hr_utility.set_location(l_proc,30);
473: -- Only proceed with SQL validation if absolutely necessary
474: --
475: if ( ( l_api_updating
476: and nvl(hr_tpp_shd.g_old_rec.navigation_direction,hr_api.g_varchar2) <>
477: nvl(p_navigation_direction,hr_api.g_varchar2))
478: or (NOT l_api_updating)) then
479: --
480: hr_utility.set_location(l_proc,30);
481: --
485: --
486: -- Must exist in hr_standard_lookups where lookup_type is
487: -- NAVIGATION_DIRECTION
488: --
489: if hr_api.not_exists_in_hrstanlookups
490: (p_effective_date => p_effective_date
491: ,p_lookup_type => 'NAVIGATION_DIRECTION'
492: ,p_lookup_code => p_navigation_direction
493: ) then
521: hr_utility.set_location('Entering:'||l_proc, 10);
522: --
523: -- Check mandatory arguments have been set
524: --
525: hr_api.mandatory_arg_error
526: (p_api_name => l_proc
527: ,p_argument => 'effective_date'
528: ,p_argument_value => p_effective_date
529: );
536: --
537: -- Only proceed with SQL validation if absolutely necessary
538: --
539: if ( ( l_api_updating
540: and nvl(hr_tpp_shd.g_old_rec.visible,hr_api.g_number) <>
541: nvl(p_visible,hr_api.g_number))
542: or (NOT l_api_updating)) then
543: --
544: hr_utility.set_location(l_proc,30);
537: -- Only proceed with SQL validation if absolutely necessary
538: --
539: if ( ( l_api_updating
540: and nvl(hr_tpp_shd.g_old_rec.visible,hr_api.g_number) <>
541: nvl(p_visible,hr_api.g_number))
542: or (NOT l_api_updating)) then
543: --
544: hr_utility.set_location(l_proc,30);
545: --
549: --
550: -- Must exist in hr_standard_lookups where lookup_type is
551: -- PROPERTY_TRUE_OR_FALSE
552: --
553: if hr_api.not_exists_in_hrstanlookups
554: (p_effective_date => p_effective_date
555: ,p_lookup_type => 'PROPERTY_TRUE_OR_FALSE'
556: ,p_lookup_code => p_visible
557: ) then
601: hr_utility.set_location('Entering:'||l_proc, 5);
602: --
603: -- Check mandatory arguments have been set
604: --
605: hr_api.mandatory_arg_error
606: (p_api_name => l_proc
607: ,p_argument => 'effective_date'
608: ,p_argument_value => p_effective_date
609: );
665: hr_utility.set_location('Entering:'||l_proc, 5);
666: --
667: -- Check mandatory arguments have been set
668: --
669: hr_api.mandatory_arg_error
670: (p_api_name => l_proc
671: ,p_argument => 'effective_date'
672: ,p_argument_value => p_effective_date
673: );