[Home] [Help]
PACKAGE: APPS.OKL_ACCRUAL_RULES_PUB_W
Source
1 package okl_accrual_rules_pub_w AUTHID CURRENT_USER as
2 /* $Header: OKLUAGNS.pls 120.1 2005/07/07 13:32:09 dkagrawa noship $ */
3 procedure insert_accrual_rules(p_api_version NUMBER
4 , p_init_msg_list VARCHAR2
5 , x_return_status out nocopy VARCHAR2
6 , x_msg_count out nocopy NUMBER
7 , x_msg_data out nocopy VARCHAR2
8 , p6_a0 out nocopy NUMBER
9 , p6_a1 out nocopy NUMBER
10 , p6_a2 out nocopy VARCHAR2
11 , p6_a3 out nocopy VARCHAR2
12 , p6_a4 out nocopy VARCHAR2
13 , p6_a5 out nocopy NUMBER
14 , p6_a6 out nocopy VARCHAR2
15 , p6_a7 out nocopy VARCHAR2
16 , p6_a8 out nocopy VARCHAR2
17 , p6_a9 out nocopy VARCHAR2
18 , p6_a10 out nocopy DATE
19 , p6_a11 out nocopy DATE
20 , p6_a12 out nocopy NUMBER
21 , p6_a13 out nocopy NUMBER
22 , p6_a14 out nocopy DATE
23 , p6_a15 out nocopy NUMBER
24 , p6_a16 out nocopy DATE
25 , p6_a17 out nocopy NUMBER
26 , p5_a0 NUMBER := 0-1962.0724
27 , p5_a1 NUMBER := 0-1962.0724
28 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
29 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
30 , p5_a4 VARCHAR2 := fnd_api.g_miss_char
31 , p5_a5 NUMBER := 0-1962.0724
32 , p5_a6 VARCHAR2 := fnd_api.g_miss_char
33 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
34 , p5_a8 VARCHAR2 := fnd_api.g_miss_char
35 , p5_a9 VARCHAR2 := fnd_api.g_miss_char
36 , p5_a10 DATE := fnd_api.g_miss_date
37 , p5_a11 DATE := fnd_api.g_miss_date
38 , p5_a12 NUMBER := 0-1962.0724
39 , p5_a13 NUMBER := 0-1962.0724
40 , p5_a14 DATE := fnd_api.g_miss_date
41 , p5_a15 NUMBER := 0-1962.0724
42 , p5_a16 DATE := fnd_api.g_miss_date
43 , p5_a17 NUMBER := 0-1962.0724
44 );
45 procedure insert_accrual_rules(p_api_version NUMBER
46 , p_init_msg_list VARCHAR2
47 , x_return_status out nocopy VARCHAR2
48 , x_msg_count out nocopy NUMBER
49 , x_msg_data out nocopy VARCHAR2
50 , p5_a0 JTF_NUMBER_TABLE
51 , p5_a1 JTF_NUMBER_TABLE
52 , p5_a2 JTF_VARCHAR2_TABLE_100
53 , p5_a3 JTF_VARCHAR2_TABLE_100
54 , p5_a4 JTF_VARCHAR2_TABLE_100
55 , p5_a5 JTF_NUMBER_TABLE
56 , p5_a6 JTF_VARCHAR2_TABLE_100
57 , p5_a7 JTF_VARCHAR2_TABLE_100
58 , p5_a8 JTF_VARCHAR2_TABLE_100
59 , p5_a9 JTF_VARCHAR2_TABLE_100
60 , p5_a10 JTF_DATE_TABLE
61 , p5_a11 JTF_DATE_TABLE
62 , p5_a12 JTF_NUMBER_TABLE
63 , p5_a13 JTF_NUMBER_TABLE
64 , p5_a14 JTF_DATE_TABLE
65 , p5_a15 JTF_NUMBER_TABLE
66 , p5_a16 JTF_DATE_TABLE
67 , p5_a17 JTF_NUMBER_TABLE
68 , p6_a0 out nocopy JTF_NUMBER_TABLE
69 , p6_a1 out nocopy JTF_NUMBER_TABLE
70 , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
71 , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
72 , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
73 , p6_a5 out nocopy JTF_NUMBER_TABLE
74 , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
75 , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
76 , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
77 , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
78 , p6_a10 out nocopy JTF_DATE_TABLE
79 , p6_a11 out nocopy JTF_DATE_TABLE
80 , p6_a12 out nocopy JTF_NUMBER_TABLE
81 , p6_a13 out nocopy JTF_NUMBER_TABLE
82 , p6_a14 out nocopy JTF_DATE_TABLE
83 , p6_a15 out nocopy JTF_NUMBER_TABLE
84 , p6_a16 out nocopy JTF_DATE_TABLE
85 , p6_a17 out nocopy JTF_NUMBER_TABLE
86 );
87 procedure lock_accrual_rules(p_api_version NUMBER
88 , p_init_msg_list VARCHAR2
89 , x_return_status out nocopy VARCHAR2
90 , x_msg_count out nocopy NUMBER
91 , x_msg_data out nocopy VARCHAR2
92 , p5_a0 NUMBER := 0-1962.0724
93 , p5_a1 NUMBER := 0-1962.0724
94 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
95 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
96 , p5_a4 VARCHAR2 := fnd_api.g_miss_char
97 , p5_a5 NUMBER := 0-1962.0724
98 , p5_a6 VARCHAR2 := fnd_api.g_miss_char
99 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
100 , p5_a8 VARCHAR2 := fnd_api.g_miss_char
101 , p5_a9 VARCHAR2 := fnd_api.g_miss_char
102 , p5_a10 DATE := fnd_api.g_miss_date
103 , p5_a11 DATE := fnd_api.g_miss_date
104 , p5_a12 NUMBER := 0-1962.0724
105 , p5_a13 NUMBER := 0-1962.0724
106 , p5_a14 DATE := fnd_api.g_miss_date
107 , p5_a15 NUMBER := 0-1962.0724
108 , p5_a16 DATE := fnd_api.g_miss_date
109 , p5_a17 NUMBER := 0-1962.0724
110 );
111 procedure lock_accrual_rules(p_api_version NUMBER
112 , p_init_msg_list VARCHAR2
113 , x_return_status out nocopy VARCHAR2
114 , x_msg_count out nocopy NUMBER
115 , x_msg_data out nocopy VARCHAR2
116 , p5_a0 JTF_NUMBER_TABLE
117 , p5_a1 JTF_NUMBER_TABLE
118 , p5_a2 JTF_VARCHAR2_TABLE_100
119 , p5_a3 JTF_VARCHAR2_TABLE_100
120 , p5_a4 JTF_VARCHAR2_TABLE_100
121 , p5_a5 JTF_NUMBER_TABLE
122 , p5_a6 JTF_VARCHAR2_TABLE_100
123 , p5_a7 JTF_VARCHAR2_TABLE_100
124 , p5_a8 JTF_VARCHAR2_TABLE_100
125 , p5_a9 JTF_VARCHAR2_TABLE_100
126 , p5_a10 JTF_DATE_TABLE
127 , p5_a11 JTF_DATE_TABLE
128 , p5_a12 JTF_NUMBER_TABLE
129 , p5_a13 JTF_NUMBER_TABLE
130 , p5_a14 JTF_DATE_TABLE
131 , p5_a15 JTF_NUMBER_TABLE
132 , p5_a16 JTF_DATE_TABLE
133 , p5_a17 JTF_NUMBER_TABLE
134 );
135 procedure update_accrual_rules(p_api_version NUMBER
136 , p_init_msg_list VARCHAR2
137 , x_return_status out nocopy VARCHAR2
138 , x_msg_count out nocopy NUMBER
139 , x_msg_data out nocopy VARCHAR2
140 , p6_a0 out nocopy NUMBER
141 , p6_a1 out nocopy NUMBER
142 , p6_a2 out nocopy VARCHAR2
143 , p6_a3 out nocopy VARCHAR2
144 , p6_a4 out nocopy VARCHAR2
145 , p6_a5 out nocopy NUMBER
146 , p6_a6 out nocopy VARCHAR2
147 , p6_a7 out nocopy VARCHAR2
148 , p6_a8 out nocopy VARCHAR2
149 , p6_a9 out nocopy VARCHAR2
150 , p6_a10 out nocopy DATE
151 , p6_a11 out nocopy DATE
152 , p6_a12 out nocopy NUMBER
153 , p6_a13 out nocopy NUMBER
154 , p6_a14 out nocopy DATE
155 , p6_a15 out nocopy NUMBER
156 , p6_a16 out nocopy DATE
157 , p6_a17 out nocopy NUMBER
158 , p5_a0 NUMBER := 0-1962.0724
159 , p5_a1 NUMBER := 0-1962.0724
160 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
161 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
162 , p5_a4 VARCHAR2 := fnd_api.g_miss_char
163 , p5_a5 NUMBER := 0-1962.0724
164 , p5_a6 VARCHAR2 := fnd_api.g_miss_char
165 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
166 , p5_a8 VARCHAR2 := fnd_api.g_miss_char
167 , p5_a9 VARCHAR2 := fnd_api.g_miss_char
168 , p5_a10 DATE := fnd_api.g_miss_date
169 , p5_a11 DATE := fnd_api.g_miss_date
170 , p5_a12 NUMBER := 0-1962.0724
171 , p5_a13 NUMBER := 0-1962.0724
172 , p5_a14 DATE := fnd_api.g_miss_date
173 , p5_a15 NUMBER := 0-1962.0724
174 , p5_a16 DATE := fnd_api.g_miss_date
175 , p5_a17 NUMBER := 0-1962.0724
176 );
177 procedure update_accrual_rules(p_api_version NUMBER
178 , p_init_msg_list VARCHAR2
179 , x_return_status out nocopy VARCHAR2
180 , x_msg_count out nocopy NUMBER
181 , x_msg_data out nocopy VARCHAR2
182 , p5_a0 JTF_NUMBER_TABLE
183 , p5_a1 JTF_NUMBER_TABLE
184 , p5_a2 JTF_VARCHAR2_TABLE_100
185 , p5_a3 JTF_VARCHAR2_TABLE_100
186 , p5_a4 JTF_VARCHAR2_TABLE_100
187 , p5_a5 JTF_NUMBER_TABLE
188 , p5_a6 JTF_VARCHAR2_TABLE_100
189 , p5_a7 JTF_VARCHAR2_TABLE_100
190 , p5_a8 JTF_VARCHAR2_TABLE_100
191 , p5_a9 JTF_VARCHAR2_TABLE_100
192 , p5_a10 JTF_DATE_TABLE
193 , p5_a11 JTF_DATE_TABLE
194 , p5_a12 JTF_NUMBER_TABLE
195 , p5_a13 JTF_NUMBER_TABLE
196 , p5_a14 JTF_DATE_TABLE
197 , p5_a15 JTF_NUMBER_TABLE
198 , p5_a16 JTF_DATE_TABLE
199 , p5_a17 JTF_NUMBER_TABLE
200 , p6_a0 out nocopy JTF_NUMBER_TABLE
201 , p6_a1 out nocopy JTF_NUMBER_TABLE
202 , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
203 , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
204 , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
205 , p6_a5 out nocopy JTF_NUMBER_TABLE
206 , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
207 , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
208 , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
209 , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
210 , p6_a10 out nocopy JTF_DATE_TABLE
211 , p6_a11 out nocopy JTF_DATE_TABLE
212 , p6_a12 out nocopy JTF_NUMBER_TABLE
213 , p6_a13 out nocopy JTF_NUMBER_TABLE
214 , p6_a14 out nocopy JTF_DATE_TABLE
215 , p6_a15 out nocopy JTF_NUMBER_TABLE
216 , p6_a16 out nocopy JTF_DATE_TABLE
217 , p6_a17 out nocopy JTF_NUMBER_TABLE
218 );
219 procedure delete_accrual_rules(p_api_version NUMBER
220 , p_init_msg_list VARCHAR2
221 , x_return_status out nocopy VARCHAR2
222 , x_msg_count out nocopy NUMBER
223 , x_msg_data 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 VARCHAR2 := fnd_api.g_miss_char
229 , p5_a5 NUMBER := 0-1962.0724
230 , p5_a6 VARCHAR2 := fnd_api.g_miss_char
231 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
232 , p5_a8 VARCHAR2 := fnd_api.g_miss_char
233 , p5_a9 VARCHAR2 := fnd_api.g_miss_char
234 , p5_a10 DATE := fnd_api.g_miss_date
235 , p5_a11 DATE := fnd_api.g_miss_date
236 , p5_a12 NUMBER := 0-1962.0724
237 , p5_a13 NUMBER := 0-1962.0724
238 , p5_a14 DATE := fnd_api.g_miss_date
239 , p5_a15 NUMBER := 0-1962.0724
240 , p5_a16 DATE := fnd_api.g_miss_date
241 , p5_a17 NUMBER := 0-1962.0724
242 );
243 procedure delete_accrual_rules(p_api_version NUMBER
244 , p_init_msg_list VARCHAR2
245 , x_return_status out nocopy VARCHAR2
246 , x_msg_count out nocopy NUMBER
247 , x_msg_data out nocopy VARCHAR2
248 , p5_a0 JTF_NUMBER_TABLE
249 , p5_a1 JTF_NUMBER_TABLE
250 , p5_a2 JTF_VARCHAR2_TABLE_100
251 , p5_a3 JTF_VARCHAR2_TABLE_100
252 , p5_a4 JTF_VARCHAR2_TABLE_100
253 , p5_a5 JTF_NUMBER_TABLE
254 , p5_a6 JTF_VARCHAR2_TABLE_100
255 , p5_a7 JTF_VARCHAR2_TABLE_100
256 , p5_a8 JTF_VARCHAR2_TABLE_100
257 , p5_a9 JTF_VARCHAR2_TABLE_100
258 , p5_a10 JTF_DATE_TABLE
259 , p5_a11 JTF_DATE_TABLE
260 , p5_a12 JTF_NUMBER_TABLE
261 , p5_a13 JTF_NUMBER_TABLE
262 , p5_a14 JTF_DATE_TABLE
263 , p5_a15 JTF_NUMBER_TABLE
264 , p5_a16 JTF_DATE_TABLE
265 , p5_a17 JTF_NUMBER_TABLE
266 );
267 procedure validate_accrual_rules(p_api_version NUMBER
268 , p_init_msg_list VARCHAR2
269 , x_return_status out nocopy VARCHAR2
270 , x_msg_count out nocopy NUMBER
271 , x_msg_data out nocopy VARCHAR2
272 , p5_a0 NUMBER := 0-1962.0724
273 , p5_a1 NUMBER := 0-1962.0724
274 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
275 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
276 , p5_a4 VARCHAR2 := fnd_api.g_miss_char
277 , p5_a5 NUMBER := 0-1962.0724
278 , p5_a6 VARCHAR2 := fnd_api.g_miss_char
279 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
280 , p5_a8 VARCHAR2 := fnd_api.g_miss_char
281 , p5_a9 VARCHAR2 := fnd_api.g_miss_char
282 , p5_a10 DATE := fnd_api.g_miss_date
283 , p5_a11 DATE := fnd_api.g_miss_date
284 , p5_a12 NUMBER := 0-1962.0724
285 , p5_a13 NUMBER := 0-1962.0724
286 , p5_a14 DATE := fnd_api.g_miss_date
287 , p5_a15 NUMBER := 0-1962.0724
288 , p5_a16 DATE := fnd_api.g_miss_date
289 , p5_a17 NUMBER := 0-1962.0724
290 );
291 procedure validate_accrual_rules(p_api_version NUMBER
292 , p_init_msg_list VARCHAR2
293 , x_return_status out nocopy VARCHAR2
294 , x_msg_count out nocopy NUMBER
295 , x_msg_data out nocopy VARCHAR2
296 , p5_a0 JTF_NUMBER_TABLE
297 , p5_a1 JTF_NUMBER_TABLE
298 , p5_a2 JTF_VARCHAR2_TABLE_100
299 , p5_a3 JTF_VARCHAR2_TABLE_100
300 , p5_a4 JTF_VARCHAR2_TABLE_100
301 , p5_a5 JTF_NUMBER_TABLE
302 , p5_a6 JTF_VARCHAR2_TABLE_100
303 , p5_a7 JTF_VARCHAR2_TABLE_100
304 , p5_a8 JTF_VARCHAR2_TABLE_100
305 , p5_a9 JTF_VARCHAR2_TABLE_100
306 , p5_a10 JTF_DATE_TABLE
307 , p5_a11 JTF_DATE_TABLE
308 , p5_a12 JTF_NUMBER_TABLE
309 , p5_a13 JTF_NUMBER_TABLE
310 , p5_a14 JTF_DATE_TABLE
311 , p5_a15 JTF_NUMBER_TABLE
312 , p5_a16 JTF_DATE_TABLE
313 , p5_a17 JTF_NUMBER_TABLE
314 );
315 end okl_accrual_rules_pub_w;