Results for “fee_type”

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

Overview

OKL_CREDIT_DATAPOINTS_PVT is a private (PVT) PL/SQL package within the Oracle E-Business Suite Lease Management (OKL) module of Oracle Enterprise Contracts / ETRM. It is defined with AUTHID CURRENT_USER and carries the API version constant G_API_VERSION := 1, identifying it as the first-generation internal implementation layer backing the credit data point infrastructure of the Lease Application flow.

The package serves a specialized business function: it resolves the individual data points that describe a credit request associated with a lease application. In lease origination, credit analysts and sales personnel capture a set of descriptive attributes — credit line number, expiration date, currency, sales representative, vendor, program agreement, expected dates, financial product, and asset-related attributes such as item, model, and manufacturer. These attributes are stored against the lease application through the OKL_LEASEAPP_DATAPOINTS table, and each data point is keyed to metadata held in AR_CMGT_DATA_POINTS_VL. OKL_CREDIT_DATAPOINTS_PVT encapsulates the retrieval and management logic for these values, exposing a uniform set of accessor functions that the public Lease Application APIs and user interface layers consume.

The package defines the PL/SQL record type lap_dp_rec_type and the associated associative array lap_dp_tbl_type, which model a lease application data point together with its descriptive name and description. These strongly typed structures allow callers to work with collections of credit data points without depending on the physical table definitions. Standard FND_API constants (G_RET_STS_SUCCESS, G_RET_STS_ERROR, G_RET_STS_UNEXP_ERROR) and error tokens are declared, indicating conformance to the Oracle Applications API error-handling conventions.

Key Procedures and Functions

The package exposes 59 documented procedures and functions. The majority are single-purpose accessor functions that return the value of a specific credit data point for a given lease application. Each follows the same signature pattern, returning the data point value as a VARCHAR2 and emitting an error message through an OUT parameter.

• CREDIT_LINE_NUMBER — returns the credit line number recorded for the lease application.
• CREDIT_LINE_EXPIRATION_DATE — returns the expiration date of the referenced credit line.
• CURRENCY — returns the currency code associated with the credit request.
• SALES_REP — returns the sales representative tied to the lease application.
• PROGRAM_VENDOR and PROGRAM_AGREEMENT_NUMBER — return vendor and program agreement identifiers used in vendor program financing.
• EXPECTED_START_DATE, EXPECTED_DELIVERY_DATE, EXPECTED_FUNDING_DATE — return the anticipated milestone dates of the lease transaction.
• LEASE_APPLICATION_TEMPLATE and TERM_OF_DEAL — return the template identifier and the commercial term description.
• ORG_UNIT and PROSPECT_ADDRESS — return the operating unit and the prospect site address.
• FINANCIAL_PRODUCT — returns the financial product classification of the lease.
• ITEM, ITEM_DESCRIPTION, ITEM_SUPPLIER, MODEL, MANUFACTURER, YEAR_OF_MANUFACTURE — return asset-level identification attributes for the equipment being leased.

All functions share the x_resultout OUT NOCOPY VARCHAR2 and x_errormsg OUT NOCOPY VARCHAR2 parameters, reflecting a consistent retrieval contract across the package.

Tables Accessed

The package reads and writes credit data point records in OKL_LEASEAPP_DATAPOINTS, the primary store for lease application data points, and joins to AR_CMGT_DATA_POINTS_VL to obtain the data point name and description. Supporting lookups resolve values from HR_ALL_ORGANIZATION_UNITS (operating unit), HZ_PARTY_SITES (prospect addresses), JTF_RS_SALESREPS (sales representatives), MTL_SYSTEM_ITEMS_KFV (inventory item details), OKC_K_HEADERS_B and OKC_K_PARTY_ROLES_B (contract header and party roles), and the asset tables OKL_ASSETS_B, OKL_ASSETS_TL, and OKL_ASSET_COMPONENTS_B. Financial detail is drawn from OKL_CASH_FLOWS, OKL_CASH_FLOW_LEVELS, OKL_CASH_FLOW_OBJECTS, OKL_COST_ADJUSTMENTS_B, and OKL_FEES_B. All access is made through APPS synonyms, consistent with EBS coding standards.

Usage Notes

As a private package, OKL_CREDIT_DATAPOINTS_PVT is not intended for direct invocation by external customers. It is referenced by one other package in the ETRM schema, which acts as the public wrapper for lease application credit processing. The accessor functions are typically invoked from the Lease Management forms during credit request entry and review, and from the Lease Application public APIs when building the credit attribute set. Because the functions return descriptive values rather than performing DML, they are safe to call in read-only contexts such as concurrent program extraction and reporting. Customizations should call the corresponding public API rather than this private package, since the private layer is subject to change between releases while the public contract remains stable.