Search Results g_child_table_token

Overview

OKL_INT_EXT_CSH_APP_PVT is a private (PVT) PL/SQL package in the Oracle Lease and Finance Management (OKL) application, classified under the APPS schema and declared with AUTHID CURRENT_USER. Its name reflects its role: it supports the integration and processing of external cash receipts and their application against lease and finance contracts. In the Oracle EBS 12.1.1 / 12.2.2 codebase, private APIs such as this one are typically the internal implementation layer behind a corresponding public API, handling validation, token substitution, and persistence logic on behalf of a higher-level caller.

The package header defines the standard global constants used throughout the OKL and OKC API frameworks, including G_APP_NAME, G_PKG_NAME, G_SQLERRM_TOKEN, G_SQLCODE_TOKEN, G_UNEXPECTED_ERROR, and the shared validation tokens G_NO_PARENT_RECORD, G_INVALID_VALUE, and G_REQUIRED_VALUE. The constant G_PARENT_TABLE_TOKEN is sourced directly from OKL_API, which is significant for the user search term "g_parent_table_token": this token is inherited from the shared API utility package and is used to build dynamic validation messages that identify the parent entity involved in a failed lookup or integrity check.

Key Procedures and Functions

The package exposes a single documented procedure, INT_EXT_CSH_APP. It is the interface routine used to process external cash receipt application data. Consistent with the OKL API conventions of the 2002-era release reflected in the header, it accepts an API version and initialization flag for message list control, and returns the standard trio of status outputs: return status, message count, and message data. The procedure delegates validation and table maintenance to the shared OKL_API and OKC_API utilities, using the token constants to construct localized error messages.

Tables Accessed

The package operates across the Oracle Receivables, trading partners, and Lease Management data models. Receivables tables include AR_CASH_RECEIPTS_ALL and AR_PAYMENT_SCHEDULES_ALL, which supply the cash receipt header and its scheduled application lines, and RA_CUSTOMER_TRX_ALL, which links receipts to customer transactions. HZ_CUST_ACCOUNTS provides the customer account identity. Lease-side tables include OKL_TRX_CSH_RECEIPT_B and its translation table OKL_TRX_CSH_RECEIPT_TL, OKL_CNSLD_AR_HDRS_ALL_B, OKL_CASH_ALLCTN_RLS, OKL_TXL_RCPT_APPS_B, and the validation results tables OKL_VALIDATION_RESULTS_B and _TL, which store validation outcomes. OKC_K_HEADERS_ALL_B supplies the contract header context. The reference to PLITBLM, the standard PL/SQL index-by table type used by the API framework, indicates set-based processing of receipt collections.

Usage Notes

As a private package, OKL_INT_EXT_CSH_APP_PVT is not intended for direct customer invocation. It is referenced by one other package within the OKL application, which is the supported public entry point. Customers and integrators should call that public API rather than this private routine. The package is invoked during external cash receipt integration flows, where lease receipts originating outside the standard flow are validated and applied to contracts. When debugging validation failures, the G_PARENT_TABLE_TOKEN and G_NO_PARENT_RECORD constants are the mechanism that surfaces which parent record is missing, making them relevant to error message interpretation in this package.