APPS.HXT_TIME_GEN dependencies on STANDARD

Line 431: a_standard_start OUT NOCOPY NUMBER,

427: a_date IN DATE,
428: a_work_id IN NUMBER,
429: a_osp_id OUT NOCOPY NUMBER,
430: a_sdf_id OUT NOCOPY NUMBER,
431: a_standard_start OUT NOCOPY NUMBER,
432: a_standard_stop OUT NOCOPY NUMBER,
433: a_early_start OUT NOCOPY NUMBER,
434: a_late_stop OUT NOCOPY NUMBER --SIR212
435: ,

Line 432: a_standard_stop OUT NOCOPY NUMBER,

428: a_work_id IN NUMBER,
429: a_osp_id OUT NOCOPY NUMBER,
430: a_sdf_id OUT NOCOPY NUMBER,
431: a_standard_start OUT NOCOPY NUMBER,
432: a_standard_stop OUT NOCOPY NUMBER,
433: a_early_start OUT NOCOPY NUMBER,
434: a_late_stop OUT NOCOPY NUMBER --SIR212
435: ,
436: a_hours OUT NOCOPY NUMBER

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

452: --
453: CURSOR work_day (a_wp_id NUMBER, a_date DATE)
454: IS
455: SELECT wsh.off_shift_prem_id, wsh.shift_diff_ovrrd_id,
456: sht.standard_start, sht.standard_stop, sht.early_start,
457: sht.late_stop, sht.hours
458: FROM hxt_shifts sht,
459: hxt_weekly_work_schedules wws,
460: hxt_work_shifts wsh

Line 471: a_standard_start,

467: -- Get shift diff and off-shift premiums
468: OPEN work_day (a_work_id, a_date);
469: FETCH work_day INTO a_osp_id,
470: a_sdf_id,
471: a_standard_start,
472: a_standard_stop,
473: a_early_start,
474: a_late_stop,
475: a_hours;

Line 472: a_standard_stop,

468: OPEN work_day (a_work_id, a_date);
469: FETCH work_day INTO a_osp_id,
470: a_sdf_id,
471: a_standard_start,
472: a_standard_stop,
473: a_early_start,
474: a_late_stop,
475: a_hours;
476: CLOSE work_day;

Line 502: l_standard_start NUMBER;

498: l_location VARCHAR2 (100);
499: l_days NUMBER;
500: l_time_in hxt_det_hours_worked.time_in%TYPE; --C421
501: l_time_out hxt_det_hours_worked.time_out%TYPE; --C421
502: l_standard_start NUMBER;
503: l_standard_stop NUMBER;
504: l_early_start NUMBER;
505: l_late_stop NUMBER;
506: l_error NUMBER;

Line 503: l_standard_stop NUMBER;

499: l_days NUMBER;
500: l_time_in hxt_det_hours_worked.time_in%TYPE; --C421
501: l_time_out hxt_det_hours_worked.time_out%TYPE; --C421
502: l_standard_start NUMBER;
503: l_standard_stop NUMBER;
504: l_early_start NUMBER;
505: l_late_stop NUMBER;
506: l_error NUMBER;
507: l_hours NUMBER;

Line 526: l_standard_start,

522: + i,
523: a_tws_id,
524: g_osp_id,
525: g_sdf_id,
526: l_standard_start,
527: l_standard_stop,
528: l_early_start,
529: l_late_stop,
530: l_hours

Line 527: l_standard_stop,

523: a_tws_id,
524: g_osp_id,
525: g_sdf_id,
526: l_standard_start,
527: l_standard_stop,
528: l_early_start,
529: l_late_stop,
530: l_hours
531: );

Line 537: + i, l_standard_start);

533: -- Create summary record - if holiday, time_out may be changed
534: IF (l_hours IS NULL)
535: THEN --SIR212
536: l_time_in := convert_time ( a_start
537: + i, l_standard_start);
538: l_time_out := convert_time (
539: a_start
540: + i,
541: l_standard_start,

Line 541: l_standard_start,

537: + i, l_standard_start);
538: l_time_out := convert_time (
539: a_start
540: + i,
541: l_standard_start,
542: l_standard_stop
543: );
544: END IF; --SIR212
545:

Line 542: l_standard_stop

538: l_time_out := convert_time (
539: a_start
540: + i,
541: l_standard_start,
542: l_standard_stop
543: );
544: END IF; --SIR212
545:
546: create_hrw (

Line 981: NULL -- standard_start

977: g_sdf_id --SPR C389
978: ,
979: g_osp_id --SPR C389
980: ,
981: NULL -- standard_start
982: ,
983: NULL -- standard_stop
984: ,
985: NULL -- early_start

Line 983: NULL -- standard_stop

979: g_osp_id --SPR C389
980: ,
981: NULL -- standard_start
982: ,
983: NULL -- standard_stop
984: ,
985: NULL -- early_start
986: ,
987: NULL -- late_stop