eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_OPM_BUS dependencies on PAY_OPM_SHD

Line 177: (p_rec in pay_opm_shd.g_rec_type

173: -- Internal Row Handler Use Only.
174: --
175: -- ----------------------------------------------------------------------------
176: procedure chk_ddf
177: (p_rec in pay_opm_shd.g_rec_type
178: ) is
179: --
180: l_proc varchar2(72) := g_package || 'chk_ddf';
181: --

Line 186: nvl(pay_opm_shd.g_old_rec.pmeth_information_category, hr_api.g_varchar2) <>

182: begin
183: hr_utility.set_location('Entering:'||l_proc,10);
184: --
185: if ((p_rec.org_payment_method_id is not null) and (
186: nvl(pay_opm_shd.g_old_rec.pmeth_information_category, hr_api.g_varchar2) <>
187: nvl(p_rec.pmeth_information_category, hr_api.g_varchar2) or
188: nvl(pay_opm_shd.g_old_rec.pmeth_information1, hr_api.g_varchar2) <>
189: nvl(p_rec.pmeth_information1, hr_api.g_varchar2) or
190: nvl(pay_opm_shd.g_old_rec.pmeth_information2, hr_api.g_varchar2) <>

Line 188: nvl(pay_opm_shd.g_old_rec.pmeth_information1, hr_api.g_varchar2) <>

184: --
185: if ((p_rec.org_payment_method_id is not null) and (
186: nvl(pay_opm_shd.g_old_rec.pmeth_information_category, hr_api.g_varchar2) <>
187: nvl(p_rec.pmeth_information_category, hr_api.g_varchar2) or
188: nvl(pay_opm_shd.g_old_rec.pmeth_information1, hr_api.g_varchar2) <>
189: nvl(p_rec.pmeth_information1, hr_api.g_varchar2) or
190: nvl(pay_opm_shd.g_old_rec.pmeth_information2, hr_api.g_varchar2) <>
191: nvl(p_rec.pmeth_information2, hr_api.g_varchar2) or
192: nvl(pay_opm_shd.g_old_rec.pmeth_information3, hr_api.g_varchar2) <>

Line 190: nvl(pay_opm_shd.g_old_rec.pmeth_information2, hr_api.g_varchar2) <>

186: nvl(pay_opm_shd.g_old_rec.pmeth_information_category, hr_api.g_varchar2) <>
187: nvl(p_rec.pmeth_information_category, hr_api.g_varchar2) or
188: nvl(pay_opm_shd.g_old_rec.pmeth_information1, hr_api.g_varchar2) <>
189: nvl(p_rec.pmeth_information1, hr_api.g_varchar2) or
190: nvl(pay_opm_shd.g_old_rec.pmeth_information2, hr_api.g_varchar2) <>
191: nvl(p_rec.pmeth_information2, hr_api.g_varchar2) or
192: nvl(pay_opm_shd.g_old_rec.pmeth_information3, hr_api.g_varchar2) <>
193: nvl(p_rec.pmeth_information3, hr_api.g_varchar2) or
194: nvl(pay_opm_shd.g_old_rec.pmeth_information4, hr_api.g_varchar2) <>

Line 192: nvl(pay_opm_shd.g_old_rec.pmeth_information3, hr_api.g_varchar2) <>

188: nvl(pay_opm_shd.g_old_rec.pmeth_information1, hr_api.g_varchar2) <>
189: nvl(p_rec.pmeth_information1, hr_api.g_varchar2) or
190: nvl(pay_opm_shd.g_old_rec.pmeth_information2, hr_api.g_varchar2) <>
191: nvl(p_rec.pmeth_information2, hr_api.g_varchar2) or
192: nvl(pay_opm_shd.g_old_rec.pmeth_information3, hr_api.g_varchar2) <>
193: nvl(p_rec.pmeth_information3, hr_api.g_varchar2) or
194: nvl(pay_opm_shd.g_old_rec.pmeth_information4, hr_api.g_varchar2) <>
195: nvl(p_rec.pmeth_information4, hr_api.g_varchar2) or
196: nvl(pay_opm_shd.g_old_rec.pmeth_information5, hr_api.g_varchar2) <>

Line 194: nvl(pay_opm_shd.g_old_rec.pmeth_information4, hr_api.g_varchar2) <>

190: nvl(pay_opm_shd.g_old_rec.pmeth_information2, hr_api.g_varchar2) <>
191: nvl(p_rec.pmeth_information2, hr_api.g_varchar2) or
192: nvl(pay_opm_shd.g_old_rec.pmeth_information3, hr_api.g_varchar2) <>
193: nvl(p_rec.pmeth_information3, hr_api.g_varchar2) or
194: nvl(pay_opm_shd.g_old_rec.pmeth_information4, hr_api.g_varchar2) <>
195: nvl(p_rec.pmeth_information4, hr_api.g_varchar2) or
196: nvl(pay_opm_shd.g_old_rec.pmeth_information5, hr_api.g_varchar2) <>
197: nvl(p_rec.pmeth_information5, hr_api.g_varchar2) or
198: nvl(pay_opm_shd.g_old_rec.pmeth_information6, hr_api.g_varchar2) <>

Line 196: nvl(pay_opm_shd.g_old_rec.pmeth_information5, hr_api.g_varchar2) <>

192: nvl(pay_opm_shd.g_old_rec.pmeth_information3, hr_api.g_varchar2) <>
193: nvl(p_rec.pmeth_information3, hr_api.g_varchar2) or
194: nvl(pay_opm_shd.g_old_rec.pmeth_information4, hr_api.g_varchar2) <>
195: nvl(p_rec.pmeth_information4, hr_api.g_varchar2) or
196: nvl(pay_opm_shd.g_old_rec.pmeth_information5, hr_api.g_varchar2) <>
197: nvl(p_rec.pmeth_information5, hr_api.g_varchar2) or
198: nvl(pay_opm_shd.g_old_rec.pmeth_information6, hr_api.g_varchar2) <>
199: nvl(p_rec.pmeth_information6, hr_api.g_varchar2) or
200: nvl(pay_opm_shd.g_old_rec.pmeth_information7, hr_api.g_varchar2) <>

Line 198: nvl(pay_opm_shd.g_old_rec.pmeth_information6, hr_api.g_varchar2) <>

194: nvl(pay_opm_shd.g_old_rec.pmeth_information4, hr_api.g_varchar2) <>
195: nvl(p_rec.pmeth_information4, hr_api.g_varchar2) or
196: nvl(pay_opm_shd.g_old_rec.pmeth_information5, hr_api.g_varchar2) <>
197: nvl(p_rec.pmeth_information5, hr_api.g_varchar2) or
198: nvl(pay_opm_shd.g_old_rec.pmeth_information6, hr_api.g_varchar2) <>
199: nvl(p_rec.pmeth_information6, hr_api.g_varchar2) or
200: nvl(pay_opm_shd.g_old_rec.pmeth_information7, hr_api.g_varchar2) <>
201: nvl(p_rec.pmeth_information7, hr_api.g_varchar2) or
202: nvl(pay_opm_shd.g_old_rec.pmeth_information8, hr_api.g_varchar2) <>

Line 200: nvl(pay_opm_shd.g_old_rec.pmeth_information7, hr_api.g_varchar2) <>

196: nvl(pay_opm_shd.g_old_rec.pmeth_information5, hr_api.g_varchar2) <>
197: nvl(p_rec.pmeth_information5, hr_api.g_varchar2) or
198: nvl(pay_opm_shd.g_old_rec.pmeth_information6, hr_api.g_varchar2) <>
199: nvl(p_rec.pmeth_information6, hr_api.g_varchar2) or
200: nvl(pay_opm_shd.g_old_rec.pmeth_information7, hr_api.g_varchar2) <>
201: nvl(p_rec.pmeth_information7, hr_api.g_varchar2) or
202: nvl(pay_opm_shd.g_old_rec.pmeth_information8, hr_api.g_varchar2) <>
203: nvl(p_rec.pmeth_information8, hr_api.g_varchar2) or
204: nvl(pay_opm_shd.g_old_rec.pmeth_information9, hr_api.g_varchar2) <>

Line 202: nvl(pay_opm_shd.g_old_rec.pmeth_information8, hr_api.g_varchar2) <>

198: nvl(pay_opm_shd.g_old_rec.pmeth_information6, hr_api.g_varchar2) <>
199: nvl(p_rec.pmeth_information6, hr_api.g_varchar2) or
200: nvl(pay_opm_shd.g_old_rec.pmeth_information7, hr_api.g_varchar2) <>
201: nvl(p_rec.pmeth_information7, hr_api.g_varchar2) or
202: nvl(pay_opm_shd.g_old_rec.pmeth_information8, hr_api.g_varchar2) <>
203: nvl(p_rec.pmeth_information8, hr_api.g_varchar2) or
204: nvl(pay_opm_shd.g_old_rec.pmeth_information9, hr_api.g_varchar2) <>
205: nvl(p_rec.pmeth_information9, hr_api.g_varchar2) or
206: nvl(pay_opm_shd.g_old_rec.pmeth_information10, hr_api.g_varchar2) <>

Line 204: nvl(pay_opm_shd.g_old_rec.pmeth_information9, hr_api.g_varchar2) <>

200: nvl(pay_opm_shd.g_old_rec.pmeth_information7, hr_api.g_varchar2) <>
201: nvl(p_rec.pmeth_information7, hr_api.g_varchar2) or
202: nvl(pay_opm_shd.g_old_rec.pmeth_information8, hr_api.g_varchar2) <>
203: nvl(p_rec.pmeth_information8, hr_api.g_varchar2) or
204: nvl(pay_opm_shd.g_old_rec.pmeth_information9, hr_api.g_varchar2) <>
205: nvl(p_rec.pmeth_information9, hr_api.g_varchar2) or
206: nvl(pay_opm_shd.g_old_rec.pmeth_information10, hr_api.g_varchar2) <>
207: nvl(p_rec.pmeth_information10, hr_api.g_varchar2) or
208: nvl(pay_opm_shd.g_old_rec.pmeth_information11, hr_api.g_varchar2) <>

Line 206: nvl(pay_opm_shd.g_old_rec.pmeth_information10, hr_api.g_varchar2) <>

202: nvl(pay_opm_shd.g_old_rec.pmeth_information8, hr_api.g_varchar2) <>
203: nvl(p_rec.pmeth_information8, hr_api.g_varchar2) or
204: nvl(pay_opm_shd.g_old_rec.pmeth_information9, hr_api.g_varchar2) <>
205: nvl(p_rec.pmeth_information9, hr_api.g_varchar2) or
206: nvl(pay_opm_shd.g_old_rec.pmeth_information10, hr_api.g_varchar2) <>
207: nvl(p_rec.pmeth_information10, hr_api.g_varchar2) or
208: nvl(pay_opm_shd.g_old_rec.pmeth_information11, hr_api.g_varchar2) <>
209: nvl(p_rec.pmeth_information11, hr_api.g_varchar2) or
210: nvl(pay_opm_shd.g_old_rec.pmeth_information12, hr_api.g_varchar2) <>

Line 208: nvl(pay_opm_shd.g_old_rec.pmeth_information11, hr_api.g_varchar2) <>

204: nvl(pay_opm_shd.g_old_rec.pmeth_information9, hr_api.g_varchar2) <>
205: nvl(p_rec.pmeth_information9, hr_api.g_varchar2) or
206: nvl(pay_opm_shd.g_old_rec.pmeth_information10, hr_api.g_varchar2) <>
207: nvl(p_rec.pmeth_information10, hr_api.g_varchar2) or
208: nvl(pay_opm_shd.g_old_rec.pmeth_information11, hr_api.g_varchar2) <>
209: nvl(p_rec.pmeth_information11, hr_api.g_varchar2) or
210: nvl(pay_opm_shd.g_old_rec.pmeth_information12, hr_api.g_varchar2) <>
211: nvl(p_rec.pmeth_information12, hr_api.g_varchar2) or
212: nvl(pay_opm_shd.g_old_rec.pmeth_information13, hr_api.g_varchar2) <>

Line 210: nvl(pay_opm_shd.g_old_rec.pmeth_information12, hr_api.g_varchar2) <>

206: nvl(pay_opm_shd.g_old_rec.pmeth_information10, hr_api.g_varchar2) <>
207: nvl(p_rec.pmeth_information10, hr_api.g_varchar2) or
208: nvl(pay_opm_shd.g_old_rec.pmeth_information11, hr_api.g_varchar2) <>
209: nvl(p_rec.pmeth_information11, hr_api.g_varchar2) or
210: nvl(pay_opm_shd.g_old_rec.pmeth_information12, hr_api.g_varchar2) <>
211: nvl(p_rec.pmeth_information12, hr_api.g_varchar2) or
212: nvl(pay_opm_shd.g_old_rec.pmeth_information13, hr_api.g_varchar2) <>
213: nvl(p_rec.pmeth_information13, hr_api.g_varchar2) or
214: nvl(pay_opm_shd.g_old_rec.pmeth_information14, hr_api.g_varchar2) <>

Line 212: nvl(pay_opm_shd.g_old_rec.pmeth_information13, hr_api.g_varchar2) <>

208: nvl(pay_opm_shd.g_old_rec.pmeth_information11, hr_api.g_varchar2) <>
209: nvl(p_rec.pmeth_information11, hr_api.g_varchar2) or
210: nvl(pay_opm_shd.g_old_rec.pmeth_information12, hr_api.g_varchar2) <>
211: nvl(p_rec.pmeth_information12, hr_api.g_varchar2) or
212: nvl(pay_opm_shd.g_old_rec.pmeth_information13, hr_api.g_varchar2) <>
213: nvl(p_rec.pmeth_information13, hr_api.g_varchar2) or
214: nvl(pay_opm_shd.g_old_rec.pmeth_information14, hr_api.g_varchar2) <>
215: nvl(p_rec.pmeth_information14, hr_api.g_varchar2) or
216: nvl(pay_opm_shd.g_old_rec.pmeth_information15, hr_api.g_varchar2) <>

Line 214: nvl(pay_opm_shd.g_old_rec.pmeth_information14, hr_api.g_varchar2) <>

210: nvl(pay_opm_shd.g_old_rec.pmeth_information12, hr_api.g_varchar2) <>
211: nvl(p_rec.pmeth_information12, hr_api.g_varchar2) or
212: nvl(pay_opm_shd.g_old_rec.pmeth_information13, hr_api.g_varchar2) <>
213: nvl(p_rec.pmeth_information13, hr_api.g_varchar2) or
214: nvl(pay_opm_shd.g_old_rec.pmeth_information14, hr_api.g_varchar2) <>
215: nvl(p_rec.pmeth_information14, hr_api.g_varchar2) or
216: nvl(pay_opm_shd.g_old_rec.pmeth_information15, hr_api.g_varchar2) <>
217: nvl(p_rec.pmeth_information15, hr_api.g_varchar2) or
218: nvl(pay_opm_shd.g_old_rec.pmeth_information16, hr_api.g_varchar2) <>

Line 216: nvl(pay_opm_shd.g_old_rec.pmeth_information15, hr_api.g_varchar2) <>

212: nvl(pay_opm_shd.g_old_rec.pmeth_information13, hr_api.g_varchar2) <>
213: nvl(p_rec.pmeth_information13, hr_api.g_varchar2) or
214: nvl(pay_opm_shd.g_old_rec.pmeth_information14, hr_api.g_varchar2) <>
215: nvl(p_rec.pmeth_information14, hr_api.g_varchar2) or
216: nvl(pay_opm_shd.g_old_rec.pmeth_information15, hr_api.g_varchar2) <>
217: nvl(p_rec.pmeth_information15, hr_api.g_varchar2) or
218: nvl(pay_opm_shd.g_old_rec.pmeth_information16, hr_api.g_varchar2) <>
219: nvl(p_rec.pmeth_information16, hr_api.g_varchar2) or
220: nvl(pay_opm_shd.g_old_rec.pmeth_information17, hr_api.g_varchar2) <>

Line 218: nvl(pay_opm_shd.g_old_rec.pmeth_information16, hr_api.g_varchar2) <>

214: nvl(pay_opm_shd.g_old_rec.pmeth_information14, hr_api.g_varchar2) <>
215: nvl(p_rec.pmeth_information14, hr_api.g_varchar2) or
216: nvl(pay_opm_shd.g_old_rec.pmeth_information15, hr_api.g_varchar2) <>
217: nvl(p_rec.pmeth_information15, hr_api.g_varchar2) or
218: nvl(pay_opm_shd.g_old_rec.pmeth_information16, hr_api.g_varchar2) <>
219: nvl(p_rec.pmeth_information16, hr_api.g_varchar2) or
220: nvl(pay_opm_shd.g_old_rec.pmeth_information17, hr_api.g_varchar2) <>
221: nvl(p_rec.pmeth_information17, hr_api.g_varchar2) or
222: nvl(pay_opm_shd.g_old_rec.pmeth_information18, hr_api.g_varchar2) <>

Line 220: nvl(pay_opm_shd.g_old_rec.pmeth_information17, hr_api.g_varchar2) <>

216: nvl(pay_opm_shd.g_old_rec.pmeth_information15, hr_api.g_varchar2) <>
217: nvl(p_rec.pmeth_information15, hr_api.g_varchar2) or
218: nvl(pay_opm_shd.g_old_rec.pmeth_information16, hr_api.g_varchar2) <>
219: nvl(p_rec.pmeth_information16, hr_api.g_varchar2) or
220: nvl(pay_opm_shd.g_old_rec.pmeth_information17, hr_api.g_varchar2) <>
221: nvl(p_rec.pmeth_information17, hr_api.g_varchar2) or
222: nvl(pay_opm_shd.g_old_rec.pmeth_information18, hr_api.g_varchar2) <>
223: nvl(p_rec.pmeth_information18, hr_api.g_varchar2) or
224: nvl(pay_opm_shd.g_old_rec.pmeth_information19, hr_api.g_varchar2) <>

Line 222: nvl(pay_opm_shd.g_old_rec.pmeth_information18, hr_api.g_varchar2) <>

218: nvl(pay_opm_shd.g_old_rec.pmeth_information16, hr_api.g_varchar2) <>
219: nvl(p_rec.pmeth_information16, hr_api.g_varchar2) or
220: nvl(pay_opm_shd.g_old_rec.pmeth_information17, hr_api.g_varchar2) <>
221: nvl(p_rec.pmeth_information17, hr_api.g_varchar2) or
222: nvl(pay_opm_shd.g_old_rec.pmeth_information18, hr_api.g_varchar2) <>
223: nvl(p_rec.pmeth_information18, hr_api.g_varchar2) or
224: nvl(pay_opm_shd.g_old_rec.pmeth_information19, hr_api.g_varchar2) <>
225: nvl(p_rec.pmeth_information19, hr_api.g_varchar2) or
226: nvl(pay_opm_shd.g_old_rec.pmeth_information20, hr_api.g_varchar2) <>

Line 224: nvl(pay_opm_shd.g_old_rec.pmeth_information19, hr_api.g_varchar2) <>

220: nvl(pay_opm_shd.g_old_rec.pmeth_information17, hr_api.g_varchar2) <>
221: nvl(p_rec.pmeth_information17, hr_api.g_varchar2) or
222: nvl(pay_opm_shd.g_old_rec.pmeth_information18, hr_api.g_varchar2) <>
223: nvl(p_rec.pmeth_information18, hr_api.g_varchar2) or
224: nvl(pay_opm_shd.g_old_rec.pmeth_information19, hr_api.g_varchar2) <>
225: nvl(p_rec.pmeth_information19, hr_api.g_varchar2) or
226: nvl(pay_opm_shd.g_old_rec.pmeth_information20, hr_api.g_varchar2) <>
227: nvl(p_rec.pmeth_information20, hr_api.g_varchar2) ))
228: or (p_rec.org_payment_method_id is null) then

Line 226: nvl(pay_opm_shd.g_old_rec.pmeth_information20, hr_api.g_varchar2) <>

222: nvl(pay_opm_shd.g_old_rec.pmeth_information18, hr_api.g_varchar2) <>
223: nvl(p_rec.pmeth_information18, hr_api.g_varchar2) or
224: nvl(pay_opm_shd.g_old_rec.pmeth_information19, hr_api.g_varchar2) <>
225: nvl(p_rec.pmeth_information19, hr_api.g_varchar2) or
226: nvl(pay_opm_shd.g_old_rec.pmeth_information20, hr_api.g_varchar2) <>
227: nvl(p_rec.pmeth_information20, hr_api.g_varchar2) ))
228: or (p_rec.org_payment_method_id is null) then
229: --
230: -- Only execute the validation if absolutely necessary:

Line 314: (p_rec in pay_opm_shd.g_rec_type

310: -- Internal Row Handler Use Only.
311: --
312: -- ----------------------------------------------------------------------------
313: procedure chk_df
314: (p_rec in pay_opm_shd.g_rec_type
315: ) is
316: --
317: l_proc varchar2(72) := g_package || 'chk_df';
318: --

Line 323: nvl(pay_opm_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>

319: begin
320: hr_utility.set_location('Entering:'||l_proc,10);
321: --
322: if ((p_rec.org_payment_method_id is not null) and (
323: nvl(pay_opm_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
324: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
325: nvl(pay_opm_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
326: nvl(p_rec.attribute1, hr_api.g_varchar2) or
327: nvl(pay_opm_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

Line 325: nvl(pay_opm_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>

321: --
322: if ((p_rec.org_payment_method_id is not null) and (
323: nvl(pay_opm_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
324: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
325: nvl(pay_opm_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
326: nvl(p_rec.attribute1, hr_api.g_varchar2) or
327: nvl(pay_opm_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
328: nvl(p_rec.attribute2, hr_api.g_varchar2) or
329: nvl(pay_opm_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

Line 327: nvl(pay_opm_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

323: nvl(pay_opm_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
324: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
325: nvl(pay_opm_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
326: nvl(p_rec.attribute1, hr_api.g_varchar2) or
327: nvl(pay_opm_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
328: nvl(p_rec.attribute2, hr_api.g_varchar2) or
329: nvl(pay_opm_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
330: nvl(p_rec.attribute3, hr_api.g_varchar2) or
331: nvl(pay_opm_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

Line 329: nvl(pay_opm_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

325: nvl(pay_opm_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
326: nvl(p_rec.attribute1, hr_api.g_varchar2) or
327: nvl(pay_opm_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
328: nvl(p_rec.attribute2, hr_api.g_varchar2) or
329: nvl(pay_opm_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
330: nvl(p_rec.attribute3, hr_api.g_varchar2) or
331: nvl(pay_opm_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
332: nvl(p_rec.attribute4, hr_api.g_varchar2) or
333: nvl(pay_opm_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

Line 331: nvl(pay_opm_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

327: nvl(pay_opm_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
328: nvl(p_rec.attribute2, hr_api.g_varchar2) or
329: nvl(pay_opm_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
330: nvl(p_rec.attribute3, hr_api.g_varchar2) or
331: nvl(pay_opm_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
332: nvl(p_rec.attribute4, hr_api.g_varchar2) or
333: nvl(pay_opm_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
334: nvl(p_rec.attribute5, hr_api.g_varchar2) or
335: nvl(pay_opm_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

Line 333: nvl(pay_opm_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

329: nvl(pay_opm_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
330: nvl(p_rec.attribute3, hr_api.g_varchar2) or
331: nvl(pay_opm_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
332: nvl(p_rec.attribute4, hr_api.g_varchar2) or
333: nvl(pay_opm_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
334: nvl(p_rec.attribute5, hr_api.g_varchar2) or
335: nvl(pay_opm_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
336: nvl(p_rec.attribute6, hr_api.g_varchar2) or
337: nvl(pay_opm_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

Line 335: nvl(pay_opm_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

331: nvl(pay_opm_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
332: nvl(p_rec.attribute4, hr_api.g_varchar2) or
333: nvl(pay_opm_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
334: nvl(p_rec.attribute5, hr_api.g_varchar2) or
335: nvl(pay_opm_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
336: nvl(p_rec.attribute6, hr_api.g_varchar2) or
337: nvl(pay_opm_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
338: nvl(p_rec.attribute7, hr_api.g_varchar2) or
339: nvl(pay_opm_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

Line 337: nvl(pay_opm_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

333: nvl(pay_opm_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
334: nvl(p_rec.attribute5, hr_api.g_varchar2) or
335: nvl(pay_opm_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
336: nvl(p_rec.attribute6, hr_api.g_varchar2) or
337: nvl(pay_opm_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
338: nvl(p_rec.attribute7, hr_api.g_varchar2) or
339: nvl(pay_opm_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
340: nvl(p_rec.attribute8, hr_api.g_varchar2) or
341: nvl(pay_opm_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

Line 339: nvl(pay_opm_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

335: nvl(pay_opm_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
336: nvl(p_rec.attribute6, hr_api.g_varchar2) or
337: nvl(pay_opm_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
338: nvl(p_rec.attribute7, hr_api.g_varchar2) or
339: nvl(pay_opm_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
340: nvl(p_rec.attribute8, hr_api.g_varchar2) or
341: nvl(pay_opm_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
342: nvl(p_rec.attribute9, hr_api.g_varchar2) or
343: nvl(pay_opm_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

Line 341: nvl(pay_opm_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

337: nvl(pay_opm_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
338: nvl(p_rec.attribute7, hr_api.g_varchar2) or
339: nvl(pay_opm_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
340: nvl(p_rec.attribute8, hr_api.g_varchar2) or
341: nvl(pay_opm_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
342: nvl(p_rec.attribute9, hr_api.g_varchar2) or
343: nvl(pay_opm_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
344: nvl(p_rec.attribute10, hr_api.g_varchar2) or
345: nvl(pay_opm_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

Line 343: nvl(pay_opm_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

339: nvl(pay_opm_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
340: nvl(p_rec.attribute8, hr_api.g_varchar2) or
341: nvl(pay_opm_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
342: nvl(p_rec.attribute9, hr_api.g_varchar2) or
343: nvl(pay_opm_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
344: nvl(p_rec.attribute10, hr_api.g_varchar2) or
345: nvl(pay_opm_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
346: nvl(p_rec.attribute11, hr_api.g_varchar2) or
347: nvl(pay_opm_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

Line 345: nvl(pay_opm_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

341: nvl(pay_opm_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
342: nvl(p_rec.attribute9, hr_api.g_varchar2) or
343: nvl(pay_opm_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
344: nvl(p_rec.attribute10, hr_api.g_varchar2) or
345: nvl(pay_opm_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
346: nvl(p_rec.attribute11, hr_api.g_varchar2) or
347: nvl(pay_opm_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
348: nvl(p_rec.attribute12, hr_api.g_varchar2) or
349: nvl(pay_opm_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

Line 347: nvl(pay_opm_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

343: nvl(pay_opm_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
344: nvl(p_rec.attribute10, hr_api.g_varchar2) or
345: nvl(pay_opm_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
346: nvl(p_rec.attribute11, hr_api.g_varchar2) or
347: nvl(pay_opm_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
348: nvl(p_rec.attribute12, hr_api.g_varchar2) or
349: nvl(pay_opm_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
350: nvl(p_rec.attribute13, hr_api.g_varchar2) or
351: nvl(pay_opm_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

Line 349: nvl(pay_opm_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

345: nvl(pay_opm_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
346: nvl(p_rec.attribute11, hr_api.g_varchar2) or
347: nvl(pay_opm_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
348: nvl(p_rec.attribute12, hr_api.g_varchar2) or
349: nvl(pay_opm_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
350: nvl(p_rec.attribute13, hr_api.g_varchar2) or
351: nvl(pay_opm_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
352: nvl(p_rec.attribute14, hr_api.g_varchar2) or
353: nvl(pay_opm_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

Line 351: nvl(pay_opm_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

347: nvl(pay_opm_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
348: nvl(p_rec.attribute12, hr_api.g_varchar2) or
349: nvl(pay_opm_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
350: nvl(p_rec.attribute13, hr_api.g_varchar2) or
351: nvl(pay_opm_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
352: nvl(p_rec.attribute14, hr_api.g_varchar2) or
353: nvl(pay_opm_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
354: nvl(p_rec.attribute15, hr_api.g_varchar2) or
355: nvl(pay_opm_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

Line 353: nvl(pay_opm_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

349: nvl(pay_opm_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
350: nvl(p_rec.attribute13, hr_api.g_varchar2) or
351: nvl(pay_opm_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
352: nvl(p_rec.attribute14, hr_api.g_varchar2) or
353: nvl(pay_opm_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
354: nvl(p_rec.attribute15, hr_api.g_varchar2) or
355: nvl(pay_opm_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
356: nvl(p_rec.attribute16, hr_api.g_varchar2) or
357: nvl(pay_opm_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

Line 355: nvl(pay_opm_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

351: nvl(pay_opm_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
352: nvl(p_rec.attribute14, hr_api.g_varchar2) or
353: nvl(pay_opm_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
354: nvl(p_rec.attribute15, hr_api.g_varchar2) or
355: nvl(pay_opm_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
356: nvl(p_rec.attribute16, hr_api.g_varchar2) or
357: nvl(pay_opm_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
358: nvl(p_rec.attribute17, hr_api.g_varchar2) or
359: nvl(pay_opm_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

Line 357: nvl(pay_opm_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

353: nvl(pay_opm_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
354: nvl(p_rec.attribute15, hr_api.g_varchar2) or
355: nvl(pay_opm_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
356: nvl(p_rec.attribute16, hr_api.g_varchar2) or
357: nvl(pay_opm_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
358: nvl(p_rec.attribute17, hr_api.g_varchar2) or
359: nvl(pay_opm_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
360: nvl(p_rec.attribute18, hr_api.g_varchar2) or
361: nvl(pay_opm_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

Line 359: nvl(pay_opm_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

355: nvl(pay_opm_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
356: nvl(p_rec.attribute16, hr_api.g_varchar2) or
357: nvl(pay_opm_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
358: nvl(p_rec.attribute17, hr_api.g_varchar2) or
359: nvl(pay_opm_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
360: nvl(p_rec.attribute18, hr_api.g_varchar2) or
361: nvl(pay_opm_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
362: nvl(p_rec.attribute19, hr_api.g_varchar2) or
363: nvl(pay_opm_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

Line 361: nvl(pay_opm_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

357: nvl(pay_opm_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
358: nvl(p_rec.attribute17, hr_api.g_varchar2) or
359: nvl(pay_opm_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
360: nvl(p_rec.attribute18, hr_api.g_varchar2) or
361: nvl(pay_opm_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
362: nvl(p_rec.attribute19, hr_api.g_varchar2) or
363: nvl(pay_opm_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
364: nvl(p_rec.attribute20, hr_api.g_varchar2) ))
365: or (p_rec.org_payment_method_id is null) then

Line 363: nvl(pay_opm_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

359: nvl(pay_opm_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
360: nvl(p_rec.attribute18, hr_api.g_varchar2) or
361: nvl(pay_opm_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
362: nvl(p_rec.attribute19, hr_api.g_varchar2) or
363: nvl(pay_opm_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
364: nvl(p_rec.attribute20, hr_api.g_varchar2) ))
365: or (p_rec.org_payment_method_id is null) then
366: --
367: -- Only execute the validation if absolutely necessary:

Line 451: ,p_rec in pay_opm_shd.g_rec_type

447: -- {End Of Comments}
448: -- ----------------------------------------------------------------------------
449: Procedure chk_non_updateable_args
450: (p_effective_date in date
451: ,p_rec in pay_opm_shd.g_rec_type
452: ) IS
453: --
454: l_proc varchar2(72) := g_package || 'chk_non_updateable_args';
455: l_error EXCEPTION;

Line 465: IF NOT pay_opm_shd.api_updating

461: --
462: -- Only proceed with the validation if a row exists for the current
463: -- record in the HR Schema.
464: --
465: IF NOT pay_opm_shd.api_updating
466: (p_org_payment_method_id => p_rec.org_payment_method_id
467: ,p_effective_date => p_effective_date
468: ,p_object_version_number => p_rec.object_version_number
469: ) THEN

Line 479: pay_opm_shd.g_old_rec.business_group_id then

475: --
476: hr_utility.set_location(l_proc, 10);
477: --
478: if nvl(p_rec.business_group_id, hr_api.g_number) <>
479: pay_opm_shd.g_old_rec.business_group_id then
480: l_argument := 'business_group_id';
481: raise l_error;
482: end if;
483: --

Line 487: pay_opm_shd.g_old_rec.payment_type_id then

483: --
484: hr_utility.set_location(l_proc, 20);
485: --
486: if nvl(p_rec.payment_type_id, hr_api.g_number) <>
487: pay_opm_shd.g_old_rec.payment_type_id then
488: l_argument := 'payment_type_id';
489: raise l_error;
490: end if;
491: --

Line 495: nvl(pay_opm_shd.g_old_rec.defined_balance_id, hr_api.g_number) then

491: --
492: hr_utility.set_location(l_proc, 30);
493: --
494: if nvl(p_rec.defined_balance_id, hr_api.g_number) <>
495: nvl(pay_opm_shd.g_old_rec.defined_balance_id, hr_api.g_number) then
496: l_argument := 'defined_balance_id';
497: raise l_error;
498: end if;
499: --

Line 503: nvl(pay_opm_shd.g_old_rec.org_payment_method_name, hr_api.g_varchar2) then

499: --
500: hr_utility.set_location(l_proc, 35);
501: --
502: if nvl(p_rec.org_payment_method_name, hr_api.g_varchar2) <>
503: nvl(pay_opm_shd.g_old_rec.org_payment_method_name, hr_api.g_varchar2) then
504: l_argument := 'org_payment_method_name';
505: raise l_error;
506: end if;
507: --

Line 869: l_api_updating := pay_opm_shd.api_updating

865: ,p_argument => 'external_account_id'
866: ,p_argument_value => p_external_account_id
867: );
868: --
869: l_api_updating := pay_opm_shd.api_updating
870: (p_effective_date => p_effective_date,
871: p_org_payment_method_id => p_org_payment_method_id,
872: p_object_version_number => p_object_version_number
873: );

Line 880: nvl(pay_opm_shd.g_old_rec.external_account_id,hr_api.g_number) <>

876: --
877: -- Only proceed with SQL validation if absolutely necessary
878: --
879: if ((l_api_updating and
880: nvl(pay_opm_shd.g_old_rec.external_account_id,hr_api.g_number) <>
881: nvl(p_external_account_id,hr_api.g_number))
882: or (NOT l_api_updating)) then
883: --
884: hr_utility.set_location(l_proc,20);

Line 893: pay_opm_shd.constraint_error('PAY_ORG_PAYMENT_METHODS_F_FK2');

889: open csr_ext_acc_id_exists;
890: fetch csr_ext_acc_id_exists into l_dummy;
891: if csr_ext_acc_id_exists%notfound then
892: close csr_ext_acc_id_exists;
893: pay_opm_shd.constraint_error('PAY_ORG_PAYMENT_METHODS_F_FK2');
894: end if;
895: close csr_ext_acc_id_exists;
896: --
897: hr_utility.set_location(l_proc,30);

Line 985: l_api_updating := pay_opm_shd.api_updating

981: ,p_argument => 'effective_date'
982: ,p_argument_value => p_effective_date
983: );
984: --
985: l_api_updating := pay_opm_shd.api_updating
986: (p_effective_date => p_effective_date,
987: p_org_payment_method_id => p_org_payment_method_id,
988: p_object_version_number => p_object_version_number
989: );

Line 996: nvl(pay_opm_shd.g_old_rec.currency_code,hr_api.g_varchar2) <>

992: --
993: -- Only proceed with SQL validation if absolutely necessary
994: --
995: if ((l_api_updating and
996: nvl(pay_opm_shd.g_old_rec.currency_code,hr_api.g_varchar2) <>
997: nvl(p_currency_code,hr_api.g_varchar2))
998: or (NOT l_api_updating)) then
999: --
1000: hr_utility.set_location(l_proc,20);

Line 1886: (p_rec in pay_opm_shd.g_rec_type

1882: -- ----------------------------------------------------------------------------
1883: -- |---------------------------< insert_validate >----------------------------|
1884: -- ----------------------------------------------------------------------------
1885: Procedure insert_validate
1886: (p_rec in pay_opm_shd.g_rec_type
1887: ,p_effective_date in date
1888: ,p_datetrack_mode in varchar2
1889: ,p_validation_start_date in date
1890: ,p_validation_end_date in date

Line 1990: (p_rec in pay_opm_shd.g_rec_type

1986: -- ----------------------------------------------------------------------------
1987: -- |---------------------------< update_validate >----------------------------|
1988: -- ----------------------------------------------------------------------------
1989: Procedure update_validate
1990: (p_rec in pay_opm_shd.g_rec_type
1991: ,p_effective_date in date
1992: ,p_datetrack_mode in varchar2
1993: ,p_validation_start_date in date
1994: ,p_validation_end_date in date

Line 2096: (p_rec in pay_opm_shd.g_rec_type

2092: -- ----------------------------------------------------------------------------
2093: -- |---------------------------< delete_validate >----------------------------|
2094: -- ----------------------------------------------------------------------------
2095: Procedure delete_validate
2096: (p_rec in pay_opm_shd.g_rec_type
2097: ,p_effective_date in date
2098: ,p_datetrack_mode in varchar2
2099: ,p_validation_start_date in date
2100: ,p_validation_end_date in date