Search Results update_amounts_f_ctl_id

Overview

ARP_CTLS_PKG is an Oracle EBS Receivables (AR) PL/SQL package owned by the APPS schema. Its name derives from Accounts Receivable "customer transaction line sales" processing, and its primary business function is to manage the sales credit records associated with invoice and credit memo lines. In Oracle EBS, sales credits determine how revenue and quota are attributed to individual salespersons on a transaction line. Those attributions are stored in the RA_CUST_TRX_LINE_SALESREPS table.

The package encapsulates the standard insert, fetch, update, delete, and lock operations required by the AutoInvoice and Transactions forms when manipulating sales credit assignments. Because the package is classified as OTHER rather than as a published public API, it is intended principally for internal use by Oracle's own forms and concurrent programs rather than as a supported integration interface. Its procedures follow the conventional Oracle Forms server-side pattern: a combined lock-and-fetch, a pure fetch, an update, and a delete, each offered in variants keyed by primary key, by customer transaction line, or by customer transaction.

Key Procedures and Functions

The package exposes 28 documented procedures. The principal groups are:

• SELECT_SUMMARY — accumulates amounts and percentages across sales credit lines for a given transaction or transaction line, supporting summary display and recalculation of totals in both entered and converted (dual/rate) amounts.
• DISPLAY_SALESCREDIT, DISPLAY_SALESCREDIT_REC, DISPLAY_SALESCREDIT_F_CTL_ID — retrieve or format sales credit data for display, either by sales credit identifier, by passing a full RA_CUST_TRX_LINE_SALESREPS record, or by way of the parent customer transaction line identifier.
• SET_TO_DUMMY and GET_NUMBER_DUMMY — initialise a sales credit record to placeholder values and supply a null-safe numeric default, used to prepare empty records in Forms blocks.
• LOCK_P, LOCK_F_CT_ID, LOCK_F_CTL_ID — acquire row-level locks on sales credit data by primary key, by customer transaction identifier, or by transaction line identifier, ensuring concurrent users cannot modify the same records simultaneously.
• LOCK_FETCH_P and LOCK_COMPARE_P — combine locking with record retrieval and compare the fetched record against the client-side copy, optionally ignoring WHO columns, to detect concurrent updates before saving.
• FETCH_P — retrieves a single sales credit record for a given identifier.
• DELETE_P, DELETE_F_CT_ID, DELETE_F_CTL_ID — remove sales credit rows by primary key, by transaction, or by transaction line, with cascading behaviour appropriate to each level.
• UPDATE_P, UPDATE_F_CT_ID, UPDATE_F_CTL_ID, UPDATE_F_PSR_ID, UPDATE_AMOUNTS_F_CTL_ID — persist modified sales credit rows and recalculate distribution amounts tied to the transaction line.

Tables Accessed

The package operates primarily on RA_CUST_TRX_LINE_SALESREPS and its companion table RA_CUST_TRX_LINE_SALESREPS_S, which together hold the sales credit assignments and their translated or secured segments. RA_CUSTOMER_TRX and RA_CUSTOMER_TRX_LINES provide the parent transaction and line context needed for the line-keyed and transaction-keyed operations. RA_CUST_TRX_LINE_GL_DIST is referenced so that distribution accounting and revenue amounts remain consistent with updated sales credits. AR_SYSTEM_PARAMETERS supplies Receivables system options that influence processing behaviour, and FND_CURRENCIES is used for currency conversion and dual-amount handling. DBMS_SQL supports dynamic SQL, and DUAL serves for single-row arithmetic and default lookups.

Usage Notes

ARP_CTLS_PKG is normally invoked from the Oracle EBS Receivables Transactions form (ARXTWMAI and related forms) whenever a user enters, revises, or deletes sales credits on a transaction line, and from AutoInvoice processing that imports sales credit information from external sources. Because the package is not a documented public API and its procedures manipulate core Receivables tables directly, customisations should not call its internal routines; they should instead use supported interfaces such as the AutoInvoice API or the AR Transaction APIs. Where code must reference sales credit records, querying RA_CUST_TRX_LINE_SALESREPS read-only is preferable. The package is referenced by eight other packages within Receivables, confirming its role as an internal service layer. Its presence in a 12.1.1 or 12.2.2 environment should be treated as a dependency of standard forms functionality rather than as a supported extension point.