1: package ahl_vwp_visits_pvt_w as
2: /* $Header: AHLWVSTS.pls 120.2 2007/12/18 09:56:58 sowsubra ship $ */
3: procedure rosetta_table_copy_in_p3(t out nocopy ahl_vwp_visits_pvt.visit_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_DATE_TABLE
1: package ahl_vwp_visits_pvt_w as
2: /* $Header: AHLWVSTS.pls 120.2 2007/12/18 09:56:58 sowsubra ship $ */
3: procedure rosetta_table_copy_in_p3(t out nocopy ahl_vwp_visits_pvt.visit_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_DATE_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_DATE_TABLE
2: /* $Header: AHLWVSTS.pls 120.2 2007/12/18 09:56:58 sowsubra ship $ */
3: procedure rosetta_table_copy_in_p3(t out nocopy ahl_vwp_visits_pvt.visit_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_DATE_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_DATE_TABLE
10: , a7 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_DATE_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_DATE_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_DATE_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_DATE_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_VARCHAR2_TABLE_300
14: , a11 JTF_NUMBER_TABLE
7: , a4 JTF_DATE_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_DATE_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_VARCHAR2_TABLE_300
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_VARCHAR2_TABLE_300
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_DATE_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_VARCHAR2_TABLE_300
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_VARCHAR2_TABLE_300
16: , a13 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_VARCHAR2_TABLE_300
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_VARCHAR2_TABLE_300
16: , a13 JTF_NUMBER_TABLE
17: , a14 JTF_VARCHAR2_TABLE_100
18: , a15 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_VARCHAR2_TABLE_300
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_VARCHAR2_TABLE_300
16: , a13 JTF_NUMBER_TABLE
17: , a14 JTF_VARCHAR2_TABLE_100
18: , a15 JTF_VARCHAR2_TABLE_100
19: , a16 JTF_VARCHAR2_TABLE_100
20: , a17 JTF_DATE_TABLE
17: , a14 JTF_VARCHAR2_TABLE_100
18: , a15 JTF_VARCHAR2_TABLE_100
19: , a16 JTF_VARCHAR2_TABLE_100
20: , a17 JTF_DATE_TABLE
21: , a18 JTF_NUMBER_TABLE
22: , a19 JTF_NUMBER_TABLE
23: , a20 JTF_DATE_TABLE
24: , a21 JTF_NUMBER_TABLE
25: , a22 JTF_NUMBER_TABLE
18: , a15 JTF_VARCHAR2_TABLE_100
19: , a16 JTF_VARCHAR2_TABLE_100
20: , a17 JTF_DATE_TABLE
21: , a18 JTF_NUMBER_TABLE
22: , a19 JTF_NUMBER_TABLE
23: , a20 JTF_DATE_TABLE
24: , a21 JTF_NUMBER_TABLE
25: , a22 JTF_NUMBER_TABLE
26: , a23 JTF_DATE_TABLE
20: , a17 JTF_DATE_TABLE
21: , a18 JTF_NUMBER_TABLE
22: , a19 JTF_NUMBER_TABLE
23: , a20 JTF_DATE_TABLE
24: , a21 JTF_NUMBER_TABLE
25: , a22 JTF_NUMBER_TABLE
26: , a23 JTF_DATE_TABLE
27: , a24 JTF_DATE_TABLE
28: , a25 JTF_VARCHAR2_TABLE_100
21: , a18 JTF_NUMBER_TABLE
22: , a19 JTF_NUMBER_TABLE
23: , a20 JTF_DATE_TABLE
24: , a21 JTF_NUMBER_TABLE
25: , a22 JTF_NUMBER_TABLE
26: , a23 JTF_DATE_TABLE
27: , a24 JTF_DATE_TABLE
28: , a25 JTF_VARCHAR2_TABLE_100
29: , a26 JTF_VARCHAR2_TABLE_100
28: , a25 JTF_VARCHAR2_TABLE_100
29: , a26 JTF_VARCHAR2_TABLE_100
30: , a27 JTF_VARCHAR2_TABLE_100
31: , a28 JTF_VARCHAR2_TABLE_100
32: , a29 JTF_NUMBER_TABLE
33: , a30 JTF_VARCHAR2_TABLE_100
34: , a31 JTF_NUMBER_TABLE
35: , a32 JTF_VARCHAR2_TABLE_100
36: , a33 JTF_NUMBER_TABLE
30: , a27 JTF_VARCHAR2_TABLE_100
31: , a28 JTF_VARCHAR2_TABLE_100
32: , a29 JTF_NUMBER_TABLE
33: , a30 JTF_VARCHAR2_TABLE_100
34: , a31 JTF_NUMBER_TABLE
35: , a32 JTF_VARCHAR2_TABLE_100
36: , a33 JTF_NUMBER_TABLE
37: , a34 JTF_VARCHAR2_TABLE_100
38: , a35 JTF_NUMBER_TABLE
32: , a29 JTF_NUMBER_TABLE
33: , a30 JTF_VARCHAR2_TABLE_100
34: , a31 JTF_NUMBER_TABLE
35: , a32 JTF_VARCHAR2_TABLE_100
36: , a33 JTF_NUMBER_TABLE
37: , a34 JTF_VARCHAR2_TABLE_100
38: , a35 JTF_NUMBER_TABLE
39: , a36 JTF_NUMBER_TABLE
40: , a37 JTF_VARCHAR2_TABLE_100
34: , a31 JTF_NUMBER_TABLE
35: , a32 JTF_VARCHAR2_TABLE_100
36: , a33 JTF_NUMBER_TABLE
37: , a34 JTF_VARCHAR2_TABLE_100
38: , a35 JTF_NUMBER_TABLE
39: , a36 JTF_NUMBER_TABLE
40: , a37 JTF_VARCHAR2_TABLE_100
41: , a38 JTF_VARCHAR2_TABLE_100
42: , a39 JTF_VARCHAR2_TABLE_100
35: , a32 JTF_VARCHAR2_TABLE_100
36: , a33 JTF_NUMBER_TABLE
37: , a34 JTF_VARCHAR2_TABLE_100
38: , a35 JTF_NUMBER_TABLE
39: , a36 JTF_NUMBER_TABLE
40: , a37 JTF_VARCHAR2_TABLE_100
41: , a38 JTF_VARCHAR2_TABLE_100
42: , a39 JTF_VARCHAR2_TABLE_100
43: , a40 JTF_VARCHAR2_TABLE_100
42: , a39 JTF_VARCHAR2_TABLE_100
43: , a40 JTF_VARCHAR2_TABLE_100
44: , a41 JTF_VARCHAR2_TABLE_100
45: , a42 JTF_VARCHAR2_TABLE_100
46: , a43 JTF_NUMBER_TABLE
47: , a44 JTF_NUMBER_TABLE
48: , a45 JTF_VARCHAR2_TABLE_4000
49: , a46 JTF_NUMBER_TABLE
50: , a47 JTF_VARCHAR2_TABLE_100
43: , a40 JTF_VARCHAR2_TABLE_100
44: , a41 JTF_VARCHAR2_TABLE_100
45: , a42 JTF_VARCHAR2_TABLE_100
46: , a43 JTF_NUMBER_TABLE
47: , a44 JTF_NUMBER_TABLE
48: , a45 JTF_VARCHAR2_TABLE_4000
49: , a46 JTF_NUMBER_TABLE
50: , a47 JTF_VARCHAR2_TABLE_100
51: , a48 JTF_VARCHAR2_TABLE_200
45: , a42 JTF_VARCHAR2_TABLE_100
46: , a43 JTF_NUMBER_TABLE
47: , a44 JTF_NUMBER_TABLE
48: , a45 JTF_VARCHAR2_TABLE_4000
49: , a46 JTF_NUMBER_TABLE
50: , a47 JTF_VARCHAR2_TABLE_100
51: , a48 JTF_VARCHAR2_TABLE_200
52: , a49 JTF_VARCHAR2_TABLE_200
53: , a50 JTF_VARCHAR2_TABLE_200
66: , a63 JTF_VARCHAR2_TABLE_100
67: , a64 JTF_VARCHAR2_TABLE_100
68: , a65 JTF_VARCHAR2_TABLE_300
69: , a66 JTF_VARCHAR2_TABLE_100
70: , a67 JTF_NUMBER_TABLE
71: , a68 JTF_VARCHAR2_TABLE_100
72: , a69 JTF_VARCHAR2_TABLE_100
73: , a70 JTF_NUMBER_TABLE
74: , a71 JTF_VARCHAR2_TABLE_100
69: , a66 JTF_VARCHAR2_TABLE_100
70: , a67 JTF_NUMBER_TABLE
71: , a68 JTF_VARCHAR2_TABLE_100
72: , a69 JTF_VARCHAR2_TABLE_100
73: , a70 JTF_NUMBER_TABLE
74: , a71 JTF_VARCHAR2_TABLE_100
75: , a72 JTF_VARCHAR2_TABLE_100
76: , a73 JTF_NUMBER_TABLE
77: , a74 JTF_VARCHAR2_TABLE_100
72: , a69 JTF_VARCHAR2_TABLE_100
73: , a70 JTF_NUMBER_TABLE
74: , a71 JTF_VARCHAR2_TABLE_100
75: , a72 JTF_VARCHAR2_TABLE_100
76: , a73 JTF_NUMBER_TABLE
77: , a74 JTF_VARCHAR2_TABLE_100
78: , a75 JTF_VARCHAR2_TABLE_100
79: , a76 JTF_VARCHAR2_TABLE_300
80: , a77 JTF_NUMBER_TABLE
76: , a73 JTF_NUMBER_TABLE
77: , a74 JTF_VARCHAR2_TABLE_100
78: , a75 JTF_VARCHAR2_TABLE_100
79: , a76 JTF_VARCHAR2_TABLE_300
80: , a77 JTF_NUMBER_TABLE
81: );
82: procedure rosetta_table_copy_out_p3(t ahl_vwp_visits_pvt.visit_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
83: , a1 out nocopy JTF_VARCHAR2_TABLE_100
84: , a2 out nocopy JTF_NUMBER_TABLE
78: , a75 JTF_VARCHAR2_TABLE_100
79: , a76 JTF_VARCHAR2_TABLE_300
80: , a77 JTF_NUMBER_TABLE
81: );
82: procedure rosetta_table_copy_out_p3(t ahl_vwp_visits_pvt.visit_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
83: , a1 out nocopy JTF_VARCHAR2_TABLE_100
84: , a2 out nocopy JTF_NUMBER_TABLE
85: , a3 out nocopy JTF_NUMBER_TABLE
86: , a4 out nocopy JTF_DATE_TABLE
80: , a77 JTF_NUMBER_TABLE
81: );
82: procedure rosetta_table_copy_out_p3(t ahl_vwp_visits_pvt.visit_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
83: , a1 out nocopy JTF_VARCHAR2_TABLE_100
84: , a2 out nocopy JTF_NUMBER_TABLE
85: , a3 out nocopy JTF_NUMBER_TABLE
86: , a4 out nocopy JTF_DATE_TABLE
87: , a5 out nocopy JTF_NUMBER_TABLE
88: , a6 out nocopy JTF_DATE_TABLE
81: );
82: procedure rosetta_table_copy_out_p3(t ahl_vwp_visits_pvt.visit_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
83: , a1 out nocopy JTF_VARCHAR2_TABLE_100
84: , a2 out nocopy JTF_NUMBER_TABLE
85: , a3 out nocopy JTF_NUMBER_TABLE
86: , a4 out nocopy JTF_DATE_TABLE
87: , a5 out nocopy JTF_NUMBER_TABLE
88: , a6 out nocopy JTF_DATE_TABLE
89: , a7 out nocopy JTF_NUMBER_TABLE
83: , a1 out nocopy JTF_VARCHAR2_TABLE_100
84: , a2 out nocopy JTF_NUMBER_TABLE
85: , a3 out nocopy JTF_NUMBER_TABLE
86: , a4 out nocopy JTF_DATE_TABLE
87: , a5 out nocopy JTF_NUMBER_TABLE
88: , a6 out nocopy JTF_DATE_TABLE
89: , a7 out nocopy JTF_NUMBER_TABLE
90: , a8 out nocopy JTF_NUMBER_TABLE
91: , a9 out nocopy JTF_NUMBER_TABLE
85: , a3 out nocopy JTF_NUMBER_TABLE
86: , a4 out nocopy JTF_DATE_TABLE
87: , a5 out nocopy JTF_NUMBER_TABLE
88: , a6 out nocopy JTF_DATE_TABLE
89: , a7 out nocopy JTF_NUMBER_TABLE
90: , a8 out nocopy JTF_NUMBER_TABLE
91: , a9 out nocopy JTF_NUMBER_TABLE
92: , a10 out nocopy JTF_VARCHAR2_TABLE_300
93: , a11 out nocopy JTF_NUMBER_TABLE
86: , a4 out nocopy JTF_DATE_TABLE
87: , a5 out nocopy JTF_NUMBER_TABLE
88: , a6 out nocopy JTF_DATE_TABLE
89: , a7 out nocopy JTF_NUMBER_TABLE
90: , a8 out nocopy JTF_NUMBER_TABLE
91: , a9 out nocopy JTF_NUMBER_TABLE
92: , a10 out nocopy JTF_VARCHAR2_TABLE_300
93: , a11 out nocopy JTF_NUMBER_TABLE
94: , a12 out nocopy JTF_VARCHAR2_TABLE_300
87: , a5 out nocopy JTF_NUMBER_TABLE
88: , a6 out nocopy JTF_DATE_TABLE
89: , a7 out nocopy JTF_NUMBER_TABLE
90: , a8 out nocopy JTF_NUMBER_TABLE
91: , a9 out nocopy JTF_NUMBER_TABLE
92: , a10 out nocopy JTF_VARCHAR2_TABLE_300
93: , a11 out nocopy JTF_NUMBER_TABLE
94: , a12 out nocopy JTF_VARCHAR2_TABLE_300
95: , a13 out nocopy JTF_NUMBER_TABLE
89: , a7 out nocopy JTF_NUMBER_TABLE
90: , a8 out nocopy JTF_NUMBER_TABLE
91: , a9 out nocopy JTF_NUMBER_TABLE
92: , a10 out nocopy JTF_VARCHAR2_TABLE_300
93: , a11 out nocopy JTF_NUMBER_TABLE
94: , a12 out nocopy JTF_VARCHAR2_TABLE_300
95: , a13 out nocopy JTF_NUMBER_TABLE
96: , a14 out nocopy JTF_VARCHAR2_TABLE_100
97: , a15 out nocopy JTF_VARCHAR2_TABLE_100
91: , a9 out nocopy JTF_NUMBER_TABLE
92: , a10 out nocopy JTF_VARCHAR2_TABLE_300
93: , a11 out nocopy JTF_NUMBER_TABLE
94: , a12 out nocopy JTF_VARCHAR2_TABLE_300
95: , a13 out nocopy JTF_NUMBER_TABLE
96: , a14 out nocopy JTF_VARCHAR2_TABLE_100
97: , a15 out nocopy JTF_VARCHAR2_TABLE_100
98: , a16 out nocopy JTF_VARCHAR2_TABLE_100
99: , a17 out nocopy JTF_DATE_TABLE
96: , a14 out nocopy JTF_VARCHAR2_TABLE_100
97: , a15 out nocopy JTF_VARCHAR2_TABLE_100
98: , a16 out nocopy JTF_VARCHAR2_TABLE_100
99: , a17 out nocopy JTF_DATE_TABLE
100: , a18 out nocopy JTF_NUMBER_TABLE
101: , a19 out nocopy JTF_NUMBER_TABLE
102: , a20 out nocopy JTF_DATE_TABLE
103: , a21 out nocopy JTF_NUMBER_TABLE
104: , a22 out nocopy JTF_NUMBER_TABLE
97: , a15 out nocopy JTF_VARCHAR2_TABLE_100
98: , a16 out nocopy JTF_VARCHAR2_TABLE_100
99: , a17 out nocopy JTF_DATE_TABLE
100: , a18 out nocopy JTF_NUMBER_TABLE
101: , a19 out nocopy JTF_NUMBER_TABLE
102: , a20 out nocopy JTF_DATE_TABLE
103: , a21 out nocopy JTF_NUMBER_TABLE
104: , a22 out nocopy JTF_NUMBER_TABLE
105: , a23 out nocopy JTF_DATE_TABLE
99: , a17 out nocopy JTF_DATE_TABLE
100: , a18 out nocopy JTF_NUMBER_TABLE
101: , a19 out nocopy JTF_NUMBER_TABLE
102: , a20 out nocopy JTF_DATE_TABLE
103: , a21 out nocopy JTF_NUMBER_TABLE
104: , a22 out nocopy JTF_NUMBER_TABLE
105: , a23 out nocopy JTF_DATE_TABLE
106: , a24 out nocopy JTF_DATE_TABLE
107: , a25 out nocopy JTF_VARCHAR2_TABLE_100
100: , a18 out nocopy JTF_NUMBER_TABLE
101: , a19 out nocopy JTF_NUMBER_TABLE
102: , a20 out nocopy JTF_DATE_TABLE
103: , a21 out nocopy JTF_NUMBER_TABLE
104: , a22 out nocopy JTF_NUMBER_TABLE
105: , a23 out nocopy JTF_DATE_TABLE
106: , a24 out nocopy JTF_DATE_TABLE
107: , a25 out nocopy JTF_VARCHAR2_TABLE_100
108: , a26 out nocopy JTF_VARCHAR2_TABLE_100
107: , a25 out nocopy JTF_VARCHAR2_TABLE_100
108: , a26 out nocopy JTF_VARCHAR2_TABLE_100
109: , a27 out nocopy JTF_VARCHAR2_TABLE_100
110: , a28 out nocopy JTF_VARCHAR2_TABLE_100
111: , a29 out nocopy JTF_NUMBER_TABLE
112: , a30 out nocopy JTF_VARCHAR2_TABLE_100
113: , a31 out nocopy JTF_NUMBER_TABLE
114: , a32 out nocopy JTF_VARCHAR2_TABLE_100
115: , a33 out nocopy JTF_NUMBER_TABLE
109: , a27 out nocopy JTF_VARCHAR2_TABLE_100
110: , a28 out nocopy JTF_VARCHAR2_TABLE_100
111: , a29 out nocopy JTF_NUMBER_TABLE
112: , a30 out nocopy JTF_VARCHAR2_TABLE_100
113: , a31 out nocopy JTF_NUMBER_TABLE
114: , a32 out nocopy JTF_VARCHAR2_TABLE_100
115: , a33 out nocopy JTF_NUMBER_TABLE
116: , a34 out nocopy JTF_VARCHAR2_TABLE_100
117: , a35 out nocopy JTF_NUMBER_TABLE
111: , a29 out nocopy JTF_NUMBER_TABLE
112: , a30 out nocopy JTF_VARCHAR2_TABLE_100
113: , a31 out nocopy JTF_NUMBER_TABLE
114: , a32 out nocopy JTF_VARCHAR2_TABLE_100
115: , a33 out nocopy JTF_NUMBER_TABLE
116: , a34 out nocopy JTF_VARCHAR2_TABLE_100
117: , a35 out nocopy JTF_NUMBER_TABLE
118: , a36 out nocopy JTF_NUMBER_TABLE
119: , a37 out nocopy JTF_VARCHAR2_TABLE_100
113: , a31 out nocopy JTF_NUMBER_TABLE
114: , a32 out nocopy JTF_VARCHAR2_TABLE_100
115: , a33 out nocopy JTF_NUMBER_TABLE
116: , a34 out nocopy JTF_VARCHAR2_TABLE_100
117: , a35 out nocopy JTF_NUMBER_TABLE
118: , a36 out nocopy JTF_NUMBER_TABLE
119: , a37 out nocopy JTF_VARCHAR2_TABLE_100
120: , a38 out nocopy JTF_VARCHAR2_TABLE_100
121: , a39 out nocopy JTF_VARCHAR2_TABLE_100
114: , a32 out nocopy JTF_VARCHAR2_TABLE_100
115: , a33 out nocopy JTF_NUMBER_TABLE
116: , a34 out nocopy JTF_VARCHAR2_TABLE_100
117: , a35 out nocopy JTF_NUMBER_TABLE
118: , a36 out nocopy JTF_NUMBER_TABLE
119: , a37 out nocopy JTF_VARCHAR2_TABLE_100
120: , a38 out nocopy JTF_VARCHAR2_TABLE_100
121: , a39 out nocopy JTF_VARCHAR2_TABLE_100
122: , a40 out nocopy JTF_VARCHAR2_TABLE_100
121: , a39 out nocopy JTF_VARCHAR2_TABLE_100
122: , a40 out nocopy JTF_VARCHAR2_TABLE_100
123: , a41 out nocopy JTF_VARCHAR2_TABLE_100
124: , a42 out nocopy JTF_VARCHAR2_TABLE_100
125: , a43 out nocopy JTF_NUMBER_TABLE
126: , a44 out nocopy JTF_NUMBER_TABLE
127: , a45 out nocopy JTF_VARCHAR2_TABLE_4000
128: , a46 out nocopy JTF_NUMBER_TABLE
129: , a47 out nocopy JTF_VARCHAR2_TABLE_100
122: , a40 out nocopy JTF_VARCHAR2_TABLE_100
123: , a41 out nocopy JTF_VARCHAR2_TABLE_100
124: , a42 out nocopy JTF_VARCHAR2_TABLE_100
125: , a43 out nocopy JTF_NUMBER_TABLE
126: , a44 out nocopy JTF_NUMBER_TABLE
127: , a45 out nocopy JTF_VARCHAR2_TABLE_4000
128: , a46 out nocopy JTF_NUMBER_TABLE
129: , a47 out nocopy JTF_VARCHAR2_TABLE_100
130: , a48 out nocopy JTF_VARCHAR2_TABLE_200
124: , a42 out nocopy JTF_VARCHAR2_TABLE_100
125: , a43 out nocopy JTF_NUMBER_TABLE
126: , a44 out nocopy JTF_NUMBER_TABLE
127: , a45 out nocopy JTF_VARCHAR2_TABLE_4000
128: , a46 out nocopy JTF_NUMBER_TABLE
129: , a47 out nocopy JTF_VARCHAR2_TABLE_100
130: , a48 out nocopy JTF_VARCHAR2_TABLE_200
131: , a49 out nocopy JTF_VARCHAR2_TABLE_200
132: , a50 out nocopy JTF_VARCHAR2_TABLE_200
145: , a63 out nocopy JTF_VARCHAR2_TABLE_100
146: , a64 out nocopy JTF_VARCHAR2_TABLE_100
147: , a65 out nocopy JTF_VARCHAR2_TABLE_300
148: , a66 out nocopy JTF_VARCHAR2_TABLE_100
149: , a67 out nocopy JTF_NUMBER_TABLE
150: , a68 out nocopy JTF_VARCHAR2_TABLE_100
151: , a69 out nocopy JTF_VARCHAR2_TABLE_100
152: , a70 out nocopy JTF_NUMBER_TABLE
153: , a71 out nocopy JTF_VARCHAR2_TABLE_100
148: , a66 out nocopy JTF_VARCHAR2_TABLE_100
149: , a67 out nocopy JTF_NUMBER_TABLE
150: , a68 out nocopy JTF_VARCHAR2_TABLE_100
151: , a69 out nocopy JTF_VARCHAR2_TABLE_100
152: , a70 out nocopy JTF_NUMBER_TABLE
153: , a71 out nocopy JTF_VARCHAR2_TABLE_100
154: , a72 out nocopy JTF_VARCHAR2_TABLE_100
155: , a73 out nocopy JTF_NUMBER_TABLE
156: , a74 out nocopy JTF_VARCHAR2_TABLE_100
151: , a69 out nocopy JTF_VARCHAR2_TABLE_100
152: , a70 out nocopy JTF_NUMBER_TABLE
153: , a71 out nocopy JTF_VARCHAR2_TABLE_100
154: , a72 out nocopy JTF_VARCHAR2_TABLE_100
155: , a73 out nocopy JTF_NUMBER_TABLE
156: , a74 out nocopy JTF_VARCHAR2_TABLE_100
157: , a75 out nocopy JTF_VARCHAR2_TABLE_100
158: , a76 out nocopy JTF_VARCHAR2_TABLE_300
159: , a77 out nocopy JTF_NUMBER_TABLE
155: , a73 out nocopy JTF_NUMBER_TABLE
156: , a74 out nocopy JTF_VARCHAR2_TABLE_100
157: , a75 out nocopy JTF_VARCHAR2_TABLE_100
158: , a76 out nocopy JTF_VARCHAR2_TABLE_300
159: , a77 out nocopy JTF_NUMBER_TABLE
160: );
161:
162: procedure rosetta_table_copy_in_p4(t out nocopy ahl_vwp_visits_pvt.error_tbl_type, a0 JTF_NUMBER_TABLE
163: , a1 JTF_VARCHAR2_TABLE_100
158: , a76 out nocopy JTF_VARCHAR2_TABLE_300
159: , a77 out nocopy JTF_NUMBER_TABLE
160: );
161:
162: procedure rosetta_table_copy_in_p4(t out nocopy ahl_vwp_visits_pvt.error_tbl_type, a0 JTF_NUMBER_TABLE
163: , a1 JTF_VARCHAR2_TABLE_100
164: , a2 JTF_VARCHAR2_TABLE_100
165: , a3 JTF_VARCHAR2_TABLE_100
166: , a4 JTF_VARCHAR2_TABLE_100
167: , a5 JTF_DATE_TABLE
168: , a6 JTF_DATE_TABLE
169: , a7 JTF_VARCHAR2_TABLE_100
170: );
171: procedure rosetta_table_copy_out_p4(t ahl_vwp_visits_pvt.error_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
172: , a1 out nocopy JTF_VARCHAR2_TABLE_100
173: , a2 out nocopy JTF_VARCHAR2_TABLE_100
174: , a3 out nocopy JTF_VARCHAR2_TABLE_100
175: , a4 out nocopy JTF_VARCHAR2_TABLE_100
182: , p_init_msg_list VARCHAR2
183: , p_commit VARCHAR2
184: , p_validation_level NUMBER
185: , p_module_type VARCHAR2
186: , p5_a0 in out nocopy JTF_NUMBER_TABLE
187: , p5_a1 in out nocopy JTF_VARCHAR2_TABLE_100
188: , p5_a2 in out nocopy JTF_NUMBER_TABLE
189: , p5_a3 in out nocopy JTF_NUMBER_TABLE
190: , p5_a4 in out nocopy JTF_DATE_TABLE
184: , p_validation_level NUMBER
185: , p_module_type VARCHAR2
186: , p5_a0 in out nocopy JTF_NUMBER_TABLE
187: , p5_a1 in out nocopy JTF_VARCHAR2_TABLE_100
188: , p5_a2 in out nocopy JTF_NUMBER_TABLE
189: , p5_a3 in out nocopy JTF_NUMBER_TABLE
190: , p5_a4 in out nocopy JTF_DATE_TABLE
191: , p5_a5 in out nocopy JTF_NUMBER_TABLE
192: , p5_a6 in out nocopy JTF_DATE_TABLE
185: , p_module_type VARCHAR2
186: , p5_a0 in out nocopy JTF_NUMBER_TABLE
187: , p5_a1 in out nocopy JTF_VARCHAR2_TABLE_100
188: , p5_a2 in out nocopy JTF_NUMBER_TABLE
189: , p5_a3 in out nocopy JTF_NUMBER_TABLE
190: , p5_a4 in out nocopy JTF_DATE_TABLE
191: , p5_a5 in out nocopy JTF_NUMBER_TABLE
192: , p5_a6 in out nocopy JTF_DATE_TABLE
193: , p5_a7 in out nocopy JTF_NUMBER_TABLE
187: , p5_a1 in out nocopy JTF_VARCHAR2_TABLE_100
188: , p5_a2 in out nocopy JTF_NUMBER_TABLE
189: , p5_a3 in out nocopy JTF_NUMBER_TABLE
190: , p5_a4 in out nocopy JTF_DATE_TABLE
191: , p5_a5 in out nocopy JTF_NUMBER_TABLE
192: , p5_a6 in out nocopy JTF_DATE_TABLE
193: , p5_a7 in out nocopy JTF_NUMBER_TABLE
194: , p5_a8 in out nocopy JTF_NUMBER_TABLE
195: , p5_a9 in out nocopy JTF_NUMBER_TABLE
189: , p5_a3 in out nocopy JTF_NUMBER_TABLE
190: , p5_a4 in out nocopy JTF_DATE_TABLE
191: , p5_a5 in out nocopy JTF_NUMBER_TABLE
192: , p5_a6 in out nocopy JTF_DATE_TABLE
193: , p5_a7 in out nocopy JTF_NUMBER_TABLE
194: , p5_a8 in out nocopy JTF_NUMBER_TABLE
195: , p5_a9 in out nocopy JTF_NUMBER_TABLE
196: , p5_a10 in out nocopy JTF_VARCHAR2_TABLE_300
197: , p5_a11 in out nocopy JTF_NUMBER_TABLE
190: , p5_a4 in out nocopy JTF_DATE_TABLE
191: , p5_a5 in out nocopy JTF_NUMBER_TABLE
192: , p5_a6 in out nocopy JTF_DATE_TABLE
193: , p5_a7 in out nocopy JTF_NUMBER_TABLE
194: , p5_a8 in out nocopy JTF_NUMBER_TABLE
195: , p5_a9 in out nocopy JTF_NUMBER_TABLE
196: , p5_a10 in out nocopy JTF_VARCHAR2_TABLE_300
197: , p5_a11 in out nocopy JTF_NUMBER_TABLE
198: , p5_a12 in out nocopy JTF_VARCHAR2_TABLE_300
191: , p5_a5 in out nocopy JTF_NUMBER_TABLE
192: , p5_a6 in out nocopy JTF_DATE_TABLE
193: , p5_a7 in out nocopy JTF_NUMBER_TABLE
194: , p5_a8 in out nocopy JTF_NUMBER_TABLE
195: , p5_a9 in out nocopy JTF_NUMBER_TABLE
196: , p5_a10 in out nocopy JTF_VARCHAR2_TABLE_300
197: , p5_a11 in out nocopy JTF_NUMBER_TABLE
198: , p5_a12 in out nocopy JTF_VARCHAR2_TABLE_300
199: , p5_a13 in out nocopy JTF_NUMBER_TABLE
193: , p5_a7 in out nocopy JTF_NUMBER_TABLE
194: , p5_a8 in out nocopy JTF_NUMBER_TABLE
195: , p5_a9 in out nocopy JTF_NUMBER_TABLE
196: , p5_a10 in out nocopy JTF_VARCHAR2_TABLE_300
197: , p5_a11 in out nocopy JTF_NUMBER_TABLE
198: , p5_a12 in out nocopy JTF_VARCHAR2_TABLE_300
199: , p5_a13 in out nocopy JTF_NUMBER_TABLE
200: , p5_a14 in out nocopy JTF_VARCHAR2_TABLE_100
201: , p5_a15 in out nocopy JTF_VARCHAR2_TABLE_100
195: , p5_a9 in out nocopy JTF_NUMBER_TABLE
196: , p5_a10 in out nocopy JTF_VARCHAR2_TABLE_300
197: , p5_a11 in out nocopy JTF_NUMBER_TABLE
198: , p5_a12 in out nocopy JTF_VARCHAR2_TABLE_300
199: , p5_a13 in out nocopy JTF_NUMBER_TABLE
200: , p5_a14 in out nocopy JTF_VARCHAR2_TABLE_100
201: , p5_a15 in out nocopy JTF_VARCHAR2_TABLE_100
202: , p5_a16 in out nocopy JTF_VARCHAR2_TABLE_100
203: , p5_a17 in out nocopy JTF_DATE_TABLE
200: , p5_a14 in out nocopy JTF_VARCHAR2_TABLE_100
201: , p5_a15 in out nocopy JTF_VARCHAR2_TABLE_100
202: , p5_a16 in out nocopy JTF_VARCHAR2_TABLE_100
203: , p5_a17 in out nocopy JTF_DATE_TABLE
204: , p5_a18 in out nocopy JTF_NUMBER_TABLE
205: , p5_a19 in out nocopy JTF_NUMBER_TABLE
206: , p5_a20 in out nocopy JTF_DATE_TABLE
207: , p5_a21 in out nocopy JTF_NUMBER_TABLE
208: , p5_a22 in out nocopy JTF_NUMBER_TABLE
201: , p5_a15 in out nocopy JTF_VARCHAR2_TABLE_100
202: , p5_a16 in out nocopy JTF_VARCHAR2_TABLE_100
203: , p5_a17 in out nocopy JTF_DATE_TABLE
204: , p5_a18 in out nocopy JTF_NUMBER_TABLE
205: , p5_a19 in out nocopy JTF_NUMBER_TABLE
206: , p5_a20 in out nocopy JTF_DATE_TABLE
207: , p5_a21 in out nocopy JTF_NUMBER_TABLE
208: , p5_a22 in out nocopy JTF_NUMBER_TABLE
209: , p5_a23 in out nocopy JTF_DATE_TABLE
203: , p5_a17 in out nocopy JTF_DATE_TABLE
204: , p5_a18 in out nocopy JTF_NUMBER_TABLE
205: , p5_a19 in out nocopy JTF_NUMBER_TABLE
206: , p5_a20 in out nocopy JTF_DATE_TABLE
207: , p5_a21 in out nocopy JTF_NUMBER_TABLE
208: , p5_a22 in out nocopy JTF_NUMBER_TABLE
209: , p5_a23 in out nocopy JTF_DATE_TABLE
210: , p5_a24 in out nocopy JTF_DATE_TABLE
211: , p5_a25 in out nocopy JTF_VARCHAR2_TABLE_100
204: , p5_a18 in out nocopy JTF_NUMBER_TABLE
205: , p5_a19 in out nocopy JTF_NUMBER_TABLE
206: , p5_a20 in out nocopy JTF_DATE_TABLE
207: , p5_a21 in out nocopy JTF_NUMBER_TABLE
208: , p5_a22 in out nocopy JTF_NUMBER_TABLE
209: , p5_a23 in out nocopy JTF_DATE_TABLE
210: , p5_a24 in out nocopy JTF_DATE_TABLE
211: , p5_a25 in out nocopy JTF_VARCHAR2_TABLE_100
212: , p5_a26 in out nocopy JTF_VARCHAR2_TABLE_100
211: , p5_a25 in out nocopy JTF_VARCHAR2_TABLE_100
212: , p5_a26 in out nocopy JTF_VARCHAR2_TABLE_100
213: , p5_a27 in out nocopy JTF_VARCHAR2_TABLE_100
214: , p5_a28 in out nocopy JTF_VARCHAR2_TABLE_100
215: , p5_a29 in out nocopy JTF_NUMBER_TABLE
216: , p5_a30 in out nocopy JTF_VARCHAR2_TABLE_100
217: , p5_a31 in out nocopy JTF_NUMBER_TABLE
218: , p5_a32 in out nocopy JTF_VARCHAR2_TABLE_100
219: , p5_a33 in out nocopy JTF_NUMBER_TABLE
213: , p5_a27 in out nocopy JTF_VARCHAR2_TABLE_100
214: , p5_a28 in out nocopy JTF_VARCHAR2_TABLE_100
215: , p5_a29 in out nocopy JTF_NUMBER_TABLE
216: , p5_a30 in out nocopy JTF_VARCHAR2_TABLE_100
217: , p5_a31 in out nocopy JTF_NUMBER_TABLE
218: , p5_a32 in out nocopy JTF_VARCHAR2_TABLE_100
219: , p5_a33 in out nocopy JTF_NUMBER_TABLE
220: , p5_a34 in out nocopy JTF_VARCHAR2_TABLE_100
221: , p5_a35 in out nocopy JTF_NUMBER_TABLE
215: , p5_a29 in out nocopy JTF_NUMBER_TABLE
216: , p5_a30 in out nocopy JTF_VARCHAR2_TABLE_100
217: , p5_a31 in out nocopy JTF_NUMBER_TABLE
218: , p5_a32 in out nocopy JTF_VARCHAR2_TABLE_100
219: , p5_a33 in out nocopy JTF_NUMBER_TABLE
220: , p5_a34 in out nocopy JTF_VARCHAR2_TABLE_100
221: , p5_a35 in out nocopy JTF_NUMBER_TABLE
222: , p5_a36 in out nocopy JTF_NUMBER_TABLE
223: , p5_a37 in out nocopy JTF_VARCHAR2_TABLE_100
217: , p5_a31 in out nocopy JTF_NUMBER_TABLE
218: , p5_a32 in out nocopy JTF_VARCHAR2_TABLE_100
219: , p5_a33 in out nocopy JTF_NUMBER_TABLE
220: , p5_a34 in out nocopy JTF_VARCHAR2_TABLE_100
221: , p5_a35 in out nocopy JTF_NUMBER_TABLE
222: , p5_a36 in out nocopy JTF_NUMBER_TABLE
223: , p5_a37 in out nocopy JTF_VARCHAR2_TABLE_100
224: , p5_a38 in out nocopy JTF_VARCHAR2_TABLE_100
225: , p5_a39 in out nocopy JTF_VARCHAR2_TABLE_100
218: , p5_a32 in out nocopy JTF_VARCHAR2_TABLE_100
219: , p5_a33 in out nocopy JTF_NUMBER_TABLE
220: , p5_a34 in out nocopy JTF_VARCHAR2_TABLE_100
221: , p5_a35 in out nocopy JTF_NUMBER_TABLE
222: , p5_a36 in out nocopy JTF_NUMBER_TABLE
223: , p5_a37 in out nocopy JTF_VARCHAR2_TABLE_100
224: , p5_a38 in out nocopy JTF_VARCHAR2_TABLE_100
225: , p5_a39 in out nocopy JTF_VARCHAR2_TABLE_100
226: , p5_a40 in out nocopy JTF_VARCHAR2_TABLE_100
225: , p5_a39 in out nocopy JTF_VARCHAR2_TABLE_100
226: , p5_a40 in out nocopy JTF_VARCHAR2_TABLE_100
227: , p5_a41 in out nocopy JTF_VARCHAR2_TABLE_100
228: , p5_a42 in out nocopy JTF_VARCHAR2_TABLE_100
229: , p5_a43 in out nocopy JTF_NUMBER_TABLE
230: , p5_a44 in out nocopy JTF_NUMBER_TABLE
231: , p5_a45 in out nocopy JTF_VARCHAR2_TABLE_4000
232: , p5_a46 in out nocopy JTF_NUMBER_TABLE
233: , p5_a47 in out nocopy JTF_VARCHAR2_TABLE_100
226: , p5_a40 in out nocopy JTF_VARCHAR2_TABLE_100
227: , p5_a41 in out nocopy JTF_VARCHAR2_TABLE_100
228: , p5_a42 in out nocopy JTF_VARCHAR2_TABLE_100
229: , p5_a43 in out nocopy JTF_NUMBER_TABLE
230: , p5_a44 in out nocopy JTF_NUMBER_TABLE
231: , p5_a45 in out nocopy JTF_VARCHAR2_TABLE_4000
232: , p5_a46 in out nocopy JTF_NUMBER_TABLE
233: , p5_a47 in out nocopy JTF_VARCHAR2_TABLE_100
234: , p5_a48 in out nocopy JTF_VARCHAR2_TABLE_200
228: , p5_a42 in out nocopy JTF_VARCHAR2_TABLE_100
229: , p5_a43 in out nocopy JTF_NUMBER_TABLE
230: , p5_a44 in out nocopy JTF_NUMBER_TABLE
231: , p5_a45 in out nocopy JTF_VARCHAR2_TABLE_4000
232: , p5_a46 in out nocopy JTF_NUMBER_TABLE
233: , p5_a47 in out nocopy JTF_VARCHAR2_TABLE_100
234: , p5_a48 in out nocopy JTF_VARCHAR2_TABLE_200
235: , p5_a49 in out nocopy JTF_VARCHAR2_TABLE_200
236: , p5_a50 in out nocopy JTF_VARCHAR2_TABLE_200
249: , p5_a63 in out nocopy JTF_VARCHAR2_TABLE_100
250: , p5_a64 in out nocopy JTF_VARCHAR2_TABLE_100
251: , p5_a65 in out nocopy JTF_VARCHAR2_TABLE_300
252: , p5_a66 in out nocopy JTF_VARCHAR2_TABLE_100
253: , p5_a67 in out nocopy JTF_NUMBER_TABLE
254: , p5_a68 in out nocopy JTF_VARCHAR2_TABLE_100
255: , p5_a69 in out nocopy JTF_VARCHAR2_TABLE_100
256: , p5_a70 in out nocopy JTF_NUMBER_TABLE
257: , p5_a71 in out nocopy JTF_VARCHAR2_TABLE_100
252: , p5_a66 in out nocopy JTF_VARCHAR2_TABLE_100
253: , p5_a67 in out nocopy JTF_NUMBER_TABLE
254: , p5_a68 in out nocopy JTF_VARCHAR2_TABLE_100
255: , p5_a69 in out nocopy JTF_VARCHAR2_TABLE_100
256: , p5_a70 in out nocopy JTF_NUMBER_TABLE
257: , p5_a71 in out nocopy JTF_VARCHAR2_TABLE_100
258: , p5_a72 in out nocopy JTF_VARCHAR2_TABLE_100
259: , p5_a73 in out nocopy JTF_NUMBER_TABLE
260: , p5_a74 in out nocopy JTF_VARCHAR2_TABLE_100
255: , p5_a69 in out nocopy JTF_VARCHAR2_TABLE_100
256: , p5_a70 in out nocopy JTF_NUMBER_TABLE
257: , p5_a71 in out nocopy JTF_VARCHAR2_TABLE_100
258: , p5_a72 in out nocopy JTF_VARCHAR2_TABLE_100
259: , p5_a73 in out nocopy JTF_NUMBER_TABLE
260: , p5_a74 in out nocopy JTF_VARCHAR2_TABLE_100
261: , p5_a75 in out nocopy JTF_VARCHAR2_TABLE_100
262: , p5_a76 in out nocopy JTF_VARCHAR2_TABLE_300
263: , p5_a77 in out nocopy JTF_NUMBER_TABLE
259: , p5_a73 in out nocopy JTF_NUMBER_TABLE
260: , p5_a74 in out nocopy JTF_VARCHAR2_TABLE_100
261: , p5_a75 in out nocopy JTF_VARCHAR2_TABLE_100
262: , p5_a76 in out nocopy JTF_VARCHAR2_TABLE_300
263: , p5_a77 in out nocopy JTF_NUMBER_TABLE
264: , x_return_status out nocopy VARCHAR2
265: , x_msg_count out nocopy NUMBER
266: , x_msg_data out nocopy VARCHAR2
267: );