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.PAY_HR_OTC_RETRIEVAL_INTERFACE dependencies on PAY_BATCH_LINES

Line 11: g_assignment_id pay_batch_lines.assignment_id%TYPE;

7: g_batches_created batches_type_table;
8: -- Global Exceptions
9: e_continue EXCEPTION;
10: e_halt EXCEPTION;
11: g_assignment_id pay_batch_lines.assignment_id%TYPE;
12: l_since_date VARCHAR2 (20);
13:
14: /*
15: || Function that can be used to convert "internal" values (LOV Codes etc.) to

Line 19: p_element_type_id IN pay_batch_lines.element_type_id%TYPE,

15: || Function that can be used to convert "internal" values (LOV Codes etc.) to
16: || their respective "display" values (LOV Meaning etc.).
17: */
18: FUNCTION display_value (
19: p_element_type_id IN pay_batch_lines.element_type_id%TYPE,
20: p_internal_input_value IN pay_batch_lines.value_1%TYPE,
21: p_iv_number IN PLS_INTEGER,
22: p_session_date IN DATE,
23: p_bg_id IN hr_all_organization_units.business_group_id%TYPE

Line 20: p_internal_input_value IN pay_batch_lines.value_1%TYPE,

16: || their respective "display" values (LOV Meaning etc.).
17: */
18: FUNCTION display_value (
19: p_element_type_id IN pay_batch_lines.element_type_id%TYPE,
20: p_internal_input_value IN pay_batch_lines.value_1%TYPE,
21: p_iv_number IN PLS_INTEGER,
22: p_session_date IN DATE,
23: p_bg_id IN hr_all_organization_units.business_group_id%TYPE
24: )

Line 912: p_batch_sequence IN pay_batch_lines.batch_sequence%TYPE,

908: p_batch_id IN pay_batch_headers.batch_id%TYPE,
909: p_det_tbb_idx IN PLS_INTEGER,
910: p_session_date IN DATE,
911: p_effective_date IN DATE,
912: p_batch_sequence IN pay_batch_lines.batch_sequence%TYPE,
913: p_bee_rec IN hxt_interface_utilities.bee_rec,
914: p_bg_id IN pay_batch_headers.business_group_id%TYPE
915: )
916: AS

Line 919: l_batch_line_id pay_batch_lines.batch_line_id%TYPE;

915: )
916: AS
917: l_proc CONSTANT proc_name := g_package || 'create_batch_line';
918: l_total_lines NUMBER;
919: l_batch_line_id pay_batch_lines.batch_line_id%TYPE;
920: l_object_version_number pay_batch_lines.object_version_number%TYPE;
921: BEGIN
922: hr_utility.set_location ('Entering:' || l_proc, 10);
923: pay_batch_element_entry_api.create_batch_line

Line 920: l_object_version_number pay_batch_lines.object_version_number%TYPE;

916: AS
917: l_proc CONSTANT proc_name := g_package || 'create_batch_line';
918: l_total_lines NUMBER;
919: l_batch_line_id pay_batch_lines.batch_line_id%TYPE;
920: l_object_version_number pay_batch_lines.object_version_number%TYPE;
921: BEGIN
922: hr_utility.set_location ('Entering:' || l_proc, 10);
923: pay_batch_element_entry_api.create_batch_line
924: (p_session_date => p_session_date,

Line 1093: p_batch_sequence IN OUT NOCOPY pay_batch_lines.batch_sequence%TYPE,

1089: PROCEDURE add_to_batch (
1090: p_batch_reference IN pay_batch_headers.batch_reference%TYPE,
1091: p_batch_id IN OUT NOCOPY pay_batch_headers.batch_id%TYPE,
1092: p_det_tbb_idx IN PLS_INTEGER,
1093: p_batch_sequence IN OUT NOCOPY pay_batch_lines.batch_sequence%TYPE,
1094: p_batch_lines IN OUT NOCOPY PLS_INTEGER,
1095: p_bg_id IN pay_batch_headers.business_group_id%TYPE,
1096: p_session_date IN DATE,
1097: p_effective_date IN DATE,

Line 1186: l_batch_sequence pay_batch_lines.batch_sequence%TYPE;

1182: l_empty_bee_rec hxt_interface_utilities.bee_rec;
1183: l_cost_flex_id per_business_groups_perf.cost_allocation_structure%TYPE
1184: := hxt_interface_utilities.cost_flex_structure_id (p_bg_id);
1185: l_batch_id pay_batch_headers.batch_reference%TYPE;
1186: l_batch_sequence pay_batch_lines.batch_sequence%TYPE;
1187: l_retro_batch_id pay_batch_headers.batch_reference%TYPE;
1188: l_retro_batch_sequence pay_batch_lines.batch_sequence%TYPE;
1189: l_batch_lines PLS_INTEGER;
1190: l_retro_batch_lines PLS_INTEGER;

Line 1188: l_retro_batch_sequence pay_batch_lines.batch_sequence%TYPE;

1184: := hxt_interface_utilities.cost_flex_structure_id (p_bg_id);
1185: l_batch_id pay_batch_headers.batch_reference%TYPE;
1186: l_batch_sequence pay_batch_lines.batch_sequence%TYPE;
1187: l_retro_batch_id pay_batch_headers.batch_reference%TYPE;
1188: l_retro_batch_sequence pay_batch_lines.batch_sequence%TYPE;
1189: l_batch_lines PLS_INTEGER;
1190: l_retro_batch_lines PLS_INTEGER;
1191: BEGIN
1192: hr_utility.set_location ('Entering ' || l_proc, 10);

Line 2120: -- and pay batch lines, so what you get from there would be the transferred values.

2116: -- Create a batch header, and then create the batch lines taking values from
2117: -- HXT_BATCH_VALUES_V. There could have been a timecard edit in HXT, and the changed
2118: -- hours could have gone to BEE. The reversal batch lines has to reverse these, rather
2119: -- than the hours you pulled out from HXC. HXT_BATCH_VALUES_V is a view on hxt detail hours
2120: -- and pay batch lines, so what you get from there would be the transferred values.
2121: -- So after you pull out the batch records, turn around the hours with a negative sign
2122: -- and create the lines.
2123: delete_non_transferred_hours;
2124: