APPS.OKL_PRTFL_CONTRACTS_PUB_W dependencies on JTF_NUMBER_TABLE

Line 8: , p5_a0 JTF_NUMBER_TABLE

4: , p_init_msg_list VARCHAR2
5: , x_return_status out nocopy VARCHAR2
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_300
11: , p5_a3 JTF_VARCHAR2_TABLE_100
12: , p5_a4 JTF_NUMBER_TABLE

Line 9: , p5_a1 JTF_NUMBER_TABLE

5: , x_return_status out nocopy VARCHAR2
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_300
11: , p5_a3 JTF_VARCHAR2_TABLE_100
12: , p5_a4 JTF_NUMBER_TABLE
13: , p5_a5 JTF_VARCHAR2_TABLE_200

Line 12: , p5_a4 JTF_NUMBER_TABLE

8: , p5_a0 JTF_NUMBER_TABLE
9: , p5_a1 JTF_NUMBER_TABLE
10: , p5_a2 JTF_VARCHAR2_TABLE_300
11: , p5_a3 JTF_VARCHAR2_TABLE_100
12: , p5_a4 JTF_NUMBER_TABLE
13: , p5_a5 JTF_VARCHAR2_TABLE_200
14: , p5_a6 JTF_VARCHAR2_TABLE_2000
15: , p5_a7 JTF_NUMBER_TABLE
16: , p5_a8 JTF_NUMBER_TABLE

Line 15: , p5_a7 JTF_NUMBER_TABLE

11: , p5_a3 JTF_VARCHAR2_TABLE_100
12: , p5_a4 JTF_NUMBER_TABLE
13: , p5_a5 JTF_VARCHAR2_TABLE_200
14: , p5_a6 JTF_VARCHAR2_TABLE_2000
15: , p5_a7 JTF_NUMBER_TABLE
16: , p5_a8 JTF_NUMBER_TABLE
17: , p5_a9 JTF_NUMBER_TABLE
18: , p5_a10 JTF_DATE_TABLE
19: , p5_a11 JTF_VARCHAR2_TABLE_300

Line 16: , p5_a8 JTF_NUMBER_TABLE

12: , p5_a4 JTF_NUMBER_TABLE
13: , p5_a5 JTF_VARCHAR2_TABLE_200
14: , p5_a6 JTF_VARCHAR2_TABLE_2000
15: , p5_a7 JTF_NUMBER_TABLE
16: , p5_a8 JTF_NUMBER_TABLE
17: , p5_a9 JTF_NUMBER_TABLE
18: , p5_a10 JTF_DATE_TABLE
19: , p5_a11 JTF_VARCHAR2_TABLE_300
20: , p5_a12 JTF_VARCHAR2_TABLE_300

Line 17: , p5_a9 JTF_NUMBER_TABLE

13: , p5_a5 JTF_VARCHAR2_TABLE_200
14: , p5_a6 JTF_VARCHAR2_TABLE_2000
15: , p5_a7 JTF_NUMBER_TABLE
16: , p5_a8 JTF_NUMBER_TABLE
17: , p5_a9 JTF_NUMBER_TABLE
18: , p5_a10 JTF_DATE_TABLE
19: , p5_a11 JTF_VARCHAR2_TABLE_300
20: , p5_a12 JTF_VARCHAR2_TABLE_300
21: , p5_a13 JTF_VARCHAR2_TABLE_300

Line 35: , p5_a27 JTF_NUMBER_TABLE

31: , p5_a23 JTF_VARCHAR2_TABLE_300
32: , p5_a24 JTF_VARCHAR2_TABLE_300
33: , p5_a25 JTF_VARCHAR2_TABLE_300
34: , p5_a26 JTF_VARCHAR2_TABLE_300
35: , p5_a27 JTF_NUMBER_TABLE
36: , p5_a28 JTF_DATE_TABLE
37: , p5_a29 JTF_NUMBER_TABLE
38: , p5_a30 JTF_DATE_TABLE
39: , p5_a31 JTF_NUMBER_TABLE

Line 37: , p5_a29 JTF_NUMBER_TABLE

33: , p5_a25 JTF_VARCHAR2_TABLE_300
34: , p5_a26 JTF_VARCHAR2_TABLE_300
35: , p5_a27 JTF_NUMBER_TABLE
36: , p5_a28 JTF_DATE_TABLE
37: , p5_a29 JTF_NUMBER_TABLE
38: , p5_a30 JTF_DATE_TABLE
39: , p5_a31 JTF_NUMBER_TABLE
40: , p6_a0 out nocopy JTF_NUMBER_TABLE
41: , p6_a1 out nocopy JTF_NUMBER_TABLE

Line 39: , p5_a31 JTF_NUMBER_TABLE

35: , p5_a27 JTF_NUMBER_TABLE
36: , p5_a28 JTF_DATE_TABLE
37: , p5_a29 JTF_NUMBER_TABLE
38: , p5_a30 JTF_DATE_TABLE
39: , p5_a31 JTF_NUMBER_TABLE
40: , p6_a0 out nocopy JTF_NUMBER_TABLE
41: , p6_a1 out nocopy JTF_NUMBER_TABLE
42: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_300
43: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100

Line 40: , p6_a0 out nocopy JTF_NUMBER_TABLE

36: , p5_a28 JTF_DATE_TABLE
37: , p5_a29 JTF_NUMBER_TABLE
38: , p5_a30 JTF_DATE_TABLE
39: , p5_a31 JTF_NUMBER_TABLE
40: , p6_a0 out nocopy JTF_NUMBER_TABLE
41: , p6_a1 out nocopy JTF_NUMBER_TABLE
42: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_300
43: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
44: , p6_a4 out nocopy JTF_NUMBER_TABLE

Line 41: , p6_a1 out nocopy JTF_NUMBER_TABLE

37: , p5_a29 JTF_NUMBER_TABLE
38: , p5_a30 JTF_DATE_TABLE
39: , p5_a31 JTF_NUMBER_TABLE
40: , p6_a0 out nocopy JTF_NUMBER_TABLE
41: , p6_a1 out nocopy JTF_NUMBER_TABLE
42: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_300
43: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
44: , p6_a4 out nocopy JTF_NUMBER_TABLE
45: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_200

Line 44: , p6_a4 out nocopy JTF_NUMBER_TABLE

40: , p6_a0 out nocopy JTF_NUMBER_TABLE
41: , p6_a1 out nocopy JTF_NUMBER_TABLE
42: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_300
43: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
44: , p6_a4 out nocopy JTF_NUMBER_TABLE
45: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_200
46: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000
47: , p6_a7 out nocopy JTF_NUMBER_TABLE
48: , p6_a8 out nocopy JTF_NUMBER_TABLE

Line 47: , p6_a7 out nocopy JTF_NUMBER_TABLE

43: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
44: , p6_a4 out nocopy JTF_NUMBER_TABLE
45: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_200
46: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000
47: , p6_a7 out nocopy JTF_NUMBER_TABLE
48: , p6_a8 out nocopy JTF_NUMBER_TABLE
49: , p6_a9 out nocopy JTF_NUMBER_TABLE
50: , p6_a10 out nocopy JTF_DATE_TABLE
51: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_300

Line 48: , p6_a8 out nocopy JTF_NUMBER_TABLE

44: , p6_a4 out nocopy JTF_NUMBER_TABLE
45: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_200
46: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000
47: , p6_a7 out nocopy JTF_NUMBER_TABLE
48: , p6_a8 out nocopy JTF_NUMBER_TABLE
49: , p6_a9 out nocopy JTF_NUMBER_TABLE
50: , p6_a10 out nocopy JTF_DATE_TABLE
51: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_300
52: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_300

Line 49: , p6_a9 out nocopy JTF_NUMBER_TABLE

45: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_200
46: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000
47: , p6_a7 out nocopy JTF_NUMBER_TABLE
48: , p6_a8 out nocopy JTF_NUMBER_TABLE
49: , p6_a9 out nocopy JTF_NUMBER_TABLE
50: , p6_a10 out nocopy JTF_DATE_TABLE
51: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_300
52: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_300
53: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_300

Line 67: , p6_a27 out nocopy JTF_NUMBER_TABLE

63: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_300
64: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_300
65: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_300
66: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_300
67: , p6_a27 out nocopy JTF_NUMBER_TABLE
68: , p6_a28 out nocopy JTF_DATE_TABLE
69: , p6_a29 out nocopy JTF_NUMBER_TABLE
70: , p6_a30 out nocopy JTF_DATE_TABLE
71: , p6_a31 out nocopy JTF_NUMBER_TABLE

Line 69: , p6_a29 out nocopy JTF_NUMBER_TABLE

65: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_300
66: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_300
67: , p6_a27 out nocopy JTF_NUMBER_TABLE
68: , p6_a28 out nocopy JTF_DATE_TABLE
69: , p6_a29 out nocopy JTF_NUMBER_TABLE
70: , p6_a30 out nocopy JTF_DATE_TABLE
71: , p6_a31 out nocopy JTF_NUMBER_TABLE
72: );
73: procedure insert_prtfl_contracts(p_api_version NUMBER

Line 71: , p6_a31 out nocopy JTF_NUMBER_TABLE

67: , p6_a27 out nocopy JTF_NUMBER_TABLE
68: , p6_a28 out nocopy JTF_DATE_TABLE
69: , p6_a29 out nocopy JTF_NUMBER_TABLE
70: , p6_a30 out nocopy JTF_DATE_TABLE
71: , p6_a31 out nocopy JTF_NUMBER_TABLE
72: );
73: procedure insert_prtfl_contracts(p_api_version NUMBER
74: , p_init_msg_list VARCHAR2
75: , x_return_status out nocopy VARCHAR2

Line 148: , p5_a0 JTF_NUMBER_TABLE

144: , p_init_msg_list VARCHAR2
145: , x_return_status out nocopy VARCHAR2
146: , x_msg_count out nocopy NUMBER
147: , x_msg_data out nocopy VARCHAR2
148: , p5_a0 JTF_NUMBER_TABLE
149: , p5_a1 JTF_NUMBER_TABLE
150: , p5_a2 JTF_VARCHAR2_TABLE_300
151: , p5_a3 JTF_VARCHAR2_TABLE_100
152: , p5_a4 JTF_NUMBER_TABLE

Line 149: , p5_a1 JTF_NUMBER_TABLE

145: , x_return_status out nocopy VARCHAR2
146: , x_msg_count out nocopy NUMBER
147: , x_msg_data out nocopy VARCHAR2
148: , p5_a0 JTF_NUMBER_TABLE
149: , p5_a1 JTF_NUMBER_TABLE
150: , p5_a2 JTF_VARCHAR2_TABLE_300
151: , p5_a3 JTF_VARCHAR2_TABLE_100
152: , p5_a4 JTF_NUMBER_TABLE
153: , p5_a5 JTF_VARCHAR2_TABLE_200

Line 152: , p5_a4 JTF_NUMBER_TABLE

148: , p5_a0 JTF_NUMBER_TABLE
149: , p5_a1 JTF_NUMBER_TABLE
150: , p5_a2 JTF_VARCHAR2_TABLE_300
151: , p5_a3 JTF_VARCHAR2_TABLE_100
152: , p5_a4 JTF_NUMBER_TABLE
153: , p5_a5 JTF_VARCHAR2_TABLE_200
154: , p5_a6 JTF_VARCHAR2_TABLE_2000
155: , p5_a7 JTF_NUMBER_TABLE
156: , p5_a8 JTF_NUMBER_TABLE

Line 155: , p5_a7 JTF_NUMBER_TABLE

151: , p5_a3 JTF_VARCHAR2_TABLE_100
152: , p5_a4 JTF_NUMBER_TABLE
153: , p5_a5 JTF_VARCHAR2_TABLE_200
154: , p5_a6 JTF_VARCHAR2_TABLE_2000
155: , p5_a7 JTF_NUMBER_TABLE
156: , p5_a8 JTF_NUMBER_TABLE
157: , p5_a9 JTF_NUMBER_TABLE
158: , p5_a10 JTF_DATE_TABLE
159: , p5_a11 JTF_VARCHAR2_TABLE_300

Line 156: , p5_a8 JTF_NUMBER_TABLE

152: , p5_a4 JTF_NUMBER_TABLE
153: , p5_a5 JTF_VARCHAR2_TABLE_200
154: , p5_a6 JTF_VARCHAR2_TABLE_2000
155: , p5_a7 JTF_NUMBER_TABLE
156: , p5_a8 JTF_NUMBER_TABLE
157: , p5_a9 JTF_NUMBER_TABLE
158: , p5_a10 JTF_DATE_TABLE
159: , p5_a11 JTF_VARCHAR2_TABLE_300
160: , p5_a12 JTF_VARCHAR2_TABLE_300

Line 157: , p5_a9 JTF_NUMBER_TABLE

153: , p5_a5 JTF_VARCHAR2_TABLE_200
154: , p5_a6 JTF_VARCHAR2_TABLE_2000
155: , p5_a7 JTF_NUMBER_TABLE
156: , p5_a8 JTF_NUMBER_TABLE
157: , p5_a9 JTF_NUMBER_TABLE
158: , p5_a10 JTF_DATE_TABLE
159: , p5_a11 JTF_VARCHAR2_TABLE_300
160: , p5_a12 JTF_VARCHAR2_TABLE_300
161: , p5_a13 JTF_VARCHAR2_TABLE_300

Line 175: , p5_a27 JTF_NUMBER_TABLE

171: , p5_a23 JTF_VARCHAR2_TABLE_300
172: , p5_a24 JTF_VARCHAR2_TABLE_300
173: , p5_a25 JTF_VARCHAR2_TABLE_300
174: , p5_a26 JTF_VARCHAR2_TABLE_300
175: , p5_a27 JTF_NUMBER_TABLE
176: , p5_a28 JTF_DATE_TABLE
177: , p5_a29 JTF_NUMBER_TABLE
178: , p5_a30 JTF_DATE_TABLE
179: , p5_a31 JTF_NUMBER_TABLE

Line 177: , p5_a29 JTF_NUMBER_TABLE

173: , p5_a25 JTF_VARCHAR2_TABLE_300
174: , p5_a26 JTF_VARCHAR2_TABLE_300
175: , p5_a27 JTF_NUMBER_TABLE
176: , p5_a28 JTF_DATE_TABLE
177: , p5_a29 JTF_NUMBER_TABLE
178: , p5_a30 JTF_DATE_TABLE
179: , p5_a31 JTF_NUMBER_TABLE
180: );
181: procedure lock_prtfl_contracts(p_api_version NUMBER

Line 179: , p5_a31 JTF_NUMBER_TABLE

175: , p5_a27 JTF_NUMBER_TABLE
176: , p5_a28 JTF_DATE_TABLE
177: , p5_a29 JTF_NUMBER_TABLE
178: , p5_a30 JTF_DATE_TABLE
179: , p5_a31 JTF_NUMBER_TABLE
180: );
181: procedure lock_prtfl_contracts(p_api_version NUMBER
182: , p_init_msg_list VARCHAR2
183: , x_return_status out nocopy VARCHAR2

Line 224: , p5_a0 JTF_NUMBER_TABLE

220: , p_init_msg_list VARCHAR2
221: , x_return_status out nocopy VARCHAR2
222: , x_msg_count out nocopy NUMBER
223: , x_msg_data out nocopy VARCHAR2
224: , p5_a0 JTF_NUMBER_TABLE
225: , p5_a1 JTF_NUMBER_TABLE
226: , p5_a2 JTF_VARCHAR2_TABLE_300
227: , p5_a3 JTF_VARCHAR2_TABLE_100
228: , p5_a4 JTF_NUMBER_TABLE

Line 225: , p5_a1 JTF_NUMBER_TABLE

221: , x_return_status out nocopy VARCHAR2
222: , x_msg_count out nocopy NUMBER
223: , x_msg_data out nocopy VARCHAR2
224: , p5_a0 JTF_NUMBER_TABLE
225: , p5_a1 JTF_NUMBER_TABLE
226: , p5_a2 JTF_VARCHAR2_TABLE_300
227: , p5_a3 JTF_VARCHAR2_TABLE_100
228: , p5_a4 JTF_NUMBER_TABLE
229: , p5_a5 JTF_VARCHAR2_TABLE_200

Line 228: , p5_a4 JTF_NUMBER_TABLE

224: , p5_a0 JTF_NUMBER_TABLE
225: , p5_a1 JTF_NUMBER_TABLE
226: , p5_a2 JTF_VARCHAR2_TABLE_300
227: , p5_a3 JTF_VARCHAR2_TABLE_100
228: , p5_a4 JTF_NUMBER_TABLE
229: , p5_a5 JTF_VARCHAR2_TABLE_200
230: , p5_a6 JTF_VARCHAR2_TABLE_2000
231: , p5_a7 JTF_NUMBER_TABLE
232: , p5_a8 JTF_NUMBER_TABLE

Line 231: , p5_a7 JTF_NUMBER_TABLE

227: , p5_a3 JTF_VARCHAR2_TABLE_100
228: , p5_a4 JTF_NUMBER_TABLE
229: , p5_a5 JTF_VARCHAR2_TABLE_200
230: , p5_a6 JTF_VARCHAR2_TABLE_2000
231: , p5_a7 JTF_NUMBER_TABLE
232: , p5_a8 JTF_NUMBER_TABLE
233: , p5_a9 JTF_NUMBER_TABLE
234: , p5_a10 JTF_DATE_TABLE
235: , p5_a11 JTF_VARCHAR2_TABLE_300

Line 232: , p5_a8 JTF_NUMBER_TABLE

228: , p5_a4 JTF_NUMBER_TABLE
229: , p5_a5 JTF_VARCHAR2_TABLE_200
230: , p5_a6 JTF_VARCHAR2_TABLE_2000
231: , p5_a7 JTF_NUMBER_TABLE
232: , p5_a8 JTF_NUMBER_TABLE
233: , p5_a9 JTF_NUMBER_TABLE
234: , p5_a10 JTF_DATE_TABLE
235: , p5_a11 JTF_VARCHAR2_TABLE_300
236: , p5_a12 JTF_VARCHAR2_TABLE_300

Line 233: , p5_a9 JTF_NUMBER_TABLE

229: , p5_a5 JTF_VARCHAR2_TABLE_200
230: , p5_a6 JTF_VARCHAR2_TABLE_2000
231: , p5_a7 JTF_NUMBER_TABLE
232: , p5_a8 JTF_NUMBER_TABLE
233: , p5_a9 JTF_NUMBER_TABLE
234: , p5_a10 JTF_DATE_TABLE
235: , p5_a11 JTF_VARCHAR2_TABLE_300
236: , p5_a12 JTF_VARCHAR2_TABLE_300
237: , p5_a13 JTF_VARCHAR2_TABLE_300

Line 251: , p5_a27 JTF_NUMBER_TABLE

247: , p5_a23 JTF_VARCHAR2_TABLE_300
248: , p5_a24 JTF_VARCHAR2_TABLE_300
249: , p5_a25 JTF_VARCHAR2_TABLE_300
250: , p5_a26 JTF_VARCHAR2_TABLE_300
251: , p5_a27 JTF_NUMBER_TABLE
252: , p5_a28 JTF_DATE_TABLE
253: , p5_a29 JTF_NUMBER_TABLE
254: , p5_a30 JTF_DATE_TABLE
255: , p5_a31 JTF_NUMBER_TABLE

Line 253: , p5_a29 JTF_NUMBER_TABLE

249: , p5_a25 JTF_VARCHAR2_TABLE_300
250: , p5_a26 JTF_VARCHAR2_TABLE_300
251: , p5_a27 JTF_NUMBER_TABLE
252: , p5_a28 JTF_DATE_TABLE
253: , p5_a29 JTF_NUMBER_TABLE
254: , p5_a30 JTF_DATE_TABLE
255: , p5_a31 JTF_NUMBER_TABLE
256: , p6_a0 out nocopy JTF_NUMBER_TABLE
257: , p6_a1 out nocopy JTF_NUMBER_TABLE

Line 255: , p5_a31 JTF_NUMBER_TABLE

251: , p5_a27 JTF_NUMBER_TABLE
252: , p5_a28 JTF_DATE_TABLE
253: , p5_a29 JTF_NUMBER_TABLE
254: , p5_a30 JTF_DATE_TABLE
255: , p5_a31 JTF_NUMBER_TABLE
256: , p6_a0 out nocopy JTF_NUMBER_TABLE
257: , p6_a1 out nocopy JTF_NUMBER_TABLE
258: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_300
259: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100

Line 256: , p6_a0 out nocopy JTF_NUMBER_TABLE

252: , p5_a28 JTF_DATE_TABLE
253: , p5_a29 JTF_NUMBER_TABLE
254: , p5_a30 JTF_DATE_TABLE
255: , p5_a31 JTF_NUMBER_TABLE
256: , p6_a0 out nocopy JTF_NUMBER_TABLE
257: , p6_a1 out nocopy JTF_NUMBER_TABLE
258: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_300
259: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
260: , p6_a4 out nocopy JTF_NUMBER_TABLE

Line 257: , p6_a1 out nocopy JTF_NUMBER_TABLE

253: , p5_a29 JTF_NUMBER_TABLE
254: , p5_a30 JTF_DATE_TABLE
255: , p5_a31 JTF_NUMBER_TABLE
256: , p6_a0 out nocopy JTF_NUMBER_TABLE
257: , p6_a1 out nocopy JTF_NUMBER_TABLE
258: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_300
259: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
260: , p6_a4 out nocopy JTF_NUMBER_TABLE
261: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_200

Line 260: , p6_a4 out nocopy JTF_NUMBER_TABLE

256: , p6_a0 out nocopy JTF_NUMBER_TABLE
257: , p6_a1 out nocopy JTF_NUMBER_TABLE
258: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_300
259: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
260: , p6_a4 out nocopy JTF_NUMBER_TABLE
261: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_200
262: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000
263: , p6_a7 out nocopy JTF_NUMBER_TABLE
264: , p6_a8 out nocopy JTF_NUMBER_TABLE

Line 263: , p6_a7 out nocopy JTF_NUMBER_TABLE

259: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
260: , p6_a4 out nocopy JTF_NUMBER_TABLE
261: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_200
262: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000
263: , p6_a7 out nocopy JTF_NUMBER_TABLE
264: , p6_a8 out nocopy JTF_NUMBER_TABLE
265: , p6_a9 out nocopy JTF_NUMBER_TABLE
266: , p6_a10 out nocopy JTF_DATE_TABLE
267: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_300

Line 264: , p6_a8 out nocopy JTF_NUMBER_TABLE

260: , p6_a4 out nocopy JTF_NUMBER_TABLE
261: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_200
262: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000
263: , p6_a7 out nocopy JTF_NUMBER_TABLE
264: , p6_a8 out nocopy JTF_NUMBER_TABLE
265: , p6_a9 out nocopy JTF_NUMBER_TABLE
266: , p6_a10 out nocopy JTF_DATE_TABLE
267: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_300
268: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_300

Line 265: , p6_a9 out nocopy JTF_NUMBER_TABLE

261: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_200
262: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000
263: , p6_a7 out nocopy JTF_NUMBER_TABLE
264: , p6_a8 out nocopy JTF_NUMBER_TABLE
265: , p6_a9 out nocopy JTF_NUMBER_TABLE
266: , p6_a10 out nocopy JTF_DATE_TABLE
267: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_300
268: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_300
269: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_300

Line 283: , p6_a27 out nocopy JTF_NUMBER_TABLE

279: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_300
280: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_300
281: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_300
282: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_300
283: , p6_a27 out nocopy JTF_NUMBER_TABLE
284: , p6_a28 out nocopy JTF_DATE_TABLE
285: , p6_a29 out nocopy JTF_NUMBER_TABLE
286: , p6_a30 out nocopy JTF_DATE_TABLE
287: , p6_a31 out nocopy JTF_NUMBER_TABLE

Line 285: , p6_a29 out nocopy JTF_NUMBER_TABLE

281: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_300
282: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_300
283: , p6_a27 out nocopy JTF_NUMBER_TABLE
284: , p6_a28 out nocopy JTF_DATE_TABLE
285: , p6_a29 out nocopy JTF_NUMBER_TABLE
286: , p6_a30 out nocopy JTF_DATE_TABLE
287: , p6_a31 out nocopy JTF_NUMBER_TABLE
288: );
289: procedure update_prtfl_contracts(p_api_version NUMBER

Line 287: , p6_a31 out nocopy JTF_NUMBER_TABLE

283: , p6_a27 out nocopy JTF_NUMBER_TABLE
284: , p6_a28 out nocopy JTF_DATE_TABLE
285: , p6_a29 out nocopy JTF_NUMBER_TABLE
286: , p6_a30 out nocopy JTF_DATE_TABLE
287: , p6_a31 out nocopy JTF_NUMBER_TABLE
288: );
289: procedure update_prtfl_contracts(p_api_version NUMBER
290: , p_init_msg_list VARCHAR2
291: , x_return_status out nocopy VARCHAR2

Line 364: , p5_a0 JTF_NUMBER_TABLE

360: , p_init_msg_list VARCHAR2
361: , x_return_status out nocopy VARCHAR2
362: , x_msg_count out nocopy NUMBER
363: , x_msg_data out nocopy VARCHAR2
364: , p5_a0 JTF_NUMBER_TABLE
365: , p5_a1 JTF_NUMBER_TABLE
366: , p5_a2 JTF_VARCHAR2_TABLE_300
367: , p5_a3 JTF_VARCHAR2_TABLE_100
368: , p5_a4 JTF_NUMBER_TABLE

Line 365: , p5_a1 JTF_NUMBER_TABLE

361: , x_return_status out nocopy VARCHAR2
362: , x_msg_count out nocopy NUMBER
363: , x_msg_data out nocopy VARCHAR2
364: , p5_a0 JTF_NUMBER_TABLE
365: , p5_a1 JTF_NUMBER_TABLE
366: , p5_a2 JTF_VARCHAR2_TABLE_300
367: , p5_a3 JTF_VARCHAR2_TABLE_100
368: , p5_a4 JTF_NUMBER_TABLE
369: , p5_a5 JTF_VARCHAR2_TABLE_200

Line 368: , p5_a4 JTF_NUMBER_TABLE

364: , p5_a0 JTF_NUMBER_TABLE
365: , p5_a1 JTF_NUMBER_TABLE
366: , p5_a2 JTF_VARCHAR2_TABLE_300
367: , p5_a3 JTF_VARCHAR2_TABLE_100
368: , p5_a4 JTF_NUMBER_TABLE
369: , p5_a5 JTF_VARCHAR2_TABLE_200
370: , p5_a6 JTF_VARCHAR2_TABLE_2000
371: , p5_a7 JTF_NUMBER_TABLE
372: , p5_a8 JTF_NUMBER_TABLE

Line 371: , p5_a7 JTF_NUMBER_TABLE

367: , p5_a3 JTF_VARCHAR2_TABLE_100
368: , p5_a4 JTF_NUMBER_TABLE
369: , p5_a5 JTF_VARCHAR2_TABLE_200
370: , p5_a6 JTF_VARCHAR2_TABLE_2000
371: , p5_a7 JTF_NUMBER_TABLE
372: , p5_a8 JTF_NUMBER_TABLE
373: , p5_a9 JTF_NUMBER_TABLE
374: , p5_a10 JTF_DATE_TABLE
375: , p5_a11 JTF_VARCHAR2_TABLE_300

Line 372: , p5_a8 JTF_NUMBER_TABLE

368: , p5_a4 JTF_NUMBER_TABLE
369: , p5_a5 JTF_VARCHAR2_TABLE_200
370: , p5_a6 JTF_VARCHAR2_TABLE_2000
371: , p5_a7 JTF_NUMBER_TABLE
372: , p5_a8 JTF_NUMBER_TABLE
373: , p5_a9 JTF_NUMBER_TABLE
374: , p5_a10 JTF_DATE_TABLE
375: , p5_a11 JTF_VARCHAR2_TABLE_300
376: , p5_a12 JTF_VARCHAR2_TABLE_300

Line 373: , p5_a9 JTF_NUMBER_TABLE

369: , p5_a5 JTF_VARCHAR2_TABLE_200
370: , p5_a6 JTF_VARCHAR2_TABLE_2000
371: , p5_a7 JTF_NUMBER_TABLE
372: , p5_a8 JTF_NUMBER_TABLE
373: , p5_a9 JTF_NUMBER_TABLE
374: , p5_a10 JTF_DATE_TABLE
375: , p5_a11 JTF_VARCHAR2_TABLE_300
376: , p5_a12 JTF_VARCHAR2_TABLE_300
377: , p5_a13 JTF_VARCHAR2_TABLE_300

Line 391: , p5_a27 JTF_NUMBER_TABLE

387: , p5_a23 JTF_VARCHAR2_TABLE_300
388: , p5_a24 JTF_VARCHAR2_TABLE_300
389: , p5_a25 JTF_VARCHAR2_TABLE_300
390: , p5_a26 JTF_VARCHAR2_TABLE_300
391: , p5_a27 JTF_NUMBER_TABLE
392: , p5_a28 JTF_DATE_TABLE
393: , p5_a29 JTF_NUMBER_TABLE
394: , p5_a30 JTF_DATE_TABLE
395: , p5_a31 JTF_NUMBER_TABLE

Line 393: , p5_a29 JTF_NUMBER_TABLE

389: , p5_a25 JTF_VARCHAR2_TABLE_300
390: , p5_a26 JTF_VARCHAR2_TABLE_300
391: , p5_a27 JTF_NUMBER_TABLE
392: , p5_a28 JTF_DATE_TABLE
393: , p5_a29 JTF_NUMBER_TABLE
394: , p5_a30 JTF_DATE_TABLE
395: , p5_a31 JTF_NUMBER_TABLE
396: );
397: procedure delete_prtfl_contracts(p_api_version NUMBER

Line 395: , p5_a31 JTF_NUMBER_TABLE

391: , p5_a27 JTF_NUMBER_TABLE
392: , p5_a28 JTF_DATE_TABLE
393: , p5_a29 JTF_NUMBER_TABLE
394: , p5_a30 JTF_DATE_TABLE
395: , p5_a31 JTF_NUMBER_TABLE
396: );
397: procedure delete_prtfl_contracts(p_api_version NUMBER
398: , p_init_msg_list VARCHAR2
399: , x_return_status out nocopy VARCHAR2

Line 440: , p5_a0 JTF_NUMBER_TABLE

436: , p_init_msg_list VARCHAR2
437: , x_return_status out nocopy VARCHAR2
438: , x_msg_count out nocopy NUMBER
439: , x_msg_data out nocopy VARCHAR2
440: , p5_a0 JTF_NUMBER_TABLE
441: , p5_a1 JTF_NUMBER_TABLE
442: , p5_a2 JTF_VARCHAR2_TABLE_300
443: , p5_a3 JTF_VARCHAR2_TABLE_100
444: , p5_a4 JTF_NUMBER_TABLE

Line 441: , p5_a1 JTF_NUMBER_TABLE

437: , x_return_status out nocopy VARCHAR2
438: , x_msg_count out nocopy NUMBER
439: , x_msg_data out nocopy VARCHAR2
440: , p5_a0 JTF_NUMBER_TABLE
441: , p5_a1 JTF_NUMBER_TABLE
442: , p5_a2 JTF_VARCHAR2_TABLE_300
443: , p5_a3 JTF_VARCHAR2_TABLE_100
444: , p5_a4 JTF_NUMBER_TABLE
445: , p5_a5 JTF_VARCHAR2_TABLE_200

Line 444: , p5_a4 JTF_NUMBER_TABLE

440: , p5_a0 JTF_NUMBER_TABLE
441: , p5_a1 JTF_NUMBER_TABLE
442: , p5_a2 JTF_VARCHAR2_TABLE_300
443: , p5_a3 JTF_VARCHAR2_TABLE_100
444: , p5_a4 JTF_NUMBER_TABLE
445: , p5_a5 JTF_VARCHAR2_TABLE_200
446: , p5_a6 JTF_VARCHAR2_TABLE_2000
447: , p5_a7 JTF_NUMBER_TABLE
448: , p5_a8 JTF_NUMBER_TABLE

Line 447: , p5_a7 JTF_NUMBER_TABLE

443: , p5_a3 JTF_VARCHAR2_TABLE_100
444: , p5_a4 JTF_NUMBER_TABLE
445: , p5_a5 JTF_VARCHAR2_TABLE_200
446: , p5_a6 JTF_VARCHAR2_TABLE_2000
447: , p5_a7 JTF_NUMBER_TABLE
448: , p5_a8 JTF_NUMBER_TABLE
449: , p5_a9 JTF_NUMBER_TABLE
450: , p5_a10 JTF_DATE_TABLE
451: , p5_a11 JTF_VARCHAR2_TABLE_300

Line 448: , p5_a8 JTF_NUMBER_TABLE

444: , p5_a4 JTF_NUMBER_TABLE
445: , p5_a5 JTF_VARCHAR2_TABLE_200
446: , p5_a6 JTF_VARCHAR2_TABLE_2000
447: , p5_a7 JTF_NUMBER_TABLE
448: , p5_a8 JTF_NUMBER_TABLE
449: , p5_a9 JTF_NUMBER_TABLE
450: , p5_a10 JTF_DATE_TABLE
451: , p5_a11 JTF_VARCHAR2_TABLE_300
452: , p5_a12 JTF_VARCHAR2_TABLE_300

Line 449: , p5_a9 JTF_NUMBER_TABLE

445: , p5_a5 JTF_VARCHAR2_TABLE_200
446: , p5_a6 JTF_VARCHAR2_TABLE_2000
447: , p5_a7 JTF_NUMBER_TABLE
448: , p5_a8 JTF_NUMBER_TABLE
449: , p5_a9 JTF_NUMBER_TABLE
450: , p5_a10 JTF_DATE_TABLE
451: , p5_a11 JTF_VARCHAR2_TABLE_300
452: , p5_a12 JTF_VARCHAR2_TABLE_300
453: , p5_a13 JTF_VARCHAR2_TABLE_300

Line 467: , p5_a27 JTF_NUMBER_TABLE

463: , p5_a23 JTF_VARCHAR2_TABLE_300
464: , p5_a24 JTF_VARCHAR2_TABLE_300
465: , p5_a25 JTF_VARCHAR2_TABLE_300
466: , p5_a26 JTF_VARCHAR2_TABLE_300
467: , p5_a27 JTF_NUMBER_TABLE
468: , p5_a28 JTF_DATE_TABLE
469: , p5_a29 JTF_NUMBER_TABLE
470: , p5_a30 JTF_DATE_TABLE
471: , p5_a31 JTF_NUMBER_TABLE

Line 469: , p5_a29 JTF_NUMBER_TABLE

465: , p5_a25 JTF_VARCHAR2_TABLE_300
466: , p5_a26 JTF_VARCHAR2_TABLE_300
467: , p5_a27 JTF_NUMBER_TABLE
468: , p5_a28 JTF_DATE_TABLE
469: , p5_a29 JTF_NUMBER_TABLE
470: , p5_a30 JTF_DATE_TABLE
471: , p5_a31 JTF_NUMBER_TABLE
472: );
473: procedure validate_prtfl_contracts(p_api_version NUMBER

Line 471: , p5_a31 JTF_NUMBER_TABLE

467: , p5_a27 JTF_NUMBER_TABLE
468: , p5_a28 JTF_DATE_TABLE
469: , p5_a29 JTF_NUMBER_TABLE
470: , p5_a30 JTF_DATE_TABLE
471: , p5_a31 JTF_NUMBER_TABLE
472: );
473: procedure validate_prtfl_contracts(p_api_version NUMBER
474: , p_init_msg_list VARCHAR2
475: , x_return_status out nocopy VARCHAR2