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.12.12020000.5 2013/01/28 11:27:38 asrajago ship $ */
3:
4: g_debug boolean := hr_utility.debug_enabled;
5: --BEGIN HXT11i1

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

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

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

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

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

977: close batch_param;
978: else
979: IF p_batch_ref IS NOT NULL THEN
980: IF l_batch_ref NOT like p_batch_ref THEN
981: l_retcode := HXT_UTIL.create_batch('R',
982: p_batch_name,
983: p_batch_ref,
984: bp.payroll_id,
985: bp.time_period_id,

Line 2612: END hxt_util;

2608:
2609: --end ER230
2610: --END HXT11i1
2611:
2612: END hxt_util;