APPS.HR_DU_DO_DATAPUMP dependencies on HR_DU_UPLOADS

Line 450: -- p_upload_id - Link to the HR_DU_UPLOADS table that will allow all

446: -- Description: Sets all the lines that will be read during the execution
447: -- of this package.
448: --
449: -- Input Parameters
450: -- p_upload_id - Link to the HR_DU_UPLOADS table that will allow all
451: -- the relevant HR_DU_UPLOAD_LINES to be identified
452: -- -------------------------------------------------------------------------
453: PROCEDURE SET_STATUS(p_upload_id IN NUMBER) IS
454:

Line 943: --Retrieve the business group for the appropriate HR_DU_UPLOADS

939: 'entry:hr_du_do_datapump.extract_business_group', 5);
940: hr_du_utility.message('PARA', '(p_upload_id - ' || p_upload_id || ')', 10);
941: --
942:
943: --Retrieve the business group for the appropriate HR_DU_UPLOADS
944: BEGIN
945: SELECT VALUE
946: INTO l_business_group
947: FROM HR_DU_DESCRIPTORS

Line 953: ' business group from HR_DU_UPLOADS with the'||

949: AND upload_id = p_upload_id;
950: EXCEPTION
951: WHEN OTHERS THEN
952: l_fatal_error_message := 'Error occured while trying to retrieve the' ||
953: ' business group from HR_DU_UPLOADS with the'||
954: ' upload_id of : ' || p_upload_id ;
955: RAISE e_fatal_error;
956: END;
957:

Line 1080: hr_du_uploads uplo

1076: --in the main header for all API's
1077: CURSOR csr_dollar_key IS
1078: SELECT des.VALUE
1079: FROM hr_du_descriptors des,
1080: hr_du_uploads uplo
1081: WHERE uplo.upload_id = p_upload_id
1082: AND uplo.upload_id = des.upload_id
1083: AND des.upload_header_id IS NULL
1084: AND upper(des.descriptor) = upper(l_single_key);

Line 1495: -- entries in the HR_DU_UPLOADS table.

1491: -- p_api_module_id - Holds the id of the API to which the column
1492: -- heading is related to in the HR_API_MODULES table.
1493: --
1494: -- p_upload_id - Holds the upload id to destinguish between
1495: -- entries in the HR_DU_UPLOADS table.
1496: --
1497: -- p_array_pos - the array position in the PL/SQL table that is
1498: -- currently being used.
1499: --

Line 1825: FROM hr_du_uploads

1821: AND status = 'S';
1822:
1823: SELECT BATCH_ID
1824: INTO l_batch_id
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

Line 1864: UPDATE hr_du_uploads

1860: DELETE FROM hr_pump_requests
1861: WHERE BATCH_ID = l_batch_id;
1862:
1863: --include this statement here so that no foreign keys are violated
1864: UPDATE hr_du_uploads
1865: SET batch_id = null
1866: WHERE upload_id = p_upload_id;
1867:
1868: -- deletes the info in the batch header

Line 2005: UPDATE hr_du_uploads

2001:
2002: hr_du_utility.message('INFO','l_batch_id : ' || l_batch_id, 20);
2003:
2004:
2005: UPDATE hr_du_uploads
2006: SET batch_id = l_batch_id
2007: WHERE upload_id = p_upload_id;
2008: COMMIT;
2009: