DBA Data[Home] [Help]

APPS.PAY_ETP_BUS_ND dependencies on PAY_ETP_SHD_ND

Line 182: (p_rec in pay_etp_shd_nd.g_rec_type

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

Line 191: (nvl(pay_etp_shd_nd.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_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

Line 194: nvl(pay_etp_shd_nd.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_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) <>

Line 196: nvl(pay_etp_shd_nd.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_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) <>

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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:

Line 321: (p_rec in pay_etp_shd_nd.g_rec_type

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

Line 330: nvl(pay_etp_shd_nd.g_old_rec.attribute_category, hr_api.g_varchar2) <>

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 370: nvl(pay_etp_shd_nd.g_old_rec.attribute20, hr_api.g_varchar2) <>

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:

Line 459: ,p_rec in pay_etp_shd_nd.g_rec_type

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

Line 469: IF NOT pay_etp_shd_nd.api_updating

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

Line 1469: pay_etp_shd_nd.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_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

Line 1679: (p_processing_priority <> pay_etp_shd_nd.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_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,

Line 1974: nvl(pay_etp_shd_nd.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_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

Line 2416: (p_indirect_only_flag <> pay_etp_shd_nd.g_old_rec.indirect_only_flag)

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

Line 2419: pay_etp_shd_nd.g_old_rec.additional_entry_allowed_flag)

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)

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

Line 2423: (p_adjustment_only_flag <> pay_etp_shd_nd.g_old_rec.adjustment_only_flag)

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)

Line 2425: (p_post_termination_rule <> pay_etp_shd_nd.g_old_rec.post_termination_rule)

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)

Line 2427: (p_process_in_run_flag <> pay_etp_shd_nd.g_old_rec.process_in_run_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: --

Line 2429: (p_once_each_period_flag <> pay_etp_shd_nd.g_old_rec.once_each_period_flag)

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,

Line 2443: If (p_adjustment_only_flag <> pay_etp_shd_nd.g_old_rec.adjustment_only_flag

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,

Line 2459: If ((p_post_termination_rule <> pay_etp_shd_nd.g_old_rec.post_termination_rule)

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)

Line 2461: (p_process_in_run_flag <> pay_etp_shd_nd.g_old_rec.process_in_run_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: --

Line 2463: (p_once_each_period_flag <> pay_etp_shd_nd.g_old_rec.once_each_period_flag)

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

Line 2727: (p_rec in pay_etp_shd_nd.g_rec_type

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

Line 2755: ,p_associated_column1 => pay_etp_shd_nd.g_tab_nam

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

Line 2902: (p_rec in pay_etp_shd_nd.g_rec_type

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

Line 2930: ,p_associated_column1 => pay_etp_shd_nd.g_tab_nam

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

Line 3093: (p_rec in pay_etp_shd_nd.g_rec_type

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