Results for “src_sol”

5 results




Overview
Explore in AI Chat

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

Overview

APPS.PON_WF_UTL_PKG is a utility package within the Oracle E-Business Suite Procurement module, specifically serving the Sourcing and Oracle Workflow integration layer. It operates under AUTHID CURRENT_USER and resides in the APPS schema, providing shared helper routines that support buyer auctions, RFQs, RFIs, and solicitations — the document types enumerated by the SRC_AUCTION, SRC_RFQ, SRC_RFI, and SRC_SOL constants. The package encapsulates URL construction for OA Framework pages, supplier registration links, notification preference retrieval, concurrent program status reporting, and workflow header attribute manipulation. Debug logging is governed by the AFLOG_ENABLED profile option, cached at package load into g_fnd_debug, and the package name PON_WF_UTL_PVT is used as the logging module prefix. Because the user searched for set_hdr_attributes, that specific routine is the primary focus of this reference, though the package contains thirteen documented procedures.

Key Procedures and Functions

  • SET_HDR_ATTRIBUTES — Populates workflow header-level attributes for a Sourcing document, allowing notification and workflow metadata to be stamped onto the workflow item before it is processed further. This is the routine most commonly referenced when callers need to seed header context.
  • GET_PAGE_URL — Low-level function returning an OA page URL in the form http://<server>:<port>/OA_HTML/OA.jsp appended with constructed parameters, with server and port resolved from profile options.
  • GET_ISP_SUPPLIER_REGISTER_URL — Returns the supplier registration URL for the iSupplier Portal.
  • GET_DEST_PAGE_URL and GET_DEST_PAGE_PARAMS — Supply the destination page URL and its associated parameter set, used to redirect workflow notification recipients.
  • GETCONCPROGRAMTYPE — Determines the concurrent program type associated with a workflow context.
  • GETLASTLINENUMBERINBATCH and GETLASTWORKSHEETINBATCH — Return the last line or worksheet number within a processing batch, supporting batch-oriented document handling.
  • REPORTCONCPROGRAMSTATUS — Reports concurrent program execution status back into the workflow context.
  • GET_NOTIF_PREFERENCE — Reads the notification preference for a given recipient.
  • GET_BASE_EXTERNAL_SUPPLIER_URL and GET_BASE_INTERNAL_BUYER_URL — Return the base URLs for external supplier-facing and internal buyer-facing applications.
  • GET_SITE_LEVEL_PROFILE_VALUE — Retrieves a profile option value at site level.

Tables Accessed

The package queries and updates several Sourcing and Workflow tables through APPS synonyms. PON_AUCTION_HEADERS_ALL supplies auction header data, and PON_AUC_DOCTYPES maps document types. Workflow integration relies on WF_MESSAGES, WF_NOTIFICATIONS, WF_NOTIFICATION_ATTRIBUTES, and WF_ITEM_ACTIVITY_STATUSES. Notification subscriptions are drawn from PON_NOTIF_SUBSCRIPTION_GROUPS and PON_NOTIF_GROUP_MEMBERS. Profile values are resolved from FND_PROFILE_OPTIONS and FND_PROFILE_OPTION_VALUES, while FND_RESPONSIBILITY supports responsibility resolution. DUAL and the PL/SQL table PLITBLM serve ancillary purposes.

Usage Notes

PON_WF_UTL_PKG is invoked from Oracle Forms, OA Framework pages, and workflow function activities within the Sourcing flow. It is referenced by eleven other packages, so customizations should treat it as a shared dependency. Callers typically invoke SET_HDR_ATTRIBUTES when initializing a workflow item to ensure downstream notifications carry correct header context. Any modification requires recompilation against dependent objects, and debug output should be enabled through AFLOG_ENABLED only during troubleshooting, as the profile is cached at session start.