Search Results check_days_for_syn_acct

Overview

OKL_STRY_CALL_CO_PUB is a public PL/SQL package in the APPS schema that supports the Oracle Lease and Finance Management (OLFM/OKL) strategy workflow used to drive collections and customer-contact activities. It acts as a workflow-enabled integration layer that evaluates business conditions—such as whether vendor approval is needed before contacting a customer—and then signals the master workflow when a custom sub-workflow completes. Declared with AUTHID CURRENT_USER, it executes with the privileges of the invoking user and is classified as a public API.

The package operates on ETRM (Enterprise Transaction Resource Management) collections data, combining case-management tables, delinquency records, party/vendor data, and workflow infrastructure. Its central role is to bridge Oracle Workflow function activities with the underlying transactional data, returning a workflow result value (typically Y/N) that governs branch logic in the collections strategy.

Key Procedures and Functions

• SEND_FULFILMENT — Sends an email through the OKL fulfilment API, which at the time of writing supported email only.
• WF_SEND_SIGNAL — Signals the main workflow that the custom workflow has completed and updates the work item.
• GET_DELINQUENT_CONTRACT — Returns the most delinquent contract associated with a case, based on the number of days past due.
• GET_VENDORAPPROVAL_FLAG — The procedure matching the user's search. It checks whether vendor approval is required before calling the customer.
• GET_NOTIFICATION_FLAG — Checks the applicable notification rule.
• CHECK_DAYS_PAST_DUE — Verifies whether the number of days past due exceeds the actual past-due threshold.
• GET_VENDOR_INFO — Returns vendor information (vendor ID, name, and email), presumably for the identified case number.
• CHECK_DAYS_FOR_SYN_ACCT, GET_LESSOR_FLAG, GET_CUSTOMER_FLAG, GET_VENDOR_APPROVAL_FLAG, GET_VEND_CUST_NOTIFY_FLAG — Additional documented procedures that evaluate account, lessor, customer, and vendor/customer notification conditions within the same workflow-decision framework.

Tables Accessed

The package reads from several ETRM and Oracle application tables via APPS synonyms:

• IEX_CASES_ALL_B, IEX_CASE_OBJECTS, IEX_DELINQUENCIES_ALL, IEX_STRATEGY_WORK_ITEMS — Collections case, object association, delinquency, and strategy work-item data that drive the workflow decisions.
• OKC_K_HEADERS_B, OKC_RULE_GROUPS_B, OKL_K_HEADERS — Contract headers and rule groups for lease/contract context.
• HZ_PARTIES, HZ_CONTACT_POINTS — Party (vendor/customer) master data and contact points such as email addresses.
• JTF_RS_RESOURCE_EXTNS, JTF_AMV_ITEMS_B, JTF_FM_TEMPLATE_CONTENTS — Resource, message/template, and fulfilment template content used for notifications.
• DUAL — Used for simple PL/SQL evaluations.

Usage Notes

OKL_STRY_CALL_CO_PUB is invoked primarily as a set of Oracle Workflow function activities within the collections strategy workflow. Each procedure returns a result value that the workflow engine interprets to branch logic; GET_VENDORAPPROVAL_FLAG, for example, returns a flag the workflow uses to decide whether vendor approval is required before contacting the customer. SEND_FULFILMENT and WF_SEND_SIGNAL support the notification and workflow-completion aspects of the strategy. Because it is a public API with no dependent packages, it is also safe for custom code and concurrent programs to call directly. The package is version-controlled from release 12.1.1 and remains documented in 12.2.2.