382: l_end_date DATE;
383: l_party_rel_rec RELATIONSHIP_REC_TYPE;
384: l_dummy VARCHAR2(1) := 'Y';
385: l_debug_prefix VARCHAR2(30) := '';
386: l_hierarchy_rec HZ_HIERARCHY_PUB.HIERARCHY_NODE_REC_TYPE;
387: l_parent_id NUMBER;
388: l_parent_object_type VARCHAR2(30);
389: l_parent_table_name VARCHAR2(30);
390: l_child_id NUMBER;
933: l_hierarchy_rec.relationship_id := p_relationship_rec.relationship_id;
934: l_hierarchy_rec.status := NVL(p_relationship_rec.status, 'A');
935: END IF;
936:
937: HZ_HIERARCHY_PUB.create_link(
938: p_init_msg_list => FND_API.G_FALSE,
939: p_hierarchy_node_rec => l_hierarchy_rec,
940: x_return_status => x_return_status,
941: x_msg_count => l_msg_count,
1250: l_direction_code VARCHAR2(30);
1251: l_subject_type VARCHAR2(30);
1252: l_object_type VARCHAR2(30);
1253: l_status VARCHAR2(1);
1254: l_hierarchy_rec HZ_HIERARCHY_PUB.HIERARCHY_NODE_REC_TYPE;
1255: l_allow_circular_relationships VARCHAR2(1);
1256: l_mult_parent_allowed VARCHAR2(1);
1257: l_parent_id NUMBER;
1258: l_parent_object_type VARCHAR2(30);
1968: l_hierarchy_rec.relationship_id := p_relationship_rec.relationship_id;
1969: l_hierarchy_rec.status := NVL(p_relationship_rec.status, l_status);
1970: END IF;
1971:
1972: HZ_HIERARCHY_PUB.update_link(
1973: p_init_msg_list => FND_API.G_FALSE,
1974: p_hierarchy_node_rec => l_hierarchy_rec,
1975: x_return_status => x_return_status,
1976: x_msg_count => l_msg_count,