APPS.AHL_VWP_VISITS_PVT_W dependencies on JTF_VARCHAR2_TABLE_100

Line 4: , a1 JTF_VARCHAR2_TABLE_100

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

Line 17: , a14 JTF_VARCHAR2_TABLE_100

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

Line 18: , a15 JTF_VARCHAR2_TABLE_100

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
21: , a18 JTF_NUMBER_TABLE
22: , a19 JTF_NUMBER_TABLE

Line 19: , a16 JTF_VARCHAR2_TABLE_100

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
21: , a18 JTF_NUMBER_TABLE
22: , a19 JTF_NUMBER_TABLE
23: , a20 JTF_DATE_TABLE

Line 28: , a25 JTF_VARCHAR2_TABLE_100

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
30: , a27 JTF_VARCHAR2_TABLE_100
31: , a28 JTF_VARCHAR2_TABLE_100
32: , a29 JTF_NUMBER_TABLE

Line 29: , a26 JTF_VARCHAR2_TABLE_100

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
30: , a27 JTF_VARCHAR2_TABLE_100
31: , a28 JTF_VARCHAR2_TABLE_100
32: , a29 JTF_NUMBER_TABLE
33: , a30 JTF_VARCHAR2_TABLE_100

Line 30: , a27 JTF_VARCHAR2_TABLE_100

26: , a23 JTF_DATE_TABLE
27: , a24 JTF_DATE_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

Line 31: , a28 JTF_VARCHAR2_TABLE_100

27: , a24 JTF_DATE_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

Line 33: , a30 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
37: , a34 JTF_VARCHAR2_TABLE_100

Line 35: , a32 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
39: , a36 JTF_NUMBER_TABLE

Line 37: , a34 JTF_VARCHAR2_TABLE_100

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
41: , a38 JTF_VARCHAR2_TABLE_100

Line 40: , a37 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
44: , a41 JTF_VARCHAR2_TABLE_100

Line 41: , a38 JTF_VARCHAR2_TABLE_100

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
44: , a41 JTF_VARCHAR2_TABLE_100
45: , a42 JTF_VARCHAR2_TABLE_100

Line 42: , a39 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
44: , a41 JTF_VARCHAR2_TABLE_100
45: , a42 JTF_VARCHAR2_TABLE_100
46: , a43 JTF_NUMBER_TABLE

Line 43: , a40 JTF_VARCHAR2_TABLE_100

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
44: , a41 JTF_VARCHAR2_TABLE_100
45: , a42 JTF_VARCHAR2_TABLE_100
46: , a43 JTF_NUMBER_TABLE
47: , a44 JTF_NUMBER_TABLE

Line 44: , a41 JTF_VARCHAR2_TABLE_100

40: , a37 JTF_VARCHAR2_TABLE_100
41: , a38 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

Line 45: , a42 JTF_VARCHAR2_TABLE_100

41: , a38 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

Line 50: , a47 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
54: , a51 JTF_VARCHAR2_TABLE_200

Line 66: , a63 JTF_VARCHAR2_TABLE_100

62: , a59 JTF_VARCHAR2_TABLE_200
63: , a60 JTF_VARCHAR2_TABLE_200
64: , a61 JTF_VARCHAR2_TABLE_200
65: , a62 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

Line 67: , a64 JTF_VARCHAR2_TABLE_100

63: , a60 JTF_VARCHAR2_TABLE_200
64: , a61 JTF_VARCHAR2_TABLE_200
65: , a62 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

Line 69: , a66 JTF_VARCHAR2_TABLE_100

65: , a62 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

Line 71: , a68 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
75: , a72 JTF_VARCHAR2_TABLE_100

Line 72: , a69 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
75: , a72 JTF_VARCHAR2_TABLE_100
76: , a73 JTF_NUMBER_TABLE

Line 74: , a71 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
78: , a75 JTF_VARCHAR2_TABLE_100

Line 75: , a72 JTF_VARCHAR2_TABLE_100

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
78: , a75 JTF_VARCHAR2_TABLE_100
79: , a76 JTF_VARCHAR2_TABLE_300

Line 77: , a74 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
81: );

Line 78: , a75 JTF_VARCHAR2_TABLE_100

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
81: );
82: procedure rosetta_table_copy_out_p3(t ahl_vwp_visits_pvt.visit_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

Line 83: , a1 out nocopy 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
87: , a5 out nocopy JTF_NUMBER_TABLE

Line 96: , a14 out nocopy JTF_VARCHAR2_TABLE_100

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
100: , a18 out nocopy JTF_NUMBER_TABLE

Line 97: , a15 out nocopy JTF_VARCHAR2_TABLE_100

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
100: , a18 out nocopy JTF_NUMBER_TABLE
101: , a19 out nocopy JTF_NUMBER_TABLE

Line 98: , a16 out nocopy JTF_VARCHAR2_TABLE_100

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
100: , a18 out nocopy JTF_NUMBER_TABLE
101: , a19 out nocopy JTF_NUMBER_TABLE
102: , a20 out nocopy JTF_DATE_TABLE

Line 107: , a25 out nocopy JTF_VARCHAR2_TABLE_100

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
109: , a27 out nocopy JTF_VARCHAR2_TABLE_100
110: , a28 out nocopy JTF_VARCHAR2_TABLE_100
111: , a29 out nocopy JTF_NUMBER_TABLE

Line 108: , a26 out nocopy JTF_VARCHAR2_TABLE_100

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
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

Line 109: , a27 out nocopy JTF_VARCHAR2_TABLE_100

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
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

Line 110: , a28 out nocopy JTF_VARCHAR2_TABLE_100

106: , a24 out nocopy JTF_DATE_TABLE
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

Line 112: , a30 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
116: , a34 out nocopy JTF_VARCHAR2_TABLE_100

Line 114: , a32 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
118: , a36 out nocopy JTF_NUMBER_TABLE

Line 116: , a34 out nocopy JTF_VARCHAR2_TABLE_100

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
120: , a38 out nocopy JTF_VARCHAR2_TABLE_100

Line 119: , a37 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
123: , a41 out nocopy JTF_VARCHAR2_TABLE_100

Line 120: , a38 out nocopy JTF_VARCHAR2_TABLE_100

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
123: , a41 out nocopy JTF_VARCHAR2_TABLE_100
124: , a42 out nocopy JTF_VARCHAR2_TABLE_100

Line 121: , a39 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
123: , a41 out nocopy JTF_VARCHAR2_TABLE_100
124: , a42 out nocopy JTF_VARCHAR2_TABLE_100
125: , a43 out nocopy JTF_NUMBER_TABLE

Line 122: , a40 out nocopy JTF_VARCHAR2_TABLE_100

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
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

Line 123: , a41 out nocopy JTF_VARCHAR2_TABLE_100

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
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

Line 124: , a42 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
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

Line 129: , a47 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
133: , a51 out nocopy JTF_VARCHAR2_TABLE_200

Line 145: , a63 out nocopy JTF_VARCHAR2_TABLE_100

141: , a59 out nocopy JTF_VARCHAR2_TABLE_200
142: , a60 out nocopy JTF_VARCHAR2_TABLE_200
143: , a61 out nocopy JTF_VARCHAR2_TABLE_200
144: , a62 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

Line 146: , a64 out nocopy JTF_VARCHAR2_TABLE_100

142: , a60 out nocopy JTF_VARCHAR2_TABLE_200
143: , a61 out nocopy JTF_VARCHAR2_TABLE_200
144: , a62 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

Line 148: , a66 out nocopy JTF_VARCHAR2_TABLE_100

144: , a62 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

Line 150: , a68 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
154: , a72 out nocopy JTF_VARCHAR2_TABLE_100

Line 151: , a69 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
154: , a72 out nocopy JTF_VARCHAR2_TABLE_100
155: , a73 out nocopy JTF_NUMBER_TABLE

Line 153: , a71 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
157: , a75 out nocopy JTF_VARCHAR2_TABLE_100

Line 154: , a72 out nocopy JTF_VARCHAR2_TABLE_100

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
157: , a75 out nocopy JTF_VARCHAR2_TABLE_100
158: , a76 out nocopy JTF_VARCHAR2_TABLE_300

Line 156: , a74 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
160: );

Line 157: , a75 out nocopy JTF_VARCHAR2_TABLE_100

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
160: );
161:

Line 163: , a1 JTF_VARCHAR2_TABLE_100

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

Line 164: , a2 JTF_VARCHAR2_TABLE_100

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

Line 165: , a3 JTF_VARCHAR2_TABLE_100

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

Line 166: , a4 JTF_VARCHAR2_TABLE_100

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: );

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

Line 172: , a1 out nocopy JTF_VARCHAR2_TABLE_100

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
176: , a5 out nocopy JTF_DATE_TABLE

Line 173: , a2 out nocopy JTF_VARCHAR2_TABLE_100

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
176: , a5 out nocopy JTF_DATE_TABLE
177: , a6 out nocopy JTF_DATE_TABLE

Line 174: , a3 out nocopy 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
176: , a5 out nocopy JTF_DATE_TABLE
177: , a6 out nocopy JTF_DATE_TABLE
178: , a7 out nocopy JTF_VARCHAR2_TABLE_100

Line 175: , a4 out nocopy JTF_VARCHAR2_TABLE_100

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
176: , a5 out nocopy JTF_DATE_TABLE
177: , a6 out nocopy JTF_DATE_TABLE
178: , a7 out nocopy JTF_VARCHAR2_TABLE_100
179: );

Line 178: , a7 out nocopy JTF_VARCHAR2_TABLE_100

174: , a3 out nocopy JTF_VARCHAR2_TABLE_100
175: , a4 out nocopy JTF_VARCHAR2_TABLE_100
176: , a5 out nocopy JTF_DATE_TABLE
177: , a6 out nocopy JTF_DATE_TABLE
178: , a7 out nocopy JTF_VARCHAR2_TABLE_100
179: );
180:
181: procedure process_visit(p_api_version NUMBER
182: , p_init_msg_list VARCHAR2

Line 187: , p5_a1 in out nocopy JTF_VARCHAR2_TABLE_100

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
191: , p5_a5 in out nocopy JTF_NUMBER_TABLE

Line 200: , p5_a14 in out nocopy JTF_VARCHAR2_TABLE_100

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
204: , p5_a18 in out nocopy JTF_NUMBER_TABLE

Line 201: , p5_a15 in out nocopy JTF_VARCHAR2_TABLE_100

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
204: , p5_a18 in out nocopy JTF_NUMBER_TABLE
205: , p5_a19 in out nocopy JTF_NUMBER_TABLE

Line 202: , p5_a16 in out nocopy JTF_VARCHAR2_TABLE_100

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
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

Line 211: , p5_a25 in out nocopy JTF_VARCHAR2_TABLE_100

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
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

Line 212: , p5_a26 in out nocopy JTF_VARCHAR2_TABLE_100

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
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

Line 213: , p5_a27 in out nocopy JTF_VARCHAR2_TABLE_100

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
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

Line 214: , p5_a28 in out nocopy JTF_VARCHAR2_TABLE_100

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
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

Line 216: , p5_a30 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
220: , p5_a34 in out nocopy JTF_VARCHAR2_TABLE_100

Line 218: , p5_a32 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
222: , p5_a36 in out nocopy JTF_NUMBER_TABLE

Line 220: , p5_a34 in out nocopy JTF_VARCHAR2_TABLE_100

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
224: , p5_a38 in out nocopy JTF_VARCHAR2_TABLE_100

Line 223: , p5_a37 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
227: , p5_a41 in out nocopy JTF_VARCHAR2_TABLE_100

Line 224: , p5_a38 in out nocopy JTF_VARCHAR2_TABLE_100

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
227: , p5_a41 in out nocopy JTF_VARCHAR2_TABLE_100
228: , p5_a42 in out nocopy JTF_VARCHAR2_TABLE_100

Line 225: , p5_a39 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
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

Line 226: , p5_a40 in out nocopy JTF_VARCHAR2_TABLE_100

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
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

Line 227: , p5_a41 in out nocopy JTF_VARCHAR2_TABLE_100

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
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

Line 228: , p5_a42 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
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

Line 233: , p5_a47 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
237: , p5_a51 in out nocopy JTF_VARCHAR2_TABLE_200

Line 249: , p5_a63 in out nocopy JTF_VARCHAR2_TABLE_100

245: , p5_a59 in out nocopy JTF_VARCHAR2_TABLE_200
246: , p5_a60 in out nocopy JTF_VARCHAR2_TABLE_200
247: , p5_a61 in out nocopy JTF_VARCHAR2_TABLE_200
248: , p5_a62 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

Line 250: , p5_a64 in out nocopy JTF_VARCHAR2_TABLE_100

246: , p5_a60 in out nocopy JTF_VARCHAR2_TABLE_200
247: , p5_a61 in out nocopy JTF_VARCHAR2_TABLE_200
248: , p5_a62 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

Line 252: , p5_a66 in out nocopy JTF_VARCHAR2_TABLE_100

248: , p5_a62 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

Line 254: , p5_a68 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
258: , p5_a72 in out nocopy JTF_VARCHAR2_TABLE_100

Line 255: , p5_a69 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
258: , p5_a72 in out nocopy JTF_VARCHAR2_TABLE_100
259: , p5_a73 in out nocopy JTF_NUMBER_TABLE

Line 257: , p5_a71 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
261: , p5_a75 in out nocopy JTF_VARCHAR2_TABLE_100

Line 258: , p5_a72 in out nocopy JTF_VARCHAR2_TABLE_100

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
261: , p5_a75 in out nocopy JTF_VARCHAR2_TABLE_100
262: , p5_a76 in out nocopy JTF_VARCHAR2_TABLE_300

Line 260: , p5_a74 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
264: , x_return_status out nocopy VARCHAR2

Line 261: , p5_a75 in out nocopy JTF_VARCHAR2_TABLE_100

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
264: , x_return_status out nocopy VARCHAR2
265: , x_msg_count out nocopy NUMBER