Search Results qte_header_rec_type

Overview

ASO_CREDIT_CHECK_VUHK is a user hook package in the Oracle EBS Order-to-Cash (ASO) module, owned by APPS and classified under API type OTHER. It exists to expose a controlled customization surface for Oracle Quoting credit checking, allowing implementers to inject custom validation logic before and after the standard credit check processing without modifying Oracle-owned code.

The package is declared with AUTHID CURRENT_USER and carries the header revision asohqccs.pls 120.1. Its stated purpose is to provide the specification required for customer user hooks that simplify the customization process, consisting of paired pre-processing and post-processing APIs that bracket the core credit check. The presence of a qte_header_rec_type dependency in the user's search reflects the package's role as the hook point that receives the quote header record used in Oracle Quoting credit evaluation.

Key Procedures and Functions

The package documents two public procedures, both centered on a quote header record structurally aligned with ASO_QUOTE_PUB.Qte_Header_Rec_Type:

• Credit_Check_PRE — the pre-processing hook. It receives the API version, initialization message flag, commit flag, and the incoming quote header record, and returns the standard API status outputs. Custom logic placed here runs before the standard credit check and can validate or reject the header before further processing.
• Credit_Check_POST — the post-processing hook. It runs after the standard credit check and additionally surfaces the credit check result and hold comment through its parameters, allowing custom logic to react to the outcome, including hold placement comments.

Both procedures follow the standard Oracle API toolkit signature conventions: a mandatory API version number, optional initialization message list and commit flags defaulting to FND_API.G_FALSE, and NOCOPY OUT parameters for return status, message count, and message data. The internal comments identify the current version as 2.0 and explicitly note that the generated procedure definitions include standard IN/OUT parameters, with developers expected to add business logic manually. Neither procedure is documented as implemented, since the package is a specification shell intended for customer extension.

Tables Accessed

The documented ETRM metadata records no direct table references through APPS synonyms for this package. This is consistent with its design as a hook specification: it does not perform its own DML, but rather operates on the quote header record passed in by the calling application. The qte_header_rec_type parameter carries quote header attributes — identifiers, pricing and credit-relevant fields — supplied by the Oracle Quoting credit check process. Any table access occurs indirectly through the caller and through whichever business logic the implementing customer adds to the hook bodies.

Usage Notes

ASO_CREDIT_CHECK_VUHK is invoked automatically by the Oracle Quoting credit check flow at the pre and post hook points; it is not intended to be called directly by end users. Implementers customize the package bodies in a supported manner, relying on the pre hook for early validation and the post hook for reacting to credit check results or attaching hold comments. The package is referenced by one other package in the documented metadata, confirming that it participates in a defined call hierarchy rather than standing alone.

Because the hooks run inside the credit check transaction, added logic must respect the commit and initialization flag parameters and avoid committing independently when P_COMMIT is false. Message handling should use the standard API message stack so that errors propagate correctly to the caller. Upgrades require review of the Qte_Header_Rec_Type definition, since record layout changes in ASO_QUOTE_PUB can invalidate custom hook code across EBS 12.1.1 and 12.2.2.