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_SETUPOPTVALUES_PVT_W

Source


1 package okl_setupoptvalues_pvt_w AUTHID CURRENT_USER as
2   /* $Header: OKLESOVS.pls 115.2 2002/12/24 04:03:06 sgorantl noship $ */
3   procedure get_rec(x_return_status out nocopy  VARCHAR2
4     , x_no_data_found out nocopy  number
5     , p3_a0 out nocopy  NUMBER
6     , p3_a1 out nocopy  NUMBER
7     , p3_a2 out nocopy  NUMBER
8     , p3_a3 out nocopy  VARCHAR2
9     , p3_a4 out nocopy  VARCHAR2
10     , p3_a5 out nocopy  DATE
11     , p3_a6 out nocopy  DATE
12     , p3_a7 out nocopy  NUMBER
13     , p3_a8 out nocopy  DATE
14     , p3_a9 out nocopy  NUMBER
15     , p3_a10 out nocopy  DATE
16     , p3_a11 out nocopy  NUMBER
17     , p0_a0  NUMBER := 0-1962.0724
18     , p0_a1  NUMBER := 0-1962.0724
19     , p0_a2  NUMBER := 0-1962.0724
20     , p0_a3  VARCHAR2 := fnd_api.g_miss_char
21     , p0_a4  VARCHAR2 := fnd_api.g_miss_char
22     , p0_a5  DATE := fnd_api.g_miss_date
23     , p0_a6  DATE := fnd_api.g_miss_date
24     , p0_a7  NUMBER := 0-1962.0724
25     , p0_a8  DATE := fnd_api.g_miss_date
26     , p0_a9  NUMBER := 0-1962.0724
27     , p0_a10  DATE := fnd_api.g_miss_date
28     , p0_a11  NUMBER := 0-1962.0724
29   );
30   procedure get_rul_rec(x_return_status out nocopy  VARCHAR2
31     , x_no_data_found out nocopy  number
32     , p3_a0 out nocopy  NUMBER
33     , p3_a1 out nocopy  NUMBER
34     , p3_a2 out nocopy  VARCHAR2
35     , p3_a3 out nocopy  VARCHAR2
36     , p3_a4 out nocopy  VARCHAR2
37     , p3_a5 out nocopy  VARCHAR2
38     , p3_a6 out nocopy  VARCHAR2
39     , p3_a7 out nocopy  VARCHAR2
40     , p3_a8 out nocopy  VARCHAR2
41     , p3_a9 out nocopy  VARCHAR2
42     , p3_a10 out nocopy  VARCHAR2
43     , p3_a11 out nocopy  VARCHAR2
44     , p3_a12 out nocopy  NUMBER
45     , p3_a13 out nocopy  NUMBER
46     , p3_a14 out nocopy  NUMBER
47     , p3_a15 out nocopy  VARCHAR2
48     , p3_a16 out nocopy  VARCHAR2
49     , p3_a17 out nocopy  VARCHAR2
50     , p3_a18 out nocopy  VARCHAR2
51     , p3_a19 out nocopy  VARCHAR2
52     , p3_a20 out nocopy  VARCHAR2
53     , p3_a21 out nocopy  VARCHAR2
54     , p3_a22 out nocopy  VARCHAR2
55     , p3_a23 out nocopy  VARCHAR2
56     , p3_a24 out nocopy  VARCHAR2
57     , p3_a25 out nocopy  VARCHAR2
58     , p3_a26 out nocopy  VARCHAR2
59     , p3_a27 out nocopy  VARCHAR2
60     , p3_a28 out nocopy  VARCHAR2
61     , p3_a29 out nocopy  VARCHAR2
62     , p3_a30 out nocopy  VARCHAR2
63     , p3_a31 out nocopy  VARCHAR2
64     , p3_a32 out nocopy  VARCHAR2
65     , p3_a33 out nocopy  VARCHAR2
66     , p3_a34 out nocopy  NUMBER
67     , p3_a35 out nocopy  DATE
68     , p3_a36 out nocopy  NUMBER
69     , p3_a37 out nocopy  DATE
70     , p3_a38 out nocopy  NUMBER
71     , p3_a39 out nocopy  VARCHAR2
72     , p3_a40 out nocopy  VARCHAR2
73     , p3_a41 out nocopy  VARCHAR2
74     , p3_a42 out nocopy  VARCHAR2
75     , p3_a43 out nocopy  VARCHAR2
76     , p3_a44 out nocopy  VARCHAR2
77     , p3_a45 out nocopy  VARCHAR2
78     , p3_a46 out nocopy  VARCHAR2
79     , p3_a47 out nocopy  VARCHAR2
80     , p3_a48 out nocopy  VARCHAR2
81     , p3_a49 out nocopy  VARCHAR2
82     , p3_a50 out nocopy  VARCHAR2
83     , p3_a51 out nocopy  VARCHAR2
84     , p3_a52 out nocopy  VARCHAR2
85     , p3_a53 out nocopy  VARCHAR2
86     , p3_a54 out nocopy  VARCHAR2
87     , p3_a55 out nocopy  VARCHAR2
88     , p3_a56 out nocopy  VARCHAR2
89     , p3_a57 out nocopy  VARCHAR2
90     , p3_a58 out nocopy  VARCHAR2
91     , p3_a59 out nocopy  NUMBER
92     , p0_a0  NUMBER := 0-1962.0724
93     , p0_a1  NUMBER := 0-1962.0724
94     , p0_a2  VARCHAR2 := fnd_api.g_miss_char
95     , p0_a3  VARCHAR2 := fnd_api.g_miss_char
96     , p0_a4  VARCHAR2 := fnd_api.g_miss_char
97     , p0_a5  VARCHAR2 := fnd_api.g_miss_char
98     , p0_a6  VARCHAR2 := fnd_api.g_miss_char
99     , p0_a7  VARCHAR2 := fnd_api.g_miss_char
100     , p0_a8  VARCHAR2 := fnd_api.g_miss_char
101     , p0_a9  VARCHAR2 := fnd_api.g_miss_char
102     , p0_a10  VARCHAR2 := fnd_api.g_miss_char
103     , p0_a11  VARCHAR2 := fnd_api.g_miss_char
104     , p0_a12  NUMBER := 0-1962.0724
105     , p0_a13  NUMBER := 0-1962.0724
106     , p0_a14  NUMBER := 0-1962.0724
107     , p0_a15  VARCHAR2 := fnd_api.g_miss_char
108     , p0_a16  VARCHAR2 := fnd_api.g_miss_char
109     , p0_a17  VARCHAR2 := fnd_api.g_miss_char
110     , p0_a18  VARCHAR2 := fnd_api.g_miss_char
111     , p0_a19  VARCHAR2 := fnd_api.g_miss_char
112     , p0_a20  VARCHAR2 := fnd_api.g_miss_char
113     , p0_a21  VARCHAR2 := fnd_api.g_miss_char
114     , p0_a22  VARCHAR2 := fnd_api.g_miss_char
115     , p0_a23  VARCHAR2 := fnd_api.g_miss_char
116     , p0_a24  VARCHAR2 := fnd_api.g_miss_char
117     , p0_a25  VARCHAR2 := fnd_api.g_miss_char
118     , p0_a26  VARCHAR2 := fnd_api.g_miss_char
119     , p0_a27  VARCHAR2 := fnd_api.g_miss_char
120     , p0_a28  VARCHAR2 := fnd_api.g_miss_char
121     , p0_a29  VARCHAR2 := fnd_api.g_miss_char
122     , p0_a30  VARCHAR2 := fnd_api.g_miss_char
123     , p0_a31  VARCHAR2 := fnd_api.g_miss_char
124     , p0_a32  VARCHAR2 := fnd_api.g_miss_char
125     , p0_a33  VARCHAR2 := fnd_api.g_miss_char
126     , p0_a34  NUMBER := 0-1962.0724
127     , p0_a35  DATE := fnd_api.g_miss_date
128     , p0_a36  NUMBER := 0-1962.0724
129     , p0_a37  DATE := fnd_api.g_miss_date
130     , p0_a38  NUMBER := 0-1962.0724
131     , p0_a39  VARCHAR2 := fnd_api.g_miss_char
132     , p0_a40  VARCHAR2 := fnd_api.g_miss_char
133     , p0_a41  VARCHAR2 := fnd_api.g_miss_char
134     , p0_a42  VARCHAR2 := fnd_api.g_miss_char
135     , p0_a43  VARCHAR2 := fnd_api.g_miss_char
136     , p0_a44  VARCHAR2 := fnd_api.g_miss_char
137     , p0_a45  VARCHAR2 := fnd_api.g_miss_char
138     , p0_a46  VARCHAR2 := fnd_api.g_miss_char
139     , p0_a47  VARCHAR2 := fnd_api.g_miss_char
140     , p0_a48  VARCHAR2 := fnd_api.g_miss_char
141     , p0_a49  VARCHAR2 := fnd_api.g_miss_char
142     , p0_a50  VARCHAR2 := fnd_api.g_miss_char
143     , p0_a51  VARCHAR2 := fnd_api.g_miss_char
144     , p0_a52  VARCHAR2 := fnd_api.g_miss_char
145     , p0_a53  VARCHAR2 := fnd_api.g_miss_char
146     , p0_a54  VARCHAR2 := fnd_api.g_miss_char
147     , p0_a55  VARCHAR2 := fnd_api.g_miss_char
148     , p0_a56  VARCHAR2 := fnd_api.g_miss_char
149     , p0_a57  VARCHAR2 := fnd_api.g_miss_char
150     , p0_a58  VARCHAR2 := fnd_api.g_miss_char
151     , p0_a59  NUMBER := 0-1962.0724
152   );
153   procedure insert_optvalues(p_api_version  NUMBER
154     , p_init_msg_list  VARCHAR2
155     , x_return_status out nocopy  VARCHAR2
156     , x_msg_count out nocopy  NUMBER
157     , x_msg_data out nocopy  VARCHAR2
158     , p7_a0 out nocopy  NUMBER
159     , p7_a1 out nocopy  NUMBER
160     , p7_a2 out nocopy  NUMBER
161     , p7_a3 out nocopy  VARCHAR2
162     , p7_a4 out nocopy  VARCHAR2
163     , p7_a5 out nocopy  DATE
164     , p7_a6 out nocopy  DATE
165     , p7_a7 out nocopy  NUMBER
166     , p7_a8 out nocopy  DATE
167     , p7_a9 out nocopy  NUMBER
168     , p7_a10 out nocopy  DATE
169     , p7_a11 out nocopy  NUMBER
170     , p5_a0  NUMBER := 0-1962.0724
171     , p5_a1  NUMBER := 0-1962.0724
172     , p5_a2  VARCHAR2 := fnd_api.g_miss_char
173     , p5_a3  VARCHAR2 := fnd_api.g_miss_char
174     , p5_a4  DATE := fnd_api.g_miss_date
175     , p5_a5  DATE := fnd_api.g_miss_date
176     , p5_a6  VARCHAR2 := fnd_api.g_miss_char
177     , p5_a7  VARCHAR2 := fnd_api.g_miss_char
178     , p5_a8  VARCHAR2 := fnd_api.g_miss_char
179     , p5_a9  VARCHAR2 := fnd_api.g_miss_char
180     , p5_a10  VARCHAR2 := fnd_api.g_miss_char
181     , p5_a11  VARCHAR2 := fnd_api.g_miss_char
182     , p5_a12  VARCHAR2 := fnd_api.g_miss_char
183     , p5_a13  VARCHAR2 := fnd_api.g_miss_char
184     , p5_a14  VARCHAR2 := fnd_api.g_miss_char
185     , p5_a15  VARCHAR2 := fnd_api.g_miss_char
186     , p5_a16  VARCHAR2 := fnd_api.g_miss_char
187     , p5_a17  VARCHAR2 := fnd_api.g_miss_char
188     , p5_a18  VARCHAR2 := fnd_api.g_miss_char
189     , p5_a19  VARCHAR2 := fnd_api.g_miss_char
190     , p5_a20  VARCHAR2 := fnd_api.g_miss_char
191     , p5_a21  VARCHAR2 := fnd_api.g_miss_char
192     , p5_a22  NUMBER := 0-1962.0724
193     , p5_a23  DATE := fnd_api.g_miss_date
194     , p5_a24  NUMBER := 0-1962.0724
195     , p5_a25  DATE := fnd_api.g_miss_date
196     , p5_a26  NUMBER := 0-1962.0724
197     , p6_a0  NUMBER := 0-1962.0724
198     , p6_a1  NUMBER := 0-1962.0724
199     , p6_a2  NUMBER := 0-1962.0724
200     , p6_a3  VARCHAR2 := fnd_api.g_miss_char
201     , p6_a4  VARCHAR2 := fnd_api.g_miss_char
202     , p6_a5  DATE := fnd_api.g_miss_date
203     , p6_a6  DATE := fnd_api.g_miss_date
204     , p6_a7  NUMBER := 0-1962.0724
205     , p6_a8  DATE := fnd_api.g_miss_date
206     , p6_a9  NUMBER := 0-1962.0724
207     , p6_a10  DATE := fnd_api.g_miss_date
208     , p6_a11  NUMBER := 0-1962.0724
209   );
210   procedure update_optvalues(p_api_version  NUMBER
211     , p_init_msg_list  VARCHAR2
212     , x_return_status out nocopy  VARCHAR2
213     , x_msg_count out nocopy  NUMBER
214     , x_msg_data out nocopy  VARCHAR2
215     , p7_a0 out nocopy  NUMBER
216     , p7_a1 out nocopy  NUMBER
217     , p7_a2 out nocopy  NUMBER
218     , p7_a3 out nocopy  VARCHAR2
219     , p7_a4 out nocopy  VARCHAR2
220     , p7_a5 out nocopy  DATE
221     , p7_a6 out nocopy  DATE
222     , p7_a7 out nocopy  NUMBER
223     , p7_a8 out nocopy  DATE
224     , p7_a9 out nocopy  NUMBER
225     , p7_a10 out nocopy  DATE
226     , p7_a11 out nocopy  NUMBER
227     , p5_a0  NUMBER := 0-1962.0724
228     , p5_a1  NUMBER := 0-1962.0724
229     , p5_a2  VARCHAR2 := fnd_api.g_miss_char
230     , p5_a3  VARCHAR2 := fnd_api.g_miss_char
231     , p5_a4  DATE := fnd_api.g_miss_date
232     , p5_a5  DATE := fnd_api.g_miss_date
233     , p5_a6  VARCHAR2 := fnd_api.g_miss_char
234     , p5_a7  VARCHAR2 := fnd_api.g_miss_char
235     , p5_a8  VARCHAR2 := fnd_api.g_miss_char
236     , p5_a9  VARCHAR2 := fnd_api.g_miss_char
237     , p5_a10  VARCHAR2 := fnd_api.g_miss_char
238     , p5_a11  VARCHAR2 := fnd_api.g_miss_char
239     , p5_a12  VARCHAR2 := fnd_api.g_miss_char
240     , p5_a13  VARCHAR2 := fnd_api.g_miss_char
241     , p5_a14  VARCHAR2 := fnd_api.g_miss_char
242     , p5_a15  VARCHAR2 := fnd_api.g_miss_char
243     , p5_a16  VARCHAR2 := fnd_api.g_miss_char
244     , p5_a17  VARCHAR2 := fnd_api.g_miss_char
245     , p5_a18  VARCHAR2 := fnd_api.g_miss_char
246     , p5_a19  VARCHAR2 := fnd_api.g_miss_char
247     , p5_a20  VARCHAR2 := fnd_api.g_miss_char
248     , p5_a21  VARCHAR2 := fnd_api.g_miss_char
249     , p5_a22  NUMBER := 0-1962.0724
250     , p5_a23  DATE := fnd_api.g_miss_date
251     , p5_a24  NUMBER := 0-1962.0724
252     , p5_a25  DATE := fnd_api.g_miss_date
253     , p5_a26  NUMBER := 0-1962.0724
254     , p6_a0  NUMBER := 0-1962.0724
255     , p6_a1  NUMBER := 0-1962.0724
256     , p6_a2  NUMBER := 0-1962.0724
257     , p6_a3  VARCHAR2 := fnd_api.g_miss_char
258     , p6_a4  VARCHAR2 := fnd_api.g_miss_char
259     , p6_a5  DATE := fnd_api.g_miss_date
260     , p6_a6  DATE := fnd_api.g_miss_date
261     , p6_a7  NUMBER := 0-1962.0724
262     , p6_a8  DATE := fnd_api.g_miss_date
263     , p6_a9  NUMBER := 0-1962.0724
264     , p6_a10  DATE := fnd_api.g_miss_date
265     , p6_a11  NUMBER := 0-1962.0724
266   );
267 end okl_setupoptvalues_pvt_w;