Search Results add_dml_delete_stmt
Overview
FND_OAM_DSCFG_API_PKG (Data Scramble Configuration API Package) is a server-side PL/SQL package that belongs to the Oracle Applications Manager (OAM) data scrambling framework within Oracle E-Business Suite. Its business function is to manage the configuration metadata that governs how production data is masked, scrambled, or cloned during controlled operations. Data scrambling is used when EBS administrators need to create a non-production copy of an instance while protecting sensitive information such as personal identifiers, financial data, or credentials.
The package is the programmatic backbone that defines configuration instances, records which database objects participate in a scramble run, stores properties associated with those objects, and assembles the SQL and PL/SQL statements that will ultimately be executed. Because it is an API package, it is deliberately designed to be largely stateless, as noted in the body comments. All meaningful state is persisted in the underlying configuration tables rather than held in package variables, allowing the OAM configuration UI and concurrent programs to call the package from any session.
Key Procedures and Functions
The package exposes approximately thirty documented procedures and functions. Their names map directly onto the configuration lifecycle:
- ARE_CONFIG_CHANGES_ALLOWED — verifies, via the OAM_DSCRAM_ENABLED and OAM_DSCRAM_ALLOWED profile options, that scrambling is both licensed and permitted before any configuration change proceeds.
- Configuration instance management — ADD_CONFIG_INSTANCE, SET_CURRENT_CONFIG_INSTANCE, GET_CURRENT_CONFIG_INSTANCE_ID, and IS_CONFIG_INSTANCE_INITIALIZED establish and query the active configuration container.
- Object registration — ADD_OBJECT, ADD_RUN_OBJECT, ADD_BUNDLE_OBJECT, ADD_ERRORED_OBJECT, and GET_OBJECTS_FOR_TYPE register the database objects (tables, packages, and so on) that form the scramble scope and classify them for processing.
- DML segment builders — ADD_DML_UPDATE_SEGMENT, ADD_DML_DELETE_STMT, and ADD_DML_TRUNCATE_STMT construct the individual UPDATE, DELETE, and TRUNCATE fragments that comprise a scramble script.
- ADD_PLSQL_TEXT — the procedure relevant to the user search term. It appends a PL/SQL text block to the configuration being assembled, allowing custom masking logic to be attached to an object.
- Property management — ADD_PROPERTY and ADD_OBJECT_PROPERTY record key/value metadata against objects and configurations.
- Status and navigation — GET_CURRENT_PROC_ID, GET_CURRENT_POLICYSET_ID, GET_CURRENT_TARGET_TABLE_LIST, and GET_NEXT_PROC return the current processing context and the ordered list of procedures to be executed.
Tables Accessed
The package reads and writes configuration through the APPS synonyms FND_OAM_DSCFG_OBJECTS, which stores the objects registered for scrambling along with their type and processing properties, and FND_OAM_DSCFG_PROPERTIES, which stores the property name/value pairs attached to configurations and objects. Dynamic SQL used to build and execute segment text is handled through the DBMS_SQL package rather than through a repository table.
Usage Notes
FND_OAM_DSCFG_API_PKG is invoked by the OAM Data Scrambling configuration screens and by the concurrent programs that build and execute scramble definitions. It is referenced by six other packages, indicating it is a foundational layer rather than an end-user entry point. Customizations that extend scrambling behavior—particularly those calling ADD_PLSQL_TEXT to inject masking logic—should invoke the package only after confirming that ARE_CONFIG_CHANGES_ALLOWED returns true, so that profile-based enablement and production safeguards are respected.