Search Results copy_entity_set

Overview

PSB_ENTITY_SET_PVT is a private (PVT-classified) PL/SQL package in the APPS schema that supports the Oracle Enterprise Resource Planning (ERP) budgeting and financial planning architecture delivered through the Public Sector/Enterprise Planning and Budgeting (PSB) module. Its role centers on the entity set construct, which groups PSB entities — the organizational, financial, or dimensional objects used in budgeting and reporting models — into reusable collections used by planning processes, data extracts, and budget revision workflows.

The package depends directly on FND_API, confirming it participates in the Oracle Application Object Library API conventions (standard error handling, message stacking, and the FND_API.G_MISS_* / FND_API.G_RET_STS_* conventions). It is referenced by PSB_COPY_DATA_EXTRACT_PVT, PSB_WRHR_EXTRACT_PROCESS, and by itself (internal recursion or shared call paths), which indicates that entity set maintenance is a prerequisite step in data extract and warehouse-load (WRHR) processes.

Key Procedures and Functions

The ETRM metadata documents six callable units. None of their parameter lists are published here, so purposes are described at the functional level only.

• INSERT_ROW — Creates a new entity set record (and, where applicable, its association to entities), typically writing to PSB_ENTITY_SET and PSB_ENTITY_S.
• LOCK_ROW — Applies a pessimistic row-level lock on an entity set record before an update or delete, protecting concurrent maintenance by multiple users or concurrent programs.
• UPDATE_ROW — Modifies an existing entity set definition, including membership and descriptive attributes.
• DELETE_ROW — Removes an entity set definition, subject to the reference checks performed by CHECK_REFERENCES.
• COPY_ENTITY_SET — Duplicates an existing entity set, including its associated entity assignments and attribute values, into a new set.
• CHECK_REFERENCES — Validates referential integrity, verifying that an entity set is not referenced by dependent records before allowing deletion or modification.

Tables Accessed

The package reads and writes a substantial set of PSB tables through APPS synonyms:

• Entity set structures: PSB_ENTITY_SET, PSB_ENTITY_S, PSB_ENTITY, PSB_ENTITY_ASSIGNMENT — the core tables holding set headers, the entity master, and the association between entities and sets.
• Attribute support: PSB_ATTRIBUTES, PSB_ATTRIBUTE_VALUES, PSB_ATTRIBUTE_VALUES_S — descriptive flexfield-style attribute storage attached to entities and sets.
• Account position sets: PSB_ACCOUNT_POSITION_SETS, PSB_ACCOUNT_POSITION_SET_LINES — used when entity sets participate in account position definitions.
• Derived planning objects: PSB_CONSTRAINT_FORMULAS(_S), PSB_PARAMETER_FORMULAS(_S), PSB_BUDGET_REVISIONS, PSB_DATA_EXTRACTS, PSB_ACCOUNT_POSITION_SETS — referenced during copy or reference-check operations to ensure dependent formulas, revisions, and extracts remain consistent.

The recurring _S suffix denotes the translated/seed variant of the base table, indicating the package respects Oracle’s multilingual (TL) storage pattern.

Usage Notes

PSB_ENTITY_SET_PVT is a private API, not intended for direct invocation from forms or external callers. It is invoked internally by the PSB data extraction and warehouse-load pipeline, most notably PSB_COPY_DATA_EXTRACT_PVT and PSB_WRHR_EXTRACT_PROCESS, when an extract requires a fresh or duplicated entity set. Standard PSB maintenance forms and concurrent programs that manage entity sets ultimately drive these procedures through the public wrapper layer.

Because the package relies on FND_API error handling, callers should inspect FND_API.G_RET_STS_* return values and the FND message stack rather than relying solely on exceptions. In Oracle EBS 12.1.1 and 12.2.2 the package is VALID and unchanged in classification, but any customization should target documented public packages rather than this PVT unit, since Oracle may modify its internals during patching.