Results for “okc_rds_pvt”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

OKC_RDS_PVT is a private PL/SQL package in the Oracle E-Business Suite Contracts (OKC) module, owned by the APPS schema and classified as a Private (PVT) API in the ETRM 12.2.2 repository. The package supports the Rule Definition Sources (RDS) feature of Oracle Contracts, which associates rule definitions with specific source objects and access levels. Its central purpose is maintaining the OKC_RULE_DEF_SOURCES entity and its companion view, exposing insert, update, delete, lock, and validation logic for rule source records while enforcing concurrency control and versioning.

The package declares public record types—rds_rec_type for the base table and rdsv_rec_type for the view—that mirror the OKC_RULE_DEF_SOURCES columns, including RGR_RGD_CODE, RGR_RDF_CODE, BUY_OR_SELL, ACCESS_LEVEL, START_DATE, END_DATE, JTOT_OBJECT_CODE, and OBJECT_ID_NUMBER. Each attribute is initialized to the OKC_API.G_MISS_* sentinel values, a standard EBS API convention that allows partial-row updates by distinguishing "not supplied" from actual values. An index-by table type (rds_tbl_type) enables bulk processing.

Key Procedures and Functions

The package documents thirteen procedures and functions. Public entry points include API_COPY, which copies a rule definition source record, and CHANGE_VERSION, which handles object version progression. QC performs quality-control checks on record data. The core DML layer comprises INSERT_ROW, UPDATE_ROW, and DELETE_ROW, which persist changes to the base table. LOCK_ROW enforces pessimistic locking, and VALIDATE_ROW applies business validation rules before commitment. The remaining routines are internal helpers supporting these operations. Consistent with the G_MISS sentinel pattern, callers pass a populated record and the API updates only the supplied attributes.

Tables Accessed

The package reads and writes OKC_RULE_DEF_SOURCES and, through rdsv_rec_type, the OKC_RULE_DEF_SOURCES_V view. It references FND_LOOKUP_VALUES for lookup validation and JTF_OBJECT_USAGES to resolve the source object context linked via JTOT_OBJECT_CODE. Rule definition relationships are checked against OKC_RG_DEF_RULES and OKC_RULE_DEFS_B, ensuring that rule sources are valid for their parent rules. PLITBLM is used for temporary storage during processing. All tables are accessed through APPS synonyms.

Usage Notes

OKC_RDS_PVT is invoked by forms and by two other packages rather than called directly from concurrent programs. It typically runs in the context of the Contracts authoring and setup forms that maintain rule definition sources, where the base-table API handles DML and the view API supports query and lock behavior. Because it is a private package, customizations should use the public OKC API layer where available; direct calls require compiling with AUTHID CURRENT_USER and observe the source object's privileges. The package is present in both EBS 12.1.1 and 12.2.2.