Search Results oks_wf_k_process_pvt




Overview
Explore in AI Chat

Overview

OKS_WF_K_PROCESS_PVT is a private PL/SQL package in the APPS schema that functions as the workflow integration engine for the Oracle Service Contracts (OKS) and Oracle Contracts (OKC) modules. Its central responsibility is to manage the Oracle Workflow-driven life cycle of service contracts, quotations, and negotiation documents. The package bridges the transactional contract tables with the Workflow engine, launching workflow processes, advancing activities, updating item attributes, and synchronizing workflow status back into the contract records. It supports both online (interactive) and deferred workflow execution modes, as reflected in the IS_ONLINE_K_YN helper. Because it is classified as a PVT package, it is not a public API; it is invoked internally by other OKS and OKC packages and by user-interface and concurrent flows that require workflow orchestration. It is a VALID object in the ETRM 12.2.2 metadata and depends directly on WF_ITEMS plus standard SYS constructs, indicating tight coupling to the Workflow schema.

Key Procedures and Functions

The package exposes 32 documented procedures and functions. The principal entry points include LAUNCH_K_PROCESS_WF, which starts the contract workflow process; INITIALIZE, which sets up processing context; and SUBMIT_FOR_APPROVAL, which routes a contract or quotation into the approval cycle. Activity management is handled by COMPLETE_ACTIVITY, while SET_NOTIFICATION_ATTR configures notification attributes on workflow items. Customer-facing negotiation actions are covered by CUSTOMER_ACCEPT_QUOTE, CUSTOMER_DECLINE_QUOTE, CUSTOMER_REQUEST_ASSISTANCE, SALESREP_ACTION, and PROCESS_NEGOTIATION_STATUS. Contract state transitions are managed through CANCEL_CONTRACT, CLEAN_WF, and the GET_OLD_WF_STATUS/GET_PROCESS_TYPE retrieval functions. Additional utilities include ASSIGN_NEW_QTO_CONTACT, PUBLISH_TO_CUSTOMER, EMAIL_MUTE, GET_CURR_CONV_DATE_VALIDITY, CHECK_QA, and IS_ONLINE_K_YN. No parameter lists are published in the reference metadata.

Tables Accessed

Through APPS synonyms the package reads and writes Workflow and reference tables including WF_ITEMS, FND_APPLICATION, FND_LANGUAGES, FND_NEW_MESSAGES, FND_RESPONSIBILITY, and FND_USER to resolve workflow items, application context, messaging, and responsibility/user routing. It accesses HR_ALL_ORGANIZATION_UNITS and JTF_RS_RESOURCE_EXTNS for organizational and resource (sales representative) data, and HZ_PARTIES, HZ_CONTACT_POINTS, HZ_CUST_ACCOUNT_ROLES, and HZ_RELATIONSHIPS for Trading Community customer and contact information. Contract data is drawn from OKC_K_HEADERS_ALL_B, OKC_K_PARTY_ROLES_B, and OKC_CLASS_OPERATIONS, giving the package visibility into contract headers, party roles, and class-level operations that drive workflow behavior.

Usage Notes

OKS_WF_K_PROCESS_PVT is referenced by at least ten other packages, including OKC_CONTRACT_APPROVAL_PVT, OKS_AUTO_REMINDER, OKS_CHANGE_STATUS_PVT, OKS_CUSTOMER_ACCEPTANCE_PVT, OKS_EXTWARPRGM_PVT, OKS_IMPORT_POST_PROCESS, OKS_KHR_PVT, OKS_MASS_UPDATE_PVT, OKS_RENEW_CONTRACT_PVT, and OKS_TEMPLATE_SET_PUB. It is also self-referencing, confirming recursive internal calls. Typical invocation occurs when approval workflows are initiated from the Service Contracts or Contracts forms, when concurrent programs such as auto-reminder or mass update trigger workflow events, and when custom extensions replicate standard workflow behavior. Because it is a private package, customization should avoid calling it directly where a public API is available; instead, integrate through the documented public packages that invoke it.