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.OKL_SETUP_PRCPARAMS_PUB_W

Source


1 package okl_setup_prcparams_pub_w AUTHID CURRENT_USER as
2   /* $Header: OKLUPPRS.pls 115.0 2004/07/02 02:38:34 sgorantl noship $ */
3   procedure create_price_parm(p_api_version  NUMBER
4     , p_init_msg_list  VARCHAR2
5     , p3_a0 out nocopy  NUMBER
6     , p3_a1 out nocopy  NUMBER
7     , p3_a2 out nocopy  VARCHAR2
8     , p3_a3 out nocopy  VARCHAR2
9     , p3_a4 out nocopy  DATE
10     , p3_a5 out nocopy  DATE
11     , p3_a6 out nocopy  VARCHAR2
12     , p3_a7 out nocopy  VARCHAR2
13     , p3_a8 out nocopy  VARCHAR2
14     , p3_a9 out nocopy  VARCHAR2
15     , p3_a10 out nocopy  VARCHAR2
16     , p3_a11 out nocopy  VARCHAR2
17     , p3_a12 out nocopy  VARCHAR2
18     , p3_a13 out nocopy  VARCHAR2
19     , p3_a14 out nocopy  VARCHAR2
20     , p3_a15 out nocopy  VARCHAR2
21     , p3_a16 out nocopy  VARCHAR2
22     , p3_a17 out nocopy  VARCHAR2
23     , p3_a18 out nocopy  VARCHAR2
24     , p3_a19 out nocopy  VARCHAR2
25     , p3_a20 out nocopy  VARCHAR2
26     , p3_a21 out nocopy  VARCHAR2
27     , p3_a22 out nocopy  VARCHAR2
28     , p3_a23 out nocopy  VARCHAR2
29     , p3_a24 out nocopy  VARCHAR2
30     , p3_a25 out nocopy  VARCHAR2
31     , p3_a26 out nocopy  VARCHAR2
32     , p3_a27 out nocopy  NUMBER
33     , p3_a28 out nocopy  NUMBER
34     , p3_a29 out nocopy  DATE
35     , p3_a30 out nocopy  DATE
36     , p3_a31 out nocopy  NUMBER
37     , x_return_status out nocopy  VARCHAR2
38     , x_msg_count out nocopy  NUMBER
39     , x_msg_data out nocopy  VARCHAR2
40     , p2_a0  NUMBER := 0-1962.0724
41     , p2_a1  NUMBER := 0-1962.0724
42     , p2_a2  VARCHAR2 := fnd_api.g_miss_char
43     , p2_a3  VARCHAR2 := fnd_api.g_miss_char
44     , p2_a4  DATE := fnd_api.g_miss_date
45     , p2_a5  DATE := fnd_api.g_miss_date
46     , p2_a6  VARCHAR2 := fnd_api.g_miss_char
47     , p2_a7  VARCHAR2 := fnd_api.g_miss_char
48     , p2_a8  VARCHAR2 := fnd_api.g_miss_char
49     , p2_a9  VARCHAR2 := fnd_api.g_miss_char
50     , p2_a10  VARCHAR2 := fnd_api.g_miss_char
51     , p2_a11  VARCHAR2 := fnd_api.g_miss_char
52     , p2_a12  VARCHAR2 := fnd_api.g_miss_char
53     , p2_a13  VARCHAR2 := fnd_api.g_miss_char
54     , p2_a14  VARCHAR2 := fnd_api.g_miss_char
55     , p2_a15  VARCHAR2 := fnd_api.g_miss_char
56     , p2_a16  VARCHAR2 := fnd_api.g_miss_char
57     , p2_a17  VARCHAR2 := fnd_api.g_miss_char
58     , p2_a18  VARCHAR2 := fnd_api.g_miss_char
59     , p2_a19  VARCHAR2 := fnd_api.g_miss_char
60     , p2_a20  VARCHAR2 := fnd_api.g_miss_char
61     , p2_a21  VARCHAR2 := fnd_api.g_miss_char
62     , p2_a22  VARCHAR2 := fnd_api.g_miss_char
63     , p2_a23  VARCHAR2 := fnd_api.g_miss_char
64     , p2_a24  VARCHAR2 := fnd_api.g_miss_char
65     , p2_a25  VARCHAR2 := fnd_api.g_miss_char
66     , p2_a26  VARCHAR2 := fnd_api.g_miss_char
67     , p2_a27  NUMBER := 0-1962.0724
68     , p2_a28  NUMBER := 0-1962.0724
69     , p2_a29  DATE := fnd_api.g_miss_date
70     , p2_a30  DATE := fnd_api.g_miss_date
71     , p2_a31  NUMBER := 0-1962.0724
72   );
73   procedure update_price_parm(p_api_version  NUMBER
74     , p_init_msg_list  VARCHAR2
75     , p3_a0 out nocopy  NUMBER
76     , p3_a1 out nocopy  NUMBER
77     , p3_a2 out nocopy  VARCHAR2
78     , p3_a3 out nocopy  VARCHAR2
79     , p3_a4 out nocopy  DATE
80     , p3_a5 out nocopy  DATE
81     , p3_a6 out nocopy  VARCHAR2
82     , p3_a7 out nocopy  VARCHAR2
83     , p3_a8 out nocopy  VARCHAR2
84     , p3_a9 out nocopy  VARCHAR2
85     , p3_a10 out nocopy  VARCHAR2
86     , p3_a11 out nocopy  VARCHAR2
87     , p3_a12 out nocopy  VARCHAR2
88     , p3_a13 out nocopy  VARCHAR2
89     , p3_a14 out nocopy  VARCHAR2
90     , p3_a15 out nocopy  VARCHAR2
91     , p3_a16 out nocopy  VARCHAR2
92     , p3_a17 out nocopy  VARCHAR2
93     , p3_a18 out nocopy  VARCHAR2
94     , p3_a19 out nocopy  VARCHAR2
95     , p3_a20 out nocopy  VARCHAR2
96     , p3_a21 out nocopy  VARCHAR2
97     , p3_a22 out nocopy  VARCHAR2
98     , p3_a23 out nocopy  VARCHAR2
99     , p3_a24 out nocopy  VARCHAR2
100     , p3_a25 out nocopy  VARCHAR2
101     , p3_a26 out nocopy  VARCHAR2
102     , p3_a27 out nocopy  NUMBER
103     , p3_a28 out nocopy  NUMBER
104     , p3_a29 out nocopy  DATE
105     , p3_a30 out nocopy  DATE
106     , p3_a31 out nocopy  NUMBER
107     , x_return_status out nocopy  VARCHAR2
108     , x_msg_count out nocopy  NUMBER
109     , x_msg_data out nocopy  VARCHAR2
110     , p2_a0  NUMBER := 0-1962.0724
111     , p2_a1  NUMBER := 0-1962.0724
112     , p2_a2  VARCHAR2 := fnd_api.g_miss_char
113     , p2_a3  VARCHAR2 := fnd_api.g_miss_char
114     , p2_a4  DATE := fnd_api.g_miss_date
115     , p2_a5  DATE := fnd_api.g_miss_date
116     , p2_a6  VARCHAR2 := fnd_api.g_miss_char
117     , p2_a7  VARCHAR2 := fnd_api.g_miss_char
118     , p2_a8  VARCHAR2 := fnd_api.g_miss_char
119     , p2_a9  VARCHAR2 := fnd_api.g_miss_char
120     , p2_a10  VARCHAR2 := fnd_api.g_miss_char
121     , p2_a11  VARCHAR2 := fnd_api.g_miss_char
122     , p2_a12  VARCHAR2 := fnd_api.g_miss_char
123     , p2_a13  VARCHAR2 := fnd_api.g_miss_char
124     , p2_a14  VARCHAR2 := fnd_api.g_miss_char
125     , p2_a15  VARCHAR2 := fnd_api.g_miss_char
126     , p2_a16  VARCHAR2 := fnd_api.g_miss_char
127     , p2_a17  VARCHAR2 := fnd_api.g_miss_char
128     , p2_a18  VARCHAR2 := fnd_api.g_miss_char
129     , p2_a19  VARCHAR2 := fnd_api.g_miss_char
130     , p2_a20  VARCHAR2 := fnd_api.g_miss_char
131     , p2_a21  VARCHAR2 := fnd_api.g_miss_char
132     , p2_a22  VARCHAR2 := fnd_api.g_miss_char
133     , p2_a23  VARCHAR2 := fnd_api.g_miss_char
134     , p2_a24  VARCHAR2 := fnd_api.g_miss_char
135     , p2_a25  VARCHAR2 := fnd_api.g_miss_char
136     , p2_a26  VARCHAR2 := fnd_api.g_miss_char
137     , p2_a27  NUMBER := 0-1962.0724
138     , p2_a28  NUMBER := 0-1962.0724
139     , p2_a29  DATE := fnd_api.g_miss_date
140     , p2_a30  DATE := fnd_api.g_miss_date
141     , p2_a31  NUMBER := 0-1962.0724
142   );
143   procedure create_price_parm(p_api_version  NUMBER
144     , p_init_msg_list  VARCHAR2
145     , p2_a0 JTF_NUMBER_TABLE
146     , p2_a1 JTF_NUMBER_TABLE
147     , p2_a2 JTF_VARCHAR2_TABLE_200
148     , p2_a3 JTF_VARCHAR2_TABLE_100
149     , p2_a4 JTF_DATE_TABLE
150     , p2_a5 JTF_DATE_TABLE
151     , p2_a6 JTF_VARCHAR2_TABLE_2000
152     , p2_a7 JTF_VARCHAR2_TABLE_100
153     , p2_a8 JTF_VARCHAR2_TABLE_100
154     , p2_a9 JTF_VARCHAR2_TABLE_100
155     , p2_a10 JTF_VARCHAR2_TABLE_200
156     , p2_a11 JTF_VARCHAR2_TABLE_100
157     , p2_a12 JTF_VARCHAR2_TABLE_500
158     , p2_a13 JTF_VARCHAR2_TABLE_500
159     , p2_a14 JTF_VARCHAR2_TABLE_500
160     , p2_a15 JTF_VARCHAR2_TABLE_500
161     , p2_a16 JTF_VARCHAR2_TABLE_500
162     , p2_a17 JTF_VARCHAR2_TABLE_500
163     , p2_a18 JTF_VARCHAR2_TABLE_500
164     , p2_a19 JTF_VARCHAR2_TABLE_500
165     , p2_a20 JTF_VARCHAR2_TABLE_500
166     , p2_a21 JTF_VARCHAR2_TABLE_500
167     , p2_a22 JTF_VARCHAR2_TABLE_500
168     , p2_a23 JTF_VARCHAR2_TABLE_500
169     , p2_a24 JTF_VARCHAR2_TABLE_500
170     , p2_a25 JTF_VARCHAR2_TABLE_500
171     , p2_a26 JTF_VARCHAR2_TABLE_500
172     , p2_a27 JTF_NUMBER_TABLE
173     , p2_a28 JTF_NUMBER_TABLE
174     , p2_a29 JTF_DATE_TABLE
175     , p2_a30 JTF_DATE_TABLE
176     , p2_a31 JTF_NUMBER_TABLE
177     , p3_a0 out nocopy JTF_NUMBER_TABLE
178     , p3_a1 out nocopy JTF_NUMBER_TABLE
179     , p3_a2 out nocopy JTF_VARCHAR2_TABLE_200
180     , p3_a3 out nocopy JTF_VARCHAR2_TABLE_100
181     , p3_a4 out nocopy JTF_DATE_TABLE
182     , p3_a5 out nocopy JTF_DATE_TABLE
183     , p3_a6 out nocopy JTF_VARCHAR2_TABLE_2000
184     , p3_a7 out nocopy JTF_VARCHAR2_TABLE_100
185     , p3_a8 out nocopy JTF_VARCHAR2_TABLE_100
186     , p3_a9 out nocopy JTF_VARCHAR2_TABLE_100
187     , p3_a10 out nocopy JTF_VARCHAR2_TABLE_200
188     , p3_a11 out nocopy JTF_VARCHAR2_TABLE_100
189     , p3_a12 out nocopy JTF_VARCHAR2_TABLE_500
190     , p3_a13 out nocopy JTF_VARCHAR2_TABLE_500
191     , p3_a14 out nocopy JTF_VARCHAR2_TABLE_500
192     , p3_a15 out nocopy JTF_VARCHAR2_TABLE_500
193     , p3_a16 out nocopy JTF_VARCHAR2_TABLE_500
194     , p3_a17 out nocopy JTF_VARCHAR2_TABLE_500
195     , p3_a18 out nocopy JTF_VARCHAR2_TABLE_500
196     , p3_a19 out nocopy JTF_VARCHAR2_TABLE_500
197     , p3_a20 out nocopy JTF_VARCHAR2_TABLE_500
198     , p3_a21 out nocopy JTF_VARCHAR2_TABLE_500
199     , p3_a22 out nocopy JTF_VARCHAR2_TABLE_500
200     , p3_a23 out nocopy JTF_VARCHAR2_TABLE_500
201     , p3_a24 out nocopy JTF_VARCHAR2_TABLE_500
202     , p3_a25 out nocopy JTF_VARCHAR2_TABLE_500
203     , p3_a26 out nocopy JTF_VARCHAR2_TABLE_500
204     , p3_a27 out nocopy JTF_NUMBER_TABLE
205     , p3_a28 out nocopy JTF_NUMBER_TABLE
206     , p3_a29 out nocopy JTF_DATE_TABLE
207     , p3_a30 out nocopy JTF_DATE_TABLE
208     , p3_a31 out nocopy JTF_NUMBER_TABLE
209     , x_return_status out nocopy  VARCHAR2
210     , x_msg_count out nocopy  NUMBER
211     , x_msg_data out nocopy  VARCHAR2
212   );
213   procedure update_price_parm(p_api_version  NUMBER
214     , p_init_msg_list  VARCHAR2
215     , p2_a0 JTF_NUMBER_TABLE
216     , p2_a1 JTF_NUMBER_TABLE
217     , p2_a2 JTF_VARCHAR2_TABLE_200
218     , p2_a3 JTF_VARCHAR2_TABLE_100
219     , p2_a4 JTF_DATE_TABLE
220     , p2_a5 JTF_DATE_TABLE
221     , p2_a6 JTF_VARCHAR2_TABLE_2000
222     , p2_a7 JTF_VARCHAR2_TABLE_100
223     , p2_a8 JTF_VARCHAR2_TABLE_100
224     , p2_a9 JTF_VARCHAR2_TABLE_100
225     , p2_a10 JTF_VARCHAR2_TABLE_200
226     , p2_a11 JTF_VARCHAR2_TABLE_100
227     , p2_a12 JTF_VARCHAR2_TABLE_500
228     , p2_a13 JTF_VARCHAR2_TABLE_500
229     , p2_a14 JTF_VARCHAR2_TABLE_500
230     , p2_a15 JTF_VARCHAR2_TABLE_500
231     , p2_a16 JTF_VARCHAR2_TABLE_500
232     , p2_a17 JTF_VARCHAR2_TABLE_500
233     , p2_a18 JTF_VARCHAR2_TABLE_500
234     , p2_a19 JTF_VARCHAR2_TABLE_500
235     , p2_a20 JTF_VARCHAR2_TABLE_500
236     , p2_a21 JTF_VARCHAR2_TABLE_500
237     , p2_a22 JTF_VARCHAR2_TABLE_500
238     , p2_a23 JTF_VARCHAR2_TABLE_500
239     , p2_a24 JTF_VARCHAR2_TABLE_500
240     , p2_a25 JTF_VARCHAR2_TABLE_500
241     , p2_a26 JTF_VARCHAR2_TABLE_500
242     , p2_a27 JTF_NUMBER_TABLE
243     , p2_a28 JTF_NUMBER_TABLE
244     , p2_a29 JTF_DATE_TABLE
245     , p2_a30 JTF_DATE_TABLE
246     , p2_a31 JTF_NUMBER_TABLE
247     , p3_a0 out nocopy JTF_NUMBER_TABLE
248     , p3_a1 out nocopy JTF_NUMBER_TABLE
249     , p3_a2 out nocopy JTF_VARCHAR2_TABLE_200
250     , p3_a3 out nocopy JTF_VARCHAR2_TABLE_100
251     , p3_a4 out nocopy JTF_DATE_TABLE
252     , p3_a5 out nocopy JTF_DATE_TABLE
253     , p3_a6 out nocopy JTF_VARCHAR2_TABLE_2000
254     , p3_a7 out nocopy JTF_VARCHAR2_TABLE_100
255     , p3_a8 out nocopy JTF_VARCHAR2_TABLE_100
256     , p3_a9 out nocopy JTF_VARCHAR2_TABLE_100
257     , p3_a10 out nocopy JTF_VARCHAR2_TABLE_200
258     , p3_a11 out nocopy JTF_VARCHAR2_TABLE_100
259     , p3_a12 out nocopy JTF_VARCHAR2_TABLE_500
260     , p3_a13 out nocopy JTF_VARCHAR2_TABLE_500
261     , p3_a14 out nocopy JTF_VARCHAR2_TABLE_500
262     , p3_a15 out nocopy JTF_VARCHAR2_TABLE_500
263     , p3_a16 out nocopy JTF_VARCHAR2_TABLE_500
264     , p3_a17 out nocopy JTF_VARCHAR2_TABLE_500
265     , p3_a18 out nocopy JTF_VARCHAR2_TABLE_500
266     , p3_a19 out nocopy JTF_VARCHAR2_TABLE_500
267     , p3_a20 out nocopy JTF_VARCHAR2_TABLE_500
268     , p3_a21 out nocopy JTF_VARCHAR2_TABLE_500
269     , p3_a22 out nocopy JTF_VARCHAR2_TABLE_500
270     , p3_a23 out nocopy JTF_VARCHAR2_TABLE_500
271     , p3_a24 out nocopy JTF_VARCHAR2_TABLE_500
272     , p3_a25 out nocopy JTF_VARCHAR2_TABLE_500
273     , p3_a26 out nocopy JTF_VARCHAR2_TABLE_500
274     , p3_a27 out nocopy JTF_NUMBER_TABLE
275     , p3_a28 out nocopy JTF_NUMBER_TABLE
276     , p3_a29 out nocopy JTF_DATE_TABLE
277     , p3_a30 out nocopy JTF_DATE_TABLE
278     , p3_a31 out nocopy JTF_NUMBER_TABLE
279     , x_return_status out nocopy  VARCHAR2
280     , x_msg_count out nocopy  NUMBER
281     , x_msg_data out nocopy  VARCHAR2
282   );
283 end okl_setup_prcparams_pub_w;