Results for “credit_check”

50+ results




AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

The OKL_BPD_CREDIT_CHECK_PVT package is a private (PVT-classified) PL/SQL API belonging to the Oracle Lease and Finance Management (OKL) module of Oracle E-Business Suite, owned by the APPS schema. Its principal business function is to evaluate the credit amount available to a customer at a given point in time, supporting the credit-checking logic that governs lease and financing transactions. In the leasing lifecycle, credit exposure must be validated before contracts, quotes, or funding requests proceed; this package encapsulates that validation so that the credit line associated with a customer can be compared against a requested or maximum credit amount.

The package declares AUTHID CURRENT_USER, meaning it executes with the privileges of the invoking user rather than the definer, a common convention for internal helper APIs. Standard ETRM global constants (G_PKG_NAME, G_APP_NAME, and the unexpected-error token set) are defined for consistent error handling and message propagation.

Key Procedures and Functions

The ETRM metadata documents a single callable unit within this package:

  • CREDIT_CHECK — A function that returns the credit amount available for a customer. It accepts a credit line identifier and a maximum credit amount as inputs, along with a transaction date (defaulting to the system date) and the standard API messaging parameters (return status, message count, and message data via the OKC_API message framework). The returned numeric value represents the available credit computed against the specified credit line. The API version parameter indicates the package follows Oracle's versioned-API convention.

No additional public procedures or functions are documented in the excerpt; the design suggests it is intended purely as an internal calculation engine rather than an end-user-facing interface.

Tables Accessed

According to the documented metadata, the package references one table through its APPS synonym:

  • OKL_TRX_AP_INVOICES_B — The base table storing lease transaction-related Oracle Payables invoice information. It is consulted to determine invoiced or billed amounts that affect the customer's outstanding credit position, thereby influencing the computed available-credit figure.

No other tables are documented for this package, indicating a narrowly scoped read pattern focused on invoice-level credit exposure.

Usage Notes

Because OKL_BPD_CREDIT_CHECK_PVT is classified as a private API and is referenced by zero other packages in the documented metadata, it is not designed for direct invocation by external customizations. Instead, it is typically called from within the OKL credit-management flow — for example, from higher-level contract or funding validation logic, credit-check concurrent programs, or forms that must confirm available credit before committing a lease transaction.

Developers should treat this as an internal implementation detail: the _PVT suffix signals that Oracle reserves the right to change its signature without notice. Custom code requiring credit-availability checks should invoke the supported public wrapper APIs in the OKL family rather than calling CREDIT_CHECK directly. The use of the OKC_API message stack further implies that callers must inspect x_return_status and iterate messages when errors occur.

Note: The search term "イオン銀行 本人確認 電話" (Aeon Bank identity verification telephone) is unrelated to this EBS package; it does not appear in the ETRM documentation.