DBA Data[Home] [Help]

PACKAGE: SYS.DBMS_RULEADM_INTERNAL

Source


1 PACKAGE dbms_ruleadm_internal AUTHID CURRENT_USER AS
2 
3   -----------------
4   -- constants
5 
6   KGLNRULS  CONSTANT BINARY_INTEGER := 23;
7   KGLNRULE  CONSTANT BINARY_INTEGER := 36;
8   KGLNREVC  CONSTANT BINARY_INTEGER := 38;
9 
10   PROCEDURE i_create_eval_ctx(
11                 evaluation_context_name IN varchar2,
12                 table_aliases           IN sys.re$table_alias_list := NULL,
13                 variable_types          IN sys.re$variable_type_list := NULL,
14                 evaluation_function     IN varchar2 := NULL,
15                 evaluation_context_comment IN varchar2 := NULL,
16                 eval_ctx_properties     IN number := NULL);
17 
18   PROCEDURE i_create_rule_set(
19 		rule_set_name		IN varchar2,
20                 evaluation_context      IN varchar2 := NULL,
21                 rule_set_comment        IN varchar2 := NULL,
22                 rule_set_properties     IN number := NULL,
23                 result_cache            IN boolean := FALSE);
24 
25   PROCEDURE i_create_rule(
26 		rule_name		IN varchar2,
27 		condition		IN varchar2,
28                 evaluation_context      IN varchar2 := NULL,
29                 action_context          IN sys.re$nv_list := NULL,
30                 rule_comment            IN varchar2 := NULL,
31                 rule_properties         IN number := NULL,
32                 internal_actx_client    IN varchar2 := NULL,
33                 internal_action_context IN sys.re$nv_list := NULL);
34 
35   PROCEDURE i_alter_rule(
36                 rule_name                 IN varchar2,
37                 condition                 IN varchar2 := NULL,
38                 evaluation_context        IN varchar2 := NULL,
39                 remove_evaluation_context IN boolean := FALSE,
40                 action_context            IN sys.re$nv_list := NULL,
41                 remove_action_context     IN boolean := FALSE,
42                 rule_comment              IN varchar2 := NULL,
43                 remove_rule_comment       IN boolean := FALSE,
44                 internal_actx_client      IN varchar2 := NULL,
45                 internal_action_context   IN sys.re$nv_list := NULL,
46                 remove_int_actx           IN boolean := FALSE);
47 
48   PROCEDURE patch_rule_priv(
49                 btab_schema             IN varchar2,
50                 btab_name               IN varchar2,
51                 condition               IN varchar2);
52 
53   PROCEDURE validate_re_object(
54                 object_name             IN varchar2,
55                 object_namespace        IN binary_integer);
56 
57 -- The export function signature should be
58 -- FUNCTION  <export_function> (
59 --           rschema                   IN  varchar2,
60 --           rname                     IN  varchar2,
61 --           new_block                 OUT PLS_INTEGER) RETURN VARCHAR2;
62 
63   PROCEDURE register_internal_actx(
64                 client_name             IN varchar2,
65                 export_function         IN varchar2 default NULL,
66                 client_comment          IN varchar2 default NULL);
67 
68   PROCEDURE unregister_internal_actx(
69                 client_name             IN varchar2);
70 
71   PROCEDURE i_evaluation_context_add_var(
72                 evaluation_context_name IN varchar2,
73                 variable_types          IN sys.re$variable_type_list default NULL
74             );
75 
76 END dbms_ruleadm_internal;