Search Results create_entity_def_handler

Overview

APPS.OE_DEFAULTING_FWK_PUB is a public PL/SQL package in Oracle E-Business Suite that serves as the runtime code-generation utility for the Order Management defaulting framework. Its principal business function is to generate handler packages that evaluate defaulting rules and constraints for entities and their attributes within Oracle Order Management. Rather than hard-coding default derivation logic, the framework stores defaulting rules and conditions as metadata (in the OE_DEF_* tables) and relies on this package to translate that metadata into executable PL/SQL handler packages.

The package is bound to the shared library OEXDFWKS.pls, with the source header revision 120.0 dated June 2005, and is classified as a PUB (public) API. It is available in both Oracle EBS 12.1.1 and 12.2.2. The package underpins the extensible defaulting architecture used by the Order Management suite, where defaulting rules for order headers, lines, and their attributes are generated and maintained programmatically. Because it is a public package, it is intended for controlled invocation by Oracle forms, concurrent programs, and approved custom extensions rather than as an ad hoc utility.

Key Procedures and Functions

The ETRM metadata documents the following ten procedures:

• CREATE_ENTITY_DEF_HANDLER — Generates a defaulting handler package for a given entity and its attributes, with an optional attribute code to restrict generation to a single attribute or to process the entity in full.
• CREATE_OBJ_ATTR_DEF_HANDLER — Generates the defaulting handler for a specific object attribute, accepting application, database object, attribute and entity identifiers plus a generation level, and returning the generated defaulting API package name.
• ASSIGN — A formatting helper used during code generation to emit an assignment statement, with alignment and right-padding controls.
• PKG_HEADER — Emits the opening header section of a generated PL/SQL package, given the package name and type. This procedure is the direct target of the user search term “pkg_header”.
• PKG_END — Emits the closing section of a generated package.
• PARAMETER — Emits a single parameter declaration within a generated procedure or function signature, supporting mode, type, alignment and first-parameter handling.
• TEXT — Emits a free-text line into the generated source.
• COMMENT — Emits a comment line into the generated source.
• CREATE_ENTITY_DEF_UTIL_HANDLER — Generates the utility handler associated with an entity, using the application short name and an object-level defaulting-enabled flag.
• CREATE_OE_DEF_HDLR — The orchestrating procedure that drives creation of the Order Management defaulting handler package.

The presence of PKG_HEADER, PKG_END, ASSIGN, PARAMETER, TEXT and COMMENT confirms that the package functions as both a generator and a lightweight source-code construction toolkit.

Tables Accessed

The package reads and writes metadata across several documented APPS synonyms:

• AK_OBJECT_ATTRIBUTES, AK_FOREIGN_KEYS, AK_FOREIGN_KEY_COLUMNS, AK_UNIQUE_KEYS, AK_UNIQUE_KEY_COLUMNS — Oracle Application Object Library repository tables supplying attribute and key definitions used to build entity and attribute structures.
• OE_AK_OBJECTS_EXT, OE_AK_OBJ_ATTR_EXT — Order Management extensions that map AK objects and attributes into the defaulting model.
• OE_DEF_ATTR_DEF_RULES, OE_DEF_ATTR_CONDNS, OE_DEF_CONDN_ELEMS — The core defaulting metadata: rules, conditions and condition elements that define how defaults are derived and evaluated.
• FND_APPLICATION — Resolves application identifiers and short names during generation.
• AD_DDL, PLITBLM, USER_ERRORS, USER_OBJECTS — Infrastructure tables used to compile, store and validate the generated handler packages, including retrieval of compile errors.

Usage Notes

OE_DEFAULTING_FWK_PUB is normally invoked indirectly. Defaulting handler packages are generated when defaulting rules are configured or regenerated through Order Management setup, and the generated output is compiled into the database for runtime use. The ASSIGN, PKG_HEADER, PKG_END, PARAMETER, TEXT and COMMENT procedures are internal scaffolding for that generation process and are not intended for direct business use. The metadata records that no other packages reference OE_DEFAULTING_FWK_PUB, indicating it is a top-level generator rather than a shared library dependency.

Custom code should treat this package as read-oriented against AK and OE_DEF metadata and avoid ad hoc regeneration of handlers outside the supported setup flows. Because the framework underpins order defaulting, regeneration should be scheduled during maintenance windows, and any resulting compilation errors should be verified using USER_ERRORS as recorded in the documented table list.