DBA Data[Home] [Help]

APPS.AS_MULTI_CURRENCIES_PKG_W dependencies on JTF_DATE_TABLE

Line 28: , a6 JTF_DATE_TABLE

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

Line 30: , a8 JTF_DATE_TABLE

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

Line 69: , a6 out nocopy JTF_DATE_TABLE

65: , a2 out nocopy JTF_VARCHAR2_TABLE_100
66: , a3 out nocopy JTF_VARCHAR2_TABLE_100
67: , a4 out nocopy JTF_VARCHAR2_TABLE_100
68: , a5 out nocopy JTF_VARCHAR2_TABLE_100
69: , a6 out nocopy JTF_DATE_TABLE
70: , a7 out nocopy JTF_NUMBER_TABLE
71: , a8 out nocopy JTF_DATE_TABLE
72: , a9 out nocopy JTF_NUMBER_TABLE
73: , a10 out nocopy JTF_NUMBER_TABLE

Line 71: , a8 out nocopy JTF_DATE_TABLE

67: , a4 out nocopy JTF_VARCHAR2_TABLE_100
68: , a5 out nocopy JTF_VARCHAR2_TABLE_100
69: , a6 out nocopy JTF_DATE_TABLE
70: , a7 out nocopy JTF_NUMBER_TABLE
71: , a8 out nocopy JTF_DATE_TABLE
72: , a9 out nocopy JTF_NUMBER_TABLE
73: , a10 out nocopy JTF_NUMBER_TABLE
74: , a11 out nocopy JTF_NUMBER_TABLE
75: ) as

Line 85: a6 := JTF_DATE_TABLE();

81: a2 := JTF_VARCHAR2_TABLE_100();
82: a3 := JTF_VARCHAR2_TABLE_100();
83: a4 := JTF_VARCHAR2_TABLE_100();
84: a5 := JTF_VARCHAR2_TABLE_100();
85: a6 := JTF_DATE_TABLE();
86: a7 := JTF_NUMBER_TABLE();
87: a8 := JTF_DATE_TABLE();
88: a9 := JTF_NUMBER_TABLE();
89: a10 := JTF_NUMBER_TABLE();

Line 87: a8 := JTF_DATE_TABLE();

83: a4 := JTF_VARCHAR2_TABLE_100();
84: a5 := JTF_VARCHAR2_TABLE_100();
85: a6 := JTF_DATE_TABLE();
86: a7 := JTF_NUMBER_TABLE();
87: a8 := JTF_DATE_TABLE();
88: a9 := JTF_NUMBER_TABLE();
89: a10 := JTF_NUMBER_TABLE();
90: a11 := JTF_NUMBER_TABLE();
91: else

Line 98: a6 := JTF_DATE_TABLE();

94: a2 := JTF_VARCHAR2_TABLE_100();
95: a3 := JTF_VARCHAR2_TABLE_100();
96: a4 := JTF_VARCHAR2_TABLE_100();
97: a5 := JTF_VARCHAR2_TABLE_100();
98: a6 := JTF_DATE_TABLE();
99: a7 := JTF_NUMBER_TABLE();
100: a8 := JTF_DATE_TABLE();
101: a9 := JTF_NUMBER_TABLE();
102: a10 := JTF_NUMBER_TABLE();

Line 100: a8 := JTF_DATE_TABLE();

96: a4 := JTF_VARCHAR2_TABLE_100();
97: a5 := JTF_VARCHAR2_TABLE_100();
98: a6 := JTF_DATE_TABLE();
99: a7 := JTF_NUMBER_TABLE();
100: a8 := JTF_DATE_TABLE();
101: a9 := JTF_NUMBER_TABLE();
102: a10 := JTF_NUMBER_TABLE();
103: a11 := JTF_NUMBER_TABLE();
104: if t.count > 0 then

Line 144: , a2 JTF_DATE_TABLE

140: end rosetta_table_copy_out_p3;
141:
142: procedure rosetta_table_copy_in_p7(t out nocopy as_multi_currencies_pkg.period_rates_tbl_type, a0 JTF_VARCHAR2_TABLE_100
143: , a1 JTF_VARCHAR2_TABLE_100
144: , a2 JTF_DATE_TABLE
145: , a3 JTF_VARCHAR2_TABLE_100
146: , a4 JTF_NUMBER_TABLE
147: ) as
148: ddindx binary_integer; indx binary_integer;

Line 171: , a2 out nocopy JTF_DATE_TABLE

167: end if;
168: end rosetta_table_copy_in_p7;
169: procedure rosetta_table_copy_out_p7(t as_multi_currencies_pkg.period_rates_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
170: , a1 out nocopy JTF_VARCHAR2_TABLE_100
171: , a2 out nocopy JTF_DATE_TABLE
172: , a3 out nocopy JTF_VARCHAR2_TABLE_100
173: , a4 out nocopy JTF_NUMBER_TABLE
174: ) as
175: ddindx binary_integer; indx binary_integer;

Line 180: a2 := JTF_DATE_TABLE();

176: begin
177: if t is null or t.count = 0 then
178: a0 := JTF_VARCHAR2_TABLE_100();
179: a1 := JTF_VARCHAR2_TABLE_100();
180: a2 := JTF_DATE_TABLE();
181: a3 := JTF_VARCHAR2_TABLE_100();
182: a4 := JTF_NUMBER_TABLE();
183: else
184: a0 := JTF_VARCHAR2_TABLE_100();

Line 186: a2 := JTF_DATE_TABLE();

182: a4 := JTF_NUMBER_TABLE();
183: else
184: a0 := JTF_VARCHAR2_TABLE_100();
185: a1 := JTF_VARCHAR2_TABLE_100();
186: a2 := JTF_DATE_TABLE();
187: a3 := JTF_VARCHAR2_TABLE_100();
188: a4 := JTF_NUMBER_TABLE();
189: if t.count > 0 then
190: a0.extend(t.count);

Line 219: , p0_a6 JTF_DATE_TABLE

215: , p0_a2 JTF_VARCHAR2_TABLE_100
216: , p0_a3 JTF_VARCHAR2_TABLE_100
217: , p0_a4 JTF_VARCHAR2_TABLE_100
218: , p0_a5 JTF_VARCHAR2_TABLE_100
219: , p0_a6 JTF_DATE_TABLE
220: , p0_a7 JTF_NUMBER_TABLE
221: , p0_a8 JTF_DATE_TABLE
222: , p0_a9 JTF_NUMBER_TABLE
223: , p0_a10 JTF_NUMBER_TABLE

Line 221: , p0_a8 JTF_DATE_TABLE

217: , p0_a4 JTF_VARCHAR2_TABLE_100
218: , p0_a5 JTF_VARCHAR2_TABLE_100
219: , p0_a6 JTF_DATE_TABLE
220: , p0_a7 JTF_NUMBER_TABLE
221: , p0_a8 JTF_DATE_TABLE
222: , p0_a9 JTF_NUMBER_TABLE
223: , p0_a10 JTF_NUMBER_TABLE
224: , p0_a11 JTF_NUMBER_TABLE
225: , x_return_status out nocopy VARCHAR2

Line 271: , p0_a6 JTF_DATE_TABLE

267: , p0_a2 JTF_VARCHAR2_TABLE_100
268: , p0_a3 JTF_VARCHAR2_TABLE_100
269: , p0_a4 JTF_VARCHAR2_TABLE_100
270: , p0_a5 JTF_VARCHAR2_TABLE_100
271: , p0_a6 JTF_DATE_TABLE
272: , p0_a7 JTF_NUMBER_TABLE
273: , p0_a8 JTF_DATE_TABLE
274: , p0_a9 JTF_NUMBER_TABLE
275: , p0_a10 JTF_NUMBER_TABLE

Line 273: , p0_a8 JTF_DATE_TABLE

269: , p0_a4 JTF_VARCHAR2_TABLE_100
270: , p0_a5 JTF_VARCHAR2_TABLE_100
271: , p0_a6 JTF_DATE_TABLE
272: , p0_a7 JTF_NUMBER_TABLE
273: , p0_a8 JTF_DATE_TABLE
274: , p0_a9 JTF_NUMBER_TABLE
275: , p0_a10 JTF_NUMBER_TABLE
276: , p0_a11 JTF_NUMBER_TABLE
277: , x_return_status out nocopy VARCHAR2

Line 323: , p0_a6 JTF_DATE_TABLE

319: , p0_a2 JTF_VARCHAR2_TABLE_100
320: , p0_a3 JTF_VARCHAR2_TABLE_100
321: , p0_a4 JTF_VARCHAR2_TABLE_100
322: , p0_a5 JTF_VARCHAR2_TABLE_100
323: , p0_a6 JTF_DATE_TABLE
324: , p0_a7 JTF_NUMBER_TABLE
325: , p0_a8 JTF_DATE_TABLE
326: , p0_a9 JTF_NUMBER_TABLE
327: , p0_a10 JTF_NUMBER_TABLE

Line 325: , p0_a8 JTF_DATE_TABLE

321: , p0_a4 JTF_VARCHAR2_TABLE_100
322: , p0_a5 JTF_VARCHAR2_TABLE_100
323: , p0_a6 JTF_DATE_TABLE
324: , p0_a7 JTF_NUMBER_TABLE
325: , p0_a8 JTF_DATE_TABLE
326: , p0_a9 JTF_NUMBER_TABLE
327: , p0_a10 JTF_NUMBER_TABLE
328: , p0_a11 JTF_NUMBER_TABLE
329: , x_return_status out nocopy VARCHAR2

Line 371: , p0_a2 JTF_DATE_TABLE

367: end;
368:
369: procedure insert_period_rates(p0_a0 JTF_VARCHAR2_TABLE_100
370: , p0_a1 JTF_VARCHAR2_TABLE_100
371: , p0_a2 JTF_DATE_TABLE
372: , p0_a3 JTF_VARCHAR2_TABLE_100
373: , p0_a4 JTF_NUMBER_TABLE
374: , x_return_status out nocopy VARCHAR2
375: , x_msg_count out nocopy NUMBER

Line 409: , p0_a2 JTF_DATE_TABLE

405: end;
406:
407: procedure update_period_rates(p0_a0 JTF_VARCHAR2_TABLE_100
408: , p0_a1 JTF_VARCHAR2_TABLE_100
409: , p0_a2 JTF_DATE_TABLE
410: , p0_a3 JTF_VARCHAR2_TABLE_100
411: , p0_a4 JTF_NUMBER_TABLE
412: , x_return_status out nocopy VARCHAR2
413: , x_msg_count out nocopy NUMBER

Line 447: , p0_a2 JTF_DATE_TABLE

443: end;
444:
445: procedure delete_period_rates(p0_a0 JTF_VARCHAR2_TABLE_100
446: , p0_a1 JTF_VARCHAR2_TABLE_100
447: , p0_a2 JTF_DATE_TABLE
448: , p0_a3 JTF_VARCHAR2_TABLE_100
449: , p0_a4 JTF_NUMBER_TABLE
450: , x_return_status out nocopy VARCHAR2
451: , x_msg_count out nocopy NUMBER