666: '.');
667: END IF;
668:
669: -- 1. Get the document type. If the type is null (meaning that
670: -- there is no entry in okc_bus_doc_types_vl for that doc type code),
671: -- set the document type to be the document type code. We nest the
672: -- query in its own block in order to catch No Data Found
673: -- exceptions.
674: SELECT name
672: -- query in its own block in order to catch No Data Found
673: -- exceptions.
674: SELECT name
675: INTO l_doc_type
676: FROM okc_bus_doc_types_vl
677: WHERE document_type = p_doc_type_code;
678:
679:
680: -- Append the document type to the attribute list.