DBA Data[Home] [Help]

APPS.HXT_BATCH_VAL dependencies on HXT_HOLIDAY_DAYS

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

163:
164: PROCEDURE get_holiday_info (
165: p_day IN DATE,
166: p_hol_cal_id IN hxt_holiday_calendars.id%TYPE,
167: p_hol_hours OUT NOCOPY hxt_holiday_days.hours%TYPE,
168: p_hol_element_type_id OUT NOCOPY hxt_holiday_calendars.element_type_id%TYPE
169: );
170:
171: PROCEDURE get_holiday_info (

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

171: PROCEDURE get_holiday_info (
172: p_person_id IN per_people_f.person_id%TYPE,
173: p_day IN DATE,
174: p_effective_date IN DATE,
175: p_hol_hours OUT NOCOPY hxt_holiday_days.hours%TYPE,
176: p_hol_element_type_id OUT NOCOPY hxt_holiday_calendars.element_type_id%TYPE
177: );
178:
179: FUNCTION sum_unexploded_hours (