DBA Data[Home] [Help]

APPS.OKL_AM_LEASE_LOAN_TRMNT_PVT_W dependencies on JTF_VARCHAR2_TABLE_200

Line 4: , a1 JTF_VARCHAR2_TABLE_200

1: package okl_am_lease_loan_trmnt_pvt_w as
2: /* $Header: OKLELLTS.pls 120.6.12010000.5 2008/11/18 10:32:31 sosharma ship $ */
3: procedure rosetta_table_copy_in_p13(t out nocopy okl_am_lease_loan_trmnt_pvt.term_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_200
5: , a2 JTF_VARCHAR2_TABLE_200
6: , a3 JTF_DATE_TABLE
7: , a4 JTF_VARCHAR2_TABLE_200
8: , a5 JTF_DATE_TABLE

Line 5: , a2 JTF_VARCHAR2_TABLE_200

1: package okl_am_lease_loan_trmnt_pvt_w as
2: /* $Header: OKLELLTS.pls 120.6.12010000.5 2008/11/18 10:32:31 sosharma ship $ */
3: procedure rosetta_table_copy_in_p13(t out nocopy okl_am_lease_loan_trmnt_pvt.term_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_200
5: , a2 JTF_VARCHAR2_TABLE_200
6: , a3 JTF_DATE_TABLE
7: , a4 JTF_VARCHAR2_TABLE_200
8: , a5 JTF_DATE_TABLE
9: , a6 JTF_VARCHAR2_TABLE_200

Line 7: , a4 JTF_VARCHAR2_TABLE_200

3: procedure rosetta_table_copy_in_p13(t out nocopy okl_am_lease_loan_trmnt_pvt.term_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_200
5: , a2 JTF_VARCHAR2_TABLE_200
6: , a3 JTF_DATE_TABLE
7: , a4 JTF_VARCHAR2_TABLE_200
8: , a5 JTF_DATE_TABLE
9: , a6 JTF_VARCHAR2_TABLE_200
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_VARCHAR2_TABLE_2000

Line 9: , a6 JTF_VARCHAR2_TABLE_200

5: , a2 JTF_VARCHAR2_TABLE_200
6: , a3 JTF_DATE_TABLE
7: , a4 JTF_VARCHAR2_TABLE_200
8: , a5 JTF_DATE_TABLE
9: , a6 JTF_VARCHAR2_TABLE_200
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_VARCHAR2_TABLE_2000
12: , a9 JTF_VARCHAR2_TABLE_2000
13: , a10 JTF_VARCHAR2_TABLE_100

Line 11: , a8 JTF_VARCHAR2_TABLE_2000

7: , a4 JTF_VARCHAR2_TABLE_200
8: , a5 JTF_DATE_TABLE
9: , a6 JTF_VARCHAR2_TABLE_200
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_VARCHAR2_TABLE_2000
12: , a9 JTF_VARCHAR2_TABLE_2000
13: , a10 JTF_VARCHAR2_TABLE_100
14: , a11 JTF_VARCHAR2_TABLE_200
15: , a12 JTF_VARCHAR2_TABLE_100

Line 12: , a9 JTF_VARCHAR2_TABLE_2000

8: , a5 JTF_DATE_TABLE
9: , a6 JTF_VARCHAR2_TABLE_200
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_VARCHAR2_TABLE_2000
12: , a9 JTF_VARCHAR2_TABLE_2000
13: , a10 JTF_VARCHAR2_TABLE_100
14: , a11 JTF_VARCHAR2_TABLE_200
15: , a12 JTF_VARCHAR2_TABLE_100
16: );

Line 14: , a11 JTF_VARCHAR2_TABLE_200

10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_VARCHAR2_TABLE_2000
12: , a9 JTF_VARCHAR2_TABLE_2000
13: , a10 JTF_VARCHAR2_TABLE_100
14: , a11 JTF_VARCHAR2_TABLE_200
15: , a12 JTF_VARCHAR2_TABLE_100
16: );
17: procedure rosetta_table_copy_out_p13(t okl_am_lease_loan_trmnt_pvt.term_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
18: , a1 out nocopy JTF_VARCHAR2_TABLE_200

Line 18: , a1 out nocopy JTF_VARCHAR2_TABLE_200

14: , a11 JTF_VARCHAR2_TABLE_200
15: , a12 JTF_VARCHAR2_TABLE_100
16: );
17: procedure rosetta_table_copy_out_p13(t okl_am_lease_loan_trmnt_pvt.term_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
18: , a1 out nocopy JTF_VARCHAR2_TABLE_200
19: , a2 out nocopy JTF_VARCHAR2_TABLE_200
20: , a3 out nocopy JTF_DATE_TABLE
21: , a4 out nocopy JTF_VARCHAR2_TABLE_200
22: , a5 out nocopy JTF_DATE_TABLE

Line 19: , a2 out nocopy JTF_VARCHAR2_TABLE_200

15: , a12 JTF_VARCHAR2_TABLE_100
16: );
17: procedure rosetta_table_copy_out_p13(t okl_am_lease_loan_trmnt_pvt.term_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
18: , a1 out nocopy JTF_VARCHAR2_TABLE_200
19: , a2 out nocopy JTF_VARCHAR2_TABLE_200
20: , a3 out nocopy JTF_DATE_TABLE
21: , a4 out nocopy JTF_VARCHAR2_TABLE_200
22: , a5 out nocopy JTF_DATE_TABLE
23: , a6 out nocopy JTF_VARCHAR2_TABLE_200

Line 21: , a4 out nocopy JTF_VARCHAR2_TABLE_200

17: procedure rosetta_table_copy_out_p13(t okl_am_lease_loan_trmnt_pvt.term_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
18: , a1 out nocopy JTF_VARCHAR2_TABLE_200
19: , a2 out nocopy JTF_VARCHAR2_TABLE_200
20: , a3 out nocopy JTF_DATE_TABLE
21: , a4 out nocopy JTF_VARCHAR2_TABLE_200
22: , a5 out nocopy JTF_DATE_TABLE
23: , a6 out nocopy JTF_VARCHAR2_TABLE_200
24: , a7 out nocopy JTF_NUMBER_TABLE
25: , a8 out nocopy JTF_VARCHAR2_TABLE_2000

Line 23: , a6 out nocopy JTF_VARCHAR2_TABLE_200

19: , a2 out nocopy JTF_VARCHAR2_TABLE_200
20: , a3 out nocopy JTF_DATE_TABLE
21: , a4 out nocopy JTF_VARCHAR2_TABLE_200
22: , a5 out nocopy JTF_DATE_TABLE
23: , a6 out nocopy JTF_VARCHAR2_TABLE_200
24: , a7 out nocopy JTF_NUMBER_TABLE
25: , a8 out nocopy JTF_VARCHAR2_TABLE_2000
26: , a9 out nocopy JTF_VARCHAR2_TABLE_2000
27: , a10 out nocopy JTF_VARCHAR2_TABLE_100

Line 25: , a8 out nocopy JTF_VARCHAR2_TABLE_2000

21: , a4 out nocopy JTF_VARCHAR2_TABLE_200
22: , a5 out nocopy JTF_DATE_TABLE
23: , a6 out nocopy JTF_VARCHAR2_TABLE_200
24: , a7 out nocopy JTF_NUMBER_TABLE
25: , a8 out nocopy JTF_VARCHAR2_TABLE_2000
26: , a9 out nocopy JTF_VARCHAR2_TABLE_2000
27: , a10 out nocopy JTF_VARCHAR2_TABLE_100
28: , a11 out nocopy JTF_VARCHAR2_TABLE_200
29: , a12 out nocopy JTF_VARCHAR2_TABLE_100

Line 26: , a9 out nocopy JTF_VARCHAR2_TABLE_2000

22: , a5 out nocopy JTF_DATE_TABLE
23: , a6 out nocopy JTF_VARCHAR2_TABLE_200
24: , a7 out nocopy JTF_NUMBER_TABLE
25: , a8 out nocopy JTF_VARCHAR2_TABLE_2000
26: , a9 out nocopy JTF_VARCHAR2_TABLE_2000
27: , a10 out nocopy JTF_VARCHAR2_TABLE_100
28: , a11 out nocopy JTF_VARCHAR2_TABLE_200
29: , a12 out nocopy JTF_VARCHAR2_TABLE_100
30: );

Line 28: , a11 out nocopy JTF_VARCHAR2_TABLE_200

24: , a7 out nocopy JTF_NUMBER_TABLE
25: , a8 out nocopy JTF_VARCHAR2_TABLE_2000
26: , a9 out nocopy JTF_VARCHAR2_TABLE_2000
27: , a10 out nocopy JTF_VARCHAR2_TABLE_100
28: , a11 out nocopy JTF_VARCHAR2_TABLE_200
29: , a12 out nocopy JTF_VARCHAR2_TABLE_100
30: );
31:
32: procedure lease_loan_termination(p_api_version NUMBER

Line 151: , p5_a1 JTF_VARCHAR2_TABLE_200

147: , x_return_status out nocopy VARCHAR2
148: , x_msg_count out nocopy NUMBER
149: , x_msg_data out nocopy VARCHAR2
150: , p5_a0 JTF_NUMBER_TABLE
151: , p5_a1 JTF_VARCHAR2_TABLE_200
152: , p5_a2 JTF_VARCHAR2_TABLE_200
153: , p5_a3 JTF_DATE_TABLE
154: , p5_a4 JTF_VARCHAR2_TABLE_200
155: , p5_a5 JTF_DATE_TABLE

Line 152: , p5_a2 JTF_VARCHAR2_TABLE_200

148: , x_msg_count out nocopy NUMBER
149: , x_msg_data out nocopy VARCHAR2
150: , p5_a0 JTF_NUMBER_TABLE
151: , p5_a1 JTF_VARCHAR2_TABLE_200
152: , p5_a2 JTF_VARCHAR2_TABLE_200
153: , p5_a3 JTF_DATE_TABLE
154: , p5_a4 JTF_VARCHAR2_TABLE_200
155: , p5_a5 JTF_DATE_TABLE
156: , p5_a6 JTF_VARCHAR2_TABLE_200

Line 154: , p5_a4 JTF_VARCHAR2_TABLE_200

150: , p5_a0 JTF_NUMBER_TABLE
151: , p5_a1 JTF_VARCHAR2_TABLE_200
152: , p5_a2 JTF_VARCHAR2_TABLE_200
153: , p5_a3 JTF_DATE_TABLE
154: , p5_a4 JTF_VARCHAR2_TABLE_200
155: , p5_a5 JTF_DATE_TABLE
156: , p5_a6 JTF_VARCHAR2_TABLE_200
157: , p5_a7 JTF_NUMBER_TABLE
158: , p5_a8 JTF_VARCHAR2_TABLE_2000

Line 156: , p5_a6 JTF_VARCHAR2_TABLE_200

152: , p5_a2 JTF_VARCHAR2_TABLE_200
153: , p5_a3 JTF_DATE_TABLE
154: , p5_a4 JTF_VARCHAR2_TABLE_200
155: , p5_a5 JTF_DATE_TABLE
156: , p5_a6 JTF_VARCHAR2_TABLE_200
157: , p5_a7 JTF_NUMBER_TABLE
158: , p5_a8 JTF_VARCHAR2_TABLE_2000
159: , p5_a9 JTF_VARCHAR2_TABLE_2000
160: , p5_a10 JTF_VARCHAR2_TABLE_100

Line 158: , p5_a8 JTF_VARCHAR2_TABLE_2000

154: , p5_a4 JTF_VARCHAR2_TABLE_200
155: , p5_a5 JTF_DATE_TABLE
156: , p5_a6 JTF_VARCHAR2_TABLE_200
157: , p5_a7 JTF_NUMBER_TABLE
158: , p5_a8 JTF_VARCHAR2_TABLE_2000
159: , p5_a9 JTF_VARCHAR2_TABLE_2000
160: , p5_a10 JTF_VARCHAR2_TABLE_100
161: , p5_a11 JTF_VARCHAR2_TABLE_200
162: , p5_a12 JTF_VARCHAR2_TABLE_100

Line 159: , p5_a9 JTF_VARCHAR2_TABLE_2000

155: , p5_a5 JTF_DATE_TABLE
156: , p5_a6 JTF_VARCHAR2_TABLE_200
157: , p5_a7 JTF_NUMBER_TABLE
158: , p5_a8 JTF_VARCHAR2_TABLE_2000
159: , p5_a9 JTF_VARCHAR2_TABLE_2000
160: , p5_a10 JTF_VARCHAR2_TABLE_100
161: , p5_a11 JTF_VARCHAR2_TABLE_200
162: , p5_a12 JTF_VARCHAR2_TABLE_100
163: , p6_a0 JTF_NUMBER_TABLE

Line 161: , p5_a11 JTF_VARCHAR2_TABLE_200

157: , p5_a7 JTF_NUMBER_TABLE
158: , p5_a8 JTF_VARCHAR2_TABLE_2000
159: , p5_a9 JTF_VARCHAR2_TABLE_2000
160: , p5_a10 JTF_VARCHAR2_TABLE_100
161: , p5_a11 JTF_VARCHAR2_TABLE_200
162: , p5_a12 JTF_VARCHAR2_TABLE_100
163: , p6_a0 JTF_NUMBER_TABLE
164: , p6_a1 JTF_NUMBER_TABLE
165: , p6_a2 JTF_VARCHAR2_TABLE_100

Line 181: , p6_a18 JTF_VARCHAR2_TABLE_200

177: , p6_a14 JTF_DATE_TABLE
178: , p6_a15 JTF_VARCHAR2_TABLE_100
179: , p6_a16 JTF_VARCHAR2_TABLE_100
180: , p6_a17 JTF_NUMBER_TABLE
181: , p6_a18 JTF_VARCHAR2_TABLE_200
182: , p6_a19 JTF_VARCHAR2_TABLE_100
183: , p6_a20 JTF_VARCHAR2_TABLE_500
184: , p6_a21 JTF_VARCHAR2_TABLE_500
185: , p6_a22 JTF_VARCHAR2_TABLE_500

Line 220: , p6_a57 JTF_VARCHAR2_TABLE_2000

216: , p6_a53 JTF_NUMBER_TABLE
217: , p6_a54 JTF_NUMBER_TABLE
218: , p6_a55 JTF_VARCHAR2_TABLE_100
219: , p6_a56 JTF_NUMBER_TABLE
220: , p6_a57 JTF_VARCHAR2_TABLE_2000
221: , p6_a58 JTF_DATE_TABLE
222: , p6_a59 JTF_VARCHAR2_TABLE_100
223: , p6_a60 JTF_VARCHAR2_TABLE_100
224: , p6_a61 JTF_VARCHAR2_TABLE_100

Line 249: , p6_a86 JTF_VARCHAR2_TABLE_200

245: , p6_a82 JTF_DATE_TABLE
246: , p6_a83 JTF_NUMBER_TABLE
247: , p6_a84 JTF_DATE_TABLE
248: , p6_a85 JTF_VARCHAR2_TABLE_100
249: , p6_a86 JTF_VARCHAR2_TABLE_200
250: , p6_a87 JTF_VARCHAR2_TABLE_100
251: , p6_a88 JTF_VARCHAR2_TABLE_200
252: , p6_a89 JTF_VARCHAR2_TABLE_100
253: , p6_a90 JTF_VARCHAR2_TABLE_100

Line 251: , p6_a88 JTF_VARCHAR2_TABLE_200

247: , p6_a84 JTF_DATE_TABLE
248: , p6_a85 JTF_VARCHAR2_TABLE_100
249: , p6_a86 JTF_VARCHAR2_TABLE_200
250: , p6_a87 JTF_VARCHAR2_TABLE_100
251: , p6_a88 JTF_VARCHAR2_TABLE_200
252: , p6_a89 JTF_VARCHAR2_TABLE_100
253: , p6_a90 JTF_VARCHAR2_TABLE_100
254: , p6_a91 JTF_VARCHAR2_TABLE_100
255: , p6_a92 JTF_VARCHAR2_TABLE_100