1: package okl_deal_charges_pvt_w as
2: /* $Header: OKLEKACS.pls 120.0 2007/04/20 06:26:42 udhenuko noship $ */
3: procedure rosetta_table_copy_in_p13(t out nocopy okl_deal_charges_pvt.fee_tbl_type, 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_200
1: package okl_deal_charges_pvt_w as
2: /* $Header: OKLEKACS.pls 120.0 2007/04/20 06:26:42 udhenuko noship $ */
3: procedure rosetta_table_copy_in_p13(t out nocopy okl_deal_charges_pvt.fee_tbl_type, 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_200
8: , a5 JTF_VARCHAR2_TABLE_100
2: /* $Header: OKLEKACS.pls 120.0 2007/04/20 06:26:42 udhenuko noship $ */
3: procedure rosetta_table_copy_in_p13(t out nocopy okl_deal_charges_pvt.fee_tbl_type, 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_200
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_VARCHAR2_TABLE_200
10: , a7 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_200
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_VARCHAR2_TABLE_200
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_VARCHAR2_TABLE_400
12: , a9 JTF_VARCHAR2_TABLE_100
13: , a10 JTF_VARCHAR2_TABLE_200
14: , a11 JTF_DATE_TABLE
12: , a9 JTF_VARCHAR2_TABLE_100
13: , a10 JTF_VARCHAR2_TABLE_200
14: , a11 JTF_DATE_TABLE
15: , a12 JTF_DATE_TABLE
16: , a13 JTF_NUMBER_TABLE
17: , a14 JTF_NUMBER_TABLE
18: , a15 JTF_NUMBER_TABLE
19: , a16 JTF_NUMBER_TABLE
20: , a17 JTF_DATE_TABLE
13: , a10 JTF_VARCHAR2_TABLE_200
14: , a11 JTF_DATE_TABLE
15: , a12 JTF_DATE_TABLE
16: , a13 JTF_NUMBER_TABLE
17: , a14 JTF_NUMBER_TABLE
18: , a15 JTF_NUMBER_TABLE
19: , a16 JTF_NUMBER_TABLE
20: , a17 JTF_DATE_TABLE
21: , a18 JTF_VARCHAR2_TABLE_100
14: , a11 JTF_DATE_TABLE
15: , a12 JTF_DATE_TABLE
16: , a13 JTF_NUMBER_TABLE
17: , a14 JTF_NUMBER_TABLE
18: , a15 JTF_NUMBER_TABLE
19: , a16 JTF_NUMBER_TABLE
20: , a17 JTF_DATE_TABLE
21: , a18 JTF_VARCHAR2_TABLE_100
22: , a19 JTF_VARCHAR2_TABLE_100
15: , a12 JTF_DATE_TABLE
16: , a13 JTF_NUMBER_TABLE
17: , a14 JTF_NUMBER_TABLE
18: , a15 JTF_NUMBER_TABLE
19: , a16 JTF_NUMBER_TABLE
20: , a17 JTF_DATE_TABLE
21: , a18 JTF_VARCHAR2_TABLE_100
22: , a19 JTF_VARCHAR2_TABLE_100
23: , a20 JTF_VARCHAR2_TABLE_500
35: , a32 JTF_VARCHAR2_TABLE_500
36: , a33 JTF_VARCHAR2_TABLE_500
37: , a34 JTF_VARCHAR2_TABLE_500
38: , a35 JTF_VARCHAR2_TABLE_100
39: , a36 JTF_NUMBER_TABLE
40: , a37 JTF_NUMBER_TABLE
41: , a38 JTF_VARCHAR2_TABLE_100
42: , a39 JTF_VARCHAR2_TABLE_200
43: , a40 JTF_VARCHAR2_TABLE_100
36: , a33 JTF_VARCHAR2_TABLE_500
37: , a34 JTF_VARCHAR2_TABLE_500
38: , a35 JTF_VARCHAR2_TABLE_100
39: , a36 JTF_NUMBER_TABLE
40: , a37 JTF_NUMBER_TABLE
41: , a38 JTF_VARCHAR2_TABLE_100
42: , a39 JTF_VARCHAR2_TABLE_200
43: , a40 JTF_VARCHAR2_TABLE_100
44: , a41 JTF_VARCHAR2_TABLE_100
41: , a38 JTF_VARCHAR2_TABLE_100
42: , a39 JTF_VARCHAR2_TABLE_200
43: , a40 JTF_VARCHAR2_TABLE_100
44: , a41 JTF_VARCHAR2_TABLE_100
45: , a42 JTF_NUMBER_TABLE
46: , a43 JTF_VARCHAR2_TABLE_500
47: , a44 JTF_VARCHAR2_TABLE_500
48: );
49: procedure rosetta_table_copy_out_p13(t okl_deal_charges_pvt.fee_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
45: , a42 JTF_NUMBER_TABLE
46: , a43 JTF_VARCHAR2_TABLE_500
47: , a44 JTF_VARCHAR2_TABLE_500
48: );
49: procedure rosetta_table_copy_out_p13(t okl_deal_charges_pvt.fee_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
50: , a1 out nocopy JTF_NUMBER_TABLE
51: , a2 out nocopy JTF_VARCHAR2_TABLE_100
52: , a3 out nocopy JTF_NUMBER_TABLE
53: , a4 out nocopy JTF_VARCHAR2_TABLE_200
46: , a43 JTF_VARCHAR2_TABLE_500
47: , a44 JTF_VARCHAR2_TABLE_500
48: );
49: procedure rosetta_table_copy_out_p13(t okl_deal_charges_pvt.fee_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
50: , a1 out nocopy JTF_NUMBER_TABLE
51: , a2 out nocopy JTF_VARCHAR2_TABLE_100
52: , a3 out nocopy JTF_NUMBER_TABLE
53: , a4 out nocopy JTF_VARCHAR2_TABLE_200
54: , a5 out nocopy JTF_VARCHAR2_TABLE_100
48: );
49: procedure rosetta_table_copy_out_p13(t okl_deal_charges_pvt.fee_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
50: , a1 out nocopy JTF_NUMBER_TABLE
51: , a2 out nocopy JTF_VARCHAR2_TABLE_100
52: , a3 out nocopy JTF_NUMBER_TABLE
53: , a4 out nocopy JTF_VARCHAR2_TABLE_200
54: , a5 out nocopy JTF_VARCHAR2_TABLE_100
55: , a6 out nocopy JTF_VARCHAR2_TABLE_200
56: , a7 out nocopy JTF_NUMBER_TABLE
52: , a3 out nocopy JTF_NUMBER_TABLE
53: , a4 out nocopy JTF_VARCHAR2_TABLE_200
54: , a5 out nocopy JTF_VARCHAR2_TABLE_100
55: , a6 out nocopy JTF_VARCHAR2_TABLE_200
56: , a7 out nocopy JTF_NUMBER_TABLE
57: , a8 out nocopy JTF_VARCHAR2_TABLE_400
58: , a9 out nocopy JTF_VARCHAR2_TABLE_100
59: , a10 out nocopy JTF_VARCHAR2_TABLE_200
60: , a11 out nocopy JTF_DATE_TABLE
58: , a9 out nocopy JTF_VARCHAR2_TABLE_100
59: , a10 out nocopy JTF_VARCHAR2_TABLE_200
60: , a11 out nocopy JTF_DATE_TABLE
61: , a12 out nocopy JTF_DATE_TABLE
62: , a13 out nocopy JTF_NUMBER_TABLE
63: , a14 out nocopy JTF_NUMBER_TABLE
64: , a15 out nocopy JTF_NUMBER_TABLE
65: , a16 out nocopy JTF_NUMBER_TABLE
66: , a17 out nocopy JTF_DATE_TABLE
59: , a10 out nocopy JTF_VARCHAR2_TABLE_200
60: , a11 out nocopy JTF_DATE_TABLE
61: , a12 out nocopy JTF_DATE_TABLE
62: , a13 out nocopy JTF_NUMBER_TABLE
63: , a14 out nocopy JTF_NUMBER_TABLE
64: , a15 out nocopy JTF_NUMBER_TABLE
65: , a16 out nocopy JTF_NUMBER_TABLE
66: , a17 out nocopy JTF_DATE_TABLE
67: , a18 out nocopy JTF_VARCHAR2_TABLE_100
60: , a11 out nocopy JTF_DATE_TABLE
61: , a12 out nocopy JTF_DATE_TABLE
62: , a13 out nocopy JTF_NUMBER_TABLE
63: , a14 out nocopy JTF_NUMBER_TABLE
64: , a15 out nocopy JTF_NUMBER_TABLE
65: , a16 out nocopy JTF_NUMBER_TABLE
66: , a17 out nocopy JTF_DATE_TABLE
67: , a18 out nocopy JTF_VARCHAR2_TABLE_100
68: , a19 out nocopy JTF_VARCHAR2_TABLE_100
61: , a12 out nocopy JTF_DATE_TABLE
62: , a13 out nocopy JTF_NUMBER_TABLE
63: , a14 out nocopy JTF_NUMBER_TABLE
64: , a15 out nocopy JTF_NUMBER_TABLE
65: , a16 out nocopy JTF_NUMBER_TABLE
66: , a17 out nocopy JTF_DATE_TABLE
67: , a18 out nocopy JTF_VARCHAR2_TABLE_100
68: , a19 out nocopy JTF_VARCHAR2_TABLE_100
69: , a20 out nocopy JTF_VARCHAR2_TABLE_500
81: , a32 out nocopy JTF_VARCHAR2_TABLE_500
82: , a33 out nocopy JTF_VARCHAR2_TABLE_500
83: , a34 out nocopy JTF_VARCHAR2_TABLE_500
84: , a35 out nocopy JTF_VARCHAR2_TABLE_100
85: , a36 out nocopy JTF_NUMBER_TABLE
86: , a37 out nocopy JTF_NUMBER_TABLE
87: , a38 out nocopy JTF_VARCHAR2_TABLE_100
88: , a39 out nocopy JTF_VARCHAR2_TABLE_200
89: , a40 out nocopy JTF_VARCHAR2_TABLE_100
82: , a33 out nocopy JTF_VARCHAR2_TABLE_500
83: , a34 out nocopy JTF_VARCHAR2_TABLE_500
84: , a35 out nocopy JTF_VARCHAR2_TABLE_100
85: , a36 out nocopy JTF_NUMBER_TABLE
86: , a37 out nocopy JTF_NUMBER_TABLE
87: , a38 out nocopy JTF_VARCHAR2_TABLE_100
88: , a39 out nocopy JTF_VARCHAR2_TABLE_200
89: , a40 out nocopy JTF_VARCHAR2_TABLE_100
90: , a41 out nocopy JTF_VARCHAR2_TABLE_100
87: , a38 out nocopy JTF_VARCHAR2_TABLE_100
88: , a39 out nocopy JTF_VARCHAR2_TABLE_200
89: , a40 out nocopy JTF_VARCHAR2_TABLE_100
90: , a41 out nocopy JTF_VARCHAR2_TABLE_100
91: , a42 out nocopy JTF_NUMBER_TABLE
92: , a43 out nocopy JTF_VARCHAR2_TABLE_500
93: , a44 out nocopy JTF_VARCHAR2_TABLE_500
94: );
95:
92: , a43 out nocopy JTF_VARCHAR2_TABLE_500
93: , a44 out nocopy JTF_VARCHAR2_TABLE_500
94: );
95:
96: procedure rosetta_table_copy_in_p15(t out nocopy okl_deal_charges_pvt.cov_asset_tbl_type, a0 JTF_NUMBER_TABLE
97: , a1 JTF_NUMBER_TABLE
98: , a2 JTF_NUMBER_TABLE
99: , a3 JTF_VARCHAR2_TABLE_200
100: , a4 JTF_VARCHAR2_TABLE_2000
93: , a44 out nocopy JTF_VARCHAR2_TABLE_500
94: );
95:
96: procedure rosetta_table_copy_in_p15(t out nocopy okl_deal_charges_pvt.cov_asset_tbl_type, a0 JTF_NUMBER_TABLE
97: , a1 JTF_NUMBER_TABLE
98: , a2 JTF_NUMBER_TABLE
99: , a3 JTF_VARCHAR2_TABLE_200
100: , a4 JTF_VARCHAR2_TABLE_2000
101: , a5 JTF_NUMBER_TABLE
94: );
95:
96: procedure rosetta_table_copy_in_p15(t out nocopy okl_deal_charges_pvt.cov_asset_tbl_type, a0 JTF_NUMBER_TABLE
97: , a1 JTF_NUMBER_TABLE
98: , a2 JTF_NUMBER_TABLE
99: , a3 JTF_VARCHAR2_TABLE_200
100: , a4 JTF_VARCHAR2_TABLE_2000
101: , a5 JTF_NUMBER_TABLE
102: , a6 JTF_NUMBER_TABLE
97: , a1 JTF_NUMBER_TABLE
98: , a2 JTF_NUMBER_TABLE
99: , a3 JTF_VARCHAR2_TABLE_200
100: , a4 JTF_VARCHAR2_TABLE_2000
101: , a5 JTF_NUMBER_TABLE
102: , a6 JTF_NUMBER_TABLE
103: , a7 JTF_VARCHAR2_TABLE_100
104: , a8 JTF_VARCHAR2_TABLE_200
105: , a9 JTF_VARCHAR2_TABLE_100
98: , a2 JTF_NUMBER_TABLE
99: , a3 JTF_VARCHAR2_TABLE_200
100: , a4 JTF_VARCHAR2_TABLE_2000
101: , a5 JTF_NUMBER_TABLE
102: , a6 JTF_NUMBER_TABLE
103: , a7 JTF_VARCHAR2_TABLE_100
104: , a8 JTF_VARCHAR2_TABLE_200
105: , a9 JTF_VARCHAR2_TABLE_100
106: );
103: , a7 JTF_VARCHAR2_TABLE_100
104: , a8 JTF_VARCHAR2_TABLE_200
105: , a9 JTF_VARCHAR2_TABLE_100
106: );
107: procedure rosetta_table_copy_out_p15(t okl_deal_charges_pvt.cov_asset_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
108: , a1 out nocopy JTF_NUMBER_TABLE
109: , a2 out nocopy JTF_NUMBER_TABLE
110: , a3 out nocopy JTF_VARCHAR2_TABLE_200
111: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
104: , a8 JTF_VARCHAR2_TABLE_200
105: , a9 JTF_VARCHAR2_TABLE_100
106: );
107: procedure rosetta_table_copy_out_p15(t okl_deal_charges_pvt.cov_asset_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
108: , a1 out nocopy JTF_NUMBER_TABLE
109: , a2 out nocopy JTF_NUMBER_TABLE
110: , a3 out nocopy JTF_VARCHAR2_TABLE_200
111: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
112: , a5 out nocopy JTF_NUMBER_TABLE
105: , a9 JTF_VARCHAR2_TABLE_100
106: );
107: procedure rosetta_table_copy_out_p15(t okl_deal_charges_pvt.cov_asset_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
108: , a1 out nocopy JTF_NUMBER_TABLE
109: , a2 out nocopy JTF_NUMBER_TABLE
110: , a3 out nocopy JTF_VARCHAR2_TABLE_200
111: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
112: , a5 out nocopy JTF_NUMBER_TABLE
113: , a6 out nocopy JTF_NUMBER_TABLE
108: , a1 out nocopy JTF_NUMBER_TABLE
109: , a2 out nocopy JTF_NUMBER_TABLE
110: , a3 out nocopy JTF_VARCHAR2_TABLE_200
111: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
112: , a5 out nocopy JTF_NUMBER_TABLE
113: , a6 out nocopy JTF_NUMBER_TABLE
114: , a7 out nocopy JTF_VARCHAR2_TABLE_100
115: , a8 out nocopy JTF_VARCHAR2_TABLE_200
116: , a9 out nocopy JTF_VARCHAR2_TABLE_100
109: , a2 out nocopy JTF_NUMBER_TABLE
110: , a3 out nocopy JTF_VARCHAR2_TABLE_200
111: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
112: , a5 out nocopy JTF_NUMBER_TABLE
113: , a6 out nocopy JTF_NUMBER_TABLE
114: , a7 out nocopy JTF_VARCHAR2_TABLE_100
115: , a8 out nocopy JTF_VARCHAR2_TABLE_200
116: , a9 out nocopy JTF_VARCHAR2_TABLE_100
117: );
124: , p_chr_id NUMBER
125: , p_cle_id NUMBER
126: , p_amount NUMBER
127: , p_mode VARCHAR2
128: , p9_a0 out nocopy JTF_NUMBER_TABLE
129: , p9_a1 out nocopy JTF_NUMBER_TABLE
130: , p9_a2 out nocopy JTF_NUMBER_TABLE
131: , p9_a3 out nocopy JTF_VARCHAR2_TABLE_200
132: , p9_a4 out nocopy JTF_VARCHAR2_TABLE_2000
125: , p_cle_id NUMBER
126: , p_amount NUMBER
127: , p_mode VARCHAR2
128: , p9_a0 out nocopy JTF_NUMBER_TABLE
129: , p9_a1 out nocopy JTF_NUMBER_TABLE
130: , p9_a2 out nocopy JTF_NUMBER_TABLE
131: , p9_a3 out nocopy JTF_VARCHAR2_TABLE_200
132: , p9_a4 out nocopy JTF_VARCHAR2_TABLE_2000
133: , p9_a5 out nocopy JTF_NUMBER_TABLE
126: , p_amount NUMBER
127: , p_mode VARCHAR2
128: , p9_a0 out nocopy JTF_NUMBER_TABLE
129: , p9_a1 out nocopy JTF_NUMBER_TABLE
130: , p9_a2 out nocopy JTF_NUMBER_TABLE
131: , p9_a3 out nocopy JTF_VARCHAR2_TABLE_200
132: , p9_a4 out nocopy JTF_VARCHAR2_TABLE_2000
133: , p9_a5 out nocopy JTF_NUMBER_TABLE
134: , p9_a6 out nocopy JTF_NUMBER_TABLE
129: , p9_a1 out nocopy JTF_NUMBER_TABLE
130: , p9_a2 out nocopy JTF_NUMBER_TABLE
131: , p9_a3 out nocopy JTF_VARCHAR2_TABLE_200
132: , p9_a4 out nocopy JTF_VARCHAR2_TABLE_2000
133: , p9_a5 out nocopy JTF_NUMBER_TABLE
134: , p9_a6 out nocopy JTF_NUMBER_TABLE
135: , p9_a7 out nocopy JTF_VARCHAR2_TABLE_100
136: , p9_a8 out nocopy JTF_VARCHAR2_TABLE_200
137: , p9_a9 out nocopy JTF_VARCHAR2_TABLE_100
130: , p9_a2 out nocopy JTF_NUMBER_TABLE
131: , p9_a3 out nocopy JTF_VARCHAR2_TABLE_200
132: , p9_a4 out nocopy JTF_VARCHAR2_TABLE_2000
133: , p9_a5 out nocopy JTF_NUMBER_TABLE
134: , p9_a6 out nocopy JTF_NUMBER_TABLE
135: , p9_a7 out nocopy JTF_VARCHAR2_TABLE_100
136: , p9_a8 out nocopy JTF_VARCHAR2_TABLE_200
137: , p9_a9 out nocopy JTF_VARCHAR2_TABLE_100
138: );