178: -- Internal Row Handler Use Only.
179: --
180: -- ----------------------------------------------------------------------------
181: procedure chk_ddf
182: (p_rec in pay_etp_shd.g_rec_type
183: ) is
184: --
185: l_proc varchar2(72) := g_package || 'chk_ddf';
186: --
187: begin
188: hr_utility.set_location('Entering:'||l_proc,10);
189: --
190: if ((p_rec.element_type_id is not null) and
191: (nvl(pay_etp_shd.g_old_rec.element_information_category,
192: hr_api.g_varchar2) <>
193: nvl(p_rec.element_information_category, hr_api.g_varchar2) or
194: nvl(pay_etp_shd.g_old_rec.element_information1, hr_api.g_varchar2) <>
195: nvl(p_rec.element_information1, hr_api.g_varchar2) or
190: if ((p_rec.element_type_id is not null) and
191: (nvl(pay_etp_shd.g_old_rec.element_information_category,
192: hr_api.g_varchar2) <>
193: nvl(p_rec.element_information_category, hr_api.g_varchar2) or
194: nvl(pay_etp_shd.g_old_rec.element_information1, hr_api.g_varchar2) <>
195: nvl(p_rec.element_information1, hr_api.g_varchar2) or
196: nvl(pay_etp_shd.g_old_rec.element_information2, hr_api.g_varchar2) <>
197: nvl(p_rec.element_information2, hr_api.g_varchar2) or
198: nvl(pay_etp_shd.g_old_rec.element_information3, hr_api.g_varchar2) <>
192: hr_api.g_varchar2) <>
193: nvl(p_rec.element_information_category, hr_api.g_varchar2) or
194: nvl(pay_etp_shd.g_old_rec.element_information1, hr_api.g_varchar2) <>
195: nvl(p_rec.element_information1, hr_api.g_varchar2) or
196: nvl(pay_etp_shd.g_old_rec.element_information2, hr_api.g_varchar2) <>
197: nvl(p_rec.element_information2, hr_api.g_varchar2) or
198: nvl(pay_etp_shd.g_old_rec.element_information3, hr_api.g_varchar2) <>
199: nvl(p_rec.element_information3, hr_api.g_varchar2) or
200: nvl(pay_etp_shd.g_old_rec.element_information4, hr_api.g_varchar2) <>
194: nvl(pay_etp_shd.g_old_rec.element_information1, hr_api.g_varchar2) <>
195: nvl(p_rec.element_information1, hr_api.g_varchar2) or
196: nvl(pay_etp_shd.g_old_rec.element_information2, hr_api.g_varchar2) <>
197: nvl(p_rec.element_information2, hr_api.g_varchar2) or
198: nvl(pay_etp_shd.g_old_rec.element_information3, hr_api.g_varchar2) <>
199: nvl(p_rec.element_information3, hr_api.g_varchar2) or
200: nvl(pay_etp_shd.g_old_rec.element_information4, hr_api.g_varchar2) <>
201: nvl(p_rec.element_information4, hr_api.g_varchar2) or
202: nvl(pay_etp_shd.g_old_rec.element_information5, hr_api.g_varchar2) <>
196: nvl(pay_etp_shd.g_old_rec.element_information2, hr_api.g_varchar2) <>
197: nvl(p_rec.element_information2, hr_api.g_varchar2) or
198: nvl(pay_etp_shd.g_old_rec.element_information3, hr_api.g_varchar2) <>
199: nvl(p_rec.element_information3, hr_api.g_varchar2) or
200: nvl(pay_etp_shd.g_old_rec.element_information4, hr_api.g_varchar2) <>
201: nvl(p_rec.element_information4, hr_api.g_varchar2) or
202: nvl(pay_etp_shd.g_old_rec.element_information5, hr_api.g_varchar2) <>
203: nvl(p_rec.element_information5, hr_api.g_varchar2) or
204: nvl(pay_etp_shd.g_old_rec.element_information6, hr_api.g_varchar2) <>
198: nvl(pay_etp_shd.g_old_rec.element_information3, hr_api.g_varchar2) <>
199: nvl(p_rec.element_information3, hr_api.g_varchar2) or
200: nvl(pay_etp_shd.g_old_rec.element_information4, hr_api.g_varchar2) <>
201: nvl(p_rec.element_information4, hr_api.g_varchar2) or
202: nvl(pay_etp_shd.g_old_rec.element_information5, hr_api.g_varchar2) <>
203: nvl(p_rec.element_information5, hr_api.g_varchar2) or
204: nvl(pay_etp_shd.g_old_rec.element_information6, hr_api.g_varchar2) <>
205: nvl(p_rec.element_information6, hr_api.g_varchar2) or
206: nvl(pay_etp_shd.g_old_rec.element_information7, hr_api.g_varchar2) <>
200: nvl(pay_etp_shd.g_old_rec.element_information4, hr_api.g_varchar2) <>
201: nvl(p_rec.element_information4, hr_api.g_varchar2) or
202: nvl(pay_etp_shd.g_old_rec.element_information5, hr_api.g_varchar2) <>
203: nvl(p_rec.element_information5, hr_api.g_varchar2) or
204: nvl(pay_etp_shd.g_old_rec.element_information6, hr_api.g_varchar2) <>
205: nvl(p_rec.element_information6, hr_api.g_varchar2) or
206: nvl(pay_etp_shd.g_old_rec.element_information7, hr_api.g_varchar2) <>
207: nvl(p_rec.element_information7, hr_api.g_varchar2) or
208: nvl(pay_etp_shd.g_old_rec.element_information8, hr_api.g_varchar2) <>
202: nvl(pay_etp_shd.g_old_rec.element_information5, hr_api.g_varchar2) <>
203: nvl(p_rec.element_information5, hr_api.g_varchar2) or
204: nvl(pay_etp_shd.g_old_rec.element_information6, hr_api.g_varchar2) <>
205: nvl(p_rec.element_information6, hr_api.g_varchar2) or
206: nvl(pay_etp_shd.g_old_rec.element_information7, hr_api.g_varchar2) <>
207: nvl(p_rec.element_information7, hr_api.g_varchar2) or
208: nvl(pay_etp_shd.g_old_rec.element_information8, hr_api.g_varchar2) <>
209: nvl(p_rec.element_information8, hr_api.g_varchar2) or
210: nvl(pay_etp_shd.g_old_rec.element_information9, hr_api.g_varchar2) <>
204: nvl(pay_etp_shd.g_old_rec.element_information6, hr_api.g_varchar2) <>
205: nvl(p_rec.element_information6, hr_api.g_varchar2) or
206: nvl(pay_etp_shd.g_old_rec.element_information7, hr_api.g_varchar2) <>
207: nvl(p_rec.element_information7, hr_api.g_varchar2) or
208: nvl(pay_etp_shd.g_old_rec.element_information8, hr_api.g_varchar2) <>
209: nvl(p_rec.element_information8, hr_api.g_varchar2) or
210: nvl(pay_etp_shd.g_old_rec.element_information9, hr_api.g_varchar2) <>
211: nvl(p_rec.element_information9, hr_api.g_varchar2) or
212: nvl(pay_etp_shd.g_old_rec.element_information10, hr_api.g_varchar2) <>
206: nvl(pay_etp_shd.g_old_rec.element_information7, hr_api.g_varchar2) <>
207: nvl(p_rec.element_information7, hr_api.g_varchar2) or
208: nvl(pay_etp_shd.g_old_rec.element_information8, hr_api.g_varchar2) <>
209: nvl(p_rec.element_information8, hr_api.g_varchar2) or
210: nvl(pay_etp_shd.g_old_rec.element_information9, hr_api.g_varchar2) <>
211: nvl(p_rec.element_information9, hr_api.g_varchar2) or
212: nvl(pay_etp_shd.g_old_rec.element_information10, hr_api.g_varchar2) <>
213: nvl(p_rec.element_information10, hr_api.g_varchar2) or
214: nvl(pay_etp_shd.g_old_rec.element_information11, hr_api.g_varchar2) <>
208: nvl(pay_etp_shd.g_old_rec.element_information8, hr_api.g_varchar2) <>
209: nvl(p_rec.element_information8, hr_api.g_varchar2) or
210: nvl(pay_etp_shd.g_old_rec.element_information9, hr_api.g_varchar2) <>
211: nvl(p_rec.element_information9, hr_api.g_varchar2) or
212: nvl(pay_etp_shd.g_old_rec.element_information10, hr_api.g_varchar2) <>
213: nvl(p_rec.element_information10, hr_api.g_varchar2) or
214: nvl(pay_etp_shd.g_old_rec.element_information11, hr_api.g_varchar2) <>
215: nvl(p_rec.element_information11, hr_api.g_varchar2) or
216: nvl(pay_etp_shd.g_old_rec.element_information12, hr_api.g_varchar2) <>
210: nvl(pay_etp_shd.g_old_rec.element_information9, hr_api.g_varchar2) <>
211: nvl(p_rec.element_information9, hr_api.g_varchar2) or
212: nvl(pay_etp_shd.g_old_rec.element_information10, hr_api.g_varchar2) <>
213: nvl(p_rec.element_information10, hr_api.g_varchar2) or
214: nvl(pay_etp_shd.g_old_rec.element_information11, hr_api.g_varchar2) <>
215: nvl(p_rec.element_information11, hr_api.g_varchar2) or
216: nvl(pay_etp_shd.g_old_rec.element_information12, hr_api.g_varchar2) <>
217: nvl(p_rec.element_information12, hr_api.g_varchar2) or
218: nvl(pay_etp_shd.g_old_rec.element_information13, hr_api.g_varchar2) <>
212: nvl(pay_etp_shd.g_old_rec.element_information10, hr_api.g_varchar2) <>
213: nvl(p_rec.element_information10, hr_api.g_varchar2) or
214: nvl(pay_etp_shd.g_old_rec.element_information11, hr_api.g_varchar2) <>
215: nvl(p_rec.element_information11, hr_api.g_varchar2) or
216: nvl(pay_etp_shd.g_old_rec.element_information12, hr_api.g_varchar2) <>
217: nvl(p_rec.element_information12, hr_api.g_varchar2) or
218: nvl(pay_etp_shd.g_old_rec.element_information13, hr_api.g_varchar2) <>
219: nvl(p_rec.element_information13, hr_api.g_varchar2) or
220: nvl(pay_etp_shd.g_old_rec.element_information14, hr_api.g_varchar2) <>
214: nvl(pay_etp_shd.g_old_rec.element_information11, hr_api.g_varchar2) <>
215: nvl(p_rec.element_information11, hr_api.g_varchar2) or
216: nvl(pay_etp_shd.g_old_rec.element_information12, hr_api.g_varchar2) <>
217: nvl(p_rec.element_information12, hr_api.g_varchar2) or
218: nvl(pay_etp_shd.g_old_rec.element_information13, hr_api.g_varchar2) <>
219: nvl(p_rec.element_information13, hr_api.g_varchar2) or
220: nvl(pay_etp_shd.g_old_rec.element_information14, hr_api.g_varchar2) <>
221: nvl(p_rec.element_information14, hr_api.g_varchar2) or
222: nvl(pay_etp_shd.g_old_rec.element_information15, hr_api.g_varchar2) <>
216: nvl(pay_etp_shd.g_old_rec.element_information12, hr_api.g_varchar2) <>
217: nvl(p_rec.element_information12, hr_api.g_varchar2) or
218: nvl(pay_etp_shd.g_old_rec.element_information13, hr_api.g_varchar2) <>
219: nvl(p_rec.element_information13, hr_api.g_varchar2) or
220: nvl(pay_etp_shd.g_old_rec.element_information14, hr_api.g_varchar2) <>
221: nvl(p_rec.element_information14, hr_api.g_varchar2) or
222: nvl(pay_etp_shd.g_old_rec.element_information15, hr_api.g_varchar2) <>
223: nvl(p_rec.element_information15, hr_api.g_varchar2) or
224: nvl(pay_etp_shd.g_old_rec.element_information16, hr_api.g_varchar2) <>
218: nvl(pay_etp_shd.g_old_rec.element_information13, hr_api.g_varchar2) <>
219: nvl(p_rec.element_information13, hr_api.g_varchar2) or
220: nvl(pay_etp_shd.g_old_rec.element_information14, hr_api.g_varchar2) <>
221: nvl(p_rec.element_information14, hr_api.g_varchar2) or
222: nvl(pay_etp_shd.g_old_rec.element_information15, hr_api.g_varchar2) <>
223: nvl(p_rec.element_information15, hr_api.g_varchar2) or
224: nvl(pay_etp_shd.g_old_rec.element_information16, hr_api.g_varchar2) <>
225: nvl(p_rec.element_information16, hr_api.g_varchar2) or
226: nvl(pay_etp_shd.g_old_rec.element_information17, hr_api.g_varchar2) <>
220: nvl(pay_etp_shd.g_old_rec.element_information14, hr_api.g_varchar2) <>
221: nvl(p_rec.element_information14, hr_api.g_varchar2) or
222: nvl(pay_etp_shd.g_old_rec.element_information15, hr_api.g_varchar2) <>
223: nvl(p_rec.element_information15, hr_api.g_varchar2) or
224: nvl(pay_etp_shd.g_old_rec.element_information16, hr_api.g_varchar2) <>
225: nvl(p_rec.element_information16, hr_api.g_varchar2) or
226: nvl(pay_etp_shd.g_old_rec.element_information17, hr_api.g_varchar2) <>
227: nvl(p_rec.element_information17, hr_api.g_varchar2) or
228: nvl(pay_etp_shd.g_old_rec.element_information18, hr_api.g_varchar2) <>
222: nvl(pay_etp_shd.g_old_rec.element_information15, hr_api.g_varchar2) <>
223: nvl(p_rec.element_information15, hr_api.g_varchar2) or
224: nvl(pay_etp_shd.g_old_rec.element_information16, hr_api.g_varchar2) <>
225: nvl(p_rec.element_information16, hr_api.g_varchar2) or
226: nvl(pay_etp_shd.g_old_rec.element_information17, hr_api.g_varchar2) <>
227: nvl(p_rec.element_information17, hr_api.g_varchar2) or
228: nvl(pay_etp_shd.g_old_rec.element_information18, hr_api.g_varchar2) <>
229: nvl(p_rec.element_information18, hr_api.g_varchar2) or
230: nvl(pay_etp_shd.g_old_rec.element_information19, hr_api.g_varchar2) <>
224: nvl(pay_etp_shd.g_old_rec.element_information16, hr_api.g_varchar2) <>
225: nvl(p_rec.element_information16, hr_api.g_varchar2) or
226: nvl(pay_etp_shd.g_old_rec.element_information17, hr_api.g_varchar2) <>
227: nvl(p_rec.element_information17, hr_api.g_varchar2) or
228: nvl(pay_etp_shd.g_old_rec.element_information18, hr_api.g_varchar2) <>
229: nvl(p_rec.element_information18, hr_api.g_varchar2) or
230: nvl(pay_etp_shd.g_old_rec.element_information19, hr_api.g_varchar2) <>
231: nvl(p_rec.element_information19, hr_api.g_varchar2) or
232: nvl(pay_etp_shd.g_old_rec.element_information20, hr_api.g_varchar2) <>
226: nvl(pay_etp_shd.g_old_rec.element_information17, hr_api.g_varchar2) <>
227: nvl(p_rec.element_information17, hr_api.g_varchar2) or
228: nvl(pay_etp_shd.g_old_rec.element_information18, hr_api.g_varchar2) <>
229: nvl(p_rec.element_information18, hr_api.g_varchar2) or
230: nvl(pay_etp_shd.g_old_rec.element_information19, hr_api.g_varchar2) <>
231: nvl(p_rec.element_information19, hr_api.g_varchar2) or
232: nvl(pay_etp_shd.g_old_rec.element_information20, hr_api.g_varchar2) <>
233: nvl(p_rec.element_information20, hr_api.g_varchar2) ))
234: or (p_rec.element_type_id is null) then
228: nvl(pay_etp_shd.g_old_rec.element_information18, hr_api.g_varchar2) <>
229: nvl(p_rec.element_information18, hr_api.g_varchar2) or
230: nvl(pay_etp_shd.g_old_rec.element_information19, hr_api.g_varchar2) <>
231: nvl(p_rec.element_information19, hr_api.g_varchar2) or
232: nvl(pay_etp_shd.g_old_rec.element_information20, hr_api.g_varchar2) <>
233: nvl(p_rec.element_information20, hr_api.g_varchar2) ))
234: or (p_rec.element_type_id is null) then
235: --
236: -- Only execute the validation if absolutely necessary:
316: -- Internal Row Handler Use Only.
317: --
318: -- ----------------------------------------------------------------------------
319: procedure chk_df
320: (p_rec in pay_etp_shd.g_rec_type
321: ) is
322: --
323: l_proc varchar2(72) := g_package || 'chk_df';
324: --
325: begin
326: hr_utility.set_location('Entering:'||l_proc,10);
327: --
328: if ((p_rec.element_type_id is not null) and (
329: nvl(pay_etp_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
330: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
331: nvl(pay_etp_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
332: nvl(p_rec.attribute1, hr_api.g_varchar2) or
333: nvl(pay_etp_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
327: --
328: if ((p_rec.element_type_id is not null) and (
329: nvl(pay_etp_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
330: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
331: nvl(pay_etp_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
332: nvl(p_rec.attribute1, hr_api.g_varchar2) or
333: nvl(pay_etp_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
334: nvl(p_rec.attribute2, hr_api.g_varchar2) or
335: nvl(pay_etp_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
329: nvl(pay_etp_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
330: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
331: nvl(pay_etp_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
332: nvl(p_rec.attribute1, hr_api.g_varchar2) or
333: nvl(pay_etp_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
334: nvl(p_rec.attribute2, hr_api.g_varchar2) or
335: nvl(pay_etp_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
336: nvl(p_rec.attribute3, hr_api.g_varchar2) or
337: nvl(pay_etp_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
331: nvl(pay_etp_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
332: nvl(p_rec.attribute1, hr_api.g_varchar2) or
333: nvl(pay_etp_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
334: nvl(p_rec.attribute2, hr_api.g_varchar2) or
335: nvl(pay_etp_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
336: nvl(p_rec.attribute3, hr_api.g_varchar2) or
337: nvl(pay_etp_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
338: nvl(p_rec.attribute4, hr_api.g_varchar2) or
339: nvl(pay_etp_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
333: nvl(pay_etp_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
334: nvl(p_rec.attribute2, hr_api.g_varchar2) or
335: nvl(pay_etp_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
336: nvl(p_rec.attribute3, hr_api.g_varchar2) or
337: nvl(pay_etp_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
338: nvl(p_rec.attribute4, hr_api.g_varchar2) or
339: nvl(pay_etp_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
340: nvl(p_rec.attribute5, hr_api.g_varchar2) or
341: nvl(pay_etp_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
335: nvl(pay_etp_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
336: nvl(p_rec.attribute3, hr_api.g_varchar2) or
337: nvl(pay_etp_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
338: nvl(p_rec.attribute4, hr_api.g_varchar2) or
339: nvl(pay_etp_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
340: nvl(p_rec.attribute5, hr_api.g_varchar2) or
341: nvl(pay_etp_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
342: nvl(p_rec.attribute6, hr_api.g_varchar2) or
343: nvl(pay_etp_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
337: nvl(pay_etp_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
338: nvl(p_rec.attribute4, hr_api.g_varchar2) or
339: nvl(pay_etp_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
340: nvl(p_rec.attribute5, hr_api.g_varchar2) or
341: nvl(pay_etp_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
342: nvl(p_rec.attribute6, hr_api.g_varchar2) or
343: nvl(pay_etp_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
344: nvl(p_rec.attribute7, hr_api.g_varchar2) or
345: nvl(pay_etp_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
339: nvl(pay_etp_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
340: nvl(p_rec.attribute5, hr_api.g_varchar2) or
341: nvl(pay_etp_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
342: nvl(p_rec.attribute6, hr_api.g_varchar2) or
343: nvl(pay_etp_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
344: nvl(p_rec.attribute7, hr_api.g_varchar2) or
345: nvl(pay_etp_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
346: nvl(p_rec.attribute8, hr_api.g_varchar2) or
347: nvl(pay_etp_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
341: nvl(pay_etp_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
342: nvl(p_rec.attribute6, hr_api.g_varchar2) or
343: nvl(pay_etp_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
344: nvl(p_rec.attribute7, hr_api.g_varchar2) or
345: nvl(pay_etp_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
346: nvl(p_rec.attribute8, hr_api.g_varchar2) or
347: nvl(pay_etp_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
348: nvl(p_rec.attribute9, hr_api.g_varchar2) or
349: nvl(pay_etp_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
343: nvl(pay_etp_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
344: nvl(p_rec.attribute7, hr_api.g_varchar2) or
345: nvl(pay_etp_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
346: nvl(p_rec.attribute8, hr_api.g_varchar2) or
347: nvl(pay_etp_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
348: nvl(p_rec.attribute9, hr_api.g_varchar2) or
349: nvl(pay_etp_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
350: nvl(p_rec.attribute10, hr_api.g_varchar2) or
351: nvl(pay_etp_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
345: nvl(pay_etp_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
346: nvl(p_rec.attribute8, hr_api.g_varchar2) or
347: nvl(pay_etp_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
348: nvl(p_rec.attribute9, hr_api.g_varchar2) or
349: nvl(pay_etp_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
350: nvl(p_rec.attribute10, hr_api.g_varchar2) or
351: nvl(pay_etp_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
352: nvl(p_rec.attribute11, hr_api.g_varchar2) or
353: nvl(pay_etp_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
347: nvl(pay_etp_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
348: nvl(p_rec.attribute9, hr_api.g_varchar2) or
349: nvl(pay_etp_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
350: nvl(p_rec.attribute10, hr_api.g_varchar2) or
351: nvl(pay_etp_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
352: nvl(p_rec.attribute11, hr_api.g_varchar2) or
353: nvl(pay_etp_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
354: nvl(p_rec.attribute12, hr_api.g_varchar2) or
355: nvl(pay_etp_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
349: nvl(pay_etp_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
350: nvl(p_rec.attribute10, hr_api.g_varchar2) or
351: nvl(pay_etp_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
352: nvl(p_rec.attribute11, hr_api.g_varchar2) or
353: nvl(pay_etp_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
354: nvl(p_rec.attribute12, hr_api.g_varchar2) or
355: nvl(pay_etp_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
356: nvl(p_rec.attribute13, hr_api.g_varchar2) or
357: nvl(pay_etp_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
351: nvl(pay_etp_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
352: nvl(p_rec.attribute11, hr_api.g_varchar2) or
353: nvl(pay_etp_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
354: nvl(p_rec.attribute12, hr_api.g_varchar2) or
355: nvl(pay_etp_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
356: nvl(p_rec.attribute13, hr_api.g_varchar2) or
357: nvl(pay_etp_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
358: nvl(p_rec.attribute14, hr_api.g_varchar2) or
359: nvl(pay_etp_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
353: nvl(pay_etp_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
354: nvl(p_rec.attribute12, hr_api.g_varchar2) or
355: nvl(pay_etp_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
356: nvl(p_rec.attribute13, hr_api.g_varchar2) or
357: nvl(pay_etp_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
358: nvl(p_rec.attribute14, hr_api.g_varchar2) or
359: nvl(pay_etp_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
360: nvl(p_rec.attribute15, hr_api.g_varchar2) or
361: nvl(pay_etp_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
355: nvl(pay_etp_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
356: nvl(p_rec.attribute13, hr_api.g_varchar2) or
357: nvl(pay_etp_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
358: nvl(p_rec.attribute14, hr_api.g_varchar2) or
359: nvl(pay_etp_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
360: nvl(p_rec.attribute15, hr_api.g_varchar2) or
361: nvl(pay_etp_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
362: nvl(p_rec.attribute16, hr_api.g_varchar2) or
363: nvl(pay_etp_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
357: nvl(pay_etp_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
358: nvl(p_rec.attribute14, hr_api.g_varchar2) or
359: nvl(pay_etp_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
360: nvl(p_rec.attribute15, hr_api.g_varchar2) or
361: nvl(pay_etp_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
362: nvl(p_rec.attribute16, hr_api.g_varchar2) or
363: nvl(pay_etp_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
364: nvl(p_rec.attribute17, hr_api.g_varchar2) or
365: nvl(pay_etp_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
359: nvl(pay_etp_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
360: nvl(p_rec.attribute15, hr_api.g_varchar2) or
361: nvl(pay_etp_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
362: nvl(p_rec.attribute16, hr_api.g_varchar2) or
363: nvl(pay_etp_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
364: nvl(p_rec.attribute17, hr_api.g_varchar2) or
365: nvl(pay_etp_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
366: nvl(p_rec.attribute18, hr_api.g_varchar2) or
367: nvl(pay_etp_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
361: nvl(pay_etp_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
362: nvl(p_rec.attribute16, hr_api.g_varchar2) or
363: nvl(pay_etp_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
364: nvl(p_rec.attribute17, hr_api.g_varchar2) or
365: nvl(pay_etp_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
366: nvl(p_rec.attribute18, hr_api.g_varchar2) or
367: nvl(pay_etp_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
368: nvl(p_rec.attribute19, hr_api.g_varchar2) or
369: nvl(pay_etp_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
363: nvl(pay_etp_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
364: nvl(p_rec.attribute17, hr_api.g_varchar2) or
365: nvl(pay_etp_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
366: nvl(p_rec.attribute18, hr_api.g_varchar2) or
367: nvl(pay_etp_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
368: nvl(p_rec.attribute19, hr_api.g_varchar2) or
369: nvl(pay_etp_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
370: nvl(p_rec.attribute20, hr_api.g_varchar2) ))
371: or (p_rec.element_type_id is null) then
365: nvl(pay_etp_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
366: nvl(p_rec.attribute18, hr_api.g_varchar2) or
367: nvl(pay_etp_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
368: nvl(p_rec.attribute19, hr_api.g_varchar2) or
369: nvl(pay_etp_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
370: nvl(p_rec.attribute20, hr_api.g_varchar2) ))
371: or (p_rec.element_type_id is null) then
372: --
373: -- Only execute the validation if absolutely necessary:
453: -- {End Of Comments}
454: -- ----------------------------------------------------------------------------
455: Procedure chk_non_updateable_args
456: (p_effective_date in date
457: ,p_rec in pay_etp_shd.g_rec_type
458: ) IS
459: --
460: l_proc varchar2(72) := g_package || 'chk_non_updateable_args';
461: --
463: --
464: -- Only proceed with the validation if a row exists for the current
465: -- record in the HR Schema.
466: --
467: IF NOT pay_etp_shd.api_updating
468: (p_element_type_id => p_rec.element_type_id
469: ,p_effective_date => p_effective_date
470: ,p_object_version_number => p_rec.object_version_number
471: ) THEN
1465: --
1466: End If;
1467: If p_element_type_id is not null and
1468: (p_multiple_entries_allowed_flg <>
1469: pay_etp_shd.g_old_rec.multiple_entries_allowed_flag) Then
1470: --
1471: If pay_element_types_pkg.stop_entry_rules_exist
1472: (p_element_type_id
1473: ,p_validation_start_date
1675: If p_processing_priority not between l_high_priority and l_low_priority Then
1676: p_processing_priority_warning := True;
1677: End If;
1678: If p_element_type_id is not null and
1679: (p_processing_priority <> pay_etp_shd.g_old_rec.processing_priority) Then
1680: --
1681: If pay_element_types_pkg.priority_result_rule_violated
1682: (p_element_type_id,
1683: p_processing_priority,
1970: --
1971: End If;
1972: If p_element_type_id is not null and
1973: (p_third_party_pay_only_flag <>
1974: nvl(pay_etp_shd.g_old_rec.third_party_pay_only_flag,hr_api.g_varchar2))
1975: Then
1976: --
1977: If pay_element_types_pkg.element_entries_exist
1978: (p_element_type_id
2642: Begin
2643: hr_utility.set_location('Entering:'||l_proc, 5);
2644: --
2645: If (
2646: (p_indirect_only_flag <> pay_etp_shd.g_old_rec.indirect_only_flag)
2647: or
2648: (p_additional_entry_allowed_flg <>
2649: pay_etp_shd.g_old_rec.additional_entry_allowed_flag)
2650: or
2645: If (
2646: (p_indirect_only_flag <> pay_etp_shd.g_old_rec.indirect_only_flag)
2647: or
2648: (p_additional_entry_allowed_flg <>
2649: pay_etp_shd.g_old_rec.additional_entry_allowed_flag)
2650: or
2651: (p_standard_link_flag <> pay_etp_shd.g_old_rec.standard_link_flag)
2652: or
2653: (p_adjustment_only_flag <> pay_etp_shd.g_old_rec.adjustment_only_flag)
2647: or
2648: (p_additional_entry_allowed_flg <>
2649: pay_etp_shd.g_old_rec.additional_entry_allowed_flag)
2650: or
2651: (p_standard_link_flag <> pay_etp_shd.g_old_rec.standard_link_flag)
2652: or
2653: (p_adjustment_only_flag <> pay_etp_shd.g_old_rec.adjustment_only_flag)
2654: or
2655: (p_post_termination_rule <> pay_etp_shd.g_old_rec.post_termination_rule)
2649: pay_etp_shd.g_old_rec.additional_entry_allowed_flag)
2650: or
2651: (p_standard_link_flag <> pay_etp_shd.g_old_rec.standard_link_flag)
2652: or
2653: (p_adjustment_only_flag <> pay_etp_shd.g_old_rec.adjustment_only_flag)
2654: or
2655: (p_post_termination_rule <> pay_etp_shd.g_old_rec.post_termination_rule)
2656: or
2657: (p_process_in_run_flag <> pay_etp_shd.g_old_rec.process_in_run_flag)
2651: (p_standard_link_flag <> pay_etp_shd.g_old_rec.standard_link_flag)
2652: or
2653: (p_adjustment_only_flag <> pay_etp_shd.g_old_rec.adjustment_only_flag)
2654: or
2655: (p_post_termination_rule <> pay_etp_shd.g_old_rec.post_termination_rule)
2656: or
2657: (p_process_in_run_flag <> pay_etp_shd.g_old_rec.process_in_run_flag)
2658: or
2659: (p_once_each_period_flag <> pay_etp_shd.g_old_rec.once_each_period_flag)
2653: (p_adjustment_only_flag <> pay_etp_shd.g_old_rec.adjustment_only_flag)
2654: or
2655: (p_post_termination_rule <> pay_etp_shd.g_old_rec.post_termination_rule)
2656: or
2657: (p_process_in_run_flag <> pay_etp_shd.g_old_rec.process_in_run_flag)
2658: or
2659: (p_once_each_period_flag <> pay_etp_shd.g_old_rec.once_each_period_flag)
2660: ) Then
2661: --
2655: (p_post_termination_rule <> pay_etp_shd.g_old_rec.post_termination_rule)
2656: or
2657: (p_process_in_run_flag <> pay_etp_shd.g_old_rec.process_in_run_flag)
2658: or
2659: (p_once_each_period_flag <> pay_etp_shd.g_old_rec.once_each_period_flag)
2660: ) Then
2661: --
2662: l_element_links := pay_element_types_pkg.links_exist
2663: (p_element_type_id,
2669: fnd_message.set_name('PAY','PAY_6147_ELEMENT_LINK_UPDATE');
2670: fnd_message.raise_error;
2671: --
2672: End If;
2673: If (p_adjustment_only_flag <> pay_etp_shd.g_old_rec.adjustment_only_flag
2674: )Then
2675: --
2676: l_indirect_results := pay_element_types_pkg.fed_by_indirect_results
2677: (p_element_type_id,
2685: --
2686: End If;
2687: --
2688: End If;
2689: If ((p_post_termination_rule <> pay_etp_shd.g_old_rec.post_termination_rule)
2690: or
2691: (p_process_in_run_flag <> pay_etp_shd.g_old_rec.process_in_run_flag)
2692: or
2693: (p_once_each_period_flag <> pay_etp_shd.g_old_rec.once_each_period_flag)
2687: --
2688: End If;
2689: If ((p_post_termination_rule <> pay_etp_shd.g_old_rec.post_termination_rule)
2690: or
2691: (p_process_in_run_flag <> pay_etp_shd.g_old_rec.process_in_run_flag)
2692: or
2693: (p_once_each_period_flag <> pay_etp_shd.g_old_rec.once_each_period_flag)
2694: ) Then
2695: --
2689: If ((p_post_termination_rule <> pay_etp_shd.g_old_rec.post_termination_rule)
2690: or
2691: (p_process_in_run_flag <> pay_etp_shd.g_old_rec.process_in_run_flag)
2692: or
2693: (p_once_each_period_flag <> pay_etp_shd.g_old_rec.once_each_period_flag)
2694: ) Then
2695: --
2696: l_run_results:= pay_element_types_pkg.run_results_exist
2697: (p_element_type_id, p_validation_start_date, p_validation_end_date);
2953: -- ----------------------------------------------------------------------------
2954: -- |---------------------------< insert_validate >----------------------------|
2955: -- ----------------------------------------------------------------------------
2956: Procedure insert_validate
2957: (p_rec in pay_etp_shd.g_rec_type
2958: ,p_effective_date in date
2959: ,p_datetrack_mode in varchar2
2960: ,p_validation_start_date in date
2961: ,p_validation_end_date in date
2981: -- Validate Important Attributes
2982: --
2983: hr_api.validate_bus_grp_id
2984: (p_business_group_id => p_rec.business_group_id
2985: ,p_associated_column1 => pay_etp_shd.g_tab_nam
2986: || '.BUSINESS_GROUP_ID');
2987: --
2988: -- after validating the set of important attributes,
2989: -- if Multiple Message Detection is enabled and at least
3139: -- ----------------------------------------------------------------------------
3140: -- |---------------------------< update_validate >----------------------------|
3141: -- ----------------------------------------------------------------------------
3142: Procedure update_validate
3143: (p_rec in pay_etp_shd.g_rec_type
3144: ,p_effective_date in date
3145: ,p_datetrack_mode in varchar2
3146: ,p_validation_start_date in date
3147: ,p_validation_end_date in date
3167: -- Validate Important Attributes
3168: --
3169: hr_api.validate_bus_grp_id
3170: (p_business_group_id => p_rec.business_group_id
3171: ,p_associated_column1 => pay_etp_shd.g_tab_nam
3172: || '.BUSINESS_GROUP_ID');
3173: --
3174: -- After validating the set of important attributes,
3175: -- if Multiple Message Detection is enabled and at least
3341: -- ----------------------------------------------------------------------------
3342: -- |---------------------------< delete_validate >----------------------------|
3343: -- ----------------------------------------------------------------------------
3344: Procedure delete_validate
3345: (p_rec in pay_etp_shd.g_rec_type
3346: ,p_effective_date in date
3347: ,p_datetrack_mode in varchar2
3348: ,p_validation_start_date in date
3349: ,p_validation_end_date in date