1: package okl_deal_charges_pvt_w AUTHID CURRENT_USER as
2: /* $Header: OKLEKACS.pls 120.0.12020000.2 2012/08/07 12:51:49 racheruv ship $ */
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 AUTHID CURRENT_USER as
2: /* $Header: OKLEKACS.pls 120.0.12020000.2 2012/08/07 12:51:49 racheruv ship $ */
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.12020000.2 2012/08/07 12:51:49 racheruv ship $ */
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: , a45 JTF_NUMBER_TABLE
49: );
44: , a41 JTF_VARCHAR2_TABLE_100
45: , a42 JTF_NUMBER_TABLE
46: , a43 JTF_VARCHAR2_TABLE_500
47: , a44 JTF_VARCHAR2_TABLE_500
48: , a45 JTF_NUMBER_TABLE
49: );
50: procedure rosetta_table_copy_out_p13(t okl_deal_charges_pvt.fee_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
51: , a1 out nocopy JTF_NUMBER_TABLE
52: , a2 out nocopy JTF_VARCHAR2_TABLE_100
46: , a43 JTF_VARCHAR2_TABLE_500
47: , a44 JTF_VARCHAR2_TABLE_500
48: , a45 JTF_NUMBER_TABLE
49: );
50: procedure rosetta_table_copy_out_p13(t okl_deal_charges_pvt.fee_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
51: , a1 out nocopy JTF_NUMBER_TABLE
52: , a2 out nocopy JTF_VARCHAR2_TABLE_100
53: , a3 out nocopy JTF_NUMBER_TABLE
54: , a4 out nocopy JTF_VARCHAR2_TABLE_200
47: , a44 JTF_VARCHAR2_TABLE_500
48: , a45 JTF_NUMBER_TABLE
49: );
50: procedure rosetta_table_copy_out_p13(t okl_deal_charges_pvt.fee_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
51: , a1 out nocopy JTF_NUMBER_TABLE
52: , a2 out nocopy JTF_VARCHAR2_TABLE_100
53: , a3 out nocopy JTF_NUMBER_TABLE
54: , a4 out nocopy JTF_VARCHAR2_TABLE_200
55: , a5 out nocopy JTF_VARCHAR2_TABLE_100
49: );
50: procedure rosetta_table_copy_out_p13(t okl_deal_charges_pvt.fee_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
51: , a1 out nocopy JTF_NUMBER_TABLE
52: , a2 out nocopy JTF_VARCHAR2_TABLE_100
53: , a3 out nocopy JTF_NUMBER_TABLE
54: , a4 out nocopy JTF_VARCHAR2_TABLE_200
55: , a5 out nocopy JTF_VARCHAR2_TABLE_100
56: , a6 out nocopy JTF_VARCHAR2_TABLE_200
57: , a7 out nocopy JTF_NUMBER_TABLE
53: , a3 out nocopy JTF_NUMBER_TABLE
54: , a4 out nocopy JTF_VARCHAR2_TABLE_200
55: , a5 out nocopy JTF_VARCHAR2_TABLE_100
56: , a6 out nocopy JTF_VARCHAR2_TABLE_200
57: , a7 out nocopy JTF_NUMBER_TABLE
58: , a8 out nocopy JTF_VARCHAR2_TABLE_400
59: , a9 out nocopy JTF_VARCHAR2_TABLE_100
60: , a10 out nocopy JTF_VARCHAR2_TABLE_200
61: , a11 out nocopy JTF_DATE_TABLE
59: , a9 out nocopy JTF_VARCHAR2_TABLE_100
60: , a10 out nocopy JTF_VARCHAR2_TABLE_200
61: , a11 out nocopy JTF_DATE_TABLE
62: , a12 out nocopy JTF_DATE_TABLE
63: , a13 out nocopy JTF_NUMBER_TABLE
64: , a14 out nocopy JTF_NUMBER_TABLE
65: , a15 out nocopy JTF_NUMBER_TABLE
66: , a16 out nocopy JTF_NUMBER_TABLE
67: , a17 out nocopy JTF_DATE_TABLE
60: , a10 out nocopy JTF_VARCHAR2_TABLE_200
61: , a11 out nocopy JTF_DATE_TABLE
62: , a12 out nocopy JTF_DATE_TABLE
63: , a13 out nocopy JTF_NUMBER_TABLE
64: , a14 out nocopy JTF_NUMBER_TABLE
65: , a15 out nocopy JTF_NUMBER_TABLE
66: , a16 out nocopy JTF_NUMBER_TABLE
67: , a17 out nocopy JTF_DATE_TABLE
68: , a18 out nocopy JTF_VARCHAR2_TABLE_100
61: , a11 out nocopy JTF_DATE_TABLE
62: , a12 out nocopy JTF_DATE_TABLE
63: , a13 out nocopy JTF_NUMBER_TABLE
64: , a14 out nocopy JTF_NUMBER_TABLE
65: , a15 out nocopy JTF_NUMBER_TABLE
66: , a16 out nocopy JTF_NUMBER_TABLE
67: , a17 out nocopy JTF_DATE_TABLE
68: , a18 out nocopy JTF_VARCHAR2_TABLE_100
69: , a19 out nocopy JTF_VARCHAR2_TABLE_100
62: , a12 out nocopy JTF_DATE_TABLE
63: , a13 out nocopy JTF_NUMBER_TABLE
64: , a14 out nocopy JTF_NUMBER_TABLE
65: , a15 out nocopy JTF_NUMBER_TABLE
66: , a16 out nocopy JTF_NUMBER_TABLE
67: , a17 out nocopy JTF_DATE_TABLE
68: , a18 out nocopy JTF_VARCHAR2_TABLE_100
69: , a19 out nocopy JTF_VARCHAR2_TABLE_100
70: , a20 out nocopy JTF_VARCHAR2_TABLE_500
82: , a32 out nocopy JTF_VARCHAR2_TABLE_500
83: , a33 out nocopy JTF_VARCHAR2_TABLE_500
84: , a34 out nocopy JTF_VARCHAR2_TABLE_500
85: , a35 out nocopy JTF_VARCHAR2_TABLE_100
86: , a36 out nocopy JTF_NUMBER_TABLE
87: , a37 out nocopy JTF_NUMBER_TABLE
88: , a38 out nocopy JTF_VARCHAR2_TABLE_100
89: , a39 out nocopy JTF_VARCHAR2_TABLE_200
90: , a40 out nocopy JTF_VARCHAR2_TABLE_100
83: , a33 out nocopy JTF_VARCHAR2_TABLE_500
84: , a34 out nocopy JTF_VARCHAR2_TABLE_500
85: , a35 out nocopy JTF_VARCHAR2_TABLE_100
86: , a36 out nocopy JTF_NUMBER_TABLE
87: , a37 out nocopy JTF_NUMBER_TABLE
88: , a38 out nocopy JTF_VARCHAR2_TABLE_100
89: , a39 out nocopy JTF_VARCHAR2_TABLE_200
90: , a40 out nocopy JTF_VARCHAR2_TABLE_100
91: , a41 out nocopy JTF_VARCHAR2_TABLE_100
88: , a38 out nocopy JTF_VARCHAR2_TABLE_100
89: , a39 out nocopy JTF_VARCHAR2_TABLE_200
90: , a40 out nocopy JTF_VARCHAR2_TABLE_100
91: , a41 out nocopy JTF_VARCHAR2_TABLE_100
92: , a42 out nocopy JTF_NUMBER_TABLE
93: , a43 out nocopy JTF_VARCHAR2_TABLE_500
94: , a44 out nocopy JTF_VARCHAR2_TABLE_500
95: , a45 out nocopy JTF_NUMBER_TABLE
96: );
91: , a41 out nocopy JTF_VARCHAR2_TABLE_100
92: , a42 out nocopy JTF_NUMBER_TABLE
93: , a43 out nocopy JTF_VARCHAR2_TABLE_500
94: , a44 out nocopy JTF_VARCHAR2_TABLE_500
95: , a45 out nocopy JTF_NUMBER_TABLE
96: );
97:
98: procedure rosetta_table_copy_in_p15(t out nocopy okl_deal_charges_pvt.cov_asset_tbl_type, a0 JTF_NUMBER_TABLE
99: , a1 JTF_NUMBER_TABLE
94: , a44 out nocopy JTF_VARCHAR2_TABLE_500
95: , a45 out nocopy JTF_NUMBER_TABLE
96: );
97:
98: procedure rosetta_table_copy_in_p15(t out nocopy okl_deal_charges_pvt.cov_asset_tbl_type, a0 JTF_NUMBER_TABLE
99: , a1 JTF_NUMBER_TABLE
100: , a2 JTF_NUMBER_TABLE
101: , a3 JTF_VARCHAR2_TABLE_200
102: , a4 JTF_VARCHAR2_TABLE_2000
95: , a45 out nocopy JTF_NUMBER_TABLE
96: );
97:
98: procedure rosetta_table_copy_in_p15(t out nocopy okl_deal_charges_pvt.cov_asset_tbl_type, a0 JTF_NUMBER_TABLE
99: , a1 JTF_NUMBER_TABLE
100: , a2 JTF_NUMBER_TABLE
101: , a3 JTF_VARCHAR2_TABLE_200
102: , a4 JTF_VARCHAR2_TABLE_2000
103: , a5 JTF_NUMBER_TABLE
96: );
97:
98: procedure rosetta_table_copy_in_p15(t out nocopy okl_deal_charges_pvt.cov_asset_tbl_type, a0 JTF_NUMBER_TABLE
99: , a1 JTF_NUMBER_TABLE
100: , a2 JTF_NUMBER_TABLE
101: , a3 JTF_VARCHAR2_TABLE_200
102: , a4 JTF_VARCHAR2_TABLE_2000
103: , a5 JTF_NUMBER_TABLE
104: , a6 JTF_NUMBER_TABLE
99: , a1 JTF_NUMBER_TABLE
100: , a2 JTF_NUMBER_TABLE
101: , a3 JTF_VARCHAR2_TABLE_200
102: , a4 JTF_VARCHAR2_TABLE_2000
103: , a5 JTF_NUMBER_TABLE
104: , a6 JTF_NUMBER_TABLE
105: , a7 JTF_VARCHAR2_TABLE_100
106: , a8 JTF_VARCHAR2_TABLE_200
107: , a9 JTF_VARCHAR2_TABLE_100
100: , a2 JTF_NUMBER_TABLE
101: , a3 JTF_VARCHAR2_TABLE_200
102: , a4 JTF_VARCHAR2_TABLE_2000
103: , a5 JTF_NUMBER_TABLE
104: , a6 JTF_NUMBER_TABLE
105: , a7 JTF_VARCHAR2_TABLE_100
106: , a8 JTF_VARCHAR2_TABLE_200
107: , a9 JTF_VARCHAR2_TABLE_100
108: );
105: , a7 JTF_VARCHAR2_TABLE_100
106: , a8 JTF_VARCHAR2_TABLE_200
107: , a9 JTF_VARCHAR2_TABLE_100
108: );
109: procedure rosetta_table_copy_out_p15(t okl_deal_charges_pvt.cov_asset_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
110: , a1 out nocopy JTF_NUMBER_TABLE
111: , a2 out nocopy JTF_NUMBER_TABLE
112: , a3 out nocopy JTF_VARCHAR2_TABLE_200
113: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
106: , a8 JTF_VARCHAR2_TABLE_200
107: , a9 JTF_VARCHAR2_TABLE_100
108: );
109: procedure rosetta_table_copy_out_p15(t okl_deal_charges_pvt.cov_asset_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
110: , a1 out nocopy JTF_NUMBER_TABLE
111: , a2 out nocopy JTF_NUMBER_TABLE
112: , a3 out nocopy JTF_VARCHAR2_TABLE_200
113: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
114: , a5 out nocopy JTF_NUMBER_TABLE
107: , a9 JTF_VARCHAR2_TABLE_100
108: );
109: procedure rosetta_table_copy_out_p15(t okl_deal_charges_pvt.cov_asset_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
110: , a1 out nocopy JTF_NUMBER_TABLE
111: , a2 out nocopy JTF_NUMBER_TABLE
112: , a3 out nocopy JTF_VARCHAR2_TABLE_200
113: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
114: , a5 out nocopy JTF_NUMBER_TABLE
115: , a6 out nocopy JTF_NUMBER_TABLE
110: , a1 out nocopy JTF_NUMBER_TABLE
111: , a2 out nocopy JTF_NUMBER_TABLE
112: , a3 out nocopy JTF_VARCHAR2_TABLE_200
113: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
114: , a5 out nocopy JTF_NUMBER_TABLE
115: , a6 out nocopy JTF_NUMBER_TABLE
116: , a7 out nocopy JTF_VARCHAR2_TABLE_100
117: , a8 out nocopy JTF_VARCHAR2_TABLE_200
118: , a9 out nocopy JTF_VARCHAR2_TABLE_100
111: , a2 out nocopy JTF_NUMBER_TABLE
112: , a3 out nocopy JTF_VARCHAR2_TABLE_200
113: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
114: , a5 out nocopy JTF_NUMBER_TABLE
115: , a6 out nocopy JTF_NUMBER_TABLE
116: , a7 out nocopy JTF_VARCHAR2_TABLE_100
117: , a8 out nocopy JTF_VARCHAR2_TABLE_200
118: , a9 out nocopy JTF_VARCHAR2_TABLE_100
119: );
126: , p_chr_id NUMBER
127: , p_cle_id NUMBER
128: , p_amount NUMBER
129: , p_mode VARCHAR2
130: , p9_a0 out nocopy JTF_NUMBER_TABLE
131: , p9_a1 out nocopy JTF_NUMBER_TABLE
132: , p9_a2 out nocopy JTF_NUMBER_TABLE
133: , p9_a3 out nocopy JTF_VARCHAR2_TABLE_200
134: , p9_a4 out nocopy JTF_VARCHAR2_TABLE_2000
127: , p_cle_id NUMBER
128: , p_amount NUMBER
129: , p_mode VARCHAR2
130: , p9_a0 out nocopy JTF_NUMBER_TABLE
131: , p9_a1 out nocopy JTF_NUMBER_TABLE
132: , p9_a2 out nocopy JTF_NUMBER_TABLE
133: , p9_a3 out nocopy JTF_VARCHAR2_TABLE_200
134: , p9_a4 out nocopy JTF_VARCHAR2_TABLE_2000
135: , p9_a5 out nocopy JTF_NUMBER_TABLE
128: , p_amount NUMBER
129: , p_mode VARCHAR2
130: , p9_a0 out nocopy JTF_NUMBER_TABLE
131: , p9_a1 out nocopy JTF_NUMBER_TABLE
132: , p9_a2 out nocopy JTF_NUMBER_TABLE
133: , p9_a3 out nocopy JTF_VARCHAR2_TABLE_200
134: , p9_a4 out nocopy JTF_VARCHAR2_TABLE_2000
135: , p9_a5 out nocopy JTF_NUMBER_TABLE
136: , p9_a6 out nocopy JTF_NUMBER_TABLE
131: , p9_a1 out nocopy JTF_NUMBER_TABLE
132: , p9_a2 out nocopy JTF_NUMBER_TABLE
133: , p9_a3 out nocopy JTF_VARCHAR2_TABLE_200
134: , p9_a4 out nocopy JTF_VARCHAR2_TABLE_2000
135: , p9_a5 out nocopy JTF_NUMBER_TABLE
136: , p9_a6 out nocopy JTF_NUMBER_TABLE
137: , p9_a7 out nocopy JTF_VARCHAR2_TABLE_100
138: , p9_a8 out nocopy JTF_VARCHAR2_TABLE_200
139: , p9_a9 out nocopy JTF_VARCHAR2_TABLE_100
132: , p9_a2 out nocopy JTF_NUMBER_TABLE
133: , p9_a3 out nocopy JTF_VARCHAR2_TABLE_200
134: , p9_a4 out nocopy JTF_VARCHAR2_TABLE_2000
135: , p9_a5 out nocopy JTF_NUMBER_TABLE
136: , p9_a6 out nocopy JTF_NUMBER_TABLE
137: , p9_a7 out nocopy JTF_VARCHAR2_TABLE_100
138: , p9_a8 out nocopy JTF_VARCHAR2_TABLE_200
139: , p9_a9 out nocopy JTF_VARCHAR2_TABLE_100
140: );