1067: BEGIN
1068: IF (p_report='Disability') THEN
1069: SELECT file_data
1070: INTO p_pdf_blob
1071: FROM fnd_lobs
1072: WHERE file_id = (SELECT MAX(file_id)
1073: FROM fnd_lobs
1074: WHERE file_name like '%PER_DIS_ar_KW.pdf');
1075: ELSE
1069: SELECT file_data
1070: INTO p_pdf_blob
1071: FROM fnd_lobs
1072: WHERE file_id = (SELECT MAX(file_id)
1073: FROM fnd_lobs
1074: WHERE file_name like '%PER_DIS_ar_KW.pdf');
1075: ELSE
1076: SELECT file_data
1077: INTO p_pdf_blob
1074: WHERE file_name like '%PER_DIS_ar_KW.pdf');
1075: ELSE
1076: SELECT file_data
1077: INTO p_pdf_blob
1078: FROM fnd_lobs
1079: WHERE file_id = (SELECT MAX(file_id)
1080: FROM fnd_lobs
1081: WHERE file_name like '%PER_CTR_ar_KW.pdf');
1082: END IF;
1076: SELECT file_data
1077: INTO p_pdf_blob
1078: FROM fnd_lobs
1079: WHERE file_id = (SELECT MAX(file_id)
1080: FROM fnd_lobs
1081: WHERE file_name like '%PER_CTR_ar_KW.pdf');
1082: END IF;
1083: EXCEPTION
1084: WHEN NO_DATA_FOUND THEN