Search Results lock_f_ctls_id

Overview

ARP_CTLGD_PKG is a PL/SQL package body owned by the APPS schema in Oracle E-Business Suite Receivables. Its name reflects its role: it manages control and general-ledger distribution records associated with customer transactions — the rows that populate RA_CUST_TRX_LINE_GL_DIST and related control tables. In the ETRM 12.2.2 metadata, the object is classified as OTHER, indicating it is an internal support package rather than a published public API. Functionally, the package encapsulates insert, update, delete, and locking logic for transaction line distributions, including multi-ledger and reporting-currency handling. It is an integral part of the Receivables transaction accounting engine and is referenced by 14 other database objects, confirming its role as a shared low-level utility rather than an end-user entry point.

Key Procedures and Functions

ETRM documents 28 procedures and functions. The bulk follow a consistent internal naming convention that separates a dispatcher routine from its per-key implementations:

• INSERT_P, UPDATE_P, DELETE_P, LOCK_P — Top-level entry points that route a caller request to the appropriate record-specific routine based on the operations requested.
• LOCK_F_CT_ID, LOCK_F_CTL_ID, LOCK_F_CTLS_ID, LOCK_FETCH_P, LOCK_COMPARE_P, LOCK_COMPARE_COVER — Locking and comparison logic that selects distribution rows for update and verifies whether a locked row still matches the caller's expected values before proceeding.
• UPDATE_F_CT_ID, UPDATE_F_CTL_ID, UPDATE_F_CTLS_ID, UPDATE_ACCTD_AMOUNT, UPDATE_AMOUNT_F_CTL_ID — Update routines keyed by customer transaction ID, distribution ID, or line ID. UPDATE_ACCTD_AMOUNT and UPDATE_AMOUNT_F_CTL_ID specifically maintain the accounted and entered amount columns, including the reporting-currency equivalents.
• DELETE_F_CT_ID, DELETE_F_CTL_ID, DELETE_F_CTLS_ID, DELETE_F_CT_LTCTL_ID_TYPE — Delete routines scoped by transaction, distribution, line, or line type.
• SET_TO_DUMMY — A utility that initialises or nullifies control values.

No parameter lists are published in the metadata; callers should not assume signatures and must rely on the delivering patch level of the package.

Tables Accessed

The package reads and writes the core Receivables distribution schema:

• RA_CUST_TRX_LINE_GL_DIST and its sequence-backed synonym RA_CUST_TRX_LINE_GL_DIST_S — the primary target for inserts, updates, and deletes.
• RA_CUSTOMER_TRX, RA_CUSTOMER_TRX_LINES, RA_CUST_TRX_LINE_SALESREPS — parent transaction and line data, plus salesperson attribution used when deriving distribution rows.
• AR_SYSTEM_PARAMETERS — Receivables system options controlling accounting and rounding behaviour.
• FND_CURRENCIES — currency definitions for entered versus accounted conversion.
• DUAL, DBMS_SQL, PLITBLM — utility access for expression evaluation and single-row selection.

Package-level dependencies include ARP_STANDARD, ARP_UTIL, ARP_GLOBAL, ARP_TRX_UTIL, ARPCURR, AR_MRC_ENGINE, APP_EXCEPTION, GL_CA_UTILITY_PKG, and FND_MESSAGE, which provide error handling, global constants, and multi-org/multiple-reporting-currency support.

Usage Notes

Because ARP_CTLGD_PKG is not exposed through a public API and is not referenced by any database object outside its own dependency chain, it is normally invoked indirectly: through Receivables transaction forms, through AutoAccounting and accounting-generation concurrent programs, and through higher-level PL/SQL utilities such as ARP_TRX_UTIL. Custom extensions should not call its procedures directly, as signatures and internal assumptions may change between patch levels without notice. Where custom code must manipulate distribution rows, the supported approach is to use documented Receivables public APIs and scripts. Diagnostic use of the package is limited to tracing its calls during accounting generation when reconciling distribution amounts, accounting dates, or reporting-currency values in RA_CUST_TRX_LINE_GL_DIST.