APPS.HXT_TIME_CLOCK dependencies on STANDARD

Line 904: l_standard_start NUMBER;

900: l_hours NUMBER;
901: l_work_id NUMBER;
902: l_osp_id NUMBER;
903: l_sdf_id NUMBER;
904: l_standard_start NUMBER;
905: l_standard_stop NUMBER;
906: l_early_start NUMBER;
907: l_late_stop NUMBER;
908: --END SIR344

Line 905: l_standard_stop NUMBER;

901: l_work_id NUMBER;
902: l_osp_id NUMBER;
903: l_sdf_id NUMBER;
904: l_standard_start NUMBER;
905: l_standard_stop NUMBER;
906: l_early_start NUMBER;
907: l_late_stop NUMBER;
908: --END SIR344
909: BEGIN

Line 925: l_standard_start,

921: l_work_id,
922: i_hxt_rotation_plan,
923: l_osp_id,
924: l_sdf_id,
925: l_standard_start,
926: l_standard_stop,
927: l_early_start,
928: l_late_stop,
929: l_hours,

Line 926: l_standard_stop,

922: i_hxt_rotation_plan,
923: l_osp_id,
924: l_sdf_id,
925: l_standard_start,
926: l_standard_stop,
927: l_early_start,
928: l_late_stop,
929: l_hours,
930: l_retcode);

Line 939: to_char(l_standard_start,'0009'), 'DDMMYYYY HH24MI');

935: l_time_out := NULL;
936: l_time_in := NULL;
937: ELSE
938: l_time_in := to_date(to_char(l_hol_rec.holiday_date,'DDMMYYYY ')||
939: to_char(l_standard_start,'0009'), 'DDMMYYYY HH24MI');
940: l_time_out := to_date(to_char(l_hol_rec.holiday_date,'DDMMYYYY ')||
941: to_char(l_standard_stop,'0009'), 'DDMMYYYY HH24MI');
942: l_hours := 24 * (l_time_out - l_time_in);
943: IF l_hours = 0 THEN

Line 941: to_char(l_standard_stop,'0009'), 'DDMMYYYY HH24MI');

937: ELSE
938: l_time_in := to_date(to_char(l_hol_rec.holiday_date,'DDMMYYYY ')||
939: to_char(l_standard_start,'0009'), 'DDMMYYYY HH24MI');
940: l_time_out := to_date(to_char(l_hol_rec.holiday_date,'DDMMYYYY ')||
941: to_char(l_standard_stop,'0009'), 'DDMMYYYY HH24MI');
942: l_hours := 24 * (l_time_out - l_time_in);
943: IF l_hours = 0 THEN
944: l_time_out := NULL;
945: l_time_in := NULL;

Line 1231: NULL, --standard start

1227: l_det_rec.pep_id,
1228: l_det_rec.pip_id,
1229: l_wsh_det_rec.shift_diff_ovrrd_id,
1230: l_wsh_det_rec.off_shift_prem_id,
1231: NULL, --standard start
1232: NULL, --standard stop
1233: NULL, --early start
1234: NULL, --late stop
1235: l_hol_yn,

Line 1232: NULL, --standard stop

1228: l_det_rec.pip_id,
1229: l_wsh_det_rec.shift_diff_ovrrd_id,
1230: l_wsh_det_rec.off_shift_prem_id,
1231: NULL, --standard start
1232: NULL, --standard stop
1233: NULL, --early start
1234: NULL, --late stop
1235: l_hol_yn,
1236: i_person_id,