[Home] [Help]
PACKAGE: APPS.QP_QP_FORM_MODIFIERS
Source
1 PACKAGE QP_QP_Form_Modifiers AS
2 /* $Header: QPXFMLLS.pls 120.2 2006/02/22 21:48:23 prarasto noship $ */
3
4 -- Procedure : Default_Attributes
5 --
6
7 PROCEDURE Default_Attributes
8 ( p_list_header_id IN NUMBER
9 , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
10 , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
11 , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
12 , x_arithmetic_operator OUT NOCOPY /* file.sql.39 change */ VARCHAR2
13 , x_attribute1 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
14 , x_attribute10 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
15 , x_attribute11 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
16 , x_attribute12 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
17 , x_attribute13 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
18 , x_attribute14 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
19 , x_attribute15 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
20 , x_attribute2 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
21 , x_attribute3 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
22 , x_attribute4 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
23 , x_attribute5 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
24 , x_attribute6 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
25 , x_attribute7 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
26 , x_attribute8 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
27 , x_attribute9 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
28 , x_automatic_flag OUT NOCOPY /* file.sql.39 change */ VARCHAR2
29 --, x_base_qty OUT NOCOPY /* file.sql.39 change */ NUMBER
30 , x_pricing_phase_id OUT NOCOPY /* file.sql.39 change */ NUMBER
31 --, x_base_uom_code OUT NOCOPY /* file.sql.39 change */ VARCHAR2
32 , x_comments OUT NOCOPY /* file.sql.39 change */ VARCHAR2
33 , x_context OUT NOCOPY /* file.sql.39 change */ VARCHAR2
34 , x_effective_period_uom OUT NOCOPY /* file.sql.39 change */ VARCHAR2
35 , x_end_date_active OUT NOCOPY /* file.sql.39 change */ DATE
36 , x_estim_accrual_rate OUT NOCOPY /* file.sql.39 change */ NUMBER
37 , x_generate_using_formula_id OUT NOCOPY /* file.sql.39 change */ NUMBER
38 --, x_gl_class_id OUT NOCOPY /* file.sql.39 change */ NUMBER
39 , x_inventory_item_id OUT NOCOPY /* file.sql.39 change */ NUMBER
40 , x_list_header_id OUT NOCOPY /* file.sql.39 change */ NUMBER
41 , x_list_line_id OUT NOCOPY /* file.sql.39 change */ NUMBER
42 , x_list_line_type_code OUT NOCOPY /* file.sql.39 change */ VARCHAR2
43 , x_list_price OUT NOCOPY /* file.sql.39 change */ NUMBER
44 --, x_list_price_uom_code OUT NOCOPY /* file.sql.39 change */ VARCHAR2
45 , x_modifier_level_code OUT NOCOPY /* file.sql.39 change */ VARCHAR2
46 --, x_new_price OUT NOCOPY /* file.sql.39 change */ NUMBER
47 , x_number_effective_periods OUT NOCOPY /* file.sql.39 change */ NUMBER
48 , x_operand OUT NOCOPY /* file.sql.39 change */ NUMBER
49 , x_organization_id OUT NOCOPY /* file.sql.39 change */ NUMBER
50 , x_override_flag OUT NOCOPY /* file.sql.39 change */ VARCHAR2
51 , x_percent_price OUT NOCOPY /* file.sql.39 change */ NUMBER
52 , x_price_break_type_code OUT NOCOPY /* file.sql.39 change */ VARCHAR2
53 , x_price_by_formula_id OUT NOCOPY /* file.sql.39 change */ NUMBER
54 , x_primary_uom_flag OUT NOCOPY /* file.sql.39 change */ VARCHAR2
55 , x_print_on_invoice_flag OUT NOCOPY /* file.sql.39 change */ VARCHAR2
56 --, x_rebate_subtype_code OUT NOCOPY /* file.sql.39 change */ VARCHAR2
57 , x_rebate_trxn_type_code OUT NOCOPY /* file.sql.39 change */ VARCHAR2
58 , x_related_item_id OUT NOCOPY /* file.sql.39 change */ NUMBER
59 , x_relationship_type_id OUT NOCOPY /* file.sql.39 change */ NUMBER
60 , x_reprice_flag OUT NOCOPY /* file.sql.39 change */ VARCHAR2
61 , x_revision OUT NOCOPY /* file.sql.39 change */ VARCHAR2
62 , x_revision_date OUT NOCOPY /* file.sql.39 change */ DATE
63 , x_revision_reason_code OUT NOCOPY /* file.sql.39 change */ VARCHAR2
64 , x_start_date_active OUT NOCOPY /* file.sql.39 change */ DATE
65 , x_substitution_attribute OUT NOCOPY /* file.sql.39 change */ VARCHAR2
66 , x_substitution_context OUT NOCOPY /* file.sql.39 change */ VARCHAR2
67 , x_substitution_value OUT NOCOPY /* file.sql.39 change */ VARCHAR2
68 , x_automatic OUT NOCOPY /* file.sql.39 change */ VARCHAR2
69 --, x_base_uom OUT NOCOPY /* file.sql.39 change */ VARCHAR2
70 , x_generate_using_formula OUT NOCOPY /* file.sql.39 change */ VARCHAR2
71 --, x_gl_class OUT NOCOPY /* file.sql.39 change */ VARCHAR2
72 , x_inventory_item OUT NOCOPY /* file.sql.39 change */ VARCHAR2
73 , x_list_header OUT NOCOPY /* file.sql.39 change */ VARCHAR2
74 , x_list_line OUT NOCOPY /* file.sql.39 change */ VARCHAR2
75 , x_list_line_type OUT NOCOPY /* file.sql.39 change */ VARCHAR2
76 --, x_list_price_uom OUT NOCOPY /* file.sql.39 change */ VARCHAR2
77 , x_modifier_level OUT NOCOPY /* file.sql.39 change */ VARCHAR2
78 , x_organization OUT NOCOPY /* file.sql.39 change */ VARCHAR2
79 , x_override OUT NOCOPY /* file.sql.39 change */ VARCHAR2
80 , x_price_break_type OUT NOCOPY /* file.sql.39 change */ VARCHAR2
81 , x_price_by_formula OUT NOCOPY /* file.sql.39 change */ VARCHAR2
82 , x_primary_uom OUT NOCOPY /* file.sql.39 change */ VARCHAR2
83 , x_print_on_invoice OUT NOCOPY /* file.sql.39 change */ VARCHAR2
84 --, x_rebate_subtype OUT NOCOPY /* file.sql.39 change */ VARCHAR2
85 , x_rebate_transaction_type OUT NOCOPY /* file.sql.39 change */ VARCHAR2
86 , x_related_item OUT NOCOPY /* file.sql.39 change */ VARCHAR2
87 , x_relationship_type OUT NOCOPY /* file.sql.39 change */ VARCHAR2
88 , x_reprice OUT NOCOPY /* file.sql.39 change */ VARCHAR2
89 , x_revision_reason OUT NOCOPY /* file.sql.39 change */ VARCHAR2
90 , x_accrual_flag OUT NOCOPY /* file.sql.39 change */ VARCHAR2
91 , x_pricing_group_sequence OUT NOCOPY /* file.sql.39 change */ NUMBER
92 , x_incompatibility_grp_code OUT NOCOPY /* file.sql.39 change */ VARCHAR2
93 , x_list_line_no OUT NOCOPY /* file.sql.39 change */ VARCHAR2
94 , x_product_precedence OUT NOCOPY /* file.sql.39 change */ NUMBER
95 , x_expiration_period_start_date OUT NOCOPY /* file.sql.39 change */ DATE
96 , x_number_expiration_periods OUT NOCOPY /* file.sql.39 change */ NUMBER
97 , x_expiration_period_uom OUT NOCOPY /* file.sql.39 change */ VARCHAR2
98 , x_expiration_date OUT NOCOPY /* file.sql.39 change */ DATE
99 , x_estim_gl_value OUT NOCOPY /* file.sql.39 change */ NUMBER
100 , x_benefit_price_list_line_id OUT NOCOPY /* file.sql.39 change */ NUMBER
101 --, x_recurring_flag OUT NOCOPY /* file.sql.39 change */ VARCHAR2
102 , x_benefit_limit OUT NOCOPY /* file.sql.39 change */ NUMBER
103 , x_charge_type_code OUT NOCOPY /* file.sql.39 change */ VARCHAR2
104 , x_charge_subtype_code OUT NOCOPY /* file.sql.39 change */ VARCHAR2
105 , x_benefit_qty OUT NOCOPY /* file.sql.39 change */ NUMBER
106 , x_benefit_uom_code OUT NOCOPY /* file.sql.39 change */ VARCHAR2
107 , x_accrual_conversion_rate OUT NOCOPY /* file.sql.39 change */ NUMBER
108 , x_proration_type_code OUT NOCOPY /* file.sql.39 change */ VARCHAR2
109 , x_include_on_returns_flag OUT NOCOPY /* file.sql.39 change */ VARCHAR2
110 , x_from_rltd_modifier_id OUT NOCOPY /* file.sql.39 change */ NUMBER
111 , x_to_rltd_modifier_id OUT NOCOPY /* file.sql.39 change */ NUMBER
112 , x_rltd_modifier_grp_no OUT NOCOPY /* file.sql.39 change */ NUMBER
113 , x_rltd_modifier_grp_type OUT NOCOPY /* file.sql.39 change */ VARCHAR2
114 , x_net_amount_flag OUT NOCOPY /* file.sql.39 change */ VARCHAR2
115 , x_accum_attribute OUT NOCOPY /* file.sql.39 change */ VARCHAR2
116 , x_continuous_price_break_flag OUT NOCOPY VARCHAR2 --Continuous Price Breaks
117 );
118
119 -- Procedure : Change_Attribute
120 --
121
122 PROCEDURE Change_Attribute
123 ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
124 , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
125 , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
126 , p_list_line_id IN NUMBER
127 , p_attr_id IN NUMBER
128 , p_attr_value IN VARCHAR2
129 , p_attribute1 IN VARCHAR2
130 , p_attribute10 IN VARCHAR2
131 , p_attribute11 IN VARCHAR2
132 , p_attribute12 IN VARCHAR2
133 , p_attribute13 IN VARCHAR2
134 , p_attribute14 IN VARCHAR2
135 , p_attribute15 IN VARCHAR2
136 , p_attribute2 IN VARCHAR2
137 , p_attribute3 IN VARCHAR2
138 , p_attribute4 IN VARCHAR2
139 , p_attribute5 IN VARCHAR2
140 , p_attribute6 IN VARCHAR2
141 , p_attribute7 IN VARCHAR2
142 , p_attribute8 IN VARCHAR2
143 , p_attribute9 IN VARCHAR2
144 , p_context IN VARCHAR2
145 , x_arithmetic_operator OUT NOCOPY /* file.sql.39 change */ VARCHAR2
146 , x_attribute1 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
147 , x_attribute10 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
148 , x_attribute11 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
149 , x_attribute12 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
150 , x_attribute13 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
151 , x_attribute14 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
152 , x_attribute15 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
153 , x_attribute2 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
154 , x_attribute3 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
155 , x_attribute4 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
156 , x_attribute5 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
157 , x_attribute6 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
158 , x_attribute7 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
159 , x_attribute8 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
160 , x_attribute9 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
161 , x_automatic_flag OUT NOCOPY /* file.sql.39 change */ VARCHAR2
162 --, x_base_qty OUT NOCOPY /* file.sql.39 change */ NUMBER
163 , x_pricing_phase_id OUT NOCOPY /* file.sql.39 change */ NUMBER
164 --, x_base_uom_code OUT NOCOPY /* file.sql.39 change */ VARCHAR2
165 , x_comments OUT NOCOPY /* file.sql.39 change */ VARCHAR2
166 , x_context OUT NOCOPY /* file.sql.39 change */ VARCHAR2
167 , x_effective_period_uom OUT NOCOPY /* file.sql.39 change */ VARCHAR2
168 , x_end_date_active OUT NOCOPY /* file.sql.39 change */ DATE
169 , x_estim_accrual_rate OUT NOCOPY /* file.sql.39 change */ NUMBER
170 , x_generate_using_formula_id OUT NOCOPY /* file.sql.39 change */ NUMBER
171 --, x_gl_class_id OUT NOCOPY /* file.sql.39 change */ NUMBER
172 , x_inventory_item_id OUT NOCOPY /* file.sql.39 change */ NUMBER
173 , x_list_header_id OUT NOCOPY /* file.sql.39 change */ NUMBER
174 , x_list_line_id OUT NOCOPY /* file.sql.39 change */ NUMBER
175 , x_list_line_type_code OUT NOCOPY /* file.sql.39 change */ VARCHAR2
176 , x_list_price OUT NOCOPY /* file.sql.39 change */ NUMBER
177 --, x_list_price_uom_code OUT NOCOPY /* file.sql.39 change */ VARCHAR2
178 , x_modifier_level_code OUT NOCOPY /* file.sql.39 change */ VARCHAR2
179 --, x_new_price OUT NOCOPY /* file.sql.39 change */ NUMBER
180 , x_number_effective_periods OUT NOCOPY /* file.sql.39 change */ NUMBER
181 , x_operand OUT NOCOPY /* file.sql.39 change */ NUMBER
182 , x_organization_id OUT NOCOPY /* file.sql.39 change */ NUMBER
183 , x_override_flag OUT NOCOPY /* file.sql.39 change */ VARCHAR2
184 , x_percent_price OUT NOCOPY /* file.sql.39 change */ NUMBER
185 , x_price_break_type_code OUT NOCOPY /* file.sql.39 change */ VARCHAR2
186 , x_price_by_formula_id OUT NOCOPY /* file.sql.39 change */ NUMBER
187 , x_primary_uom_flag OUT NOCOPY /* file.sql.39 change */ VARCHAR2
188 , x_print_on_invoice_flag OUT NOCOPY /* file.sql.39 change */ VARCHAR2
189 --, x_rebate_subtype_code OUT NOCOPY /* file.sql.39 change */ VARCHAR2
190 , x_rebate_trxn_type_code OUT NOCOPY /* file.sql.39 change */ VARCHAR2
191 , x_related_item_id OUT NOCOPY /* file.sql.39 change */ NUMBER
192 , x_relationship_type_id OUT NOCOPY /* file.sql.39 change */ NUMBER
193 , x_reprice_flag OUT NOCOPY /* file.sql.39 change */ VARCHAR2
194 , x_revision OUT NOCOPY /* file.sql.39 change */ VARCHAR2
195 , x_revision_date OUT NOCOPY /* file.sql.39 change */ DATE
196 , x_revision_reason_code OUT NOCOPY /* file.sql.39 change */ VARCHAR2
197 , x_start_date_active OUT NOCOPY /* file.sql.39 change */ DATE
198 , x_substitution_attribute OUT NOCOPY /* file.sql.39 change */ VARCHAR2
199 , x_substitution_context OUT NOCOPY /* file.sql.39 change */ VARCHAR2
200 , x_substitution_value OUT NOCOPY /* file.sql.39 change */ VARCHAR2
201 , x_automatic OUT NOCOPY /* file.sql.39 change */ VARCHAR2
202 --, x_base_uom OUT NOCOPY /* file.sql.39 change */ VARCHAR2
203 , x_generate_using_formula OUT NOCOPY /* file.sql.39 change */ VARCHAR2
204 --, x_gl_class OUT NOCOPY /* file.sql.39 change */ VARCHAR2
205 , x_inventory_item OUT NOCOPY /* file.sql.39 change */ VARCHAR2
206 , x_list_header OUT NOCOPY /* file.sql.39 change */ VARCHAR2
207 , x_list_line OUT NOCOPY /* file.sql.39 change */ VARCHAR2
208 , x_list_line_type OUT NOCOPY /* file.sql.39 change */ VARCHAR2
209 --, x_list_price_uom OUT NOCOPY /* file.sql.39 change */ VARCHAR2
210 , x_modifier_level OUT NOCOPY /* file.sql.39 change */ VARCHAR2
211 , x_organization OUT NOCOPY /* file.sql.39 change */ VARCHAR2
212 , x_override OUT NOCOPY /* file.sql.39 change */ VARCHAR2
213 , x_price_break_type OUT NOCOPY /* file.sql.39 change */ VARCHAR2
214 , x_price_by_formula OUT NOCOPY /* file.sql.39 change */ VARCHAR2
215 , x_primary_uom OUT NOCOPY /* file.sql.39 change */ VARCHAR2
216 , x_print_on_invoice OUT NOCOPY /* file.sql.39 change */ VARCHAR2
217 --, x_rebate_subtype OUT NOCOPY /* file.sql.39 change */ VARCHAR2
218 , x_rebate_transaction_type OUT NOCOPY /* file.sql.39 change */ VARCHAR2
219 , x_related_item OUT NOCOPY /* file.sql.39 change */ VARCHAR2
220 , x_relationship_type OUT NOCOPY /* file.sql.39 change */ VARCHAR2
221 , x_reprice OUT NOCOPY /* file.sql.39 change */ VARCHAR2
222 , x_revision_reason OUT NOCOPY /* file.sql.39 change */ VARCHAR2
223 , x_accrual_flag OUT NOCOPY /* file.sql.39 change */ VARCHAR2
224 , x_pricing_group_sequence OUT NOCOPY /* file.sql.39 change */ NUMBER
228 , x_expiration_period_start_date OUT NOCOPY /* file.sql.39 change */ DATE
225 , x_incompatibility_grp_code OUT NOCOPY /* file.sql.39 change */ VARCHAR2
226 , x_list_line_no OUT NOCOPY /* file.sql.39 change */ VARCHAR2
227 , x_product_precedence OUT NOCOPY /* file.sql.39 change */ NUMBER
229 , x_number_expiration_periods OUT NOCOPY /* file.sql.39 change */ NUMBER
230 , x_expiration_period_uom OUT NOCOPY /* file.sql.39 change */ VARCHAR2
231 , x_expiration_date OUT NOCOPY /* file.sql.39 change */ DATE
232 , x_estim_gl_value OUT NOCOPY /* file.sql.39 change */ NUMBER
233 , x_benefit_price_list_line_id OUT NOCOPY /* file.sql.39 change */ NUMBER
234 --, x_recurring_flag OUT NOCOPY /* file.sql.39 change */ VARCHAR2
235 , x_benefit_limit OUT NOCOPY /* file.sql.39 change */ NUMBER
236 , x_charge_type_code OUT NOCOPY /* file.sql.39 change */ VARCHAR2
237 , x_charge_subtype_code OUT NOCOPY /* file.sql.39 change */ VARCHAR2
238 , x_benefit_qty OUT NOCOPY /* file.sql.39 change */ NUMBER
239 , x_benefit_uom_code OUT NOCOPY /* file.sql.39 change */ VARCHAR2
240 , x_accrual_conversion_rate OUT NOCOPY /* file.sql.39 change */ NUMBER
241 , x_proration_type_code OUT NOCOPY /* file.sql.39 change */ VARCHAR2
242 , x_include_on_returns_flag OUT NOCOPY /* file.sql.39 change */ VARCHAR2
243 , x_from_rltd_modifier_id OUT NOCOPY /* file.sql.39 change */ NUMBER
244 , x_to_rltd_modifier_id OUT NOCOPY /* file.sql.39 change */ NUMBER
245 , x_rltd_modifier_grp_no OUT NOCOPY /* file.sql.39 change */ NUMBER
246 , x_rltd_modifier_grp_type OUT NOCOPY /* file.sql.39 change */ VARCHAR2
247 , x_net_amount_flag OUT NOCOPY /* file.sql.39 change */ VARCHAR2
248 , x_accum_attribute OUT NOCOPY /* file.sql.39 change */ VARCHAR2
249 , x_continuous_price_break_flag OUT NOCOPY VARCHAR2 --Continuous Price Breaks
250 );
251
252 -- Procedure Validate_And_Write
253 --
254
255 PROCEDURE Validate_And_Write
256 ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
257 , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
258 , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
259 , p_list_line_id IN NUMBER
260 , x_creation_date OUT NOCOPY /* file.sql.39 change */ DATE
261 , x_created_by OUT NOCOPY /* file.sql.39 change */ NUMBER
262 , x_last_update_date OUT NOCOPY /* file.sql.39 change */ DATE
263 , x_last_updated_by OUT NOCOPY /* file.sql.39 change */ NUMBER
264 , x_last_update_login OUT NOCOPY /* file.sql.39 change */ NUMBER
265 );
266
267 -- Procedure Delete_Row
268 --
269
270 PROCEDURE Delete_Row
271 ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
272 , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
273 , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
274 , p_list_line_id IN NUMBER
275 );
276
277 -- Procedure Process_Entity
278 --
279
280 PROCEDURE Process_Entity
281 ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
282 , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
283 , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
284 );
285
286 -- Procedure lock_Row
287 --
288
289 PROCEDURE Lock_Row
290 ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
291 , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
292 , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
293 , p_arithmetic_operator IN VARCHAR2
294 , p_attribute1 IN VARCHAR2
295 , p_attribute10 IN VARCHAR2
296 , p_attribute11 IN VARCHAR2
297 , p_attribute12 IN VARCHAR2
298 , p_attribute13 IN VARCHAR2
299 , p_attribute14 IN VARCHAR2
300 , p_attribute15 IN VARCHAR2
301 , p_attribute2 IN VARCHAR2
302 , p_attribute3 IN VARCHAR2
303 , p_attribute4 IN VARCHAR2
304 , p_attribute5 IN VARCHAR2
305 , p_attribute6 IN VARCHAR2
306 , p_attribute7 IN VARCHAR2
307 , p_attribute8 IN VARCHAR2
308 , p_attribute9 IN VARCHAR2
309 , p_automatic_flag IN VARCHAR2
310 --, p_base_qty IN NUMBER
311 , p_pricing_phase_id IN NUMBER
312 --, p_base_uom_code IN VARCHAR2
313 , p_comments IN VARCHAR2
314 , p_context IN VARCHAR2
315 , p_created_by IN NUMBER
316 , p_creation_date IN DATE
317 , p_effective_period_uom IN VARCHAR2
318 , p_end_date_active IN DATE
319 , p_estim_accrual_rate IN NUMBER
320 , p_generate_using_formula_id IN NUMBER
321 --, p_gl_class_id IN NUMBER
322 , p_inventory_item_id IN NUMBER
323 , p_last_updated_by IN NUMBER
324 , p_last_update_date IN DATE
325 , p_last_update_login IN NUMBER
326 , p_list_header_id IN NUMBER
327 , p_list_line_id IN NUMBER
331 , p_modifier_level_code IN VARCHAR2
328 , p_list_line_type_code IN VARCHAR2
329 , p_list_price IN NUMBER
330 --, p_list_price_uom_code IN VARCHAR2
332 --, p_new_price IN NUMBER
333 , p_number_effective_periods IN NUMBER
334 , p_operand IN NUMBER
335 , p_organization_id IN NUMBER
336 , p_override_flag IN VARCHAR2
337 , p_percent_price IN NUMBER
338 , p_price_break_type_code IN VARCHAR2
339 , p_price_by_formula_id IN NUMBER
340 , p_primary_uom_flag IN VARCHAR2
341 , p_print_on_invoice_flag IN VARCHAR2
342 , p_program_application_id IN NUMBER
343 , p_program_id IN NUMBER
344 , p_program_update_date IN DATE
345 --, p_rebate_subtype_code IN VARCHAR2
346 , p_rebate_trxn_type_code IN VARCHAR2
347 , p_related_item_id IN NUMBER
348 , p_relationship_type_id IN NUMBER
349 , p_reprice_flag IN VARCHAR2
350 , p_request_id IN NUMBER
351 , p_revision IN VARCHAR2
352 , p_revision_date IN DATE
353 , p_revision_reason_code IN VARCHAR2
354 , p_start_date_active IN DATE
355 , p_substitution_attribute IN VARCHAR2
356 , p_substitution_context IN VARCHAR2
357 , p_substitution_value IN VARCHAR2
358 , p_accrual_flag IN VARCHAR2
359 , p_pricing_group_sequence IN NUMBER
360 , p_incompatibility_grp_code IN VARCHAR2
361 , p_list_line_no IN VARCHAR2
362 , p_product_precedence IN NUMBER
363 , p_expiration_period_start_date IN DATE
364 , p_number_expiration_periods IN NUMBER
365 , p_expiration_period_uom IN VARCHAR2
366 , p_expiration_date IN DATE
367 , p_estim_gl_value IN NUMBER
368 , p_benefit_price_list_line_id IN NUMBER
369 --, p_recurring_flag IN VARCHAR2
370 , p_benefit_limit IN NUMBER
371 , p_charge_type_code IN VARCHAR2
372 , p_charge_subtype_code IN VARCHAR2
373 , p_benefit_qty IN NUMBER
374 , p_benefit_uom_code IN VARCHAR2
375 , p_accrual_conversion_rate IN NUMBER
376 , p_proration_type_code IN VARCHAR2
377 , p_include_on_returns_flag IN VARCHAR2
378 , p_from_rltd_modifier_id IN NUMBER
379 , p_to_rltd_modifier_id IN NUMBER
380 , p_rltd_modifier_grp_no IN NUMBER
381 , p_rltd_modifier_grp_type IN VARCHAR2
382 , p_net_amount_flag IN VARCHAR2
383 , p_accum_attribute IN VARCHAR2
384 , p_continuous_price_break_flag IN VARCHAR2 --Continuous Price Breaks
385 );
386
387
388
389
390 -- added by svdeshmu for delayed request on feb 24 ,00
391
392 Procedure Clear_Record
393 ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
394 , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
395 , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
396 , p_list_line_id IN NUMBER
397 );
398
399
400
401 -- End of additions by svdeshmu for delayed request
402
403 -- Following procedure is added for the ER 2423045
404
405 Procedure Dup_record
406 ( p_old_list_line_id IN NUMBER,
407 p_new_list_line_id IN NUMBER,
408 p_list_header_id IN NUMBER,
409 p_list_line_type_code IN VARCHAR2,
410 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
411 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
412 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
413 );
414
415
416 END QP_QP_Form_Modifiers;