[Home] [Help]
PACKAGE: APPS.ASO_ORDER_FEEDBACK_PUB
Source
1 PACKAGE ASO_ORDER_FEEDBACK_PUB AUTHID CURRENT_USER AS
2 /* $Header: asopomfs.pls 120.2 2010/05/05 12:42:40 rassharm ship $ */
3
4 -- ---------------------------------------------------------
5 -- Declare Data Types
6 -- ---------------------------------------------------------
7
8 -- ---------------------------------------------------------
9 -- Declare Procedures
10 -- ---------------------------------------------------------
11
12 --------------------------------------------------------------------------
13
14 -- Start of comments
15 -- API name : UPDATE_NOTICE
16 -- Type : Public
17 -- Function : This API is the PUBLIC API that is invoked by Order Manager
18 -- to communicate any changes (inserts/updates/deletes) to the
19 -- Order Entities to Oracle Order Capture application.
20 -- Pre-reqs : None.
21 --
22 -- Standard IN Parameters:
23 -- p_api_version IN NUMBER Required
24 -- p_init_msg_list IN VARCHAR2 Optional
25 -- Default = FND_API.G_FALSE
26 -- p_commit IN VARCHAR2 Optional
27 -- Default = FND_API.G_FALSE
28 --
29 -- Standard OUT NOCOPY /* file.sql.39 change */ Parameters:
30 -- x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2(1)
31 -- x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
32 -- x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2(2000)
33 --
34 -- UPDATE_NOTICE API specific IN Parameters:
35 --
36 -- ALL PARAMETERS ARE OPTIONAL
37 --
38 -- p_header_rec IN OE_Order_PUB.Header_Rec_Type
39 -- Default = OE_Order_PUB.G_MISS_HEADER_REC
40 -- p_old_header_rec IN OE_Order_PUB.Header_Rec_Type
41 -- Default = OE_ORDER_PUB.G_MISS_HEADER_REC
42 -- p_Header_Adj_tbl IN OE_Order_PUB.Header_Adj_Tbl_Type
43 -- Default = OE_ORDER_PUB.G_MISS_HEADER_ADJ_TBL
44 -- p_old_Header_Adj_tbl IN OE_Order_PUB.Header_Adj_Tbl_Type
45 -- Default = OE_ORDER_PUB.G_MISS_HEADER_ADJ_TBL
46 -- p_Header_price_Att_tbl IN OE_Order_PUB.Header_Price_Att_Tbl_Type
47 -- Default = OE_ORDER_PUB.G_MISS_HEADER_PRICE_ATT_TBL
48 -- p_old_Header_Price_Att_tbl IN OE_Order_PUB.Header_Price_Att_Tbl_Type
49 -- Default = OE_ORDER_PUB.G_MISS_HEADER_PRICE_ATT_TBL
50 -- p_Header_Adj_Att_tbl IN OE_Order_PUB.Header_Adj_Att_Tbl_Type
51 -- Default = OE_ORDER_PUB.G_MISS_HEADER_ADJ_ATT_TBL
52 -- p_old_Header_Adj_Att_tbl IN OE_Order_PUB.Header_Adj_Att_Tbl_Type
53 -- Default = OE_ORDER_PUB.G_MISS_HEADER_ADJ_ATT_TBL
54 -- p_Header_Adj_Assoc_tbl IN OE_Order_PUB.Header_Adj_Assoc_Tbl_Type
55 -- Default = OE_ORDER_PUB.G_MISS_HEADER_ADJ_ASSOC_TBL
56 -- p_old_Header_Adj_Assoc_tbl IN OE_Order_PUB.Header_Adj_Assoc_Tbl_Type
57 -- Default = OE_ORDER_PUB.G_MISS_HEADER_ADJ_ASSOC_TBL
58 -- p_Header_Scredit_tbl IN OE_Order_PUB.Header_Scredit_Tbl_Type
59 -- Default = OE_ORDER_PUB.G_MISS_HEADER_SCREDIT_TBL
60 -- p_old_Header_Scredit_tbl IN OE_Order_PUB.Header_Scredit_Tbl_Type
61 -- Default = OE_ORDER_PUB.G_MISS_HEADER_SCREDIT_TBL
62 -- p_line_tbl IN OE_Order_PUB.Line_Tbl_Type
63 -- Default = OE_ORDER_PUB.G_MISS_LINE_TBL
64 -- p_old_line_tbl IN OE_Order_PUB.Line_Tbl_Type
65 -- Default = OE_ORDER_PUB.G_MISS_LINE_TBL
66 -- p_Line_Adj_tbl IN OE_Order_PUB.Line_Adj_Tbl_Type
67 -- Default = OE_ORDER_PUB.G_MISS_LINE_ADJ_TBL
68 -- p_old_Line_Adj_tbl IN OE_Order_PUB.Line_Adj_Tbl_Type
69 -- Default = OE_ORDER_PUB.G_MISS_LINE_ADJ_TBL
70 -- p_Line_Price_Att_tbl IN OE_Order_PUB.Line_Price_Att_Tbl_Type
71 -- Default = OE_ORDER_PUB.G_MISS_LINE_PRICE_ATT_TBL
72 -- p_old_Line_Price_Att_tbl IN OE_Order_PUB.Line_Price_Att_Tbl_Type
73 -- Default = OE_ORDER_PUB.G_MISS_LINE_PRICE_ATT_TBL
74 -- p_Line_Adj_Att_tbl IN OE_Order_PUB.Line_Adj_Att_Tbl_Type
75 -- Default = OE_ORDER_PUB.G_MISS_LINE_ADJ_ATT_TBL
76 -- p_old_Line_Adj_Att_tbl IN OE_Order_PUB.Line_Adj_Att_Tbl_Type
77 -- Default = OE_ORDER_PUB.G_MISS_LINE_ADJ_ATT_TBL
78 -- p_Line_Adj_Assoc_tbl IN OE_Order_PUB.Line_Adj_Assoc_Tbl_Type
79 -- Default = OE_ORDER_PUB.G_MISS_LINE_ADJ_ASSOC_TBL
80 -- p_old_Line_Adj_Assoc_tbl IN OE_Order_PUB.Line_Adj_Assoc_Tbl_Type
81 -- Default = OE_ORDER_PUB.G_MISS_LINE_ADJ_ASSOC_TBL
82 -- p_Line_Scredit_tbl IN OE_Order_PUB.Line_Scredit_Tbl_Type
83 -- Default = OE_ORDER_PUB.G_MISS_LINE_SCREDIT_TBL
84 -- p_old_Line_Scredit_tbl IN OE_Order_PUB.Line_Scredit_Tbl_Type
85 -- Default = OE_ORDER_PUB.G_MISS_LINE_SCREDIT_TBL
86 -- p_Lot_Serial_tbl IN OE_Order_PUB.Lot_Serial_Tbl_Type
87 -- Default = OE_ORDER_PUB.G_MISS_LOT_SERIAL_TBL
88 -- p_old_Lot_Serial_tbl IN OE_Order_PUB.Lot_Serial_Tbl_Type
89 -- Default = OE_ORDER_PUB.G_MISS_LOT_SERIAL_TBL
90 -- p_action_request_tbl IN OE_Order_PUB.Request_Tbl_Type
91 -- Default = OE_ORDER_PUB.G_MISS_REQUEST_TBL
92 --
93 --
94 -- UPDATE_NOTICE API specific OUT NOCOPY /* file.sql.39 change */ Parameters:
95 -- none
96 --
97 -- Version : Current version 1.0
98 -- Initial version 1.0
99 --
100 -- End of comments
101 --------------------------------------------------------------------------
102
103 PROCEDURE UPDATE_NOTICE
104 (
105 p_api_version IN NUMBER,
106 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
107 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
108 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
109 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
110 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
111 p_header_rec IN OE_Order_PUB.Header_Rec_Type :=
112 OE_Order_PUB.G_MISS_HEADER_REC,
113 p_old_header_rec IN OE_Order_PUB.Header_Rec_Type :=
114 OE_Order_PUB.G_MISS_HEADER_REC,
115 p_Header_Adj_tbl IN OE_Order_PUB.Header_Adj_Tbl_Type :=
116 OE_Order_PUB.G_MISS_HEADER_ADJ_TBL,
117 p_old_Header_Adj_tbl IN OE_Order_PUB.Header_Adj_Tbl_Type :=
118 OE_Order_PUB.G_MISS_HEADER_ADJ_TBL,
119 p_Header_price_Att_tbl IN OE_Order_PUB.Header_Price_Att_Tbl_Type :=
120 OE_Order_PUB.G_MISS_HEADER_PRICE_ATT_TBL,
121 p_old_Header_Price_Att_tbl IN OE_Order_PUB.Header_Price_Att_Tbl_Type :=
122 OE_Order_PUB.G_MISS_HEADER_PRICE_ATT_TBL,
123 p_Header_Adj_Att_tbl IN OE_Order_PUB.Header_Adj_Att_Tbl_Type :=
124 OE_Order_PUB.G_MISS_HEADER_ADJ_ATT_TBL,
125 p_old_Header_Adj_Att_tbl IN OE_Order_PUB.Header_Adj_Att_Tbl_Type :=
126 OE_Order_PUB.G_MISS_HEADER_ADJ_ATT_TBL,
127 p_Header_Adj_Assoc_tbl IN OE_Order_PUB.Header_Adj_Assoc_Tbl_Type :=
128 OE_Order_PUB.G_MISS_HEADER_ADJ_ASSOC_TBL,
129 p_old_Header_Adj_Assoc_tbl IN OE_Order_PUB.Header_Adj_Assoc_Tbl_Type :=
130 OE_Order_PUB.G_MISS_HEADER_ADJ_ASSOC_TBL,
131 p_Header_Scredit_tbl IN OE_Order_PUB.Header_Scredit_Tbl_Type :=
132 OE_Order_PUB.G_MISS_HEADER_SCREDIT_TBL,
133 p_old_Header_Scredit_tbl IN OE_Order_PUB.Header_Scredit_Tbl_Type :=
134 OE_Order_PUB.G_MISS_HEADER_SCREDIT_TBL,
135 p_line_tbl IN OE_Order_PUB.Line_Tbl_Type :=
136 OE_Order_PUB.G_MISS_LINE_TBL,
137 p_old_line_tbl IN OE_Order_PUB.Line_Tbl_Type :=
138 OE_Order_PUB.G_MISS_LINE_TBL,
139 p_Line_Adj_tbl IN OE_Order_PUB.Line_Adj_Tbl_Type :=
140 OE_Order_PUB.G_MISS_LINE_ADJ_TBL,
141 p_old_Line_Adj_tbl IN OE_Order_PUB.Line_Adj_Tbl_Type :=
142 OE_Order_PUB.G_MISS_LINE_ADJ_TBL,
143 p_Line_Price_Att_tbl IN OE_Order_PUB.Line_Price_Att_Tbl_Type :=
144 OE_Order_PUB.G_MISS_LINE_PRICE_ATT_TBL,
145 p_old_Line_Price_Att_tbl IN OE_Order_PUB.Line_Price_Att_Tbl_Type :=
146 OE_Order_PUB.G_MISS_LINE_PRICE_ATT_TBL,
147 p_Line_Adj_Att_tbl IN OE_Order_PUB.Line_Adj_Att_Tbl_Type :=
148 OE_Order_PUB.G_MISS_LINE_ADJ_ATT_TBL,
149 p_old_Line_Adj_Att_tbl IN OE_Order_PUB.Line_Adj_Att_Tbl_Type :=
150 OE_Order_PUB.G_MISS_LINE_ADJ_ATT_TBL,
151 p_Line_Adj_Assoc_tbl IN OE_Order_PUB.Line_Adj_Assoc_Tbl_Type :=
152 OE_Order_PUB.G_MISS_LINE_ADJ_ASSOC_TBL,
153 p_old_Line_Adj_Assoc_tbl IN OE_Order_PUB.Line_Adj_Assoc_Tbl_Type :=
154 OE_Order_PUB.G_MISS_LINE_ADJ_ASSOC_TBL,
155 p_Line_Scredit_tbl IN OE_Order_PUB.Line_Scredit_Tbl_Type :=
156 OE_Order_PUB.G_MISS_LINE_SCREDIT_TBL,
157 p_old_Line_Scredit_tbl IN OE_Order_PUB.Line_Scredit_Tbl_Type :=
158 OE_Order_PUB.G_MISS_LINE_SCREDIT_TBL,
159 p_Lot_Serial_tbl IN OE_Order_PUB.Lot_Serial_Tbl_Type :=
160 OE_Order_PUB.G_MISS_LOT_SERIAL_TBL,
161 p_old_Lot_Serial_tbl IN OE_Order_PUB.Lot_Serial_Tbl_Type :=
162 OE_Order_PUB.G_MISS_LOT_SERIAL_TBL,
163 p_action_request_tbl IN OE_Order_PUB.Request_Tbl_Type :=
164 OE_Order_PUB.G_MISS_REQUEST_TBL
165 );
166
167
168 --------------------------------------------------------------------------
169
170 -- Start of comments
171 -- API name : GET_NOTICE
172 -- Type : Public
173 -- Function : This API is the PUBLIC API that is invoked by CRM Apps
174 -- to get the data regarding changes (inserts/updates/deletes) to the
175 -- Order Entities communicated by the Order Management application.
176 -- Pre-reqs : None.
177 --
178 -- Standard IN Parameters:
179 -- p_api_version IN NUMBER Required
180 -- p_init_msg_list IN VARCHAR2 Optional
181 -- Default = FND_API.G_FALSE
182 -- p_commit IN VARCHAR2 Optional
183 -- Default = FND_API.G_FALSE
184 --
185 -- Standard OUT NOCOPY /* file.sql.39 change */ Parameters:
186 -- x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2(1)
187 -- x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
188 -- x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2(2000)
189 --
190 -- GET_NOTICE API specific IN Parameters:
191 -- p_app_short_name IN VARCHAR2 Required
192 -- p_wait IN NUMBER Optional
193 -- Default = DBMS_AQ.NO_WAIT
194 --
195 -- GET_NOTICE API specific OUT NOCOPY /* file.sql.39 change */ Parameters:
196 --
197 -- x_no_more_messages OUT NOCOPY /* file.sql.39 change */ VARCHAR2
198 -- x_header_rec OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Rec_Type
199 -- x_old_header_rec OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Rec_Type
200 -- x_Header_Adj_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Tbl_Type
201 -- x_old_Header_Adj_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Tbl_Type
202 -- x_Header_price_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Price_Att_Tbl_Type
203 -- x_old_Header_Price_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Price_Att_Tbl_Type
204 -- x_Header_Adj_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Att_Tbl_Type
205 -- x_old_Header_Adj_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Att_Tbl_Type
206 -- x_Header_Adj_Assoc_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Assoc_Tbl_Type
207 -- x_old_Header_Adj_Assoc_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Assoc_Tbl_Type
208 -- x_Header_Scredit_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Scredit_Tbl_Type
209 -- x_old_Header_Scredit_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Scredit_Tbl_Type
213 -- x_old_Line_Adj_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Tbl_Type
210 -- x_line_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Tbl_Type
211 -- x_old_line_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Tbl_Type
212 -- x_Line_Adj_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Tbl_Type
214 -- x_Line_Price_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Price_Att_Tbl_Type
215 -- x_old_Line_Price_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Price_Att_Tbl_Type
216 -- x_Line_Adj_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Att_Tbl_Type
217 -- x_old_Line_Adj_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Att_Tbl_Type
218 -- x_Line_Adj_Assoc_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Assoc_Tbl_Type
219 -- x_old_Line_Adj_Assoc_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Assoc_Tbl_Type
220 -- x_Line_Scredit_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Scredit_Tbl_Type
221 -- x_old_Line_Scredit_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Scredit_Tbl_Type
222 -- x_Lot_Serial_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Lot_Serial_Tbl_Type
223 -- x_old_Lot_Serial_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Lot_Serial_Tbl_Type
224 -- x_action_request_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Request_Tbl_Type
225 --
226 --
227 -- Version : Current version 1.0
228 -- Initial version 1.0
229 --
230 -- End of comments
231 --------------------------------------------------------------------------
232
233 PROCEDURE GET_NOTICE
234 (
235 p_api_version IN NUMBER,
236 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
237 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
238 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
239 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
240 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
241 p_app_short_name IN VARCHAR2,
242 p_wait IN NUMBER DEFAULT DBMS_AQ.NO_WAIT,
243 p_deq_condition IN VARCHAR2 DEFAULT NULL, /* Bug 9410311 */
244 x_no_more_messages OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
245 x_header_rec OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Rec_Type,
246 x_old_header_rec OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Rec_Type,
247 x_Header_Adj_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Tbl_Type,
248 x_old_Header_Adj_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Tbl_Type,
249 x_Header_price_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Price_Att_Tbl_Type,
250 x_old_Header_Price_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Price_Att_Tbl_Type,
251 x_Header_Adj_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Att_Tbl_Type,
252 x_old_Header_Adj_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Att_Tbl_Type,
253 x_Header_Adj_Assoc_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Assoc_Tbl_Type,
254 x_old_Header_Adj_Assoc_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Assoc_Tbl_Type,
255 x_Header_Scredit_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Scredit_Tbl_Type,
256 x_old_Header_Scredit_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Scredit_Tbl_Type,
257 x_line_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Tbl_Type,
258 x_old_line_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Tbl_Type,
259 x_Line_Adj_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Tbl_Type,
260 x_old_Line_Adj_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Tbl_Type,
261 x_Line_Price_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Price_Att_Tbl_Type,
262 x_old_Line_Price_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Price_Att_Tbl_Type,
263 x_Line_Adj_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Att_Tbl_Type,
264 x_old_Line_Adj_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Att_Tbl_Type,
265 x_Line_Adj_Assoc_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Assoc_Tbl_Type,
266 x_old_Line_Adj_Assoc_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Assoc_Tbl_Type,
267 x_Line_Scredit_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Scredit_Tbl_Type,
268 x_old_Line_Scredit_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Scredit_Tbl_Type,
269 x_Lot_Serial_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Lot_Serial_Tbl_Type,
270 x_old_Lot_Serial_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Lot_Serial_Tbl_Type,
271 x_action_request_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Request_Tbl_Type
272 );
273
274
275 --------------------------------------------------------------------------
276
277 -- Start of comments
278 -- API name : HANDLE_EXCEPTION
279 -- Type : Public
280 -- Function : This API is the PUBLIC API that is invoked by consumer apps
281 -- to enqueue a failed message in the Order Feedback Exception
282 -- Queue. Consumers may use the GET_EXCEPTION public API
283 -- to subsequently dequeue these failed message. If p_commit is
284 -- set to true the message is enqueued in an immediate mode and
285 -- is immediately available in for dequeueing by the
286 -- GET_EXCEPTION API, otherwise the message is available in
290 -- Standard IN Parameters:
287 -- the exception queue only after the calling application commits.
288 -- Pre-reqs : None.
289 --
291 -- p_api_version IN NUMBER Required
292 -- p_init_msg_list IN VARCHAR2 Optional
293 -- Default = FND_API.G_FALSE
294 -- p_commit IN VARCHAR2 Optional
295 -- Default = FND_API.G_FALSE
296 --
297 -- Standard OUT NOCOPY /* file.sql.39 change */ Parameters:
298 -- x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2(1)
299 -- x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
300 -- x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2(2000)
301 --
302 -- HANDLE_EXCEPTION API specific IN Parameters:
303
304 -- p_app_short_name IN VARCHAR2 Required
305 --
306 -- ALL PARAMETERS BELOW ARE OPTIONAL
307 --
308 -- p_header_rec IN OE_Order_PUB.Header_Rec_Type
309 -- Default = OE_Order_PUB.G_MISS_HEADER_REC
310 -- p_old_header_rec IN OE_Order_PUB.Header_Rec_Type
311 -- Default = OE_ORDER_PUB.G_MISS_HEADER_REC
312 -- p_Header_Adj_tbl IN OE_Order_PUB.Header_Adj_Tbl_Type
313 -- Default = OE_ORDER_PUB.G_MISS_HEADER_ADJ_TBL
314 -- p_old_Header_Adj_tbl IN OE_Order_PUB.Header_Adj_Tbl_Type
315 -- Default = OE_ORDER_PUB.G_MISS_HEADER_ADJ_TBL
316 -- p_Header_price_Att_tbl IN OE_Order_PUB.Header_Price_Att_Tbl_Type
317 -- Default = OE_ORDER_PUB.G_MISS_HEADER_PRICE_ATT_TBL
318 -- p_old_Header_Price_Att_tbl IN OE_Order_PUB.Header_Price_Att_Tbl_Type
319 -- Default = OE_ORDER_PUB.G_MISS_HEADER_PRICE_ATT_TBL
320 -- p_Header_Adj_Att_tbl IN OE_Order_PUB.Header_Adj_Att_Tbl_Type
321 -- Default = OE_ORDER_PUB.G_MISS_HEADER_ADJ_ATT_TBL
322 -- p_old_Header_Adj_Att_tbl IN OE_Order_PUB.Header_Adj_Att_Tbl_Type
323 -- Default = OE_ORDER_PUB.G_MISS_HEADER_ADJ_ATT_TBL
324 -- p_Header_Adj_Assoc_tbl IN OE_Order_PUB.Header_Adj_Assoc_Tbl_Type
325 -- Default = OE_ORDER_PUB.G_MISS_HEADER_ADJ_ASSOC_TBL
326 -- p_old_Header_Adj_Assoc_tbl IN OE_Order_PUB.Header_Adj_Assoc_Tbl_Type
327 -- Default = OE_ORDER_PUB.G_MISS_HEADER_ADJ_ASSOC_TBL
328 -- p_Header_Scredit_tbl IN OE_Order_PUB.Header_Scredit_Tbl_Type
329 -- Default = OE_ORDER_PUB.G_MISS_HEADER_SCREDIT_TBL
330 -- p_old_Header_Scredit_tbl IN OE_Order_PUB.Header_Scredit_Tbl_Type
331 -- Default = OE_ORDER_PUB.G_MISS_HEADER_SCREDIT_TBL
332 -- p_line_tbl IN OE_Order_PUB.Line_Tbl_Type
333 -- Default = OE_ORDER_PUB.G_MISS_LINE_TBL
334 -- p_old_line_tbl IN OE_Order_PUB.Line_Tbl_Type
335 -- Default = OE_ORDER_PUB.G_MISS_LINE_TBL
336 -- p_Line_Adj_tbl IN OE_Order_PUB.Line_Adj_Tbl_Type
337 -- Default = OE_ORDER_PUB.G_MISS_LINE_ADJ_TBL
338 -- p_old_Line_Adj_tbl IN OE_Order_PUB.Line_Adj_Tbl_Type
339 -- Default = OE_ORDER_PUB.G_MISS_LINE_ADJ_TBL
340 -- p_Line_Price_Att_tbl IN OE_Order_PUB.Line_Price_Att_Tbl_Type
341 -- Default = OE_ORDER_PUB.G_MISS_LINE_PRICE_ATT_TBL
342 -- p_old_Line_Price_Att_tbl IN OE_Order_PUB.Line_Price_Att_Tbl_Type
343 -- Default = OE_ORDER_PUB.G_MISS_LINE_PRICE_ATT_TBL
344 -- p_Line_Adj_Att_tbl IN OE_Order_PUB.Line_Adj_Att_Tbl_Type
345 -- Default = OE_ORDER_PUB.G_MISS_LINE_ADJ_ATT_TBL
346 -- p_old_Line_Adj_Att_tbl IN OE_Order_PUB.Line_Adj_Att_Tbl_Type
347 -- Default = OE_ORDER_PUB.G_MISS_LINE_ADJ_ATT_TBL
348 -- p_Line_Adj_Assoc_tbl IN OE_Order_PUB.Line_Adj_Assoc_Tbl_Type
349 -- Default = OE_ORDER_PUB.G_MISS_LINE_ADJ_ASSOC_TBL
350 -- p_old_Line_Adj_Assoc_tbl IN OE_Order_PUB.Line_Adj_Assoc_Tbl_Type
351 -- Default = OE_ORDER_PUB.G_MISS_LINE_ADJ_ASSOC_TBL
352 -- p_Line_Scredit_tbl IN OE_Order_PUB.Line_Scredit_Tbl_Type
353 -- Default = OE_ORDER_PUB.G_MISS_LINE_SCREDIT_TBL
354 -- p_old_Line_Scredit_tbl IN OE_Order_PUB.Line_Scredit_Tbl_Type
355 -- Default = OE_ORDER_PUB.G_MISS_LINE_SCREDIT_TBL
356 -- p_Lot_Serial_tbl IN OE_Order_PUB.Lot_Serial_Tbl_Type
357 -- Default = OE_ORDER_PUB.G_MISS_LOT_SERIAL_TBL
358 -- p_old_Lot_Serial_tbl IN OE_Order_PUB.Lot_Serial_Tbl_Type
359 -- Default = OE_ORDER_PUB.G_MISS_LOT_SERIAL_TBL
360 -- p_action_request_tbl IN OE_Order_PUB.Request_Tbl_Type
361 -- Default = OE_ORDER_PUB.G_MISS_REQUEST_TBL
362 --
363 --
364 -- HANDLE_EXCEPTION API specific OUT NOCOPY /* file.sql.39 change */ Parameters:
365 -- none
366 --
367 -- Version : Current version 1.0
368 -- Initial version 1.0
369 --
370 -- End of comments
371 --------------------------------------------------------------------------
372
373 PROCEDURE HANDLE_EXCEPTION
374 (
375 p_api_version IN NUMBER,
376 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
377 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
378 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
379 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
383 OE_Order_PUB.G_MISS_HEADER_REC,
380 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
381 p_app_short_name IN VARCHAR2,
382 p_header_rec IN OE_Order_PUB.Header_Rec_Type :=
384 p_old_header_rec IN OE_Order_PUB.Header_Rec_Type :=
385 OE_Order_PUB.G_MISS_HEADER_REC,
386 p_Header_Adj_tbl IN OE_Order_PUB.Header_Adj_Tbl_Type :=
387 OE_Order_PUB.G_MISS_HEADER_ADJ_TBL,
388 p_old_Header_Adj_tbl IN OE_Order_PUB.Header_Adj_Tbl_Type :=
389 OE_Order_PUB.G_MISS_HEADER_ADJ_TBL,
390 p_Header_price_Att_tbl IN OE_Order_PUB.Header_Price_Att_Tbl_Type :=
391 OE_Order_PUB.G_MISS_HEADER_PRICE_ATT_TBL,
392 p_old_Header_Price_Att_tbl IN OE_Order_PUB.Header_Price_Att_Tbl_Type :=
393 OE_Order_PUB.G_MISS_HEADER_PRICE_ATT_TBL,
394 p_Header_Adj_Att_tbl IN OE_Order_PUB.Header_Adj_Att_Tbl_Type :=
395 OE_Order_PUB.G_MISS_HEADER_ADJ_ATT_TBL,
396 p_old_Header_Adj_Att_tbl IN OE_Order_PUB.Header_Adj_Att_Tbl_Type :=
397 OE_Order_PUB.G_MISS_HEADER_ADJ_ATT_TBL,
398 p_Header_Adj_Assoc_tbl IN OE_Order_PUB.Header_Adj_Assoc_Tbl_Type :=
399 OE_Order_PUB.G_MISS_HEADER_ADJ_ASSOC_TBL,
400 p_old_Header_Adj_Assoc_tbl IN OE_Order_PUB.Header_Adj_Assoc_Tbl_Type :=
401 OE_Order_PUB.G_MISS_HEADER_ADJ_ASSOC_TBL,
402 p_Header_Scredit_tbl IN OE_Order_PUB.Header_Scredit_Tbl_Type :=
403 OE_Order_PUB.G_MISS_HEADER_SCREDIT_TBL,
404 p_old_Header_Scredit_tbl IN OE_Order_PUB.Header_Scredit_Tbl_Type :=
405 OE_Order_PUB.G_MISS_HEADER_SCREDIT_TBL,
406 p_line_tbl IN OE_Order_PUB.Line_Tbl_Type :=
407 OE_Order_PUB.G_MISS_LINE_TBL,
408 p_old_line_tbl IN OE_Order_PUB.Line_Tbl_Type :=
409 OE_Order_PUB.G_MISS_LINE_TBL,
410 p_Line_Adj_tbl IN OE_Order_PUB.Line_Adj_Tbl_Type :=
411 OE_Order_PUB.G_MISS_LINE_ADJ_TBL,
412 p_old_Line_Adj_tbl IN OE_Order_PUB.Line_Adj_Tbl_Type :=
413 OE_Order_PUB.G_MISS_LINE_ADJ_TBL,
414 p_Line_Price_Att_tbl IN OE_Order_PUB.Line_Price_Att_Tbl_Type :=
415 OE_Order_PUB.G_MISS_LINE_PRICE_ATT_TBL,
416 p_old_Line_Price_Att_tbl IN OE_Order_PUB.Line_Price_Att_Tbl_Type :=
417 OE_Order_PUB.G_MISS_LINE_PRICE_ATT_TBL,
418 p_Line_Adj_Att_tbl IN OE_Order_PUB.Line_Adj_Att_Tbl_Type :=
419 OE_Order_PUB.G_MISS_LINE_ADJ_ATT_TBL,
420 p_old_Line_Adj_Att_tbl IN OE_Order_PUB.Line_Adj_Att_Tbl_Type :=
421 OE_Order_PUB.G_MISS_LINE_ADJ_ATT_TBL,
422 p_Line_Adj_Assoc_tbl IN OE_Order_PUB.Line_Adj_Assoc_Tbl_Type :=
423 OE_Order_PUB.G_MISS_LINE_ADJ_ASSOC_TBL,
424 p_old_Line_Adj_Assoc_tbl IN OE_Order_PUB.Line_Adj_Assoc_Tbl_Type :=
425 OE_Order_PUB.G_MISS_LINE_ADJ_ASSOC_TBL,
426 p_Line_Scredit_tbl IN OE_Order_PUB.Line_Scredit_Tbl_Type :=
427 OE_Order_PUB.G_MISS_LINE_SCREDIT_TBL,
428 p_old_Line_Scredit_tbl IN OE_Order_PUB.Line_Scredit_Tbl_Type :=
429 OE_Order_PUB.G_MISS_LINE_SCREDIT_TBL,
430 p_Lot_Serial_tbl IN OE_Order_PUB.Lot_Serial_Tbl_Type :=
431 OE_Order_PUB.G_MISS_LOT_SERIAL_TBL,
432 p_old_Lot_Serial_tbl IN OE_Order_PUB.Lot_Serial_Tbl_Type :=
433 OE_Order_PUB.G_MISS_LOT_SERIAL_TBL,
434 p_action_request_tbl IN OE_Order_PUB.Request_Tbl_Type :=
435 OE_Order_PUB.G_MISS_REQUEST_TBL
436 );
437
438 --------------------------------------------------------------------------
439
440 -- Start of comments
441 -- API name : GET_EXCEPTION
442 -- Type : Public
443 -- Function : This API is the PUBLIC API that is invoked by CRM Apps
444 -- to get the data from the Order Feedback Exception Queue.
445 -- The messages from the Order Feedback Exception Queue may
446 -- be either retrieved in the browse mode or the remove mode.
447 -- Pre-reqs : Data must have been enqueued by using the HANDLE_EXCEPTION
448 -- PUBLIC API.
449 --
450 -- Standard IN Parameters:
451 -- p_api_version IN NUMBER Required
452 -- p_init_msg_list IN VARCHAR2 Optional
453 -- Default = FND_API.G_FALSE
454 -- p_commit IN VARCHAR2 Optional
455 -- Default = FND_API.G_FALSE
456 --
457 -- Standard OUT NOCOPY /* file.sql.39 change */ Parameters:
458 -- x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2(1)
459 -- x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
460 -- x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2(2000)
461 --
462 -- GET_EXCEPTION API specific IN Parameters:
463 -- p_app_short_name IN VARCHAR2 Required
464 -- p_wait IN NUMBER Optional
465 -- Default = DBMS_AQ.NO_WAIT
466 -- p_dequeue_mode IN VARCHAR2 Optional
467 -- Default = DBMS_AQ.REMOVE
468 -- p_navigation IN VARCHAR2 Optional
469 -- DEFAULT = DBMS_AQ.FIRST_MESSAGE,
470 --
471 -- GET_EXCEPTION API specific OUT NOCOPY /* file.sql.39 change */ Parameters:
472 --
476 -- x_Header_Adj_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Tbl_Type
473 -- x_no_more_messages OUT NOCOPY /* file.sql.39 change */ VARCHAR2
474 -- x_header_rec OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Rec_Type
475 -- x_old_header_rec OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Rec_Type
477 -- x_old_Header_Adj_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Tbl_Type
478 -- x_Header_price_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Price_Att_Tbl_Type
479 -- x_old_Header_Price_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Price_Att_Tbl_Type
480 -- x_Header_Adj_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Att_Tbl_Type
481 -- x_old_Header_Adj_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Att_Tbl_Type
482 -- x_Header_Adj_Assoc_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Assoc_Tbl_Type
483 -- x_old_Header_Adj_Assoc_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Assoc_Tbl_Type
484 -- x_Header_Scredit_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Scredit_Tbl_Type
485 -- x_old_Header_Scredit_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Scredit_Tbl_Type
486 -- x_line_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Tbl_Type
487 -- x_old_line_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Tbl_Type
488 -- x_Line_Adj_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Tbl_Type
489 -- x_old_Line_Adj_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Tbl_Type
490 -- x_Line_Price_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Price_Att_Tbl_Type
491 -- x_old_Line_Price_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Price_Att_Tbl_Type
492 -- x_Line_Adj_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Att_Tbl_Type
493 -- x_old_Line_Adj_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Att_Tbl_Type
494 -- x_Line_Adj_Assoc_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Assoc_Tbl_Type
495 -- x_old_Line_Adj_Assoc_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Assoc_Tbl_Type
496 -- x_Line_Scredit_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Scredit_Tbl_Type
497 -- x_old_Line_Scredit_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Scredit_Tbl_Type
498 -- x_Lot_Serial_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Lot_Serial_Tbl_Type
499 -- x_old_Lot_Serial_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Lot_Serial_Tbl_Type
500 -- x_action_request_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Request_Tbl_Type
501 --
502 --
503 -- Version : Current version 1.0
504 -- Initial version 1.0
505 --
506 -- End of comments
507 --------------------------------------------------------------------------
508
509 PROCEDURE GET_EXCEPTION
510 (
511 p_api_version IN NUMBER,
512 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
513 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
514 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
515 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
516 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
517 p_app_short_name IN VARCHAR2,
518 p_wait IN NUMBER DEFAULT DBMS_AQ.NO_WAIT,
519 p_dequeue_mode IN VARCHAR2 DEFAULT DBMS_AQ.REMOVE,
520 p_navigation IN VARCHAR2 DEFAULT DBMS_AQ.FIRST_MESSAGE,
521 x_no_more_messages OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
522 x_header_rec OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Rec_Type,
523 x_old_header_rec OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Rec_Type,
524 x_Header_Adj_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Tbl_Type,
525 x_old_Header_Adj_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Tbl_Type,
526 x_Header_price_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Price_Att_Tbl_Type,
527 x_old_Header_Price_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Price_Att_Tbl_Type,
528 x_Header_Adj_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Att_Tbl_Type,
529 x_old_Header_Adj_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Att_Tbl_Type,
530 x_Header_Adj_Assoc_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Assoc_Tbl_Type,
531 x_old_Header_Adj_Assoc_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Assoc_Tbl_Type,
532 x_Header_Scredit_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Scredit_Tbl_Type,
533 x_old_Header_Scredit_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Scredit_Tbl_Type,
534 x_line_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Tbl_Type,
535 x_old_line_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Tbl_Type,
536 x_Line_Adj_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Tbl_Type,
537 x_old_Line_Adj_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Tbl_Type,
538 x_Line_Price_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Price_Att_Tbl_Type,
539 x_old_Line_Price_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Price_Att_Tbl_Type,
540 x_Line_Adj_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Att_Tbl_Type,
541 x_old_Line_Adj_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Att_Tbl_Type,
545 x_old_Line_Scredit_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Scredit_Tbl_Type,
542 x_Line_Adj_Assoc_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Assoc_Tbl_Type,
543 x_old_Line_Adj_Assoc_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Assoc_Tbl_Type,
544 x_Line_Scredit_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Scredit_Tbl_Type,
546 x_Lot_Serial_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Lot_Serial_Tbl_Type,
547 x_old_Lot_Serial_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Lot_Serial_Tbl_Type,
548 x_action_request_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Request_Tbl_Type
549 );
550
551 END ASO_ORDER_FEEDBACK_PUB;