Search Results update_sll

Overview

OKS_CONTRACT_SLL_PUB is the public application programming interface for Service Line Level (SLL) records within the Oracle E-Business Suite Service Contracts (OKS) and Contracts (OKC) modules. The package exposes a controlled, pl/sql-based entry point through which callers create, modify, validate, and delete stream level definitions that define the granular line and sub-line structure of a service contract. The package is declared AUTHID CURRENT_USER and carries a subtype alias to OKS_SLL_PVT, indicating that the public package is a thin wrapper over an internal private package that holds the actual business logic. Published header information shows that the package was last modified in 2005 (OKSPSLLS.pls 120.0), consistent with a stable, legacy API that has remained largely unchanged across the 12.1.1 and 12.2.2 releases. All return status constants (G_RET_STS_SUCCESS, G_RET_STS_ERROR, G_RET_STS_UNEXP_ERROR) follow the standard OKC_API / TCA error-handling convention, and error messages are surfaced through the OKC_API message stack using SQLerrm and SQLcode tokens.

Key Procedures and Functions

The documented interface comprises sixteen procedures/functions, with the following principal entry points:

• CREATE_SLL — Inserts one or more Service Line Level records. Overloaded signatures support both a single record and a set-based table of records. Parameters follow the standard API pattern (p_api_version, p_init_msg_list, x_return_status, x_msg_count, x_msg_data) with a p_validate_yn flag to control validation-only execution.
• UPDATE_SLL — Modifies existing SLL rows, applying the same standard parameter convention and validation flag.
• DELETE_SLL — Removes SLL records. This is the procedure most frequently targeted by the search term "delete_sll," typically invoked when a contract line or stream level is re-versioned, reorganized, or eliminated.
• VALIDATE_SLL — Performs business-rule validation of an SLL record without persisting changes, used to pre-check data before create/update operations.
• LOCK_SLL — Acquires a lock on the SLL record, preventing concurrent modification during transactional processing.
• INSERT_ROW_UPG — An upgrade-related helper used during patch or version migration to insert rows for pre-existing data.

Tables Accessed

The package interfaces with OKS_STREAM_LEVELS_B, the base table that stores service line level definitions for contracts, and PLITBLM, an EBS PL/SQL table (index-by table) used for transient, in-memory set processing during bulk create/update/delete operations. Access is performed through APPS-owned synonyms, so the package executes with the privileges of the APPS schema rather than the invoking schema.

Usage Notes

OKS_CONTRACT_SLL_PUB is typically invoked from the Service Contracts authoring forms, from concurrent programs that process contract lines in batch, and from custom extensions that must maintain stream level data programmatically. Because it is classified as a PUB (public) API, Oracle supports direct invocation by customer code, provided callers honor the standard API contract: supply a valid API version, initialize the message list when requested, and inspect x_return_status before proceeding. Any call that deletes SLL rows — e.g., DELETE_SLL — should be preceded by validation and locking to avoid orphaned stream-level data or concurrent modification. The package is referenced by two other packages in the EBS schema, reinforcing its role as a shared, stable service rather than a private implementation detail.