Results for “get_acn_type”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

OKC_QUEUE_PVT is a private (PVT) PL/SQL package body owned by APPS within the Oracle E-Business Suite Contracts (OKC) module. It serves as an internal infrastructure component responsible for resolving the Advanced Queuing (AQ) names used by the Contracts event and outcome messaging framework. During package initialization, the body calls FND_INSTALLATION.GET_APP_INFO to retrieve the installation schema for the OKC product, then constructs the fully qualified queue names OKC_AQ_EV_QUEUE (event queue) and OKC_AQ_OC_QUEUE (outcome queue) by prefixing the schema name. These package-level variables, EVENT_QUEUE_NAME and OUTCOME_QUEUE_NAME, allow other Contracts components to enqueue and dequeue messages without hard-coding schema-qualified queue names. The package also exposes a utility function, GET_ACN_TYPE, that supports rule-based subscription processing by resolving the action type associated with a given correlation identifier. The package carries a header of $Header: OKCRQUEB.pls 120.0 2005/25/25, indicating it is a legacy, fairly stable piece of the Contracts architecture that predates the 12.x releases but remains in use across 12.1.1 and 12.2.2.

Key Procedures and Functions

• GET_ACN_TYPE — A function that accepts a correlation identifier (p_corrid) and returns the corresponding action type (acn_type) as a VARCHAR2. It is explicitly documented in the source as being used to resolve rule-based subscriptions. The function opens an explicit cursor over OKC_ACTIONS_B filtered by the correlation value, fetches a single row, and returns the ACN_TYPE. It is a read-only lookup whose stated purpose is to translate a subscription correlation into the action type needed by the subscription engine.

Tables Accessed

• OKC_ACTIONS_B — The base table for contract actions. GET_ACN_TYPE issues a SELECT of the ACN_TYPE column from this table, filtered by the CORRELATION column, to map a correlation identifier to an action type. No inserts, updates, or deletes are performed; the package is strictly read-only against this table.

Usage Notes

The package variable initialization runs automatically the first time any program unit in the package is referenced, so the queue-name variables are set as a side effect of invoking GET_ACN_TYPE or by direct reference to EVENT_QUEUE_NAME / OUTCOME_QUEUE_NAME. The queue names follow the fully qualified form schema.OKC_AQ_EV_QUEUE and schema.OKC_AQ_OC_QUEUE, where schema is the OKC installation schema returned by FND_INSTALLATION.GET_APP_INFO. GET_ACN_TYPE is typically called from rule-based subscription processing logic within the Contracts module, where a subscription is recorded against a correlation value and the action type must be determined programmatically. Because it is classified as a PVT (private) API, it is not intended for direct invocation by external integrations or customer extensions; it is a supporting routine used by other Contracts packages. The reference count of 20 dependent packages confirms it is widely consumed inside the OKC code base. When debugging subscription or queue behavior in 12.1.1 or 12.2.2, note that GET_ACN_TYPE returns the literal string 'Not Available' both when no matching correlation row is found and when any unexpected exception occurs, so callers cannot distinguish a genuine absence of data from an error condition based on its return value alone.