[Home] [Help]
624: BEGIN
625: IF (p_report='CHQR') THEN
626: Select file_data
627: Into p_pdf_blob
628: From fnd_lobs
629: Where file_id = (select max(file_id) from fnd_lobs where file_name like '%PAY_CHQ_ar_SA.rtf');
630: END IF;
631:
632: EXCEPTION
625: IF (p_report='CHQR') THEN
626: Select file_data
627: Into p_pdf_blob
628: From fnd_lobs
629: Where file_id = (select max(file_id) from fnd_lobs where file_name like '%PAY_CHQ_ar_SA.rtf');
630: END IF;
631:
632: EXCEPTION
633: when no_data_found then