APPS.HXT_UTIL dependencies on PAY_BATCH_HEADERS

Line 937: pay_batch_headers pbh

933: cursor existing_batch is
934: select retro_batch_id, assignment_id, pbh.batch_reference
935: from hxt_det_hours_worked det,
936: hxt_batch_states tbs,
937: pay_batch_headers pbh
938: where det.tim_id = p_tim_id
939: and tbs.batch_id = det.retro_batch_id
940: and tbs.status in ('H','VE')
941: and pay_status = 'R'

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

1002: i_assignment_id IN NUMBER,
1003: i_person_id IN NUMBER,
1004: o_batch_id OUT NOCOPY NUMBER) RETURN NUMBER IS
1005:
1006: l_batch_id pay_batch_headers.batch_id%TYPE DEFAULT NULL;
1007: l_reference_num pay_batch_headers.batch_reference%TYPE DEFAULT NULL;
1008: l_batch_name pay_batch_headers.batch_name%TYPE DEFAULT NULL;
1009: l_error_text VARCHAR2(128) DEFAULT NULL;
1010: l_batch_id_error EXCEPTION;

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

1003: i_person_id IN NUMBER,
1004: o_batch_id OUT NOCOPY NUMBER) RETURN NUMBER IS
1005:
1006: l_batch_id pay_batch_headers.batch_id%TYPE DEFAULT NULL;
1007: l_reference_num pay_batch_headers.batch_reference%TYPE DEFAULT NULL;
1008: l_batch_name pay_batch_headers.batch_name%TYPE DEFAULT NULL;
1009: l_error_text VARCHAR2(128) DEFAULT NULL;
1010: l_batch_id_error EXCEPTION;
1011: l_reference_num_error EXCEPTION;

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

1004: o_batch_id OUT NOCOPY NUMBER) RETURN NUMBER IS
1005:
1006: l_batch_id pay_batch_headers.batch_id%TYPE DEFAULT NULL;
1007: l_reference_num pay_batch_headers.batch_reference%TYPE DEFAULT NULL;
1008: l_batch_name pay_batch_headers.batch_name%TYPE DEFAULT NULL;
1009: l_error_text VARCHAR2(128) DEFAULT NULL;
1010: l_batch_id_error EXCEPTION;
1011: l_reference_num_error EXCEPTION;
1012: l_retcode NUMBER DEFAULT 0;

Line 1019: l_object_version_number pay_batch_headers.object_version_number%TYPE;

1015: l_sysdate DATE := trunc(SYSDATE);
1016: l_bus_group_id hr_organization_units.business_group_id%TYPE :=
1017: FND_PROFILE.Value( 'PER_BUSINESS_GROUP_ID' );
1018:
1019: l_object_version_number pay_batch_headers.object_version_number%TYPE;
1020: cursor assign_param(c_person_id NUMBER) IS
1021: select asm.business_group_id
1022: from per_assignment_status_types ast,
1023: per_assignments_f asm

Line 1095: /* INSERT INTO pay_batch_headers

1091: IF l_error_text <> NULL THEN
1092: RETURN 1;
1093: END IF;
1094:
1095: /* INSERT INTO pay_batch_headers
1096: (batch_id,
1097: business_group_id,
1098: batch_name,
1099: batch_status,

Line 1777: select max(batch_id) from pay_batch_headers pbh

1773: AND ncr.accrual_plan_id = p_accrual_plan_id ;
1774:
1775:
1776: cursor get_max_retro_batch is
1777: select max(batch_id) from pay_batch_headers pbh
1778: where pbh.batch_status='T'
1779: and pbh.batch_id in (select distinct retro_batch_id from hxt_det_hours_worked_f
1780: where tim_id=p_tim_id);
1781:

Line 1784: select batch_id from pay_batch_headers pbh

1780: where tim_id=p_tim_id);
1781:
1782:
1783: cursor chk_retro_batch_status is
1784: select batch_id from pay_batch_headers pbh
1785: where pbh.batch_status='T'
1786: and pbh.batch_id in (select distinct retro_batch_id from hxt_det_hours_worked_f
1787: where tim_id=p_tim_id);
1788:

Line 1791: select null from pay_batch_headers pbh

1787: where tim_id=p_tim_id);
1788:
1789:
1790: cursor chk_original_batch_status is
1791: select null from pay_batch_headers pbh
1792: where pbh.batch_status='T'
1793: and pbh.batch_id in (select distinct batch_id from hxt_timecards_f
1794: where id=p_tim_id);
1795:

Line 2254: FROM pay_batch_headers pbh

2250: IS
2251: CURSOR c_chk_tc_exists
2252: IS
2253: SELECT 'Y'
2254: FROM pay_batch_headers pbh
2255: WHERE pbh.batch_status <> 'T'
2256: AND pbh.batch_id = p_batch_id
2257: AND EXISTS ((SELECT HTF.batch_id
2258: FROM hxt_timecards_f HTF