[Home] [Help]
PACKAGE: APPS.OE_ORDER_GRP
Source
1 PACKAGE OE_Order_GRP AUTHID CURRENT_USER AS
2 /* $Header: OEXGORDS.pls 120.4.12020000.1 2012/06/26 08:41:17 appldev ship $ */
3
4
5 -- Start of Comments
6 -- API name Process_Order
7 -- Type Group
8 -- Function Over Loaded
9 --
10 -- Pre-reqs
11 --
12 -- Parameters
13 --
14 -- Version Current version = 1.0
15 -- Initial version = 1.0
16 --
17 -- Notes
18 --
19 -- End of Comments
20
21 PROCEDURE Process_Order
22 ( p_api_version_number IN NUMBER
23 , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
24 , p_return_values IN VARCHAR2 := FND_API.G_FALSE
25 , p_commit IN VARCHAR2 := FND_API.G_FALSE
26 , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
27 , p_control_rec IN OE_GLOBALS.Control_Rec_Type :=
28 OE_GLOBALS.G_MISS_CONTROL_REC
29 , p_api_service_level IN VARCHAR2 := OE_GLOBALS.G_ALL_SERVICE
30 , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
31 , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
32 , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
33 , p_header_rec IN OE_Order_Pub.Header_Rec_Type :=
34 OE_Order_PUB.G_MISS_HEADER_REC
35 , p_old_header_rec IN OE_Order_PUB.Header_Rec_Type :=
36 OE_Order_PUB.G_MISS_HEADER_REC
37 , p_header_val_rec IN OE_Order_PUB.Header_Val_Rec_Type :=
38 OE_Order_PUB.G_MISS_HEADER_VAL_REC
39 , p_old_header_val_rec IN OE_Order_PUB.Header_Val_Rec_Type :=
40 OE_Order_PUB.G_MISS_HEADER_VAL_REC
41 , p_Header_Adj_tbl IN OE_Order_PUB.Header_Adj_Tbl_Type :=
42 OE_Order_PUB.G_MISS_HEADER_ADJ_TBL
43 , p_old_Header_Adj_tbl IN OE_Order_PUB.Header_Adj_Tbl_Type :=
44 OE_Order_PUB.G_MISS_HEADER_ADJ_TBL
45 , p_Header_Adj_val_tbl IN OE_Order_PUB.Header_Adj_Val_Tbl_Type :=
46 OE_Order_PUB.G_MISS_HEADER_ADJ_VAL_TBL
47 , p_old_Header_Adj_val_tbl IN OE_Order_PUB.Header_Adj_Val_Tbl_Type :=
48 OE_Order_PUB.G_MISS_HEADER_ADJ_VAL_TBL
49 , p_Header_price_Att_tbl IN OE_Order_PUB.Header_Price_Att_Tbl_Type :=
50 OE_Order_PUB.G_MISS_HEADER_PRICE_ATT_TBL
51 , p_old_Header_Price_Att_tbl IN OE_Order_PUB.Header_Price_Att_Tbl_Type :=
52 OE_Order_PUB.G_MISS_HEADER_PRICE_ATT_TBL
53 , p_Header_Adj_Att_tbl IN OE_Order_PUB.Header_Adj_Att_Tbl_Type :=
54 OE_Order_PUB.G_MISS_HEADER_ADJ_ATT_TBL
55 , p_old_Header_Adj_Att_tbl IN OE_Order_PUB.Header_Adj_Att_Tbl_Type :=
56 OE_Order_PUB.G_MISS_HEADER_ADJ_ATT_TBL
57 , p_Header_Adj_Assoc_tbl IN OE_Order_PUB.Header_Adj_Assoc_Tbl_Type :=
58 OE_Order_PUB.G_MISS_HEADER_ADJ_ASSOC_TBL
59 , p_old_Header_Adj_Assoc_tbl IN OE_Order_PUB.Header_Adj_Assoc_Tbl_Type :=
60 OE_Order_PUB.G_MISS_HEADER_ADJ_ASSOC_TBL
61 , p_Header_Scredit_tbl IN OE_Order_PUB.Header_Scredit_Tbl_Type :=
62 OE_Order_PUB.G_MISS_HEADER_SCREDIT_TBL
63 , p_old_Header_Scredit_tbl IN OE_Order_PUB.Header_Scredit_Tbl_Type :=
64 OE_Order_PUB.G_MISS_HEADER_SCREDIT_TBL
65 , p_Header_Scredit_val_tbl IN OE_Order_PUB.Header_Scredit_Val_Tbl_Type :=
66 OE_Order_PUB.G_MISS_HEADER_SCREDIT_VAL_TBL
67 , p_old_Header_Scredit_val_tbl IN OE_Order_PUB.Header_Scredit_Val_Tbl_Type :=
68 OE_Order_PUB.G_MISS_HEADER_SCREDIT_VAL_TBL
69 , p_line_tbl IN OE_Order_PUB.Line_Tbl_Type :=
70 OE_Order_PUB.G_MISS_LINE_TBL
71 , p_old_line_tbl IN OE_Order_PUB.Line_Tbl_Type :=
72 OE_Order_PUB.G_MISS_LINE_TBL
73 , p_line_val_tbl IN OE_Order_PUB.Line_Val_Tbl_Type :=
74 OE_Order_PUB.G_MISS_LINE_VAL_TBL
75 , p_old_line_val_tbl IN OE_Order_PUB.Line_Val_Tbl_Type :=
76 OE_Order_PUB.G_MISS_LINE_VAL_TBL
77 , p_Line_Adj_tbl IN OE_Order_PUB.Line_Adj_Tbl_Type :=
78 OE_Order_PUB.G_MISS_LINE_ADJ_TBL
79 , p_old_Line_Adj_tbl IN OE_Order_PUB.Line_Adj_Tbl_Type :=
80 OE_Order_PUB.G_MISS_LINE_ADJ_TBL
81 , p_Line_Adj_val_tbl IN OE_Order_PUB.Line_Adj_Val_Tbl_Type :=
82 OE_Order_PUB.G_MISS_LINE_ADJ_VAL_TBL
83 , p_old_Line_Adj_val_tbl IN OE_Order_PUB.Line_Adj_Val_Tbl_Type :=
84 OE_Order_PUB.G_MISS_LINE_ADJ_VAL_TBL
85 , p_Line_price_Att_tbl IN OE_Order_PUB.Line_Price_Att_Tbl_Type :=
86 OE_Order_PUB.G_MISS_LINE_PRICE_ATT_TBL
87 , p_old_Line_Price_Att_tbl IN OE_Order_PUB.Line_Price_Att_Tbl_Type :=
88 OE_Order_PUB.G_MISS_LINE_PRICE_ATT_TBL
89 , p_Line_Adj_Att_tbl IN OE_Order_PUB.Line_Adj_Att_Tbl_Type :=
90 OE_Order_PUB.G_MISS_LINE_ADJ_ATT_TBL
91 , p_old_Line_Adj_Att_tbl IN OE_Order_PUB.Line_Adj_Att_Tbl_Type :=
92 OE_Order_PUB.G_MISS_LINE_ADJ_ATT_TBL
93 , p_Line_Adj_Assoc_tbl IN OE_Order_PUB.Line_Adj_Assoc_Tbl_Type :=
94 OE_Order_PUB.G_MISS_LINE_ADJ_ASSOC_TBL
95 , p_old_Line_Adj_Assoc_tbl IN OE_Order_PUB.Line_Adj_Assoc_Tbl_Type :=
96 OE_Order_PUB.G_MISS_LINE_ADJ_ASSOC_TBL
97 , p_Line_Scredit_tbl IN OE_Order_PUB.Line_Scredit_Tbl_Type :=
98 OE_Order_PUB.G_MISS_LINE_SCREDIT_TBL
99 , p_old_Line_Scredit_tbl IN OE_Order_PUB.Line_Scredit_Tbl_Type :=
100 OE_Order_PUB.G_MISS_LINE_SCREDIT_TBL
101 , p_Line_Scredit_val_tbl IN OE_Order_PUB.Line_Scredit_Val_Tbl_Type :=
102 OE_Order_PUB.G_MISS_LINE_SCREDIT_VAL_TBL
103 , p_old_Line_Scredit_val_tbl IN OE_Order_PUB.Line_Scredit_Val_Tbl_Type :=
104 OE_Order_PUB.G_MISS_LINE_SCREDIT_VAL_TBL
105 , p_Lot_Serial_tbl IN OE_Order_PUB.Lot_Serial_Tbl_Type :=
106 OE_Order_PUB.G_MISS_LOT_SERIAL_TBL
107 , p_old_Lot_Serial_tbl IN OE_Order_PUB.Lot_Serial_Tbl_Type :=
108 OE_Order_PUB.G_MISS_LOT_SERIAL_TBL
109 , p_Lot_Serial_val_tbl IN OE_Order_PUB.Lot_Serial_Val_Tbl_Type :=
110 OE_Order_PUB.G_MISS_LOT_SERIAL_VAL_TBL
111 , p_old_Lot_Serial_val_tbl IN OE_Order_PUB.Lot_Serial_Val_Tbl_Type :=
112 OE_Order_PUB.G_MISS_LOT_SERIAL_VAL_TBL
113 , p_action_request_tbl IN OE_Order_PUB.Request_Tbl_Type :=
114 OE_Order_PUB.G_MISS_REQUEST_TBL
115 , x_header_rec OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Rec_Type
116 , x_header_val_rec OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Val_Rec_Type
117 , x_Header_Adj_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Tbl_Type
118 , x_Header_Adj_val_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Val_Tbl_Type
119 , x_Header_price_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Price_Att_Tbl_Type
120 , x_Header_Adj_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Att_Tbl_Type
121 , x_Header_Adj_Assoc_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Assoc_Tbl_Type
122 , x_Header_Scredit_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Scredit_Tbl_Type
123 , x_Header_Scredit_val_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Scredit_Val_Tbl_Type
124 , x_line_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Tbl_Type
125 , x_line_val_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Val_Tbl_Type
126 , x_Line_Adj_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Tbl_Type
127 , x_Line_Adj_val_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Val_Tbl_Type
128 , x_Line_price_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Price_Att_Tbl_Type
129 , x_Line_Adj_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Att_Tbl_Type
130 , x_Line_Adj_Assoc_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Assoc_Tbl_Type
131 , x_Line_Scredit_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Scredit_Tbl_Type
132 , x_Line_Scredit_val_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Scredit_Val_Tbl_Type
133 , x_Lot_Serial_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Lot_Serial_Tbl_Type
134 , x_Lot_Serial_val_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Lot_Serial_Val_Tbl_Type
135 , x_action_request_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Request_Tbl_Type
136 --For bug 3390458
137 , p_rtrim_data IN Varchar2 :='N'
138 , p_validate_desc_flex in varchar2 default 'Y' -- bug4343612
139
140 --ER7675548
141 , p_header_customer_info_tbl IN OE_ORDER_PUB.CUSTOMER_INFO_TABLE_TYPE :=
142 OE_ORDER_PUB.G_MISS_CUSTOMER_INFO_TBL
143 , p_line_customer_info_tbl IN OE_ORDER_PUB.CUSTOMER_INFO_TABLE_TYPE :=
144 OE_ORDER_PUB.G_MISS_CUSTOMER_INFO_TBL
145 );
146
147 -- Process_order overloaded with payments parameters
148 PROCEDURE Process_Order
149 ( p_api_version_number IN NUMBER
150 , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
151 , p_return_values IN VARCHAR2 := FND_API.G_FALSE
152 , p_commit IN VARCHAR2 := FND_API.G_FALSE
153 , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
154 , p_control_rec IN OE_GLOBALS.Control_Rec_Type :=
155 OE_GLOBALS.G_MISS_CONTROL_REC
156 , p_api_service_level IN VARCHAR2 := OE_GLOBALS.G_ALL_SERVICE
157 , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
158 , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
159 , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
160 , p_header_rec IN OE_Order_Pub.Header_Rec_Type :=
161 OE_Order_PUB.G_MISS_HEADER_REC
162 , p_old_header_rec IN OE_Order_PUB.Header_Rec_Type :=
163 OE_Order_PUB.G_MISS_HEADER_REC
164 , p_header_val_rec IN OE_Order_PUB.Header_Val_Rec_Type :=
165 OE_Order_PUB.G_MISS_HEADER_VAL_REC
166 , p_old_header_val_rec IN OE_Order_PUB.Header_Val_Rec_Type :=
167 OE_Order_PUB.G_MISS_HEADER_VAL_REC
168 , p_Header_Adj_tbl IN OE_Order_PUB.Header_Adj_Tbl_Type :=
169 OE_Order_PUB.G_MISS_HEADER_ADJ_TBL
170 , p_old_Header_Adj_tbl IN OE_Order_PUB.Header_Adj_Tbl_Type :=
171 OE_Order_PUB.G_MISS_HEADER_ADJ_TBL
172 , p_Header_Adj_val_tbl IN OE_Order_PUB.Header_Adj_Val_Tbl_Type :=
173 OE_Order_PUB.G_MISS_HEADER_ADJ_VAL_TBL
174 , p_old_Header_Adj_val_tbl IN OE_Order_PUB.Header_Adj_Val_Tbl_Type :=
175 OE_Order_PUB.G_MISS_HEADER_ADJ_VAL_TBL
176 , p_Header_price_Att_tbl IN OE_Order_PUB.Header_Price_Att_Tbl_Type :=
177 OE_Order_PUB.G_MISS_HEADER_PRICE_ATT_TBL
178 , p_old_Header_Price_Att_tbl IN OE_Order_PUB.Header_Price_Att_Tbl_Type :=
179 OE_Order_PUB.G_MISS_HEADER_PRICE_ATT_TBL
180 , p_Header_Adj_Att_tbl IN OE_Order_PUB.Header_Adj_Att_Tbl_Type :=
181 OE_Order_PUB.G_MISS_HEADER_ADJ_ATT_TBL
182 , p_old_Header_Adj_Att_tbl IN OE_Order_PUB.Header_Adj_Att_Tbl_Type :=
183 OE_Order_PUB.G_MISS_HEADER_ADJ_ATT_TBL
184 , p_Header_Adj_Assoc_tbl IN OE_Order_PUB.Header_Adj_Assoc_Tbl_Type :=
185 OE_Order_PUB.G_MISS_HEADER_ADJ_ASSOC_TBL
186 , p_old_Header_Adj_Assoc_tbl IN OE_Order_PUB.Header_Adj_Assoc_Tbl_Type :=
187 OE_Order_PUB.G_MISS_HEADER_ADJ_ASSOC_TBL
188 , p_Header_Scredit_tbl IN OE_Order_PUB.Header_Scredit_Tbl_Type :=
189 OE_Order_PUB.G_MISS_HEADER_SCREDIT_TBL
190 , p_old_Header_Scredit_tbl IN OE_Order_PUB.Header_Scredit_Tbl_Type :=
191 OE_Order_PUB.G_MISS_HEADER_SCREDIT_TBL
192 , p_Header_Scredit_val_tbl IN OE_Order_PUB.Header_Scredit_Val_Tbl_Type :=
193 OE_Order_PUB.G_MISS_HEADER_SCREDIT_VAL_TBL
194 , p_old_Header_Scredit_val_tbl IN OE_Order_PUB.Header_Scredit_Val_Tbl_Type :=
195 OE_Order_PUB.G_MISS_HEADER_SCREDIT_VAL_TBL
196 , p_Header_Payment_tbl IN OE_Order_PUB.Header_Payment_Tbl_Type :=
197 OE_Order_PUB.G_MISS_HEADER_PAYMENT_TBL
198 , p_old_Header_Payment_tbl IN OE_Order_PUB.Header_Payment_Tbl_Type :=
199 OE_Order_PUB.G_MISS_HEADER_PAYMENT_TBL
200 , p_Header_Payment_val_tbl IN OE_Order_PUB.Header_Payment_Val_Tbl_Type :=
201 OE_Order_PUB.G_MISS_HEADER_PAYMENT_VAL_TBL
202 , p_old_Header_Payment_val_tbl IN OE_Order_PUB.Header_Payment_Val_Tbl_Type :=
203 OE_Order_PUB.G_MISS_HEADER_PAYMENT_VAL_TBL
204 , p_line_tbl IN OE_Order_PUB.Line_Tbl_Type :=
205 OE_Order_PUB.G_MISS_LINE_TBL
206 , p_old_line_tbl IN OE_Order_PUB.Line_Tbl_Type :=
207 OE_Order_PUB.G_MISS_LINE_TBL
208 , p_line_val_tbl IN OE_Order_PUB.Line_Val_Tbl_Type :=
209 OE_Order_PUB.G_MISS_LINE_VAL_TBL
210 , p_old_line_val_tbl IN OE_Order_PUB.Line_Val_Tbl_Type :=
211 OE_Order_PUB.G_MISS_LINE_VAL_TBL
212 , p_Line_Adj_tbl IN OE_Order_PUB.Line_Adj_Tbl_Type :=
213 OE_Order_PUB.G_MISS_LINE_ADJ_TBL
214 , p_old_Line_Adj_tbl IN OE_Order_PUB.Line_Adj_Tbl_Type :=
215 OE_Order_PUB.G_MISS_LINE_ADJ_TBL
216 , p_Line_Adj_val_tbl IN OE_Order_PUB.Line_Adj_Val_Tbl_Type :=
217 OE_Order_PUB.G_MISS_LINE_ADJ_VAL_TBL
218 , p_old_Line_Adj_val_tbl IN OE_Order_PUB.Line_Adj_Val_Tbl_Type :=
219 OE_Order_PUB.G_MISS_LINE_ADJ_VAL_TBL
220 , p_Line_price_Att_tbl IN OE_Order_PUB.Line_Price_Att_Tbl_Type :=
221 OE_Order_PUB.G_MISS_LINE_PRICE_ATT_TBL
222 , p_old_Line_Price_Att_tbl IN OE_Order_PUB.Line_Price_Att_Tbl_Type :=
223 OE_Order_PUB.G_MISS_LINE_PRICE_ATT_TBL
224 , p_Line_Adj_Att_tbl IN OE_Order_PUB.Line_Adj_Att_Tbl_Type :=
225 OE_Order_PUB.G_MISS_LINE_ADJ_ATT_TBL
226 , p_old_Line_Adj_Att_tbl IN OE_Order_PUB.Line_Adj_Att_Tbl_Type :=
227 OE_Order_PUB.G_MISS_LINE_ADJ_ATT_TBL
228 , p_Line_Adj_Assoc_tbl IN OE_Order_PUB.Line_Adj_Assoc_Tbl_Type :=
229 OE_Order_PUB.G_MISS_LINE_ADJ_ASSOC_TBL
230 , p_old_Line_Adj_Assoc_tbl IN OE_Order_PUB.Line_Adj_Assoc_Tbl_Type :=
231 OE_Order_PUB.G_MISS_LINE_ADJ_ASSOC_TBL
232 , p_Line_Scredit_tbl IN OE_Order_PUB.Line_Scredit_Tbl_Type :=
233 OE_Order_PUB.G_MISS_LINE_SCREDIT_TBL
234 , p_old_Line_Scredit_tbl IN OE_Order_PUB.Line_Scredit_Tbl_Type :=
235 OE_Order_PUB.G_MISS_LINE_SCREDIT_TBL
236 , p_Line_Scredit_val_tbl IN OE_Order_PUB.Line_Scredit_Val_Tbl_Type :=
237 OE_Order_PUB.G_MISS_LINE_SCREDIT_VAL_TBL
238 , p_old_Line_Scredit_val_tbl IN OE_Order_PUB.Line_Scredit_Val_Tbl_Type :=
239 OE_Order_PUB.G_MISS_LINE_SCREDIT_VAL_TBL
240 , p_Line_Payment_tbl IN OE_Order_PUB.Line_Payment_Tbl_Type :=
241 OE_Order_PUB.G_MISS_LINE_PAYMENT_TBL
242 , p_old_Line_Payment_tbl IN OE_Order_PUB.Line_Payment_Tbl_Type :=
243 OE_Order_PUB.G_MISS_LINE_PAYMENT_TBL
244 , p_Line_Payment_val_tbl IN OE_Order_PUB.Line_Payment_Val_Tbl_Type :=
245 OE_Order_PUB.G_MISS_LINE_PAYMENT_VAL_TBL
246 , p_old_Line_Payment_val_tbl IN OE_Order_PUB.Line_Payment_Val_Tbl_Type :=
247 OE_Order_PUB.G_MISS_LINE_PAYMENT_VAL_TBL
248 , p_Lot_Serial_tbl IN OE_Order_PUB.Lot_Serial_Tbl_Type :=
249 OE_Order_PUB.G_MISS_LOT_SERIAL_TBL
250 , p_old_Lot_Serial_tbl IN OE_Order_PUB.Lot_Serial_Tbl_Type :=
251 OE_Order_PUB.G_MISS_LOT_SERIAL_TBL
252 , p_Lot_Serial_val_tbl IN OE_Order_PUB.Lot_Serial_Val_Tbl_Type :=
253 OE_Order_PUB.G_MISS_LOT_SERIAL_VAL_TBL
254 , p_old_Lot_Serial_val_tbl IN OE_Order_PUB.Lot_Serial_Val_Tbl_Type :=
255 OE_Order_PUB.G_MISS_LOT_SERIAL_VAL_TBL
256 , p_action_request_tbl IN OE_Order_PUB.Request_Tbl_Type :=
257 OE_Order_PUB.G_MISS_REQUEST_TBL
258 , x_header_rec OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Rec_Type
259 , x_header_val_rec OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Val_Rec_Type
260 , x_Header_Adj_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Tbl_Type
261 , x_Header_Adj_val_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Val_Tbl_Type
262 , x_Header_price_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Price_Att_Tbl_Type
263 , x_Header_Adj_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Att_Tbl_Type
264 , x_Header_Adj_Assoc_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Assoc_Tbl_Type
265 , x_Header_Scredit_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Scredit_Tbl_Type
266 , x_Header_Scredit_val_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Scredit_Val_Tbl_Type
267 , x_Header_Payment_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Payment_Tbl_Type
268 , x_Header_Payment_val_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Payment_Val_Tbl_Type
269 , x_line_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Tbl_Type
270 , x_line_val_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Val_Tbl_Type
271 , x_Line_Adj_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Tbl_Type
272 , x_Line_Adj_val_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Val_Tbl_Type
273 , x_Line_price_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Price_Att_Tbl_Type
274 , x_Line_Adj_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Att_Tbl_Type
275 , x_Line_Adj_Assoc_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Assoc_Tbl_Type
276 , x_Line_Scredit_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Scredit_Tbl_Type
277 , x_Line_Scredit_val_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Scredit_Val_Tbl_Type
278 , x_Line_Payment_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Payment_Tbl_Type
279 , x_Line_Payment_val_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Payment_Val_Tbl_Type
280 , x_Lot_Serial_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Lot_Serial_Tbl_Type
281 , x_Lot_Serial_val_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Lot_Serial_Val_Tbl_Type
282 , x_action_request_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Request_Tbl_Type
283 --For bug 3390458
284 , p_rtrim_data IN Varchar2 :='N'
285 , p_validate_desc_flex in varchar2 default 'Y' -- bug4343612
286 --ER7675548
287 , p_header_customer_info_tbl IN OE_ORDER_PUB.CUSTOMER_INFO_TABLE_TYPE :=
288 OE_ORDER_PUB.G_MISS_CUSTOMER_INFO_TBL
289 , p_line_customer_info_tbl IN OE_ORDER_PUB.CUSTOMER_INFO_TABLE_TYPE :=
290 OE_ORDER_PUB.G_MISS_CUSTOMER_INFO_TBL
291 );
292
293 -- Start of Comments
294 -- API name Lock_Order
295 -- Type Group
296 -- Function Over Loaded
297 --
298 -- Pre-reqs
299 --
300 -- Parameters
301 --
302 -- Version Current version = 1.0
303 -- Initial version = 1.0
304 --
305 -- Notes
306 --
307 -- End of Comments
308
309 PROCEDURE Lock_Order
310 ( p_api_version_number IN NUMBER
311 , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
312 , p_return_values IN VARCHAR2 := FND_API.G_FALSE
313 , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
314 , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
315 , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
316 , p_header_rec IN OE_Order_PUB.Header_Rec_Type :=
317 OE_Order_PUB.G_MISS_HEADER_REC
318 , p_header_val_rec IN OE_Order_PUB.Header_Val_Rec_Type :=
319 OE_Order_PUB.G_MISS_HEADER_VAL_REC
320 , p_Header_Adj_tbl IN OE_Order_PUB.Header_Adj_Tbl_Type :=
321 OE_Order_PUB.G_MISS_HEADER_ADJ_TBL
322 , p_Header_Adj_val_tbl IN OE_Order_PUB.Header_Adj_Val_Tbl_Type :=
323 OE_Order_PUB.G_MISS_HEADER_ADJ_VAL_TBL
324 , p_Header_price_Att_tbl IN OE_Order_PUB.Header_Price_Att_Tbl_Type :=
325 OE_Order_PUB.G_MISS_HEADER_PRICE_ATT_TBL
326 , p_Header_Adj_Att_tbl IN OE_Order_PUB.Header_Adj_Att_Tbl_Type :=
327 OE_Order_PUB.G_MISS_HEADER_ADJ_ATT_TBL
328 , p_Header_Adj_Assoc_tbl IN OE_Order_PUB.Header_Adj_Assoc_Tbl_Type :=
329 OE_Order_PUB.G_MISS_HEADER_ADJ_ASSOC_TBL
330 , p_Header_Scredit_tbl IN OE_Order_PUB.Header_Scredit_Tbl_Type :=
331 OE_Order_PUB.G_MISS_HEADER_SCREDIT_TBL
332 , p_Header_Scredit_val_tbl IN OE_Order_PUB.Header_Scredit_Val_Tbl_Type :=
333 OE_Order_PUB.G_MISS_HEADER_SCREDIT_VAL_TBL
334 , p_line_tbl IN OE_Order_PUB.Line_Tbl_Type :=
335 OE_Order_PUB.G_MISS_LINE_TBL
336 , p_line_val_tbl IN OE_Order_PUB.Line_Val_Tbl_Type :=
337 OE_Order_PUB.G_MISS_LINE_VAL_TBL
338 , p_Line_Adj_tbl IN OE_Order_PUB.Line_Adj_Tbl_Type :=
339 OE_Order_PUB.G_MISS_LINE_ADJ_TBL
340 , p_Line_Adj_val_tbl IN OE_Order_PUB.Line_Adj_Val_Tbl_Type :=
341 OE_Order_PUB.G_MISS_LINE_ADJ_VAL_TBL
342 , p_Line_price_Att_tbl IN OE_Order_PUB.Line_Price_Att_Tbl_Type :=
343 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 OE_Order_PUB.G_MISS_LINE_ADJ_ATT_TBL
346 , p_Line_Adj_Assoc_tbl IN OE_Order_PUB.Line_Adj_Assoc_Tbl_Type :=
347 OE_Order_PUB.G_MISS_LINE_ADJ_ASSOC_TBL
348 , p_Line_Scredit_tbl IN OE_Order_PUB.Line_Scredit_Tbl_Type :=
349 OE_Order_PUB.G_MISS_LINE_SCREDIT_TBL
350 , p_Line_Scredit_val_tbl IN OE_Order_PUB.Line_Scredit_Val_Tbl_Type :=
351 OE_Order_PUB.G_MISS_LINE_SCREDIT_VAL_TBL
352 , p_Lot_Serial_tbl IN OE_Order_PUB.Lot_Serial_Tbl_Type :=
353 OE_Order_PUB.G_MISS_LOT_SERIAL_TBL
354 , p_Lot_Serial_val_tbl IN OE_Order_PUB.Lot_Serial_Val_Tbl_Type :=
355 OE_Order_PUB.G_MISS_LOT_SERIAL_VAL_TBL
356 , x_header_rec OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Rec_Type
357 , x_header_val_rec OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Val_Rec_Type
358 , x_Header_Adj_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Tbl_Type
359 , x_Header_Adj_val_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Val_Tbl_Type
360 , x_Header_price_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Price_Att_Tbl_Type
361 , x_Header_Adj_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Att_Tbl_Type
362 , x_Header_Adj_Assoc_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Assoc_Tbl_Type
363 , x_Header_Scredit_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Scredit_Tbl_Type
364 , x_Header_Scredit_val_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Scredit_Val_Tbl_Type
365 , x_line_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Tbl_Type
366 , x_line_val_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Val_Tbl_Type
367 , x_Line_Adj_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Tbl_Type
368 , x_Line_Adj_val_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Val_Tbl_Type
369 , x_Line_price_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Price_Att_Tbl_Type
370 , x_Line_Adj_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Att_Tbl_Type
371 , x_Line_Adj_Assoc_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Assoc_Tbl_Type
372 , x_Line_Scredit_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Scredit_Tbl_Type
373 , x_Line_Scredit_val_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Scredit_Val_Tbl_Type
374 , x_Lot_Serial_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Lot_Serial_Tbl_Type
375 , x_Lot_Serial_val_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Lot_Serial_Val_Tbl_Type
376 );
377
378 -- Lock_order over loaded with payment parameters
379 PROCEDURE Lock_Order
380 ( p_api_version_number IN NUMBER
381 , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
382 , p_return_values IN VARCHAR2 := FND_API.G_FALSE
383 , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
384 , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
385 , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
386 , p_header_rec IN OE_Order_PUB.Header_Rec_Type :=
387 OE_Order_PUB.G_MISS_HEADER_REC
388 , p_header_val_rec IN OE_Order_PUB.Header_Val_Rec_Type :=
389 OE_Order_PUB.G_MISS_HEADER_VAL_REC
390 , p_Header_Adj_tbl IN OE_Order_PUB.Header_Adj_Tbl_Type :=
391 OE_Order_PUB.G_MISS_HEADER_ADJ_TBL
392 , p_Header_Adj_val_tbl IN OE_Order_PUB.Header_Adj_Val_Tbl_Type :=
393 OE_Order_PUB.G_MISS_HEADER_ADJ_VAL_TBL
394 , p_Header_price_Att_tbl IN OE_Order_PUB.Header_Price_Att_Tbl_Type :=
395 OE_Order_PUB.G_MISS_HEADER_PRICE_ATT_TBL
396 , p_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_Header_Scredit_tbl IN OE_Order_PUB.Header_Scredit_Tbl_Type :=
401 OE_Order_PUB.G_MISS_HEADER_SCREDIT_TBL
402 , p_Header_Scredit_val_tbl IN OE_Order_PUB.Header_Scredit_Val_Tbl_Type :=
403 OE_Order_PUB.G_MISS_HEADER_SCREDIT_VAL_TBL
404 , p_Header_Payment_tbl IN OE_Order_PUB.Header_Payment_Tbl_Type :=
405 OE_Order_PUB.G_MISS_HEADER_PAYMENT_TBL
406 , p_Header_Payment_val_tbl IN OE_Order_PUB.Header_Payment_Val_Tbl_Type :=
407 OE_Order_PUB.G_MISS_HEADER_PAYMENT_VAL_TBL
408 , p_line_tbl IN OE_Order_PUB.Line_Tbl_Type :=
409 OE_Order_PUB.G_MISS_LINE_TBL
410 , p_line_val_tbl IN OE_Order_PUB.Line_Val_Tbl_Type :=
411 OE_Order_PUB.G_MISS_LINE_VAL_TBL
412 , p_Line_Adj_tbl IN OE_Order_PUB.Line_Adj_Tbl_Type :=
413 OE_Order_PUB.G_MISS_LINE_ADJ_TBL
414 , p_Line_Adj_val_tbl IN OE_Order_PUB.Line_Adj_Val_Tbl_Type :=
415 OE_Order_PUB.G_MISS_LINE_ADJ_VAL_TBL
416 , p_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_Line_Adj_Assoc_tbl IN OE_Order_PUB.Line_Adj_Assoc_Tbl_Type :=
421 OE_Order_PUB.G_MISS_LINE_ADJ_ASSOC_TBL
422 , p_Line_Scredit_tbl IN OE_Order_PUB.Line_Scredit_Tbl_Type :=
423 OE_Order_PUB.G_MISS_LINE_SCREDIT_TBL
424 , p_Line_Scredit_val_tbl IN OE_Order_PUB.Line_Scredit_Val_Tbl_Type :=
425 OE_Order_PUB.G_MISS_LINE_SCREDIT_VAL_TBL
426 , p_Line_Payment_tbl IN OE_Order_PUB.Line_Payment_Tbl_Type :=
427 OE_Order_PUB.G_MISS_LINE_PAYMENT_TBL
428 , p_Line_Payment_val_tbl IN OE_Order_PUB.Line_Payment_Val_Tbl_Type :=
429 OE_Order_PUB.G_MISS_LINE_PAYMENT_VAL_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_Lot_Serial_val_tbl IN OE_Order_PUB.Lot_Serial_Val_Tbl_Type :=
433 OE_Order_PUB.G_MISS_LOT_SERIAL_VAL_TBL
434 , x_header_rec OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Rec_Type
435 , x_header_val_rec OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Val_Rec_Type
436 , x_Header_Adj_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Tbl_Type
437 , x_Header_Adj_val_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Val_Tbl_Type
438 , x_Header_price_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Price_Att_Tbl_Type
439 , x_Header_Adj_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Att_Tbl_Type
440 , x_Header_Adj_Assoc_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Assoc_Tbl_Type
441 , x_Header_Scredit_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Scredit_Tbl_Type
442 , x_Header_Scredit_val_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Scredit_Val_Tbl_Type
443 , x_Header_Payment_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Payment_Tbl_Type
444 , x_Header_Payment_val_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Payment_Val_Tbl_Type
445 , x_line_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Tbl_Type
446 , x_line_val_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Val_Tbl_Type
447 , x_Line_Adj_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Tbl_Type
448 , x_Line_Adj_val_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Val_Tbl_Type
449 , x_Line_price_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Price_Att_Tbl_Type
450 , x_Line_Adj_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Att_Tbl_Type
451 , x_Line_Adj_Assoc_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Assoc_Tbl_Type
452 , x_Line_Scredit_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Scredit_Tbl_Type
453 , x_Line_Scredit_val_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Scredit_Val_Tbl_Type
454 , x_Line_Payment_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Payment_Tbl_Type
455 , x_Line_Payment_val_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Payment_Val_Tbl_Type
456 , x_Lot_Serial_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Lot_Serial_Tbl_Type
457 , x_Lot_Serial_val_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Lot_Serial_Val_Tbl_Type
458 );
459
460 -- Start of Comments
461 -- API name Get_Order
462 -- Type Group
463 -- Function Over Loaded
464 --
465 -- Pre-reqs
466 --
467 -- Parameters
468 --
469 -- Version Current version = 1.0
470 -- Initial version = 1.0
471 --
472 -- Notes
473 --
474 -- End of Comments
475
476 PROCEDURE Get_Order
477 ( p_api_version_number IN NUMBER
478 , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
479 , p_return_values IN VARCHAR2 := FND_API.G_FALSE
480 , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
481 , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
482 , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
483 , p_header_id IN NUMBER :=
484 FND_API.G_MISS_NUM
485 , p_header IN VARCHAR2 :=
486 FND_API.G_MISS_CHAR
487 , x_header_rec OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Rec_Type
488 , x_header_val_rec OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Val_Rec_Type
489 , x_Header_Adj_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Tbl_Type
490 , x_Header_Adj_val_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Val_Tbl_Type
491 , x_Header_price_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Price_Att_Tbl_Type
492 , x_Header_Adj_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Att_Tbl_Type
493 , x_Header_Adj_Assoc_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Assoc_Tbl_Type
494 , x_Header_Scredit_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Scredit_Tbl_Type
495 , x_Header_Scredit_val_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Scredit_Val_Tbl_Type
496 , x_line_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Tbl_Type
497 , x_line_val_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Val_Tbl_Type
498 , x_Line_Adj_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Tbl_Type
499 , x_Line_Adj_val_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Val_Tbl_Type
500 , x_Line_price_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Price_Att_Tbl_Type
501 , x_Line_Adj_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Att_Tbl_Type
502 , x_Line_Adj_Assoc_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Assoc_Tbl_Type
503 , x_Line_Scredit_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Scredit_Tbl_Type
504 , x_Line_Scredit_val_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Scredit_Val_Tbl_Type
505 , x_Lot_Serial_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Lot_Serial_Tbl_Type
506 , x_Lot_Serial_val_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Lot_Serial_Val_Tbl_Type
507 );
508
509
510 -- Get_order over loaded with payment parameters
511 PROCEDURE Get_Order
512 ( p_api_version_number IN NUMBER
513 , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
514 , p_return_values IN VARCHAR2 := FND_API.G_FALSE
515 , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
516 , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
517 , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
518 , p_header_id IN NUMBER :=
519 FND_API.G_MISS_NUM
520 , p_header IN VARCHAR2 :=
521 FND_API.G_MISS_CHAR
522 , x_header_rec OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Rec_Type
523 , x_header_val_rec OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Val_Rec_Type
524 , x_Header_Adj_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Tbl_Type
525 , x_Header_Adj_val_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Val_Tbl_Type
526 , x_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_Header_Adj_Assoc_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Assoc_Tbl_Type
529 , x_Header_Scredit_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Scredit_Tbl_Type
530 , x_Header_Scredit_val_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Scredit_Val_Tbl_Type
531 , x_Header_Payment_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Payment_Tbl_Type
532 , x_Header_Payment_val_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Payment_Val_Tbl_Type
533 , x_line_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Tbl_Type
534 , x_line_val_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Val_Tbl_Type
535 , x_Line_Adj_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Tbl_Type
536 , x_Line_Adj_val_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Val_Tbl_Type
537 , x_Line_price_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Price_Att_Tbl_Type
538 , x_Line_Adj_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Att_Tbl_Type
539 , x_Line_Adj_Assoc_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Assoc_Tbl_Type
540 , x_Line_Scredit_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Scredit_Tbl_Type
541 , x_Line_Scredit_val_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Scredit_Val_Tbl_Type
542 , x_Line_Payment_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Payment_Tbl_Type
543 , x_Line_Payment_val_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Payment_Val_Tbl_Type
544 , x_Lot_Serial_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Lot_Serial_Tbl_Type
545 , x_Lot_Serial_val_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Lot_Serial_Val_Tbl_Type
546 );
547
548 PROCEDURE Get_Option_Lines
549 ( p_api_version_number IN NUMBER
550 , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
551 , p_top_model_line_id IN NUMBER
552 , x_line_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_Pub.Line_Tbl_Type
553 , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
554 , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
555 , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
556 );
557
558 PROCEDURE Id_To_Value
559 ( p_header_rec IN OE_Order_PUB.Header_Rec_Type
560 , p_Header_Adj_tbl IN OE_Order_PUB.Header_Adj_Tbl_Type
561 , p_Header_Scredit_tbl IN OE_Order_PUB.Header_Scredit_Tbl_Type
562 , p_line_tbl IN OE_Order_PUB.Line_Tbl_Type
563 , p_Line_Adj_tbl IN OE_Order_PUB.Line_Adj_Tbl_Type
564 , p_Line_Scredit_tbl IN OE_Order_PUB.Line_Scredit_Tbl_Type
565 , p_Lot_Serial_tbl IN OE_Order_PUB.Lot_Serial_Tbl_Type
566 , x_header_val_rec OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Val_Rec_Type
567 , x_Header_Adj_val_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Val_Tbl_Type
568 , x_Header_Scredit_val_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Scredit_Val_Tbl_Type
569 , x_line_val_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Val_Tbl_Type
570 , x_Line_Adj_val_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Val_Tbl_Type
571 , x_Line_Scredit_val_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Scredit_Val_Tbl_Type
572 , x_Lot_Serial_val_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Lot_Serial_Val_Tbl_Type
573 );
574
575 -- Id_To_Value over loaded with payment parameters
576
577 PROCEDURE Id_To_Value
578 ( p_header_rec IN OE_Order_PUB.Header_Rec_Type
579 , p_Header_Adj_tbl IN OE_Order_PUB.Header_Adj_Tbl_Type
580 , p_Header_Scredit_tbl IN OE_Order_PUB.Header_Scredit_Tbl_Type
581 , p_Header_Payment_tbl IN OE_Order_PUB.Header_Payment_Tbl_Type
582 , p_line_tbl IN OE_Order_PUB.Line_Tbl_Type
583 , p_Line_Adj_tbl IN OE_Order_PUB.Line_Adj_Tbl_Type
584 , p_Line_Scredit_tbl IN OE_Order_PUB.Line_Scredit_Tbl_Type
585 , p_Line_Payment_tbl IN OE_Order_PUB.Line_Payment_Tbl_Type
586 , p_Lot_Serial_tbl IN OE_Order_PUB.Lot_Serial_Tbl_Type
587 , x_header_val_rec OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Val_Rec_Type
588 , x_Header_Adj_val_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Val_Tbl_Type
589 , x_Header_Scredit_val_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Scredit_Val_Tbl_Type
590 , x_Header_Payment_val_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Payment_Val_Tbl_Type
591 , x_line_val_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Val_Tbl_Type
592 , x_Line_Adj_val_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Val_Tbl_Type
593 , x_Line_Scredit_val_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Scredit_Val_Tbl_Type
594 , x_Line_Payment_val_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Payment_Val_Tbl_Type
595 , x_Lot_Serial_val_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Lot_Serial_Val_Tbl_Type
596 );
597
598 PROCEDURE Value_To_Id (
599 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
600 , p_header_rec IN OE_Order_PUB.Header_Rec_Type
601 , p_header_val_rec IN OE_Order_PUB.Header_Val_Rec_Type
602 , p_Header_Adj_tbl IN OE_Order_PUB.Header_Adj_Tbl_Type
603 , p_Header_Adj_val_tbl IN OE_Order_PUB.Header_Adj_Val_Tbl_Type
604 , p_Header_Scredit_tbl IN OE_Order_PUB.Header_Scredit_Tbl_Type
605 , p_Header_Scredit_val_tbl IN OE_Order_PUB.Header_Scredit_Val_Tbl_Type
606 , p_line_tbl IN OE_Order_PUB.Line_Tbl_Type
607 , p_line_val_tbl IN OE_Order_PUB.Line_Val_Tbl_Type
608 , p_Line_Adj_tbl IN OE_Order_PUB.Line_Adj_Tbl_Type
609 , p_Line_Adj_val_tbl IN OE_Order_PUB.Line_Adj_Val_Tbl_Type
610 , p_Line_Scredit_tbl IN OE_Order_PUB.Line_Scredit_Tbl_Type
611 , p_Line_Scredit_val_tbl IN OE_Order_PUB.Line_Scredit_Val_Tbl_Type
612 , p_Lot_Serial_tbl IN OE_Order_PUB.Lot_Serial_Tbl_Type
613 , p_Lot_Serial_val_tbl IN OE_Order_PUB.Lot_Serial_Val_Tbl_Type
614 , x_header_rec OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Rec_Type
615 , x_Header_Adj_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Tbl_Type
616 , x_Header_Scredit_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Scredit_Tbl_Type
617 , x_line_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Tbl_Type
618 , x_Line_Adj_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Tbl_Type
619 , x_Line_Scredit_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Scredit_Tbl_Type
620 , x_Lot_Serial_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Lot_Serial_Tbl_Type
621 );
622
623 -- Id_To_Value over loaded with payment parameters
624
625 PROCEDURE Value_To_Id (
626 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
627 , p_header_rec IN OE_Order_PUB.Header_Rec_Type
628 , p_header_val_rec IN OE_Order_PUB.Header_Val_Rec_Type
629 , p_Header_Adj_tbl IN OE_Order_PUB.Header_Adj_Tbl_Type
630 , p_Header_Adj_val_tbl IN OE_Order_PUB.Header_Adj_Val_Tbl_Type
631 , p_Header_Scredit_tbl IN OE_Order_PUB.Header_Scredit_Tbl_Type
632 , p_Header_Scredit_val_tbl IN OE_Order_PUB.Header_Scredit_Val_Tbl_Type
633 , p_Header_Payment_tbl IN OE_Order_PUB.Header_Payment_Tbl_Type
634 , p_Header_Payment_val_tbl IN OE_Order_PUB.Header_Payment_Val_Tbl_Type
635 , p_line_tbl IN OE_Order_PUB.Line_Tbl_Type
636 , p_line_val_tbl IN OE_Order_PUB.Line_Val_Tbl_Type
637 , p_Line_Adj_tbl IN OE_Order_PUB.Line_Adj_Tbl_Type
638 , p_Line_Adj_val_tbl IN OE_Order_PUB.Line_Adj_Val_Tbl_Type
639 , p_Line_Scredit_tbl IN OE_Order_PUB.Line_Scredit_Tbl_Type
640 , p_Line_Scredit_val_tbl IN OE_Order_PUB.Line_Scredit_Val_Tbl_Type
641 , p_Line_Payment_tbl IN OE_Order_PUB.Line_Payment_Tbl_Type
642 , p_Line_Payment_val_tbl IN OE_Order_PUB.Line_Payment_Val_Tbl_Type
643 , p_Lot_Serial_tbl IN OE_Order_PUB.Lot_Serial_Tbl_Type
644 , p_Lot_Serial_val_tbl IN OE_Order_PUB.Lot_Serial_Val_Tbl_Type
645 , x_header_rec OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Rec_Type
646 , x_Header_Adj_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Tbl_Type
647 , x_Header_Scredit_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Scredit_Tbl_Type
648 , x_Header_Payment_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Payment_Tbl_Type
649 , x_line_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Tbl_Type
650 , x_Line_Adj_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Tbl_Type
651 , x_Line_Scredit_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Scredit_Tbl_Type
652 , x_Line_Payment_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Payment_Tbl_Type
653 , x_Lot_Serial_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Lot_Serial_Tbl_Type
654 );
655
656 PROCEDURE automatic_account_creation
657 (
658 p_header_rec IN OE_Order_Pub.Header_Rec_Type,
659 p_Header_Val_Rec IN OE_Order_pub.Header_Val_Rec_TYPE,
660 p_line_tbl IN OE_Order_Pub.Line_Tbl_Type,
661 p_Line_Val_tbl IN OE_Order_pub.Line_Val_tbl_Type,
662 x_header_rec IN OUT NOCOPY /* file.sql.39 change */ OE_Order_Pub.Header_Rec_Type, --bug6278382
663 x_line_tbl IN OUT NOCOPY /* file.sql.39 change */ OE_Order_Pub.Line_Tbl_Type, --bug6278382
664 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
665 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
666 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
667 );
668
669 --For bug 3390458
670 Procedure RTrim_data
671 ( p_x_header_rec IN OUT NOCOPY OE_Order_Pub.Header_Rec_Type
672 , p_x_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_Tbl_Type
673 , x_return_status OUT NOCOPY /* file.sql.39 change */ Varchar2);
674
675 -- Introduced for OKC workbench call. Call this API to check if there are
676 --constraints defined for the attribute "Contract terms"
677
678 PROCEDURE Check_Header_Security
679 ( p_document_type IN VARCHAR2
680 , p_column IN VARCHAR2 := NULL
681 , p_header_id IN NUMBER
682 , p_operation IN VARCHAR2
683 , x_msg_count OUT NOCOPY NUMBER
684 , x_msg_data OUT NOCOPY VARCHAR2
685 , x_return_status OUT NOCOPY VARCHAR2
686 , x_result OUT NOCOPY NUMBER
687 );
688
689 END OE_Order_GRP;