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.IBY_DBCCARD_GRAPH_PVT_W dependencies on JTF_VARCHAR2_TABLE_100

Line 24: , a2 JTF_VARCHAR2_TABLE_100

20: end;
21:
22: procedure rosetta_table_copy_in_p12(t out nocopy iby_dbccard_graph_pvt.hourlyvol_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_VARCHAR2_TABLE_100
25: ) as
26: ddindx binary_integer; indx binary_integer;
27: begin
28: if a0 is not null and a0.count > 0 then

Line 47: , a2 out nocopy JTF_VARCHAR2_TABLE_100

43: end if;
44: end rosetta_table_copy_in_p12;
45: procedure rosetta_table_copy_out_p12(t iby_dbccard_graph_pvt.hourlyvol_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
46: , a1 out nocopy JTF_NUMBER_TABLE
47: , a2 out nocopy JTF_VARCHAR2_TABLE_100
48: ) as
49: ddindx binary_integer; indx binary_integer;
50: begin
51: if t is null or t.count = 0 then

Line 54: a2 := JTF_VARCHAR2_TABLE_100();

50: begin
51: if t is null or t.count = 0 then
52: a0 := JTF_NUMBER_TABLE();
53: a1 := JTF_NUMBER_TABLE();
54: a2 := JTF_VARCHAR2_TABLE_100();
55: else
56: a0 := JTF_NUMBER_TABLE();
57: a1 := JTF_NUMBER_TABLE();
58: a2 := JTF_VARCHAR2_TABLE_100();

Line 58: a2 := JTF_VARCHAR2_TABLE_100();

54: a2 := JTF_VARCHAR2_TABLE_100();
55: else
56: a0 := JTF_NUMBER_TABLE();
57: a1 := JTF_NUMBER_TABLE();
58: a2 := JTF_VARCHAR2_TABLE_100();
59: if t.count > 0 then
60: a0.extend(t.count);
61: a1.extend(t.count);
62: a2.extend(t.count);

Line 79: procedure rosetta_table_copy_in_p13(t out nocopy iby_dbccard_graph_pvt.trxntrends_tbl_type, a0 JTF_VARCHAR2_TABLE_100

75: end if;
76: end if;
77: end rosetta_table_copy_out_p12;
78:
79: procedure rosetta_table_copy_in_p13(t out nocopy iby_dbccard_graph_pvt.trxntrends_tbl_type, a0 JTF_VARCHAR2_TABLE_100
80: , a1 JTF_NUMBER_TABLE
81: , a2 JTF_VARCHAR2_TABLE_100
82: , a3 JTF_DATE_TABLE
83: ) as

Line 81: , a2 JTF_VARCHAR2_TABLE_100

77: end rosetta_table_copy_out_p12;
78:
79: procedure rosetta_table_copy_in_p13(t out nocopy iby_dbccard_graph_pvt.trxntrends_tbl_type, a0 JTF_VARCHAR2_TABLE_100
80: , a1 JTF_NUMBER_TABLE
81: , a2 JTF_VARCHAR2_TABLE_100
82: , a3 JTF_DATE_TABLE
83: ) as
84: ddindx binary_integer; indx binary_integer;
85: begin

Line 104: procedure rosetta_table_copy_out_p13(t iby_dbccard_graph_pvt.trxntrends_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100

100: end loop;
101: end if;
102: end if;
103: end rosetta_table_copy_in_p13;
104: procedure rosetta_table_copy_out_p13(t iby_dbccard_graph_pvt.trxntrends_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
105: , a1 out nocopy JTF_NUMBER_TABLE
106: , a2 out nocopy JTF_VARCHAR2_TABLE_100
107: , a3 out nocopy JTF_DATE_TABLE
108: ) as

Line 106: , a2 out nocopy JTF_VARCHAR2_TABLE_100

102: end if;
103: end rosetta_table_copy_in_p13;
104: procedure rosetta_table_copy_out_p13(t iby_dbccard_graph_pvt.trxntrends_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
105: , a1 out nocopy JTF_NUMBER_TABLE
106: , a2 out nocopy JTF_VARCHAR2_TABLE_100
107: , a3 out nocopy JTF_DATE_TABLE
108: ) as
109: ddindx binary_integer; indx binary_integer;
110: begin

Line 112: a0 := JTF_VARCHAR2_TABLE_100();

108: ) as
109: ddindx binary_integer; indx binary_integer;
110: begin
111: if t is null or t.count = 0 then
112: a0 := JTF_VARCHAR2_TABLE_100();
113: a1 := JTF_NUMBER_TABLE();
114: a2 := JTF_VARCHAR2_TABLE_100();
115: a3 := JTF_DATE_TABLE();
116: else

Line 114: a2 := JTF_VARCHAR2_TABLE_100();

110: begin
111: if t is null or t.count = 0 then
112: a0 := JTF_VARCHAR2_TABLE_100();
113: a1 := JTF_NUMBER_TABLE();
114: a2 := JTF_VARCHAR2_TABLE_100();
115: a3 := JTF_DATE_TABLE();
116: else
117: a0 := JTF_VARCHAR2_TABLE_100();
118: a1 := JTF_NUMBER_TABLE();

Line 117: a0 := JTF_VARCHAR2_TABLE_100();

113: a1 := JTF_NUMBER_TABLE();
114: a2 := JTF_VARCHAR2_TABLE_100();
115: a3 := JTF_DATE_TABLE();
116: else
117: a0 := JTF_VARCHAR2_TABLE_100();
118: a1 := JTF_NUMBER_TABLE();
119: a2 := JTF_VARCHAR2_TABLE_100();
120: a3 := JTF_DATE_TABLE();
121: if t.count > 0 then

Line 119: a2 := JTF_VARCHAR2_TABLE_100();

115: a3 := JTF_DATE_TABLE();
116: else
117: a0 := JTF_VARCHAR2_TABLE_100();
118: a1 := JTF_NUMBER_TABLE();
119: a2 := JTF_VARCHAR2_TABLE_100();
120: a3 := JTF_DATE_TABLE();
121: if t.count > 0 then
122: a0.extend(t.count);
123: a1.extend(t.count);

Line 143: procedure rosetta_table_copy_in_p14(t out nocopy iby_dbccard_graph_pvt.trends_tbl_type, a0 JTF_VARCHAR2_TABLE_100

139: end if;
140: end if;
141: end rosetta_table_copy_out_p13;
142:
143: procedure rosetta_table_copy_in_p14(t out nocopy iby_dbccard_graph_pvt.trends_tbl_type, a0 JTF_VARCHAR2_TABLE_100
144: , a1 JTF_NUMBER_TABLE
145: , a2 JTF_VARCHAR2_TABLE_100
146: , a3 JTF_DATE_TABLE
147: ) as

Line 145: , a2 JTF_VARCHAR2_TABLE_100

141: end rosetta_table_copy_out_p13;
142:
143: procedure rosetta_table_copy_in_p14(t out nocopy iby_dbccard_graph_pvt.trends_tbl_type, a0 JTF_VARCHAR2_TABLE_100
144: , a1 JTF_NUMBER_TABLE
145: , a2 JTF_VARCHAR2_TABLE_100
146: , a3 JTF_DATE_TABLE
147: ) as
148: ddindx binary_integer; indx binary_integer;
149: begin

Line 172: procedure rosetta_table_copy_out_p14(t iby_dbccard_graph_pvt.trends_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100

168: end loop;
169: end if;
170: end if;
171: end rosetta_table_copy_in_p14;
172: procedure rosetta_table_copy_out_p14(t iby_dbccard_graph_pvt.trends_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
173: , a1 out nocopy JTF_NUMBER_TABLE
174: , a2 out nocopy JTF_VARCHAR2_TABLE_100
175: , a3 out nocopy JTF_DATE_TABLE
176: ) as

Line 174: , a2 out nocopy JTF_VARCHAR2_TABLE_100

170: end if;
171: end rosetta_table_copy_in_p14;
172: procedure rosetta_table_copy_out_p14(t iby_dbccard_graph_pvt.trends_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
173: , a1 out nocopy JTF_NUMBER_TABLE
174: , a2 out nocopy JTF_VARCHAR2_TABLE_100
175: , a3 out nocopy JTF_DATE_TABLE
176: ) as
177: ddindx binary_integer; indx binary_integer;
178: begin

Line 185: a0 := JTF_VARCHAR2_TABLE_100();

181: a1 := null;
182: a2 := null;
183: a3 := null;
184: elsif t.count = 0 then
185: a0 := JTF_VARCHAR2_TABLE_100();
186: a1 := JTF_NUMBER_TABLE();
187: a2 := JTF_VARCHAR2_TABLE_100();
188: a3 := JTF_DATE_TABLE();
189: else

Line 187: a2 := JTF_VARCHAR2_TABLE_100();

183: a3 := null;
184: elsif t.count = 0 then
185: a0 := JTF_VARCHAR2_TABLE_100();
186: a1 := JTF_NUMBER_TABLE();
187: a2 := JTF_VARCHAR2_TABLE_100();
188: a3 := JTF_DATE_TABLE();
189: else
190: a0 := JTF_VARCHAR2_TABLE_100();
191: a1 := JTF_NUMBER_TABLE();

Line 190: a0 := JTF_VARCHAR2_TABLE_100();

186: a1 := JTF_NUMBER_TABLE();
187: a2 := JTF_VARCHAR2_TABLE_100();
188: a3 := JTF_DATE_TABLE();
189: else
190: a0 := JTF_VARCHAR2_TABLE_100();
191: a1 := JTF_NUMBER_TABLE();
192: a2 := JTF_VARCHAR2_TABLE_100();
193: a3 := JTF_DATE_TABLE();
194: if t.count > 0 then

Line 192: a2 := JTF_VARCHAR2_TABLE_100();

188: a3 := JTF_DATE_TABLE();
189: else
190: a0 := JTF_VARCHAR2_TABLE_100();
191: a1 := JTF_NUMBER_TABLE();
192: a2 := JTF_VARCHAR2_TABLE_100();
193: a3 := JTF_DATE_TABLE();
194: if t.count > 0 then
195: a0.extend(t.count);
196: a1.extend(t.count);

Line 219: , p1_a2 out nocopy JTF_VARCHAR2_TABLE_100

215:
216: procedure get_hourly_volume(payee_id VARCHAR2
217: , p1_a0 out nocopy JTF_NUMBER_TABLE
218: , p1_a1 out nocopy JTF_NUMBER_TABLE
219: , p1_a2 out nocopy JTF_VARCHAR2_TABLE_100
220: )
221: as
222: ddhourlyvol_tbl iby_dbccard_graph_pvt.hourlyvol_tbl_type;
223: ddindx binary_integer; indx binary_integer;

Line 243: , p2_a0 out nocopy JTF_VARCHAR2_TABLE_100

239: end;
240:
241: procedure get_trxn_trends(payee_id VARCHAR2
242: , output_type VARCHAR2
243: , p2_a0 out nocopy JTF_VARCHAR2_TABLE_100
244: , p2_a1 out nocopy JTF_NUMBER_TABLE
245: , p2_a2 out nocopy JTF_VARCHAR2_TABLE_100
246: , p2_a3 out nocopy JTF_DATE_TABLE
247: )

Line 245: , p2_a2 out nocopy JTF_VARCHAR2_TABLE_100

241: procedure get_trxn_trends(payee_id VARCHAR2
242: , output_type VARCHAR2
243: , p2_a0 out nocopy JTF_VARCHAR2_TABLE_100
244: , p2_a1 out nocopy JTF_NUMBER_TABLE
245: , p2_a2 out nocopy JTF_VARCHAR2_TABLE_100
246: , p2_a3 out nocopy JTF_DATE_TABLE
247: )
248: as
249: ddtrxntrend_tbl iby_dbccard_graph_pvt.trxntrends_tbl_type;

Line 274: , p2_a0 out nocopy JTF_VARCHAR2_TABLE_100

270: end;
271:
272: procedure get_processor_trends(payee_id VARCHAR2
273: , output_type VARCHAR2
274: , p2_a0 out nocopy JTF_VARCHAR2_TABLE_100
275: , p2_a1 out nocopy JTF_NUMBER_TABLE
276: , p2_a2 out nocopy JTF_VARCHAR2_TABLE_100
277: , p2_a3 out nocopy JTF_DATE_TABLE
278: )

Line 276: , p2_a2 out nocopy JTF_VARCHAR2_TABLE_100

272: procedure get_processor_trends(payee_id VARCHAR2
273: , output_type VARCHAR2
274: , p2_a0 out nocopy JTF_VARCHAR2_TABLE_100
275: , p2_a1 out nocopy JTF_NUMBER_TABLE
276: , p2_a2 out nocopy JTF_VARCHAR2_TABLE_100
277: , p2_a3 out nocopy JTF_DATE_TABLE
278: )
279: as
280: ddtrxntrend_tbl iby_dbccard_graph_pvt.trxntrends_tbl_type;

Line 305: , p2_a0 out nocopy JTF_VARCHAR2_TABLE_100

301: end;
302:
303: procedure get_subtype_trends(payee_id VARCHAR2
304: , output_type VARCHAR2
305: , p2_a0 out nocopy JTF_VARCHAR2_TABLE_100
306: , p2_a1 out nocopy JTF_NUMBER_TABLE
307: , p2_a2 out nocopy JTF_VARCHAR2_TABLE_100
308: , p2_a3 out nocopy JTF_DATE_TABLE
309: )

Line 307: , p2_a2 out nocopy JTF_VARCHAR2_TABLE_100

303: procedure get_subtype_trends(payee_id VARCHAR2
304: , output_type VARCHAR2
305: , p2_a0 out nocopy JTF_VARCHAR2_TABLE_100
306: , p2_a1 out nocopy JTF_NUMBER_TABLE
307: , p2_a2 out nocopy JTF_VARCHAR2_TABLE_100
308: , p2_a3 out nocopy JTF_DATE_TABLE
309: )
310: as
311: ddtrxntrend_tbl iby_dbccard_graph_pvt.trxntrends_tbl_type;

Line 336: , p2_a0 out nocopy JTF_VARCHAR2_TABLE_100

332: end;
333:
334: procedure get_failure_trends(payee_id VARCHAR2
335: , output_type VARCHAR2
336: , p2_a0 out nocopy JTF_VARCHAR2_TABLE_100
337: , p2_a1 out nocopy JTF_NUMBER_TABLE
338: , p2_a2 out nocopy JTF_VARCHAR2_TABLE_100
339: , p2_a3 out nocopy JTF_DATE_TABLE
340: )

Line 338: , p2_a2 out nocopy JTF_VARCHAR2_TABLE_100

334: procedure get_failure_trends(payee_id VARCHAR2
335: , output_type VARCHAR2
336: , p2_a0 out nocopy JTF_VARCHAR2_TABLE_100
337: , p2_a1 out nocopy JTF_NUMBER_TABLE
338: , p2_a2 out nocopy JTF_VARCHAR2_TABLE_100
339: , p2_a3 out nocopy JTF_DATE_TABLE
340: )
341: as
342: ddtrxntrend_tbl iby_dbccard_graph_pvt.trxntrends_tbl_type;