APPS.HXT_TIME_GEN dependencies on PAY_BATCH_HEADERS

Line 163: l_reference_number pay_batch_headers.batch_reference%TYPE

159: l_retcode NUMBER;
160: l_errors EXCEPTION;
161: v_retcode NUMBER := 0; --SIR60
162: a_person_id NUMBER; --SIR60
163: l_reference_number pay_batch_headers.batch_reference%TYPE
164: := a_reference_number;
165: l_tccount BOOLEAN; -- added 2772781
166: --this flag is used to indicate that at
167: --least one timecard has got autogenerated or

Line 661: l_batch_id pay_batch_headers.batch_id%TYPE;

657: ------------------------------------------------------------------
658: FUNCTION create_batch (a_tim_cntr NUMBER, a_reference_num VARCHAR2)
659: RETURN NUMBER
660: IS
661: l_batch_id pay_batch_headers.batch_id%TYPE;
662: l_batch_name pay_batch_headers.batch_name%TYPE;
663: l_object_version_number pay_batch_headers.object_version_number%TYPE;
664: BEGIN
665: -- Check if batch limit exceeded

Line 662: l_batch_name pay_batch_headers.batch_name%TYPE;

658: FUNCTION create_batch (a_tim_cntr NUMBER, a_reference_num VARCHAR2)
659: RETURN NUMBER
660: IS
661: l_batch_id pay_batch_headers.batch_id%TYPE;
662: l_batch_name pay_batch_headers.batch_name%TYPE;
663: l_object_version_number pay_batch_headers.object_version_number%TYPE;
664: BEGIN
665: -- Check if batch limit exceeded
666: IF a_tim_cntr >= g_batch_size

Line 663: l_object_version_number pay_batch_headers.object_version_number%TYPE;

659: RETURN NUMBER
660: IS
661: l_batch_id pay_batch_headers.batch_id%TYPE;
662: l_batch_name pay_batch_headers.batch_name%TYPE;
663: l_object_version_number pay_batch_headers.object_version_number%TYPE;
664: BEGIN
665: -- Check if batch limit exceeded
666: IF a_tim_cntr >= g_batch_size
667: THEN

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

689: l_batch_id,
690: l_batch_name,
691: g_autogen_error
692: );
693: g_sub_loc := 'INSERT INTO pay_batch_headers';
694: --update the batch name
695: pay_batch_element_entry_api.update_batch_header (
696: p_session_date=> g_sysdatetime,
697: p_batch_id=> l_batch_id,

Line 708: /* INSERT INTO pay_batch_headers

704: p_purge_after_transfer=> 'N',
705: p_reject_if_future_changes=> 'N'
706: );
707:
708: /* INSERT INTO pay_batch_headers
709: (batch_id, business_group_id, batch_name, batch_status,
710: action_if_exists, batch_reference, batch_source,
711: purge_after_transfer, reject_if_future_changes,
712: created_by, creation_date, last_updated_by,

Line 741: From pay_batch_headers

737:
738:
739: CURSOR c_ovn is
740: Select object_version_number
741: From pay_batch_headers
742:
743: Where batch_id = l_batch_id;
744:
745: l_object_version_number pay_batch_headers.object_version_number%TYPE;

Line 745: l_object_version_number pay_batch_headers.object_version_number%TYPE;

741: From pay_batch_headers
742:
743: Where batch_id = l_batch_id;
744:
745: l_object_version_number pay_batch_headers.object_version_number%TYPE;
746:
747: BEGIN
748:
749:

Line 1121: SELECT pay_batch_headers_s.NEXTVAL

1117: BEGIN
1118: -- Get next value
1119: g_sub_loc := 'OPEN cur_id';
1120:
1121: SELECT pay_batch_headers_s.NEXTVAL
1122: INTO l_nextval
1123: FROM DUAL; --SPR C166 BY BC
1124:
1125: RETURN (l_nextval);