APPS.CN_RULEATTRIBUTE_PUB dependencies on CN_ATTRIBUTE_RULES

Line 233: SELECT cn_attribute_rules_s.NEXTVAL

229: WHERE name = l_RuleAttribute_rec.object_name
230: AND table_id = -11803 and
231: org_id=l_RuleAttribute_rec.org_id;
232:
233: SELECT cn_attribute_rules_s.NEXTVAL
234: INTO l_ruleattribute_rec_pvt.attribute_rule_id
235: FROM dual;
236:
237: SELECT count(1)

Line 545: cn_attribute_rules.column_id%TYPE,

541: org_id=p_org_id;
542:
543: CURSOR get_attribute_rules(p_rule_id IN cn_rules.rule_id%TYPE,
544: p_column_id IN
545: cn_attribute_rules.column_id%TYPE,
546: p_org_id IN cn_rules.org_id%TYPE) IS
547: SELECT attribute_rule_id
548: FROM cn_attribute_rules
549: WHERE rule_id = p_rule_id

Line 548: FROM cn_attribute_rules

544: p_column_id IN
545: cn_attribute_rules.column_id%TYPE,
546: p_org_id IN cn_rules.org_id%TYPE) IS
547: SELECT attribute_rule_id
548: FROM cn_attribute_rules
549: WHERE rule_id = p_rule_id
550: AND column_id = p_column_id and
551: org_id=p_org_id;
552:

Line 858: FROM cn_attribute_rules

854:
855: /*
856: SELECT attribute_rule_id
857: INTO l_ruleattribute_rec_pvt.attribute_rule_id
858: FROM cn_attribute_rules
859: WHERE rule_id = i.rule_id
860: AND column_id = l_object_id;
861:
862: SELECT attribute_rule_id

Line 864: FROM cn_attribute_rules

860: AND column_id = l_object_id;
861:
862: SELECT attribute_rule_id
863: INTO l_old_ruleattribute_rec_pvt.attribute_rule_id
864: FROM cn_attribute_rules
865: WHERE rule_id = i.rule_id
866: AND column_id = l_old_object_id;
867: */
868:

Line 1140: p_column_id IN cn_attribute_rules.column_id%TYPE,

1136: AND name = p_rule_name
1137: AND org_id = p_org_id;
1138:
1139: CURSOR get_attribute_rules(p_rule_id IN cn_rules.rule_id%TYPE,
1140: p_column_id IN cn_attribute_rules.column_id%TYPE,
1141: p_org_id IN cn_rules.org_id%TYPE) IS
1142: SELECT attribute_rule_id,object_version_number
1143: FROM cn_attribute_rules
1144: WHERE rule_id = p_rule_id

Line 1143: FROM cn_attribute_rules

1139: CURSOR get_attribute_rules(p_rule_id IN cn_rules.rule_id%TYPE,
1140: p_column_id IN cn_attribute_rules.column_id%TYPE,
1141: p_org_id IN cn_rules.org_id%TYPE) IS
1142: SELECT attribute_rule_id,object_version_number
1143: FROM cn_attribute_rules
1144: WHERE rule_id = p_rule_id
1145: AND column_id = p_column_id
1146: AND org_id = p_org_id;
1147: --

Line 1355: FROM cn_attribute_rules

1351:
1352: /*
1353: SELECT attribute_rule_id
1354: INTO l_ruleattribute_rec_pvt.attribute_rule_id
1355: FROM cn_attribute_rules
1356: WHERE rule_id = i.rule_id
1357: AND column_id = l_object_id;
1358: */
1359: