eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AMV_STOCK_PVT_W dependencies on JTF_VARCHAR2_TABLE_100

Line 22: procedure rosetta_table_copy_in_p6(t out nocopy amv_stock_pvt.amv_tkr_varray_type, a0 JTF_VARCHAR2_TABLE_100

18: if n=b then return a; end if;
19: return n;
20: end;
21:
22: procedure rosetta_table_copy_in_p6(t out nocopy amv_stock_pvt.amv_tkr_varray_type, a0 JTF_VARCHAR2_TABLE_100
23: , a1 JTF_NUMBER_TABLE
24: ) as
25: ddindx binary_integer; indx binary_integer;
26: begin

Line 43: procedure rosetta_table_copy_out_p6(t amv_stock_pvt.amv_tkr_varray_type, a0 out nocopy JTF_VARCHAR2_TABLE_100

39: end loop;
40: end if;
41: end if;
42: end rosetta_table_copy_in_p6;
43: procedure rosetta_table_copy_out_p6(t amv_stock_pvt.amv_tkr_varray_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
44: , a1 out nocopy JTF_NUMBER_TABLE
45: ) as
46: ddindx binary_integer; indx binary_integer;
47: begin

Line 49: a0 := JTF_VARCHAR2_TABLE_100();

45: ) as
46: ddindx binary_integer; indx binary_integer;
47: begin
48: if t is null or t.count = 0 then
49: a0 := JTF_VARCHAR2_TABLE_100();
50: a1 := JTF_NUMBER_TABLE();
51: else
52: a0 := JTF_VARCHAR2_TABLE_100();
53: a1 := JTF_NUMBER_TABLE();

Line 52: a0 := JTF_VARCHAR2_TABLE_100();

48: if t is null or t.count = 0 then
49: a0 := JTF_VARCHAR2_TABLE_100();
50: a1 := JTF_NUMBER_TABLE();
51: else
52: a0 := JTF_VARCHAR2_TABLE_100();
53: a1 := JTF_NUMBER_TABLE();
54: if t.count > 0 then
55: a0.extend(t.count);
56: a1.extend(t.count);

Line 73: , a1 JTF_VARCHAR2_TABLE_100

69: end if;
70: end rosetta_table_copy_out_p6;
71:
72: procedure rosetta_table_copy_in_p7(t out nocopy amv_stock_pvt.amv_sym_varray_type, a0 JTF_NUMBER_TABLE
73: , a1 JTF_VARCHAR2_TABLE_100
74: , a2 JTF_VARCHAR2_TABLE_100
75: ) as
76: ddindx binary_integer; indx binary_integer;
77: begin

Line 74: , a2 JTF_VARCHAR2_TABLE_100

70: end rosetta_table_copy_out_p6;
71:
72: procedure rosetta_table_copy_in_p7(t out nocopy amv_stock_pvt.amv_sym_varray_type, a0 JTF_NUMBER_TABLE
73: , a1 JTF_VARCHAR2_TABLE_100
74: , a2 JTF_VARCHAR2_TABLE_100
75: ) as
76: ddindx binary_integer; indx binary_integer;
77: begin
78: if a0 is not null and a0.count > 0 then

Line 96: , a1 out nocopy JTF_VARCHAR2_TABLE_100

92: end if;
93: end if;
94: end rosetta_table_copy_in_p7;
95: procedure rosetta_table_copy_out_p7(t amv_stock_pvt.amv_sym_varray_type, a0 out nocopy JTF_NUMBER_TABLE
96: , a1 out nocopy JTF_VARCHAR2_TABLE_100
97: , a2 out nocopy JTF_VARCHAR2_TABLE_100
98: ) as
99: ddindx binary_integer; indx binary_integer;
100: begin

Line 97: , a2 out nocopy JTF_VARCHAR2_TABLE_100

93: end if;
94: end rosetta_table_copy_in_p7;
95: procedure rosetta_table_copy_out_p7(t amv_stock_pvt.amv_sym_varray_type, a0 out nocopy JTF_NUMBER_TABLE
96: , a1 out nocopy JTF_VARCHAR2_TABLE_100
97: , a2 out nocopy JTF_VARCHAR2_TABLE_100
98: ) as
99: ddindx binary_integer; indx binary_integer;
100: begin
101: if t is null or t.count = 0 then

Line 103: a1 := JTF_VARCHAR2_TABLE_100();

99: ddindx binary_integer; indx binary_integer;
100: begin
101: if t is null or t.count = 0 then
102: a0 := JTF_NUMBER_TABLE();
103: a1 := JTF_VARCHAR2_TABLE_100();
104: a2 := JTF_VARCHAR2_TABLE_100();
105: else
106: a0 := JTF_NUMBER_TABLE();
107: a1 := JTF_VARCHAR2_TABLE_100();

Line 104: a2 := JTF_VARCHAR2_TABLE_100();

100: begin
101: if t is null or t.count = 0 then
102: a0 := JTF_NUMBER_TABLE();
103: a1 := JTF_VARCHAR2_TABLE_100();
104: a2 := JTF_VARCHAR2_TABLE_100();
105: else
106: a0 := JTF_NUMBER_TABLE();
107: a1 := JTF_VARCHAR2_TABLE_100();
108: a2 := JTF_VARCHAR2_TABLE_100();

Line 107: a1 := JTF_VARCHAR2_TABLE_100();

103: a1 := JTF_VARCHAR2_TABLE_100();
104: a2 := JTF_VARCHAR2_TABLE_100();
105: else
106: a0 := JTF_NUMBER_TABLE();
107: a1 := JTF_VARCHAR2_TABLE_100();
108: a2 := JTF_VARCHAR2_TABLE_100();
109: if t.count > 0 then
110: a0.extend(t.count);
111: a1.extend(t.count);

Line 108: a2 := JTF_VARCHAR2_TABLE_100();

104: a2 := JTF_VARCHAR2_TABLE_100();
105: else
106: a0 := JTF_NUMBER_TABLE();
107: a1 := JTF_VARCHAR2_TABLE_100();
108: a2 := JTF_VARCHAR2_TABLE_100();
109: if t.count > 0 then
110: a0.extend(t.count);
111: a1.extend(t.count);
112: a2.extend(t.count);

Line 130: , a1 JTF_VARCHAR2_TABLE_100

126: end if;
127: end rosetta_table_copy_out_p7;
128:
129: procedure rosetta_table_copy_in_p8(t out nocopy amv_stock_pvt.amv_stk_varray_type, a0 JTF_NUMBER_TABLE
130: , a1 JTF_VARCHAR2_TABLE_100
131: , a2 JTF_VARCHAR2_TABLE_300
132: , a3 JTF_NUMBER_TABLE
133: , a4 JTF_NUMBER_TABLE
134: ) as

Line 157: , a1 out nocopy JTF_VARCHAR2_TABLE_100

153: end if;
154: end if;
155: end rosetta_table_copy_in_p8;
156: procedure rosetta_table_copy_out_p8(t amv_stock_pvt.amv_stk_varray_type, a0 out nocopy JTF_NUMBER_TABLE
157: , a1 out nocopy JTF_VARCHAR2_TABLE_100
158: , a2 out nocopy JTF_VARCHAR2_TABLE_300
159: , a3 out nocopy JTF_NUMBER_TABLE
160: , a4 out nocopy JTF_NUMBER_TABLE
161: ) as

Line 166: a1 := JTF_VARCHAR2_TABLE_100();

162: ddindx binary_integer; indx binary_integer;
163: begin
164: if t is null or t.count = 0 then
165: a0 := JTF_NUMBER_TABLE();
166: a1 := JTF_VARCHAR2_TABLE_100();
167: a2 := JTF_VARCHAR2_TABLE_300();
168: a3 := JTF_NUMBER_TABLE();
169: a4 := JTF_NUMBER_TABLE();
170: else

Line 172: a1 := JTF_VARCHAR2_TABLE_100();

168: a3 := JTF_NUMBER_TABLE();
169: a4 := JTF_NUMBER_TABLE();
170: else
171: a0 := JTF_NUMBER_TABLE();
172: a1 := JTF_VARCHAR2_TABLE_100();
173: a2 := JTF_VARCHAR2_TABLE_300();
174: a3 := JTF_NUMBER_TABLE();
175: a4 := JTF_NUMBER_TABLE();
176: if t.count > 0 then

Line 200: procedure rosetta_table_copy_in_p9(t out nocopy amv_stock_pvt.amv_news_varray_type, a0 JTF_VARCHAR2_TABLE_100

196: end if;
197: end if;
198: end rosetta_table_copy_out_p8;
199:
200: procedure rosetta_table_copy_in_p9(t out nocopy amv_stock_pvt.amv_news_varray_type, a0 JTF_VARCHAR2_TABLE_100
201: , a1 JTF_VARCHAR2_TABLE_2000
202: , a2 JTF_VARCHAR2_TABLE_2000
203: , a3 JTF_VARCHAR2_TABLE_300
204: , a4 JTF_DATE_TABLE

Line 227: procedure rosetta_table_copy_out_p9(t amv_stock_pvt.amv_news_varray_type, a0 out nocopy JTF_VARCHAR2_TABLE_100

223: end loop;
224: end if;
225: end if;
226: end rosetta_table_copy_in_p9;
227: procedure rosetta_table_copy_out_p9(t amv_stock_pvt.amv_news_varray_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
228: , a1 out nocopy JTF_VARCHAR2_TABLE_2000
229: , a2 out nocopy JTF_VARCHAR2_TABLE_2000
230: , a3 out nocopy JTF_VARCHAR2_TABLE_300
231: , a4 out nocopy JTF_DATE_TABLE

Line 236: a0 := JTF_VARCHAR2_TABLE_100();

232: ) as
233: ddindx binary_integer; indx binary_integer;
234: begin
235: if t is null or t.count = 0 then
236: a0 := JTF_VARCHAR2_TABLE_100();
237: a1 := JTF_VARCHAR2_TABLE_2000();
238: a2 := JTF_VARCHAR2_TABLE_2000();
239: a3 := JTF_VARCHAR2_TABLE_300();
240: a4 := JTF_DATE_TABLE();

Line 242: a0 := JTF_VARCHAR2_TABLE_100();

238: a2 := JTF_VARCHAR2_TABLE_2000();
239: a3 := JTF_VARCHAR2_TABLE_300();
240: a4 := JTF_DATE_TABLE();
241: else
242: a0 := JTF_VARCHAR2_TABLE_100();
243: a1 := JTF_VARCHAR2_TABLE_2000();
244: a2 := JTF_VARCHAR2_TABLE_2000();
245: a3 := JTF_VARCHAR2_TABLE_300();
246: a4 := JTF_DATE_TABLE();

Line 363: , p9_a1 out nocopy JTF_VARCHAR2_TABLE_100

359: , p_user_id NUMBER
360: , p_distinct_stocks VARCHAR2
361: , p_sort_order VARCHAR2
362: , p9_a0 out nocopy JTF_NUMBER_TABLE
363: , p9_a1 out nocopy JTF_VARCHAR2_TABLE_100
364: , p9_a2 out nocopy JTF_VARCHAR2_TABLE_300
365: , p9_a3 out nocopy JTF_NUMBER_TABLE
366: , p9_a4 out nocopy JTF_NUMBER_TABLE
367: )

Line 423: , p7_a1 out nocopy JTF_VARCHAR2_TABLE_100

419: , x_msg_count out nocopy NUMBER
420: , x_msg_data out nocopy VARCHAR2
421: , p_symbols VARCHAR2
422: , p7_a0 out nocopy JTF_NUMBER_TABLE
423: , p7_a1 out nocopy JTF_VARCHAR2_TABLE_100
424: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_300
425: , p7_a3 out nocopy JTF_NUMBER_TABLE
426: , p7_a4 out nocopy JTF_NUMBER_TABLE
427: )

Line 479: , p9_a1 out nocopy JTF_VARCHAR2_TABLE_100

475: , p_vendor_id NUMBER
476: , p_start_index NUMBER
477: , p_batch_size NUMBER
478: , p9_a0 out nocopy JTF_NUMBER_TABLE
479: , p9_a1 out nocopy JTF_VARCHAR2_TABLE_100
480: , p9_a2 out nocopy JTF_VARCHAR2_TABLE_100
481: )
482:
483: as

Line 480: , p9_a2 out nocopy JTF_VARCHAR2_TABLE_100

476: , p_start_index NUMBER
477: , p_batch_size NUMBER
478: , p9_a0 out nocopy JTF_NUMBER_TABLE
479: , p9_a1 out nocopy JTF_VARCHAR2_TABLE_100
480: , p9_a2 out nocopy JTF_VARCHAR2_TABLE_100
481: )
482:
483: as
484: ddx_stocks_array amv_stock_pvt.amv_sym_varray_type;

Line 692: , p8_a0 out nocopy JTF_VARCHAR2_TABLE_100

688: , x_return_status out nocopy VARCHAR2
689: , x_msg_count out nocopy NUMBER
690: , x_msg_data out nocopy VARCHAR2
691: , p_stock_id NUMBER
692: , p8_a0 out nocopy JTF_VARCHAR2_TABLE_100
693: , p8_a1 out nocopy JTF_VARCHAR2_TABLE_2000
694: , p8_a2 out nocopy JTF_VARCHAR2_TABLE_2000
695: , p8_a3 out nocopy JTF_VARCHAR2_TABLE_300
696: , p8_a4 out nocopy JTF_DATE_TABLE