Search Results update_conterms_dates

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:

• SUBTYPE Event_tbl_type IS OKC_MANAGE_DELIVERABLES_GRP.BUSDOCDATES_TBL_TYPE;

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:

• CONTRACT_TERMS_CHANGED — Function returning a value that indicates whether contract terms were modified in the current revision.
• GET_DELIVERABLE_EVENTS — Returns event codes and their due dates for deliverables; the output is the event_tbl_type collection.
• UPDATE_CONTERMS_DATES — Retrieves and updates the last-update dates for contract terms date fields, returning status and message information.
• UPDATE_CONTRACT_TERMS — Informs Contracts about an approval, accepting the signed date and returning status details.
• IS_STANDARD_CONTRACT — Workflow function that determines whether a contract deviates from the standard contract template.
• IS_CONTRACT_TEMPLATE_EXPIRED — Workflow function that checks whether the contract template has expired.
• IS_CONTRACT_ARTICLES_EXIST — Checks whether articles are attached to the purchase order.
• IS_CONTRACT_ARTICLES_AMENDED — Checks whether articles were amended in the current revision.
• IS_CONTRACT_DELIVRABLS_EXIST — Checks whether deliverables exist on the contract terms.
• IS_CONTRACT_DELIVRABLS_AMENDED — Checks whether deliverables were amended in the current revision.
• CANCEL_DELIVERABLES — Cancels deliverables associated with the document.

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.