178: -- Internal Row Handler Use Only.
179: --
180: -- ----------------------------------------------------------------------------
181: procedure chk_ddf
182: (p_rec in pay_etp_shd_nd.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_nd.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_nd.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_nd.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_nd.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_nd.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_nd.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_nd.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_nd.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_nd.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_nd.g_old_rec.element_information4, hr_api.g_varchar2) <>
194: nvl(pay_etp_shd_nd.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_nd.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_nd.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_nd.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_nd.g_old_rec.element_information5, hr_api.g_varchar2) <>
196: nvl(pay_etp_shd_nd.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_nd.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_nd.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_nd.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_nd.g_old_rec.element_information6, hr_api.g_varchar2) <>
198: nvl(pay_etp_shd_nd.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_nd.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_nd.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_nd.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_nd.g_old_rec.element_information7, hr_api.g_varchar2) <>
200: nvl(pay_etp_shd_nd.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_nd.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_nd.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_nd.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_nd.g_old_rec.element_information8, hr_api.g_varchar2) <>
202: nvl(pay_etp_shd_nd.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_nd.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_nd.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_nd.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_nd.g_old_rec.element_information9, hr_api.g_varchar2) <>
204: nvl(pay_etp_shd_nd.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_nd.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_nd.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_nd.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_nd.g_old_rec.element_information10, hr_api.g_varchar2) <>
206: nvl(pay_etp_shd_nd.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_nd.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_nd.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_nd.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_nd.g_old_rec.element_information11, hr_api.g_varchar2) <>
208: nvl(pay_etp_shd_nd.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_nd.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_nd.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_nd.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_nd.g_old_rec.element_information12, hr_api.g_varchar2) <>
210: nvl(pay_etp_shd_nd.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_nd.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_nd.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_nd.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_nd.g_old_rec.element_information13, hr_api.g_varchar2) <>
212: nvl(pay_etp_shd_nd.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_nd.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_nd.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_nd.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_nd.g_old_rec.element_information14, hr_api.g_varchar2) <>
214: nvl(pay_etp_shd_nd.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_nd.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_nd.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_nd.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_nd.g_old_rec.element_information15, hr_api.g_varchar2) <>
216: nvl(pay_etp_shd_nd.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_nd.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_nd.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_nd.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_nd.g_old_rec.element_information16, hr_api.g_varchar2) <>
218: nvl(pay_etp_shd_nd.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_nd.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_nd.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_nd.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_nd.g_old_rec.element_information17, hr_api.g_varchar2) <>
220: nvl(pay_etp_shd_nd.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_nd.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_nd.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_nd.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_nd.g_old_rec.element_information18, hr_api.g_varchar2) <>
222: nvl(pay_etp_shd_nd.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_nd.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_nd.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_nd.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_nd.g_old_rec.element_information19, hr_api.g_varchar2) <>
224: nvl(pay_etp_shd_nd.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_nd.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_nd.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_nd.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_nd.g_old_rec.element_information20, hr_api.g_varchar2) <>
226: nvl(pay_etp_shd_nd.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_nd.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_nd.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_nd.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_nd.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_nd.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_nd.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:
317: -- Internal Row Handler Use Only.
318: --
319: -- ----------------------------------------------------------------------------
320: procedure chk_df
321: (p_rec in pay_etp_shd_nd.g_rec_type
322: ) is
323: --
324: l_proc varchar2(72) := g_package || 'chk_df';
325: --
326: begin
327: hr_utility.set_location('Entering:'||l_proc,10);
328: --
329: if ((p_rec.element_type_id is not null) and (
330: nvl(pay_etp_shd_nd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
331: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
332: nvl(pay_etp_shd_nd.g_old_rec.attribute1, hr_api.g_varchar2) <>
333: nvl(p_rec.attribute1, hr_api.g_varchar2) or
334: nvl(pay_etp_shd_nd.g_old_rec.attribute2, hr_api.g_varchar2) <>
328: --
329: if ((p_rec.element_type_id is not null) and (
330: nvl(pay_etp_shd_nd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
331: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
332: nvl(pay_etp_shd_nd.g_old_rec.attribute1, hr_api.g_varchar2) <>
333: nvl(p_rec.attribute1, hr_api.g_varchar2) or
334: nvl(pay_etp_shd_nd.g_old_rec.attribute2, hr_api.g_varchar2) <>
335: nvl(p_rec.attribute2, hr_api.g_varchar2) or
336: nvl(pay_etp_shd_nd.g_old_rec.attribute3, hr_api.g_varchar2) <>
330: nvl(pay_etp_shd_nd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
331: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
332: nvl(pay_etp_shd_nd.g_old_rec.attribute1, hr_api.g_varchar2) <>
333: nvl(p_rec.attribute1, hr_api.g_varchar2) or
334: nvl(pay_etp_shd_nd.g_old_rec.attribute2, hr_api.g_varchar2) <>
335: nvl(p_rec.attribute2, hr_api.g_varchar2) or
336: nvl(pay_etp_shd_nd.g_old_rec.attribute3, hr_api.g_varchar2) <>
337: nvl(p_rec.attribute3, hr_api.g_varchar2) or
338: nvl(pay_etp_shd_nd.g_old_rec.attribute4, hr_api.g_varchar2) <>
332: nvl(pay_etp_shd_nd.g_old_rec.attribute1, hr_api.g_varchar2) <>
333: nvl(p_rec.attribute1, hr_api.g_varchar2) or
334: nvl(pay_etp_shd_nd.g_old_rec.attribute2, hr_api.g_varchar2) <>
335: nvl(p_rec.attribute2, hr_api.g_varchar2) or
336: nvl(pay_etp_shd_nd.g_old_rec.attribute3, hr_api.g_varchar2) <>
337: nvl(p_rec.attribute3, hr_api.g_varchar2) or
338: nvl(pay_etp_shd_nd.g_old_rec.attribute4, hr_api.g_varchar2) <>
339: nvl(p_rec.attribute4, hr_api.g_varchar2) or
340: nvl(pay_etp_shd_nd.g_old_rec.attribute5, hr_api.g_varchar2) <>
334: nvl(pay_etp_shd_nd.g_old_rec.attribute2, hr_api.g_varchar2) <>
335: nvl(p_rec.attribute2, hr_api.g_varchar2) or
336: nvl(pay_etp_shd_nd.g_old_rec.attribute3, hr_api.g_varchar2) <>
337: nvl(p_rec.attribute3, hr_api.g_varchar2) or
338: nvl(pay_etp_shd_nd.g_old_rec.attribute4, hr_api.g_varchar2) <>
339: nvl(p_rec.attribute4, hr_api.g_varchar2) or
340: nvl(pay_etp_shd_nd.g_old_rec.attribute5, hr_api.g_varchar2) <>
341: nvl(p_rec.attribute5, hr_api.g_varchar2) or
342: nvl(pay_etp_shd_nd.g_old_rec.attribute6, hr_api.g_varchar2) <>
336: nvl(pay_etp_shd_nd.g_old_rec.attribute3, hr_api.g_varchar2) <>
337: nvl(p_rec.attribute3, hr_api.g_varchar2) or
338: nvl(pay_etp_shd_nd.g_old_rec.attribute4, hr_api.g_varchar2) <>
339: nvl(p_rec.attribute4, hr_api.g_varchar2) or
340: nvl(pay_etp_shd_nd.g_old_rec.attribute5, hr_api.g_varchar2) <>
341: nvl(p_rec.attribute5, hr_api.g_varchar2) or
342: nvl(pay_etp_shd_nd.g_old_rec.attribute6, hr_api.g_varchar2) <>
343: nvl(p_rec.attribute6, hr_api.g_varchar2) or
344: nvl(pay_etp_shd_nd.g_old_rec.attribute7, hr_api.g_varchar2) <>
338: nvl(pay_etp_shd_nd.g_old_rec.attribute4, hr_api.g_varchar2) <>
339: nvl(p_rec.attribute4, hr_api.g_varchar2) or
340: nvl(pay_etp_shd_nd.g_old_rec.attribute5, hr_api.g_varchar2) <>
341: nvl(p_rec.attribute5, hr_api.g_varchar2) or
342: nvl(pay_etp_shd_nd.g_old_rec.attribute6, hr_api.g_varchar2) <>
343: nvl(p_rec.attribute6, hr_api.g_varchar2) or
344: nvl(pay_etp_shd_nd.g_old_rec.attribute7, hr_api.g_varchar2) <>
345: nvl(p_rec.attribute7, hr_api.g_varchar2) or
346: nvl(pay_etp_shd_nd.g_old_rec.attribute8, hr_api.g_varchar2) <>
340: nvl(pay_etp_shd_nd.g_old_rec.attribute5, hr_api.g_varchar2) <>
341: nvl(p_rec.attribute5, hr_api.g_varchar2) or
342: nvl(pay_etp_shd_nd.g_old_rec.attribute6, hr_api.g_varchar2) <>
343: nvl(p_rec.attribute6, hr_api.g_varchar2) or
344: nvl(pay_etp_shd_nd.g_old_rec.attribute7, hr_api.g_varchar2) <>
345: nvl(p_rec.attribute7, hr_api.g_varchar2) or
346: nvl(pay_etp_shd_nd.g_old_rec.attribute8, hr_api.g_varchar2) <>
347: nvl(p_rec.attribute8, hr_api.g_varchar2) or
348: nvl(pay_etp_shd_nd.g_old_rec.attribute9, hr_api.g_varchar2) <>
342: nvl(pay_etp_shd_nd.g_old_rec.attribute6, hr_api.g_varchar2) <>
343: nvl(p_rec.attribute6, hr_api.g_varchar2) or
344: nvl(pay_etp_shd_nd.g_old_rec.attribute7, hr_api.g_varchar2) <>
345: nvl(p_rec.attribute7, hr_api.g_varchar2) or
346: nvl(pay_etp_shd_nd.g_old_rec.attribute8, hr_api.g_varchar2) <>
347: nvl(p_rec.attribute8, hr_api.g_varchar2) or
348: nvl(pay_etp_shd_nd.g_old_rec.attribute9, hr_api.g_varchar2) <>
349: nvl(p_rec.attribute9, hr_api.g_varchar2) or
350: nvl(pay_etp_shd_nd.g_old_rec.attribute10, hr_api.g_varchar2) <>
344: nvl(pay_etp_shd_nd.g_old_rec.attribute7, hr_api.g_varchar2) <>
345: nvl(p_rec.attribute7, hr_api.g_varchar2) or
346: nvl(pay_etp_shd_nd.g_old_rec.attribute8, hr_api.g_varchar2) <>
347: nvl(p_rec.attribute8, hr_api.g_varchar2) or
348: nvl(pay_etp_shd_nd.g_old_rec.attribute9, hr_api.g_varchar2) <>
349: nvl(p_rec.attribute9, hr_api.g_varchar2) or
350: nvl(pay_etp_shd_nd.g_old_rec.attribute10, hr_api.g_varchar2) <>
351: nvl(p_rec.attribute10, hr_api.g_varchar2) or
352: nvl(pay_etp_shd_nd.g_old_rec.attribute11, hr_api.g_varchar2) <>
346: nvl(pay_etp_shd_nd.g_old_rec.attribute8, hr_api.g_varchar2) <>
347: nvl(p_rec.attribute8, hr_api.g_varchar2) or
348: nvl(pay_etp_shd_nd.g_old_rec.attribute9, hr_api.g_varchar2) <>
349: nvl(p_rec.attribute9, hr_api.g_varchar2) or
350: nvl(pay_etp_shd_nd.g_old_rec.attribute10, hr_api.g_varchar2) <>
351: nvl(p_rec.attribute10, hr_api.g_varchar2) or
352: nvl(pay_etp_shd_nd.g_old_rec.attribute11, hr_api.g_varchar2) <>
353: nvl(p_rec.attribute11, hr_api.g_varchar2) or
354: nvl(pay_etp_shd_nd.g_old_rec.attribute12, hr_api.g_varchar2) <>
348: nvl(pay_etp_shd_nd.g_old_rec.attribute9, hr_api.g_varchar2) <>
349: nvl(p_rec.attribute9, hr_api.g_varchar2) or
350: nvl(pay_etp_shd_nd.g_old_rec.attribute10, hr_api.g_varchar2) <>
351: nvl(p_rec.attribute10, hr_api.g_varchar2) or
352: nvl(pay_etp_shd_nd.g_old_rec.attribute11, hr_api.g_varchar2) <>
353: nvl(p_rec.attribute11, hr_api.g_varchar2) or
354: nvl(pay_etp_shd_nd.g_old_rec.attribute12, hr_api.g_varchar2) <>
355: nvl(p_rec.attribute12, hr_api.g_varchar2) or
356: nvl(pay_etp_shd_nd.g_old_rec.attribute13, hr_api.g_varchar2) <>
350: nvl(pay_etp_shd_nd.g_old_rec.attribute10, hr_api.g_varchar2) <>
351: nvl(p_rec.attribute10, hr_api.g_varchar2) or
352: nvl(pay_etp_shd_nd.g_old_rec.attribute11, hr_api.g_varchar2) <>
353: nvl(p_rec.attribute11, hr_api.g_varchar2) or
354: nvl(pay_etp_shd_nd.g_old_rec.attribute12, hr_api.g_varchar2) <>
355: nvl(p_rec.attribute12, hr_api.g_varchar2) or
356: nvl(pay_etp_shd_nd.g_old_rec.attribute13, hr_api.g_varchar2) <>
357: nvl(p_rec.attribute13, hr_api.g_varchar2) or
358: nvl(pay_etp_shd_nd.g_old_rec.attribute14, hr_api.g_varchar2) <>
352: nvl(pay_etp_shd_nd.g_old_rec.attribute11, hr_api.g_varchar2) <>
353: nvl(p_rec.attribute11, hr_api.g_varchar2) or
354: nvl(pay_etp_shd_nd.g_old_rec.attribute12, hr_api.g_varchar2) <>
355: nvl(p_rec.attribute12, hr_api.g_varchar2) or
356: nvl(pay_etp_shd_nd.g_old_rec.attribute13, hr_api.g_varchar2) <>
357: nvl(p_rec.attribute13, hr_api.g_varchar2) or
358: nvl(pay_etp_shd_nd.g_old_rec.attribute14, hr_api.g_varchar2) <>
359: nvl(p_rec.attribute14, hr_api.g_varchar2) or
360: nvl(pay_etp_shd_nd.g_old_rec.attribute15, hr_api.g_varchar2) <>
354: nvl(pay_etp_shd_nd.g_old_rec.attribute12, hr_api.g_varchar2) <>
355: nvl(p_rec.attribute12, hr_api.g_varchar2) or
356: nvl(pay_etp_shd_nd.g_old_rec.attribute13, hr_api.g_varchar2) <>
357: nvl(p_rec.attribute13, hr_api.g_varchar2) or
358: nvl(pay_etp_shd_nd.g_old_rec.attribute14, hr_api.g_varchar2) <>
359: nvl(p_rec.attribute14, hr_api.g_varchar2) or
360: nvl(pay_etp_shd_nd.g_old_rec.attribute15, hr_api.g_varchar2) <>
361: nvl(p_rec.attribute15, hr_api.g_varchar2) or
362: nvl(pay_etp_shd_nd.g_old_rec.attribute16, hr_api.g_varchar2) <>
356: nvl(pay_etp_shd_nd.g_old_rec.attribute13, hr_api.g_varchar2) <>
357: nvl(p_rec.attribute13, hr_api.g_varchar2) or
358: nvl(pay_etp_shd_nd.g_old_rec.attribute14, hr_api.g_varchar2) <>
359: nvl(p_rec.attribute14, hr_api.g_varchar2) or
360: nvl(pay_etp_shd_nd.g_old_rec.attribute15, hr_api.g_varchar2) <>
361: nvl(p_rec.attribute15, hr_api.g_varchar2) or
362: nvl(pay_etp_shd_nd.g_old_rec.attribute16, hr_api.g_varchar2) <>
363: nvl(p_rec.attribute16, hr_api.g_varchar2) or
364: nvl(pay_etp_shd_nd.g_old_rec.attribute17, hr_api.g_varchar2) <>
358: nvl(pay_etp_shd_nd.g_old_rec.attribute14, hr_api.g_varchar2) <>
359: nvl(p_rec.attribute14, hr_api.g_varchar2) or
360: nvl(pay_etp_shd_nd.g_old_rec.attribute15, hr_api.g_varchar2) <>
361: nvl(p_rec.attribute15, hr_api.g_varchar2) or
362: nvl(pay_etp_shd_nd.g_old_rec.attribute16, hr_api.g_varchar2) <>
363: nvl(p_rec.attribute16, hr_api.g_varchar2) or
364: nvl(pay_etp_shd_nd.g_old_rec.attribute17, hr_api.g_varchar2) <>
365: nvl(p_rec.attribute17, hr_api.g_varchar2) or
366: nvl(pay_etp_shd_nd.g_old_rec.attribute18, hr_api.g_varchar2) <>
360: nvl(pay_etp_shd_nd.g_old_rec.attribute15, hr_api.g_varchar2) <>
361: nvl(p_rec.attribute15, hr_api.g_varchar2) or
362: nvl(pay_etp_shd_nd.g_old_rec.attribute16, hr_api.g_varchar2) <>
363: nvl(p_rec.attribute16, hr_api.g_varchar2) or
364: nvl(pay_etp_shd_nd.g_old_rec.attribute17, hr_api.g_varchar2) <>
365: nvl(p_rec.attribute17, hr_api.g_varchar2) or
366: nvl(pay_etp_shd_nd.g_old_rec.attribute18, hr_api.g_varchar2) <>
367: nvl(p_rec.attribute18, hr_api.g_varchar2) or
368: nvl(pay_etp_shd_nd.g_old_rec.attribute19, hr_api.g_varchar2) <>
362: nvl(pay_etp_shd_nd.g_old_rec.attribute16, hr_api.g_varchar2) <>
363: nvl(p_rec.attribute16, hr_api.g_varchar2) or
364: nvl(pay_etp_shd_nd.g_old_rec.attribute17, hr_api.g_varchar2) <>
365: nvl(p_rec.attribute17, hr_api.g_varchar2) or
366: nvl(pay_etp_shd_nd.g_old_rec.attribute18, hr_api.g_varchar2) <>
367: nvl(p_rec.attribute18, hr_api.g_varchar2) or
368: nvl(pay_etp_shd_nd.g_old_rec.attribute19, hr_api.g_varchar2) <>
369: nvl(p_rec.attribute19, hr_api.g_varchar2) or
370: nvl(pay_etp_shd_nd.g_old_rec.attribute20, hr_api.g_varchar2) <>
364: nvl(pay_etp_shd_nd.g_old_rec.attribute17, hr_api.g_varchar2) <>
365: nvl(p_rec.attribute17, hr_api.g_varchar2) or
366: nvl(pay_etp_shd_nd.g_old_rec.attribute18, hr_api.g_varchar2) <>
367: nvl(p_rec.attribute18, hr_api.g_varchar2) or
368: nvl(pay_etp_shd_nd.g_old_rec.attribute19, hr_api.g_varchar2) <>
369: nvl(p_rec.attribute19, hr_api.g_varchar2) or
370: nvl(pay_etp_shd_nd.g_old_rec.attribute20, hr_api.g_varchar2) <>
371: nvl(p_rec.attribute20, hr_api.g_varchar2) ))
372: or (p_rec.element_type_id is null) then
366: nvl(pay_etp_shd_nd.g_old_rec.attribute18, hr_api.g_varchar2) <>
367: nvl(p_rec.attribute18, hr_api.g_varchar2) or
368: nvl(pay_etp_shd_nd.g_old_rec.attribute19, hr_api.g_varchar2) <>
369: nvl(p_rec.attribute19, hr_api.g_varchar2) or
370: nvl(pay_etp_shd_nd.g_old_rec.attribute20, hr_api.g_varchar2) <>
371: nvl(p_rec.attribute20, hr_api.g_varchar2) ))
372: or (p_rec.element_type_id is null) then
373: --
374: -- Only execute the validation if absolutely necessary:
455: -- {End Of Comments}
456: -- ----------------------------------------------------------------------------
457: Procedure chk_non_updateable_args
458: (p_effective_date in date
459: ,p_rec in pay_etp_shd_nd.g_rec_type
460: ) IS
461: --
462: l_proc varchar2(72) := g_package || 'chk_non_updateable_args';
463: --
465: --
466: -- Only proceed with the validation if a row exists for the current
467: -- record in the HR Schema.
468: --
469: IF NOT pay_etp_shd_nd.api_updating
470: (p_element_type_id => p_rec.element_type_id
471: ,p_effective_date => p_effective_date
472: ,p_object_version_number => p_rec.object_version_number
473: ) 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_nd.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_nd.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_nd.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
2412: Begin
2413: hr_utility.set_location('Entering:'||l_proc, 5);
2414: --
2415: If (
2416: (p_indirect_only_flag <> pay_etp_shd_nd.g_old_rec.indirect_only_flag)
2417: or
2418: (p_additional_entry_allowed_flg <>
2419: pay_etp_shd_nd.g_old_rec.additional_entry_allowed_flag)
2420: or
2415: If (
2416: (p_indirect_only_flag <> pay_etp_shd_nd.g_old_rec.indirect_only_flag)
2417: or
2418: (p_additional_entry_allowed_flg <>
2419: pay_etp_shd_nd.g_old_rec.additional_entry_allowed_flag)
2420: or
2421: (p_standard_link_flag <> pay_etp_shd_nd.g_old_rec.standard_link_flag)
2422: or
2423: (p_adjustment_only_flag <> pay_etp_shd_nd.g_old_rec.adjustment_only_flag)
2417: or
2418: (p_additional_entry_allowed_flg <>
2419: pay_etp_shd_nd.g_old_rec.additional_entry_allowed_flag)
2420: or
2421: (p_standard_link_flag <> pay_etp_shd_nd.g_old_rec.standard_link_flag)
2422: or
2423: (p_adjustment_only_flag <> pay_etp_shd_nd.g_old_rec.adjustment_only_flag)
2424: or
2425: (p_post_termination_rule <> pay_etp_shd_nd.g_old_rec.post_termination_rule)
2419: pay_etp_shd_nd.g_old_rec.additional_entry_allowed_flag)
2420: or
2421: (p_standard_link_flag <> pay_etp_shd_nd.g_old_rec.standard_link_flag)
2422: or
2423: (p_adjustment_only_flag <> pay_etp_shd_nd.g_old_rec.adjustment_only_flag)
2424: or
2425: (p_post_termination_rule <> pay_etp_shd_nd.g_old_rec.post_termination_rule)
2426: or
2427: (p_process_in_run_flag <> pay_etp_shd_nd.g_old_rec.process_in_run_flag)
2421: (p_standard_link_flag <> pay_etp_shd_nd.g_old_rec.standard_link_flag)
2422: or
2423: (p_adjustment_only_flag <> pay_etp_shd_nd.g_old_rec.adjustment_only_flag)
2424: or
2425: (p_post_termination_rule <> pay_etp_shd_nd.g_old_rec.post_termination_rule)
2426: or
2427: (p_process_in_run_flag <> pay_etp_shd_nd.g_old_rec.process_in_run_flag)
2428: or
2429: (p_once_each_period_flag <> pay_etp_shd_nd.g_old_rec.once_each_period_flag)
2423: (p_adjustment_only_flag <> pay_etp_shd_nd.g_old_rec.adjustment_only_flag)
2424: or
2425: (p_post_termination_rule <> pay_etp_shd_nd.g_old_rec.post_termination_rule)
2426: or
2427: (p_process_in_run_flag <> pay_etp_shd_nd.g_old_rec.process_in_run_flag)
2428: or
2429: (p_once_each_period_flag <> pay_etp_shd_nd.g_old_rec.once_each_period_flag)
2430: ) Then
2431: --
2425: (p_post_termination_rule <> pay_etp_shd_nd.g_old_rec.post_termination_rule)
2426: or
2427: (p_process_in_run_flag <> pay_etp_shd_nd.g_old_rec.process_in_run_flag)
2428: or
2429: (p_once_each_period_flag <> pay_etp_shd_nd.g_old_rec.once_each_period_flag)
2430: ) Then
2431: --
2432: l_element_links := pay_element_types_pkg.links_exist
2433: (p_element_type_id,
2439: fnd_message.set_name('PAY','PAY_6147_ELEMENT_LINK_UPDATE');
2440: fnd_message.raise_error;
2441: --
2442: End If;
2443: If (p_adjustment_only_flag <> pay_etp_shd_nd.g_old_rec.adjustment_only_flag
2444: )Then
2445: --
2446: l_indirect_results := pay_element_types_pkg.fed_by_indirect_results
2447: (p_element_type_id,
2455: --
2456: End If;
2457: --
2458: End If;
2459: If ((p_post_termination_rule <> pay_etp_shd_nd.g_old_rec.post_termination_rule)
2460: or
2461: (p_process_in_run_flag <> pay_etp_shd_nd.g_old_rec.process_in_run_flag)
2462: or
2463: (p_once_each_period_flag <> pay_etp_shd_nd.g_old_rec.once_each_period_flag)
2457: --
2458: End If;
2459: If ((p_post_termination_rule <> pay_etp_shd_nd.g_old_rec.post_termination_rule)
2460: or
2461: (p_process_in_run_flag <> pay_etp_shd_nd.g_old_rec.process_in_run_flag)
2462: or
2463: (p_once_each_period_flag <> pay_etp_shd_nd.g_old_rec.once_each_period_flag)
2464: ) Then
2465: --
2459: If ((p_post_termination_rule <> pay_etp_shd_nd.g_old_rec.post_termination_rule)
2460: or
2461: (p_process_in_run_flag <> pay_etp_shd_nd.g_old_rec.process_in_run_flag)
2462: or
2463: (p_once_each_period_flag <> pay_etp_shd_nd.g_old_rec.once_each_period_flag)
2464: ) Then
2465: --
2466: l_run_results:= pay_element_types_pkg.run_results_exist
2467: (p_element_type_id, p_validation_start_date, p_validation_end_date);
2723: -- ----------------------------------------------------------------------------
2724: -- |---------------------------< insert_validate >----------------------------|
2725: -- ----------------------------------------------------------------------------
2726: Procedure insert_validate
2727: (p_rec in pay_etp_shd_nd.g_rec_type
2728: ,p_effective_date in date
2729: ,p_datetrack_mode in varchar2
2730: ,p_validation_start_date in date
2731: ,p_validation_end_date in date
2751: -- Validate Important Attributes
2752: --
2753: hr_api.validate_bus_grp_id
2754: (p_business_group_id => p_rec.business_group_id
2755: ,p_associated_column1 => pay_etp_shd_nd.g_tab_nam
2756: || '.BUSINESS_GROUP_ID');
2757: --
2758: -- after validating the set of important attributes,
2759: -- if Multiple Message Detection is enabled and at least
2898: -- ----------------------------------------------------------------------------
2899: -- |---------------------------< update_validate >----------------------------|
2900: -- ----------------------------------------------------------------------------
2901: Procedure update_validate
2902: (p_rec in pay_etp_shd_nd.g_rec_type
2903: ,p_effective_date in date
2904: ,p_datetrack_mode in varchar2
2905: ,p_validation_start_date in date
2906: ,p_validation_end_date in date
2926: -- Validate Important Attributes
2927: --
2928: hr_api.validate_bus_grp_id
2929: (p_business_group_id => p_rec.business_group_id
2930: ,p_associated_column1 => pay_etp_shd_nd.g_tab_nam
2931: || '.BUSINESS_GROUP_ID');
2932: --
2933: -- After validating the set of important attributes,
2934: -- if Multiple Message Detection is enabled and at least
3089: -- ----------------------------------------------------------------------------
3090: -- |---------------------------< delete_validate >----------------------------|
3091: -- ----------------------------------------------------------------------------
3092: Procedure delete_validate
3093: (p_rec in pay_etp_shd_nd.g_rec_type
3094: ,p_effective_date in date
3095: ,p_datetrack_mode in varchar2
3096: ,p_validation_start_date in date
3097: ,p_validation_end_date in date