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 123: g_hol_STANDARD_START NUMBER;

119: g_hol_LAST_UPDATE_DATE DATE;
120: g_hol_LAST_UPDATE_LOGIN NUMBER;
121: g_hol_EARLY_START NUMBER;
122: g_hol_LATE_STOP NUMBER;
123: g_hol_STANDARD_START NUMBER;
124: g_hol_STANDARD_STOP NUMBER;
125: g_hol_PROJECT_ID NUMBER;
126: g_hol_JOB_ID hxt_SUM_HOURS_WORKED.JOB_ID%TYPE;
127: g_hol_PAY_STATUS CHAR(1);

Line 124: g_hol_STANDARD_STOP NUMBER;

120: g_hol_LAST_UPDATE_LOGIN NUMBER;
121: g_hol_EARLY_START NUMBER;
122: g_hol_LATE_STOP NUMBER;
123: g_hol_STANDARD_START NUMBER;
124: g_hol_STANDARD_STOP NUMBER;
125: g_hol_PROJECT_ID NUMBER;
126: g_hol_JOB_ID hxt_SUM_HOURS_WORKED.JOB_ID%TYPE;
127: g_hol_PAY_STATUS CHAR(1);
128: g_hol_PA_STATUS CHAR(1);

Line 226: g_hol_standard_start := g_standard_start;

222: g_hol_pep_id := g_pep_id;
223: g_hol_pip_id := g_pip_id;
224: g_hol_sdovr_id := g_sdovr_id;
225: g_hol_osp_id := g_osp_id;
226: g_hol_standard_start := g_standard_start;
227: g_hol_standard_stop := g_standard_stop;
228: g_hol_early_start := g_early_start;
229: g_hol_late_stop := g_late_stop;
230: g_hol_hol_yn := g_hol_yn;

Line 227: g_hol_standard_stop := g_standard_stop;

223: g_hol_pip_id := g_pip_id;
224: g_hol_sdovr_id := g_sdovr_id;
225: g_hol_osp_id := g_osp_id;
226: g_hol_standard_start := g_standard_start;
227: g_hol_standard_stop := g_standard_stop;
228: g_hol_early_start := g_early_start;
229: g_hol_late_stop := g_late_stop;
230: g_hol_hol_yn := g_hol_yn;
231: g_hol_person_id := g_person_id;

Line 392: g_hol_standard_start := NULL;

388: g_hol_pep_id := NULL;
389: g_hol_pip_id := NULL;
390: g_hol_sdovr_id := NULL;
391: g_hol_osp_id := NULL;
392: g_hol_standard_start := NULL;
393: g_hol_standard_stop := NULL;
394: g_hol_early_start := NULL;
395: g_hol_late_stop := NULL;
396: g_hol_hol_yn := NULL;

Line 393: g_hol_standard_stop := NULL;

389: g_hol_pip_id := NULL;
390: g_hol_sdovr_id := NULL;
391: g_hol_osp_id := NULL;
392: g_hol_standard_start := NULL;
393: g_hol_standard_stop := NULL;
394: g_hol_early_start := NULL;
395: g_hol_late_stop := NULL;
396: g_hol_hol_yn := NULL;
397: g_hol_person_id := NULL;

Line 1059: g_standard_start := g_hol_standard_start;

1055: g_pep_id := g_hol_pep_id;
1056: g_pip_id := g_hol_pip_id;
1057: g_sdovr_id := g_hol_sdovr_id;
1058: g_osp_id := g_hol_osp_id;
1059: g_standard_start := g_hol_standard_start;
1060: g_standard_stop := g_hol_standard_stop;
1061: g_early_start := g_hol_early_start;
1062: g_late_stop := g_hol_late_stop;
1063: g_hol_yn := g_hol_hol_yn;

Line 1060: g_standard_stop := g_hol_standard_stop;

1056: g_pip_id := g_hol_pip_id;
1057: g_sdovr_id := g_hol_sdovr_id;
1058: g_osp_id := g_hol_osp_id;
1059: g_standard_start := g_hol_standard_start;
1060: g_standard_stop := g_hol_standard_stop;
1061: g_early_start := g_hol_early_start;
1062: g_late_stop := g_hol_late_stop;
1063: g_hol_yn := g_hol_hol_yn;
1064: g_person_id := g_hol_person_id;

Line 1268: ,p_standard_start IN NUMBER

1264: ,p_pep_id IN NUMBER
1265: ,p_pip_id IN NUMBER
1266: ,p_sdovr_id IN NUMBER
1267: ,p_osp_id IN NUMBER
1268: ,p_standard_start IN NUMBER
1269: ,p_standard_stop IN NUMBER
1270: ,p_early_start IN NUMBER
1271: ,p_late_stop IN NUMBER
1272: ,p_hol_yn IN VARCHAR2

Line 1269: ,p_standard_stop IN NUMBER

1265: ,p_pip_id IN NUMBER
1266: ,p_sdovr_id IN NUMBER
1267: ,p_osp_id IN NUMBER
1268: ,p_standard_start IN NUMBER
1269: ,p_standard_stop IN NUMBER
1270: ,p_early_start IN NUMBER
1271: ,p_late_stop IN NUMBER
1272: ,p_hol_yn IN VARCHAR2
1273: ,p_person_id IN NUMBER

Line 1605: g_standard_start := p_standard_start;

1601: g_pep_id := p_pep_id;
1602: g_pip_id := p_pip_id;
1603: g_sdovr_id := p_sdovr_id;
1604: g_osp_id := p_osp_id;
1605: g_standard_start := p_standard_start;
1606: g_standard_stop := p_standard_stop;
1607: g_early_start := p_early_start;
1608: g_late_stop := p_late_stop;
1609: g_hol_yn := p_hol_yn;

Line 1606: g_standard_stop := p_standard_stop;

1602: g_pip_id := p_pip_id;
1603: g_sdovr_id := p_sdovr_id;
1604: g_osp_id := p_osp_id;
1605: g_standard_start := p_standard_start;
1606: g_standard_stop := p_standard_stop;
1607: g_early_start := p_early_start;
1608: g_late_stop := p_late_stop;
1609: g_hol_yn := p_hol_yn;
1610: g_person_id := p_person_id;

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

2400: end if;
2401: p_shift_adjusted_time_in := g_TIME_IN;
2402: p_shift_adjusted_time_out := g_TIME_OUT;
2403:
2404: IF (g_EARLY_START IS NOT NULL AND g_STANDARD_START IS NOT NULL) THEN
2405: if g_debug then
2406: hr_utility.set_location('hxt_time_summary.shift_adjust_times',20);
2407: end if;
2408: IF g_EARLY_START > g_STANDARD_START THEN -- spans midnight

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

2404: IF (g_EARLY_START IS NOT NULL AND g_STANDARD_START IS NOT NULL) THEN
2405: if g_debug then
2406: hr_utility.set_location('hxt_time_summary.shift_adjust_times',20);
2407: end if;
2408: IF g_EARLY_START > g_STANDARD_START THEN -- spans midnight
2409: if g_debug then
2410: hr_utility.set_location('hxt_time_summary.shift_adjust_times',30);
2411: end if;
2412: IF to_number(to_char(g_TIME_IN, 'HH24MI')) < g_STANDARD_START THEN

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

2408: IF g_EARLY_START > g_STANDARD_START THEN -- spans midnight
2409: if g_debug then
2410: hr_utility.set_location('hxt_time_summary.shift_adjust_times',30);
2411: end if;
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)

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

2427: if g_debug then
2428: hr_utility.set_location('hxt_time_summary.shift_adjust_times',60);
2429: end if;
2430: IF to_number(to_char(g_TIME_IN, 'HH24MI')) BETWEEN g_EARLY_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)

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

2437: END IF;
2438: END IF;
2439: END IF;
2440:
2441: IF (g_LATE_STOP IS NOT NULL AND g_STANDARD_STOP IS NOT NULL) THEN
2442: if g_debug then
2443: hr_utility.set_location('hxt_time_summary.shift_adjust_times',80);
2444: end if;
2445: IF g_LATE_STOP < g_STANDARD_STOP THEN -- spans midnight

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

2441: IF (g_LATE_STOP IS NOT NULL AND g_STANDARD_STOP IS NOT NULL) THEN
2442: if g_debug then
2443: hr_utility.set_location('hxt_time_summary.shift_adjust_times',80);
2444: end if;
2445: IF g_LATE_STOP < g_STANDARD_STOP THEN -- spans midnight
2446: if g_debug then
2447: hr_utility.set_location('hxt_time_summary.shift_adjust_times',90);
2448: end if;
2449: IF to_number(to_char(g_TIME_OUT, 'HH24MI')) > g_STANDARD_STOP THEN

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

2445: IF g_LATE_STOP < g_STANDARD_STOP THEN -- spans midnight
2446: if g_debug then
2447: hr_utility.set_location('hxt_time_summary.shift_adjust_times',90);
2448: end if;
2449: IF to_number(to_char(g_TIME_OUT, 'HH24MI')) > g_STANDARD_STOP THEN
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 -

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

2464: ELSE -- no midnight span
2465: if g_debug then
2466: hr_utility.set_location('hxt_time_summary.shift_adjust_times',120);
2467: end if;
2468: IF to_number(to_char(g_TIME_OUT, 'HH24MI')) BETWEEN g_STANDARD_STOP
2469: AND g_LATE_STOP THEN
2470: if g_debug then
2471: hr_utility.set_location('hxt_time_summary.shift_adjust_times',130);
2472: 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 2579: SELECT hs.standard_stop

2575: loop_count NUMBER := 0;--count loop passes to break if necessary
2576:
2577: /*CURSOR Get_shift_stop_time (p_assignment_id NUMBER
2578: ,p_date_worked DATE ) IS
2579: SELECT hs.standard_stop
2580: FROM hxt_shifts hs
2581: ,hxt_work_shifts hws
2582: ,hxt_per_aei_ddf_v aeiv
2583: ,hxt_rotation_schedules rts

Line 2597: ln_standard_start hxt_shifts.standard_start%TYPE;

2593: AND hws.tws_id = rts.tws_id
2594: AND hws.week_day = to_char(p_DATE_WORKED,'DY')
2595: AND hws.sht_id = hs.id;
2596: */
2597: ln_standard_start hxt_shifts.standard_start%TYPE;
2598: ln_standard_stop hxt_shifts.standard_stop%TYPE;
2599: wp_start_time DATE;
2600: wp_stop_time DATE;
2601: ld_carryover2 DATE;

Line 2598: ln_standard_stop hxt_shifts.standard_stop%TYPE;

2594: AND hws.week_day = to_char(p_DATE_WORKED,'DY')
2595: AND hws.sht_id = hs.id;
2596: */
2597: ln_standard_start hxt_shifts.standard_start%TYPE;
2598: ln_standard_stop hxt_shifts.standard_stop%TYPE;
2599: wp_start_time DATE;
2600: wp_stop_time DATE;
2601: ld_carryover2 DATE;
2602:

Line 2604: SELECT hs.standard_start , hs.standard_stop

2600: wp_stop_time DATE;
2601: ld_carryover2 DATE;
2602:
2603: CURSOR Get_Work_plan IS
2604: SELECT hs.standard_start , hs.standard_stop
2605: FROM hxt_per_aei_ddf_v aeiv
2606: ,hxt_rotation_schedules rts
2607: ,hxt_work_shifts hws
2608: ,hxt_shifts hs

Line 3793: fetch get_work_plan into ln_standard_start ,ln_standard_stop;

3789: -- Now insert the rows for work plan start stop
3790: -- into the pl sql table segment_chunks for day before , day worked and day
3791: -- after.
3792: open get_work_plan;
3793: fetch get_work_plan into ln_standard_start ,ln_standard_stop;
3794: if g_debug then
3795: hr_utility.trace('ln_standard_start :'|| ln_standard_start);
3796: hr_utility.trace('ln_standard_stop :'|| ln_standard_stop);
3797: end if;

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

3791: -- after.
3792: open get_work_plan;
3793: fetch get_work_plan into ln_standard_start ,ln_standard_stop;
3794: if g_debug then
3795: hr_utility.trace('ln_standard_start :'|| ln_standard_start);
3796: hr_utility.trace('ln_standard_stop :'|| ln_standard_stop);
3797: end if;
3798: close get_work_plan;
3799:

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

3792: open get_work_plan;
3793: fetch get_work_plan into ln_standard_start ,ln_standard_stop;
3794: if g_debug then
3795: hr_utility.trace('ln_standard_start :'|| ln_standard_start);
3796: hr_utility.trace('ln_standard_stop :'|| ln_standard_stop);
3797: end if;
3798: close get_work_plan;
3799:
3800: wplan_date_worked := TRUNC(p_shift_adjusted_time_in - 1, 'DD');

Line 3806: time_in_dates(ln_standard_start

3802: if g_debug then
3803: hr_utility.trace('wplan_date_worked :'
3804: || to_char(wplan_date_worked,'DD-MON-YYYY HH24:MI:SS'));
3805: end if;
3806: time_in_dates(ln_standard_start
3807: ,ln_standard_stop
3808: ,null
3809: ,wp_start_time
3810: ,wp_stop_time

Line 3807: ,ln_standard_stop

3803: hr_utility.trace('wplan_date_worked :'
3804: || to_char(wplan_date_worked,'DD-MON-YYYY HH24:MI:SS'));
3805: end if;
3806: time_in_dates(ln_standard_start
3807: ,ln_standard_stop
3808: ,null
3809: ,wp_start_time
3810: ,wp_stop_time
3811: ,ld_carryover2

Line 4061: fetch Get_Shift_stop_time into lv_standard_stop;

4057: -- CHECK IF THERE IS A SHIFT DIFFERENTIAL OVERRIDE APPLICABLE TO THIS DAY
4058: ELSIF g_sdovr_id is NOT NULL THEN
4059:
4060: open Get_Shift_stop_time( g_ASSIGNMENT_ID,g_DATE_WORKED );
4061: fetch Get_Shift_stop_time into lv_standard_stop;
4062: if g_debug then
4063: hr_utility.trace('lv_standard_stop :'||lv_standard_stop);
4064: end if;
4065: close Get_Shift_stop_time;

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

4059:
4060: open Get_Shift_stop_time( g_ASSIGNMENT_ID,g_DATE_WORKED );
4061: fetch Get_Shift_stop_time into lv_standard_stop;
4062: if g_debug then
4063: hr_utility.trace('lv_standard_stop :'||lv_standard_stop);
4064: end if;
4065: close Get_Shift_stop_time;
4066:
4067: -- IF working from 0800 to 2300 then pay only regular hours

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

4066:
4067: -- IF working from 0800 to 2300 then pay only regular hours
4068: -- from 1200 to 1700 (shift diff defined from 0800 to 1200) and
4069: -- shift diff Override from 1700 to 2300
4070: IF to_number(to_char(segment_stop_time,'HH24MI')) < lv_standard_stop THEN
4071: if g_debug then
4072: hr_utility.set_location('hxt_time_summary.gen_details',75);
4073: end if;
4074: -- segment_stop_time := lv_standard_stop;

Line 4074: -- segment_stop_time := lv_standard_stop;

4070: IF to_number(to_char(segment_stop_time,'HH24MI')) < lv_standard_stop THEN
4071: if g_debug then
4072: hr_utility.set_location('hxt_time_summary.gen_details',75);
4073: end if;
4074: -- segment_stop_time := lv_standard_stop;
4075: segment_stop_time := to_date((to_char(g_date_worked, 'DDMMYYYY')||lv_standard_stop), 'DDMMYYYYHH24MI');
4076: if g_debug then
4077: hr_utility.trace('segment_stop_time :'
4078: ||to_char(segment_stop_time,'DD-MON-YYYY HH24:MI:SS'));

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

4071: if g_debug then
4072: hr_utility.set_location('hxt_time_summary.gen_details',75);
4073: end if;
4074: -- segment_stop_time := lv_standard_stop;
4075: segment_stop_time := to_date((to_char(g_date_worked, 'DDMMYYYY')||lv_standard_stop), 'DDMMYYYYHH24MI');
4076: if g_debug then
4077: hr_utility.trace('segment_stop_time :'
4078: ||to_char(segment_stop_time,'DD-MON-YYYY HH24:MI:SS'));
4079: hr_utility.trace('segment_start_time :'

Line 4087: ELSE -- segment_stop_time >= lv_standard_stop

4083: if g_debug then
4084: hr_utility.trace('hours_worked :'||hours_worked);
4085: end if;
4086: sd_rule_earning := NULL;
4087: ELSE -- segment_stop_time >= lv_standard_stop
4088: if g_debug then
4089: hr_utility.set_location('hxt_time_summary.gen_details',76);
4090: end if;
4091: segment_stop_time := p_shift_adjusted_time_out;