Search Results ar_interface_conts




Overview

AR_DEFERRAL_REASONS_GRP is a public PL/SQL package in the APPS schema that supports Oracle Receivables revenue management and deferral processing. Its classification as a GRP (group) package indicates that it bundles related business operations rather than exposing a single, narrowly scoped API. In the context of Oracle EBS 12.1.1 and 12.2.2, the package provides the server-side logic required to record customer acceptance and proof-of-delivery events and to determine the deferral reasons applicable to a transaction line. These events are central to revenue recognition: when a customer accepts goods or a proof of delivery is confirmed, the deferral status of the associated receivable line can be updated, allowing revenue to be recognized in accordance with the configured revenue recognition rules. The package interacts with deferred line records, interface continuation tables, and delivery data, and depends on shared Revenue Management and API infrastructure such as AR_REVENUE_MANAGEMENT_PVT, AR_RAAPI_UTIL, FND_API, FND_MSG_PUB, FND_PROFILE, and FUN_RULE_PUB. It is referenced by five other packages, confirming that it forms part of a larger internal call hierarchy within Receivables.

Key Procedures and Functions

  • DEFAULT_REASONS — Determines and applies default deferral reasons for the relevant deferral context. It resolves which deferral reason should be associated with a transaction or deferred line based on the configured deferral reason setup held in AR_DEFERRAL_REASONS.
  • RECORD_ACCEPTANCE — Records a customer acceptance event against the appropriate transaction or deferred line. This operation drives deferral and revenue recognition activity by signaling that acceptance has occurred.
  • RECORD_PROOF_OF_DELIVERY — Records a proof-of-delivery event, using delivery information from the WSH delivery tables, so that the deferral state of the associated line can be evaluated or updated.

All three procedures are documented as public package-level operations. The metadata does not enumerate their formal parameter lists; parameter details should be obtained from the package specification rather than inferred.

Tables Accessed

The package accesses the following tables through APPS synonyms:

  • AR_DEFERRAL_REASONS — Deferral reason definitions used by DEFAULT_REASONS.
  • AR_DEFERRED_LINES — Deferred line records updated or queried when acceptance or proof of delivery is recorded.
  • AR_INTERFACE_CONTS — Interface continuation records associated with Receivables interface processing.
  • RA_CUSTOMER_TRX_LINES — Transaction lines whose deferral and revenue status is affected.
  • RA_INTERFACE_LINES — Receivables interface lines processed in conjunction with the interface continuation records.
  • RA_RULES — Revenue recognition rules applied during deferral processing.
  • WSH_DELIVERY_ASSIGNMENTS — Delivery-to-line assignments used to link proof-of-delivery events.
  • WSH_DELIVERY_DETAILS — Delivery detail records providing the shipped/delivered context for proof-of-delivery processing.

Usage Notes

AR_DEFERRAL_REASONS_GRP is an internal Receivables package rather than a standalone user-facing API. It is typically invoked indirectly from forms, concurrent programs, or other PL/SQL packages that process customer acceptance and proof-of-delivery events for deferred revenue. Because the package is not referenced by any database object but is itself dependent on Revenue Management and API utilities, callers should respect the established call hierarchy and avoid bypassing it. Developers extending Receivables should reference the package specification for exact signatures; the presence of AR_INTERFACE_CONTS in the dependency list reflects the package's role in interface-based processing of continuations and deferral data.