Search Results get_write_ptr

Overview

OKC_ARTWF_PVT is a private (PVT) PL/SQL package in the Oracle E-Business Suite Applications (APPS) schema that supports the Oracle Contracts (OKC) module's article and terms-template workflow processing. Its header, dated 2006, defines the interface used by the article import and workflow subsystems. The package acts as a supporting engine for launching Oracle Workflow processes, evaluating article status, and managing notifications associated with article adoption across organizations. Because it is classified as a private package, it is not part of the public API surface and must not be called directly from customer extensions; it is invoked internally by other OKC modules and by the article import workflow.

Key Procedures and Functions

The documented routines fall into several functional clusters:

Workflow integration: START_WF_AFTER_IMPORT initiates workflow processing after an article import batch completes; START_WF_PROCESSES and START_WF_PROCESS launch one or more workflow processes for articles; SET_NOTIFICATION, SET_APPROVER, SET_NOTIFIED_LIST, and SET_NOTIFIED populate workflow notification attributes and approver/recipient lists.
Status and selector logic: CHECK_STATUS evaluates the status of a specific article version and returns a result code with message count/data; SELECTOR and SELECT_PROCESS contain the workflow selector logic that determines which process should be started.
Meaning lookups: GET_PENDING_MEANING and GET_ADOPTED_MEANING translate status/adoption codes into user-facing meanings.
Diagnostics and buffer management: TEST, PRINT_TAB, and PRINT_ERR are explicitly marked for testing use only and should not be invoked from application code. GET_WRITE_PTR, GET_ERROR_PTR, GET_TAB, and GET_ERR expose pointer-based access to internal write and error buffers, allowing callers to iterate cached article rows and error rows.
Housekeeping: CLEAN resets internal buffers.

Parameter lists are deliberately omitted here; refer to the package header for exact signatures.

Tables Accessed

The package reads and writes core Contracts and Workflow tables through APPS synonyms. Article data is stored in OKC_ARTICLES_ALL and OKC_ARTICLE_VERSIONS, with adoption details in OKC_ARTICLE_ADOPTIONS and import staging in OKC_ART_INTERFACE_ALL. Terms template metadata is read from OKC_TERMS_TEMPLATES_ALL. Organization context is resolved through HR_ALL_ORGANIZATION_UNITS, HR_ALL_ORGANIZATION_UNITS_TL, and HR_ORGANIZATION_INFORMATION. Workflow state and notifications are managed via WF_ITEMS, WF_NOTIFICATIONS, and WF_NOTIFICATION_ATTRIBUTES. User information is obtained from FND_USER, with messages from FND_NEW_MESSAGES. DBMS_LOB and DBMS_UTILITY provide large-object and utility support. OKC_ARTWF_PVT is itself referenced by one other package, indicating it sits in a layered call chain rather than at the top of the stack.

Usage Notes

OKC_ARTWF_PVT is a private package and its procedures are called from within Oracle's own OKC code — typically from the article import concurrent program and from workflow function activities. It should never be called directly from customer forms or custom concurrent programs. The procedures TEST, PRINT_TAB, and PRINT_ERR exist only for internal diagnostics and are explicitly documented as unsuitable for application use. Implementers extending Contracts workflow behavior should rely on the documented public OKC APIs rather than this package.