Search Results get_various_session_info

Overview

POS_ANON_PKG is an Oracle E-Business Suite PL/SQL package owned by the APPS schema that supports the anonymous (guest) login capability used by Oracle iStore and related e-commerce storefront functionality. Its central purpose is to allow an unauthenticated visitor to be provisioned with a lightweight, temporary application session and responsibility so that they can browse, configure, and price products without first being registered or authenticated as a named user. The package is declared with AUTHID CURRENT_USER and, based on its header comment (POSANONS.pls 120.1), has been a stable part of the applications codebase since at least 2005, predating the 12.1.1 and 12.2.2 releases in which it remains present.

The API classification is OTHER, indicating it is not part of a formal, versioned public interface and is intended primarily for internal consumption by the iStore application layer and a small number of dependent packages (it is referenced by two other packages). This classification carries an implicit warning: signatures are not governed by Oracle's API compatibility policy, so custom code should use it cautiously.

Key Procedures and Functions

The package exposes four documented program units.

• MAKE_ANONYMOUS_LOGIN — a function that creates the anonymous login for a visitor. It accepts a registration key and returns a value while returning a session identifier and a transaction identifier as OUT parameters. It is the primary entry point for initiating a guest session.
• CONFIRM_HAS_RESP — a procedure that confirms the presence of a responsibility for the anonymous user, taking a responsibility key as input. It validates that the anonymous login is associated with a usable responsibility before the session proceeds.
• GET_VARIOUS_LOGIN_INFO — the procedure targeted by the query. It accepts raw session identifier, raw transaction identifier, and responsibility key as inputs, and returns the database connection name, encoded session identifier, encoded transaction identifier, application identifier, and responsibility identifier as OUT parameters. In effect, it resolves and encodes the login context needed to reconstruct or validate a guest session.
• GET_VARIOUS_SESSION_INFO — a procedure returning the session cookie name and session cookie domain, which the iStore middle tier uses to set and read the anonymous session cookie.

Tables Accessed

The package operates against the following tables via APPS synonyms:

• FND_USER — to resolve and validate the anonymous (guest) user account.
• FND_RESPONSIBILITY and FND_APPLICATION — to identify and encode the application and responsibility assigned to the guest session.
• FND_PROFILE_OPTIONS and FND_PROFILE_OPTION_VALUES — to read profile option settings that govern anonymous login behaviour.
• ICX_PARAMETERS — to obtain session and cookie configuration parameters.
• ICX_TRANSACTIONS and ICX_TRANSACTIONS_S — to create and manage the iStore transaction record associated with the anonymous session.
• DUAL — for single-row expression evaluation.

Usage Notes

POS_ANON_PKG is invoked indirectly by the iStore storefront when a shopper reaches the site without authenticating or when the session needs to be re-established. GET_VARIOUS_LOGIN_INFO in particular is called during session reconstruction to decode raw session and transaction identifiers into their encoded forms together with the governing application and responsibility IDs. Because the package is classified as OTHER and referenced by only two other packages, customizations should treat it as an internal dependency rather than a supported integration point. Any custom code that calls it must respect the OUT parameter behaviour and should be retested across 12.1.1 and 12.2.2, particularly where online patching (adop) phases in 12.2 affect concurrent session state.