PACKAGE: DVSYS.MAC_POLICY_FACTOR$_PRIV

Source

1 PACKAGE       MAC_POLICY_FACTOR$_priv AS
2 
3   TYPE attribute_rec IS RECORD (
4       ID# MAC_POLICY_FACTOR$.ID#%TYPE
5     , FACTOR_ID# MAC_POLICY_FACTOR$.FACTOR_ID#%TYPE
6     , MAC_POLICY_ID# MAC_POLICY_FACTOR$.MAC_POLICY_ID#%TYPE
7   );
8 
9   TYPE attribute_list IS VARRAY(4096) OF attribute_rec;
10 
11   -- Create method
12   PROCEDURE create_row(
13     p_FACTOR_ID# IN NUMBER,
14     p_MAC_POLICY_ID# IN NUMBER,
15     x_id# OUT number);
16 
17   -- Read method
18   PROCEDURE read_row(p_id#        IN     number,
19       x_ID# OUT NUMBER
20     , x_FACTOR_ID# OUT NUMBER
21     , x_MAC_POLICY_ID# OUT NUMBER
22     );
23 
24   PROCEDURE read_by_FACTOR_ID#_(
25     p_FACTOR_ID# IN number,
26     x_attribute_list OUT attribute_list);
27 
28   PROCEDURE read_by_MAC_POLICY_ID#_(
29     p_MAC_POLICY_ID# IN number,
30     x_attribute_list OUT attribute_list);
31 
32   -- Update method
33   PROCEDURE update_row(
34       p_id# NUMBER
35     , p_FACTOR_ID# IN NUMBER
36     , p_MAC_POLICY_ID# IN NUMBER
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_FACTOR_ID#_(
44     p_FACTOR_ID# IN number,
45     p_delete_children IN boolean := false);
46 
47   PROCEDURE delete_by_MAC_POLICY_ID#_(
48     p_MAC_POLICY_ID# IN number,
49     p_delete_children IN boolean := false);
50 
51 END;