[Home] [Help]
PACKAGE: APPS.OE_PRICE_LIST_PUB
Source
1 PACKAGE OE_Price_List_PUB AUTHID CURRENT_USER AS
2 /* $Header: OEXPPRLS.pls 120.0 2005/06/02 00:21:04 appldev noship $ */
3
4 -- Price_List record type
5
6 TYPE Price_List_Rec_Type IS RECORD
7 ( attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
8 , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
9 , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
10 , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
11 , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
12 , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
13 , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
14 , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
15 , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
16 , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
17 , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
18 , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
19 , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
20 , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
21 , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
22 , comments VARCHAR2(240) := FND_API.G_MISS_CHAR
23 , context VARCHAR2(30) := FND_API.G_MISS_CHAR
24 , created_by NUMBER := FND_API.G_MISS_NUM
25 , creation_date DATE := FND_API.G_MISS_DATE
26 , currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR
27 , description VARCHAR2(2000) := FND_API.G_MISS_CHAR
28 , end_date_active DATE := FND_API.G_MISS_DATE
29 , freight_terms_code VARCHAR2(30) := FND_API.G_MISS_CHAR
30 , last_updated_by NUMBER := FND_API.G_MISS_NUM
31 , last_update_date DATE := FND_API.G_MISS_DATE
32 , last_update_login NUMBER := FND_API.G_MISS_NUM
33 , name VARCHAR2(240) := FND_API.G_MISS_CHAR
34 , price_list_id NUMBER := FND_API.G_MISS_NUM
35 , pricing_contract_id NUMBER := FND_API.G_MISS_NUM
36 , program_application_id NUMBER := FND_API.G_MISS_NUM
37 , program_id NUMBER := FND_API.G_MISS_NUM
38 , program_update_date DATE := FND_API.G_MISS_DATE
39 , request_id NUMBER := FND_API.G_MISS_NUM
40 , rounding_factor NUMBER := FND_API.G_MISS_NUM
41 , secondary_price_list_id NUMBER := FND_API.G_MISS_NUM
42 , ship_method_code VARCHAR2(30) := FND_API.G_MISS_CHAR
43 , start_date_active DATE := FND_API.G_MISS_DATE
44 , terms_id NUMBER := FND_API.G_MISS_NUM
45 , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
46 , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
47 , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
48 , tp_attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
49 , tp_attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
50 , tp_attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
51 , tp_attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
52 , tp_attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
53 , tp_attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
54 , tp_attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
55 , tp_attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
56 , tp_attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
57 , tp_attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
58 , tp_attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
59 , tp_attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
60 , tp_attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
61 , tp_attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
62 , tp_attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
63 , tp_attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR
64 , currency_header_id NUMBER := FND_API.G_MISS_NUM -- Multi-Currency SunilPandey
65 );
66
67 TYPE Price_List_Tbl_Type IS TABLE OF Price_List_Rec_Type
68 INDEX BY BINARY_INTEGER;
69
70 -- Price_List value record type
71
72 TYPE Price_List_Val_Rec_Type IS RECORD
73 ( currency VARCHAR2(240) := FND_API.G_MISS_CHAR
74 , freight_terms VARCHAR2(240) := FND_API.G_MISS_CHAR
75 , price_list VARCHAR2(240) := FND_API.G_MISS_CHAR
76 , secondary_price_list VARCHAR2(240) := FND_API.G_MISS_CHAR
77 , ship_method VARCHAR2(240) := FND_API.G_MISS_CHAR
78 , terms VARCHAR2(240) := FND_API.G_MISS_CHAR
79 );
80
81 TYPE Price_List_Val_Tbl_Type IS TABLE OF Price_List_Val_Rec_Type
82 INDEX BY BINARY_INTEGER;
83
84 -- Price_List_Line record type
85
86 TYPE Price_List_Line_Rec_Type IS RECORD
87 ( attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
88 , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
89 , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
90 , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
91 , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
92 , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
93 , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
94 , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
95 , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
96 , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
97 , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
98 , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
99 , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
100 , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
101 , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
102 , comments VARCHAR2(2000) := FND_API.G_MISS_CHAR
103 , context VARCHAR2(30) := FND_API.G_MISS_CHAR
104 , created_by NUMBER := FND_API.G_MISS_NUM
105 , creation_date DATE := FND_API.G_MISS_DATE
106 , customer_item_id NUMBER := FND_API.G_MISS_NUM
107 , end_date_active DATE := FND_API.G_MISS_DATE
108 , inventory_item_id NUMBER := FND_API.G_MISS_NUM
109 , last_updated_by NUMBER := FND_API.G_MISS_NUM
110 , last_update_date DATE := FND_API.G_MISS_DATE
111 , last_update_login NUMBER := FND_API.G_MISS_NUM
112 , list_price NUMBER := FND_API.G_MISS_NUM
113 , method_code VARCHAR2(4) := FND_API.G_MISS_CHAR
114 , price_list_id NUMBER := FND_API.G_MISS_NUM
115 , price_list_line_id NUMBER := FND_API.G_MISS_NUM
116 , pricing_attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
117 , pricing_attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
118 , pricing_attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
119 , pricing_attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
120 , pricing_attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
121 , pricing_attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
122 , pricing_attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
123 , pricing_attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
124 , pricing_attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
125 , pricing_attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
126 , pricing_attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
127 , pricing_attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
128 , pricing_attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
129 , pricing_attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
130 , pricing_attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
131 , pricing_context VARCHAR2(30) := FND_API.G_MISS_CHAR
132 , pricing_rule_id NUMBER := FND_API.G_MISS_NUM
133 , primary VARCHAR2(30) := FND_API.G_MISS_CHAR
134 , program_application_id NUMBER := FND_API.G_MISS_NUM
135 , program_id NUMBER := FND_API.G_MISS_NUM
136 , program_update_date DATE := FND_API.G_MISS_DATE
137 , reprice_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
138 , request_id NUMBER := FND_API.G_MISS_NUM
139 , revision VARCHAR2(50) := FND_API.G_MISS_CHAR
140 , revision_date DATE := FND_API.G_MISS_DATE
141 , revision_reason_code VARCHAR2(30) := FND_API.G_MISS_CHAR
142 , start_date_active DATE := FND_API.G_MISS_DATE
143 , unit_code VARCHAR2(3) := FND_API.G_MISS_CHAR
144 , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
145 , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
146 , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
147 , tp_attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
148 , tp_attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
149 , tp_attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
150 , tp_attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
151 , tp_attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
152 , tp_attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
153 , tp_attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
154 , tp_attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
155 , tp_attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
156 , tp_attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
157 , tp_attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
158 , tp_attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
159 , tp_attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
160 , tp_attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
161 , tp_attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
162 , tp_attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR
163 , method_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
164 , price_break_high NUMBER := FND_API.G_MISS_NUM
165 , price_break_low NUMBER := FND_API.G_MISS_NUM
166 , price_break_parent_line NUMBER := FND_API.G_MISS_NUM
167 , list_line_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
168 , price_break_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
169 );
170
171 TYPE Price_List_Line_Tbl_Type IS TABLE OF Price_List_Line_Rec_Type
172 INDEX BY BINARY_INTEGER;
173
174 -- Price_List_Line value record type
175
176 TYPE Price_List_Line_Val_Rec_Type IS RECORD
177 ( customer_item VARCHAR2(240) := FND_API.G_MISS_CHAR
178 , inventory_item VARCHAR2(240) := FND_API.G_MISS_CHAR
179 , method VARCHAR2(240) := FND_API.G_MISS_CHAR
180 , price_list VARCHAR2(240) := FND_API.G_MISS_CHAR
181 , price_list_line VARCHAR2(240) := FND_API.G_MISS_CHAR
182 , pricing_rule VARCHAR2(240) := FND_API.G_MISS_CHAR
183 , reprice VARCHAR2(240) := FND_API.G_MISS_CHAR
184 , revision_reason VARCHAR2(240) := FND_API.G_MISS_CHAR
185 , unit VARCHAR2(240) := FND_API.G_MISS_CHAR
186 );
187
188 TYPE Price_List_Line_Val_Tbl_Type IS TABLE OF Price_List_Line_Val_Rec_Type
189 INDEX BY BINARY_INTEGER;
190
191 -- Pricing_Attr record type
192
193 TYPE Pricing_Attr_Rec_Type IS RECORD
194 ( accumulate_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
195 , attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
196 , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
197 , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
198 , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
199 , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
200 , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
201 , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
202 , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
203 , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
204 , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
205 , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
206 , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
207 , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
208 , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
209 , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
210 , attribute_grouping_no NUMBER := FND_API.G_MISS_NUM
211 , context VARCHAR2(30) := FND_API.G_MISS_CHAR
212 , created_by NUMBER := FND_API.G_MISS_NUM
213 , creation_date DATE := FND_API.G_MISS_DATE
214 , excluder_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
215 , last_updated_by NUMBER := FND_API.G_MISS_NUM
216 , last_update_date DATE := FND_API.G_MISS_DATE
217 , last_update_login NUMBER := FND_API.G_MISS_NUM
218 , list_line_id NUMBER := FND_API.G_MISS_NUM
219 , pricing_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR
220 , pricing_attribute_context VARCHAR2(30) := FND_API.G_MISS_CHAR
221 , pricing_attribute_id NUMBER := FND_API.G_MISS_NUM
222 , pricing_attr_value_from VARCHAR2(240) := FND_API.G_MISS_CHAR
223 , pricing_attr_value_to VARCHAR2(240) := FND_API.G_MISS_CHAR
224 , product_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR
225 , product_attribute_context VARCHAR2(30) := FND_API.G_MISS_CHAR
226 , product_attr_value VARCHAR2(240) := FND_API.G_MISS_CHAR
227 , product_uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR
228 , program_application_id NUMBER := FND_API.G_MISS_NUM
229 , program_id NUMBER := FND_API.G_MISS_NUM
230 , program_update_date DATE := FND_API.G_MISS_DATE
231 , request_id NUMBER := FND_API.G_MISS_NUM
232 , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
236 );
233 , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
234 , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
235 , PRICE_LIST_LINE_index NUMBER := FND_API.G_MISS_NUM
237
238 TYPE Pricing_Attr_Tbl_Type IS TABLE OF Pricing_Attr_Rec_Type
239 INDEX BY BINARY_INTEGER;
240
241 -- Variables representing missing records and tables
242
243 G_MISS_PRICE_LIST_REC Price_List_Rec_Type;
244 G_MISS_PRICE_LIST_VAL_REC Price_List_Val_Rec_Type;
245 G_MISS_PRICE_LIST_TBL Price_List_Tbl_Type;
246 G_MISS_PRICE_LIST_VAL_TBL Price_List_Val_Tbl_Type;
247 G_MISS_PRICE_LIST_LINE_REC Price_List_Line_Rec_Type;
248 G_MISS_PRICE_LIST_LINE_VAL_REC Price_List_Line_Val_Rec_Type;
249 G_MISS_PRICE_LIST_LINE_TBL Price_List_Line_Tbl_Type;
250 G_MISS_PRICE_LIST_LINE_VAL_TBL Price_List_Line_Val_Tbl_Type;
251 G_MISS_PRICING_ATTR_TBL Pricing_Attr_Tbl_Type;
252
253 -- Start of Comments
254 -- API name Process_Price_List
255 -- Type Public
256 -- Function
257 --
258 -- Pre-reqs
259 --
260 -- Parameters
261 --
262 -- Version Current version = 1.0
263 -- Initial version = 1.0
264 --
265 -- Notes
266 --
267 -- End of Comments
268 /*
269 PROCEDURE Process_Price_List
270 ( p_api_version_number IN NUMBER
271 , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
272 , p_return_values IN VARCHAR2 := FND_API.G_FALSE
273 , p_commit IN VARCHAR2 := FND_API.G_FALSE
274 , x_return_status OUT VARCHAR2
275 , x_msg_count OUT NUMBER
276 , x_msg_data OUT VARCHAR2
277 , p_PRICE_LIST_rec IN Price_List_Rec_Type :=
278 G_MISS_PRICE_LIST_REC
279 , p_PRICE_LIST_val_rec IN Price_List_Val_Rec_Type :=
280 G_MISS_PRICE_LIST_VAL_REC
281 , p_PRICE_LIST_LINE_tbl IN Price_List_Line_Tbl_Type :=
282 G_MISS_PRICE_LIST_LINE_TBL
283 , p_PRICE_LIST_LINE_val_tbl IN Price_List_Line_Val_Tbl_Type :=
284 G_MISS_PRICE_LIST_LINE_VAL_TBL
285 , x_PRICE_LIST_rec OUT Price_List_Rec_Type
286 , x_PRICE_LIST_val_rec OUT Price_List_Val_Rec_Type
287 , x_PRICE_LIST_LINE_tbl OUT Price_List_Line_Tbl_Type
288 , x_PRICE_LIST_LINE_val_tbl OUT Price_List_Line_Val_Tbl_Type
289 );
290
291 -- Start of Comments
292 -- API name Lock_Price_List
293 -- Type Public
294 -- Function
295 --
296 -- Pre-reqs
297 --
298 -- Parameters
299 --
300 -- Version Current version = 1.0
301 -- Initial version = 1.0
302 --
303 -- Notes
304 --
305 -- End of Comments
306
307 PROCEDURE Lock_Price_List
308 ( p_api_version_number IN NUMBER
309 , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
310 , p_return_values IN VARCHAR2 := FND_API.G_FALSE
311 , x_return_status OUT VARCHAR2
312 , x_msg_count OUT NUMBER
313 , x_msg_data OUT VARCHAR2
314 , p_PRICE_LIST_rec IN Price_List_Rec_Type :=
315 G_MISS_PRICE_LIST_REC
316 , p_PRICE_LIST_val_rec IN Price_List_Val_Rec_Type :=
317 G_MISS_PRICE_LIST_VAL_REC
318 , p_PRICE_LIST_LINE_tbl IN Price_List_Line_Tbl_Type :=
319 G_MISS_PRICE_LIST_LINE_TBL
320 , p_PRICE_LIST_LINE_val_tbl IN Price_List_Line_Val_Tbl_Type :=
321 G_MISS_PRICE_LIST_LINE_VAL_TBL
322 , x_PRICE_LIST_rec OUT Price_List_Rec_Type
323 , x_PRICE_LIST_val_rec OUT Price_List_Val_Rec_Type
324 , x_PRICE_LIST_LINE_tbl OUT Price_List_Line_Tbl_Type
325 , x_PRICE_LIST_LINE_val_tbl OUT Price_List_Line_Val_Tbl_Type
326 );
327
328 -- Start of Comments
329 -- API name Get_Price_List
330 -- Type Public
331 -- Function
332 --
333 -- Pre-reqs
334 --
335 -- Parameters
336 --
337 -- Version Current version = 1.0
338 -- Initial version = 1.0
339 --
340 -- Notes
341 --
342 -- End of Comments
343
344 PROCEDURE Get_Price_List
345 ( p_api_version_number IN NUMBER
346 , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
347 , p_return_values IN VARCHAR2 := FND_API.G_FALSE
348 , x_return_status OUT VARCHAR2
349 , x_msg_count OUT NUMBER
350 , x_msg_data OUT VARCHAR2
351 , p_name IN VARCHAR2 :=
352 FND_API.G_MISS_CHAR
353 , p_price_list_id IN NUMBER :=
354 FND_API.G_MISS_NUM
355 , p_price_list IN VARCHAR2 :=
356 FND_API.G_MISS_CHAR
357 , x_PRICE_LIST_rec OUT Price_List_Rec_Type
358 , x_PRICE_LIST_val_rec OUT Price_List_Val_Rec_Type
359 , x_PRICE_LIST_LINE_tbl OUT Price_List_Line_Tbl_Type
360 , x_PRICE_LIST_LINE_val_tbl OUT Price_List_Line_Val_Tbl_Type
361 );
362 */
363
364 END OE_Price_List_PUB;