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 105: RETURN hxt_holiday_calendars.id%TYPE;

101: FUNCTION holiday_calendar_id (
102: p_person_id IN per_people_f.person_id%TYPE,
103: p_effective_date IN DATE
104: )
105: RETURN hxt_holiday_calendars.id%TYPE;
106:
107: FUNCTION holiday_calendar_id (
108: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE,
109: p_effective_date IN DATE

Line 111: RETURN hxt_holiday_calendars.id%TYPE;

107: FUNCTION holiday_calendar_id (
108: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE,
109: p_effective_date IN DATE
110: )
111: RETURN hxt_holiday_calendars.id%TYPE;
112:
113: FUNCTION holiday_element_id (p_hol_cal_id IN hxt_holiday_calendars.id%TYPE)
114: RETURN hxt_holiday_calendars.element_type_id%TYPE;
115:

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

109: p_effective_date IN DATE
110: )
111: RETURN hxt_holiday_calendars.id%TYPE;
112:
113: FUNCTION holiday_element_id (p_hol_cal_id IN hxt_holiday_calendars.id%TYPE)
114: RETURN hxt_holiday_calendars.element_type_id%TYPE;
115:
116: FUNCTION day_is_holiday (
117: p_hol_cal_id IN hxt_holiday_calendars.id%TYPE,

Line 114: RETURN hxt_holiday_calendars.element_type_id%TYPE;

110: )
111: RETURN hxt_holiday_calendars.id%TYPE;
112:
113: FUNCTION holiday_element_id (p_hol_cal_id IN hxt_holiday_calendars.id%TYPE)
114: RETURN hxt_holiday_calendars.element_type_id%TYPE;
115:
116: FUNCTION day_is_holiday (
117: p_hol_cal_id IN hxt_holiday_calendars.id%TYPE,
118: p_day IN DATE

Line 117: p_hol_cal_id IN hxt_holiday_calendars.id%TYPE,

113: FUNCTION holiday_element_id (p_hol_cal_id IN hxt_holiday_calendars.id%TYPE)
114: RETURN hxt_holiday_calendars.element_type_id%TYPE;
115:
116: FUNCTION day_is_holiday (
117: p_hol_cal_id IN hxt_holiday_calendars.id%TYPE,
118: p_day IN DATE
119: )
120: RETURN BOOLEAN;
121:

Line 123: p_tim_id IN hxt_holiday_calendars.id%TYPE,

119: )
120: RETURN BOOLEAN;
121:
122: FUNCTION timecard_approved (
123: p_tim_id IN hxt_holiday_calendars.id%TYPE,
124: p_approver_id IN hxt_timecards_f.approv_person_id%TYPE,
125: p_source_flag IN hxt_timecards_f.auto_gen_flag%TYPE
126: )
127: RETURN BOOLEAN;

Line 166: p_hol_cal_id IN hxt_holiday_calendars.id%TYPE,

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

Line 168: p_hol_element_type_id OUT NOCOPY hxt_holiday_calendars.element_type_id%TYPE

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

Line 176: p_hol_element_type_id OUT NOCOPY hxt_holiday_calendars.element_type_id%TYPE

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

Line 193: p_hol_cal_id IN hxt_holiday_calendars.id%TYPE

189: p_period_id IN hxt_timecards.time_period_id%TYPE,
190: p_tim_id IN hxt_timecards.id%TYPE,
191: p_day IN DATE,
192: p_hours_type IN hxt_sum_hours_worked_f.element_type_id%TYPE,
193: p_hol_cal_id IN hxt_holiday_calendars.id%TYPE
194: );
195:
196: PROCEDURE holiday_valid (
197: p_batch_id IN NUMBER,

Line 203: p_hol_cal_id IN hxt_holiday_calendars.id%TYPE

199: p_period_id IN hxt_timecards.time_period_id%TYPE,
200: p_tim_id IN hxt_timecards.id%TYPE,
201: p_day IN DATE,
202: p_hours_type IN hxt_sum_hours_worked_f.element_type_id%TYPE,
203: p_hol_cal_id IN hxt_holiday_calendars.id%TYPE
204: );
205:
206: FUNCTION element_link (
207: p_element_type_id IN pay_element_types_f.element_type_id%TYPE,

Line 225: p_hol_cal_id IN hxt_holiday_calendars.id%TYPE,

221: p_element_id IN pay_element_types_f.element_type_id%TYPE,
222: p_earnings_category IN hxt_add_elem_info_f.earning_category%TYPE,
223: p_day IN DATE,
224: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE,
225: p_hol_cal_id IN hxt_holiday_calendars.id%TYPE,
226: p_valid_earn_cat1 IN hxt_add_elem_info_f.earning_category%TYPE
227: DEFAULT NULL,
228: p_valid_earn_cat2 IN hxt_add_elem_info_f.earning_category%TYPE
229: DEFAULT NULL,

Line 247: p_hol_cal_id IN hxt_holiday_calendars.id%TYPE

243: FUNCTION sum_valid_det_hours (
244: p_tim_id IN hxt_timecards.id%TYPE,
245: p_day IN DATE,
246: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE,
247: p_hol_cal_id IN hxt_holiday_calendars.id%TYPE
248: )
249: RETURN NUMBER;
250:
251: PROCEDURE day_over_24 (

Line 258: p_hol_cal_id IN hxt_holiday_calendars.id%TYPE

254: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE,
255: p_period_id IN hxt_timecards.time_period_id%TYPE,
256: p_tim_id IN hxt_timecards.id%TYPE,
257: p_day IN DATE,
258: p_hol_cal_id IN hxt_holiday_calendars.id%TYPE
259: );
260:
261: PROCEDURE holiday_as_reg (
262: p_batch_id IN NUMBER,

Line 268: p_hol_cal_id IN hxt_holiday_calendars.id%TYPE

264: p_period_id IN hxt_timecards.time_period_id%TYPE,
265: p_tim_id IN hxt_timecards.id%TYPE,
266: p_day IN DATE,
267: p_hours_type IN hxt_sum_hours_worked_f.element_type_id%TYPE,
268: p_hol_cal_id IN hxt_holiday_calendars.id%TYPE
269: );
270:
271: PROCEDURE validate_tc (
272: p_batch_id IN NUMBER,