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 PAY_BATCH_HEADERS

Line 17: batch_id pay_batch_headers.batch_id%TYPE,

13: g_cache BOOLEAN := TRUE;
14: g_max_tc_allowed PLS_INTEGER := fnd_profile.VALUE ('HXT_BATCH_SIZE');
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: );

Line 18: batch_ref pay_batch_headers.batch_reference%TYPE,

14: g_max_tc_allowed PLS_INTEGER := fnd_profile.VALUE ('HXT_BATCH_SIZE');
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:

Line 153: p_batch_reference IN pay_batch_headers.batch_reference%TYPE

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:
157: FUNCTION create_holiday_hours (

Line 155: RETURN pay_batch_headers.batch_id%TYPE;

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:
157: FUNCTION create_holiday_hours (
158: i_person_id IN NUMBER,
159: i_hcl_id IN NUMBER,

Line 3294: l_batch_id pay_batch_headers.batch_id%TYPE DEFAULT NULL;

3290: l_retcode NUMBER DEFAULT 0;
3291: l_batch_creation_error EXCEPTION;
3292: l_batch_location_error EXCEPTION;
3293: l_tim_id_creation_error EXCEPTION;
3294: l_batch_id pay_batch_headers.batch_id%TYPE DEFAULT NULL;
3295: l_timecard_id hxt_timecards.ID%TYPE DEFAULT NULL;
3296: l_object_version_number NUMBER DEFAULT NULL;
3297: l_rowid ROWID;
3298: BEGIN

Line 3471: l_batch_id pay_batch_headers.batch_id%TYPE DEFAULT NULL;

3467: o_batch_id OUT NOCOPY NUMBER
3468: )
3469: RETURN NUMBER
3470: IS
3471: l_batch_id pay_batch_headers.batch_id%TYPE DEFAULT NULL;
3472: l_batch_name pay_batch_headers.batch_name%TYPE
3473: DEFAULT NULL;
3474: l_reference_num pay_batch_headers.batch_reference%TYPE
3475: DEFAULT NULL;

Line 3472: l_batch_name pay_batch_headers.batch_name%TYPE

3468: )
3469: RETURN NUMBER
3470: IS
3471: l_batch_id pay_batch_headers.batch_id%TYPE DEFAULT NULL;
3472: l_batch_name pay_batch_headers.batch_name%TYPE
3473: DEFAULT NULL;
3474: l_reference_num pay_batch_headers.batch_reference%TYPE
3475: DEFAULT NULL;
3476: l_error_text VARCHAR2 (128) DEFAULT NULL;

Line 3474: l_reference_num pay_batch_headers.batch_reference%TYPE

3470: IS
3471: l_batch_id pay_batch_headers.batch_id%TYPE DEFAULT NULL;
3472: l_batch_name pay_batch_headers.batch_name%TYPE
3473: DEFAULT NULL;
3474: l_reference_num pay_batch_headers.batch_reference%TYPE
3475: DEFAULT NULL;
3476: l_error_text VARCHAR2 (128) DEFAULT NULL;
3477: l_batch_id_error EXCEPTION;
3478: l_batch_name_error EXCEPTION;

Line 3568: /* INSERT INTO pay_batch_headers

3564: THEN
3565: hr_utility.TRACE ('BEFORE INSERT batch ');
3566: END IF;
3567:
3568: /* INSERT INTO pay_batch_headers
3569: (batch_id, business_group_id, batch_name, batch_status,
3570: action_if_exists, batch_reference, batch_source,
3571: purge_after_transfer, reject_if_future_changes,
3572: last_update_date, last_updated_by, last_update_login,

Line 3653: Examine the pay_batch_headers and the hxt_timeclocks

3649: END create_batch;
3650:
3651: /********************************************************************
3652: find_existing_batch()
3653: Examine the pay_batch_headers and the hxt_timeclocks
3654: tables for existing unprocessed timeclock batches. The
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: ********************************************************************/

Line 3660: p_batch_reference IN pay_batch_headers.batch_reference%TYPE

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
3664: CURSOR csr_timecard_batches (

Line 3662: RETURN pay_batch_headers.batch_id%TYPE

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
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

Line 3666: p_batch_reference pay_batch_headers.batch_reference%TYPE

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
3670: FROM hxt_timecards ht,

Line 3672: pay_batch_headers pbh

3668: IS
3669: SELECT COUNT (ht.ID) num_tcs, MAX (ht.batch_id) batch_id
3670: FROM hxt_timecards ht,
3671: hxt_batch_states hbs,
3672: pay_batch_headers pbh
3673: WHERE ht.time_period_id = p_time_period_id
3674: AND hbs.batch_id = ht.batch_id
3675: AND pbh.batch_id = ht.batch_id
3676: AND hbs.status <> 'VT'

Line 3683: l_batch_id pay_batch_headers.batch_id%TYPE;

3679: GROUP BY ht.batch_id;
3680:
3681: l_proc VARCHAR2 (72);
3682: l_timecard_batches csr_timecard_batches%ROWTYPE;
3683: l_batch_id pay_batch_headers.batch_id%TYPE;
3684: l_batch_tbl_idx PLS_INTEGER := g_batch_info.FIRST;
3685: BEGIN
3686: IF g_debug
3687: THEN