DBA Data[Home] [Help]

APPS.CNSYIN_ATTR_RULES_PKG dependencies on CN_ATTRIBUTE_RULES

Line 125: INSERT INTO cn_attribute_rules(object_version_number,

121: p_last_update_login NUMBER
122: )
123: IS
124: BEGIN
125: INSERT INTO cn_attribute_rules(object_version_number,
126: attribute_rule_id, column_id,
127: column_value, low_value, high_value,
128: dimension_hierarchy_id, not_flag,
129: rule_id, ruleset_id, last_update_date, last_updated_by,

Line 163: UPDATE cn_attribute_rules

159: p_last_update_login NUMBER
160: )
161: IS
162: BEGIN
163: UPDATE cn_attribute_rules
164: SET column_id = p_column_id,
165: object_version_number = p_object_version_number + 1,
166: column_value = p_column_value,
167: low_value = p_low_value,

Line 189: DELETE FROM cn_attribute_rules

185: PROCEDURE delete_row(p_attribute_rule_id NUMBER )
186: IS
187: BEGIN
188:
189: DELETE FROM cn_attribute_rules
190: WHERE attribute_rule_id = p_attribute_rule_id;
191:
192: END Delete_Row;
193: