eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE: APPS.QP_QP_FORM_PRICING_ATTR

Source


1 PACKAGE QP_QP_Form_Pricing_Attr AS
2 /* $Header: QPXFPRAS.pls 120.2 2005/08/26 00:20:33 nirmkuma noship $ */
3 
4 --  Procedure : Default_Attributes
5 --
6 
7 PROCEDURE Default_Attributes
8 (   p_list_line_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_accumulate_flag               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_attribute_grouping_no         OUT NOCOPY /* file.sql.39 change */ NUMBER
29 ,   x_context                       OUT NOCOPY /* file.sql.39 change */ VARCHAR2
30 ,   x_excluder_flag                 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
31 ,   x_list_line_id                  OUT NOCOPY /* file.sql.39 change */ NUMBER
32 ,   x_pricing_attribute             OUT NOCOPY /* file.sql.39 change */ VARCHAR2
33 ,   x_pricing_attribute_context     OUT NOCOPY /* file.sql.39 change */ VARCHAR2
34 ,   x_pricing_attribute_id          OUT NOCOPY /* file.sql.39 change */ NUMBER
35 ,   x_pricing_attr_value_from       OUT NOCOPY /* file.sql.39 change */ VARCHAR2
36 ,   x_pricing_attr_value_to         OUT NOCOPY /* file.sql.39 change */ VARCHAR2
37 ,   x_product_attribute             OUT NOCOPY /* file.sql.39 change */ VARCHAR2
38 ,   x_product_attribute_context     OUT NOCOPY /* file.sql.39 change */ VARCHAR2
39 ,   x_product_attr_value            OUT NOCOPY /* file.sql.39 change */ VARCHAR2
40 ,   x_product_uom_code              OUT NOCOPY /* file.sql.39 change */ VARCHAR2
41 ,   x_accumulate                    OUT NOCOPY /* file.sql.39 change */ VARCHAR2
42 ,   x_excluder                      OUT NOCOPY /* file.sql.39 change */ VARCHAR2
43 ,   x_list_line                     OUT NOCOPY /* file.sql.39 change */ VARCHAR2
44 ,   x_product_uom                   OUT NOCOPY /* file.sql.39 change */ VARCHAR2
45 ,   x_product_attribute_datatype    OUT NOCOPY /* file.sql.39 change */ VARCHAR2
46 ,   x_pricing_attribute_datatype    OUT NOCOPY /* file.sql.39 change */ VARCHAR2
47 ,   x_comparison_operator_code      OUT NOCOPY /* file.sql.39 change */ VARCHAR2
48 );
49 
50 --  Procedure   :   Change_Attribute
51 --
52 
53 PROCEDURE Change_Attribute
54 (   x_return_status                 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
55 ,   x_msg_count                     OUT NOCOPY /* file.sql.39 change */ NUMBER
56 ,   x_msg_data                      OUT NOCOPY /* file.sql.39 change */ VARCHAR2
57 ,   p_pricing_attribute_id          IN  NUMBER
58 ,   p_attr_id                       IN  NUMBER
59 ,   p_attr_value                    IN  VARCHAR2
60 ,   p_attribute1                    IN  VARCHAR2
61 ,   p_attribute10                   IN  VARCHAR2
62 ,   p_attribute11                   IN  VARCHAR2
63 ,   p_attribute12                   IN  VARCHAR2
64 ,   p_attribute13                   IN  VARCHAR2
65 ,   p_attribute14                   IN  VARCHAR2
66 ,   p_attribute15                   IN  VARCHAR2
67 ,   p_attribute2                    IN  VARCHAR2
68 ,   p_attribute3                    IN  VARCHAR2
69 ,   p_attribute4                    IN  VARCHAR2
70 ,   p_attribute5                    IN  VARCHAR2
71 ,   p_attribute6                    IN  VARCHAR2
72 ,   p_attribute7                    IN  VARCHAR2
73 ,   p_attribute8                    IN  VARCHAR2
74 ,   p_attribute9                    IN  VARCHAR2
75 ,   p_context                       IN  VARCHAR2
76 ,   x_accumulate_flag               OUT NOCOPY /* file.sql.39 change */ VARCHAR2
77 ,   x_attribute1                    OUT NOCOPY /* file.sql.39 change */ VARCHAR2
78 ,   x_attribute10                   OUT NOCOPY /* file.sql.39 change */ VARCHAR2
79 ,   x_attribute11                   OUT NOCOPY /* file.sql.39 change */ VARCHAR2
80 ,   x_attribute12                   OUT NOCOPY /* file.sql.39 change */ VARCHAR2
81 ,   x_attribute13                   OUT NOCOPY /* file.sql.39 change */ VARCHAR2
82 ,   x_attribute14                   OUT NOCOPY /* file.sql.39 change */ VARCHAR2
83 ,   x_attribute15                   OUT NOCOPY /* file.sql.39 change */ VARCHAR2
84 ,   x_attribute2                    OUT NOCOPY /* file.sql.39 change */ VARCHAR2
85 ,   x_attribute3                    OUT NOCOPY /* file.sql.39 change */ VARCHAR2
86 ,   x_attribute4                    OUT NOCOPY /* file.sql.39 change */ VARCHAR2
87 ,   x_attribute5                    OUT NOCOPY /* file.sql.39 change */ VARCHAR2
88 ,   x_attribute6                    OUT NOCOPY /* file.sql.39 change */ VARCHAR2
89 ,   x_attribute7                    OUT NOCOPY /* file.sql.39 change */ VARCHAR2
90 ,   x_attribute8                    OUT NOCOPY /* file.sql.39 change */ VARCHAR2
91 ,   x_attribute9                    OUT NOCOPY /* file.sql.39 change */ VARCHAR2
92 ,   x_attribute_grouping_no         OUT NOCOPY /* file.sql.39 change */ NUMBER
93 ,   x_context                       OUT NOCOPY /* file.sql.39 change */ VARCHAR2
94 ,   x_excluder_flag                 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
95 ,   x_list_line_id                  OUT NOCOPY /* file.sql.39 change */ NUMBER
96 ,   x_pricing_attribute             OUT NOCOPY /* file.sql.39 change */ VARCHAR2
97 ,   x_pricing_attribute_context     OUT NOCOPY /* file.sql.39 change */ VARCHAR2
98 ,   x_pricing_attribute_id          OUT NOCOPY /* file.sql.39 change */ NUMBER
99 ,   x_pricing_attr_value_from       OUT NOCOPY /* file.sql.39 change */ VARCHAR2
100 ,   x_pricing_attr_value_to         OUT NOCOPY /* file.sql.39 change */ VARCHAR2
101 ,   x_product_attribute             OUT NOCOPY /* file.sql.39 change */ VARCHAR2
102 ,   x_product_attribute_context     OUT NOCOPY /* file.sql.39 change */ VARCHAR2
103 ,   x_product_attr_value            OUT NOCOPY /* file.sql.39 change */ VARCHAR2
104 ,   x_product_uom_code              OUT NOCOPY /* file.sql.39 change */ VARCHAR2
105 ,   x_accumulate                    OUT NOCOPY /* file.sql.39 change */ VARCHAR2
106 ,   x_excluder                      OUT NOCOPY /* file.sql.39 change */ VARCHAR2
107 ,   x_list_line                     OUT NOCOPY /* file.sql.39 change */ VARCHAR2
108 ,   x_product_uom                   OUT NOCOPY /* file.sql.39 change */ VARCHAR2
109 ,   x_product_attribute_datatype    OUT NOCOPY /* file.sql.39 change */ VARCHAR2
110 ,   x_pricing_attribute_datatype    OUT NOCOPY /* file.sql.39 change */ VARCHAR2
111 ,   x_comparison_operator_code      OUT NOCOPY /* file.sql.39 change */ VARCHAR2
112 );
113 
114 --  Procedure       Validate_And_Write
115 --
116 
117 PROCEDURE Validate_And_Write
118 (   x_return_status                 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
119 ,   x_msg_count                     OUT NOCOPY /* file.sql.39 change */ NUMBER
120 ,   x_msg_data                      OUT NOCOPY /* file.sql.39 change */ VARCHAR2
121 ,   p_pricing_attribute_id          IN  NUMBER
122 ,   x_creation_date                 OUT NOCOPY /* file.sql.39 change */ DATE
123 ,   x_created_by                    OUT NOCOPY /* file.sql.39 change */ NUMBER
124 ,   x_last_update_date              OUT NOCOPY /* file.sql.39 change */ DATE
125 ,   x_last_updated_by               OUT NOCOPY /* file.sql.39 change */ NUMBER
126 ,   x_last_update_login             OUT NOCOPY /* file.sql.39 change */ NUMBER
127 );
128 
129 --  Procedure       Delete_Row
130 --
131 
132 PROCEDURE Delete_Row
133 (   x_return_status                 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
134 ,   x_msg_count                     OUT NOCOPY /* file.sql.39 change */ NUMBER
135 ,   x_msg_data                      OUT NOCOPY /* file.sql.39 change */ VARCHAR2
136 ,   p_pricing_attribute_id          IN  NUMBER
137 );
138 
139 --  Procedure       Process_Entity
140 --
141 
142 PROCEDURE Process_Entity
143 (   x_return_status                 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
144 ,   x_msg_count                     OUT NOCOPY /* file.sql.39 change */ NUMBER
145 ,   x_msg_data                      OUT NOCOPY /* file.sql.39 change */ VARCHAR2
146 );
147 
148 --  Procedure       lock_Row
149 --
150 
151 PROCEDURE Lock_Row
152 (   x_return_status                 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
153 ,   x_msg_count                     OUT NOCOPY /* file.sql.39 change */ NUMBER
154 ,   x_msg_data                      OUT NOCOPY /* file.sql.39 change */ VARCHAR2
155 ,   p_accumulate_flag               IN  VARCHAR2
156 ,   p_attribute1                    IN  VARCHAR2
157 ,   p_attribute10                   IN  VARCHAR2
158 ,   p_attribute11                   IN  VARCHAR2
159 ,   p_attribute12                   IN  VARCHAR2
160 ,   p_attribute13                   IN  VARCHAR2
161 ,   p_attribute14                   IN  VARCHAR2
162 ,   p_attribute15                   IN  VARCHAR2
163 ,   p_attribute2                    IN  VARCHAR2
164 ,   p_attribute3                    IN  VARCHAR2
165 ,   p_attribute4                    IN  VARCHAR2
166 ,   p_attribute5                    IN  VARCHAR2
167 ,   p_attribute6                    IN  VARCHAR2
168 ,   p_attribute7                    IN  VARCHAR2
169 ,   p_attribute8                    IN  VARCHAR2
170 ,   p_attribute9                    IN  VARCHAR2
171 ,   p_attribute_grouping_no         IN  NUMBER
172 ,   p_context                       IN  VARCHAR2
173 ,   p_created_by                    IN  NUMBER
174 ,   p_creation_date                 IN  DATE
175 ,   p_excluder_flag                 IN  VARCHAR2
176 ,   p_last_updated_by               IN  NUMBER
177 ,   p_last_update_date              IN  DATE
178 ,   p_last_update_login             IN  NUMBER
179 ,   p_list_line_id                  IN  NUMBER
180 ,   p_pricing_attribute             IN  VARCHAR2
181 ,   p_pricing_attribute_context     IN  VARCHAR2
182 ,   p_pricing_attribute_id          IN  NUMBER
183 ,   p_pricing_attr_value_from       IN  VARCHAR2
184 ,   p_pricing_attr_value_to         IN  VARCHAR2
185 ,   p_product_attribute             IN  VARCHAR2
186 ,   p_product_attribute_context     IN  VARCHAR2
187 ,   p_product_attr_value            IN  VARCHAR2
188 ,   p_product_uom_code              IN  VARCHAR2
189 ,   p_program_application_id        IN  NUMBER
190 ,   p_program_id                    IN  NUMBER
191 ,   p_program_update_date           IN  DATE
192 ,   p_request_id                    IN  NUMBER
193 ,   p_product_attribute_datatype    IN  VARCHAR2
194 ,   p_pricing_attribute_datatype    IN  VARCHAR2
195 ,   p_comparison_operator_code      IN  VARCHAR2
196 );
197 
198 
199 
200 FUNCTION Get_MEANING
201 (   p_lookup_code                     IN  QP_LOOKUPS.lookup_code%type
202  ,  p_lookup_type                     IN  QP_LOOKUPS.lookup_type%type
203 )
204 RETURN QP_LOOKUPS.Meaning%Type;
205 
206 FUNCTION Get_Pricing_Phase
207 (   p_pricing_phase_id                     IN  QP_PRICING_PHASES.Pricing_Phase_ID%type
208 )
209 RETURN QP_PRICING_PHASES.Name%Type;
210 
211 /* added list_header_id for  freight and spl. charges Bug#4562869   */
212 FUNCTION Get_Charge_name
213 (   p_list_header_id                       IN  qp_list_headers_b.list_header_id%type
214  ,  p_Charge_Type_code                     IN  QP_CHARGE_LOOKUP.lookup_code%type
215  ,  p_Charge_Subtype_code                  IN  QP_LOOKUPS.lookup_code%type
216  ,  p_list_line_type_code                  IN  QP_LIST_LINES.list_line_type_code%type
217 )
218 RETURN QP_LOOKUPS.Meaning%Type;
219 
220 FUNCTION Get_Formula
221 (   p_Price_By_Formula_Id                     IN  QP_PRICE_FORMULAS_VL.Price_Formula_ID%type
222 )
223 RETURN QP_PRICE_FORMULAS_VL.Name%Type;
224 
225 FUNCTION Get_Expiration_Date
226 (   p_list_line_id                     IN  QP_LIST_LINES.list_line_id%type
227 ,   p_modifier_type_code               IN  QP_LIST_LINES.list_line_type_code%type
228 )
229 RETURN QP_LIST_LINES.Expiration_Date%Type;
230 
231 FUNCTION Get_Exp_Period_Start_Date
232 (   p_list_line_id                     IN  QP_LIST_LINES.list_line_id%type
233 ,   p_modifier_type_code               IN  QP_LIST_LINES.list_line_type_code%type
234 )
235 RETURN QP_LIST_LINES.Expiration_Period_Start_Date%Type;
236 
237 FUNCTION Get_Number_Expiration_Periods
238 (   p_list_line_id                     IN  QP_LIST_LINES.list_line_id%type
239 ,   p_modifier_type_code               IN  QP_LIST_LINES.list_line_type_code%type
240 )
241 RETURN QP_LIST_LINES.Number_Expiration_Periods%Type;
242 
243 FUNCTION Get_Expiration_Period_UOM
244 (   p_list_line_id                     IN  QP_LIST_LINES.list_line_id%type
245 ,   p_modifier_type_code               IN  QP_LIST_LINES.list_line_type_code%type
246 )
247 RETURN QP_LIST_LINES.Expiration_Period_UOM%Type;
248 
249 FUNCTION Get_Rebate_Txn_Type
250 (   p_list_line_id                     IN  QP_LIST_LINES.list_line_id%type
251 ,   p_modifier_type_code               IN  QP_LIST_LINES.list_line_type_code%type
252 ,   p_list_line_type_code			IN QP_LIST_LINES.list_line_type_code%type
253 ,   p_rebate_transaction_type_code      IN QP_LIST_LINES.REBATE_TRANSACTION_TYPE_CODE%type
254 )
255 RETURN QP_LOOKUPS.Meaning%Type;
256 
257 FUNCTION Get_Benefit_Qty
258 (   p_list_line_id                     IN  QP_LIST_LINES.list_line_id%type
259 ,   p_modifier_type_code               IN  QP_LIST_LINES.list_line_type_code%type
260 )
261 RETURN QP_LIST_LINES.Benefit_Qty%Type;
262 
263 FUNCTION Get_Benefit_UOM_Code
264 (   p_list_line_id                     IN  QP_LIST_LINES.list_line_id%type
265 ,   p_modifier_type_code               IN  QP_LIST_LINES.list_line_type_code%type
266 )
267 RETURN QP_LIST_LINES.Benefit_UOM_Code%Type;
268 
269 FUNCTION Get_Benefit_List_Line_No
270 (   p_list_line_id              IN  QP_LIST_LINES.list_line_id%type
271 ,   p_modifier_type_code        IN  QP_LIST_LINES.list_line_type_code%type
272 )
273 RETURN QP_LIST_LINES.List_Line_No%Type;
274 
275 FUNCTION Get_Accrual_Flag
276 (   p_list_line_id                     IN  QP_LIST_LINES.list_line_id%type
277 ,   p_modifier_type_code               IN  QP_LIST_LINES.list_line_type_code%type
278 )
279 RETURN QP_LIST_LINES.Accrual_Flag%Type;
280 
281 FUNCTION Get_Accrual_Conversion_Rate
282 (   p_list_line_id                     IN  QP_LIST_LINES.list_line_id%type
283 ,   p_modifier_type_code               IN  QP_LIST_LINES.list_line_type_code%type
284 )
285 RETURN QP_LIST_LINES.Accrual_Conversion_Rate%Type;
286 
287 FUNCTION Get_Estim_Accrual_Rate
288 (   p_list_line_id                     IN  QP_LIST_LINES.list_line_id%type
289 ,   p_modifier_type_code               IN  QP_LIST_LINES.list_line_type_code%type
290 )
291 RETURN QP_LIST_LINES.Estim_Accrual_Rate%Type;
292 
293 FUNCTION Get_Break_Line_Type_Code
294 (   p_list_line_id                     IN  QP_LIST_LINES.list_line_id%type
295 ,   p_modifier_type_code               IN  QP_LIST_LINES.list_line_type_code%type
296 )
297 RETURN QP_LIST_LINES.List_Line_Type_Code%Type;
298 
299 FUNCTION Get_Break_Line_Type
300 (   p_list_line_id                     IN  QP_LIST_LINES.list_line_id%type
301 ,   p_modifier_type_code               IN  QP_LIST_LINES.list_line_type_code%type
302 ,   p_break_line_type_code              IN QP_LIST_LINES.list_line_type_code%type
303 )
304 RETURN QP_LOOKUPS.Meaning%Type;
305 
306   FUNCTION Get_Context(p_FlexField_Name  IN VARCHAR2
307 				    ,p_context    IN VARCHAR2)RETURN VARCHAR2;
308 
309 PROCEDURE Get_Attribute_Code(p_FlexField_Name IN VARCHAR2
310 					   ,p_Context_Name   IN VARCHAR2
311 					   ,p_attribute      IN VARCHAR2
312                             ,p_attribute_col_name  IN VARCHAR2
313 					   ,x_attribute_code OUT NOCOPY /* file.sql.39 change */ VARCHAR2
314 					   ,x_segment_name   OUT NOCOPY /* file.sql.39 change */ VARCHAR2
315 					   );
316 
317 FUNCTION Get_Attribute
318 (   p_FlexField_Name IN VARCHAR2
319 ,   p_Context_Name   IN VARCHAR2
320 ,   p_attribute      IN VARCHAR2
321 )
322 RETURN VARCHAR2;
323 
324 FUNCTION Get_Segment_name
325 (   p_FlexField_Name IN VARCHAR2
326 ,   p_Context_Name   IN VARCHAR2
327 ,   p_attribute      IN VARCHAR2
328 )
329 RETURN VARCHAR2;
330 
331 
332 FUNCTION Get_Attribute_Value(	 p_FlexField_Name       IN VARCHAR2
333 						,p_Context_Name         IN VARCHAR2
334 						,p_attribute         	  IN VARCHAR2
335 						,p_attr_value IN VARCHAR2
336                             	,p_attribute_val_col_name   IN VARCHAR2 := NULL
337 						,p_comparison_operator_code IN VARCHAR2 := NULL
338 					    ) RETURN VARCHAR2;
339 
340 FUNCTION Get_Attr_Value_To(	 p_FlexField_Name       IN VARCHAR2
341 						,p_Context_Name         IN VARCHAR2
342 						,p_segment_name         IN VARCHAR2
343 						,p_attr_value_To        IN VARCHAR2
344 					  ) RETURN VARCHAR2;
345 
346 FUNCTION Get_To_Rltd_Modifier_ID
347 (   p_list_line_id   		IN QP_LIST_LINES.List_Line_ID%Type
348 ,   p_modifier_type_code      IN  QP_LIST_LINES.list_line_type_code%type
349 )
350 RETURN QP_RLTD_MODIFIERS.To_Rltd_Modifier_ID%Type;
351 
352 FUNCTION Get_Rltd_Modifier_ID
353 (   p_list_line_id   		IN QP_LIST_LINES.List_Line_ID%Type
354 ,   p_modifier_type_code      IN  QP_LIST_LINES.list_line_type_code%type
355 )
356 RETURN QP_RLTD_MODIFIERS.Rltd_Modifier_ID%Type;
357 
358 FUNCTION Get_Rltd_Modifier_Grp_Type
359 (   p_list_line_id   		IN QP_LIST_LINES.List_Line_ID%Type
360 ,   p_modifier_type_code      IN  QP_LIST_LINES.list_line_type_code%type
361 )
362 RETURN QP_RLTD_MODIFIERS.Rltd_Modifier_Grp_Type%Type;
363 
364 FUNCTION Get_Rltd_Modifier_Grp_No
365 (   p_list_line_id   		IN QP_LIST_LINES.List_Line_ID%Type
366 ,   p_modifier_type_code      IN  QP_LIST_LINES.list_line_type_code%type
367 )
368 RETURN QP_RLTD_MODIFIERS.Rltd_Modifier_Grp_No%Type;
369 
370 
371 --for canonical datafix in tst115
372 FUNCTION Get_datatype
373 (   p_flexfield_name                 IN  VARCHAR2
374 ,   p_Context                      IN  QP_PRICING_ATTRIBUTES.Pricing_Attribute_Context%type
375 ,   p_Attribute                    IN  QP_PRICING_ATTRIBUTES.Pricing_Attribute%Type
376 )
377 RETURN QP_PRICING_ATTRIBUTES.Pricing_Attribute_Datatype%Type;
378 
379 
380 
381 -- added by svdeshmu for delayed request on  April 07 ,00
382 
383 Procedure Clear_Record
384 (   x_return_status                 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
385 ,   x_msg_count                     OUT NOCOPY /* file.sql.39 change */ NUMBER
386 ,   x_msg_data                      OUT NOCOPY /* file.sql.39 change */ VARCHAR2
387 ,   p_list_line_id                IN  NUMBER
388 );
389 
390 
391 
392 -- End of additions by svdeshmu for delayed request
393 
394 
395 
396 
397 
398 
399 
400 
401 END QP_QP_Form_Pricing_Attr;