Search Results p_contract_number

Overview

The APPS.OKL_PROP_TAX_ADJ_PUB package body is a public API wrapper within the Oracle E-Business Suite Lease and Finance Management (OKL) module. Its specific business function is to create adjustment invoices related to property tax reconciliation for leased assets. The package serves as the public interface layer in a two-tier architecture, delegating the substantive business logic to the private package OKL_PROP_TAX_ADJ_PVT while exposing a stable, callable API surface to external consumers such as concurrent programs, forms, and custom extensions. This separation follows Oracle's standard PL/SQL API design pattern, where _PUB packages provide controlled entry points and _PVT packages encapsulate the internal processing logic.

Key Procedures and Functions

The package body exposes two documented procedures as listed in the ETRM metadata:

• CREATE_ADJUSTMENT_INVOICE — This is the standard programmatic API entry point. It accepts a contract number and an asset number (both VARCHAR2) and returns the standard API outputs: return status, message count, and message data. It also accepts API version and message list initialization parameters, consistent with the Oracle EBS API framework conventions. Internally, it delegates immediately to OKL_PROP_TAX_ADJ_PVT.create_adjustment_invoice, passing all parameters through unchanged. This procedure is intended for callers that need to invoke the adjustment invoice creation logic from within other PL/SQL code, forms, or OA Framework-based pages.
• CREATE_ADJUST_INVOICE_CONC — This is the concurrent program entry point. It follows the standard concurrent program signature with errbuf and retcode OUT parameters, which Oracle EBS concurrent managers require. It accepts the same p_contract_number and p_asset_number inputs as the programmatic API. Internally, it calls CREATE_ADJUSTMENT_INVOICE with a hardcoded API version of 1 and then writes a formatted log to the concurrent program's log file using FND_FILE.PUT_LINE, including a run date and a "Property Tax Reconciliation" header. This procedure is designed to be registered as a concurrent program in Oracle Applications and executed via the standard concurrent manager.

Tables Accessed

The ETRM metadata for this package body does not explicitly list any direct table references. All table access is encapsulated within the private package OKL_PROP_TAX_ADJ_PVT, which this package delegates to. Based on the package's purpose, the private package presumably reads and writes lease contract and asset data (likely from OKL contract tables such as OKL_HEADERS or similar) and may interact with Oracle Receivables tables to create adjustment invoices. However, because the metadata does not document these tables and the public package performs no direct DML, no specific table-level claims can be made from the provided documentation alone.

Usage Notes

This package is typically invoked in two ways:

• As a concurrent program, through CREATE_ADJUST_INVOICE_CONC, which is registered in the Oracle Applications concurrent program definitions and scheduled to run periodically or on demand for property tax reconciliation processing. The user-supplied search term p_contract_number corresponds to the input parameter of this concurrent program, which restricts the adjustment invoice creation to a specific lease contract.
• As a programmatic API, through CREATE_ADJUSTMENT_INVOICE, which can be called from custom PL/SQL, Oracle Forms, or other EBS components when immediate adjustment invoice creation is required as part of a larger transaction flow.

The package is not referenced by any other documented public packages, indicating it is a top-level entry point rather than a shared utility. Callers should always check x_return_status for OKL_API.G_RET_STS_SUCCESS or similar success indicators, and should retrieve messages via OKL_API.GET_MSG_COUNT and OKL_API.GET_MSG_DATA when errors occur. The package leverages FND_FILE for concurrent logging and OKC_API.G_FALSE for message list initialization, confirming its integration with the standard Oracle EBS API framework.