Search Results delete_f_ctls_id

Overview

ARP_CTLGD_PKG (internally identified by the source file header ARTILGDS.pls) is a Receivables control and locking package that manages the ra_cust_trx_line_gl_dist distribution records underpinning Oracle EBS invoice accounting. It supplies the standard Oracle Forms locking and DML contract — lock, fetch, compare, insert, update, delete — for distribution rows keyed by several alternative identifiers: the distribution ID itself, the customer transaction header, the transaction line, and the transaction line salesrep. In the Oracle EBS 12.1.1 and 12.2.2 architectures this package therefore acts as a shared data-access layer used predominantly by the AutoInvoice and Transaction window forms, ensuring that concurrent users cannot silently overwrite distribution rows while preserving the who-columns and the optimistic-locking semantics expected by Oracle Forms.

Key Procedures and Functions

The documented interface comprises 28 procedures. The locking family includes LOCK_P, which locks a distribution row by its primary key; LOCK_F_CT_ID, LOCK_F_CTL_ID, and LOCK_F_CTLS_ID, which lock rows selected by customer transaction, transaction line, and line salesrep respectively, each qualified by account set flag and account class; LOCK_FETCH_P, which re-reads a row for comparison; LOCK_COMPARE_P, which validates that a row has not changed since it was fetched; and LOCK_COMPARE_COVER, which performs a broader comparison across customer transaction, line, salesrep, account class, percent, and amount attributes.

The DML family mirrors the locking family. INSERT_P and UPDATE_P operate on the distribution row identified by its primary key, while UPDATE_F_CT_ID, UPDATE_F_CTL_ID, and UPDATE_F_CTLS_ID update rows by the corresponding transaction, line, or salesrep keys. Specialized update procedures UPDATE_ACCTD_AMOUNT and UPDATE_AMOUNT_F_CTL_ID maintain accounted and functional amounts. The delete family — DELETE_P, DELETE_F_CT_ID, DELETE_F_CTL_ID, DELETE_F_CTLS_ID, and DELETE_F_CT_LTCTL_ID_TYPE — removes distribution rows by primary key, transaction, line, salesrep, or the transaction/line/type combination. SET_TO_DUMMY initializes an OUT record to an empty row image, a conventional Forms pattern for non-queryable blocks.

Tables Accessed

All base tables are reached through APPS synonyms. RA_CUST_TRX_LINE_GL_DIST is the primary subject of the package, holding one accounting distribution line per transaction line, salesrep, and account class, and is read and written by every lock, insert, update, and delete routine. RA_CUST_TRX_LINE_GL_DIST_S is the corresponding sequence for deriving new primary keys during INSERT_P. RA_CUSTOMER_TRX and RA_CUSTOMER_TRX_LINES supply the transaction and line identifiers used by the foreign-key locking and update variants, while RA_CUST_TRX_LINE_SALESREPS provides salesrep attribution used by the CTLS-keyed operations. AR_SYSTEM_PARAMETERS and FND_CURRENCIES are consulted for functional currency and system-level defaults affecting amount storage. DUAL and DBMS_SQL support dynamic SQL and singleton selection used in the comparison and cover logic, and PLITBLM is leveraged for PL/SQL table (index-by) bulk operations.

Usage Notes

ARP_CTLGD_PKG is not a user-invoked API; it is an internal Forms support package. It is typically called from Receivables transaction entry forms (the Transactions window and its distribution blocks) and from AutoInvoice processing, and it is referenced by at least 14 other packages in the APPS schema, indicating its role as a common distribution-maintenance utility. Because the procedures enforce pessimistic row locking before update or delete, customizations that bypass them risk lost updates and inconsistent who-column audit data. The user search term delete_f_ctls_id does not correspond to a documented procedure; the nearest documented entry is DELETE_F_CTLS_ID, which deletes distribution rows by customer transaction line salesrep identifier. Custom code should invoke the DELETE_F_* procedures rather than issuing direct DML against RA_CUST_TRX_LINE_GL_DIST.