1: package jtf_ih_pub_w AUTHID CURRENT_USER as
2: /* $Header: JTFIHJWS.pls 115.32 2003/07/14 17:55:54 ialeshin ship $ */
3: procedure rosetta_table_copy_in_p3(t out nocopy jtf_ih_pub.activity_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_300
1: package jtf_ih_pub_w AUTHID CURRENT_USER as
2: /* $Header: JTFIHJWS.pls 115.32 2003/07/14 17:55:54 ialeshin ship $ */
3: procedure rosetta_table_copy_in_p3(t out nocopy jtf_ih_pub.activity_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_300
8: , a5 JTF_DATE_TABLE
1: package jtf_ih_pub_w AUTHID CURRENT_USER as
2: /* $Header: JTFIHJWS.pls 115.32 2003/07/14 17:55:54 ialeshin ship $ */
3: procedure rosetta_table_copy_in_p3(t out nocopy jtf_ih_pub.activity_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_300
8: , a5 JTF_DATE_TABLE
9: , a6 JTF_DATE_TABLE
2: /* $Header: JTFIHJWS.pls 115.32 2003/07/14 17:55:54 ialeshin ship $ */
3: procedure rosetta_table_copy_in_p3(t out nocopy jtf_ih_pub.activity_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_300
8: , a5 JTF_DATE_TABLE
9: , a6 JTF_DATE_TABLE
10: , a7 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_300
8: , a5 JTF_DATE_TABLE
9: , a6 JTF_DATE_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_VARCHAR2_TABLE_100
13: , a10 JTF_VARCHAR2_TABLE_100
14: , a11 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_300
8: , a5 JTF_DATE_TABLE
9: , a6 JTF_DATE_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_VARCHAR2_TABLE_100
13: , a10 JTF_VARCHAR2_TABLE_100
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_VARCHAR2_TABLE_100
13: , a10 JTF_VARCHAR2_TABLE_100
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_NUMBER_TABLE
17: , a14 JTF_NUMBER_TABLE
18: , a15 JTF_NUMBER_TABLE
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_VARCHAR2_TABLE_100
13: , a10 JTF_VARCHAR2_TABLE_100
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_NUMBER_TABLE
17: , a14 JTF_NUMBER_TABLE
18: , a15 JTF_NUMBER_TABLE
19: , a16 JTF_NUMBER_TABLE
12: , a9 JTF_VARCHAR2_TABLE_100
13: , a10 JTF_VARCHAR2_TABLE_100
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_NUMBER_TABLE
17: , a14 JTF_NUMBER_TABLE
18: , a15 JTF_NUMBER_TABLE
19: , a16 JTF_NUMBER_TABLE
20: , a17 JTF_VARCHAR2_TABLE_1000
13: , a10 JTF_VARCHAR2_TABLE_100
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_NUMBER_TABLE
17: , a14 JTF_NUMBER_TABLE
18: , a15 JTF_NUMBER_TABLE
19: , a16 JTF_NUMBER_TABLE
20: , a17 JTF_VARCHAR2_TABLE_1000
21: , a18 JTF_NUMBER_TABLE
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_NUMBER_TABLE
17: , a14 JTF_NUMBER_TABLE
18: , a15 JTF_NUMBER_TABLE
19: , a16 JTF_NUMBER_TABLE
20: , a17 JTF_VARCHAR2_TABLE_1000
21: , a18 JTF_NUMBER_TABLE
22: , a19 JTF_VARCHAR2_TABLE_300
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_NUMBER_TABLE
17: , a14 JTF_NUMBER_TABLE
18: , a15 JTF_NUMBER_TABLE
19: , a16 JTF_NUMBER_TABLE
20: , a17 JTF_VARCHAR2_TABLE_1000
21: , a18 JTF_NUMBER_TABLE
22: , a19 JTF_VARCHAR2_TABLE_300
23: , a20 JTF_NUMBER_TABLE
17: , a14 JTF_NUMBER_TABLE
18: , a15 JTF_NUMBER_TABLE
19: , a16 JTF_NUMBER_TABLE
20: , a17 JTF_VARCHAR2_TABLE_1000
21: , a18 JTF_NUMBER_TABLE
22: , a19 JTF_VARCHAR2_TABLE_300
23: , a20 JTF_NUMBER_TABLE
24: , a21 JTF_VARCHAR2_TABLE_100
25: , a22 JTF_NUMBER_TABLE
19: , a16 JTF_NUMBER_TABLE
20: , a17 JTF_VARCHAR2_TABLE_1000
21: , a18 JTF_NUMBER_TABLE
22: , a19 JTF_VARCHAR2_TABLE_300
23: , a20 JTF_NUMBER_TABLE
24: , a21 JTF_VARCHAR2_TABLE_100
25: , a22 JTF_NUMBER_TABLE
26: , a23 JTF_VARCHAR2_TABLE_100
27: , a24 JTF_NUMBER_TABLE
21: , a18 JTF_NUMBER_TABLE
22: , a19 JTF_VARCHAR2_TABLE_300
23: , a20 JTF_NUMBER_TABLE
24: , a21 JTF_VARCHAR2_TABLE_100
25: , a22 JTF_NUMBER_TABLE
26: , a23 JTF_VARCHAR2_TABLE_100
27: , a24 JTF_NUMBER_TABLE
28: , a25 JTF_VARCHAR2_TABLE_200
29: , a26 JTF_VARCHAR2_TABLE_200
23: , a20 JTF_NUMBER_TABLE
24: , a21 JTF_VARCHAR2_TABLE_100
25: , a22 JTF_NUMBER_TABLE
26: , a23 JTF_VARCHAR2_TABLE_100
27: , a24 JTF_NUMBER_TABLE
28: , a25 JTF_VARCHAR2_TABLE_200
29: , a26 JTF_VARCHAR2_TABLE_200
30: , a27 JTF_VARCHAR2_TABLE_200
31: , a28 JTF_VARCHAR2_TABLE_200
42: , a39 JTF_VARCHAR2_TABLE_200
43: , a40 JTF_VARCHAR2_TABLE_100
44: , a41 JTF_VARCHAR2_TABLE_300
45: , a42 JTF_VARCHAR2_TABLE_300
46: , a43 JTF_NUMBER_TABLE
47: , a44 JTF_NUMBER_TABLE
48: );
49: procedure rosetta_table_copy_out_p3(t jtf_ih_pub.activity_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
50: , a1 out nocopy JTF_NUMBER_TABLE
43: , a40 JTF_VARCHAR2_TABLE_100
44: , a41 JTF_VARCHAR2_TABLE_300
45: , a42 JTF_VARCHAR2_TABLE_300
46: , a43 JTF_NUMBER_TABLE
47: , a44 JTF_NUMBER_TABLE
48: );
49: procedure rosetta_table_copy_out_p3(t jtf_ih_pub.activity_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
50: , a1 out nocopy JTF_NUMBER_TABLE
51: , a2 out nocopy JTF_NUMBER_TABLE
45: , a42 JTF_VARCHAR2_TABLE_300
46: , a43 JTF_NUMBER_TABLE
47: , a44 JTF_NUMBER_TABLE
48: );
49: procedure rosetta_table_copy_out_p3(t jtf_ih_pub.activity_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
50: , a1 out nocopy JTF_NUMBER_TABLE
51: , a2 out nocopy JTF_NUMBER_TABLE
52: , a3 out nocopy JTF_NUMBER_TABLE
53: , a4 out nocopy JTF_VARCHAR2_TABLE_300
46: , a43 JTF_NUMBER_TABLE
47: , a44 JTF_NUMBER_TABLE
48: );
49: procedure rosetta_table_copy_out_p3(t jtf_ih_pub.activity_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
50: , a1 out nocopy JTF_NUMBER_TABLE
51: , a2 out nocopy JTF_NUMBER_TABLE
52: , a3 out nocopy JTF_NUMBER_TABLE
53: , a4 out nocopy JTF_VARCHAR2_TABLE_300
54: , a5 out nocopy JTF_DATE_TABLE
47: , a44 JTF_NUMBER_TABLE
48: );
49: procedure rosetta_table_copy_out_p3(t jtf_ih_pub.activity_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
50: , a1 out nocopy JTF_NUMBER_TABLE
51: , a2 out nocopy JTF_NUMBER_TABLE
52: , a3 out nocopy JTF_NUMBER_TABLE
53: , a4 out nocopy JTF_VARCHAR2_TABLE_300
54: , a5 out nocopy JTF_DATE_TABLE
55: , a6 out nocopy JTF_DATE_TABLE
48: );
49: procedure rosetta_table_copy_out_p3(t jtf_ih_pub.activity_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
50: , a1 out nocopy JTF_NUMBER_TABLE
51: , a2 out nocopy JTF_NUMBER_TABLE
52: , a3 out nocopy JTF_NUMBER_TABLE
53: , a4 out nocopy JTF_VARCHAR2_TABLE_300
54: , a5 out nocopy JTF_DATE_TABLE
55: , a6 out nocopy JTF_DATE_TABLE
56: , a7 out nocopy JTF_NUMBER_TABLE
52: , a3 out nocopy JTF_NUMBER_TABLE
53: , a4 out nocopy JTF_VARCHAR2_TABLE_300
54: , a5 out nocopy JTF_DATE_TABLE
55: , a6 out nocopy JTF_DATE_TABLE
56: , a7 out nocopy JTF_NUMBER_TABLE
57: , a8 out nocopy JTF_NUMBER_TABLE
58: , a9 out nocopy JTF_VARCHAR2_TABLE_100
59: , a10 out nocopy JTF_VARCHAR2_TABLE_100
60: , a11 out nocopy JTF_NUMBER_TABLE
53: , a4 out nocopy JTF_VARCHAR2_TABLE_300
54: , a5 out nocopy JTF_DATE_TABLE
55: , a6 out nocopy JTF_DATE_TABLE
56: , a7 out nocopy JTF_NUMBER_TABLE
57: , a8 out nocopy JTF_NUMBER_TABLE
58: , a9 out nocopy JTF_VARCHAR2_TABLE_100
59: , a10 out nocopy JTF_VARCHAR2_TABLE_100
60: , a11 out nocopy JTF_NUMBER_TABLE
61: , a12 out nocopy JTF_NUMBER_TABLE
56: , a7 out nocopy JTF_NUMBER_TABLE
57: , a8 out nocopy JTF_NUMBER_TABLE
58: , a9 out nocopy JTF_VARCHAR2_TABLE_100
59: , a10 out nocopy JTF_VARCHAR2_TABLE_100
60: , a11 out nocopy JTF_NUMBER_TABLE
61: , a12 out nocopy JTF_NUMBER_TABLE
62: , a13 out nocopy JTF_NUMBER_TABLE
63: , a14 out nocopy JTF_NUMBER_TABLE
64: , a15 out nocopy JTF_NUMBER_TABLE
57: , a8 out nocopy JTF_NUMBER_TABLE
58: , a9 out nocopy JTF_VARCHAR2_TABLE_100
59: , a10 out nocopy JTF_VARCHAR2_TABLE_100
60: , a11 out nocopy JTF_NUMBER_TABLE
61: , a12 out nocopy JTF_NUMBER_TABLE
62: , a13 out nocopy JTF_NUMBER_TABLE
63: , a14 out nocopy JTF_NUMBER_TABLE
64: , a15 out nocopy JTF_NUMBER_TABLE
65: , a16 out nocopy JTF_NUMBER_TABLE
58: , a9 out nocopy JTF_VARCHAR2_TABLE_100
59: , a10 out nocopy JTF_VARCHAR2_TABLE_100
60: , a11 out nocopy JTF_NUMBER_TABLE
61: , a12 out nocopy JTF_NUMBER_TABLE
62: , a13 out nocopy JTF_NUMBER_TABLE
63: , a14 out nocopy JTF_NUMBER_TABLE
64: , a15 out nocopy JTF_NUMBER_TABLE
65: , a16 out nocopy JTF_NUMBER_TABLE
66: , a17 out nocopy JTF_VARCHAR2_TABLE_1000
59: , a10 out nocopy JTF_VARCHAR2_TABLE_100
60: , a11 out nocopy JTF_NUMBER_TABLE
61: , a12 out nocopy JTF_NUMBER_TABLE
62: , a13 out nocopy JTF_NUMBER_TABLE
63: , a14 out nocopy JTF_NUMBER_TABLE
64: , a15 out nocopy JTF_NUMBER_TABLE
65: , a16 out nocopy JTF_NUMBER_TABLE
66: , a17 out nocopy JTF_VARCHAR2_TABLE_1000
67: , a18 out nocopy JTF_NUMBER_TABLE
60: , a11 out nocopy JTF_NUMBER_TABLE
61: , a12 out nocopy JTF_NUMBER_TABLE
62: , a13 out nocopy JTF_NUMBER_TABLE
63: , a14 out nocopy JTF_NUMBER_TABLE
64: , a15 out nocopy JTF_NUMBER_TABLE
65: , a16 out nocopy JTF_NUMBER_TABLE
66: , a17 out nocopy JTF_VARCHAR2_TABLE_1000
67: , a18 out nocopy JTF_NUMBER_TABLE
68: , a19 out nocopy JTF_VARCHAR2_TABLE_300
61: , a12 out nocopy JTF_NUMBER_TABLE
62: , a13 out nocopy JTF_NUMBER_TABLE
63: , a14 out nocopy JTF_NUMBER_TABLE
64: , a15 out nocopy JTF_NUMBER_TABLE
65: , a16 out nocopy JTF_NUMBER_TABLE
66: , a17 out nocopy JTF_VARCHAR2_TABLE_1000
67: , a18 out nocopy JTF_NUMBER_TABLE
68: , a19 out nocopy JTF_VARCHAR2_TABLE_300
69: , a20 out nocopy JTF_NUMBER_TABLE
63: , a14 out nocopy JTF_NUMBER_TABLE
64: , a15 out nocopy JTF_NUMBER_TABLE
65: , a16 out nocopy JTF_NUMBER_TABLE
66: , a17 out nocopy JTF_VARCHAR2_TABLE_1000
67: , a18 out nocopy JTF_NUMBER_TABLE
68: , a19 out nocopy JTF_VARCHAR2_TABLE_300
69: , a20 out nocopy JTF_NUMBER_TABLE
70: , a21 out nocopy JTF_VARCHAR2_TABLE_100
71: , a22 out nocopy JTF_NUMBER_TABLE
65: , a16 out nocopy JTF_NUMBER_TABLE
66: , a17 out nocopy JTF_VARCHAR2_TABLE_1000
67: , a18 out nocopy JTF_NUMBER_TABLE
68: , a19 out nocopy JTF_VARCHAR2_TABLE_300
69: , a20 out nocopy JTF_NUMBER_TABLE
70: , a21 out nocopy JTF_VARCHAR2_TABLE_100
71: , a22 out nocopy JTF_NUMBER_TABLE
72: , a23 out nocopy JTF_VARCHAR2_TABLE_100
73: , a24 out nocopy JTF_NUMBER_TABLE
67: , a18 out nocopy JTF_NUMBER_TABLE
68: , a19 out nocopy JTF_VARCHAR2_TABLE_300
69: , a20 out nocopy JTF_NUMBER_TABLE
70: , a21 out nocopy JTF_VARCHAR2_TABLE_100
71: , a22 out nocopy JTF_NUMBER_TABLE
72: , a23 out nocopy JTF_VARCHAR2_TABLE_100
73: , a24 out nocopy JTF_NUMBER_TABLE
74: , a25 out nocopy JTF_VARCHAR2_TABLE_200
75: , a26 out nocopy JTF_VARCHAR2_TABLE_200
69: , a20 out nocopy JTF_NUMBER_TABLE
70: , a21 out nocopy JTF_VARCHAR2_TABLE_100
71: , a22 out nocopy JTF_NUMBER_TABLE
72: , a23 out nocopy JTF_VARCHAR2_TABLE_100
73: , a24 out nocopy JTF_NUMBER_TABLE
74: , a25 out nocopy JTF_VARCHAR2_TABLE_200
75: , a26 out nocopy JTF_VARCHAR2_TABLE_200
76: , a27 out nocopy JTF_VARCHAR2_TABLE_200
77: , a28 out nocopy JTF_VARCHAR2_TABLE_200
88: , a39 out nocopy JTF_VARCHAR2_TABLE_200
89: , a40 out nocopy JTF_VARCHAR2_TABLE_100
90: , a41 out nocopy JTF_VARCHAR2_TABLE_300
91: , a42 out nocopy JTF_VARCHAR2_TABLE_300
92: , a43 out nocopy JTF_NUMBER_TABLE
93: , a44 out nocopy JTF_NUMBER_TABLE
94: );
95:
96: procedure rosetta_table_copy_in_p8(t out nocopy jtf_ih_pub.mlcs_tbl_type, a0 JTF_DATE_TABLE
89: , a40 out nocopy JTF_VARCHAR2_TABLE_100
90: , a41 out nocopy JTF_VARCHAR2_TABLE_300
91: , a42 out nocopy JTF_VARCHAR2_TABLE_300
92: , a43 out nocopy JTF_NUMBER_TABLE
93: , a44 out nocopy JTF_NUMBER_TABLE
94: );
95:
96: procedure rosetta_table_copy_in_p8(t out nocopy jtf_ih_pub.mlcs_tbl_type, a0 JTF_DATE_TABLE
97: , a1 JTF_VARCHAR2_TABLE_100
94: );
95:
96: procedure rosetta_table_copy_in_p8(t out nocopy jtf_ih_pub.mlcs_tbl_type, a0 JTF_DATE_TABLE
97: , a1 JTF_VARCHAR2_TABLE_100
98: , a2 JTF_NUMBER_TABLE
99: , a3 JTF_NUMBER_TABLE
100: , a4 JTF_DATE_TABLE
101: , a5 JTF_NUMBER_TABLE
102: , a6 JTF_NUMBER_TABLE
95:
96: procedure rosetta_table_copy_in_p8(t out nocopy jtf_ih_pub.mlcs_tbl_type, a0 JTF_DATE_TABLE
97: , a1 JTF_VARCHAR2_TABLE_100
98: , a2 JTF_NUMBER_TABLE
99: , a3 JTF_NUMBER_TABLE
100: , a4 JTF_DATE_TABLE
101: , a5 JTF_NUMBER_TABLE
102: , a6 JTF_NUMBER_TABLE
103: , a7 JTF_NUMBER_TABLE
97: , a1 JTF_VARCHAR2_TABLE_100
98: , a2 JTF_NUMBER_TABLE
99: , a3 JTF_NUMBER_TABLE
100: , a4 JTF_DATE_TABLE
101: , a5 JTF_NUMBER_TABLE
102: , a6 JTF_NUMBER_TABLE
103: , a7 JTF_NUMBER_TABLE
104: , a8 JTF_NUMBER_TABLE
105: , a9 JTF_NUMBER_TABLE
98: , a2 JTF_NUMBER_TABLE
99: , a3 JTF_NUMBER_TABLE
100: , a4 JTF_DATE_TABLE
101: , a5 JTF_NUMBER_TABLE
102: , a6 JTF_NUMBER_TABLE
103: , a7 JTF_NUMBER_TABLE
104: , a8 JTF_NUMBER_TABLE
105: , a9 JTF_NUMBER_TABLE
106: , a10 JTF_VARCHAR2_TABLE_100
99: , a3 JTF_NUMBER_TABLE
100: , a4 JTF_DATE_TABLE
101: , a5 JTF_NUMBER_TABLE
102: , a6 JTF_NUMBER_TABLE
103: , a7 JTF_NUMBER_TABLE
104: , a8 JTF_NUMBER_TABLE
105: , a9 JTF_NUMBER_TABLE
106: , a10 JTF_VARCHAR2_TABLE_100
107: , a11 JTF_VARCHAR2_TABLE_300
100: , a4 JTF_DATE_TABLE
101: , a5 JTF_NUMBER_TABLE
102: , a6 JTF_NUMBER_TABLE
103: , a7 JTF_NUMBER_TABLE
104: , a8 JTF_NUMBER_TABLE
105: , a9 JTF_NUMBER_TABLE
106: , a10 JTF_VARCHAR2_TABLE_100
107: , a11 JTF_VARCHAR2_TABLE_300
108: , a12 JTF_VARCHAR2_TABLE_300
101: , a5 JTF_NUMBER_TABLE
102: , a6 JTF_NUMBER_TABLE
103: , a7 JTF_NUMBER_TABLE
104: , a8 JTF_NUMBER_TABLE
105: , a9 JTF_NUMBER_TABLE
106: , a10 JTF_VARCHAR2_TABLE_100
107: , a11 JTF_VARCHAR2_TABLE_300
108: , a12 JTF_VARCHAR2_TABLE_300
109: , a13 JTF_NUMBER_TABLE
105: , a9 JTF_NUMBER_TABLE
106: , a10 JTF_VARCHAR2_TABLE_100
107: , a11 JTF_VARCHAR2_TABLE_300
108: , a12 JTF_VARCHAR2_TABLE_300
109: , a13 JTF_NUMBER_TABLE
110: , a14 JTF_NUMBER_TABLE
111: );
112: procedure rosetta_table_copy_out_p8(t jtf_ih_pub.mlcs_tbl_type, a0 out nocopy JTF_DATE_TABLE
113: , a1 out nocopy JTF_VARCHAR2_TABLE_100
106: , a10 JTF_VARCHAR2_TABLE_100
107: , a11 JTF_VARCHAR2_TABLE_300
108: , a12 JTF_VARCHAR2_TABLE_300
109: , a13 JTF_NUMBER_TABLE
110: , a14 JTF_NUMBER_TABLE
111: );
112: procedure rosetta_table_copy_out_p8(t jtf_ih_pub.mlcs_tbl_type, a0 out nocopy JTF_DATE_TABLE
113: , a1 out nocopy JTF_VARCHAR2_TABLE_100
114: , a2 out nocopy JTF_NUMBER_TABLE
110: , a14 JTF_NUMBER_TABLE
111: );
112: procedure rosetta_table_copy_out_p8(t jtf_ih_pub.mlcs_tbl_type, a0 out nocopy JTF_DATE_TABLE
113: , a1 out nocopy JTF_VARCHAR2_TABLE_100
114: , a2 out nocopy JTF_NUMBER_TABLE
115: , a3 out nocopy JTF_NUMBER_TABLE
116: , a4 out nocopy JTF_DATE_TABLE
117: , a5 out nocopy JTF_NUMBER_TABLE
118: , a6 out nocopy JTF_NUMBER_TABLE
111: );
112: procedure rosetta_table_copy_out_p8(t jtf_ih_pub.mlcs_tbl_type, a0 out nocopy JTF_DATE_TABLE
113: , a1 out nocopy JTF_VARCHAR2_TABLE_100
114: , a2 out nocopy JTF_NUMBER_TABLE
115: , a3 out nocopy JTF_NUMBER_TABLE
116: , a4 out nocopy JTF_DATE_TABLE
117: , a5 out nocopy JTF_NUMBER_TABLE
118: , a6 out nocopy JTF_NUMBER_TABLE
119: , a7 out nocopy JTF_NUMBER_TABLE
113: , a1 out nocopy JTF_VARCHAR2_TABLE_100
114: , a2 out nocopy JTF_NUMBER_TABLE
115: , a3 out nocopy JTF_NUMBER_TABLE
116: , a4 out nocopy JTF_DATE_TABLE
117: , a5 out nocopy JTF_NUMBER_TABLE
118: , a6 out nocopy JTF_NUMBER_TABLE
119: , a7 out nocopy JTF_NUMBER_TABLE
120: , a8 out nocopy JTF_NUMBER_TABLE
121: , a9 out nocopy JTF_NUMBER_TABLE
114: , a2 out nocopy JTF_NUMBER_TABLE
115: , a3 out nocopy JTF_NUMBER_TABLE
116: , a4 out nocopy JTF_DATE_TABLE
117: , a5 out nocopy JTF_NUMBER_TABLE
118: , a6 out nocopy JTF_NUMBER_TABLE
119: , a7 out nocopy JTF_NUMBER_TABLE
120: , a8 out nocopy JTF_NUMBER_TABLE
121: , a9 out nocopy JTF_NUMBER_TABLE
122: , a10 out nocopy JTF_VARCHAR2_TABLE_100
115: , a3 out nocopy JTF_NUMBER_TABLE
116: , a4 out nocopy JTF_DATE_TABLE
117: , a5 out nocopy JTF_NUMBER_TABLE
118: , a6 out nocopy JTF_NUMBER_TABLE
119: , a7 out nocopy JTF_NUMBER_TABLE
120: , a8 out nocopy JTF_NUMBER_TABLE
121: , a9 out nocopy JTF_NUMBER_TABLE
122: , a10 out nocopy JTF_VARCHAR2_TABLE_100
123: , a11 out nocopy JTF_VARCHAR2_TABLE_300
116: , a4 out nocopy JTF_DATE_TABLE
117: , a5 out nocopy JTF_NUMBER_TABLE
118: , a6 out nocopy JTF_NUMBER_TABLE
119: , a7 out nocopy JTF_NUMBER_TABLE
120: , a8 out nocopy JTF_NUMBER_TABLE
121: , a9 out nocopy JTF_NUMBER_TABLE
122: , a10 out nocopy JTF_VARCHAR2_TABLE_100
123: , a11 out nocopy JTF_VARCHAR2_TABLE_300
124: , a12 out nocopy JTF_VARCHAR2_TABLE_300
117: , a5 out nocopy JTF_NUMBER_TABLE
118: , a6 out nocopy JTF_NUMBER_TABLE
119: , a7 out nocopy JTF_NUMBER_TABLE
120: , a8 out nocopy JTF_NUMBER_TABLE
121: , a9 out nocopy JTF_NUMBER_TABLE
122: , a10 out nocopy JTF_VARCHAR2_TABLE_100
123: , a11 out nocopy JTF_VARCHAR2_TABLE_300
124: , a12 out nocopy JTF_VARCHAR2_TABLE_300
125: , a13 out nocopy JTF_NUMBER_TABLE
121: , a9 out nocopy JTF_NUMBER_TABLE
122: , a10 out nocopy JTF_VARCHAR2_TABLE_100
123: , a11 out nocopy JTF_VARCHAR2_TABLE_300
124: , a12 out nocopy JTF_VARCHAR2_TABLE_300
125: , a13 out nocopy JTF_NUMBER_TABLE
126: , a14 out nocopy JTF_NUMBER_TABLE
127: );
128:
129: procedure create_interaction(p_api_version NUMBER
122: , a10 out nocopy JTF_VARCHAR2_TABLE_100
123: , a11 out nocopy JTF_VARCHAR2_TABLE_300
124: , a12 out nocopy JTF_VARCHAR2_TABLE_300
125: , a13 out nocopy JTF_NUMBER_TABLE
126: , a14 out nocopy JTF_NUMBER_TABLE
127: );
128:
129: procedure create_interaction(p_api_version NUMBER
130: , p_init_msg_list VARCHAR2
135: , p_login_id NUMBER
136: , x_return_status out nocopy VARCHAR2
137: , x_msg_count out nocopy NUMBER
138: , x_msg_data out nocopy VARCHAR2
139: , p11_a0 JTF_NUMBER_TABLE
140: , p11_a1 JTF_NUMBER_TABLE
141: , p11_a2 JTF_NUMBER_TABLE
142: , p11_a3 JTF_NUMBER_TABLE
143: , p11_a4 JTF_VARCHAR2_TABLE_300
136: , x_return_status out nocopy VARCHAR2
137: , x_msg_count out nocopy NUMBER
138: , x_msg_data out nocopy VARCHAR2
139: , p11_a0 JTF_NUMBER_TABLE
140: , p11_a1 JTF_NUMBER_TABLE
141: , p11_a2 JTF_NUMBER_TABLE
142: , p11_a3 JTF_NUMBER_TABLE
143: , p11_a4 JTF_VARCHAR2_TABLE_300
144: , p11_a5 JTF_DATE_TABLE
137: , x_msg_count out nocopy NUMBER
138: , x_msg_data out nocopy VARCHAR2
139: , p11_a0 JTF_NUMBER_TABLE
140: , p11_a1 JTF_NUMBER_TABLE
141: , p11_a2 JTF_NUMBER_TABLE
142: , p11_a3 JTF_NUMBER_TABLE
143: , p11_a4 JTF_VARCHAR2_TABLE_300
144: , p11_a5 JTF_DATE_TABLE
145: , p11_a6 JTF_DATE_TABLE
138: , x_msg_data out nocopy VARCHAR2
139: , p11_a0 JTF_NUMBER_TABLE
140: , p11_a1 JTF_NUMBER_TABLE
141: , p11_a2 JTF_NUMBER_TABLE
142: , p11_a3 JTF_NUMBER_TABLE
143: , p11_a4 JTF_VARCHAR2_TABLE_300
144: , p11_a5 JTF_DATE_TABLE
145: , p11_a6 JTF_DATE_TABLE
146: , p11_a7 JTF_NUMBER_TABLE
142: , p11_a3 JTF_NUMBER_TABLE
143: , p11_a4 JTF_VARCHAR2_TABLE_300
144: , p11_a5 JTF_DATE_TABLE
145: , p11_a6 JTF_DATE_TABLE
146: , p11_a7 JTF_NUMBER_TABLE
147: , p11_a8 JTF_NUMBER_TABLE
148: , p11_a9 JTF_VARCHAR2_TABLE_100
149: , p11_a10 JTF_VARCHAR2_TABLE_100
150: , p11_a11 JTF_NUMBER_TABLE
143: , p11_a4 JTF_VARCHAR2_TABLE_300
144: , p11_a5 JTF_DATE_TABLE
145: , p11_a6 JTF_DATE_TABLE
146: , p11_a7 JTF_NUMBER_TABLE
147: , p11_a8 JTF_NUMBER_TABLE
148: , p11_a9 JTF_VARCHAR2_TABLE_100
149: , p11_a10 JTF_VARCHAR2_TABLE_100
150: , p11_a11 JTF_NUMBER_TABLE
151: , p11_a12 JTF_NUMBER_TABLE
146: , p11_a7 JTF_NUMBER_TABLE
147: , p11_a8 JTF_NUMBER_TABLE
148: , p11_a9 JTF_VARCHAR2_TABLE_100
149: , p11_a10 JTF_VARCHAR2_TABLE_100
150: , p11_a11 JTF_NUMBER_TABLE
151: , p11_a12 JTF_NUMBER_TABLE
152: , p11_a13 JTF_NUMBER_TABLE
153: , p11_a14 JTF_NUMBER_TABLE
154: , p11_a15 JTF_NUMBER_TABLE
147: , p11_a8 JTF_NUMBER_TABLE
148: , p11_a9 JTF_VARCHAR2_TABLE_100
149: , p11_a10 JTF_VARCHAR2_TABLE_100
150: , p11_a11 JTF_NUMBER_TABLE
151: , p11_a12 JTF_NUMBER_TABLE
152: , p11_a13 JTF_NUMBER_TABLE
153: , p11_a14 JTF_NUMBER_TABLE
154: , p11_a15 JTF_NUMBER_TABLE
155: , p11_a16 JTF_NUMBER_TABLE
148: , p11_a9 JTF_VARCHAR2_TABLE_100
149: , p11_a10 JTF_VARCHAR2_TABLE_100
150: , p11_a11 JTF_NUMBER_TABLE
151: , p11_a12 JTF_NUMBER_TABLE
152: , p11_a13 JTF_NUMBER_TABLE
153: , p11_a14 JTF_NUMBER_TABLE
154: , p11_a15 JTF_NUMBER_TABLE
155: , p11_a16 JTF_NUMBER_TABLE
156: , p11_a17 JTF_VARCHAR2_TABLE_1000
149: , p11_a10 JTF_VARCHAR2_TABLE_100
150: , p11_a11 JTF_NUMBER_TABLE
151: , p11_a12 JTF_NUMBER_TABLE
152: , p11_a13 JTF_NUMBER_TABLE
153: , p11_a14 JTF_NUMBER_TABLE
154: , p11_a15 JTF_NUMBER_TABLE
155: , p11_a16 JTF_NUMBER_TABLE
156: , p11_a17 JTF_VARCHAR2_TABLE_1000
157: , p11_a18 JTF_NUMBER_TABLE
150: , p11_a11 JTF_NUMBER_TABLE
151: , p11_a12 JTF_NUMBER_TABLE
152: , p11_a13 JTF_NUMBER_TABLE
153: , p11_a14 JTF_NUMBER_TABLE
154: , p11_a15 JTF_NUMBER_TABLE
155: , p11_a16 JTF_NUMBER_TABLE
156: , p11_a17 JTF_VARCHAR2_TABLE_1000
157: , p11_a18 JTF_NUMBER_TABLE
158: , p11_a19 JTF_VARCHAR2_TABLE_300
151: , p11_a12 JTF_NUMBER_TABLE
152: , p11_a13 JTF_NUMBER_TABLE
153: , p11_a14 JTF_NUMBER_TABLE
154: , p11_a15 JTF_NUMBER_TABLE
155: , p11_a16 JTF_NUMBER_TABLE
156: , p11_a17 JTF_VARCHAR2_TABLE_1000
157: , p11_a18 JTF_NUMBER_TABLE
158: , p11_a19 JTF_VARCHAR2_TABLE_300
159: , p11_a20 JTF_NUMBER_TABLE
153: , p11_a14 JTF_NUMBER_TABLE
154: , p11_a15 JTF_NUMBER_TABLE
155: , p11_a16 JTF_NUMBER_TABLE
156: , p11_a17 JTF_VARCHAR2_TABLE_1000
157: , p11_a18 JTF_NUMBER_TABLE
158: , p11_a19 JTF_VARCHAR2_TABLE_300
159: , p11_a20 JTF_NUMBER_TABLE
160: , p11_a21 JTF_VARCHAR2_TABLE_100
161: , p11_a22 JTF_NUMBER_TABLE
155: , p11_a16 JTF_NUMBER_TABLE
156: , p11_a17 JTF_VARCHAR2_TABLE_1000
157: , p11_a18 JTF_NUMBER_TABLE
158: , p11_a19 JTF_VARCHAR2_TABLE_300
159: , p11_a20 JTF_NUMBER_TABLE
160: , p11_a21 JTF_VARCHAR2_TABLE_100
161: , p11_a22 JTF_NUMBER_TABLE
162: , p11_a23 JTF_VARCHAR2_TABLE_100
163: , p11_a24 JTF_NUMBER_TABLE
157: , p11_a18 JTF_NUMBER_TABLE
158: , p11_a19 JTF_VARCHAR2_TABLE_300
159: , p11_a20 JTF_NUMBER_TABLE
160: , p11_a21 JTF_VARCHAR2_TABLE_100
161: , p11_a22 JTF_NUMBER_TABLE
162: , p11_a23 JTF_VARCHAR2_TABLE_100
163: , p11_a24 JTF_NUMBER_TABLE
164: , p11_a25 JTF_VARCHAR2_TABLE_200
165: , p11_a26 JTF_VARCHAR2_TABLE_200
159: , p11_a20 JTF_NUMBER_TABLE
160: , p11_a21 JTF_VARCHAR2_TABLE_100
161: , p11_a22 JTF_NUMBER_TABLE
162: , p11_a23 JTF_VARCHAR2_TABLE_100
163: , p11_a24 JTF_NUMBER_TABLE
164: , p11_a25 JTF_VARCHAR2_TABLE_200
165: , p11_a26 JTF_VARCHAR2_TABLE_200
166: , p11_a27 JTF_VARCHAR2_TABLE_200
167: , p11_a28 JTF_VARCHAR2_TABLE_200
178: , p11_a39 JTF_VARCHAR2_TABLE_200
179: , p11_a40 JTF_VARCHAR2_TABLE_100
180: , p11_a41 JTF_VARCHAR2_TABLE_300
181: , p11_a42 JTF_VARCHAR2_TABLE_300
182: , p11_a43 JTF_NUMBER_TABLE
183: , p11_a44 JTF_NUMBER_TABLE
184: , p10_a0 NUMBER := 0-1962.0724
185: , p10_a1 VARCHAR2 := fnd_api.g_miss_char
186: , p10_a2 VARCHAR2 := fnd_api.g_miss_char
179: , p11_a40 JTF_VARCHAR2_TABLE_100
180: , p11_a41 JTF_VARCHAR2_TABLE_300
181: , p11_a42 JTF_VARCHAR2_TABLE_300
182: , p11_a43 JTF_NUMBER_TABLE
183: , p11_a44 JTF_NUMBER_TABLE
184: , p10_a0 NUMBER := 0-1962.0724
185: , p10_a1 VARCHAR2 := fnd_api.g_miss_char
186: , p10_a2 VARCHAR2 := fnd_api.g_miss_char
187: , p10_a3 NUMBER := 0-1962.0724
242: , x_msg_count out nocopy NUMBER
243: , x_msg_data out nocopy VARCHAR2
244: , p11_a0 JTF_DATE_TABLE
245: , p11_a1 JTF_VARCHAR2_TABLE_100
246: , p11_a2 JTF_NUMBER_TABLE
247: , p11_a3 JTF_NUMBER_TABLE
248: , p11_a4 JTF_DATE_TABLE
249: , p11_a5 JTF_NUMBER_TABLE
250: , p11_a6 JTF_NUMBER_TABLE
243: , x_msg_data out nocopy VARCHAR2
244: , p11_a0 JTF_DATE_TABLE
245: , p11_a1 JTF_VARCHAR2_TABLE_100
246: , p11_a2 JTF_NUMBER_TABLE
247: , p11_a3 JTF_NUMBER_TABLE
248: , p11_a4 JTF_DATE_TABLE
249: , p11_a5 JTF_NUMBER_TABLE
250: , p11_a6 JTF_NUMBER_TABLE
251: , p11_a7 JTF_NUMBER_TABLE
245: , p11_a1 JTF_VARCHAR2_TABLE_100
246: , p11_a2 JTF_NUMBER_TABLE
247: , p11_a3 JTF_NUMBER_TABLE
248: , p11_a4 JTF_DATE_TABLE
249: , p11_a5 JTF_NUMBER_TABLE
250: , p11_a6 JTF_NUMBER_TABLE
251: , p11_a7 JTF_NUMBER_TABLE
252: , p11_a8 JTF_NUMBER_TABLE
253: , p11_a9 JTF_NUMBER_TABLE
246: , p11_a2 JTF_NUMBER_TABLE
247: , p11_a3 JTF_NUMBER_TABLE
248: , p11_a4 JTF_DATE_TABLE
249: , p11_a5 JTF_NUMBER_TABLE
250: , p11_a6 JTF_NUMBER_TABLE
251: , p11_a7 JTF_NUMBER_TABLE
252: , p11_a8 JTF_NUMBER_TABLE
253: , p11_a9 JTF_NUMBER_TABLE
254: , p11_a10 JTF_VARCHAR2_TABLE_100
247: , p11_a3 JTF_NUMBER_TABLE
248: , p11_a4 JTF_DATE_TABLE
249: , p11_a5 JTF_NUMBER_TABLE
250: , p11_a6 JTF_NUMBER_TABLE
251: , p11_a7 JTF_NUMBER_TABLE
252: , p11_a8 JTF_NUMBER_TABLE
253: , p11_a9 JTF_NUMBER_TABLE
254: , p11_a10 JTF_VARCHAR2_TABLE_100
255: , p11_a11 JTF_VARCHAR2_TABLE_300
248: , p11_a4 JTF_DATE_TABLE
249: , p11_a5 JTF_NUMBER_TABLE
250: , p11_a6 JTF_NUMBER_TABLE
251: , p11_a7 JTF_NUMBER_TABLE
252: , p11_a8 JTF_NUMBER_TABLE
253: , p11_a9 JTF_NUMBER_TABLE
254: , p11_a10 JTF_VARCHAR2_TABLE_100
255: , p11_a11 JTF_VARCHAR2_TABLE_300
256: , p11_a12 JTF_VARCHAR2_TABLE_300
249: , p11_a5 JTF_NUMBER_TABLE
250: , p11_a6 JTF_NUMBER_TABLE
251: , p11_a7 JTF_NUMBER_TABLE
252: , p11_a8 JTF_NUMBER_TABLE
253: , p11_a9 JTF_NUMBER_TABLE
254: , p11_a10 JTF_VARCHAR2_TABLE_100
255: , p11_a11 JTF_VARCHAR2_TABLE_300
256: , p11_a12 JTF_VARCHAR2_TABLE_300
257: , p11_a13 JTF_NUMBER_TABLE
253: , p11_a9 JTF_NUMBER_TABLE
254: , p11_a10 JTF_VARCHAR2_TABLE_100
255: , p11_a11 JTF_VARCHAR2_TABLE_300
256: , p11_a12 JTF_VARCHAR2_TABLE_300
257: , p11_a13 JTF_NUMBER_TABLE
258: , p11_a14 JTF_NUMBER_TABLE
259: , p10_a0 NUMBER := 0-1962.0724
260: , p10_a1 NUMBER := 0-1962.0724
261: , p10_a2 VARCHAR2 := fnd_api.g_miss_char
254: , p11_a10 JTF_VARCHAR2_TABLE_100
255: , p11_a11 JTF_VARCHAR2_TABLE_300
256: , p11_a12 JTF_VARCHAR2_TABLE_300
257: , p11_a13 JTF_NUMBER_TABLE
258: , p11_a14 JTF_NUMBER_TABLE
259: , p10_a0 NUMBER := 0-1962.0724
260: , p10_a1 NUMBER := 0-1962.0724
261: , p10_a2 VARCHAR2 := fnd_api.g_miss_char
262: , p10_a3 NUMBER := 0-1962.0724