APPS.HR_DU_DI_INSERT dependencies on HR_DU_UPLOAD_LINES

Line 406: -- in the HR_DU_UPLOAD_LINES for a particular header and verfies that all

402:
403:
404: -- -------------------------- VALIDATE_API_IDS ----------------------------
405: -- Description: This procedure simply finds out where the ID column is with
406: -- in the HR_DU_UPLOAD_LINES for a particular header and verfies that all
407: -- the values within that ID coulmn are unique.
408: --
409: -- Input Parameters
410: -- p_upload_header_id - Identify the upload header

Line 417: FROM hr_du_upload_lines

413: IS
414:
415: CURSOR csr_line_id IS
416: SELECT UPLOAD_LINE_ID
417: FROM hr_du_upload_lines
418: WHERE upload_header_id = p_upload_header_id
419: AND LINE_TYPE = 'C';
420:
421: CURSOR csr_API_name IS

Line 434: FROM hr_du_upload_lines

430:
431:
432: CURSOR csr_count IS
433: Select count(PVAL001)
434: FROM hr_du_upload_lines
435: WHERE upload_header_id = p_upload_header_id;
436:
437: CURSOR csr_count_distinct IS
438: Select count(DISTINCT PVAL001)

Line 439: FROM hr_du_upload_lines

435: WHERE upload_header_id = p_upload_header_id;
436:
437: CURSOR csr_count_distinct IS
438: Select count(DISTINCT PVAL001)
439: FROM hr_du_upload_lines
440: WHERE upload_header_id = p_upload_header_id;
441:
442:
443: e_fatal_error EXCEPTION;

Line 467: || 'the HR_DU_UPLOAD_LINES';

463: OPEN csr_line_id;
464: FETCH csr_line_id INTO l_line_id;
465: IF csr_line_id%NOTFOUND THEN
466: l_fatal_error_message := 'No appropriate column title row exists in '
467: || 'the HR_DU_UPLOAD_LINES';
468: RAISE e_fatal_error;
469: END IF;
470: CLOSE csr_line_id;
471:

Line 1625: -- the HR_DU_UPLOAD_LINES and takes into account the fact that all lines

1621:
1622:
1623: -- ------------------------- EXTRACT_LINES ------------------------------
1624: -- Description: Takes the lines from the spreadsheet and inserts them in
1625: -- the HR_DU_UPLOAD_LINES and takes into account the fact that all lines
1626: -- must only have one header for one API. So if there are two headers with
1627: -- the same API then all lines are placed into the first one.
1628: --
1629: -- Input Parameters

Line 1801: INSERT INTO hr_du_upload_lines(

1797: null;
1798: ELSE
1799: hr_du_utility.message('INFO','Insert Statement Start ' , 25);
1800:
1801: INSERT INTO hr_du_upload_lines(
1802: UPLOAD_LINE_ID, UPLOAD_HEADER_ID, BATCH_LINE_ID,
1803: STATUS, REFERENCE_TYPE, LINE_TYPE, LAST_UPDATE_DATE,
1804: LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY,
1805: CREATION_DATE, DI_LINE_NUMBER, ORIGINAL_UPLOAD_HEADER_ID,

Line 1846: HR_DU_UPLOAD_LINES_S.nextval, p_upload_header_id, null, 'NS',

1842: PVAL217, PVAL218, PVAL219,PVAL220, PVAL221, PVAL222,
1843: PVAL223, PVAL224, PVAL225,PVAL226, PVAL227, PVAL228,
1844: PVAL229, PVAL230 )
1845: VALUES(
1846: HR_DU_UPLOAD_LINES_S.nextval, p_upload_header_id, null, 'NS',
1847: p_reference_type, l_line_type, sysdate,
1848: 1, 1, 1, sysdate, g_counter, p_original_upload_header_id,
1849: g_line_table(1), g_line_table(2), g_line_table(3),
1850: g_line_table(4), g_line_table(5), g_line_table(6),

Line 2076: DELETE FROM HR_DU_UPLOAD_LINES

2072: DELETE FROM HR_DU_DESCRIPTORS
2073: WHERE UPLOAD_ID = p_upload_id;
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;