APPS.HXT_TIME_GEN dependencies on PAY_BATCH_HEADERS

Line 260: l_reference_number pay_batch_headers.batch_reference%TYPE

256: l_retcode NUMBER;
257: l_errors EXCEPTION;
258: v_retcode NUMBER := 0; --SIR60
259: a_person_id NUMBER; --SIR60
260: l_reference_number pay_batch_headers.batch_reference%TYPE
261: := a_reference_number;
262: l_tccount BOOLEAN; -- added 2772781
263: --this flag is used to indicate that at
264: --least one timecard has got autogenerated or

Line 794: l_batch_id pay_batch_headers.batch_id%TYPE;

790: ------------------------------------------------------------------
791: FUNCTION create_batch (a_tim_cntr NUMBER, a_reference_num VARCHAR2)
792: RETURN NUMBER
793: IS
794: l_batch_id pay_batch_headers.batch_id%TYPE;
795: l_batch_name pay_batch_headers.batch_name%TYPE;
796: l_object_version_number pay_batch_headers.object_version_number%TYPE;
797: BEGIN
798: -- Check if batch limit exceeded

Line 795: l_batch_name pay_batch_headers.batch_name%TYPE;

791: FUNCTION create_batch (a_tim_cntr NUMBER, a_reference_num VARCHAR2)
792: RETURN NUMBER
793: IS
794: l_batch_id pay_batch_headers.batch_id%TYPE;
795: l_batch_name pay_batch_headers.batch_name%TYPE;
796: l_object_version_number pay_batch_headers.object_version_number%TYPE;
797: BEGIN
798: -- Check if batch limit exceeded
799: IF a_tim_cntr >= g_batch_size

Line 796: l_object_version_number pay_batch_headers.object_version_number%TYPE;

792: RETURN NUMBER
793: IS
794: l_batch_id pay_batch_headers.batch_id%TYPE;
795: l_batch_name pay_batch_headers.batch_name%TYPE;
796: l_object_version_number pay_batch_headers.object_version_number%TYPE;
797: BEGIN
798: -- Check if batch limit exceeded
799: IF a_tim_cntr >= g_batch_size
800: THEN

Line 826: g_sub_loc := 'INSERT INTO pay_batch_headers';

822: l_batch_id,
823: l_batch_name,
824: g_autogen_error
825: );
826: g_sub_loc := 'INSERT INTO pay_batch_headers';
827: --update the batch name
828: pay_batch_element_entry_api.update_batch_header (
829: p_session_date=> g_sysdatetime,
830: p_batch_id=> l_batch_id,

Line 841: /* INSERT INTO pay_batch_headers

837: p_purge_after_transfer=> 'N',
838: p_reject_if_future_changes=> 'N'
839: );
840:
841: /* INSERT INTO pay_batch_headers
842: (batch_id, business_group_id, batch_name, batch_status,
843: action_if_exists, batch_reference, batch_source,
844: purge_after_transfer, reject_if_future_changes,
845: created_by, creation_date, last_updated_by,

Line 874: From pay_batch_headers

870:
871:
872: CURSOR c_ovn is
873: Select object_version_number
874: From pay_batch_headers
875:
876: Where batch_id = l_batch_id;
877:
878: l_object_version_number pay_batch_headers.object_version_number%TYPE;

Line 878: l_object_version_number pay_batch_headers.object_version_number%TYPE;

874: From pay_batch_headers
875:
876: Where batch_id = l_batch_id;
877:
878: l_object_version_number pay_batch_headers.object_version_number%TYPE;
879:
880: BEGIN
881:
882:

Line 1254: SELECT pay_batch_headers_s.NEXTVAL

1250: BEGIN
1251: -- Get next value
1252: g_sub_loc := 'OPEN cur_id';
1253:
1254: SELECT pay_batch_headers_s.NEXTVAL
1255: INTO l_nextval
1256: FROM DUAL; --SPR C166 BY BC
1257:
1258: RETURN (l_nextval);