[Home] [Help]
PACKAGE: APPS.RG_DSS_DIMENSIONS_PKG
Source
1 PACKAGE RG_DSS_DIMENSIONS_PKG AS
2 /* $Header: rgiddims.pls 120.3 2002/11/14 03:34:25 djogg ship $ */
3 --
4 -- Name
5 -- RG_DSS_DIMENSIONS_PKG
6 -- Purpose
7 -- to include all server side procedures and packages for table
8 -- rg_dss_dimensions
9 -- Notes
10 --
11 -- History
12 -- 06/16/95 A Chen Created
13 --
14 --
15 -- Procedures
16
17
18 /* Name: get_cache_data
19 * Desc: Gets cache data.
20 *
21 * History:
22 * 08/30/95 S. Rahman Created.
23 */
24 PROCEDURE get_cache_data(COAId NUMBER,
25 AccountingSegmentColumn IN OUT NOCOPY VARCHAR2);
26
27
28 /* Name: get_new_id
29 * Desc: Gets a new id from the sequence RG_DSS_DIMENSIONS_S
30 *
31 * History:
32 * 10/09/95 S. Rahman Created.
33 */
34 FUNCTION get_new_id RETURN NUMBER;
35
36
37 /* Name: used_in_frozen_system
38 * Desc: Return 1 if the dimension is used in a frozen system;
39 * 0 otherwise. NOTE: this function returns a NUMBER instead of
40 * a BOOLEAN because it is called from a WHERE clause in
41 * RG_DSS_HIERARCHIES_PKG.used_in_frozen_system function.
42 *
43 * History:
44 * 07/31/95 S. Rahman Created.
45 */
46 FUNCTION used_in_frozen_system(X_Dimension_Id NUMBER) RETURN NUMBER;
47 PRAGMA RESTRICT_REFERENCES(used_in_frozen_system, WNDS, WNPS);
48
49
50 -- Name
51 -- check_unique_name
52 -- Purpose
53 -- unique check for name
54 -- Arguments
55 -- name
56 --
57 PROCEDURE check_unique_name(X_rowid VARCHAR2,
58 X_name VARCHAR2);
59
60
61 -- Name
62 -- check_unique_object_name
63 -- Purpose
64 -- unique check for object name
65 -- Arguments
66 -- object name
67 --
68 PROCEDURE check_unique_object_name(X_rowid VARCHAR2,
69 X_object_name VARCHAR2);
70
71
72 -- Name
73 -- check_unique_object_prefix
74 -- Purpose
75 -- unique check for object prefix
76 -- Arguments
77 -- object prefix
78 --
79 PROCEDURE check_unique_object_prefix(X_rowid VARCHAR2,
80 X_object_prefix VARCHAR2);
81
82
83 -- Name
84 -- check_references
85 -- Purpose
86 -- Referential integrity check on rg_dss_dimensions
87 -- Arguments
88 -- dimension_id
89 --
90 PROCEDURE check_references(X_dimension_id NUMBER);
91
92
93 FUNCTION num_details(X_Dimension_Id NUMBER) RETURN NUMBER;
94
95
96 PROCEDURE set_dimension_type(
97 X_Dimension_Id NUMBER,
98 X_Dimension_Type IN OUT NOCOPY VARCHAR2,
99 Num_Records NUMBER DEFAULT NULL);
100
101
102 PROCEDURE pre_insert(X_Rowid VARCHAR2,
103 X_Name VARCHAR2,
104 X_Object_Name VARCHAR2,
105 X_Object_Prefix VARCHAR2,
106 X_Level_Code VARCHAR2,
107 X_Dimension_Id IN OUT NOCOPY NUMBER,
108 X_Dimension_Type IN OUT NOCOPY VARCHAR2);
109
110
111 PROCEDURE pre_update(X_Level_Code VARCHAR2,
112 X_Dimension_Id NUMBER);
113
114
115 PROCEDURE pre_delete(X_Dimension_Id NUMBER);
116
117
118 PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
119 X_Dimension_Id NUMBER,
120 X_Name VARCHAR2,
121 X_Object_Name VARCHAR2,
122 X_Object_Prefix VARCHAR2,
123 X_Value_Prefix VARCHAR2,
124 X_Row_Label VARCHAR2,
125 X_Column_Label VARCHAR2,
126 X_Selector_Label VARCHAR2,
127 X_Level_Code VARCHAR2,
128 X_Dimension_Type VARCHAR2,
129 X_Dimension_By_Currency VARCHAR2,
130 X_Last_Update_Date DATE,
131 X_Last_Updated_By NUMBER,
132 X_Creation_Date DATE,
133 X_Created_By NUMBER,
134 X_Last_Update_Login NUMBER,
135 X_Id_Flex_Code VARCHAR2,
136 X_Id_Flex_Num NUMBER,
137 X_Description VARCHAR2,
138 X_Context VARCHAR2,
139 X_Attribute1 VARCHAR2,
140 X_Attribute2 VARCHAR2,
141 X_Attribute3 VARCHAR2,
142 X_Attribute4 VARCHAR2,
143 X_Attribute5 VARCHAR2,
144 X_Attribute6 VARCHAR2,
145 X_Attribute7 VARCHAR2,
146 X_Attribute8 VARCHAR2,
147 X_Attribute9 VARCHAR2,
148 X_Attribute10 VARCHAR2,
149 X_Attribute11 VARCHAR2,
150 X_Attribute12 VARCHAR2,
151 X_Attribute13 VARCHAR2,
152 X_Attribute14 VARCHAR2,
153 X_Attribute15 VARCHAR2
154 );
155
156 PROCEDURE Update_Row(X_Rowid VARCHAR2,
157 X_Dimension_Id NUMBER,
158 X_Name VARCHAR2,
159 X_Object_Name VARCHAR2,
160 X_Object_Prefix VARCHAR2,
161 X_Value_Prefix VARCHAR2,
162 X_Row_Label VARCHAR2,
163 X_Column_Label VARCHAR2,
164 X_Selector_Label VARCHAR2,
165 X_Level_Code VARCHAR2,
166 X_Dimension_Type VARCHAR2,
167 X_Dimension_By_Currency VARCHAR2,
168 X_Last_Update_Date DATE,
169 X_Last_Updated_By NUMBER,
170 X_Last_Update_Login NUMBER,
171 X_Id_Flex_Code VARCHAR2,
172 X_Id_Flex_Num NUMBER,
173 X_Description VARCHAR2,
174 X_Context VARCHAR2,
175 X_Attribute1 VARCHAR2,
176 X_Attribute2 VARCHAR2,
177 X_Attribute3 VARCHAR2,
178 X_Attribute4 VARCHAR2,
179 X_Attribute5 VARCHAR2,
180 X_Attribute6 VARCHAR2,
181 X_Attribute7 VARCHAR2,
182 X_Attribute8 VARCHAR2,
183 X_Attribute9 VARCHAR2,
184 X_Attribute10 VARCHAR2,
185 X_Attribute11 VARCHAR2,
186 X_Attribute12 VARCHAR2,
187 X_Attribute13 VARCHAR2,
188 X_Attribute14 VARCHAR2,
189 X_Attribute15 VARCHAR2
190 );
191
192 PROCEDURE Load_Row( X_Dimension_Id NUMBER,
193 X_Name VARCHAR2,
194 X_Object_Name VARCHAR2,
195 X_Object_Prefix VARCHAR2,
196 X_Value_Prefix VARCHAR2,
197 X_Row_Label VARCHAR2,
198 X_Column_Label VARCHAR2,
199 X_Selector_Label VARCHAR2,
200 X_Level_Code VARCHAR2,
201 X_Dimension_Type VARCHAR2,
202 X_Dimension_By_Currency VARCHAR2,
203 X_Id_Flex_Code VARCHAR2,
204 X_Id_Flex_Num NUMBER,
205 X_Description VARCHAR2,
206 X_Context VARCHAR2,
207 X_Attribute1 VARCHAR2,
208 X_Attribute2 VARCHAR2,
209 X_Attribute3 VARCHAR2,
210 X_Attribute4 VARCHAR2,
211 X_Attribute5 VARCHAR2,
212 X_Attribute6 VARCHAR2,
213 X_Attribute7 VARCHAR2,
214 X_Attribute8 VARCHAR2,
215 X_Attribute9 VARCHAR2,
216 X_Attribute10 VARCHAR2,
217 X_Attribute11 VARCHAR2,
218 X_Attribute12 VARCHAR2,
219 X_Attribute13 VARCHAR2,
220 X_Attribute14 VARCHAR2,
221 X_Attribute15 VARCHAR2,
222 X_Owner VARCHAR2,
223 X_Force_Edits VARCHAR2);
224
225 PROCEDURE Translate_Row(X_Dimension_Id NUMBER,
226 X_Name VARCHAR2,
227 X_Description VARCHAR2,
228 X_Owner VARCHAR2,
229 X_Force_Edits VARCHAR2);
230
231 END RG_DSS_DIMENSIONS_PKG;