APPS.CN_RULEATTRIBUTE_PVT dependencies on CN_HEAD_HIERARCHIES

Line 459: -- FROM cn_head_hierarchies

455: BEGIN
456:
457: --SELECT head_hierarchy_id
458: -- INTO l_dim_hierarchy_id
459: -- FROM cn_head_hierarchies
460: -- WHERE name = p_value_1;
461:
462: SELECT head_hierarchy_id
463: INTO l_dim_hierarchy_id

Line 464: FROM cn_head_hierarchies

460: -- WHERE name = p_value_1;
461:
462: SELECT head_hierarchy_id
463: INTO l_dim_hierarchy_id
464: FROM cn_head_hierarchies
465: WHERE head_hierarchy_id = p_value_1 and org_id=p_org_id;
466:
467: EXCEPTION
468: WHEN no_data_found then

Line 625: l_dim_hierarchy_id cn_head_hierarchies.head_hierarchy_id%TYPE;

621:
622: l_api_name CONSTANT VARCHAR2(30) := 'Create_RuleAttribute';
623: l_api_version CONSTANT NUMBER := 1.0;
624: l_attr_rule_retvalue NUMBER;
625: l_dim_hierarchy_id cn_head_hierarchies.head_hierarchy_id%TYPE;
626: l_hierarchy_value cn_hierarchy_nodes.value_id%TYPE;
627: l_rowid VARCHAR2(4000);
628: l_sequence_number NUMBER;
629: l_attribute_rule_ret_value NUMBER;

Line 800: FROM cn_head_hierarchies

796: ELSIF p_RuleAttribute_rec.data_flag = 'H'
797: THEN
798: SELECT head_hierarchy_id
799: INTO l_dim_hierarchy_id
800: FROM cn_head_hierarchies
801: --WHERE name = p_RuleAttribute_rec.value_1;
802: WHERE head_hierarchy_id = p_RuleAttribute_rec.value_1 and org_id=p_RuleAttribute_rec.org_id;
803: SELECT hn.value_id
804: INTO l_hierarchy_value

Line 943: l_dim_hierarchy_id cn_head_hierarchies.head_hierarchy_id%TYPE;

939:
940: l_api_name CONSTANT VARCHAR2(30) := 'Update_RuleAttribute';
941: l_api_version CONSTANT NUMBER := 1.0;
942: l_attr_rule_retvalue NUMBER;
943: l_dim_hierarchy_id cn_head_hierarchies.head_hierarchy_id%TYPE;
944: l_hierarchy_value cn_hierarchy_nodes.value_id%TYPE;
945: l_rowid VARCHAR2(4000);
946: l_sequence_number NUMBER;
947: l_attribute_rule_ret_value NUMBER;

Line 1185: FROM cn_head_hierarchies

1181:
1182: -- Modified By Kumar
1183: SELECT head_hierarchy_id
1184: INTO l_dim_hierarchy_id
1185: FROM cn_head_hierarchies
1186: WHERE head_hierarchy_id = p_RuleAttribute_rec.value_1
1187: AND org_id=p_RuleAttribute_rec.org_id;
1188:
1189: EXCEPTION