eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE: APPS.OKL_TMPT_SET_PUB

Source


1 PACKAGE OKL_TMPT_SET_PUB AUTHID CURRENT_USER AS
2 /* $Header: OKLPAESS.pls 115.6 2002/02/18 22:40:10 pkm ship        $ */
3 
4 
5 
6   SUBTYPE aesv_rec_type IS OKL_TMPT_SET_PVT.aesv_rec_type;
7 
8   SUBTYPE aesv_tbl_type IS OKL_TMPT_SET_PVT.aesv_tbl_type;
9 
10 
11 
12   SUBTYPE avlv_rec_type IS OKL_TMPT_SET_PVT.avlv_rec_type;
13 
14   SUBTYPE avlv_tbl_type IS OKL_TMPT_SET_PVT.avlv_tbl_type;
15 
16 
17 
18   SUBTYPE atlv_rec_type IS OKL_TMPT_SET_PVT.atlv_rec_type;
19 
20   SUBTYPE atlv_tbl_type IS OKL_TMPT_SET_PVT.atlv_tbl_type;
21 
22 
23   -- GLOBAL MESSAGE CONSTANTS
24 
25   ---------------------------------------------------------------------------------
26 
27   G_FND_APP                    CONSTANT VARCHAR2(200) :=  OKC_API.G_FND_APP;
28 
29   G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) :=  OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
30 
31   G_FORM_RECORD_DELETED        CONSTANT VARCHAR2(200) :=  OKC_API.G_FORM_RECORD_DELETED;
32 
33   G_FORM_RECORD_CHANGED        CONSTANT VARCHAR2(200) :=  OKC_API.G_FORM_RECORD_CHANGED;
34 
35   G_RECORD_LOGICALLY_DELETED   CONSTANT VARCHAR2(200) :=  OKC_API.G_RECORD_LOGICALLY_DELETED;
36 
37   G_REQUIRED_VALUE             CONSTANT VARCHAR2(200) :=  OKC_API.G_REQUIRED_VALUE;
38 
39   G_INVALID_VALUE              CONSTANT VARCHAR2(200) :=  OKC_API.G_INVALID_VALUE;
40 
41   G_COL_NAME_TOKEN             CONSTANT VARCHAR2(200) :=  OKC_API.G_COL_NAME_TOKEN;
42 
43   G_PARENT_TABLE_TOKEN         CONSTANT VARCHAR2(200) :=  OKC_API.G_PARENT_TABLE_TOKEN;
44 
45   G_CHILD_TABLE_TOKEN          CONSTANT VARCHAR2(200) :=  OKC_API.G_CHILD_TABLE_TOKEN;
46 
47   G_UNEXPECTED_ERROR           CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
48 
49   G_SQLERRM_TOKEN              CONSTANT VARCHAR2(200) := 'SQLerrm';
50 
51   G_SQLCODE_TOKEN              CONSTANT VARCHAR2(200) := 'SQLcode';
52 
53   G_UPPERCASE_REQUIRED         CONSTANT VARCHAR2(200) := 'OKC_UPPER_CASE_REQUIRED';
54 
55   ---------------------------------------------------------------------------------
56 
57 
58 
59   -- GLOBAL EXCEPTION
60 
61   ---------------------------------------------------------------------------------
62 
63   G_EXCEPTION_HALT_VALIDATION EXCEPTION;
64 
65   ---------------------------------------------------------------------------------
66 
67 
68 
69   -- GLOBAL VARIABLES
70 
71   ---------------------------------------------------------------------------------
72 
73   G_PKG_NAME                     CONSTANT VARCHAR2(200) := 'OKL_TMPT_SET_PUB';
74 
75   G_APP_NAME                     CONSTANT VARCHAR2(3)   :=  OKC_API.G_APP_NAME;
76 
77   ---------------------------------------------------------------------------------
78 
79 
80 
81   g_aesv_rec                   aesv_rec_type;
82 
83   g_avlv_rec                   avlv_rec_type;
84 
85   g_atlv_rec				    atlv_rec_type;
86 
87  PROCEDURE create_tmpt_set(
88 
89      p_api_version                  IN  NUMBER
90 
91     ,p_init_msg_list                IN  VARCHAR2 DEFAULT OKC_API.G_FALSE
92 
93     ,x_return_status                OUT NOCOPY VARCHAR2
94 
95     ,x_msg_count                    OUT NOCOPY NUMBER
96 
97     ,x_msg_data                     OUT NOCOPY VARCHAR2
98 
99     ,p_aesv_rec                     IN  aesv_rec_type
100 
101     ,p_avlv_tbl                     IN  avlv_tbl_type
102 
103     ,p_atlv_tbl			    IN atlv_tbl_type
104 
105     ,x_aesv_rec                     OUT NOCOPY aesv_rec_type
106 
107     ,x_avlv_tbl                     OUT NOCOPY avlv_tbl_type
108 
109     ,x_atlv_tbl						OUT NOCOPY atlv_tbl_type
110 
111      );
112 
113   --Object type procedure for update
114 
115   PROCEDURE update_tmpt_set(
116 
117      p_api_version                  IN  NUMBER
118 
119     ,p_init_msg_list                IN  VARCHAR2 DEFAULT OKC_API.G_FALSE
120 
121     ,x_return_status                OUT NOCOPY VARCHAR2
122 
123     ,x_msg_count                    OUT NOCOPY NUMBER
124 
125     ,x_msg_data                     OUT NOCOPY VARCHAR2
126 
127     ,p_aesv_rec                     IN  aesv_rec_type
128 
129     ,p_avlv_tbl                     IN  avlv_tbl_type
130 
131     ,p_atlv_tbl			    IN atlv_tbl_type
132 
133     ,x_aesv_rec                     OUT NOCOPY aesv_rec_type
134 
135     ,x_avlv_tbl                     OUT NOCOPY avlv_tbl_type
136 
137     ,x_atlv_tbl						OUT NOCOPY atlv_tbl_type
138 
139      );
140 
141 
142 
143   --Object type procedure for validate
144 
145   PROCEDURE validate_tmpt_set(
146 
147      p_api_version                  IN  NUMBER
148 
149     ,p_init_msg_list                IN  VARCHAR2 DEFAULT OKC_API.G_FALSE
150 
151     ,x_return_status                OUT NOCOPY VARCHAR2
152 
153     ,x_msg_count                    OUT NOCOPY NUMBER
154 
155     ,x_msg_data                     OUT NOCOPY VARCHAR2
156 
157     ,p_aesv_rec                     IN  aesv_rec_type
158 
159     ,p_avlv_tbl                     IN  avlv_tbl_type
160 
161     ,p_atlv_tbl						IN atlv_tbl_type
162 
163      );
164 
165 
166   PROCEDURE create_tmpt_set(
167 
168      p_api_version                  IN  NUMBER,
169 
170      p_init_msg_list                IN  VARCHAR2 DEFAULT OKC_API.G_FALSE,
171 
172      x_return_status                OUT NOCOPY VARCHAR2,
173 
174      x_msg_count                    OUT NOCOPY NUMBER,
175 
176      x_msg_data                     OUT NOCOPY VARCHAR2,
177 
178      p_aesv_tbl                     IN  aesv_tbl_type,
179 
180      x_aesv_tbl                     OUT NOCOPY aesv_tbl_type);
181 
182 
183 
184   PROCEDURE create_tmpt_set(
185 
186      p_api_version                  IN  NUMBER,
187 
188      p_init_msg_list                IN  VARCHAR2 DEFAULT OKC_API.G_FALSE,
189 
190      x_return_status                OUT NOCOPY VARCHAR2,
191 
192      x_msg_count                    OUT NOCOPY NUMBER,
193 
194      x_msg_data                     OUT NOCOPY VARCHAR2,
195 
196      p_aesv_rec                     IN  aesv_rec_type,
197 
198      x_aesv_rec                     OUT NOCOPY aesv_rec_type);
199 
200 
201 
202   PROCEDURE lock_tmpt_set(
203 
204      p_api_version                  IN  NUMBER,
205 
206      p_init_msg_list                IN  VARCHAR2 DEFAULT OKC_API.G_FALSE,
207 
208      x_return_status                OUT NOCOPY VARCHAR2,
209 
210      x_msg_count                    OUT NOCOPY NUMBER,
211 
212      x_msg_data                     OUT NOCOPY VARCHAR2,
213 
214      p_aesv_tbl                     IN  aesv_tbl_type);
215 
216 
217 
218   PROCEDURE lock_tmpt_set(
219 
220      p_api_version                  IN  NUMBER,
221 
222      p_init_msg_list                IN  VARCHAR2 DEFAULT OKC_API.G_FALSE,
223 
224      x_return_status                OUT NOCOPY VARCHAR2,
225 
226      x_msg_count                    OUT NOCOPY NUMBER,
227 
228      x_msg_data                     OUT NOCOPY VARCHAR2,
229 
230      p_aesv_rec                     IN  aesv_rec_type);
231 
232 
233 
234   PROCEDURE update_tmpt_set(
235 
236      p_api_version                  IN  NUMBER,
237 
238      p_init_msg_list                IN  VARCHAR2 DEFAULT OKC_API.G_FALSE,
239 
240      x_return_status                OUT NOCOPY VARCHAR2,
241 
242      x_msg_count                    OUT NOCOPY NUMBER,
243 
244      x_msg_data                     OUT NOCOPY VARCHAR2,
245 
246      p_aesv_tbl                     IN  aesv_tbl_type,
247 
248      x_aesv_tbl                     OUT NOCOPY aesv_tbl_type);
249 
250 
251 
252   PROCEDURE update_tmpt_set(
253 
254      p_api_version                  IN  NUMBER,
255 
256      p_init_msg_list                IN  VARCHAR2 DEFAULT OKC_API.G_FALSE,
257 
258      x_return_status                OUT NOCOPY VARCHAR2,
259 
260      x_msg_count                    OUT NOCOPY NUMBER,
261 
262      x_msg_data                     OUT NOCOPY VARCHAR2,
263 
264      p_aesv_rec                     IN  aesv_rec_type,
265 
266      x_aesv_rec                     OUT NOCOPY aesv_rec_type);
267 
268 
269 
270   PROCEDURE delete_tmpt_set(
271 
272      p_api_version                  IN  NUMBER,
273 
274      p_init_msg_list                IN  VARCHAR2 DEFAULT OKC_API.G_FALSE,
275 
276      x_return_status                OUT NOCOPY VARCHAR2,
277 
278      x_msg_count                    OUT NOCOPY NUMBER,
279 
280      x_msg_data                     OUT NOCOPY VARCHAR2,
281 
282      p_aesv_tbl                     IN  aesv_tbl_type);
283 
284 
285 
286   PROCEDURE delete_tmpt_set(
287 
288      p_api_version                  IN  NUMBER,
289 
290      p_init_msg_list                IN  VARCHAR2 DEFAULT OKC_API.G_FALSE,
291 
292      x_return_status                OUT NOCOPY VARCHAR2,
293 
294      x_msg_count                    OUT NOCOPY NUMBER,
295 
296      x_msg_data                     OUT NOCOPY VARCHAR2,
297 
298      p_aesv_rec                     IN aesv_rec_type);
299 
300 
301 
302    PROCEDURE validate_tmpt_set(
303 
304      p_api_version                  IN  NUMBER,
305 
306      p_init_msg_list                IN  VARCHAR2 DEFAULT OKC_API.G_FALSE,
307 
308      x_return_status                OUT NOCOPY VARCHAR2,
309 
310      x_msg_count                    OUT NOCOPY NUMBER,
311 
312      x_msg_data                     OUT NOCOPY VARCHAR2,
313 
314      p_aesv_tbl                     IN  aesv_tbl_type);
315 
316 
317 
318   PROCEDURE validate_tmpt_set(
319 
320      p_api_version                  IN  NUMBER,
321 
322      p_init_msg_list                IN  VARCHAR2 DEFAULT OKC_API.G_FALSE,
323 
324      x_return_status                OUT NOCOPY VARCHAR2,
325 
326      x_msg_count                    OUT NOCOPY NUMBER,
327 
328      x_msg_data                     OUT NOCOPY VARCHAR2,
329 
330      p_aesv_rec                     IN  aesv_rec_type);
331 
332 
333 
334 
335 
336   PROCEDURE create_template(
337 
338      p_api_version                  IN  NUMBER,
339 
340      p_init_msg_list                IN  VARCHAR2 DEFAULT OKC_API.G_FALSE,
341 
342      x_return_status                OUT NOCOPY VARCHAR2,
343 
344      x_msg_count                    OUT NOCOPY NUMBER,
345 
346      x_msg_data                     OUT NOCOPY VARCHAR2,
347 
348      p_avlv_tbl                     IN  avlv_tbl_type,
349 
350      x_avlv_tbl                     OUT NOCOPY avlv_tbl_type);
351 
352 
353 
354   PROCEDURE create_template(
355 
356      p_api_version                  IN  NUMBER,
357 
358      p_init_msg_list                IN  VARCHAR2 DEFAULT OKC_API.G_FALSE,
359 
360      x_return_status                OUT NOCOPY VARCHAR2,
361 
362      x_msg_count                    OUT NOCOPY NUMBER,
363 
364      x_msg_data                     OUT NOCOPY VARCHAR2,
365 
366      p_avlv_rec                     IN  avlv_rec_type,
367 
368      x_avlv_rec                     OUT NOCOPY avlv_rec_type);
369 
370 
371 
372   PROCEDURE lock_template(
373 
374      p_api_version                  IN  NUMBER,
375 
376      p_init_msg_list                IN  VARCHAR2 DEFAULT OKC_API.G_FALSE,
377 
378      x_return_status                OUT NOCOPY VARCHAR2,
379 
380      x_msg_count                    OUT NOCOPY NUMBER,
381 
382      x_msg_data                     OUT NOCOPY VARCHAR2,
383 
384      p_avlv_tbl                     IN  avlv_tbl_type);
385 
386 
387 
388   PROCEDURE lock_template(
389 
390      p_api_version                  IN  NUMBER,
391 
392      p_init_msg_list                IN  VARCHAR2 DEFAULT OKC_API.G_FALSE,
393 
394      x_return_status                OUT NOCOPY VARCHAR2,
395 
396      x_msg_count                    OUT NOCOPY NUMBER,
397 
398      x_msg_data                     OUT NOCOPY VARCHAR2,
399 
400      p_avlv_rec                     IN  avlv_rec_type);
401 
402 
403 
404   PROCEDURE update_template(
405 
406      p_api_version                  IN  NUMBER,
407 
408      p_init_msg_list                IN  VARCHAR2 DEFAULT OKC_API.G_FALSE,
409 
410      x_return_status                OUT NOCOPY VARCHAR2,
411 
412      x_msg_count                    OUT NOCOPY NUMBER,
413 
414      x_msg_data                     OUT NOCOPY VARCHAR2,
415 
416      p_avlv_tbl                     IN  avlv_tbl_type,
417 
418      x_avlv_tbl                     OUT NOCOPY avlv_tbl_type);
419 
420 
421 
422   PROCEDURE update_template(
423 
424      p_api_version                  IN  NUMBER,
425 
426      p_init_msg_list                IN  VARCHAR2 DEFAULT OKC_API.G_FALSE,
427 
428      x_return_status                OUT NOCOPY VARCHAR2,
429 
430      x_msg_count                    OUT NOCOPY NUMBER,
431 
432      x_msg_data                     OUT NOCOPY VARCHAR2,
433 
434      p_avlv_rec                     IN  avlv_rec_type,
435 
436      x_avlv_rec                     OUT NOCOPY avlv_rec_type);
437 
438 
439 
440   PROCEDURE delete_template(
441 
442      p_api_version                  IN  NUMBER,
443 
444      p_init_msg_list                IN  VARCHAR2 DEFAULT OKC_API.G_FALSE,
445 
446      x_return_status                OUT NOCOPY VARCHAR2,
447 
448      x_msg_count                    OUT NOCOPY NUMBER,
449 
450      x_msg_data                     OUT NOCOPY VARCHAR2,
451 
452      p_avlv_tbl                     IN  avlv_tbl_type);
453 
454 
455 
456   PROCEDURE delete_template(
457 
458      p_api_version                  IN  NUMBER,
459 
460      p_init_msg_list                IN  VARCHAR2 DEFAULT OKC_API.G_FALSE,
461 
462      x_return_status                OUT NOCOPY VARCHAR2,
463 
464      x_msg_count                    OUT NOCOPY NUMBER,
465 
466      x_msg_data                     OUT NOCOPY VARCHAR2,
467 
468      p_avlv_rec                     IN  avlv_rec_type);
469 
470 
471 
472    PROCEDURE validate_template(
473 
474      p_api_version                  IN  NUMBER,
475 
476      p_init_msg_list                IN  VARCHAR2 DEFAULT OKC_API.G_FALSE,
477 
478      x_return_status                OUT NOCOPY VARCHAR2,
479 
480      x_msg_count                    OUT NOCOPY NUMBER,
481 
482      x_msg_data                     OUT NOCOPY VARCHAR2,
483 
484      p_avlv_tbl                     IN  avlv_tbl_type);
485 
486 
487 
488   PROCEDURE validate_template(
489 
490      p_api_version                  IN  NUMBER,
491 
492      p_init_msg_list                IN  VARCHAR2 DEFAULT OKC_API.G_FALSE,
493 
494      x_return_status                OUT NOCOPY VARCHAR2,
495 
496      x_msg_count                    OUT NOCOPY NUMBER,
497 
498      x_msg_data                     OUT NOCOPY VARCHAR2,
499 
500      p_avlv_rec                     IN  avlv_rec_type);
501 
502 
503 PROCEDURE create_tmpt_lines(
504 
505      p_api_version                  IN  NUMBER,
506 
507      p_init_msg_list                IN  VARCHAR2 DEFAULT OKC_API.G_FALSE,
508 
509      x_return_status                OUT NOCOPY VARCHAR2,
510 
511      x_msg_count                    OUT NOCOPY NUMBER,
512 
513      x_msg_data                     OUT NOCOPY VARCHAR2,
514 
515      p_atlv_tbl                     IN  atlv_tbl_type,
516 
517      x_atlv_tbl                     OUT NOCOPY atlv_tbl_type);
518 
519 
520 
521   PROCEDURE create_tmpt_lines(
522 
523      p_api_version                  IN  NUMBER,
524 
525      p_init_msg_list                IN  VARCHAR2 DEFAULT OKC_API.G_FALSE,
526 
527      x_return_status                OUT NOCOPY VARCHAR2,
528 
529      x_msg_count                    OUT NOCOPY NUMBER,
530 
531      x_msg_data                     OUT NOCOPY VARCHAR2,
532 
533      p_atlv_rec                     IN  atlv_rec_type,
534 
535      x_atlv_rec                     OUT NOCOPY atlv_rec_type);
536 
537 
538 
539   PROCEDURE lock_tmpt_lines(
540 
541      p_api_version                  IN  NUMBER,
542 
543      p_init_msg_list                IN  VARCHAR2 DEFAULT OKC_API.G_FALSE,
544 
545      x_return_status                OUT NOCOPY VARCHAR2,
546 
547      x_msg_count                    OUT NOCOPY NUMBER,
548 
549      x_msg_data                     OUT NOCOPY VARCHAR2,
550 
551      p_atlv_tbl                     IN  atlv_tbl_type);
552 
553 
554 
555   PROCEDURE lock_tmpt_lines(
556 
557      p_api_version                  IN  NUMBER,
558 
559      p_init_msg_list                IN  VARCHAR2 DEFAULT OKC_API.G_FALSE,
560 
561      x_return_status                OUT NOCOPY VARCHAR2,
562 
563      x_msg_count                    OUT NOCOPY NUMBER,
564 
565      x_msg_data                     OUT NOCOPY VARCHAR2,
566 
567      p_atlv_rec                     IN  atlv_rec_type);
568 
569 
570 
571   PROCEDURE update_tmpt_lines(
572 
573      p_api_version                  IN  NUMBER,
574 
575      p_init_msg_list                IN  VARCHAR2 DEFAULT OKC_API.G_FALSE,
576 
577      x_return_status                OUT NOCOPY VARCHAR2,
578 
579      x_msg_count                    OUT NOCOPY NUMBER,
580 
581      x_msg_data                     OUT NOCOPY VARCHAR2,
582 
583      p_atlv_tbl                     IN  atlv_tbl_type,
584 
585      x_atlv_tbl                     OUT NOCOPY atlv_tbl_type);
586 
587 
588 
589   PROCEDURE update_tmpt_lines(
590 
591      p_api_version                  IN  NUMBER,
592 
593      p_init_msg_list                IN  VARCHAR2 DEFAULT OKC_API.G_FALSE,
594 
595      x_return_status                OUT NOCOPY VARCHAR2,
596 
597      x_msg_count                    OUT NOCOPY NUMBER,
598 
599      x_msg_data                     OUT NOCOPY VARCHAR2,
600 
601      p_atlv_rec                     IN  atlv_rec_type,
602 
603      x_atlv_rec                     OUT NOCOPY atlv_rec_type);
604 
605 
606 
607   PROCEDURE delete_tmpt_lines(
608 
609      p_api_version                  IN  NUMBER,
610 
611      p_init_msg_list                IN  VARCHAR2 DEFAULT OKC_API.G_FALSE,
612 
613      x_return_status                OUT NOCOPY VARCHAR2,
614 
615      x_msg_count                    OUT NOCOPY NUMBER,
616 
617      x_msg_data                     OUT NOCOPY VARCHAR2,
618 
619      p_atlv_tbl                     IN  atlv_tbl_type);
620 
621 
622 
623   PROCEDURE delete_tmpt_lines(
624 
625      p_api_version                  IN  NUMBER,
626 
627      p_init_msg_list                IN  VARCHAR2 DEFAULT OKC_API.G_FALSE,
628 
629      x_return_status                OUT NOCOPY VARCHAR2,
630 
631      x_msg_count                    OUT NOCOPY NUMBER,
632 
633      x_msg_data                     OUT NOCOPY VARCHAR2,
634 
635      p_atlv_rec                     IN  atlv_rec_type);
636 
637 
638 
639    PROCEDURE validate_tmpt_lines(
640 
641      p_api_version                  IN  NUMBER,
642 
643      p_init_msg_list                IN  VARCHAR2 DEFAULT OKC_API.G_FALSE,
644 
645      x_return_status                OUT NOCOPY VARCHAR2,
646 
647      x_msg_count                    OUT NOCOPY NUMBER,
648 
649      x_msg_data                     OUT NOCOPY VARCHAR2,
650 
651      p_atlv_tbl                     IN  atlv_tbl_type);
652 
653 
654 
655   PROCEDURE validate_tmpt_lines(
656 
657      p_api_version                  IN  NUMBER,
658 
659      p_init_msg_list                IN  VARCHAR2 DEFAULT OKC_API.G_FALSE,
660 
661      x_return_status                OUT NOCOPY VARCHAR2,
662 
663      x_msg_count                    OUT NOCOPY NUMBER,
664 
665      x_msg_data                     OUT NOCOPY VARCHAR2,
666 
667      p_atlv_rec                     IN  atlv_rec_type);
668 
669 
670 END OKL_TMPT_SET_PUB;
671