Search Results ar_cmgt_data_points_s

Overview

AR_CMGT_DP_TABLE_HANDLER is an Oracle EBS PL/SQL package body owned by the APPS schema that supports the Credit Management (AR_CMGT) data point infrastructure. Its purpose is to manage rows within the Credit Management data points entity, which stores the configurable scoring parameters used by Oracle Credit Management to evaluate customer creditworthiness. The package provides the classic EBS "table handler" pattern of DML and translation routines used by the Oracle Application Object Library (AOL) and the Application Programming Interface (API) generation framework.

Because the object is a PACKAGE BODY with status VALID, the specification and body compile cleanly, and the ETRM classifies the API as OTHER rather than a public or private stub. The package encapsulates row-level insert, update, delete, and language/translation operations against the AR_CMGT_DATA_POINTS_B, _S, and _TL tables, shielding callers from the underlying multi-table structure.

Key Procedures and Functions

ETRM documents ten procedures and functions in this package body:

• INSERT_ROW — Inserts a new data point row across the base and security (S) tables, establishing a new scoring data point.
• INSERT_ADP_ROW — Performs the insert variant used by the ADP (Application Data Point) loader path.
• UPDATE_ROW — Modifies an existing data point record's attribute values.
• UPDATE_ADP_ROW — Update counterpart for ADP-sourced data point rows.
• DELETE_ROW — Removes a data point row and its dependent translation/security records.
• ADD_LANGUAGE — Inserts a new language row into the translation (_TL) table for an existing data point.
• TRANSLATE_ROW — Updates or populates translated (language-specific) descriptions in the _TL table.
• LOAD_ROW — Load-interface routine that inserts or syncs a data point from an external seed/loader source.
• LOAD_ADP_ROW — Load routine specific to ADP data point definitions.
• TRANSLATE_ADP_ROW — Translation routine for ADP data point rows.

Tables Accessed

The package references the following documented tables via APPS synonyms:

• AR_CMGT_DATA_POINTS_B — Base (language-independent) table holding the core data point definition; written by INSERT_ROW and UPDATE_ROW.
• AR_CMGT_DATA_POINTS_S — Security/intersection table governing which data points are visible to which operating units or responsibility contexts.
• AR_CMGT_DATA_POINTS_TL — Translation table storing language-specific names and descriptions; managed by ADD_LANGUAGE and TRANSLATE_ROW.
• FND_LANGUAGES — Read to validate installed languages and drive translation inserts.
• DUAL — Utility source used for single-row lookups and sequence/identity checks.

Usage Notes

This package is not a public API intended for direct external calls. It is referenced by one other documented package, meaning it operates as an internal handler consumed by a higher-level Credit Management component rather than by customer forms or concurrent programs directly. The INSERT_ADP_ROW, UPDATE_ADP_ROW, LOAD_ADP_ROW, and TRANSLATE_ADP_ROW procedures indicate a parallel loader path for Application Data Point definitions that flow through the Credit Management configuration framework.

Typical invocation surfaces include Oracle Credit Management setup screens and any ADP import/concurrent process that seeds data points. Customizations should avoid calling these handler procedures directly and instead use the prerequisite APIs on AR_CMGT_DATA_POINTS_B, which ENFORCE validation, WHO-column auditing, and consistent cross-table writes. Because the package is a body with no public interface, direct references from custom code risk breakage across patch upgrades. Support the object through the standard Oracle patch and AD utilities.