PACKAGE: DVSYS.IDENTITY_MAP$_PRIV

Source

1 PACKAGE       IDENTITY_MAP$_priv AS
2 
3   TYPE attribute_rec IS RECORD (
4       ID# IDENTITY_MAP$.ID#%TYPE
5     , IDENTITY_ID# IDENTITY_MAP$.IDENTITY_ID#%TYPE
6     , FACTOR_LINK_ID# IDENTITY_MAP$.FACTOR_LINK_ID#%TYPE
7     , OPERATION_CODE_ID# IDENTITY_MAP$.OPERATION_CODE_ID#%TYPE
8     , OPERAND1 IDENTITY_MAP$.OPERAND1%TYPE
9     , OPERAND2 IDENTITY_MAP$.OPERAND2%TYPE
10   );
11 
12   TYPE attribute_list IS VARRAY(4096) OF attribute_rec;
13 
14   -- Create method
15   PROCEDURE create_row(
16     p_IDENTITY_ID# IN NUMBER,
17     p_FACTOR_LINK_ID# IN NUMBER,
18     p_OPERATION_CODE_ID# IN NUMBER,
19     p_OPERAND1 IN VARCHAR2,
20     p_OPERAND2 IN VARCHAR2,
21     x_id# OUT number);
22 
23   -- Read method
24   PROCEDURE read_row(p_id#        IN     number,
25       x_ID# OUT NUMBER
26     , x_IDENTITY_ID# OUT NUMBER
27     , x_FACTOR_LINK_ID# OUT NUMBER
28     , x_OPERATION_CODE_ID# OUT NUMBER
29     , x_OPERAND1 OUT VARCHAR2
30     , x_OPERAND2 OUT VARCHAR2
31     );
32 
33   PROCEDURE read_by_IDENTITY_ID#_(
34     p_IDENTITY_ID# IN number,
35     x_attribute_list OUT attribute_list);
36 
37   PROCEDURE read_by_FACTOR_LINK_ID#_(
38     p_FACTOR_LINK_ID# IN number,
39     x_attribute_list OUT attribute_list);
40 
41   PROCEDURE read_by_OPERATION_CODE_ID#_(
42     p_OPERATION_CODE_ID# IN number,
43     x_attribute_list OUT attribute_list);
44 
45   -- Update method
46   PROCEDURE update_row(
47       p_id# NUMBER
48     , p_IDENTITY_ID# IN NUMBER
49     , p_FACTOR_LINK_ID# IN NUMBER
50     , p_OPERATION_CODE_ID# IN NUMBER
51     , p_OPERAND1 IN VARCHAR2
52     , p_OPERAND2 IN VARCHAR2
53     );
54 
55   -- Delete method
56   PROCEDURE delete_row(p_id# IN number,
57                     p_delete_children IN boolean := false);
58 
59   PROCEDURE delete_by_IDENTITY_ID#_(
60     p_IDENTITY_ID# IN number,
61     p_delete_children IN boolean := false);
62 
63   PROCEDURE delete_by_FACTOR_LINK_ID#_(
64     p_FACTOR_LINK_ID# IN number,
65     p_delete_children IN boolean := false);
66 
67   PROCEDURE delete_by_OPERATION_CODE_ID#_(
68     p_OPERATION_CODE_ID# IN number,
69     p_delete_children IN boolean := false);
70 
71 END;