[Home] [Help]
PACKAGE: APPS.QP_MODIFIERS_PUB
Source
1 PACKAGE QP_Modifiers_PUB AUTHID CURRENT_USER AS
2 /* $Header: QPXPMLSS.pls 120.3.12020000.2 2013/01/31 18:31:10 jputta 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
203
200 , continuous_price_break_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
201 , service_duration NUMBER := FND_API.G_MISS_NUM -- service project
202 , service_period VARCHAR2(3) := FND_API.G_MISS_CHAR -- service project
204 );
205
206 TYPE Modifiers_Tbl_Type IS TABLE OF Modifiers_Rec_Type
207 INDEX BY BINARY_INTEGER;
208
209 -- Modifiers value record type
210
211 TYPE Modifiers_Val_Rec_Type IS RECORD
212 ( automatic VARCHAR2(240) := FND_API.G_MISS_CHAR
213 , base_uom VARCHAR2(240) := FND_API.G_MISS_CHAR
214 , generate_using_formula VARCHAR2(240) := FND_API.G_MISS_CHAR
215 , gl_class VARCHAR2(240) := FND_API.G_MISS_CHAR
216 , inventory_item VARCHAR2(240) := FND_API.G_MISS_CHAR
217 , list_header VARCHAR2(240) := FND_API.G_MISS_CHAR
218 , list_line VARCHAR2(240) := FND_API.G_MISS_CHAR
219 , list_line_type VARCHAR2(240) := FND_API.G_MISS_CHAR
220 , list_price_uom VARCHAR2(240) := FND_API.G_MISS_CHAR
221 , modifier_level VARCHAR2(240) := FND_API.G_MISS_CHAR
222 , organization VARCHAR2(240) := FND_API.G_MISS_CHAR
223 , override VARCHAR2(240) := FND_API.G_MISS_CHAR
224 , price_break_type VARCHAR2(240) := FND_API.G_MISS_CHAR
225 , price_by_formula VARCHAR2(240) := FND_API.G_MISS_CHAR
226 , primary_uom VARCHAR2(240) := FND_API.G_MISS_CHAR
227 , print_on_invoice VARCHAR2(240) := FND_API.G_MISS_CHAR
228 , rebate_subtype VARCHAR2(240) := FND_API.G_MISS_CHAR
229 , rebate_transaction_type VARCHAR2(240) := FND_API.G_MISS_CHAR
230 , related_item VARCHAR2(240) := FND_API.G_MISS_CHAR
231 , relationship_type VARCHAR2(240) := FND_API.G_MISS_CHAR
232 , reprice VARCHAR2(240) := FND_API.G_MISS_CHAR
233 , revision_reason VARCHAR2(240) := FND_API.G_MISS_CHAR
234 );
235
236 TYPE Modifiers_Val_Tbl_Type IS TABLE OF Modifiers_Val_Rec_Type
237 INDEX BY BINARY_INTEGER;
238
239 -- Qualifiers record type
240 /*
241 TYPE Qualifiers_Rec_Type IS RECORD
242 ( attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
243 , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
244 , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
245 , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
246 , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
247 , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
248 , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
249 , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
250 , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
251 , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
252 , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
253 , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
254 , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
255 , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
256 , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
257 , comparison_operator_code VARCHAR2(30) := FND_API.G_MISS_CHAR
258 , context VARCHAR2(30) := FND_API.G_MISS_CHAR
259 , created_by NUMBER := FND_API.G_MISS_NUM
260 , created_from_rule_id NUMBER := FND_API.G_MISS_NUM
261 , creation_date DATE := FND_API.G_MISS_DATE
262 , end_date_active DATE := FND_API.G_MISS_DATE
263 , excluder_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
264 , last_updated_by NUMBER := FND_API.G_MISS_NUM
265 , last_update_date DATE := FND_API.G_MISS_DATE
266 , last_update_login NUMBER := FND_API.G_MISS_NUM
267 , list_header_id NUMBER := FND_API.G_MISS_NUM
268 , list_line_id NUMBER := FND_API.G_MISS_NUM
269 , program_application_id NUMBER := FND_API.G_MISS_NUM
270 , program_id NUMBER := FND_API.G_MISS_NUM
271 , program_update_date DATE := FND_API.G_MISS_DATE
272 , qualifier_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR
273 , qualifier_attr_value VARCHAR2(240) := FND_API.G_MISS_CHAR
274 , qualifier_attr_value_to VARCHAR2(240) := FND_API.G_MISS_CHAR
275 , qualifier_context VARCHAR2(30) := FND_API.G_MISS_CHAR
276 , qualifier_datatype VARCHAR2(10) := FND_API.G_MISS_CHAR
277 --, qualifier_date_format VARCHAR2(30) := FND_API.G_MISS_CHAR
278 , qualifier_grouping_no NUMBER := FND_API.G_MISS_NUM
279 , qualifier_id NUMBER := FND_API.G_MISS_NUM
280 --, qualifier_number_format VARCHAR2(30) := FND_API.G_MISS_CHAR
281 , qualifier_precedence NUMBER := FND_API.G_MISS_NUM
282 , qualifier_rule_id NUMBER := FND_API.G_MISS_NUM
283 , request_id NUMBER := FND_API.G_MISS_NUM
284 , start_date_active DATE := FND_API.G_MISS_DATE
285 , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
286 , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
287 , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
288 );
289
290 TYPE Qualifiers_Tbl_Type IS TABLE OF Qualifiers_Rec_Type
291 INDEX BY BINARY_INTEGER;
292
293 -- Qualifiers value record type
294
295
296 TYPE Qualifiers_Val_Rec_Type IS RECORD
297 ( created_from_rule VARCHAR2(240) := FND_API.G_MISS_CHAR
298 , list_header VARCHAR2(240) := FND_API.G_MISS_CHAR
302
299 , list_line VARCHAR2(240) := FND_API.G_MISS_CHAR
300 , qualifier_rule VARCHAR2(240) := FND_API.G_MISS_CHAR
301 );
303 TYPE Qualifiers_Val_Tbl_Type IS TABLE OF Qualifiers_Val_Rec_Type
304 INDEX BY BINARY_INTEGER;
305
306 */
307
308
309 -- Pricing_Attr record type
310
311 TYPE Pricing_Attr_Rec_Type IS RECORD
312 ( accumulate_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
313 , attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
314 , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
315 , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
316 , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
317 , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
318 , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
319 , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
320 , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
321 , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
322 , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
323 , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
324 , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
325 , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
326 , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
327 , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
328 , attribute_grouping_no NUMBER := FND_API.G_MISS_NUM
329 , context VARCHAR2(30) := FND_API.G_MISS_CHAR
330 , created_by NUMBER := FND_API.G_MISS_NUM
331 , creation_date DATE := FND_API.G_MISS_DATE
332 , excluder_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
333 , last_updated_by NUMBER := FND_API.G_MISS_NUM
334 , last_update_date DATE := FND_API.G_MISS_DATE
335 , last_update_login NUMBER := FND_API.G_MISS_NUM
336 , list_line_id NUMBER := FND_API.G_MISS_NUM
337 , pricing_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR
338 , pricing_attribute_context VARCHAR2(30) := FND_API.G_MISS_CHAR
339 , pricing_attribute_id NUMBER := FND_API.G_MISS_NUM
340 , pricing_attr_value_from VARCHAR2(240) := FND_API.G_MISS_CHAR
341 , pricing_attr_value_to VARCHAR2(240) := FND_API.G_MISS_CHAR
342 , product_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR
343 , product_attribute_context VARCHAR2(30) := FND_API.G_MISS_CHAR
344 , product_attr_value VARCHAR2(240) := FND_API.G_MISS_CHAR
345 , product_uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR
346 , program_application_id NUMBER := FND_API.G_MISS_NUM
347 , program_id NUMBER := FND_API.G_MISS_NUM
348 , program_update_date DATE := FND_API.G_MISS_DATE
349 , product_attribute_datatype VARCHAR2(30) := FND_API.G_MISS_CHAR
350 , pricing_attribute_datatype VARCHAR2(30) := FND_API.G_MISS_CHAR
351 , comparison_operator_code VARCHAR2(30) := FND_API.G_MISS_CHAR
352 , list_header_id NUMBER := FND_API.G_MISS_NUM
353 , pricing_phase_id NUMBER := FND_API.G_MISS_NUM
354 , request_id NUMBER := FND_API.G_MISS_NUM
355 , pricing_attr_value_from_number NUMBER := FND_API.G_MISS_NUM
356 , pricing_attr_value_to_number NUMBER := FND_API.G_MISS_NUM
357 , qualification_ind NUMBER := FND_API.G_MISS_NUM
358 , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
359 , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
360 , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
361 , MODIFIERS_index NUMBER := FND_API.G_MISS_NUM
362 );
363
364 TYPE Pricing_Attr_Tbl_Type IS TABLE OF Pricing_Attr_Rec_Type
365 INDEX BY BINARY_INTEGER;
366
367 -- Pricing_Attr value record type
368
369 TYPE Pricing_Attr_Val_Rec_Type IS RECORD
370 ( accumulate VARCHAR2(240) := FND_API.G_MISS_CHAR
371 , excluder VARCHAR2(240) := FND_API.G_MISS_CHAR
372 , list_line VARCHAR2(240) := FND_API.G_MISS_CHAR
373 , pricing_attribute_desc VARCHAR2(240) := FND_API.G_MISS_CHAR
374 , pricing_attr_value_from_desc VARCHAR2(240) := FND_API.G_MISS_CHAR
375 , pricing_attr_value_to_desc VARCHAR2(240) := FND_API.G_MISS_CHAR
376 , product_uom VARCHAR2(240) := FND_API.G_MISS_CHAR
377 , list_header VARCHAR2(240) := FND_API.G_MISS_CHAR
378 , pricing_phase VARCHAR2(240) := FND_API.G_MISS_CHAR
379 );
380
381 TYPE Pricing_Attr_Val_Tbl_Type IS TABLE OF Pricing_Attr_Val_Rec_Type
382 INDEX BY BINARY_INTEGER;
383
384 -- Variables representing missing records and tables
385
386 G_MISS_MODIFIER_LIST_REC Modifier_List_Rec_Type;
387 G_MISS_MODIFIER_LIST_VAL_REC Modifier_List_Val_Rec_Type;
388 G_MISS_MODIFIER_LIST_TBL Modifier_List_Tbl_Type;
389 G_MISS_MODIFIER_LIST_VAL_TBL Modifier_List_Val_Tbl_Type;
390 G_MISS_MODIFIERS_REC Modifiers_Rec_Type;
391 G_MISS_MODIFIERS_VAL_REC Modifiers_Val_Rec_Type;
392 G_MISS_MODIFIERS_TBL Modifiers_Tbl_Type;
393 G_MISS_MODIFIERS_VAL_TBL Modifiers_Val_Tbl_Type;
394 G_MISS_QUALIFIERS_REC QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
395 G_MISS_QUALIFIERS_VAL_REC QP_Qualifier_Rules_PUB.Qualifiers_Val_Rec_Type;
396 G_MISS_QUALIFIERS_TBL QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
397 G_MISS_QUALIFIERS_VAL_TBL QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type;
398 G_MISS_PRICING_ATTR_REC Pricing_Attr_Rec_Type;
399 G_MISS_PRICING_ATTR_VAL_REC Pricing_Attr_Val_Rec_Type;
400 G_MISS_PRICING_ATTR_TBL Pricing_Attr_Tbl_Type;
404 -- API name Process_Modifiers
401 G_MISS_PRICING_ATTR_VAL_TBL Pricing_Attr_Val_Tbl_Type;
402
403 -- Start of Comments
405 -- Type Public
406 -- Function
407 --
408 -- Pre-reqs
409 --
410 -- Parameters
411 --
412 -- Version Current version = 1.0
413 -- Initial version = 1.0
414 --
415 -- Notes
416 --
417 -- End of Comments
418
419 /*#
420 * Use this API to create, update, and delete modifiers.
421 *
422 * @param p_api_version_number the api version number
423 * @param p_init_msg_list true or false if there is an initial message list
424 * @param p_return_values true or false if there are return values
425 * @param p_commit true or false if the modifier should be committed
426 * @param x_return_status the return status
427 * @param x_msg_count the message count
428 * @param x_msg_data the message data
429 * @param p_MODIFIER_LIST_rec the input record corresponding to the columns in
430 * the modifier header tables QP_LIST_HEADERS_B and
431 * QP_LIST_HEADERS_TL
432 * @param p_MODIFIER_LIST_val_rec the input record for the modifier header values
433 * @param p_MODIFIERS_tbl the input table used to set up multiple modifier lines
434 * by giving multiple modifier definitions
435 * @param p_MODIFIERS_val_tbl the input table for the modifier definition values
436 * @param p_QUALIFIERS_tbl the input table used to attach multiple qualifiers
437 * either at the header level (modifier list) or at the
438 * line level (modifier) by giving multiple qualifier
439 * definitions
440 * @param p_QUALIFIERS_val_tbl the input table for the qualifier values
441 * @param p_PRICING_ATTR_tbl the input table used to attach multiple pricing
442 * attributes to modifier lines by giving multiple
443 * pricing attribute definitions
444 * @param p_PRICING_ATTR_val_tbl the input table for the pricing attribute
445 * definition values
446 * @param x_MODIFIER_LIST_rec the output record for the modifier list header
447 * definition
448 * @param x_MODIFIER_LIST_val_rec the output record for the modifier list header
449 * values
450 * @param x_MODIFIERS_tbl the output table for the modifier definition
451 * @param x_MODIFIERS_val_tbl the output table for the modifier values
452 * @param x_QUALIFIERS_tbl the output table for the qualifier definition
453 * @param x_QUALIFIERS_val_tbl the output table for the qualifier values
454 * @param x_PRICING_ATTR_tbl the output table for the pricing attribute
455 * definition
456 * @param x_PRICING_ATTR_val_tbl the output table for the pricing attribute
457 * values
458 *
459 * @rep:displayname Process Modifier
460 */
461 PROCEDURE Process_Modifiers
462 ( p_api_version_number IN NUMBER
463 , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
464 , p_return_values IN VARCHAR2 := FND_API.G_FALSE
465 , p_commit IN VARCHAR2 := FND_API.G_FALSE
466 , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
467 , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
468 , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
469 , p_MODIFIER_LIST_rec IN Modifier_List_Rec_Type :=
470 G_MISS_MODIFIER_LIST_REC
471 , p_MODIFIER_LIST_val_rec IN Modifier_List_Val_Rec_Type :=
472 G_MISS_MODIFIER_LIST_VAL_REC
473 , p_MODIFIERS_tbl IN Modifiers_Tbl_Type :=
474 G_MISS_MODIFIERS_TBL
475 , p_MODIFIERS_val_tbl IN Modifiers_Val_Tbl_Type :=
476 G_MISS_MODIFIERS_VAL_TBL
477 , p_QUALIFIERS_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type :=
478 QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_TBL
479 , p_QUALIFIERS_val_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type :=
480 QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_VAL_TBL
481 , p_PRICING_ATTR_tbl IN Pricing_Attr_Tbl_Type :=
482 G_MISS_PRICING_ATTR_TBL
483 , p_PRICING_ATTR_val_tbl IN Pricing_Attr_Val_Tbl_Type :=
484 G_MISS_PRICING_ATTR_VAL_TBL
485 , x_MODIFIER_LIST_rec OUT NOCOPY /* file.sql.39 change */ Modifier_List_Rec_Type
486 , x_MODIFIER_LIST_val_rec OUT NOCOPY /* file.sql.39 change */ Modifier_List_Val_Rec_Type
487 , x_MODIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ Modifiers_Tbl_Type
488 , x_MODIFIERS_val_tbl OUT NOCOPY /* file.sql.39 change */ Modifiers_Val_Tbl_Type
489 , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type
490 , x_QUALIFIERS_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type
491 , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ Pricing_Attr_Tbl_Type
492 , x_PRICING_ATTR_val_tbl OUT NOCOPY /* file.sql.39 change */ Pricing_Attr_Val_Tbl_Type
493 );
494
495 -- Start of Comments
496 -- API name Lock_Modifiers
497 -- Type Public
498 -- Function
499 --
500 -- Pre-reqs
501 --
502 -- Parameters
503 --
504 -- Version Current version = 1.0
505 -- Initial version = 1.0
506 --
507 -- Notes
508 --
509 -- End of Comments
510
511 PROCEDURE Lock_Modifiers
512 ( p_api_version_number IN NUMBER
513 , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
514 , p_return_values IN VARCHAR2 := FND_API.G_FALSE
515 , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
519 G_MISS_MODIFIER_LIST_REC
516 , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
517 , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
518 , p_MODIFIER_LIST_rec IN Modifier_List_Rec_Type :=
520 , p_MODIFIER_LIST_val_rec IN Modifier_List_Val_Rec_Type :=
521 G_MISS_MODIFIER_LIST_VAL_REC
522 , p_MODIFIERS_tbl IN Modifiers_Tbl_Type :=
523 G_MISS_MODIFIERS_TBL
524 , p_MODIFIERS_val_tbl IN Modifiers_Val_Tbl_Type :=
525 G_MISS_MODIFIERS_VAL_TBL
526 , p_QUALIFIERS_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type :=
527 QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_TBL
528 , p_QUALIFIERS_val_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type :=
529 QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_VAL_TBL
530 , p_PRICING_ATTR_tbl IN Pricing_Attr_Tbl_Type :=
531 G_MISS_PRICING_ATTR_TBL
532 , p_PRICING_ATTR_val_tbl IN Pricing_Attr_Val_Tbl_Type :=
533 G_MISS_PRICING_ATTR_VAL_TBL
534 , x_MODIFIER_LIST_rec OUT NOCOPY /* file.sql.39 change */ Modifier_List_Rec_Type
535 , x_MODIFIER_LIST_val_rec OUT NOCOPY /* file.sql.39 change */ Modifier_List_Val_Rec_Type
536 , x_MODIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ Modifiers_Tbl_Type
537 , x_MODIFIERS_val_tbl OUT NOCOPY /* file.sql.39 change */ Modifiers_Val_Tbl_Type
538 , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type
539 , x_QUALIFIERS_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type
540 , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ Pricing_Attr_Tbl_Type
541 , x_PRICING_ATTR_val_tbl OUT NOCOPY /* file.sql.39 change */ Pricing_Attr_Val_Tbl_Type
542 );
543
544 -- Start of Comments
545 -- API name Get_Modifiers
546 -- Type Public
547 -- Function
548 --
549 -- Pre-reqs
550 --
551 -- Parameters
552 --
553 -- Version Current version = 1.0
554 -- Initial version = 1.0
555 --
556 -- Notes
557 --
558 -- End of Comments
559
560 PROCEDURE Get_Modifiers
561 ( p_api_version_number IN NUMBER
562 , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
563 , p_return_values IN VARCHAR2 := FND_API.G_FALSE
564 , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
565 , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
566 , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
567 , p_list_header_id IN NUMBER :=
568 FND_API.G_MISS_NUM
569 , p_list_header IN VARCHAR2 :=
570 FND_API.G_MISS_CHAR
571 , x_MODIFIER_LIST_rec OUT NOCOPY /* file.sql.39 change */ Modifier_List_Rec_Type
572 , x_MODIFIER_LIST_val_rec OUT NOCOPY /* file.sql.39 change */ Modifier_List_Val_Rec_Type
573 , x_MODIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ Modifiers_Tbl_Type
574 , x_MODIFIERS_val_tbl OUT NOCOPY /* file.sql.39 change */ Modifiers_Val_Tbl_Type
575 , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type
576 , x_QUALIFIERS_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type
577 , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ Pricing_Attr_Tbl_Type
578 , x_PRICING_ATTR_val_tbl OUT NOCOPY /* file.sql.39 change */ Pricing_Attr_Val_Tbl_Type
579 );
580
581 END QP_Modifiers_PUB;