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;