Search Results flush_requestitems

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

APPS.ITG_BATCHMANAGEMENT_PVT is a private PL/SQL package body that implements the batch management and workflow orchestration logic for the Oracle E-Business Suite ETRM (Enterprise Territory and Resource Management, delivered under the ITG module prefix). The package coordinates the lifecycle of batch processes, request items, and associated workflow activities. It is classified as a Private (PVT) API, meaning it is intended for internal consumption by other ETRM components rather than as a supported public integration interface.

The package exposes the classic EBS API conventions: procedures accept p_api_version, return an x_return_status conforming to FND_API conventions (for example FND_API.G_RET_STS_SUCCESS), and use NOCOPY OUT parameters for performance. Debug tracing is emitted through ITG_Debug.msg with short procedure tags such as 'GPSI', 'FRI', and 'ARI'. The package body header indicates an ARCS/CVS revision lineage dating to early 2003, reflecting that this is long-standing ETRM infrastructure retained across EBS releases.

Key Procedures and Functions

• GET_PROCESSSETID — Retrieves the process set identifier. In the documented body it returns a default process set ID and sets the return status to success, functioning as a lightweight lookup or placeholder for process set resolution.
• FLUSH_REQUESTITEMS — Flushes pending request items. Accepts a flag controlling whether the next item is retrieved (defaulting to FND_API.G_FALSE) and returns a process set ID.
• ADDED_REQUESTITEM — Invoked after a request item is added. It dynamically executes a call to a caller-supplied package (p_pkg_name) to start the batch process, capturing the CCM request ID via USING OUT. It then commits and performs additional processing derived from the original synchronous item code.
• WF_CHECK_BATCH_TIMEOUT — Checks whether a running batch has exceeded its permitted duration, supporting timeout handling within the workflow-driven batch.
• WF_GET_BATCH_INFO — Retrieves information about the current batch, supporting workflow decision points.
• WF_START_BATCH — Initiates the batch process as part of the workflow sequence.
• WF_RESTART_BATCH — Restarts a batch, typically after failure or interruption.
• WF_COMPLETE_BATCH — Marks a batch as complete. This is the procedure most closely associated with the search term wf_complete_batch, which corresponds to the WF_COMPLETE_BATCH procedure name (case-insensitive in PL/SQL).

Tables Accessed

The documented metadata lists a single referenced table via APPS synonyms: USER_OBJECTS. This data dictionary view is used to validate the existence and validity of database objects, most likely to confirm that a dynamically referenced package (as used in ADDED_REQUESTITEM) exists and is valid before constructing dynamic SQL. The dynamic invocation pattern reflects the package's role as a dispatcher that calls into caller-named packages.

Usage Notes

Because ITG_BATCHMANAGEMENT_PVT is a Private API, it is not intended for direct customer invocation. It is referenced by zero other packages per the documented metadata, so its callers are most likely Oracle Forms, workflow activity functions, or concurrent programs within the ETRM module rather than other PL/SQL APIs. The WF_ prefixed procedures indicate that the package is wired into Oracle Workflow as stored procedure activities, where WF_START_BATCH, WF_RESTART_BATCH, WF_GET_BATCH_INFO, WF_CHECK_BATCH_TIMEOUT, and WF_COMPLETE_BATCH are invoked as part of a workflow process definition. Administrators troubleshooting batch completion issues (for example, when searching for wf_complete_batch) should trace the workflow activity rather than call the procedure directly, and should confirm that the dynamically referenced Start_BatchProcess package is valid in USER_OBJECTS, since ADDED_REQUESTITEM depends on it. In EBS 12.1.1 and 12.2.2, the package resides in the APPS schema and its behavior is consistent across both releases.