Search Results get_case_contracts

Overview

OKL_CO_WF is an Oracle EBS Applications package owned by APPS that provides the PL/SQL integration layer between Oracle Lease and Finance Management (OKL) and the Oracle Workflow engine. Its central responsibility is to supply Workflow function activities — the standard PL/SQL callback signature of itemtype, itemkey, actid, funcmode, and resultout — with the business logic needed to drive lease syndication, vendor approval, and case management processes. The package is classified as OTHER in the API classification scheme, indicating it is an internal supporting package rather than a public, customer-callable API. The header declares AUTHID CURRENT_USER, so privileges are evaluated against the invoking schema. Global constants reference okl_api message tokens and define standard error handling names such as OKL_UNEXPECTED_ERROR, while a global exception, G_EXCEPTION_HALT_VALIDATION, allows validation routines to abort a workflow transition cleanly.

Key Procedures and Functions

The package exposes twenty documented procedures and functions. The routine most directly associated with the common search term get_syndicate_flag is GET_SYNDICATE_FLAG, which checks whether a syndication condition applies and returns a result to Workflow (Y/N). Parallel flag evaluators include GET_SENDTOTHIRDPARTY_FLAG, GET_VENDORAPPROVAL_FLAG, and GET_VENDORNOTIFY_FLAG, each determining whether the corresponding downstream action should be triggered.

Notification and reporting routines include NOTIFY_CUSTOMER, REPORT_CUSTOMER, and SEND_VENDOR_NOTIFY, which generate customer and vendor communications; WAIT_BEFORE_REPORT, which introduces a workflow delay prior to reporting; and SEND_VENDOR_APPROVAL, which routes vendor approval requests. Case lifecycle activities are handled by TRANSFER_CASE, REVIEW_CASE, and RECALL_CASE, while WF_SEND_SIGNAL_CANCELLED and WF_SEND_SIGNAL_COMPLETE raise the corresponding Workflow signals.

Data-retrieval functions that populate workflow attributes and notifications include GET_VENDOR_INFO, GET_VENDOR_NAME, GET_PARTY_NAME, GET_CASE_CONTRACTS, GET_CASE_TOTAL_VALUE, and GET_AMT_OVERDUE.

Tables Accessed

The package reads and writes through APPS synonyms across several product schemas. Lease-specific objects include OKL_K_HEADERS, OKL_CNSLD_AR_STRMS_B, and OKL_OPEN_INT, supporting syndication checks and overdue-interest calculations. Oracle Contracts objects OKC_K_HEADERS_B and OKC_RULE_GROUPS_B supply contract and rule-group context. Case-management tables IEX_CASES_ALL_B, IEX_CASE_OBJECTS, IEX_DELINQUENCIES_ALL, and IEX_OPEN_INT_HST are queried for collection case activities, while AR_PAYMENT_SCHEDULES_ALL provides receivables and overdue amounts. Party data comes from HZ_PARTIES and HZ_CONTACT_POINTS. Lookup values are resolved from JTF_AMV_ITEMS_B.

Usage Notes

OKL_CO_WF functions are invoked as Workflow function activities within lease-related item types, primarily for syndication and vendor-approval processes and for collections case workflows. They are also callable from concurrent programs, forms, and custom PL/SQL that need to evaluate a syndication, third-party, or vendor flag, or to retrieve vendor and case context. Because the package is classified OTHER and is referenced by no other documented packages, it should be treated as internal; extensions should call it defensively and honor the G_EXCEPTION_HALT_VALIDATION contract when invoked within a Workflow validation function mode.