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

Line 52: l_valid_batch_id PAY_BATCH_HEADERS.BATCH_ID%TYPE;

48: p_bus_group_id NUMBER,
49: p_mode VARCHAR2
50: )
51: IS
52: l_valid_batch_id PAY_BATCH_HEADERS.BATCH_ID%TYPE;
53: l_error_batch_id PAY_BATCH_HEADERS.BATCH_ID%TYPE;
54: l_warning_batch_id PAY_BATCH_HEADERS.BATCH_ID%TYPE;
55: l_temp_batch_upd_id PAY_BATCH_HEADERS.BATCH_ID%TYPE;
56: l_batch_name PAY_BATCH_HEADERS.BATCH_NAME%TYPE;

Line 53: l_error_batch_id PAY_BATCH_HEADERS.BATCH_ID%TYPE;

49: p_mode VARCHAR2
50: )
51: IS
52: l_valid_batch_id PAY_BATCH_HEADERS.BATCH_ID%TYPE;
53: l_error_batch_id PAY_BATCH_HEADERS.BATCH_ID%TYPE;
54: l_warning_batch_id PAY_BATCH_HEADERS.BATCH_ID%TYPE;
55: l_temp_batch_upd_id PAY_BATCH_HEADERS.BATCH_ID%TYPE;
56: l_batch_name PAY_BATCH_HEADERS.BATCH_NAME%TYPE;
57: l_valid_batch_name PAY_BATCH_HEADERS.BATCH_NAME%TYPE;

Line 54: l_warning_batch_id PAY_BATCH_HEADERS.BATCH_ID%TYPE;

50: )
51: IS
52: l_valid_batch_id PAY_BATCH_HEADERS.BATCH_ID%TYPE;
53: l_error_batch_id PAY_BATCH_HEADERS.BATCH_ID%TYPE;
54: l_warning_batch_id PAY_BATCH_HEADERS.BATCH_ID%TYPE;
55: l_temp_batch_upd_id PAY_BATCH_HEADERS.BATCH_ID%TYPE;
56: l_batch_name PAY_BATCH_HEADERS.BATCH_NAME%TYPE;
57: l_valid_batch_name PAY_BATCH_HEADERS.BATCH_NAME%TYPE;
58: l_error_batch_name PAY_BATCH_HEADERS.BATCH_NAME%TYPE;

Line 55: l_temp_batch_upd_id PAY_BATCH_HEADERS.BATCH_ID%TYPE;

51: IS
52: l_valid_batch_id PAY_BATCH_HEADERS.BATCH_ID%TYPE;
53: l_error_batch_id PAY_BATCH_HEADERS.BATCH_ID%TYPE;
54: l_warning_batch_id PAY_BATCH_HEADERS.BATCH_ID%TYPE;
55: l_temp_batch_upd_id PAY_BATCH_HEADERS.BATCH_ID%TYPE;
56: l_batch_name PAY_BATCH_HEADERS.BATCH_NAME%TYPE;
57: l_valid_batch_name PAY_BATCH_HEADERS.BATCH_NAME%TYPE;
58: l_error_batch_name PAY_BATCH_HEADERS.BATCH_NAME%TYPE;
59: l_warning_batch_name PAY_BATCH_HEADERS.BATCH_NAME%TYPE;

Line 56: l_batch_name PAY_BATCH_HEADERS.BATCH_NAME%TYPE;

52: l_valid_batch_id PAY_BATCH_HEADERS.BATCH_ID%TYPE;
53: l_error_batch_id PAY_BATCH_HEADERS.BATCH_ID%TYPE;
54: l_warning_batch_id PAY_BATCH_HEADERS.BATCH_ID%TYPE;
55: l_temp_batch_upd_id PAY_BATCH_HEADERS.BATCH_ID%TYPE;
56: l_batch_name PAY_BATCH_HEADERS.BATCH_NAME%TYPE;
57: l_valid_batch_name PAY_BATCH_HEADERS.BATCH_NAME%TYPE;
58: l_error_batch_name PAY_BATCH_HEADERS.BATCH_NAME%TYPE;
59: l_warning_batch_name PAY_BATCH_HEADERS.BATCH_NAME%TYPE;
60: l_object_version_number PAY_BATCH_HEADERS.OBJECT_VERSION_NUMBER%TYPE;

Line 57: l_valid_batch_name PAY_BATCH_HEADERS.BATCH_NAME%TYPE;

53: l_error_batch_id PAY_BATCH_HEADERS.BATCH_ID%TYPE;
54: l_warning_batch_id PAY_BATCH_HEADERS.BATCH_ID%TYPE;
55: l_temp_batch_upd_id PAY_BATCH_HEADERS.BATCH_ID%TYPE;
56: l_batch_name PAY_BATCH_HEADERS.BATCH_NAME%TYPE;
57: l_valid_batch_name PAY_BATCH_HEADERS.BATCH_NAME%TYPE;
58: l_error_batch_name PAY_BATCH_HEADERS.BATCH_NAME%TYPE;
59: l_warning_batch_name PAY_BATCH_HEADERS.BATCH_NAME%TYPE;
60: l_object_version_number PAY_BATCH_HEADERS.OBJECT_VERSION_NUMBER%TYPE;
61: l_ovn HXT_TIMECARDS_F.OBJECT_VERSION_NUMBER%TYPE;

Line 58: l_error_batch_name PAY_BATCH_HEADERS.BATCH_NAME%TYPE;

54: l_warning_batch_id PAY_BATCH_HEADERS.BATCH_ID%TYPE;
55: l_temp_batch_upd_id PAY_BATCH_HEADERS.BATCH_ID%TYPE;
56: l_batch_name PAY_BATCH_HEADERS.BATCH_NAME%TYPE;
57: l_valid_batch_name PAY_BATCH_HEADERS.BATCH_NAME%TYPE;
58: l_error_batch_name PAY_BATCH_HEADERS.BATCH_NAME%TYPE;
59: l_warning_batch_name PAY_BATCH_HEADERS.BATCH_NAME%TYPE;
60: l_object_version_number PAY_BATCH_HEADERS.OBJECT_VERSION_NUMBER%TYPE;
61: l_ovn HXT_TIMECARDS_F.OBJECT_VERSION_NUMBER%TYPE;
62: l_string1 VARCHAR2(5);

Line 59: l_warning_batch_name PAY_BATCH_HEADERS.BATCH_NAME%TYPE;

55: l_temp_batch_upd_id PAY_BATCH_HEADERS.BATCH_ID%TYPE;
56: l_batch_name PAY_BATCH_HEADERS.BATCH_NAME%TYPE;
57: l_valid_batch_name PAY_BATCH_HEADERS.BATCH_NAME%TYPE;
58: l_error_batch_name PAY_BATCH_HEADERS.BATCH_NAME%TYPE;
59: l_warning_batch_name PAY_BATCH_HEADERS.BATCH_NAME%TYPE;
60: l_object_version_number PAY_BATCH_HEADERS.OBJECT_VERSION_NUMBER%TYPE;
61: l_ovn HXT_TIMECARDS_F.OBJECT_VERSION_NUMBER%TYPE;
62: l_string1 VARCHAR2(5);
63: l_string2 VARCHAR2(5);

Line 60: l_object_version_number PAY_BATCH_HEADERS.OBJECT_VERSION_NUMBER%TYPE;

56: l_batch_name PAY_BATCH_HEADERS.BATCH_NAME%TYPE;
57: l_valid_batch_name PAY_BATCH_HEADERS.BATCH_NAME%TYPE;
58: l_error_batch_name PAY_BATCH_HEADERS.BATCH_NAME%TYPE;
59: l_warning_batch_name PAY_BATCH_HEADERS.BATCH_NAME%TYPE;
60: l_object_version_number PAY_BATCH_HEADERS.OBJECT_VERSION_NUMBER%TYPE;
61: l_ovn HXT_TIMECARDS_F.OBJECT_VERSION_NUMBER%TYPE;
62: l_string1 VARCHAR2(5);
63: l_string2 VARCHAR2(5);
64: l_loop_index1 BINARY_INTEGER;

Line 68: l_parent_batch_name PAY_BATCH_HEADERS.BATCH_NAME%TYPE;

64: l_loop_index1 BINARY_INTEGER;
65: l_loop_index2 BINARY_INTEGER;
66: l_proc VARCHAR2(72);
67: l_assignment_no PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_NUMBER%TYPE;
68: l_parent_batch_name PAY_BATCH_HEADERS.BATCH_NAME%TYPE;
69: l_batch_type VARCHAR2(10);
70:
71: BEGIN
72: g_debug := hr_utility.debug_enabled;

Line 288: FROM pay_batch_headers pbh

284: AND sysdate between effective_start_date and effective_end_date;
285:
286: SELECT pbh.batch_name
287: INTO l_parent_batch_name
288: FROM pay_batch_headers pbh
289: WHERE pbh.batch_id = (SELECT tc.batch_id
290: FROM hxt_timecards_x tc
291: WHERE tc.id = p_merge_batches(l_loop_index1).tc_id
292: );

Line 377: FROM pay_batch_headers pbh, --GLOBAL

373: SELECT pbh.batch_id,
374: hbs.status batch_status, --SIR020
375: pbh.batch_reference ,
376: pbh.object_version_number
377: FROM pay_batch_headers pbh, --GLOBAL
378: hxt_batch_states hbs --SIR020
379: WHERE pbh.business_group_id = p_bus_group_id --GLOBAL
380: AND hbs.batch_id = pbh.batch_id --SIR020
381: AND pbh.batch_id BETWEEN nvl(c_batch_num,0)

Line 1662: pay_batch_headers pbh

1658: cursor c_get_retro_batch_ids(p_batch_id number) is
1659: SELECT distinct(hrw.retro_batch_id) retro_batch_id,pbh.object_version_number
1660: FROM hxt_det_hours_worked_f hrw,
1661: hxt_timecards_f tim,
1662: pay_batch_headers pbh
1663: WHERE hrw.tim_id = tim.id
1664: AND tim.batch_id = pbh.batch_id
1665: AND tim.batch_id = p_batch_id
1666: AND hrw.retro_batch_id IS NOT NULL;

Line 1669: from pay_batch_headers

1665: AND tim.batch_id = p_batch_id
1666: AND hrw.retro_batch_id IS NOT NULL;
1667: CURSOR c_get_batch_ovn(p_batch_id number) is
1668: select object_version_number
1669: from pay_batch_headers
1670: where batch_id = p_batch_id;
1671: l_batch_ovn pay_batch_headers.object_version_number%type;
1672: l_batch_line_id pay_batch_lines.batch_line_id%type;
1673: l_line_ovn pay_batch_headers.object_version_number%type;

Line 1671: l_batch_ovn pay_batch_headers.object_version_number%type;

1667: CURSOR c_get_batch_ovn(p_batch_id number) is
1668: select object_version_number
1669: from pay_batch_headers
1670: where batch_id = p_batch_id;
1671: l_batch_ovn pay_batch_headers.object_version_number%type;
1672: l_batch_line_id pay_batch_lines.batch_line_id%type;
1673: l_line_ovn pay_batch_headers.object_version_number%type;
1674: BEGIN
1675: -- if no time period is specified, delete all PayMIX entries

Line 1673: l_line_ovn pay_batch_headers.object_version_number%type;

1669: from pay_batch_headers
1670: where batch_id = p_batch_id;
1671: l_batch_ovn pay_batch_headers.object_version_number%type;
1672: l_batch_line_id pay_batch_lines.batch_line_id%type;
1673: l_line_ovn pay_batch_headers.object_version_number%type;
1674: BEGIN
1675: -- if no time period is specified, delete all PayMIX entries
1676: IF p_time_period_id IS NULL THEN
1677: -- Delete PayMIX

Line 1756: FROM pay_batch_headers

1752: -- we will create a new batch, the first time we enter this loop
1753: if not l_batch_created then
1754: SELECT business_group_id, batch_name, batch_reference
1755: INTO l_business_group_id, l_batch_name, l_batch_reference
1756: FROM pay_batch_headers
1757: WHERE batch_id = p_batch_id;
1758: PAY_BATCH_ELEMENT_ENTRY_API.create_batch_header
1759: (p_session_date => sysdate
1760: ,p_batch_name => l_batch_name