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_TIME_SUMMARY dependencies on HXT_UTIL

Line 291: l_costable_type := HXT_UTIL.get_costable_type(g_element_type_id,

287: IF g_amount IS NOT NULL THEN
288: l_amount := g_amount ;
289: END IF ;
290:
291: l_costable_type := HXT_UTIL.get_costable_type(g_element_type_id,
292: g_date_worked,
293: g_assignment_id);
294: IF g_debug THEN
295: hr_utility.trace('l_costable_type :'||l_costable_type);

Line 750: hxt_util.gen_error(g_tim_id

746: end if;
747: --Checking of the hours worked table for the current id is done so that
748: --validation is not done on a record being deleted.
749:
750: hxt_util.gen_error(g_tim_id
751: ,g_id
752: ,NULL
753: ,p_error_text
754: ,p_location

Line 777: hxt_util.gen_error(g_tim_id

773: WHEN OTHERS THEN
774: if g_debug then
775: hr_utility.set_location('hxt_time_summary.call_gen_error',40);
776: end if;
777: hxt_util.gen_error(g_tim_id
778: ,g_id
779: ,NULL
780: ,p_error_text
781: ,p_location

Line 812: hxt_util.gen_error(g_tim_id

808: end if;
809: --Checking of the hours worked table for the current id is done so that
810: --validation is not done on a record being deleted.
811:
812: hxt_util.gen_error(g_tim_id
813: ,g_id
814: ,NULL
815: ,p_error_text
816: ,p_location

Line 852: hxt_util.gen_error(g_tim_id

848: WHEN OTHERS THEN
849: if g_debug then
850: hr_utility.set_location('hxt_time_summary.call_gen_error',40);
851: end if;
852: hxt_util.gen_error(g_tim_id
853: ,g_id
854: ,NULL
855: ,p_error_text
856: ,p_location

Line 931: l_cat := hxt_util.element_cat(g_element_type_id

927:
928: if g_debug then
929: hr_utility.set_location('hxt_time_summary.valid_data',50);
930: end if;
931: l_cat := hxt_util.element_cat(g_element_type_id
932: ,g_date_worked);
933:
934: END IF;
935:

Line 1125: p_shift_adjusted_time_in := g_TIME_IN + ((hxt_util.time_to_hours(g_STANDARD_START)

1121: IF to_number(to_char(g_TIME_IN, 'HH24MI')) < g_STANDARD_START THEN
1122: if g_debug then
1123: hr_utility.set_location('hxt_time_summary.shift_adjust_times',40);
1124: end if;
1125: p_shift_adjusted_time_in := g_TIME_IN + ((hxt_util.time_to_hours(g_STANDARD_START)
1126: - hxt_util.time_to_hours(to_number(to_char(g_TIME_IN, 'HH24MI')))) / 24);
1127: ELSIF to_number(to_char(g_TIME_IN, 'HH24MI')) > g_EARLY_START THEN
1128: if g_debug then
1129: hr_utility.set_location('hxt_time_summary.shift_adjust_times',50);

Line 1126: - hxt_util.time_to_hours(to_number(to_char(g_TIME_IN, 'HH24MI')))) / 24);

1122: if g_debug then
1123: hr_utility.set_location('hxt_time_summary.shift_adjust_times',40);
1124: end if;
1125: p_shift_adjusted_time_in := g_TIME_IN + ((hxt_util.time_to_hours(g_STANDARD_START)
1126: - hxt_util.time_to_hours(to_number(to_char(g_TIME_IN, 'HH24MI')))) / 24);
1127: ELSIF to_number(to_char(g_TIME_IN, 'HH24MI')) > g_EARLY_START THEN
1128: if g_debug then
1129: hr_utility.set_location('hxt_time_summary.shift_adjust_times',50);
1130: end if;

Line 1131: p_shift_adjusted_time_in := g_TIME_IN + ((hxt_util.time_to_hours(g_STANDARD_START)

1127: ELSIF to_number(to_char(g_TIME_IN, 'HH24MI')) > g_EARLY_START THEN
1128: if g_debug then
1129: hr_utility.set_location('hxt_time_summary.shift_adjust_times',50);
1130: end if;
1131: p_shift_adjusted_time_in := g_TIME_IN + ((hxt_util.time_to_hours(g_STANDARD_START)
1132: + (hxt_util.time_to_hours(2400) -
1133: hxt_util.time_to_hours(to_number(to_char(g_TIME_IN, 'HH24MI'))))) / 24);
1134: END IF;
1135: ELSE -- no midnight span

Line 1132: + (hxt_util.time_to_hours(2400) -

1128: if g_debug then
1129: hr_utility.set_location('hxt_time_summary.shift_adjust_times',50);
1130: end if;
1131: p_shift_adjusted_time_in := g_TIME_IN + ((hxt_util.time_to_hours(g_STANDARD_START)
1132: + (hxt_util.time_to_hours(2400) -
1133: hxt_util.time_to_hours(to_number(to_char(g_TIME_IN, 'HH24MI'))))) / 24);
1134: END IF;
1135: ELSE -- no midnight span
1136: if g_debug then

Line 1133: hxt_util.time_to_hours(to_number(to_char(g_TIME_IN, 'HH24MI'))))) / 24);

1129: hr_utility.set_location('hxt_time_summary.shift_adjust_times',50);
1130: end if;
1131: p_shift_adjusted_time_in := g_TIME_IN + ((hxt_util.time_to_hours(g_STANDARD_START)
1132: + (hxt_util.time_to_hours(2400) -
1133: hxt_util.time_to_hours(to_number(to_char(g_TIME_IN, 'HH24MI'))))) / 24);
1134: END IF;
1135: ELSE -- no midnight span
1136: if g_debug then
1137: hr_utility.set_location('hxt_time_summary.shift_adjust_times',60);

Line 1144: p_shift_adjusted_time_in := g_TIME_IN + ((hxt_util.time_to_hours(g_STANDARD_START)

1140: AND g_STANDARD_START THEN
1141: if g_debug then
1142: hr_utility.set_location('hxt_time_summary.shift_adjust_times',70);
1143: end if;
1144: p_shift_adjusted_time_in := g_TIME_IN + ((hxt_util.time_to_hours(g_STANDARD_START)
1145: - hxt_util.time_to_hours(to_number(to_char(g_TIME_IN, 'HH24MI')))) / 24);
1146: END IF;
1147: END IF;
1148: END IF;

Line 1145: - hxt_util.time_to_hours(to_number(to_char(g_TIME_IN, 'HH24MI')))) / 24);

1141: if g_debug then
1142: hr_utility.set_location('hxt_time_summary.shift_adjust_times',70);
1143: end if;
1144: p_shift_adjusted_time_in := g_TIME_IN + ((hxt_util.time_to_hours(g_STANDARD_START)
1145: - hxt_util.time_to_hours(to_number(to_char(g_TIME_IN, 'HH24MI')))) / 24);
1146: END IF;
1147: END IF;
1148: END IF;
1149:

Line 1163: (( hxt_util.time_to_hours(to_number(to_char(g_TIME_OUT, 'HH24MI')))

1159: if g_debug then
1160: hr_utility.set_location('hxt_time_summary.shift_adjust_times',100);
1161: end if;
1162: p_shift_adjusted_time_out := g_TIME_OUT -
1163: (( hxt_util.time_to_hours(to_number(to_char(g_TIME_OUT, 'HH24MI')))
1164: - (hxt_util.time_to_hours(g_STANDARD_STOP))) / 24);
1165: ELSIF to_number(to_char(g_TIME_OUT, 'HH24MI')) < g_LATE_STOP THEN
1166: if g_debug then
1167: hr_utility.set_location('hxt_time_summary.shift_adjust_times',110);

Line 1164: - (hxt_util.time_to_hours(g_STANDARD_STOP))) / 24);

1160: hr_utility.set_location('hxt_time_summary.shift_adjust_times',100);
1161: end if;
1162: p_shift_adjusted_time_out := g_TIME_OUT -
1163: (( hxt_util.time_to_hours(to_number(to_char(g_TIME_OUT, 'HH24MI')))
1164: - (hxt_util.time_to_hours(g_STANDARD_STOP))) / 24);
1165: ELSIF to_number(to_char(g_TIME_OUT, 'HH24MI')) < g_LATE_STOP THEN
1166: if g_debug then
1167: hr_utility.set_location('hxt_time_summary.shift_adjust_times',110);
1168: end if;

Line 1170: (( hxt_util.time_to_hours(to_number(to_char(g_TIME_OUT, 'HH24MI')))

1166: if g_debug then
1167: hr_utility.set_location('hxt_time_summary.shift_adjust_times',110);
1168: end if;
1169: p_shift_adjusted_time_out := g_TIME_OUT -
1170: (( hxt_util.time_to_hours(to_number(to_char(g_TIME_OUT, 'HH24MI')))
1171: + (hxt_util.time_to_hours(2400) - (hxt_util.time_to_hours(g_STANDARD_STOP)))) / 24);
1172: END IF;
1173: ELSE -- no midnight span
1174: if g_debug then

Line 1171: + (hxt_util.time_to_hours(2400) - (hxt_util.time_to_hours(g_STANDARD_STOP)))) / 24);

1167: hr_utility.set_location('hxt_time_summary.shift_adjust_times',110);
1168: end if;
1169: p_shift_adjusted_time_out := g_TIME_OUT -
1170: (( hxt_util.time_to_hours(to_number(to_char(g_TIME_OUT, 'HH24MI')))
1171: + (hxt_util.time_to_hours(2400) - (hxt_util.time_to_hours(g_STANDARD_STOP)))) / 24);
1172: END IF;
1173: ELSE -- no midnight span
1174: if g_debug then
1175: hr_utility.set_location('hxt_time_summary.shift_adjust_times',120);

Line 1183: (( hxt_util.time_to_hours(to_number(to_char(g_TIME_OUT, 'HH24MI')))

1179: if g_debug then
1180: hr_utility.set_location('hxt_time_summary.shift_adjust_times',130);
1181: end if;
1182: p_shift_adjusted_time_out := g_TIME_OUT -
1183: (( hxt_util.time_to_hours(to_number(to_char(g_TIME_OUT, 'HH24MI')))
1184: - (hxt_util.time_to_hours(g_STANDARD_STOP))) / 24);
1185: END IF;
1186: END IF;
1187: END IF;

Line 1184: - (hxt_util.time_to_hours(g_STANDARD_STOP))) / 24);

1180: hr_utility.set_location('hxt_time_summary.shift_adjust_times',130);
1181: end if;
1182: p_shift_adjusted_time_out := g_TIME_OUT -
1183: (( hxt_util.time_to_hours(to_number(to_char(g_TIME_OUT, 'HH24MI')))
1184: - (hxt_util.time_to_hours(g_STANDARD_STOP))) / 24);
1185: END IF;
1186: END IF;
1187: END IF;
1188:

Line 1219: HXT_UTIL.Check_For_Holiday(g_date_worked

1215: --Currently, earning type is null in the summary record unless it is of type
1216: --'ABSENCE'.
1217:
1218: --Check if absence and not in include group
1219: HXT_UTIL.Check_For_Holiday(g_date_worked
1220: ,g_hol_id
1221: ,l_hdy_id
1222: ,l_hours
1223: ,l_retcode);

Line 1327: AND hws.week_day = hxt_util.get_week_day(g_DATE_WORKED)

1323: WHERE rtp_id = rts.rtp_id
1324: AND start_date <= g_DATE_WORKED
1325: )
1326: AND hws.tws_id = rts.tws_id
1327: AND hws.week_day = hxt_util.get_week_day(g_DATE_WORKED)
1328: AND hws.sht_id = hs.id;
1329:
1330: CURSOR Get_sd_rules IS
1331: SELECT sdr.start_time

Line 2211: ((hxt_util.time_to_hours(sd_rule_carryover) -

2207: hr_utility.set_location('hxt_time_summary.set_stop_and_hours',40);
2208: end if;
2209: -- S C | ST
2210: p_segment_stop_time := segment_start_time +
2211: ((hxt_util.time_to_hours(sd_rule_carryover) -
2212: hxt_util.time_to_hours(time_in_hours)) / 24);
2213: if g_debug then
2214: hr_utility.trace('p_segment_stop_time :'||p_segment_stop_time);
2215: end if;

Line 2212: hxt_util.time_to_hours(time_in_hours)) / 24);

2208: end if;
2209: -- S C | ST
2210: p_segment_stop_time := segment_start_time +
2211: ((hxt_util.time_to_hours(sd_rule_carryover) -
2212: hxt_util.time_to_hours(time_in_hours)) / 24);
2213: if g_debug then
2214: hr_utility.trace('p_segment_stop_time :'||p_segment_stop_time);
2215: end if;
2216: END IF;

Line 2224: ((hxt_util.time_to_hours(sd_rule_carryover) -

2220: hr_utility.set_location('hxt_time_summary.set_stop_and_hours',50);
2221: end if;
2222: -- S C ST |
2223: p_segment_stop_time := segment_start_time +
2224: ((hxt_util.time_to_hours(sd_rule_carryover) -
2225: hxt_util.time_to_hours(time_in_hours)) / 24);
2226: if g_debug then
2227: hr_utility.trace('p_segment_stop_time :'||p_segment_stop_time);
2228: end if;

Line 2225: hxt_util.time_to_hours(time_in_hours)) / 24);

2221: end if;
2222: -- S C ST |
2223: p_segment_stop_time := segment_start_time +
2224: ((hxt_util.time_to_hours(sd_rule_carryover) -
2225: hxt_util.time_to_hours(time_in_hours)) / 24);
2226: if g_debug then
2227: hr_utility.trace('p_segment_stop_time :'||p_segment_stop_time);
2228: end if;
2229:

Line 2236: ((hxt_util.time_to_hours(sd_rule_carryover) +

2232: hr_utility.set_location('hxt_time_summary.set_stop_and_hours',60);
2233: end if;
2234: -- S | C ST
2235: p_segment_stop_time := segment_start_time +
2236: ((hxt_util.time_to_hours(sd_rule_carryover) +
2237: (hxt_util.time_to_hours(2400) - hxt_util.time_to_hours(time_in_hours))) / 24);
2238: if g_debug then
2239: hr_utility.trace('p_segment_stop_time :'||p_segment_stop_time);
2240: end if;

Line 2237: (hxt_util.time_to_hours(2400) - hxt_util.time_to_hours(time_in_hours))) / 24);

2233: end if;
2234: -- S | C ST
2235: p_segment_stop_time := segment_start_time +
2236: ((hxt_util.time_to_hours(sd_rule_carryover) +
2237: (hxt_util.time_to_hours(2400) - hxt_util.time_to_hours(time_in_hours))) / 24);
2238: if g_debug then
2239: hr_utility.trace('p_segment_stop_time :'||p_segment_stop_time);
2240: end if;
2241: ELSIF ((time_in_hours > sd_rule_carryover) AND (time_in_hours < time_out_hours)) THEN

Line 2315: l_stop_time := segment_start_time + ((hxt_util.time_to_hours(sd_rule_start)

2311: if g_debug then
2312: hr_utility.set_location('hxt_time_summary.set_stop_at_rule',20);
2313: hr_utility.trace('segment_start_time:'||to_char(segment_start_time,'DD-MON-YYYY HH24:MI:SS'));
2314: end if;
2315: l_stop_time := segment_start_time + ((hxt_util.time_to_hours(sd_rule_start)
2316: - hxt_util.time_to_hours(time_in_hours)) / 24);
2317: -- | Segment.start Rule.start or Segment.start Rule.start |
2318: if g_debug then
2319: hr_utility.trace('l_stop_time :'||to_char(l_stop_time,'DD-MON-YYYY HH24:MI:SS'));

Line 2316: - hxt_util.time_to_hours(time_in_hours)) / 24);

2312: hr_utility.set_location('hxt_time_summary.set_stop_at_rule',20);
2313: hr_utility.trace('segment_start_time:'||to_char(segment_start_time,'DD-MON-YYYY HH24:MI:SS'));
2314: end if;
2315: l_stop_time := segment_start_time + ((hxt_util.time_to_hours(sd_rule_start)
2316: - hxt_util.time_to_hours(time_in_hours)) / 24);
2317: -- | Segment.start Rule.start or Segment.start Rule.start |
2318: if g_debug then
2319: hr_utility.trace('l_stop_time :'||to_char(l_stop_time,'DD-MON-YYYY HH24:MI:SS'));
2320: end if;

Line 2326: l_stop_time := segment_start_time + ((hxt_util.time_to_hours(sd_rule_start) +

2322: if g_debug then
2323: hr_utility.set_location('hxt_time_summary.set_stop_at_rule',30);
2324: hr_utility.trace('segment_start_time:'||to_char(segment_start_time,'DD-MON-YYYY HH24:MI:SS'));
2325: end if;
2326: l_stop_time := segment_start_time + ((hxt_util.time_to_hours(sd_rule_start) +
2327: (hxt_util.time_to_hours(2400) - hxt_util.time_to_hours(time_in_hours))) / 24);
2328: -- Segment.start | Rule.start
2329: if g_debug then
2330: hr_utility.trace('l_stop_time :'||to_char(l_stop_time,'DD-MON-YYYY HH24:MI:SS'));

Line 2327: (hxt_util.time_to_hours(2400) - hxt_util.time_to_hours(time_in_hours))) / 24);

2323: hr_utility.set_location('hxt_time_summary.set_stop_at_rule',30);
2324: hr_utility.trace('segment_start_time:'||to_char(segment_start_time,'DD-MON-YYYY HH24:MI:SS'));
2325: end if;
2326: l_stop_time := segment_start_time + ((hxt_util.time_to_hours(sd_rule_start) +
2327: (hxt_util.time_to_hours(2400) - hxt_util.time_to_hours(time_in_hours))) / 24);
2328: -- Segment.start | Rule.start
2329: if g_debug then
2330: hr_utility.trace('l_stop_time :'||to_char(l_stop_time,'DD-MON-YYYY HH24:MI:SS'));
2331: end if;