[Home] [Help]
PACKAGE: APPS.QP_MODIFIERS_GRP
Source
1 PACKAGE QP_Modifiers_GRP AUTHID CURRENT_USER AS
2 /* $Header: QPXGMLSS.pls 120.1 2005/06/10 00:40:19 appldev $ */
3
4 -- Modifier_List record type
5
6 /*
7 TYPE Modifier_List_Rec_Type IS RECORD
8 ( attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
9 , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
10 , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
11 , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
12 , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
13 , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
14 , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
15 , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
16 , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
17 , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
18 , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
19 , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
20 , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
21 , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
22 , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
23 , automatic_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
24 , comments VARCHAR2(2000) := FND_API.G_MISS_CHAR
25 , context VARCHAR2(30) := FND_API.G_MISS_CHAR
26 , created_by NUMBER := FND_API.G_MISS_NUM
27 , creation_date DATE := FND_API.G_MISS_DATE
28 , currency_code VARCHAR2(30) := FND_API.G_MISS_CHAR
29 , discount_lines_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
30 , end_date_active DATE := FND_API.G_MISS_DATE
31 , freight_terms_code VARCHAR2(30) := FND_API.G_MISS_CHAR
32 , gsa_indicator VARCHAR2(1) := FND_API.G_MISS_CHAR
33 , last_updated_by NUMBER := FND_API.G_MISS_NUM
34 , last_update_date DATE := FND_API.G_MISS_DATE
35 , last_update_login NUMBER := FND_API.G_MISS_NUM
36 , list_header_id NUMBER := FND_API.G_MISS_NUM
37 , list_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
38 , program_application_id NUMBER := FND_API.G_MISS_NUM
39 , program_id NUMBER := FND_API.G_MISS_NUM
40 , program_update_date DATE := FND_API.G_MISS_DATE
41 , prorate_flag VARCHAR2(30) := FND_API.G_MISS_CHAR
42 , request_id NUMBER := FND_API.G_MISS_NUM
43 , rounding_factor NUMBER := FND_API.G_MISS_NUM
44 , ship_method_code VARCHAR2(30) := FND_API.G_MISS_CHAR
45 , start_date_active DATE := FND_API.G_MISS_DATE
46 , terms_id NUMBER := FND_API.G_MISS_NUM
47 , source_system_code VARCHAR2(30) := FND_API.G_MISS_CHAR
48 , active_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
49 , parent_list_header_id NUMBER := FND_API.G_MISS_NUM
50 , start_date_active_first DATE := FND_API.G_MISS_DATE
51 , end_date_active_first DATE := FND_API.G_MISS_DATE
52 , active_date_first_type VARCHAR2(30) := FND_API.G_MISS_CHAR
53 , start_date_active_second DATE := FND_API.G_MISS_DATE
54 , end_date_active_second DATE := FND_API.G_MISS_DATE
55 , active_date_second_type VARCHAR2(30) := FND_API.G_MISS_CHAR
56 , ask_for_flag VARCHAR2(1) := 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 , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
61 , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
62 , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
63 );
64
65
66 TYPE Modifier_List_Tbl_Type IS TABLE OF Modifier_List_Rec_Type
67 INDEX BY BINARY_INTEGER;
68
69 -- Modifier_List value record type
70
71 TYPE Modifier_List_Val_Rec_Type IS RECORD
72 ( automatic VARCHAR2(240) := FND_API.G_MISS_CHAR
73 , currency VARCHAR2(240) := FND_API.G_MISS_CHAR
74 , discount_lines VARCHAR2(240) := FND_API.G_MISS_CHAR
75 , freight_terms VARCHAR2(240) := FND_API.G_MISS_CHAR
76 , list_header VARCHAR2(240) := FND_API.G_MISS_CHAR
77 , list_type VARCHAR2(240) := FND_API.G_MISS_CHAR
78 , prorate VARCHAR2(240) := FND_API.G_MISS_CHAR
79 , ship_method VARCHAR2(240) := FND_API.G_MISS_CHAR
80 , terms VARCHAR2(240) := FND_API.G_MISS_CHAR
81 );
82
83 TYPE Modifier_List_Val_Tbl_Type IS TABLE OF Modifier_List_Val_Rec_Type
84 INDEX BY BINARY_INTEGER;
85
86 -- Modifiers record type
87
88 TYPE Modifiers_Rec_Type IS RECORD
89 ( arithmetic_operator VARCHAR2(30) := FND_API.G_MISS_CHAR
90 , attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
91 , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
92 , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
93 , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
94 , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
95 , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
96 , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
97 , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
98 , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
99 , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
100 , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
101 , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
102 , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
103 , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
104 , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
105 , automatic_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
106 --, base_qty NUMBER := FND_API.G_MISS_NUM
107 --, base_uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR
108 , comments VARCHAR2(2000) := FND_API.G_MISS_CHAR
109 , context VARCHAR2(30) := FND_API.G_MISS_CHAR
110 , created_by NUMBER := FND_API.G_MISS_NUM
111 , creation_date DATE := FND_API.G_MISS_DATE
112 , effective_period_uom VARCHAR2(3) := FND_API.G_MISS_CHAR
113 , end_date_active DATE := FND_API.G_MISS_DATE
114 , estim_accrual_rate NUMBER := FND_API.G_MISS_NUM
115 , generate_using_formula_id NUMBER := FND_API.G_MISS_NUM
116 --, gl_class_id NUMBER := FND_API.G_MISS_NUM
117 , inventory_item_id NUMBER := FND_API.G_MISS_NUM
118 , last_updated_by NUMBER := FND_API.G_MISS_NUM
119 , last_update_date DATE := FND_API.G_MISS_DATE
120 , last_update_login NUMBER := FND_API.G_MISS_NUM
121 , list_header_id NUMBER := FND_API.G_MISS_NUM
122 , list_line_id NUMBER := FND_API.G_MISS_NUM
123 , list_line_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
124 , list_price NUMBER := FND_API.G_MISS_NUM
125 --, list_price_uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR
126 , modifier_level_code VARCHAR2(30) := FND_API.G_MISS_CHAR
127 --, new_price NUMBER := FND_API.G_MISS_NUM
128 , number_effective_periods NUMBER := FND_API.G_MISS_NUM
129 , operand NUMBER := FND_API.G_MISS_NUM
130 , organization_id NUMBER := FND_API.G_MISS_NUM
131 , override_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
132 , percent_price NUMBER := FND_API.G_MISS_NUM
133 , price_break_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
134 , price_by_formula_id NUMBER := FND_API.G_MISS_NUM
135 , primary_uom_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
136 , print_on_invoice_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
137 , program_application_id NUMBER := FND_API.G_MISS_NUM
138 , program_id NUMBER := FND_API.G_MISS_NUM
139 , program_update_date DATE := FND_API.G_MISS_DATE
140 --, rebate_subtype_code VARCHAR2(30) := FND_API.G_MISS_CHAR
141 , rebate_trxn_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
142 , related_item_id NUMBER := FND_API.G_MISS_NUM
143 , relationship_type_id NUMBER := FND_API.G_MISS_NUM
144 , reprice_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
145 , request_id NUMBER := FND_API.G_MISS_NUM
146 , revision VARCHAR2(50) := FND_API.G_MISS_CHAR
147 , revision_date DATE := FND_API.G_MISS_DATE
148 , revision_reason_code VARCHAR2(30) := FND_API.G_MISS_CHAR
149 , start_date_active DATE := FND_API.G_MISS_DATE
150 , substitution_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR
151 , substitution_context VARCHAR2(30) := FND_API.G_MISS_CHAR
152 , substitution_value VARCHAR2(240) := FND_API.G_MISS_CHAR
153 , accrual_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
154 , pricing_group_sequence NUMBER := FND_API.G_MISS_NUM
155 , incompatibility_grp_code VARCHAR2(30) := FND_API.G_MISS_CHAR
156 , list_line_no VARCHAR2(30) := FND_API.G_MISS_CHAR
157 , from_rltd_modifier_id NUMBER := FND_API.G_MISS_NUM
158 , to_rltd_modifier_id NUMBER := FND_API.G_MISS_NUM
159 , rltd_modifier_grp_no NUMBER := FND_API.G_MISS_NUM
160 , rltd_modifier_grp_type VARCHAR2(30) := FND_API.G_MISS_CHAR
161 , pricing_phase_id NUMBER := FND_API.G_MISS_NUM
162 , product_precedence NUMBER := FND_API.G_MISS_NUM
163 , expiration_period_start_date DATE := FND_API.G_MISS_DATE
164 , number_expiration_periods NUMBER := FND_API.G_MISS_NUM
165 , expiration_period_uom VARCHAR2(3) := FND_API.G_MISS_CHAR
166 , expiration_date DATE := FND_API.G_MISS_DATE
167 , estim_gl_value NUMBER := FND_API.G_MISS_NUM
168 , benefit_price_list_line_id NUMBER := FND_API.G_MISS_NUM
169 --, recurring_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
170 , benefit_limit NUMBER := FND_API.G_MISS_NUM
171 , charge_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
172 , charge_subtype_code VARCHAR2(30) := FND_API.G_MISS_CHAR
173 , benefit_qty NUMBER := FND_API.G_MISS_NUM
174 , benefit_uom_code VARCHAR2(30) := FND_API.G_MISS_CHAR
175 , accrual_conversion_rate NUMBER := FND_API.G_MISS_NUM
176 , proration_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
177 , include_on_returns_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
178 , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
179 , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
180 , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
181 );
182
183 TYPE Modifiers_Tbl_Type IS TABLE OF Modifiers_Rec_Type
184 INDEX BY BINARY_INTEGER;
185
186 -- Modifiers value record type
187
188 TYPE Modifiers_Val_Rec_Type IS RECORD
189 ( automatic VARCHAR2(240) := FND_API.G_MISS_CHAR
190 , base_uom VARCHAR2(240) := FND_API.G_MISS_CHAR
191 , generate_using_formula VARCHAR2(240) := FND_API.G_MISS_CHAR
192 , gl_class VARCHAR2(240) := FND_API.G_MISS_CHAR
193 , inventory_item VARCHAR2(240) := FND_API.G_MISS_CHAR
194 , list_header VARCHAR2(240) := FND_API.G_MISS_CHAR
195 , list_line VARCHAR2(240) := FND_API.G_MISS_CHAR
196 , list_line_type VARCHAR2(240) := FND_API.G_MISS_CHAR
197 , list_price_uom VARCHAR2(240) := FND_API.G_MISS_CHAR
198 , modifier_level VARCHAR2(240) := FND_API.G_MISS_CHAR
199 , organization VARCHAR2(240) := FND_API.G_MISS_CHAR
200 , override VARCHAR2(240) := FND_API.G_MISS_CHAR
201 , price_break_type VARCHAR2(240) := FND_API.G_MISS_CHAR
202 , price_by_formula VARCHAR2(240) := FND_API.G_MISS_CHAR
203 , primary_uom VARCHAR2(240) := FND_API.G_MISS_CHAR
204 , print_on_invoice VARCHAR2(240) := FND_API.G_MISS_CHAR
205 , rebate_subtype VARCHAR2(240) := FND_API.G_MISS_CHAR
206 , rebate_transaction_type VARCHAR2(240) := FND_API.G_MISS_CHAR
207 , related_item VARCHAR2(240) := FND_API.G_MISS_CHAR
208 , relationship_type VARCHAR2(240) := FND_API.G_MISS_CHAR
209 , reprice VARCHAR2(240) := FND_API.G_MISS_CHAR
210 , revision_reason VARCHAR2(240) := FND_API.G_MISS_CHAR
211 );
212
213 TYPE Modifiers_Val_Tbl_Type IS TABLE OF Modifiers_Val_Rec_Type
214 INDEX BY BINARY_INTEGER;
215
216 -- Qualifiers record type
217 TYPE Qualifiers_Rec_Type IS RECORD
218 ( attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
219 , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
220 , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
221 , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
222 , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
223 , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
224 , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
225 , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
226 , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
227 , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
228 , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
229 , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
230 , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
231 , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
232 , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
233 , comparison_operator_code VARCHAR2(30) := FND_API.G_MISS_CHAR
234 , context VARCHAR2(30) := FND_API.G_MISS_CHAR
235 , created_by NUMBER := FND_API.G_MISS_NUM
236 , created_from_rule_id NUMBER := FND_API.G_MISS_NUM
237 , creation_date DATE := FND_API.G_MISS_DATE
238 , end_date_active DATE := FND_API.G_MISS_DATE
239 , excluder_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
240 , last_updated_by NUMBER := FND_API.G_MISS_NUM
241 , last_update_date DATE := FND_API.G_MISS_DATE
242 , last_update_login NUMBER := FND_API.G_MISS_NUM
243 , list_header_id NUMBER := FND_API.G_MISS_NUM
244 , list_line_id NUMBER := FND_API.G_MISS_NUM
245 , program_application_id NUMBER := FND_API.G_MISS_NUM
246 , program_id NUMBER := FND_API.G_MISS_NUM
247 , program_update_date DATE := FND_API.G_MISS_DATE
248 , qualifier_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR
249 , qualifier_attr_value VARCHAR2(240) := FND_API.G_MISS_CHAR
250 , qualifier_attr_value_to VARCHAR2(240) := FND_API.G_MISS_CHAR
251 , qualifier_context VARCHAR2(30) := FND_API.G_MISS_CHAR
252 , qualifier_datatype VARCHAR2(10) := FND_API.G_MISS_CHAR
253 --, qualifier_date_format VARCHAR2(30) := FND_API.G_MISS_CHAR
254 , qualifier_grouping_no NUMBER := FND_API.G_MISS_NUM
255 , qualifier_id NUMBER := FND_API.G_MISS_NUM
256 --, qualifier_number_format VARCHAR2(30) := FND_API.G_MISS_CHAR
257 , qualifier_precedence NUMBER := FND_API.G_MISS_NUM
258 , qualifier_rule_id NUMBER := FND_API.G_MISS_NUM
259 , request_id NUMBER := FND_API.G_MISS_NUM
260 , start_date_active DATE := FND_API.G_MISS_DATE
261 , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
262 , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
263 , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
264 );
265
266 TYPE Qualifiers_Tbl_Type IS TABLE OF Qualifiers_Rec_Type
267 INDEX BY BINARY_INTEGER;
268
269 -- Qualifiers value record type
270
271
272 TYPE Qualifiers_Val_Rec_Type IS RECORD
273 ( created_from_rule VARCHAR2(240) := FND_API.G_MISS_CHAR
274 , list_header VARCHAR2(240) := FND_API.G_MISS_CHAR
275 , list_line VARCHAR2(240) := FND_API.G_MISS_CHAR
276 , qualifier_rule VARCHAR2(240) := FND_API.G_MISS_CHAR
277 );
278
279 TYPE Qualifiers_Val_Tbl_Type IS TABLE OF Qualifiers_Val_Rec_Type
280 INDEX BY BINARY_INTEGER;
281
282
283 -- Pricing_Attr record type
284
285 TYPE Pricing_Attr_Rec_Type IS RECORD
286 ( accumulate_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
287 , attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
288 , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
289 , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
290 , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
291 , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
292 , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
293 , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
294 , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
295 , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
296 , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
297 , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
298 , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
299 , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
300 , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
301 , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
302 , attribute_grouping_no NUMBER := FND_API.G_MISS_NUM
303 , context VARCHAR2(30) := FND_API.G_MISS_CHAR
304 , created_by NUMBER := FND_API.G_MISS_NUM
305 , creation_date DATE := FND_API.G_MISS_DATE
306 , excluder_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
307 , last_updated_by NUMBER := FND_API.G_MISS_NUM
308 , last_update_date DATE := FND_API.G_MISS_DATE
309 , last_update_login NUMBER := FND_API.G_MISS_NUM
310 , list_line_id NUMBER := FND_API.G_MISS_NUM
311 , pricing_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR
312 , pricing_attribute_context VARCHAR2(30) := FND_API.G_MISS_CHAR
313 , pricing_attribute_id NUMBER := FND_API.G_MISS_NUM
314 , pricing_attr_value_from VARCHAR2(240) := FND_API.G_MISS_CHAR
315 , pricing_attr_value_to VARCHAR2(240) := FND_API.G_MISS_CHAR
316 , product_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR
317 , product_attribute_context VARCHAR2(30) := FND_API.G_MISS_CHAR
318 , product_attr_value VARCHAR2(240) := FND_API.G_MISS_CHAR
319 , product_uom_code VARCHAR2(3) := FND_API.G_MISS_CHAR
320 , program_application_id NUMBER := FND_API.G_MISS_NUM
321 , program_id NUMBER := FND_API.G_MISS_NUM
322 , program_update_date DATE := FND_API.G_MISS_DATE
323 , product_attribute_datatype VARCHAR2(30) := FND_API.G_MISS_CHAR
324 , pricing_attribute_datatype VARCHAR2(30) := FND_API.G_MISS_CHAR
325 , comparison_operator_code VARCHAR2(30) := FND_API.G_MISS_CHAR
326 , request_id NUMBER := FND_API.G_MISS_NUM
327 , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
328 , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
329 , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
330 , MODIFIERS_index NUMBER := FND_API.G_MISS_NUM
331 );
332
333 TYPE Pricing_Attr_Tbl_Type IS TABLE OF Pricing_Attr_Rec_Type
334 INDEX BY BINARY_INTEGER;
335
336 -- Pricing_Attr value record type
337
338 TYPE Pricing_Attr_Val_Rec_Type IS RECORD
339 ( accumulate VARCHAR2(240) := FND_API.G_MISS_CHAR
340 , excluder VARCHAR2(240) := FND_API.G_MISS_CHAR
341 , list_line VARCHAR2(240) := FND_API.G_MISS_CHAR
342 , pricing_attribute VARCHAR2(240) := FND_API.G_MISS_CHAR
343 , product_uom VARCHAR2(240) := FND_API.G_MISS_CHAR
344 );
345
346 TYPE Pricing_Attr_Val_Tbl_Type IS TABLE OF Pricing_Attr_Val_Rec_Type
347 INDEX BY BINARY_INTEGER;
348
349 -- Variables representing missing records and tables
350
351 G_MISS_MODIFIER_LIST_REC Modifier_List_Rec_Type;
352 G_MISS_MODIFIER_LIST_VAL_REC Modifier_List_Val_Rec_Type;
353 G_MISS_MODIFIER_LIST_TBL Modifier_List_Tbl_Type;
354 G_MISS_MODIFIER_LIST_VAL_TBL Modifier_List_Val_Tbl_Type;
355 G_MISS_MODIFIERS_REC Modifiers_Rec_Type;
356 G_MISS_MODIFIERS_VAL_REC Modifiers_Val_Rec_Type;
357 G_MISS_MODIFIERS_TBL Modifiers_Tbl_Type;
358 G_MISS_MODIFIERS_VAL_TBL Modifiers_Val_Tbl_Type;
359 G_MISS_QUALIFIERS_REC QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
360 G_MISS_QUALIFIERS_VAL_REC QP_Qualifier_Rules_PUB.Qualifiers_Val_Rec_Type;
361 G_MISS_QUALIFIERS_TBL QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
362 G_MISS_QUALIFIERS_VAL_TBL QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type;
363 G_MISS_PRICING_ATTR_REC Pricing_Attr_Rec_Type;
364 G_MISS_PRICING_ATTR_VAL_REC Pricing_Attr_Val_Rec_Type;
365 G_MISS_PRICING_ATTR_TBL Pricing_Attr_Tbl_Type;
366 G_MISS_PRICING_ATTR_VAL_TBL Pricing_Attr_Val_Tbl_Type;
367 */
368
369 -- Start of Comments
370 -- API name Process_Modifiers
371 -- Type Public
372 -- Function
373 --
374 -- Pre-reqs
375 --
376 -- Parameters
377 --
378 -- Version Current version = 1.0
379 -- Initial version = 1.0
380 --
381 -- Notes
382 --
383 -- End of Comments
384
385 PROCEDURE Process_Modifiers
386 ( p_api_version_number IN NUMBER
387 , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
388 , p_return_values IN VARCHAR2 := FND_API.G_FALSE
389 , p_commit IN VARCHAR2 := FND_API.G_FALSE
390 , p_control_rec IN QP_GLOBALS.Control_Rec_Type :=
391 QP_GLOBALS.G_MISS_CONTROL_REC
392 , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
393 , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
394 , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
395 , p_MODIFIER_LIST_rec IN QP_MODIFIERS_PUB.Modifier_List_Rec_Type :=
396 QP_MODIFIERS_PUB.G_MISS_MODIFIER_LIST_REC
397 , p_MODIFIER_LIST_val_rec IN QP_MODIFIERS_PUB.Modifier_List_Val_Rec_Type :=
398 QP_MODIFIERS_PUB.G_MISS_MODIFIER_LIST_VAL_REC
399 , p_MODIFIERS_tbl IN QP_MODIFIERS_PUB.Modifiers_Tbl_Type :=
400 QP_MODIFIERS_PUB.G_MISS_MODIFIERS_TBL
401 , p_MODIFIERS_val_tbl IN QP_MODIFIERS_PUB.Modifiers_Val_Tbl_Type :=
402 QP_MODIFIERS_PUB.G_MISS_MODIFIERS_VAL_TBL
403 , p_QUALIFIERS_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type :=
404 QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_TBL
405 , p_QUALIFIERS_val_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type :=
406 QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_VAL_TBL
407 , p_PRICING_ATTR_tbl IN QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type :=
408 QP_MODIFIERS_PUB.G_MISS_PRICING_ATTR_TBL
409 , p_PRICING_ATTR_val_tbl IN QP_MODIFIERS_PUB.Pricing_Attr_Val_Tbl_Type :=
410 QP_MODIFIERS_PUB.G_MISS_PRICING_ATTR_VAL_TBL
411 , x_MODIFIER_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.Modifier_List_Rec_Type
412 , x_MODIFIER_LIST_val_rec OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.Modifier_List_Val_Rec_Type
413 , x_MODIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.Modifiers_Tbl_Type
414 , x_MODIFIERS_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.Modifiers_Val_Tbl_Type
415 , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type
416 , x_QUALIFIERS_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type
417 , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type
418 , x_PRICING_ATTR_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.Pricing_Attr_Val_Tbl_Type
419 );
420
421 -- Start of Comments
422 -- API name Lock_Modifiers
423 -- Type Public
424 -- Function
425 --
426 -- Pre-reqs
427 --
428 -- Parameters
429 --
430 -- Version Current version = 1.0
431 -- Initial version = 1.0
432 --
433 -- Notes
434 --
435 -- End of Comments
436
437 PROCEDURE Lock_Modifiers
438 ( p_api_version_number IN NUMBER
439 , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
440 , p_return_values IN VARCHAR2 := FND_API.G_FALSE
441 , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
442 , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
443 , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
444 , p_MODIFIER_LIST_rec IN QP_MODIFIERS_PUB.Modifier_List_Rec_Type :=
445 QP_MODIFIERS_PUB.G_MISS_MODIFIER_LIST_REC
446 , p_MODIFIER_LIST_val_rec IN QP_MODIFIERS_PUB.Modifier_List_Val_Rec_Type :=
447 QP_MODIFIERS_PUB.G_MISS_MODIFIER_LIST_VAL_REC
448 , p_MODIFIERS_tbl IN QP_MODIFIERS_PUB.Modifiers_Tbl_Type :=
449 QP_MODIFIERS_PUB.G_MISS_MODIFIERS_TBL
450 , p_MODIFIERS_val_tbl IN QP_MODIFIERS_PUB.Modifiers_Val_Tbl_Type :=
451 QP_MODIFIERS_PUB.G_MISS_MODIFIERS_VAL_TBL
452 , p_QUALIFIERS_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type :=
453 QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_TBL
454 , p_QUALIFIERS_val_tbl IN QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type :=
455 QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_VAL_TBL
456 , p_PRICING_ATTR_tbl IN QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type :=
457 QP_MODIFIERS_PUB.G_MISS_PRICING_ATTR_TBL
458 , p_PRICING_ATTR_val_tbl IN QP_MODIFIERS_PUB.Pricing_Attr_Val_Tbl_Type :=
459 QP_MODIFIERS_PUB.G_MISS_PRICING_ATTR_VAL_TBL
460 , x_MODIFIER_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.Modifier_List_Rec_Type
461 , x_MODIFIER_LIST_val_rec OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.Modifier_List_Val_Rec_Type
462 , x_MODIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.Modifiers_Tbl_Type
463 , x_MODIFIERS_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.Modifiers_Val_Tbl_Type
464 , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type
465 , x_QUALIFIERS_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type
466 , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type
467 , x_PRICING_ATTR_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.Pricing_Attr_Val_Tbl_Type
468 );
469
470 -- Start of Comments
471 -- API name Get_Modifiers
472 -- Type Public
473 -- Function
474 --
475 -- Pre-reqs
476 --
477 -- Parameters
478 --
479 -- Version Current version = 1.0
480 -- Initial version = 1.0
481 --
482 -- Notes
483 --
484 -- End of Comments
485
486 PROCEDURE Get_Modifiers
487 ( p_api_version_number IN NUMBER
488 , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
489 , p_return_values IN VARCHAR2 := FND_API.G_FALSE
490 , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
491 , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
492 , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
493 , p_list_header_id IN NUMBER :=
494 FND_API.G_MISS_NUM
495 , p_list_header IN VARCHAR2 :=
496 FND_API.G_MISS_CHAR
497 , x_MODIFIER_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.Modifier_List_Rec_Type
498 , x_MODIFIER_LIST_val_rec OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.Modifier_List_Val_Rec_Type
499 , x_MODIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.Modifiers_Tbl_Type
500 , x_MODIFIERS_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.Modifiers_Val_Tbl_Type
501 , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type
502 , x_QUALIFIERS_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type
503 , x_PRICING_ATTR_tbl OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type
504 , x_PRICING_ATTR_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_MODIFIERS_PUB.Pricing_Attr_Val_Tbl_Type
505 );
506
507 END QP_Modifiers_GRP;