DBA Data[Home] [Help]

APPS.AMS_VENUE_RATES_PVT_W dependencies on JTF_NUMBER_TABLE

Line 22: procedure rosetta_table_copy_in_p3(t OUT NOCOPY ams_venue_rates_pvt.venue_rates_tbl_type, a0 JTF_NUMBER_TABLE

18: if d = rosetta_g_mistake_date then return fnd_api.g_miss_date; end if;
19: return d;
20: end;
21:
22: procedure rosetta_table_copy_in_p3(t OUT NOCOPY ams_venue_rates_pvt.venue_rates_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_DATE_TABLE
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_DATE_TABLE
26: , a4 JTF_NUMBER_TABLE

Line 24: , a2 JTF_NUMBER_TABLE

20: end;
21:
22: procedure rosetta_table_copy_in_p3(t OUT NOCOPY ams_venue_rates_pvt.venue_rates_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_DATE_TABLE
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_DATE_TABLE
26: , a4 JTF_NUMBER_TABLE
27: , a5 JTF_NUMBER_TABLE
28: , a6 JTF_NUMBER_TABLE

Line 26: , a4 JTF_NUMBER_TABLE

22: procedure rosetta_table_copy_in_p3(t OUT NOCOPY ams_venue_rates_pvt.venue_rates_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_DATE_TABLE
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_DATE_TABLE
26: , a4 JTF_NUMBER_TABLE
27: , a5 JTF_NUMBER_TABLE
28: , a6 JTF_NUMBER_TABLE
29: , a7 JTF_VARCHAR2_TABLE_100
30: , a8 JTF_NUMBER_TABLE

Line 27: , a5 JTF_NUMBER_TABLE

23: , a1 JTF_DATE_TABLE
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_DATE_TABLE
26: , a4 JTF_NUMBER_TABLE
27: , a5 JTF_NUMBER_TABLE
28: , a6 JTF_NUMBER_TABLE
29: , a7 JTF_VARCHAR2_TABLE_100
30: , a8 JTF_NUMBER_TABLE
31: , a9 JTF_NUMBER_TABLE

Line 28: , a6 JTF_NUMBER_TABLE

24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_DATE_TABLE
26: , a4 JTF_NUMBER_TABLE
27: , a5 JTF_NUMBER_TABLE
28: , a6 JTF_NUMBER_TABLE
29: , a7 JTF_VARCHAR2_TABLE_100
30: , a8 JTF_NUMBER_TABLE
31: , a9 JTF_NUMBER_TABLE
32: , a10 JTF_NUMBER_TABLE

Line 30: , a8 JTF_NUMBER_TABLE

26: , a4 JTF_NUMBER_TABLE
27: , a5 JTF_NUMBER_TABLE
28: , a6 JTF_NUMBER_TABLE
29: , a7 JTF_VARCHAR2_TABLE_100
30: , a8 JTF_NUMBER_TABLE
31: , a9 JTF_NUMBER_TABLE
32: , a10 JTF_NUMBER_TABLE
33: , a11 JTF_VARCHAR2_TABLE_100
34: , a12 JTF_NUMBER_TABLE

Line 31: , a9 JTF_NUMBER_TABLE

27: , a5 JTF_NUMBER_TABLE
28: , a6 JTF_NUMBER_TABLE
29: , a7 JTF_VARCHAR2_TABLE_100
30: , a8 JTF_NUMBER_TABLE
31: , a9 JTF_NUMBER_TABLE
32: , a10 JTF_NUMBER_TABLE
33: , a11 JTF_VARCHAR2_TABLE_100
34: , a12 JTF_NUMBER_TABLE
35: , a13 JTF_VARCHAR2_TABLE_100

Line 32: , a10 JTF_NUMBER_TABLE

28: , a6 JTF_NUMBER_TABLE
29: , a7 JTF_VARCHAR2_TABLE_100
30: , a8 JTF_NUMBER_TABLE
31: , a9 JTF_NUMBER_TABLE
32: , a10 JTF_NUMBER_TABLE
33: , a11 JTF_VARCHAR2_TABLE_100
34: , a12 JTF_NUMBER_TABLE
35: , a13 JTF_VARCHAR2_TABLE_100
36: , a14 JTF_VARCHAR2_TABLE_100

Line 34: , a12 JTF_NUMBER_TABLE

30: , a8 JTF_NUMBER_TABLE
31: , a9 JTF_NUMBER_TABLE
32: , a10 JTF_NUMBER_TABLE
33: , a11 JTF_VARCHAR2_TABLE_100
34: , a12 JTF_NUMBER_TABLE
35: , a13 JTF_VARCHAR2_TABLE_100
36: , a14 JTF_VARCHAR2_TABLE_100
37: , a15 JTF_VARCHAR2_TABLE_100
38: , a16 JTF_VARCHAR2_TABLE_100

Line 105: procedure rosetta_table_copy_out_p3(t ams_venue_rates_pvt.venue_rates_tbl_type, a0 OUT NOCOPY JTF_NUMBER_TABLE

101: end loop;
102: end if;
103: end if;
104: end rosetta_table_copy_in_p3;
105: procedure rosetta_table_copy_out_p3(t ams_venue_rates_pvt.venue_rates_tbl_type, a0 OUT NOCOPY JTF_NUMBER_TABLE
106: , a1 OUT NOCOPY JTF_DATE_TABLE
107: , a2 OUT NOCOPY JTF_NUMBER_TABLE
108: , a3 OUT NOCOPY JTF_DATE_TABLE
109: , a4 OUT NOCOPY JTF_NUMBER_TABLE

Line 107: , a2 OUT NOCOPY JTF_NUMBER_TABLE

103: end if;
104: end rosetta_table_copy_in_p3;
105: procedure rosetta_table_copy_out_p3(t ams_venue_rates_pvt.venue_rates_tbl_type, a0 OUT NOCOPY JTF_NUMBER_TABLE
106: , a1 OUT NOCOPY JTF_DATE_TABLE
107: , a2 OUT NOCOPY JTF_NUMBER_TABLE
108: , a3 OUT NOCOPY JTF_DATE_TABLE
109: , a4 OUT NOCOPY JTF_NUMBER_TABLE
110: , a5 OUT NOCOPY JTF_NUMBER_TABLE
111: , a6 OUT NOCOPY JTF_NUMBER_TABLE

Line 109: , a4 OUT NOCOPY JTF_NUMBER_TABLE

105: procedure rosetta_table_copy_out_p3(t ams_venue_rates_pvt.venue_rates_tbl_type, a0 OUT NOCOPY JTF_NUMBER_TABLE
106: , a1 OUT NOCOPY JTF_DATE_TABLE
107: , a2 OUT NOCOPY JTF_NUMBER_TABLE
108: , a3 OUT NOCOPY JTF_DATE_TABLE
109: , a4 OUT NOCOPY JTF_NUMBER_TABLE
110: , a5 OUT NOCOPY JTF_NUMBER_TABLE
111: , a6 OUT NOCOPY JTF_NUMBER_TABLE
112: , a7 OUT NOCOPY JTF_VARCHAR2_TABLE_100
113: , a8 OUT NOCOPY JTF_NUMBER_TABLE

Line 110: , a5 OUT NOCOPY JTF_NUMBER_TABLE

106: , a1 OUT NOCOPY JTF_DATE_TABLE
107: , a2 OUT NOCOPY JTF_NUMBER_TABLE
108: , a3 OUT NOCOPY JTF_DATE_TABLE
109: , a4 OUT NOCOPY JTF_NUMBER_TABLE
110: , a5 OUT NOCOPY JTF_NUMBER_TABLE
111: , a6 OUT NOCOPY JTF_NUMBER_TABLE
112: , a7 OUT NOCOPY JTF_VARCHAR2_TABLE_100
113: , a8 OUT NOCOPY JTF_NUMBER_TABLE
114: , a9 OUT NOCOPY JTF_NUMBER_TABLE

Line 111: , a6 OUT NOCOPY JTF_NUMBER_TABLE

107: , a2 OUT NOCOPY JTF_NUMBER_TABLE
108: , a3 OUT NOCOPY JTF_DATE_TABLE
109: , a4 OUT NOCOPY JTF_NUMBER_TABLE
110: , a5 OUT NOCOPY JTF_NUMBER_TABLE
111: , a6 OUT NOCOPY JTF_NUMBER_TABLE
112: , a7 OUT NOCOPY JTF_VARCHAR2_TABLE_100
113: , a8 OUT NOCOPY JTF_NUMBER_TABLE
114: , a9 OUT NOCOPY JTF_NUMBER_TABLE
115: , a10 OUT NOCOPY JTF_NUMBER_TABLE

Line 113: , a8 OUT NOCOPY JTF_NUMBER_TABLE

109: , a4 OUT NOCOPY JTF_NUMBER_TABLE
110: , a5 OUT NOCOPY JTF_NUMBER_TABLE
111: , a6 OUT NOCOPY JTF_NUMBER_TABLE
112: , a7 OUT NOCOPY JTF_VARCHAR2_TABLE_100
113: , a8 OUT NOCOPY JTF_NUMBER_TABLE
114: , a9 OUT NOCOPY JTF_NUMBER_TABLE
115: , a10 OUT NOCOPY JTF_NUMBER_TABLE
116: , a11 OUT NOCOPY JTF_VARCHAR2_TABLE_100
117: , a12 OUT NOCOPY JTF_NUMBER_TABLE

Line 114: , a9 OUT NOCOPY JTF_NUMBER_TABLE

110: , a5 OUT NOCOPY JTF_NUMBER_TABLE
111: , a6 OUT NOCOPY JTF_NUMBER_TABLE
112: , a7 OUT NOCOPY JTF_VARCHAR2_TABLE_100
113: , a8 OUT NOCOPY JTF_NUMBER_TABLE
114: , a9 OUT NOCOPY JTF_NUMBER_TABLE
115: , a10 OUT NOCOPY JTF_NUMBER_TABLE
116: , a11 OUT NOCOPY JTF_VARCHAR2_TABLE_100
117: , a12 OUT NOCOPY JTF_NUMBER_TABLE
118: , a13 OUT NOCOPY JTF_VARCHAR2_TABLE_100

Line 115: , a10 OUT NOCOPY JTF_NUMBER_TABLE

111: , a6 OUT NOCOPY JTF_NUMBER_TABLE
112: , a7 OUT NOCOPY JTF_VARCHAR2_TABLE_100
113: , a8 OUT NOCOPY JTF_NUMBER_TABLE
114: , a9 OUT NOCOPY JTF_NUMBER_TABLE
115: , a10 OUT NOCOPY JTF_NUMBER_TABLE
116: , a11 OUT NOCOPY JTF_VARCHAR2_TABLE_100
117: , a12 OUT NOCOPY JTF_NUMBER_TABLE
118: , a13 OUT NOCOPY JTF_VARCHAR2_TABLE_100
119: , a14 OUT NOCOPY JTF_VARCHAR2_TABLE_100

Line 117: , a12 OUT NOCOPY JTF_NUMBER_TABLE

113: , a8 OUT NOCOPY JTF_NUMBER_TABLE
114: , a9 OUT NOCOPY JTF_NUMBER_TABLE
115: , a10 OUT NOCOPY JTF_NUMBER_TABLE
116: , a11 OUT NOCOPY JTF_VARCHAR2_TABLE_100
117: , a12 OUT NOCOPY JTF_NUMBER_TABLE
118: , a13 OUT NOCOPY JTF_VARCHAR2_TABLE_100
119: , a14 OUT NOCOPY JTF_VARCHAR2_TABLE_100
120: , a15 OUT NOCOPY JTF_VARCHAR2_TABLE_100
121: , a16 OUT NOCOPY JTF_VARCHAR2_TABLE_100

Line 142: a0 := JTF_NUMBER_TABLE();

138: ) as
139: ddindx binary_integer; indx binary_integer;
140: begin
141: if t is null or t.count = 0 then
142: a0 := JTF_NUMBER_TABLE();
143: a1 := JTF_DATE_TABLE();
144: a2 := JTF_NUMBER_TABLE();
145: a3 := JTF_DATE_TABLE();
146: a4 := JTF_NUMBER_TABLE();

Line 144: a2 := JTF_NUMBER_TABLE();

140: begin
141: if t is null or t.count = 0 then
142: a0 := JTF_NUMBER_TABLE();
143: a1 := JTF_DATE_TABLE();
144: a2 := JTF_NUMBER_TABLE();
145: a3 := JTF_DATE_TABLE();
146: a4 := JTF_NUMBER_TABLE();
147: a5 := JTF_NUMBER_TABLE();
148: a6 := JTF_NUMBER_TABLE();

Line 146: a4 := JTF_NUMBER_TABLE();

142: a0 := JTF_NUMBER_TABLE();
143: a1 := JTF_DATE_TABLE();
144: a2 := JTF_NUMBER_TABLE();
145: a3 := JTF_DATE_TABLE();
146: a4 := JTF_NUMBER_TABLE();
147: a5 := JTF_NUMBER_TABLE();
148: a6 := JTF_NUMBER_TABLE();
149: a7 := JTF_VARCHAR2_TABLE_100();
150: a8 := JTF_NUMBER_TABLE();

Line 147: a5 := JTF_NUMBER_TABLE();

143: a1 := JTF_DATE_TABLE();
144: a2 := JTF_NUMBER_TABLE();
145: a3 := JTF_DATE_TABLE();
146: a4 := JTF_NUMBER_TABLE();
147: a5 := JTF_NUMBER_TABLE();
148: a6 := JTF_NUMBER_TABLE();
149: a7 := JTF_VARCHAR2_TABLE_100();
150: a8 := JTF_NUMBER_TABLE();
151: a9 := JTF_NUMBER_TABLE();

Line 148: a6 := JTF_NUMBER_TABLE();

144: a2 := JTF_NUMBER_TABLE();
145: a3 := JTF_DATE_TABLE();
146: a4 := JTF_NUMBER_TABLE();
147: a5 := JTF_NUMBER_TABLE();
148: a6 := JTF_NUMBER_TABLE();
149: a7 := JTF_VARCHAR2_TABLE_100();
150: a8 := JTF_NUMBER_TABLE();
151: a9 := JTF_NUMBER_TABLE();
152: a10 := JTF_NUMBER_TABLE();

Line 150: a8 := JTF_NUMBER_TABLE();

146: a4 := JTF_NUMBER_TABLE();
147: a5 := JTF_NUMBER_TABLE();
148: a6 := JTF_NUMBER_TABLE();
149: a7 := JTF_VARCHAR2_TABLE_100();
150: a8 := JTF_NUMBER_TABLE();
151: a9 := JTF_NUMBER_TABLE();
152: a10 := JTF_NUMBER_TABLE();
153: a11 := JTF_VARCHAR2_TABLE_100();
154: a12 := JTF_NUMBER_TABLE();

Line 151: a9 := JTF_NUMBER_TABLE();

147: a5 := JTF_NUMBER_TABLE();
148: a6 := JTF_NUMBER_TABLE();
149: a7 := JTF_VARCHAR2_TABLE_100();
150: a8 := JTF_NUMBER_TABLE();
151: a9 := JTF_NUMBER_TABLE();
152: a10 := JTF_NUMBER_TABLE();
153: a11 := JTF_VARCHAR2_TABLE_100();
154: a12 := JTF_NUMBER_TABLE();
155: a13 := JTF_VARCHAR2_TABLE_100();

Line 152: a10 := JTF_NUMBER_TABLE();

148: a6 := JTF_NUMBER_TABLE();
149: a7 := JTF_VARCHAR2_TABLE_100();
150: a8 := JTF_NUMBER_TABLE();
151: a9 := JTF_NUMBER_TABLE();
152: a10 := JTF_NUMBER_TABLE();
153: a11 := JTF_VARCHAR2_TABLE_100();
154: a12 := JTF_NUMBER_TABLE();
155: a13 := JTF_VARCHAR2_TABLE_100();
156: a14 := JTF_VARCHAR2_TABLE_100();

Line 154: a12 := JTF_NUMBER_TABLE();

150: a8 := JTF_NUMBER_TABLE();
151: a9 := JTF_NUMBER_TABLE();
152: a10 := JTF_NUMBER_TABLE();
153: a11 := JTF_VARCHAR2_TABLE_100();
154: a12 := JTF_NUMBER_TABLE();
155: a13 := JTF_VARCHAR2_TABLE_100();
156: a14 := JTF_VARCHAR2_TABLE_100();
157: a15 := JTF_VARCHAR2_TABLE_100();
158: a16 := JTF_VARCHAR2_TABLE_100();

Line 176: a0 := JTF_NUMBER_TABLE();

172: a30 := JTF_VARCHAR2_TABLE_200();
173: a31 := JTF_VARCHAR2_TABLE_200();
174: a32 := JTF_VARCHAR2_TABLE_4000();
175: else
176: a0 := JTF_NUMBER_TABLE();
177: a1 := JTF_DATE_TABLE();
178: a2 := JTF_NUMBER_TABLE();
179: a3 := JTF_DATE_TABLE();
180: a4 := JTF_NUMBER_TABLE();

Line 178: a2 := JTF_NUMBER_TABLE();

174: a32 := JTF_VARCHAR2_TABLE_4000();
175: else
176: a0 := JTF_NUMBER_TABLE();
177: a1 := JTF_DATE_TABLE();
178: a2 := JTF_NUMBER_TABLE();
179: a3 := JTF_DATE_TABLE();
180: a4 := JTF_NUMBER_TABLE();
181: a5 := JTF_NUMBER_TABLE();
182: a6 := JTF_NUMBER_TABLE();

Line 180: a4 := JTF_NUMBER_TABLE();

176: a0 := JTF_NUMBER_TABLE();
177: a1 := JTF_DATE_TABLE();
178: a2 := JTF_NUMBER_TABLE();
179: a3 := JTF_DATE_TABLE();
180: a4 := JTF_NUMBER_TABLE();
181: a5 := JTF_NUMBER_TABLE();
182: a6 := JTF_NUMBER_TABLE();
183: a7 := JTF_VARCHAR2_TABLE_100();
184: a8 := JTF_NUMBER_TABLE();

Line 181: a5 := JTF_NUMBER_TABLE();

177: a1 := JTF_DATE_TABLE();
178: a2 := JTF_NUMBER_TABLE();
179: a3 := JTF_DATE_TABLE();
180: a4 := JTF_NUMBER_TABLE();
181: a5 := JTF_NUMBER_TABLE();
182: a6 := JTF_NUMBER_TABLE();
183: a7 := JTF_VARCHAR2_TABLE_100();
184: a8 := JTF_NUMBER_TABLE();
185: a9 := JTF_NUMBER_TABLE();

Line 182: a6 := JTF_NUMBER_TABLE();

178: a2 := JTF_NUMBER_TABLE();
179: a3 := JTF_DATE_TABLE();
180: a4 := JTF_NUMBER_TABLE();
181: a5 := JTF_NUMBER_TABLE();
182: a6 := JTF_NUMBER_TABLE();
183: a7 := JTF_VARCHAR2_TABLE_100();
184: a8 := JTF_NUMBER_TABLE();
185: a9 := JTF_NUMBER_TABLE();
186: a10 := JTF_NUMBER_TABLE();

Line 184: a8 := JTF_NUMBER_TABLE();

180: a4 := JTF_NUMBER_TABLE();
181: a5 := JTF_NUMBER_TABLE();
182: a6 := JTF_NUMBER_TABLE();
183: a7 := JTF_VARCHAR2_TABLE_100();
184: a8 := JTF_NUMBER_TABLE();
185: a9 := JTF_NUMBER_TABLE();
186: a10 := JTF_NUMBER_TABLE();
187: a11 := JTF_VARCHAR2_TABLE_100();
188: a12 := JTF_NUMBER_TABLE();

Line 185: a9 := JTF_NUMBER_TABLE();

181: a5 := JTF_NUMBER_TABLE();
182: a6 := JTF_NUMBER_TABLE();
183: a7 := JTF_VARCHAR2_TABLE_100();
184: a8 := JTF_NUMBER_TABLE();
185: a9 := JTF_NUMBER_TABLE();
186: a10 := JTF_NUMBER_TABLE();
187: a11 := JTF_VARCHAR2_TABLE_100();
188: a12 := JTF_NUMBER_TABLE();
189: a13 := JTF_VARCHAR2_TABLE_100();

Line 186: a10 := JTF_NUMBER_TABLE();

182: a6 := JTF_NUMBER_TABLE();
183: a7 := JTF_VARCHAR2_TABLE_100();
184: a8 := JTF_NUMBER_TABLE();
185: a9 := JTF_NUMBER_TABLE();
186: a10 := JTF_NUMBER_TABLE();
187: a11 := JTF_VARCHAR2_TABLE_100();
188: a12 := JTF_NUMBER_TABLE();
189: a13 := JTF_VARCHAR2_TABLE_100();
190: a14 := JTF_VARCHAR2_TABLE_100();

Line 188: a12 := JTF_NUMBER_TABLE();

184: a8 := JTF_NUMBER_TABLE();
185: a9 := JTF_NUMBER_TABLE();
186: a10 := JTF_NUMBER_TABLE();
187: a11 := JTF_VARCHAR2_TABLE_100();
188: a12 := JTF_NUMBER_TABLE();
189: a13 := JTF_VARCHAR2_TABLE_100();
190: a14 := JTF_VARCHAR2_TABLE_100();
191: a15 := JTF_VARCHAR2_TABLE_100();
192: a16 := JTF_VARCHAR2_TABLE_100();