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