DBA Data[Home] [Help]

APPS.AS_MULTI_CURRENCIES_PKG_W dependencies on JTF_NUMBER_TABLE

Line 29: , a7 JTF_NUMBER_TABLE

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
33: , a11 JTF_NUMBER_TABLE

Line 31: , a9 JTF_NUMBER_TABLE

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
35: ddindx binary_integer; indx binary_integer;

Line 32: , a10 JTF_NUMBER_TABLE

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
35: ddindx binary_integer; indx binary_integer;
36: begin

Line 33: , a11 JTF_NUMBER_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
35: ddindx binary_integer; indx binary_integer;
36: begin
37: if a0 is not null and a0.count > 0 then

Line 70: , a7 out nocopy JTF_NUMBER_TABLE

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
74: , a11 out nocopy JTF_NUMBER_TABLE

Line 72: , a9 out nocopy JTF_NUMBER_TABLE

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
76: ddindx binary_integer; indx binary_integer;

Line 73: , a10 out nocopy JTF_NUMBER_TABLE

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
76: ddindx binary_integer; indx binary_integer;
77: begin

Line 74: , a11 out nocopy JTF_NUMBER_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
76: ddindx binary_integer; indx binary_integer;
77: begin
78: if t is null or t.count = 0 then

Line 86: a7 := JTF_NUMBER_TABLE();

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();
90: a11 := JTF_NUMBER_TABLE();

Line 88: a9 := JTF_NUMBER_TABLE();

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
92: a0 := JTF_VARCHAR2_TABLE_100();

Line 89: a10 := JTF_NUMBER_TABLE();

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
92: a0 := JTF_VARCHAR2_TABLE_100();
93: a1 := JTF_VARCHAR2_TABLE_100();

Line 90: a11 := JTF_NUMBER_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
92: a0 := JTF_VARCHAR2_TABLE_100();
93: a1 := JTF_VARCHAR2_TABLE_100();
94: a2 := JTF_VARCHAR2_TABLE_100();

Line 99: a7 := JTF_NUMBER_TABLE();

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();
103: a11 := JTF_NUMBER_TABLE();

Line 101: a9 := JTF_NUMBER_TABLE();

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
105: a0.extend(t.count);

Line 102: a10 := JTF_NUMBER_TABLE();

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
105: a0.extend(t.count);
106: a1.extend(t.count);

Line 103: a11 := JTF_NUMBER_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
105: a0.extend(t.count);
106: a1.extend(t.count);
107: a2.extend(t.count);

Line 146: , a4 JTF_NUMBER_TABLE

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;
149: begin
150: if a0 is not null and a0.count > 0 then

Line 173: , a4 out nocopy JTF_NUMBER_TABLE

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;
176: begin
177: if t is null or t.count = 0 then

Line 182: a4 := JTF_NUMBER_TABLE();

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();
185: a1 := JTF_VARCHAR2_TABLE_100();
186: a2 := JTF_DATE_TABLE();

Line 188: a4 := JTF_NUMBER_TABLE();

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);
191: a1.extend(t.count);
192: a2.extend(t.count);

Line 220: , p0_a7 JTF_NUMBER_TABLE

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
224: , p0_a11 JTF_NUMBER_TABLE

Line 222: , p0_a9 JTF_NUMBER_TABLE

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
226: , x_msg_count out nocopy NUMBER

Line 223: , p0_a10 JTF_NUMBER_TABLE

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
226: , x_msg_count out nocopy NUMBER
227: , x_msg_data out nocopy VARCHAR2

Line 224: , p0_a11 JTF_NUMBER_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
226: , x_msg_count out nocopy NUMBER
227: , x_msg_data out nocopy VARCHAR2
228: )

Line 272: , p0_a7 JTF_NUMBER_TABLE

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
276: , p0_a11 JTF_NUMBER_TABLE

Line 274: , p0_a9 JTF_NUMBER_TABLE

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
278: , x_msg_count out nocopy NUMBER

Line 275: , p0_a10 JTF_NUMBER_TABLE

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
278: , x_msg_count out nocopy NUMBER
279: , x_msg_data out nocopy VARCHAR2

Line 276: , p0_a11 JTF_NUMBER_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
278: , x_msg_count out nocopy NUMBER
279: , x_msg_data out nocopy VARCHAR2
280: )

Line 324: , p0_a7 JTF_NUMBER_TABLE

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
328: , p0_a11 JTF_NUMBER_TABLE

Line 326: , p0_a9 JTF_NUMBER_TABLE

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
330: , x_msg_count out nocopy NUMBER

Line 327: , p0_a10 JTF_NUMBER_TABLE

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
330: , x_msg_count out nocopy NUMBER
331: , x_msg_data out nocopy VARCHAR2

Line 328: , p0_a11 JTF_NUMBER_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
330: , x_msg_count out nocopy NUMBER
331: , x_msg_data out nocopy VARCHAR2
332: )

Line 373: , p0_a4 JTF_NUMBER_TABLE

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
376: , x_msg_data out nocopy VARCHAR2
377: )

Line 411: , p0_a4 JTF_NUMBER_TABLE

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
414: , x_msg_data out nocopy VARCHAR2
415: )

Line 449: , p0_a4 JTF_NUMBER_TABLE

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
452: , x_msg_data out nocopy VARCHAR2
453: )