1939: BEGIN
1940: If p_report = 'MAIN' then
1941: SELECT file_data
1942: INTO p_pdf_blob
1943: FROM fnd_lobs
1944: WHERE file_id = (SELECT MAX(file_id)
1945: FROM fnd_lobs
1946: WHERE file_name like '%PAY_PRG_ar_AE.pdf');
1947: End If;
1941: SELECT file_data
1942: INTO p_pdf_blob
1943: FROM fnd_lobs
1944: WHERE file_id = (SELECT MAX(file_id)
1945: FROM fnd_lobs
1946: WHERE file_name like '%PAY_PRG_ar_AE.pdf');
1947: End If;
1948: EXCEPTION
1949: when no_data_found then