Search Results insert_dist_cover

Overview

ARP_INSERT_DIST_COVER is a public PL/SQL package body owned by APPS within the Oracle E-Business Suite Receivables (AR) module. Its documented purpose is to convert a set of column-oriented parameters into a distribution record and insert a corresponding distribution line into the accounting distribution table for a receivables transaction. In effect, the package encapsulates the insert logic for RA_CUST_TRX_LINE_GL_DIST, shielding calling code from the physical column layout of that table.

The package version is recorded in its header as ARTLGDIB.pls 115.7, last shipped 2003/10/27. It is classified as an "OTHER" API and is not referenced by any other documented package, which indicates it is a standalone utility invoked directly by forms or custom integration code rather than a widely shared low-level library. It belongs to the family of "distribution cover" routines that support revenue, tax, freight, and receivables accounting line creation during transaction entry and adjustment.

Key Procedures and Functions

The ETRM metadata documents one callable unit in this package: INSERT_DIST_COVER. Its stated description is to convert its column parameters into a distribution record and insert a distribution line. It is scoped PUBLIC.

• INSERT_DIST_COVER — Inserts a single accounting distribution line for a customer transaction line. Its argument list, as documented, covers the full spread of distribution attributes: form context (p_form_name, p_form_version); currency conversion inputs (p_exchange_rate, p_base_currency_code, p_base_precision, p_base_mau); transaction identity (p_customer_trx_id, p_customer_trx_line_id, p_cust_trx_line_salesrep_id); accounting classification (p_account_class, p_account_set_flag); amounts and percentages (p_percent, p_amount, p_acctd_amount); dates (p_gl_date, p_original_gl_date); the account (p_code_combination_id, p_concatenated_segments) and tax account (p_collected_tax_ccid, p_collected_tax_concat_seg); descriptive text (p_comments); USSGL fields (p_ussgl_transaction_code, p_ussgl_trx_code_context); and fifteen descriptive flexfield attribute columns (p_attribute1 through p_attribute15). The procedure returns the identifier of the newly created distribution row through the OUT parameter p_cust_trx_line_gl_dist_id, and its documented return type is NONE.

The package header also declares the private function set_original_gl_date, which resolves the original GL date for a given transaction line and account class. The modification history begins 10-OCT-95 (created by Martin Johnson).

Tables Accessed

The package operates against the following APPS synonyms:

• RA_CUST_TRX_LINE_GL_DIST — the primary target; the insert described above writes the distribution row here.
• RA_CUSTOMER_TRX and RA_CUSTOMER_TRX_LINES — read to validate and resolve transaction and line context for the distribution being created.
• RA_CUST_TRX_TYPES — supplies transaction type attributes used during defaulting.
• RA_RULES — provides revenue recognition and distribution rule information.
• AR_SYSTEM_PARAMETERS — supplies system-level defaults and precision/currency settings.
• FND_CURRENCIES — resolves currency attributes for the base currency and precision arguments.

Usage Notes

ARP_INSERT_DIST_COVER is a low-level distribution insertion API. It is not invoked by any other documented package, so it is normally called directly from Receivables transaction entry forms, from concurrent programs that build distribution lines, or from custom PL/SQL extensions that need to create a RA_CUST_TRX_LINE_GL_DIST row without using the full Receivables public API layer. Because the procedure accepts the primary key components of a transaction and line along with an explicit account and amount, callers are responsible for supplying valid, already-derived values; the procedure performs the insert rather than computing the entire distribution. The OUT parameter p_cust_trx_line_gl_dist_id allows the caller to reference the new row immediately after creation. Debug output is routed through arp_standard.debug at the level held in pg_msg_level_debug, which is useful when diagnosing distribution-population issues in transaction entry or conversion scripts.