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.PER_NL_FDR_ARCHIVE dependencies on UTL_FILE

Line 1038: l_file UTL_FILE.FILE_TYPE;

1034: l_establishment_id NUMBER;
1035: l_org_id NUMBER;
1036: l_org_struct_id NUMBER;
1037: l_org_name VARCHAR2(150);
1038: l_file UTL_FILE.FILE_TYPE;
1039: l_directory_path VARCHAR2(500);
1040: l_file_name VARCHAR2(50);
1041: vCtr NUMBER := 0;
1042: l_xfdf_clob CLOB;

Line 1085: FROM v$parameter WHERE LOWER(name)='utl_file_dir';

1081: AND paa.assignment_action_id = p_assignment_action_id;
1082:
1083:
1084: SELECT value INTO l_directory_path
1085: FROM v$parameter WHERE LOWER(name)='utl_file_dir';
1086:
1087: IF INSTR(l_directory_path,',') > 0 THEN
1088: l_directory_path := SUBSTR(l_directory_path, 1, INSTR(l_directory_path,',')-1);
1089: END IF;

Line 1197: l_file := utl_file.fopen(l_directory_path, l_file_name, 'W');

1193: WritetoCLOB_rtf(l_xfdf_clob, vXMLTable);
1194:
1195: l_file_name := l_employee_number||'_'||to_char(l_tax_reg_num)||'_'||substr(to_char(to_date(l_report_date,'RRRR/MM/DD HH24:MI:SS'),'DD-MM-RR'),1,2)||
1196: substr(to_char(to_date(l_report_date,'RRRR/MM/DD HH24:MI:SS'),'DD-MM-RR'),4,2)||substr(to_char(to_date(l_report_date,'RRRR/MM/DD HH24:MI:SS'),'DD-MM-RR'),7,2)||'.xml';
1197: l_file := utl_file.fopen(l_directory_path, l_file_name, 'W');
1198: utl_file.put_line(l_file,substr(l_xfdf_clob,1,instr(l_xfdf_clob,'')-1));
1199: utl_file.put_line(l_file,substr(l_xfdf_clob,instr(l_xfdf_clob,''),length(l_xfdf_clob)-instr(l_xfdf_clob,'')+1));
1200: utl_file.fclose(l_file);
1201:

Line 1198: utl_file.put_line(l_file,substr(l_xfdf_clob,1,instr(l_xfdf_clob,'')-1));

1194:
1195: l_file_name := l_employee_number||'_'||to_char(l_tax_reg_num)||'_'||substr(to_char(to_date(l_report_date,'RRRR/MM/DD HH24:MI:SS'),'DD-MM-RR'),1,2)||
1196: substr(to_char(to_date(l_report_date,'RRRR/MM/DD HH24:MI:SS'),'DD-MM-RR'),4,2)||substr(to_char(to_date(l_report_date,'RRRR/MM/DD HH24:MI:SS'),'DD-MM-RR'),7,2)||'.xml';
1197: l_file := utl_file.fopen(l_directory_path, l_file_name, 'W');
1198: utl_file.put_line(l_file,substr(l_xfdf_clob,1,instr(l_xfdf_clob,'')-1));
1199: utl_file.put_line(l_file,substr(l_xfdf_clob,instr(l_xfdf_clob,''),length(l_xfdf_clob)-instr(l_xfdf_clob,'')+1));
1200: utl_file.fclose(l_file);
1201:
1202:

Line 1199: utl_file.put_line(l_file,substr(l_xfdf_clob,instr(l_xfdf_clob,''),length(l_xfdf_clob)-instr(l_xfdf_clob,'')+1));

1195: l_file_name := l_employee_number||'_'||to_char(l_tax_reg_num)||'_'||substr(to_char(to_date(l_report_date,'RRRR/MM/DD HH24:MI:SS'),'DD-MM-RR'),1,2)||
1196: substr(to_char(to_date(l_report_date,'RRRR/MM/DD HH24:MI:SS'),'DD-MM-RR'),4,2)||substr(to_char(to_date(l_report_date,'RRRR/MM/DD HH24:MI:SS'),'DD-MM-RR'),7,2)||'.xml';
1197: l_file := utl_file.fopen(l_directory_path, l_file_name, 'W');
1198: utl_file.put_line(l_file,substr(l_xfdf_clob,1,instr(l_xfdf_clob,'')-1));
1199: utl_file.put_line(l_file,substr(l_xfdf_clob,instr(l_xfdf_clob,''),length(l_xfdf_clob)-instr(l_xfdf_clob,'')+1));
1200: utl_file.fclose(l_file);
1201:
1202:
1203: pay_action_information_api.create_action_information

Line 1200: utl_file.fclose(l_file);

1196: substr(to_char(to_date(l_report_date,'RRRR/MM/DD HH24:MI:SS'),'DD-MM-RR'),4,2)||substr(to_char(to_date(l_report_date,'RRRR/MM/DD HH24:MI:SS'),'DD-MM-RR'),7,2)||'.xml';
1197: l_file := utl_file.fopen(l_directory_path, l_file_name, 'W');
1198: utl_file.put_line(l_file,substr(l_xfdf_clob,1,instr(l_xfdf_clob,'')-1));
1199: utl_file.put_line(l_file,substr(l_xfdf_clob,instr(l_xfdf_clob,''),length(l_xfdf_clob)-instr(l_xfdf_clob,'')+1));
1200: utl_file.fclose(l_file);
1201:
1202:
1203: pay_action_information_api.create_action_information
1204: ( p_action_information_id => l_action_info_id