[Home] [Help]
PACKAGE: APPS.ASO_ORDER_FEEDBACK_UPDATE_PVT
Source
1 PACKAGE ASO_ORDER_FEEDBACK_UPDATE_PVT AS
2 /* $Header: asovomus.pls 120.1 2005/06/29 12:42:41 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 PRIVATE 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 specific IN Parameters:
35 --
36 -- p_header_rec IN OE_Order_PUB.Header_Rec_Type OPTIONAL
37 -- Default := OE_Order_PUB.G_MISS_HEADER_REC
38 -- p_old_header_rec IN OE_Order_PUB.Header_Rec_Type
39 -- Default := OE_ORDER_PUB.G_MISS_HEADER_REC
40 -- p_Header_Adj_tbl IN OE_Order_PUB.Header_Adj_Tbl_Type
41 -- Default := OE_ORDER_PUB.G_MISS_HEADER_ADJ_TBL
42 -- p_old_Header_Adj_tbl IN OE_Order_PUB.Header_Adj_Tbl_Type
43 -- Default := OE_ORDER_PUB.G_MISS_HEADER_ADJ_TBL
44 -- p_Header_price_Att_tbl IN OE_Order_PUB.Header_Price_Att_Tbl_Type
45 -- Default := OE_ORDER_PUB.G_MISS_HEADER_PRICE_ATT_TBL
46 -- p_old_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_Header_Adj_Att_tbl IN OE_Order_PUB.Header_Adj_Att_Tbl_Type
49 -- Default := OE_ORDER_PUB.G_MISS_HEADER_ADJ_ATT_TBL
50 -- p_old_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_Header_Adj_Assoc_tbl IN OE_Order_PUB.Header_Adj_Assoc_Tbl_Type
53 -- Default := OE_ORDER_PUB.G_MISS_HEADER_ADJ_ASSOC_TBL
54 -- p_old_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_Header_Scredit_tbl IN OE_Order_PUB.Header_Scredit_Tbl_Type
57 -- Default := OE_ORDER_PUB.G_MISS_HEADER_SCREDIT_TBL
58 -- p_old_Header_Scredit_tbl IN OE_Order_PUB.Header_Scredit_Tbl_Type
59 -- Default := OE_ORDER_PUB.G_MISS_HEADER_SCREDIT_TBL
60 -- p_line_tbl IN OE_Order_PUB.Line_Tbl_Type
61 -- Default := OE_ORDER_PUB.G_MISS_LINE_TBL
62 -- p_old_line_tbl IN OE_Order_PUB.Line_Tbl_Type
63 -- Default := OE_ORDER_PUB.G_MISS_LINE_TBL
64 -- p_Line_Adj_tbl IN OE_Order_PUB.Line_Adj_Tbl_Type
65 -- Default := OE_ORDER_PUB.G_MISS_LINE_ADJ_TBL
66 -- p_old_Line_Adj_tbl IN OE_Order_PUB.Line_Adj_Tbl_Type
67 -- Default := OE_ORDER_PUB.G_MISS_LINE_ADJ_TBL
68 -- p_Line_price_Att_tbl IN OE_Order_PUB.Line_Price_Att_Tbl_Type
69 -- Default := OE_ORDER_PUB.G_MISS_LINE_PRICE_ATT_TBL
70 -- p_old_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_Line_Adj_Att_tbl IN OE_Order_PUB.Line_Adj_Att_Tbl_Type
73 -- Default := OE_ORDER_PUB.G_MISS_LINE_ADJ_ATT_TBL
74 -- p_old_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_Line_Adj_Assoc_tbl IN OE_Order_PUB.Line_Adj_Assoc_Tbl_Type
77 -- Default := OE_ORDER_PUB.G_MISS_LINE_ADJ_ASSOC_TBL
78 -- p_old_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_Line_Scredit_tbl IN OE_Order_PUB.Line_Scredit_Tbl_Type
81 -- Default := OE_ORDER_PUB.G_MISS_LINE_SCREDIT_TBL
82 -- p_old_Line_Scredit_tbl IN OE_Order_PUB.Line_Scredit_Tbl_Type
83 -- Default := OE_ORDER_PUB.G_MISS_LINE_SCREDIT_TBL
84 -- p_Lot_Serial_tbl IN OE_Order_PUB.Lot_Serial_Tbl_Type
85 -- Default := OE_ORDER_PUB.G_MISS_LOT_SERIAL_TBL
86 -- p_old_Lot_Serial_tbl IN OE_Order_PUB.Lot_Serial_Tbl_Type
87 -- Default := OE_ORDER_PUB.G_MISS_LOT_SERIAL_TBL
88 -- p_action_request_tbl IN OE_Order_PUB.Request_Tbl_Type
89 -- Default := OE_ORDER_PUB.G_MISS_REQUEST_TBL
90 --
91 -- p_app_short_name IN VARCHAR2(30) := NULL ,
92 -- p_queue_type IN VARCHAR2(30) := 'ASO_OF_Q'
93 --
94 -- UPDATE_NOTICE 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 p_app_short_name IN VARCHAR2 := NULL ,
166 p_queue_type IN VARCHAR2 := 'OF_QUEUE'
167 );
168
169 PROCEDURE ASO_Header_Rec_To_Type
170 (
171 p_header_rec IN OE_Order_PUB.Header_Rec_Type ,
172 x_header_type OUT NOCOPY /* file.sql.39 change */ SYSTEM.ASO_Header_Type
173 );
174
175 PROCEDURE ASO_Header_Adj_Tbl_To_Var
176 (
177 p_header_adj_tbl_type IN OE_Order_PUB.Header_Adj_Tbl_Type,
178 x_header_adj_var_type OUT NOCOPY /* file.sql.39 change */ SYSTEM.ASO_Header_Adj_Var_Type
179 );
180
181 PROCEDURE ASO_Header_Adj_Assoc_Tbl_T_Var
182 (
183 p_header_adj_assoc_tbl_type IN OE_Order_PUB.Header_Adj_Assoc_Tbl_Type,
184 x_header_adj_assoc_var_type OUT NOCOPY /* file.sql.39 change */ SYSTEM.ASO_Header_Adj_Assoc_Var_Type
185 );
186
187 PROCEDURE ASO_Header_Adj_Att_Tbl_To_Var
188 (
189 p_header_adj_att_tbl_type IN OE_Order_PUB.Header_Adj_Att_Tbl_Type,
190 x_header_adj_att_var_type OUT NOCOPY /* file.sql.39 change */ SYSTEM.ASO_Header_Adj_Att_Var_Type
191 );
192
193 PROCEDURE ASO_Header_Price_Tbl_To_Var
194 (
195 p_header_price_att_tbl_type IN OE_Order_PUB.Header_Price_Att_Tbl_Type,
196 x_header_price_att_var_type OUT NOCOPY /* file.sql.39 change */ SYSTEM.ASO_Header_Price_Att_Var_Type
197 );
198
199 PROCEDURE ASO_Header_Scredit_Tbl_To_Var
200 (
201 p_header_scredit_tbl_type IN OE_Order_PUB.Header_Scredit_Tbl_Type,
202 x_header_scredit_var_type OUT NOCOPY /* file.sql.39 change */ SYSTEM.ASO_Header_Scredit_Var_Type
203 );
204
205 PROCEDURE ASO_Line_Tbl_To_Var
206 (
207 p_line_tbl_type IN OE_Order_PUB.Line_Tbl_Type,
208 x_line_var_type OUT NOCOPY /* file.sql.39 change */ SYSTEM.ASO_Line_Var_Type
209 );
210
211 PROCEDURE ASO_Line_Adj_Tbl_To_Var
212 (
213 p_line_adj_tbl_type IN OE_Order_PUB.Line_Adj_Tbl_Type,
214 x_line_adj_var_type OUT NOCOPY /* file.sql.39 change */ SYSTEM.ASO_Line_Adj_Var_Type
215 );
216
217 PROCEDURE ASO_Line_Adj_Assoc_Tbl_To_Var
218 (
219 p_line_adj_assoc_tbl_type IN OE_Order_PUB.Line_Adj_Assoc_Tbl_Type,
220 x_line_adj_assoc_var_type OUT NOCOPY /* file.sql.39 change */ SYSTEM.ASO_Line_Adj_Assoc_Var_Type
221 );
222
223 PROCEDURE ASO_Line_Adj_Att_Tbl_To_Var
224 (
225 p_line_adj_att_tbl_type IN OE_Order_PUB.Line_Adj_Att_Tbl_Type,
226 x_line_adj_att_var_type OUT NOCOPY /* file.sql.39 change */ SYSTEM.ASO_Line_Adj_Att_Var_Type
227 );
228
229 PROCEDURE ASO_Line_Price_Att_Tbl_To_Var
230 (
231 p_line_price_att_tbl_type IN OE_Order_PUB.Line_Price_Att_Tbl_Type,
232 x_line_price_att_var_type OUT NOCOPY /* file.sql.39 change */ SYSTEM.ASO_Line_Price_Att_Var_Type
233 );
234
235 PROCEDURE ASO_Line_Scredit_Tbl_To_Var
236 (
237 p_line_scredit_tbl_type IN OE_Order_PUB.Line_Scredit_Tbl_Type,
238 x_line_scredit_var_type OUT NOCOPY /* file.sql.39 change */ SYSTEM.ASO_Line_Scredit_Var_Type
239 );
240
241 PROCEDURE ASO_Lot_Serial_Tbl_To_Var
242 (
243 p_lot_serial_tbl_type IN OE_Order_PUB.Lot_Serial_Tbl_Type,
244 x_lot_serial_var_type OUT NOCOPY /* file.sql.39 change */ SYSTEM.ASO_Lot_Serial_Var_Type
245 );
246
247 PROCEDURE ASO_Request_Tbl_To_Var
248 (
249 p_request_tbl_type IN OE_Order_PUB.Request_Tbl_Type,
250 x_request_var_type OUT NOCOPY /* file.sql.39 change */ SYSTEM.ASO_Request_Var_Type
251 );
252
253 PROCEDURE ASO_Order_Feedback_ENQ
254 (
255 p_aso_order_feedback_type IN SYSTEM.ASO_ORDER_FEEDBACK_TYPE,
256 p_queue_type IN VARCHAR2,
257 p_commit IN VARCHAR2,
258 p_app_short_name IN VARCHAR2
259 );
260
261 PROCEDURE ASO_CRM_Recipients
262 (
263 p_recipient_list OUT NOCOPY /* file.sql.39 change */ DBMS_AQ.aq$_recipient_list_t
264 );
265
266 END ASO_ORDER_FEEDBACK_UPDATE_PVT;