[Home] [Help]
PACKAGE: APPS.OKL_OPERANDS_PUB_W
Source
1 package okl_operands_pub_w AUTHID CURRENT_USER as
2 /* $Header: OKLUOPDS.pls 120.1 2005/07/18 10:30:44 asawanka noship $ */
3 procedure insert_operands(p_api_version NUMBER
4 , p_init_msg_list VARCHAR2
5 , x_return_status out nocopy VARCHAR2
6 , x_msg_count out nocopy NUMBER
7 , x_msg_data out nocopy VARCHAR2
8 , p6_a0 out nocopy NUMBER
9 , p6_a1 out nocopy NUMBER
10 , p6_a2 out nocopy VARCHAR2
11 , p6_a3 out nocopy NUMBER
12 , p6_a4 out nocopy NUMBER
13 , p6_a5 out nocopy VARCHAR2
14 , p6_a6 out nocopy VARCHAR2
15 , p6_a7 out nocopy VARCHAR2
16 , p6_a8 out nocopy DATE
17 , p6_a9 out nocopy DATE
18 , p6_a10 out nocopy VARCHAR2
19 , p6_a11 out nocopy VARCHAR2
20 , p6_a12 out nocopy NUMBER
21 , p6_a13 out nocopy NUMBER
22 , p6_a14 out nocopy DATE
23 , p6_a15 out nocopy NUMBER
24 , p6_a16 out nocopy DATE
25 , p6_a17 out nocopy NUMBER
26 , p5_a0 NUMBER := 0-1962.0724
27 , p5_a1 NUMBER := 0-1962.0724
28 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
29 , p5_a3 NUMBER := 0-1962.0724
30 , p5_a4 NUMBER := 0-1962.0724
31 , p5_a5 VARCHAR2 := fnd_api.g_miss_char
32 , p5_a6 VARCHAR2 := fnd_api.g_miss_char
33 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
34 , p5_a8 DATE := fnd_api.g_miss_date
35 , p5_a9 DATE := fnd_api.g_miss_date
36 , p5_a10 VARCHAR2 := fnd_api.g_miss_char
37 , p5_a11 VARCHAR2 := fnd_api.g_miss_char
38 , p5_a12 NUMBER := 0-1962.0724
39 , p5_a13 NUMBER := 0-1962.0724
40 , p5_a14 DATE := fnd_api.g_miss_date
41 , p5_a15 NUMBER := 0-1962.0724
42 , p5_a16 DATE := fnd_api.g_miss_date
43 , p5_a17 NUMBER := 0-1962.0724
44 );
45 procedure insert_operands(p_api_version NUMBER
46 , p_init_msg_list VARCHAR2
47 , x_return_status out nocopy VARCHAR2
48 , x_msg_count out nocopy NUMBER
49 , x_msg_data out nocopy VARCHAR2
50 , p5_a0 JTF_NUMBER_TABLE
51 , p5_a1 JTF_NUMBER_TABLE
52 , p5_a2 JTF_VARCHAR2_TABLE_100
53 , p5_a3 JTF_NUMBER_TABLE
54 , p5_a4 JTF_NUMBER_TABLE
55 , p5_a5 JTF_VARCHAR2_TABLE_200
56 , p5_a6 JTF_VARCHAR2_TABLE_2000
57 , p5_a7 JTF_VARCHAR2_TABLE_100
58 , p5_a8 JTF_DATE_TABLE
59 , p5_a9 JTF_DATE_TABLE
60 , p5_a10 JTF_VARCHAR2_TABLE_200
61 , p5_a11 JTF_VARCHAR2_TABLE_100
62 , p5_a12 JTF_NUMBER_TABLE
63 , p5_a13 JTF_NUMBER_TABLE
64 , p5_a14 JTF_DATE_TABLE
65 , p5_a15 JTF_NUMBER_TABLE
66 , p5_a16 JTF_DATE_TABLE
67 , p5_a17 JTF_NUMBER_TABLE
68 , p6_a0 out nocopy JTF_NUMBER_TABLE
69 , p6_a1 out nocopy JTF_NUMBER_TABLE
70 , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
71 , p6_a3 out nocopy JTF_NUMBER_TABLE
72 , p6_a4 out nocopy JTF_NUMBER_TABLE
73 , p6_a5 out nocopy JTF_VARCHAR2_TABLE_200
74 , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000
75 , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
76 , p6_a8 out nocopy JTF_DATE_TABLE
77 , p6_a9 out nocopy JTF_DATE_TABLE
78 , p6_a10 out nocopy JTF_VARCHAR2_TABLE_200
79 , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
80 , p6_a12 out nocopy JTF_NUMBER_TABLE
81 , p6_a13 out nocopy JTF_NUMBER_TABLE
82 , p6_a14 out nocopy JTF_DATE_TABLE
83 , p6_a15 out nocopy JTF_NUMBER_TABLE
84 , p6_a16 out nocopy JTF_DATE_TABLE
85 , p6_a17 out nocopy JTF_NUMBER_TABLE
86 );
87 procedure lock_operands(p_api_version NUMBER
88 , p_init_msg_list VARCHAR2
89 , x_return_status out nocopy VARCHAR2
90 , x_msg_count out nocopy NUMBER
91 , x_msg_data out nocopy VARCHAR2
92 , p5_a0 NUMBER := 0-1962.0724
93 , p5_a1 NUMBER := 0-1962.0724
94 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
95 , p5_a3 NUMBER := 0-1962.0724
96 , p5_a4 NUMBER := 0-1962.0724
97 , p5_a5 VARCHAR2 := fnd_api.g_miss_char
98 , p5_a6 VARCHAR2 := fnd_api.g_miss_char
99 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
100 , p5_a8 DATE := fnd_api.g_miss_date
101 , p5_a9 DATE := fnd_api.g_miss_date
102 , p5_a10 VARCHAR2 := fnd_api.g_miss_char
103 , p5_a11 VARCHAR2 := fnd_api.g_miss_char
104 , p5_a12 NUMBER := 0-1962.0724
105 , p5_a13 NUMBER := 0-1962.0724
106 , p5_a14 DATE := fnd_api.g_miss_date
107 , p5_a15 NUMBER := 0-1962.0724
108 , p5_a16 DATE := fnd_api.g_miss_date
109 , p5_a17 NUMBER := 0-1962.0724
110 );
111 procedure lock_operands(p_api_version NUMBER
112 , p_init_msg_list VARCHAR2
113 , x_return_status out nocopy VARCHAR2
114 , x_msg_count out nocopy NUMBER
115 , x_msg_data out nocopy VARCHAR2
116 , p5_a0 JTF_NUMBER_TABLE
117 , p5_a1 JTF_NUMBER_TABLE
118 , p5_a2 JTF_VARCHAR2_TABLE_100
119 , p5_a3 JTF_NUMBER_TABLE
120 , p5_a4 JTF_NUMBER_TABLE
121 , p5_a5 JTF_VARCHAR2_TABLE_200
122 , p5_a6 JTF_VARCHAR2_TABLE_2000
123 , p5_a7 JTF_VARCHAR2_TABLE_100
124 , p5_a8 JTF_DATE_TABLE
125 , p5_a9 JTF_DATE_TABLE
126 , p5_a10 JTF_VARCHAR2_TABLE_200
127 , p5_a11 JTF_VARCHAR2_TABLE_100
128 , p5_a12 JTF_NUMBER_TABLE
129 , p5_a13 JTF_NUMBER_TABLE
130 , p5_a14 JTF_DATE_TABLE
131 , p5_a15 JTF_NUMBER_TABLE
132 , p5_a16 JTF_DATE_TABLE
133 , p5_a17 JTF_NUMBER_TABLE
134 );
135 procedure update_operands(p_api_version NUMBER
136 , p_init_msg_list VARCHAR2
137 , x_return_status out nocopy VARCHAR2
138 , x_msg_count out nocopy NUMBER
139 , x_msg_data out nocopy VARCHAR2
140 , p6_a0 out nocopy NUMBER
141 , p6_a1 out nocopy NUMBER
142 , p6_a2 out nocopy VARCHAR2
143 , p6_a3 out nocopy NUMBER
144 , p6_a4 out nocopy NUMBER
145 , p6_a5 out nocopy VARCHAR2
146 , p6_a6 out nocopy VARCHAR2
147 , p6_a7 out nocopy VARCHAR2
148 , p6_a8 out nocopy DATE
149 , p6_a9 out nocopy DATE
150 , p6_a10 out nocopy VARCHAR2
151 , p6_a11 out nocopy VARCHAR2
152 , p6_a12 out nocopy NUMBER
153 , p6_a13 out nocopy NUMBER
154 , p6_a14 out nocopy DATE
155 , p6_a15 out nocopy NUMBER
156 , p6_a16 out nocopy DATE
157 , p6_a17 out nocopy NUMBER
158 , p5_a0 NUMBER := 0-1962.0724
159 , p5_a1 NUMBER := 0-1962.0724
160 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
161 , p5_a3 NUMBER := 0-1962.0724
162 , p5_a4 NUMBER := 0-1962.0724
163 , p5_a5 VARCHAR2 := fnd_api.g_miss_char
164 , p5_a6 VARCHAR2 := fnd_api.g_miss_char
165 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
166 , p5_a8 DATE := fnd_api.g_miss_date
167 , p5_a9 DATE := fnd_api.g_miss_date
168 , p5_a10 VARCHAR2 := fnd_api.g_miss_char
169 , p5_a11 VARCHAR2 := fnd_api.g_miss_char
170 , p5_a12 NUMBER := 0-1962.0724
171 , p5_a13 NUMBER := 0-1962.0724
172 , p5_a14 DATE := fnd_api.g_miss_date
173 , p5_a15 NUMBER := 0-1962.0724
174 , p5_a16 DATE := fnd_api.g_miss_date
175 , p5_a17 NUMBER := 0-1962.0724
176 );
177 procedure update_operands(p_api_version NUMBER
178 , p_init_msg_list VARCHAR2
179 , x_return_status out nocopy VARCHAR2
180 , x_msg_count out nocopy NUMBER
181 , x_msg_data out nocopy VARCHAR2
182 , p5_a0 JTF_NUMBER_TABLE
183 , p5_a1 JTF_NUMBER_TABLE
184 , p5_a2 JTF_VARCHAR2_TABLE_100
185 , p5_a3 JTF_NUMBER_TABLE
186 , p5_a4 JTF_NUMBER_TABLE
187 , p5_a5 JTF_VARCHAR2_TABLE_200
188 , p5_a6 JTF_VARCHAR2_TABLE_2000
189 , p5_a7 JTF_VARCHAR2_TABLE_100
190 , p5_a8 JTF_DATE_TABLE
191 , p5_a9 JTF_DATE_TABLE
192 , p5_a10 JTF_VARCHAR2_TABLE_200
193 , p5_a11 JTF_VARCHAR2_TABLE_100
194 , p5_a12 JTF_NUMBER_TABLE
195 , p5_a13 JTF_NUMBER_TABLE
196 , p5_a14 JTF_DATE_TABLE
197 , p5_a15 JTF_NUMBER_TABLE
198 , p5_a16 JTF_DATE_TABLE
199 , p5_a17 JTF_NUMBER_TABLE
200 , p6_a0 out nocopy JTF_NUMBER_TABLE
201 , p6_a1 out nocopy JTF_NUMBER_TABLE
202 , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
203 , p6_a3 out nocopy JTF_NUMBER_TABLE
204 , p6_a4 out nocopy JTF_NUMBER_TABLE
205 , p6_a5 out nocopy JTF_VARCHAR2_TABLE_200
206 , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000
207 , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
208 , p6_a8 out nocopy JTF_DATE_TABLE
209 , p6_a9 out nocopy JTF_DATE_TABLE
210 , p6_a10 out nocopy JTF_VARCHAR2_TABLE_200
211 , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
212 , p6_a12 out nocopy JTF_NUMBER_TABLE
213 , p6_a13 out nocopy JTF_NUMBER_TABLE
214 , p6_a14 out nocopy JTF_DATE_TABLE
215 , p6_a15 out nocopy JTF_NUMBER_TABLE
216 , p6_a16 out nocopy JTF_DATE_TABLE
217 , p6_a17 out nocopy JTF_NUMBER_TABLE
218 );
219 procedure delete_operands(p_api_version NUMBER
220 , p_init_msg_list VARCHAR2
221 , x_return_status out nocopy VARCHAR2
222 , x_msg_count out nocopy NUMBER
223 , x_msg_data out nocopy VARCHAR2
224 , p5_a0 NUMBER := 0-1962.0724
225 , p5_a1 NUMBER := 0-1962.0724
226 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
227 , p5_a3 NUMBER := 0-1962.0724
228 , p5_a4 NUMBER := 0-1962.0724
229 , p5_a5 VARCHAR2 := fnd_api.g_miss_char
230 , p5_a6 VARCHAR2 := fnd_api.g_miss_char
231 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
232 , p5_a8 DATE := fnd_api.g_miss_date
233 , p5_a9 DATE := fnd_api.g_miss_date
234 , p5_a10 VARCHAR2 := fnd_api.g_miss_char
235 , p5_a11 VARCHAR2 := fnd_api.g_miss_char
236 , p5_a12 NUMBER := 0-1962.0724
237 , p5_a13 NUMBER := 0-1962.0724
238 , p5_a14 DATE := fnd_api.g_miss_date
239 , p5_a15 NUMBER := 0-1962.0724
240 , p5_a16 DATE := fnd_api.g_miss_date
241 , p5_a17 NUMBER := 0-1962.0724
242 );
243 procedure delete_operands(p_api_version NUMBER
244 , p_init_msg_list VARCHAR2
245 , x_return_status out nocopy VARCHAR2
246 , x_msg_count out nocopy NUMBER
247 , x_msg_data out nocopy VARCHAR2
248 , p5_a0 JTF_NUMBER_TABLE
249 , p5_a1 JTF_NUMBER_TABLE
250 , p5_a2 JTF_VARCHAR2_TABLE_100
251 , p5_a3 JTF_NUMBER_TABLE
252 , p5_a4 JTF_NUMBER_TABLE
253 , p5_a5 JTF_VARCHAR2_TABLE_200
254 , p5_a6 JTF_VARCHAR2_TABLE_2000
255 , p5_a7 JTF_VARCHAR2_TABLE_100
256 , p5_a8 JTF_DATE_TABLE
257 , p5_a9 JTF_DATE_TABLE
258 , p5_a10 JTF_VARCHAR2_TABLE_200
259 , p5_a11 JTF_VARCHAR2_TABLE_100
260 , p5_a12 JTF_NUMBER_TABLE
261 , p5_a13 JTF_NUMBER_TABLE
262 , p5_a14 JTF_DATE_TABLE
263 , p5_a15 JTF_NUMBER_TABLE
264 , p5_a16 JTF_DATE_TABLE
265 , p5_a17 JTF_NUMBER_TABLE
266 );
267 procedure validate_operands(p_api_version NUMBER
268 , p_init_msg_list VARCHAR2
269 , x_return_status out nocopy VARCHAR2
270 , x_msg_count out nocopy NUMBER
271 , x_msg_data out nocopy VARCHAR2
272 , p5_a0 NUMBER := 0-1962.0724
273 , p5_a1 NUMBER := 0-1962.0724
274 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
275 , p5_a3 NUMBER := 0-1962.0724
276 , p5_a4 NUMBER := 0-1962.0724
277 , p5_a5 VARCHAR2 := fnd_api.g_miss_char
278 , p5_a6 VARCHAR2 := fnd_api.g_miss_char
279 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
280 , p5_a8 DATE := fnd_api.g_miss_date
281 , p5_a9 DATE := fnd_api.g_miss_date
282 , p5_a10 VARCHAR2 := fnd_api.g_miss_char
283 , p5_a11 VARCHAR2 := fnd_api.g_miss_char
284 , p5_a12 NUMBER := 0-1962.0724
285 , p5_a13 NUMBER := 0-1962.0724
286 , p5_a14 DATE := fnd_api.g_miss_date
287 , p5_a15 NUMBER := 0-1962.0724
288 , p5_a16 DATE := fnd_api.g_miss_date
289 , p5_a17 NUMBER := 0-1962.0724
290 );
291 procedure validate_operands(p_api_version NUMBER
292 , p_init_msg_list VARCHAR2
293 , x_return_status out nocopy VARCHAR2
294 , x_msg_count out nocopy NUMBER
295 , x_msg_data out nocopy VARCHAR2
296 , p5_a0 JTF_NUMBER_TABLE
297 , p5_a1 JTF_NUMBER_TABLE
298 , p5_a2 JTF_VARCHAR2_TABLE_100
299 , p5_a3 JTF_NUMBER_TABLE
300 , p5_a4 JTF_NUMBER_TABLE
301 , p5_a5 JTF_VARCHAR2_TABLE_200
302 , p5_a6 JTF_VARCHAR2_TABLE_2000
303 , p5_a7 JTF_VARCHAR2_TABLE_100
304 , p5_a8 JTF_DATE_TABLE
305 , p5_a9 JTF_DATE_TABLE
306 , p5_a10 JTF_VARCHAR2_TABLE_200
307 , p5_a11 JTF_VARCHAR2_TABLE_100
308 , p5_a12 JTF_NUMBER_TABLE
309 , p5_a13 JTF_NUMBER_TABLE
310 , p5_a14 JTF_DATE_TABLE
311 , p5_a15 JTF_NUMBER_TABLE
312 , p5_a16 JTF_DATE_TABLE
313 , p5_a17 JTF_NUMBER_TABLE
314 );
315 end okl_operands_pub_w;