DBA Data[Home] [Help]

APPS.PO_PROTESTS_UTIL dependencies on PO_PROTESTS_UTIL

Line 1: PACKAGE BODY po_protests_util AS

1: PACKAGE BODY po_protests_util AS
2: /* $Header: PO_PROTESTS_UTIL.plb 120.0.12020000.3 2013/02/28 08:09:55 vpeddi noship $ */
3:
4: PROCEDURE Store_zip_blob(p_protest_id NUMBER,
5: x_media_id OUT nocopy NUMBER)

Line 2: /* $Header: PO_PROTESTS_UTIL.plb 120.0.12020000.3 2013/02/28 08:09:55 vpeddi noship $ */

1: PACKAGE BODY po_protests_util AS
2: /* $Header: PO_PROTESTS_UTIL.plb 120.0.12020000.3 2013/02/28 08:09:55 vpeddi noship $ */
3:
4: PROCEDURE Store_zip_blob(p_protest_id NUMBER,
5: x_media_id OUT nocopy NUMBER)
6: IS

Line 220: l_progress := 'PO_PROTESTS_UTIL.zip_attach : Begin';

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:
222: -- Docuement ID passed to this procedure is the file id in the fnd_lobs
223: l_document_id := document_id;
224:

Line 225: l_progress := 'PO_PROTESTS_UTIL.zip_attach : Get item attributes';

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:
227: l_progress := 'PO_PROTESTS_UTIL.zip_attach : Query the Zip blob';
228:
229: --Bug #4865352 - Added a join with fnd_documents and selected media_id from it

Line 227: l_progress := 'PO_PROTESTS_UTIL.zip_attach : Query the Zip blob';

223: l_document_id := document_id;
224:
225: l_progress := 'PO_PROTESTS_UTIL.zip_attach : Get item attributes';
226:
227: l_progress := 'PO_PROTESTS_UTIL.zip_attach : Query the Zip blob';
228:
229: --Bug #4865352 - Added a join with fnd_documents and selected media_id from it
230: BEGIN
231: SELECT fl.file_data,

Line 239: l_progress := 'PO_PROTESTS_UTIL.zip_attach : no_data_found';

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';
240:
241: RAISE;
242: END;
243:

Line 244: l_progress := 'PO_PROTESTS_UTIL.zip_attach : Get blob length';

240:
241: RAISE;
242: END;
243:
244: l_progress := 'PO_PROTESTS_UTIL.zip_attach : Get blob length';
245:
246: l_document_length := dbms_lob.Getlength(l_document);
247:
248: l_progress := 'PO_PROTESTS_UTIL.zip_attach : Copy zip blob';

Line 248: l_progress := 'PO_PROTESTS_UTIL.zip_attach : Copy zip blob';

244: l_progress := 'PO_PROTESTS_UTIL.zip_attach : Get blob length';
245:
246: l_document_length := dbms_lob.Getlength(l_document);
247:
248: l_progress := 'PO_PROTESTS_UTIL.zip_attach : Copy zip blob';
249:
250: dbms_lob.Copy(document, l_document, l_document_length, 1, 1);
251:
252: l_progress := 'PO_PROTESTS_UTIL.zip_attach : Set document type';

Line 252: l_progress := 'PO_PROTESTS_UTIL.zip_attach : Set document type';

248: l_progress := 'PO_PROTESTS_UTIL.zip_attach : Copy zip blob';
249:
250: dbms_lob.Copy(document, l_document, l_document_length, 1, 1);
251:
252: l_progress := 'PO_PROTESTS_UTIL.zip_attach : Set document type';
253:
254: document_type := l_filecontent_type
255: ||'; name='
256: || l_filename;

Line 258: l_progress := 'PO_PROTESTS_UTIL.zip_attach : End';

254: document_type := l_filecontent_type
255: ||'; name='
256: || l_filename;
257:
258: l_progress := 'PO_PROTESTS_UTIL.zip_attach : End';
259: EXCEPTION
260: WHEN OTHERS THEN
261: document_type := 'text/html; name='
262: || l_filename;

Line 317: avalue =>'PLSQLBLOB:PO_PROTESTS_UTIL.ZIP_ATTACH/'||file_id);

313: aname => 'NOTIFICATION_REGION',
314: avalue => 'JSP:/OA_HTML/OA.jsp?OAFunc=PROTEST_NOTIFICATION_REGION&protestId='|| protestid || '&mode=V&protestNotes='|| protestnotes);
315: wf_notification.Setattrtext(nid => l_notification_id,
316: aname => 'ZIP_ATTACHMENT',
317: avalue =>'PLSQLBLOB:PO_PROTESTS_UTIL.ZIP_ATTACH/'||file_id);
318: END IF;
319:
320: COMMIT;
321: EXCEPTION

Line 390: END po_protests_util;

386: Send(l_po_email_performer, from_user, notification_subject, file_id,
387: protest_notes, protest_id);
388: END LOOP;
389: END send_notifications;
390: END po_protests_util;