DBA Data[Home] [Help]

APPS.OKC_REP_SEARCH_UTIL_PVT dependencies on OKC_BUS_DOC_TYPES_VL

Line 670: -- there is no entry in okc_bus_doc_types_vl for that doc type code),

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

Line 676: FROM okc_bus_doc_types_vl

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.