APPS.AHL_VWP_VISITS_PVT_W dependencies on JTF_NUMBER_TABLE

Line 3: procedure rosetta_table_copy_in_p3(t out nocopy ahl_vwp_visits_pvt.visit_tbl_type, a0 JTF_NUMBER_TABLE

1: package ahl_vwp_visits_pvt_w AUTHID CURRENT_USER as
2: /* $Header: AHLWVSTS.pls 120.5.12020000.2 2012/12/11 06:00:50 prakkum 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

Line 5: , a2 JTF_NUMBER_TABLE

1: package ahl_vwp_visits_pvt_w AUTHID CURRENT_USER as
2: /* $Header: AHLWVSTS.pls 120.5.12020000.2 2012/12/11 06:00:50 prakkum 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

Line 6: , a3 JTF_NUMBER_TABLE

2: /* $Header: AHLWVSTS.pls 120.5.12020000.2 2012/12/11 06:00:50 prakkum 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

Line 8: , a5 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

Line 10: , a7 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

Line 11: , a8 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

Line 12: , a9 JTF_NUMBER_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
16: , a13 JTF_NUMBER_TABLE

Line 14: , a11 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

Line 16: , a13 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
19: , a16 JTF_VARCHAR2_TABLE_100
20: , a17 JTF_DATE_TABLE

Line 21: , a18 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
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

Line 22: , a19 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

Line 24: , a21 JTF_NUMBER_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

Line 25: , a22 JTF_NUMBER_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
29: , a26 JTF_VARCHAR2_TABLE_100

Line 32: , a29 JTF_NUMBER_TABLE

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

Line 34: , a31 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

Line 36: , a33 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

Line 38: , a35 JTF_NUMBER_TABLE

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

Line 39: , a36 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
43: , a40 JTF_VARCHAR2_TABLE_100

Line 46: , a43 JTF_NUMBER_TABLE

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

Line 47: , a44 JTF_NUMBER_TABLE

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

Line 49: , a46 JTF_NUMBER_TABLE

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

Line 70: , a67 JTF_NUMBER_TABLE

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

Line 73: , a70 JTF_NUMBER_TABLE

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

Line 76: , a73 JTF_NUMBER_TABLE

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_NUMBER_TABLE
80: , a77 JTF_VARCHAR2_TABLE_100

Line 79: , a76 JTF_NUMBER_TABLE

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_NUMBER_TABLE
80: , a77 JTF_VARCHAR2_TABLE_100
81: , a78 JTF_VARCHAR2_TABLE_300
82: , a79 JTF_NUMBER_TABLE
83: , a80 JTF_NUMBER_TABLE

Line 82: , a79 JTF_NUMBER_TABLE

78: , a75 JTF_VARCHAR2_TABLE_100
79: , a76 JTF_NUMBER_TABLE
80: , a77 JTF_VARCHAR2_TABLE_100
81: , a78 JTF_VARCHAR2_TABLE_300
82: , a79 JTF_NUMBER_TABLE
83: , a80 JTF_NUMBER_TABLE
84: , a81 JTF_VARCHAR2_TABLE_100
85: , a82 JTF_VARCHAR2_TABLE_100
86: , a83 JTF_DATE_TABLE

Line 83: , a80 JTF_NUMBER_TABLE

79: , a76 JTF_NUMBER_TABLE
80: , a77 JTF_VARCHAR2_TABLE_100
81: , a78 JTF_VARCHAR2_TABLE_300
82: , a79 JTF_NUMBER_TABLE
83: , a80 JTF_NUMBER_TABLE
84: , a81 JTF_VARCHAR2_TABLE_100
85: , a82 JTF_VARCHAR2_TABLE_100
86: , a83 JTF_DATE_TABLE
87: , a84 JTF_VARCHAR2_TABLE_100

Line 94: , a91 JTF_NUMBER_TABLE

90: , a87 JTF_VARCHAR2_TABLE_4000
91: , a88 JTF_VARCHAR2_TABLE_100
92: , a89 JTF_VARCHAR2_TABLE_100
93: , a90 JTF_VARCHAR2_TABLE_100
94: , a91 JTF_NUMBER_TABLE
95: , a92 JTF_NUMBER_TABLE
96: , a93 JTF_VARCHAR2_TABLE_100
97: , a94 JTF_VARCHAR2_TABLE_300
98: , a95 JTF_NUMBER_TABLE

Line 95: , a92 JTF_NUMBER_TABLE

91: , a88 JTF_VARCHAR2_TABLE_100
92: , a89 JTF_VARCHAR2_TABLE_100
93: , a90 JTF_VARCHAR2_TABLE_100
94: , a91 JTF_NUMBER_TABLE
95: , a92 JTF_NUMBER_TABLE
96: , a93 JTF_VARCHAR2_TABLE_100
97: , a94 JTF_VARCHAR2_TABLE_300
98: , a95 JTF_NUMBER_TABLE
99: , a96 JTF_VARCHAR2_TABLE_100

Line 98: , a95 JTF_NUMBER_TABLE

94: , a91 JTF_NUMBER_TABLE
95: , a92 JTF_NUMBER_TABLE
96: , a93 JTF_VARCHAR2_TABLE_100
97: , a94 JTF_VARCHAR2_TABLE_300
98: , a95 JTF_NUMBER_TABLE
99: , a96 JTF_VARCHAR2_TABLE_100
100: , a97 JTF_VARCHAR2_TABLE_300
101: , a98 JTF_NUMBER_TABLE
102: , a99 JTF_VARCHAR2_TABLE_100

Line 101: , a98 JTF_NUMBER_TABLE

97: , a94 JTF_VARCHAR2_TABLE_300
98: , a95 JTF_NUMBER_TABLE
99: , a96 JTF_VARCHAR2_TABLE_100
100: , a97 JTF_VARCHAR2_TABLE_300
101: , a98 JTF_NUMBER_TABLE
102: , a99 JTF_VARCHAR2_TABLE_100
103: , a100 JTF_VARCHAR2_TABLE_100
104: );
105: procedure rosetta_table_copy_out_p3(t ahl_vwp_visits_pvt.visit_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

Line 105: procedure rosetta_table_copy_out_p3(t ahl_vwp_visits_pvt.visit_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

101: , a98 JTF_NUMBER_TABLE
102: , a99 JTF_VARCHAR2_TABLE_100
103: , a100 JTF_VARCHAR2_TABLE_100
104: );
105: procedure rosetta_table_copy_out_p3(t ahl_vwp_visits_pvt.visit_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
106: , a1 out nocopy JTF_VARCHAR2_TABLE_100
107: , a2 out nocopy JTF_NUMBER_TABLE
108: , a3 out nocopy JTF_NUMBER_TABLE
109: , a4 out nocopy JTF_DATE_TABLE

Line 107: , a2 out nocopy JTF_NUMBER_TABLE

103: , a100 JTF_VARCHAR2_TABLE_100
104: );
105: procedure rosetta_table_copy_out_p3(t ahl_vwp_visits_pvt.visit_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
106: , a1 out nocopy JTF_VARCHAR2_TABLE_100
107: , a2 out nocopy JTF_NUMBER_TABLE
108: , a3 out nocopy JTF_NUMBER_TABLE
109: , a4 out nocopy JTF_DATE_TABLE
110: , a5 out nocopy JTF_NUMBER_TABLE
111: , a6 out nocopy JTF_DATE_TABLE

Line 108: , a3 out nocopy JTF_NUMBER_TABLE

104: );
105: procedure rosetta_table_copy_out_p3(t ahl_vwp_visits_pvt.visit_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
106: , a1 out nocopy JTF_VARCHAR2_TABLE_100
107: , a2 out nocopy JTF_NUMBER_TABLE
108: , a3 out nocopy JTF_NUMBER_TABLE
109: , a4 out nocopy JTF_DATE_TABLE
110: , a5 out nocopy JTF_NUMBER_TABLE
111: , a6 out nocopy JTF_DATE_TABLE
112: , a7 out nocopy JTF_NUMBER_TABLE

Line 110: , a5 out nocopy JTF_NUMBER_TABLE

106: , a1 out nocopy JTF_VARCHAR2_TABLE_100
107: , a2 out nocopy JTF_NUMBER_TABLE
108: , a3 out nocopy JTF_NUMBER_TABLE
109: , a4 out nocopy JTF_DATE_TABLE
110: , a5 out nocopy JTF_NUMBER_TABLE
111: , a6 out nocopy JTF_DATE_TABLE
112: , a7 out nocopy JTF_NUMBER_TABLE
113: , a8 out nocopy JTF_NUMBER_TABLE
114: , a9 out nocopy JTF_NUMBER_TABLE

Line 112: , a7 out nocopy JTF_NUMBER_TABLE

108: , a3 out nocopy JTF_NUMBER_TABLE
109: , a4 out nocopy JTF_DATE_TABLE
110: , a5 out nocopy JTF_NUMBER_TABLE
111: , a6 out nocopy JTF_DATE_TABLE
112: , a7 out nocopy JTF_NUMBER_TABLE
113: , a8 out nocopy JTF_NUMBER_TABLE
114: , a9 out nocopy JTF_NUMBER_TABLE
115: , a10 out nocopy JTF_VARCHAR2_TABLE_300
116: , a11 out nocopy JTF_NUMBER_TABLE

Line 113: , a8 out nocopy JTF_NUMBER_TABLE

109: , a4 out nocopy JTF_DATE_TABLE
110: , a5 out nocopy JTF_NUMBER_TABLE
111: , a6 out nocopy JTF_DATE_TABLE
112: , a7 out nocopy JTF_NUMBER_TABLE
113: , a8 out nocopy JTF_NUMBER_TABLE
114: , a9 out nocopy JTF_NUMBER_TABLE
115: , a10 out nocopy JTF_VARCHAR2_TABLE_300
116: , a11 out nocopy JTF_NUMBER_TABLE
117: , a12 out nocopy JTF_VARCHAR2_TABLE_300

Line 114: , a9 out nocopy JTF_NUMBER_TABLE

110: , a5 out nocopy JTF_NUMBER_TABLE
111: , a6 out nocopy JTF_DATE_TABLE
112: , a7 out nocopy JTF_NUMBER_TABLE
113: , a8 out nocopy JTF_NUMBER_TABLE
114: , a9 out nocopy JTF_NUMBER_TABLE
115: , a10 out nocopy JTF_VARCHAR2_TABLE_300
116: , a11 out nocopy JTF_NUMBER_TABLE
117: , a12 out nocopy JTF_VARCHAR2_TABLE_300
118: , a13 out nocopy JTF_NUMBER_TABLE

Line 116: , a11 out nocopy JTF_NUMBER_TABLE

112: , a7 out nocopy JTF_NUMBER_TABLE
113: , a8 out nocopy JTF_NUMBER_TABLE
114: , a9 out nocopy JTF_NUMBER_TABLE
115: , a10 out nocopy JTF_VARCHAR2_TABLE_300
116: , a11 out nocopy JTF_NUMBER_TABLE
117: , a12 out nocopy JTF_VARCHAR2_TABLE_300
118: , a13 out nocopy JTF_NUMBER_TABLE
119: , a14 out nocopy JTF_VARCHAR2_TABLE_100
120: , a15 out nocopy JTF_VARCHAR2_TABLE_100

Line 118: , a13 out nocopy JTF_NUMBER_TABLE

114: , a9 out nocopy JTF_NUMBER_TABLE
115: , a10 out nocopy JTF_VARCHAR2_TABLE_300
116: , a11 out nocopy JTF_NUMBER_TABLE
117: , a12 out nocopy JTF_VARCHAR2_TABLE_300
118: , a13 out nocopy JTF_NUMBER_TABLE
119: , a14 out nocopy JTF_VARCHAR2_TABLE_100
120: , a15 out nocopy JTF_VARCHAR2_TABLE_100
121: , a16 out nocopy JTF_VARCHAR2_TABLE_100
122: , a17 out nocopy JTF_DATE_TABLE

Line 123: , a18 out nocopy JTF_NUMBER_TABLE

119: , a14 out nocopy JTF_VARCHAR2_TABLE_100
120: , a15 out nocopy JTF_VARCHAR2_TABLE_100
121: , a16 out nocopy JTF_VARCHAR2_TABLE_100
122: , a17 out nocopy JTF_DATE_TABLE
123: , a18 out nocopy JTF_NUMBER_TABLE
124: , a19 out nocopy JTF_NUMBER_TABLE
125: , a20 out nocopy JTF_DATE_TABLE
126: , a21 out nocopy JTF_NUMBER_TABLE
127: , a22 out nocopy JTF_NUMBER_TABLE

Line 124: , a19 out nocopy JTF_NUMBER_TABLE

120: , a15 out nocopy JTF_VARCHAR2_TABLE_100
121: , a16 out nocopy JTF_VARCHAR2_TABLE_100
122: , a17 out nocopy JTF_DATE_TABLE
123: , a18 out nocopy JTF_NUMBER_TABLE
124: , a19 out nocopy JTF_NUMBER_TABLE
125: , a20 out nocopy JTF_DATE_TABLE
126: , a21 out nocopy JTF_NUMBER_TABLE
127: , a22 out nocopy JTF_NUMBER_TABLE
128: , a23 out nocopy JTF_DATE_TABLE

Line 126: , a21 out nocopy JTF_NUMBER_TABLE

122: , a17 out nocopy JTF_DATE_TABLE
123: , a18 out nocopy JTF_NUMBER_TABLE
124: , a19 out nocopy JTF_NUMBER_TABLE
125: , a20 out nocopy JTF_DATE_TABLE
126: , a21 out nocopy JTF_NUMBER_TABLE
127: , a22 out nocopy JTF_NUMBER_TABLE
128: , a23 out nocopy JTF_DATE_TABLE
129: , a24 out nocopy JTF_DATE_TABLE
130: , a25 out nocopy JTF_VARCHAR2_TABLE_100

Line 127: , a22 out nocopy JTF_NUMBER_TABLE

123: , a18 out nocopy JTF_NUMBER_TABLE
124: , a19 out nocopy JTF_NUMBER_TABLE
125: , a20 out nocopy JTF_DATE_TABLE
126: , a21 out nocopy JTF_NUMBER_TABLE
127: , a22 out nocopy JTF_NUMBER_TABLE
128: , a23 out nocopy JTF_DATE_TABLE
129: , a24 out nocopy JTF_DATE_TABLE
130: , a25 out nocopy JTF_VARCHAR2_TABLE_100
131: , a26 out nocopy JTF_VARCHAR2_TABLE_100

Line 134: , a29 out nocopy JTF_NUMBER_TABLE

130: , a25 out nocopy JTF_VARCHAR2_TABLE_100
131: , a26 out nocopy JTF_VARCHAR2_TABLE_100
132: , a27 out nocopy JTF_VARCHAR2_TABLE_100
133: , a28 out nocopy JTF_VARCHAR2_TABLE_100
134: , a29 out nocopy JTF_NUMBER_TABLE
135: , a30 out nocopy JTF_VARCHAR2_TABLE_100
136: , a31 out nocopy JTF_NUMBER_TABLE
137: , a32 out nocopy JTF_VARCHAR2_TABLE_100
138: , a33 out nocopy JTF_NUMBER_TABLE

Line 136: , a31 out nocopy JTF_NUMBER_TABLE

132: , a27 out nocopy JTF_VARCHAR2_TABLE_100
133: , a28 out nocopy JTF_VARCHAR2_TABLE_100
134: , a29 out nocopy JTF_NUMBER_TABLE
135: , a30 out nocopy JTF_VARCHAR2_TABLE_100
136: , a31 out nocopy JTF_NUMBER_TABLE
137: , a32 out nocopy JTF_VARCHAR2_TABLE_100
138: , a33 out nocopy JTF_NUMBER_TABLE
139: , a34 out nocopy JTF_VARCHAR2_TABLE_100
140: , a35 out nocopy JTF_NUMBER_TABLE

Line 138: , a33 out nocopy JTF_NUMBER_TABLE

134: , a29 out nocopy JTF_NUMBER_TABLE
135: , a30 out nocopy JTF_VARCHAR2_TABLE_100
136: , a31 out nocopy JTF_NUMBER_TABLE
137: , a32 out nocopy JTF_VARCHAR2_TABLE_100
138: , a33 out nocopy JTF_NUMBER_TABLE
139: , a34 out nocopy JTF_VARCHAR2_TABLE_100
140: , a35 out nocopy JTF_NUMBER_TABLE
141: , a36 out nocopy JTF_NUMBER_TABLE
142: , a37 out nocopy JTF_VARCHAR2_TABLE_100

Line 140: , a35 out nocopy JTF_NUMBER_TABLE

136: , a31 out nocopy JTF_NUMBER_TABLE
137: , a32 out nocopy JTF_VARCHAR2_TABLE_100
138: , a33 out nocopy JTF_NUMBER_TABLE
139: , a34 out nocopy JTF_VARCHAR2_TABLE_100
140: , a35 out nocopy JTF_NUMBER_TABLE
141: , a36 out nocopy JTF_NUMBER_TABLE
142: , a37 out nocopy JTF_VARCHAR2_TABLE_100
143: , a38 out nocopy JTF_VARCHAR2_TABLE_100
144: , a39 out nocopy JTF_VARCHAR2_TABLE_100

Line 141: , a36 out nocopy JTF_NUMBER_TABLE

137: , a32 out nocopy JTF_VARCHAR2_TABLE_100
138: , a33 out nocopy JTF_NUMBER_TABLE
139: , a34 out nocopy JTF_VARCHAR2_TABLE_100
140: , a35 out nocopy JTF_NUMBER_TABLE
141: , a36 out nocopy JTF_NUMBER_TABLE
142: , a37 out nocopy JTF_VARCHAR2_TABLE_100
143: , a38 out nocopy JTF_VARCHAR2_TABLE_100
144: , a39 out nocopy JTF_VARCHAR2_TABLE_100
145: , a40 out nocopy JTF_VARCHAR2_TABLE_100

Line 148: , a43 out nocopy JTF_NUMBER_TABLE

144: , a39 out nocopy JTF_VARCHAR2_TABLE_100
145: , a40 out nocopy JTF_VARCHAR2_TABLE_100
146: , a41 out nocopy JTF_VARCHAR2_TABLE_100
147: , a42 out nocopy JTF_VARCHAR2_TABLE_100
148: , a43 out nocopy JTF_NUMBER_TABLE
149: , a44 out nocopy JTF_NUMBER_TABLE
150: , a45 out nocopy JTF_VARCHAR2_TABLE_4000
151: , a46 out nocopy JTF_NUMBER_TABLE
152: , a47 out nocopy JTF_VARCHAR2_TABLE_100

Line 149: , a44 out nocopy JTF_NUMBER_TABLE

145: , a40 out nocopy JTF_VARCHAR2_TABLE_100
146: , a41 out nocopy JTF_VARCHAR2_TABLE_100
147: , a42 out nocopy JTF_VARCHAR2_TABLE_100
148: , a43 out nocopy JTF_NUMBER_TABLE
149: , a44 out nocopy JTF_NUMBER_TABLE
150: , a45 out nocopy JTF_VARCHAR2_TABLE_4000
151: , a46 out nocopy JTF_NUMBER_TABLE
152: , a47 out nocopy JTF_VARCHAR2_TABLE_100
153: , a48 out nocopy JTF_VARCHAR2_TABLE_200

Line 151: , a46 out nocopy JTF_NUMBER_TABLE

147: , a42 out nocopy JTF_VARCHAR2_TABLE_100
148: , a43 out nocopy JTF_NUMBER_TABLE
149: , a44 out nocopy JTF_NUMBER_TABLE
150: , a45 out nocopy JTF_VARCHAR2_TABLE_4000
151: , a46 out nocopy JTF_NUMBER_TABLE
152: , a47 out nocopy JTF_VARCHAR2_TABLE_100
153: , a48 out nocopy JTF_VARCHAR2_TABLE_200
154: , a49 out nocopy JTF_VARCHAR2_TABLE_200
155: , a50 out nocopy JTF_VARCHAR2_TABLE_200

Line 172: , a67 out nocopy JTF_NUMBER_TABLE

168: , a63 out nocopy JTF_VARCHAR2_TABLE_100
169: , a64 out nocopy JTF_VARCHAR2_TABLE_100
170: , a65 out nocopy JTF_VARCHAR2_TABLE_300
171: , a66 out nocopy JTF_VARCHAR2_TABLE_100
172: , a67 out nocopy JTF_NUMBER_TABLE
173: , a68 out nocopy JTF_VARCHAR2_TABLE_100
174: , a69 out nocopy JTF_VARCHAR2_TABLE_100
175: , a70 out nocopy JTF_NUMBER_TABLE
176: , a71 out nocopy JTF_VARCHAR2_TABLE_100

Line 175: , a70 out nocopy JTF_NUMBER_TABLE

171: , a66 out nocopy JTF_VARCHAR2_TABLE_100
172: , a67 out nocopy JTF_NUMBER_TABLE
173: , a68 out nocopy JTF_VARCHAR2_TABLE_100
174: , a69 out nocopy JTF_VARCHAR2_TABLE_100
175: , a70 out nocopy JTF_NUMBER_TABLE
176: , a71 out nocopy JTF_VARCHAR2_TABLE_100
177: , a72 out nocopy JTF_VARCHAR2_TABLE_100
178: , a73 out nocopy JTF_NUMBER_TABLE
179: , a74 out nocopy JTF_VARCHAR2_TABLE_100

Line 178: , a73 out nocopy JTF_NUMBER_TABLE

174: , a69 out nocopy JTF_VARCHAR2_TABLE_100
175: , a70 out nocopy JTF_NUMBER_TABLE
176: , a71 out nocopy JTF_VARCHAR2_TABLE_100
177: , a72 out nocopy JTF_VARCHAR2_TABLE_100
178: , a73 out nocopy JTF_NUMBER_TABLE
179: , a74 out nocopy JTF_VARCHAR2_TABLE_100
180: , a75 out nocopy JTF_VARCHAR2_TABLE_100
181: , a76 out nocopy JTF_NUMBER_TABLE
182: , a77 out nocopy JTF_VARCHAR2_TABLE_100

Line 181: , a76 out nocopy JTF_NUMBER_TABLE

177: , a72 out nocopy JTF_VARCHAR2_TABLE_100
178: , a73 out nocopy JTF_NUMBER_TABLE
179: , a74 out nocopy JTF_VARCHAR2_TABLE_100
180: , a75 out nocopy JTF_VARCHAR2_TABLE_100
181: , a76 out nocopy JTF_NUMBER_TABLE
182: , a77 out nocopy JTF_VARCHAR2_TABLE_100
183: , a78 out nocopy JTF_VARCHAR2_TABLE_300
184: , a79 out nocopy JTF_NUMBER_TABLE
185: , a80 out nocopy JTF_NUMBER_TABLE

Line 184: , a79 out nocopy JTF_NUMBER_TABLE

180: , a75 out nocopy JTF_VARCHAR2_TABLE_100
181: , a76 out nocopy JTF_NUMBER_TABLE
182: , a77 out nocopy JTF_VARCHAR2_TABLE_100
183: , a78 out nocopy JTF_VARCHAR2_TABLE_300
184: , a79 out nocopy JTF_NUMBER_TABLE
185: , a80 out nocopy JTF_NUMBER_TABLE
186: , a81 out nocopy JTF_VARCHAR2_TABLE_100
187: , a82 out nocopy JTF_VARCHAR2_TABLE_100
188: , a83 out nocopy JTF_DATE_TABLE

Line 185: , a80 out nocopy JTF_NUMBER_TABLE

181: , a76 out nocopy JTF_NUMBER_TABLE
182: , a77 out nocopy JTF_VARCHAR2_TABLE_100
183: , a78 out nocopy JTF_VARCHAR2_TABLE_300
184: , a79 out nocopy JTF_NUMBER_TABLE
185: , a80 out nocopy JTF_NUMBER_TABLE
186: , a81 out nocopy JTF_VARCHAR2_TABLE_100
187: , a82 out nocopy JTF_VARCHAR2_TABLE_100
188: , a83 out nocopy JTF_DATE_TABLE
189: , a84 out nocopy JTF_VARCHAR2_TABLE_100

Line 196: , a91 out nocopy JTF_NUMBER_TABLE

192: , a87 out nocopy JTF_VARCHAR2_TABLE_4000
193: , a88 out nocopy JTF_VARCHAR2_TABLE_100
194: , a89 out nocopy JTF_VARCHAR2_TABLE_100
195: , a90 out nocopy JTF_VARCHAR2_TABLE_100
196: , a91 out nocopy JTF_NUMBER_TABLE
197: , a92 out nocopy JTF_NUMBER_TABLE
198: , a93 out nocopy JTF_VARCHAR2_TABLE_100
199: , a94 out nocopy JTF_VARCHAR2_TABLE_300
200: , a95 out nocopy JTF_NUMBER_TABLE

Line 197: , a92 out nocopy JTF_NUMBER_TABLE

193: , a88 out nocopy JTF_VARCHAR2_TABLE_100
194: , a89 out nocopy JTF_VARCHAR2_TABLE_100
195: , a90 out nocopy JTF_VARCHAR2_TABLE_100
196: , a91 out nocopy JTF_NUMBER_TABLE
197: , a92 out nocopy JTF_NUMBER_TABLE
198: , a93 out nocopy JTF_VARCHAR2_TABLE_100
199: , a94 out nocopy JTF_VARCHAR2_TABLE_300
200: , a95 out nocopy JTF_NUMBER_TABLE
201: , a96 out nocopy JTF_VARCHAR2_TABLE_100

Line 200: , a95 out nocopy JTF_NUMBER_TABLE

196: , a91 out nocopy JTF_NUMBER_TABLE
197: , a92 out nocopy JTF_NUMBER_TABLE
198: , a93 out nocopy JTF_VARCHAR2_TABLE_100
199: , a94 out nocopy JTF_VARCHAR2_TABLE_300
200: , a95 out nocopy JTF_NUMBER_TABLE
201: , a96 out nocopy JTF_VARCHAR2_TABLE_100
202: , a97 out nocopy JTF_VARCHAR2_TABLE_300
203: , a98 out nocopy JTF_NUMBER_TABLE
204: , a99 out nocopy JTF_VARCHAR2_TABLE_100

Line 203: , a98 out nocopy JTF_NUMBER_TABLE

199: , a94 out nocopy JTF_VARCHAR2_TABLE_300
200: , a95 out nocopy JTF_NUMBER_TABLE
201: , a96 out nocopy JTF_VARCHAR2_TABLE_100
202: , a97 out nocopy JTF_VARCHAR2_TABLE_300
203: , a98 out nocopy JTF_NUMBER_TABLE
204: , a99 out nocopy JTF_VARCHAR2_TABLE_100
205: , a100 out nocopy JTF_VARCHAR2_TABLE_100
206: );
207:

Line 208: procedure rosetta_table_copy_in_p4(t out nocopy ahl_vwp_visits_pvt.error_tbl_type, a0 JTF_NUMBER_TABLE

204: , a99 out nocopy JTF_VARCHAR2_TABLE_100
205: , a100 out nocopy JTF_VARCHAR2_TABLE_100
206: );
207:
208: procedure rosetta_table_copy_in_p4(t out nocopy ahl_vwp_visits_pvt.error_tbl_type, a0 JTF_NUMBER_TABLE
209: , a1 JTF_VARCHAR2_TABLE_100
210: , a2 JTF_VARCHAR2_TABLE_100
211: , a3 JTF_VARCHAR2_TABLE_100
212: , a4 JTF_VARCHAR2_TABLE_100

Line 217: procedure rosetta_table_copy_out_p4(t ahl_vwp_visits_pvt.error_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

213: , a5 JTF_DATE_TABLE
214: , a6 JTF_DATE_TABLE
215: , a7 JTF_VARCHAR2_TABLE_100
216: );
217: procedure rosetta_table_copy_out_p4(t ahl_vwp_visits_pvt.error_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
218: , a1 out nocopy JTF_VARCHAR2_TABLE_100
219: , a2 out nocopy JTF_VARCHAR2_TABLE_100
220: , a3 out nocopy JTF_VARCHAR2_TABLE_100
221: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 232: , p5_a0 in out nocopy JTF_NUMBER_TABLE

228: , p_init_msg_list VARCHAR2
229: , p_commit VARCHAR2
230: , p_validation_level NUMBER
231: , p_module_type VARCHAR2
232: , p5_a0 in out nocopy JTF_NUMBER_TABLE
233: , p5_a1 in out nocopy JTF_VARCHAR2_TABLE_100
234: , p5_a2 in out nocopy JTF_NUMBER_TABLE
235: , p5_a3 in out nocopy JTF_NUMBER_TABLE
236: , p5_a4 in out nocopy JTF_DATE_TABLE

Line 234: , p5_a2 in out nocopy JTF_NUMBER_TABLE

230: , p_validation_level NUMBER
231: , p_module_type VARCHAR2
232: , p5_a0 in out nocopy JTF_NUMBER_TABLE
233: , p5_a1 in out nocopy JTF_VARCHAR2_TABLE_100
234: , p5_a2 in out nocopy JTF_NUMBER_TABLE
235: , p5_a3 in out nocopy JTF_NUMBER_TABLE
236: , p5_a4 in out nocopy JTF_DATE_TABLE
237: , p5_a5 in out nocopy JTF_NUMBER_TABLE
238: , p5_a6 in out nocopy JTF_DATE_TABLE

Line 235: , p5_a3 in out nocopy JTF_NUMBER_TABLE

231: , p_module_type VARCHAR2
232: , p5_a0 in out nocopy JTF_NUMBER_TABLE
233: , p5_a1 in out nocopy JTF_VARCHAR2_TABLE_100
234: , p5_a2 in out nocopy JTF_NUMBER_TABLE
235: , p5_a3 in out nocopy JTF_NUMBER_TABLE
236: , p5_a4 in out nocopy JTF_DATE_TABLE
237: , p5_a5 in out nocopy JTF_NUMBER_TABLE
238: , p5_a6 in out nocopy JTF_DATE_TABLE
239: , p5_a7 in out nocopy JTF_NUMBER_TABLE

Line 237: , p5_a5 in out nocopy JTF_NUMBER_TABLE

233: , p5_a1 in out nocopy JTF_VARCHAR2_TABLE_100
234: , p5_a2 in out nocopy JTF_NUMBER_TABLE
235: , p5_a3 in out nocopy JTF_NUMBER_TABLE
236: , p5_a4 in out nocopy JTF_DATE_TABLE
237: , p5_a5 in out nocopy JTF_NUMBER_TABLE
238: , p5_a6 in out nocopy JTF_DATE_TABLE
239: , p5_a7 in out nocopy JTF_NUMBER_TABLE
240: , p5_a8 in out nocopy JTF_NUMBER_TABLE
241: , p5_a9 in out nocopy JTF_NUMBER_TABLE

Line 239: , p5_a7 in out nocopy JTF_NUMBER_TABLE

235: , p5_a3 in out nocopy JTF_NUMBER_TABLE
236: , p5_a4 in out nocopy JTF_DATE_TABLE
237: , p5_a5 in out nocopy JTF_NUMBER_TABLE
238: , p5_a6 in out nocopy JTF_DATE_TABLE
239: , p5_a7 in out nocopy JTF_NUMBER_TABLE
240: , p5_a8 in out nocopy JTF_NUMBER_TABLE
241: , p5_a9 in out nocopy JTF_NUMBER_TABLE
242: , p5_a10 in out nocopy JTF_VARCHAR2_TABLE_300
243: , p5_a11 in out nocopy JTF_NUMBER_TABLE

Line 240: , p5_a8 in out nocopy JTF_NUMBER_TABLE

236: , p5_a4 in out nocopy JTF_DATE_TABLE
237: , p5_a5 in out nocopy JTF_NUMBER_TABLE
238: , p5_a6 in out nocopy JTF_DATE_TABLE
239: , p5_a7 in out nocopy JTF_NUMBER_TABLE
240: , p5_a8 in out nocopy JTF_NUMBER_TABLE
241: , p5_a9 in out nocopy JTF_NUMBER_TABLE
242: , p5_a10 in out nocopy JTF_VARCHAR2_TABLE_300
243: , p5_a11 in out nocopy JTF_NUMBER_TABLE
244: , p5_a12 in out nocopy JTF_VARCHAR2_TABLE_300

Line 241: , p5_a9 in out nocopy JTF_NUMBER_TABLE

237: , p5_a5 in out nocopy JTF_NUMBER_TABLE
238: , p5_a6 in out nocopy JTF_DATE_TABLE
239: , p5_a7 in out nocopy JTF_NUMBER_TABLE
240: , p5_a8 in out nocopy JTF_NUMBER_TABLE
241: , p5_a9 in out nocopy JTF_NUMBER_TABLE
242: , p5_a10 in out nocopy JTF_VARCHAR2_TABLE_300
243: , p5_a11 in out nocopy JTF_NUMBER_TABLE
244: , p5_a12 in out nocopy JTF_VARCHAR2_TABLE_300
245: , p5_a13 in out nocopy JTF_NUMBER_TABLE

Line 243: , p5_a11 in out nocopy JTF_NUMBER_TABLE

239: , p5_a7 in out nocopy JTF_NUMBER_TABLE
240: , p5_a8 in out nocopy JTF_NUMBER_TABLE
241: , p5_a9 in out nocopy JTF_NUMBER_TABLE
242: , p5_a10 in out nocopy JTF_VARCHAR2_TABLE_300
243: , p5_a11 in out nocopy JTF_NUMBER_TABLE
244: , p5_a12 in out nocopy JTF_VARCHAR2_TABLE_300
245: , p5_a13 in out nocopy JTF_NUMBER_TABLE
246: , p5_a14 in out nocopy JTF_VARCHAR2_TABLE_100
247: , p5_a15 in out nocopy JTF_VARCHAR2_TABLE_100

Line 245: , p5_a13 in out nocopy JTF_NUMBER_TABLE

241: , p5_a9 in out nocopy JTF_NUMBER_TABLE
242: , p5_a10 in out nocopy JTF_VARCHAR2_TABLE_300
243: , p5_a11 in out nocopy JTF_NUMBER_TABLE
244: , p5_a12 in out nocopy JTF_VARCHAR2_TABLE_300
245: , p5_a13 in out nocopy JTF_NUMBER_TABLE
246: , p5_a14 in out nocopy JTF_VARCHAR2_TABLE_100
247: , p5_a15 in out nocopy JTF_VARCHAR2_TABLE_100
248: , p5_a16 in out nocopy JTF_VARCHAR2_TABLE_100
249: , p5_a17 in out nocopy JTF_DATE_TABLE

Line 250: , p5_a18 in out nocopy JTF_NUMBER_TABLE

246: , p5_a14 in out nocopy JTF_VARCHAR2_TABLE_100
247: , p5_a15 in out nocopy JTF_VARCHAR2_TABLE_100
248: , p5_a16 in out nocopy JTF_VARCHAR2_TABLE_100
249: , p5_a17 in out nocopy JTF_DATE_TABLE
250: , p5_a18 in out nocopy JTF_NUMBER_TABLE
251: , p5_a19 in out nocopy JTF_NUMBER_TABLE
252: , p5_a20 in out nocopy JTF_DATE_TABLE
253: , p5_a21 in out nocopy JTF_NUMBER_TABLE
254: , p5_a22 in out nocopy JTF_NUMBER_TABLE

Line 251: , p5_a19 in out nocopy JTF_NUMBER_TABLE

247: , p5_a15 in out nocopy JTF_VARCHAR2_TABLE_100
248: , p5_a16 in out nocopy JTF_VARCHAR2_TABLE_100
249: , p5_a17 in out nocopy JTF_DATE_TABLE
250: , p5_a18 in out nocopy JTF_NUMBER_TABLE
251: , p5_a19 in out nocopy JTF_NUMBER_TABLE
252: , p5_a20 in out nocopy JTF_DATE_TABLE
253: , p5_a21 in out nocopy JTF_NUMBER_TABLE
254: , p5_a22 in out nocopy JTF_NUMBER_TABLE
255: , p5_a23 in out nocopy JTF_DATE_TABLE

Line 253: , p5_a21 in out nocopy JTF_NUMBER_TABLE

249: , p5_a17 in out nocopy JTF_DATE_TABLE
250: , p5_a18 in out nocopy JTF_NUMBER_TABLE
251: , p5_a19 in out nocopy JTF_NUMBER_TABLE
252: , p5_a20 in out nocopy JTF_DATE_TABLE
253: , p5_a21 in out nocopy JTF_NUMBER_TABLE
254: , p5_a22 in out nocopy JTF_NUMBER_TABLE
255: , p5_a23 in out nocopy JTF_DATE_TABLE
256: , p5_a24 in out nocopy JTF_DATE_TABLE
257: , p5_a25 in out nocopy JTF_VARCHAR2_TABLE_100

Line 254: , p5_a22 in out nocopy JTF_NUMBER_TABLE

250: , p5_a18 in out nocopy JTF_NUMBER_TABLE
251: , p5_a19 in out nocopy JTF_NUMBER_TABLE
252: , p5_a20 in out nocopy JTF_DATE_TABLE
253: , p5_a21 in out nocopy JTF_NUMBER_TABLE
254: , p5_a22 in out nocopy JTF_NUMBER_TABLE
255: , p5_a23 in out nocopy JTF_DATE_TABLE
256: , p5_a24 in out nocopy JTF_DATE_TABLE
257: , p5_a25 in out nocopy JTF_VARCHAR2_TABLE_100
258: , p5_a26 in out nocopy JTF_VARCHAR2_TABLE_100

Line 261: , p5_a29 in out nocopy JTF_NUMBER_TABLE

257: , p5_a25 in out nocopy JTF_VARCHAR2_TABLE_100
258: , p5_a26 in out nocopy JTF_VARCHAR2_TABLE_100
259: , p5_a27 in out nocopy JTF_VARCHAR2_TABLE_100
260: , p5_a28 in out nocopy JTF_VARCHAR2_TABLE_100
261: , p5_a29 in out nocopy JTF_NUMBER_TABLE
262: , p5_a30 in out nocopy JTF_VARCHAR2_TABLE_100
263: , p5_a31 in out nocopy JTF_NUMBER_TABLE
264: , p5_a32 in out nocopy JTF_VARCHAR2_TABLE_100
265: , p5_a33 in out nocopy JTF_NUMBER_TABLE

Line 263: , p5_a31 in out nocopy JTF_NUMBER_TABLE

259: , p5_a27 in out nocopy JTF_VARCHAR2_TABLE_100
260: , p5_a28 in out nocopy JTF_VARCHAR2_TABLE_100
261: , p5_a29 in out nocopy JTF_NUMBER_TABLE
262: , p5_a30 in out nocopy JTF_VARCHAR2_TABLE_100
263: , p5_a31 in out nocopy JTF_NUMBER_TABLE
264: , p5_a32 in out nocopy JTF_VARCHAR2_TABLE_100
265: , p5_a33 in out nocopy JTF_NUMBER_TABLE
266: , p5_a34 in out nocopy JTF_VARCHAR2_TABLE_100
267: , p5_a35 in out nocopy JTF_NUMBER_TABLE

Line 265: , p5_a33 in out nocopy JTF_NUMBER_TABLE

261: , p5_a29 in out nocopy JTF_NUMBER_TABLE
262: , p5_a30 in out nocopy JTF_VARCHAR2_TABLE_100
263: , p5_a31 in out nocopy JTF_NUMBER_TABLE
264: , p5_a32 in out nocopy JTF_VARCHAR2_TABLE_100
265: , p5_a33 in out nocopy JTF_NUMBER_TABLE
266: , p5_a34 in out nocopy JTF_VARCHAR2_TABLE_100
267: , p5_a35 in out nocopy JTF_NUMBER_TABLE
268: , p5_a36 in out nocopy JTF_NUMBER_TABLE
269: , p5_a37 in out nocopy JTF_VARCHAR2_TABLE_100

Line 267: , p5_a35 in out nocopy JTF_NUMBER_TABLE

263: , p5_a31 in out nocopy JTF_NUMBER_TABLE
264: , p5_a32 in out nocopy JTF_VARCHAR2_TABLE_100
265: , p5_a33 in out nocopy JTF_NUMBER_TABLE
266: , p5_a34 in out nocopy JTF_VARCHAR2_TABLE_100
267: , p5_a35 in out nocopy JTF_NUMBER_TABLE
268: , p5_a36 in out nocopy JTF_NUMBER_TABLE
269: , p5_a37 in out nocopy JTF_VARCHAR2_TABLE_100
270: , p5_a38 in out nocopy JTF_VARCHAR2_TABLE_100
271: , p5_a39 in out nocopy JTF_VARCHAR2_TABLE_100

Line 268: , p5_a36 in out nocopy JTF_NUMBER_TABLE

264: , p5_a32 in out nocopy JTF_VARCHAR2_TABLE_100
265: , p5_a33 in out nocopy JTF_NUMBER_TABLE
266: , p5_a34 in out nocopy JTF_VARCHAR2_TABLE_100
267: , p5_a35 in out nocopy JTF_NUMBER_TABLE
268: , p5_a36 in out nocopy JTF_NUMBER_TABLE
269: , p5_a37 in out nocopy JTF_VARCHAR2_TABLE_100
270: , p5_a38 in out nocopy JTF_VARCHAR2_TABLE_100
271: , p5_a39 in out nocopy JTF_VARCHAR2_TABLE_100
272: , p5_a40 in out nocopy JTF_VARCHAR2_TABLE_100

Line 275: , p5_a43 in out nocopy JTF_NUMBER_TABLE

271: , p5_a39 in out nocopy JTF_VARCHAR2_TABLE_100
272: , p5_a40 in out nocopy JTF_VARCHAR2_TABLE_100
273: , p5_a41 in out nocopy JTF_VARCHAR2_TABLE_100
274: , p5_a42 in out nocopy JTF_VARCHAR2_TABLE_100
275: , p5_a43 in out nocopy JTF_NUMBER_TABLE
276: , p5_a44 in out nocopy JTF_NUMBER_TABLE
277: , p5_a45 in out nocopy JTF_VARCHAR2_TABLE_4000
278: , p5_a46 in out nocopy JTF_NUMBER_TABLE
279: , p5_a47 in out nocopy JTF_VARCHAR2_TABLE_100

Line 276: , p5_a44 in out nocopy JTF_NUMBER_TABLE

272: , p5_a40 in out nocopy JTF_VARCHAR2_TABLE_100
273: , p5_a41 in out nocopy JTF_VARCHAR2_TABLE_100
274: , p5_a42 in out nocopy JTF_VARCHAR2_TABLE_100
275: , p5_a43 in out nocopy JTF_NUMBER_TABLE
276: , p5_a44 in out nocopy JTF_NUMBER_TABLE
277: , p5_a45 in out nocopy JTF_VARCHAR2_TABLE_4000
278: , p5_a46 in out nocopy JTF_NUMBER_TABLE
279: , p5_a47 in out nocopy JTF_VARCHAR2_TABLE_100
280: , p5_a48 in out nocopy JTF_VARCHAR2_TABLE_200

Line 278: , p5_a46 in out nocopy JTF_NUMBER_TABLE

274: , p5_a42 in out nocopy JTF_VARCHAR2_TABLE_100
275: , p5_a43 in out nocopy JTF_NUMBER_TABLE
276: , p5_a44 in out nocopy JTF_NUMBER_TABLE
277: , p5_a45 in out nocopy JTF_VARCHAR2_TABLE_4000
278: , p5_a46 in out nocopy JTF_NUMBER_TABLE
279: , p5_a47 in out nocopy JTF_VARCHAR2_TABLE_100
280: , p5_a48 in out nocopy JTF_VARCHAR2_TABLE_200
281: , p5_a49 in out nocopy JTF_VARCHAR2_TABLE_200
282: , p5_a50 in out nocopy JTF_VARCHAR2_TABLE_200

Line 299: , p5_a67 in out nocopy JTF_NUMBER_TABLE

295: , p5_a63 in out nocopy JTF_VARCHAR2_TABLE_100
296: , p5_a64 in out nocopy JTF_VARCHAR2_TABLE_100
297: , p5_a65 in out nocopy JTF_VARCHAR2_TABLE_300
298: , p5_a66 in out nocopy JTF_VARCHAR2_TABLE_100
299: , p5_a67 in out nocopy JTF_NUMBER_TABLE
300: , p5_a68 in out nocopy JTF_VARCHAR2_TABLE_100
301: , p5_a69 in out nocopy JTF_VARCHAR2_TABLE_100
302: , p5_a70 in out nocopy JTF_NUMBER_TABLE
303: , p5_a71 in out nocopy JTF_VARCHAR2_TABLE_100

Line 302: , p5_a70 in out nocopy JTF_NUMBER_TABLE

298: , p5_a66 in out nocopy JTF_VARCHAR2_TABLE_100
299: , p5_a67 in out nocopy JTF_NUMBER_TABLE
300: , p5_a68 in out nocopy JTF_VARCHAR2_TABLE_100
301: , p5_a69 in out nocopy JTF_VARCHAR2_TABLE_100
302: , p5_a70 in out nocopy JTF_NUMBER_TABLE
303: , p5_a71 in out nocopy JTF_VARCHAR2_TABLE_100
304: , p5_a72 in out nocopy JTF_VARCHAR2_TABLE_100
305: , p5_a73 in out nocopy JTF_NUMBER_TABLE
306: , p5_a74 in out nocopy JTF_VARCHAR2_TABLE_100

Line 305: , p5_a73 in out nocopy JTF_NUMBER_TABLE

301: , p5_a69 in out nocopy JTF_VARCHAR2_TABLE_100
302: , p5_a70 in out nocopy JTF_NUMBER_TABLE
303: , p5_a71 in out nocopy JTF_VARCHAR2_TABLE_100
304: , p5_a72 in out nocopy JTF_VARCHAR2_TABLE_100
305: , p5_a73 in out nocopy JTF_NUMBER_TABLE
306: , p5_a74 in out nocopy JTF_VARCHAR2_TABLE_100
307: , p5_a75 in out nocopy JTF_VARCHAR2_TABLE_100
308: , p5_a76 in out nocopy JTF_NUMBER_TABLE
309: , p5_a77 in out nocopy JTF_VARCHAR2_TABLE_100

Line 308: , p5_a76 in out nocopy JTF_NUMBER_TABLE

304: , p5_a72 in out nocopy JTF_VARCHAR2_TABLE_100
305: , p5_a73 in out nocopy JTF_NUMBER_TABLE
306: , p5_a74 in out nocopy JTF_VARCHAR2_TABLE_100
307: , p5_a75 in out nocopy JTF_VARCHAR2_TABLE_100
308: , p5_a76 in out nocopy JTF_NUMBER_TABLE
309: , p5_a77 in out nocopy JTF_VARCHAR2_TABLE_100
310: , p5_a78 in out nocopy JTF_VARCHAR2_TABLE_300
311: , p5_a79 in out nocopy JTF_NUMBER_TABLE
312: , p5_a80 in out nocopy JTF_NUMBER_TABLE

Line 311: , p5_a79 in out nocopy JTF_NUMBER_TABLE

307: , p5_a75 in out nocopy JTF_VARCHAR2_TABLE_100
308: , p5_a76 in out nocopy JTF_NUMBER_TABLE
309: , p5_a77 in out nocopy JTF_VARCHAR2_TABLE_100
310: , p5_a78 in out nocopy JTF_VARCHAR2_TABLE_300
311: , p5_a79 in out nocopy JTF_NUMBER_TABLE
312: , p5_a80 in out nocopy JTF_NUMBER_TABLE
313: , p5_a81 in out nocopy JTF_VARCHAR2_TABLE_100
314: , p5_a82 in out nocopy JTF_VARCHAR2_TABLE_100
315: , p5_a83 in out nocopy JTF_DATE_TABLE

Line 312: , p5_a80 in out nocopy JTF_NUMBER_TABLE

308: , p5_a76 in out nocopy JTF_NUMBER_TABLE
309: , p5_a77 in out nocopy JTF_VARCHAR2_TABLE_100
310: , p5_a78 in out nocopy JTF_VARCHAR2_TABLE_300
311: , p5_a79 in out nocopy JTF_NUMBER_TABLE
312: , p5_a80 in out nocopy JTF_NUMBER_TABLE
313: , p5_a81 in out nocopy JTF_VARCHAR2_TABLE_100
314: , p5_a82 in out nocopy JTF_VARCHAR2_TABLE_100
315: , p5_a83 in out nocopy JTF_DATE_TABLE
316: , p5_a84 in out nocopy JTF_VARCHAR2_TABLE_100

Line 323: , p5_a91 in out nocopy JTF_NUMBER_TABLE

319: , p5_a87 in out nocopy JTF_VARCHAR2_TABLE_4000
320: , p5_a88 in out nocopy JTF_VARCHAR2_TABLE_100
321: , p5_a89 in out nocopy JTF_VARCHAR2_TABLE_100
322: , p5_a90 in out nocopy JTF_VARCHAR2_TABLE_100
323: , p5_a91 in out nocopy JTF_NUMBER_TABLE
324: , p5_a92 in out nocopy JTF_NUMBER_TABLE
325: , p5_a93 in out nocopy JTF_VARCHAR2_TABLE_100
326: , p5_a94 in out nocopy JTF_VARCHAR2_TABLE_300
327: , p5_a95 in out nocopy JTF_NUMBER_TABLE

Line 324: , p5_a92 in out nocopy JTF_NUMBER_TABLE

320: , p5_a88 in out nocopy JTF_VARCHAR2_TABLE_100
321: , p5_a89 in out nocopy JTF_VARCHAR2_TABLE_100
322: , p5_a90 in out nocopy JTF_VARCHAR2_TABLE_100
323: , p5_a91 in out nocopy JTF_NUMBER_TABLE
324: , p5_a92 in out nocopy JTF_NUMBER_TABLE
325: , p5_a93 in out nocopy JTF_VARCHAR2_TABLE_100
326: , p5_a94 in out nocopy JTF_VARCHAR2_TABLE_300
327: , p5_a95 in out nocopy JTF_NUMBER_TABLE
328: , p5_a96 in out nocopy JTF_VARCHAR2_TABLE_100

Line 327: , p5_a95 in out nocopy JTF_NUMBER_TABLE

323: , p5_a91 in out nocopy JTF_NUMBER_TABLE
324: , p5_a92 in out nocopy JTF_NUMBER_TABLE
325: , p5_a93 in out nocopy JTF_VARCHAR2_TABLE_100
326: , p5_a94 in out nocopy JTF_VARCHAR2_TABLE_300
327: , p5_a95 in out nocopy JTF_NUMBER_TABLE
328: , p5_a96 in out nocopy JTF_VARCHAR2_TABLE_100
329: , p5_a97 in out nocopy JTF_VARCHAR2_TABLE_300
330: , p5_a98 in out nocopy JTF_NUMBER_TABLE
331: , p5_a99 in out nocopy JTF_VARCHAR2_TABLE_100

Line 330: , p5_a98 in out nocopy JTF_NUMBER_TABLE

326: , p5_a94 in out nocopy JTF_VARCHAR2_TABLE_300
327: , p5_a95 in out nocopy JTF_NUMBER_TABLE
328: , p5_a96 in out nocopy JTF_VARCHAR2_TABLE_100
329: , p5_a97 in out nocopy JTF_VARCHAR2_TABLE_300
330: , p5_a98 in out nocopy JTF_NUMBER_TABLE
331: , p5_a99 in out nocopy JTF_VARCHAR2_TABLE_100
332: , p5_a100 in out nocopy JTF_VARCHAR2_TABLE_100
333: , x_return_status out nocopy VARCHAR2
334: , x_msg_count out nocopy NUMBER