APPS.PO_COMM_FPDSNG_PVT dependencies on FND_LOBS

Line 693: l_file_name fnd_lobs.file_name%type;

689: p_language_code varchar2) RETURN varchar2 IS
690:
691: l_api_name CONSTANT VARCHAR2(25):= 'getFPDSNGFileName';
692: l_po_number po_headers_all.segment1%type;
693: l_file_name fnd_lobs.file_name%type;
694: l_extension VARCHAR2(15);
695: l_doc_type VARCHAR2(10);
696: l_progress VARCHAR2(3);
697: l_release_num number;

Line 789: l_file_content_type fnd_lobs.file_content_type%type;

785: l_entity_name VARCHAR2(30);
786: Seq_num NUMBER;
787: l_category_id NUMBER;
788:
789: l_file_content_type fnd_lobs.file_content_type%type;
790: l_progress VARCHAR2(3);
791: l_api_name CONSTANT VARCHAR2(25):= 'Store_Blob';
792:
793: Begin

Line 813: FROM fnd_lobs fl,fnd_attached_documents fad

809: BEGIN
810:
811: l_progress := '002';
812: SELECT DISTINCT fl.file_id INTO p_media_id
813: FROM fnd_lobs fl,fnd_attached_documents fad
814: WHERE
815: fad.pk1_value = TO_CHAR(p_document_id) and
816: fad.pk2_value = TO_CHAR(p_revision_number) and
817: fad.entity_name = l_entity_name AND

Line 871: INSERT INTO fnd_lobs (

867: p_file_name,
868: p_media_id);
869:
870: l_progress := '006';
871: INSERT INTO fnd_lobs (
872: file_id,
873: File_name,
874: file_content_type,
875: upload_date,

Line 961: UPDATE fnd_lobs SET file_data = p_result, upload_date = sysdate

957:
958: ELSE
959: l_progress := '006';
960:
961: UPDATE fnd_lobs SET file_data = p_result, upload_date = sysdate
962: WHERE file_id = p_media_id;
963:
964: IF g_debug_stmt THEN
965: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'Data Updated in Table. After', l_progress);