Search Results ahl_mc_masterconfig_pub




Overview
Explore in AI Chat

Overview

APPS.AHL_MC_MASTERCONFIG_PVT is a private PL/SQL package within the Oracle E-Business Suite Advanced Product Catalog / Oracle Configurator foundation schema (the AHL module, historically associated with Oracle Product Lifecycle Management and Configure-to-Order functionality). The package encapsulates the business logic responsible for the lifecycle management of Master Configurations — the reusable, versioned definitions of a configured product or asset structure that serve as the authoritative template for a model's allowable options, relations, and item groupings.

The _PVT suffix indicates this is a private package: it is not intended to be called directly by external consumers. Instead, it is invoked by the public API layer (typically AHL_MC_MASTERCONFIG_PUB or equivalent) and by internal workflow or concurrent processing logic. The package header defines the standard Oracle API conventions, including an API version constant, initialization message list flags conforming to FND_API.G_FALSE, and DML operation mode constants (G_DML_CREATE, G_DML_UPDATE, G_DML_DELETE, G_DML_COPY) used to drive the multi-purpose processing routines. A Header_Rec_Type record type models the master configuration header, carrying the primary key (MC_HEADER_ID), descriptive attributes, version and revision tracking, model code/meaning, a defaulted CONFIG_STATUS_CODE of 'DRAFT', an optimistic locking column (OBJECT_VERSION_NUMBER), security group partitioning, and the standard 15 attribute columns reserved for extensibility. The header comment references an "Enigma code changes" modification dated 26-Aug-2008, reflecting historical enhancements to the model handling logic.

Key Procedures and Functions

  • CREATE_MASTER_CONFIG — Creates a new Master Configuration header together with its associated top node. This is the entry point for establishing a fresh configuration template, initializing the header in DRAFT status.
  • MODIFY_MASTER_CONFIG — Applies updates to an existing Master Configuration header, enforcing optimistic concurrency through the object version number.
  • DELETE_MASTER_CONFIG — Removes a Master Configuration and its dependent structures, cascading through the relation and position key tables.
  • COPY_MASTER_CONFIG — Duplicates an existing Master Configuration, producing a new header, top node, and copied relation set, typically to seed a new model variant.
  • CREATE_MC_REVISION — Generates a new revision of an existing Master Configuration, supporting the versioning scheme visible in the header record (VERSION_NUMBER, REVISION).
  • REOPEN_MASTER_CONFIG — Transitions a configuration out of a locked or approved state back into an editable status, allowing further changes.
  • INITIATE_MC_APPROVAL — Kicks off the approval workflow for a Master Configuration, advancing its lifecycle status and submitting it for sign-off.

Tables Accessed

Usage Notes

As a private package, AHL_MC_MASTERCONFIG_PVT is not invoked directly from concurrent program registrations or the user interface. It is reached through the public Master Configuration API and is referenced by four other packages in the AHL schema, which delegate their header manipulation logic to these procedures. Oracle Forms and OAF-based configuration workbenches call the public layer, which in turn invokes these private routines to persist header and top-node changes. Custom extensions should call the public API rather than this package to preserve validation, concurrency, and workflow semantics.