[Home] [Help]
PACKAGE: APPS.QP_QP_FORM_PRICE_LIST_LINE
Source
1 PACKAGE QP_QP_Form_Price_List_Line AS
2 /* $Header: QPXFPLLS.pls 120.2 2006/02/22 06:20:48 prarasto noship $ */
3
4 -- Procedure : Default_Attributes
5 --
6
7 PROCEDURE Default_Attributes
8 ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
9 , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
10 , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
11 , p_list_header_id IN NUMBER
12 , x_accrual_qty OUT NOCOPY /* file.sql.39 change */ NUMBER
13 , x_accrual_uom_code OUT NOCOPY /* file.sql.39 change */ VARCHAR2
14 , x_arithmetic_operator OUT NOCOPY /* file.sql.39 change */ VARCHAR2
15 , x_attribute1 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
16 , x_attribute10 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
17 , x_attribute11 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
18 , x_attribute12 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
19 , x_attribute13 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
20 , x_attribute14 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
21 , x_attribute15 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
22 , x_attribute2 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
23 , x_attribute3 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
24 , x_attribute4 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
25 , x_attribute5 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
26 , x_attribute6 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
27 , x_attribute7 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
28 , x_attribute8 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
29 , x_attribute9 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
30 , x_automatic_flag OUT NOCOPY /* file.sql.39 change */ VARCHAR2
31 , x_base_qty OUT NOCOPY /* file.sql.39 change */ NUMBER
32 , x_base_uom_code OUT NOCOPY /* file.sql.39 change */ VARCHAR2
33 , x_comments OUT NOCOPY /* file.sql.39 change */ VARCHAR2
34 , x_context OUT NOCOPY /* file.sql.39 change */ VARCHAR2
35 , x_effective_period_uom OUT NOCOPY /* file.sql.39 change */ VARCHAR2
36 , x_end_date_active OUT NOCOPY /* file.sql.39 change */ DATE
37 , x_estim_accrual_rate OUT NOCOPY /* file.sql.39 change */ NUMBER
38 , x_generate_using_formula_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_from_rltd_modifier_id OUT NOCOPY /* file.sql.39 change */ NUMBER
45 , x_rltd_modifier_group_no OUT NOCOPY /* file.sql.39 change */ NUMBER
46 , x_product_precedence OUT NOCOPY /* file.sql.39 change */ NUMBER
47 , x_modifier_level_code OUT NOCOPY /* file.sql.39 change */ VARCHAR2
48 , x_number_effective_periods OUT NOCOPY /* file.sql.39 change */ NUMBER
49 , x_operand OUT NOCOPY /* file.sql.39 change */ NUMBER
50 , x_organization_id OUT NOCOPY /* file.sql.39 change */ NUMBER
51 , x_override_flag OUT NOCOPY /* file.sql.39 change */ VARCHAR2
52 , x_percent_price OUT NOCOPY /* file.sql.39 change */ NUMBER
53 , x_price_break_type_code OUT NOCOPY /* file.sql.39 change */ VARCHAR2
54 , x_price_by_formula_id OUT NOCOPY /* file.sql.39 change */ NUMBER
55 , x_primary_uom_flag OUT NOCOPY /* file.sql.39 change */ VARCHAR2
56 , x_print_on_invoice_flag 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_accrual_uom OUT NOCOPY /* file.sql.39 change */ VARCHAR2
69 , x_automatic OUT NOCOPY /* file.sql.39 change */ VARCHAR2
70 , x_base_uom OUT NOCOPY /* file.sql.39 change */ VARCHAR2
71 , x_generate_using_formula 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_modifier_level OUT NOCOPY /* file.sql.39 change */ VARCHAR2
77 , x_organization OUT NOCOPY /* file.sql.39 change */ VARCHAR2
78 , x_override OUT NOCOPY /* file.sql.39 change */ VARCHAR2
79 , x_price_break_type OUT NOCOPY /* file.sql.39 change */ VARCHAR2
80 , x_price_by_formula OUT NOCOPY /* file.sql.39 change */ VARCHAR2
81 , x_primary_uom OUT NOCOPY /* file.sql.39 change */ VARCHAR2
82 , x_print_on_invoice OUT NOCOPY /* file.sql.39 change */ VARCHAR2
83 , x_rebate_transaction_type OUT NOCOPY /* file.sql.39 change */ VARCHAR2
84 , x_related_item OUT NOCOPY /* file.sql.39 change */ VARCHAR2
85 , x_relationship_type OUT NOCOPY /* file.sql.39 change */ VARCHAR2
86 , x_reprice OUT NOCOPY /* file.sql.39 change */ VARCHAR2
87 , x_revision_reason OUT NOCOPY /* file.sql.39 change */ VARCHAR2
88 , p_from_rltd_modifier_id IN NUMBER := NULL
89 , x_recurring_value OUT NOCOPY /* file.sql.39 change */ NUMBER -- block pricing
90 , x_customer_item_id OUT NOCOPY /* file.sql.39 change */ NUMBER
91 , x_break_uom_code OUT NOCOPY /* file.sql.39 change */ VARCHAR2 -- OKS proration
92 , x_break_uom_context OUT NOCOPY /* file.sql.39 change */ VARCHAR2 -- OKS
93 , x_break_uom_attribute OUT NOCOPY /* file.sql.39 change */ VARCHAR2 -- OKS proration
94 , x_continuous_price_break_flag OUT NOCOPY VARCHAR2 --Continuous Price Breaks
95 );
96
97 -- Procedure : Change_Attribute
98 --
99
100 PROCEDURE Change_Attribute
101 ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
102 , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
103 , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
104 , p_list_line_id IN NUMBER
105 , p_attr_id IN NUMBER
106 , p_attr_value IN VARCHAR2
107 , p_attribute1 IN VARCHAR2
108 , p_attribute10 IN VARCHAR2
109 , p_attribute11 IN VARCHAR2
110 , p_attribute12 IN VARCHAR2
111 , p_attribute13 IN VARCHAR2
112 , p_attribute14 IN VARCHAR2
113 , p_attribute15 IN VARCHAR2
114 , p_attribute2 IN VARCHAR2
115 , p_attribute3 IN VARCHAR2
116 , p_attribute4 IN VARCHAR2
117 , p_attribute5 IN VARCHAR2
118 , p_attribute6 IN VARCHAR2
119 , p_attribute7 IN VARCHAR2
120 , p_attribute8 IN VARCHAR2
121 , p_attribute9 IN VARCHAR2
122 , p_context IN VARCHAR2
123 , x_accrual_qty OUT NOCOPY /* file.sql.39 change */ NUMBER
124 , x_accrual_uom_code OUT NOCOPY /* file.sql.39 change */ VARCHAR2
125 , x_arithmetic_operator OUT NOCOPY /* file.sql.39 change */ VARCHAR2
126 , x_attribute1 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
127 , x_attribute10 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
128 , x_attribute11 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
129 , x_attribute12 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
130 , x_attribute13 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
131 , x_attribute14 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
132 , x_attribute15 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
133 , x_attribute2 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
134 , x_attribute3 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
135 , x_attribute4 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
136 , x_attribute5 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
137 , x_attribute6 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
138 , x_attribute7 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
139 , x_attribute8 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
140 , x_attribute9 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
141 , x_automatic_flag OUT NOCOPY /* file.sql.39 change */ VARCHAR2
142 , x_base_qty OUT NOCOPY /* file.sql.39 change */ NUMBER
143 , x_base_uom_code OUT NOCOPY /* file.sql.39 change */ VARCHAR2
144 , x_comments OUT NOCOPY /* file.sql.39 change */ VARCHAR2
145 , x_context OUT NOCOPY /* file.sql.39 change */ VARCHAR2
146 , x_effective_period_uom OUT NOCOPY /* file.sql.39 change */ VARCHAR2
147 , x_end_date_active OUT NOCOPY /* file.sql.39 change */ DATE
148 , x_estim_accrual_rate OUT NOCOPY /* file.sql.39 change */ NUMBER
149 , x_generate_using_formula_id OUT NOCOPY /* file.sql.39 change */ NUMBER
150 , x_inventory_item_id OUT NOCOPY /* file.sql.39 change */ NUMBER
151 , x_list_header_id OUT NOCOPY /* file.sql.39 change */ NUMBER
152 , x_list_line_id OUT NOCOPY /* file.sql.39 change */ NUMBER
153 , x_list_line_type_code OUT NOCOPY /* file.sql.39 change */ VARCHAR2
154 , x_list_price OUT NOCOPY /* file.sql.39 change */ NUMBER
155 , x_from_rltd_modifier_id OUT NOCOPY /* file.sql.39 change */ NUMBER
156 , x_rltd_modifier_group_no OUT NOCOPY /* file.sql.39 change */ NUMBER
157 , x_product_precedence OUT NOCOPY /* file.sql.39 change */ NUMBER
158 , x_modifier_level_code OUT NOCOPY /* file.sql.39 change */ VARCHAR2
159 , x_number_effective_periods OUT NOCOPY /* file.sql.39 change */ NUMBER
160 , x_operand OUT NOCOPY /* file.sql.39 change */ NUMBER
161 , x_organization_id OUT NOCOPY /* file.sql.39 change */ NUMBER
162 , x_override_flag OUT NOCOPY /* file.sql.39 change */ VARCHAR2
163 , x_percent_price OUT NOCOPY /* file.sql.39 change */ NUMBER
164 , x_price_break_type_code OUT NOCOPY /* file.sql.39 change */ VARCHAR2
165 , x_price_by_formula_id OUT NOCOPY /* file.sql.39 change */ NUMBER
166 , x_primary_uom_flag OUT NOCOPY /* file.sql.39 change */ VARCHAR2
167 , x_print_on_invoice_flag OUT NOCOPY /* file.sql.39 change */ VARCHAR2
168 , x_rebate_trxn_type_code OUT NOCOPY /* file.sql.39 change */ VARCHAR2
169 , x_related_item_id OUT NOCOPY /* file.sql.39 change */ NUMBER
170 , x_relationship_type_id OUT NOCOPY /* file.sql.39 change */ NUMBER
171 , x_reprice_flag OUT NOCOPY /* file.sql.39 change */ VARCHAR2
172 , x_revision OUT NOCOPY /* file.sql.39 change */ VARCHAR2
173 , x_revision_date OUT NOCOPY /* file.sql.39 change */ DATE
174 , x_revision_reason_code OUT NOCOPY /* file.sql.39 change */ VARCHAR2
175 , x_start_date_active OUT NOCOPY /* file.sql.39 change */ DATE
176 , x_substitution_attribute OUT NOCOPY /* file.sql.39 change */ VARCHAR2
177 , x_substitution_context OUT NOCOPY /* file.sql.39 change */ VARCHAR2
178 , x_substitution_value OUT NOCOPY /* file.sql.39 change */ VARCHAR2
179 , x_accrual_uom OUT NOCOPY /* file.sql.39 change */ VARCHAR2
180 , x_automatic OUT NOCOPY /* file.sql.39 change */ VARCHAR2
181 , x_base_uom OUT NOCOPY /* file.sql.39 change */ VARCHAR2
182 , x_generate_using_formula OUT NOCOPY /* file.sql.39 change */ VARCHAR2
183 , x_inventory_item OUT NOCOPY /* file.sql.39 change */ VARCHAR2
184 , x_list_header OUT NOCOPY /* file.sql.39 change */ VARCHAR2
185 , x_list_line OUT NOCOPY /* file.sql.39 change */ VARCHAR2
186 , x_list_line_type OUT NOCOPY /* file.sql.39 change */ VARCHAR2
187 , x_modifier_level OUT NOCOPY /* file.sql.39 change */ VARCHAR2
188 , x_organization OUT NOCOPY /* file.sql.39 change */ VARCHAR2
189 , x_override OUT NOCOPY /* file.sql.39 change */ VARCHAR2
190 , x_price_break_type OUT NOCOPY /* file.sql.39 change */ VARCHAR2
191 , x_price_by_formula OUT NOCOPY /* file.sql.39 change */ VARCHAR2
192 , x_primary_uom OUT NOCOPY /* file.sql.39 change */ VARCHAR2
193 , x_print_on_invoice OUT NOCOPY /* file.sql.39 change */ VARCHAR2
194 , x_rebate_transaction_type OUT NOCOPY /* file.sql.39 change */ VARCHAR2
195 , x_related_item OUT NOCOPY /* file.sql.39 change */ VARCHAR2
196 , x_relationship_type OUT NOCOPY /* file.sql.39 change */ VARCHAR2
197 , x_reprice OUT NOCOPY /* file.sql.39 change */ VARCHAR2
198 , x_revision_reason OUT NOCOPY /* file.sql.39 change */ VARCHAR2
199 , x_recurring_value OUT NOCOPY /* file.sql.39 change */ NUMBER -- block pricing
200 , x_customer_item_id OUT NOCOPY /* file.sql.39 change */ NUMBER
201 , x_break_uom_code OUT NOCOPY /* file.sql.39 change */ VARCHAR2 -- OKS proration
202 , x_break_uom_context OUT NOCOPY /* file.sql.39 change */ VARCHAR2 -- OKS
203 , x_break_uom_attribute OUT NOCOPY /* file.sql.39 change */ VARCHAR2 -- OKS proration
204 , x_continuous_price_break_flag OUT NOCOPY VARCHAR2 --Continuous Price Breaks
205 );
206
207 -- Procedure Validate_And_Write
208 --
209
210 PROCEDURE Validate_And_Write
211 ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
212 , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
213 , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
214 , p_list_line_id IN NUMBER
215 , x_creation_date OUT NOCOPY /* file.sql.39 change */ DATE
216 , x_created_by OUT NOCOPY /* file.sql.39 change */ NUMBER
217 , x_last_update_date OUT NOCOPY /* file.sql.39 change */ DATE
218 , x_last_updated_by OUT NOCOPY /* file.sql.39 change */ NUMBER
219 , x_last_update_login OUT NOCOPY /* file.sql.39 change */ NUMBER
220 , x_program_application_id OUT NOCOPY /* file.sql.39 change */ NUMBER
221 , x_program_id OUT NOCOPY /* file.sql.39 change */ NUMBER
222 , x_program_update_date OUT NOCOPY /* file.sql.39 change */ DATE
223 , x_request_id OUT NOCOPY /* file.sql.39 change */ NUMBER
224 );
225
226 -- Procedure Delete_Row
227 --
228
229 PROCEDURE Delete_Row
230 ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
231 , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
232 , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
236 -- Procedure Process_Entity
233 , p_list_line_id IN NUMBER
234 );
235
237 --
238
239 PROCEDURE Process_Entity
240 ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
241 , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
242 , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
243 );
244
245 -- Procedure lock_Row
246 --
247
248 PROCEDURE Lock_Row
249 ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
250 , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
251 , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
252 , p_accrual_qty IN NUMBER
253 , p_accrual_uom_code IN VARCHAR2
254 , p_arithmetic_operator IN VARCHAR2
255 , p_attribute1 IN VARCHAR2
256 , p_attribute10 IN VARCHAR2
257 , p_attribute11 IN VARCHAR2
258 , p_attribute12 IN VARCHAR2
259 , p_attribute13 IN VARCHAR2
260 , p_attribute14 IN VARCHAR2
261 , p_attribute15 IN VARCHAR2
262 , p_attribute2 IN VARCHAR2
263 , p_attribute3 IN VARCHAR2
264 , p_attribute4 IN VARCHAR2
265 , p_attribute5 IN VARCHAR2
266 , p_attribute6 IN VARCHAR2
267 , p_attribute7 IN VARCHAR2
268 , p_attribute8 IN VARCHAR2
269 , p_attribute9 IN VARCHAR2
270 , p_automatic_flag IN VARCHAR2
271 , p_base_qty IN NUMBER
272 , p_base_uom_code IN VARCHAR2
273 , p_comments IN VARCHAR2
274 , p_context IN VARCHAR2
275 , p_created_by IN NUMBER
276 , p_creation_date IN DATE
277 , p_effective_period_uom IN VARCHAR2
278 , p_end_date_active IN DATE
279 , p_estim_accrual_rate IN NUMBER
280 , p_generate_using_formula_id IN NUMBER
281 , p_inventory_item_id IN NUMBER
282 , p_last_updated_by IN NUMBER
283 , p_last_update_date IN DATE
284 , p_last_update_login IN NUMBER
285 , p_list_header_id IN NUMBER
286 , p_list_line_id IN NUMBER
287 , p_list_line_type_code IN VARCHAR2
288 , p_list_price IN NUMBER
289 , p_product_precedence IN NUMBER
290 , p_modifier_level_code IN VARCHAR2
291 , p_number_effective_periods IN NUMBER
292 , p_operand IN NUMBER
293 , p_organization_id IN NUMBER
294 , p_override_flag IN VARCHAR2
295 , p_percent_price IN NUMBER
296 , p_price_break_type_code IN VARCHAR2
297 , p_price_by_formula_id IN NUMBER
298 , p_primary_uom_flag IN VARCHAR2
299 , p_print_on_invoice_flag IN VARCHAR2
300 , p_program_application_id IN NUMBER
301 , p_program_id IN NUMBER
302 , p_program_update_date IN DATE
303 , p_rebate_trxn_type_code IN VARCHAR2
304 , p_related_item_id IN NUMBER
305 , p_relationship_type_id IN NUMBER
306 , p_reprice_flag IN VARCHAR2
307 , p_request_id IN NUMBER
308 , p_revision IN VARCHAR2
309 , p_revision_date IN DATE
310 , p_revision_reason_code IN VARCHAR2
311 , p_start_date_active IN DATE
312 , p_substitution_attribute IN VARCHAR2
313 , p_substitution_context IN VARCHAR2
314 , p_substitution_value IN VARCHAR2
315 , p_recurring_value IN NUMBER -- block pricing
316 , p_customer_item_id IN NUMBER
317 , p_break_uom_code IN VARCHAR2 -- OKS proration
318 , p_break_uom_context IN VARCHAR2 -- OKS
319 , p_break_uom_attribute IN VARCHAR2 -- OKS proration
320 , p_continuous_price_break_flag IN VARCHAR2 --Continuous Price Breaks
321 );
322
323 Procedure Clear_Record
324 ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
325 , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
326 , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
327 , p_list_line_id IN NUMBER
328 );
329
330 Procedure Delete_All_Requests
331 ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
332 , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
333 , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
334 );
335
336 END QP_QP_Form_Price_List_Line;