Search Results recalculate_all

Overview

XNP_TIMER_STANDARD is a PL/SQL package owned by APPS in the Oracle E-Business Suite, classified as an OTHER API within the ETRM (E-Business Suite Technical Reference Manual) repository. It belongs to the XNP module, which supports the Order Management and fulfillment scheduling infrastructure — specifically the timer and jeopardy management framework used to monitor time-based commitments such as order scheduling, shipping, and delivery deadlines. The package provides a standard implementation of the timer interface, allowing fulfillment flows to create, query, restart, recalculate, and remove timers that track whether processing milestones are met within their allotted windows. Its AUTHID CURRENT_USER declaration indicates it executes with the privileges of the calling schema, which is significant for how it is granted and invoked in a multi-schema EBS environment. The header revision ($Header: XNPTSTAS.pls 120.2 2006/02/13) confirms that the package has been stable since the early 12.x code line and is carried forward into 12.1.1 and 12.2.2 without functional change.

Key Procedures and Functions

• FIRE — The default entry point for the timer interface. It starts a timer based on a timer code and callback reference, optionally scoped to an order, work item instance, or fulfillment (FA) instance. It returns error code and message output parameters.
• START_RELATED_TIMERS — Starts all timers associated with a given message code, again optionally scoped to an order, work item, or fulfillment instance.
• GET_TIMER_STATUS — Returns the internal timer ID and current status for a supplied reference ID and timer message code.
• RESTART_ALL — Restarts every timer associated with a given reference ID.
• RECALCULATE_ALL — Recomputes the due dates/expirations for all timers under a reference ID, typically after a scheduling change.
• REMOVE — Removes a single timer identified by reference ID and timer message code.
• DEREGISTER — Removes all timers associated with a specific order ID.
• DEREGISTER_FOR_WORKITEM — The procedure the user searched for. It deletes or deactivates timers tied specifically to a work item instance, used when a work item completes, is cancelled, or is otherwise no longer relevant, so that stale timers do not fire or raise false jeopardy alerts. It is the work-item-scoped counterpart to DEREGISTER.
• GET_JEOPARDY_FLAG — Returns a flag indicating whether the associated timer/order is in jeopardy (i.e., at risk of or past its due date).

Tables Accessed

The ETRM metadata does not enumerate base tables for this package; it references objects exclusively through APPS synonyms. Based on the XNP timer framework, these are the underlying XNP timer definition and timer instance tables that store timer codes, reference IDs, due dates, statuses, and callback references. The procedures read timer definitions and write timer instances and status values.

Usage Notes

XNP_TIMER_STANDARD is invoked by the Order Management fulfillment flows, the scheduling/jeopardy concurrent programs, and by other PL/SQL packages (three are documented as referencing it). DEREGISTER_FOR_WORKITEM is typically called at the close of work item processing — for example when a pick, ship, or delivery work item completes or is cancelled — to clean up pending timers. Customizations extending order fulfillment should call FIRE to register timers and DEREGISTER_FOR_WORKITEM or DEREGISTER to release them, always checking the returned error code and message, and should never call the package directly from client-side code without proper APPS grants.