APPS.CN_CLASSIFICATION_GEN dependencies on CN_ATTRIBUTE_RULES

Line 91: x_value cn_attribute_rules.column_value%TYPE; --AE 09-18-95

87: l_dummy NUMBER := '-1000';
88: l_dummy_date VARCHAR2(60):= '01/01/1600';
89:
90:
91: x_value cn_attribute_rules.column_value%TYPE; --AE 09-18-95
92: x_high_value cn_attribute_rules.high_value%TYPE; --AE
93: x_low_value cn_attribute_rules.low_value%TYPE; --AE
94: x_ruleset_id cn_rulesets.ruleset_id%TYPE; -- RK
95:

Line 92: x_high_value cn_attribute_rules.high_value%TYPE; --AE

88: l_dummy_date VARCHAR2(60):= '01/01/1600';
89:
90:
91: x_value cn_attribute_rules.column_value%TYPE; --AE 09-18-95
92: x_high_value cn_attribute_rules.high_value%TYPE; --AE
93: x_low_value cn_attribute_rules.low_value%TYPE; --AE
94: x_ruleset_id cn_rulesets.ruleset_id%TYPE; -- RK
95:
96: cached_org_id integer;

Line 93: x_low_value cn_attribute_rules.low_value%TYPE; --AE

89:
90:
91: x_value cn_attribute_rules.column_value%TYPE; --AE 09-18-95
92: x_high_value cn_attribute_rules.high_value%TYPE; --AE
93: x_low_value cn_attribute_rules.low_value%TYPE; --AE
94: x_ruleset_id cn_rulesets.ruleset_id%TYPE; -- RK
95:
96: cached_org_id integer;
97: cached_org_append varchar2(100);

Line 106: FROM cn_attribute_rules car, cn_obj_columns_v cocv

102: --which will enable to distinguish between numeric and alphanumeric usage
103: --of the attribute columns
104: column_value value, high_value, low_value,
105: not_flag, dimension_hierarchy_id
106: FROM cn_attribute_rules car, cn_obj_columns_v cocv
107: WHERE rule_id = X_rule_id
108: AND car.org_id=cocv.org_id
109: and car.org_id=x_org_id
110: AND cocv.column_id = car.column_id;

Line 322: FROM cn_attribute_rules car, cn_obj_columns_v cocv

318: CURSOR attribute_rules_cursor IS
319: SELECT attribute_rule_id, LOWER(cocv.name) column_name,
320: cocv.column_datatype data_type,cocv.data_type datatype,column_value value,
321: high_value, low_value, not_flag, dimension_hierarchy_id
322: FROM cn_attribute_rules car, cn_obj_columns_v cocv
323: WHERE rule_id = X_rule_id
324: and car.org_id= cocv.org_id
325: AND cocv.column_id = car.column_id;
326: CURSOR rule_attr_expr_cursor IS