EXEC m_api_doc.set_login_env('RS','DOC_IMPORT');
DECLARE
v_doc_source m_doc_imports.doc_source%TYPE := 'SPF';
v_mode_ind m_doc_imports.process_type_ind%TYPE := 'A';
v_doc_name m_doc_imports.docu_code%TYPE := 'SPF_6';
v_revision m_doc_imports.revision%TYPE := '0';
v_path_type m_doc_imports.path_type%TYPE:= 'P';
v_client_ref m_doc_imports.client_ref%TYPE := '';
v_partner_ref m_doc_imports.partner_ref%TYPE := '';
v_list_of_units m_doc_imports.list_of_units%TYPE := '' ;
v_material_code m_doc_imports.material_code%TYPE := '';
v_list_of_tags m_doc_imports.list_of_tags%TYPE := '';
v_doc_type m_doc_imports.docu_type%TYPE := '3D Documents';
n_number_of_pages m_doc_imports.number_of_pages%TYPE := 1;
v_status m_doc_imports.status%TYPE := 'STA';
v_author m_doc_imports.author%TYPE := 'Autor';
d_creation_date m_doc_imports.creation_date%TYPE := '05-OCT-2014' ;
v_authorized_by m_doc_imports.authorized_by%TYPE := '';
d_authorization_date m_doc_imports.authorization_date%TYPE :='11-10-2014';
v_changed_by m_doc_imports.changed_by%TYPE := '';
d_changed_date m_doc_imports.changed_date%TYPE := sysdate;
v_docu_format m_doc_imports.docu_format%TYPE := 'PDF';
v_comments m_doc_imports.comments%TYPE := 'comment';
v_reference_module m_doc_imports.reference_module%TYPE := '';
v_file_name m_doc_imports.file_name%TYPE := '';
v_source_path m_doc_imports.source_path%TYPE := '';
v_std_code m_doc_imports.std_code%TYPE := '';
v_src_code m_doc_imports.src_code%TYPE := '';
v_origin_code m_doc_imports.origin_code%TYPE := '';
v_directa_class m_doc_imports.directa_class%TYPE := '';
v_directa_docu_type m_doc_imports.directa_docu_type%TYPE := '';
v_obid m_doc_imports.directa_docu_type%TYPE := '';
v_spf_uid m_doc_imports.spf_uid%TYPE := '636';
v_spf_revision m_doc_imports.spf_revision%TYPE := '2';
v_spf_version m_doc_imports.spf_version%TYPE := '1';
v_spf_version_date m_doc_imports.spf_version_date%TYPE:='20140125';--RRRRMMDD;
v_spf_version_UID m_doc_imports.spf_version_UID%TYPE := 'VERGUID_098456457';
v_spf_category m_doc_imports.spf_category%TYPE := '3D';
v_spf_subtype m_doc_imports.spf_subtype%TYPE := 'SUBTYPE';
v_spf_title m_doc_imports.spf_title%TYPE := 'Document Title';
v_spf_plant m_doc_imports.spf_plant%TYPE := 'PLANT A';
v_spf_project m_doc_imports.spf_project%TYPE := '';
v_short_desc m_doc_imports.short_desc%TYPE := 'Short Desc 20';
v_description m_doc_imports.description%TYPE := 'Longer description';
BEGIN
m_api_doc.insert_document ( v_doc_source
, v_mode_ind
, v_doc_name
, v_revision
, v_path_type
, v_client_ref
, v_partner_ref
, v_list_of_units
, v_material_code
, v_list_of_tags
, v_doc_type
, n_number_of_pages
, v_status
, v_author
, d_creation_date
, v_authorized_by
, d_authorization_date
, v_changed_by
, d_changed_date
, v_docu_format
, v_comments
, v_reference_module
, v_file_name
, v_source_path
, v_std_code
, v_src_code
, v_origin_code
, v_directa_class
, v_directa_docu_type
, v_obid
, v_spf_uid
, v_spf_revision
, v_spf_version
, v_spf_version_date
, v_spf_version_UID
, v_spf_category
, v_spf_subtype
, v_spf_title
, v_spf_plant
, v_spf_project
, v_short_desc
, v_description
);
m_api_doc.process_doc_import ('RS', 'SPF', 'N');
END;