DBA Data[Home] [Help]

APPS.CSI_II_RELATIONSHIPS_PUB_W dependencies on JTF_NUMBER_TABLE

Line 10: , p8_a0 out nocopy JTF_NUMBER_TABLE

6: , p_validation_level NUMBER
7: , p_depth NUMBER
8: , p_time_stamp date
9: , p_active_relationship_only VARCHAR2
10: , p8_a0 out nocopy JTF_NUMBER_TABLE
11: , p8_a1 out nocopy JTF_VARCHAR2_TABLE_100
12: , p8_a2 out nocopy JTF_NUMBER_TABLE
13: , p8_a3 out nocopy JTF_NUMBER_TABLE
14: , p8_a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 12: , p8_a2 out nocopy JTF_NUMBER_TABLE

8: , p_time_stamp date
9: , p_active_relationship_only VARCHAR2
10: , p8_a0 out nocopy JTF_NUMBER_TABLE
11: , p8_a1 out nocopy JTF_VARCHAR2_TABLE_100
12: , p8_a2 out nocopy JTF_NUMBER_TABLE
13: , p8_a3 out nocopy JTF_NUMBER_TABLE
14: , p8_a4 out nocopy JTF_VARCHAR2_TABLE_100
15: , p8_a5 out nocopy JTF_VARCHAR2_TABLE_100
16: , p8_a6 out nocopy JTF_DATE_TABLE

Line 13: , p8_a3 out nocopy JTF_NUMBER_TABLE

9: , p_active_relationship_only VARCHAR2
10: , p8_a0 out nocopy JTF_NUMBER_TABLE
11: , p8_a1 out nocopy JTF_VARCHAR2_TABLE_100
12: , p8_a2 out nocopy JTF_NUMBER_TABLE
13: , p8_a3 out nocopy JTF_NUMBER_TABLE
14: , p8_a4 out nocopy JTF_VARCHAR2_TABLE_100
15: , p8_a5 out nocopy JTF_VARCHAR2_TABLE_100
16: , p8_a6 out nocopy JTF_DATE_TABLE
17: , p8_a7 out nocopy JTF_DATE_TABLE

Line 18: , p8_a8 out nocopy JTF_NUMBER_TABLE

14: , p8_a4 out nocopy JTF_VARCHAR2_TABLE_100
15: , p8_a5 out nocopy JTF_VARCHAR2_TABLE_100
16: , p8_a6 out nocopy JTF_DATE_TABLE
17: , p8_a7 out nocopy JTF_DATE_TABLE
18: , p8_a8 out nocopy JTF_NUMBER_TABLE
19: , p8_a9 out nocopy JTF_VARCHAR2_TABLE_100
20: , p8_a10 out nocopy JTF_VARCHAR2_TABLE_100
21: , p8_a11 out nocopy JTF_VARCHAR2_TABLE_200
22: , p8_a12 out nocopy JTF_VARCHAR2_TABLE_200

Line 36: , p8_a26 out nocopy JTF_NUMBER_TABLE

32: , p8_a22 out nocopy JTF_VARCHAR2_TABLE_200
33: , p8_a23 out nocopy JTF_VARCHAR2_TABLE_200
34: , p8_a24 out nocopy JTF_VARCHAR2_TABLE_200
35: , p8_a25 out nocopy JTF_VARCHAR2_TABLE_200
36: , p8_a26 out nocopy JTF_NUMBER_TABLE
37: , p8_a27 out nocopy JTF_NUMBER_TABLE
38: , p8_a28 out nocopy JTF_VARCHAR2_TABLE_100
39: , p8_a29 out nocopy JTF_NUMBER_TABLE
40: , p8_a30 out nocopy JTF_VARCHAR2_TABLE_100

Line 37: , p8_a27 out nocopy JTF_NUMBER_TABLE

33: , p8_a23 out nocopy JTF_VARCHAR2_TABLE_200
34: , p8_a24 out nocopy JTF_VARCHAR2_TABLE_200
35: , p8_a25 out nocopy JTF_VARCHAR2_TABLE_200
36: , p8_a26 out nocopy JTF_NUMBER_TABLE
37: , p8_a27 out nocopy JTF_NUMBER_TABLE
38: , p8_a28 out nocopy JTF_VARCHAR2_TABLE_100
39: , p8_a29 out nocopy JTF_NUMBER_TABLE
40: , p8_a30 out nocopy JTF_VARCHAR2_TABLE_100
41: , x_return_status out nocopy VARCHAR2

Line 39: , p8_a29 out nocopy JTF_NUMBER_TABLE

35: , p8_a25 out nocopy JTF_VARCHAR2_TABLE_200
36: , p8_a26 out nocopy JTF_NUMBER_TABLE
37: , p8_a27 out nocopy JTF_NUMBER_TABLE
38: , p8_a28 out nocopy JTF_VARCHAR2_TABLE_100
39: , p8_a29 out nocopy JTF_NUMBER_TABLE
40: , p8_a30 out nocopy JTF_VARCHAR2_TABLE_100
41: , x_return_status out nocopy VARCHAR2
42: , x_msg_count out nocopy NUMBER
43: , x_msg_data out nocopy VARCHAR2

Line 53: , p4_a0 in out nocopy JTF_NUMBER_TABLE

49: procedure create_relationship(p_api_version NUMBER
50: , p_commit VARCHAR2
51: , p_init_msg_list VARCHAR2
52: , p_validation_level NUMBER
53: , p4_a0 in out nocopy JTF_NUMBER_TABLE
54: , p4_a1 in out nocopy JTF_VARCHAR2_TABLE_100
55: , p4_a2 in out nocopy JTF_NUMBER_TABLE
56: , p4_a3 in out nocopy JTF_NUMBER_TABLE
57: , p4_a4 in out nocopy JTF_VARCHAR2_TABLE_100

Line 55: , p4_a2 in out nocopy JTF_NUMBER_TABLE

51: , p_init_msg_list VARCHAR2
52: , p_validation_level NUMBER
53: , p4_a0 in out nocopy JTF_NUMBER_TABLE
54: , p4_a1 in out nocopy JTF_VARCHAR2_TABLE_100
55: , p4_a2 in out nocopy JTF_NUMBER_TABLE
56: , p4_a3 in out nocopy JTF_NUMBER_TABLE
57: , p4_a4 in out nocopy JTF_VARCHAR2_TABLE_100
58: , p4_a5 in out nocopy JTF_VARCHAR2_TABLE_100
59: , p4_a6 in out nocopy JTF_DATE_TABLE

Line 56: , p4_a3 in out nocopy JTF_NUMBER_TABLE

52: , p_validation_level NUMBER
53: , p4_a0 in out nocopy JTF_NUMBER_TABLE
54: , p4_a1 in out nocopy JTF_VARCHAR2_TABLE_100
55: , p4_a2 in out nocopy JTF_NUMBER_TABLE
56: , p4_a3 in out nocopy JTF_NUMBER_TABLE
57: , p4_a4 in out nocopy JTF_VARCHAR2_TABLE_100
58: , p4_a5 in out nocopy JTF_VARCHAR2_TABLE_100
59: , p4_a6 in out nocopy JTF_DATE_TABLE
60: , p4_a7 in out nocopy JTF_DATE_TABLE

Line 61: , p4_a8 in out nocopy JTF_NUMBER_TABLE

57: , p4_a4 in out nocopy JTF_VARCHAR2_TABLE_100
58: , p4_a5 in out nocopy JTF_VARCHAR2_TABLE_100
59: , p4_a6 in out nocopy JTF_DATE_TABLE
60: , p4_a7 in out nocopy JTF_DATE_TABLE
61: , p4_a8 in out nocopy JTF_NUMBER_TABLE
62: , p4_a9 in out nocopy JTF_VARCHAR2_TABLE_100
63: , p4_a10 in out nocopy JTF_VARCHAR2_TABLE_100
64: , p4_a11 in out nocopy JTF_VARCHAR2_TABLE_200
65: , p4_a12 in out nocopy JTF_VARCHAR2_TABLE_200

Line 79: , p4_a26 in out nocopy JTF_NUMBER_TABLE

75: , p4_a22 in out nocopy JTF_VARCHAR2_TABLE_200
76: , p4_a23 in out nocopy JTF_VARCHAR2_TABLE_200
77: , p4_a24 in out nocopy JTF_VARCHAR2_TABLE_200
78: , p4_a25 in out nocopy JTF_VARCHAR2_TABLE_200
79: , p4_a26 in out nocopy JTF_NUMBER_TABLE
80: , p4_a27 in out nocopy JTF_NUMBER_TABLE
81: , p4_a28 in out nocopy JTF_VARCHAR2_TABLE_100
82: , p4_a29 in out nocopy JTF_NUMBER_TABLE
83: , p4_a30 in out nocopy JTF_VARCHAR2_TABLE_100

Line 80: , p4_a27 in out nocopy JTF_NUMBER_TABLE

76: , p4_a23 in out nocopy JTF_VARCHAR2_TABLE_200
77: , p4_a24 in out nocopy JTF_VARCHAR2_TABLE_200
78: , p4_a25 in out nocopy JTF_VARCHAR2_TABLE_200
79: , p4_a26 in out nocopy JTF_NUMBER_TABLE
80: , p4_a27 in out nocopy JTF_NUMBER_TABLE
81: , p4_a28 in out nocopy JTF_VARCHAR2_TABLE_100
82: , p4_a29 in out nocopy JTF_NUMBER_TABLE
83: , p4_a30 in out nocopy JTF_VARCHAR2_TABLE_100
84: , p5_a0 in out nocopy NUMBER

Line 82: , p4_a29 in out nocopy JTF_NUMBER_TABLE

78: , p4_a25 in out nocopy JTF_VARCHAR2_TABLE_200
79: , p4_a26 in out nocopy JTF_NUMBER_TABLE
80: , p4_a27 in out nocopy JTF_NUMBER_TABLE
81: , p4_a28 in out nocopy JTF_VARCHAR2_TABLE_100
82: , p4_a29 in out nocopy JTF_NUMBER_TABLE
83: , p4_a30 in out nocopy JTF_VARCHAR2_TABLE_100
84: , p5_a0 in out nocopy NUMBER
85: , p5_a1 in out nocopy DATE
86: , p5_a2 in out nocopy DATE

Line 132: , p4_a0 JTF_NUMBER_TABLE

128: procedure update_relationship(p_api_version NUMBER
129: , p_commit VARCHAR2
130: , p_init_msg_list VARCHAR2
131: , p_validation_level NUMBER
132: , p4_a0 JTF_NUMBER_TABLE
133: , p4_a1 JTF_VARCHAR2_TABLE_100
134: , p4_a2 JTF_NUMBER_TABLE
135: , p4_a3 JTF_NUMBER_TABLE
136: , p4_a4 JTF_VARCHAR2_TABLE_100

Line 134: , p4_a2 JTF_NUMBER_TABLE

130: , p_init_msg_list VARCHAR2
131: , p_validation_level NUMBER
132: , p4_a0 JTF_NUMBER_TABLE
133: , p4_a1 JTF_VARCHAR2_TABLE_100
134: , p4_a2 JTF_NUMBER_TABLE
135: , p4_a3 JTF_NUMBER_TABLE
136: , p4_a4 JTF_VARCHAR2_TABLE_100
137: , p4_a5 JTF_VARCHAR2_TABLE_100
138: , p4_a6 JTF_DATE_TABLE

Line 135: , p4_a3 JTF_NUMBER_TABLE

131: , p_validation_level NUMBER
132: , p4_a0 JTF_NUMBER_TABLE
133: , p4_a1 JTF_VARCHAR2_TABLE_100
134: , p4_a2 JTF_NUMBER_TABLE
135: , p4_a3 JTF_NUMBER_TABLE
136: , p4_a4 JTF_VARCHAR2_TABLE_100
137: , p4_a5 JTF_VARCHAR2_TABLE_100
138: , p4_a6 JTF_DATE_TABLE
139: , p4_a7 JTF_DATE_TABLE

Line 140: , p4_a8 JTF_NUMBER_TABLE

136: , p4_a4 JTF_VARCHAR2_TABLE_100
137: , p4_a5 JTF_VARCHAR2_TABLE_100
138: , p4_a6 JTF_DATE_TABLE
139: , p4_a7 JTF_DATE_TABLE
140: , p4_a8 JTF_NUMBER_TABLE
141: , p4_a9 JTF_VARCHAR2_TABLE_100
142: , p4_a10 JTF_VARCHAR2_TABLE_100
143: , p4_a11 JTF_VARCHAR2_TABLE_200
144: , p4_a12 JTF_VARCHAR2_TABLE_200

Line 158: , p4_a26 JTF_NUMBER_TABLE

154: , p4_a22 JTF_VARCHAR2_TABLE_200
155: , p4_a23 JTF_VARCHAR2_TABLE_200
156: , p4_a24 JTF_VARCHAR2_TABLE_200
157: , p4_a25 JTF_VARCHAR2_TABLE_200
158: , p4_a26 JTF_NUMBER_TABLE
159: , p4_a27 JTF_NUMBER_TABLE
160: , p4_a28 JTF_VARCHAR2_TABLE_100
161: , p4_a29 JTF_NUMBER_TABLE
162: , p4_a30 JTF_VARCHAR2_TABLE_100

Line 159: , p4_a27 JTF_NUMBER_TABLE

155: , p4_a23 JTF_VARCHAR2_TABLE_200
156: , p4_a24 JTF_VARCHAR2_TABLE_200
157: , p4_a25 JTF_VARCHAR2_TABLE_200
158: , p4_a26 JTF_NUMBER_TABLE
159: , p4_a27 JTF_NUMBER_TABLE
160: , p4_a28 JTF_VARCHAR2_TABLE_100
161: , p4_a29 JTF_NUMBER_TABLE
162: , p4_a30 JTF_VARCHAR2_TABLE_100
163: , p5_a0 in out nocopy NUMBER

Line 161: , p4_a29 JTF_NUMBER_TABLE

157: , p4_a25 JTF_VARCHAR2_TABLE_200
158: , p4_a26 JTF_NUMBER_TABLE
159: , p4_a27 JTF_NUMBER_TABLE
160: , p4_a28 JTF_VARCHAR2_TABLE_100
161: , p4_a29 JTF_NUMBER_TABLE
162: , p4_a30 JTF_VARCHAR2_TABLE_100
163: , p5_a0 in out nocopy NUMBER
164: , p5_a1 in out nocopy DATE
165: , p5_a2 in out nocopy DATE

Line 251: , x_instance_id_lst out nocopy JTF_NUMBER_TABLE

247: , p5_a36 in out nocopy NUMBER
248: , p5_a37 in out nocopy VARCHAR2
249: , p5_a38 in out nocopy DATE
250: , p5_a39 in out nocopy NUMBER
251: , x_instance_id_lst out nocopy JTF_NUMBER_TABLE
252: , x_return_status out nocopy VARCHAR2
253: , x_msg_count out nocopy NUMBER
254: , x_msg_data out nocopy VARCHAR2
255: , p4_a0 NUMBER := 0-1962.0724