Results for “hr_dm_gen_tups”
34 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
HR_DM_GEN_TUPS is a PL/SQL package in the APPS schema that forms part of Oracle E-Business Suite's HR Data Migration (HR_DM) framework. The HR_DM modules support the bulk loading, staging, and transformation of human resources data — including hierarchies, tables, and column metadata — during implementation or large-scale data conversion projects. Rather than exposing a general-purpose API to end users, HR_DM_GEN_TUPS serves as an internal generation utility within that framework. Its role is to dynamically construct and manage "TUPS" (table update/processing structures) used by the HR data migration engine to carry out set-based operations against staged HR data.
The package has a VALID status in the ETRM registry and is classified under the generic API category OTHER, reflecting that it is a supporting internal component rather than a published public interface. It is tightly coupled to the broader HR_DM library and generation architecture, as evidenced by its dependency relationships.
Key Procedures and Functions
The documented metadata exposes a single procedure:
- CREATE_TUPS_PACAKGE — The sole documented procedure, responsible for generating a TUPS package (the name carries an intentional typographic variant of "PACKAGE"). Its purpose is to dynamically build a PL/SQL package containing the structures and logic required by the HR data migration process to operate against the relevant tables derived from HR_DM metadata. Because the metadata does not document a parameter list for this procedure, no signature is asserted here; only its generative purpose is confirmed.
Tables Accessed
The package references several tables and resources through APPS synonyms and built-in utilities:
- HR_DM_TABLES — Stores metadata describing the tables participating in the HR data migration, and is the primary source from which TUPS generation is driven.
- HR_DM_HIERARCHIES — Holds hierarchy definitions used to determine structural relationships among migration entities.
- ALL_TAB_COLUMNS — Provides runtime column definitions for the target tables, enabling the package to generate column-aware code dynamically.
- FND_ORACLE_USERID — Supplies Oracle user identity information referenced during generation.
- DBMS_SQL — Oracle's dynamic SQL package, used to parse, execute, and manage the dynamically generated SQL and PL/SQL produced by the utility.
- PLITBLM — A PL/SQL internal table type used to hold PL/SQL source text in memory while the generated package is assembled.
Usage Notes
HR_DM_GEN_TUPS is not intended for direct invocation by end users or standard application flows. It is called programmatically by HR_DM_GEN_MAIN, which orchestrates the HR data migration generation process. The package also references HR_DM_LIBRARY for shared utility routines, and is referenced by HR_DM_GEN_MAIN and by itself, confirming its role as an internal, reusable generation component.
In practice, this package executes during HR data migration setup and regeneration activities, typically as a background step triggered by the HR_DM driver processes rather than by a concurrent program or form directly. Administrators performing HR data conversion would invoke the higher-level HR_DM framework; HR_DM_GEN_TUPS would then be exercised implicitly to produce the required TUPS artifacts. Because it relies on DBMS_SQL and dynamic package generation, it must be executed with appropriate privileges in the APPS schema and is sensitive to the state of HR_DM metadata tables. The identical object structure is expected across EBS 12.1.1 and 12.2.2, with the online patching architecture of 12.2.x affecting editioning considerations but not the package's functional role.
-
PACKAGE: APPS.HR_DM_GEN_TUPS 12.1.1
-
PACKAGE: APPS.HR_DM_GEN_TUPS 12.2.2
-
PACKAGE: APPS.HR_DM_GEN_TUPS 12.2.2
-
PACKAGE: APPS.HR_DM_GEN_TUPS 12.1.1
-
SYNONYM: APPS.HR_DM_TABLES 12.1.1
-
SYNONYM: APPS.HR_DM_TABLES 12.2.2
-
PACKAGE: APPS.HR_DM_GEN_MAIN 12.1.1
-
PACKAGE: APPS.HR_DM_GEN_MAIN 12.2.2
-
SYNONYM: PUBLIC.DBMS_SQL 12.2.2
-
SYNONYM: PUBLIC.DBMS_SQL 12.1.1
-
SYNONYM: PUBLIC.PLITBLM 12.1.1
-
SYNONYM: PUBLIC.PLITBLM 12.2.2
-
12.2.2 DBA Data 12.2.2
-
12.2.2 DBA Data 12.2.2
-
12.1.1 DBA Data 12.1.1
-
12.1.1 DBA Data 12.1.1