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_COLLECTION dependencies on STANDARD

Line 247: p_standard_start OUT NOCOPY NUMBER,

243: p_sdf_id OUT NOCOPY NUMBER -- override shift diff
244: ,
245: p_osp_id OUT NOCOPY NUMBER -- off-shift prem
246: ,
247: p_standard_start OUT NOCOPY NUMBER,
248: p_standard_stop OUT NOCOPY NUMBER,
249: p_early_start OUT NOCOPY NUMBER,
250: p_late_stop OUT NOCOPY NUMBER,
251: p_min_tcard_intvl OUT NOCOPY NUMBER,

Line 248: p_standard_stop OUT NOCOPY NUMBER,

244: ,
245: p_osp_id OUT NOCOPY NUMBER -- off-shift prem
246: ,
247: p_standard_start OUT NOCOPY NUMBER,
248: p_standard_stop OUT NOCOPY NUMBER,
249: p_early_start OUT NOCOPY NUMBER,
250: p_late_stop OUT NOCOPY NUMBER,
251: p_min_tcard_intvl OUT NOCOPY NUMBER,
252: p_round_up OUT NOCOPY NUMBER,

Line 4003: l_standard_start NUMBER;

3999: l_hours NUMBER;
4000: l_work_id NUMBER;
4001: l_osp_id NUMBER;
4002: l_sdf_id NUMBER;
4003: l_standard_start NUMBER;
4004: l_standard_stop NUMBER;
4005: l_early_start NUMBER;
4006: l_late_stop NUMBER;
4007: l_proc VARCHAR2 (100);

Line 4004: l_standard_stop NUMBER;

4000: l_work_id NUMBER;
4001: l_osp_id NUMBER;
4002: l_sdf_id NUMBER;
4003: l_standard_start NUMBER;
4004: l_standard_stop NUMBER;
4005: l_early_start NUMBER;
4006: l_late_stop NUMBER;
4007: l_proc VARCHAR2 (100);
4008: BEGIN

Line 4065: l_standard_start,

4061: l_work_id,
4062: i_hxt_rotation_plan,
4063: l_osp_id,
4064: l_sdf_id,
4065: l_standard_start,
4066: l_standard_stop,
4067: l_early_start,
4068: l_late_stop,
4069: l_hours,

Line 4066: l_standard_stop,

4062: i_hxt_rotation_plan,
4063: l_osp_id,
4064: l_sdf_id,
4065: l_standard_start,
4066: l_standard_stop,
4067: l_early_start,
4068: l_late_stop,
4069: l_hours,
4070: l_retcode

Line 4111: || TO_CHAR (l_standard_start, '0009'),

4107: END IF;
4108:
4109: l_time_in :=
4110: TO_DATE ( TO_CHAR (l_hol_rec.holiday_date, 'DDMMYYYY ')
4111: || TO_CHAR (l_standard_start, '0009'),
4112: 'DDMMYYYY HH24MI'
4113: );
4114: l_time_out :=
4115: TO_DATE ( TO_CHAR (l_hol_rec.holiday_date, 'DDMMYYYY ')

Line 4116: || TO_CHAR (l_standard_stop, '0009'),

4112: 'DDMMYYYY HH24MI'
4113: );
4114: l_time_out :=
4115: TO_DATE ( TO_CHAR (l_hol_rec.holiday_date, 'DDMMYYYY ')
4116: || TO_CHAR (l_standard_stop, '0009'),
4117: 'DDMMYYYY HH24MI'
4118: );
4119: l_hours := 24 * (l_time_out - l_time_in);
4120:

Line 4348: p_standard_start OUT NOCOPY NUMBER,

4344: p_sdf_id OUT NOCOPY NUMBER -- override shift diff
4345: ,
4346: p_osp_id OUT NOCOPY NUMBER -- off-shift prem
4347: ,
4348: p_standard_start OUT NOCOPY NUMBER,
4349: p_standard_stop OUT NOCOPY NUMBER,
4350: p_early_start OUT NOCOPY NUMBER,
4351: p_late_stop OUT NOCOPY NUMBER,
4352: p_min_tcard_intvl OUT NOCOPY NUMBER,

Line 4349: p_standard_stop OUT NOCOPY NUMBER,

4345: ,
4346: p_osp_id OUT NOCOPY NUMBER -- off-shift prem
4347: ,
4348: p_standard_start OUT NOCOPY NUMBER,
4349: p_standard_stop OUT NOCOPY NUMBER,
4350: p_early_start OUT NOCOPY NUMBER,
4351: p_late_stop OUT NOCOPY NUMBER,
4352: p_min_tcard_intvl OUT NOCOPY NUMBER,
4353: p_round_up OUT NOCOPY NUMBER,

Line 4445: p_standard_start,

4441: p_work_plan,
4442: p_rotation_plan,
4443: p_osp_id,
4444: p_sdf_id,
4445: p_standard_start,
4446: p_standard_stop,
4447: p_early_start,
4448: p_late_stop,
4449: p_shift_hours,

Line 4446: p_standard_stop,

4442: p_rotation_plan,
4443: p_osp_id,
4444: p_sdf_id,
4445: p_standard_start,
4446: p_standard_stop,
4447: p_early_start,
4448: p_late_stop,
4449: p_shift_hours,
4450: p_error

Line 4683: l_standard_start NUMBER;

4679: l_hcl_id NUMBER; -- holiday calendar
4680: l_hcl_elt_id NUMBER; -- holiday earning type
4681: l_sdf_id NUMBER; -- override shift diff prem
4682: l_osp_id NUMBER; -- off-shift prem
4683: l_standard_start NUMBER;
4684: l_standard_stop NUMBER;
4685: l_early_start NUMBER;
4686: l_late_stop NUMBER;
4687: l_min_tcard_intvl NUMBER;

Line 4684: l_standard_stop NUMBER;

4680: l_hcl_elt_id NUMBER; -- holiday earning type
4681: l_sdf_id NUMBER; -- override shift diff prem
4682: l_osp_id NUMBER; -- off-shift prem
4683: l_standard_start NUMBER;
4684: l_standard_stop NUMBER;
4685: l_early_start NUMBER;
4686: l_late_stop NUMBER;
4687: l_min_tcard_intvl NUMBER;
4688: l_round_up NUMBER;

Line 4758: l_standard_start,

4754: l_hcl_id, -- holiday calendar
4755: l_hcl_elt_id, -- holiday earning type
4756: l_sdf_id, -- override shift diff prem
4757: l_osp_id, -- off-shift prem
4758: l_standard_start,
4759: l_standard_stop,
4760: l_early_start,
4761: l_late_stop,
4762: l_min_tcard_intvl,

Line 4759: l_standard_stop,

4755: l_hcl_elt_id, -- holiday earning type
4756: l_sdf_id, -- override shift diff prem
4757: l_osp_id, -- off-shift prem
4758: l_standard_start,
4759: l_standard_stop,
4760: l_early_start,
4761: l_late_stop,
4762: l_min_tcard_intvl,
4763: l_round_up,

Line 5695: NULL -- standard start

5691: l_sdf_id -- shift_diff_ovrrd_id
5692: ,
5693: l_osp_id -- off_shift_prem_id
5694: ,
5695: NULL -- standard start
5696: ,
5697: NULL -- standard stop
5698: ,
5699: NULL -- early start

Line 5697: NULL -- standard stop

5693: l_osp_id -- off_shift_prem_id
5694: ,
5695: NULL -- standard start
5696: ,
5697: NULL -- standard stop
5698: ,
5699: NULL -- early start
5700: ,
5701: NULL -- late stop

Line 6433: l_standard_start NUMBER;

6429: l_rot_id hxt_rotation_plans.ID%TYPE;
6430: l_work_id hxt_rotation_schedules.tws_id%TYPE;
6431: l_osp_id NUMBER;
6432: l_sdf_id NUMBER;
6433: l_standard_start NUMBER;
6434: l_standard_stop NUMBER;
6435: l_early_start NUMBER;
6436: l_late_stop NUMBER;
6437: l_hours NUMBER;

Line 6434: l_standard_stop NUMBER;

6430: l_work_id hxt_rotation_schedules.tws_id%TYPE;
6431: l_osp_id NUMBER;
6432: l_sdf_id NUMBER;
6433: l_standard_start NUMBER;
6434: l_standard_stop NUMBER;
6435: l_early_start NUMBER;
6436: l_late_stop NUMBER;
6437: l_hours NUMBER;
6438: l_error NUMBER;

Line 6528: l_standard_start,

6524: l_work_id,
6525: l_rot_id,
6526: l_osp_id,
6527: l_sdf_id,
6528: l_standard_start,
6529: l_standard_stop,
6530: l_early_start,
6531: l_late_stop,
6532: l_hours,

Line 6529: l_standard_stop,

6525: l_rot_id,
6526: l_osp_id,
6527: l_sdf_id,
6528: l_standard_start,
6529: l_standard_stop,
6530: l_early_start,
6531: l_late_stop,
6532: l_hours,
6533: l_error

Line 6550: -- convert time_in, standard_start, and early_start to a date, plus

6546: hr_utility.set_location (l_proc, 60);
6547: END IF;
6548:
6549: -- No error, so get the early start,etc timings...
6550: -- convert time_in, standard_start, and early_start to a date, plus
6551: -- embed date_worked into all three.
6552: IF p_time_in IS NOT NULL
6553: THEN
6554: IF (l_early_start IS NOT NULL AND l_standard_start IS NOT NULL

Line 6554: IF (l_early_start IS NOT NULL AND l_standard_start IS NOT NULL

6550: -- convert time_in, standard_start, and early_start to a date, plus
6551: -- embed date_worked into all three.
6552: IF p_time_in IS NOT NULL
6553: THEN
6554: IF (l_early_start IS NOT NULL AND l_standard_start IS NOT NULL
6555: )
6556: THEN
6557: IF g_debug
6558: THEN

Line 6580: + hxt_util.time_to_hours (l_standard_start) / 24;

6576: 'DD-MM-YYYY HH24MI'
6577: );*/
6578: l_std_date_start :=
6579: TRUNC (p_date_worked)
6580: + hxt_util.time_to_hours (l_standard_start) / 24;
6581:
6582: /* TO_DATE (
6583: TO_CHAR (
6584: p_date_worked,

Line 6587: || TO_CHAR (l_standard_start, '0009'),

6583: TO_CHAR (
6584: p_date_worked,
6585: 'DD-MM-YYYY '
6586: )
6587: || TO_CHAR (l_standard_start, '0009'),
6588: 'DD-MM-YYYY HH24MI'
6589: );*/
6590: IF g_debug
6591: THEN

Line 6640: AND l_standard_stop IS NOT NULL

6636: IF p_time_out IS NOT NULL
6637: THEN
6638: -- For Time Store
6639: IF ( ( l_late_stop IS NOT NULL
6640: AND l_standard_stop IS NOT NULL
6641: AND p_timecard_source = 'Time Store'
6642: )
6643: -- For PUI
6644: OR (p_timecard_source <> 'Time Store')

Line 6684: + hxt_util.time_to_hours (l_standard_stop) / 24;

6680: 'DD-MM-YYYY HH24MI'
6681: );*/
6682: l_std_date_stop :=
6683: TRUNC (p_date_worked)
6684: + hxt_util.time_to_hours (l_standard_stop) / 24;
6685:
6686: /* TO_DATE (
6687: TO_CHAR (p_date_worked, 'DD-MM-YYYY ')
6688: || TO_CHAR (l_standard_stop, '0009'),

Line 6688: || TO_CHAR (l_standard_stop, '0009'),

6684: + hxt_util.time_to_hours (l_standard_stop) / 24;
6685:
6686: /* TO_DATE (
6687: TO_CHAR (p_date_worked, 'DD-MM-YYYY ')
6688: || TO_CHAR (l_standard_stop, '0009'),
6689: 'DD-MM-YYYY HH24MI'
6690: );*/
6691: IF g_debug
6692: THEN

Line 6752: + hxt_util.time_to_hours (l_standard_stop) / 24;

6748: END IF;
6749:
6750: l_std_date_stop :=
6751: TRUNC (l_time_out_date)
6752: + hxt_util.time_to_hours (l_standard_stop) / 24;
6753:
6754: IF g_debug
6755: THEN
6756: hr_utility.TRACE ( 'l_time_out_date :'

Line 6814: + hxt_util.time_to_hours (l_standard_stop) / 24;

6810: TRUNC (l_time_out_date)
6811: + hxt_util.time_to_hours (l_late_stop) / 24;
6812: l_std_date_stop :=
6813: TRUNC (l_time_out_date)
6814: + hxt_util.time_to_hours (l_standard_stop) / 24;
6815:
6816: IF g_debug
6817: THEN
6818: hr_utility.TRACE ( 'l_time_out_date :'