[Home] [Help]
PACKAGE: APPS.QP_PRICE_LIST_PUB
Source
1 PACKAGE QP_Price_List_PUB AUTHID CURRENT_USER AS
2 /* $Header: QPXPPRLS.pls 120.5 2006/02/22 10:26:47 shulin ship $ */
3 /*#
4 * This package consists of entities to set up price lists.
5 *
6 * @rep:scope public
7 * @rep:product QP
8 * @rep:displayname Price List Setup
9 * @rep:category BUSINESS_ENTITY QP_PRICE_LIST
10 */
11
12 -- Price_List record type
13
14 TYPE Price_List_Rec_Type IS RECORD
15 ( attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
16 , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
17 , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
18 , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
19 , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
20 , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
21 , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
22 , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
23 , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
24 , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
25 , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
26 , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
27 , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
28 , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
29 , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
30 , automatic_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
31 , comments VARCHAR2(2000) := FND_API.G_MISS_CHAR
32 , context VARCHAR2(30) := FND_API.G_MISS_CHAR
33 , created_by NUMBER := FND_API.G_MISS_NUM
34 , creation_date DATE := FND_API.G_MISS_DATE
35 , currency_code VARCHAR2(30) := FND_API.G_MISS_CHAR
36 , discount_lines_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
37 , end_date_active DATE := FND_API.G_MISS_DATE
38 , freight_terms_code VARCHAR2(30) := FND_API.G_MISS_CHAR
39 , gsa_indicator VARCHAR2(1) := FND_API.G_MISS_CHAR
40 , last_updated_by NUMBER := FND_API.G_MISS_NUM
41 , last_update_date DATE := FND_API.G_MISS_DATE
42 , last_update_login NUMBER := FND_API.G_MISS_NUM
43 , list_header_id NUMBER := FND_API.G_MISS_NUM
44 , list_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
45 , program_application_id NUMBER := FND_API.G_MISS_NUM
46 , program_id NUMBER := FND_API.G_MISS_NUM
47 , program_update_date DATE := FND_API.G_MISS_DATE
48 , prorate_flag VARCHAR2(30) := FND_API.G_MISS_CHAR
49 , request_id NUMBER := FND_API.G_MISS_NUM
50 , rounding_factor NUMBER := FND_API.G_MISS_NUM
51 , ship_method_code VARCHAR2(30) := FND_API.G_MISS_CHAR
52 , start_date_active DATE := FND_API.G_MISS_DATE
53 , terms_id NUMBER := FND_API.G_MISS_NUM
54 , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
55 , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
56 , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
57 , name VARCHAR2(240) := FND_API.G_MISS_CHAR
58 , description VARCHAR2(2000) := FND_API.G_MISS_CHAR
59 , version_no VARCHAR2(30) := FND_API.G_MISS_CHAR
60 , active_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
61 , mobile_download VARCHAR2(1) := FND_API.G_MISS_CHAR -- mkarya for bug 1944882
62 , currency_header_id NUMBER := FND_API.G_MISS_NUM -- Multi-Currency SunilPandey
63 , pte_code VARCHAR2(30) := FND_API.G_MISS_CHAR -- Attribute Manager Giri
64 , list_source_code VARCHAR2(30) := FND_API.G_MISS_CHAR -- Blanket Sales Order, arraghav
65 , orig_system_header_ref VARCHAR2(50) := FND_API.G_MISS_CHAR -- Blanket Sales Order, arraghav
66 , global_flag VARCHAR2(1) := FND_API.G_MISS_CHAR -- Pricing Security , gtippire
67 , source_system_code VARCHAR2(30) := FND_API.G_MISS_CHAR
68 , shareable_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
69 , sold_to_org_id NUMBER := FND_API.G_MISS_NUM
70 , locked_from_list_header_id NUMBER := FND_API.G_MISS_NUM
71 --added for MOAC support
72 , org_id NUMBER := FND_API.G_MISS_NUM
73 );
74
75 TYPE Price_List_Tbl_Type IS TABLE OF Price_List_Rec_Type
76 INDEX BY BINARY_INTEGER;
77
78 -- Price_List value record type
79
80 TYPE Price_List_Val_Rec_Type IS RECORD
81 ( automatic VARCHAR2(240) := FND_API.G_MISS_CHAR
82 , currency VARCHAR2(240) := FND_API.G_MISS_CHAR
83 , discount_lines VARCHAR2(240) := FND_API.G_MISS_CHAR
84 , freight_terms VARCHAR2(240) := FND_API.G_MISS_CHAR
85 , list_header VARCHAR2(240) := FND_API.G_MISS_CHAR
86 , list_type VARCHAR2(240) := FND_API.G_MISS_CHAR
87 , prorate VARCHAR2(240) := FND_API.G_MISS_CHAR
88 , ship_method VARCHAR2(240) := FND_API.G_MISS_CHAR
89 , terms VARCHAR2(240) := FND_API.G_MISS_CHAR
90 , currency_header VARCHAR2(240) := FND_API.G_MISS_CHAR -- Multi-Currency SunilPandey
91 , pte VARCHAR2(240) := FND_API.G_MISS_CHAR -- Attribute Manager Giri
92 , list_source_code VARCHAR2(240) := FND_API.G_MISS_CHAR
93 -- Blanket Sales Order, arraghav
94 , orig_system_header_ref VARCHAR2(240) := FND_API.G_MISS_CHAR
95 -- Blanket Sales Order, arraghav
96 );
97
98 TYPE Price_List_Val_Tbl_Type IS TABLE OF Price_List_Val_Rec_Type
99 INDEX BY BINARY_INTEGER;
100
101 -- Price_List_Line record type
102
103 TYPE Price_List_Line_Rec_Type IS RECORD
104 ( accrual_qty NUMBER := FND_API.G_MISS_NUM
105 , accrual_uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR
106 , arithmetic_operator VARCHAR2(30) := FND_API.G_MISS_CHAR
107 , attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
108 , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
109 , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
110 , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
111 , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
112 , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
113 , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
114 , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
115 , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
116 , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
117 , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
118 , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
119 , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
120 , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
121 , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
122 , automatic_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
123 , base_qty NUMBER := FND_API.G_MISS_NUM
124 , base_uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR
125 , comments VARCHAR2(2000) := FND_API.G_MISS_CHAR
126 , context VARCHAR2(30) := FND_API.G_MISS_CHAR
127 , created_by NUMBER := FND_API.G_MISS_NUM
128 , creation_date DATE := FND_API.G_MISS_DATE
129 , effective_period_uom VARCHAR2(3) := FND_API.G_MISS_CHAR
130 , end_date_active DATE := FND_API.G_MISS_DATE
131 , estim_accrual_rate NUMBER := FND_API.G_MISS_NUM
132 , generate_using_formula_id NUMBER := FND_API.G_MISS_NUM
133 , inventory_item_id NUMBER := FND_API.G_MISS_NUM
134 , last_updated_by NUMBER := FND_API.G_MISS_NUM
135 , last_update_date DATE := FND_API.G_MISS_DATE
136 , last_update_login NUMBER := FND_API.G_MISS_NUM
137 , list_header_id NUMBER := FND_API.G_MISS_NUM
138 , list_line_id NUMBER := FND_API.G_MISS_NUM
139 , list_line_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
140 , list_price NUMBER := FND_API.G_MISS_NUM
141 , modifier_level_code VARCHAR2(30) := FND_API.G_MISS_CHAR
142 , number_effective_periods NUMBER := FND_API.G_MISS_NUM
143 , operand NUMBER := FND_API.G_MISS_NUM
144 , organization_id NUMBER := FND_API.G_MISS_NUM
145 , override_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
146 , percent_price NUMBER := FND_API.G_MISS_NUM
147 , price_break_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
148 , price_by_formula_id NUMBER := FND_API.G_MISS_NUM
149 , primary_uom_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
150 , print_on_invoice_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
151 , program_application_id NUMBER := FND_API.G_MISS_NUM
152 , program_id NUMBER := FND_API.G_MISS_NUM
153 , program_update_date DATE := FND_API.G_MISS_DATE
154 , rebate_trxn_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
155 , related_item_id NUMBER := FND_API.G_MISS_NUM
156 , relationship_type_id NUMBER := FND_API.G_MISS_NUM
157 , reprice_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
158 , request_id NUMBER := FND_API.G_MISS_NUM
159 , revision VARCHAR2(50) := FND_API.G_MISS_CHAR
160 , revision_date DATE := FND_API.G_MISS_DATE
161 , revision_reason_code VARCHAR2(30) := FND_API.G_MISS_CHAR
162 , start_date_active DATE := FND_API.G_MISS_DATE
163 , substitution_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR
164 , substitution_context VARCHAR2(30) := FND_API.G_MISS_CHAR
165 , substitution_value VARCHAR2(240) := FND_API.G_MISS_CHAR
166 , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
167 , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
168 , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
169 , rltd_modifier_id NUMBER := FND_API.G_MISS_NUM
170 , from_rltd_modifier_id NUMBER := FND_API.G_MISS_NUM
171 , to_rltd_modifier_id NUMBER := FND_API.G_MISS_NUM
172 , rltd_modifier_group_no NUMBER := FND_API.G_MISS_NUM
173 , rltd_modifier_grp_type VARCHAR2(30) := FND_API.G_MISS_CHAR
174 , product_precedence NUMBER := FND_API.G_MISS_NUM
175 , PRICE_BREAK_HEADER_index NUMBER := FND_API.G_MISS_NUM
176 , list_line_no VARCHAR2(30) := FND_API.G_MISS_CHAR -- bug 4199398
177 , qualification_ind NUMBER := FND_API.G_MISS_NUM --Euro Bug 2138996.
178 , recurring_value NUMBER := FND_API.G_MISS_NUM -- block pricing
179 , customer_item_id NUMBER := FND_API.G_MISS_NUM
180 , break_uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR -- OKS proration
181 , break_uom_context VARCHAR2(30) := FND_API.G_MISS_CHAR -- OKS proration
182 , break_uom_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR -- OKS proration
183 , continuous_price_break_flag VARCHAR2(1) := FND_API.G_MISS_CHAR -- Continuous Price Breaks
184 );
185
186 TYPE Price_List_Line_Tbl_Type IS TABLE OF Price_List_Line_Rec_Type
187 INDEX BY BINARY_INTEGER;
188
189 -- Price_List_Line value record type
190
191 TYPE Price_List_Line_Val_Rec_Type IS RECORD
192 ( accrual_uom VARCHAR2(240) := FND_API.G_MISS_CHAR
193 , automatic VARCHAR2(240) := FND_API.G_MISS_CHAR
194 , base_uom VARCHAR2(240) := FND_API.G_MISS_CHAR
195 , generate_using_formula VARCHAR2(240) := FND_API.G_MISS_CHAR
196 , inventory_item VARCHAR2(240) := FND_API.G_MISS_CHAR
197 , list_header VARCHAR2(240) := FND_API.G_MISS_CHAR
198 , list_line VARCHAR2(240) := FND_API.G_MISS_CHAR
199 , list_line_type VARCHAR2(240) := FND_API.G_MISS_CHAR
200 , modifier_level VARCHAR2(240) := FND_API.G_MISS_CHAR
201 , organization VARCHAR2(240) := FND_API.G_MISS_CHAR
202 , override VARCHAR2(240) := FND_API.G_MISS_CHAR
203 , price_break_type VARCHAR2(240) := FND_API.G_MISS_CHAR
204 , price_by_formula VARCHAR2(240) := FND_API.G_MISS_CHAR
205 , primary_uom VARCHAR2(240) := FND_API.G_MISS_CHAR
206 , print_on_invoice VARCHAR2(240) := FND_API.G_MISS_CHAR
207 , rebate_transaction_type VARCHAR2(240) := FND_API.G_MISS_CHAR
208 , related_item VARCHAR2(240) := FND_API.G_MISS_CHAR
209 , relationship_type VARCHAR2(240) := FND_API.G_MISS_CHAR
210 , reprice VARCHAR2(240) := FND_API.G_MISS_CHAR
211 , revision_reason VARCHAR2(240) := FND_API.G_MISS_CHAR
212 );
213
214 TYPE Price_List_Line_Val_Tbl_Type IS TABLE OF Price_List_Line_Val_Rec_Type
215 INDEX BY BINARY_INTEGER;
216
217 -- Pricing_Attr record type
218
219 TYPE Pricing_Attr_Rec_Type IS RECORD
220 ( accumulate_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
221 , attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
222 , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
223 , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
224 , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
225 , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
226 , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
227 , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
228 , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
229 , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
230 , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
231 , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
232 , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
233 , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
234 , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
235 , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
236 , attribute_grouping_no NUMBER := FND_API.G_MISS_NUM
237 , context VARCHAR2(30) := FND_API.G_MISS_CHAR
238 , created_by NUMBER := FND_API.G_MISS_NUM
239 , creation_date DATE := FND_API.G_MISS_DATE
240 , excluder_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
241 , last_updated_by NUMBER := FND_API.G_MISS_NUM
242 , last_update_date DATE := FND_API.G_MISS_DATE
243 , last_update_login NUMBER := FND_API.G_MISS_NUM
244 , list_line_id NUMBER := FND_API.G_MISS_NUM
245 , pricing_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR
246 , pricing_attribute_context VARCHAR2(30) := FND_API.G_MISS_CHAR
247 , pricing_attribute_id NUMBER := FND_API.G_MISS_NUM
248 , pricing_attr_value_from VARCHAR2(240) := FND_API.G_MISS_CHAR
249 , pricing_attr_value_to VARCHAR2(240) := FND_API.G_MISS_CHAR
250 , product_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR
251 , product_attribute_context VARCHAR2(30) := FND_API.G_MISS_CHAR
252 , product_attr_value VARCHAR2(240) := FND_API.G_MISS_CHAR
253 , product_uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR
254 , program_application_id NUMBER := FND_API.G_MISS_NUM
255 , program_id NUMBER := FND_API.G_MISS_NUM
256 , program_update_date DATE := FND_API.G_MISS_DATE
257 , request_id NUMBER := FND_API.G_MISS_NUM
258 , pricing_attr_value_from_number NUMBER := FND_API.G_MISS_NUM
259 , pricing_attr_value_to_number NUMBER := FND_API.G_MISS_NUM
260 , qualification_ind NUMBER := FND_API.G_MISS_NUM
261 , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
262 , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
266 , comparison_operator_code VARCHAR2(30) := FND_API.G_MISS_CHAR
263 , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
264 , PRICE_LIST_LINE_index NUMBER := FND_API.G_MISS_NUM
265 , from_rltd_modifier_id NUMBER := FND_API.G_MISS_NUM
267 , product_attribute_datatype VARCHAR2(30) := FND_API.G_MISS_CHAR
268 , pricing_attribute_datatype VARCHAR2(30) := FND_API.G_MISS_CHAR
269 , list_header_id NUMBER := FND_API.G_MISS_NUM
270 , pricing_phase_id NUMBER := FND_API.G_MISS_NUM
271 );
272
273 TYPE Pricing_Attr_Tbl_Type IS TABLE OF Pricing_Attr_Rec_Type
274 INDEX BY BINARY_INTEGER;
275
276 -- Pricing_Attr value record type
277
278 TYPE Pricing_Attr_Val_Rec_Type IS RECORD
279 ( accumulate VARCHAR2(240) := FND_API.G_MISS_CHAR
280 , excluder VARCHAR2(240) := FND_API.G_MISS_CHAR
281 , list_line VARCHAR2(240) := FND_API.G_MISS_CHAR
282 , product_uom VARCHAR2(240) := FND_API.G_MISS_CHAR
283 , pricing_attribute_desc VARCHAR2(240) := FND_API.G_MISS_CHAR
284 , pricing_attr_value_from_desc VARCHAR2(240) := FND_API.G_MISS_CHAR
285 , pricing_attr_value_to_desc VARCHAR2(240) := FND_API.G_MISS_CHAR
286 );
287
288 TYPE Pricing_Attr_Val_Tbl_Type IS TABLE OF Pricing_Attr_Val_Rec_Type
289 INDEX BY BINARY_INTEGER;
290
291 -- Variables representing missing records and tables
292
293 G_MISS_PRICE_LIST_REC Price_List_Rec_Type;
294 G_MISS_PRICE_LIST_VAL_REC Price_List_Val_Rec_Type;
295 G_MISS_PRICE_LIST_TBL Price_List_Tbl_Type;
296 G_MISS_PRICE_LIST_VAL_TBL Price_List_Val_Tbl_Type;
297 G_MISS_PRICE_LIST_LINE_REC Price_List_Line_Rec_Type;
298 G_MISS_PRICE_LIST_LINE_VAL_REC Price_List_Line_Val_Rec_Type;
299 G_MISS_PRICE_LIST_LINE_TBL Price_List_Line_Tbl_Type;
300 G_MISS_PRICE_LIST_LINE_VAL_TBL Price_List_Line_Val_Tbl_Type;
301 G_MISS_QUALIFIERS_REC QP_Qualifier_Rules_Pub.Qualifiers_Rec_Type;
302 G_MISS_QUALIFIERS_VAL_REC QP_Qualifier_Rules_Pub.Qualifiers_Val_Rec_Type;
303 G_MISS_QUALIFIERS_TBL QP_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
304 G_MISS_QUALIFIERS_VAL_TBL QP_Qualifier_Rules_Pub.Qualifiers_Val_Tbl_Type;
305 G_MISS_PRICING_ATTR_REC Pricing_Attr_Rec_Type;
306 G_MISS_PRICING_ATTR_VAL_REC Pricing_Attr_Val_Rec_Type;
307 G_MISS_PRICING_ATTR_TBL Pricing_Attr_Tbl_Type;
308 G_MISS_PRICING_ATTR_VAL_TBL Pricing_Attr_Val_Tbl_Type;
309
310 -- Start of Comments
311 -- API name Process_Price_List
312 -- Type Public
313 -- Function
314 --
315 -- Pre-reqs
316 --
317 -- Parameters
318 --
319 -- Version Current version = 1.0
320 -- Initial version = 1.0
321 --
322 -- Notes
323 --
324 -- End of Comments
325
326 /*#
327 * Use this API to create, update, and delete price lists.
328 *
329 * @param p_api_version_number the api version number
330 * @param p_init_msg_list true or false if there is an initial message list
331 * @param p_return_values true or false if there are return values
332 * @param p_commit true or false if the modifier should be committed
333 * @param x_return_status the return status
334 * @param x_msg_count the message count
335 * @param x_msg_data the message data
336 * @param p_PRICE_LIST_rec the input record corresponding to the columns in the
337 * price list header tables QP_LIST_HEADERS_B and
338 * QP_LIST_HEADERS_TL
339 * @param p_PRICE_LIST_val_rec the input record containing values that store the
340 * meaning of id or code columns in the price list
341 * header table QP_LIST_HEADERS_B
342 * @param p_PRICE_LIST_LINE_tbl the input table for the price list line
343 * definitions
344 * @param p_PRICE_LIST_LINE_val_tbl the input table for the price list line
345 * values
346 * @param p_QUALIFIERS_tbl the input table used to attach multiple qualifiers
347 * either at the header level (modifier list) or at the
348 * line level (modifier) by giving multiple qualifier
349 * definitions
350 * @param p_QUALIFIERS_val_tbl the input table for the qualifier values
351 * @param p_PRICING_ATTR_tbl the input table used to attach multiple pricing
352 * attributes to modifier lines by giving multiple
353 * pricing attribute definitions
354 * @param p_PRICING_ATTR_val_tbl the input table for the pricing attribute
355 * definition values
356 * @param x_PRICE_LIST_rec the output record corresponding to the columns in the
357 * price list header tables QP_LIST_HEADERS_B and
358 * QP_LIST_HEADERS_TL
359 * @param x_PRICE_LIST_val_rec the output record containing values that store the
360 * meaning of id or code columns in the price list
361 * header table QP_LIST_HEADERS_B
362 * @param x_PRICE_LIST_LINE_tbl the output table for the price list line
363 * definitions
364 * @param x_PRICE_LIST_LINE_val_tbl the output table for the price list line
365 * values
366 * @param x_QUALIFIERS_tbl the output table for the qualifier definition
367 * @param x_QUALIFIERS_val_tbl the output table for the qualifier values
368 * @param x_PRICING_ATTR_tbl the output table for the pricing attribute
369 * definition
370 * @param x_PRICING_ATTR_val_tbl the output table for the pricing attribute
371 * values
372 *
373 * @rep:displayname Process Price List
374 */
375 PROCEDURE Process_Price_List
376 ( p_api_version_number IN NUMBER
380 , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
377 , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
378 , p_return_values IN VARCHAR2 := FND_API.G_FALSE
379 , p_commit IN VARCHAR2 := FND_API.G_FALSE
381 , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
382 , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
383 , p_PRICE_LIST_rec IN Price_List_Rec_Type :=
384 G_MISS_PRICE_LIST_REC
385 , p_PRICE_LIST_val_rec IN Price_List_Val_Rec_Type :=
386 G_MISS_PRICE_LIST_VAL_REC
387 , p_PRICE_LIST_LINE_tbl IN Price_List_Line_Tbl_Type :=
388 G_MISS_PRICE_LIST_LINE_TBL
389 , p_PRICE_LIST_LINE_val_tbl IN Price_List_Line_Val_Tbl_Type :=
390 G_MISS_PRICE_LIST_LINE_VAL_TBL
391 , p_QUALIFIERS_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type :=
392 G_MISS_QUALIFIERS_TBL
393 , p_QUALIFIERS_val_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Val_Tbl_Type :=
394 G_MISS_QUALIFIERS_VAL_TBL
395 , p_PRICING_ATTR_tbl IN Pricing_Attr_Tbl_Type :=
396 G_MISS_PRICING_ATTR_TBL
397 , p_PRICING_ATTR_val_tbl IN Pricing_Attr_Val_Tbl_Type :=
398 G_MISS_PRICING_ATTR_VAL_TBL
399 , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ Price_List_Rec_Type
400 , x_PRICE_LIST_val_rec OUT NOCOPY /* file.sql.39 change */ Price_List_Val_Rec_Type
401 , x_PRICE_LIST_LINE_tbl OUT NOCOPY /* file.sql.39 change */ Price_List_Line_Tbl_Type
402 , x_PRICE_LIST_LINE_val_tbl OUT NOCOPY /* file.sql.39 change */ Price_List_Line_Val_Tbl_Type
403 , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type
404 , x_QUALIFIERS_val_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Val_Tbl_Type
405 , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ Pricing_Attr_Tbl_Type
406 , x_PRICING_ATTR_val_tbl OUT NOCOPY /* file.sql.39 change */ Pricing_Attr_Val_Tbl_Type
407 , p_check_duplicate_lines IN VARCHAR2 DEFAULT NULL --5018856, 5024801, 5024919
408
409 );
410
411 -- Start of Comments
412 -- API name Lock_Price_List
413 -- Type Public
414 -- Function
415 --
416 -- Pre-reqs
417 --
418 -- Parameters
419 --
420 -- Version Current version = 1.0
421 -- Initial version = 1.0
422 --
423 -- Notes
424 --
425 -- End of Comments
426
427 PROCEDURE Lock_Price_List
428 ( p_api_version_number IN NUMBER
429 , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
430 , p_return_values IN VARCHAR2 := FND_API.G_FALSE
431 , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
432 , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
433 , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
434 , p_PRICE_LIST_rec IN Price_List_Rec_Type :=
435 G_MISS_PRICE_LIST_REC
436 , p_PRICE_LIST_val_rec IN Price_List_Val_Rec_Type :=
437 G_MISS_PRICE_LIST_VAL_REC
438 , p_PRICE_LIST_LINE_tbl IN Price_List_Line_Tbl_Type :=
439 G_MISS_PRICE_LIST_LINE_TBL
440 , p_PRICE_LIST_LINE_val_tbl IN Price_List_Line_Val_Tbl_Type :=
441 G_MISS_PRICE_LIST_LINE_VAL_TBL
442 , p_QUALIFIERS_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type :=
443 G_MISS_QUALIFIERS_TBL
444 , p_QUALIFIERS_val_tbl IN Qp_Qualifier_Rules_Pub.Qualifiers_Val_Tbl_Type :=
445 G_MISS_QUALIFIERS_VAL_TBL
446 , p_PRICING_ATTR_tbl IN Pricing_Attr_Tbl_Type :=
447 G_MISS_PRICING_ATTR_TBL
448 , p_PRICING_ATTR_val_tbl IN Pricing_Attr_Val_Tbl_Type :=
449 G_MISS_PRICING_ATTR_VAL_TBL
450 , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ Price_List_Rec_Type
451 , x_PRICE_LIST_val_rec OUT NOCOPY /* file.sql.39 change */ Price_List_Val_Rec_Type
452 , x_PRICE_LIST_LINE_tbl OUT NOCOPY /* file.sql.39 change */ Price_List_Line_Tbl_Type
453 , x_PRICE_LIST_LINE_val_tbl OUT NOCOPY /* file.sql.39 change */ Price_List_Line_Val_Tbl_Type
454 , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type
455 , x_QUALIFIERS_val_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Val_Tbl_Type
456 , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ Pricing_Attr_Tbl_Type
457 , x_PRICING_ATTR_val_tbl OUT NOCOPY /* file.sql.39 change */ Pricing_Attr_Val_Tbl_Type
458 );
459
460 -- Start of Comments
461 -- API name Get_Price_List
462 -- Type Public
463 -- Function
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_Price_List
477 ( p_api_version_number IN NUMBER
481 , x_msg_count OUT NOCOPY /* file.sql.39 change */ 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
482 , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
483 , p_list_header_id IN NUMBER :=
484 FND_API.G_MISS_NUM
485 , p_list_header IN VARCHAR2 :=
486 FND_API.G_MISS_CHAR
487 , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ Price_List_Rec_Type
491 , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type
492 , x_QUALIFIERS_val_tbl OUT NOCOPY /* file.sql.39 change */ Qp_Qualifier_Rules_Pub.Qualifiers_Val_Tbl_Type
493 , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ Pricing_Attr_Tbl_Type
494 , x_PRICING_ATTR_val_tbl OUT NOCOPY /* file.sql.39 change */ Pricing_Attr_Val_Tbl_Type
495 );
496
497 END QP_Price_List_PUB;
490 , x_PRICE_LIST_LINE_val_tbl OUT NOCOPY /* file.sql.39 change */ Price_List_Line_Val_Tbl_Type
488 , x_PRICE_LIST_val_rec OUT NOCOPY /* file.sql.39 change */ Price_List_Val_Rec_Type
489 , x_PRICE_LIST_LINE_tbl OUT NOCOPY /* file.sql.39 change */ Price_List_Line_Tbl_Type