eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_DU_DO_DATAPUMP dependencies on HR_DU_UPLOAD_LINES

Line 142: FROM HR_DU_UPLOAD_LINES

138: g_column_headings(220),g_column_headings(221),g_column_headings(222),
139: g_column_headings(223),g_column_headings(224),g_column_headings(225),
140: g_column_headings(226),g_column_headings(227),g_column_headings(228),
141: g_column_headings(229),g_column_headings(230)
142: FROM HR_DU_UPLOAD_LINES
143: WHERE UPLOAD_LINE_ID = p_line_id;
144:
145: hr_du_utility.message('INFO','Select Statement Ends ' , 20);
146:

Line 451: -- the relevant HR_DU_UPLOAD_LINES to be identified

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:
455: BEGIN

Line 463: UPDATE hr_du_upload_lines

459: 'entry:hr_du_do_datapump.set_status', 5);
460: hr_du_utility.message('PARA', '(p_upload_id - ' || p_upload_id || ')', 10);
461: --
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)

Line 532: hr_du_upload_lines line

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
536: AND line.PVAL001 = to_char(p_column_id);

Line 630: ('HR_DU_UPLOAD_LINES', l_upload_line_id,

626: ELSE
627: --adds column values to the user_key
628:
629: l_field_value := hr_du_dp_pc_conversion.return_field_value
630: ('HR_DU_UPLOAD_LINES', l_upload_line_id,
631: 'upload_line_id', l_single_key);
632:
633: l_actual_user_key := l_actual_user_key || ':' || l_field_value;
634: END IF;

Line 786: ('HR_DU_UPLOAD_LINES', p_upload_line_id,

782: ELSE
783: --adds column values to the user_key
784:
785: l_field_value := hr_du_dp_pc_conversion.RETURN_FIELD_VALUE
786: ('HR_DU_UPLOAD_LINES', p_upload_line_id,
787: 'upload_line_id', l_single_key);
788:
789: l_actual_user_key := l_actual_user_key || ':' || l_field_value;
790: END IF;

Line 1162: 'to a PVAL column in HR_DU_UPLOAD_LINES';

1158:
1159: IF l_key_pval IS NULL THEN
1160: l_fatal_error_message := 'Error occured trying to map part of the '
1161: || 'user key : ' || l_mapped_name || ' ' ||
1162: 'to a PVAL column in HR_DU_UPLOAD_LINES';
1163: RAISE e_fatal_error;
1164: END IF;
1165: l_key_pval_string := l_key_pval_string || ':' || l_key_pval;
1166:

Line 1312: --Returns the line_id for the column names in HR_DU_UPLOAD_LINES

1308: p_upload_id IN NUMBER,
1309: p_array_pos IN NUMBER)
1310: IS
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

Line 1316: hr_du_upload_lines line

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
1320: AND line.LINE_TYPE = 'C';

Line 1346: 'the HR_DU_UPLOAD_LINES for the api_module '||

1342: OPEN csr_line_id;
1343: FETCH csr_line_id INTO l_line_id;
1344: IF csr_line_id%NOTFOUND THEN
1345: l_fatal_error_message := 'No appropriate column title row exists in '||
1346: 'the HR_DU_UPLOAD_LINES for the api_module '||
1347: 'passed';
1348: RAISE e_fatal_error;
1349: END IF;
1350: CLOSE csr_line_id;

Line 1676: hr_du_upload_lines line

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
1680: AND line.LINE_TYPE = 'C';

Line 1701: 'the HR_DU_UPLOAD_LINES for the api_module passed';

1697: OPEN csr_line_id;
1698: FETCH csr_line_id INTO l_line_id;
1699: IF csr_line_id%NOTFOUND THEN
1700: l_fatal_error_message := 'No appropriate column title row exists in '||
1701: 'the HR_DU_UPLOAD_LINES for the api_module passed';
1702: RAISE e_fatal_error;
1703: END IF;
1704: CLOSE csr_line_id;
1705:

Line 1743: hr_du_upload_lines line

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';
1747:

Line 1816: UPDATE hr_du_upload_lines

1812: hr_du_utility.message('PARA', '(p_upload_id - ' || p_upload_id || ')' , 10);
1813: --
1814:
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)

Line 1931: FROM hr_du_upload_lines line,

1927:
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

Line 2077: UPDATE hr_du_upload_lines

2073: INTO l_pump_batch_line_id
2074: FROM dual;
2075:
2076: --change the status of the PC row to show we're processing this
2077: UPDATE hr_du_upload_lines
2078: SET status = 'S'
2079: WHERE upload_line_id = l_upload_line_id;
2080:
2081: --If statements inserted here to call the appropriate procedure within

Line 2108: UPDATE hr_du_upload_lines

2104: END IF;
2105:
2106: --change the status of the PC row to show we're processing this
2107: --and connect the HR_DU_UPLOAD_LINE to the HR_PUMP_BATCH_LINE
2108: UPDATE hr_du_upload_lines
2109: SET status = 'C',
2110: batch_line_id = l_pump_batch_line_id
2111: WHERE upload_line_id = l_upload_line_id;
2112: