Search Results select_resource_info




Overview
Explore in AI Chat

Overview

IEX_WF_DEL_CUR_STATUS_NOTE_PUB is a public PL/SQL package owned by the APPS schema in Oracle E-Business Suite Release 12.1.1 and 12.2.2. Its documented purpose is to drive the Oracle Collections workflow so that a customer's owner and manager are notified whenever a delinquency is closed with a status of "Current." The package header comment trail identifies it as being created by chewang on 26-Feb-2002 and carries the version banner $Header: iexwfcns.pls 120.0 2004/01/24 03:31:05 appldev noship $, confirming it is a longstanding component of the Advanced Collections (IEX) product family.

Functionally, the package bridges the Collections data model and the Oracle Workflow engine. It assembles a notification payload, resolves which resource (collector or manager) should receive the message, and hands the payload to Workflow for delivery. It is a "PUB" API, meaning it is intended to be called from outside the package rather than serving as a purely private helper, although in practice it is invoked primarily by the Collections workflow infrastructure and by other IEX packages (the metadata records one dependent package).

Key Procedures and Functions

  • START_WORKFLOW — The principal entry point. It initiates the workflow process that notifies the owner and manager when a delinquency transitions to a closed/Current state. It accepts a set of delinquency identifiers and standard API housekeeping arguments, returning the usual API status triple (return status, message count, message data).
  • SELECT_NOTICE — A Workflow-standard callback function used to determine the notice or notification to be issued. Its signature matches the Oracle Workflow function-activity convention (item type, item key, activity id, function mode, and an OUT result), allowing it to be wired directly into a workflow process definition.
  • SELECT_RESOURCE_INFO — The procedure most relevant to the "select_resource_info" search. It takes a delinquency identifier and resolves the recipient resource information needed for the notification, identifying the owner/manager associated with the delinquency so the correct party is addressed.
  • SEND_NOTIFICATION — Delivers the notification through the Workflow notification subsystem. It receives the item type, item key, and the workflow attribute name/value tables (numeric and text), and returns a status and result to the caller.

The header also declares package-level collection types (p_wf_item_NUMBER_NAME, p_wf_item_NUMBER_VALUE, p_wf_item_TEXT_NAME, p_wf_item_TEXT_VALUE) based on the wf_engine name and number table types, plus a DEL_NOTIFICATION_CUR REF CURSOR used to drive notification selection.

Tables Accessed

  • IEX_DEL_WF_S — The Collections delinquency/workflow staging table. It supplies the delinquency records driving the workflow and holds the state required to correlate a delinquency with its workflow item.
  • DUAL — Used for singleton SELECT expressions and PL/SQL constant evaluation.
  • PLITBLM — The standard Oracle Workflow/PL/SQL character table used for variable-length message and list data handling.

Usage Notes

This package is not intended for direct end-user invocation. It is normally called by the Advanced Collections workflow process definitions (via the SELECT_NOTICE function activity) and by other IEX packages that need to raise a closure notification; the ETRM metadata records one package referencing it. Developers extending Collections may call START_WORKFLOW directly from custom PL/SQL, passing the delinquency ID collection and respecting the FND_API initialization and commit conventions. Because the package name and public procedures are documented as an API, they are supported integration points in both 12.1.1 and 12.2.2, and any custom code should treat the parameter lists as fixed and reference the row types and ID collections (such as IEX_UTILITIES.t_del_id) exactly as declared in the specification.