DBA Data[Home] [Help]

APPS.PON_FBO_PKG dependencies on FND_LOBS

Line 600: fnd_lobs fl,

596: FOR temp IN (SELECT fl.file_name as filename,ENCODE_BLOB(fl.file_data) as filedata,
597: fl.file_name as description
598: FROM fnd_attached_documents fad,
599: fnd_documents_vl fdvl,
600: fnd_lobs fl,
601: fnd_document_categories doccat
602: WHERE fad.document_id = fdvl.document_id
603: and fdvl.category_id = doccat.category_id
604: and doccat.name = l_doccat_name

Line 776: fnd_lobs fl,

772: FOR temp IN (SELECT fl.file_name as filename,ENCODE_BLOB(fl.file_data) as filedata,
773: fl.file_name as description
774: FROM fnd_attached_documents fad,
775: fnd_documents_vl fdvl,
776: fnd_lobs fl,
777: fnd_document_categories doccat
778: WHERE fad.document_id = fdvl.document_id
779: and fdvl.category_id = doccat.category_id
780: and doccat.name = 'ToFedBizOppsSecure'

Line 888: FROM fnd_Lobs fl WHERE file_Id =

884: files_clob := '';
885:
886: SELECT fl.file_name, ENCODE_BLOB(fl.file_data)
887: INTO l_pdfname, l_pdfdata
888: FROM fnd_Lobs fl WHERE file_Id =
889: (SELECT file_id FROM pon_action_History
890: WHERE object_id = p_auction_header_id
891: AND ACTION_TYPE='STORE_CLM_PDF'
892: AND ROWNUM < 2 );

Line 923: fnd_lobs fl,

919: FOR temp IN ( SELECT fl.file_name as filename,ENCODE_BLOB(fl.file_data) as filedata,
920: fl.file_name as description
921: FROM fnd_attached_documents fad,
922: fnd_documents_vl fdvl,
923: fnd_lobs fl,
924: fnd_document_categories doccat
925: WHERE fad.document_id = fdvl.document_id
926: and fdvl.category_id = doccat.category_id
927: and doccat.name in ('ToFedBizOpps','Vendor')