Search Results okc_std_article_pvt




Overview
Explore in AI Chat

Overview

OKC_SAM_PVT is a private PL/SQL package in the APPS schema that supports Oracle E-Business Suite's Service Agreements and Contracts (OKC) module, specifically the Standard Article and Standard Article Set functionality. The package name reflects its role in managing "SAM" (Standard Article Membership) data — the association of standard articles into reusable article sets that can be applied across contract and service agreement templates.

As a private (PVT) API, OKC_SAM_PVT is not intended for direct external invocation. It provides the internal row-level DML, validation, and versioning logic that the public OKC_STD_ARTICLE_PUB and OKC_STD_ARTICLE_PVT packages rely upon. The package depends on FND_API for the Oracle Application Object Library API framework (error handling, message stacking) and on OKC_API for contract-specific utilities, confirming its position within the broader Contracts API stack.

The package is documented as VALID and is referenced by two other packages, indicating it is an active and depended-upon component in the ETRM 12.2.2 environment.

Key Procedures and Functions

The package exposes fourteen documented procedures and functions. The core data management operations are:

  • INSERT_ROW — Inserts a new standard article set membership record into the base table.
  • UPDATE_ROW — Modifies an existing membership record.
  • DELETE_ROW — Removes a membership record.
  • LOCK_ROW — Acquires a row-level lock prior to update, preventing concurrent modification conflicts.
  • API_COPY — Duplicates existing standard article set membership records, supporting the copy/clone operations common in contract template administration.
  • VALIDATE_ROW — Performs validation of a row's data against business rules before persistence.
  • VALIDATE_UNIQUE — Enforces uniqueness constraints on the membership records.
  • CHANGE_VERSION — Manages version transitions of standard article records, consistent with the versioning model used throughout OKC standard articles.
  • QC — A quality-control or consistency check routine that verifies the integrity of membership data.

The remaining documented procedures perform supporting functions within the same validation and DML lifecycle. No parameter lists are documented; callers should reference the actual package specification in the EBS database for signature details.

Tables Accessed

The package reads and writes the following tables through APPS synonyms:

  • OKC_STD_ART_SET_MEMS — The base table holding standard article set membership records. This is the primary target of INSERT_ROW, UPDATE_ROW, DELETE_ROW, and LOCK_ROW operations.
  • OKC_STD_ART_SET_MEMS_V — The corresponding view over the membership table, referenced for read operations and validation.
  • OKC_STD_ARTICLES_B — The base table of standard articles, referenced to validate that articles being added to a set exist and are valid.
  • PLITBLM — A PL/SQL index-by table type used internally for passing collections of IDs between procedures, commonly employed in the OKC API family for bulk operations.

Usage Notes

OKC_SAM_PVT is a private package and should not be invoked directly by custom code. It is called by OKC_STD_ARTICLE_PUB and OKC_STD_ARTICLE_PVT, which serve as the supported entry points. These public packages are invoked from the Standard Articles setup forms in the Contracts Manager responsibility, from concurrent programs that import or copy standard article sets, and from the OKC API layer when contract templates are generated or applied. Customizations that need to manipulate standard article set memberships should route through OKC_STD_ARTICLE_PUB and its documented procedures rather than calling OKC_SAM_PVT, since the private API signatures and behavior are subject to change across patch levels. In 12.1.1 and 12.2.2, this package remains a stable internal dependency of the standard article feature set.