Search Results crt_seq_grw




Overview
Explore in AI Chat

Overview

The PL/SQL package body APPS.OKI_LOAD_SGR_PUB belongs to the Oracle E-Business Suite (EBS) Order Management and Contracts domain, specifically the OKI (Contracts/Service) module. Its documented single responsibility is to create sequential growth rate records used in period-based contract or service summary calculations. In Oracle EBS 12.1.1 and 12.2.2, this object is classified as a Public (PUB) API package, meaning it is intended to be invoked from outside the owning module — typically from concurrent programs, other modules, or custom extensions — rather than being an internal-only implementation detail.

The package follows the standard Oracle Concurrent Manager API pattern: a "PUB" (public) wrapper package that accepts concurrent-program style parameters (x_errbuf, x_retcode) and delegates the substantive logic to a "PVT" (private) package named oki_load_sgr_pvt. This layered design keeps the public signature stable while allowing internal processing logic to evolve independently.

Key Procedures and Functions

  • CRT_SEQ_GRW — The sole documented procedure in the package. Its purpose is to create all sequential growth rate records for a given period range. It accepts the period set name, the period type, a start summary build date, and an end summary build date as inputs, along with the standard concurrent manager output parameters (x_errbuf and x_retcode). The procedure first converts the inbound VARCHAR2 date strings into the DATE datatype using the fnd_conc_date.string_to_date utility, then calls the corresponding private procedure oki_load_sgr_pvt.crt_seq_grw, passing the converted dates and returning any error buffer and return code supplied by the private layer.

Tables Accessed

The provided ETRM metadata documents no directly referenced base tables via APPS synonyms for this package body. This is consistent with the design pattern: the public wrapper performs only date conversion and delegation, so any table reads, writes, or DML against sequential growth rate staging or summary tables occur inside the private package oki_load_sgr_pvt. Because the public layer contains no embedded SQL, no table-level dependency is attributed to OKI_LOAD_SGR_PUB itself.

Usage Notes

This package is typically invoked through a concurrent program in Oracle E-Business Suite, which explains the presence of the x_errbuf and x_retcode parameters. The concurrent manager populates these to communicate success, warning, or error status back to the user's request log. The header comment (version 115.3, dated 2002/06/06; initial version 10-Oct-2001 by mezra) indicates the object originates from an early Contracts/Service release and has been carried forward largely unchanged into 12.1.1 and 12.2.2. Since it is a PUB API, it may also be called directly from custom PL/SQL code, though callers should supply valid period set names, period types, and date strings parseable by fnd_conc_date. No other packages are documented as referencing it, so it functions as an entry-point wrapper rather than a shared utility.