APPS.PO_CLOSEOUT_PVT dependencies on FND_LOBS

Line 4489: l_filename fnd_lobs.file_name%TYPE;

4485: d_module CONSTANT VARCHAR2(2000) := d_pkg_name || '.' || 'get_closeout_pdf';
4486: d_position NUMBER;
4487:
4488: l_document_length NUMBER;
4489: l_filename fnd_lobs.file_name%TYPE;
4490: l_filecontent_type fnd_lobs.file_content_type%TYPE;
4491: l_document fnd_lobs.file_data%TYPE;
4492:
4493:

Line 4490: l_filecontent_type fnd_lobs.file_content_type%TYPE;

4486: d_position NUMBER;
4487:
4488: l_document_length NUMBER;
4489: l_filename fnd_lobs.file_name%TYPE;
4490: l_filecontent_type fnd_lobs.file_content_type%TYPE;
4491: l_document fnd_lobs.file_data%TYPE;
4492:
4493:
4494: BEGIN

Line 4491: l_document fnd_lobs.file_data%TYPE;

4487:
4488: l_document_length NUMBER;
4489: l_filename fnd_lobs.file_name%TYPE;
4490: l_filecontent_type fnd_lobs.file_content_type%TYPE;
4491: l_document fnd_lobs.file_data%TYPE;
4492:
4493:
4494: BEGIN
4495:

Line 4515: FND_LOBS L,

4511: -- Obtain the BLOB version of the document
4512: SELECT l.FILE_NAME, l.FILE_CONTENT_TYPE, l.FILE_DATA
4513: INTO l_filename, l_filecontent_type, l_document
4514: FROM
4515: FND_LOBS L,
4516: FND_DOCUMENTS D,
4517: FND_ATTACHED_DOCUMENTS A
4518: WHERE D.DOCUMENT_ID = A.DOCUMENT_ID
4519: AND A.ENTITY_NAME = 'PO_CLOSEOUT_DETAILS'