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 STANDARD

Line 52: g_STANDARD_START NUMBER;

48: g_LAST_UPDATE_DATE DATE;
49: g_LAST_UPDATE_LOGIN NUMBER;
50: g_EARLY_START NUMBER;
51: g_LATE_STOP NUMBER;
52: g_STANDARD_START NUMBER;
53: g_STANDARD_STOP NUMBER;
54: g_PROJECT_ID NUMBER;
55: g_JOB_ID hxt_SUM_HOURS_WORKED.JOB_ID%TYPE;
56: g_PAY_STATUS CHAR(1);

Line 53: g_STANDARD_STOP NUMBER;

49: g_LAST_UPDATE_LOGIN NUMBER;
50: g_EARLY_START NUMBER;
51: g_LATE_STOP NUMBER;
52: g_STANDARD_START NUMBER;
53: g_STANDARD_STOP NUMBER;
54: g_PROJECT_ID NUMBER;
55: g_JOB_ID hxt_SUM_HOURS_WORKED.JOB_ID%TYPE;
56: g_PAY_STATUS CHAR(1);
57: g_PA_STATUS CHAR(1);

Line 137: ,p_standard_start IN NUMBER

133: ,p_pep_id IN NUMBER
134: ,p_pip_id IN NUMBER
135: ,p_sdovr_id IN NUMBER
136: ,p_osp_id IN NUMBER
137: ,p_standard_start IN NUMBER
138: ,p_standard_stop IN NUMBER
139: ,p_early_start IN NUMBER
140: ,p_late_stop IN NUMBER
141: ,p_hol_yn IN VARCHAR2

Line 138: ,p_standard_stop IN NUMBER

134: ,p_pip_id IN NUMBER
135: ,p_sdovr_id IN NUMBER
136: ,p_osp_id IN NUMBER
137: ,p_standard_start IN NUMBER
138: ,p_standard_stop IN NUMBER
139: ,p_early_start IN NUMBER
140: ,p_late_stop IN NUMBER
141: ,p_hol_yn IN VARCHAR2
142: ,p_person_id IN NUMBER

Line 433: g_standard_start := p_standard_start;

429: g_pep_id := p_pep_id;
430: g_pip_id := p_pip_id;
431: g_sdovr_id := p_sdovr_id;
432: g_osp_id := p_osp_id;
433: g_standard_start := p_standard_start;
434: g_standard_stop := p_standard_stop;
435: g_early_start := p_early_start;
436: g_late_stop := p_late_stop;
437: g_hol_yn := p_hol_yn;

Line 434: g_standard_stop := p_standard_stop;

430: g_pip_id := p_pip_id;
431: g_sdovr_id := p_sdovr_id;
432: g_osp_id := p_osp_id;
433: g_standard_start := p_standard_start;
434: g_standard_stop := p_standard_stop;
435: g_early_start := p_early_start;
436: g_late_stop := p_late_stop;
437: g_hol_yn := p_hol_yn;
438: g_person_id := p_person_id;

Line 1113: IF (g_EARLY_START IS NOT NULL AND g_STANDARD_START IS NOT NULL) THEN

1109: end if;
1110: p_shift_adjusted_time_in := g_TIME_IN;
1111: p_shift_adjusted_time_out := g_TIME_OUT;
1112:
1113: IF (g_EARLY_START IS NOT NULL AND g_STANDARD_START IS NOT NULL) THEN
1114: if g_debug then
1115: hr_utility.set_location('hxt_time_summary.shift_adjust_times',20);
1116: end if;
1117: IF g_EARLY_START > g_STANDARD_START THEN -- spans midnight

Line 1117: IF g_EARLY_START > g_STANDARD_START THEN -- spans midnight

1113: IF (g_EARLY_START IS NOT NULL AND g_STANDARD_START IS NOT NULL) THEN
1114: if g_debug then
1115: hr_utility.set_location('hxt_time_summary.shift_adjust_times',20);
1116: end if;
1117: IF g_EARLY_START > g_STANDARD_START THEN -- spans midnight
1118: if g_debug then
1119: hr_utility.set_location('hxt_time_summary.shift_adjust_times',30);
1120: end if;
1121: IF to_number(to_char(g_TIME_IN, 'HH24MI')) < g_STANDARD_START THEN

Line 1121: IF to_number(to_char(g_TIME_IN, 'HH24MI')) < g_STANDARD_START THEN

1117: IF g_EARLY_START > g_STANDARD_START THEN -- spans midnight
1118: if g_debug then
1119: hr_utility.set_location('hxt_time_summary.shift_adjust_times',30);
1120: end if;
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)

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 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 1140: AND g_STANDARD_START THEN

1136: if g_debug then
1137: hr_utility.set_location('hxt_time_summary.shift_adjust_times',60);
1138: end if;
1139: IF to_number(to_char(g_TIME_IN, 'HH24MI')) BETWEEN g_EARLY_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)

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 1150: IF (g_LATE_STOP IS NOT NULL AND g_STANDARD_STOP IS NOT NULL) THEN

1146: END IF;
1147: END IF;
1148: END IF;
1149:
1150: IF (g_LATE_STOP IS NOT NULL AND g_STANDARD_STOP IS NOT NULL) THEN
1151: if g_debug then
1152: hr_utility.set_location('hxt_time_summary.shift_adjust_times',80);
1153: end if;
1154: IF g_LATE_STOP < g_STANDARD_STOP THEN -- spans midnight

Line 1154: IF g_LATE_STOP < g_STANDARD_STOP THEN -- spans midnight

1150: IF (g_LATE_STOP IS NOT NULL AND g_STANDARD_STOP IS NOT NULL) THEN
1151: if g_debug then
1152: hr_utility.set_location('hxt_time_summary.shift_adjust_times',80);
1153: end if;
1154: IF g_LATE_STOP < g_STANDARD_STOP THEN -- spans midnight
1155: if g_debug then
1156: hr_utility.set_location('hxt_time_summary.shift_adjust_times',90);
1157: end if;
1158: IF to_number(to_char(g_TIME_OUT, 'HH24MI')) > g_STANDARD_STOP THEN

Line 1158: IF to_number(to_char(g_TIME_OUT, 'HH24MI')) > g_STANDARD_STOP THEN

1154: IF g_LATE_STOP < g_STANDARD_STOP THEN -- spans midnight
1155: if g_debug then
1156: hr_utility.set_location('hxt_time_summary.shift_adjust_times',90);
1157: end if;
1158: IF to_number(to_char(g_TIME_OUT, 'HH24MI')) > g_STANDARD_STOP THEN
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 -

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 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 1177: IF to_number(to_char(g_TIME_OUT, 'HH24MI')) BETWEEN g_STANDARD_STOP

1173: ELSE -- no midnight span
1174: if g_debug then
1175: hr_utility.set_location('hxt_time_summary.shift_adjust_times',120);
1176: end if;
1177: IF to_number(to_char(g_TIME_OUT, 'HH24MI')) BETWEEN g_STANDARD_STOP
1178: AND g_LATE_STOP THEN
1179: if g_debug then
1180: hr_utility.set_location('hxt_time_summary.shift_adjust_times',130);
1181: 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 1287: SELECT hs.standard_stop

1283: loop_count NUMBER := 0;--count loop passes to break if necessary
1284:
1285: /*CURSOR Get_shift_stop_time (p_assignment_id NUMBER
1286: ,p_date_worked DATE ) IS
1287: SELECT hs.standard_stop
1288: FROM hxt_shifts hs
1289: ,hxt_work_shifts hws
1290: ,hxt_per_aei_ddf_v aeiv
1291: ,hxt_rotation_schedules rts

Line 1305: ln_standard_start hxt_shifts.standard_start%TYPE;

1301: AND hws.tws_id = rts.tws_id
1302: AND hws.week_day = to_char(p_DATE_WORKED,'DY')
1303: AND hws.sht_id = hs.id;
1304: */
1305: ln_standard_start hxt_shifts.standard_start%TYPE;
1306: ln_standard_stop hxt_shifts.standard_stop%TYPE;
1307: wp_start_time DATE;
1308: wp_stop_time DATE;
1309: ld_carryover2 DATE;

Line 1306: ln_standard_stop hxt_shifts.standard_stop%TYPE;

1302: AND hws.week_day = to_char(p_DATE_WORKED,'DY')
1303: AND hws.sht_id = hs.id;
1304: */
1305: ln_standard_start hxt_shifts.standard_start%TYPE;
1306: ln_standard_stop hxt_shifts.standard_stop%TYPE;
1307: wp_start_time DATE;
1308: wp_stop_time DATE;
1309: ld_carryover2 DATE;
1310:

Line 1312: SELECT hs.standard_start , hs.standard_stop

1308: wp_stop_time DATE;
1309: ld_carryover2 DATE;
1310:
1311: CURSOR Get_Work_plan IS
1312: SELECT hs.standard_start , hs.standard_stop
1313: FROM hxt_per_aei_ddf_v aeiv
1314: ,hxt_rotation_schedules rts
1315: ,hxt_work_shifts hws
1316: ,hxt_shifts hs

Line 2462: fetch get_work_plan into ln_standard_start ,ln_standard_stop;

2458: -- Now insert the rows for work plan start stop
2459: -- into the pl sql table segment_chunks for day before , day worked and day
2460: -- after.
2461: open get_work_plan;
2462: fetch get_work_plan into ln_standard_start ,ln_standard_stop;
2463: if g_debug then
2464: hr_utility.trace('ln_standard_start :'|| ln_standard_start);
2465: hr_utility.trace('ln_standard_stop :'|| ln_standard_stop);
2466: end if;

Line 2464: hr_utility.trace('ln_standard_start :'|| ln_standard_start);

2460: -- after.
2461: open get_work_plan;
2462: fetch get_work_plan into ln_standard_start ,ln_standard_stop;
2463: if g_debug then
2464: hr_utility.trace('ln_standard_start :'|| ln_standard_start);
2465: hr_utility.trace('ln_standard_stop :'|| ln_standard_stop);
2466: end if;
2467: close get_work_plan;
2468:

Line 2465: hr_utility.trace('ln_standard_stop :'|| ln_standard_stop);

2461: open get_work_plan;
2462: fetch get_work_plan into ln_standard_start ,ln_standard_stop;
2463: if g_debug then
2464: hr_utility.trace('ln_standard_start :'|| ln_standard_start);
2465: hr_utility.trace('ln_standard_stop :'|| ln_standard_stop);
2466: end if;
2467: close get_work_plan;
2468:
2469: wplan_date_worked := TRUNC(p_shift_adjusted_time_in - 1, 'DD');

Line 2475: time_in_dates(ln_standard_start

2471: if g_debug then
2472: hr_utility.trace('wplan_date_worked :'
2473: || to_char(wplan_date_worked,'DD-MON-YYYY HH24:MI:SS'));
2474: end if;
2475: time_in_dates(ln_standard_start
2476: ,ln_standard_stop
2477: ,null
2478: ,wp_start_time
2479: ,wp_stop_time

Line 2476: ,ln_standard_stop

2472: hr_utility.trace('wplan_date_worked :'
2473: || to_char(wplan_date_worked,'DD-MON-YYYY HH24:MI:SS'));
2474: end if;
2475: time_in_dates(ln_standard_start
2476: ,ln_standard_stop
2477: ,null
2478: ,wp_start_time
2479: ,wp_stop_time
2480: ,ld_carryover2

Line 2730: fetch Get_Shift_stop_time into lv_standard_stop;

2726: -- CHECK IF THERE IS A SHIFT DIFFERENTIAL OVERRIDE APPLICABLE TO THIS DAY
2727: ELSIF g_sdovr_id is NOT NULL THEN
2728:
2729: open Get_Shift_stop_time( g_ASSIGNMENT_ID,g_DATE_WORKED );
2730: fetch Get_Shift_stop_time into lv_standard_stop;
2731: if g_debug then
2732: hr_utility.trace('lv_standard_stop :'||lv_standard_stop);
2733: end if;
2734: close Get_Shift_stop_time;

Line 2732: hr_utility.trace('lv_standard_stop :'||lv_standard_stop);

2728:
2729: open Get_Shift_stop_time( g_ASSIGNMENT_ID,g_DATE_WORKED );
2730: fetch Get_Shift_stop_time into lv_standard_stop;
2731: if g_debug then
2732: hr_utility.trace('lv_standard_stop :'||lv_standard_stop);
2733: end if;
2734: close Get_Shift_stop_time;
2735:
2736: -- IF working from 0800 to 2300 then pay only regular hours

Line 2739: IF to_number(to_char(segment_stop_time,'HH24MI')) < lv_standard_stop THEN

2735:
2736: -- IF working from 0800 to 2300 then pay only regular hours
2737: -- from 1200 to 1700 (shift diff defined from 0800 to 1200) and
2738: -- shift diff Override from 1700 to 2300
2739: IF to_number(to_char(segment_stop_time,'HH24MI')) < lv_standard_stop THEN
2740: if g_debug then
2741: hr_utility.set_location('hxt_time_summary.gen_details',75);
2742: end if;
2743: -- segment_stop_time := lv_standard_stop;

Line 2743: -- segment_stop_time := lv_standard_stop;

2739: IF to_number(to_char(segment_stop_time,'HH24MI')) < lv_standard_stop THEN
2740: if g_debug then
2741: hr_utility.set_location('hxt_time_summary.gen_details',75);
2742: end if;
2743: -- segment_stop_time := lv_standard_stop;
2744: segment_stop_time := to_date((to_char(g_date_worked, 'DDMMYYYY')||lv_standard_stop), 'DDMMYYYYHH24MI');
2745: if g_debug then
2746: hr_utility.trace('segment_stop_time :'
2747: ||to_char(segment_stop_time,'DD-MON-YYYY HH24:MI:SS'));

Line 2744: segment_stop_time := to_date((to_char(g_date_worked, 'DDMMYYYY')||lv_standard_stop), 'DDMMYYYYHH24MI');

2740: if g_debug then
2741: hr_utility.set_location('hxt_time_summary.gen_details',75);
2742: end if;
2743: -- segment_stop_time := lv_standard_stop;
2744: segment_stop_time := to_date((to_char(g_date_worked, 'DDMMYYYY')||lv_standard_stop), 'DDMMYYYYHH24MI');
2745: if g_debug then
2746: hr_utility.trace('segment_stop_time :'
2747: ||to_char(segment_stop_time,'DD-MON-YYYY HH24:MI:SS'));
2748: hr_utility.trace('segment_start_time :'

Line 2756: ELSE -- segment_stop_time >= lv_standard_stop

2752: if g_debug then
2753: hr_utility.trace('hours_worked :'||hours_worked);
2754: end if;
2755: sd_rule_earning := NULL;
2756: ELSE -- segment_stop_time >= lv_standard_stop
2757: if g_debug then
2758: hr_utility.set_location('hxt_time_summary.gen_details',76);
2759: end if;
2760: segment_stop_time := p_shift_adjusted_time_out;