[Home] [Help]
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: g_debug BOOLEAN := hr_utility.debug_enabled;
14:
15: -- Bug 13705204
69: || Function that can be used to convert "internal" values (LOV Codes etc.) to
70: || their respective "display" values (LOV Meaning etc.).
71: */
72: FUNCTION display_value (
73: p_element_type_id IN pay_batch_lines.element_type_id%TYPE,
74: p_internal_input_value IN pay_batch_lines.value_1%TYPE,
75: p_iv_number IN PLS_INTEGER,
76: p_session_date IN DATE,
77: p_bg_id IN hr_all_organization_units.business_group_id%TYPE
70: || their respective "display" values (LOV Meaning etc.).
71: */
72: FUNCTION display_value (
73: p_element_type_id IN pay_batch_lines.element_type_id%TYPE,
74: p_internal_input_value IN pay_batch_lines.value_1%TYPE,
75: p_iv_number IN PLS_INTEGER,
76: p_session_date IN DATE,
77: p_bg_id IN hr_all_organization_units.business_group_id%TYPE
78: )
1242: p_batch_id IN pay_batch_headers.batch_id%TYPE,
1243: p_det_tbb_idx IN PLS_INTEGER,
1244: p_session_date IN DATE,
1245: p_effective_date IN DATE,
1246: p_batch_sequence IN pay_batch_lines.batch_sequence%TYPE,
1247: p_bee_rec IN hxt_interface_utilities.bee_rec,
1248: p_bg_id IN pay_batch_headers.business_group_id%TYPE,
1249: p_is_retro IN BOOLEAN DEFAULT FALSE -- Bug 9494444
1250: )
1250: )
1251: AS
1252: l_proc CONSTANT proc_name := g_package || 'create_batch_line';
1253: l_total_lines NUMBER;
1254: l_batch_line_id pay_batch_lines.batch_line_id%TYPE;
1255: l_object_version_number pay_batch_lines.object_version_number%TYPE;
1256: BEGIN
1257: hr_utility.set_location ('Entering:' || l_proc, 10);
1258:
1251: AS
1252: l_proc CONSTANT proc_name := g_package || 'create_batch_line';
1253: l_total_lines NUMBER;
1254: l_batch_line_id pay_batch_lines.batch_line_id%TYPE;
1255: l_object_version_number pay_batch_lines.object_version_number%TYPE;
1256: BEGIN
1257: hr_utility.set_location ('Entering:' || l_proc, 10);
1258:
1259: -- Bug 13777315
1548: PROCEDURE add_to_batch (
1549: p_batch_reference IN pay_batch_headers.batch_reference%TYPE,
1550: p_batch_id IN OUT NOCOPY pay_batch_headers.batch_id%TYPE,
1551: p_det_tbb_idx IN PLS_INTEGER,
1552: p_batch_sequence IN OUT NOCOPY pay_batch_lines.batch_sequence%TYPE,
1553: p_batch_lines IN OUT NOCOPY PLS_INTEGER,
1554: p_bg_id IN pay_batch_headers.business_group_id%TYPE,
1555: p_session_date IN DATE,
1556: p_effective_date IN DATE,
1643: l_empty_bee_rec hxt_interface_utilities.bee_rec;
1644: l_cost_flex_id per_business_groups_perf.cost_allocation_structure%TYPE
1645: := hxt_interface_utilities.cost_flex_structure_id (p_bg_id);
1646: l_batch_id pay_batch_headers.batch_reference%TYPE;
1647: l_batch_sequence pay_batch_lines.batch_sequence%TYPE;
1648: l_retro_batch_id pay_batch_headers.batch_reference%TYPE;
1649: l_retro_batch_sequence pay_batch_lines.batch_sequence%TYPE;
1650: l_batch_lines PLS_INTEGER;
1651: l_retro_batch_lines PLS_INTEGER;
1645: := hxt_interface_utilities.cost_flex_structure_id (p_bg_id);
1646: l_batch_id pay_batch_headers.batch_reference%TYPE;
1647: l_batch_sequence pay_batch_lines.batch_sequence%TYPE;
1648: l_retro_batch_id pay_batch_headers.batch_reference%TYPE;
1649: l_retro_batch_sequence pay_batch_lines.batch_sequence%TYPE;
1650: l_batch_lines PLS_INTEGER;
1651: l_retro_batch_lines PLS_INTEGER;
1652: i BINARY_INTEGER;
1653: l_space VARCHAR2(15) := ' |';
2857: -- Create a batch header, and then create the batch lines taking values from
2858: -- HXT_BATCH_VALUES_V. There could have been a timecard edit in HXT, and the changed
2859: -- hours could have gone to BEE. The reversal batch lines has to reverse these, rather
2860: -- than the hours you pulled out from HXC. HXT_BATCH_VALUES_V is a view on hxt detail hours
2861: -- and pay batch lines, so what you get from there would be the transferred values.
2862: -- So after you pull out the batch records, turn around the hours with a negative sign
2863: -- and create the lines.
2864: delete_non_transferred_hours;
2865: