Search Results crt_rnwl_bkng

Overview

The APPS.OKI_LOAD_RBK_PUB package body is a public PL/SQL API within the Oracle E-Business Suite (EBS) Order Management / Service Contracts (OKI) module. Its role is to load and create renewal booking records for service contracts. The package acts as the externally callable interface (the "PUB" layer) that shields callers from the underlying implementation stored in its companion private package, OKI_LOAD_RBK_PVT. In this two-tier design, OKI_LOAD_RBK_PUB performs input conversion and validation before delegating the substantive processing to the private package.

The header comment references a modification history spanning 2001–2002, including NOCOPY optimization introduced in release 11i. The documented object is available in both Oracle EBS 12.1.1 and 12.2.2, and is owned by APPS, making it a supported integration point for renewal booking generation.

Key Procedures and Functions

The package exposes a single documented procedure:

• CRT_RNWL_BKNG — Accepts a start and end summary-build date (supplied as VARCHAR2 strings from the concurrent request parameters) and creates all renewal booking records that fall within that date range. The procedure first converts the VARCHAR2 parameters into DATE values using FND_CONC_DATE.STRING_TO_DATE, then calls OKI_LOAD_RBK_PVT.CRT_RNWL_BKNG, passing the converted dates along with the standard concurrent program output parameters (x_errbuf and x_retcode). NOCOPY is applied to the OUT parameters for performance. The effective/job-run date also serves as the "current DATE" for bin calculations, such as aging reports.

The public procedure therefore contains no business logic of its own beyond date conversion and delegation; the renewal booking creation is entirely handled by the private package.

Tables Accessed

The ETRM metadata lists no tables directly referenced through APPS synonyms by the public package. Any data manipulation is performed within the private package (OKI_LOAD_RBK_PVT) rather than in OKI_LOAD_RBK_PUB. Because the documented metadata does not enumerate the underlying tables, no specific table names can be asserted; in practice the private layer operates on the OKI service contracts and renewal booking base tables, but this cannot be confirmed from the provided metadata.

Usage Notes

This package is designed to be invoked as part of a concurrent program request. The input parameters are the VARCHAR2 representation of the summary-build start and end dates, characteristic of a concurrent program's parameter set, and the procedure signature includes the standard Oracle concurrent program OUT parameters x_errbuf and x_retcode. Typical invocation occurs when the concurrent program is submitted from the Order Management / Service Contracts responsibility or scheduled by an administrator.

Custom code may call OKI_LOAD_RBK_PUB.CRT_RNWL_BKNG directly, provided it supplies valid VARCHAR2 dates and provides host variables to capture the error buffer and return code. Because the public package delegates to the private package, the API boundary is preserved with the _PUB suffix as the supported, upward-compatible entry point, while _PVT remains internal and subject to change. The ETRM metadata notes the package is referenced by zero other packages, indicating it is invoked from outside the PL/SQL package dependency chain — most likely from a concurrent program definition.