1: package okl_asset_subsidy_pvt_w AUTHID CURRENT_USER as
2: /* $Header: OKLEASBS.pls 115.1 2003/10/16 07:54:11 avsingh noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy okl_asset_subsidy_pvt.asb_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_VARCHAR2_TABLE_200
7: , a4 JTF_NUMBER_TABLE
1: package okl_asset_subsidy_pvt_w AUTHID CURRENT_USER as
2: /* $Header: OKLEASBS.pls 115.1 2003/10/16 07:54:11 avsingh noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy okl_asset_subsidy_pvt.asb_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_VARCHAR2_TABLE_200
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
3: procedure rosetta_table_copy_in_p1(t out nocopy okl_asset_subsidy_pvt.asb_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_VARCHAR2_TABLE_200
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_VARCHAR2_TABLE_200
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_VARCHAR2_TABLE_200
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_VARCHAR2_TABLE_300
6: , a3 JTF_VARCHAR2_TABLE_200
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_VARCHAR2_TABLE_300
14: );
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_VARCHAR2_TABLE_300
14: );
15: procedure rosetta_table_copy_out_p1(t okl_asset_subsidy_pvt.asb_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_VARCHAR2_TABLE_300
14: );
15: procedure rosetta_table_copy_out_p1(t okl_asset_subsidy_pvt.asb_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
16: , a1 out nocopy JTF_NUMBER_TABLE
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_VARCHAR2_TABLE_300
14: );
15: procedure rosetta_table_copy_out_p1(t okl_asset_subsidy_pvt.asb_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
16: , a1 out nocopy JTF_NUMBER_TABLE
17: , a2 out nocopy JTF_VARCHAR2_TABLE_100
18: , a3 out nocopy JTF_VARCHAR2_TABLE_200
19: , a4 out nocopy JTF_NUMBER_TABLE
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_VARCHAR2_TABLE_300
14: );
15: procedure rosetta_table_copy_out_p1(t okl_asset_subsidy_pvt.asb_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
16: , a1 out nocopy JTF_NUMBER_TABLE
17: , a2 out nocopy JTF_VARCHAR2_TABLE_100
18: , a3 out nocopy JTF_VARCHAR2_TABLE_200
19: , a4 out nocopy JTF_NUMBER_TABLE
20: , a5 out nocopy JTF_NUMBER_TABLE
15: procedure rosetta_table_copy_out_p1(t okl_asset_subsidy_pvt.asb_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
16: , a1 out nocopy JTF_NUMBER_TABLE
17: , a2 out nocopy JTF_VARCHAR2_TABLE_100
18: , a3 out nocopy JTF_VARCHAR2_TABLE_200
19: , a4 out nocopy JTF_NUMBER_TABLE
20: , a5 out nocopy JTF_NUMBER_TABLE
21: , a6 out nocopy JTF_NUMBER_TABLE
22: , a7 out nocopy JTF_NUMBER_TABLE
23: , a8 out nocopy JTF_NUMBER_TABLE
16: , a1 out nocopy JTF_NUMBER_TABLE
17: , a2 out nocopy JTF_VARCHAR2_TABLE_100
18: , a3 out nocopy JTF_VARCHAR2_TABLE_200
19: , a4 out nocopy JTF_NUMBER_TABLE
20: , a5 out nocopy JTF_NUMBER_TABLE
21: , a6 out nocopy JTF_NUMBER_TABLE
22: , a7 out nocopy JTF_NUMBER_TABLE
23: , a8 out nocopy JTF_NUMBER_TABLE
24: , a9 out nocopy JTF_NUMBER_TABLE
17: , a2 out nocopy JTF_VARCHAR2_TABLE_100
18: , a3 out nocopy JTF_VARCHAR2_TABLE_200
19: , a4 out nocopy JTF_NUMBER_TABLE
20: , a5 out nocopy JTF_NUMBER_TABLE
21: , a6 out nocopy JTF_NUMBER_TABLE
22: , a7 out nocopy JTF_NUMBER_TABLE
23: , a8 out nocopy JTF_NUMBER_TABLE
24: , a9 out nocopy JTF_NUMBER_TABLE
25: , a10 out nocopy JTF_VARCHAR2_TABLE_300
18: , a3 out nocopy JTF_VARCHAR2_TABLE_200
19: , a4 out nocopy JTF_NUMBER_TABLE
20: , a5 out nocopy JTF_NUMBER_TABLE
21: , a6 out nocopy JTF_NUMBER_TABLE
22: , a7 out nocopy JTF_NUMBER_TABLE
23: , a8 out nocopy JTF_NUMBER_TABLE
24: , a9 out nocopy JTF_NUMBER_TABLE
25: , a10 out nocopy JTF_VARCHAR2_TABLE_300
26: );
19: , a4 out nocopy JTF_NUMBER_TABLE
20: , a5 out nocopy JTF_NUMBER_TABLE
21: , a6 out nocopy JTF_NUMBER_TABLE
22: , a7 out nocopy JTF_NUMBER_TABLE
23: , a8 out nocopy JTF_NUMBER_TABLE
24: , a9 out nocopy JTF_NUMBER_TABLE
25: , a10 out nocopy JTF_VARCHAR2_TABLE_300
26: );
27:
20: , a5 out nocopy JTF_NUMBER_TABLE
21: , a6 out nocopy JTF_NUMBER_TABLE
22: , a7 out nocopy JTF_NUMBER_TABLE
23: , a8 out nocopy JTF_NUMBER_TABLE
24: , a9 out nocopy JTF_NUMBER_TABLE
25: , a10 out nocopy JTF_VARCHAR2_TABLE_300
26: );
27:
28: procedure create_asset_subsidy(p_api_version NUMBER
57: , p_init_msg_list VARCHAR2
58: , x_return_status out nocopy VARCHAR2
59: , x_msg_count out nocopy NUMBER
60: , x_msg_data out nocopy VARCHAR2
61: , p5_a0 JTF_NUMBER_TABLE
62: , p5_a1 JTF_NUMBER_TABLE
63: , p5_a2 JTF_VARCHAR2_TABLE_100
64: , p5_a3 JTF_VARCHAR2_TABLE_200
65: , p5_a4 JTF_NUMBER_TABLE
58: , x_return_status out nocopy VARCHAR2
59: , x_msg_count out nocopy NUMBER
60: , x_msg_data out nocopy VARCHAR2
61: , p5_a0 JTF_NUMBER_TABLE
62: , p5_a1 JTF_NUMBER_TABLE
63: , p5_a2 JTF_VARCHAR2_TABLE_100
64: , p5_a3 JTF_VARCHAR2_TABLE_200
65: , p5_a4 JTF_NUMBER_TABLE
66: , p5_a5 JTF_NUMBER_TABLE
61: , p5_a0 JTF_NUMBER_TABLE
62: , p5_a1 JTF_NUMBER_TABLE
63: , p5_a2 JTF_VARCHAR2_TABLE_100
64: , p5_a3 JTF_VARCHAR2_TABLE_200
65: , p5_a4 JTF_NUMBER_TABLE
66: , p5_a5 JTF_NUMBER_TABLE
67: , p5_a6 JTF_NUMBER_TABLE
68: , p5_a7 JTF_NUMBER_TABLE
69: , p5_a8 JTF_NUMBER_TABLE
62: , p5_a1 JTF_NUMBER_TABLE
63: , p5_a2 JTF_VARCHAR2_TABLE_100
64: , p5_a3 JTF_VARCHAR2_TABLE_200
65: , p5_a4 JTF_NUMBER_TABLE
66: , p5_a5 JTF_NUMBER_TABLE
67: , p5_a6 JTF_NUMBER_TABLE
68: , p5_a7 JTF_NUMBER_TABLE
69: , p5_a8 JTF_NUMBER_TABLE
70: , p5_a9 JTF_NUMBER_TABLE
63: , p5_a2 JTF_VARCHAR2_TABLE_100
64: , p5_a3 JTF_VARCHAR2_TABLE_200
65: , p5_a4 JTF_NUMBER_TABLE
66: , p5_a5 JTF_NUMBER_TABLE
67: , p5_a6 JTF_NUMBER_TABLE
68: , p5_a7 JTF_NUMBER_TABLE
69: , p5_a8 JTF_NUMBER_TABLE
70: , p5_a9 JTF_NUMBER_TABLE
71: , p5_a10 JTF_VARCHAR2_TABLE_300
64: , p5_a3 JTF_VARCHAR2_TABLE_200
65: , p5_a4 JTF_NUMBER_TABLE
66: , p5_a5 JTF_NUMBER_TABLE
67: , p5_a6 JTF_NUMBER_TABLE
68: , p5_a7 JTF_NUMBER_TABLE
69: , p5_a8 JTF_NUMBER_TABLE
70: , p5_a9 JTF_NUMBER_TABLE
71: , p5_a10 JTF_VARCHAR2_TABLE_300
72: , p6_a0 out nocopy JTF_NUMBER_TABLE
65: , p5_a4 JTF_NUMBER_TABLE
66: , p5_a5 JTF_NUMBER_TABLE
67: , p5_a6 JTF_NUMBER_TABLE
68: , p5_a7 JTF_NUMBER_TABLE
69: , p5_a8 JTF_NUMBER_TABLE
70: , p5_a9 JTF_NUMBER_TABLE
71: , p5_a10 JTF_VARCHAR2_TABLE_300
72: , p6_a0 out nocopy JTF_NUMBER_TABLE
73: , p6_a1 out nocopy JTF_NUMBER_TABLE
66: , p5_a5 JTF_NUMBER_TABLE
67: , p5_a6 JTF_NUMBER_TABLE
68: , p5_a7 JTF_NUMBER_TABLE
69: , p5_a8 JTF_NUMBER_TABLE
70: , p5_a9 JTF_NUMBER_TABLE
71: , p5_a10 JTF_VARCHAR2_TABLE_300
72: , p6_a0 out nocopy JTF_NUMBER_TABLE
73: , p6_a1 out nocopy JTF_NUMBER_TABLE
74: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
68: , p5_a7 JTF_NUMBER_TABLE
69: , p5_a8 JTF_NUMBER_TABLE
70: , p5_a9 JTF_NUMBER_TABLE
71: , p5_a10 JTF_VARCHAR2_TABLE_300
72: , p6_a0 out nocopy JTF_NUMBER_TABLE
73: , p6_a1 out nocopy JTF_NUMBER_TABLE
74: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
75: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
76: , p6_a4 out nocopy JTF_NUMBER_TABLE
69: , p5_a8 JTF_NUMBER_TABLE
70: , p5_a9 JTF_NUMBER_TABLE
71: , p5_a10 JTF_VARCHAR2_TABLE_300
72: , p6_a0 out nocopy JTF_NUMBER_TABLE
73: , p6_a1 out nocopy JTF_NUMBER_TABLE
74: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
75: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
76: , p6_a4 out nocopy JTF_NUMBER_TABLE
77: , p6_a5 out nocopy JTF_NUMBER_TABLE
72: , p6_a0 out nocopy JTF_NUMBER_TABLE
73: , p6_a1 out nocopy JTF_NUMBER_TABLE
74: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
75: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
76: , p6_a4 out nocopy JTF_NUMBER_TABLE
77: , p6_a5 out nocopy JTF_NUMBER_TABLE
78: , p6_a6 out nocopy JTF_NUMBER_TABLE
79: , p6_a7 out nocopy JTF_NUMBER_TABLE
80: , p6_a8 out nocopy JTF_NUMBER_TABLE
73: , p6_a1 out nocopy JTF_NUMBER_TABLE
74: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
75: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
76: , p6_a4 out nocopy JTF_NUMBER_TABLE
77: , p6_a5 out nocopy JTF_NUMBER_TABLE
78: , p6_a6 out nocopy JTF_NUMBER_TABLE
79: , p6_a7 out nocopy JTF_NUMBER_TABLE
80: , p6_a8 out nocopy JTF_NUMBER_TABLE
81: , p6_a9 out nocopy JTF_NUMBER_TABLE
74: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
75: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
76: , p6_a4 out nocopy JTF_NUMBER_TABLE
77: , p6_a5 out nocopy JTF_NUMBER_TABLE
78: , p6_a6 out nocopy JTF_NUMBER_TABLE
79: , p6_a7 out nocopy JTF_NUMBER_TABLE
80: , p6_a8 out nocopy JTF_NUMBER_TABLE
81: , p6_a9 out nocopy JTF_NUMBER_TABLE
82: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_300
75: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
76: , p6_a4 out nocopy JTF_NUMBER_TABLE
77: , p6_a5 out nocopy JTF_NUMBER_TABLE
78: , p6_a6 out nocopy JTF_NUMBER_TABLE
79: , p6_a7 out nocopy JTF_NUMBER_TABLE
80: , p6_a8 out nocopy JTF_NUMBER_TABLE
81: , p6_a9 out nocopy JTF_NUMBER_TABLE
82: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_300
83: );
76: , p6_a4 out nocopy JTF_NUMBER_TABLE
77: , p6_a5 out nocopy JTF_NUMBER_TABLE
78: , p6_a6 out nocopy JTF_NUMBER_TABLE
79: , p6_a7 out nocopy JTF_NUMBER_TABLE
80: , p6_a8 out nocopy JTF_NUMBER_TABLE
81: , p6_a9 out nocopy JTF_NUMBER_TABLE
82: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_300
83: );
84: procedure update_asset_subsidy(p_api_version NUMBER
77: , p6_a5 out nocopy JTF_NUMBER_TABLE
78: , p6_a6 out nocopy JTF_NUMBER_TABLE
79: , p6_a7 out nocopy JTF_NUMBER_TABLE
80: , p6_a8 out nocopy JTF_NUMBER_TABLE
81: , p6_a9 out nocopy JTF_NUMBER_TABLE
82: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_300
83: );
84: procedure update_asset_subsidy(p_api_version NUMBER
85: , p_init_msg_list VARCHAR2
113: , p_init_msg_list VARCHAR2
114: , x_return_status out nocopy VARCHAR2
115: , x_msg_count out nocopy NUMBER
116: , x_msg_data out nocopy VARCHAR2
117: , p5_a0 JTF_NUMBER_TABLE
118: , p5_a1 JTF_NUMBER_TABLE
119: , p5_a2 JTF_VARCHAR2_TABLE_100
120: , p5_a3 JTF_VARCHAR2_TABLE_200
121: , p5_a4 JTF_NUMBER_TABLE
114: , x_return_status out nocopy VARCHAR2
115: , x_msg_count out nocopy NUMBER
116: , x_msg_data out nocopy VARCHAR2
117: , p5_a0 JTF_NUMBER_TABLE
118: , p5_a1 JTF_NUMBER_TABLE
119: , p5_a2 JTF_VARCHAR2_TABLE_100
120: , p5_a3 JTF_VARCHAR2_TABLE_200
121: , p5_a4 JTF_NUMBER_TABLE
122: , p5_a5 JTF_NUMBER_TABLE
117: , p5_a0 JTF_NUMBER_TABLE
118: , p5_a1 JTF_NUMBER_TABLE
119: , p5_a2 JTF_VARCHAR2_TABLE_100
120: , p5_a3 JTF_VARCHAR2_TABLE_200
121: , p5_a4 JTF_NUMBER_TABLE
122: , p5_a5 JTF_NUMBER_TABLE
123: , p5_a6 JTF_NUMBER_TABLE
124: , p5_a7 JTF_NUMBER_TABLE
125: , p5_a8 JTF_NUMBER_TABLE
118: , p5_a1 JTF_NUMBER_TABLE
119: , p5_a2 JTF_VARCHAR2_TABLE_100
120: , p5_a3 JTF_VARCHAR2_TABLE_200
121: , p5_a4 JTF_NUMBER_TABLE
122: , p5_a5 JTF_NUMBER_TABLE
123: , p5_a6 JTF_NUMBER_TABLE
124: , p5_a7 JTF_NUMBER_TABLE
125: , p5_a8 JTF_NUMBER_TABLE
126: , p5_a9 JTF_NUMBER_TABLE
119: , p5_a2 JTF_VARCHAR2_TABLE_100
120: , p5_a3 JTF_VARCHAR2_TABLE_200
121: , p5_a4 JTF_NUMBER_TABLE
122: , p5_a5 JTF_NUMBER_TABLE
123: , p5_a6 JTF_NUMBER_TABLE
124: , p5_a7 JTF_NUMBER_TABLE
125: , p5_a8 JTF_NUMBER_TABLE
126: , p5_a9 JTF_NUMBER_TABLE
127: , p5_a10 JTF_VARCHAR2_TABLE_300
120: , p5_a3 JTF_VARCHAR2_TABLE_200
121: , p5_a4 JTF_NUMBER_TABLE
122: , p5_a5 JTF_NUMBER_TABLE
123: , p5_a6 JTF_NUMBER_TABLE
124: , p5_a7 JTF_NUMBER_TABLE
125: , p5_a8 JTF_NUMBER_TABLE
126: , p5_a9 JTF_NUMBER_TABLE
127: , p5_a10 JTF_VARCHAR2_TABLE_300
128: , p6_a0 out nocopy JTF_NUMBER_TABLE
121: , p5_a4 JTF_NUMBER_TABLE
122: , p5_a5 JTF_NUMBER_TABLE
123: , p5_a6 JTF_NUMBER_TABLE
124: , p5_a7 JTF_NUMBER_TABLE
125: , p5_a8 JTF_NUMBER_TABLE
126: , p5_a9 JTF_NUMBER_TABLE
127: , p5_a10 JTF_VARCHAR2_TABLE_300
128: , p6_a0 out nocopy JTF_NUMBER_TABLE
129: , p6_a1 out nocopy JTF_NUMBER_TABLE
122: , p5_a5 JTF_NUMBER_TABLE
123: , p5_a6 JTF_NUMBER_TABLE
124: , p5_a7 JTF_NUMBER_TABLE
125: , p5_a8 JTF_NUMBER_TABLE
126: , p5_a9 JTF_NUMBER_TABLE
127: , p5_a10 JTF_VARCHAR2_TABLE_300
128: , p6_a0 out nocopy JTF_NUMBER_TABLE
129: , p6_a1 out nocopy JTF_NUMBER_TABLE
130: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
124: , p5_a7 JTF_NUMBER_TABLE
125: , p5_a8 JTF_NUMBER_TABLE
126: , p5_a9 JTF_NUMBER_TABLE
127: , p5_a10 JTF_VARCHAR2_TABLE_300
128: , p6_a0 out nocopy JTF_NUMBER_TABLE
129: , p6_a1 out nocopy JTF_NUMBER_TABLE
130: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
131: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
132: , p6_a4 out nocopy JTF_NUMBER_TABLE
125: , p5_a8 JTF_NUMBER_TABLE
126: , p5_a9 JTF_NUMBER_TABLE
127: , p5_a10 JTF_VARCHAR2_TABLE_300
128: , p6_a0 out nocopy JTF_NUMBER_TABLE
129: , p6_a1 out nocopy JTF_NUMBER_TABLE
130: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
131: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
132: , p6_a4 out nocopy JTF_NUMBER_TABLE
133: , p6_a5 out nocopy JTF_NUMBER_TABLE
128: , p6_a0 out nocopy JTF_NUMBER_TABLE
129: , p6_a1 out nocopy JTF_NUMBER_TABLE
130: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
131: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
132: , p6_a4 out nocopy JTF_NUMBER_TABLE
133: , p6_a5 out nocopy JTF_NUMBER_TABLE
134: , p6_a6 out nocopy JTF_NUMBER_TABLE
135: , p6_a7 out nocopy JTF_NUMBER_TABLE
136: , p6_a8 out nocopy JTF_NUMBER_TABLE
129: , p6_a1 out nocopy JTF_NUMBER_TABLE
130: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
131: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
132: , p6_a4 out nocopy JTF_NUMBER_TABLE
133: , p6_a5 out nocopy JTF_NUMBER_TABLE
134: , p6_a6 out nocopy JTF_NUMBER_TABLE
135: , p6_a7 out nocopy JTF_NUMBER_TABLE
136: , p6_a8 out nocopy JTF_NUMBER_TABLE
137: , p6_a9 out nocopy JTF_NUMBER_TABLE
130: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
131: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
132: , p6_a4 out nocopy JTF_NUMBER_TABLE
133: , p6_a5 out nocopy JTF_NUMBER_TABLE
134: , p6_a6 out nocopy JTF_NUMBER_TABLE
135: , p6_a7 out nocopy JTF_NUMBER_TABLE
136: , p6_a8 out nocopy JTF_NUMBER_TABLE
137: , p6_a9 out nocopy JTF_NUMBER_TABLE
138: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_300
131: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
132: , p6_a4 out nocopy JTF_NUMBER_TABLE
133: , p6_a5 out nocopy JTF_NUMBER_TABLE
134: , p6_a6 out nocopy JTF_NUMBER_TABLE
135: , p6_a7 out nocopy JTF_NUMBER_TABLE
136: , p6_a8 out nocopy JTF_NUMBER_TABLE
137: , p6_a9 out nocopy JTF_NUMBER_TABLE
138: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_300
139: );
132: , p6_a4 out nocopy JTF_NUMBER_TABLE
133: , p6_a5 out nocopy JTF_NUMBER_TABLE
134: , p6_a6 out nocopy JTF_NUMBER_TABLE
135: , p6_a7 out nocopy JTF_NUMBER_TABLE
136: , p6_a8 out nocopy JTF_NUMBER_TABLE
137: , p6_a9 out nocopy JTF_NUMBER_TABLE
138: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_300
139: );
140: procedure delete_asset_subsidy(p_api_version NUMBER
133: , p6_a5 out nocopy JTF_NUMBER_TABLE
134: , p6_a6 out nocopy JTF_NUMBER_TABLE
135: , p6_a7 out nocopy JTF_NUMBER_TABLE
136: , p6_a8 out nocopy JTF_NUMBER_TABLE
137: , p6_a9 out nocopy JTF_NUMBER_TABLE
138: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_300
139: );
140: procedure delete_asset_subsidy(p_api_version NUMBER
141: , p_init_msg_list VARCHAR2
158: , p_init_msg_list VARCHAR2
159: , x_return_status out nocopy VARCHAR2
160: , x_msg_count out nocopy NUMBER
161: , x_msg_data out nocopy VARCHAR2
162: , p5_a0 JTF_NUMBER_TABLE
163: , p5_a1 JTF_NUMBER_TABLE
164: , p5_a2 JTF_VARCHAR2_TABLE_100
165: , p5_a3 JTF_VARCHAR2_TABLE_200
166: , p5_a4 JTF_NUMBER_TABLE
159: , x_return_status out nocopy VARCHAR2
160: , x_msg_count out nocopy NUMBER
161: , x_msg_data out nocopy VARCHAR2
162: , p5_a0 JTF_NUMBER_TABLE
163: , p5_a1 JTF_NUMBER_TABLE
164: , p5_a2 JTF_VARCHAR2_TABLE_100
165: , p5_a3 JTF_VARCHAR2_TABLE_200
166: , p5_a4 JTF_NUMBER_TABLE
167: , p5_a5 JTF_NUMBER_TABLE
162: , p5_a0 JTF_NUMBER_TABLE
163: , p5_a1 JTF_NUMBER_TABLE
164: , p5_a2 JTF_VARCHAR2_TABLE_100
165: , p5_a3 JTF_VARCHAR2_TABLE_200
166: , p5_a4 JTF_NUMBER_TABLE
167: , p5_a5 JTF_NUMBER_TABLE
168: , p5_a6 JTF_NUMBER_TABLE
169: , p5_a7 JTF_NUMBER_TABLE
170: , p5_a8 JTF_NUMBER_TABLE
163: , p5_a1 JTF_NUMBER_TABLE
164: , p5_a2 JTF_VARCHAR2_TABLE_100
165: , p5_a3 JTF_VARCHAR2_TABLE_200
166: , p5_a4 JTF_NUMBER_TABLE
167: , p5_a5 JTF_NUMBER_TABLE
168: , p5_a6 JTF_NUMBER_TABLE
169: , p5_a7 JTF_NUMBER_TABLE
170: , p5_a8 JTF_NUMBER_TABLE
171: , p5_a9 JTF_NUMBER_TABLE
164: , p5_a2 JTF_VARCHAR2_TABLE_100
165: , p5_a3 JTF_VARCHAR2_TABLE_200
166: , p5_a4 JTF_NUMBER_TABLE
167: , p5_a5 JTF_NUMBER_TABLE
168: , p5_a6 JTF_NUMBER_TABLE
169: , p5_a7 JTF_NUMBER_TABLE
170: , p5_a8 JTF_NUMBER_TABLE
171: , p5_a9 JTF_NUMBER_TABLE
172: , p5_a10 JTF_VARCHAR2_TABLE_300
165: , p5_a3 JTF_VARCHAR2_TABLE_200
166: , p5_a4 JTF_NUMBER_TABLE
167: , p5_a5 JTF_NUMBER_TABLE
168: , p5_a6 JTF_NUMBER_TABLE
169: , p5_a7 JTF_NUMBER_TABLE
170: , p5_a8 JTF_NUMBER_TABLE
171: , p5_a9 JTF_NUMBER_TABLE
172: , p5_a10 JTF_VARCHAR2_TABLE_300
173: );
166: , p5_a4 JTF_NUMBER_TABLE
167: , p5_a5 JTF_NUMBER_TABLE
168: , p5_a6 JTF_NUMBER_TABLE
169: , p5_a7 JTF_NUMBER_TABLE
170: , p5_a8 JTF_NUMBER_TABLE
171: , p5_a9 JTF_NUMBER_TABLE
172: , p5_a10 JTF_VARCHAR2_TABLE_300
173: );
174: procedure validate_asset_subsidy(p_api_version NUMBER
167: , p5_a5 JTF_NUMBER_TABLE
168: , p5_a6 JTF_NUMBER_TABLE
169: , p5_a7 JTF_NUMBER_TABLE
170: , p5_a8 JTF_NUMBER_TABLE
171: , p5_a9 JTF_NUMBER_TABLE
172: , p5_a10 JTF_VARCHAR2_TABLE_300
173: );
174: procedure validate_asset_subsidy(p_api_version NUMBER
175: , p_init_msg_list VARCHAR2
192: , p_init_msg_list VARCHAR2
193: , x_return_status out nocopy VARCHAR2
194: , x_msg_count out nocopy NUMBER
195: , x_msg_data out nocopy VARCHAR2
196: , p5_a0 JTF_NUMBER_TABLE
197: , p5_a1 JTF_NUMBER_TABLE
198: , p5_a2 JTF_VARCHAR2_TABLE_100
199: , p5_a3 JTF_VARCHAR2_TABLE_200
200: , p5_a4 JTF_NUMBER_TABLE
193: , x_return_status out nocopy VARCHAR2
194: , x_msg_count out nocopy NUMBER
195: , x_msg_data out nocopy VARCHAR2
196: , p5_a0 JTF_NUMBER_TABLE
197: , p5_a1 JTF_NUMBER_TABLE
198: , p5_a2 JTF_VARCHAR2_TABLE_100
199: , p5_a3 JTF_VARCHAR2_TABLE_200
200: , p5_a4 JTF_NUMBER_TABLE
201: , p5_a5 JTF_NUMBER_TABLE
196: , p5_a0 JTF_NUMBER_TABLE
197: , p5_a1 JTF_NUMBER_TABLE
198: , p5_a2 JTF_VARCHAR2_TABLE_100
199: , p5_a3 JTF_VARCHAR2_TABLE_200
200: , p5_a4 JTF_NUMBER_TABLE
201: , p5_a5 JTF_NUMBER_TABLE
202: , p5_a6 JTF_NUMBER_TABLE
203: , p5_a7 JTF_NUMBER_TABLE
204: , p5_a8 JTF_NUMBER_TABLE
197: , p5_a1 JTF_NUMBER_TABLE
198: , p5_a2 JTF_VARCHAR2_TABLE_100
199: , p5_a3 JTF_VARCHAR2_TABLE_200
200: , p5_a4 JTF_NUMBER_TABLE
201: , p5_a5 JTF_NUMBER_TABLE
202: , p5_a6 JTF_NUMBER_TABLE
203: , p5_a7 JTF_NUMBER_TABLE
204: , p5_a8 JTF_NUMBER_TABLE
205: , p5_a9 JTF_NUMBER_TABLE
198: , p5_a2 JTF_VARCHAR2_TABLE_100
199: , p5_a3 JTF_VARCHAR2_TABLE_200
200: , p5_a4 JTF_NUMBER_TABLE
201: , p5_a5 JTF_NUMBER_TABLE
202: , p5_a6 JTF_NUMBER_TABLE
203: , p5_a7 JTF_NUMBER_TABLE
204: , p5_a8 JTF_NUMBER_TABLE
205: , p5_a9 JTF_NUMBER_TABLE
206: , p5_a10 JTF_VARCHAR2_TABLE_300
199: , p5_a3 JTF_VARCHAR2_TABLE_200
200: , p5_a4 JTF_NUMBER_TABLE
201: , p5_a5 JTF_NUMBER_TABLE
202: , p5_a6 JTF_NUMBER_TABLE
203: , p5_a7 JTF_NUMBER_TABLE
204: , p5_a8 JTF_NUMBER_TABLE
205: , p5_a9 JTF_NUMBER_TABLE
206: , p5_a10 JTF_VARCHAR2_TABLE_300
207: );
200: , p5_a4 JTF_NUMBER_TABLE
201: , p5_a5 JTF_NUMBER_TABLE
202: , p5_a6 JTF_NUMBER_TABLE
203: , p5_a7 JTF_NUMBER_TABLE
204: , p5_a8 JTF_NUMBER_TABLE
205: , p5_a9 JTF_NUMBER_TABLE
206: , p5_a10 JTF_VARCHAR2_TABLE_300
207: );
208: procedure calculate_asset_subsidy(p_api_version NUMBER
201: , p5_a5 JTF_NUMBER_TABLE
202: , p5_a6 JTF_NUMBER_TABLE
203: , p5_a7 JTF_NUMBER_TABLE
204: , p5_a8 JTF_NUMBER_TABLE
205: , p5_a9 JTF_NUMBER_TABLE
206: , p5_a10 JTF_VARCHAR2_TABLE_300
207: );
208: procedure calculate_asset_subsidy(p_api_version NUMBER
209: , p_init_msg_list VARCHAR2
237: , p_init_msg_list VARCHAR2
238: , x_return_status out nocopy VARCHAR2
239: , x_msg_count out nocopy NUMBER
240: , x_msg_data out nocopy VARCHAR2
241: , p5_a0 JTF_NUMBER_TABLE
242: , p5_a1 JTF_NUMBER_TABLE
243: , p5_a2 JTF_VARCHAR2_TABLE_100
244: , p5_a3 JTF_VARCHAR2_TABLE_200
245: , p5_a4 JTF_NUMBER_TABLE
238: , x_return_status out nocopy VARCHAR2
239: , x_msg_count out nocopy NUMBER
240: , x_msg_data out nocopy VARCHAR2
241: , p5_a0 JTF_NUMBER_TABLE
242: , p5_a1 JTF_NUMBER_TABLE
243: , p5_a2 JTF_VARCHAR2_TABLE_100
244: , p5_a3 JTF_VARCHAR2_TABLE_200
245: , p5_a4 JTF_NUMBER_TABLE
246: , p5_a5 JTF_NUMBER_TABLE
241: , p5_a0 JTF_NUMBER_TABLE
242: , p5_a1 JTF_NUMBER_TABLE
243: , p5_a2 JTF_VARCHAR2_TABLE_100
244: , p5_a3 JTF_VARCHAR2_TABLE_200
245: , p5_a4 JTF_NUMBER_TABLE
246: , p5_a5 JTF_NUMBER_TABLE
247: , p5_a6 JTF_NUMBER_TABLE
248: , p5_a7 JTF_NUMBER_TABLE
249: , p5_a8 JTF_NUMBER_TABLE
242: , p5_a1 JTF_NUMBER_TABLE
243: , p5_a2 JTF_VARCHAR2_TABLE_100
244: , p5_a3 JTF_VARCHAR2_TABLE_200
245: , p5_a4 JTF_NUMBER_TABLE
246: , p5_a5 JTF_NUMBER_TABLE
247: , p5_a6 JTF_NUMBER_TABLE
248: , p5_a7 JTF_NUMBER_TABLE
249: , p5_a8 JTF_NUMBER_TABLE
250: , p5_a9 JTF_NUMBER_TABLE
243: , p5_a2 JTF_VARCHAR2_TABLE_100
244: , p5_a3 JTF_VARCHAR2_TABLE_200
245: , p5_a4 JTF_NUMBER_TABLE
246: , p5_a5 JTF_NUMBER_TABLE
247: , p5_a6 JTF_NUMBER_TABLE
248: , p5_a7 JTF_NUMBER_TABLE
249: , p5_a8 JTF_NUMBER_TABLE
250: , p5_a9 JTF_NUMBER_TABLE
251: , p5_a10 JTF_VARCHAR2_TABLE_300
244: , p5_a3 JTF_VARCHAR2_TABLE_200
245: , p5_a4 JTF_NUMBER_TABLE
246: , p5_a5 JTF_NUMBER_TABLE
247: , p5_a6 JTF_NUMBER_TABLE
248: , p5_a7 JTF_NUMBER_TABLE
249: , p5_a8 JTF_NUMBER_TABLE
250: , p5_a9 JTF_NUMBER_TABLE
251: , p5_a10 JTF_VARCHAR2_TABLE_300
252: , p6_a0 out nocopy JTF_NUMBER_TABLE
245: , p5_a4 JTF_NUMBER_TABLE
246: , p5_a5 JTF_NUMBER_TABLE
247: , p5_a6 JTF_NUMBER_TABLE
248: , p5_a7 JTF_NUMBER_TABLE
249: , p5_a8 JTF_NUMBER_TABLE
250: , p5_a9 JTF_NUMBER_TABLE
251: , p5_a10 JTF_VARCHAR2_TABLE_300
252: , p6_a0 out nocopy JTF_NUMBER_TABLE
253: , p6_a1 out nocopy JTF_NUMBER_TABLE
246: , p5_a5 JTF_NUMBER_TABLE
247: , p5_a6 JTF_NUMBER_TABLE
248: , p5_a7 JTF_NUMBER_TABLE
249: , p5_a8 JTF_NUMBER_TABLE
250: , p5_a9 JTF_NUMBER_TABLE
251: , p5_a10 JTF_VARCHAR2_TABLE_300
252: , p6_a0 out nocopy JTF_NUMBER_TABLE
253: , p6_a1 out nocopy JTF_NUMBER_TABLE
254: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
248: , p5_a7 JTF_NUMBER_TABLE
249: , p5_a8 JTF_NUMBER_TABLE
250: , p5_a9 JTF_NUMBER_TABLE
251: , p5_a10 JTF_VARCHAR2_TABLE_300
252: , p6_a0 out nocopy JTF_NUMBER_TABLE
253: , p6_a1 out nocopy JTF_NUMBER_TABLE
254: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
255: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
256: , p6_a4 out nocopy JTF_NUMBER_TABLE
249: , p5_a8 JTF_NUMBER_TABLE
250: , p5_a9 JTF_NUMBER_TABLE
251: , p5_a10 JTF_VARCHAR2_TABLE_300
252: , p6_a0 out nocopy JTF_NUMBER_TABLE
253: , p6_a1 out nocopy JTF_NUMBER_TABLE
254: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
255: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
256: , p6_a4 out nocopy JTF_NUMBER_TABLE
257: , p6_a5 out nocopy JTF_NUMBER_TABLE
252: , p6_a0 out nocopy JTF_NUMBER_TABLE
253: , p6_a1 out nocopy JTF_NUMBER_TABLE
254: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
255: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
256: , p6_a4 out nocopy JTF_NUMBER_TABLE
257: , p6_a5 out nocopy JTF_NUMBER_TABLE
258: , p6_a6 out nocopy JTF_NUMBER_TABLE
259: , p6_a7 out nocopy JTF_NUMBER_TABLE
260: , p6_a8 out nocopy JTF_NUMBER_TABLE
253: , p6_a1 out nocopy JTF_NUMBER_TABLE
254: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
255: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
256: , p6_a4 out nocopy JTF_NUMBER_TABLE
257: , p6_a5 out nocopy JTF_NUMBER_TABLE
258: , p6_a6 out nocopy JTF_NUMBER_TABLE
259: , p6_a7 out nocopy JTF_NUMBER_TABLE
260: , p6_a8 out nocopy JTF_NUMBER_TABLE
261: , p6_a9 out nocopy JTF_NUMBER_TABLE
254: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
255: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
256: , p6_a4 out nocopy JTF_NUMBER_TABLE
257: , p6_a5 out nocopy JTF_NUMBER_TABLE
258: , p6_a6 out nocopy JTF_NUMBER_TABLE
259: , p6_a7 out nocopy JTF_NUMBER_TABLE
260: , p6_a8 out nocopy JTF_NUMBER_TABLE
261: , p6_a9 out nocopy JTF_NUMBER_TABLE
262: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_300
255: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
256: , p6_a4 out nocopy JTF_NUMBER_TABLE
257: , p6_a5 out nocopy JTF_NUMBER_TABLE
258: , p6_a6 out nocopy JTF_NUMBER_TABLE
259: , p6_a7 out nocopy JTF_NUMBER_TABLE
260: , p6_a8 out nocopy JTF_NUMBER_TABLE
261: , p6_a9 out nocopy JTF_NUMBER_TABLE
262: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_300
263: );
256: , p6_a4 out nocopy JTF_NUMBER_TABLE
257: , p6_a5 out nocopy JTF_NUMBER_TABLE
258: , p6_a6 out nocopy JTF_NUMBER_TABLE
259: , p6_a7 out nocopy JTF_NUMBER_TABLE
260: , p6_a8 out nocopy JTF_NUMBER_TABLE
261: , p6_a9 out nocopy JTF_NUMBER_TABLE
262: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_300
263: );
264: end okl_asset_subsidy_pvt_w;
257: , p6_a5 out nocopy JTF_NUMBER_TABLE
258: , p6_a6 out nocopy JTF_NUMBER_TABLE
259: , p6_a7 out nocopy JTF_NUMBER_TABLE
260: , p6_a8 out nocopy JTF_NUMBER_TABLE
261: , p6_a9 out nocopy JTF_NUMBER_TABLE
262: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_300
263: );
264: end okl_asset_subsidy_pvt_w;