DBA Data[Home] [Help]

PACKAGE: APPS.CSI_PRICING_ATTRIBS_PUB_W

Source


1 package csi_pricing_attribs_pub_w as
2   /* $Header: csippaws.pls 120.11 2008/01/15 03:34:10 devijay ship $ */
3   procedure get_pricing_attribs(p_api_version  NUMBER
4     , p_commit  VARCHAR2
5     , p_init_msg_list  VARCHAR2
6     , p_validation_level  NUMBER
7     , p_time_stamp  date
8     , p6_a0 out nocopy JTF_NUMBER_TABLE
9     , p6_a1 out nocopy JTF_NUMBER_TABLE
10     , p6_a2 out nocopy JTF_DATE_TABLE
11     , p6_a3 out nocopy JTF_DATE_TABLE
12     , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
13     , p6_a5 out nocopy JTF_VARCHAR2_TABLE_200
14     , p6_a6 out nocopy JTF_VARCHAR2_TABLE_200
15     , p6_a7 out nocopy JTF_VARCHAR2_TABLE_200
16     , p6_a8 out nocopy JTF_VARCHAR2_TABLE_200
17     , p6_a9 out nocopy JTF_VARCHAR2_TABLE_200
18     , p6_a10 out nocopy JTF_VARCHAR2_TABLE_200
19     , p6_a11 out nocopy JTF_VARCHAR2_TABLE_200
20     , p6_a12 out nocopy JTF_VARCHAR2_TABLE_200
21     , p6_a13 out nocopy JTF_VARCHAR2_TABLE_200
22     , p6_a14 out nocopy JTF_VARCHAR2_TABLE_200
23     , p6_a15 out nocopy JTF_VARCHAR2_TABLE_200
24     , p6_a16 out nocopy JTF_VARCHAR2_TABLE_200
25     , p6_a17 out nocopy JTF_VARCHAR2_TABLE_200
26     , p6_a18 out nocopy JTF_VARCHAR2_TABLE_200
27     , p6_a19 out nocopy JTF_VARCHAR2_TABLE_200
28     , p6_a20 out nocopy JTF_VARCHAR2_TABLE_200
29     , p6_a21 out nocopy JTF_VARCHAR2_TABLE_200
30     , p6_a22 out nocopy JTF_VARCHAR2_TABLE_200
31     , p6_a23 out nocopy JTF_VARCHAR2_TABLE_200
32     , p6_a24 out nocopy JTF_VARCHAR2_TABLE_300
33     , p6_a25 out nocopy JTF_VARCHAR2_TABLE_200
34     , p6_a26 out nocopy JTF_VARCHAR2_TABLE_200
35     , p6_a27 out nocopy JTF_VARCHAR2_TABLE_200
36     , p6_a28 out nocopy JTF_VARCHAR2_TABLE_200
37     , p6_a29 out nocopy JTF_VARCHAR2_TABLE_200
38     , p6_a30 out nocopy JTF_VARCHAR2_TABLE_200
39     , p6_a31 out nocopy JTF_VARCHAR2_TABLE_200
40     , p6_a32 out nocopy JTF_VARCHAR2_TABLE_200
41     , p6_a33 out nocopy JTF_VARCHAR2_TABLE_200
42     , p6_a34 out nocopy JTF_VARCHAR2_TABLE_200
43     , p6_a35 out nocopy JTF_VARCHAR2_TABLE_200
44     , p6_a36 out nocopy JTF_VARCHAR2_TABLE_200
45     , p6_a37 out nocopy JTF_VARCHAR2_TABLE_200
46     , p6_a38 out nocopy JTF_VARCHAR2_TABLE_200
47     , p6_a39 out nocopy JTF_VARCHAR2_TABLE_200
48     , p6_a40 out nocopy JTF_VARCHAR2_TABLE_200
49     , p6_a41 out nocopy JTF_VARCHAR2_TABLE_200
50     , p6_a42 out nocopy JTF_VARCHAR2_TABLE_200
51     , p6_a43 out nocopy JTF_VARCHAR2_TABLE_200
52     , p6_a44 out nocopy JTF_VARCHAR2_TABLE_200
53     , p6_a45 out nocopy JTF_VARCHAR2_TABLE_200
54     , p6_a46 out nocopy JTF_VARCHAR2_TABLE_200
55     , p6_a47 out nocopy JTF_VARCHAR2_TABLE_200
56     , p6_a48 out nocopy JTF_VARCHAR2_TABLE_200
57     , p6_a49 out nocopy JTF_VARCHAR2_TABLE_200
58     , p6_a50 out nocopy JTF_VARCHAR2_TABLE_200
59     , p6_a51 out nocopy JTF_VARCHAR2_TABLE_200
60     , p6_a52 out nocopy JTF_VARCHAR2_TABLE_200
61     , p6_a53 out nocopy JTF_VARCHAR2_TABLE_200
62     , p6_a54 out nocopy JTF_VARCHAR2_TABLE_200
63     , p6_a55 out nocopy JTF_VARCHAR2_TABLE_200
64     , p6_a56 out nocopy JTF_VARCHAR2_TABLE_200
65     , p6_a57 out nocopy JTF_VARCHAR2_TABLE_200
66     , p6_a58 out nocopy JTF_VARCHAR2_TABLE_200
67     , p6_a59 out nocopy JTF_VARCHAR2_TABLE_200
68     , p6_a60 out nocopy JTF_VARCHAR2_TABLE_200
69     , p6_a61 out nocopy JTF_VARCHAR2_TABLE_200
70     , p6_a62 out nocopy JTF_VARCHAR2_TABLE_200
71     , p6_a63 out nocopy JTF_VARCHAR2_TABLE_200
72     , p6_a64 out nocopy JTF_VARCHAR2_TABLE_200
73     , p6_a65 out nocopy JTF_VARCHAR2_TABLE_200
74     , p6_a66 out nocopy JTF_VARCHAR2_TABLE_200
75     , p6_a67 out nocopy JTF_VARCHAR2_TABLE_200
76     , p6_a68 out nocopy JTF_VARCHAR2_TABLE_200
77     , p6_a69 out nocopy JTF_VARCHAR2_TABLE_200
78     , p6_a70 out nocopy JTF_VARCHAR2_TABLE_200
79     , p6_a71 out nocopy JTF_VARCHAR2_TABLE_200
80     , p6_a72 out nocopy JTF_VARCHAR2_TABLE_200
81     , p6_a73 out nocopy JTF_VARCHAR2_TABLE_200
82     , p6_a74 out nocopy JTF_VARCHAR2_TABLE_200
83     , p6_a75 out nocopy JTF_VARCHAR2_TABLE_200
84     , p6_a76 out nocopy JTF_VARCHAR2_TABLE_200
85     , p6_a77 out nocopy JTF_VARCHAR2_TABLE_200
86     , p6_a78 out nocopy JTF_VARCHAR2_TABLE_200
87     , p6_a79 out nocopy JTF_VARCHAR2_TABLE_200
88     , p6_a80 out nocopy JTF_VARCHAR2_TABLE_200
89     , p6_a81 out nocopy JTF_VARCHAR2_TABLE_200
90     , p6_a82 out nocopy JTF_VARCHAR2_TABLE_200
91     , p6_a83 out nocopy JTF_VARCHAR2_TABLE_200
92     , p6_a84 out nocopy JTF_VARCHAR2_TABLE_200
93     , p6_a85 out nocopy JTF_VARCHAR2_TABLE_200
94     , p6_a86 out nocopy JTF_VARCHAR2_TABLE_200
95     , p6_a87 out nocopy JTF_VARCHAR2_TABLE_200
96     , p6_a88 out nocopy JTF_VARCHAR2_TABLE_200
97     , p6_a89 out nocopy JTF_VARCHAR2_TABLE_200
98     , p6_a90 out nocopy JTF_VARCHAR2_TABLE_200
99     , p6_a91 out nocopy JTF_VARCHAR2_TABLE_200
100     , p6_a92 out nocopy JTF_VARCHAR2_TABLE_200
101     , p6_a93 out nocopy JTF_VARCHAR2_TABLE_200
102     , p6_a94 out nocopy JTF_VARCHAR2_TABLE_200
103     , p6_a95 out nocopy JTF_VARCHAR2_TABLE_200
104     , p6_a96 out nocopy JTF_VARCHAR2_TABLE_200
105     , p6_a97 out nocopy JTF_VARCHAR2_TABLE_200
106     , p6_a98 out nocopy JTF_VARCHAR2_TABLE_200
107     , p6_a99 out nocopy JTF_VARCHAR2_TABLE_200
108     , p6_a100 out nocopy JTF_VARCHAR2_TABLE_200
109     , p6_a101 out nocopy JTF_VARCHAR2_TABLE_200
110     , p6_a102 out nocopy JTF_VARCHAR2_TABLE_200
111     , p6_a103 out nocopy JTF_VARCHAR2_TABLE_200
112     , p6_a104 out nocopy JTF_VARCHAR2_TABLE_200
113     , p6_a105 out nocopy JTF_VARCHAR2_TABLE_100
114     , p6_a106 out nocopy JTF_VARCHAR2_TABLE_200
115     , p6_a107 out nocopy JTF_VARCHAR2_TABLE_200
116     , p6_a108 out nocopy JTF_VARCHAR2_TABLE_200
117     , p6_a109 out nocopy JTF_VARCHAR2_TABLE_200
118     , p6_a110 out nocopy JTF_VARCHAR2_TABLE_200
119     , p6_a111 out nocopy JTF_VARCHAR2_TABLE_200
120     , p6_a112 out nocopy JTF_VARCHAR2_TABLE_200
121     , p6_a113 out nocopy JTF_VARCHAR2_TABLE_200
122     , p6_a114 out nocopy JTF_VARCHAR2_TABLE_200
123     , p6_a115 out nocopy JTF_VARCHAR2_TABLE_200
124     , p6_a116 out nocopy JTF_VARCHAR2_TABLE_200
125     , p6_a117 out nocopy JTF_VARCHAR2_TABLE_200
126     , p6_a118 out nocopy JTF_VARCHAR2_TABLE_200
127     , p6_a119 out nocopy JTF_VARCHAR2_TABLE_200
128     , p6_a120 out nocopy JTF_VARCHAR2_TABLE_200
129     , p6_a121 out nocopy JTF_NUMBER_TABLE
130     , p6_a122 out nocopy JTF_NUMBER_TABLE
131     , x_return_status out nocopy  VARCHAR2
132     , x_msg_count out nocopy  NUMBER
133     , x_msg_data out nocopy  VARCHAR2
134     , p4_a0  NUMBER := 0-1962.0724
135     , p4_a1  NUMBER := 0-1962.0724
136   );
137   procedure create_pricing_attribs(p_api_version  NUMBER
138     , p_commit  VARCHAR2
139     , p_init_msg_list  VARCHAR2
140     , p_validation_level  NUMBER
141     , p4_a0 in out nocopy JTF_NUMBER_TABLE
142     , p4_a1 in out nocopy JTF_NUMBER_TABLE
143     , p4_a2 in out nocopy JTF_DATE_TABLE
144     , p4_a3 in out nocopy JTF_DATE_TABLE
145     , p4_a4 in out nocopy JTF_VARCHAR2_TABLE_100
146     , p4_a5 in out nocopy JTF_VARCHAR2_TABLE_200
147     , p4_a6 in out nocopy JTF_VARCHAR2_TABLE_200
148     , p4_a7 in out nocopy JTF_VARCHAR2_TABLE_200
149     , p4_a8 in out nocopy JTF_VARCHAR2_TABLE_200
150     , p4_a9 in out nocopy JTF_VARCHAR2_TABLE_200
151     , p4_a10 in out nocopy JTF_VARCHAR2_TABLE_200
152     , p4_a11 in out nocopy JTF_VARCHAR2_TABLE_200
153     , p4_a12 in out nocopy JTF_VARCHAR2_TABLE_200
154     , p4_a13 in out nocopy JTF_VARCHAR2_TABLE_200
155     , p4_a14 in out nocopy JTF_VARCHAR2_TABLE_200
156     , p4_a15 in out nocopy JTF_VARCHAR2_TABLE_200
157     , p4_a16 in out nocopy JTF_VARCHAR2_TABLE_200
158     , p4_a17 in out nocopy JTF_VARCHAR2_TABLE_200
159     , p4_a18 in out nocopy JTF_VARCHAR2_TABLE_200
160     , p4_a19 in out nocopy JTF_VARCHAR2_TABLE_200
161     , p4_a20 in out nocopy JTF_VARCHAR2_TABLE_200
162     , p4_a21 in out nocopy JTF_VARCHAR2_TABLE_200
163     , p4_a22 in out nocopy JTF_VARCHAR2_TABLE_200
164     , p4_a23 in out nocopy JTF_VARCHAR2_TABLE_200
165     , p4_a24 in out nocopy JTF_VARCHAR2_TABLE_300
166     , p4_a25 in out nocopy JTF_VARCHAR2_TABLE_200
167     , p4_a26 in out nocopy JTF_VARCHAR2_TABLE_200
168     , p4_a27 in out nocopy JTF_VARCHAR2_TABLE_200
169     , p4_a28 in out nocopy JTF_VARCHAR2_TABLE_200
170     , p4_a29 in out nocopy JTF_VARCHAR2_TABLE_200
171     , p4_a30 in out nocopy JTF_VARCHAR2_TABLE_200
172     , p4_a31 in out nocopy JTF_VARCHAR2_TABLE_200
173     , p4_a32 in out nocopy JTF_VARCHAR2_TABLE_200
174     , p4_a33 in out nocopy JTF_VARCHAR2_TABLE_200
175     , p4_a34 in out nocopy JTF_VARCHAR2_TABLE_200
176     , p4_a35 in out nocopy JTF_VARCHAR2_TABLE_200
177     , p4_a36 in out nocopy JTF_VARCHAR2_TABLE_200
178     , p4_a37 in out nocopy JTF_VARCHAR2_TABLE_200
179     , p4_a38 in out nocopy JTF_VARCHAR2_TABLE_200
180     , p4_a39 in out nocopy JTF_VARCHAR2_TABLE_200
181     , p4_a40 in out nocopy JTF_VARCHAR2_TABLE_200
182     , p4_a41 in out nocopy JTF_VARCHAR2_TABLE_200
183     , p4_a42 in out nocopy JTF_VARCHAR2_TABLE_200
184     , p4_a43 in out nocopy JTF_VARCHAR2_TABLE_200
185     , p4_a44 in out nocopy JTF_VARCHAR2_TABLE_200
186     , p4_a45 in out nocopy JTF_VARCHAR2_TABLE_200
187     , p4_a46 in out nocopy JTF_VARCHAR2_TABLE_200
188     , p4_a47 in out nocopy JTF_VARCHAR2_TABLE_200
189     , p4_a48 in out nocopy JTF_VARCHAR2_TABLE_200
190     , p4_a49 in out nocopy JTF_VARCHAR2_TABLE_200
191     , p4_a50 in out nocopy JTF_VARCHAR2_TABLE_200
192     , p4_a51 in out nocopy JTF_VARCHAR2_TABLE_200
193     , p4_a52 in out nocopy JTF_VARCHAR2_TABLE_200
194     , p4_a53 in out nocopy JTF_VARCHAR2_TABLE_200
195     , p4_a54 in out nocopy JTF_VARCHAR2_TABLE_200
196     , p4_a55 in out nocopy JTF_VARCHAR2_TABLE_200
197     , p4_a56 in out nocopy JTF_VARCHAR2_TABLE_200
198     , p4_a57 in out nocopy JTF_VARCHAR2_TABLE_200
199     , p4_a58 in out nocopy JTF_VARCHAR2_TABLE_200
200     , p4_a59 in out nocopy JTF_VARCHAR2_TABLE_200
201     , p4_a60 in out nocopy JTF_VARCHAR2_TABLE_200
202     , p4_a61 in out nocopy JTF_VARCHAR2_TABLE_200
203     , p4_a62 in out nocopy JTF_VARCHAR2_TABLE_200
204     , p4_a63 in out nocopy JTF_VARCHAR2_TABLE_200
205     , p4_a64 in out nocopy JTF_VARCHAR2_TABLE_200
206     , p4_a65 in out nocopy JTF_VARCHAR2_TABLE_200
207     , p4_a66 in out nocopy JTF_VARCHAR2_TABLE_200
208     , p4_a67 in out nocopy JTF_VARCHAR2_TABLE_200
209     , p4_a68 in out nocopy JTF_VARCHAR2_TABLE_200
210     , p4_a69 in out nocopy JTF_VARCHAR2_TABLE_200
211     , p4_a70 in out nocopy JTF_VARCHAR2_TABLE_200
212     , p4_a71 in out nocopy JTF_VARCHAR2_TABLE_200
213     , p4_a72 in out nocopy JTF_VARCHAR2_TABLE_200
214     , p4_a73 in out nocopy JTF_VARCHAR2_TABLE_200
215     , p4_a74 in out nocopy JTF_VARCHAR2_TABLE_200
216     , p4_a75 in out nocopy JTF_VARCHAR2_TABLE_200
217     , p4_a76 in out nocopy JTF_VARCHAR2_TABLE_200
218     , p4_a77 in out nocopy JTF_VARCHAR2_TABLE_200
219     , p4_a78 in out nocopy JTF_VARCHAR2_TABLE_200
220     , p4_a79 in out nocopy JTF_VARCHAR2_TABLE_200
221     , p4_a80 in out nocopy JTF_VARCHAR2_TABLE_200
222     , p4_a81 in out nocopy JTF_VARCHAR2_TABLE_200
223     , p4_a82 in out nocopy JTF_VARCHAR2_TABLE_200
224     , p4_a83 in out nocopy JTF_VARCHAR2_TABLE_200
225     , p4_a84 in out nocopy JTF_VARCHAR2_TABLE_200
226     , p4_a85 in out nocopy JTF_VARCHAR2_TABLE_200
227     , p4_a86 in out nocopy JTF_VARCHAR2_TABLE_200
228     , p4_a87 in out nocopy JTF_VARCHAR2_TABLE_200
229     , p4_a88 in out nocopy JTF_VARCHAR2_TABLE_200
230     , p4_a89 in out nocopy JTF_VARCHAR2_TABLE_200
231     , p4_a90 in out nocopy JTF_VARCHAR2_TABLE_200
232     , p4_a91 in out nocopy JTF_VARCHAR2_TABLE_200
233     , p4_a92 in out nocopy JTF_VARCHAR2_TABLE_200
234     , p4_a93 in out nocopy JTF_VARCHAR2_TABLE_200
235     , p4_a94 in out nocopy JTF_VARCHAR2_TABLE_200
236     , p4_a95 in out nocopy JTF_VARCHAR2_TABLE_200
237     , p4_a96 in out nocopy JTF_VARCHAR2_TABLE_200
238     , p4_a97 in out nocopy JTF_VARCHAR2_TABLE_200
239     , p4_a98 in out nocopy JTF_VARCHAR2_TABLE_200
240     , p4_a99 in out nocopy JTF_VARCHAR2_TABLE_200
241     , p4_a100 in out nocopy JTF_VARCHAR2_TABLE_200
242     , p4_a101 in out nocopy JTF_VARCHAR2_TABLE_200
243     , p4_a102 in out nocopy JTF_VARCHAR2_TABLE_200
244     , p4_a103 in out nocopy JTF_VARCHAR2_TABLE_200
245     , p4_a104 in out nocopy JTF_VARCHAR2_TABLE_200
246     , p4_a105 in out nocopy JTF_VARCHAR2_TABLE_100
247     , p4_a106 in out nocopy JTF_VARCHAR2_TABLE_200
248     , p4_a107 in out nocopy JTF_VARCHAR2_TABLE_200
249     , p4_a108 in out nocopy JTF_VARCHAR2_TABLE_200
250     , p4_a109 in out nocopy JTF_VARCHAR2_TABLE_200
251     , p4_a110 in out nocopy JTF_VARCHAR2_TABLE_200
252     , p4_a111 in out nocopy JTF_VARCHAR2_TABLE_200
253     , p4_a112 in out nocopy JTF_VARCHAR2_TABLE_200
254     , p4_a113 in out nocopy JTF_VARCHAR2_TABLE_200
255     , p4_a114 in out nocopy JTF_VARCHAR2_TABLE_200
256     , p4_a115 in out nocopy JTF_VARCHAR2_TABLE_200
257     , p4_a116 in out nocopy JTF_VARCHAR2_TABLE_200
258     , p4_a117 in out nocopy JTF_VARCHAR2_TABLE_200
259     , p4_a118 in out nocopy JTF_VARCHAR2_TABLE_200
260     , p4_a119 in out nocopy JTF_VARCHAR2_TABLE_200
261     , p4_a120 in out nocopy JTF_VARCHAR2_TABLE_200
262     , p4_a121 in out nocopy JTF_NUMBER_TABLE
263     , p4_a122 in out nocopy JTF_NUMBER_TABLE
264     , p5_a0 in out nocopy  NUMBER
265     , p5_a1 in out nocopy  DATE
266     , p5_a2 in out nocopy  DATE
267     , p5_a3 in out nocopy  NUMBER
268     , p5_a4 in out nocopy  NUMBER
269     , p5_a5 in out nocopy  NUMBER
270     , p5_a6 in out nocopy  VARCHAR2
271     , p5_a7 in out nocopy  NUMBER
272     , p5_a8 in out nocopy  VARCHAR2
273     , p5_a9 in out nocopy  NUMBER
274     , p5_a10 in out nocopy  VARCHAR2
275     , p5_a11 in out nocopy  NUMBER
276     , p5_a12 in out nocopy  NUMBER
277     , p5_a13 in out nocopy  NUMBER
278     , p5_a14 in out nocopy  NUMBER
279     , p5_a15 in out nocopy  VARCHAR2
280     , p5_a16 in out nocopy  NUMBER
281     , p5_a17 in out nocopy  VARCHAR2
282     , p5_a18 in out nocopy  VARCHAR2
283     , p5_a19 in out nocopy  NUMBER
284     , p5_a20 in out nocopy  VARCHAR2
285     , p5_a21 in out nocopy  VARCHAR2
286     , p5_a22 in out nocopy  VARCHAR2
287     , p5_a23 in out nocopy  VARCHAR2
288     , p5_a24 in out nocopy  VARCHAR2
289     , p5_a25 in out nocopy  VARCHAR2
290     , p5_a26 in out nocopy  VARCHAR2
294     , p5_a30 in out nocopy  VARCHAR2
291     , p5_a27 in out nocopy  VARCHAR2
292     , p5_a28 in out nocopy  VARCHAR2
293     , p5_a29 in out nocopy  VARCHAR2
295     , p5_a31 in out nocopy  VARCHAR2
296     , p5_a32 in out nocopy  VARCHAR2
297     , p5_a33 in out nocopy  VARCHAR2
298     , p5_a34 in out nocopy  VARCHAR2
299     , p5_a35 in out nocopy  VARCHAR2
300     , p5_a36 in out nocopy  NUMBER
301     , p5_a37 in out nocopy  VARCHAR2
302     , p5_a38 in out nocopy  DATE
303     , p5_a39 in out nocopy  NUMBER
304     , x_return_status out nocopy  VARCHAR2
305     , x_msg_count out nocopy  NUMBER
306     , x_msg_data out nocopy  VARCHAR2
307   );
308   procedure update_pricing_attribs(p_api_version  NUMBER
309     , p_commit  VARCHAR2
310     , p_init_msg_list  VARCHAR2
311     , p_validation_level  NUMBER
312     , p4_a0 JTF_NUMBER_TABLE
313     , p4_a1 JTF_NUMBER_TABLE
314     , p4_a2 JTF_DATE_TABLE
315     , p4_a3 JTF_DATE_TABLE
316     , p4_a4 JTF_VARCHAR2_TABLE_100
317     , p4_a5 JTF_VARCHAR2_TABLE_200
318     , p4_a6 JTF_VARCHAR2_TABLE_200
319     , p4_a7 JTF_VARCHAR2_TABLE_200
320     , p4_a8 JTF_VARCHAR2_TABLE_200
321     , p4_a9 JTF_VARCHAR2_TABLE_200
322     , p4_a10 JTF_VARCHAR2_TABLE_200
323     , p4_a11 JTF_VARCHAR2_TABLE_200
324     , p4_a12 JTF_VARCHAR2_TABLE_200
325     , p4_a13 JTF_VARCHAR2_TABLE_200
326     , p4_a14 JTF_VARCHAR2_TABLE_200
327     , p4_a15 JTF_VARCHAR2_TABLE_200
328     , p4_a16 JTF_VARCHAR2_TABLE_200
329     , p4_a17 JTF_VARCHAR2_TABLE_200
330     , p4_a18 JTF_VARCHAR2_TABLE_200
331     , p4_a19 JTF_VARCHAR2_TABLE_200
332     , p4_a20 JTF_VARCHAR2_TABLE_200
333     , p4_a21 JTF_VARCHAR2_TABLE_200
334     , p4_a22 JTF_VARCHAR2_TABLE_200
335     , p4_a23 JTF_VARCHAR2_TABLE_200
336     , p4_a24 JTF_VARCHAR2_TABLE_300
337     , p4_a25 JTF_VARCHAR2_TABLE_200
338     , p4_a26 JTF_VARCHAR2_TABLE_200
339     , p4_a27 JTF_VARCHAR2_TABLE_200
340     , p4_a28 JTF_VARCHAR2_TABLE_200
341     , p4_a29 JTF_VARCHAR2_TABLE_200
342     , p4_a30 JTF_VARCHAR2_TABLE_200
343     , p4_a31 JTF_VARCHAR2_TABLE_200
344     , p4_a32 JTF_VARCHAR2_TABLE_200
345     , p4_a33 JTF_VARCHAR2_TABLE_200
346     , p4_a34 JTF_VARCHAR2_TABLE_200
347     , p4_a35 JTF_VARCHAR2_TABLE_200
348     , p4_a36 JTF_VARCHAR2_TABLE_200
349     , p4_a37 JTF_VARCHAR2_TABLE_200
350     , p4_a38 JTF_VARCHAR2_TABLE_200
351     , p4_a39 JTF_VARCHAR2_TABLE_200
352     , p4_a40 JTF_VARCHAR2_TABLE_200
353     , p4_a41 JTF_VARCHAR2_TABLE_200
354     , p4_a42 JTF_VARCHAR2_TABLE_200
355     , p4_a43 JTF_VARCHAR2_TABLE_200
356     , p4_a44 JTF_VARCHAR2_TABLE_200
357     , p4_a45 JTF_VARCHAR2_TABLE_200
358     , p4_a46 JTF_VARCHAR2_TABLE_200
359     , p4_a47 JTF_VARCHAR2_TABLE_200
360     , p4_a48 JTF_VARCHAR2_TABLE_200
361     , p4_a49 JTF_VARCHAR2_TABLE_200
362     , p4_a50 JTF_VARCHAR2_TABLE_200
363     , p4_a51 JTF_VARCHAR2_TABLE_200
364     , p4_a52 JTF_VARCHAR2_TABLE_200
365     , p4_a53 JTF_VARCHAR2_TABLE_200
366     , p4_a54 JTF_VARCHAR2_TABLE_200
367     , p4_a55 JTF_VARCHAR2_TABLE_200
368     , p4_a56 JTF_VARCHAR2_TABLE_200
369     , p4_a57 JTF_VARCHAR2_TABLE_200
370     , p4_a58 JTF_VARCHAR2_TABLE_200
371     , p4_a59 JTF_VARCHAR2_TABLE_200
372     , p4_a60 JTF_VARCHAR2_TABLE_200
373     , p4_a61 JTF_VARCHAR2_TABLE_200
374     , p4_a62 JTF_VARCHAR2_TABLE_200
375     , p4_a63 JTF_VARCHAR2_TABLE_200
376     , p4_a64 JTF_VARCHAR2_TABLE_200
377     , p4_a65 JTF_VARCHAR2_TABLE_200
378     , p4_a66 JTF_VARCHAR2_TABLE_200
379     , p4_a67 JTF_VARCHAR2_TABLE_200
380     , p4_a68 JTF_VARCHAR2_TABLE_200
381     , p4_a69 JTF_VARCHAR2_TABLE_200
382     , p4_a70 JTF_VARCHAR2_TABLE_200
383     , p4_a71 JTF_VARCHAR2_TABLE_200
384     , p4_a72 JTF_VARCHAR2_TABLE_200
385     , p4_a73 JTF_VARCHAR2_TABLE_200
386     , p4_a74 JTF_VARCHAR2_TABLE_200
387     , p4_a75 JTF_VARCHAR2_TABLE_200
388     , p4_a76 JTF_VARCHAR2_TABLE_200
389     , p4_a77 JTF_VARCHAR2_TABLE_200
390     , p4_a78 JTF_VARCHAR2_TABLE_200
391     , p4_a79 JTF_VARCHAR2_TABLE_200
392     , p4_a80 JTF_VARCHAR2_TABLE_200
393     , p4_a81 JTF_VARCHAR2_TABLE_200
394     , p4_a82 JTF_VARCHAR2_TABLE_200
395     , p4_a83 JTF_VARCHAR2_TABLE_200
396     , p4_a84 JTF_VARCHAR2_TABLE_200
397     , p4_a85 JTF_VARCHAR2_TABLE_200
398     , p4_a86 JTF_VARCHAR2_TABLE_200
399     , p4_a87 JTF_VARCHAR2_TABLE_200
400     , p4_a88 JTF_VARCHAR2_TABLE_200
401     , p4_a89 JTF_VARCHAR2_TABLE_200
402     , p4_a90 JTF_VARCHAR2_TABLE_200
403     , p4_a91 JTF_VARCHAR2_TABLE_200
404     , p4_a92 JTF_VARCHAR2_TABLE_200
405     , p4_a93 JTF_VARCHAR2_TABLE_200
406     , p4_a94 JTF_VARCHAR2_TABLE_200
407     , p4_a95 JTF_VARCHAR2_TABLE_200
408     , p4_a96 JTF_VARCHAR2_TABLE_200
409     , p4_a97 JTF_VARCHAR2_TABLE_200
410     , p4_a98 JTF_VARCHAR2_TABLE_200
411     , p4_a99 JTF_VARCHAR2_TABLE_200
412     , p4_a100 JTF_VARCHAR2_TABLE_200
413     , p4_a101 JTF_VARCHAR2_TABLE_200
414     , p4_a102 JTF_VARCHAR2_TABLE_200
415     , p4_a103 JTF_VARCHAR2_TABLE_200
416     , p4_a104 JTF_VARCHAR2_TABLE_200
417     , p4_a105 JTF_VARCHAR2_TABLE_100
418     , p4_a106 JTF_VARCHAR2_TABLE_200
419     , p4_a107 JTF_VARCHAR2_TABLE_200
420     , p4_a108 JTF_VARCHAR2_TABLE_200
421     , p4_a109 JTF_VARCHAR2_TABLE_200
422     , p4_a110 JTF_VARCHAR2_TABLE_200
423     , p4_a111 JTF_VARCHAR2_TABLE_200
424     , p4_a112 JTF_VARCHAR2_TABLE_200
425     , p4_a113 JTF_VARCHAR2_TABLE_200
429     , p4_a117 JTF_VARCHAR2_TABLE_200
426     , p4_a114 JTF_VARCHAR2_TABLE_200
427     , p4_a115 JTF_VARCHAR2_TABLE_200
428     , p4_a116 JTF_VARCHAR2_TABLE_200
430     , p4_a118 JTF_VARCHAR2_TABLE_200
431     , p4_a119 JTF_VARCHAR2_TABLE_200
432     , p4_a120 JTF_VARCHAR2_TABLE_200
433     , p4_a121 JTF_NUMBER_TABLE
434     , p4_a122 JTF_NUMBER_TABLE
435     , p5_a0 in out nocopy  NUMBER
436     , p5_a1 in out nocopy  DATE
437     , p5_a2 in out nocopy  DATE
438     , p5_a3 in out nocopy  NUMBER
439     , p5_a4 in out nocopy  NUMBER
440     , p5_a5 in out nocopy  NUMBER
441     , p5_a6 in out nocopy  VARCHAR2
442     , p5_a7 in out nocopy  NUMBER
443     , p5_a8 in out nocopy  VARCHAR2
444     , p5_a9 in out nocopy  NUMBER
445     , p5_a10 in out nocopy  VARCHAR2
446     , p5_a11 in out nocopy  NUMBER
447     , p5_a12 in out nocopy  NUMBER
448     , p5_a13 in out nocopy  NUMBER
449     , p5_a14 in out nocopy  NUMBER
450     , p5_a15 in out nocopy  VARCHAR2
451     , p5_a16 in out nocopy  NUMBER
452     , p5_a17 in out nocopy  VARCHAR2
453     , p5_a18 in out nocopy  VARCHAR2
454     , p5_a19 in out nocopy  NUMBER
455     , p5_a20 in out nocopy  VARCHAR2
456     , p5_a21 in out nocopy  VARCHAR2
457     , p5_a22 in out nocopy  VARCHAR2
458     , p5_a23 in out nocopy  VARCHAR2
459     , p5_a24 in out nocopy  VARCHAR2
460     , p5_a25 in out nocopy  VARCHAR2
461     , p5_a26 in out nocopy  VARCHAR2
462     , p5_a27 in out nocopy  VARCHAR2
463     , p5_a28 in out nocopy  VARCHAR2
464     , p5_a29 in out nocopy  VARCHAR2
465     , p5_a30 in out nocopy  VARCHAR2
466     , p5_a31 in out nocopy  VARCHAR2
467     , p5_a32 in out nocopy  VARCHAR2
468     , p5_a33 in out nocopy  VARCHAR2
469     , p5_a34 in out nocopy  VARCHAR2
470     , p5_a35 in out nocopy  VARCHAR2
471     , p5_a36 in out nocopy  NUMBER
472     , p5_a37 in out nocopy  VARCHAR2
473     , p5_a38 in out nocopy  DATE
474     , p5_a39 in out nocopy  NUMBER
475     , x_return_status out nocopy  VARCHAR2
476     , x_msg_count out nocopy  NUMBER
477     , x_msg_data out nocopy  VARCHAR2
478   );
479   procedure expire_pricing_attribs(p_api_version  NUMBER
480     , p_commit  VARCHAR2
481     , p_init_msg_list  VARCHAR2
482     , p_validation_level  NUMBER
483     , p4_a0 JTF_NUMBER_TABLE
484     , p4_a1 JTF_NUMBER_TABLE
485     , p4_a2 JTF_DATE_TABLE
486     , p4_a3 JTF_DATE_TABLE
487     , p4_a4 JTF_VARCHAR2_TABLE_100
488     , p4_a5 JTF_VARCHAR2_TABLE_200
489     , p4_a6 JTF_VARCHAR2_TABLE_200
490     , p4_a7 JTF_VARCHAR2_TABLE_200
491     , p4_a8 JTF_VARCHAR2_TABLE_200
492     , p4_a9 JTF_VARCHAR2_TABLE_200
493     , p4_a10 JTF_VARCHAR2_TABLE_200
494     , p4_a11 JTF_VARCHAR2_TABLE_200
495     , p4_a12 JTF_VARCHAR2_TABLE_200
496     , p4_a13 JTF_VARCHAR2_TABLE_200
497     , p4_a14 JTF_VARCHAR2_TABLE_200
498     , p4_a15 JTF_VARCHAR2_TABLE_200
499     , p4_a16 JTF_VARCHAR2_TABLE_200
500     , p4_a17 JTF_VARCHAR2_TABLE_200
501     , p4_a18 JTF_VARCHAR2_TABLE_200
502     , p4_a19 JTF_VARCHAR2_TABLE_200
503     , p4_a20 JTF_VARCHAR2_TABLE_200
504     , p4_a21 JTF_VARCHAR2_TABLE_200
505     , p4_a22 JTF_VARCHAR2_TABLE_200
506     , p4_a23 JTF_VARCHAR2_TABLE_200
507     , p4_a24 JTF_VARCHAR2_TABLE_300
508     , p4_a25 JTF_VARCHAR2_TABLE_200
509     , p4_a26 JTF_VARCHAR2_TABLE_200
510     , p4_a27 JTF_VARCHAR2_TABLE_200
511     , p4_a28 JTF_VARCHAR2_TABLE_200
512     , p4_a29 JTF_VARCHAR2_TABLE_200
513     , p4_a30 JTF_VARCHAR2_TABLE_200
514     , p4_a31 JTF_VARCHAR2_TABLE_200
515     , p4_a32 JTF_VARCHAR2_TABLE_200
516     , p4_a33 JTF_VARCHAR2_TABLE_200
517     , p4_a34 JTF_VARCHAR2_TABLE_200
518     , p4_a35 JTF_VARCHAR2_TABLE_200
519     , p4_a36 JTF_VARCHAR2_TABLE_200
520     , p4_a37 JTF_VARCHAR2_TABLE_200
521     , p4_a38 JTF_VARCHAR2_TABLE_200
522     , p4_a39 JTF_VARCHAR2_TABLE_200
523     , p4_a40 JTF_VARCHAR2_TABLE_200
524     , p4_a41 JTF_VARCHAR2_TABLE_200
525     , p4_a42 JTF_VARCHAR2_TABLE_200
526     , p4_a43 JTF_VARCHAR2_TABLE_200
527     , p4_a44 JTF_VARCHAR2_TABLE_200
528     , p4_a45 JTF_VARCHAR2_TABLE_200
529     , p4_a46 JTF_VARCHAR2_TABLE_200
530     , p4_a47 JTF_VARCHAR2_TABLE_200
531     , p4_a48 JTF_VARCHAR2_TABLE_200
532     , p4_a49 JTF_VARCHAR2_TABLE_200
533     , p4_a50 JTF_VARCHAR2_TABLE_200
534     , p4_a51 JTF_VARCHAR2_TABLE_200
535     , p4_a52 JTF_VARCHAR2_TABLE_200
536     , p4_a53 JTF_VARCHAR2_TABLE_200
537     , p4_a54 JTF_VARCHAR2_TABLE_200
538     , p4_a55 JTF_VARCHAR2_TABLE_200
539     , p4_a56 JTF_VARCHAR2_TABLE_200
540     , p4_a57 JTF_VARCHAR2_TABLE_200
541     , p4_a58 JTF_VARCHAR2_TABLE_200
542     , p4_a59 JTF_VARCHAR2_TABLE_200
543     , p4_a60 JTF_VARCHAR2_TABLE_200
544     , p4_a61 JTF_VARCHAR2_TABLE_200
545     , p4_a62 JTF_VARCHAR2_TABLE_200
546     , p4_a63 JTF_VARCHAR2_TABLE_200
547     , p4_a64 JTF_VARCHAR2_TABLE_200
548     , p4_a65 JTF_VARCHAR2_TABLE_200
549     , p4_a66 JTF_VARCHAR2_TABLE_200
550     , p4_a67 JTF_VARCHAR2_TABLE_200
551     , p4_a68 JTF_VARCHAR2_TABLE_200
552     , p4_a69 JTF_VARCHAR2_TABLE_200
553     , p4_a70 JTF_VARCHAR2_TABLE_200
554     , p4_a71 JTF_VARCHAR2_TABLE_200
555     , p4_a72 JTF_VARCHAR2_TABLE_200
556     , p4_a73 JTF_VARCHAR2_TABLE_200
557     , p4_a74 JTF_VARCHAR2_TABLE_200
558     , p4_a75 JTF_VARCHAR2_TABLE_200
559     , p4_a76 JTF_VARCHAR2_TABLE_200
560     , p4_a77 JTF_VARCHAR2_TABLE_200
561     , p4_a78 JTF_VARCHAR2_TABLE_200
562     , p4_a79 JTF_VARCHAR2_TABLE_200
563     , p4_a80 JTF_VARCHAR2_TABLE_200
564     , p4_a81 JTF_VARCHAR2_TABLE_200
565     , p4_a82 JTF_VARCHAR2_TABLE_200
566     , p4_a83 JTF_VARCHAR2_TABLE_200
567     , p4_a84 JTF_VARCHAR2_TABLE_200
568     , p4_a85 JTF_VARCHAR2_TABLE_200
569     , p4_a86 JTF_VARCHAR2_TABLE_200
570     , p4_a87 JTF_VARCHAR2_TABLE_200
571     , p4_a88 JTF_VARCHAR2_TABLE_200
572     , p4_a89 JTF_VARCHAR2_TABLE_200
573     , p4_a90 JTF_VARCHAR2_TABLE_200
574     , p4_a91 JTF_VARCHAR2_TABLE_200
575     , p4_a92 JTF_VARCHAR2_TABLE_200
576     , p4_a93 JTF_VARCHAR2_TABLE_200
577     , p4_a94 JTF_VARCHAR2_TABLE_200
578     , p4_a95 JTF_VARCHAR2_TABLE_200
579     , p4_a96 JTF_VARCHAR2_TABLE_200
580     , p4_a97 JTF_VARCHAR2_TABLE_200
581     , p4_a98 JTF_VARCHAR2_TABLE_200
582     , p4_a99 JTF_VARCHAR2_TABLE_200
583     , p4_a100 JTF_VARCHAR2_TABLE_200
584     , p4_a101 JTF_VARCHAR2_TABLE_200
585     , p4_a102 JTF_VARCHAR2_TABLE_200
586     , p4_a103 JTF_VARCHAR2_TABLE_200
587     , p4_a104 JTF_VARCHAR2_TABLE_200
588     , p4_a105 JTF_VARCHAR2_TABLE_100
589     , p4_a106 JTF_VARCHAR2_TABLE_200
590     , p4_a107 JTF_VARCHAR2_TABLE_200
591     , p4_a108 JTF_VARCHAR2_TABLE_200
592     , p4_a109 JTF_VARCHAR2_TABLE_200
593     , p4_a110 JTF_VARCHAR2_TABLE_200
594     , p4_a111 JTF_VARCHAR2_TABLE_200
595     , p4_a112 JTF_VARCHAR2_TABLE_200
596     , p4_a113 JTF_VARCHAR2_TABLE_200
597     , p4_a114 JTF_VARCHAR2_TABLE_200
598     , p4_a115 JTF_VARCHAR2_TABLE_200
599     , p4_a116 JTF_VARCHAR2_TABLE_200
600     , p4_a117 JTF_VARCHAR2_TABLE_200
601     , p4_a118 JTF_VARCHAR2_TABLE_200
602     , p4_a119 JTF_VARCHAR2_TABLE_200
603     , p4_a120 JTF_VARCHAR2_TABLE_200
604     , p4_a121 JTF_NUMBER_TABLE
605     , p4_a122 JTF_NUMBER_TABLE
606     , p5_a0 in out nocopy  NUMBER
607     , p5_a1 in out nocopy  DATE
608     , p5_a2 in out nocopy  DATE
609     , p5_a3 in out nocopy  NUMBER
610     , p5_a4 in out nocopy  NUMBER
611     , p5_a5 in out nocopy  NUMBER
612     , p5_a6 in out nocopy  VARCHAR2
613     , p5_a7 in out nocopy  NUMBER
614     , p5_a8 in out nocopy  VARCHAR2
615     , p5_a9 in out nocopy  NUMBER
616     , p5_a10 in out nocopy  VARCHAR2
617     , p5_a11 in out nocopy  NUMBER
618     , p5_a12 in out nocopy  NUMBER
619     , p5_a13 in out nocopy  NUMBER
620     , p5_a14 in out nocopy  NUMBER
621     , p5_a15 in out nocopy  VARCHAR2
622     , p5_a16 in out nocopy  NUMBER
623     , p5_a17 in out nocopy  VARCHAR2
624     , p5_a18 in out nocopy  VARCHAR2
625     , p5_a19 in out nocopy  NUMBER
626     , p5_a20 in out nocopy  VARCHAR2
627     , p5_a21 in out nocopy  VARCHAR2
628     , p5_a22 in out nocopy  VARCHAR2
629     , p5_a23 in out nocopy  VARCHAR2
630     , p5_a24 in out nocopy  VARCHAR2
631     , p5_a25 in out nocopy  VARCHAR2
632     , p5_a26 in out nocopy  VARCHAR2
633     , p5_a27 in out nocopy  VARCHAR2
634     , p5_a28 in out nocopy  VARCHAR2
635     , p5_a29 in out nocopy  VARCHAR2
636     , p5_a30 in out nocopy  VARCHAR2
637     , p5_a31 in out nocopy  VARCHAR2
638     , p5_a32 in out nocopy  VARCHAR2
639     , p5_a33 in out nocopy  VARCHAR2
640     , p5_a34 in out nocopy  VARCHAR2
641     , p5_a35 in out nocopy  VARCHAR2
642     , p5_a36 in out nocopy  NUMBER
643     , p5_a37 in out nocopy  VARCHAR2
644     , p5_a38 in out nocopy  DATE
645     , p5_a39 in out nocopy  NUMBER
646     , x_return_status out nocopy  VARCHAR2
647     , x_msg_count out nocopy  NUMBER
648     , x_msg_data out nocopy  VARCHAR2
649   );
650 end csi_pricing_attribs_pub_w;