DBA Data[Home] [Help]

APPS.LNS_PAYOFF_PUB_W dependencies on JTF_NUMBER_TABLE

Line 3: procedure rosetta_table_copy_in_p1(t out nocopy lns_payoff_pub.invoice_details_tbl, a0 JTF_NUMBER_TABLE

1: package body lns_payoff_pub_w as
2: /* $Header: LNS_PAYOFFJ_B.pls 120.1.12020000.2 2012/07/19 20:58:34 scherkas ship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy lns_payoff_pub.invoice_details_tbl, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100

Line 4: , a1 JTF_NUMBER_TABLE

1: package body lns_payoff_pub_w as
2: /* $Header: LNS_PAYOFFJ_B.pls 120.1.12020000.2 2012/07/19 20:58:34 scherkas ship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy lns_payoff_pub.invoice_details_tbl, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_NUMBER_TABLE

Line 6: , a3 JTF_NUMBER_TABLE

2: /* $Header: LNS_PAYOFFJ_B.pls 120.1.12020000.2 2012/07/19 20:58:34 scherkas ship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy lns_payoff_pub.invoice_details_tbl, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_DATE_TABLE
10: , a7 JTF_DATE_TABLE

Line 8: , a5 JTF_NUMBER_TABLE

4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_DATE_TABLE
10: , a7 JTF_DATE_TABLE
11: , a8 JTF_DATE_TABLE
12: , a9 JTF_VARCHAR2_TABLE_100

Line 42: procedure rosetta_table_copy_out_p1(t lns_payoff_pub.invoice_details_tbl, a0 out nocopy JTF_NUMBER_TABLE

38: end loop;
39: end if;
40: end if;
41: end rosetta_table_copy_in_p1;
42: procedure rosetta_table_copy_out_p1(t lns_payoff_pub.invoice_details_tbl, a0 out nocopy JTF_NUMBER_TABLE
43: , a1 out nocopy JTF_NUMBER_TABLE
44: , a2 out nocopy JTF_VARCHAR2_TABLE_100
45: , a3 out nocopy JTF_NUMBER_TABLE
46: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 43: , a1 out nocopy JTF_NUMBER_TABLE

39: end if;
40: end if;
41: end rosetta_table_copy_in_p1;
42: procedure rosetta_table_copy_out_p1(t lns_payoff_pub.invoice_details_tbl, a0 out nocopy JTF_NUMBER_TABLE
43: , a1 out nocopy JTF_NUMBER_TABLE
44: , a2 out nocopy JTF_VARCHAR2_TABLE_100
45: , a3 out nocopy JTF_NUMBER_TABLE
46: , a4 out nocopy JTF_VARCHAR2_TABLE_100
47: , a5 out nocopy JTF_NUMBER_TABLE

Line 45: , a3 out nocopy JTF_NUMBER_TABLE

41: end rosetta_table_copy_in_p1;
42: procedure rosetta_table_copy_out_p1(t lns_payoff_pub.invoice_details_tbl, a0 out nocopy JTF_NUMBER_TABLE
43: , a1 out nocopy JTF_NUMBER_TABLE
44: , a2 out nocopy JTF_VARCHAR2_TABLE_100
45: , a3 out nocopy JTF_NUMBER_TABLE
46: , a4 out nocopy JTF_VARCHAR2_TABLE_100
47: , a5 out nocopy JTF_NUMBER_TABLE
48: , a6 out nocopy JTF_DATE_TABLE
49: , a7 out nocopy JTF_DATE_TABLE

Line 47: , a5 out nocopy JTF_NUMBER_TABLE

43: , a1 out nocopy JTF_NUMBER_TABLE
44: , a2 out nocopy JTF_VARCHAR2_TABLE_100
45: , a3 out nocopy JTF_NUMBER_TABLE
46: , a4 out nocopy JTF_VARCHAR2_TABLE_100
47: , a5 out nocopy JTF_NUMBER_TABLE
48: , a6 out nocopy JTF_DATE_TABLE
49: , a7 out nocopy JTF_DATE_TABLE
50: , a8 out nocopy JTF_DATE_TABLE
51: , a9 out nocopy JTF_VARCHAR2_TABLE_100

Line 57: a0 := JTF_NUMBER_TABLE();

53: ) as
54: ddindx binary_integer; indx binary_integer;
55: begin
56: if t is null or t.count = 0 then
57: a0 := JTF_NUMBER_TABLE();
58: a1 := JTF_NUMBER_TABLE();
59: a2 := JTF_VARCHAR2_TABLE_100();
60: a3 := JTF_NUMBER_TABLE();
61: a4 := JTF_VARCHAR2_TABLE_100();

Line 58: a1 := JTF_NUMBER_TABLE();

54: ddindx binary_integer; indx binary_integer;
55: begin
56: if t is null or t.count = 0 then
57: a0 := JTF_NUMBER_TABLE();
58: a1 := JTF_NUMBER_TABLE();
59: a2 := JTF_VARCHAR2_TABLE_100();
60: a3 := JTF_NUMBER_TABLE();
61: a4 := JTF_VARCHAR2_TABLE_100();
62: a5 := JTF_NUMBER_TABLE();

Line 60: a3 := JTF_NUMBER_TABLE();

56: if t is null or t.count = 0 then
57: a0 := JTF_NUMBER_TABLE();
58: a1 := JTF_NUMBER_TABLE();
59: a2 := JTF_VARCHAR2_TABLE_100();
60: a3 := JTF_NUMBER_TABLE();
61: a4 := JTF_VARCHAR2_TABLE_100();
62: a5 := JTF_NUMBER_TABLE();
63: a6 := JTF_DATE_TABLE();
64: a7 := JTF_DATE_TABLE();

Line 62: a5 := JTF_NUMBER_TABLE();

58: a1 := JTF_NUMBER_TABLE();
59: a2 := JTF_VARCHAR2_TABLE_100();
60: a3 := JTF_NUMBER_TABLE();
61: a4 := JTF_VARCHAR2_TABLE_100();
62: a5 := JTF_NUMBER_TABLE();
63: a6 := JTF_DATE_TABLE();
64: a7 := JTF_DATE_TABLE();
65: a8 := JTF_DATE_TABLE();
66: a9 := JTF_VARCHAR2_TABLE_100();

Line 69: a0 := JTF_NUMBER_TABLE();

65: a8 := JTF_DATE_TABLE();
66: a9 := JTF_VARCHAR2_TABLE_100();
67: a10 := JTF_VARCHAR2_TABLE_100();
68: else
69: a0 := JTF_NUMBER_TABLE();
70: a1 := JTF_NUMBER_TABLE();
71: a2 := JTF_VARCHAR2_TABLE_100();
72: a3 := JTF_NUMBER_TABLE();
73: a4 := JTF_VARCHAR2_TABLE_100();

Line 70: a1 := JTF_NUMBER_TABLE();

66: a9 := JTF_VARCHAR2_TABLE_100();
67: a10 := JTF_VARCHAR2_TABLE_100();
68: else
69: a0 := JTF_NUMBER_TABLE();
70: a1 := JTF_NUMBER_TABLE();
71: a2 := JTF_VARCHAR2_TABLE_100();
72: a3 := JTF_NUMBER_TABLE();
73: a4 := JTF_VARCHAR2_TABLE_100();
74: a5 := JTF_NUMBER_TABLE();

Line 72: a3 := JTF_NUMBER_TABLE();

68: else
69: a0 := JTF_NUMBER_TABLE();
70: a1 := JTF_NUMBER_TABLE();
71: a2 := JTF_VARCHAR2_TABLE_100();
72: a3 := JTF_NUMBER_TABLE();
73: a4 := JTF_VARCHAR2_TABLE_100();
74: a5 := JTF_NUMBER_TABLE();
75: a6 := JTF_DATE_TABLE();
76: a7 := JTF_DATE_TABLE();

Line 74: a5 := JTF_NUMBER_TABLE();

70: a1 := JTF_NUMBER_TABLE();
71: a2 := JTF_VARCHAR2_TABLE_100();
72: a3 := JTF_NUMBER_TABLE();
73: a4 := JTF_VARCHAR2_TABLE_100();
74: a5 := JTF_NUMBER_TABLE();
75: a6 := JTF_DATE_TABLE();
76: a7 := JTF_DATE_TABLE();
77: a8 := JTF_DATE_TABLE();
78: a9 := JTF_VARCHAR2_TABLE_100();

Line 116: procedure rosetta_table_copy_in_p3(t out nocopy lns_payoff_pub.cash_receipt_tbl, a0 JTF_NUMBER_TABLE

112: end if;
113: end if;
114: end rosetta_table_copy_out_p1;
115:
116: procedure rosetta_table_copy_in_p3(t out nocopy lns_payoff_pub.cash_receipt_tbl, a0 JTF_NUMBER_TABLE
117: , a1 JTF_NUMBER_TABLE
118: , a2 JTF_VARCHAR2_TABLE_100
119: , a3 JTF_NUMBER_TABLE
120: , a4 JTF_DATE_TABLE

Line 117: , a1 JTF_NUMBER_TABLE

113: end if;
114: end rosetta_table_copy_out_p1;
115:
116: procedure rosetta_table_copy_in_p3(t out nocopy lns_payoff_pub.cash_receipt_tbl, a0 JTF_NUMBER_TABLE
117: , a1 JTF_NUMBER_TABLE
118: , a2 JTF_VARCHAR2_TABLE_100
119: , a3 JTF_NUMBER_TABLE
120: , a4 JTF_DATE_TABLE
121: , a5 JTF_VARCHAR2_TABLE_100

Line 119: , a3 JTF_NUMBER_TABLE

115:
116: procedure rosetta_table_copy_in_p3(t out nocopy lns_payoff_pub.cash_receipt_tbl, a0 JTF_NUMBER_TABLE
117: , a1 JTF_NUMBER_TABLE
118: , a2 JTF_VARCHAR2_TABLE_100
119: , a3 JTF_NUMBER_TABLE
120: , a4 JTF_DATE_TABLE
121: , a5 JTF_VARCHAR2_TABLE_100
122: , a6 JTF_VARCHAR2_TABLE_100
123: , a7 JTF_VARCHAR2_TABLE_100

Line 149: procedure rosetta_table_copy_out_p3(t lns_payoff_pub.cash_receipt_tbl, a0 out nocopy JTF_NUMBER_TABLE

145: end loop;
146: end if;
147: end if;
148: end rosetta_table_copy_in_p3;
149: procedure rosetta_table_copy_out_p3(t lns_payoff_pub.cash_receipt_tbl, a0 out nocopy JTF_NUMBER_TABLE
150: , a1 out nocopy JTF_NUMBER_TABLE
151: , a2 out nocopy JTF_VARCHAR2_TABLE_100
152: , a3 out nocopy JTF_NUMBER_TABLE
153: , a4 out nocopy JTF_DATE_TABLE

Line 150: , a1 out nocopy JTF_NUMBER_TABLE

146: end if;
147: end if;
148: end rosetta_table_copy_in_p3;
149: procedure rosetta_table_copy_out_p3(t lns_payoff_pub.cash_receipt_tbl, a0 out nocopy JTF_NUMBER_TABLE
150: , a1 out nocopy JTF_NUMBER_TABLE
151: , a2 out nocopy JTF_VARCHAR2_TABLE_100
152: , a3 out nocopy JTF_NUMBER_TABLE
153: , a4 out nocopy JTF_DATE_TABLE
154: , a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 152: , a3 out nocopy JTF_NUMBER_TABLE

148: end rosetta_table_copy_in_p3;
149: procedure rosetta_table_copy_out_p3(t lns_payoff_pub.cash_receipt_tbl, a0 out nocopy JTF_NUMBER_TABLE
150: , a1 out nocopy JTF_NUMBER_TABLE
151: , a2 out nocopy JTF_VARCHAR2_TABLE_100
152: , a3 out nocopy JTF_NUMBER_TABLE
153: , a4 out nocopy JTF_DATE_TABLE
154: , a5 out nocopy JTF_VARCHAR2_TABLE_100
155: , a6 out nocopy JTF_VARCHAR2_TABLE_100
156: , a7 out nocopy JTF_VARCHAR2_TABLE_100

Line 161: a0 := JTF_NUMBER_TABLE();

157: ) as
158: ddindx binary_integer; indx binary_integer;
159: begin
160: if t is null or t.count = 0 then
161: a0 := JTF_NUMBER_TABLE();
162: a1 := JTF_NUMBER_TABLE();
163: a2 := JTF_VARCHAR2_TABLE_100();
164: a3 := JTF_NUMBER_TABLE();
165: a4 := JTF_DATE_TABLE();

Line 162: a1 := JTF_NUMBER_TABLE();

158: ddindx binary_integer; indx binary_integer;
159: begin
160: if t is null or t.count = 0 then
161: a0 := JTF_NUMBER_TABLE();
162: a1 := JTF_NUMBER_TABLE();
163: a2 := JTF_VARCHAR2_TABLE_100();
164: a3 := JTF_NUMBER_TABLE();
165: a4 := JTF_DATE_TABLE();
166: a5 := JTF_VARCHAR2_TABLE_100();

Line 164: a3 := JTF_NUMBER_TABLE();

160: if t is null or t.count = 0 then
161: a0 := JTF_NUMBER_TABLE();
162: a1 := JTF_NUMBER_TABLE();
163: a2 := JTF_VARCHAR2_TABLE_100();
164: a3 := JTF_NUMBER_TABLE();
165: a4 := JTF_DATE_TABLE();
166: a5 := JTF_VARCHAR2_TABLE_100();
167: a6 := JTF_VARCHAR2_TABLE_100();
168: a7 := JTF_VARCHAR2_TABLE_100();

Line 170: a0 := JTF_NUMBER_TABLE();

166: a5 := JTF_VARCHAR2_TABLE_100();
167: a6 := JTF_VARCHAR2_TABLE_100();
168: a7 := JTF_VARCHAR2_TABLE_100();
169: else
170: a0 := JTF_NUMBER_TABLE();
171: a1 := JTF_NUMBER_TABLE();
172: a2 := JTF_VARCHAR2_TABLE_100();
173: a3 := JTF_NUMBER_TABLE();
174: a4 := JTF_DATE_TABLE();

Line 171: a1 := JTF_NUMBER_TABLE();

167: a6 := JTF_VARCHAR2_TABLE_100();
168: a7 := JTF_VARCHAR2_TABLE_100();
169: else
170: a0 := JTF_NUMBER_TABLE();
171: a1 := JTF_NUMBER_TABLE();
172: a2 := JTF_VARCHAR2_TABLE_100();
173: a3 := JTF_NUMBER_TABLE();
174: a4 := JTF_DATE_TABLE();
175: a5 := JTF_VARCHAR2_TABLE_100();

Line 173: a3 := JTF_NUMBER_TABLE();

169: else
170: a0 := JTF_NUMBER_TABLE();
171: a1 := JTF_NUMBER_TABLE();
172: a2 := JTF_VARCHAR2_TABLE_100();
173: a3 := JTF_NUMBER_TABLE();
174: a4 := JTF_DATE_TABLE();
175: a5 := JTF_VARCHAR2_TABLE_100();
176: a6 := JTF_VARCHAR2_TABLE_100();
177: a7 := JTF_VARCHAR2_TABLE_100();

Line 208: procedure rosetta_table_copy_in_p5(t out nocopy lns_payoff_pub.loan_cancel_details_tbl, a0 JTF_NUMBER_TABLE

204: end if;
205: end if;
206: end rosetta_table_copy_out_p3;
207:
208: procedure rosetta_table_copy_in_p5(t out nocopy lns_payoff_pub.loan_cancel_details_tbl, a0 JTF_NUMBER_TABLE
209: , a1 JTF_NUMBER_TABLE
210: , a2 JTF_DATE_TABLE
211: , a3 JTF_DATE_TABLE
212: , a4 JTF_DATE_TABLE

Line 209: , a1 JTF_NUMBER_TABLE

205: end if;
206: end rosetta_table_copy_out_p3;
207:
208: procedure rosetta_table_copy_in_p5(t out nocopy lns_payoff_pub.loan_cancel_details_tbl, a0 JTF_NUMBER_TABLE
209: , a1 JTF_NUMBER_TABLE
210: , a2 JTF_DATE_TABLE
211: , a3 JTF_DATE_TABLE
212: , a4 JTF_DATE_TABLE
213: , a5 JTF_VARCHAR2_TABLE_100

Line 216: , a8 JTF_NUMBER_TABLE

212: , a4 JTF_DATE_TABLE
213: , a5 JTF_VARCHAR2_TABLE_100
214: , a6 JTF_VARCHAR2_TABLE_100
215: , a7 JTF_VARCHAR2_TABLE_100
216: , a8 JTF_NUMBER_TABLE
217: , a9 JTF_NUMBER_TABLE
218: , a10 JTF_VARCHAR2_TABLE_100
219: , a11 JTF_NUMBER_TABLE
220: , a12 JTF_VARCHAR2_TABLE_100

Line 217: , a9 JTF_NUMBER_TABLE

213: , a5 JTF_VARCHAR2_TABLE_100
214: , a6 JTF_VARCHAR2_TABLE_100
215: , a7 JTF_VARCHAR2_TABLE_100
216: , a8 JTF_NUMBER_TABLE
217: , a9 JTF_NUMBER_TABLE
218: , a10 JTF_VARCHAR2_TABLE_100
219: , a11 JTF_NUMBER_TABLE
220: , a12 JTF_VARCHAR2_TABLE_100
221: , a13 JTF_VARCHAR2_TABLE_100

Line 219: , a11 JTF_NUMBER_TABLE

215: , a7 JTF_VARCHAR2_TABLE_100
216: , a8 JTF_NUMBER_TABLE
217: , a9 JTF_NUMBER_TABLE
218: , a10 JTF_VARCHAR2_TABLE_100
219: , a11 JTF_NUMBER_TABLE
220: , a12 JTF_VARCHAR2_TABLE_100
221: , a13 JTF_VARCHAR2_TABLE_100
222: , a14 JTF_NUMBER_TABLE
223: , a15 JTF_NUMBER_TABLE

Line 222: , a14 JTF_NUMBER_TABLE

218: , a10 JTF_VARCHAR2_TABLE_100
219: , a11 JTF_NUMBER_TABLE
220: , a12 JTF_VARCHAR2_TABLE_100
221: , a13 JTF_VARCHAR2_TABLE_100
222: , a14 JTF_NUMBER_TABLE
223: , a15 JTF_NUMBER_TABLE
224: , a16 JTF_NUMBER_TABLE
225: ) as
226: ddindx binary_integer; indx binary_integer;

Line 223: , a15 JTF_NUMBER_TABLE

219: , a11 JTF_NUMBER_TABLE
220: , a12 JTF_VARCHAR2_TABLE_100
221: , a13 JTF_VARCHAR2_TABLE_100
222: , a14 JTF_NUMBER_TABLE
223: , a15 JTF_NUMBER_TABLE
224: , a16 JTF_NUMBER_TABLE
225: ) as
226: ddindx binary_integer; indx binary_integer;
227: begin

Line 224: , a16 JTF_NUMBER_TABLE

220: , a12 JTF_VARCHAR2_TABLE_100
221: , a13 JTF_VARCHAR2_TABLE_100
222: , a14 JTF_NUMBER_TABLE
223: , a15 JTF_NUMBER_TABLE
224: , a16 JTF_NUMBER_TABLE
225: ) as
226: ddindx binary_integer; indx binary_integer;
227: begin
228: if a0 is not null and a0.count > 0 then

Line 259: procedure rosetta_table_copy_out_p5(t lns_payoff_pub.loan_cancel_details_tbl, a0 out nocopy JTF_NUMBER_TABLE

255: end loop;
256: end if;
257: end if;
258: end rosetta_table_copy_in_p5;
259: procedure rosetta_table_copy_out_p5(t lns_payoff_pub.loan_cancel_details_tbl, a0 out nocopy JTF_NUMBER_TABLE
260: , a1 out nocopy JTF_NUMBER_TABLE
261: , a2 out nocopy JTF_DATE_TABLE
262: , a3 out nocopy JTF_DATE_TABLE
263: , a4 out nocopy JTF_DATE_TABLE

Line 260: , a1 out nocopy JTF_NUMBER_TABLE

256: end if;
257: end if;
258: end rosetta_table_copy_in_p5;
259: procedure rosetta_table_copy_out_p5(t lns_payoff_pub.loan_cancel_details_tbl, a0 out nocopy JTF_NUMBER_TABLE
260: , a1 out nocopy JTF_NUMBER_TABLE
261: , a2 out nocopy JTF_DATE_TABLE
262: , a3 out nocopy JTF_DATE_TABLE
263: , a4 out nocopy JTF_DATE_TABLE
264: , a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 267: , a8 out nocopy JTF_NUMBER_TABLE

263: , a4 out nocopy JTF_DATE_TABLE
264: , a5 out nocopy JTF_VARCHAR2_TABLE_100
265: , a6 out nocopy JTF_VARCHAR2_TABLE_100
266: , a7 out nocopy JTF_VARCHAR2_TABLE_100
267: , a8 out nocopy JTF_NUMBER_TABLE
268: , a9 out nocopy JTF_NUMBER_TABLE
269: , a10 out nocopy JTF_VARCHAR2_TABLE_100
270: , a11 out nocopy JTF_NUMBER_TABLE
271: , a12 out nocopy JTF_VARCHAR2_TABLE_100

Line 268: , a9 out nocopy JTF_NUMBER_TABLE

264: , a5 out nocopy JTF_VARCHAR2_TABLE_100
265: , a6 out nocopy JTF_VARCHAR2_TABLE_100
266: , a7 out nocopy JTF_VARCHAR2_TABLE_100
267: , a8 out nocopy JTF_NUMBER_TABLE
268: , a9 out nocopy JTF_NUMBER_TABLE
269: , a10 out nocopy JTF_VARCHAR2_TABLE_100
270: , a11 out nocopy JTF_NUMBER_TABLE
271: , a12 out nocopy JTF_VARCHAR2_TABLE_100
272: , a13 out nocopy JTF_VARCHAR2_TABLE_100

Line 270: , a11 out nocopy JTF_NUMBER_TABLE

266: , a7 out nocopy JTF_VARCHAR2_TABLE_100
267: , a8 out nocopy JTF_NUMBER_TABLE
268: , a9 out nocopy JTF_NUMBER_TABLE
269: , a10 out nocopy JTF_VARCHAR2_TABLE_100
270: , a11 out nocopy JTF_NUMBER_TABLE
271: , a12 out nocopy JTF_VARCHAR2_TABLE_100
272: , a13 out nocopy JTF_VARCHAR2_TABLE_100
273: , a14 out nocopy JTF_NUMBER_TABLE
274: , a15 out nocopy JTF_NUMBER_TABLE

Line 273: , a14 out nocopy JTF_NUMBER_TABLE

269: , a10 out nocopy JTF_VARCHAR2_TABLE_100
270: , a11 out nocopy JTF_NUMBER_TABLE
271: , a12 out nocopy JTF_VARCHAR2_TABLE_100
272: , a13 out nocopy JTF_VARCHAR2_TABLE_100
273: , a14 out nocopy JTF_NUMBER_TABLE
274: , a15 out nocopy JTF_NUMBER_TABLE
275: , a16 out nocopy JTF_NUMBER_TABLE
276: ) as
277: ddindx binary_integer; indx binary_integer;

Line 274: , a15 out nocopy JTF_NUMBER_TABLE

270: , a11 out nocopy JTF_NUMBER_TABLE
271: , a12 out nocopy JTF_VARCHAR2_TABLE_100
272: , a13 out nocopy JTF_VARCHAR2_TABLE_100
273: , a14 out nocopy JTF_NUMBER_TABLE
274: , a15 out nocopy JTF_NUMBER_TABLE
275: , a16 out nocopy JTF_NUMBER_TABLE
276: ) as
277: ddindx binary_integer; indx binary_integer;
278: begin

Line 275: , a16 out nocopy JTF_NUMBER_TABLE

271: , a12 out nocopy JTF_VARCHAR2_TABLE_100
272: , a13 out nocopy JTF_VARCHAR2_TABLE_100
273: , a14 out nocopy JTF_NUMBER_TABLE
274: , a15 out nocopy JTF_NUMBER_TABLE
275: , a16 out nocopy JTF_NUMBER_TABLE
276: ) as
277: ddindx binary_integer; indx binary_integer;
278: begin
279: if t is null or t.count = 0 then

Line 280: a0 := JTF_NUMBER_TABLE();

276: ) as
277: ddindx binary_integer; indx binary_integer;
278: begin
279: if t is null or t.count = 0 then
280: a0 := JTF_NUMBER_TABLE();
281: a1 := JTF_NUMBER_TABLE();
282: a2 := JTF_DATE_TABLE();
283: a3 := JTF_DATE_TABLE();
284: a4 := JTF_DATE_TABLE();

Line 281: a1 := JTF_NUMBER_TABLE();

277: ddindx binary_integer; indx binary_integer;
278: begin
279: if t is null or t.count = 0 then
280: a0 := JTF_NUMBER_TABLE();
281: a1 := JTF_NUMBER_TABLE();
282: a2 := JTF_DATE_TABLE();
283: a3 := JTF_DATE_TABLE();
284: a4 := JTF_DATE_TABLE();
285: a5 := JTF_VARCHAR2_TABLE_100();

Line 288: a8 := JTF_NUMBER_TABLE();

284: a4 := JTF_DATE_TABLE();
285: a5 := JTF_VARCHAR2_TABLE_100();
286: a6 := JTF_VARCHAR2_TABLE_100();
287: a7 := JTF_VARCHAR2_TABLE_100();
288: a8 := JTF_NUMBER_TABLE();
289: a9 := JTF_NUMBER_TABLE();
290: a10 := JTF_VARCHAR2_TABLE_100();
291: a11 := JTF_NUMBER_TABLE();
292: a12 := JTF_VARCHAR2_TABLE_100();

Line 289: a9 := JTF_NUMBER_TABLE();

285: a5 := JTF_VARCHAR2_TABLE_100();
286: a6 := JTF_VARCHAR2_TABLE_100();
287: a7 := JTF_VARCHAR2_TABLE_100();
288: a8 := JTF_NUMBER_TABLE();
289: a9 := JTF_NUMBER_TABLE();
290: a10 := JTF_VARCHAR2_TABLE_100();
291: a11 := JTF_NUMBER_TABLE();
292: a12 := JTF_VARCHAR2_TABLE_100();
293: a13 := JTF_VARCHAR2_TABLE_100();

Line 291: a11 := JTF_NUMBER_TABLE();

287: a7 := JTF_VARCHAR2_TABLE_100();
288: a8 := JTF_NUMBER_TABLE();
289: a9 := JTF_NUMBER_TABLE();
290: a10 := JTF_VARCHAR2_TABLE_100();
291: a11 := JTF_NUMBER_TABLE();
292: a12 := JTF_VARCHAR2_TABLE_100();
293: a13 := JTF_VARCHAR2_TABLE_100();
294: a14 := JTF_NUMBER_TABLE();
295: a15 := JTF_NUMBER_TABLE();

Line 294: a14 := JTF_NUMBER_TABLE();

290: a10 := JTF_VARCHAR2_TABLE_100();
291: a11 := JTF_NUMBER_TABLE();
292: a12 := JTF_VARCHAR2_TABLE_100();
293: a13 := JTF_VARCHAR2_TABLE_100();
294: a14 := JTF_NUMBER_TABLE();
295: a15 := JTF_NUMBER_TABLE();
296: a16 := JTF_NUMBER_TABLE();
297: else
298: a0 := JTF_NUMBER_TABLE();

Line 295: a15 := JTF_NUMBER_TABLE();

291: a11 := JTF_NUMBER_TABLE();
292: a12 := JTF_VARCHAR2_TABLE_100();
293: a13 := JTF_VARCHAR2_TABLE_100();
294: a14 := JTF_NUMBER_TABLE();
295: a15 := JTF_NUMBER_TABLE();
296: a16 := JTF_NUMBER_TABLE();
297: else
298: a0 := JTF_NUMBER_TABLE();
299: a1 := JTF_NUMBER_TABLE();

Line 296: a16 := JTF_NUMBER_TABLE();

292: a12 := JTF_VARCHAR2_TABLE_100();
293: a13 := JTF_VARCHAR2_TABLE_100();
294: a14 := JTF_NUMBER_TABLE();
295: a15 := JTF_NUMBER_TABLE();
296: a16 := JTF_NUMBER_TABLE();
297: else
298: a0 := JTF_NUMBER_TABLE();
299: a1 := JTF_NUMBER_TABLE();
300: a2 := JTF_DATE_TABLE();

Line 298: a0 := JTF_NUMBER_TABLE();

294: a14 := JTF_NUMBER_TABLE();
295: a15 := JTF_NUMBER_TABLE();
296: a16 := JTF_NUMBER_TABLE();
297: else
298: a0 := JTF_NUMBER_TABLE();
299: a1 := JTF_NUMBER_TABLE();
300: a2 := JTF_DATE_TABLE();
301: a3 := JTF_DATE_TABLE();
302: a4 := JTF_DATE_TABLE();

Line 299: a1 := JTF_NUMBER_TABLE();

295: a15 := JTF_NUMBER_TABLE();
296: a16 := JTF_NUMBER_TABLE();
297: else
298: a0 := JTF_NUMBER_TABLE();
299: a1 := JTF_NUMBER_TABLE();
300: a2 := JTF_DATE_TABLE();
301: a3 := JTF_DATE_TABLE();
302: a4 := JTF_DATE_TABLE();
303: a5 := JTF_VARCHAR2_TABLE_100();

Line 306: a8 := JTF_NUMBER_TABLE();

302: a4 := JTF_DATE_TABLE();
303: a5 := JTF_VARCHAR2_TABLE_100();
304: a6 := JTF_VARCHAR2_TABLE_100();
305: a7 := JTF_VARCHAR2_TABLE_100();
306: a8 := JTF_NUMBER_TABLE();
307: a9 := JTF_NUMBER_TABLE();
308: a10 := JTF_VARCHAR2_TABLE_100();
309: a11 := JTF_NUMBER_TABLE();
310: a12 := JTF_VARCHAR2_TABLE_100();

Line 307: a9 := JTF_NUMBER_TABLE();

303: a5 := JTF_VARCHAR2_TABLE_100();
304: a6 := JTF_VARCHAR2_TABLE_100();
305: a7 := JTF_VARCHAR2_TABLE_100();
306: a8 := JTF_NUMBER_TABLE();
307: a9 := JTF_NUMBER_TABLE();
308: a10 := JTF_VARCHAR2_TABLE_100();
309: a11 := JTF_NUMBER_TABLE();
310: a12 := JTF_VARCHAR2_TABLE_100();
311: a13 := JTF_VARCHAR2_TABLE_100();

Line 309: a11 := JTF_NUMBER_TABLE();

305: a7 := JTF_VARCHAR2_TABLE_100();
306: a8 := JTF_NUMBER_TABLE();
307: a9 := JTF_NUMBER_TABLE();
308: a10 := JTF_VARCHAR2_TABLE_100();
309: a11 := JTF_NUMBER_TABLE();
310: a12 := JTF_VARCHAR2_TABLE_100();
311: a13 := JTF_VARCHAR2_TABLE_100();
312: a14 := JTF_NUMBER_TABLE();
313: a15 := JTF_NUMBER_TABLE();

Line 312: a14 := JTF_NUMBER_TABLE();

308: a10 := JTF_VARCHAR2_TABLE_100();
309: a11 := JTF_NUMBER_TABLE();
310: a12 := JTF_VARCHAR2_TABLE_100();
311: a13 := JTF_VARCHAR2_TABLE_100();
312: a14 := JTF_NUMBER_TABLE();
313: a15 := JTF_NUMBER_TABLE();
314: a16 := JTF_NUMBER_TABLE();
315: if t.count > 0 then
316: a0.extend(t.count);

Line 313: a15 := JTF_NUMBER_TABLE();

309: a11 := JTF_NUMBER_TABLE();
310: a12 := JTF_VARCHAR2_TABLE_100();
311: a13 := JTF_VARCHAR2_TABLE_100();
312: a14 := JTF_NUMBER_TABLE();
313: a15 := JTF_NUMBER_TABLE();
314: a16 := JTF_NUMBER_TABLE();
315: if t.count > 0 then
316: a0.extend(t.count);
317: a1.extend(t.count);

Line 314: a16 := JTF_NUMBER_TABLE();

310: a12 := JTF_VARCHAR2_TABLE_100();
311: a13 := JTF_VARCHAR2_TABLE_100();
312: a14 := JTF_NUMBER_TABLE();
313: a15 := JTF_NUMBER_TABLE();
314: a16 := JTF_NUMBER_TABLE();
315: if t.count > 0 then
316: a0.extend(t.count);
317: a1.extend(t.count);
318: a2.extend(t.count);

Line 367: , p4_a0 JTF_NUMBER_TABLE

363: procedure processpayoff(p_api_version NUMBER
364: , p_init_msg_list VARCHAR2
365: , p_loan_id NUMBER
366: , p_payoff_date DATE
367: , p4_a0 JTF_NUMBER_TABLE
368: , p4_a1 JTF_NUMBER_TABLE
369: , p4_a2 JTF_VARCHAR2_TABLE_100
370: , p4_a3 JTF_NUMBER_TABLE
371: , p4_a4 JTF_DATE_TABLE

Line 368: , p4_a1 JTF_NUMBER_TABLE

364: , p_init_msg_list VARCHAR2
365: , p_loan_id NUMBER
366: , p_payoff_date DATE
367: , p4_a0 JTF_NUMBER_TABLE
368: , p4_a1 JTF_NUMBER_TABLE
369: , p4_a2 JTF_VARCHAR2_TABLE_100
370: , p4_a3 JTF_NUMBER_TABLE
371: , p4_a4 JTF_DATE_TABLE
372: , p4_a5 JTF_VARCHAR2_TABLE_100

Line 370: , p4_a3 JTF_NUMBER_TABLE

366: , p_payoff_date DATE
367: , p4_a0 JTF_NUMBER_TABLE
368: , p4_a1 JTF_NUMBER_TABLE
369: , p4_a2 JTF_VARCHAR2_TABLE_100
370: , p4_a3 JTF_NUMBER_TABLE
371: , p4_a4 JTF_DATE_TABLE
372: , p4_a5 JTF_VARCHAR2_TABLE_100
373: , p4_a6 JTF_VARCHAR2_TABLE_100
374: , p4_a7 JTF_VARCHAR2_TABLE_100

Line 427: , p4_a0 out nocopy JTF_NUMBER_TABLE

423: procedure getloaninvoices(p_api_version NUMBER
424: , p_init_msg_list VARCHAR2
425: , p_loan_id NUMBER
426: , p_payoff_date DATE
427: , p4_a0 out nocopy JTF_NUMBER_TABLE
428: , p4_a1 out nocopy JTF_NUMBER_TABLE
429: , p4_a2 out nocopy JTF_VARCHAR2_TABLE_100
430: , p4_a3 out nocopy JTF_NUMBER_TABLE
431: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 428: , p4_a1 out nocopy JTF_NUMBER_TABLE

424: , p_init_msg_list VARCHAR2
425: , p_loan_id NUMBER
426: , p_payoff_date DATE
427: , p4_a0 out nocopy JTF_NUMBER_TABLE
428: , p4_a1 out nocopy JTF_NUMBER_TABLE
429: , p4_a2 out nocopy JTF_VARCHAR2_TABLE_100
430: , p4_a3 out nocopy JTF_NUMBER_TABLE
431: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_100
432: , p4_a5 out nocopy JTF_NUMBER_TABLE

Line 430: , p4_a3 out nocopy JTF_NUMBER_TABLE

426: , p_payoff_date DATE
427: , p4_a0 out nocopy JTF_NUMBER_TABLE
428: , p4_a1 out nocopy JTF_NUMBER_TABLE
429: , p4_a2 out nocopy JTF_VARCHAR2_TABLE_100
430: , p4_a3 out nocopy JTF_NUMBER_TABLE
431: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_100
432: , p4_a5 out nocopy JTF_NUMBER_TABLE
433: , p4_a6 out nocopy JTF_DATE_TABLE
434: , p4_a7 out nocopy JTF_DATE_TABLE

Line 432: , p4_a5 out nocopy JTF_NUMBER_TABLE

428: , p4_a1 out nocopy JTF_NUMBER_TABLE
429: , p4_a2 out nocopy JTF_VARCHAR2_TABLE_100
430: , p4_a3 out nocopy JTF_NUMBER_TABLE
431: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_100
432: , p4_a5 out nocopy JTF_NUMBER_TABLE
433: , p4_a6 out nocopy JTF_DATE_TABLE
434: , p4_a7 out nocopy JTF_DATE_TABLE
435: , p4_a8 out nocopy JTF_DATE_TABLE
436: , p4_a9 out nocopy JTF_VARCHAR2_TABLE_100

Line 493: , p4_a0 out nocopy JTF_NUMBER_TABLE

489: procedure getinvoicesforloancancellation(p_api_version NUMBER
490: , p_init_msg_list VARCHAR2
491: , p_loan_id NUMBER
492: , p_cancellation_date DATE
493: , p4_a0 out nocopy JTF_NUMBER_TABLE
494: , p4_a1 out nocopy JTF_NUMBER_TABLE
495: , p4_a2 out nocopy JTF_DATE_TABLE
496: , p4_a3 out nocopy JTF_DATE_TABLE
497: , p4_a4 out nocopy JTF_DATE_TABLE

Line 494: , p4_a1 out nocopy JTF_NUMBER_TABLE

490: , p_init_msg_list VARCHAR2
491: , p_loan_id NUMBER
492: , p_cancellation_date DATE
493: , p4_a0 out nocopy JTF_NUMBER_TABLE
494: , p4_a1 out nocopy JTF_NUMBER_TABLE
495: , p4_a2 out nocopy JTF_DATE_TABLE
496: , p4_a3 out nocopy JTF_DATE_TABLE
497: , p4_a4 out nocopy JTF_DATE_TABLE
498: , p4_a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 501: , p4_a8 out nocopy JTF_NUMBER_TABLE

497: , p4_a4 out nocopy JTF_DATE_TABLE
498: , p4_a5 out nocopy JTF_VARCHAR2_TABLE_100
499: , p4_a6 out nocopy JTF_VARCHAR2_TABLE_100
500: , p4_a7 out nocopy JTF_VARCHAR2_TABLE_100
501: , p4_a8 out nocopy JTF_NUMBER_TABLE
502: , p4_a9 out nocopy JTF_NUMBER_TABLE
503: , p4_a10 out nocopy JTF_VARCHAR2_TABLE_100
504: , p4_a11 out nocopy JTF_NUMBER_TABLE
505: , p4_a12 out nocopy JTF_VARCHAR2_TABLE_100

Line 502: , p4_a9 out nocopy JTF_NUMBER_TABLE

498: , p4_a5 out nocopy JTF_VARCHAR2_TABLE_100
499: , p4_a6 out nocopy JTF_VARCHAR2_TABLE_100
500: , p4_a7 out nocopy JTF_VARCHAR2_TABLE_100
501: , p4_a8 out nocopy JTF_NUMBER_TABLE
502: , p4_a9 out nocopy JTF_NUMBER_TABLE
503: , p4_a10 out nocopy JTF_VARCHAR2_TABLE_100
504: , p4_a11 out nocopy JTF_NUMBER_TABLE
505: , p4_a12 out nocopy JTF_VARCHAR2_TABLE_100
506: , p4_a13 out nocopy JTF_VARCHAR2_TABLE_100

Line 504: , p4_a11 out nocopy JTF_NUMBER_TABLE

500: , p4_a7 out nocopy JTF_VARCHAR2_TABLE_100
501: , p4_a8 out nocopy JTF_NUMBER_TABLE
502: , p4_a9 out nocopy JTF_NUMBER_TABLE
503: , p4_a10 out nocopy JTF_VARCHAR2_TABLE_100
504: , p4_a11 out nocopy JTF_NUMBER_TABLE
505: , p4_a12 out nocopy JTF_VARCHAR2_TABLE_100
506: , p4_a13 out nocopy JTF_VARCHAR2_TABLE_100
507: , p4_a14 out nocopy JTF_NUMBER_TABLE
508: , p4_a15 out nocopy JTF_NUMBER_TABLE

Line 507: , p4_a14 out nocopy JTF_NUMBER_TABLE

503: , p4_a10 out nocopy JTF_VARCHAR2_TABLE_100
504: , p4_a11 out nocopy JTF_NUMBER_TABLE
505: , p4_a12 out nocopy JTF_VARCHAR2_TABLE_100
506: , p4_a13 out nocopy JTF_VARCHAR2_TABLE_100
507: , p4_a14 out nocopy JTF_NUMBER_TABLE
508: , p4_a15 out nocopy JTF_NUMBER_TABLE
509: , p4_a16 out nocopy JTF_NUMBER_TABLE
510: , x_return_status out nocopy VARCHAR2
511: , x_msg_count out nocopy NUMBER

Line 508: , p4_a15 out nocopy JTF_NUMBER_TABLE

504: , p4_a11 out nocopy JTF_NUMBER_TABLE
505: , p4_a12 out nocopy JTF_VARCHAR2_TABLE_100
506: , p4_a13 out nocopy JTF_VARCHAR2_TABLE_100
507: , p4_a14 out nocopy JTF_NUMBER_TABLE
508: , p4_a15 out nocopy JTF_NUMBER_TABLE
509: , p4_a16 out nocopy JTF_NUMBER_TABLE
510: , x_return_status out nocopy VARCHAR2
511: , x_msg_count out nocopy NUMBER
512: , x_msg_data out nocopy VARCHAR2

Line 509: , p4_a16 out nocopy JTF_NUMBER_TABLE

505: , p4_a12 out nocopy JTF_VARCHAR2_TABLE_100
506: , p4_a13 out nocopy JTF_VARCHAR2_TABLE_100
507: , p4_a14 out nocopy JTF_NUMBER_TABLE
508: , p4_a15 out nocopy JTF_NUMBER_TABLE
509: , p4_a16 out nocopy JTF_NUMBER_TABLE
510: , x_return_status out nocopy VARCHAR2
511: , x_msg_count out nocopy NUMBER
512: , x_msg_data out nocopy VARCHAR2
513: )

Line 577: , p10_a0 in out nocopy JTF_NUMBER_TABLE

573: , p_cancellation_date DATE
574: , p_disable_billing VARCHAR2
575: , p_action VARCHAR2
576: , p_loan_cancellation_id in out nocopy NUMBER
577: , p10_a0 in out nocopy JTF_NUMBER_TABLE
578: , p10_a1 in out nocopy JTF_NUMBER_TABLE
579: , p10_a2 in out nocopy JTF_DATE_TABLE
580: , p10_a3 in out nocopy JTF_DATE_TABLE
581: , p10_a4 in out nocopy JTF_DATE_TABLE

Line 578: , p10_a1 in out nocopy JTF_NUMBER_TABLE

574: , p_disable_billing VARCHAR2
575: , p_action VARCHAR2
576: , p_loan_cancellation_id in out nocopy NUMBER
577: , p10_a0 in out nocopy JTF_NUMBER_TABLE
578: , p10_a1 in out nocopy JTF_NUMBER_TABLE
579: , p10_a2 in out nocopy JTF_DATE_TABLE
580: , p10_a3 in out nocopy JTF_DATE_TABLE
581: , p10_a4 in out nocopy JTF_DATE_TABLE
582: , p10_a5 in out nocopy JTF_VARCHAR2_TABLE_100

Line 585: , p10_a8 in out nocopy JTF_NUMBER_TABLE

581: , p10_a4 in out nocopy JTF_DATE_TABLE
582: , p10_a5 in out nocopy JTF_VARCHAR2_TABLE_100
583: , p10_a6 in out nocopy JTF_VARCHAR2_TABLE_100
584: , p10_a7 in out nocopy JTF_VARCHAR2_TABLE_100
585: , p10_a8 in out nocopy JTF_NUMBER_TABLE
586: , p10_a9 in out nocopy JTF_NUMBER_TABLE
587: , p10_a10 in out nocopy JTF_VARCHAR2_TABLE_100
588: , p10_a11 in out nocopy JTF_NUMBER_TABLE
589: , p10_a12 in out nocopy JTF_VARCHAR2_TABLE_100

Line 586: , p10_a9 in out nocopy JTF_NUMBER_TABLE

582: , p10_a5 in out nocopy JTF_VARCHAR2_TABLE_100
583: , p10_a6 in out nocopy JTF_VARCHAR2_TABLE_100
584: , p10_a7 in out nocopy JTF_VARCHAR2_TABLE_100
585: , p10_a8 in out nocopy JTF_NUMBER_TABLE
586: , p10_a9 in out nocopy JTF_NUMBER_TABLE
587: , p10_a10 in out nocopy JTF_VARCHAR2_TABLE_100
588: , p10_a11 in out nocopy JTF_NUMBER_TABLE
589: , p10_a12 in out nocopy JTF_VARCHAR2_TABLE_100
590: , p10_a13 in out nocopy JTF_VARCHAR2_TABLE_100

Line 588: , p10_a11 in out nocopy JTF_NUMBER_TABLE

584: , p10_a7 in out nocopy JTF_VARCHAR2_TABLE_100
585: , p10_a8 in out nocopy JTF_NUMBER_TABLE
586: , p10_a9 in out nocopy JTF_NUMBER_TABLE
587: , p10_a10 in out nocopy JTF_VARCHAR2_TABLE_100
588: , p10_a11 in out nocopy JTF_NUMBER_TABLE
589: , p10_a12 in out nocopy JTF_VARCHAR2_TABLE_100
590: , p10_a13 in out nocopy JTF_VARCHAR2_TABLE_100
591: , p10_a14 in out nocopy JTF_NUMBER_TABLE
592: , p10_a15 in out nocopy JTF_NUMBER_TABLE

Line 591: , p10_a14 in out nocopy JTF_NUMBER_TABLE

587: , p10_a10 in out nocopy JTF_VARCHAR2_TABLE_100
588: , p10_a11 in out nocopy JTF_NUMBER_TABLE
589: , p10_a12 in out nocopy JTF_VARCHAR2_TABLE_100
590: , p10_a13 in out nocopy JTF_VARCHAR2_TABLE_100
591: , p10_a14 in out nocopy JTF_NUMBER_TABLE
592: , p10_a15 in out nocopy JTF_NUMBER_TABLE
593: , p10_a16 in out nocopy JTF_NUMBER_TABLE
594: , x_return_status out nocopy VARCHAR2
595: , x_msg_count out nocopy NUMBER

Line 592: , p10_a15 in out nocopy JTF_NUMBER_TABLE

588: , p10_a11 in out nocopy JTF_NUMBER_TABLE
589: , p10_a12 in out nocopy JTF_VARCHAR2_TABLE_100
590: , p10_a13 in out nocopy JTF_VARCHAR2_TABLE_100
591: , p10_a14 in out nocopy JTF_NUMBER_TABLE
592: , p10_a15 in out nocopy JTF_NUMBER_TABLE
593: , p10_a16 in out nocopy JTF_NUMBER_TABLE
594: , x_return_status out nocopy VARCHAR2
595: , x_msg_count out nocopy NUMBER
596: , x_msg_data out nocopy VARCHAR2

Line 593: , p10_a16 in out nocopy JTF_NUMBER_TABLE

589: , p10_a12 in out nocopy JTF_VARCHAR2_TABLE_100
590: , p10_a13 in out nocopy JTF_VARCHAR2_TABLE_100
591: , p10_a14 in out nocopy JTF_NUMBER_TABLE
592: , p10_a15 in out nocopy JTF_NUMBER_TABLE
593: , p10_a16 in out nocopy JTF_NUMBER_TABLE
594: , x_return_status out nocopy VARCHAR2
595: , x_msg_count out nocopy NUMBER
596: , x_msg_data out nocopy VARCHAR2
597: )