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_CLOCK dependencies on PAY_BATCH_HEADERS

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

624: l_batch_location_error EXCEPTION;
625: l_tim_id_creation_error EXCEPTION;
626: --BEGIN GLOBAL
627: -- l_batch_id pay_pdt_batch_headers.batch_id%TYPE DEFAULT NULL;
628: l_batch_id pay_batch_headers.batch_id%TYPE DEFAULT NULL;
629: --END GLOBAL
630: l_timecard_id hxt_timecards.id%TYPE DEFAULT NULL;
631: BEGIN
632: /* Obtain a batch id for the new timecard */

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

717: o_batch_id OUT NOCOPY NUMBER) RETURN NUMBER IS
718: --BEGIN GLOBAL
719: -- l_batch_id pay_pdt_batch_headers.batch_id%TYPE DEFAULT NULL;
720: -- l_reference_num pay_pdt_batch_headers.reference_num%TYPE DEFAULT NULL;
721: l_batch_id pay_batch_headers.batch_id%TYPE DEFAULT NULL;
722: l_reference_num pay_batch_headers.batch_reference%TYPE DEFAULT NULL;
723: l_batch_name pay_batch_headers.batch_name%TYPE DEFAULT NULL;
724: l_batch_name_error EXCEPTION;
725: --END GLOBAL

Line 722: l_reference_num pay_batch_headers.batch_reference%TYPE DEFAULT NULL;

718: --BEGIN GLOBAL
719: -- l_batch_id pay_pdt_batch_headers.batch_id%TYPE DEFAULT NULL;
720: -- l_reference_num pay_pdt_batch_headers.reference_num%TYPE DEFAULT NULL;
721: l_batch_id pay_batch_headers.batch_id%TYPE DEFAULT NULL;
722: l_reference_num pay_batch_headers.batch_reference%TYPE DEFAULT NULL;
723: l_batch_name pay_batch_headers.batch_name%TYPE DEFAULT NULL;
724: l_batch_name_error EXCEPTION;
725: --END GLOBAL
726: l_error_text VARCHAR2(128) DEFAULT NULL;

Line 723: l_batch_name pay_batch_headers.batch_name%TYPE DEFAULT NULL;

719: -- l_batch_id pay_pdt_batch_headers.batch_id%TYPE DEFAULT NULL;
720: -- l_reference_num pay_pdt_batch_headers.reference_num%TYPE DEFAULT NULL;
721: l_batch_id pay_batch_headers.batch_id%TYPE DEFAULT NULL;
722: l_reference_num pay_batch_headers.batch_reference%TYPE DEFAULT NULL;
723: l_batch_name pay_batch_headers.batch_name%TYPE DEFAULT NULL;
724: l_batch_name_error EXCEPTION;
725: --END GLOBAL
726: l_error_text VARCHAR2(128) DEFAULT NULL;
727: l_batch_id_error EXCEPTION;

Line 730: l_object_version_number pay_batch_headers.object_version_number%TYPE;

726: l_error_text VARCHAR2(128) DEFAULT NULL;
727: l_batch_id_error EXCEPTION;
728: l_reference_num_error EXCEPTION;
729: l_retcode NUMBER DEFAULT 0;
730: l_object_version_number pay_batch_headers.object_version_number%TYPE;
731: BEGIN
732: hxt_user_exits.Define_Reference_Number(i_payroll_id,
733: i_time_period_id,
734: i_assignment_id,

Line 839: -- FROM pay_batch_headers bat

835: -- WHERE tim.batch_id = bat.batch_id);
836: --BEGIN SIR343
837: -- SELECT bat.batch_id
838: -- INTO o_batch_id
839: -- FROM pay_batch_headers bat
840: -- WHERE bat.batch_reference like 'C_%'
841: -- AND bat.batch_id = (SELECT MAX(bat2.batch_id)
842: -- FROM pay_batch_headers bat2
843: -- WHERE bat2.batch_status = 'U')

Line 842: -- FROM pay_batch_headers bat2

838: -- INTO o_batch_id
839: -- FROM pay_batch_headers bat
840: -- WHERE bat.batch_reference like 'C_%'
841: -- AND bat.batch_id = (SELECT MAX(bat2.batch_id)
842: -- FROM pay_batch_headers bat2
843: -- WHERE bat2.batch_status = 'U')
844: -- AND l_max_batches > (SELECT COUNT(tim.id)
845: -- FROM hxt_timecards tim
846: -- WHERE tim.batch_id = bat.batch_id);

Line 849: FROM pay_batch_headers bat

845: -- FROM hxt_timecards tim
846: -- WHERE tim.batch_id = bat.batch_id);
847: SELECT MAX(bat.batch_id)
848: INTO o_batch_id
849: FROM pay_batch_headers bat
850: WHERE bat.batch_status = 'U'
851: AND bat.batch_reference like 'C_%'
852: AND not exists (SELECT 'x'
853: FROM hxt_timecards tim