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_DI_INSERT dependencies on UTL_FILE

Line 717: FUNCTION NEXT_LINE (p_filehandle IN utl_file.file_type,

713: -- Output Parameters
714: -- l_data_line - new line with the removed articles
715: -- passed back
716: -- ------------------------------------------------------------------------
717: FUNCTION NEXT_LINE (p_filehandle IN utl_file.file_type,
718: p_upload_header_id IN NUMBER ) RETURN VARCHAR2
719: IS
720:
721: l_data_line VARCHAR2(32767);

Line 738: utl_file.get_line(p_filehandle,l_data_line);

734: hr_du_utility.message('ROUT','entry:hr_du_di_insert.next_line', 5);
735: hr_du_utility.message('PARA', '(p_filehandle - Record type )' , 10);
736: --
737: g_counter := g_counter + 1;
738: utl_file.get_line(p_filehandle,l_data_line);
739: l_string_length := LENGTH(l_data_line);
740: --
741: hr_du_utility.message('INFO','Value of the line ' || l_data_line, 15);
742: --

Line 901: PROCEDURE GENERAL_EXTRACT (p_filehandle IN utl_file.file_type,

897: -- p_descriptor_type - Either D or F inputted into the descriptor table
898: --
899: -- ------------------------------------------------------------------------
900:
901: PROCEDURE GENERAL_EXTRACT (p_filehandle IN utl_file.file_type,
902: p_upload_id IN NUMBER,
903: p_upload_header_id IN NUMBER, p_string IN VARCHAR2,
904: p_descriptor_type IN VARCHAR)
905: IS

Line 1044: PROCEDURE EXTRACT_API_LOCATIONS (p_filehandle IN utl_file.file_type,

1040: --
1041: -- p_upload_id - HR_DU_UPLOAD_ID
1042: --
1043: -- ------------------------------------------------------------------------
1044: PROCEDURE EXTRACT_API_LOCATIONS (p_filehandle IN utl_file.file_type,
1045: p_upload_id IN NUMBER)
1046:
1047: IS
1048: l_file_descriptor VARCHAR2(2000) :='F';

Line 1084: PROCEDURE EXTRACT_HEADERS (p_filehandle IN utl_file.file_type,

1080: --
1081: -- p_upload_id - HR_DU_UPLOAD_ID
1082: --
1083: -- ------------------------------------------------------------------------
1084: PROCEDURE EXTRACT_HEADERS (p_filehandle IN utl_file.file_type,
1085: p_upload_id IN NUMBER)
1086: IS
1087: l_file_descriptor VARCHAR2(2000) :='D';
1088: l_Column_one_header VARCHAR2(2000) :='HEADER';

Line 1126: FUNCTION EXTRACT_DESCRIPTORS (p_filehandle IN utl_file.file_type,

1122: --
1123: -- p_upload_header_id - HR_DU_UPLOAD_HEADER_ID
1124: --
1125: -- ------------------------------------------------------------------------
1126: FUNCTION EXTRACT_DESCRIPTORS (p_filehandle IN utl_file.file_type,
1127: p_upload_id IN NUMBER, p_upload_header_id IN NUMBER)
1128: RETURN VARCHAR2
1129: IS
1130: l_file_descriptor VARCHAR2(2000) :='D';

Line 1219: l_filehandle UTL_FILE.FILE_TYPE;

1215:
1216: e_fatal_error EXCEPTION;
1217: l_fatal_error_message VARCHAR2(2000);
1218: l_file_record csr_files%ROWTYPE;
1219: l_filehandle UTL_FILE.FILE_TYPE;
1220: l_upload_header_id NUMBER;
1221: l_reference_type VARCHAR2(10);
1222: l_descriptor VARCHAR2(50);
1223: l_table_size NUMBER := 0;

Line 1575: RETURN utl_file.file_type

1571: -- l_filehandle - handle to the file so it can be referenced later
1572: --
1573: -- ------------------------------------------------------------------------
1574: FUNCTION OPEN_FILE (p_file_location IN varchar2, p_file_name IN varchar2)
1575: RETURN utl_file.file_type
1576: IS
1577: --
1578: CURSOR csr_valid_profile IS
1579: SELECT value

Line 1581: WHERE name='utl_file_dir';

1577: --
1578: CURSOR csr_valid_profile IS
1579: SELECT value
1580: FROM v$parameter
1581: WHERE name='utl_file_dir';
1582: --
1583: l_filehandle UTL_FILE.FILE_TYPE;
1584: l_location VARCHAR2(2000);
1585: l_valid_profile VARCHAR2(2000);

Line 1583: l_filehandle UTL_FILE.FILE_TYPE;

1579: SELECT value
1580: FROM v$parameter
1581: WHERE name='utl_file_dir';
1582: --
1583: l_filehandle UTL_FILE.FILE_TYPE;
1584: l_location VARCHAR2(2000);
1585: l_valid_profile VARCHAR2(2000);
1586: --
1587: BEGIN

Line 1605: l_filehandle := utl_file.fopen(p_file_location, p_file_name, 'r', 32767);

1601: hr_du_utility.message('SUMM', 'File name ->' || p_file_name , 25);
1602: hr_du_utility.message('SUMM', 'File location/HR: Data Exchange Directory profile option->' || l_location , 30);
1603: hr_du_utility.message('SUMM', 'Valid options for HR: Data Exchange Directory profile ->' || l_valid_profile , 35);
1604: --
1605: l_filehandle := utl_file.fopen(p_file_location, p_file_name, 'r', 32767);
1606: g_counter := 0;
1607: --
1608: hr_du_utility.message('ROUT','exit:hr_du_di_insert.open_file', 15);
1609: hr_du_utility.message('PARA', '(l_filehandle - File Type )' , 20);

Line 1645: PROCEDURE EXTRACT_LINES(p_filehandle IN utl_file.file_type,

1641: -- p_upload_header_id - The Header that the line is placed
1642: -- with so all the lines will be in a
1643: -- header with the ownership of the API
1644: -- ------------------------------------------------------------------------
1645: PROCEDURE EXTRACT_LINES(p_filehandle IN utl_file.file_type,
1646: p_upload_id IN NUMBER, p_original_upload_header_id IN NUMBER,
1647: p_reference_type IN VARCHAR2, p_api_module_id IN NUMBER,
1648: p_upload_header_id IN NUMBER)
1649: IS

Line 1979: l_filehandle UTL_FILE.FILE_TYPE;

1975: -- ------------------------------------------------------------------------
1976: PROCEDURE ORDERED_SEQUENCE(p_upload_id IN NUMBER)
1977: IS
1978:
1979: l_filehandle UTL_FILE.FILE_TYPE;
1980: l_data_line VARCHAR2(2000);
1981: l_number NUMBER;
1982: l_location VARCHAR2(2000);
1983: l_file_name VARCHAR2(2000);