[Home] [Help]
PACKAGE: APPS.RG_DSS_VARIABLES_PKG
Source
1 PACKAGE RG_DSS_VARIABLES_PKG AUTHID CURRENT_USER as
2 /*$Header: rgidvars.pls 120.3 2003/04/29 00:47:32 djogg ship $*/
3
4 /* Name: get_new_id
5 * Desc: Return the next value from the sequence rg_dss_variables_s.
6 *
7 * History:
8 * 09/14/95 S. Rahman Created.
9 */
10 FUNCTION get_new_id RETURN NUMBER;
11
12
13 FUNCTION num_dimensions(X_Variable_Id NUMBER) RETURN NUMBER;
14
15 /* Name: used_in_frozen_system
16 * Desc: Return TRUE if the financial data is used in a frozen system;
17 * FALSE otherwise.
18 *
19 * History:
20 * 06/26/95 S. Rahman Created.
21 */
22 FUNCTION used_in_frozen_system(X_Variable_Id NUMBER) RETURN BOOLEAN;
23
24
25 /* Name: check_for_details
26 * Desc: Check if at least one dimension exists for the variable,
27 * and if at least one summary dimension exists for a summary
28 * level variable. Raise exception otherwise.
29 *
30 * History:
31 * 00/14/95 S. Rahman Created.
32 * 07/03/97 Charmaine Wang Modified for R11.
33 */
34 PROCEDURE check_for_details(X_Variable_Id NUMBER,
35 X_Level_Code VARCHAR2);
36
37
38 /* Name: check_unique_name
39 * Desc: Check if the variable name already exists. If it does,
40 * raise an exception. If it doesn't, do nothing.
41 *
42 * History:
43 * 06/20/95 S. Rahman Created.
44 */
45 PROCEDURE check_unique_name(X_Rowid VARCHAR2, X_Name VARCHAR2);
46
47
48 /* Name: check_unique_object_name
49 * Desc: Check if the object name already exists. If it does,
50 * raise an exception. If it doesn't, do nothing.
51 *
52 * History:
53 * 06/26/95 S. Rahman Created.
54 */
55 PROCEDURE check_unique_object_name(X_Rowid VARCHAR2, X_Object_Name VARCHAR2);
56
57
58 /* Name: check_references
59 * Desc: Check if the variable is used in a system.
60 *
61 * History:
62 * 07/17/95 S. Rahman Created.
63 */
64 PROCEDURE check_references(X_Variable_Id NUMBER);
65
66 -- Function generate_matching_struc
67 -- Purpose
68 -- Generate the matching structure for summary templates
69 -- History:
70 -- 07/02/97 Charmaine Wang Created.
71
72 PROCEDURE generate_matching_struc(
73 X_Variable_Id NUMBER,
74 X_Chart_of_Account_Id NUMBER,
75 X_Segment1_Type IN OUT NOCOPY VARCHAR2,
76 X_Segment2_Type IN OUT NOCOPY VARCHAR2,
77 X_Segment3_Type IN OUT NOCOPY VARCHAR2,
78 X_Segment4_Type IN OUT NOCOPY VARCHAR2,
79 X_Segment5_Type IN OUT NOCOPY VARCHAR2,
80 X_Segment6_Type IN OUT NOCOPY VARCHAR2,
81 X_Segment7_Type IN OUT NOCOPY VARCHAR2,
82 X_Segment8_Type IN OUT NOCOPY VARCHAR2,
83 X_Segment9_Type IN OUT NOCOPY VARCHAR2,
84 X_Segment10_Type IN OUT NOCOPY VARCHAR2,
85 X_Segment11_Type IN OUT NOCOPY VARCHAR2,
86 X_Segment12_Type IN OUT NOCOPY VARCHAR2,
87 X_Segment13_Type IN OUT NOCOPY VARCHAR2,
88 X_Segment14_Type IN OUT NOCOPY VARCHAR2,
89 X_Segment15_Type IN OUT NOCOPY VARCHAR2,
90 X_Segment16_Type IN OUT NOCOPY VARCHAR2,
91 X_Segment17_Type IN OUT NOCOPY VARCHAR2,
92 X_Segment18_Type IN OUT NOCOPY VARCHAR2,
93 X_Segment19_Type IN OUT NOCOPY VARCHAR2,
94 X_Segment20_Type IN OUT NOCOPY VARCHAR2,
95 X_Segment21_Type IN OUT NOCOPY VARCHAR2,
96 X_Segment22_Type IN OUT NOCOPY VARCHAR2,
97 X_Segment23_Type IN OUT NOCOPY VARCHAR2,
98 X_Segment24_Type IN OUT NOCOPY VARCHAR2,
99 X_Segment25_Type IN OUT NOCOPY VARCHAR2,
100 X_Segment26_Type IN OUT NOCOPY VARCHAR2,
101 X_Segment27_Type IN OUT NOCOPY VARCHAR2,
102 X_Segment28_Type IN OUT NOCOPY VARCHAR2,
103 X_Segment29_Type IN OUT NOCOPY VARCHAR2,
104 X_Segment30_Type IN OUT NOCOPY VARCHAR2
105 );
106
107 /* Name: insert_row
108 * Desc: Insert a row into rg_dss_variables. Ensure that the
109 * variable name doesn't exist already. Assign the
110 * primary key (variable_id). Return the rowid of the inserted
111 * row to the form. Also generates matching structure.
112 *
113 * History:
114 * 06/20/95 S. Rahman Created.
115 * 07/03/97 Charmaine Wang Modified for R11.
116 */
117 PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
118 X_Variable_Id IN OUT NOCOPY NUMBER,
119 X_Name VARCHAR2,
120 X_Object_Name VARCHAR2,
121 X_Column_Label VARCHAR2,
122 X_Balance_Type VARCHAR2,
123 X_Currency_Type VARCHAR2,
124 X_Currency_Code VARCHAR2,
125 X_Id_Flex_Code VARCHAR2,
126 X_Id_Flex_Num NUMBER,
127 X_Ledger_Id NUMBER,
128 X_Budget_Version_Id NUMBER,
129 X_Encumbrance_Type_Id NUMBER,
130 X_Level_Code VARCHAR2,
131 X_Status_Code VARCHAR2,
132 X_Description VARCHAR2,
133 X_Last_Update_Date DATE,
134 X_Last_Updated_By NUMBER,
135 X_Last_Update_Login NUMBER,
136 X_Creation_Date DATE,
137 X_Created_By NUMBER,
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 X_Segment1_Type IN OUT NOCOPY VARCHAR2,
155 X_Segment2_Type IN OUT NOCOPY VARCHAR2,
156 X_Segment3_Type IN OUT NOCOPY VARCHAR2,
157 X_Segment4_Type IN OUT NOCOPY VARCHAR2,
158 X_Segment5_Type IN OUT NOCOPY VARCHAR2,
159 X_Segment6_Type IN OUT NOCOPY VARCHAR2,
160 X_Segment7_Type IN OUT NOCOPY VARCHAR2,
161 X_Segment8_Type IN OUT NOCOPY VARCHAR2,
162 X_Segment9_Type IN OUT NOCOPY VARCHAR2,
163 X_Segment10_Type IN OUT NOCOPY VARCHAR2,
164 X_Segment11_Type IN OUT NOCOPY VARCHAR2,
165 X_Segment12_Type IN OUT NOCOPY VARCHAR2,
166 X_Segment13_Type IN OUT NOCOPY VARCHAR2,
167 X_Segment14_Type IN OUT NOCOPY VARCHAR2,
168 X_Segment15_Type IN OUT NOCOPY VARCHAR2,
169 X_Segment16_Type IN OUT NOCOPY VARCHAR2,
170 X_Segment17_Type IN OUT NOCOPY VARCHAR2,
171 X_Segment18_Type IN OUT NOCOPY VARCHAR2,
172 X_Segment19_Type IN OUT NOCOPY VARCHAR2,
173 X_Segment20_Type IN OUT NOCOPY VARCHAR2,
174 X_Segment21_Type IN OUT NOCOPY VARCHAR2,
175 X_Segment22_Type IN OUT NOCOPY VARCHAR2,
176 X_Segment23_Type IN OUT NOCOPY VARCHAR2,
177 X_Segment24_Type IN OUT NOCOPY VARCHAR2,
178 X_Segment25_Type IN OUT NOCOPY VARCHAR2,
179 X_Segment26_Type IN OUT NOCOPY VARCHAR2,
180 X_Segment27_Type IN OUT NOCOPY VARCHAR2,
181 X_Segment28_Type IN OUT NOCOPY VARCHAR2,
182 X_Segment29_Type IN OUT NOCOPY VARCHAR2,
183 X_Segment30_Type IN OUT NOCOPY VARCHAR2);
184
185
186 /* Name: lock_row
187 * Desc: Lock the row specified by X_Rowid.
188 *
189 * History:
190 * 06/20/95 S. Rahman Created.
191 */
192 PROCEDURE Lock_Row(X_Rowid VARCHAR2,
193 X_Variable_Id NUMBER,
194 X_Name VARCHAR2,
195 X_Object_Name VARCHAR2,
196 X_Column_Label VARCHAR2,
197 X_Balance_Type VARCHAR2,
198 X_Currency_Type VARCHAR2,
199 X_Currency_Code VARCHAR2,
200 X_Id_Flex_Code VARCHAR2,
201 X_Id_Flex_Num NUMBER,
202 X_Ledger_Id NUMBER,
203 X_Budget_Version_Id NUMBER,
204 X_Encumbrance_Type_Id NUMBER,
205 X_Level_Code VARCHAR2,
206 X_Status_Code VARCHAR2,
207 X_Description VARCHAR2,
208 X_Context VARCHAR2,
209 X_Attribute1 VARCHAR2,
210 X_Attribute2 VARCHAR2,
211 X_Attribute3 VARCHAR2,
212 X_Attribute4 VARCHAR2,
213 X_Attribute5 VARCHAR2,
214 X_Attribute6 VARCHAR2,
215 X_Attribute7 VARCHAR2,
216 X_Attribute8 VARCHAR2,
217 X_Attribute9 VARCHAR2,
218 X_Attribute10 VARCHAR2,
219 X_Attribute11 VARCHAR2,
220 X_Attribute12 VARCHAR2,
221 X_Attribute13 VARCHAR2,
222 X_Attribute14 VARCHAR2,
223 X_Attribute15 VARCHAR2,
224 X_Segment1_Type VARCHAR2,
225 X_Segment2_Type VARCHAR2,
226 X_Segment3_Type VARCHAR2,
227 X_Segment4_Type VARCHAR2,
228 X_Segment5_Type VARCHAR2,
229 X_Segment6_Type VARCHAR2,
230 X_Segment7_Type VARCHAR2,
231 X_Segment8_Type VARCHAR2,
232 X_Segment9_Type VARCHAR2,
233 X_Segment10_Type VARCHAR2,
234 X_Segment11_Type VARCHAR2,
235 X_Segment12_Type VARCHAR2,
236 X_Segment13_Type VARCHAR2,
237 X_Segment14_Type VARCHAR2,
238 X_Segment15_Type VARCHAR2,
239 X_Segment16_Type VARCHAR2,
240 X_Segment17_Type VARCHAR2,
241 X_Segment18_Type VARCHAR2,
242 X_Segment19_Type VARCHAR2,
243 X_Segment20_Type VARCHAR2,
244 X_Segment21_Type VARCHAR2,
245 X_Segment22_Type VARCHAR2,
246 X_Segment23_Type VARCHAR2,
247 X_Segment24_Type VARCHAR2,
251 X_Segment28_Type VARCHAR2,
248 X_Segment25_Type VARCHAR2,
249 X_Segment26_Type VARCHAR2,
250 X_Segment27_Type VARCHAR2,
252 X_Segment29_Type VARCHAR2,
253 X_Segment30_Type VARCHAR2
254 );
255
256
257 /* Name: update_row
258 * Desc: Update the row specified by X_Rowid.
259 * Also generates matching structure.
260 *
261 * History:
262 * 06/20/95 S. Rahman Created.
263 * 07/03/97 Charmaine Wang Modified.
264 */
265 PROCEDURE Update_Row(X_Rowid VARCHAR2,
266 X_Variable_Id NUMBER,
267 X_Name VARCHAR2,
268 X_Object_Name VARCHAR2,
269 X_Column_Label VARCHAR2,
270 X_Balance_Type VARCHAR2,
271 X_Currency_Type VARCHAR2,
272 X_Currency_Code VARCHAR2,
273 X_Id_Flex_Code VARCHAR2,
274 X_Id_Flex_Num NUMBER,
275 X_Ledger_Id NUMBER,
276 X_Budget_Version_Id NUMBER,
277 X_Encumbrance_Type_Id NUMBER,
278 X_Level_Code VARCHAR2,
279 X_Status_Code VARCHAR2,
280 X_Description VARCHAR2,
281 X_Last_Update_Date DATE,
282 X_Last_Updated_By NUMBER,
283 X_Last_Update_Login NUMBER,
284 X_Context VARCHAR2,
285 X_Attribute1 VARCHAR2,
286 X_Attribute2 VARCHAR2,
287 X_Attribute3 VARCHAR2,
288 X_Attribute4 VARCHAR2,
289 X_Attribute5 VARCHAR2,
290 X_Attribute6 VARCHAR2,
291 X_Attribute7 VARCHAR2,
292 X_Attribute8 VARCHAR2,
293 X_Attribute9 VARCHAR2,
294 X_Attribute10 VARCHAR2,
295 X_Attribute11 VARCHAR2,
296 X_Attribute12 VARCHAR2,
297 X_Attribute13 VARCHAR2,
298 X_Attribute14 VARCHAR2,
299 X_Attribute15 VARCHAR2,
300 X_Segment1_Type IN OUT NOCOPY VARCHAR2,
301 X_Segment2_Type IN OUT NOCOPY VARCHAR2,
302 X_Segment3_Type IN OUT NOCOPY VARCHAR2,
303 X_Segment4_Type IN OUT NOCOPY VARCHAR2,
304 X_Segment5_Type IN OUT NOCOPY VARCHAR2,
305 X_Segment6_Type IN OUT NOCOPY VARCHAR2,
306 X_Segment7_Type IN OUT NOCOPY VARCHAR2,
307 X_Segment8_Type IN OUT NOCOPY VARCHAR2,
308 X_Segment9_Type IN OUT NOCOPY VARCHAR2,
309 X_Segment10_Type IN OUT NOCOPY VARCHAR2,
310 X_Segment11_Type IN OUT NOCOPY VARCHAR2,
311 X_Segment12_Type IN OUT NOCOPY VARCHAR2,
312 X_Segment13_Type IN OUT NOCOPY VARCHAR2,
313 X_Segment14_Type IN OUT NOCOPY VARCHAR2,
314 X_Segment15_Type IN OUT NOCOPY VARCHAR2,
315 X_Segment16_Type IN OUT NOCOPY VARCHAR2,
316 X_Segment17_Type IN OUT NOCOPY VARCHAR2,
317 X_Segment18_Type IN OUT NOCOPY VARCHAR2,
318 X_Segment19_Type IN OUT NOCOPY VARCHAR2,
319 X_Segment20_Type IN OUT NOCOPY VARCHAR2,
320 X_Segment21_Type IN OUT NOCOPY VARCHAR2,
321 X_Segment22_Type IN OUT NOCOPY VARCHAR2,
322 X_Segment23_Type IN OUT NOCOPY VARCHAR2,
323 X_Segment24_Type IN OUT NOCOPY VARCHAR2,
324 X_Segment25_Type IN OUT NOCOPY VARCHAR2,
325 X_Segment26_Type IN OUT NOCOPY VARCHAR2,
326 X_Segment27_Type IN OUT NOCOPY VARCHAR2,
327 X_Segment28_Type IN OUT NOCOPY VARCHAR2,
328 X_Segment29_Type IN OUT NOCOPY VARCHAR2,
329 X_Segment30_Type IN OUT NOCOPY VARCHAR2);
330
331
332 /* Name: delete_row
333 * Desc: Delete the row specified by X_Rowid.
334 *
335 * History:
336 * 06/20/95 S. Rahman Created.
337 */
338 PROCEDURE Delete_Row(X_Rowid VARCHAR2, X_Variable_Id NUMBER);
339
340
341 END RG_DSS_VARIABLES_PKG;