Search Results oki_load_rbk_pub

Overview

OKI_LOAD_RBK_PUB is a public PL/SQL package owned by the APPS schema in Oracle E-Business Suite. Its declared purpose, as documented in the package header comments, is to load the OKI_RNWL_BOOKINGS table. The package supports the Oracle Contracts (OKI) renewal booking process by assembling renewal booking records from date-bounded summary data and persisting them to the renewal bookings staging/interface table.

The package is declared with AUTHID CURRENT_USER, meaning its SQL statements execute with the privileges of the invoking user rather than the definer. This is consistent with a public API intended to be called from concurrent programs or other application code running under an application user context. The header carries the revision identifier $Header: OKIPRBKS.pls 115.3 2002/12/01 17:51:19 rpotnuru noship $, indicating the file was last revised in December 2002 and is marked "noship." The package is classified as a PUB (public) API in ETRM, confirming it is intended for supported external invocation rather than internal-only use.

Key Procedures and Functions

The package exposes a single documented procedure:

• CRT_RNWL_BKNG — Creates the renewal booking records. Per the package comments, this procedure builds and inserts the records that populate the OKI_RNWL_BOOKINGS table. It accepts start and end summary build date parameters, which scope the set of renewal bookings generated to a defined date range. The procedure also returns the standard concurrent manager OUT parameters x_errbuf and x_retcode, allowing it to be registered and executed directly as a concurrent program. The source header notes that the OUT parameters are listed first due to restrictions in the concurrent manager, which is a common convention for PL/SQL concurrent program entry points in EBS. Parameter lists are not reproduced here; only the documented behavior is described.

No functions or additional procedures are documented in the ETRM metadata for this package. The package body is expected to contain the implementation logic behind CRT_RNWL_BKNG, but the public specification is limited to this single entry point.

Tables Accessed

The ETRM metadata records no explicitly listed table references for this package via APPS synonyms, beyond the target table identified in the package comments: OKI_RNWL_BOOKINGS. Based on the documented purpose ("Load the oki_rnwl_bookings table"), the package writes renewal booking records into OKI_RNWL_BOOKINGS. The start and end summary build date parameters imply the procedure also reads from summary build or renewal summary sources to determine which bookings qualify within the specified date window, though specific source tables are not enumerated in the available metadata.

Usage Notes

OKI_LOAD_RBK_PUB is typically invoked as part of the Oracle Contracts renewal booking cycle. Because CRT_RNWL_BKNG follows the concurrent program parameter convention (x_errbuf and x_retcode returned first), it is most commonly registered as a concurrent program and submitted from the Oracle EBS concurrent manager, allowing users or schedulers to supply the summary build date range. The package may also be called from custom PL/SQL code or from other application logic that needs to regenerate renewal bookings for a given period. The AUTHID CURRENT_USER setting means callers must have the appropriate privileges on the referenced objects. The documented metadata indicates the package is not referenced by any other packages, so it functions as a top-level entry point rather than a library dependency for other APIs. When integrating, ensure the summary build date range is supplied so that the generated renewal bookings align with the intended accounting or renewal period.