APPS.OKL_SPLIT_ASSET_COMP_PVT_W dependencies on JTF_VARCHAR2_TABLE_100

Line 10: , p5_a2 JTF_VARCHAR2_TABLE_100

6: , x_msg_count out nocopy NUMBER
7: , x_msg_data out nocopy VARCHAR2
8: , p5_a0 JTF_NUMBER_TABLE
9: , p5_a1 JTF_NUMBER_TABLE
10: , p5_a2 JTF_VARCHAR2_TABLE_100
11: , p5_a3 JTF_NUMBER_TABLE
12: , p5_a4 JTF_NUMBER_TABLE
13: , p5_a5 JTF_NUMBER_TABLE
14: , p5_a6 JTF_VARCHAR2_TABLE_100

Line 14: , p5_a6 JTF_VARCHAR2_TABLE_100

10: , p5_a2 JTF_VARCHAR2_TABLE_100
11: , p5_a3 JTF_NUMBER_TABLE
12: , p5_a4 JTF_NUMBER_TABLE
13: , p5_a5 JTF_NUMBER_TABLE
14: , p5_a6 JTF_VARCHAR2_TABLE_100
15: , p5_a7 JTF_VARCHAR2_TABLE_2000
16: , p5_a8 JTF_NUMBER_TABLE
17: , p5_a9 JTF_NUMBER_TABLE
18: , p5_a10 JTF_VARCHAR2_TABLE_100

Line 18: , p5_a10 JTF_VARCHAR2_TABLE_100

14: , p5_a6 JTF_VARCHAR2_TABLE_100
15: , p5_a7 JTF_VARCHAR2_TABLE_2000
16: , p5_a8 JTF_NUMBER_TABLE
17: , p5_a9 JTF_NUMBER_TABLE
18: , p5_a10 JTF_VARCHAR2_TABLE_100
19: , p5_a11 JTF_NUMBER_TABLE
20: , p5_a12 JTF_VARCHAR2_TABLE_100
21: , p5_a13 JTF_NUMBER_TABLE
22: , p5_a14 JTF_NUMBER_TABLE

Line 20: , p5_a12 JTF_VARCHAR2_TABLE_100

16: , p5_a8 JTF_NUMBER_TABLE
17: , p5_a9 JTF_NUMBER_TABLE
18: , p5_a10 JTF_VARCHAR2_TABLE_100
19: , p5_a11 JTF_NUMBER_TABLE
20: , p5_a12 JTF_VARCHAR2_TABLE_100
21: , p5_a13 JTF_NUMBER_TABLE
22: , p5_a14 JTF_NUMBER_TABLE
23: , p5_a15 JTF_NUMBER_TABLE
24: , p5_a16 JTF_NUMBER_TABLE

Line 25: , p5_a17 JTF_VARCHAR2_TABLE_100

21: , p5_a13 JTF_NUMBER_TABLE
22: , p5_a14 JTF_NUMBER_TABLE
23: , p5_a15 JTF_NUMBER_TABLE
24: , p5_a16 JTF_NUMBER_TABLE
25: , p5_a17 JTF_VARCHAR2_TABLE_100
26: , p5_a18 JTF_VARCHAR2_TABLE_500
27: , p5_a19 JTF_VARCHAR2_TABLE_500
28: , p5_a20 JTF_VARCHAR2_TABLE_500
29: , p5_a21 JTF_VARCHAR2_TABLE_500

Line 46: , p5_a38 JTF_VARCHAR2_TABLE_100

42: , p5_a34 JTF_DATE_TABLE
43: , p5_a35 JTF_NUMBER_TABLE
44: , p5_a36 JTF_DATE_TABLE
45: , p5_a37 JTF_NUMBER_TABLE
46: , p5_a38 JTF_VARCHAR2_TABLE_100
47: , p5_a39 JTF_VARCHAR2_TABLE_100
48: , p5_a40 JTF_NUMBER_TABLE
49: , p5_a41 JTF_DATE_TABLE
50: , p6_a0 out nocopy JTF_NUMBER_TABLE

Line 47: , p5_a39 JTF_VARCHAR2_TABLE_100

43: , p5_a35 JTF_NUMBER_TABLE
44: , p5_a36 JTF_DATE_TABLE
45: , p5_a37 JTF_NUMBER_TABLE
46: , p5_a38 JTF_VARCHAR2_TABLE_100
47: , p5_a39 JTF_VARCHAR2_TABLE_100
48: , p5_a40 JTF_NUMBER_TABLE
49: , p5_a41 JTF_DATE_TABLE
50: , p6_a0 out nocopy JTF_NUMBER_TABLE
51: , p6_a1 out nocopy JTF_NUMBER_TABLE

Line 52: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100

48: , p5_a40 JTF_NUMBER_TABLE
49: , p5_a41 JTF_DATE_TABLE
50: , p6_a0 out nocopy JTF_NUMBER_TABLE
51: , p6_a1 out nocopy JTF_NUMBER_TABLE
52: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
53: , p6_a3 out nocopy JTF_NUMBER_TABLE
54: , p6_a4 out nocopy JTF_NUMBER_TABLE
55: , p6_a5 out nocopy JTF_NUMBER_TABLE
56: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 56: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100

52: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
53: , p6_a3 out nocopy JTF_NUMBER_TABLE
54: , p6_a4 out nocopy JTF_NUMBER_TABLE
55: , p6_a5 out nocopy JTF_NUMBER_TABLE
56: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
57: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_2000
58: , p6_a8 out nocopy JTF_NUMBER_TABLE
59: , p6_a9 out nocopy JTF_NUMBER_TABLE
60: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100

Line 60: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100

56: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
57: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_2000
58: , p6_a8 out nocopy JTF_NUMBER_TABLE
59: , p6_a9 out nocopy JTF_NUMBER_TABLE
60: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
61: , p6_a11 out nocopy JTF_NUMBER_TABLE
62: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
63: , p6_a13 out nocopy JTF_NUMBER_TABLE
64: , p6_a14 out nocopy JTF_NUMBER_TABLE

Line 62: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100

58: , p6_a8 out nocopy JTF_NUMBER_TABLE
59: , p6_a9 out nocopy JTF_NUMBER_TABLE
60: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
61: , p6_a11 out nocopy JTF_NUMBER_TABLE
62: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
63: , p6_a13 out nocopy JTF_NUMBER_TABLE
64: , p6_a14 out nocopy JTF_NUMBER_TABLE
65: , p6_a15 out nocopy JTF_NUMBER_TABLE
66: , p6_a16 out nocopy JTF_NUMBER_TABLE

Line 67: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_100

63: , p6_a13 out nocopy JTF_NUMBER_TABLE
64: , p6_a14 out nocopy JTF_NUMBER_TABLE
65: , p6_a15 out nocopy JTF_NUMBER_TABLE
66: , p6_a16 out nocopy JTF_NUMBER_TABLE
67: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_100
68: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_500
69: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_500
70: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
71: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500

Line 88: , p6_a38 out nocopy JTF_VARCHAR2_TABLE_100

84: , p6_a34 out nocopy JTF_DATE_TABLE
85: , p6_a35 out nocopy JTF_NUMBER_TABLE
86: , p6_a36 out nocopy JTF_DATE_TABLE
87: , p6_a37 out nocopy JTF_NUMBER_TABLE
88: , p6_a38 out nocopy JTF_VARCHAR2_TABLE_100
89: , p6_a39 out nocopy JTF_VARCHAR2_TABLE_100
90: , p6_a40 out nocopy JTF_NUMBER_TABLE
91: , p6_a41 out nocopy JTF_DATE_TABLE
92: );

Line 89: , p6_a39 out nocopy JTF_VARCHAR2_TABLE_100

85: , p6_a35 out nocopy JTF_NUMBER_TABLE
86: , p6_a36 out nocopy JTF_DATE_TABLE
87: , p6_a37 out nocopy JTF_NUMBER_TABLE
88: , p6_a38 out nocopy JTF_VARCHAR2_TABLE_100
89: , p6_a39 out nocopy JTF_VARCHAR2_TABLE_100
90: , p6_a40 out nocopy JTF_NUMBER_TABLE
91: , p6_a41 out nocopy JTF_DATE_TABLE
92: );
93: procedure update_split_asset_comp(p_api_version NUMBER

Line 100: , p5_a2 JTF_VARCHAR2_TABLE_100

96: , x_msg_count out nocopy NUMBER
97: , x_msg_data out nocopy VARCHAR2
98: , p5_a0 JTF_NUMBER_TABLE
99: , p5_a1 JTF_NUMBER_TABLE
100: , p5_a2 JTF_VARCHAR2_TABLE_100
101: , p5_a3 JTF_NUMBER_TABLE
102: , p5_a4 JTF_NUMBER_TABLE
103: , p5_a5 JTF_NUMBER_TABLE
104: , p5_a6 JTF_VARCHAR2_TABLE_100

Line 104: , p5_a6 JTF_VARCHAR2_TABLE_100

100: , p5_a2 JTF_VARCHAR2_TABLE_100
101: , p5_a3 JTF_NUMBER_TABLE
102: , p5_a4 JTF_NUMBER_TABLE
103: , p5_a5 JTF_NUMBER_TABLE
104: , p5_a6 JTF_VARCHAR2_TABLE_100
105: , p5_a7 JTF_VARCHAR2_TABLE_2000
106: , p5_a8 JTF_NUMBER_TABLE
107: , p5_a9 JTF_NUMBER_TABLE
108: , p5_a10 JTF_VARCHAR2_TABLE_100

Line 108: , p5_a10 JTF_VARCHAR2_TABLE_100

104: , p5_a6 JTF_VARCHAR2_TABLE_100
105: , p5_a7 JTF_VARCHAR2_TABLE_2000
106: , p5_a8 JTF_NUMBER_TABLE
107: , p5_a9 JTF_NUMBER_TABLE
108: , p5_a10 JTF_VARCHAR2_TABLE_100
109: , p5_a11 JTF_NUMBER_TABLE
110: , p5_a12 JTF_VARCHAR2_TABLE_100
111: , p5_a13 JTF_NUMBER_TABLE
112: , p5_a14 JTF_NUMBER_TABLE

Line 110: , p5_a12 JTF_VARCHAR2_TABLE_100

106: , p5_a8 JTF_NUMBER_TABLE
107: , p5_a9 JTF_NUMBER_TABLE
108: , p5_a10 JTF_VARCHAR2_TABLE_100
109: , p5_a11 JTF_NUMBER_TABLE
110: , p5_a12 JTF_VARCHAR2_TABLE_100
111: , p5_a13 JTF_NUMBER_TABLE
112: , p5_a14 JTF_NUMBER_TABLE
113: , p5_a15 JTF_NUMBER_TABLE
114: , p5_a16 JTF_NUMBER_TABLE

Line 115: , p5_a17 JTF_VARCHAR2_TABLE_100

111: , p5_a13 JTF_NUMBER_TABLE
112: , p5_a14 JTF_NUMBER_TABLE
113: , p5_a15 JTF_NUMBER_TABLE
114: , p5_a16 JTF_NUMBER_TABLE
115: , p5_a17 JTF_VARCHAR2_TABLE_100
116: , p5_a18 JTF_VARCHAR2_TABLE_500
117: , p5_a19 JTF_VARCHAR2_TABLE_500
118: , p5_a20 JTF_VARCHAR2_TABLE_500
119: , p5_a21 JTF_VARCHAR2_TABLE_500

Line 136: , p5_a38 JTF_VARCHAR2_TABLE_100

132: , p5_a34 JTF_DATE_TABLE
133: , p5_a35 JTF_NUMBER_TABLE
134: , p5_a36 JTF_DATE_TABLE
135: , p5_a37 JTF_NUMBER_TABLE
136: , p5_a38 JTF_VARCHAR2_TABLE_100
137: , p5_a39 JTF_VARCHAR2_TABLE_100
138: , p5_a40 JTF_NUMBER_TABLE
139: , p5_a41 JTF_DATE_TABLE
140: , p6_a0 out nocopy JTF_NUMBER_TABLE

Line 137: , p5_a39 JTF_VARCHAR2_TABLE_100

133: , p5_a35 JTF_NUMBER_TABLE
134: , p5_a36 JTF_DATE_TABLE
135: , p5_a37 JTF_NUMBER_TABLE
136: , p5_a38 JTF_VARCHAR2_TABLE_100
137: , p5_a39 JTF_VARCHAR2_TABLE_100
138: , p5_a40 JTF_NUMBER_TABLE
139: , p5_a41 JTF_DATE_TABLE
140: , p6_a0 out nocopy JTF_NUMBER_TABLE
141: , p6_a1 out nocopy JTF_NUMBER_TABLE

Line 142: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100

138: , p5_a40 JTF_NUMBER_TABLE
139: , p5_a41 JTF_DATE_TABLE
140: , p6_a0 out nocopy JTF_NUMBER_TABLE
141: , p6_a1 out nocopy JTF_NUMBER_TABLE
142: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
143: , p6_a3 out nocopy JTF_NUMBER_TABLE
144: , p6_a4 out nocopy JTF_NUMBER_TABLE
145: , p6_a5 out nocopy JTF_NUMBER_TABLE
146: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 146: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100

142: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
143: , p6_a3 out nocopy JTF_NUMBER_TABLE
144: , p6_a4 out nocopy JTF_NUMBER_TABLE
145: , p6_a5 out nocopy JTF_NUMBER_TABLE
146: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
147: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_2000
148: , p6_a8 out nocopy JTF_NUMBER_TABLE
149: , p6_a9 out nocopy JTF_NUMBER_TABLE
150: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100

Line 150: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100

146: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
147: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_2000
148: , p6_a8 out nocopy JTF_NUMBER_TABLE
149: , p6_a9 out nocopy JTF_NUMBER_TABLE
150: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
151: , p6_a11 out nocopy JTF_NUMBER_TABLE
152: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
153: , p6_a13 out nocopy JTF_NUMBER_TABLE
154: , p6_a14 out nocopy JTF_NUMBER_TABLE

Line 152: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100

148: , p6_a8 out nocopy JTF_NUMBER_TABLE
149: , p6_a9 out nocopy JTF_NUMBER_TABLE
150: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
151: , p6_a11 out nocopy JTF_NUMBER_TABLE
152: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
153: , p6_a13 out nocopy JTF_NUMBER_TABLE
154: , p6_a14 out nocopy JTF_NUMBER_TABLE
155: , p6_a15 out nocopy JTF_NUMBER_TABLE
156: , p6_a16 out nocopy JTF_NUMBER_TABLE

Line 157: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_100

153: , p6_a13 out nocopy JTF_NUMBER_TABLE
154: , p6_a14 out nocopy JTF_NUMBER_TABLE
155: , p6_a15 out nocopy JTF_NUMBER_TABLE
156: , p6_a16 out nocopy JTF_NUMBER_TABLE
157: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_100
158: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_500
159: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_500
160: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
161: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500

Line 178: , p6_a38 out nocopy JTF_VARCHAR2_TABLE_100

174: , p6_a34 out nocopy JTF_DATE_TABLE
175: , p6_a35 out nocopy JTF_NUMBER_TABLE
176: , p6_a36 out nocopy JTF_DATE_TABLE
177: , p6_a37 out nocopy JTF_NUMBER_TABLE
178: , p6_a38 out nocopy JTF_VARCHAR2_TABLE_100
179: , p6_a39 out nocopy JTF_VARCHAR2_TABLE_100
180: , p6_a40 out nocopy JTF_NUMBER_TABLE
181: , p6_a41 out nocopy JTF_DATE_TABLE
182: );

Line 179: , p6_a39 out nocopy JTF_VARCHAR2_TABLE_100

175: , p6_a35 out nocopy JTF_NUMBER_TABLE
176: , p6_a36 out nocopy JTF_DATE_TABLE
177: , p6_a37 out nocopy JTF_NUMBER_TABLE
178: , p6_a38 out nocopy JTF_VARCHAR2_TABLE_100
179: , p6_a39 out nocopy JTF_VARCHAR2_TABLE_100
180: , p6_a40 out nocopy JTF_NUMBER_TABLE
181: , p6_a41 out nocopy JTF_DATE_TABLE
182: );
183: procedure delete_split_asset_comp(p_api_version NUMBER

Line 190: , p5_a2 JTF_VARCHAR2_TABLE_100

186: , x_msg_count out nocopy NUMBER
187: , x_msg_data out nocopy VARCHAR2
188: , p5_a0 JTF_NUMBER_TABLE
189: , p5_a1 JTF_NUMBER_TABLE
190: , p5_a2 JTF_VARCHAR2_TABLE_100
191: , p5_a3 JTF_NUMBER_TABLE
192: , p5_a4 JTF_NUMBER_TABLE
193: , p5_a5 JTF_NUMBER_TABLE
194: , p5_a6 JTF_VARCHAR2_TABLE_100

Line 194: , p5_a6 JTF_VARCHAR2_TABLE_100

190: , p5_a2 JTF_VARCHAR2_TABLE_100
191: , p5_a3 JTF_NUMBER_TABLE
192: , p5_a4 JTF_NUMBER_TABLE
193: , p5_a5 JTF_NUMBER_TABLE
194: , p5_a6 JTF_VARCHAR2_TABLE_100
195: , p5_a7 JTF_VARCHAR2_TABLE_2000
196: , p5_a8 JTF_NUMBER_TABLE
197: , p5_a9 JTF_NUMBER_TABLE
198: , p5_a10 JTF_VARCHAR2_TABLE_100

Line 198: , p5_a10 JTF_VARCHAR2_TABLE_100

194: , p5_a6 JTF_VARCHAR2_TABLE_100
195: , p5_a7 JTF_VARCHAR2_TABLE_2000
196: , p5_a8 JTF_NUMBER_TABLE
197: , p5_a9 JTF_NUMBER_TABLE
198: , p5_a10 JTF_VARCHAR2_TABLE_100
199: , p5_a11 JTF_NUMBER_TABLE
200: , p5_a12 JTF_VARCHAR2_TABLE_100
201: , p5_a13 JTF_NUMBER_TABLE
202: , p5_a14 JTF_NUMBER_TABLE

Line 200: , p5_a12 JTF_VARCHAR2_TABLE_100

196: , p5_a8 JTF_NUMBER_TABLE
197: , p5_a9 JTF_NUMBER_TABLE
198: , p5_a10 JTF_VARCHAR2_TABLE_100
199: , p5_a11 JTF_NUMBER_TABLE
200: , p5_a12 JTF_VARCHAR2_TABLE_100
201: , p5_a13 JTF_NUMBER_TABLE
202: , p5_a14 JTF_NUMBER_TABLE
203: , p5_a15 JTF_NUMBER_TABLE
204: , p5_a16 JTF_NUMBER_TABLE

Line 205: , p5_a17 JTF_VARCHAR2_TABLE_100

201: , p5_a13 JTF_NUMBER_TABLE
202: , p5_a14 JTF_NUMBER_TABLE
203: , p5_a15 JTF_NUMBER_TABLE
204: , p5_a16 JTF_NUMBER_TABLE
205: , p5_a17 JTF_VARCHAR2_TABLE_100
206: , p5_a18 JTF_VARCHAR2_TABLE_500
207: , p5_a19 JTF_VARCHAR2_TABLE_500
208: , p5_a20 JTF_VARCHAR2_TABLE_500
209: , p5_a21 JTF_VARCHAR2_TABLE_500

Line 226: , p5_a38 JTF_VARCHAR2_TABLE_100

222: , p5_a34 JTF_DATE_TABLE
223: , p5_a35 JTF_NUMBER_TABLE
224: , p5_a36 JTF_DATE_TABLE
225: , p5_a37 JTF_NUMBER_TABLE
226: , p5_a38 JTF_VARCHAR2_TABLE_100
227: , p5_a39 JTF_VARCHAR2_TABLE_100
228: , p5_a40 JTF_NUMBER_TABLE
229: , p5_a41 JTF_DATE_TABLE
230: );

Line 227: , p5_a39 JTF_VARCHAR2_TABLE_100

223: , p5_a35 JTF_NUMBER_TABLE
224: , p5_a36 JTF_DATE_TABLE
225: , p5_a37 JTF_NUMBER_TABLE
226: , p5_a38 JTF_VARCHAR2_TABLE_100
227: , p5_a39 JTF_VARCHAR2_TABLE_100
228: , p5_a40 JTF_NUMBER_TABLE
229: , p5_a41 JTF_DATE_TABLE
230: );
231: end okl_split_asset_comp_pvt_w;