[Home] [Help]
173: -- Internal Row Handler Use Only.
174: --
175: -- ---------------------------------------------------------------------------+
176: procedure chk_ddf
177: (p_rec in pqp_aat_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.assignment_attribute_id is not null) and (
186: nvl(pqp_aat_shd.g_old_rec.aat_information_category, hr_api.g_varchar2) <>
187: nvl(p_rec.aat_information_category, hr_api.g_varchar2) or
188: nvl(pqp_aat_shd.g_old_rec.aat_information1, hr_api.g_varchar2) <>
189: nvl(p_rec.aat_information1, hr_api.g_varchar2) or
190: nvl(pqp_aat_shd.g_old_rec.aat_information2, hr_api.g_varchar2) <>
184: --
185: if ((p_rec.assignment_attribute_id is not null) and (
186: nvl(pqp_aat_shd.g_old_rec.aat_information_category, hr_api.g_varchar2) <>
187: nvl(p_rec.aat_information_category, hr_api.g_varchar2) or
188: nvl(pqp_aat_shd.g_old_rec.aat_information1, hr_api.g_varchar2) <>
189: nvl(p_rec.aat_information1, hr_api.g_varchar2) or
190: nvl(pqp_aat_shd.g_old_rec.aat_information2, hr_api.g_varchar2) <>
191: nvl(p_rec.aat_information2, hr_api.g_varchar2) or
192: nvl(pqp_aat_shd.g_old_rec.aat_information3, hr_api.g_varchar2) <>
186: nvl(pqp_aat_shd.g_old_rec.aat_information_category, hr_api.g_varchar2) <>
187: nvl(p_rec.aat_information_category, hr_api.g_varchar2) or
188: nvl(pqp_aat_shd.g_old_rec.aat_information1, hr_api.g_varchar2) <>
189: nvl(p_rec.aat_information1, hr_api.g_varchar2) or
190: nvl(pqp_aat_shd.g_old_rec.aat_information2, hr_api.g_varchar2) <>
191: nvl(p_rec.aat_information2, hr_api.g_varchar2) or
192: nvl(pqp_aat_shd.g_old_rec.aat_information3, hr_api.g_varchar2) <>
193: nvl(p_rec.aat_information3, hr_api.g_varchar2) or
194: nvl(pqp_aat_shd.g_old_rec.aat_information4, hr_api.g_varchar2) <>
188: nvl(pqp_aat_shd.g_old_rec.aat_information1, hr_api.g_varchar2) <>
189: nvl(p_rec.aat_information1, hr_api.g_varchar2) or
190: nvl(pqp_aat_shd.g_old_rec.aat_information2, hr_api.g_varchar2) <>
191: nvl(p_rec.aat_information2, hr_api.g_varchar2) or
192: nvl(pqp_aat_shd.g_old_rec.aat_information3, hr_api.g_varchar2) <>
193: nvl(p_rec.aat_information3, hr_api.g_varchar2) or
194: nvl(pqp_aat_shd.g_old_rec.aat_information4, hr_api.g_varchar2) <>
195: nvl(p_rec.aat_information4, hr_api.g_varchar2) or
196: nvl(pqp_aat_shd.g_old_rec.aat_information5, hr_api.g_varchar2) <>
190: nvl(pqp_aat_shd.g_old_rec.aat_information2, hr_api.g_varchar2) <>
191: nvl(p_rec.aat_information2, hr_api.g_varchar2) or
192: nvl(pqp_aat_shd.g_old_rec.aat_information3, hr_api.g_varchar2) <>
193: nvl(p_rec.aat_information3, hr_api.g_varchar2) or
194: nvl(pqp_aat_shd.g_old_rec.aat_information4, hr_api.g_varchar2) <>
195: nvl(p_rec.aat_information4, hr_api.g_varchar2) or
196: nvl(pqp_aat_shd.g_old_rec.aat_information5, hr_api.g_varchar2) <>
197: nvl(p_rec.aat_information5, hr_api.g_varchar2) or
198: nvl(pqp_aat_shd.g_old_rec.aat_information6, hr_api.g_varchar2) <>
192: nvl(pqp_aat_shd.g_old_rec.aat_information3, hr_api.g_varchar2) <>
193: nvl(p_rec.aat_information3, hr_api.g_varchar2) or
194: nvl(pqp_aat_shd.g_old_rec.aat_information4, hr_api.g_varchar2) <>
195: nvl(p_rec.aat_information4, hr_api.g_varchar2) or
196: nvl(pqp_aat_shd.g_old_rec.aat_information5, hr_api.g_varchar2) <>
197: nvl(p_rec.aat_information5, hr_api.g_varchar2) or
198: nvl(pqp_aat_shd.g_old_rec.aat_information6, hr_api.g_varchar2) <>
199: nvl(p_rec.aat_information6, hr_api.g_varchar2) or
200: nvl(pqp_aat_shd.g_old_rec.aat_information7, hr_api.g_varchar2) <>
194: nvl(pqp_aat_shd.g_old_rec.aat_information4, hr_api.g_varchar2) <>
195: nvl(p_rec.aat_information4, hr_api.g_varchar2) or
196: nvl(pqp_aat_shd.g_old_rec.aat_information5, hr_api.g_varchar2) <>
197: nvl(p_rec.aat_information5, hr_api.g_varchar2) or
198: nvl(pqp_aat_shd.g_old_rec.aat_information6, hr_api.g_varchar2) <>
199: nvl(p_rec.aat_information6, hr_api.g_varchar2) or
200: nvl(pqp_aat_shd.g_old_rec.aat_information7, hr_api.g_varchar2) <>
201: nvl(p_rec.aat_information7, hr_api.g_varchar2) or
202: nvl(pqp_aat_shd.g_old_rec.aat_information8, hr_api.g_varchar2) <>
196: nvl(pqp_aat_shd.g_old_rec.aat_information5, hr_api.g_varchar2) <>
197: nvl(p_rec.aat_information5, hr_api.g_varchar2) or
198: nvl(pqp_aat_shd.g_old_rec.aat_information6, hr_api.g_varchar2) <>
199: nvl(p_rec.aat_information6, hr_api.g_varchar2) or
200: nvl(pqp_aat_shd.g_old_rec.aat_information7, hr_api.g_varchar2) <>
201: nvl(p_rec.aat_information7, hr_api.g_varchar2) or
202: nvl(pqp_aat_shd.g_old_rec.aat_information8, hr_api.g_varchar2) <>
203: nvl(p_rec.aat_information8, hr_api.g_varchar2) or
204: nvl(pqp_aat_shd.g_old_rec.aat_information9, hr_api.g_varchar2) <>
198: nvl(pqp_aat_shd.g_old_rec.aat_information6, hr_api.g_varchar2) <>
199: nvl(p_rec.aat_information6, hr_api.g_varchar2) or
200: nvl(pqp_aat_shd.g_old_rec.aat_information7, hr_api.g_varchar2) <>
201: nvl(p_rec.aat_information7, hr_api.g_varchar2) or
202: nvl(pqp_aat_shd.g_old_rec.aat_information8, hr_api.g_varchar2) <>
203: nvl(p_rec.aat_information8, hr_api.g_varchar2) or
204: nvl(pqp_aat_shd.g_old_rec.aat_information9, hr_api.g_varchar2) <>
205: nvl(p_rec.aat_information9, hr_api.g_varchar2) or
206: nvl(pqp_aat_shd.g_old_rec.aat_information10, hr_api.g_varchar2) <>
200: nvl(pqp_aat_shd.g_old_rec.aat_information7, hr_api.g_varchar2) <>
201: nvl(p_rec.aat_information7, hr_api.g_varchar2) or
202: nvl(pqp_aat_shd.g_old_rec.aat_information8, hr_api.g_varchar2) <>
203: nvl(p_rec.aat_information8, hr_api.g_varchar2) or
204: nvl(pqp_aat_shd.g_old_rec.aat_information9, hr_api.g_varchar2) <>
205: nvl(p_rec.aat_information9, hr_api.g_varchar2) or
206: nvl(pqp_aat_shd.g_old_rec.aat_information10, hr_api.g_varchar2) <>
207: nvl(p_rec.aat_information10, hr_api.g_varchar2) or
208: nvl(pqp_aat_shd.g_old_rec.aat_information11, hr_api.g_varchar2) <>
202: nvl(pqp_aat_shd.g_old_rec.aat_information8, hr_api.g_varchar2) <>
203: nvl(p_rec.aat_information8, hr_api.g_varchar2) or
204: nvl(pqp_aat_shd.g_old_rec.aat_information9, hr_api.g_varchar2) <>
205: nvl(p_rec.aat_information9, hr_api.g_varchar2) or
206: nvl(pqp_aat_shd.g_old_rec.aat_information10, hr_api.g_varchar2) <>
207: nvl(p_rec.aat_information10, hr_api.g_varchar2) or
208: nvl(pqp_aat_shd.g_old_rec.aat_information11, hr_api.g_varchar2) <>
209: nvl(p_rec.aat_information11, hr_api.g_varchar2) or
210: nvl(pqp_aat_shd.g_old_rec.aat_information12, hr_api.g_varchar2) <>
204: nvl(pqp_aat_shd.g_old_rec.aat_information9, hr_api.g_varchar2) <>
205: nvl(p_rec.aat_information9, hr_api.g_varchar2) or
206: nvl(pqp_aat_shd.g_old_rec.aat_information10, hr_api.g_varchar2) <>
207: nvl(p_rec.aat_information10, hr_api.g_varchar2) or
208: nvl(pqp_aat_shd.g_old_rec.aat_information11, hr_api.g_varchar2) <>
209: nvl(p_rec.aat_information11, hr_api.g_varchar2) or
210: nvl(pqp_aat_shd.g_old_rec.aat_information12, hr_api.g_varchar2) <>
211: nvl(p_rec.aat_information12, hr_api.g_varchar2) or
212: nvl(pqp_aat_shd.g_old_rec.aat_information13, hr_api.g_varchar2) <>
206: nvl(pqp_aat_shd.g_old_rec.aat_information10, hr_api.g_varchar2) <>
207: nvl(p_rec.aat_information10, hr_api.g_varchar2) or
208: nvl(pqp_aat_shd.g_old_rec.aat_information11, hr_api.g_varchar2) <>
209: nvl(p_rec.aat_information11, hr_api.g_varchar2) or
210: nvl(pqp_aat_shd.g_old_rec.aat_information12, hr_api.g_varchar2) <>
211: nvl(p_rec.aat_information12, hr_api.g_varchar2) or
212: nvl(pqp_aat_shd.g_old_rec.aat_information13, hr_api.g_varchar2) <>
213: nvl(p_rec.aat_information13, hr_api.g_varchar2) or
214: nvl(pqp_aat_shd.g_old_rec.aat_information14, hr_api.g_varchar2) <>
208: nvl(pqp_aat_shd.g_old_rec.aat_information11, hr_api.g_varchar2) <>
209: nvl(p_rec.aat_information11, hr_api.g_varchar2) or
210: nvl(pqp_aat_shd.g_old_rec.aat_information12, hr_api.g_varchar2) <>
211: nvl(p_rec.aat_information12, hr_api.g_varchar2) or
212: nvl(pqp_aat_shd.g_old_rec.aat_information13, hr_api.g_varchar2) <>
213: nvl(p_rec.aat_information13, hr_api.g_varchar2) or
214: nvl(pqp_aat_shd.g_old_rec.aat_information14, hr_api.g_varchar2) <>
215: nvl(p_rec.aat_information14, hr_api.g_varchar2) or
216: nvl(pqp_aat_shd.g_old_rec.aat_information15, hr_api.g_varchar2) <>
210: nvl(pqp_aat_shd.g_old_rec.aat_information12, hr_api.g_varchar2) <>
211: nvl(p_rec.aat_information12, hr_api.g_varchar2) or
212: nvl(pqp_aat_shd.g_old_rec.aat_information13, hr_api.g_varchar2) <>
213: nvl(p_rec.aat_information13, hr_api.g_varchar2) or
214: nvl(pqp_aat_shd.g_old_rec.aat_information14, hr_api.g_varchar2) <>
215: nvl(p_rec.aat_information14, hr_api.g_varchar2) or
216: nvl(pqp_aat_shd.g_old_rec.aat_information15, hr_api.g_varchar2) <>
217: nvl(p_rec.aat_information15, hr_api.g_varchar2) or
218: nvl(pqp_aat_shd.g_old_rec.aat_information16, hr_api.g_varchar2) <>
212: nvl(pqp_aat_shd.g_old_rec.aat_information13, hr_api.g_varchar2) <>
213: nvl(p_rec.aat_information13, hr_api.g_varchar2) or
214: nvl(pqp_aat_shd.g_old_rec.aat_information14, hr_api.g_varchar2) <>
215: nvl(p_rec.aat_information14, hr_api.g_varchar2) or
216: nvl(pqp_aat_shd.g_old_rec.aat_information15, hr_api.g_varchar2) <>
217: nvl(p_rec.aat_information15, hr_api.g_varchar2) or
218: nvl(pqp_aat_shd.g_old_rec.aat_information16, hr_api.g_varchar2) <>
219: nvl(p_rec.aat_information16, hr_api.g_varchar2) or
220: nvl(pqp_aat_shd.g_old_rec.aat_information17, hr_api.g_varchar2) <>
214: nvl(pqp_aat_shd.g_old_rec.aat_information14, hr_api.g_varchar2) <>
215: nvl(p_rec.aat_information14, hr_api.g_varchar2) or
216: nvl(pqp_aat_shd.g_old_rec.aat_information15, hr_api.g_varchar2) <>
217: nvl(p_rec.aat_information15, hr_api.g_varchar2) or
218: nvl(pqp_aat_shd.g_old_rec.aat_information16, hr_api.g_varchar2) <>
219: nvl(p_rec.aat_information16, hr_api.g_varchar2) or
220: nvl(pqp_aat_shd.g_old_rec.aat_information17, hr_api.g_varchar2) <>
221: nvl(p_rec.aat_information17, hr_api.g_varchar2) or
222: nvl(pqp_aat_shd.g_old_rec.aat_information18, hr_api.g_varchar2) <>
216: nvl(pqp_aat_shd.g_old_rec.aat_information15, hr_api.g_varchar2) <>
217: nvl(p_rec.aat_information15, hr_api.g_varchar2) or
218: nvl(pqp_aat_shd.g_old_rec.aat_information16, hr_api.g_varchar2) <>
219: nvl(p_rec.aat_information16, hr_api.g_varchar2) or
220: nvl(pqp_aat_shd.g_old_rec.aat_information17, hr_api.g_varchar2) <>
221: nvl(p_rec.aat_information17, hr_api.g_varchar2) or
222: nvl(pqp_aat_shd.g_old_rec.aat_information18, hr_api.g_varchar2) <>
223: nvl(p_rec.aat_information18, hr_api.g_varchar2) or
224: nvl(pqp_aat_shd.g_old_rec.aat_information19, hr_api.g_varchar2) <>
218: nvl(pqp_aat_shd.g_old_rec.aat_information16, hr_api.g_varchar2) <>
219: nvl(p_rec.aat_information16, hr_api.g_varchar2) or
220: nvl(pqp_aat_shd.g_old_rec.aat_information17, hr_api.g_varchar2) <>
221: nvl(p_rec.aat_information17, hr_api.g_varchar2) or
222: nvl(pqp_aat_shd.g_old_rec.aat_information18, hr_api.g_varchar2) <>
223: nvl(p_rec.aat_information18, hr_api.g_varchar2) or
224: nvl(pqp_aat_shd.g_old_rec.aat_information19, hr_api.g_varchar2) <>
225: nvl(p_rec.aat_information19, hr_api.g_varchar2) or
226: nvl(pqp_aat_shd.g_old_rec.aat_information20, hr_api.g_varchar2) <>
220: nvl(pqp_aat_shd.g_old_rec.aat_information17, hr_api.g_varchar2) <>
221: nvl(p_rec.aat_information17, hr_api.g_varchar2) or
222: nvl(pqp_aat_shd.g_old_rec.aat_information18, hr_api.g_varchar2) <>
223: nvl(p_rec.aat_information18, hr_api.g_varchar2) or
224: nvl(pqp_aat_shd.g_old_rec.aat_information19, hr_api.g_varchar2) <>
225: nvl(p_rec.aat_information19, hr_api.g_varchar2) or
226: nvl(pqp_aat_shd.g_old_rec.aat_information20, hr_api.g_varchar2) <>
227: nvl(p_rec.aat_information20, hr_api.g_varchar2) ))
228: or (p_rec.assignment_attribute_id is null) then
222: nvl(pqp_aat_shd.g_old_rec.aat_information18, hr_api.g_varchar2) <>
223: nvl(p_rec.aat_information18, hr_api.g_varchar2) or
224: nvl(pqp_aat_shd.g_old_rec.aat_information19, hr_api.g_varchar2) <>
225: nvl(p_rec.aat_information19, hr_api.g_varchar2) or
226: nvl(pqp_aat_shd.g_old_rec.aat_information20, hr_api.g_varchar2) <>
227: nvl(p_rec.aat_information20, hr_api.g_varchar2) ))
228: or (p_rec.assignment_attribute_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_aat_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.assignment_attribute_id is not null) and (
323: nvl(pqp_aat_shd.g_old_rec.assignment_attribute_id, hr_api.g_number) <>
324: nvl(p_rec.assignment_attribute_id, hr_api.g_number) or
325: nvl(pqp_aat_shd.g_old_rec.aat_attribute_category, hr_api.g_varchar2) <>
326: nvl(p_rec.aat_attribute_category, hr_api.g_varchar2) or
327: nvl(pqp_aat_shd.g_old_rec.aat_attribute1, hr_api.g_varchar2) <>
321: --
322: if ((p_rec.assignment_attribute_id is not null) and (
323: nvl(pqp_aat_shd.g_old_rec.assignment_attribute_id, hr_api.g_number) <>
324: nvl(p_rec.assignment_attribute_id, hr_api.g_number) or
325: nvl(pqp_aat_shd.g_old_rec.aat_attribute_category, hr_api.g_varchar2) <>
326: nvl(p_rec.aat_attribute_category, hr_api.g_varchar2) or
327: nvl(pqp_aat_shd.g_old_rec.aat_attribute1, hr_api.g_varchar2) <>
328: nvl(p_rec.aat_attribute1, hr_api.g_varchar2) or
329: nvl(pqp_aat_shd.g_old_rec.aat_attribute2, hr_api.g_varchar2) <>
323: nvl(pqp_aat_shd.g_old_rec.assignment_attribute_id, hr_api.g_number) <>
324: nvl(p_rec.assignment_attribute_id, hr_api.g_number) or
325: nvl(pqp_aat_shd.g_old_rec.aat_attribute_category, hr_api.g_varchar2) <>
326: nvl(p_rec.aat_attribute_category, hr_api.g_varchar2) or
327: nvl(pqp_aat_shd.g_old_rec.aat_attribute1, hr_api.g_varchar2) <>
328: nvl(p_rec.aat_attribute1, hr_api.g_varchar2) or
329: nvl(pqp_aat_shd.g_old_rec.aat_attribute2, hr_api.g_varchar2) <>
330: nvl(p_rec.aat_attribute2, hr_api.g_varchar2) or
331: nvl(pqp_aat_shd.g_old_rec.aat_attribute3, hr_api.g_varchar2) <>
325: nvl(pqp_aat_shd.g_old_rec.aat_attribute_category, hr_api.g_varchar2) <>
326: nvl(p_rec.aat_attribute_category, hr_api.g_varchar2) or
327: nvl(pqp_aat_shd.g_old_rec.aat_attribute1, hr_api.g_varchar2) <>
328: nvl(p_rec.aat_attribute1, hr_api.g_varchar2) or
329: nvl(pqp_aat_shd.g_old_rec.aat_attribute2, hr_api.g_varchar2) <>
330: nvl(p_rec.aat_attribute2, hr_api.g_varchar2) or
331: nvl(pqp_aat_shd.g_old_rec.aat_attribute3, hr_api.g_varchar2) <>
332: nvl(p_rec.aat_attribute3, hr_api.g_varchar2) or
333: nvl(pqp_aat_shd.g_old_rec.aat_attribute4, hr_api.g_varchar2) <>
327: nvl(pqp_aat_shd.g_old_rec.aat_attribute1, hr_api.g_varchar2) <>
328: nvl(p_rec.aat_attribute1, hr_api.g_varchar2) or
329: nvl(pqp_aat_shd.g_old_rec.aat_attribute2, hr_api.g_varchar2) <>
330: nvl(p_rec.aat_attribute2, hr_api.g_varchar2) or
331: nvl(pqp_aat_shd.g_old_rec.aat_attribute3, hr_api.g_varchar2) <>
332: nvl(p_rec.aat_attribute3, hr_api.g_varchar2) or
333: nvl(pqp_aat_shd.g_old_rec.aat_attribute4, hr_api.g_varchar2) <>
334: nvl(p_rec.aat_attribute4, hr_api.g_varchar2) or
335: nvl(pqp_aat_shd.g_old_rec.aat_attribute5, hr_api.g_varchar2) <>
329: nvl(pqp_aat_shd.g_old_rec.aat_attribute2, hr_api.g_varchar2) <>
330: nvl(p_rec.aat_attribute2, hr_api.g_varchar2) or
331: nvl(pqp_aat_shd.g_old_rec.aat_attribute3, hr_api.g_varchar2) <>
332: nvl(p_rec.aat_attribute3, hr_api.g_varchar2) or
333: nvl(pqp_aat_shd.g_old_rec.aat_attribute4, hr_api.g_varchar2) <>
334: nvl(p_rec.aat_attribute4, hr_api.g_varchar2) or
335: nvl(pqp_aat_shd.g_old_rec.aat_attribute5, hr_api.g_varchar2) <>
336: nvl(p_rec.aat_attribute5, hr_api.g_varchar2) or
337: nvl(pqp_aat_shd.g_old_rec.aat_attribute6, hr_api.g_varchar2) <>
331: nvl(pqp_aat_shd.g_old_rec.aat_attribute3, hr_api.g_varchar2) <>
332: nvl(p_rec.aat_attribute3, hr_api.g_varchar2) or
333: nvl(pqp_aat_shd.g_old_rec.aat_attribute4, hr_api.g_varchar2) <>
334: nvl(p_rec.aat_attribute4, hr_api.g_varchar2) or
335: nvl(pqp_aat_shd.g_old_rec.aat_attribute5, hr_api.g_varchar2) <>
336: nvl(p_rec.aat_attribute5, hr_api.g_varchar2) or
337: nvl(pqp_aat_shd.g_old_rec.aat_attribute6, hr_api.g_varchar2) <>
338: nvl(p_rec.aat_attribute6, hr_api.g_varchar2) or
339: nvl(pqp_aat_shd.g_old_rec.aat_attribute7, hr_api.g_varchar2) <>
333: nvl(pqp_aat_shd.g_old_rec.aat_attribute4, hr_api.g_varchar2) <>
334: nvl(p_rec.aat_attribute4, hr_api.g_varchar2) or
335: nvl(pqp_aat_shd.g_old_rec.aat_attribute5, hr_api.g_varchar2) <>
336: nvl(p_rec.aat_attribute5, hr_api.g_varchar2) or
337: nvl(pqp_aat_shd.g_old_rec.aat_attribute6, hr_api.g_varchar2) <>
338: nvl(p_rec.aat_attribute6, hr_api.g_varchar2) or
339: nvl(pqp_aat_shd.g_old_rec.aat_attribute7, hr_api.g_varchar2) <>
340: nvl(p_rec.aat_attribute7, hr_api.g_varchar2) or
341: nvl(pqp_aat_shd.g_old_rec.aat_attribute8, hr_api.g_varchar2) <>
335: nvl(pqp_aat_shd.g_old_rec.aat_attribute5, hr_api.g_varchar2) <>
336: nvl(p_rec.aat_attribute5, hr_api.g_varchar2) or
337: nvl(pqp_aat_shd.g_old_rec.aat_attribute6, hr_api.g_varchar2) <>
338: nvl(p_rec.aat_attribute6, hr_api.g_varchar2) or
339: nvl(pqp_aat_shd.g_old_rec.aat_attribute7, hr_api.g_varchar2) <>
340: nvl(p_rec.aat_attribute7, hr_api.g_varchar2) or
341: nvl(pqp_aat_shd.g_old_rec.aat_attribute8, hr_api.g_varchar2) <>
342: nvl(p_rec.aat_attribute8, hr_api.g_varchar2) or
343: nvl(pqp_aat_shd.g_old_rec.aat_attribute9, hr_api.g_varchar2) <>
337: nvl(pqp_aat_shd.g_old_rec.aat_attribute6, hr_api.g_varchar2) <>
338: nvl(p_rec.aat_attribute6, hr_api.g_varchar2) or
339: nvl(pqp_aat_shd.g_old_rec.aat_attribute7, hr_api.g_varchar2) <>
340: nvl(p_rec.aat_attribute7, hr_api.g_varchar2) or
341: nvl(pqp_aat_shd.g_old_rec.aat_attribute8, hr_api.g_varchar2) <>
342: nvl(p_rec.aat_attribute8, hr_api.g_varchar2) or
343: nvl(pqp_aat_shd.g_old_rec.aat_attribute9, hr_api.g_varchar2) <>
344: nvl(p_rec.aat_attribute9, hr_api.g_varchar2) or
345: nvl(pqp_aat_shd.g_old_rec.aat_attribute10, hr_api.g_varchar2) <>
339: nvl(pqp_aat_shd.g_old_rec.aat_attribute7, hr_api.g_varchar2) <>
340: nvl(p_rec.aat_attribute7, hr_api.g_varchar2) or
341: nvl(pqp_aat_shd.g_old_rec.aat_attribute8, hr_api.g_varchar2) <>
342: nvl(p_rec.aat_attribute8, hr_api.g_varchar2) or
343: nvl(pqp_aat_shd.g_old_rec.aat_attribute9, hr_api.g_varchar2) <>
344: nvl(p_rec.aat_attribute9, hr_api.g_varchar2) or
345: nvl(pqp_aat_shd.g_old_rec.aat_attribute10, hr_api.g_varchar2) <>
346: nvl(p_rec.aat_attribute10, hr_api.g_varchar2) or
347: nvl(pqp_aat_shd.g_old_rec.aat_attribute11, hr_api.g_varchar2) <>
341: nvl(pqp_aat_shd.g_old_rec.aat_attribute8, hr_api.g_varchar2) <>
342: nvl(p_rec.aat_attribute8, hr_api.g_varchar2) or
343: nvl(pqp_aat_shd.g_old_rec.aat_attribute9, hr_api.g_varchar2) <>
344: nvl(p_rec.aat_attribute9, hr_api.g_varchar2) or
345: nvl(pqp_aat_shd.g_old_rec.aat_attribute10, hr_api.g_varchar2) <>
346: nvl(p_rec.aat_attribute10, hr_api.g_varchar2) or
347: nvl(pqp_aat_shd.g_old_rec.aat_attribute11, hr_api.g_varchar2) <>
348: nvl(p_rec.aat_attribute11, hr_api.g_varchar2) or
349: nvl(pqp_aat_shd.g_old_rec.aat_attribute12, hr_api.g_varchar2) <>
343: nvl(pqp_aat_shd.g_old_rec.aat_attribute9, hr_api.g_varchar2) <>
344: nvl(p_rec.aat_attribute9, hr_api.g_varchar2) or
345: nvl(pqp_aat_shd.g_old_rec.aat_attribute10, hr_api.g_varchar2) <>
346: nvl(p_rec.aat_attribute10, hr_api.g_varchar2) or
347: nvl(pqp_aat_shd.g_old_rec.aat_attribute11, hr_api.g_varchar2) <>
348: nvl(p_rec.aat_attribute11, hr_api.g_varchar2) or
349: nvl(pqp_aat_shd.g_old_rec.aat_attribute12, hr_api.g_varchar2) <>
350: nvl(p_rec.aat_attribute12, hr_api.g_varchar2) or
351: nvl(pqp_aat_shd.g_old_rec.aat_attribute13, hr_api.g_varchar2) <>
345: nvl(pqp_aat_shd.g_old_rec.aat_attribute10, hr_api.g_varchar2) <>
346: nvl(p_rec.aat_attribute10, hr_api.g_varchar2) or
347: nvl(pqp_aat_shd.g_old_rec.aat_attribute11, hr_api.g_varchar2) <>
348: nvl(p_rec.aat_attribute11, hr_api.g_varchar2) or
349: nvl(pqp_aat_shd.g_old_rec.aat_attribute12, hr_api.g_varchar2) <>
350: nvl(p_rec.aat_attribute12, hr_api.g_varchar2) or
351: nvl(pqp_aat_shd.g_old_rec.aat_attribute13, hr_api.g_varchar2) <>
352: nvl(p_rec.aat_attribute13, hr_api.g_varchar2) or
353: nvl(pqp_aat_shd.g_old_rec.aat_attribute14, hr_api.g_varchar2) <>
347: nvl(pqp_aat_shd.g_old_rec.aat_attribute11, hr_api.g_varchar2) <>
348: nvl(p_rec.aat_attribute11, hr_api.g_varchar2) or
349: nvl(pqp_aat_shd.g_old_rec.aat_attribute12, hr_api.g_varchar2) <>
350: nvl(p_rec.aat_attribute12, hr_api.g_varchar2) or
351: nvl(pqp_aat_shd.g_old_rec.aat_attribute13, hr_api.g_varchar2) <>
352: nvl(p_rec.aat_attribute13, hr_api.g_varchar2) or
353: nvl(pqp_aat_shd.g_old_rec.aat_attribute14, hr_api.g_varchar2) <>
354: nvl(p_rec.aat_attribute14, hr_api.g_varchar2) or
355: nvl(pqp_aat_shd.g_old_rec.aat_attribute15, hr_api.g_varchar2) <>
349: nvl(pqp_aat_shd.g_old_rec.aat_attribute12, hr_api.g_varchar2) <>
350: nvl(p_rec.aat_attribute12, hr_api.g_varchar2) or
351: nvl(pqp_aat_shd.g_old_rec.aat_attribute13, hr_api.g_varchar2) <>
352: nvl(p_rec.aat_attribute13, hr_api.g_varchar2) or
353: nvl(pqp_aat_shd.g_old_rec.aat_attribute14, hr_api.g_varchar2) <>
354: nvl(p_rec.aat_attribute14, hr_api.g_varchar2) or
355: nvl(pqp_aat_shd.g_old_rec.aat_attribute15, hr_api.g_varchar2) <>
356: nvl(p_rec.aat_attribute15, hr_api.g_varchar2) or
357: nvl(pqp_aat_shd.g_old_rec.aat_attribute16, hr_api.g_varchar2) <>
351: nvl(pqp_aat_shd.g_old_rec.aat_attribute13, hr_api.g_varchar2) <>
352: nvl(p_rec.aat_attribute13, hr_api.g_varchar2) or
353: nvl(pqp_aat_shd.g_old_rec.aat_attribute14, hr_api.g_varchar2) <>
354: nvl(p_rec.aat_attribute14, hr_api.g_varchar2) or
355: nvl(pqp_aat_shd.g_old_rec.aat_attribute15, hr_api.g_varchar2) <>
356: nvl(p_rec.aat_attribute15, hr_api.g_varchar2) or
357: nvl(pqp_aat_shd.g_old_rec.aat_attribute16, hr_api.g_varchar2) <>
358: nvl(p_rec.aat_attribute16, hr_api.g_varchar2) or
359: nvl(pqp_aat_shd.g_old_rec.aat_attribute17, hr_api.g_varchar2) <>
353: nvl(pqp_aat_shd.g_old_rec.aat_attribute14, hr_api.g_varchar2) <>
354: nvl(p_rec.aat_attribute14, hr_api.g_varchar2) or
355: nvl(pqp_aat_shd.g_old_rec.aat_attribute15, hr_api.g_varchar2) <>
356: nvl(p_rec.aat_attribute15, hr_api.g_varchar2) or
357: nvl(pqp_aat_shd.g_old_rec.aat_attribute16, hr_api.g_varchar2) <>
358: nvl(p_rec.aat_attribute16, hr_api.g_varchar2) or
359: nvl(pqp_aat_shd.g_old_rec.aat_attribute17, hr_api.g_varchar2) <>
360: nvl(p_rec.aat_attribute17, hr_api.g_varchar2) or
361: nvl(pqp_aat_shd.g_old_rec.aat_attribute18, hr_api.g_varchar2) <>
355: nvl(pqp_aat_shd.g_old_rec.aat_attribute15, hr_api.g_varchar2) <>
356: nvl(p_rec.aat_attribute15, hr_api.g_varchar2) or
357: nvl(pqp_aat_shd.g_old_rec.aat_attribute16, hr_api.g_varchar2) <>
358: nvl(p_rec.aat_attribute16, hr_api.g_varchar2) or
359: nvl(pqp_aat_shd.g_old_rec.aat_attribute17, hr_api.g_varchar2) <>
360: nvl(p_rec.aat_attribute17, hr_api.g_varchar2) or
361: nvl(pqp_aat_shd.g_old_rec.aat_attribute18, hr_api.g_varchar2) <>
362: nvl(p_rec.aat_attribute18, hr_api.g_varchar2) or
363: nvl(pqp_aat_shd.g_old_rec.aat_attribute19, hr_api.g_varchar2) <>
357: nvl(pqp_aat_shd.g_old_rec.aat_attribute16, hr_api.g_varchar2) <>
358: nvl(p_rec.aat_attribute16, hr_api.g_varchar2) or
359: nvl(pqp_aat_shd.g_old_rec.aat_attribute17, hr_api.g_varchar2) <>
360: nvl(p_rec.aat_attribute17, hr_api.g_varchar2) or
361: nvl(pqp_aat_shd.g_old_rec.aat_attribute18, hr_api.g_varchar2) <>
362: nvl(p_rec.aat_attribute18, hr_api.g_varchar2) or
363: nvl(pqp_aat_shd.g_old_rec.aat_attribute19, hr_api.g_varchar2) <>
364: nvl(p_rec.aat_attribute19, hr_api.g_varchar2) or
365: nvl(pqp_aat_shd.g_old_rec.aat_attribute20, hr_api.g_varchar2) <>
359: nvl(pqp_aat_shd.g_old_rec.aat_attribute17, hr_api.g_varchar2) <>
360: nvl(p_rec.aat_attribute17, hr_api.g_varchar2) or
361: nvl(pqp_aat_shd.g_old_rec.aat_attribute18, hr_api.g_varchar2) <>
362: nvl(p_rec.aat_attribute18, hr_api.g_varchar2) or
363: nvl(pqp_aat_shd.g_old_rec.aat_attribute19, hr_api.g_varchar2) <>
364: nvl(p_rec.aat_attribute19, hr_api.g_varchar2) or
365: nvl(pqp_aat_shd.g_old_rec.aat_attribute20, hr_api.g_varchar2) <>
366: nvl(p_rec.aat_attribute20, hr_api.g_varchar2) ))
367: or (p_rec.assignment_attribute_id is null) then
361: nvl(pqp_aat_shd.g_old_rec.aat_attribute18, hr_api.g_varchar2) <>
362: nvl(p_rec.aat_attribute18, hr_api.g_varchar2) or
363: nvl(pqp_aat_shd.g_old_rec.aat_attribute19, hr_api.g_varchar2) <>
364: nvl(p_rec.aat_attribute19, hr_api.g_varchar2) or
365: nvl(pqp_aat_shd.g_old_rec.aat_attribute20, hr_api.g_varchar2) <>
366: nvl(p_rec.aat_attribute20, hr_api.g_varchar2) ))
367: or (p_rec.assignment_attribute_id is null) then
368: --
369: -- Only execute the validation if absolutely necessary:
449: -- {End Of Comments}
450: -- ---------------------------------------------------------------------------+
451: Procedure chk_non_updateable_args
452: (p_effective_date in date
453: ,p_rec in pqp_aat_shd.g_rec_type
454: ) IS
455: --
456: l_proc varchar2(72) := g_package || 'chk_non_updateable_args';
457: l_error EXCEPTION;
461: --
462: -- Only proceed with the validation if a row exists for the current
463: -- record in the HR Schema.
464: --
465: IF NOT pqp_aat_shd.api_updating
466: (p_assignment_attribute_id => p_rec.assignment_attribute_id
467: ,p_effective_date => p_effective_date
468: ,p_object_version_number => p_rec.object_version_number
469: ) THEN
825: --
826: hr_utility.set_location(' Entering: '|| l_proc, 10);
827:
828: if (((p_assignment_attribute_id is not null) and
829: nvl(pqp_aat_shd.g_old_rec.tp_is_teacher,
830: hr_api.g_varchar2) <> nvl(p_tp_is_teacher,
831: hr_api.g_varchar2))
832: or
833: (p_assignment_attribute_id is null)) then
893: --
894: hr_utility.set_location(' Entering: '|| l_proc, 10);
895:
896: if (((p_assignment_attribute_id is not null) and
897: nvl(pqp_aat_shd.g_old_rec.tp_is_teacher,
898: hr_api.g_varchar2) <> nvl(p_tp_is_teacher,
899: hr_api.g_varchar2))
900: or
901: (p_assignment_attribute_id is null)) then
959: --
960: hr_utility.set_location(' Entering: '|| l_proc, 10);
961:
962: if (((p_assignment_attribute_id is not null) and
963: nvl(pqp_aat_shd.g_old_rec.tp_elected_pension,
964: hr_api.g_varchar2) <> nvl(p_tp_elected_pension,
965: hr_api.g_varchar2))
966: or
967: (p_assignment_attribute_id is null)) then
1053: --
1054: hr_utility.set_location(' Entering: '|| l_proc, 10);
1055:
1056: if (((p_assignment_attribute_id is not null) and
1057: nvl(pqp_aat_shd.g_old_rec.tp_safeguarded_grade,
1058: hr_api.g_varchar2) <> nvl(p_tp_safeguarded_grade,
1059: hr_api.g_varchar2))
1060: or
1061: (p_assignment_attribute_id is null)) then
1206: -- 2
1207:
1208: if l_TCHR_TTR6_History then
1209: -- 3
1210: pqp_aat_shd.constraint_error
1211: (p_constraint_name => 'PQP_INVALID_JOB_STATUS');
1212: end if; -- 3
1213:
1214: if l_TTR6_Future then
1212: end if; -- 3
1213:
1214: if l_TTR6_Future then
1215: -- 4
1216: pqp_aat_shd.constraint_error
1217: (p_constraint_name => 'PQP_INVALID_JOB_STATUS');
1218: end if; -- 4
1219: --
1220: end if; -- 2
1224: if p_old_job_status = 'NONT' and p_new_job_status = 'TCHR' then
1225: -- 5
1226: if l_TTR6_Future then
1227: -- 6
1228: pqp_aat_shd.constraint_error
1229: (p_constraint_name => 'PQP_INVALID_JOB_STATUS');
1230: end if; -- 6
1231:
1232: end if; -- 5
1242: p_datetrack_mode = hr_api.g_update_change_insert) then
1243: -- 7
1244: if p_old_job_status = 'TCHR' and p_new_job_status = 'TTR6' then
1245: -- 8
1246: pqp_aat_shd.constraint_error
1247: (p_constraint_name => 'PQP_INVALID_JOB_STATUS');
1248: end if; -- 8
1249:
1250: end if; -- 7
1260: -- 12
1261:
1262: if l_TTR6_Future then
1263: -- 13
1264: pqp_aat_shd.constraint_error
1265: (p_constraint_name => 'PQP_INVALID_JOB_STATUS');
1266: end if; -- 13
1267:
1268: /* For old = 'NONT' and new = 'TTR6'
1268: /* For old = 'NONT' and new = 'TTR6'
1269: Rules Handled : 4(remaining part) Refer design doc for rules table */
1270: if p_new_job_status = 'TTR6' and l_TCHR_TTR6_History then
1271: -- 14
1272: pqp_aat_shd.constraint_error
1273: (p_constraint_name => 'PQP_INVALID_JOB_STATUS');
1274: end if; -- 14
1275:
1276: end if; -- 12
1404: hr_utility.set_location(' Entering: '|| l_proc, 10);
1405:
1406:
1407: if (((p_assignment_attribute_id is not null) and
1408: (nvl(pqp_aat_shd.g_old_rec.tp_safeguarded_rate_type,hr_api.g_varchar2)
1409: <> nvl(p_tp_safeguarded_rate_type,hr_api.g_varchar2)
1410: )
1411: or
1412: (nvl(pqp_aat_shd.g_old_rec.tp_safeguarded_rate_id,hr_api.g_number)
1408: (nvl(pqp_aat_shd.g_old_rec.tp_safeguarded_rate_type,hr_api.g_varchar2)
1409: <> nvl(p_tp_safeguarded_rate_type,hr_api.g_varchar2)
1410: )
1411: or
1412: (nvl(pqp_aat_shd.g_old_rec.tp_safeguarded_rate_id,hr_api.g_number)
1413: <> nvl(p_tp_safeguarded_rate_id,hr_api.g_number)
1414: )
1415: or
1416: (nvl(pqp_aat_shd.g_old_rec.tp_safeguarded_grade,hr_api.g_varchar2)
1412: (nvl(pqp_aat_shd.g_old_rec.tp_safeguarded_rate_id,hr_api.g_number)
1413: <> nvl(p_tp_safeguarded_rate_id,hr_api.g_number)
1414: )
1415: or
1416: (nvl(pqp_aat_shd.g_old_rec.tp_safeguarded_grade,hr_api.g_varchar2)
1417: <> nvl(p_tp_safeguarded_grade,hr_api.g_varchar2)
1418: )
1419: )
1420: or
1530: --
1531: hr_utility.set_location(' Entering: '|| l_proc, 10);
1532:
1533: if (((p_assignment_attribute_id is not null) and
1534: nvl(pqp_aat_shd.g_old_rec.tp_safeguarded_spinal_point_id,hr_api.g_number)
1535: <> nvl(p_tp_spinal_point_id,hr_api.g_number))
1536: or
1537: (p_assignment_attribute_id is null)
1538: ) then
1637: hr_utility.set_location(' Entering: '|| l_proc, 10);
1638:
1639: if (((p_assignment_attribute_id is not null)
1640: and
1641: (nvl(pqp_aat_shd.g_old_rec.tp_safeguarded_spinal_point_id,hr_api.g_number)
1642: <> nvl(p_tp_spinal_point_id,hr_api.g_number)
1643: or
1644: nvl(pqp_aat_shd.g_old_rec.tp_safeguarded_rate_id,hr_api.g_number)
1645: <> nvl(p_tp_safeguarded_rate_id,hr_api.g_number)
1640: and
1641: (nvl(pqp_aat_shd.g_old_rec.tp_safeguarded_spinal_point_id,hr_api.g_number)
1642: <> nvl(p_tp_spinal_point_id,hr_api.g_number)
1643: or
1644: nvl(pqp_aat_shd.g_old_rec.tp_safeguarded_rate_id,hr_api.g_number)
1645: <> nvl(p_tp_safeguarded_rate_id,hr_api.g_number)
1646: or
1647: nvl(pqp_aat_shd.g_old_rec.tp_safeguarded_rate_type,hr_api.g_varchar2)
1648: <> nvl(p_tp_safeguarded_rate_type,hr_api.g_varchar2)
1643: or
1644: nvl(pqp_aat_shd.g_old_rec.tp_safeguarded_rate_id,hr_api.g_number)
1645: <> nvl(p_tp_safeguarded_rate_id,hr_api.g_number)
1646: or
1647: nvl(pqp_aat_shd.g_old_rec.tp_safeguarded_rate_type,hr_api.g_varchar2)
1648: <> nvl(p_tp_safeguarded_rate_type,hr_api.g_varchar2)
1649: or
1650: nvl(pqp_aat_shd.g_old_rec.tp_safeguarded_grade,hr_api.g_varchar2)
1651: <> nvl(p_tp_safeguarded_grade,hr_api.g_varchar2)
1646: or
1647: nvl(pqp_aat_shd.g_old_rec.tp_safeguarded_rate_type,hr_api.g_varchar2)
1648: <> nvl(p_tp_safeguarded_rate_type,hr_api.g_varchar2)
1649: or
1650: nvl(pqp_aat_shd.g_old_rec.tp_safeguarded_grade,hr_api.g_varchar2)
1651: <> nvl(p_tp_safeguarded_grade,hr_api.g_varchar2)
1652: )
1653: )
1654: or
1727: --
1728: hr_utility.set_location(' Entering: '|| l_proc, 10);
1729:
1730: if (((p_assignment_attribute_id is not null) and
1731: nvl(pqp_aat_shd.g_old_rec.tp_fast_track,
1732: hr_api.g_varchar2) <> nvl(p_tp_fast_track,
1733: hr_api.g_varchar2))
1734: or
1735: (p_assignment_attribute_id is null)) then
1957: -- ---------------------------------------------------------------------------+
1958: -- |---------------------------< insert_validate >----------------------------|
1959: -- ---------------------------------------------------------------------------+
1960: Procedure insert_validate
1961: (p_rec in pqp_aat_shd.g_rec_type
1962: ,p_effective_date in date
1963: ,p_datetrack_mode in varchar2
1964: ,p_validation_start_date in date
1965: ,p_validation_end_date in date
2150: -- ---------------------------------------------------------------------------+
2151: -- |---------------------------< update_validate >----------------------------|
2152: -- ---------------------------------------------------------------------------+
2153: Procedure update_validate
2154: (p_rec in pqp_aat_shd.g_rec_type
2155: ,p_effective_date in date
2156: ,p_datetrack_mode in varchar2
2157: ,p_validation_start_date in date
2158: ,p_validation_end_date in date
2284: --
2285:
2286: chk_job_status_change
2287: (p_new_job_status => p_rec.tp_is_teacher
2288: ,p_old_job_status => pqp_aat_shd.g_old_rec.tp_is_teacher
2289: ,p_assignment_id => p_rec.assignment_id
2290: ,p_effective_date => p_effective_date
2291: ,p_datetrack_mode => p_datetrack_mode
2292: );
2369: -- ---------------------------------------------------------------------------+
2370: -- |---------------------------< delete_validate >----------------------------|
2371: -- ---------------------------------------------------------------------------+
2372: Procedure delete_validate
2373: (p_rec in pqp_aat_shd.g_rec_type
2374: ,p_effective_date in date
2375: ,p_datetrack_mode in varchar2
2376: ,p_validation_start_date in date
2377: ,p_validation_end_date in date