1 PACKAGE XNP_TIMER_CORE AUTHID CURRENT_USER AS
2 /* $Header: XNPTBLPS.pls 120.1 2005/06/17 03:54:15 appldev $ */
3
4 -- Recalculate the values for delay and interval for the given timer
5 --
6 PROCEDURE recalculate
7 (
8 p_reference_id IN VARCHAR2
9 ,p_timer_message_code IN VARCHAR2
10 ,x_error_code OUT NOCOPY NUMBER
11 ,x_error_message OUT NOCOPY VARCHAR2
12 );
13
14 -- Recalculate the values for delay and interval for timers
15 -- associated with the reference ID.
16 --
17 PROCEDURE recalculate_all
18 (
19 p_reference_id IN VARCHAR2
20 ,x_error_code OUT NOCOPY NUMBER
21 ,x_error_message OUT NOCOPY VARCHAR2
22 );
23
24 -- Get status for the timer
25 --
26 PROCEDURE get_timer_status
27 (
28 p_reference_id IN VARCHAR2
29 ,p_timer_message_code IN VARCHAR2
30 ,x_timer_id OUT NOCOPY NUMBER
31 ,x_status OUT NOCOPY VARCHAR2
32 ,x_error_code OUT NOCOPY NUMBER
33 ,x_error_message OUT NOCOPY VARCHAR2
34 );
35
36 -- Get status for the timer
37 --
38 PROCEDURE get_timer_status
39 (
40 p_timer_id IN NUMBER
41 ,x_status OUT NOCOPY VARCHAR2
42 ,x_error_code OUT NOCOPY NUMBER
43 ,x_error_message OUT NOCOPY VARCHAR2
44 );
45
46 -- Update status for the timer
47 --
48 PROCEDURE update_timer_status
49 (
50 p_timer_id IN NUMBER
51 ,p_status IN VARCHAR2
52 ,x_error_code OUT NOCOPY NUMBER
53 ,x_error_message OUT NOCOPY VARCHAR2
54 );
55
56 -- Update status for the timer
57 --
58 PROCEDURE update_timer_status
59 (
60 p_reference_id IN VARCHAR2
61 ,p_timer_message_code IN VARCHAR2
62 ,p_status IN VARCHAR2
63 ,x_error_code OUT NOCOPY NUMBER
64 ,x_error_message OUT NOCOPY VARCHAR2
65 );
66
67 -- Remove timer using reference_ID and timer name
68 --
69 PROCEDURE remove_timer
70 (
71 p_reference_id IN VARCHAR2
72 ,p_timer_message_code IN VARCHAR2
73 ,x_error_code OUT NOCOPY NUMBER
74 ,x_error_message OUT NOCOPY VARCHAR2
75 );
76
77 -- Remove timer using timer_id
78 --
79 PROCEDURE remove_timer
80 (
81 p_timer_id IN NUMBER
82 ,x_error_code OUT NOCOPY NUMBER
83 ,x_error_message OUT NOCOPY VARCHAR2
84 );
85
86 -- Remove timer using order_ID
87 --
88 PROCEDURE deregister
89 (
90 p_order_id IN NUMBER
91 ,x_error_code OUT NOCOPY NUMBER
92 ,x_error_message OUT NOCOPY VARCHAR2
93 );
94
95 -- Remove all timers for a given Work Item
96 --
97 PROCEDURE deregister_for_workitem
98 (
99 p_workitem_instance_id IN NUMBER
100 ,x_error_code OUT NOCOPY NUMBER
101 ,x_error_message OUT NOCOPY VARCHAR2
102 );
103
104 -- Remove timer using order_ID
105 --
106 FUNCTION get_next_timer(p_timer_id NUMBER)
107 RETURN VARCHAR2 ;
108
109 -- Remove timer using order_id
110 --
111 PROCEDURE restart
112 (
113 p_reference_id IN VARCHAR2
114 ,p_timer_message_code IN VARCHAR2
115 ,x_error_code OUT NOCOPY NUMBER
116 ,x_error_message OUT NOCOPY VARCHAR2
117 );
118
119 -- Restart all timers for a specific reference ID
120 --
121 PROCEDURE restart_all
122 (
123 p_reference_id IN VARCHAR2
124 ,x_error_code OUT NOCOPY NUMBER
125 ,x_error_message OUT NOCOPY VARCHAR2
126
127 );
128
129 -- Start timers related to a given message
130 --
131 PROCEDURE start_related_timers
132 (
133 p_message_code IN VARCHAR2
134 ,p_reference_id IN VARCHAR2
135 ,x_error_code OUT NOCOPY NUMBER
136 ,x_error_message OUT NOCOPY VARCHAR2
137 ,p_opp_reference_id IN VARCHAR2 DEFAULT NULL
138 ,p_sender_name IN VARCHAR2 DEFAULT NULL
139 ,p_recipient_name IN VARCHAR2 DEFAULT NULL
140 ,p_order_id IN NUMBER DEFAULT NULL
141 ,p_wi_instance_id IN NUMBER DEFAULT NULL
142 ,p_fa_instance_id IN NUMBER DEFAULT NULL
143 );
144
145 -- Get jeopardy flag for the given order ID
146 --
147 PROCEDURE get_jeopardy_flag
148 (
149 p_order_id IN NUMBER
150 ,x_flag OUT NOCOPY VARCHAR2
151 ,x_error_code OUT NOCOPY NUMBER
152 ,x_error_message OUT NOCOPY VARCHAR2
153 );
154
155 -- Wrapper to the XNP_<Timer Code>_U.FIRE procedure
156 --
157 PROCEDURE FIRE ( p_timer_code IN VARCHAR2,
158 x_timer_id OUT NOCOPY NUMBER,
159 x_timer_contents OUT NOCOPY VARCHAR2,
160 x_error_code OUT NOCOPY NUMBER,
161 x_error_message OUT NOCOPY VARCHAR2,
162 p_sender_name IN VARCHAR2 DEFAULT NULL,
163 p_recipient_list IN VARCHAR2 DEFAULT NULL,
164 p_version IN NUMBER DEFAULT 1,
165 p_reference_id IN VARCHAR2 DEFAULT NULL,
166 p_opp_reference_id IN VARCHAR2 DEFAULT NULL,
167 p_order_id IN NUMBER DEFAULT NULL,
168 p_wi_instance_id IN NUMBER DEFAULT NULL,
169 p_fa_instance_id IN NUMBER DEFAULT NULL
170 );
171
172 END xnp_timer_core;