eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.HXT_BATCH_VAL dependencies on HXT_HOLIDAY_DAYS

Line 735: FROM hxt_holiday_calendars hhc, hxt_holiday_days hhd

731: p_day DATE
732: )
733: IS
734: SELECT 1
735: FROM hxt_holiday_calendars hhc, hxt_holiday_days hhd
736: WHERE hhc.id = p_hol_cal_id
737: AND hhc.id = hhd.hcl_id
738: AND hhd.holiday_date = p_day
739: AND hhd.hours >= 0;

Line 1110: p_hol_hours OUT NOCOPY hxt_holiday_days.hours%TYPE,

1106:
1107: PROCEDURE get_holiday_info (
1108: p_day IN DATE,
1109: p_hol_cal_id IN hxt_holiday_calendars.id%TYPE,
1110: p_hol_hours OUT NOCOPY hxt_holiday_days.hours%TYPE,
1111: p_hol_element_type_id OUT NOCOPY hxt_holiday_calendars.element_type_id%TYPE
1112: )
1113: IS
1114: l_proc VARCHAR2 (72) := g_package

Line 1123: FROM hxt_holiday_days hhd, hxt_holiday_calendars hhc

1119: p_day DATE
1120: )
1121: IS
1122: SELECT hhd.hours, hhc.element_type_id
1123: FROM hxt_holiday_days hhd, hxt_holiday_calendars hhc
1124: WHERE hhd.holiday_date = p_day
1125: AND hhc.id = p_hol_cal_id
1126: AND hhd.hcl_id = hhc.id;
1127: BEGIN

Line 1160: p_hol_hours OUT NOCOPY hxt_holiday_days.hours%TYPE,

1156: PROCEDURE get_holiday_info (
1157: p_person_id IN per_people_f.person_id%TYPE,
1158: p_day IN DATE,
1159: p_effective_date IN DATE,
1160: p_hol_hours OUT NOCOPY hxt_holiday_days.hours%TYPE,
1161: p_hol_element_type_id OUT NOCOPY hxt_holiday_calendars.element_type_id%TYPE
1162: )
1163: IS
1164: l_proc VARCHAR2 (72) ;

Line 1249: l_hol_hours hxt_holiday_days.hours%TYPE;

1245: p_hol_cal_id IN hxt_holiday_calendars.id%TYPE
1246: )
1247: IS
1248: l_proc VARCHAR2 (72) ;
1249: l_hol_hours hxt_holiday_days.hours%TYPE;
1250: l_hol_element hxt_holiday_calendars.element_type_id%TYPE;
1251: BEGIN
1252: g_debug :=hr_utility.debug_enabled;
1253: if g_debug then

Line 1685: l_hol_hours hxt_holiday_days.hours%TYPE;

1681: p_hol_cal_id IN hxt_holiday_calendars.id%TYPE
1682: )
1683: IS
1684: l_proc VARCHAR2 (72) ;
1685: l_hol_hours hxt_holiday_days.hours%TYPE;
1686: l_hol_element hxt_holiday_calendars.element_type_id%TYPE;
1687: BEGIN
1688: g_debug :=hr_utility.debug_enabled;
1689: if g_debug then