1 PACKAGE XNP_TIMER_STANDARD AUTHID CURRENT_USER AS
2 /* $Header: XNPTSTAS.pls 120.2 2006/02/13 07:58:30 dputhiye ship $ */
3
4 -- Start the timer. Each timer package has a default method
5 -- called fire that is invoked to start the timer.
6 --
7 PROCEDURE FIRE
8 (p_order_id NUMBER DEFAULT NULL
9 ,p_workitem_instance_id NUMBER DEFAULT NULL
10 ,p_fa_instance_id NUMBER DEFAULT NULL
11 ,p_timer_code VARCHAR2
12 ,p_callback_ref_id VARCHAR2
13 ,x_error_code OUT NOCOPY NUMBER
14 ,x_error_message OUT NOCOPY VARCHAR2
15 );
16
17 -- Start timers related to the messge.
18 --
19 PROCEDURE START_RELATED_TIMERS
20 (p_message_code VARCHAR2
21 ,p_order_id NUMBER DEFAULT NULL
22 ,p_workitem_instance_id NUMBER DEFAULT NULL
23 ,p_fa_instance_id NUMBER DEFAULT NULL
24 ,p_callback_ref_id VARCHAR2
25 ,x_error_code OUT NOCOPY NUMBER
26 ,x_error_message OUT NOCOPY VARCHAR2
27 );
28
29 -- Retrieve the status for the given timer
30 --
31 PROCEDURE GET_TIMER_STATUS
32 (
33 p_reference_id IN VARCHAR2
34 ,p_timer_message_code IN VARCHAR2
35 ,x_timer_id OUT NOCOPY NUMBER
36 ,x_status OUT NOCOPY VARCHAR2
37 ,x_error_code OUT NOCOPY NUMBER
38 ,x_error_message OUT NOCOPY VARCHAR2
39 );
40
41 -- Restart all timers for the reference ID
42 --
43 PROCEDURE RESTART_ALL
44 (
45 p_reference_id IN VARCHAR2
46 ,x_error_code OUT NOCOPY NUMBER
47 ,x_error_message OUT NOCOPY VARCHAR2
48 );
49
50 -- Recalculate all timers for the reference ID
51 --
52 PROCEDURE RECALCULATE_ALL
53 (
54 p_reference_id IN VARCHAR2
55 ,x_error_code OUT NOCOPY NUMBER
56 ,x_error_message OUT NOCOPY VARCHAR2
57 );
58
59 -- Remove the timer for the given reference_ID
60 --
61 PROCEDURE REMOVE
62 (
63 p_reference_id IN VARCHAR2
64 ,p_timer_message_code IN VARCHAR2
65 ,x_error_code OUT NOCOPY NUMBER
66 ,x_error_message OUT NOCOPY VARCHAR2
67 );
68
69 -- Remove all timers for the given order ID
70 --
71 PROCEDURE DEREGISTER
72 (
73 p_order_id IN NUMBER
74 ,x_error_code OUT NOCOPY NUMBER
75 ,x_error_message OUT NOCOPY VARCHAR2
76 );
77
78 -- Remove all timers for a given Work Item
79 --
80 PROCEDURE DEREGISTER_FOR_WORKITEM
81 (
82 p_workitem_instance_id IN NUMBER
83 ,x_error_code OUT NOCOPY NUMBER
84 ,x_error_message OUT NOCOPY VARCHAR2
85 );
86
87 -- Retrieve the jeopardy flag given the order ID
88 --
89 PROCEDURE GET_JEOPARDY_FLAG
90 (
91 p_order_id IN NUMBER
92 ,x_flag OUT NOCOPY VARCHAR2
93 ,x_error_code OUT NOCOPY NUMBER
94 ,x_error_message OUT NOCOPY VARCHAR2
95 );
96 END XNP_TIMER_STANDARD;