APPS.RG_DSS_VARIABLES_PKG dependencies on RG_DSS_VAR_DIMENSIONS

Line 22: FROM rg_dss_var_dimensions

18: NumRecords NUMBER;
19: BEGIN
20: SELECT COUNT(variable_id)
21: INTO NumRecords
22: FROM rg_dss_var_dimensions
23: WHERE variable_id = X_Variable_Id;
24:
25: RETURN(NumRecords);
26: END num_dimensions;

Line 64: FROM rg_dss_var_dimensions vdm,

60: INTO dummy
61: FROM dual
62: WHERE NOT EXISTS
63: (SELECT 1
64: FROM rg_dss_var_dimensions vdm,
65: rg_dss_dimensions dim
66: WHERE vdm.variable_id = X_Variable_Id
67: AND vdm.dimension_id = dim.dimension_id
68: AND dim.dimension_type = 'T' );

Line 82: FROM rg_dss_var_dimensions vdm,

78: INTO dummy
79: FROM dual
80: WHERE NOT EXISTS
81: (SELECT 1
82: FROM rg_dss_var_dimensions vdm,
83: rg_dss_dimensions dim
84: WHERE vdm.variable_id = X_Variable_Id
85: AND vdm.dimension_id = dim.dimension_id
86: AND dim.level_code = 'S' );

Line 215: rg_dss_var_dimensions vd

211: SELECT decode(dim.level_code,'D','D','S','R','D')
212: INTO seg_value
213: FROM rg_dss_dimensions dim,
214: rg_dss_dim_segments ds,
215: rg_dss_var_dimensions vd
216: WHERE ds.dimension_id = vd.dimension_id
217: AND vd.variable_id = X_Variable_Id
218: AND ds.application_column_name = seg_name
219: AND vd.dimension_id = dim.dimension_id;

Line 1056: DELETE FROM rg_dss_var_dimensions

1052: FND_MESSAGE.set_token('OBJECT', 'RG_DSS_VARIABLE', TRUE);
1053: APP_EXCEPTION.raise_exception;
1054: END IF;
1055:
1056: DELETE FROM rg_dss_var_dimensions
1057: WHERE variable_id = X_Variable_Id;
1058:
1059: DELETE FROM rg_dss_var_selections
1060: WHERE variable_id = X_Variable_Id;