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