DBA Data[Home] [Help]

APPS.IBY_DBCCARD_PVT_W dependencies on JTF_NUMBER_TABLE

Line 22: procedure rosetta_table_copy_in_p13(t out nocopy iby_dbccard_pvt.summary_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_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;

Line 23: , a1 JTF_NUMBER_TABLE

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

Line 24: , a2 JTF_NUMBER_TABLE

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

Line 45: procedure rosetta_table_copy_out_p13(t iby_dbccard_pvt.summary_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

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;

Line 46: , a1 out nocopy JTF_NUMBER_TABLE

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

Line 47: , a2 out nocopy JTF_NUMBER_TABLE

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

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_NUMBER_TABLE();
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_NUMBER_TABLE();
55: else
56: a0 := JTF_NUMBER_TABLE();
57: a1 := JTF_NUMBER_TABLE();

Line 54: a2 := 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();

Line 56: a0 := 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);

Line 57: a1 := 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);
61: a1.extend(t.count);

Line 58: a2 := 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);
62: a2.extend(t.count);

Line 79: procedure rosetta_table_copy_in_p14(t out nocopy iby_dbccard_pvt.trxnsum_tbl_type, a0 JTF_NUMBER_TABLE

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

Line 80: , a1 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

Line 81: , a2 JTF_NUMBER_TABLE

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;

Line 82: , a3 JTF_NUMBER_TABLE

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

Line 83: , a4 JTF_NUMBER_TABLE

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

Line 106: procedure rosetta_table_copy_out_p14(t iby_dbccard_pvt.trxnsum_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

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

Line 107: , a1 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

Line 108: , a2 out nocopy JTF_NUMBER_TABLE

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;

Line 109: , a3 out nocopy JTF_NUMBER_TABLE

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

Line 110: , a4 out nocopy JTF_NUMBER_TABLE

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

Line 115: a0 := JTF_NUMBER_TABLE();

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();

Line 116: a1 := 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

Line 117: a2 := JTF_NUMBER_TABLE();

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();

Line 118: a3 := 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();

Line 119: a4 := 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();

Line 121: a0 := 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();

Line 122: a1 := 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

Line 123: a2 := 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
127: a0.extend(t.count);

Line 124: a3 := 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);
128: a1.extend(t.count);

Line 125: a4 := JTF_NUMBER_TABLE();

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);

Line 150: procedure rosetta_table_copy_in_p15(t out nocopy iby_dbccard_pvt.trxnfail_tbl_type, a0 JTF_NUMBER_TABLE

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

Line 151: , a1 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

Line 153: , a3 JTF_NUMBER_TABLE

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

Line 154: , a4 JTF_NUMBER_TABLE

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

Line 177: procedure rosetta_table_copy_out_p15(t iby_dbccard_pvt.trxnfail_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

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

Line 178: , a1 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

Line 180: , a3 out nocopy JTF_NUMBER_TABLE

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

Line 181: , a4 out nocopy JTF_NUMBER_TABLE

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

Line 186: a0 := JTF_NUMBER_TABLE();

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();

Line 187: a1 := 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

Line 189: a3 := JTF_NUMBER_TABLE();

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();

Line 190: a4 := 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();

Line 192: a0 := 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();
195: a3 := JTF_NUMBER_TABLE();
196: a4 := JTF_NUMBER_TABLE();

Line 193: a1 := 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

Line 195: a3 := 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
198: a0.extend(t.count);
199: a1.extend(t.count);

Line 196: a4 := JTF_NUMBER_TABLE();

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);

Line 223: , p2_a0 out nocopy JTF_NUMBER_TABLE

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

Line 224: , p2_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

Line 225: , p2_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

Line 226: , p3_a0 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

Line 227: , p3_a1 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: )

Line 228: , p3_a2 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: )
232: as

Line 229: , p3_a3 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
233: ddsummary_tbl iby_dbccard_pvt.summary_tbl_type;

Line 230: , p3_a4 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;
234: ddtrxnsum_tbl iby_dbccard_pvt.trxnsum_tbl_type;

Line 267: , p2_a0 out nocopy JTF_NUMBER_TABLE

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

Line 268: , p2_a1 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

Line 270: , p2_a3 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

Line 271: , p2_a4 out nocopy JTF_NUMBER_TABLE

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

Line 272: , p3_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
276: , p3_a4 out nocopy JTF_NUMBER_TABLE

Line 273: , p3_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
277: )

Line 275: , p3_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: )
278: as
279: ddauthfail_tbl iby_dbccard_pvt.trxnfail_tbl_type;

Line 276: , p3_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;
280: ddsettfail_tbl iby_dbccard_pvt.trxnfail_tbl_type;

Line 315: , p2_a0 out nocopy JTF_NUMBER_TABLE

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

Line 316: , p2_a1 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: )

Line 318: , p2_a3 out nocopy JTF_NUMBER_TABLE

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;

Line 319: , p2_a4 out nocopy JTF_NUMBER_TABLE

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;

Line 348: , p2_a0 out nocopy JTF_NUMBER_TABLE

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

Line 349: , p2_a1 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: )

Line 351: , p2_a3 out nocopy JTF_NUMBER_TABLE

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;

Line 352: , p2_a4 out nocopy JTF_NUMBER_TABLE

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;