[Home] [Help]
PACKAGE: APPS.OKL_AEH_PVT_W
Source
1 package okl_aeh_pvt_w AUTHID CURRENT_USER as
2 /* $Header: OKLIAEHS.pls 120.2 2005/12/02 12:57:27 dkagrawa noship $ */
3 procedure rosetta_table_copy_in_p2(t out nocopy okl_aeh_pvt.aeh_tbl_type, a0 JTF_NUMBER_TABLE
4 , a1 JTF_VARCHAR2_TABLE_100
5 , a2 JTF_NUMBER_TABLE
6 , a3 JTF_NUMBER_TABLE
7 , a4 JTF_NUMBER_TABLE
8 , a5 JTF_VARCHAR2_TABLE_100
9 , a6 JTF_VARCHAR2_TABLE_100
10 , a7 JTF_DATE_TABLE
11 , a8 JTF_VARCHAR2_TABLE_100
12 , a9 JTF_VARCHAR2_TABLE_100
13 , a10 JTF_NUMBER_TABLE
14 , a11 JTF_NUMBER_TABLE
15 , a12 JTF_NUMBER_TABLE
16 , a13 JTF_NUMBER_TABLE
17 , a14 JTF_VARCHAR2_TABLE_800
18 , a15 JTF_VARCHAR2_TABLE_100
19 , a16 JTF_VARCHAR2_TABLE_100
20 , a17 JTF_VARCHAR2_TABLE_100
21 , a18 JTF_NUMBER_TABLE
22 , a19 JTF_NUMBER_TABLE
23 , a20 JTF_DATE_TABLE
24 , a21 JTF_NUMBER_TABLE
25 , a22 JTF_NUMBER_TABLE
26 , a23 JTF_DATE_TABLE
27 , a24 JTF_NUMBER_TABLE
28 , a25 JTF_DATE_TABLE
29 , a26 JTF_NUMBER_TABLE
30 );
31 procedure rosetta_table_copy_out_p2(t okl_aeh_pvt.aeh_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
32 , a1 out nocopy JTF_VARCHAR2_TABLE_100
33 , a2 out nocopy JTF_NUMBER_TABLE
34 , a3 out nocopy JTF_NUMBER_TABLE
35 , a4 out nocopy JTF_NUMBER_TABLE
36 , a5 out nocopy JTF_VARCHAR2_TABLE_100
37 , a6 out nocopy JTF_VARCHAR2_TABLE_100
38 , a7 out nocopy JTF_DATE_TABLE
39 , a8 out nocopy JTF_VARCHAR2_TABLE_100
40 , a9 out nocopy JTF_VARCHAR2_TABLE_100
41 , a10 out nocopy JTF_NUMBER_TABLE
42 , a11 out nocopy JTF_NUMBER_TABLE
43 , a12 out nocopy JTF_NUMBER_TABLE
44 , a13 out nocopy JTF_NUMBER_TABLE
45 , a14 out nocopy JTF_VARCHAR2_TABLE_800
46 , a15 out nocopy JTF_VARCHAR2_TABLE_100
47 , a16 out nocopy JTF_VARCHAR2_TABLE_100
48 , a17 out nocopy JTF_VARCHAR2_TABLE_100
49 , a18 out nocopy JTF_NUMBER_TABLE
50 , a19 out nocopy JTF_NUMBER_TABLE
51 , a20 out nocopy JTF_DATE_TABLE
52 , a21 out nocopy JTF_NUMBER_TABLE
53 , a22 out nocopy JTF_NUMBER_TABLE
54 , a23 out nocopy JTF_DATE_TABLE
55 , a24 out nocopy JTF_NUMBER_TABLE
56 , a25 out nocopy JTF_DATE_TABLE
57 , a26 out nocopy JTF_NUMBER_TABLE
58 );
59
60 procedure rosetta_table_copy_in_p5(t out nocopy okl_aeh_pvt.aehv_tbl_type, a0 JTF_VARCHAR2_TABLE_100
61 , a1 JTF_NUMBER_TABLE
62 , a2 JTF_NUMBER_TABLE
63 , a3 JTF_NUMBER_TABLE
64 , a4 JTF_NUMBER_TABLE
65 , a5 JTF_NUMBER_TABLE
66 , a6 JTF_VARCHAR2_TABLE_100
67 , a7 JTF_NUMBER_TABLE
68 , a8 JTF_NUMBER_TABLE
69 , a9 JTF_VARCHAR2_TABLE_100
70 , a10 JTF_DATE_TABLE
71 , a11 JTF_VARCHAR2_TABLE_800
72 , a12 JTF_VARCHAR2_TABLE_100
73 , a13 JTF_VARCHAR2_TABLE_100
74 , a14 JTF_VARCHAR2_TABLE_100
75 , a15 JTF_VARCHAR2_TABLE_100
76 , a16 JTF_NUMBER_TABLE
77 , a17 JTF_VARCHAR2_TABLE_100
78 , a18 JTF_NUMBER_TABLE
79 , a19 JTF_NUMBER_TABLE
80 , a20 JTF_DATE_TABLE
81 , a21 JTF_NUMBER_TABLE
82 , a22 JTF_NUMBER_TABLE
83 , a23 JTF_DATE_TABLE
84 , a24 JTF_NUMBER_TABLE
85 , a25 JTF_DATE_TABLE
86 , a26 JTF_NUMBER_TABLE
87 );
88 procedure rosetta_table_copy_out_p5(t okl_aeh_pvt.aehv_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
89 , a1 out nocopy JTF_NUMBER_TABLE
90 , a2 out nocopy JTF_NUMBER_TABLE
91 , a3 out nocopy JTF_NUMBER_TABLE
92 , a4 out nocopy JTF_NUMBER_TABLE
93 , a5 out nocopy JTF_NUMBER_TABLE
94 , a6 out nocopy JTF_VARCHAR2_TABLE_100
95 , a7 out nocopy JTF_NUMBER_TABLE
96 , a8 out nocopy JTF_NUMBER_TABLE
97 , a9 out nocopy JTF_VARCHAR2_TABLE_100
98 , a10 out nocopy JTF_DATE_TABLE
99 , a11 out nocopy JTF_VARCHAR2_TABLE_800
100 , a12 out nocopy JTF_VARCHAR2_TABLE_100
101 , a13 out nocopy JTF_VARCHAR2_TABLE_100
102 , a14 out nocopy JTF_VARCHAR2_TABLE_100
103 , a15 out nocopy JTF_VARCHAR2_TABLE_100
104 , a16 out nocopy JTF_NUMBER_TABLE
105 , a17 out nocopy JTF_VARCHAR2_TABLE_100
106 , a18 out nocopy JTF_NUMBER_TABLE
107 , a19 out nocopy JTF_NUMBER_TABLE
108 , a20 out nocopy JTF_DATE_TABLE
109 , a21 out nocopy JTF_NUMBER_TABLE
110 , a22 out nocopy JTF_NUMBER_TABLE
111 , a23 out nocopy JTF_DATE_TABLE
112 , a24 out nocopy JTF_NUMBER_TABLE
113 , a25 out nocopy JTF_DATE_TABLE
114 , a26 out nocopy JTF_NUMBER_TABLE
115 );
116
117 procedure rosetta_table_copy_in_p6(t out nocopy okl_aeh_pvt.ae_header_id_typ, a0 JTF_NUMBER_TABLE);
118 procedure rosetta_table_copy_out_p6(t okl_aeh_pvt.ae_header_id_typ, a0 out nocopy JTF_NUMBER_TABLE);
119
120 procedure rosetta_table_copy_in_p7(t out nocopy okl_aeh_pvt.post_to_gl_flag_typ, a0 JTF_VARCHAR2_TABLE_100);
121 procedure rosetta_table_copy_out_p7(t okl_aeh_pvt.post_to_gl_flag_typ, a0 out nocopy JTF_VARCHAR2_TABLE_100);
122
123 procedure rosetta_table_copy_in_p8(t out nocopy okl_aeh_pvt.set_of_books_id_typ, a0 JTF_NUMBER_TABLE);
124 procedure rosetta_table_copy_out_p8(t okl_aeh_pvt.set_of_books_id_typ, a0 out nocopy JTF_NUMBER_TABLE);
125
126 procedure rosetta_table_copy_in_p9(t out nocopy okl_aeh_pvt.accounting_event_id_typ, a0 JTF_NUMBER_TABLE);
127 procedure rosetta_table_copy_out_p9(t okl_aeh_pvt.accounting_event_id_typ, a0 out nocopy JTF_NUMBER_TABLE);
128
129 procedure rosetta_table_copy_in_p10(t out nocopy okl_aeh_pvt.object_version_number_typ, a0 JTF_NUMBER_TABLE);
130 procedure rosetta_table_copy_out_p10(t okl_aeh_pvt.object_version_number_typ, a0 out nocopy JTF_NUMBER_TABLE);
131
132 procedure rosetta_table_copy_in_p11(t out nocopy okl_aeh_pvt.ae_category_typ, a0 JTF_VARCHAR2_TABLE_100);
133 procedure rosetta_table_copy_out_p11(t okl_aeh_pvt.ae_category_typ, a0 out nocopy JTF_VARCHAR2_TABLE_100);
134
135 procedure rosetta_table_copy_in_p12(t out nocopy okl_aeh_pvt.period_name_typ, a0 JTF_VARCHAR2_TABLE_100);
136 procedure rosetta_table_copy_out_p12(t okl_aeh_pvt.period_name_typ, a0 out nocopy JTF_VARCHAR2_TABLE_100);
137
138 procedure rosetta_table_copy_in_p13(t out nocopy okl_aeh_pvt.accounting_date_typ, a0 JTF_DATE_TABLE);
139 procedure rosetta_table_copy_out_p13(t okl_aeh_pvt.accounting_date_typ, a0 out nocopy JTF_DATE_TABLE);
140
141 procedure rosetta_table_copy_in_p14(t out nocopy okl_aeh_pvt.gl_transfer_run_id_typ, a0 JTF_NUMBER_TABLE);
142 procedure rosetta_table_copy_out_p14(t okl_aeh_pvt.gl_transfer_run_id_typ, a0 out nocopy JTF_NUMBER_TABLE);
143
144 procedure rosetta_table_copy_in_p15(t out nocopy okl_aeh_pvt.cross_currency_flag_typ, a0 JTF_VARCHAR2_TABLE_100);
145 procedure rosetta_table_copy_out_p15(t okl_aeh_pvt.cross_currency_flag_typ, a0 out nocopy JTF_VARCHAR2_TABLE_100);
146
147 procedure rosetta_table_copy_in_p16(t out nocopy okl_aeh_pvt.gl_transfer_flag_typ, a0 JTF_VARCHAR2_TABLE_100);
148 procedure rosetta_table_copy_out_p16(t okl_aeh_pvt.gl_transfer_flag_typ, a0 out nocopy JTF_VARCHAR2_TABLE_100);
149
150 procedure rosetta_table_copy_in_p17(t out nocopy okl_aeh_pvt.sequence_id_typ, a0 JTF_NUMBER_TABLE);
151 procedure rosetta_table_copy_out_p17(t okl_aeh_pvt.sequence_id_typ, a0 out nocopy JTF_NUMBER_TABLE);
152
153 procedure rosetta_table_copy_in_p18(t out nocopy okl_aeh_pvt.sequence_value_typ, a0 JTF_NUMBER_TABLE);
154 procedure rosetta_table_copy_out_p18(t okl_aeh_pvt.sequence_value_typ, a0 out nocopy JTF_NUMBER_TABLE);
155
156 procedure rosetta_table_copy_in_p19(t out nocopy okl_aeh_pvt.description_typ, a0 JTF_VARCHAR2_TABLE_800);
157 procedure rosetta_table_copy_out_p19(t okl_aeh_pvt.description_typ, a0 out nocopy JTF_VARCHAR2_TABLE_800);
158
159 procedure rosetta_table_copy_in_p20(t out nocopy okl_aeh_pvt.accounting_error_code_typ, a0 JTF_VARCHAR2_TABLE_100);
160 procedure rosetta_table_copy_out_p20(t okl_aeh_pvt.accounting_error_code_typ, a0 out nocopy JTF_VARCHAR2_TABLE_100);
161
162 procedure rosetta_table_copy_in_p21(t out nocopy okl_aeh_pvt.gl_transfer_error_code_typ, a0 JTF_VARCHAR2_TABLE_100);
163 procedure rosetta_table_copy_out_p21(t okl_aeh_pvt.gl_transfer_error_code_typ, a0 out nocopy JTF_VARCHAR2_TABLE_100);
164
165 procedure rosetta_table_copy_in_p22(t out nocopy okl_aeh_pvt.gl_reversal_flag_typ, a0 JTF_VARCHAR2_TABLE_100);
166 procedure rosetta_table_copy_out_p22(t okl_aeh_pvt.gl_reversal_flag_typ, a0 out nocopy JTF_VARCHAR2_TABLE_100);
167
168 procedure rosetta_table_copy_in_p23(t out nocopy okl_aeh_pvt.org_id_typ, a0 JTF_NUMBER_TABLE);
169 procedure rosetta_table_copy_out_p23(t okl_aeh_pvt.org_id_typ, a0 out nocopy JTF_NUMBER_TABLE);
170
171 procedure rosetta_table_copy_in_p24(t out nocopy okl_aeh_pvt.program_id_typ, a0 JTF_NUMBER_TABLE);
172 procedure rosetta_table_copy_out_p24(t okl_aeh_pvt.program_id_typ, a0 out nocopy JTF_NUMBER_TABLE);
173
174 procedure rosetta_table_copy_in_p25(t out nocopy okl_aeh_pvt.program_application_id_typ, a0 JTF_NUMBER_TABLE);
175 procedure rosetta_table_copy_out_p25(t okl_aeh_pvt.program_application_id_typ, a0 out nocopy JTF_NUMBER_TABLE);
176
177 procedure rosetta_table_copy_in_p26(t out nocopy okl_aeh_pvt.program_update_date_typ, a0 JTF_DATE_TABLE);
178 procedure rosetta_table_copy_out_p26(t okl_aeh_pvt.program_update_date_typ, a0 out nocopy JTF_DATE_TABLE);
179
180 procedure rosetta_table_copy_in_p27(t out nocopy okl_aeh_pvt.request_id_typ, a0 JTF_NUMBER_TABLE);
181 procedure rosetta_table_copy_out_p27(t okl_aeh_pvt.request_id_typ, a0 out nocopy JTF_NUMBER_TABLE);
182
183 procedure rosetta_table_copy_in_p28(t out nocopy okl_aeh_pvt.created_by_typ, a0 JTF_NUMBER_TABLE);
184 procedure rosetta_table_copy_out_p28(t okl_aeh_pvt.created_by_typ, a0 out nocopy JTF_NUMBER_TABLE);
185
186 procedure rosetta_table_copy_in_p29(t out nocopy okl_aeh_pvt.creation_date_typ, a0 JTF_DATE_TABLE);
187 procedure rosetta_table_copy_out_p29(t okl_aeh_pvt.creation_date_typ, a0 out nocopy JTF_DATE_TABLE);
188
189 procedure rosetta_table_copy_in_p30(t out nocopy okl_aeh_pvt.last_updated_by_typ, a0 JTF_NUMBER_TABLE);
190 procedure rosetta_table_copy_out_p30(t okl_aeh_pvt.last_updated_by_typ, a0 out nocopy JTF_NUMBER_TABLE);
191
192 procedure rosetta_table_copy_in_p31(t out nocopy okl_aeh_pvt.last_update_date_typ, a0 JTF_DATE_TABLE);
193 procedure rosetta_table_copy_out_p31(t okl_aeh_pvt.last_update_date_typ, a0 out nocopy JTF_DATE_TABLE);
194
195 procedure rosetta_table_copy_in_p32(t out nocopy okl_aeh_pvt.last_update_login_typ, a0 JTF_NUMBER_TABLE);
196 procedure rosetta_table_copy_out_p32(t okl_aeh_pvt.last_update_login_typ, a0 out nocopy JTF_NUMBER_TABLE);
197
198 procedure insert_row(p_api_version NUMBER
199 , p_init_msg_list VARCHAR2
200 , x_return_status out nocopy VARCHAR2
201 , x_msg_count out nocopy NUMBER
202 , x_msg_data out nocopy VARCHAR2
203 , p6_a0 out nocopy VARCHAR2
204 , p6_a1 out nocopy NUMBER
205 , p6_a2 out nocopy NUMBER
206 , p6_a3 out nocopy NUMBER
207 , p6_a4 out nocopy NUMBER
208 , p6_a5 out nocopy NUMBER
209 , p6_a6 out nocopy VARCHAR2
210 , p6_a7 out nocopy NUMBER
211 , p6_a8 out nocopy NUMBER
212 , p6_a9 out nocopy VARCHAR2
213 , p6_a10 out nocopy DATE
214 , p6_a11 out nocopy VARCHAR2
215 , p6_a12 out nocopy VARCHAR2
216 , p6_a13 out nocopy VARCHAR2
217 , p6_a14 out nocopy VARCHAR2
218 , p6_a15 out nocopy VARCHAR2
219 , p6_a16 out nocopy NUMBER
220 , p6_a17 out nocopy VARCHAR2
221 , p6_a18 out nocopy NUMBER
222 , p6_a19 out nocopy NUMBER
223 , p6_a20 out nocopy DATE
224 , p6_a21 out nocopy NUMBER
225 , p6_a22 out nocopy NUMBER
226 , p6_a23 out nocopy DATE
227 , p6_a24 out nocopy NUMBER
228 , p6_a25 out nocopy DATE
229 , p6_a26 out nocopy NUMBER
230 , p5_a0 VARCHAR2 := fnd_api.g_miss_char
231 , p5_a1 NUMBER := 0-1962.0724
232 , p5_a2 NUMBER := 0-1962.0724
233 , p5_a3 NUMBER := 0-1962.0724
234 , p5_a4 NUMBER := 0-1962.0724
235 , p5_a5 NUMBER := 0-1962.0724
236 , p5_a6 VARCHAR2 := fnd_api.g_miss_char
237 , p5_a7 NUMBER := 0-1962.0724
238 , p5_a8 NUMBER := 0-1962.0724
239 , p5_a9 VARCHAR2 := fnd_api.g_miss_char
240 , p5_a10 DATE := fnd_api.g_miss_date
241 , p5_a11 VARCHAR2 := fnd_api.g_miss_char
242 , p5_a12 VARCHAR2 := fnd_api.g_miss_char
243 , p5_a13 VARCHAR2 := fnd_api.g_miss_char
244 , p5_a14 VARCHAR2 := fnd_api.g_miss_char
245 , p5_a15 VARCHAR2 := fnd_api.g_miss_char
246 , p5_a16 NUMBER := 0-1962.0724
247 , p5_a17 VARCHAR2 := fnd_api.g_miss_char
248 , p5_a18 NUMBER := 0-1962.0724
249 , p5_a19 NUMBER := 0-1962.0724
250 , p5_a20 DATE := fnd_api.g_miss_date
251 , p5_a21 NUMBER := 0-1962.0724
252 , p5_a22 NUMBER := 0-1962.0724
253 , p5_a23 DATE := fnd_api.g_miss_date
254 , p5_a24 NUMBER := 0-1962.0724
255 , p5_a25 DATE := fnd_api.g_miss_date
256 , p5_a26 NUMBER := 0-1962.0724
257 );
258 procedure insert_row(p_api_version NUMBER
259 , p_init_msg_list VARCHAR2
260 , x_return_status out nocopy VARCHAR2
261 , x_msg_count out nocopy NUMBER
262 , x_msg_data out nocopy VARCHAR2
263 , p5_a0 JTF_VARCHAR2_TABLE_100
264 , p5_a1 JTF_NUMBER_TABLE
265 , p5_a2 JTF_NUMBER_TABLE
266 , p5_a3 JTF_NUMBER_TABLE
267 , p5_a4 JTF_NUMBER_TABLE
268 , p5_a5 JTF_NUMBER_TABLE
269 , p5_a6 JTF_VARCHAR2_TABLE_100
270 , p5_a7 JTF_NUMBER_TABLE
271 , p5_a8 JTF_NUMBER_TABLE
272 , p5_a9 JTF_VARCHAR2_TABLE_100
273 , p5_a10 JTF_DATE_TABLE
274 , p5_a11 JTF_VARCHAR2_TABLE_800
275 , p5_a12 JTF_VARCHAR2_TABLE_100
276 , p5_a13 JTF_VARCHAR2_TABLE_100
277 , p5_a14 JTF_VARCHAR2_TABLE_100
278 , p5_a15 JTF_VARCHAR2_TABLE_100
279 , p5_a16 JTF_NUMBER_TABLE
280 , p5_a17 JTF_VARCHAR2_TABLE_100
281 , p5_a18 JTF_NUMBER_TABLE
282 , p5_a19 JTF_NUMBER_TABLE
283 , p5_a20 JTF_DATE_TABLE
284 , p5_a21 JTF_NUMBER_TABLE
285 , p5_a22 JTF_NUMBER_TABLE
286 , p5_a23 JTF_DATE_TABLE
287 , p5_a24 JTF_NUMBER_TABLE
288 , p5_a25 JTF_DATE_TABLE
289 , p5_a26 JTF_NUMBER_TABLE
290 , p6_a0 out nocopy JTF_VARCHAR2_TABLE_100
291 , p6_a1 out nocopy JTF_NUMBER_TABLE
292 , p6_a2 out nocopy JTF_NUMBER_TABLE
293 , p6_a3 out nocopy JTF_NUMBER_TABLE
294 , p6_a4 out nocopy JTF_NUMBER_TABLE
295 , p6_a5 out nocopy JTF_NUMBER_TABLE
296 , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
297 , p6_a7 out nocopy JTF_NUMBER_TABLE
298 , p6_a8 out nocopy JTF_NUMBER_TABLE
299 , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
300 , p6_a10 out nocopy JTF_DATE_TABLE
301 , p6_a11 out nocopy JTF_VARCHAR2_TABLE_800
302 , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
303 , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
304 , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100
305 , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
306 , p6_a16 out nocopy JTF_NUMBER_TABLE
307 , p6_a17 out nocopy JTF_VARCHAR2_TABLE_100
308 , p6_a18 out nocopy JTF_NUMBER_TABLE
309 , p6_a19 out nocopy JTF_NUMBER_TABLE
310 , p6_a20 out nocopy JTF_DATE_TABLE
311 , p6_a21 out nocopy JTF_NUMBER_TABLE
312 , p6_a22 out nocopy JTF_NUMBER_TABLE
313 , p6_a23 out nocopy JTF_DATE_TABLE
314 , p6_a24 out nocopy JTF_NUMBER_TABLE
315 , p6_a25 out nocopy JTF_DATE_TABLE
316 , p6_a26 out nocopy JTF_NUMBER_TABLE
317 );
318 procedure insert_row_perf(p_api_version NUMBER
319 , p_init_msg_list VARCHAR2
320 , x_return_status out nocopy VARCHAR2
321 , x_msg_count out nocopy NUMBER
322 , x_msg_data out nocopy VARCHAR2
323 , p5_a0 JTF_VARCHAR2_TABLE_100
324 , p5_a1 JTF_NUMBER_TABLE
325 , p5_a2 JTF_NUMBER_TABLE
326 , p5_a3 JTF_NUMBER_TABLE
327 , p5_a4 JTF_NUMBER_TABLE
328 , p5_a5 JTF_NUMBER_TABLE
329 , p5_a6 JTF_VARCHAR2_TABLE_100
330 , p5_a7 JTF_NUMBER_TABLE
331 , p5_a8 JTF_NUMBER_TABLE
332 , p5_a9 JTF_VARCHAR2_TABLE_100
333 , p5_a10 JTF_DATE_TABLE
334 , p5_a11 JTF_VARCHAR2_TABLE_800
335 , p5_a12 JTF_VARCHAR2_TABLE_100
336 , p5_a13 JTF_VARCHAR2_TABLE_100
337 , p5_a14 JTF_VARCHAR2_TABLE_100
338 , p5_a15 JTF_VARCHAR2_TABLE_100
339 , p5_a16 JTF_NUMBER_TABLE
340 , p5_a17 JTF_VARCHAR2_TABLE_100
341 , p5_a18 JTF_NUMBER_TABLE
342 , p5_a19 JTF_NUMBER_TABLE
343 , p5_a20 JTF_DATE_TABLE
344 , p5_a21 JTF_NUMBER_TABLE
345 , p5_a22 JTF_NUMBER_TABLE
346 , p5_a23 JTF_DATE_TABLE
347 , p5_a24 JTF_NUMBER_TABLE
348 , p5_a25 JTF_DATE_TABLE
349 , p5_a26 JTF_NUMBER_TABLE
350 , p6_a0 out nocopy JTF_VARCHAR2_TABLE_100
351 , p6_a1 out nocopy JTF_NUMBER_TABLE
352 , p6_a2 out nocopy JTF_NUMBER_TABLE
353 , p6_a3 out nocopy JTF_NUMBER_TABLE
354 , p6_a4 out nocopy JTF_NUMBER_TABLE
355 , p6_a5 out nocopy JTF_NUMBER_TABLE
356 , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
357 , p6_a7 out nocopy JTF_NUMBER_TABLE
358 , p6_a8 out nocopy JTF_NUMBER_TABLE
359 , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
360 , p6_a10 out nocopy JTF_DATE_TABLE
361 , p6_a11 out nocopy JTF_VARCHAR2_TABLE_800
362 , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
363 , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
364 , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100
365 , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
366 , p6_a16 out nocopy JTF_NUMBER_TABLE
367 , p6_a17 out nocopy JTF_VARCHAR2_TABLE_100
368 , p6_a18 out nocopy JTF_NUMBER_TABLE
369 , p6_a19 out nocopy JTF_NUMBER_TABLE
370 , p6_a20 out nocopy JTF_DATE_TABLE
371 , p6_a21 out nocopy JTF_NUMBER_TABLE
372 , p6_a22 out nocopy JTF_NUMBER_TABLE
373 , p6_a23 out nocopy JTF_DATE_TABLE
374 , p6_a24 out nocopy JTF_NUMBER_TABLE
375 , p6_a25 out nocopy JTF_DATE_TABLE
376 , p6_a26 out nocopy JTF_NUMBER_TABLE
377 );
378 procedure lock_row(p_api_version NUMBER
379 , p_init_msg_list VARCHAR2
380 , x_return_status out nocopy VARCHAR2
381 , x_msg_count out nocopy NUMBER
382 , x_msg_data out nocopy VARCHAR2
383 , p5_a0 VARCHAR2 := fnd_api.g_miss_char
384 , p5_a1 NUMBER := 0-1962.0724
385 , p5_a2 NUMBER := 0-1962.0724
386 , p5_a3 NUMBER := 0-1962.0724
387 , p5_a4 NUMBER := 0-1962.0724
388 , p5_a5 NUMBER := 0-1962.0724
389 , p5_a6 VARCHAR2 := fnd_api.g_miss_char
390 , p5_a7 NUMBER := 0-1962.0724
391 , p5_a8 NUMBER := 0-1962.0724
392 , p5_a9 VARCHAR2 := fnd_api.g_miss_char
393 , p5_a10 DATE := fnd_api.g_miss_date
394 , p5_a11 VARCHAR2 := fnd_api.g_miss_char
395 , p5_a12 VARCHAR2 := fnd_api.g_miss_char
396 , p5_a13 VARCHAR2 := fnd_api.g_miss_char
397 , p5_a14 VARCHAR2 := fnd_api.g_miss_char
398 , p5_a15 VARCHAR2 := fnd_api.g_miss_char
399 , p5_a16 NUMBER := 0-1962.0724
400 , p5_a17 VARCHAR2 := fnd_api.g_miss_char
401 , p5_a18 NUMBER := 0-1962.0724
402 , p5_a19 NUMBER := 0-1962.0724
403 , p5_a20 DATE := fnd_api.g_miss_date
404 , p5_a21 NUMBER := 0-1962.0724
405 , p5_a22 NUMBER := 0-1962.0724
406 , p5_a23 DATE := fnd_api.g_miss_date
407 , p5_a24 NUMBER := 0-1962.0724
408 , p5_a25 DATE := fnd_api.g_miss_date
409 , p5_a26 NUMBER := 0-1962.0724
410 );
411 procedure lock_row(p_api_version NUMBER
412 , p_init_msg_list VARCHAR2
413 , x_return_status out nocopy VARCHAR2
414 , x_msg_count out nocopy NUMBER
415 , x_msg_data out nocopy VARCHAR2
416 , p5_a0 JTF_VARCHAR2_TABLE_100
417 , p5_a1 JTF_NUMBER_TABLE
418 , p5_a2 JTF_NUMBER_TABLE
419 , p5_a3 JTF_NUMBER_TABLE
420 , p5_a4 JTF_NUMBER_TABLE
421 , p5_a5 JTF_NUMBER_TABLE
422 , p5_a6 JTF_VARCHAR2_TABLE_100
423 , p5_a7 JTF_NUMBER_TABLE
424 , p5_a8 JTF_NUMBER_TABLE
425 , p5_a9 JTF_VARCHAR2_TABLE_100
426 , p5_a10 JTF_DATE_TABLE
427 , p5_a11 JTF_VARCHAR2_TABLE_800
428 , p5_a12 JTF_VARCHAR2_TABLE_100
429 , p5_a13 JTF_VARCHAR2_TABLE_100
430 , p5_a14 JTF_VARCHAR2_TABLE_100
431 , p5_a15 JTF_VARCHAR2_TABLE_100
432 , p5_a16 JTF_NUMBER_TABLE
433 , p5_a17 JTF_VARCHAR2_TABLE_100
434 , p5_a18 JTF_NUMBER_TABLE
435 , p5_a19 JTF_NUMBER_TABLE
436 , p5_a20 JTF_DATE_TABLE
437 , p5_a21 JTF_NUMBER_TABLE
438 , p5_a22 JTF_NUMBER_TABLE
439 , p5_a23 JTF_DATE_TABLE
440 , p5_a24 JTF_NUMBER_TABLE
441 , p5_a25 JTF_DATE_TABLE
442 , p5_a26 JTF_NUMBER_TABLE
443 );
444 procedure update_row(p_api_version NUMBER
445 , p_init_msg_list VARCHAR2
446 , x_return_status out nocopy VARCHAR2
447 , x_msg_count out nocopy NUMBER
448 , x_msg_data out nocopy VARCHAR2
449 , p6_a0 out nocopy VARCHAR2
450 , p6_a1 out nocopy NUMBER
451 , p6_a2 out nocopy NUMBER
452 , p6_a3 out nocopy NUMBER
453 , p6_a4 out nocopy NUMBER
454 , p6_a5 out nocopy NUMBER
455 , p6_a6 out nocopy VARCHAR2
456 , p6_a7 out nocopy NUMBER
457 , p6_a8 out nocopy NUMBER
458 , p6_a9 out nocopy VARCHAR2
459 , p6_a10 out nocopy DATE
460 , p6_a11 out nocopy VARCHAR2
461 , p6_a12 out nocopy VARCHAR2
462 , p6_a13 out nocopy VARCHAR2
463 , p6_a14 out nocopy VARCHAR2
464 , p6_a15 out nocopy VARCHAR2
465 , p6_a16 out nocopy NUMBER
466 , p6_a17 out nocopy VARCHAR2
467 , p6_a18 out nocopy NUMBER
468 , p6_a19 out nocopy NUMBER
469 , p6_a20 out nocopy DATE
470 , p6_a21 out nocopy NUMBER
471 , p6_a22 out nocopy NUMBER
472 , p6_a23 out nocopy DATE
473 , p6_a24 out nocopy NUMBER
474 , p6_a25 out nocopy DATE
475 , p6_a26 out nocopy NUMBER
476 , p5_a0 VARCHAR2 := fnd_api.g_miss_char
477 , p5_a1 NUMBER := 0-1962.0724
478 , p5_a2 NUMBER := 0-1962.0724
479 , p5_a3 NUMBER := 0-1962.0724
480 , p5_a4 NUMBER := 0-1962.0724
481 , p5_a5 NUMBER := 0-1962.0724
482 , p5_a6 VARCHAR2 := fnd_api.g_miss_char
483 , p5_a7 NUMBER := 0-1962.0724
484 , p5_a8 NUMBER := 0-1962.0724
485 , p5_a9 VARCHAR2 := fnd_api.g_miss_char
486 , p5_a10 DATE := fnd_api.g_miss_date
487 , p5_a11 VARCHAR2 := fnd_api.g_miss_char
488 , p5_a12 VARCHAR2 := fnd_api.g_miss_char
489 , p5_a13 VARCHAR2 := fnd_api.g_miss_char
490 , p5_a14 VARCHAR2 := fnd_api.g_miss_char
491 , p5_a15 VARCHAR2 := fnd_api.g_miss_char
492 , p5_a16 NUMBER := 0-1962.0724
493 , p5_a17 VARCHAR2 := fnd_api.g_miss_char
494 , p5_a18 NUMBER := 0-1962.0724
495 , p5_a19 NUMBER := 0-1962.0724
496 , p5_a20 DATE := fnd_api.g_miss_date
497 , p5_a21 NUMBER := 0-1962.0724
498 , p5_a22 NUMBER := 0-1962.0724
499 , p5_a23 DATE := fnd_api.g_miss_date
500 , p5_a24 NUMBER := 0-1962.0724
501 , p5_a25 DATE := fnd_api.g_miss_date
502 , p5_a26 NUMBER := 0-1962.0724
503 );
504 procedure update_row(p_api_version NUMBER
505 , p_init_msg_list VARCHAR2
506 , x_return_status out nocopy VARCHAR2
507 , x_msg_count out nocopy NUMBER
508 , x_msg_data out nocopy VARCHAR2
509 , p5_a0 JTF_VARCHAR2_TABLE_100
510 , p5_a1 JTF_NUMBER_TABLE
511 , p5_a2 JTF_NUMBER_TABLE
512 , p5_a3 JTF_NUMBER_TABLE
513 , p5_a4 JTF_NUMBER_TABLE
514 , p5_a5 JTF_NUMBER_TABLE
515 , p5_a6 JTF_VARCHAR2_TABLE_100
516 , p5_a7 JTF_NUMBER_TABLE
517 , p5_a8 JTF_NUMBER_TABLE
518 , p5_a9 JTF_VARCHAR2_TABLE_100
519 , p5_a10 JTF_DATE_TABLE
520 , p5_a11 JTF_VARCHAR2_TABLE_800
521 , p5_a12 JTF_VARCHAR2_TABLE_100
522 , p5_a13 JTF_VARCHAR2_TABLE_100
523 , p5_a14 JTF_VARCHAR2_TABLE_100
524 , p5_a15 JTF_VARCHAR2_TABLE_100
525 , p5_a16 JTF_NUMBER_TABLE
526 , p5_a17 JTF_VARCHAR2_TABLE_100
527 , p5_a18 JTF_NUMBER_TABLE
528 , p5_a19 JTF_NUMBER_TABLE
529 , p5_a20 JTF_DATE_TABLE
530 , p5_a21 JTF_NUMBER_TABLE
531 , p5_a22 JTF_NUMBER_TABLE
532 , p5_a23 JTF_DATE_TABLE
533 , p5_a24 JTF_NUMBER_TABLE
534 , p5_a25 JTF_DATE_TABLE
535 , p5_a26 JTF_NUMBER_TABLE
536 , p6_a0 out nocopy JTF_VARCHAR2_TABLE_100
537 , p6_a1 out nocopy JTF_NUMBER_TABLE
538 , p6_a2 out nocopy JTF_NUMBER_TABLE
539 , p6_a3 out nocopy JTF_NUMBER_TABLE
540 , p6_a4 out nocopy JTF_NUMBER_TABLE
541 , p6_a5 out nocopy JTF_NUMBER_TABLE
542 , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
543 , p6_a7 out nocopy JTF_NUMBER_TABLE
544 , p6_a8 out nocopy JTF_NUMBER_TABLE
545 , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
546 , p6_a10 out nocopy JTF_DATE_TABLE
547 , p6_a11 out nocopy JTF_VARCHAR2_TABLE_800
548 , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
549 , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
550 , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100
551 , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
552 , p6_a16 out nocopy JTF_NUMBER_TABLE
553 , p6_a17 out nocopy JTF_VARCHAR2_TABLE_100
554 , p6_a18 out nocopy JTF_NUMBER_TABLE
555 , p6_a19 out nocopy JTF_NUMBER_TABLE
556 , p6_a20 out nocopy JTF_DATE_TABLE
557 , p6_a21 out nocopy JTF_NUMBER_TABLE
558 , p6_a22 out nocopy JTF_NUMBER_TABLE
559 , p6_a23 out nocopy JTF_DATE_TABLE
560 , p6_a24 out nocopy JTF_NUMBER_TABLE
561 , p6_a25 out nocopy JTF_DATE_TABLE
562 , p6_a26 out nocopy JTF_NUMBER_TABLE
563 );
564 procedure delete_row(p_api_version NUMBER
565 , p_init_msg_list VARCHAR2
566 , x_return_status out nocopy VARCHAR2
567 , x_msg_count out nocopy NUMBER
568 , x_msg_data out nocopy VARCHAR2
569 , p5_a0 VARCHAR2 := fnd_api.g_miss_char
570 , p5_a1 NUMBER := 0-1962.0724
571 , p5_a2 NUMBER := 0-1962.0724
572 , p5_a3 NUMBER := 0-1962.0724
573 , p5_a4 NUMBER := 0-1962.0724
574 , p5_a5 NUMBER := 0-1962.0724
575 , p5_a6 VARCHAR2 := fnd_api.g_miss_char
576 , p5_a7 NUMBER := 0-1962.0724
577 , p5_a8 NUMBER := 0-1962.0724
578 , p5_a9 VARCHAR2 := fnd_api.g_miss_char
579 , p5_a10 DATE := fnd_api.g_miss_date
580 , p5_a11 VARCHAR2 := fnd_api.g_miss_char
581 , p5_a12 VARCHAR2 := fnd_api.g_miss_char
582 , p5_a13 VARCHAR2 := fnd_api.g_miss_char
583 , p5_a14 VARCHAR2 := fnd_api.g_miss_char
584 , p5_a15 VARCHAR2 := fnd_api.g_miss_char
585 , p5_a16 NUMBER := 0-1962.0724
586 , p5_a17 VARCHAR2 := fnd_api.g_miss_char
587 , p5_a18 NUMBER := 0-1962.0724
588 , p5_a19 NUMBER := 0-1962.0724
589 , p5_a20 DATE := fnd_api.g_miss_date
590 , p5_a21 NUMBER := 0-1962.0724
591 , p5_a22 NUMBER := 0-1962.0724
592 , p5_a23 DATE := fnd_api.g_miss_date
593 , p5_a24 NUMBER := 0-1962.0724
594 , p5_a25 DATE := fnd_api.g_miss_date
595 , p5_a26 NUMBER := 0-1962.0724
596 );
597 procedure delete_row(p_api_version NUMBER
598 , p_init_msg_list VARCHAR2
599 , x_return_status out nocopy VARCHAR2
600 , x_msg_count out nocopy NUMBER
601 , x_msg_data out nocopy VARCHAR2
602 , p5_a0 JTF_VARCHAR2_TABLE_100
603 , p5_a1 JTF_NUMBER_TABLE
604 , p5_a2 JTF_NUMBER_TABLE
605 , p5_a3 JTF_NUMBER_TABLE
606 , p5_a4 JTF_NUMBER_TABLE
607 , p5_a5 JTF_NUMBER_TABLE
608 , p5_a6 JTF_VARCHAR2_TABLE_100
609 , p5_a7 JTF_NUMBER_TABLE
610 , p5_a8 JTF_NUMBER_TABLE
611 , p5_a9 JTF_VARCHAR2_TABLE_100
612 , p5_a10 JTF_DATE_TABLE
613 , p5_a11 JTF_VARCHAR2_TABLE_800
614 , p5_a12 JTF_VARCHAR2_TABLE_100
615 , p5_a13 JTF_VARCHAR2_TABLE_100
616 , p5_a14 JTF_VARCHAR2_TABLE_100
617 , p5_a15 JTF_VARCHAR2_TABLE_100
618 , p5_a16 JTF_NUMBER_TABLE
619 , p5_a17 JTF_VARCHAR2_TABLE_100
620 , p5_a18 JTF_NUMBER_TABLE
621 , p5_a19 JTF_NUMBER_TABLE
622 , p5_a20 JTF_DATE_TABLE
623 , p5_a21 JTF_NUMBER_TABLE
624 , p5_a22 JTF_NUMBER_TABLE
625 , p5_a23 JTF_DATE_TABLE
626 , p5_a24 JTF_NUMBER_TABLE
627 , p5_a25 JTF_DATE_TABLE
628 , p5_a26 JTF_NUMBER_TABLE
629 );
630 procedure validate_row(p_api_version NUMBER
631 , p_init_msg_list VARCHAR2
632 , x_return_status out nocopy VARCHAR2
633 , x_msg_count out nocopy NUMBER
634 , x_msg_data out nocopy VARCHAR2
635 , p5_a0 VARCHAR2 := fnd_api.g_miss_char
636 , p5_a1 NUMBER := 0-1962.0724
637 , p5_a2 NUMBER := 0-1962.0724
638 , p5_a3 NUMBER := 0-1962.0724
639 , p5_a4 NUMBER := 0-1962.0724
640 , p5_a5 NUMBER := 0-1962.0724
641 , p5_a6 VARCHAR2 := fnd_api.g_miss_char
642 , p5_a7 NUMBER := 0-1962.0724
643 , p5_a8 NUMBER := 0-1962.0724
644 , p5_a9 VARCHAR2 := fnd_api.g_miss_char
645 , p5_a10 DATE := fnd_api.g_miss_date
646 , p5_a11 VARCHAR2 := fnd_api.g_miss_char
647 , p5_a12 VARCHAR2 := fnd_api.g_miss_char
648 , p5_a13 VARCHAR2 := fnd_api.g_miss_char
649 , p5_a14 VARCHAR2 := fnd_api.g_miss_char
650 , p5_a15 VARCHAR2 := fnd_api.g_miss_char
651 , p5_a16 NUMBER := 0-1962.0724
652 , p5_a17 VARCHAR2 := fnd_api.g_miss_char
653 , p5_a18 NUMBER := 0-1962.0724
654 , p5_a19 NUMBER := 0-1962.0724
655 , p5_a20 DATE := fnd_api.g_miss_date
656 , p5_a21 NUMBER := 0-1962.0724
657 , p5_a22 NUMBER := 0-1962.0724
658 , p5_a23 DATE := fnd_api.g_miss_date
659 , p5_a24 NUMBER := 0-1962.0724
660 , p5_a25 DATE := fnd_api.g_miss_date
661 , p5_a26 NUMBER := 0-1962.0724
662 );
663 procedure validate_row(p_api_version NUMBER
664 , p_init_msg_list VARCHAR2
665 , x_return_status out nocopy VARCHAR2
666 , x_msg_count out nocopy NUMBER
667 , x_msg_data out nocopy VARCHAR2
668 , p5_a0 JTF_VARCHAR2_TABLE_100
669 , p5_a1 JTF_NUMBER_TABLE
670 , p5_a2 JTF_NUMBER_TABLE
671 , p5_a3 JTF_NUMBER_TABLE
672 , p5_a4 JTF_NUMBER_TABLE
673 , p5_a5 JTF_NUMBER_TABLE
674 , p5_a6 JTF_VARCHAR2_TABLE_100
675 , p5_a7 JTF_NUMBER_TABLE
676 , p5_a8 JTF_NUMBER_TABLE
677 , p5_a9 JTF_VARCHAR2_TABLE_100
678 , p5_a10 JTF_DATE_TABLE
679 , p5_a11 JTF_VARCHAR2_TABLE_800
680 , p5_a12 JTF_VARCHAR2_TABLE_100
681 , p5_a13 JTF_VARCHAR2_TABLE_100
682 , p5_a14 JTF_VARCHAR2_TABLE_100
683 , p5_a15 JTF_VARCHAR2_TABLE_100
684 , p5_a16 JTF_NUMBER_TABLE
685 , p5_a17 JTF_VARCHAR2_TABLE_100
686 , p5_a18 JTF_NUMBER_TABLE
687 , p5_a19 JTF_NUMBER_TABLE
688 , p5_a20 JTF_DATE_TABLE
689 , p5_a21 JTF_NUMBER_TABLE
690 , p5_a22 JTF_NUMBER_TABLE
691 , p5_a23 JTF_DATE_TABLE
692 , p5_a24 JTF_NUMBER_TABLE
693 , p5_a25 JTF_DATE_TABLE
694 , p5_a26 JTF_NUMBER_TABLE
695 );
696 end okl_aeh_pvt_w;