DBA Data[Home] [Help]

APPS.CSI_II_RELATIONSHIPS_PUB_W dependencies on JTF_NUMBER_TABLE

Line 32: , p8_a0 out nocopy JTF_NUMBER_TABLE

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

Line 34: , p8_a2 out nocopy JTF_NUMBER_TABLE

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

Line 35: , p8_a3 out nocopy JTF_NUMBER_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

Line 40: , p8_a8 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
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

Line 58: , p8_a26 out nocopy JTF_NUMBER_TABLE

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

Line 59: , p8_a27 out nocopy JTF_NUMBER_TABLE

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

Line 61: , p8_a29 out nocopy JTF_NUMBER_TABLE

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

Line 161: , p4_a0 in out nocopy JTF_NUMBER_TABLE

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

Line 163: , p4_a2 in out nocopy JTF_NUMBER_TABLE

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

Line 164: , p4_a3 in out nocopy JTF_NUMBER_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

Line 169: , p4_a8 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
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

Line 187: , p4_a26 in out nocopy JTF_NUMBER_TABLE

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

Line 188: , p4_a27 in out nocopy JTF_NUMBER_TABLE

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

Line 190: , p4_a29 in out nocopy JTF_NUMBER_TABLE

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

Line 423: , p4_a0 JTF_NUMBER_TABLE

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

Line 425: , p4_a2 JTF_NUMBER_TABLE

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

Line 426: , p4_a3 JTF_NUMBER_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

Line 431: , p4_a8 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
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

Line 449: , p4_a26 JTF_NUMBER_TABLE

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

Line 450: , p4_a27 JTF_NUMBER_TABLE

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

Line 452: , p4_a29 JTF_NUMBER_TABLE

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

Line 693: , x_instance_id_lst out nocopy JTF_NUMBER_TABLE

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