DBA Data[Home] [Help]

APPS.HXT_UTIL dependencies on HXT_UTIL

Line 1: PACKAGE BODY HXT_UTIL AS

1: PACKAGE BODY HXT_UTIL AS
2: /* $Header: hxtutl.pkb 120.8.12010000.2 2008/08/05 09:50:55 ubhat ship $ */
3:
4: g_debug boolean := hr_utility.debug_enabled;
5: --BEGIN HXT11i1

Line 704: WHERE wsh.week_day = hxt_util.get_week_day(p_date)

700: p_hours
701: FROM hxt_shifts sht,
702: hxt_weekly_work_schedules wws,
703: hxt_work_shifts wsh
704: WHERE wsh.week_day = hxt_util.get_week_day(p_date)
705: AND wws.id = wsh.tws_id
706: AND p_date between wws.date_from
707: and nvl(wws.date_to, p_date)
708: AND wws.id = p_work_id

Line 959: l_retcode := HXT_UTIL.create_batch('R', --source is retro-pay

955: if existing_batch%NOTFOUND then
956: open batch_param;
957: fetch batch_param into bp;
958: if batch_param%FOUND then
959: l_retcode := HXT_UTIL.create_batch('R', --source is retro-pay
960: p_batch_name,
961: p_batch_ref,
962: bp.payroll_id,
963: bp.time_period_id,

Line 977: l_retcode := HXT_UTIL.create_batch('R',

973: close batch_param;
974: else
975: IF p_batch_ref IS NOT NULL THEN
976: IF l_batch_ref NOT like p_batch_ref THEN
977: l_retcode := HXT_UTIL.create_batch('R',
978: p_batch_name,
979: p_batch_ref,
980: bp.payroll_id,
981: bp.time_period_id,

Line 2422: END hxt_util;

2418:
2419: --end ER230
2420: --END HXT11i1
2421:
2422: END hxt_util;