Search Results fnd_svc_comp_param_vals_s

Overview

The APPS.FND_SVC_COMP_PARAM_VALS_PKG package body is the implementation of a low-level data maintenance API within the Oracle E-Business Suite service component framework. It is a member of the FND_SVC_* family of packages that collectively support the Service Components feature, which allows administrators to define configurable business entities whose runtime behavior is driven by parameter values stored in the database. The package is responsible for the persistence and lifecycle management of rows in the FND_SVC_COMP_PARAM_VALS table, which holds the individual parameter values assigned to a given service component instance. Because it exposes standard transactional operations rather than high-level business rules, the package is best understood as a table maintenance layer used by concurrent programs, forms, and internal service component processing logic. In Oracle EBS 12.1.1 and 12.2.2, the object is documented as VALID in the APPS schema and is classified under the ETRM API classification of OTHER, indicating that it is not a public, externally supported API but an internal building block of the service components subsystem.

Key Procedures and Functions

ETRM documents five procedures or functions within this package body. Their names follow the classic Oracle Forms-generated table handler pattern:

• INSERT_ROW — Inserts a new parameter value record into FND_SVC_COMP_PARAM_VALS, populating the standard WHO columns and any identifying keys required by the table.
• LOCK_ROW — Acquires a row-level lock on an existing parameter value record, typically used to serialize concurrent modifications before an update or delete.
• UPDATE_ROW — Modifies the attributes of an existing parameter value row, including the stored value and its associated audit columns.
• DELETE_ROW — Removes a parameter value record from the table.
• LOAD_ROW — Retrieves a parameter value row and populates a caller-supplied record structure, functioning as the read path for the table handler.

No parameter lists are documented in the ETRM metadata, so the precise signatures should be confirmed against the deployed source.

Tables Accessed

The documented dependencies show that the package interacts with several related objects:

• FND_SVC_COMP_PARAM_VALS — the primary table holding parameter values; the target of INSERT_ROW, UPDATE_ROW, DELETE_ROW and LOAD_ROW.
• FND_SVC_COMP_PARAM_VALS_S — the corresponding sequence used to generate surrogate keys for new rows. This is the object referenced by the user search term fnd_svc_comp_param_vals_s.
• FND_SVC_COMP_PARAMS_B — the base parameter definition table, validated when a value is inserted or updated.
• FND_SVC_COMPONENTS — the parent service component table, providing context for the parameter values.
• DUAL — used for sequence lookups and simple scalar queries.

Utility dependencies include WF_CORE, WF_EVENTS_PKG, DBMS_STANDARD, and STANDARD, indicating that row changes may trigger workflow events or use standard error-raising conventions.

Usage Notes

Because FND_SVC_COMP_PARAM_VALS_PKG is not referenced by any other database object per ETRM (though the metadata notes it is referenced by one other package), it is intended to be invoked directly by external callers rather than as a dependency of higher-level APIs. Typical invocation points include Oracle Forms-based maintenance screens for service components, concurrent programs that seed or migrate service component configuration, and custom PL/SQL extensions that need to create or amend parameter values programmatically. When calling these procedures from custom code, developers should perform their own validation, manage commits explicitly, and preserve the WHO audit columns. Given its classification as OTHER, the package is subject to change between releases and should be used with caution in any customization that must remain upgrade-safe across 12.1.1 and 12.2.2.