1: package ahl_prd_resource_tranx_pvt_w as
2: /* $Header: AHLWTRSS.pls 120.2 2006/01/19 16:47 sikumar noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy ahl_prd_resource_tranx_pvt.prd_resource_txns_tbl, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
1: package ahl_prd_resource_tranx_pvt_w as
2: /* $Header: AHLWTRSS.pls 120.2 2006/01/19 16:47 sikumar noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy ahl_prd_resource_tranx_pvt.prd_resource_txns_tbl, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
1: package ahl_prd_resource_tranx_pvt_w as
2: /* $Header: AHLWTRSS.pls 120.2 2006/01/19 16:47 sikumar noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy ahl_prd_resource_tranx_pvt.prd_resource_txns_tbl, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_VARCHAR2_TABLE_300
2: /* $Header: AHLWTRSS.pls 120.2 2006/01/19 16:47 sikumar noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy ahl_prd_resource_tranx_pvt.prd_resource_txns_tbl, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_VARCHAR2_TABLE_300
10: , a7 JTF_NUMBER_TABLE
3: procedure rosetta_table_copy_in_p1(t out nocopy ahl_prd_resource_tranx_pvt.prd_resource_txns_tbl, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_VARCHAR2_TABLE_300
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_VARCHAR2_TABLE_100
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_VARCHAR2_TABLE_300
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_VARCHAR2_TABLE_300
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_VARCHAR2_TABLE_300
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_VARCHAR2_TABLE_300
13: , a10 JTF_NUMBER_TABLE
14: , a11 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_VARCHAR2_TABLE_300
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_VARCHAR2_TABLE_300
13: , a10 JTF_NUMBER_TABLE
14: , a11 JTF_VARCHAR2_TABLE_100
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_VARCHAR2_TABLE_100
17: , a14 JTF_NUMBER_TABLE
11: , a8 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_VARCHAR2_TABLE_300
13: , a10 JTF_NUMBER_TABLE
14: , a11 JTF_VARCHAR2_TABLE_100
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_VARCHAR2_TABLE_100
17: , a14 JTF_NUMBER_TABLE
18: , a15 JTF_NUMBER_TABLE
19: , a16 JTF_VARCHAR2_TABLE_100
13: , a10 JTF_NUMBER_TABLE
14: , a11 JTF_VARCHAR2_TABLE_100
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_VARCHAR2_TABLE_100
17: , a14 JTF_NUMBER_TABLE
18: , a15 JTF_NUMBER_TABLE
19: , a16 JTF_VARCHAR2_TABLE_100
20: , a17 JTF_VARCHAR2_TABLE_100
21: , a18 JTF_VARCHAR2_TABLE_100
14: , a11 JTF_VARCHAR2_TABLE_100
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_VARCHAR2_TABLE_100
17: , a14 JTF_NUMBER_TABLE
18: , a15 JTF_NUMBER_TABLE
19: , a16 JTF_VARCHAR2_TABLE_100
20: , a17 JTF_VARCHAR2_TABLE_100
21: , a18 JTF_VARCHAR2_TABLE_100
22: , a19 JTF_NUMBER_TABLE
18: , a15 JTF_NUMBER_TABLE
19: , a16 JTF_VARCHAR2_TABLE_100
20: , a17 JTF_VARCHAR2_TABLE_100
21: , a18 JTF_VARCHAR2_TABLE_100
22: , a19 JTF_NUMBER_TABLE
23: , a20 JTF_NUMBER_TABLE
24: , a21 JTF_VARCHAR2_TABLE_100
25: , a22 JTF_VARCHAR2_TABLE_100
26: , a23 JTF_VARCHAR2_TABLE_100
19: , a16 JTF_VARCHAR2_TABLE_100
20: , a17 JTF_VARCHAR2_TABLE_100
21: , a18 JTF_VARCHAR2_TABLE_100
22: , a19 JTF_NUMBER_TABLE
23: , a20 JTF_NUMBER_TABLE
24: , a21 JTF_VARCHAR2_TABLE_100
25: , a22 JTF_VARCHAR2_TABLE_100
26: , a23 JTF_VARCHAR2_TABLE_100
27: , a24 JTF_VARCHAR2_TABLE_100
29: , a26 JTF_VARCHAR2_TABLE_300
30: , a27 JTF_DATE_TABLE
31: , a28 JTF_DATE_TABLE
32: );
33: procedure rosetta_table_copy_out_p1(t ahl_prd_resource_tranx_pvt.prd_resource_txns_tbl, 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_NUMBER_TABLE
37: , a4 out nocopy JTF_NUMBER_TABLE
30: , a27 JTF_DATE_TABLE
31: , a28 JTF_DATE_TABLE
32: );
33: procedure rosetta_table_copy_out_p1(t ahl_prd_resource_tranx_pvt.prd_resource_txns_tbl, 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_NUMBER_TABLE
37: , a4 out nocopy JTF_NUMBER_TABLE
38: , a5 out nocopy JTF_NUMBER_TABLE
31: , a28 JTF_DATE_TABLE
32: );
33: procedure rosetta_table_copy_out_p1(t ahl_prd_resource_tranx_pvt.prd_resource_txns_tbl, 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_NUMBER_TABLE
37: , a4 out nocopy JTF_NUMBER_TABLE
38: , a5 out nocopy JTF_NUMBER_TABLE
39: , a6 out nocopy JTF_VARCHAR2_TABLE_300
32: );
33: procedure rosetta_table_copy_out_p1(t ahl_prd_resource_tranx_pvt.prd_resource_txns_tbl, 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_NUMBER_TABLE
37: , a4 out nocopy JTF_NUMBER_TABLE
38: , a5 out nocopy JTF_NUMBER_TABLE
39: , a6 out nocopy JTF_VARCHAR2_TABLE_300
40: , a7 out nocopy JTF_NUMBER_TABLE
33: procedure rosetta_table_copy_out_p1(t ahl_prd_resource_tranx_pvt.prd_resource_txns_tbl, 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_NUMBER_TABLE
37: , a4 out nocopy JTF_NUMBER_TABLE
38: , a5 out nocopy JTF_NUMBER_TABLE
39: , a6 out nocopy JTF_VARCHAR2_TABLE_300
40: , a7 out nocopy JTF_NUMBER_TABLE
41: , a8 out nocopy JTF_VARCHAR2_TABLE_100
34: , a1 out nocopy JTF_NUMBER_TABLE
35: , a2 out nocopy JTF_NUMBER_TABLE
36: , a3 out nocopy JTF_NUMBER_TABLE
37: , a4 out nocopy JTF_NUMBER_TABLE
38: , a5 out nocopy JTF_NUMBER_TABLE
39: , a6 out nocopy JTF_VARCHAR2_TABLE_300
40: , a7 out nocopy JTF_NUMBER_TABLE
41: , a8 out nocopy JTF_VARCHAR2_TABLE_100
42: , a9 out nocopy JTF_VARCHAR2_TABLE_300
36: , a3 out nocopy JTF_NUMBER_TABLE
37: , a4 out nocopy JTF_NUMBER_TABLE
38: , a5 out nocopy JTF_NUMBER_TABLE
39: , a6 out nocopy JTF_VARCHAR2_TABLE_300
40: , a7 out nocopy JTF_NUMBER_TABLE
41: , a8 out nocopy JTF_VARCHAR2_TABLE_100
42: , a9 out nocopy JTF_VARCHAR2_TABLE_300
43: , a10 out nocopy JTF_NUMBER_TABLE
44: , a11 out nocopy JTF_VARCHAR2_TABLE_100
39: , a6 out nocopy JTF_VARCHAR2_TABLE_300
40: , a7 out nocopy JTF_NUMBER_TABLE
41: , a8 out nocopy JTF_VARCHAR2_TABLE_100
42: , a9 out nocopy JTF_VARCHAR2_TABLE_300
43: , a10 out nocopy JTF_NUMBER_TABLE
44: , a11 out nocopy JTF_VARCHAR2_TABLE_100
45: , a12 out nocopy JTF_NUMBER_TABLE
46: , a13 out nocopy JTF_VARCHAR2_TABLE_100
47: , a14 out nocopy JTF_NUMBER_TABLE
41: , a8 out nocopy JTF_VARCHAR2_TABLE_100
42: , a9 out nocopy JTF_VARCHAR2_TABLE_300
43: , a10 out nocopy JTF_NUMBER_TABLE
44: , a11 out nocopy JTF_VARCHAR2_TABLE_100
45: , a12 out nocopy JTF_NUMBER_TABLE
46: , a13 out nocopy JTF_VARCHAR2_TABLE_100
47: , a14 out nocopy JTF_NUMBER_TABLE
48: , a15 out nocopy JTF_NUMBER_TABLE
49: , a16 out nocopy JTF_VARCHAR2_TABLE_100
43: , a10 out nocopy JTF_NUMBER_TABLE
44: , a11 out nocopy JTF_VARCHAR2_TABLE_100
45: , a12 out nocopy JTF_NUMBER_TABLE
46: , a13 out nocopy JTF_VARCHAR2_TABLE_100
47: , a14 out nocopy JTF_NUMBER_TABLE
48: , a15 out nocopy JTF_NUMBER_TABLE
49: , a16 out nocopy JTF_VARCHAR2_TABLE_100
50: , a17 out nocopy JTF_VARCHAR2_TABLE_100
51: , a18 out nocopy JTF_VARCHAR2_TABLE_100
44: , a11 out nocopy JTF_VARCHAR2_TABLE_100
45: , a12 out nocopy JTF_NUMBER_TABLE
46: , a13 out nocopy JTF_VARCHAR2_TABLE_100
47: , a14 out nocopy JTF_NUMBER_TABLE
48: , a15 out nocopy JTF_NUMBER_TABLE
49: , a16 out nocopy JTF_VARCHAR2_TABLE_100
50: , a17 out nocopy JTF_VARCHAR2_TABLE_100
51: , a18 out nocopy JTF_VARCHAR2_TABLE_100
52: , a19 out nocopy JTF_NUMBER_TABLE
48: , a15 out nocopy JTF_NUMBER_TABLE
49: , a16 out nocopy JTF_VARCHAR2_TABLE_100
50: , a17 out nocopy JTF_VARCHAR2_TABLE_100
51: , a18 out nocopy JTF_VARCHAR2_TABLE_100
52: , a19 out nocopy JTF_NUMBER_TABLE
53: , a20 out nocopy JTF_NUMBER_TABLE
54: , a21 out nocopy JTF_VARCHAR2_TABLE_100
55: , a22 out nocopy JTF_VARCHAR2_TABLE_100
56: , a23 out nocopy JTF_VARCHAR2_TABLE_100
49: , a16 out nocopy JTF_VARCHAR2_TABLE_100
50: , a17 out nocopy JTF_VARCHAR2_TABLE_100
51: , a18 out nocopy JTF_VARCHAR2_TABLE_100
52: , a19 out nocopy JTF_NUMBER_TABLE
53: , a20 out nocopy JTF_NUMBER_TABLE
54: , a21 out nocopy JTF_VARCHAR2_TABLE_100
55: , a22 out nocopy JTF_VARCHAR2_TABLE_100
56: , a23 out nocopy JTF_VARCHAR2_TABLE_100
57: , a24 out nocopy JTF_VARCHAR2_TABLE_100
60: , a27 out nocopy JTF_DATE_TABLE
61: , a28 out nocopy JTF_DATE_TABLE
62: );
63:
64: procedure rosetta_table_copy_in_p3(t out nocopy ahl_prd_resource_tranx_pvt.prd_myworkorder_txns_tbl, a0 JTF_NUMBER_TABLE
65: , a1 JTF_NUMBER_TABLE
66: , a2 JTF_NUMBER_TABLE
67: , a3 JTF_NUMBER_TABLE
68: , a4 JTF_NUMBER_TABLE
61: , a28 out nocopy JTF_DATE_TABLE
62: );
63:
64: procedure rosetta_table_copy_in_p3(t out nocopy ahl_prd_resource_tranx_pvt.prd_myworkorder_txns_tbl, a0 JTF_NUMBER_TABLE
65: , a1 JTF_NUMBER_TABLE
66: , a2 JTF_NUMBER_TABLE
67: , a3 JTF_NUMBER_TABLE
68: , a4 JTF_NUMBER_TABLE
69: , a5 JTF_NUMBER_TABLE
62: );
63:
64: procedure rosetta_table_copy_in_p3(t out nocopy ahl_prd_resource_tranx_pvt.prd_myworkorder_txns_tbl, a0 JTF_NUMBER_TABLE
65: , a1 JTF_NUMBER_TABLE
66: , a2 JTF_NUMBER_TABLE
67: , a3 JTF_NUMBER_TABLE
68: , a4 JTF_NUMBER_TABLE
69: , a5 JTF_NUMBER_TABLE
70: , a6 JTF_NUMBER_TABLE
63:
64: procedure rosetta_table_copy_in_p3(t out nocopy ahl_prd_resource_tranx_pvt.prd_myworkorder_txns_tbl, a0 JTF_NUMBER_TABLE
65: , a1 JTF_NUMBER_TABLE
66: , a2 JTF_NUMBER_TABLE
67: , a3 JTF_NUMBER_TABLE
68: , a4 JTF_NUMBER_TABLE
69: , a5 JTF_NUMBER_TABLE
70: , a6 JTF_NUMBER_TABLE
71: , a7 JTF_NUMBER_TABLE
64: procedure rosetta_table_copy_in_p3(t out nocopy ahl_prd_resource_tranx_pvt.prd_myworkorder_txns_tbl, a0 JTF_NUMBER_TABLE
65: , a1 JTF_NUMBER_TABLE
66: , a2 JTF_NUMBER_TABLE
67: , a3 JTF_NUMBER_TABLE
68: , a4 JTF_NUMBER_TABLE
69: , a5 JTF_NUMBER_TABLE
70: , a6 JTF_NUMBER_TABLE
71: , a7 JTF_NUMBER_TABLE
72: , a8 JTF_VARCHAR2_TABLE_100
65: , a1 JTF_NUMBER_TABLE
66: , a2 JTF_NUMBER_TABLE
67: , a3 JTF_NUMBER_TABLE
68: , a4 JTF_NUMBER_TABLE
69: , a5 JTF_NUMBER_TABLE
70: , a6 JTF_NUMBER_TABLE
71: , a7 JTF_NUMBER_TABLE
72: , a8 JTF_VARCHAR2_TABLE_100
73: , a9 JTF_NUMBER_TABLE
66: , a2 JTF_NUMBER_TABLE
67: , a3 JTF_NUMBER_TABLE
68: , a4 JTF_NUMBER_TABLE
69: , a5 JTF_NUMBER_TABLE
70: , a6 JTF_NUMBER_TABLE
71: , a7 JTF_NUMBER_TABLE
72: , a8 JTF_VARCHAR2_TABLE_100
73: , a9 JTF_NUMBER_TABLE
74: , a10 JTF_NUMBER_TABLE
67: , a3 JTF_NUMBER_TABLE
68: , a4 JTF_NUMBER_TABLE
69: , a5 JTF_NUMBER_TABLE
70: , a6 JTF_NUMBER_TABLE
71: , a7 JTF_NUMBER_TABLE
72: , a8 JTF_VARCHAR2_TABLE_100
73: , a9 JTF_NUMBER_TABLE
74: , a10 JTF_NUMBER_TABLE
75: , a11 JTF_VARCHAR2_TABLE_100
69: , a5 JTF_NUMBER_TABLE
70: , a6 JTF_NUMBER_TABLE
71: , a7 JTF_NUMBER_TABLE
72: , a8 JTF_VARCHAR2_TABLE_100
73: , a9 JTF_NUMBER_TABLE
74: , a10 JTF_NUMBER_TABLE
75: , a11 JTF_VARCHAR2_TABLE_100
76: );
77: procedure rosetta_table_copy_out_p3(t ahl_prd_resource_tranx_pvt.prd_myworkorder_txns_tbl, a0 out nocopy JTF_NUMBER_TABLE
70: , a6 JTF_NUMBER_TABLE
71: , a7 JTF_NUMBER_TABLE
72: , a8 JTF_VARCHAR2_TABLE_100
73: , a9 JTF_NUMBER_TABLE
74: , a10 JTF_NUMBER_TABLE
75: , a11 JTF_VARCHAR2_TABLE_100
76: );
77: procedure rosetta_table_copy_out_p3(t ahl_prd_resource_tranx_pvt.prd_myworkorder_txns_tbl, a0 out nocopy JTF_NUMBER_TABLE
78: , a1 out nocopy JTF_NUMBER_TABLE
73: , a9 JTF_NUMBER_TABLE
74: , a10 JTF_NUMBER_TABLE
75: , a11 JTF_VARCHAR2_TABLE_100
76: );
77: procedure rosetta_table_copy_out_p3(t ahl_prd_resource_tranx_pvt.prd_myworkorder_txns_tbl, a0 out nocopy JTF_NUMBER_TABLE
78: , a1 out nocopy JTF_NUMBER_TABLE
79: , a2 out nocopy JTF_NUMBER_TABLE
80: , a3 out nocopy JTF_NUMBER_TABLE
81: , a4 out nocopy JTF_NUMBER_TABLE
74: , a10 JTF_NUMBER_TABLE
75: , a11 JTF_VARCHAR2_TABLE_100
76: );
77: procedure rosetta_table_copy_out_p3(t ahl_prd_resource_tranx_pvt.prd_myworkorder_txns_tbl, a0 out nocopy JTF_NUMBER_TABLE
78: , a1 out nocopy JTF_NUMBER_TABLE
79: , a2 out nocopy JTF_NUMBER_TABLE
80: , a3 out nocopy JTF_NUMBER_TABLE
81: , a4 out nocopy JTF_NUMBER_TABLE
82: , a5 out nocopy JTF_NUMBER_TABLE
75: , a11 JTF_VARCHAR2_TABLE_100
76: );
77: procedure rosetta_table_copy_out_p3(t ahl_prd_resource_tranx_pvt.prd_myworkorder_txns_tbl, a0 out nocopy JTF_NUMBER_TABLE
78: , a1 out nocopy JTF_NUMBER_TABLE
79: , a2 out nocopy JTF_NUMBER_TABLE
80: , a3 out nocopy JTF_NUMBER_TABLE
81: , a4 out nocopy JTF_NUMBER_TABLE
82: , a5 out nocopy JTF_NUMBER_TABLE
83: , a6 out nocopy JTF_NUMBER_TABLE
76: );
77: procedure rosetta_table_copy_out_p3(t ahl_prd_resource_tranx_pvt.prd_myworkorder_txns_tbl, a0 out nocopy JTF_NUMBER_TABLE
78: , a1 out nocopy JTF_NUMBER_TABLE
79: , a2 out nocopy JTF_NUMBER_TABLE
80: , a3 out nocopy JTF_NUMBER_TABLE
81: , a4 out nocopy JTF_NUMBER_TABLE
82: , a5 out nocopy JTF_NUMBER_TABLE
83: , a6 out nocopy JTF_NUMBER_TABLE
84: , a7 out nocopy JTF_NUMBER_TABLE
77: procedure rosetta_table_copy_out_p3(t ahl_prd_resource_tranx_pvt.prd_myworkorder_txns_tbl, a0 out nocopy JTF_NUMBER_TABLE
78: , a1 out nocopy JTF_NUMBER_TABLE
79: , a2 out nocopy JTF_NUMBER_TABLE
80: , a3 out nocopy JTF_NUMBER_TABLE
81: , a4 out nocopy JTF_NUMBER_TABLE
82: , a5 out nocopy JTF_NUMBER_TABLE
83: , a6 out nocopy JTF_NUMBER_TABLE
84: , a7 out nocopy JTF_NUMBER_TABLE
85: , a8 out nocopy JTF_VARCHAR2_TABLE_100
78: , a1 out nocopy JTF_NUMBER_TABLE
79: , a2 out nocopy JTF_NUMBER_TABLE
80: , a3 out nocopy JTF_NUMBER_TABLE
81: , a4 out nocopy JTF_NUMBER_TABLE
82: , a5 out nocopy JTF_NUMBER_TABLE
83: , a6 out nocopy JTF_NUMBER_TABLE
84: , a7 out nocopy JTF_NUMBER_TABLE
85: , a8 out nocopy JTF_VARCHAR2_TABLE_100
86: , a9 out nocopy JTF_NUMBER_TABLE
79: , a2 out nocopy JTF_NUMBER_TABLE
80: , a3 out nocopy JTF_NUMBER_TABLE
81: , a4 out nocopy JTF_NUMBER_TABLE
82: , a5 out nocopy JTF_NUMBER_TABLE
83: , a6 out nocopy JTF_NUMBER_TABLE
84: , a7 out nocopy JTF_NUMBER_TABLE
85: , a8 out nocopy JTF_VARCHAR2_TABLE_100
86: , a9 out nocopy JTF_NUMBER_TABLE
87: , a10 out nocopy JTF_NUMBER_TABLE
80: , a3 out nocopy JTF_NUMBER_TABLE
81: , a4 out nocopy JTF_NUMBER_TABLE
82: , a5 out nocopy JTF_NUMBER_TABLE
83: , a6 out nocopy JTF_NUMBER_TABLE
84: , a7 out nocopy JTF_NUMBER_TABLE
85: , a8 out nocopy JTF_VARCHAR2_TABLE_100
86: , a9 out nocopy JTF_NUMBER_TABLE
87: , a10 out nocopy JTF_NUMBER_TABLE
88: , a11 out nocopy JTF_VARCHAR2_TABLE_100
82: , a5 out nocopy JTF_NUMBER_TABLE
83: , a6 out nocopy JTF_NUMBER_TABLE
84: , a7 out nocopy JTF_NUMBER_TABLE
85: , a8 out nocopy JTF_VARCHAR2_TABLE_100
86: , a9 out nocopy JTF_NUMBER_TABLE
87: , a10 out nocopy JTF_NUMBER_TABLE
88: , a11 out nocopy JTF_VARCHAR2_TABLE_100
89: );
90:
83: , a6 out nocopy JTF_NUMBER_TABLE
84: , a7 out nocopy JTF_NUMBER_TABLE
85: , a8 out nocopy JTF_VARCHAR2_TABLE_100
86: , a9 out nocopy JTF_NUMBER_TABLE
87: , a10 out nocopy JTF_NUMBER_TABLE
88: , a11 out nocopy JTF_VARCHAR2_TABLE_100
89: );
90:
91: procedure process_resource_txns(p_api_version NUMBER
96: , p_module_type VARCHAR2
97: , x_return_status out nocopy VARCHAR2
98: , x_msg_count out nocopy NUMBER
99: , x_msg_data out nocopy VARCHAR2
100: , p9_a0 in out nocopy JTF_NUMBER_TABLE
101: , p9_a1 in out nocopy JTF_NUMBER_TABLE
102: , p9_a2 in out nocopy JTF_NUMBER_TABLE
103: , p9_a3 in out nocopy JTF_NUMBER_TABLE
104: , p9_a4 in out nocopy JTF_NUMBER_TABLE
97: , x_return_status out nocopy VARCHAR2
98: , x_msg_count out nocopy NUMBER
99: , x_msg_data out nocopy VARCHAR2
100: , p9_a0 in out nocopy JTF_NUMBER_TABLE
101: , p9_a1 in out nocopy JTF_NUMBER_TABLE
102: , p9_a2 in out nocopy JTF_NUMBER_TABLE
103: , p9_a3 in out nocopy JTF_NUMBER_TABLE
104: , p9_a4 in out nocopy JTF_NUMBER_TABLE
105: , p9_a5 in out nocopy JTF_NUMBER_TABLE
98: , x_msg_count out nocopy NUMBER
99: , x_msg_data out nocopy VARCHAR2
100: , p9_a0 in out nocopy JTF_NUMBER_TABLE
101: , p9_a1 in out nocopy JTF_NUMBER_TABLE
102: , p9_a2 in out nocopy JTF_NUMBER_TABLE
103: , p9_a3 in out nocopy JTF_NUMBER_TABLE
104: , p9_a4 in out nocopy JTF_NUMBER_TABLE
105: , p9_a5 in out nocopy JTF_NUMBER_TABLE
106: , p9_a6 in out nocopy JTF_VARCHAR2_TABLE_300
99: , x_msg_data out nocopy VARCHAR2
100: , p9_a0 in out nocopy JTF_NUMBER_TABLE
101: , p9_a1 in out nocopy JTF_NUMBER_TABLE
102: , p9_a2 in out nocopy JTF_NUMBER_TABLE
103: , p9_a3 in out nocopy JTF_NUMBER_TABLE
104: , p9_a4 in out nocopy JTF_NUMBER_TABLE
105: , p9_a5 in out nocopy JTF_NUMBER_TABLE
106: , p9_a6 in out nocopy JTF_VARCHAR2_TABLE_300
107: , p9_a7 in out nocopy JTF_NUMBER_TABLE
100: , p9_a0 in out nocopy JTF_NUMBER_TABLE
101: , p9_a1 in out nocopy JTF_NUMBER_TABLE
102: , p9_a2 in out nocopy JTF_NUMBER_TABLE
103: , p9_a3 in out nocopy JTF_NUMBER_TABLE
104: , p9_a4 in out nocopy JTF_NUMBER_TABLE
105: , p9_a5 in out nocopy JTF_NUMBER_TABLE
106: , p9_a6 in out nocopy JTF_VARCHAR2_TABLE_300
107: , p9_a7 in out nocopy JTF_NUMBER_TABLE
108: , p9_a8 in out nocopy JTF_VARCHAR2_TABLE_100
101: , p9_a1 in out nocopy JTF_NUMBER_TABLE
102: , p9_a2 in out nocopy JTF_NUMBER_TABLE
103: , p9_a3 in out nocopy JTF_NUMBER_TABLE
104: , p9_a4 in out nocopy JTF_NUMBER_TABLE
105: , p9_a5 in out nocopy JTF_NUMBER_TABLE
106: , p9_a6 in out nocopy JTF_VARCHAR2_TABLE_300
107: , p9_a7 in out nocopy JTF_NUMBER_TABLE
108: , p9_a8 in out nocopy JTF_VARCHAR2_TABLE_100
109: , p9_a9 in out nocopy JTF_VARCHAR2_TABLE_300
103: , p9_a3 in out nocopy JTF_NUMBER_TABLE
104: , p9_a4 in out nocopy JTF_NUMBER_TABLE
105: , p9_a5 in out nocopy JTF_NUMBER_TABLE
106: , p9_a6 in out nocopy JTF_VARCHAR2_TABLE_300
107: , p9_a7 in out nocopy JTF_NUMBER_TABLE
108: , p9_a8 in out nocopy JTF_VARCHAR2_TABLE_100
109: , p9_a9 in out nocopy JTF_VARCHAR2_TABLE_300
110: , p9_a10 in out nocopy JTF_NUMBER_TABLE
111: , p9_a11 in out nocopy JTF_VARCHAR2_TABLE_100
106: , p9_a6 in out nocopy JTF_VARCHAR2_TABLE_300
107: , p9_a7 in out nocopy JTF_NUMBER_TABLE
108: , p9_a8 in out nocopy JTF_VARCHAR2_TABLE_100
109: , p9_a9 in out nocopy JTF_VARCHAR2_TABLE_300
110: , p9_a10 in out nocopy JTF_NUMBER_TABLE
111: , p9_a11 in out nocopy JTF_VARCHAR2_TABLE_100
112: , p9_a12 in out nocopy JTF_NUMBER_TABLE
113: , p9_a13 in out nocopy JTF_VARCHAR2_TABLE_100
114: , p9_a14 in out nocopy JTF_NUMBER_TABLE
108: , p9_a8 in out nocopy JTF_VARCHAR2_TABLE_100
109: , p9_a9 in out nocopy JTF_VARCHAR2_TABLE_300
110: , p9_a10 in out nocopy JTF_NUMBER_TABLE
111: , p9_a11 in out nocopy JTF_VARCHAR2_TABLE_100
112: , p9_a12 in out nocopy JTF_NUMBER_TABLE
113: , p9_a13 in out nocopy JTF_VARCHAR2_TABLE_100
114: , p9_a14 in out nocopy JTF_NUMBER_TABLE
115: , p9_a15 in out nocopy JTF_NUMBER_TABLE
116: , p9_a16 in out nocopy JTF_VARCHAR2_TABLE_100
110: , p9_a10 in out nocopy JTF_NUMBER_TABLE
111: , p9_a11 in out nocopy JTF_VARCHAR2_TABLE_100
112: , p9_a12 in out nocopy JTF_NUMBER_TABLE
113: , p9_a13 in out nocopy JTF_VARCHAR2_TABLE_100
114: , p9_a14 in out nocopy JTF_NUMBER_TABLE
115: , p9_a15 in out nocopy JTF_NUMBER_TABLE
116: , p9_a16 in out nocopy JTF_VARCHAR2_TABLE_100
117: , p9_a17 in out nocopy JTF_VARCHAR2_TABLE_100
118: , p9_a18 in out nocopy JTF_VARCHAR2_TABLE_100
111: , p9_a11 in out nocopy JTF_VARCHAR2_TABLE_100
112: , p9_a12 in out nocopy JTF_NUMBER_TABLE
113: , p9_a13 in out nocopy JTF_VARCHAR2_TABLE_100
114: , p9_a14 in out nocopy JTF_NUMBER_TABLE
115: , p9_a15 in out nocopy JTF_NUMBER_TABLE
116: , p9_a16 in out nocopy JTF_VARCHAR2_TABLE_100
117: , p9_a17 in out nocopy JTF_VARCHAR2_TABLE_100
118: , p9_a18 in out nocopy JTF_VARCHAR2_TABLE_100
119: , p9_a19 in out nocopy JTF_NUMBER_TABLE
115: , p9_a15 in out nocopy JTF_NUMBER_TABLE
116: , p9_a16 in out nocopy JTF_VARCHAR2_TABLE_100
117: , p9_a17 in out nocopy JTF_VARCHAR2_TABLE_100
118: , p9_a18 in out nocopy JTF_VARCHAR2_TABLE_100
119: , p9_a19 in out nocopy JTF_NUMBER_TABLE
120: , p9_a20 in out nocopy JTF_NUMBER_TABLE
121: , p9_a21 in out nocopy JTF_VARCHAR2_TABLE_100
122: , p9_a22 in out nocopy JTF_VARCHAR2_TABLE_100
123: , p9_a23 in out nocopy JTF_VARCHAR2_TABLE_100
116: , p9_a16 in out nocopy JTF_VARCHAR2_TABLE_100
117: , p9_a17 in out nocopy JTF_VARCHAR2_TABLE_100
118: , p9_a18 in out nocopy JTF_VARCHAR2_TABLE_100
119: , p9_a19 in out nocopy JTF_NUMBER_TABLE
120: , p9_a20 in out nocopy JTF_NUMBER_TABLE
121: , p9_a21 in out nocopy JTF_VARCHAR2_TABLE_100
122: , p9_a22 in out nocopy JTF_VARCHAR2_TABLE_100
123: , p9_a23 in out nocopy JTF_VARCHAR2_TABLE_100
124: , p9_a24 in out nocopy JTF_VARCHAR2_TABLE_100
135: , p_module_type VARCHAR2
136: , x_return_status out nocopy VARCHAR2
137: , x_msg_count out nocopy NUMBER
138: , x_msg_data out nocopy VARCHAR2
139: , p9_a0 in out nocopy JTF_NUMBER_TABLE
140: , p9_a1 in out nocopy JTF_NUMBER_TABLE
141: , p9_a2 in out nocopy JTF_NUMBER_TABLE
142: , p9_a3 in out nocopy JTF_NUMBER_TABLE
143: , p9_a4 in out nocopy JTF_NUMBER_TABLE
136: , x_return_status out nocopy VARCHAR2
137: , x_msg_count out nocopy NUMBER
138: , x_msg_data out nocopy VARCHAR2
139: , p9_a0 in out nocopy JTF_NUMBER_TABLE
140: , p9_a1 in out nocopy JTF_NUMBER_TABLE
141: , p9_a2 in out nocopy JTF_NUMBER_TABLE
142: , p9_a3 in out nocopy JTF_NUMBER_TABLE
143: , p9_a4 in out nocopy JTF_NUMBER_TABLE
144: , p9_a5 in out nocopy JTF_NUMBER_TABLE
137: , x_msg_count out nocopy NUMBER
138: , x_msg_data out nocopy VARCHAR2
139: , p9_a0 in out nocopy JTF_NUMBER_TABLE
140: , p9_a1 in out nocopy JTF_NUMBER_TABLE
141: , p9_a2 in out nocopy JTF_NUMBER_TABLE
142: , p9_a3 in out nocopy JTF_NUMBER_TABLE
143: , p9_a4 in out nocopy JTF_NUMBER_TABLE
144: , p9_a5 in out nocopy JTF_NUMBER_TABLE
145: , p9_a6 in out nocopy JTF_NUMBER_TABLE
138: , x_msg_data out nocopy VARCHAR2
139: , p9_a0 in out nocopy JTF_NUMBER_TABLE
140: , p9_a1 in out nocopy JTF_NUMBER_TABLE
141: , p9_a2 in out nocopy JTF_NUMBER_TABLE
142: , p9_a3 in out nocopy JTF_NUMBER_TABLE
143: , p9_a4 in out nocopy JTF_NUMBER_TABLE
144: , p9_a5 in out nocopy JTF_NUMBER_TABLE
145: , p9_a6 in out nocopy JTF_NUMBER_TABLE
146: , p9_a7 in out nocopy JTF_NUMBER_TABLE
139: , p9_a0 in out nocopy JTF_NUMBER_TABLE
140: , p9_a1 in out nocopy JTF_NUMBER_TABLE
141: , p9_a2 in out nocopy JTF_NUMBER_TABLE
142: , p9_a3 in out nocopy JTF_NUMBER_TABLE
143: , p9_a4 in out nocopy JTF_NUMBER_TABLE
144: , p9_a5 in out nocopy JTF_NUMBER_TABLE
145: , p9_a6 in out nocopy JTF_NUMBER_TABLE
146: , p9_a7 in out nocopy JTF_NUMBER_TABLE
147: , p9_a8 in out nocopy JTF_VARCHAR2_TABLE_100
140: , p9_a1 in out nocopy JTF_NUMBER_TABLE
141: , p9_a2 in out nocopy JTF_NUMBER_TABLE
142: , p9_a3 in out nocopy JTF_NUMBER_TABLE
143: , p9_a4 in out nocopy JTF_NUMBER_TABLE
144: , p9_a5 in out nocopy JTF_NUMBER_TABLE
145: , p9_a6 in out nocopy JTF_NUMBER_TABLE
146: , p9_a7 in out nocopy JTF_NUMBER_TABLE
147: , p9_a8 in out nocopy JTF_VARCHAR2_TABLE_100
148: , p9_a9 in out nocopy JTF_NUMBER_TABLE
141: , p9_a2 in out nocopy JTF_NUMBER_TABLE
142: , p9_a3 in out nocopy JTF_NUMBER_TABLE
143: , p9_a4 in out nocopy JTF_NUMBER_TABLE
144: , p9_a5 in out nocopy JTF_NUMBER_TABLE
145: , p9_a6 in out nocopy JTF_NUMBER_TABLE
146: , p9_a7 in out nocopy JTF_NUMBER_TABLE
147: , p9_a8 in out nocopy JTF_VARCHAR2_TABLE_100
148: , p9_a9 in out nocopy JTF_NUMBER_TABLE
149: , p9_a10 in out nocopy JTF_NUMBER_TABLE
142: , p9_a3 in out nocopy JTF_NUMBER_TABLE
143: , p9_a4 in out nocopy JTF_NUMBER_TABLE
144: , p9_a5 in out nocopy JTF_NUMBER_TABLE
145: , p9_a6 in out nocopy JTF_NUMBER_TABLE
146: , p9_a7 in out nocopy JTF_NUMBER_TABLE
147: , p9_a8 in out nocopy JTF_VARCHAR2_TABLE_100
148: , p9_a9 in out nocopy JTF_NUMBER_TABLE
149: , p9_a10 in out nocopy JTF_NUMBER_TABLE
150: , p9_a11 in out nocopy JTF_VARCHAR2_TABLE_100
144: , p9_a5 in out nocopy JTF_NUMBER_TABLE
145: , p9_a6 in out nocopy JTF_NUMBER_TABLE
146: , p9_a7 in out nocopy JTF_NUMBER_TABLE
147: , p9_a8 in out nocopy JTF_VARCHAR2_TABLE_100
148: , p9_a9 in out nocopy JTF_NUMBER_TABLE
149: , p9_a10 in out nocopy JTF_NUMBER_TABLE
150: , p9_a11 in out nocopy JTF_VARCHAR2_TABLE_100
151: );
152: procedure get_resource_txn_defaults(p_api_version NUMBER
145: , p9_a6 in out nocopy JTF_NUMBER_TABLE
146: , p9_a7 in out nocopy JTF_NUMBER_TABLE
147: , p9_a8 in out nocopy JTF_VARCHAR2_TABLE_100
148: , p9_a9 in out nocopy JTF_NUMBER_TABLE
149: , p9_a10 in out nocopy JTF_NUMBER_TABLE
150: , p9_a11 in out nocopy JTF_VARCHAR2_TABLE_100
151: );
152: procedure get_resource_txn_defaults(p_api_version NUMBER
153: , p_init_msg_list VARCHAR2
158: , p_employee_id NUMBER
159: , p_workorder_id NUMBER
160: , p_operation_seq_num NUMBER
161: , p_function_name VARCHAR2
162: , p10_a0 out nocopy JTF_NUMBER_TABLE
163: , p10_a1 out nocopy JTF_NUMBER_TABLE
164: , p10_a2 out nocopy JTF_NUMBER_TABLE
165: , p10_a3 out nocopy JTF_NUMBER_TABLE
166: , p10_a4 out nocopy JTF_NUMBER_TABLE
159: , p_workorder_id NUMBER
160: , p_operation_seq_num NUMBER
161: , p_function_name VARCHAR2
162: , p10_a0 out nocopy JTF_NUMBER_TABLE
163: , p10_a1 out nocopy JTF_NUMBER_TABLE
164: , p10_a2 out nocopy JTF_NUMBER_TABLE
165: , p10_a3 out nocopy JTF_NUMBER_TABLE
166: , p10_a4 out nocopy JTF_NUMBER_TABLE
167: , p10_a5 out nocopy JTF_NUMBER_TABLE
160: , p_operation_seq_num NUMBER
161: , p_function_name VARCHAR2
162: , p10_a0 out nocopy JTF_NUMBER_TABLE
163: , p10_a1 out nocopy JTF_NUMBER_TABLE
164: , p10_a2 out nocopy JTF_NUMBER_TABLE
165: , p10_a3 out nocopy JTF_NUMBER_TABLE
166: , p10_a4 out nocopy JTF_NUMBER_TABLE
167: , p10_a5 out nocopy JTF_NUMBER_TABLE
168: , p10_a6 out nocopy JTF_VARCHAR2_TABLE_300
161: , p_function_name VARCHAR2
162: , p10_a0 out nocopy JTF_NUMBER_TABLE
163: , p10_a1 out nocopy JTF_NUMBER_TABLE
164: , p10_a2 out nocopy JTF_NUMBER_TABLE
165: , p10_a3 out nocopy JTF_NUMBER_TABLE
166: , p10_a4 out nocopy JTF_NUMBER_TABLE
167: , p10_a5 out nocopy JTF_NUMBER_TABLE
168: , p10_a6 out nocopy JTF_VARCHAR2_TABLE_300
169: , p10_a7 out nocopy JTF_NUMBER_TABLE
162: , p10_a0 out nocopy JTF_NUMBER_TABLE
163: , p10_a1 out nocopy JTF_NUMBER_TABLE
164: , p10_a2 out nocopy JTF_NUMBER_TABLE
165: , p10_a3 out nocopy JTF_NUMBER_TABLE
166: , p10_a4 out nocopy JTF_NUMBER_TABLE
167: , p10_a5 out nocopy JTF_NUMBER_TABLE
168: , p10_a6 out nocopy JTF_VARCHAR2_TABLE_300
169: , p10_a7 out nocopy JTF_NUMBER_TABLE
170: , p10_a8 out nocopy JTF_VARCHAR2_TABLE_100
163: , p10_a1 out nocopy JTF_NUMBER_TABLE
164: , p10_a2 out nocopy JTF_NUMBER_TABLE
165: , p10_a3 out nocopy JTF_NUMBER_TABLE
166: , p10_a4 out nocopy JTF_NUMBER_TABLE
167: , p10_a5 out nocopy JTF_NUMBER_TABLE
168: , p10_a6 out nocopy JTF_VARCHAR2_TABLE_300
169: , p10_a7 out nocopy JTF_NUMBER_TABLE
170: , p10_a8 out nocopy JTF_VARCHAR2_TABLE_100
171: , p10_a9 out nocopy JTF_VARCHAR2_TABLE_300
165: , p10_a3 out nocopy JTF_NUMBER_TABLE
166: , p10_a4 out nocopy JTF_NUMBER_TABLE
167: , p10_a5 out nocopy JTF_NUMBER_TABLE
168: , p10_a6 out nocopy JTF_VARCHAR2_TABLE_300
169: , p10_a7 out nocopy JTF_NUMBER_TABLE
170: , p10_a8 out nocopy JTF_VARCHAR2_TABLE_100
171: , p10_a9 out nocopy JTF_VARCHAR2_TABLE_300
172: , p10_a10 out nocopy JTF_NUMBER_TABLE
173: , p10_a11 out nocopy JTF_VARCHAR2_TABLE_100
168: , p10_a6 out nocopy JTF_VARCHAR2_TABLE_300
169: , p10_a7 out nocopy JTF_NUMBER_TABLE
170: , p10_a8 out nocopy JTF_VARCHAR2_TABLE_100
171: , p10_a9 out nocopy JTF_VARCHAR2_TABLE_300
172: , p10_a10 out nocopy JTF_NUMBER_TABLE
173: , p10_a11 out nocopy JTF_VARCHAR2_TABLE_100
174: , p10_a12 out nocopy JTF_NUMBER_TABLE
175: , p10_a13 out nocopy JTF_VARCHAR2_TABLE_100
176: , p10_a14 out nocopy JTF_NUMBER_TABLE
170: , p10_a8 out nocopy JTF_VARCHAR2_TABLE_100
171: , p10_a9 out nocopy JTF_VARCHAR2_TABLE_300
172: , p10_a10 out nocopy JTF_NUMBER_TABLE
173: , p10_a11 out nocopy JTF_VARCHAR2_TABLE_100
174: , p10_a12 out nocopy JTF_NUMBER_TABLE
175: , p10_a13 out nocopy JTF_VARCHAR2_TABLE_100
176: , p10_a14 out nocopy JTF_NUMBER_TABLE
177: , p10_a15 out nocopy JTF_NUMBER_TABLE
178: , p10_a16 out nocopy JTF_VARCHAR2_TABLE_100
172: , p10_a10 out nocopy JTF_NUMBER_TABLE
173: , p10_a11 out nocopy JTF_VARCHAR2_TABLE_100
174: , p10_a12 out nocopy JTF_NUMBER_TABLE
175: , p10_a13 out nocopy JTF_VARCHAR2_TABLE_100
176: , p10_a14 out nocopy JTF_NUMBER_TABLE
177: , p10_a15 out nocopy JTF_NUMBER_TABLE
178: , p10_a16 out nocopy JTF_VARCHAR2_TABLE_100
179: , p10_a17 out nocopy JTF_VARCHAR2_TABLE_100
180: , p10_a18 out nocopy JTF_VARCHAR2_TABLE_100
173: , p10_a11 out nocopy JTF_VARCHAR2_TABLE_100
174: , p10_a12 out nocopy JTF_NUMBER_TABLE
175: , p10_a13 out nocopy JTF_VARCHAR2_TABLE_100
176: , p10_a14 out nocopy JTF_NUMBER_TABLE
177: , p10_a15 out nocopy JTF_NUMBER_TABLE
178: , p10_a16 out nocopy JTF_VARCHAR2_TABLE_100
179: , p10_a17 out nocopy JTF_VARCHAR2_TABLE_100
180: , p10_a18 out nocopy JTF_VARCHAR2_TABLE_100
181: , p10_a19 out nocopy JTF_NUMBER_TABLE
177: , p10_a15 out nocopy JTF_NUMBER_TABLE
178: , p10_a16 out nocopy JTF_VARCHAR2_TABLE_100
179: , p10_a17 out nocopy JTF_VARCHAR2_TABLE_100
180: , p10_a18 out nocopy JTF_VARCHAR2_TABLE_100
181: , p10_a19 out nocopy JTF_NUMBER_TABLE
182: , p10_a20 out nocopy JTF_NUMBER_TABLE
183: , p10_a21 out nocopy JTF_VARCHAR2_TABLE_100
184: , p10_a22 out nocopy JTF_VARCHAR2_TABLE_100
185: , p10_a23 out nocopy JTF_VARCHAR2_TABLE_100
178: , p10_a16 out nocopy JTF_VARCHAR2_TABLE_100
179: , p10_a17 out nocopy JTF_VARCHAR2_TABLE_100
180: , p10_a18 out nocopy JTF_VARCHAR2_TABLE_100
181: , p10_a19 out nocopy JTF_NUMBER_TABLE
182: , p10_a20 out nocopy JTF_NUMBER_TABLE
183: , p10_a21 out nocopy JTF_VARCHAR2_TABLE_100
184: , p10_a22 out nocopy JTF_VARCHAR2_TABLE_100
185: , p10_a23 out nocopy JTF_VARCHAR2_TABLE_100
186: , p10_a24 out nocopy JTF_VARCHAR2_TABLE_100