[Home] [Help]
PACKAGE: APPS.ASO_ORDER_FEEDBACK_PUB
Source
1 PACKAGE ASO_ORDER_FEEDBACK_PUB AS
2 /* $Header: asopomfs.pls 120.1 2005/06/29 12:37:13 appldev 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
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
213 -- x_old_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 x_no_more_messages OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
244 x_header_rec OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Rec_Type,
245 x_old_header_rec OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Rec_Type,
246 x_Header_Adj_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Tbl_Type,
247 x_old_Header_Adj_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Tbl_Type,
248 x_Header_price_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Price_Att_Tbl_Type,
249 x_old_Header_Price_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Price_Att_Tbl_Type,
250 x_Header_Adj_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Att_Tbl_Type,
251 x_old_Header_Adj_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Att_Tbl_Type,
252 x_Header_Adj_Assoc_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Assoc_Tbl_Type,
253 x_old_Header_Adj_Assoc_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Assoc_Tbl_Type,
254 x_Header_Scredit_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Scredit_Tbl_Type,
258 x_Line_Adj_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Tbl_Type,
255 x_old_Header_Scredit_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Scredit_Tbl_Type,
256 x_line_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Tbl_Type,
257 x_old_line_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Tbl_Type,
259 x_old_Line_Adj_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Tbl_Type,
260 x_Line_Price_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Price_Att_Tbl_Type,
261 x_old_Line_Price_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Price_Att_Tbl_Type,
262 x_Line_Adj_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Att_Tbl_Type,
263 x_old_Line_Adj_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Att_Tbl_Type,
264 x_Line_Adj_Assoc_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Assoc_Tbl_Type,
265 x_old_Line_Adj_Assoc_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Assoc_Tbl_Type,
266 x_Line_Scredit_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Scredit_Tbl_Type,
267 x_old_Line_Scredit_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Scredit_Tbl_Type,
268 x_Lot_Serial_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Lot_Serial_Tbl_Type,
269 x_old_Lot_Serial_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Lot_Serial_Tbl_Type,
270 x_action_request_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Request_Tbl_Type
271 );
272
273
274 --------------------------------------------------------------------------
275
276 -- Start of comments
277 -- API name : HANDLE_EXCEPTION
278 -- Type : Public
279 -- Function : This API is the PUBLIC API that is invoked by consumer apps
280 -- to enqueue a failed message in the Order Feedback Exception
281 -- Queue. Consumers may use the GET_EXCEPTION public API
282 -- to subsequently dequeue these failed message. If p_commit is
283 -- set to true the message is enqueued in an immediate mode and
284 -- is immediately available in for dequeueing by the
285 -- GET_EXCEPTION API, otherwise the message is available in
286 -- the exception queue only after the calling application commits.
287 -- Pre-reqs : None.
288 --
289 -- Standard IN Parameters:
290 -- p_api_version IN NUMBER Required
291 -- p_init_msg_list IN VARCHAR2 Optional
292 -- Default = FND_API.G_FALSE
293 -- p_commit IN VARCHAR2 Optional
294 -- Default = FND_API.G_FALSE
295 --
296 -- Standard OUT NOCOPY /* file.sql.39 change */ Parameters:
297 -- x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2(1)
298 -- x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
299 -- x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2(2000)
300 --
301 -- HANDLE_EXCEPTION API specific IN Parameters:
302
303 -- p_app_short_name IN VARCHAR2 Required
304 --
305 -- ALL PARAMETERS BELOW ARE OPTIONAL
306 --
307 -- p_header_rec IN OE_Order_PUB.Header_Rec_Type
308 -- Default = OE_Order_PUB.G_MISS_HEADER_REC
309 -- p_old_header_rec IN OE_Order_PUB.Header_Rec_Type
310 -- Default = OE_ORDER_PUB.G_MISS_HEADER_REC
311 -- p_Header_Adj_tbl IN OE_Order_PUB.Header_Adj_Tbl_Type
312 -- Default = OE_ORDER_PUB.G_MISS_HEADER_ADJ_TBL
313 -- p_old_Header_Adj_tbl IN OE_Order_PUB.Header_Adj_Tbl_Type
314 -- Default = OE_ORDER_PUB.G_MISS_HEADER_ADJ_TBL
315 -- p_Header_price_Att_tbl IN OE_Order_PUB.Header_Price_Att_Tbl_Type
316 -- Default = OE_ORDER_PUB.G_MISS_HEADER_PRICE_ATT_TBL
317 -- p_old_Header_Price_Att_tbl IN OE_Order_PUB.Header_Price_Att_Tbl_Type
318 -- Default = OE_ORDER_PUB.G_MISS_HEADER_PRICE_ATT_TBL
319 -- p_Header_Adj_Att_tbl IN OE_Order_PUB.Header_Adj_Att_Tbl_Type
320 -- Default = OE_ORDER_PUB.G_MISS_HEADER_ADJ_ATT_TBL
321 -- p_old_Header_Adj_Att_tbl IN OE_Order_PUB.Header_Adj_Att_Tbl_Type
322 -- Default = OE_ORDER_PUB.G_MISS_HEADER_ADJ_ATT_TBL
323 -- p_Header_Adj_Assoc_tbl IN OE_Order_PUB.Header_Adj_Assoc_Tbl_Type
324 -- Default = OE_ORDER_PUB.G_MISS_HEADER_ADJ_ASSOC_TBL
325 -- p_old_Header_Adj_Assoc_tbl IN OE_Order_PUB.Header_Adj_Assoc_Tbl_Type
326 -- Default = OE_ORDER_PUB.G_MISS_HEADER_ADJ_ASSOC_TBL
327 -- p_Header_Scredit_tbl IN OE_Order_PUB.Header_Scredit_Tbl_Type
328 -- Default = OE_ORDER_PUB.G_MISS_HEADER_SCREDIT_TBL
329 -- p_old_Header_Scredit_tbl IN OE_Order_PUB.Header_Scredit_Tbl_Type
330 -- Default = OE_ORDER_PUB.G_MISS_HEADER_SCREDIT_TBL
331 -- p_line_tbl IN OE_Order_PUB.Line_Tbl_Type
332 -- Default = OE_ORDER_PUB.G_MISS_LINE_TBL
333 -- p_old_line_tbl IN OE_Order_PUB.Line_Tbl_Type
334 -- Default = OE_ORDER_PUB.G_MISS_LINE_TBL
335 -- p_Line_Adj_tbl IN OE_Order_PUB.Line_Adj_Tbl_Type
336 -- Default = OE_ORDER_PUB.G_MISS_LINE_ADJ_TBL
340 -- Default = OE_ORDER_PUB.G_MISS_LINE_PRICE_ATT_TBL
337 -- p_old_Line_Adj_tbl IN OE_Order_PUB.Line_Adj_Tbl_Type
338 -- Default = OE_ORDER_PUB.G_MISS_LINE_ADJ_TBL
339 -- p_Line_Price_Att_tbl IN OE_Order_PUB.Line_Price_Att_Tbl_Type
341 -- p_old_Line_Price_Att_tbl IN OE_Order_PUB.Line_Price_Att_Tbl_Type
342 -- Default = OE_ORDER_PUB.G_MISS_LINE_PRICE_ATT_TBL
343 -- p_Line_Adj_Att_tbl IN OE_Order_PUB.Line_Adj_Att_Tbl_Type
344 -- Default = OE_ORDER_PUB.G_MISS_LINE_ADJ_ATT_TBL
345 -- p_old_Line_Adj_Att_tbl IN OE_Order_PUB.Line_Adj_Att_Tbl_Type
346 -- Default = OE_ORDER_PUB.G_MISS_LINE_ADJ_ATT_TBL
347 -- p_Line_Adj_Assoc_tbl IN OE_Order_PUB.Line_Adj_Assoc_Tbl_Type
348 -- Default = OE_ORDER_PUB.G_MISS_LINE_ADJ_ASSOC_TBL
349 -- p_old_Line_Adj_Assoc_tbl IN OE_Order_PUB.Line_Adj_Assoc_Tbl_Type
350 -- Default = OE_ORDER_PUB.G_MISS_LINE_ADJ_ASSOC_TBL
351 -- p_Line_Scredit_tbl IN OE_Order_PUB.Line_Scredit_Tbl_Type
352 -- Default = OE_ORDER_PUB.G_MISS_LINE_SCREDIT_TBL
353 -- p_old_Line_Scredit_tbl IN OE_Order_PUB.Line_Scredit_Tbl_Type
354 -- Default = OE_ORDER_PUB.G_MISS_LINE_SCREDIT_TBL
355 -- p_Lot_Serial_tbl IN OE_Order_PUB.Lot_Serial_Tbl_Type
356 -- Default = OE_ORDER_PUB.G_MISS_LOT_SERIAL_TBL
357 -- p_old_Lot_Serial_tbl IN OE_Order_PUB.Lot_Serial_Tbl_Type
358 -- Default = OE_ORDER_PUB.G_MISS_LOT_SERIAL_TBL
359 -- p_action_request_tbl IN OE_Order_PUB.Request_Tbl_Type
360 -- Default = OE_ORDER_PUB.G_MISS_REQUEST_TBL
361 --
362 --
363 -- HANDLE_EXCEPTION API specific OUT NOCOPY /* file.sql.39 change */ Parameters:
364 -- none
365 --
366 -- Version : Current version 1.0
367 -- Initial version 1.0
368 --
369 -- End of comments
370 --------------------------------------------------------------------------
371
372 PROCEDURE HANDLE_EXCEPTION
373 (
374 p_api_version IN NUMBER,
375 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
376 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
377 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
378 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
379 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
380 p_app_short_name IN VARCHAR2,
381 p_header_rec IN OE_Order_PUB.Header_Rec_Type :=
382 OE_Order_PUB.G_MISS_HEADER_REC,
383 p_old_header_rec IN OE_Order_PUB.Header_Rec_Type :=
384 OE_Order_PUB.G_MISS_HEADER_REC,
385 p_Header_Adj_tbl IN OE_Order_PUB.Header_Adj_Tbl_Type :=
386 OE_Order_PUB.G_MISS_HEADER_ADJ_TBL,
387 p_old_Header_Adj_tbl IN OE_Order_PUB.Header_Adj_Tbl_Type :=
388 OE_Order_PUB.G_MISS_HEADER_ADJ_TBL,
389 p_Header_price_Att_tbl IN OE_Order_PUB.Header_Price_Att_Tbl_Type :=
390 OE_Order_PUB.G_MISS_HEADER_PRICE_ATT_TBL,
391 p_old_Header_Price_Att_tbl IN OE_Order_PUB.Header_Price_Att_Tbl_Type :=
392 OE_Order_PUB.G_MISS_HEADER_PRICE_ATT_TBL,
393 p_Header_Adj_Att_tbl IN OE_Order_PUB.Header_Adj_Att_Tbl_Type :=
394 OE_Order_PUB.G_MISS_HEADER_ADJ_ATT_TBL,
395 p_old_Header_Adj_Att_tbl IN OE_Order_PUB.Header_Adj_Att_Tbl_Type :=
396 OE_Order_PUB.G_MISS_HEADER_ADJ_ATT_TBL,
397 p_Header_Adj_Assoc_tbl IN OE_Order_PUB.Header_Adj_Assoc_Tbl_Type :=
398 OE_Order_PUB.G_MISS_HEADER_ADJ_ASSOC_TBL,
399 p_old_Header_Adj_Assoc_tbl IN OE_Order_PUB.Header_Adj_Assoc_Tbl_Type :=
400 OE_Order_PUB.G_MISS_HEADER_ADJ_ASSOC_TBL,
401 p_Header_Scredit_tbl IN OE_Order_PUB.Header_Scredit_Tbl_Type :=
402 OE_Order_PUB.G_MISS_HEADER_SCREDIT_TBL,
403 p_old_Header_Scredit_tbl IN OE_Order_PUB.Header_Scredit_Tbl_Type :=
404 OE_Order_PUB.G_MISS_HEADER_SCREDIT_TBL,
405 p_line_tbl IN OE_Order_PUB.Line_Tbl_Type :=
406 OE_Order_PUB.G_MISS_LINE_TBL,
407 p_old_line_tbl IN OE_Order_PUB.Line_Tbl_Type :=
408 OE_Order_PUB.G_MISS_LINE_TBL,
409 p_Line_Adj_tbl IN OE_Order_PUB.Line_Adj_Tbl_Type :=
410 OE_Order_PUB.G_MISS_LINE_ADJ_TBL,
411 p_old_Line_Adj_tbl IN OE_Order_PUB.Line_Adj_Tbl_Type :=
412 OE_Order_PUB.G_MISS_LINE_ADJ_TBL,
413 p_Line_Price_Att_tbl IN OE_Order_PUB.Line_Price_Att_Tbl_Type :=
414 OE_Order_PUB.G_MISS_LINE_PRICE_ATT_TBL,
415 p_old_Line_Price_Att_tbl IN OE_Order_PUB.Line_Price_Att_Tbl_Type :=
416 OE_Order_PUB.G_MISS_LINE_PRICE_ATT_TBL,
417 p_Line_Adj_Att_tbl IN OE_Order_PUB.Line_Adj_Att_Tbl_Type :=
418 OE_Order_PUB.G_MISS_LINE_ADJ_ATT_TBL,
419 p_old_Line_Adj_Att_tbl IN OE_Order_PUB.Line_Adj_Att_Tbl_Type :=
423 p_old_Line_Adj_Assoc_tbl IN OE_Order_PUB.Line_Adj_Assoc_Tbl_Type :=
420 OE_Order_PUB.G_MISS_LINE_ADJ_ATT_TBL,
421 p_Line_Adj_Assoc_tbl IN OE_Order_PUB.Line_Adj_Assoc_Tbl_Type :=
422 OE_Order_PUB.G_MISS_LINE_ADJ_ASSOC_TBL,
424 OE_Order_PUB.G_MISS_LINE_ADJ_ASSOC_TBL,
425 p_Line_Scredit_tbl IN OE_Order_PUB.Line_Scredit_Tbl_Type :=
426 OE_Order_PUB.G_MISS_LINE_SCREDIT_TBL,
427 p_old_Line_Scredit_tbl IN OE_Order_PUB.Line_Scredit_Tbl_Type :=
428 OE_Order_PUB.G_MISS_LINE_SCREDIT_TBL,
429 p_Lot_Serial_tbl IN OE_Order_PUB.Lot_Serial_Tbl_Type :=
430 OE_Order_PUB.G_MISS_LOT_SERIAL_TBL,
431 p_old_Lot_Serial_tbl IN OE_Order_PUB.Lot_Serial_Tbl_Type :=
432 OE_Order_PUB.G_MISS_LOT_SERIAL_TBL,
433 p_action_request_tbl IN OE_Order_PUB.Request_Tbl_Type :=
434 OE_Order_PUB.G_MISS_REQUEST_TBL
435 );
436
437 --------------------------------------------------------------------------
438
439 -- Start of comments
440 -- API name : GET_EXCEPTION
441 -- Type : Public
442 -- Function : This API is the PUBLIC API that is invoked by CRM Apps
443 -- to get the data from the Order Feedback Exception Queue.
444 -- The messages from the Order Feedback Exception Queue may
445 -- be either retrieved in the browse mode or the remove mode.
446 -- Pre-reqs : Data must have been enqueued by using the HANDLE_EXCEPTION
447 -- PUBLIC API.
448 --
449 -- Standard IN Parameters:
450 -- p_api_version IN NUMBER Required
451 -- p_init_msg_list IN VARCHAR2 Optional
452 -- Default = FND_API.G_FALSE
453 -- p_commit IN VARCHAR2 Optional
454 -- Default = FND_API.G_FALSE
455 --
456 -- Standard OUT NOCOPY /* file.sql.39 change */ Parameters:
457 -- x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2(1)
458 -- x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
459 -- x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2(2000)
460 --
461 -- GET_EXCEPTION API specific IN Parameters:
462 -- p_app_short_name IN VARCHAR2 Required
463 -- p_wait IN NUMBER Optional
464 -- Default = DBMS_AQ.NO_WAIT
465 -- p_dequeue_mode IN VARCHAR2 Optional
466 -- Default = DBMS_AQ.REMOVE
467 -- p_navigation IN VARCHAR2 Optional
468 -- DEFAULT = DBMS_AQ.FIRST_MESSAGE,
469 --
470 -- GET_EXCEPTION API specific OUT NOCOPY /* file.sql.39 change */ Parameters:
471 --
472 -- x_no_more_messages OUT NOCOPY /* file.sql.39 change */ VARCHAR2
473 -- x_header_rec OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Rec_Type
474 -- x_old_header_rec OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Rec_Type
475 -- x_Header_Adj_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Tbl_Type
476 -- x_old_Header_Adj_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Tbl_Type
477 -- x_Header_price_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Price_Att_Tbl_Type
478 -- x_old_Header_Price_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Price_Att_Tbl_Type
479 -- x_Header_Adj_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Att_Tbl_Type
480 -- x_old_Header_Adj_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Att_Tbl_Type
481 -- x_Header_Adj_Assoc_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Assoc_Tbl_Type
482 -- x_old_Header_Adj_Assoc_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Assoc_Tbl_Type
483 -- x_Header_Scredit_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Scredit_Tbl_Type
484 -- x_old_Header_Scredit_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Scredit_Tbl_Type
485 -- x_line_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Tbl_Type
486 -- x_old_line_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Tbl_Type
487 -- x_Line_Adj_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Tbl_Type
488 -- x_old_Line_Adj_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Tbl_Type
489 -- x_Line_Price_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Price_Att_Tbl_Type
490 -- x_old_Line_Price_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Price_Att_Tbl_Type
491 -- x_Line_Adj_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Att_Tbl_Type
492 -- x_old_Line_Adj_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Att_Tbl_Type
493 -- x_Line_Adj_Assoc_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Assoc_Tbl_Type
494 -- x_old_Line_Adj_Assoc_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Assoc_Tbl_Type
495 -- x_Line_Scredit_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Scredit_Tbl_Type
496 -- x_old_Line_Scredit_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Scredit_Tbl_Type
497 -- x_Lot_Serial_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Lot_Serial_Tbl_Type
498 -- x_old_Lot_Serial_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Lot_Serial_Tbl_Type
499 -- x_action_request_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Request_Tbl_Type
500 --
501 --
502 -- Version : Current version 1.0
503 -- Initial version 1.0
504 --
505 -- End of comments
506 --------------------------------------------------------------------------
507
508 PROCEDURE GET_EXCEPTION
509 (
510 p_api_version IN NUMBER,
511 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
512 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
513 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
514 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
515 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
516 p_app_short_name IN VARCHAR2,
517 p_wait IN NUMBER DEFAULT DBMS_AQ.NO_WAIT,
518 p_dequeue_mode IN VARCHAR2 DEFAULT DBMS_AQ.REMOVE,
519 p_navigation IN VARCHAR2 DEFAULT DBMS_AQ.FIRST_MESSAGE,
520 x_no_more_messages OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
521 x_header_rec OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Rec_Type,
522 x_old_header_rec OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Rec_Type,
523 x_Header_Adj_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Tbl_Type,
524 x_old_Header_Adj_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Tbl_Type,
525 x_Header_price_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Price_Att_Tbl_Type,
526 x_old_Header_Price_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Price_Att_Tbl_Type,
527 x_Header_Adj_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Att_Tbl_Type,
528 x_old_Header_Adj_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Att_Tbl_Type,
529 x_Header_Adj_Assoc_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Assoc_Tbl_Type,
530 x_old_Header_Adj_Assoc_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Assoc_Tbl_Type,
531 x_Header_Scredit_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Scredit_Tbl_Type,
532 x_old_Header_Scredit_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Scredit_Tbl_Type,
533 x_line_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Tbl_Type,
537 x_Line_Price_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Price_Att_Tbl_Type,
534 x_old_line_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Tbl_Type,
535 x_Line_Adj_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Tbl_Type,
536 x_old_Line_Adj_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Tbl_Type,
538 x_old_Line_Price_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Price_Att_Tbl_Type,
539 x_Line_Adj_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Att_Tbl_Type,
540 x_old_Line_Adj_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Att_Tbl_Type,
541 x_Line_Adj_Assoc_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Assoc_Tbl_Type,
542 x_old_Line_Adj_Assoc_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Assoc_Tbl_Type,
543 x_Line_Scredit_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Scredit_Tbl_Type,
544 x_old_Line_Scredit_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Scredit_Tbl_Type,
545 x_Lot_Serial_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Lot_Serial_Tbl_Type,
546 x_old_Lot_Serial_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Lot_Serial_Tbl_Type,
547 x_action_request_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Request_Tbl_Type
548 );
549
550 END ASO_ORDER_FEEDBACK_PUB;