Search Results per_gen_hierarchy_nodes_s

Overview

APPS.PQH_DE_OPERATION is a PL/SQL package body that supports the Oracle E-Business Suite Human Resources (formerly Oracle HRMS) "Public Sector/Deutschland" (DE) localization, specifically the operation plan (Operationsplan / Betriebsablauf) functionality used for German public-sector workforce planning. It is part of the PQH family of packages that maintain data held in the PER_GEN_HIERARCHY_NODES and PER_GEN_HIERARCHY_VERSIONS generic hierarchy structures, together with the German-specific tables PQH_DE_OPERATIONS and its associated validation and task-detail tables. The package's principal business role is to insert and populate operation records — and the operation plan hierarchy nodes that represent them — within a hierarchical planning version. The header comment (pqoprpln.pkb 115.9, dated 2002/12/12) indicates a long-standing object carried forward through EBS 12.1.1 and 12.2.2. It is classified as an "OTHER" API, meaning Oracle does not publish it as a supported external interface; it is intended for internal use by the DE localization forms and processes.

Key Procedures and Functions

The documented API exposes three callable units:

• INSERT_REC — The core insertion routine. It creates a new node in the generic hierarchy for an operation, resolving the operation group, hierarchy version, node type (OPR_OPTS or OPR_JOB_DTLS), parent node, and sequence number before writing to PER_GEN_HIERARCHY_NODES. The excerpt shows it accepts a business group, effective date, entity identifier, parent entity, operation group, transaction type and several OUT parameters (hierarchy node ID, status and object version number). Notably, when the transaction type is not 'O', the procedure attempts to locate a parent entity through a cursor joining PQH_DE_OPERATIONS; if none is found it sets status to 'N' and returns without inserting.
• POPULATE_OPERATIONS — Drives population of operation data, creating or refreshing the operation records and their hierarchy representations. It handles the bulk creation of operation nodes associated with an operation plan.
• POPULATE_OPERATION_PLAN — Builds the overall operation plan structure, coordinating generation of the hierarchy version and the operation nodes that belong to it.

Tables Accessed

The package reads and writes the following documented synonyms:

• PER_GEN_HIERARCHY_NODES and PER_GEN_HIERARCHY_NODES_S — the generic hierarchy node table and its sequence; INSERT_REC selects the next hierarchy node ID here and inserts the new operation node, deriving node type, parent node, and sequence.
• PER_GEN_HIERARCHY_VERSIONS — supplies the hierarchy version ID that governs the node being created.
• PQH_DE_OPERATIONS — the German operation master table; joined against hierarchy nodes to resolve a parent entity and to hold operation records.
• PQH_DE_TATIGKEIT_DETAILS — task/detail records linked to operations, written during population.
• PQH_DE_WRKPLC_VLDTN_JOBS, PQH_DE_WRKPLC_VLDTN_OPS, and PQH_DE_WRKPLC_VLDTN_JOBFTRS — validation tables for workplaces, operations and job factors, consulted to validate operation-plan data.
• DUAL — used for sequence retrieval.

Usage Notes

PQH_DE_OPERATION is an internal implementation package. It is not referenced by any other documented package, and its classification as OTHER confirms that Oracle does not support direct customer invocation. In practice it is called from the German public-sector operation-plan forms and from the concurrent processes that populate and regenerate operation plans. Because the package manipulates generic hierarchy structures directly, custom code should avoid embedding calls to INSERT_REC, POPULATE_OPERATIONS or POPULATE_OPERATION_PLAN; instead, the supported operation forms or the DE localization APIs should be used, so that the hierarchy, sequence and validation logic remains consistent with the rest of the PER_GEN_HIERARCHY framework.