APPS.CSI_ASSET_PVT_W dependencies on JTF_VARCHAR2_TABLE_100

Line 3: procedure rosetta_table_copy_in_p1(t out nocopy csi_asset_pvt.lookup_tbl, a0 JTF_VARCHAR2_TABLE_100

1: package csi_asset_pvt_w as
2: /* $Header: csivasws.pls 120.10 2008/01/15 03:33:11 devijay ship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy csi_asset_pvt.lookup_tbl, a0 JTF_VARCHAR2_TABLE_100
4: , a1 JTF_VARCHAR2_TABLE_100
5: );
6: procedure rosetta_table_copy_out_p1(t csi_asset_pvt.lookup_tbl, a0 out nocopy JTF_VARCHAR2_TABLE_100
7: , a1 out nocopy JTF_VARCHAR2_TABLE_100

Line 4: , a1 JTF_VARCHAR2_TABLE_100

1: package csi_asset_pvt_w as
2: /* $Header: csivasws.pls 120.10 2008/01/15 03:33:11 devijay ship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy csi_asset_pvt.lookup_tbl, a0 JTF_VARCHAR2_TABLE_100
4: , a1 JTF_VARCHAR2_TABLE_100
5: );
6: procedure rosetta_table_copy_out_p1(t csi_asset_pvt.lookup_tbl, a0 out nocopy JTF_VARCHAR2_TABLE_100
7: , a1 out nocopy JTF_VARCHAR2_TABLE_100
8: );

Line 6: procedure rosetta_table_copy_out_p1(t csi_asset_pvt.lookup_tbl, a0 out nocopy JTF_VARCHAR2_TABLE_100

2: /* $Header: csivasws.pls 120.10 2008/01/15 03:33:11 devijay ship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy csi_asset_pvt.lookup_tbl, a0 JTF_VARCHAR2_TABLE_100
4: , a1 JTF_VARCHAR2_TABLE_100
5: );
6: procedure rosetta_table_copy_out_p1(t csi_asset_pvt.lookup_tbl, a0 out nocopy JTF_VARCHAR2_TABLE_100
7: , a1 out nocopy JTF_VARCHAR2_TABLE_100
8: );
9:
10: procedure rosetta_table_copy_in_p4(t out nocopy csi_asset_pvt.asset_id_tbl, a0 JTF_NUMBER_TABLE

Line 7: , a1 out nocopy JTF_VARCHAR2_TABLE_100

3: procedure rosetta_table_copy_in_p1(t out nocopy csi_asset_pvt.lookup_tbl, a0 JTF_VARCHAR2_TABLE_100
4: , a1 JTF_VARCHAR2_TABLE_100
5: );
6: procedure rosetta_table_copy_out_p1(t csi_asset_pvt.lookup_tbl, a0 out nocopy JTF_VARCHAR2_TABLE_100
7: , a1 out nocopy JTF_VARCHAR2_TABLE_100
8: );
9:
10: procedure rosetta_table_copy_in_p4(t out nocopy csi_asset_pvt.asset_id_tbl, a0 JTF_NUMBER_TABLE
11: , a1 JTF_VARCHAR2_TABLE_100

Line 11: , a1 JTF_VARCHAR2_TABLE_100

7: , a1 out nocopy JTF_VARCHAR2_TABLE_100
8: );
9:
10: procedure rosetta_table_copy_in_p4(t out nocopy csi_asset_pvt.asset_id_tbl, a0 JTF_NUMBER_TABLE
11: , a1 JTF_VARCHAR2_TABLE_100
12: , a2 JTF_VARCHAR2_TABLE_100
13: );
14: procedure rosetta_table_copy_out_p4(t csi_asset_pvt.asset_id_tbl, a0 out nocopy JTF_NUMBER_TABLE
15: , a1 out nocopy JTF_VARCHAR2_TABLE_100

Line 12: , a2 JTF_VARCHAR2_TABLE_100

8: );
9:
10: procedure rosetta_table_copy_in_p4(t out nocopy csi_asset_pvt.asset_id_tbl, a0 JTF_NUMBER_TABLE
11: , a1 JTF_VARCHAR2_TABLE_100
12: , a2 JTF_VARCHAR2_TABLE_100
13: );
14: procedure rosetta_table_copy_out_p4(t csi_asset_pvt.asset_id_tbl, a0 out nocopy JTF_NUMBER_TABLE
15: , a1 out nocopy JTF_VARCHAR2_TABLE_100
16: , a2 out nocopy JTF_VARCHAR2_TABLE_100

Line 15: , a1 out nocopy JTF_VARCHAR2_TABLE_100

11: , a1 JTF_VARCHAR2_TABLE_100
12: , a2 JTF_VARCHAR2_TABLE_100
13: );
14: procedure rosetta_table_copy_out_p4(t csi_asset_pvt.asset_id_tbl, a0 out nocopy JTF_NUMBER_TABLE
15: , a1 out nocopy JTF_VARCHAR2_TABLE_100
16: , a2 out nocopy JTF_VARCHAR2_TABLE_100
17: );
18:
19: procedure rosetta_table_copy_in_p6(t out nocopy csi_asset_pvt.asset_loc_tbl, a0 JTF_NUMBER_TABLE

Line 16: , a2 out nocopy JTF_VARCHAR2_TABLE_100

12: , a2 JTF_VARCHAR2_TABLE_100
13: );
14: procedure rosetta_table_copy_out_p4(t csi_asset_pvt.asset_id_tbl, a0 out nocopy JTF_NUMBER_TABLE
15: , a1 out nocopy JTF_VARCHAR2_TABLE_100
16: , a2 out nocopy JTF_VARCHAR2_TABLE_100
17: );
18:
19: procedure rosetta_table_copy_in_p6(t out nocopy csi_asset_pvt.asset_loc_tbl, a0 JTF_NUMBER_TABLE
20: , a1 JTF_VARCHAR2_TABLE_100

Line 20: , a1 JTF_VARCHAR2_TABLE_100

16: , a2 out nocopy JTF_VARCHAR2_TABLE_100
17: );
18:
19: procedure rosetta_table_copy_in_p6(t out nocopy csi_asset_pvt.asset_loc_tbl, a0 JTF_NUMBER_TABLE
20: , a1 JTF_VARCHAR2_TABLE_100
21: );
22: procedure rosetta_table_copy_out_p6(t csi_asset_pvt.asset_loc_tbl, a0 out nocopy JTF_NUMBER_TABLE
23: , a1 out nocopy JTF_VARCHAR2_TABLE_100
24: );

Line 23: , a1 out nocopy JTF_VARCHAR2_TABLE_100

19: procedure rosetta_table_copy_in_p6(t out nocopy csi_asset_pvt.asset_loc_tbl, a0 JTF_NUMBER_TABLE
20: , a1 JTF_VARCHAR2_TABLE_100
21: );
22: procedure rosetta_table_copy_out_p6(t csi_asset_pvt.asset_loc_tbl, a0 out nocopy JTF_NUMBER_TABLE
23: , a1 out nocopy JTF_VARCHAR2_TABLE_100
24: );
25:
26: procedure rosetta_table_copy_in_p8(t out nocopy csi_asset_pvt.instance_asset_sync_tbl, a0 JTF_NUMBER_TABLE
27: , a1 JTF_NUMBER_TABLE

Line 54: , a4 JTF_VARCHAR2_TABLE_100

50: procedure rosetta_table_copy_in_p12(t out nocopy csi_asset_pvt.instance_sync_tbl, a0 JTF_NUMBER_TABLE
51: , a1 JTF_NUMBER_TABLE
52: , a2 JTF_NUMBER_TABLE
53: , a3 JTF_NUMBER_TABLE
54: , a4 JTF_VARCHAR2_TABLE_100
55: , a5 JTF_NUMBER_TABLE
56: , a6 JTF_NUMBER_TABLE
57: , a7 JTF_VARCHAR2_TABLE_100
58: );

Line 57: , a7 JTF_VARCHAR2_TABLE_100

53: , a3 JTF_NUMBER_TABLE
54: , a4 JTF_VARCHAR2_TABLE_100
55: , a5 JTF_NUMBER_TABLE
56: , a6 JTF_NUMBER_TABLE
57: , a7 JTF_VARCHAR2_TABLE_100
58: );
59: procedure rosetta_table_copy_out_p12(t csi_asset_pvt.instance_sync_tbl, a0 out nocopy JTF_NUMBER_TABLE
60: , a1 out nocopy JTF_NUMBER_TABLE
61: , a2 out nocopy JTF_NUMBER_TABLE

Line 63: , a4 out nocopy JTF_VARCHAR2_TABLE_100

59: procedure rosetta_table_copy_out_p12(t csi_asset_pvt.instance_sync_tbl, a0 out nocopy JTF_NUMBER_TABLE
60: , a1 out nocopy JTF_NUMBER_TABLE
61: , a2 out nocopy JTF_NUMBER_TABLE
62: , a3 out nocopy JTF_NUMBER_TABLE
63: , a4 out nocopy JTF_VARCHAR2_TABLE_100
64: , a5 out nocopy JTF_NUMBER_TABLE
65: , a6 out nocopy JTF_NUMBER_TABLE
66: , a7 out nocopy JTF_VARCHAR2_TABLE_100
67: );

Line 66: , a7 out nocopy JTF_VARCHAR2_TABLE_100

62: , a3 out nocopy JTF_NUMBER_TABLE
63: , a4 out nocopy JTF_VARCHAR2_TABLE_100
64: , a5 out nocopy JTF_NUMBER_TABLE
65: , a6 out nocopy JTF_NUMBER_TABLE
66: , a7 out nocopy JTF_VARCHAR2_TABLE_100
67: );
68:
69: procedure initialize_asset_rec(p0_a0 in out nocopy NUMBER
70: , p0_a1 in out nocopy NUMBER

Line 102: , p0_a3 in out nocopy JTF_VARCHAR2_TABLE_100

98: );
99: procedure construct_asset_from_hist(p0_a0 in out nocopy JTF_NUMBER_TABLE
100: , p0_a1 in out nocopy JTF_NUMBER_TABLE
101: , p0_a2 in out nocopy JTF_NUMBER_TABLE
102: , p0_a3 in out nocopy JTF_VARCHAR2_TABLE_100
103: , p0_a4 in out nocopy JTF_NUMBER_TABLE
104: , p0_a5 in out nocopy JTF_NUMBER_TABLE
105: , p0_a6 in out nocopy JTF_VARCHAR2_TABLE_100
106: , p0_a7 in out nocopy JTF_DATE_TABLE

Line 105: , p0_a6 in out nocopy JTF_VARCHAR2_TABLE_100

101: , p0_a2 in out nocopy JTF_NUMBER_TABLE
102: , p0_a3 in out nocopy JTF_VARCHAR2_TABLE_100
103: , p0_a4 in out nocopy JTF_NUMBER_TABLE
104: , p0_a5 in out nocopy JTF_NUMBER_TABLE
105: , p0_a6 in out nocopy JTF_VARCHAR2_TABLE_100
106: , p0_a7 in out nocopy JTF_DATE_TABLE
107: , p0_a8 in out nocopy JTF_DATE_TABLE
108: , p0_a9 in out nocopy JTF_NUMBER_TABLE
109: , p0_a10 in out nocopy JTF_VARCHAR2_TABLE_100

Line 109: , p0_a10 in out nocopy JTF_VARCHAR2_TABLE_100

105: , p0_a6 in out nocopy JTF_VARCHAR2_TABLE_100
106: , p0_a7 in out nocopy JTF_DATE_TABLE
107: , p0_a8 in out nocopy JTF_DATE_TABLE
108: , p0_a9 in out nocopy JTF_NUMBER_TABLE
109: , p0_a10 in out nocopy JTF_VARCHAR2_TABLE_100
110: , p0_a11 in out nocopy JTF_VARCHAR2_TABLE_100
111: , p0_a12 in out nocopy JTF_VARCHAR2_TABLE_100
112: , p0_a13 in out nocopy JTF_VARCHAR2_TABLE_100
113: , p0_a14 in out nocopy JTF_VARCHAR2_TABLE_100

Line 110: , p0_a11 in out nocopy JTF_VARCHAR2_TABLE_100

106: , p0_a7 in out nocopy JTF_DATE_TABLE
107: , p0_a8 in out nocopy JTF_DATE_TABLE
108: , p0_a9 in out nocopy JTF_NUMBER_TABLE
109: , p0_a10 in out nocopy JTF_VARCHAR2_TABLE_100
110: , p0_a11 in out nocopy JTF_VARCHAR2_TABLE_100
111: , p0_a12 in out nocopy JTF_VARCHAR2_TABLE_100
112: , p0_a13 in out nocopy JTF_VARCHAR2_TABLE_100
113: , p0_a14 in out nocopy JTF_VARCHAR2_TABLE_100
114: , p0_a15 in out nocopy JTF_VARCHAR2_TABLE_100

Line 111: , p0_a12 in out nocopy JTF_VARCHAR2_TABLE_100

107: , p0_a8 in out nocopy JTF_DATE_TABLE
108: , p0_a9 in out nocopy JTF_NUMBER_TABLE
109: , p0_a10 in out nocopy JTF_VARCHAR2_TABLE_100
110: , p0_a11 in out nocopy JTF_VARCHAR2_TABLE_100
111: , p0_a12 in out nocopy JTF_VARCHAR2_TABLE_100
112: , p0_a13 in out nocopy JTF_VARCHAR2_TABLE_100
113: , p0_a14 in out nocopy JTF_VARCHAR2_TABLE_100
114: , p0_a15 in out nocopy JTF_VARCHAR2_TABLE_100
115: , p0_a16 in out nocopy JTF_VARCHAR2_TABLE_100

Line 112: , p0_a13 in out nocopy JTF_VARCHAR2_TABLE_100

108: , p0_a9 in out nocopy JTF_NUMBER_TABLE
109: , p0_a10 in out nocopy JTF_VARCHAR2_TABLE_100
110: , p0_a11 in out nocopy JTF_VARCHAR2_TABLE_100
111: , p0_a12 in out nocopy JTF_VARCHAR2_TABLE_100
112: , p0_a13 in out nocopy JTF_VARCHAR2_TABLE_100
113: , p0_a14 in out nocopy JTF_VARCHAR2_TABLE_100
114: , p0_a15 in out nocopy JTF_VARCHAR2_TABLE_100
115: , p0_a16 in out nocopy JTF_VARCHAR2_TABLE_100
116: , p0_a17 in out nocopy JTF_VARCHAR2_TABLE_100

Line 113: , p0_a14 in out nocopy JTF_VARCHAR2_TABLE_100

109: , p0_a10 in out nocopy JTF_VARCHAR2_TABLE_100
110: , p0_a11 in out nocopy JTF_VARCHAR2_TABLE_100
111: , p0_a12 in out nocopy JTF_VARCHAR2_TABLE_100
112: , p0_a13 in out nocopy JTF_VARCHAR2_TABLE_100
113: , p0_a14 in out nocopy JTF_VARCHAR2_TABLE_100
114: , p0_a15 in out nocopy JTF_VARCHAR2_TABLE_100
115: , p0_a16 in out nocopy JTF_VARCHAR2_TABLE_100
116: , p0_a17 in out nocopy JTF_VARCHAR2_TABLE_100
117: , p0_a18 in out nocopy JTF_VARCHAR2_TABLE_100

Line 114: , p0_a15 in out nocopy JTF_VARCHAR2_TABLE_100

110: , p0_a11 in out nocopy JTF_VARCHAR2_TABLE_100
111: , p0_a12 in out nocopy JTF_VARCHAR2_TABLE_100
112: , p0_a13 in out nocopy JTF_VARCHAR2_TABLE_100
113: , p0_a14 in out nocopy JTF_VARCHAR2_TABLE_100
114: , p0_a15 in out nocopy JTF_VARCHAR2_TABLE_100
115: , p0_a16 in out nocopy JTF_VARCHAR2_TABLE_100
116: , p0_a17 in out nocopy JTF_VARCHAR2_TABLE_100
117: , p0_a18 in out nocopy JTF_VARCHAR2_TABLE_100
118: , p0_a19 in out nocopy JTF_VARCHAR2_TABLE_100

Line 115: , p0_a16 in out nocopy JTF_VARCHAR2_TABLE_100

111: , p0_a12 in out nocopy JTF_VARCHAR2_TABLE_100
112: , p0_a13 in out nocopy JTF_VARCHAR2_TABLE_100
113: , p0_a14 in out nocopy JTF_VARCHAR2_TABLE_100
114: , p0_a15 in out nocopy JTF_VARCHAR2_TABLE_100
115: , p0_a16 in out nocopy JTF_VARCHAR2_TABLE_100
116: , p0_a17 in out nocopy JTF_VARCHAR2_TABLE_100
117: , p0_a18 in out nocopy JTF_VARCHAR2_TABLE_100
118: , p0_a19 in out nocopy JTF_VARCHAR2_TABLE_100
119: , p0_a20 in out nocopy JTF_VARCHAR2_TABLE_100

Line 116: , p0_a17 in out nocopy JTF_VARCHAR2_TABLE_100

112: , p0_a13 in out nocopy JTF_VARCHAR2_TABLE_100
113: , p0_a14 in out nocopy JTF_VARCHAR2_TABLE_100
114: , p0_a15 in out nocopy JTF_VARCHAR2_TABLE_100
115: , p0_a16 in out nocopy JTF_VARCHAR2_TABLE_100
116: , p0_a17 in out nocopy JTF_VARCHAR2_TABLE_100
117: , p0_a18 in out nocopy JTF_VARCHAR2_TABLE_100
118: , p0_a19 in out nocopy JTF_VARCHAR2_TABLE_100
119: , p0_a20 in out nocopy JTF_VARCHAR2_TABLE_100
120: , p0_a21 in out nocopy JTF_DATE_TABLE

Line 117: , p0_a18 in out nocopy JTF_VARCHAR2_TABLE_100

113: , p0_a14 in out nocopy JTF_VARCHAR2_TABLE_100
114: , p0_a15 in out nocopy JTF_VARCHAR2_TABLE_100
115: , p0_a16 in out nocopy JTF_VARCHAR2_TABLE_100
116: , p0_a17 in out nocopy JTF_VARCHAR2_TABLE_100
117: , p0_a18 in out nocopy JTF_VARCHAR2_TABLE_100
118: , p0_a19 in out nocopy JTF_VARCHAR2_TABLE_100
119: , p0_a20 in out nocopy JTF_VARCHAR2_TABLE_100
120: , p0_a21 in out nocopy JTF_DATE_TABLE
121: , p0_a22 in out nocopy JTF_VARCHAR2_TABLE_100

Line 118: , p0_a19 in out nocopy JTF_VARCHAR2_TABLE_100

114: , p0_a15 in out nocopy JTF_VARCHAR2_TABLE_100
115: , p0_a16 in out nocopy JTF_VARCHAR2_TABLE_100
116: , p0_a17 in out nocopy JTF_VARCHAR2_TABLE_100
117: , p0_a18 in out nocopy JTF_VARCHAR2_TABLE_100
118: , p0_a19 in out nocopy JTF_VARCHAR2_TABLE_100
119: , p0_a20 in out nocopy JTF_VARCHAR2_TABLE_100
120: , p0_a21 in out nocopy JTF_DATE_TABLE
121: , p0_a22 in out nocopy JTF_VARCHAR2_TABLE_100
122: , p0_a23 in out nocopy JTF_VARCHAR2_TABLE_300

Line 119: , p0_a20 in out nocopy JTF_VARCHAR2_TABLE_100

115: , p0_a16 in out nocopy JTF_VARCHAR2_TABLE_100
116: , p0_a17 in out nocopy JTF_VARCHAR2_TABLE_100
117: , p0_a18 in out nocopy JTF_VARCHAR2_TABLE_100
118: , p0_a19 in out nocopy JTF_VARCHAR2_TABLE_100
119: , p0_a20 in out nocopy JTF_VARCHAR2_TABLE_100
120: , p0_a21 in out nocopy JTF_DATE_TABLE
121: , p0_a22 in out nocopy JTF_VARCHAR2_TABLE_100
122: , p0_a23 in out nocopy JTF_VARCHAR2_TABLE_300
123: , p0_a24 in out nocopy JTF_VARCHAR2_TABLE_100

Line 121: , p0_a22 in out nocopy JTF_VARCHAR2_TABLE_100

117: , p0_a18 in out nocopy JTF_VARCHAR2_TABLE_100
118: , p0_a19 in out nocopy JTF_VARCHAR2_TABLE_100
119: , p0_a20 in out nocopy JTF_VARCHAR2_TABLE_100
120: , p0_a21 in out nocopy JTF_DATE_TABLE
121: , p0_a22 in out nocopy JTF_VARCHAR2_TABLE_100
122: , p0_a23 in out nocopy JTF_VARCHAR2_TABLE_300
123: , p0_a24 in out nocopy JTF_VARCHAR2_TABLE_100
124: , p0_a25 in out nocopy JTF_NUMBER_TABLE
125: , p0_a26 in out nocopy JTF_VARCHAR2_TABLE_100

Line 123: , p0_a24 in out nocopy JTF_VARCHAR2_TABLE_100

119: , p0_a20 in out nocopy JTF_VARCHAR2_TABLE_100
120: , p0_a21 in out nocopy JTF_DATE_TABLE
121: , p0_a22 in out nocopy JTF_VARCHAR2_TABLE_100
122: , p0_a23 in out nocopy JTF_VARCHAR2_TABLE_300
123: , p0_a24 in out nocopy JTF_VARCHAR2_TABLE_100
124: , p0_a25 in out nocopy JTF_NUMBER_TABLE
125: , p0_a26 in out nocopy JTF_VARCHAR2_TABLE_100
126: , p_time_stamp date
127: );

Line 125: , p0_a26 in out nocopy JTF_VARCHAR2_TABLE_100

121: , p0_a22 in out nocopy JTF_VARCHAR2_TABLE_100
122: , p0_a23 in out nocopy JTF_VARCHAR2_TABLE_300
123: , p0_a24 in out nocopy JTF_VARCHAR2_TABLE_100
124: , p0_a25 in out nocopy JTF_NUMBER_TABLE
125: , p0_a26 in out nocopy JTF_VARCHAR2_TABLE_100
126: , p_time_stamp date
127: );
128: procedure get_asset_column_values(p_get_asset_cursor_id NUMBER
129: , p1_a0 out nocopy NUMBER

Line 169: , p0_a3 in out nocopy JTF_VARCHAR2_TABLE_100

165: );
166: procedure resolve_id_columns(p0_a0 in out nocopy JTF_NUMBER_TABLE
167: , p0_a1 in out nocopy JTF_NUMBER_TABLE
168: , p0_a2 in out nocopy JTF_NUMBER_TABLE
169: , p0_a3 in out nocopy JTF_VARCHAR2_TABLE_100
170: , p0_a4 in out nocopy JTF_NUMBER_TABLE
171: , p0_a5 in out nocopy JTF_NUMBER_TABLE
172: , p0_a6 in out nocopy JTF_VARCHAR2_TABLE_100
173: , p0_a7 in out nocopy JTF_DATE_TABLE

Line 172: , p0_a6 in out nocopy JTF_VARCHAR2_TABLE_100

168: , p0_a2 in out nocopy JTF_NUMBER_TABLE
169: , p0_a3 in out nocopy JTF_VARCHAR2_TABLE_100
170: , p0_a4 in out nocopy JTF_NUMBER_TABLE
171: , p0_a5 in out nocopy JTF_NUMBER_TABLE
172: , p0_a6 in out nocopy JTF_VARCHAR2_TABLE_100
173: , p0_a7 in out nocopy JTF_DATE_TABLE
174: , p0_a8 in out nocopy JTF_DATE_TABLE
175: , p0_a9 in out nocopy JTF_NUMBER_TABLE
176: , p0_a10 in out nocopy JTF_VARCHAR2_TABLE_100

Line 176: , p0_a10 in out nocopy JTF_VARCHAR2_TABLE_100

172: , p0_a6 in out nocopy JTF_VARCHAR2_TABLE_100
173: , p0_a7 in out nocopy JTF_DATE_TABLE
174: , p0_a8 in out nocopy JTF_DATE_TABLE
175: , p0_a9 in out nocopy JTF_NUMBER_TABLE
176: , p0_a10 in out nocopy JTF_VARCHAR2_TABLE_100
177: , p0_a11 in out nocopy JTF_VARCHAR2_TABLE_100
178: , p0_a12 in out nocopy JTF_VARCHAR2_TABLE_100
179: , p0_a13 in out nocopy JTF_VARCHAR2_TABLE_100
180: , p0_a14 in out nocopy JTF_VARCHAR2_TABLE_100

Line 177: , p0_a11 in out nocopy JTF_VARCHAR2_TABLE_100

173: , p0_a7 in out nocopy JTF_DATE_TABLE
174: , p0_a8 in out nocopy JTF_DATE_TABLE
175: , p0_a9 in out nocopy JTF_NUMBER_TABLE
176: , p0_a10 in out nocopy JTF_VARCHAR2_TABLE_100
177: , p0_a11 in out nocopy JTF_VARCHAR2_TABLE_100
178: , p0_a12 in out nocopy JTF_VARCHAR2_TABLE_100
179: , p0_a13 in out nocopy JTF_VARCHAR2_TABLE_100
180: , p0_a14 in out nocopy JTF_VARCHAR2_TABLE_100
181: , p0_a15 in out nocopy JTF_VARCHAR2_TABLE_100

Line 178: , p0_a12 in out nocopy JTF_VARCHAR2_TABLE_100

174: , p0_a8 in out nocopy JTF_DATE_TABLE
175: , p0_a9 in out nocopy JTF_NUMBER_TABLE
176: , p0_a10 in out nocopy JTF_VARCHAR2_TABLE_100
177: , p0_a11 in out nocopy JTF_VARCHAR2_TABLE_100
178: , p0_a12 in out nocopy JTF_VARCHAR2_TABLE_100
179: , p0_a13 in out nocopy JTF_VARCHAR2_TABLE_100
180: , p0_a14 in out nocopy JTF_VARCHAR2_TABLE_100
181: , p0_a15 in out nocopy JTF_VARCHAR2_TABLE_100
182: , p0_a16 in out nocopy JTF_VARCHAR2_TABLE_100

Line 179: , p0_a13 in out nocopy JTF_VARCHAR2_TABLE_100

175: , p0_a9 in out nocopy JTF_NUMBER_TABLE
176: , p0_a10 in out nocopy JTF_VARCHAR2_TABLE_100
177: , p0_a11 in out nocopy JTF_VARCHAR2_TABLE_100
178: , p0_a12 in out nocopy JTF_VARCHAR2_TABLE_100
179: , p0_a13 in out nocopy JTF_VARCHAR2_TABLE_100
180: , p0_a14 in out nocopy JTF_VARCHAR2_TABLE_100
181: , p0_a15 in out nocopy JTF_VARCHAR2_TABLE_100
182: , p0_a16 in out nocopy JTF_VARCHAR2_TABLE_100
183: , p0_a17 in out nocopy JTF_VARCHAR2_TABLE_100

Line 180: , p0_a14 in out nocopy JTF_VARCHAR2_TABLE_100

176: , p0_a10 in out nocopy JTF_VARCHAR2_TABLE_100
177: , p0_a11 in out nocopy JTF_VARCHAR2_TABLE_100
178: , p0_a12 in out nocopy JTF_VARCHAR2_TABLE_100
179: , p0_a13 in out nocopy JTF_VARCHAR2_TABLE_100
180: , p0_a14 in out nocopy JTF_VARCHAR2_TABLE_100
181: , p0_a15 in out nocopy JTF_VARCHAR2_TABLE_100
182: , p0_a16 in out nocopy JTF_VARCHAR2_TABLE_100
183: , p0_a17 in out nocopy JTF_VARCHAR2_TABLE_100
184: , p0_a18 in out nocopy JTF_VARCHAR2_TABLE_100

Line 181: , p0_a15 in out nocopy JTF_VARCHAR2_TABLE_100

177: , p0_a11 in out nocopy JTF_VARCHAR2_TABLE_100
178: , p0_a12 in out nocopy JTF_VARCHAR2_TABLE_100
179: , p0_a13 in out nocopy JTF_VARCHAR2_TABLE_100
180: , p0_a14 in out nocopy JTF_VARCHAR2_TABLE_100
181: , p0_a15 in out nocopy JTF_VARCHAR2_TABLE_100
182: , p0_a16 in out nocopy JTF_VARCHAR2_TABLE_100
183: , p0_a17 in out nocopy JTF_VARCHAR2_TABLE_100
184: , p0_a18 in out nocopy JTF_VARCHAR2_TABLE_100
185: , p0_a19 in out nocopy JTF_VARCHAR2_TABLE_100

Line 182: , p0_a16 in out nocopy JTF_VARCHAR2_TABLE_100

178: , p0_a12 in out nocopy JTF_VARCHAR2_TABLE_100
179: , p0_a13 in out nocopy JTF_VARCHAR2_TABLE_100
180: , p0_a14 in out nocopy JTF_VARCHAR2_TABLE_100
181: , p0_a15 in out nocopy JTF_VARCHAR2_TABLE_100
182: , p0_a16 in out nocopy JTF_VARCHAR2_TABLE_100
183: , p0_a17 in out nocopy JTF_VARCHAR2_TABLE_100
184: , p0_a18 in out nocopy JTF_VARCHAR2_TABLE_100
185: , p0_a19 in out nocopy JTF_VARCHAR2_TABLE_100
186: , p0_a20 in out nocopy JTF_VARCHAR2_TABLE_100

Line 183: , p0_a17 in out nocopy JTF_VARCHAR2_TABLE_100

179: , p0_a13 in out nocopy JTF_VARCHAR2_TABLE_100
180: , p0_a14 in out nocopy JTF_VARCHAR2_TABLE_100
181: , p0_a15 in out nocopy JTF_VARCHAR2_TABLE_100
182: , p0_a16 in out nocopy JTF_VARCHAR2_TABLE_100
183: , p0_a17 in out nocopy JTF_VARCHAR2_TABLE_100
184: , p0_a18 in out nocopy JTF_VARCHAR2_TABLE_100
185: , p0_a19 in out nocopy JTF_VARCHAR2_TABLE_100
186: , p0_a20 in out nocopy JTF_VARCHAR2_TABLE_100
187: , p0_a21 in out nocopy JTF_DATE_TABLE

Line 184: , p0_a18 in out nocopy JTF_VARCHAR2_TABLE_100

180: , p0_a14 in out nocopy JTF_VARCHAR2_TABLE_100
181: , p0_a15 in out nocopy JTF_VARCHAR2_TABLE_100
182: , p0_a16 in out nocopy JTF_VARCHAR2_TABLE_100
183: , p0_a17 in out nocopy JTF_VARCHAR2_TABLE_100
184: , p0_a18 in out nocopy JTF_VARCHAR2_TABLE_100
185: , p0_a19 in out nocopy JTF_VARCHAR2_TABLE_100
186: , p0_a20 in out nocopy JTF_VARCHAR2_TABLE_100
187: , p0_a21 in out nocopy JTF_DATE_TABLE
188: , p0_a22 in out nocopy JTF_VARCHAR2_TABLE_100

Line 185: , p0_a19 in out nocopy JTF_VARCHAR2_TABLE_100

181: , p0_a15 in out nocopy JTF_VARCHAR2_TABLE_100
182: , p0_a16 in out nocopy JTF_VARCHAR2_TABLE_100
183: , p0_a17 in out nocopy JTF_VARCHAR2_TABLE_100
184: , p0_a18 in out nocopy JTF_VARCHAR2_TABLE_100
185: , p0_a19 in out nocopy JTF_VARCHAR2_TABLE_100
186: , p0_a20 in out nocopy JTF_VARCHAR2_TABLE_100
187: , p0_a21 in out nocopy JTF_DATE_TABLE
188: , p0_a22 in out nocopy JTF_VARCHAR2_TABLE_100
189: , p0_a23 in out nocopy JTF_VARCHAR2_TABLE_300

Line 186: , p0_a20 in out nocopy JTF_VARCHAR2_TABLE_100

182: , p0_a16 in out nocopy JTF_VARCHAR2_TABLE_100
183: , p0_a17 in out nocopy JTF_VARCHAR2_TABLE_100
184: , p0_a18 in out nocopy JTF_VARCHAR2_TABLE_100
185: , p0_a19 in out nocopy JTF_VARCHAR2_TABLE_100
186: , p0_a20 in out nocopy JTF_VARCHAR2_TABLE_100
187: , p0_a21 in out nocopy JTF_DATE_TABLE
188: , p0_a22 in out nocopy JTF_VARCHAR2_TABLE_100
189: , p0_a23 in out nocopy JTF_VARCHAR2_TABLE_300
190: , p0_a24 in out nocopy JTF_VARCHAR2_TABLE_100

Line 188: , p0_a22 in out nocopy JTF_VARCHAR2_TABLE_100

184: , p0_a18 in out nocopy JTF_VARCHAR2_TABLE_100
185: , p0_a19 in out nocopy JTF_VARCHAR2_TABLE_100
186: , p0_a20 in out nocopy JTF_VARCHAR2_TABLE_100
187: , p0_a21 in out nocopy JTF_DATE_TABLE
188: , p0_a22 in out nocopy JTF_VARCHAR2_TABLE_100
189: , p0_a23 in out nocopy JTF_VARCHAR2_TABLE_300
190: , p0_a24 in out nocopy JTF_VARCHAR2_TABLE_100
191: , p0_a25 in out nocopy JTF_NUMBER_TABLE
192: , p0_a26 in out nocopy JTF_VARCHAR2_TABLE_100

Line 190: , p0_a24 in out nocopy JTF_VARCHAR2_TABLE_100

186: , p0_a20 in out nocopy JTF_VARCHAR2_TABLE_100
187: , p0_a21 in out nocopy JTF_DATE_TABLE
188: , p0_a22 in out nocopy JTF_VARCHAR2_TABLE_100
189: , p0_a23 in out nocopy JTF_VARCHAR2_TABLE_300
190: , p0_a24 in out nocopy JTF_VARCHAR2_TABLE_100
191: , p0_a25 in out nocopy JTF_NUMBER_TABLE
192: , p0_a26 in out nocopy JTF_VARCHAR2_TABLE_100
193: );
194: procedure gen_asset_where_clause(x_where_clause out nocopy VARCHAR2

Line 192: , p0_a26 in out nocopy JTF_VARCHAR2_TABLE_100

188: , p0_a22 in out nocopy JTF_VARCHAR2_TABLE_100
189: , p0_a23 in out nocopy JTF_VARCHAR2_TABLE_300
190: , p0_a24 in out nocopy JTF_VARCHAR2_TABLE_100
191: , p0_a25 in out nocopy JTF_NUMBER_TABLE
192: , p0_a26 in out nocopy JTF_VARCHAR2_TABLE_100
193: );
194: procedure gen_asset_where_clause(x_where_clause out nocopy VARCHAR2
195: , p0_a0 NUMBER := 0-1962.0724
196: , p0_a1 NUMBER := 0-1962.0724

Line 212: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_100

208: , p_time_stamp date
209: , p7_a0 out nocopy JTF_NUMBER_TABLE
210: , p7_a1 out nocopy JTF_NUMBER_TABLE
211: , p7_a2 out nocopy JTF_NUMBER_TABLE
212: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_100
213: , p7_a4 out nocopy JTF_NUMBER_TABLE
214: , p7_a5 out nocopy JTF_NUMBER_TABLE
215: , p7_a6 out nocopy JTF_VARCHAR2_TABLE_100
216: , p7_a7 out nocopy JTF_DATE_TABLE

Line 215: , p7_a6 out nocopy JTF_VARCHAR2_TABLE_100

211: , p7_a2 out nocopy JTF_NUMBER_TABLE
212: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_100
213: , p7_a4 out nocopy JTF_NUMBER_TABLE
214: , p7_a5 out nocopy JTF_NUMBER_TABLE
215: , p7_a6 out nocopy JTF_VARCHAR2_TABLE_100
216: , p7_a7 out nocopy JTF_DATE_TABLE
217: , p7_a8 out nocopy JTF_DATE_TABLE
218: , p7_a9 out nocopy JTF_NUMBER_TABLE
219: , p7_a10 out nocopy JTF_VARCHAR2_TABLE_100

Line 219: , p7_a10 out nocopy JTF_VARCHAR2_TABLE_100

215: , p7_a6 out nocopy JTF_VARCHAR2_TABLE_100
216: , p7_a7 out nocopy JTF_DATE_TABLE
217: , p7_a8 out nocopy JTF_DATE_TABLE
218: , p7_a9 out nocopy JTF_NUMBER_TABLE
219: , p7_a10 out nocopy JTF_VARCHAR2_TABLE_100
220: , p7_a11 out nocopy JTF_VARCHAR2_TABLE_100
221: , p7_a12 out nocopy JTF_VARCHAR2_TABLE_100
222: , p7_a13 out nocopy JTF_VARCHAR2_TABLE_100
223: , p7_a14 out nocopy JTF_VARCHAR2_TABLE_100

Line 220: , p7_a11 out nocopy JTF_VARCHAR2_TABLE_100

216: , p7_a7 out nocopy JTF_DATE_TABLE
217: , p7_a8 out nocopy JTF_DATE_TABLE
218: , p7_a9 out nocopy JTF_NUMBER_TABLE
219: , p7_a10 out nocopy JTF_VARCHAR2_TABLE_100
220: , p7_a11 out nocopy JTF_VARCHAR2_TABLE_100
221: , p7_a12 out nocopy JTF_VARCHAR2_TABLE_100
222: , p7_a13 out nocopy JTF_VARCHAR2_TABLE_100
223: , p7_a14 out nocopy JTF_VARCHAR2_TABLE_100
224: , p7_a15 out nocopy JTF_VARCHAR2_TABLE_100

Line 221: , p7_a12 out nocopy JTF_VARCHAR2_TABLE_100

217: , p7_a8 out nocopy JTF_DATE_TABLE
218: , p7_a9 out nocopy JTF_NUMBER_TABLE
219: , p7_a10 out nocopy JTF_VARCHAR2_TABLE_100
220: , p7_a11 out nocopy JTF_VARCHAR2_TABLE_100
221: , p7_a12 out nocopy JTF_VARCHAR2_TABLE_100
222: , p7_a13 out nocopy JTF_VARCHAR2_TABLE_100
223: , p7_a14 out nocopy JTF_VARCHAR2_TABLE_100
224: , p7_a15 out nocopy JTF_VARCHAR2_TABLE_100
225: , p7_a16 out nocopy JTF_VARCHAR2_TABLE_100

Line 222: , p7_a13 out nocopy JTF_VARCHAR2_TABLE_100

218: , p7_a9 out nocopy JTF_NUMBER_TABLE
219: , p7_a10 out nocopy JTF_VARCHAR2_TABLE_100
220: , p7_a11 out nocopy JTF_VARCHAR2_TABLE_100
221: , p7_a12 out nocopy JTF_VARCHAR2_TABLE_100
222: , p7_a13 out nocopy JTF_VARCHAR2_TABLE_100
223: , p7_a14 out nocopy JTF_VARCHAR2_TABLE_100
224: , p7_a15 out nocopy JTF_VARCHAR2_TABLE_100
225: , p7_a16 out nocopy JTF_VARCHAR2_TABLE_100
226: , p7_a17 out nocopy JTF_VARCHAR2_TABLE_100

Line 223: , p7_a14 out nocopy JTF_VARCHAR2_TABLE_100

219: , p7_a10 out nocopy JTF_VARCHAR2_TABLE_100
220: , p7_a11 out nocopy JTF_VARCHAR2_TABLE_100
221: , p7_a12 out nocopy JTF_VARCHAR2_TABLE_100
222: , p7_a13 out nocopy JTF_VARCHAR2_TABLE_100
223: , p7_a14 out nocopy JTF_VARCHAR2_TABLE_100
224: , p7_a15 out nocopy JTF_VARCHAR2_TABLE_100
225: , p7_a16 out nocopy JTF_VARCHAR2_TABLE_100
226: , p7_a17 out nocopy JTF_VARCHAR2_TABLE_100
227: , p7_a18 out nocopy JTF_VARCHAR2_TABLE_100

Line 224: , p7_a15 out nocopy JTF_VARCHAR2_TABLE_100

220: , p7_a11 out nocopy JTF_VARCHAR2_TABLE_100
221: , p7_a12 out nocopy JTF_VARCHAR2_TABLE_100
222: , p7_a13 out nocopy JTF_VARCHAR2_TABLE_100
223: , p7_a14 out nocopy JTF_VARCHAR2_TABLE_100
224: , p7_a15 out nocopy JTF_VARCHAR2_TABLE_100
225: , p7_a16 out nocopy JTF_VARCHAR2_TABLE_100
226: , p7_a17 out nocopy JTF_VARCHAR2_TABLE_100
227: , p7_a18 out nocopy JTF_VARCHAR2_TABLE_100
228: , p7_a19 out nocopy JTF_VARCHAR2_TABLE_100

Line 225: , p7_a16 out nocopy JTF_VARCHAR2_TABLE_100

221: , p7_a12 out nocopy JTF_VARCHAR2_TABLE_100
222: , p7_a13 out nocopy JTF_VARCHAR2_TABLE_100
223: , p7_a14 out nocopy JTF_VARCHAR2_TABLE_100
224: , p7_a15 out nocopy JTF_VARCHAR2_TABLE_100
225: , p7_a16 out nocopy JTF_VARCHAR2_TABLE_100
226: , p7_a17 out nocopy JTF_VARCHAR2_TABLE_100
227: , p7_a18 out nocopy JTF_VARCHAR2_TABLE_100
228: , p7_a19 out nocopy JTF_VARCHAR2_TABLE_100
229: , p7_a20 out nocopy JTF_VARCHAR2_TABLE_100

Line 226: , p7_a17 out nocopy JTF_VARCHAR2_TABLE_100

222: , p7_a13 out nocopy JTF_VARCHAR2_TABLE_100
223: , p7_a14 out nocopy JTF_VARCHAR2_TABLE_100
224: , p7_a15 out nocopy JTF_VARCHAR2_TABLE_100
225: , p7_a16 out nocopy JTF_VARCHAR2_TABLE_100
226: , p7_a17 out nocopy JTF_VARCHAR2_TABLE_100
227: , p7_a18 out nocopy JTF_VARCHAR2_TABLE_100
228: , p7_a19 out nocopy JTF_VARCHAR2_TABLE_100
229: , p7_a20 out nocopy JTF_VARCHAR2_TABLE_100
230: , p7_a21 out nocopy JTF_DATE_TABLE

Line 227: , p7_a18 out nocopy JTF_VARCHAR2_TABLE_100

223: , p7_a14 out nocopy JTF_VARCHAR2_TABLE_100
224: , p7_a15 out nocopy JTF_VARCHAR2_TABLE_100
225: , p7_a16 out nocopy JTF_VARCHAR2_TABLE_100
226: , p7_a17 out nocopy JTF_VARCHAR2_TABLE_100
227: , p7_a18 out nocopy JTF_VARCHAR2_TABLE_100
228: , p7_a19 out nocopy JTF_VARCHAR2_TABLE_100
229: , p7_a20 out nocopy JTF_VARCHAR2_TABLE_100
230: , p7_a21 out nocopy JTF_DATE_TABLE
231: , p7_a22 out nocopy JTF_VARCHAR2_TABLE_100

Line 228: , p7_a19 out nocopy JTF_VARCHAR2_TABLE_100

224: , p7_a15 out nocopy JTF_VARCHAR2_TABLE_100
225: , p7_a16 out nocopy JTF_VARCHAR2_TABLE_100
226: , p7_a17 out nocopy JTF_VARCHAR2_TABLE_100
227: , p7_a18 out nocopy JTF_VARCHAR2_TABLE_100
228: , p7_a19 out nocopy JTF_VARCHAR2_TABLE_100
229: , p7_a20 out nocopy JTF_VARCHAR2_TABLE_100
230: , p7_a21 out nocopy JTF_DATE_TABLE
231: , p7_a22 out nocopy JTF_VARCHAR2_TABLE_100
232: , p7_a23 out nocopy JTF_VARCHAR2_TABLE_300

Line 229: , p7_a20 out nocopy JTF_VARCHAR2_TABLE_100

225: , p7_a16 out nocopy JTF_VARCHAR2_TABLE_100
226: , p7_a17 out nocopy JTF_VARCHAR2_TABLE_100
227: , p7_a18 out nocopy JTF_VARCHAR2_TABLE_100
228: , p7_a19 out nocopy JTF_VARCHAR2_TABLE_100
229: , p7_a20 out nocopy JTF_VARCHAR2_TABLE_100
230: , p7_a21 out nocopy JTF_DATE_TABLE
231: , p7_a22 out nocopy JTF_VARCHAR2_TABLE_100
232: , p7_a23 out nocopy JTF_VARCHAR2_TABLE_300
233: , p7_a24 out nocopy JTF_VARCHAR2_TABLE_100

Line 231: , p7_a22 out nocopy JTF_VARCHAR2_TABLE_100

227: , p7_a18 out nocopy JTF_VARCHAR2_TABLE_100
228: , p7_a19 out nocopy JTF_VARCHAR2_TABLE_100
229: , p7_a20 out nocopy JTF_VARCHAR2_TABLE_100
230: , p7_a21 out nocopy JTF_DATE_TABLE
231: , p7_a22 out nocopy JTF_VARCHAR2_TABLE_100
232: , p7_a23 out nocopy JTF_VARCHAR2_TABLE_300
233: , p7_a24 out nocopy JTF_VARCHAR2_TABLE_100
234: , p7_a25 out nocopy JTF_NUMBER_TABLE
235: , p7_a26 out nocopy JTF_VARCHAR2_TABLE_100

Line 233: , p7_a24 out nocopy JTF_VARCHAR2_TABLE_100

229: , p7_a20 out nocopy JTF_VARCHAR2_TABLE_100
230: , p7_a21 out nocopy JTF_DATE_TABLE
231: , p7_a22 out nocopy JTF_VARCHAR2_TABLE_100
232: , p7_a23 out nocopy JTF_VARCHAR2_TABLE_300
233: , p7_a24 out nocopy JTF_VARCHAR2_TABLE_100
234: , p7_a25 out nocopy JTF_NUMBER_TABLE
235: , p7_a26 out nocopy JTF_VARCHAR2_TABLE_100
236: , x_return_status out nocopy VARCHAR2
237: , x_msg_count out nocopy NUMBER

Line 235: , p7_a26 out nocopy JTF_VARCHAR2_TABLE_100

231: , p7_a22 out nocopy JTF_VARCHAR2_TABLE_100
232: , p7_a23 out nocopy JTF_VARCHAR2_TABLE_300
233: , p7_a24 out nocopy JTF_VARCHAR2_TABLE_100
234: , p7_a25 out nocopy JTF_NUMBER_TABLE
235: , p7_a26 out nocopy JTF_VARCHAR2_TABLE_100
236: , x_return_status out nocopy VARCHAR2
237: , x_msg_count out nocopy NUMBER
238: , x_msg_data out nocopy VARCHAR2
239: , p4_a0 NUMBER := 0-1962.0724

Line 310: , p9_a0 in out nocopy JTF_VARCHAR2_TABLE_100

306: , p5_a39 in out nocopy NUMBER
307: , x_return_status out nocopy VARCHAR2
308: , x_msg_count out nocopy NUMBER
309: , x_msg_data out nocopy VARCHAR2
310: , p9_a0 in out nocopy JTF_VARCHAR2_TABLE_100
311: , p9_a1 in out nocopy JTF_VARCHAR2_TABLE_100
312: , p10_a0 in out nocopy NUMBER
313: , p10_a1 in out nocopy NUMBER
314: , p10_a2 in out nocopy NUMBER

Line 311: , p9_a1 in out nocopy JTF_VARCHAR2_TABLE_100

307: , x_return_status out nocopy VARCHAR2
308: , x_msg_count out nocopy NUMBER
309: , x_msg_data out nocopy VARCHAR2
310: , p9_a0 in out nocopy JTF_VARCHAR2_TABLE_100
311: , p9_a1 in out nocopy JTF_VARCHAR2_TABLE_100
312: , p10_a0 in out nocopy NUMBER
313: , p10_a1 in out nocopy NUMBER
314: , p10_a2 in out nocopy NUMBER
315: , p11_a0 in out nocopy JTF_NUMBER_TABLE

Line 316: , p11_a1 in out nocopy JTF_VARCHAR2_TABLE_100

312: , p10_a0 in out nocopy NUMBER
313: , p10_a1 in out nocopy NUMBER
314: , p10_a2 in out nocopy NUMBER
315: , p11_a0 in out nocopy JTF_NUMBER_TABLE
316: , p11_a1 in out nocopy JTF_VARCHAR2_TABLE_100
317: , p11_a2 in out nocopy JTF_VARCHAR2_TABLE_100
318: , p12_a0 in out nocopy JTF_NUMBER_TABLE
319: , p12_a1 in out nocopy JTF_VARCHAR2_TABLE_100
320: , p_called_from_grp VARCHAR2

Line 317: , p11_a2 in out nocopy JTF_VARCHAR2_TABLE_100

313: , p10_a1 in out nocopy NUMBER
314: , p10_a2 in out nocopy NUMBER
315: , p11_a0 in out nocopy JTF_NUMBER_TABLE
316: , p11_a1 in out nocopy JTF_VARCHAR2_TABLE_100
317: , p11_a2 in out nocopy JTF_VARCHAR2_TABLE_100
318: , p12_a0 in out nocopy JTF_NUMBER_TABLE
319: , p12_a1 in out nocopy JTF_VARCHAR2_TABLE_100
320: , p_called_from_grp VARCHAR2
321: );

Line 319: , p12_a1 in out nocopy JTF_VARCHAR2_TABLE_100

315: , p11_a0 in out nocopy JTF_NUMBER_TABLE
316: , p11_a1 in out nocopy JTF_VARCHAR2_TABLE_100
317: , p11_a2 in out nocopy JTF_VARCHAR2_TABLE_100
318: , p12_a0 in out nocopy JTF_NUMBER_TABLE
319: , p12_a1 in out nocopy JTF_VARCHAR2_TABLE_100
320: , p_called_from_grp VARCHAR2
321: );
322: procedure update_instance_asset(p_api_version NUMBER
323: , p_commit VARCHAR2

Line 385: , p9_a0 in out nocopy JTF_VARCHAR2_TABLE_100

381: , p5_a39 in out nocopy NUMBER
382: , x_return_status out nocopy VARCHAR2
383: , x_msg_count out nocopy NUMBER
384: , x_msg_data out nocopy VARCHAR2
385: , p9_a0 in out nocopy JTF_VARCHAR2_TABLE_100
386: , p9_a1 in out nocopy JTF_VARCHAR2_TABLE_100
387: , p10_a0 in out nocopy NUMBER
388: , p10_a1 in out nocopy NUMBER
389: , p10_a2 in out nocopy NUMBER

Line 386: , p9_a1 in out nocopy JTF_VARCHAR2_TABLE_100

382: , x_return_status out nocopy VARCHAR2
383: , x_msg_count out nocopy NUMBER
384: , x_msg_data out nocopy VARCHAR2
385: , p9_a0 in out nocopy JTF_VARCHAR2_TABLE_100
386: , p9_a1 in out nocopy JTF_VARCHAR2_TABLE_100
387: , p10_a0 in out nocopy NUMBER
388: , p10_a1 in out nocopy NUMBER
389: , p10_a2 in out nocopy NUMBER
390: , p11_a0 in out nocopy JTF_NUMBER_TABLE

Line 391: , p11_a1 in out nocopy JTF_VARCHAR2_TABLE_100

387: , p10_a0 in out nocopy NUMBER
388: , p10_a1 in out nocopy NUMBER
389: , p10_a2 in out nocopy NUMBER
390: , p11_a0 in out nocopy JTF_NUMBER_TABLE
391: , p11_a1 in out nocopy JTF_VARCHAR2_TABLE_100
392: , p11_a2 in out nocopy JTF_VARCHAR2_TABLE_100
393: , p12_a0 in out nocopy JTF_NUMBER_TABLE
394: , p12_a1 in out nocopy JTF_VARCHAR2_TABLE_100
395: );

Line 392: , p11_a2 in out nocopy JTF_VARCHAR2_TABLE_100

388: , p10_a1 in out nocopy NUMBER
389: , p10_a2 in out nocopy NUMBER
390: , p11_a0 in out nocopy JTF_NUMBER_TABLE
391: , p11_a1 in out nocopy JTF_VARCHAR2_TABLE_100
392: , p11_a2 in out nocopy JTF_VARCHAR2_TABLE_100
393: , p12_a0 in out nocopy JTF_NUMBER_TABLE
394: , p12_a1 in out nocopy JTF_VARCHAR2_TABLE_100
395: );
396: procedure get_instance_asset_hist(p_api_version NUMBER

Line 394: , p12_a1 in out nocopy JTF_VARCHAR2_TABLE_100

390: , p11_a0 in out nocopy JTF_NUMBER_TABLE
391: , p11_a1 in out nocopy JTF_VARCHAR2_TABLE_100
392: , p11_a2 in out nocopy JTF_VARCHAR2_TABLE_100
393: , p12_a0 in out nocopy JTF_NUMBER_TABLE
394: , p12_a1 in out nocopy JTF_VARCHAR2_TABLE_100
395: );
396: procedure get_instance_asset_hist(p_api_version NUMBER
397: , p_commit VARCHAR2
398: , p_init_msg_list VARCHAR2

Line 406: , p5_a5 out nocopy JTF_VARCHAR2_TABLE_100

402: , p5_a1 out nocopy JTF_NUMBER_TABLE
403: , p5_a2 out nocopy JTF_NUMBER_TABLE
404: , p5_a3 out nocopy JTF_NUMBER_TABLE
405: , p5_a4 out nocopy JTF_NUMBER_TABLE
406: , p5_a5 out nocopy JTF_VARCHAR2_TABLE_100
407: , p5_a6 out nocopy JTF_VARCHAR2_TABLE_100
408: , p5_a7 out nocopy JTF_NUMBER_TABLE
409: , p5_a8 out nocopy JTF_NUMBER_TABLE
410: , p5_a9 out nocopy JTF_NUMBER_TABLE

Line 407: , p5_a6 out nocopy JTF_VARCHAR2_TABLE_100

403: , p5_a2 out nocopy JTF_NUMBER_TABLE
404: , p5_a3 out nocopy JTF_NUMBER_TABLE
405: , p5_a4 out nocopy JTF_NUMBER_TABLE
406: , p5_a5 out nocopy JTF_VARCHAR2_TABLE_100
407: , p5_a6 out nocopy JTF_VARCHAR2_TABLE_100
408: , p5_a7 out nocopy JTF_NUMBER_TABLE
409: , p5_a8 out nocopy JTF_NUMBER_TABLE
410: , p5_a9 out nocopy JTF_NUMBER_TABLE
411: , p5_a10 out nocopy JTF_NUMBER_TABLE

Line 412: , p5_a11 out nocopy JTF_VARCHAR2_TABLE_100

408: , p5_a7 out nocopy JTF_NUMBER_TABLE
409: , p5_a8 out nocopy JTF_NUMBER_TABLE
410: , p5_a9 out nocopy JTF_NUMBER_TABLE
411: , p5_a10 out nocopy JTF_NUMBER_TABLE
412: , p5_a11 out nocopy JTF_VARCHAR2_TABLE_100
413: , p5_a12 out nocopy JTF_VARCHAR2_TABLE_100
414: , p5_a13 out nocopy JTF_DATE_TABLE
415: , p5_a14 out nocopy JTF_DATE_TABLE
416: , p5_a15 out nocopy JTF_DATE_TABLE

Line 413: , p5_a12 out nocopy JTF_VARCHAR2_TABLE_100

409: , p5_a8 out nocopy JTF_NUMBER_TABLE
410: , p5_a9 out nocopy JTF_NUMBER_TABLE
411: , p5_a10 out nocopy JTF_NUMBER_TABLE
412: , p5_a11 out nocopy JTF_VARCHAR2_TABLE_100
413: , p5_a12 out nocopy JTF_VARCHAR2_TABLE_100
414: , p5_a13 out nocopy JTF_DATE_TABLE
415: , p5_a14 out nocopy JTF_DATE_TABLE
416: , p5_a15 out nocopy JTF_DATE_TABLE
417: , p5_a16 out nocopy JTF_DATE_TABLE

Line 418: , p5_a17 out nocopy JTF_VARCHAR2_TABLE_100

414: , p5_a13 out nocopy JTF_DATE_TABLE
415: , p5_a14 out nocopy JTF_DATE_TABLE
416: , p5_a15 out nocopy JTF_DATE_TABLE
417: , p5_a16 out nocopy JTF_DATE_TABLE
418: , p5_a17 out nocopy JTF_VARCHAR2_TABLE_100
419: , p5_a18 out nocopy JTF_VARCHAR2_TABLE_100
420: , p5_a19 out nocopy JTF_VARCHAR2_TABLE_100
421: , p5_a20 out nocopy JTF_VARCHAR2_TABLE_100
422: , p5_a21 out nocopy JTF_VARCHAR2_TABLE_100

Line 419: , p5_a18 out nocopy JTF_VARCHAR2_TABLE_100

415: , p5_a14 out nocopy JTF_DATE_TABLE
416: , p5_a15 out nocopy JTF_DATE_TABLE
417: , p5_a16 out nocopy JTF_DATE_TABLE
418: , p5_a17 out nocopy JTF_VARCHAR2_TABLE_100
419: , p5_a18 out nocopy JTF_VARCHAR2_TABLE_100
420: , p5_a19 out nocopy JTF_VARCHAR2_TABLE_100
421: , p5_a20 out nocopy JTF_VARCHAR2_TABLE_100
422: , p5_a21 out nocopy JTF_VARCHAR2_TABLE_100
423: , p5_a22 out nocopy JTF_VARCHAR2_TABLE_100

Line 420: , p5_a19 out nocopy JTF_VARCHAR2_TABLE_100

416: , p5_a15 out nocopy JTF_DATE_TABLE
417: , p5_a16 out nocopy JTF_DATE_TABLE
418: , p5_a17 out nocopy JTF_VARCHAR2_TABLE_100
419: , p5_a18 out nocopy JTF_VARCHAR2_TABLE_100
420: , p5_a19 out nocopy JTF_VARCHAR2_TABLE_100
421: , p5_a20 out nocopy JTF_VARCHAR2_TABLE_100
422: , p5_a21 out nocopy JTF_VARCHAR2_TABLE_100
423: , p5_a22 out nocopy JTF_VARCHAR2_TABLE_100
424: , p5_a23 out nocopy JTF_VARCHAR2_TABLE_100

Line 421: , p5_a20 out nocopy JTF_VARCHAR2_TABLE_100

417: , p5_a16 out nocopy JTF_DATE_TABLE
418: , p5_a17 out nocopy JTF_VARCHAR2_TABLE_100
419: , p5_a18 out nocopy JTF_VARCHAR2_TABLE_100
420: , p5_a19 out nocopy JTF_VARCHAR2_TABLE_100
421: , p5_a20 out nocopy JTF_VARCHAR2_TABLE_100
422: , p5_a21 out nocopy JTF_VARCHAR2_TABLE_100
423: , p5_a22 out nocopy JTF_VARCHAR2_TABLE_100
424: , p5_a23 out nocopy JTF_VARCHAR2_TABLE_100
425: , p5_a24 out nocopy JTF_VARCHAR2_TABLE_100

Line 422: , p5_a21 out nocopy JTF_VARCHAR2_TABLE_100

418: , p5_a17 out nocopy JTF_VARCHAR2_TABLE_100
419: , p5_a18 out nocopy JTF_VARCHAR2_TABLE_100
420: , p5_a19 out nocopy JTF_VARCHAR2_TABLE_100
421: , p5_a20 out nocopy JTF_VARCHAR2_TABLE_100
422: , p5_a21 out nocopy JTF_VARCHAR2_TABLE_100
423: , p5_a22 out nocopy JTF_VARCHAR2_TABLE_100
424: , p5_a23 out nocopy JTF_VARCHAR2_TABLE_100
425: , p5_a24 out nocopy JTF_VARCHAR2_TABLE_100
426: , p5_a25 out nocopy JTF_VARCHAR2_TABLE_100

Line 423: , p5_a22 out nocopy JTF_VARCHAR2_TABLE_100

419: , p5_a18 out nocopy JTF_VARCHAR2_TABLE_100
420: , p5_a19 out nocopy JTF_VARCHAR2_TABLE_100
421: , p5_a20 out nocopy JTF_VARCHAR2_TABLE_100
422: , p5_a21 out nocopy JTF_VARCHAR2_TABLE_100
423: , p5_a22 out nocopy JTF_VARCHAR2_TABLE_100
424: , p5_a23 out nocopy JTF_VARCHAR2_TABLE_100
425: , p5_a24 out nocopy JTF_VARCHAR2_TABLE_100
426: , p5_a25 out nocopy JTF_VARCHAR2_TABLE_100
427: , p5_a26 out nocopy JTF_VARCHAR2_TABLE_100

Line 424: , p5_a23 out nocopy JTF_VARCHAR2_TABLE_100

420: , p5_a19 out nocopy JTF_VARCHAR2_TABLE_100
421: , p5_a20 out nocopy JTF_VARCHAR2_TABLE_100
422: , p5_a21 out nocopy JTF_VARCHAR2_TABLE_100
423: , p5_a22 out nocopy JTF_VARCHAR2_TABLE_100
424: , p5_a23 out nocopy JTF_VARCHAR2_TABLE_100
425: , p5_a24 out nocopy JTF_VARCHAR2_TABLE_100
426: , p5_a25 out nocopy JTF_VARCHAR2_TABLE_100
427: , p5_a26 out nocopy JTF_VARCHAR2_TABLE_100
428: , p5_a27 out nocopy JTF_VARCHAR2_TABLE_100

Line 425: , p5_a24 out nocopy JTF_VARCHAR2_TABLE_100

421: , p5_a20 out nocopy JTF_VARCHAR2_TABLE_100
422: , p5_a21 out nocopy JTF_VARCHAR2_TABLE_100
423: , p5_a22 out nocopy JTF_VARCHAR2_TABLE_100
424: , p5_a23 out nocopy JTF_VARCHAR2_TABLE_100
425: , p5_a24 out nocopy JTF_VARCHAR2_TABLE_100
426: , p5_a25 out nocopy JTF_VARCHAR2_TABLE_100
427: , p5_a26 out nocopy JTF_VARCHAR2_TABLE_100
428: , p5_a27 out nocopy JTF_VARCHAR2_TABLE_100
429: , p5_a28 out nocopy JTF_VARCHAR2_TABLE_100

Line 426: , p5_a25 out nocopy JTF_VARCHAR2_TABLE_100

422: , p5_a21 out nocopy JTF_VARCHAR2_TABLE_100
423: , p5_a22 out nocopy JTF_VARCHAR2_TABLE_100
424: , p5_a23 out nocopy JTF_VARCHAR2_TABLE_100
425: , p5_a24 out nocopy JTF_VARCHAR2_TABLE_100
426: , p5_a25 out nocopy JTF_VARCHAR2_TABLE_100
427: , p5_a26 out nocopy JTF_VARCHAR2_TABLE_100
428: , p5_a27 out nocopy JTF_VARCHAR2_TABLE_100
429: , p5_a28 out nocopy JTF_VARCHAR2_TABLE_100
430: , p5_a29 out nocopy JTF_VARCHAR2_TABLE_100

Line 427: , p5_a26 out nocopy JTF_VARCHAR2_TABLE_100

423: , p5_a22 out nocopy JTF_VARCHAR2_TABLE_100
424: , p5_a23 out nocopy JTF_VARCHAR2_TABLE_100
425: , p5_a24 out nocopy JTF_VARCHAR2_TABLE_100
426: , p5_a25 out nocopy JTF_VARCHAR2_TABLE_100
427: , p5_a26 out nocopy JTF_VARCHAR2_TABLE_100
428: , p5_a27 out nocopy JTF_VARCHAR2_TABLE_100
429: , p5_a28 out nocopy JTF_VARCHAR2_TABLE_100
430: , p5_a29 out nocopy JTF_VARCHAR2_TABLE_100
431: , p5_a30 out nocopy JTF_VARCHAR2_TABLE_100

Line 428: , p5_a27 out nocopy JTF_VARCHAR2_TABLE_100

424: , p5_a23 out nocopy JTF_VARCHAR2_TABLE_100
425: , p5_a24 out nocopy JTF_VARCHAR2_TABLE_100
426: , p5_a25 out nocopy JTF_VARCHAR2_TABLE_100
427: , p5_a26 out nocopy JTF_VARCHAR2_TABLE_100
428: , p5_a27 out nocopy JTF_VARCHAR2_TABLE_100
429: , p5_a28 out nocopy JTF_VARCHAR2_TABLE_100
430: , p5_a29 out nocopy JTF_VARCHAR2_TABLE_100
431: , p5_a30 out nocopy JTF_VARCHAR2_TABLE_100
432: , p5_a31 out nocopy JTF_VARCHAR2_TABLE_100

Line 429: , p5_a28 out nocopy JTF_VARCHAR2_TABLE_100

425: , p5_a24 out nocopy JTF_VARCHAR2_TABLE_100
426: , p5_a25 out nocopy JTF_VARCHAR2_TABLE_100
427: , p5_a26 out nocopy JTF_VARCHAR2_TABLE_100
428: , p5_a27 out nocopy JTF_VARCHAR2_TABLE_100
429: , p5_a28 out nocopy JTF_VARCHAR2_TABLE_100
430: , p5_a29 out nocopy JTF_VARCHAR2_TABLE_100
431: , p5_a30 out nocopy JTF_VARCHAR2_TABLE_100
432: , p5_a31 out nocopy JTF_VARCHAR2_TABLE_100
433: , p5_a32 out nocopy JTF_VARCHAR2_TABLE_100

Line 430: , p5_a29 out nocopy JTF_VARCHAR2_TABLE_100

426: , p5_a25 out nocopy JTF_VARCHAR2_TABLE_100
427: , p5_a26 out nocopy JTF_VARCHAR2_TABLE_100
428: , p5_a27 out nocopy JTF_VARCHAR2_TABLE_100
429: , p5_a28 out nocopy JTF_VARCHAR2_TABLE_100
430: , p5_a29 out nocopy JTF_VARCHAR2_TABLE_100
431: , p5_a30 out nocopy JTF_VARCHAR2_TABLE_100
432: , p5_a31 out nocopy JTF_VARCHAR2_TABLE_100
433: , p5_a32 out nocopy JTF_VARCHAR2_TABLE_100
434: , p5_a33 out nocopy JTF_VARCHAR2_TABLE_100

Line 431: , p5_a30 out nocopy JTF_VARCHAR2_TABLE_100

427: , p5_a26 out nocopy JTF_VARCHAR2_TABLE_100
428: , p5_a27 out nocopy JTF_VARCHAR2_TABLE_100
429: , p5_a28 out nocopy JTF_VARCHAR2_TABLE_100
430: , p5_a29 out nocopy JTF_VARCHAR2_TABLE_100
431: , p5_a30 out nocopy JTF_VARCHAR2_TABLE_100
432: , p5_a31 out nocopy JTF_VARCHAR2_TABLE_100
433: , p5_a32 out nocopy JTF_VARCHAR2_TABLE_100
434: , p5_a33 out nocopy JTF_VARCHAR2_TABLE_100
435: , p5_a34 out nocopy JTF_VARCHAR2_TABLE_100

Line 432: , p5_a31 out nocopy JTF_VARCHAR2_TABLE_100

428: , p5_a27 out nocopy JTF_VARCHAR2_TABLE_100
429: , p5_a28 out nocopy JTF_VARCHAR2_TABLE_100
430: , p5_a29 out nocopy JTF_VARCHAR2_TABLE_100
431: , p5_a30 out nocopy JTF_VARCHAR2_TABLE_100
432: , p5_a31 out nocopy JTF_VARCHAR2_TABLE_100
433: , p5_a32 out nocopy JTF_VARCHAR2_TABLE_100
434: , p5_a33 out nocopy JTF_VARCHAR2_TABLE_100
435: , p5_a34 out nocopy JTF_VARCHAR2_TABLE_100
436: , p5_a35 out nocopy JTF_VARCHAR2_TABLE_100

Line 433: , p5_a32 out nocopy JTF_VARCHAR2_TABLE_100

429: , p5_a28 out nocopy JTF_VARCHAR2_TABLE_100
430: , p5_a29 out nocopy JTF_VARCHAR2_TABLE_100
431: , p5_a30 out nocopy JTF_VARCHAR2_TABLE_100
432: , p5_a31 out nocopy JTF_VARCHAR2_TABLE_100
433: , p5_a32 out nocopy JTF_VARCHAR2_TABLE_100
434: , p5_a33 out nocopy JTF_VARCHAR2_TABLE_100
435: , p5_a34 out nocopy JTF_VARCHAR2_TABLE_100
436: , p5_a35 out nocopy JTF_VARCHAR2_TABLE_100
437: , p5_a36 out nocopy JTF_VARCHAR2_TABLE_100

Line 434: , p5_a33 out nocopy JTF_VARCHAR2_TABLE_100

430: , p5_a29 out nocopy JTF_VARCHAR2_TABLE_100
431: , p5_a30 out nocopy JTF_VARCHAR2_TABLE_100
432: , p5_a31 out nocopy JTF_VARCHAR2_TABLE_100
433: , p5_a32 out nocopy JTF_VARCHAR2_TABLE_100
434: , p5_a33 out nocopy JTF_VARCHAR2_TABLE_100
435: , p5_a34 out nocopy JTF_VARCHAR2_TABLE_100
436: , p5_a35 out nocopy JTF_VARCHAR2_TABLE_100
437: , p5_a36 out nocopy JTF_VARCHAR2_TABLE_100
438: , p5_a37 out nocopy JTF_VARCHAR2_TABLE_100

Line 435: , p5_a34 out nocopy JTF_VARCHAR2_TABLE_100

431: , p5_a30 out nocopy JTF_VARCHAR2_TABLE_100
432: , p5_a31 out nocopy JTF_VARCHAR2_TABLE_100
433: , p5_a32 out nocopy JTF_VARCHAR2_TABLE_100
434: , p5_a33 out nocopy JTF_VARCHAR2_TABLE_100
435: , p5_a34 out nocopy JTF_VARCHAR2_TABLE_100
436: , p5_a35 out nocopy JTF_VARCHAR2_TABLE_100
437: , p5_a36 out nocopy JTF_VARCHAR2_TABLE_100
438: , p5_a37 out nocopy JTF_VARCHAR2_TABLE_100
439: , p5_a38 out nocopy JTF_VARCHAR2_TABLE_100

Line 436: , p5_a35 out nocopy JTF_VARCHAR2_TABLE_100

432: , p5_a31 out nocopy JTF_VARCHAR2_TABLE_100
433: , p5_a32 out nocopy JTF_VARCHAR2_TABLE_100
434: , p5_a33 out nocopy JTF_VARCHAR2_TABLE_100
435: , p5_a34 out nocopy JTF_VARCHAR2_TABLE_100
436: , p5_a35 out nocopy JTF_VARCHAR2_TABLE_100
437: , p5_a36 out nocopy JTF_VARCHAR2_TABLE_100
438: , p5_a37 out nocopy JTF_VARCHAR2_TABLE_100
439: , p5_a38 out nocopy JTF_VARCHAR2_TABLE_100
440: , p5_a39 out nocopy JTF_DATE_TABLE

Line 437: , p5_a36 out nocopy JTF_VARCHAR2_TABLE_100

433: , p5_a32 out nocopy JTF_VARCHAR2_TABLE_100
434: , p5_a33 out nocopy JTF_VARCHAR2_TABLE_100
435: , p5_a34 out nocopy JTF_VARCHAR2_TABLE_100
436: , p5_a35 out nocopy JTF_VARCHAR2_TABLE_100
437: , p5_a36 out nocopy JTF_VARCHAR2_TABLE_100
438: , p5_a37 out nocopy JTF_VARCHAR2_TABLE_100
439: , p5_a38 out nocopy JTF_VARCHAR2_TABLE_100
440: , p5_a39 out nocopy JTF_DATE_TABLE
441: , p5_a40 out nocopy JTF_DATE_TABLE

Line 438: , p5_a37 out nocopy JTF_VARCHAR2_TABLE_100

434: , p5_a33 out nocopy JTF_VARCHAR2_TABLE_100
435: , p5_a34 out nocopy JTF_VARCHAR2_TABLE_100
436: , p5_a35 out nocopy JTF_VARCHAR2_TABLE_100
437: , p5_a36 out nocopy JTF_VARCHAR2_TABLE_100
438: , p5_a37 out nocopy JTF_VARCHAR2_TABLE_100
439: , p5_a38 out nocopy JTF_VARCHAR2_TABLE_100
440: , p5_a39 out nocopy JTF_DATE_TABLE
441: , p5_a40 out nocopy JTF_DATE_TABLE
442: , p5_a41 out nocopy JTF_VARCHAR2_TABLE_100

Line 439: , p5_a38 out nocopy JTF_VARCHAR2_TABLE_100

435: , p5_a34 out nocopy JTF_VARCHAR2_TABLE_100
436: , p5_a35 out nocopy JTF_VARCHAR2_TABLE_100
437: , p5_a36 out nocopy JTF_VARCHAR2_TABLE_100
438: , p5_a37 out nocopy JTF_VARCHAR2_TABLE_100
439: , p5_a38 out nocopy JTF_VARCHAR2_TABLE_100
440: , p5_a39 out nocopy JTF_DATE_TABLE
441: , p5_a40 out nocopy JTF_DATE_TABLE
442: , p5_a41 out nocopy JTF_VARCHAR2_TABLE_100
443: , p5_a42 out nocopy JTF_VARCHAR2_TABLE_100

Line 442: , p5_a41 out nocopy JTF_VARCHAR2_TABLE_100

438: , p5_a37 out nocopy JTF_VARCHAR2_TABLE_100
439: , p5_a38 out nocopy JTF_VARCHAR2_TABLE_100
440: , p5_a39 out nocopy JTF_DATE_TABLE
441: , p5_a40 out nocopy JTF_DATE_TABLE
442: , p5_a41 out nocopy JTF_VARCHAR2_TABLE_100
443: , p5_a42 out nocopy JTF_VARCHAR2_TABLE_100
444: , p5_a43 out nocopy JTF_VARCHAR2_TABLE_300
445: , p5_a44 out nocopy JTF_VARCHAR2_TABLE_300
446: , p5_a45 out nocopy JTF_VARCHAR2_TABLE_100

Line 443: , p5_a42 out nocopy JTF_VARCHAR2_TABLE_100

439: , p5_a38 out nocopy JTF_VARCHAR2_TABLE_100
440: , p5_a39 out nocopy JTF_DATE_TABLE
441: , p5_a40 out nocopy JTF_DATE_TABLE
442: , p5_a41 out nocopy JTF_VARCHAR2_TABLE_100
443: , p5_a42 out nocopy JTF_VARCHAR2_TABLE_100
444: , p5_a43 out nocopy JTF_VARCHAR2_TABLE_300
445: , p5_a44 out nocopy JTF_VARCHAR2_TABLE_300
446: , p5_a45 out nocopy JTF_VARCHAR2_TABLE_100
447: , p5_a46 out nocopy JTF_VARCHAR2_TABLE_100

Line 446: , p5_a45 out nocopy JTF_VARCHAR2_TABLE_100

442: , p5_a41 out nocopy JTF_VARCHAR2_TABLE_100
443: , p5_a42 out nocopy JTF_VARCHAR2_TABLE_100
444: , p5_a43 out nocopy JTF_VARCHAR2_TABLE_300
445: , p5_a44 out nocopy JTF_VARCHAR2_TABLE_300
446: , p5_a45 out nocopy JTF_VARCHAR2_TABLE_100
447: , p5_a46 out nocopy JTF_VARCHAR2_TABLE_100
448: , p5_a47 out nocopy JTF_NUMBER_TABLE
449: , p5_a48 out nocopy JTF_NUMBER_TABLE
450: , p5_a49 out nocopy JTF_NUMBER_TABLE

Line 447: , p5_a46 out nocopy JTF_VARCHAR2_TABLE_100

443: , p5_a42 out nocopy JTF_VARCHAR2_TABLE_100
444: , p5_a43 out nocopy JTF_VARCHAR2_TABLE_300
445: , p5_a44 out nocopy JTF_VARCHAR2_TABLE_300
446: , p5_a45 out nocopy JTF_VARCHAR2_TABLE_100
447: , p5_a46 out nocopy JTF_VARCHAR2_TABLE_100
448: , p5_a47 out nocopy JTF_NUMBER_TABLE
449: , p5_a48 out nocopy JTF_NUMBER_TABLE
450: , p5_a49 out nocopy JTF_NUMBER_TABLE
451: , p5_a50 out nocopy JTF_VARCHAR2_TABLE_100

Line 451: , p5_a50 out nocopy JTF_VARCHAR2_TABLE_100

447: , p5_a46 out nocopy JTF_VARCHAR2_TABLE_100
448: , p5_a47 out nocopy JTF_NUMBER_TABLE
449: , p5_a48 out nocopy JTF_NUMBER_TABLE
450: , p5_a49 out nocopy JTF_NUMBER_TABLE
451: , p5_a50 out nocopy JTF_VARCHAR2_TABLE_100
452: , p5_a51 out nocopy JTF_VARCHAR2_TABLE_100
453: , p5_a52 out nocopy JTF_NUMBER_TABLE
454: , p5_a53 out nocopy JTF_NUMBER_TABLE
455: , p5_a54 out nocopy JTF_VARCHAR2_TABLE_100

Line 452: , p5_a51 out nocopy JTF_VARCHAR2_TABLE_100

448: , p5_a47 out nocopy JTF_NUMBER_TABLE
449: , p5_a48 out nocopy JTF_NUMBER_TABLE
450: , p5_a49 out nocopy JTF_NUMBER_TABLE
451: , p5_a50 out nocopy JTF_VARCHAR2_TABLE_100
452: , p5_a51 out nocopy JTF_VARCHAR2_TABLE_100
453: , p5_a52 out nocopy JTF_NUMBER_TABLE
454: , p5_a53 out nocopy JTF_NUMBER_TABLE
455: , p5_a54 out nocopy JTF_VARCHAR2_TABLE_100
456: , p5_a55 out nocopy JTF_VARCHAR2_TABLE_100

Line 455: , p5_a54 out nocopy JTF_VARCHAR2_TABLE_100

451: , p5_a50 out nocopy JTF_VARCHAR2_TABLE_100
452: , p5_a51 out nocopy JTF_VARCHAR2_TABLE_100
453: , p5_a52 out nocopy JTF_NUMBER_TABLE
454: , p5_a53 out nocopy JTF_NUMBER_TABLE
455: , p5_a54 out nocopy JTF_VARCHAR2_TABLE_100
456: , p5_a55 out nocopy JTF_VARCHAR2_TABLE_100
457: , x_return_status out nocopy VARCHAR2
458: , x_msg_count out nocopy NUMBER
459: , x_msg_data out nocopy VARCHAR2

Line 456: , p5_a55 out nocopy JTF_VARCHAR2_TABLE_100

452: , p5_a51 out nocopy JTF_VARCHAR2_TABLE_100
453: , p5_a52 out nocopy JTF_NUMBER_TABLE
454: , p5_a53 out nocopy JTF_NUMBER_TABLE
455: , p5_a54 out nocopy JTF_VARCHAR2_TABLE_100
456: , p5_a55 out nocopy JTF_VARCHAR2_TABLE_100
457: , x_return_status out nocopy VARCHAR2
458: , x_msg_count out nocopy NUMBER
459: , x_msg_data out nocopy VARCHAR2
460: );

Line 465: , p0_a4 in out nocopy JTF_VARCHAR2_TABLE_100

461: procedure asset_syncup_validation(p0_a0 in out nocopy JTF_NUMBER_TABLE
462: , p0_a1 in out nocopy JTF_NUMBER_TABLE
463: , p0_a2 in out nocopy JTF_NUMBER_TABLE
464: , p0_a3 in out nocopy JTF_NUMBER_TABLE
465: , p0_a4 in out nocopy JTF_VARCHAR2_TABLE_100
466: , p0_a5 in out nocopy JTF_NUMBER_TABLE
467: , p0_a6 in out nocopy JTF_NUMBER_TABLE
468: , p0_a7 in out nocopy JTF_VARCHAR2_TABLE_100
469: , p1_a0 in out nocopy JTF_NUMBER_TABLE

Line 468: , p0_a7 in out nocopy JTF_VARCHAR2_TABLE_100

464: , p0_a3 in out nocopy JTF_NUMBER_TABLE
465: , p0_a4 in out nocopy JTF_VARCHAR2_TABLE_100
466: , p0_a5 in out nocopy JTF_NUMBER_TABLE
467: , p0_a6 in out nocopy JTF_NUMBER_TABLE
468: , p0_a7 in out nocopy JTF_VARCHAR2_TABLE_100
469: , p1_a0 in out nocopy JTF_NUMBER_TABLE
470: , p1_a1 in out nocopy JTF_NUMBER_TABLE
471: , p1_a2 in out nocopy JTF_NUMBER_TABLE
472: , p1_a3 in out nocopy JTF_NUMBER_TABLE

Line 492: , p3_a4 out nocopy JTF_VARCHAR2_TABLE_100

488: , p3_a0 out nocopy JTF_NUMBER_TABLE
489: , p3_a1 out nocopy JTF_NUMBER_TABLE
490: , p3_a2 out nocopy JTF_NUMBER_TABLE
491: , p3_a3 out nocopy JTF_NUMBER_TABLE
492: , p3_a4 out nocopy JTF_VARCHAR2_TABLE_100
493: , p3_a5 out nocopy JTF_NUMBER_TABLE
494: , p3_a6 out nocopy JTF_NUMBER_TABLE
495: , p3_a7 out nocopy JTF_VARCHAR2_TABLE_100
496: , x_return_status out nocopy VARCHAR2

Line 495: , p3_a7 out nocopy JTF_VARCHAR2_TABLE_100

491: , p3_a3 out nocopy JTF_NUMBER_TABLE
492: , p3_a4 out nocopy JTF_VARCHAR2_TABLE_100
493: , p3_a5 out nocopy JTF_NUMBER_TABLE
494: , p3_a6 out nocopy JTF_NUMBER_TABLE
495: , p3_a7 out nocopy JTF_VARCHAR2_TABLE_100
496: , x_return_status out nocopy VARCHAR2
497: , x_msg_count out nocopy NUMBER
498: , x_msg_data out nocopy VARCHAR2
499: , p_source_system_name VARCHAR2

Line 508: , p2_a4 JTF_VARCHAR2_TABLE_100

504: , p2_a0 JTF_NUMBER_TABLE
505: , p2_a1 JTF_NUMBER_TABLE
506: , p2_a2 JTF_NUMBER_TABLE
507: , p2_a3 JTF_NUMBER_TABLE
508: , p2_a4 JTF_VARCHAR2_TABLE_100
509: , p2_a5 JTF_NUMBER_TABLE
510: , p2_a6 JTF_NUMBER_TABLE
511: , p2_a7 JTF_VARCHAR2_TABLE_100
512: , p3_a0 out nocopy JTF_NUMBER_TABLE

Line 511: , p2_a7 JTF_VARCHAR2_TABLE_100

507: , p2_a3 JTF_NUMBER_TABLE
508: , p2_a4 JTF_VARCHAR2_TABLE_100
509: , p2_a5 JTF_NUMBER_TABLE
510: , p2_a6 JTF_NUMBER_TABLE
511: , p2_a7 JTF_VARCHAR2_TABLE_100
512: , p3_a0 out nocopy JTF_NUMBER_TABLE
513: , p3_a1 out nocopy JTF_NUMBER_TABLE
514: , p3_a2 out nocopy JTF_NUMBER_TABLE
515: , p3_a3 out nocopy JTF_NUMBER_TABLE

Line 544: , p0_a4 in out nocopy JTF_VARCHAR2_TABLE_100

540: procedure get_syncup_tree(p0_a0 in out nocopy JTF_NUMBER_TABLE
541: , p0_a1 in out nocopy JTF_NUMBER_TABLE
542: , p0_a2 in out nocopy JTF_NUMBER_TABLE
543: , p0_a3 in out nocopy JTF_NUMBER_TABLE
544: , p0_a4 in out nocopy JTF_VARCHAR2_TABLE_100
545: , p0_a5 in out nocopy JTF_NUMBER_TABLE
546: , p0_a6 in out nocopy JTF_NUMBER_TABLE
547: , p0_a7 in out nocopy JTF_VARCHAR2_TABLE_100
548: , p1_a0 in out nocopy JTF_NUMBER_TABLE

Line 547: , p0_a7 in out nocopy JTF_VARCHAR2_TABLE_100

543: , p0_a3 in out nocopy JTF_NUMBER_TABLE
544: , p0_a4 in out nocopy JTF_VARCHAR2_TABLE_100
545: , p0_a5 in out nocopy JTF_NUMBER_TABLE
546: , p0_a6 in out nocopy JTF_NUMBER_TABLE
547: , p0_a7 in out nocopy JTF_VARCHAR2_TABLE_100
548: , p1_a0 in out nocopy JTF_NUMBER_TABLE
549: , p1_a1 in out nocopy JTF_NUMBER_TABLE
550: , p1_a2 in out nocopy JTF_NUMBER_TABLE
551: , p1_a3 in out nocopy JTF_NUMBER_TABLE

Line 569: , p4_a3 in out nocopy JTF_VARCHAR2_TABLE_100

565: , p_validation_level NUMBER
566: , p4_a0 in out nocopy JTF_NUMBER_TABLE
567: , p4_a1 in out nocopy JTF_NUMBER_TABLE
568: , p4_a2 in out nocopy JTF_NUMBER_TABLE
569: , p4_a3 in out nocopy JTF_VARCHAR2_TABLE_100
570: , p4_a4 in out nocopy JTF_NUMBER_TABLE
571: , p4_a5 in out nocopy JTF_NUMBER_TABLE
572: , p4_a6 in out nocopy JTF_VARCHAR2_TABLE_100
573: , p4_a7 in out nocopy JTF_DATE_TABLE

Line 572: , p4_a6 in out nocopy JTF_VARCHAR2_TABLE_100

568: , p4_a2 in out nocopy JTF_NUMBER_TABLE
569: , p4_a3 in out nocopy JTF_VARCHAR2_TABLE_100
570: , p4_a4 in out nocopy JTF_NUMBER_TABLE
571: , p4_a5 in out nocopy JTF_NUMBER_TABLE
572: , p4_a6 in out nocopy JTF_VARCHAR2_TABLE_100
573: , p4_a7 in out nocopy JTF_DATE_TABLE
574: , p4_a8 in out nocopy JTF_DATE_TABLE
575: , p4_a9 in out nocopy JTF_NUMBER_TABLE
576: , p4_a10 in out nocopy JTF_VARCHAR2_TABLE_100

Line 576: , p4_a10 in out nocopy JTF_VARCHAR2_TABLE_100

572: , p4_a6 in out nocopy JTF_VARCHAR2_TABLE_100
573: , p4_a7 in out nocopy JTF_DATE_TABLE
574: , p4_a8 in out nocopy JTF_DATE_TABLE
575: , p4_a9 in out nocopy JTF_NUMBER_TABLE
576: , p4_a10 in out nocopy JTF_VARCHAR2_TABLE_100
577: , p4_a11 in out nocopy JTF_NUMBER_TABLE
578: , p4_a12 in out nocopy JTF_VARCHAR2_TABLE_100
579: , p4_a13 in out nocopy JTF_NUMBER_TABLE
580: , p4_a14 in out nocopy JTF_VARCHAR2_TABLE_100

Line 578: , p4_a12 in out nocopy JTF_VARCHAR2_TABLE_100

574: , p4_a8 in out nocopy JTF_DATE_TABLE
575: , p4_a9 in out nocopy JTF_NUMBER_TABLE
576: , p4_a10 in out nocopy JTF_VARCHAR2_TABLE_100
577: , p4_a11 in out nocopy JTF_NUMBER_TABLE
578: , p4_a12 in out nocopy JTF_VARCHAR2_TABLE_100
579: , p4_a13 in out nocopy JTF_NUMBER_TABLE
580: , p4_a14 in out nocopy JTF_VARCHAR2_TABLE_100
581: , p4_a15 in out nocopy JTF_VARCHAR2_TABLE_100
582: , p5_a0 in out nocopy NUMBER

Line 580: , p4_a14 in out nocopy JTF_VARCHAR2_TABLE_100

576: , p4_a10 in out nocopy JTF_VARCHAR2_TABLE_100
577: , p4_a11 in out nocopy JTF_NUMBER_TABLE
578: , p4_a12 in out nocopy JTF_VARCHAR2_TABLE_100
579: , p4_a13 in out nocopy JTF_NUMBER_TABLE
580: , p4_a14 in out nocopy JTF_VARCHAR2_TABLE_100
581: , p4_a15 in out nocopy JTF_VARCHAR2_TABLE_100
582: , p5_a0 in out nocopy NUMBER
583: , p5_a1 in out nocopy DATE
584: , p5_a2 in out nocopy DATE

Line 581: , p4_a15 in out nocopy JTF_VARCHAR2_TABLE_100

577: , p4_a11 in out nocopy JTF_NUMBER_TABLE
578: , p4_a12 in out nocopy JTF_VARCHAR2_TABLE_100
579: , p4_a13 in out nocopy JTF_NUMBER_TABLE
580: , p4_a14 in out nocopy JTF_VARCHAR2_TABLE_100
581: , p4_a15 in out nocopy JTF_VARCHAR2_TABLE_100
582: , p5_a0 in out nocopy NUMBER
583: , p5_a1 in out nocopy DATE
584: , p5_a2 in out nocopy DATE
585: , p5_a3 in out nocopy NUMBER

Line 622: , p6_a0 in out nocopy JTF_VARCHAR2_TABLE_100

618: , p5_a36 in out nocopy NUMBER
619: , p5_a37 in out nocopy VARCHAR2
620: , p5_a38 in out nocopy DATE
621: , p5_a39 in out nocopy NUMBER
622: , p6_a0 in out nocopy JTF_VARCHAR2_TABLE_100
623: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
624: , p7_a0 in out nocopy NUMBER
625: , p7_a1 in out nocopy NUMBER
626: , p7_a2 in out nocopy NUMBER

Line 623: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100

619: , p5_a37 in out nocopy VARCHAR2
620: , p5_a38 in out nocopy DATE
621: , p5_a39 in out nocopy NUMBER
622: , p6_a0 in out nocopy JTF_VARCHAR2_TABLE_100
623: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
624: , p7_a0 in out nocopy NUMBER
625: , p7_a1 in out nocopy NUMBER
626: , p7_a2 in out nocopy NUMBER
627: , p8_a0 in out nocopy JTF_NUMBER_TABLE

Line 628: , p8_a1 in out nocopy JTF_VARCHAR2_TABLE_100

624: , p7_a0 in out nocopy NUMBER
625: , p7_a1 in out nocopy NUMBER
626: , p7_a2 in out nocopy NUMBER
627: , p8_a0 in out nocopy JTF_NUMBER_TABLE
628: , p8_a1 in out nocopy JTF_VARCHAR2_TABLE_100
629: , p8_a2 in out nocopy JTF_VARCHAR2_TABLE_100
630: , p9_a0 in out nocopy JTF_NUMBER_TABLE
631: , p9_a1 in out nocopy JTF_VARCHAR2_TABLE_100
632: , x_return_status out nocopy VARCHAR2

Line 629: , p8_a2 in out nocopy JTF_VARCHAR2_TABLE_100

625: , p7_a1 in out nocopy NUMBER
626: , p7_a2 in out nocopy NUMBER
627: , p8_a0 in out nocopy JTF_NUMBER_TABLE
628: , p8_a1 in out nocopy JTF_VARCHAR2_TABLE_100
629: , p8_a2 in out nocopy JTF_VARCHAR2_TABLE_100
630: , p9_a0 in out nocopy JTF_NUMBER_TABLE
631: , p9_a1 in out nocopy JTF_VARCHAR2_TABLE_100
632: , x_return_status out nocopy VARCHAR2
633: , x_msg_count out nocopy NUMBER

Line 631: , p9_a1 in out nocopy JTF_VARCHAR2_TABLE_100

627: , p8_a0 in out nocopy JTF_NUMBER_TABLE
628: , p8_a1 in out nocopy JTF_VARCHAR2_TABLE_100
629: , p8_a2 in out nocopy JTF_VARCHAR2_TABLE_100
630: , p9_a0 in out nocopy JTF_NUMBER_TABLE
631: , p9_a1 in out nocopy JTF_VARCHAR2_TABLE_100
632: , x_return_status out nocopy VARCHAR2
633: , x_msg_count out nocopy NUMBER
634: , x_msg_data out nocopy VARCHAR2
635: );