Search Results set_approval_status

Overview

OKL_CURE_WF is an Oracle E-Business Suite PL/SQL package body owned by APPS that supports the cure process for Oracle Lease and Finance Management (OKL) contracts. The package integrates lease cure reporting with the Oracle Workflow engine and the EBS Message Dictionary to drive approval and rejection routing for cure reports. It is classified as OTHER within the ETRM metadata, indicating it is a supporting utility package rather than a fully exposed public API.

The package header comment references the ESB transport module okl.stream.esg.okl_esg_transport_pvt and includes internal debug controls via OKL_DEBUG_PUB.CHECK_LOG_ENABLED, confirming it participates in the broader OKL integration and error-handling framework. Private helper procedures such as AddMissingArgMsg, AddfailMsg, and Get_Messages build localized FND messages using tokens (for example OKL_API_ALL_MISSING_PARAM and OKL_FAILED_OPERATION) and aggregate message stacks through FND_MSG_PUB.

Key Procedures and Functions

• SET_APPROVAL_STATUS — Sets the approval status of a cure report, most likely recording a workflow-driven approval outcome against the OKL_CURE_REPORTS record and advancing the associated workflow item.
• SET_REJECT_STATUS — Records a rejection outcome for a cure report, updating the report's status and updating the workflow item accordingly.
• APPROVE_CURE_REPORTS — Drives approval processing for cure reports, iterating or acting on the report set and invoking the status-setting logic plus workflow notification handling.

These procedures are the entry points referenced when the user searches for set_approval_status; they represent the status-transition layer that workflow callbacks invoke.

Tables Accessed

• OKL_CURE_REPORTS — Primary business table; holds the cure report records whose approval or rejection status is maintained.
• OKL_WF_ITEM_S — Stores workflow item status; updated as cure report approvals progress.
• WF_PARAMETER_LIST_T — Workflow parameter list table, used to pass approval parameters into workflow activities.
• FND_USER — Resolves the approving or rejecting user identity for workflow routing and audit.
• FND_NEW_MESSAGES — Source of message text and numbers resolved by the Get_Messages helper.
• DUAL and PLITBLM — Utility references for single-row selection and PL/SQL table handling.

Usage Notes

OKL_CURE_WF is typically invoked from Oracle Workflow function activities configured for cure report approval notifications, and it is referenced by one other documented package. Concurrent programs or custom code that submit cure reports for approval may also call APPROVE_CURE_REPORTS directly. Because the package relies on FND message tokens and FND_MSG_PUB, callers should check the message stack after invocation to surface validation or operation-failure errors. When extending the package, preserve the message-token naming conventions (OKL_API_ALL_MISSING_PARAM, OKL_FAILED_OPERATION) to maintain consistent error reporting across the OKL API family.