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 20: batch_id pay_batch_headers.batch_id%TYPE,

16: -- Bug 12850901
17: g_intg_error VARCHAR2(4000) := fnd_message.get_string('HXC','HXC_PROJ_PAY_NO_OTLR');
18:
19: TYPE batch_info_rec IS RECORD (
20: batch_id pay_batch_headers.batch_id%TYPE,
21: batch_ref pay_batch_headers.batch_reference%TYPE,
22: period_id per_time_periods.time_period_id%TYPE,
23: num_tcs NUMBER
24: );

Line 21: batch_ref pay_batch_headers.batch_reference%TYPE,

17: g_intg_error VARCHAR2(4000) := fnd_message.get_string('HXC','HXC_PROJ_PAY_NO_OTLR');
18:
19: TYPE batch_info_rec IS RECORD (
20: batch_id pay_batch_headers.batch_id%TYPE,
21: batch_ref pay_batch_headers.batch_reference%TYPE,
22: period_id per_time_periods.time_period_id%TYPE,
23: num_tcs NUMBER
24: );
25:

Line 156: p_batch_reference IN pay_batch_headers.batch_reference%TYPE

152: RETURN NUMBER;
153:
154: FUNCTION find_existing_batch (
155: p_time_period_id IN per_time_periods.time_period_id%TYPE,
156: p_batch_reference IN pay_batch_headers.batch_reference%TYPE
157: )
158: RETURN pay_batch_headers.batch_id%TYPE;
159:
160: FUNCTION create_holiday_hours (

Line 158: RETURN pay_batch_headers.batch_id%TYPE;

154: FUNCTION find_existing_batch (
155: p_time_period_id IN per_time_periods.time_period_id%TYPE,
156: p_batch_reference IN pay_batch_headers.batch_reference%TYPE
157: )
158: RETURN pay_batch_headers.batch_id%TYPE;
159:
160: FUNCTION create_holiday_hours (
161: i_person_id IN NUMBER,
162: i_hcl_id IN NUMBER,

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

3483: l_retcode NUMBER DEFAULT 0;
3484: l_batch_creation_error EXCEPTION;
3485: l_batch_location_error EXCEPTION;
3486: l_tim_id_creation_error EXCEPTION;
3487: l_batch_id pay_batch_headers.batch_id%TYPE DEFAULT NULL;
3488: l_timecard_id hxt_timecards.ID%TYPE DEFAULT NULL;
3489: l_object_version_number NUMBER DEFAULT NULL;
3490: l_rowid ROWID;
3491: BEGIN

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

3661: o_batch_id OUT NOCOPY NUMBER
3662: )
3663: RETURN NUMBER
3664: IS
3665: l_batch_id pay_batch_headers.batch_id%TYPE DEFAULT NULL;
3666: l_batch_name pay_batch_headers.batch_name%TYPE
3667: DEFAULT NULL;
3668: l_reference_num pay_batch_headers.batch_reference%TYPE
3669: DEFAULT NULL;

Line 3666: l_batch_name pay_batch_headers.batch_name%TYPE

3662: )
3663: RETURN NUMBER
3664: IS
3665: l_batch_id pay_batch_headers.batch_id%TYPE DEFAULT NULL;
3666: l_batch_name pay_batch_headers.batch_name%TYPE
3667: DEFAULT NULL;
3668: l_reference_num pay_batch_headers.batch_reference%TYPE
3669: DEFAULT NULL;
3670: l_error_text VARCHAR2 (128) DEFAULT NULL;

Line 3668: l_reference_num pay_batch_headers.batch_reference%TYPE

3664: IS
3665: l_batch_id pay_batch_headers.batch_id%TYPE DEFAULT NULL;
3666: l_batch_name pay_batch_headers.batch_name%TYPE
3667: DEFAULT NULL;
3668: l_reference_num pay_batch_headers.batch_reference%TYPE
3669: DEFAULT NULL;
3670: l_error_text VARCHAR2 (128) DEFAULT NULL;
3671: l_batch_id_error EXCEPTION;
3672: l_batch_name_error EXCEPTION;

Line 3762: /* INSERT INTO pay_batch_headers

3758: THEN
3759: hr_utility.TRACE ('BEFORE INSERT batch ');
3760: END IF;
3761:
3762: /* INSERT INTO pay_batch_headers
3763: (batch_id, business_group_id, batch_name, batch_status,
3764: action_if_exists, batch_reference, batch_source,
3765: purge_after_transfer, reject_if_future_changes,
3766: last_update_date, last_updated_by, last_update_login,

Line 3848: Examine the pay_batch_headers and the hxt_timeclocks

3844: END create_batch;
3845:
3846: /********************************************************************
3847: find_existing_batch()
3848: Examine the pay_batch_headers and the hxt_timeclocks
3849: tables for existing unprocessed timeclock batches. The
3850: batches must be in a hold status (batch_status = 'H')
3851: and have less than the max amount of timecards allowed per batch.
3852: ********************************************************************/

Line 3855: p_batch_reference IN pay_batch_headers.batch_reference%TYPE

3851: and have less than the max amount of timecards allowed per batch.
3852: ********************************************************************/
3853: FUNCTION find_existing_batch (
3854: p_time_period_id IN per_time_periods.time_period_id%TYPE,
3855: p_batch_reference IN pay_batch_headers.batch_reference%TYPE
3856: )
3857: RETURN pay_batch_headers.batch_id%TYPE
3858: IS
3859: CURSOR csr_timecard_batches (

Line 3857: RETURN pay_batch_headers.batch_id%TYPE

3853: FUNCTION find_existing_batch (
3854: p_time_period_id IN per_time_periods.time_period_id%TYPE,
3855: p_batch_reference IN pay_batch_headers.batch_reference%TYPE
3856: )
3857: RETURN pay_batch_headers.batch_id%TYPE
3858: IS
3859: CURSOR csr_timecard_batches (
3860: p_time_period_id per_time_periods.time_period_id%TYPE,
3861: p_batch_reference pay_batch_headers.batch_reference%TYPE

Line 3861: p_batch_reference pay_batch_headers.batch_reference%TYPE

3857: RETURN pay_batch_headers.batch_id%TYPE
3858: IS
3859: CURSOR csr_timecard_batches (
3860: p_time_period_id per_time_periods.time_period_id%TYPE,
3861: p_batch_reference pay_batch_headers.batch_reference%TYPE
3862: )
3863: IS
3864: SELECT COUNT (ht.ID) num_tcs, MAX (ht.batch_id) batch_id
3865: FROM hxt_timecards ht,

Line 3867: pay_batch_headers pbh

3863: IS
3864: SELECT COUNT (ht.ID) num_tcs, MAX (ht.batch_id) batch_id
3865: FROM hxt_timecards ht,
3866: hxt_batch_states hbs,
3867: pay_batch_headers pbh
3868: WHERE ht.time_period_id = p_time_period_id
3869: AND hbs.batch_id = ht.batch_id
3870: AND pbh.batch_id = ht.batch_id
3871: AND hbs.status <> 'VT'

Line 3878: l_batch_id pay_batch_headers.batch_id%TYPE;

3874: GROUP BY ht.batch_id;
3875:
3876: l_proc VARCHAR2 (72);
3877: l_timecard_batches csr_timecard_batches%ROWTYPE;
3878: l_batch_id pay_batch_headers.batch_id%TYPE;
3879: l_batch_tbl_idx PLS_INTEGER := g_batch_info.FIRST;
3880: BEGIN
3881: IF g_debug
3882: THEN