Search Results pv_enrl_request_order_pub




Overview
Explore in AI Chat

Overview

PV_ENRL_REQUEST_ORDER_PUB is a public PL/SQL package belonging to the Oracle EBS Advanced Pricing / Channel Revenue Management family of APIs, owned by the APPS schema. Its business purpose is to support enrollment request processing by resolving payment-related attributes for an order, including the payment type that should be applied to the resulting invoice and the outstanding balance of an invoice tied to an order. The package header comment (pVxperob.pls, $Header: 120.1, dated 2005/08/10) confirms that the code was specifically reworked for Release 12, notably by commenting out logic that previously depended on FND lookup views and by prefixing the AMOUNT_DUE_REMAINING column with its owning table alias ("ARPS") because that column name exists in both AR_PAYMENT_SCHEDULES_ALL and RA_CUSTOMER_TRX_LINES_ALL. This is a small, single-purpose public API layer exposed to callers rather than a broad transactional package.

Key Procedures and Functions

The package exposes four documented routines. Only their names and purposes are described here; parameter lists are not enumerated.

  • GET_INVOICE_BALANCE — Returns the outstanding balance associated with a given order header. In the shipped source this function is effectively a stub that declares a local balance variable, immediately returns it (as NULL), and traps NO_DATA_FOUND to return NULL as well. It therefore serves as a placeholder/compatibility entry point rather than an active calculation in this version.
  • GET_PAYMENT_TYPE — Returns the payment type meaning for an order. It reads PAYMENT_TYPE_CODE and CUST_PO_NUMBER from the order header, then resolves the descriptive meaning from PV_LOOKUPS for lookup type PV_PAYMENT_TYPE. When the stored payment type code is null, it defaults to the 'INVOICE' lookup code. The Release 12 change commented out the older path that branched to a PURCHASE_ORDER meaning via FND_LOOKUP_VALUES_VL when a customer PO number existed.
  • GET_INVOICE_DETAILS — Documented as a third public routine for retrieving invoice-level detail associated with the order, complementing the balance and payment type accessors.
  • The package also declares G_PKG_NAME, a global constant holding the package name used for diagnostic and error-identification purposes.

Tables Accessed

The package reads across the order-to-invoice chain through the following APPS synonyms:

  • OE_ORDER_HEADERS_ALL — source of the order's payment type code and customer PO number used by GET_PAYMENT_TYPE.
  • OE_ORDER_LINES_ALL — order line context used when resolving invoice detail.
  • AR_PAYMENT_SCHEDULES_ALL — repository of invoice balances; note the "ARPS" alias convention adopted to disambiguate AMOUNT_DUE_REMAINING.
  • RA_CUSTOMER_TRX_ALL — the AR transaction (invoice) header for detail retrieval.
  • RA_CUSTOMER_TRX_LINES_ALL — transaction lines, which also carry an AMOUNT_DUE_REMAINING column (the reason for the alias fix).

Usage Notes

PV_ENRL_REQUEST_ORDER_PUB is classified as a PUBLIC API (API classification: PUB), indicating it is intended to be called by external code rather than invoked internally only. It is typically called from Oracle Forms order-entry or enrollment flows, from concurrent programs performing invoice or payment-type resolution, and from customer-written PL/SQL that needs the payment type or invoice balance for an order. Callers should note that in this shipped version GET_INVOICE_BALANCE returns NULL by design, so downstream logic requiring a real balance must source it directly from AR_PAYMENT_SCHEDULES_ALL via the RA_CUSTOMER_TRX_LINES_ALL alias. The package is not referenced by any other package (referenced by 0 other packages), so its impact is confined to direct callers. Behavior is consistent across 12.1.1 and 12.2.2, the Release 12 lookup refactoring being the principal functional difference from earlier 11i code.