Search Results okl_vendor_refund_pub

Overview

OKL_VENDOR_REFUND_PUB is a public PL/SQL package in the Oracle E-Business Suite (EBS) Oracle Lease and Finance Management (OKL) module, delivered under the APPS schema. It is part of the Enterprise Transaction and Reporting Management (ETRM) extension layer that supports vendor program processing for leased assets. The package is declared with AUTHID CURRENT_USER, meaning its SQL statements execute with the privileges of the invoking user rather than the package owner, a common convention for public APIs in the ETRM framework.

The business purpose of the package, as documented in the source header, is to identify delinquent contracts and, based on the rules defined for the associated vendor programs, calculate the Cure Amount and the Repurchase Amount. These calculations represent the financial exposure the vendor bears when a lessee defaults on a contract that was originated under a vendor program offering cure and repurchase protection. The package therefore supports the vendor recourse and refund settlement process within lease and finance management.

Key Procedures and Functions

The package exposes a single documented procedure, GENERATE_VENDOR_REFUND. It is implemented as a concurrent program entry point, accepting the standard concurrent manager output parameters for the error buffer and return code, along with a contract number parameter that scopes the processing to a specific lease contract.

• GENERATE_VENDOR_REFUND — Identifies delinquent contracts and calculates the Cure and Repurchase Amounts based on vendor program rules. Per the documented note, calculation is permitted only for contracts linked to vendor programs that explicitly allow cures and repurchases. The procedure signature follows the standard concurrent program convention (error buffer OUT, return code OUT, contract number IN).

No other procedures or functions are documented for this package in the ETRM 12.2.2 metadata.

Tables Accessed

The provided metadata does not enumerate the specific tables referenced through APPS synonyms. Based on the package's function, it necessarily reads lease contract and vendor program configuration data — including the vendor program rules that determine eligibility for cure and repurchase — and it writes the resulting Cure and Repurchase Amounts for downstream settlement or reporting. Because the documented reference list is empty in the metadata excerpt, the exact table inventory should be confirmed against the deployed package body in the target instance.

Usage Notes

OKL_VENDOR_REFUND_PUB is intended for concurrent program invocation. The standard pattern is to register GENERATE_VENDOR_REFUND as a concurrent executable so that it can be submitted from the Submit Requests form or scheduled by the concurrent manager. The contract number parameter allows the program to be run for a single contract; broader batch identification of delinquent contracts is handled by the program logic itself.

• Do not call the procedure from custom code expecting row-by-row results; it is a batch-oriented concurrent entry point.
• The package is classified as a public (PUB) API, so its interface is considered stable for extension use.
• It is not referenced by any other documented package, so it functions as a leaf-level API rather than a shared utility.
• Ensure the executing user has appropriate privileges on the underlying lease and vendor program tables, consistent with the AUTHID CURRENT_USER declaration.

Because the metadata offers limited detail, implementers integrating or troubleshooting this package should inspect the actual package specification and body in the target release to confirm parameters, table access, and exception handling behavior. The absent table references and single procedure indicate the object has a narrow, purpose-built role in vendor refund processing rather than broad functional coverage.