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 PER_TIME_PERIODS

Line 19: period_id per_time_periods.time_period_id%TYPE,

15:
16: TYPE batch_info_rec IS RECORD (
17: batch_id pay_batch_headers.batch_id%TYPE,
18: batch_ref pay_batch_headers.batch_reference%TYPE,
19: period_id per_time_periods.time_period_id%TYPE,
20: num_tcs NUMBER
21: );
22:
23: TYPE batch_info_table IS TABLE OF batch_info_rec

Line 152: p_time_period_id IN per_time_periods.time_period_id%TYPE,

148: )
149: RETURN NUMBER;
150:
151: FUNCTION find_existing_batch (
152: p_time_period_id IN per_time_periods.time_period_id%TYPE,
153: p_batch_reference IN pay_batch_headers.batch_reference%TYPE
154: )
155: RETURN pay_batch_headers.batch_id%TYPE;
156:

Line 481: l_time_period_id per_time_periods.time_period_id%TYPE

477: l_task_id hxt_tasks_v.task_id%TYPE DEFAULT NULL;
478: l_location_id hr_locations.location_id%TYPE DEFAULT NULL;
479: l_project_id hxt_sum_hours_worked.project_id%TYPE
480: DEFAULT NULL;
481: l_time_period_id per_time_periods.time_period_id%TYPE
482: DEFAULT NULL;
483: l_start_date DATE DEFAULT NULL;
484: l_end_date DATE DEFAULT NULL;
485: l_auto_gen_flag hxt_timecards.auto_gen_flag%TYPE

Line 2942: per_time_periods ptp --SIR286

2938: IS
2939: SELECT tim.for_person_id, tbh.status, ptp.start_date --SIR286
2940: FROM hxt_timecards tim, --SIR290
2941: hxt_batch_states tbh,
2942: per_time_periods ptp --SIR286
2943: WHERE tim.ID = c_tim_id
2944: AND tbh.batch_id = tim.batch_id
2945: AND ptp.time_period_id = tim.time_period_id -- SIR286
2946: ; --SIR290

Line 3169: FROM per_time_periods

3165: IS
3166: BEGIN
3167: SELECT time_period_id, start_date, end_date
3168: INTO o_time_period, o_start_date, o_end_date
3169: FROM per_time_periods
3170: WHERE payroll_id = i_payroll_id
3171: AND TRUNC (i_date_worked) BETWEEN TRUNC (start_date) AND TRUNC
3172: (end_date);
3173:

Line 3659: p_time_period_id IN per_time_periods.time_period_id%TYPE,

3655: batches must be in a hold status (batch_status = 'H')
3656: and have less than the max amount of timecards allowed per batch.
3657: ********************************************************************/
3658: FUNCTION find_existing_batch (
3659: p_time_period_id IN per_time_periods.time_period_id%TYPE,
3660: p_batch_reference IN pay_batch_headers.batch_reference%TYPE
3661: )
3662: RETURN pay_batch_headers.batch_id%TYPE
3663: IS

Line 3665: p_time_period_id per_time_periods.time_period_id%TYPE,

3661: )
3662: RETURN pay_batch_headers.batch_id%TYPE
3663: IS
3664: CURSOR csr_timecard_batches (
3665: p_time_period_id per_time_periods.time_period_id%TYPE,
3666: p_batch_reference pay_batch_headers.batch_reference%TYPE
3667: )
3668: IS
3669: SELECT COUNT (ht.ID) num_tcs, MAX (ht.batch_id) batch_id