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_p13(t out nocopy iby_dbccard_pvt.summary_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_NUMBER_TABLE
25: ) as
26: ddindx binary_integer; indx binary_integer;
19: return d;
20: end;
21:
22: procedure rosetta_table_copy_in_p13(t out nocopy iby_dbccard_pvt.summary_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_NUMBER_TABLE
25: ) as
26: ddindx binary_integer; indx binary_integer;
27: begin
20: end;
21:
22: procedure rosetta_table_copy_in_p13(t out nocopy iby_dbccard_pvt.summary_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_NUMBER_TABLE
25: ) as
26: ddindx binary_integer; indx binary_integer;
27: begin
28: if a0 is not null and a0.count > 0 then
41: end loop;
42: end if;
43: end if;
44: end rosetta_table_copy_in_p13;
45: procedure rosetta_table_copy_out_p13(t iby_dbccard_pvt.summary_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
46: , a1 out nocopy JTF_NUMBER_TABLE
47: , a2 out nocopy JTF_NUMBER_TABLE
48: ) as
49: ddindx binary_integer; indx binary_integer;
42: end if;
43: end if;
44: end rosetta_table_copy_in_p13;
45: procedure rosetta_table_copy_out_p13(t iby_dbccard_pvt.summary_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
46: , a1 out nocopy JTF_NUMBER_TABLE
47: , a2 out nocopy JTF_NUMBER_TABLE
48: ) as
49: ddindx binary_integer; indx binary_integer;
50: begin
43: end if;
44: end rosetta_table_copy_in_p13;
45: procedure rosetta_table_copy_out_p13(t iby_dbccard_pvt.summary_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
46: , a1 out nocopy JTF_NUMBER_TABLE
47: , a2 out nocopy JTF_NUMBER_TABLE
48: ) as
49: ddindx binary_integer; indx binary_integer;
50: begin
51: if t is null or t.count = 0 then
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_NUMBER_TABLE();
55: else
56: a0 := 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_NUMBER_TABLE();
55: else
56: a0 := JTF_NUMBER_TABLE();
57: a1 := JTF_NUMBER_TABLE();
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_NUMBER_TABLE();
55: else
56: a0 := JTF_NUMBER_TABLE();
57: a1 := JTF_NUMBER_TABLE();
58: a2 := JTF_NUMBER_TABLE();
52: a0 := JTF_NUMBER_TABLE();
53: a1 := JTF_NUMBER_TABLE();
54: a2 := JTF_NUMBER_TABLE();
55: else
56: a0 := JTF_NUMBER_TABLE();
57: a1 := JTF_NUMBER_TABLE();
58: a2 := JTF_NUMBER_TABLE();
59: if t.count > 0 then
60: a0.extend(t.count);
53: a1 := JTF_NUMBER_TABLE();
54: a2 := JTF_NUMBER_TABLE();
55: else
56: a0 := JTF_NUMBER_TABLE();
57: a1 := JTF_NUMBER_TABLE();
58: a2 := JTF_NUMBER_TABLE();
59: if t.count > 0 then
60: a0.extend(t.count);
61: a1.extend(t.count);
54: a2 := JTF_NUMBER_TABLE();
55: else
56: a0 := JTF_NUMBER_TABLE();
57: a1 := JTF_NUMBER_TABLE();
58: a2 := JTF_NUMBER_TABLE();
59: if t.count > 0 then
60: a0.extend(t.count);
61: a1.extend(t.count);
62: a2.extend(t.count);
75: end if;
76: end if;
77: end rosetta_table_copy_out_p13;
78:
79: procedure rosetta_table_copy_in_p14(t out nocopy iby_dbccard_pvt.trxnsum_tbl_type, a0 JTF_NUMBER_TABLE
80: , a1 JTF_NUMBER_TABLE
81: , a2 JTF_NUMBER_TABLE
82: , a3 JTF_NUMBER_TABLE
83: , a4 JTF_NUMBER_TABLE
76: end if;
77: end rosetta_table_copy_out_p13;
78:
79: procedure rosetta_table_copy_in_p14(t out nocopy iby_dbccard_pvt.trxnsum_tbl_type, a0 JTF_NUMBER_TABLE
80: , a1 JTF_NUMBER_TABLE
81: , a2 JTF_NUMBER_TABLE
82: , a3 JTF_NUMBER_TABLE
83: , a4 JTF_NUMBER_TABLE
84: ) as
77: end rosetta_table_copy_out_p13;
78:
79: procedure rosetta_table_copy_in_p14(t out nocopy iby_dbccard_pvt.trxnsum_tbl_type, a0 JTF_NUMBER_TABLE
80: , a1 JTF_NUMBER_TABLE
81: , a2 JTF_NUMBER_TABLE
82: , a3 JTF_NUMBER_TABLE
83: , a4 JTF_NUMBER_TABLE
84: ) as
85: ddindx binary_integer; indx binary_integer;
78:
79: procedure rosetta_table_copy_in_p14(t out nocopy iby_dbccard_pvt.trxnsum_tbl_type, a0 JTF_NUMBER_TABLE
80: , a1 JTF_NUMBER_TABLE
81: , a2 JTF_NUMBER_TABLE
82: , a3 JTF_NUMBER_TABLE
83: , a4 JTF_NUMBER_TABLE
84: ) as
85: ddindx binary_integer; indx binary_integer;
86: begin
79: procedure rosetta_table_copy_in_p14(t out nocopy iby_dbccard_pvt.trxnsum_tbl_type, a0 JTF_NUMBER_TABLE
80: , a1 JTF_NUMBER_TABLE
81: , a2 JTF_NUMBER_TABLE
82: , a3 JTF_NUMBER_TABLE
83: , a4 JTF_NUMBER_TABLE
84: ) as
85: ddindx binary_integer; indx binary_integer;
86: begin
87: if a0 is not null and a0.count > 0 then
102: end loop;
103: end if;
104: end if;
105: end rosetta_table_copy_in_p14;
106: procedure rosetta_table_copy_out_p14(t iby_dbccard_pvt.trxnsum_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
107: , a1 out nocopy JTF_NUMBER_TABLE
108: , a2 out nocopy JTF_NUMBER_TABLE
109: , a3 out nocopy JTF_NUMBER_TABLE
110: , a4 out nocopy JTF_NUMBER_TABLE
103: end if;
104: end if;
105: end rosetta_table_copy_in_p14;
106: procedure rosetta_table_copy_out_p14(t iby_dbccard_pvt.trxnsum_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
107: , a1 out nocopy JTF_NUMBER_TABLE
108: , a2 out nocopy JTF_NUMBER_TABLE
109: , a3 out nocopy JTF_NUMBER_TABLE
110: , a4 out nocopy JTF_NUMBER_TABLE
111: ) as
104: end if;
105: end rosetta_table_copy_in_p14;
106: procedure rosetta_table_copy_out_p14(t iby_dbccard_pvt.trxnsum_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
107: , a1 out nocopy JTF_NUMBER_TABLE
108: , a2 out nocopy JTF_NUMBER_TABLE
109: , a3 out nocopy JTF_NUMBER_TABLE
110: , a4 out nocopy JTF_NUMBER_TABLE
111: ) as
112: ddindx binary_integer; indx binary_integer;
105: end rosetta_table_copy_in_p14;
106: procedure rosetta_table_copy_out_p14(t iby_dbccard_pvt.trxnsum_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
107: , a1 out nocopy JTF_NUMBER_TABLE
108: , a2 out nocopy JTF_NUMBER_TABLE
109: , a3 out nocopy JTF_NUMBER_TABLE
110: , a4 out nocopy JTF_NUMBER_TABLE
111: ) as
112: ddindx binary_integer; indx binary_integer;
113: begin
106: procedure rosetta_table_copy_out_p14(t iby_dbccard_pvt.trxnsum_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
107: , a1 out nocopy JTF_NUMBER_TABLE
108: , a2 out nocopy JTF_NUMBER_TABLE
109: , a3 out nocopy JTF_NUMBER_TABLE
110: , a4 out nocopy JTF_NUMBER_TABLE
111: ) as
112: ddindx binary_integer; indx binary_integer;
113: begin
114: if t is null or t.count = 0 then
111: ) as
112: ddindx binary_integer; indx binary_integer;
113: begin
114: if t is null or t.count = 0 then
115: a0 := JTF_NUMBER_TABLE();
116: a1 := JTF_NUMBER_TABLE();
117: a2 := JTF_NUMBER_TABLE();
118: a3 := JTF_NUMBER_TABLE();
119: a4 := JTF_NUMBER_TABLE();
112: ddindx binary_integer; indx binary_integer;
113: begin
114: if t is null or t.count = 0 then
115: a0 := JTF_NUMBER_TABLE();
116: a1 := JTF_NUMBER_TABLE();
117: a2 := JTF_NUMBER_TABLE();
118: a3 := JTF_NUMBER_TABLE();
119: a4 := JTF_NUMBER_TABLE();
120: else
113: begin
114: if t is null or t.count = 0 then
115: a0 := JTF_NUMBER_TABLE();
116: a1 := JTF_NUMBER_TABLE();
117: a2 := JTF_NUMBER_TABLE();
118: a3 := JTF_NUMBER_TABLE();
119: a4 := JTF_NUMBER_TABLE();
120: else
121: a0 := JTF_NUMBER_TABLE();
114: if t is null or t.count = 0 then
115: a0 := JTF_NUMBER_TABLE();
116: a1 := JTF_NUMBER_TABLE();
117: a2 := JTF_NUMBER_TABLE();
118: a3 := JTF_NUMBER_TABLE();
119: a4 := JTF_NUMBER_TABLE();
120: else
121: a0 := JTF_NUMBER_TABLE();
122: a1 := JTF_NUMBER_TABLE();
115: a0 := JTF_NUMBER_TABLE();
116: a1 := JTF_NUMBER_TABLE();
117: a2 := JTF_NUMBER_TABLE();
118: a3 := JTF_NUMBER_TABLE();
119: a4 := JTF_NUMBER_TABLE();
120: else
121: a0 := JTF_NUMBER_TABLE();
122: a1 := JTF_NUMBER_TABLE();
123: a2 := JTF_NUMBER_TABLE();
117: a2 := JTF_NUMBER_TABLE();
118: a3 := JTF_NUMBER_TABLE();
119: a4 := JTF_NUMBER_TABLE();
120: else
121: a0 := JTF_NUMBER_TABLE();
122: a1 := JTF_NUMBER_TABLE();
123: a2 := JTF_NUMBER_TABLE();
124: a3 := JTF_NUMBER_TABLE();
125: a4 := JTF_NUMBER_TABLE();
118: a3 := JTF_NUMBER_TABLE();
119: a4 := JTF_NUMBER_TABLE();
120: else
121: a0 := JTF_NUMBER_TABLE();
122: a1 := JTF_NUMBER_TABLE();
123: a2 := JTF_NUMBER_TABLE();
124: a3 := JTF_NUMBER_TABLE();
125: a4 := JTF_NUMBER_TABLE();
126: if t.count > 0 then
119: a4 := JTF_NUMBER_TABLE();
120: else
121: a0 := JTF_NUMBER_TABLE();
122: a1 := JTF_NUMBER_TABLE();
123: a2 := JTF_NUMBER_TABLE();
124: a3 := JTF_NUMBER_TABLE();
125: a4 := JTF_NUMBER_TABLE();
126: if t.count > 0 then
127: a0.extend(t.count);
120: else
121: a0 := JTF_NUMBER_TABLE();
122: a1 := JTF_NUMBER_TABLE();
123: a2 := JTF_NUMBER_TABLE();
124: a3 := JTF_NUMBER_TABLE();
125: a4 := JTF_NUMBER_TABLE();
126: if t.count > 0 then
127: a0.extend(t.count);
128: a1.extend(t.count);
121: a0 := JTF_NUMBER_TABLE();
122: a1 := JTF_NUMBER_TABLE();
123: a2 := JTF_NUMBER_TABLE();
124: a3 := JTF_NUMBER_TABLE();
125: a4 := JTF_NUMBER_TABLE();
126: if t.count > 0 then
127: a0.extend(t.count);
128: a1.extend(t.count);
129: a2.extend(t.count);
146: end if;
147: end if;
148: end rosetta_table_copy_out_p14;
149:
150: procedure rosetta_table_copy_in_p15(t out nocopy iby_dbccard_pvt.trxnfail_tbl_type, a0 JTF_NUMBER_TABLE
151: , a1 JTF_NUMBER_TABLE
152: , a2 JTF_VARCHAR2_TABLE_100
153: , a3 JTF_NUMBER_TABLE
154: , a4 JTF_NUMBER_TABLE
147: end if;
148: end rosetta_table_copy_out_p14;
149:
150: procedure rosetta_table_copy_in_p15(t out nocopy iby_dbccard_pvt.trxnfail_tbl_type, a0 JTF_NUMBER_TABLE
151: , a1 JTF_NUMBER_TABLE
152: , a2 JTF_VARCHAR2_TABLE_100
153: , a3 JTF_NUMBER_TABLE
154: , a4 JTF_NUMBER_TABLE
155: ) as
149:
150: procedure rosetta_table_copy_in_p15(t out nocopy iby_dbccard_pvt.trxnfail_tbl_type, a0 JTF_NUMBER_TABLE
151: , a1 JTF_NUMBER_TABLE
152: , a2 JTF_VARCHAR2_TABLE_100
153: , a3 JTF_NUMBER_TABLE
154: , a4 JTF_NUMBER_TABLE
155: ) as
156: ddindx binary_integer; indx binary_integer;
157: begin
150: procedure rosetta_table_copy_in_p15(t out nocopy iby_dbccard_pvt.trxnfail_tbl_type, a0 JTF_NUMBER_TABLE
151: , a1 JTF_NUMBER_TABLE
152: , a2 JTF_VARCHAR2_TABLE_100
153: , a3 JTF_NUMBER_TABLE
154: , a4 JTF_NUMBER_TABLE
155: ) as
156: ddindx binary_integer; indx binary_integer;
157: begin
158: if a0 is not null and a0.count > 0 then
173: end loop;
174: end if;
175: end if;
176: end rosetta_table_copy_in_p15;
177: procedure rosetta_table_copy_out_p15(t iby_dbccard_pvt.trxnfail_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
178: , a1 out nocopy JTF_NUMBER_TABLE
179: , a2 out nocopy JTF_VARCHAR2_TABLE_100
180: , a3 out nocopy JTF_NUMBER_TABLE
181: , a4 out nocopy JTF_NUMBER_TABLE
174: end if;
175: end if;
176: end rosetta_table_copy_in_p15;
177: procedure rosetta_table_copy_out_p15(t iby_dbccard_pvt.trxnfail_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
178: , a1 out nocopy JTF_NUMBER_TABLE
179: , a2 out nocopy JTF_VARCHAR2_TABLE_100
180: , a3 out nocopy JTF_NUMBER_TABLE
181: , a4 out nocopy JTF_NUMBER_TABLE
182: ) as
176: end rosetta_table_copy_in_p15;
177: procedure rosetta_table_copy_out_p15(t iby_dbccard_pvt.trxnfail_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
178: , a1 out nocopy JTF_NUMBER_TABLE
179: , a2 out nocopy JTF_VARCHAR2_TABLE_100
180: , a3 out nocopy JTF_NUMBER_TABLE
181: , a4 out nocopy JTF_NUMBER_TABLE
182: ) as
183: ddindx binary_integer; indx binary_integer;
184: begin
177: procedure rosetta_table_copy_out_p15(t iby_dbccard_pvt.trxnfail_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
178: , a1 out nocopy JTF_NUMBER_TABLE
179: , a2 out nocopy JTF_VARCHAR2_TABLE_100
180: , a3 out nocopy JTF_NUMBER_TABLE
181: , a4 out nocopy JTF_NUMBER_TABLE
182: ) as
183: ddindx binary_integer; indx binary_integer;
184: begin
185: if t is null or t.count = 0 then
182: ) as
183: ddindx binary_integer; indx binary_integer;
184: begin
185: if t is null or t.count = 0 then
186: a0 := JTF_NUMBER_TABLE();
187: a1 := JTF_NUMBER_TABLE();
188: a2 := JTF_VARCHAR2_TABLE_100();
189: a3 := JTF_NUMBER_TABLE();
190: a4 := JTF_NUMBER_TABLE();
183: ddindx binary_integer; indx binary_integer;
184: begin
185: if t is null or t.count = 0 then
186: a0 := JTF_NUMBER_TABLE();
187: a1 := JTF_NUMBER_TABLE();
188: a2 := JTF_VARCHAR2_TABLE_100();
189: a3 := JTF_NUMBER_TABLE();
190: a4 := JTF_NUMBER_TABLE();
191: else
185: if t is null or t.count = 0 then
186: a0 := JTF_NUMBER_TABLE();
187: a1 := JTF_NUMBER_TABLE();
188: a2 := JTF_VARCHAR2_TABLE_100();
189: a3 := JTF_NUMBER_TABLE();
190: a4 := JTF_NUMBER_TABLE();
191: else
192: a0 := JTF_NUMBER_TABLE();
193: a1 := JTF_NUMBER_TABLE();
186: a0 := JTF_NUMBER_TABLE();
187: a1 := JTF_NUMBER_TABLE();
188: a2 := JTF_VARCHAR2_TABLE_100();
189: a3 := JTF_NUMBER_TABLE();
190: a4 := JTF_NUMBER_TABLE();
191: else
192: a0 := JTF_NUMBER_TABLE();
193: a1 := JTF_NUMBER_TABLE();
194: a2 := JTF_VARCHAR2_TABLE_100();
188: a2 := JTF_VARCHAR2_TABLE_100();
189: a3 := JTF_NUMBER_TABLE();
190: a4 := JTF_NUMBER_TABLE();
191: else
192: a0 := JTF_NUMBER_TABLE();
193: a1 := JTF_NUMBER_TABLE();
194: a2 := JTF_VARCHAR2_TABLE_100();
195: a3 := JTF_NUMBER_TABLE();
196: a4 := JTF_NUMBER_TABLE();
189: a3 := JTF_NUMBER_TABLE();
190: a4 := JTF_NUMBER_TABLE();
191: else
192: a0 := JTF_NUMBER_TABLE();
193: a1 := JTF_NUMBER_TABLE();
194: a2 := JTF_VARCHAR2_TABLE_100();
195: a3 := JTF_NUMBER_TABLE();
196: a4 := JTF_NUMBER_TABLE();
197: if t.count > 0 then
191: else
192: a0 := JTF_NUMBER_TABLE();
193: a1 := JTF_NUMBER_TABLE();
194: a2 := JTF_VARCHAR2_TABLE_100();
195: a3 := JTF_NUMBER_TABLE();
196: a4 := JTF_NUMBER_TABLE();
197: if t.count > 0 then
198: a0.extend(t.count);
199: a1.extend(t.count);
192: a0 := JTF_NUMBER_TABLE();
193: a1 := JTF_NUMBER_TABLE();
194: a2 := JTF_VARCHAR2_TABLE_100();
195: a3 := JTF_NUMBER_TABLE();
196: a4 := JTF_NUMBER_TABLE();
197: if t.count > 0 then
198: a0.extend(t.count);
199: a1.extend(t.count);
200: a2.extend(t.count);
219: end rosetta_table_copy_out_p15;
220:
221: procedure get_trxn_summary(payee_id VARCHAR2
222: , period VARCHAR2
223: , p2_a0 out nocopy JTF_NUMBER_TABLE
224: , p2_a1 out nocopy JTF_NUMBER_TABLE
225: , p2_a2 out nocopy JTF_NUMBER_TABLE
226: , p3_a0 out nocopy JTF_NUMBER_TABLE
227: , p3_a1 out nocopy JTF_NUMBER_TABLE
220:
221: procedure get_trxn_summary(payee_id VARCHAR2
222: , period VARCHAR2
223: , p2_a0 out nocopy JTF_NUMBER_TABLE
224: , p2_a1 out nocopy JTF_NUMBER_TABLE
225: , p2_a2 out nocopy JTF_NUMBER_TABLE
226: , p3_a0 out nocopy JTF_NUMBER_TABLE
227: , p3_a1 out nocopy JTF_NUMBER_TABLE
228: , p3_a2 out nocopy JTF_NUMBER_TABLE
221: procedure get_trxn_summary(payee_id VARCHAR2
222: , period VARCHAR2
223: , p2_a0 out nocopy JTF_NUMBER_TABLE
224: , p2_a1 out nocopy JTF_NUMBER_TABLE
225: , p2_a2 out nocopy JTF_NUMBER_TABLE
226: , p3_a0 out nocopy JTF_NUMBER_TABLE
227: , p3_a1 out nocopy JTF_NUMBER_TABLE
228: , p3_a2 out nocopy JTF_NUMBER_TABLE
229: , p3_a3 out nocopy JTF_NUMBER_TABLE
222: , period VARCHAR2
223: , p2_a0 out nocopy JTF_NUMBER_TABLE
224: , p2_a1 out nocopy JTF_NUMBER_TABLE
225: , p2_a2 out nocopy JTF_NUMBER_TABLE
226: , p3_a0 out nocopy JTF_NUMBER_TABLE
227: , p3_a1 out nocopy JTF_NUMBER_TABLE
228: , p3_a2 out nocopy JTF_NUMBER_TABLE
229: , p3_a3 out nocopy JTF_NUMBER_TABLE
230: , p3_a4 out nocopy JTF_NUMBER_TABLE
223: , p2_a0 out nocopy JTF_NUMBER_TABLE
224: , p2_a1 out nocopy JTF_NUMBER_TABLE
225: , p2_a2 out nocopy JTF_NUMBER_TABLE
226: , p3_a0 out nocopy JTF_NUMBER_TABLE
227: , p3_a1 out nocopy JTF_NUMBER_TABLE
228: , p3_a2 out nocopy JTF_NUMBER_TABLE
229: , p3_a3 out nocopy JTF_NUMBER_TABLE
230: , p3_a4 out nocopy JTF_NUMBER_TABLE
231: )
224: , p2_a1 out nocopy JTF_NUMBER_TABLE
225: , p2_a2 out nocopy JTF_NUMBER_TABLE
226: , p3_a0 out nocopy JTF_NUMBER_TABLE
227: , p3_a1 out nocopy JTF_NUMBER_TABLE
228: , p3_a2 out nocopy JTF_NUMBER_TABLE
229: , p3_a3 out nocopy JTF_NUMBER_TABLE
230: , p3_a4 out nocopy JTF_NUMBER_TABLE
231: )
232: as
225: , p2_a2 out nocopy JTF_NUMBER_TABLE
226: , p3_a0 out nocopy JTF_NUMBER_TABLE
227: , p3_a1 out nocopy JTF_NUMBER_TABLE
228: , p3_a2 out nocopy JTF_NUMBER_TABLE
229: , p3_a3 out nocopy JTF_NUMBER_TABLE
230: , p3_a4 out nocopy JTF_NUMBER_TABLE
231: )
232: as
233: ddsummary_tbl iby_dbccard_pvt.summary_tbl_type;
226: , p3_a0 out nocopy JTF_NUMBER_TABLE
227: , p3_a1 out nocopy JTF_NUMBER_TABLE
228: , p3_a2 out nocopy JTF_NUMBER_TABLE
229: , p3_a3 out nocopy JTF_NUMBER_TABLE
230: , p3_a4 out nocopy JTF_NUMBER_TABLE
231: )
232: as
233: ddsummary_tbl iby_dbccard_pvt.summary_tbl_type;
234: ddtrxnsum_tbl iby_dbccard_pvt.trxnsum_tbl_type;
263: end;
264:
265: procedure get_failure_summary(payee_id VARCHAR2
266: , period VARCHAR2
267: , p2_a0 out nocopy JTF_NUMBER_TABLE
268: , p2_a1 out nocopy JTF_NUMBER_TABLE
269: , p2_a2 out nocopy JTF_VARCHAR2_TABLE_100
270: , p2_a3 out nocopy JTF_NUMBER_TABLE
271: , p2_a4 out nocopy JTF_NUMBER_TABLE
264:
265: procedure get_failure_summary(payee_id VARCHAR2
266: , period VARCHAR2
267: , p2_a0 out nocopy JTF_NUMBER_TABLE
268: , p2_a1 out nocopy JTF_NUMBER_TABLE
269: , p2_a2 out nocopy JTF_VARCHAR2_TABLE_100
270: , p2_a3 out nocopy JTF_NUMBER_TABLE
271: , p2_a4 out nocopy JTF_NUMBER_TABLE
272: , p3_a0 out nocopy JTF_NUMBER_TABLE
266: , period VARCHAR2
267: , p2_a0 out nocopy JTF_NUMBER_TABLE
268: , p2_a1 out nocopy JTF_NUMBER_TABLE
269: , p2_a2 out nocopy JTF_VARCHAR2_TABLE_100
270: , p2_a3 out nocopy JTF_NUMBER_TABLE
271: , p2_a4 out nocopy JTF_NUMBER_TABLE
272: , p3_a0 out nocopy JTF_NUMBER_TABLE
273: , p3_a1 out nocopy JTF_NUMBER_TABLE
274: , p3_a2 out nocopy JTF_VARCHAR2_TABLE_100
267: , p2_a0 out nocopy JTF_NUMBER_TABLE
268: , p2_a1 out nocopy JTF_NUMBER_TABLE
269: , p2_a2 out nocopy JTF_VARCHAR2_TABLE_100
270: , p2_a3 out nocopy JTF_NUMBER_TABLE
271: , p2_a4 out nocopy JTF_NUMBER_TABLE
272: , p3_a0 out nocopy JTF_NUMBER_TABLE
273: , p3_a1 out nocopy JTF_NUMBER_TABLE
274: , p3_a2 out nocopy JTF_VARCHAR2_TABLE_100
275: , p3_a3 out nocopy JTF_NUMBER_TABLE
268: , p2_a1 out nocopy JTF_NUMBER_TABLE
269: , p2_a2 out nocopy JTF_VARCHAR2_TABLE_100
270: , p2_a3 out nocopy JTF_NUMBER_TABLE
271: , p2_a4 out nocopy JTF_NUMBER_TABLE
272: , p3_a0 out nocopy JTF_NUMBER_TABLE
273: , p3_a1 out nocopy JTF_NUMBER_TABLE
274: , p3_a2 out nocopy JTF_VARCHAR2_TABLE_100
275: , p3_a3 out nocopy JTF_NUMBER_TABLE
276: , p3_a4 out nocopy JTF_NUMBER_TABLE
269: , p2_a2 out nocopy JTF_VARCHAR2_TABLE_100
270: , p2_a3 out nocopy JTF_NUMBER_TABLE
271: , p2_a4 out nocopy JTF_NUMBER_TABLE
272: , p3_a0 out nocopy JTF_NUMBER_TABLE
273: , p3_a1 out nocopy JTF_NUMBER_TABLE
274: , p3_a2 out nocopy JTF_VARCHAR2_TABLE_100
275: , p3_a3 out nocopy JTF_NUMBER_TABLE
276: , p3_a4 out nocopy JTF_NUMBER_TABLE
277: )
271: , p2_a4 out nocopy JTF_NUMBER_TABLE
272: , p3_a0 out nocopy JTF_NUMBER_TABLE
273: , p3_a1 out nocopy JTF_NUMBER_TABLE
274: , p3_a2 out nocopy JTF_VARCHAR2_TABLE_100
275: , p3_a3 out nocopy JTF_NUMBER_TABLE
276: , p3_a4 out nocopy JTF_NUMBER_TABLE
277: )
278: as
279: ddauthfail_tbl iby_dbccard_pvt.trxnfail_tbl_type;
272: , p3_a0 out nocopy JTF_NUMBER_TABLE
273: , p3_a1 out nocopy JTF_NUMBER_TABLE
274: , p3_a2 out nocopy JTF_VARCHAR2_TABLE_100
275: , p3_a3 out nocopy JTF_NUMBER_TABLE
276: , p3_a4 out nocopy JTF_NUMBER_TABLE
277: )
278: as
279: ddauthfail_tbl iby_dbccard_pvt.trxnfail_tbl_type;
280: ddsettfail_tbl iby_dbccard_pvt.trxnfail_tbl_type;
311: end;
312:
313: procedure get_cardtype_summary(payee_id VARCHAR2
314: , period VARCHAR2
315: , p2_a0 out nocopy JTF_NUMBER_TABLE
316: , p2_a1 out nocopy JTF_NUMBER_TABLE
317: , p2_a2 out nocopy JTF_VARCHAR2_TABLE_100
318: , p2_a3 out nocopy JTF_NUMBER_TABLE
319: , p2_a4 out nocopy JTF_NUMBER_TABLE
312:
313: procedure get_cardtype_summary(payee_id VARCHAR2
314: , period VARCHAR2
315: , p2_a0 out nocopy JTF_NUMBER_TABLE
316: , p2_a1 out nocopy JTF_NUMBER_TABLE
317: , p2_a2 out nocopy JTF_VARCHAR2_TABLE_100
318: , p2_a3 out nocopy JTF_NUMBER_TABLE
319: , p2_a4 out nocopy JTF_NUMBER_TABLE
320: )
314: , period VARCHAR2
315: , p2_a0 out nocopy JTF_NUMBER_TABLE
316: , p2_a1 out nocopy JTF_NUMBER_TABLE
317: , p2_a2 out nocopy JTF_VARCHAR2_TABLE_100
318: , p2_a3 out nocopy JTF_NUMBER_TABLE
319: , p2_a4 out nocopy JTF_NUMBER_TABLE
320: )
321: as
322: ddcardtype_tbl iby_dbccard_pvt.trxnfail_tbl_type;
315: , p2_a0 out nocopy JTF_NUMBER_TABLE
316: , p2_a1 out nocopy JTF_NUMBER_TABLE
317: , p2_a2 out nocopy JTF_VARCHAR2_TABLE_100
318: , p2_a3 out nocopy JTF_NUMBER_TABLE
319: , p2_a4 out nocopy JTF_NUMBER_TABLE
320: )
321: as
322: ddcardtype_tbl iby_dbccard_pvt.trxnfail_tbl_type;
323: ddindx binary_integer; indx binary_integer;
344: end;
345:
346: procedure get_processor_summary(payee_id VARCHAR2
347: , period VARCHAR2
348: , p2_a0 out nocopy JTF_NUMBER_TABLE
349: , p2_a1 out nocopy JTF_NUMBER_TABLE
350: , p2_a2 out nocopy JTF_VARCHAR2_TABLE_100
351: , p2_a3 out nocopy JTF_NUMBER_TABLE
352: , p2_a4 out nocopy JTF_NUMBER_TABLE
345:
346: procedure get_processor_summary(payee_id VARCHAR2
347: , period VARCHAR2
348: , p2_a0 out nocopy JTF_NUMBER_TABLE
349: , p2_a1 out nocopy JTF_NUMBER_TABLE
350: , p2_a2 out nocopy JTF_VARCHAR2_TABLE_100
351: , p2_a3 out nocopy JTF_NUMBER_TABLE
352: , p2_a4 out nocopy JTF_NUMBER_TABLE
353: )
347: , period VARCHAR2
348: , p2_a0 out nocopy JTF_NUMBER_TABLE
349: , p2_a1 out nocopy JTF_NUMBER_TABLE
350: , p2_a2 out nocopy JTF_VARCHAR2_TABLE_100
351: , p2_a3 out nocopy JTF_NUMBER_TABLE
352: , p2_a4 out nocopy JTF_NUMBER_TABLE
353: )
354: as
355: ddprocessor_tbl iby_dbccard_pvt.trxnfail_tbl_type;
348: , p2_a0 out nocopy JTF_NUMBER_TABLE
349: , p2_a1 out nocopy JTF_NUMBER_TABLE
350: , p2_a2 out nocopy JTF_VARCHAR2_TABLE_100
351: , p2_a3 out nocopy JTF_NUMBER_TABLE
352: , p2_a4 out nocopy JTF_NUMBER_TABLE
353: )
354: as
355: ddprocessor_tbl iby_dbccard_pvt.trxnfail_tbl_type;
356: ddindx binary_integer; indx binary_integer;