APPS.PO_PROTESTS_UTIL dependencies on FND_LOBS

Line 15: l_file_name fnd_lobs.file_name%TYPE;

11: l_entity_name VARCHAR2(30);
12: seq_num NUMBER;
13: l_category_id NUMBER;
14: l_count NUMBER;
15: l_file_name fnd_lobs.file_name%TYPE;
16: l_file_content_type fnd_lobs.file_content_type%TYPE;
17: l_api_name CONSTANT VARCHAR2(25) := 'Store_Blob';
18: l_progress VARCHAR2(3);
19: p_blob_type VARCHAR2(4);

Line 16: l_file_content_type fnd_lobs.file_content_type%TYPE;

12: seq_num NUMBER;
13: l_category_id NUMBER;
14: l_count NUMBER;
15: l_file_name fnd_lobs.file_name%TYPE;
16: l_file_content_type fnd_lobs.file_content_type%TYPE;
17: l_api_name CONSTANT VARCHAR2(25) := 'Store_Blob';
18: l_progress VARCHAR2(3);
19: p_blob_type VARCHAR2(4);
20: BEGIN

Line 58: -- locator will be inserted into fnd_lobs. If too_many_rows (though should

54: ));
55: EXCEPTION
56: WHEN OTHERS THEN
57: -- do nothing. If no_data_found then x_media_id will be null and a new lob
58: -- locator will be inserted into fnd_lobs. If too_many_rows (though should
59: -- not occur because the locator gets overwritten everytime)
60: -- then the first blob found will be overwritten
61: NULL;
62: END;

Line 99: INSERT INTO fnd_lobs

95: l_file_name, x_media_id);
96:
97: l_progress := '060';
98:
99: INSERT INTO fnd_lobs
100: (file_id,
101: file_name,
102: file_content_type,
103: upload_date,

Line 212: l_filename fnd_lobs.file_name%TYPE;

208: content_type IN VARCHAR2,
209: document IN OUT nocopy BLOB,
210: document_type IN OUT nocopy VARCHAR2)
211: IS
212: l_filename fnd_lobs.file_name%TYPE;
213: l_document_id po_headers_all.po_header_id%TYPE;
214: l_document fnd_lobs.file_data%TYPE;
215: l_document_length NUMBER;
216: l_progress VARCHAR2(300);

Line 214: l_document fnd_lobs.file_data%TYPE;

210: document_type IN OUT nocopy VARCHAR2)
211: IS
212: l_filename fnd_lobs.file_name%TYPE;
213: l_document_id po_headers_all.po_header_id%TYPE;
214: l_document fnd_lobs.file_data%TYPE;
215: l_document_length NUMBER;
216: l_progress VARCHAR2(300);
217: l_filecontent_type fnd_lobs.file_content_type%TYPE;
218: l_message fnd_new_messages.message_text%TYPE;

Line 217: l_filecontent_type fnd_lobs.file_content_type%TYPE;

213: l_document_id po_headers_all.po_header_id%TYPE;
214: l_document fnd_lobs.file_data%TYPE;
215: l_document_length NUMBER;
216: l_progress VARCHAR2(300);
217: l_filecontent_type fnd_lobs.file_content_type%TYPE;
218: l_message fnd_new_messages.message_text%TYPE;
219: BEGIN
220: l_progress := 'PO_PROTESTS_UTIL.zip_attach : Begin';
221:

Line 222: -- Docuement ID passed to this procedure is the file id in the fnd_lobs

218: l_message fnd_new_messages.message_text%TYPE;
219: BEGIN
220: l_progress := 'PO_PROTESTS_UTIL.zip_attach : Begin';
221:
222: -- Docuement ID passed to this procedure is the file id in the fnd_lobs
223: l_document_id := document_id;
224:
225: l_progress := 'PO_PROTESTS_UTIL.zip_attach : Get item attributes';
226:

Line 235: FROM fnd_lobs fl

231: SELECT fl.file_data,
232: fl.file_content_type,
233: fl.file_name
234: INTO l_document, l_filecontent_type, l_filename
235: FROM fnd_lobs fl
236: WHERE fl.file_id = l_document_id;
237: EXCEPTION
238: WHEN OTHERS THEN
239: l_progress := 'PO_PROTESTS_UTIL.zip_attach : no_data_found';