DBA Data[Home] [Help]

APPS.PER_PTU_BUS dependencies on PER_PTU_SHD

Line 247: (p_rec in per_ptu_shd.g_rec_type) is

243: -- Access Status:
244: -- Internal Row Handler Use Only.
245: --
246: procedure check_df
247: (p_rec in per_ptu_shd.g_rec_type) is
248: --
249: l_proc varchar2(72) := g_package||'chk_df';
250: --
251: begin

Line 255: nvl(per_ptu_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>

251: begin
252: hr_utility.set_location('Entering:'||l_proc, 10);
253: --
254: if ((p_rec.person_type_usage_id is not null) and (
255: nvl(per_ptu_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
256: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
257: nvl(per_ptu_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
258: nvl(p_rec.attribute1, hr_api.g_varchar2) or
259: nvl(per_ptu_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

Line 257: nvl(per_ptu_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>

253: --
254: if ((p_rec.person_type_usage_id is not null) and (
255: nvl(per_ptu_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
256: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
257: nvl(per_ptu_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
258: nvl(p_rec.attribute1, hr_api.g_varchar2) or
259: nvl(per_ptu_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
260: nvl(p_rec.attribute2, hr_api.g_varchar2) or
261: nvl(per_ptu_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

Line 259: nvl(per_ptu_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

255: nvl(per_ptu_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
256: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
257: nvl(per_ptu_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
258: nvl(p_rec.attribute1, hr_api.g_varchar2) or
259: nvl(per_ptu_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
260: nvl(p_rec.attribute2, hr_api.g_varchar2) or
261: nvl(per_ptu_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
262: nvl(p_rec.attribute3, hr_api.g_varchar2) or
263: nvl(per_ptu_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

Line 261: nvl(per_ptu_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

257: nvl(per_ptu_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
258: nvl(p_rec.attribute1, hr_api.g_varchar2) or
259: nvl(per_ptu_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
260: nvl(p_rec.attribute2, hr_api.g_varchar2) or
261: nvl(per_ptu_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
262: nvl(p_rec.attribute3, hr_api.g_varchar2) or
263: nvl(per_ptu_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
264: nvl(p_rec.attribute4, hr_api.g_varchar2) or
265: nvl(per_ptu_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

Line 263: nvl(per_ptu_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

259: nvl(per_ptu_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
260: nvl(p_rec.attribute2, hr_api.g_varchar2) or
261: nvl(per_ptu_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
262: nvl(p_rec.attribute3, hr_api.g_varchar2) or
263: nvl(per_ptu_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
264: nvl(p_rec.attribute4, hr_api.g_varchar2) or
265: nvl(per_ptu_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
266: nvl(p_rec.attribute5, hr_api.g_varchar2) or
267: nvl(per_ptu_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

Line 265: nvl(per_ptu_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

261: nvl(per_ptu_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
262: nvl(p_rec.attribute3, hr_api.g_varchar2) or
263: nvl(per_ptu_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
264: nvl(p_rec.attribute4, hr_api.g_varchar2) or
265: nvl(per_ptu_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
266: nvl(p_rec.attribute5, hr_api.g_varchar2) or
267: nvl(per_ptu_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
268: nvl(p_rec.attribute6, hr_api.g_varchar2) or
269: nvl(per_ptu_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

Line 267: nvl(per_ptu_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

263: nvl(per_ptu_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
264: nvl(p_rec.attribute4, hr_api.g_varchar2) or
265: nvl(per_ptu_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
266: nvl(p_rec.attribute5, hr_api.g_varchar2) or
267: nvl(per_ptu_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
268: nvl(p_rec.attribute6, hr_api.g_varchar2) or
269: nvl(per_ptu_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
270: nvl(p_rec.attribute7, hr_api.g_varchar2) or
271: nvl(per_ptu_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

Line 269: nvl(per_ptu_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

265: nvl(per_ptu_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
266: nvl(p_rec.attribute5, hr_api.g_varchar2) or
267: nvl(per_ptu_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
268: nvl(p_rec.attribute6, hr_api.g_varchar2) or
269: nvl(per_ptu_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
270: nvl(p_rec.attribute7, hr_api.g_varchar2) or
271: nvl(per_ptu_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
272: nvl(p_rec.attribute8, hr_api.g_varchar2) or
273: nvl(per_ptu_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

Line 271: nvl(per_ptu_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

267: nvl(per_ptu_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
268: nvl(p_rec.attribute6, hr_api.g_varchar2) or
269: nvl(per_ptu_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
270: nvl(p_rec.attribute7, hr_api.g_varchar2) or
271: nvl(per_ptu_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
272: nvl(p_rec.attribute8, hr_api.g_varchar2) or
273: nvl(per_ptu_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
274: nvl(p_rec.attribute9, hr_api.g_varchar2) or
275: nvl(per_ptu_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

Line 273: nvl(per_ptu_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

269: nvl(per_ptu_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
270: nvl(p_rec.attribute7, hr_api.g_varchar2) or
271: nvl(per_ptu_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
272: nvl(p_rec.attribute8, hr_api.g_varchar2) or
273: nvl(per_ptu_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
274: nvl(p_rec.attribute9, hr_api.g_varchar2) or
275: nvl(per_ptu_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
276: nvl(p_rec.attribute10, hr_api.g_varchar2) or
277: nvl(per_ptu_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

Line 275: nvl(per_ptu_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

271: nvl(per_ptu_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
272: nvl(p_rec.attribute8, hr_api.g_varchar2) or
273: nvl(per_ptu_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
274: nvl(p_rec.attribute9, hr_api.g_varchar2) or
275: nvl(per_ptu_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
276: nvl(p_rec.attribute10, hr_api.g_varchar2) or
277: nvl(per_ptu_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
278: nvl(p_rec.attribute11, hr_api.g_varchar2) or
279: nvl(per_ptu_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

Line 277: nvl(per_ptu_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

273: nvl(per_ptu_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
274: nvl(p_rec.attribute9, hr_api.g_varchar2) or
275: nvl(per_ptu_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
276: nvl(p_rec.attribute10, hr_api.g_varchar2) or
277: nvl(per_ptu_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
278: nvl(p_rec.attribute11, hr_api.g_varchar2) or
279: nvl(per_ptu_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
280: nvl(p_rec.attribute12, hr_api.g_varchar2) or
281: nvl(per_ptu_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

Line 279: nvl(per_ptu_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

275: nvl(per_ptu_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
276: nvl(p_rec.attribute10, hr_api.g_varchar2) or
277: nvl(per_ptu_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
278: nvl(p_rec.attribute11, hr_api.g_varchar2) or
279: nvl(per_ptu_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
280: nvl(p_rec.attribute12, hr_api.g_varchar2) or
281: nvl(per_ptu_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
282: nvl(p_rec.attribute13, hr_api.g_varchar2) or
283: nvl(per_ptu_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

Line 281: nvl(per_ptu_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

277: nvl(per_ptu_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
278: nvl(p_rec.attribute11, hr_api.g_varchar2) or
279: nvl(per_ptu_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
280: nvl(p_rec.attribute12, hr_api.g_varchar2) or
281: nvl(per_ptu_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
282: nvl(p_rec.attribute13, hr_api.g_varchar2) or
283: nvl(per_ptu_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
284: nvl(p_rec.attribute14, hr_api.g_varchar2) or
285: nvl(per_ptu_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

Line 283: nvl(per_ptu_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

279: nvl(per_ptu_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
280: nvl(p_rec.attribute12, hr_api.g_varchar2) or
281: nvl(per_ptu_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
282: nvl(p_rec.attribute13, hr_api.g_varchar2) or
283: nvl(per_ptu_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
284: nvl(p_rec.attribute14, hr_api.g_varchar2) or
285: nvl(per_ptu_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
286: nvl(p_rec.attribute15, hr_api.g_varchar2) or
287: nvl(per_ptu_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

Line 285: nvl(per_ptu_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

281: nvl(per_ptu_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
282: nvl(p_rec.attribute13, hr_api.g_varchar2) or
283: nvl(per_ptu_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
284: nvl(p_rec.attribute14, hr_api.g_varchar2) or
285: nvl(per_ptu_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
286: nvl(p_rec.attribute15, hr_api.g_varchar2) or
287: nvl(per_ptu_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
288: nvl(p_rec.attribute16, hr_api.g_varchar2) or
289: nvl(per_ptu_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

Line 287: nvl(per_ptu_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

283: nvl(per_ptu_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
284: nvl(p_rec.attribute14, hr_api.g_varchar2) or
285: nvl(per_ptu_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
286: nvl(p_rec.attribute15, hr_api.g_varchar2) or
287: nvl(per_ptu_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
288: nvl(p_rec.attribute16, hr_api.g_varchar2) or
289: nvl(per_ptu_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
290: nvl(p_rec.attribute17, hr_api.g_varchar2) or
291: nvl(per_ptu_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

Line 289: nvl(per_ptu_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

285: nvl(per_ptu_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
286: nvl(p_rec.attribute15, hr_api.g_varchar2) or
287: nvl(per_ptu_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
288: nvl(p_rec.attribute16, hr_api.g_varchar2) or
289: nvl(per_ptu_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
290: nvl(p_rec.attribute17, hr_api.g_varchar2) or
291: nvl(per_ptu_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
292: nvl(p_rec.attribute18, hr_api.g_varchar2) or
293: nvl(per_ptu_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

Line 291: nvl(per_ptu_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

287: nvl(per_ptu_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
288: nvl(p_rec.attribute16, hr_api.g_varchar2) or
289: nvl(per_ptu_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
290: nvl(p_rec.attribute17, hr_api.g_varchar2) or
291: nvl(per_ptu_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
292: nvl(p_rec.attribute18, hr_api.g_varchar2) or
293: nvl(per_ptu_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
294: nvl(p_rec.attribute19, hr_api.g_varchar2) or
295: nvl(per_ptu_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

Line 293: nvl(per_ptu_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

289: nvl(per_ptu_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
290: nvl(p_rec.attribute17, hr_api.g_varchar2) or
291: nvl(per_ptu_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
292: nvl(p_rec.attribute18, hr_api.g_varchar2) or
293: nvl(per_ptu_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
294: nvl(p_rec.attribute19, hr_api.g_varchar2) or
295: nvl(per_ptu_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
296: nvl(p_rec.attribute20, hr_api.g_varchar2) or
297: nvl(per_ptu_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>

Line 295: nvl(per_ptu_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

291: nvl(per_ptu_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
292: nvl(p_rec.attribute18, hr_api.g_varchar2) or
293: nvl(per_ptu_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
294: nvl(p_rec.attribute19, hr_api.g_varchar2) or
295: nvl(per_ptu_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
296: nvl(p_rec.attribute20, hr_api.g_varchar2) or
297: nvl(per_ptu_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
298: nvl(p_rec.attribute21, hr_api.g_varchar2) or
299: nvl(per_ptu_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>

Line 297: nvl(per_ptu_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>

293: nvl(per_ptu_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
294: nvl(p_rec.attribute19, hr_api.g_varchar2) or
295: nvl(per_ptu_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
296: nvl(p_rec.attribute20, hr_api.g_varchar2) or
297: nvl(per_ptu_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
298: nvl(p_rec.attribute21, hr_api.g_varchar2) or
299: nvl(per_ptu_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
300: nvl(p_rec.attribute22, hr_api.g_varchar2) or
301: nvl(per_ptu_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>

Line 299: nvl(per_ptu_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>

295: nvl(per_ptu_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
296: nvl(p_rec.attribute20, hr_api.g_varchar2) or
297: nvl(per_ptu_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
298: nvl(p_rec.attribute21, hr_api.g_varchar2) or
299: nvl(per_ptu_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
300: nvl(p_rec.attribute22, hr_api.g_varchar2) or
301: nvl(per_ptu_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
302: nvl(p_rec.attribute23, hr_api.g_varchar2) or
303: nvl(per_ptu_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>

Line 301: nvl(per_ptu_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>

297: nvl(per_ptu_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
298: nvl(p_rec.attribute21, hr_api.g_varchar2) or
299: nvl(per_ptu_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
300: nvl(p_rec.attribute22, hr_api.g_varchar2) or
301: nvl(per_ptu_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
302: nvl(p_rec.attribute23, hr_api.g_varchar2) or
303: nvl(per_ptu_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
304: nvl(p_rec.attribute24, hr_api.g_varchar2) or
305: nvl(per_ptu_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>

Line 303: nvl(per_ptu_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>

299: nvl(per_ptu_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
300: nvl(p_rec.attribute22, hr_api.g_varchar2) or
301: nvl(per_ptu_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
302: nvl(p_rec.attribute23, hr_api.g_varchar2) or
303: nvl(per_ptu_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
304: nvl(p_rec.attribute24, hr_api.g_varchar2) or
305: nvl(per_ptu_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
306: nvl(p_rec.attribute25, hr_api.g_varchar2) or
307: nvl(per_ptu_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>

Line 305: nvl(per_ptu_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>

301: nvl(per_ptu_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
302: nvl(p_rec.attribute23, hr_api.g_varchar2) or
303: nvl(per_ptu_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
304: nvl(p_rec.attribute24, hr_api.g_varchar2) or
305: nvl(per_ptu_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
306: nvl(p_rec.attribute25, hr_api.g_varchar2) or
307: nvl(per_ptu_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
308: nvl(p_rec.attribute26, hr_api.g_varchar2) or
309: nvl(per_ptu_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>

Line 307: nvl(per_ptu_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>

303: nvl(per_ptu_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
304: nvl(p_rec.attribute24, hr_api.g_varchar2) or
305: nvl(per_ptu_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
306: nvl(p_rec.attribute25, hr_api.g_varchar2) or
307: nvl(per_ptu_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
308: nvl(p_rec.attribute26, hr_api.g_varchar2) or
309: nvl(per_ptu_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
310: nvl(p_rec.attribute27, hr_api.g_varchar2) or
311: nvl(per_ptu_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>

Line 309: nvl(per_ptu_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>

305: nvl(per_ptu_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
306: nvl(p_rec.attribute25, hr_api.g_varchar2) or
307: nvl(per_ptu_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
308: nvl(p_rec.attribute26, hr_api.g_varchar2) or
309: nvl(per_ptu_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
310: nvl(p_rec.attribute27, hr_api.g_varchar2) or
311: nvl(per_ptu_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
312: nvl(p_rec.attribute28, hr_api.g_varchar2) or
313: nvl(per_ptu_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>

Line 311: nvl(per_ptu_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>

307: nvl(per_ptu_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
308: nvl(p_rec.attribute26, hr_api.g_varchar2) or
309: nvl(per_ptu_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
310: nvl(p_rec.attribute27, hr_api.g_varchar2) or
311: nvl(per_ptu_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
312: nvl(p_rec.attribute28, hr_api.g_varchar2) or
313: nvl(per_ptu_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
314: nvl(p_rec.attribute29, hr_api.g_varchar2) or
315: nvl(per_ptu_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>

Line 313: nvl(per_ptu_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>

309: nvl(per_ptu_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
310: nvl(p_rec.attribute27, hr_api.g_varchar2) or
311: nvl(per_ptu_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
312: nvl(p_rec.attribute28, hr_api.g_varchar2) or
313: nvl(per_ptu_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
314: nvl(p_rec.attribute29, hr_api.g_varchar2) or
315: nvl(per_ptu_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
316: nvl(p_rec.attribute30, hr_api.g_varchar2)))
317: or

Line 315: nvl(per_ptu_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>

311: nvl(per_ptu_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
312: nvl(p_rec.attribute28, hr_api.g_varchar2) or
313: nvl(per_ptu_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
314: nvl(p_rec.attribute29, hr_api.g_varchar2) or
315: nvl(per_ptu_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
316: nvl(p_rec.attribute30, hr_api.g_varchar2)))
317: or
318: (p_rec.person_type_usage_id is null) then
319: --

Line 399: (p_rec in per_ptu_shd.g_rec_type

395: -- --------------------------------------------------------------------------
396: -- |---------------------< chk_non_updateable_args >------------------------|
397: -- --------------------------------------------------------------------------
398: Procedure chk_non_updateable_args
399: (p_rec in per_ptu_shd.g_rec_type
400: ,p_effective_date in date
401: ) is
402: --
403: l_proc varchar2(72) := g_package||'chk_non_updateable_args';

Line 413: if not per_ptu_shd.api_updating

409: --
410: -- Only proceed with validation if a row exists for
411: -- the current record in the HR Schema
412: --
413: if not per_ptu_shd.api_updating
414: (p_person_type_usage_id => p_rec.person_type_usage_id
415: ,p_object_version_number => p_rec.object_version_number
416: ,p_effective_date => p_effective_date
417: ) then

Line 426: if p_rec.person_id <> per_ptu_shd.g_old_rec.person_id then

422: hr_utility.set_location(l_proc, 30);
423: --
424: -- Bug# 2195731 Starts here. If Condition changed.
425: --
426: if p_rec.person_id <> per_ptu_shd.g_old_rec.person_id then
427: l_argument := 'person_id';
428: raise l_error;
429: end if;
430: --

Line 503: per_ptu_shd.constraint_error('PER_PERSON_TYPE_USAGES_F_FK1');

499: open csr_valid_person_id;
500: fetch csr_valid_person_id into l_person_id;
501: if csr_valid_person_id%notfound then
502: close csr_valid_person_id;
503: per_ptu_shd.constraint_error('PER_PERSON_TYPE_USAGES_F_FK1');
504: end if;
505: close csr_valid_person_id;
506:
507: hr_utility.set_location('Leaving: '||l_proc,10);

Line 592: l_api_updating := per_ptu_shd.api_updating

588: (p_api_name => l_proc,
589: p_argument => 'p_person_type_id',
590: p_argument_value => p_person_type_id);
591: --
592: l_api_updating := per_ptu_shd.api_updating
593: (p_effective_date => p_effective_date,
594: p_person_type_usage_id => p_person_type_usage_id,
595: p_object_version_number => p_object_version_number
596: );

Line 606: per_ptu_shd.g_old_rec.person_type_id <> p_person_type_id) or

602: --
603: hr_utility.set_location('At: '||l_proc,10);
604:
605: if ((l_api_updating and
606: per_ptu_shd.g_old_rec.person_type_id <> p_person_type_id) or
607: (not l_api_updating)) then
608: -----------------------------------
609: -- Check person type id is valid --
610: -----------------------------------

Line 615: per_ptu_shd.constraint_error('PER_PERSON_TYPE_USAGES_F_FK2');

611: open csr_valid_person_type(p_person_type_id);
612: fetch csr_valid_person_type into l_person_type , l_business_group_id;
613: if csr_valid_person_type%notfound then
614: close csr_valid_person_type;
615: per_ptu_shd.constraint_error('PER_PERSON_TYPE_USAGES_F_FK2');
616: end if;
617: close csr_valid_person_type;
618:
619: hr_utility.set_location('At: '||l_proc,15);

Line 634: per_ptu_shd.constraint_error('PER_PERSON_TYPE_USAGES_F_FK2');

630: l_person_type = 'EX_APL' or
631: l_person_type = 'EMP_APL' or
632: l_person_type = 'EX_EMP_APL' or
633: l_person_type = 'APL_EX_APL') then
634: per_ptu_shd.constraint_error('PER_PERSON_TYPE_USAGES_F_FK2');
635: end if;
636: --
637: --
638: hr_utility.set_location('At: '||l_proc,20);

Line 665: open csr_valid_person_type(per_ptu_shd.g_old_rec.person_type_id);

661:
662: -----------------------------------
663: -- Check person type id is valid --
664: -----------------------------------
665: open csr_valid_person_type(per_ptu_shd.g_old_rec.person_type_id);
666: fetch csr_valid_person_type into l_old_person_type , l_business_group_id;
667: if csr_valid_person_type%notfound then
668: close csr_valid_person_type;
669: per_ptu_shd.constraint_error('PER_PERSON_TYPE_USAGES_F_FK2');

Line 669: per_ptu_shd.constraint_error('PER_PERSON_TYPE_USAGES_F_FK2');

665: open csr_valid_person_type(per_ptu_shd.g_old_rec.person_type_id);
666: fetch csr_valid_person_type into l_old_person_type , l_business_group_id;
667: if csr_valid_person_type%notfound then
668: close csr_valid_person_type;
669: per_ptu_shd.constraint_error('PER_PERSON_TYPE_USAGES_F_FK2');
670: end if;
671: close csr_valid_person_type;
672: --
673: -- PTU changes: now allow transitions between type and ex_type

Line 696: (p_rec in per_ptu_shd.g_rec_type,

692: -- ----------------------------------------------------------------------------
693: -- |---------------------------< insert_validate >----------------------------|
694: -- ----------------------------------------------------------------------------
695: Procedure insert_validate
696: (p_rec in per_ptu_shd.g_rec_type,
697: p_effective_date in date,
698: p_datetrack_mode in varchar2,
699: p_validation_start_date in date,
700: p_validation_end_date in date) is

Line 739: (p_rec in per_ptu_shd.g_rec_type,

735: -- ----------------------------------------------------------------------------
736: -- |---------------------------< update_validate >----------------------------|
737: -- ----------------------------------------------------------------------------
738: Procedure update_validate
739: (p_rec in per_ptu_shd.g_rec_type,
740: p_effective_date in date,
741: p_datetrack_mode in varchar2,
742: p_validation_start_date in date,
743: p_validation_end_date in date) is

Line 790: (p_rec in per_ptu_shd.g_rec_type,

786: -- ----------------------------------------------------------------------------
787: -- |---------------------------< delete_validate >----------------------------|
788: -- ----------------------------------------------------------------------------
789: Procedure delete_validate
790: (p_rec in per_ptu_shd.g_rec_type,
791: p_effective_date in date,
792: p_datetrack_mode in varchar2,
793: p_validation_start_date in date,
794: p_validation_end_date in date) is