Search Results p_mode

Overview

AR_CMGT_DATA_POINTS_PKG is an Oracle Receivables Credit Management (AR_CMGT) package body in the APPS schema. It implements the data point and case folder processing logic used by the Credit Management module. A data point represents a discrete, scored attribute of a credit case — a financial metric, an aging bucket balance, a credit request attribute, or a third-party (D&B) detail. Credit Management evaluates a set of these data points against configured checklists and scoring rules to produce a case folder that drives credit decisions.

The package body contains private helpers such as build_case_folder_details, shown in the source excerpt, which accepts a custom p_mode parameter. When p_mode = 'CREATE' the procedure delegates to AR_CMGT_CONTROLS.populate_case_folder_details to generate case folder details of type 'CASE', and conditionally builds details of type 'DATA' against the global case folder identified by g_data_case_folder_id and g_data_case_folder_exists. The source file carries the header $Header: ARCMGDPB.pls 120.31.12010000.2 2008/09/24 …, and the package uses ar_cmgt_util.get_wf_debug_flag and ar_cmgt_util.wf_debug for diagnostic tracing.

Although the source excerpt exposes the p_mode pattern on the private entry point, the only documented public procedures in the ETRM metadata are GATHER_DATA_POINTS and GETFINANCIALDATA. The API classification is OTHER.

Key Procedures and Functions

• GATHER_DATA_POINTS — Collects the data point values that comprise a credit case. It evaluates the configured data points against the case context and populates the case folder and related detail records so that scoring and checklist evaluation can proceed. This is the primary entry point into the package for case construction.
• GETFINANCIALDATA — Retrieves the financial data used to derive data point values. It returns financial metrics — aging bucket balances, transaction balance summaries and related figures — that the Credit Management scoring engine consumes as data points.

Internally, the body also defines the private procedure build_case_folder_details, which coordinates case folder construction and is governed by the p_mode parameter. Only GATHER_DATA_POINTS and GETFINANCIALDATA are exposed in the documented metadata.

Tables Accessed

• AR_CMGT_CASE_FOLDERS, AR_CMGT_CASE_FOLDERS_S, AR_CMGT_CASE_FOLDER_NUMBER_S — the case folder header and its sequence generator; the persistent anchor for each credit case.
• AR_CMGT_CF_DTLS — case folder detail lines holding individual data point values.
• AR_CMGT_CF_DNB_DTLS — D&B-sourced case folder detail attributes.
• AR_CMGT_CHECK_LISTS, AR_CMGT_CHECK_LIST_DTLS — checklist definitions and lines used to determine whether a data point is included_in_check_list.
• AR_CMGT_FINANCIAL_DATA — stored financial data points referenced by GETFINANCIALDATA.
• AR_CMGT_CREDIT_REQUESTS — credit request records feeding the case.
• AR_CMGT_CURR_USAGE_GT — a global temporary table for current credit usage.
• AR_CMGT_SETUP_OPTIONS — Credit Management system options.
• AR_AGING_BUCKETS, AR_AGING_BUCKET_LINES — aging bucket definitions and balances used to derive overdue metrics.
• AR_TRX_BAL_SUMMARY — transaction balance summary, a source of exposure and overdue amounts.
• AR_CORRESPONDENCES_ALL — correspondence records associated with the credit case.

Usage Notes

The package is invoked from the Credit Management workbench and related concurrent programs when a case is created, refreshed, or scored. It is also referenced by three other packages, indicating it is called programmatically during case folder lifecycle events rather than only from a form.

When diagnosing the p_mode search term, note that p_mode is a private parameter on build_case_folder_details with a default of 'CREATE'; it governs whether the procedure creates new case folder details or updates existing 'DATA' type details via AR_CMGT_CONTROLS. Custom code should prefer the documented public procedures (GATHER_DATA_POINTS and GETFINANCIALDATA) rather than private helpers, since signatures of private procedures are not part of the supported API surface and may change between 12.1.1 and 12.2.2. Set the WF debug flag through ar_cmgt_util.get_wf_debug_flag to enable tracing during case construction.

Because the package writes to Credit Management base tables, changes should be performed through the supported API and committed by the calling program.