DBA Data[Home] [Help]

APPS.OKL_PROVISIONS_PUB_W dependencies on JTF_NUMBER_TABLE

Line 80: , p5_a0 JTF_NUMBER_TABLE

76: , p_init_msg_list VARCHAR2
77: , x_return_status out nocopy VARCHAR2
78: , x_msg_count out nocopy NUMBER
79: , x_msg_data out nocopy VARCHAR2
80: , p5_a0 JTF_NUMBER_TABLE
81: , p5_a1 JTF_NUMBER_TABLE
82: , p5_a2 JTF_NUMBER_TABLE
83: , p5_a3 JTF_NUMBER_TABLE
84: , p5_a4 JTF_NUMBER_TABLE

Line 81: , p5_a1 JTF_NUMBER_TABLE

77: , x_return_status out nocopy VARCHAR2
78: , x_msg_count out nocopy NUMBER
79: , x_msg_data out nocopy VARCHAR2
80: , p5_a0 JTF_NUMBER_TABLE
81: , p5_a1 JTF_NUMBER_TABLE
82: , p5_a2 JTF_NUMBER_TABLE
83: , p5_a3 JTF_NUMBER_TABLE
84: , p5_a4 JTF_NUMBER_TABLE
85: , p5_a5 JTF_NUMBER_TABLE

Line 82: , p5_a2 JTF_NUMBER_TABLE

78: , x_msg_count out nocopy NUMBER
79: , x_msg_data out nocopy VARCHAR2
80: , p5_a0 JTF_NUMBER_TABLE
81: , p5_a1 JTF_NUMBER_TABLE
82: , p5_a2 JTF_NUMBER_TABLE
83: , p5_a3 JTF_NUMBER_TABLE
84: , p5_a4 JTF_NUMBER_TABLE
85: , p5_a5 JTF_NUMBER_TABLE
86: , p5_a6 JTF_NUMBER_TABLE

Line 83: , p5_a3 JTF_NUMBER_TABLE

79: , x_msg_data out nocopy VARCHAR2
80: , p5_a0 JTF_NUMBER_TABLE
81: , p5_a1 JTF_NUMBER_TABLE
82: , p5_a2 JTF_NUMBER_TABLE
83: , p5_a3 JTF_NUMBER_TABLE
84: , p5_a4 JTF_NUMBER_TABLE
85: , p5_a5 JTF_NUMBER_TABLE
86: , p5_a6 JTF_NUMBER_TABLE
87: , p5_a7 JTF_VARCHAR2_TABLE_200

Line 84: , p5_a4 JTF_NUMBER_TABLE

80: , p5_a0 JTF_NUMBER_TABLE
81: , p5_a1 JTF_NUMBER_TABLE
82: , p5_a2 JTF_NUMBER_TABLE
83: , p5_a3 JTF_NUMBER_TABLE
84: , p5_a4 JTF_NUMBER_TABLE
85: , p5_a5 JTF_NUMBER_TABLE
86: , p5_a6 JTF_NUMBER_TABLE
87: , p5_a7 JTF_VARCHAR2_TABLE_200
88: , p5_a8 JTF_VARCHAR2_TABLE_2000

Line 85: , p5_a5 JTF_NUMBER_TABLE

81: , p5_a1 JTF_NUMBER_TABLE
82: , p5_a2 JTF_NUMBER_TABLE
83: , p5_a3 JTF_NUMBER_TABLE
84: , p5_a4 JTF_NUMBER_TABLE
85: , p5_a5 JTF_NUMBER_TABLE
86: , p5_a6 JTF_NUMBER_TABLE
87: , p5_a7 JTF_VARCHAR2_TABLE_200
88: , p5_a8 JTF_VARCHAR2_TABLE_2000
89: , p5_a9 JTF_VARCHAR2_TABLE_100

Line 86: , p5_a6 JTF_NUMBER_TABLE

82: , p5_a2 JTF_NUMBER_TABLE
83: , p5_a3 JTF_NUMBER_TABLE
84: , p5_a4 JTF_NUMBER_TABLE
85: , p5_a5 JTF_NUMBER_TABLE
86: , p5_a6 JTF_NUMBER_TABLE
87: , p5_a7 JTF_VARCHAR2_TABLE_200
88: , p5_a8 JTF_VARCHAR2_TABLE_2000
89: , p5_a9 JTF_VARCHAR2_TABLE_100
90: , p5_a10 JTF_VARCHAR2_TABLE_500

Line 108: , p5_a28 JTF_NUMBER_TABLE

104: , p5_a24 JTF_VARCHAR2_TABLE_500
105: , p5_a25 JTF_VARCHAR2_TABLE_100
106: , p5_a26 JTF_DATE_TABLE
107: , p5_a27 JTF_DATE_TABLE
108: , p5_a28 JTF_NUMBER_TABLE
109: , p5_a29 JTF_DATE_TABLE
110: , p5_a30 JTF_NUMBER_TABLE
111: , p5_a31 JTF_DATE_TABLE
112: , p5_a32 JTF_NUMBER_TABLE

Line 110: , p5_a30 JTF_NUMBER_TABLE

106: , p5_a26 JTF_DATE_TABLE
107: , p5_a27 JTF_DATE_TABLE
108: , p5_a28 JTF_NUMBER_TABLE
109: , p5_a29 JTF_DATE_TABLE
110: , p5_a30 JTF_NUMBER_TABLE
111: , p5_a31 JTF_DATE_TABLE
112: , p5_a32 JTF_NUMBER_TABLE
113: , p6_a0 out nocopy JTF_NUMBER_TABLE
114: , p6_a1 out nocopy JTF_NUMBER_TABLE

Line 112: , p5_a32 JTF_NUMBER_TABLE

108: , p5_a28 JTF_NUMBER_TABLE
109: , p5_a29 JTF_DATE_TABLE
110: , p5_a30 JTF_NUMBER_TABLE
111: , p5_a31 JTF_DATE_TABLE
112: , p5_a32 JTF_NUMBER_TABLE
113: , p6_a0 out nocopy JTF_NUMBER_TABLE
114: , p6_a1 out nocopy JTF_NUMBER_TABLE
115: , p6_a2 out nocopy JTF_NUMBER_TABLE
116: , p6_a3 out nocopy JTF_NUMBER_TABLE

Line 113: , p6_a0 out nocopy JTF_NUMBER_TABLE

109: , p5_a29 JTF_DATE_TABLE
110: , p5_a30 JTF_NUMBER_TABLE
111: , p5_a31 JTF_DATE_TABLE
112: , p5_a32 JTF_NUMBER_TABLE
113: , p6_a0 out nocopy JTF_NUMBER_TABLE
114: , p6_a1 out nocopy JTF_NUMBER_TABLE
115: , p6_a2 out nocopy JTF_NUMBER_TABLE
116: , p6_a3 out nocopy JTF_NUMBER_TABLE
117: , p6_a4 out nocopy JTF_NUMBER_TABLE

Line 114: , p6_a1 out nocopy JTF_NUMBER_TABLE

110: , p5_a30 JTF_NUMBER_TABLE
111: , p5_a31 JTF_DATE_TABLE
112: , p5_a32 JTF_NUMBER_TABLE
113: , p6_a0 out nocopy JTF_NUMBER_TABLE
114: , p6_a1 out nocopy JTF_NUMBER_TABLE
115: , p6_a2 out nocopy JTF_NUMBER_TABLE
116: , p6_a3 out nocopy JTF_NUMBER_TABLE
117: , p6_a4 out nocopy JTF_NUMBER_TABLE
118: , p6_a5 out nocopy JTF_NUMBER_TABLE

Line 115: , p6_a2 out nocopy JTF_NUMBER_TABLE

111: , p5_a31 JTF_DATE_TABLE
112: , p5_a32 JTF_NUMBER_TABLE
113: , p6_a0 out nocopy JTF_NUMBER_TABLE
114: , p6_a1 out nocopy JTF_NUMBER_TABLE
115: , p6_a2 out nocopy JTF_NUMBER_TABLE
116: , p6_a3 out nocopy JTF_NUMBER_TABLE
117: , p6_a4 out nocopy JTF_NUMBER_TABLE
118: , p6_a5 out nocopy JTF_NUMBER_TABLE
119: , p6_a6 out nocopy JTF_NUMBER_TABLE

Line 116: , p6_a3 out nocopy JTF_NUMBER_TABLE

112: , p5_a32 JTF_NUMBER_TABLE
113: , p6_a0 out nocopy JTF_NUMBER_TABLE
114: , p6_a1 out nocopy JTF_NUMBER_TABLE
115: , p6_a2 out nocopy JTF_NUMBER_TABLE
116: , p6_a3 out nocopy JTF_NUMBER_TABLE
117: , p6_a4 out nocopy JTF_NUMBER_TABLE
118: , p6_a5 out nocopy JTF_NUMBER_TABLE
119: , p6_a6 out nocopy JTF_NUMBER_TABLE
120: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_200

Line 117: , p6_a4 out nocopy JTF_NUMBER_TABLE

113: , p6_a0 out nocopy JTF_NUMBER_TABLE
114: , p6_a1 out nocopy JTF_NUMBER_TABLE
115: , p6_a2 out nocopy JTF_NUMBER_TABLE
116: , p6_a3 out nocopy JTF_NUMBER_TABLE
117: , p6_a4 out nocopy JTF_NUMBER_TABLE
118: , p6_a5 out nocopy JTF_NUMBER_TABLE
119: , p6_a6 out nocopy JTF_NUMBER_TABLE
120: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_200
121: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_2000

Line 118: , p6_a5 out nocopy JTF_NUMBER_TABLE

114: , p6_a1 out nocopy JTF_NUMBER_TABLE
115: , p6_a2 out nocopy JTF_NUMBER_TABLE
116: , p6_a3 out nocopy JTF_NUMBER_TABLE
117: , p6_a4 out nocopy JTF_NUMBER_TABLE
118: , p6_a5 out nocopy JTF_NUMBER_TABLE
119: , p6_a6 out nocopy JTF_NUMBER_TABLE
120: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_200
121: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_2000
122: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100

Line 119: , p6_a6 out nocopy JTF_NUMBER_TABLE

115: , p6_a2 out nocopy JTF_NUMBER_TABLE
116: , p6_a3 out nocopy JTF_NUMBER_TABLE
117: , p6_a4 out nocopy JTF_NUMBER_TABLE
118: , p6_a5 out nocopy JTF_NUMBER_TABLE
119: , p6_a6 out nocopy JTF_NUMBER_TABLE
120: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_200
121: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_2000
122: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
123: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_500

Line 141: , p6_a28 out nocopy JTF_NUMBER_TABLE

137: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
138: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_100
139: , p6_a26 out nocopy JTF_DATE_TABLE
140: , p6_a27 out nocopy JTF_DATE_TABLE
141: , p6_a28 out nocopy JTF_NUMBER_TABLE
142: , p6_a29 out nocopy JTF_DATE_TABLE
143: , p6_a30 out nocopy JTF_NUMBER_TABLE
144: , p6_a31 out nocopy JTF_DATE_TABLE
145: , p6_a32 out nocopy JTF_NUMBER_TABLE

Line 143: , p6_a30 out nocopy JTF_NUMBER_TABLE

139: , p6_a26 out nocopy JTF_DATE_TABLE
140: , p6_a27 out nocopy JTF_DATE_TABLE
141: , p6_a28 out nocopy JTF_NUMBER_TABLE
142: , p6_a29 out nocopy JTF_DATE_TABLE
143: , p6_a30 out nocopy JTF_NUMBER_TABLE
144: , p6_a31 out nocopy JTF_DATE_TABLE
145: , p6_a32 out nocopy JTF_NUMBER_TABLE
146: );
147: procedure lock_provisions(p_api_version NUMBER

Line 145: , p6_a32 out nocopy JTF_NUMBER_TABLE

141: , p6_a28 out nocopy JTF_NUMBER_TABLE
142: , p6_a29 out nocopy JTF_DATE_TABLE
143: , p6_a30 out nocopy JTF_NUMBER_TABLE
144: , p6_a31 out nocopy JTF_DATE_TABLE
145: , p6_a32 out nocopy JTF_NUMBER_TABLE
146: );
147: procedure lock_provisions(p_api_version NUMBER
148: , p_init_msg_list VARCHAR2
149: , x_return_status out nocopy VARCHAR2

Line 191: , p5_a0 JTF_NUMBER_TABLE

187: , p_init_msg_list VARCHAR2
188: , x_return_status out nocopy VARCHAR2
189: , x_msg_count out nocopy NUMBER
190: , x_msg_data out nocopy VARCHAR2
191: , p5_a0 JTF_NUMBER_TABLE
192: , p5_a1 JTF_NUMBER_TABLE
193: , p5_a2 JTF_NUMBER_TABLE
194: , p5_a3 JTF_NUMBER_TABLE
195: , p5_a4 JTF_NUMBER_TABLE

Line 192: , p5_a1 JTF_NUMBER_TABLE

188: , x_return_status out nocopy VARCHAR2
189: , x_msg_count out nocopy NUMBER
190: , x_msg_data out nocopy VARCHAR2
191: , p5_a0 JTF_NUMBER_TABLE
192: , p5_a1 JTF_NUMBER_TABLE
193: , p5_a2 JTF_NUMBER_TABLE
194: , p5_a3 JTF_NUMBER_TABLE
195: , p5_a4 JTF_NUMBER_TABLE
196: , p5_a5 JTF_NUMBER_TABLE

Line 193: , p5_a2 JTF_NUMBER_TABLE

189: , x_msg_count out nocopy NUMBER
190: , x_msg_data out nocopy VARCHAR2
191: , p5_a0 JTF_NUMBER_TABLE
192: , p5_a1 JTF_NUMBER_TABLE
193: , p5_a2 JTF_NUMBER_TABLE
194: , p5_a3 JTF_NUMBER_TABLE
195: , p5_a4 JTF_NUMBER_TABLE
196: , p5_a5 JTF_NUMBER_TABLE
197: , p5_a6 JTF_NUMBER_TABLE

Line 194: , p5_a3 JTF_NUMBER_TABLE

190: , x_msg_data out nocopy VARCHAR2
191: , p5_a0 JTF_NUMBER_TABLE
192: , p5_a1 JTF_NUMBER_TABLE
193: , p5_a2 JTF_NUMBER_TABLE
194: , p5_a3 JTF_NUMBER_TABLE
195: , p5_a4 JTF_NUMBER_TABLE
196: , p5_a5 JTF_NUMBER_TABLE
197: , p5_a6 JTF_NUMBER_TABLE
198: , p5_a7 JTF_VARCHAR2_TABLE_200

Line 195: , p5_a4 JTF_NUMBER_TABLE

191: , p5_a0 JTF_NUMBER_TABLE
192: , p5_a1 JTF_NUMBER_TABLE
193: , p5_a2 JTF_NUMBER_TABLE
194: , p5_a3 JTF_NUMBER_TABLE
195: , p5_a4 JTF_NUMBER_TABLE
196: , p5_a5 JTF_NUMBER_TABLE
197: , p5_a6 JTF_NUMBER_TABLE
198: , p5_a7 JTF_VARCHAR2_TABLE_200
199: , p5_a8 JTF_VARCHAR2_TABLE_2000

Line 196: , p5_a5 JTF_NUMBER_TABLE

192: , p5_a1 JTF_NUMBER_TABLE
193: , p5_a2 JTF_NUMBER_TABLE
194: , p5_a3 JTF_NUMBER_TABLE
195: , p5_a4 JTF_NUMBER_TABLE
196: , p5_a5 JTF_NUMBER_TABLE
197: , p5_a6 JTF_NUMBER_TABLE
198: , p5_a7 JTF_VARCHAR2_TABLE_200
199: , p5_a8 JTF_VARCHAR2_TABLE_2000
200: , p5_a9 JTF_VARCHAR2_TABLE_100

Line 197: , p5_a6 JTF_NUMBER_TABLE

193: , p5_a2 JTF_NUMBER_TABLE
194: , p5_a3 JTF_NUMBER_TABLE
195: , p5_a4 JTF_NUMBER_TABLE
196: , p5_a5 JTF_NUMBER_TABLE
197: , p5_a6 JTF_NUMBER_TABLE
198: , p5_a7 JTF_VARCHAR2_TABLE_200
199: , p5_a8 JTF_VARCHAR2_TABLE_2000
200: , p5_a9 JTF_VARCHAR2_TABLE_100
201: , p5_a10 JTF_VARCHAR2_TABLE_500

Line 219: , p5_a28 JTF_NUMBER_TABLE

215: , p5_a24 JTF_VARCHAR2_TABLE_500
216: , p5_a25 JTF_VARCHAR2_TABLE_100
217: , p5_a26 JTF_DATE_TABLE
218: , p5_a27 JTF_DATE_TABLE
219: , p5_a28 JTF_NUMBER_TABLE
220: , p5_a29 JTF_DATE_TABLE
221: , p5_a30 JTF_NUMBER_TABLE
222: , p5_a31 JTF_DATE_TABLE
223: , p5_a32 JTF_NUMBER_TABLE

Line 221: , p5_a30 JTF_NUMBER_TABLE

217: , p5_a26 JTF_DATE_TABLE
218: , p5_a27 JTF_DATE_TABLE
219: , p5_a28 JTF_NUMBER_TABLE
220: , p5_a29 JTF_DATE_TABLE
221: , p5_a30 JTF_NUMBER_TABLE
222: , p5_a31 JTF_DATE_TABLE
223: , p5_a32 JTF_NUMBER_TABLE
224: );
225: procedure update_provisions(p_api_version NUMBER

Line 223: , p5_a32 JTF_NUMBER_TABLE

219: , p5_a28 JTF_NUMBER_TABLE
220: , p5_a29 JTF_DATE_TABLE
221: , p5_a30 JTF_NUMBER_TABLE
222: , p5_a31 JTF_DATE_TABLE
223: , p5_a32 JTF_NUMBER_TABLE
224: );
225: procedure update_provisions(p_api_version NUMBER
226: , p_init_msg_list VARCHAR2
227: , x_return_status out nocopy VARCHAR2

Line 302: , p5_a0 JTF_NUMBER_TABLE

298: , p_init_msg_list VARCHAR2
299: , x_return_status out nocopy VARCHAR2
300: , x_msg_count out nocopy NUMBER
301: , x_msg_data out nocopy VARCHAR2
302: , p5_a0 JTF_NUMBER_TABLE
303: , p5_a1 JTF_NUMBER_TABLE
304: , p5_a2 JTF_NUMBER_TABLE
305: , p5_a3 JTF_NUMBER_TABLE
306: , p5_a4 JTF_NUMBER_TABLE

Line 303: , p5_a1 JTF_NUMBER_TABLE

299: , x_return_status out nocopy VARCHAR2
300: , x_msg_count out nocopy NUMBER
301: , x_msg_data out nocopy VARCHAR2
302: , p5_a0 JTF_NUMBER_TABLE
303: , p5_a1 JTF_NUMBER_TABLE
304: , p5_a2 JTF_NUMBER_TABLE
305: , p5_a3 JTF_NUMBER_TABLE
306: , p5_a4 JTF_NUMBER_TABLE
307: , p5_a5 JTF_NUMBER_TABLE

Line 304: , p5_a2 JTF_NUMBER_TABLE

300: , x_msg_count out nocopy NUMBER
301: , x_msg_data out nocopy VARCHAR2
302: , p5_a0 JTF_NUMBER_TABLE
303: , p5_a1 JTF_NUMBER_TABLE
304: , p5_a2 JTF_NUMBER_TABLE
305: , p5_a3 JTF_NUMBER_TABLE
306: , p5_a4 JTF_NUMBER_TABLE
307: , p5_a5 JTF_NUMBER_TABLE
308: , p5_a6 JTF_NUMBER_TABLE

Line 305: , p5_a3 JTF_NUMBER_TABLE

301: , x_msg_data out nocopy VARCHAR2
302: , p5_a0 JTF_NUMBER_TABLE
303: , p5_a1 JTF_NUMBER_TABLE
304: , p5_a2 JTF_NUMBER_TABLE
305: , p5_a3 JTF_NUMBER_TABLE
306: , p5_a4 JTF_NUMBER_TABLE
307: , p5_a5 JTF_NUMBER_TABLE
308: , p5_a6 JTF_NUMBER_TABLE
309: , p5_a7 JTF_VARCHAR2_TABLE_200

Line 306: , p5_a4 JTF_NUMBER_TABLE

302: , p5_a0 JTF_NUMBER_TABLE
303: , p5_a1 JTF_NUMBER_TABLE
304: , p5_a2 JTF_NUMBER_TABLE
305: , p5_a3 JTF_NUMBER_TABLE
306: , p5_a4 JTF_NUMBER_TABLE
307: , p5_a5 JTF_NUMBER_TABLE
308: , p5_a6 JTF_NUMBER_TABLE
309: , p5_a7 JTF_VARCHAR2_TABLE_200
310: , p5_a8 JTF_VARCHAR2_TABLE_2000

Line 307: , p5_a5 JTF_NUMBER_TABLE

303: , p5_a1 JTF_NUMBER_TABLE
304: , p5_a2 JTF_NUMBER_TABLE
305: , p5_a3 JTF_NUMBER_TABLE
306: , p5_a4 JTF_NUMBER_TABLE
307: , p5_a5 JTF_NUMBER_TABLE
308: , p5_a6 JTF_NUMBER_TABLE
309: , p5_a7 JTF_VARCHAR2_TABLE_200
310: , p5_a8 JTF_VARCHAR2_TABLE_2000
311: , p5_a9 JTF_VARCHAR2_TABLE_100

Line 308: , p5_a6 JTF_NUMBER_TABLE

304: , p5_a2 JTF_NUMBER_TABLE
305: , p5_a3 JTF_NUMBER_TABLE
306: , p5_a4 JTF_NUMBER_TABLE
307: , p5_a5 JTF_NUMBER_TABLE
308: , p5_a6 JTF_NUMBER_TABLE
309: , p5_a7 JTF_VARCHAR2_TABLE_200
310: , p5_a8 JTF_VARCHAR2_TABLE_2000
311: , p5_a9 JTF_VARCHAR2_TABLE_100
312: , p5_a10 JTF_VARCHAR2_TABLE_500

Line 330: , p5_a28 JTF_NUMBER_TABLE

326: , p5_a24 JTF_VARCHAR2_TABLE_500
327: , p5_a25 JTF_VARCHAR2_TABLE_100
328: , p5_a26 JTF_DATE_TABLE
329: , p5_a27 JTF_DATE_TABLE
330: , p5_a28 JTF_NUMBER_TABLE
331: , p5_a29 JTF_DATE_TABLE
332: , p5_a30 JTF_NUMBER_TABLE
333: , p5_a31 JTF_DATE_TABLE
334: , p5_a32 JTF_NUMBER_TABLE

Line 332: , p5_a30 JTF_NUMBER_TABLE

328: , p5_a26 JTF_DATE_TABLE
329: , p5_a27 JTF_DATE_TABLE
330: , p5_a28 JTF_NUMBER_TABLE
331: , p5_a29 JTF_DATE_TABLE
332: , p5_a30 JTF_NUMBER_TABLE
333: , p5_a31 JTF_DATE_TABLE
334: , p5_a32 JTF_NUMBER_TABLE
335: , p6_a0 out nocopy JTF_NUMBER_TABLE
336: , p6_a1 out nocopy JTF_NUMBER_TABLE

Line 334: , p5_a32 JTF_NUMBER_TABLE

330: , p5_a28 JTF_NUMBER_TABLE
331: , p5_a29 JTF_DATE_TABLE
332: , p5_a30 JTF_NUMBER_TABLE
333: , p5_a31 JTF_DATE_TABLE
334: , p5_a32 JTF_NUMBER_TABLE
335: , p6_a0 out nocopy JTF_NUMBER_TABLE
336: , p6_a1 out nocopy JTF_NUMBER_TABLE
337: , p6_a2 out nocopy JTF_NUMBER_TABLE
338: , p6_a3 out nocopy JTF_NUMBER_TABLE

Line 335: , p6_a0 out nocopy JTF_NUMBER_TABLE

331: , p5_a29 JTF_DATE_TABLE
332: , p5_a30 JTF_NUMBER_TABLE
333: , p5_a31 JTF_DATE_TABLE
334: , p5_a32 JTF_NUMBER_TABLE
335: , p6_a0 out nocopy JTF_NUMBER_TABLE
336: , p6_a1 out nocopy JTF_NUMBER_TABLE
337: , p6_a2 out nocopy JTF_NUMBER_TABLE
338: , p6_a3 out nocopy JTF_NUMBER_TABLE
339: , p6_a4 out nocopy JTF_NUMBER_TABLE

Line 336: , p6_a1 out nocopy JTF_NUMBER_TABLE

332: , p5_a30 JTF_NUMBER_TABLE
333: , p5_a31 JTF_DATE_TABLE
334: , p5_a32 JTF_NUMBER_TABLE
335: , p6_a0 out nocopy JTF_NUMBER_TABLE
336: , p6_a1 out nocopy JTF_NUMBER_TABLE
337: , p6_a2 out nocopy JTF_NUMBER_TABLE
338: , p6_a3 out nocopy JTF_NUMBER_TABLE
339: , p6_a4 out nocopy JTF_NUMBER_TABLE
340: , p6_a5 out nocopy JTF_NUMBER_TABLE

Line 337: , p6_a2 out nocopy JTF_NUMBER_TABLE

333: , p5_a31 JTF_DATE_TABLE
334: , p5_a32 JTF_NUMBER_TABLE
335: , p6_a0 out nocopy JTF_NUMBER_TABLE
336: , p6_a1 out nocopy JTF_NUMBER_TABLE
337: , p6_a2 out nocopy JTF_NUMBER_TABLE
338: , p6_a3 out nocopy JTF_NUMBER_TABLE
339: , p6_a4 out nocopy JTF_NUMBER_TABLE
340: , p6_a5 out nocopy JTF_NUMBER_TABLE
341: , p6_a6 out nocopy JTF_NUMBER_TABLE

Line 338: , p6_a3 out nocopy JTF_NUMBER_TABLE

334: , p5_a32 JTF_NUMBER_TABLE
335: , p6_a0 out nocopy JTF_NUMBER_TABLE
336: , p6_a1 out nocopy JTF_NUMBER_TABLE
337: , p6_a2 out nocopy JTF_NUMBER_TABLE
338: , p6_a3 out nocopy JTF_NUMBER_TABLE
339: , p6_a4 out nocopy JTF_NUMBER_TABLE
340: , p6_a5 out nocopy JTF_NUMBER_TABLE
341: , p6_a6 out nocopy JTF_NUMBER_TABLE
342: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_200

Line 339: , p6_a4 out nocopy JTF_NUMBER_TABLE

335: , p6_a0 out nocopy JTF_NUMBER_TABLE
336: , p6_a1 out nocopy JTF_NUMBER_TABLE
337: , p6_a2 out nocopy JTF_NUMBER_TABLE
338: , p6_a3 out nocopy JTF_NUMBER_TABLE
339: , p6_a4 out nocopy JTF_NUMBER_TABLE
340: , p6_a5 out nocopy JTF_NUMBER_TABLE
341: , p6_a6 out nocopy JTF_NUMBER_TABLE
342: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_200
343: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_2000

Line 340: , p6_a5 out nocopy JTF_NUMBER_TABLE

336: , p6_a1 out nocopy JTF_NUMBER_TABLE
337: , p6_a2 out nocopy JTF_NUMBER_TABLE
338: , p6_a3 out nocopy JTF_NUMBER_TABLE
339: , p6_a4 out nocopy JTF_NUMBER_TABLE
340: , p6_a5 out nocopy JTF_NUMBER_TABLE
341: , p6_a6 out nocopy JTF_NUMBER_TABLE
342: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_200
343: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_2000
344: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100

Line 341: , p6_a6 out nocopy JTF_NUMBER_TABLE

337: , p6_a2 out nocopy JTF_NUMBER_TABLE
338: , p6_a3 out nocopy JTF_NUMBER_TABLE
339: , p6_a4 out nocopy JTF_NUMBER_TABLE
340: , p6_a5 out nocopy JTF_NUMBER_TABLE
341: , p6_a6 out nocopy JTF_NUMBER_TABLE
342: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_200
343: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_2000
344: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
345: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_500

Line 363: , p6_a28 out nocopy JTF_NUMBER_TABLE

359: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
360: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_100
361: , p6_a26 out nocopy JTF_DATE_TABLE
362: , p6_a27 out nocopy JTF_DATE_TABLE
363: , p6_a28 out nocopy JTF_NUMBER_TABLE
364: , p6_a29 out nocopy JTF_DATE_TABLE
365: , p6_a30 out nocopy JTF_NUMBER_TABLE
366: , p6_a31 out nocopy JTF_DATE_TABLE
367: , p6_a32 out nocopy JTF_NUMBER_TABLE

Line 365: , p6_a30 out nocopy JTF_NUMBER_TABLE

361: , p6_a26 out nocopy JTF_DATE_TABLE
362: , p6_a27 out nocopy JTF_DATE_TABLE
363: , p6_a28 out nocopy JTF_NUMBER_TABLE
364: , p6_a29 out nocopy JTF_DATE_TABLE
365: , p6_a30 out nocopy JTF_NUMBER_TABLE
366: , p6_a31 out nocopy JTF_DATE_TABLE
367: , p6_a32 out nocopy JTF_NUMBER_TABLE
368: );
369: procedure delete_provisions(p_api_version NUMBER

Line 367: , p6_a32 out nocopy JTF_NUMBER_TABLE

363: , p6_a28 out nocopy JTF_NUMBER_TABLE
364: , p6_a29 out nocopy JTF_DATE_TABLE
365: , p6_a30 out nocopy JTF_NUMBER_TABLE
366: , p6_a31 out nocopy JTF_DATE_TABLE
367: , p6_a32 out nocopy JTF_NUMBER_TABLE
368: );
369: procedure delete_provisions(p_api_version NUMBER
370: , p_init_msg_list VARCHAR2
371: , x_return_status out nocopy VARCHAR2

Line 413: , p5_a0 JTF_NUMBER_TABLE

409: , p_init_msg_list VARCHAR2
410: , x_return_status out nocopy VARCHAR2
411: , x_msg_count out nocopy NUMBER
412: , x_msg_data out nocopy VARCHAR2
413: , p5_a0 JTF_NUMBER_TABLE
414: , p5_a1 JTF_NUMBER_TABLE
415: , p5_a2 JTF_NUMBER_TABLE
416: , p5_a3 JTF_NUMBER_TABLE
417: , p5_a4 JTF_NUMBER_TABLE

Line 414: , p5_a1 JTF_NUMBER_TABLE

410: , x_return_status out nocopy VARCHAR2
411: , x_msg_count out nocopy NUMBER
412: , x_msg_data out nocopy VARCHAR2
413: , p5_a0 JTF_NUMBER_TABLE
414: , p5_a1 JTF_NUMBER_TABLE
415: , p5_a2 JTF_NUMBER_TABLE
416: , p5_a3 JTF_NUMBER_TABLE
417: , p5_a4 JTF_NUMBER_TABLE
418: , p5_a5 JTF_NUMBER_TABLE

Line 415: , p5_a2 JTF_NUMBER_TABLE

411: , x_msg_count out nocopy NUMBER
412: , x_msg_data out nocopy VARCHAR2
413: , p5_a0 JTF_NUMBER_TABLE
414: , p5_a1 JTF_NUMBER_TABLE
415: , p5_a2 JTF_NUMBER_TABLE
416: , p5_a3 JTF_NUMBER_TABLE
417: , p5_a4 JTF_NUMBER_TABLE
418: , p5_a5 JTF_NUMBER_TABLE
419: , p5_a6 JTF_NUMBER_TABLE

Line 416: , p5_a3 JTF_NUMBER_TABLE

412: , x_msg_data out nocopy VARCHAR2
413: , p5_a0 JTF_NUMBER_TABLE
414: , p5_a1 JTF_NUMBER_TABLE
415: , p5_a2 JTF_NUMBER_TABLE
416: , p5_a3 JTF_NUMBER_TABLE
417: , p5_a4 JTF_NUMBER_TABLE
418: , p5_a5 JTF_NUMBER_TABLE
419: , p5_a6 JTF_NUMBER_TABLE
420: , p5_a7 JTF_VARCHAR2_TABLE_200

Line 417: , p5_a4 JTF_NUMBER_TABLE

413: , p5_a0 JTF_NUMBER_TABLE
414: , p5_a1 JTF_NUMBER_TABLE
415: , p5_a2 JTF_NUMBER_TABLE
416: , p5_a3 JTF_NUMBER_TABLE
417: , p5_a4 JTF_NUMBER_TABLE
418: , p5_a5 JTF_NUMBER_TABLE
419: , p5_a6 JTF_NUMBER_TABLE
420: , p5_a7 JTF_VARCHAR2_TABLE_200
421: , p5_a8 JTF_VARCHAR2_TABLE_2000

Line 418: , p5_a5 JTF_NUMBER_TABLE

414: , p5_a1 JTF_NUMBER_TABLE
415: , p5_a2 JTF_NUMBER_TABLE
416: , p5_a3 JTF_NUMBER_TABLE
417: , p5_a4 JTF_NUMBER_TABLE
418: , p5_a5 JTF_NUMBER_TABLE
419: , p5_a6 JTF_NUMBER_TABLE
420: , p5_a7 JTF_VARCHAR2_TABLE_200
421: , p5_a8 JTF_VARCHAR2_TABLE_2000
422: , p5_a9 JTF_VARCHAR2_TABLE_100

Line 419: , p5_a6 JTF_NUMBER_TABLE

415: , p5_a2 JTF_NUMBER_TABLE
416: , p5_a3 JTF_NUMBER_TABLE
417: , p5_a4 JTF_NUMBER_TABLE
418: , p5_a5 JTF_NUMBER_TABLE
419: , p5_a6 JTF_NUMBER_TABLE
420: , p5_a7 JTF_VARCHAR2_TABLE_200
421: , p5_a8 JTF_VARCHAR2_TABLE_2000
422: , p5_a9 JTF_VARCHAR2_TABLE_100
423: , p5_a10 JTF_VARCHAR2_TABLE_500

Line 441: , p5_a28 JTF_NUMBER_TABLE

437: , p5_a24 JTF_VARCHAR2_TABLE_500
438: , p5_a25 JTF_VARCHAR2_TABLE_100
439: , p5_a26 JTF_DATE_TABLE
440: , p5_a27 JTF_DATE_TABLE
441: , p5_a28 JTF_NUMBER_TABLE
442: , p5_a29 JTF_DATE_TABLE
443: , p5_a30 JTF_NUMBER_TABLE
444: , p5_a31 JTF_DATE_TABLE
445: , p5_a32 JTF_NUMBER_TABLE

Line 443: , p5_a30 JTF_NUMBER_TABLE

439: , p5_a26 JTF_DATE_TABLE
440: , p5_a27 JTF_DATE_TABLE
441: , p5_a28 JTF_NUMBER_TABLE
442: , p5_a29 JTF_DATE_TABLE
443: , p5_a30 JTF_NUMBER_TABLE
444: , p5_a31 JTF_DATE_TABLE
445: , p5_a32 JTF_NUMBER_TABLE
446: );
447: procedure validate_provisions(p_api_version NUMBER

Line 445: , p5_a32 JTF_NUMBER_TABLE

441: , p5_a28 JTF_NUMBER_TABLE
442: , p5_a29 JTF_DATE_TABLE
443: , p5_a30 JTF_NUMBER_TABLE
444: , p5_a31 JTF_DATE_TABLE
445: , p5_a32 JTF_NUMBER_TABLE
446: );
447: procedure validate_provisions(p_api_version NUMBER
448: , p_init_msg_list VARCHAR2
449: , x_return_status out nocopy VARCHAR2

Line 491: , p5_a0 JTF_NUMBER_TABLE

487: , p_init_msg_list VARCHAR2
488: , x_return_status out nocopy VARCHAR2
489: , x_msg_count out nocopy NUMBER
490: , x_msg_data out nocopy VARCHAR2
491: , p5_a0 JTF_NUMBER_TABLE
492: , p5_a1 JTF_NUMBER_TABLE
493: , p5_a2 JTF_NUMBER_TABLE
494: , p5_a3 JTF_NUMBER_TABLE
495: , p5_a4 JTF_NUMBER_TABLE

Line 492: , p5_a1 JTF_NUMBER_TABLE

488: , x_return_status out nocopy VARCHAR2
489: , x_msg_count out nocopy NUMBER
490: , x_msg_data out nocopy VARCHAR2
491: , p5_a0 JTF_NUMBER_TABLE
492: , p5_a1 JTF_NUMBER_TABLE
493: , p5_a2 JTF_NUMBER_TABLE
494: , p5_a3 JTF_NUMBER_TABLE
495: , p5_a4 JTF_NUMBER_TABLE
496: , p5_a5 JTF_NUMBER_TABLE

Line 493: , p5_a2 JTF_NUMBER_TABLE

489: , x_msg_count out nocopy NUMBER
490: , x_msg_data out nocopy VARCHAR2
491: , p5_a0 JTF_NUMBER_TABLE
492: , p5_a1 JTF_NUMBER_TABLE
493: , p5_a2 JTF_NUMBER_TABLE
494: , p5_a3 JTF_NUMBER_TABLE
495: , p5_a4 JTF_NUMBER_TABLE
496: , p5_a5 JTF_NUMBER_TABLE
497: , p5_a6 JTF_NUMBER_TABLE

Line 494: , p5_a3 JTF_NUMBER_TABLE

490: , x_msg_data out nocopy VARCHAR2
491: , p5_a0 JTF_NUMBER_TABLE
492: , p5_a1 JTF_NUMBER_TABLE
493: , p5_a2 JTF_NUMBER_TABLE
494: , p5_a3 JTF_NUMBER_TABLE
495: , p5_a4 JTF_NUMBER_TABLE
496: , p5_a5 JTF_NUMBER_TABLE
497: , p5_a6 JTF_NUMBER_TABLE
498: , p5_a7 JTF_VARCHAR2_TABLE_200

Line 495: , p5_a4 JTF_NUMBER_TABLE

491: , p5_a0 JTF_NUMBER_TABLE
492: , p5_a1 JTF_NUMBER_TABLE
493: , p5_a2 JTF_NUMBER_TABLE
494: , p5_a3 JTF_NUMBER_TABLE
495: , p5_a4 JTF_NUMBER_TABLE
496: , p5_a5 JTF_NUMBER_TABLE
497: , p5_a6 JTF_NUMBER_TABLE
498: , p5_a7 JTF_VARCHAR2_TABLE_200
499: , p5_a8 JTF_VARCHAR2_TABLE_2000

Line 496: , p5_a5 JTF_NUMBER_TABLE

492: , p5_a1 JTF_NUMBER_TABLE
493: , p5_a2 JTF_NUMBER_TABLE
494: , p5_a3 JTF_NUMBER_TABLE
495: , p5_a4 JTF_NUMBER_TABLE
496: , p5_a5 JTF_NUMBER_TABLE
497: , p5_a6 JTF_NUMBER_TABLE
498: , p5_a7 JTF_VARCHAR2_TABLE_200
499: , p5_a8 JTF_VARCHAR2_TABLE_2000
500: , p5_a9 JTF_VARCHAR2_TABLE_100

Line 497: , p5_a6 JTF_NUMBER_TABLE

493: , p5_a2 JTF_NUMBER_TABLE
494: , p5_a3 JTF_NUMBER_TABLE
495: , p5_a4 JTF_NUMBER_TABLE
496: , p5_a5 JTF_NUMBER_TABLE
497: , p5_a6 JTF_NUMBER_TABLE
498: , p5_a7 JTF_VARCHAR2_TABLE_200
499: , p5_a8 JTF_VARCHAR2_TABLE_2000
500: , p5_a9 JTF_VARCHAR2_TABLE_100
501: , p5_a10 JTF_VARCHAR2_TABLE_500

Line 519: , p5_a28 JTF_NUMBER_TABLE

515: , p5_a24 JTF_VARCHAR2_TABLE_500
516: , p5_a25 JTF_VARCHAR2_TABLE_100
517: , p5_a26 JTF_DATE_TABLE
518: , p5_a27 JTF_DATE_TABLE
519: , p5_a28 JTF_NUMBER_TABLE
520: , p5_a29 JTF_DATE_TABLE
521: , p5_a30 JTF_NUMBER_TABLE
522: , p5_a31 JTF_DATE_TABLE
523: , p5_a32 JTF_NUMBER_TABLE

Line 521: , p5_a30 JTF_NUMBER_TABLE

517: , p5_a26 JTF_DATE_TABLE
518: , p5_a27 JTF_DATE_TABLE
519: , p5_a28 JTF_NUMBER_TABLE
520: , p5_a29 JTF_DATE_TABLE
521: , p5_a30 JTF_NUMBER_TABLE
522: , p5_a31 JTF_DATE_TABLE
523: , p5_a32 JTF_NUMBER_TABLE
524: );
525: end okl_provisions_pub_w;

Line 523: , p5_a32 JTF_NUMBER_TABLE

519: , p5_a28 JTF_NUMBER_TABLE
520: , p5_a29 JTF_DATE_TABLE
521: , p5_a30 JTF_NUMBER_TABLE
522: , p5_a31 JTF_DATE_TABLE
523: , p5_a32 JTF_NUMBER_TABLE
524: );
525: end okl_provisions_pub_w;