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
22: , p5_a14 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
40: , p6_a0 out nocopy JTF_NUMBER_TABLE
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
42: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_300
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
54: , p6_a14 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
72: );
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
74: , p_init_msg_list VARCHAR2
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
162: , p5_a14 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
180: );
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
182: , p_init_msg_list VARCHAR2
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
238: , p5_a14 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
256: , p6_a0 out nocopy JTF_NUMBER_TABLE
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
258: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_300
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
270: , p6_a14 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
288: );
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
290: , p_init_msg_list VARCHAR2
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
378: , p5_a14 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
396: );
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
398: , p_init_msg_list VARCHAR2
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
454: , p5_a14 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
472: );
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
474: , p_init_msg_list VARCHAR2