Search Results turnoff_collection_profile

Overview

The APPS.IEX_WF_BAN_STATUS_PUB package is a public PL/SQL API that drives the Oracle EBS Collections Bankruptcy Status Approval workflow. Its primary business function is to evaluate a customer's bankruptcy standing and delinquency status, then start and control an Oracle Workflow process that governs whether collection activity should be suspended or resumed for the affected party and customer account. It bridges the Collections module (IEX) with Trading Community Architecture (TCA/HZ) data and the Oracle Workflow engine. The package is classified as a public API (PUB), declared AUTHID CURRENT_USER, and is part of the IEX (Collections) product family. The header iexwfbss.pls 120.1.12020000.4 dates the current version to a January 2013 release aligned with the 12.2.2 code line, and the sources span both 12.1.1 and 12.2.2 installations.

Key Procedures and Functions

The package exposes twelve documented members. The two query functions, GET_BANKRUPTCY_STATUS and GET_TURNINVOFF, return the bankruptcy status and the turn-off collections indicator for a given party, customer account, and effective date. START_WORKFLOW initiates the Bankruptcy Status Approval workflow, accepting API version, initialization, commit, user, delinquency, party, and bankruptcy identifiers, and returning the standard x_return_status, x_msg_count, and x_msg_data outputs. UPDATE_APPROVAL_STATUS and UPDATE_REJECTION_STATUS are workflow callbacks that set the approval or rejection state based on the workflow item and activity. SET_NO_CONTACT_IN_TCA updates TCA contact preferences to suppress contact. TURNOFF_COLLECTION_PROFILE, TURNOFF_COLLECTIONS, and NO_TURNOFF_COLLECTIONS manage the collections profile state and the decision on whether to disable collections. CREATE_STRATEGY and CANCEL_STRATEGY_AND_WORKFLOW create or cancel the collection strategy and its associated workflow. NOTIFY_CHECK, the member most relevant to the user's search, is a workflow notification handler that evaluates conditions to determine whether a notification should be sent and to populate its content.

Tables Accessed

The package reads and writes a defined set of APPS synonyms. Bankruptcy and delinquency data are held in IEX_BANKRUPTCIES and IEX_DELINQUENCIES, while IEX_CASES_ALL_B supplies case information. Collection strategies and their work items reside in IEX_STRATEGIES and IEX_STRATEGY_WORK_ITEMS. Questionnaire responses come from IEX_QUESTIONNAIRE_ITEMS. TCA entities are represented by HZ_PARTIES, HZ_CUST_ACCOUNTS, HZ_RELATIONSHIPS, and HZ_CONTACT_PREFERENCES, the last being modified by SET_NO_CONTACT_IN_TCA. Resource assignments reference JTF_RS_RESOURCE_EXTNS.

Usage Notes

In Oracle EBS 12.1.1 and 12.2.2, this package is invoked when a user enters or updates a bankruptcy record in the Collections workbench, which triggers START_WORKFLOW and routes approval notifications. The remaining procedures function as workflow activity callbacks invoked by the Workflow engine rather than by end users, with NOTIFY_CHECK governing notification delivery. Custom code should call the public API entry points such as START_WORKFLOW using the standard FND_API conventions, and avoid direct DML against the underlying IEX and HZ tables. Because the package is referenced by five other packages, it participates in shared bankruptcy and strategy processing and must be treated as a dependent component during upgrades or patches.