APPS.CAC_SYNC_TASK_W dependencies on JTF_VARCHAR2_TABLE_100

Line 8: , a5 JTF_VARCHAR2_TABLE_100

4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_DATE_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_VARCHAR2_TABLE_2000
11: , a8 JTF_VARCHAR2_TABLE_4000
12: , a9 JTF_VARCHAR2_TABLE_100

Line 9: , a6 JTF_VARCHAR2_TABLE_100

5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_DATE_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_VARCHAR2_TABLE_2000
11: , a8 JTF_VARCHAR2_TABLE_4000
12: , a9 JTF_VARCHAR2_TABLE_100
13: , a10 JTF_DATE_TABLE

Line 12: , a9 JTF_VARCHAR2_TABLE_100

8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_VARCHAR2_TABLE_2000
11: , a8 JTF_VARCHAR2_TABLE_4000
12: , a9 JTF_VARCHAR2_TABLE_100
13: , a10 JTF_DATE_TABLE
14: , a11 JTF_DATE_TABLE
15: , a12 JTF_DATE_TABLE
16: , a13 JTF_DATE_TABLE

Line 21: , a18 JTF_VARCHAR2_TABLE_100

17: , a14 JTF_DATE_TABLE
18: , a15 JTF_DATE_TABLE
19: , a16 JTF_NUMBER_TABLE
20: , a17 JTF_NUMBER_TABLE
21: , a18 JTF_VARCHAR2_TABLE_100
22: , a19 JTF_DATE_TABLE
23: , a20 JTF_VARCHAR2_TABLE_100
24: , a21 JTF_VARCHAR2_TABLE_300
25: , a22 JTF_NUMBER_TABLE

Line 23: , a20 JTF_VARCHAR2_TABLE_100

19: , a16 JTF_NUMBER_TABLE
20: , a17 JTF_NUMBER_TABLE
21: , a18 JTF_VARCHAR2_TABLE_100
22: , a19 JTF_DATE_TABLE
23: , a20 JTF_VARCHAR2_TABLE_100
24: , a21 JTF_VARCHAR2_TABLE_300
25: , a22 JTF_NUMBER_TABLE
26: , a23 JTF_VARCHAR2_TABLE_2000
27: , a24 JTF_NUMBER_TABLE

Line 31: , a28 JTF_VARCHAR2_TABLE_100

27: , a24 JTF_NUMBER_TABLE
28: , a25 JTF_NUMBER_TABLE
29: , a26 JTF_VARCHAR2_TABLE_300
30: , a27 JTF_VARCHAR2_TABLE_2000
31: , a28 JTF_VARCHAR2_TABLE_100
32: , a29 JTF_NUMBER_TABLE
33: , a30 JTF_DATE_TABLE
34: , a31 JTF_DATE_TABLE
35: , a32 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_DATE_TABLE
34: , a31 JTF_DATE_TABLE
35: , a32 JTF_VARCHAR2_TABLE_100
36: , a33 JTF_VARCHAR2_TABLE_100
37: , a34 JTF_VARCHAR2_TABLE_100
38: , a35 JTF_VARCHAR2_TABLE_100
39: , a36 JTF_VARCHAR2_TABLE_100

Line 36: , a33 JTF_VARCHAR2_TABLE_100

32: , a29 JTF_NUMBER_TABLE
33: , a30 JTF_DATE_TABLE
34: , a31 JTF_DATE_TABLE
35: , a32 JTF_VARCHAR2_TABLE_100
36: , a33 JTF_VARCHAR2_TABLE_100
37: , a34 JTF_VARCHAR2_TABLE_100
38: , a35 JTF_VARCHAR2_TABLE_100
39: , a36 JTF_VARCHAR2_TABLE_100
40: , a37 JTF_VARCHAR2_TABLE_100

Line 37: , a34 JTF_VARCHAR2_TABLE_100

33: , a30 JTF_DATE_TABLE
34: , a31 JTF_DATE_TABLE
35: , a32 JTF_VARCHAR2_TABLE_100
36: , a33 JTF_VARCHAR2_TABLE_100
37: , a34 JTF_VARCHAR2_TABLE_100
38: , a35 JTF_VARCHAR2_TABLE_100
39: , a36 JTF_VARCHAR2_TABLE_100
40: , a37 JTF_VARCHAR2_TABLE_100
41: , a38 JTF_VARCHAR2_TABLE_100

Line 38: , a35 JTF_VARCHAR2_TABLE_100

34: , a31 JTF_DATE_TABLE
35: , a32 JTF_VARCHAR2_TABLE_100
36: , a33 JTF_VARCHAR2_TABLE_100
37: , a34 JTF_VARCHAR2_TABLE_100
38: , a35 JTF_VARCHAR2_TABLE_100
39: , a36 JTF_VARCHAR2_TABLE_100
40: , a37 JTF_VARCHAR2_TABLE_100
41: , a38 JTF_VARCHAR2_TABLE_100
42: , a39 JTF_NUMBER_TABLE

Line 39: , a36 JTF_VARCHAR2_TABLE_100

35: , a32 JTF_VARCHAR2_TABLE_100
36: , a33 JTF_VARCHAR2_TABLE_100
37: , a34 JTF_VARCHAR2_TABLE_100
38: , a35 JTF_VARCHAR2_TABLE_100
39: , a36 JTF_VARCHAR2_TABLE_100
40: , a37 JTF_VARCHAR2_TABLE_100
41: , a38 JTF_VARCHAR2_TABLE_100
42: , a39 JTF_NUMBER_TABLE
43: , a40 JTF_NUMBER_TABLE

Line 40: , a37 JTF_VARCHAR2_TABLE_100

36: , a33 JTF_VARCHAR2_TABLE_100
37: , a34 JTF_VARCHAR2_TABLE_100
38: , a35 JTF_VARCHAR2_TABLE_100
39: , a36 JTF_VARCHAR2_TABLE_100
40: , a37 JTF_VARCHAR2_TABLE_100
41: , a38 JTF_VARCHAR2_TABLE_100
42: , a39 JTF_NUMBER_TABLE
43: , a40 JTF_NUMBER_TABLE
44: , a41 JTF_VARCHAR2_TABLE_4000

Line 41: , a38 JTF_VARCHAR2_TABLE_100

37: , a34 JTF_VARCHAR2_TABLE_100
38: , a35 JTF_VARCHAR2_TABLE_100
39: , a36 JTF_VARCHAR2_TABLE_100
40: , a37 JTF_VARCHAR2_TABLE_100
41: , a38 JTF_VARCHAR2_TABLE_100
42: , a39 JTF_NUMBER_TABLE
43: , a40 JTF_NUMBER_TABLE
44: , a41 JTF_VARCHAR2_TABLE_4000
45: , a42 JTF_NUMBER_TABLE

Line 46: , a43 JTF_VARCHAR2_TABLE_100

42: , a39 JTF_NUMBER_TABLE
43: , a40 JTF_NUMBER_TABLE
44: , a41 JTF_VARCHAR2_TABLE_4000
45: , a42 JTF_NUMBER_TABLE
46: , a43 JTF_VARCHAR2_TABLE_100
47: , a44 JTF_VARCHAR2_TABLE_100
48: );
49: procedure rosetta_table_copy_out_p3(t cac_sync_task.task_tbl, a0 out nocopy JTF_NUMBER_TABLE
50: , a1 out nocopy JTF_NUMBER_TABLE

Line 47: , a44 JTF_VARCHAR2_TABLE_100

43: , a40 JTF_NUMBER_TABLE
44: , a41 JTF_VARCHAR2_TABLE_4000
45: , a42 JTF_NUMBER_TABLE
46: , a43 JTF_VARCHAR2_TABLE_100
47: , a44 JTF_VARCHAR2_TABLE_100
48: );
49: procedure rosetta_table_copy_out_p3(t cac_sync_task.task_tbl, a0 out nocopy JTF_NUMBER_TABLE
50: , a1 out nocopy JTF_NUMBER_TABLE
51: , a2 out nocopy JTF_NUMBER_TABLE

Line 54: , a5 out nocopy JTF_VARCHAR2_TABLE_100

50: , a1 out nocopy JTF_NUMBER_TABLE
51: , a2 out nocopy JTF_NUMBER_TABLE
52: , a3 out nocopy JTF_DATE_TABLE
53: , a4 out nocopy JTF_NUMBER_TABLE
54: , a5 out nocopy JTF_VARCHAR2_TABLE_100
55: , a6 out nocopy JTF_VARCHAR2_TABLE_100
56: , a7 out nocopy JTF_VARCHAR2_TABLE_2000
57: , a8 out nocopy JTF_VARCHAR2_TABLE_4000
58: , a9 out nocopy JTF_VARCHAR2_TABLE_100

Line 55: , a6 out nocopy JTF_VARCHAR2_TABLE_100

51: , a2 out nocopy JTF_NUMBER_TABLE
52: , a3 out nocopy JTF_DATE_TABLE
53: , a4 out nocopy JTF_NUMBER_TABLE
54: , a5 out nocopy JTF_VARCHAR2_TABLE_100
55: , a6 out nocopy JTF_VARCHAR2_TABLE_100
56: , a7 out nocopy JTF_VARCHAR2_TABLE_2000
57: , a8 out nocopy JTF_VARCHAR2_TABLE_4000
58: , a9 out nocopy JTF_VARCHAR2_TABLE_100
59: , a10 out nocopy JTF_DATE_TABLE

Line 58: , a9 out nocopy JTF_VARCHAR2_TABLE_100

54: , a5 out nocopy JTF_VARCHAR2_TABLE_100
55: , a6 out nocopy JTF_VARCHAR2_TABLE_100
56: , a7 out nocopy JTF_VARCHAR2_TABLE_2000
57: , a8 out nocopy JTF_VARCHAR2_TABLE_4000
58: , a9 out nocopy JTF_VARCHAR2_TABLE_100
59: , a10 out nocopy JTF_DATE_TABLE
60: , a11 out nocopy JTF_DATE_TABLE
61: , a12 out nocopy JTF_DATE_TABLE
62: , a13 out nocopy JTF_DATE_TABLE

Line 67: , a18 out nocopy JTF_VARCHAR2_TABLE_100

63: , a14 out nocopy JTF_DATE_TABLE
64: , a15 out nocopy JTF_DATE_TABLE
65: , a16 out nocopy JTF_NUMBER_TABLE
66: , a17 out nocopy JTF_NUMBER_TABLE
67: , a18 out nocopy JTF_VARCHAR2_TABLE_100
68: , a19 out nocopy JTF_DATE_TABLE
69: , a20 out nocopy JTF_VARCHAR2_TABLE_100
70: , a21 out nocopy JTF_VARCHAR2_TABLE_300
71: , a22 out nocopy JTF_NUMBER_TABLE

Line 69: , a20 out nocopy JTF_VARCHAR2_TABLE_100

65: , a16 out nocopy JTF_NUMBER_TABLE
66: , a17 out nocopy JTF_NUMBER_TABLE
67: , a18 out nocopy JTF_VARCHAR2_TABLE_100
68: , a19 out nocopy JTF_DATE_TABLE
69: , a20 out nocopy JTF_VARCHAR2_TABLE_100
70: , a21 out nocopy JTF_VARCHAR2_TABLE_300
71: , a22 out nocopy JTF_NUMBER_TABLE
72: , a23 out nocopy JTF_VARCHAR2_TABLE_2000
73: , a24 out nocopy JTF_NUMBER_TABLE

Line 77: , a28 out nocopy JTF_VARCHAR2_TABLE_100

73: , a24 out nocopy JTF_NUMBER_TABLE
74: , a25 out nocopy JTF_NUMBER_TABLE
75: , a26 out nocopy JTF_VARCHAR2_TABLE_300
76: , a27 out nocopy JTF_VARCHAR2_TABLE_2000
77: , a28 out nocopy JTF_VARCHAR2_TABLE_100
78: , a29 out nocopy JTF_NUMBER_TABLE
79: , a30 out nocopy JTF_DATE_TABLE
80: , a31 out nocopy JTF_DATE_TABLE
81: , a32 out nocopy JTF_VARCHAR2_TABLE_100

Line 81: , a32 out nocopy JTF_VARCHAR2_TABLE_100

77: , a28 out nocopy JTF_VARCHAR2_TABLE_100
78: , a29 out nocopy JTF_NUMBER_TABLE
79: , a30 out nocopy JTF_DATE_TABLE
80: , a31 out nocopy JTF_DATE_TABLE
81: , a32 out nocopy JTF_VARCHAR2_TABLE_100
82: , a33 out nocopy JTF_VARCHAR2_TABLE_100
83: , a34 out nocopy JTF_VARCHAR2_TABLE_100
84: , a35 out nocopy JTF_VARCHAR2_TABLE_100
85: , a36 out nocopy JTF_VARCHAR2_TABLE_100

Line 82: , a33 out nocopy JTF_VARCHAR2_TABLE_100

78: , a29 out nocopy JTF_NUMBER_TABLE
79: , a30 out nocopy JTF_DATE_TABLE
80: , a31 out nocopy JTF_DATE_TABLE
81: , a32 out nocopy JTF_VARCHAR2_TABLE_100
82: , a33 out nocopy JTF_VARCHAR2_TABLE_100
83: , a34 out nocopy JTF_VARCHAR2_TABLE_100
84: , a35 out nocopy JTF_VARCHAR2_TABLE_100
85: , a36 out nocopy JTF_VARCHAR2_TABLE_100
86: , a37 out nocopy JTF_VARCHAR2_TABLE_100

Line 83: , a34 out nocopy JTF_VARCHAR2_TABLE_100

79: , a30 out nocopy JTF_DATE_TABLE
80: , a31 out nocopy JTF_DATE_TABLE
81: , a32 out nocopy JTF_VARCHAR2_TABLE_100
82: , a33 out nocopy JTF_VARCHAR2_TABLE_100
83: , a34 out nocopy JTF_VARCHAR2_TABLE_100
84: , a35 out nocopy JTF_VARCHAR2_TABLE_100
85: , a36 out nocopy JTF_VARCHAR2_TABLE_100
86: , a37 out nocopy JTF_VARCHAR2_TABLE_100
87: , a38 out nocopy JTF_VARCHAR2_TABLE_100

Line 84: , a35 out nocopy JTF_VARCHAR2_TABLE_100

80: , a31 out nocopy JTF_DATE_TABLE
81: , a32 out nocopy JTF_VARCHAR2_TABLE_100
82: , a33 out nocopy JTF_VARCHAR2_TABLE_100
83: , a34 out nocopy JTF_VARCHAR2_TABLE_100
84: , a35 out nocopy JTF_VARCHAR2_TABLE_100
85: , a36 out nocopy JTF_VARCHAR2_TABLE_100
86: , a37 out nocopy JTF_VARCHAR2_TABLE_100
87: , a38 out nocopy JTF_VARCHAR2_TABLE_100
88: , a39 out nocopy JTF_NUMBER_TABLE

Line 85: , a36 out nocopy JTF_VARCHAR2_TABLE_100

81: , a32 out nocopy JTF_VARCHAR2_TABLE_100
82: , a33 out nocopy JTF_VARCHAR2_TABLE_100
83: , a34 out nocopy JTF_VARCHAR2_TABLE_100
84: , a35 out nocopy JTF_VARCHAR2_TABLE_100
85: , a36 out nocopy JTF_VARCHAR2_TABLE_100
86: , a37 out nocopy JTF_VARCHAR2_TABLE_100
87: , a38 out nocopy JTF_VARCHAR2_TABLE_100
88: , a39 out nocopy JTF_NUMBER_TABLE
89: , a40 out nocopy JTF_NUMBER_TABLE

Line 86: , a37 out nocopy JTF_VARCHAR2_TABLE_100

82: , a33 out nocopy JTF_VARCHAR2_TABLE_100
83: , a34 out nocopy JTF_VARCHAR2_TABLE_100
84: , a35 out nocopy JTF_VARCHAR2_TABLE_100
85: , a36 out nocopy JTF_VARCHAR2_TABLE_100
86: , a37 out nocopy JTF_VARCHAR2_TABLE_100
87: , a38 out nocopy JTF_VARCHAR2_TABLE_100
88: , a39 out nocopy JTF_NUMBER_TABLE
89: , a40 out nocopy JTF_NUMBER_TABLE
90: , a41 out nocopy JTF_VARCHAR2_TABLE_4000

Line 87: , a38 out nocopy JTF_VARCHAR2_TABLE_100

83: , a34 out nocopy JTF_VARCHAR2_TABLE_100
84: , a35 out nocopy JTF_VARCHAR2_TABLE_100
85: , a36 out nocopy JTF_VARCHAR2_TABLE_100
86: , a37 out nocopy JTF_VARCHAR2_TABLE_100
87: , a38 out nocopy JTF_VARCHAR2_TABLE_100
88: , a39 out nocopy JTF_NUMBER_TABLE
89: , a40 out nocopy JTF_NUMBER_TABLE
90: , a41 out nocopy JTF_VARCHAR2_TABLE_4000
91: , a42 out nocopy JTF_NUMBER_TABLE

Line 92: , a43 out nocopy JTF_VARCHAR2_TABLE_100

88: , a39 out nocopy JTF_NUMBER_TABLE
89: , a40 out nocopy JTF_NUMBER_TABLE
90: , a41 out nocopy JTF_VARCHAR2_TABLE_4000
91: , a42 out nocopy JTF_NUMBER_TABLE
92: , a43 out nocopy JTF_VARCHAR2_TABLE_100
93: , a44 out nocopy JTF_VARCHAR2_TABLE_100
94: );
95:
96: procedure rosetta_table_copy_in_p4(t out nocopy cac_sync_task.exclusion_tbl, a0 JTF_NUMBER_TABLE

Line 93: , a44 out nocopy JTF_VARCHAR2_TABLE_100

89: , a40 out nocopy JTF_NUMBER_TABLE
90: , a41 out nocopy JTF_VARCHAR2_TABLE_4000
91: , a42 out nocopy JTF_NUMBER_TABLE
92: , a43 out nocopy JTF_VARCHAR2_TABLE_100
93: , a44 out nocopy JTF_VARCHAR2_TABLE_100
94: );
95:
96: procedure rosetta_table_copy_in_p4(t out nocopy cac_sync_task.exclusion_tbl, a0 JTF_NUMBER_TABLE
97: , a1 JTF_DATE_TABLE

Line 102: , a6 JTF_VARCHAR2_TABLE_100

98: , a2 JTF_NUMBER_TABLE
99: , a3 JTF_NUMBER_TABLE
100: , a4 JTF_DATE_TABLE
101: , a5 JTF_NUMBER_TABLE
102: , a6 JTF_VARCHAR2_TABLE_100
103: , a7 JTF_VARCHAR2_TABLE_100
104: , a8 JTF_VARCHAR2_TABLE_2000
105: , a9 JTF_VARCHAR2_TABLE_4000
106: , a10 JTF_VARCHAR2_TABLE_100

Line 103: , a7 JTF_VARCHAR2_TABLE_100

99: , a3 JTF_NUMBER_TABLE
100: , a4 JTF_DATE_TABLE
101: , a5 JTF_NUMBER_TABLE
102: , a6 JTF_VARCHAR2_TABLE_100
103: , a7 JTF_VARCHAR2_TABLE_100
104: , a8 JTF_VARCHAR2_TABLE_2000
105: , a9 JTF_VARCHAR2_TABLE_4000
106: , a10 JTF_VARCHAR2_TABLE_100
107: , a11 JTF_DATE_TABLE

Line 106: , a10 JTF_VARCHAR2_TABLE_100

102: , a6 JTF_VARCHAR2_TABLE_100
103: , a7 JTF_VARCHAR2_TABLE_100
104: , a8 JTF_VARCHAR2_TABLE_2000
105: , a9 JTF_VARCHAR2_TABLE_4000
106: , a10 JTF_VARCHAR2_TABLE_100
107: , a11 JTF_DATE_TABLE
108: , a12 JTF_DATE_TABLE
109: , a13 JTF_DATE_TABLE
110: , a14 JTF_DATE_TABLE

Line 115: , a19 JTF_VARCHAR2_TABLE_100

111: , a15 JTF_DATE_TABLE
112: , a16 JTF_DATE_TABLE
113: , a17 JTF_NUMBER_TABLE
114: , a18 JTF_NUMBER_TABLE
115: , a19 JTF_VARCHAR2_TABLE_100
116: , a20 JTF_DATE_TABLE
117: , a21 JTF_VARCHAR2_TABLE_100
118: , a22 JTF_VARCHAR2_TABLE_300
119: , a23 JTF_NUMBER_TABLE

Line 117: , a21 JTF_VARCHAR2_TABLE_100

113: , a17 JTF_NUMBER_TABLE
114: , a18 JTF_NUMBER_TABLE
115: , a19 JTF_VARCHAR2_TABLE_100
116: , a20 JTF_DATE_TABLE
117: , a21 JTF_VARCHAR2_TABLE_100
118: , a22 JTF_VARCHAR2_TABLE_300
119: , a23 JTF_NUMBER_TABLE
120: , a24 JTF_VARCHAR2_TABLE_2000
121: , a25 JTF_NUMBER_TABLE

Line 125: , a29 JTF_VARCHAR2_TABLE_100

121: , a25 JTF_NUMBER_TABLE
122: , a26 JTF_NUMBER_TABLE
123: , a27 JTF_VARCHAR2_TABLE_300
124: , a28 JTF_VARCHAR2_TABLE_2000
125: , a29 JTF_VARCHAR2_TABLE_100
126: , a30 JTF_NUMBER_TABLE
127: , a31 JTF_DATE_TABLE
128: , a32 JTF_DATE_TABLE
129: , a33 JTF_VARCHAR2_TABLE_100

Line 129: , a33 JTF_VARCHAR2_TABLE_100

125: , a29 JTF_VARCHAR2_TABLE_100
126: , a30 JTF_NUMBER_TABLE
127: , a31 JTF_DATE_TABLE
128: , a32 JTF_DATE_TABLE
129: , a33 JTF_VARCHAR2_TABLE_100
130: , a34 JTF_VARCHAR2_TABLE_100
131: , a35 JTF_VARCHAR2_TABLE_100
132: , a36 JTF_VARCHAR2_TABLE_100
133: , a37 JTF_VARCHAR2_TABLE_100

Line 130: , a34 JTF_VARCHAR2_TABLE_100

126: , a30 JTF_NUMBER_TABLE
127: , a31 JTF_DATE_TABLE
128: , a32 JTF_DATE_TABLE
129: , a33 JTF_VARCHAR2_TABLE_100
130: , a34 JTF_VARCHAR2_TABLE_100
131: , a35 JTF_VARCHAR2_TABLE_100
132: , a36 JTF_VARCHAR2_TABLE_100
133: , a37 JTF_VARCHAR2_TABLE_100
134: , a38 JTF_VARCHAR2_TABLE_100

Line 131: , a35 JTF_VARCHAR2_TABLE_100

127: , a31 JTF_DATE_TABLE
128: , a32 JTF_DATE_TABLE
129: , a33 JTF_VARCHAR2_TABLE_100
130: , a34 JTF_VARCHAR2_TABLE_100
131: , a35 JTF_VARCHAR2_TABLE_100
132: , a36 JTF_VARCHAR2_TABLE_100
133: , a37 JTF_VARCHAR2_TABLE_100
134: , a38 JTF_VARCHAR2_TABLE_100
135: , a39 JTF_VARCHAR2_TABLE_100

Line 132: , a36 JTF_VARCHAR2_TABLE_100

128: , a32 JTF_DATE_TABLE
129: , a33 JTF_VARCHAR2_TABLE_100
130: , a34 JTF_VARCHAR2_TABLE_100
131: , a35 JTF_VARCHAR2_TABLE_100
132: , a36 JTF_VARCHAR2_TABLE_100
133: , a37 JTF_VARCHAR2_TABLE_100
134: , a38 JTF_VARCHAR2_TABLE_100
135: , a39 JTF_VARCHAR2_TABLE_100
136: , a40 JTF_NUMBER_TABLE

Line 133: , a37 JTF_VARCHAR2_TABLE_100

129: , a33 JTF_VARCHAR2_TABLE_100
130: , a34 JTF_VARCHAR2_TABLE_100
131: , a35 JTF_VARCHAR2_TABLE_100
132: , a36 JTF_VARCHAR2_TABLE_100
133: , a37 JTF_VARCHAR2_TABLE_100
134: , a38 JTF_VARCHAR2_TABLE_100
135: , a39 JTF_VARCHAR2_TABLE_100
136: , a40 JTF_NUMBER_TABLE
137: , a41 JTF_NUMBER_TABLE

Line 134: , a38 JTF_VARCHAR2_TABLE_100

130: , a34 JTF_VARCHAR2_TABLE_100
131: , a35 JTF_VARCHAR2_TABLE_100
132: , a36 JTF_VARCHAR2_TABLE_100
133: , a37 JTF_VARCHAR2_TABLE_100
134: , a38 JTF_VARCHAR2_TABLE_100
135: , a39 JTF_VARCHAR2_TABLE_100
136: , a40 JTF_NUMBER_TABLE
137: , a41 JTF_NUMBER_TABLE
138: , a42 JTF_VARCHAR2_TABLE_4000

Line 135: , a39 JTF_VARCHAR2_TABLE_100

131: , a35 JTF_VARCHAR2_TABLE_100
132: , a36 JTF_VARCHAR2_TABLE_100
133: , a37 JTF_VARCHAR2_TABLE_100
134: , a38 JTF_VARCHAR2_TABLE_100
135: , a39 JTF_VARCHAR2_TABLE_100
136: , a40 JTF_NUMBER_TABLE
137: , a41 JTF_NUMBER_TABLE
138: , a42 JTF_VARCHAR2_TABLE_4000
139: , a43 JTF_NUMBER_TABLE

Line 140: , a44 JTF_VARCHAR2_TABLE_100

136: , a40 JTF_NUMBER_TABLE
137: , a41 JTF_NUMBER_TABLE
138: , a42 JTF_VARCHAR2_TABLE_4000
139: , a43 JTF_NUMBER_TABLE
140: , a44 JTF_VARCHAR2_TABLE_100
141: , a45 JTF_VARCHAR2_TABLE_100
142: );
143: procedure rosetta_table_copy_out_p4(t cac_sync_task.exclusion_tbl, a0 out nocopy JTF_NUMBER_TABLE
144: , a1 out nocopy JTF_DATE_TABLE

Line 141: , a45 JTF_VARCHAR2_TABLE_100

137: , a41 JTF_NUMBER_TABLE
138: , a42 JTF_VARCHAR2_TABLE_4000
139: , a43 JTF_NUMBER_TABLE
140: , a44 JTF_VARCHAR2_TABLE_100
141: , a45 JTF_VARCHAR2_TABLE_100
142: );
143: procedure rosetta_table_copy_out_p4(t cac_sync_task.exclusion_tbl, a0 out nocopy JTF_NUMBER_TABLE
144: , a1 out nocopy JTF_DATE_TABLE
145: , a2 out nocopy JTF_NUMBER_TABLE

Line 149: , a6 out nocopy JTF_VARCHAR2_TABLE_100

145: , a2 out nocopy JTF_NUMBER_TABLE
146: , a3 out nocopy JTF_NUMBER_TABLE
147: , a4 out nocopy JTF_DATE_TABLE
148: , a5 out nocopy JTF_NUMBER_TABLE
149: , a6 out nocopy JTF_VARCHAR2_TABLE_100
150: , a7 out nocopy JTF_VARCHAR2_TABLE_100
151: , a8 out nocopy JTF_VARCHAR2_TABLE_2000
152: , a9 out nocopy JTF_VARCHAR2_TABLE_4000
153: , a10 out nocopy JTF_VARCHAR2_TABLE_100

Line 150: , a7 out nocopy JTF_VARCHAR2_TABLE_100

146: , a3 out nocopy JTF_NUMBER_TABLE
147: , a4 out nocopy JTF_DATE_TABLE
148: , a5 out nocopy JTF_NUMBER_TABLE
149: , a6 out nocopy JTF_VARCHAR2_TABLE_100
150: , a7 out nocopy JTF_VARCHAR2_TABLE_100
151: , a8 out nocopy JTF_VARCHAR2_TABLE_2000
152: , a9 out nocopy JTF_VARCHAR2_TABLE_4000
153: , a10 out nocopy JTF_VARCHAR2_TABLE_100
154: , a11 out nocopy JTF_DATE_TABLE

Line 153: , a10 out nocopy JTF_VARCHAR2_TABLE_100

149: , a6 out nocopy JTF_VARCHAR2_TABLE_100
150: , a7 out nocopy JTF_VARCHAR2_TABLE_100
151: , a8 out nocopy JTF_VARCHAR2_TABLE_2000
152: , a9 out nocopy JTF_VARCHAR2_TABLE_4000
153: , a10 out nocopy JTF_VARCHAR2_TABLE_100
154: , a11 out nocopy JTF_DATE_TABLE
155: , a12 out nocopy JTF_DATE_TABLE
156: , a13 out nocopy JTF_DATE_TABLE
157: , a14 out nocopy JTF_DATE_TABLE

Line 162: , a19 out nocopy JTF_VARCHAR2_TABLE_100

158: , a15 out nocopy JTF_DATE_TABLE
159: , a16 out nocopy JTF_DATE_TABLE
160: , a17 out nocopy JTF_NUMBER_TABLE
161: , a18 out nocopy JTF_NUMBER_TABLE
162: , a19 out nocopy JTF_VARCHAR2_TABLE_100
163: , a20 out nocopy JTF_DATE_TABLE
164: , a21 out nocopy JTF_VARCHAR2_TABLE_100
165: , a22 out nocopy JTF_VARCHAR2_TABLE_300
166: , a23 out nocopy JTF_NUMBER_TABLE

Line 164: , a21 out nocopy JTF_VARCHAR2_TABLE_100

160: , a17 out nocopy JTF_NUMBER_TABLE
161: , a18 out nocopy JTF_NUMBER_TABLE
162: , a19 out nocopy JTF_VARCHAR2_TABLE_100
163: , a20 out nocopy JTF_DATE_TABLE
164: , a21 out nocopy JTF_VARCHAR2_TABLE_100
165: , a22 out nocopy JTF_VARCHAR2_TABLE_300
166: , a23 out nocopy JTF_NUMBER_TABLE
167: , a24 out nocopy JTF_VARCHAR2_TABLE_2000
168: , a25 out nocopy JTF_NUMBER_TABLE

Line 172: , a29 out nocopy JTF_VARCHAR2_TABLE_100

168: , a25 out nocopy JTF_NUMBER_TABLE
169: , a26 out nocopy JTF_NUMBER_TABLE
170: , a27 out nocopy JTF_VARCHAR2_TABLE_300
171: , a28 out nocopy JTF_VARCHAR2_TABLE_2000
172: , a29 out nocopy JTF_VARCHAR2_TABLE_100
173: , a30 out nocopy JTF_NUMBER_TABLE
174: , a31 out nocopy JTF_DATE_TABLE
175: , a32 out nocopy JTF_DATE_TABLE
176: , a33 out nocopy JTF_VARCHAR2_TABLE_100

Line 176: , a33 out nocopy JTF_VARCHAR2_TABLE_100

172: , a29 out nocopy JTF_VARCHAR2_TABLE_100
173: , a30 out nocopy JTF_NUMBER_TABLE
174: , a31 out nocopy JTF_DATE_TABLE
175: , a32 out nocopy JTF_DATE_TABLE
176: , a33 out nocopy JTF_VARCHAR2_TABLE_100
177: , a34 out nocopy JTF_VARCHAR2_TABLE_100
178: , a35 out nocopy JTF_VARCHAR2_TABLE_100
179: , a36 out nocopy JTF_VARCHAR2_TABLE_100
180: , a37 out nocopy JTF_VARCHAR2_TABLE_100

Line 177: , a34 out nocopy JTF_VARCHAR2_TABLE_100

173: , a30 out nocopy JTF_NUMBER_TABLE
174: , a31 out nocopy JTF_DATE_TABLE
175: , a32 out nocopy JTF_DATE_TABLE
176: , a33 out nocopy JTF_VARCHAR2_TABLE_100
177: , a34 out nocopy JTF_VARCHAR2_TABLE_100
178: , a35 out nocopy JTF_VARCHAR2_TABLE_100
179: , a36 out nocopy JTF_VARCHAR2_TABLE_100
180: , a37 out nocopy JTF_VARCHAR2_TABLE_100
181: , a38 out nocopy JTF_VARCHAR2_TABLE_100

Line 178: , a35 out nocopy JTF_VARCHAR2_TABLE_100

174: , a31 out nocopy JTF_DATE_TABLE
175: , a32 out nocopy JTF_DATE_TABLE
176: , a33 out nocopy JTF_VARCHAR2_TABLE_100
177: , a34 out nocopy JTF_VARCHAR2_TABLE_100
178: , a35 out nocopy JTF_VARCHAR2_TABLE_100
179: , a36 out nocopy JTF_VARCHAR2_TABLE_100
180: , a37 out nocopy JTF_VARCHAR2_TABLE_100
181: , a38 out nocopy JTF_VARCHAR2_TABLE_100
182: , a39 out nocopy JTF_VARCHAR2_TABLE_100

Line 179: , a36 out nocopy JTF_VARCHAR2_TABLE_100

175: , a32 out nocopy JTF_DATE_TABLE
176: , a33 out nocopy JTF_VARCHAR2_TABLE_100
177: , a34 out nocopy JTF_VARCHAR2_TABLE_100
178: , a35 out nocopy JTF_VARCHAR2_TABLE_100
179: , a36 out nocopy JTF_VARCHAR2_TABLE_100
180: , a37 out nocopy JTF_VARCHAR2_TABLE_100
181: , a38 out nocopy JTF_VARCHAR2_TABLE_100
182: , a39 out nocopy JTF_VARCHAR2_TABLE_100
183: , a40 out nocopy JTF_NUMBER_TABLE

Line 180: , a37 out nocopy JTF_VARCHAR2_TABLE_100

176: , a33 out nocopy JTF_VARCHAR2_TABLE_100
177: , a34 out nocopy JTF_VARCHAR2_TABLE_100
178: , a35 out nocopy JTF_VARCHAR2_TABLE_100
179: , a36 out nocopy JTF_VARCHAR2_TABLE_100
180: , a37 out nocopy JTF_VARCHAR2_TABLE_100
181: , a38 out nocopy JTF_VARCHAR2_TABLE_100
182: , a39 out nocopy JTF_VARCHAR2_TABLE_100
183: , a40 out nocopy JTF_NUMBER_TABLE
184: , a41 out nocopy JTF_NUMBER_TABLE

Line 181: , a38 out nocopy JTF_VARCHAR2_TABLE_100

177: , a34 out nocopy JTF_VARCHAR2_TABLE_100
178: , a35 out nocopy JTF_VARCHAR2_TABLE_100
179: , a36 out nocopy JTF_VARCHAR2_TABLE_100
180: , a37 out nocopy JTF_VARCHAR2_TABLE_100
181: , a38 out nocopy JTF_VARCHAR2_TABLE_100
182: , a39 out nocopy JTF_VARCHAR2_TABLE_100
183: , a40 out nocopy JTF_NUMBER_TABLE
184: , a41 out nocopy JTF_NUMBER_TABLE
185: , a42 out nocopy JTF_VARCHAR2_TABLE_4000

Line 182: , a39 out nocopy JTF_VARCHAR2_TABLE_100

178: , a35 out nocopy JTF_VARCHAR2_TABLE_100
179: , a36 out nocopy JTF_VARCHAR2_TABLE_100
180: , a37 out nocopy JTF_VARCHAR2_TABLE_100
181: , a38 out nocopy JTF_VARCHAR2_TABLE_100
182: , a39 out nocopy JTF_VARCHAR2_TABLE_100
183: , a40 out nocopy JTF_NUMBER_TABLE
184: , a41 out nocopy JTF_NUMBER_TABLE
185: , a42 out nocopy JTF_VARCHAR2_TABLE_4000
186: , a43 out nocopy JTF_NUMBER_TABLE

Line 187: , a44 out nocopy JTF_VARCHAR2_TABLE_100

183: , a40 out nocopy JTF_NUMBER_TABLE
184: , a41 out nocopy JTF_NUMBER_TABLE
185: , a42 out nocopy JTF_VARCHAR2_TABLE_4000
186: , a43 out nocopy JTF_NUMBER_TABLE
187: , a44 out nocopy JTF_VARCHAR2_TABLE_100
188: , a45 out nocopy JTF_VARCHAR2_TABLE_100
189: );
190:
191: procedure rosetta_table_copy_in_p6(t out nocopy cac_sync_task.attendee_tbl, a0 JTF_NUMBER_TABLE

Line 188: , a45 out nocopy JTF_VARCHAR2_TABLE_100

184: , a41 out nocopy JTF_NUMBER_TABLE
185: , a42 out nocopy JTF_VARCHAR2_TABLE_4000
186: , a43 out nocopy JTF_NUMBER_TABLE
187: , a44 out nocopy JTF_VARCHAR2_TABLE_100
188: , a45 out nocopy JTF_VARCHAR2_TABLE_100
189: );
190:
191: procedure rosetta_table_copy_in_p6(t out nocopy cac_sync_task.attendee_tbl, a0 JTF_NUMBER_TABLE
192: , a1 JTF_VARCHAR2_TABLE_2000

Line 197: , a6 JTF_VARCHAR2_TABLE_100

193: , a2 JTF_NUMBER_TABLE
194: , a3 JTF_NUMBER_TABLE
195: , a4 JTF_VARCHAR2_TABLE_2000
196: , a5 JTF_VARCHAR2_TABLE_200
197: , a6 JTF_VARCHAR2_TABLE_100
198: , a7 JTF_VARCHAR2_TABLE_200
199: , a8 JTF_VARCHAR2_TABLE_100
200: , a9 JTF_VARCHAR2_TABLE_100
201: , a10 JTF_VARCHAR2_TABLE_100

Line 199: , a8 JTF_VARCHAR2_TABLE_100

195: , a4 JTF_VARCHAR2_TABLE_2000
196: , a5 JTF_VARCHAR2_TABLE_200
197: , a6 JTF_VARCHAR2_TABLE_100
198: , a7 JTF_VARCHAR2_TABLE_200
199: , a8 JTF_VARCHAR2_TABLE_100
200: , a9 JTF_VARCHAR2_TABLE_100
201: , a10 JTF_VARCHAR2_TABLE_100
202: , a11 JTF_VARCHAR2_TABLE_100
203: , a12 JTF_VARCHAR2_TABLE_2000

Line 200: , a9 JTF_VARCHAR2_TABLE_100

196: , a5 JTF_VARCHAR2_TABLE_200
197: , a6 JTF_VARCHAR2_TABLE_100
198: , a7 JTF_VARCHAR2_TABLE_200
199: , a8 JTF_VARCHAR2_TABLE_100
200: , a9 JTF_VARCHAR2_TABLE_100
201: , a10 JTF_VARCHAR2_TABLE_100
202: , a11 JTF_VARCHAR2_TABLE_100
203: , a12 JTF_VARCHAR2_TABLE_2000
204: , a13 JTF_VARCHAR2_TABLE_100

Line 201: , a10 JTF_VARCHAR2_TABLE_100

197: , a6 JTF_VARCHAR2_TABLE_100
198: , a7 JTF_VARCHAR2_TABLE_200
199: , a8 JTF_VARCHAR2_TABLE_100
200: , a9 JTF_VARCHAR2_TABLE_100
201: , a10 JTF_VARCHAR2_TABLE_100
202: , a11 JTF_VARCHAR2_TABLE_100
203: , a12 JTF_VARCHAR2_TABLE_2000
204: , a13 JTF_VARCHAR2_TABLE_100
205: );

Line 202: , a11 JTF_VARCHAR2_TABLE_100

198: , a7 JTF_VARCHAR2_TABLE_200
199: , a8 JTF_VARCHAR2_TABLE_100
200: , a9 JTF_VARCHAR2_TABLE_100
201: , a10 JTF_VARCHAR2_TABLE_100
202: , a11 JTF_VARCHAR2_TABLE_100
203: , a12 JTF_VARCHAR2_TABLE_2000
204: , a13 JTF_VARCHAR2_TABLE_100
205: );
206: procedure rosetta_table_copy_out_p6(t cac_sync_task.attendee_tbl, a0 out nocopy JTF_NUMBER_TABLE

Line 204: , a13 JTF_VARCHAR2_TABLE_100

200: , a9 JTF_VARCHAR2_TABLE_100
201: , a10 JTF_VARCHAR2_TABLE_100
202: , a11 JTF_VARCHAR2_TABLE_100
203: , a12 JTF_VARCHAR2_TABLE_2000
204: , a13 JTF_VARCHAR2_TABLE_100
205: );
206: procedure rosetta_table_copy_out_p6(t cac_sync_task.attendee_tbl, a0 out nocopy JTF_NUMBER_TABLE
207: , a1 out nocopy JTF_VARCHAR2_TABLE_2000
208: , a2 out nocopy JTF_NUMBER_TABLE

Line 212: , a6 out nocopy JTF_VARCHAR2_TABLE_100

208: , a2 out nocopy JTF_NUMBER_TABLE
209: , a3 out nocopy JTF_NUMBER_TABLE
210: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
211: , a5 out nocopy JTF_VARCHAR2_TABLE_200
212: , a6 out nocopy JTF_VARCHAR2_TABLE_100
213: , a7 out nocopy JTF_VARCHAR2_TABLE_200
214: , a8 out nocopy JTF_VARCHAR2_TABLE_100
215: , a9 out nocopy JTF_VARCHAR2_TABLE_100
216: , a10 out nocopy JTF_VARCHAR2_TABLE_100

Line 214: , a8 out nocopy JTF_VARCHAR2_TABLE_100

210: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
211: , a5 out nocopy JTF_VARCHAR2_TABLE_200
212: , a6 out nocopy JTF_VARCHAR2_TABLE_100
213: , a7 out nocopy JTF_VARCHAR2_TABLE_200
214: , a8 out nocopy JTF_VARCHAR2_TABLE_100
215: , a9 out nocopy JTF_VARCHAR2_TABLE_100
216: , a10 out nocopy JTF_VARCHAR2_TABLE_100
217: , a11 out nocopy JTF_VARCHAR2_TABLE_100
218: , a12 out nocopy JTF_VARCHAR2_TABLE_2000

Line 215: , a9 out nocopy JTF_VARCHAR2_TABLE_100

211: , a5 out nocopy JTF_VARCHAR2_TABLE_200
212: , a6 out nocopy JTF_VARCHAR2_TABLE_100
213: , a7 out nocopy JTF_VARCHAR2_TABLE_200
214: , a8 out nocopy JTF_VARCHAR2_TABLE_100
215: , a9 out nocopy JTF_VARCHAR2_TABLE_100
216: , a10 out nocopy JTF_VARCHAR2_TABLE_100
217: , a11 out nocopy JTF_VARCHAR2_TABLE_100
218: , a12 out nocopy JTF_VARCHAR2_TABLE_2000
219: , a13 out nocopy JTF_VARCHAR2_TABLE_100

Line 216: , a10 out nocopy JTF_VARCHAR2_TABLE_100

212: , a6 out nocopy JTF_VARCHAR2_TABLE_100
213: , a7 out nocopy JTF_VARCHAR2_TABLE_200
214: , a8 out nocopy JTF_VARCHAR2_TABLE_100
215: , a9 out nocopy JTF_VARCHAR2_TABLE_100
216: , a10 out nocopy JTF_VARCHAR2_TABLE_100
217: , a11 out nocopy JTF_VARCHAR2_TABLE_100
218: , a12 out nocopy JTF_VARCHAR2_TABLE_2000
219: , a13 out nocopy JTF_VARCHAR2_TABLE_100
220: );

Line 217: , a11 out nocopy JTF_VARCHAR2_TABLE_100

213: , a7 out nocopy JTF_VARCHAR2_TABLE_200
214: , a8 out nocopy JTF_VARCHAR2_TABLE_100
215: , a9 out nocopy JTF_VARCHAR2_TABLE_100
216: , a10 out nocopy JTF_VARCHAR2_TABLE_100
217: , a11 out nocopy JTF_VARCHAR2_TABLE_100
218: , a12 out nocopy JTF_VARCHAR2_TABLE_2000
219: , a13 out nocopy JTF_VARCHAR2_TABLE_100
220: );
221:

Line 219: , a13 out nocopy JTF_VARCHAR2_TABLE_100

215: , a9 out nocopy JTF_VARCHAR2_TABLE_100
216: , a10 out nocopy JTF_VARCHAR2_TABLE_100
217: , a11 out nocopy JTF_VARCHAR2_TABLE_100
218: , a12 out nocopy JTF_VARCHAR2_TABLE_2000
219: , a13 out nocopy JTF_VARCHAR2_TABLE_100
220: );
221:
222: procedure get_count(p_request_type VARCHAR2
223: , p_syncanchor date

Line 239: , p4_a5 out nocopy JTF_VARCHAR2_TABLE_100

235: , p4_a1 out nocopy JTF_NUMBER_TABLE
236: , p4_a2 out nocopy JTF_NUMBER_TABLE
237: , p4_a3 out nocopy JTF_DATE_TABLE
238: , p4_a4 out nocopy JTF_NUMBER_TABLE
239: , p4_a5 out nocopy JTF_VARCHAR2_TABLE_100
240: , p4_a6 out nocopy JTF_VARCHAR2_TABLE_100
241: , p4_a7 out nocopy JTF_VARCHAR2_TABLE_2000
242: , p4_a8 out nocopy JTF_VARCHAR2_TABLE_4000
243: , p4_a9 out nocopy JTF_VARCHAR2_TABLE_100

Line 240: , p4_a6 out nocopy JTF_VARCHAR2_TABLE_100

236: , p4_a2 out nocopy JTF_NUMBER_TABLE
237: , p4_a3 out nocopy JTF_DATE_TABLE
238: , p4_a4 out nocopy JTF_NUMBER_TABLE
239: , p4_a5 out nocopy JTF_VARCHAR2_TABLE_100
240: , p4_a6 out nocopy JTF_VARCHAR2_TABLE_100
241: , p4_a7 out nocopy JTF_VARCHAR2_TABLE_2000
242: , p4_a8 out nocopy JTF_VARCHAR2_TABLE_4000
243: , p4_a9 out nocopy JTF_VARCHAR2_TABLE_100
244: , p4_a10 out nocopy JTF_DATE_TABLE

Line 243: , p4_a9 out nocopy JTF_VARCHAR2_TABLE_100

239: , p4_a5 out nocopy JTF_VARCHAR2_TABLE_100
240: , p4_a6 out nocopy JTF_VARCHAR2_TABLE_100
241: , p4_a7 out nocopy JTF_VARCHAR2_TABLE_2000
242: , p4_a8 out nocopy JTF_VARCHAR2_TABLE_4000
243: , p4_a9 out nocopy JTF_VARCHAR2_TABLE_100
244: , p4_a10 out nocopy JTF_DATE_TABLE
245: , p4_a11 out nocopy JTF_DATE_TABLE
246: , p4_a12 out nocopy JTF_DATE_TABLE
247: , p4_a13 out nocopy JTF_DATE_TABLE

Line 252: , p4_a18 out nocopy JTF_VARCHAR2_TABLE_100

248: , p4_a14 out nocopy JTF_DATE_TABLE
249: , p4_a15 out nocopy JTF_DATE_TABLE
250: , p4_a16 out nocopy JTF_NUMBER_TABLE
251: , p4_a17 out nocopy JTF_NUMBER_TABLE
252: , p4_a18 out nocopy JTF_VARCHAR2_TABLE_100
253: , p4_a19 out nocopy JTF_DATE_TABLE
254: , p4_a20 out nocopy JTF_VARCHAR2_TABLE_100
255: , p4_a21 out nocopy JTF_VARCHAR2_TABLE_300
256: , p4_a22 out nocopy JTF_NUMBER_TABLE

Line 254: , p4_a20 out nocopy JTF_VARCHAR2_TABLE_100

250: , p4_a16 out nocopy JTF_NUMBER_TABLE
251: , p4_a17 out nocopy JTF_NUMBER_TABLE
252: , p4_a18 out nocopy JTF_VARCHAR2_TABLE_100
253: , p4_a19 out nocopy JTF_DATE_TABLE
254: , p4_a20 out nocopy JTF_VARCHAR2_TABLE_100
255: , p4_a21 out nocopy JTF_VARCHAR2_TABLE_300
256: , p4_a22 out nocopy JTF_NUMBER_TABLE
257: , p4_a23 out nocopy JTF_VARCHAR2_TABLE_2000
258: , p4_a24 out nocopy JTF_NUMBER_TABLE

Line 262: , p4_a28 out nocopy JTF_VARCHAR2_TABLE_100

258: , p4_a24 out nocopy JTF_NUMBER_TABLE
259: , p4_a25 out nocopy JTF_NUMBER_TABLE
260: , p4_a26 out nocopy JTF_VARCHAR2_TABLE_300
261: , p4_a27 out nocopy JTF_VARCHAR2_TABLE_2000
262: , p4_a28 out nocopy JTF_VARCHAR2_TABLE_100
263: , p4_a29 out nocopy JTF_NUMBER_TABLE
264: , p4_a30 out nocopy JTF_DATE_TABLE
265: , p4_a31 out nocopy JTF_DATE_TABLE
266: , p4_a32 out nocopy JTF_VARCHAR2_TABLE_100

Line 266: , p4_a32 out nocopy JTF_VARCHAR2_TABLE_100

262: , p4_a28 out nocopy JTF_VARCHAR2_TABLE_100
263: , p4_a29 out nocopy JTF_NUMBER_TABLE
264: , p4_a30 out nocopy JTF_DATE_TABLE
265: , p4_a31 out nocopy JTF_DATE_TABLE
266: , p4_a32 out nocopy JTF_VARCHAR2_TABLE_100
267: , p4_a33 out nocopy JTF_VARCHAR2_TABLE_100
268: , p4_a34 out nocopy JTF_VARCHAR2_TABLE_100
269: , p4_a35 out nocopy JTF_VARCHAR2_TABLE_100
270: , p4_a36 out nocopy JTF_VARCHAR2_TABLE_100

Line 267: , p4_a33 out nocopy JTF_VARCHAR2_TABLE_100

263: , p4_a29 out nocopy JTF_NUMBER_TABLE
264: , p4_a30 out nocopy JTF_DATE_TABLE
265: , p4_a31 out nocopy JTF_DATE_TABLE
266: , p4_a32 out nocopy JTF_VARCHAR2_TABLE_100
267: , p4_a33 out nocopy JTF_VARCHAR2_TABLE_100
268: , p4_a34 out nocopy JTF_VARCHAR2_TABLE_100
269: , p4_a35 out nocopy JTF_VARCHAR2_TABLE_100
270: , p4_a36 out nocopy JTF_VARCHAR2_TABLE_100
271: , p4_a37 out nocopy JTF_VARCHAR2_TABLE_100

Line 268: , p4_a34 out nocopy JTF_VARCHAR2_TABLE_100

264: , p4_a30 out nocopy JTF_DATE_TABLE
265: , p4_a31 out nocopy JTF_DATE_TABLE
266: , p4_a32 out nocopy JTF_VARCHAR2_TABLE_100
267: , p4_a33 out nocopy JTF_VARCHAR2_TABLE_100
268: , p4_a34 out nocopy JTF_VARCHAR2_TABLE_100
269: , p4_a35 out nocopy JTF_VARCHAR2_TABLE_100
270: , p4_a36 out nocopy JTF_VARCHAR2_TABLE_100
271: , p4_a37 out nocopy JTF_VARCHAR2_TABLE_100
272: , p4_a38 out nocopy JTF_VARCHAR2_TABLE_100

Line 269: , p4_a35 out nocopy JTF_VARCHAR2_TABLE_100

265: , p4_a31 out nocopy JTF_DATE_TABLE
266: , p4_a32 out nocopy JTF_VARCHAR2_TABLE_100
267: , p4_a33 out nocopy JTF_VARCHAR2_TABLE_100
268: , p4_a34 out nocopy JTF_VARCHAR2_TABLE_100
269: , p4_a35 out nocopy JTF_VARCHAR2_TABLE_100
270: , p4_a36 out nocopy JTF_VARCHAR2_TABLE_100
271: , p4_a37 out nocopy JTF_VARCHAR2_TABLE_100
272: , p4_a38 out nocopy JTF_VARCHAR2_TABLE_100
273: , p4_a39 out nocopy JTF_NUMBER_TABLE

Line 270: , p4_a36 out nocopy JTF_VARCHAR2_TABLE_100

266: , p4_a32 out nocopy JTF_VARCHAR2_TABLE_100
267: , p4_a33 out nocopy JTF_VARCHAR2_TABLE_100
268: , p4_a34 out nocopy JTF_VARCHAR2_TABLE_100
269: , p4_a35 out nocopy JTF_VARCHAR2_TABLE_100
270: , p4_a36 out nocopy JTF_VARCHAR2_TABLE_100
271: , p4_a37 out nocopy JTF_VARCHAR2_TABLE_100
272: , p4_a38 out nocopy JTF_VARCHAR2_TABLE_100
273: , p4_a39 out nocopy JTF_NUMBER_TABLE
274: , p4_a40 out nocopy JTF_NUMBER_TABLE

Line 271: , p4_a37 out nocopy JTF_VARCHAR2_TABLE_100

267: , p4_a33 out nocopy JTF_VARCHAR2_TABLE_100
268: , p4_a34 out nocopy JTF_VARCHAR2_TABLE_100
269: , p4_a35 out nocopy JTF_VARCHAR2_TABLE_100
270: , p4_a36 out nocopy JTF_VARCHAR2_TABLE_100
271: , p4_a37 out nocopy JTF_VARCHAR2_TABLE_100
272: , p4_a38 out nocopy JTF_VARCHAR2_TABLE_100
273: , p4_a39 out nocopy JTF_NUMBER_TABLE
274: , p4_a40 out nocopy JTF_NUMBER_TABLE
275: , p4_a41 out nocopy JTF_VARCHAR2_TABLE_4000

Line 272: , p4_a38 out nocopy JTF_VARCHAR2_TABLE_100

268: , p4_a34 out nocopy JTF_VARCHAR2_TABLE_100
269: , p4_a35 out nocopy JTF_VARCHAR2_TABLE_100
270: , p4_a36 out nocopy JTF_VARCHAR2_TABLE_100
271: , p4_a37 out nocopy JTF_VARCHAR2_TABLE_100
272: , p4_a38 out nocopy JTF_VARCHAR2_TABLE_100
273: , p4_a39 out nocopy JTF_NUMBER_TABLE
274: , p4_a40 out nocopy JTF_NUMBER_TABLE
275: , p4_a41 out nocopy JTF_VARCHAR2_TABLE_4000
276: , p4_a42 out nocopy JTF_NUMBER_TABLE

Line 277: , p4_a43 out nocopy JTF_VARCHAR2_TABLE_100

273: , p4_a39 out nocopy JTF_NUMBER_TABLE
274: , p4_a40 out nocopy JTF_NUMBER_TABLE
275: , p4_a41 out nocopy JTF_VARCHAR2_TABLE_4000
276: , p4_a42 out nocopy JTF_NUMBER_TABLE
277: , p4_a43 out nocopy JTF_VARCHAR2_TABLE_100
278: , p4_a44 out nocopy JTF_VARCHAR2_TABLE_100
279: , p5_a0 out nocopy JTF_NUMBER_TABLE
280: , p5_a1 out nocopy JTF_DATE_TABLE
281: , p5_a2 out nocopy JTF_NUMBER_TABLE

Line 278: , p4_a44 out nocopy JTF_VARCHAR2_TABLE_100

274: , p4_a40 out nocopy JTF_NUMBER_TABLE
275: , p4_a41 out nocopy JTF_VARCHAR2_TABLE_4000
276: , p4_a42 out nocopy JTF_NUMBER_TABLE
277: , p4_a43 out nocopy JTF_VARCHAR2_TABLE_100
278: , p4_a44 out nocopy JTF_VARCHAR2_TABLE_100
279: , p5_a0 out nocopy JTF_NUMBER_TABLE
280: , p5_a1 out nocopy JTF_DATE_TABLE
281: , p5_a2 out nocopy JTF_NUMBER_TABLE
282: , p5_a3 out nocopy JTF_NUMBER_TABLE

Line 285: , p5_a6 out nocopy JTF_VARCHAR2_TABLE_100

281: , p5_a2 out nocopy JTF_NUMBER_TABLE
282: , p5_a3 out nocopy JTF_NUMBER_TABLE
283: , p5_a4 out nocopy JTF_DATE_TABLE
284: , p5_a5 out nocopy JTF_NUMBER_TABLE
285: , p5_a6 out nocopy JTF_VARCHAR2_TABLE_100
286: , p5_a7 out nocopy JTF_VARCHAR2_TABLE_100
287: , p5_a8 out nocopy JTF_VARCHAR2_TABLE_2000
288: , p5_a9 out nocopy JTF_VARCHAR2_TABLE_4000
289: , p5_a10 out nocopy JTF_VARCHAR2_TABLE_100

Line 286: , p5_a7 out nocopy JTF_VARCHAR2_TABLE_100

282: , p5_a3 out nocopy JTF_NUMBER_TABLE
283: , p5_a4 out nocopy JTF_DATE_TABLE
284: , p5_a5 out nocopy JTF_NUMBER_TABLE
285: , p5_a6 out nocopy JTF_VARCHAR2_TABLE_100
286: , p5_a7 out nocopy JTF_VARCHAR2_TABLE_100
287: , p5_a8 out nocopy JTF_VARCHAR2_TABLE_2000
288: , p5_a9 out nocopy JTF_VARCHAR2_TABLE_4000
289: , p5_a10 out nocopy JTF_VARCHAR2_TABLE_100
290: , p5_a11 out nocopy JTF_DATE_TABLE

Line 289: , p5_a10 out nocopy JTF_VARCHAR2_TABLE_100

285: , p5_a6 out nocopy JTF_VARCHAR2_TABLE_100
286: , p5_a7 out nocopy JTF_VARCHAR2_TABLE_100
287: , p5_a8 out nocopy JTF_VARCHAR2_TABLE_2000
288: , p5_a9 out nocopy JTF_VARCHAR2_TABLE_4000
289: , p5_a10 out nocopy JTF_VARCHAR2_TABLE_100
290: , p5_a11 out nocopy JTF_DATE_TABLE
291: , p5_a12 out nocopy JTF_DATE_TABLE
292: , p5_a13 out nocopy JTF_DATE_TABLE
293: , p5_a14 out nocopy JTF_DATE_TABLE

Line 298: , p5_a19 out nocopy JTF_VARCHAR2_TABLE_100

294: , p5_a15 out nocopy JTF_DATE_TABLE
295: , p5_a16 out nocopy JTF_DATE_TABLE
296: , p5_a17 out nocopy JTF_NUMBER_TABLE
297: , p5_a18 out nocopy JTF_NUMBER_TABLE
298: , p5_a19 out nocopy JTF_VARCHAR2_TABLE_100
299: , p5_a20 out nocopy JTF_DATE_TABLE
300: , p5_a21 out nocopy JTF_VARCHAR2_TABLE_100
301: , p5_a22 out nocopy JTF_VARCHAR2_TABLE_300
302: , p5_a23 out nocopy JTF_NUMBER_TABLE

Line 300: , p5_a21 out nocopy JTF_VARCHAR2_TABLE_100

296: , p5_a17 out nocopy JTF_NUMBER_TABLE
297: , p5_a18 out nocopy JTF_NUMBER_TABLE
298: , p5_a19 out nocopy JTF_VARCHAR2_TABLE_100
299: , p5_a20 out nocopy JTF_DATE_TABLE
300: , p5_a21 out nocopy JTF_VARCHAR2_TABLE_100
301: , p5_a22 out nocopy JTF_VARCHAR2_TABLE_300
302: , p5_a23 out nocopy JTF_NUMBER_TABLE
303: , p5_a24 out nocopy JTF_VARCHAR2_TABLE_2000
304: , p5_a25 out nocopy JTF_NUMBER_TABLE

Line 308: , p5_a29 out nocopy JTF_VARCHAR2_TABLE_100

304: , p5_a25 out nocopy JTF_NUMBER_TABLE
305: , p5_a26 out nocopy JTF_NUMBER_TABLE
306: , p5_a27 out nocopy JTF_VARCHAR2_TABLE_300
307: , p5_a28 out nocopy JTF_VARCHAR2_TABLE_2000
308: , p5_a29 out nocopy JTF_VARCHAR2_TABLE_100
309: , p5_a30 out nocopy JTF_NUMBER_TABLE
310: , p5_a31 out nocopy JTF_DATE_TABLE
311: , p5_a32 out nocopy JTF_DATE_TABLE
312: , p5_a33 out nocopy JTF_VARCHAR2_TABLE_100

Line 312: , p5_a33 out nocopy JTF_VARCHAR2_TABLE_100

308: , p5_a29 out nocopy JTF_VARCHAR2_TABLE_100
309: , p5_a30 out nocopy JTF_NUMBER_TABLE
310: , p5_a31 out nocopy JTF_DATE_TABLE
311: , p5_a32 out nocopy JTF_DATE_TABLE
312: , p5_a33 out nocopy JTF_VARCHAR2_TABLE_100
313: , p5_a34 out nocopy JTF_VARCHAR2_TABLE_100
314: , p5_a35 out nocopy JTF_VARCHAR2_TABLE_100
315: , p5_a36 out nocopy JTF_VARCHAR2_TABLE_100
316: , p5_a37 out nocopy JTF_VARCHAR2_TABLE_100

Line 313: , p5_a34 out nocopy JTF_VARCHAR2_TABLE_100

309: , p5_a30 out nocopy JTF_NUMBER_TABLE
310: , p5_a31 out nocopy JTF_DATE_TABLE
311: , p5_a32 out nocopy JTF_DATE_TABLE
312: , p5_a33 out nocopy JTF_VARCHAR2_TABLE_100
313: , p5_a34 out nocopy JTF_VARCHAR2_TABLE_100
314: , p5_a35 out nocopy JTF_VARCHAR2_TABLE_100
315: , p5_a36 out nocopy JTF_VARCHAR2_TABLE_100
316: , p5_a37 out nocopy JTF_VARCHAR2_TABLE_100
317: , p5_a38 out nocopy JTF_VARCHAR2_TABLE_100

Line 314: , p5_a35 out nocopy JTF_VARCHAR2_TABLE_100

310: , p5_a31 out nocopy JTF_DATE_TABLE
311: , p5_a32 out nocopy JTF_DATE_TABLE
312: , p5_a33 out nocopy JTF_VARCHAR2_TABLE_100
313: , p5_a34 out nocopy JTF_VARCHAR2_TABLE_100
314: , p5_a35 out nocopy JTF_VARCHAR2_TABLE_100
315: , p5_a36 out nocopy JTF_VARCHAR2_TABLE_100
316: , p5_a37 out nocopy JTF_VARCHAR2_TABLE_100
317: , p5_a38 out nocopy JTF_VARCHAR2_TABLE_100
318: , p5_a39 out nocopy JTF_VARCHAR2_TABLE_100

Line 315: , p5_a36 out nocopy JTF_VARCHAR2_TABLE_100

311: , p5_a32 out nocopy JTF_DATE_TABLE
312: , p5_a33 out nocopy JTF_VARCHAR2_TABLE_100
313: , p5_a34 out nocopy JTF_VARCHAR2_TABLE_100
314: , p5_a35 out nocopy JTF_VARCHAR2_TABLE_100
315: , p5_a36 out nocopy JTF_VARCHAR2_TABLE_100
316: , p5_a37 out nocopy JTF_VARCHAR2_TABLE_100
317: , p5_a38 out nocopy JTF_VARCHAR2_TABLE_100
318: , p5_a39 out nocopy JTF_VARCHAR2_TABLE_100
319: , p5_a40 out nocopy JTF_NUMBER_TABLE

Line 316: , p5_a37 out nocopy JTF_VARCHAR2_TABLE_100

312: , p5_a33 out nocopy JTF_VARCHAR2_TABLE_100
313: , p5_a34 out nocopy JTF_VARCHAR2_TABLE_100
314: , p5_a35 out nocopy JTF_VARCHAR2_TABLE_100
315: , p5_a36 out nocopy JTF_VARCHAR2_TABLE_100
316: , p5_a37 out nocopy JTF_VARCHAR2_TABLE_100
317: , p5_a38 out nocopy JTF_VARCHAR2_TABLE_100
318: , p5_a39 out nocopy JTF_VARCHAR2_TABLE_100
319: , p5_a40 out nocopy JTF_NUMBER_TABLE
320: , p5_a41 out nocopy JTF_NUMBER_TABLE

Line 317: , p5_a38 out nocopy JTF_VARCHAR2_TABLE_100

313: , p5_a34 out nocopy JTF_VARCHAR2_TABLE_100
314: , p5_a35 out nocopy JTF_VARCHAR2_TABLE_100
315: , p5_a36 out nocopy JTF_VARCHAR2_TABLE_100
316: , p5_a37 out nocopy JTF_VARCHAR2_TABLE_100
317: , p5_a38 out nocopy JTF_VARCHAR2_TABLE_100
318: , p5_a39 out nocopy JTF_VARCHAR2_TABLE_100
319: , p5_a40 out nocopy JTF_NUMBER_TABLE
320: , p5_a41 out nocopy JTF_NUMBER_TABLE
321: , p5_a42 out nocopy JTF_VARCHAR2_TABLE_4000

Line 318: , p5_a39 out nocopy JTF_VARCHAR2_TABLE_100

314: , p5_a35 out nocopy JTF_VARCHAR2_TABLE_100
315: , p5_a36 out nocopy JTF_VARCHAR2_TABLE_100
316: , p5_a37 out nocopy JTF_VARCHAR2_TABLE_100
317: , p5_a38 out nocopy JTF_VARCHAR2_TABLE_100
318: , p5_a39 out nocopy JTF_VARCHAR2_TABLE_100
319: , p5_a40 out nocopy JTF_NUMBER_TABLE
320: , p5_a41 out nocopy JTF_NUMBER_TABLE
321: , p5_a42 out nocopy JTF_VARCHAR2_TABLE_4000
322: , p5_a43 out nocopy JTF_NUMBER_TABLE

Line 323: , p5_a44 out nocopy JTF_VARCHAR2_TABLE_100

319: , p5_a40 out nocopy JTF_NUMBER_TABLE
320: , p5_a41 out nocopy JTF_NUMBER_TABLE
321: , p5_a42 out nocopy JTF_VARCHAR2_TABLE_4000
322: , p5_a43 out nocopy JTF_NUMBER_TABLE
323: , p5_a44 out nocopy JTF_VARCHAR2_TABLE_100
324: , p5_a45 out nocopy JTF_VARCHAR2_TABLE_100
325: , p6_a0 out nocopy JTF_NUMBER_TABLE
326: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_2000
327: , p6_a2 out nocopy JTF_NUMBER_TABLE

Line 324: , p5_a45 out nocopy JTF_VARCHAR2_TABLE_100

320: , p5_a41 out nocopy JTF_NUMBER_TABLE
321: , p5_a42 out nocopy JTF_VARCHAR2_TABLE_4000
322: , p5_a43 out nocopy JTF_NUMBER_TABLE
323: , p5_a44 out nocopy JTF_VARCHAR2_TABLE_100
324: , p5_a45 out nocopy JTF_VARCHAR2_TABLE_100
325: , p6_a0 out nocopy JTF_NUMBER_TABLE
326: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_2000
327: , p6_a2 out nocopy JTF_NUMBER_TABLE
328: , p6_a3 out nocopy JTF_NUMBER_TABLE

Line 331: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100

327: , p6_a2 out nocopy JTF_NUMBER_TABLE
328: , p6_a3 out nocopy JTF_NUMBER_TABLE
329: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_2000
330: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_200
331: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
332: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_200
333: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
334: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
335: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100

Line 333: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100

329: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_2000
330: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_200
331: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
332: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_200
333: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
334: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
335: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
336: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
337: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_2000

Line 334: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100

330: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_200
331: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
332: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_200
333: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
334: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
335: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
336: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
337: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_2000
338: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100

Line 335: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100

331: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
332: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_200
333: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
334: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
335: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
336: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
337: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_2000
338: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
339: );

Line 336: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100

332: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_200
333: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
334: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
335: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
336: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
337: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_2000
338: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
339: );
340: procedure create_ids(p_num_req NUMBER

Line 338: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100

334: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
335: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
336: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
337: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_2000
338: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
339: );
340: procedure create_ids(p_num_req NUMBER
341: , p1_a0 in out nocopy JTF_NUMBER_TABLE
342: , p1_a1 in out nocopy JTF_NUMBER_TABLE

Line 346: , p1_a5 in out nocopy JTF_VARCHAR2_TABLE_100

342: , p1_a1 in out nocopy JTF_NUMBER_TABLE
343: , p1_a2 in out nocopy JTF_NUMBER_TABLE
344: , p1_a3 in out nocopy JTF_DATE_TABLE
345: , p1_a4 in out nocopy JTF_NUMBER_TABLE
346: , p1_a5 in out nocopy JTF_VARCHAR2_TABLE_100
347: , p1_a6 in out nocopy JTF_VARCHAR2_TABLE_100
348: , p1_a7 in out nocopy JTF_VARCHAR2_TABLE_2000
349: , p1_a8 in out nocopy JTF_VARCHAR2_TABLE_4000
350: , p1_a9 in out nocopy JTF_VARCHAR2_TABLE_100

Line 347: , p1_a6 in out nocopy JTF_VARCHAR2_TABLE_100

343: , p1_a2 in out nocopy JTF_NUMBER_TABLE
344: , p1_a3 in out nocopy JTF_DATE_TABLE
345: , p1_a4 in out nocopy JTF_NUMBER_TABLE
346: , p1_a5 in out nocopy JTF_VARCHAR2_TABLE_100
347: , p1_a6 in out nocopy JTF_VARCHAR2_TABLE_100
348: , p1_a7 in out nocopy JTF_VARCHAR2_TABLE_2000
349: , p1_a8 in out nocopy JTF_VARCHAR2_TABLE_4000
350: , p1_a9 in out nocopy JTF_VARCHAR2_TABLE_100
351: , p1_a10 in out nocopy JTF_DATE_TABLE

Line 350: , p1_a9 in out nocopy JTF_VARCHAR2_TABLE_100

346: , p1_a5 in out nocopy JTF_VARCHAR2_TABLE_100
347: , p1_a6 in out nocopy JTF_VARCHAR2_TABLE_100
348: , p1_a7 in out nocopy JTF_VARCHAR2_TABLE_2000
349: , p1_a8 in out nocopy JTF_VARCHAR2_TABLE_4000
350: , p1_a9 in out nocopy JTF_VARCHAR2_TABLE_100
351: , p1_a10 in out nocopy JTF_DATE_TABLE
352: , p1_a11 in out nocopy JTF_DATE_TABLE
353: , p1_a12 in out nocopy JTF_DATE_TABLE
354: , p1_a13 in out nocopy JTF_DATE_TABLE

Line 359: , p1_a18 in out nocopy JTF_VARCHAR2_TABLE_100

355: , p1_a14 in out nocopy JTF_DATE_TABLE
356: , p1_a15 in out nocopy JTF_DATE_TABLE
357: , p1_a16 in out nocopy JTF_NUMBER_TABLE
358: , p1_a17 in out nocopy JTF_NUMBER_TABLE
359: , p1_a18 in out nocopy JTF_VARCHAR2_TABLE_100
360: , p1_a19 in out nocopy JTF_DATE_TABLE
361: , p1_a20 in out nocopy JTF_VARCHAR2_TABLE_100
362: , p1_a21 in out nocopy JTF_VARCHAR2_TABLE_300
363: , p1_a22 in out nocopy JTF_NUMBER_TABLE

Line 361: , p1_a20 in out nocopy JTF_VARCHAR2_TABLE_100

357: , p1_a16 in out nocopy JTF_NUMBER_TABLE
358: , p1_a17 in out nocopy JTF_NUMBER_TABLE
359: , p1_a18 in out nocopy JTF_VARCHAR2_TABLE_100
360: , p1_a19 in out nocopy JTF_DATE_TABLE
361: , p1_a20 in out nocopy JTF_VARCHAR2_TABLE_100
362: , p1_a21 in out nocopy JTF_VARCHAR2_TABLE_300
363: , p1_a22 in out nocopy JTF_NUMBER_TABLE
364: , p1_a23 in out nocopy JTF_VARCHAR2_TABLE_2000
365: , p1_a24 in out nocopy JTF_NUMBER_TABLE

Line 369: , p1_a28 in out nocopy JTF_VARCHAR2_TABLE_100

365: , p1_a24 in out nocopy JTF_NUMBER_TABLE
366: , p1_a25 in out nocopy JTF_NUMBER_TABLE
367: , p1_a26 in out nocopy JTF_VARCHAR2_TABLE_300
368: , p1_a27 in out nocopy JTF_VARCHAR2_TABLE_2000
369: , p1_a28 in out nocopy JTF_VARCHAR2_TABLE_100
370: , p1_a29 in out nocopy JTF_NUMBER_TABLE
371: , p1_a30 in out nocopy JTF_DATE_TABLE
372: , p1_a31 in out nocopy JTF_DATE_TABLE
373: , p1_a32 in out nocopy JTF_VARCHAR2_TABLE_100

Line 373: , p1_a32 in out nocopy JTF_VARCHAR2_TABLE_100

369: , p1_a28 in out nocopy JTF_VARCHAR2_TABLE_100
370: , p1_a29 in out nocopy JTF_NUMBER_TABLE
371: , p1_a30 in out nocopy JTF_DATE_TABLE
372: , p1_a31 in out nocopy JTF_DATE_TABLE
373: , p1_a32 in out nocopy JTF_VARCHAR2_TABLE_100
374: , p1_a33 in out nocopy JTF_VARCHAR2_TABLE_100
375: , p1_a34 in out nocopy JTF_VARCHAR2_TABLE_100
376: , p1_a35 in out nocopy JTF_VARCHAR2_TABLE_100
377: , p1_a36 in out nocopy JTF_VARCHAR2_TABLE_100

Line 374: , p1_a33 in out nocopy JTF_VARCHAR2_TABLE_100

370: , p1_a29 in out nocopy JTF_NUMBER_TABLE
371: , p1_a30 in out nocopy JTF_DATE_TABLE
372: , p1_a31 in out nocopy JTF_DATE_TABLE
373: , p1_a32 in out nocopy JTF_VARCHAR2_TABLE_100
374: , p1_a33 in out nocopy JTF_VARCHAR2_TABLE_100
375: , p1_a34 in out nocopy JTF_VARCHAR2_TABLE_100
376: , p1_a35 in out nocopy JTF_VARCHAR2_TABLE_100
377: , p1_a36 in out nocopy JTF_VARCHAR2_TABLE_100
378: , p1_a37 in out nocopy JTF_VARCHAR2_TABLE_100

Line 375: , p1_a34 in out nocopy JTF_VARCHAR2_TABLE_100

371: , p1_a30 in out nocopy JTF_DATE_TABLE
372: , p1_a31 in out nocopy JTF_DATE_TABLE
373: , p1_a32 in out nocopy JTF_VARCHAR2_TABLE_100
374: , p1_a33 in out nocopy JTF_VARCHAR2_TABLE_100
375: , p1_a34 in out nocopy JTF_VARCHAR2_TABLE_100
376: , p1_a35 in out nocopy JTF_VARCHAR2_TABLE_100
377: , p1_a36 in out nocopy JTF_VARCHAR2_TABLE_100
378: , p1_a37 in out nocopy JTF_VARCHAR2_TABLE_100
379: , p1_a38 in out nocopy JTF_VARCHAR2_TABLE_100

Line 376: , p1_a35 in out nocopy JTF_VARCHAR2_TABLE_100

372: , p1_a31 in out nocopy JTF_DATE_TABLE
373: , p1_a32 in out nocopy JTF_VARCHAR2_TABLE_100
374: , p1_a33 in out nocopy JTF_VARCHAR2_TABLE_100
375: , p1_a34 in out nocopy JTF_VARCHAR2_TABLE_100
376: , p1_a35 in out nocopy JTF_VARCHAR2_TABLE_100
377: , p1_a36 in out nocopy JTF_VARCHAR2_TABLE_100
378: , p1_a37 in out nocopy JTF_VARCHAR2_TABLE_100
379: , p1_a38 in out nocopy JTF_VARCHAR2_TABLE_100
380: , p1_a39 in out nocopy JTF_NUMBER_TABLE

Line 377: , p1_a36 in out nocopy JTF_VARCHAR2_TABLE_100

373: , p1_a32 in out nocopy JTF_VARCHAR2_TABLE_100
374: , p1_a33 in out nocopy JTF_VARCHAR2_TABLE_100
375: , p1_a34 in out nocopy JTF_VARCHAR2_TABLE_100
376: , p1_a35 in out nocopy JTF_VARCHAR2_TABLE_100
377: , p1_a36 in out nocopy JTF_VARCHAR2_TABLE_100
378: , p1_a37 in out nocopy JTF_VARCHAR2_TABLE_100
379: , p1_a38 in out nocopy JTF_VARCHAR2_TABLE_100
380: , p1_a39 in out nocopy JTF_NUMBER_TABLE
381: , p1_a40 in out nocopy JTF_NUMBER_TABLE

Line 378: , p1_a37 in out nocopy JTF_VARCHAR2_TABLE_100

374: , p1_a33 in out nocopy JTF_VARCHAR2_TABLE_100
375: , p1_a34 in out nocopy JTF_VARCHAR2_TABLE_100
376: , p1_a35 in out nocopy JTF_VARCHAR2_TABLE_100
377: , p1_a36 in out nocopy JTF_VARCHAR2_TABLE_100
378: , p1_a37 in out nocopy JTF_VARCHAR2_TABLE_100
379: , p1_a38 in out nocopy JTF_VARCHAR2_TABLE_100
380: , p1_a39 in out nocopy JTF_NUMBER_TABLE
381: , p1_a40 in out nocopy JTF_NUMBER_TABLE
382: , p1_a41 in out nocopy JTF_VARCHAR2_TABLE_4000

Line 379: , p1_a38 in out nocopy JTF_VARCHAR2_TABLE_100

375: , p1_a34 in out nocopy JTF_VARCHAR2_TABLE_100
376: , p1_a35 in out nocopy JTF_VARCHAR2_TABLE_100
377: , p1_a36 in out nocopy JTF_VARCHAR2_TABLE_100
378: , p1_a37 in out nocopy JTF_VARCHAR2_TABLE_100
379: , p1_a38 in out nocopy JTF_VARCHAR2_TABLE_100
380: , p1_a39 in out nocopy JTF_NUMBER_TABLE
381: , p1_a40 in out nocopy JTF_NUMBER_TABLE
382: , p1_a41 in out nocopy JTF_VARCHAR2_TABLE_4000
383: , p1_a42 in out nocopy JTF_NUMBER_TABLE

Line 384: , p1_a43 in out nocopy JTF_VARCHAR2_TABLE_100

380: , p1_a39 in out nocopy JTF_NUMBER_TABLE
381: , p1_a40 in out nocopy JTF_NUMBER_TABLE
382: , p1_a41 in out nocopy JTF_VARCHAR2_TABLE_4000
383: , p1_a42 in out nocopy JTF_NUMBER_TABLE
384: , p1_a43 in out nocopy JTF_VARCHAR2_TABLE_100
385: , p1_a44 in out nocopy JTF_VARCHAR2_TABLE_100
386: );
387: procedure update_data(p0_a0 in out nocopy JTF_NUMBER_TABLE
388: , p0_a1 in out nocopy JTF_NUMBER_TABLE

Line 385: , p1_a44 in out nocopy JTF_VARCHAR2_TABLE_100

381: , p1_a40 in out nocopy JTF_NUMBER_TABLE
382: , p1_a41 in out nocopy JTF_VARCHAR2_TABLE_4000
383: , p1_a42 in out nocopy JTF_NUMBER_TABLE
384: , p1_a43 in out nocopy JTF_VARCHAR2_TABLE_100
385: , p1_a44 in out nocopy JTF_VARCHAR2_TABLE_100
386: );
387: procedure update_data(p0_a0 in out nocopy JTF_NUMBER_TABLE
388: , p0_a1 in out nocopy JTF_NUMBER_TABLE
389: , p0_a2 in out nocopy JTF_NUMBER_TABLE

Line 392: , p0_a5 in out nocopy JTF_VARCHAR2_TABLE_100

388: , p0_a1 in out nocopy JTF_NUMBER_TABLE
389: , p0_a2 in out nocopy JTF_NUMBER_TABLE
390: , p0_a3 in out nocopy JTF_DATE_TABLE
391: , p0_a4 in out nocopy JTF_NUMBER_TABLE
392: , p0_a5 in out nocopy JTF_VARCHAR2_TABLE_100
393: , p0_a6 in out nocopy JTF_VARCHAR2_TABLE_100
394: , p0_a7 in out nocopy JTF_VARCHAR2_TABLE_2000
395: , p0_a8 in out nocopy JTF_VARCHAR2_TABLE_4000
396: , p0_a9 in out nocopy JTF_VARCHAR2_TABLE_100

Line 393: , p0_a6 in out nocopy JTF_VARCHAR2_TABLE_100

389: , p0_a2 in out nocopy JTF_NUMBER_TABLE
390: , p0_a3 in out nocopy JTF_DATE_TABLE
391: , p0_a4 in out nocopy JTF_NUMBER_TABLE
392: , p0_a5 in out nocopy JTF_VARCHAR2_TABLE_100
393: , p0_a6 in out nocopy JTF_VARCHAR2_TABLE_100
394: , p0_a7 in out nocopy JTF_VARCHAR2_TABLE_2000
395: , p0_a8 in out nocopy JTF_VARCHAR2_TABLE_4000
396: , p0_a9 in out nocopy JTF_VARCHAR2_TABLE_100
397: , p0_a10 in out nocopy JTF_DATE_TABLE

Line 396: , p0_a9 in out nocopy JTF_VARCHAR2_TABLE_100

392: , p0_a5 in out nocopy JTF_VARCHAR2_TABLE_100
393: , p0_a6 in out nocopy JTF_VARCHAR2_TABLE_100
394: , p0_a7 in out nocopy JTF_VARCHAR2_TABLE_2000
395: , p0_a8 in out nocopy JTF_VARCHAR2_TABLE_4000
396: , p0_a9 in out nocopy JTF_VARCHAR2_TABLE_100
397: , p0_a10 in out nocopy JTF_DATE_TABLE
398: , p0_a11 in out nocopy JTF_DATE_TABLE
399: , p0_a12 in out nocopy JTF_DATE_TABLE
400: , p0_a13 in out nocopy JTF_DATE_TABLE

Line 405: , p0_a18 in out nocopy JTF_VARCHAR2_TABLE_100

401: , p0_a14 in out nocopy JTF_DATE_TABLE
402: , p0_a15 in out nocopy JTF_DATE_TABLE
403: , p0_a16 in out nocopy JTF_NUMBER_TABLE
404: , p0_a17 in out nocopy JTF_NUMBER_TABLE
405: , p0_a18 in out nocopy JTF_VARCHAR2_TABLE_100
406: , p0_a19 in out nocopy JTF_DATE_TABLE
407: , p0_a20 in out nocopy JTF_VARCHAR2_TABLE_100
408: , p0_a21 in out nocopy JTF_VARCHAR2_TABLE_300
409: , p0_a22 in out nocopy JTF_NUMBER_TABLE

Line 407: , p0_a20 in out nocopy JTF_VARCHAR2_TABLE_100

403: , p0_a16 in out nocopy JTF_NUMBER_TABLE
404: , p0_a17 in out nocopy JTF_NUMBER_TABLE
405: , p0_a18 in out nocopy JTF_VARCHAR2_TABLE_100
406: , p0_a19 in out nocopy JTF_DATE_TABLE
407: , p0_a20 in out nocopy JTF_VARCHAR2_TABLE_100
408: , p0_a21 in out nocopy JTF_VARCHAR2_TABLE_300
409: , p0_a22 in out nocopy JTF_NUMBER_TABLE
410: , p0_a23 in out nocopy JTF_VARCHAR2_TABLE_2000
411: , p0_a24 in out nocopy JTF_NUMBER_TABLE

Line 415: , p0_a28 in out nocopy JTF_VARCHAR2_TABLE_100

411: , p0_a24 in out nocopy JTF_NUMBER_TABLE
412: , p0_a25 in out nocopy JTF_NUMBER_TABLE
413: , p0_a26 in out nocopy JTF_VARCHAR2_TABLE_300
414: , p0_a27 in out nocopy JTF_VARCHAR2_TABLE_2000
415: , p0_a28 in out nocopy JTF_VARCHAR2_TABLE_100
416: , p0_a29 in out nocopy JTF_NUMBER_TABLE
417: , p0_a30 in out nocopy JTF_DATE_TABLE
418: , p0_a31 in out nocopy JTF_DATE_TABLE
419: , p0_a32 in out nocopy JTF_VARCHAR2_TABLE_100

Line 419: , p0_a32 in out nocopy JTF_VARCHAR2_TABLE_100

415: , p0_a28 in out nocopy JTF_VARCHAR2_TABLE_100
416: , p0_a29 in out nocopy JTF_NUMBER_TABLE
417: , p0_a30 in out nocopy JTF_DATE_TABLE
418: , p0_a31 in out nocopy JTF_DATE_TABLE
419: , p0_a32 in out nocopy JTF_VARCHAR2_TABLE_100
420: , p0_a33 in out nocopy JTF_VARCHAR2_TABLE_100
421: , p0_a34 in out nocopy JTF_VARCHAR2_TABLE_100
422: , p0_a35 in out nocopy JTF_VARCHAR2_TABLE_100
423: , p0_a36 in out nocopy JTF_VARCHAR2_TABLE_100

Line 420: , p0_a33 in out nocopy JTF_VARCHAR2_TABLE_100

416: , p0_a29 in out nocopy JTF_NUMBER_TABLE
417: , p0_a30 in out nocopy JTF_DATE_TABLE
418: , p0_a31 in out nocopy JTF_DATE_TABLE
419: , p0_a32 in out nocopy JTF_VARCHAR2_TABLE_100
420: , p0_a33 in out nocopy JTF_VARCHAR2_TABLE_100
421: , p0_a34 in out nocopy JTF_VARCHAR2_TABLE_100
422: , p0_a35 in out nocopy JTF_VARCHAR2_TABLE_100
423: , p0_a36 in out nocopy JTF_VARCHAR2_TABLE_100
424: , p0_a37 in out nocopy JTF_VARCHAR2_TABLE_100

Line 421: , p0_a34 in out nocopy JTF_VARCHAR2_TABLE_100

417: , p0_a30 in out nocopy JTF_DATE_TABLE
418: , p0_a31 in out nocopy JTF_DATE_TABLE
419: , p0_a32 in out nocopy JTF_VARCHAR2_TABLE_100
420: , p0_a33 in out nocopy JTF_VARCHAR2_TABLE_100
421: , p0_a34 in out nocopy JTF_VARCHAR2_TABLE_100
422: , p0_a35 in out nocopy JTF_VARCHAR2_TABLE_100
423: , p0_a36 in out nocopy JTF_VARCHAR2_TABLE_100
424: , p0_a37 in out nocopy JTF_VARCHAR2_TABLE_100
425: , p0_a38 in out nocopy JTF_VARCHAR2_TABLE_100

Line 422: , p0_a35 in out nocopy JTF_VARCHAR2_TABLE_100

418: , p0_a31 in out nocopy JTF_DATE_TABLE
419: , p0_a32 in out nocopy JTF_VARCHAR2_TABLE_100
420: , p0_a33 in out nocopy JTF_VARCHAR2_TABLE_100
421: , p0_a34 in out nocopy JTF_VARCHAR2_TABLE_100
422: , p0_a35 in out nocopy JTF_VARCHAR2_TABLE_100
423: , p0_a36 in out nocopy JTF_VARCHAR2_TABLE_100
424: , p0_a37 in out nocopy JTF_VARCHAR2_TABLE_100
425: , p0_a38 in out nocopy JTF_VARCHAR2_TABLE_100
426: , p0_a39 in out nocopy JTF_NUMBER_TABLE

Line 423: , p0_a36 in out nocopy JTF_VARCHAR2_TABLE_100

419: , p0_a32 in out nocopy JTF_VARCHAR2_TABLE_100
420: , p0_a33 in out nocopy JTF_VARCHAR2_TABLE_100
421: , p0_a34 in out nocopy JTF_VARCHAR2_TABLE_100
422: , p0_a35 in out nocopy JTF_VARCHAR2_TABLE_100
423: , p0_a36 in out nocopy JTF_VARCHAR2_TABLE_100
424: , p0_a37 in out nocopy JTF_VARCHAR2_TABLE_100
425: , p0_a38 in out nocopy JTF_VARCHAR2_TABLE_100
426: , p0_a39 in out nocopy JTF_NUMBER_TABLE
427: , p0_a40 in out nocopy JTF_NUMBER_TABLE

Line 424: , p0_a37 in out nocopy JTF_VARCHAR2_TABLE_100

420: , p0_a33 in out nocopy JTF_VARCHAR2_TABLE_100
421: , p0_a34 in out nocopy JTF_VARCHAR2_TABLE_100
422: , p0_a35 in out nocopy JTF_VARCHAR2_TABLE_100
423: , p0_a36 in out nocopy JTF_VARCHAR2_TABLE_100
424: , p0_a37 in out nocopy JTF_VARCHAR2_TABLE_100
425: , p0_a38 in out nocopy JTF_VARCHAR2_TABLE_100
426: , p0_a39 in out nocopy JTF_NUMBER_TABLE
427: , p0_a40 in out nocopy JTF_NUMBER_TABLE
428: , p0_a41 in out nocopy JTF_VARCHAR2_TABLE_4000

Line 425: , p0_a38 in out nocopy JTF_VARCHAR2_TABLE_100

421: , p0_a34 in out nocopy JTF_VARCHAR2_TABLE_100
422: , p0_a35 in out nocopy JTF_VARCHAR2_TABLE_100
423: , p0_a36 in out nocopy JTF_VARCHAR2_TABLE_100
424: , p0_a37 in out nocopy JTF_VARCHAR2_TABLE_100
425: , p0_a38 in out nocopy JTF_VARCHAR2_TABLE_100
426: , p0_a39 in out nocopy JTF_NUMBER_TABLE
427: , p0_a40 in out nocopy JTF_NUMBER_TABLE
428: , p0_a41 in out nocopy JTF_VARCHAR2_TABLE_4000
429: , p0_a42 in out nocopy JTF_NUMBER_TABLE

Line 430: , p0_a43 in out nocopy JTF_VARCHAR2_TABLE_100

426: , p0_a39 in out nocopy JTF_NUMBER_TABLE
427: , p0_a40 in out nocopy JTF_NUMBER_TABLE
428: , p0_a41 in out nocopy JTF_VARCHAR2_TABLE_4000
429: , p0_a42 in out nocopy JTF_NUMBER_TABLE
430: , p0_a43 in out nocopy JTF_VARCHAR2_TABLE_100
431: , p0_a44 in out nocopy JTF_VARCHAR2_TABLE_100
432: , p1_a0 in out nocopy JTF_NUMBER_TABLE
433: , p1_a1 in out nocopy JTF_DATE_TABLE
434: , p1_a2 in out nocopy JTF_NUMBER_TABLE

Line 431: , p0_a44 in out nocopy JTF_VARCHAR2_TABLE_100

427: , p0_a40 in out nocopy JTF_NUMBER_TABLE
428: , p0_a41 in out nocopy JTF_VARCHAR2_TABLE_4000
429: , p0_a42 in out nocopy JTF_NUMBER_TABLE
430: , p0_a43 in out nocopy JTF_VARCHAR2_TABLE_100
431: , p0_a44 in out nocopy JTF_VARCHAR2_TABLE_100
432: , p1_a0 in out nocopy JTF_NUMBER_TABLE
433: , p1_a1 in out nocopy JTF_DATE_TABLE
434: , p1_a2 in out nocopy JTF_NUMBER_TABLE
435: , p1_a3 in out nocopy JTF_NUMBER_TABLE

Line 438: , p1_a6 in out nocopy JTF_VARCHAR2_TABLE_100

434: , p1_a2 in out nocopy JTF_NUMBER_TABLE
435: , p1_a3 in out nocopy JTF_NUMBER_TABLE
436: , p1_a4 in out nocopy JTF_DATE_TABLE
437: , p1_a5 in out nocopy JTF_NUMBER_TABLE
438: , p1_a6 in out nocopy JTF_VARCHAR2_TABLE_100
439: , p1_a7 in out nocopy JTF_VARCHAR2_TABLE_100
440: , p1_a8 in out nocopy JTF_VARCHAR2_TABLE_2000
441: , p1_a9 in out nocopy JTF_VARCHAR2_TABLE_4000
442: , p1_a10 in out nocopy JTF_VARCHAR2_TABLE_100

Line 439: , p1_a7 in out nocopy JTF_VARCHAR2_TABLE_100

435: , p1_a3 in out nocopy JTF_NUMBER_TABLE
436: , p1_a4 in out nocopy JTF_DATE_TABLE
437: , p1_a5 in out nocopy JTF_NUMBER_TABLE
438: , p1_a6 in out nocopy JTF_VARCHAR2_TABLE_100
439: , p1_a7 in out nocopy JTF_VARCHAR2_TABLE_100
440: , p1_a8 in out nocopy JTF_VARCHAR2_TABLE_2000
441: , p1_a9 in out nocopy JTF_VARCHAR2_TABLE_4000
442: , p1_a10 in out nocopy JTF_VARCHAR2_TABLE_100
443: , p1_a11 in out nocopy JTF_DATE_TABLE

Line 442: , p1_a10 in out nocopy JTF_VARCHAR2_TABLE_100

438: , p1_a6 in out nocopy JTF_VARCHAR2_TABLE_100
439: , p1_a7 in out nocopy JTF_VARCHAR2_TABLE_100
440: , p1_a8 in out nocopy JTF_VARCHAR2_TABLE_2000
441: , p1_a9 in out nocopy JTF_VARCHAR2_TABLE_4000
442: , p1_a10 in out nocopy JTF_VARCHAR2_TABLE_100
443: , p1_a11 in out nocopy JTF_DATE_TABLE
444: , p1_a12 in out nocopy JTF_DATE_TABLE
445: , p1_a13 in out nocopy JTF_DATE_TABLE
446: , p1_a14 in out nocopy JTF_DATE_TABLE

Line 451: , p1_a19 in out nocopy JTF_VARCHAR2_TABLE_100

447: , p1_a15 in out nocopy JTF_DATE_TABLE
448: , p1_a16 in out nocopy JTF_DATE_TABLE
449: , p1_a17 in out nocopy JTF_NUMBER_TABLE
450: , p1_a18 in out nocopy JTF_NUMBER_TABLE
451: , p1_a19 in out nocopy JTF_VARCHAR2_TABLE_100
452: , p1_a20 in out nocopy JTF_DATE_TABLE
453: , p1_a21 in out nocopy JTF_VARCHAR2_TABLE_100
454: , p1_a22 in out nocopy JTF_VARCHAR2_TABLE_300
455: , p1_a23 in out nocopy JTF_NUMBER_TABLE

Line 453: , p1_a21 in out nocopy JTF_VARCHAR2_TABLE_100

449: , p1_a17 in out nocopy JTF_NUMBER_TABLE
450: , p1_a18 in out nocopy JTF_NUMBER_TABLE
451: , p1_a19 in out nocopy JTF_VARCHAR2_TABLE_100
452: , p1_a20 in out nocopy JTF_DATE_TABLE
453: , p1_a21 in out nocopy JTF_VARCHAR2_TABLE_100
454: , p1_a22 in out nocopy JTF_VARCHAR2_TABLE_300
455: , p1_a23 in out nocopy JTF_NUMBER_TABLE
456: , p1_a24 in out nocopy JTF_VARCHAR2_TABLE_2000
457: , p1_a25 in out nocopy JTF_NUMBER_TABLE

Line 461: , p1_a29 in out nocopy JTF_VARCHAR2_TABLE_100

457: , p1_a25 in out nocopy JTF_NUMBER_TABLE
458: , p1_a26 in out nocopy JTF_NUMBER_TABLE
459: , p1_a27 in out nocopy JTF_VARCHAR2_TABLE_300
460: , p1_a28 in out nocopy JTF_VARCHAR2_TABLE_2000
461: , p1_a29 in out nocopy JTF_VARCHAR2_TABLE_100
462: , p1_a30 in out nocopy JTF_NUMBER_TABLE
463: , p1_a31 in out nocopy JTF_DATE_TABLE
464: , p1_a32 in out nocopy JTF_DATE_TABLE
465: , p1_a33 in out nocopy JTF_VARCHAR2_TABLE_100

Line 465: , p1_a33 in out nocopy JTF_VARCHAR2_TABLE_100

461: , p1_a29 in out nocopy JTF_VARCHAR2_TABLE_100
462: , p1_a30 in out nocopy JTF_NUMBER_TABLE
463: , p1_a31 in out nocopy JTF_DATE_TABLE
464: , p1_a32 in out nocopy JTF_DATE_TABLE
465: , p1_a33 in out nocopy JTF_VARCHAR2_TABLE_100
466: , p1_a34 in out nocopy JTF_VARCHAR2_TABLE_100
467: , p1_a35 in out nocopy JTF_VARCHAR2_TABLE_100
468: , p1_a36 in out nocopy JTF_VARCHAR2_TABLE_100
469: , p1_a37 in out nocopy JTF_VARCHAR2_TABLE_100

Line 466: , p1_a34 in out nocopy JTF_VARCHAR2_TABLE_100

462: , p1_a30 in out nocopy JTF_NUMBER_TABLE
463: , p1_a31 in out nocopy JTF_DATE_TABLE
464: , p1_a32 in out nocopy JTF_DATE_TABLE
465: , p1_a33 in out nocopy JTF_VARCHAR2_TABLE_100
466: , p1_a34 in out nocopy JTF_VARCHAR2_TABLE_100
467: , p1_a35 in out nocopy JTF_VARCHAR2_TABLE_100
468: , p1_a36 in out nocopy JTF_VARCHAR2_TABLE_100
469: , p1_a37 in out nocopy JTF_VARCHAR2_TABLE_100
470: , p1_a38 in out nocopy JTF_VARCHAR2_TABLE_100

Line 467: , p1_a35 in out nocopy JTF_VARCHAR2_TABLE_100

463: , p1_a31 in out nocopy JTF_DATE_TABLE
464: , p1_a32 in out nocopy JTF_DATE_TABLE
465: , p1_a33 in out nocopy JTF_VARCHAR2_TABLE_100
466: , p1_a34 in out nocopy JTF_VARCHAR2_TABLE_100
467: , p1_a35 in out nocopy JTF_VARCHAR2_TABLE_100
468: , p1_a36 in out nocopy JTF_VARCHAR2_TABLE_100
469: , p1_a37 in out nocopy JTF_VARCHAR2_TABLE_100
470: , p1_a38 in out nocopy JTF_VARCHAR2_TABLE_100
471: , p1_a39 in out nocopy JTF_VARCHAR2_TABLE_100

Line 468: , p1_a36 in out nocopy JTF_VARCHAR2_TABLE_100

464: , p1_a32 in out nocopy JTF_DATE_TABLE
465: , p1_a33 in out nocopy JTF_VARCHAR2_TABLE_100
466: , p1_a34 in out nocopy JTF_VARCHAR2_TABLE_100
467: , p1_a35 in out nocopy JTF_VARCHAR2_TABLE_100
468: , p1_a36 in out nocopy JTF_VARCHAR2_TABLE_100
469: , p1_a37 in out nocopy JTF_VARCHAR2_TABLE_100
470: , p1_a38 in out nocopy JTF_VARCHAR2_TABLE_100
471: , p1_a39 in out nocopy JTF_VARCHAR2_TABLE_100
472: , p1_a40 in out nocopy JTF_NUMBER_TABLE

Line 469: , p1_a37 in out nocopy JTF_VARCHAR2_TABLE_100

465: , p1_a33 in out nocopy JTF_VARCHAR2_TABLE_100
466: , p1_a34 in out nocopy JTF_VARCHAR2_TABLE_100
467: , p1_a35 in out nocopy JTF_VARCHAR2_TABLE_100
468: , p1_a36 in out nocopy JTF_VARCHAR2_TABLE_100
469: , p1_a37 in out nocopy JTF_VARCHAR2_TABLE_100
470: , p1_a38 in out nocopy JTF_VARCHAR2_TABLE_100
471: , p1_a39 in out nocopy JTF_VARCHAR2_TABLE_100
472: , p1_a40 in out nocopy JTF_NUMBER_TABLE
473: , p1_a41 in out nocopy JTF_NUMBER_TABLE

Line 470: , p1_a38 in out nocopy JTF_VARCHAR2_TABLE_100

466: , p1_a34 in out nocopy JTF_VARCHAR2_TABLE_100
467: , p1_a35 in out nocopy JTF_VARCHAR2_TABLE_100
468: , p1_a36 in out nocopy JTF_VARCHAR2_TABLE_100
469: , p1_a37 in out nocopy JTF_VARCHAR2_TABLE_100
470: , p1_a38 in out nocopy JTF_VARCHAR2_TABLE_100
471: , p1_a39 in out nocopy JTF_VARCHAR2_TABLE_100
472: , p1_a40 in out nocopy JTF_NUMBER_TABLE
473: , p1_a41 in out nocopy JTF_NUMBER_TABLE
474: , p1_a42 in out nocopy JTF_VARCHAR2_TABLE_4000

Line 471: , p1_a39 in out nocopy JTF_VARCHAR2_TABLE_100

467: , p1_a35 in out nocopy JTF_VARCHAR2_TABLE_100
468: , p1_a36 in out nocopy JTF_VARCHAR2_TABLE_100
469: , p1_a37 in out nocopy JTF_VARCHAR2_TABLE_100
470: , p1_a38 in out nocopy JTF_VARCHAR2_TABLE_100
471: , p1_a39 in out nocopy JTF_VARCHAR2_TABLE_100
472: , p1_a40 in out nocopy JTF_NUMBER_TABLE
473: , p1_a41 in out nocopy JTF_NUMBER_TABLE
474: , p1_a42 in out nocopy JTF_VARCHAR2_TABLE_4000
475: , p1_a43 in out nocopy JTF_NUMBER_TABLE

Line 476: , p1_a44 in out nocopy JTF_VARCHAR2_TABLE_100

472: , p1_a40 in out nocopy JTF_NUMBER_TABLE
473: , p1_a41 in out nocopy JTF_NUMBER_TABLE
474: , p1_a42 in out nocopy JTF_VARCHAR2_TABLE_4000
475: , p1_a43 in out nocopy JTF_NUMBER_TABLE
476: , p1_a44 in out nocopy JTF_VARCHAR2_TABLE_100
477: , p1_a45 in out nocopy JTF_VARCHAR2_TABLE_100
478: );
479: procedure delete_data(p0_a0 in out nocopy JTF_NUMBER_TABLE
480: , p0_a1 in out nocopy JTF_NUMBER_TABLE

Line 477: , p1_a45 in out nocopy JTF_VARCHAR2_TABLE_100

473: , p1_a41 in out nocopy JTF_NUMBER_TABLE
474: , p1_a42 in out nocopy JTF_VARCHAR2_TABLE_4000
475: , p1_a43 in out nocopy JTF_NUMBER_TABLE
476: , p1_a44 in out nocopy JTF_VARCHAR2_TABLE_100
477: , p1_a45 in out nocopy JTF_VARCHAR2_TABLE_100
478: );
479: procedure delete_data(p0_a0 in out nocopy JTF_NUMBER_TABLE
480: , p0_a1 in out nocopy JTF_NUMBER_TABLE
481: , p0_a2 in out nocopy JTF_NUMBER_TABLE

Line 484: , p0_a5 in out nocopy JTF_VARCHAR2_TABLE_100

480: , p0_a1 in out nocopy JTF_NUMBER_TABLE
481: , p0_a2 in out nocopy JTF_NUMBER_TABLE
482: , p0_a3 in out nocopy JTF_DATE_TABLE
483: , p0_a4 in out nocopy JTF_NUMBER_TABLE
484: , p0_a5 in out nocopy JTF_VARCHAR2_TABLE_100
485: , p0_a6 in out nocopy JTF_VARCHAR2_TABLE_100
486: , p0_a7 in out nocopy JTF_VARCHAR2_TABLE_2000
487: , p0_a8 in out nocopy JTF_VARCHAR2_TABLE_4000
488: , p0_a9 in out nocopy JTF_VARCHAR2_TABLE_100

Line 485: , p0_a6 in out nocopy JTF_VARCHAR2_TABLE_100

481: , p0_a2 in out nocopy JTF_NUMBER_TABLE
482: , p0_a3 in out nocopy JTF_DATE_TABLE
483: , p0_a4 in out nocopy JTF_NUMBER_TABLE
484: , p0_a5 in out nocopy JTF_VARCHAR2_TABLE_100
485: , p0_a6 in out nocopy JTF_VARCHAR2_TABLE_100
486: , p0_a7 in out nocopy JTF_VARCHAR2_TABLE_2000
487: , p0_a8 in out nocopy JTF_VARCHAR2_TABLE_4000
488: , p0_a9 in out nocopy JTF_VARCHAR2_TABLE_100
489: , p0_a10 in out nocopy JTF_DATE_TABLE

Line 488: , p0_a9 in out nocopy JTF_VARCHAR2_TABLE_100

484: , p0_a5 in out nocopy JTF_VARCHAR2_TABLE_100
485: , p0_a6 in out nocopy JTF_VARCHAR2_TABLE_100
486: , p0_a7 in out nocopy JTF_VARCHAR2_TABLE_2000
487: , p0_a8 in out nocopy JTF_VARCHAR2_TABLE_4000
488: , p0_a9 in out nocopy JTF_VARCHAR2_TABLE_100
489: , p0_a10 in out nocopy JTF_DATE_TABLE
490: , p0_a11 in out nocopy JTF_DATE_TABLE
491: , p0_a12 in out nocopy JTF_DATE_TABLE
492: , p0_a13 in out nocopy JTF_DATE_TABLE

Line 497: , p0_a18 in out nocopy JTF_VARCHAR2_TABLE_100

493: , p0_a14 in out nocopy JTF_DATE_TABLE
494: , p0_a15 in out nocopy JTF_DATE_TABLE
495: , p0_a16 in out nocopy JTF_NUMBER_TABLE
496: , p0_a17 in out nocopy JTF_NUMBER_TABLE
497: , p0_a18 in out nocopy JTF_VARCHAR2_TABLE_100
498: , p0_a19 in out nocopy JTF_DATE_TABLE
499: , p0_a20 in out nocopy JTF_VARCHAR2_TABLE_100
500: , p0_a21 in out nocopy JTF_VARCHAR2_TABLE_300
501: , p0_a22 in out nocopy JTF_NUMBER_TABLE

Line 499: , p0_a20 in out nocopy JTF_VARCHAR2_TABLE_100

495: , p0_a16 in out nocopy JTF_NUMBER_TABLE
496: , p0_a17 in out nocopy JTF_NUMBER_TABLE
497: , p0_a18 in out nocopy JTF_VARCHAR2_TABLE_100
498: , p0_a19 in out nocopy JTF_DATE_TABLE
499: , p0_a20 in out nocopy JTF_VARCHAR2_TABLE_100
500: , p0_a21 in out nocopy JTF_VARCHAR2_TABLE_300
501: , p0_a22 in out nocopy JTF_NUMBER_TABLE
502: , p0_a23 in out nocopy JTF_VARCHAR2_TABLE_2000
503: , p0_a24 in out nocopy JTF_NUMBER_TABLE

Line 507: , p0_a28 in out nocopy JTF_VARCHAR2_TABLE_100

503: , p0_a24 in out nocopy JTF_NUMBER_TABLE
504: , p0_a25 in out nocopy JTF_NUMBER_TABLE
505: , p0_a26 in out nocopy JTF_VARCHAR2_TABLE_300
506: , p0_a27 in out nocopy JTF_VARCHAR2_TABLE_2000
507: , p0_a28 in out nocopy JTF_VARCHAR2_TABLE_100
508: , p0_a29 in out nocopy JTF_NUMBER_TABLE
509: , p0_a30 in out nocopy JTF_DATE_TABLE
510: , p0_a31 in out nocopy JTF_DATE_TABLE
511: , p0_a32 in out nocopy JTF_VARCHAR2_TABLE_100

Line 511: , p0_a32 in out nocopy JTF_VARCHAR2_TABLE_100

507: , p0_a28 in out nocopy JTF_VARCHAR2_TABLE_100
508: , p0_a29 in out nocopy JTF_NUMBER_TABLE
509: , p0_a30 in out nocopy JTF_DATE_TABLE
510: , p0_a31 in out nocopy JTF_DATE_TABLE
511: , p0_a32 in out nocopy JTF_VARCHAR2_TABLE_100
512: , p0_a33 in out nocopy JTF_VARCHAR2_TABLE_100
513: , p0_a34 in out nocopy JTF_VARCHAR2_TABLE_100
514: , p0_a35 in out nocopy JTF_VARCHAR2_TABLE_100
515: , p0_a36 in out nocopy JTF_VARCHAR2_TABLE_100

Line 512: , p0_a33 in out nocopy JTF_VARCHAR2_TABLE_100

508: , p0_a29 in out nocopy JTF_NUMBER_TABLE
509: , p0_a30 in out nocopy JTF_DATE_TABLE
510: , p0_a31 in out nocopy JTF_DATE_TABLE
511: , p0_a32 in out nocopy JTF_VARCHAR2_TABLE_100
512: , p0_a33 in out nocopy JTF_VARCHAR2_TABLE_100
513: , p0_a34 in out nocopy JTF_VARCHAR2_TABLE_100
514: , p0_a35 in out nocopy JTF_VARCHAR2_TABLE_100
515: , p0_a36 in out nocopy JTF_VARCHAR2_TABLE_100
516: , p0_a37 in out nocopy JTF_VARCHAR2_TABLE_100

Line 513: , p0_a34 in out nocopy JTF_VARCHAR2_TABLE_100

509: , p0_a30 in out nocopy JTF_DATE_TABLE
510: , p0_a31 in out nocopy JTF_DATE_TABLE
511: , p0_a32 in out nocopy JTF_VARCHAR2_TABLE_100
512: , p0_a33 in out nocopy JTF_VARCHAR2_TABLE_100
513: , p0_a34 in out nocopy JTF_VARCHAR2_TABLE_100
514: , p0_a35 in out nocopy JTF_VARCHAR2_TABLE_100
515: , p0_a36 in out nocopy JTF_VARCHAR2_TABLE_100
516: , p0_a37 in out nocopy JTF_VARCHAR2_TABLE_100
517: , p0_a38 in out nocopy JTF_VARCHAR2_TABLE_100

Line 514: , p0_a35 in out nocopy JTF_VARCHAR2_TABLE_100

510: , p0_a31 in out nocopy JTF_DATE_TABLE
511: , p0_a32 in out nocopy JTF_VARCHAR2_TABLE_100
512: , p0_a33 in out nocopy JTF_VARCHAR2_TABLE_100
513: , p0_a34 in out nocopy JTF_VARCHAR2_TABLE_100
514: , p0_a35 in out nocopy JTF_VARCHAR2_TABLE_100
515: , p0_a36 in out nocopy JTF_VARCHAR2_TABLE_100
516: , p0_a37 in out nocopy JTF_VARCHAR2_TABLE_100
517: , p0_a38 in out nocopy JTF_VARCHAR2_TABLE_100
518: , p0_a39 in out nocopy JTF_NUMBER_TABLE

Line 515: , p0_a36 in out nocopy JTF_VARCHAR2_TABLE_100

511: , p0_a32 in out nocopy JTF_VARCHAR2_TABLE_100
512: , p0_a33 in out nocopy JTF_VARCHAR2_TABLE_100
513: , p0_a34 in out nocopy JTF_VARCHAR2_TABLE_100
514: , p0_a35 in out nocopy JTF_VARCHAR2_TABLE_100
515: , p0_a36 in out nocopy JTF_VARCHAR2_TABLE_100
516: , p0_a37 in out nocopy JTF_VARCHAR2_TABLE_100
517: , p0_a38 in out nocopy JTF_VARCHAR2_TABLE_100
518: , p0_a39 in out nocopy JTF_NUMBER_TABLE
519: , p0_a40 in out nocopy JTF_NUMBER_TABLE

Line 516: , p0_a37 in out nocopy JTF_VARCHAR2_TABLE_100

512: , p0_a33 in out nocopy JTF_VARCHAR2_TABLE_100
513: , p0_a34 in out nocopy JTF_VARCHAR2_TABLE_100
514: , p0_a35 in out nocopy JTF_VARCHAR2_TABLE_100
515: , p0_a36 in out nocopy JTF_VARCHAR2_TABLE_100
516: , p0_a37 in out nocopy JTF_VARCHAR2_TABLE_100
517: , p0_a38 in out nocopy JTF_VARCHAR2_TABLE_100
518: , p0_a39 in out nocopy JTF_NUMBER_TABLE
519: , p0_a40 in out nocopy JTF_NUMBER_TABLE
520: , p0_a41 in out nocopy JTF_VARCHAR2_TABLE_4000

Line 517: , p0_a38 in out nocopy JTF_VARCHAR2_TABLE_100

513: , p0_a34 in out nocopy JTF_VARCHAR2_TABLE_100
514: , p0_a35 in out nocopy JTF_VARCHAR2_TABLE_100
515: , p0_a36 in out nocopy JTF_VARCHAR2_TABLE_100
516: , p0_a37 in out nocopy JTF_VARCHAR2_TABLE_100
517: , p0_a38 in out nocopy JTF_VARCHAR2_TABLE_100
518: , p0_a39 in out nocopy JTF_NUMBER_TABLE
519: , p0_a40 in out nocopy JTF_NUMBER_TABLE
520: , p0_a41 in out nocopy JTF_VARCHAR2_TABLE_4000
521: , p0_a42 in out nocopy JTF_NUMBER_TABLE

Line 522: , p0_a43 in out nocopy JTF_VARCHAR2_TABLE_100

518: , p0_a39 in out nocopy JTF_NUMBER_TABLE
519: , p0_a40 in out nocopy JTF_NUMBER_TABLE
520: , p0_a41 in out nocopy JTF_VARCHAR2_TABLE_4000
521: , p0_a42 in out nocopy JTF_NUMBER_TABLE
522: , p0_a43 in out nocopy JTF_VARCHAR2_TABLE_100
523: , p0_a44 in out nocopy JTF_VARCHAR2_TABLE_100
524: );
525: end cac_sync_task_w;

Line 523: , p0_a44 in out nocopy JTF_VARCHAR2_TABLE_100

519: , p0_a40 in out nocopy JTF_NUMBER_TABLE
520: , p0_a41 in out nocopy JTF_VARCHAR2_TABLE_4000
521: , p0_a42 in out nocopy JTF_NUMBER_TABLE
522: , p0_a43 in out nocopy JTF_VARCHAR2_TABLE_100
523: , p0_a44 in out nocopy JTF_VARCHAR2_TABLE_100
524: );
525: end cac_sync_task_w;