1: package okl_btc_pvt_w as
2: /* $Header: OKLEBTCS.pls 120.4 2007/09/28 06:48:42 varangan ship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_btc_pvt.btc_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_DATE_TABLE
6: , a3 JTF_DATE_TABLE
7: , a4 JTF_DATE_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
2: /* $Header: OKLEBTCS.pls 120.4 2007/09/28 06:48:42 varangan ship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_btc_pvt.btc_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_DATE_TABLE
6: , a3 JTF_DATE_TABLE
7: , a4 JTF_DATE_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_VARCHAR2_TABLE_100
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_btc_pvt.btc_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_DATE_TABLE
6: , a3 JTF_DATE_TABLE
7: , a4 JTF_DATE_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_NUMBER_TABLE
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_NUMBER_TABLE
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_DATE_TABLE
16: , a13 JTF_NUMBER_TABLE
17: , a14 JTF_VARCHAR2_TABLE_100
18: , a15 JTF_VARCHAR2_TABLE_500
19: , a16 JTF_VARCHAR2_TABLE_500
30: , a27 JTF_VARCHAR2_TABLE_500
31: , a28 JTF_VARCHAR2_TABLE_500
32: , a29 JTF_VARCHAR2_TABLE_500
33: , a30 JTF_NUMBER_TABLE
34: , a31 JTF_DATE_TABLE
35: , a32 JTF_NUMBER_TABLE
36: , a33 JTF_DATE_TABLE
37: , a34 JTF_NUMBER_TABLE
38: , a35 JTF_VARCHAR2_TABLE_100
32: , a29 JTF_VARCHAR2_TABLE_500
33: , a30 JTF_NUMBER_TABLE
34: , a31 JTF_DATE_TABLE
35: , a32 JTF_NUMBER_TABLE
36: , a33 JTF_DATE_TABLE
37: , a34 JTF_NUMBER_TABLE
38: , a35 JTF_VARCHAR2_TABLE_100
39: , a36 JTF_VARCHAR2_TABLE_100
40: , a37 JTF_NUMBER_TABLE
37: , a34 JTF_NUMBER_TABLE
38: , a35 JTF_VARCHAR2_TABLE_100
39: , a36 JTF_VARCHAR2_TABLE_100
40: , a37 JTF_NUMBER_TABLE
41: , a38 JTF_DATE_TABLE
42: , a39 JTF_NUMBER_TABLE
43: );
44: procedure rosetta_table_copy_out_p2(t okl_btc_pvt.btc_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
45: , a1 out nocopy JTF_NUMBER_TABLE
42: , a39 JTF_NUMBER_TABLE
43: );
44: procedure rosetta_table_copy_out_p2(t okl_btc_pvt.btc_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
45: , a1 out nocopy JTF_NUMBER_TABLE
46: , a2 out nocopy JTF_DATE_TABLE
47: , a3 out nocopy JTF_DATE_TABLE
48: , a4 out nocopy JTF_DATE_TABLE
49: , a5 out nocopy JTF_NUMBER_TABLE
50: , a6 out nocopy JTF_NUMBER_TABLE
43: );
44: procedure rosetta_table_copy_out_p2(t okl_btc_pvt.btc_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
45: , a1 out nocopy JTF_NUMBER_TABLE
46: , a2 out nocopy JTF_DATE_TABLE
47: , a3 out nocopy JTF_DATE_TABLE
48: , a4 out nocopy JTF_DATE_TABLE
49: , a5 out nocopy JTF_NUMBER_TABLE
50: , a6 out nocopy JTF_NUMBER_TABLE
51: , a7 out nocopy JTF_VARCHAR2_TABLE_100
44: procedure rosetta_table_copy_out_p2(t okl_btc_pvt.btc_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
45: , a1 out nocopy JTF_NUMBER_TABLE
46: , a2 out nocopy JTF_DATE_TABLE
47: , a3 out nocopy JTF_DATE_TABLE
48: , a4 out nocopy JTF_DATE_TABLE
49: , a5 out nocopy JTF_NUMBER_TABLE
50: , a6 out nocopy JTF_NUMBER_TABLE
51: , a7 out nocopy JTF_VARCHAR2_TABLE_100
52: , a8 out nocopy JTF_NUMBER_TABLE
52: , a8 out nocopy JTF_NUMBER_TABLE
53: , a9 out nocopy JTF_NUMBER_TABLE
54: , a10 out nocopy JTF_NUMBER_TABLE
55: , a11 out nocopy JTF_NUMBER_TABLE
56: , a12 out nocopy JTF_DATE_TABLE
57: , a13 out nocopy JTF_NUMBER_TABLE
58: , a14 out nocopy JTF_VARCHAR2_TABLE_100
59: , a15 out nocopy JTF_VARCHAR2_TABLE_500
60: , a16 out nocopy JTF_VARCHAR2_TABLE_500
71: , a27 out nocopy JTF_VARCHAR2_TABLE_500
72: , a28 out nocopy JTF_VARCHAR2_TABLE_500
73: , a29 out nocopy JTF_VARCHAR2_TABLE_500
74: , a30 out nocopy JTF_NUMBER_TABLE
75: , a31 out nocopy JTF_DATE_TABLE
76: , a32 out nocopy JTF_NUMBER_TABLE
77: , a33 out nocopy JTF_DATE_TABLE
78: , a34 out nocopy JTF_NUMBER_TABLE
79: , a35 out nocopy JTF_VARCHAR2_TABLE_100
73: , a29 out nocopy JTF_VARCHAR2_TABLE_500
74: , a30 out nocopy JTF_NUMBER_TABLE
75: , a31 out nocopy JTF_DATE_TABLE
76: , a32 out nocopy JTF_NUMBER_TABLE
77: , a33 out nocopy JTF_DATE_TABLE
78: , a34 out nocopy JTF_NUMBER_TABLE
79: , a35 out nocopy JTF_VARCHAR2_TABLE_100
80: , a36 out nocopy JTF_VARCHAR2_TABLE_100
81: , a37 out nocopy JTF_NUMBER_TABLE
78: , a34 out nocopy JTF_NUMBER_TABLE
79: , a35 out nocopy JTF_VARCHAR2_TABLE_100
80: , a36 out nocopy JTF_VARCHAR2_TABLE_100
81: , a37 out nocopy JTF_NUMBER_TABLE
82: , a38 out nocopy JTF_DATE_TABLE
83: , a39 out nocopy JTF_NUMBER_TABLE
84: );
85:
86: procedure rosetta_table_copy_in_p5(t out nocopy okl_btc_pvt.okl_trx_csh_batch_tl_tbl_type, a0 JTF_NUMBER_TABLE
89: , a3 JTF_VARCHAR2_TABLE_100
90: , a4 JTF_VARCHAR2_TABLE_200
91: , a5 JTF_VARCHAR2_TABLE_2000
92: , a6 JTF_NUMBER_TABLE
93: , a7 JTF_DATE_TABLE
94: , a8 JTF_NUMBER_TABLE
95: , a9 JTF_DATE_TABLE
96: , a10 JTF_NUMBER_TABLE
97: );
91: , a5 JTF_VARCHAR2_TABLE_2000
92: , a6 JTF_NUMBER_TABLE
93: , a7 JTF_DATE_TABLE
94: , a8 JTF_NUMBER_TABLE
95: , a9 JTF_DATE_TABLE
96: , a10 JTF_NUMBER_TABLE
97: );
98: procedure rosetta_table_copy_out_p5(t okl_btc_pvt.okl_trx_csh_batch_tl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
99: , a1 out nocopy JTF_VARCHAR2_TABLE_100
101: , a3 out nocopy JTF_VARCHAR2_TABLE_100
102: , a4 out nocopy JTF_VARCHAR2_TABLE_200
103: , a5 out nocopy JTF_VARCHAR2_TABLE_2000
104: , a6 out nocopy JTF_NUMBER_TABLE
105: , a7 out nocopy JTF_DATE_TABLE
106: , a8 out nocopy JTF_NUMBER_TABLE
107: , a9 out nocopy JTF_DATE_TABLE
108: , a10 out nocopy JTF_NUMBER_TABLE
109: );
103: , a5 out nocopy JTF_VARCHAR2_TABLE_2000
104: , a6 out nocopy JTF_NUMBER_TABLE
105: , a7 out nocopy JTF_DATE_TABLE
106: , a8 out nocopy JTF_NUMBER_TABLE
107: , a9 out nocopy JTF_DATE_TABLE
108: , a10 out nocopy JTF_NUMBER_TABLE
109: );
110:
111: procedure rosetta_table_copy_in_p8(t out nocopy okl_btc_pvt.btcv_tbl_type, a0 JTF_NUMBER_TABLE
111: procedure rosetta_table_copy_in_p8(t out nocopy okl_btc_pvt.btcv_tbl_type, a0 JTF_NUMBER_TABLE
112: , a1 JTF_NUMBER_TABLE
113: , a2 JTF_VARCHAR2_TABLE_100
114: , a3 JTF_VARCHAR2_TABLE_200
115: , a4 JTF_DATE_TABLE
116: , a5 JTF_DATE_TABLE
117: , a6 JTF_DATE_TABLE
118: , a7 JTF_NUMBER_TABLE
119: , a8 JTF_NUMBER_TABLE
112: , a1 JTF_NUMBER_TABLE
113: , a2 JTF_VARCHAR2_TABLE_100
114: , a3 JTF_VARCHAR2_TABLE_200
115: , a4 JTF_DATE_TABLE
116: , a5 JTF_DATE_TABLE
117: , a6 JTF_DATE_TABLE
118: , a7 JTF_NUMBER_TABLE
119: , a8 JTF_NUMBER_TABLE
120: , a9 JTF_VARCHAR2_TABLE_100
113: , a2 JTF_VARCHAR2_TABLE_100
114: , a3 JTF_VARCHAR2_TABLE_200
115: , a4 JTF_DATE_TABLE
116: , a5 JTF_DATE_TABLE
117: , a6 JTF_DATE_TABLE
118: , a7 JTF_NUMBER_TABLE
119: , a8 JTF_NUMBER_TABLE
120: , a9 JTF_VARCHAR2_TABLE_100
121: , a10 JTF_NUMBER_TABLE
138: , a27 JTF_VARCHAR2_TABLE_500
139: , a28 JTF_NUMBER_TABLE
140: , a29 JTF_NUMBER_TABLE
141: , a30 JTF_NUMBER_TABLE
142: , a31 JTF_DATE_TABLE
143: , a32 JTF_NUMBER_TABLE
144: , a33 JTF_NUMBER_TABLE
145: , a34 JTF_DATE_TABLE
146: , a35 JTF_NUMBER_TABLE
141: , a30 JTF_NUMBER_TABLE
142: , a31 JTF_DATE_TABLE
143: , a32 JTF_NUMBER_TABLE
144: , a33 JTF_NUMBER_TABLE
145: , a34 JTF_DATE_TABLE
146: , a35 JTF_NUMBER_TABLE
147: , a36 JTF_DATE_TABLE
148: , a37 JTF_NUMBER_TABLE
149: , a38 JTF_VARCHAR2_TABLE_100
143: , a32 JTF_NUMBER_TABLE
144: , a33 JTF_NUMBER_TABLE
145: , a34 JTF_DATE_TABLE
146: , a35 JTF_NUMBER_TABLE
147: , a36 JTF_DATE_TABLE
148: , a37 JTF_NUMBER_TABLE
149: , a38 JTF_VARCHAR2_TABLE_100
150: , a39 JTF_VARCHAR2_TABLE_100
151: , a40 JTF_NUMBER_TABLE
148: , a37 JTF_NUMBER_TABLE
149: , a38 JTF_VARCHAR2_TABLE_100
150: , a39 JTF_VARCHAR2_TABLE_100
151: , a40 JTF_NUMBER_TABLE
152: , a41 JTF_DATE_TABLE
153: , a42 JTF_NUMBER_TABLE
154: );
155: procedure rosetta_table_copy_out_p8(t okl_btc_pvt.btcv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
156: , a1 out nocopy JTF_NUMBER_TABLE
155: procedure rosetta_table_copy_out_p8(t okl_btc_pvt.btcv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
156: , a1 out nocopy JTF_NUMBER_TABLE
157: , a2 out nocopy JTF_VARCHAR2_TABLE_100
158: , a3 out nocopy JTF_VARCHAR2_TABLE_200
159: , a4 out nocopy JTF_DATE_TABLE
160: , a5 out nocopy JTF_DATE_TABLE
161: , a6 out nocopy JTF_DATE_TABLE
162: , a7 out nocopy JTF_NUMBER_TABLE
163: , a8 out nocopy JTF_NUMBER_TABLE
156: , a1 out nocopy JTF_NUMBER_TABLE
157: , a2 out nocopy JTF_VARCHAR2_TABLE_100
158: , a3 out nocopy JTF_VARCHAR2_TABLE_200
159: , a4 out nocopy JTF_DATE_TABLE
160: , a5 out nocopy JTF_DATE_TABLE
161: , a6 out nocopy JTF_DATE_TABLE
162: , a7 out nocopy JTF_NUMBER_TABLE
163: , a8 out nocopy JTF_NUMBER_TABLE
164: , a9 out nocopy JTF_VARCHAR2_TABLE_100
157: , a2 out nocopy JTF_VARCHAR2_TABLE_100
158: , a3 out nocopy JTF_VARCHAR2_TABLE_200
159: , a4 out nocopy JTF_DATE_TABLE
160: , a5 out nocopy JTF_DATE_TABLE
161: , a6 out nocopy JTF_DATE_TABLE
162: , a7 out nocopy JTF_NUMBER_TABLE
163: , a8 out nocopy JTF_NUMBER_TABLE
164: , a9 out nocopy JTF_VARCHAR2_TABLE_100
165: , a10 out nocopy JTF_NUMBER_TABLE
182: , a27 out nocopy JTF_VARCHAR2_TABLE_500
183: , a28 out nocopy JTF_NUMBER_TABLE
184: , a29 out nocopy JTF_NUMBER_TABLE
185: , a30 out nocopy JTF_NUMBER_TABLE
186: , a31 out nocopy JTF_DATE_TABLE
187: , a32 out nocopy JTF_NUMBER_TABLE
188: , a33 out nocopy JTF_NUMBER_TABLE
189: , a34 out nocopy JTF_DATE_TABLE
190: , a35 out nocopy JTF_NUMBER_TABLE
185: , a30 out nocopy JTF_NUMBER_TABLE
186: , a31 out nocopy JTF_DATE_TABLE
187: , a32 out nocopy JTF_NUMBER_TABLE
188: , a33 out nocopy JTF_NUMBER_TABLE
189: , a34 out nocopy JTF_DATE_TABLE
190: , a35 out nocopy JTF_NUMBER_TABLE
191: , a36 out nocopy JTF_DATE_TABLE
192: , a37 out nocopy JTF_NUMBER_TABLE
193: , a38 out nocopy JTF_VARCHAR2_TABLE_100
187: , a32 out nocopy JTF_NUMBER_TABLE
188: , a33 out nocopy JTF_NUMBER_TABLE
189: , a34 out nocopy JTF_DATE_TABLE
190: , a35 out nocopy JTF_NUMBER_TABLE
191: , a36 out nocopy JTF_DATE_TABLE
192: , a37 out nocopy JTF_NUMBER_TABLE
193: , a38 out nocopy JTF_VARCHAR2_TABLE_100
194: , a39 out nocopy JTF_VARCHAR2_TABLE_100
195: , a40 out nocopy JTF_NUMBER_TABLE
192: , a37 out nocopy JTF_NUMBER_TABLE
193: , a38 out nocopy JTF_VARCHAR2_TABLE_100
194: , a39 out nocopy JTF_VARCHAR2_TABLE_100
195: , a40 out nocopy JTF_NUMBER_TABLE
196: , a41 out nocopy JTF_DATE_TABLE
197: , a42 out nocopy JTF_NUMBER_TABLE
198: );
199:
200: procedure insert_row(p_api_version NUMBER
297: , p5_a0 JTF_NUMBER_TABLE
298: , p5_a1 JTF_NUMBER_TABLE
299: , p5_a2 JTF_VARCHAR2_TABLE_100
300: , p5_a3 JTF_VARCHAR2_TABLE_200
301: , p5_a4 JTF_DATE_TABLE
302: , p5_a5 JTF_DATE_TABLE
303: , p5_a6 JTF_DATE_TABLE
304: , p5_a7 JTF_NUMBER_TABLE
305: , p5_a8 JTF_NUMBER_TABLE
298: , p5_a1 JTF_NUMBER_TABLE
299: , p5_a2 JTF_VARCHAR2_TABLE_100
300: , p5_a3 JTF_VARCHAR2_TABLE_200
301: , p5_a4 JTF_DATE_TABLE
302: , p5_a5 JTF_DATE_TABLE
303: , p5_a6 JTF_DATE_TABLE
304: , p5_a7 JTF_NUMBER_TABLE
305: , p5_a8 JTF_NUMBER_TABLE
306: , p5_a9 JTF_VARCHAR2_TABLE_100
299: , p5_a2 JTF_VARCHAR2_TABLE_100
300: , p5_a3 JTF_VARCHAR2_TABLE_200
301: , p5_a4 JTF_DATE_TABLE
302: , p5_a5 JTF_DATE_TABLE
303: , p5_a6 JTF_DATE_TABLE
304: , p5_a7 JTF_NUMBER_TABLE
305: , p5_a8 JTF_NUMBER_TABLE
306: , p5_a9 JTF_VARCHAR2_TABLE_100
307: , p5_a10 JTF_NUMBER_TABLE
324: , p5_a27 JTF_VARCHAR2_TABLE_500
325: , p5_a28 JTF_NUMBER_TABLE
326: , p5_a29 JTF_NUMBER_TABLE
327: , p5_a30 JTF_NUMBER_TABLE
328: , p5_a31 JTF_DATE_TABLE
329: , p5_a32 JTF_NUMBER_TABLE
330: , p5_a33 JTF_NUMBER_TABLE
331: , p5_a34 JTF_DATE_TABLE
332: , p5_a35 JTF_NUMBER_TABLE
327: , p5_a30 JTF_NUMBER_TABLE
328: , p5_a31 JTF_DATE_TABLE
329: , p5_a32 JTF_NUMBER_TABLE
330: , p5_a33 JTF_NUMBER_TABLE
331: , p5_a34 JTF_DATE_TABLE
332: , p5_a35 JTF_NUMBER_TABLE
333: , p5_a36 JTF_DATE_TABLE
334: , p5_a37 JTF_NUMBER_TABLE
335: , p5_a38 JTF_VARCHAR2_TABLE_100
329: , p5_a32 JTF_NUMBER_TABLE
330: , p5_a33 JTF_NUMBER_TABLE
331: , p5_a34 JTF_DATE_TABLE
332: , p5_a35 JTF_NUMBER_TABLE
333: , p5_a36 JTF_DATE_TABLE
334: , p5_a37 JTF_NUMBER_TABLE
335: , p5_a38 JTF_VARCHAR2_TABLE_100
336: , p5_a39 JTF_VARCHAR2_TABLE_100
337: , p5_a40 JTF_NUMBER_TABLE
334: , p5_a37 JTF_NUMBER_TABLE
335: , p5_a38 JTF_VARCHAR2_TABLE_100
336: , p5_a39 JTF_VARCHAR2_TABLE_100
337: , p5_a40 JTF_NUMBER_TABLE
338: , p5_a41 JTF_DATE_TABLE
339: , p5_a42 JTF_NUMBER_TABLE
340: , p6_a0 out nocopy JTF_NUMBER_TABLE
341: , p6_a1 out nocopy JTF_NUMBER_TABLE
342: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
340: , p6_a0 out nocopy JTF_NUMBER_TABLE
341: , p6_a1 out nocopy JTF_NUMBER_TABLE
342: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
343: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
344: , p6_a4 out nocopy JTF_DATE_TABLE
345: , p6_a5 out nocopy JTF_DATE_TABLE
346: , p6_a6 out nocopy JTF_DATE_TABLE
347: , p6_a7 out nocopy JTF_NUMBER_TABLE
348: , p6_a8 out nocopy JTF_NUMBER_TABLE
341: , p6_a1 out nocopy JTF_NUMBER_TABLE
342: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
343: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
344: , p6_a4 out nocopy JTF_DATE_TABLE
345: , p6_a5 out nocopy JTF_DATE_TABLE
346: , p6_a6 out nocopy JTF_DATE_TABLE
347: , p6_a7 out nocopy JTF_NUMBER_TABLE
348: , p6_a8 out nocopy JTF_NUMBER_TABLE
349: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
342: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
343: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
344: , p6_a4 out nocopy JTF_DATE_TABLE
345: , p6_a5 out nocopy JTF_DATE_TABLE
346: , p6_a6 out nocopy JTF_DATE_TABLE
347: , p6_a7 out nocopy JTF_NUMBER_TABLE
348: , p6_a8 out nocopy JTF_NUMBER_TABLE
349: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
350: , p6_a10 out nocopy JTF_NUMBER_TABLE
367: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_500
368: , p6_a28 out nocopy JTF_NUMBER_TABLE
369: , p6_a29 out nocopy JTF_NUMBER_TABLE
370: , p6_a30 out nocopy JTF_NUMBER_TABLE
371: , p6_a31 out nocopy JTF_DATE_TABLE
372: , p6_a32 out nocopy JTF_NUMBER_TABLE
373: , p6_a33 out nocopy JTF_NUMBER_TABLE
374: , p6_a34 out nocopy JTF_DATE_TABLE
375: , p6_a35 out nocopy JTF_NUMBER_TABLE
370: , p6_a30 out nocopy JTF_NUMBER_TABLE
371: , p6_a31 out nocopy JTF_DATE_TABLE
372: , p6_a32 out nocopy JTF_NUMBER_TABLE
373: , p6_a33 out nocopy JTF_NUMBER_TABLE
374: , p6_a34 out nocopy JTF_DATE_TABLE
375: , p6_a35 out nocopy JTF_NUMBER_TABLE
376: , p6_a36 out nocopy JTF_DATE_TABLE
377: , p6_a37 out nocopy JTF_NUMBER_TABLE
378: , p6_a38 out nocopy JTF_VARCHAR2_TABLE_100
372: , p6_a32 out nocopy JTF_NUMBER_TABLE
373: , p6_a33 out nocopy JTF_NUMBER_TABLE
374: , p6_a34 out nocopy JTF_DATE_TABLE
375: , p6_a35 out nocopy JTF_NUMBER_TABLE
376: , p6_a36 out nocopy JTF_DATE_TABLE
377: , p6_a37 out nocopy JTF_NUMBER_TABLE
378: , p6_a38 out nocopy JTF_VARCHAR2_TABLE_100
379: , p6_a39 out nocopy JTF_VARCHAR2_TABLE_100
380: , p6_a40 out nocopy JTF_NUMBER_TABLE
377: , p6_a37 out nocopy JTF_NUMBER_TABLE
378: , p6_a38 out nocopy JTF_VARCHAR2_TABLE_100
379: , p6_a39 out nocopy JTF_VARCHAR2_TABLE_100
380: , p6_a40 out nocopy JTF_NUMBER_TABLE
381: , p6_a41 out nocopy JTF_DATE_TABLE
382: , p6_a42 out nocopy JTF_NUMBER_TABLE
383: );
384: procedure lock_row(p_api_version NUMBER
385: , p_init_msg_list VARCHAR2
438: , p5_a0 JTF_NUMBER_TABLE
439: , p5_a1 JTF_NUMBER_TABLE
440: , p5_a2 JTF_VARCHAR2_TABLE_100
441: , p5_a3 JTF_VARCHAR2_TABLE_200
442: , p5_a4 JTF_DATE_TABLE
443: , p5_a5 JTF_DATE_TABLE
444: , p5_a6 JTF_DATE_TABLE
445: , p5_a7 JTF_NUMBER_TABLE
446: , p5_a8 JTF_NUMBER_TABLE
439: , p5_a1 JTF_NUMBER_TABLE
440: , p5_a2 JTF_VARCHAR2_TABLE_100
441: , p5_a3 JTF_VARCHAR2_TABLE_200
442: , p5_a4 JTF_DATE_TABLE
443: , p5_a5 JTF_DATE_TABLE
444: , p5_a6 JTF_DATE_TABLE
445: , p5_a7 JTF_NUMBER_TABLE
446: , p5_a8 JTF_NUMBER_TABLE
447: , p5_a9 JTF_VARCHAR2_TABLE_100
440: , p5_a2 JTF_VARCHAR2_TABLE_100
441: , p5_a3 JTF_VARCHAR2_TABLE_200
442: , p5_a4 JTF_DATE_TABLE
443: , p5_a5 JTF_DATE_TABLE
444: , p5_a6 JTF_DATE_TABLE
445: , p5_a7 JTF_NUMBER_TABLE
446: , p5_a8 JTF_NUMBER_TABLE
447: , p5_a9 JTF_VARCHAR2_TABLE_100
448: , p5_a10 JTF_NUMBER_TABLE
465: , p5_a27 JTF_VARCHAR2_TABLE_500
466: , p5_a28 JTF_NUMBER_TABLE
467: , p5_a29 JTF_NUMBER_TABLE
468: , p5_a30 JTF_NUMBER_TABLE
469: , p5_a31 JTF_DATE_TABLE
470: , p5_a32 JTF_NUMBER_TABLE
471: , p5_a33 JTF_NUMBER_TABLE
472: , p5_a34 JTF_DATE_TABLE
473: , p5_a35 JTF_NUMBER_TABLE
468: , p5_a30 JTF_NUMBER_TABLE
469: , p5_a31 JTF_DATE_TABLE
470: , p5_a32 JTF_NUMBER_TABLE
471: , p5_a33 JTF_NUMBER_TABLE
472: , p5_a34 JTF_DATE_TABLE
473: , p5_a35 JTF_NUMBER_TABLE
474: , p5_a36 JTF_DATE_TABLE
475: , p5_a37 JTF_NUMBER_TABLE
476: , p5_a38 JTF_VARCHAR2_TABLE_100
470: , p5_a32 JTF_NUMBER_TABLE
471: , p5_a33 JTF_NUMBER_TABLE
472: , p5_a34 JTF_DATE_TABLE
473: , p5_a35 JTF_NUMBER_TABLE
474: , p5_a36 JTF_DATE_TABLE
475: , p5_a37 JTF_NUMBER_TABLE
476: , p5_a38 JTF_VARCHAR2_TABLE_100
477: , p5_a39 JTF_VARCHAR2_TABLE_100
478: , p5_a40 JTF_NUMBER_TABLE
475: , p5_a37 JTF_NUMBER_TABLE
476: , p5_a38 JTF_VARCHAR2_TABLE_100
477: , p5_a39 JTF_VARCHAR2_TABLE_100
478: , p5_a40 JTF_NUMBER_TABLE
479: , p5_a41 JTF_DATE_TABLE
480: , p5_a42 JTF_NUMBER_TABLE
481: );
482: procedure update_row(p_api_version NUMBER
483: , p_init_msg_list VARCHAR2
579: , p5_a0 JTF_NUMBER_TABLE
580: , p5_a1 JTF_NUMBER_TABLE
581: , p5_a2 JTF_VARCHAR2_TABLE_100
582: , p5_a3 JTF_VARCHAR2_TABLE_200
583: , p5_a4 JTF_DATE_TABLE
584: , p5_a5 JTF_DATE_TABLE
585: , p5_a6 JTF_DATE_TABLE
586: , p5_a7 JTF_NUMBER_TABLE
587: , p5_a8 JTF_NUMBER_TABLE
580: , p5_a1 JTF_NUMBER_TABLE
581: , p5_a2 JTF_VARCHAR2_TABLE_100
582: , p5_a3 JTF_VARCHAR2_TABLE_200
583: , p5_a4 JTF_DATE_TABLE
584: , p5_a5 JTF_DATE_TABLE
585: , p5_a6 JTF_DATE_TABLE
586: , p5_a7 JTF_NUMBER_TABLE
587: , p5_a8 JTF_NUMBER_TABLE
588: , p5_a9 JTF_VARCHAR2_TABLE_100
581: , p5_a2 JTF_VARCHAR2_TABLE_100
582: , p5_a3 JTF_VARCHAR2_TABLE_200
583: , p5_a4 JTF_DATE_TABLE
584: , p5_a5 JTF_DATE_TABLE
585: , p5_a6 JTF_DATE_TABLE
586: , p5_a7 JTF_NUMBER_TABLE
587: , p5_a8 JTF_NUMBER_TABLE
588: , p5_a9 JTF_VARCHAR2_TABLE_100
589: , p5_a10 JTF_NUMBER_TABLE
606: , p5_a27 JTF_VARCHAR2_TABLE_500
607: , p5_a28 JTF_NUMBER_TABLE
608: , p5_a29 JTF_NUMBER_TABLE
609: , p5_a30 JTF_NUMBER_TABLE
610: , p5_a31 JTF_DATE_TABLE
611: , p5_a32 JTF_NUMBER_TABLE
612: , p5_a33 JTF_NUMBER_TABLE
613: , p5_a34 JTF_DATE_TABLE
614: , p5_a35 JTF_NUMBER_TABLE
609: , p5_a30 JTF_NUMBER_TABLE
610: , p5_a31 JTF_DATE_TABLE
611: , p5_a32 JTF_NUMBER_TABLE
612: , p5_a33 JTF_NUMBER_TABLE
613: , p5_a34 JTF_DATE_TABLE
614: , p5_a35 JTF_NUMBER_TABLE
615: , p5_a36 JTF_DATE_TABLE
616: , p5_a37 JTF_NUMBER_TABLE
617: , p5_a38 JTF_VARCHAR2_TABLE_100
611: , p5_a32 JTF_NUMBER_TABLE
612: , p5_a33 JTF_NUMBER_TABLE
613: , p5_a34 JTF_DATE_TABLE
614: , p5_a35 JTF_NUMBER_TABLE
615: , p5_a36 JTF_DATE_TABLE
616: , p5_a37 JTF_NUMBER_TABLE
617: , p5_a38 JTF_VARCHAR2_TABLE_100
618: , p5_a39 JTF_VARCHAR2_TABLE_100
619: , p5_a40 JTF_NUMBER_TABLE
616: , p5_a37 JTF_NUMBER_TABLE
617: , p5_a38 JTF_VARCHAR2_TABLE_100
618: , p5_a39 JTF_VARCHAR2_TABLE_100
619: , p5_a40 JTF_NUMBER_TABLE
620: , p5_a41 JTF_DATE_TABLE
621: , p5_a42 JTF_NUMBER_TABLE
622: , p6_a0 out nocopy JTF_NUMBER_TABLE
623: , p6_a1 out nocopy JTF_NUMBER_TABLE
624: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
622: , p6_a0 out nocopy JTF_NUMBER_TABLE
623: , p6_a1 out nocopy JTF_NUMBER_TABLE
624: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
625: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
626: , p6_a4 out nocopy JTF_DATE_TABLE
627: , p6_a5 out nocopy JTF_DATE_TABLE
628: , p6_a6 out nocopy JTF_DATE_TABLE
629: , p6_a7 out nocopy JTF_NUMBER_TABLE
630: , p6_a8 out nocopy JTF_NUMBER_TABLE
623: , p6_a1 out nocopy JTF_NUMBER_TABLE
624: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
625: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
626: , p6_a4 out nocopy JTF_DATE_TABLE
627: , p6_a5 out nocopy JTF_DATE_TABLE
628: , p6_a6 out nocopy JTF_DATE_TABLE
629: , p6_a7 out nocopy JTF_NUMBER_TABLE
630: , p6_a8 out nocopy JTF_NUMBER_TABLE
631: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
624: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
625: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
626: , p6_a4 out nocopy JTF_DATE_TABLE
627: , p6_a5 out nocopy JTF_DATE_TABLE
628: , p6_a6 out nocopy JTF_DATE_TABLE
629: , p6_a7 out nocopy JTF_NUMBER_TABLE
630: , p6_a8 out nocopy JTF_NUMBER_TABLE
631: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
632: , p6_a10 out nocopy JTF_NUMBER_TABLE
649: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_500
650: , p6_a28 out nocopy JTF_NUMBER_TABLE
651: , p6_a29 out nocopy JTF_NUMBER_TABLE
652: , p6_a30 out nocopy JTF_NUMBER_TABLE
653: , p6_a31 out nocopy JTF_DATE_TABLE
654: , p6_a32 out nocopy JTF_NUMBER_TABLE
655: , p6_a33 out nocopy JTF_NUMBER_TABLE
656: , p6_a34 out nocopy JTF_DATE_TABLE
657: , p6_a35 out nocopy JTF_NUMBER_TABLE
652: , p6_a30 out nocopy JTF_NUMBER_TABLE
653: , p6_a31 out nocopy JTF_DATE_TABLE
654: , p6_a32 out nocopy JTF_NUMBER_TABLE
655: , p6_a33 out nocopy JTF_NUMBER_TABLE
656: , p6_a34 out nocopy JTF_DATE_TABLE
657: , p6_a35 out nocopy JTF_NUMBER_TABLE
658: , p6_a36 out nocopy JTF_DATE_TABLE
659: , p6_a37 out nocopy JTF_NUMBER_TABLE
660: , p6_a38 out nocopy JTF_VARCHAR2_TABLE_100
654: , p6_a32 out nocopy JTF_NUMBER_TABLE
655: , p6_a33 out nocopy JTF_NUMBER_TABLE
656: , p6_a34 out nocopy JTF_DATE_TABLE
657: , p6_a35 out nocopy JTF_NUMBER_TABLE
658: , p6_a36 out nocopy JTF_DATE_TABLE
659: , p6_a37 out nocopy JTF_NUMBER_TABLE
660: , p6_a38 out nocopy JTF_VARCHAR2_TABLE_100
661: , p6_a39 out nocopy JTF_VARCHAR2_TABLE_100
662: , p6_a40 out nocopy JTF_NUMBER_TABLE
659: , p6_a37 out nocopy JTF_NUMBER_TABLE
660: , p6_a38 out nocopy JTF_VARCHAR2_TABLE_100
661: , p6_a39 out nocopy JTF_VARCHAR2_TABLE_100
662: , p6_a40 out nocopy JTF_NUMBER_TABLE
663: , p6_a41 out nocopy JTF_DATE_TABLE
664: , p6_a42 out nocopy JTF_NUMBER_TABLE
665: );
666: procedure delete_row(p_api_version NUMBER
667: , p_init_msg_list VARCHAR2
720: , p5_a0 JTF_NUMBER_TABLE
721: , p5_a1 JTF_NUMBER_TABLE
722: , p5_a2 JTF_VARCHAR2_TABLE_100
723: , p5_a3 JTF_VARCHAR2_TABLE_200
724: , p5_a4 JTF_DATE_TABLE
725: , p5_a5 JTF_DATE_TABLE
726: , p5_a6 JTF_DATE_TABLE
727: , p5_a7 JTF_NUMBER_TABLE
728: , p5_a8 JTF_NUMBER_TABLE
721: , p5_a1 JTF_NUMBER_TABLE
722: , p5_a2 JTF_VARCHAR2_TABLE_100
723: , p5_a3 JTF_VARCHAR2_TABLE_200
724: , p5_a4 JTF_DATE_TABLE
725: , p5_a5 JTF_DATE_TABLE
726: , p5_a6 JTF_DATE_TABLE
727: , p5_a7 JTF_NUMBER_TABLE
728: , p5_a8 JTF_NUMBER_TABLE
729: , p5_a9 JTF_VARCHAR2_TABLE_100
722: , p5_a2 JTF_VARCHAR2_TABLE_100
723: , p5_a3 JTF_VARCHAR2_TABLE_200
724: , p5_a4 JTF_DATE_TABLE
725: , p5_a5 JTF_DATE_TABLE
726: , p5_a6 JTF_DATE_TABLE
727: , p5_a7 JTF_NUMBER_TABLE
728: , p5_a8 JTF_NUMBER_TABLE
729: , p5_a9 JTF_VARCHAR2_TABLE_100
730: , p5_a10 JTF_NUMBER_TABLE
747: , p5_a27 JTF_VARCHAR2_TABLE_500
748: , p5_a28 JTF_NUMBER_TABLE
749: , p5_a29 JTF_NUMBER_TABLE
750: , p5_a30 JTF_NUMBER_TABLE
751: , p5_a31 JTF_DATE_TABLE
752: , p5_a32 JTF_NUMBER_TABLE
753: , p5_a33 JTF_NUMBER_TABLE
754: , p5_a34 JTF_DATE_TABLE
755: , p5_a35 JTF_NUMBER_TABLE
750: , p5_a30 JTF_NUMBER_TABLE
751: , p5_a31 JTF_DATE_TABLE
752: , p5_a32 JTF_NUMBER_TABLE
753: , p5_a33 JTF_NUMBER_TABLE
754: , p5_a34 JTF_DATE_TABLE
755: , p5_a35 JTF_NUMBER_TABLE
756: , p5_a36 JTF_DATE_TABLE
757: , p5_a37 JTF_NUMBER_TABLE
758: , p5_a38 JTF_VARCHAR2_TABLE_100
752: , p5_a32 JTF_NUMBER_TABLE
753: , p5_a33 JTF_NUMBER_TABLE
754: , p5_a34 JTF_DATE_TABLE
755: , p5_a35 JTF_NUMBER_TABLE
756: , p5_a36 JTF_DATE_TABLE
757: , p5_a37 JTF_NUMBER_TABLE
758: , p5_a38 JTF_VARCHAR2_TABLE_100
759: , p5_a39 JTF_VARCHAR2_TABLE_100
760: , p5_a40 JTF_NUMBER_TABLE
757: , p5_a37 JTF_NUMBER_TABLE
758: , p5_a38 JTF_VARCHAR2_TABLE_100
759: , p5_a39 JTF_VARCHAR2_TABLE_100
760: , p5_a40 JTF_NUMBER_TABLE
761: , p5_a41 JTF_DATE_TABLE
762: , p5_a42 JTF_NUMBER_TABLE
763: );
764: procedure validate_row(p_api_version NUMBER
765: , p_init_msg_list VARCHAR2
818: , p5_a0 JTF_NUMBER_TABLE
819: , p5_a1 JTF_NUMBER_TABLE
820: , p5_a2 JTF_VARCHAR2_TABLE_100
821: , p5_a3 JTF_VARCHAR2_TABLE_200
822: , p5_a4 JTF_DATE_TABLE
823: , p5_a5 JTF_DATE_TABLE
824: , p5_a6 JTF_DATE_TABLE
825: , p5_a7 JTF_NUMBER_TABLE
826: , p5_a8 JTF_NUMBER_TABLE
819: , p5_a1 JTF_NUMBER_TABLE
820: , p5_a2 JTF_VARCHAR2_TABLE_100
821: , p5_a3 JTF_VARCHAR2_TABLE_200
822: , p5_a4 JTF_DATE_TABLE
823: , p5_a5 JTF_DATE_TABLE
824: , p5_a6 JTF_DATE_TABLE
825: , p5_a7 JTF_NUMBER_TABLE
826: , p5_a8 JTF_NUMBER_TABLE
827: , p5_a9 JTF_VARCHAR2_TABLE_100
820: , p5_a2 JTF_VARCHAR2_TABLE_100
821: , p5_a3 JTF_VARCHAR2_TABLE_200
822: , p5_a4 JTF_DATE_TABLE
823: , p5_a5 JTF_DATE_TABLE
824: , p5_a6 JTF_DATE_TABLE
825: , p5_a7 JTF_NUMBER_TABLE
826: , p5_a8 JTF_NUMBER_TABLE
827: , p5_a9 JTF_VARCHAR2_TABLE_100
828: , p5_a10 JTF_NUMBER_TABLE
845: , p5_a27 JTF_VARCHAR2_TABLE_500
846: , p5_a28 JTF_NUMBER_TABLE
847: , p5_a29 JTF_NUMBER_TABLE
848: , p5_a30 JTF_NUMBER_TABLE
849: , p5_a31 JTF_DATE_TABLE
850: , p5_a32 JTF_NUMBER_TABLE
851: , p5_a33 JTF_NUMBER_TABLE
852: , p5_a34 JTF_DATE_TABLE
853: , p5_a35 JTF_NUMBER_TABLE
848: , p5_a30 JTF_NUMBER_TABLE
849: , p5_a31 JTF_DATE_TABLE
850: , p5_a32 JTF_NUMBER_TABLE
851: , p5_a33 JTF_NUMBER_TABLE
852: , p5_a34 JTF_DATE_TABLE
853: , p5_a35 JTF_NUMBER_TABLE
854: , p5_a36 JTF_DATE_TABLE
855: , p5_a37 JTF_NUMBER_TABLE
856: , p5_a38 JTF_VARCHAR2_TABLE_100
850: , p5_a32 JTF_NUMBER_TABLE
851: , p5_a33 JTF_NUMBER_TABLE
852: , p5_a34 JTF_DATE_TABLE
853: , p5_a35 JTF_NUMBER_TABLE
854: , p5_a36 JTF_DATE_TABLE
855: , p5_a37 JTF_NUMBER_TABLE
856: , p5_a38 JTF_VARCHAR2_TABLE_100
857: , p5_a39 JTF_VARCHAR2_TABLE_100
858: , p5_a40 JTF_NUMBER_TABLE
855: , p5_a37 JTF_NUMBER_TABLE
856: , p5_a38 JTF_VARCHAR2_TABLE_100
857: , p5_a39 JTF_VARCHAR2_TABLE_100
858: , p5_a40 JTF_NUMBER_TABLE
859: , p5_a41 JTF_DATE_TABLE
860: , p5_a42 JTF_NUMBER_TABLE
861: );
862: end okl_btc_pvt_w;