1 package WF_LOAD AUTHID CURRENT_USER as
2 /* $Header: wfldrs.pls 120.6 2011/03/14 05:30:48 alsosa ship $ */
3
4 -- Variables
5 logbuf varchar2(32000) := ''; -- special log messages that got past back
6
7 --
8 -- UPLOAD_ITEM_TYPE
9 --
10 procedure UPLOAD_ITEM_TYPE (
11 x_name in varchar2,
12 x_display_name in varchar2,
13 x_description in varchar2,
14 x_protect_level in number,
15 x_custom_level in number,
16 x_wf_selector in varchar2,
17 x_read_role in varchar2,
18 x_write_role in varchar2,
19 x_execute_role in varchar2,
20 x_persistence_type in varchar2,
21 x_persistence_days in varchar2,
22 x_level_error out NOCOPY number
23 );
24
25 --
26 -- UPLOAD_ITEM_ATTRIBUTE
27 --
28 procedure UPLOAD_ITEM_ATTRIBUTE (
29 x_item_type in varchar2,
30 x_name in varchar2,
31 x_display_name in varchar2,
32 x_description in varchar2,
33 x_sequence in number,
34 x_type in varchar2,
35 x_protect_level in number,
36 x_custom_level in number,
37 x_subtype in varchar2,
38 x_format in varchar2,
39 x_default in varchar2,
40 x_level_error out NOCOPY number
41 );
42
43 --
44 -- UPLOAD_LOOKUP_TYPE
45 --
46 procedure UPLOAD_LOOKUP_TYPE (
47 x_lookup_type in varchar2,
48 x_display_name in varchar2,
49 x_description in varchar2,
50 x_protect_level in number,
51 x_custom_level in number,
52 x_item_type in varchar2,
53 x_level_error out NOCOPY number
54 );
55
56 --
57 -- UPLOAD_LOOKUP
58 --
59 procedure UPLOAD_LOOKUP (
60 x_lookup_type in varchar2,
61 x_lookup_code in varchar2,
62 x_meaning in varchar2,
63 x_description in varchar2,
64 x_protect_level in number,
65 x_custom_level in number,
66 x_level_error out NOCOPY number
67 );
68
69 --
70 -- UPLOAD_MESSAGE
71 --
72 procedure UPLOAD_MESSAGE (
73 x_type in varchar2,
74 x_name in varchar2,
75 x_display_name in varchar2,
76 x_description in varchar2,
77 x_subject in varchar2,
78 x_body in varchar2,
79 x_html_body in varchar2,
80 x_protect_level in number,
81 x_custom_level in number,
82 x_default_priority in number,
83 x_read_role in varchar2,
84 x_write_role in varchar2,
85 x_level_error out NOCOPY number
86 );
87
88 --
89 -- UPLOAD_MESSAGE_ATTRIBUTE
90 --
91 procedure UPLOAD_MESSAGE_ATTRIBUTE (
92 x_message_type in varchar2,
93 x_message_name in varchar2,
94 x_name in varchar2,
95 x_display_name in varchar2,
96 x_description in varchar2,
97 x_sequence in number,
98 x_type in varchar2,
99 x_subtype in varchar2,
100 x_protect_level in number,
101 x_custom_level in number,
102 x_format in varchar2,
103 x_default in varchar2,
104 x_value_type in varchar2,
105 x_attach in varchar2,
106 x_level_error out NOCOPY number
107 );
108
109 --
110 -- UPLOAD_ACTIVITY
111 --
112 procedure UPLOAD_ACTIVITY (
113 x_item_type in varchar2,
114 x_name in varchar2,
115 x_display_name in varchar2,
116 x_description in varchar2,
117 x_type in varchar2,
118 x_rerun in varchar2,
119 x_protect_level in number,
120 x_custom_level in number,
121 x_effective_date in date,
122 x_function in varchar2,
123 x_function_type in varchar2,
124 x_result_type in varchar2,
125 x_cost in number,
126 x_read_role in varchar2,
127 x_write_role in varchar2,
128 x_execute_role in varchar2,
129 x_icon_name in varchar2,
130 x_message in varchar2,
131 x_error_process in varchar2,
132 x_expand_role in varchar2,
133 x_error_item_type in varchar2,
134 x_runnable_flag in varchar2,
135 x_event_filter in varchar2 default null,
136 x_event_type in varchar2 default null,
137 x_log_message out NOCOPY varchar2,
138 x_version out NOCOPY number,
139 x_level_error out NOCOPY number
140 );
141
142 --
143 -- provide the old 2.5 version of signature for forward compatibility
144 -- this is used by other product teams
145 --
146 procedure UPLOAD_ACTIVITY (
147 x_item_type in varchar2,
148 x_name in varchar2,
149 x_display_name in varchar2,
150 x_description in varchar2,
151 x_type in varchar2,
152 x_rerun in varchar2,
153 x_protect_level in number,
154 x_custom_level in number,
155 x_effective_date in date,
156 x_function in varchar2,
157 x_function_type in varchar2,
158 x_result_type in varchar2,
159 x_cost in number,
160 x_read_role in varchar2,
161 x_write_role in varchar2,
162 x_execute_role in varchar2,
163 x_icon_name in varchar2,
164 x_message in varchar2,
165 x_error_process in varchar2,
166 x_expand_role in varchar2,
167 x_error_item_type in varchar2,
168 x_runnable_flag in varchar2,
169 x_version out NOCOPY number,
170 x_level_error out NOCOPY number
171 );
172
173 --
174 -- UPLOAD_ACTIVITY_ATTRIBUTE
175 --
176 procedure UPLOAD_ACTIVITY_ATTRIBUTE (
177 x_activity_item_type in varchar2,
178 x_activity_name in varchar2,
179 x_activity_version in number,
180 x_name in varchar2,
181 x_display_name in varchar2,
182 x_description in varchar2,
183 x_sequence in number,
184 x_type in varchar2,
185 x_protect_level in number,
186 x_custom_level in number,
187 x_subtype in varchar2,
188 x_format in varchar2,
189 x_default in varchar2,
190 x_value_type in varchar2,
191 x_level_error out NOCOPY number
192 );
193
194 --
195 -- UPLOAD_PROCESS_ACTIVITY
196 --
197 procedure UPLOAD_PROCESS_ACTIVITY (
198 x_process_item_type in varchar2,
199 x_process_name in varchar2,
200 x_process_version in number,
201 x_activity_item_type in varchar2,
202 x_activity_name in varchar2,
203 x_instance_id in out NOCOPY number,
204 x_instance_label in varchar2,
205 x_protect_level in number,
206 x_custom_level in number,
207 x_start_end in varchar2,
208 x_default_result in varchar2,
209 x_icon_geometry in varchar2,
210 x_perform_role in varchar2,
211 x_perform_role_type in varchar2,
212 x_user_comment in varchar2,
213 x_level_error out NOCOPY number
214 );
215
216 --
217 -- UPLOAD_ACTIVITY_ATTR_VALUE
218 --
219 procedure UPLOAD_ACTIVITY_ATTR_VALUE (
220 x_process_activity_id in number,
221 x_name in varchar2,
222 x_protect_level in number,
223 x_custom_level in number,
224 x_value in varchar2,
225 x_value_type in varchar2,
226 x_effective_date in date,
227 x_level_error out NOCOPY number
228 );
229
230 --
231 -- UPLOAD_ACTIVITY_TRANSITION
232 --
233 procedure UPLOAD_ACTIVITY_TRANSITION (
234 x_from_process_activity in number,
235 x_result_code in varchar2,
236 x_to_process_activity in number,
237 x_protect_level in number,
238 x_custom_level in number,
239 x_arrow_geometry in varchar2,
240 x_level_error out NOCOPY number
241 );
242
243 --
244 -- UPLOAD_RESOURCE
245 --
246 procedure UPLOAD_RESOURCE (
247 x_type in varchar2,
248 x_name in varchar2,
249 x_protect_level in number,
250 x_custom_level in number,
251 x_id in number,
252 x_text in varchar2,
253 x_level_error out NOCOPY number
254 );
255
256 --
257 -- DELETE_LOOKUP_TYPE
258 --
259 procedure DELETE_LOOKUP_TYPE(
260 x_lookup_type in varchar2,
261 x_level_error out NOCOPY number
262 );
263
264 --
265 -- DELETE_LOOKUP
266 --
267 procedure DELETE_LOOKUP(
268 x_lookup_type in varchar2,
269 x_lookup_code in varchar2,
270 x_level_error out NOCOPY number
271 );
272
273 --
274 -- DELETE_LOOKUPS
275 --
276 procedure DELETE_LOOKUPS(
277 x_lookup_type in varchar2,
278 x_level_error out NOCOPY number
279 );
280
281 --
282 -- DELETE_ITEM_TYPE
283 --
284 procedure DELETE_ITEM_TYPE(
285 x_name in varchar2,
286 x_level_error out NOCOPY number
287 );
288
289 --
290 -- DELETE_ITEM_ATTRIBUTE
291 --
292 procedure DELETE_ITEM_ATTRIBUTE(
293 x_item_type in varchar2,
294 x_name in varchar2,
295 x_level_error out NOCOPY number
296 );
297
298 --
299 -- DELETE_ITEM_ATTRIBUTES
300 --
301 procedure DELETE_ITEM_ATTRIBUTES(
302 x_item_type in varchar2,
303 x_level_error out NOCOPY number
304 );
305
306 --
307 -- DELETE_MESSAGE
308 --
309 procedure DELETE_MESSAGE(
310 x_type in varchar2,
311 x_name in varchar2,
312 x_level_error out NOCOPY number
313 );
314
315 --
316 -- DELETE_MESSAGE_ATTRIBUTE
317 --
318 procedure DELETE_MESSAGE_ATTRIBUTE(
319 x_message_type in varchar2,
320 x_message_name in varchar2,
321 x_name in varchar2,
322 x_level_error out NOCOPY number
323 );
324
325 --
326 -- DELETE_MESSAGE_ATTRIBUTES
327 --
328 procedure DELETE_MESSAGE_ATTRIBUTES(
329 x_message_type in varchar2,
330 x_message_name in varchar2,
331 x_level_error out NOCOPY number
332 );
333
334 --
335 -- DELETE_ACTIVITY
336 --
337 procedure DELETE_ACTIVITY(
338 x_item_type in varchar2,
339 x_name in varchar2,
340 x_level_error out NOCOPY number
341 );
342
343
344 --
345 -- WebDB Integration
346 --
347
348 --
349 -- Delete_Transition
350 -- IN
351 -- p_previous_step - instance id of the FROM process activity
352 -- p_next_step - instance id of the TO process activity
353 -- P_result_code - result code of this transition
354 -- NOTE
355 -- It is possible to leave an invalid Workflow definition after this
356 -- call.
357 -- Ignores the criteria with a null arguement.
358 -- p_previous_step and p_next_step cannot be both null.
359 procedure Delete_Transition(
360 p_previous_step in number default null,
361 p_next_step in number default null,
362 p_result_code in varchar2 default null);
363
364 --
365 -- Get_Process_Activity
366 -- IN
367 -- p_activity_instance - instance id of a process activity
368 -- OUT
369 -- p_xcor - X coordinate of the icon geometry
370 -- p_ycor - Y coordinate of the icon geometry
371 -- p_activity_name - internal name of this process activity
372 -- NOTE
373 --
374 procedure Get_Process_Activity(
375 p_activity_instance in number,
376 p_xcor out NOCOPY number,
377 p_ycor out NOCOPY number,
378 p_activity_name out NOCOPY varchar2,
379 p_instance_label out NOCOPY varchar2);
380
381 --
382 -- Update_Message
383 -- IN
384 -- p_type - item type of message
385 -- p_name - message name
386 -- p_subject - message subject
387 -- p_body - text body
388 -- p_html_body - html formated body
389 -- OUT
390 -- x_level_error - the output of error level
391 -- NOTE
392 -- It first selects the values related to the message
393 -- and then calls UPLOAD_MESSAGE to update the value.
394 --
395 procedure UPDATE_MESSAGE (
396 p_type in varchar2,
397 p_name in varchar2,
398 p_subject in varchar2,
399 p_body in varchar2,
400 p_html_body in varchar2,
401 p_level_error out NOCOPY number
402 );
403
404
405 --
406 -- Get_MESSAGE
407 -- IN
408 -- p_type - message item type
409 -- p_name - message name
410 -- OUT
411 -- p_protect_level -
412 -- p_custom_level -
413 -- p_default_priority -
414 -- p_display_name - 80
415 -- p_description - 240
416 -- p_subject - 240
417 -- p_body - 4000
418 -- p_html_body - 4000
419 --
420 procedure GET_MESSAGE (
421 p_type in varchar2,
422 p_name in varchar2,
423 p_protect_level out NOCOPY number,
424 p_custom_level out NOCOPY number,
425 p_default_priority out NOCOPY number,
426 p_display_name out NOCOPY varchar2,
427 p_description out NOCOPY varchar2,
428 p_subject out NOCOPY varchar2,
429 p_body out NOCOPY varchar2,
430 p_html_body out NOCOPY varchar2
431 );
432
433 --
434 -- COPY_ITEM_TYPE
435 -- IN
436 -- p_item_type - item type to copy from.
437 -- p_destination_item_type- new item type.
438 -- p_new_suffix - suffix to use append to internal names
439 -- of new entities.
440 -- NOTE
441 --
442 procedure COPY_ITEM_TYPE(
443 p_item_type in varchar2,
444 p_destination_item_type in varchar2,
445 p_new_suffix in varchar2);
446
447 -- Delete_Process_Activity
448 -- IN
449 -- p_item_type - item type of this process activity (used in making
450 -- sure the process activity has not been run).
451 -- No need to have this.
452 -- p_step - instance id of the process activity
453 -- NOTE
454 -- It is possible to leave an invalid Workflow definition after this
455 -- call.
456 -- Make sure it does not exist in wf_item_activity_statuses, ie. has
457 -- not been run.
458 -- It needs to make sure all transitions are cleaned up first.
459 -- It also needs to clean up all activity attribute values.
460 procedure Delete_Process_Activity(
461 p_step in number);
462
463 --
464 -- Get_Activity_Attr_Val
465 -- IN
466 -- p_process_instance_id - instance id of the process activity
467 -- p_attribute_name - name of the attribute
468 -- OUT
469 -- p_attribute_value_type - value type like 'CONSTANT' or 'ITEMATTR'
470 -- p_attribute_value - value of the attribute
471 --
472 procedure GET_ACTIVITY_ATTR_VAL(
473 p_process_instance_id in number,
474 p_attribute_name in varchar2,
475 p_attribute_value_type out NOCOPY varchar2,
476 p_attribute_value out NOCOPY varchar2);
477
478 --
479 -- Get_Item_Attribute
480 -- IN
481 -- p_item_type - item type
482 -- p_attribute_name - name of the attribute
483 -- OUT
484 -- p_attribute_type - type like 'NUMBER', 'TEXT' and so on
485 -- p_attribute_value - value of the attribute
486 --
487 procedure GET_ITEM_ATTRIBUTE(
488 p_item_type in varchar2,
489 p_attribute_name in varchar2,
490 p_attribute_type out NOCOPY varchar2,
491 p_attribute_value out NOCOPY varchar2);
492
493 --
497 -- p_name -
494 -- Get_Activity
495 -- IN
496 -- p_item_type -
498 -- OUT
499 -- p_display_name -
500 -- p_description -
501 -- p_type -
502 -- p_rerun -
503 -- p_protect_level -
504 -- p_custom_level -
505 -- p_begin_date -
506 -- p_function -
507 -- p_function_type -
508 -- p_result_type -
509 -- p_cost -
510 -- p_read_role -
511 -- p_write_role -
512 -- p_excute_role -
513 -- p_icon_name -
514 -- p_message -
515 -- p_error_process -
516 -- p_expand_role -
517 -- p_error_item_type -
518 -- p_runnable_flag -
519 -- p_version -
520 procedure GET_ACTIVITY (
521 p_item_type in varchar2,
522 p_name in varchar2,
523 p_display_name out NOCOPY varchar2,
524 p_description out NOCOPY varchar2,
525 p_type out NOCOPY varchar2,
526 p_rerun out NOCOPY varchar2,
527 p_protect_level out NOCOPY number,
528 p_custom_level out NOCOPY number,
529 p_begin_date out NOCOPY date,
530 p_function out NOCOPY varchar2,
531 p_function_type out NOCOPY varchar2,
532 p_result_type out NOCOPY varchar2,
533 p_cost out NOCOPY number,
534 p_read_role out NOCOPY varchar2,
535 p_write_role out NOCOPY varchar2,
536 p_execute_role out NOCOPY varchar2,
537 p_icon_name out NOCOPY varchar2,
538 p_message out NOCOPY varchar2,
539 p_error_process out NOCOPY varchar2,
540 p_expand_role out NOCOPY varchar2,
541 p_error_item_type out NOCOPY varchar2,
542 p_runnable_flag out NOCOPY varchar2,
543 p_version out NOCOPY number
544 );
545
546 --
547 -- Update_Activity
548 -- IN
549 -- p_item_type - item type of the activity
550 -- p_name - activity name
551 -- p_display_name - activity display name
552 -- p_description - activity description
553 -- p_expand_role - flag to indicate expand role or not
554 -- OUT
555 -- p_level_error - the output of error level
556 -- NOTE
557 -- It first selects the values related to the activity
558 -- and then calls UPLOAD_ACTIVITY to update the value.
559 --
560 procedure UPDATE_ACTIVITY (
561 p_item_type in varchar2,
562 p_name in varchar2,
563 p_display_name in varchar2 default null,
564 p_description in varchar2 default null,
565 p_expand_role in varchar2 default null,
566 p_level_error out NOCOPY number);
567
568 --
569 -- Get_Activity_Instance
570 -- Return the instance id for an activity based on its label of a
571 -- given process and activity
572 -- IN
573 -- p_process_item_type -
574 -- p_process_name -
575 -- p_process_version -
576 -- p_activity_item_type -
577 -- p_activity_name -
578 -- p_instance_label -
579 function Get_Activity_Instance(
580 p_process_item_type in varchar2,
581 p_process_name in varchar2,
582 p_process_version in number default 1,
583 p_activity_item_type in varchar2 default null,
584 p_activity_name in varchar2 default null,
585 p_instance_label in varchar2 default null)
586 return number;
587
588 /* ### Get_Process_Activity include this function
589 --
590 -- GetActNameFromInstId
591 -- IN
592 -- p_instance_id - instance id of an activity
593 -- RET
594 -- Name of the activity in varchar2
595 --
596 function GetActNameFromInstId (
597 p_instance_id in number)
598 return varchar2;
599 */
600
601 type t_instanceidTab is table of number index by binary_integer;
602 type t_nameTab is table of varchar2(30) index by binary_integer;
603 type t_resultcodeTab is table of varchar2(30) index by binary_integer;
604
605 --
606 -- Get_Activity_Transition
607 -- IN
608 -- p_from_activity -
609 -- p_to_activity -
610 -- p_result_code -
611 -- OUT
612 -- p_result_codes - table of all matched result codes
613 -- p_activities - table of all matched activity instance ids
614 -- NOTE
615 -- Depend on what the parameter given return the appropriate result
616 -- p_from_activity + p_to_activity => p_result_codes
617 -- p_from_activity + p_result_code => p_activities (of to activity)
618 -- p_to_activity + p_result_code => p_activities (of from activity)
619 -- p_from_activity => p_result_codes + p_activities (of to activity)
620 -- p_to_activity => p_result_codes + p_activities (of from activity)
621 procedure Get_Activity_Transition (
622 p_from_activity in number default null,
623 p_to_activity in number default null,
624 p_result_code in varchar2 default null,
625 p_activities out NOCOPY t_instanceidTab,
626 p_result_codes out NOCOPY t_resultcodeTab);
627
628 --
629 -- Get_Item_Attribute_Names
630 -- select all the item attributes that match the specified suffix
631 -- IN
632 -- p_item_type - item type of the item attributes
636 --
633 -- p_suffix - suffix that the internal names of item attributes endded in
634 -- OUT
635 -- p_names - table of internal names that returned
637 procedure Get_Item_Attribute_Names(
638 p_item_type in varchar2,
639 p_suffix in varchar2,
640 p_names out NOCOPY t_nameTab
641 );
642
643 --
644 -- Get_Notif_Activity_Names
645 -- select all the notification activities that match the specified suffix
646 -- IN
647 -- p_item_type - item type of the activities
648 -- p_suffix - suffix that the internal names of activities endded in
649 -- OUT
650 -- p_names - table of internal names that returned
651 --
652 procedure Get_Notif_Activity_Names(
653 p_item_type in varchar2,
654 p_suffix in varchar2,
655 p_names out NOCOPY t_nameTab
656 );
657
658 -- Get_Message_Names
659 -- select all the messages that match the specified suffix
660 -- IN
661 -- p_item_type - item type of the messages
662 -- p_suffix - suffix that the internal names of messages endded in
663 -- OUT
664 -- p_names - table of internal names that returned
665 --
666 procedure Get_Message_Names(
667 p_item_type in varchar2,
668 p_suffix in varchar2,
669 p_names out NOCOPY t_nameTab
670 );
671
672 -- Get_Process_Activity_Instances
673 -- select all the process activities of activity of type process
674 -- IN
675 -- p_process_item_type - item type of the process which includes these
676 -- activities.
677 -- p_process_name - process name
678 -- p_process_version - process version which defaults to 1
679 -- OUT
680 -- p_instance_ids - table of instance ids that returned
681 --
682 procedure Get_Process_Activity_Instances(
683 p_process_item_type in varchar2,
684 p_process_name in varchar2,
685 p_process_version in number default 1,
686 p_instance_ids out NOCOPY t_instanceidTab
687 );
688
689 --
690 -- GET_LOOKUP
691 -- Get the Lookup definition
692 -- IN
693 -- x_lookup_type - item type of lookup
694 -- x_lookup_code - internal name of lookup code
695 -- OUT
696 -- x_meaning - display name of lookup code
697 -- x_description - description of lookup code
698 -- x_protect_level -
699 -- x_custom_level -
700 --
701 procedure Get_Lookup(
702 x_lookup_type in varchar2,
703 x_lookup_code in varchar2,
704 x_meaning out NOCOPY varchar2,
705 x_description out NOCOPY varchar2,
706 x_protect_level out NOCOPY number,
707 x_custom_level out NOCOPY number
708 );
709
710 --
711 -- UPDATE_LOOKUP
712 -- Update the provided fields for Lookup
713 -- IN
714 -- x_lookup_type - item type of lookup
715 -- x_lookup_code - internal name of lookup code
716 -- x_meaning - display name of lookup code
717 -- x_description - description of lookup code
718 -- x_protect_level -
719 -- x_custom_level -
720 -- OUT
721 -- x_level_error - level of error returned from UPLOAD_LOOKUP
722 -- NOTE
723 -- Calls GET_LOOKUP to get the default value before calling
724 -- UPLOAD_LOOKUP.
725 --
726 procedure UPDATE_LOOKUP(
727 x_lookup_type in varchar2,
728 x_lookup_code in varchar2,
729 x_meaning in varchar2 default null,
730 x_description in varchar2 default null,
731 x_protect_level in number default null,
732 x_custom_level in number default null,
733 x_level_error out NOCOPY number
734 );
735
736 --
737 -- GET_LOOKUP_Codes
738 -- Get lookup codes for a lookup type
739 -- IN
740 -- p_lookup_type - item type of lookup
741 -- OUT
742 -- p_lookup_codes - table of lookup codes
743 --
744 procedure Get_Lookup_Codes(
745 p_lookup_type in varchar2,
746 p_lookup_codes out NOCOPY t_resultcodeTab);
747
748
749 --
750 -- Activity_Exist_In_Process (Deprecated, use WF_ENGINE.Activity_Exist instead)
751 -- Check if an activity exist in a process
752 -- IN
753 -- p_process_item_type
754 -- p_process_name
755 -- p_activity_item_type
756 -- p_anctivity_name
757 -- active_date
758 -- iteration - maximum 8 level deep (0-7)
759 -- RET
760 -- TRUE if activity exist, FALSE otherwise
761 --
762 function Activity_Exist_In_Process (
763 p_process_item_type in varchar2,
764 p_process_name in varchar2,
765 p_activity_item_type in varchar2 default null,
766 p_activity_name in varchar2,
767 active_date in date default sysdate,
768 iteration in number default 0)
769 return boolean;
770
771 --
772 -- BeginTransaction
773 -- (PRIVATE)
774 -- Calls WF_CACHE.BeginTransaction() to control the calls to WF_CACHE.Reset()
775 -- so there is not unnecessary locking or update to WFCACHE_META_UPD.
776 -- Calling this api mandates that EndTransaction is called BEFORE control is
777 -- returned.
778 PROCEDURE BeginTransaction;
779
780 --
781 -- EndTransaction
782 -- (PRIVATE)
783 -- Calls WF_CACHE.EndTransaction() to signal the end of the transaction and to
784 -- call WF_CACHE.Reset() which will update WFCACHE_META_UPD.
785 -- WARNING: THIS API WILL ISSUE A COMMIT!
786 PROCEDURE EndTransaction;
787
788 --
789 -- Prepare_NZDT_WFRESGEN
790 -- (PRIVATE)
791 -- This procedure is called from WFRESGEN to prepare the affected tables by using
792 -- package AD_ZD_SEED.PREPARE('<TABLE_NAME') so that the content of the table
793 -- is backed up in the current namespace.
794 PROCEDURE Prepare_NZDT_WFRESGEN;
795
796 --
797 -- Prepare_NZDT_WFLOAD
798 -- (PRIVATE)
799 -- This procedure is called from WFLOAD to prepare the affected tables by using
800 -- package AD_ZD_SEED.PREPARE('<TABLE_NAME') so that the content of the tables
801 -- is backed up in the current namespace.
802 PROCEDURE Prepare_NZDT_WFLOAD;
803 end WF_LOAD;
[Home] [Help]