Search Results select_notice




Overview
Explore in AI Chat

Overview

APPS.IEX_WF_REP_STATUS_PUB is a public PL/SQL package within the Oracle E-Business Suite Collections (Advanced Collections / IEX) module. Its central purpose is to integrate the collections workflow with third-party repossession notification processing. The package header identifies it as an AUTHID CURRENT_USER package, and its internal comments state that it is called by the collections workflow to notify a third party for repossession. It therefore acts as the workflow-callable API that drives the Oracle Workflow notification and response cycle for repossession activity handled by collections agents.

The source header indicates an original creation date of 2002 and an ETRM version of 115.1, which is consistent with the long-lived nature of collections workflow APIs that were carried forward into EBS 12.1.1 and 12.2.2 largely unchanged. The package is a public API, meaning it is intended to be invoked from outside the module—principally from Oracle Workflow function activities and workflow notification processing.

Key Procedures and Functions

The documented package exposes two procedures: START_WORKFLOW and SELECT_NOTICE.

  • START_WORKFLOW — Initiates the workflow process used to notify a third party regarding a repossession. Its parameters include the standard Oracle EBS API conventions (API version, initialization of the message list, and commit flag) alongside business identifiers for the delinquency, the repossession, and the third party, a third-party name reference, and a status indicator. It returns the standard API return status plus message count and message data outputs. This procedure is the entry point that hands control from the collections transaction to Oracle Workflow.
  • SELECT_NOTICE — A workflow function activity used to determine or select the appropriate notice. It accepts the standard Oracle Workflow function-activity parameters—item type, item key, activity ID, and function mode—and returns a result value that Oracle Workflow interprets to branch or complete the process. It is this procedure that supports the branching logic within the repossession notification workflow.

Tables Accessed

No tables are documented as referenced through APPS synonyms in the available ETRM metadata, and the package is not listed as referenced by any other package. Given its role, the package operates primarily against Oracle Workflow runtime tables and the Collections repossession and third-party records identified by the parameters passed to START_WORKFLOW. Where the underlying data is manipulated, it is done by the workflow engine and by the collections entities referenced by identifier rather than by direct table access within this package's documented surface.

Usage Notes

This package is typically invoked from Oracle Workflow rather than from a form or concurrent program directly. START_WORKFLOW is called by the collections workflow to launch the third-party repossession notification, and SELECT_NOTICE is registered as a workflow function activity (the funcmode parameter follows the standard run/cancel/test/save conventions). Customizations and integrations should treat both procedures as the supported public interface, invoke START_WORKFLOW with the standard API versioning and message-list conventions, and always inspect x_return_status and the associated message outputs before proceeding. Because behavior is governed by the ETRM-documented signatures, parameter lists should not be altered.