3:
4: PROCEDURE write_header
5: IS
6: BEGIN
7: fnd_file.put_line(fnd_file.output,null);
8: fnd_file.put_line(fnd_file.output,'P11D PDF Output Report');
9: fnd_file.put_line(fnd_file.output,rpad('File No',9) ||
10: rpad('Request ID',21) ||
11: rpad('File Name',21) ||
4: PROCEDURE write_header
5: IS
6: BEGIN
7: fnd_file.put_line(fnd_file.output,null);
8: fnd_file.put_line(fnd_file.output,'P11D PDF Output Report');
9: fnd_file.put_line(fnd_file.output,rpad('File No',9) ||
10: rpad('Request ID',21) ||
11: rpad('File Name',21) ||
12: rpad('P11D Per File',16));
5: IS
6: BEGIN
7: fnd_file.put_line(fnd_file.output,null);
8: fnd_file.put_line(fnd_file.output,'P11D PDF Output Report');
9: fnd_file.put_line(fnd_file.output,rpad('File No',9) ||
10: rpad('Request ID',21) ||
11: rpad('File Name',21) ||
12: rpad('P11D Per File',16));
13: fnd_file.put_line(fnd_file.output,rpad('-',8,'-') || ' ' ||
9: fnd_file.put_line(fnd_file.output,rpad('File No',9) ||
10: rpad('Request ID',21) ||
11: rpad('File Name',21) ||
12: rpad('P11D Per File',16));
13: fnd_file.put_line(fnd_file.output,rpad('-',8,'-') || ' ' ||
14: rpad('-',20,'-') || ' ' ||
15: rpad('-',20,'-') || ' ' ||
16: rpad('-',15,'-'));
17: END;
21: p_file_name varchar2,
22: p_size number)
23: IS
24: BEGIN
25: fnd_file.put_line(fnd_file.output,rpad(p_file_no,9) ||
26: rpad(p_request_id,21) ||
27: rpad(p_file_name,21) ||
28: rpad(p_size,16));
29: END write_body;
30:
31: PROCEDURE write_footer(p_total number)
32: IS
33: BEGIN
34: fnd_file.put_line(fnd_file.output,' ');
35: fnd_file.put_line(fnd_file.output,rpad('Total P11D PDF Produced',51) ||
36: rpad(p_total,16));
37: END;
38:
31: PROCEDURE write_footer(p_total number)
32: IS
33: BEGIN
34: fnd_file.put_line(fnd_file.output,' ');
35: fnd_file.put_line(fnd_file.output,rpad('Total P11D PDF Produced',51) ||
36: rpad(p_total,16));
37: END;
38:
39: PROCEDURE print_pdf(errbuf out NOCOPY VARCHAR2,