Search Results hr_dm_gen_tds




Overview
Explore in AI Chat

Overview

The APPS.HR_DM_GEN_TDS package body is a component of Oracle E-Business Suite's HR Data Migration (DM) framework, a set of utilities used to migrate legacy human resources data into Oracle HRMS. The "TDS" naming convention refers to "Table Data Source" or table-driven definition structures that the migration generator uses to construct dynamic SQL statements at runtime. The package operates within the APPS schema and carries a VALID status in both Oracle EBS 12.1.1 and 12.2.2.

Its core business function is to programmatically build and manage the TDS package structures that drive HR data migration transformations. Rather than issuing static SQL, the package assembles dynamic SQL fragments from metadata stored in HR_DM_TABLES and HR_DM_MIGRATIONS, then generates PL/SQL package code that the migration engine executes during conversion runs. This makes HR_DM_GEN_TDS a generator utility rather than a run-time transaction processor: it is invoked during migration setup and generation phases, not during routine payroll or HR processing.

Key Procedures and Functions

The documented API surface comprises two procedures/functions classified as OTHER:

  • CREATE_TDS_PACAKGE — Generates the TDS package body for a given migration. It reads table and migration metadata and emits the corresponding PL/SQL source, which is dynamically compiled for use by the HR data migration engine. (The spelling of the identifier reflects the delivered Oracle source.)
  • GET_CURSOR_FROM_CLAUSE — Returns the FROM-clause fragment used to construct the dynamic cursor or query that a TDS definition drives. It derives this clause from migration and table metadata so the generated SQL references the correct HR objects and hierarchies.

Both routines depend on DBMS_SQL for dynamic statement handling and on the supporting HR_DM_LIBRARY, HR_DM_UTILITY, and HR_DM_GEN_MAIN packages for shared parsing, error logging, and orchestration.

Tables Accessed

The package reads metadata from the following documented tables, accessed via APPS synonyms:

  • HR_DM_TABLES — Stores the table-level definitions (source tables, columns, and aliases) used to assemble generated SQL and TDS package content.
  • HR_DM_MIGRATIONS — Holds migration and business-group context that determines which TDS definitions are generated and how FROM clauses are composed.
  • HR_DM_HIERARCHIES — Provides hierarchy and organization-structure information used when the generated cursor must traverse HR hierarchies.
  • DBMS_SQL and PLITBLM — Oracle-supplied packages leveraged for dynamic cursor construction and PL/SQL table handling (PLITBLM is the underlying implementation of associative array functionality).

Usage Notes

HR_DM_GEN_TDS is not exposed directly to end users through Oracle HRMS forms. It is invoked as part of the HR Data Migration generation workflow, typically from the migration setup screens or from the concurrent processes that compile and validate migration definitions. It cooperates closely with HR_DM_GEN_MAIN, which orchestrates generation across the various DM generator packages, and with HR_DM_IMP_BG_WHERE, which supplies business-group WHERE-clause filtering.

The ETRM metadata records that HR_DM_GEN_TDS is referenced by two other database objects, while it is not referenced by any object outside the HR_DM family. This confirms that it is an internal utility of the data migration toolkit rather than a general-purpose API. Consultants customizing migrations may call it when regenerating TDS packages after modifying HR_DM_TABLES or HR_DM_MIGRATIONS rows, but direct invocation should be limited to migration development and refresh cycles, since generated packages are otherwise managed by the DM framework itself.