Search Results addon_ship_to_site_name

Overview

OKL_DEAL_ASSET_PVT is a private (PVT) PL/SQL package in the Oracle Lease and Finance Management (OKL) module of Oracle E-Business Suite. It encapsulates the internal business logic that governs how leased assets and asset-related lines are created, updated, and loaded against an OKL contract or deal. The package operates on the composite record type las_rec_type, a structure that aggregates the attributes of a leased asset line: deal type, inventory item and organization identifiers, fixed asset identifiers and numbers, unit cost and units, model and manufacturer data, party site and fixed asset location references, and financial attributes such as residual percentage, residual value, residual code, guaranteed amount, and RVI premium. This record type provides a single logical view of an asset line spanning purchasing, inventory, fixed assets, and contract header/line tables.

The package belongs to the OKL Deal Asset family of private APIs. Its classification as PVT indicates that it is intended for internal consumption by other OKL packages, forms, and concurrent programs rather than for direct invocation by external custom code. The header comment ($Header: OKLRDASS.pls 120.1 2007/04/26) confirms the file has been stable since the 11i/12.0 era and is carried forward into 12.1.1 and 12.2.2.

Key Procedures and Functions

The documented API exposes 14 procedures and functions. Their purposes are as follows.

• PROCESS_LINE_BILLING_SETUP — Processes the billing setup associated with a deal line, deriving the billing attributes required for downstream invoicing.
• LOAD_LINE_BILLING_SETUP — Loads the billing setup data into the relevant contract line structures.
• CREATE_ASSETADDON_LINE — Creates an asset add-on line on a deal, used when additional assets are attached to an existing contract.
• UPDATE_ASSETADDON_LINE — Updates an existing asset add-on line.
• CREATE_ALL_LINE — Creates a complete asset line, populating the full las_rec_type record.
• UPDATE_ALL_LINE — Updates an existing asset line in full. This is the procedure associated with the search term update_all_line; it is the principal maintenance entry point for changing asset line attributes across the deal.
• LOAD_ALL_LINE — Loads a fully populated asset line record, typically invoked as the final step in the create/update sequence.
• ADDON_SHIP_TO_SITE_NAME — Resolves and returns the ship-to site name for an add-on line.
• ALLOCATE_AMOUNT_TRADEIN — Allocates trade-in amounts across deal lines.
• ALLOCATE_AMOUNT_DOWN_PAYMENT — Allocates down payment amounts across deal lines.
• GET_SUBSIDY_AMOUNT — Retrieves the subsidy amount applicable to the deal or line.
• GET_DOWN_PAYMENT_AMOUNT — Retrieves the down payment amount applicable to the deal or line.

Tables Accessed

The package reads and writes across the contract, inventory, and fixed asset schemas.

• OKC_K_HEADERS_B, OKC_K_LINES_B, OKC_K_LINES_TL, OKC_K_ITEMS, OKC_K_PARTY_ROLES_B — Core contract header, line, item, and party role data from the OKC contracts schema; the package reads currency, price, and line identifiers and writes line attributes.
• OKL_K_HEADERS, OKL_K_LINES — Lease-specific header and line extensions holding deal type, model number, residual, RVI, and delivery/funding expectations.
• OKL_TXL_ASSETS_B — Transactional asset attributes such as manufacturer, year of manufacture, FA location, and asset key.
• FA_ADDITIONS_B, FA_ADDITIONS_TL, FA_ADDITIONS, FA_DISTRIBUTION_HISTORY — Fixed asset definitions, descriptions, and distribution history used when assets are capitalized or reassigned.
• MTL_SYSTEM_ITEMS_B, MTL_SYSTEM_ITEMS_TL — Inventory item definitions and descriptions, resolving the inventory item and organization for the asset.
• CSI_ITEM_INSTANCES — Installed base instances representing the deployed asset.

Usage Notes

OKL_DEAL_ASSET_PVT is invoked indirectly. The OKL lease entry and asset management forms call the public OKL APIs, which in turn delegate to this private package. Concurrent programs that load or refresh deal asset lines may also call it. Because the package is classified PVT, Oracle does not guarantee its signature across patches; custom code should call the corresponding public OKL API rather than UPDATE_ALL_LINE directly. The update_all_line procedure is invoked when an existing asset line's units, residual attributes, location, or financial terms change, and it typically precedes LOAD_ALL_LINE to persist the change. The package is referenced by one other package, confirming its role as an internal dependency within the OKL deal asset processing chain rather than a standalone entry point.