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

Line 5: , a2 JTF_VARCHAR2_TABLE_100

1: package body lns_payoff_pub_w as
2: /* $Header: LNS_PAYOFFJ_B.pls 120.0 2005/05/31 18:30:33 appldev noship $ */
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

Line 7: , a4 JTF_VARCHAR2_TABLE_100

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_VARCHAR2_TABLE_100
11: , a8 JTF_VARCHAR2_TABLE_100

Line 10: , a7 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_VARCHAR2_TABLE_100
11: , a8 JTF_VARCHAR2_TABLE_100
12: ) as
13: ddindx binary_integer; indx binary_integer;
14: begin

Line 11: , a8 JTF_VARCHAR2_TABLE_100

7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_DATE_TABLE
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_VARCHAR2_TABLE_100
12: ) as
13: ddindx binary_integer; indx binary_integer;
14: begin
15: if a0 is not null and a0.count > 0 then

Line 40: , a2 out nocopy JTF_VARCHAR2_TABLE_100

36: end if;
37: end rosetta_table_copy_in_p1;
38: procedure rosetta_table_copy_out_p1(t lns_payoff_pub.invoice_details_tbl, a0 out nocopy JTF_NUMBER_TABLE
39: , a1 out nocopy JTF_NUMBER_TABLE
40: , a2 out nocopy JTF_VARCHAR2_TABLE_100
41: , a3 out nocopy JTF_NUMBER_TABLE
42: , a4 out nocopy JTF_VARCHAR2_TABLE_100
43: , a5 out nocopy JTF_NUMBER_TABLE
44: , a6 out nocopy JTF_DATE_TABLE

Line 42: , a4 out nocopy JTF_VARCHAR2_TABLE_100

38: procedure rosetta_table_copy_out_p1(t lns_payoff_pub.invoice_details_tbl, a0 out nocopy JTF_NUMBER_TABLE
39: , a1 out nocopy JTF_NUMBER_TABLE
40: , a2 out nocopy JTF_VARCHAR2_TABLE_100
41: , a3 out nocopy JTF_NUMBER_TABLE
42: , a4 out nocopy JTF_VARCHAR2_TABLE_100
43: , a5 out nocopy JTF_NUMBER_TABLE
44: , a6 out nocopy JTF_DATE_TABLE
45: , a7 out nocopy JTF_VARCHAR2_TABLE_100
46: , a8 out nocopy JTF_VARCHAR2_TABLE_100

Line 45: , a7 out nocopy JTF_VARCHAR2_TABLE_100

41: , a3 out nocopy JTF_NUMBER_TABLE
42: , a4 out nocopy JTF_VARCHAR2_TABLE_100
43: , a5 out nocopy JTF_NUMBER_TABLE
44: , a6 out nocopy JTF_DATE_TABLE
45: , a7 out nocopy JTF_VARCHAR2_TABLE_100
46: , a8 out nocopy JTF_VARCHAR2_TABLE_100
47: ) as
48: ddindx binary_integer; indx binary_integer;
49: begin

Line 46: , a8 out nocopy JTF_VARCHAR2_TABLE_100

42: , a4 out nocopy JTF_VARCHAR2_TABLE_100
43: , a5 out nocopy JTF_NUMBER_TABLE
44: , a6 out nocopy JTF_DATE_TABLE
45: , a7 out nocopy JTF_VARCHAR2_TABLE_100
46: , a8 out nocopy JTF_VARCHAR2_TABLE_100
47: ) as
48: ddindx binary_integer; indx binary_integer;
49: begin
50: if t is null or t.count = 0 then

Line 53: a2 := JTF_VARCHAR2_TABLE_100();

49: begin
50: if t is null or t.count = 0 then
51: a0 := JTF_NUMBER_TABLE();
52: a1 := JTF_NUMBER_TABLE();
53: a2 := JTF_VARCHAR2_TABLE_100();
54: a3 := JTF_NUMBER_TABLE();
55: a4 := JTF_VARCHAR2_TABLE_100();
56: a5 := JTF_NUMBER_TABLE();
57: a6 := JTF_DATE_TABLE();

Line 55: a4 := JTF_VARCHAR2_TABLE_100();

51: a0 := JTF_NUMBER_TABLE();
52: a1 := JTF_NUMBER_TABLE();
53: a2 := JTF_VARCHAR2_TABLE_100();
54: a3 := JTF_NUMBER_TABLE();
55: a4 := JTF_VARCHAR2_TABLE_100();
56: a5 := JTF_NUMBER_TABLE();
57: a6 := JTF_DATE_TABLE();
58: a7 := JTF_VARCHAR2_TABLE_100();
59: a8 := JTF_VARCHAR2_TABLE_100();

Line 58: a7 := JTF_VARCHAR2_TABLE_100();

54: a3 := JTF_NUMBER_TABLE();
55: a4 := JTF_VARCHAR2_TABLE_100();
56: a5 := JTF_NUMBER_TABLE();
57: a6 := JTF_DATE_TABLE();
58: a7 := JTF_VARCHAR2_TABLE_100();
59: a8 := JTF_VARCHAR2_TABLE_100();
60: else
61: a0 := JTF_NUMBER_TABLE();
62: a1 := JTF_NUMBER_TABLE();

Line 59: a8 := JTF_VARCHAR2_TABLE_100();

55: a4 := JTF_VARCHAR2_TABLE_100();
56: a5 := JTF_NUMBER_TABLE();
57: a6 := JTF_DATE_TABLE();
58: a7 := JTF_VARCHAR2_TABLE_100();
59: a8 := JTF_VARCHAR2_TABLE_100();
60: else
61: a0 := JTF_NUMBER_TABLE();
62: a1 := JTF_NUMBER_TABLE();
63: a2 := JTF_VARCHAR2_TABLE_100();

Line 63: a2 := JTF_VARCHAR2_TABLE_100();

59: a8 := JTF_VARCHAR2_TABLE_100();
60: else
61: a0 := JTF_NUMBER_TABLE();
62: a1 := JTF_NUMBER_TABLE();
63: a2 := JTF_VARCHAR2_TABLE_100();
64: a3 := JTF_NUMBER_TABLE();
65: a4 := JTF_VARCHAR2_TABLE_100();
66: a5 := JTF_NUMBER_TABLE();
67: a6 := JTF_DATE_TABLE();

Line 65: a4 := JTF_VARCHAR2_TABLE_100();

61: a0 := JTF_NUMBER_TABLE();
62: a1 := JTF_NUMBER_TABLE();
63: a2 := JTF_VARCHAR2_TABLE_100();
64: a3 := JTF_NUMBER_TABLE();
65: a4 := JTF_VARCHAR2_TABLE_100();
66: a5 := JTF_NUMBER_TABLE();
67: a6 := JTF_DATE_TABLE();
68: a7 := JTF_VARCHAR2_TABLE_100();
69: a8 := JTF_VARCHAR2_TABLE_100();

Line 68: a7 := JTF_VARCHAR2_TABLE_100();

64: a3 := JTF_NUMBER_TABLE();
65: a4 := JTF_VARCHAR2_TABLE_100();
66: a5 := JTF_NUMBER_TABLE();
67: a6 := JTF_DATE_TABLE();
68: a7 := JTF_VARCHAR2_TABLE_100();
69: a8 := JTF_VARCHAR2_TABLE_100();
70: if t.count > 0 then
71: a0.extend(t.count);
72: a1.extend(t.count);

Line 69: a8 := JTF_VARCHAR2_TABLE_100();

65: a4 := JTF_VARCHAR2_TABLE_100();
66: a5 := JTF_NUMBER_TABLE();
67: a6 := JTF_DATE_TABLE();
68: a7 := JTF_VARCHAR2_TABLE_100();
69: a8 := JTF_VARCHAR2_TABLE_100();
70: if t.count > 0 then
71: a0.extend(t.count);
72: a1.extend(t.count);
73: a2.extend(t.count);

Line 104: , a2 JTF_VARCHAR2_TABLE_100

100: end rosetta_table_copy_out_p1;
101:
102: procedure rosetta_table_copy_in_p3(t out nocopy lns_payoff_pub.cash_receipt_tbl, a0 JTF_NUMBER_TABLE
103: , a1 JTF_NUMBER_TABLE
104: , a2 JTF_VARCHAR2_TABLE_100
105: , a3 JTF_NUMBER_TABLE
106: , a4 JTF_DATE_TABLE
107: , a5 JTF_VARCHAR2_TABLE_100
108: , a6 JTF_VARCHAR2_TABLE_100

Line 107: , a5 JTF_VARCHAR2_TABLE_100

103: , a1 JTF_NUMBER_TABLE
104: , a2 JTF_VARCHAR2_TABLE_100
105: , a3 JTF_NUMBER_TABLE
106: , a4 JTF_DATE_TABLE
107: , a5 JTF_VARCHAR2_TABLE_100
108: , a6 JTF_VARCHAR2_TABLE_100
109: , a7 JTF_VARCHAR2_TABLE_100
110: ) as
111: ddindx binary_integer; indx binary_integer;

Line 108: , a6 JTF_VARCHAR2_TABLE_100

104: , a2 JTF_VARCHAR2_TABLE_100
105: , a3 JTF_NUMBER_TABLE
106: , a4 JTF_DATE_TABLE
107: , a5 JTF_VARCHAR2_TABLE_100
108: , a6 JTF_VARCHAR2_TABLE_100
109: , a7 JTF_VARCHAR2_TABLE_100
110: ) as
111: ddindx binary_integer; indx binary_integer;
112: begin

Line 109: , a7 JTF_VARCHAR2_TABLE_100

105: , a3 JTF_NUMBER_TABLE
106: , a4 JTF_DATE_TABLE
107: , a5 JTF_VARCHAR2_TABLE_100
108: , a6 JTF_VARCHAR2_TABLE_100
109: , a7 JTF_VARCHAR2_TABLE_100
110: ) as
111: ddindx binary_integer; indx binary_integer;
112: begin
113: if a0 is not null and a0.count > 0 then

Line 137: , a2 out nocopy JTF_VARCHAR2_TABLE_100

133: end if;
134: end rosetta_table_copy_in_p3;
135: procedure rosetta_table_copy_out_p3(t lns_payoff_pub.cash_receipt_tbl, a0 out nocopy JTF_NUMBER_TABLE
136: , a1 out nocopy JTF_NUMBER_TABLE
137: , a2 out nocopy JTF_VARCHAR2_TABLE_100
138: , a3 out nocopy JTF_NUMBER_TABLE
139: , a4 out nocopy JTF_DATE_TABLE
140: , a5 out nocopy JTF_VARCHAR2_TABLE_100
141: , a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 140: , a5 out nocopy JTF_VARCHAR2_TABLE_100

136: , a1 out nocopy JTF_NUMBER_TABLE
137: , a2 out nocopy JTF_VARCHAR2_TABLE_100
138: , a3 out nocopy JTF_NUMBER_TABLE
139: , a4 out nocopy JTF_DATE_TABLE
140: , a5 out nocopy JTF_VARCHAR2_TABLE_100
141: , a6 out nocopy JTF_VARCHAR2_TABLE_100
142: , a7 out nocopy JTF_VARCHAR2_TABLE_100
143: ) as
144: ddindx binary_integer; indx binary_integer;

Line 141: , a6 out nocopy JTF_VARCHAR2_TABLE_100

137: , a2 out nocopy JTF_VARCHAR2_TABLE_100
138: , a3 out nocopy JTF_NUMBER_TABLE
139: , a4 out nocopy JTF_DATE_TABLE
140: , a5 out nocopy JTF_VARCHAR2_TABLE_100
141: , a6 out nocopy JTF_VARCHAR2_TABLE_100
142: , a7 out nocopy JTF_VARCHAR2_TABLE_100
143: ) as
144: ddindx binary_integer; indx binary_integer;
145: begin

Line 142: , a7 out nocopy JTF_VARCHAR2_TABLE_100

138: , a3 out nocopy JTF_NUMBER_TABLE
139: , a4 out nocopy JTF_DATE_TABLE
140: , a5 out nocopy JTF_VARCHAR2_TABLE_100
141: , a6 out nocopy JTF_VARCHAR2_TABLE_100
142: , a7 out nocopy JTF_VARCHAR2_TABLE_100
143: ) as
144: ddindx binary_integer; indx binary_integer;
145: begin
146: if t is null or t.count = 0 then

Line 149: a2 := JTF_VARCHAR2_TABLE_100();

145: begin
146: if t is null or t.count = 0 then
147: a0 := JTF_NUMBER_TABLE();
148: a1 := JTF_NUMBER_TABLE();
149: a2 := JTF_VARCHAR2_TABLE_100();
150: a3 := JTF_NUMBER_TABLE();
151: a4 := JTF_DATE_TABLE();
152: a5 := JTF_VARCHAR2_TABLE_100();
153: a6 := JTF_VARCHAR2_TABLE_100();

Line 152: a5 := JTF_VARCHAR2_TABLE_100();

148: a1 := JTF_NUMBER_TABLE();
149: a2 := JTF_VARCHAR2_TABLE_100();
150: a3 := JTF_NUMBER_TABLE();
151: a4 := JTF_DATE_TABLE();
152: a5 := JTF_VARCHAR2_TABLE_100();
153: a6 := JTF_VARCHAR2_TABLE_100();
154: a7 := JTF_VARCHAR2_TABLE_100();
155: else
156: a0 := JTF_NUMBER_TABLE();

Line 153: a6 := JTF_VARCHAR2_TABLE_100();

149: a2 := JTF_VARCHAR2_TABLE_100();
150: a3 := JTF_NUMBER_TABLE();
151: a4 := JTF_DATE_TABLE();
152: a5 := JTF_VARCHAR2_TABLE_100();
153: a6 := JTF_VARCHAR2_TABLE_100();
154: a7 := JTF_VARCHAR2_TABLE_100();
155: else
156: a0 := JTF_NUMBER_TABLE();
157: a1 := JTF_NUMBER_TABLE();

Line 154: a7 := JTF_VARCHAR2_TABLE_100();

150: a3 := JTF_NUMBER_TABLE();
151: a4 := JTF_DATE_TABLE();
152: a5 := JTF_VARCHAR2_TABLE_100();
153: a6 := JTF_VARCHAR2_TABLE_100();
154: a7 := JTF_VARCHAR2_TABLE_100();
155: else
156: a0 := JTF_NUMBER_TABLE();
157: a1 := JTF_NUMBER_TABLE();
158: a2 := JTF_VARCHAR2_TABLE_100();

Line 158: a2 := JTF_VARCHAR2_TABLE_100();

154: a7 := JTF_VARCHAR2_TABLE_100();
155: else
156: a0 := JTF_NUMBER_TABLE();
157: a1 := JTF_NUMBER_TABLE();
158: a2 := JTF_VARCHAR2_TABLE_100();
159: a3 := JTF_NUMBER_TABLE();
160: a4 := JTF_DATE_TABLE();
161: a5 := JTF_VARCHAR2_TABLE_100();
162: a6 := JTF_VARCHAR2_TABLE_100();

Line 161: a5 := JTF_VARCHAR2_TABLE_100();

157: a1 := JTF_NUMBER_TABLE();
158: a2 := JTF_VARCHAR2_TABLE_100();
159: a3 := JTF_NUMBER_TABLE();
160: a4 := JTF_DATE_TABLE();
161: a5 := JTF_VARCHAR2_TABLE_100();
162: a6 := JTF_VARCHAR2_TABLE_100();
163: a7 := JTF_VARCHAR2_TABLE_100();
164: if t.count > 0 then
165: a0.extend(t.count);

Line 162: a6 := JTF_VARCHAR2_TABLE_100();

158: a2 := JTF_VARCHAR2_TABLE_100();
159: a3 := JTF_NUMBER_TABLE();
160: a4 := JTF_DATE_TABLE();
161: a5 := JTF_VARCHAR2_TABLE_100();
162: a6 := JTF_VARCHAR2_TABLE_100();
163: a7 := JTF_VARCHAR2_TABLE_100();
164: if t.count > 0 then
165: a0.extend(t.count);
166: a1.extend(t.count);

Line 163: a7 := JTF_VARCHAR2_TABLE_100();

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

Line 200: , p4_a2 JTF_VARCHAR2_TABLE_100

196: , p_loan_id NUMBER
197: , p_payoff_date DATE
198: , p4_a0 JTF_NUMBER_TABLE
199: , p4_a1 JTF_NUMBER_TABLE
200: , p4_a2 JTF_VARCHAR2_TABLE_100
201: , p4_a3 JTF_NUMBER_TABLE
202: , p4_a4 JTF_DATE_TABLE
203: , p4_a5 JTF_VARCHAR2_TABLE_100
204: , p4_a6 JTF_VARCHAR2_TABLE_100

Line 203: , p4_a5 JTF_VARCHAR2_TABLE_100

199: , p4_a1 JTF_NUMBER_TABLE
200: , p4_a2 JTF_VARCHAR2_TABLE_100
201: , p4_a3 JTF_NUMBER_TABLE
202: , p4_a4 JTF_DATE_TABLE
203: , p4_a5 JTF_VARCHAR2_TABLE_100
204: , p4_a6 JTF_VARCHAR2_TABLE_100
205: , p4_a7 JTF_VARCHAR2_TABLE_100
206: , x_return_status out nocopy VARCHAR2
207: , x_msg_count out nocopy NUMBER

Line 204: , p4_a6 JTF_VARCHAR2_TABLE_100

200: , p4_a2 JTF_VARCHAR2_TABLE_100
201: , p4_a3 JTF_NUMBER_TABLE
202: , p4_a4 JTF_DATE_TABLE
203: , p4_a5 JTF_VARCHAR2_TABLE_100
204: , p4_a6 JTF_VARCHAR2_TABLE_100
205: , p4_a7 JTF_VARCHAR2_TABLE_100
206: , x_return_status out nocopy VARCHAR2
207: , x_msg_count out nocopy NUMBER
208: , x_msg_data out nocopy VARCHAR2

Line 205: , p4_a7 JTF_VARCHAR2_TABLE_100

201: , p4_a3 JTF_NUMBER_TABLE
202: , p4_a4 JTF_DATE_TABLE
203: , p4_a5 JTF_VARCHAR2_TABLE_100
204: , p4_a6 JTF_VARCHAR2_TABLE_100
205: , p4_a7 JTF_VARCHAR2_TABLE_100
206: , x_return_status out nocopy VARCHAR2
207: , x_msg_count out nocopy NUMBER
208: , x_msg_data out nocopy VARCHAR2
209: )

Line 260: , p4_a2 out nocopy JTF_VARCHAR2_TABLE_100

256: , p_loan_id NUMBER
257: , p_payoff_date DATE
258: , p4_a0 out nocopy JTF_NUMBER_TABLE
259: , p4_a1 out nocopy JTF_NUMBER_TABLE
260: , p4_a2 out nocopy JTF_VARCHAR2_TABLE_100
261: , p4_a3 out nocopy JTF_NUMBER_TABLE
262: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_100
263: , p4_a5 out nocopy JTF_NUMBER_TABLE
264: , p4_a6 out nocopy JTF_DATE_TABLE

Line 262: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_100

258: , p4_a0 out nocopy JTF_NUMBER_TABLE
259: , p4_a1 out nocopy JTF_NUMBER_TABLE
260: , p4_a2 out nocopy JTF_VARCHAR2_TABLE_100
261: , p4_a3 out nocopy JTF_NUMBER_TABLE
262: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_100
263: , p4_a5 out nocopy JTF_NUMBER_TABLE
264: , p4_a6 out nocopy JTF_DATE_TABLE
265: , p4_a7 out nocopy JTF_VARCHAR2_TABLE_100
266: , p4_a8 out nocopy JTF_VARCHAR2_TABLE_100

Line 265: , p4_a7 out nocopy JTF_VARCHAR2_TABLE_100

261: , p4_a3 out nocopy JTF_NUMBER_TABLE
262: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_100
263: , p4_a5 out nocopy JTF_NUMBER_TABLE
264: , p4_a6 out nocopy JTF_DATE_TABLE
265: , p4_a7 out nocopy JTF_VARCHAR2_TABLE_100
266: , p4_a8 out nocopy JTF_VARCHAR2_TABLE_100
267: , x_return_status out nocopy VARCHAR2
268: , x_msg_count out nocopy NUMBER
269: , x_msg_data out nocopy VARCHAR2

Line 266: , p4_a8 out nocopy JTF_VARCHAR2_TABLE_100

262: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_100
263: , p4_a5 out nocopy JTF_NUMBER_TABLE
264: , p4_a6 out nocopy JTF_DATE_TABLE
265: , p4_a7 out nocopy JTF_VARCHAR2_TABLE_100
266: , p4_a8 out nocopy JTF_VARCHAR2_TABLE_100
267: , x_return_status out nocopy VARCHAR2
268: , x_msg_count out nocopy NUMBER
269: , x_msg_data out nocopy VARCHAR2
270: )