PACKAGE: DVSYS.ROLE$_PRIV

Source

1 PACKAGE       ROLE$_priv AS
2 
3   TYPE attribute_rec IS RECORD (
4       ID# ROLE$.ID#%TYPE
5     , ROLE ROLE$.ROLE%TYPE
6     , RULE_SET_ID# ROLE$.RULE_SET_ID#%TYPE
7     , ENABLED ROLE$.ENABLED%TYPE
8   );
9 
10   TYPE attribute_list IS VARRAY(4096) OF attribute_rec;
11 
12   -- Create method
13   PROCEDURE create_row(
14     p_ROLE IN VARCHAR2,
15     p_RULE_SET_ID# IN NUMBER,
16     p_ENABLED IN VARCHAR2,
17     x_id# OUT number);
18 
19   -- Read method
20   PROCEDURE read_row(p_id#        IN     number,
21       x_ID# OUT NUMBER
22     , x_ROLE OUT VARCHAR2
23     , x_RULE_SET_ID# OUT NUMBER
24     , x_ENABLED OUT VARCHAR2
25     );
26 
27   PROCEDURE read_by_RULE_SET_ID#_(
28     p_RULE_SET_ID# IN number,
29     x_attribute_list OUT attribute_list);
30 
31   -- Update method
32   PROCEDURE update_row(
33       p_id# NUMBER
34     , p_ROLE IN VARCHAR2
35     , p_RULE_SET_ID# IN NUMBER
36     , p_ENABLED IN VARCHAR2
37     );
38 
39   -- Delete method
40   PROCEDURE delete_row(p_id# IN number,
41                     p_delete_children IN boolean := false);
42 
43   PROCEDURE delete_by_RULE_SET_ID#_(
44     p_RULE_SET_ID# IN number,
45     p_delete_children IN boolean := false);
46 
47 END;