PACKAGE: DVSYS.FACTOR_LINK$_PRIV

Source

1 PACKAGE       FACTOR_LINK$_priv AS
2 
3   TYPE attribute_rec IS RECORD (
4       ID# FACTOR_LINK$.ID#%TYPE
5     , PARENT_FACTOR_ID# FACTOR_LINK$.PARENT_FACTOR_ID#%TYPE
6     , CHILD_FACTOR_ID# FACTOR_LINK$.CHILD_FACTOR_ID#%TYPE
7     , LABEL_IND FACTOR_LINK$.LABEL_IND%TYPE
8   );
9 
10   TYPE attribute_list IS VARRAY(4096) OF attribute_rec;
11 
12   -- Create method
13   PROCEDURE create_row(
14     p_PARENT_FACTOR_ID# IN NUMBER,
15     p_CHILD_FACTOR_ID# IN NUMBER,
16     p_LABEL_IND IN VARCHAR2,
17     x_id# OUT number);
18 
19   -- Read method
20   PROCEDURE read_row(p_id#        IN     number,
21       x_ID# OUT NUMBER
22     , x_PARENT_FACTOR_ID# OUT NUMBER
23     , x_CHILD_FACTOR_ID# OUT NUMBER
24     , x_LABEL_IND OUT VARCHAR2
25     );
26 
27   PROCEDURE read_by_PARENT_FACTOR_ID#_(
28     p_PARENT_FACTOR_ID# IN number,
29     x_attribute_list OUT attribute_list);
30 
31   PROCEDURE read_by_CHILD_FACTOR_ID#_(
32     p_CHILD_FACTOR_ID# IN number,
33     x_attribute_list OUT attribute_list);
34 
35   -- Update method
36   PROCEDURE update_row(
37       p_id# NUMBER
38     , p_PARENT_FACTOR_ID# IN NUMBER
39     , p_CHILD_FACTOR_ID# IN NUMBER
40     , p_LABEL_IND IN VARCHAR2
41     );
42 
43   -- Delete method
44   PROCEDURE delete_row(p_id# IN number,
45                     p_delete_children IN boolean := false);
46 
47   PROCEDURE delete_by_PARENT_FACTOR_ID#_(
48     p_PARENT_FACTOR_ID# IN number,
49     p_delete_children IN boolean := false);
50 
51   PROCEDURE delete_by_CHILD_FACTOR_ID#_(
52     p_CHILD_FACTOR_ID# IN number,
53     p_delete_children IN boolean := false);
54 
55 END;