Search Results populate_operation_plan

Overview

APPS.PQH_DE_OPERATION is a PL/SQL package belonging to the Oracle E-Business Suite Public Sector/HR (PQH) module family, specifically the "DE" (Deutschland / German public sector) component that supports position management and operation planning for German federal and state authorities. In EBS 12.1.1 and 12.2.2, this package encapsulates the server-side logic used to build and maintain "operation" records — the organizational units, jobs, and task workplans that describe how a public sector position hierarchy is structured and staffed. The package is declared with AUTHID CURRENT_USER, meaning its SQL executes under the privileges of the calling session rather than the definer, which is consistent with ETRM APIs intended to be invoked from forms, concurrent managers, or custom code operating with APPS-level access.

The header comment ($Header: pqoprpln.pkh 115.4 2002/12/12) indicates the package specification has been stable since the early 11i era and was carried forward unchanged into 12.1.1 and 12.2.2, a common pattern for localized public sector extensions. The API classification recorded in ETRM is OTHER, reflecting its role as an internal processing package rather than a formally published, externally supported API.

Key Procedures and Functions

The package specification documents three procedures. No functions are exposed.

• INSERT_REC — Creates a single operation record within the hierarchy. It accepts business group, effective date, entity, parent entity, operation group, and transaction type inputs, and returns the newly created hierarchy node identifier, a status value, and an object version number through OUT NOCOPY parameters. This is the low-level row insertion primitive used by higher-level population routines.
• POPULATE_OPERATIONS — Generates or refreshes operation records for a given business group against a validated version of operations, a hierarchy node, a transaction type, and a job number/job identifier combination. It drives bulk creation of operation rows tied to a workplan validation version.
• POPULATE_OPERATION_PLAN — The procedure matched by the user's search term "populate_operation_plan." It takes a workplan validation version ID, a business group ID, and an effective date, and builds the operation plan for that validation version. This is the top-level entry point that orchestrates plan population for a specific workplan validation cycle.

Tables Accessed

ETRM records the following referenced tables via APPS synonyms:

• PQH_DE_OPERATIONS — the primary base table holding operation records; written by INSERT_REC and POPULATE_OPERATIONS.
• PQH_DE_WRKPLC_VLDTN_OPS, PQH_DE_WRKPLC_VLDTN_JOBS, PQH_DE_WRKPLC_VLDTN_JOBFTRS — the workplan validation operations, jobs, and job features tables, which supply the source data the population routines read and against which operations are validated.
• PQH_DE_TATIGKEIT_DETAILS — holds German "Tätigkeit" (activity/task) detail records linked to operations.
• PER_GEN_HIERARCHY_NODES, PER_GEN_HIERARCHY_NODES_S, PER_GEN_HIERARCHY_VERSIONS — the generic hierarchy tables that store the node and version structure into which operations are placed; INSERT_REC returns the hierarchy node ID created here.
• DUAL — used for single-row utility selects.

Usage Notes

ETRM records that this package is referenced by zero other packages, indicating it is invoked directly rather than through a shared wrapper layer. In practice, POPULATE_OPERATION_PLAN is called from the German public sector position/operation maintenance forms or from a concurrent program that rebuilds an operation plan after a workplan validation version is created or amended. INSERT_REC and POPULATE_OPERATIONS are typically reached as subordinate steps within that same flow. Because the API is classified as OTHER and this is a localized extension, custom code should call it cautiously, always within the correct business group context and effective date, and should not assume the same interface stability or upward compatibility guarantees that apply to formally published EBS APIs.