DBA Data[Home] [Help]

APPS.HXT_BATCH_VAL dependencies on HXT_HOLIDAY_DAYS

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

139:
140: PROCEDURE get_holiday_info (
141: p_day IN DATE,
142: p_hol_cal_id IN hxt_holiday_calendars.id%TYPE,
143: p_hol_hours OUT NOCOPY hxt_holiday_days.hours%TYPE,
144: p_hol_element_type_id OUT NOCOPY hxt_holiday_calendars.element_type_id%TYPE
145: );
146:
147: PROCEDURE get_holiday_info (

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

147: PROCEDURE get_holiday_info (
148: p_person_id IN per_people_f.person_id%TYPE,
149: p_day IN DATE,
150: p_effective_date IN DATE,
151: p_hol_hours OUT NOCOPY hxt_holiday_days.hours%TYPE,
152: p_hol_element_type_id OUT NOCOPY hxt_holiday_calendars.element_type_id%TYPE
153: );
154:
155: FUNCTION sum_unexploded_hours (