Search Results data_type_name




Overview
Explore in AI Chat

Overview

The APPS.GCS_DATA_TYPE_CODES_PKG package is a public PL/SQL API that manages consolidation data type definitions within the Oracle E-Business Suite Financial Consolidation Hub (GCS) application. Data type codes represent the classifications applied to source and target data during the consolidation process, and they carry the rules that govern balancing, elimination, and consolidation behavior. The package encapsulates the business logic required to create, maintain, and localize these data type code records, allowing the associated attributes, flags, and descriptive text to be managed consistently across the base and translation tables. It is classified as an OTHER type API within ETRM and is owned by the APPS schema.

Key Procedures and Functions

The package exposes five documented procedures and defines supporting record and table types for internal data handling. The r_datatype_info record type and t_datatype_info collection type describe the set of columns managed by the API, including the data type code, balancing enforcement flag, elimination rule flag, consolidation rule flag, and source dataset code.

  • INSERT_ROW — Inserts a new row into the GCS_DATA_TYPE_CODES_B table. Among its documented arguments are data_type_name, which carries the user-facing name of the data type, alongside the identifier, code, rule flags, and standard audit columns.
  • UPDATE_ROW — Updates an existing row in GCS_DATA_TYPE_CODES_B, including the data_type_name and related descriptive and audit attributes. It accepts the row_id for row identification and maintains the object_version_number for concurrency control.
  • LOAD_ROW — Loads a row into the base table, typically invoked by the localization or seed data loading process.
  • TRANSLATE_ROW — Inserts or updates translated descriptive text for a row, targeting the translation table GCS_DATA_TYPE_CODES_TL. This is the mechanism that localizes the data_type_name and description values.
  • ADD_LANGUAGE — Adds a new language row to the translation infrastructure, referencing FND_LANGUAGES to determine installable languages and inserting corresponding translation entries.

Tables Accessed

  • GCS_DATA_TYPE_CODES_B — The base table that stores the core data type code definition, including codes, rule flags, and source dataset references. Written by INSERT_ROW, UPDATE_ROW, and LOAD_ROW.
  • GCS_DATA_TYPE_CODES_TL — The translation table that stores language-specific text such as data_type_name and description. Written by TRANSLATE_ROW and ADD_LANGUAGE.
  • FND_LANGUAGES — The Oracle Applications language repository, queried by ADD_LANGUAGE to identify languages requiring translation rows.
  • DUAL — Used for single-row selection and sequence or value derivation within the package logic.

Usage Notes

The package is typically invoked by the consolidation setup forms and by concurrent programs that seed or localize Data Type Code reference data. The data_type_name argument on INSERT_ROW and UPDATE_ROW belongs to the translation layer, so callers should be aware that naming is language dependent and is maintained through TRANSLATE_ROW and ADD_LANGUAGE rather than the base table alone. Each procedure accepts the full suite of audit columns and the object_version_number, so custom code that calls the API must populate these values appropriately to preserve row versioning semantics. Because the package is referenced by zero other packages, it is intended primarily for direct invocation from forms, concurrent programs, or site-specific extensions rather than as a dependency of other delivered APIs.