DBA Data[Home] [Help]

APPS.IBY_DBCCARD_GRAPH_PVT_W dependencies on JTF_NUMBER_TABLE

Line 22: procedure rosetta_table_copy_in_p12(t out nocopy iby_dbccard_graph_pvt.hourlyvol_tbl_type, a0 JTF_NUMBER_TABLE

18: if d = rosetta_g_mistake_date then return fnd_api.g_miss_date; end if;
19: return d;
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;

Line 23: , a1 JTF_NUMBER_TABLE

19: return d;
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

Line 45: procedure rosetta_table_copy_out_p12(t iby_dbccard_graph_pvt.hourlyvol_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

41: end loop;
42: end if;
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;

Line 46: , a1 out nocopy JTF_NUMBER_TABLE

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

Line 52: a0 := JTF_NUMBER_TABLE();

48: ) as
49: ddindx binary_integer; indx binary_integer;
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();

Line 53: a1 := JTF_NUMBER_TABLE();

49: ddindx binary_integer; indx binary_integer;
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();

Line 56: a0 := JTF_NUMBER_TABLE();

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

Line 57: a1 := 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();
59: if t.count > 0 then
60: a0.extend(t.count);
61: a1.extend(t.count);

Line 80: , a1 JTF_NUMBER_TABLE

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

Line 105: , a1 out nocopy JTF_NUMBER_TABLE

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

Line 113: a1 := JTF_NUMBER_TABLE();

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

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

Line 144: , a1 JTF_NUMBER_TABLE

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

Line 173: , a1 out nocopy JTF_NUMBER_TABLE

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

Line 186: a1 := JTF_NUMBER_TABLE();

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

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

Line 217: , p1_a0 out nocopy JTF_NUMBER_TABLE

213: end if;
214: end rosetta_table_copy_out_p14;
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

Line 218: , p1_a1 out nocopy JTF_NUMBER_TABLE

214: end rosetta_table_copy_out_p14;
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;

Line 244: , p2_a1 out nocopy JTF_NUMBER_TABLE

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: )
248: as

Line 275: , p2_a1 out nocopy JTF_NUMBER_TABLE

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: )
279: as

Line 306: , p2_a1 out nocopy JTF_NUMBER_TABLE

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: )
310: as

Line 337: , p2_a1 out nocopy JTF_NUMBER_TABLE

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: )
341: as