Search Results okc_sac_pvt




Overview
Explore in AI Chat

Overview

OKC_SAC_PVT is a private PL/SQL package in the APPS schema that supports the Service and Subscription (SAC) functionality within Oracle E-Business Suite's Service Contracts (OKC) module. It is a private (PVT) API package, meaning it is intended for internal use by other packages in the OKC family rather than being called directly from external interfaces. The package encapsulates the core database operations — validation, insert, update, delete, and locking — required to manage service article classifications (SAC) records. These records define which serviceable items are grouped into specific classifications used in contract and subscription processing.

The package is documented as VALID and exists in both Oracle EBS 12.1.1 and 12.2.2. It exposes 15 documented procedures and functions and references several core tables through APPS synonyms. It is referenced by two other packages, indicating it is a supporting layer beneath higher-level public APIs and publication packages such as OKC_STD_ARTICLE_PUB and OKC_STD_ARTICLE_PVT.

Key Procedures and Functions

The documented procedures and functions fall into three categories: validation, CRUD operations, and utility services.

  • VALIDATE_PRICE_TYPE — Validates the price type value supplied for a service article classification record against the accepted pricing model.
  • VALIDATE_SCS_CODE — Validates the service classification structure code associated with the record.
  • VALIDATE_ROW — Performs full row-level validation, likely invoking the individual validation routines above and other business rules before a record is persisted.
  • INSERT_ROW — Inserts a new service article classification row into the base table.
  • UPDATE_ROW — Updates an existing service article classification row.
  • DELETE_ROW — Deletes an existing service article classification row.
  • LOCK_ROW — Obtains a row-level lock to support concurrent-safe updates.
  • API_COPY — Copies an existing classification record, supporting duplication scenarios.
  • CHANGE_VERSION — Manages versioning of a record, likely incrementing or updating the version attribute when changes occur.
  • QC — A quality control or consistency check routine, typically used to verify data integrity for the entity.

The remaining documented entries (VALIDATE_ROW, API_COPY, INSERT_ROW, LOCK_ROW, UPDATE_ROW, DELETE_ROW, CHANGE_VERSION, QC, and the two specific validators) represent the complete set of 15 named program units as reported by the ETRM metadata. Parameter lists are not documented and should not be assumed; callers should reference the package source or the public wrapper packages for signature details.

Tables Accessed

The package reads from and writes to the following tables via APPS synonyms:

  • OKC_STD_ART_CLASSINGS — The primary base table storing standard article classification records. It is the target of INSERT_ROW, UPDATE_ROW, and DELETE_ROW, and the source for validation queries.
  • OKC_STD_ART_CLASSINGS_V — The public view over the base table, used for read-only lookups during validation and QC.
  • OKC_SUBCLASSES_B — Stores subclass definitions referenced when validating or resolving classification values.
  • PLITBLM — A PL/SQL index-by table used for internal bulk processing; it is not a physical application table.

These tables underpin the classification of serviceable items, which in turn drive subscription and service contract line generation.

Usage Notes

Because OKC_SAC_PVT is a private package, it is not intended to be called directly from forms, concurrent programs, or custom code. Instead, it is invoked by public API and publication packages such as OKC_STD_ARTICLE_PUB and OKC_STD_ARTICLE_PVT, which expose the supported interface for creating and maintaining service article classifications. Customizations should always target the public packages to preserve upgrade safety. The package relies on FND_API for standard API error handling and on OKC_API for shared contract utilities, and it participates in the standard OKC validation and row-handling framework, including locking and versioning conventions. Database administrators and developers troubleshooting service article classification issues should inspect this package when diagnosing validation failures, duplicate records, or concurrent update conflicts.