Search Results get_dest_page_url

Overview

APPS.POS_URL_PKG is a PL/SQL utility package in Oracle E-Business Suite, owned by the APPS schema and classified as OTHER in the ETRM repository. Its header carries the version stamp $Header: POSURLS.pls 120.2 2011/11/01 18:23:56 jatraman ship $ and it is declared AUTHID CURRENT_USER, meaning its unqualified references resolve under the privileges of the calling user rather than the defining schema. The package exists to centralize URL construction for Oracle iSupplier Portal and related supplier-facing flows. Rather than hard-coding host names, ports, servlet paths, or login entry points, callers invoke these functions so that the correct internal or external web server address is resolved at runtime from profile option configuration. This separation is essential in EBS deployments where the external (supplier) web tier and the internal (employee) web tier are distinct hosts, often behind different listeners and SSO configurations. The package also exposes a small record and table type used to carry URL parameter name/value pairs, reflecting its role as a general-purpose URL assembly helper.

Key Procedures and Functions

The package documents seven functions, each returning VARCHAR2 unless noted:

• GET_EXTERNAL_URL — Returns the base URL of the external web server used for suppliers, for example a host-and-port form such as http://host.example.com:8888/.
• GET_INTERNAL_URL — Returns the base URL of the internal web server, following the same host-and-port convention.
• GET_EXTERNAL_LOGIN_URL — Returns the login URL served by the external web server for suppliers, for example a path terminating in the SSO login servlet oracle.apps.fnd.sso.AppsLogin.
• GET_INTERNAL_LOGIN_URL — Returns the corresponding login URL at the internal web server.
• GET_DEST_PAGE_URL — Builds a destination page URL, taking a destination function and a notification performer as inputs. It is used to route a user to the correct page after an action, typically in notification-driven flows.
• GET_NTF_VENDOR_ID — Accepts a notification identifier (NUMBER) and returns a vendor identifier (NUMBER), resolving which supplier party a given workflow notification pertains to.
• GET_BUYER_LOGIN_URL — Returns the login URL intended for buyer users accessing the supplier-facing application.

The package additionally declares the types url_parameter_rec, url_parameters_tab, and menu_function_parameter_rec, which support passing ordered URL parameter and menu function metadata into URL-building logic. No parameter lists for the functions are reproduced here beyond those shown in the documented header.

Tables Accessed

The package references the following objects through APPS synonyms:

• FND_PROFILE_OPTIONS and FND_PROFILE_OPTION_VALUES — Read to resolve the profile option settings that hold internal and external server URLs and related login entry points. This is the mechanism by which the URL functions return deployment-specific values.
• WF_ITEM_ACTIVITY_STATUSES and WF_NOTIFICATIONS — Read to resolve notification context, supporting GET_NTF_VENDOR_ID and destination-page resolution.
• OWA_PATTERN — The Oracle Web Agent pattern-matching package, used for string parsing and substitution during URL assembly.
• PLITBLM — The PL/SQL table helper package used for indexed table manipulation, consistent with the package's use of index-by tables for URL parameters.

Usage Notes

POS_URL_PKG is invoked at runtime by iSupplier Portal pages, Oracle Workflow notification handling, and other supplier-facing components that must emit a link pointing at the correct web tier. Ten other packages are documented as referencing it, indicating it functions as a shared foundation rather than an entry point. Because all URL values derive from profile options read at call time, administrators can relocate or reconfigure the web tier without code changes. Customizations should call these functions rather than reconstructing URLs, and any code that wraps them must respect the AUTHID CURRENT_USER semantics so that profile lookups resolve against the invoking session's configuration.