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_NUMBER_TABLE

Line 23: , a1 JTF_NUMBER_TABLE

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
27: if a0 is not null and a0.count > 0 then

Line 44: , a1 out nocopy JTF_NUMBER_TABLE

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
48: if t is null or t.count = 0 then

Line 50: a1 := JTF_NUMBER_TABLE();

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();
54: if t.count > 0 then

Line 53: a1 := JTF_NUMBER_TABLE();

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);
57: ddindx := t.first;

Line 72: procedure rosetta_table_copy_in_p7(t out nocopy amv_stock_pvt.amv_sym_varray_type, a0 JTF_NUMBER_TABLE

68: end if;
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;

Line 95: procedure rosetta_table_copy_out_p7(t amv_stock_pvt.amv_sym_varray_type, a0 out nocopy JTF_NUMBER_TABLE

91: end loop;
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;

Line 102: a0 := JTF_NUMBER_TABLE();

98: ) as
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();

Line 106: a0 := JTF_NUMBER_TABLE();

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();
109: if t.count > 0 then
110: a0.extend(t.count);

Line 129: procedure rosetta_table_copy_in_p8(t out nocopy amv_stock_pvt.amv_stk_varray_type, a0 JTF_NUMBER_TABLE

125: end if;
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

Line 132: , a3 JTF_NUMBER_TABLE

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
135: ddindx binary_integer; indx binary_integer;
136: begin

Line 133: , a4 JTF_NUMBER_TABLE

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
135: ddindx binary_integer; indx binary_integer;
136: begin
137: if a0 is not null and a0.count > 0 then

Line 156: procedure rosetta_table_copy_out_p8(t amv_stock_pvt.amv_stk_varray_type, a0 out nocopy JTF_NUMBER_TABLE

152: end loop;
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

Line 159: , a3 out nocopy JTF_NUMBER_TABLE

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
162: ddindx binary_integer; indx binary_integer;
163: begin

Line 160: , a4 out nocopy JTF_NUMBER_TABLE

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
162: ddindx binary_integer; indx binary_integer;
163: begin
164: if t is null or t.count = 0 then

Line 165: a0 := JTF_NUMBER_TABLE();

161: ) as
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();

Line 168: a3 := JTF_NUMBER_TABLE();

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
171: a0 := JTF_NUMBER_TABLE();
172: a1 := JTF_VARCHAR2_TABLE_100();

Line 169: a4 := JTF_NUMBER_TABLE();

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
171: a0 := JTF_NUMBER_TABLE();
172: a1 := JTF_VARCHAR2_TABLE_100();
173: a2 := JTF_VARCHAR2_TABLE_300();

Line 171: a0 := JTF_NUMBER_TABLE();

167: a2 := JTF_VARCHAR2_TABLE_300();
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();

Line 174: a3 := 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
177: a0.extend(t.count);
178: a1.extend(t.count);

Line 175: a4 := JTF_NUMBER_TABLE();

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
177: a0.extend(t.count);
178: a1.extend(t.count);
179: a2.extend(t.count);

Line 312: procedure rosetta_table_copy_in_p11(t out nocopy amv_stock_pvt.amv_num_varray_type, a0 JTF_NUMBER_TABLE) as

308: end if;
309: end if;
310: end rosetta_table_copy_out_p10;
311:
312: procedure rosetta_table_copy_in_p11(t out nocopy amv_stock_pvt.amv_num_varray_type, a0 JTF_NUMBER_TABLE) as
313: ddindx binary_integer; indx binary_integer;
314: begin
315: if a0 is not null and a0.count > 0 then
316: if a0.count > 0 then

Line 330: procedure rosetta_table_copy_out_p11(t amv_stock_pvt.amv_num_varray_type, a0 out nocopy JTF_NUMBER_TABLE) as

326: end loop;
327: end if;
328: end if;
329: end rosetta_table_copy_in_p11;
330: procedure rosetta_table_copy_out_p11(t amv_stock_pvt.amv_num_varray_type, a0 out nocopy JTF_NUMBER_TABLE) as
331: ddindx binary_integer; indx binary_integer;
332: begin
333: if t is null or t.count = 0 then
334: a0 := JTF_NUMBER_TABLE();

Line 334: a0 := JTF_NUMBER_TABLE();

330: procedure rosetta_table_copy_out_p11(t amv_stock_pvt.amv_num_varray_type, a0 out nocopy JTF_NUMBER_TABLE) as
331: ddindx binary_integer; indx binary_integer;
332: begin
333: if t is null or t.count = 0 then
334: a0 := JTF_NUMBER_TABLE();
335: else
336: a0 := JTF_NUMBER_TABLE();
337: if t.count > 0 then
338: a0.extend(t.count);

Line 336: a0 := JTF_NUMBER_TABLE();

332: begin
333: if t is null or t.count = 0 then
334: a0 := JTF_NUMBER_TABLE();
335: else
336: a0 := JTF_NUMBER_TABLE();
337: if t.count > 0 then
338: a0.extend(t.count);
339: ddindx := t.first;
340: indx := 1;

Line 362: , p9_a0 out nocopy JTF_NUMBER_TABLE

358: , x_msg_data out nocopy VARCHAR2
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

Line 365: , p9_a3 out nocopy JTF_NUMBER_TABLE

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: )
368:
369: as

Line 366: , p9_a4 out nocopy JTF_NUMBER_TABLE

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: )
368:
369: as
370: ddx_stkpr_array amv_stock_pvt.amv_stk_varray_type;

Line 422: , p7_a0 out nocopy JTF_NUMBER_TABLE

418: , x_return_status out nocopy VARCHAR2
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

Line 425: , p7_a3 out nocopy JTF_NUMBER_TABLE

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: )
428:
429: as

Line 426: , p7_a4 out nocopy JTF_NUMBER_TABLE

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: )
428:
429: as
430: ddx_stkpr_array amv_stock_pvt.amv_stk_varray_type;

Line 478: , p9_a0 out nocopy JTF_NUMBER_TABLE

474: , x_msg_data out nocopy VARCHAR2
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: