Search Results default_entity

Overview

ASO_DEFAULTING_INT is an internal PL/SQL package in the APPS schema that supports the Oracle EBS Order Capture / Quoting (ASO) defaulting framework. Its documented purpose is to default attribute values onto quote entities before those entities are persisted to their underlying database tables. The package is not a user-facing artifact; it is infrastructure invoked by higher-level ASO public APIs such as ASO_QUOTE_PUB and ASO_OPP_QTE_PUB.

The package header is dated 2005 and carries the identifier asoidefs.pls 120.1, indicating it originated in the 11.5.10 timeframe and was carried forward into 12.1.1 and 12.2.2 without signature changes. It is declared AUTHID CURRENT_USER and includes the standard ETRM classification OTHER, reflecting that it is an internal integration layer rather than a documented public interface.

The search term "g_miss_control_rec" refers to the package-level global constant G_MISS_CONTROL_REC. This variable is an instance of Control_Rec_Type, a record that drives defaulting behavior through four control flags (Override_Trigger_Flag, Dependency_Flag, Defaulting_Flag, Application_Type_Code, Defaulting_Flow_Code, Last_Update_Date, and Object_Version_Number). Because it is populated entirely with FND_API.G_MISS_* sentinel values (and explicit TRUE/FALSE defaults), it functions as the "caller did not supply a value" placeholder for the P_CONTROL_REC parameter of DEFAULT_ENTITY.

Key Procedures and Functions

The ETRM metadata documents a single procedure:

• DEFAULT_ENTITY — This is the sole documented entry point. It performs attribute defaulting against a named database object, accepting a control record, an object name, an attribute code table, and optional quote header records from ASO_QUOTE_PUB and ASO_OPP_QTE_PUB. The procedure applies defaulting rules to the entity identified by P_DATABASE_OBJECT_NAME and returns defaulted values through the supplied records.

The package also declares several supporting types that shape the procedure's contract: Control_Rec_Type (control flags), Attribute_Codes_Tbl_Type (a BINARY_INTEGER-indexed table of VARCHAR2(30) attribute codes), Attribute_IDs_Tbl_Type (an indexed table of attribute IDs), Header_Misc_Rec_Type, and Line_Misc_Rec_Type. Global miss constants for each type—G_MISS_CONTROL_REC, G_MISS_ATTRIBUTE_CODES_TBL, G_MISS_ATTRIBUTE_IDS_TBL, G_MISS_HEADER_MISC_REC, and G_MISS_LINE_MISC_REC—provide callers with safe default values. Header_Misc_Rec_Type and Line_Misc_Rec_Type are explicitly documented as being present for forward compatibility, reserved for future attribute extensions.

Tables Accessed

The ETRM metadata records no direct table references for ASO_DEFAULTING_INT via APPS synonyms. All database interaction occurs indirectly: DEFAULT_ENTITY operates on the object named by P_DATABASE_OBJECT_NAME at runtime, which is ordinarily an ASO base table such as ASO_QUOTE_HEADERS or ASO_QUOTE_LINES. Defaulting lookups against ASO defaulting rule and attribute metadata tables are delegated to subordinate packages. This runtime binding explains the absence of a static table list in the repository.

Usage Notes

DEFAULT_ENTITY is not intended to be called directly by end users. It is invoked:

• By the ASO public APIs (ASO_QUOTE_PUB, ASO_OPP_QTE_PUB) as part of the quote creation and update flow, to populate attributes prior to insert or update.
• By 14 other packages in the APPS schema, making it a shared internal utility within the ASO defaulting architecture.
• Indirectly from Order Capture / Quoting forms and any concurrent program or custom code that calls the ASO public APIs rather than the internal package.

Custom developers should prefer the documented public APIs. Where DEFAULT_ENTITY must be called directly, callers should rely on the G_MISS_CONTROL_REC constant so that defaulting flags (Defaulting_Flag, Dependency_Flag) behave per the standard configuration, and should populate the attribute code and ID tables explicitly to scope the defaulting operation.