Search Results p_customer_name

Overview

VEA_LAYER_LICENSES_SV is a table handler package in the Oracle E-Business Suite 12.1.1 / 12.2.2 environment, owned by the APPS schema. Its stated purpose, as documented in the package header, is to serve as the table handler for the VEA_LAYER_LICENSES table. The package belongs to the ETRM (Enterprise Trade Management) product family, as indicated by the VEA_ prefix and the referenced VEAVALLB.pls source script. Table handler packages in EBS encapsulate the canonical DML operations for a specific base table, providing a controlled API layer so that forms, concurrent programs, and other PL/SQL callers do not issue raw INSERT, UPDATE, and DELETE statements against the underlying table.

Key Procedures and Functions

The documented package body includes a procedure named insert_row. According to the ETRM metadata, no procedures or functions are formally listed in the extracted API inventory, but the source excerpt explicitly shows insert_row. The procedure is designed to insert a single record into the VEA_LAYER_LICENSES table. Based on the visible source, it accepts parameters corresponding to the layer provider code, customer name, description, and trade promotion layer identifier, and it populates the standard WHO columns (created_by, creation_date, last_updated_by, last_update_date, and last_update_login). The user's search term, "p_customer_name", maps directly to the insert_row parameter of the same name, which carries the customer name attribute of the layer license record. The procedure draws audit context from the utility package VEA_TPA_UTIL_PVT, specifically through its get_user_id and get_login_id functions, and it performs error handling via VEA_TPA_UTIL_PVT.add_exc_message_and_raise with the package name and API name passed as arguments. No other documented procedures or functions are present in the supplied metadata.

Tables Accessed

The primary table referenced by this package is VEA_LAYER_LICENSES, which is the target of the insert_row operation. The metadata also lists VEA_LAYERS and VEA_TP_LAYERS as referenced tables accessible through APPS synonyms. VEA_TP_LAYERS is directly represented in the insert_row parameter list through the tp_layer_id column, indicating that a layer license record is associated with a trade promotion layer. VEA_LAYERS provides the broader layer definition context to which layer licenses are tied. Together these tables model the relationship between trade promotion layers, layer providers, and the customer-specific licenses granted against those layers.

Usage Notes

The package is referenced by five other packages within the EBS instance, which indicates it is invoked programmatically rather than being an entry-point API. Typical invocation paths include Oracle Forms based on the VEA_LAYER_LICENSES block, concurrent programs that process or load layer license data, and custom PL/SQL that requires the validated insert semantics provided by insert_row. Because the procedure encapsulates WHO column population and centralized exception logging, callers should use insert_row instead of direct inserts to preserve audit integrity and consistent error reporting. The header comment indicates the package is deployed via the VEAVALHB.pls and VEAVALLB.pls scripts, and that its last recorded version in the source header is 115.9.