1 PACKAGE FII_FDHM_PKG as
2 /* $Header: fiifdhms.pls 120.1 2005/07/18 20:25:43 juding noship $ */
3
4 --
5 -- Function
6 -- has_loop
7 -- PURPOSE
8 -- Tree Loop Detection
9 -- Check to see if the source is in the parent path of target.
10 -- This is a recursive function.
11 -- Return
12 -- TRUE if there is loop in the drag and drop
13 -- FALSE if drag and drop results in no loop
14 -- Notes
15 --
16
17 FUNCTION has_loop (source IN VARCHAR2,
18 target IN VARCHAR2,
19 value_set_id IN NUMBER) RETURN VARCHAR2;
20
21 --
22 -- Function
23 -- modify_range
24 -- PURPOSE
25 -- Range Split
26 -- Determine how the range will be affected by a drag and drop action.
27 -- Depending on the position that the node that is being dragged in the
28 -- range. It may cause a range delection, range boundary modificaiton,
29 -- or range split.
30 -- History
31 -- 26-JAN-00 Maria Hui Created
32 -- Arguments
33 -- parent old parent of the node that is being dragged away
34 -- child the node that is being dragged away
35 -- range_attr range attribute for the existing range
36 -- range_low child_flex_value_low of the current range
37 -- range_high child_flex_value_high of the current range
38 -- value_set_id flex value set id of the row
39 -- Return
40 -- 1 if the range split can be handled successfully
41 -- 0 if there is any exception raised
42 -- Notes
43 --
44
45 FUNCTION modify_range ( parent IN VARCHAR2,
46 child IN VARCHAR2,
47 range_attr IN VARCHAR2,
48 range_low IN VARCHAR2,
49 range_high IN VARCHAR2,
50 parent_value_set_id IN NUMBER,
51 child_value_set_id IN NUMBER) RETURN INTEGER;
52
53 --
54 -- Function
55 -- has_loop_in_range
56 -- PURPOSE
57 -- Loop Detection in Range Manipulation
58 -- Check to see if the new or edited range create loop in the hierarchy.
59 -- History
60 -- 30-MAY-00 Maria Hui Created
61 -- Arguments
62 -- parent parent whose range is being modified
63 -- low lower bound of the new range
64 -- high upper bound of the new range
65 -- value_set_id flex value set id
66 -- Return
67 -- NULL if the new range will not cause any loop with existing range
68 -- flex_value flex value in the new range that is causing a loop
69 -- Notes
70 --
71
72 FUNCTION has_loop_in_range(parent IN VARCHAR2,
73 low IN VARCHAR2,
74 high IN VARCHAR2,
75 value_set_id IN NUMBER) RETURN VARCHAR2;
76
77 --
78 -- Function
79 -- unique_flex_value
80 -- PURPOSE
81 -- Checks to see if the flex value is unique.
82 -- History
83 -- 21-JUN-00 Maria Hui Created
84 -- Arguments
85 -- f_value flex value in concern
86 -- parent_low parent flex value low
87 -- value_set_id flex value set id
88 -- Return
89 -- TRUE if the value is unique
90 -- FALSE otherwise
91 -- Notes
92 --
93
94 FUNCTION unique_flex_value (f_value IN VARCHAR2,
95 parent_low IN VARCHAR2,
96 value_set_id IN NUMBER) RETURN VARCHAR2;
97
98 FUNCTION lock_dim_value_sets (dim_short_name VARCHAR2,
99 source_lgr_group_id NUMBER) RETURN VARCHAR2;
100
101 PROCEDURE release_value_set_lock(dim_short_name VARCHAR2, source_lgr_group_id NUMBER,
102 value_set_id NUMBER);
103
104
105 FUNCTION release_dimension_lock (dim_short_name VARCHAR2,
106 source_lgr_group_id NUMBER) RETURN VARCHAR2;
107
108
109 PROCEDURE insert_dim_value_sets (dim_short_name VARCHAR2, source_lgr_group_id NUMBER);
110
111 FUNCTION flatten_hierarchy (dim_short_name VARCHAR2,
112 source_lgr_group_id NUMBER,
113 user_id IN NUMBER,
114 resp_id IN NUMBER,
115 appl_id IN NUMBER) RETURN VARCHAR2;
116
117 PROCEDURE insert_tl_records;
118
119 PROCEDURE insert_tl_records_for_id(value_id number);
120
121 PROCEDURE delete_tl_records_for_id(value_id number);
122
123 FUNCTION get_compiled_value_attr(value_set_id NUMBER) RETURN VARCHAR2;
124
125 PROCEDURE launch( dim_short_name IN VARCHAR2,
126 source_ledger_group_id IN NUMBER);
127
128 PROCEDURE delete_dim_value_sets(dim_short_name VARCHAR2,
129 source_lgr_group_id NUMBER);
130
131 PROCEDURE insert_fnd_norm_hier_rec( parent IN VARCHAR2,
132 child IN VARCHAR2,
133 range_attr IN VARCHAR2,
134 range_low IN VARCHAR2,
135 range_high IN VARCHAR2,
136 value_set_id IN NUMBER);
137
138 PROCEDURE delete_fnd_norm_hier_rec( parent IN VARCHAR2,
139 child IN VARCHAR2,
140 range_attr IN VARCHAR2,
141 range_low IN VARCHAR2,
142 range_high IN VARCHAR2,
143 value_set_id IN NUMBER);
144
145 FUNCTION access_test RETURN VARCHAR2;
146
147 END FII_FDHM_PKG ;