Search Results arp_process_freight_cover




Overview
Explore in AI Chat

Overview

ARP_PROCESS_FREIGHT_COVER is a PL/SQL package body owned by the APPS schema in Oracle E-Business Suite Release 12.1.1 and 12.2.2. Its object status is VALID, and it is classified as an OTHER API within the ETRM repository. The package belongs to the Oracle Receivables (AR) module and forms part of the freight processing family of programs, which manage the calculation, distribution, and accounting of freight charges attached to customer transactions.

In Oracle Receivables, freight charges are treated as a distinct revenue or cost component of a transaction line. Freight charges frequently carry tax implications and require their own accounting distributions. The freight cover logic in this package addresses the treatment of freight amounts when covering or offsetting those charges. The package performs the database-level work necessary to record freight cover information against customer transaction lines and to generate or adjust the corresponding general ledger distributions. It is a backend API rather than an end-user-facing component; it is invoked by other Receivables programs or by custom extensions rather than being run directly.

Key Procedures and Functions

The ETRM metadata documents two procedures within this package body:

  • INSERT_FREIGHT_COVER — Creates a new freight cover record for a Receivables transaction. This procedure inserts the data required to associate a freight cover amount with the appropriate customer transaction line and to establish the related accounting distribution entries.
  • UPDATE_FREIGHT_COVER — Modifies an existing freight cover record. This procedure is used when freight cover amounts or their associated distributions must be adjusted subsequent to initial creation, for example following a correction to the underlying transaction.

Both procedures operate on transaction line and distribution data and are not documented as referenced by any other database object, indicating they are called programmatically by the Receivables application layer. Specific parameter lists are not reproduced here; the documented procedures consist of the two named above.

Tables Accessed

The package references the following base tables through APPS synonyms, as documented in the dependency information:

  • RA_CUSTOMER_TRX_LINES — The transaction line table. Freight cover records are associated with individual transaction lines, so this table is read to identify and validate the line against which freight cover is applied.
  • RA_CUST_TRX_LINE_GL_DIST — The transaction line general ledger distribution table. Freight cover amounts require corresponding accounting entries, and this table is updated or queried to maintain those distributions.
  • RA_CUST_TRX_TYPES — The transaction type table. This is read to determine valid transaction types for which freight cover processing is allowed, and to apply type-specific processing rules.

In addition, the package depends on the standard Receivables utility and processing packages ARP_CTL_PKG, ARP_PROCESS_FREIGHT, ARP_UTIL, and the FND_PROFILE package. These dependencies indicate reliance on shared error handling, profile option lookups, and the core freight processing logic maintained in ARP_PROCESS_FREIGHT.

Usage Notes

ARP_PROCESS_FREIGHT_COVER is an internal Receivables API. It is not exposed through a standard concurrent program or Oracle Forms interface and is not referenced by any other database package object in the documented metadata. Typical invocation occurs from the Receivables transaction processing flow, where the application layer or a custom extension calls INSERT_FREIGHT_COVER when freight cover must be established and UPDATE_FREIGHT_COVER when existing cover must be revised.

Because the package depends on ARP_PROCESS_FREIGHT and FND_PROFILE, custom code that calls it should ensure the relevant profile options are configured and that transaction lines and distributions are in an appropriate state before invocation. Direct modification of the underlying tables is not recommended; the procedures in this package provide the supported path for creating and updating freight cover records and their accounting distributions.