Search Results create_target

Overview

PQH_GEN_FORM is an internal Oracle E-Business Suite PL/SQL package body owned by APPS that provides generic form-support functionality for the Oracle Human Resources (PQH) product family, most notably the HR Copy Entity feature used by forms such as "Copy Position" and related entity-copying flows. The package header comment explicitly designates the object as "Internal Use Only" and describes its role as handling "internal Generic form support functionalities." It was created by Sanej Nair and carries a header version of 120.2 dated 26-Aug-2006, with an initial 115.0 version dated 27-Feb-2000. In EBS 12.1.1 and 12.2.2 the package remains an unreleased, internal-use object; it is not a public API and is not documented for customer extension. Its principal business purpose is to build and maintain the staging, source, and target records that a form requires when a user copies an entity from a source context to a target context, including the dynamic SQL generation needed to select source rows and insert target rows.

Key Procedures and Functions

The package exposes 25 documented procedures and functions. The core copy-entity lifecycle is handled by CREATE_SOURCE, which creates the source records for a copy transaction and can also estimate the number of rows likely to be retrieved; COUNT_SOURCE and RECOUNT_SOURCE, which determine and re-determine the source row counts; UPDATE_SOURCE, which modifies existing source staging rows; and CREATE_TARGET, the procedure corresponding to the user's search term, which generates the target-side records that result from a completed copy operation. DELETE_SOURCE removes staged source rows, while FLIP_SELECTION toggles the selection state of source rows in the form.

Supporting routines include GET_SQL_FROM_VSET_ID, which derives SQL text from a value set identifier; GET_VALUE_FROM_ID and GET_ID_FROM_VALUE, which translate between flex value identifiers and their displayed meanings; POPULATE_PREFS, which loads copy-entity preference data; and POPULATE_CONTEXT, which populates context business group and transaction context information. GET_LEGISLATION_CODE and GET_ALR retrieve legislation and associated legislative information for the transaction. CHK_TRANSACTION_CATEGORY and GET_TRANSACTION_TYPE validate and resolve the transaction category and type driving the copy. GET_LOOK performs lookup meaning resolution, MY_CON is a session/context helper, and KF is a key-flexfield utility. CHECK_ID_FLEX_STRUCT validates the key flexfield structure used by the copied entity.

Tables Accessed

The package operates primarily against the PQH copy-entity staging schema and Oracle Application Object Library metadata tables. PQH_COPY_ENTITY_TXNS holds the copy transaction header, and PQH_COPY_ENTITY_RESULTS stores outcome rows; PQH_COPY_ENTITY_ATTRIBS and PQH_COPY_ENTITY_CONTEXTS define the attributes and contexts eligible for copying, while PQH_COPY_ENTITY_FUNCTIONS and PQH_COPY_ENTITY_PREFS drive function-level and user preference behavior. PQH_TRANSACTION_CATEGORIES and PQH_ATTRIBUTES supply transaction and attribute definitions. FND_SESSIONS provides session identifiers for the current form session. Key flexfield validation and value resolution draw on FND_FLEX_VALUE_SETS, FND_ID_FLEX_STRUCTURES, FND_ID_FLEX_SEGMENTS, and FND_COMPILED_ID_FLEX_STRUCTS, while FND_APPLICATION and FND_RESPONSIBILITY resolve application and responsibility context.

Usage Notes

PQH_GEN_FORM is invoked internally by Oracle HRMS forms and by the copy-entity framework rather than by customer code. The ETRM metadata records that it is referenced by one other package, confirming its role as a subordinate utility within the PQH copy-entity stack. In 12.1.1 and 12.2.2 it should be treated as an unsupported internal object: customizations should not call CREATE_TARGET or the other procedures directly, because signatures and behavior are subject to change without notice. Where copy-entity behavior must be extended, the supported approach is to use the documented HRMS APIs and form personalization rather than wrapping this package. Its tables, particularly PQH_COPY_ENTITY_TXNS and PQH_COPY_ENTITY_RESULTS, remain useful for diagnostic queries when troubleshooting failed or incomplete copy operations.