APPS.RG_DSS_VAR_DIMENSIONS_PKG dependencies on RG_DSS_VAR_DIMENSIONS

Line 1: PACKAGE BODY RG_DSS_VAR_DIMENSIONS_PKG as

1: PACKAGE BODY RG_DSS_VAR_DIMENSIONS_PKG as
2: /* $Header: rgidvdmb.pls 120.2 2002/11/14 02:59:25 djogg ship $ */
3:
4:
5:

Line 15: FROM rg_dss_var_dimensions

11: dummy NUMBER;
12: BEGIN
13: SELECT 1
14: INTO dummy
15: FROM rg_dss_var_dimensions
16: WHERE variable_id = X_Variable_Id
17: AND sequence = X_Sequence
18: AND ((X_Rowid IS NULL) OR (rowid <> X_Rowid));
19:

Line 40: FROM rg_dss_var_dimensions

36: dummy NUMBER;
37: BEGIN
38: SELECT 1
39: INTO dummy
40: FROM rg_dss_var_dimensions
41: WHERE variable_id = X_Variable_Id
42: AND dimension_id = X_Dimension_Id
43: AND ((X_Rowid IS NULL) OR (rowid <> X_Rowid));
44:

Line 89: FROM rg_dss_var_dimensions

85: NumRecs NUMBER;
86:
87: CURSOR C IS
88: SELECT rowid
89: FROM rg_dss_var_dimensions
90: WHERE variable_id = X_Variable_Id
91: AND sequence = X_Sequence;
92:
93: BEGIN

Line 108: FROM rg_dss_var_dimensions

104: END IF;
105:
106: SELECT count(*)
107: INTO NumRecs
108: FROM rg_dss_var_dimensions
109: WHERE variable_id = X_Variable_Id;
110:
111: IF (NumRecs >= 10) THEN
112: -- Maximum number of dimensions is 10

Line 121: INSERT INTO rg_dss_var_dimensions(

117:
118: check_unique_sequence(X_Rowid, X_Variable_Id, X_Sequence);
119: check_unique_dimension(X_Rowid, X_Variable_Id, X_Dimension_Id);
120:
121: INSERT INTO rg_dss_var_dimensions(
122: variable_id,
123: sequence,
124: dimension_id,
125: last_update_date,

Line 210: FROM rg_dss_var_dimensions

206: X_Attribute15 VARCHAR2
207: ) IS
208: CURSOR C IS
209: SELECT *
210: FROM rg_dss_var_dimensions
211: WHERE rowid = X_Rowid
212: FOR UPDATE of variable_id NOWAIT;
213: Recinfo C%ROWTYPE;
214: BEGIN

Line 323: UPDATE rg_dss_var_dimensions

319: FND_MESSAGE.set_token('OBJECT', 'RG_DSS_VARIABLE', TRUE);
320: APP_EXCEPTION.raise_exception;
321: END IF;
322:
323: UPDATE rg_dss_var_dimensions
324: SET
325: variable_id = X_Variable_Id,
326: sequence = X_Sequence,
327: dimension_id = X_Dimension_Id,

Line 366: DELETE FROM rg_dss_var_dimensions

362: FND_MESSAGE.set_token('OBJECT', 'RG_DSS_VARIABLE', TRUE);
363: APP_EXCEPTION.raise_exception;
364: END IF;
365:
366: DELETE FROM rg_dss_var_dimensions
367: WHERE rowid = X_Rowid;
368:
369: IF (SQL%NOTFOUND) THEN
370: RAISE NO_DATA_FOUND;

Line 379: END RG_DSS_VAR_DIMENSIONS_PKG;

375: RG_DSS_VARIABLES_PKG.check_for_details(X_Variable_Id,'D');
376: END Delete_Row;
377:
378:
379: END RG_DSS_VAR_DIMENSIONS_PKG;