Search Results check_dm_binvalues_items

Overview

APPS.AMS_DM_BINVALUES_PVT_W is a private PL/SQL wrapper package within the Oracle EBS Advanced Marketing (AMS) module, specifically serving the Demand Manager (DM) bin values infrastructure. The package acts as a Web/UI-facing wrapper layer (indicated by the "_W" suffix) around the AMS_DM_BINVALUES_PVT package, exposing its business logic to the Oracle Application Framework (OAF) and related Java/BC4J-based pages. Its principal responsibility is to provide an interface for creating, updating, validating, and copying demand manager bin value records, which represent the discrete value buckets used in demand analysis, forecasting, and segmentation within the marketing and demand planning processes. The package is declared with AUTHID CURRENT_USER, meaning it executes with the privileges of the invoking schema rather than the definer, consistent with Oracle's standard wrapper conventions.

The header comment (revision 115.3, dated 2002/12/09) indicates the package originated in an early 11i-era code line and has been carried forward largely unchanged into EBS 12.1.1 and 12.2.2. It is classified as API type OTHER, and it is not directly referenced by any other documented package, confirming its role as a leaf-level wrapper invoked primarily through the user interface layer.

Key Procedures and Functions

• ROSETTA_TABLE_COPY_IN_P3 — Translates a set of flat JTF collection tables (number, date, and varchar2 table types) into the strongly typed PL/SQL table structure ams_dm_binvalues_pvt.dm_binvalues_tbl_type. This facilitates the transfer of bulk row data from Java/EJB layers into PL/SQL.
• ROSETTA_TABLE_COPY_OUT_P3 — Performs the inverse operation, unpacking the typed PL/SQL table back into the JTF_NUMBER_TABLE, JTF_DATE_TABLE, and JTF_VARCHAR2_TABLE_200 collections expected by the caller.
• CREATE_DM_BINVALUES — Creates a new demand manager bin value record, accepting the standard FND_API parameters (API version, message list initialization, commit flag, validation level) plus the bin value column attributes, and returning the new bin value identifier along with standard return status and message outputs.
• UPDATE_DM_BINVALUES — Modifies an existing bin value record using the same FND_API calling convention and message-handling pattern.
• VALIDATE_DM_BINVALUES — Applies entity-level validation rules to a bin value record prior to creation or update.
• CHECK_DM_BINVALUES_ITEMS — Validates the individual item or bucket assignments associated with a bin value set, ensuring referenced items are valid and consistent with the bin value definition. This is the procedure most commonly searched for by users diagnosing bin value configuration errors.
• VALIDATE_DM_BINVALUES_REC — Performs record-level validation, likely checking uniqueness and mandatory column constraints on the bin values row itself.

Tables Accessed

The documented metadata lists PLITBLM as the sole referenced table via an APPS synonym. PLITBLM is a standard Oracle EBS tooling table used by the Rosetta/table-copy infrastructure for temporary storage and marshalling of collection data between the Java middle tier and the PL/SQL layer. The actual persistence of bin value rows is delegated to the underlying AMS_DM_BINVALUES base tables through the _PVT package, which this wrapper calls; no direct DML against business tables is exposed in this wrapper layer itself.

Usage Notes

This package is not intended for direct invocation by end users or custom concurrent programs. It is typically called from OAF pages, JSP/BC4J view objects, or the older JTF-based web UI when users maintain demand manager bin value definitions. Because the wrapper relies on JTF collection types and the Rosetta copy-in/copy-out pattern, customizations should call the underlying AMS_DM_BINVALUES_PVT package rather than this wrapper. When troubleshooting errors surfaced by check_dm_binvalues_items, the returned FND_API message stack should be read via the standard message-handling utilities.