1: package okl_lease_quote_cashflow_pvt_w as
2: /* $Header: OKLEQUCS.pls 120.5 2006/02/10 07:41:36 asawanka noship $ */
3: procedure rosetta_table_copy_in_p21(t out nocopy okl_lease_quote_cashflow_pvt.cashflow_level_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_DATE_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
1: package okl_lease_quote_cashflow_pvt_w as
2: /* $Header: OKLEQUCS.pls 120.5 2006/02/10 07:41:36 asawanka noship $ */
3: procedure rosetta_table_copy_in_p21(t out nocopy okl_lease_quote_cashflow_pvt.cashflow_level_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_DATE_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
2: /* $Header: OKLEQUCS.pls 120.5 2006/02/10 07:41:36 asawanka noship $ */
3: procedure rosetta_table_copy_in_p21(t out nocopy okl_lease_quote_cashflow_pvt.cashflow_level_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_DATE_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
3: procedure rosetta_table_copy_in_p21(t out nocopy okl_lease_quote_cashflow_pvt.cashflow_level_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_DATE_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_VARCHAR2_TABLE_100
4: , a1 JTF_DATE_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_VARCHAR2_TABLE_100
13: );
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_VARCHAR2_TABLE_100
13: );
14: procedure rosetta_table_copy_out_p21(t okl_lease_quote_cashflow_pvt.cashflow_level_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_VARCHAR2_TABLE_100
13: );
14: procedure rosetta_table_copy_out_p21(t okl_lease_quote_cashflow_pvt.cashflow_level_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
15: , a1 out nocopy JTF_DATE_TABLE
16: , a2 out nocopy JTF_NUMBER_TABLE
17: , a3 out nocopy JTF_NUMBER_TABLE
18: , a4 out nocopy JTF_NUMBER_TABLE
12: , a9 JTF_VARCHAR2_TABLE_100
13: );
14: procedure rosetta_table_copy_out_p21(t okl_lease_quote_cashflow_pvt.cashflow_level_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
15: , a1 out nocopy JTF_DATE_TABLE
16: , a2 out nocopy JTF_NUMBER_TABLE
17: , a3 out nocopy JTF_NUMBER_TABLE
18: , a4 out nocopy JTF_NUMBER_TABLE
19: , a5 out nocopy JTF_NUMBER_TABLE
20: , a6 out nocopy JTF_NUMBER_TABLE
13: );
14: procedure rosetta_table_copy_out_p21(t okl_lease_quote_cashflow_pvt.cashflow_level_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
15: , a1 out nocopy JTF_DATE_TABLE
16: , a2 out nocopy JTF_NUMBER_TABLE
17: , a3 out nocopy JTF_NUMBER_TABLE
18: , a4 out nocopy JTF_NUMBER_TABLE
19: , a5 out nocopy JTF_NUMBER_TABLE
20: , a6 out nocopy JTF_NUMBER_TABLE
21: , a7 out nocopy JTF_NUMBER_TABLE
14: procedure rosetta_table_copy_out_p21(t okl_lease_quote_cashflow_pvt.cashflow_level_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
15: , a1 out nocopy JTF_DATE_TABLE
16: , a2 out nocopy JTF_NUMBER_TABLE
17: , a3 out nocopy JTF_NUMBER_TABLE
18: , a4 out nocopy JTF_NUMBER_TABLE
19: , a5 out nocopy JTF_NUMBER_TABLE
20: , a6 out nocopy JTF_NUMBER_TABLE
21: , a7 out nocopy JTF_NUMBER_TABLE
22: , a8 out nocopy JTF_VARCHAR2_TABLE_100
15: , a1 out nocopy JTF_DATE_TABLE
16: , a2 out nocopy JTF_NUMBER_TABLE
17: , a3 out nocopy JTF_NUMBER_TABLE
18: , a4 out nocopy JTF_NUMBER_TABLE
19: , a5 out nocopy JTF_NUMBER_TABLE
20: , a6 out nocopy JTF_NUMBER_TABLE
21: , a7 out nocopy JTF_NUMBER_TABLE
22: , a8 out nocopy JTF_VARCHAR2_TABLE_100
23: , a9 out nocopy JTF_VARCHAR2_TABLE_100
16: , a2 out nocopy JTF_NUMBER_TABLE
17: , a3 out nocopy JTF_NUMBER_TABLE
18: , a4 out nocopy JTF_NUMBER_TABLE
19: , a5 out nocopy JTF_NUMBER_TABLE
20: , a6 out nocopy JTF_NUMBER_TABLE
21: , a7 out nocopy JTF_NUMBER_TABLE
22: , a8 out nocopy JTF_VARCHAR2_TABLE_100
23: , a9 out nocopy JTF_VARCHAR2_TABLE_100
24: );
17: , a3 out nocopy JTF_NUMBER_TABLE
18: , a4 out nocopy JTF_NUMBER_TABLE
19: , a5 out nocopy JTF_NUMBER_TABLE
20: , a6 out nocopy JTF_NUMBER_TABLE
21: , a7 out nocopy JTF_NUMBER_TABLE
22: , a8 out nocopy JTF_VARCHAR2_TABLE_100
23: , a9 out nocopy JTF_VARCHAR2_TABLE_100
24: );
25:
39: , p3_a10 in out nocopy NUMBER
40: , p3_a11 in out nocopy NUMBER
41: , p3_a12 in out nocopy NUMBER
42: , p3_a13 in out nocopy NUMBER
43: , p4_a0 in out nocopy JTF_NUMBER_TABLE
44: , p4_a1 in out nocopy JTF_DATE_TABLE
45: , p4_a2 in out nocopy JTF_NUMBER_TABLE
46: , p4_a3 in out nocopy JTF_NUMBER_TABLE
47: , p4_a4 in out nocopy JTF_NUMBER_TABLE
41: , p3_a12 in out nocopy NUMBER
42: , p3_a13 in out nocopy NUMBER
43: , p4_a0 in out nocopy JTF_NUMBER_TABLE
44: , p4_a1 in out nocopy JTF_DATE_TABLE
45: , p4_a2 in out nocopy JTF_NUMBER_TABLE
46: , p4_a3 in out nocopy JTF_NUMBER_TABLE
47: , p4_a4 in out nocopy JTF_NUMBER_TABLE
48: , p4_a5 in out nocopy JTF_NUMBER_TABLE
49: , p4_a6 in out nocopy JTF_NUMBER_TABLE
42: , p3_a13 in out nocopy NUMBER
43: , p4_a0 in out nocopy JTF_NUMBER_TABLE
44: , p4_a1 in out nocopy JTF_DATE_TABLE
45: , p4_a2 in out nocopy JTF_NUMBER_TABLE
46: , p4_a3 in out nocopy JTF_NUMBER_TABLE
47: , p4_a4 in out nocopy JTF_NUMBER_TABLE
48: , p4_a5 in out nocopy JTF_NUMBER_TABLE
49: , p4_a6 in out nocopy JTF_NUMBER_TABLE
50: , p4_a7 in out nocopy JTF_NUMBER_TABLE
43: , p4_a0 in out nocopy JTF_NUMBER_TABLE
44: , p4_a1 in out nocopy JTF_DATE_TABLE
45: , p4_a2 in out nocopy JTF_NUMBER_TABLE
46: , p4_a3 in out nocopy JTF_NUMBER_TABLE
47: , p4_a4 in out nocopy JTF_NUMBER_TABLE
48: , p4_a5 in out nocopy JTF_NUMBER_TABLE
49: , p4_a6 in out nocopy JTF_NUMBER_TABLE
50: , p4_a7 in out nocopy JTF_NUMBER_TABLE
51: , p4_a8 in out nocopy JTF_VARCHAR2_TABLE_100
44: , p4_a1 in out nocopy JTF_DATE_TABLE
45: , p4_a2 in out nocopy JTF_NUMBER_TABLE
46: , p4_a3 in out nocopy JTF_NUMBER_TABLE
47: , p4_a4 in out nocopy JTF_NUMBER_TABLE
48: , p4_a5 in out nocopy JTF_NUMBER_TABLE
49: , p4_a6 in out nocopy JTF_NUMBER_TABLE
50: , p4_a7 in out nocopy JTF_NUMBER_TABLE
51: , p4_a8 in out nocopy JTF_VARCHAR2_TABLE_100
52: , p4_a9 in out nocopy JTF_VARCHAR2_TABLE_100
45: , p4_a2 in out nocopy JTF_NUMBER_TABLE
46: , p4_a3 in out nocopy JTF_NUMBER_TABLE
47: , p4_a4 in out nocopy JTF_NUMBER_TABLE
48: , p4_a5 in out nocopy JTF_NUMBER_TABLE
49: , p4_a6 in out nocopy JTF_NUMBER_TABLE
50: , p4_a7 in out nocopy JTF_NUMBER_TABLE
51: , p4_a8 in out nocopy JTF_VARCHAR2_TABLE_100
52: , p4_a9 in out nocopy JTF_VARCHAR2_TABLE_100
53: , x_return_status out nocopy VARCHAR2
46: , p4_a3 in out nocopy JTF_NUMBER_TABLE
47: , p4_a4 in out nocopy JTF_NUMBER_TABLE
48: , p4_a5 in out nocopy JTF_NUMBER_TABLE
49: , p4_a6 in out nocopy JTF_NUMBER_TABLE
50: , p4_a7 in out nocopy JTF_NUMBER_TABLE
51: , p4_a8 in out nocopy JTF_VARCHAR2_TABLE_100
52: , p4_a9 in out nocopy JTF_VARCHAR2_TABLE_100
53: , x_return_status out nocopy VARCHAR2
54: , x_msg_count out nocopy NUMBER
70: , p3_a10 in out nocopy NUMBER
71: , p3_a11 in out nocopy NUMBER
72: , p3_a12 in out nocopy NUMBER
73: , p3_a13 in out nocopy NUMBER
74: , p4_a0 in out nocopy JTF_NUMBER_TABLE
75: , p4_a1 in out nocopy JTF_DATE_TABLE
76: , p4_a2 in out nocopy JTF_NUMBER_TABLE
77: , p4_a3 in out nocopy JTF_NUMBER_TABLE
78: , p4_a4 in out nocopy JTF_NUMBER_TABLE
72: , p3_a12 in out nocopy NUMBER
73: , p3_a13 in out nocopy NUMBER
74: , p4_a0 in out nocopy JTF_NUMBER_TABLE
75: , p4_a1 in out nocopy JTF_DATE_TABLE
76: , p4_a2 in out nocopy JTF_NUMBER_TABLE
77: , p4_a3 in out nocopy JTF_NUMBER_TABLE
78: , p4_a4 in out nocopy JTF_NUMBER_TABLE
79: , p4_a5 in out nocopy JTF_NUMBER_TABLE
80: , p4_a6 in out nocopy JTF_NUMBER_TABLE
73: , p3_a13 in out nocopy NUMBER
74: , p4_a0 in out nocopy JTF_NUMBER_TABLE
75: , p4_a1 in out nocopy JTF_DATE_TABLE
76: , p4_a2 in out nocopy JTF_NUMBER_TABLE
77: , p4_a3 in out nocopy JTF_NUMBER_TABLE
78: , p4_a4 in out nocopy JTF_NUMBER_TABLE
79: , p4_a5 in out nocopy JTF_NUMBER_TABLE
80: , p4_a6 in out nocopy JTF_NUMBER_TABLE
81: , p4_a7 in out nocopy JTF_NUMBER_TABLE
74: , p4_a0 in out nocopy JTF_NUMBER_TABLE
75: , p4_a1 in out nocopy JTF_DATE_TABLE
76: , p4_a2 in out nocopy JTF_NUMBER_TABLE
77: , p4_a3 in out nocopy JTF_NUMBER_TABLE
78: , p4_a4 in out nocopy JTF_NUMBER_TABLE
79: , p4_a5 in out nocopy JTF_NUMBER_TABLE
80: , p4_a6 in out nocopy JTF_NUMBER_TABLE
81: , p4_a7 in out nocopy JTF_NUMBER_TABLE
82: , p4_a8 in out nocopy JTF_VARCHAR2_TABLE_100
75: , p4_a1 in out nocopy JTF_DATE_TABLE
76: , p4_a2 in out nocopy JTF_NUMBER_TABLE
77: , p4_a3 in out nocopy JTF_NUMBER_TABLE
78: , p4_a4 in out nocopy JTF_NUMBER_TABLE
79: , p4_a5 in out nocopy JTF_NUMBER_TABLE
80: , p4_a6 in out nocopy JTF_NUMBER_TABLE
81: , p4_a7 in out nocopy JTF_NUMBER_TABLE
82: , p4_a8 in out nocopy JTF_VARCHAR2_TABLE_100
83: , p4_a9 in out nocopy JTF_VARCHAR2_TABLE_100
76: , p4_a2 in out nocopy JTF_NUMBER_TABLE
77: , p4_a3 in out nocopy JTF_NUMBER_TABLE
78: , p4_a4 in out nocopy JTF_NUMBER_TABLE
79: , p4_a5 in out nocopy JTF_NUMBER_TABLE
80: , p4_a6 in out nocopy JTF_NUMBER_TABLE
81: , p4_a7 in out nocopy JTF_NUMBER_TABLE
82: , p4_a8 in out nocopy JTF_VARCHAR2_TABLE_100
83: , p4_a9 in out nocopy JTF_VARCHAR2_TABLE_100
84: , x_return_status out nocopy VARCHAR2
77: , p4_a3 in out nocopy JTF_NUMBER_TABLE
78: , p4_a4 in out nocopy JTF_NUMBER_TABLE
79: , p4_a5 in out nocopy JTF_NUMBER_TABLE
80: , p4_a6 in out nocopy JTF_NUMBER_TABLE
81: , p4_a7 in out nocopy JTF_NUMBER_TABLE
82: , p4_a8 in out nocopy JTF_VARCHAR2_TABLE_100
83: , p4_a9 in out nocopy JTF_VARCHAR2_TABLE_100
84: , x_return_status out nocopy VARCHAR2
85: , x_msg_count out nocopy NUMBER