Search Results oki_load_rbs_pvt




Overview
Explore in AI Chat

Overview

OKI_LOAD_RBS_PVT is a private (PVT-classified) PL/SQL package body owned by the APPS schema in Oracle E-Business Suite. Its name reflects the "Load RBS" function — loading data related to RBS, understood within the Oracle Knowledge & Information (OKI) / Enterprise Contracts (formerly OKC/OKI) product family as "Renewal By Status" processing. The package belongs to the Oracle Contracts renewal and coverage subsystem and is responsible for extracting qualifying sales contract data and loading it into renewal-processing structures so that eligibility rules can be applied against contract lines.

In the Oracle EBS 12.1.1 and 12.2.2 releases, this PL/SQL unit is a supporting private package invoked internally by public-facing renewal APIs and concurrent programs. As a PVT package, it is not intended for direct customer invocation; instead it provides the loading and staging logic consumed by the renewal refresh and coverage-period processing flows.

Key Procedures and Functions

  • CRT_RNWL_BY_STATUS — The single documented procedure in this package body. Based on its name, its purpose is to create ("CRT") renewal candidate records based on contract/line status criteria. It evaluates sales contracts and their lines against configured status filters and populates the renewal-by-status staging table. As a private routine, its parameter list is not exposed in the metadata and should not be assumed; callers should treat it as an internal entry point driven by the parent renewal flow.

No additional procedures or functions are documented for this package body in the ETRM metadata. The specification entry confirming the private classification (PVT) indicates the package is designed for internal consumption only.

Tables Accessed

  • OKI_RENEW_BY_STATUSES and OKI_RENEW_BY_STATUSES_S1 — The primary business tables and their sequence used by CRT_RNWL_BY_STATUS to store and key renewal-by-status records. These hold the qualifying rows generated during processing.
  • OKI_SALES_K_HDRS — The sales contract header source table. The package reads contract header information to identify contracts eligible for renewal by status.
  • OKI_COV_PRD_LINES — Coverage period line detail. Renewal logic depends on coverage period definitions and line-level attributes when determining qualifying records.
  • GL_PERIODS — The General Ledger period calendar, used to resolve the accounting period or period name relevant to the renewal date/eligibility window.
  • DUAL — Used for single-row PL/SQL constructs and lookups within the package.

The package also depends on the standard EBS utilities FND_FILE (concurrent program file output), FND_GLOBAL (session/user context), FND_MESSAGE (message text resolution), and internal OKI packages OKI_REFRESH_PVT and OKI_UTL_PVT, which provide refresh orchestration and shared helper routines respectively.

Usage Notes

Because OKI_LOAD_RBS_PVT is classified as a private package and is not referenced by any other database object, it is invoked exclusively from within the Oracle Contracts renewal processing stack. Typical invocation paths are:

  • Concurrent programs in the Oracle Contracts renewal family, which trigger the refresh/load process as a batch job. The presence of FND_FILE as a dependency indicates the package writes output to a concurrent program log/file.
  • Parent private packages such as OKI_REFRESH_PVT, which coordinate the renewal refresh sequence and call CRT_RNWL_BY_STATUS during the load phase.

Customers and implementers should not call this package directly from custom code. Any custom integration requiring renewal-by-status behavior should be built against the publicly supported renewal APIs or concurrent programs that internally drive this routine, preserving upgrade safety across 12.1.1 and 12.2.2.