Results for “cn_post_collection_tae_pub”

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

Overview

CN_POST_COLLECTION_TAE_PUB is a public PL/SQL package body in the Oracle EBS Trade Management (formerly Oracle Contracts) application, owned by the APPS schema. Its name indicates its role: it supports the posting of collection activity associated with Trade Accounting Engine (TAE) processing. TAE is the subsystem that converts trade and contract events into accounting distributions and accrual entries. This package provides a programmatic interface through which callers can retrieve the assignment data that TAE uses to determine which accounting programs and usage assignments apply to a given trade transaction over a specified period range. It is classified as a PUB package in the ETRM metadata, meaning it is intended to be a publicly callable API, and it exposes exactly one documented procedure, GET_ASSIGNMENTS. The source header identifies the file as cnppcolb.pls at version 120.8.12000000.2.

Key Procedures and Functions

The package body exposes a single public API, get_assignments. Per the inline API comments, this public procedure is used to retrieve TAE assignments. It returns the caller a period range (a start period and an end period), a concurrent program identifier, and the standard Oracle EBS API output parameters for return status, message count, and message data. The procedure also accepts an operating unit identifier, consistent with multi-org enabled Trade Management data. In keeping with Oracle's API conventions, the procedure declares local API name and API version constants, initializes the message stack using the FND_API utilities, and follows the standard IN/OUT parameter discipline. The metadata confirms GET_ASSIGNMENTS as the sole documented procedure in the package; no other public entry points are recorded.

Tables Accessed

The documented table reference for this package is JTY_TRANS_USG_PGM_SQL, accessed through an APPS synonym. This is a Trade Management table that stores SQL definitions associated with transaction usage programs. Within the TAE context, the package queries this table to resolve the assignment of usage programs for a transaction so that the correct accounting program SQL is identified and returned to the caller. No additional tables are documented in the ETRM metadata; the package relies on FND_API and FND_GLOBAL utilities for message handling and session context (user ID, login ID, and timestamps) rather than on direct base-table DML.

Usage Notes

Because this is a PUB-classified API, it is intended to be invoked from custom PL/SQL code, Oracle Forms, or concurrent programs that need to determine TAE assignment information before posting collections. A typical caller supplies the API version, optional initialization and commit flags, a validation level, and the organization ID, and receives back the start and end period IDs, the concurrent program ID, and the standard API return status and message stack. Callers should always check x_return_status for FND_API.G_RET_STS_SUCCESS and inspect the message stack on error. The package is referenced by zero other packages according to the metadata, indicating that it is a leaf-level API called directly rather than a shared internal utility. As with all Oracle EBS public APIs, it should be called with a correctly initialized FND_GLOBAL session (application, responsibility, and user) so that the organization context and audit columns resolve properly. The documented interface is stable across Oracle EBS 12.1.1 and 12.2.2, and the source revision pre-dates the 12.2 online patching model, so no editioning-specific behavior is expected at the API level.