Search Results cn_payment_transactions




Overview
Explore in AI Chat

Overview

CN_PMT_TRANS_PKG is the Oracle E-Business Suite package responsible for managing payment transaction records within the Channel Revenue Management (formerly Trade Management) module, specifically in the incentive compensation and payee settlement functional area. The package body resides in the APPS schema and carries the class designation OTHER, indicating it is an internal programmatic utility rather than a published, externally supported API. Its principal purpose is to create, maintain, and delete rows in the CN_PAYMENT_TRANSACTIONS table, which stores the individual payment transactions that link commission lines to payrun processing. The current shipped version carries the header identifier cntpmtrb.pls 120.9.12000000.2, reflecting a maintenance level dated June 2007; the file has remained stable across the 12.1.1 and 12.2.2 releases.

Key Procedures and Functions

  • INSERT_RECORD — Inserts a new payment transaction row into CN_PAYMENT_TRANSACTIONS. The procedure accepts a record of type PMT_TRANS_REC_TYPE and, per the source excerpt, first obtains a unique identifier through the internal GET_UID helper before performing the insert. The source comment documents that it is called from cnvpmtrb.pls, the manual transaction creation path.
  • DELETE_RECORD — Removes a payment transaction from CN_PAYMENT_TRANSACTIONS. This supports reversal of manual or system-generated payment transactions when a transaction is no longer required.
  • GET_PMT_TRAN_ID — Returns a payment transaction identifier to the caller. This is the publicly callable counterpart to the private GET_UID routine, and it is this function that external packages reference when they need a primary key value before building their own insert or update logic.

The package additionally contains a private GET_UID procedure, not exposed in the documented public interface, which fetches the next value from the CN_PAYMENT_TRANSACTIONS_S sequence and caches it in the package global G_PAYMENT_TRANSACTION_ID. That global was introduced under Bug 3866089 (and its 11.5.8/11.5.10 equivalents) to guarantee that the sequence value generated at ID-acquisition time is the same value later written during the insert, avoiding a historical mismatch between the two steps. The standard audit globals—g_last_updated_by, g_created_by, and g_last_update_login—are populated from FND_GLOBAL at package initialization.

Tables Accessed

The package reads and writes CN_PAYMENT_TRANSACTIONS and draws its sequence values from CN_PAYMENT_TRANSACTIONS_S. Its row construction requires context supplied by the surrounding incentive compensation data model, which the package and its callers reference: CN_COMMISSION_LINES (the commission detail rows being settled), CN_PAYRUNS_ALL (the payrun to which transactions belong), CN_QUOTAS_ALL, CN_QUOTA_PAY_ELEMENTS and CN_QUOTA_PAY_ELEMENTS_ALL (quota and pay element definitions that determine payable amounts), CN_REPOSITORIES and CN_REPOSITORIES_ALL (the repository that owns the transaction), CN_SRP_PAYEE_ASSIGNS_ALL (payee assignment for the sales representative), CN_SRP_PERIODS (the compensation period), and DUAL for sequence selection. All access is through APPS synonyms.

Usage Notes

CN_PMT_TRANS_PKG is invoked programmatically rather than through a dedicated form or concurrent program. The source explicitly records the manual transaction path via cnvpmtrb.pls, meaning the package is driven whenever a user creates a manual payment transaction in the Channel Revenue Management compensation UI, and it is likewise called during automated payment processing. Because the ETRM metadata records five other packages referencing CN_PMT_TRANS_PKG, it functions as a low-level service layer for transaction ID allocation and row maintenance. Customizations should prefer GET_PMT_TRAN_ID over direct sequence access so that the package’s caching behaviour is preserved. As an OTHER-classified object, the package is not covered by Oracle’s public API compatibility guarantee and may change between releases without notice.