Search Results delete_f_ltctl_id

Overview

ARP_CTL_PKG is a PL/SQL control package in the Oracle E-Business Suite Receivables (AR) module, owned by the APPS schema. Its name—derived from "AR" and "Control"—reflects its role as a low-level repository access layer for the RA_CUSTOMER_TRX_LINES entity, which stores the individual transaction lines that make up an invoice, debit memo, credit memo, or on-account credit. Rather than implementing a formal, published business API with validation and workflow semantics, ARP_CTL_PKG exposes a set of tightly scoped procedures for fetching, locking, inserting, updating, deleting, and displaying customer transaction line records. It is best characterized as an internal pl/sql construct that higher-level Receivables APIs, forms, and concurrent programs call to perform the physical row operations against the transaction line table. The header comment (120.6, last modified 2005) indicates the package has been stable across many releases and is inherited unchanged into 12.1.1 and 12.2.2.

Key Procedures and Functions

The 24 documented procedures fall into logical groups:

• Fetch and display: FETCH_P, DISPLAY_LINE_P, DISPLAY_LINE_REC, DISPLAY_LINE_F_LCTL_ID, and DISPLAY_LINE_F_CT_ID retrieve a full RA_CUSTOMER_TRX_LINES%ROWTYPE record for a given line, by customer_trx_id, or by link_to_cust_trx_line_id. DISPLAY_LINE_REC and its siblings format a line record for diagnostic output. SET_TO_DUMMY initializes a line record with empty/default values.
• Locking: LOCK_P, LOCK_F_CT_ID, LOCK_FETCH_P, and LOCK_COMPARE_P provide row-level concurrency control, selecting a line FOR UPDATE and optionally comparing the caller's copy against the database copy before proceeding.
• Deletion: DELETE_P removes a single line; DELETE_F_CT_ID removes all lines for a transaction; DELETE_F_LTCTL_ID removes lines by link_to_cust_trx_line_id; DELETE_F_CT_LTCTL_ID_TYPE combines transaction id, link id, and line_type filters.
• Update: UPDATE_P (single line, optional currency), UPDATE_F_CT_ID (all lines of a transaction), UPDATE_AMOUNT_F_CTL_ID and UPDATE_CM_AMOUNT_F_CTL_ID adjust line amounts for a given customer_trx_line_id—the latter specifically for credit memo amounts.
• Insert and merge: INSERT_P creates a new line row, while MERGE_LINE_RECS consolidates or reconciles line records.

The user-searched procedure, UPDATE_F_CT_ID, updates all customer transaction lines belonging to a specified customer_trx_id, optionally filtered by line_type and currency_code. It is the bulk counterpart to UPDATE_P and is typically invoked when an entire transaction's lines must be rewritten, such as during a copy or adjustment operation.

Tables Accessed

The package operates against the core Receivables transaction tables through APPS synonyms: RA_CUSTOMER_TRX, RA_CUSTOMER_TRX_ALL, RA_CUSTOMER_TRX_LINES, RA_CUSTOMER_TRX_LINES_ALL, and RA_CUSTOMER_TRX_LINES_S (the _ALL and _S variants indicate Multi-Org and security-enabled access used from 11i onward). FND_CURRENCIES supplies valid currency codes for amount updates; AR_MEMO_LINES_B and AR_SYSTEM_PARAMETERS provide memo line and system-parameter defaults; DUAL is used for simple scalar queries; PLITBLM and DBMS_SQL support dynamic SQL and PL/SQL table structures.

Usage Notes

ARP_CTL_PKG is a private implementation utility rather than a public integration API. Its 18 documented callers are almost exclusively other Oracle Receivables packages—such as AutoInvoice and the transaction copy/merge routines—plus Receivables forms that need direct row manipulation where no validated API is appropriate. Customizations should avoid calling ARP_CTL_PKG directly because it bypasses the business logic (accounting, tax, and distribution) enforced by the supported AR APIs; direct use can violate data integrity and is not upgrade-safe across 12.1.1 and 12.2.2.