[Home] [Help]
PACKAGE: APPS.OKL_PROCESS_TMPT_SET_PUB_W
Source
1 package okl_process_tmpt_set_pub_w as
2 /* $Header: OKLUTMSS.pls 120.2 2005/10/30 03:52:20 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 create_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 , p5_a0 JTF_NUMBER_TABLE
381 , p5_a1 JTF_NUMBER_TABLE
382 , p5_a2 JTF_VARCHAR2_TABLE_200
383 , p5_a3 JTF_VARCHAR2_TABLE_2000
384 , p5_a4 JTF_VARCHAR2_TABLE_100
385 , p5_a5 JTF_DATE_TABLE
386 , p5_a6 JTF_DATE_TABLE
387 , p5_a7 JTF_NUMBER_TABLE
388 , p5_a8 JTF_NUMBER_TABLE
389 , p5_a9 JTF_DATE_TABLE
390 , p5_a10 JTF_NUMBER_TABLE
391 , p5_a11 JTF_DATE_TABLE
392 , p5_a12 JTF_NUMBER_TABLE
393 , p5_a13 JTF_NUMBER_TABLE
394 , p6_a0 out nocopy JTF_NUMBER_TABLE
395 , p6_a1 out nocopy JTF_NUMBER_TABLE
396 , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
397 , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000
398 , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
399 , p6_a5 out nocopy JTF_DATE_TABLE
400 , p6_a6 out nocopy JTF_DATE_TABLE
401 , p6_a7 out nocopy JTF_NUMBER_TABLE
402 , p6_a8 out nocopy JTF_NUMBER_TABLE
403 , p6_a9 out nocopy JTF_DATE_TABLE
404 , p6_a10 out nocopy JTF_NUMBER_TABLE
405 , p6_a11 out nocopy JTF_DATE_TABLE
406 , p6_a12 out nocopy JTF_NUMBER_TABLE
407 , p6_a13 out nocopy JTF_NUMBER_TABLE
408 );
409 procedure create_tmpt_set(p_api_version NUMBER
410 , p_init_msg_list VARCHAR2
411 , x_return_status out nocopy VARCHAR2
412 , x_msg_count out nocopy NUMBER
413 , x_msg_data out nocopy VARCHAR2
414 , p6_a0 out nocopy NUMBER
415 , p6_a1 out nocopy NUMBER
416 , p6_a2 out nocopy VARCHAR2
417 , p6_a3 out nocopy VARCHAR2
418 , p6_a4 out nocopy VARCHAR2
419 , p6_a5 out nocopy DATE
420 , p6_a6 out nocopy DATE
421 , p6_a7 out nocopy NUMBER
422 , p6_a8 out nocopy NUMBER
423 , p6_a9 out nocopy DATE
424 , p6_a10 out nocopy NUMBER
425 , p6_a11 out nocopy DATE
426 , p6_a12 out nocopy NUMBER
427 , p6_a13 out nocopy NUMBER
428 , p_aes_source_id NUMBER
429 , p5_a0 NUMBER := 0-1962.0724
430 , p5_a1 NUMBER := 0-1962.0724
431 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
432 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
433 , p5_a4 VARCHAR2 := fnd_api.g_miss_char
434 , p5_a5 DATE := fnd_api.g_miss_date
435 , p5_a6 DATE := fnd_api.g_miss_date
436 , p5_a7 NUMBER := 0-1962.0724
437 , p5_a8 NUMBER := 0-1962.0724
438 , p5_a9 DATE := fnd_api.g_miss_date
439 , p5_a10 NUMBER := 0-1962.0724
440 , p5_a11 DATE := fnd_api.g_miss_date
441 , p5_a12 NUMBER := 0-1962.0724
442 , p5_a13 NUMBER := 0-1962.0724
443 );
444 procedure update_tmpt_set(p_api_version NUMBER
445 , p_init_msg_list VARCHAR2
446 , x_return_status out nocopy VARCHAR2
447 , x_msg_count out nocopy NUMBER
448 , x_msg_data out nocopy VARCHAR2
449 , p5_a0 JTF_NUMBER_TABLE
450 , p5_a1 JTF_NUMBER_TABLE
451 , p5_a2 JTF_VARCHAR2_TABLE_200
452 , p5_a3 JTF_VARCHAR2_TABLE_2000
453 , p5_a4 JTF_VARCHAR2_TABLE_100
454 , p5_a5 JTF_DATE_TABLE
455 , p5_a6 JTF_DATE_TABLE
456 , p5_a7 JTF_NUMBER_TABLE
457 , p5_a8 JTF_NUMBER_TABLE
458 , p5_a9 JTF_DATE_TABLE
459 , p5_a10 JTF_NUMBER_TABLE
460 , p5_a11 JTF_DATE_TABLE
461 , p5_a12 JTF_NUMBER_TABLE
462 , p5_a13 JTF_NUMBER_TABLE
463 , p6_a0 out nocopy JTF_NUMBER_TABLE
464 , p6_a1 out nocopy JTF_NUMBER_TABLE
465 , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
466 , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000
467 , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
468 , p6_a5 out nocopy JTF_DATE_TABLE
469 , p6_a6 out nocopy JTF_DATE_TABLE
470 , p6_a7 out nocopy JTF_NUMBER_TABLE
471 , p6_a8 out nocopy JTF_NUMBER_TABLE
472 , p6_a9 out nocopy JTF_DATE_TABLE
473 , p6_a10 out nocopy JTF_NUMBER_TABLE
474 , p6_a11 out nocopy JTF_DATE_TABLE
475 , p6_a12 out nocopy JTF_NUMBER_TABLE
476 , p6_a13 out nocopy JTF_NUMBER_TABLE
477 );
478 procedure update_tmpt_set(p_api_version NUMBER
479 , p_init_msg_list VARCHAR2
480 , x_return_status out nocopy VARCHAR2
481 , x_msg_count out nocopy NUMBER
482 , x_msg_data out nocopy VARCHAR2
483 , p6_a0 out nocopy NUMBER
484 , p6_a1 out nocopy NUMBER
485 , p6_a2 out nocopy VARCHAR2
486 , p6_a3 out nocopy VARCHAR2
487 , p6_a4 out nocopy VARCHAR2
488 , p6_a5 out nocopy DATE
489 , p6_a6 out nocopy DATE
490 , p6_a7 out nocopy NUMBER
491 , p6_a8 out nocopy NUMBER
492 , p6_a9 out nocopy DATE
493 , p6_a10 out nocopy NUMBER
494 , p6_a11 out nocopy DATE
495 , p6_a12 out nocopy NUMBER
496 , p6_a13 out nocopy NUMBER
497 , p5_a0 NUMBER := 0-1962.0724
498 , p5_a1 NUMBER := 0-1962.0724
499 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
500 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
501 , p5_a4 VARCHAR2 := fnd_api.g_miss_char
502 , p5_a5 DATE := fnd_api.g_miss_date
503 , p5_a6 DATE := fnd_api.g_miss_date
504 , p5_a7 NUMBER := 0-1962.0724
505 , p5_a8 NUMBER := 0-1962.0724
506 , p5_a9 DATE := fnd_api.g_miss_date
507 , p5_a10 NUMBER := 0-1962.0724
508 , p5_a11 DATE := fnd_api.g_miss_date
509 , p5_a12 NUMBER := 0-1962.0724
510 , p5_a13 NUMBER := 0-1962.0724
511 );
512 procedure delete_tmpt_set(p_api_version NUMBER
513 , p_init_msg_list VARCHAR2
514 , x_return_status out nocopy VARCHAR2
515 , x_msg_count out nocopy NUMBER
516 , x_msg_data out nocopy VARCHAR2
517 , p5_a0 JTF_NUMBER_TABLE
518 , p5_a1 JTF_NUMBER_TABLE
519 , p5_a2 JTF_VARCHAR2_TABLE_200
520 , p5_a3 JTF_VARCHAR2_TABLE_2000
521 , p5_a4 JTF_VARCHAR2_TABLE_100
522 , p5_a5 JTF_DATE_TABLE
523 , p5_a6 JTF_DATE_TABLE
524 , p5_a7 JTF_NUMBER_TABLE
525 , p5_a8 JTF_NUMBER_TABLE
526 , p5_a9 JTF_DATE_TABLE
527 , p5_a10 JTF_NUMBER_TABLE
528 , p5_a11 JTF_DATE_TABLE
529 , p5_a12 JTF_NUMBER_TABLE
530 , p5_a13 JTF_NUMBER_TABLE
531 );
532 procedure delete_tmpt_set(p_api_version NUMBER
533 , p_init_msg_list VARCHAR2
534 , x_return_status out nocopy VARCHAR2
535 , x_msg_count out nocopy NUMBER
536 , x_msg_data out nocopy VARCHAR2
537 , p5_a0 NUMBER := 0-1962.0724
538 , p5_a1 NUMBER := 0-1962.0724
539 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
540 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
541 , p5_a4 VARCHAR2 := fnd_api.g_miss_char
542 , p5_a5 DATE := fnd_api.g_miss_date
543 , p5_a6 DATE := fnd_api.g_miss_date
544 , p5_a7 NUMBER := 0-1962.0724
545 , p5_a8 NUMBER := 0-1962.0724
546 , p5_a9 DATE := fnd_api.g_miss_date
547 , p5_a10 NUMBER := 0-1962.0724
548 , p5_a11 DATE := fnd_api.g_miss_date
549 , p5_a12 NUMBER := 0-1962.0724
550 , p5_a13 NUMBER := 0-1962.0724
551 );
552 procedure create_template(p_api_version NUMBER
553 , p_init_msg_list VARCHAR2
554 , x_return_status out nocopy VARCHAR2
555 , x_msg_count out nocopy NUMBER
556 , x_msg_data out nocopy VARCHAR2
557 , p5_a0 JTF_NUMBER_TABLE
558 , p5_a1 JTF_NUMBER_TABLE
559 , p5_a2 JTF_NUMBER_TABLE
560 , p5_a3 JTF_NUMBER_TABLE
561 , p5_a4 JTF_NUMBER_TABLE
562 , p5_a5 JTF_NUMBER_TABLE
563 , p5_a6 JTF_NUMBER_TABLE
564 , p5_a7 JTF_VARCHAR2_TABLE_100
565 , p5_a8 JTF_VARCHAR2_TABLE_100
566 , p5_a9 JTF_VARCHAR2_TABLE_100
567 , p5_a10 JTF_VARCHAR2_TABLE_100
568 , p5_a11 JTF_VARCHAR2_TABLE_100
569 , p5_a12 JTF_VARCHAR2_TABLE_100
570 , p5_a13 JTF_VARCHAR2_TABLE_200
571 , p5_a14 JTF_VARCHAR2_TABLE_2000
572 , p5_a15 JTF_VARCHAR2_TABLE_100
573 , p5_a16 JTF_VARCHAR2_TABLE_100
574 , p5_a17 JTF_DATE_TABLE
575 , p5_a18 JTF_DATE_TABLE
576 , p5_a19 JTF_VARCHAR2_TABLE_100
577 , p5_a20 JTF_VARCHAR2_TABLE_100
578 , p5_a21 JTF_VARCHAR2_TABLE_500
579 , p5_a22 JTF_VARCHAR2_TABLE_500
580 , p5_a23 JTF_VARCHAR2_TABLE_500
581 , p5_a24 JTF_VARCHAR2_TABLE_500
582 , p5_a25 JTF_VARCHAR2_TABLE_500
583 , p5_a26 JTF_VARCHAR2_TABLE_500
584 , p5_a27 JTF_VARCHAR2_TABLE_500
585 , p5_a28 JTF_VARCHAR2_TABLE_500
586 , p5_a29 JTF_VARCHAR2_TABLE_500
587 , p5_a30 JTF_VARCHAR2_TABLE_500
588 , p5_a31 JTF_VARCHAR2_TABLE_500
589 , p5_a32 JTF_VARCHAR2_TABLE_500
590 , p5_a33 JTF_VARCHAR2_TABLE_500
591 , p5_a34 JTF_VARCHAR2_TABLE_500
592 , p5_a35 JTF_VARCHAR2_TABLE_500
593 , p5_a36 JTF_NUMBER_TABLE
594 , p5_a37 JTF_NUMBER_TABLE
595 , p5_a38 JTF_DATE_TABLE
596 , p5_a39 JTF_NUMBER_TABLE
597 , p5_a40 JTF_DATE_TABLE
598 , p5_a41 JTF_NUMBER_TABLE
599 , p5_a42 JTF_VARCHAR2_TABLE_100
600 , p6_a0 out nocopy JTF_NUMBER_TABLE
601 , p6_a1 out nocopy JTF_NUMBER_TABLE
602 , p6_a2 out nocopy JTF_NUMBER_TABLE
603 , p6_a3 out nocopy JTF_NUMBER_TABLE
604 , p6_a4 out nocopy JTF_NUMBER_TABLE
605 , p6_a5 out nocopy JTF_NUMBER_TABLE
606 , p6_a6 out nocopy JTF_NUMBER_TABLE
607 , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
608 , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
609 , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
610 , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
611 , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
612 , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
613 , p6_a13 out nocopy JTF_VARCHAR2_TABLE_200
614 , p6_a14 out nocopy JTF_VARCHAR2_TABLE_2000
615 , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
616 , p6_a16 out nocopy JTF_VARCHAR2_TABLE_100
617 , p6_a17 out nocopy JTF_DATE_TABLE
618 , p6_a18 out nocopy JTF_DATE_TABLE
619 , p6_a19 out nocopy JTF_VARCHAR2_TABLE_100
620 , p6_a20 out nocopy JTF_VARCHAR2_TABLE_100
621 , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
622 , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
623 , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
624 , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
625 , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
626 , p6_a26 out nocopy JTF_VARCHAR2_TABLE_500
627 , p6_a27 out nocopy JTF_VARCHAR2_TABLE_500
628 , p6_a28 out nocopy JTF_VARCHAR2_TABLE_500
629 , p6_a29 out nocopy JTF_VARCHAR2_TABLE_500
630 , p6_a30 out nocopy JTF_VARCHAR2_TABLE_500
631 , p6_a31 out nocopy JTF_VARCHAR2_TABLE_500
632 , p6_a32 out nocopy JTF_VARCHAR2_TABLE_500
633 , p6_a33 out nocopy JTF_VARCHAR2_TABLE_500
634 , p6_a34 out nocopy JTF_VARCHAR2_TABLE_500
635 , p6_a35 out nocopy JTF_VARCHAR2_TABLE_500
636 , p6_a36 out nocopy JTF_NUMBER_TABLE
637 , p6_a37 out nocopy JTF_NUMBER_TABLE
638 , p6_a38 out nocopy JTF_DATE_TABLE
639 , p6_a39 out nocopy JTF_NUMBER_TABLE
640 , p6_a40 out nocopy JTF_DATE_TABLE
641 , p6_a41 out nocopy JTF_NUMBER_TABLE
642 , p6_a42 out nocopy JTF_VARCHAR2_TABLE_100
643 );
644 procedure create_template(p_api_version NUMBER
645 , p_init_msg_list VARCHAR2
646 , x_return_status out nocopy VARCHAR2
647 , x_msg_count out nocopy NUMBER
648 , x_msg_data out nocopy VARCHAR2
649 , p6_a0 out nocopy NUMBER
650 , p6_a1 out nocopy NUMBER
651 , p6_a2 out nocopy NUMBER
652 , p6_a3 out nocopy NUMBER
653 , p6_a4 out nocopy NUMBER
654 , p6_a5 out nocopy NUMBER
655 , p6_a6 out nocopy NUMBER
656 , p6_a7 out nocopy VARCHAR2
657 , p6_a8 out nocopy VARCHAR2
658 , p6_a9 out nocopy VARCHAR2
659 , p6_a10 out nocopy VARCHAR2
660 , p6_a11 out nocopy VARCHAR2
661 , p6_a12 out nocopy VARCHAR2
662 , p6_a13 out nocopy VARCHAR2
663 , p6_a14 out nocopy VARCHAR2
664 , p6_a15 out nocopy VARCHAR2
665 , p6_a16 out nocopy VARCHAR2
666 , p6_a17 out nocopy DATE
667 , p6_a18 out nocopy DATE
668 , p6_a19 out nocopy VARCHAR2
669 , p6_a20 out nocopy VARCHAR2
670 , p6_a21 out nocopy VARCHAR2
671 , p6_a22 out nocopy VARCHAR2
672 , p6_a23 out nocopy VARCHAR2
673 , p6_a24 out nocopy VARCHAR2
674 , p6_a25 out nocopy VARCHAR2
675 , p6_a26 out nocopy VARCHAR2
676 , p6_a27 out nocopy VARCHAR2
677 , p6_a28 out nocopy VARCHAR2
678 , p6_a29 out nocopy VARCHAR2
679 , p6_a30 out nocopy VARCHAR2
680 , p6_a31 out nocopy VARCHAR2
681 , p6_a32 out nocopy VARCHAR2
682 , p6_a33 out nocopy VARCHAR2
683 , p6_a34 out nocopy VARCHAR2
684 , p6_a35 out nocopy VARCHAR2
685 , p6_a36 out nocopy NUMBER
686 , p6_a37 out nocopy NUMBER
687 , p6_a38 out nocopy DATE
688 , p6_a39 out nocopy NUMBER
689 , p6_a40 out nocopy DATE
690 , p6_a41 out nocopy NUMBER
691 , p6_a42 out nocopy VARCHAR2
692 , p5_a0 NUMBER := 0-1962.0724
693 , p5_a1 NUMBER := 0-1962.0724
694 , p5_a2 NUMBER := 0-1962.0724
695 , p5_a3 NUMBER := 0-1962.0724
696 , p5_a4 NUMBER := 0-1962.0724
697 , p5_a5 NUMBER := 0-1962.0724
698 , p5_a6 NUMBER := 0-1962.0724
699 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
700 , p5_a8 VARCHAR2 := fnd_api.g_miss_char
701 , p5_a9 VARCHAR2 := fnd_api.g_miss_char
702 , p5_a10 VARCHAR2 := fnd_api.g_miss_char
703 , p5_a11 VARCHAR2 := fnd_api.g_miss_char
704 , p5_a12 VARCHAR2 := fnd_api.g_miss_char
705 , p5_a13 VARCHAR2 := fnd_api.g_miss_char
706 , p5_a14 VARCHAR2 := fnd_api.g_miss_char
707 , p5_a15 VARCHAR2 := fnd_api.g_miss_char
708 , p5_a16 VARCHAR2 := fnd_api.g_miss_char
709 , p5_a17 DATE := fnd_api.g_miss_date
710 , p5_a18 DATE := fnd_api.g_miss_date
711 , p5_a19 VARCHAR2 := fnd_api.g_miss_char
712 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
713 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
714 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
715 , p5_a23 VARCHAR2 := fnd_api.g_miss_char
716 , p5_a24 VARCHAR2 := fnd_api.g_miss_char
717 , p5_a25 VARCHAR2 := fnd_api.g_miss_char
718 , p5_a26 VARCHAR2 := fnd_api.g_miss_char
719 , p5_a27 VARCHAR2 := fnd_api.g_miss_char
720 , p5_a28 VARCHAR2 := fnd_api.g_miss_char
721 , p5_a29 VARCHAR2 := fnd_api.g_miss_char
722 , p5_a30 VARCHAR2 := fnd_api.g_miss_char
723 , p5_a31 VARCHAR2 := fnd_api.g_miss_char
724 , p5_a32 VARCHAR2 := fnd_api.g_miss_char
725 , p5_a33 VARCHAR2 := fnd_api.g_miss_char
726 , p5_a34 VARCHAR2 := fnd_api.g_miss_char
727 , p5_a35 VARCHAR2 := fnd_api.g_miss_char
728 , p5_a36 NUMBER := 0-1962.0724
729 , p5_a37 NUMBER := 0-1962.0724
730 , p5_a38 DATE := fnd_api.g_miss_date
731 , p5_a39 NUMBER := 0-1962.0724
732 , p5_a40 DATE := fnd_api.g_miss_date
733 , p5_a41 NUMBER := 0-1962.0724
734 , p5_a42 VARCHAR2 := fnd_api.g_miss_char
735 );
736 procedure update_template(p_api_version NUMBER
737 , p_init_msg_list VARCHAR2
738 , x_return_status out nocopy VARCHAR2
739 , x_msg_count out nocopy NUMBER
740 , x_msg_data out nocopy VARCHAR2
741 , p5_a0 JTF_NUMBER_TABLE
742 , p5_a1 JTF_NUMBER_TABLE
743 , p5_a2 JTF_NUMBER_TABLE
744 , p5_a3 JTF_NUMBER_TABLE
745 , p5_a4 JTF_NUMBER_TABLE
746 , p5_a5 JTF_NUMBER_TABLE
747 , p5_a6 JTF_NUMBER_TABLE
748 , p5_a7 JTF_VARCHAR2_TABLE_100
749 , p5_a8 JTF_VARCHAR2_TABLE_100
750 , p5_a9 JTF_VARCHAR2_TABLE_100
751 , p5_a10 JTF_VARCHAR2_TABLE_100
752 , p5_a11 JTF_VARCHAR2_TABLE_100
753 , p5_a12 JTF_VARCHAR2_TABLE_100
754 , p5_a13 JTF_VARCHAR2_TABLE_200
755 , p5_a14 JTF_VARCHAR2_TABLE_2000
756 , p5_a15 JTF_VARCHAR2_TABLE_100
757 , p5_a16 JTF_VARCHAR2_TABLE_100
758 , p5_a17 JTF_DATE_TABLE
759 , p5_a18 JTF_DATE_TABLE
760 , p5_a19 JTF_VARCHAR2_TABLE_100
761 , p5_a20 JTF_VARCHAR2_TABLE_100
762 , p5_a21 JTF_VARCHAR2_TABLE_500
763 , p5_a22 JTF_VARCHAR2_TABLE_500
764 , p5_a23 JTF_VARCHAR2_TABLE_500
765 , p5_a24 JTF_VARCHAR2_TABLE_500
766 , p5_a25 JTF_VARCHAR2_TABLE_500
767 , p5_a26 JTF_VARCHAR2_TABLE_500
768 , p5_a27 JTF_VARCHAR2_TABLE_500
769 , p5_a28 JTF_VARCHAR2_TABLE_500
770 , p5_a29 JTF_VARCHAR2_TABLE_500
771 , p5_a30 JTF_VARCHAR2_TABLE_500
772 , p5_a31 JTF_VARCHAR2_TABLE_500
773 , p5_a32 JTF_VARCHAR2_TABLE_500
774 , p5_a33 JTF_VARCHAR2_TABLE_500
775 , p5_a34 JTF_VARCHAR2_TABLE_500
776 , p5_a35 JTF_VARCHAR2_TABLE_500
777 , p5_a36 JTF_NUMBER_TABLE
778 , p5_a37 JTF_NUMBER_TABLE
779 , p5_a38 JTF_DATE_TABLE
780 , p5_a39 JTF_NUMBER_TABLE
781 , p5_a40 JTF_DATE_TABLE
782 , p5_a41 JTF_NUMBER_TABLE
783 , p5_a42 JTF_VARCHAR2_TABLE_100
784 , p6_a0 out nocopy JTF_NUMBER_TABLE
785 , p6_a1 out nocopy JTF_NUMBER_TABLE
786 , p6_a2 out nocopy JTF_NUMBER_TABLE
787 , p6_a3 out nocopy JTF_NUMBER_TABLE
788 , p6_a4 out nocopy JTF_NUMBER_TABLE
789 , p6_a5 out nocopy JTF_NUMBER_TABLE
790 , p6_a6 out nocopy JTF_NUMBER_TABLE
791 , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
792 , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
793 , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
794 , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
795 , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
796 , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
797 , p6_a13 out nocopy JTF_VARCHAR2_TABLE_200
798 , p6_a14 out nocopy JTF_VARCHAR2_TABLE_2000
799 , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
800 , p6_a16 out nocopy JTF_VARCHAR2_TABLE_100
801 , p6_a17 out nocopy JTF_DATE_TABLE
802 , p6_a18 out nocopy JTF_DATE_TABLE
803 , p6_a19 out nocopy JTF_VARCHAR2_TABLE_100
804 , p6_a20 out nocopy JTF_VARCHAR2_TABLE_100
805 , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
806 , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
807 , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
808 , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
809 , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
810 , p6_a26 out nocopy JTF_VARCHAR2_TABLE_500
811 , p6_a27 out nocopy JTF_VARCHAR2_TABLE_500
812 , p6_a28 out nocopy JTF_VARCHAR2_TABLE_500
813 , p6_a29 out nocopy JTF_VARCHAR2_TABLE_500
814 , p6_a30 out nocopy JTF_VARCHAR2_TABLE_500
815 , p6_a31 out nocopy JTF_VARCHAR2_TABLE_500
816 , p6_a32 out nocopy JTF_VARCHAR2_TABLE_500
817 , p6_a33 out nocopy JTF_VARCHAR2_TABLE_500
818 , p6_a34 out nocopy JTF_VARCHAR2_TABLE_500
819 , p6_a35 out nocopy JTF_VARCHAR2_TABLE_500
820 , p6_a36 out nocopy JTF_NUMBER_TABLE
821 , p6_a37 out nocopy JTF_NUMBER_TABLE
822 , p6_a38 out nocopy JTF_DATE_TABLE
823 , p6_a39 out nocopy JTF_NUMBER_TABLE
824 , p6_a40 out nocopy JTF_DATE_TABLE
825 , p6_a41 out nocopy JTF_NUMBER_TABLE
826 , p6_a42 out nocopy JTF_VARCHAR2_TABLE_100
827 );
828 procedure update_template(p_api_version NUMBER
829 , p_init_msg_list VARCHAR2
830 , x_return_status out nocopy VARCHAR2
831 , x_msg_count out nocopy NUMBER
832 , x_msg_data out nocopy VARCHAR2
833 , p6_a0 out nocopy NUMBER
834 , p6_a1 out nocopy NUMBER
835 , p6_a2 out nocopy NUMBER
836 , p6_a3 out nocopy NUMBER
837 , p6_a4 out nocopy NUMBER
838 , p6_a5 out nocopy NUMBER
839 , p6_a6 out nocopy NUMBER
840 , p6_a7 out nocopy VARCHAR2
841 , p6_a8 out nocopy VARCHAR2
842 , p6_a9 out nocopy VARCHAR2
843 , p6_a10 out nocopy VARCHAR2
844 , p6_a11 out nocopy VARCHAR2
845 , p6_a12 out nocopy VARCHAR2
846 , p6_a13 out nocopy VARCHAR2
847 , p6_a14 out nocopy VARCHAR2
848 , p6_a15 out nocopy VARCHAR2
849 , p6_a16 out nocopy VARCHAR2
850 , p6_a17 out nocopy DATE
851 , p6_a18 out nocopy DATE
852 , p6_a19 out nocopy VARCHAR2
853 , p6_a20 out nocopy VARCHAR2
854 , p6_a21 out nocopy VARCHAR2
855 , p6_a22 out nocopy VARCHAR2
856 , p6_a23 out nocopy VARCHAR2
857 , p6_a24 out nocopy VARCHAR2
858 , p6_a25 out nocopy VARCHAR2
859 , p6_a26 out nocopy VARCHAR2
860 , p6_a27 out nocopy VARCHAR2
861 , p6_a28 out nocopy VARCHAR2
862 , p6_a29 out nocopy VARCHAR2
863 , p6_a30 out nocopy VARCHAR2
864 , p6_a31 out nocopy VARCHAR2
865 , p6_a32 out nocopy VARCHAR2
866 , p6_a33 out nocopy VARCHAR2
867 , p6_a34 out nocopy VARCHAR2
868 , p6_a35 out nocopy VARCHAR2
869 , p6_a36 out nocopy NUMBER
870 , p6_a37 out nocopy NUMBER
871 , p6_a38 out nocopy DATE
872 , p6_a39 out nocopy NUMBER
873 , p6_a40 out nocopy DATE
874 , p6_a41 out nocopy NUMBER
875 , p6_a42 out nocopy VARCHAR2
876 , p5_a0 NUMBER := 0-1962.0724
877 , p5_a1 NUMBER := 0-1962.0724
878 , p5_a2 NUMBER := 0-1962.0724
879 , p5_a3 NUMBER := 0-1962.0724
880 , p5_a4 NUMBER := 0-1962.0724
881 , p5_a5 NUMBER := 0-1962.0724
882 , p5_a6 NUMBER := 0-1962.0724
883 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
884 , p5_a8 VARCHAR2 := fnd_api.g_miss_char
885 , p5_a9 VARCHAR2 := fnd_api.g_miss_char
886 , p5_a10 VARCHAR2 := fnd_api.g_miss_char
887 , p5_a11 VARCHAR2 := fnd_api.g_miss_char
888 , p5_a12 VARCHAR2 := fnd_api.g_miss_char
889 , p5_a13 VARCHAR2 := fnd_api.g_miss_char
890 , p5_a14 VARCHAR2 := fnd_api.g_miss_char
891 , p5_a15 VARCHAR2 := fnd_api.g_miss_char
892 , p5_a16 VARCHAR2 := fnd_api.g_miss_char
893 , p5_a17 DATE := fnd_api.g_miss_date
894 , p5_a18 DATE := fnd_api.g_miss_date
895 , p5_a19 VARCHAR2 := fnd_api.g_miss_char
896 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
897 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
898 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
899 , p5_a23 VARCHAR2 := fnd_api.g_miss_char
900 , p5_a24 VARCHAR2 := fnd_api.g_miss_char
901 , p5_a25 VARCHAR2 := fnd_api.g_miss_char
902 , p5_a26 VARCHAR2 := fnd_api.g_miss_char
903 , p5_a27 VARCHAR2 := fnd_api.g_miss_char
904 , p5_a28 VARCHAR2 := fnd_api.g_miss_char
905 , p5_a29 VARCHAR2 := fnd_api.g_miss_char
906 , p5_a30 VARCHAR2 := fnd_api.g_miss_char
907 , p5_a31 VARCHAR2 := fnd_api.g_miss_char
908 , p5_a32 VARCHAR2 := fnd_api.g_miss_char
909 , p5_a33 VARCHAR2 := fnd_api.g_miss_char
910 , p5_a34 VARCHAR2 := fnd_api.g_miss_char
911 , p5_a35 VARCHAR2 := fnd_api.g_miss_char
912 , p5_a36 NUMBER := 0-1962.0724
913 , p5_a37 NUMBER := 0-1962.0724
914 , p5_a38 DATE := fnd_api.g_miss_date
915 , p5_a39 NUMBER := 0-1962.0724
916 , p5_a40 DATE := fnd_api.g_miss_date
917 , p5_a41 NUMBER := 0-1962.0724
918 , p5_a42 VARCHAR2 := fnd_api.g_miss_char
919 );
920 procedure delete_template(p_api_version NUMBER
921 , p_init_msg_list VARCHAR2
922 , x_return_status out nocopy VARCHAR2
923 , x_msg_count out nocopy NUMBER
924 , x_msg_data out nocopy VARCHAR2
925 , p5_a0 JTF_NUMBER_TABLE
926 , p5_a1 JTF_NUMBER_TABLE
927 , p5_a2 JTF_NUMBER_TABLE
928 , p5_a3 JTF_NUMBER_TABLE
929 , p5_a4 JTF_NUMBER_TABLE
930 , p5_a5 JTF_NUMBER_TABLE
931 , p5_a6 JTF_NUMBER_TABLE
932 , p5_a7 JTF_VARCHAR2_TABLE_100
933 , p5_a8 JTF_VARCHAR2_TABLE_100
934 , p5_a9 JTF_VARCHAR2_TABLE_100
935 , p5_a10 JTF_VARCHAR2_TABLE_100
936 , p5_a11 JTF_VARCHAR2_TABLE_100
937 , p5_a12 JTF_VARCHAR2_TABLE_100
938 , p5_a13 JTF_VARCHAR2_TABLE_200
939 , p5_a14 JTF_VARCHAR2_TABLE_2000
940 , p5_a15 JTF_VARCHAR2_TABLE_100
941 , p5_a16 JTF_VARCHAR2_TABLE_100
942 , p5_a17 JTF_DATE_TABLE
943 , p5_a18 JTF_DATE_TABLE
944 , p5_a19 JTF_VARCHAR2_TABLE_100
945 , p5_a20 JTF_VARCHAR2_TABLE_100
946 , p5_a21 JTF_VARCHAR2_TABLE_500
947 , p5_a22 JTF_VARCHAR2_TABLE_500
948 , p5_a23 JTF_VARCHAR2_TABLE_500
949 , p5_a24 JTF_VARCHAR2_TABLE_500
950 , p5_a25 JTF_VARCHAR2_TABLE_500
951 , p5_a26 JTF_VARCHAR2_TABLE_500
952 , p5_a27 JTF_VARCHAR2_TABLE_500
953 , p5_a28 JTF_VARCHAR2_TABLE_500
954 , p5_a29 JTF_VARCHAR2_TABLE_500
955 , p5_a30 JTF_VARCHAR2_TABLE_500
956 , p5_a31 JTF_VARCHAR2_TABLE_500
957 , p5_a32 JTF_VARCHAR2_TABLE_500
958 , p5_a33 JTF_VARCHAR2_TABLE_500
959 , p5_a34 JTF_VARCHAR2_TABLE_500
960 , p5_a35 JTF_VARCHAR2_TABLE_500
961 , p5_a36 JTF_NUMBER_TABLE
962 , p5_a37 JTF_NUMBER_TABLE
963 , p5_a38 JTF_DATE_TABLE
964 , p5_a39 JTF_NUMBER_TABLE
965 , p5_a40 JTF_DATE_TABLE
966 , p5_a41 JTF_NUMBER_TABLE
967 , p5_a42 JTF_VARCHAR2_TABLE_100
968 );
969 procedure delete_template(p_api_version NUMBER
970 , p_init_msg_list VARCHAR2
971 , x_return_status out nocopy VARCHAR2
972 , x_msg_count out nocopy NUMBER
973 , x_msg_data out nocopy VARCHAR2
974 , p5_a0 NUMBER := 0-1962.0724
975 , p5_a1 NUMBER := 0-1962.0724
976 , p5_a2 NUMBER := 0-1962.0724
977 , p5_a3 NUMBER := 0-1962.0724
978 , p5_a4 NUMBER := 0-1962.0724
979 , p5_a5 NUMBER := 0-1962.0724
980 , p5_a6 NUMBER := 0-1962.0724
981 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
982 , p5_a8 VARCHAR2 := fnd_api.g_miss_char
983 , p5_a9 VARCHAR2 := fnd_api.g_miss_char
984 , p5_a10 VARCHAR2 := fnd_api.g_miss_char
985 , p5_a11 VARCHAR2 := fnd_api.g_miss_char
986 , p5_a12 VARCHAR2 := fnd_api.g_miss_char
987 , p5_a13 VARCHAR2 := fnd_api.g_miss_char
988 , p5_a14 VARCHAR2 := fnd_api.g_miss_char
989 , p5_a15 VARCHAR2 := fnd_api.g_miss_char
990 , p5_a16 VARCHAR2 := fnd_api.g_miss_char
991 , p5_a17 DATE := fnd_api.g_miss_date
992 , p5_a18 DATE := fnd_api.g_miss_date
993 , p5_a19 VARCHAR2 := fnd_api.g_miss_char
994 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
995 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
996 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
997 , p5_a23 VARCHAR2 := fnd_api.g_miss_char
998 , p5_a24 VARCHAR2 := fnd_api.g_miss_char
999 , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1000 , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1001 , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1002 , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1003 , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1004 , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1005 , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1006 , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1007 , p5_a33 VARCHAR2 := fnd_api.g_miss_char
1008 , p5_a34 VARCHAR2 := fnd_api.g_miss_char
1009 , p5_a35 VARCHAR2 := fnd_api.g_miss_char
1010 , p5_a36 NUMBER := 0-1962.0724
1011 , p5_a37 NUMBER := 0-1962.0724
1012 , p5_a38 DATE := fnd_api.g_miss_date
1013 , p5_a39 NUMBER := 0-1962.0724
1014 , p5_a40 DATE := fnd_api.g_miss_date
1015 , p5_a41 NUMBER := 0-1962.0724
1016 , p5_a42 VARCHAR2 := fnd_api.g_miss_char
1017 );
1018 procedure create_tmpt_lines(p_api_version NUMBER
1019 , p_init_msg_list VARCHAR2
1020 , x_return_status out nocopy VARCHAR2
1021 , x_msg_count out nocopy NUMBER
1022 , x_msg_data out nocopy VARCHAR2
1023 , p5_a0 JTF_NUMBER_TABLE
1024 , p5_a1 JTF_NUMBER_TABLE
1025 , p5_a2 JTF_NUMBER_TABLE
1026 , p5_a3 JTF_VARCHAR2_TABLE_100
1027 , p5_a4 JTF_NUMBER_TABLE
1028 , p5_a5 JTF_VARCHAR2_TABLE_100
1029 , p5_a6 JTF_NUMBER_TABLE
1030 , p5_a7 JTF_VARCHAR2_TABLE_2000
1031 , p5_a8 JTF_NUMBER_TABLE
1032 , p5_a9 JTF_VARCHAR2_TABLE_100
1033 , p5_a10 JTF_VARCHAR2_TABLE_100
1034 , p5_a11 JTF_VARCHAR2_TABLE_500
1035 , p5_a12 JTF_VARCHAR2_TABLE_500
1036 , p5_a13 JTF_VARCHAR2_TABLE_500
1037 , p5_a14 JTF_VARCHAR2_TABLE_500
1038 , p5_a15 JTF_VARCHAR2_TABLE_500
1039 , p5_a16 JTF_VARCHAR2_TABLE_500
1040 , p5_a17 JTF_VARCHAR2_TABLE_500
1041 , p5_a18 JTF_VARCHAR2_TABLE_500
1042 , p5_a19 JTF_VARCHAR2_TABLE_500
1043 , p5_a20 JTF_VARCHAR2_TABLE_500
1044 , p5_a21 JTF_VARCHAR2_TABLE_500
1045 , p5_a22 JTF_VARCHAR2_TABLE_500
1046 , p5_a23 JTF_VARCHAR2_TABLE_500
1047 , p5_a24 JTF_VARCHAR2_TABLE_500
1048 , p5_a25 JTF_VARCHAR2_TABLE_500
1049 , p5_a26 JTF_NUMBER_TABLE
1050 , p5_a27 JTF_NUMBER_TABLE
1051 , p5_a28 JTF_NUMBER_TABLE
1052 , p5_a29 JTF_DATE_TABLE
1053 , p5_a30 JTF_NUMBER_TABLE
1054 , p5_a31 JTF_DATE_TABLE
1055 , p5_a32 JTF_NUMBER_TABLE
1056 , p6_a0 out nocopy JTF_NUMBER_TABLE
1057 , p6_a1 out nocopy JTF_NUMBER_TABLE
1058 , p6_a2 out nocopy JTF_NUMBER_TABLE
1059 , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
1060 , p6_a4 out nocopy JTF_NUMBER_TABLE
1061 , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
1062 , p6_a6 out nocopy JTF_NUMBER_TABLE
1063 , p6_a7 out nocopy JTF_VARCHAR2_TABLE_2000
1064 , p6_a8 out nocopy JTF_NUMBER_TABLE
1065 , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
1066 , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
1067 , p6_a11 out nocopy JTF_VARCHAR2_TABLE_500
1068 , p6_a12 out nocopy JTF_VARCHAR2_TABLE_500
1069 , p6_a13 out nocopy JTF_VARCHAR2_TABLE_500
1070 , p6_a14 out nocopy JTF_VARCHAR2_TABLE_500
1071 , p6_a15 out nocopy JTF_VARCHAR2_TABLE_500
1072 , p6_a16 out nocopy JTF_VARCHAR2_TABLE_500
1073 , p6_a17 out nocopy JTF_VARCHAR2_TABLE_500
1074 , p6_a18 out nocopy JTF_VARCHAR2_TABLE_500
1075 , p6_a19 out nocopy JTF_VARCHAR2_TABLE_500
1076 , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
1077 , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
1078 , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
1079 , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
1080 , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
1081 , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
1082 , p6_a26 out nocopy JTF_NUMBER_TABLE
1083 , p6_a27 out nocopy JTF_NUMBER_TABLE
1084 , p6_a28 out nocopy JTF_NUMBER_TABLE
1085 , p6_a29 out nocopy JTF_DATE_TABLE
1086 , p6_a30 out nocopy JTF_NUMBER_TABLE
1087 , p6_a31 out nocopy JTF_DATE_TABLE
1088 , p6_a32 out nocopy JTF_NUMBER_TABLE
1089 );
1090 procedure create_tmpt_lines(p_api_version NUMBER
1091 , p_init_msg_list VARCHAR2
1092 , x_return_status out nocopy VARCHAR2
1093 , x_msg_count out nocopy NUMBER
1094 , x_msg_data out nocopy VARCHAR2
1095 , p6_a0 out nocopy NUMBER
1096 , p6_a1 out nocopy NUMBER
1097 , p6_a2 out nocopy NUMBER
1098 , p6_a3 out nocopy VARCHAR2
1099 , p6_a4 out nocopy NUMBER
1100 , p6_a5 out nocopy VARCHAR2
1101 , p6_a6 out nocopy NUMBER
1102 , p6_a7 out nocopy VARCHAR2
1103 , p6_a8 out nocopy NUMBER
1104 , p6_a9 out nocopy VARCHAR2
1105 , p6_a10 out nocopy VARCHAR2
1106 , p6_a11 out nocopy VARCHAR2
1107 , p6_a12 out nocopy VARCHAR2
1108 , p6_a13 out nocopy VARCHAR2
1109 , p6_a14 out nocopy VARCHAR2
1110 , p6_a15 out nocopy VARCHAR2
1111 , p6_a16 out nocopy VARCHAR2
1112 , p6_a17 out nocopy VARCHAR2
1113 , p6_a18 out nocopy VARCHAR2
1114 , p6_a19 out nocopy VARCHAR2
1115 , p6_a20 out nocopy VARCHAR2
1116 , p6_a21 out nocopy VARCHAR2
1117 , p6_a22 out nocopy VARCHAR2
1118 , p6_a23 out nocopy VARCHAR2
1119 , p6_a24 out nocopy VARCHAR2
1120 , p6_a25 out nocopy VARCHAR2
1121 , p6_a26 out nocopy NUMBER
1122 , p6_a27 out nocopy NUMBER
1123 , p6_a28 out nocopy NUMBER
1124 , p6_a29 out nocopy DATE
1125 , p6_a30 out nocopy NUMBER
1126 , p6_a31 out nocopy DATE
1127 , p6_a32 out nocopy NUMBER
1128 , p5_a0 NUMBER := 0-1962.0724
1129 , p5_a1 NUMBER := 0-1962.0724
1130 , p5_a2 NUMBER := 0-1962.0724
1131 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1132 , p5_a4 NUMBER := 0-1962.0724
1133 , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1134 , p5_a6 NUMBER := 0-1962.0724
1135 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1136 , p5_a8 NUMBER := 0-1962.0724
1137 , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1138 , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1139 , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1140 , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1141 , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1142 , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1143 , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1144 , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1145 , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1146 , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1147 , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1148 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1149 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1150 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1151 , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1152 , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1153 , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1154 , p5_a26 NUMBER := 0-1962.0724
1155 , p5_a27 NUMBER := 0-1962.0724
1156 , p5_a28 NUMBER := 0-1962.0724
1157 , p5_a29 DATE := fnd_api.g_miss_date
1158 , p5_a30 NUMBER := 0-1962.0724
1159 , p5_a31 DATE := fnd_api.g_miss_date
1160 , p5_a32 NUMBER := 0-1962.0724
1161 );
1162 procedure update_tmpt_lines(p_api_version NUMBER
1163 , p_init_msg_list VARCHAR2
1164 , x_return_status out nocopy VARCHAR2
1165 , x_msg_count out nocopy NUMBER
1166 , x_msg_data out nocopy VARCHAR2
1167 , p5_a0 JTF_NUMBER_TABLE
1168 , p5_a1 JTF_NUMBER_TABLE
1169 , p5_a2 JTF_NUMBER_TABLE
1170 , p5_a3 JTF_VARCHAR2_TABLE_100
1171 , p5_a4 JTF_NUMBER_TABLE
1172 , p5_a5 JTF_VARCHAR2_TABLE_100
1173 , p5_a6 JTF_NUMBER_TABLE
1174 , p5_a7 JTF_VARCHAR2_TABLE_2000
1175 , p5_a8 JTF_NUMBER_TABLE
1176 , p5_a9 JTF_VARCHAR2_TABLE_100
1177 , p5_a10 JTF_VARCHAR2_TABLE_100
1178 , p5_a11 JTF_VARCHAR2_TABLE_500
1179 , p5_a12 JTF_VARCHAR2_TABLE_500
1180 , p5_a13 JTF_VARCHAR2_TABLE_500
1181 , p5_a14 JTF_VARCHAR2_TABLE_500
1182 , p5_a15 JTF_VARCHAR2_TABLE_500
1183 , p5_a16 JTF_VARCHAR2_TABLE_500
1184 , p5_a17 JTF_VARCHAR2_TABLE_500
1185 , p5_a18 JTF_VARCHAR2_TABLE_500
1186 , p5_a19 JTF_VARCHAR2_TABLE_500
1187 , p5_a20 JTF_VARCHAR2_TABLE_500
1188 , p5_a21 JTF_VARCHAR2_TABLE_500
1189 , p5_a22 JTF_VARCHAR2_TABLE_500
1190 , p5_a23 JTF_VARCHAR2_TABLE_500
1191 , p5_a24 JTF_VARCHAR2_TABLE_500
1192 , p5_a25 JTF_VARCHAR2_TABLE_500
1193 , p5_a26 JTF_NUMBER_TABLE
1194 , p5_a27 JTF_NUMBER_TABLE
1195 , p5_a28 JTF_NUMBER_TABLE
1196 , p5_a29 JTF_DATE_TABLE
1197 , p5_a30 JTF_NUMBER_TABLE
1198 , p5_a31 JTF_DATE_TABLE
1199 , p5_a32 JTF_NUMBER_TABLE
1200 , p6_a0 out nocopy JTF_NUMBER_TABLE
1201 , p6_a1 out nocopy JTF_NUMBER_TABLE
1202 , p6_a2 out nocopy JTF_NUMBER_TABLE
1203 , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
1204 , p6_a4 out nocopy JTF_NUMBER_TABLE
1205 , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
1206 , p6_a6 out nocopy JTF_NUMBER_TABLE
1207 , p6_a7 out nocopy JTF_VARCHAR2_TABLE_2000
1208 , p6_a8 out nocopy JTF_NUMBER_TABLE
1209 , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
1210 , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
1211 , p6_a11 out nocopy JTF_VARCHAR2_TABLE_500
1212 , p6_a12 out nocopy JTF_VARCHAR2_TABLE_500
1213 , p6_a13 out nocopy JTF_VARCHAR2_TABLE_500
1214 , p6_a14 out nocopy JTF_VARCHAR2_TABLE_500
1215 , p6_a15 out nocopy JTF_VARCHAR2_TABLE_500
1216 , p6_a16 out nocopy JTF_VARCHAR2_TABLE_500
1217 , p6_a17 out nocopy JTF_VARCHAR2_TABLE_500
1218 , p6_a18 out nocopy JTF_VARCHAR2_TABLE_500
1219 , p6_a19 out nocopy JTF_VARCHAR2_TABLE_500
1220 , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
1221 , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
1222 , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
1223 , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
1224 , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
1225 , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
1226 , p6_a26 out nocopy JTF_NUMBER_TABLE
1227 , p6_a27 out nocopy JTF_NUMBER_TABLE
1228 , p6_a28 out nocopy JTF_NUMBER_TABLE
1229 , p6_a29 out nocopy JTF_DATE_TABLE
1230 , p6_a30 out nocopy JTF_NUMBER_TABLE
1231 , p6_a31 out nocopy JTF_DATE_TABLE
1232 , p6_a32 out nocopy JTF_NUMBER_TABLE
1233 );
1234 procedure update_tmpt_lines(p_api_version NUMBER
1235 , p_init_msg_list VARCHAR2
1236 , x_return_status out nocopy VARCHAR2
1237 , x_msg_count out nocopy NUMBER
1238 , x_msg_data out nocopy VARCHAR2
1239 , p6_a0 out nocopy NUMBER
1240 , p6_a1 out nocopy NUMBER
1241 , p6_a2 out nocopy NUMBER
1242 , p6_a3 out nocopy VARCHAR2
1243 , p6_a4 out nocopy NUMBER
1244 , p6_a5 out nocopy VARCHAR2
1245 , p6_a6 out nocopy NUMBER
1246 , p6_a7 out nocopy VARCHAR2
1247 , p6_a8 out nocopy NUMBER
1248 , p6_a9 out nocopy VARCHAR2
1249 , p6_a10 out nocopy VARCHAR2
1250 , p6_a11 out nocopy VARCHAR2
1251 , p6_a12 out nocopy VARCHAR2
1252 , p6_a13 out nocopy VARCHAR2
1253 , p6_a14 out nocopy VARCHAR2
1254 , p6_a15 out nocopy VARCHAR2
1255 , p6_a16 out nocopy VARCHAR2
1256 , p6_a17 out nocopy VARCHAR2
1257 , p6_a18 out nocopy VARCHAR2
1258 , p6_a19 out nocopy VARCHAR2
1259 , p6_a20 out nocopy VARCHAR2
1260 , p6_a21 out nocopy VARCHAR2
1261 , p6_a22 out nocopy VARCHAR2
1262 , p6_a23 out nocopy VARCHAR2
1263 , p6_a24 out nocopy VARCHAR2
1264 , p6_a25 out nocopy VARCHAR2
1265 , p6_a26 out nocopy NUMBER
1266 , p6_a27 out nocopy NUMBER
1267 , p6_a28 out nocopy NUMBER
1268 , p6_a29 out nocopy DATE
1269 , p6_a30 out nocopy NUMBER
1270 , p6_a31 out nocopy DATE
1271 , p6_a32 out nocopy NUMBER
1272 , p5_a0 NUMBER := 0-1962.0724
1273 , p5_a1 NUMBER := 0-1962.0724
1274 , p5_a2 NUMBER := 0-1962.0724
1275 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1276 , p5_a4 NUMBER := 0-1962.0724
1277 , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1278 , p5_a6 NUMBER := 0-1962.0724
1279 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1280 , p5_a8 NUMBER := 0-1962.0724
1281 , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1282 , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1283 , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1284 , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1285 , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1286 , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1287 , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1288 , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1289 , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1290 , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1291 , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1292 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1293 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1294 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1295 , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1296 , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1297 , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1298 , p5_a26 NUMBER := 0-1962.0724
1299 , p5_a27 NUMBER := 0-1962.0724
1300 , p5_a28 NUMBER := 0-1962.0724
1301 , p5_a29 DATE := fnd_api.g_miss_date
1302 , p5_a30 NUMBER := 0-1962.0724
1303 , p5_a31 DATE := fnd_api.g_miss_date
1304 , p5_a32 NUMBER := 0-1962.0724
1305 );
1306 procedure delete_tmpt_lines(p_api_version NUMBER
1307 , p_init_msg_list VARCHAR2
1308 , x_return_status out nocopy VARCHAR2
1309 , x_msg_count out nocopy NUMBER
1310 , x_msg_data out nocopy VARCHAR2
1311 , p5_a0 JTF_NUMBER_TABLE
1312 , p5_a1 JTF_NUMBER_TABLE
1313 , p5_a2 JTF_NUMBER_TABLE
1314 , p5_a3 JTF_VARCHAR2_TABLE_100
1315 , p5_a4 JTF_NUMBER_TABLE
1316 , p5_a5 JTF_VARCHAR2_TABLE_100
1317 , p5_a6 JTF_NUMBER_TABLE
1318 , p5_a7 JTF_VARCHAR2_TABLE_2000
1319 , p5_a8 JTF_NUMBER_TABLE
1320 , p5_a9 JTF_VARCHAR2_TABLE_100
1321 , p5_a10 JTF_VARCHAR2_TABLE_100
1322 , p5_a11 JTF_VARCHAR2_TABLE_500
1323 , p5_a12 JTF_VARCHAR2_TABLE_500
1324 , p5_a13 JTF_VARCHAR2_TABLE_500
1325 , p5_a14 JTF_VARCHAR2_TABLE_500
1326 , p5_a15 JTF_VARCHAR2_TABLE_500
1327 , p5_a16 JTF_VARCHAR2_TABLE_500
1328 , p5_a17 JTF_VARCHAR2_TABLE_500
1329 , p5_a18 JTF_VARCHAR2_TABLE_500
1330 , p5_a19 JTF_VARCHAR2_TABLE_500
1331 , p5_a20 JTF_VARCHAR2_TABLE_500
1332 , p5_a21 JTF_VARCHAR2_TABLE_500
1333 , p5_a22 JTF_VARCHAR2_TABLE_500
1334 , p5_a23 JTF_VARCHAR2_TABLE_500
1335 , p5_a24 JTF_VARCHAR2_TABLE_500
1336 , p5_a25 JTF_VARCHAR2_TABLE_500
1337 , p5_a26 JTF_NUMBER_TABLE
1338 , p5_a27 JTF_NUMBER_TABLE
1339 , p5_a28 JTF_NUMBER_TABLE
1340 , p5_a29 JTF_DATE_TABLE
1341 , p5_a30 JTF_NUMBER_TABLE
1342 , p5_a31 JTF_DATE_TABLE
1343 , p5_a32 JTF_NUMBER_TABLE
1344 );
1345 procedure delete_tmpt_lines(p_api_version NUMBER
1346 , p_init_msg_list VARCHAR2
1347 , x_return_status out nocopy VARCHAR2
1348 , x_msg_count out nocopy NUMBER
1349 , x_msg_data out nocopy VARCHAR2
1350 , p5_a0 NUMBER := 0-1962.0724
1351 , p5_a1 NUMBER := 0-1962.0724
1352 , p5_a2 NUMBER := 0-1962.0724
1353 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1354 , p5_a4 NUMBER := 0-1962.0724
1355 , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1356 , p5_a6 NUMBER := 0-1962.0724
1357 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1358 , p5_a8 NUMBER := 0-1962.0724
1359 , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1360 , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1361 , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1362 , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1363 , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1364 , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1365 , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1366 , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1367 , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1368 , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1369 , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1370 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1371 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1372 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1373 , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1374 , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1375 , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1376 , p5_a26 NUMBER := 0-1962.0724
1377 , p5_a27 NUMBER := 0-1962.0724
1378 , p5_a28 NUMBER := 0-1962.0724
1379 , p5_a29 DATE := fnd_api.g_miss_date
1380 , p5_a30 NUMBER := 0-1962.0724
1381 , p5_a31 DATE := fnd_api.g_miss_date
1382 , p5_a32 NUMBER := 0-1962.0724
1383 );
1384 procedure copy_template(p_api_version NUMBER
1385 , p_init_msg_list VARCHAR2
1386 , x_return_status out nocopy VARCHAR2
1387 , x_msg_count out nocopy NUMBER
1388 , x_msg_data out nocopy VARCHAR2
1389 , p_source_tmpl_id NUMBER
1390 , p7_a0 out nocopy NUMBER
1391 , p7_a1 out nocopy NUMBER
1392 , p7_a2 out nocopy NUMBER
1393 , p7_a3 out nocopy NUMBER
1394 , p7_a4 out nocopy NUMBER
1395 , p7_a5 out nocopy NUMBER
1396 , p7_a6 out nocopy NUMBER
1397 , p7_a7 out nocopy VARCHAR2
1398 , p7_a8 out nocopy VARCHAR2
1399 , p7_a9 out nocopy VARCHAR2
1400 , p7_a10 out nocopy VARCHAR2
1401 , p7_a11 out nocopy VARCHAR2
1402 , p7_a12 out nocopy VARCHAR2
1403 , p7_a13 out nocopy VARCHAR2
1404 , p7_a14 out nocopy VARCHAR2
1405 , p7_a15 out nocopy VARCHAR2
1406 , p7_a16 out nocopy VARCHAR2
1407 , p7_a17 out nocopy DATE
1408 , p7_a18 out nocopy DATE
1409 , p7_a19 out nocopy VARCHAR2
1410 , p7_a20 out nocopy VARCHAR2
1411 , p7_a21 out nocopy VARCHAR2
1412 , p7_a22 out nocopy VARCHAR2
1413 , p7_a23 out nocopy VARCHAR2
1414 , p7_a24 out nocopy VARCHAR2
1415 , p7_a25 out nocopy VARCHAR2
1416 , p7_a26 out nocopy VARCHAR2
1417 , p7_a27 out nocopy VARCHAR2
1418 , p7_a28 out nocopy VARCHAR2
1419 , p7_a29 out nocopy VARCHAR2
1420 , p7_a30 out nocopy VARCHAR2
1421 , p7_a31 out nocopy VARCHAR2
1422 , p7_a32 out nocopy VARCHAR2
1423 , p7_a33 out nocopy VARCHAR2
1424 , p7_a34 out nocopy VARCHAR2
1425 , p7_a35 out nocopy VARCHAR2
1426 , p7_a36 out nocopy NUMBER
1427 , p7_a37 out nocopy NUMBER
1428 , p7_a38 out nocopy DATE
1429 , p7_a39 out nocopy NUMBER
1430 , p7_a40 out nocopy DATE
1431 , p7_a41 out nocopy NUMBER
1432 , p7_a42 out nocopy VARCHAR2
1433 , p5_a0 NUMBER := 0-1962.0724
1434 , p5_a1 NUMBER := 0-1962.0724
1435 , p5_a2 NUMBER := 0-1962.0724
1436 , p5_a3 NUMBER := 0-1962.0724
1437 , p5_a4 NUMBER := 0-1962.0724
1438 , p5_a5 NUMBER := 0-1962.0724
1439 , p5_a6 NUMBER := 0-1962.0724
1440 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1441 , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1442 , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1443 , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1444 , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1445 , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1446 , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1447 , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1448 , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1449 , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1450 , p5_a17 DATE := fnd_api.g_miss_date
1451 , p5_a18 DATE := fnd_api.g_miss_date
1452 , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1453 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1454 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1455 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1456 , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1457 , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1458 , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1459 , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1460 , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1461 , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1462 , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1463 , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1464 , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1465 , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1466 , p5_a33 VARCHAR2 := fnd_api.g_miss_char
1467 , p5_a34 VARCHAR2 := fnd_api.g_miss_char
1468 , p5_a35 VARCHAR2 := fnd_api.g_miss_char
1469 , p5_a36 NUMBER := 0-1962.0724
1470 , p5_a37 NUMBER := 0-1962.0724
1471 , p5_a38 DATE := fnd_api.g_miss_date
1472 , p5_a39 NUMBER := 0-1962.0724
1473 , p5_a40 DATE := fnd_api.g_miss_date
1474 , p5_a41 NUMBER := 0-1962.0724
1475 , p5_a42 VARCHAR2 := fnd_api.g_miss_char
1476 );
1477 end okl_process_tmpt_set_pub_w;