173: -- Internal Row Handler Use Only.
174: --
175: -- ----------------------------------------------------------------------------
176: procedure chk_ddf
177: (p_rec in pqp_shp_shd.g_rec_type
178: ) is
179: --
180: l_proc varchar2(72) := g_package || 'chk_ddf';
181: --
182: begin
183: hr_utility.set_location('Entering:'||l_proc,10);
184: --
185: if ((p_rec.service_history_period_id is not null) and (
186: nvl(pqp_shp_shd.g_old_rec.shp_information_category, hr_api.g_varchar2) <>
187: nvl(p_rec.shp_information_category, hr_api.g_varchar2) or
188: nvl(pqp_shp_shd.g_old_rec.shp_information1, hr_api.g_varchar2) <>
189: nvl(p_rec.shp_information1, hr_api.g_varchar2) or
190: nvl(pqp_shp_shd.g_old_rec.shp_information2, hr_api.g_varchar2) <>
184: --
185: if ((p_rec.service_history_period_id is not null) and (
186: nvl(pqp_shp_shd.g_old_rec.shp_information_category, hr_api.g_varchar2) <>
187: nvl(p_rec.shp_information_category, hr_api.g_varchar2) or
188: nvl(pqp_shp_shd.g_old_rec.shp_information1, hr_api.g_varchar2) <>
189: nvl(p_rec.shp_information1, hr_api.g_varchar2) or
190: nvl(pqp_shp_shd.g_old_rec.shp_information2, hr_api.g_varchar2) <>
191: nvl(p_rec.shp_information2, hr_api.g_varchar2) or
192: nvl(pqp_shp_shd.g_old_rec.shp_information3, hr_api.g_varchar2) <>
186: nvl(pqp_shp_shd.g_old_rec.shp_information_category, hr_api.g_varchar2) <>
187: nvl(p_rec.shp_information_category, hr_api.g_varchar2) or
188: nvl(pqp_shp_shd.g_old_rec.shp_information1, hr_api.g_varchar2) <>
189: nvl(p_rec.shp_information1, hr_api.g_varchar2) or
190: nvl(pqp_shp_shd.g_old_rec.shp_information2, hr_api.g_varchar2) <>
191: nvl(p_rec.shp_information2, hr_api.g_varchar2) or
192: nvl(pqp_shp_shd.g_old_rec.shp_information3, hr_api.g_varchar2) <>
193: nvl(p_rec.shp_information3, hr_api.g_varchar2) or
194: nvl(pqp_shp_shd.g_old_rec.shp_information4, hr_api.g_varchar2) <>
188: nvl(pqp_shp_shd.g_old_rec.shp_information1, hr_api.g_varchar2) <>
189: nvl(p_rec.shp_information1, hr_api.g_varchar2) or
190: nvl(pqp_shp_shd.g_old_rec.shp_information2, hr_api.g_varchar2) <>
191: nvl(p_rec.shp_information2, hr_api.g_varchar2) or
192: nvl(pqp_shp_shd.g_old_rec.shp_information3, hr_api.g_varchar2) <>
193: nvl(p_rec.shp_information3, hr_api.g_varchar2) or
194: nvl(pqp_shp_shd.g_old_rec.shp_information4, hr_api.g_varchar2) <>
195: nvl(p_rec.shp_information4, hr_api.g_varchar2) or
196: nvl(pqp_shp_shd.g_old_rec.shp_information5, hr_api.g_varchar2) <>
190: nvl(pqp_shp_shd.g_old_rec.shp_information2, hr_api.g_varchar2) <>
191: nvl(p_rec.shp_information2, hr_api.g_varchar2) or
192: nvl(pqp_shp_shd.g_old_rec.shp_information3, hr_api.g_varchar2) <>
193: nvl(p_rec.shp_information3, hr_api.g_varchar2) or
194: nvl(pqp_shp_shd.g_old_rec.shp_information4, hr_api.g_varchar2) <>
195: nvl(p_rec.shp_information4, hr_api.g_varchar2) or
196: nvl(pqp_shp_shd.g_old_rec.shp_information5, hr_api.g_varchar2) <>
197: nvl(p_rec.shp_information5, hr_api.g_varchar2) or
198: nvl(pqp_shp_shd.g_old_rec.shp_information6, hr_api.g_varchar2) <>
192: nvl(pqp_shp_shd.g_old_rec.shp_information3, hr_api.g_varchar2) <>
193: nvl(p_rec.shp_information3, hr_api.g_varchar2) or
194: nvl(pqp_shp_shd.g_old_rec.shp_information4, hr_api.g_varchar2) <>
195: nvl(p_rec.shp_information4, hr_api.g_varchar2) or
196: nvl(pqp_shp_shd.g_old_rec.shp_information5, hr_api.g_varchar2) <>
197: nvl(p_rec.shp_information5, hr_api.g_varchar2) or
198: nvl(pqp_shp_shd.g_old_rec.shp_information6, hr_api.g_varchar2) <>
199: nvl(p_rec.shp_information6, hr_api.g_varchar2) or
200: nvl(pqp_shp_shd.g_old_rec.shp_information7, hr_api.g_varchar2) <>
194: nvl(pqp_shp_shd.g_old_rec.shp_information4, hr_api.g_varchar2) <>
195: nvl(p_rec.shp_information4, hr_api.g_varchar2) or
196: nvl(pqp_shp_shd.g_old_rec.shp_information5, hr_api.g_varchar2) <>
197: nvl(p_rec.shp_information5, hr_api.g_varchar2) or
198: nvl(pqp_shp_shd.g_old_rec.shp_information6, hr_api.g_varchar2) <>
199: nvl(p_rec.shp_information6, hr_api.g_varchar2) or
200: nvl(pqp_shp_shd.g_old_rec.shp_information7, hr_api.g_varchar2) <>
201: nvl(p_rec.shp_information7, hr_api.g_varchar2) or
202: nvl(pqp_shp_shd.g_old_rec.shp_information8, hr_api.g_varchar2) <>
196: nvl(pqp_shp_shd.g_old_rec.shp_information5, hr_api.g_varchar2) <>
197: nvl(p_rec.shp_information5, hr_api.g_varchar2) or
198: nvl(pqp_shp_shd.g_old_rec.shp_information6, hr_api.g_varchar2) <>
199: nvl(p_rec.shp_information6, hr_api.g_varchar2) or
200: nvl(pqp_shp_shd.g_old_rec.shp_information7, hr_api.g_varchar2) <>
201: nvl(p_rec.shp_information7, hr_api.g_varchar2) or
202: nvl(pqp_shp_shd.g_old_rec.shp_information8, hr_api.g_varchar2) <>
203: nvl(p_rec.shp_information8, hr_api.g_varchar2) or
204: nvl(pqp_shp_shd.g_old_rec.shp_information9, hr_api.g_varchar2) <>
198: nvl(pqp_shp_shd.g_old_rec.shp_information6, hr_api.g_varchar2) <>
199: nvl(p_rec.shp_information6, hr_api.g_varchar2) or
200: nvl(pqp_shp_shd.g_old_rec.shp_information7, hr_api.g_varchar2) <>
201: nvl(p_rec.shp_information7, hr_api.g_varchar2) or
202: nvl(pqp_shp_shd.g_old_rec.shp_information8, hr_api.g_varchar2) <>
203: nvl(p_rec.shp_information8, hr_api.g_varchar2) or
204: nvl(pqp_shp_shd.g_old_rec.shp_information9, hr_api.g_varchar2) <>
205: nvl(p_rec.shp_information9, hr_api.g_varchar2) or
206: nvl(pqp_shp_shd.g_old_rec.shp_information10, hr_api.g_varchar2) <>
200: nvl(pqp_shp_shd.g_old_rec.shp_information7, hr_api.g_varchar2) <>
201: nvl(p_rec.shp_information7, hr_api.g_varchar2) or
202: nvl(pqp_shp_shd.g_old_rec.shp_information8, hr_api.g_varchar2) <>
203: nvl(p_rec.shp_information8, hr_api.g_varchar2) or
204: nvl(pqp_shp_shd.g_old_rec.shp_information9, hr_api.g_varchar2) <>
205: nvl(p_rec.shp_information9, hr_api.g_varchar2) or
206: nvl(pqp_shp_shd.g_old_rec.shp_information10, hr_api.g_varchar2) <>
207: nvl(p_rec.shp_information10, hr_api.g_varchar2) or
208: nvl(pqp_shp_shd.g_old_rec.shp_information11, hr_api.g_varchar2) <>
202: nvl(pqp_shp_shd.g_old_rec.shp_information8, hr_api.g_varchar2) <>
203: nvl(p_rec.shp_information8, hr_api.g_varchar2) or
204: nvl(pqp_shp_shd.g_old_rec.shp_information9, hr_api.g_varchar2) <>
205: nvl(p_rec.shp_information9, hr_api.g_varchar2) or
206: nvl(pqp_shp_shd.g_old_rec.shp_information10, hr_api.g_varchar2) <>
207: nvl(p_rec.shp_information10, hr_api.g_varchar2) or
208: nvl(pqp_shp_shd.g_old_rec.shp_information11, hr_api.g_varchar2) <>
209: nvl(p_rec.shp_information11, hr_api.g_varchar2) or
210: nvl(pqp_shp_shd.g_old_rec.shp_information12, hr_api.g_varchar2) <>
204: nvl(pqp_shp_shd.g_old_rec.shp_information9, hr_api.g_varchar2) <>
205: nvl(p_rec.shp_information9, hr_api.g_varchar2) or
206: nvl(pqp_shp_shd.g_old_rec.shp_information10, hr_api.g_varchar2) <>
207: nvl(p_rec.shp_information10, hr_api.g_varchar2) or
208: nvl(pqp_shp_shd.g_old_rec.shp_information11, hr_api.g_varchar2) <>
209: nvl(p_rec.shp_information11, hr_api.g_varchar2) or
210: nvl(pqp_shp_shd.g_old_rec.shp_information12, hr_api.g_varchar2) <>
211: nvl(p_rec.shp_information12, hr_api.g_varchar2) or
212: nvl(pqp_shp_shd.g_old_rec.shp_information13, hr_api.g_varchar2) <>
206: nvl(pqp_shp_shd.g_old_rec.shp_information10, hr_api.g_varchar2) <>
207: nvl(p_rec.shp_information10, hr_api.g_varchar2) or
208: nvl(pqp_shp_shd.g_old_rec.shp_information11, hr_api.g_varchar2) <>
209: nvl(p_rec.shp_information11, hr_api.g_varchar2) or
210: nvl(pqp_shp_shd.g_old_rec.shp_information12, hr_api.g_varchar2) <>
211: nvl(p_rec.shp_information12, hr_api.g_varchar2) or
212: nvl(pqp_shp_shd.g_old_rec.shp_information13, hr_api.g_varchar2) <>
213: nvl(p_rec.shp_information13, hr_api.g_varchar2) or
214: nvl(pqp_shp_shd.g_old_rec.shp_information14, hr_api.g_varchar2) <>
208: nvl(pqp_shp_shd.g_old_rec.shp_information11, hr_api.g_varchar2) <>
209: nvl(p_rec.shp_information11, hr_api.g_varchar2) or
210: nvl(pqp_shp_shd.g_old_rec.shp_information12, hr_api.g_varchar2) <>
211: nvl(p_rec.shp_information12, hr_api.g_varchar2) or
212: nvl(pqp_shp_shd.g_old_rec.shp_information13, hr_api.g_varchar2) <>
213: nvl(p_rec.shp_information13, hr_api.g_varchar2) or
214: nvl(pqp_shp_shd.g_old_rec.shp_information14, hr_api.g_varchar2) <>
215: nvl(p_rec.shp_information14, hr_api.g_varchar2) or
216: nvl(pqp_shp_shd.g_old_rec.shp_information15, hr_api.g_varchar2) <>
210: nvl(pqp_shp_shd.g_old_rec.shp_information12, hr_api.g_varchar2) <>
211: nvl(p_rec.shp_information12, hr_api.g_varchar2) or
212: nvl(pqp_shp_shd.g_old_rec.shp_information13, hr_api.g_varchar2) <>
213: nvl(p_rec.shp_information13, hr_api.g_varchar2) or
214: nvl(pqp_shp_shd.g_old_rec.shp_information14, hr_api.g_varchar2) <>
215: nvl(p_rec.shp_information14, hr_api.g_varchar2) or
216: nvl(pqp_shp_shd.g_old_rec.shp_information15, hr_api.g_varchar2) <>
217: nvl(p_rec.shp_information15, hr_api.g_varchar2) or
218: nvl(pqp_shp_shd.g_old_rec.shp_information16, hr_api.g_varchar2) <>
212: nvl(pqp_shp_shd.g_old_rec.shp_information13, hr_api.g_varchar2) <>
213: nvl(p_rec.shp_information13, hr_api.g_varchar2) or
214: nvl(pqp_shp_shd.g_old_rec.shp_information14, hr_api.g_varchar2) <>
215: nvl(p_rec.shp_information14, hr_api.g_varchar2) or
216: nvl(pqp_shp_shd.g_old_rec.shp_information15, hr_api.g_varchar2) <>
217: nvl(p_rec.shp_information15, hr_api.g_varchar2) or
218: nvl(pqp_shp_shd.g_old_rec.shp_information16, hr_api.g_varchar2) <>
219: nvl(p_rec.shp_information16, hr_api.g_varchar2) or
220: nvl(pqp_shp_shd.g_old_rec.shp_information17, hr_api.g_varchar2) <>
214: nvl(pqp_shp_shd.g_old_rec.shp_information14, hr_api.g_varchar2) <>
215: nvl(p_rec.shp_information14, hr_api.g_varchar2) or
216: nvl(pqp_shp_shd.g_old_rec.shp_information15, hr_api.g_varchar2) <>
217: nvl(p_rec.shp_information15, hr_api.g_varchar2) or
218: nvl(pqp_shp_shd.g_old_rec.shp_information16, hr_api.g_varchar2) <>
219: nvl(p_rec.shp_information16, hr_api.g_varchar2) or
220: nvl(pqp_shp_shd.g_old_rec.shp_information17, hr_api.g_varchar2) <>
221: nvl(p_rec.shp_information17, hr_api.g_varchar2) or
222: nvl(pqp_shp_shd.g_old_rec.shp_information18, hr_api.g_varchar2) <>
216: nvl(pqp_shp_shd.g_old_rec.shp_information15, hr_api.g_varchar2) <>
217: nvl(p_rec.shp_information15, hr_api.g_varchar2) or
218: nvl(pqp_shp_shd.g_old_rec.shp_information16, hr_api.g_varchar2) <>
219: nvl(p_rec.shp_information16, hr_api.g_varchar2) or
220: nvl(pqp_shp_shd.g_old_rec.shp_information17, hr_api.g_varchar2) <>
221: nvl(p_rec.shp_information17, hr_api.g_varchar2) or
222: nvl(pqp_shp_shd.g_old_rec.shp_information18, hr_api.g_varchar2) <>
223: nvl(p_rec.shp_information18, hr_api.g_varchar2) or
224: nvl(pqp_shp_shd.g_old_rec.shp_information19, hr_api.g_varchar2) <>
218: nvl(pqp_shp_shd.g_old_rec.shp_information16, hr_api.g_varchar2) <>
219: nvl(p_rec.shp_information16, hr_api.g_varchar2) or
220: nvl(pqp_shp_shd.g_old_rec.shp_information17, hr_api.g_varchar2) <>
221: nvl(p_rec.shp_information17, hr_api.g_varchar2) or
222: nvl(pqp_shp_shd.g_old_rec.shp_information18, hr_api.g_varchar2) <>
223: nvl(p_rec.shp_information18, hr_api.g_varchar2) or
224: nvl(pqp_shp_shd.g_old_rec.shp_information19, hr_api.g_varchar2) <>
225: nvl(p_rec.shp_information19, hr_api.g_varchar2) or
226: nvl(pqp_shp_shd.g_old_rec.shp_information20, hr_api.g_varchar2) <>
220: nvl(pqp_shp_shd.g_old_rec.shp_information17, hr_api.g_varchar2) <>
221: nvl(p_rec.shp_information17, hr_api.g_varchar2) or
222: nvl(pqp_shp_shd.g_old_rec.shp_information18, hr_api.g_varchar2) <>
223: nvl(p_rec.shp_information18, hr_api.g_varchar2) or
224: nvl(pqp_shp_shd.g_old_rec.shp_information19, hr_api.g_varchar2) <>
225: nvl(p_rec.shp_information19, hr_api.g_varchar2) or
226: nvl(pqp_shp_shd.g_old_rec.shp_information20, hr_api.g_varchar2) <>
227: nvl(p_rec.shp_information20, hr_api.g_varchar2) ))
228: or (p_rec.service_history_period_id is null) then
222: nvl(pqp_shp_shd.g_old_rec.shp_information18, hr_api.g_varchar2) <>
223: nvl(p_rec.shp_information18, hr_api.g_varchar2) or
224: nvl(pqp_shp_shd.g_old_rec.shp_information19, hr_api.g_varchar2) <>
225: nvl(p_rec.shp_information19, hr_api.g_varchar2) or
226: nvl(pqp_shp_shd.g_old_rec.shp_information20, hr_api.g_varchar2) <>
227: nvl(p_rec.shp_information20, hr_api.g_varchar2) ))
228: or (p_rec.service_history_period_id is null) then
229: --
230: -- Only execute the validation if absolutely necessary:
310: -- Internal Row Handler Use Only.
311: --
312: -- ----------------------------------------------------------------------------
313: procedure chk_df
314: (p_rec in pqp_shp_shd.g_rec_type
315: ) is
316: --
317: l_proc varchar2(72) := g_package || 'chk_df';
318: --
319: begin
320: hr_utility.set_location('Entering:'||l_proc,10);
321: --
322: if ((p_rec.service_history_period_id is not null) and (
323: nvl(pqp_shp_shd.g_old_rec.shp_attribute_category, hr_api.g_varchar2) <>
324: nvl(p_rec.shp_attribute_category, hr_api.g_varchar2) or
325: nvl(pqp_shp_shd.g_old_rec.shp_attribute1, hr_api.g_varchar2) <>
326: nvl(p_rec.shp_attribute1, hr_api.g_varchar2) or
327: nvl(pqp_shp_shd.g_old_rec.shp_attribute2, hr_api.g_varchar2) <>
321: --
322: if ((p_rec.service_history_period_id is not null) and (
323: nvl(pqp_shp_shd.g_old_rec.shp_attribute_category, hr_api.g_varchar2) <>
324: nvl(p_rec.shp_attribute_category, hr_api.g_varchar2) or
325: nvl(pqp_shp_shd.g_old_rec.shp_attribute1, hr_api.g_varchar2) <>
326: nvl(p_rec.shp_attribute1, hr_api.g_varchar2) or
327: nvl(pqp_shp_shd.g_old_rec.shp_attribute2, hr_api.g_varchar2) <>
328: nvl(p_rec.shp_attribute2, hr_api.g_varchar2) or
329: nvl(pqp_shp_shd.g_old_rec.shp_attribute3, hr_api.g_varchar2) <>
323: nvl(pqp_shp_shd.g_old_rec.shp_attribute_category, hr_api.g_varchar2) <>
324: nvl(p_rec.shp_attribute_category, hr_api.g_varchar2) or
325: nvl(pqp_shp_shd.g_old_rec.shp_attribute1, hr_api.g_varchar2) <>
326: nvl(p_rec.shp_attribute1, hr_api.g_varchar2) or
327: nvl(pqp_shp_shd.g_old_rec.shp_attribute2, hr_api.g_varchar2) <>
328: nvl(p_rec.shp_attribute2, hr_api.g_varchar2) or
329: nvl(pqp_shp_shd.g_old_rec.shp_attribute3, hr_api.g_varchar2) <>
330: nvl(p_rec.shp_attribute3, hr_api.g_varchar2) or
331: nvl(pqp_shp_shd.g_old_rec.shp_attribute4, hr_api.g_varchar2) <>
325: nvl(pqp_shp_shd.g_old_rec.shp_attribute1, hr_api.g_varchar2) <>
326: nvl(p_rec.shp_attribute1, hr_api.g_varchar2) or
327: nvl(pqp_shp_shd.g_old_rec.shp_attribute2, hr_api.g_varchar2) <>
328: nvl(p_rec.shp_attribute2, hr_api.g_varchar2) or
329: nvl(pqp_shp_shd.g_old_rec.shp_attribute3, hr_api.g_varchar2) <>
330: nvl(p_rec.shp_attribute3, hr_api.g_varchar2) or
331: nvl(pqp_shp_shd.g_old_rec.shp_attribute4, hr_api.g_varchar2) <>
332: nvl(p_rec.shp_attribute4, hr_api.g_varchar2) or
333: nvl(pqp_shp_shd.g_old_rec.shp_attribute5, hr_api.g_varchar2) <>
327: nvl(pqp_shp_shd.g_old_rec.shp_attribute2, hr_api.g_varchar2) <>
328: nvl(p_rec.shp_attribute2, hr_api.g_varchar2) or
329: nvl(pqp_shp_shd.g_old_rec.shp_attribute3, hr_api.g_varchar2) <>
330: nvl(p_rec.shp_attribute3, hr_api.g_varchar2) or
331: nvl(pqp_shp_shd.g_old_rec.shp_attribute4, hr_api.g_varchar2) <>
332: nvl(p_rec.shp_attribute4, hr_api.g_varchar2) or
333: nvl(pqp_shp_shd.g_old_rec.shp_attribute5, hr_api.g_varchar2) <>
334: nvl(p_rec.shp_attribute5, hr_api.g_varchar2) or
335: nvl(pqp_shp_shd.g_old_rec.shp_attribute6, hr_api.g_varchar2) <>
329: nvl(pqp_shp_shd.g_old_rec.shp_attribute3, hr_api.g_varchar2) <>
330: nvl(p_rec.shp_attribute3, hr_api.g_varchar2) or
331: nvl(pqp_shp_shd.g_old_rec.shp_attribute4, hr_api.g_varchar2) <>
332: nvl(p_rec.shp_attribute4, hr_api.g_varchar2) or
333: nvl(pqp_shp_shd.g_old_rec.shp_attribute5, hr_api.g_varchar2) <>
334: nvl(p_rec.shp_attribute5, hr_api.g_varchar2) or
335: nvl(pqp_shp_shd.g_old_rec.shp_attribute6, hr_api.g_varchar2) <>
336: nvl(p_rec.shp_attribute6, hr_api.g_varchar2) or
337: nvl(pqp_shp_shd.g_old_rec.shp_attribute7, hr_api.g_varchar2) <>
331: nvl(pqp_shp_shd.g_old_rec.shp_attribute4, hr_api.g_varchar2) <>
332: nvl(p_rec.shp_attribute4, hr_api.g_varchar2) or
333: nvl(pqp_shp_shd.g_old_rec.shp_attribute5, hr_api.g_varchar2) <>
334: nvl(p_rec.shp_attribute5, hr_api.g_varchar2) or
335: nvl(pqp_shp_shd.g_old_rec.shp_attribute6, hr_api.g_varchar2) <>
336: nvl(p_rec.shp_attribute6, hr_api.g_varchar2) or
337: nvl(pqp_shp_shd.g_old_rec.shp_attribute7, hr_api.g_varchar2) <>
338: nvl(p_rec.shp_attribute7, hr_api.g_varchar2) or
339: nvl(pqp_shp_shd.g_old_rec.shp_attribute8, hr_api.g_varchar2) <>
333: nvl(pqp_shp_shd.g_old_rec.shp_attribute5, hr_api.g_varchar2) <>
334: nvl(p_rec.shp_attribute5, hr_api.g_varchar2) or
335: nvl(pqp_shp_shd.g_old_rec.shp_attribute6, hr_api.g_varchar2) <>
336: nvl(p_rec.shp_attribute6, hr_api.g_varchar2) or
337: nvl(pqp_shp_shd.g_old_rec.shp_attribute7, hr_api.g_varchar2) <>
338: nvl(p_rec.shp_attribute7, hr_api.g_varchar2) or
339: nvl(pqp_shp_shd.g_old_rec.shp_attribute8, hr_api.g_varchar2) <>
340: nvl(p_rec.shp_attribute8, hr_api.g_varchar2) or
341: nvl(pqp_shp_shd.g_old_rec.shp_attribute9, hr_api.g_varchar2) <>
335: nvl(pqp_shp_shd.g_old_rec.shp_attribute6, hr_api.g_varchar2) <>
336: nvl(p_rec.shp_attribute6, hr_api.g_varchar2) or
337: nvl(pqp_shp_shd.g_old_rec.shp_attribute7, hr_api.g_varchar2) <>
338: nvl(p_rec.shp_attribute7, hr_api.g_varchar2) or
339: nvl(pqp_shp_shd.g_old_rec.shp_attribute8, hr_api.g_varchar2) <>
340: nvl(p_rec.shp_attribute8, hr_api.g_varchar2) or
341: nvl(pqp_shp_shd.g_old_rec.shp_attribute9, hr_api.g_varchar2) <>
342: nvl(p_rec.shp_attribute9, hr_api.g_varchar2) or
343: nvl(pqp_shp_shd.g_old_rec.shp_attribute10, hr_api.g_varchar2) <>
337: nvl(pqp_shp_shd.g_old_rec.shp_attribute7, hr_api.g_varchar2) <>
338: nvl(p_rec.shp_attribute7, hr_api.g_varchar2) or
339: nvl(pqp_shp_shd.g_old_rec.shp_attribute8, hr_api.g_varchar2) <>
340: nvl(p_rec.shp_attribute8, hr_api.g_varchar2) or
341: nvl(pqp_shp_shd.g_old_rec.shp_attribute9, hr_api.g_varchar2) <>
342: nvl(p_rec.shp_attribute9, hr_api.g_varchar2) or
343: nvl(pqp_shp_shd.g_old_rec.shp_attribute10, hr_api.g_varchar2) <>
344: nvl(p_rec.shp_attribute10, hr_api.g_varchar2) or
345: nvl(pqp_shp_shd.g_old_rec.shp_attribute11, hr_api.g_varchar2) <>
339: nvl(pqp_shp_shd.g_old_rec.shp_attribute8, hr_api.g_varchar2) <>
340: nvl(p_rec.shp_attribute8, hr_api.g_varchar2) or
341: nvl(pqp_shp_shd.g_old_rec.shp_attribute9, hr_api.g_varchar2) <>
342: nvl(p_rec.shp_attribute9, hr_api.g_varchar2) or
343: nvl(pqp_shp_shd.g_old_rec.shp_attribute10, hr_api.g_varchar2) <>
344: nvl(p_rec.shp_attribute10, hr_api.g_varchar2) or
345: nvl(pqp_shp_shd.g_old_rec.shp_attribute11, hr_api.g_varchar2) <>
346: nvl(p_rec.shp_attribute11, hr_api.g_varchar2) or
347: nvl(pqp_shp_shd.g_old_rec.shp_attribute12, hr_api.g_varchar2) <>
341: nvl(pqp_shp_shd.g_old_rec.shp_attribute9, hr_api.g_varchar2) <>
342: nvl(p_rec.shp_attribute9, hr_api.g_varchar2) or
343: nvl(pqp_shp_shd.g_old_rec.shp_attribute10, hr_api.g_varchar2) <>
344: nvl(p_rec.shp_attribute10, hr_api.g_varchar2) or
345: nvl(pqp_shp_shd.g_old_rec.shp_attribute11, hr_api.g_varchar2) <>
346: nvl(p_rec.shp_attribute11, hr_api.g_varchar2) or
347: nvl(pqp_shp_shd.g_old_rec.shp_attribute12, hr_api.g_varchar2) <>
348: nvl(p_rec.shp_attribute12, hr_api.g_varchar2) or
349: nvl(pqp_shp_shd.g_old_rec.shp_attribute13, hr_api.g_varchar2) <>
343: nvl(pqp_shp_shd.g_old_rec.shp_attribute10, hr_api.g_varchar2) <>
344: nvl(p_rec.shp_attribute10, hr_api.g_varchar2) or
345: nvl(pqp_shp_shd.g_old_rec.shp_attribute11, hr_api.g_varchar2) <>
346: nvl(p_rec.shp_attribute11, hr_api.g_varchar2) or
347: nvl(pqp_shp_shd.g_old_rec.shp_attribute12, hr_api.g_varchar2) <>
348: nvl(p_rec.shp_attribute12, hr_api.g_varchar2) or
349: nvl(pqp_shp_shd.g_old_rec.shp_attribute13, hr_api.g_varchar2) <>
350: nvl(p_rec.shp_attribute13, hr_api.g_varchar2) or
351: nvl(pqp_shp_shd.g_old_rec.shp_attribute14, hr_api.g_varchar2) <>
345: nvl(pqp_shp_shd.g_old_rec.shp_attribute11, hr_api.g_varchar2) <>
346: nvl(p_rec.shp_attribute11, hr_api.g_varchar2) or
347: nvl(pqp_shp_shd.g_old_rec.shp_attribute12, hr_api.g_varchar2) <>
348: nvl(p_rec.shp_attribute12, hr_api.g_varchar2) or
349: nvl(pqp_shp_shd.g_old_rec.shp_attribute13, hr_api.g_varchar2) <>
350: nvl(p_rec.shp_attribute13, hr_api.g_varchar2) or
351: nvl(pqp_shp_shd.g_old_rec.shp_attribute14, hr_api.g_varchar2) <>
352: nvl(p_rec.shp_attribute14, hr_api.g_varchar2) or
353: nvl(pqp_shp_shd.g_old_rec.shp_attribute15, hr_api.g_varchar2) <>
347: nvl(pqp_shp_shd.g_old_rec.shp_attribute12, hr_api.g_varchar2) <>
348: nvl(p_rec.shp_attribute12, hr_api.g_varchar2) or
349: nvl(pqp_shp_shd.g_old_rec.shp_attribute13, hr_api.g_varchar2) <>
350: nvl(p_rec.shp_attribute13, hr_api.g_varchar2) or
351: nvl(pqp_shp_shd.g_old_rec.shp_attribute14, hr_api.g_varchar2) <>
352: nvl(p_rec.shp_attribute14, hr_api.g_varchar2) or
353: nvl(pqp_shp_shd.g_old_rec.shp_attribute15, hr_api.g_varchar2) <>
354: nvl(p_rec.shp_attribute15, hr_api.g_varchar2) or
355: nvl(pqp_shp_shd.g_old_rec.shp_attribute16, hr_api.g_varchar2) <>
349: nvl(pqp_shp_shd.g_old_rec.shp_attribute13, hr_api.g_varchar2) <>
350: nvl(p_rec.shp_attribute13, hr_api.g_varchar2) or
351: nvl(pqp_shp_shd.g_old_rec.shp_attribute14, hr_api.g_varchar2) <>
352: nvl(p_rec.shp_attribute14, hr_api.g_varchar2) or
353: nvl(pqp_shp_shd.g_old_rec.shp_attribute15, hr_api.g_varchar2) <>
354: nvl(p_rec.shp_attribute15, hr_api.g_varchar2) or
355: nvl(pqp_shp_shd.g_old_rec.shp_attribute16, hr_api.g_varchar2) <>
356: nvl(p_rec.shp_attribute16, hr_api.g_varchar2) or
357: nvl(pqp_shp_shd.g_old_rec.shp_attribute17, hr_api.g_varchar2) <>
351: nvl(pqp_shp_shd.g_old_rec.shp_attribute14, hr_api.g_varchar2) <>
352: nvl(p_rec.shp_attribute14, hr_api.g_varchar2) or
353: nvl(pqp_shp_shd.g_old_rec.shp_attribute15, hr_api.g_varchar2) <>
354: nvl(p_rec.shp_attribute15, hr_api.g_varchar2) or
355: nvl(pqp_shp_shd.g_old_rec.shp_attribute16, hr_api.g_varchar2) <>
356: nvl(p_rec.shp_attribute16, hr_api.g_varchar2) or
357: nvl(pqp_shp_shd.g_old_rec.shp_attribute17, hr_api.g_varchar2) <>
358: nvl(p_rec.shp_attribute17, hr_api.g_varchar2) or
359: nvl(pqp_shp_shd.g_old_rec.shp_attribute18, hr_api.g_varchar2) <>
353: nvl(pqp_shp_shd.g_old_rec.shp_attribute15, hr_api.g_varchar2) <>
354: nvl(p_rec.shp_attribute15, hr_api.g_varchar2) or
355: nvl(pqp_shp_shd.g_old_rec.shp_attribute16, hr_api.g_varchar2) <>
356: nvl(p_rec.shp_attribute16, hr_api.g_varchar2) or
357: nvl(pqp_shp_shd.g_old_rec.shp_attribute17, hr_api.g_varchar2) <>
358: nvl(p_rec.shp_attribute17, hr_api.g_varchar2) or
359: nvl(pqp_shp_shd.g_old_rec.shp_attribute18, hr_api.g_varchar2) <>
360: nvl(p_rec.shp_attribute18, hr_api.g_varchar2) or
361: nvl(pqp_shp_shd.g_old_rec.shp_attribute19, hr_api.g_varchar2) <>
355: nvl(pqp_shp_shd.g_old_rec.shp_attribute16, hr_api.g_varchar2) <>
356: nvl(p_rec.shp_attribute16, hr_api.g_varchar2) or
357: nvl(pqp_shp_shd.g_old_rec.shp_attribute17, hr_api.g_varchar2) <>
358: nvl(p_rec.shp_attribute17, hr_api.g_varchar2) or
359: nvl(pqp_shp_shd.g_old_rec.shp_attribute18, hr_api.g_varchar2) <>
360: nvl(p_rec.shp_attribute18, hr_api.g_varchar2) or
361: nvl(pqp_shp_shd.g_old_rec.shp_attribute19, hr_api.g_varchar2) <>
362: nvl(p_rec.shp_attribute19, hr_api.g_varchar2) or
363: nvl(pqp_shp_shd.g_old_rec.shp_attribute20, hr_api.g_varchar2) <>
357: nvl(pqp_shp_shd.g_old_rec.shp_attribute17, hr_api.g_varchar2) <>
358: nvl(p_rec.shp_attribute17, hr_api.g_varchar2) or
359: nvl(pqp_shp_shd.g_old_rec.shp_attribute18, hr_api.g_varchar2) <>
360: nvl(p_rec.shp_attribute18, hr_api.g_varchar2) or
361: nvl(pqp_shp_shd.g_old_rec.shp_attribute19, hr_api.g_varchar2) <>
362: nvl(p_rec.shp_attribute19, hr_api.g_varchar2) or
363: nvl(pqp_shp_shd.g_old_rec.shp_attribute20, hr_api.g_varchar2) <>
364: nvl(p_rec.shp_attribute20, hr_api.g_varchar2) ))
365: or (p_rec.service_history_period_id is null) then
359: nvl(pqp_shp_shd.g_old_rec.shp_attribute18, hr_api.g_varchar2) <>
360: nvl(p_rec.shp_attribute18, hr_api.g_varchar2) or
361: nvl(pqp_shp_shd.g_old_rec.shp_attribute19, hr_api.g_varchar2) <>
362: nvl(p_rec.shp_attribute19, hr_api.g_varchar2) or
363: nvl(pqp_shp_shd.g_old_rec.shp_attribute20, hr_api.g_varchar2) <>
364: nvl(p_rec.shp_attribute20, hr_api.g_varchar2) ))
365: or (p_rec.service_history_period_id is null) then
366: --
367: -- Only execute the validation if absolutely necessary:
447: -- {End Of Comments}
448: -- ----------------------------------------------------------------------------
449: Procedure chk_non_updateable_args
450: (
451: p_rec in pqp_shp_shd.g_rec_type
452: ) IS
453: --
454: l_proc varchar2(72) := g_package || 'chk_non_updateable_args';
455: l_error EXCEPTION;
459: --
460: -- Only proceed with the validation if a row exists for the current
461: -- record in the HR Schema.
462: --
463: IF NOT pqp_shp_shd.api_updating
464: (p_service_history_period_id => p_rec.service_history_period_id
465: ,p_object_version_number => p_rec.object_version_number
466: ) THEN
467: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
549: -- b) The year value or day value has changed
550: --
551: --
552:
553: l_api_updating := pqp_shp_shd.api_updating
554: (p_service_history_period_id => p_service_history_period_id
555: ,p_object_version_number => p_object_version_number);
556: --
557:
554: (p_service_history_period_id => p_service_history_period_id
555: ,p_object_version_number => p_object_version_number);
556: --
557:
558: if ((l_api_updating and ((nvl(pqp_shp_shd.g_old_rec.period_years, hr_api.g_number) <>
559: nvl(p_period_years, hr_api.g_number)) or
560: (nvl(pqp_shp_shd.g_old_rec.period_days, hr_api.g_number) <>
561: nvl(p_period_days, hr_api.g_number)))) or
562: (NOT l_api_updating)) then
556: --
557:
558: if ((l_api_updating and ((nvl(pqp_shp_shd.g_old_rec.period_years, hr_api.g_number) <>
559: nvl(p_period_years, hr_api.g_number)) or
560: (nvl(pqp_shp_shd.g_old_rec.period_days, hr_api.g_number) <>
561: nvl(p_period_days, hr_api.g_number)))) or
562: (NOT l_api_updating)) then
563: --
564: -- Check that either year value or day value is not null
658: -- Only proceed with validation if :
659: -- a) The current g_old_rec is current and
660: -- b) The start_date value has changed
661: --
662: l_api_updating := pqp_shp_shd.api_updating
663: (p_service_history_period_id => p_service_history_period_id
664: ,p_object_version_number => p_object_version_number);
665:
666: --
663: (p_service_history_period_id => p_service_history_period_id
664: ,p_object_version_number => p_object_version_number);
665:
666: --
667: if ((l_api_updating and nvl(pqp_shp_shd.g_old_rec.start_date, hr_api.g_date) <>
668: nvl(p_start_date, hr_api.g_date)) or
669: (NOT l_api_updating)) then
670: --
671: --
770: -- b) The end_date value has changed
771: --
772: --
773:
774: l_api_updating := pqp_shp_shd.api_updating
775: (p_service_history_period_id => p_service_history_period_id
776: ,p_object_version_number => p_object_version_number);
777: --
778:
775: (p_service_history_period_id => p_service_history_period_id
776: ,p_object_version_number => p_object_version_number);
777: --
778:
779: if ((l_api_updating and nvl(pqp_shp_shd.g_old_rec.end_date, hr_api.g_date) <>
780: nvl(p_end_date, hr_api.g_date)) or
781: (NOT l_api_updating)) then
782: --
783: -- Check that the end date has a value if start date has a value
827: -- |---------------------------< insert_validate >----------------------------|
828: -- ----------------------------------------------------------------------------
829: Procedure insert_validate
830: (
831: p_rec in pqp_shp_shd.g_rec_type
832: ) is
833: --
834: l_proc varchar2(72) := g_package||'insert_validate';
835: --
882: -- |---------------------------< update_validate >----------------------------|
883: -- ----------------------------------------------------------------------------
884: Procedure update_validate
885: (
886: p_rec in pqp_shp_shd.g_rec_type
887: ) is
888: --
889: l_proc varchar2(72) := g_package||'update_validate';
890: --
951: -- ----------------------------------------------------------------------------
952: -- |---------------------------< delete_validate >----------------------------|
953: -- ----------------------------------------------------------------------------
954: Procedure delete_validate
955: (p_rec in pqp_shp_shd.g_rec_type
956: ) is
957: --
958: l_proc varchar2(72) := g_package||'delete_validate';
959: --