Search Results oki_exp_not_renewed_s1

Overview

The APPS.OKI_LOAD_ENR_PVT package body is a private (PVT-classified) PL/SQL implementation within the Oracle E-Business Suite ETRM (Enterprise Territory and Renewal Management, historically Service Contracts) module. Its name — OKI LOAD ENR — identifies it as a load or staging utility for "ENR" data, which in the OKI/ETRM schema family corresponds to the expiration and non-renewal tracking process. In practice, this package is the engine that identifies contract lines that are expiring within a defined period and have not been renewed, and then materializes those findings into the expiration/non-renewal repository.

The business purpose is to give contract administrators and service managers visibility into service agreements that are approaching expiration without a renewal in place, so that retention and revenue activity can be triggered before the contract lapses. It is a utility package invoked by ETRM's renewal management flow rather than a customer-facing API; the documented status of the object is VALID and it resides in the APPS schema.

Key Procedures and Functions

The ETRM metadata documents a single entry point in the package specification/body:

• CRT_EXP_NOT_RNW — "Create Expired Not Renewed." This procedure is the substantive driver of the package. Consistent with its name and the surrounding object set, it evaluates coverage or entitlement period lines and creates records in OKI_EXP_NOT_RENEWED for those lines whose expiration date has been reached (or falls within a processing window) and for which no renewal exists. It relies on the collection/temporary structures and the header tables listed in the dependency section to determine which lines qualify.

Consistent with the package's PRIVATE classification, no public API parameter list is published in the ETRM documentation, and the parameter lists are deliberately not reproduced here. Any invocation should be driven by the calling ETRM package rather than by direct calls with assumed signatures. The package additionally depends on shared private utilities — OKI_REFRESH_PVT and OKI_UTL_PVT — indicating that it defers to those packages for common refresh and utility logic rather than duplicating it, and on the standard FND_FILE, FND_GLOBAL, and FND_MESSAGE packages for file output, session context, and message lookups.

Tables Accessed

The documented dependencies define the data footprint of OKI_LOAD_ENR_PVT:

• GL_PERIODS — used to resolve the accounting period boundaries that define the expiration or evaluation window, so the process can align its selection to the general ledger calendar.
• OKI_COV_PRD_LINES — the coverage period line table; these are the candidate lines examined to determine whether a covered period is ending and whether a renewal record exists.
• OKI_SALES_K_HDRS — contract/agreement header records referenced to resolve the owning document for each expiring line.
• OKI_K_SALESREPS — the sales representative key table, used to attribute the expiring agreement to the responsible salesperson for downstream notification or reporting.
• OKI_EXP_NOT_RENEWED and OKI_EXP_NOT_RENEWED_S1 — the target expiration/non-renewal table and its sequence; the package inserts the qualifying "expired, not renewed" rows here.
• DUAL and the standard SYS/STANDARD packages — used for simple scalar evaluation and language primitives.

Usage Notes

OKI_LOAD_ENR_PVT is a private implementation package; the ETRM documentation explicitly records that it is not referenced by any other database object, meaning no other packaged code or view currently calls it, and it is instead driven as the implementation layer behind a higher-level public wrapper or concurrent program in the OKI/ETRM family. Typical invocation patterns are:

• A concurrent program submitted from the ETRM or Service Contracts responsibility that executes CRT_EXP_NOT_RNW on a scheduled basis (for example, monthly or on demand before a renewal cycle) to populate or refresh the expiration/non-renewal data set.
• An internal call from a sibling private package (such as OKI_REFRESH_PVT) during a broader refresh of ETRM renewal data, with output written through FND_FILE to the concurrent request log and output file.
• Custom extensions should not call this package directly. Because the signatures are private and unpublished, any customization should reproduce the selection logic against OKI_COV_PRD_LINES, OKI_SALES_K_HDRS, and GL_PERIODS in its own code rather than binding to this package's entry points, which may change without notice.

Because the package writes to OKI_EXP_NOT_RENEWED, it should be treated as a data-modifying process: any re-execution should be coordinated with the ETRM renewal cycle to avoid duplicate non-renewal records within the same period.