Search Results get_to_coa_id




Overview
Explore in AI Chat

Overview

GL_CONS_SEGMENT_ACTIONS_PKG is an Oracle E-Business Suite PL/SQL package owned by the APPS schema and defined with AUTHID CURRENT_USER. Its documented purpose is to provide the procedures that support the Chart of Accounts Mapping Setup form, specifically the Segment Actions block used during consolidation configuration. Chart of Accounts Mapping allows a parent or consolidation set of books to translate the segment values of a source (from) chart of accounts into the corresponding segment values of a target (to) chart of accounts. This package encapsulates the database operations that back the Segment Actions region of that setup form, including the insertion, locking, updating, and deletion of segment mapping rules stored in GL_CONS_SEGMENT_MAP, as well as helper logic for validation and defaulting of chart of accounts identifiers.

The package header history records an original creation date of 19-Feb-97, making it one of the original General Ledger consolidation components. Its last recorded header revision is version 120.5, dated 2005/05/05. Because it is an API-style package used primarily by the Forms layer, it is classified as OTHER rather than as a public open interface.

Key Procedures and Functions

The ETRM metadata documents eleven callable units. The core DML procedures correspond directly to the table columns of GL_CONS_SEGMENT_MAP:

  • INSERT_ROW — Inserts a new segment mapping record into GL_CONS_SEGMENT_MAP, accepting the table columns as arguments and returning the generated surrogate key and row identifier.
  • LOCK_ROW — Obtains a row-level lock on a GL_CONS_SEGMENT_MAP record, supporting Forms optimistic locking behavior.
  • UPDATE_ROW — Updates an existing segment mapping record.
  • DELETE_ROW — Removes a segment mapping record.
  • CHECK_DUPLICATE_RULES — Detects duplicate or conflicting mapping rules within the Segment Actions block to prevent ambiguous consolidation mappings.
  • GET_VALIDATION_TYPE — Returns the validation type applicable to a mapping rule, governing how source values are matched (for example, exact or parent rollup).
  • SET_CRITERIA — Establishes the criteria used to evaluate segment mapping during validation and querying.
  • VALIDATE_FROM_SEGMENT — Validates the source segment value specified in a mapping rule against the source chart of accounts.
  • GET_COA_MAPPING_ID — Resolves the chart of accounts mapping identifier for the mapping currently being edited.
  • GET_TO_COA_ID — Retrieves the target chart of accounts identifier associated with the mapping.
  • GET_FROM_COA_ID — Retrieves the source chart of accounts identifier, the value sought by users who search on "get_from_coa_id". This function is commonly used by form triggers and custom code to establish the from chart of accounts context before validating segment values.

Tables Accessed

The package references the following APPS synonyms:

  • GL_CONS_SEGMENT_MAP and GL_CONS_SEGMENT_MAP_S — the primary segment action mapping table and its sequence, read and written by the DML procedures.
  • GL_CONS_FLEX_HIERARCHIES — defines parent rollup hierarchies used when validating rollup mappings.
  • FND_FLEX_VALUE_SETS — the source and target value sets that constrain valid segment values on each side of the mapping.
  • DUAL — used for singular lookups and function return scaffolding.

Usage Notes

The package is invoked primarily by the Chart of Accounts Mapping Setup form whenever a user enters, changes, or deletes a line in the Segment Actions block. Form triggers call the DML procedures directly, while validation triggers invoke the GET_* and VALIDATE_* helpers. Because it is referenced by one other package, it may also be called from consolidation processing code that needs to resolve mapping identifiers. Custom code should call the GET_FROM_COA_ID, GET_TO_COA_ID, and GET_COA_MAPPING_ID functions rather than querying the underlying tables directly, to preserve the validation behavior established by the form.