[Home] [Help]
107: l_valid_batch_name := l_batch_name;
108: IF g_debug THEN
109: hr_utility.set_location('Before creating new valid batch header', 30);
110: END IF;
111: pay_batch_element_entry_api.create_batch_header (p_session_date => sysdate,
112: p_batch_name => l_valid_batch_name,
113: p_business_group_id => p_bus_group_id,
114: p_action_if_exists => 'I',
115: p_batch_reference => l_valid_batch_name||l_string1,
121: IF g_debug THEN
122: hr_utility.set_location('After creating new valid batch header: '||l_valid_batch_id, 40);
123: END IF;
124: l_valid_batch_name := l_valid_batch_name||l_string2||to_char(l_valid_batch_id);
125: pay_batch_element_entry_api.update_batch_header (p_session_date => sysdate,
126: p_batch_id => l_valid_batch_id,
127: p_object_version_number => l_object_version_number,
128: p_batch_name => l_valid_batch_name
129: ); /* For updating the batch_name of the newly created batch */
151: l_warning_batch_name := l_batch_name||'_W';
152: IF g_debug THEN
153: hr_utility.set_location('Before creating new warning batch header', 70);
154: END IF;
155: pay_batch_element_entry_api.create_batch_header (p_session_date => sysdate,
156: p_batch_name => l_warning_batch_name,
157: p_business_group_id => p_bus_group_id,
158: p_action_if_exists => 'I',
159: p_batch_reference => l_warning_batch_name||l_string1,
165: IF g_debug THEN
166: hr_utility.set_location('After creating new warning batch header: '||l_warning_batch_id, 80);
167: END IF;
168: l_warning_batch_name := l_warning_batch_name||l_string2||to_char(l_warning_batch_id);
169: pay_batch_element_entry_api.update_batch_header (p_session_date => sysdate,
170: p_batch_id => l_warning_batch_id,
171: p_object_version_number => l_object_version_number,
172: p_batch_name => l_warning_batch_name
173: ); /* For updating the batch_name of the newly created batch */
196: l_error_batch_name := l_batch_name||'_E';
197: IF g_debug THEN
198: hr_utility.set_location('Before creating new error batch header', 110);
199: END IF;
200: pay_batch_element_entry_api.create_batch_header (p_session_date => sysdate,
201: p_batch_name => l_error_batch_name,
202: p_business_group_id => p_bus_group_id,
203: p_action_if_exists => 'I',
204: p_batch_reference => l_error_batch_name||l_string1,
210: IF g_debug THEN
211: hr_utility.set_location('after creating new error batch header: '||l_error_batch_id, 120);
212: END IF;
213: l_error_batch_name := l_error_batch_name||l_string2||to_char(l_error_batch_id);
214: pay_batch_element_entry_api.update_batch_header (p_session_date => sysdate,
215: p_batch_id => l_error_batch_id,
216: p_object_version_number => l_object_version_number,
217: p_batch_name => l_error_batch_name
218: ); /* For updating the batch_name of the newly created batch */
319: hr_utility.set_location('Before deleting empty batches: '||p_del_empty_batches(l_loop_index2).batch_id||
320: ' ovn: '||p_del_empty_batches(l_loop_index2).batch_ovn, 170);
321: END IF;
322:
323: pay_batch_element_entry_api.delete_batch_header (p_batch_id => p_del_empty_batches(l_loop_index2).batch_id,
324: p_object_version_number => p_del_empty_batches(l_loop_index2).batch_ovn
325: );
326: IF g_debug THEN
327: hr_utility.set_location('After deleting empty batches', 180);
1289: hr_utility.set_location('dtl_to_BEE',210);
1290: end if;
1291: HXT_UTIL.DEBUG('batch_sequence = '||to_char(p_batch_sequence)); --HXT115
1292: -- Insert data into BEE table
1293: PAY_BATCH_ELEMENT_ENTRY_API.create_batch_line
1294: (p_session_date => sysdate
1295: ,p_batch_id => p_values_rec.batch_id
1296: ,p_batch_line_status => 'U'
1297: ,p_assignment_id => p_values_rec.assignment_id
1676: IF p_time_period_id IS NULL THEN
1677: -- Delete PayMIX
1678: --
1679: for l_rec in c_get_batch_lines(p_batch_id) loop
1680: PAY_BATCH_ELEMENT_ENTRY_API.delete_batch_line
1681: (p_batch_line_id => l_rec.batch_line_id
1682: ,p_object_version_number => l_rec.object_version_number
1683: );
1684: end loop;
1693: --Then we loop through the cursor and delete the batch lines and batches as follows.
1694: for l_rec in c_get_retro_batch_ids(p_batch_id) loop
1695: -- delete the batch lines
1696: for l_line_rec in c_get_batch_lines(l_rec.retro_batch_id) loop
1697: PAY_BATCH_ELEMENT_ENTRY_API.delete_batch_line
1698: (p_batch_line_id => l_line_rec.batch_line_id
1699: ,p_object_version_number => l_line_rec.object_version_number
1700: );
1701: end loop;
1699: ,p_object_version_number => l_line_rec.object_version_number
1700: );
1701: end loop;
1702: -- delete the batch
1703: PAY_BATCH_ELEMENT_ENTRY_API.delete_batch_header
1704: (p_batch_id => l_rec.retro_batch_id
1705: ,p_object_version_number => l_rec.object_version_number
1706: );
1707: end loop;
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
1761: ,p_batch_status => 'U'
1762: ,p_business_group_id => l_business_group_id
1786: SET tim.batch_id = l_new_batch
1787: WHERE tim.batch_id = p_batch_id
1788: AND tim.id = l_tim_id;
1789: -- Delete actual PayMIX batch lines
1790: PAY_BATCH_ELEMENT_ENTRY_API.delete_batch_line
1791: (p_batch_line_id => batch_line_rec.batch_line_id
1792: ,p_object_version_number => batch_line_rec.object_version_number
1793: );
1794: END LOOP;
1800: -- no batch lines found. So we can delete this batch
1801: OPEN c_get_batch_ovn (p_batch_id);
1802: FETCH c_get_batch_ovn INTO l_batch_ovn;
1803: CLOSE c_get_batch_ovn;
1804: pay_batch_element_entry_api.delete_batch_header (
1805: p_batch_id => p_batch_id,
1806: p_object_version_number => l_batch_ovn
1807: );
1808: END IF;