1832: BEGIN
1833: If p_report = 'MAIN' then
1834: SELECT file_data
1835: INTO p_pdf_blob
1836: FROM fnd_lobs
1837: WHERE file_id = (SELECT MAX(file_id)
1838: FROM fnd_lobs
1839: WHERE file_name like '%PAY_PRG_ar_KW.pdf');
1840: /* Else
1834: SELECT file_data
1835: INTO p_pdf_blob
1836: FROM fnd_lobs
1837: WHERE file_id = (SELECT MAX(file_id)
1838: FROM fnd_lobs
1839: WHERE file_name like '%PAY_PRG_ar_KW.pdf');
1840: /* Else
1841: SELECT file_data
1842: INTO p_pdf_blob
1839: WHERE file_name like '%PAY_PRG_ar_KW.pdf');
1840: /* Else
1841: SELECT file_data
1842: INTO p_pdf_blob
1843: FROM fnd_lobs
1844: WHERE file_id = (SELECT MAX(file_id)
1845: FROM fnd_lobs
1846: WHERE file_name like '%PAY_PRG_SUMMARY_ar_KW.pdf');*/
1847: End If;
1841: SELECT file_data
1842: INTO p_pdf_blob
1843: FROM fnd_lobs
1844: WHERE file_id = (SELECT MAX(file_id)
1845: FROM fnd_lobs
1846: WHERE file_name like '%PAY_PRG_SUMMARY_ar_KW.pdf');*/
1847: End If;
1848: EXCEPTION
1849: when no_data_found then