APPS.HR_DU_DO_DATAPUMP dependencies on HR_DU_UPLOAD_HEADERS

Line 466: FROM hr_du_upload_headers

462:
463: UPDATE hr_du_upload_lines
464: SET status = 'NS'
465: WHERE UPLOAD_HEADER_ID IN (SELECT upload_header_id
466: FROM hr_du_upload_headers
467: WHERE upload_id = p_upload_id)
468: AND (REFERENCE_TYPE = 'CP' OR LINE_TYPE = 'C');
469: COMMIT;
470:

Line 531: FROM hr_du_upload_headers head,

527:
528:
529: CURSOR csr_upload_line_id IS
530: SELECT line.UPLOAD_LINE_ID
531: FROM hr_du_upload_headers head,
532: hr_du_upload_lines line
533: WHERE head.upload_id = p_upload_id
534: AND head.api_module_id = p_api_module_id
535: AND line.upload_header_id = head.upload_header_id

Line 997: HR_DU_UPLOAD_HEADERS head

993:
994: CURSOR csr_user_key IS
995: SELECT descr.VALUE
996: FROM HR_DU_DESCRIPTORS descr,
997: HR_DU_UPLOAD_HEADERS head
998: WHERE head.upload_id = p_upload_id
999: AND head.api_module_id = g_values_table(p_table_id).r_api_id
1000: AND head.upload_header_id = descr.upload_header_id
1001: AND descr.DESCRIPTOR = 'USER KEY';

Line 1091: hr_du_upload_headers head

1087: --in the specific API header
1088: CURSOR csr_dollar_key_api IS
1089: SELECT des.VALUE
1090: FROM hr_du_descriptors des,
1091: hr_du_upload_headers head
1092: WHERE head.api_module_id = l_api_id
1093: AND head.upload_id = p_upload_id
1094: AND head.upload_header_id = des.upload_header_id
1095: AND upper(des.descriptor) = upper(l_single_key);

Line 1315: FROM hr_du_upload_headers head,

1311:
1312: --Returns the line_id for the column names in HR_DU_UPLOAD_LINES
1313: CURSOR csr_line_id IS
1314: SELECT line.UPLOAD_LINE_ID
1315: FROM hr_du_upload_headers head,
1316: hr_du_upload_lines line
1317: WHERE head.upload_id = p_upload_id
1318: AND head.api_module_id = p_api_module_id
1319: AND line.upload_header_id = head.upload_header_id

Line 1675: FROM hr_du_upload_headers head,

1671: IS
1672:
1673: CURSOR csr_line_id IS
1674: SELECT line.UPLOAD_LINE_ID
1675: FROM hr_du_upload_headers head,
1676: hr_du_upload_lines line
1677: WHERE head.upload_id = p_upload_id
1678: AND head.api_module_id = p_api_module_id
1679: AND line.upload_header_id = head.upload_header_id

Line 1742: FROM hr_du_upload_headers head,

1738: PROCEDURE VALIDATE(p_upload_id IN NUMBER) IS
1739:
1740: CURSOR csr_validate_data IS
1741: SELECT line.UPLOAD_LINE_ID
1742: FROM hr_du_upload_headers head,
1743: hr_du_upload_lines line
1744: WHERE head.upload_id = p_upload_id
1745: AND line.upload_header_id = head.upload_header_id
1746: AND line.REFERENCE_TYPE = 'CP';

Line 1819: FROM hr_du_upload_headers

1815:
1816: UPDATE hr_du_upload_lines
1817: SET status = 'NS'
1818: WHERE UPLOAD_HEADER_ID IN (SELECT upload_header_id
1819: FROM hr_du_upload_headers
1820: WHERE upload_id = p_upload_id)
1821: AND status = 'S';
1822:
1823: SELECT BATCH_ID

Line 1932: hr_du_upload_headers head

1928: --Returns the upload line and header to be placed in Pump lines
1929: CURSOR csr_upload_line_id IS
1930: SELECT line.upload_line_id, line.upload_header_id
1931: FROM hr_du_upload_lines line,
1932: hr_du_upload_headers head
1933: WHERE head.upload_id = p_upload_id
1934: AND head.api_module_id = l_api_module_id
1935: AND line.upload_header_id = head.upload_header_id
1936: AND line.status = 'NS'