[Home] [Help]
PACKAGE: APPS.OKL_FPR_PVT_W
Source
1 package okl_fpr_pvt_w as
2 /* $Header: OKLIFPRS.pls 120.1 2005/07/12 07:05:47 asawanka noship $ */
3 procedure rosetta_table_copy_in_p2(t out nocopy okl_fpr_pvt.fpr_tbl_type, a0 JTF_NUMBER_TABLE
4 , a1 JTF_NUMBER_TABLE
5 , a2 JTF_NUMBER_TABLE
6 , a3 JTF_VARCHAR2_TABLE_100
7 , a4 JTF_NUMBER_TABLE
8 , a5 JTF_NUMBER_TABLE
9 , a6 JTF_NUMBER_TABLE
10 , a7 JTF_DATE_TABLE
11 , a8 JTF_NUMBER_TABLE
12 , a9 JTF_DATE_TABLE
13 , a10 JTF_NUMBER_TABLE
14 );
15 procedure rosetta_table_copy_out_p2(t okl_fpr_pvt.fpr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
16 , a1 out nocopy JTF_NUMBER_TABLE
17 , a2 out nocopy JTF_NUMBER_TABLE
18 , a3 out nocopy JTF_VARCHAR2_TABLE_100
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_DATE_TABLE
23 , a8 out nocopy JTF_NUMBER_TABLE
24 , a9 out nocopy JTF_DATE_TABLE
25 , a10 out nocopy JTF_NUMBER_TABLE
26 );
27
28 procedure rosetta_table_copy_in_p5(t out nocopy okl_fpr_pvt.okl_fnctn_prmtrs_tl_tbl_type, a0 JTF_NUMBER_TABLE
29 , a1 JTF_VARCHAR2_TABLE_100
30 , a2 JTF_VARCHAR2_TABLE_100
31 , a3 JTF_VARCHAR2_TABLE_100
32 , a4 JTF_VARCHAR2_TABLE_300
33 , a5 JTF_VARCHAR2_TABLE_800
34 , a6 JTF_NUMBER_TABLE
35 , a7 JTF_DATE_TABLE
36 , a8 JTF_NUMBER_TABLE
37 , a9 JTF_DATE_TABLE
38 , a10 JTF_NUMBER_TABLE
39 );
40 procedure rosetta_table_copy_out_p5(t okl_fpr_pvt.okl_fnctn_prmtrs_tl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
41 , a1 out nocopy JTF_VARCHAR2_TABLE_100
42 , a2 out nocopy JTF_VARCHAR2_TABLE_100
43 , a3 out nocopy JTF_VARCHAR2_TABLE_100
44 , a4 out nocopy JTF_VARCHAR2_TABLE_300
45 , a5 out nocopy JTF_VARCHAR2_TABLE_800
46 , a6 out nocopy JTF_NUMBER_TABLE
47 , a7 out nocopy JTF_DATE_TABLE
48 , a8 out nocopy JTF_NUMBER_TABLE
49 , a9 out nocopy JTF_DATE_TABLE
50 , a10 out nocopy JTF_NUMBER_TABLE
51 );
52
53 procedure rosetta_table_copy_in_p8(t out nocopy okl_fpr_pvt.fprv_tbl_type, a0 JTF_NUMBER_TABLE
54 , a1 JTF_NUMBER_TABLE
55 , a2 JTF_VARCHAR2_TABLE_100
56 , a3 JTF_NUMBER_TABLE
57 , a4 JTF_NUMBER_TABLE
58 , a5 JTF_NUMBER_TABLE
59 , a6 JTF_VARCHAR2_TABLE_300
60 , a7 JTF_VARCHAR2_TABLE_800
61 , a8 JTF_VARCHAR2_TABLE_100
62 , a9 JTF_NUMBER_TABLE
63 , a10 JTF_DATE_TABLE
64 , a11 JTF_NUMBER_TABLE
65 , a12 JTF_DATE_TABLE
66 , a13 JTF_NUMBER_TABLE
67 );
68 procedure rosetta_table_copy_out_p8(t okl_fpr_pvt.fprv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
69 , a1 out nocopy JTF_NUMBER_TABLE
70 , a2 out nocopy JTF_VARCHAR2_TABLE_100
71 , a3 out nocopy JTF_NUMBER_TABLE
72 , a4 out nocopy JTF_NUMBER_TABLE
73 , a5 out nocopy JTF_NUMBER_TABLE
74 , a6 out nocopy JTF_VARCHAR2_TABLE_300
75 , a7 out nocopy JTF_VARCHAR2_TABLE_800
76 , a8 out nocopy JTF_VARCHAR2_TABLE_100
77 , a9 out nocopy JTF_NUMBER_TABLE
78 , a10 out nocopy JTF_DATE_TABLE
79 , a11 out nocopy JTF_NUMBER_TABLE
80 , a12 out nocopy JTF_DATE_TABLE
81 , a13 out nocopy JTF_NUMBER_TABLE
82 );
83
84 procedure insert_row(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 NUMBER
93 , p6_a4 out nocopy NUMBER
94 , p6_a5 out nocopy NUMBER
95 , p6_a6 out nocopy VARCHAR2
96 , p6_a7 out nocopy VARCHAR2
97 , p6_a8 out nocopy VARCHAR2
98 , p6_a9 out nocopy NUMBER
99 , p6_a10 out nocopy DATE
100 , p6_a11 out nocopy NUMBER
101 , p6_a12 out nocopy DATE
102 , p6_a13 out nocopy NUMBER
103 , p5_a0 NUMBER := 0-1962.0724
104 , p5_a1 NUMBER := 0-1962.0724
105 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
106 , p5_a3 NUMBER := 0-1962.0724
107 , p5_a4 NUMBER := 0-1962.0724
108 , p5_a5 NUMBER := 0-1962.0724
109 , p5_a6 VARCHAR2 := fnd_api.g_miss_char
110 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
111 , p5_a8 VARCHAR2 := fnd_api.g_miss_char
112 , p5_a9 NUMBER := 0-1962.0724
113 , p5_a10 DATE := fnd_api.g_miss_date
114 , p5_a11 NUMBER := 0-1962.0724
115 , p5_a12 DATE := fnd_api.g_miss_date
116 , p5_a13 NUMBER := 0-1962.0724
117 );
118 procedure insert_row(p_api_version NUMBER
119 , p_init_msg_list VARCHAR2
120 , x_return_status out nocopy VARCHAR2
121 , x_msg_count out nocopy NUMBER
122 , x_msg_data out nocopy VARCHAR2
123 , p5_a0 JTF_NUMBER_TABLE
124 , p5_a1 JTF_NUMBER_TABLE
125 , p5_a2 JTF_VARCHAR2_TABLE_100
126 , p5_a3 JTF_NUMBER_TABLE
127 , p5_a4 JTF_NUMBER_TABLE
128 , p5_a5 JTF_NUMBER_TABLE
129 , p5_a6 JTF_VARCHAR2_TABLE_300
130 , p5_a7 JTF_VARCHAR2_TABLE_800
131 , p5_a8 JTF_VARCHAR2_TABLE_100
132 , p5_a9 JTF_NUMBER_TABLE
133 , p5_a10 JTF_DATE_TABLE
134 , p5_a11 JTF_NUMBER_TABLE
135 , p5_a12 JTF_DATE_TABLE
136 , p5_a13 JTF_NUMBER_TABLE
137 , p6_a0 out nocopy JTF_NUMBER_TABLE
138 , p6_a1 out nocopy JTF_NUMBER_TABLE
139 , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
140 , p6_a3 out nocopy JTF_NUMBER_TABLE
141 , p6_a4 out nocopy JTF_NUMBER_TABLE
142 , p6_a5 out nocopy JTF_NUMBER_TABLE
143 , p6_a6 out nocopy JTF_VARCHAR2_TABLE_300
144 , p6_a7 out nocopy JTF_VARCHAR2_TABLE_800
145 , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
146 , p6_a9 out nocopy JTF_NUMBER_TABLE
147 , p6_a10 out nocopy JTF_DATE_TABLE
148 , p6_a11 out nocopy JTF_NUMBER_TABLE
149 , p6_a12 out nocopy JTF_DATE_TABLE
150 , p6_a13 out nocopy JTF_NUMBER_TABLE
151 );
152 procedure lock_row(p_api_version NUMBER
153 , p_init_msg_list VARCHAR2
154 , x_return_status out nocopy VARCHAR2
155 , x_msg_count out nocopy NUMBER
156 , x_msg_data out nocopy VARCHAR2
157 , p5_a0 NUMBER := 0-1962.0724
158 , p5_a1 NUMBER := 0-1962.0724
159 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
160 , p5_a3 NUMBER := 0-1962.0724
161 , p5_a4 NUMBER := 0-1962.0724
162 , p5_a5 NUMBER := 0-1962.0724
163 , p5_a6 VARCHAR2 := fnd_api.g_miss_char
164 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
165 , p5_a8 VARCHAR2 := fnd_api.g_miss_char
166 , p5_a9 NUMBER := 0-1962.0724
167 , p5_a10 DATE := fnd_api.g_miss_date
168 , p5_a11 NUMBER := 0-1962.0724
169 , p5_a12 DATE := fnd_api.g_miss_date
170 , p5_a13 NUMBER := 0-1962.0724
171 );
172 procedure lock_row(p_api_version NUMBER
173 , p_init_msg_list VARCHAR2
174 , x_return_status out nocopy VARCHAR2
175 , x_msg_count out nocopy NUMBER
176 , x_msg_data out nocopy VARCHAR2
177 , p5_a0 JTF_NUMBER_TABLE
178 , p5_a1 JTF_NUMBER_TABLE
179 , p5_a2 JTF_VARCHAR2_TABLE_100
180 , p5_a3 JTF_NUMBER_TABLE
181 , p5_a4 JTF_NUMBER_TABLE
182 , p5_a5 JTF_NUMBER_TABLE
183 , p5_a6 JTF_VARCHAR2_TABLE_300
184 , p5_a7 JTF_VARCHAR2_TABLE_800
185 , p5_a8 JTF_VARCHAR2_TABLE_100
186 , p5_a9 JTF_NUMBER_TABLE
187 , p5_a10 JTF_DATE_TABLE
188 , p5_a11 JTF_NUMBER_TABLE
189 , p5_a12 JTF_DATE_TABLE
190 , p5_a13 JTF_NUMBER_TABLE
191 );
192 procedure update_row(p_api_version NUMBER
193 , p_init_msg_list VARCHAR2
194 , x_return_status out nocopy VARCHAR2
195 , x_msg_count out nocopy NUMBER
196 , x_msg_data out nocopy VARCHAR2
197 , p6_a0 out nocopy NUMBER
198 , p6_a1 out nocopy NUMBER
199 , p6_a2 out nocopy VARCHAR2
200 , p6_a3 out nocopy NUMBER
201 , p6_a4 out nocopy NUMBER
202 , p6_a5 out nocopy NUMBER
203 , p6_a6 out nocopy VARCHAR2
204 , p6_a7 out nocopy VARCHAR2
205 , p6_a8 out nocopy VARCHAR2
206 , p6_a9 out nocopy NUMBER
207 , p6_a10 out nocopy DATE
208 , p6_a11 out nocopy NUMBER
209 , p6_a12 out nocopy DATE
210 , p6_a13 out nocopy NUMBER
211 , p5_a0 NUMBER := 0-1962.0724
212 , p5_a1 NUMBER := 0-1962.0724
213 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
214 , p5_a3 NUMBER := 0-1962.0724
215 , p5_a4 NUMBER := 0-1962.0724
216 , p5_a5 NUMBER := 0-1962.0724
217 , p5_a6 VARCHAR2 := fnd_api.g_miss_char
218 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
219 , p5_a8 VARCHAR2 := fnd_api.g_miss_char
220 , p5_a9 NUMBER := 0-1962.0724
221 , p5_a10 DATE := fnd_api.g_miss_date
222 , p5_a11 NUMBER := 0-1962.0724
223 , p5_a12 DATE := fnd_api.g_miss_date
224 , p5_a13 NUMBER := 0-1962.0724
225 );
226 procedure update_row(p_api_version NUMBER
227 , p_init_msg_list VARCHAR2
228 , x_return_status out nocopy VARCHAR2
229 , x_msg_count out nocopy NUMBER
230 , x_msg_data out nocopy VARCHAR2
231 , p5_a0 JTF_NUMBER_TABLE
232 , p5_a1 JTF_NUMBER_TABLE
233 , p5_a2 JTF_VARCHAR2_TABLE_100
234 , p5_a3 JTF_NUMBER_TABLE
235 , p5_a4 JTF_NUMBER_TABLE
236 , p5_a5 JTF_NUMBER_TABLE
237 , p5_a6 JTF_VARCHAR2_TABLE_300
238 , p5_a7 JTF_VARCHAR2_TABLE_800
239 , p5_a8 JTF_VARCHAR2_TABLE_100
240 , p5_a9 JTF_NUMBER_TABLE
241 , p5_a10 JTF_DATE_TABLE
242 , p5_a11 JTF_NUMBER_TABLE
243 , p5_a12 JTF_DATE_TABLE
244 , p5_a13 JTF_NUMBER_TABLE
245 , p6_a0 out nocopy JTF_NUMBER_TABLE
246 , p6_a1 out nocopy JTF_NUMBER_TABLE
247 , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
248 , p6_a3 out nocopy JTF_NUMBER_TABLE
249 , p6_a4 out nocopy JTF_NUMBER_TABLE
250 , p6_a5 out nocopy JTF_NUMBER_TABLE
251 , p6_a6 out nocopy JTF_VARCHAR2_TABLE_300
252 , p6_a7 out nocopy JTF_VARCHAR2_TABLE_800
253 , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
254 , p6_a9 out nocopy JTF_NUMBER_TABLE
255 , p6_a10 out nocopy JTF_DATE_TABLE
256 , p6_a11 out nocopy JTF_NUMBER_TABLE
257 , p6_a12 out nocopy JTF_DATE_TABLE
258 , p6_a13 out nocopy JTF_NUMBER_TABLE
259 );
260 procedure delete_row(p_api_version NUMBER
261 , p_init_msg_list VARCHAR2
262 , x_return_status out nocopy VARCHAR2
263 , x_msg_count out nocopy NUMBER
264 , x_msg_data out nocopy VARCHAR2
265 , p5_a0 NUMBER := 0-1962.0724
266 , p5_a1 NUMBER := 0-1962.0724
267 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
268 , p5_a3 NUMBER := 0-1962.0724
269 , p5_a4 NUMBER := 0-1962.0724
270 , p5_a5 NUMBER := 0-1962.0724
271 , p5_a6 VARCHAR2 := fnd_api.g_miss_char
272 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
273 , p5_a8 VARCHAR2 := fnd_api.g_miss_char
274 , p5_a9 NUMBER := 0-1962.0724
275 , p5_a10 DATE := fnd_api.g_miss_date
276 , p5_a11 NUMBER := 0-1962.0724
277 , p5_a12 DATE := fnd_api.g_miss_date
278 , p5_a13 NUMBER := 0-1962.0724
279 );
280 procedure delete_row(p_api_version NUMBER
281 , p_init_msg_list VARCHAR2
282 , x_return_status out nocopy VARCHAR2
283 , x_msg_count out nocopy NUMBER
284 , x_msg_data out nocopy VARCHAR2
285 , p5_a0 JTF_NUMBER_TABLE
286 , p5_a1 JTF_NUMBER_TABLE
287 , p5_a2 JTF_VARCHAR2_TABLE_100
288 , p5_a3 JTF_NUMBER_TABLE
289 , p5_a4 JTF_NUMBER_TABLE
290 , p5_a5 JTF_NUMBER_TABLE
291 , p5_a6 JTF_VARCHAR2_TABLE_300
292 , p5_a7 JTF_VARCHAR2_TABLE_800
293 , p5_a8 JTF_VARCHAR2_TABLE_100
294 , p5_a9 JTF_NUMBER_TABLE
295 , p5_a10 JTF_DATE_TABLE
296 , p5_a11 JTF_NUMBER_TABLE
297 , p5_a12 JTF_DATE_TABLE
298 , p5_a13 JTF_NUMBER_TABLE
299 );
300 procedure validate_row(p_api_version NUMBER
301 , p_init_msg_list VARCHAR2
302 , x_return_status out nocopy VARCHAR2
303 , x_msg_count out nocopy NUMBER
304 , x_msg_data out nocopy VARCHAR2
305 , p5_a0 NUMBER := 0-1962.0724
306 , p5_a1 NUMBER := 0-1962.0724
307 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
308 , p5_a3 NUMBER := 0-1962.0724
309 , p5_a4 NUMBER := 0-1962.0724
310 , p5_a5 NUMBER := 0-1962.0724
311 , p5_a6 VARCHAR2 := fnd_api.g_miss_char
312 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
313 , p5_a8 VARCHAR2 := fnd_api.g_miss_char
314 , p5_a9 NUMBER := 0-1962.0724
315 , p5_a10 DATE := fnd_api.g_miss_date
316 , p5_a11 NUMBER := 0-1962.0724
317 , p5_a12 DATE := fnd_api.g_miss_date
318 , p5_a13 NUMBER := 0-1962.0724
319 );
320 procedure validate_row(p_api_version NUMBER
321 , p_init_msg_list VARCHAR2
322 , x_return_status out nocopy VARCHAR2
323 , x_msg_count out nocopy NUMBER
324 , x_msg_data out nocopy VARCHAR2
325 , p5_a0 JTF_NUMBER_TABLE
326 , p5_a1 JTF_NUMBER_TABLE
327 , p5_a2 JTF_VARCHAR2_TABLE_100
328 , p5_a3 JTF_NUMBER_TABLE
329 , p5_a4 JTF_NUMBER_TABLE
330 , p5_a5 JTF_NUMBER_TABLE
331 , p5_a6 JTF_VARCHAR2_TABLE_300
332 , p5_a7 JTF_VARCHAR2_TABLE_800
333 , p5_a8 JTF_VARCHAR2_TABLE_100
334 , p5_a9 JTF_NUMBER_TABLE
335 , p5_a10 JTF_DATE_TABLE
336 , p5_a11 JTF_NUMBER_TABLE
337 , p5_a12 JTF_DATE_TABLE
338 , p5_a13 JTF_NUMBER_TABLE
339 );
340 end okl_fpr_pvt_w;