Results for “update_ame_status”
18 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
OKC_REP_WF_PVT is a private PL/SQL package body in the APPS schema that supports the Oracle E-Business Suite Contract Lifecycle Management workflow approval infrastructure. In EBS 12.1.1 and 12.2.2, the package belongs to the Oracle Contracts (OKC) module family, specifically the repository (OKC_REP) objects that manage contracts authored through Contract Terms and Oracle Approvals Management (AME). The package acts as the runtime bridge between the Contracts repository and the Oracle Workflow Engine, orchestrating approval and rejection processing, AME status synchronization, and workflow notification completion for contract approval hierarchies. Because it is classified as a PVT package, its entry points are not exposed as public APIs; they are invoked internally by workflow activity functions, the contract approval engine, and sibling package OKC_REP_UTIL_PVT.
Key Procedures and Functions
The documented interface exposes sixteen procedures and functions that fall into several functional groups:
- Initialization: APPS_INITIALIZE and INITIALIZE_ATTRIBUTES prepare the session and workflow item attribute context before approval processing begins.
- Approval and rejection: APPROVE_CONTRACT and REJECT_CONTRACT apply an approver's decision to a contract; HAS_NEXT_APPROVER determines whether the AME approval chain contains subsequent approvers.
- AME status management: UPDATE_AME_STATUS and UPDATE_AME_STATUS_DETAILED synchronize AME approval outcomes back to the contract; IS_CONTRACT_APPROVED and IS_CONTRACT_APPROVED_DETAILED evaluate whether a contract has reached fully approved status.
- Workflow completion: IS_APPROVAL_COMPLETE and COMPLETE_NOTIFICATION finalize the workflow item and close pending notifications when the approval process terminates.
- Contract metadata checks: CON_HAS_TERMS, CON_ATTACH_GENERATED_YN, and CONTRACT_PREVIEW_YN determine whether a contract contains terms, whether a generated document is attached, and whether preview is enabled prior to approval.
- Approver controls: CHECK_CURRENT_APPROVER validates that the acting user is the current approver, and ALLOW_APPROVER_EDIT controls whether the current approver may modify contract content during the approval cycle.
Tables Accessed
The package reads and writes the following tables through APPS synonyms: OKC_REP_CONTRACTS_ALL and OKC_REP_CONTRACT_VERS store the contract repository rows and versions updated during approval; OKC_REP_CON_APPROVALS holds the approval history records; OKC_CONTRACT_DOCS and OKC_BUS_DOC_TYPES_B support the contract document and business document type logic used by CON_ATTACH_GENERATED_YN and CONTRACT_PREVIEW_YN; WF_ITEMS and WF_NOTIFICATIONS are used to read and update workflow item state and notification status; FND_USER is consulted to resolve the acting user; and the HR tables PER_ALL_PEOPLE_F, PER_ALL_ASSIGNMENTS_F, PER_ASSIGNMENT_STATUS_TYPES, together with JTF_RS_RESOURCE_EXTNS, are used to resolve approver identities and resource information for AME integration. PLITBLM is referenced for PL/SQL table operations.
Usage Notes
OKC_REP_WF_PVT is not a publicly callable API and is not referenced by any other database object. It is invoked indirectly when a contract is submitted into the AME approval workflow: the Workflow Engine calls the activity functions within this package through contract approval workflow definitions, and the package in turn calls AME_API2, AME_API6, AME_UTIL, AME_UTIL2, FND_API, FND_GLOBAL, FND_LOG, FND_NUMBER, OKC_API, OKC_REP_UTIL_PVT, OKC_TERMS_UTIL_GRP, WF_CORE, WF_DIRECTORY, WF_ENGINE, WF_NOTIFICATION, and WF_NOTIFICATIONS. Because these are internal entry points, customizations should not call the procedures directly; instead, integrators should extend behavior through supported OKC APIs and Workflow Builder configuration. Debugging typically involves examining FND_LOG output and WF_NOTIFICATIONS rows produced during approval processing.
-
PACKAGE: APPS.OKC_REP_WF_PVT 12.1.1
-
PACKAGE: APPS.OKC_REP_WF_PVT 12.2.2