[Home] [Help]
PACKAGE: APPS.OE_OE_FORM_HEADER_PATTR
Source
1 PACKAGE OE_OE_Form_Header_PAttr AS
2 /* $Header: OEXFHPAS.pls 120.0 2005/06/01 23:01:17 appldev noship $ */
3
4 PROCEDURE Default_Attributes
5 ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
6 , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
7 , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
8 , p_header_id in NUMBER
9 , p_line_id in NUMBER
10 , x_attribute1 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
11 , x_attribute10 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
12 , x_attribute11 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
13 , x_attribute12 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
14 , x_attribute13 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
15 , x_attribute14 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
16 , x_attribute15 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
17 , x_attribute2 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
18 , x_attribute3 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
19 , x_attribute4 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
20 , x_attribute5 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
21 , x_attribute6 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
22 , x_attribute7 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
23 , x_attribute8 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
24 , x_attribute9 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
25 , x_flex_title OUT NOCOPY /* file.sql.39 change */ VARCHAR2
26 , x_context OUT NOCOPY /* file.sql.39 change */ VARCHAR2
27 , x_header_id OUT NOCOPY /* file.sql.39 change */ NUMBER
28 , x_line_id OUT NOCOPY /* file.sql.39 change */ NUMBER
29 , x_order_price_attrib_id OUT NOCOPY /* file.sql.39 change */ NUMBER
30 , x_pricing_attribute1 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
31 , x_pricing_attribute10 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
32 , x_pricing_attribute11 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
33 , x_pricing_attribute12 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
34 , x_pricing_attribute13 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
35 , x_pricing_attribute14 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
36 , x_pricing_attribute15 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
37 , x_pricing_attribute2 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
38 , x_pricing_attribute3 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
39 , x_pricing_attribute4 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
40 , x_pricing_attribute5 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
41 , x_pricing_attribute6 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
42 , x_pricing_attribute7 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
43 , x_pricing_attribute8 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
44 , x_pricing_attribute9 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
45 , x_pricing_attribute16 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
46 , x_pricing_attribute17 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
47 , x_pricing_attribute18 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
48 , x_pricing_attribute19 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
49 , x_pricing_attribute20 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
50 , x_pricing_attribute21 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
51 , x_pricing_attribute22 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
52 , x_pricing_attribute23 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
53 , x_pricing_attribute24 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
54 , x_pricing_attribute25 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
55 , x_pricing_attribute26 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
56 , x_pricing_attribute27 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
57 , x_pricing_attribute28 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
58 , x_pricing_attribute29 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
59 , x_pricing_attribute30 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
60 , x_pricing_attribute31 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
61 , x_pricing_attribute32 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
62 , x_pricing_attribute33 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
63 , x_pricing_attribute34 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
64 , x_pricing_attribute35 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
65 , x_pricing_attribute36 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
66 , x_pricing_attribute37 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
67 , x_pricing_attribute38 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
68 , x_pricing_attribute39 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
69 , x_pricing_attribute40 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
70 , x_pricing_attribute41 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
71 , x_pricing_attribute42 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
72 , x_pricing_attribute43 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
73 , x_pricing_attribute44 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
74 , x_pricing_attribute45 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
75 , x_pricing_attribute46 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
76 , x_pricing_attribute47 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
77 , x_pricing_attribute48 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
78 , x_pricing_attribute49 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
79 , x_pricing_attribute50 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
80 , x_pricing_attribute51 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
81 , x_pricing_attribute52 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
82 , x_pricing_attribute53 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
83 , x_pricing_attribute54 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
84 , x_pricing_attribute55 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
85 , x_pricing_attribute56 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
86 , x_pricing_attribute57 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
87 , x_pricing_attribute58 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
88 , x_pricing_attribute59 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
89 , x_pricing_attribute60 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
90 , x_pricing_attribute61 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
91 , x_pricing_attribute62 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
92 , x_pricing_attribute63 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
93 , x_pricing_attribute64 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
94 , x_pricing_attribute65 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
95 , x_pricing_attribute66 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
96 , x_pricing_attribute67 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
97 , x_pricing_attribute68 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
98 , x_pricing_attribute69 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
99 , x_pricing_attribute70 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
100 , x_pricing_attribute71 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
101 , x_pricing_attribute72 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
102 , x_pricing_attribute73 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
103 , x_pricing_attribute74 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
104 , x_pricing_attribute75 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
105 , x_pricing_attribute76 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
106 , x_pricing_attribute77 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
107 , x_pricing_attribute78 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
108 , x_pricing_attribute79 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
109 , x_pricing_attribute80 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
110 , x_pricing_attribute81 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
111 , x_pricing_attribute82 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
112 , x_pricing_attribute83 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
113 , x_pricing_attribute84 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
114 , x_pricing_attribute85 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
115 , x_pricing_attribute86 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
116 , x_pricing_attribute87 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
117 , x_pricing_attribute88 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
118 , x_pricing_attribute89 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
119 , x_pricing_attribute90 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
120 , x_pricing_attribute91 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
121 , x_pricing_attribute92 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
122 , x_pricing_attribute93 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
123 , x_pricing_attribute94 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
124 , x_pricing_attribute95 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
125 , x_pricing_attribute96 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
126 , x_pricing_attribute97 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
127 , x_pricing_attribute98 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
128 , x_pricing_attribute99 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
129 , x_pricing_attribute100 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
130 , x_pricing_context OUT NOCOPY /* file.sql.39 change */ VARCHAR2
131 , x_override_flag OUT NOCOPY /* file.sql.39 change */ VARCHAR2
132 , x_creation_date OUT NOCOPY /* file.sql.39 change */ DATE
133 );
134
135 PROCEDURE Default_Attributes
136 ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
137 , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
138 , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
139 , p_header_id in NUMBER
140 , p_line_id in NUMBER
141 , x_attribute1 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
142 , x_attribute10 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
143 , x_attribute11 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
144 , x_attribute12 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
145 , x_attribute13 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
146 , x_attribute14 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
147 , x_attribute15 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
148 , x_attribute2 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
149 , x_attribute3 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
150 , x_attribute4 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
151 , x_attribute5 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
152 , x_attribute6 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
153 , x_attribute7 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
154 , x_attribute8 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
155 , x_attribute9 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
156 , x_flex_title OUT NOCOPY /* file.sql.39 change */ VARCHAR2
157 , x_context OUT NOCOPY /* file.sql.39 change */ VARCHAR2
158 , x_header_id OUT NOCOPY /* file.sql.39 change */ NUMBER
159 , x_line_id OUT NOCOPY /* file.sql.39 change */ NUMBER
160 , x_order_price_attrib_id OUT NOCOPY /* file.sql.39 change */ NUMBER
161 , x_pricing_attribute1 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
162 , x_pricing_attribute10 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
163 , x_pricing_attribute11 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
164 , x_pricing_attribute12 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
165 , x_pricing_attribute13 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
166 , x_pricing_attribute14 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
167 , x_pricing_attribute15 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
168 , x_pricing_attribute2 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
169 , x_pricing_attribute3 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
170 , x_pricing_attribute4 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
171 , x_pricing_attribute5 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
172 , x_pricing_attribute6 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
173 , x_pricing_attribute7 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
174 , x_pricing_attribute8 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
175 , x_pricing_attribute9 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
176 , x_pricing_attribute16 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
177 , x_pricing_attribute17 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
178 , x_pricing_attribute18 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
179 , x_pricing_attribute19 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
180 , x_pricing_attribute20 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
181 , x_pricing_attribute21 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
182 , x_pricing_attribute22 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
183 , x_pricing_attribute23 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
184 , x_pricing_attribute24 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
185 , x_pricing_attribute25 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
186 , x_pricing_attribute26 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
187 , x_pricing_attribute27 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
188 , x_pricing_attribute28 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
189 , x_pricing_attribute29 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
190 , x_pricing_attribute30 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
191 , x_pricing_context OUT NOCOPY /* file.sql.39 change */ VARCHAR2
192 , x_override_flag OUT NOCOPY /* file.sql.39 change */ VARCHAR2
193 , x_creation_date OUT NOCOPY /* file.sql.39 change */ DATE
194 );
195
196 PROCEDURE Change_Attributes
197 ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
198 , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
199 , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
200 , p_order_price_attrib_id IN NUMBER
201 , p_attr_id IN NUMBER
202 , p_context IN VARCHAR2
203 , p_attr_value IN VARCHAR2
204 , p_attribute1 IN VARCHAR2
205 , p_attribute2 IN VARCHAR2
206 , p_attribute3 IN VARCHAR2
207 , p_attribute4 IN VARCHAR2
208 , p_attribute5 IN VARCHAR2
209 , p_attribute6 IN VARCHAR2
210 , p_attribute7 IN VARCHAR2
211 , p_attribute8 IN VARCHAR2
212 , p_attribute9 IN VARCHAR2
213 , p_attribute10 IN VARCHAR2
214 , p_attribute11 IN VARCHAR2
215 , p_attribute12 IN VARCHAR2
216 , p_attribute13 IN VARCHAR2
217 , p_attribute14 IN VARCHAR2
218 , p_attribute15 IN VARCHAR2
219 , p_pricing_attribute1 IN VARCHAR2
220 , p_pricing_attribute10 IN VARCHAR2
224 , p_pricing_attribute14 IN VARCHAR2
221 , p_pricing_attribute11 IN VARCHAR2
222 , p_pricing_attribute12 IN VARCHAR2
223 , p_pricing_attribute13 IN VARCHAR2
225 , p_pricing_attribute15 IN VARCHAR2
226 , p_pricing_attribute2 IN VARCHAR2
227 , p_pricing_attribute3 IN VARCHAR2
228 , p_pricing_attribute4 IN VARCHAR2
229 , p_pricing_attribute5 IN VARCHAR2
230 , p_pricing_attribute6 IN VARCHAR2
231 , p_pricing_attribute7 IN VARCHAR2
232 , p_pricing_attribute8 IN VARCHAR2
233 , p_pricing_attribute9 IN VARCHAR2
234 , p_pricing_attribute16 IN VARCHAR2
235 , p_pricing_attribute17 IN VARCHAR2
236 , p_pricing_attribute18 IN VARCHAR2
237 , p_pricing_attribute19 IN VARCHAR2
238 , p_pricing_attribute20 IN VARCHAR2
239 , p_pricing_attribute21 IN VARCHAR2
240 , p_pricing_attribute22 IN VARCHAR2
241 , p_pricing_attribute23 IN VARCHAR2
242 , p_pricing_attribute24 IN VARCHAR2
243 , p_pricing_attribute25 IN VARCHAR2
244 , p_pricing_attribute26 IN VARCHAR2
245 , p_pricing_attribute27 IN VARCHAR2
246 , p_pricing_attribute28 IN VARCHAR2
247 , p_pricing_attribute29 IN VARCHAR2
248 , p_pricing_attribute30 IN VARCHAR2
249 , p_pricing_attribute31 IN VARCHAR2
250 , p_pricing_attribute32 IN VARCHAR2
251 , p_pricing_attribute33 IN VARCHAR2
252 , p_pricing_attribute34 IN VARCHAR2
253 , p_pricing_attribute35 IN VARCHAR2
254 , p_pricing_attribute36 IN VARCHAR2
255 , p_pricing_attribute37 IN VARCHAR2
256 , p_pricing_attribute38 IN VARCHAR2
257 , p_pricing_attribute39 IN VARCHAR2
258 , p_pricing_attribute40 IN VARCHAR2
259 , p_pricing_attribute41 IN VARCHAR2
260 , p_pricing_attribute42 IN VARCHAR2
261 , p_pricing_attribute43 IN VARCHAR2
262 , p_pricing_attribute44 IN VARCHAR2
263 , p_pricing_attribute45 IN VARCHAR2
264 , p_pricing_attribute46 IN VARCHAR2
265 , p_pricing_attribute47 IN VARCHAR2
266 , p_pricing_attribute48 IN VARCHAR2
267 , p_pricing_attribute49 IN VARCHAR2
268 , p_pricing_attribute50 IN VARCHAR2
269 , p_pricing_attribute51 IN VARCHAR2
270 , p_pricing_attribute52 IN VARCHAR2
271 , p_pricing_attribute53 IN VARCHAR2
272 , p_pricing_attribute54 IN VARCHAR2
273 , p_pricing_attribute55 IN VARCHAR2
274 , p_pricing_attribute56 IN VARCHAR2
275 , p_pricing_attribute57 IN VARCHAR2
276 , p_pricing_attribute58 IN VARCHAR2
277 , p_pricing_attribute59 IN VARCHAR2
278 , p_pricing_attribute60 IN VARCHAR2
279 , p_pricing_attribute61 IN VARCHAR2
280 , p_pricing_attribute62 IN VARCHAR2
281 , p_pricing_attribute63 IN VARCHAR2
282 , p_pricing_attribute64 IN VARCHAR2
283 , p_pricing_attribute65 IN VARCHAR2
284 , p_pricing_attribute66 IN VARCHAR2
285 , p_pricing_attribute67 IN VARCHAR2
286 , p_pricing_attribute68 IN VARCHAR2
287 , p_pricing_attribute69 IN VARCHAR2
288 , p_pricing_attribute70 IN VARCHAR2
289 , p_pricing_attribute71 IN VARCHAR2
290 , p_pricing_attribute72 IN VARCHAR2
291 , p_pricing_attribute73 IN VARCHAR2
292 , p_pricing_attribute74 IN VARCHAR2
293 , p_pricing_attribute75 IN VARCHAR2
294 , p_pricing_attribute76 IN VARCHAR2
295 , p_pricing_attribute77 IN VARCHAR2
296 , p_pricing_attribute78 IN VARCHAR2
297 , p_pricing_attribute79 IN VARCHAR2
298 , p_pricing_attribute80 IN VARCHAR2
299 , p_pricing_attribute81 IN VARCHAR2
300 , p_pricing_attribute82 IN VARCHAR2
301 , p_pricing_attribute83 IN VARCHAR2
302 , p_pricing_attribute84 IN VARCHAR2
303 , p_pricing_attribute85 IN VARCHAR2
304 , p_pricing_attribute86 IN VARCHAR2
305 , p_pricing_attribute87 IN VARCHAR2
306 , p_pricing_attribute88 IN VARCHAR2
307 , p_pricing_attribute89 IN VARCHAR2
308 , p_pricing_attribute90 IN VARCHAR2
309 , p_pricing_attribute91 IN VARCHAR2
310 , p_pricing_attribute92 IN VARCHAR2
311 , p_pricing_attribute93 IN VARCHAR2
312 , p_pricing_attribute94 IN VARCHAR2
313 , p_pricing_attribute95 IN VARCHAR2
314 , p_pricing_attribute96 IN VARCHAR2
315 , p_pricing_attribute97 IN VARCHAR2
316 , p_pricing_attribute98 IN VARCHAR2
317 , p_pricing_attribute99 IN VARCHAR2
318 , p_pricing_attribute100 IN VARCHAR2
319 , p_pricing_context IN VARCHAR2
320 , p_flex_title IN VARCHAR2
321 , x_flex_title OUT NOCOPY /* file.sql.39 change */ VARCHAR2
322 , x_order_price_attrib_id OUT NOCOPY /* file.sql.39 change */ NUMBER
323 , x_header_id OUT NOCOPY /* file.sql.39 change */ NUMBER
324 , x_line_id OUT NOCOPY /* file.sql.39 change */ NUMBER
325 , x_context OUT NOCOPY /* file.sql.39 change */ VARCHAR2
326 , x_attribute1 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
327 , x_attribute2 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
328 , x_attribute3 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
329 , x_attribute4 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
330 , x_attribute5 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
331 , x_attribute6 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
332 , x_attribute7 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
333 , x_attribute8 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
334 , x_attribute9 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
335 , x_attribute10 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
336 , x_attribute11 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
337 , x_attribute12 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
338 , x_attribute13 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
339 , x_attribute14 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
340 , x_attribute15 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
341 , x_pricing_attribute1 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
342 , x_pricing_attribute10 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
343 , x_pricing_attribute11 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
344 , x_pricing_attribute12 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
345 , x_pricing_attribute13 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
346 , x_pricing_attribute14 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
347 , x_pricing_attribute15 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
348 , x_pricing_attribute2 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
349 , x_pricing_attribute3 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
350 , x_pricing_attribute4 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
351 , x_pricing_attribute5 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
352 , x_pricing_attribute6 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
353 , x_pricing_attribute7 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
354 , x_pricing_attribute8 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
355 , x_pricing_attribute9 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
356 , x_pricing_attribute16 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
357 , x_pricing_attribute17 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
358 , x_pricing_attribute18 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
359 , x_pricing_attribute19 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
360 , x_pricing_attribute20 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
361 , x_pricing_attribute21 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
362 , x_pricing_attribute22 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
363 , x_pricing_attribute23 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
364 , x_pricing_attribute24 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
365 , x_pricing_attribute25 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
366 , x_pricing_attribute26 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
367 , x_pricing_attribute27 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
368 , x_pricing_attribute28 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
372 , x_pricing_attribute32 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
369 , x_pricing_attribute29 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
370 , x_pricing_attribute30 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
371 , x_pricing_attribute31 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
373 , x_pricing_attribute33 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
374 , x_pricing_attribute34 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
375 , x_pricing_attribute35 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
376 , x_pricing_attribute36 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
377 , x_pricing_attribute37 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
378 , x_pricing_attribute38 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
379 , x_pricing_attribute39 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
380 , x_pricing_attribute40 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
381 , x_pricing_attribute41 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
382 , x_pricing_attribute42 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
383 , x_pricing_attribute43 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
384 , x_pricing_attribute44 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
385 , x_pricing_attribute45 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
386 , x_pricing_attribute46 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
387 , x_pricing_attribute47 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
388 , x_pricing_attribute48 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
389 , x_pricing_attribute49 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
390 , x_pricing_attribute50 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
391 , x_pricing_attribute51 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
392 , x_pricing_attribute52 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
393 , x_pricing_attribute53 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
394 , x_pricing_attribute54 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
395 , x_pricing_attribute55 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
396 , x_pricing_attribute56 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
397 , x_pricing_attribute57 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
398 , x_pricing_attribute58 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
399 , x_pricing_attribute59 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
400 , x_pricing_attribute60 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
401 , x_pricing_attribute61 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
402 , x_pricing_attribute62 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
403 , x_pricing_attribute63 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
404 , x_pricing_attribute64 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
405 , x_pricing_attribute65 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
406 , x_pricing_attribute66 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
407 , x_pricing_attribute67 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
408 , x_pricing_attribute68 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
409 , x_pricing_attribute69 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
410 , x_pricing_attribute70 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
411 , x_pricing_attribute71 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
412 , x_pricing_attribute72 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
413 , x_pricing_attribute73 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
414 , x_pricing_attribute74 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
415 , x_pricing_attribute75 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
416 , x_pricing_attribute76 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
417 , x_pricing_attribute77 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
418 , x_pricing_attribute78 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
419 , x_pricing_attribute79 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
420 , x_pricing_attribute80 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
421 , x_pricing_attribute81 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
422 , x_pricing_attribute82 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
423 , x_pricing_attribute83 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
424 , x_pricing_attribute84 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
425 , x_pricing_attribute85 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
426 , x_pricing_attribute86 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
427 , x_pricing_attribute87 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
428 , x_pricing_attribute88 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
429 , x_pricing_attribute89 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
430 , x_pricing_attribute90 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
431 , x_pricing_attribute91 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
432 , x_pricing_attribute92 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
433 , x_pricing_attribute93 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
434 , x_pricing_attribute94 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
435 , x_pricing_attribute95 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
436 , x_pricing_attribute96 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
437 , x_pricing_attribute97 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
438 , x_pricing_attribute98 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
439 , x_pricing_attribute99 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
440 , x_pricing_attribute100 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
441 , x_pricing_context OUT NOCOPY /* file.sql.39 change */ VARCHAR2
442 , x_override_flag OUT NOCOPY /* file.sql.39 change */ VARCHAR2
443
444 );
445
446 PROCEDURE Change_Attributes
447 ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
448 , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
449 , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
450 , p_order_price_attrib_id IN NUMBER
451 , p_attr_id IN NUMBER
455 , p_attribute2 IN VARCHAR2
452 , p_context IN VARCHAR2
453 , p_attr_value IN VARCHAR2
454 , p_attribute1 IN VARCHAR2
456 , p_attribute3 IN VARCHAR2
457 , p_attribute4 IN VARCHAR2
458 , p_attribute5 IN VARCHAR2
459 , p_attribute6 IN VARCHAR2
460 , p_attribute7 IN VARCHAR2
461 , p_attribute8 IN VARCHAR2
462 , p_attribute9 IN VARCHAR2
463 , p_attribute10 IN VARCHAR2
464 , p_attribute11 IN VARCHAR2
465 , p_attribute12 IN VARCHAR2
466 , p_attribute13 IN VARCHAR2
467 , p_attribute14 IN VARCHAR2
468 , p_attribute15 IN VARCHAR2
472 , p_pricing_attribute12 IN VARCHAR2
473 , p_pricing_attribute13 IN VARCHAR2
474 , p_pricing_attribute14 IN VARCHAR2
475 , p_pricing_attribute15 IN VARCHAR2
476 , p_pricing_attribute2 IN VARCHAR2
477 , p_pricing_attribute3 IN VARCHAR2
478 , p_pricing_attribute4 IN VARCHAR2
479 , p_pricing_attribute5 IN VARCHAR2
480 , p_pricing_attribute6 IN VARCHAR2
481 , p_pricing_attribute7 IN VARCHAR2
482 , p_pricing_attribute8 IN VARCHAR2
483 , p_pricing_attribute9 IN VARCHAR2
484 , p_pricing_attribute16 IN VARCHAR2
485 , p_pricing_attribute17 IN VARCHAR2
486 , p_pricing_attribute18 IN VARCHAR2
487 , p_pricing_attribute19 IN VARCHAR2
488 , p_pricing_attribute20 IN VARCHAR2
489 , p_pricing_attribute21 IN VARCHAR2
490 , p_pricing_attribute22 IN VARCHAR2
491 , p_pricing_attribute23 IN VARCHAR2
492 , p_pricing_attribute24 IN VARCHAR2
493 , p_pricing_attribute25 IN VARCHAR2
494 , p_pricing_attribute26 IN VARCHAR2
495 , p_pricing_attribute27 IN VARCHAR2
496 , p_pricing_attribute28 IN VARCHAR2
497 , p_pricing_attribute29 IN VARCHAR2
498 , p_pricing_attribute30 IN VARCHAR2
499 , p_pricing_context IN VARCHAR2
500 , p_flex_title IN VARCHAR2
501 , x_flex_title OUT NOCOPY /* file.sql.39 change */ VARCHAR2
502 , x_order_price_attrib_id OUT NOCOPY /* file.sql.39 change */ NUMBER
503 , x_header_id OUT NOCOPY /* file.sql.39 change */ NUMBER
504 , x_line_id OUT NOCOPY /* file.sql.39 change */ NUMBER
505 , x_context OUT NOCOPY /* file.sql.39 change */ VARCHAR2
506 , x_attribute1 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
507 , x_attribute2 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
508 , x_attribute3 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
509 , x_attribute4 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
510 , x_attribute5 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
511 , x_attribute6 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
512 , x_attribute7 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
513 , x_attribute8 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
514 , x_attribute9 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
515 , x_attribute10 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
516 , x_attribute11 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
517 , x_attribute12 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
518 , x_attribute13 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
519 , x_attribute14 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
520 , x_attribute15 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
521 , x_pricing_attribute1 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
522 , x_pricing_attribute10 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
523 , x_pricing_attribute11 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
524 , x_pricing_attribute12 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
525 , x_pricing_attribute13 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
526 , x_pricing_attribute14 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
527 , x_pricing_attribute15 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
528 , x_pricing_attribute2 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
529 , x_pricing_attribute3 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
530 , x_pricing_attribute4 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
531 , x_pricing_attribute5 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
532 , x_pricing_attribute6 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
533 , x_pricing_attribute7 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
534 , x_pricing_attribute8 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
535 , x_pricing_attribute9 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
536 , x_pricing_attribute16 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
537 , x_pricing_attribute17 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
538 , x_pricing_attribute18 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
539 , x_pricing_attribute19 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
540 , x_pricing_attribute20 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
541 , x_pricing_attribute21 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
542 , x_pricing_attribute22 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
543 , x_pricing_attribute23 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
544 , x_pricing_attribute24 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
545 , x_pricing_attribute25 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
546 , x_pricing_attribute26 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
547 , x_pricing_attribute27 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
548 , x_pricing_attribute28 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
549 , x_pricing_attribute29 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
550 , x_pricing_attribute30 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
551 , x_pricing_context OUT NOCOPY /* file.sql.39 change */ VARCHAR2
552 , x_override_flag OUT NOCOPY /* file.sql.39 change */ VARCHAR2
553
554 );
555
556
557
558 PROCEDURE Validate_And_Write
559 ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
560 , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
561 , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
562 , p_order_price_attrib_id IN NUMBER
563 , x_creation_date OUT NOCOPY /* file.sql.39 change */ DATE
564 , x_created_by OUT NOCOPY /* file.sql.39 change */ NUMBER
565 , x_last_update_date OUT NOCOPY /* file.sql.39 change */ DATE
566 , x_last_updated_by OUT NOCOPY /* file.sql.39 change */ NUMBER
567 , x_last_update_login OUT NOCOPY /* file.sql.39 change */ NUMBER
568 , x_program_id OUT NOCOPY /* file.sql.39 change */ NUMBER
571 , x_request_id OUT NOCOPY /* file.sql.39 change */ NUMBER
469 , p_pricing_attribute1 IN VARCHAR2
470 , p_pricing_attribute10 IN VARCHAR2
471 , p_pricing_attribute11 IN VARCHAR2
569 , x_program_application_id OUT NOCOPY /* file.sql.39 change */ NUMBER
570 , x_program_update_date OUT NOCOPY /* file.sql.39 change */ DATE
572 , x_lock_control OUT NOCOPY /* file.sql.39 change */ NUMBER
573 );
574
575
576 PROCEDURE Delete_Row
577 ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
578 , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
579 , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
580 , p_order_price_attrib_id IN NUMBER
581 );
582
583 PROCEDURE Lock_Row
584 ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
585 , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
586 , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
587 , p_order_price_attrib_id IN NUMBER
588 , p_lock_control IN NUMBER
589 );
590
591 END OE_OE_Form_Header_PAttr;