[Home] [Help]
PACKAGE: APPS.OKL_ASSET_SUBSIDY_PVT_W
Source
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
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
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
26 );
27
28 procedure create_asset_subsidy(p_api_version NUMBER
29 , p_init_msg_list VARCHAR2
30 , x_return_status out nocopy VARCHAR2
31 , x_msg_count out nocopy NUMBER
32 , x_msg_data out nocopy VARCHAR2
33 , p6_a0 out nocopy NUMBER
34 , p6_a1 out nocopy NUMBER
35 , p6_a2 out nocopy VARCHAR2
36 , p6_a3 out nocopy VARCHAR2
37 , p6_a4 out nocopy NUMBER
38 , p6_a5 out nocopy NUMBER
39 , p6_a6 out nocopy NUMBER
40 , p6_a7 out nocopy NUMBER
41 , p6_a8 out nocopy NUMBER
42 , p6_a9 out nocopy NUMBER
43 , p6_a10 out nocopy VARCHAR2
44 , p5_a0 NUMBER := 0-1962.0724
45 , p5_a1 NUMBER := 0-1962.0724
46 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
47 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
48 , p5_a4 NUMBER := 0-1962.0724
49 , p5_a5 NUMBER := 0-1962.0724
50 , p5_a6 NUMBER := 0-1962.0724
51 , p5_a7 NUMBER := 0-1962.0724
52 , p5_a8 NUMBER := 0-1962.0724
53 , p5_a9 NUMBER := 0-1962.0724
54 , p5_a10 VARCHAR2 := fnd_api.g_miss_char
55 );
56 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
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
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 );
84 procedure update_asset_subsidy(p_api_version NUMBER
85 , p_init_msg_list VARCHAR2
86 , x_return_status out nocopy VARCHAR2
87 , x_msg_count out nocopy NUMBER
88 , x_msg_data out nocopy VARCHAR2
89 , p6_a0 out nocopy NUMBER
90 , p6_a1 out nocopy NUMBER
91 , p6_a2 out nocopy VARCHAR2
92 , p6_a3 out nocopy VARCHAR2
93 , p6_a4 out nocopy NUMBER
94 , p6_a5 out nocopy NUMBER
95 , p6_a6 out nocopy NUMBER
96 , p6_a7 out nocopy NUMBER
97 , p6_a8 out nocopy NUMBER
98 , p6_a9 out nocopy NUMBER
99 , p6_a10 out nocopy VARCHAR2
100 , p5_a0 NUMBER := 0-1962.0724
101 , p5_a1 NUMBER := 0-1962.0724
102 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
103 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
104 , p5_a4 NUMBER := 0-1962.0724
105 , p5_a5 NUMBER := 0-1962.0724
106 , p5_a6 NUMBER := 0-1962.0724
107 , p5_a7 NUMBER := 0-1962.0724
108 , p5_a8 NUMBER := 0-1962.0724
109 , p5_a9 NUMBER := 0-1962.0724
110 , p5_a10 VARCHAR2 := fnd_api.g_miss_char
111 );
112 procedure update_asset_subsidy(p_api_version NUMBER
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
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
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 );
140 procedure delete_asset_subsidy(p_api_version NUMBER
141 , p_init_msg_list VARCHAR2
142 , x_return_status out nocopy VARCHAR2
143 , x_msg_count out nocopy NUMBER
144 , x_msg_data out nocopy VARCHAR2
145 , p5_a0 NUMBER := 0-1962.0724
146 , p5_a1 NUMBER := 0-1962.0724
147 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
148 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
149 , p5_a4 NUMBER := 0-1962.0724
150 , p5_a5 NUMBER := 0-1962.0724
151 , p5_a6 NUMBER := 0-1962.0724
152 , p5_a7 NUMBER := 0-1962.0724
153 , p5_a8 NUMBER := 0-1962.0724
154 , p5_a9 NUMBER := 0-1962.0724
155 , p5_a10 VARCHAR2 := fnd_api.g_miss_char
156 );
157 procedure delete_asset_subsidy(p_api_version NUMBER
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
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
176 , x_return_status out nocopy VARCHAR2
177 , x_msg_count out nocopy NUMBER
178 , x_msg_data out nocopy VARCHAR2
179 , p5_a0 NUMBER := 0-1962.0724
180 , p5_a1 NUMBER := 0-1962.0724
181 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
182 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
183 , p5_a4 NUMBER := 0-1962.0724
184 , p5_a5 NUMBER := 0-1962.0724
185 , p5_a6 NUMBER := 0-1962.0724
186 , p5_a7 NUMBER := 0-1962.0724
187 , p5_a8 NUMBER := 0-1962.0724
188 , p5_a9 NUMBER := 0-1962.0724
189 , p5_a10 VARCHAR2 := fnd_api.g_miss_char
190 );
191 procedure validate_asset_subsidy(p_api_version NUMBER
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
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
210 , x_return_status out nocopy VARCHAR2
211 , x_msg_count out nocopy NUMBER
212 , x_msg_data out nocopy VARCHAR2
213 , p6_a0 out nocopy NUMBER
214 , p6_a1 out nocopy NUMBER
215 , p6_a2 out nocopy VARCHAR2
216 , p6_a3 out nocopy VARCHAR2
217 , p6_a4 out nocopy NUMBER
218 , p6_a5 out nocopy NUMBER
219 , p6_a6 out nocopy NUMBER
220 , p6_a7 out nocopy NUMBER
221 , p6_a8 out nocopy NUMBER
222 , p6_a9 out nocopy NUMBER
223 , p6_a10 out nocopy VARCHAR2
224 , p5_a0 NUMBER := 0-1962.0724
225 , p5_a1 NUMBER := 0-1962.0724
226 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
227 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
228 , p5_a4 NUMBER := 0-1962.0724
229 , p5_a5 NUMBER := 0-1962.0724
230 , p5_a6 NUMBER := 0-1962.0724
231 , p5_a7 NUMBER := 0-1962.0724
232 , p5_a8 NUMBER := 0-1962.0724
233 , p5_a9 NUMBER := 0-1962.0724
234 , p5_a10 VARCHAR2 := fnd_api.g_miss_char
235 );
236 procedure calculate_asset_subsidy(p_api_version NUMBER
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
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
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 );
264 end okl_asset_subsidy_pvt_w;