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 461: HXT_UTIL.Check_For_Holiday(g_date_worked

457: -- We no longer need to check for Holiday.
458: -- We need these global variables for all days.
459: /*
460:
461: HXT_UTIL.Check_For_Holiday(g_date_worked
462: ,g_hol_id
463: ,l_hdy_id
464: ,l_hours
465: ,l_retcode);

Line 481: HXT_UTIL.Check_For_Holiday(g_date_worked

477: -- We still need the Clear globals part and all other holiday looping for an Overridden element
478: -- but we do not want to pay anything on the Holiday days.
479: IF g_hol_element_type_id IS NOT NULL
480: THEN
481: HXT_UTIL.Check_For_Holiday(g_date_worked
482: ,g_hol_id
483: ,l_hdy_id
484: ,l_hours
485: ,l_retcode);

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

1455: IF g_amount IS NOT NULL THEN
1456: l_amount := g_amount ;
1457: END IF ;
1458:
1459: l_costable_type := HXT_UTIL.get_costable_type(g_element_type_id,
1460: g_date_worked,
1461: g_assignment_id);
1462: IF g_debug THEN
1463: hr_utility.trace('l_costable_type :'||l_costable_type);

Line 2015: hxt_util.gen_error(g_tim_id

2011: end if;
2012: --Checking of the hours worked table for the current id is done so that
2013: --validation is not done on a record being deleted.
2014:
2015: hxt_util.gen_error(g_tim_id
2016: ,g_id
2017: ,NULL
2018: ,p_error_text
2019: ,p_location

Line 2042: hxt_util.gen_error(g_tim_id

2038: WHEN OTHERS THEN
2039: if g_debug then
2040: hr_utility.set_location('hxt_time_summary.call_gen_error',40);
2041: end if;
2042: hxt_util.gen_error(g_tim_id
2043: ,g_id
2044: ,NULL
2045: ,p_error_text
2046: ,p_location

Line 2078: hxt_util.gen_error(g_tim_id

2074: end if;
2075: --Checking of the hours worked table for the current id is done so that
2076: --validation is not done on a record being deleted.
2077:
2078: hxt_util.gen_error(g_tim_id
2079: ,g_id
2080: ,NULL
2081: ,p_error_text
2082: ,p_location

Line 2118: hxt_util.gen_error(g_tim_id

2114: WHEN OTHERS THEN
2115: if g_debug then
2116: hr_utility.set_location('hxt_time_summary.call_gen_error',40);
2117: end if;
2118: hxt_util.gen_error(g_tim_id
2119: ,g_id
2120: ,NULL
2121: ,p_error_text
2122: ,p_location

Line 2207: l_cat := hxt_util.element_cat(g_element_type_id

2203:
2204: if g_debug then
2205: hr_utility.set_location('hxt_time_summary.valid_data',50);
2206: end if;
2207: l_cat := hxt_util.element_cat(g_element_type_id
2208: ,g_date_worked);
2209:
2210: END IF;
2211:

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

2412: IF to_number(to_char(g_TIME_IN, 'HH24MI')) < g_STANDARD_START THEN
2413: if g_debug then
2414: hr_utility.set_location('hxt_time_summary.shift_adjust_times',40);
2415: end if;
2416: p_shift_adjusted_time_in := g_TIME_IN + ((hxt_util.time_to_hours(g_STANDARD_START)
2417: - hxt_util.time_to_hours(to_number(to_char(g_TIME_IN, 'HH24MI')))) / 24);
2418: ELSIF to_number(to_char(g_TIME_IN, 'HH24MI')) > g_EARLY_START THEN
2419: if g_debug then
2420: hr_utility.set_location('hxt_time_summary.shift_adjust_times',50);

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

2413: if g_debug then
2414: hr_utility.set_location('hxt_time_summary.shift_adjust_times',40);
2415: end if;
2416: p_shift_adjusted_time_in := g_TIME_IN + ((hxt_util.time_to_hours(g_STANDARD_START)
2417: - hxt_util.time_to_hours(to_number(to_char(g_TIME_IN, 'HH24MI')))) / 24);
2418: ELSIF to_number(to_char(g_TIME_IN, 'HH24MI')) > g_EARLY_START THEN
2419: if g_debug then
2420: hr_utility.set_location('hxt_time_summary.shift_adjust_times',50);
2421: end if;

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

2418: ELSIF to_number(to_char(g_TIME_IN, 'HH24MI')) > g_EARLY_START THEN
2419: if g_debug then
2420: hr_utility.set_location('hxt_time_summary.shift_adjust_times',50);
2421: end if;
2422: p_shift_adjusted_time_in := g_TIME_IN + ((hxt_util.time_to_hours(g_STANDARD_START)
2423: + (hxt_util.time_to_hours(2400) -
2424: hxt_util.time_to_hours(to_number(to_char(g_TIME_IN, 'HH24MI'))))) / 24);
2425: END IF;
2426: ELSE -- no midnight span

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

2419: if g_debug then
2420: hr_utility.set_location('hxt_time_summary.shift_adjust_times',50);
2421: end if;
2422: p_shift_adjusted_time_in := g_TIME_IN + ((hxt_util.time_to_hours(g_STANDARD_START)
2423: + (hxt_util.time_to_hours(2400) -
2424: hxt_util.time_to_hours(to_number(to_char(g_TIME_IN, 'HH24MI'))))) / 24);
2425: END IF;
2426: ELSE -- no midnight span
2427: if g_debug then

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

2420: hr_utility.set_location('hxt_time_summary.shift_adjust_times',50);
2421: end if;
2422: p_shift_adjusted_time_in := g_TIME_IN + ((hxt_util.time_to_hours(g_STANDARD_START)
2423: + (hxt_util.time_to_hours(2400) -
2424: hxt_util.time_to_hours(to_number(to_char(g_TIME_IN, 'HH24MI'))))) / 24);
2425: END IF;
2426: ELSE -- no midnight span
2427: if g_debug then
2428: hr_utility.set_location('hxt_time_summary.shift_adjust_times',60);

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

2431: AND g_STANDARD_START THEN
2432: if g_debug then
2433: hr_utility.set_location('hxt_time_summary.shift_adjust_times',70);
2434: end if;
2435: p_shift_adjusted_time_in := g_TIME_IN + ((hxt_util.time_to_hours(g_STANDARD_START)
2436: - hxt_util.time_to_hours(to_number(to_char(g_TIME_IN, 'HH24MI')))) / 24);
2437: END IF;
2438: END IF;
2439: END IF;

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

2432: if g_debug then
2433: hr_utility.set_location('hxt_time_summary.shift_adjust_times',70);
2434: end if;
2435: p_shift_adjusted_time_in := g_TIME_IN + ((hxt_util.time_to_hours(g_STANDARD_START)
2436: - hxt_util.time_to_hours(to_number(to_char(g_TIME_IN, 'HH24MI')))) / 24);
2437: END IF;
2438: END IF;
2439: END IF;
2440:

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

2450: if g_debug then
2451: hr_utility.set_location('hxt_time_summary.shift_adjust_times',100);
2452: end if;
2453: p_shift_adjusted_time_out := g_TIME_OUT -
2454: (( hxt_util.time_to_hours(to_number(to_char(g_TIME_OUT, 'HH24MI')))
2455: - (hxt_util.time_to_hours(g_STANDARD_STOP))) / 24);
2456: ELSIF to_number(to_char(g_TIME_OUT, 'HH24MI')) < g_LATE_STOP THEN
2457: if g_debug then
2458: hr_utility.set_location('hxt_time_summary.shift_adjust_times',110);

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

2451: hr_utility.set_location('hxt_time_summary.shift_adjust_times',100);
2452: end if;
2453: p_shift_adjusted_time_out := g_TIME_OUT -
2454: (( hxt_util.time_to_hours(to_number(to_char(g_TIME_OUT, 'HH24MI')))
2455: - (hxt_util.time_to_hours(g_STANDARD_STOP))) / 24);
2456: ELSIF to_number(to_char(g_TIME_OUT, 'HH24MI')) < g_LATE_STOP THEN
2457: if g_debug then
2458: hr_utility.set_location('hxt_time_summary.shift_adjust_times',110);
2459: end if;

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

2457: if g_debug then
2458: hr_utility.set_location('hxt_time_summary.shift_adjust_times',110);
2459: end if;
2460: p_shift_adjusted_time_out := g_TIME_OUT -
2461: (( hxt_util.time_to_hours(to_number(to_char(g_TIME_OUT, 'HH24MI')))
2462: + (hxt_util.time_to_hours(2400) - (hxt_util.time_to_hours(g_STANDARD_STOP)))) / 24);
2463: END IF;
2464: ELSE -- no midnight span
2465: if g_debug then

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

2458: hr_utility.set_location('hxt_time_summary.shift_adjust_times',110);
2459: end if;
2460: p_shift_adjusted_time_out := g_TIME_OUT -
2461: (( hxt_util.time_to_hours(to_number(to_char(g_TIME_OUT, 'HH24MI')))
2462: + (hxt_util.time_to_hours(2400) - (hxt_util.time_to_hours(g_STANDARD_STOP)))) / 24);
2463: END IF;
2464: ELSE -- no midnight span
2465: if g_debug then
2466: hr_utility.set_location('hxt_time_summary.shift_adjust_times',120);

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

2470: if g_debug then
2471: hr_utility.set_location('hxt_time_summary.shift_adjust_times',130);
2472: end if;
2473: p_shift_adjusted_time_out := g_TIME_OUT -
2474: (( hxt_util.time_to_hours(to_number(to_char(g_TIME_OUT, 'HH24MI')))
2475: - (hxt_util.time_to_hours(g_STANDARD_STOP))) / 24);
2476: END IF;
2477: END IF;
2478: END IF;

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

2471: hr_utility.set_location('hxt_time_summary.shift_adjust_times',130);
2472: end if;
2473: p_shift_adjusted_time_out := g_TIME_OUT -
2474: (( hxt_util.time_to_hours(to_number(to_char(g_TIME_OUT, 'HH24MI')))
2475: - (hxt_util.time_to_hours(g_STANDARD_STOP))) / 24);
2476: END IF;
2477: END IF;
2478: END IF;
2479:

Line 2510: HXT_UTIL.Check_For_Holiday(g_date_worked

2506: --Currently, earning type is null in the summary record unless it is of type
2507: --'ABSENCE'.
2508:
2509: --Check if absence and not in include group
2510: HXT_UTIL.Check_For_Holiday(g_date_worked
2511: ,g_hol_id
2512: ,l_hdy_id
2513: ,l_hours
2514: ,l_retcode);

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

2615: WHERE rtp_id = rts.rtp_id
2616: AND start_date <= g_DATE_WORKED
2617: )
2618: AND hws.tws_id = rts.tws_id
2619: AND hws.week_day = hxt_util.get_week_day(g_DATE_WORKED)
2620: AND hws.sht_id = hs.id;
2621:
2622: CURSOR Get_sd_rules IS
2623: SELECT sdr.start_time

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

3524: hr_utility.set_location('hxt_time_summary.set_stop_and_hours',40);
3525: end if;
3526: -- S C | ST
3527: p_segment_stop_time := segment_start_time +
3528: ((hxt_util.time_to_hours(sd_rule_carryover) -
3529: hxt_util.time_to_hours(time_in_hours)) / 24);
3530: if g_debug then
3531: hr_utility.trace('p_segment_stop_time :'||p_segment_stop_time);
3532: end if;

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

3525: end if;
3526: -- S C | ST
3527: p_segment_stop_time := segment_start_time +
3528: ((hxt_util.time_to_hours(sd_rule_carryover) -
3529: hxt_util.time_to_hours(time_in_hours)) / 24);
3530: if g_debug then
3531: hr_utility.trace('p_segment_stop_time :'||p_segment_stop_time);
3532: end if;
3533: END IF;

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

3537: hr_utility.set_location('hxt_time_summary.set_stop_and_hours',50);
3538: end if;
3539: -- S C ST |
3540: p_segment_stop_time := segment_start_time +
3541: ((hxt_util.time_to_hours(sd_rule_carryover) -
3542: hxt_util.time_to_hours(time_in_hours)) / 24);
3543: if g_debug then
3544: hr_utility.trace('p_segment_stop_time :'||p_segment_stop_time);
3545: end if;

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

3538: end if;
3539: -- S C ST |
3540: p_segment_stop_time := segment_start_time +
3541: ((hxt_util.time_to_hours(sd_rule_carryover) -
3542: hxt_util.time_to_hours(time_in_hours)) / 24);
3543: if g_debug then
3544: hr_utility.trace('p_segment_stop_time :'||p_segment_stop_time);
3545: end if;
3546:

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

3549: hr_utility.set_location('hxt_time_summary.set_stop_and_hours',60);
3550: end if;
3551: -- S | C ST
3552: p_segment_stop_time := segment_start_time +
3553: ((hxt_util.time_to_hours(sd_rule_carryover) +
3554: (hxt_util.time_to_hours(2400) - hxt_util.time_to_hours(time_in_hours))) / 24);
3555: if g_debug then
3556: hr_utility.trace('p_segment_stop_time :'||p_segment_stop_time);
3557: end if;

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

3550: end if;
3551: -- S | C ST
3552: p_segment_stop_time := segment_start_time +
3553: ((hxt_util.time_to_hours(sd_rule_carryover) +
3554: (hxt_util.time_to_hours(2400) - hxt_util.time_to_hours(time_in_hours))) / 24);
3555: if g_debug then
3556: hr_utility.trace('p_segment_stop_time :'||p_segment_stop_time);
3557: end if;
3558: ELSIF ((time_in_hours > sd_rule_carryover) AND (time_in_hours < time_out_hours)) THEN

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

3628: if g_debug then
3629: hr_utility.set_location('hxt_time_summary.set_stop_at_rule',20);
3630: hr_utility.trace('segment_start_time:'||to_char(segment_start_time,'DD-MON-YYYY HH24:MI:SS'));
3631: end if;
3632: l_stop_time := segment_start_time + ((hxt_util.time_to_hours(sd_rule_start)
3633: - hxt_util.time_to_hours(time_in_hours)) / 24);
3634: -- | Segment.start Rule.start or Segment.start Rule.start |
3635: if g_debug then
3636: hr_utility.trace('l_stop_time :'||to_char(l_stop_time,'DD-MON-YYYY HH24:MI:SS'));

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

3629: hr_utility.set_location('hxt_time_summary.set_stop_at_rule',20);
3630: hr_utility.trace('segment_start_time:'||to_char(segment_start_time,'DD-MON-YYYY HH24:MI:SS'));
3631: end if;
3632: l_stop_time := segment_start_time + ((hxt_util.time_to_hours(sd_rule_start)
3633: - hxt_util.time_to_hours(time_in_hours)) / 24);
3634: -- | Segment.start Rule.start or Segment.start Rule.start |
3635: if g_debug then
3636: hr_utility.trace('l_stop_time :'||to_char(l_stop_time,'DD-MON-YYYY HH24:MI:SS'));
3637: end if;

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

3639: if g_debug then
3640: hr_utility.set_location('hxt_time_summary.set_stop_at_rule',30);
3641: hr_utility.trace('segment_start_time:'||to_char(segment_start_time,'DD-MON-YYYY HH24:MI:SS'));
3642: end if;
3643: l_stop_time := segment_start_time + ((hxt_util.time_to_hours(sd_rule_start) +
3644: (hxt_util.time_to_hours(2400) - hxt_util.time_to_hours(time_in_hours))) / 24);
3645: -- Segment.start | Rule.start
3646: if g_debug then
3647: hr_utility.trace('l_stop_time :'||to_char(l_stop_time,'DD-MON-YYYY HH24:MI:SS'));

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

3640: hr_utility.set_location('hxt_time_summary.set_stop_at_rule',30);
3641: hr_utility.trace('segment_start_time:'||to_char(segment_start_time,'DD-MON-YYYY HH24:MI:SS'));
3642: end if;
3643: l_stop_time := segment_start_time + ((hxt_util.time_to_hours(sd_rule_start) +
3644: (hxt_util.time_to_hours(2400) - hxt_util.time_to_hours(time_in_hours))) / 24);
3645: -- Segment.start | Rule.start
3646: if g_debug then
3647: hr_utility.trace('l_stop_time :'||to_char(l_stop_time,'DD-MON-YYYY HH24:MI:SS'));
3648: end if;