APPS.OKL_VP_ASSOCIATIONS_PVT_W dependencies on JTF_NUMBER_TABLE

Line 84: , p5_a0 JTF_NUMBER_TABLE

80: , p_init_msg_list VARCHAR2
81: , x_return_status out nocopy VARCHAR2
82: , x_msg_count out nocopy NUMBER
83: , x_msg_data out nocopy VARCHAR2
84: , p5_a0 JTF_NUMBER_TABLE
85: , p5_a1 JTF_NUMBER_TABLE
86: , p5_a2 JTF_NUMBER_TABLE
87: , p5_a3 JTF_NUMBER_TABLE
88: , p5_a4 JTF_DATE_TABLE

Line 85: , p5_a1 JTF_NUMBER_TABLE

81: , x_return_status out nocopy VARCHAR2
82: , x_msg_count out nocopy NUMBER
83: , x_msg_data out nocopy VARCHAR2
84: , p5_a0 JTF_NUMBER_TABLE
85: , p5_a1 JTF_NUMBER_TABLE
86: , p5_a2 JTF_NUMBER_TABLE
87: , p5_a3 JTF_NUMBER_TABLE
88: , p5_a4 JTF_DATE_TABLE
89: , p5_a5 JTF_DATE_TABLE

Line 86: , p5_a2 JTF_NUMBER_TABLE

82: , x_msg_count out nocopy NUMBER
83: , x_msg_data out nocopy VARCHAR2
84: , p5_a0 JTF_NUMBER_TABLE
85: , p5_a1 JTF_NUMBER_TABLE
86: , p5_a2 JTF_NUMBER_TABLE
87: , p5_a3 JTF_NUMBER_TABLE
88: , p5_a4 JTF_DATE_TABLE
89: , p5_a5 JTF_DATE_TABLE
90: , p5_a6 JTF_VARCHAR2_TABLE_2000

Line 87: , p5_a3 JTF_NUMBER_TABLE

83: , x_msg_data out nocopy VARCHAR2
84: , p5_a0 JTF_NUMBER_TABLE
85: , p5_a1 JTF_NUMBER_TABLE
86: , p5_a2 JTF_NUMBER_TABLE
87: , p5_a3 JTF_NUMBER_TABLE
88: , p5_a4 JTF_DATE_TABLE
89: , p5_a5 JTF_DATE_TABLE
90: , p5_a6 JTF_VARCHAR2_TABLE_2000
91: , p5_a7 JTF_VARCHAR2_TABLE_100

Line 92: , p5_a8 JTF_NUMBER_TABLE

88: , p5_a4 JTF_DATE_TABLE
89: , p5_a5 JTF_DATE_TABLE
90: , p5_a6 JTF_VARCHAR2_TABLE_2000
91: , p5_a7 JTF_VARCHAR2_TABLE_100
92: , p5_a8 JTF_NUMBER_TABLE
93: , p5_a9 JTF_NUMBER_TABLE
94: , p5_a10 JTF_VARCHAR2_TABLE_100
95: , p5_a11 JTF_VARCHAR2_TABLE_500
96: , p5_a12 JTF_VARCHAR2_TABLE_500

Line 93: , p5_a9 JTF_NUMBER_TABLE

89: , p5_a5 JTF_DATE_TABLE
90: , p5_a6 JTF_VARCHAR2_TABLE_2000
91: , p5_a7 JTF_VARCHAR2_TABLE_100
92: , p5_a8 JTF_NUMBER_TABLE
93: , p5_a9 JTF_NUMBER_TABLE
94: , p5_a10 JTF_VARCHAR2_TABLE_100
95: , p5_a11 JTF_VARCHAR2_TABLE_500
96: , p5_a12 JTF_VARCHAR2_TABLE_500
97: , p5_a13 JTF_VARCHAR2_TABLE_500

Line 110: , p5_a26 JTF_NUMBER_TABLE

106: , p5_a22 JTF_VARCHAR2_TABLE_500
107: , p5_a23 JTF_VARCHAR2_TABLE_500
108: , p5_a24 JTF_VARCHAR2_TABLE_500
109: , p5_a25 JTF_VARCHAR2_TABLE_500
110: , p5_a26 JTF_NUMBER_TABLE
111: , p5_a27 JTF_NUMBER_TABLE
112: , p5_a28 JTF_NUMBER_TABLE
113: , p5_a29 JTF_DATE_TABLE
114: , p5_a30 JTF_NUMBER_TABLE

Line 111: , p5_a27 JTF_NUMBER_TABLE

107: , p5_a23 JTF_VARCHAR2_TABLE_500
108: , p5_a24 JTF_VARCHAR2_TABLE_500
109: , p5_a25 JTF_VARCHAR2_TABLE_500
110: , p5_a26 JTF_NUMBER_TABLE
111: , p5_a27 JTF_NUMBER_TABLE
112: , p5_a28 JTF_NUMBER_TABLE
113: , p5_a29 JTF_DATE_TABLE
114: , p5_a30 JTF_NUMBER_TABLE
115: , p5_a31 JTF_DATE_TABLE

Line 112: , p5_a28 JTF_NUMBER_TABLE

108: , p5_a24 JTF_VARCHAR2_TABLE_500
109: , p5_a25 JTF_VARCHAR2_TABLE_500
110: , p5_a26 JTF_NUMBER_TABLE
111: , p5_a27 JTF_NUMBER_TABLE
112: , p5_a28 JTF_NUMBER_TABLE
113: , p5_a29 JTF_DATE_TABLE
114: , p5_a30 JTF_NUMBER_TABLE
115: , p5_a31 JTF_DATE_TABLE
116: , p5_a32 JTF_NUMBER_TABLE

Line 114: , p5_a30 JTF_NUMBER_TABLE

110: , p5_a26 JTF_NUMBER_TABLE
111: , p5_a27 JTF_NUMBER_TABLE
112: , p5_a28 JTF_NUMBER_TABLE
113: , p5_a29 JTF_DATE_TABLE
114: , p5_a30 JTF_NUMBER_TABLE
115: , p5_a31 JTF_DATE_TABLE
116: , p5_a32 JTF_NUMBER_TABLE
117: , p5_a33 JTF_DATE_TABLE
118: , p5_a34 JTF_NUMBER_TABLE

Line 116: , p5_a32 JTF_NUMBER_TABLE

112: , p5_a28 JTF_NUMBER_TABLE
113: , p5_a29 JTF_DATE_TABLE
114: , p5_a30 JTF_NUMBER_TABLE
115: , p5_a31 JTF_DATE_TABLE
116: , p5_a32 JTF_NUMBER_TABLE
117: , p5_a33 JTF_DATE_TABLE
118: , p5_a34 JTF_NUMBER_TABLE
119: , p6_a0 out nocopy JTF_NUMBER_TABLE
120: , p6_a1 out nocopy JTF_NUMBER_TABLE

Line 118: , p5_a34 JTF_NUMBER_TABLE

114: , p5_a30 JTF_NUMBER_TABLE
115: , p5_a31 JTF_DATE_TABLE
116: , p5_a32 JTF_NUMBER_TABLE
117: , p5_a33 JTF_DATE_TABLE
118: , p5_a34 JTF_NUMBER_TABLE
119: , p6_a0 out nocopy JTF_NUMBER_TABLE
120: , p6_a1 out nocopy JTF_NUMBER_TABLE
121: , p6_a2 out nocopy JTF_NUMBER_TABLE
122: , p6_a3 out nocopy JTF_NUMBER_TABLE

Line 119: , p6_a0 out nocopy JTF_NUMBER_TABLE

115: , p5_a31 JTF_DATE_TABLE
116: , p5_a32 JTF_NUMBER_TABLE
117: , p5_a33 JTF_DATE_TABLE
118: , p5_a34 JTF_NUMBER_TABLE
119: , p6_a0 out nocopy JTF_NUMBER_TABLE
120: , p6_a1 out nocopy JTF_NUMBER_TABLE
121: , p6_a2 out nocopy JTF_NUMBER_TABLE
122: , p6_a3 out nocopy JTF_NUMBER_TABLE
123: , p6_a4 out nocopy JTF_DATE_TABLE

Line 120: , p6_a1 out nocopy JTF_NUMBER_TABLE

116: , p5_a32 JTF_NUMBER_TABLE
117: , p5_a33 JTF_DATE_TABLE
118: , p5_a34 JTF_NUMBER_TABLE
119: , p6_a0 out nocopy JTF_NUMBER_TABLE
120: , p6_a1 out nocopy JTF_NUMBER_TABLE
121: , p6_a2 out nocopy JTF_NUMBER_TABLE
122: , p6_a3 out nocopy JTF_NUMBER_TABLE
123: , p6_a4 out nocopy JTF_DATE_TABLE
124: , p6_a5 out nocopy JTF_DATE_TABLE

Line 121: , p6_a2 out nocopy JTF_NUMBER_TABLE

117: , p5_a33 JTF_DATE_TABLE
118: , p5_a34 JTF_NUMBER_TABLE
119: , p6_a0 out nocopy JTF_NUMBER_TABLE
120: , p6_a1 out nocopy JTF_NUMBER_TABLE
121: , p6_a2 out nocopy JTF_NUMBER_TABLE
122: , p6_a3 out nocopy JTF_NUMBER_TABLE
123: , p6_a4 out nocopy JTF_DATE_TABLE
124: , p6_a5 out nocopy JTF_DATE_TABLE
125: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000

Line 122: , p6_a3 out nocopy JTF_NUMBER_TABLE

118: , p5_a34 JTF_NUMBER_TABLE
119: , p6_a0 out nocopy JTF_NUMBER_TABLE
120: , p6_a1 out nocopy JTF_NUMBER_TABLE
121: , p6_a2 out nocopy JTF_NUMBER_TABLE
122: , p6_a3 out nocopy JTF_NUMBER_TABLE
123: , p6_a4 out nocopy JTF_DATE_TABLE
124: , p6_a5 out nocopy JTF_DATE_TABLE
125: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000
126: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100

Line 127: , p6_a8 out nocopy JTF_NUMBER_TABLE

123: , p6_a4 out nocopy JTF_DATE_TABLE
124: , p6_a5 out nocopy JTF_DATE_TABLE
125: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000
126: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
127: , p6_a8 out nocopy JTF_NUMBER_TABLE
128: , p6_a9 out nocopy JTF_NUMBER_TABLE
129: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
130: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_500
131: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_500

Line 128: , p6_a9 out nocopy JTF_NUMBER_TABLE

124: , p6_a5 out nocopy JTF_DATE_TABLE
125: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000
126: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
127: , p6_a8 out nocopy JTF_NUMBER_TABLE
128: , p6_a9 out nocopy JTF_NUMBER_TABLE
129: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
130: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_500
131: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_500
132: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_500

Line 145: , p6_a26 out nocopy JTF_NUMBER_TABLE

141: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
142: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
143: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
144: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
145: , p6_a26 out nocopy JTF_NUMBER_TABLE
146: , p6_a27 out nocopy JTF_NUMBER_TABLE
147: , p6_a28 out nocopy JTF_NUMBER_TABLE
148: , p6_a29 out nocopy JTF_DATE_TABLE
149: , p6_a30 out nocopy JTF_NUMBER_TABLE

Line 146: , p6_a27 out nocopy JTF_NUMBER_TABLE

142: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
143: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
144: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
145: , p6_a26 out nocopy JTF_NUMBER_TABLE
146: , p6_a27 out nocopy JTF_NUMBER_TABLE
147: , p6_a28 out nocopy JTF_NUMBER_TABLE
148: , p6_a29 out nocopy JTF_DATE_TABLE
149: , p6_a30 out nocopy JTF_NUMBER_TABLE
150: , p6_a31 out nocopy JTF_DATE_TABLE

Line 147: , p6_a28 out nocopy JTF_NUMBER_TABLE

143: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
144: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
145: , p6_a26 out nocopy JTF_NUMBER_TABLE
146: , p6_a27 out nocopy JTF_NUMBER_TABLE
147: , p6_a28 out nocopy JTF_NUMBER_TABLE
148: , p6_a29 out nocopy JTF_DATE_TABLE
149: , p6_a30 out nocopy JTF_NUMBER_TABLE
150: , p6_a31 out nocopy JTF_DATE_TABLE
151: , p6_a32 out nocopy JTF_NUMBER_TABLE

Line 149: , p6_a30 out nocopy JTF_NUMBER_TABLE

145: , p6_a26 out nocopy JTF_NUMBER_TABLE
146: , p6_a27 out nocopy JTF_NUMBER_TABLE
147: , p6_a28 out nocopy JTF_NUMBER_TABLE
148: , p6_a29 out nocopy JTF_DATE_TABLE
149: , p6_a30 out nocopy JTF_NUMBER_TABLE
150: , p6_a31 out nocopy JTF_DATE_TABLE
151: , p6_a32 out nocopy JTF_NUMBER_TABLE
152: , p6_a33 out nocopy JTF_DATE_TABLE
153: , p6_a34 out nocopy JTF_NUMBER_TABLE

Line 151: , p6_a32 out nocopy JTF_NUMBER_TABLE

147: , p6_a28 out nocopy JTF_NUMBER_TABLE
148: , p6_a29 out nocopy JTF_DATE_TABLE
149: , p6_a30 out nocopy JTF_NUMBER_TABLE
150: , p6_a31 out nocopy JTF_DATE_TABLE
151: , p6_a32 out nocopy JTF_NUMBER_TABLE
152: , p6_a33 out nocopy JTF_DATE_TABLE
153: , p6_a34 out nocopy JTF_NUMBER_TABLE
154: );
155: procedure lock_vp_associations(p_api_version NUMBER

Line 153: , p6_a34 out nocopy JTF_NUMBER_TABLE

149: , p6_a30 out nocopy JTF_NUMBER_TABLE
150: , p6_a31 out nocopy JTF_DATE_TABLE
151: , p6_a32 out nocopy JTF_NUMBER_TABLE
152: , p6_a33 out nocopy JTF_DATE_TABLE
153: , p6_a34 out nocopy JTF_NUMBER_TABLE
154: );
155: procedure lock_vp_associations(p_api_version NUMBER
156: , p_init_msg_list VARCHAR2
157: , x_return_status out nocopy VARCHAR2

Line 201: , p5_a0 JTF_NUMBER_TABLE

197: , p_init_msg_list VARCHAR2
198: , x_return_status out nocopy VARCHAR2
199: , x_msg_count out nocopy NUMBER
200: , x_msg_data out nocopy VARCHAR2
201: , p5_a0 JTF_NUMBER_TABLE
202: , p5_a1 JTF_NUMBER_TABLE
203: , p5_a2 JTF_NUMBER_TABLE
204: , p5_a3 JTF_NUMBER_TABLE
205: , p5_a4 JTF_DATE_TABLE

Line 202: , p5_a1 JTF_NUMBER_TABLE

198: , x_return_status out nocopy VARCHAR2
199: , x_msg_count out nocopy NUMBER
200: , x_msg_data out nocopy VARCHAR2
201: , p5_a0 JTF_NUMBER_TABLE
202: , p5_a1 JTF_NUMBER_TABLE
203: , p5_a2 JTF_NUMBER_TABLE
204: , p5_a3 JTF_NUMBER_TABLE
205: , p5_a4 JTF_DATE_TABLE
206: , p5_a5 JTF_DATE_TABLE

Line 203: , p5_a2 JTF_NUMBER_TABLE

199: , x_msg_count out nocopy NUMBER
200: , x_msg_data out nocopy VARCHAR2
201: , p5_a0 JTF_NUMBER_TABLE
202: , p5_a1 JTF_NUMBER_TABLE
203: , p5_a2 JTF_NUMBER_TABLE
204: , p5_a3 JTF_NUMBER_TABLE
205: , p5_a4 JTF_DATE_TABLE
206: , p5_a5 JTF_DATE_TABLE
207: , p5_a6 JTF_VARCHAR2_TABLE_2000

Line 204: , p5_a3 JTF_NUMBER_TABLE

200: , x_msg_data out nocopy VARCHAR2
201: , p5_a0 JTF_NUMBER_TABLE
202: , p5_a1 JTF_NUMBER_TABLE
203: , p5_a2 JTF_NUMBER_TABLE
204: , p5_a3 JTF_NUMBER_TABLE
205: , p5_a4 JTF_DATE_TABLE
206: , p5_a5 JTF_DATE_TABLE
207: , p5_a6 JTF_VARCHAR2_TABLE_2000
208: , p5_a7 JTF_VARCHAR2_TABLE_100

Line 209: , p5_a8 JTF_NUMBER_TABLE

205: , p5_a4 JTF_DATE_TABLE
206: , p5_a5 JTF_DATE_TABLE
207: , p5_a6 JTF_VARCHAR2_TABLE_2000
208: , p5_a7 JTF_VARCHAR2_TABLE_100
209: , p5_a8 JTF_NUMBER_TABLE
210: , p5_a9 JTF_NUMBER_TABLE
211: , p5_a10 JTF_VARCHAR2_TABLE_100
212: , p5_a11 JTF_VARCHAR2_TABLE_500
213: , p5_a12 JTF_VARCHAR2_TABLE_500

Line 210: , p5_a9 JTF_NUMBER_TABLE

206: , p5_a5 JTF_DATE_TABLE
207: , p5_a6 JTF_VARCHAR2_TABLE_2000
208: , p5_a7 JTF_VARCHAR2_TABLE_100
209: , p5_a8 JTF_NUMBER_TABLE
210: , p5_a9 JTF_NUMBER_TABLE
211: , p5_a10 JTF_VARCHAR2_TABLE_100
212: , p5_a11 JTF_VARCHAR2_TABLE_500
213: , p5_a12 JTF_VARCHAR2_TABLE_500
214: , p5_a13 JTF_VARCHAR2_TABLE_500

Line 227: , p5_a26 JTF_NUMBER_TABLE

223: , p5_a22 JTF_VARCHAR2_TABLE_500
224: , p5_a23 JTF_VARCHAR2_TABLE_500
225: , p5_a24 JTF_VARCHAR2_TABLE_500
226: , p5_a25 JTF_VARCHAR2_TABLE_500
227: , p5_a26 JTF_NUMBER_TABLE
228: , p5_a27 JTF_NUMBER_TABLE
229: , p5_a28 JTF_NUMBER_TABLE
230: , p5_a29 JTF_DATE_TABLE
231: , p5_a30 JTF_NUMBER_TABLE

Line 228: , p5_a27 JTF_NUMBER_TABLE

224: , p5_a23 JTF_VARCHAR2_TABLE_500
225: , p5_a24 JTF_VARCHAR2_TABLE_500
226: , p5_a25 JTF_VARCHAR2_TABLE_500
227: , p5_a26 JTF_NUMBER_TABLE
228: , p5_a27 JTF_NUMBER_TABLE
229: , p5_a28 JTF_NUMBER_TABLE
230: , p5_a29 JTF_DATE_TABLE
231: , p5_a30 JTF_NUMBER_TABLE
232: , p5_a31 JTF_DATE_TABLE

Line 229: , p5_a28 JTF_NUMBER_TABLE

225: , p5_a24 JTF_VARCHAR2_TABLE_500
226: , p5_a25 JTF_VARCHAR2_TABLE_500
227: , p5_a26 JTF_NUMBER_TABLE
228: , p5_a27 JTF_NUMBER_TABLE
229: , p5_a28 JTF_NUMBER_TABLE
230: , p5_a29 JTF_DATE_TABLE
231: , p5_a30 JTF_NUMBER_TABLE
232: , p5_a31 JTF_DATE_TABLE
233: , p5_a32 JTF_NUMBER_TABLE

Line 231: , p5_a30 JTF_NUMBER_TABLE

227: , p5_a26 JTF_NUMBER_TABLE
228: , p5_a27 JTF_NUMBER_TABLE
229: , p5_a28 JTF_NUMBER_TABLE
230: , p5_a29 JTF_DATE_TABLE
231: , p5_a30 JTF_NUMBER_TABLE
232: , p5_a31 JTF_DATE_TABLE
233: , p5_a32 JTF_NUMBER_TABLE
234: , p5_a33 JTF_DATE_TABLE
235: , p5_a34 JTF_NUMBER_TABLE

Line 233: , p5_a32 JTF_NUMBER_TABLE

229: , p5_a28 JTF_NUMBER_TABLE
230: , p5_a29 JTF_DATE_TABLE
231: , p5_a30 JTF_NUMBER_TABLE
232: , p5_a31 JTF_DATE_TABLE
233: , p5_a32 JTF_NUMBER_TABLE
234: , p5_a33 JTF_DATE_TABLE
235: , p5_a34 JTF_NUMBER_TABLE
236: );
237: procedure update_vp_associations(p_api_version NUMBER

Line 235: , p5_a34 JTF_NUMBER_TABLE

231: , p5_a30 JTF_NUMBER_TABLE
232: , p5_a31 JTF_DATE_TABLE
233: , p5_a32 JTF_NUMBER_TABLE
234: , p5_a33 JTF_DATE_TABLE
235: , p5_a34 JTF_NUMBER_TABLE
236: );
237: procedure update_vp_associations(p_api_version NUMBER
238: , p_init_msg_list VARCHAR2
239: , x_return_status out nocopy VARCHAR2

Line 318: , p5_a0 JTF_NUMBER_TABLE

314: , p_init_msg_list VARCHAR2
315: , x_return_status out nocopy VARCHAR2
316: , x_msg_count out nocopy NUMBER
317: , x_msg_data out nocopy VARCHAR2
318: , p5_a0 JTF_NUMBER_TABLE
319: , p5_a1 JTF_NUMBER_TABLE
320: , p5_a2 JTF_NUMBER_TABLE
321: , p5_a3 JTF_NUMBER_TABLE
322: , p5_a4 JTF_DATE_TABLE

Line 319: , p5_a1 JTF_NUMBER_TABLE

315: , x_return_status out nocopy VARCHAR2
316: , x_msg_count out nocopy NUMBER
317: , x_msg_data out nocopy VARCHAR2
318: , p5_a0 JTF_NUMBER_TABLE
319: , p5_a1 JTF_NUMBER_TABLE
320: , p5_a2 JTF_NUMBER_TABLE
321: , p5_a3 JTF_NUMBER_TABLE
322: , p5_a4 JTF_DATE_TABLE
323: , p5_a5 JTF_DATE_TABLE

Line 320: , p5_a2 JTF_NUMBER_TABLE

316: , x_msg_count out nocopy NUMBER
317: , x_msg_data out nocopy VARCHAR2
318: , p5_a0 JTF_NUMBER_TABLE
319: , p5_a1 JTF_NUMBER_TABLE
320: , p5_a2 JTF_NUMBER_TABLE
321: , p5_a3 JTF_NUMBER_TABLE
322: , p5_a4 JTF_DATE_TABLE
323: , p5_a5 JTF_DATE_TABLE
324: , p5_a6 JTF_VARCHAR2_TABLE_2000

Line 321: , p5_a3 JTF_NUMBER_TABLE

317: , x_msg_data out nocopy VARCHAR2
318: , p5_a0 JTF_NUMBER_TABLE
319: , p5_a1 JTF_NUMBER_TABLE
320: , p5_a2 JTF_NUMBER_TABLE
321: , p5_a3 JTF_NUMBER_TABLE
322: , p5_a4 JTF_DATE_TABLE
323: , p5_a5 JTF_DATE_TABLE
324: , p5_a6 JTF_VARCHAR2_TABLE_2000
325: , p5_a7 JTF_VARCHAR2_TABLE_100

Line 326: , p5_a8 JTF_NUMBER_TABLE

322: , p5_a4 JTF_DATE_TABLE
323: , p5_a5 JTF_DATE_TABLE
324: , p5_a6 JTF_VARCHAR2_TABLE_2000
325: , p5_a7 JTF_VARCHAR2_TABLE_100
326: , p5_a8 JTF_NUMBER_TABLE
327: , p5_a9 JTF_NUMBER_TABLE
328: , p5_a10 JTF_VARCHAR2_TABLE_100
329: , p5_a11 JTF_VARCHAR2_TABLE_500
330: , p5_a12 JTF_VARCHAR2_TABLE_500

Line 327: , p5_a9 JTF_NUMBER_TABLE

323: , p5_a5 JTF_DATE_TABLE
324: , p5_a6 JTF_VARCHAR2_TABLE_2000
325: , p5_a7 JTF_VARCHAR2_TABLE_100
326: , p5_a8 JTF_NUMBER_TABLE
327: , p5_a9 JTF_NUMBER_TABLE
328: , p5_a10 JTF_VARCHAR2_TABLE_100
329: , p5_a11 JTF_VARCHAR2_TABLE_500
330: , p5_a12 JTF_VARCHAR2_TABLE_500
331: , p5_a13 JTF_VARCHAR2_TABLE_500

Line 344: , p5_a26 JTF_NUMBER_TABLE

340: , p5_a22 JTF_VARCHAR2_TABLE_500
341: , p5_a23 JTF_VARCHAR2_TABLE_500
342: , p5_a24 JTF_VARCHAR2_TABLE_500
343: , p5_a25 JTF_VARCHAR2_TABLE_500
344: , p5_a26 JTF_NUMBER_TABLE
345: , p5_a27 JTF_NUMBER_TABLE
346: , p5_a28 JTF_NUMBER_TABLE
347: , p5_a29 JTF_DATE_TABLE
348: , p5_a30 JTF_NUMBER_TABLE

Line 345: , p5_a27 JTF_NUMBER_TABLE

341: , p5_a23 JTF_VARCHAR2_TABLE_500
342: , p5_a24 JTF_VARCHAR2_TABLE_500
343: , p5_a25 JTF_VARCHAR2_TABLE_500
344: , p5_a26 JTF_NUMBER_TABLE
345: , p5_a27 JTF_NUMBER_TABLE
346: , p5_a28 JTF_NUMBER_TABLE
347: , p5_a29 JTF_DATE_TABLE
348: , p5_a30 JTF_NUMBER_TABLE
349: , p5_a31 JTF_DATE_TABLE

Line 346: , p5_a28 JTF_NUMBER_TABLE

342: , p5_a24 JTF_VARCHAR2_TABLE_500
343: , p5_a25 JTF_VARCHAR2_TABLE_500
344: , p5_a26 JTF_NUMBER_TABLE
345: , p5_a27 JTF_NUMBER_TABLE
346: , p5_a28 JTF_NUMBER_TABLE
347: , p5_a29 JTF_DATE_TABLE
348: , p5_a30 JTF_NUMBER_TABLE
349: , p5_a31 JTF_DATE_TABLE
350: , p5_a32 JTF_NUMBER_TABLE

Line 348: , p5_a30 JTF_NUMBER_TABLE

344: , p5_a26 JTF_NUMBER_TABLE
345: , p5_a27 JTF_NUMBER_TABLE
346: , p5_a28 JTF_NUMBER_TABLE
347: , p5_a29 JTF_DATE_TABLE
348: , p5_a30 JTF_NUMBER_TABLE
349: , p5_a31 JTF_DATE_TABLE
350: , p5_a32 JTF_NUMBER_TABLE
351: , p5_a33 JTF_DATE_TABLE
352: , p5_a34 JTF_NUMBER_TABLE

Line 350: , p5_a32 JTF_NUMBER_TABLE

346: , p5_a28 JTF_NUMBER_TABLE
347: , p5_a29 JTF_DATE_TABLE
348: , p5_a30 JTF_NUMBER_TABLE
349: , p5_a31 JTF_DATE_TABLE
350: , p5_a32 JTF_NUMBER_TABLE
351: , p5_a33 JTF_DATE_TABLE
352: , p5_a34 JTF_NUMBER_TABLE
353: , p6_a0 out nocopy JTF_NUMBER_TABLE
354: , p6_a1 out nocopy JTF_NUMBER_TABLE

Line 352: , p5_a34 JTF_NUMBER_TABLE

348: , p5_a30 JTF_NUMBER_TABLE
349: , p5_a31 JTF_DATE_TABLE
350: , p5_a32 JTF_NUMBER_TABLE
351: , p5_a33 JTF_DATE_TABLE
352: , p5_a34 JTF_NUMBER_TABLE
353: , p6_a0 out nocopy JTF_NUMBER_TABLE
354: , p6_a1 out nocopy JTF_NUMBER_TABLE
355: , p6_a2 out nocopy JTF_NUMBER_TABLE
356: , p6_a3 out nocopy JTF_NUMBER_TABLE

Line 353: , p6_a0 out nocopy JTF_NUMBER_TABLE

349: , p5_a31 JTF_DATE_TABLE
350: , p5_a32 JTF_NUMBER_TABLE
351: , p5_a33 JTF_DATE_TABLE
352: , p5_a34 JTF_NUMBER_TABLE
353: , p6_a0 out nocopy JTF_NUMBER_TABLE
354: , p6_a1 out nocopy JTF_NUMBER_TABLE
355: , p6_a2 out nocopy JTF_NUMBER_TABLE
356: , p6_a3 out nocopy JTF_NUMBER_TABLE
357: , p6_a4 out nocopy JTF_DATE_TABLE

Line 354: , p6_a1 out nocopy JTF_NUMBER_TABLE

350: , p5_a32 JTF_NUMBER_TABLE
351: , p5_a33 JTF_DATE_TABLE
352: , p5_a34 JTF_NUMBER_TABLE
353: , p6_a0 out nocopy JTF_NUMBER_TABLE
354: , p6_a1 out nocopy JTF_NUMBER_TABLE
355: , p6_a2 out nocopy JTF_NUMBER_TABLE
356: , p6_a3 out nocopy JTF_NUMBER_TABLE
357: , p6_a4 out nocopy JTF_DATE_TABLE
358: , p6_a5 out nocopy JTF_DATE_TABLE

Line 355: , p6_a2 out nocopy JTF_NUMBER_TABLE

351: , p5_a33 JTF_DATE_TABLE
352: , p5_a34 JTF_NUMBER_TABLE
353: , p6_a0 out nocopy JTF_NUMBER_TABLE
354: , p6_a1 out nocopy JTF_NUMBER_TABLE
355: , p6_a2 out nocopy JTF_NUMBER_TABLE
356: , p6_a3 out nocopy JTF_NUMBER_TABLE
357: , p6_a4 out nocopy JTF_DATE_TABLE
358: , p6_a5 out nocopy JTF_DATE_TABLE
359: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000

Line 356: , p6_a3 out nocopy JTF_NUMBER_TABLE

352: , p5_a34 JTF_NUMBER_TABLE
353: , p6_a0 out nocopy JTF_NUMBER_TABLE
354: , p6_a1 out nocopy JTF_NUMBER_TABLE
355: , p6_a2 out nocopy JTF_NUMBER_TABLE
356: , p6_a3 out nocopy JTF_NUMBER_TABLE
357: , p6_a4 out nocopy JTF_DATE_TABLE
358: , p6_a5 out nocopy JTF_DATE_TABLE
359: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000
360: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100

Line 361: , p6_a8 out nocopy JTF_NUMBER_TABLE

357: , p6_a4 out nocopy JTF_DATE_TABLE
358: , p6_a5 out nocopy JTF_DATE_TABLE
359: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000
360: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
361: , p6_a8 out nocopy JTF_NUMBER_TABLE
362: , p6_a9 out nocopy JTF_NUMBER_TABLE
363: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
364: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_500
365: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_500

Line 362: , p6_a9 out nocopy JTF_NUMBER_TABLE

358: , p6_a5 out nocopy JTF_DATE_TABLE
359: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000
360: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
361: , p6_a8 out nocopy JTF_NUMBER_TABLE
362: , p6_a9 out nocopy JTF_NUMBER_TABLE
363: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
364: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_500
365: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_500
366: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_500

Line 379: , p6_a26 out nocopy JTF_NUMBER_TABLE

375: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
376: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
377: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
378: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
379: , p6_a26 out nocopy JTF_NUMBER_TABLE
380: , p6_a27 out nocopy JTF_NUMBER_TABLE
381: , p6_a28 out nocopy JTF_NUMBER_TABLE
382: , p6_a29 out nocopy JTF_DATE_TABLE
383: , p6_a30 out nocopy JTF_NUMBER_TABLE

Line 380: , p6_a27 out nocopy JTF_NUMBER_TABLE

376: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
377: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
378: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
379: , p6_a26 out nocopy JTF_NUMBER_TABLE
380: , p6_a27 out nocopy JTF_NUMBER_TABLE
381: , p6_a28 out nocopy JTF_NUMBER_TABLE
382: , p6_a29 out nocopy JTF_DATE_TABLE
383: , p6_a30 out nocopy JTF_NUMBER_TABLE
384: , p6_a31 out nocopy JTF_DATE_TABLE

Line 381: , p6_a28 out nocopy JTF_NUMBER_TABLE

377: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
378: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
379: , p6_a26 out nocopy JTF_NUMBER_TABLE
380: , p6_a27 out nocopy JTF_NUMBER_TABLE
381: , p6_a28 out nocopy JTF_NUMBER_TABLE
382: , p6_a29 out nocopy JTF_DATE_TABLE
383: , p6_a30 out nocopy JTF_NUMBER_TABLE
384: , p6_a31 out nocopy JTF_DATE_TABLE
385: , p6_a32 out nocopy JTF_NUMBER_TABLE

Line 383: , p6_a30 out nocopy JTF_NUMBER_TABLE

379: , p6_a26 out nocopy JTF_NUMBER_TABLE
380: , p6_a27 out nocopy JTF_NUMBER_TABLE
381: , p6_a28 out nocopy JTF_NUMBER_TABLE
382: , p6_a29 out nocopy JTF_DATE_TABLE
383: , p6_a30 out nocopy JTF_NUMBER_TABLE
384: , p6_a31 out nocopy JTF_DATE_TABLE
385: , p6_a32 out nocopy JTF_NUMBER_TABLE
386: , p6_a33 out nocopy JTF_DATE_TABLE
387: , p6_a34 out nocopy JTF_NUMBER_TABLE

Line 385: , p6_a32 out nocopy JTF_NUMBER_TABLE

381: , p6_a28 out nocopy JTF_NUMBER_TABLE
382: , p6_a29 out nocopy JTF_DATE_TABLE
383: , p6_a30 out nocopy JTF_NUMBER_TABLE
384: , p6_a31 out nocopy JTF_DATE_TABLE
385: , p6_a32 out nocopy JTF_NUMBER_TABLE
386: , p6_a33 out nocopy JTF_DATE_TABLE
387: , p6_a34 out nocopy JTF_NUMBER_TABLE
388: );
389: procedure delete_vp_associations(p_api_version NUMBER

Line 387: , p6_a34 out nocopy JTF_NUMBER_TABLE

383: , p6_a30 out nocopy JTF_NUMBER_TABLE
384: , p6_a31 out nocopy JTF_DATE_TABLE
385: , p6_a32 out nocopy JTF_NUMBER_TABLE
386: , p6_a33 out nocopy JTF_DATE_TABLE
387: , p6_a34 out nocopy JTF_NUMBER_TABLE
388: );
389: procedure delete_vp_associations(p_api_version NUMBER
390: , p_init_msg_list VARCHAR2
391: , x_return_status out nocopy VARCHAR2

Line 435: , p5_a0 JTF_NUMBER_TABLE

431: , p_init_msg_list VARCHAR2
432: , x_return_status out nocopy VARCHAR2
433: , x_msg_count out nocopy NUMBER
434: , x_msg_data out nocopy VARCHAR2
435: , p5_a0 JTF_NUMBER_TABLE
436: , p5_a1 JTF_NUMBER_TABLE
437: , p5_a2 JTF_NUMBER_TABLE
438: , p5_a3 JTF_NUMBER_TABLE
439: , p5_a4 JTF_DATE_TABLE

Line 436: , p5_a1 JTF_NUMBER_TABLE

432: , x_return_status out nocopy VARCHAR2
433: , x_msg_count out nocopy NUMBER
434: , x_msg_data out nocopy VARCHAR2
435: , p5_a0 JTF_NUMBER_TABLE
436: , p5_a1 JTF_NUMBER_TABLE
437: , p5_a2 JTF_NUMBER_TABLE
438: , p5_a3 JTF_NUMBER_TABLE
439: , p5_a4 JTF_DATE_TABLE
440: , p5_a5 JTF_DATE_TABLE

Line 437: , p5_a2 JTF_NUMBER_TABLE

433: , x_msg_count out nocopy NUMBER
434: , x_msg_data out nocopy VARCHAR2
435: , p5_a0 JTF_NUMBER_TABLE
436: , p5_a1 JTF_NUMBER_TABLE
437: , p5_a2 JTF_NUMBER_TABLE
438: , p5_a3 JTF_NUMBER_TABLE
439: , p5_a4 JTF_DATE_TABLE
440: , p5_a5 JTF_DATE_TABLE
441: , p5_a6 JTF_VARCHAR2_TABLE_2000

Line 438: , p5_a3 JTF_NUMBER_TABLE

434: , x_msg_data out nocopy VARCHAR2
435: , p5_a0 JTF_NUMBER_TABLE
436: , p5_a1 JTF_NUMBER_TABLE
437: , p5_a2 JTF_NUMBER_TABLE
438: , p5_a3 JTF_NUMBER_TABLE
439: , p5_a4 JTF_DATE_TABLE
440: , p5_a5 JTF_DATE_TABLE
441: , p5_a6 JTF_VARCHAR2_TABLE_2000
442: , p5_a7 JTF_VARCHAR2_TABLE_100

Line 443: , p5_a8 JTF_NUMBER_TABLE

439: , p5_a4 JTF_DATE_TABLE
440: , p5_a5 JTF_DATE_TABLE
441: , p5_a6 JTF_VARCHAR2_TABLE_2000
442: , p5_a7 JTF_VARCHAR2_TABLE_100
443: , p5_a8 JTF_NUMBER_TABLE
444: , p5_a9 JTF_NUMBER_TABLE
445: , p5_a10 JTF_VARCHAR2_TABLE_100
446: , p5_a11 JTF_VARCHAR2_TABLE_500
447: , p5_a12 JTF_VARCHAR2_TABLE_500

Line 444: , p5_a9 JTF_NUMBER_TABLE

440: , p5_a5 JTF_DATE_TABLE
441: , p5_a6 JTF_VARCHAR2_TABLE_2000
442: , p5_a7 JTF_VARCHAR2_TABLE_100
443: , p5_a8 JTF_NUMBER_TABLE
444: , p5_a9 JTF_NUMBER_TABLE
445: , p5_a10 JTF_VARCHAR2_TABLE_100
446: , p5_a11 JTF_VARCHAR2_TABLE_500
447: , p5_a12 JTF_VARCHAR2_TABLE_500
448: , p5_a13 JTF_VARCHAR2_TABLE_500

Line 461: , p5_a26 JTF_NUMBER_TABLE

457: , p5_a22 JTF_VARCHAR2_TABLE_500
458: , p5_a23 JTF_VARCHAR2_TABLE_500
459: , p5_a24 JTF_VARCHAR2_TABLE_500
460: , p5_a25 JTF_VARCHAR2_TABLE_500
461: , p5_a26 JTF_NUMBER_TABLE
462: , p5_a27 JTF_NUMBER_TABLE
463: , p5_a28 JTF_NUMBER_TABLE
464: , p5_a29 JTF_DATE_TABLE
465: , p5_a30 JTF_NUMBER_TABLE

Line 462: , p5_a27 JTF_NUMBER_TABLE

458: , p5_a23 JTF_VARCHAR2_TABLE_500
459: , p5_a24 JTF_VARCHAR2_TABLE_500
460: , p5_a25 JTF_VARCHAR2_TABLE_500
461: , p5_a26 JTF_NUMBER_TABLE
462: , p5_a27 JTF_NUMBER_TABLE
463: , p5_a28 JTF_NUMBER_TABLE
464: , p5_a29 JTF_DATE_TABLE
465: , p5_a30 JTF_NUMBER_TABLE
466: , p5_a31 JTF_DATE_TABLE

Line 463: , p5_a28 JTF_NUMBER_TABLE

459: , p5_a24 JTF_VARCHAR2_TABLE_500
460: , p5_a25 JTF_VARCHAR2_TABLE_500
461: , p5_a26 JTF_NUMBER_TABLE
462: , p5_a27 JTF_NUMBER_TABLE
463: , p5_a28 JTF_NUMBER_TABLE
464: , p5_a29 JTF_DATE_TABLE
465: , p5_a30 JTF_NUMBER_TABLE
466: , p5_a31 JTF_DATE_TABLE
467: , p5_a32 JTF_NUMBER_TABLE

Line 465: , p5_a30 JTF_NUMBER_TABLE

461: , p5_a26 JTF_NUMBER_TABLE
462: , p5_a27 JTF_NUMBER_TABLE
463: , p5_a28 JTF_NUMBER_TABLE
464: , p5_a29 JTF_DATE_TABLE
465: , p5_a30 JTF_NUMBER_TABLE
466: , p5_a31 JTF_DATE_TABLE
467: , p5_a32 JTF_NUMBER_TABLE
468: , p5_a33 JTF_DATE_TABLE
469: , p5_a34 JTF_NUMBER_TABLE

Line 467: , p5_a32 JTF_NUMBER_TABLE

463: , p5_a28 JTF_NUMBER_TABLE
464: , p5_a29 JTF_DATE_TABLE
465: , p5_a30 JTF_NUMBER_TABLE
466: , p5_a31 JTF_DATE_TABLE
467: , p5_a32 JTF_NUMBER_TABLE
468: , p5_a33 JTF_DATE_TABLE
469: , p5_a34 JTF_NUMBER_TABLE
470: );
471: procedure validate_vp_associations(p_api_version NUMBER

Line 469: , p5_a34 JTF_NUMBER_TABLE

465: , p5_a30 JTF_NUMBER_TABLE
466: , p5_a31 JTF_DATE_TABLE
467: , p5_a32 JTF_NUMBER_TABLE
468: , p5_a33 JTF_DATE_TABLE
469: , p5_a34 JTF_NUMBER_TABLE
470: );
471: procedure validate_vp_associations(p_api_version NUMBER
472: , p_init_msg_list VARCHAR2
473: , x_return_status out nocopy VARCHAR2

Line 517: , p5_a0 JTF_NUMBER_TABLE

513: , p_init_msg_list VARCHAR2
514: , x_return_status out nocopy VARCHAR2
515: , x_msg_count out nocopy NUMBER
516: , x_msg_data out nocopy VARCHAR2
517: , p5_a0 JTF_NUMBER_TABLE
518: , p5_a1 JTF_NUMBER_TABLE
519: , p5_a2 JTF_NUMBER_TABLE
520: , p5_a3 JTF_NUMBER_TABLE
521: , p5_a4 JTF_DATE_TABLE

Line 518: , p5_a1 JTF_NUMBER_TABLE

514: , x_return_status out nocopy VARCHAR2
515: , x_msg_count out nocopy NUMBER
516: , x_msg_data out nocopy VARCHAR2
517: , p5_a0 JTF_NUMBER_TABLE
518: , p5_a1 JTF_NUMBER_TABLE
519: , p5_a2 JTF_NUMBER_TABLE
520: , p5_a3 JTF_NUMBER_TABLE
521: , p5_a4 JTF_DATE_TABLE
522: , p5_a5 JTF_DATE_TABLE

Line 519: , p5_a2 JTF_NUMBER_TABLE

515: , x_msg_count out nocopy NUMBER
516: , x_msg_data out nocopy VARCHAR2
517: , p5_a0 JTF_NUMBER_TABLE
518: , p5_a1 JTF_NUMBER_TABLE
519: , p5_a2 JTF_NUMBER_TABLE
520: , p5_a3 JTF_NUMBER_TABLE
521: , p5_a4 JTF_DATE_TABLE
522: , p5_a5 JTF_DATE_TABLE
523: , p5_a6 JTF_VARCHAR2_TABLE_2000

Line 520: , p5_a3 JTF_NUMBER_TABLE

516: , x_msg_data out nocopy VARCHAR2
517: , p5_a0 JTF_NUMBER_TABLE
518: , p5_a1 JTF_NUMBER_TABLE
519: , p5_a2 JTF_NUMBER_TABLE
520: , p5_a3 JTF_NUMBER_TABLE
521: , p5_a4 JTF_DATE_TABLE
522: , p5_a5 JTF_DATE_TABLE
523: , p5_a6 JTF_VARCHAR2_TABLE_2000
524: , p5_a7 JTF_VARCHAR2_TABLE_100

Line 525: , p5_a8 JTF_NUMBER_TABLE

521: , p5_a4 JTF_DATE_TABLE
522: , p5_a5 JTF_DATE_TABLE
523: , p5_a6 JTF_VARCHAR2_TABLE_2000
524: , p5_a7 JTF_VARCHAR2_TABLE_100
525: , p5_a8 JTF_NUMBER_TABLE
526: , p5_a9 JTF_NUMBER_TABLE
527: , p5_a10 JTF_VARCHAR2_TABLE_100
528: , p5_a11 JTF_VARCHAR2_TABLE_500
529: , p5_a12 JTF_VARCHAR2_TABLE_500

Line 526: , p5_a9 JTF_NUMBER_TABLE

522: , p5_a5 JTF_DATE_TABLE
523: , p5_a6 JTF_VARCHAR2_TABLE_2000
524: , p5_a7 JTF_VARCHAR2_TABLE_100
525: , p5_a8 JTF_NUMBER_TABLE
526: , p5_a9 JTF_NUMBER_TABLE
527: , p5_a10 JTF_VARCHAR2_TABLE_100
528: , p5_a11 JTF_VARCHAR2_TABLE_500
529: , p5_a12 JTF_VARCHAR2_TABLE_500
530: , p5_a13 JTF_VARCHAR2_TABLE_500

Line 543: , p5_a26 JTF_NUMBER_TABLE

539: , p5_a22 JTF_VARCHAR2_TABLE_500
540: , p5_a23 JTF_VARCHAR2_TABLE_500
541: , p5_a24 JTF_VARCHAR2_TABLE_500
542: , p5_a25 JTF_VARCHAR2_TABLE_500
543: , p5_a26 JTF_NUMBER_TABLE
544: , p5_a27 JTF_NUMBER_TABLE
545: , p5_a28 JTF_NUMBER_TABLE
546: , p5_a29 JTF_DATE_TABLE
547: , p5_a30 JTF_NUMBER_TABLE

Line 544: , p5_a27 JTF_NUMBER_TABLE

540: , p5_a23 JTF_VARCHAR2_TABLE_500
541: , p5_a24 JTF_VARCHAR2_TABLE_500
542: , p5_a25 JTF_VARCHAR2_TABLE_500
543: , p5_a26 JTF_NUMBER_TABLE
544: , p5_a27 JTF_NUMBER_TABLE
545: , p5_a28 JTF_NUMBER_TABLE
546: , p5_a29 JTF_DATE_TABLE
547: , p5_a30 JTF_NUMBER_TABLE
548: , p5_a31 JTF_DATE_TABLE

Line 545: , p5_a28 JTF_NUMBER_TABLE

541: , p5_a24 JTF_VARCHAR2_TABLE_500
542: , p5_a25 JTF_VARCHAR2_TABLE_500
543: , p5_a26 JTF_NUMBER_TABLE
544: , p5_a27 JTF_NUMBER_TABLE
545: , p5_a28 JTF_NUMBER_TABLE
546: , p5_a29 JTF_DATE_TABLE
547: , p5_a30 JTF_NUMBER_TABLE
548: , p5_a31 JTF_DATE_TABLE
549: , p5_a32 JTF_NUMBER_TABLE

Line 547: , p5_a30 JTF_NUMBER_TABLE

543: , p5_a26 JTF_NUMBER_TABLE
544: , p5_a27 JTF_NUMBER_TABLE
545: , p5_a28 JTF_NUMBER_TABLE
546: , p5_a29 JTF_DATE_TABLE
547: , p5_a30 JTF_NUMBER_TABLE
548: , p5_a31 JTF_DATE_TABLE
549: , p5_a32 JTF_NUMBER_TABLE
550: , p5_a33 JTF_DATE_TABLE
551: , p5_a34 JTF_NUMBER_TABLE

Line 549: , p5_a32 JTF_NUMBER_TABLE

545: , p5_a28 JTF_NUMBER_TABLE
546: , p5_a29 JTF_DATE_TABLE
547: , p5_a30 JTF_NUMBER_TABLE
548: , p5_a31 JTF_DATE_TABLE
549: , p5_a32 JTF_NUMBER_TABLE
550: , p5_a33 JTF_DATE_TABLE
551: , p5_a34 JTF_NUMBER_TABLE
552: );
553: procedure copy_vp_associations(p_api_version NUMBER

Line 551: , p5_a34 JTF_NUMBER_TABLE

547: , p5_a30 JTF_NUMBER_TABLE
548: , p5_a31 JTF_DATE_TABLE
549: , p5_a32 JTF_NUMBER_TABLE
550: , p5_a33 JTF_DATE_TABLE
551: , p5_a34 JTF_NUMBER_TABLE
552: );
553: procedure copy_vp_associations(p_api_version NUMBER
554: , p_init_msg_list VARCHAR2
555: , x_return_status out nocopy VARCHAR2

Line 634: , p5_a0 JTF_NUMBER_TABLE

630: , p_init_msg_list VARCHAR2
631: , x_return_status out nocopy VARCHAR2
632: , x_msg_count out nocopy NUMBER
633: , x_msg_data out nocopy VARCHAR2
634: , p5_a0 JTF_NUMBER_TABLE
635: , p5_a1 JTF_NUMBER_TABLE
636: , p5_a2 JTF_NUMBER_TABLE
637: , p5_a3 JTF_NUMBER_TABLE
638: , p5_a4 JTF_DATE_TABLE

Line 635: , p5_a1 JTF_NUMBER_TABLE

631: , x_return_status out nocopy VARCHAR2
632: , x_msg_count out nocopy NUMBER
633: , x_msg_data out nocopy VARCHAR2
634: , p5_a0 JTF_NUMBER_TABLE
635: , p5_a1 JTF_NUMBER_TABLE
636: , p5_a2 JTF_NUMBER_TABLE
637: , p5_a3 JTF_NUMBER_TABLE
638: , p5_a4 JTF_DATE_TABLE
639: , p5_a5 JTF_DATE_TABLE

Line 636: , p5_a2 JTF_NUMBER_TABLE

632: , x_msg_count out nocopy NUMBER
633: , x_msg_data out nocopy VARCHAR2
634: , p5_a0 JTF_NUMBER_TABLE
635: , p5_a1 JTF_NUMBER_TABLE
636: , p5_a2 JTF_NUMBER_TABLE
637: , p5_a3 JTF_NUMBER_TABLE
638: , p5_a4 JTF_DATE_TABLE
639: , p5_a5 JTF_DATE_TABLE
640: , p5_a6 JTF_VARCHAR2_TABLE_2000

Line 637: , p5_a3 JTF_NUMBER_TABLE

633: , x_msg_data out nocopy VARCHAR2
634: , p5_a0 JTF_NUMBER_TABLE
635: , p5_a1 JTF_NUMBER_TABLE
636: , p5_a2 JTF_NUMBER_TABLE
637: , p5_a3 JTF_NUMBER_TABLE
638: , p5_a4 JTF_DATE_TABLE
639: , p5_a5 JTF_DATE_TABLE
640: , p5_a6 JTF_VARCHAR2_TABLE_2000
641: , p5_a7 JTF_VARCHAR2_TABLE_100

Line 642: , p5_a8 JTF_NUMBER_TABLE

638: , p5_a4 JTF_DATE_TABLE
639: , p5_a5 JTF_DATE_TABLE
640: , p5_a6 JTF_VARCHAR2_TABLE_2000
641: , p5_a7 JTF_VARCHAR2_TABLE_100
642: , p5_a8 JTF_NUMBER_TABLE
643: , p5_a9 JTF_NUMBER_TABLE
644: , p5_a10 JTF_VARCHAR2_TABLE_100
645: , p5_a11 JTF_VARCHAR2_TABLE_500
646: , p5_a12 JTF_VARCHAR2_TABLE_500

Line 643: , p5_a9 JTF_NUMBER_TABLE

639: , p5_a5 JTF_DATE_TABLE
640: , p5_a6 JTF_VARCHAR2_TABLE_2000
641: , p5_a7 JTF_VARCHAR2_TABLE_100
642: , p5_a8 JTF_NUMBER_TABLE
643: , p5_a9 JTF_NUMBER_TABLE
644: , p5_a10 JTF_VARCHAR2_TABLE_100
645: , p5_a11 JTF_VARCHAR2_TABLE_500
646: , p5_a12 JTF_VARCHAR2_TABLE_500
647: , p5_a13 JTF_VARCHAR2_TABLE_500

Line 660: , p5_a26 JTF_NUMBER_TABLE

656: , p5_a22 JTF_VARCHAR2_TABLE_500
657: , p5_a23 JTF_VARCHAR2_TABLE_500
658: , p5_a24 JTF_VARCHAR2_TABLE_500
659: , p5_a25 JTF_VARCHAR2_TABLE_500
660: , p5_a26 JTF_NUMBER_TABLE
661: , p5_a27 JTF_NUMBER_TABLE
662: , p5_a28 JTF_NUMBER_TABLE
663: , p5_a29 JTF_DATE_TABLE
664: , p5_a30 JTF_NUMBER_TABLE

Line 661: , p5_a27 JTF_NUMBER_TABLE

657: , p5_a23 JTF_VARCHAR2_TABLE_500
658: , p5_a24 JTF_VARCHAR2_TABLE_500
659: , p5_a25 JTF_VARCHAR2_TABLE_500
660: , p5_a26 JTF_NUMBER_TABLE
661: , p5_a27 JTF_NUMBER_TABLE
662: , p5_a28 JTF_NUMBER_TABLE
663: , p5_a29 JTF_DATE_TABLE
664: , p5_a30 JTF_NUMBER_TABLE
665: , p5_a31 JTF_DATE_TABLE

Line 662: , p5_a28 JTF_NUMBER_TABLE

658: , p5_a24 JTF_VARCHAR2_TABLE_500
659: , p5_a25 JTF_VARCHAR2_TABLE_500
660: , p5_a26 JTF_NUMBER_TABLE
661: , p5_a27 JTF_NUMBER_TABLE
662: , p5_a28 JTF_NUMBER_TABLE
663: , p5_a29 JTF_DATE_TABLE
664: , p5_a30 JTF_NUMBER_TABLE
665: , p5_a31 JTF_DATE_TABLE
666: , p5_a32 JTF_NUMBER_TABLE

Line 664: , p5_a30 JTF_NUMBER_TABLE

660: , p5_a26 JTF_NUMBER_TABLE
661: , p5_a27 JTF_NUMBER_TABLE
662: , p5_a28 JTF_NUMBER_TABLE
663: , p5_a29 JTF_DATE_TABLE
664: , p5_a30 JTF_NUMBER_TABLE
665: , p5_a31 JTF_DATE_TABLE
666: , p5_a32 JTF_NUMBER_TABLE
667: , p5_a33 JTF_DATE_TABLE
668: , p5_a34 JTF_NUMBER_TABLE

Line 666: , p5_a32 JTF_NUMBER_TABLE

662: , p5_a28 JTF_NUMBER_TABLE
663: , p5_a29 JTF_DATE_TABLE
664: , p5_a30 JTF_NUMBER_TABLE
665: , p5_a31 JTF_DATE_TABLE
666: , p5_a32 JTF_NUMBER_TABLE
667: , p5_a33 JTF_DATE_TABLE
668: , p5_a34 JTF_NUMBER_TABLE
669: , p6_a0 out nocopy JTF_NUMBER_TABLE
670: , p6_a1 out nocopy JTF_NUMBER_TABLE

Line 668: , p5_a34 JTF_NUMBER_TABLE

664: , p5_a30 JTF_NUMBER_TABLE
665: , p5_a31 JTF_DATE_TABLE
666: , p5_a32 JTF_NUMBER_TABLE
667: , p5_a33 JTF_DATE_TABLE
668: , p5_a34 JTF_NUMBER_TABLE
669: , p6_a0 out nocopy JTF_NUMBER_TABLE
670: , p6_a1 out nocopy JTF_NUMBER_TABLE
671: , p6_a2 out nocopy JTF_NUMBER_TABLE
672: , p6_a3 out nocopy JTF_NUMBER_TABLE

Line 669: , p6_a0 out nocopy JTF_NUMBER_TABLE

665: , p5_a31 JTF_DATE_TABLE
666: , p5_a32 JTF_NUMBER_TABLE
667: , p5_a33 JTF_DATE_TABLE
668: , p5_a34 JTF_NUMBER_TABLE
669: , p6_a0 out nocopy JTF_NUMBER_TABLE
670: , p6_a1 out nocopy JTF_NUMBER_TABLE
671: , p6_a2 out nocopy JTF_NUMBER_TABLE
672: , p6_a3 out nocopy JTF_NUMBER_TABLE
673: , p6_a4 out nocopy JTF_DATE_TABLE

Line 670: , p6_a1 out nocopy JTF_NUMBER_TABLE

666: , p5_a32 JTF_NUMBER_TABLE
667: , p5_a33 JTF_DATE_TABLE
668: , p5_a34 JTF_NUMBER_TABLE
669: , p6_a0 out nocopy JTF_NUMBER_TABLE
670: , p6_a1 out nocopy JTF_NUMBER_TABLE
671: , p6_a2 out nocopy JTF_NUMBER_TABLE
672: , p6_a3 out nocopy JTF_NUMBER_TABLE
673: , p6_a4 out nocopy JTF_DATE_TABLE
674: , p6_a5 out nocopy JTF_DATE_TABLE

Line 671: , p6_a2 out nocopy JTF_NUMBER_TABLE

667: , p5_a33 JTF_DATE_TABLE
668: , p5_a34 JTF_NUMBER_TABLE
669: , p6_a0 out nocopy JTF_NUMBER_TABLE
670: , p6_a1 out nocopy JTF_NUMBER_TABLE
671: , p6_a2 out nocopy JTF_NUMBER_TABLE
672: , p6_a3 out nocopy JTF_NUMBER_TABLE
673: , p6_a4 out nocopy JTF_DATE_TABLE
674: , p6_a5 out nocopy JTF_DATE_TABLE
675: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000

Line 672: , p6_a3 out nocopy JTF_NUMBER_TABLE

668: , p5_a34 JTF_NUMBER_TABLE
669: , p6_a0 out nocopy JTF_NUMBER_TABLE
670: , p6_a1 out nocopy JTF_NUMBER_TABLE
671: , p6_a2 out nocopy JTF_NUMBER_TABLE
672: , p6_a3 out nocopy JTF_NUMBER_TABLE
673: , p6_a4 out nocopy JTF_DATE_TABLE
674: , p6_a5 out nocopy JTF_DATE_TABLE
675: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000
676: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100

Line 677: , p6_a8 out nocopy JTF_NUMBER_TABLE

673: , p6_a4 out nocopy JTF_DATE_TABLE
674: , p6_a5 out nocopy JTF_DATE_TABLE
675: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000
676: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
677: , p6_a8 out nocopy JTF_NUMBER_TABLE
678: , p6_a9 out nocopy JTF_NUMBER_TABLE
679: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
680: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_500
681: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_500

Line 678: , p6_a9 out nocopy JTF_NUMBER_TABLE

674: , p6_a5 out nocopy JTF_DATE_TABLE
675: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000
676: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
677: , p6_a8 out nocopy JTF_NUMBER_TABLE
678: , p6_a9 out nocopy JTF_NUMBER_TABLE
679: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
680: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_500
681: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_500
682: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_500

Line 695: , p6_a26 out nocopy JTF_NUMBER_TABLE

691: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
692: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
693: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
694: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
695: , p6_a26 out nocopy JTF_NUMBER_TABLE
696: , p6_a27 out nocopy JTF_NUMBER_TABLE
697: , p6_a28 out nocopy JTF_NUMBER_TABLE
698: , p6_a29 out nocopy JTF_DATE_TABLE
699: , p6_a30 out nocopy JTF_NUMBER_TABLE

Line 696: , p6_a27 out nocopy JTF_NUMBER_TABLE

692: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
693: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
694: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
695: , p6_a26 out nocopy JTF_NUMBER_TABLE
696: , p6_a27 out nocopy JTF_NUMBER_TABLE
697: , p6_a28 out nocopy JTF_NUMBER_TABLE
698: , p6_a29 out nocopy JTF_DATE_TABLE
699: , p6_a30 out nocopy JTF_NUMBER_TABLE
700: , p6_a31 out nocopy JTF_DATE_TABLE

Line 697: , p6_a28 out nocopy JTF_NUMBER_TABLE

693: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
694: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
695: , p6_a26 out nocopy JTF_NUMBER_TABLE
696: , p6_a27 out nocopy JTF_NUMBER_TABLE
697: , p6_a28 out nocopy JTF_NUMBER_TABLE
698: , p6_a29 out nocopy JTF_DATE_TABLE
699: , p6_a30 out nocopy JTF_NUMBER_TABLE
700: , p6_a31 out nocopy JTF_DATE_TABLE
701: , p6_a32 out nocopy JTF_NUMBER_TABLE

Line 699: , p6_a30 out nocopy JTF_NUMBER_TABLE

695: , p6_a26 out nocopy JTF_NUMBER_TABLE
696: , p6_a27 out nocopy JTF_NUMBER_TABLE
697: , p6_a28 out nocopy JTF_NUMBER_TABLE
698: , p6_a29 out nocopy JTF_DATE_TABLE
699: , p6_a30 out nocopy JTF_NUMBER_TABLE
700: , p6_a31 out nocopy JTF_DATE_TABLE
701: , p6_a32 out nocopy JTF_NUMBER_TABLE
702: , p6_a33 out nocopy JTF_DATE_TABLE
703: , p6_a34 out nocopy JTF_NUMBER_TABLE

Line 701: , p6_a32 out nocopy JTF_NUMBER_TABLE

697: , p6_a28 out nocopy JTF_NUMBER_TABLE
698: , p6_a29 out nocopy JTF_DATE_TABLE
699: , p6_a30 out nocopy JTF_NUMBER_TABLE
700: , p6_a31 out nocopy JTF_DATE_TABLE
701: , p6_a32 out nocopy JTF_NUMBER_TABLE
702: , p6_a33 out nocopy JTF_DATE_TABLE
703: , p6_a34 out nocopy JTF_NUMBER_TABLE
704: );
705: end okl_vp_associations_pvt_w;

Line 703: , p6_a34 out nocopy JTF_NUMBER_TABLE

699: , p6_a30 out nocopy JTF_NUMBER_TABLE
700: , p6_a31 out nocopy JTF_DATE_TABLE
701: , p6_a32 out nocopy JTF_NUMBER_TABLE
702: , p6_a33 out nocopy JTF_DATE_TABLE
703: , p6_a34 out nocopy JTF_NUMBER_TABLE
704: );
705: end okl_vp_associations_pvt_w;