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 244: p_standard_start OUT NOCOPY NUMBER,

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

Line 245: p_standard_stop OUT NOCOPY NUMBER,

241: ,
242: p_osp_id OUT NOCOPY NUMBER -- off-shift prem
243: ,
244: p_standard_start OUT NOCOPY NUMBER,
245: p_standard_stop OUT NOCOPY NUMBER,
246: p_early_start OUT NOCOPY NUMBER,
247: p_late_stop OUT NOCOPY NUMBER,
248: p_min_tcard_intvl OUT NOCOPY NUMBER,
249: p_round_up OUT NOCOPY NUMBER,

Line 3807: l_standard_start NUMBER;

3803: l_hours NUMBER;
3804: l_work_id NUMBER;
3805: l_osp_id NUMBER;
3806: l_sdf_id NUMBER;
3807: l_standard_start NUMBER;
3808: l_standard_stop NUMBER;
3809: l_early_start NUMBER;
3810: l_late_stop NUMBER;
3811: l_proc VARCHAR2 (100);

Line 3808: l_standard_stop NUMBER;

3804: l_work_id NUMBER;
3805: l_osp_id NUMBER;
3806: l_sdf_id NUMBER;
3807: l_standard_start NUMBER;
3808: l_standard_stop NUMBER;
3809: l_early_start NUMBER;
3810: l_late_stop NUMBER;
3811: l_proc VARCHAR2 (100);
3812: BEGIN

Line 3869: l_standard_start,

3865: l_work_id,
3866: i_hxt_rotation_plan,
3867: l_osp_id,
3868: l_sdf_id,
3869: l_standard_start,
3870: l_standard_stop,
3871: l_early_start,
3872: l_late_stop,
3873: l_hours,

Line 3870: l_standard_stop,

3866: i_hxt_rotation_plan,
3867: l_osp_id,
3868: l_sdf_id,
3869: l_standard_start,
3870: l_standard_stop,
3871: l_early_start,
3872: l_late_stop,
3873: l_hours,
3874: l_retcode

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

3911: END IF;
3912:
3913: l_time_in :=
3914: TO_DATE ( TO_CHAR (l_hol_rec.holiday_date, 'DDMMYYYY ')
3915: || TO_CHAR (l_standard_start, '0009'),
3916: 'DDMMYYYY HH24MI'
3917: );
3918: l_time_out :=
3919: TO_DATE ( TO_CHAR (l_hol_rec.holiday_date, 'DDMMYYYY ')

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

3916: 'DDMMYYYY HH24MI'
3917: );
3918: l_time_out :=
3919: TO_DATE ( TO_CHAR (l_hol_rec.holiday_date, 'DDMMYYYY ')
3920: || TO_CHAR (l_standard_stop, '0009'),
3921: 'DDMMYYYY HH24MI'
3922: );
3923: l_hours := 24 * (l_time_out - l_time_in);
3924:

Line 4151: p_standard_start OUT NOCOPY NUMBER,

4147: p_sdf_id OUT NOCOPY NUMBER -- override shift diff
4148: ,
4149: p_osp_id OUT NOCOPY NUMBER -- off-shift prem
4150: ,
4151: p_standard_start OUT NOCOPY NUMBER,
4152: p_standard_stop OUT NOCOPY NUMBER,
4153: p_early_start OUT NOCOPY NUMBER,
4154: p_late_stop OUT NOCOPY NUMBER,
4155: p_min_tcard_intvl OUT NOCOPY NUMBER,

Line 4152: p_standard_stop OUT NOCOPY NUMBER,

4148: ,
4149: p_osp_id OUT NOCOPY NUMBER -- off-shift prem
4150: ,
4151: p_standard_start OUT NOCOPY NUMBER,
4152: p_standard_stop OUT NOCOPY NUMBER,
4153: p_early_start OUT NOCOPY NUMBER,
4154: p_late_stop OUT NOCOPY NUMBER,
4155: p_min_tcard_intvl OUT NOCOPY NUMBER,
4156: p_round_up OUT NOCOPY NUMBER,

Line 4248: p_standard_start,

4244: p_work_plan,
4245: p_rotation_plan,
4246: p_osp_id,
4247: p_sdf_id,
4248: p_standard_start,
4249: p_standard_stop,
4250: p_early_start,
4251: p_late_stop,
4252: p_shift_hours,

Line 4249: p_standard_stop,

4245: p_rotation_plan,
4246: p_osp_id,
4247: p_sdf_id,
4248: p_standard_start,
4249: p_standard_stop,
4250: p_early_start,
4251: p_late_stop,
4252: p_shift_hours,
4253: p_error

Line 4460: l_standard_start NUMBER;

4456: l_hcl_id NUMBER; -- holiday calendar
4457: l_hcl_elt_id NUMBER; -- holiday earning type
4458: l_sdf_id NUMBER; -- override shift diff prem
4459: l_osp_id NUMBER; -- off-shift prem
4460: l_standard_start NUMBER;
4461: l_standard_stop NUMBER;
4462: l_early_start NUMBER;
4463: l_late_stop NUMBER;
4464: l_min_tcard_intvl NUMBER;

Line 4461: l_standard_stop NUMBER;

4457: l_hcl_elt_id NUMBER; -- holiday earning type
4458: l_sdf_id NUMBER; -- override shift diff prem
4459: l_osp_id NUMBER; -- off-shift prem
4460: l_standard_start NUMBER;
4461: l_standard_stop NUMBER;
4462: l_early_start NUMBER;
4463: l_late_stop NUMBER;
4464: l_min_tcard_intvl NUMBER;
4465: l_round_up NUMBER;

Line 4535: l_standard_start,

4531: l_hcl_id, -- holiday calendar
4532: l_hcl_elt_id, -- holiday earning type
4533: l_sdf_id, -- override shift diff prem
4534: l_osp_id, -- off-shift prem
4535: l_standard_start,
4536: l_standard_stop,
4537: l_early_start,
4538: l_late_stop,
4539: l_min_tcard_intvl,

Line 4536: l_standard_stop,

4532: l_hcl_elt_id, -- holiday earning type
4533: l_sdf_id, -- override shift diff prem
4534: l_osp_id, -- off-shift prem
4535: l_standard_start,
4536: l_standard_stop,
4537: l_early_start,
4538: l_late_stop,
4539: l_min_tcard_intvl,
4540: l_round_up,

Line 5397: NULL -- standard start

5393: l_sdf_id -- shift_diff_ovrrd_id
5394: ,
5395: l_osp_id -- off_shift_prem_id
5396: ,
5397: NULL -- standard start
5398: ,
5399: NULL -- standard stop
5400: ,
5401: NULL -- early start

Line 5399: NULL -- standard stop

5395: l_osp_id -- off_shift_prem_id
5396: ,
5397: NULL -- standard start
5398: ,
5399: NULL -- standard stop
5400: ,
5401: NULL -- early start
5402: ,
5403: NULL -- late stop

Line 6052: l_standard_start NUMBER;

6048: l_rot_id hxt_rotation_plans.ID%TYPE;
6049: l_work_id hxt_rotation_schedules.tws_id%TYPE;
6050: l_osp_id NUMBER;
6051: l_sdf_id NUMBER;
6052: l_standard_start NUMBER;
6053: l_standard_stop NUMBER;
6054: l_early_start NUMBER;
6055: l_late_stop NUMBER;
6056: l_hours NUMBER;

Line 6053: l_standard_stop NUMBER;

6049: l_work_id hxt_rotation_schedules.tws_id%TYPE;
6050: l_osp_id NUMBER;
6051: l_sdf_id NUMBER;
6052: l_standard_start NUMBER;
6053: l_standard_stop NUMBER;
6054: l_early_start NUMBER;
6055: l_late_stop NUMBER;
6056: l_hours NUMBER;
6057: l_error NUMBER;

Line 6147: l_standard_start,

6143: l_work_id,
6144: l_rot_id,
6145: l_osp_id,
6146: l_sdf_id,
6147: l_standard_start,
6148: l_standard_stop,
6149: l_early_start,
6150: l_late_stop,
6151: l_hours,

Line 6148: l_standard_stop,

6144: l_rot_id,
6145: l_osp_id,
6146: l_sdf_id,
6147: l_standard_start,
6148: l_standard_stop,
6149: l_early_start,
6150: l_late_stop,
6151: l_hours,
6152: l_error

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

6165: hr_utility.set_location (l_proc, 60);
6166: END IF;
6167:
6168: -- No error, so get the early start,etc timings...
6169: -- convert time_in, standard_start, and early_start to a date, plus
6170: -- embed date_worked into all three.
6171: IF p_time_in IS NOT NULL
6172: THEN
6173: IF (l_early_start IS NOT NULL AND l_standard_start IS NOT NULL

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

6169: -- convert time_in, standard_start, and early_start to a date, plus
6170: -- embed date_worked into all three.
6171: IF p_time_in IS NOT NULL
6172: THEN
6173: IF (l_early_start IS NOT NULL AND l_standard_start IS NOT NULL
6174: )
6175: THEN
6176: IF g_debug
6177: THEN

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

6195: 'DD-MM-YYYY HH24MI'
6196: );*/
6197: l_std_date_start :=
6198: TRUNC (p_date_worked)
6199: + hxt_util.time_to_hours (l_standard_start) / 24;
6200:
6201: /* TO_DATE (
6202: TO_CHAR (
6203: p_date_worked,

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

6202: TO_CHAR (
6203: p_date_worked,
6204: 'DD-MM-YYYY '
6205: )
6206: || TO_CHAR (l_standard_start, '0009'),
6207: 'DD-MM-YYYY HH24MI'
6208: );*/
6209: IF g_debug
6210: THEN

Line 6259: AND l_standard_stop IS NOT NULL

6255: IF p_time_out IS NOT NULL
6256: THEN
6257: -- For Time Store
6258: IF ( ( l_late_stop IS NOT NULL
6259: AND l_standard_stop IS NOT NULL
6260: AND p_timecard_source = 'Time Store'
6261: )
6262: -- For PUI
6263: OR (p_timecard_source <> 'Time Store')

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

6299: 'DD-MM-YYYY HH24MI'
6300: );*/
6301: l_std_date_stop :=
6302: TRUNC (p_date_worked)
6303: + hxt_util.time_to_hours (l_standard_stop) / 24;
6304:
6305: /* TO_DATE (
6306: TO_CHAR (p_date_worked, 'DD-MM-YYYY ')
6307: || TO_CHAR (l_standard_stop, '0009'),

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

6303: + hxt_util.time_to_hours (l_standard_stop) / 24;
6304:
6305: /* TO_DATE (
6306: TO_CHAR (p_date_worked, 'DD-MM-YYYY ')
6307: || TO_CHAR (l_standard_stop, '0009'),
6308: 'DD-MM-YYYY HH24MI'
6309: );*/
6310: IF g_debug
6311: THEN

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

6367: END IF;
6368:
6369: l_std_date_stop :=
6370: TRUNC (l_time_out_date)
6371: + hxt_util.time_to_hours (l_standard_stop) / 24;
6372:
6373: IF g_debug
6374: THEN
6375: hr_utility.TRACE ( 'l_time_out_date :'

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

6429: TRUNC (l_time_out_date)
6430: + hxt_util.time_to_hours (l_late_stop) / 24;
6431: l_std_date_stop :=
6432: TRUNC (l_time_out_date)
6433: + hxt_util.time_to_hours (l_standard_stop) / 24;
6434:
6435: IF g_debug
6436: THEN
6437: hr_utility.TRACE ( 'l_time_out_date :'