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