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.

APPS.HXT_BATCH_VAL dependencies on HXT_HOLIDAY_CALENDARS

Line 81: RETURN hxt_holiday_calendars.id%TYPE;

77: FUNCTION holiday_calendar_id (
78: p_person_id IN per_people_f.person_id%TYPE,
79: p_effective_date IN DATE
80: )
81: RETURN hxt_holiday_calendars.id%TYPE;
82:
83: FUNCTION holiday_calendar_id (
84: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE,
85: p_effective_date IN DATE

Line 87: RETURN hxt_holiday_calendars.id%TYPE;

83: FUNCTION holiday_calendar_id (
84: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE,
85: p_effective_date IN DATE
86: )
87: RETURN hxt_holiday_calendars.id%TYPE;
88:
89: FUNCTION holiday_element_id (p_hol_cal_id IN hxt_holiday_calendars.id%TYPE)
90: RETURN hxt_holiday_calendars.element_type_id%TYPE;
91:

Line 89: FUNCTION holiday_element_id (p_hol_cal_id IN hxt_holiday_calendars.id%TYPE)

85: p_effective_date IN DATE
86: )
87: RETURN hxt_holiday_calendars.id%TYPE;
88:
89: FUNCTION holiday_element_id (p_hol_cal_id IN hxt_holiday_calendars.id%TYPE)
90: RETURN hxt_holiday_calendars.element_type_id%TYPE;
91:
92: FUNCTION day_is_holiday (
93: p_hol_cal_id IN hxt_holiday_calendars.id%TYPE,

Line 90: RETURN hxt_holiday_calendars.element_type_id%TYPE;

86: )
87: RETURN hxt_holiday_calendars.id%TYPE;
88:
89: FUNCTION holiday_element_id (p_hol_cal_id IN hxt_holiday_calendars.id%TYPE)
90: RETURN hxt_holiday_calendars.element_type_id%TYPE;
91:
92: FUNCTION day_is_holiday (
93: p_hol_cal_id IN hxt_holiday_calendars.id%TYPE,
94: p_day IN DATE

Line 93: p_hol_cal_id IN hxt_holiday_calendars.id%TYPE,

89: FUNCTION holiday_element_id (p_hol_cal_id IN hxt_holiday_calendars.id%TYPE)
90: RETURN hxt_holiday_calendars.element_type_id%TYPE;
91:
92: FUNCTION day_is_holiday (
93: p_hol_cal_id IN hxt_holiday_calendars.id%TYPE,
94: p_day IN DATE
95: )
96: RETURN BOOLEAN;
97:

Line 99: p_tim_id IN hxt_holiday_calendars.id%TYPE,

95: )
96: RETURN BOOLEAN;
97:
98: FUNCTION timecard_approved (
99: p_tim_id IN hxt_holiday_calendars.id%TYPE,
100: p_approver_id IN hxt_timecards_f.approv_person_id%TYPE,
101: p_source_flag IN hxt_timecards_f.auto_gen_flag%TYPE
102: )
103: RETURN BOOLEAN;

Line 142: p_hol_cal_id IN hxt_holiday_calendars.id%TYPE,

138: );
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:

Line 144: p_hol_element_type_id OUT NOCOPY hxt_holiday_calendars.element_type_id%TYPE

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 (
148: p_person_id IN per_people_f.person_id%TYPE,

Line 152: p_hol_element_type_id OUT NOCOPY hxt_holiday_calendars.element_type_id%TYPE

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 (
156: p_tim_id IN hxt_timecards.id%TYPE,

Line 169: p_hol_cal_id IN hxt_holiday_calendars.id%TYPE

165: p_period_id IN hxt_timecards.time_period_id%TYPE,
166: p_tim_id IN hxt_timecards.id%TYPE,
167: p_day IN DATE,
168: p_hours_type IN hxt_sum_hours_worked_f.element_type_id%TYPE,
169: p_hol_cal_id IN hxt_holiday_calendars.id%TYPE
170: );
171:
172: PROCEDURE holiday_valid (
173: p_batch_id IN NUMBER,

Line 179: p_hol_cal_id IN hxt_holiday_calendars.id%TYPE

175: p_period_id IN hxt_timecards.time_period_id%TYPE,
176: p_tim_id IN hxt_timecards.id%TYPE,
177: p_day IN DATE,
178: p_hours_type IN hxt_sum_hours_worked_f.element_type_id%TYPE,
179: p_hol_cal_id IN hxt_holiday_calendars.id%TYPE
180: );
181:
182: FUNCTION element_link (
183: p_element_type_id IN pay_element_types_f.element_type_id%TYPE,

Line 201: p_hol_cal_id IN hxt_holiday_calendars.id%TYPE,

197: p_element_id IN pay_element_types_f.element_type_id%TYPE,
198: p_earnings_category IN hxt_add_elem_info_f.earning_category%TYPE,
199: p_day IN DATE,
200: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE,
201: p_hol_cal_id IN hxt_holiday_calendars.id%TYPE,
202: p_valid_earn_cat1 IN hxt_add_elem_info_f.earning_category%TYPE
203: DEFAULT NULL,
204: p_valid_earn_cat2 IN hxt_add_elem_info_f.earning_category%TYPE
205: DEFAULT NULL,

Line 223: p_hol_cal_id IN hxt_holiday_calendars.id%TYPE

219: FUNCTION sum_valid_det_hours (
220: p_tim_id IN hxt_timecards.id%TYPE,
221: p_day IN DATE,
222: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE,
223: p_hol_cal_id IN hxt_holiday_calendars.id%TYPE
224: )
225: RETURN NUMBER;
226:
227: PROCEDURE day_over_24 (

Line 234: p_hol_cal_id IN hxt_holiday_calendars.id%TYPE

230: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE,
231: p_period_id IN hxt_timecards.time_period_id%TYPE,
232: p_tim_id IN hxt_timecards.id%TYPE,
233: p_day IN DATE,
234: p_hol_cal_id IN hxt_holiday_calendars.id%TYPE
235: );
236:
237: PROCEDURE holiday_as_reg (
238: p_batch_id IN NUMBER,

Line 244: p_hol_cal_id IN hxt_holiday_calendars.id%TYPE

240: p_period_id IN hxt_timecards.time_period_id%TYPE,
241: p_tim_id IN hxt_timecards.id%TYPE,
242: p_day IN DATE,
243: p_hours_type IN hxt_sum_hours_worked_f.element_type_id%TYPE,
244: p_hol_cal_id IN hxt_holiday_calendars.id%TYPE
245: );
246:
247: PROCEDURE validate_tc (
248: p_batch_id IN NUMBER,