Results for “update_umbrella_prog”

5 results




Overview
Explore in AI Chat

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

Overview

PON_CLM_UTIL_PKG is a public PL/SQL utility package owned by the APPS schema in Oracle E-Business Procurement. Its declared purpose is to centralize the helper logic required by the Contract Lifecycle Management (CLM) feature set that layers federal and commercial contracting capabilities over Oracle Sourcing and Oracle Purchasing documents. The package is defined as AUTHID CURRENT_USER, meaning that its SQL executes under the privileges of the invoking session rather than the definer, which allows it to participate safely in VPD-controlled and Multi-Org secured queries.

The most frequently referenced member of this package is GET_DOCUMENT_NUMBER, which returns a sourcing document identifier formatted according to CLM numbering conventions. It was introduced by Bug 10056890 specifically to produce a CLM-format document number from an auction header identifier, replacing earlier ad hoc formatting performed in forms and reports. The package header carries a revision history spanning 120.11 series releases, and the object is referenced by 18 other packages, confirming its role as a shared dependency rather than a standalone API.

Key Procedures and Functions

  • IS_DOCUMENT_FEDERAL — Determines whether a given document type is treated as a federal document for CLM processing.
  • IS_NEG_DOCUMENT_FEDERAL — Same determination at the negotiation (auction header) level.
  • GET_COPY_ERR_MSGS — Consolidates and returns error messages from a message stack, indicating whether any unexpected error occurred.
  • IS_AMENDMENT — Identifies whether a negotiation is an amendment of a prior document.
  • IS_UDA_ENABLED — Reports whether User Defined Attributes are enabled for the document type.
  • UPDATE_HEADER_STYLE_ID — Persists a style (template) identifier onto a negotiation header.
  • ISCLMINSTALLED — Boolean check for the presence of the CLM application.
  • ISCLMRESP — Returns the CLM responsibility context for the current session.
  • GETCLMSTATUS — Resolves CLM status for a user, responsibility, and application combination.
  • CLM_PON_AUC_HDR_VPD_FUN — VPD predicate function securing the auction header view.
  • IS_LINE_CLIN — Tests whether a negotiation line corresponds to a Contract Line Item Number.
  • IS_LINE_PRICED — Tests whether a line carries pricing.
  • DOES_CLIN_HAVE_CHILD — Indicates whether a CLIN has subordinate lines.
  • DOES_LINE_HAVE_OPTION — Indicates whether a line has associated options.
  • GET_DOCUMENT_NUMBER — Returns the CLM-format document number for a negotiation.
  • UPDATE_UMBRELLA_PROG — Associates an umbrella program identifier with a negotiation.
  • GET_CLM_PDF_NAME — Builds the PDF file name for a CLM document, incorporating revision, language, and user view type.
  • GET_CLM_COMMERCIAL_DOC_NUMBER — Returns the CLM-format number for commercial documents.
  • GET_LINE_STRUCTURE_ENABLED — Reports whether line structure functionality is active.

Tables Accessed

Usage Notes

The package is invoked in four principal contexts. First, Oracle Forms for Sourcing and CLM call GET_DOCUMENT_NUMBER and the line-structure helpers when rendering negotiation headers and lines. Second, CLM setup and validation logic calls ISCLMINSTALLED, ISCLMRESP, and GETCLMSTATUS. Third, the VPD function CLM_PON_AUC_HDR_VPD_FUN is registered as a security policy predicate on the auction header view and executes automatically for all querying sessions. Fourth — and most relevant to custom development — the eighteen dependent packages call these utilities directly, so any extension code should invoke GET_DOCUMENT_NUMBER rather than reimplementing CLM number formatting. Because the package is AUTHID CURRENT_USER, callers must hold the necessary object privileges and be initialized in a valid Multi-Org and responsibility context.