DBA Data[Home] [Help]

APPS.HR_DU_DO_DATAPUMP dependencies on HR_PUMP_BATCH_EXCEPTIONS

Line 1829: DELETE FROM hr_pump_batch_exceptions

1825: FROM hr_du_uploads
1826: WHERE upload_id = p_upload_id;
1827:
1828: --deletes the header from the batch exception
1829: DELETE FROM hr_pump_batch_exceptions
1830: WHERE source_id = l_batch_id
1831: AND source_type = 'BATCH_HEADER';
1832:
1833: OPEN csr_batch_lines;

Line 1841: DELETE FROM hr_pump_batch_exceptions

1837: EXIT WHEN csr_batch_lines%NOTFOUND;
1838:
1839: --act upon the previous statement to delete approiate exceptions
1840: if l_line_status = 'E' Then
1841: DELETE FROM hr_pump_batch_exceptions
1842: WHERE source_id = l_batch_line
1843: AND source_type = 'BATCH_LINE';
1844: END IF;
1845: --insert extra code here to remove data from user keys in the future