APPS.HXT_UTIL dependencies on PAY_BATCH_HEADERS

Line 941: pay_batch_headers pbh

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

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

1021: i_assignment_id IN NUMBER,
1022: i_person_id IN NUMBER,
1023: o_batch_id OUT NOCOPY NUMBER) RETURN NUMBER IS
1024:
1025: l_batch_id pay_batch_headers.batch_id%TYPE DEFAULT NULL;
1026: l_reference_num pay_batch_headers.batch_reference%TYPE DEFAULT NULL;
1027: l_batch_name pay_batch_headers.batch_name%TYPE DEFAULT NULL;
1028: l_error_text VARCHAR2(128) DEFAULT NULL;
1029: l_batch_id_error EXCEPTION;

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

1022: i_person_id IN NUMBER,
1023: o_batch_id OUT NOCOPY NUMBER) RETURN NUMBER IS
1024:
1025: l_batch_id pay_batch_headers.batch_id%TYPE DEFAULT NULL;
1026: l_reference_num pay_batch_headers.batch_reference%TYPE DEFAULT NULL;
1027: l_batch_name pay_batch_headers.batch_name%TYPE DEFAULT NULL;
1028: l_error_text VARCHAR2(128) DEFAULT NULL;
1029: l_batch_id_error EXCEPTION;
1030: l_reference_num_error EXCEPTION;

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

1023: o_batch_id OUT NOCOPY NUMBER) RETURN NUMBER IS
1024:
1025: l_batch_id pay_batch_headers.batch_id%TYPE DEFAULT NULL;
1026: l_reference_num pay_batch_headers.batch_reference%TYPE DEFAULT NULL;
1027: l_batch_name pay_batch_headers.batch_name%TYPE DEFAULT NULL;
1028: l_error_text VARCHAR2(128) DEFAULT NULL;
1029: l_batch_id_error EXCEPTION;
1030: l_reference_num_error EXCEPTION;
1031: l_retcode NUMBER DEFAULT 0;

Line 1038: l_object_version_number pay_batch_headers.object_version_number%TYPE;

1034: l_sysdate DATE := trunc(SYSDATE);
1035: l_bus_group_id hr_organization_units.business_group_id%TYPE :=
1036: FND_PROFILE.Value( 'PER_BUSINESS_GROUP_ID' );
1037:
1038: l_object_version_number pay_batch_headers.object_version_number%TYPE;
1039: cursor assign_param(c_person_id NUMBER) IS
1040: select asm.business_group_id
1041: from per_assignment_status_types ast,
1042: per_assignments_f asm

Line 1114: /* INSERT INTO pay_batch_headers

1110: IF l_error_text <> NULL THEN
1111: RETURN 1;
1112: END IF;
1113:
1114: /* INSERT INTO pay_batch_headers
1115: (batch_id,
1116: business_group_id,
1117: batch_name,
1118: batch_status,

Line 1847: select max(batch_id) from pay_batch_headers pbh

1843: AND ncr.accrual_plan_id = p_accrual_plan_id ;
1844:
1845:
1846: cursor get_max_retro_batch is
1847: select max(batch_id) from pay_batch_headers pbh
1848: where pbh.batch_status='T'
1849: and pbh.batch_id in (select distinct retro_batch_id from hxt_det_hours_worked_f
1850: where tim_id=p_tim_id);
1851:

Line 1854: select batch_id from pay_batch_headers pbh

1850: where tim_id=p_tim_id);
1851:
1852:
1853: cursor chk_retro_batch_status is
1854: select batch_id from pay_batch_headers pbh
1855: where pbh.batch_status='T'
1856: and pbh.batch_id in (select distinct retro_batch_id from hxt_det_hours_worked_f
1857: where tim_id=p_tim_id);
1858:

Line 1861: select null from pay_batch_headers pbh

1857: where tim_id=p_tim_id);
1858:
1859:
1860: cursor chk_original_batch_status is
1861: select null from pay_batch_headers pbh
1862: where pbh.batch_status='T'
1863: and pbh.batch_id in (select distinct batch_id from hxt_timecards_f
1864: where id=p_tim_id);
1865:

Line 2336: FROM pay_batch_headers pbh

2332: IS
2333: CURSOR c_chk_tc_exists
2334: IS
2335: SELECT 'Y'
2336: FROM pay_batch_headers pbh
2337: WHERE pbh.batch_status <> 'T'
2338: AND pbh.batch_id = p_batch_id
2339: AND EXISTS ((SELECT HTF.batch_id
2340: FROM hxt_timecards_f HTF