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.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

Line 4: , a1 JTF_NUMBER_TABLE

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

Line 6: , a3 JTF_NUMBER_TABLE

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
10: , a7 JTF_VARCHAR2_TABLE_100

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

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

34: end loop;
35: end if;
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

Line 39: , a1 out nocopy JTF_NUMBER_TABLE

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

Line 41: , a3 out nocopy JTF_NUMBER_TABLE

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
45: , a7 out nocopy JTF_VARCHAR2_TABLE_100

Line 43: , a5 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
47: ) as

Line 51: a0 := JTF_NUMBER_TABLE();

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

Line 52: a1 := JTF_NUMBER_TABLE();

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

Line 54: a3 := JTF_NUMBER_TABLE();

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();
58: a7 := JTF_VARCHAR2_TABLE_100();

Line 56: a5 := 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();
60: else

Line 61: a0 := 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();
64: a3 := JTF_NUMBER_TABLE();
65: a4 := JTF_VARCHAR2_TABLE_100();

Line 62: a1 := JTF_NUMBER_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();
64: a3 := JTF_NUMBER_TABLE();
65: a4 := JTF_VARCHAR2_TABLE_100();
66: a5 := JTF_NUMBER_TABLE();

Line 64: a3 := JTF_NUMBER_TABLE();

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();
68: a7 := JTF_VARCHAR2_TABLE_100();

Line 66: a5 := 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();
70: if t.count > 0 then

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

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

Line 103: , a1 JTF_NUMBER_TABLE

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

Line 105: , a3 JTF_NUMBER_TABLE

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
109: , a7 JTF_VARCHAR2_TABLE_100

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

131: end loop;
132: end if;
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

Line 136: , a1 out nocopy JTF_NUMBER_TABLE

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

Line 138: , a3 out nocopy JTF_NUMBER_TABLE

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
142: , a7 out nocopy JTF_VARCHAR2_TABLE_100

Line 147: a0 := JTF_NUMBER_TABLE();

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

Line 148: a1 := JTF_NUMBER_TABLE();

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

Line 150: a3 := JTF_NUMBER_TABLE();

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();
154: a7 := JTF_VARCHAR2_TABLE_100();

Line 156: a0 := JTF_NUMBER_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();
159: a3 := JTF_NUMBER_TABLE();
160: a4 := JTF_DATE_TABLE();

Line 157: a1 := JTF_NUMBER_TABLE();

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();
159: a3 := JTF_NUMBER_TABLE();
160: a4 := JTF_DATE_TABLE();
161: a5 := JTF_VARCHAR2_TABLE_100();

Line 159: a3 := JTF_NUMBER_TABLE();

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();
163: a7 := JTF_VARCHAR2_TABLE_100();

Line 198: , p4_a0 JTF_NUMBER_TABLE

194: procedure processpayoff(p_api_version NUMBER
195: , p_init_msg_list VARCHAR2
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

Line 199: , p4_a1 JTF_NUMBER_TABLE

195: , p_init_msg_list VARCHAR2
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

Line 201: , p4_a3 JTF_NUMBER_TABLE

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
205: , p4_a7 JTF_VARCHAR2_TABLE_100

Line 258: , p4_a0 out nocopy JTF_NUMBER_TABLE

254: procedure getloaninvoices(p_api_version NUMBER
255: , p_init_msg_list VARCHAR2
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

Line 259: , p4_a1 out nocopy JTF_NUMBER_TABLE

255: , p_init_msg_list VARCHAR2
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

Line 261: , p4_a3 out nocopy JTF_NUMBER_TABLE

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
265: , p4_a7 out nocopy JTF_VARCHAR2_TABLE_100

Line 263: , p4_a5 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
267: , x_return_status out nocopy VARCHAR2