1 PACKAGE OE_Delayed_Requests_PVT AS
2 /* $Header: OEXVREQS.pls 120.0.12010000.1 2008/07/25 08:06:59 appldev ship $ */
3
4 -- Log_Request will search if the request already exists based on the
5 -- combined key
6 -- entity_code, entity_id, and request_type and request_unique_key1-5.
7 -- The request is updated with
8 -- new values if the request exists else a new request is added to the
9 -- queue parameters.
10 /* Use this function to search if a request exists based on a key
11 entity_code, entity_id, request_type.
12 Parameters
13 IN p_entity_code
14 p_entity_id
15 p_request_type
16 p_request_unique_key1
17 p_request_unique_key2
18 p_request_unique_key3
19 p_request_unique_key4
20 p_request_unique_key5
21 */
22
23 g_delayed_requests OE_Order_PUB.Request_Tbl_Type;
24
25 TYPE Entity_Id_Rec_Type IS RECORD
26 ( request_ind NUMBER := FND_API.G_MISS_NUM
27 , entity_id NUMBER := FND_API.G_MISS_NUM
28 );
29
30 TYPE Entity_Id_Tbl_Type IS TABLE OF Entity_Id_Rec_Type
31 INDEX BY BINARY_INTEGER;
32
33 Procedure Log_Request
34 ( p_entity_code IN VARCHAR2
35 , p_entity_id IN NUMBER
36 , p_requesting_entity_code IN VARCHAR2
37 , p_requesting_entity_id IN NUMBER
38 , p_request_type IN VARCHAR2
39 , p_request_unique_key1 IN VARCHAR2 := NULL
40 , p_request_unique_key2 IN VARCHAR2 := NULL
41 , p_request_unique_key3 IN VARCHAR2 := NULL
42 , p_request_unique_key4 IN VARCHAR2 := NULL
43 , p_request_unique_key5 IN VARCHAR2 := NULL
44 , p_param1 IN VARCHAR2 := NULL
45 , p_param2 IN VARCHAR2 := NULL
46 , p_param3 IN VARCHAR2 := NULL
47 , p_param4 IN VARCHAR2 := NULL
48 , p_param5 IN VARCHAR2 := NULL
49 , p_param6 IN VARCHAR2 := NULL
50 , p_param7 IN VARCHAR2 := NULL
51 , p_param8 IN VARCHAR2 := NULL
52 , p_param9 IN VARCHAR2 := NULL
53 , p_param10 IN VARCHAR2 := NULL
54 , p_param11 IN VARCHAR2 := NULL
55 , p_param12 IN VARCHAR2 := NULL
56 , p_param13 IN VARCHAR2 := NULL
57 , p_param14 IN VARCHAR2 := NULL
58 , p_param15 IN VARCHAR2 := NULL
59 , p_param16 IN VARCHAR2 := NULL
60 , p_param17 IN VARCHAR2 := NULL
61 , p_param18 IN VARCHAR2 := NULL
62 , p_param19 IN VARCHAR2 := NULL
63 , p_param20 IN VARCHAR2 := NULL
64 , p_param21 IN VARCHAR2 := NULL
65 , p_param22 IN VARCHAR2 := NULL
66 , p_param23 IN VARCHAR2 := NULL
67 , p_param24 IN VARCHAR2 := NULL
68 , p_param25 IN VARCHAR2 := NULL
69 , p_date_param1 IN DATE := NULL
70 , p_date_param2 IN DATE := NULL
71 , p_date_param3 IN DATE := NULL
72 , p_date_param4 IN DATE := NULL
73 , p_date_param5 IN DATE := NULL
74 , p_date_param6 IN DATE := NULL
75 , p_date_param7 IN DATE := NULL
76 , p_date_param8 IN DATE := NULL
77 , p_long_param1 IN VARCHAR2 := NULL
78 , x_return_status OUT NOCOPY VARCHAR2
79
80 );
81
82 Function Check_for_Request
83 ( p_entity_code IN VARCHAR2
84 , p_entity_id IN NUMBER
85 , p_request_type IN VARCHAR2
86 , p_request_unique_key1 IN VARCHAR2 := NULL
87 , p_request_unique_key2 IN VARCHAR2 := NULL
88 , p_request_unique_key3 IN VARCHAR2 := NULL
89 , p_request_unique_key4 IN VARCHAR2 := NULL
90 , p_request_unique_key5 IN VARCHAR2 := NULL
91 )
92 RETURN BOOLEAN;
93
94 FUNCTION Requests_Count
95 RETURN NUMBER;
96
97 /* Use this procedure to delete a request based on key
98 entity_code, entity_id, request_type. The procedure does not do
99 anything if the request does not exist.
100 Parameters
101 IN p_entity_code
102 p_entity_id
103 p_request_type
104 p_request_unique_key1
105 p_request_unique_key2
106 p_request_unique_key3
107 p_request_unique_key4
108 p_request_unique_key5
109 out nocopy x_return_status
110
111 */
112 Procedure Delete_Request
113 ( p_entity_code IN Varchar2
114 , p_entity_id in Number
115 , p_request_Type in Varchar2
116 , p_request_unique_key1 IN VARCHAR2 := NULL
117 , p_request_unique_key2 IN VARCHAR2 := NULL
118 , p_request_unique_key3 IN VARCHAR2 := NULL
119 , p_request_unique_key4 IN VARCHAR2 := NULL
120 , p_request_unique_key5 IN VARCHAR2 := NULL
121 , x_return_status OUT NOCOPY Varchar2);
122
123
124 /* Use this procedure to clear all request in OE_Delayed_Requests
125 Parameters
126 out nocopy x_return_status
127
128 */
129 Procedure Clear_Request( x_return_status OUT NOCOPY VARCHAR2);
130
131
132 /* Use this procedure to process a request based on key
133 entity_code, entity_id, request_type and request_unique_key1-5.
134 The procedure does not do
135 anything if the request does not exists. It will delete a request
136 if parameter p_delete is set to FND_API.G_TRUE
137 Parameters
138 IN p_entity_code
139 p_entity_id
140 p_request_type
141 p_request_unique_key1
142 p_request_unique_key2
143 p_request_unique_key3
144 p_request_unique_key4
145 p_request_unique_key5
146 p_delete
147 out nocopy x_return_status
148
149 */
150 Procedure Process_Request( p_entity_code in Varchar2
151 ,p_entity_id in Number
152 ,p_request_Type in Varchar2
153 ,p_request_unique_key1 IN VARCHAR2 := NULL
154 ,p_request_unique_key2 IN VARCHAR2 := NULL
155 ,p_request_unique_key3 IN VARCHAR2 := NULL
156 ,p_request_unique_key4 IN VARCHAR2 := NULL
157 ,p_request_unique_key5 IN VARCHAR2 := NULL
158 ,p_delete in Varchar2 Default FND_API.G_TRUE
159 ,x_return_status OUT NOCOPY Varchar2);
160
161
162 /* Use this procedure to process a request for a entity
163 The procedure does not do anything if the request does not exists.
164 It will delete a request if parameter p_delete is set to FND_API.G_TRUE
165 Parameters
166 IN p_entity_code
167 IN p_delete
168 out nocopy x_return_status
169
170 */
171 Procedure Process_Request_for_Entity
172 ( p_entity_code in Varchar2
173 , p_delete in Varchar2 Default FND_API.G_TRUE
174 , x_return_status OUT NOCOPY Varchar2);
175
176
177 /* Use this procedure to process a request for a given request type
178 The procedure does not do anything if the request does not exist.
179 It will delete a request if parameter p_delete is set to FND_API.G_TRUE
180 Parameters
181 IN p_request_type
182 IN p_delete
183 out nocopy x_return_status
184
185 */
186 Procedure Process_Request_for_ReqType
187 ( p_request_type in Varchar2
188 , p_delete in Varchar2 Default FND_API.G_TRUE
189 , x_return_status OUT NOCOPY Varchar2
190
191 );
192
193 /* Use this procedure to process all requests in OE_Delayed_Requests
194 The procedure does not do anything if the request does not exist.
195 It will clear all the requests at the end.
196 Parameters
197 out nocopy x_return_status
198
199 */
200 Procedure Process_Delayed_Requests
201 ( x_return_status OUT NOCOPY VARCHAR2
202
203 );
204
205
206 PROCEDURE Process_Order_Actions
207 ( p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
208 , p_x_request_tbl IN OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.request_tbl_type
209 , p_process_WF_requests IN BOOLEAN := TRUE
210 );
211
212 /* Use this procedure to delete all requests when an entity is deleted.
213 IN p_entity_code
214 p_entity_id
215 out nocopy x_return_status
216
217 */
218 -- Bug 3800577
219 -- Make p_entity_id an optional parameter so if it is null, delete
220 -- all requests for that entity code
221 Procedure Delete_Reqs_for_Deleted_Entity
222 ( p_entity_code IN Varchar2
223 , p_delete_against IN BOOLEAN := TRUE
224 , p_entity_id in Number := NULL
225 , x_return_status OUT NOCOPY Varchar2);
226
227
228
229 End OE_Delayed_Requests_PVT;