APPS.HR_DU_DI_INSERT dependencies on HR_DU_UPLOAD_HEADERS

Line 423: FROM hr_du_upload_headers head,

419: AND LINE_TYPE = 'C';
420:
421: CURSOR csr_API_name IS
422: SELECT upper(des.value)
423: FROM hr_du_upload_headers head,
424: hr_api_modules api,
425: hr_du_descriptors des
426: WHERE head.upload_header_id = p_upload_header_id
427: AND head.upload_header_id = des.upload_header_id

Line 728: hr_du_upload_headers head

724:
725: CURSOR csr_api_name IS
726: SELECT api.module_NAME
727: FROM hr_api_modules api,
728: hr_du_upload_headers head
729: WHERE head.upload_header_id = p_upload_header_id
730: AND head.api_module_id = api.api_module_id;
731:
732: BEGIN

Line 1251: SELECT HR_DU_UPLOAD_HEADERS_S.nextval

1247: LOOP
1248: FETCH csr_files INTO l_file_record;
1249: EXIT WHEN csr_files%NOTFOUND;
1250:
1251: SELECT HR_DU_UPLOAD_HEADERS_S.nextval
1252: INTO l_upload_header_id
1253: FROM dual;
1254:
1255:

Line 1258: INSERT INTO HR_DU_UPLOAD_HEADERS(

1254:
1255:
1256: hr_du_utility.message('INFO','Insert statement', 15);
1257: --Creating upload_header
1258: INSERT INTO HR_DU_UPLOAD_HEADERS(
1259: UPLOAD_HEADER_ID, UPLOAD_ID, API_MODULE_ID, STATUS,
1260: LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN,
1261: CREATED_BY, CREATION_DATE)
1262: VALUES(

Line 2078: FROM hr_du_upload_headers

2074: COMMIT;
2075:
2076: DELETE FROM HR_DU_UPLOAD_LINES
2077: WHERE UPLOAD_HEADER_ID IN (SELECT upload_header_id
2078: FROM hr_du_upload_headers
2079: WHERE upload_id = p_upload_id);
2080: COMMIT;
2081:
2082: DELETE FROM HR_DU_UPLOAD_HEADERS

Line 2082: DELETE FROM HR_DU_UPLOAD_HEADERS

2078: FROM hr_du_upload_headers
2079: WHERE upload_id = p_upload_id);
2080: COMMIT;
2081:
2082: DELETE FROM HR_DU_UPLOAD_HEADERS
2083: WHERE UPLOAD_ID = p_upload_id;
2084: COMMIT;
2085:
2086: --