APPS.PAY_ETP_BUS dependencies on PAY_ETP_SHD

Line 182: (p_rec in pay_etp_shd.g_rec_type

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: --

Line 191: (nvl(pay_etp_shd.g_old_rec.element_information_category,

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

Line 194: nvl(pay_etp_shd.g_old_rec.element_information1, hr_api.g_varchar2) <>

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) <>

Line 196: nvl(pay_etp_shd.g_old_rec.element_information2, 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) <>

Line 198: nvl(pay_etp_shd.g_old_rec.element_information3, 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) <>

Line 200: nvl(pay_etp_shd.g_old_rec.element_information4, 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) <>

Line 202: nvl(pay_etp_shd.g_old_rec.element_information5, 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) <>

Line 204: nvl(pay_etp_shd.g_old_rec.element_information6, 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) <>

Line 206: nvl(pay_etp_shd.g_old_rec.element_information7, 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) <>

Line 208: nvl(pay_etp_shd.g_old_rec.element_information8, 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) <>

Line 210: nvl(pay_etp_shd.g_old_rec.element_information9, 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) <>

Line 212: nvl(pay_etp_shd.g_old_rec.element_information10, 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) <>

Line 214: nvl(pay_etp_shd.g_old_rec.element_information11, 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) <>

Line 216: nvl(pay_etp_shd.g_old_rec.element_information12, 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) <>

Line 218: nvl(pay_etp_shd.g_old_rec.element_information13, 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) <>

Line 220: nvl(pay_etp_shd.g_old_rec.element_information14, 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) <>

Line 222: nvl(pay_etp_shd.g_old_rec.element_information15, 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) <>

Line 224: nvl(pay_etp_shd.g_old_rec.element_information16, 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) <>

Line 226: nvl(pay_etp_shd.g_old_rec.element_information17, 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) <>

Line 228: nvl(pay_etp_shd.g_old_rec.element_information18, 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) <>

Line 230: nvl(pay_etp_shd.g_old_rec.element_information19, 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

Line 232: nvl(pay_etp_shd.g_old_rec.element_information20, hr_api.g_varchar2) <>

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:

Line 320: (p_rec in pay_etp_shd.g_rec_type

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: --

Line 329: nvl(pay_etp_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>

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) <>

Line 331: nvl(pay_etp_shd.g_old_rec.attribute1, 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) <>

Line 333: nvl(pay_etp_shd.g_old_rec.attribute2, 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) <>

Line 335: nvl(pay_etp_shd.g_old_rec.attribute3, 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) <>

Line 337: nvl(pay_etp_shd.g_old_rec.attribute4, 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) <>

Line 339: nvl(pay_etp_shd.g_old_rec.attribute5, 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) <>

Line 341: nvl(pay_etp_shd.g_old_rec.attribute6, 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) <>

Line 343: nvl(pay_etp_shd.g_old_rec.attribute7, 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) <>

Line 345: nvl(pay_etp_shd.g_old_rec.attribute8, 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) <>

Line 347: nvl(pay_etp_shd.g_old_rec.attribute9, 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) <>

Line 349: nvl(pay_etp_shd.g_old_rec.attribute10, 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) <>

Line 351: nvl(pay_etp_shd.g_old_rec.attribute11, 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) <>

Line 353: nvl(pay_etp_shd.g_old_rec.attribute12, 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) <>

Line 355: nvl(pay_etp_shd.g_old_rec.attribute13, 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) <>

Line 357: nvl(pay_etp_shd.g_old_rec.attribute14, 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) <>

Line 359: nvl(pay_etp_shd.g_old_rec.attribute15, 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) <>

Line 361: nvl(pay_etp_shd.g_old_rec.attribute16, 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) <>

Line 363: nvl(pay_etp_shd.g_old_rec.attribute17, 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) <>

Line 365: nvl(pay_etp_shd.g_old_rec.attribute18, 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) <>

Line 367: nvl(pay_etp_shd.g_old_rec.attribute19, 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

Line 369: nvl(pay_etp_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

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:

Line 457: ,p_rec in pay_etp_shd.g_rec_type

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: --

Line 467: IF NOT pay_etp_shd.api_updating

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

Line 1469: pay_etp_shd.g_old_rec.multiple_entries_allowed_flag) 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

Line 1679: (p_processing_priority <> pay_etp_shd.g_old_rec.processing_priority) Then

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,

Line 1974: nvl(pay_etp_shd.g_old_rec.third_party_pay_only_flag,hr_api.g_varchar2))

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

Line 2646: (p_indirect_only_flag <> pay_etp_shd.g_old_rec.indirect_only_flag)

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

Line 2649: pay_etp_shd.g_old_rec.additional_entry_allowed_flag)

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)

Line 2651: (p_standard_link_flag <> pay_etp_shd.g_old_rec.standard_link_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)

Line 2653: (p_adjustment_only_flag <> pay_etp_shd.g_old_rec.adjustment_only_flag)

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)

Line 2655: (p_post_termination_rule <> pay_etp_shd.g_old_rec.post_termination_rule)

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)

Line 2657: (p_process_in_run_flag <> pay_etp_shd.g_old_rec.process_in_run_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: --

Line 2659: (p_once_each_period_flag <> pay_etp_shd.g_old_rec.once_each_period_flag)

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,

Line 2673: If (p_adjustment_only_flag <> pay_etp_shd.g_old_rec.adjustment_only_flag

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,

Line 2689: If ((p_post_termination_rule <> pay_etp_shd.g_old_rec.post_termination_rule)

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)

Line 2691: (p_process_in_run_flag <> pay_etp_shd.g_old_rec.process_in_run_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: --

Line 2693: (p_once_each_period_flag <> pay_etp_shd.g_old_rec.once_each_period_flag)

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);

Line 2957: (p_rec in pay_etp_shd.g_rec_type

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

Line 2985: ,p_associated_column1 => pay_etp_shd.g_tab_nam

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

Line 3145: (p_rec in pay_etp_shd.g_rec_type

3141: -- ----------------------------------------------------------------------------
3142: -- |---------------------------< update_validate >----------------------------|
3143: -- ----------------------------------------------------------------------------
3144: Procedure update_validate
3145: (p_rec in pay_etp_shd.g_rec_type
3146: ,p_effective_date in date
3147: ,p_datetrack_mode in varchar2
3148: ,p_validation_start_date in date
3149: ,p_validation_end_date in date

Line 3173: ,p_associated_column1 => pay_etp_shd.g_tab_nam

3169: -- Validate Important Attributes
3170: --
3171: hr_api.validate_bus_grp_id
3172: (p_business_group_id => p_rec.business_group_id
3173: ,p_associated_column1 => pay_etp_shd.g_tab_nam
3174: || '.BUSINESS_GROUP_ID');
3175: --
3176: -- After validating the set of important attributes,
3177: -- if Multiple Message Detection is enabled and at least

Line 3349: (p_rec in pay_etp_shd.g_rec_type

3345: -- ----------------------------------------------------------------------------
3346: -- |---------------------------< delete_validate >----------------------------|
3347: -- ----------------------------------------------------------------------------
3348: Procedure delete_validate
3349: (p_rec in pay_etp_shd.g_rec_type
3350: ,p_effective_date in date
3351: ,p_datetrack_mode in varchar2
3352: ,p_validation_start_date in date
3353: ,p_validation_end_date in date