733: l_datatype_id fnd_documents.datatype_id%TYPE := null;
734: l_category_id fnd_documents.category_id%TYPE := null;
735: l_security_type fnd_documents.security_type%TYPE := null;
736: l_publish_flag fnd_documents.publish_flag%TYPE := null;
737: l_description fnd_documents_vl.description%TYPE := null;
738: l_file_name fnd_documents_vl.file_name%TYPE := null;
739: l_create_doc varchar2(1):= null;
740: --included to fix bug 1903257 End
741: l_title fnd_documents_vl.title%TYPE := null; ---bug 12402550
734: l_category_id fnd_documents.category_id%TYPE := null;
735: l_security_type fnd_documents.security_type%TYPE := null;
736: l_publish_flag fnd_documents.publish_flag%TYPE := null;
737: l_description fnd_documents_vl.description%TYPE := null;
738: l_file_name fnd_documents_vl.file_name%TYPE := null;
739: l_create_doc varchar2(1):= null;
740: --included to fix bug 1903257 End
741: l_title fnd_documents_vl.title%TYPE := null; ---bug 12402550
742:
737: l_description fnd_documents_vl.description%TYPE := null;
738: l_file_name fnd_documents_vl.file_name%TYPE := null;
739: l_create_doc varchar2(1):= null;
740: --included to fix bug 1903257 End
741: l_title fnd_documents_vl.title%TYPE := null; ---bug 12402550
742:
743: --
744: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
745: --
817: select datatype_id,category_id,security_type,
818: publish_flag,media_id,file_name,description , title
819: into l_datatype_id,l_category_id,l_security_type,
820: l_publish_flag,l_media_id,l_file_name,l_description ,l_title ---bug 12402550
821: from fnd_documents_vl where document_id = p_document_id;
822: l_create_doc := 'Y';
823: l_document_id := null;
824: exception
825: when others then