APPS.CSE_FA_STAGE_PKG dependencies on FND_LOBS

Line 430: --FND_LOBS Table

426: END LOOP;
427: END report_output;
428:
429: --For bug 14480337 Modified the procedure to get the CLOB from the
430: --FND_LOBS Table
431: PROCEDURE get_report_clob (
432: p_document_id IN varchar2,
433: p_display_type IN varchar2,
434: x_document IN OUT NOCOPY clob,

Line 464: FROM fnd_lobs

460: ,file_data
461: INTO filename
462: ,content_type
463: ,bdoc
464: FROM fnd_lobs
465: WHERE program_name = 'CSEFANOTIFY'
466: AND program_tag = v_request_id
467: AND expiration_date > SYSDATE;
468:

Line 469: --Convert the blob stored in FND_LOBS to clob

465: WHERE program_name = 'CSEFANOTIFY'
466: AND program_tag = v_request_id
467: AND expiration_date > SYSDATE;
468:
469: --Convert the blob stored in FND_LOBS to clob
470: x_document_type := content_type || ';name=' || filename;
471: dest_lob := BLOB_TO_CLOB(bdoc);
472: dbms_lob.copy(x_document, dest_lob, dbms_lob.getlength(bdoc));
473: EXCEPTION

Line 599: --FND_LOBS Table

595:
596: END send_mail;
597:
598: --For bug 14480337 Modified the procedure to store the CLOB in
599: --FND_LOBS Table
600: PROCEDURE notify_users(
601: errbuf OUT NOCOPY VARCHAR2,
602: retcode OUT NOCOPY NUMBER)
603: IS

Line 621: SELECT fnd_lobs_s.NEXTVAL INTO l_fid FROM DUAL;

617: report_output;
618:
619: l_request_id := fnd_global.conc_request_id;
620:
621: SELECT fnd_lobs_s.NEXTVAL INTO l_fid FROM DUAL;
622: l_file_name := l_program_name || '_' || l_request_id || '.out';
623: l_program_tag := l_request_id;
624:
625: --Convert the clob to blob to store it in the table FNB_LOBS

Line 628: INSERT INTO fnd_lobs (

624:
625: --Convert the clob to blob to store it in the table FNB_LOBS
626: l_blob := Clob_to_blob(g_clob);
627:
628: INSERT INTO fnd_lobs (
629: file_id,
630: file_name,
631: file_content_type,
632: upload_date,