APPS.HXT_TIME_GEN dependencies on STANDARD

Line 564: a_standard_start OUT NOCOPY NUMBER,

560: a_date IN DATE,
561: a_work_id IN NUMBER,
562: a_osp_id OUT NOCOPY NUMBER,
563: a_sdf_id OUT NOCOPY NUMBER,
564: a_standard_start OUT NOCOPY NUMBER,
565: a_standard_stop OUT NOCOPY NUMBER,
566: a_early_start OUT NOCOPY NUMBER,
567: a_late_stop OUT NOCOPY NUMBER --SIR212
568: ,

Line 565: a_standard_stop OUT NOCOPY NUMBER,

561: a_work_id IN NUMBER,
562: a_osp_id OUT NOCOPY NUMBER,
563: a_sdf_id OUT NOCOPY NUMBER,
564: a_standard_start OUT NOCOPY NUMBER,
565: a_standard_stop OUT NOCOPY NUMBER,
566: a_early_start OUT NOCOPY NUMBER,
567: a_late_stop OUT NOCOPY NUMBER --SIR212
568: ,
569: a_hours OUT NOCOPY NUMBER

Line 589: sht.standard_start, sht.standard_stop, sht.early_start,

585: --
586: CURSOR work_day (a_wp_id NUMBER, a_date DATE)
587: IS
588: SELECT wsh.off_shift_prem_id, wsh.shift_diff_ovrrd_id,
589: sht.standard_start, sht.standard_stop, sht.early_start,
590: sht.late_stop, sht.hours
591: FROM hxt_shifts sht,
592: hxt_weekly_work_schedules wws,
593: hxt_work_shifts wsh

Line 604: a_standard_start,

600: -- Get shift diff and off-shift premiums
601: OPEN work_day (a_work_id, a_date);
602: FETCH work_day INTO a_osp_id,
603: a_sdf_id,
604: a_standard_start,
605: a_standard_stop,
606: a_early_start,
607: a_late_stop,
608: a_hours;

Line 605: a_standard_stop,

601: OPEN work_day (a_work_id, a_date);
602: FETCH work_day INTO a_osp_id,
603: a_sdf_id,
604: a_standard_start,
605: a_standard_stop,
606: a_early_start,
607: a_late_stop,
608: a_hours;
609: CLOSE work_day;

Line 635: l_standard_start NUMBER;

631: l_location VARCHAR2 (100);
632: l_days NUMBER;
633: l_time_in hxt_det_hours_worked.time_in%TYPE; --C421
634: l_time_out hxt_det_hours_worked.time_out%TYPE; --C421
635: l_standard_start NUMBER;
636: l_standard_stop NUMBER;
637: l_early_start NUMBER;
638: l_late_stop NUMBER;
639: l_error NUMBER;

Line 636: l_standard_stop NUMBER;

632: l_days NUMBER;
633: l_time_in hxt_det_hours_worked.time_in%TYPE; --C421
634: l_time_out hxt_det_hours_worked.time_out%TYPE; --C421
635: l_standard_start NUMBER;
636: l_standard_stop NUMBER;
637: l_early_start NUMBER;
638: l_late_stop NUMBER;
639: l_error NUMBER;
640: l_hours NUMBER;

Line 659: l_standard_start,

655: + i,
656: a_tws_id,
657: g_osp_id,
658: g_sdf_id,
659: l_standard_start,
660: l_standard_stop,
661: l_early_start,
662: l_late_stop,
663: l_hours

Line 660: l_standard_stop,

656: a_tws_id,
657: g_osp_id,
658: g_sdf_id,
659: l_standard_start,
660: l_standard_stop,
661: l_early_start,
662: l_late_stop,
663: l_hours
664: );

Line 670: + i, l_standard_start);

666: -- Create summary record - if holiday, time_out may be changed
667: IF (l_hours IS NULL)
668: THEN --SIR212
669: l_time_in := convert_time ( a_start
670: + i, l_standard_start);
671: l_time_out := convert_time (
672: a_start
673: + i,
674: l_standard_start,

Line 674: l_standard_start,

670: + i, l_standard_start);
671: l_time_out := convert_time (
672: a_start
673: + i,
674: l_standard_start,
675: l_standard_stop
676: );
677: END IF; --SIR212
678:

Line 675: l_standard_stop

671: l_time_out := convert_time (
672: a_start
673: + i,
674: l_standard_start,
675: l_standard_stop
676: );
677: END IF; --SIR212
678:
679: create_hrw (

Line 1114: NULL -- standard_start

1110: g_sdf_id --SPR C389
1111: ,
1112: g_osp_id --SPR C389
1113: ,
1114: NULL -- standard_start
1115: ,
1116: NULL -- standard_stop
1117: ,
1118: NULL -- early_start

Line 1116: NULL -- standard_stop

1112: g_osp_id --SPR C389
1113: ,
1114: NULL -- standard_start
1115: ,
1116: NULL -- standard_stop
1117: ,
1118: NULL -- early_start
1119: ,
1120: NULL -- late_stop