[Home] [Help]
201: -- Internal Row Handler Use Only.
202: --
203: -- ----------------------------------------------------------------------------
204: procedure chk_df
205: (p_rec in hxc_hph_shd.g_rec_type
206: ) is
207: --
208: l_proc varchar2(72);
209: --
214: hr_utility.set_location('Entering:'||l_proc,10);
215: end if;
216: --
217: if ((p_rec.pref_hierarchy_id is not null) and (
218: nvl(hxc_hph_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
219: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
220: nvl(hxc_hph_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
221: nvl(p_rec.attribute1, hr_api.g_varchar2) or
222: nvl(hxc_hph_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
216: --
217: if ((p_rec.pref_hierarchy_id is not null) and (
218: nvl(hxc_hph_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
219: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
220: nvl(hxc_hph_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
221: nvl(p_rec.attribute1, hr_api.g_varchar2) or
222: nvl(hxc_hph_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
223: nvl(p_rec.attribute2, hr_api.g_varchar2) or
224: nvl(hxc_hph_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
218: nvl(hxc_hph_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
219: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
220: nvl(hxc_hph_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
221: nvl(p_rec.attribute1, hr_api.g_varchar2) or
222: nvl(hxc_hph_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
223: nvl(p_rec.attribute2, hr_api.g_varchar2) or
224: nvl(hxc_hph_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
225: nvl(p_rec.attribute3, hr_api.g_varchar2) or
226: nvl(hxc_hph_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
220: nvl(hxc_hph_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
221: nvl(p_rec.attribute1, hr_api.g_varchar2) or
222: nvl(hxc_hph_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
223: nvl(p_rec.attribute2, hr_api.g_varchar2) or
224: nvl(hxc_hph_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
225: nvl(p_rec.attribute3, hr_api.g_varchar2) or
226: nvl(hxc_hph_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
227: nvl(p_rec.attribute4, hr_api.g_varchar2) or
228: nvl(hxc_hph_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
222: nvl(hxc_hph_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
223: nvl(p_rec.attribute2, hr_api.g_varchar2) or
224: nvl(hxc_hph_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
225: nvl(p_rec.attribute3, hr_api.g_varchar2) or
226: nvl(hxc_hph_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
227: nvl(p_rec.attribute4, hr_api.g_varchar2) or
228: nvl(hxc_hph_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
229: nvl(p_rec.attribute5, hr_api.g_varchar2) or
230: nvl(hxc_hph_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
224: nvl(hxc_hph_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
225: nvl(p_rec.attribute3, hr_api.g_varchar2) or
226: nvl(hxc_hph_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
227: nvl(p_rec.attribute4, hr_api.g_varchar2) or
228: nvl(hxc_hph_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
229: nvl(p_rec.attribute5, hr_api.g_varchar2) or
230: nvl(hxc_hph_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
231: nvl(p_rec.attribute6, hr_api.g_varchar2) or
232: nvl(hxc_hph_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
226: nvl(hxc_hph_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
227: nvl(p_rec.attribute4, hr_api.g_varchar2) or
228: nvl(hxc_hph_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
229: nvl(p_rec.attribute5, hr_api.g_varchar2) or
230: nvl(hxc_hph_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
231: nvl(p_rec.attribute6, hr_api.g_varchar2) or
232: nvl(hxc_hph_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
233: nvl(p_rec.attribute7, hr_api.g_varchar2) or
234: nvl(hxc_hph_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
228: nvl(hxc_hph_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
229: nvl(p_rec.attribute5, hr_api.g_varchar2) or
230: nvl(hxc_hph_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
231: nvl(p_rec.attribute6, hr_api.g_varchar2) or
232: nvl(hxc_hph_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
233: nvl(p_rec.attribute7, hr_api.g_varchar2) or
234: nvl(hxc_hph_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
235: nvl(p_rec.attribute8, hr_api.g_varchar2) or
236: nvl(hxc_hph_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
230: nvl(hxc_hph_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
231: nvl(p_rec.attribute6, hr_api.g_varchar2) or
232: nvl(hxc_hph_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
233: nvl(p_rec.attribute7, hr_api.g_varchar2) or
234: nvl(hxc_hph_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
235: nvl(p_rec.attribute8, hr_api.g_varchar2) or
236: nvl(hxc_hph_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
237: nvl(p_rec.attribute9, hr_api.g_varchar2) or
238: nvl(hxc_hph_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
232: nvl(hxc_hph_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
233: nvl(p_rec.attribute7, hr_api.g_varchar2) or
234: nvl(hxc_hph_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
235: nvl(p_rec.attribute8, hr_api.g_varchar2) or
236: nvl(hxc_hph_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
237: nvl(p_rec.attribute9, hr_api.g_varchar2) or
238: nvl(hxc_hph_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
239: nvl(p_rec.attribute10, hr_api.g_varchar2) or
240: nvl(hxc_hph_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
234: nvl(hxc_hph_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
235: nvl(p_rec.attribute8, hr_api.g_varchar2) or
236: nvl(hxc_hph_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
237: nvl(p_rec.attribute9, hr_api.g_varchar2) or
238: nvl(hxc_hph_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
239: nvl(p_rec.attribute10, hr_api.g_varchar2) or
240: nvl(hxc_hph_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
241: nvl(p_rec.attribute11, hr_api.g_varchar2) or
242: nvl(hxc_hph_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
236: nvl(hxc_hph_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
237: nvl(p_rec.attribute9, hr_api.g_varchar2) or
238: nvl(hxc_hph_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
239: nvl(p_rec.attribute10, hr_api.g_varchar2) or
240: nvl(hxc_hph_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
241: nvl(p_rec.attribute11, hr_api.g_varchar2) or
242: nvl(hxc_hph_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
243: nvl(p_rec.attribute12, hr_api.g_varchar2) or
244: nvl(hxc_hph_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
238: nvl(hxc_hph_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
239: nvl(p_rec.attribute10, hr_api.g_varchar2) or
240: nvl(hxc_hph_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
241: nvl(p_rec.attribute11, hr_api.g_varchar2) or
242: nvl(hxc_hph_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
243: nvl(p_rec.attribute12, hr_api.g_varchar2) or
244: nvl(hxc_hph_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
245: nvl(p_rec.attribute13, hr_api.g_varchar2) or
246: nvl(hxc_hph_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
240: nvl(hxc_hph_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
241: nvl(p_rec.attribute11, hr_api.g_varchar2) or
242: nvl(hxc_hph_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
243: nvl(p_rec.attribute12, hr_api.g_varchar2) or
244: nvl(hxc_hph_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
245: nvl(p_rec.attribute13, hr_api.g_varchar2) or
246: nvl(hxc_hph_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
247: nvl(p_rec.attribute14, hr_api.g_varchar2) or
248: nvl(hxc_hph_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
242: nvl(hxc_hph_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
243: nvl(p_rec.attribute12, hr_api.g_varchar2) or
244: nvl(hxc_hph_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
245: nvl(p_rec.attribute13, hr_api.g_varchar2) or
246: nvl(hxc_hph_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
247: nvl(p_rec.attribute14, hr_api.g_varchar2) or
248: nvl(hxc_hph_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
249: nvl(p_rec.attribute15, hr_api.g_varchar2) or
250: nvl(hxc_hph_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
244: nvl(hxc_hph_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
245: nvl(p_rec.attribute13, hr_api.g_varchar2) or
246: nvl(hxc_hph_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
247: nvl(p_rec.attribute14, hr_api.g_varchar2) or
248: nvl(hxc_hph_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
249: nvl(p_rec.attribute15, hr_api.g_varchar2) or
250: nvl(hxc_hph_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
251: nvl(p_rec.attribute16, hr_api.g_varchar2) or
252: nvl(hxc_hph_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
246: nvl(hxc_hph_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
247: nvl(p_rec.attribute14, hr_api.g_varchar2) or
248: nvl(hxc_hph_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
249: nvl(p_rec.attribute15, hr_api.g_varchar2) or
250: nvl(hxc_hph_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
251: nvl(p_rec.attribute16, hr_api.g_varchar2) or
252: nvl(hxc_hph_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
253: nvl(p_rec.attribute17, hr_api.g_varchar2) or
254: nvl(hxc_hph_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
248: nvl(hxc_hph_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
249: nvl(p_rec.attribute15, hr_api.g_varchar2) or
250: nvl(hxc_hph_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
251: nvl(p_rec.attribute16, hr_api.g_varchar2) or
252: nvl(hxc_hph_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
253: nvl(p_rec.attribute17, hr_api.g_varchar2) or
254: nvl(hxc_hph_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
255: nvl(p_rec.attribute18, hr_api.g_varchar2) or
256: nvl(hxc_hph_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
250: nvl(hxc_hph_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
251: nvl(p_rec.attribute16, hr_api.g_varchar2) or
252: nvl(hxc_hph_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
253: nvl(p_rec.attribute17, hr_api.g_varchar2) or
254: nvl(hxc_hph_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
255: nvl(p_rec.attribute18, hr_api.g_varchar2) or
256: nvl(hxc_hph_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
257: nvl(p_rec.attribute19, hr_api.g_varchar2) or
258: nvl(hxc_hph_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
252: nvl(hxc_hph_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
253: nvl(p_rec.attribute17, hr_api.g_varchar2) or
254: nvl(hxc_hph_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
255: nvl(p_rec.attribute18, hr_api.g_varchar2) or
256: nvl(hxc_hph_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
257: nvl(p_rec.attribute19, hr_api.g_varchar2) or
258: nvl(hxc_hph_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
259: nvl(p_rec.attribute20, hr_api.g_varchar2) or
260: nvl(hxc_hph_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
254: nvl(hxc_hph_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
255: nvl(p_rec.attribute18, hr_api.g_varchar2) or
256: nvl(hxc_hph_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
257: nvl(p_rec.attribute19, hr_api.g_varchar2) or
258: nvl(hxc_hph_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
259: nvl(p_rec.attribute20, hr_api.g_varchar2) or
260: nvl(hxc_hph_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
261: nvl(p_rec.attribute21, hr_api.g_varchar2) or
262: nvl(hxc_hph_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
256: nvl(hxc_hph_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
257: nvl(p_rec.attribute19, hr_api.g_varchar2) or
258: nvl(hxc_hph_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
259: nvl(p_rec.attribute20, hr_api.g_varchar2) or
260: nvl(hxc_hph_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
261: nvl(p_rec.attribute21, hr_api.g_varchar2) or
262: nvl(hxc_hph_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
263: nvl(p_rec.attribute22, hr_api.g_varchar2) or
264: nvl(hxc_hph_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
258: nvl(hxc_hph_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
259: nvl(p_rec.attribute20, hr_api.g_varchar2) or
260: nvl(hxc_hph_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
261: nvl(p_rec.attribute21, hr_api.g_varchar2) or
262: nvl(hxc_hph_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
263: nvl(p_rec.attribute22, hr_api.g_varchar2) or
264: nvl(hxc_hph_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
265: nvl(p_rec.attribute23, hr_api.g_varchar2) or
266: nvl(hxc_hph_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
260: nvl(hxc_hph_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
261: nvl(p_rec.attribute21, hr_api.g_varchar2) or
262: nvl(hxc_hph_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
263: nvl(p_rec.attribute22, hr_api.g_varchar2) or
264: nvl(hxc_hph_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
265: nvl(p_rec.attribute23, hr_api.g_varchar2) or
266: nvl(hxc_hph_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
267: nvl(p_rec.attribute24, hr_api.g_varchar2) or
268: nvl(hxc_hph_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
262: nvl(hxc_hph_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
263: nvl(p_rec.attribute22, hr_api.g_varchar2) or
264: nvl(hxc_hph_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
265: nvl(p_rec.attribute23, hr_api.g_varchar2) or
266: nvl(hxc_hph_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
267: nvl(p_rec.attribute24, hr_api.g_varchar2) or
268: nvl(hxc_hph_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
269: nvl(p_rec.attribute25, hr_api.g_varchar2) or
270: nvl(hxc_hph_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
264: nvl(hxc_hph_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
265: nvl(p_rec.attribute23, hr_api.g_varchar2) or
266: nvl(hxc_hph_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
267: nvl(p_rec.attribute24, hr_api.g_varchar2) or
268: nvl(hxc_hph_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
269: nvl(p_rec.attribute25, hr_api.g_varchar2) or
270: nvl(hxc_hph_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
271: nvl(p_rec.attribute26, hr_api.g_varchar2) or
272: nvl(hxc_hph_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
266: nvl(hxc_hph_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
267: nvl(p_rec.attribute24, hr_api.g_varchar2) or
268: nvl(hxc_hph_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
269: nvl(p_rec.attribute25, hr_api.g_varchar2) or
270: nvl(hxc_hph_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
271: nvl(p_rec.attribute26, hr_api.g_varchar2) or
272: nvl(hxc_hph_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
273: nvl(p_rec.attribute27, hr_api.g_varchar2) or
274: nvl(hxc_hph_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
268: nvl(hxc_hph_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
269: nvl(p_rec.attribute25, hr_api.g_varchar2) or
270: nvl(hxc_hph_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
271: nvl(p_rec.attribute26, hr_api.g_varchar2) or
272: nvl(hxc_hph_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
273: nvl(p_rec.attribute27, hr_api.g_varchar2) or
274: nvl(hxc_hph_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
275: nvl(p_rec.attribute28, hr_api.g_varchar2) or
276: nvl(hxc_hph_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
270: nvl(hxc_hph_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
271: nvl(p_rec.attribute26, hr_api.g_varchar2) or
272: nvl(hxc_hph_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
273: nvl(p_rec.attribute27, hr_api.g_varchar2) or
274: nvl(hxc_hph_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
275: nvl(p_rec.attribute28, hr_api.g_varchar2) or
276: nvl(hxc_hph_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
277: nvl(p_rec.attribute29, hr_api.g_varchar2) or
278: nvl(hxc_hph_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
272: nvl(hxc_hph_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
273: nvl(p_rec.attribute27, hr_api.g_varchar2) or
274: nvl(hxc_hph_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
275: nvl(p_rec.attribute28, hr_api.g_varchar2) or
276: nvl(hxc_hph_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
277: nvl(p_rec.attribute29, hr_api.g_varchar2) or
278: nvl(hxc_hph_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
279: nvl(p_rec.attribute30, hr_api.g_varchar2) ))
280: or (p_rec.pref_hierarchy_id is null) then
274: nvl(hxc_hph_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
275: nvl(p_rec.attribute28, hr_api.g_varchar2) or
276: nvl(hxc_hph_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
277: nvl(p_rec.attribute29, hr_api.g_varchar2) or
278: nvl(hxc_hph_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
279: nvl(p_rec.attribute30, hr_api.g_varchar2) ))
280: or (p_rec.pref_hierarchy_id is null) then
281: --
282: -- Only execute the validation if absolutely necessary:
386: -- {End Of Comments}
387: -- ----------------------------------------------------------------------------
388: Procedure chk_non_updateable_args
389: (p_effective_date in date
390: ,p_rec in hxc_hph_shd.g_rec_type
391: ) IS
392: --
393: l_proc varchar2(72) := g_package || 'chk_non_updateable_args';
394: l_error EXCEPTION;
398: --
399: -- Only proceed with the validation if a row exists for the current
400: -- record in the HR Schema.
401: --
402: IF NOT hxc_hph_shd.api_updating
403: (p_pref_hierarchy_id => p_rec.pref_hierarchy_id
404: ,p_object_version_number => p_rec.object_version_number
405: ) THEN
406: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
994: --
995: -- {End Of Comments}
996: -- ----------------------------------------------------------------------------
997: procedure get_mapping_components(p_alias_type_id in number,
998: p_mapping_id_table in out nocopy hxc_hph_shd.alias_mapping_table) is
999: cursor c_get_mapping_components (p_alias_type_id number) is
1000: select mapping_component_id
1001: from hxc_alias_type_components hac
1002: where hac.alias_type_id = p_alias_type_id;
1035: -- 1 -Success
1036: -- {End Of Comments}
1037: -- ----------------------------------------------------------------------------
1038:
1039: function VALIDATE_ALIAS_DEFINITIONS(p_alias_type_id_table in hxc_hph_shd.alias_type_id_table
1040: ,p_index in number) return number is
1041: key_mapping_id_table hxc_hph_shd.alias_mapping_table;
1042: key_alias_type_id hxc_alias_types.alias_type_id%type;
1043: l_alias_type_id hxc_alias_types.alias_type_id%type;
1037: -- ----------------------------------------------------------------------------
1038:
1039: function VALIDATE_ALIAS_DEFINITIONS(p_alias_type_id_table in hxc_hph_shd.alias_type_id_table
1040: ,p_index in number) return number is
1041: key_mapping_id_table hxc_hph_shd.alias_mapping_table;
1042: key_alias_type_id hxc_alias_types.alias_type_id%type;
1043: l_alias_type_id hxc_alias_types.alias_type_id%type;
1044: l_mapping_id_table hxc_hph_shd.alias_mapping_table;
1045: i number;
1040: ,p_index in number) return number is
1041: key_mapping_id_table hxc_hph_shd.alias_mapping_table;
1042: key_alias_type_id hxc_alias_types.alias_type_id%type;
1043: l_alias_type_id hxc_alias_types.alias_type_id%type;
1044: l_mapping_id_table hxc_hph_shd.alias_mapping_table;
1045: i number;
1046: j number;
1047: begin
1048: g_debug:=hr_utility.debug_enabled;
1097: -- p_alias_type_id_table
1098: --
1099: -- {End Of Comments}
1100: -- ----------------------------------------------------------------------------
1101: procedure populate_alias_type_id_table (p_rec in hxc_hph_shd.g_rec_type,
1102: p_alias_type_id_table in out nocopy hxc_hph_shd.alias_type_id_table) is
1103: cursor c_alias_type_id (p_alias_definition_id number) is
1104: select alias_type_id
1105: from hxc_alias_definitions had
1098: --
1099: -- {End Of Comments}
1100: -- ----------------------------------------------------------------------------
1101: procedure populate_alias_type_id_table (p_rec in hxc_hph_shd.g_rec_type,
1102: p_alias_type_id_table in out nocopy hxc_hph_shd.alias_type_id_table) is
1103: cursor c_alias_type_id (p_alias_definition_id number) is
1104: select alias_type_id
1105: from hxc_alias_definitions had
1106: where had.alias_definition_id = p_alias_definition_id;
1363: -- 1 -Success
1364: -- {End Of Comments}
1365: -- ----------------------------------------------------------------------------
1366:
1367: function validate_alias_mapping_names(p_alias_type_id_table in hxc_hph_shd.alias_type_id_table) return number is
1368: l_alias_mapping_name_table hxc_hph_shd.alias_mapping_name_table;
1369: n number;
1370: counter number := 1;
1371: l_Inputvalue_flag number := 0;
1364: -- {End Of Comments}
1365: -- ----------------------------------------------------------------------------
1366:
1367: function validate_alias_mapping_names(p_alias_type_id_table in hxc_hph_shd.alias_type_id_table) return number is
1368: l_alias_mapping_name_table hxc_hph_shd.alias_mapping_name_table;
1369: n number;
1370: counter number := 1;
1371: l_Inputvalue_flag number := 0;
1372: l_CostSegment_flag number := 0;
1524: */
1525: return 1;
1526: end validate_alias_mapping_names;
1527:
1528: procedure validate_alias (p_rec in hxc_hph_shd.g_rec_type) is
1529: n number;
1530: succ number;
1531: l_alias_type_id_table hxc_hph_shd.alias_type_id_table;
1532: l_alias_mapping_name_table hxc_hph_shd.alias_mapping_name_table;
1527:
1528: procedure validate_alias (p_rec in hxc_hph_shd.g_rec_type) is
1529: n number;
1530: succ number;
1531: l_alias_type_id_table hxc_hph_shd.alias_type_id_table;
1532: l_alias_mapping_name_table hxc_hph_shd.alias_mapping_name_table;
1533: begin
1534: g_debug:=hr_utility.debug_enabled;
1535: if g_debug then
1528: procedure validate_alias (p_rec in hxc_hph_shd.g_rec_type) is
1529: n number;
1530: succ number;
1531: l_alias_type_id_table hxc_hph_shd.alias_type_id_table;
1532: l_alias_mapping_name_table hxc_hph_shd.alias_mapping_name_table;
1533: begin
1534: g_debug:=hr_utility.debug_enabled;
1535: if g_debug then
1536: hr_utility.trace('p_rec.attribute_category' ||p_rec.attribute_category);
1656: -- |---------------------------< insert_validate >----------------------------|
1657: -- ----------------------------------------------------------------------------
1658: Procedure insert_validate
1659: (p_effective_date in date
1660: ,p_rec in hxc_hph_shd.g_rec_type
1661: ) is
1662: --
1663: l_proc varchar2(72);
1664: --
1777: -- |---------------------------< update_validate >----------------------------|
1778: -- ----------------------------------------------------------------------------
1779: Procedure update_validate
1780: (p_effective_date in date
1781: ,p_rec in hxc_hph_shd.g_rec_type
1782: ) is
1783: --
1784: l_proc varchar2(72);
1785: --
1898: -- ----------------------------------------------------------------------------
1899: -- |---------------------------< delete_validate >----------------------------|
1900: -- ----------------------------------------------------------------------------
1901: Procedure delete_validate
1902: (p_rec in hxc_hph_shd.g_rec_type
1903: ) is
1904: --
1905: l_proc varchar2(72);
1906: --