[Home] [Help]
PACKAGE: APPS.OKL_TMPT_SET_PVT_W
Source
1 package okl_tmpt_set_pvt_w AUTHID CURRENT_USER as
2 /* $Header: OKLOAESS.pls 120.2 2005/10/30 03:27:41 appldev noship $ */
3 procedure create_tmpt_set(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 JTF_NUMBER_TABLE
9 , p6_a1 JTF_NUMBER_TABLE
10 , p6_a2 JTF_NUMBER_TABLE
11 , p6_a3 JTF_NUMBER_TABLE
12 , p6_a4 JTF_NUMBER_TABLE
13 , p6_a5 JTF_NUMBER_TABLE
14 , p6_a6 JTF_NUMBER_TABLE
15 , p6_a7 JTF_VARCHAR2_TABLE_100
16 , p6_a8 JTF_VARCHAR2_TABLE_100
17 , p6_a9 JTF_VARCHAR2_TABLE_100
18 , p6_a10 JTF_VARCHAR2_TABLE_100
19 , p6_a11 JTF_VARCHAR2_TABLE_100
20 , p6_a12 JTF_VARCHAR2_TABLE_100
21 , p6_a13 JTF_VARCHAR2_TABLE_200
22 , p6_a14 JTF_VARCHAR2_TABLE_2000
23 , p6_a15 JTF_VARCHAR2_TABLE_100
24 , p6_a16 JTF_VARCHAR2_TABLE_100
25 , p6_a17 JTF_DATE_TABLE
26 , p6_a18 JTF_DATE_TABLE
27 , p6_a19 JTF_VARCHAR2_TABLE_100
28 , p6_a20 JTF_VARCHAR2_TABLE_100
29 , p6_a21 JTF_VARCHAR2_TABLE_500
30 , p6_a22 JTF_VARCHAR2_TABLE_500
31 , p6_a23 JTF_VARCHAR2_TABLE_500
32 , p6_a24 JTF_VARCHAR2_TABLE_500
33 , p6_a25 JTF_VARCHAR2_TABLE_500
34 , p6_a26 JTF_VARCHAR2_TABLE_500
35 , p6_a27 JTF_VARCHAR2_TABLE_500
36 , p6_a28 JTF_VARCHAR2_TABLE_500
37 , p6_a29 JTF_VARCHAR2_TABLE_500
38 , p6_a30 JTF_VARCHAR2_TABLE_500
39 , p6_a31 JTF_VARCHAR2_TABLE_500
40 , p6_a32 JTF_VARCHAR2_TABLE_500
41 , p6_a33 JTF_VARCHAR2_TABLE_500
42 , p6_a34 JTF_VARCHAR2_TABLE_500
43 , p6_a35 JTF_VARCHAR2_TABLE_500
44 , p6_a36 JTF_NUMBER_TABLE
45 , p6_a37 JTF_NUMBER_TABLE
46 , p6_a38 JTF_DATE_TABLE
47 , p6_a39 JTF_NUMBER_TABLE
48 , p6_a40 JTF_DATE_TABLE
49 , p6_a41 JTF_NUMBER_TABLE
50 , p6_a42 JTF_VARCHAR2_TABLE_100
51 , p7_a0 JTF_NUMBER_TABLE
52 , p7_a1 JTF_NUMBER_TABLE
53 , p7_a2 JTF_NUMBER_TABLE
54 , p7_a3 JTF_VARCHAR2_TABLE_100
55 , p7_a4 JTF_NUMBER_TABLE
56 , p7_a5 JTF_VARCHAR2_TABLE_100
57 , p7_a6 JTF_NUMBER_TABLE
58 , p7_a7 JTF_VARCHAR2_TABLE_2000
59 , p7_a8 JTF_NUMBER_TABLE
60 , p7_a9 JTF_VARCHAR2_TABLE_100
61 , p7_a10 JTF_VARCHAR2_TABLE_100
62 , p7_a11 JTF_VARCHAR2_TABLE_500
63 , p7_a12 JTF_VARCHAR2_TABLE_500
64 , p7_a13 JTF_VARCHAR2_TABLE_500
65 , p7_a14 JTF_VARCHAR2_TABLE_500
66 , p7_a15 JTF_VARCHAR2_TABLE_500
67 , p7_a16 JTF_VARCHAR2_TABLE_500
68 , p7_a17 JTF_VARCHAR2_TABLE_500
69 , p7_a18 JTF_VARCHAR2_TABLE_500
70 , p7_a19 JTF_VARCHAR2_TABLE_500
71 , p7_a20 JTF_VARCHAR2_TABLE_500
72 , p7_a21 JTF_VARCHAR2_TABLE_500
73 , p7_a22 JTF_VARCHAR2_TABLE_500
74 , p7_a23 JTF_VARCHAR2_TABLE_500
75 , p7_a24 JTF_VARCHAR2_TABLE_500
76 , p7_a25 JTF_VARCHAR2_TABLE_500
77 , p7_a26 JTF_NUMBER_TABLE
78 , p7_a27 JTF_NUMBER_TABLE
79 , p7_a28 JTF_NUMBER_TABLE
80 , p7_a29 JTF_DATE_TABLE
81 , p7_a30 JTF_NUMBER_TABLE
82 , p7_a31 JTF_DATE_TABLE
83 , p7_a32 JTF_NUMBER_TABLE
84 , p8_a0 out nocopy NUMBER
85 , p8_a1 out nocopy NUMBER
86 , p8_a2 out nocopy VARCHAR2
87 , p8_a3 out nocopy VARCHAR2
88 , p8_a4 out nocopy VARCHAR2
89 , p8_a5 out nocopy DATE
90 , p8_a6 out nocopy DATE
91 , p8_a7 out nocopy NUMBER
92 , p8_a8 out nocopy NUMBER
93 , p8_a9 out nocopy DATE
94 , p8_a10 out nocopy NUMBER
95 , p8_a11 out nocopy DATE
96 , p8_a12 out nocopy NUMBER
97 , p8_a13 out nocopy NUMBER
98 , p9_a0 out nocopy JTF_NUMBER_TABLE
99 , p9_a1 out nocopy JTF_NUMBER_TABLE
100 , p9_a2 out nocopy JTF_NUMBER_TABLE
101 , p9_a3 out nocopy JTF_NUMBER_TABLE
102 , p9_a4 out nocopy JTF_NUMBER_TABLE
103 , p9_a5 out nocopy JTF_NUMBER_TABLE
104 , p9_a6 out nocopy JTF_NUMBER_TABLE
105 , p9_a7 out nocopy JTF_VARCHAR2_TABLE_100
106 , p9_a8 out nocopy JTF_VARCHAR2_TABLE_100
107 , p9_a9 out nocopy JTF_VARCHAR2_TABLE_100
108 , p9_a10 out nocopy JTF_VARCHAR2_TABLE_100
109 , p9_a11 out nocopy JTF_VARCHAR2_TABLE_100
110 , p9_a12 out nocopy JTF_VARCHAR2_TABLE_100
111 , p9_a13 out nocopy JTF_VARCHAR2_TABLE_200
112 , p9_a14 out nocopy JTF_VARCHAR2_TABLE_2000
113 , p9_a15 out nocopy JTF_VARCHAR2_TABLE_100
114 , p9_a16 out nocopy JTF_VARCHAR2_TABLE_100
115 , p9_a17 out nocopy JTF_DATE_TABLE
116 , p9_a18 out nocopy JTF_DATE_TABLE
117 , p9_a19 out nocopy JTF_VARCHAR2_TABLE_100
118 , p9_a20 out nocopy JTF_VARCHAR2_TABLE_100
119 , p9_a21 out nocopy JTF_VARCHAR2_TABLE_500
120 , p9_a22 out nocopy JTF_VARCHAR2_TABLE_500
121 , p9_a23 out nocopy JTF_VARCHAR2_TABLE_500
122 , p9_a24 out nocopy JTF_VARCHAR2_TABLE_500
123 , p9_a25 out nocopy JTF_VARCHAR2_TABLE_500
124 , p9_a26 out nocopy JTF_VARCHAR2_TABLE_500
125 , p9_a27 out nocopy JTF_VARCHAR2_TABLE_500
126 , p9_a28 out nocopy JTF_VARCHAR2_TABLE_500
127 , p9_a29 out nocopy JTF_VARCHAR2_TABLE_500
128 , p9_a30 out nocopy JTF_VARCHAR2_TABLE_500
129 , p9_a31 out nocopy JTF_VARCHAR2_TABLE_500
130 , p9_a32 out nocopy JTF_VARCHAR2_TABLE_500
131 , p9_a33 out nocopy JTF_VARCHAR2_TABLE_500
132 , p9_a34 out nocopy JTF_VARCHAR2_TABLE_500
133 , p9_a35 out nocopy JTF_VARCHAR2_TABLE_500
134 , p9_a36 out nocopy JTF_NUMBER_TABLE
135 , p9_a37 out nocopy JTF_NUMBER_TABLE
136 , p9_a38 out nocopy JTF_DATE_TABLE
137 , p9_a39 out nocopy JTF_NUMBER_TABLE
138 , p9_a40 out nocopy JTF_DATE_TABLE
139 , p9_a41 out nocopy JTF_NUMBER_TABLE
140 , p9_a42 out nocopy JTF_VARCHAR2_TABLE_100
141 , p10_a0 out nocopy JTF_NUMBER_TABLE
142 , p10_a1 out nocopy JTF_NUMBER_TABLE
143 , p10_a2 out nocopy JTF_NUMBER_TABLE
144 , p10_a3 out nocopy JTF_VARCHAR2_TABLE_100
145 , p10_a4 out nocopy JTF_NUMBER_TABLE
146 , p10_a5 out nocopy JTF_VARCHAR2_TABLE_100
147 , p10_a6 out nocopy JTF_NUMBER_TABLE
148 , p10_a7 out nocopy JTF_VARCHAR2_TABLE_2000
149 , p10_a8 out nocopy JTF_NUMBER_TABLE
150 , p10_a9 out nocopy JTF_VARCHAR2_TABLE_100
151 , p10_a10 out nocopy JTF_VARCHAR2_TABLE_100
152 , p10_a11 out nocopy JTF_VARCHAR2_TABLE_500
153 , p10_a12 out nocopy JTF_VARCHAR2_TABLE_500
154 , p10_a13 out nocopy JTF_VARCHAR2_TABLE_500
155 , p10_a14 out nocopy JTF_VARCHAR2_TABLE_500
156 , p10_a15 out nocopy JTF_VARCHAR2_TABLE_500
157 , p10_a16 out nocopy JTF_VARCHAR2_TABLE_500
158 , p10_a17 out nocopy JTF_VARCHAR2_TABLE_500
159 , p10_a18 out nocopy JTF_VARCHAR2_TABLE_500
160 , p10_a19 out nocopy JTF_VARCHAR2_TABLE_500
161 , p10_a20 out nocopy JTF_VARCHAR2_TABLE_500
162 , p10_a21 out nocopy JTF_VARCHAR2_TABLE_500
163 , p10_a22 out nocopy JTF_VARCHAR2_TABLE_500
164 , p10_a23 out nocopy JTF_VARCHAR2_TABLE_500
165 , p10_a24 out nocopy JTF_VARCHAR2_TABLE_500
166 , p10_a25 out nocopy JTF_VARCHAR2_TABLE_500
167 , p10_a26 out nocopy JTF_NUMBER_TABLE
168 , p10_a27 out nocopy JTF_NUMBER_TABLE
169 , p10_a28 out nocopy JTF_NUMBER_TABLE
170 , p10_a29 out nocopy JTF_DATE_TABLE
171 , p10_a30 out nocopy JTF_NUMBER_TABLE
172 , p10_a31 out nocopy JTF_DATE_TABLE
173 , p10_a32 out nocopy JTF_NUMBER_TABLE
174 , p5_a0 NUMBER := 0-1962.0724
175 , p5_a1 NUMBER := 0-1962.0724
176 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
177 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
178 , p5_a4 VARCHAR2 := fnd_api.g_miss_char
179 , p5_a5 DATE := fnd_api.g_miss_date
180 , p5_a6 DATE := fnd_api.g_miss_date
181 , p5_a7 NUMBER := 0-1962.0724
182 , p5_a8 NUMBER := 0-1962.0724
183 , p5_a9 DATE := fnd_api.g_miss_date
184 , p5_a10 NUMBER := 0-1962.0724
185 , p5_a11 DATE := fnd_api.g_miss_date
186 , p5_a12 NUMBER := 0-1962.0724
187 , p5_a13 NUMBER := 0-1962.0724
188 );
189 procedure update_tmpt_set(p_api_version NUMBER
190 , p_init_msg_list VARCHAR2
191 , x_return_status out nocopy VARCHAR2
192 , x_msg_count out nocopy NUMBER
193 , x_msg_data out nocopy VARCHAR2
194 , p6_a0 JTF_NUMBER_TABLE
195 , p6_a1 JTF_NUMBER_TABLE
196 , p6_a2 JTF_NUMBER_TABLE
197 , p6_a3 JTF_NUMBER_TABLE
198 , p6_a4 JTF_NUMBER_TABLE
199 , p6_a5 JTF_NUMBER_TABLE
200 , p6_a6 JTF_NUMBER_TABLE
201 , p6_a7 JTF_VARCHAR2_TABLE_100
202 , p6_a8 JTF_VARCHAR2_TABLE_100
203 , p6_a9 JTF_VARCHAR2_TABLE_100
204 , p6_a10 JTF_VARCHAR2_TABLE_100
205 , p6_a11 JTF_VARCHAR2_TABLE_100
206 , p6_a12 JTF_VARCHAR2_TABLE_100
207 , p6_a13 JTF_VARCHAR2_TABLE_200
208 , p6_a14 JTF_VARCHAR2_TABLE_2000
209 , p6_a15 JTF_VARCHAR2_TABLE_100
210 , p6_a16 JTF_VARCHAR2_TABLE_100
211 , p6_a17 JTF_DATE_TABLE
212 , p6_a18 JTF_DATE_TABLE
213 , p6_a19 JTF_VARCHAR2_TABLE_100
214 , p6_a20 JTF_VARCHAR2_TABLE_100
215 , p6_a21 JTF_VARCHAR2_TABLE_500
216 , p6_a22 JTF_VARCHAR2_TABLE_500
217 , p6_a23 JTF_VARCHAR2_TABLE_500
218 , p6_a24 JTF_VARCHAR2_TABLE_500
219 , p6_a25 JTF_VARCHAR2_TABLE_500
220 , p6_a26 JTF_VARCHAR2_TABLE_500
221 , p6_a27 JTF_VARCHAR2_TABLE_500
222 , p6_a28 JTF_VARCHAR2_TABLE_500
223 , p6_a29 JTF_VARCHAR2_TABLE_500
224 , p6_a30 JTF_VARCHAR2_TABLE_500
225 , p6_a31 JTF_VARCHAR2_TABLE_500
226 , p6_a32 JTF_VARCHAR2_TABLE_500
227 , p6_a33 JTF_VARCHAR2_TABLE_500
228 , p6_a34 JTF_VARCHAR2_TABLE_500
229 , p6_a35 JTF_VARCHAR2_TABLE_500
230 , p6_a36 JTF_NUMBER_TABLE
231 , p6_a37 JTF_NUMBER_TABLE
232 , p6_a38 JTF_DATE_TABLE
233 , p6_a39 JTF_NUMBER_TABLE
234 , p6_a40 JTF_DATE_TABLE
235 , p6_a41 JTF_NUMBER_TABLE
236 , p6_a42 JTF_VARCHAR2_TABLE_100
237 , p7_a0 JTF_NUMBER_TABLE
238 , p7_a1 JTF_NUMBER_TABLE
239 , p7_a2 JTF_NUMBER_TABLE
240 , p7_a3 JTF_VARCHAR2_TABLE_100
241 , p7_a4 JTF_NUMBER_TABLE
242 , p7_a5 JTF_VARCHAR2_TABLE_100
243 , p7_a6 JTF_NUMBER_TABLE
244 , p7_a7 JTF_VARCHAR2_TABLE_2000
245 , p7_a8 JTF_NUMBER_TABLE
246 , p7_a9 JTF_VARCHAR2_TABLE_100
247 , p7_a10 JTF_VARCHAR2_TABLE_100
248 , p7_a11 JTF_VARCHAR2_TABLE_500
249 , p7_a12 JTF_VARCHAR2_TABLE_500
250 , p7_a13 JTF_VARCHAR2_TABLE_500
251 , p7_a14 JTF_VARCHAR2_TABLE_500
252 , p7_a15 JTF_VARCHAR2_TABLE_500
253 , p7_a16 JTF_VARCHAR2_TABLE_500
254 , p7_a17 JTF_VARCHAR2_TABLE_500
255 , p7_a18 JTF_VARCHAR2_TABLE_500
256 , p7_a19 JTF_VARCHAR2_TABLE_500
257 , p7_a20 JTF_VARCHAR2_TABLE_500
258 , p7_a21 JTF_VARCHAR2_TABLE_500
259 , p7_a22 JTF_VARCHAR2_TABLE_500
260 , p7_a23 JTF_VARCHAR2_TABLE_500
261 , p7_a24 JTF_VARCHAR2_TABLE_500
262 , p7_a25 JTF_VARCHAR2_TABLE_500
263 , p7_a26 JTF_NUMBER_TABLE
264 , p7_a27 JTF_NUMBER_TABLE
265 , p7_a28 JTF_NUMBER_TABLE
266 , p7_a29 JTF_DATE_TABLE
267 , p7_a30 JTF_NUMBER_TABLE
268 , p7_a31 JTF_DATE_TABLE
269 , p7_a32 JTF_NUMBER_TABLE
270 , p8_a0 out nocopy NUMBER
271 , p8_a1 out nocopy NUMBER
272 , p8_a2 out nocopy VARCHAR2
273 , p8_a3 out nocopy VARCHAR2
274 , p8_a4 out nocopy VARCHAR2
275 , p8_a5 out nocopy DATE
276 , p8_a6 out nocopy DATE
277 , p8_a7 out nocopy NUMBER
278 , p8_a8 out nocopy NUMBER
279 , p8_a9 out nocopy DATE
280 , p8_a10 out nocopy NUMBER
281 , p8_a11 out nocopy DATE
282 , p8_a12 out nocopy NUMBER
283 , p8_a13 out nocopy NUMBER
284 , p9_a0 out nocopy JTF_NUMBER_TABLE
285 , p9_a1 out nocopy JTF_NUMBER_TABLE
286 , p9_a2 out nocopy JTF_NUMBER_TABLE
287 , p9_a3 out nocopy JTF_NUMBER_TABLE
288 , p9_a4 out nocopy JTF_NUMBER_TABLE
289 , p9_a5 out nocopy JTF_NUMBER_TABLE
290 , p9_a6 out nocopy JTF_NUMBER_TABLE
291 , p9_a7 out nocopy JTF_VARCHAR2_TABLE_100
292 , p9_a8 out nocopy JTF_VARCHAR2_TABLE_100
293 , p9_a9 out nocopy JTF_VARCHAR2_TABLE_100
294 , p9_a10 out nocopy JTF_VARCHAR2_TABLE_100
295 , p9_a11 out nocopy JTF_VARCHAR2_TABLE_100
296 , p9_a12 out nocopy JTF_VARCHAR2_TABLE_100
297 , p9_a13 out nocopy JTF_VARCHAR2_TABLE_200
298 , p9_a14 out nocopy JTF_VARCHAR2_TABLE_2000
299 , p9_a15 out nocopy JTF_VARCHAR2_TABLE_100
300 , p9_a16 out nocopy JTF_VARCHAR2_TABLE_100
301 , p9_a17 out nocopy JTF_DATE_TABLE
302 , p9_a18 out nocopy JTF_DATE_TABLE
303 , p9_a19 out nocopy JTF_VARCHAR2_TABLE_100
304 , p9_a20 out nocopy JTF_VARCHAR2_TABLE_100
305 , p9_a21 out nocopy JTF_VARCHAR2_TABLE_500
306 , p9_a22 out nocopy JTF_VARCHAR2_TABLE_500
307 , p9_a23 out nocopy JTF_VARCHAR2_TABLE_500
308 , p9_a24 out nocopy JTF_VARCHAR2_TABLE_500
309 , p9_a25 out nocopy JTF_VARCHAR2_TABLE_500
310 , p9_a26 out nocopy JTF_VARCHAR2_TABLE_500
311 , p9_a27 out nocopy JTF_VARCHAR2_TABLE_500
312 , p9_a28 out nocopy JTF_VARCHAR2_TABLE_500
313 , p9_a29 out nocopy JTF_VARCHAR2_TABLE_500
314 , p9_a30 out nocopy JTF_VARCHAR2_TABLE_500
315 , p9_a31 out nocopy JTF_VARCHAR2_TABLE_500
316 , p9_a32 out nocopy JTF_VARCHAR2_TABLE_500
317 , p9_a33 out nocopy JTF_VARCHAR2_TABLE_500
318 , p9_a34 out nocopy JTF_VARCHAR2_TABLE_500
319 , p9_a35 out nocopy JTF_VARCHAR2_TABLE_500
320 , p9_a36 out nocopy JTF_NUMBER_TABLE
321 , p9_a37 out nocopy JTF_NUMBER_TABLE
322 , p9_a38 out nocopy JTF_DATE_TABLE
323 , p9_a39 out nocopy JTF_NUMBER_TABLE
324 , p9_a40 out nocopy JTF_DATE_TABLE
325 , p9_a41 out nocopy JTF_NUMBER_TABLE
326 , p9_a42 out nocopy JTF_VARCHAR2_TABLE_100
327 , p10_a0 out nocopy JTF_NUMBER_TABLE
328 , p10_a1 out nocopy JTF_NUMBER_TABLE
329 , p10_a2 out nocopy JTF_NUMBER_TABLE
330 , p10_a3 out nocopy JTF_VARCHAR2_TABLE_100
331 , p10_a4 out nocopy JTF_NUMBER_TABLE
332 , p10_a5 out nocopy JTF_VARCHAR2_TABLE_100
333 , p10_a6 out nocopy JTF_NUMBER_TABLE
334 , p10_a7 out nocopy JTF_VARCHAR2_TABLE_2000
335 , p10_a8 out nocopy JTF_NUMBER_TABLE
336 , p10_a9 out nocopy JTF_VARCHAR2_TABLE_100
337 , p10_a10 out nocopy JTF_VARCHAR2_TABLE_100
338 , p10_a11 out nocopy JTF_VARCHAR2_TABLE_500
339 , p10_a12 out nocopy JTF_VARCHAR2_TABLE_500
340 , p10_a13 out nocopy JTF_VARCHAR2_TABLE_500
341 , p10_a14 out nocopy JTF_VARCHAR2_TABLE_500
342 , p10_a15 out nocopy JTF_VARCHAR2_TABLE_500
343 , p10_a16 out nocopy JTF_VARCHAR2_TABLE_500
344 , p10_a17 out nocopy JTF_VARCHAR2_TABLE_500
345 , p10_a18 out nocopy JTF_VARCHAR2_TABLE_500
346 , p10_a19 out nocopy JTF_VARCHAR2_TABLE_500
347 , p10_a20 out nocopy JTF_VARCHAR2_TABLE_500
348 , p10_a21 out nocopy JTF_VARCHAR2_TABLE_500
349 , p10_a22 out nocopy JTF_VARCHAR2_TABLE_500
350 , p10_a23 out nocopy JTF_VARCHAR2_TABLE_500
351 , p10_a24 out nocopy JTF_VARCHAR2_TABLE_500
352 , p10_a25 out nocopy JTF_VARCHAR2_TABLE_500
353 , p10_a26 out nocopy JTF_NUMBER_TABLE
354 , p10_a27 out nocopy JTF_NUMBER_TABLE
355 , p10_a28 out nocopy JTF_NUMBER_TABLE
356 , p10_a29 out nocopy JTF_DATE_TABLE
357 , p10_a30 out nocopy JTF_NUMBER_TABLE
358 , p10_a31 out nocopy JTF_DATE_TABLE
359 , p10_a32 out nocopy JTF_NUMBER_TABLE
360 , p5_a0 NUMBER := 0-1962.0724
361 , p5_a1 NUMBER := 0-1962.0724
362 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
363 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
364 , p5_a4 VARCHAR2 := fnd_api.g_miss_char
365 , p5_a5 DATE := fnd_api.g_miss_date
366 , p5_a6 DATE := fnd_api.g_miss_date
367 , p5_a7 NUMBER := 0-1962.0724
368 , p5_a8 NUMBER := 0-1962.0724
369 , p5_a9 DATE := fnd_api.g_miss_date
370 , p5_a10 NUMBER := 0-1962.0724
371 , p5_a11 DATE := fnd_api.g_miss_date
372 , p5_a12 NUMBER := 0-1962.0724
373 , p5_a13 NUMBER := 0-1962.0724
374 );
375 procedure validate_tmpt_set(p_api_version NUMBER
376 , p_init_msg_list VARCHAR2
377 , x_return_status out nocopy VARCHAR2
378 , x_msg_count out nocopy NUMBER
379 , x_msg_data out nocopy VARCHAR2
380 , p6_a0 JTF_NUMBER_TABLE
381 , p6_a1 JTF_NUMBER_TABLE
382 , p6_a2 JTF_NUMBER_TABLE
383 , p6_a3 JTF_NUMBER_TABLE
384 , p6_a4 JTF_NUMBER_TABLE
385 , p6_a5 JTF_NUMBER_TABLE
386 , p6_a6 JTF_NUMBER_TABLE
387 , p6_a7 JTF_VARCHAR2_TABLE_100
388 , p6_a8 JTF_VARCHAR2_TABLE_100
389 , p6_a9 JTF_VARCHAR2_TABLE_100
390 , p6_a10 JTF_VARCHAR2_TABLE_100
391 , p6_a11 JTF_VARCHAR2_TABLE_100
392 , p6_a12 JTF_VARCHAR2_TABLE_100
393 , p6_a13 JTF_VARCHAR2_TABLE_200
394 , p6_a14 JTF_VARCHAR2_TABLE_2000
395 , p6_a15 JTF_VARCHAR2_TABLE_100
396 , p6_a16 JTF_VARCHAR2_TABLE_100
397 , p6_a17 JTF_DATE_TABLE
398 , p6_a18 JTF_DATE_TABLE
399 , p6_a19 JTF_VARCHAR2_TABLE_100
400 , p6_a20 JTF_VARCHAR2_TABLE_100
401 , p6_a21 JTF_VARCHAR2_TABLE_500
402 , p6_a22 JTF_VARCHAR2_TABLE_500
403 , p6_a23 JTF_VARCHAR2_TABLE_500
404 , p6_a24 JTF_VARCHAR2_TABLE_500
405 , p6_a25 JTF_VARCHAR2_TABLE_500
406 , p6_a26 JTF_VARCHAR2_TABLE_500
407 , p6_a27 JTF_VARCHAR2_TABLE_500
408 , p6_a28 JTF_VARCHAR2_TABLE_500
409 , p6_a29 JTF_VARCHAR2_TABLE_500
410 , p6_a30 JTF_VARCHAR2_TABLE_500
411 , p6_a31 JTF_VARCHAR2_TABLE_500
412 , p6_a32 JTF_VARCHAR2_TABLE_500
413 , p6_a33 JTF_VARCHAR2_TABLE_500
414 , p6_a34 JTF_VARCHAR2_TABLE_500
415 , p6_a35 JTF_VARCHAR2_TABLE_500
416 , p6_a36 JTF_NUMBER_TABLE
417 , p6_a37 JTF_NUMBER_TABLE
418 , p6_a38 JTF_DATE_TABLE
419 , p6_a39 JTF_NUMBER_TABLE
420 , p6_a40 JTF_DATE_TABLE
421 , p6_a41 JTF_NUMBER_TABLE
422 , p6_a42 JTF_VARCHAR2_TABLE_100
423 , p7_a0 JTF_NUMBER_TABLE
424 , p7_a1 JTF_NUMBER_TABLE
425 , p7_a2 JTF_NUMBER_TABLE
426 , p7_a3 JTF_VARCHAR2_TABLE_100
427 , p7_a4 JTF_NUMBER_TABLE
428 , p7_a5 JTF_VARCHAR2_TABLE_100
429 , p7_a6 JTF_NUMBER_TABLE
430 , p7_a7 JTF_VARCHAR2_TABLE_2000
431 , p7_a8 JTF_NUMBER_TABLE
432 , p7_a9 JTF_VARCHAR2_TABLE_100
433 , p7_a10 JTF_VARCHAR2_TABLE_100
434 , p7_a11 JTF_VARCHAR2_TABLE_500
435 , p7_a12 JTF_VARCHAR2_TABLE_500
436 , p7_a13 JTF_VARCHAR2_TABLE_500
437 , p7_a14 JTF_VARCHAR2_TABLE_500
438 , p7_a15 JTF_VARCHAR2_TABLE_500
439 , p7_a16 JTF_VARCHAR2_TABLE_500
440 , p7_a17 JTF_VARCHAR2_TABLE_500
441 , p7_a18 JTF_VARCHAR2_TABLE_500
442 , p7_a19 JTF_VARCHAR2_TABLE_500
443 , p7_a20 JTF_VARCHAR2_TABLE_500
444 , p7_a21 JTF_VARCHAR2_TABLE_500
445 , p7_a22 JTF_VARCHAR2_TABLE_500
446 , p7_a23 JTF_VARCHAR2_TABLE_500
447 , p7_a24 JTF_VARCHAR2_TABLE_500
448 , p7_a25 JTF_VARCHAR2_TABLE_500
449 , p7_a26 JTF_NUMBER_TABLE
450 , p7_a27 JTF_NUMBER_TABLE
451 , p7_a28 JTF_NUMBER_TABLE
452 , p7_a29 JTF_DATE_TABLE
453 , p7_a30 JTF_NUMBER_TABLE
454 , p7_a31 JTF_DATE_TABLE
455 , p7_a32 JTF_NUMBER_TABLE
456 , p5_a0 NUMBER := 0-1962.0724
457 , p5_a1 NUMBER := 0-1962.0724
458 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
459 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
460 , p5_a4 VARCHAR2 := fnd_api.g_miss_char
461 , p5_a5 DATE := fnd_api.g_miss_date
462 , p5_a6 DATE := fnd_api.g_miss_date
463 , p5_a7 NUMBER := 0-1962.0724
464 , p5_a8 NUMBER := 0-1962.0724
465 , p5_a9 DATE := fnd_api.g_miss_date
466 , p5_a10 NUMBER := 0-1962.0724
467 , p5_a11 DATE := fnd_api.g_miss_date
468 , p5_a12 NUMBER := 0-1962.0724
469 , p5_a13 NUMBER := 0-1962.0724
470 );
471 procedure create_tmpt_set(p_api_version NUMBER
472 , p_init_msg_list VARCHAR2
473 , x_return_status out nocopy VARCHAR2
474 , x_msg_count out nocopy NUMBER
475 , x_msg_data out nocopy VARCHAR2
476 , p5_a0 JTF_NUMBER_TABLE
477 , p5_a1 JTF_NUMBER_TABLE
478 , p5_a2 JTF_VARCHAR2_TABLE_200
479 , p5_a3 JTF_VARCHAR2_TABLE_2000
480 , p5_a4 JTF_VARCHAR2_TABLE_100
481 , p5_a5 JTF_DATE_TABLE
482 , p5_a6 JTF_DATE_TABLE
483 , p5_a7 JTF_NUMBER_TABLE
484 , p5_a8 JTF_NUMBER_TABLE
485 , p5_a9 JTF_DATE_TABLE
486 , p5_a10 JTF_NUMBER_TABLE
487 , p5_a11 JTF_DATE_TABLE
488 , p5_a12 JTF_NUMBER_TABLE
489 , p5_a13 JTF_NUMBER_TABLE
490 , p6_a0 out nocopy JTF_NUMBER_TABLE
491 , p6_a1 out nocopy JTF_NUMBER_TABLE
492 , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
493 , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000
494 , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
495 , p6_a5 out nocopy JTF_DATE_TABLE
496 , p6_a6 out nocopy JTF_DATE_TABLE
497 , p6_a7 out nocopy JTF_NUMBER_TABLE
498 , p6_a8 out nocopy JTF_NUMBER_TABLE
499 , p6_a9 out nocopy JTF_DATE_TABLE
500 , p6_a10 out nocopy JTF_NUMBER_TABLE
501 , p6_a11 out nocopy JTF_DATE_TABLE
502 , p6_a12 out nocopy JTF_NUMBER_TABLE
503 , p6_a13 out nocopy JTF_NUMBER_TABLE
504 );
505 procedure create_tmpt_set(p_api_version NUMBER
506 , p_init_msg_list VARCHAR2
507 , x_return_status out nocopy VARCHAR2
508 , x_msg_count out nocopy NUMBER
509 , x_msg_data out nocopy VARCHAR2
510 , p6_a0 out nocopy NUMBER
511 , p6_a1 out nocopy NUMBER
512 , p6_a2 out nocopy VARCHAR2
513 , p6_a3 out nocopy VARCHAR2
514 , p6_a4 out nocopy VARCHAR2
515 , p6_a5 out nocopy DATE
516 , p6_a6 out nocopy DATE
517 , p6_a7 out nocopy NUMBER
518 , p6_a8 out nocopy NUMBER
519 , p6_a9 out nocopy DATE
520 , p6_a10 out nocopy NUMBER
521 , p6_a11 out nocopy DATE
522 , p6_a12 out nocopy NUMBER
523 , p6_a13 out nocopy NUMBER
524 , p5_a0 NUMBER := 0-1962.0724
525 , p5_a1 NUMBER := 0-1962.0724
526 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
527 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
528 , p5_a4 VARCHAR2 := fnd_api.g_miss_char
529 , p5_a5 DATE := fnd_api.g_miss_date
530 , p5_a6 DATE := fnd_api.g_miss_date
531 , p5_a7 NUMBER := 0-1962.0724
532 , p5_a8 NUMBER := 0-1962.0724
533 , p5_a9 DATE := fnd_api.g_miss_date
534 , p5_a10 NUMBER := 0-1962.0724
535 , p5_a11 DATE := fnd_api.g_miss_date
536 , p5_a12 NUMBER := 0-1962.0724
537 , p5_a13 NUMBER := 0-1962.0724
538 );
539 procedure lock_tmpt_set(p_api_version NUMBER
540 , p_init_msg_list VARCHAR2
541 , x_return_status out nocopy VARCHAR2
542 , x_msg_count out nocopy NUMBER
543 , x_msg_data out nocopy VARCHAR2
544 , p5_a0 JTF_NUMBER_TABLE
545 , p5_a1 JTF_NUMBER_TABLE
546 , p5_a2 JTF_VARCHAR2_TABLE_200
547 , p5_a3 JTF_VARCHAR2_TABLE_2000
548 , p5_a4 JTF_VARCHAR2_TABLE_100
549 , p5_a5 JTF_DATE_TABLE
550 , p5_a6 JTF_DATE_TABLE
551 , p5_a7 JTF_NUMBER_TABLE
552 , p5_a8 JTF_NUMBER_TABLE
553 , p5_a9 JTF_DATE_TABLE
554 , p5_a10 JTF_NUMBER_TABLE
555 , p5_a11 JTF_DATE_TABLE
556 , p5_a12 JTF_NUMBER_TABLE
557 , p5_a13 JTF_NUMBER_TABLE
558 );
559 procedure lock_tmpt_set(p_api_version NUMBER
560 , p_init_msg_list VARCHAR2
561 , x_return_status out nocopy VARCHAR2
562 , x_msg_count out nocopy NUMBER
563 , x_msg_data out nocopy VARCHAR2
564 , p5_a0 NUMBER := 0-1962.0724
565 , p5_a1 NUMBER := 0-1962.0724
566 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
567 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
568 , p5_a4 VARCHAR2 := fnd_api.g_miss_char
569 , p5_a5 DATE := fnd_api.g_miss_date
570 , p5_a6 DATE := fnd_api.g_miss_date
571 , p5_a7 NUMBER := 0-1962.0724
572 , p5_a8 NUMBER := 0-1962.0724
573 , p5_a9 DATE := fnd_api.g_miss_date
574 , p5_a10 NUMBER := 0-1962.0724
575 , p5_a11 DATE := fnd_api.g_miss_date
576 , p5_a12 NUMBER := 0-1962.0724
577 , p5_a13 NUMBER := 0-1962.0724
578 );
579 procedure update_tmpt_set(p_api_version NUMBER
580 , p_init_msg_list VARCHAR2
581 , x_return_status out nocopy VARCHAR2
582 , x_msg_count out nocopy NUMBER
583 , x_msg_data out nocopy VARCHAR2
584 , p5_a0 JTF_NUMBER_TABLE
585 , p5_a1 JTF_NUMBER_TABLE
586 , p5_a2 JTF_VARCHAR2_TABLE_200
587 , p5_a3 JTF_VARCHAR2_TABLE_2000
588 , p5_a4 JTF_VARCHAR2_TABLE_100
589 , p5_a5 JTF_DATE_TABLE
590 , p5_a6 JTF_DATE_TABLE
591 , p5_a7 JTF_NUMBER_TABLE
592 , p5_a8 JTF_NUMBER_TABLE
593 , p5_a9 JTF_DATE_TABLE
594 , p5_a10 JTF_NUMBER_TABLE
595 , p5_a11 JTF_DATE_TABLE
596 , p5_a12 JTF_NUMBER_TABLE
597 , p5_a13 JTF_NUMBER_TABLE
598 , p6_a0 out nocopy JTF_NUMBER_TABLE
599 , p6_a1 out nocopy JTF_NUMBER_TABLE
600 , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
601 , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000
602 , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
603 , p6_a5 out nocopy JTF_DATE_TABLE
604 , p6_a6 out nocopy JTF_DATE_TABLE
605 , p6_a7 out nocopy JTF_NUMBER_TABLE
606 , p6_a8 out nocopy JTF_NUMBER_TABLE
607 , p6_a9 out nocopy JTF_DATE_TABLE
608 , p6_a10 out nocopy JTF_NUMBER_TABLE
609 , p6_a11 out nocopy JTF_DATE_TABLE
610 , p6_a12 out nocopy JTF_NUMBER_TABLE
611 , p6_a13 out nocopy JTF_NUMBER_TABLE
612 );
613 procedure update_tmpt_set(p_api_version NUMBER
614 , p_init_msg_list VARCHAR2
615 , x_return_status out nocopy VARCHAR2
616 , x_msg_count out nocopy NUMBER
617 , x_msg_data out nocopy VARCHAR2
618 , p6_a0 out nocopy NUMBER
619 , p6_a1 out nocopy NUMBER
620 , p6_a2 out nocopy VARCHAR2
621 , p6_a3 out nocopy VARCHAR2
622 , p6_a4 out nocopy VARCHAR2
623 , p6_a5 out nocopy DATE
624 , p6_a6 out nocopy DATE
625 , p6_a7 out nocopy NUMBER
626 , p6_a8 out nocopy NUMBER
627 , p6_a9 out nocopy DATE
628 , p6_a10 out nocopy NUMBER
629 , p6_a11 out nocopy DATE
630 , p6_a12 out nocopy NUMBER
631 , p6_a13 out nocopy NUMBER
632 , p5_a0 NUMBER := 0-1962.0724
633 , p5_a1 NUMBER := 0-1962.0724
634 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
635 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
636 , p5_a4 VARCHAR2 := fnd_api.g_miss_char
637 , p5_a5 DATE := fnd_api.g_miss_date
638 , p5_a6 DATE := fnd_api.g_miss_date
639 , p5_a7 NUMBER := 0-1962.0724
640 , p5_a8 NUMBER := 0-1962.0724
641 , p5_a9 DATE := fnd_api.g_miss_date
642 , p5_a10 NUMBER := 0-1962.0724
643 , p5_a11 DATE := fnd_api.g_miss_date
644 , p5_a12 NUMBER := 0-1962.0724
645 , p5_a13 NUMBER := 0-1962.0724
646 );
647 procedure delete_tmpt_set(p_api_version NUMBER
648 , p_init_msg_list VARCHAR2
649 , x_return_status out nocopy VARCHAR2
650 , x_msg_count out nocopy NUMBER
651 , x_msg_data out nocopy VARCHAR2
652 , p5_a0 JTF_NUMBER_TABLE
653 , p5_a1 JTF_NUMBER_TABLE
654 , p5_a2 JTF_VARCHAR2_TABLE_200
655 , p5_a3 JTF_VARCHAR2_TABLE_2000
656 , p5_a4 JTF_VARCHAR2_TABLE_100
657 , p5_a5 JTF_DATE_TABLE
658 , p5_a6 JTF_DATE_TABLE
659 , p5_a7 JTF_NUMBER_TABLE
660 , p5_a8 JTF_NUMBER_TABLE
661 , p5_a9 JTF_DATE_TABLE
662 , p5_a10 JTF_NUMBER_TABLE
663 , p5_a11 JTF_DATE_TABLE
664 , p5_a12 JTF_NUMBER_TABLE
665 , p5_a13 JTF_NUMBER_TABLE
666 );
667 procedure delete_tmpt_set(p_api_version NUMBER
668 , p_init_msg_list VARCHAR2
669 , x_return_status out nocopy VARCHAR2
670 , x_msg_count out nocopy NUMBER
671 , x_msg_data out nocopy VARCHAR2
672 , p5_a0 NUMBER := 0-1962.0724
673 , p5_a1 NUMBER := 0-1962.0724
674 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
675 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
676 , p5_a4 VARCHAR2 := fnd_api.g_miss_char
677 , p5_a5 DATE := fnd_api.g_miss_date
678 , p5_a6 DATE := fnd_api.g_miss_date
679 , p5_a7 NUMBER := 0-1962.0724
680 , p5_a8 NUMBER := 0-1962.0724
681 , p5_a9 DATE := fnd_api.g_miss_date
682 , p5_a10 NUMBER := 0-1962.0724
683 , p5_a11 DATE := fnd_api.g_miss_date
684 , p5_a12 NUMBER := 0-1962.0724
685 , p5_a13 NUMBER := 0-1962.0724
686 );
687 procedure validate_tmpt_set(p_api_version NUMBER
688 , p_init_msg_list VARCHAR2
689 , x_return_status out nocopy VARCHAR2
690 , x_msg_count out nocopy NUMBER
691 , x_msg_data out nocopy VARCHAR2
692 , p5_a0 JTF_NUMBER_TABLE
693 , p5_a1 JTF_NUMBER_TABLE
694 , p5_a2 JTF_VARCHAR2_TABLE_200
695 , p5_a3 JTF_VARCHAR2_TABLE_2000
696 , p5_a4 JTF_VARCHAR2_TABLE_100
697 , p5_a5 JTF_DATE_TABLE
698 , p5_a6 JTF_DATE_TABLE
699 , p5_a7 JTF_NUMBER_TABLE
700 , p5_a8 JTF_NUMBER_TABLE
701 , p5_a9 JTF_DATE_TABLE
702 , p5_a10 JTF_NUMBER_TABLE
703 , p5_a11 JTF_DATE_TABLE
704 , p5_a12 JTF_NUMBER_TABLE
705 , p5_a13 JTF_NUMBER_TABLE
706 );
707 procedure validate_tmpt_set(p_api_version NUMBER
708 , p_init_msg_list VARCHAR2
709 , x_return_status out nocopy VARCHAR2
710 , x_msg_count out nocopy NUMBER
711 , x_msg_data out nocopy VARCHAR2
712 , p5_a0 NUMBER := 0-1962.0724
713 , p5_a1 NUMBER := 0-1962.0724
714 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
715 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
716 , p5_a4 VARCHAR2 := fnd_api.g_miss_char
717 , p5_a5 DATE := fnd_api.g_miss_date
718 , p5_a6 DATE := fnd_api.g_miss_date
719 , p5_a7 NUMBER := 0-1962.0724
720 , p5_a8 NUMBER := 0-1962.0724
721 , p5_a9 DATE := fnd_api.g_miss_date
722 , p5_a10 NUMBER := 0-1962.0724
723 , p5_a11 DATE := fnd_api.g_miss_date
724 , p5_a12 NUMBER := 0-1962.0724
725 , p5_a13 NUMBER := 0-1962.0724
726 );
727 procedure create_template(p_api_version NUMBER
728 , p_init_msg_list VARCHAR2
729 , x_return_status out nocopy VARCHAR2
730 , x_msg_count out nocopy NUMBER
731 , x_msg_data out nocopy VARCHAR2
732 , p5_a0 JTF_NUMBER_TABLE
733 , p5_a1 JTF_NUMBER_TABLE
734 , p5_a2 JTF_NUMBER_TABLE
735 , p5_a3 JTF_NUMBER_TABLE
736 , p5_a4 JTF_NUMBER_TABLE
737 , p5_a5 JTF_NUMBER_TABLE
738 , p5_a6 JTF_NUMBER_TABLE
739 , p5_a7 JTF_VARCHAR2_TABLE_100
740 , p5_a8 JTF_VARCHAR2_TABLE_100
741 , p5_a9 JTF_VARCHAR2_TABLE_100
742 , p5_a10 JTF_VARCHAR2_TABLE_100
743 , p5_a11 JTF_VARCHAR2_TABLE_100
744 , p5_a12 JTF_VARCHAR2_TABLE_100
745 , p5_a13 JTF_VARCHAR2_TABLE_200
746 , p5_a14 JTF_VARCHAR2_TABLE_2000
747 , p5_a15 JTF_VARCHAR2_TABLE_100
748 , p5_a16 JTF_VARCHAR2_TABLE_100
749 , p5_a17 JTF_DATE_TABLE
750 , p5_a18 JTF_DATE_TABLE
751 , p5_a19 JTF_VARCHAR2_TABLE_100
752 , p5_a20 JTF_VARCHAR2_TABLE_100
753 , p5_a21 JTF_VARCHAR2_TABLE_500
754 , p5_a22 JTF_VARCHAR2_TABLE_500
755 , p5_a23 JTF_VARCHAR2_TABLE_500
756 , p5_a24 JTF_VARCHAR2_TABLE_500
757 , p5_a25 JTF_VARCHAR2_TABLE_500
758 , p5_a26 JTF_VARCHAR2_TABLE_500
759 , p5_a27 JTF_VARCHAR2_TABLE_500
760 , p5_a28 JTF_VARCHAR2_TABLE_500
761 , p5_a29 JTF_VARCHAR2_TABLE_500
762 , p5_a30 JTF_VARCHAR2_TABLE_500
763 , p5_a31 JTF_VARCHAR2_TABLE_500
764 , p5_a32 JTF_VARCHAR2_TABLE_500
765 , p5_a33 JTF_VARCHAR2_TABLE_500
766 , p5_a34 JTF_VARCHAR2_TABLE_500
767 , p5_a35 JTF_VARCHAR2_TABLE_500
768 , p5_a36 JTF_NUMBER_TABLE
769 , p5_a37 JTF_NUMBER_TABLE
770 , p5_a38 JTF_DATE_TABLE
771 , p5_a39 JTF_NUMBER_TABLE
772 , p5_a40 JTF_DATE_TABLE
773 , p5_a41 JTF_NUMBER_TABLE
774 , p5_a42 JTF_VARCHAR2_TABLE_100
775 , p6_a0 out nocopy JTF_NUMBER_TABLE
776 , p6_a1 out nocopy JTF_NUMBER_TABLE
777 , p6_a2 out nocopy JTF_NUMBER_TABLE
778 , p6_a3 out nocopy JTF_NUMBER_TABLE
779 , p6_a4 out nocopy JTF_NUMBER_TABLE
780 , p6_a5 out nocopy JTF_NUMBER_TABLE
781 , p6_a6 out nocopy JTF_NUMBER_TABLE
782 , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
783 , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
784 , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
785 , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
786 , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
787 , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
788 , p6_a13 out nocopy JTF_VARCHAR2_TABLE_200
789 , p6_a14 out nocopy JTF_VARCHAR2_TABLE_2000
790 , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
791 , p6_a16 out nocopy JTF_VARCHAR2_TABLE_100
792 , p6_a17 out nocopy JTF_DATE_TABLE
793 , p6_a18 out nocopy JTF_DATE_TABLE
794 , p6_a19 out nocopy JTF_VARCHAR2_TABLE_100
795 , p6_a20 out nocopy JTF_VARCHAR2_TABLE_100
796 , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
797 , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
798 , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
799 , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
800 , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
801 , p6_a26 out nocopy JTF_VARCHAR2_TABLE_500
802 , p6_a27 out nocopy JTF_VARCHAR2_TABLE_500
803 , p6_a28 out nocopy JTF_VARCHAR2_TABLE_500
804 , p6_a29 out nocopy JTF_VARCHAR2_TABLE_500
805 , p6_a30 out nocopy JTF_VARCHAR2_TABLE_500
806 , p6_a31 out nocopy JTF_VARCHAR2_TABLE_500
807 , p6_a32 out nocopy JTF_VARCHAR2_TABLE_500
808 , p6_a33 out nocopy JTF_VARCHAR2_TABLE_500
809 , p6_a34 out nocopy JTF_VARCHAR2_TABLE_500
810 , p6_a35 out nocopy JTF_VARCHAR2_TABLE_500
811 , p6_a36 out nocopy JTF_NUMBER_TABLE
812 , p6_a37 out nocopy JTF_NUMBER_TABLE
813 , p6_a38 out nocopy JTF_DATE_TABLE
814 , p6_a39 out nocopy JTF_NUMBER_TABLE
815 , p6_a40 out nocopy JTF_DATE_TABLE
816 , p6_a41 out nocopy JTF_NUMBER_TABLE
817 , p6_a42 out nocopy JTF_VARCHAR2_TABLE_100
818 );
819 procedure create_template(p_api_version NUMBER
820 , p_init_msg_list VARCHAR2
821 , x_return_status out nocopy VARCHAR2
822 , x_msg_count out nocopy NUMBER
823 , x_msg_data out nocopy VARCHAR2
824 , p6_a0 out nocopy NUMBER
825 , p6_a1 out nocopy NUMBER
826 , p6_a2 out nocopy NUMBER
827 , p6_a3 out nocopy NUMBER
828 , p6_a4 out nocopy NUMBER
829 , p6_a5 out nocopy NUMBER
830 , p6_a6 out nocopy NUMBER
831 , p6_a7 out nocopy VARCHAR2
832 , p6_a8 out nocopy VARCHAR2
833 , p6_a9 out nocopy VARCHAR2
834 , p6_a10 out nocopy VARCHAR2
835 , p6_a11 out nocopy VARCHAR2
836 , p6_a12 out nocopy VARCHAR2
837 , p6_a13 out nocopy VARCHAR2
838 , p6_a14 out nocopy VARCHAR2
839 , p6_a15 out nocopy VARCHAR2
840 , p6_a16 out nocopy VARCHAR2
841 , p6_a17 out nocopy DATE
842 , p6_a18 out nocopy DATE
843 , p6_a19 out nocopy VARCHAR2
844 , p6_a20 out nocopy VARCHAR2
845 , p6_a21 out nocopy VARCHAR2
846 , p6_a22 out nocopy VARCHAR2
847 , p6_a23 out nocopy VARCHAR2
848 , p6_a24 out nocopy VARCHAR2
849 , p6_a25 out nocopy VARCHAR2
850 , p6_a26 out nocopy VARCHAR2
851 , p6_a27 out nocopy VARCHAR2
852 , p6_a28 out nocopy VARCHAR2
853 , p6_a29 out nocopy VARCHAR2
854 , p6_a30 out nocopy VARCHAR2
855 , p6_a31 out nocopy VARCHAR2
856 , p6_a32 out nocopy VARCHAR2
857 , p6_a33 out nocopy VARCHAR2
858 , p6_a34 out nocopy VARCHAR2
859 , p6_a35 out nocopy VARCHAR2
860 , p6_a36 out nocopy NUMBER
861 , p6_a37 out nocopy NUMBER
862 , p6_a38 out nocopy DATE
863 , p6_a39 out nocopy NUMBER
864 , p6_a40 out nocopy DATE
865 , p6_a41 out nocopy NUMBER
866 , p6_a42 out nocopy VARCHAR2
867 , p5_a0 NUMBER := 0-1962.0724
868 , p5_a1 NUMBER := 0-1962.0724
869 , p5_a2 NUMBER := 0-1962.0724
870 , p5_a3 NUMBER := 0-1962.0724
871 , p5_a4 NUMBER := 0-1962.0724
872 , p5_a5 NUMBER := 0-1962.0724
873 , p5_a6 NUMBER := 0-1962.0724
874 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
875 , p5_a8 VARCHAR2 := fnd_api.g_miss_char
876 , p5_a9 VARCHAR2 := fnd_api.g_miss_char
877 , p5_a10 VARCHAR2 := fnd_api.g_miss_char
878 , p5_a11 VARCHAR2 := fnd_api.g_miss_char
879 , p5_a12 VARCHAR2 := fnd_api.g_miss_char
880 , p5_a13 VARCHAR2 := fnd_api.g_miss_char
881 , p5_a14 VARCHAR2 := fnd_api.g_miss_char
882 , p5_a15 VARCHAR2 := fnd_api.g_miss_char
883 , p5_a16 VARCHAR2 := fnd_api.g_miss_char
884 , p5_a17 DATE := fnd_api.g_miss_date
885 , p5_a18 DATE := fnd_api.g_miss_date
886 , p5_a19 VARCHAR2 := fnd_api.g_miss_char
887 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
888 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
889 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
890 , p5_a23 VARCHAR2 := fnd_api.g_miss_char
891 , p5_a24 VARCHAR2 := fnd_api.g_miss_char
892 , p5_a25 VARCHAR2 := fnd_api.g_miss_char
893 , p5_a26 VARCHAR2 := fnd_api.g_miss_char
894 , p5_a27 VARCHAR2 := fnd_api.g_miss_char
895 , p5_a28 VARCHAR2 := fnd_api.g_miss_char
896 , p5_a29 VARCHAR2 := fnd_api.g_miss_char
897 , p5_a30 VARCHAR2 := fnd_api.g_miss_char
898 , p5_a31 VARCHAR2 := fnd_api.g_miss_char
899 , p5_a32 VARCHAR2 := fnd_api.g_miss_char
900 , p5_a33 VARCHAR2 := fnd_api.g_miss_char
901 , p5_a34 VARCHAR2 := fnd_api.g_miss_char
902 , p5_a35 VARCHAR2 := fnd_api.g_miss_char
903 , p5_a36 NUMBER := 0-1962.0724
904 , p5_a37 NUMBER := 0-1962.0724
905 , p5_a38 DATE := fnd_api.g_miss_date
906 , p5_a39 NUMBER := 0-1962.0724
907 , p5_a40 DATE := fnd_api.g_miss_date
908 , p5_a41 NUMBER := 0-1962.0724
909 , p5_a42 VARCHAR2 := fnd_api.g_miss_char
910 );
911 procedure lock_template(p_api_version NUMBER
912 , p_init_msg_list VARCHAR2
913 , x_return_status out nocopy VARCHAR2
914 , x_msg_count out nocopy NUMBER
915 , x_msg_data out nocopy VARCHAR2
916 , p5_a0 JTF_NUMBER_TABLE
917 , p5_a1 JTF_NUMBER_TABLE
918 , p5_a2 JTF_NUMBER_TABLE
919 , p5_a3 JTF_NUMBER_TABLE
920 , p5_a4 JTF_NUMBER_TABLE
921 , p5_a5 JTF_NUMBER_TABLE
922 , p5_a6 JTF_NUMBER_TABLE
923 , p5_a7 JTF_VARCHAR2_TABLE_100
924 , p5_a8 JTF_VARCHAR2_TABLE_100
925 , p5_a9 JTF_VARCHAR2_TABLE_100
926 , p5_a10 JTF_VARCHAR2_TABLE_100
927 , p5_a11 JTF_VARCHAR2_TABLE_100
928 , p5_a12 JTF_VARCHAR2_TABLE_100
929 , p5_a13 JTF_VARCHAR2_TABLE_200
930 , p5_a14 JTF_VARCHAR2_TABLE_2000
931 , p5_a15 JTF_VARCHAR2_TABLE_100
932 , p5_a16 JTF_VARCHAR2_TABLE_100
933 , p5_a17 JTF_DATE_TABLE
934 , p5_a18 JTF_DATE_TABLE
935 , p5_a19 JTF_VARCHAR2_TABLE_100
936 , p5_a20 JTF_VARCHAR2_TABLE_100
937 , p5_a21 JTF_VARCHAR2_TABLE_500
938 , p5_a22 JTF_VARCHAR2_TABLE_500
939 , p5_a23 JTF_VARCHAR2_TABLE_500
940 , p5_a24 JTF_VARCHAR2_TABLE_500
941 , p5_a25 JTF_VARCHAR2_TABLE_500
942 , p5_a26 JTF_VARCHAR2_TABLE_500
943 , p5_a27 JTF_VARCHAR2_TABLE_500
944 , p5_a28 JTF_VARCHAR2_TABLE_500
945 , p5_a29 JTF_VARCHAR2_TABLE_500
946 , p5_a30 JTF_VARCHAR2_TABLE_500
947 , p5_a31 JTF_VARCHAR2_TABLE_500
948 , p5_a32 JTF_VARCHAR2_TABLE_500
949 , p5_a33 JTF_VARCHAR2_TABLE_500
950 , p5_a34 JTF_VARCHAR2_TABLE_500
951 , p5_a35 JTF_VARCHAR2_TABLE_500
952 , p5_a36 JTF_NUMBER_TABLE
953 , p5_a37 JTF_NUMBER_TABLE
954 , p5_a38 JTF_DATE_TABLE
955 , p5_a39 JTF_NUMBER_TABLE
956 , p5_a40 JTF_DATE_TABLE
957 , p5_a41 JTF_NUMBER_TABLE
958 , p5_a42 JTF_VARCHAR2_TABLE_100
959 );
960 procedure lock_template(p_api_version NUMBER
961 , p_init_msg_list VARCHAR2
962 , x_return_status out nocopy VARCHAR2
963 , x_msg_count out nocopy NUMBER
964 , x_msg_data out nocopy VARCHAR2
965 , p5_a0 NUMBER := 0-1962.0724
966 , p5_a1 NUMBER := 0-1962.0724
967 , p5_a2 NUMBER := 0-1962.0724
968 , p5_a3 NUMBER := 0-1962.0724
969 , p5_a4 NUMBER := 0-1962.0724
970 , p5_a5 NUMBER := 0-1962.0724
971 , p5_a6 NUMBER := 0-1962.0724
972 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
973 , p5_a8 VARCHAR2 := fnd_api.g_miss_char
974 , p5_a9 VARCHAR2 := fnd_api.g_miss_char
975 , p5_a10 VARCHAR2 := fnd_api.g_miss_char
976 , p5_a11 VARCHAR2 := fnd_api.g_miss_char
977 , p5_a12 VARCHAR2 := fnd_api.g_miss_char
978 , p5_a13 VARCHAR2 := fnd_api.g_miss_char
979 , p5_a14 VARCHAR2 := fnd_api.g_miss_char
980 , p5_a15 VARCHAR2 := fnd_api.g_miss_char
981 , p5_a16 VARCHAR2 := fnd_api.g_miss_char
982 , p5_a17 DATE := fnd_api.g_miss_date
983 , p5_a18 DATE := fnd_api.g_miss_date
984 , p5_a19 VARCHAR2 := fnd_api.g_miss_char
985 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
986 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
987 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
988 , p5_a23 VARCHAR2 := fnd_api.g_miss_char
989 , p5_a24 VARCHAR2 := fnd_api.g_miss_char
990 , p5_a25 VARCHAR2 := fnd_api.g_miss_char
991 , p5_a26 VARCHAR2 := fnd_api.g_miss_char
992 , p5_a27 VARCHAR2 := fnd_api.g_miss_char
993 , p5_a28 VARCHAR2 := fnd_api.g_miss_char
994 , p5_a29 VARCHAR2 := fnd_api.g_miss_char
995 , p5_a30 VARCHAR2 := fnd_api.g_miss_char
996 , p5_a31 VARCHAR2 := fnd_api.g_miss_char
997 , p5_a32 VARCHAR2 := fnd_api.g_miss_char
998 , p5_a33 VARCHAR2 := fnd_api.g_miss_char
999 , p5_a34 VARCHAR2 := fnd_api.g_miss_char
1000 , p5_a35 VARCHAR2 := fnd_api.g_miss_char
1001 , p5_a36 NUMBER := 0-1962.0724
1002 , p5_a37 NUMBER := 0-1962.0724
1003 , p5_a38 DATE := fnd_api.g_miss_date
1004 , p5_a39 NUMBER := 0-1962.0724
1005 , p5_a40 DATE := fnd_api.g_miss_date
1006 , p5_a41 NUMBER := 0-1962.0724
1007 , p5_a42 VARCHAR2 := fnd_api.g_miss_char
1008 );
1009 procedure update_template(p_api_version NUMBER
1010 , p_init_msg_list VARCHAR2
1011 , x_return_status out nocopy VARCHAR2
1012 , x_msg_count out nocopy NUMBER
1013 , x_msg_data out nocopy VARCHAR2
1014 , p5_a0 JTF_NUMBER_TABLE
1015 , p5_a1 JTF_NUMBER_TABLE
1016 , p5_a2 JTF_NUMBER_TABLE
1017 , p5_a3 JTF_NUMBER_TABLE
1018 , p5_a4 JTF_NUMBER_TABLE
1019 , p5_a5 JTF_NUMBER_TABLE
1020 , p5_a6 JTF_NUMBER_TABLE
1021 , p5_a7 JTF_VARCHAR2_TABLE_100
1022 , p5_a8 JTF_VARCHAR2_TABLE_100
1023 , p5_a9 JTF_VARCHAR2_TABLE_100
1024 , p5_a10 JTF_VARCHAR2_TABLE_100
1025 , p5_a11 JTF_VARCHAR2_TABLE_100
1026 , p5_a12 JTF_VARCHAR2_TABLE_100
1027 , p5_a13 JTF_VARCHAR2_TABLE_200
1028 , p5_a14 JTF_VARCHAR2_TABLE_2000
1029 , p5_a15 JTF_VARCHAR2_TABLE_100
1030 , p5_a16 JTF_VARCHAR2_TABLE_100
1031 , p5_a17 JTF_DATE_TABLE
1032 , p5_a18 JTF_DATE_TABLE
1033 , p5_a19 JTF_VARCHAR2_TABLE_100
1034 , p5_a20 JTF_VARCHAR2_TABLE_100
1035 , p5_a21 JTF_VARCHAR2_TABLE_500
1036 , p5_a22 JTF_VARCHAR2_TABLE_500
1037 , p5_a23 JTF_VARCHAR2_TABLE_500
1038 , p5_a24 JTF_VARCHAR2_TABLE_500
1039 , p5_a25 JTF_VARCHAR2_TABLE_500
1040 , p5_a26 JTF_VARCHAR2_TABLE_500
1041 , p5_a27 JTF_VARCHAR2_TABLE_500
1042 , p5_a28 JTF_VARCHAR2_TABLE_500
1043 , p5_a29 JTF_VARCHAR2_TABLE_500
1044 , p5_a30 JTF_VARCHAR2_TABLE_500
1045 , p5_a31 JTF_VARCHAR2_TABLE_500
1046 , p5_a32 JTF_VARCHAR2_TABLE_500
1047 , p5_a33 JTF_VARCHAR2_TABLE_500
1048 , p5_a34 JTF_VARCHAR2_TABLE_500
1049 , p5_a35 JTF_VARCHAR2_TABLE_500
1050 , p5_a36 JTF_NUMBER_TABLE
1051 , p5_a37 JTF_NUMBER_TABLE
1052 , p5_a38 JTF_DATE_TABLE
1053 , p5_a39 JTF_NUMBER_TABLE
1054 , p5_a40 JTF_DATE_TABLE
1055 , p5_a41 JTF_NUMBER_TABLE
1056 , p5_a42 JTF_VARCHAR2_TABLE_100
1057 , p6_a0 out nocopy JTF_NUMBER_TABLE
1058 , p6_a1 out nocopy JTF_NUMBER_TABLE
1059 , p6_a2 out nocopy JTF_NUMBER_TABLE
1060 , p6_a3 out nocopy JTF_NUMBER_TABLE
1061 , p6_a4 out nocopy JTF_NUMBER_TABLE
1062 , p6_a5 out nocopy JTF_NUMBER_TABLE
1063 , p6_a6 out nocopy JTF_NUMBER_TABLE
1064 , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
1065 , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
1066 , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
1067 , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
1068 , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
1069 , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
1070 , p6_a13 out nocopy JTF_VARCHAR2_TABLE_200
1071 , p6_a14 out nocopy JTF_VARCHAR2_TABLE_2000
1072 , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
1073 , p6_a16 out nocopy JTF_VARCHAR2_TABLE_100
1074 , p6_a17 out nocopy JTF_DATE_TABLE
1075 , p6_a18 out nocopy JTF_DATE_TABLE
1076 , p6_a19 out nocopy JTF_VARCHAR2_TABLE_100
1077 , p6_a20 out nocopy JTF_VARCHAR2_TABLE_100
1078 , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
1079 , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
1080 , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
1081 , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
1082 , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
1083 , p6_a26 out nocopy JTF_VARCHAR2_TABLE_500
1084 , p6_a27 out nocopy JTF_VARCHAR2_TABLE_500
1085 , p6_a28 out nocopy JTF_VARCHAR2_TABLE_500
1086 , p6_a29 out nocopy JTF_VARCHAR2_TABLE_500
1087 , p6_a30 out nocopy JTF_VARCHAR2_TABLE_500
1088 , p6_a31 out nocopy JTF_VARCHAR2_TABLE_500
1089 , p6_a32 out nocopy JTF_VARCHAR2_TABLE_500
1090 , p6_a33 out nocopy JTF_VARCHAR2_TABLE_500
1091 , p6_a34 out nocopy JTF_VARCHAR2_TABLE_500
1092 , p6_a35 out nocopy JTF_VARCHAR2_TABLE_500
1093 , p6_a36 out nocopy JTF_NUMBER_TABLE
1094 , p6_a37 out nocopy JTF_NUMBER_TABLE
1095 , p6_a38 out nocopy JTF_DATE_TABLE
1096 , p6_a39 out nocopy JTF_NUMBER_TABLE
1097 , p6_a40 out nocopy JTF_DATE_TABLE
1098 , p6_a41 out nocopy JTF_NUMBER_TABLE
1099 , p6_a42 out nocopy JTF_VARCHAR2_TABLE_100
1100 );
1101 procedure update_template(p_api_version NUMBER
1102 , p_init_msg_list VARCHAR2
1103 , x_return_status out nocopy VARCHAR2
1104 , x_msg_count out nocopy NUMBER
1105 , x_msg_data out nocopy VARCHAR2
1106 , p6_a0 out nocopy NUMBER
1107 , p6_a1 out nocopy NUMBER
1108 , p6_a2 out nocopy NUMBER
1109 , p6_a3 out nocopy NUMBER
1110 , p6_a4 out nocopy NUMBER
1111 , p6_a5 out nocopy NUMBER
1112 , p6_a6 out nocopy NUMBER
1113 , p6_a7 out nocopy VARCHAR2
1114 , p6_a8 out nocopy VARCHAR2
1115 , p6_a9 out nocopy VARCHAR2
1116 , p6_a10 out nocopy VARCHAR2
1117 , p6_a11 out nocopy VARCHAR2
1118 , p6_a12 out nocopy VARCHAR2
1119 , p6_a13 out nocopy VARCHAR2
1120 , p6_a14 out nocopy VARCHAR2
1121 , p6_a15 out nocopy VARCHAR2
1122 , p6_a16 out nocopy VARCHAR2
1123 , p6_a17 out nocopy DATE
1124 , p6_a18 out nocopy DATE
1125 , p6_a19 out nocopy VARCHAR2
1126 , p6_a20 out nocopy VARCHAR2
1127 , p6_a21 out nocopy VARCHAR2
1128 , p6_a22 out nocopy VARCHAR2
1129 , p6_a23 out nocopy VARCHAR2
1130 , p6_a24 out nocopy VARCHAR2
1131 , p6_a25 out nocopy VARCHAR2
1132 , p6_a26 out nocopy VARCHAR2
1133 , p6_a27 out nocopy VARCHAR2
1134 , p6_a28 out nocopy VARCHAR2
1135 , p6_a29 out nocopy VARCHAR2
1136 , p6_a30 out nocopy VARCHAR2
1137 , p6_a31 out nocopy VARCHAR2
1138 , p6_a32 out nocopy VARCHAR2
1139 , p6_a33 out nocopy VARCHAR2
1140 , p6_a34 out nocopy VARCHAR2
1141 , p6_a35 out nocopy VARCHAR2
1142 , p6_a36 out nocopy NUMBER
1143 , p6_a37 out nocopy NUMBER
1144 , p6_a38 out nocopy DATE
1145 , p6_a39 out nocopy NUMBER
1146 , p6_a40 out nocopy DATE
1147 , p6_a41 out nocopy NUMBER
1148 , p6_a42 out nocopy VARCHAR2
1149 , p5_a0 NUMBER := 0-1962.0724
1150 , p5_a1 NUMBER := 0-1962.0724
1151 , p5_a2 NUMBER := 0-1962.0724
1152 , p5_a3 NUMBER := 0-1962.0724
1153 , p5_a4 NUMBER := 0-1962.0724
1154 , p5_a5 NUMBER := 0-1962.0724
1155 , p5_a6 NUMBER := 0-1962.0724
1156 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1157 , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1158 , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1159 , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1160 , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1161 , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1162 , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1163 , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1164 , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1165 , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1166 , p5_a17 DATE := fnd_api.g_miss_date
1167 , p5_a18 DATE := fnd_api.g_miss_date
1168 , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1169 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1170 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1171 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1172 , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1173 , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1174 , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1175 , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1176 , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1177 , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1178 , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1179 , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1180 , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1181 , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1182 , p5_a33 VARCHAR2 := fnd_api.g_miss_char
1183 , p5_a34 VARCHAR2 := fnd_api.g_miss_char
1184 , p5_a35 VARCHAR2 := fnd_api.g_miss_char
1185 , p5_a36 NUMBER := 0-1962.0724
1186 , p5_a37 NUMBER := 0-1962.0724
1187 , p5_a38 DATE := fnd_api.g_miss_date
1188 , p5_a39 NUMBER := 0-1962.0724
1189 , p5_a40 DATE := fnd_api.g_miss_date
1190 , p5_a41 NUMBER := 0-1962.0724
1191 , p5_a42 VARCHAR2 := fnd_api.g_miss_char
1192 );
1193 procedure delete_template(p_api_version NUMBER
1194 , p_init_msg_list VARCHAR2
1195 , x_return_status out nocopy VARCHAR2
1196 , x_msg_count out nocopy NUMBER
1197 , x_msg_data out nocopy VARCHAR2
1198 , p5_a0 JTF_NUMBER_TABLE
1199 , p5_a1 JTF_NUMBER_TABLE
1200 , p5_a2 JTF_NUMBER_TABLE
1201 , p5_a3 JTF_NUMBER_TABLE
1202 , p5_a4 JTF_NUMBER_TABLE
1203 , p5_a5 JTF_NUMBER_TABLE
1204 , p5_a6 JTF_NUMBER_TABLE
1205 , p5_a7 JTF_VARCHAR2_TABLE_100
1206 , p5_a8 JTF_VARCHAR2_TABLE_100
1207 , p5_a9 JTF_VARCHAR2_TABLE_100
1208 , p5_a10 JTF_VARCHAR2_TABLE_100
1209 , p5_a11 JTF_VARCHAR2_TABLE_100
1210 , p5_a12 JTF_VARCHAR2_TABLE_100
1211 , p5_a13 JTF_VARCHAR2_TABLE_200
1212 , p5_a14 JTF_VARCHAR2_TABLE_2000
1213 , p5_a15 JTF_VARCHAR2_TABLE_100
1214 , p5_a16 JTF_VARCHAR2_TABLE_100
1215 , p5_a17 JTF_DATE_TABLE
1216 , p5_a18 JTF_DATE_TABLE
1217 , p5_a19 JTF_VARCHAR2_TABLE_100
1218 , p5_a20 JTF_VARCHAR2_TABLE_100
1219 , p5_a21 JTF_VARCHAR2_TABLE_500
1220 , p5_a22 JTF_VARCHAR2_TABLE_500
1221 , p5_a23 JTF_VARCHAR2_TABLE_500
1222 , p5_a24 JTF_VARCHAR2_TABLE_500
1223 , p5_a25 JTF_VARCHAR2_TABLE_500
1224 , p5_a26 JTF_VARCHAR2_TABLE_500
1225 , p5_a27 JTF_VARCHAR2_TABLE_500
1226 , p5_a28 JTF_VARCHAR2_TABLE_500
1227 , p5_a29 JTF_VARCHAR2_TABLE_500
1228 , p5_a30 JTF_VARCHAR2_TABLE_500
1229 , p5_a31 JTF_VARCHAR2_TABLE_500
1230 , p5_a32 JTF_VARCHAR2_TABLE_500
1231 , p5_a33 JTF_VARCHAR2_TABLE_500
1232 , p5_a34 JTF_VARCHAR2_TABLE_500
1233 , p5_a35 JTF_VARCHAR2_TABLE_500
1234 , p5_a36 JTF_NUMBER_TABLE
1235 , p5_a37 JTF_NUMBER_TABLE
1236 , p5_a38 JTF_DATE_TABLE
1237 , p5_a39 JTF_NUMBER_TABLE
1238 , p5_a40 JTF_DATE_TABLE
1239 , p5_a41 JTF_NUMBER_TABLE
1240 , p5_a42 JTF_VARCHAR2_TABLE_100
1241 );
1242 procedure delete_template(p_api_version NUMBER
1243 , p_init_msg_list VARCHAR2
1244 , x_return_status out nocopy VARCHAR2
1245 , x_msg_count out nocopy NUMBER
1246 , x_msg_data out nocopy VARCHAR2
1247 , p5_a0 NUMBER := 0-1962.0724
1248 , p5_a1 NUMBER := 0-1962.0724
1249 , p5_a2 NUMBER := 0-1962.0724
1250 , p5_a3 NUMBER := 0-1962.0724
1251 , p5_a4 NUMBER := 0-1962.0724
1252 , p5_a5 NUMBER := 0-1962.0724
1253 , p5_a6 NUMBER := 0-1962.0724
1254 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1255 , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1256 , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1257 , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1258 , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1259 , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1260 , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1261 , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1262 , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1263 , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1264 , p5_a17 DATE := fnd_api.g_miss_date
1265 , p5_a18 DATE := fnd_api.g_miss_date
1266 , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1267 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1268 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1269 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1270 , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1271 , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1272 , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1273 , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1274 , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1275 , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1276 , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1277 , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1278 , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1279 , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1280 , p5_a33 VARCHAR2 := fnd_api.g_miss_char
1281 , p5_a34 VARCHAR2 := fnd_api.g_miss_char
1282 , p5_a35 VARCHAR2 := fnd_api.g_miss_char
1283 , p5_a36 NUMBER := 0-1962.0724
1284 , p5_a37 NUMBER := 0-1962.0724
1285 , p5_a38 DATE := fnd_api.g_miss_date
1286 , p5_a39 NUMBER := 0-1962.0724
1287 , p5_a40 DATE := fnd_api.g_miss_date
1288 , p5_a41 NUMBER := 0-1962.0724
1289 , p5_a42 VARCHAR2 := fnd_api.g_miss_char
1290 );
1291 procedure validate_template(p_api_version NUMBER
1292 , p_init_msg_list VARCHAR2
1293 , x_return_status out nocopy VARCHAR2
1294 , x_msg_count out nocopy NUMBER
1295 , x_msg_data out nocopy VARCHAR2
1296 , p5_a0 JTF_NUMBER_TABLE
1297 , p5_a1 JTF_NUMBER_TABLE
1298 , p5_a2 JTF_NUMBER_TABLE
1299 , p5_a3 JTF_NUMBER_TABLE
1300 , p5_a4 JTF_NUMBER_TABLE
1301 , p5_a5 JTF_NUMBER_TABLE
1302 , p5_a6 JTF_NUMBER_TABLE
1303 , p5_a7 JTF_VARCHAR2_TABLE_100
1304 , p5_a8 JTF_VARCHAR2_TABLE_100
1305 , p5_a9 JTF_VARCHAR2_TABLE_100
1306 , p5_a10 JTF_VARCHAR2_TABLE_100
1307 , p5_a11 JTF_VARCHAR2_TABLE_100
1308 , p5_a12 JTF_VARCHAR2_TABLE_100
1309 , p5_a13 JTF_VARCHAR2_TABLE_200
1310 , p5_a14 JTF_VARCHAR2_TABLE_2000
1311 , p5_a15 JTF_VARCHAR2_TABLE_100
1312 , p5_a16 JTF_VARCHAR2_TABLE_100
1313 , p5_a17 JTF_DATE_TABLE
1314 , p5_a18 JTF_DATE_TABLE
1315 , p5_a19 JTF_VARCHAR2_TABLE_100
1316 , p5_a20 JTF_VARCHAR2_TABLE_100
1317 , p5_a21 JTF_VARCHAR2_TABLE_500
1318 , p5_a22 JTF_VARCHAR2_TABLE_500
1319 , p5_a23 JTF_VARCHAR2_TABLE_500
1320 , p5_a24 JTF_VARCHAR2_TABLE_500
1321 , p5_a25 JTF_VARCHAR2_TABLE_500
1322 , p5_a26 JTF_VARCHAR2_TABLE_500
1323 , p5_a27 JTF_VARCHAR2_TABLE_500
1324 , p5_a28 JTF_VARCHAR2_TABLE_500
1325 , p5_a29 JTF_VARCHAR2_TABLE_500
1326 , p5_a30 JTF_VARCHAR2_TABLE_500
1327 , p5_a31 JTF_VARCHAR2_TABLE_500
1328 , p5_a32 JTF_VARCHAR2_TABLE_500
1329 , p5_a33 JTF_VARCHAR2_TABLE_500
1330 , p5_a34 JTF_VARCHAR2_TABLE_500
1331 , p5_a35 JTF_VARCHAR2_TABLE_500
1332 , p5_a36 JTF_NUMBER_TABLE
1333 , p5_a37 JTF_NUMBER_TABLE
1334 , p5_a38 JTF_DATE_TABLE
1335 , p5_a39 JTF_NUMBER_TABLE
1336 , p5_a40 JTF_DATE_TABLE
1337 , p5_a41 JTF_NUMBER_TABLE
1338 , p5_a42 JTF_VARCHAR2_TABLE_100
1339 );
1340 procedure validate_template(p_api_version NUMBER
1341 , p_init_msg_list VARCHAR2
1342 , x_return_status out nocopy VARCHAR2
1343 , x_msg_count out nocopy NUMBER
1344 , x_msg_data out nocopy VARCHAR2
1345 , p5_a0 NUMBER := 0-1962.0724
1346 , p5_a1 NUMBER := 0-1962.0724
1347 , p5_a2 NUMBER := 0-1962.0724
1348 , p5_a3 NUMBER := 0-1962.0724
1349 , p5_a4 NUMBER := 0-1962.0724
1350 , p5_a5 NUMBER := 0-1962.0724
1351 , p5_a6 NUMBER := 0-1962.0724
1352 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1353 , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1354 , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1355 , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1356 , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1357 , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1358 , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1359 , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1360 , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1361 , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1362 , p5_a17 DATE := fnd_api.g_miss_date
1363 , p5_a18 DATE := fnd_api.g_miss_date
1364 , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1365 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1366 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1367 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1368 , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1369 , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1370 , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1371 , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1372 , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1373 , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1374 , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1375 , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1376 , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1377 , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1378 , p5_a33 VARCHAR2 := fnd_api.g_miss_char
1379 , p5_a34 VARCHAR2 := fnd_api.g_miss_char
1380 , p5_a35 VARCHAR2 := fnd_api.g_miss_char
1381 , p5_a36 NUMBER := 0-1962.0724
1382 , p5_a37 NUMBER := 0-1962.0724
1383 , p5_a38 DATE := fnd_api.g_miss_date
1384 , p5_a39 NUMBER := 0-1962.0724
1385 , p5_a40 DATE := fnd_api.g_miss_date
1386 , p5_a41 NUMBER := 0-1962.0724
1387 , p5_a42 VARCHAR2 := fnd_api.g_miss_char
1388 );
1389 procedure create_tmpt_lines(p_api_version NUMBER
1390 , p_init_msg_list VARCHAR2
1391 , x_return_status out nocopy VARCHAR2
1392 , x_msg_count out nocopy NUMBER
1393 , x_msg_data out nocopy VARCHAR2
1394 , p5_a0 JTF_NUMBER_TABLE
1395 , p5_a1 JTF_NUMBER_TABLE
1396 , p5_a2 JTF_NUMBER_TABLE
1397 , p5_a3 JTF_VARCHAR2_TABLE_100
1398 , p5_a4 JTF_NUMBER_TABLE
1399 , p5_a5 JTF_VARCHAR2_TABLE_100
1400 , p5_a6 JTF_NUMBER_TABLE
1401 , p5_a7 JTF_VARCHAR2_TABLE_2000
1402 , p5_a8 JTF_NUMBER_TABLE
1403 , p5_a9 JTF_VARCHAR2_TABLE_100
1404 , p5_a10 JTF_VARCHAR2_TABLE_100
1405 , p5_a11 JTF_VARCHAR2_TABLE_500
1406 , p5_a12 JTF_VARCHAR2_TABLE_500
1407 , p5_a13 JTF_VARCHAR2_TABLE_500
1408 , p5_a14 JTF_VARCHAR2_TABLE_500
1409 , p5_a15 JTF_VARCHAR2_TABLE_500
1410 , p5_a16 JTF_VARCHAR2_TABLE_500
1411 , p5_a17 JTF_VARCHAR2_TABLE_500
1412 , p5_a18 JTF_VARCHAR2_TABLE_500
1413 , p5_a19 JTF_VARCHAR2_TABLE_500
1414 , p5_a20 JTF_VARCHAR2_TABLE_500
1415 , p5_a21 JTF_VARCHAR2_TABLE_500
1416 , p5_a22 JTF_VARCHAR2_TABLE_500
1417 , p5_a23 JTF_VARCHAR2_TABLE_500
1418 , p5_a24 JTF_VARCHAR2_TABLE_500
1419 , p5_a25 JTF_VARCHAR2_TABLE_500
1420 , p5_a26 JTF_NUMBER_TABLE
1421 , p5_a27 JTF_NUMBER_TABLE
1422 , p5_a28 JTF_NUMBER_TABLE
1423 , p5_a29 JTF_DATE_TABLE
1424 , p5_a30 JTF_NUMBER_TABLE
1425 , p5_a31 JTF_DATE_TABLE
1426 , p5_a32 JTF_NUMBER_TABLE
1427 , p6_a0 out nocopy JTF_NUMBER_TABLE
1428 , p6_a1 out nocopy JTF_NUMBER_TABLE
1429 , p6_a2 out nocopy JTF_NUMBER_TABLE
1430 , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
1431 , p6_a4 out nocopy JTF_NUMBER_TABLE
1432 , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
1433 , p6_a6 out nocopy JTF_NUMBER_TABLE
1434 , p6_a7 out nocopy JTF_VARCHAR2_TABLE_2000
1435 , p6_a8 out nocopy JTF_NUMBER_TABLE
1436 , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
1437 , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
1438 , p6_a11 out nocopy JTF_VARCHAR2_TABLE_500
1439 , p6_a12 out nocopy JTF_VARCHAR2_TABLE_500
1440 , p6_a13 out nocopy JTF_VARCHAR2_TABLE_500
1441 , p6_a14 out nocopy JTF_VARCHAR2_TABLE_500
1442 , p6_a15 out nocopy JTF_VARCHAR2_TABLE_500
1443 , p6_a16 out nocopy JTF_VARCHAR2_TABLE_500
1444 , p6_a17 out nocopy JTF_VARCHAR2_TABLE_500
1445 , p6_a18 out nocopy JTF_VARCHAR2_TABLE_500
1446 , p6_a19 out nocopy JTF_VARCHAR2_TABLE_500
1447 , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
1448 , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
1449 , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
1450 , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
1451 , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
1452 , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
1453 , p6_a26 out nocopy JTF_NUMBER_TABLE
1454 , p6_a27 out nocopy JTF_NUMBER_TABLE
1455 , p6_a28 out nocopy JTF_NUMBER_TABLE
1456 , p6_a29 out nocopy JTF_DATE_TABLE
1457 , p6_a30 out nocopy JTF_NUMBER_TABLE
1458 , p6_a31 out nocopy JTF_DATE_TABLE
1459 , p6_a32 out nocopy JTF_NUMBER_TABLE
1460 );
1461 procedure create_tmpt_lines(p_api_version NUMBER
1462 , p_init_msg_list VARCHAR2
1463 , x_return_status out nocopy VARCHAR2
1464 , x_msg_count out nocopy NUMBER
1465 , x_msg_data out nocopy VARCHAR2
1466 , p6_a0 out nocopy NUMBER
1467 , p6_a1 out nocopy NUMBER
1468 , p6_a2 out nocopy NUMBER
1469 , p6_a3 out nocopy VARCHAR2
1470 , p6_a4 out nocopy NUMBER
1471 , p6_a5 out nocopy VARCHAR2
1472 , p6_a6 out nocopy NUMBER
1473 , p6_a7 out nocopy VARCHAR2
1474 , p6_a8 out nocopy NUMBER
1475 , p6_a9 out nocopy VARCHAR2
1476 , p6_a10 out nocopy VARCHAR2
1477 , p6_a11 out nocopy VARCHAR2
1478 , p6_a12 out nocopy VARCHAR2
1479 , p6_a13 out nocopy VARCHAR2
1480 , p6_a14 out nocopy VARCHAR2
1481 , p6_a15 out nocopy VARCHAR2
1482 , p6_a16 out nocopy VARCHAR2
1483 , p6_a17 out nocopy VARCHAR2
1484 , p6_a18 out nocopy VARCHAR2
1485 , p6_a19 out nocopy VARCHAR2
1486 , p6_a20 out nocopy VARCHAR2
1487 , p6_a21 out nocopy VARCHAR2
1488 , p6_a22 out nocopy VARCHAR2
1489 , p6_a23 out nocopy VARCHAR2
1490 , p6_a24 out nocopy VARCHAR2
1491 , p6_a25 out nocopy VARCHAR2
1492 , p6_a26 out nocopy NUMBER
1493 , p6_a27 out nocopy NUMBER
1494 , p6_a28 out nocopy NUMBER
1495 , p6_a29 out nocopy DATE
1496 , p6_a30 out nocopy NUMBER
1497 , p6_a31 out nocopy DATE
1498 , p6_a32 out nocopy NUMBER
1499 , p5_a0 NUMBER := 0-1962.0724
1500 , p5_a1 NUMBER := 0-1962.0724
1501 , p5_a2 NUMBER := 0-1962.0724
1502 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1503 , p5_a4 NUMBER := 0-1962.0724
1504 , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1505 , p5_a6 NUMBER := 0-1962.0724
1506 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1507 , p5_a8 NUMBER := 0-1962.0724
1508 , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1509 , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1510 , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1511 , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1512 , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1513 , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1514 , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1515 , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1516 , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1517 , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1518 , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1519 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1520 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1521 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1522 , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1523 , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1524 , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1525 , p5_a26 NUMBER := 0-1962.0724
1526 , p5_a27 NUMBER := 0-1962.0724
1527 , p5_a28 NUMBER := 0-1962.0724
1528 , p5_a29 DATE := fnd_api.g_miss_date
1529 , p5_a30 NUMBER := 0-1962.0724
1530 , p5_a31 DATE := fnd_api.g_miss_date
1531 , p5_a32 NUMBER := 0-1962.0724
1532 );
1533 procedure lock_tmpt_lines(p_api_version NUMBER
1534 , p_init_msg_list VARCHAR2
1535 , x_return_status out nocopy VARCHAR2
1536 , x_msg_count out nocopy NUMBER
1537 , x_msg_data out nocopy VARCHAR2
1538 , p5_a0 JTF_NUMBER_TABLE
1539 , p5_a1 JTF_NUMBER_TABLE
1540 , p5_a2 JTF_NUMBER_TABLE
1541 , p5_a3 JTF_VARCHAR2_TABLE_100
1542 , p5_a4 JTF_NUMBER_TABLE
1543 , p5_a5 JTF_VARCHAR2_TABLE_100
1544 , p5_a6 JTF_NUMBER_TABLE
1545 , p5_a7 JTF_VARCHAR2_TABLE_2000
1546 , p5_a8 JTF_NUMBER_TABLE
1547 , p5_a9 JTF_VARCHAR2_TABLE_100
1548 , p5_a10 JTF_VARCHAR2_TABLE_100
1549 , p5_a11 JTF_VARCHAR2_TABLE_500
1550 , p5_a12 JTF_VARCHAR2_TABLE_500
1551 , p5_a13 JTF_VARCHAR2_TABLE_500
1552 , p5_a14 JTF_VARCHAR2_TABLE_500
1553 , p5_a15 JTF_VARCHAR2_TABLE_500
1554 , p5_a16 JTF_VARCHAR2_TABLE_500
1555 , p5_a17 JTF_VARCHAR2_TABLE_500
1556 , p5_a18 JTF_VARCHAR2_TABLE_500
1557 , p5_a19 JTF_VARCHAR2_TABLE_500
1558 , p5_a20 JTF_VARCHAR2_TABLE_500
1559 , p5_a21 JTF_VARCHAR2_TABLE_500
1560 , p5_a22 JTF_VARCHAR2_TABLE_500
1561 , p5_a23 JTF_VARCHAR2_TABLE_500
1562 , p5_a24 JTF_VARCHAR2_TABLE_500
1563 , p5_a25 JTF_VARCHAR2_TABLE_500
1564 , p5_a26 JTF_NUMBER_TABLE
1565 , p5_a27 JTF_NUMBER_TABLE
1566 , p5_a28 JTF_NUMBER_TABLE
1567 , p5_a29 JTF_DATE_TABLE
1568 , p5_a30 JTF_NUMBER_TABLE
1569 , p5_a31 JTF_DATE_TABLE
1570 , p5_a32 JTF_NUMBER_TABLE
1571 );
1572 procedure lock_tmpt_lines(p_api_version NUMBER
1573 , p_init_msg_list VARCHAR2
1574 , x_return_status out nocopy VARCHAR2
1575 , x_msg_count out nocopy NUMBER
1576 , x_msg_data out nocopy VARCHAR2
1577 , p5_a0 NUMBER := 0-1962.0724
1578 , p5_a1 NUMBER := 0-1962.0724
1579 , p5_a2 NUMBER := 0-1962.0724
1580 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1581 , p5_a4 NUMBER := 0-1962.0724
1582 , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1583 , p5_a6 NUMBER := 0-1962.0724
1584 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1585 , p5_a8 NUMBER := 0-1962.0724
1586 , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1587 , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1588 , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1589 , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1590 , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1591 , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1592 , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1593 , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1594 , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1595 , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1596 , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1597 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1598 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1599 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1600 , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1601 , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1602 , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1603 , p5_a26 NUMBER := 0-1962.0724
1604 , p5_a27 NUMBER := 0-1962.0724
1605 , p5_a28 NUMBER := 0-1962.0724
1606 , p5_a29 DATE := fnd_api.g_miss_date
1607 , p5_a30 NUMBER := 0-1962.0724
1608 , p5_a31 DATE := fnd_api.g_miss_date
1609 , p5_a32 NUMBER := 0-1962.0724
1610 );
1611 procedure update_tmpt_lines(p_api_version NUMBER
1612 , p_init_msg_list VARCHAR2
1613 , x_return_status out nocopy VARCHAR2
1614 , x_msg_count out nocopy NUMBER
1615 , x_msg_data out nocopy VARCHAR2
1616 , p5_a0 JTF_NUMBER_TABLE
1617 , p5_a1 JTF_NUMBER_TABLE
1618 , p5_a2 JTF_NUMBER_TABLE
1619 , p5_a3 JTF_VARCHAR2_TABLE_100
1620 , p5_a4 JTF_NUMBER_TABLE
1621 , p5_a5 JTF_VARCHAR2_TABLE_100
1622 , p5_a6 JTF_NUMBER_TABLE
1623 , p5_a7 JTF_VARCHAR2_TABLE_2000
1624 , p5_a8 JTF_NUMBER_TABLE
1625 , p5_a9 JTF_VARCHAR2_TABLE_100
1626 , p5_a10 JTF_VARCHAR2_TABLE_100
1627 , p5_a11 JTF_VARCHAR2_TABLE_500
1628 , p5_a12 JTF_VARCHAR2_TABLE_500
1629 , p5_a13 JTF_VARCHAR2_TABLE_500
1630 , p5_a14 JTF_VARCHAR2_TABLE_500
1631 , p5_a15 JTF_VARCHAR2_TABLE_500
1632 , p5_a16 JTF_VARCHAR2_TABLE_500
1633 , p5_a17 JTF_VARCHAR2_TABLE_500
1634 , p5_a18 JTF_VARCHAR2_TABLE_500
1635 , p5_a19 JTF_VARCHAR2_TABLE_500
1636 , p5_a20 JTF_VARCHAR2_TABLE_500
1637 , p5_a21 JTF_VARCHAR2_TABLE_500
1638 , p5_a22 JTF_VARCHAR2_TABLE_500
1639 , p5_a23 JTF_VARCHAR2_TABLE_500
1640 , p5_a24 JTF_VARCHAR2_TABLE_500
1641 , p5_a25 JTF_VARCHAR2_TABLE_500
1642 , p5_a26 JTF_NUMBER_TABLE
1643 , p5_a27 JTF_NUMBER_TABLE
1644 , p5_a28 JTF_NUMBER_TABLE
1645 , p5_a29 JTF_DATE_TABLE
1646 , p5_a30 JTF_NUMBER_TABLE
1647 , p5_a31 JTF_DATE_TABLE
1648 , p5_a32 JTF_NUMBER_TABLE
1649 , p6_a0 out nocopy JTF_NUMBER_TABLE
1650 , p6_a1 out nocopy JTF_NUMBER_TABLE
1651 , p6_a2 out nocopy JTF_NUMBER_TABLE
1652 , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
1653 , p6_a4 out nocopy JTF_NUMBER_TABLE
1654 , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
1655 , p6_a6 out nocopy JTF_NUMBER_TABLE
1656 , p6_a7 out nocopy JTF_VARCHAR2_TABLE_2000
1657 , p6_a8 out nocopy JTF_NUMBER_TABLE
1658 , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
1659 , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
1660 , p6_a11 out nocopy JTF_VARCHAR2_TABLE_500
1661 , p6_a12 out nocopy JTF_VARCHAR2_TABLE_500
1662 , p6_a13 out nocopy JTF_VARCHAR2_TABLE_500
1663 , p6_a14 out nocopy JTF_VARCHAR2_TABLE_500
1664 , p6_a15 out nocopy JTF_VARCHAR2_TABLE_500
1665 , p6_a16 out nocopy JTF_VARCHAR2_TABLE_500
1666 , p6_a17 out nocopy JTF_VARCHAR2_TABLE_500
1667 , p6_a18 out nocopy JTF_VARCHAR2_TABLE_500
1668 , p6_a19 out nocopy JTF_VARCHAR2_TABLE_500
1669 , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
1670 , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
1671 , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
1672 , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
1673 , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
1674 , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
1675 , p6_a26 out nocopy JTF_NUMBER_TABLE
1676 , p6_a27 out nocopy JTF_NUMBER_TABLE
1677 , p6_a28 out nocopy JTF_NUMBER_TABLE
1678 , p6_a29 out nocopy JTF_DATE_TABLE
1679 , p6_a30 out nocopy JTF_NUMBER_TABLE
1680 , p6_a31 out nocopy JTF_DATE_TABLE
1681 , p6_a32 out nocopy JTF_NUMBER_TABLE
1682 );
1683 procedure update_tmpt_lines(p_api_version NUMBER
1684 , p_init_msg_list VARCHAR2
1685 , x_return_status out nocopy VARCHAR2
1686 , x_msg_count out nocopy NUMBER
1687 , x_msg_data out nocopy VARCHAR2
1688 , p6_a0 out nocopy NUMBER
1689 , p6_a1 out nocopy NUMBER
1690 , p6_a2 out nocopy NUMBER
1691 , p6_a3 out nocopy VARCHAR2
1692 , p6_a4 out nocopy NUMBER
1693 , p6_a5 out nocopy VARCHAR2
1694 , p6_a6 out nocopy NUMBER
1695 , p6_a7 out nocopy VARCHAR2
1696 , p6_a8 out nocopy NUMBER
1697 , p6_a9 out nocopy VARCHAR2
1698 , p6_a10 out nocopy VARCHAR2
1699 , p6_a11 out nocopy VARCHAR2
1700 , p6_a12 out nocopy VARCHAR2
1701 , p6_a13 out nocopy VARCHAR2
1702 , p6_a14 out nocopy VARCHAR2
1703 , p6_a15 out nocopy VARCHAR2
1704 , p6_a16 out nocopy VARCHAR2
1705 , p6_a17 out nocopy VARCHAR2
1706 , p6_a18 out nocopy VARCHAR2
1707 , p6_a19 out nocopy VARCHAR2
1708 , p6_a20 out nocopy VARCHAR2
1709 , p6_a21 out nocopy VARCHAR2
1710 , p6_a22 out nocopy VARCHAR2
1711 , p6_a23 out nocopy VARCHAR2
1712 , p6_a24 out nocopy VARCHAR2
1713 , p6_a25 out nocopy VARCHAR2
1714 , p6_a26 out nocopy NUMBER
1715 , p6_a27 out nocopy NUMBER
1716 , p6_a28 out nocopy NUMBER
1717 , p6_a29 out nocopy DATE
1718 , p6_a30 out nocopy NUMBER
1719 , p6_a31 out nocopy DATE
1720 , p6_a32 out nocopy NUMBER
1721 , p5_a0 NUMBER := 0-1962.0724
1722 , p5_a1 NUMBER := 0-1962.0724
1723 , p5_a2 NUMBER := 0-1962.0724
1724 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1725 , p5_a4 NUMBER := 0-1962.0724
1726 , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1727 , p5_a6 NUMBER := 0-1962.0724
1728 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1729 , p5_a8 NUMBER := 0-1962.0724
1730 , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1731 , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1732 , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1733 , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1734 , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1735 , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1736 , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1737 , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1738 , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1739 , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1740 , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1741 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1742 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1743 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1744 , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1745 , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1746 , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1747 , p5_a26 NUMBER := 0-1962.0724
1748 , p5_a27 NUMBER := 0-1962.0724
1749 , p5_a28 NUMBER := 0-1962.0724
1750 , p5_a29 DATE := fnd_api.g_miss_date
1751 , p5_a30 NUMBER := 0-1962.0724
1752 , p5_a31 DATE := fnd_api.g_miss_date
1753 , p5_a32 NUMBER := 0-1962.0724
1754 );
1755 procedure delete_tmpt_lines(p_api_version NUMBER
1756 , p_init_msg_list VARCHAR2
1757 , x_return_status out nocopy VARCHAR2
1758 , x_msg_count out nocopy NUMBER
1759 , x_msg_data out nocopy VARCHAR2
1760 , p5_a0 JTF_NUMBER_TABLE
1761 , p5_a1 JTF_NUMBER_TABLE
1762 , p5_a2 JTF_NUMBER_TABLE
1763 , p5_a3 JTF_VARCHAR2_TABLE_100
1764 , p5_a4 JTF_NUMBER_TABLE
1765 , p5_a5 JTF_VARCHAR2_TABLE_100
1766 , p5_a6 JTF_NUMBER_TABLE
1767 , p5_a7 JTF_VARCHAR2_TABLE_2000
1768 , p5_a8 JTF_NUMBER_TABLE
1769 , p5_a9 JTF_VARCHAR2_TABLE_100
1770 , p5_a10 JTF_VARCHAR2_TABLE_100
1771 , p5_a11 JTF_VARCHAR2_TABLE_500
1772 , p5_a12 JTF_VARCHAR2_TABLE_500
1773 , p5_a13 JTF_VARCHAR2_TABLE_500
1774 , p5_a14 JTF_VARCHAR2_TABLE_500
1775 , p5_a15 JTF_VARCHAR2_TABLE_500
1776 , p5_a16 JTF_VARCHAR2_TABLE_500
1777 , p5_a17 JTF_VARCHAR2_TABLE_500
1778 , p5_a18 JTF_VARCHAR2_TABLE_500
1779 , p5_a19 JTF_VARCHAR2_TABLE_500
1780 , p5_a20 JTF_VARCHAR2_TABLE_500
1781 , p5_a21 JTF_VARCHAR2_TABLE_500
1782 , p5_a22 JTF_VARCHAR2_TABLE_500
1783 , p5_a23 JTF_VARCHAR2_TABLE_500
1784 , p5_a24 JTF_VARCHAR2_TABLE_500
1785 , p5_a25 JTF_VARCHAR2_TABLE_500
1786 , p5_a26 JTF_NUMBER_TABLE
1787 , p5_a27 JTF_NUMBER_TABLE
1788 , p5_a28 JTF_NUMBER_TABLE
1789 , p5_a29 JTF_DATE_TABLE
1790 , p5_a30 JTF_NUMBER_TABLE
1791 , p5_a31 JTF_DATE_TABLE
1792 , p5_a32 JTF_NUMBER_TABLE
1793 );
1794 procedure delete_tmpt_lines(p_api_version NUMBER
1795 , p_init_msg_list VARCHAR2
1796 , x_return_status out nocopy VARCHAR2
1797 , x_msg_count out nocopy NUMBER
1798 , x_msg_data out nocopy VARCHAR2
1799 , p5_a0 NUMBER := 0-1962.0724
1800 , p5_a1 NUMBER := 0-1962.0724
1801 , p5_a2 NUMBER := 0-1962.0724
1802 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1803 , p5_a4 NUMBER := 0-1962.0724
1804 , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1805 , p5_a6 NUMBER := 0-1962.0724
1806 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1807 , p5_a8 NUMBER := 0-1962.0724
1808 , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1809 , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1810 , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1811 , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1812 , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1813 , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1814 , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1815 , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1816 , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1817 , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1818 , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1819 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1820 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1821 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1822 , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1823 , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1824 , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1825 , p5_a26 NUMBER := 0-1962.0724
1826 , p5_a27 NUMBER := 0-1962.0724
1827 , p5_a28 NUMBER := 0-1962.0724
1828 , p5_a29 DATE := fnd_api.g_miss_date
1829 , p5_a30 NUMBER := 0-1962.0724
1830 , p5_a31 DATE := fnd_api.g_miss_date
1831 , p5_a32 NUMBER := 0-1962.0724
1832 );
1833 procedure validate_tmpt_lines(p_api_version NUMBER
1834 , p_init_msg_list VARCHAR2
1835 , x_return_status out nocopy VARCHAR2
1836 , x_msg_count out nocopy NUMBER
1837 , x_msg_data out nocopy VARCHAR2
1838 , p5_a0 JTF_NUMBER_TABLE
1839 , p5_a1 JTF_NUMBER_TABLE
1840 , p5_a2 JTF_NUMBER_TABLE
1841 , p5_a3 JTF_VARCHAR2_TABLE_100
1842 , p5_a4 JTF_NUMBER_TABLE
1843 , p5_a5 JTF_VARCHAR2_TABLE_100
1844 , p5_a6 JTF_NUMBER_TABLE
1845 , p5_a7 JTF_VARCHAR2_TABLE_2000
1846 , p5_a8 JTF_NUMBER_TABLE
1847 , p5_a9 JTF_VARCHAR2_TABLE_100
1848 , p5_a10 JTF_VARCHAR2_TABLE_100
1849 , p5_a11 JTF_VARCHAR2_TABLE_500
1850 , p5_a12 JTF_VARCHAR2_TABLE_500
1851 , p5_a13 JTF_VARCHAR2_TABLE_500
1852 , p5_a14 JTF_VARCHAR2_TABLE_500
1853 , p5_a15 JTF_VARCHAR2_TABLE_500
1854 , p5_a16 JTF_VARCHAR2_TABLE_500
1855 , p5_a17 JTF_VARCHAR2_TABLE_500
1856 , p5_a18 JTF_VARCHAR2_TABLE_500
1857 , p5_a19 JTF_VARCHAR2_TABLE_500
1858 , p5_a20 JTF_VARCHAR2_TABLE_500
1859 , p5_a21 JTF_VARCHAR2_TABLE_500
1860 , p5_a22 JTF_VARCHAR2_TABLE_500
1861 , p5_a23 JTF_VARCHAR2_TABLE_500
1862 , p5_a24 JTF_VARCHAR2_TABLE_500
1863 , p5_a25 JTF_VARCHAR2_TABLE_500
1864 , p5_a26 JTF_NUMBER_TABLE
1865 , p5_a27 JTF_NUMBER_TABLE
1866 , p5_a28 JTF_NUMBER_TABLE
1867 , p5_a29 JTF_DATE_TABLE
1868 , p5_a30 JTF_NUMBER_TABLE
1869 , p5_a31 JTF_DATE_TABLE
1870 , p5_a32 JTF_NUMBER_TABLE
1871 );
1872 procedure validate_tmpt_lines(p_api_version NUMBER
1873 , p_init_msg_list VARCHAR2
1874 , x_return_status out nocopy VARCHAR2
1875 , x_msg_count out nocopy NUMBER
1876 , x_msg_data out nocopy VARCHAR2
1877 , p5_a0 NUMBER := 0-1962.0724
1878 , p5_a1 NUMBER := 0-1962.0724
1879 , p5_a2 NUMBER := 0-1962.0724
1880 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1881 , p5_a4 NUMBER := 0-1962.0724
1882 , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1883 , p5_a6 NUMBER := 0-1962.0724
1884 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1885 , p5_a8 NUMBER := 0-1962.0724
1886 , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1887 , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1888 , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1889 , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1890 , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1891 , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1892 , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1893 , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1894 , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1895 , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1896 , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1897 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1898 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1899 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1900 , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1901 , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1902 , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1903 , p5_a26 NUMBER := 0-1962.0724
1904 , p5_a27 NUMBER := 0-1962.0724
1905 , p5_a28 NUMBER := 0-1962.0724
1906 , p5_a29 DATE := fnd_api.g_miss_date
1907 , p5_a30 NUMBER := 0-1962.0724
1908 , p5_a31 DATE := fnd_api.g_miss_date
1909 , p5_a32 NUMBER := 0-1962.0724
1910 );
1911 end okl_tmpt_set_pvt_w;