Search Results rosetta_g_miss_num

Overview

IBE_QUOTE_W2_PVT is a private PL/SQL package in the Oracle E-Business Suite iStore/Quoting module (IBE application). It is the body half of a package whose primary responsibility is to support quoting and "share" functionality for iStore (the Oracle EBS e-commerce storefront), specifically around version 2 (V2) of quote sharing. The "_PVT" suffix indicates this is a private helper package, meaning it is not intended to be called directly by external APIs; it exposes internal utility routines consumed by the public quote publishing layer (notably the ASO_Quote_Pub APIs).

The package header comment block (line 3–8) is largely empty, so the functional intent must be inferred from the identifiers present in the body and from the documented procedure name. The body references ASO_Quote_Pub.Control_Rec_Type, confirming this package sits in the quoting (ASO) integration space. The presence of a ROSETTA_G_MISS_NUM constant (value 0-1962.0724) and a ROSETTA_G_MISTAKE_DATE constant (TO_DATE('01/01/+4713', 'MM/DD/SYYYY')) indicates the package follows the standard Oracle Rosetta/TCA-style "missing value" convention. These sentinels distinguish "value not supplied" from a legitimate NULL. The user search term "rosetta_g_miss_num" maps directly to line 10 of the source, where ROSETTA_G_MISS_NUM NUMBER := 0-1962.0724 is declared.

Key Procedures and Functions

The documented ETRM metadata lists one procedure for this package:

• SAVE_SHARE_V2_WRAPPER — A wrapper procedure that handles the "share" operation corresponding to version 2 of the quote sharing logic. As a wrapper, it is expected to receive an incoming request payload, validate or transform the inputs, and delegate the core processing to the underlying quote-sharing routine. It encapsulates the V2 sharing behavior so callers do not need to interact with the lower-level implementation directly.

The source excerpt also exposes a private helper named set_control_rec_w, which assembles an ASO_Quote_Pub.Control_Rec_Type record from optional parameters. It compares each incoming parameter against the Rosetta missing-value sentinels (ROSETTA_G_MISTAKE_DATE, FND_API.G_MISS_DATE, and FND_API.G_MISS_CHAR) and only assigns the value to the output record when the parameter differs from those sentinels. Parameters include last_update_date, auto_version_flag, pricing_request_type, header_pricing_event, line_pricing_event, calculate_tax_flag, and freight charge flag. This routine is an internal utility that supports the wrapper and other packaged logic.

Tables Accessed

The documented table reference for this package is PLITBLM (accessed via an APPS synonym). PLITBLM is a standard EBS multi-lingual / temporary line table used by the Oracle "M" (multi-lingual) and temporary-table mechanisms. In the quoting context, it typically serves as a transient staging area for line-level data processed during a save or share operation before the values are persisted to the quoting base tables.

Usage Notes

Because IBE_QUOTE_W2_PVT is a PVT (private) package, it is not called directly by end users or external integrations. It is invoked internally from the iStore quoting forms and from other IBE/ASO public packages that need the version-2 quote-sharing behavior. Typical invocation paths include:

• The iStore quote / shopping cart UI when a user shares a quote.
• The ASO_Quote_Pub public API layer, which wraps and calls these private helpers.
• Concurrent programs or custom code that drive quote save/share processing through the supported public APIs.

The package is referenced by zero other packages per the metadata, confirming it is a leaf-level helper rather than a shared utility. The constant declarations and set_control_rec_w helper indicate that callers pass optional parameters and the package applies Rosetta missing-value semantics, so custom code should avoid passing ROSETTA_G_MISS_NUM or the sentinel date as legitimate business values. Developers searching for "rosetta_g_miss_num" will find its declaration here and should understand it as the numeric missing-value sentinel used for the standard EBS optional-parameter pattern.