[Home] [Help]
PACKAGE: APPS.QP_MODIFIERS_PUB
Source
1 PACKAGE QP_Modifiers_PUB AS
2 /* $Header: QPXPMLSS.pls 120.3 2006/02/22 21:48:49 prarasto ship $ */
3 /*#
4 * This package consists of entities to set up modifiers.
5 *
6 * @rep:scope public
7 * @rep:product QP
8 * @rep:displayname Modifier Setup
9 * @rep:category BUSINESS_ENTITY QP_PRICE_MODIFIER
10 */
11
12 -- Modifier_List record type
13 TYPE Modifier_List_Rec_Type IS RECORD
14 ( attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
15 , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
16 , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
17 , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
18 , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
19 , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
20 , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
21 , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
22 , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
23 , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
24 , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
25 , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
26 , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
27 , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
28 , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
29 , automatic_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
30 , comments VARCHAR2(2000) := FND_API.G_MISS_CHAR
31 , context VARCHAR2(30) := FND_API.G_MISS_CHAR
32 , created_by NUMBER := FND_API.G_MISS_NUM
33 , creation_date DATE := FND_API.G_MISS_DATE
34 , currency_code VARCHAR2(30) := FND_API.G_MISS_CHAR
35 , discount_lines_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
36 , end_date_active DATE := FND_API.G_MISS_DATE
37 , freight_terms_code VARCHAR2(30) := FND_API.G_MISS_CHAR
38 , gsa_indicator VARCHAR2(1) := FND_API.G_MISS_CHAR
39 , last_updated_by NUMBER := FND_API.G_MISS_NUM
40 , last_update_date DATE := FND_API.G_MISS_DATE
41 , last_update_login NUMBER := FND_API.G_MISS_NUM
42 , list_header_id NUMBER := FND_API.G_MISS_NUM
43 , list_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
44 , program_application_id NUMBER := FND_API.G_MISS_NUM
45 , program_id NUMBER := FND_API.G_MISS_NUM
46 , program_update_date DATE := FND_API.G_MISS_DATE
47 , prorate_flag VARCHAR2(30) := FND_API.G_MISS_CHAR
48 , request_id NUMBER := FND_API.G_MISS_NUM
49 , rounding_factor NUMBER := FND_API.G_MISS_NUM
50 , ship_method_code VARCHAR2(30) := FND_API.G_MISS_CHAR
51 , start_date_active DATE := FND_API.G_MISS_DATE
52 , terms_id NUMBER := FND_API.G_MISS_NUM
53 , source_system_code VARCHAR2(30) := FND_API.G_MISS_CHAR
54 , active_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
55 , parent_list_header_id NUMBER := FND_API.G_MISS_NUM
56 , start_date_active_first DATE := FND_API.G_MISS_DATE
57 , end_date_active_first DATE := FND_API.G_MISS_DATE
58 , active_date_first_type VARCHAR2(30) := FND_API.G_MISS_CHAR
59 , start_date_active_second DATE := FND_API.G_MISS_DATE
60 , global_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
61 , end_date_active_second DATE := FND_API.G_MISS_DATE
62 , active_date_second_type VARCHAR2(30) := FND_API.G_MISS_CHAR
63 , ask_for_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
64 , name VARCHAR2(240) := FND_API.G_MISS_CHAR
65 , description VARCHAR2(2000) := FND_API.G_MISS_CHAR
66 , version_no VARCHAR2(30) := FND_API.G_MISS_CHAR
67 , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
68 , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
69 , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
70 , pte_code VARCHAR2(30) := FND_API.G_MISS_CHAR
71 , list_source_code VARCHAR2(30) := FND_API.G_MISS_CHAR -- Blanket Pricing
72 , orig_system_header_ref VARCHAR2(50) := FND_API.G_MISS_CHAR -- Blanket Pricing
73 , shareable_flag VARCHAR2(1) := FND_API.G_MISS_CHAR -- Blanket Pricing
74 --added for MOAC support
75 , org_id NUMBER := FND_API.G_MISS_NUM
76 );
77
78
79 TYPE Modifier_List_Tbl_Type IS TABLE OF Modifier_List_Rec_Type
80 INDEX BY BINARY_INTEGER;
81
82 -- Modifier_List value record type
83
84 TYPE Modifier_List_Val_Rec_Type IS RECORD
85 ( automatic VARCHAR2(240) := FND_API.G_MISS_CHAR
86 , currency VARCHAR2(240) := FND_API.G_MISS_CHAR
87 , discount_lines VARCHAR2(240) := FND_API.G_MISS_CHAR
88 , freight_terms VARCHAR2(240) := FND_API.G_MISS_CHAR
89 , list_header VARCHAR2(240) := FND_API.G_MISS_CHAR
90 , list_type VARCHAR2(240) := FND_API.G_MISS_CHAR
91 , prorate VARCHAR2(240) := FND_API.G_MISS_CHAR
92 , ship_method VARCHAR2(240) := FND_API.G_MISS_CHAR
93 , terms VARCHAR2(240) := FND_API.G_MISS_CHAR
94 , list_source_code VARCHAR2(240) := FND_API.G_MISS_CHAR -- Blanket Pricing
95 );
96
97 TYPE Modifier_List_Val_Tbl_Type IS TABLE OF Modifier_List_Val_Rec_Type
98 INDEX BY BINARY_INTEGER;
99
100 -- Modifiers record type
101
102 TYPE Modifiers_Rec_Type IS RECORD
103 ( arithmetic_operator VARCHAR2(30) := FND_API.G_MISS_CHAR
104 , attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
105 , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
106 , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
107 , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
108 , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
109 , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
110 , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
111 , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
112 , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
113 , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
114 , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
115 , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
116 , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
117 , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
118 , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
119 , automatic_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
120 --, base_qty NUMBER := FND_API.G_MISS_NUM
121 --, base_uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR
122 , comments VARCHAR2(2000) := FND_API.G_MISS_CHAR
123 , context VARCHAR2(30) := FND_API.G_MISS_CHAR
124 , created_by NUMBER := FND_API.G_MISS_NUM
125 , creation_date DATE := FND_API.G_MISS_DATE
126 , effective_period_uom VARCHAR2(3) := FND_API.G_MISS_CHAR
127 , end_date_active DATE := FND_API.G_MISS_DATE
128 , estim_accrual_rate NUMBER := FND_API.G_MISS_NUM
129 , generate_using_formula_id NUMBER := FND_API.G_MISS_NUM
130 --, gl_class_id NUMBER := FND_API.G_MISS_NUM
131 , inventory_item_id NUMBER := FND_API.G_MISS_NUM
132 , last_updated_by NUMBER := FND_API.G_MISS_NUM
133 , last_update_date DATE := FND_API.G_MISS_DATE
134 , last_update_login NUMBER := FND_API.G_MISS_NUM
135 , list_header_id NUMBER := FND_API.G_MISS_NUM
136 , list_line_id NUMBER := FND_API.G_MISS_NUM
137 , list_line_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
138 , list_price NUMBER := FND_API.G_MISS_NUM
139 --, list_price_uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR
140 , modifier_level_code VARCHAR2(30) := FND_API.G_MISS_CHAR
141 --, new_price NUMBER := FND_API.G_MISS_NUM
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_subtype_code VARCHAR2(30) := FND_API.G_MISS_CHAR
155 , rebate_trxn_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
156 , related_item_id NUMBER := FND_API.G_MISS_NUM
157 , relationship_type_id NUMBER := FND_API.G_MISS_NUM
158 , reprice_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
159 , request_id NUMBER := FND_API.G_MISS_NUM
160 , revision VARCHAR2(50) := FND_API.G_MISS_CHAR
161 , revision_date DATE := FND_API.G_MISS_DATE
162 , revision_reason_code VARCHAR2(30) := FND_API.G_MISS_CHAR
163 , start_date_active DATE := FND_API.G_MISS_DATE
164 , substitution_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR
165 , substitution_context VARCHAR2(30) := FND_API.G_MISS_CHAR
166 , substitution_value VARCHAR2(240) := FND_API.G_MISS_CHAR
167 , accrual_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
168 , pricing_group_sequence NUMBER := FND_API.G_MISS_NUM
169 , incompatibility_grp_code VARCHAR2(30) := FND_API.G_MISS_CHAR
170 , list_line_no VARCHAR2(30) := FND_API.G_MISS_CHAR
171 , rltd_modifier_id NUMBER := FND_API.G_MISS_NUM
172 , from_rltd_modifier_id NUMBER := FND_API.G_MISS_NUM
173 , to_rltd_modifier_id NUMBER := FND_API.G_MISS_NUM
174 , rltd_modifier_grp_no NUMBER := FND_API.G_MISS_NUM
175 , rltd_modifier_grp_type VARCHAR2(30) := FND_API.G_MISS_CHAR
176 , pricing_phase_id NUMBER := FND_API.G_MISS_NUM
177 , product_precedence NUMBER := FND_API.G_MISS_NUM
178 , expiration_period_start_date DATE := FND_API.G_MISS_DATE
179 , number_expiration_periods NUMBER := FND_API.G_MISS_NUM
180 , expiration_period_uom VARCHAR2(3) := FND_API.G_MISS_CHAR
181 , expiration_date DATE := FND_API.G_MISS_DATE
182 , estim_gl_value NUMBER := FND_API.G_MISS_NUM
183 , benefit_price_list_line_id NUMBER := FND_API.G_MISS_NUM
184 --, recurring_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
185 , benefit_limit NUMBER := FND_API.G_MISS_NUM
186 , charge_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
187 , charge_subtype_code VARCHAR2(30) := FND_API.G_MISS_CHAR
188 , benefit_qty NUMBER := FND_API.G_MISS_NUM
189 , benefit_uom_code VARCHAR2(30) := FND_API.G_MISS_CHAR
190 , accrual_conversion_rate NUMBER := FND_API.G_MISS_NUM
191 , proration_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
192 , include_on_returns_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
193 , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
194 , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
195 , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
196 , Modifier_parent_index NUMBER := FND_API.G_MISS_NUM
197 , qualification_ind NUMBER := FND_API.G_MISS_NUM
198 , net_amount_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
199 , accum_attribute VARCHAR2(240) := FND_API.G_MISS_CHAR
200 , continuous_price_break_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
201 );
202
203 TYPE Modifiers_Tbl_Type IS TABLE OF Modifiers_Rec_Type
204 INDEX BY BINARY_INTEGER;
205
206 -- Modifiers value record type
207
208 TYPE Modifiers_Val_Rec_Type IS RECORD
209 ( automatic VARCHAR2(240) := FND_API.G_MISS_CHAR
210 , base_uom VARCHAR2(240) := FND_API.G_MISS_CHAR
211 , generate_using_formula VARCHAR2(240) := FND_API.G_MISS_CHAR
212 , gl_class VARCHAR2(240) := FND_API.G_MISS_CHAR
213 , inventory_item VARCHAR2(240) := FND_API.G_MISS_CHAR
214 , list_header VARCHAR2(240) := FND_API.G_MISS_CHAR
215 , list_line VARCHAR2(240) := FND_API.G_MISS_CHAR
216 , list_line_type VARCHAR2(240) := FND_API.G_MISS_CHAR
217 , list_price_uom VARCHAR2(240) := FND_API.G_MISS_CHAR
218 , modifier_level VARCHAR2(240) := FND_API.G_MISS_CHAR
219 , organization VARCHAR2(240) := FND_API.G_MISS_CHAR
220 , override VARCHAR2(240) := FND_API.G_MISS_CHAR
221 , price_break_type VARCHAR2(240) := FND_API.G_MISS_CHAR
222 , price_by_formula VARCHAR2(240) := FND_API.G_MISS_CHAR
223 , primary_uom VARCHAR2(240) := FND_API.G_MISS_CHAR
224 , print_on_invoice VARCHAR2(240) := FND_API.G_MISS_CHAR
225 , rebate_subtype VARCHAR2(240) := FND_API.G_MISS_CHAR
229 , reprice VARCHAR2(240) := FND_API.G_MISS_CHAR
226 , rebate_transaction_type VARCHAR2(240) := FND_API.G_MISS_CHAR
227 , related_item VARCHAR2(240) := FND_API.G_MISS_CHAR
228 , relationship_type VARCHAR2(240) := FND_API.G_MISS_CHAR
230 , revision_reason VARCHAR2(240) := FND_API.G_MISS_CHAR
231 );
232
233 TYPE Modifiers_Val_Tbl_Type IS TABLE OF Modifiers_Val_Rec_Type
234 INDEX BY BINARY_INTEGER;
235
236 -- Qualifiers record type
237 /*
238 TYPE Qualifiers_Rec_Type IS RECORD
239 ( attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
240 , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
241 , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
242 , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
243 , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
244 , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
245 , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
246 , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
247 , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
248 , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
249 , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
250 , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
251 , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
252 , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
253 , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
254 , comparison_operator_code VARCHAR2(30) := FND_API.G_MISS_CHAR
255 , context VARCHAR2(30) := FND_API.G_MISS_CHAR
256 , created_by NUMBER := FND_API.G_MISS_NUM
257 , created_from_rule_id NUMBER := FND_API.G_MISS_NUM
258 , creation_date DATE := FND_API.G_MISS_DATE
259 , end_date_active DATE := FND_API.G_MISS_DATE
260 , excluder_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
261 , last_updated_by NUMBER := FND_API.G_MISS_NUM
262 , last_update_date DATE := FND_API.G_MISS_DATE
263 , last_update_login NUMBER := FND_API.G_MISS_NUM
264 , list_header_id NUMBER := FND_API.G_MISS_NUM
265 , list_line_id NUMBER := FND_API.G_MISS_NUM
266 , program_application_id NUMBER := FND_API.G_MISS_NUM
267 , program_id NUMBER := FND_API.G_MISS_NUM
268 , program_update_date DATE := FND_API.G_MISS_DATE
269 , qualifier_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR
270 , qualifier_attr_value VARCHAR2(240) := FND_API.G_MISS_CHAR
271 , qualifier_attr_value_to VARCHAR2(240) := FND_API.G_MISS_CHAR
272 , qualifier_context VARCHAR2(30) := FND_API.G_MISS_CHAR
273 , qualifier_datatype VARCHAR2(10) := FND_API.G_MISS_CHAR
274 --, qualifier_date_format VARCHAR2(30) := FND_API.G_MISS_CHAR
275 , qualifier_grouping_no NUMBER := FND_API.G_MISS_NUM
276 , qualifier_id NUMBER := FND_API.G_MISS_NUM
277 --, qualifier_number_format VARCHAR2(30) := FND_API.G_MISS_CHAR
278 , qualifier_precedence NUMBER := FND_API.G_MISS_NUM
279 , qualifier_rule_id NUMBER := FND_API.G_MISS_NUM
280 , request_id NUMBER := FND_API.G_MISS_NUM
281 , start_date_active DATE := FND_API.G_MISS_DATE
282 , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
283 , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
284 , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
285 );
286
287 TYPE Qualifiers_Tbl_Type IS TABLE OF Qualifiers_Rec_Type
288 INDEX BY BINARY_INTEGER;
289
290 -- Qualifiers value record type
291
292
293 TYPE Qualifiers_Val_Rec_Type IS RECORD
294 ( created_from_rule VARCHAR2(240) := FND_API.G_MISS_CHAR
295 , list_header VARCHAR2(240) := FND_API.G_MISS_CHAR
296 , list_line VARCHAR2(240) := FND_API.G_MISS_CHAR
297 , qualifier_rule VARCHAR2(240) := FND_API.G_MISS_CHAR
298 );
299
300 TYPE Qualifiers_Val_Tbl_Type IS TABLE OF Qualifiers_Val_Rec_Type
301 INDEX BY BINARY_INTEGER;
302
303 */
304
305
306 -- Pricing_Attr record type
307
308 TYPE Pricing_Attr_Rec_Type IS RECORD
309 ( accumulate_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
310 , attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
311 , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
312 , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
313 , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
314 , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
315 , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
316 , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
317 , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
318 , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
319 , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
320 , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
321 , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
322 , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
326 , context VARCHAR2(30) := FND_API.G_MISS_CHAR
323 , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
324 , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
325 , attribute_grouping_no NUMBER := FND_API.G_MISS_NUM
327 , created_by NUMBER := FND_API.G_MISS_NUM
328 , creation_date DATE := FND_API.G_MISS_DATE
329 , excluder_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
330 , last_updated_by NUMBER := FND_API.G_MISS_NUM
331 , last_update_date DATE := FND_API.G_MISS_DATE
332 , last_update_login NUMBER := FND_API.G_MISS_NUM
333 , list_line_id NUMBER := FND_API.G_MISS_NUM
334 , pricing_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR
335 , pricing_attribute_context VARCHAR2(30) := FND_API.G_MISS_CHAR
336 , pricing_attribute_id NUMBER := FND_API.G_MISS_NUM
337 , pricing_attr_value_from VARCHAR2(240) := FND_API.G_MISS_CHAR
338 , pricing_attr_value_to VARCHAR2(240) := FND_API.G_MISS_CHAR
339 , product_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR
340 , product_attribute_context VARCHAR2(30) := FND_API.G_MISS_CHAR
341 , product_attr_value VARCHAR2(240) := FND_API.G_MISS_CHAR
342 , product_uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR
343 , program_application_id NUMBER := FND_API.G_MISS_NUM
344 , program_id NUMBER := FND_API.G_MISS_NUM
345 , program_update_date DATE := FND_API.G_MISS_DATE
346 , product_attribute_datatype VARCHAR2(30) := FND_API.G_MISS_CHAR
347 , pricing_attribute_datatype VARCHAR2(30) := FND_API.G_MISS_CHAR
348 , comparison_operator_code VARCHAR2(30) := FND_API.G_MISS_CHAR
349 , list_header_id NUMBER := FND_API.G_MISS_NUM
350 , pricing_phase_id NUMBER := FND_API.G_MISS_NUM
351 , request_id NUMBER := FND_API.G_MISS_NUM
352 , pricing_attr_value_from_number NUMBER := FND_API.G_MISS_NUM
353 , pricing_attr_value_to_number NUMBER := FND_API.G_MISS_NUM
354 , qualification_ind NUMBER := FND_API.G_MISS_NUM
355 , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
356 , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
357 , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
358 , MODIFIERS_index NUMBER := FND_API.G_MISS_NUM
359 );
360
361 TYPE Pricing_Attr_Tbl_Type IS TABLE OF Pricing_Attr_Rec_Type
362 INDEX BY BINARY_INTEGER;
363
364 -- Pricing_Attr value record type
365
366 TYPE Pricing_Attr_Val_Rec_Type IS RECORD
367 ( accumulate VARCHAR2(240) := FND_API.G_MISS_CHAR
368 , excluder VARCHAR2(240) := FND_API.G_MISS_CHAR
369 , list_line VARCHAR2(240) := FND_API.G_MISS_CHAR
370 , pricing_attribute_desc VARCHAR2(240) := FND_API.G_MISS_CHAR
371 , pricing_attr_value_from_desc VARCHAR2(240) := FND_API.G_MISS_CHAR
372 , pricing_attr_value_to_desc VARCHAR2(240) := FND_API.G_MISS_CHAR
373 , product_uom VARCHAR2(240) := FND_API.G_MISS_CHAR
374 , list_header VARCHAR2(240) := FND_API.G_MISS_CHAR
375 , pricing_phase VARCHAR2(240) := FND_API.G_MISS_CHAR
376 );
377
378 TYPE Pricing_Attr_Val_Tbl_Type IS TABLE OF Pricing_Attr_Val_Rec_Type
379 INDEX BY BINARY_INTEGER;
380
381 -- Variables representing missing records and tables
382
383 G_MISS_MODIFIER_LIST_REC Modifier_List_Rec_Type;
384 G_MISS_MODIFIER_LIST_VAL_REC Modifier_List_Val_Rec_Type;
385 G_MISS_MODIFIER_LIST_TBL Modifier_List_Tbl_Type;
386 G_MISS_MODIFIER_LIST_VAL_TBL Modifier_List_Val_Tbl_Type;
387 G_MISS_MODIFIERS_REC Modifiers_Rec_Type;
388 G_MISS_MODIFIERS_VAL_REC Modifiers_Val_Rec_Type;
389 G_MISS_MODIFIERS_TBL Modifiers_Tbl_Type;
390 G_MISS_MODIFIERS_VAL_TBL Modifiers_Val_Tbl_Type;
391 G_MISS_QUALIFIERS_REC QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
392 G_MISS_QUALIFIERS_VAL_REC QP_Qualifier_Rules_PUB.Qualifiers_Val_Rec_Type;
393 G_MISS_QUALIFIERS_TBL QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
394 G_MISS_QUALIFIERS_VAL_TBL QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type;
395 G_MISS_PRICING_ATTR_REC Pricing_Attr_Rec_Type;
396 G_MISS_PRICING_ATTR_VAL_REC Pricing_Attr_Val_Rec_Type;
397 G_MISS_PRICING_ATTR_TBL Pricing_Attr_Tbl_Type;
398 G_MISS_PRICING_ATTR_VAL_TBL Pricing_Attr_Val_Tbl_Type;
399
400 -- Start of Comments
401 -- API name Process_Modifiers
402 -- Type Public
403 -- Function
404 --
405 -- Pre-reqs
406 --
407 -- Parameters
408 --
409 -- Version Current version = 1.0
410 -- Initial version = 1.0
411 --
412 -- Notes
413 --
414 -- End of Comments
415
416 /*#
417 * Use this API to create, update, and delete modifiers.
418 *
419 * @param p_api_version_number the api version number
420 * @param p_init_msg_list true or false if there is an initial message list
421 * @param p_return_values true or false if there are return values
422 * @param p_commit true or false if the modifier should be committed
423 * @param x_return_status the return status
424 * @param x_msg_count the message count
425 * @param x_msg_data the message data
426 * @param p_MODIFIER_LIST_rec the input record corresponding to the columns in
427 * the modifier header tables QP_LIST_HEADERS_B and
428 * QP_LIST_HEADERS_TL
432 * @param p_MODIFIERS_val_tbl the input table for the modifier definition values
429 * @param p_MODIFIER_LIST_val_rec the input record for the modifier header values
430 * @param p_MODIFIERS_tbl the input table used to set up multiple modifier lines
431 * by giving multiple modifier definitions
433 * @param p_QUALIFIERS_tbl the input table used to attach multiple qualifiers
434 * either at the header level (modifier list) or at the
435 * line level (modifier) by giving multiple qualifier
436 * definitions
437 * @param p_QUALIFIERS_val_tbl the input table for the qualifier values
438 * @param p_PRICING_ATTR_tbl the input table used to attach multiple pricing
439 * attributes to modifier lines by giving multiple
440 * pricing attribute definitions
441 * @param p_PRICING_ATTR_val_tbl the input table for the pricing attribute
442 * definition values
443 * @param x_MODIFIER_LIST_rec the output record for the modifier list header
444 * definition
445 * @param x_MODIFIER_LIST_val_rec the output record for the modifier list header
446 * values
447 * @param x_MODIFIERS_tbl the output table for the modifier definition
448 * @param x_MODIFIERS_val_tbl the output table for the modifier values
449 * @param x_QUALIFIERS_tbl the output table for the qualifier definition
450 * @param x_QUALIFIERS_val_tbl the output table for the qualifier values
451 * @param x_PRICING_ATTR_tbl the output table for the pricing attribute
452 * definition
453 * @param x_PRICING_ATTR_val_tbl the output table for the pricing attribute
454 * values
455 *
456 * @rep:displayname Process Modifier
457 */
458 PROCEDURE Process_Modifiers
459 ( p_api_version_number IN NUMBER
460 , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
461 , p_return_values IN VARCHAR2 := FND_API.G_FALSE
462 , p_commit IN VARCHAR2 := FND_API.G_FALSE
463 , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
464 , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
465 , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
466 , p_MODIFIER_LIST_rec IN Modifier_List_Rec_Type :=
467 G_MISS_MODIFIER_LIST_REC
468 , p_MODIFIER_LIST_val_rec IN Modifier_List_Val_Rec_Type :=
469 G_MISS_MODIFIER_LIST_VAL_REC
470 , p_MODIFIERS_tbl IN Modifiers_Tbl_Type :=
471 G_MISS_MODIFIERS_TBL
472 , p_MODIFIERS_val_tbl IN Modifiers_Val_Tbl_Type :=
473 G_MISS_MODIFIERS_VAL_TBL
474 , p_QUALIFIERS_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type :=
475 QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_TBL
476 , p_QUALIFIERS_val_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type :=
477 QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_VAL_TBL
478 , p_PRICING_ATTR_tbl IN Pricing_Attr_Tbl_Type :=
479 G_MISS_PRICING_ATTR_TBL
480 , p_PRICING_ATTR_val_tbl IN Pricing_Attr_Val_Tbl_Type :=
481 G_MISS_PRICING_ATTR_VAL_TBL
482 , x_MODIFIER_LIST_rec OUT NOCOPY /* file.sql.39 change */ Modifier_List_Rec_Type
483 , x_MODIFIER_LIST_val_rec OUT NOCOPY /* file.sql.39 change */ Modifier_List_Val_Rec_Type
484 , x_MODIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ Modifiers_Tbl_Type
485 , x_MODIFIERS_val_tbl OUT NOCOPY /* file.sql.39 change */ Modifiers_Val_Tbl_Type
486 , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type
487 , x_QUALIFIERS_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type
488 , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ Pricing_Attr_Tbl_Type
489 , x_PRICING_ATTR_val_tbl OUT NOCOPY /* file.sql.39 change */ Pricing_Attr_Val_Tbl_Type
490 );
491
492 -- Start of Comments
493 -- API name Lock_Modifiers
494 -- Type Public
495 -- Function
496 --
497 -- Pre-reqs
498 --
499 -- Parameters
500 --
501 -- Version Current version = 1.0
502 -- Initial version = 1.0
503 --
504 -- Notes
505 --
506 -- End of Comments
507
508 PROCEDURE Lock_Modifiers
509 ( p_api_version_number IN NUMBER
510 , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
511 , p_return_values IN VARCHAR2 := FND_API.G_FALSE
512 , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
513 , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
514 , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
515 , p_MODIFIER_LIST_rec IN Modifier_List_Rec_Type :=
516 G_MISS_MODIFIER_LIST_REC
517 , p_MODIFIER_LIST_val_rec IN Modifier_List_Val_Rec_Type :=
521 , p_MODIFIERS_val_tbl IN Modifiers_Val_Tbl_Type :=
518 G_MISS_MODIFIER_LIST_VAL_REC
519 , p_MODIFIERS_tbl IN Modifiers_Tbl_Type :=
520 G_MISS_MODIFIERS_TBL
522 G_MISS_MODIFIERS_VAL_TBL
523 , p_QUALIFIERS_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type :=
524 QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_TBL
525 , p_QUALIFIERS_val_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type :=
526 QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_VAL_TBL
527 , p_PRICING_ATTR_tbl IN Pricing_Attr_Tbl_Type :=
528 G_MISS_PRICING_ATTR_TBL
529 , p_PRICING_ATTR_val_tbl IN Pricing_Attr_Val_Tbl_Type :=
530 G_MISS_PRICING_ATTR_VAL_TBL
531 , x_MODIFIER_LIST_rec OUT NOCOPY /* file.sql.39 change */ Modifier_List_Rec_Type
532 , x_MODIFIER_LIST_val_rec OUT NOCOPY /* file.sql.39 change */ Modifier_List_Val_Rec_Type
533 , x_MODIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ Modifiers_Tbl_Type
534 , x_MODIFIERS_val_tbl OUT NOCOPY /* file.sql.39 change */ Modifiers_Val_Tbl_Type
535 , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type
536 , x_QUALIFIERS_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type
537 , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ Pricing_Attr_Tbl_Type
538 , x_PRICING_ATTR_val_tbl OUT NOCOPY /* file.sql.39 change */ Pricing_Attr_Val_Tbl_Type
539 );
540
541 -- Start of Comments
542 -- API name Get_Modifiers
543 -- Type Public
544 -- Function
545 --
546 -- Pre-reqs
547 --
548 -- Parameters
549 --
550 -- Version Current version = 1.0
551 -- Initial version = 1.0
552 --
553 -- Notes
554 --
555 -- End of Comments
556
557 PROCEDURE Get_Modifiers
558 ( p_api_version_number IN NUMBER
559 , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
560 , p_return_values IN VARCHAR2 := FND_API.G_FALSE
561 , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
562 , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
563 , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
564 , p_list_header_id IN NUMBER :=
565 FND_API.G_MISS_NUM
566 , p_list_header IN VARCHAR2 :=
567 FND_API.G_MISS_CHAR
568 , x_MODIFIER_LIST_rec OUT NOCOPY /* file.sql.39 change */ Modifier_List_Rec_Type
569 , x_MODIFIER_LIST_val_rec OUT NOCOPY /* file.sql.39 change */ Modifier_List_Val_Rec_Type
570 , x_MODIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ Modifiers_Tbl_Type
571 , x_MODIFIERS_val_tbl OUT NOCOPY /* file.sql.39 change */ Modifiers_Val_Tbl_Type
572 , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type
573 , x_QUALIFIERS_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type
574 , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ Pricing_Attr_Tbl_Type
575 , x_PRICING_ATTR_val_tbl OUT NOCOPY /* file.sql.39 change */ Pricing_Attr_Val_Tbl_Type
576 );
577
578 END QP_Modifiers_PUB;