PACKAGE: DVSYS.POLICY_LABEL$_PRIV

Source

1 PACKAGE       POLICY_LABEL$_priv AS
2 
3   TYPE attribute_rec IS RECORD (
4       ID# POLICY_LABEL$.ID#%TYPE
5     , IDENTITY_ID# POLICY_LABEL$.IDENTITY_ID#%TYPE
6     , POLICY_ID# POLICY_LABEL$.POLICY_ID#%TYPE
7     , LABEL_ID# POLICY_LABEL$.LABEL_ID#%TYPE
8   );
9 
10   TYPE attribute_list IS VARRAY(4096) OF attribute_rec;
11 
12   -- Create method
13   PROCEDURE create_row(
14     p_IDENTITY_ID# IN NUMBER,
15     p_POLICY_ID# IN NUMBER,
16     p_LABEL_ID# IN NUMBER,
17     x_id# OUT number);
18 
19   -- Read method
20   PROCEDURE read_row(p_id#        IN     number,
21       x_ID# OUT NUMBER
22     , x_IDENTITY_ID# OUT NUMBER
23     , x_POLICY_ID# OUT NUMBER
24     , x_LABEL_ID# OUT NUMBER
25     );
26 
27   PROCEDURE read_by_IDENTITY_ID#_(
28     p_IDENTITY_ID# IN number,
29     x_attribute_list OUT attribute_list);
30 
31   -- Update method
32   PROCEDURE update_row(
33       p_id# NUMBER
34     , p_IDENTITY_ID# IN NUMBER
35     , p_POLICY_ID# IN NUMBER
36     , p_LABEL_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_IDENTITY_ID#_(
44     p_IDENTITY_ID# IN number,
45     p_delete_children IN boolean := false);
46 
47 END;