1: package okl_rfc_pvt_w AUTHID CURRENT_USER as
2: /* $Header: OKLIRFCS.pls 115.3 2002/12/19 23:27:37 gkadarka noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_rfc_pvt.rfc_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_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_DATE_TABLE
13: , a10 JTF_VARCHAR2_TABLE_100
14: , a11 JTF_VARCHAR2_TABLE_500
15: , a12 JTF_VARCHAR2_TABLE_500
16: , a13 JTF_VARCHAR2_TABLE_500
17: , a14 JTF_VARCHAR2_TABLE_500
30: , a27 JTF_DATE_TABLE
31: , a28 JTF_NUMBER_TABLE
32: , a29 JTF_DATE_TABLE
33: , a30 JTF_NUMBER_TABLE
34: , a31 JTF_VARCHAR2_TABLE_100
35: , a32 JTF_VARCHAR2_TABLE_100
36: , a33 JTF_VARCHAR2_TABLE_100
37: , a34 JTF_NUMBER_TABLE
38: , a35 JTF_DATE_TABLE
31: , a28 JTF_NUMBER_TABLE
32: , a29 JTF_DATE_TABLE
33: , a30 JTF_NUMBER_TABLE
34: , a31 JTF_VARCHAR2_TABLE_100
35: , a32 JTF_VARCHAR2_TABLE_100
36: , a33 JTF_VARCHAR2_TABLE_100
37: , a34 JTF_NUMBER_TABLE
38: , a35 JTF_DATE_TABLE
39: );
32: , a29 JTF_DATE_TABLE
33: , a30 JTF_NUMBER_TABLE
34: , a31 JTF_VARCHAR2_TABLE_100
35: , a32 JTF_VARCHAR2_TABLE_100
36: , a33 JTF_VARCHAR2_TABLE_100
37: , a34 JTF_NUMBER_TABLE
38: , a35 JTF_DATE_TABLE
39: );
40: procedure rosetta_table_copy_out_p2(t okl_rfc_pvt.rfc_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
37: , a34 JTF_NUMBER_TABLE
38: , a35 JTF_DATE_TABLE
39: );
40: procedure rosetta_table_copy_out_p2(t okl_rfc_pvt.rfc_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
41: , a1 out nocopy JTF_VARCHAR2_TABLE_100
42: , a2 out nocopy JTF_NUMBER_TABLE
43: , a3 out nocopy JTF_NUMBER_TABLE
44: , a4 out nocopy JTF_NUMBER_TABLE
45: , a5 out nocopy JTF_NUMBER_TABLE
46: , a6 out nocopy JTF_NUMBER_TABLE
47: , a7 out nocopy JTF_NUMBER_TABLE
48: , a8 out nocopy JTF_NUMBER_TABLE
49: , a9 out nocopy JTF_DATE_TABLE
50: , a10 out nocopy JTF_VARCHAR2_TABLE_100
51: , a11 out nocopy JTF_VARCHAR2_TABLE_500
52: , a12 out nocopy JTF_VARCHAR2_TABLE_500
53: , a13 out nocopy JTF_VARCHAR2_TABLE_500
54: , a14 out nocopy JTF_VARCHAR2_TABLE_500
67: , a27 out nocopy JTF_DATE_TABLE
68: , a28 out nocopy JTF_NUMBER_TABLE
69: , a29 out nocopy JTF_DATE_TABLE
70: , a30 out nocopy JTF_NUMBER_TABLE
71: , a31 out nocopy JTF_VARCHAR2_TABLE_100
72: , a32 out nocopy JTF_VARCHAR2_TABLE_100
73: , a33 out nocopy JTF_VARCHAR2_TABLE_100
74: , a34 out nocopy JTF_NUMBER_TABLE
75: , a35 out nocopy JTF_DATE_TABLE
68: , a28 out nocopy JTF_NUMBER_TABLE
69: , a29 out nocopy JTF_DATE_TABLE
70: , a30 out nocopy JTF_NUMBER_TABLE
71: , a31 out nocopy JTF_VARCHAR2_TABLE_100
72: , a32 out nocopy JTF_VARCHAR2_TABLE_100
73: , a33 out nocopy JTF_VARCHAR2_TABLE_100
74: , a34 out nocopy JTF_NUMBER_TABLE
75: , a35 out nocopy JTF_DATE_TABLE
76: );
69: , a29 out nocopy JTF_DATE_TABLE
70: , a30 out nocopy JTF_NUMBER_TABLE
71: , a31 out nocopy JTF_VARCHAR2_TABLE_100
72: , a32 out nocopy JTF_VARCHAR2_TABLE_100
73: , a33 out nocopy JTF_VARCHAR2_TABLE_100
74: , a34 out nocopy JTF_NUMBER_TABLE
75: , a35 out nocopy JTF_DATE_TABLE
76: );
77:
75: , a35 out nocopy JTF_DATE_TABLE
76: );
77:
78: procedure rosetta_table_copy_in_p5(t out nocopy okl_rfc_pvt.oklremarktngcoststltbltype, a0 JTF_NUMBER_TABLE
79: , a1 JTF_VARCHAR2_TABLE_100
80: , a2 JTF_VARCHAR2_TABLE_100
81: , a3 JTF_VARCHAR2_TABLE_100
82: , a4 JTF_VARCHAR2_TABLE_2000
83: , a5 JTF_NUMBER_TABLE
76: );
77:
78: procedure rosetta_table_copy_in_p5(t out nocopy okl_rfc_pvt.oklremarktngcoststltbltype, a0 JTF_NUMBER_TABLE
79: , a1 JTF_VARCHAR2_TABLE_100
80: , a2 JTF_VARCHAR2_TABLE_100
81: , a3 JTF_VARCHAR2_TABLE_100
82: , a4 JTF_VARCHAR2_TABLE_2000
83: , a5 JTF_NUMBER_TABLE
84: , a6 JTF_DATE_TABLE
77:
78: procedure rosetta_table_copy_in_p5(t out nocopy okl_rfc_pvt.oklremarktngcoststltbltype, a0 JTF_NUMBER_TABLE
79: , a1 JTF_VARCHAR2_TABLE_100
80: , a2 JTF_VARCHAR2_TABLE_100
81: , a3 JTF_VARCHAR2_TABLE_100
82: , a4 JTF_VARCHAR2_TABLE_2000
83: , a5 JTF_NUMBER_TABLE
84: , a6 JTF_DATE_TABLE
85: , a7 JTF_NUMBER_TABLE
86: , a8 JTF_DATE_TABLE
87: , a9 JTF_NUMBER_TABLE
88: );
89: procedure rosetta_table_copy_out_p5(t okl_rfc_pvt.oklremarktngcoststltbltype, a0 out nocopy JTF_NUMBER_TABLE
90: , a1 out nocopy JTF_VARCHAR2_TABLE_100
91: , a2 out nocopy JTF_VARCHAR2_TABLE_100
92: , a3 out nocopy JTF_VARCHAR2_TABLE_100
93: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
94: , a5 out nocopy JTF_NUMBER_TABLE
87: , a9 JTF_NUMBER_TABLE
88: );
89: procedure rosetta_table_copy_out_p5(t okl_rfc_pvt.oklremarktngcoststltbltype, a0 out nocopy JTF_NUMBER_TABLE
90: , a1 out nocopy JTF_VARCHAR2_TABLE_100
91: , a2 out nocopy JTF_VARCHAR2_TABLE_100
92: , a3 out nocopy JTF_VARCHAR2_TABLE_100
93: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
94: , a5 out nocopy JTF_NUMBER_TABLE
95: , a6 out nocopy JTF_DATE_TABLE
88: );
89: procedure rosetta_table_copy_out_p5(t okl_rfc_pvt.oklremarktngcoststltbltype, a0 out nocopy JTF_NUMBER_TABLE
90: , a1 out nocopy JTF_VARCHAR2_TABLE_100
91: , a2 out nocopy JTF_VARCHAR2_TABLE_100
92: , a3 out nocopy JTF_VARCHAR2_TABLE_100
93: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
94: , a5 out nocopy JTF_NUMBER_TABLE
95: , a6 out nocopy JTF_DATE_TABLE
96: , a7 out nocopy JTF_NUMBER_TABLE
99: );
100:
101: procedure rosetta_table_copy_in_p8(t out nocopy okl_rfc_pvt.rfcv_tbl_type, a0 JTF_NUMBER_TABLE
102: , a1 JTF_NUMBER_TABLE
103: , a2 JTF_VARCHAR2_TABLE_100
104: , a3 JTF_NUMBER_TABLE
105: , a4 JTF_VARCHAR2_TABLE_100
106: , a5 JTF_NUMBER_TABLE
107: , a6 JTF_VARCHAR2_TABLE_2000
101: procedure rosetta_table_copy_in_p8(t out nocopy okl_rfc_pvt.rfcv_tbl_type, a0 JTF_NUMBER_TABLE
102: , a1 JTF_NUMBER_TABLE
103: , a2 JTF_VARCHAR2_TABLE_100
104: , a3 JTF_NUMBER_TABLE
105: , a4 JTF_VARCHAR2_TABLE_100
106: , a5 JTF_NUMBER_TABLE
107: , a6 JTF_VARCHAR2_TABLE_2000
108: , a7 JTF_VARCHAR2_TABLE_100
109: , a8 JTF_VARCHAR2_TABLE_500
104: , a3 JTF_NUMBER_TABLE
105: , a4 JTF_VARCHAR2_TABLE_100
106: , a5 JTF_NUMBER_TABLE
107: , a6 JTF_VARCHAR2_TABLE_2000
108: , a7 JTF_VARCHAR2_TABLE_100
109: , a8 JTF_VARCHAR2_TABLE_500
110: , a9 JTF_VARCHAR2_TABLE_500
111: , a10 JTF_VARCHAR2_TABLE_500
112: , a11 JTF_VARCHAR2_TABLE_500
130: , a29 JTF_DATE_TABLE
131: , a30 JTF_NUMBER_TABLE
132: , a31 JTF_DATE_TABLE
133: , a32 JTF_NUMBER_TABLE
134: , a33 JTF_VARCHAR2_TABLE_100
135: , a34 JTF_VARCHAR2_TABLE_100
136: , a35 JTF_VARCHAR2_TABLE_100
137: , a36 JTF_NUMBER_TABLE
138: , a37 JTF_DATE_TABLE
131: , a30 JTF_NUMBER_TABLE
132: , a31 JTF_DATE_TABLE
133: , a32 JTF_NUMBER_TABLE
134: , a33 JTF_VARCHAR2_TABLE_100
135: , a34 JTF_VARCHAR2_TABLE_100
136: , a35 JTF_VARCHAR2_TABLE_100
137: , a36 JTF_NUMBER_TABLE
138: , a37 JTF_DATE_TABLE
139: );
132: , a31 JTF_DATE_TABLE
133: , a32 JTF_NUMBER_TABLE
134: , a33 JTF_VARCHAR2_TABLE_100
135: , a34 JTF_VARCHAR2_TABLE_100
136: , a35 JTF_VARCHAR2_TABLE_100
137: , a36 JTF_NUMBER_TABLE
138: , a37 JTF_DATE_TABLE
139: );
140: procedure rosetta_table_copy_out_p8(t okl_rfc_pvt.rfcv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
138: , a37 JTF_DATE_TABLE
139: );
140: procedure rosetta_table_copy_out_p8(t okl_rfc_pvt.rfcv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
141: , a1 out nocopy JTF_NUMBER_TABLE
142: , a2 out nocopy JTF_VARCHAR2_TABLE_100
143: , a3 out nocopy JTF_NUMBER_TABLE
144: , a4 out nocopy JTF_VARCHAR2_TABLE_100
145: , a5 out nocopy JTF_NUMBER_TABLE
146: , a6 out nocopy JTF_VARCHAR2_TABLE_2000
140: procedure rosetta_table_copy_out_p8(t okl_rfc_pvt.rfcv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
141: , a1 out nocopy JTF_NUMBER_TABLE
142: , a2 out nocopy JTF_VARCHAR2_TABLE_100
143: , a3 out nocopy JTF_NUMBER_TABLE
144: , a4 out nocopy JTF_VARCHAR2_TABLE_100
145: , a5 out nocopy JTF_NUMBER_TABLE
146: , a6 out nocopy JTF_VARCHAR2_TABLE_2000
147: , a7 out nocopy JTF_VARCHAR2_TABLE_100
148: , a8 out nocopy JTF_VARCHAR2_TABLE_500
143: , a3 out nocopy JTF_NUMBER_TABLE
144: , a4 out nocopy JTF_VARCHAR2_TABLE_100
145: , a5 out nocopy JTF_NUMBER_TABLE
146: , a6 out nocopy JTF_VARCHAR2_TABLE_2000
147: , a7 out nocopy JTF_VARCHAR2_TABLE_100
148: , a8 out nocopy JTF_VARCHAR2_TABLE_500
149: , a9 out nocopy JTF_VARCHAR2_TABLE_500
150: , a10 out nocopy JTF_VARCHAR2_TABLE_500
151: , a11 out nocopy JTF_VARCHAR2_TABLE_500
169: , a29 out nocopy JTF_DATE_TABLE
170: , a30 out nocopy JTF_NUMBER_TABLE
171: , a31 out nocopy JTF_DATE_TABLE
172: , a32 out nocopy JTF_NUMBER_TABLE
173: , a33 out nocopy JTF_VARCHAR2_TABLE_100
174: , a34 out nocopy JTF_VARCHAR2_TABLE_100
175: , a35 out nocopy JTF_VARCHAR2_TABLE_100
176: , a36 out nocopy JTF_NUMBER_TABLE
177: , a37 out nocopy JTF_DATE_TABLE
170: , a30 out nocopy JTF_NUMBER_TABLE
171: , a31 out nocopy JTF_DATE_TABLE
172: , a32 out nocopy JTF_NUMBER_TABLE
173: , a33 out nocopy JTF_VARCHAR2_TABLE_100
174: , a34 out nocopy JTF_VARCHAR2_TABLE_100
175: , a35 out nocopy JTF_VARCHAR2_TABLE_100
176: , a36 out nocopy JTF_NUMBER_TABLE
177: , a37 out nocopy JTF_DATE_TABLE
178: );
171: , a31 out nocopy JTF_DATE_TABLE
172: , a32 out nocopy JTF_NUMBER_TABLE
173: , a33 out nocopy JTF_VARCHAR2_TABLE_100
174: , a34 out nocopy JTF_VARCHAR2_TABLE_100
175: , a35 out nocopy JTF_VARCHAR2_TABLE_100
176: , a36 out nocopy JTF_NUMBER_TABLE
177: , a37 out nocopy JTF_DATE_TABLE
178: );
179:
265: , x_msg_count out nocopy NUMBER
266: , x_msg_data out nocopy VARCHAR2
267: , p5_a0 JTF_NUMBER_TABLE
268: , p5_a1 JTF_NUMBER_TABLE
269: , p5_a2 JTF_VARCHAR2_TABLE_100
270: , p5_a3 JTF_NUMBER_TABLE
271: , p5_a4 JTF_VARCHAR2_TABLE_100
272: , p5_a5 JTF_NUMBER_TABLE
273: , p5_a6 JTF_VARCHAR2_TABLE_2000
267: , p5_a0 JTF_NUMBER_TABLE
268: , p5_a1 JTF_NUMBER_TABLE
269: , p5_a2 JTF_VARCHAR2_TABLE_100
270: , p5_a3 JTF_NUMBER_TABLE
271: , p5_a4 JTF_VARCHAR2_TABLE_100
272: , p5_a5 JTF_NUMBER_TABLE
273: , p5_a6 JTF_VARCHAR2_TABLE_2000
274: , p5_a7 JTF_VARCHAR2_TABLE_100
275: , p5_a8 JTF_VARCHAR2_TABLE_500
270: , p5_a3 JTF_NUMBER_TABLE
271: , p5_a4 JTF_VARCHAR2_TABLE_100
272: , p5_a5 JTF_NUMBER_TABLE
273: , p5_a6 JTF_VARCHAR2_TABLE_2000
274: , p5_a7 JTF_VARCHAR2_TABLE_100
275: , p5_a8 JTF_VARCHAR2_TABLE_500
276: , p5_a9 JTF_VARCHAR2_TABLE_500
277: , p5_a10 JTF_VARCHAR2_TABLE_500
278: , p5_a11 JTF_VARCHAR2_TABLE_500
296: , p5_a29 JTF_DATE_TABLE
297: , p5_a30 JTF_NUMBER_TABLE
298: , p5_a31 JTF_DATE_TABLE
299: , p5_a32 JTF_NUMBER_TABLE
300: , p5_a33 JTF_VARCHAR2_TABLE_100
301: , p5_a34 JTF_VARCHAR2_TABLE_100
302: , p5_a35 JTF_VARCHAR2_TABLE_100
303: , p5_a36 JTF_NUMBER_TABLE
304: , p5_a37 JTF_DATE_TABLE
297: , p5_a30 JTF_NUMBER_TABLE
298: , p5_a31 JTF_DATE_TABLE
299: , p5_a32 JTF_NUMBER_TABLE
300: , p5_a33 JTF_VARCHAR2_TABLE_100
301: , p5_a34 JTF_VARCHAR2_TABLE_100
302: , p5_a35 JTF_VARCHAR2_TABLE_100
303: , p5_a36 JTF_NUMBER_TABLE
304: , p5_a37 JTF_DATE_TABLE
305: , p6_a0 out nocopy JTF_NUMBER_TABLE
298: , p5_a31 JTF_DATE_TABLE
299: , p5_a32 JTF_NUMBER_TABLE
300: , p5_a33 JTF_VARCHAR2_TABLE_100
301: , p5_a34 JTF_VARCHAR2_TABLE_100
302: , p5_a35 JTF_VARCHAR2_TABLE_100
303: , p5_a36 JTF_NUMBER_TABLE
304: , p5_a37 JTF_DATE_TABLE
305: , p6_a0 out nocopy JTF_NUMBER_TABLE
306: , p6_a1 out nocopy JTF_NUMBER_TABLE
303: , p5_a36 JTF_NUMBER_TABLE
304: , p5_a37 JTF_DATE_TABLE
305: , p6_a0 out nocopy JTF_NUMBER_TABLE
306: , p6_a1 out nocopy JTF_NUMBER_TABLE
307: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
308: , p6_a3 out nocopy JTF_NUMBER_TABLE
309: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
310: , p6_a5 out nocopy JTF_NUMBER_TABLE
311: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000
305: , p6_a0 out nocopy JTF_NUMBER_TABLE
306: , p6_a1 out nocopy JTF_NUMBER_TABLE
307: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
308: , p6_a3 out nocopy JTF_NUMBER_TABLE
309: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
310: , p6_a5 out nocopy JTF_NUMBER_TABLE
311: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000
312: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
313: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_500
308: , p6_a3 out nocopy JTF_NUMBER_TABLE
309: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
310: , p6_a5 out nocopy JTF_NUMBER_TABLE
311: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000
312: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
313: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_500
314: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_500
315: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_500
316: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_500
334: , p6_a29 out nocopy JTF_DATE_TABLE
335: , p6_a30 out nocopy JTF_NUMBER_TABLE
336: , p6_a31 out nocopy JTF_DATE_TABLE
337: , p6_a32 out nocopy JTF_NUMBER_TABLE
338: , p6_a33 out nocopy JTF_VARCHAR2_TABLE_100
339: , p6_a34 out nocopy JTF_VARCHAR2_TABLE_100
340: , p6_a35 out nocopy JTF_VARCHAR2_TABLE_100
341: , p6_a36 out nocopy JTF_NUMBER_TABLE
342: , p6_a37 out nocopy JTF_DATE_TABLE
335: , p6_a30 out nocopy JTF_NUMBER_TABLE
336: , p6_a31 out nocopy JTF_DATE_TABLE
337: , p6_a32 out nocopy JTF_NUMBER_TABLE
338: , p6_a33 out nocopy JTF_VARCHAR2_TABLE_100
339: , p6_a34 out nocopy JTF_VARCHAR2_TABLE_100
340: , p6_a35 out nocopy JTF_VARCHAR2_TABLE_100
341: , p6_a36 out nocopy JTF_NUMBER_TABLE
342: , p6_a37 out nocopy JTF_DATE_TABLE
343: );
336: , p6_a31 out nocopy JTF_DATE_TABLE
337: , p6_a32 out nocopy JTF_NUMBER_TABLE
338: , p6_a33 out nocopy JTF_VARCHAR2_TABLE_100
339: , p6_a34 out nocopy JTF_VARCHAR2_TABLE_100
340: , p6_a35 out nocopy JTF_VARCHAR2_TABLE_100
341: , p6_a36 out nocopy JTF_NUMBER_TABLE
342: , p6_a37 out nocopy JTF_DATE_TABLE
343: );
344: procedure lock_row(p_api_version NUMBER
391: , x_msg_count out nocopy NUMBER
392: , x_msg_data out nocopy VARCHAR2
393: , p5_a0 JTF_NUMBER_TABLE
394: , p5_a1 JTF_NUMBER_TABLE
395: , p5_a2 JTF_VARCHAR2_TABLE_100
396: , p5_a3 JTF_NUMBER_TABLE
397: , p5_a4 JTF_VARCHAR2_TABLE_100
398: , p5_a5 JTF_NUMBER_TABLE
399: , p5_a6 JTF_VARCHAR2_TABLE_2000
393: , p5_a0 JTF_NUMBER_TABLE
394: , p5_a1 JTF_NUMBER_TABLE
395: , p5_a2 JTF_VARCHAR2_TABLE_100
396: , p5_a3 JTF_NUMBER_TABLE
397: , p5_a4 JTF_VARCHAR2_TABLE_100
398: , p5_a5 JTF_NUMBER_TABLE
399: , p5_a6 JTF_VARCHAR2_TABLE_2000
400: , p5_a7 JTF_VARCHAR2_TABLE_100
401: , p5_a8 JTF_VARCHAR2_TABLE_500
396: , p5_a3 JTF_NUMBER_TABLE
397: , p5_a4 JTF_VARCHAR2_TABLE_100
398: , p5_a5 JTF_NUMBER_TABLE
399: , p5_a6 JTF_VARCHAR2_TABLE_2000
400: , p5_a7 JTF_VARCHAR2_TABLE_100
401: , p5_a8 JTF_VARCHAR2_TABLE_500
402: , p5_a9 JTF_VARCHAR2_TABLE_500
403: , p5_a10 JTF_VARCHAR2_TABLE_500
404: , p5_a11 JTF_VARCHAR2_TABLE_500
422: , p5_a29 JTF_DATE_TABLE
423: , p5_a30 JTF_NUMBER_TABLE
424: , p5_a31 JTF_DATE_TABLE
425: , p5_a32 JTF_NUMBER_TABLE
426: , p5_a33 JTF_VARCHAR2_TABLE_100
427: , p5_a34 JTF_VARCHAR2_TABLE_100
428: , p5_a35 JTF_VARCHAR2_TABLE_100
429: , p5_a36 JTF_NUMBER_TABLE
430: , p5_a37 JTF_DATE_TABLE
423: , p5_a30 JTF_NUMBER_TABLE
424: , p5_a31 JTF_DATE_TABLE
425: , p5_a32 JTF_NUMBER_TABLE
426: , p5_a33 JTF_VARCHAR2_TABLE_100
427: , p5_a34 JTF_VARCHAR2_TABLE_100
428: , p5_a35 JTF_VARCHAR2_TABLE_100
429: , p5_a36 JTF_NUMBER_TABLE
430: , p5_a37 JTF_DATE_TABLE
431: );
424: , p5_a31 JTF_DATE_TABLE
425: , p5_a32 JTF_NUMBER_TABLE
426: , p5_a33 JTF_VARCHAR2_TABLE_100
427: , p5_a34 JTF_VARCHAR2_TABLE_100
428: , p5_a35 JTF_VARCHAR2_TABLE_100
429: , p5_a36 JTF_NUMBER_TABLE
430: , p5_a37 JTF_DATE_TABLE
431: );
432: procedure update_row(p_api_version NUMBER
517: , x_msg_count out nocopy NUMBER
518: , x_msg_data out nocopy VARCHAR2
519: , p5_a0 JTF_NUMBER_TABLE
520: , p5_a1 JTF_NUMBER_TABLE
521: , p5_a2 JTF_VARCHAR2_TABLE_100
522: , p5_a3 JTF_NUMBER_TABLE
523: , p5_a4 JTF_VARCHAR2_TABLE_100
524: , p5_a5 JTF_NUMBER_TABLE
525: , p5_a6 JTF_VARCHAR2_TABLE_2000
519: , p5_a0 JTF_NUMBER_TABLE
520: , p5_a1 JTF_NUMBER_TABLE
521: , p5_a2 JTF_VARCHAR2_TABLE_100
522: , p5_a3 JTF_NUMBER_TABLE
523: , p5_a4 JTF_VARCHAR2_TABLE_100
524: , p5_a5 JTF_NUMBER_TABLE
525: , p5_a6 JTF_VARCHAR2_TABLE_2000
526: , p5_a7 JTF_VARCHAR2_TABLE_100
527: , p5_a8 JTF_VARCHAR2_TABLE_500
522: , p5_a3 JTF_NUMBER_TABLE
523: , p5_a4 JTF_VARCHAR2_TABLE_100
524: , p5_a5 JTF_NUMBER_TABLE
525: , p5_a6 JTF_VARCHAR2_TABLE_2000
526: , p5_a7 JTF_VARCHAR2_TABLE_100
527: , p5_a8 JTF_VARCHAR2_TABLE_500
528: , p5_a9 JTF_VARCHAR2_TABLE_500
529: , p5_a10 JTF_VARCHAR2_TABLE_500
530: , p5_a11 JTF_VARCHAR2_TABLE_500
548: , p5_a29 JTF_DATE_TABLE
549: , p5_a30 JTF_NUMBER_TABLE
550: , p5_a31 JTF_DATE_TABLE
551: , p5_a32 JTF_NUMBER_TABLE
552: , p5_a33 JTF_VARCHAR2_TABLE_100
553: , p5_a34 JTF_VARCHAR2_TABLE_100
554: , p5_a35 JTF_VARCHAR2_TABLE_100
555: , p5_a36 JTF_NUMBER_TABLE
556: , p5_a37 JTF_DATE_TABLE
549: , p5_a30 JTF_NUMBER_TABLE
550: , p5_a31 JTF_DATE_TABLE
551: , p5_a32 JTF_NUMBER_TABLE
552: , p5_a33 JTF_VARCHAR2_TABLE_100
553: , p5_a34 JTF_VARCHAR2_TABLE_100
554: , p5_a35 JTF_VARCHAR2_TABLE_100
555: , p5_a36 JTF_NUMBER_TABLE
556: , p5_a37 JTF_DATE_TABLE
557: , p6_a0 out nocopy JTF_NUMBER_TABLE
550: , p5_a31 JTF_DATE_TABLE
551: , p5_a32 JTF_NUMBER_TABLE
552: , p5_a33 JTF_VARCHAR2_TABLE_100
553: , p5_a34 JTF_VARCHAR2_TABLE_100
554: , p5_a35 JTF_VARCHAR2_TABLE_100
555: , p5_a36 JTF_NUMBER_TABLE
556: , p5_a37 JTF_DATE_TABLE
557: , p6_a0 out nocopy JTF_NUMBER_TABLE
558: , p6_a1 out nocopy JTF_NUMBER_TABLE
555: , p5_a36 JTF_NUMBER_TABLE
556: , p5_a37 JTF_DATE_TABLE
557: , p6_a0 out nocopy JTF_NUMBER_TABLE
558: , p6_a1 out nocopy JTF_NUMBER_TABLE
559: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
560: , p6_a3 out nocopy JTF_NUMBER_TABLE
561: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
562: , p6_a5 out nocopy JTF_NUMBER_TABLE
563: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000
557: , p6_a0 out nocopy JTF_NUMBER_TABLE
558: , p6_a1 out nocopy JTF_NUMBER_TABLE
559: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
560: , p6_a3 out nocopy JTF_NUMBER_TABLE
561: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
562: , p6_a5 out nocopy JTF_NUMBER_TABLE
563: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000
564: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
565: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_500
560: , p6_a3 out nocopy JTF_NUMBER_TABLE
561: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
562: , p6_a5 out nocopy JTF_NUMBER_TABLE
563: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000
564: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
565: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_500
566: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_500
567: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_500
568: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_500
586: , p6_a29 out nocopy JTF_DATE_TABLE
587: , p6_a30 out nocopy JTF_NUMBER_TABLE
588: , p6_a31 out nocopy JTF_DATE_TABLE
589: , p6_a32 out nocopy JTF_NUMBER_TABLE
590: , p6_a33 out nocopy JTF_VARCHAR2_TABLE_100
591: , p6_a34 out nocopy JTF_VARCHAR2_TABLE_100
592: , p6_a35 out nocopy JTF_VARCHAR2_TABLE_100
593: , p6_a36 out nocopy JTF_NUMBER_TABLE
594: , p6_a37 out nocopy JTF_DATE_TABLE
587: , p6_a30 out nocopy JTF_NUMBER_TABLE
588: , p6_a31 out nocopy JTF_DATE_TABLE
589: , p6_a32 out nocopy JTF_NUMBER_TABLE
590: , p6_a33 out nocopy JTF_VARCHAR2_TABLE_100
591: , p6_a34 out nocopy JTF_VARCHAR2_TABLE_100
592: , p6_a35 out nocopy JTF_VARCHAR2_TABLE_100
593: , p6_a36 out nocopy JTF_NUMBER_TABLE
594: , p6_a37 out nocopy JTF_DATE_TABLE
595: );
588: , p6_a31 out nocopy JTF_DATE_TABLE
589: , p6_a32 out nocopy JTF_NUMBER_TABLE
590: , p6_a33 out nocopy JTF_VARCHAR2_TABLE_100
591: , p6_a34 out nocopy JTF_VARCHAR2_TABLE_100
592: , p6_a35 out nocopy JTF_VARCHAR2_TABLE_100
593: , p6_a36 out nocopy JTF_NUMBER_TABLE
594: , p6_a37 out nocopy JTF_DATE_TABLE
595: );
596: procedure delete_row(p_api_version NUMBER
643: , x_msg_count out nocopy NUMBER
644: , x_msg_data out nocopy VARCHAR2
645: , p5_a0 JTF_NUMBER_TABLE
646: , p5_a1 JTF_NUMBER_TABLE
647: , p5_a2 JTF_VARCHAR2_TABLE_100
648: , p5_a3 JTF_NUMBER_TABLE
649: , p5_a4 JTF_VARCHAR2_TABLE_100
650: , p5_a5 JTF_NUMBER_TABLE
651: , p5_a6 JTF_VARCHAR2_TABLE_2000
645: , p5_a0 JTF_NUMBER_TABLE
646: , p5_a1 JTF_NUMBER_TABLE
647: , p5_a2 JTF_VARCHAR2_TABLE_100
648: , p5_a3 JTF_NUMBER_TABLE
649: , p5_a4 JTF_VARCHAR2_TABLE_100
650: , p5_a5 JTF_NUMBER_TABLE
651: , p5_a6 JTF_VARCHAR2_TABLE_2000
652: , p5_a7 JTF_VARCHAR2_TABLE_100
653: , p5_a8 JTF_VARCHAR2_TABLE_500
648: , p5_a3 JTF_NUMBER_TABLE
649: , p5_a4 JTF_VARCHAR2_TABLE_100
650: , p5_a5 JTF_NUMBER_TABLE
651: , p5_a6 JTF_VARCHAR2_TABLE_2000
652: , p5_a7 JTF_VARCHAR2_TABLE_100
653: , p5_a8 JTF_VARCHAR2_TABLE_500
654: , p5_a9 JTF_VARCHAR2_TABLE_500
655: , p5_a10 JTF_VARCHAR2_TABLE_500
656: , p5_a11 JTF_VARCHAR2_TABLE_500
674: , p5_a29 JTF_DATE_TABLE
675: , p5_a30 JTF_NUMBER_TABLE
676: , p5_a31 JTF_DATE_TABLE
677: , p5_a32 JTF_NUMBER_TABLE
678: , p5_a33 JTF_VARCHAR2_TABLE_100
679: , p5_a34 JTF_VARCHAR2_TABLE_100
680: , p5_a35 JTF_VARCHAR2_TABLE_100
681: , p5_a36 JTF_NUMBER_TABLE
682: , p5_a37 JTF_DATE_TABLE
675: , p5_a30 JTF_NUMBER_TABLE
676: , p5_a31 JTF_DATE_TABLE
677: , p5_a32 JTF_NUMBER_TABLE
678: , p5_a33 JTF_VARCHAR2_TABLE_100
679: , p5_a34 JTF_VARCHAR2_TABLE_100
680: , p5_a35 JTF_VARCHAR2_TABLE_100
681: , p5_a36 JTF_NUMBER_TABLE
682: , p5_a37 JTF_DATE_TABLE
683: );
676: , p5_a31 JTF_DATE_TABLE
677: , p5_a32 JTF_NUMBER_TABLE
678: , p5_a33 JTF_VARCHAR2_TABLE_100
679: , p5_a34 JTF_VARCHAR2_TABLE_100
680: , p5_a35 JTF_VARCHAR2_TABLE_100
681: , p5_a36 JTF_NUMBER_TABLE
682: , p5_a37 JTF_DATE_TABLE
683: );
684: procedure validate_row(p_api_version NUMBER
731: , x_msg_count out nocopy NUMBER
732: , x_msg_data out nocopy VARCHAR2
733: , p5_a0 JTF_NUMBER_TABLE
734: , p5_a1 JTF_NUMBER_TABLE
735: , p5_a2 JTF_VARCHAR2_TABLE_100
736: , p5_a3 JTF_NUMBER_TABLE
737: , p5_a4 JTF_VARCHAR2_TABLE_100
738: , p5_a5 JTF_NUMBER_TABLE
739: , p5_a6 JTF_VARCHAR2_TABLE_2000
733: , p5_a0 JTF_NUMBER_TABLE
734: , p5_a1 JTF_NUMBER_TABLE
735: , p5_a2 JTF_VARCHAR2_TABLE_100
736: , p5_a3 JTF_NUMBER_TABLE
737: , p5_a4 JTF_VARCHAR2_TABLE_100
738: , p5_a5 JTF_NUMBER_TABLE
739: , p5_a6 JTF_VARCHAR2_TABLE_2000
740: , p5_a7 JTF_VARCHAR2_TABLE_100
741: , p5_a8 JTF_VARCHAR2_TABLE_500
736: , p5_a3 JTF_NUMBER_TABLE
737: , p5_a4 JTF_VARCHAR2_TABLE_100
738: , p5_a5 JTF_NUMBER_TABLE
739: , p5_a6 JTF_VARCHAR2_TABLE_2000
740: , p5_a7 JTF_VARCHAR2_TABLE_100
741: , p5_a8 JTF_VARCHAR2_TABLE_500
742: , p5_a9 JTF_VARCHAR2_TABLE_500
743: , p5_a10 JTF_VARCHAR2_TABLE_500
744: , p5_a11 JTF_VARCHAR2_TABLE_500
762: , p5_a29 JTF_DATE_TABLE
763: , p5_a30 JTF_NUMBER_TABLE
764: , p5_a31 JTF_DATE_TABLE
765: , p5_a32 JTF_NUMBER_TABLE
766: , p5_a33 JTF_VARCHAR2_TABLE_100
767: , p5_a34 JTF_VARCHAR2_TABLE_100
768: , p5_a35 JTF_VARCHAR2_TABLE_100
769: , p5_a36 JTF_NUMBER_TABLE
770: , p5_a37 JTF_DATE_TABLE
763: , p5_a30 JTF_NUMBER_TABLE
764: , p5_a31 JTF_DATE_TABLE
765: , p5_a32 JTF_NUMBER_TABLE
766: , p5_a33 JTF_VARCHAR2_TABLE_100
767: , p5_a34 JTF_VARCHAR2_TABLE_100
768: , p5_a35 JTF_VARCHAR2_TABLE_100
769: , p5_a36 JTF_NUMBER_TABLE
770: , p5_a37 JTF_DATE_TABLE
771: );
764: , p5_a31 JTF_DATE_TABLE
765: , p5_a32 JTF_NUMBER_TABLE
766: , p5_a33 JTF_VARCHAR2_TABLE_100
767: , p5_a34 JTF_VARCHAR2_TABLE_100
768: , p5_a35 JTF_VARCHAR2_TABLE_100
769: , p5_a36 JTF_NUMBER_TABLE
770: , p5_a37 JTF_DATE_TABLE
771: );
772: end okl_rfc_pvt_w;