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_DP_PC_CONVERSION dependencies on HR_DU_UPLOAD_LINES

Line 211: FROM HR_DU_UPLOAD_LINES

207: g_column_headings(220),g_column_headings(221),g_column_headings(222),
208: g_column_headings(223),g_column_headings(224),g_column_headings(225),
209: g_column_headings(226),g_column_headings(227),g_column_headings(228),
210: g_column_headings(229),g_column_headings(230)
211: FROM HR_DU_UPLOAD_LINES
212: WHERE UPLOAD_LINE_ID = p_line_id;
213:
214: hr_du_utility.message('INFO','Select Statement Ends ' , 20);
215:

Line 232: -- with in the HR_DU_UPLOAD_LINES have thier appropriate file attached. i.e.

228:
229:
230: -- ------------------------- VERIFY_API_ATTACHED ---------------------------
231: -- Description: This Procedure simply checks that the referencing columns
232: -- with in the HR_DU_UPLOAD_LINES have thier appropriate file attached. i.e.
233: -- in the person api an error would be raised if they had an address
234: -- and the address flat file as not present.
235: --
236: -- Input Parameters

Line 779: -- column of an HR_DU_UPLOAD_LINES (p_id_pval).

775:
776:
777: -- ------------------------- MAX_ID_VALUE --------------------------------
778: -- Description: Returns the maximum value stored with in the specified
779: -- column of an HR_DU_UPLOAD_LINES (p_id_pval).
780: --
781: -- Input Parameters
782: --
783: -- p_upload_line_id - Allows the select statement to be confined

Line 801: FROM hr_du_upload_lines

797: l_max_number NUMBER;
798:
799: CURSOR csr_max_id IS
800: SELECT MAX(to_number(PVAL001))
801: FROM hr_du_upload_lines
802: WHERE UPLOAD_HEADER_ID IN (SELECT upload_header_id
803: FROM hr_du_upload_lines
804: WHERE upload_line_id = p_upload_line_id)
805: AND LINE_TYPE = 'D';

Line 803: FROM hr_du_upload_lines

799: CURSOR csr_max_id IS
800: SELECT MAX(to_number(PVAL001))
801: FROM hr_du_upload_lines
802: WHERE UPLOAD_HEADER_ID IN (SELECT upload_header_id
803: FROM hr_du_upload_lines
804: WHERE upload_line_id = p_upload_line_id)
805: AND LINE_TYPE = 'D';
806:
807: BEGIN

Line 1109: --Returns the upload_line_id from HR_DU_UPLOAD_LINES where the header id,

1105: l_api_module_id_string VARCHAR2(200) := null;
1106: l_spaces BOOLEAN := FALSE;
1107: l_spreadsheet_cell VARCHAR2(10);
1108:
1109: --Returns the upload_line_id from HR_DU_UPLOAD_LINES where the header id,
1110: --and the LINE_TYPE match i.e. the column headers 'C'.
1111: CURSOR csr_line_id IS
1112: SELECT UPLOAD_LINE_ID
1113: FROM hr_du_upload_lines

Line 1113: FROM hr_du_upload_lines

1109: --Returns the upload_line_id from HR_DU_UPLOAD_LINES where the header id,
1110: --and the LINE_TYPE match i.e. the column headers 'C'.
1111: CURSOR csr_line_id IS
1112: SELECT UPLOAD_LINE_ID
1113: FROM hr_du_upload_lines
1114: WHERE upload_header_id = p_upload_header_id
1115: AND LINE_TYPE = 'C';
1116:
1117: CURSOR csr_DI_LINE_NUMBER IS

Line 1119: FROM hr_du_upload_lines

1115: AND LINE_TYPE = 'C';
1116:
1117: CURSOR csr_DI_LINE_NUMBER IS
1118: SELECT DI_LINE_NUMBER
1119: FROM hr_du_upload_lines
1120: WHERE upload_line_id = l_line_id;
1121:
1122: CURSOR csr_api_file IS
1123: SELECT des.value

Line 1145: 'the HR_DU_UPLOAD_LINES for the api passed';

1141: OPEN csr_line_id;
1142: FETCH csr_line_id INTO l_line_id;
1143: IF csr_line_id%NOTFOUND THEN
1144: l_fatal_error_message := 'No appropriate column title row exists in '||
1145: 'the HR_DU_UPLOAD_LINES for the api passed';
1146: RAISE e_fatal_error;
1147: END IF;
1148: CLOSE csr_line_id;
1149:

Line 1152: UPDATE hr_du_upload_lines

1148: CLOSE csr_line_id;
1149:
1150: --change the status of the PC row column heading to reflect that processing
1151: --on that line has started.
1152: UPDATE hr_du_upload_lines
1153: SET status = 'S'
1154: WHERE upload_line_id = l_line_id;
1155:
1156: COMMIT;

Line 1275: UPDATE hr_du_upload_lines

1271:
1272:
1273: --change the status of the PC row column heading to show that
1274: --I've completed
1275: UPDATE hr_du_upload_lines
1276: SET status = 'C'
1277: WHERE upload_line_id = l_line_id;
1278:
1279: --

Line 1347: FROM hr_du_upload_lines

1343:
1344:
1345: CURSOR csr_field_value IS
1346: SELECT to_number(PVAL001)
1347: FROM hr_du_upload_lines
1348: WHERE upload_line_id = l_upload_line_id;
1349:
1350: BEGIN
1351: --

Line 1414: FROM hr_du_upload_lines line,

1410: BEGIN
1411: --
1412: SELECT line.upload_line_id, line.upload_header_id
1413: INTO l_upload_line_id, l_upload_header_id
1414: FROM hr_du_upload_lines line,
1415: hr_du_upload_headers head
1416: WHERE head.upload_id = p_upload_id
1417: AND head.api_module_id = l_api_module_id
1418: AND line.upload_header_id = head.upload_header_id

Line 1470: FROM hr_du_upload_lines line,

1466: l_upload_header_id := NULL;
1467:
1468: SELECT line.upload_line_id, line.upload_header_id
1469: INTO l_upload_line_id, l_upload_header_id
1470: FROM hr_du_upload_lines line,
1471: hr_du_upload_headers head
1472: WHERE head.upload_id = p_upload_id
1473: AND head.api_module_id = l_api_module_id
1474: AND line.upload_header_id = head.upload_header_id

Line 1575: FROM hr_du_upload_lines

1571:
1572:
1573: CURSOR csr_line_id IS
1574: SELECT UPLOAD_LINE_ID
1575: FROM hr_du_upload_lines
1576: WHERE upload_header_id = p_upload_header_id
1577: AND PVAL001 = to_char(p_target_ID)
1578: AND REFERENCE_TYPE = 'PC';
1579:

Line 1638: UPDATE hr_du_upload_lines

1634:
1635: hr_du_utility.message('INFO', 'l_upload_line_id : ' || l_upload_line_id, 15);
1636:
1637: --change the status of the PC row to show we're processing this
1638: UPDATE hr_du_upload_lines
1639: SET status = 'S'
1640: WHERE upload_line_id = l_upload_line_id;
1641:
1642: Select HR_DU_UPLOAD_LINES_S.nextval

Line 1642: Select HR_DU_UPLOAD_LINES_S.nextval

1638: UPDATE hr_du_upload_lines
1639: SET status = 'S'
1640: WHERE upload_line_id = l_upload_line_id;
1641:
1642: Select HR_DU_UPLOAD_LINES_S.nextval
1643: INTO l_line_id
1644: FROM dual;
1645:
1646: Select ORIGINAL_UPLOAD_HEADER_ID

Line 1648: FROM hr_du_upload_lines

1644: FROM dual;
1645:
1646: Select ORIGINAL_UPLOAD_HEADER_ID
1647: INTO l_original_upload_header_id
1648: FROM hr_du_upload_lines
1649: WHERE upload_line_id = l_upload_line_id;
1650:
1651: --String being built up simply creates a new UPLOAD_LINE with all of the
1652: --none referencing columns' data being copied across

Line 1653: l_built_up_string1 := 'INSERT INTO hr_du_upload_lines( ' ||

1649: WHERE upload_line_id = l_upload_line_id;
1650:
1651: --String being built up simply creates a new UPLOAD_LINE with all of the
1652: --none referencing columns' data being copied across
1653: l_built_up_string1 := 'INSERT INTO hr_du_upload_lines( ' ||
1654: ' UPLOAD_LINE_ID, UPLOAD_HEADER_ID, BATCH_LINE_ID, ' ||
1655: ' STATUS, REFERENCE_TYPE, LINE_TYPE, LAST_UPDATE_DATE, ' ||
1656: ' LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY, CREATION_DATE, ' ||
1657: ' ORIGINAL_UPLOAD_HEADER_ID, PVAL001,' ||

Line 1669: ' FROM hr_du_upload_lines ' ||

1665: l_built_up_string2 := ', 1, 1, 1,' ;
1666: l_built_up_string3 := ' ,' || l_original_upload_header_id || ' ,' ||
1667: ( g_insert_table(p_target_api_module).r_id_curval + 1) ||
1668: ',' || g_insert_table(p_target_api_module).r_none_ref_PVAL ||
1669: ' FROM hr_du_upload_lines ' ||
1670: ' WHERE upload_line_id = ' || l_upload_line_id;
1671:
1672: --grab the sysdate and formate it to the correct style to be executed later
1673: SELECT ' to_date(''' || to_char(sysdate, 'YYYY/MM/DD') ||

Line 1726: l_cell_value := RETURN_FIELD_VALUE ('HR_DU_UPLOAD_LINES',

1722: || l_target_api_module, 30);
1723:
1724: --Target the value of the cell with the appropriate PVAL*** supplied
1725: --by l_reference_pval
1726: l_cell_value := RETURN_FIELD_VALUE ('HR_DU_UPLOAD_LINES',
1727: l_upload_line_id, 'upload_line_id', l_reference_pval);
1728:
1729: --removes leading and trailing spaces from the reference number
1730: REMOVE_SPACES (l_cell_value, l_spaces);

Line 1812: l_built_up_string1 := 'update HR_DU_UPLOAD_LINES SET ' ||

1808: l_single_pval := hr_du_di_insert.Return_Word(
1809: g_insert_table(p_target_api_module).R_API_PVALS, j);
1810:
1811: --modifies the line with the extra CP referencing information
1812: l_built_up_string1 := 'update HR_DU_UPLOAD_LINES SET ' ||
1813: l_single_pval || ' = ''' || p_prev_upload_line_id ||
1814: ''' WHERE upload_line_id = ' || l_line_id;
1815:
1816: hr_du_utility.message('INFO', l_built_up_string1 ,50);

Line 1850: l_built_up_string3 := 'update HR_DU_UPLOAD_LINES SET ' ||

1846: g_insert_table(p_target_api_module).r_generic_pval);
1847: l_generic_pval := hr_du_di_insert.Return_Word(
1848: g_insert_table(p_target_api_module).r_generic_pval, j);
1849:
1850: l_built_up_string3 := 'update HR_DU_UPLOAD_LINES SET ' ||
1851: l_single_pval || ' = ''' || p_prev_upload_line_id
1852: || ''',' || l_generic_pval || ' = ''' ||
1853: g_insert_table(p_prev_table_number).r_api_id ||
1854: ''' WHERE upload_line_id = ' || l_line_id;

Line 1871: UPDATE hr_du_upload_lines

1867: END IF;
1868: END IF;
1869:
1870: --change the status of the PC row to show we've completed the process
1871: UPDATE hr_du_upload_lines
1872: SET status = 'C'
1873: WHERE upload_line_id = l_upload_line_id;
1874:
1875: --change the status of the CP row to show we've completed the process

Line 1876: UPDATE hr_du_upload_lines

1872: SET status = 'C'
1873: WHERE upload_line_id = l_upload_line_id;
1874:
1875: --change the status of the CP row to show we've completed the process
1876: UPDATE hr_du_upload_lines
1877: SET status = 'C'
1878: WHERE upload_line_id = l_line_id;
1879:
1880: COMMIT;

Line 1962: DELETE FROM HR_DU_UPLOAD_LINES

1958: hr_du_utility.message('PARA', '(p_upload_id - ' || p_upload_id || ')' , 10);
1959: --
1960:
1961:
1962: DELETE FROM HR_DU_UPLOAD_LINES
1963: WHERE UPLOAD_HEADER_ID IN (SELECT head.upload_header_id
1964: FROM hr_du_upload_headers head,
1965: hr_du_descriptors des
1966: WHERE head.upload_id = p_upload_id

Line 1973: UPDATE hr_du_upload_lines

1969: AND upper(des.value) = 'PC')
1970: AND REFERENCE_TYPE = 'CP';
1971: COMMIT;
1972:
1973: UPDATE hr_du_upload_lines
1974: SET status = 'NS'
1975: WHERE UPLOAD_HEADER_ID IN (SELECT upload_header_id
1976: FROM hr_du_upload_headers
1977: WHERE upload_id = p_upload_id)