[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;