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_ACCT_EVENT_PUB

Source


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