281: --
282: -- ----------------------------------------------------------------------------
283: -- |---------------------------< insert_validate >----------------------------|
284: -- ----------------------------------------------------------------------------
285: Procedure insert_validate(p_rec in hr_exu_shd.g_rec_type) is
286: --
287: l_proc varchar2(72) := g_package||'insert_validate';
288: --
289: Begin
318: --
319: -- ----------------------------------------------------------------------------
320: -- |---------------------------< update_validate >----------------------------|
321: -- ----------------------------------------------------------------------------
322: Procedure update_validate(p_rec in hr_exu_shd.g_rec_type) is
323: --
324: l_proc varchar2(72) := g_package||'update_validate';
325: --
326: Begin
327: hr_utility.set_location('Entering:'||l_proc, 5);
328: --
329: -- Call all supporting business operations
330: --
331: /* if (hr_exu_shd.api_updating
332: ( p_exception_usage_id => p_rec.exception_usage_id,
333: p_object_version_number => p_rec.object_version_number) and
334: nvl(p_rec.calendar_id, hr_exu.g_number) <>
335: nvl(hr_exu_shd.g_old_rec.calendar_id,hr_api.g_number)) then
331: /* if (hr_exu_shd.api_updating
332: ( p_exception_usage_id => p_rec.exception_usage_id,
333: p_object_version_number => p_rec.object_version_number) and
334: nvl(p_rec.calendar_id, hr_exu.g_number) <>
335: nvl(hr_exu_shd.g_old_rec.calendar_id,hr_api.g_number)) then
336: (p_api_name => l_proc,
337: p_argument => 'calendar_id');
338: end if;
339:
336: (p_api_name => l_proc,
337: p_argument => 'calendar_id');
338: end if;
339:
340: if (hr_exu_shd.api_updating
341: ( p_exception_usage_id => p_rec.exception_usage_id,
342: p_object_version_number => p_rec.object_version_number) and
343: nvl(p_rec.calendar_usage_id,hr_api.g_number) <>
344: nvl(hr_exu_shd.g_old_rec.calendar_usage_id,hr_api.g_varchar2)) then
340: if (hr_exu_shd.api_updating
341: ( p_exception_usage_id => p_rec.exception_usage_id,
342: p_object_version_number => p_rec.object_version_number) and
343: nvl(p_rec.calendar_usage_id,hr_api.g_number) <>
344: nvl(hr_exu_shd.g_old_rec.calendar_usage_id,hr_api.g_varchar2)) then
345: (p_api_name => l_proc,
346: p_argument => 'calendar_usage_id');
347: end if;
348:
345: (p_api_name => l_proc,
346: p_argument => 'calendar_usage_id');
347: end if;
348:
349: if (hr_exu_shd.api_updating
350: ( p_exception_usage_id => p_rec.exception_usage_id,
351: p_object_version_number => p_rec.object_version_number) and
352: p_rec.exception_id <> hr_exu_shd.g_old_rec.exception_id) then
353: (p_api_name => l_proc,
348:
349: if (hr_exu_shd.api_updating
350: ( p_exception_usage_id => p_rec.exception_usage_id,
351: p_object_version_number => p_rec.object_version_number) and
352: p_rec.exception_id <> hr_exu_shd.g_old_rec.exception_id) then
353: (p_api_name => l_proc,
354: p_argument => 'exception_id');
355: end if;
356: */
361: --
362: -- ----------------------------------------------------------------------------
363: -- |---------------------------< delete_validate >----------------------------|
364: -- ----------------------------------------------------------------------------
365: Procedure delete_validate(p_rec in hr_exu_shd.g_rec_type) is
366: --
367: l_proc varchar2(72) := g_package||'delete_validate';
368: --
369: Begin