APPS.HZ_MERGE_PKG dependencies on HZ_HIERARCHY_PUB

Line 6928: l_hierarchy_rec HZ_HIERARCHY_PUB.HIERARCHY_NODE_REC_TYPE;

6924: AND effective_end_date > sysdate --bug 6696774
6925: AND level_number = 1;
6926:
6927: l_hierarchical_flag VARCHAR2(1);
6928: l_hierarchy_rec HZ_HIERARCHY_PUB.HIERARCHY_NODE_REC_TYPE;
6929: l_subject_id NUMBER;
6930: l_object_id NUMBER;
6931: l_subject_table_name VARCHAR2(30);
6932: l_object_table_name VARCHAR2(30);

Line 7031: HZ_HIERARCHY_PUB.update_link(

7027: l_hierarchy_rec.child_table_name := l_subject_table_name;
7028: l_hierarchy_rec.child_object_type := l_subject_type;
7029:
7030: END IF;
7031: HZ_HIERARCHY_PUB.update_link(
7032: p_init_msg_list => FND_API.G_FALSE,
7033: p_hierarchy_node_rec => l_hierarchy_rec,
7034: x_return_status => x_return_status,
7035: x_msg_count => l_msg_count,

Line 7074: HZ_HIERARCHY_PUB.create_link(

7070: l_hierarchy_rec.parent_id := p_to_fk_id;
7071: l_hierarchy_rec.child_id := l_subject_id;
7072: END IF;
7073: END IF;
7074: HZ_HIERARCHY_PUB.create_link(
7075: p_init_msg_list => FND_API.G_FALSE,
7076: p_hierarchy_node_rec => l_hierarchy_rec,
7077: x_return_status => l_return_status,
7078: x_msg_count => l_msg_count,