DBA Data[Home] [Help]

PACKAGE: DVSYS.IDENTITY$_PRIV

Source


1 PACKAGE       IDENTITY$_priv AS
2 
3   TYPE attribute_rec IS RECORD (
4       ID# IDENTITY$.ID#%TYPE
5     , FACTOR_ID# IDENTITY$.FACTOR_ID#%TYPE
6     , VALUE IDENTITY$.VALUE%TYPE
7     , TRUST_LEVEL IDENTITY$.TRUST_LEVEL%TYPE
8   );
9 
10   TYPE attribute_list IS VARRAY(4096) OF attribute_rec;
11 
12   -- Create method
13   PROCEDURE create_row(
14     p_FACTOR_ID# IN NUMBER,
15     p_VALUE IN VARCHAR2,
16     p_TRUST_LEVEL 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_FACTOR_ID# OUT NUMBER
23     , x_VALUE OUT VARCHAR2
24     , x_TRUST_LEVEL OUT NUMBER
25     );
26 
27   PROCEDURE read_by_FACTOR_ID#_(
28     p_FACTOR_ID# IN number,
29     x_attribute_list OUT attribute_list);
30 
31   -- Update method
32   PROCEDURE update_row(
33       p_id# NUMBER
34     , p_FACTOR_ID# IN NUMBER
35     , p_VALUE IN VARCHAR2
36     , p_TRUST_LEVEL 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 END;