Search Results x_enabled_flag

Overview

AZ_SSET_TAXONOMIES_PKG is a PL/SQL package body owned by the APPS schema in Oracle E-Business Suite, classified as OTHER within the ETRM (E-Business Suite Technical Reference Manual) repository. It provides the low-level data maintenance API for the intersection between taxonomies and selection sets in the Oracle Advanced Product Catalog / taxonomy configuration model. A taxonomy defines a hierarchical classification of catalog content, while selection sets define subsets of items used for reporting, sourcing, or attribute assignment. The relationship between the two is stored as an ordered pairing, with each taxonomy-to-selection-set assignment carrying a sequence number that controls processing or display order and an enabled flag that governs whether the assignment is active. The package encapsulates the insert, update, delete, and load operations required to maintain that relationship, ensuring that the two-part natural key (TAXONOMY_CODE plus SELECTION_SET_CODE) remains consistent and that the standard EBS audit columns are populated on every transaction. The header comment reflects a version of the file maintained under the internal designation azttaxssetb.pls, indicating it belongs to the AZ product family.

The parameter naming convention is directly relevant to the search term x_enabled_flag. Both the INSERT_ROW and UPDATE_ROW procedures expose an X_ENABLED_FLAG parameter, which maps to the ENABLED_FLAG column of the underlying table. This confirms that enablement is managed at the individual taxonomy/selection-set assignment level rather than at a higher grouping level.

Key Procedures and Functions

• INSERT_ROW — Creates a new taxonomy-to-selection-set assignment. In addition to the two key values and the enabled flag, it accepts a sequence number and the standard audit attributes (creation date, created by, last update date, last updated by, last update login). After the insert, the procedure opens an explicit cursor against the row identifier for the new key, fetches the ROWID into the X_ROWID output parameter, and raises NO_DATA_FOUND if the row cannot be located, providing callers with a reliable handle to the newly created record.
• UPDATE_ROW — Modifies the sequence number, enabled flag, and audit columns of an existing assignment, identified by taxonomy code and selection-set code. The procedure raises NO_DATA_FOUND when the update affects no rows, signalling that the target assignment does not exist.
• DELETE_ROW — Removes an assignment. Documented parameters are the taxonomy code and a user identifier, reflecting the pattern of recording the acting user even on deletion.
• LOAD_ROW — Supports the standard EBS loader pattern used for data migration, seed data installation, and patching. It typically attempts an update and falls back to insert (or vice versa) based on whether the row already exists for the given keys.

Tables Accessed

The package operates exclusively against AZ_SELECTION_SET_TAXONOMIES, referenced through the APPS synonym. The insert path writes TAXONOMY_CODE, SELECTION_SET_CODE, SEQ_NUM, ENABLED_FLAG, CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, and LAST_UPDATE_LOGIN. The update path modifies SEQ_NUM, ENABLED_FLAG, and the last-update audit columns, keyed on the combined taxonomy and selection-set codes. The internal cursor selects ROWID from the same table to return the row handle to the caller.

Usage Notes

The package is not referenced by any other documented package, so it functions as a leaf-level API invoked directly by its consumers. In practice it is called from the Oracle Forms UI used to administer taxonomy and selection-set relationships, from concurrent programs that bulk-load or refresh assignment data, and from custom extensions or migration scripts that need to create or retire taxonomy/selection-set links. Because the procedures enforce the natural key and raise NO_DATA_FOUND on failed lookups, callers should include appropriate exception handling. Setting ENABLED_FLAG through this API is the supported way to activate or deactivate a taxonomy-to-selection-set assignment without deleting the underlying configuration.