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.BEN_PDT_BUS dependencies on BEN_PDT_SHD

Line 189: (p_rec in ben_pdt_shd.g_rec_type

185: -- Internal Row Handler Use Only.
186: --
187: -- ----------------------------------------------------------------------------
188: procedure chk_df
189: (p_rec in ben_pdt_shd.g_rec_type
190: ) is
191: --
192: l_proc varchar2(72) := g_package || 'chk_df';
193: --

Line 198: nvl(ben_pdt_shd.g_old_rec.pdt_attribute_category, hr_api.g_varchar2) <>

194: begin
195: hr_utility.set_location('Entering:'||l_proc,10);
196: --
197: if ((p_rec.pymt_check_det_id is not null) and (
198: nvl(ben_pdt_shd.g_old_rec.pdt_attribute_category, hr_api.g_varchar2) <>
199: nvl(p_rec.pdt_attribute_category, hr_api.g_varchar2) or
200: nvl(ben_pdt_shd.g_old_rec.pdt_attribute1, hr_api.g_varchar2) <>
201: nvl(p_rec.pdt_attribute1, hr_api.g_varchar2) or
202: nvl(ben_pdt_shd.g_old_rec.pdt_attribute2, hr_api.g_varchar2) <>

Line 200: nvl(ben_pdt_shd.g_old_rec.pdt_attribute1, hr_api.g_varchar2) <>

196: --
197: if ((p_rec.pymt_check_det_id is not null) and (
198: nvl(ben_pdt_shd.g_old_rec.pdt_attribute_category, hr_api.g_varchar2) <>
199: nvl(p_rec.pdt_attribute_category, hr_api.g_varchar2) or
200: nvl(ben_pdt_shd.g_old_rec.pdt_attribute1, hr_api.g_varchar2) <>
201: nvl(p_rec.pdt_attribute1, hr_api.g_varchar2) or
202: nvl(ben_pdt_shd.g_old_rec.pdt_attribute2, hr_api.g_varchar2) <>
203: nvl(p_rec.pdt_attribute2, hr_api.g_varchar2) or
204: nvl(ben_pdt_shd.g_old_rec.pdt_attribute3, hr_api.g_varchar2) <>

Line 202: nvl(ben_pdt_shd.g_old_rec.pdt_attribute2, hr_api.g_varchar2) <>

198: nvl(ben_pdt_shd.g_old_rec.pdt_attribute_category, hr_api.g_varchar2) <>
199: nvl(p_rec.pdt_attribute_category, hr_api.g_varchar2) or
200: nvl(ben_pdt_shd.g_old_rec.pdt_attribute1, hr_api.g_varchar2) <>
201: nvl(p_rec.pdt_attribute1, hr_api.g_varchar2) or
202: nvl(ben_pdt_shd.g_old_rec.pdt_attribute2, hr_api.g_varchar2) <>
203: nvl(p_rec.pdt_attribute2, hr_api.g_varchar2) or
204: nvl(ben_pdt_shd.g_old_rec.pdt_attribute3, hr_api.g_varchar2) <>
205: nvl(p_rec.pdt_attribute3, hr_api.g_varchar2) or
206: nvl(ben_pdt_shd.g_old_rec.pdt_attribute4, hr_api.g_varchar2) <>

Line 204: nvl(ben_pdt_shd.g_old_rec.pdt_attribute3, hr_api.g_varchar2) <>

200: nvl(ben_pdt_shd.g_old_rec.pdt_attribute1, hr_api.g_varchar2) <>
201: nvl(p_rec.pdt_attribute1, hr_api.g_varchar2) or
202: nvl(ben_pdt_shd.g_old_rec.pdt_attribute2, hr_api.g_varchar2) <>
203: nvl(p_rec.pdt_attribute2, hr_api.g_varchar2) or
204: nvl(ben_pdt_shd.g_old_rec.pdt_attribute3, hr_api.g_varchar2) <>
205: nvl(p_rec.pdt_attribute3, hr_api.g_varchar2) or
206: nvl(ben_pdt_shd.g_old_rec.pdt_attribute4, hr_api.g_varchar2) <>
207: nvl(p_rec.pdt_attribute4, hr_api.g_varchar2) or
208: nvl(ben_pdt_shd.g_old_rec.pdt_attribute5, hr_api.g_varchar2) <>

Line 206: nvl(ben_pdt_shd.g_old_rec.pdt_attribute4, hr_api.g_varchar2) <>

202: nvl(ben_pdt_shd.g_old_rec.pdt_attribute2, hr_api.g_varchar2) <>
203: nvl(p_rec.pdt_attribute2, hr_api.g_varchar2) or
204: nvl(ben_pdt_shd.g_old_rec.pdt_attribute3, hr_api.g_varchar2) <>
205: nvl(p_rec.pdt_attribute3, hr_api.g_varchar2) or
206: nvl(ben_pdt_shd.g_old_rec.pdt_attribute4, hr_api.g_varchar2) <>
207: nvl(p_rec.pdt_attribute4, hr_api.g_varchar2) or
208: nvl(ben_pdt_shd.g_old_rec.pdt_attribute5, hr_api.g_varchar2) <>
209: nvl(p_rec.pdt_attribute5, hr_api.g_varchar2) or
210: nvl(ben_pdt_shd.g_old_rec.pdt_attribute6, hr_api.g_varchar2) <>

Line 208: nvl(ben_pdt_shd.g_old_rec.pdt_attribute5, hr_api.g_varchar2) <>

204: nvl(ben_pdt_shd.g_old_rec.pdt_attribute3, hr_api.g_varchar2) <>
205: nvl(p_rec.pdt_attribute3, hr_api.g_varchar2) or
206: nvl(ben_pdt_shd.g_old_rec.pdt_attribute4, hr_api.g_varchar2) <>
207: nvl(p_rec.pdt_attribute4, hr_api.g_varchar2) or
208: nvl(ben_pdt_shd.g_old_rec.pdt_attribute5, hr_api.g_varchar2) <>
209: nvl(p_rec.pdt_attribute5, hr_api.g_varchar2) or
210: nvl(ben_pdt_shd.g_old_rec.pdt_attribute6, hr_api.g_varchar2) <>
211: nvl(p_rec.pdt_attribute6, hr_api.g_varchar2) or
212: nvl(ben_pdt_shd.g_old_rec.pdt_attribute7, hr_api.g_varchar2) <>

Line 210: nvl(ben_pdt_shd.g_old_rec.pdt_attribute6, hr_api.g_varchar2) <>

206: nvl(ben_pdt_shd.g_old_rec.pdt_attribute4, hr_api.g_varchar2) <>
207: nvl(p_rec.pdt_attribute4, hr_api.g_varchar2) or
208: nvl(ben_pdt_shd.g_old_rec.pdt_attribute5, hr_api.g_varchar2) <>
209: nvl(p_rec.pdt_attribute5, hr_api.g_varchar2) or
210: nvl(ben_pdt_shd.g_old_rec.pdt_attribute6, hr_api.g_varchar2) <>
211: nvl(p_rec.pdt_attribute6, hr_api.g_varchar2) or
212: nvl(ben_pdt_shd.g_old_rec.pdt_attribute7, hr_api.g_varchar2) <>
213: nvl(p_rec.pdt_attribute7, hr_api.g_varchar2) or
214: nvl(ben_pdt_shd.g_old_rec.pdt_attribute8, hr_api.g_varchar2) <>

Line 212: nvl(ben_pdt_shd.g_old_rec.pdt_attribute7, hr_api.g_varchar2) <>

208: nvl(ben_pdt_shd.g_old_rec.pdt_attribute5, hr_api.g_varchar2) <>
209: nvl(p_rec.pdt_attribute5, hr_api.g_varchar2) or
210: nvl(ben_pdt_shd.g_old_rec.pdt_attribute6, hr_api.g_varchar2) <>
211: nvl(p_rec.pdt_attribute6, hr_api.g_varchar2) or
212: nvl(ben_pdt_shd.g_old_rec.pdt_attribute7, hr_api.g_varchar2) <>
213: nvl(p_rec.pdt_attribute7, hr_api.g_varchar2) or
214: nvl(ben_pdt_shd.g_old_rec.pdt_attribute8, hr_api.g_varchar2) <>
215: nvl(p_rec.pdt_attribute8, hr_api.g_varchar2) or
216: nvl(ben_pdt_shd.g_old_rec.pdt_attribute9, hr_api.g_varchar2) <>

Line 214: nvl(ben_pdt_shd.g_old_rec.pdt_attribute8, hr_api.g_varchar2) <>

210: nvl(ben_pdt_shd.g_old_rec.pdt_attribute6, hr_api.g_varchar2) <>
211: nvl(p_rec.pdt_attribute6, hr_api.g_varchar2) or
212: nvl(ben_pdt_shd.g_old_rec.pdt_attribute7, hr_api.g_varchar2) <>
213: nvl(p_rec.pdt_attribute7, hr_api.g_varchar2) or
214: nvl(ben_pdt_shd.g_old_rec.pdt_attribute8, hr_api.g_varchar2) <>
215: nvl(p_rec.pdt_attribute8, hr_api.g_varchar2) or
216: nvl(ben_pdt_shd.g_old_rec.pdt_attribute9, hr_api.g_varchar2) <>
217: nvl(p_rec.pdt_attribute9, hr_api.g_varchar2) or
218: nvl(ben_pdt_shd.g_old_rec.pdt_attribute10, hr_api.g_varchar2) <>

Line 216: nvl(ben_pdt_shd.g_old_rec.pdt_attribute9, hr_api.g_varchar2) <>

212: nvl(ben_pdt_shd.g_old_rec.pdt_attribute7, hr_api.g_varchar2) <>
213: nvl(p_rec.pdt_attribute7, hr_api.g_varchar2) or
214: nvl(ben_pdt_shd.g_old_rec.pdt_attribute8, hr_api.g_varchar2) <>
215: nvl(p_rec.pdt_attribute8, hr_api.g_varchar2) or
216: nvl(ben_pdt_shd.g_old_rec.pdt_attribute9, hr_api.g_varchar2) <>
217: nvl(p_rec.pdt_attribute9, hr_api.g_varchar2) or
218: nvl(ben_pdt_shd.g_old_rec.pdt_attribute10, hr_api.g_varchar2) <>
219: nvl(p_rec.pdt_attribute10, hr_api.g_varchar2) or
220: nvl(ben_pdt_shd.g_old_rec.pdt_attribute11, hr_api.g_varchar2) <>

Line 218: nvl(ben_pdt_shd.g_old_rec.pdt_attribute10, hr_api.g_varchar2) <>

214: nvl(ben_pdt_shd.g_old_rec.pdt_attribute8, hr_api.g_varchar2) <>
215: nvl(p_rec.pdt_attribute8, hr_api.g_varchar2) or
216: nvl(ben_pdt_shd.g_old_rec.pdt_attribute9, hr_api.g_varchar2) <>
217: nvl(p_rec.pdt_attribute9, hr_api.g_varchar2) or
218: nvl(ben_pdt_shd.g_old_rec.pdt_attribute10, hr_api.g_varchar2) <>
219: nvl(p_rec.pdt_attribute10, hr_api.g_varchar2) or
220: nvl(ben_pdt_shd.g_old_rec.pdt_attribute11, hr_api.g_varchar2) <>
221: nvl(p_rec.pdt_attribute11, hr_api.g_varchar2) or
222: nvl(ben_pdt_shd.g_old_rec.pdt_attribute12, hr_api.g_varchar2) <>

Line 220: nvl(ben_pdt_shd.g_old_rec.pdt_attribute11, hr_api.g_varchar2) <>

216: nvl(ben_pdt_shd.g_old_rec.pdt_attribute9, hr_api.g_varchar2) <>
217: nvl(p_rec.pdt_attribute9, hr_api.g_varchar2) or
218: nvl(ben_pdt_shd.g_old_rec.pdt_attribute10, hr_api.g_varchar2) <>
219: nvl(p_rec.pdt_attribute10, hr_api.g_varchar2) or
220: nvl(ben_pdt_shd.g_old_rec.pdt_attribute11, hr_api.g_varchar2) <>
221: nvl(p_rec.pdt_attribute11, hr_api.g_varchar2) or
222: nvl(ben_pdt_shd.g_old_rec.pdt_attribute12, hr_api.g_varchar2) <>
223: nvl(p_rec.pdt_attribute12, hr_api.g_varchar2) or
224: nvl(ben_pdt_shd.g_old_rec.pdt_attribute13, hr_api.g_varchar2) <>

Line 222: nvl(ben_pdt_shd.g_old_rec.pdt_attribute12, hr_api.g_varchar2) <>

218: nvl(ben_pdt_shd.g_old_rec.pdt_attribute10, hr_api.g_varchar2) <>
219: nvl(p_rec.pdt_attribute10, hr_api.g_varchar2) or
220: nvl(ben_pdt_shd.g_old_rec.pdt_attribute11, hr_api.g_varchar2) <>
221: nvl(p_rec.pdt_attribute11, hr_api.g_varchar2) or
222: nvl(ben_pdt_shd.g_old_rec.pdt_attribute12, hr_api.g_varchar2) <>
223: nvl(p_rec.pdt_attribute12, hr_api.g_varchar2) or
224: nvl(ben_pdt_shd.g_old_rec.pdt_attribute13, hr_api.g_varchar2) <>
225: nvl(p_rec.pdt_attribute13, hr_api.g_varchar2) or
226: nvl(ben_pdt_shd.g_old_rec.pdt_attribute14, hr_api.g_varchar2) <>

Line 224: nvl(ben_pdt_shd.g_old_rec.pdt_attribute13, hr_api.g_varchar2) <>

220: nvl(ben_pdt_shd.g_old_rec.pdt_attribute11, hr_api.g_varchar2) <>
221: nvl(p_rec.pdt_attribute11, hr_api.g_varchar2) or
222: nvl(ben_pdt_shd.g_old_rec.pdt_attribute12, hr_api.g_varchar2) <>
223: nvl(p_rec.pdt_attribute12, hr_api.g_varchar2) or
224: nvl(ben_pdt_shd.g_old_rec.pdt_attribute13, hr_api.g_varchar2) <>
225: nvl(p_rec.pdt_attribute13, hr_api.g_varchar2) or
226: nvl(ben_pdt_shd.g_old_rec.pdt_attribute14, hr_api.g_varchar2) <>
227: nvl(p_rec.pdt_attribute14, hr_api.g_varchar2) or
228: nvl(ben_pdt_shd.g_old_rec.pdt_attribute15, hr_api.g_varchar2) <>

Line 226: nvl(ben_pdt_shd.g_old_rec.pdt_attribute14, hr_api.g_varchar2) <>

222: nvl(ben_pdt_shd.g_old_rec.pdt_attribute12, hr_api.g_varchar2) <>
223: nvl(p_rec.pdt_attribute12, hr_api.g_varchar2) or
224: nvl(ben_pdt_shd.g_old_rec.pdt_attribute13, hr_api.g_varchar2) <>
225: nvl(p_rec.pdt_attribute13, hr_api.g_varchar2) or
226: nvl(ben_pdt_shd.g_old_rec.pdt_attribute14, hr_api.g_varchar2) <>
227: nvl(p_rec.pdt_attribute14, hr_api.g_varchar2) or
228: nvl(ben_pdt_shd.g_old_rec.pdt_attribute15, hr_api.g_varchar2) <>
229: nvl(p_rec.pdt_attribute15, hr_api.g_varchar2) or
230: nvl(ben_pdt_shd.g_old_rec.pdt_attribute16, hr_api.g_varchar2) <>

Line 228: nvl(ben_pdt_shd.g_old_rec.pdt_attribute15, hr_api.g_varchar2) <>

224: nvl(ben_pdt_shd.g_old_rec.pdt_attribute13, hr_api.g_varchar2) <>
225: nvl(p_rec.pdt_attribute13, hr_api.g_varchar2) or
226: nvl(ben_pdt_shd.g_old_rec.pdt_attribute14, hr_api.g_varchar2) <>
227: nvl(p_rec.pdt_attribute14, hr_api.g_varchar2) or
228: nvl(ben_pdt_shd.g_old_rec.pdt_attribute15, hr_api.g_varchar2) <>
229: nvl(p_rec.pdt_attribute15, hr_api.g_varchar2) or
230: nvl(ben_pdt_shd.g_old_rec.pdt_attribute16, hr_api.g_varchar2) <>
231: nvl(p_rec.pdt_attribute16, hr_api.g_varchar2) or
232: nvl(ben_pdt_shd.g_old_rec.pdt_attribute17, hr_api.g_varchar2) <>

Line 230: nvl(ben_pdt_shd.g_old_rec.pdt_attribute16, hr_api.g_varchar2) <>

226: nvl(ben_pdt_shd.g_old_rec.pdt_attribute14, hr_api.g_varchar2) <>
227: nvl(p_rec.pdt_attribute14, hr_api.g_varchar2) or
228: nvl(ben_pdt_shd.g_old_rec.pdt_attribute15, hr_api.g_varchar2) <>
229: nvl(p_rec.pdt_attribute15, hr_api.g_varchar2) or
230: nvl(ben_pdt_shd.g_old_rec.pdt_attribute16, hr_api.g_varchar2) <>
231: nvl(p_rec.pdt_attribute16, hr_api.g_varchar2) or
232: nvl(ben_pdt_shd.g_old_rec.pdt_attribute17, hr_api.g_varchar2) <>
233: nvl(p_rec.pdt_attribute17, hr_api.g_varchar2) or
234: nvl(ben_pdt_shd.g_old_rec.pdt_attribute18, hr_api.g_varchar2) <>

Line 232: nvl(ben_pdt_shd.g_old_rec.pdt_attribute17, hr_api.g_varchar2) <>

228: nvl(ben_pdt_shd.g_old_rec.pdt_attribute15, hr_api.g_varchar2) <>
229: nvl(p_rec.pdt_attribute15, hr_api.g_varchar2) or
230: nvl(ben_pdt_shd.g_old_rec.pdt_attribute16, hr_api.g_varchar2) <>
231: nvl(p_rec.pdt_attribute16, hr_api.g_varchar2) or
232: nvl(ben_pdt_shd.g_old_rec.pdt_attribute17, hr_api.g_varchar2) <>
233: nvl(p_rec.pdt_attribute17, hr_api.g_varchar2) or
234: nvl(ben_pdt_shd.g_old_rec.pdt_attribute18, hr_api.g_varchar2) <>
235: nvl(p_rec.pdt_attribute18, hr_api.g_varchar2) or
236: nvl(ben_pdt_shd.g_old_rec.pdt_attribute19, hr_api.g_varchar2) <>

Line 234: nvl(ben_pdt_shd.g_old_rec.pdt_attribute18, hr_api.g_varchar2) <>

230: nvl(ben_pdt_shd.g_old_rec.pdt_attribute16, hr_api.g_varchar2) <>
231: nvl(p_rec.pdt_attribute16, hr_api.g_varchar2) or
232: nvl(ben_pdt_shd.g_old_rec.pdt_attribute17, hr_api.g_varchar2) <>
233: nvl(p_rec.pdt_attribute17, hr_api.g_varchar2) or
234: nvl(ben_pdt_shd.g_old_rec.pdt_attribute18, hr_api.g_varchar2) <>
235: nvl(p_rec.pdt_attribute18, hr_api.g_varchar2) or
236: nvl(ben_pdt_shd.g_old_rec.pdt_attribute19, hr_api.g_varchar2) <>
237: nvl(p_rec.pdt_attribute19, hr_api.g_varchar2) or
238: nvl(ben_pdt_shd.g_old_rec.pdt_attribute20, hr_api.g_varchar2) <>

Line 236: nvl(ben_pdt_shd.g_old_rec.pdt_attribute19, hr_api.g_varchar2) <>

232: nvl(ben_pdt_shd.g_old_rec.pdt_attribute17, hr_api.g_varchar2) <>
233: nvl(p_rec.pdt_attribute17, hr_api.g_varchar2) or
234: nvl(ben_pdt_shd.g_old_rec.pdt_attribute18, hr_api.g_varchar2) <>
235: nvl(p_rec.pdt_attribute18, hr_api.g_varchar2) or
236: nvl(ben_pdt_shd.g_old_rec.pdt_attribute19, hr_api.g_varchar2) <>
237: nvl(p_rec.pdt_attribute19, hr_api.g_varchar2) or
238: nvl(ben_pdt_shd.g_old_rec.pdt_attribute20, hr_api.g_varchar2) <>
239: nvl(p_rec.pdt_attribute20, hr_api.g_varchar2) or
240: nvl(ben_pdt_shd.g_old_rec.pdt_attribute21, hr_api.g_varchar2) <>

Line 238: nvl(ben_pdt_shd.g_old_rec.pdt_attribute20, hr_api.g_varchar2) <>

234: nvl(ben_pdt_shd.g_old_rec.pdt_attribute18, hr_api.g_varchar2) <>
235: nvl(p_rec.pdt_attribute18, hr_api.g_varchar2) or
236: nvl(ben_pdt_shd.g_old_rec.pdt_attribute19, hr_api.g_varchar2) <>
237: nvl(p_rec.pdt_attribute19, hr_api.g_varchar2) or
238: nvl(ben_pdt_shd.g_old_rec.pdt_attribute20, hr_api.g_varchar2) <>
239: nvl(p_rec.pdt_attribute20, hr_api.g_varchar2) or
240: nvl(ben_pdt_shd.g_old_rec.pdt_attribute21, hr_api.g_varchar2) <>
241: nvl(p_rec.pdt_attribute21, hr_api.g_varchar2) or
242: nvl(ben_pdt_shd.g_old_rec.pdt_attribute22, hr_api.g_varchar2) <>

Line 240: nvl(ben_pdt_shd.g_old_rec.pdt_attribute21, hr_api.g_varchar2) <>

236: nvl(ben_pdt_shd.g_old_rec.pdt_attribute19, hr_api.g_varchar2) <>
237: nvl(p_rec.pdt_attribute19, hr_api.g_varchar2) or
238: nvl(ben_pdt_shd.g_old_rec.pdt_attribute20, hr_api.g_varchar2) <>
239: nvl(p_rec.pdt_attribute20, hr_api.g_varchar2) or
240: nvl(ben_pdt_shd.g_old_rec.pdt_attribute21, hr_api.g_varchar2) <>
241: nvl(p_rec.pdt_attribute21, hr_api.g_varchar2) or
242: nvl(ben_pdt_shd.g_old_rec.pdt_attribute22, hr_api.g_varchar2) <>
243: nvl(p_rec.pdt_attribute22, hr_api.g_varchar2) or
244: nvl(ben_pdt_shd.g_old_rec.pdt_attribute23, hr_api.g_varchar2) <>

Line 242: nvl(ben_pdt_shd.g_old_rec.pdt_attribute22, hr_api.g_varchar2) <>

238: nvl(ben_pdt_shd.g_old_rec.pdt_attribute20, hr_api.g_varchar2) <>
239: nvl(p_rec.pdt_attribute20, hr_api.g_varchar2) or
240: nvl(ben_pdt_shd.g_old_rec.pdt_attribute21, hr_api.g_varchar2) <>
241: nvl(p_rec.pdt_attribute21, hr_api.g_varchar2) or
242: nvl(ben_pdt_shd.g_old_rec.pdt_attribute22, hr_api.g_varchar2) <>
243: nvl(p_rec.pdt_attribute22, hr_api.g_varchar2) or
244: nvl(ben_pdt_shd.g_old_rec.pdt_attribute23, hr_api.g_varchar2) <>
245: nvl(p_rec.pdt_attribute23, hr_api.g_varchar2) or
246: nvl(ben_pdt_shd.g_old_rec.pdt_attribute24, hr_api.g_varchar2) <>

Line 244: nvl(ben_pdt_shd.g_old_rec.pdt_attribute23, hr_api.g_varchar2) <>

240: nvl(ben_pdt_shd.g_old_rec.pdt_attribute21, hr_api.g_varchar2) <>
241: nvl(p_rec.pdt_attribute21, hr_api.g_varchar2) or
242: nvl(ben_pdt_shd.g_old_rec.pdt_attribute22, hr_api.g_varchar2) <>
243: nvl(p_rec.pdt_attribute22, hr_api.g_varchar2) or
244: nvl(ben_pdt_shd.g_old_rec.pdt_attribute23, hr_api.g_varchar2) <>
245: nvl(p_rec.pdt_attribute23, hr_api.g_varchar2) or
246: nvl(ben_pdt_shd.g_old_rec.pdt_attribute24, hr_api.g_varchar2) <>
247: nvl(p_rec.pdt_attribute24, hr_api.g_varchar2) or
248: nvl(ben_pdt_shd.g_old_rec.pdt_attribute25, hr_api.g_varchar2) <>

Line 246: nvl(ben_pdt_shd.g_old_rec.pdt_attribute24, hr_api.g_varchar2) <>

242: nvl(ben_pdt_shd.g_old_rec.pdt_attribute22, hr_api.g_varchar2) <>
243: nvl(p_rec.pdt_attribute22, hr_api.g_varchar2) or
244: nvl(ben_pdt_shd.g_old_rec.pdt_attribute23, hr_api.g_varchar2) <>
245: nvl(p_rec.pdt_attribute23, hr_api.g_varchar2) or
246: nvl(ben_pdt_shd.g_old_rec.pdt_attribute24, hr_api.g_varchar2) <>
247: nvl(p_rec.pdt_attribute24, hr_api.g_varchar2) or
248: nvl(ben_pdt_shd.g_old_rec.pdt_attribute25, hr_api.g_varchar2) <>
249: nvl(p_rec.pdt_attribute25, hr_api.g_varchar2) or
250: nvl(ben_pdt_shd.g_old_rec.pdt_attribute26, hr_api.g_varchar2) <>

Line 248: nvl(ben_pdt_shd.g_old_rec.pdt_attribute25, hr_api.g_varchar2) <>

244: nvl(ben_pdt_shd.g_old_rec.pdt_attribute23, hr_api.g_varchar2) <>
245: nvl(p_rec.pdt_attribute23, hr_api.g_varchar2) or
246: nvl(ben_pdt_shd.g_old_rec.pdt_attribute24, hr_api.g_varchar2) <>
247: nvl(p_rec.pdt_attribute24, hr_api.g_varchar2) or
248: nvl(ben_pdt_shd.g_old_rec.pdt_attribute25, hr_api.g_varchar2) <>
249: nvl(p_rec.pdt_attribute25, hr_api.g_varchar2) or
250: nvl(ben_pdt_shd.g_old_rec.pdt_attribute26, hr_api.g_varchar2) <>
251: nvl(p_rec.pdt_attribute26, hr_api.g_varchar2) or
252: nvl(ben_pdt_shd.g_old_rec.pdt_attribute27, hr_api.g_varchar2) <>

Line 250: nvl(ben_pdt_shd.g_old_rec.pdt_attribute26, hr_api.g_varchar2) <>

246: nvl(ben_pdt_shd.g_old_rec.pdt_attribute24, hr_api.g_varchar2) <>
247: nvl(p_rec.pdt_attribute24, hr_api.g_varchar2) or
248: nvl(ben_pdt_shd.g_old_rec.pdt_attribute25, hr_api.g_varchar2) <>
249: nvl(p_rec.pdt_attribute25, hr_api.g_varchar2) or
250: nvl(ben_pdt_shd.g_old_rec.pdt_attribute26, hr_api.g_varchar2) <>
251: nvl(p_rec.pdt_attribute26, hr_api.g_varchar2) or
252: nvl(ben_pdt_shd.g_old_rec.pdt_attribute27, hr_api.g_varchar2) <>
253: nvl(p_rec.pdt_attribute27, hr_api.g_varchar2) or
254: nvl(ben_pdt_shd.g_old_rec.pdt_attribute28, hr_api.g_varchar2) <>

Line 252: nvl(ben_pdt_shd.g_old_rec.pdt_attribute27, hr_api.g_varchar2) <>

248: nvl(ben_pdt_shd.g_old_rec.pdt_attribute25, hr_api.g_varchar2) <>
249: nvl(p_rec.pdt_attribute25, hr_api.g_varchar2) or
250: nvl(ben_pdt_shd.g_old_rec.pdt_attribute26, hr_api.g_varchar2) <>
251: nvl(p_rec.pdt_attribute26, hr_api.g_varchar2) or
252: nvl(ben_pdt_shd.g_old_rec.pdt_attribute27, hr_api.g_varchar2) <>
253: nvl(p_rec.pdt_attribute27, hr_api.g_varchar2) or
254: nvl(ben_pdt_shd.g_old_rec.pdt_attribute28, hr_api.g_varchar2) <>
255: nvl(p_rec.pdt_attribute28, hr_api.g_varchar2) or
256: nvl(ben_pdt_shd.g_old_rec.pdt_attribute29, hr_api.g_varchar2) <>

Line 254: nvl(ben_pdt_shd.g_old_rec.pdt_attribute28, hr_api.g_varchar2) <>

250: nvl(ben_pdt_shd.g_old_rec.pdt_attribute26, hr_api.g_varchar2) <>
251: nvl(p_rec.pdt_attribute26, hr_api.g_varchar2) or
252: nvl(ben_pdt_shd.g_old_rec.pdt_attribute27, hr_api.g_varchar2) <>
253: nvl(p_rec.pdt_attribute27, hr_api.g_varchar2) or
254: nvl(ben_pdt_shd.g_old_rec.pdt_attribute28, hr_api.g_varchar2) <>
255: nvl(p_rec.pdt_attribute28, hr_api.g_varchar2) or
256: nvl(ben_pdt_shd.g_old_rec.pdt_attribute29, hr_api.g_varchar2) <>
257: nvl(p_rec.pdt_attribute29, hr_api.g_varchar2) or
258: nvl(ben_pdt_shd.g_old_rec.pdt_attribute30, hr_api.g_varchar2) <>

Line 256: nvl(ben_pdt_shd.g_old_rec.pdt_attribute29, hr_api.g_varchar2) <>

252: nvl(ben_pdt_shd.g_old_rec.pdt_attribute27, hr_api.g_varchar2) <>
253: nvl(p_rec.pdt_attribute27, hr_api.g_varchar2) or
254: nvl(ben_pdt_shd.g_old_rec.pdt_attribute28, hr_api.g_varchar2) <>
255: nvl(p_rec.pdt_attribute28, hr_api.g_varchar2) or
256: nvl(ben_pdt_shd.g_old_rec.pdt_attribute29, hr_api.g_varchar2) <>
257: nvl(p_rec.pdt_attribute29, hr_api.g_varchar2) or
258: nvl(ben_pdt_shd.g_old_rec.pdt_attribute30, hr_api.g_varchar2) <>
259: nvl(p_rec.pdt_attribute30, hr_api.g_varchar2) ))
260: or (p_rec.pymt_check_det_id is null) then

Line 258: nvl(ben_pdt_shd.g_old_rec.pdt_attribute30, hr_api.g_varchar2) <>

254: nvl(ben_pdt_shd.g_old_rec.pdt_attribute28, hr_api.g_varchar2) <>
255: nvl(p_rec.pdt_attribute28, hr_api.g_varchar2) or
256: nvl(ben_pdt_shd.g_old_rec.pdt_attribute29, hr_api.g_varchar2) <>
257: nvl(p_rec.pdt_attribute29, hr_api.g_varchar2) or
258: nvl(ben_pdt_shd.g_old_rec.pdt_attribute30, hr_api.g_varchar2) <>
259: nvl(p_rec.pdt_attribute30, hr_api.g_varchar2) ))
260: or (p_rec.pymt_check_det_id is null) then
261: --
262: -- Only execute the validation if absolutely necessary:

Line 366: ,p_rec in ben_pdt_shd.g_rec_type

362: -- {End Of Comments}
363: -- ----------------------------------------------------------------------------
364: Procedure chk_non_updateable_args
365: (p_effective_date in date
366: ,p_rec in ben_pdt_shd.g_rec_type
367: ) IS
368: --
369: l_proc varchar2(72) := g_package || 'chk_non_updateable_args';
370: --

Line 376: IF NOT ben_pdt_shd.api_updating

372: --
373: -- Only proceed with the validation if a row exists for the current
374: -- record in the HR Schema.
375: --
376: IF NOT ben_pdt_shd.api_updating
377: (p_pymt_check_det_id => p_rec.pymt_check_det_id
378: ,p_object_version_number => p_rec.object_version_number
379: ) THEN
380: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');

Line 387: nvl(ben_pdt_shd.g_old_rec.business_group_id,hr_api.g_number) then

383: fnd_message.raise_error;
384: END IF;
385:
386: IF nvl(p_rec.business_group_id,hr_api.g_number) <>
387: nvl(ben_pdt_shd.g_old_rec.business_group_id,hr_api.g_number) then
388:
389: hr_api.argument_changed_error
390: (p_api_name => l_proc,
391: p_argument => 'BUSINESS_GROUP_ID',

Line 392: p_base_table => ben_pdt_shd.g_tab_nam);

388:
389: hr_api.argument_changed_error
390: (p_api_name => l_proc,
391: p_argument => 'BUSINESS_GROUP_ID',
392: p_base_table => ben_pdt_shd.g_tab_nam);
393: END IF;
394: --
395: IF nvl(p_rec.person_id,hr_api.g_number) <>
396: nvl(ben_pdt_shd.g_old_rec.person_id,hr_api.g_number) then

Line 396: nvl(ben_pdt_shd.g_old_rec.person_id,hr_api.g_number) then

392: p_base_table => ben_pdt_shd.g_tab_nam);
393: END IF;
394: --
395: IF nvl(p_rec.person_id,hr_api.g_number) <>
396: nvl(ben_pdt_shd.g_old_rec.person_id,hr_api.g_number) then
397:
398: hr_api.argument_changed_error
399: (p_api_name => l_proc,
400: p_argument => 'PERSON_ID',

Line 401: p_base_table => ben_pdt_shd.g_tab_nam);

397:
398: hr_api.argument_changed_error
399: (p_api_name => l_proc,
400: p_argument => 'PERSON_ID',
401: p_base_table => ben_pdt_shd.g_tab_nam);
402: END IF;
403:
404: End chk_non_updateable_args;
405: --

Line 443: l_api_updating := ben_pdt_shd.api_updating

439: Begin
440: --
441: hr_utility.set_location('Entering:'||l_proc, 5);
442: --
443: l_api_updating := ben_pdt_shd.api_updating
444: (p_pymt_check_det_id => p_pymt_check_det_id,
445: p_object_version_number => p_object_version_number);
446: --
447: if (l_api_updating

Line 449: <> ben_pdt_shd.g_old_rec.pymt_check_det_id) then

445: p_object_version_number => p_object_version_number);
446: --
447: if (l_api_updating
448: and nvl(p_pymt_check_det_id,hr_api.g_number)
449: <> ben_pdt_shd.g_old_rec.pymt_check_det_id) then
450: --
451: -- raise error as PK has changed
452: --
453: ben_pty_shd.constraint_error('BEN_PYMT_CHECK_DET_PK');

Line 515: l_api_updating := ben_pdt_shd.api_updating

511: Begin
512: --
513: hr_utility.set_location('Entering:'||l_proc,5);
514: --
515: l_api_updating := ben_pdt_shd.api_updating
516: (p_pymt_check_det_id => p_pymt_check_det_id,
517: p_object_version_number => p_object_version_number);
518: --
519: if (l_api_updating

Line 521: <> nvl(ben_pdt_shd.g_old_rec.person_id,hr_api.g_number)

517: p_object_version_number => p_object_version_number);
518: --
519: if (l_api_updating
520: and nvl(p_person_id,hr_api.g_number)
521: <> nvl(ben_pdt_shd.g_old_rec.person_id,hr_api.g_number)
522: or not l_api_updating) then
523: --
524: -- check if person_id value exists in per_all_people_f table
525: --

Line 536: ben_pdt_shd.constraint_error('BEN_PYMT_CHECK_DET_FK2');

532: --
533: -- raise error as FK does not relate to PK in per_all_people_f
534: -- table.
535: --
536: ben_pdt_shd.constraint_error('BEN_PYMT_CHECK_DET_FK2');
537: --
538: end if;
539: --
540: close c1;

Line 553: ,p_rec in ben_pdt_shd.g_rec_type

549: -- |---------------------------< insert_validate >----------------------------|
550: -- ----------------------------------------------------------------------------
551: Procedure insert_validate
552: (p_effective_date in date
553: ,p_rec in ben_pdt_shd.g_rec_type
554: ) is
555: --
556: l_proc varchar2(72) := g_package||'insert_validate';
557: --

Line 565: ,p_associated_column1 => ben_pdt_shd.g_tab_nam

561: -- Call all supporting business operations
562: --
563: hr_api.validate_bus_grp_id
564: (p_business_group_id => p_rec.business_group_id
565: ,p_associated_column1 => ben_pdt_shd.g_tab_nam
566: || '.BUSINESS_GROUP_ID');
567: --
568: -- After validating the set of important attributes,
569: -- if Multiple Message detection is enabled and at least

Line 592: ,p_rec in ben_pdt_shd.g_rec_type

588: -- |---------------------------< update_validate >----------------------------|
589: -- ----------------------------------------------------------------------------
590: Procedure update_validate
591: (p_effective_date in date
592: ,p_rec in ben_pdt_shd.g_rec_type
593: ) is
594: --
595: l_proc varchar2(72) := g_package||'update_validate';
596: --

Line 604: ,p_associated_column1 => ben_pdt_shd.g_tab_nam

600: -- Call all supporting business operations
601: --
602: hr_api.validate_bus_grp_id
603: (p_business_group_id => p_rec.business_group_id
604: ,p_associated_column1 => ben_pdt_shd.g_tab_nam
605: || '.BUSINESS_GROUP_ID');
606: --
607: -- After validating the set of important attributes,
608: -- if Multiple Message detection is enabled and at least

Line 635: (p_rec in ben_pdt_shd.g_rec_type

631: -- ----------------------------------------------------------------------------
632: -- |---------------------------< delete_validate >----------------------------|
633: -- ----------------------------------------------------------------------------
634: Procedure delete_validate
635: (p_rec in ben_pdt_shd.g_rec_type
636: ) is
637: --
638: l_proc varchar2(72) := g_package||'delete_validate';
639: --