28: , p_validation_level NUMBER
29: , p_depth NUMBER
30: , p_time_stamp date
31: , p_active_relationship_only VARCHAR2
32: , p8_a0 out nocopy JTF_NUMBER_TABLE
33: , p8_a1 out nocopy JTF_VARCHAR2_TABLE_100
34: , p8_a2 out nocopy JTF_NUMBER_TABLE
35: , p8_a3 out nocopy JTF_NUMBER_TABLE
36: , p8_a4 out nocopy JTF_VARCHAR2_TABLE_100
30: , p_time_stamp date
31: , p_active_relationship_only VARCHAR2
32: , p8_a0 out nocopy JTF_NUMBER_TABLE
33: , p8_a1 out nocopy JTF_VARCHAR2_TABLE_100
34: , p8_a2 out nocopy JTF_NUMBER_TABLE
35: , p8_a3 out nocopy JTF_NUMBER_TABLE
36: , p8_a4 out nocopy JTF_VARCHAR2_TABLE_100
37: , p8_a5 out nocopy JTF_VARCHAR2_TABLE_100
38: , p8_a6 out nocopy JTF_DATE_TABLE
31: , p_active_relationship_only VARCHAR2
32: , p8_a0 out nocopy JTF_NUMBER_TABLE
33: , p8_a1 out nocopy JTF_VARCHAR2_TABLE_100
34: , p8_a2 out nocopy JTF_NUMBER_TABLE
35: , p8_a3 out nocopy JTF_NUMBER_TABLE
36: , p8_a4 out nocopy JTF_VARCHAR2_TABLE_100
37: , p8_a5 out nocopy JTF_VARCHAR2_TABLE_100
38: , p8_a6 out nocopy JTF_DATE_TABLE
39: , p8_a7 out nocopy JTF_DATE_TABLE
36: , p8_a4 out nocopy JTF_VARCHAR2_TABLE_100
37: , p8_a5 out nocopy JTF_VARCHAR2_TABLE_100
38: , p8_a6 out nocopy JTF_DATE_TABLE
39: , p8_a7 out nocopy JTF_DATE_TABLE
40: , p8_a8 out nocopy JTF_NUMBER_TABLE
41: , p8_a9 out nocopy JTF_VARCHAR2_TABLE_100
42: , p8_a10 out nocopy JTF_VARCHAR2_TABLE_100
43: , p8_a11 out nocopy JTF_VARCHAR2_TABLE_200
44: , p8_a12 out nocopy JTF_VARCHAR2_TABLE_200
54: , p8_a22 out nocopy JTF_VARCHAR2_TABLE_200
55: , p8_a23 out nocopy JTF_VARCHAR2_TABLE_200
56: , p8_a24 out nocopy JTF_VARCHAR2_TABLE_200
57: , p8_a25 out nocopy JTF_VARCHAR2_TABLE_200
58: , p8_a26 out nocopy JTF_NUMBER_TABLE
59: , p8_a27 out nocopy JTF_NUMBER_TABLE
60: , p8_a28 out nocopy JTF_VARCHAR2_TABLE_100
61: , p8_a29 out nocopy JTF_NUMBER_TABLE
62: , p8_a30 out nocopy JTF_VARCHAR2_TABLE_100
55: , p8_a23 out nocopy JTF_VARCHAR2_TABLE_200
56: , p8_a24 out nocopy JTF_VARCHAR2_TABLE_200
57: , p8_a25 out nocopy JTF_VARCHAR2_TABLE_200
58: , p8_a26 out nocopy JTF_NUMBER_TABLE
59: , p8_a27 out nocopy JTF_NUMBER_TABLE
60: , p8_a28 out nocopy JTF_VARCHAR2_TABLE_100
61: , p8_a29 out nocopy JTF_NUMBER_TABLE
62: , p8_a30 out nocopy JTF_VARCHAR2_TABLE_100
63: , x_return_status out nocopy VARCHAR2
57: , p8_a25 out nocopy JTF_VARCHAR2_TABLE_200
58: , p8_a26 out nocopy JTF_NUMBER_TABLE
59: , p8_a27 out nocopy JTF_NUMBER_TABLE
60: , p8_a28 out nocopy JTF_VARCHAR2_TABLE_100
61: , p8_a29 out nocopy JTF_NUMBER_TABLE
62: , p8_a30 out nocopy JTF_VARCHAR2_TABLE_100
63: , x_return_status out nocopy VARCHAR2
64: , x_msg_count out nocopy NUMBER
65: , x_msg_data out nocopy VARCHAR2
157: procedure create_relationship(p_api_version NUMBER
158: , p_commit VARCHAR2
159: , p_init_msg_list VARCHAR2
160: , p_validation_level NUMBER
161: , p4_a0 in out nocopy JTF_NUMBER_TABLE
162: , p4_a1 in out nocopy JTF_VARCHAR2_TABLE_100
163: , p4_a2 in out nocopy JTF_NUMBER_TABLE
164: , p4_a3 in out nocopy JTF_NUMBER_TABLE
165: , p4_a4 in out nocopy JTF_VARCHAR2_TABLE_100
159: , p_init_msg_list VARCHAR2
160: , p_validation_level NUMBER
161: , p4_a0 in out nocopy JTF_NUMBER_TABLE
162: , p4_a1 in out nocopy JTF_VARCHAR2_TABLE_100
163: , p4_a2 in out nocopy JTF_NUMBER_TABLE
164: , p4_a3 in out nocopy JTF_NUMBER_TABLE
165: , p4_a4 in out nocopy JTF_VARCHAR2_TABLE_100
166: , p4_a5 in out nocopy JTF_VARCHAR2_TABLE_100
167: , p4_a6 in out nocopy JTF_DATE_TABLE
160: , p_validation_level NUMBER
161: , p4_a0 in out nocopy JTF_NUMBER_TABLE
162: , p4_a1 in out nocopy JTF_VARCHAR2_TABLE_100
163: , p4_a2 in out nocopy JTF_NUMBER_TABLE
164: , p4_a3 in out nocopy JTF_NUMBER_TABLE
165: , p4_a4 in out nocopy JTF_VARCHAR2_TABLE_100
166: , p4_a5 in out nocopy JTF_VARCHAR2_TABLE_100
167: , p4_a6 in out nocopy JTF_DATE_TABLE
168: , p4_a7 in out nocopy JTF_DATE_TABLE
165: , p4_a4 in out nocopy JTF_VARCHAR2_TABLE_100
166: , p4_a5 in out nocopy JTF_VARCHAR2_TABLE_100
167: , p4_a6 in out nocopy JTF_DATE_TABLE
168: , p4_a7 in out nocopy JTF_DATE_TABLE
169: , p4_a8 in out nocopy JTF_NUMBER_TABLE
170: , p4_a9 in out nocopy JTF_VARCHAR2_TABLE_100
171: , p4_a10 in out nocopy JTF_VARCHAR2_TABLE_100
172: , p4_a11 in out nocopy JTF_VARCHAR2_TABLE_200
173: , p4_a12 in out nocopy JTF_VARCHAR2_TABLE_200
183: , p4_a22 in out nocopy JTF_VARCHAR2_TABLE_200
184: , p4_a23 in out nocopy JTF_VARCHAR2_TABLE_200
185: , p4_a24 in out nocopy JTF_VARCHAR2_TABLE_200
186: , p4_a25 in out nocopy JTF_VARCHAR2_TABLE_200
187: , p4_a26 in out nocopy JTF_NUMBER_TABLE
188: , p4_a27 in out nocopy JTF_NUMBER_TABLE
189: , p4_a28 in out nocopy JTF_VARCHAR2_TABLE_100
190: , p4_a29 in out nocopy JTF_NUMBER_TABLE
191: , p4_a30 in out nocopy JTF_VARCHAR2_TABLE_100
184: , p4_a23 in out nocopy JTF_VARCHAR2_TABLE_200
185: , p4_a24 in out nocopy JTF_VARCHAR2_TABLE_200
186: , p4_a25 in out nocopy JTF_VARCHAR2_TABLE_200
187: , p4_a26 in out nocopy JTF_NUMBER_TABLE
188: , p4_a27 in out nocopy JTF_NUMBER_TABLE
189: , p4_a28 in out nocopy JTF_VARCHAR2_TABLE_100
190: , p4_a29 in out nocopy JTF_NUMBER_TABLE
191: , p4_a30 in out nocopy JTF_VARCHAR2_TABLE_100
192: , p5_a0 in out nocopy NUMBER
186: , p4_a25 in out nocopy JTF_VARCHAR2_TABLE_200
187: , p4_a26 in out nocopy JTF_NUMBER_TABLE
188: , p4_a27 in out nocopy JTF_NUMBER_TABLE
189: , p4_a28 in out nocopy JTF_VARCHAR2_TABLE_100
190: , p4_a29 in out nocopy JTF_NUMBER_TABLE
191: , p4_a30 in out nocopy JTF_VARCHAR2_TABLE_100
192: , p5_a0 in out nocopy NUMBER
193: , p5_a1 in out nocopy DATE
194: , p5_a2 in out nocopy DATE
419: procedure update_relationship(p_api_version NUMBER
420: , p_commit VARCHAR2
421: , p_init_msg_list VARCHAR2
422: , p_validation_level NUMBER
423: , p4_a0 JTF_NUMBER_TABLE
424: , p4_a1 JTF_VARCHAR2_TABLE_100
425: , p4_a2 JTF_NUMBER_TABLE
426: , p4_a3 JTF_NUMBER_TABLE
427: , p4_a4 JTF_VARCHAR2_TABLE_100
421: , p_init_msg_list VARCHAR2
422: , p_validation_level NUMBER
423: , p4_a0 JTF_NUMBER_TABLE
424: , p4_a1 JTF_VARCHAR2_TABLE_100
425: , p4_a2 JTF_NUMBER_TABLE
426: , p4_a3 JTF_NUMBER_TABLE
427: , p4_a4 JTF_VARCHAR2_TABLE_100
428: , p4_a5 JTF_VARCHAR2_TABLE_100
429: , p4_a6 JTF_DATE_TABLE
422: , p_validation_level NUMBER
423: , p4_a0 JTF_NUMBER_TABLE
424: , p4_a1 JTF_VARCHAR2_TABLE_100
425: , p4_a2 JTF_NUMBER_TABLE
426: , p4_a3 JTF_NUMBER_TABLE
427: , p4_a4 JTF_VARCHAR2_TABLE_100
428: , p4_a5 JTF_VARCHAR2_TABLE_100
429: , p4_a6 JTF_DATE_TABLE
430: , p4_a7 JTF_DATE_TABLE
427: , p4_a4 JTF_VARCHAR2_TABLE_100
428: , p4_a5 JTF_VARCHAR2_TABLE_100
429: , p4_a6 JTF_DATE_TABLE
430: , p4_a7 JTF_DATE_TABLE
431: , p4_a8 JTF_NUMBER_TABLE
432: , p4_a9 JTF_VARCHAR2_TABLE_100
433: , p4_a10 JTF_VARCHAR2_TABLE_100
434: , p4_a11 JTF_VARCHAR2_TABLE_200
435: , p4_a12 JTF_VARCHAR2_TABLE_200
445: , p4_a22 JTF_VARCHAR2_TABLE_200
446: , p4_a23 JTF_VARCHAR2_TABLE_200
447: , p4_a24 JTF_VARCHAR2_TABLE_200
448: , p4_a25 JTF_VARCHAR2_TABLE_200
449: , p4_a26 JTF_NUMBER_TABLE
450: , p4_a27 JTF_NUMBER_TABLE
451: , p4_a28 JTF_VARCHAR2_TABLE_100
452: , p4_a29 JTF_NUMBER_TABLE
453: , p4_a30 JTF_VARCHAR2_TABLE_100
446: , p4_a23 JTF_VARCHAR2_TABLE_200
447: , p4_a24 JTF_VARCHAR2_TABLE_200
448: , p4_a25 JTF_VARCHAR2_TABLE_200
449: , p4_a26 JTF_NUMBER_TABLE
450: , p4_a27 JTF_NUMBER_TABLE
451: , p4_a28 JTF_VARCHAR2_TABLE_100
452: , p4_a29 JTF_NUMBER_TABLE
453: , p4_a30 JTF_VARCHAR2_TABLE_100
454: , p5_a0 in out nocopy NUMBER
448: , p4_a25 JTF_VARCHAR2_TABLE_200
449: , p4_a26 JTF_NUMBER_TABLE
450: , p4_a27 JTF_NUMBER_TABLE
451: , p4_a28 JTF_VARCHAR2_TABLE_100
452: , p4_a29 JTF_NUMBER_TABLE
453: , p4_a30 JTF_VARCHAR2_TABLE_100
454: , p5_a0 in out nocopy NUMBER
455: , p5_a1 in out nocopy DATE
456: , p5_a2 in out nocopy DATE
689: , p5_a36 in out nocopy NUMBER
690: , p5_a37 in out nocopy VARCHAR2
691: , p5_a38 in out nocopy DATE
692: , p5_a39 in out nocopy NUMBER
693: , x_instance_id_lst out nocopy JTF_NUMBER_TABLE
694: , x_return_status out nocopy VARCHAR2
695: , x_msg_count out nocopy NUMBER
696: , x_msg_data out nocopy VARCHAR2
697: , p4_a0 NUMBER := 0-1962.0724