Search Results po_conterms_wf_pvt




Overview
Explore in AI Chat

Overview

PO_CONTERMS_WF_PVT is a private PL/SQL package owned by APPS that supplies the contract terms workflow logic used by Oracle Purchasing in Oracle E-Business Suite 12.1.1 and 12.2.2. It bridges the Oracle Purchasing document model with the Oracle Contracts (OKC) deliverable and business-event infrastructure, evaluating changes made to contract terms during a document revision and feeding the appropriate results back into the workflow. The package declares AUTHID CURRENT_USER, indicating it executes with the privileges of the calling schema, and is classified as a private API (PVT), meaning it is not intended for direct third-party invocation.

A notable element relevant to the user's search for "event_tbl_type" is the package's subtype declaration:

This aliases the Contracts group's collection of business document dates, which carries deliverable event codes together with their due dates. The private subtype is used by the GET_DELIVERABLE_EVENTS procedure to return that collection through its x_event_tbl OUT NOCOPY parameter, making "event_tbl_type" the internal name that appears when inspecting the package specification or when tracing deliverable event handling from Purchasing into Contracts.

Key Procedures and Functions

The package exposes eleven documented procedures and functions, all oriented toward workflow rule evaluation and contract terms maintenance:

All of the IS_* routines follow the standard workflow function signature convention, receiving item type, item key, activity, and function mode, and returning a result for the workflow engine.

Tables Accessed

The package reads and writes the core Purchasing document tables through APPS synonyms:

  • PO_HEADERS_ALL — the primary source for document type, subtype, and header identifiers.
  • PO_HEADERS_ARCHIVE_ALL — used when comparing revisions to detect whether terms, articles, or deliverables changed.
  • PO_DOCUMENT_TYPES_ALL_B — supplies document type and subtype validation.
  • PLITBLM — the standard EBS message table used for message lookup and error reporting.

Usage Notes

PO_CONTERMS_WF_PVT is invoked from the Purchasing contract terms workflow and from Oracle Contracts integration points rather than from end-user forms. It is referenced by six other packages, so its routines are commonly called indirectly during document approval, revision comparison, and deliverable synchronization. Because the package is private, customizations should not call it directly; supported integration should use the public Contracts and Purchasing APIs that consume it. When troubleshooting deliverable event behavior, the event_tbl_type subtype in this specification is the relevant internal type to trace.