[Home] [Help]
230:
231: BEGIN
232: SELECT 'DR'
233: INTO seg_value
234: FROM rg_dss_var_selections vs
235: WHERE
236: vs.variable_id = X_Variable_Id
237: AND vs.application_column_name = seg_name;
238: EXCEPTION
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;
1061:
1062: DELETE FROM rg_dss_var_templates
1063: WHERE variable_id = X_Variable_Id;