DBA Data[Home] [Help]

APPS.PO_MOD_UTIL_PVT dependencies on FND_LOBS

Line 48: l_file_name fnd_lobs.file_name%type;

44: l_category_id number;
45: l_count number;
46:
47: --
48: l_file_name fnd_lobs.file_name%type;
49: l_file_content_type fnd_lobs.file_content_type%type;
50: l_org_id po_headers_all.org_id%type;
51: l_api_name CONSTANT VARCHAR2(25) := 'Store_Blob';
52: l_progress VARCHAR2(3);

Line 49: l_file_content_type fnd_lobs.file_content_type%type;

45: l_count number;
46:
47: --
48: l_file_name fnd_lobs.file_name%type;
49: l_file_content_type fnd_lobs.file_content_type%type;
50: l_org_id po_headers_all.org_id%type;
51: l_api_name CONSTANT VARCHAR2(25) := 'Store_Blob';
52: l_progress VARCHAR2(3);
53:

Line 126: INSERT INTO fnd_lobs (

122: x_media_id);
123:
124: l_progress := '060';
125:
126: INSERT INTO fnd_lobs (
127: file_id,
128: File_name,
129: file_content_type,
130: upload_date,

Line 255: fnd_lobs fl

251: SELECT file_data,file_content_type
252: from fnd_attached_documents fad,
253: fnd_documents fd,
254: fnd_documents_tl fdl,
255: fnd_lobs fl
256: WHERE fdl.document_id = fad.document_id
257: and fd.document_id= fdl.document_id
258: and fd.media_id = fl.file_id
259: and fl.file_name LIKE l_filename