1 PACKAGE QP_Delayed_Requests_PVT AUTHID CURRENT_USER AS
2 /* $Header: QPXVREQS.pls 120.0 2005/06/02 00:44:33 appldev noship $ */
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 Procedure Log_Request
24 ( p_entity_code IN VARCHAR2
25 , p_entity_id IN NUMBER
26 , p_requesting_entity_code IN VARCHAR2
27 , p_requesting_entity_id IN NUMBER
28 , p_request_type IN VARCHAR2
29 , p_request_unique_key1 IN VARCHAR2 := NULL
30 , p_request_unique_key2 IN VARCHAR2 := NULL
31 , p_request_unique_key3 IN VARCHAR2 := NULL
32 , p_request_unique_key4 IN VARCHAR2 := NULL
33 , p_request_unique_key5 IN VARCHAR2 := NULL
34 , p_param1 IN VARCHAR2 := NULL
35 , p_param2 IN VARCHAR2 := NULL
36 , p_param3 IN VARCHAR2 := NULL
37 , p_param4 IN VARCHAR2 := NULL
38 , p_param5 IN VARCHAR2 := NULL
39 , p_param6 IN VARCHAR2 := NULL
40 , p_param7 IN VARCHAR2 := NULL
41 , p_param8 IN VARCHAR2 := NULL
42 , p_param9 IN VARCHAR2 := NULL
43 , p_param10 IN VARCHAR2 := NULL
44 , p_param11 IN VARCHAR2 := NULL
45 , p_param12 IN VARCHAR2 := NULL
46 , p_param13 IN VARCHAR2 := NULL
47 , p_param14 IN VARCHAR2 := NULL
48 , p_param15 IN VARCHAR2 := NULL
49 , p_param16 IN VARCHAR2 := NULL
50 , p_param17 IN VARCHAR2 := NULL
51 , p_param18 IN VARCHAR2 := NULL
52 , p_param19 IN VARCHAR2 := NULL
53 , p_param20 IN VARCHAR2 := NULL
54 , p_param21 IN VARCHAR2 := NULL
55 , p_param22 IN VARCHAR2 := NULL
56 , p_param23 IN VARCHAR2 := NULL
57 , p_param24 IN VARCHAR2 := NULL
58 , p_param25 IN VARCHAR2 := NULL
59 , p_long_param1 IN VARCHAR2 := NULL
60 , x_return_status OUT NOCOPY VARCHAR2
61 );
62
63 Function Check_for_Request
64 ( p_entity_code IN VARCHAR2
65 , p_entity_id IN NUMBER
66 , p_request_type IN VARCHAR2
67 , p_request_unique_key1 IN VARCHAR2 := NULL
68 , p_request_unique_key2 IN VARCHAR2 := NULL
69 , p_request_unique_key3 IN VARCHAR2 := NULL
70 , p_request_unique_key4 IN VARCHAR2 := NULL
71 , p_request_unique_key5 IN VARCHAR2 := NULL
72 )
73 RETURN BOOLEAN;
74
75 /* Use this procedure to delete a request based on key
76 entity_code, entity_id, request_type. The procedure does not do
77 anything if the request does not exist.
78 Parameters
79 IN p_entity_code
80 p_entity_id
81 p_request_type
82 p_request_unique_key1
83 p_request_unique_key2
84 p_request_unique_key3
85 p_request_unique_key4
86 p_request_unique_key5
87 Out x_return_status
88 */
89 Procedure Delete_Request
90 ( p_entity_code IN Varchar2
91 , p_entity_id in Number
92 , p_request_Type in Varchar2
93 , p_request_unique_key1 IN VARCHAR2 := NULL
94 , p_request_unique_key2 IN VARCHAR2 := NULL
95 , p_request_unique_key3 IN VARCHAR2 := NULL
96 , p_request_unique_key4 IN VARCHAR2 := NULL
97 , p_request_unique_key5 IN VARCHAR2 := NULL
98 , x_return_status OUT NOCOPY Varchar2);
99
100 /* Use this procedure to clear all request in OE_Delayed_Requests
101 Parameters
102 Out x_return_status
103 */
104 Procedure Clear_Request( x_return_status OUT NOCOPY VARCHAR2);
105
106 /* Use this procedure to process a request based on key
107 entity_code, entity_id, request_type and request_unique_key1-5.
108 The procedure does not do
109 anything if the request does not exists. It will delete a request
110 if parameter p_delete is set to FND_API.G_TRUE
111 Parameters
112 IN p_entity_code
113 p_entity_id
114 p_request_type
115 p_request_unique_key1
116 p_request_unique_key2
117 p_request_unique_key3
118 p_request_unique_key4
119 p_request_unique_key5
120 p_delete
121 Out x_return_status
122 */
123 Procedure Process_Request( p_entity_code in Varchar2
124 ,p_entity_id in Number
125 ,p_request_Type in Varchar2
126 ,p_request_unique_key1 IN VARCHAR2 := NULL
127 ,p_request_unique_key2 IN VARCHAR2 := NULL
128 ,p_request_unique_key3 IN VARCHAR2 := NULL
129 ,p_request_unique_key4 IN VARCHAR2 := NULL
130 ,p_request_unique_key5 IN VARCHAR2 := NULL
131 ,p_delete in Varchar2 Default FND_API.G_TRUE
132 ,x_return_status OUT NOCOPY Varchar2);
133
134 /* Use this procedure to process a request for a entity
135 The procedure does not do anything if the request does not exists.
136 It will delete a request if parameter p_delete is set to FND_API.G_TRUE
137 Parameters
138 IN p_entity_code
139 IN p_delete
140 Out x_return_status
141 */
142 Procedure Process_Request_for_Entity
143 ( p_entity_code in Varchar2
144 , p_delete in Varchar2 Default FND_API.G_TRUE
145 , x_return_status OUT NOCOPY Varchar2);
146
147 /* Use this procedure to process a request for a given request type
148 The procedure does not do anything if the request does not exist.
149 It will delete a request if parameter p_delete is set to FND_API.G_TRUE
150 Parameters
151 IN p_request_type
152 IN p_delete
153 Out x_return_status
154 */
155 Procedure Process_Request_for_ReqType
156 ( p_request_type in Varchar2
157 , p_delete in Varchar2 Default FND_API.G_TRUE
158 , x_return_status OUT NOCOPY Varchar2
159 );
160
161 /* Use this procedure to process all requests in OE_Delayed_Requests
162 The procedure does not do anything if the request does not exist.
163 It will clear all the requests at the end.
164 Parameters
165 Out x_return_status
166 */
167
168 Procedure Process_Delayed_Requests
169 ( x_return_status OUT NOCOPY VARCHAR2
170 );
171
172
173
174 /* Use this procedure to delete all requests when an entity is deleted.
175 IN p_entity_code
176 p_entity_id
177 Out x_return_status
178 */
179 Procedure Delete_Reqs_for_Deleted_Entity
180 ( p_entity_code IN Varchar2
181 , p_entity_id in Number
182 , x_return_status OUT NOCOPY Varchar2);
183
184
185 End;