Search Results crt_exp_not_rnw

Overview

The package body APPS.OKI_LOAD_ENR_PUB is a public API artifact within the Oracle E-Business Suite Order Management and Service Contracts (OKI) module family. Its documented purpose is to serve as the externally callable entry point for loading and populating expired-not-renewed (ENR) contract data. Specifically, the header of the source indicates that its sole documented routine exists to "create all the expired not renewed records," which are contractual instruments whose expiration date has passed without a renewal having been registered against them.

The object is dated to the ETRM 12.1.1 metadata set and carries a header revision of 115.4 dated 2002/12/01. Although the source extract lists the schema as APPS and classifies the object as a PUB (public) API, the visible body is a thin wrapper: the original implementation and the heavy lifting reside in the private package OKI_LOAD_ENR_PVT, which the public procedure delegates to. This public/private split is a standard EBS design convention that keeps the callable surface stable while allowing internal logic to evolve.

Key Procedures and Functions

• CRT_EXP_NOT_RNW — The single documented procedure in this package. It is the public entry point used to generate the set of expired-not-renewed records. It accepts a period set name, a period type, and a summary build date, and returns the standard concurrent-request output parameters (error buffer and return code). The procedure converts the incoming summary build date from a character string into an Oracle DATE using FND_CONC_DATE.STRING_TO_DATE, treats that date as the effective "current date" for aging and bin calculations, then delegates the actual creation work to OKI_LOAD_ENR_PVT.CRT_EXP_NOT_RNW, passing the converted date and returning the error buffer and return code to the caller. The NOCOPY compiler hint on the OUT parameters reflects the 26-NOV-2002 performance change noted in the modification history.

Tables Accessed

The ETRM metadata provided for this object lists no directly referenced tables via APPS synonyms. All data access is encapsulated in the private package OKI_LOAD_ENR_PVT, which performs the actual DML against the ENR staging and contract tables. Consequently, the public package body itself is not a source of direct table dependencies, and its read/write footprint cannot be enumerated from the documented metadata alone.

Usage Notes

Because CRT_EXP_NOT_RNW conforms to the EBS concurrent program parameter convention (error buffer, return code, plus a small set of input parameters), it is typically invoked from a concurrent program registered in Oracle Applications Manager, most likely as a scheduled or on-demand process run from the Order Management or Service Contracts responsibility. It may equally be called from custom PL/SQL code that needs to seed expired-not-renewed records, provided the caller supplies a valid period set name, period type, and a summary build date in a format accepted by FND_CONC_DATE.STRING_TO_DATE.

Two practical cautions apply. First, the summary build date is not merely a filter; it also defines the reference "current date" for aging bins, so callers should pass the intended business date rather than SYSDATE by default. Second, since the public body is a wrapper only, callers should not expect it to perform validation or logging beyond what the private package provides; error conditions surface through x_errbuf and x_retcode, and the return code should be inspected before downstream processing continues. No other packages are documented as referencing this object, indicating it is intended as a top-level invocation point rather than a shared internal utility.