[Home] [Help]
PACKAGE: APPS.CNDIHY_HIERARCHY_PKG
Source
1 PACKAGE CNDIHY_Hierarchy_PKG AUTHID CURRENT_USER as
2 -- $Header: cndihyas.pls 115.1 99/07/16 07:06:20 porting ship $
3
4
5 --
6 -- Procedure Name
7 -- default_row
8 -- History
9 -- 12/28/93 Paul Mitchell Created
10 --
11 PROCEDURE Default_Row (X_hierarchy_id IN OUT number);
12 PROCEDURE Default_Period_Row (X_hierarchy_id IN OUT number);
13
14
15 PROCEDURE Populate_Period_Fields (X_start_period number,
16 X_start_name IN OUT varchar2,
17 X_end_period number,
18 X_end_name IN OUT varchar2);
19 --
20 -- Procedure Name
21 -- populate_fields
22 -- History
23 -- 12/28/93 Tony Lower Created
24 --
25 PROCEDURE Populate_Fields (X_dimension_id number,
26 X_hierarchy_id number,
27 X_select_clause IN OUT varchar2);
28
29
30 --
31 -- Procedure Name
32 -- populate_fields
33 -- History
34 -- 06/01/94 Tony Lower Created
35 --
36 PROCEDURE Populate_Value_Fields (X_value_id number,
37 X_dim_hierarchy_id number,
38 X_name IN OUT varchar2);
39
40 --
41 -- Procedure Name
42 -- default_row
43 -- History
44 -- 12/28/93 Paul Mitchell Created
45 --
46 PROCEDURE Root_Node ( X_hierarchy_id number,
47 X_value_id IN OUT number);
48
49
50 --
51 -- Procedure Name
52 -- Synchronize_Node
53 -- History
54 -- 12/28/93 Paul Mitchell Created
55 --
56 PROCEDURE Synchronize_Node ( X_value_id IN OUT number,
57 X_name varchar2,
58 X_dim_hierarchy_id number);
59
60
61 --
62 -- Procedure Name
63 -- Synchronize_Node
64 -- History
65 -- 06/02/94 Tony Lower Created
66 --
67 PROCEDURE Shift_Parent( X_parent_value_id number,
68 X_dim_hierarchy_id number,
69 X_central_root_node number,
70 X_central_value_id IN OUT number,
71 X_central_parent_id IN OUT number);
72
73 --
74 -- Procedure Name
75 -- Cascade_Number
76 -- History
77 -- 7/19/93 Tony Lower Created
78 --
79 PROCEDURE Cascade_Number(X_value_id number,
80 X_dim_hierarchy_id number,
81 X_cascade_number IN OUT number);
82
83 --
84 -- Procedure Name
85 -- Cascade_Delete
86 -- History
87 -- 7/19/93 Tony Lower Created
88 --
89 PROCEDURE Cascade_Delete(X_value_id number,
90 X_parent_value_id number,
91 X_dim_hierarchy_id number);
92
93 --
94 -- Procedure Name
95 -- Insert_Row
96 -- History
97 -- 7/19/93 Tony Lower Created
98 --
99 PROCEDURE Insert_Row(X_value_id number,
100 X_parent_Value_id number,
101 X_dim_hierarchy_id number);
102
103 --
104 -- Procedure Name
105 -- Insert_Root
106 -- History
107 -- 7/25/93 Tony Lower Created
108 --
109 PROCEDURE Insert_Root(X_value_id number,
110 X_dim_hierarchy_id number);
111
112 --
113 -- Procedure Name
114 -- Fetch_Row_counts
115 -- History
116 -- 7/25/93 Tony Lower Created
117 --
118 PROCEDURE Fetch_Row_Counts (X_parent_value_id number,
119 X_value_id number,
120 X_dim_hierarchy_id number,
121 X_parent_rows IN OUT number,
122 X_child_rows IN OUT number);
123
124 --
125 -- Procedure Name
126 -- Fetch_Row_counts
127 -- History
128 -- 7/26/93 Tony Lower Created
129 --
130 PROCEDURE Create_Dummy_Node (X_value_id IN OUT number,
131 X_name varchar2,
132 X_dim_hierarchy_id number);
133
134 END CNDIHY_Hierarchy_PKG;