Search Results notification_header_function

Overview

OKC_BUS_DOC_TYPES_V is a seeded, VALID view in the APPS schema that exposes the metadata definitions of business document types used throughout Oracle Contracts Core (OKC). A business document type describes the behavioral template of a contract-related document — for example, a purchase agreement, a sales contract, or a subscription — and controls how that document type is rendered, amended, previewed, and surfaced in the Contracts workbench. The view is not a transactional object; it is a reference and configuration view consumed by the Contracts forms, the Contracts Workbench (OKC), and integrations that need to enumerate the document types available to a responsibility or user.

The view exists primarily to join the base table to its translation table so that the NAME presented to the user is returned in the session language. Because it exposes flags such as SHOW_IN_WORKBENCH_FLAG, it is the canonical source used by the Workbench UI to decide which document types appear as selectable tiles or list entries.

Underlying Base Objects

Per the documented ETRM metadata, the view is defined over two base objects, exposed to APPS through synonyms:

• OKC_BUS_DOC_TYPES_B — the base (non-translated) table holding all functional attributes of a business document type, including the internal DOCUMENT_TYPE code, the DOCUMENT_TYPE_CLASS, intent, preview and details functions, and the SHOW_IN_WORKBENCH_FLAG.
• OKC_BUS_DOC_TYPES_TL — the translation table, holding the language-specific NAME, LANGUAGE, and SOURCE_LANG columns.

The two are joined on DOCUMENT_TYPE, with the TL side additionally restricted by LANGUAGE = USERENV('LANG'), so the view returns exactly one row per document type, translated into the caller's session language.

Key Columns

• ROW_ID, DOCUMENT_TYPE, OBJECT_VERSION_NUMBER — surrogate row identifier, the internal document type code, and the optimistic locking version.
• NAME, LANGUAGE, SOURCE_LANG — translated display name and language attributes from OKC_BUS_DOC_TYPES_TL.
• INTENT, DOCUMENT_TYPE_CLASS, PROVISION_ALLOWED_YN — classification and whether provisioning is permitted.
• SHOW_IN_WORKBENCH_FLAG — the column most commonly searched: when set to 'Y', the document type is eligible to be displayed in the Contracts Workbench. This is a primary filter for Workbench-driven queries.
• SHOW_IN_LOV_YN, SHOW_PREVIEW_BTN_YN, SHOW_EXT_VAR_FLAG, SHOW_AUTH_PARTY_FLAG — UI and behavior toggles controlling list-of-values visibility, preview button rendering, extensible variable display, and authorized party display.
• DOC_PREVIEW_FUNCTION, DOC_VIEW_DETAILS_FUNCTION, NOTIFICATION_HEADER_FUNCTION, CONTRACT_TERMS_FUNCTION — names of the PL/SQL functions that implement preview, detail, notification header, and contract terms behavior.
• ENABLE_AMEND_SUMMARY_YN, DISABLE_AMEND_YN, ENABLE_DELIVERABLES_YN, ENABLE_ATTACHMENTS_YN, ENABLE_CONTRACT_TERMS_YN, ENABLE_ATTACHED_DOC_FLAG — feature enablement flags.
• APPLICATION_ID, EXTERNAL_USERLIST_PROC, TARGET_RESPONSE_DOC_TYPE, VARIABLE_RESOLUTION_AM, START_DATE, END_DATE — ownership, external sourcing, response linkage, variable resolution, and effective dating.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard audit columns inherited from the base table.

Common Use Cases and Queries

The most frequent use of this view is to list the document types enabled for the workbench, or to obtain the display name of a given document type for a report or integration.

SELECT document_type, name, intent, document_type_class
  FROM apps.okc_bus_doc_types_v
 WHERE show_in_workbench_flag = 'Y'
 ORDER BY name;

To resolve a single document type's name and preview function in an integration or concurrent program:

SELECT name, doc_preview_function, contract_terms_function
  FROM apps.okc_bus_doc_types_v
 WHERE document_type = :p_document_type
   AND SYSDATE BETWEEN NVL(start_date, SYSDATE)
                   AND NVL(end_date, SYSDATE);

To identify types available for a specific class, such as purchase agreements, use DOCUMENT_TYPE_CLASS and APPLICATION_ID as filters. Because the view is language-aware, its results vary with USERENV('LANG'); reports that must be language-independent should join the base table OKC_BUS_DOC_TYPES_B directly or specify the desired LANGUAGE. Query performance is generally good, as the view is a simple equijoin with no aggregation or union operations.