Results for “pon_ext_apps_framework_agent”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

PON_WF_UTL_PKG is a utility package in the Oracle EBS Sourcing (Oracle iSupplier Portal / Sourcing) module, owned by APPS and classified as OTHER within the ETRM repository. Its principal responsibility is to centralize the construction of URLs, notification preferences, batch-tracking values, and header attributes required by the Sourcing workflow and notification infrastructure. The package encapsulates logic that would otherwise be duplicated across the various Sourcing workflow agents that must render Oracle Application Framework (OAF) pages, resolve the correct external framework agent, and direct users to the appropriate destination page.

Because the user searched for "pon_ext_apps_framework_agent," the most relevant function is get_base_supplier_url, which resolves the external framework agent by first querying the PON_EXT_APPS_FRAMEWORK_AGENT profile option, then falling back to APPS_FRAMEWORK_AGENT, and finally appending OA_HTML/OA.jsp to produce a fully qualified base supplier URL. This profile-driven design allows deployments to define a distinct external framework agent endpoint for supplier-facing access without affecting internal buyer access.

Key Procedures and Functions

• GET_PAGE_URL — Returns the URL of an OAF page used within the Sourcing workflow context.
• GET_ISP_SUPPLIER_REGISTER_URL — Constructs the URL directing a supplier to the iSupplier Portal registration page.
• SET_HDR_ATTRIBUTES — Populates workflow notification header attributes, typically before a notification is dispatched.
• GET_DEST_PAGE_URL — Returns the destination page URL associated with a workflow notification or activity.
• GET_DEST_PAGE_PARAMS — Returns the parameter string appended to the destination page URL.
• GETCONCPROGRAMTYPE — Identifies the concurrent program type relevant to a Sourcing batch process.
• GETLASTLINENUMBERINBATCH — Retrieves the last line number processed within a given batch.
• GETLASTWORKSHEETINBATCH — Retrieves the last worksheet processed within a given batch.
• REPORTCONCPROGRAMSTATUS — Reports the status of a concurrent program back to the calling process.
• GET_NOTIF_PREFERENCE — Returns the notification preference for a given workflow message name and document type, consulting notification subscription and group member tables.
• GET_BASE_EXTERNAL_SUPPLIER_URL — Returns the base external supplier URL, derived from the external framework agent profile.
• GET_BASE_INTERNAL_BUYER_URL — Returns the base internal buyer URL, derived from the buyer-side profile or responsibility.
• GET_SITE_LEVEL_PROFILE_VALUE — Retrieves a site-level profile option value.

Tables Accessed

• PON_AUCTION_HEADERS_ALL — Sourcing negotiation headers, used to resolve context-specific page URLs and attributes.
• WF_MESSAGES — Provides message names against which notification preferences are evaluated.
• FND_PROFILE_OPTIONS / FND_PROFILE_OPTION_VALUES — Source of profile option definitions and values, including framework agent settings.
• FND_RESPONSIBILITY — Used when resolving the default responsibility for external users.
• PON_AUC_DOCTYPES — Supplies document type group names for notification preference lookups.
• PON_NOTIF_GROUP_MEMBERS / PON_NOTIF_SUBSCRIPTION_GROUPS — Define which users receive notifications and under what subscription.
• WF_ITEM_ACTIVITY_STATUSES, WF_NOTIFICATIONS, WF_NOTIFICATION_ATTRIBUTES — Workflow runtime tables consulted for activity status and notification attribute population.
• DUAL, PLITBLM — Utility references; DUAL for scalar lookups and PLITBLM for bulk PL/SQL operations.

Usage Notes

PON_WF_UTL_PKG is referenced by 11 other packages, indicating it functions as a shared utility layer rather than an entry-point API. It is typically invoked from Sourcing workflow background processes, notification mailers, and OAF controller logic that must generate a redirect to the correct framework agent. The profile option PON_EXT_APPS_FRAMEWORK_AGENT should be set when suppliers access Sourcing through a dedicated external framework agent; absent this setting, the package falls back to APPS_FRAMEWORK_AGENT, and if neither is configured, returns an empty string. Custom code requiring Sourcing notification URLs or preference resolution should call these functions rather than re-implementing profile and workflow lookups.