Search Results oki_load_rag_pub

Overview

OKI_LOAD_RAG_PUB is a public PL/SQL package owned by the APPS schema in Oracle E-Business Suite. Its declared purpose, as stated in the package header comments, is to load the OKI_RENEWAL_AGING table, a staging and reporting structure used by the Oracle Contracts (OKI) renewal management functionality. The package belongs to the Public (PUB) API classification in the ETRM documentation model, meaning it is designed for invocation from external callers such as concurrent programs, forms, or custom code rather than being restricted to internal package-to-package use.

The package is declared with AUTHID CURRENT_USER, so all unqualified object references are resolved in the schema of the calling session rather than in the APPS schema. The header carries the revision string $Header: OKIPRAGS.pls 115.4 2002/12/01 17:50:28 rpotnuru noship $, and the modification history records creation on 19-Sep-2001 and a NOCOPY parameter change on 26-Nov-2002. These dates place the package within the Oracle 11i code line, and the same source is carried forward into the 12.1.1 and 12.2.2 releases without functional change. The ETRM metadata for the 12.1.1 reference environment documents exactly one procedure and zero dependent packages.

Key Procedures and Functions

The package exposes a single documented procedure:

• CRT_RNWL_AGING — Creates and populates the renewal aging data. Its signature places the two concurrent manager output parameters first, as required by the concurrent processing architecture. The output parameters are declared with NOCOPY: x_errbuf returns the error message buffer and x_retcode returns the completion status code. Three input parameters follow: p_period_set_name and p_period_type identify the accounting period set and period type to be used when aging the renewal lines, and p_summary_build_date supplies the date against which the aging calculation is performed. The procedure therefore supports both ad hoc on-demand aging for a specified date and scheduled, period-driven aging aligned to a named calendar.

No functions or additional overloads are documented in the ETRM record for this package. The package body is not part of the documented public interface; callers depend only on the header signature above.

Tables Accessed

The ETRM metadata lists no referenced tables resolved through APPS synonyms. This is consistent with the AUTHID CURRENT_USER declaration: object references in the body resolve in the invoker's schema, so the extraction of synonym-based dependencies does not report APPS-schema targets. The table explicitly identified in the package header comments is OKI_RENEWAL_AGING, which the package loads. In the Oracle Contracts renewal flow, this table holds aged renewal summary rows keyed by period set, period type, and summary build date, and it is subsequently read by renewal reporting and inquiry components. Because the aging load is a bulk rebuild, the procedure typically deletes or replaces existing rows for the requested build date before inserting the newly computed set.

Usage Notes

OKI_LOAD_RAG_PUB is intended to be invoked as a concurrent program, which explains the leading x_errbuf and x_retcode NOCOPY parameters and the period set, period type, and build date arguments that map naturally to concurrent program parameters. In a 12.1.1 or 12.2.2 environment the wrapper concurrent program is submitted from the Contracts responsibility, either directly by a user or through a scheduling request set that builds renewal aging periodically. The procedure can also be called directly from custom PL/SQL, for example in a test harness that ages a specific period set and build date without creating a concurrent request. Because the package is AUTHID CURRENT_USER, any direct caller must have appropriate privileges on OKI_RENEWAL_AGING and its supporting objects, or must connect as a schema that does. The referenced-by count of zero confirms that no other shipped package depends on this API, so changes to it are isolated and it may be treated as a standalone data-load utility within the renewal aging subsystem.