APPS.CN_RULE_PVT dependencies on CN_RULES_HIERARCHY

Line 105: FROM cn_rules_hierarchy cnrh,

101: x_loading_status OUT NOCOPY VARCHAR2 ) RETURN VARCHAR2 IS
102:
103: CURSOR check_siblings_cur IS
104: SELECT count(*) cnt
105: FROM cn_rules_hierarchy cnrh,
106: cn_rules cnr
107: WHERE cnrh.parent_rule_id = p_parent_rule_id
108: AND cnr.ruleset_id = p_ruleset_id
109: AND cnrh.rule_id = cnr.rule_id

Line 120: FROM cn_rules_hierarchy cnrh,

116:
117: CURSOR check_parents_cur (p_parent_rule_id cn_rules.rule_id%TYPE)IS
118: SELECT cnrh.parent_rule_id,
119: cnr.name
120: FROM cn_rules_hierarchy cnrh,
121: cn_rules cnr
122: WHERE cnr.ruleset_id = p_ruleset_id
123: AND cnrh.rule_id = p_parent_rule_id
124: AND cnrh.rule_id = cnr.rule_id

Line 130: l_current_parent_rule_id cn_rules_hierarchy.parent_rule_id%TYPE;

126: AND cnr.org_id=p_org_id;
127:
128: l_check_parents_rec check_parents_cur%ROWTYPE;
129:
130: l_current_parent_rule_id cn_rules_hierarchy.parent_rule_id%TYPE;
131:
132: l_api_name VARCHAR2(30) := 'validate_rule_name';
133:
134: BEGIN

Line 373: FROM cn_rules_hierarchy

369: IF p_rule_rec.sequence_number IS NULL
370: then
371: SELECT nvl(MAX(nvl(sequence_number, 0)),0) + 1
372: INTO l_sequence_number
373: FROM cn_rules_hierarchy
374: WHERE ruleset_id = p_rule_rec.ruleset_id;
375: ELSE
376: l_sequence_number := p_rule_rec.sequence_number;
377: END IF;

Line 892: FROM cn_rules_hierarchy

888: SELECT COUNT(1)
889: INTO l_count
890: FROM
891: ( SELECT rule_id ,ruleset_id
892: FROM cn_rules_hierarchy
893: WHERE ruleset_id=Nvl(p_ruleset_id ,-1002) and org_id=p_org_id
894: CONNECT BY PRIOR rule_id = parent_rule_id
895: START WITH rule_id = Nvl(p_rule_id, -1002)
896: )a WHERE EXISTS