APPS.CSE_UTIL_PKG dependencies on CSI_II_RELATIONSHIPS

Line 1242: FROM csi_ii_relationships ciir1

1238: x_return_status OUT NOCOPY VARCHAR2,
1239: x_error_message OUT NOCOPY VARCHAR2) IS
1240: CURSOR check_top_assembly(p_id IN NUMBER) IS
1241: SELECT 1
1242: FROM csi_ii_relationships ciir1
1243: WHERE ciir1.object_id = p_id
1244: AND ciir1.relationship_type_code = 'COMPONENT-OF'
1245: AND NOT EXISTS (select ciir2.subject_id
1246: from csi_ii_relationships ciir2

Line 1246: from csi_ii_relationships ciir2

1242: FROM csi_ii_relationships ciir1
1243: WHERE ciir1.object_id = p_id
1244: AND ciir1.relationship_type_code = 'COMPONENT-OF'
1245: AND NOT EXISTS (select ciir2.subject_id
1246: from csi_ii_relationships ciir2
1247: where ciir2.relationship_type_code = 'COMPONENT-OF'
1248: and ciir2.subject_id = p_id);
1249:
1250: l_dummy PLS_INTEGER;

Line 1428: csi_ii_relationships_pub.get_relationships(

1424: cse_util_pkg.write_log('Count :' || x_inst_dtls_tbl.COUNT);
1425: l_relationship_query_rec.object_id := p_instance_id ;
1426: l_relationship_query_rec.relationship_type_code := 'COMPONENT-OF';
1427:
1428: csi_ii_relationships_pub.get_relationships(
1429: p_api_version => l_api_version ,
1430: p_commit => l_commit ,
1431: p_init_msg_list => l_init_msg_list ,
1432: p_validation_level => l_validation_level ,