1: package okl_gtt_pvt_w as
2: /* $Header: OKLIGTTS.pls 120.1 2005/10/30 04:00:54 appldev noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_gtt_pvt.gtt_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_DATE_TABLE
1: package okl_gtt_pvt_w as
2: /* $Header: OKLIGTTS.pls 120.1 2005/10/30 04:00:54 appldev noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_gtt_pvt.gtt_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_DATE_TABLE
8: , a5 JTF_DATE_TABLE
1: package okl_gtt_pvt_w as
2: /* $Header: OKLIGTTS.pls 120.1 2005/10/30 04:00:54 appldev noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_gtt_pvt.gtt_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_DATE_TABLE
8: , a5 JTF_DATE_TABLE
9: , a6 JTF_VARCHAR2_TABLE_100
22: , a19 JTF_VARCHAR2_TABLE_500
23: , a20 JTF_VARCHAR2_TABLE_500
24: , a21 JTF_VARCHAR2_TABLE_500
25: , a22 JTF_VARCHAR2_TABLE_500
26: , a23 JTF_NUMBER_TABLE
27: , a24 JTF_NUMBER_TABLE
28: , a25 JTF_DATE_TABLE
29: , a26 JTF_NUMBER_TABLE
30: , a27 JTF_DATE_TABLE
23: , a20 JTF_VARCHAR2_TABLE_500
24: , a21 JTF_VARCHAR2_TABLE_500
25: , a22 JTF_VARCHAR2_TABLE_500
26: , a23 JTF_NUMBER_TABLE
27: , a24 JTF_NUMBER_TABLE
28: , a25 JTF_DATE_TABLE
29: , a26 JTF_NUMBER_TABLE
30: , a27 JTF_DATE_TABLE
31: , a28 JTF_NUMBER_TABLE
25: , a22 JTF_VARCHAR2_TABLE_500
26: , a23 JTF_NUMBER_TABLE
27: , a24 JTF_NUMBER_TABLE
28: , a25 JTF_DATE_TABLE
29: , a26 JTF_NUMBER_TABLE
30: , a27 JTF_DATE_TABLE
31: , a28 JTF_NUMBER_TABLE
32: );
33: procedure rosetta_table_copy_out_p2(t okl_gtt_pvt.gtt_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
27: , a24 JTF_NUMBER_TABLE
28: , a25 JTF_DATE_TABLE
29: , a26 JTF_NUMBER_TABLE
30: , a27 JTF_DATE_TABLE
31: , a28 JTF_NUMBER_TABLE
32: );
33: procedure rosetta_table_copy_out_p2(t okl_gtt_pvt.gtt_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
34: , a1 out nocopy JTF_NUMBER_TABLE
35: , a2 out nocopy JTF_NUMBER_TABLE
29: , a26 JTF_NUMBER_TABLE
30: , a27 JTF_DATE_TABLE
31: , a28 JTF_NUMBER_TABLE
32: );
33: procedure rosetta_table_copy_out_p2(t okl_gtt_pvt.gtt_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
34: , a1 out nocopy JTF_NUMBER_TABLE
35: , a2 out nocopy JTF_NUMBER_TABLE
36: , a3 out nocopy JTF_VARCHAR2_TABLE_100
37: , a4 out nocopy JTF_DATE_TABLE
30: , a27 JTF_DATE_TABLE
31: , a28 JTF_NUMBER_TABLE
32: );
33: procedure rosetta_table_copy_out_p2(t okl_gtt_pvt.gtt_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
34: , a1 out nocopy JTF_NUMBER_TABLE
35: , a2 out nocopy JTF_NUMBER_TABLE
36: , a3 out nocopy JTF_VARCHAR2_TABLE_100
37: , a4 out nocopy JTF_DATE_TABLE
38: , a5 out nocopy JTF_DATE_TABLE
31: , a28 JTF_NUMBER_TABLE
32: );
33: procedure rosetta_table_copy_out_p2(t okl_gtt_pvt.gtt_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
34: , a1 out nocopy JTF_NUMBER_TABLE
35: , a2 out nocopy JTF_NUMBER_TABLE
36: , a3 out nocopy JTF_VARCHAR2_TABLE_100
37: , a4 out nocopy JTF_DATE_TABLE
38: , a5 out nocopy JTF_DATE_TABLE
39: , a6 out nocopy JTF_VARCHAR2_TABLE_100
52: , a19 out nocopy JTF_VARCHAR2_TABLE_500
53: , a20 out nocopy JTF_VARCHAR2_TABLE_500
54: , a21 out nocopy JTF_VARCHAR2_TABLE_500
55: , a22 out nocopy JTF_VARCHAR2_TABLE_500
56: , a23 out nocopy JTF_NUMBER_TABLE
57: , a24 out nocopy JTF_NUMBER_TABLE
58: , a25 out nocopy JTF_DATE_TABLE
59: , a26 out nocopy JTF_NUMBER_TABLE
60: , a27 out nocopy JTF_DATE_TABLE
53: , a20 out nocopy JTF_VARCHAR2_TABLE_500
54: , a21 out nocopy JTF_VARCHAR2_TABLE_500
55: , a22 out nocopy JTF_VARCHAR2_TABLE_500
56: , a23 out nocopy JTF_NUMBER_TABLE
57: , a24 out nocopy JTF_NUMBER_TABLE
58: , a25 out nocopy JTF_DATE_TABLE
59: , a26 out nocopy JTF_NUMBER_TABLE
60: , a27 out nocopy JTF_DATE_TABLE
61: , a28 out nocopy JTF_NUMBER_TABLE
55: , a22 out nocopy JTF_VARCHAR2_TABLE_500
56: , a23 out nocopy JTF_NUMBER_TABLE
57: , a24 out nocopy JTF_NUMBER_TABLE
58: , a25 out nocopy JTF_DATE_TABLE
59: , a26 out nocopy JTF_NUMBER_TABLE
60: , a27 out nocopy JTF_DATE_TABLE
61: , a28 out nocopy JTF_NUMBER_TABLE
62: );
63:
57: , a24 out nocopy JTF_NUMBER_TABLE
58: , a25 out nocopy JTF_DATE_TABLE
59: , a26 out nocopy JTF_NUMBER_TABLE
60: , a27 out nocopy JTF_DATE_TABLE
61: , a28 out nocopy JTF_NUMBER_TABLE
62: );
63:
64: procedure rosetta_table_copy_in_p5(t out nocopy okl_gtt_pvt.gttv_tbl_type, a0 JTF_NUMBER_TABLE
65: , a1 JTF_NUMBER_TABLE
60: , a27 out nocopy JTF_DATE_TABLE
61: , a28 out nocopy JTF_NUMBER_TABLE
62: );
63:
64: procedure rosetta_table_copy_in_p5(t out nocopy okl_gtt_pvt.gttv_tbl_type, a0 JTF_NUMBER_TABLE
65: , a1 JTF_NUMBER_TABLE
66: , a2 JTF_NUMBER_TABLE
67: , a3 JTF_VARCHAR2_TABLE_100
68: , a4 JTF_DATE_TABLE
61: , a28 out nocopy JTF_NUMBER_TABLE
62: );
63:
64: procedure rosetta_table_copy_in_p5(t out nocopy okl_gtt_pvt.gttv_tbl_type, a0 JTF_NUMBER_TABLE
65: , a1 JTF_NUMBER_TABLE
66: , a2 JTF_NUMBER_TABLE
67: , a3 JTF_VARCHAR2_TABLE_100
68: , a4 JTF_DATE_TABLE
69: , a5 JTF_DATE_TABLE
62: );
63:
64: procedure rosetta_table_copy_in_p5(t out nocopy okl_gtt_pvt.gttv_tbl_type, a0 JTF_NUMBER_TABLE
65: , a1 JTF_NUMBER_TABLE
66: , a2 JTF_NUMBER_TABLE
67: , a3 JTF_VARCHAR2_TABLE_100
68: , a4 JTF_DATE_TABLE
69: , a5 JTF_DATE_TABLE
70: , a6 JTF_VARCHAR2_TABLE_100
83: , a19 JTF_VARCHAR2_TABLE_500
84: , a20 JTF_VARCHAR2_TABLE_500
85: , a21 JTF_VARCHAR2_TABLE_500
86: , a22 JTF_VARCHAR2_TABLE_500
87: , a23 JTF_NUMBER_TABLE
88: , a24 JTF_NUMBER_TABLE
89: , a25 JTF_DATE_TABLE
90: , a26 JTF_NUMBER_TABLE
91: , a27 JTF_DATE_TABLE
84: , a20 JTF_VARCHAR2_TABLE_500
85: , a21 JTF_VARCHAR2_TABLE_500
86: , a22 JTF_VARCHAR2_TABLE_500
87: , a23 JTF_NUMBER_TABLE
88: , a24 JTF_NUMBER_TABLE
89: , a25 JTF_DATE_TABLE
90: , a26 JTF_NUMBER_TABLE
91: , a27 JTF_DATE_TABLE
92: , a28 JTF_NUMBER_TABLE
86: , a22 JTF_VARCHAR2_TABLE_500
87: , a23 JTF_NUMBER_TABLE
88: , a24 JTF_NUMBER_TABLE
89: , a25 JTF_DATE_TABLE
90: , a26 JTF_NUMBER_TABLE
91: , a27 JTF_DATE_TABLE
92: , a28 JTF_NUMBER_TABLE
93: );
94: procedure rosetta_table_copy_out_p5(t okl_gtt_pvt.gttv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
88: , a24 JTF_NUMBER_TABLE
89: , a25 JTF_DATE_TABLE
90: , a26 JTF_NUMBER_TABLE
91: , a27 JTF_DATE_TABLE
92: , a28 JTF_NUMBER_TABLE
93: );
94: procedure rosetta_table_copy_out_p5(t okl_gtt_pvt.gttv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
95: , a1 out nocopy JTF_NUMBER_TABLE
96: , a2 out nocopy JTF_NUMBER_TABLE
90: , a26 JTF_NUMBER_TABLE
91: , a27 JTF_DATE_TABLE
92: , a28 JTF_NUMBER_TABLE
93: );
94: procedure rosetta_table_copy_out_p5(t okl_gtt_pvt.gttv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
95: , a1 out nocopy JTF_NUMBER_TABLE
96: , a2 out nocopy JTF_NUMBER_TABLE
97: , a3 out nocopy JTF_VARCHAR2_TABLE_100
98: , a4 out nocopy JTF_DATE_TABLE
91: , a27 JTF_DATE_TABLE
92: , a28 JTF_NUMBER_TABLE
93: );
94: procedure rosetta_table_copy_out_p5(t okl_gtt_pvt.gttv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
95: , a1 out nocopy JTF_NUMBER_TABLE
96: , a2 out nocopy JTF_NUMBER_TABLE
97: , a3 out nocopy JTF_VARCHAR2_TABLE_100
98: , a4 out nocopy JTF_DATE_TABLE
99: , a5 out nocopy JTF_DATE_TABLE
92: , a28 JTF_NUMBER_TABLE
93: );
94: procedure rosetta_table_copy_out_p5(t okl_gtt_pvt.gttv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
95: , a1 out nocopy JTF_NUMBER_TABLE
96: , a2 out nocopy JTF_NUMBER_TABLE
97: , a3 out nocopy JTF_VARCHAR2_TABLE_100
98: , a4 out nocopy JTF_DATE_TABLE
99: , a5 out nocopy JTF_DATE_TABLE
100: , a6 out nocopy JTF_VARCHAR2_TABLE_100
113: , a19 out nocopy JTF_VARCHAR2_TABLE_500
114: , a20 out nocopy JTF_VARCHAR2_TABLE_500
115: , a21 out nocopy JTF_VARCHAR2_TABLE_500
116: , a22 out nocopy JTF_VARCHAR2_TABLE_500
117: , a23 out nocopy JTF_NUMBER_TABLE
118: , a24 out nocopy JTF_NUMBER_TABLE
119: , a25 out nocopy JTF_DATE_TABLE
120: , a26 out nocopy JTF_NUMBER_TABLE
121: , a27 out nocopy JTF_DATE_TABLE
114: , a20 out nocopy JTF_VARCHAR2_TABLE_500
115: , a21 out nocopy JTF_VARCHAR2_TABLE_500
116: , a22 out nocopy JTF_VARCHAR2_TABLE_500
117: , a23 out nocopy JTF_NUMBER_TABLE
118: , a24 out nocopy JTF_NUMBER_TABLE
119: , a25 out nocopy JTF_DATE_TABLE
120: , a26 out nocopy JTF_NUMBER_TABLE
121: , a27 out nocopy JTF_DATE_TABLE
122: , a28 out nocopy JTF_NUMBER_TABLE
116: , a22 out nocopy JTF_VARCHAR2_TABLE_500
117: , a23 out nocopy JTF_NUMBER_TABLE
118: , a24 out nocopy JTF_NUMBER_TABLE
119: , a25 out nocopy JTF_DATE_TABLE
120: , a26 out nocopy JTF_NUMBER_TABLE
121: , a27 out nocopy JTF_DATE_TABLE
122: , a28 out nocopy JTF_NUMBER_TABLE
123: );
124:
118: , a24 out nocopy JTF_NUMBER_TABLE
119: , a25 out nocopy JTF_DATE_TABLE
120: , a26 out nocopy JTF_NUMBER_TABLE
121: , a27 out nocopy JTF_DATE_TABLE
122: , a28 out nocopy JTF_NUMBER_TABLE
123: );
124:
125: procedure insert_row(p_api_version NUMBER
126: , p_init_msg_list VARCHAR2
190: , p_init_msg_list VARCHAR2
191: , x_return_status out nocopy VARCHAR2
192: , x_msg_count out nocopy NUMBER
193: , x_msg_data out nocopy VARCHAR2
194: , p5_a0 JTF_NUMBER_TABLE
195: , p5_a1 JTF_NUMBER_TABLE
196: , p5_a2 JTF_NUMBER_TABLE
197: , p5_a3 JTF_VARCHAR2_TABLE_100
198: , p5_a4 JTF_DATE_TABLE
191: , x_return_status out nocopy VARCHAR2
192: , x_msg_count out nocopy NUMBER
193: , x_msg_data out nocopy VARCHAR2
194: , p5_a0 JTF_NUMBER_TABLE
195: , p5_a1 JTF_NUMBER_TABLE
196: , p5_a2 JTF_NUMBER_TABLE
197: , p5_a3 JTF_VARCHAR2_TABLE_100
198: , p5_a4 JTF_DATE_TABLE
199: , p5_a5 JTF_DATE_TABLE
192: , x_msg_count out nocopy NUMBER
193: , x_msg_data out nocopy VARCHAR2
194: , p5_a0 JTF_NUMBER_TABLE
195: , p5_a1 JTF_NUMBER_TABLE
196: , p5_a2 JTF_NUMBER_TABLE
197: , p5_a3 JTF_VARCHAR2_TABLE_100
198: , p5_a4 JTF_DATE_TABLE
199: , p5_a5 JTF_DATE_TABLE
200: , p5_a6 JTF_VARCHAR2_TABLE_100
213: , p5_a19 JTF_VARCHAR2_TABLE_500
214: , p5_a20 JTF_VARCHAR2_TABLE_500
215: , p5_a21 JTF_VARCHAR2_TABLE_500
216: , p5_a22 JTF_VARCHAR2_TABLE_500
217: , p5_a23 JTF_NUMBER_TABLE
218: , p5_a24 JTF_NUMBER_TABLE
219: , p5_a25 JTF_DATE_TABLE
220: , p5_a26 JTF_NUMBER_TABLE
221: , p5_a27 JTF_DATE_TABLE
214: , p5_a20 JTF_VARCHAR2_TABLE_500
215: , p5_a21 JTF_VARCHAR2_TABLE_500
216: , p5_a22 JTF_VARCHAR2_TABLE_500
217: , p5_a23 JTF_NUMBER_TABLE
218: , p5_a24 JTF_NUMBER_TABLE
219: , p5_a25 JTF_DATE_TABLE
220: , p5_a26 JTF_NUMBER_TABLE
221: , p5_a27 JTF_DATE_TABLE
222: , p5_a28 JTF_NUMBER_TABLE
216: , p5_a22 JTF_VARCHAR2_TABLE_500
217: , p5_a23 JTF_NUMBER_TABLE
218: , p5_a24 JTF_NUMBER_TABLE
219: , p5_a25 JTF_DATE_TABLE
220: , p5_a26 JTF_NUMBER_TABLE
221: , p5_a27 JTF_DATE_TABLE
222: , p5_a28 JTF_NUMBER_TABLE
223: , p6_a0 out nocopy JTF_NUMBER_TABLE
224: , p6_a1 out nocopy JTF_NUMBER_TABLE
218: , p5_a24 JTF_NUMBER_TABLE
219: , p5_a25 JTF_DATE_TABLE
220: , p5_a26 JTF_NUMBER_TABLE
221: , p5_a27 JTF_DATE_TABLE
222: , p5_a28 JTF_NUMBER_TABLE
223: , p6_a0 out nocopy JTF_NUMBER_TABLE
224: , p6_a1 out nocopy JTF_NUMBER_TABLE
225: , p6_a2 out nocopy JTF_NUMBER_TABLE
226: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
219: , p5_a25 JTF_DATE_TABLE
220: , p5_a26 JTF_NUMBER_TABLE
221: , p5_a27 JTF_DATE_TABLE
222: , p5_a28 JTF_NUMBER_TABLE
223: , p6_a0 out nocopy JTF_NUMBER_TABLE
224: , p6_a1 out nocopy JTF_NUMBER_TABLE
225: , p6_a2 out nocopy JTF_NUMBER_TABLE
226: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
227: , p6_a4 out nocopy JTF_DATE_TABLE
220: , p5_a26 JTF_NUMBER_TABLE
221: , p5_a27 JTF_DATE_TABLE
222: , p5_a28 JTF_NUMBER_TABLE
223: , p6_a0 out nocopy JTF_NUMBER_TABLE
224: , p6_a1 out nocopy JTF_NUMBER_TABLE
225: , p6_a2 out nocopy JTF_NUMBER_TABLE
226: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
227: , p6_a4 out nocopy JTF_DATE_TABLE
228: , p6_a5 out nocopy JTF_DATE_TABLE
221: , p5_a27 JTF_DATE_TABLE
222: , p5_a28 JTF_NUMBER_TABLE
223: , p6_a0 out nocopy JTF_NUMBER_TABLE
224: , p6_a1 out nocopy JTF_NUMBER_TABLE
225: , p6_a2 out nocopy JTF_NUMBER_TABLE
226: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
227: , p6_a4 out nocopy JTF_DATE_TABLE
228: , p6_a5 out nocopy JTF_DATE_TABLE
229: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
242: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_500
243: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
244: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
245: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
246: , p6_a23 out nocopy JTF_NUMBER_TABLE
247: , p6_a24 out nocopy JTF_NUMBER_TABLE
248: , p6_a25 out nocopy JTF_DATE_TABLE
249: , p6_a26 out nocopy JTF_NUMBER_TABLE
250: , p6_a27 out nocopy JTF_DATE_TABLE
243: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
244: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
245: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
246: , p6_a23 out nocopy JTF_NUMBER_TABLE
247: , p6_a24 out nocopy JTF_NUMBER_TABLE
248: , p6_a25 out nocopy JTF_DATE_TABLE
249: , p6_a26 out nocopy JTF_NUMBER_TABLE
250: , p6_a27 out nocopy JTF_DATE_TABLE
251: , p6_a28 out nocopy JTF_NUMBER_TABLE
245: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
246: , p6_a23 out nocopy JTF_NUMBER_TABLE
247: , p6_a24 out nocopy JTF_NUMBER_TABLE
248: , p6_a25 out nocopy JTF_DATE_TABLE
249: , p6_a26 out nocopy JTF_NUMBER_TABLE
250: , p6_a27 out nocopy JTF_DATE_TABLE
251: , p6_a28 out nocopy JTF_NUMBER_TABLE
252: );
253: procedure update_row(p_api_version NUMBER
247: , p6_a24 out nocopy JTF_NUMBER_TABLE
248: , p6_a25 out nocopy JTF_DATE_TABLE
249: , p6_a26 out nocopy JTF_NUMBER_TABLE
250: , p6_a27 out nocopy JTF_DATE_TABLE
251: , p6_a28 out nocopy JTF_NUMBER_TABLE
252: );
253: procedure update_row(p_api_version NUMBER
254: , p_init_msg_list VARCHAR2
255: , x_return_status out nocopy VARCHAR2
318: , p_init_msg_list VARCHAR2
319: , x_return_status out nocopy VARCHAR2
320: , x_msg_count out nocopy NUMBER
321: , x_msg_data out nocopy VARCHAR2
322: , p5_a0 JTF_NUMBER_TABLE
323: , p5_a1 JTF_NUMBER_TABLE
324: , p5_a2 JTF_NUMBER_TABLE
325: , p5_a3 JTF_VARCHAR2_TABLE_100
326: , p5_a4 JTF_DATE_TABLE
319: , x_return_status out nocopy VARCHAR2
320: , x_msg_count out nocopy NUMBER
321: , x_msg_data out nocopy VARCHAR2
322: , p5_a0 JTF_NUMBER_TABLE
323: , p5_a1 JTF_NUMBER_TABLE
324: , p5_a2 JTF_NUMBER_TABLE
325: , p5_a3 JTF_VARCHAR2_TABLE_100
326: , p5_a4 JTF_DATE_TABLE
327: , p5_a5 JTF_DATE_TABLE
320: , x_msg_count out nocopy NUMBER
321: , x_msg_data out nocopy VARCHAR2
322: , p5_a0 JTF_NUMBER_TABLE
323: , p5_a1 JTF_NUMBER_TABLE
324: , p5_a2 JTF_NUMBER_TABLE
325: , p5_a3 JTF_VARCHAR2_TABLE_100
326: , p5_a4 JTF_DATE_TABLE
327: , p5_a5 JTF_DATE_TABLE
328: , p5_a6 JTF_VARCHAR2_TABLE_100
341: , p5_a19 JTF_VARCHAR2_TABLE_500
342: , p5_a20 JTF_VARCHAR2_TABLE_500
343: , p5_a21 JTF_VARCHAR2_TABLE_500
344: , p5_a22 JTF_VARCHAR2_TABLE_500
345: , p5_a23 JTF_NUMBER_TABLE
346: , p5_a24 JTF_NUMBER_TABLE
347: , p5_a25 JTF_DATE_TABLE
348: , p5_a26 JTF_NUMBER_TABLE
349: , p5_a27 JTF_DATE_TABLE
342: , p5_a20 JTF_VARCHAR2_TABLE_500
343: , p5_a21 JTF_VARCHAR2_TABLE_500
344: , p5_a22 JTF_VARCHAR2_TABLE_500
345: , p5_a23 JTF_NUMBER_TABLE
346: , p5_a24 JTF_NUMBER_TABLE
347: , p5_a25 JTF_DATE_TABLE
348: , p5_a26 JTF_NUMBER_TABLE
349: , p5_a27 JTF_DATE_TABLE
350: , p5_a28 JTF_NUMBER_TABLE
344: , p5_a22 JTF_VARCHAR2_TABLE_500
345: , p5_a23 JTF_NUMBER_TABLE
346: , p5_a24 JTF_NUMBER_TABLE
347: , p5_a25 JTF_DATE_TABLE
348: , p5_a26 JTF_NUMBER_TABLE
349: , p5_a27 JTF_DATE_TABLE
350: , p5_a28 JTF_NUMBER_TABLE
351: , p6_a0 out nocopy JTF_NUMBER_TABLE
352: , p6_a1 out nocopy JTF_NUMBER_TABLE
346: , p5_a24 JTF_NUMBER_TABLE
347: , p5_a25 JTF_DATE_TABLE
348: , p5_a26 JTF_NUMBER_TABLE
349: , p5_a27 JTF_DATE_TABLE
350: , p5_a28 JTF_NUMBER_TABLE
351: , p6_a0 out nocopy JTF_NUMBER_TABLE
352: , p6_a1 out nocopy JTF_NUMBER_TABLE
353: , p6_a2 out nocopy JTF_NUMBER_TABLE
354: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
347: , p5_a25 JTF_DATE_TABLE
348: , p5_a26 JTF_NUMBER_TABLE
349: , p5_a27 JTF_DATE_TABLE
350: , p5_a28 JTF_NUMBER_TABLE
351: , p6_a0 out nocopy JTF_NUMBER_TABLE
352: , p6_a1 out nocopy JTF_NUMBER_TABLE
353: , p6_a2 out nocopy JTF_NUMBER_TABLE
354: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
355: , p6_a4 out nocopy JTF_DATE_TABLE
348: , p5_a26 JTF_NUMBER_TABLE
349: , p5_a27 JTF_DATE_TABLE
350: , p5_a28 JTF_NUMBER_TABLE
351: , p6_a0 out nocopy JTF_NUMBER_TABLE
352: , p6_a1 out nocopy JTF_NUMBER_TABLE
353: , p6_a2 out nocopy JTF_NUMBER_TABLE
354: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
355: , p6_a4 out nocopy JTF_DATE_TABLE
356: , p6_a5 out nocopy JTF_DATE_TABLE
349: , p5_a27 JTF_DATE_TABLE
350: , p5_a28 JTF_NUMBER_TABLE
351: , p6_a0 out nocopy JTF_NUMBER_TABLE
352: , p6_a1 out nocopy JTF_NUMBER_TABLE
353: , p6_a2 out nocopy JTF_NUMBER_TABLE
354: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
355: , p6_a4 out nocopy JTF_DATE_TABLE
356: , p6_a5 out nocopy JTF_DATE_TABLE
357: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
370: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_500
371: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
372: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
373: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
374: , p6_a23 out nocopy JTF_NUMBER_TABLE
375: , p6_a24 out nocopy JTF_NUMBER_TABLE
376: , p6_a25 out nocopy JTF_DATE_TABLE
377: , p6_a26 out nocopy JTF_NUMBER_TABLE
378: , p6_a27 out nocopy JTF_DATE_TABLE
371: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
372: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
373: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
374: , p6_a23 out nocopy JTF_NUMBER_TABLE
375: , p6_a24 out nocopy JTF_NUMBER_TABLE
376: , p6_a25 out nocopy JTF_DATE_TABLE
377: , p6_a26 out nocopy JTF_NUMBER_TABLE
378: , p6_a27 out nocopy JTF_DATE_TABLE
379: , p6_a28 out nocopy JTF_NUMBER_TABLE
373: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
374: , p6_a23 out nocopy JTF_NUMBER_TABLE
375: , p6_a24 out nocopy JTF_NUMBER_TABLE
376: , p6_a25 out nocopy JTF_DATE_TABLE
377: , p6_a26 out nocopy JTF_NUMBER_TABLE
378: , p6_a27 out nocopy JTF_DATE_TABLE
379: , p6_a28 out nocopy JTF_NUMBER_TABLE
380: );
381: procedure delete_row(p_api_version NUMBER
375: , p6_a24 out nocopy JTF_NUMBER_TABLE
376: , p6_a25 out nocopy JTF_DATE_TABLE
377: , p6_a26 out nocopy JTF_NUMBER_TABLE
378: , p6_a27 out nocopy JTF_DATE_TABLE
379: , p6_a28 out nocopy JTF_NUMBER_TABLE
380: );
381: procedure delete_row(p_api_version NUMBER
382: , p_init_msg_list VARCHAR2
383: , x_return_status out nocopy VARCHAR2
417: , p_init_msg_list VARCHAR2
418: , x_return_status out nocopy VARCHAR2
419: , x_msg_count out nocopy NUMBER
420: , x_msg_data out nocopy VARCHAR2
421: , p5_a0 JTF_NUMBER_TABLE
422: , p5_a1 JTF_NUMBER_TABLE
423: , p5_a2 JTF_NUMBER_TABLE
424: , p5_a3 JTF_VARCHAR2_TABLE_100
425: , p5_a4 JTF_DATE_TABLE
418: , x_return_status out nocopy VARCHAR2
419: , x_msg_count out nocopy NUMBER
420: , x_msg_data out nocopy VARCHAR2
421: , p5_a0 JTF_NUMBER_TABLE
422: , p5_a1 JTF_NUMBER_TABLE
423: , p5_a2 JTF_NUMBER_TABLE
424: , p5_a3 JTF_VARCHAR2_TABLE_100
425: , p5_a4 JTF_DATE_TABLE
426: , p5_a5 JTF_DATE_TABLE
419: , x_msg_count out nocopy NUMBER
420: , x_msg_data out nocopy VARCHAR2
421: , p5_a0 JTF_NUMBER_TABLE
422: , p5_a1 JTF_NUMBER_TABLE
423: , p5_a2 JTF_NUMBER_TABLE
424: , p5_a3 JTF_VARCHAR2_TABLE_100
425: , p5_a4 JTF_DATE_TABLE
426: , p5_a5 JTF_DATE_TABLE
427: , p5_a6 JTF_VARCHAR2_TABLE_100
440: , p5_a19 JTF_VARCHAR2_TABLE_500
441: , p5_a20 JTF_VARCHAR2_TABLE_500
442: , p5_a21 JTF_VARCHAR2_TABLE_500
443: , p5_a22 JTF_VARCHAR2_TABLE_500
444: , p5_a23 JTF_NUMBER_TABLE
445: , p5_a24 JTF_NUMBER_TABLE
446: , p5_a25 JTF_DATE_TABLE
447: , p5_a26 JTF_NUMBER_TABLE
448: , p5_a27 JTF_DATE_TABLE
441: , p5_a20 JTF_VARCHAR2_TABLE_500
442: , p5_a21 JTF_VARCHAR2_TABLE_500
443: , p5_a22 JTF_VARCHAR2_TABLE_500
444: , p5_a23 JTF_NUMBER_TABLE
445: , p5_a24 JTF_NUMBER_TABLE
446: , p5_a25 JTF_DATE_TABLE
447: , p5_a26 JTF_NUMBER_TABLE
448: , p5_a27 JTF_DATE_TABLE
449: , p5_a28 JTF_NUMBER_TABLE
443: , p5_a22 JTF_VARCHAR2_TABLE_500
444: , p5_a23 JTF_NUMBER_TABLE
445: , p5_a24 JTF_NUMBER_TABLE
446: , p5_a25 JTF_DATE_TABLE
447: , p5_a26 JTF_NUMBER_TABLE
448: , p5_a27 JTF_DATE_TABLE
449: , p5_a28 JTF_NUMBER_TABLE
450: );
451: end okl_gtt_pvt_w;
445: , p5_a24 JTF_NUMBER_TABLE
446: , p5_a25 JTF_DATE_TABLE
447: , p5_a26 JTF_NUMBER_TABLE
448: , p5_a27 JTF_DATE_TABLE
449: , p5_a28 JTF_NUMBER_TABLE
450: );
451: end okl_gtt_pvt_w;