Search Results g_dml_update

Overview

APPS.AHL_MC_MASTERCONFIG_PUB is a public PL/SQL package in the Oracle E-Business Suite Discrete Manufacturing or, more precisely, the Oracle Complex Maintenance, Repair, and Overhaul (AHL) product family. Its declared scope is public (API classification PUB), and its display name in the repository is "Master Configuration." The package encapsulates the business logic required to create, modify, and delete Master Configurations, which are hierarchical definitions of complex assets and their component structures used throughout the AHL maintenance, repair, and overhaul modules.

The body begins with the constant G_PKG_NAME set to 'AHL_MC_MasterConfig_PUB'. Two further constants govern the operation performed by the package: G_DML_CREATE ('C'), G_DML_UPDATE ('U'), and G_DML_DELETE ('D'). These literals are passed as an action flag to the single public entry point, so that one procedure dispatches to the appropriate insert, update, or delete logic against the underlying tables. The category assignment of BUSINESS_ENTITY AHL_MASTER_CONFIG confirms that Master Configurations are the primary persistent object managed by this API.

Key Procedures and Functions

The package exposes one documented public procedure:

• PROCESS_MASTER_CONFIG — The central entry point that handles creation, updation, and deletion of Master Configurations based on the flag passed by the caller. It follows the Oracle EBS API standard signature pattern, accepting p_api_version, p_init_msg_list, p_commit, p_validation_level, and p_module_type as standard IN parameters, and returning x_return_status, x_msg_count, and x_msg_data as standard OUT parameters. The action to be taken is selected through the package's DML constants (Create, Update, Delete). No parameter list is invented beyond the documented standard parameters; callers should reference the file specification for the full set of other IN/OUT parameters.

Tables Accessed

The ETRM metadata documents a single referenced table accessed through an APPS synonym: AHL_ITEM_GROUPS_B. This is the base table that stores Master Configuration item group definitions. The package reads from and writes to this table when fulfilling its create, update, and delete operations. Insert and update logic populate the item group definition rows, while delete logic removes them. Because the package is a public API, callers should not manipulate AHL_ITEM_GROUPS_B directly; all maintenance should flow through PROCESS_MASTER_CONFIG to preserve validation, concurrency, and message-stack consistency.

Usage Notes

Because this is a public API, it is intended to be called by other AHL packages, by Oracle Forms-based user interfaces in the Complex MRO module, or by custom code and concurrent programs that need to programmatically maintain Master Configurations. The metadata records that the package is referenced by one other package, confirming that it functions as a shared dependency rather than a standalone utility. When integrating, supply the standard API parameters, set p_commit appropriately for transactional control, and always inspect x_return_status and the message stack after invocation. Following standard EBS API conventions, the G_DML_UPDATE flag is the route exercised whenever a user searches for update-related behavior such as "g_dml_update," which is the constant that selects the modification branch of PROCESS_MASTER_CONFIG.